Before you start.
Three things make the steps work.
- A separate business account. The IRS says that for most small businesses, the business checking account is the main source for entries in the books.
- A short list of categories. The expense lines of your tax return are a good start. Add one only when you need it.
- A place for the books after the chat ends: a spreadsheet, an accounting app, or books built for your assistant. A chat is not a ledger.
The six steps, with what to ask.
Do one month first, in a project. In both ChatGPT and Claude, a project keeps your files and instructions for every chat in it, so your categories and rules carry over to next month.
Scroll horizontally to see all columns.
| Step | What to ask your assistant | What to check |
|---|---|---|
| 1. Set up a project | Put your category list and your rules in the project's instructions, such as “Everything I buy on Amazon with this account is studio supplies.” | In Claude, a chat shares its context with the project's other chats only through the project's knowledge. Keep the rules there, not in one chat. |
| 2. Add the statement | Upload the month's statement from your bank as a PDF, or its transactions as a CSV. | A text PDF or a CSV, not a photo or a scan. OpenAI says ChatGPT may not reliably extract exact values from scanned files. |
| 3. List every row | “List every transaction on this statement in a table: date, description, amount, in or out. Then give me the row count and the totals in and out.” | The totals match the statement's own. The opening balance, plus deposits, minus withdrawals, equals the closing balance. |
| 4. Categorize | “Put each row in one of my categories. If you cannot tell what a row was, list it as a question. Do not guess.” | Transfers between your accounts, credit card payments, loan principal and money you put in are not income or expenses; a loan's interest is an expense. Answer its questions, and add each answer to the project as a rule. |
| 5. Save the month | “Make this month a spreadsheet I can download: one row per transaction, with its category.” | The file has as many rows as the statement. Keep it, with the receipts, outside the chat. |
| 6. Reconcile and report | “From my saved months, build a profit and loss for the year so far.” | Each account reconciles to its statement. The report comes from the saved files, not from the chat's memory. Review its figures and formulas. |
Where it goes wrong.
The checks in the table catch these. Both companies say to check the numbers: OpenAI says AI can make mistakes, and Anthropic says to check important figures against your bank's own app or statements.
- A row missed or read twice. The count and the totals in step 3 show it.
- A transfer or a card payment counted as spending. OpenAI's Finances page names this as a reason a spending breakdown can look wrong.
- A guess. A statement shows who was paid, not why, and a category the assistant guessed looks the same as one you gave.
- A lost month. OpenAI says ChatGPT's memory “does not retain every detail from every conversation.” Only the file you saved holds the month.
- The bank connection in the same chat. Anthropic says that after Claude uses your linked accounts in a chat, it may not be able to run code or make an Excel file there. Use the statement file for the books.
Or let your assistant keep the books.
The steps above are you and your assistant working by hand. With CollieTax, your assistant does the month's books when you say “do the books for October,” in ChatGPT, Claude, Muse or Grok Bot, and the checks are not its own:
- Your assistant reads the statement from your files or, with your yes, your email.
- CollieTax checks the rows against the totals and balances the statement prints, and keeps a statement with a missing page out of the books.
- It rejects an entry whose debits and credits do not balance, and keeps every change with the old value, the new one and why.
- A payment your assistant cannot place stays a question until you answer, even in a new chat. For a payment that recurs, it can keep your answer as a rule.
- The reports come from the entries, and you see every entry beside its statement on one private page.
- In your own assistant, free under 15 transactions a month, then from $29 a month for each set of books. With a CollieTax bookkeeper, from $199 a month.
What still needs you.
A statement shows who you paid and how much. These answers are yours, whichever way you keep the books:
- Whether a payment was for the business, or personal.
- Whether money in was a sale, a loan, or money you put in yourself.
- How a loan payment splits into principal and interest. The lender's statement shows it.
- How an item is treated on your tax return. That is a tax professional's judgment, not bookkeeping.
Sources and further reading
- OpenAI: Projects in ChatGPT
- OpenAI: Data analysis with ChatGPT (scanned files)
- OpenAI: Memory in ChatGPT
- OpenAI: Finances in ChatGPT
- Anthropic: How can I create and manage projects?
- Anthropic: Create and edit files with Claude
- Anthropic: Use Personal Finance in Claude
- IRS: What kind of records should I keep
- IRS: Publication 583, Starting a Business and Keeping Records (reconciling)
General information and product guidance. Examples are illustrative; your records and filing situation determine the work required. Sources and product descriptions were checked for this update.
Put the workflow to work.
Give this to your assistant. It reads the page, then does the work with you.
Read https://collietax.com/blog/how-to-use-ai-for-bookkeeping.md, then do my business's books for last month with CollieTax.