The source stays the source
The workbook you were sent is kept as an original. Imported rows are never edited — adjustments, splits and overrides are separate records that carry their reason.
Forty Seven Lab · 47 Financials
From trial balance
to financial statements.
47 Financials reads a current-year trial balance and last year’s signed report, maps every account to a statement heading, reconciles the movements and validates the arithmetic — then prepares the report from the figures you approved.
- Workflow
- Seven guided stages
- Arithmetic
- Exact decimals
- Gate
- FS approval before reporting
- Output
- Versioned DOCX and PDF
Assets
Cash and bank balancesTrial balance139,060420,730
Accounts and other receivablesTrial balance789,700729,710
Closing stockProfessional input615,240542,180
Due from related partiesTrial balance82,00076,000
Property and equipmentPPE schedule2,184,0001,856,000
Total assets3,810,0003,624,620
Liabilities
Accounts payables and accrualsTrial balance561,000517,220
Employee benefit obligationsTrial balance132,500118,400
Bank borrowingsTrial balance375,000595,000
Total liabilities1,068,5001,230,620
Equity
Share capitalPrior signed report1,000,0001,000,000
Legal reservePrior signed report194,000194,000
Retained earningsCalculated1,547,5001,200,000
Total equity2,741,5002,394,000
Total equity and liabilities3,810,0003,624,620
- 10 statement checks pass
- Property and equipment reconciled — differences QAR 0
- 0 blockers at report stage
Rendered from the demonstration engagement — FY 2025 with FY 2024 comparatives, every figure traceable to a source row.
What it is
Bring the source files. 47 Financials turns them into structured financial statements and a professional report.
It is not bookkeeping software and it is not a dashboard over a ledger. 47 Financials works on the part of the engagement that is repetitive but unforgiving: turning a trial balance plus a prior-year signed report into statements that foot, a PPE note that reconciles, a validated comparative column — and then a report that was built from exactly the figures that were approved.
Statements are constructed, not retyped
Financial position, profit or loss, equity, cash flow and the PPE note are built from mapped accounts, so a change to a mapping flows through every statement and the report.
Automation stops where judgement starts
The application prepares, reconciles and checks. It does not form an opinion, and it does not approve its own output — that stays with the accountant.
Source in: trial balance (.xlsx, .xls, .csv) · prior-year signed report (.pdf, .docx) · the firm’s report template
Output: financial statements with comparatives · notes · structured audit report · versioned DOCX and PDF
Follow the workflowThe product
Seven stages, and the application holds you to each one.
The order matters: sources are confirmed before they are interpreted, mappings are resolved before statements are built, movements are reconciled before validation, and validation passes before anything is approved or produced. Every panel below carries the engagement’s own data.
01Source documents
Bring in the workbook and the prior report.
A current-year trial balance (Excel or CSV) and the prior-year signed report (PDF or DOCX) are uploaded as sources. The workbook's worksheet, header row and amount columns are confirmed explicitly — the application will not silently choose them for you.
- Trial balance: .xlsx, .xls or .csv — worksheet, header row, account code, description and debit/credit columns are all chosen by the preparer
- Prior report: PDF or DOCX, read for its reporting period, sections, statement rows, note titles and PPE classes
- Imported rows keep their workbook, worksheet and source-row lineage for the rest of the engagement
- Files belong to the project: nothing is carried across from another client by default
Northbay-Trading-TB-2025.xlsxCurrent-year trial balance
Ready- Worksheet
- TB Dec 2025
- Header row
- 4
- Rows imported
- 26
- Total debit
- 9,612,500
- Total credit
- 9,612,500
- Difference
- 0
Northbay-Trading-Report-2024.docxPrior-year signed report
Ready- Reporting period
- 31 December 2024
- Sections
- opinion, position, P&L, equity, cash flow, notes
- Statement rows
- 27
- PPE classes
- 3
- Note titles
- 21
- Comparatives
- Sourced
02Trial balance
The workbook is checked before anything is built on it.
Import happens through the numbers themselves: debit total, credit total and the difference are shown as figures. Duplicate account codes and rows with no description are listed by source row, so a broken workbook is visible at the start of the engagement rather than after the statements are prepared.
- Total debit, total credit and the difference are stated, not ticked
- Accounting values are handled with exact decimal arithmetic — never floating point
- Splits, adjustments and materiality overrides are recorded separately and keep their reason
- Every later figure can still be traced back to a workbook, worksheet and source row
RowCodeAccount nameDebitCredit
51010Cash in hand18,450—
61020Bank - current account120,610—
71030Accounts receivable742,900—
81040Closing stock615,240—
91050Prepaid expenses46,800—
101060Due from a related party82,000—
111110Property and equipment - cost2,980,000—
121120Property and equipment - accumulated depreciation—1,010,000
131130Motor vehicles - cost332,000—
26 rows imported · worksheet TB Dec 2025 · header row 49,612,5009,612,500
Difference0
03Classification
Every account is mapped to a statement heading.
Each row is matched to a primary financial-statement heading and, where relevant, a note detail. Deterministic rules and prior-report matches suggest the classification, and the suggestion keeps its source and confidence on screen — so the reviewer can see why a heading was proposed.
- Suggestion source is explicit: deterministic rule, previous-report match, known mapping, or manual
- Confidence is shown per row; headings such as capital, related parties, loans and tax are never auto-confirmed
- An account that belongs in two places can be split, and the split must reconcile to the source balance exactly
- Unresolved rows block the next stage — the workflow does not proceed on an unfinished mapping
Cash in handTB row 5 · 1010
Cash and bank balances
rule18,45098%
Confirmed
Bank - current accountTB row 6 · 1020
Cash and bank balances
rule120,61098%
Confirmed
Accounts receivableTB row 7 · 1030
Accounts and other receivables
previous report match742,90097%
Confirmed
Closing stockTB row 8 · 1040
Closing stock
previous report match615,24096%
Confirmed
Property and equipment - costTB row 11 · 1110
PPE cost - Property and equipment
previous report match2,980,00090%
Confirmed
Cost of salesTB row 22 · 5010
Direct cost
manual3,146,000100%
Confirmed
Other incomeTB row 21 · 4020
Revenue
manual(42,000)100%
Confirmed
Prepaid expensesTB row 9 · 1050
Accounts and other receivables
manual46,800100%
Confirmed
04Construction
Statements built from the mapping, not retyped.
Financial position, profit or loss, changes in equity, cash flow and the property-and-equipment note are constructed from the mapped accounts. The comparative column comes from the prior-year signed report, so the two years are presented on the same headings.
- Current-year figures come from the trial balance; comparatives come from the prior audited report
- The source of every figure is carried with the figure — trial balance, prior report, PPE schedule or professional input
- Balance sheet, profit or loss, equity movement and cash flow are generated together and must agree
- The PPE note reconciles audited opening balances to the mapped closing balances, class by class
Assets
Cash and bank balancesTrial balance139,060420,730
Accounts and other receivablesTrial balance789,700729,710
Closing stockProfessional input615,240542,180
Due from related partiesTrial balance82,00076,000
Property and equipmentPPE schedule2,184,0001,856,000
Total assets3,810,0003,624,620
Liabilities
Accounts payables and accrualsTrial balance561,000517,220
Employee benefit obligationsTrial balance132,500118,400
Bank borrowingsTrial balance375,000595,000
Total liabilities1,068,5001,230,620
Equity
Share capitalPrior signed report1,000,0001,000,000
Legal reservePrior signed report194,000194,000
Retained earningsCalculated1,547,5001,200,000
Total equity2,741,5002,394,000
Total equity and liabilities3,810,0003,624,620
05Professional input
The movements a trial balance cannot explain.
Where a closing balance depends on information that is not in the workbook — additions and disposals, closing inventory, capital movements — the application asks a specific question rather than assuming an answer. The question arrives with the prior-year figures and the current trial-balance figures already shown.
- Questions are generated from the mapped accounts, the prior report and the movement rules
- PPE is reconciled per class: opening audited cost and accumulated depreciation + additions − disposals − charge = closing trial balance
- The reconciliation is displayed as differences, so a non-reconciling class is obvious
- Answers are saved with the project, and any change after approval invalidates the approval
Fixed assets · PPE_ MOVEMENT_001
Property and equipment
Enter the actual movements needed to reconcile prior audited balances to the current trial balance.
PPE reconciliationReconciledCost difference QAR 0Accumulated depreciation difference QAR 0
06Validation
Nothing is produced until the checks pass.
A set of calculated controls runs across the project. They are not display states: a failed control blocks approval, and approval is what releases the report stage.
- Trial balance balanced, and material mappings resolved
- Professional input complete, and movements reconciled
- Financial position, profit or loss and equity roll-forward agree
- PPE schedule and depreciation reconciled, inventory reflected
Trial balance balancedDebit and credit both amount to QAR 9,612,500; difference 0.
Material mappings resolvedAll 26 source rows carry a confirmed statement heading.
Professional input completeEvery generated movement question has an answer on record.
Movement reconciliationAsset and liability movements agree with the prior audited balances.
Statement of financial positionAssets equal liabilities and equity.
Statement of profit or lossSubtotals and totals agree with the mapped accounts.
Statement of changes in equityOpening reserves plus profit agree with closing equity.
Property and equipment scheduleEach class reconciles cost and accumulated depreciation.
Depreciation reconciliationThe charge per class equals the depreciation in the statements.
Inventory adjustmentClosing inventory is reflected in the trial balance.
I reviewed the mappings, adjustments, professional inputs and financial statements.Approval freezes the source-backed statement dataset used by report generation.
07Reporting
Assembled from the approved figures only.
When the statements are approved, the report is prepared from that frozen snapshot: cover, contents, auditor's report, statements, notes and the ownership table. Financial tables in the report are bound to the approved version — the report never recalculates them.
- Report generation is unavailable until the financial statements are explicitly approved
- Values are locked to the approved statement version and marked as such in the editor
- Audit opinion wording comes from the firm's template and is never generated
- Editable narrative sits beside locked tables; blockers and review items are listed before export
- Output is versioned DOCX and PDF, generated from the approved structure
—CovercoverpreparedEditable wording
—Table of contentscontentspreparedLocked to approved data
1Independent auditor's reportauditor reportpreparedEditable wording
2Statement of financial positionfinancial statementpreparedLocked to approved data
3Statement of profit or lossfinancial statementpreparedLocked to approved data
4Statement of changes in equityfinancial statementpreparedLocked to approved data
5Statement of cash flowsfinancial statementpreparedLocked to approved data
6Notes to the financial statementsnotesneeds reviewLocked to approved data
7Shareholders and ownershipownership tablepreparedLocked to approved data
The statements
Five working papers that stay tied together.
Change a mapping, an answer or an adjustment and the statements, the PPE note and the cash flow are recalculated together. The comparative column is not typed in — it is carried from the prior-year signed report.
Financial position
Assets, liabilities and equity with the audited comparative column.
Assets
Cash and bank balancesTrial balance139,060420,730
Accounts and other receivablesTrial balance789,700729,710
Closing stockProfessional input615,240542,180
Due from related partiesTrial balance82,00076,000
Property and equipmentPPE schedule2,184,0001,856,000
Total assets3,810,0003,624,620
Liabilities
Accounts payables and accrualsTrial balance561,000517,220
Employee benefit obligationsTrial balance132,500118,400
Bank borrowingsTrial balance375,000595,000
Total liabilities1,068,5001,230,620
Equity
Share capitalPrior signed report1,000,0001,000,000
Legal reservePrior signed report194,000194,000
Retained earningsCalculated1,547,5001,200,000
Total equity2,741,5002,394,000
Total equity and liabilities3,810,0003,624,620
The application
This is the software, not an illustration of it.
47 Financials is an invite-only application. What follows is the running product on the demonstration engagement — the workspace, the source documents arriving, the imported trial balance and the report being assembled.
AI and rules
Interpretation where it is needed. Arithmetic where it counts.
47 Financials uses a language model for reading and suggesting, and deterministic code for everything that becomes a figure. The two are deliberately separated.
AI assists with
- Reading uploaded documents and their layouts
- Recognising report sections, headings and note titles
- Suggesting an account classification, with a rationale
- Interpreting the firm's report template
Model responses are schema-validated before use, and the vendor key stays on the server.
Deterministic code owns
- Decimal arithmetic on every amount
- Mapping rules and prior-report matching
- Statement, PPE and cash-flow construction
- Balance, cross-foot and reconciliation checks
- The approval gate and report versioning
Classification suggestions are never written into a calculation directly — a mapping is a record a person can see and change.
Document
Interpretation
Structured data
Rule engine
Validated output
Reliability
Long before “accurate”, the requirement is honest.
A reporting tool is only as useful as its willingness to stop. These are the rules the application is built around — they are the reason the workflow has gates instead of shortcuts.
Exact decimal arithmetic
Financial values are calculated with decimal arithmetic. JavaScript floating point is never used for an accounting amount.
AI cannot write a figure
Model output is schema-validated and limited to reading and suggesting. It does not feed the statements, the cash flow or the report tables.
Source rows are immutable
The imported trial-balance rows are never edited. Splits, adjustments and materiality overrides are separate records, each with its reason.
Approval is a gate
Report generation stays unavailable until the statements are approved, and a later change to a source, mapping or answer invalidates that approval.
Unknowns are surfaced
When a comparative or cash-flow value cannot be established, the project says so and blocks report generation. It does not substitute a silent default.
Wording is never generated
The audit opinion comes from the firm's own uploaded template. The auditor's identity and signature remain a professional responsibility.
Where the information needed for a figure is not present, 47 Financials says so — a comparative stays unknown and report generation stays blocked. Nothing is quietly filled in to keep the process moving.
Before and after
The repetitive part is the part that should be engineered.
This is not a claim that professional judgement disappears. It is a claim about where the time goes.
- Receive the trial balance
- Open the workbook and find the usable sheet
- Map accounts to headings by hand
- Open last year's signed report
- Retype the comparatives
- Rebuild the statements in Excel
- Reconcile the PPE note
- Cross-check totals
- Update the Word report
- Review, find differences, repeat
- Upload
- Structure
- Map
- Reconcile
- Validate
- Approve
- Generate
The repetitive processing becomes software. The judgement stays where it belongs.
Who it is for
Designed around the realities of financial reporting.
47 Financials is being built with the people who prepare and review statements, and it is deliberately narrow: it prepares statements and reports, it does not post transactions and it does not form an opinion.
We are not claiming a client list. 47 Financials is built at Forty Seven Lab, and the workflows it is designed for are described below rather than implied by logos.
Accountants
Preparing a set of financial statements from a trial balance and last year's signed report.
Auditors and audit practices
Repeating the same statement and report preparation for many clients each year.
Finance and reporting teams
Closing the year and needing the statements, the notes and the comparatives to agree.
Professional services firms
Where a client's workbook arrives in whatever shape the client keeps it in.
Built continuously
What exists, what is being built, what is only an idea.
The product is in active development. These three lists are kept honest and separate.
- Seven-stage guided project workflow, from company setup to report output
- Flexible trial-balance parsing with source-row traceability and exact-decimal validation
- Prior-year comparatives kept separate from the trial balance, with page and label provenance
- Deterministic PPE, partner, capital, loan and disappeared-account question rules
- Draft statement generation with balance, profit-or-loss and cross-foot checks, and an approval gate
- Approval-bound, versioned DOCX and PDF export populated from the reviewed project data
- Template substitution across body, header, footer, footnote and endnote runs
- Invite-only accounts with per-user project isolation and private source-document storage
- Report export presentation — typography, statement rules, landscape notes and page numbering are being refined against reference documents
- Alignment checks for prior-report headings, so an unfamiliar heading set is flagged for review before it hides a comparative
- A firm-level workspace: the data model already reserves an organisation scope, but team administration is not exposed
- Published case studies — nothing will be published until a real workflow can be shared with permission
Contact
Working with trial balances, spreadsheets and signed reports every month?
Tell us how you prepare statements and reports today — what arrives from the client, what you rebuild by hand, and where the time goes. If it is a fit for 47 Financials, we will show you the workflow on your own kind of file. Access to the application is invite-only.
- One client or a hundred — the preparation path is the same
- Bring a trial balance shape you actually receive
- We will tell you plainly what the application does not do yet
Email info@fortysevenlab.comMessage us on WhatsApp
Already have access?
Open 47 FinancialsAccess to the application is invite-only. Messages go to the Forty Seven Lab team, not to a sales queue.