Aantar

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

Something unclear or out of date? Write to support@aantar.com and name this page.