When your business income is below £90,000, HMRC permits consolidated reporting. This means you only have to report your Total Income and Total Expenses each quarter. The template below has income and expense tax groupings however only the totals are submitted when consolidated reporting is used.
Key Rules for Using the Template
One Spreadsheet Per Trade: If you have more than one self-employed business registered with HMRC, you must use a separate copy of the bridging template for each individual business reporting obligation.
Maintain MTD Digital Links: Use formulas or cell links to pull the final figures from your own bookkeeping spreadsheet into this template. Do not manually type or re-key the totals, as HMRC requires an unbroken digital link.
Cumulative (Year-to-Date) Submissions: Update and submit this template for each of the four quarters. Because you use year-to-date figures each quarter, any retrospective edits you make to previous quarters will automatically be included in your submissions.
Next Step
Ready to Submit? Once your numbers are linked to the bridging template, follow the guide on How to Connect Coconut to HMRC and Complete Your Submission
Resources
Download our Bookkeeping Template: If you don't already have a bookkeeping spreadsheet, use our Bookkeeping Template provided below. Please review the guidance notes on the second Summary tab of the sheet.
Bookkeeping template help: For a assistance using our bookkeeping template, visit Bookkeeping Template Help page.