Shopify Same-Day Cancelled Orders: Accounting Treatment Explained | Build with Bookkeep

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:

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:

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

Summary

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