Skip to content

QuickBooks & Xero / File guide

The right files.
A useful result.

Keep each run to one client. Choose the files for the task below.

Sample report
QuickBooksExample Store 0142

Example Store 0142

Transaction detail

Checking · October 2026 · USD

Account: Checking01–31 Oct 2026Sample CSV
Three sample rows from the October ledger
DateDescriptionAmount
03 OctCard settlementDEP-1001$4,655.00
05 OctStore rentRENT-10−$1,800.00
28 OctRepair checkCHK-1048−$300.00

3 example rows shown. Download the sample CSV for all activity.

These examples show which fields to include in your reports. Menu names and export options may differ in your version of the software.

01 / You provide

Choose your task.

  • Transaction CategorizationHistorical transactions and your custom chart of accounts. Approved rules, account mappings and previously reviewed coding are optional supporting evidence.
  • Bank Statement to SpreadsheetA text-readable bank or card statement. Include every page.
  • Receipt MatchingA transaction export and the receipts or invoices to compare. Select up to 20 PDF, PNG or JPG documents.
  • Bank Rule FinderSeveral months of reviewed transaction history from one business. Keep the original descriptions, final categories, dates, direction, account and currency. Existing rules and the chart of accounts are optional.

Include references and account identifiers. For uncleared items, state the report cutoff; a transaction date alone does not establish when an item was open.

02 / Your review pack

A workpaper you can follow.

  • The prepared scheduleStructured transactions, proposed account categories, receipt matches or proposed recurring rules, depending on the tool.
  • Source referencesThe file, page or row behind each finding, with ambiguous and unreadable records kept visible.
  • Next actionsMissing documents, conflicting matches and the questions needed to finish the review.

Download an Excel workbook. Review it before adding rules, attaching receipts or changing entries in QuickBooks or Xero.

See the handoff in action

See what comes back.

Each tool includes sample files and results.

Clorse is independent of Intuit and Xero.