LedgerClearLedgerClear

Fix guide

How to export QuickBooks transactions to CSV for reconciliation

The QuickBooks side of a Shopify reconciliation is one well-configured report export. QuickBooks Online can hand you every transaction your sync posted - with dates, amounts, tax, and the reference that ties each transaction back to its Shopify order - but the default reports aren't shaped for it, and the wrong export quietly omits the columns that make matching possible.

This guide produces that export using nothing but QBO itself. Pair it with our Shopify orders export guide and you have both sides of the diff; the manual reconciliation guide walks the comparison itself.

The symptoms

  • You have (or are building) a Shopify export and need the QuickBooks side to compare against
  • You want to see exactly what your sync posted, not what its dashboard claims
  • Your accountant asked for the sales transactions behind a period before filing
  • You suspect duplicates or gaps and want the raw list to check

Why it happens

Why the transaction type matters

Different syncs post different transaction types: sales receipts, invoices plus payments, or journal entries. Export the type your sync actually creates, or your report will be empty or partial. If you're not sure, open one recent Shopify-originated transaction in QBO and note its type - that's the type to filter for.

Why the reference column is everything

Most syncs stamp the Shopify order number (or a derivative) into a field on each transaction - memo, message, or document number. That column is what lets you match line by line instead of guessing by amount and date. An export without it turns reconciliation into archaeology.

How to check and fix it by hand

  1. 01

    Run the Transaction List by Date report

    QBO → Reports → 'Transaction List by Date'. Set the date range to your reconciliation period plus about five business days on each side, matching the buffer on your Shopify export so settlement timing doesn't create false gaps.

  2. 02

    Filter to the sync's transactions

    Customize → Filter → Transaction Type: select the type(s) your sync posts (commonly Sales Receipt; also Refund Receipt or Credit Memo for refunds, Invoice/Payment or Journal Entry for other setups). If your sync posts to a specific clearing or income account, filtering by that account instead is often the cleanest way to isolate Shopify activity from everything else in the ledger.

  3. 03

    Add the matching columns

    Customize → Rows/Columns: include Date, Transaction Type, Num, Memo/Description, Amount, and the tax column your report offers. Num and Memo are where syncs stamp the order reference - check one known transaction to confirm which field carries it. Then use the report's Export → Export to Excel (save as CSV) rather than copying from the screen.

  4. 04

    Sanity-check and pair with the Shopify side

    Confirm the transaction count is plausible against the period's order count, spot-check three transactions against their Shopify orders, and verify the reference column populated. Then run the comparison - by hand with our manual reconciliation guide, or upload both CSVs to LedgerClear's free scan and get the line-by-line diff, with findings tiered by confidence, in about a minute.

Common questions

Which QuickBooks report exports the transactions a sync posted?
'Transaction List by Date', filtered to the transaction type your sync creates (or to the clearing/income account it posts to), with Num and Memo columns added so the Shopify order reference comes along. Export to Excel/CSV from the report toolbar.
My export has no order numbers - how do I match transactions to orders?
Check a known transaction to find where your sync stamps the reference (Num, Memo, or Message fields differ by sync), then re-run the report with that column added. If your sync stamps nothing, matching falls back to amount + date, which is workable but slower and less certain.
Do refunds come out in the same export?
Only if you include their transaction type (Refund Receipt or Credit Memo, depending on the sync). Include them - unmatched refunds are one of the most common findings in a Shopify-QBO diff, and an export that omits them can't surface the gap.

LedgerClear doesn’t replace your sync. It audits per-order syncs today - the official connector and Synder. Summary-posting tools like A2X and Link My Books: auditing support is coming later, and LedgerClear runs alongside them without touching their entries. If the right answer for you is switching tools, the scan report is the damage report to migrate with.