Skip to main content

Shopify Same-Day Cancelled Orders: Accounting Treatment Explained

Which Sales Summary does this apply to?

This describes the original Shopify Sales Summary journal entry, whose document number begins with BKShopSum.

Bookkeep's newer Shopify Sales Summary entry — document number BKShopify, and the one with a Cancel Reversals line — has no same-day rule and handles cancellations differently. Skip to On the newer Sales Summary entry below.

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

On the newer Sales Summary entry​

Bookkeep's newer Shopify Sales Summary entry — document number BKShopify — handles cancellations differently, and the rules above do not apply to it.

There is no same-day rule. Every cancelled order that ends up with no net payment is handled, no matter how long after it was placed that the cancellation happened. "No net payment" means either nothing was ever collected, or everything collected was refunded.

The order stays on your P&L. Gross Sales, Discounts, Returns and Shipping Income are untouched, so they match Shopify's Finances Summary. Only two things change:

  • Sales tax comes back out, so you do not remit tax on an order that collected none. This is the one line that will differ from Shopify's report.
  • The rest of the reversal posts to Cancel Reversals, offset inside Other Receivables, so accounts receivable closes on the day of the cancellation.

The practical difference from the original entry is what happens to your top line. On the original entry the order disappears and your sales read lower than Shopify's. On the newer entry your sales match Shopify's, and only the tax line differs.

For the full picture, see Matching Your Shopify Sales Summary to Shopify's Finances Summary.