Bookkeeping Agents
A QuickBooks Online agent that suggests categories while the shliach approves every change, and a Gmail-to-Sheets tracker for Zelle, Venmo and PayPal gifts. Have your CPA review any setup.
On this page
Have your CPA review it. Nothing on this page is accounting or tax advice. In June 2026 members ran two long AI "deep research" reports on Chabad House accounting (fund classes, restricted gifts, donor-advised fund rules, unrelated business income, housing allowance). The reports were pasted into the group, and no accountant checked them. Several points in them need a professional's review, and some may be wrong. Use AI to sort, draft and flag. Let a person who knows your books approve what gets recorded.
A Chabad House usually has one to three staff, money arriving by Zelle, Stripe, PayPal and checks, and books that someone catches up on at year end. AI can take the sorting off your plate. It should not be the final word on your books.
Worked example 1: a QuickBooks Online agent
In June 2026 a member set out to build an agent that would help categorize his Chabad House's QuickBooks Online (QBO) transactions in conversation, with him as the final approver. The design the group converged on, over many rounds of correction, is a good template for anyone.
The flow
- The agent pulls new, unreviewed transactions from QuickBooks.
- It sends a numbered list, each with its suggested category and a confidence flag. Unknown donors and possible duplicates are flagged separately.
- The shliach replies with corrections ("3 is building fund, 7 is a refund").
- The agent shows exactly what it will write.
- It writes to QuickBooks only after an explicit "confirm."
- It marks each processed transaction (a short tag in the memo field was the member's idea) and keeps its own log of what it changed.
Two design choices worth copying: a separate "bookkeeper" agent that only records, apart from an "analyst" agent that only reads and reports; and dropping a separate bank-data service, because QuickBooks already pulls in the bank feeds.
What was learned
- The agent got facts wrong and corrected itself only when pushed. It first said bank-feed transactions waiting for review could not be read through QuickBooks' API, then reversed itself; later it said the review items are readable but QuickBooks' own auto-match suggestions are not. A member who knew the older API doubted it. Test on your own account before you rely on any of it.
- Final bank reconciliation and payroll stay with a person. That was the group's position in July 2026.
- Run research in two passes. The approach that emerged: Perplexity for research with citations, then Claude to turn it into a design, with a second AI review before acting.
- Know your situation. The member listed constraints any design should respect: tiny staff, personal and institutional money often tangled, gifts mostly by card processor rather than Venmo, and the shliach approving everything.
Ways to connect QuickBooks
As of 2026-10-21:
- Intuit's QuickBooks plugin for ChatGPT. In ChatGPT open Plugins, search for Intuit QuickBooks, connect and sign in. Intuit's help page (updated August 26, 2026) says it is for US QuickBooks Online customers; its examples are questions about invoices and profit and loss.
- A QuickBooks connector in Claude's directory. Anthropic and Intuit announced the integration in 2026. Check which actions it allows before you connect.
- Intuit's open-source QuickBooks Online MCP server (github.com/intuit/quickbooks-online-mcp-server): runs on your own computer, needs an Intuit developer app, and its README recommends starting in a sandbox company. This is the route the member's agent used.
- Pipedream's hosted QuickBooks MCP: a hosted alternative for agents.
Start read-only. Run the agent beside your current process for a few weeks, compare its suggestions to your real books, and only then let it write. The short version is the guide How do I pilot AI-assisted bookkeeping with QuickBooks.
Worked example 2: Gmail to Google Sheets payment tracker
The most-shared practical build of 2026. Zelle, Venmo, Cash App and PayPal all send an email for each payment. A Google Apps Script, written by AI and running inside your own Google account, reads those emails and logs each payment in a sheet. A shliach posted a "Donation Getter" version in June 2026 and another posted a full prompt in October 2026.
What the October 2026 prompt asks the AI to build:
- A script that searches Gmail every 15 to 30 minutes for payment notices (Zelle, Venmo, Cash App, PayPal, wire, ACH).
- One row per payment: date, method, sender, amount, memo, which account it was sent to, and a link to the email.
- A hidden tab of already-processed email IDs, so nothing is logged twice.
- Handling for emails forwarded from other inboxes.
- A tab per mosad if you run more than one, and an "Uncategorized" tab for anything it cannot place.
- A settings block at the top of the script.
The order of work the prompt insists on, which is the part to keep:
- Have the AI look at a few of your real payment emails first, so it reads the actual format.
- Test on recent mail only.
- Show the results in the sheet before turning on the timed trigger.
A prompt to start from:
Write a Google Apps Script for a Google Sheet that finds Zelle, Venmo, Cash App and PayPal payment notification emails in my Gmail and logs each payment as a row: date, method, sender, amount, memo, and a link to the email.
Keep a hidden tab of processed email IDs so nothing is logged twice.
Before writing the script, ask me to paste two or three sample emails (I will remove account numbers).
Run it on the last 7 days first and show me the results. Do not set up a timed trigger until I say so.
Things members ran into:
- Zelle notices often lack the donor's full name, and bank CSV exports may drop the Zelle memo. Expect an "unknown sender" list to sort by hand.
- Native integrations miss things. PayPal and Stripe connect to QuickBooks directly, but the builder of the June version said those integrations do not handle classes, sales receipts, Zelle notes or Cash App, and that processor fees should be recorded as an expense.
- Getting the sheet into a CRM is the next step. Import it rather than letting an AI type it in: CMS Cloud's Upload Donations (Premium package) takes a CSV and lets you review each gift before it posts. See CRM Automation.
- Google limits how much an Apps Script can do per day, and the limits differ between free Gmail and Workspace accounts. A tracker for a normal Chabad House stays well within them; a shared account handling many mosdos may not.
The script runs in your Google account and the data stays in your sheet. That is its main advantage over giving an outside agent your inbox.
Other tools members use
- Bookeeping.ai (one "k"): an AI bookkeeping service with a nonprofit section on its pricing page; its for-profit plans include a free tier and a 30-day trial on paid plans. One member uses it for his Chabad House.
- Dext: receipt capture that feeds accounting software.
- Tiller: puts bank data into a Google Sheet, which an AI can then read.
- TechSoup offers discounted QuickBooks Online for eligible nonprofits for an annual admin fee; check techsoup.org for the current fee and eligibility.
- ChatGPT or Claude on an export. In July 2026 a shliach had ChatGPT sort 2,687 transactions into 20 categories in about an hour, then spent four hours checking. Another did the same with Claude. The checking is the real work.
Rules the group follows
- Read-only or draft-only for anything financial. A person confirms every write.
- Never paste bank or card numbers, or online banking logins, into a chat.
- Do not let an agent log in to your bank or a financial aggregator; it can lock the account.
- Keep real accounting software as the record. AI works alongside it.
- Keep a log of what the AI proposed and who approved it.
- A cautionary story the June research raised: Bench, an online bookkeeping service, shut down without warning on December 27, 2024, and its platform became inaccessible to customers overnight. A buyer later restarted it, but export your records regularly from any service you rely on.
Two IRS facts that come up
Checked on irs.gov on 2026-10-21. Anything beyond these, ask your accountant.
- Churches and conventions or associations of churches are among the organizations that do not have to file the IRS annual information return. Whether your Chabad House is classified that way is a question for your accountant.
- A donor needs a written acknowledgment from the charity for any single gift of $250 or more (IRS Topic 506).