Aantar

Aantar Books

Financial statement layouts

View the Profit & Loss and the Balance Sheet in another layout, with the same dates: Standard or Detail, year-end financial statements, the two-sided (T-format) layout, the T2 GIFI schedules, this year against last, by month or quarter, common-size, by class or location, or budget vs. actual.

Where: Reports ▸ Company & Financial ▸ Profit & Loss Standard · Reports ▸ Company & Financial ▸ Balance Sheet Standard

The Profit & Loss and the Balance Sheet can be read in several layouts. There is the standard layout, the year-end statements an accountant files, and the two-sided (T-format) layout some accountants learned on. Every layout shows the same books: the net income and the total assets are the same in each one.

Changing the layout

  1. Open the Profit & Loss Standard or the Balance Sheet Standard (Reports ▸ Company & Financial), or any of the layouts below.
  2. Next to the dates, press View as. The button shows the layout on screen, for example View as: Standard.
  3. Pick a layout. It opens in the same window, with the same dates, the same location and the same Accrual | Cash choice where the layout has one.

Aantar Books remembers your choice. The next time you open Profit & Loss Standard or Balance Sheet Standard from the Reports menu, it opens in the layout you picked last. To go back, choose View as ▸ Standard. The choice is yours alone: other users on the same company keep their own.

Every layout drills to the transactions behind a figure, and prints, exports and emails like any other report (see Print, export and email a report).

The Profit & Loss layouts

View as Report What it shows
Standard Profit & Loss Standard Income less expenses for the period. The default.
Detail Profit & Loss Detail Every transaction under each account.
Financial Statements Income Statement (Financial Statements) The year-end income statement as an accountant prints it (ASPE), this year beside last.
Two-sided (T-format) Trading and Profit & Loss Account The Trading Account (stock, purchases, direct expenses, gross profit) then the Profit & Loss Account, left side and right side.
T2 GIFI Schedule 125 GIFI Schedule 125 — Income Statement Revenue and expenses grouped by GIFI code. Canadian companies only.
This year vs last year Profit & Loss Prev Year Comparison The period beside the same period last year, with $ Change and % Change.
By month Profit & Loss by Month A column per month and the total.
By quarter Profit & Loss by Quarter A column per quarter of your fiscal year and the total.
Common-size (% of income) Profit & Loss — % of Income Every line as a share of total income.
By class Profit & Loss by Class A column per class.
By location Profit & Loss by Location A column per store or warehouse.
Budget vs. actual Budget vs. Actual Each income and expense account against its budget.

The Balance Sheet layouts

View as Report What it shows
Standard Balance Sheet Standard What the business owns and owes on the date. The default.
Detail Balance Sheet Detail Every transaction under each account.
Financial Statements Balance Sheet (Financial Statements) The year-end balance sheet as an accountant prints it, this year beside last.
Two-sided (T-format) Balance Sheet (Two-Sided) Liabilities and capital on the left, assets on the right, both totals equal.
T2 GIFI Schedule 100 GIFI Schedule 100 — Balance Sheet Assets, liabilities and equity grouped by GIFI code. Canadian companies only.
This year vs last year Balance Sheet Prev Year Comparison The date beside the same day last year, with $ Change and % Change.
By month Balance Sheet by Month Month-end balances side by side.
By quarter Balance Sheet by Quarter Quarter-end balances side by side.
Common-size (% of total assets) Balance Sheet — % of Total Assets Every line as a share of total assets.
By class Balance Sheet by Class A column per class.
By location Balance Sheet by Location A column per location, Unassigned for what has none, and the TOTAL.

How the dates carry across

  • Between two layouts with the same kind of dates, the dates stay exactly as they were.
  • From a period (the Profit & Loss, or the Balance Sheet by month or quarter) to a layout as of one date, the layout opens as of the last day of the period.
  • From a Balance Sheet as of a date to By month or By quarter, the layout covers the start of that fiscal year to the date, so its last column is the Balance Sheet you were reading.

Two-sided layouts, in short

The two-sided layouts group your accounts by type:

  • Sales Accounts are your Income accounts; Direct Expenses are your Cost of Goods Sold accounts; Indirect Expenses are your Expense and Other Expense accounts; Indirect Incomes are your Other Income accounts.
  • Opening Stock and Closing Stock are the value of your stock at cost at the start and end of the period. Aantar Books takes the cost of each sale out of stock as it sells, so Purchase Accounts is worked out from the stock (closing less opening plus the cost of what sold). The gross profit is the Profit & Loss Standard's.
  • On the Balance Sheet, Profit & Loss A/c shows the profit of earlier years (Opening Balance) and this fiscal year's (Current Period).

Note: Standard is the default layout. The other layouts are there for your accountant, and changing the layout never changes a figure.

Common problems

  • A layout is missing from View as. The GIFI schedules are for Canadian companies only. A layout that needs something you have not set up (classes, locations, a budget) still opens, with everything under one column.
  • The GIFI schedule lists accounts under "Not yet assigned a GIFI code". Give those accounts their codes on Company ▸ Income Tax (T2 / GIFI). See Income Tax (T2 / GIFI).
  • Purchase Accounts in the Trading Account is not what I bought. It is worked out from the stock value. If your stock value and the Inventory Asset account disagree, the difference shows here; check the Inventory Valuation Summary.

Related articles

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