How to Use Claude for Financial Reporting From a Trial Balance

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use Claude for Financial Reporting From a Trial Balance.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use Claude for Financial Reporting From a Trial Balance.

Use Claude to turn a trial balance into a monthly reporting pack by uploading a clean export, supplying an approved account map and requesting a workbook with traceable calculations. Check debit and credit totals, reconcile every report to the ledger, then ask your accountant to approve classifications, adjustments and commentary before relying on it.

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 now

A trial balance is a list of ledger account balances. Equal debit and credit totals are an essential control, but they do not prove that every entry belongs in the correct account or month. Claude should prepare a draft management pack with visible exceptions; it should not quietly repair the books or certify the numbers.

What should a first Claude monthly reporting pack include?

A first monthly pack from Claude should stay small: a profit and loss statement, a balance sheet, a comparison with the previous period, an exceptions sheet and one page of commentary. The profit and loss statement explains income and expenses over a period. The balance sheet shows assets, liabilities and equity at a point in time. A cash-flow forecast is a different deliverable and needs more than a closing trial balance.

Claude's file-creation documentation says it can analyse uploaded CSV data and create downloadable Excel workbooks with working formulas, Word documents and PDFs, up to 30 MB per file for uploads and downloads. The feature is on by default on Free, Pro, Max and Ultra. If no download appears, check that Code execution and file creation (called Create and edit files in the newer Settings layout) is switched on under Settings > Capabilities. Creating files uses more of your usage limit than ordinary chat, and none of it validates the accounting.

Start with the account map your accountant uses. An account map assigns each ledger account to a reporting line, such as materials, wages or trade receivables. Without it, Claude may group similar names incorrectly. Do not let “repairs”, for example, stand for both maintenance expenses and customer repair income merely because the labels share a word. Preserve account codes as the matching key.

The QuickBooks and PayPal close packet handles collecting and explaining source records. This reporting workflow begins once the trial balance and supporting ledger are available. Keeping those jobs distinct helps you identify whether a mismatch comes from incomplete bookkeeping, an export setting or the reporting transformation.

Why freeze the trial balance export before Claude reads it?

Freeze the export first by saving an untouched source export and recording the business identifier, reporting period, accounting basis, currency, export time and whether the period is still open. Use the same basis and currency in every comparison. A profit figure prepared on one basis should not be compared with another without explanation. Ask the accountant which export settings are appropriate rather than asking Claude to infer them from headings.

Useful columns are account code, account name, debit balance, credit balance and period label. If the system exports one signed balance, document what positive and negative mean before conversion. Retain all accounts, including zero balances where useful for continuity. Remove report titles, repeated headers and totals from the data table, but retain the original report alongside the cleaned copy so changes remain visible.

For an illustrative bakery, a control sheet might read: “First month of financial year; income and expense balances cover this month; balance-sheet accounts include brought-forward balances; USD; debit total $92,000; credit total $92,000.” This is a deliberately simplified example. In later months, closing income balances may be cumulative: use current-month ledger movements or a correctly configured monthly report instead of labelling year-to-date balances as one month's results.

Check the export by opening it yourself. Look for account codes converted to scientific notation, blank debit cells represented as dashes, parentheses around credit figures and commas treated as decimal marks. If account 00120 becomes 120, retain a text version before mapping. The data-cleaning tutorial provides broader techniques; here, every transformation needs a control total and a reason.

Turn a $92,000 trial balance into two connected statements

The following illustrative adjusted trial balance is for the bakery's first reporting month of its financial year. Opening capital and retained earnings are combined only to keep the example compact. Income and expense balances therefore describe the month; asset, liability and equity accounts include opening positions. No tax computation or statutory presentation is attempted. Ask your accountant to adapt the structure to your business.

AccountDebitCreditApproved destination
Bank$18,000$0Cash
Trade receivables$12,000$0Receivables
Inventory$5,000$0Inventory
Equipment cost$20,000$0Equipment, gross
Accumulated depreciation$0$5,000Deduct from equipment
Trade payables$0$9,000Payables
Loan$0$15,000Borrowings
Opening capital and retained earnings$0$21,000Opening equity
Sales$0$42,000Revenue
Cost of sales$22,000$0Cost of sales
Wages$10,000$0Operating expenses
Rent$3,000$0Operating expenses
Utilities$1,000$0Operating expenses
Depreciation expense$1,000$0Operating expenses
Total$92,000$92,000Difference $0

The expected profit and loss calculation is revenue $42,000 less cost of sales $22,000, giving gross profit $20,000. Wages, rent, utilities and depreciation total $15,000, leaving profit of $5,000 before any items excluded from this simplified example. Gross margin is $20,000 divided by $42,000, or approximately 47.6%. Retain full precision in the workbook and round only the displayed figure.

The balance sheet should show bank $18,000, receivables $12,000, inventory $5,000 and net equipment $15,000: total assets $50,000. Payables and borrowings total $24,000. Opening equity $21,000 plus the month's $5,000 profit equals closing equity $26,000. Liabilities plus equity therefore total $50,000. A separate control cell should show assets less liabilities less equity equals zero.

