QuickBooks HelpQuickBooksHelpIntuit

Moving from paper or spreadsheets to digital record-keeping in QuickBooks

by Intuit•2• Updated 2 weeks ago

If you’ve traditionally managed your accounts using paper ledgers or Excel spreadsheets, the transition to Making Tax Digital for Income Tax (MTD for IT) in April 2026 involves more than just switching to a computer.

HMRC’s MTD rules require digital record-keeping, which means your financial data must flow through an unbroken electronic path from the initial transaction to the final submission. This guide explains what counts as a digital record and how QuickBooks ensures you stay compliant.

Note: This article covers digital record-keeping. For a broader overview of the HMRC mandate and how it affects your business, visit our Making Tax Digital hub page.

Ready to switch?

If you're currently using spreadsheets, now is the time to transition and get MTD-ready well ahead of the April 2026 deadline. Explore plans and pricing


What is a "Digital Link"?

A digital link is an electronic transfer of data between software programs or products. HMRC is strict about how this data moves. For your records to be MTD-compliant, the "digital chain" must not be broken.

  • Compliant digital links: Automatic bank feeds, CSV file imports, and API transfers between apps.
  • Non-compliant actions: Manually re-typing figures from one sheet to another or using "copy and paste" to move totals into a tax portal.

HMRC rule: Once data is entered into a digital system, any further movement of that data to HMRC must happen automatically. Manually typing your final quarterly totals into a website is no longer allowed under Making Tax Digital. See official HMRC guidance on creating digital records.


Why spreadsheets often fail Making Tax Digital rules

While HMRC allows the use of spreadsheets, they can only be used if they are "digitally linked" to compatible software.

  • The risk of manual error: Standalone spreadsheets rely on manual entry, which HMRC identifies as a major source of the "tax gap."
  • The "copy-paste" trap: If you calculate your totals in Excel and then manually type them into a submission form, you have broken the digital link.
  • The solution: QuickBooks replaces the need for complex spreadsheets by capturing the data at the source—your bank account—and moving it directly to HMRC with no manual re-typing required.

Making the transition to digital records

Transitioning to QuickBooks removes the risk of manual entry errors and ensures your data is always "submission-ready." Here is how to move your manual processes into a compliant digital workflow.

The easiest way to maintain a digital record is to capture the data the moment it occurs.

  • Bank feeds: Connect your bank to QuickBooks. Every time you spend or earn, the transaction is recorded digitally.
  • Receipt capture: Use the QuickBooks mobile app to snap a photo of a paper receipt. QuickBooks extracts the date, amount, and supplier, creating a digital record that satisfies HMRC’s requirements for supporting evidence.

In QuickBooks, you "add" or "match" transactions rather than typing them out.

  • Go to the Banking tab.
  • Review the suggested category (e.g., "Office Expenses").
  • Select Add.

This maintains the digital link because the software is moving the data for you.

When it’s time for your quarterly update, QuickBooks pulls the totals from your digital records. Because QuickBooks is MTD-compatible with HMRC, the submission happens via a secure API connection, ensuring the digital chain remains unbroken from start to finish.


Quick tips for success

  • Digital accuracy: Digital records must include the date of the transaction, the amount, and the category (type of income/expense).
  • No paper requirement: While you should keep your original receipts, HMRC accepts digital photos of receipts as valid record keeping for Income Tax.
  • Transition period: If you are migrating data from a spreadsheet into QuickBooks, use our CSV import tool to ensure the data moves via a digital link rather than manual re-entry.

More help

QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start