Guides
Practical, step-by-step guides for getting bank statement data where it needs to go.
Getting the data where it needs to go
Import a bank CSV into QuickBooks Online
The exact column format QuickBooks expects, upload steps, and common errors.
Import a bank CSV into Xero
Date/Amount/Payee/Description format, upload steps, and the region date-format trap.
Clean up bank statement data in Excel
Fix text-formatted numbers, ambiguous dates, split debit/credit, remove duplicates and categorize.
Preparing statements for a filing deadline
Bank statements for US tax season
The December cutoff that decides which tax year a transaction lands in, mixed business and personal accounts, and how long to keep the file.
Bank statements for UK Self Assessment
Why a 6 April to 5 April year cuts two statement months in half, which accounts and interest are in scope, and the Paid In / Paid Out problem.
Bank statements for ITR filing
Which months FY 2025-26 needs, unlocking an encrypted statement PDF, and checking interest against what was already reported for you.