Ask Claude to explain how current profit reaches equity without adding it twice. If its balance sheet reports equity $31,000, inspect whether it both included a profit account and added the profit and loss result again. A balanced source can become an unbalanced report through that presentation error. The workbook should expose each component rather than hide the difference in a line called “other”.

What workbook structure makes errors visible?

Ask Claude for separate Source, Mapping, Statements, Comparisons, Checks and Questions sheets, a structure that makes errors visible. These are proposed workbook names, not special Claude features. Source contains the exact exported data. Mapping contains one reporting destination per account. Statements calculates the pack. Comparisons holds approved prior figures. Checks shows differences and coverage. Questions lists unresolved matters with source references and the person responsible for answering them.

Create a draft monthly management reporting workbook from these files.
Keep the source export unchanged on its own sheet. Use account codes
to apply the supplied mapping. Show formulas for statement totals,
gross margin, period comparisons and control differences.
Stop and list unmapped or multiply mapped accounts. Do not post entries,
invent missing amounts, infer causes or plug a balancing difference.
Separate verified calculations from questions for the accountant.
Use the period and accounting basis stated in the control sheet.

For the bakery, a Checks sheet that passes should read like this illustrative extract: source debits $92,000, source credits $92,000, difference $0; accounts in the export 14, accounts mapped 14, unmapped 0, mapped twice 0; assets $50,000 less liabilities $24,000 less equity $26,000 equals $0; statement profit $5,000 equals Source revenue less Source expenses, $5,000. Every one of those figures should be a formula pointing at Source or Mapping, so a changed export changes the checks too.

Request both a formula-based workbook and a plain-language explanation of its checks. Download and open the workbook in your usual spreadsheet software, then recalculate it. Inspect whether totals are formulas or typed values, and whether formulas reference the expected rows. A green “passed” cell is unhelpful if it contains the word passed rather than a calculation comparing the relevant amounts.

Test one copied figure after saving a clean baseline. Increase utilities from an illustrative $1,000 to $1,100 in a separate test copy, keeping the exercise clearly marked as a test. Profit should fall by $100. The trial balance control should also reveal the unmatched change because no offsetting entry was supplied. This checks the report's dependencies without pretending the altered copy is valid bookkeeping.

Then restore the untouched figures. Ask for a coverage check showing source account count, mapped account count, unmapped count and duplicate-map count. “All amounts included” can conceal a duplicated account and an omitted account with equal values. Counting account identifiers as well as summing balances makes that kind of accidental cancellation harder to miss.

If the workbook side is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.

Which small exceptions deserve their own tests?

Test each exception on its own, starting with any account that has no mapped destination: Claude should list it on the Questions sheet, not drop it from the pack.

An unmapped charge is an unanswered question

Suppose an illustrative $240 card-processing expense appears under a new account code. The map has no destination. Claude should put it on Questions with its code, balance and proposed classification for review. It should not drop it from expenses or silently add it to materials. Ask the accountant to approve the map change, then rerun the complete pack and document the difference in reported profit.

A duplicated export row can preserve a misleading story

A CSV assembled from two overlapping exports includes the same $680 expense account row twice. If the associated credit row was also duplicated, debit and credit totals might still balance. Compare account identifiers and the source export totals, not only whether debits equal credits. The correct action is to resolve the duplicated extraction, preserve the originals and regenerate the reporting input.

A credit balance is not automatically income

An illustrative $300 supplier credit sits in a materials account. Its credit sign reduces that expense under the approved mapping; it should not become sales income just because it is a credit. Ask Claude for the account-level movement behind unusual signs. If the credit relates to a different period or inventory treatment, leave the classification for accountant review rather than making a blanket rule.

A rising revenue percentage needs a valid denominator

If prior revenue was $38,000 and current revenue is $42,000, the increase is $4,000 divided by $38,000, approximately 10.5%. If the prior figure was zero, a percentage growth calculation is not meaningful in the same way. Require “not comparable; previous period zero” instead of an enormous invented percentage. Use the absolute change and explain the missing comparison basis.

A cumulative export can impersonate a strong month

Imagine year-to-date sales of $120,000 after three reporting months, compared with $78,000 at the previous month-end. Subject to consistent scope and approved adjustments, the difference is $42,000. Calling the entire $120,000 current-month sales would distort every ratio. Ask for both period labels and the derivation of monthly movements; confirm the approach with the accountant before applying it to the remaining accounts.

Bank balance and profit answer different questions

The bakery's illustrative $18,000 bank balance and $5,000 profit are not a cash-flow reconciliation. Borrowing, asset purchases, unpaid customer invoices and supplier payments can move cash differently from profit. A useful sample output says, “Cash movement cannot be explained from these closing balances alone; opening balances and transaction detail are required.” Remove any commentary that treats profit as the amount available to spend.

How do you reconcile the pack to records outside it?

Reconcile the pack with three separate checks: statement lines to mapped source accounts, source accounts to the original ledger report, and control accounts to supporting evidence. Repeating the same spreadsheet sum twice does not establish that the underlying bank, customer or supplier records agree.

