Tidy your round income and expenses for quarterly digital updates
The problem
Owners are anxious about Making Tax Digital because their records live in a round app, a notebook and a bank app. A sheet that turns your exports into income and expenses by month means that when you do need to send updates you're copying numbers, not hunting for them.
What AI does
AI helps you lay out a monthly income and expenses sheet from your round app and bank exports, using customer references, not names. It may suggest a category for you to accept or change, but never decides what's allowable or sends anything to HMRC (UK).
Time
The steps, in short
- Check on GOV.UK if and from when the Making Tax Digital rules cover you.
- Export your round payments and business bank statement, leaving out personal spending.
- Have AI lay out a monthly sheet with [your column headings].
- Categorise each month's rows yourself, and ask your accountant or HMRC guidance about anything unclear.
A short sample prompt
I'm a sole-trader window cleaner in the UK. Lay out a monthly spreadsheet for business income and costs with these columns: [your column headings]. Use customer references, not names. Don't judge what's allowable.
In the full playbook
- 6 steps in full
- The exact prompt to copy
- A check-before-you-send list (3 points)
- UK notes with official sources