Paste in your business bank statement, tick off the categories, and get the cumulative quarterly figures for Making Tax Digital for Income Tax. Save them as a PDF, then enter them in HMRC-compatible software such as 123 Sheets.
Try the calculator £50 per yearYour bank data stays in your browser. Nothing you paste is uploaded or stored on our servers.
1. Click the first Date cell below and paste (Ctrl+V or Cmd+V) the columns Date, Type, Description, Paid Out, Paid In copied from Excel or your bank’s CSV. Each value drops into its own cell, just like a spreadsheet. A header row is fine, and a single Amount column (negative = money out) also works. You can also click any cell to type or edit, and paste into any column.
2. Quick Categorize sets money in to Sales and money out to Cost of Goods for uncategorised rows. Cost of Sales Adjustments then applies your keyword list below. 3. Fix anything by hand. Tick Disallowable for an expense that isn’t allowable, and use Not Applicable for transfers and personal spending.
Type a word from the bank description (for example a supplier’s name) and its category (for example Advertising). Matching ignores capitals; short categories such as “Advertising” are accepted. Words of three letters or fewer match only as a whole word. Saved in this browser only.
Prepared with mtd-software.co.uk from figures entered by the user. These figures are only as accurate as the bank entries and categories supplied; they are not tax advice. If unsure which figure goes in each box, ask your accountant or HMRC.
In the print window choose Save as PDF as the destination.
Many sole traders and landlords just need the right totals to enter in their filing software. This does that part, without the cost or complexity of full accounting software.
MTD Software works out the figures. To send them to HMRC you need HMRC-recognised software.
Enter your cumulative figures into 123 Sheets and submit your quarterly update to HMRC.
See GOV.UK’s list of software compatible with Making Tax Digital for Income Tax.
Send them the PDF. It shows income, each expense category and taxable profit for the period.
Making Tax Digital for Income Tax Self Assessment (MTD ITSA) means sole traders and landlords keep digital records and send HMRC four quarterly updates a year, then a final declaration. It applies from 6 April 2026 if qualifying income is over £50,000, from 6 April 2027 if over £30,000, and from 6 April 2028 if over £20,000. Check GOV.UK for the current rules.
Each update covers everything from 6 April to the end of that quarter, so the second update includes the first quarter. This tool adds the quarters together for you.
They are your total income and your expenses by category for the period, plus the taxable profit that follows from them. HMRC asks for them in each quarterly update.
No. MTD Software calculates the cumulative figures and gives you a PDF. You then enter them into HMRC-recognised software such as 123 Sheets to submit.
Everything is processed in your own browser. Your bank figures are not sent to or stored on our servers, and they are cleared when you close the page. Use Save my data to download a backup file to your own device, and Load my data to carry on next quarter.
£50 per year.
Tick Disallowable on that row. It is shown separately and is not deducted when working out your taxable profit. Depreciation is a common example.
No. Choosing the right category for each entry is your responsibility. If unsure, ask your accountant or HMRC.