Skip to main content

Tracking and Managing Shopify Orders, Refunds, and Cancellations

Learn when Shopify sales, cost of goods sold (COGS), refunds and cancellations are recorded on cash or accrual basis, and how to settle open orders with order actions and sales channel statuses.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, Margins

Finaloop connects directly to Shopify so your orders, refunds, cancellations, and receivables flow automatically into your books.

Use this guide to see how Shopify orders are recorded in Finaloop, how refunds and returns work, what happens when an order is cancelled, and how to manage your open or unpaid orders on the Orders page (Customers → Orders).

In Margins, Finaloop's performance analytics product, Orders is in the main menu and shows the All orders and Sales channels tabs. Sales channel statuses and order actions (except Link payment) work the same way in Margins. The accounting sections (cash and accrual basis, revenue recognition, A/R) apply only to Finaloop Accounting.


1. Your revenue recognition timing

Before diving into how your Shopify orders flow into Finaloop, let's understand when your Shopify revenue gets recognized in your books. Revenue recognition timing affects how your orders, refunds and cancellations are recorded, so it's important to understand upfront.

The exact timing of your revenue recognition depends on whether you use cash or accrual basis, but your fulfillment data is a key factor that impacts the timing of your sales recognition (accrual only) and cost of goods sold (COGS) recognition (cash and accrual).

For most sales channels like Amazon and TikTok Shop, Finaloop syncs fulfillment data automatically and uses the actual fulfillment date to determine your revenue recognition timing. Shopify is different. Many brands don't consistently update fulfillment statuses in Shopify, so that data is often incomplete, delayed, or missing. To handle this, Finaloop gives you two options for how revenue is recognized for Shopify orders.

You can choose your method under Customers → Orders → Settings → Revenue recognition. If you also sell on marketplaces, click Shopify first.

Option

How it works

Who should use it

Fulfillment date (recommended)

Revenue is recognized on the date the order is marked as fulfilled in Shopify

Brands who consistently update fulfillment statuses in Shopify

Order date (default)

Revenue is recognized on the date the order is placed in Shopify

Brands whose Shopify fulfillment data is incomplete or inconsistent

To use a different method for different years or stores, turn on Use different methods for different years or Shopify stores. Years whose books are closed can't be changed.

The Revenue recognition setting affects how sales are recorded, how refunds are treated, and how cancellations are handled.

Inventory tracking:

  • Dropshipping: Shopify fulfillment details are always used to track warehouses for dropshipped orders, regardless of your revenue recognition setting.

  • Non-dropshipping:

    • Order date: Finaloop uses your default warehouse settings (Inventory settings → Warehouses) to reduce inventory when an order is placed.

    • Fulfillment date: Finaloop uses Shopify's fulfillment data to reduce inventory from the relevant warehouses when an order is fulfilled.

Learn more under "Incorrect warehouse settings" in InventoryIQ Troubleshooting.


2. How Shopify orders flow into Finaloop

Here's how revenue recognition plays out step by step, depending on your accounting basis.

Cash basis

How it works:

  • Sales: Recorded when payment is collected, not when the order is placed or fulfilled.

  • COGS: Recorded based on your Revenue recognition setting (Order date or Fulfillment date).

Because sales and COGS follow different triggers on cash basis, timing differences between the two are normal.

Step-by-step order flow:

  1. Order placed in Shopify. The order appears on your Orders page but has no impact on your Profit & Loss or Balance Sheet. On cash basis, unpaid orders don't create Accounts Receivable. If you use Order date for revenue recognition, COGS are recorded when the order is placed, even before sales are recorded.

  2. Payment received from customer. Payments can be received through a payment processor (online payment) or through an offline channel, like cash, ACH, or check. How the payment comes in determines what happens next:

    • Online payment: Sales, discounts, shipping income, tips, and taxes hit your P&L on the payment date. Finaloop matches the payment to the order automatically.

    • Offline payment (ACH, check, cash) or marked as unpaid in Shopify: The order shows as Unpaid on your Orders page until you link the payment to the order (see Link payment under Order actions). Alternatively, categorize the deposit on the Transactions page as Cash payment received for Shopify orders. This keeps your numbers accurate, but won't mark the specific order as Paid on your Orders page, making it harder to track real unpaid orders.

  3. Order fulfilled. If you use Fulfillment date for revenue recognition, COGS are recorded when the order is marked as fulfilled in Shopify.


