Aantar Books
Financial Statement Builder
Build a set of year-end statements (cover, balance sheet, income statement, cash flow and notes) from the ledger, map accounts to statement lines, and save the set to Excel or print it.
Where: Accountant ▸ Financial Statement Builder…
Choose the period, an optional comparative column (the prior period or the same dates a year earlier), how figures are shown (dollars and cents, whole dollars or thousands), a basis label, the company and firm names, the cover title and which parts to include. The notice paragraph is editable text; {entity}, {firm}, {from} and {to} are filled in. The default says the statements were prepared from management's records and are not audited or reviewed. Edit it to suit the engagement. Notes are free text with a heading, numbered in order.
Preview shows the set on screen. Excel saves a workbook with a sheet for each part and a Data sheet that holds one row per account; every statement figure is a formula over the Data sheet, so changing a balance, moving an account to another line or changing the rounding moves the statements. PDF / Print prints the set. Save set keeps the choices under a name for next time.
Statement lines maps each account to a line (an asset to an asset line, an expense to an expense line). Only choices that differ from the default are kept, so a new account follows its default. You can reword a line or add one of your own. Back to defaults clears the mapping.
The balance sheet has a check row (assets against liabilities plus equity) and the cash flow, which is built the indirect way, ends on a cash check; the page warns when either is not nil. A period that includes the year-end closing entry shows the closed (nil) profit and loss, so build the statements for the period before the closing date.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.