Run this before you trust the month’s numbers. It’s the same order I’d follow to close a small business’s books, with a ChatGPT prompt for each check so you can work faster.
How to use it: work top to bottom once a month and tick each box when it’s done. AI can show you what to look into. It doesn’t replace professional judgment, so check every flag yourself before you change an entry.
Step 1: Get your data ready
- ☐ Reconcile every bank and credit card account to its statement
- ☐ Export the month’s transactions to a spreadsheet (date, vendor, amount, category)
- ☐ Remove account numbers, tax IDs and any personal details before you paste anything into ChatGPT
Step 2: Run the 7 checks
1. Find unusual transactions
Prompt to copy:
Review these transactions. Flag anything unusual: large amounts, round numbers, new vendors or odd dates. Tell me why each one stands out.
- ☐ Every flagged transaction is explained or corrected
2. Look for duplicate expenses
Prompt to copy:
Find possible duplicate expenses: same vendor and amount within 7 days, or the same invoice number entered twice. List them side by side.
- ☐ Duplicates removed, or the vendor asked for a refund
3. Find unusual month-to-month changes
Prompt to copy:
Here is my P&L by month. Show every account that changed more than 20% from last month, and list the questions I should ask about each.
- ☐ You can explain every big move on your P&L
4. Review accounts receivable
Prompt to copy:
Here is my A/R aging report. Which customers are over 60 days? Flag any credits or unapplied payments that need a closer look.
- ☐ Follow-up sent on everything past 60 days
- ☐ Unapplied payments and credits matched to the right invoices
5. Look for possible miscategorizations
Prompt to copy:
Review these expenses and their categories. Flag anything that looks miscategorized, like personal charges, equipment booked as supplies, or loan payments booked as expenses.
- ☐ Miscategorized expenses moved to the right account
6. Identify missing reconciliations
Prompt to copy:
Here is my balance sheet with the last reconciled date for each account. Which accounts are behind, and what could go wrong with each one?
- ☐ Every balance sheet account has a current reconciliation
7. Find the questions to ask your bookkeeper
Prompt to copy:
Based on these reports, write 10 questions I should ask my bookkeeper before I trust this month’s numbers.
- ☐ Questions sent to your bookkeeper before you sign off on the month
Step 3: Sign off
- ☐ Every AI flag checked by you, not just accepted
- ☐ P&L and balance sheet reviewed one last time
- ☐ Month marked closed (in QuickBooks Online: Gear icon > Account and settings > Advanced > Close the books)
Need a hand? I’m a California CPA and I help small business owners clean up and understand their books. Send me a DM at @accountingwithvorsky or email oksana@vorskyadvisory.com and tell me which step got stuck.
This checklist is general education, not tax, legal or accounting advice for your specific business. Review anything that doesn’t look right with a qualified accountant.