Home · Money & bills · Catch up on months of bookkeeping from your bank statements
Catch up on months of bookkeeping from your bank statements
You're months behind and the thought of it keeps you up. Upload your bank statement export and get every line sorted into categories, ready to check and hand to your accountant.
The prompt · ChatGPT
Help me catch up on bookkeeping from my bank statement. My business: [what you do] The statement: [upload the CSV or paste rows: date, description, amount] Categories I use, or my accountant's list: [list, or ask me to use the GOV.UK allowable expense categories] Payments I know are personal: [list] First ask me up to 4 short questions. Wait for my answers. Then: 1. Every line with a category, and a confidence mark where you're unsure. 2. A list of lines you can't identify, for me to check. 3. Monthly totals by category. 4. A short note for my accountant on what I've done and what's still open. 5. A routine so I don't fall behind again. Use only my rows. Not tax advice. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. If I've uploaded a file, analyse it directly for the categorised statement and show your working. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
A short example
Fill the blanks, then paste. what you do: a short note you already have. upload the CSV or paste rows: date, description, amount: a short note you already have. Leave the rest of the prompt as written.
This does not give tax advice. The books stay in the accounting system.
The prompt · Gemini
Help me catch up on bookkeeping from my bank statement. My business: [what you do] The statement: [upload the CSV or paste rows: date, description, amount] Categories I use, or my accountant's list: [list, or ask me to use the GOV.UK allowable expense categories] Payments I know are personal: [list] First ask me up to 4 short questions. Wait for my answers. Then: 1. Every line with a category, and a confidence mark where you're unsure. 2. A list of lines you can't identify, for me to check. 3. Monthly totals by category. 4. A short note for my accountant on what I've done and what's still open. 5. A routine so I don't fall behind again. Use only my rows. Not tax advice. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Keep the categorised statement as a table so I can use Export to Sheets. Stay in this Gemini chat. Leave extensions off, including Gmail and Drive.
A short example
Fill the blanks, then paste. what you do: a short note you already have. upload the CSV or paste rows: date, description, amount: a short note you already have. Leave the rest of the prompt as written.
You export your business bank statement and upload or paste it.
The assistant asks your usual categories and about payments it can't identify.
You get every line categorised, a list of unknowns for you to check, monthly totals and a file to send on.
What happens
Use Gemini to catch up on months of bookkeeping from your bank statements
You're months behind and the thought of it keeps you up. Upload your bank statement export and get every line sorted into categories, ready to check and hand to your accountant.
Tools
Paste the prompt, fill the blanks, copy the draft.
- Gemini — required. Drafts from the text you paste. Nothing is sent.
The prompt is on this page. A free account saves it.
Create a free account