A line-by-line guide to reconciling Bookkeep's Shopify Sales Summary journal entry against Shopify's Finances Summary report, including the handful of lines that are expected to differ and exactly why.
Understand the Shopify AR Aging report in Bookkeep: every Shopify order with an outstanding accounts receivable balance as of a date you choose, with per-order deferred revenue, deferred discounts, Shopify Payments, and refunds payable balances that tie to Bookkeep's ledger.
Understand the Shopify AR Movement report in Bookkeep: an accounts receivable roll-forward for any period — beginning balance plus increases minus decreases equals ending balance — bucketed by order creation month, with per-order drill-down and CSV export.
Understand the Shopify Channel Coverage report in Bookkeep: every sales channel, app, and POS location your Shopify store could be segmented on, whether an active segment maps it, and the net sales and shipping Shopify itself recorded on it over a date range — so revenue with no journal entry is visible before you close the books.
Understand the Shopify Fulfilled Line Items report in Bookkeep: line-item detail of gross sales, discounts, and cost of goods sold for Shopify fulfillments in a chosen date window, with returns and adjustments, shipped versus delivered totals, and full CSV export.
Understand the Shopify Payments Reporting dashboard in Bookkeep: payouts in transit and undeposited orders as of a chosen date, per-payout and per-sales-date breakdowns, order-level drill-downs, and a QuickBooks balance card that compares the books to what Shopify still owes you.
Understand the Shopify Unfulfilled Line Items report in Bookkeep: see every order line item sold on or before a chosen date that had not yet been fulfilled as of that date, with sales amounts, order payment totals, and as-of received and refunded figures that support deferred revenue verification.
Understand the Template Reconciliation report in Bookkeep: every journal entry line for a date range rolled up by account type across all of your connections and templates, with a net total per account type, a balance check, the days each connection is missing an entry, and a flat CSV export built for spreadsheets and AI tools.