Here's how to automate bookkeeping with AI, from my own books overhaul: one month at a time, the bot checks every record against every other, and logs anything that doesn't match for you.
My old books were a pile: repair tickets in one place, parts orders in my inbox, card payments in two apps. I knew they didn't all line up, and I never had a free week to check.
Jump To: The Process · The Rule · The Short Version · Step By Step · A Filled-In Example · Copy These Prompts · Before You Approve · Common Mistakes · Worked Scenario: A Weekly Sort · More Questions · A Small Business Can Work Like A Big One · How Grok Bot Usage Works
The Process
- One month per run, so each pass stays small and checkable.
- Repair tickets and invoices are read from my repair software, read-only.
- Parts-order emails, PayPal and Square records are matched against them.
- Anything that doesn't match is logged in a findings file for me.
- What the bot can't see, like card statements, is listed as a request.
The Rule
Nothing in my repair software or my accountant's files gets changed by the bot. It reads, matches and reports. I decide.
Tools I used: Zapier for Square, and RepairDesk.
The Short Version
Here's the step-by-step way to have a bot help with bookkeeping. It sorts and flags; you approve, and your accountant has the final word.
Step By Step
- Decide what the bot handles. Sorting transactions, matching receipts and flagging questions are good starts.
- Give it read access only. It reads your accounts and books but doesn't move money or file anything.
- Write your categories down. A short list of the categories you use, so it sorts consistently.
- Ask for a weekly sort. New transactions get a suggested category and a note if it's unsure.
- Review and approve. You confirm each category before it's saved in your books.
- Flag anything odd. Duplicates, unusual amounts and missing receipts go on a list for you.
- Keep a deadlines list. Have the bot track filing and payment dates and remind you early.
- Hand off to your accountant. Use the bot's tidy records to answer your accountant's questions faster.
A Filled-In Example
Date | Description | Amount | Suggested Category | Sure?
-----|-------------|--------|--------------------|------
[date] | [vendor] | [amt] | [category] | Yes / Check
Copy These Prompts
Estimated usage: our rough guide, not an official figure. Est. Usage: Low quick one-off asks; Est. Usage: Medium multi-step tasks or short research; Est. Usage: High long research, many tool calls, browser work or daily routines.
Read my transactions from the last week, read-only. Suggest a category for each from my list below, mark any you're unsure about, and flag duplicates or missing receipts. Don't save anything.
Categories: [your list]
Est. Usage: Low
List my upcoming tax and filing deadlines from the sources I've given you, with dates, and remind me two weeks before each.
Est. Usage: Medium
Before You Approve
- The bot has read-only access.
- You approved every category.
- Odd items are on a list, not ignored.
- Deadlines are tracked with reminders.
Payment dates: record each payment on the day the money landed in the account, not the day it was sent or invoiced.
Common Mistakes
- Letting a bot pay or file anything. Keep it read-only.
- No category list. The bot will sort inconsistently.
- Approving in bulk without looking.
- Treating the bot as your accountant. It prepares; a pro advises.
- Waiting until tax time. Sort weekly.
Worked Scenario: A Weekly Sort
Say the week has thirty new transactions. The bot suggests a category for each from your list, marks four as "Check" and flags one charge that appears twice.
You confirm the categories, look into the double charge, and note the missing receipt the bot listed. When your accountant asks about a vendor in spring, the categories and notes are already there instead of piled up for tax season.
Over a few months the category list gets sharper. Each time you correct a suggestion, you add a short note to the list, such as which vendor goes where, and the bot's suggestions get more consistent. The deadlines list does the same job for dates: every filing and payment date sits in one place with an early reminder, so nothing sneaks up on you.
More Questions
Can The Bot Replace My Accountant?
No. It keeps records tidy and flags questions. Your accountant advises and files.
Should It Have Access To Move Money?
No. Read-only access is enough for sorting and flagging.
What If It Categorizes Something Wrong?
You approve each one, so fix it then and add a note to your category list so it learns the pattern.
What Should The Weekly Report Include?
New transactions with suggested categories, anything marked Check, duplicates, missing receipts and any deadline coming up in the next few weeks.
A Small Business Can Work Like A Big One
Many small business owners don't know these AI tools exist yet. That's a missed chance, because they let a small shop handle work that used to need a team: price updates, store edits, daily reports and research. You stay the one who approves every change, and the routine work gets done in the background.
How Grok Bot Usage Works
Franchitti's Fix is run by Steve with help from Grok Bot, so here's the plain version of how its usage works.
- Your Plan Includes A Usage Allowance. Paid plans come with included usage that refreshes every week. Higher-tier plans include more. Unused usage doesn't roll over. (Source)
- Bigger Jobs Use More. In general, long research, tasks that use lots of tools and routines running in the background do more work, so they draw down the allowance faster than a quick question.
- Light Settings Stretch It. Lower effort for simple jobs, fewer and less frequent routines and short, focused requests all help the allowance last. See How To Regulate Grok Bot Usage.
- Checking Your Usage. In Grok Bot, open Settings, then Usage & Billing. On The X Subscription, you can also check Usage at grok.com/dashboard, which shows the weekly pool, the next reset date and any prepaid credit. (Source)
Try Grok Bot
Affiliate link: we may earn a referral reward if you sign up.
Related Guides
- How To Use AI For Pricing: Exact Prices, Clean Listings
- How To Connect AI To Apps: Prompts That Work
- AI Prompts For Bookkeeping: Read, Match, Report
- How To Use AI With Google Sheets, Drive And Docs
Why This Matters To Me
I was an overworked and overwhelmed one-person shop trying to run a six-figure business alone, because hiring here is so expensive. Grok Bot helped me accomplish things I never thought were possible. The full story starts in How To Set Up An AI Assistant With Grok Bot.
More In This Series
Back to the series index: AI Business Overhaul Stories: Before And After. All series: Every AI Guide In One Place.
Want To Talk Shop?
I'm Steve, and I run Franchitti's Fix, a home-based, by-appointment iPhone repair shop in San Diego. Questions about bots, or an iPhone that needs fixing? Book An Appointment or call (720) 413-8150, or read more about me.
Try This Prompt: AI For Small Business
Restaurant
List 5 repeat tasks in my restaurant I could hand to an AI assistant, with what I would still need to approve myself.
Salon
List 5 front-desk tasks at my salon an AI assistant could draft, like reminders and rebooking texts, and what I should always approve first.
Contractor
Write a missed-call text reply for my contracting business: thank them, ask for the job address and a photo, and say when I usually call back.
Retail
Make a weekly checklist for running my shop's social posts with AI: what to draft, what to review, what never to post without me.
Real Estate
Make a weekly AI routine for my real estate business: what to draft (posts, follow-ups), what to review, what never to send without me.
Repair Shop
Draft a ready-for-pickup message for [customer] about their [device] repair. Include our hours: [hours]. Under 40 words.
Personal And Family
Help me set up a weekly family plan with AI: chores, meals and reminders for [family members]. Keep it to one page.
Seniors
List 5 simple, safe ways I could use AI each week, like reading letters or making shopping lists, and what I should never share with it.
How To Use These Prompts
Pick the card closest to your business, tap To Copy, then paste it into your AI app.
Tips To Customize Them
- Fill In Every [Bracket] With Your Own Details.
- Add Context: Who It Is For, How Long, What Not To Change.
- Ask A Follow-Up To Adjust The First Answer.
Common Mistakes
- Leaving Brackets Unfilled.
- Pasting Private Info Like Passwords Or Card Numbers.
- Trusting Prices, Dates Or Facts Without Checking.