Accrual basis

How it works:

  • Sales and COGS: Recorded based on your Revenue recognition setting (Order date or Fulfillment date), even if payment hasn't been received yet.

Step-by-step order flow:

  1. Order placed in Shopify.

    • Deferred revenue is created on your Balance Sheet. This is a liability representing money received for services or products not yet delivered.

    • An open balance appears in your Accounts receivable (A/R) - Shopify account.

    • If you use Order date for revenue recognition, Finaloop immediately recognizes sales, shipping income, discounts, and tips, reduces deferred revenue, and records COGS and reduces inventory.

  2. Payment received from customer. Payments can be received through a payment processor (online payment) or through an offline channel, like cash, ACH, or check. How the payment comes in determines what happens next:

    • Online payment: Finaloop automatically marks the order as Paid (or Partially paid) and matches the payment to the order, reducing your Accounts receivable (A/R) - Shopify balance.

    • Offline payment (ACH, check, cash), or marked as unpaid in Shopify: The order stays Unpaid until you link the payment to the order (see Link payment under Order actions). This reduces your Accounts receivable (A/R) - Shopify balance. Alternatively, categorize the deposit on the Transactions page as Cash payment received for Shopify orders. This reduces your net A/R through the Cash payments received for store orders account. This keeps your numbers accurate, but won't mark the specific order as Paid on your Orders page, making it harder to track real unpaid orders.

  3. Order fulfilled. If you use Fulfillment date for revenue recognition, Finaloop recognizes sales, shipping income, discounts, and tips, reduces deferred revenue, and records COGS and reduces inventory.

The Balance Sheet with the Accounts receivable (A/R) - cash orders and Cash payments received for store orders rows.

① Accounts receivable (A/R) - cash orders (unpaid Shopify orders), ② Cash payments received for store orders.

To learn more about how we sync your Shopify numbers, check out Finaloop's Shopify Integration Deep-Dive


Why you might see a Reconciliation in process balance

When an order is marked as Paid, you may notice a temporary balance in a Balance Sheet account called Reconciliation in process. This is normal. It's a holding account that bridges the timing gap between when a sale or refund is recorded and when the actual payment arrives. It zeros out automatically as payments are reconciled.

Here's the flow:

  1. Order marked as paid in Shopify: the Reconciliation in process balance increases.

  2. Actual payment received: the Reconciliation in process balance decreases, zeroing itself out over time.

  3. Undeposited funds for that payment processor increases, until the money lands in your bank.


3. Refunds, returns, and cancelled orders

Flowchart of how a Shopify refund or cancellation is recorded: voided, a refund in the P&L, or reduced deferred revenue, by payment and basis.

How it works:

  1. Not paid: The order is voided and removed from your books entirely.

  2. Paid, and the sale was already recorded (based on your accounting method and revenue recognition setting): A new entry appears in Refunds & returns in your P&L. The original sale stays intact.

  3. Paid, but the sale wasn't recorded yet (accrual with Fulfillment date only): Deferred revenue is reduced on your Balance Sheet. No P&L impact.

Refunds and cancellations initiated in Shopify: cash basis

If an order is cancelled in Shopify before payment:

  • The cancelled order is marked as Voided in Finaloop and doesn't impact your books.

