How to Build an AI Bookkeeper (Step-by-Step)
Small business owners spend 5-10 hours every week on bookkeeping tasks that follow the same pattern every time: send invoice, wait, follow up, wait longer, follow up again, check if payment landed, update the books, file the receipt. Multiply that by 20 or 50 clients and you’re burning entire days on accounts receivable alone.
Accounting software like QuickBooks and Xero stores your data. But it doesn’t chase down the client who’s 14 days late on a $3,200 invoice. It doesn’t email your vendor to confirm a payment went through. It doesn’t pull last month’s expenses into a summary and send it to your inbox Monday morning. You still have to do all of that manually — or hire someone to do it.
An AI agent changes that. It connects directly to your accounting software, payment processor, email, and file storage — then runs your entire bookkeeping workflow autonomously. Invoice follow-ups, payment reconciliation, receipt filing, financial reporting, vendor management. All through email, all without you touching it.
What an AI Bookkeeper Does That Accounting Software Doesn’t
QuickBooks tells you invoice #1047 is overdue. You email your AI bookkeeper “run AR follow-ups” and it checks every open invoice, sends the right reminder based on how overdue it is, and escalates the worst offenders to you. When a payment notification arrives from Stripe, it matches the payment to the open invoice in QuickBooks, sends a receipt, and updates the client record in your CRM.
The difference is action. Accounting software is a database with a dashboard. An AI bookkeeper is an autonomous agent that reads the data, makes decisions based on your rules, and executes multi-step workflows across every tool in your finance stack.
What it handles:
- Invoice follow-up sequences — escalating reminders sent from your email when you trigger a follow-up check
- Payment reconciliation — matching Stripe/Square payments to open invoices in QuickBooks/Xero
- Receipt collection and filing — saving emailed receipts to Google Drive, categorized by vendor and month
- Financial summaries — pulling data from your books and compiling reports when you ask for them
- Vendor payment tracking — reviewing outgoing payments and flagging upcoming due dates when you email for an update
Building Your AI Bookkeeper in Carly: Step-by-Step
The entire setup takes under ten minutes. You’re writing plain-English instructions, not code.
Step 1: Create the Agent
Fastest method: Email your main Carly agent at agent@usecarly.com and describe what you need:
Create a bookkeeping agent connected to Gmail, QuickBooks, Stripe,
Google Drive, and Google Sheets. It should handle invoice follow-ups,
payment tracking, and receipt filing.Your agent builds the new agent for you — name, email, tools, and starter instructions.
Dashboard method: Go to dashboard.carlyassistant.com/agents and click “Add Email Agent.” The getting started guide walks through the full setup.
Step 2: Name It and Assign an Email
Give it a role-specific name: “Accounts Receivable,” “Bookkeeper,” or “Finance Operations.” Assign a professional email like billing@yourdomain.com or ar@yourdomain.com. Clients will interact with this address directly, so pick something that reads like a real team member. See our guide on giving your AI agent a name, email, and personality for naming strategy.
Step 3: Connect Your Finance Tools
Toggle on the integrations your bookkeeping agent needs. Carly connects to 70+ integrations across 25 categories. For a bookkeeping agent, the core stack looks like:
| Category | Integrations |
|---|---|
| Accounting | QuickBooks, Xero, FreshBooks, YNAB, Zoho Books, Zoho Inventory |
| Payments | Stripe, Square |
| Gmail, Outlook | |
| File Management | Google Drive, Dropbox, Box |
| Productivity | Google Sheets, Airtable, Notion |
| E-commerce | Shopify, Gumroad |
| CRM | HubSpot, Salesforce |
| Documents | Google Docs, Google Slides, SharePoint |
| Messaging | Slack |
| Native | Google Calendar, Web Search |
Start with accounting + payments + email + file storage. Add CRM and messaging once the core workflows run clean.
Step 4: Write Instructions
Your instructions are the agent’s playbook. Be specific, sequential, and include escalation rules. The five workflows below give you ready-to-paste templates.
Step 5: Test with Real Scenarios
Send 5-10 test emails covering different situations: a new invoice to track, a payment confirmation, an expense receipt, a request for a financial summary. Watch how the agent processes each one in your dashboard and refine instructions based on results.
5 Bookkeeping Workflows with Ready-to-Use Instructions
1. Invoice Follow-Up Sequences
The single biggest cash flow killer for small businesses: invoices that sit unpaid because nobody followed up.
Tools: Gmail, QuickBooks or Xero, Stripe, HubSpot or Salesforce
How it works: You forward an invoice email to the agent to log it. When you email the agent to run AR follow-ups, it checks all open invoices and sends the appropriate reminder for each one based on how close it is to the due date — or escalates to you if it’s past the threshold.
Instructions:
You are the Accounts Receivable agent for [Company Name].
When I forward you an invoice or when a new invoice appears in QuickBooks:
1. Extract the client name, email, invoice number, amount, and due date
2. Log the invoice in Google Sheets "AR Tracker" with status "sent"
3. Update the client record in HubSpot with the invoice details
When I email you "run AR follow-ups" or "check invoices":
4. Review all open invoices in the AR Tracker and send the appropriate
follow-up for each based on where it stands:
- Due within 3 days: send a friendly reminder with the amount,
due date, and payment link. Subject: "Upcoming payment reminder -
Invoice #[number]"
- Due today with no payment: send a direct reminder. "This is
due today. Here's the payment link."
- 1-6 days past due: send a firm but polite follow-up. "Invoice
#[number] for $[amount] is now past due. Please remit payment
at your earliest convenience."
- 7-13 days past due: send a final reminder noting this is the
second overdue notice. Reference the original invoice date
and amount.
- 14+ days past due: stop emailing the client. Forward the full
thread to me with [OVERDUE - 14 DAYS] in the subject line.
Include the client name, amount, and all prior follow-up dates.
When payment is received in Stripe:
9. Match the payment to the open invoice in QuickBooks
10. Mark the invoice as paid in QuickBooks and in the Google Sheets tracker
11. Send a payment receipt and thank-you email to the client
12. Update the CRM record
Tone: professional, concise, never aggressive. Use the client's first
name. Keep emails under 5 sentences.2. Payment Receipt and Reconciliation
Tools: Gmail, Stripe or Square, QuickBooks or Xero, Google Sheets
How it works: When a payment arrives in Stripe, the agent matches it to an open invoice, updates your books, sends a receipt to the client, and logs everything.
Instructions:
You are the Payment Reconciliation agent for [Company Name].
When a payment notification arrives from Stripe:
1. Extract the payer name, email, amount, and transaction ID
2. Search QuickBooks for a matching open invoice (match by client
name and amount, allow a $0.50 variance for processing fees)
3. If a match is found: mark the invoice as paid in QuickBooks with
the Stripe transaction ID as reference
4. Update Google Sheets "AR Tracker" — change status to "paid" and
add the payment date
5. Send a receipt email to the client confirming payment received
6. If no matching invoice is found: forward the payment details to
me with [UNMATCHED PAYMENT] in the subject. Include the Stripe
transaction ID, amount, and payer email so I can investigate.
Never guess on invoice matching. If the amount doesn't match within
$0.50 or the client name is ambiguous, escalate to me.3. Expense Receipt Collection and Filing
Tools: Gmail, Google Drive, Google Sheets, QuickBooks or Xero
How it works: You or your team forward expense receipts to the agent. It extracts the details, saves the receipt to Google Drive in the right folder, logs the expense in a tracker, and categorizes it for tax time.
Instructions:
You are the Expense Management agent for [Company Name].
When someone forwards an expense receipt:
1. Extract: vendor name, date, amount, payment method, and expense
category (software, travel, meals, office supplies, professional
services, marketing, other)
2. Save the receipt file (PDF or image) to Google Drive in
"Finance/Receipts/[Year]/[Month]/" — create the folder if it
doesn't exist
3. Rename the file: "[Date]-[Vendor]-[Amount].pdf"
4. Log the expense in Google Sheets "Expense Tracker" with all
extracted details
5. If the expense is over $500, forward it to me with [LARGE EXPENSE]
in the subject for review
6. If you can't read the receipt or the amount is unclear, reply
asking for a clearer copy
When I email you "monthly expenses" or "expense summary":
7. Compile all expenses from the previous month into a summary
organized by category
8. Email me the summary with total spend per category and the top
5 largest individual expenses4. Weekly and Monthly Financial Summary Reports
Tools: Gmail, QuickBooks or Xero, Google Sheets, Google Docs, Slack
How it works: When you email the agent asking for a report, it pulls data from your accounting software, compiles a summary, and delivers it to your inbox or Slack.
Instructions:
You are the Financial Reporting agent for [Company Name].
When I email you "weekly finance summary" or "weekly report":
1. Pull from QuickBooks: total revenue received last week, total
expenses recorded, number of open invoices, total outstanding AR
2. Check Google Sheets "AR Tracker" for any invoices past due
3. Compile a summary email with:
- Revenue received last week
- Total expenses last week
- Number and total dollar amount of open invoices
- List of overdue invoices with client name, amount, and days overdue
- Cash position if available
4. Email the summary to me with subject "Weekly Finance Summary -
[Date Range]"
5. Post a condensed version to Slack #finance
When I email you "monthly report" or "monthly financial summary":
6. Pull the full previous month from QuickBooks: revenue, expenses
by category, net income, AR aging summary
7. Create a Google Doc with the monthly financial summary, including
month-over-month comparisons if prior month data is available
8. Save the doc to Google Drive "Finance/Monthly Reports/"
9. Email me the summary with the Google Doc link5. Vendor Payment Tracking and Reminders
Tools: Gmail, QuickBooks or Xero, Google Sheets, Google Calendar
How it works: The agent tracks what you owe vendors, reminds you before due dates, and confirms when payments go through.
Instructions:
You are the Accounts Payable tracker for [Company Name].
When I forward a vendor invoice or bill:
1. Extract: vendor name, amount, due date, payment terms, and any
early payment discount
2. Log it in Google Sheets "AP Tracker" with status "pending"
3. Create a Google Calendar reminder 3 business days before the due
date: "[Vendor Name] - $[Amount] due [Date]"
4. If there's an early payment discount (e.g., 2/10 net 30), create
an additional reminder for the discount deadline
When I email you "check AP" or "upcoming payments":
5. Review the AP Tracker for any bills due within the next 7 days
and email me a reminder for each: "Payment of $[amount] to
[vendor] is due on [date]. Early discount of [X]% expires on
[date] if applicable."
When I confirm payment was sent:
6. Update Google Sheets status to "paid" with the payment date
7. Send a confirmation email to the vendor that payment has been
initiated
8. Update QuickBooks with the payment recordScaling Up: Separate Agents for AR, AP, and Reporting
Once your single bookkeeping agent handles the basics, split the workload into specialized agents. Carly agents can spawn sub-agents, so your main finance agent can delegate to purpose-built specialists:
- AR Agent (
ar@yourdomain.com) — owns the full invoice-to-payment cycle. Only connected to email, QuickBooks, Stripe, and CRM. - AP Agent (
ap@yourdomain.com) — tracks vendor bills, payment deadlines, and early-pay discounts. Connected to email, QuickBooks, Google Sheets, and Google Calendar. - Reporting Agent (
reports@yourdomain.com) — compiles financial summaries when you email it for a report and delivers them to Slack and email. Read-only access to QuickBooks — it never modifies records. - Expense Agent (
expenses@yourdomain.com) — receives forwarded receipts, files them, categorizes them, compiles monthly expense reports.
Each agent has its own email, its own instructions, and its own tool access. The AR agent never touches vendor bills. The reporting agent never sends payment reminders. Isolation means fewer mistakes and cleaner audit trails.
Email agent@usecarly.com to have your main agent build any of these sub-agents in seconds.
Mistakes to Avoid with AI Bookkeeping Agents
Skipping escalation rules for financial actions. Every bookkeeping agent needs clear dollar thresholds and escalation paths. What amount triggers human review before a refund is processed? When does an overdue invoice get escalated from the agent to you? Write these rules explicitly — “if over $1,000, forward to me” — not as general guidelines.
Letting the agent guess on payment matching. A $4,950 Stripe payment could match three different open invoices. Your instructions must tell the agent to escalate ambiguous matches rather than picking the most likely one. Wrong reconciliation is worse than slow reconciliation.
Giving write access when read access is enough. Your reporting agent should pull data from QuickBooks, not modify records. Your expense filing agent should save to Google Drive, not delete files. Match tool permissions to the actual workflow.
Not testing the overdue escalation sequence end-to-end. Send a fake invoice, let the 3-day and 7-day reminders fire, and verify the 14-day escalation actually reaches you. A broken escalation path means overdue invoices silently rot.
Writing instructions as paragraphs instead of numbered steps. Financial workflows are sequential. “Check for payment, then update QuickBooks, then send a receipt” is three distinct steps. Number them. The agent follows numbered instructions more reliably than prose.
Combining too many financial functions in one agent on day one. Start with AR follow-ups only. Get the sequence running. Then add payment reconciliation. Then expense filing. Layering one workflow at a time means you catch errors early instead of debugging five broken processes at once.
Pick the workflow that costs you the most time — for most small businesses, that’s invoice follow-ups — and build your first bookkeeping agent at dashboard.carlyassistant.com/agents. Or email agent@usecarly.com and tell it what to build.
Related: What Are AI Agents · How to Build AI Employees · Best AI Agent Platforms · Getting Started with Carly · What Carly Can Do
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or try our Free Group Scheduling Tool
