Let me be honest with you.
Every month, I dread compliance week.
Not because I don’t understand the numbers, but because turning a bank statement into proper accounting entries, tracking down payment gateway fees, identifying GST implications, and making sure everything ties to the last rupee… that process has always been manual. And manual means slow, and slow means I push it to the last possible day.
This February, I decided to try something different. I handed all of it to Claude Cowork.
Here’s what happened, step by step, no theory, just the actual workflow.
What I Started With
Three files:
A bank statement CSV from My Bank: 22 transactions, 01–28 February 2026
A Cashfree transactions CSV: 200 rows of payment gateway settlement data
A Cashfree tax invoice PDF: the GST invoice for processing fees (HSN codes, IGST, everything)
No Excel template. No journal entry format. No prior setup. Just three raw files dropped into the workspace folder.
The Workflow: What I Typed, What Claude Did
Step 1: Journal Entries from the Bank Statement
My first prompt was simple:
Prompt → Debit Entries and Credit Entries Connecting to Sales invoices Purchase invoices in Bank Statement in Excel with an Explanation. I need this for the month of February from 1st of February to 28th of February 2026.
What came back: a 5-sheet Excel workbook.
Bank Statement tab: all 22 transactions with a running balance column
Journal Entries tab: full double-entry lines for every transaction, with narrations
Sales Invoices tab: categorised receipts
Purchase Invoices tab: categorised payments (bank charges, software subscriptions, taxes, transfers)
Summary tab: opening balance, total receipts, total payments, closing balance
Every debit had a matching credit. Every line was labelled. The closing balance matched the bank statement to the rupee.
Step 2: “Can You Recheck Everything?”
I got a little confused looking at the summary sheet.
In double-entry accounting, the journal totals always appear equal on both sides, that’s how the system is designed. I didn’t know that. So I asked Claude to explain it, recheck every number, and rebuild the summary so it was clear to a non-accountant.
It did exactly that. Broke it down into plain language. Rebuilt the sheet.
The closing balance matched the bank statement exactly.
Zero discrepancy.