Aantar Books
Company & Financial reports
Every Company & Financial report explained: the Profit & Loss family, income by customer and expenses by vendor, the Balance Sheet family, cash flow, the MIS pack (funds flow, ratios, party abstracts, profitability) and exchange gains and losses.
Where: Reports ▸ Company & Financial ▸ Profit & Loss Standard · Reports ▸ Company & Financial ▸ Profit & Loss Detail · Reports ▸ Company & Financial ▸ Profit & Loss by Month · Reports ▸ Company & Financial ▸ Balance Sheet Standard · Reports ▸ Company & Financial ▸ Balance Sheet Detail · Reports ▸ Company & Financial ▸ Balance Sheet (Financial Statements) · Reports ▸ Company & Financial ▸ Income Statement (Financial Statements) · Reports ▸ Company & Financial ▸ Statement of Cash Flows · Reports ▸ Company & Financial ▸ Ratio Analysis · Reports ▸ Report Centre
The Company & Financial reports are your financial statements and the analysis built on them: what the business earned (Profit & Loss), what it owns and owes (Balance Sheet), where its cash went (Statement of Cash Flows), and the management reports an accountant reads alongside them. Use them at every month-end and year-end, for your accountant and your bank, and whenever you want to know how the business is really doing.
Open them from Reports ▸ Company & Financial, or from the Company & Financial category in the Report Centre (Reports ▸ Report Centre). In the Report Centre, B opens the Balance Sheet Standard. Choosing dates, the Accrual | Cash switch, drilling down and printing work the same on every report: see Running a report, Drilling down from a report and Print, export and email a report.
The Reports ▸ Company & Financial submenu also lists, under Accounting screens, the live Profit & Loss, Balance Sheet and Cash Flow screens of the Accounting area. They show the same figures as working screens: see Profit & Loss, Balance Sheet and Statement of Cash Flows.
Which report do I want?
| Question | Report |
|---|---|
| Did we make money this period? | Profit & Loss Standard |
| Which transactions make up an income or expense account? | Profit & Loss Detail |
| How does this period compare with last year? | Profit & Loss Prev Year Comparison |
| How did each month go? | Profit & Loss by Month |
| How did each quarter go? | Profit & Loss by Quarter |
| Can I read the statements two-sided (T-format), as year-end financial statements, or the way the T2 lays them out? | Financial statement layouts (View as) |
| What does each cost amount to as a share of sales? | Profit & Loss — % of Income |
| How profitable is each store, class or job? | by Location, by Class, by Job |
| What does the business own and owe today? | Balance Sheet Standard |
| Where did the cash come from and go? | Statement of Cash Flows |
| Will we have enough cash over the next few weeks? | Cash Flow Forecast |
| How healthy are we: liquidity, margins, days to collect? | Ratio Analysis |
| Which customers make us the most profit? | Profitability by Customer |
| What did exchange rates cost or earn us? | Realized Gains & Losses |
Where the figures come from
- The books. The Profit & Loss, Balance Sheet and Cash Flow reports read the postings in your ledger, account by account: the same figures as the Trial Balance and General Ledger. A document that has not posted to the books does not appear on them.
- Accounts and sections. Each account reports under a section by its account type in the Chart of Accounts: Income, Cost of Goods Sold, Expenses, Other Income, Other Expense on the Profit & Loss; Current Assets, Fixed Assets, Other Assets, Current Liabilities, Long Term Liabilities and Equity on the Balance Sheet. An account whose type does not match a section is placed in the main section for its kind (Income, Expenses, Current Assets, Current Liabilities or Equity) rather than left out. See Chart of Accounts.
- Sub-accounts are shown this way on the Profit & Loss Standard, % of Income and the Balance Sheet Standard, Prev Year Comparison and by Month: the parent as a heading, its sub-accounts under it, anything posted to the parent itself as Parent - Other, and Total Parent. Accounts with nothing in them are left out.
- Account numbers. Every report here can show each account with its number, 4000 · Sales, with the accounts listed in number order: click Account # on the report's toolbar. It prints and exports to Excel the same way and stays on for every financial report until you click it again. See Account numbers.
- Accrual or Cash. The Profit & Loss Standard, Detail, YTD Comparison, Prev Year Comparison, by Month and % of Income have the Accrual | Cash switch. On a cash basis, an invoice or bill counts on the dates its payments were made, for the share that was paid. The subtitle then ends · cash basis. Every other report here is accrual.
- Fiscal year. Year-to-date figures and the split between this year's net income and retained earnings follow the first month of your fiscal year (Edit ▸ Preferences ▸ Reports & Graphs).
Profit & Loss
Profit & Loss Standard
What it answers: your income, less the cost of what you sold and your expenses, for the period: net income (profit) or net loss. Also called the income statement.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss Standard |
| Dates | Period |
| Filters | Accrual / Cash, Location |
| Source | The books |
Columns: Account, Amount. Click Account # on the toolbar to show account numbers.
Rows and totals: in order, Income, Cost of Goods Sold, Expenses, Other Income and Other Expense, each with its accounts (sub-accounts nested) and a Total line. A section with nothing in it is left out. After Total Cost of Goods Sold comes Gross Profit (income less cost of goods sold). Net Ordinary Income (gross profit less expenses) appears when there is other income or other expense. The last line is NET INCOME.
Drill-down: an account opens Transaction Detail by Account for that account and period: every posting behind the figure (see Accountant & Taxes reports).
Notes: No cost of sales was posted in this period, so gross profit equals income. Check the posting map if that is not expected. appears when there is income but no cost of goods sold (see Item accounts and Accounting Setup).
Related: Profit & Loss Detail lists every posting; the Balance Sheet carries this period's net income into equity; the live Profit & Loss screen shows the same figures.
Note: the location picker plays the part of a class or location filter.
Profit & Loss Detail
What it answers: every posting behind each income and expense account in the period.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss Detail |
| Dates | Period |
| Filters | Accrual / Cash, Location |
| Source | The books |
| Column | What it shows |
|---|---|
| Date | The posting date. |
| Type | What raised it: Invoice, Credit Note, Bill, Debit Note (vendor credit), Expense, General Journal, Opening Stock, Stock Adjustment, Transfer Out, Transfer In, or the kind of journal. |
| Num | The document number. |
| Name | The customer or vendor. |
| Memo | The posting's note. |
| Amount | Income positive, expense positive (a refund against an account is negative). |
Rows and totals: a heading per section (Income, Cost of Goods Sold…), under it a heading per account with its postings in date order and Total for the account, then Total for the section. The last line is NET INCOME.
On a cash basis each line is a document, dated when its money arrived, for the share that was paid.
Drill-down: a line opens its document, or its General Journal entry when there is no document.
Tip: Long periods can exceed the 5,000-line limit (the report then says it is incomplete). Use Summary (F6) to fold each account into months, or narrow the period.
Profit & Loss YTD Comparison
What it answers: the period beside the year to date, account by account.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss YTD Comparison |
| Dates | Period (the year to date runs from the start of the fiscal year containing the period's end) |
| Filters | Accrual / Cash, Location |
| Source | The books |
Columns: Account, This period, Year to date.
Rows and totals: a heading per section with the accounts that have a figure in either column, Total per section, and NET INCOME. Sub-accounts are listed as ordinary lines.
Drill-down: an account opens Transaction Detail by Account for the period.
Tip: Choose Last month to see last month beside the year so far: the report a monthly board pack usually needs.
Profit & Loss Prev Year Comparison
What it answers: this period against the same dates last year, with the change in dollars and per cent.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss Prev Year Comparison |
| Dates | Period (compared with the same dates one year earlier) |
| Filters | Accrual / Cash, Location |
| Source | The books |
| Column | What it shows |
|---|---|
| Account | The account. |
| This year (for example 2026) | This period. |
| Last year (2025) | The same dates a year earlier. |
| $ Change | This year less last year. |
| % Change | The change as a share of last year. Blank when last year was zero. |
Rows and totals: as the YTD Comparison, ending NET INCOME. Both columns use the same basis.
Drill-down: an account opens Transaction Detail by Account for this period.
Profit & Loss by Month
What it answers: income and expenses month by month, one column per month across the period.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss by Month |
| Dates | Period (up to 24 months) |
| Filters | Accrual / Cash, Location |
| Source | The books |
Columns: Account, one column per month (for example Jan 2026), Total. The first and last months cover only the days inside the period.
Rows and totals: a heading per section with its accounts, Total per section, and NET INCOME per month and in total.
Drill-down: a month's figure opens Transaction Detail by Account for that account in that month; anywhere else on the line (the account's name, Total, or an empty month) opens the whole period.
Notes: Capped at 24 months. Narrow the range to see the rest.
Profit & Loss by Quarter
What it answers: income and expenses quarter by quarter, one column per quarter of your fiscal year, plus the total.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss by Quarter |
| Dates | Period (up to 12 quarters) |
| Filters | Accrual / Cash, Location |
| Source | The books |
Columns: Account, one column per quarter (for example Jan–Mar 2026), Total. Quarters follow the First month of the fiscal year: a year that starts in July has Jul–Sep as its first quarter. The first and last quarters cover only the days inside the period.
Rows and totals: exactly as Profit & Loss by Month, three months to a column. NET INCOME in the Total column is the Profit & Loss Standard's.
Drill-down: a quarter's figure opens Transaction Detail by Account for that account in that quarter; anywhere else on the line opens the whole period.
Profit & Loss — % of Income
What it answers: every line of the Profit & Loss Standard as a share of total income, so costs can be compared across months and with other businesses whatever the size of the sales.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss — % of Income |
| Dates | Period |
| Filters | Accrual / Cash, Location |
| Source | The books |
Columns: Account, Amount, % of income (the amount ÷ Total Income × 100).
Rows and totals: exactly the Profit & Loss Standard, with the percentage beside every figure, including Gross Profit and NET INCOME (your gross and net margins).
Drill-down: as the Profit & Loss Standard.
Trading and Profit & Loss Account
What it answers: the profit and loss laid out in the two-sided (T-format) layout: what the goods earned (the Trading Account), then what the business earned after its other costs (the Profit & Loss Account).
| Menu | Reports ▸ Company & Financial ▸ Trading and Profit & Loss Account |
| Dates | Period |
| Filters | None besides the dates (accrual basis) |
| Source | The books and the inventory valuation |
Columns: Particulars and Amount on each side. An account's figure sits in the inner column under its group, and the group's total in Amount.
Rows and totals:
- Trading Account. Left: Opening Stock, Purchase Accounts, Direct Expenses (your Cost of Goods Sold accounts), Gross Profit c/o. Right: Sales Accounts (your Income accounts), Closing Stock. When the goods lost money, Gross Loss c/o is on the right instead. Both sides end on the same Total.
- Profit & Loss Account. Left: Indirect Expenses (your Expense and Other Expense accounts), Net Profit. Right: Gross Profit b/f, Indirect Incomes (your Other Income accounts). A loss is Net Loss on the right. Both sides end on the same Total.
Notes: opening and closing stock are the value of your stock at cost at the start and end of the period, as the Inventory Valuation reports value it. Aantar Books moves each sale's cost out of stock as it sells, so Purchase Accounts is worked out as closing stock less opening stock plus the cost of the stock sold, and Direct Expenses are the rest of Cost of Goods Sold (freight in, for example). Gross profit and net profit are exactly the Profit & Loss Standard's.
Drill-down: an account opens Transaction Detail by Account for the period; the stock and purchases lines open Inventory Valuation Detail; Net Profit opens the Profit & Loss Standard.
Note: This is the layout accountants who learned on two-sided books read first.
Profit & Loss by Location
What it answers: income and expense in a column per store or warehouse.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss by Location |
| Dates | Period |
| Filters | None besides the date (every location is a column) |
| Source | The books, placed at the location of the document behind each posting |
Columns: Account, one column per location, Unallocated (when needed), Total.
Rows and totals: a heading per section, its accounts, Total per section, and NET INCOME per location.
Unallocated holds postings with no document behind them, such as general journal entries and opening balances. They are part of the total.
Drill-down: a location's figure opens Transaction Detail by Account for that account at that location; anywhere else on the line (including an Unallocated figure) opens it for every location.
Profit & Loss by Class
What it answers: income and expense in a column per class (department, division or any other way you track the business).
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss by Class |
| Dates | Period |
| Filters | None besides the date |
| Source | The books (the class on each posting) |
Columns: Account, one column per class used in the period, Unassigned for postings with no class, TOTAL.
Rows and totals: Income and Expense sections with their accounts and a Total each, then Net Income per class. (Cost of goods sold is included under Expense.)
Drill-down: an account opens Transaction Detail by Account for the period.
Related: Profit & Loss Unclassified lists the postings still without a class; Classes explains how to assign them.
Profit & Loss by Job
What it answers: income and expense in a column per job (project).
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss by Job |
| Dates | Period |
| Filters | None besides the date |
| Source | The books (the job on each posting) |
Columns: Account, one column per job used in the period, Unassigned, TOTAL.
Rows and totals: as Profit & Loss by Class.
Notes: Entries with no project on them are shown under Unassigned. That is most of a normal business — overheads belong to no single job — and spreading them across jobs on a guess would make every job's profit an invention.
Drill-down: an account opens Transaction Detail by Account for the period.
Related: Job Profitability Summary and Jobs.
Profit & Loss Unclassified
What it answers: the income and expense posted with no class: the lines a business that tracks classes has to go back and code.
| Menu | Reports ▸ Company & Financial ▸ Profit & Loss Unclassified |
| Dates | Period |
| Filters | None besides the date |
| Source | The books |
Columns: Account, Unclassified.
Rows and totals: Income and Expense sections (accounts alphabetical) with Total lines, then Net Income (unclassified). When classes are not in use at all, it says Classes are not set up for this company.
Drill-down: an account opens every posting to it for the period.
Income & Expense Graph
What it answers: income, expense and net income month by month, drawn as bars above the figures.
| Menu | Reports ▸ Company & Financial ▸ Income & Expense Graph |
| Dates | Period |
| Filters | None besides the date |
| Source | The books |
Columns: Month, Income, Expense (cost of goods sold and all expenses), Net Income. The graph draws Income and Expense for each month.
Rows and totals: one row per month, then TOTAL.
Drill-down: a month opens the Profit & Loss Standard for that month.
Income & Expenses
These four reports cut the Profit & Loss by the customer or vendor on the document behind each posting.
Important: Postings made straight to the ledger (general journal entries, depreciation, payroll) belong to no customer or vendor and are not included, so these reports total less than the Profit & Loss for the same period. Each says so in a note.
Income by Customer Summary
What it answers: what each customer was worth in income this period, and their share of the total.
| Menu | Reports ▸ Company & Financial ▸ Income by Customer Summary |
| Dates | Period |
| Filters | Customer |
| Source | The books (income accounts), by the customer on each invoice or credit memo |
Columns: Customer, Income, Share (per cent of all customer income).
Rows and totals: customers A to Z by name, including one Walk-In Customer line for sales without a named customer, then TOTAL. Click a column heading to sort another way. Narrowed to one customer, Share is still their share of the whole period (a note says so).
Drill-down: a customer opens Income by Customer Detail for that customer.
Related: Sales by Customer Summary answers a similar question from the invoices rather than the books.
Income by Customer Detail
What it answers: every income posting behind each customer.
| Menu | Reports ▸ Company & Financial ▸ Income by Customer Detail |
| Dates | Period |
| Filters | Customer |
| Source | The books |
Columns: Date, Type (Invoice or Credit Note), Num, Account (the income account), Amount.
Rows and totals: a heading per customer, their postings in date order, Total per customer and a final TOTAL.
Drill-down: a line opens its invoice or credit memo.
Expenses by Vendor Summary
What it answers: what was spent with each vendor in the period, and their share.
| Menu | Reports ▸ Company & Financial ▸ Expenses by Vendor Summary |
| Dates | Period |
| Filters | Vendor (the chip reads All vendors) |
| Source | The books (expense accounts), by the vendor on each bill, vendor credit or expense |
Columns: Vendor, Spend, Share.
Rows and totals: vendors A to Z by name, then TOTAL. Click a column heading to sort another way. Only bills, vendor credits and expenses count. Cost of goods sold is posted on the sale, whose name is the customer, so it is not spend with a vendor and is not counted.
Drill-down: a vendor opens Expenses by Vendor Detail for that vendor.
Expenses by Vendor Detail
What it answers: every bill, vendor credit and expense behind each vendor.
| Menu | Reports ▸ Company & Financial ▸ Expenses by Vendor Detail |
| Dates | Period |
| Filters | Vendor |
| Source | The books |
Columns: Date, Type (Bill, Debit Note, Expense), Num, Account, Amount.
Rows and totals: a heading per vendor, their postings, Total per vendor and TOTAL.
Drill-down: a line opens its document.
Balance Sheet
Balance Sheet Standard
What it answers: what the business owns (assets), owes (liabilities) and is worth to its owners (equity) at the end of a day.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet Standard; B in the Report Centre |
| Dates | As of a date |
| Filters | None besides the date |
| Source | The books (every posting up to and including the date) |
Columns: Account, Balance.
Rows and totals:
- ASSETS — Current Assets, Fixed Assets and Other Assets, each with its accounts and a Total, then TOTAL ASSETS.
- LIABILITIES & EQUITY — Current Liabilities and Long Term Liabilities with their totals, Total Liabilities, then Equity: your equity accounts, Retained Earnings (prior years) (all profit before the start of this fiscal year), Net Income (current period) (profit from the start of this fiscal year to the date), and Total Equity.
- TOTAL LIABILITIES & EQUITY, which must equal TOTAL ASSETS.
Drill-down: an account opens Transaction Detail by Account for it (on the year to date; widen its dates to see older postings). Net Income (current period) opens the Profit & Loss Standard.
If it does not balance: a note says THIS BALANCE SHEET DOES NOT BALANCE — assets exceed liabilities and equity by … Do not file from it. Run the Trial Balance to find the entry at fault., with the red bar across the report. See Trial Balance.
Note: Aantar Books works out Retained Earnings and this year's Net Income on the fly from the fiscal year start; you do not need a closing entry for the Balance Sheet to balance.
Balance Sheet Detail
What it answers: every posting behind each balance sheet account, with a running balance, up to the date.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet Detail |
| Dates | As of a date |
| Filters | None besides the date |
| Source | The books |
Columns: Date, Type, Num, Name, Amount, Balance (running).
Rows and totals: a heading per section, a heading per account with its postings from the very first one, Total per account and per section.
Drill-down: a line opens its document or General Journal entry.
Tip: This report lists every posting ever made to each account, so it reaches the 5,000-line limit quickly. For one account, use Transaction Detail by Account with a period instead.
Balance Sheet by Month
What it answers: month-end balances side by side.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet by Month |
| Dates | Period (one column for each month-end in it, and the period's last day) |
| Filters | None besides the date |
| Source | The books |
Columns: Account, then one column per month-end (for example 31 Jan 2026), the last being the period's end date. At most the last 12 are shown: Only the last 12 month-ends are shown. Narrow the period to see earlier ones.
Rows and totals: the Balance Sheet Standard's layout, for each date.
Drill-down: as the Balance Sheet Standard.
Balance Sheet by Quarter
What it answers: the balance sheet at each quarter-end of your fiscal year, side by side.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet by Quarter |
| Dates | Period (up to 12 quarter-ends) |
| Filters | None besides the dates |
| Source | The books |
Columns: Account, one column per quarter-end, the last one being the last date of the period.
Rows and totals: as the Balance Sheet Standard, in every column. The last column is the Balance Sheet Standard as of that date.
Drill-down: as the Balance Sheet Standard.
Balance Sheet — % of Total Assets
What it answers: every line of the Balance Sheet Standard as a share of total assets (a common-size balance sheet), so the shape of the business can be compared across years and with other businesses.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet — % of Total Assets |
| Dates | As of one date |
| Filters | None besides the date |
| Source | The books |
Columns: Account, Balance, % of Total Assets (the balance ÷ TOTAL ASSETS × 100).
Rows and totals: exactly the Balance Sheet Standard; TOTAL ASSETS reads 100%.
Drill-down: as the Balance Sheet Standard.
Balance Sheet (Two-Sided)
What it answers: the balance sheet in the two-sided (T-format) layout: liabilities and capital on the left, assets on the right, both totals equal at the bottom.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet (Two-Sided) |
| Dates | As at one date |
| Filters | None besides the date |
| Source | The books |
Columns: Liabilities and Amount on the left, Assets and Amount on the right, each account's figure in the inner column under its group.
Rows and totals: left: Capital Account (your equity accounts), Loans (Liability) (long-term liabilities), Current Liabilities, and Profit & Loss A/c with its Opening Balance (profit of earlier years) and Current Period (this fiscal year's net income). Right: Fixed Assets, Investments & Other Assets, Current Assets. A group with nothing in it is left out. The bottom line is Total on each side; the right-hand total is the Balance Sheet Standard's TOTAL ASSETS. If the books do not balance, the left side shows Difference in Opening Balances, and the report warns you.
Drill-down: an account opens Transaction Detail by Account; Current Period opens the Profit & Loss Standard.
Balance Sheet Summary
What it answers: the balance sheet rolled up to its sections: a one-glance version.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet Summary |
| Dates | As of a date |
| Filters | None besides the date |
| Source | The books |
Columns: Account, Balance.
Rows and totals: ASSETS with Current Assets, Fixed Assets, Other Assets and TOTAL ASSETS; LIABILITIES & EQUITY with Current Liabilities, Long Term Liabilities, Total Liabilities and Equity (including retained earnings and this year's net income); TOTAL LIABILITIES & EQUITY.
Drill-down: any line opens the Balance Sheet Standard.
Balance Sheet Prev Year Comparison
What it answers: the balance sheet on a date beside the same date last year, with the change.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet Prev Year Comparison |
| Dates | As of a date (compared with one year earlier) |
| Filters | None besides the date |
| Source | The books |
Columns: Account, the date (for example 30 Sep 2026), the same date last year (30 Sep 2025), $ Change, % Change (blank when last year was zero).
Rows and totals: the Balance Sheet Standard's layout, for both dates.
Drill-down: as the Balance Sheet Standard.
Balance Sheet by Class
What it answers: every balance sheet account in a column per class.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet by Class |
| Dates | As of a date |
| Filters | None besides the date |
| Source | The books (the class on each posting) |
Columns: Account, one column per class (alphabetical), Unclassified, TOTAL (which is the Balance Sheet Standard's figure).
Rows and totals: ASSETS, LIABILITIES and EQUITY, each with its accounts (alphabetical) and a Total. Equity includes Retained Earnings & Net Income per class. The last line is TOTAL LIABILITIES & EQUITY.
Notes: A class column balances only when every line of an entry carries the same class. Postings with no class are under Unclassified.
Drill-down: an account opens Transaction Detail by Account from 1 January of that year up to the "as of" date; Retained Earnings & Net Income opens the Profit & Loss Standard.
Balance Sheet by Location
What it answers: every balance sheet account in a column per location (store or warehouse), so you can see what each one holds and owes. Locations play the part of classes here.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet by Location; or View as ▸ By location on the Balance Sheet |
| Dates | As of a date |
| Filters | None besides the date |
| Source | The books (the location each line was posted with) |
Columns: Account, one column per location with a balance (alphabetical), Unassigned, TOTAL. The TOTAL column is the Balance Sheet Standard, to the cent.
Rows and totals: the Balance Sheet Standard's layout: ASSETS, LIABILITIES & EQUITY, sub-accounts under their parent, Retained Earnings (prior years) and Net Income (current period). Retained earnings and net income are split by the location of the income and expenses behind them.
Notes: Unassigned holds what was posted with no location: opening balances, journal entries entered without one, and anything from a location since deleted. It is part of the total. A location's column balances only when every line of each entry carries that location.
Drill-down: an account opens Transaction Detail by Account; Net Income (current period) opens the Profit & Loss Standard.
Note: locations play the part of classes. Unassigned holds what has no location.
Net Worth Graph
What it answers: assets, liabilities and net worth at each month's end, drawn as bars above the figures.
| Menu | Reports ▸ Company & Financial ▸ Net Worth Graph |
| Dates | Period (one row per month in it) |
| Filters | None besides the date |
| Source | The books |
Columns: Month, Assets, Liabilities, Net Worth (assets less liabilities). The graph draws all three.
Rows and totals: one row per month, at that month's end (or the period's end for the last month).
Drill-down: a month opens the Balance Sheet Standard as of that month's end (the date on its row).
Balance Sheet (Financial Statements)
What it answers: the year-end balance sheet laid out the way an accountant prints a small corporation's year-end financial statements, this year-end beside last.
| Menu | Reports ▸ Company & Financial ▸ Balance Sheet (Financial Statements) |
| Dates | As at a date (compared with one year earlier) |
| Filters | None besides the date |
| Source | The books |
Columns: the line, this year, last year.
Rows and totals: ASSETS: Current (Bank and cash equivalents, Accounts receivable, Inventory, Prepaid expenses, Other current assets, Total current assets), Property and equipment (net of accumulated amortization), Other assets, TOTAL ASSETS. LIABILITIES: Current (Accounts payable and accrued liabilities, Government remittances payable for GST/HST, PST and payroll remittances, Income taxes payable, Current portion of long-term debt, Due to shareholder, Total current liabilities), Long-term debt, TOTAL LIABILITIES. SHAREHOLDERS' EQUITY: Share capital, Retained earnings (this year's net income included). The last line is TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY. A line with nothing in either year is left out.
Notes: each account goes on a line by its type, then its detail type and name (an account called "Share Capital" is share capital; a GST/HST payable account is a government remittance). The totals are the Balance Sheet Standard's.
Due to shareholder and Government remittances payable are decided by the account's GIFI code first, then its detail type, and by its name only when it has neither:
- Due to shareholder: GIFI 2780–2783 or 3260–3263 (due to shareholders and directors), 2860, 2861, 2863 or 3300 (due to related parties), or the detail type Shareholder notes payable.
- Government remittances payable: GIFI 2627 (employee deductions), 2628 (withholding taxes) or 2680 (taxes payable), the detail types Sales and service tax payable, Payroll liabilities and Payroll clearing, or the sales tax and payroll remittance accounts set in your posting accounts.
- An account with a GIFI code stays where its code puts it, whatever it is called: "Shareholder deposits" coded 2620 is a payable. Give your accounts their codes on Company ▸ Income Tax (T2 / GIFI).
Drill-down: a line opens Transaction Detail by Account for the accounts behind it; the last-year figure opens them up to last year's date. Retained earnings opens the Profit & Loss Standard.
Note: This is the statement an accountant prepares at year-end, built from your books.
Income Statement (Financial Statements)
What it answers: the year's income statement laid out as an accountant prints it, this year beside last.
| Menu | Reports ▸ Company & Financial ▸ Income Statement (Financial Statements) |
| Dates | Period, usually your fiscal year (compared with the same period a year earlier) |
| Filters | None besides the dates |
| Source | The books (accrual basis) |
Columns: the line, this year, last year.
Rows and totals: REVENUE (each income account, Total revenue), Cost of sales, GROSS PROFIT with the Gross margin for both years, EXPENSES listed alphabetically (each expense account, Total expenses), INCOME FROM OPERATIONS, OTHER INCOME and OTHER EXPENSES when there are any, INCOME BEFORE INCOME TAXES, Income taxes (accounts named for income tax), NET INCOME. The heading reads "For the year ended" the last date.
Drill-down: a line opens Transaction Detail by Account for the period; the last-year figure opens last year's period.
Cash Flow
Statement of Cash Flows
What it answers: how cash moved in the period, split into operating, investing and financing activities, by the indirect method (starting from net income).
| Menu | Reports ▸ Company & Financial ▸ Statement of Cash Flows |
| Dates | Period |
| Filters | None besides the date |
| Source | The books |
Columns: the line, Amount.
Rows and totals:
- OPERATING ACTIVITIES — Net income, then Increase in … or Decrease in … for each current asset and current liability account (other than cash) that changed: more receivables or stock uses cash, more payables provides it. Net cash from operating activities.
- INVESTING ACTIVITIES — the change in each fixed and other asset account. Net cash from investing activities.
- FINANCING ACTIVITIES — the change in each long-term liability and equity account. Net cash from financing activities.
- Net change in cash, Cash at beginning of period and Cash at end of period.
Which accounts are cash: the Cash and Bank accounts set in Accounting Setup, plus every account of the cash type. A note names them: Treated as cash: …. If none is found: No cash account is identified. Set the Cash and Bank roles in Accounting ▸ Setup, or this statement cannot reconcile.
Check: if the movement the statement works out differs from what the cash accounts actually moved, a note says DOES NOT RECONCILE: this statement derives a movement of … but the cash accounts moved by …. Usually an account has the wrong type.
Drill-down: Net income opens the Profit & Loss Standard; an account line opens Transaction Detail by Account.
Statement of Cash Flows Prev Year Comparison
What it answers: the Statement of Cash Flows for the period beside the same period last year.
| Menu | Reports ▸ Company & Financial ▸ Statement of Cash Flows Prev Year Comparison |
| Dates | Period (compared with the same dates one year earlier) |
| Filters | None besides the date |
| Source | The books |
Columns: the line, this period (headed with its dates), the same period last year, $ Change.
Rows and totals: the Statement of Cash Flows' lines; a line that only last year had appears just before its section's total. Each column agrees with the Statement of Cash Flows run on its own dates.
Drill-down: as the Statement of Cash Flows.
Cash Flow Forecast
What it answers: week by week, the cash you have, what customers are due to pay you, what you are due to pay vendors, and the projected balance.
| Menu | Reports ▸ Company & Financial ▸ Cash Flow Forecast |
| Dates | Period, divided into weeks starting on its first day |
| Filters | None besides the date |
| Source | The books (cash) and open invoices and bills |
| Column | What it shows |
|---|---|
| Period | The week, for example Sep 25 – Oct 1, 2026. |
| Beginning Balance | Cash at the start of the week (for the first week: the cash and bank accounts the day before). |
| Accnts Receivable | Open customer invoices due that week. Overdue ones fall in the first week. |
| Accnts Payable | Open bills due that week, shown negative. Overdue ones fall in the first week. |
| Bank Accnts | Money already entered in the bank accounts for a date in that week. |
| Net Inflows | Receivable less payable plus bank. |
| Proj Balance | The projected cash at the end of the week. |
Rows and totals: one row per week, then TOTAL.
Note: Open invoices and bills are taken as of the first day of the period, and due dates follow the same terms rules as the aging reports. The report window opens on today and the eight weeks after it. Its date button opens a calendar that reaches two years ahead, so you can forecast as far as you need; click the first day and the last day, then Save.
Funds Flow Statement
What it answers: where the business's funds came from and where they went between two balance sheets, and the resulting change in working capital.
| Menu | Reports ▸ Company & Financial ▸ Funds Flow Statement |
| Dates | Period (compares the balance sheet the day before it starts with the one at its end) |
| Filters | None besides the date |
| Source | The books |
Columns: Particulars, At (the day before the period), At (the period's end), Amount.
Rows and totals:
- Sources of funds — Net profit for the period, and every fixed asset that fell, or long-term liability or equity account that rose (a loan taken, capital put in, an asset sold). Total sources of funds.
- Applications of funds — Net loss for the period if there was one, and every fixed asset that rose, or long-term liability or equity account that fell (an asset bought, a loan repaid, drawings). Total applications of funds.
- Increase in working capital (or Decrease).
- Schedule of changes in working capital — every current asset and current liability with its two balances and its effect (positive increased working capital), ending Increase (or Decrease) in working capital, which must equal the figure above.
Check: DOES NOT AGREE — sources less applications come to … but working capital moved by … means the balance sheet does not balance on one of the two dates; run it for each date to find which.
Drill-down: net profit or loss opens the Profit & Loss Standard for the period; an account opens Transaction Detail by Account for the period.
MIS
The management information reports an accountant reads a set of accounts by. Each is built from figures other reports already produce, so they cannot disagree.
Ratio Analysis
What it answers: the liquidity, leverage, profitability and efficiency ratios of the business, each with how it was worked out.
| Menu | Reports ▸ Company & Financial ▸ Ratio Analysis |
| Dates | Period (balance sheet figures at its end; income figures for the period) |
| Filters | None besides the date |
| Source | The books |
Columns: Measure, Ratio, Per cent, Days, Amount, Worked out as (the figures used, so any ratio can be checked by hand).
| Section | Measures |
|---|---|
| Liquidity | Working capital (current assets less current liabilities); Current ratio (current assets ÷ current liabilities); Quick ratio (current assets less inventory ÷ current liabilities); Cash ratio (cash and bank ÷ current liabilities). |
| Leverage | Debt to equity (total liabilities ÷ equity); Debt ratio (liabilities ÷ assets, %); Equity ratio (equity ÷ assets, %). |
| Profitability | Sales; Gross profit; Gross margin %; Operating expense ratio % (expenses ÷ sales); Net profit (as on the Profit & Loss); Net margin %; Return on equity %; Return on assets %. |
| Efficiency | Receivable days, Payable days and Inventory days (scaled to the number of days in the period); Inventory turnover; Asset turnover. |
Equity includes every year's profit, whether or not a closing entry was made. Inventory is the balance of the inventory account set in Accounting Setup; without one, inventory is taken as zero and a note says the quick ratio then equals the current ratio. A blank means the ratio has nothing to divide by (no sales, no liabilities, no stock).
Drill-down: none.
Party Abstract — Customers
What it answers: for every customer with a balance or any movement, the opening balance, what was invoiced, what was received or credited, and the closing balance: a one-line-per-customer summary of their ledger (sundry debtors).
| Menu | Report Centre only; A (Account Summary) in the Report Centre |
| Dates | Period |
| Filters | None besides the date |
| Source | The documents and payments, by the same rules as each customer's ledger |
Columns: Customer, Opening balance, Invoiced, Received & credit notes, Closing balance.
Rows and totals: customers alphabetically, then TOTAL. Invoices and balances brought forward raise the balance; credit memos and payments received lower it; change handed back and refunds raise it. Drafts and held sales are not counted. A closing balance above zero is what the customer owes; below zero, they are in credit.
Drill-down: a customer opens their ledger, whose movements for the same dates agree with the line to the cent.
Party Abstract — Vendors
What it answers: the same for every vendor (sundry creditors): opening balance, billed, paid and debit notes, closing balance.
| Menu | Report Centre only |
| Dates | Period |
| Filters | None besides the date |
| Source | The documents and payments |
Columns: Vendor, Opening balance, Billed (received bills, expenses and balances brought forward), Paid & debit notes, Closing balance.
Rows and totals: vendors alphabetically, then TOTAL. Unreceived purchase orders do not count. A closing balance above zero is what you owe the vendor; below zero, they owe you.
Drill-down: a vendor opens their ledger.
Profitability by Customer
What it answers: what each customer's goods sold for, what they cost, and the gross profit left: party-wise profitability.
| Menu | Report Centre only |
| Dates | Period |
| Filters | Location |
| Source | The documents (invoice lines and the cost of the stock each sale used) |
| Column | What it shows |
|---|---|
| Customer | The customer (or Walk-In Customer). |
| Invoices | Invoices in the period. |
| Sales excl. tax | Goods sold, before tax and after line and invoice discounts, less credit memos. |
| COGS | The actual cost of the stock each sale used. |
| Gross profit | Sales less COGS. |
| Margin % | Gross profit ÷ sales. |
| Share of profit | This customer's share of all gross profit. |
Rows and totals: most profitable first, then TOTAL. Delivery charges, tips and rounding are on no item line and are not included. A credit memo counts in the period it was issued. Goods that arrived without a purchase document (for example imported opening stock) carry no cost, so their margin reads as the full selling price.
Drill-down: a named customer opens their ledger.
Related: Gross Profit by Invoice has the same figures invoice by invoice; Sales by Item Summary item by item.
Currency
Realized Gains & Losses
What it answers: the exchange gain or loss on foreign-currency invoices and bills settled in the period, at a different rate from the one they were entered at.
| Menu | Reports ▸ Company & Financial ▸ Realized Gains & Losses |
| Dates | Period |
| Filters | None besides the date |
| Source | The books (the Exchange Gain or Loss account) |
Columns: Date, Type, Num, Name, Memo, Gain (Loss) (a gain positive, a loss negative).
Rows and totals: one row per posting to Exchange Gain or Loss, then TOTAL. Until anything has been settled in another currency the report says No Exchange Gain or Loss account yet: nothing has been settled in another currency.
Drill-down: a line opens its document or journal entry.
Unrealized Gains & Losses
What it answers: what your open foreign-currency invoices and bills would gain or lose if they were settled at the exchange rate on the date. Nothing is posted.
| Menu | Reports ▸ Company & Financial ▸ Unrealized Gains & Losses |
| Dates | As of a date |
| Filters | None besides the date |
| Source | Open foreign-currency documents and your currency rates |
| Column | What it shows |
|---|---|
| Name | The customer or vendor. |
| Num | The document number. |
| Currency | Its currency. |
| Open Balance (foreign) | What is still open, in that currency. |
| Carried at | What it is carried at in your home currency. |
| Exchange Rate | The rate on the date. |
| Revalued | The open balance at that rate. |
| Unrealized Gain (Loss) | The difference: a receivable worth more, or a payable costing less, is a gain. |
Rows and totals: Accounts Receivable and Accounts Payable sections with their totals, then TOTAL.
Notes: No rate on this date for …; enter one in Company ▸ Manage Currency. When multicurrency is not in use it says Multicurrency is not set up for this company.
Drill-down: a line opens its invoice or bill.
Related: Home Currency Adjustment and foreign currency and Currency List.
Sales and Purchases by Currency
What it answers: how much you sold and bought in each currency over a period, in that currency and in your home currency, with the average rate the documents used.
| Where | Reports ▸ Report Centre ▸ Company & Financial, group Currency |
| Dates | From and to dates |
| Filters | None besides the dates |
| Source | Invoices, credit notes, bills and vendor credits, each with the currency and rate saved on it |
| Column | What it shows |
|---|---|
| Currency | The currency; your own reads, for example, CAD (home). |
| Documents | How many documents were in that currency. |
| Total in the currency | Their total in that currency. Credit notes and vendor credits are taken off. |
| Total in your home currency | The same total converted at each document's own rate. |
| Average rate | Home total divided by the currency total. Blank for the home currency. |
Rows: a SALES section and a PURCHASES section, each with one row per currency and a total in the home currency.
A bill is counted in a foreign currency only when the currency and rate were set on the bill itself, not just on the vendor. A vendor whose name says USD, but whose bills were entered without a currency, shows under the home currency.
Common problems
| Problem | Cause and fix |
|---|---|
| The Balance Sheet does not balance | Run the Trial Balance for the same date and look for an entry that does not balance or an account with the wrong type. Do not file from it until it balances. |
| Net income on the Profit & Loss differs from Net Income on the Balance Sheet | The Balance Sheet's Net Income (current period) runs from the start of your fiscal year to its date; the Profit & Loss covers whatever period you chose. Choose the fiscal year to date on the Profit & Loss. |
| Gross profit equals income | No cost of goods sold was posted. Check each item's accounts and the posting accounts in Accounting Setup. |
| An invoice is missing from the Profit & Loss | It has not posted to the books (for example it is a draft or estimate), or it is dated outside the period. Check it on Profit & Loss Detail and in the document itself. |
| Cash basis shows less income than accrual | Intended: on a cash basis only the paid share of each invoice counts, on the dates it was paid. |
| Income by Customer totals less than the Profit & Loss | Postings with no customer (journal entries) are not on it. |
| DOES NOT RECONCILE on the Statement of Cash Flows | An account is typed so that its movement is not classified. Check the types of the accounts that moved in the period. |
| Too many Unassigned or Unclassified figures | Postings made without a job or class. Assign them on the documents (see Classes and Jobs). |
Related articles
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.