If an order is refunded or cancelled in Shopify after payment:

  • Using cash basis, a sale is recognized at the time of payment.

  • Since the order was both paid and the sale was already recorded in Finaloop, a refund or cancellation will not reverse the sale (it won't have an impact on your gross sales). Instead, a refund payment will increase your Refunds & returns account in your P&L for the net refund amount. The other accounts in your P&L will not be impacted.

  • On cash basis, this treatment is the same whether the order was refunded or cancelled before or after the items were fulfilled. This is why even cancelled orders can still appear in your Refunds & returns account.

Note: Refunds and returns don't impact COGS unless an item is marked as "Restocked" in Shopify or is updated manually in Finaloop. Learn more in Reporting inventory restocks.


Refunds and cancellations initiated in Shopify: accrual basis

If an order is cancelled in Shopify before payment:

  • The cancelled order is marked as Voided in Finaloop and doesn't impact your books.

If an order is refunded or cancelled in Shopify after payment:

Using accrual basis, sales are recorded on the fulfillment date or the order date, depending on the method selected in your revenue recognition settings. Because of this, the way refunds, cancellations, or reversals are treated depends on the revenue recognition method you selected.

  • Fulfillment date method:

    • Cancellation or refund after payment, before the fulfilled date: Since this order was not yet recorded as sales in your P&L, we reverse the order from Deferred revenue with no actual refund recorded, so there's no impact on your P&L.

    • Cancellation or refund after payment and the fulfilled date: Since the sale was already recorded in your P&L, a refund will not reverse or cancel the order and won't have an impact on your gross sales. Instead, a refund payment will increase your Refunds & returns account in your P&L for the net refund amount. The other accounts in your P&L will not be impacted. This is why cancelled orders can appear in your Refunds & returns account, depending on when the order was cancelled.

  • Order date method:

    • Sales are recorded almost immediately, when the order is placed.

    • Since sales are already recorded, a refund or cancellation won't reverse or cancel the order and won't have an impact on your gross sales.

    • Instead, a refund payment will increase your Refunds & returns account in your P&L for the net refund amount. The other accounts in your P&L will not be impacted.

    • This is why cancelled orders can appear in your Refunds & returns account, depending on when the order was cancelled.

    • With the Order date method, this treatment is the same whether the order was refunded before or after the items were physically fulfilled.

Note: Refunds and returns don't impact COGS unless an item is marked as "Restocked" in Shopify or is updated manually in Finaloop. Learn more in Reporting inventory restocks.


Returns and restocked inventory


Exchanges

  • Unlike returns, where everything is handled within the original order, in exchanges you both mark a return on the original order and create a new order for the replacement.

  • In this case, make sure whoever handles the exchange manages it correctly in Shopify:

    • A return on the original order (and restock if needed); and

    • A new order for the replacement.

  • If you use tools like Loop or Redo, exchanges typically create a new $0 order in Shopify (an order with a 100% discount applied). We exclude those sales channels from your sales so your sales aren't overstated.

  • Instead, we treat it as a COGS only order (see Finaloop status under Status summary) and pick up any additional sales related to upsells from the payment processor data. You can view the settings for your specific sales channels under Customers → Orders → Settings → Sales channels.


Handling refunds with open balances in Finaloop

If a refund was accepted in Shopify but the order still shows open in Finaloop, use Close over-collected balance to close it out (see Order actions). This usually happens if a return wasn't initiated in Shopify for the order, despite the refunded payment.


4. Actions in Finaloop

Sometimes Shopify data doesn't tell the full story. That's where Finaloop's order actions come in, letting you adjust open orders so your A/R and books stay clean.

These changes can be applied by changing the status of a sales channel or of an order in Finaloop.

Channel actions

If you use a non-Shopify sales channel, marketplace, or app that is the source of orders but is connected to Shopify, such as TikTok Shop, Faire, Amazon, Loop Returns, and others, you can choose how all orders from that channel are treated with a channel status, such as Included, Excluded or COGS only. You set it under Customers → Orders → Settings → Sales channels. For each status and the steps, see Choosing which Shopify sales count as revenue.


Order actions

Sometimes your unpaid or open orders need to be updated if their Shopify data doesn't reflect the most accurate information.

You can also check out this video, "Manage your Account Receivable account", to learn more:

It's important to periodically review the Orders awaiting input tab on your Orders page. It shows all the unpaid orders, partially paid orders, orders marked as manually paid in Shopify, and overpaid orders, so you can keep this number in line with:

  • Offline payments for orders that weren't linked

  • Orders that should be voided

  • Over-collected or uncollected balances that should be closed

  • Orders that won't be paid, such as product giveaways, replacements, or exchanges

  • Orders that were historically paid before you started tracking your books in Finaloop

In Finaloop, we offer various actions that you can apply to a single order, or up to 250 orders at once, to update your A/R balance and your order status.

The Actions drawer on the Orders page listing the order actions, from Link payment through Mark as COGS only.

① Actions, ② Mark as historically paid.

To view your unpaid orders, go to Customers → Orders and click the Orders awaiting input tab. Select the relevant order or orders, click Actions, and choose any of the following actions to keep your unpaid balance updated. To reverse an action, open the same drawer and click Undo (or Edit) next to it.

  1. Link payment

    • If the order payment was already received in your bank account, you can link the order(s) to the specific payment(s) from your bank transactions.

    • Select the relevant order(s), click Actions, then Link payment.

    • If the amounts don't match exactly, you can split payments and add only part of the order amount, or add expenses like discounts or FX commission to the link.

  2. Void

    • When you mark an order as void, it doesn't impact your books at all. It's as if it never happened for financial purposes, although you will still see it on the Orders page.

    • Select the relevant order(s), click Actions, then Void.

    • If you see an order with a Voided status, this can be because you marked it as void or because of the void status we synced from Shopify. If the Voided tag has a small Finaloop logo (Set by Finaloop), it was marked as void in Finaloop.

  3. Close uncollected balance

    • If you have an order that will likely never be paid, you can close this uncollected balance by selecting the order(s), clicking Actions and selecting Close uncollected balance.

    • This will close your open balance for this order and create a bad debt expense in your P&L.

  4. Close over-collected balance

    • Sometimes, a customer may overpay you for an order. For example, if a refund was initiated for an order, or an item in the order was cancelled, but payment was already collected and no return was issued for this item in Shopify. Another example is if you accidentally charged the customer twice for the same order but never issued a refund. When this happens, it creates a negative order balance, which also impacts your A/R balance.

    • If you over-collected from a customer but don't plan to refund them, this should increase your sales income in your P&L and be removed from your A/R balance.

    • To close this order and make sure it's properly shown in your books, select the order(s), click Actions and select Close over-collected balance. This will increase your sales by the over-collected amount and close the open order on the date of the last activity in this order.

  5. Mark as historically paid

    • Use this if the payment for an order was made before your books started in Finaloop, or in a period that's already closed, so you can't link it to the order.

    • Select the order(s), click Actions and select Mark as historically paid. This reduces the order's unpaid balance.

  6. Mark as giveaway

    • If an order is related to influencer collaborations, giveaways, or product samples, mark it as a giveaway. This records the product cost as a marketing expense (under the Product giveaways line) in your operating expenses instead of COGS, and excludes any sales revenue or discounts relating to the order from A/R.

  7. Mark as COGS only

    • A COGS only order doesn't impact your sales, discounts, or other sales metrics. Only the COGS expense for that order impacts your books.

    • This can be due to the channel being treated as COGS only, or to a specific order, for example a replacement, warranty, or exchange order.


5. Status summary

These are the statuses you'll see on your Orders page and what each one does to your books.

Payment status

Status

What it means

Cash basis treatment

Accrual basis treatment

Paid / Partially paid

Online: the order's payment and payment processor show in Shopify. Offline: the payment was linked manually in Finaloop.

The order becomes Sales when paid.

Online: reduces A/R and increases Undeposited funds. Offline: reduces A/R and decreases the account the payment was previously categorized into (for example, Uncategorized transactions - money received).

Unpaid

The payment in Shopify is offline, manual, cash or unknown, or the order is unpaid in Shopify.

Not included in your books until a payment is linked to the order.

Included in A/R until a payment is linked to the order.

Refunded / Partially refunded

The payment was refunded by the payment processor after the sale was recognized in Finaloop, whether you use Order date or Fulfillment date. A refund sent offline won't show here. If the order was cancelled and refunded before payment was received, see Voided under Finaloop status.

When the refund is paid: increases Refunds & returns in your P&L for the net sales price and reduces Undeposited funds. No COGS impact unless an item is marked as restocked in Shopify.

After the sale was recognized: increases Refunds & returns in your P&L for the net sales price and reduces Undeposited funds. Before the sale was recognized (Fulfillment date only): reduces Deferred revenue and Undeposited funds. No COGS impact unless an item is marked as restocked in Shopify.


Fulfillment status

Status

What it means

Cash basis treatment

Accrual basis treatment

Fulfilled / Partially fulfilled

Order date: items are marked as fulfilled on the date the order was placed; no partially fulfilled or unfulfilled status applies. Fulfillment date: the status becomes fulfilled on the "Posted At" date in Shopify, which is the date the fulfillment was created.

Order date: no impact on your books when an order is fulfilled. Fulfillment date: increases COGS and decreases Inventory.

Order date: no impact on your books when an order is fulfilled. Fulfillment date: increases sales, discounts, shipping income, tip income and COGS, and reduces Deferred revenue and Inventory.

Unfulfilled

Reflects what happened in Shopify, not your revenue recognition method. It only affects your books if you use Fulfillment date and Shopify shows no fulfillment date.

Fulfillment date: no COGS or Inventory adjustment recognized yet.

Fulfillment date: no sales, COGS or Inventory adjustment recognized yet. Sales income stays in Deferred revenue.

Restocked / Partially restocked

The order is marked as restocked in Shopify. A refund doesn't automatically restock items; mark the restock in Shopify manually or through your 3PL's integration with Shopify. You can also report restocks in Finaloop, but these won't show on your Orders page.

Reduces COGS and increases Inventory for the restocked amount.

Reduces COGS and increases Inventory for the restocked amount.


Finaloop status

Status

What it means

Cash basis treatment

Accrual basis treatment

Excluded

Orders synced from a sales channel connected to Shopify that's set to Excluded in Finaloop, by you or by Finaloop as a default (see Channel actions).

Excluded completely from your books.

Excluded completely from your books.

Voided

Orders you marked as void in Finaloop, orders marked as void in Shopify (for example, the payment was cancelled before capture, so no money moved), or orders cancelled in Shopify with no payment.

Any impact is fully reversed from your books, as if it never happened.

Any impact is fully reversed from your books, as if it never happened.

Giveaway

Orders marked as a giveaway in Finaloop.

Sales are excluded. Increases the Product giveaways marketing expense for the COGS amount and decreases Inventory.

Sales are excluded. Increases the Product giveaways marketing expense for the COGS amount and decreases Inventory.

COGS only

Orders you marked as COGS only, or orders from channels set to COGS only.

Sales are excluded. Increases COGS and decreases Inventory.

Sales are excluded. Increases COGS and decreases Inventory.

Uncollectible

Orders you closed with Close uncollected balance because you don't expect to collect the open balance.

Not relevant (sales are only included upon payment).

Reduces A/R and increases Bad debt.

Over collected

Orders you closed with Close over-collected balance because they had a negative balance you don't plan to refund (for example, a refund was initiated but no refund was issued, or a customer was charged twice and not refunded).

Not relevant (sales are automatically increased upon payment).

Increases sales by the over-collected amount and increases A/R by reversing the negative amount, on the date of the order's latest activity, as this is most likely when it became negative.


6. Shopify order FAQs

Do refunds change my COGS?

No. Refunds have no impact on COGS. COGS only updates if the item is marked as restocked in Shopify or manually updated in Finaloop.


Why does a cancelled order show up as a return in my P&L?

This happens when an order was cancelled after payment was already collected. Because payment makes it a paid order, Finaloop treats the cancellation as a refund rather than a void, so both the original sale and the refund appear in your P&L. The net impact is the same either way. If the order was cancelled before payment, it would be voided and nothing would appear in your P&L.


What's the difference between Voided and Cancelled?

In Finaloop, Voided means the order has no financial footprint. It's removed from your books entirely, as if it never happened. This always happens when an order is cancelled while unpaid.

Cancelled in Shopify doesn't automatically mean voided in Finaloop. If the order was already paid when it was cancelled, it's treated as a refund, and both the original sale and the refund are visible in your P&L.


Why is there still an open balance on an order I already refunded?

This usually happens when the refund was processed in Shopify but a return wasn't initiated there for the order. Finaloop still sees it as open. To close it, select the order and use Close over-collected balance. See "Handling refunds with open balances in Finaloop" for more detail.


My refund amount in Finaloop doesn't match what I refunded in Shopify. Why?

Finaloop records the net refund payment amount, exactly what was refunded. If the number still looks off, check whether the refund was processed through an online payment processor (Finaloop picks this up automatically) or offline (which needs to be linked manually). Offline refunds won't appear as Refunded on your Orders page.


If I switch my revenue recognition setting, does it affect my historical data?

It can impact your data for any open years. Switching typically takes about 24 hours to process; then you can switch again. Years whose books are closed can't be changed.


Why do I see a Reconciliation in process balance on my Balance Sheet?

This is normal. Reconciliation in process is a temporary holding account that bridges the timing gap between when a payment is recorded and when it actually arrives. It zeros out automatically as payments are reconciled. See "Why you might see a Reconciliation in process balance" for a full explanation of how it flows.


Related articles


Need help?

If you have any questions about your Shopify orders, just reach out to us at [email protected].

Did this answer your question?