Claude (formerly Cowork) can sort a folder of receipts and invoices for reconciliation in Claude Desktop. Point it at one folder of copies, set permissions to Manual, and ask it to rename the files, extract date, supplier, amount and tax into an Excel workbook, and match each line to the bank statement. Check flagged rows before your accountant does.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowThe careful set-up isn't optional. Anthropic's own safety page for Cowork advises against granting access to local files with sensitive information, naming financial documents as the example, and suggests a dedicated working folder plus backups instead of broad access. It also explains that tasks run on Anthropic's servers, reaching your computer through Claude Desktop only for the folders you've connected, so any file Claude opens is processed there. That's why everything below works on copies in one folder, with Manual approval and no banking logins anywhere near the task.
Should Claude read receipts from a local folder or connectors?
Claude can get receipts from a local folder in Claude Desktop or from connectors, and most small businesses end up using both. Claude Desktop can read and write files in folders on your computer, but only while the app is open. Connectors reach cloud services instead, and those keep working when your computer is off.
| Route | What Claude can do there | Use it for | Watch out for |
|---|---|---|---|
| Local folder via Claude Desktop | Read PDFs, images, spreadsheets and CSV files; rename, sort and create files in that folder | The monthly prep itself | Only works while Claude Desktop is open; connect one folder, not your whole drive |
| Google Drive connector | Search, read, copy, create, update, share and trash files, per the connector's tool list | Receipts your team already saves to a shared Drive folder | Set write and delete tools to Needs approval |
| Dropbox connector | List, search, copy, move, create folders and delete | Receipt folders kept in Dropbox | Same: approval on move and delete |
| Xero connector | Read-only: bills, invoices, aged payables, bank account transactions, chart of accounts | Checking your workbook against what's already in the books | Read-only by design, which is exactly what you want here |
| QuickBooks connector | Reports plus tools that create, update and send invoices and import transactions | Reading A/P and A/R ageing to compare | Writing tools exist; block them for this job |
| Gmail connector | Search and read threads; its tool list also includes drafting, sending, forwarding and trashing | Listing supplier invoice emails you haven't saved yet | Block the send, forward and trash tools; save attachments into the folder yourself |
Connector permissions are set per tool. In Customize > Connectors, select a connector to see its Tool permissions, grouped into read-only and write/delete tools, and choose Always allow, Needs approval or Blocked for each. For month-end prep, read-only tools can be allowed and everything that writes, sends or deletes should be blocked. If you're an accounting practice rather than an owner, the client-folder version of this set-up is in Claude for accounting firms: safe folder tasks.
How do you set up a month-end folder Claude cannot damage?
Copy every receipt and invoice into one new month-end folder with empty output subfolders, and connect only that folder to Claude, so no original can be changed. Ten minutes of set-up decides whether this is safe. The illustrative example throughout is a six-person signage company: vans, fuel, trade-counter materials (aluminium composite panel, vinyl, LED modules, fixings), subcontract installers and a handful of software subscriptions.
Month-end-2026-10/ (new folder, outside your synced drives)
01-in/ COPIES of every receipt and invoice
02-renamed/ empty: Claude writes renamed copies here
03-statement/ bank CSV export, account number rows deleted
04-workbook/ empty: Claude saves the .xlsx here
README.txt the rules below, so they travel with the folder
- Copy, never move. Originals stay wherever they live now. If anything goes wrong, you delete the month-end folder and start again.
- Trim the bank export. Open the statement CSV and delete the header rows holding the account number and sort code. Claude needs date, description and amount, nothing more.
- Convert awkward files. If your phone saves photos as HEIC, export receipts as JPG or PDF first: HEIC isn't on the list of file types Anthropic says Cowork reads, which covers PDF, Word, Excel, CSV and common image formats.
- Connect only this folder in Claude Desktop. Check which folders Claude Desktop can already reach in its settings, and remove anything broader you granted earlier.
- Set the permission setting in the message box to Manual (the older Cowork layout calls it "Manually approve"). Anthropic's help centre says Auto is rolling out as the default on Pro, Max, Ultra and Team, so check it each time.
- Turn Memory off for this task from the "+" menu before the first message, so supplier amounts don't become part of what Claude remembers about you. It can't be changed once the task starts.
Two plan points sit underneath this. Anthropic says Cowork needs a paid plan (Pro, Max, Ultra, Team or Enterprise), and Claude's pricing page lists Pro at $20 a month billed monthly or $17 a month on an annual subscription ($200 up front). On Free, Pro, Max and Ultra the pricing page marks model training as opt-out, so check your privacy settings; Team plans, from $25 a seat a month billed monthly, don't train on your content by default.
The README rules the folder carries
The README.txt file is there so the rules don't depend on anyone's memory, yours or Claude's. Claude reads it with everything else in the folder, and you can point to it in the prompt. The signage company's version after three months:
RULES FOR THIS FOLDER
- Never change or delete anything in 01-in.
- Amounts: copy exactly as printed. No rounding.
- Supplier names: use the trading name on the document header,
not the card-terminal name on the statement.
- Credit notes are negative amounts and get the flag CREDIT.
- Anything over 1,000.00 goes on the Questions tab as well.
- LED modules and vinyl: category "Stock" (accountant, Aug).
- Tool-hire deposits: Questions tab, never a category.
- If a receipt shows a tip, record the total charged and note the tip.
Two of those rules exist because of things that went wrong. "Use the trading name on the document" was added after Claude named a supplier by the payment processor shown on the card slip, so the same supplier appeared under two names. And "copy exactly as printed" was added after one month's workbook rounded every amount to whole numbers, which made matching to the bank fail on half the rows. Each lesson becomes a line in the README, and the README is in the folder every month.
What prompt turns a receipts folder into a reconciliation workbook?
A single prompt does the job by asking Claude to show a plan first, then save renamed copies and build a multi-tab Excel workbook with bank matches. Main worked example: the signage company's October folder holds 63 receipts (photos and PDFs), 14 supplier invoices and a statement export with 112 lines. The owner opens a new conversation in Claude Desktop and sends:
Work only inside Month-end-2026-10. Before changing anything, show me
your plan and wait for my OK.
1. For every file in 01-in, save a renamed COPY to 02-renamed as
YYYY-MM-DD_Supplier_Gross.ext (e.g. 2026-10-07_TradeCounter_184.20.pdf).
Never rename or delete anything in 01-in.
2. Build 04-workbook/October-prep.xlsx with these tabs:
Documents: one row per file. Columns: original file name, new
file name, document date, supplier, description, net, tax, gross,
paid by (card / transfer / cash / unknown), suggested category,
matched bank line, flag.
Bank: every line from 03-statement, plus match status.
Unmatched: documents with no bank line, and bank debits with no
document.
Checks: file count vs row count; total gross vs total matched
debits; count of flagged rows.
Questions: anything my accountant must decide.
3. Use working Excel formulas for totals and checks, not typed numbers.
4. Matching rule: same amount, bank date within 0 to 5 days after the
document date. One bank line may cover several receipts only if
they add up exactly; say so in the flag.
5. If you can't read a figure, leave the cell empty and flag it
"CHECK IMAGE". Never guess an amount, date or supplier name.
6. Dates on receipts may be day/month. If a date is ambiguous
(e.g. 03/10), flag it "DATE?".
Because the permission setting is Manual, Claude replies with a plan and waits. An illustrative plan, trimmed:
Plan
- Read 77 files in 01-in (63 images/PDF receipts, 14 invoices).
- Write 77 renamed copies to 02-renamed. Nothing in 01-in changes.
- Read 03-statement/oct.csv (112 lines).
- Create 04-workbook/October-prep.xlsx with 5 tabs.
- 2 files look like duplicates (same supplier, amount and date):
IMG_4471.jpg and Invoice-88213.pdf. I'll keep both rows and flag them.
Approve to continue?
That duplicate note is worth the whole exercise: a trade-counter receipt photographed in the van and the same purchase emailed as an invoice would otherwise be claimed twice. Approve, and Claude asks again before each file operation it hasn't been cleared for. Anthropic's help centre says Claude can produce Excel files with working formulas, conditional formatting and multiple tabs, so the Checks tab should contain live formulas such as =COUNTA(Documents!A2:A200) and =SUM(Documents!H2:H200)-SUMIFS(Bank!C2:C200,Bank!E2:E200,"Matched"), not pasted values. Click into a few cells to confirm.
How do you check Claude’s extraction before trusting a row?
Run six checks in sequence before trusting any row: file count, arithmetic, totals, spot-checks, dates and flags. A workbook that looks finished isn't evidence that it's right, and these checks catch nearly everything:
- Count. Files in 01-in must equal rows on the Documents tab. In the example, 77 and 77.
- Arithmetic. Add a column with
=IF(ABS(F2+G2-H2)>0.01,"SUM?","")so any row where net plus tax doesn't equal gross lights up. - Totals. Total gross on the Documents tab against total matched debits on the Bank tab. The difference must be explained by the Unmatched tab, line by line.
- Spot-check one row in ten against the original image, choosing faded thermal receipts and angled photos first.
- Dates. Sort by date and look for anything outside the month; a swapped day and month usually lands a receipt in the wrong month entirely.
- Flags. Every CHECK IMAGE, DATE? and duplicate flag gets resolved by a person, not by asking Claude to have another go.
Here's what a few rows looked like after the first run (illustrative figures):
| New file name | Supplier | Gross | Matched bank line | Flag |
|---|---|---|---|---|
| 2026-10-07_TradeCounter_184.20.pdf | Trade counter | 184.20 | B-031 | |
| 2026-10-09_FuelStation_86.40.jpg | Fuel station | 86.40 | B-038 | |
| 2026-10-03_VinylSupplier_612.00.pdf | Vinyl supplier | 612.00 | None | DATE? (03/10 or 10/03) |
| 2026-10-14_Parking_.jpg | Car park | (empty) | None | CHECK IMAGE |
| 2026-10-21_LEDModules_1,240.00.pdf | LED supplier | 1,240.00 | B-077 + B-078 | Paid in two parts |
The three misreads that turned up
The checks earned their keep on the first run. A builder's-merchant receipt showed a returned item, and Claude took the pre-refund total of $212.60 rather than the $168.10 actually charged; the arithmetic column didn't catch it because the receipt's own lines added up, but the bank match failed, which flagged it. A fuel receipt read $68.40 instead of $86.40, a transposition on a faded thermal slip, caught by the spot-check. And a supplier statement had slipped into the inbox folder alongside the invoices it summarised, so October's purchases appeared twice; the duplicate rule caught most of it, and the count check (78 rows against 77 real documents, once the statement was removed) caught the rest. None of these is exotic. All three would have reached the accountant without the checks.
If the spreadsheet side is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.
How does Claude match receipts to the bank statement, and what stays unmatched?
Claude matches a document to a bank line when the amount is the same and the bank date falls up to five days after the document date, which handles most card spend. The interesting work is in the Unmatched tab, which in the example ended up with 19 lines in four groups:
- Bank debits with no document (9). Mostly software subscriptions and a tool-hire deposit. Claude can't invent receipts, so these become a chase list: log in to each supplier and download the invoice.
- Documents with no bank debit (5). Cash purchases and two invoices on 30-day terms, not yet paid. Mark them as expected next month rather than missing.
- Split payments (3). One invoice paid in two parts, one card payment covering three receipts. Claude can propose these when the numbers add up exactly; you confirm them.
- Bank fees and transfers (2). No receipt expected. Your accountant will tell you how they want these labelled.
If your books are in Xero, its read-only connector gives Claude a second source to compare against: the bills already entered for October, aged payables and bank account transactions. That's a useful extra check (is this supplier invoice already in the books?) without giving Claude any way to change them. How to review matches before reconciling in Xero itself is covered in checking Claude's Xero matches before you reconcile, and the general logic of matching and its failure points is in automating bank reconciliation and checking the matches.
Invoices that arrive by email, and receipts that land in Dropbox
A local folder only holds what someone remembered to save there. Two connector steps close the gaps, and both are worth setting up with deliberately narrow permissions.
Finding unsaved invoices with the Gmail connector
Supplier invoices that arrive as email attachments are the commonest gap. Anthropic's directory describes the Gmail connector as able to search your inbox, summarise threads and draft replies, and its tool list also includes sending, forwarding and trashing messages. Use it to produce a list, not to fetch files:
Search my inbox for emails from 1 to 31 October 2026 that contain an
invoice, receipt or statement from a supplier. List: date, sender,
subject, amount if visible in the email body, and whether a PDF is
attached. Do not reply to, forward or delete anything.
An illustrative result listed 16 emails. Eleven matched invoices already in 01-in. Four were invoices nobody had saved: a sign-board supplier, two software renewals and a courier. One was a supplier's monthly statement, which belongs with the accountant's papers but not in the receipts folder, because it would duplicate every invoice it lists. The fix for the four missing ones is manual and quick: open each email, save the PDF into 01-in, rerun the workbook step. If Gmail's write tools are set to Blocked under the connector's tool permissions, there's no risk of a stray reply or deletion while Claude searches.
The cloud variant: receipts saved straight to Dropbox
Some teams photograph receipts with a scanning app that saves PDFs to a shared Dropbox folder. Anthropic's directory lists Dropbox connector tools for listing, searching, copying, moving, creating folders and deleting. For this job, the permissions look like this:
| Dropbox tool | Setting | Why |
|---|---|---|
| list_folder, search, fetch, get_file_metadata | Always allow | Reading is the whole job |
| create_folder, copy, create_file | Needs approval | Claude makes the month folder and writes the workbook there |
| move, delete | Blocked | Nothing in the team's receipt folder should move or disappear |
| create_shared_link | Blocked | Financial documents shouldn't get public links by accident |
The prompt is the same as the local version, with one change at the start: "Copy every file added to /Receipts/Incoming in October into /Month-end/2026-10/01-in, then continue." Because copying needs approval, Claude asks before it starts, and because move and delete are blocked, the worst a mistake can do is create an extra copy. This route also runs without Claude Desktop being open, which helps if the person doing month-end works across two computers.
Awkward documents and how to word them into the prompt
- Credit notes: tell Claude to record them as negative amounts with a CREDIT flag; otherwise a refund reads as another purchase.
- Foreign-currency subscriptions: record the amount and currency as printed, plus the amount that left the bank, and send the pair to the Questions tab rather than letting Claude pick a rate.
- Multi-page invoices: ask for one row per invoice, not per page, using the total on the final page.
- Deposits already paid: when an invoice shows "less deposit paid", record the balance due as the amount to match, and note the deposit so it can be matched to its own earlier bank line.
- Receipts with tips: match on the total charged to the card, which is what the bank shows.
What should go to the accountant, and what stays their call?
Send your accountant the workbook and the renamed copies together, and leave categories and tax treatment to them. The workbook is preparation, not bookkeeping. Claude's "suggested category" column is a starting point for your accountant, and the Questions tab is where real judgement calls go. In the signage company's October workbook it read like this (illustrative):
QUESTIONS FOR ACCOUNTANT (October)
1. Vinyl cutter bought 21/10 for 2,890.00: equipment or expense?
2. Tool-hire deposit 250.00 (bank line B-052): refundable, how to record?
3. Fuel receipt 2026-10-26: van used for a personal trip that day,
split needed?
4. Subcontract installer invoice 1,450.00: no tax shown on the
invoice. Is their invoice complete?
5. Two subscriptions billed in another currency: which rate to use?
Every one of those is a question about tax treatment or accounting policy, which is exactly where an AI suggestion shouldn't be treated as an answer. Send the workbook and the renamed copies together, keep the original receipts where they always live, and let your accountant decide categories and treatment. If they work in their own software, the renamed files (date, supplier, amount in every name) are far easier to attach to transactions than a folder of IMG_ numbers.
Once your accountant has seen two or three months, ask what they changed and add those rules to README.txt in the folder: "LED modules are always stock", "tool-hire deposits go on the Questions tab". Claude reads the folder each month, so the rules travel with it. If you prefer to keep refining the workbook inside Excel itself, the Claude for Excel add-in works on the same file.
How long does month-end receipt prep take with Claude, and what does it cost?
In the illustrative signage-company example, month-end prep drops from about five hours to roughly 1 hour 35 minutes, on a Pro subscription at $20 a month. Here is the sum. Before: about five hours at month-end, mostly typing receipts into a spreadsheet and hunting for missing ones. After: 15 minutes copying files and trimming the statement, 20 minutes of Claude working while the owner does something else, and around an hour on checks, flags and the chase list. Call it 1 hour 35 minutes, saving roughly three and a half hours a month, for a Pro subscription at $20 a month that most owners already use for other work.
Two practical limits. Anthropic's Cowork page says agentic work uses limits faster than chat, and its help centre suggests checking Settings > Usage if you hit them; a 77-file month can be split into two batches by week if that happens. And resist scheduling it. Scheduled tasks run in the cloud with your connectors and the files saved to your Claude account, and reach a local folder only while your computer is awake with Claude Desktop open. More to the point, Anthropic's safety guidance says not to schedule tasks that access sensitive files. Month-end finance is a supervised task.
The routine, once it's settled:
- Last working day: create the month folder from a saved empty copy, copy receipts and invoices into 01-in, export and trim the statement.
- Run the same prompt, saved in a text file in the folder so wording never drifts. Approve the plan only after reading it.
- Work the six checks and the Unmatched tab.
- Send the workbook, renamed copies and Questions tab to your accountant.
- Delete the month folder from your computer once your accountant confirms receipt, after checking that the originals are safely filed where they always live.
For phone-photo receipts on their own, without Claude Desktop, turning receipt photos into an expense sheet with ChatGPT shows a lighter approach with the same discipline on totals.
If you want help fitting this routine into how your business actually runs, I offer one-to-one AI consultations for small businesses.
Questions about Claude and month-end paperwork
Do I need a paid Claude plan for this?
Yes. Anthropic's help pages say Cowork's capabilities, including working in local folders, need a paid plan: Pro, Max, Ultra, Team or Enterprise. Claude's pricing page lists Pro at $20 a month billed monthly, or $17 a month on an annual subscription. Local folders also need the Claude Desktop app open on your computer.
Can Claude read photos of receipts, not just PDFs?
Yes. Anthropic's Cowork page lists common image formats such as .jpg, .png and .webp alongside PDF, Word, Excel and CSV files. Faded thermal receipts and photos taken at an angle are where misreads happen, so spot-check those rows against the image before trusting the totals.
Should I schedule the monthly receipts run?
I wouldn't. Anthropic's safety guidance advises against scheduling tasks that access sensitive files, and scheduled tasks reach local folders only when your computer is awake with Claude Desktop open. Run month-end prep yourself, in Manual mode, and keep scheduling for low-risk jobs such as reminders.
Can Claude post the transactions into my accounting software?
Some connectors can write: Anthropic's directory lists QuickBooks tools that create and update invoices. For month-end prep, keep Claude to reading and producing the workbook, and let you or your accountant post entries. Set any write tools to Needs approval or Blocked under Customize, Connectors.
How can Claude sort receipts and invoices for reconciliation?
Copy receipts, invoices and a trimmed bank-statement export into one dedicated folder, connect only that folder in Claude Desktop, set permissions to Manual and send one prompt that asks for a plan first. Claude then renames copies and builds a workbook with matches and flags, and you check the rows before your accountant sees it.
Further reads
- AI Receipt Capture and Bank Categorisation: A Bookkeeper's Setup — How a bookkeeper sets up receipt capture and bank rules.
- Catch-Up Bookkeeping With AI: Rescue Months of Untouched Books — When months of paperwork have piled up, not just one.
- Claude (Formerly Cowork) vs ChatGPT Work: Which Cuts Owner Admin? — How Claude compares with ChatGPT Work for owner admin.
- Owner-Operator Expense Categories: Sort Receipts and Fuel With AI — A monthly routine: photograph receipts, sort fuel and card lines into categories, check totals and hand the accountant a clean summary.
Browse all AI-for-business tutorials
Sources: claude.com (Cowork is now Claude announcement, Cowork product page, pricing, connectors directory pages for Xero, QuickBooks, Google Drive, Dropbox and Gmail), Claude help centre (Claude Cowork and chat are one Claude; Get started with Claude Cowork; Use Claude Cowork safely; Schedule recurring tasks; connector tool permissions). Checked 17 and 18 November 2026.
