Build a Tax-Prep Packet for Your Accountant From Bank Statements
Researched
What it does
Turn a year of bank and card statements into categorized totals, a list of questions and a summary your accountant can use for a Schedule C, so tax season starts organized.
Who it is for
Sole proprietors and side businesses who hand their accountant a shoebox, or pay extra for catch-up bookkeeping.
Tools
ChatGPT or Claude (a paid plan helps with large statement files)
CSV exports of your business bank and card statements, with account numbers removed
Your receipts or receipt app
Your accountant's list of what they need, if they gave you one
Steps
Export statements as CSV for the tax year. Delete account and card numbers first.
Ask your accountant which categories they want, or use the prompt's default list.
Paste one month at a time into the prompt below if the file is large.
Check every line it marks "not sure" and every large amount against a receipt.
Ask for the final totals table and the questions list.
Send the packet and your receipts to your accountant. They decide what goes on the return.
The prompt
Help me organize my business transactions for my accountant. This is not tax advice and you will not file anything.
My business: [what you do, sole proprietor or other]
Tax year: [year]
Categories my accountant wants: [paste, or "use common small business categories: advertising, car and truck, contract labor, insurance, office, supplies, phone and internet, travel, meals, software, bank fees, other"]
Transactions (CSV, account numbers removed): [paste]
Do:
1. Put every transaction in one category. If unsure, mark it "not sure" with a reason.
2. Flag transfers, owner draws and loan payments separately. They are usually not expenses.
3. Give totals by category and by month.
4. List questions for my accountant (personal-looking charges, large purchases that may be equipment, duplicates).
5. Do not guess deductions or what is allowed. Leave that to my accountant.
Tips
Do this every quarter, not once a year. It is faster and catches mistakes early.