DeepLedger
Menu

Bookkeeping

30 Claude and ChatGPT Prompts for QuickBooks and Xero Bookkeeping

Thirty example prompts for Claude or ChatGPT connected to QuickBooks Online or Xero: receivables, payables, cash, cleanup, month-end and multi-client work, each marked read only or prepares a change.

Published by DeepLedger6 min read

The best bookkeeping prompts name the company, the period, the basis and the output, and say plainly whether the AI may change anything. Below are 30 example prompts for Claude or ChatGPT connected to QuickBooks Online or Xero through DeepLedger, grouped by job. Each is marked Read only (the AI only reads) or Prepares a change (the AI drafts something for you to check before it is recorded).

These are example prompts: adjust names, dates and amounts to the company you are working in, and check the first answers against the ledger's own reports. If your AI app is not connected yet, start with Connect Claude to QuickBooks Online, Connect ChatGPT to QuickBooks Online or Connect Claude to Xero.

How to write a bookkeeping prompt

Five habits make the difference:

  1. Name the company. "Switch to Ridge Dental" before anything else, and read the company name in the answer.
  2. Name the period and basis. "October 2026, accrual basis" beats "last month".
  3. Say what the AI may do. "Do not change anything", or "prepare it and show me before you record it".
  4. Ask for a table. Columns you can check against the ledger.
  5. Ask it to stop when unsure. "If something is unclear, open a Task instead of guessing."

Getting started (any ledger)

  1. Read only.

Which company am I in? List every company I can access with its ledger.

  1. Read only.

Switch to Harbour Cafe Ltd and show the profit and loss for October 2026, accrual basis, with September beside it. Explain the three biggest changes.

  1. Read only.

Show the balance sheet at October 31, 2026 and flag any account whose balance looks unusual for this company, with a reason.

  1. Read only.

Read this company's AI Brain and summarise the rules it holds for vendors, customers and month-end.

Receivables

  1. Read only.

List open customer invoices more than 30 days past due with customer, number, amount and due date, largest first.

  1. Prepares a change (text only).

Draft a short, polite reminder for each of the five largest overdue invoices. Do not send anything.

  1. Read only.

Which customers paid late more than twice this year? Show average days late for each.

  1. Read only.

Find customer payments received in October that are not applied to an invoice.

Payables

  1. Read only.

List unpaid bills due in the next 14 days, grouped by vendor, with totals.

  1. Read only.

Check October's bills for possible duplicates: same vendor, similar amount, dates within 15 days. Show the evidence for each pair.

  1. Prepares a change.

Create a bill for the attached invoice from Northside Supplies. Check it is not already in the books first. Show me the lines before you record it.

  1. Read only (Xero).

List draft bills older than 30 days that were never approved.

Cash and bank

  1. Read only.

Show cash in each bank account at October 31 and the change from September 30.

  1. Read only (QuickBooks).

List bank feed transactions still waiting for review, oldest first, with a suggested category for each and how sure you are.

  1. Read only.

Build a simple 13-week cash view from open invoices, open bills and the current bank balance. State every assumption.

  1. Read only.

List deposits in October over $5,000 and what each one was for.

Cleanup and categorisation

  1. Read only.

List transactions posted to Uncategorized Expense or Uncategorized Income this year, with a suggested account for each.

  1. Prepares a change.

For the items you are confident about, prepare the recategorisation. Open a Task for the rest. Show me the list before you change anything.

  1. Read only.

Which vendors were coded to more than one expense account this year? Show the split for each.

  1. Prepares a change.

Save a rule in the AI Brain: Gusto payments go to Payroll Expenses except the monthly fee, which goes to Payroll Fees. Show me the rule before you save it.

Month-end close

  1. Read only.

Check October for this company: list bank and card accounts not yet reconciled to October 31, and open Tasks.

  1. Prepares a change.

Draft the October accrual for the audit fee of $3,000 as a journal entry. Do not record it until I approve.

  1. Read only.

Compare October's revenue and gross margin with the last three months and write two sentences a client would understand.

  1. Read only.

Show this company's QuickBooks closing date or Xero lock dates, and tell me whether October is locked yet.

  1. Read only (Xero).

Show the trial balance at October 31 and confirm debits equal credits.

Multi-client work

  1. Read only.

For each of my companies, show cash, October revenue, overdue receivables and open Tasks in one table. Do not change anything.

  1. Read only.

Go through my Xero companies one at a time and list bills due in the next week over $2,000. Name the company above each list.

  1. Read only.

Switch to Harbour Cafe Holdings and show the intercompany loan balance at October 31. Then switch to Harbour Cafe Ltd and show the matching account. Do the two agree?

  1. Read only.

Which of my companies have not had a bank account reconciled for October yet?

  1. Read only.

List every company where the AI Brain has no vendor rules yet, so I know where to start.

Prompts that need extra care

  • Anything that posts at once. In Xero, payments, Spend Money, Receive Money and transfers post straight away. In QuickBooks, a deposit cannot be voided; a wrong one is deleted with your confirmation or reversed with a journal entry. Ask for these only when you mean it, and read the lines first.
  • Deletes and voids. These need an explicit confirmation step through DeepLedger, and in QuickBooks a delete is refused for a reconciled transaction or one dated on or before the closing date. See AI write access to QuickBooks.
  • Sending. Emailing an invoice is a separate action that needs your confirmation. Drafting text in the chat sends nothing.

Frequently asked questions

What prompts work best for bookkeeping in ChatGPT or Claude?

Prompts that name the company, the period, the basis (cash or accrual) and the output you want, and that say whether the AI may change anything. Ask for a table, ask it to name the company in the answer, and ask it to stop and ask when something is unclear.

Can Claude or ChatGPT change my QuickBooks or Xero books from a prompt?

Only if the connection allows writes. Through DeepLedger, an AI can prepare and record transactions when you ask, with checks such as naming the company on every write and confirmation for actions that cannot be undone. In Xero, new invoices, bills, credit notes and manual journals are drafts by default. A read-only member cannot write at all, whatever the prompt says.

Do these prompts work in both QuickBooks and Xero?

Most do, because DeepLedger gives the AI the tools for whichever ledger the active company uses. A few are ledger-specific and are marked.

Does saying do not change anything make a prompt safe?

It guides the AI but it is not a permission. If a person should only read a company, make them a read-only member in DeepLedger, so a write is refused whatever the prompt says.

Ready to get started?

Connect QuickBooks and try your first task with an AI agent.

Create an Account

With your permission, Google Analytics measures visits to our public website and blog. Essential cookies work either way. Change your choice in Cookie settings. Privacy policy