Skip to main content

Shopify Same-Day Cancelled Orders: Accounting Treatment Explained

Overview​

For Bookkeep's Shopify automation, Bookkeep automatically excludes orders that are cancelled on the same day they are created when no payment has been captured on the order.

This behavior is intentional and designed to ensure accurate financial reporting and prevent overstating sales, tax liability, and accounts receivable.

How Bookkeep Handles Same-Day Cancelled Orders​

Bookkeep will ignore orders that meet all of the following conditions:

  • The order was cancelled on the same day it was created

  • The order has no successful payment recorded

If a payment has been captured, the order will still be included in Bookkeep’s accounting entries (even if cancelled), because funds movement has occurred and must be accounted for.

Why These Orders Are Excluded​

Same-day cancelled and unpaid orders are excluded for several important accounting reasons:

1. Preventing Overstatement of Sales and Revenue​

Including unpaid, cancelled orders would inflate gross sales figures even though no economic transaction occurred.

2. Avoiding Overpayment of Sales Tax​

If these orders were included, tax reporting would reflect liabilities for transactions that were never actually completed or collected, potentially causing businesses to overpay sales tax to authorities.

3. Preventing False Accounts Receivable​

These orders would incorrectly appear as outstanding receivables. Since they are cancelled and never paid, they would never convert into cash, leading to inflated AR balances that do not reflect reality.

Important Note About Shopify Finance Summary​

The Shopify Finance Summary does include these same-day cancelled orders, even if no payment was captured.

This creates an important discrepancy:

  • Shopify Finance Summary → includes cancelled, unpaid orders

  • Bookkeep → excludes cancelled, unpaid same-day orders

As a result, if you are manually recording accounting entries based solely on the Shopify Finance Summary, you may:

  • Overstate sales

  • Overstate tax collected

  • Overstate accounts receivable

Summary​

This logic is a deliberate accounting safeguard in Bookkeep’s Shopify integration. It ensures:

  • Sales reflect only economically valid transactions

  • Tax liabilities are not overstated

  • Accounts receivable remains accurate