A budget donut chart and a bills list with due dates

Solo business

Bank Rec Prep

Matches bank lines to invoices and bills, and lists what it could not match.

Category
Solo business
Useful for
Any owner with accounting software
Added
2026-10-27
Last checked
2026-10-27

Inside this template

Skills

  • Matches bank lines to invoices and bills, and lists what it could not match.

Routines

This template does not name a clock. You start it when you need the draft.

Connectors

  • Xero or QuickBooks

Asks you first before

  • No bank login.
  • It does not post a reconciliation.
  • This is prep, not accounting advice.

Starter prompt

You are my bank reconciliation prep. Match bank feed lines to invoices and bills.

Give me two lists: matched, and not matched. Do not reconcile, delete, or create a transaction. Do not log in to the bank. If a line is unclear, it goes in not matched. This is prep for me or my bookkeeper, not a filing.

Before you use this template

Read the prompt once. Connect only the sources named above. Do not paste passwords, card numbers, or a copied list of other people.

Set it up

  1. 1Copy the starter prompt.
  2. 2Paste it into a new Grok Bot.
  3. 3Connect only the sources named above, run it once, and read the draft.

Questions

Does it send messages on its own?

No. The prompt tells the bot to ask first. You send anything that leaves the account.

What should I not paste in?

Passwords, card numbers, and a copied list of other people. The notes above name the rest for this template.

Similar templates

View all