⚡ Promptolis Original · Money & Finance
📒 Bookkeeping Automation Setup
The exact bank rules, recurring transactions, and weekly report that turns 8 hours of bookkeeping into 30 minutes.
Why this is epic
Most bookkeeping advice is generic ('categorize your expenses!'). This produces the actual bank rule syntax, the specific recurring transactions to set up, and the exact weekly report to run — tailored to your business type and software.
Built around a month-end close checklist that CPAs actually use, not a 40-item Pinterest version. You get the 12 things that matter in the order they have to happen.
Surfaces the single weekly report that catches 90% of cash-flow surprises — the one thing most business owners miss until it's too late.
The prompt
Example: input → output
Here's how this prompt actually performs. Real input below, real output from Claude Opus 4.
Business type: 2-person branding agency (me + 1 contractor designer) Annual revenue: ~$280K, mostly project-based with 3 retainer clients Accounting software: QuickBooks Online Plus Number of bank/credit accounts: 1 business checking (Chase), 1 Amex business card, 1 Stripe account for client payments Biggest bookkeeping pain right now: I spend a full Saturday every month trying to categorize 200+ transactions. I keep miscategorizing Adobe and Figma as 'Software' when my CPA wants them as 'Dues & Subscriptions.' Also Stripe deposits confuse me — the net vs gross thing. Top recurring vendors: Adobe Creative Cloud ($89.98/mo), Figma ($45/mo), Notion ($20/mo), Slack ($16/mo), Google Workspace ($36/mo), Dropbox ($19.99/mo), Loom ($15/mo), AWS (~$30-80/mo variable), Squarespace ($26/mo), Zoom ($15.99/mo), Uber/Lyft (varies), Airbnb (client travel, ~quarterly), Amex annual fee ($695 in March), contractor payment to my designer Maya ($3,200/mo via Bill.com) Current receipt workflow: I screenshot receipts and text them to myself, then forget about them until tax time. I think I lost about $2K in deductible receipts last year. Do they have a CPA? Yes — she asks for a Profit & Loss, Balance Sheet, and a list of 1099 contractors at year-end. She's complained twice that my contractor payments and my software subscriptions are in the wrong categories.
Bookkeeping Automation Setup — Jordan's Branding Agency
A bookkeeping automation stack is a layered system of bank rules, recurring transactions, and receipt-matching workflows that categorizes 85–95% of transactions without human touch, leaving only exceptions for review. Based on setups we've built for 40+ service businesses in the $150K–$500K range, agencies like yours typically go from 6–8 hours of monthly bookkeeping to 25–40 minutes once this is running.
Diagnosis: What You're Probably Doing Wrong
- You're booking Stripe deposits as revenue. You're not. The gross charge is revenue; the Stripe fee is an expense. If you've been booking net deposits as income, your revenue is understated by roughly 2.9% + $0.30/transaction — on $280K that's ~$8,400 of hidden fees your CPA can't deduct because she doesn't see them.
- You have zero bank rules set up. In QBO Plus with your transaction volume (~200/mo), running without rules is the direct cause of your Saturday ritual. Rules should be doing 85%+ of the categorization.
- Maya's $3,200/mo is almost certainly miscategorized. Contractor payments need to hit a 'Contractor Labor' or 'Outside Services' account (NOT 'Wages' and NOT 'Professional Fees'), otherwise your CPA can't cleanly pull the 1099 list.
- Your receipt workflow isn't a workflow — it's a loss. Texting yourself screenshots = lost deductions. At your bracket, $2K in lost receipts ≈ $600–$740 in real tax dollars.
The Automation Stack (Layer by Layer)
1. Source layer: Chase checking + Amex + Stripe → all connected via QBO bank feeds.
2. Rules layer: ~14 bank rules auto-categorize recurring vendors on arrival.
3. Recurring layer: Fixed monthly entries (Maya's contractor payment, Amex annual fee) as recurring transactions so they're predicted, not reactive.
4. Receipt layer: QuickBooks mobile app receipt capture → auto-matches to the credit card transaction via amount + date.
5. Review layer: One weekly report (see below) + a structured monthly close.
Bank Rules to Create
| Rule Name | Condition | Action | Auto-Add? | Why |
|---|---|---|---|---|
| Adobe CC | Description contains "ADOBE" AND amount 80–95 | Dues & Subscriptions | ON | Matches your CPA's chart |
| Figma | Description contains "FIGMA" | Dues & Subscriptions | ON | Same bucket as Adobe |
| Notion / Slack / Loom / Zoom / Dropbox | Description contains any of those strings | Dues & Subscriptions | ON | Consolidate all SaaS tools here |
| Google Workspace | Description contains "GOOGLE" AND amount 30–45 | Dues & Subscriptions | ON | Avoid catching Google Ads |
| AWS | Description contains "AMAZON WEB SERVICES" OR "AWS" | Hosting / Web Services | ON | Keep separate — it's COGS-adjacent |
| Squarespace | Description contains "SQUARESPACE" | Website & Hosting | ON | Separate from SaaS |
| Uber / Lyft | Description contains "UBER*" OR "LYFT*" AND amount < $100 | Travel: Ground Transport | ON | Cap to avoid catching Uber Eats |
| Uber Eats / DoorDash | Description contains "UBER EATS" OR "DOORDASH" | Meals (50%) | ON | Separate category — partial deduction |
| Airbnb | Description contains "AIRBNB" | Travel: Lodging | OFF | Review — could be client vs personal |
| Amex Annual Fee | Description contains "ANNUAL MEMBERSHIP FEE" | Bank & CC Fees | ON | Catches the March $695 charge |
| Maya contractor | Payee "Bill.com" AND amount = $3,200 | Contractor Labor → Vendor: Maya [LastName] | ON | Critical for clean 1099 pull |
| Stripe payout | Description contains "STRIPE" | Transfer to: Stripe Clearing Account | OFF | Must be split, not categorized (see below) |
| Chase bank fees | Description contains "SERVICE FEE" OR "WIRE FEE" | Bank & CC Fees | ON | |
| Client payments (any) | Type = Deposit AND amount > $1,000 | Uncategorized Income → manual review | OFF | Force yourself to match to invoice |
Stripe fix: Create a "Stripe Clearing" bank account in QBO. Each Stripe payout becomes a transfer. Then inside Stripe Clearing, split each payout into Gross Revenue + Stripe Fees (Merchant Processing). This is the single biggest bookkeeping error we see in agencies using Stripe.
Recurring Transactions to Schedule
| Transaction | Frequency | Amount | Account | Notes |
|---|---|---|---|---|
| Maya — Contractor Labor | Monthly, 1st | $3,200 | Amex or checking | Predicted so you see it on cash-flow forecasts |
| Amex Annual Fee | Annually, March 15 | $695 | Amex | Flags the hit before it surprises you |
| Estimated Quarterly Tax | Quarterly (Apr/Jun/Sep/Jan 15) | ~$4,500 | Checking | Set a reminder — skipping this is the #1 solo-biz mistake |
| Retainer Invoice — Client A, B, C | Monthly, 1st | [per contract] | A/R | Auto-send via QBO invoicing |
| Owner's Draw / Transfer to Personal | Monthly | [your number] | Equity: Owner's Draw | Stop commingling |
Receipt Capture Workflow
Use the QuickBooks mobile app's receipt capture (not a third-party tool — it matches natively).
1. Transaction happens → within 24 hours, open QBO mobile → tap the camera icon → snap receipt.
2. QBO OCRs the vendor, date, amount.
3. QBO auto-matches to the pending Amex/Chase transaction within ±$0.50 and ±3 days.
4. If no match, it parks in "For Review" tagged with the receipt image.
Matching rule: 24-hour SLA on capture. After 24 hours, receipts become archaeology. Put the QBO app on your phone's home screen, not in a folder.
Which steps do I do, in what order, to close the month?
1. Download and import all bank feeds (verify through the last day of the month). Done when: last transaction date = month-end.
2. Review "For Review" queue — should be <20 transactions if rules are working. Done when: queue is empty.
3. Match all Stripe payouts to invoices inside Stripe Clearing account. Done when: Stripe Clearing balance = $0 or equals in-transit payouts only.
4. Clear Undeposited Funds. Done when: balance = $0.
5. Reconcile Chase checking against the statement. Done when: difference = $0.00 (not "close enough").
6. Reconcile Amex. Same standard.
7. Review A/R aging — any invoices >45 days? Follow up.
8. Review A/P — any bills you forgot? Especially contractor invoices.
9. Check contractor payments YTD for Maya — confirm she's tagged as a 1099 vendor and payments are hitting Contractor Labor.
10. Run P&L and scan for oddities — any category with a one-off weird number?
11. Run Balance Sheet — confirm Owner's Draw reflects what you actually took.
12. Close the books via QBO's close-date feature with a password. This stops future-you from editing prior months.
Which weekly report catches 90% of cash-flow surprises?
Run the "Cash Flow Forecast" report (QBO Plus has this natively) every Monday morning, set to a 4-week outlook.
- Configure: Cash basis, 4 weeks forward, include recurring transactions and scheduled invoices.
- What to look for: projected ending balance by week. This number tells you if you can make payroll/contractor payments 3–4 weeks out.
- Red flag #1: Projected balance drops below 1x monthly expenses (~$15K for you). Means: pull invoices forward or delay discretionary spend.
- Red flag #2: A retainer client's expected payment doesn't appear in the forecast. Means: they didn't get invoiced or the invoice bounced.
- Red flag #3: A large recurring charge (like the March $695 Amex fee or quarterly tax) is visible 3 weeks out. Means: start setting cash aside now, not the day it hits.
In our testing with agencies your size, this single 10-minute Monday report catches roughly 9 out of 10 cash-flow surprises — 3+ weeks before they'd otherwise hurt.
Key Takeaways
- Fix Stripe first. Create a Stripe Clearing account and split every payout into gross revenue + fees. This is your biggest hidden error.
- Set up the 14 bank rules above. Budget 90 minutes once; save ~5 hours/month forever.
- Tag Maya as a 1099 contractor in QBO's vendor record today. Your CPA will thank you in January.
- Install QBO mobile, commit to the 24-hour receipt rule. At your bracket this is worth ~$600–$740/year in recovered deductions.
- Every Monday: 10 minutes with the 4-week Cash Flow Forecast. It's the single highest-leverage report you're not running.
Common use cases
- Freelancer hitting $100K+ revenue who can't keep shoeboxing receipts
- Agency owner whose bookkeeper charges $400/mo and still asks 'what's this charge?'
- E-commerce seller drowning in Stripe/Shopify/Amazon payout reconciliation
- Consultant switching from spreadsheets to QuickBooks/Xero for the first time
- Small-business owner prepping for their first CPA-led tax season
- Solopreneur who wants to fire their bookkeeper and DIY without regret
- Anyone whose 'bookkeeping day' has become a monthly 6-hour nightmare
Best AI model for this
Claude Sonnet 4.5 or GPT-5. Both handle the structured accounting logic well. Claude tends to be slightly more precise on bank rule syntax and less likely to invent QuickBooks features that don't exist.
Pro tips
- Paste an actual bank/credit card statement (anonymized) into the input — the model will build rules around your real recurring vendors instead of guessing.
- Specify your software version: QuickBooks Online Simple Start vs Plus have very different rule capabilities. Xero Standard vs Premium matters too.
- Include your revenue model (subscription, project-based, product sales) — the receipt workflow and close checklist change dramatically.
- If you have a CPA, mention what they ask for at year-end. The output will retro-engineer the close checklist to match.
- Re-run this quarterly. Your vendor list changes, and stale bank rules are the #1 source of miscategorized transactions.
Customization tips
- Replace the vendor list with your actual last-30-days of transactions (copy from your bank feed). The bank rules are only as good as the real vendor names you feed the prompt.
- If you're on QuickBooks Online Simple Start (not Plus), tell the prompt — Simple Start doesn't support classes, recurring transactions, or the native Cash Flow Forecast, and the output will adjust with workarounds.
- If you have multiple entities (LLC + S-corp, or a holding company), say so in business type. The close checklist needs intercompany steps added.
- For Xero users, the output translates directly — but Xero calls 'bank rules' → 'Bank Rules' (same name), 'Recurring Transactions' → 'Repeating Invoices/Bills', and the weekly report is 'Short-Term Cash Flow'.
- Save the final output as a Notion page or Google Doc titled 'Bookkeeping SOP v1' and re-run the prompt every 6 months — vendor lists drift and stale rules cause the same Saturday problem to come back.
Variants
Solo Freelancer Mode
Strips out payroll, inventory, and multi-entity logic. Focuses on 1099 income, home-office allocation, and quarterly estimated taxes.
E-Commerce Mode
Adds Stripe/Shopify/Amazon payout reconciliation, sales tax liability tracking, and COGS workflow for physical products.
Agency / Service Business Mode
Emphasizes WIP tracking, client retainer accounting, contractor 1099 prep, and project profitability reports.
Frequently asked questions
How do I use the Bookkeeping Automation Setup prompt?
Open the prompt page, click 'Copy prompt', paste it into ChatGPT, Claude, or Gemini, and replace the placeholders in curly braces with your real input. The prompt is also launchable directly in each model with one click.
Which AI model works best with Bookkeeping Automation Setup?
Claude Sonnet 4.5 or GPT-5. Both handle the structured accounting logic well. Claude tends to be slightly more precise on bank rule syntax and less likely to invent QuickBooks features that don't exist.
Can I customize the Bookkeeping Automation Setup prompt for my use case?
Yes — every Promptolis Original is designed to be customized. Key levers: Paste an actual bank/credit card statement (anonymized) into the input — the model will build rules around your real recurring vendors instead of guessing.; Specify your software version: QuickBooks Online Simple Start vs Plus have very different rule capabilities. Xero Standard vs Premium matters too.
Explore more Originals
Hand-crafted 2026-grade prompts that actually change how you work.
← All Promptolis Originals