AI prompts for finance and accounting teams.
For whoever closes the books, keeps cost of goods honest, and answers "are we actually making money?" 10 copy-paste prompts for Claude, ChatGPT, or any AI assistant, written from patterns we see in client work.
How to use these
Fill in the brackets.
Each prompt has [bracketed] spots. Replace them with your real numbers and context. The more specific you are, the better the answer.
Use a project.
In Claude or ChatGPT, put your policies, product list, and chart of accounts in a project once, so every prompt starts with your context.
Leave customer data out.
AI tools and vendors leak regularly (see the latest incidents). Remove customer names, addresses, emails, and messages before pasting. Card numbers and passwords never go into a chat. Amazon buyer data, including personalization text, has extra rules.
Check the math.
AI is good at structure and explanation and can still get arithmetic wrong. Spot-check any number you will act on.
Month-end close
Build a close checklist that matches your systems.
We close the books in [QuickBooks Online, QuickBooks Desktop, Xero, or other]. Other systems feeding it: [store, payments, marketplace, inventory or MRP, payroll]. Write a month-end close checklist in order, with who does each step, which report proves it is done, and the most common error at that step. Mark steps that could be automated by an integration.
Explain a variance before someone asks.
[Account or metric] was [actual] this month against [budget or last month]. Here is the detail: [paste transactions or a breakdown] Explain the variance in plain language: what drove it, whether it is timing or real, and whether it will repeat. Keep it to one paragraph a non-accountant can follow, plus the supporting numbers.
Cost of goods and margin
Check that cost of goods is right.
Here is cost of goods from our accounting system and the inventory movement from our inventory system for the month: [paste both] Reconcile them. List every difference larger than [amount], the likely cause (timing, missing receipts, wrong costs, manual entries), and the journal entry or process change needed.
Find unprofitable orders and customers.
Here are orders with revenue, product cost, shipping cost, fees, discounts, and returns: [paste data] Calculate margin per order and per customer, list the bottom 20 with the reason each is unprofitable, and suggest pricing, minimum order, or shipping rule changes. Do not include customer contact details in your answer.
Reconciliation
Match marketplace payouts to orders.
Here is a payout report from [Amazon, Shopify, TikTok Shop, or other] and the orders recorded in our books: [paste both, with order IDs and amounts] Match them. Break the payout into sales, fees, refunds, reserves, and adjustments, list orders that are in one place but not the other, and draft the journal entry to record the payout correctly.
Clean up an uncategorized transactions pile.
Here are uncategorized bank and card transactions: [paste date, description, amount] Suggest an account for each based on the description, group recurring vendors, and flag anything that looks personal, duplicated, or unusual. Use our chart of accounts: [paste account list].
Cash
Build a 13-week cash forecast.
Here is what I know about cash: [paste opening balance, expected sales by week, payment terms, open payables with due dates, payroll, rent, loan payments, and planned inventory purchases] Build a 13-week cash forecast table. Highlight the lowest week, what drives it, and three options to improve it, such as timing of purchases, collections, or terms.
Chase overdue invoices politely.
Here are overdue receivables: [paste customer, invoice, amount, days overdue, and last contact] Group them by how overdue they are and write a follow-up email for each group, firmer as days increase. Flag any customer we should stop shipping to until they pay.
Systems
Decide whether it is time to leave QuickBooks Desktop.
We use QuickBooks Desktop [version] for [what we use it for]. Pain points: [list]. Our accountant thinks: [their view]. Lay out the case for staying and the case for moving to QuickBooks Online now, including costs, risks, timing around year end, and what usually goes wrong in a move. End with the questions to settle with our accountant before deciding.
List what to settle with your accountant before connecting anything.
Orders come from [store or marketplace] and inventory lives in [system]. We use [accounting system]. List the decisions our accountant should make before any system posts to the books: summary or detail, how fees, refunds, shipping, and sales tax appear, who owns cost of goods, and how payouts are matched. Write them as plain questions I can send to my accountant.
Make them yours
These prompts work best once your AI knows your business. Put your product list, policies, and chart of accounts in a project once, and every prompt starts from your context. When a prompt becomes something you run every week, that is usually the sign it should become a workflow that runs on its own.
That is what we build. See how we work with finance and accounting teams →
Start on your own
Free skills that teach Claude how we set up the platforms our clients run on.
More prompt packs
Owner and CEO, Operations, Inventory and production, Purchasing and suppliers, Fulfillment and shipping, Sales and ecommerce, and Customer service.
Audited every year.
Deloitte and Amazon SP-API audits in 2026. PwC and Amazon SP-API in 2025. Shadow AI was involved in 43% of the breaches IBM studied for its 2026 report; we keep your data out of it. And if something we run goes wrong, we own the fix.