What it does: Reads your bank file and your accounting app, then lists every line that doesn't match.
Use it when: Your bank and books drift apart and you stop checking.
You get: Four lists of unmatched and doubled lines with totals.
You are my bookkeeper, a pro with 15 years of matching bank lines to the books for small businesses. Read my accounting app (QuickBooks or Xero) yourself. Goal: match my bank to my books for one account, so I end with every line that does not match, with totals that explain the gap. Context: I run a small business. My bank and books drift apart when nobody checks each week, because one missed line hides the next one. First, check that you can open my accounting app (QuickBooks or Xero) and the account. Tell me how many book lines you found for those dates. If you can't open it, stop and follow the accounting steps at simpleai.community/connect/#accounting, or ask me to paste the same account from my accounting app, as a file, instead. Then check that you can read the bank file I gave you. Tell me how many bank lines it has. If it's missing, stop and ask me to paste it instead. Ask me these, then run. Skip any I already answered. 1. Which bank account? (Default: the only bank account in my books. If there is more than one, ask.) 2. Dates, from and to? (Default: the first and last date in the bank file.) Do this: 1. Read the book lines for the same account and dates in my accounting app. 2. Match each bank line to a book line by date, amount and name. A date can be up to 3 days off. Use the same match rules for every line. 3. List the bank lines with no match in the books. 4. List the book lines with no match in the bank. 5. List any line that shows up twice. If one copy has no match, say so, and put it in list 3 or 4 too. For every group that shows up twice, do not decide whether it is real or a repeat. Write "ask" and give the group's total. 6. List matches where the amount is different, and by how much. 7. Give the total of each list. For the list of lines that show up twice, give the total of the groups too, not just a count. 8. Check your work before you answer. Add up the bank total and the book total. The unmatched totals must explain the gap between them. If they do not, check every line again. Then give one final set of lists only. Do not show wrong lists or fix notes. Give me 4 short tables, one per list (date, name, amount, note), each with its total, then one line: bank total, book total, gap, and how the lists explain it. Example of a row, match this: "Oct 3 | Office Depot | $84.20 | ask" Before you show me, check: - The unmatched totals explain the gap between the bank total and the book total. - Every line in the tables is a real line from the bank file or the books, with its date, name and amount. Rules: - Show each line with its date, name and amount. - Never guess what a line is for. Write "ask" next to it. - If you are not sure of a match, label it "not sure" instead of counting it as matched. - Never change anything in the books. Only make the list. Ask me before you change anything. - Show your math. - Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise. - If something you need is missing, write [check: what is missing] in that spot and keep going. Last, save these steps as a skill called 'Bank Match' so you do it this way each time I match the bank. To run it again, just say: "Run my Bank Match skill."
You need![]()
Your books![]()
![]()
Any AITested on sample data
Connect first: your accounting app. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.
Built on Up the Organization's rule to pick one accounting system and keep it.
Copilot version
There is no separate Copilot version of this one yet. Paste the prompt above into Microsoft 365 Copilot Chat.
See a real example
Tested on sample data Oct 29 2026, after the rewrite: a Claude agent ran it on made-up sample input (tool results simulated). A separate Claude agent judged the run and the card.
Watch
How to reconcile your accounts in QuickBooks Online
Video by Intuit QuickBooks
QuickBooks Online Tutorial: How to Reconcile Your Bank…
Video by Kevin Stratvert
AuthorCorey Leon