From trial balance to lead schedules to financial statements
Rekeying a client's trial balance into Excel lead sheets is slow and error-prone. Stowbill imports the trial balance as exported from the client's accounting system, maps each account to a lead schedule, and builds draft financial statements that update as you record adjustments.
Import from the systems your clients use
Upload a CSV or Excel file from Tally, QuickBooks, Xero, Zoho Books, Sage or a client's own spreadsheet, for the current year and the prior year. Stowbill finds the header row even under a title block, and reads:
- Separate Debit and Credit columns, or a single signed balance column
- Balances with Dr and Cr suffixes, as Tally exports them
- Negatives in brackets, and Indian-style digit grouping such as 1,25,000
- Account codes where present, while skipping total and difference rows
Automatic mapping to lead schedules
Each account is mapped to a lead schedule using its name and the sign of its balance: cash and bank, receivables, inventories, property and equipment, payables, borrowings, equity, revenue, cost of sales, operating expenses, finance costs and tax. Change any mapping in one click; manual mappings are remembered when you re-import and applied to the matching account in the other year.
Lead schedules that support review
- Current year, prior year and percentage change for every lead.
- Overall, performance and clearly trivial materiality recorded on the engagement.
- Leads whose movement is at least performance materiality and at least 10% are flagged for explanation.
- Explanation, cross-reference to working papers, and preparer and reviewer sign-off on each lead.
Adjustments and the ISA 450 summary
Record proposed journals as balanced entries. Booked adjustments flow into the final figures and the statements. Unadjusted misstatements feed a summary that shows their total effect on profit against overall materiality and the clearly trivial threshold.
Draft financial statements
Stowbill builds a statement of financial position and a statement of profit or loss with comparatives, adds profit for the year to equity, and checks that assets equal equity and liabilities. Print it or save it as PDF as a starting point. You still choose the applicable framework (full IFRS, IFRS for SMEs or, in Pakistan, ICAP's AFRS for small-sized entities) and add the notes it requires.
Questions
Do we need to clean the export first?
Usually not. Title rows above the header and total rows at the bottom are handled. The file needs an account name column and either Debit and Credit columns or one balance column.
Does it produce final, issuable financial statements?
No. It produces draft primary statements to check against the client's accounts. Notes and disclosures are prepared separately.
Can we use our own lead codes?
The default set follows common audit practice. Firm-specific lead codes are on our roadmap.
Last reviewed 27 October 2026. General information, not professional or legal advice.
Related
A client document portal that does the chasing for you
Collect client documents without WhatsApp or email: one private upload link per engagement, accept or send bac…
SolutionsAudit software built for chartered accountancy firms in Pakistan
Audit software for chartered accountancy firms in Pakistan: ICAP-aligned statutory audit checklist, ISQM 1, cl…
CompareA CaseWare alternative for small and mid-size audit firms
Compare Stowbill and CaseWare for small and mid-size audit firms in Pakistan and the Gulf: workflow, client po…
TemplatesPakistan statutory audit checklist
Free statutory audit checklist for Pakistan, organised by stage and referenced to ISAs, ISQM 1 and the Compani…
Run your next audit in Stowbill
Start a 30-day trial, or let us walk your partners through a live engagement.