Check a client’s MTD quarter before you submit it
Drop in a bank export or a client’s spreadsheet. The checker keeps only what belongs in the quarter, sets aside personal and non-business items, and totals the rest by HMRC category.
- 01Pick the quarter
- 02Add the records
- 03Clear the flagged rows and copy the totals
Add the client’s transactions
Paste rows instead
Columns
Totals by HMRC category
Review rows
| Date | Description | Amount | HMRC category | Count | Status |
|---|
Rows dated outside the quarter are set aside, using standard or calendar quarters.
Totals run from the start of the tax year, because MTD updates are cumulative from April 2026.
Tax payments, transfers, cash withdrawals and likely personal spending are kept out of the totals.
Missing months, duplicate rows and items with no category are flagged for you to decide.
Doing this for 50+ clients every quarter?
Autocountly runs the MTD quarter for small practices: a read-only readiness scan across Xero, QuickBooks and spreadsheet clients, chase emails drafted for you to approve, and a one-page review pack per client. Start with a free readiness scan of up to 10 clients.
Your files are read in this browser tab and are never uploaded. Opening an Excel file loads a spreadsheet reader from a public code library; CSV files need nothing extra.
This tool helps you prepare records. It isn’t tax advice and it doesn’t submit anything to HMRC. Send quarterly updates through HMRC-recognised software. Category suggestions are a starting point, so check each figure.
© 2026 Autocountly
