Skip to main content

Managing Dropshipping (InventoryIQ)

Learn how to setup and manage dropshipping if you are using InventoryIQ

Written by Rayla Rappaport
Updated over 3 months ago

About

If you sell through dropshipping, your customers place orders in your store, but the products are stored, packed, and shipped by your vendor or third-party supplier, not by you.

Since these items never pass through your own warehouse, they need to be tracked differently in your books.

As part of setting up your InventoryIQ setup, we’ll ask whether you use dropshipping.

If you select Yes, you’ll go through a short guided setup to identify your dropshipping warehouses, vendors, and payment terms, so Finaloop can set up your accounting for these orders.


1. InventoryIQ dropshipping overview

To get an overview of how we support dropshipping sales, check out this quick video:


2. How we manage your dropshipping

During setup, we’ll ask a few quick questions to determine which solution best fits your business and how we should set up your dropshipping in Finaloop.

Based on your answers in the guided setup, we’ll automatically choose the best way to track your dropshipping orders and payments.

There are two ways we can manage your dropshipping COGS:

Option 1: Based on dropshipping payment transactions or bills

With this method, Finaloop tracks dropshipping costs based on vendor payments or bills. When we detect a dropshipping payment (via a bank transaction or bill), we record it directly as COGS on your P&L on the transaction date.

Because the cost is already recorded:

  • For orders marked as dropshipping, we do not calculate COGS again when the order is fulfilled

  • This avoids double counting

  • Your COGS and inventory remain accurate with no additional work required

Note: Since costs are recorded at the payment level, dropshipping COGS are not broken down by product when using this method.


Option 2: Based on dropshipping landed costs per unit

With this method, Finaloop calculates COGS using the landed cost of each dropshipping fulfillment.

When Finaloop detects a Shopify order was fulfilled from a dropshipping warehouse, you identified during setup (see below), we’ll automatically create a dropshipping purchase order (PO) for that order using the vendor and cost details available in our system.

If data is missing:

If we don’t have vendor or cost information for the product fulfilled, we’ll create a draft PO instead. Once you add the missing details, the PO and related COGS will automatically update.

You can find these POs here:

Inventory>Purchases>Purchase Orders tab>Dropshipping POs tab.

Click into any draft PO to add or adjust the vendor and cost details. This method allows you to:

  • Use precise landed costs per unit

  • Track different costs per fulfillment method

  • Keep COGS and the balance with your dropshipping vendors as accurate as possible

While this method requires a bit more input, it produces the most precise COGS results.

Adding dropshipping adjustments:

Sometimes, dropshipping bills or payments don’t exactly match the costs on the dropshipping POs. This can occur if the PO is based on an average cost rather than the exact cost for that PO shipment. In these cases, if there is a small gap you can add an adjustment to close the gap and align your vendor balance with the actual balance.

Note: If a larger gap exists between your dropshipping bills and payments and your dropshipping POs, we recommend editing the PO at the source rather than adding a dropshipping adjustment.

How to add a dropshipping adjustment:

  1. Go to Inventory > Purchases > Vendors

  2. Search for the relevant dropshipping vendor

  3. Click + Adjustment

  4. Enter the adjustment amount

  5. Click Save

Optional: You can also link relevant dropshipping bills and payments to the corresponding POs and adjustments.


Viewing and updating COGS by product

No matter which method you use, you can always track dropshipping activity by product.

To view dropshipping products:

  1. Go to Inventory>Products.

  2. Click Filter and select Dropshipping.

  3. Click into any dropshipping product

  4. Go to the COGS tab for that product.

On the COGS tab you’ll see all sales channels, including dropshipping, where you can track:

  • Units fulfilled and restocked

  • Average cost per unit

  • Total COGS for this sales channel.

Note: If you track dropshipping using Option 1 (based on dropshipping payments or bills), the cost and COGS for this product will show as $0.00, since costs are tracked at the payment level rather than per SKU.

Missing data on dropshipping POs:

If any automatically created dropshipping POs are missing required information, you’ll see a Missing data badge.

Click the badge to:

  • View all dropshipping POs related to that product

  • Edit any draft POs

  • Add missing vendor or cost details

After saving, you can choose whether to:

  • Apply the cost only to the current PO, or

  • Apply it to future dropshipping POs for this product

Your COGS will update automatically.


3. Setting up dropshipping in Finaloop

We'll walk you through a guided setup, asking the following questions. Based on the answers, we'll automatically select the right option for your business.

3.1. Select your dropshipping warehouses

We automatically sync your warehouses from Shopify. Choose the ones used for dropshipping fulfillment and (not your own inventory).

Select all relevant warehouses. Any order marked as fulfilled in Shopify from these warehouses will automatically be treated by Finaloop as dropshipping and COGS will be recorded based on your dropshipping method.

3.2. Set your dropshipping vendor rules

Next, Finaloop automatically detects vendors categorized (either by you or automatically) as dropshipping vendors.

Review the list and:

  • Confirm all your dropshipping vendors are included

  • Add any missing vendors if needed.

Once saved, Finaloop automatically classifies all transactions tied to those vendors as Dropshipping.

3.3. Clarify payment terms & bills

Finally, we’ll ask about your payment terms with your vendors. Some vendors require immediate payment, while others allow you to pay some days after the order.

If a vendor gives you 3 or more days to pay, select Yes. If not, select No.

If you select Yes, you’ll also be asked on average, how many dropshipping bills or payments do you have per month.

Your answer helps us choose the dropshipping method that best aligns your expense timing with your payment terms, while keeping your manual work to a minimum.


4. Changing your dropshipping setup

If you ever want to switch between the two methods, contact Finaloop Support via chat or email. Our team can update your configuration to match the way you manage your dropshipping operations.

Need Help?

Contact our Support team anytime through chat or at support@finaloop.com.

Did this answer your question?