Bilnax

Financial statements from your trial balance

Turn your trial balance into financial statements. Review every account mapping, reconcile the figures, and export the working papers.

Your trial balance

Start with this period. Add a comparative period for changes in equity and cash flows.

Bring in a trial balance

Drop your files here, or choose them from your computer.

Excel or CSV · One file per period

Export the whole ledger, not a filtered range. Report headings and subtotals are recognised automatically.

Try it with a sample trial balance

Use these fictional figures to explore the workflow before bringing in your own file. They are demonstration data, not a required template.

Upload the current-period file above for a balance sheet and income statement. Add the prior-period file for a comparison and cash flow working. Both files use USD.

Check your import: current-period debits and credits each total 235,000; the prior-period totals are 190,000 each. Before any adjustments, current-period revenue is 120,000, expenses are 95,000 and profit is 25,000.

What you get from a trial balance

  • The balance sheet and income statement from one period. Add the previous period’s trial balance for the statement of changes in equity and the cash flow statement, which both need a year to compare against.
  • Under IFRS, on IAS 1’s line items. Under US GAAP, the balance sheet, statement of operations, changes in stockholders’ equity and statement of cash flows on Regulation S-X captions, with a note of what each caption is made of. The policy, subsequent-events and going-concern notes are yours to write, and are listed rather than drafted.
  • Every account placed on a line with the reason it went there. Any it cannot place are listed for you to decide. None is left out.
  • A working paper to export: which account went where, and every check it ran.

What it checks, and what it will not do

  • A trial balance that does not balance is stopped, with the difference stated. It is never plugged to make the balance sheet tie.
  • A sheet holding more than one company, with a column naming each, is split into one book per company, and each has to balance on its own.
  • Report titles, subtotals and grand totals are recognised and left out, so a group is not counted twice.

The exports it reads

Excel and CSV exactly as your system writes them: a report title above the table, a debit and credit pair or a single signed column, credits in brackets or marked CR. The older .xls files NetSuite and Oracle export, and the HTML saved as .xls that Sage and Tally produce. Semicolon-separated files with comma decimals, the default in Germany and France, and headings in German or French. Subtotals written “Total Sales” as Xero and QuickBooks write them, “Total - Sales” as NetSuite does, or “Summe”.