For bank accounts, obtain the completed reconciliation and statement balance. Intuit's reconciliation guidance explains comparing transactions and investigating a non-zero difference, including checking opening and ending balances. Do not ask Claude to create an unexplained adjustment just to remove a difference. A zero result needs a traceable explanation of what was matched.

For the illustrative bakery, the receivables ledger should support the $12,000 trial balance figure and the payables ledger the $9,000 figure, using the same reporting cut-off. If the customer schedule totals $11,500, list the $500 difference with the reports used and the extraction settings. The difference could reflect a scope or posting issue; the pack should not guess which without transaction evidence.

Check inventory against the approved valuation schedule and equipment against the asset register. Ask the accountant whether depreciation, accruals, prepayments and other adjustments are complete. An accrual records an expense incurred but not yet fully reflected in the ordinary documents; a prepayment spreads a payment across periods it relates to. Claude can list possible missing evidence, but the accountant decides the appropriate entries and treatment.

Use the accountant reconciliation workflow when the pack depends on a more detailed spreadsheet check. Keep a status for each control: matched, explained timing difference, awaiting evidence or awaiting accountant decision. Do not allow the phrase “reviewed” to cover all four states. Readers should be able to see which numbers are still provisional.

If you want help fitting a monthly pack like this into how your business actually runs, I offer one-to-one AI consultations for small businesses.

When should Claude write the commentary?

Ask Claude for commentary only after the current and prior-period figures are approved and have stopped moving. Give it an approved current and prior-period table. For illustration, prior revenue is $38,000, cost of sales $19,000 and operating expenses $14,800, leaving profit $4,200. Current revenue $42,000, cost of sales $22,000 and operating expenses $15,000 leave $5,000. Revenue rose approximately 10.5%, profit rose approximately 19.0%, and gross margin fell from 50.0% to 47.6%.

A useful illustrative commentary is: “Revenue increased by $4,000 and profit by $800. Gross margin fell by around 2.4 percentage points. Review sales mix, materials usage and purchase prices to explain the change.” Those final items are questions to investigate. They are not established causes. Require a source reference for each factual sentence and a separate label for any hypothesis.

Compare that with a weak draft: “Strong demand and supplier inflation drove the result.” Neither claim follows from the trial balance alone. Replace it with a request for order quantities, prices and comparable supplier records. Keep the narrative short enough that an owner can connect every number to a statement line. When adjustments change the figures, regenerate the narrative rather than editing only the headline profit.

For a loss-making month, ask for neutral wording and a practical question. An illustrative loss of $2,000 on $20,000 revenue should not be called “a temporary setback” without evidence about future trading. Appropriate wording is: “The period shows a $2,000 loss; identify recurring expenses and one-off items with the accountant before deciding what changes are needed.”

How do you hand the pack to your accountant for approval?

Plan the first hand-over to your accountant as three illustrative 30-minute blocks: preparing files, inspecting the workbook and resolving questions. These are planning allowances, not vendor timings. If the source map is incomplete, spend the session fixing the map rather than polishing charts. Retain a manual spreadsheet route so the reporting deadline does not depend on one AI session finishing.

At the time of writing, the Claude pricing page includes file creation on Free and lists Pro at $20 a month billed monthly, or $17 a month on an annual plan. Paid plans also add Claude Sheets, a beta spreadsheet with formulas you can check and change inside Claude; this tutorial sticks to a downloaded workbook so the same steps work on Free and the accountant receives an ordinary file. Start with the access you have, and pay for more only if a representative pack shows that usage is the constraint. Include owner preparation, accountant review and correction time in the cost; a subscription does not replace professional review.

Send the workbook, untouched exports, account map, reconciliation evidence, commentary and open-question list together. Label the version draft until the accountant approves it. Ask for explicit decisions on new classifications and any suggested adjustments. Once changes are posted through the normal bookkeeping process, export a fresh trial balance, rerun the pack and retain the superseded version for comparison.

If an illustrative $450 expense arrives after the first draft, ask whether it belongs in the reporting period and whether it is already reflected through an accrual. Record the accountant's decision before changing the pack. Simply subtracting $450 from profit in the PDF would leave the workbook and ledger inconsistent, and could count the expense twice. Use an adjustment log with the original amount, approved change, ledger reference and revised report version so the next reviewer can follow the full chain.

Finish with a compact approval record: reporting period, source export, map version, control differences, unresolved items, accountant reviewer and owner acceptance. The monthly pack is ready for decisions when its numbers can be traced, its limitations are visible and the responsible people agree what it represents. An attractive PDF is the final presentation layer, not the evidence that makes the report dependable.

Further reads

Sources: Anthropic, Create and edit files with Claude; Claude pricing; Claude Artifacts page. Intuit, Fix issues at the end of a reconciliation in QuickBooks Online. Product capabilities checked 18 November 2026. All accounting figures are simplified illustrations for a management pack, subject to accountant review.

Have a specific process in mind?

Describe the job in your own words on a 1:1 call and I'll show you what AI you can use for it with the tools you already pay for.

Book a 1:1 call with me