Established MMXXVRemote-first · Serving the US & CanadaConversions both directions
care@ezconvertbooks.com

November 16, 2026

QuickBooks Desktop memorised reports, form templates, audit trail and reconciliation reports: what to save before you convert to QuickBooks Online

The short answer: four things that bookkeepers rely on do not come across when a QuickBooks Desktop file moves to QuickBooks Online. Memorised reports must be rebuilt as custom reports, custom form templates must be rebuilt as custom form styles, and the audit trail and past reconciliation reports do not move at all. The transactions behind them do move, so nothing is lost from the books, but the evidence of how they were reviewed is. Save it from Desktop first.

The details come from Intuit’s US help article “Learn how features and data transfer from QuickBooks Desktop to QuickBooks Online” (updated 5 November 2026), its UK edition (republished in November 2026), and the US article “Move your QuickBooks Desktop company file to QuickBooks Online” (updated 5 November 2026), all read on 16 November 2026.

Rebuild vs save: the four items at a glance

Desktop itemWhat happens in the moveWhat to do before converting
Memorised reportsNot moved. Intuit maps them to custom reports, which you rebuild in QuickBooks Online.List each one with its settings, and export the year-end versions you rely on.
Custom form templates (invoices, estimates, statements)Not moved. Rebuilt as custom form styles.Print one sample of each template to PDF as the design reference.
Audit trailNot moved.Export the audit trail report for the open periods and any year still open to review.
Past reconciliation reportsNot moved. Reconciled transactions arrive marked R and cleared ones C.Intuit: “Save or print the reconciliation reports you want to keep before you move.”

The UK edition of the same page uses the same mapping, memorised and scheduled reports to custom reports and templates to custom form styles, and lists the audit trail and memorised reports among the reports that do not move.

Memorised reports: rebuild the few you use

Most Desktop files carry dozens of memorised reports, many unused for years. Do not rebuild them all. Open the memorised report list, note the five to ten your team actually runs each month or at year-end, and record for each one the date range, columns, filters and basis (cash or accrual). Then export the final year-end versions to Excel or PDF so you have the figures as they were reported.

Basis matters here. Intuit’s US page says accrual-basis reports in QuickBooks Online match your Desktop reports, while cash-basis reports may differ. If your management or tax reporting is on a cash basis, a saved Desktop copy is the only like-for-like record of what you reported. Our report test after migration shows how to compare the two once you are live.

Custom form templates: keep a picture, not the file

Desktop templates cannot be imported, so the goal is a clear reference for whoever rebuilds them as custom form styles. Print one invoice, one estimate, one statement and any other customer-facing form to PDF, with a real transaction on it so the field placement is visible. Note anything regulators or customers expect to see: tax registration numbers and wording for GST, VAT or sales tax, payment terms, bank details. Those are the fields most often missed in a rebuild.

Audit trail: export it while you still can

The audit trail records who entered, changed or deleted each transaction. It is the report an external accountant, auditor or tax inspector asks for when something looks wrong, and Intuit lists it among the items you set up again rather than transfer, which in practice means starting fresh. Export it from Desktop for at least the current financial year and any earlier year that is not yet closed, reviewed or past its query window with your tax authority, and store it with the company file backup.

QuickBooks Online keeps its own audit log from the day you start; our note on the QuickBooks Online audit log explains what it captures. It will not contain anything that happened in Desktop.

Reconciliation reports: the one Intuit tells you to save

This is the only item in the set where Intuit gives an explicit instruction: save or print the reconciliation reports you want to keep before you move. The R and C markers survive, so QuickBooks Online knows which transactions were reconciled, but the statement-by-statement reports, with their ending balances and uncleared items, do not. Save at least the last reconciliation for every bank and card account and every year-end reconciliation still within your record-keeping period. If any account’s beginning balance has already drifted, fix it before the move; see reconciliation beginning balance wrong.

Why not just keep Desktop?

Intuit says you have 90 days from signing up for QuickBooks Online to import your data, or 180 days if an accountant does it, and warns that importing into a company that already has data replaces it. The video on Intuit’s move guide refers to view-only access to the Desktop data after you cancel your subscription, for a limited period. A limited period is not a retention plan. Tax authorities set their own record-keeping periods, and those usually run for years longer than any software access window, so the saved PDFs and spreadsheets, kept alongside a final Desktop backup, are what you will rely on later.

A 30-minute pre-conversion checklist

  1. Make a final Desktop backup and store it outside the computer you are converting from.
  2. Export the audit trail for open years.
  3. Save the latest and the year-end reconciliation report for every bank and card account.
  4. Export the memorised reports you actually use, and note their settings.
  5. Print each customer-facing template to PDF.
  6. Keep everything in one dated folder with the backup.

For the full list of what does not convert, including bank feeds, users, units of measure and time-tracking data, see our guide to what doesn’t convert and the companion post on attachments.

FAQ

Do memorised reports transfer from QuickBooks Desktop to QuickBooks Online?

No. Intuit lists memorised reports as something you set up again, by rebuilding them as custom reports in QuickBooks Online. Export the ones you rely on before the move.

Does the audit trail move to QuickBooks Online?

No. The Desktop audit trail does not transfer, and QuickBooks Online’s audit log only starts once you begin working there. Export the Desktop audit trail for any year that is still open.

Do past reconciliation reports transfer?

No. Reconciled and cleared transactions keep their R and C status, but past reconciliation reports do not move. Intuit says to save or print the ones you want to keep before you convert.

Related service: QuickBooks Desktop to Online conversion

Thinking about a conversion?

Send us your details for a free, fixed-price quote within one business day.