Manual

Account schedules and budgets

The ready-made reports

On Chart Of Accounts, under Report:

Report	What it shows
Trial Balance	Each account’s movement and balance over a period.
Detailed Trial Balance	The same, with each account’s entries.
Balance Sheet	Assets, liabilities and equity at a date.
Income Statement	Income, costs and profit over a period.

The trial balances filter by dimension, so the bakery’s trial balance can be run for the DELIVERY department alone.

Account schedules

An account schedule is a financial statement you lay out yourself: which accounts go on which row, which rows add up others, and which columns to print (this month, this year, last year, the budget). Account Schedules (under Activity) lists them, each with a Name, a Description and a Default Column Layout. Edit Account Schedule opens its rows; Print runs it.

Rows

Field	What it is for
Line No.	The row’s place; a new row takes the last number plus 10000, so a row can be put between two.
Row No.	The name formulas use for the row, such as 10 or P0010.
Description	The text printed.
Totaling Type	Posting Accounts, Total Accounts, or Formula of other rows.
Totaling	The accounts (`210100`, `210100\|210200`, `210000..219999`), or the formula (`10+20`, a range of rows such as `P0010..P0030`). Blank for a heading.
Row Type	The dates the accounts are added up over: Net Change (the column’s period), Balance At Date (everything to its end) or Beginning Balance (everything before its start).
Amount Type	Net Amount, Debit Amount or Credit Amount.
Show Opposite Sign	Prints the row’s figures with the opposite sign, as income and liabilities often are.
Show	Yes, No, If Any Column Not Zero, When Positive Balance or When Negative Balance.
Bold, Italic, Underline, Indentation	How the row looks.

Note

Formulas add up the rows’ figures before their opposite sign. Income is a credit, so its raw figure is negative: a gross profit row is income plus cost of sales (10+20), shown with the opposite sign.

Column layouts

Column Layouts holds the columns, each layout a Name and Description; Edit Column Layout opens its columns:

Field	What it is for
Column No.	The name column formulas use, such as C001.
Column Header	The heading printed.
Column Type	Net Change, Balance At Date, Beginning Balance, Year To Date, Entire Fiscal Year, or Formula.
Ledger Entry Type	Entries (what was posted) or Budget Entries (a G/L budget).
Amount Type	Net, debit or credit amounts.
Formula	For a formula column: other columns, such as `C002-C001`.
Show Opposite Sign, Show	The sign, and when it prints: Always, Never, When Positive, When Negative.
Comparison Date Formula	Moves the column’s dates, such as `-1Y` for the same period last year: see Date formulas.
Rounding Factor	None, One, Thousand or Million.

Running one

Print opens the Account Schedule report: choose the period, the Column Layout (blank for the schedule’s default), a Budget Filter for budget columns, the dimension filters, and whether to show amounts in the additional reporting currency. It previews on screen and exports to PDF or Excel.

G/L budgets

A G/L budget holds what each account is expected to come to, by date. G/L Budgets (under Activity) lists the budgets, each with its Name, Description, Start Date, End Date and Blocked (no more amounts once its period is over). Budget Entries opens its amounts:

Field	What it is for
Budget Name	The budget.
G/L Account No.	A posting account.
Date	The date the amount is budgeted for, such as the first of each month.
Description	What it is for.
Amount	An expense positive, an income negative, as the account’s balance would be.
Dimension codes	The department or channel it is budgeted for.

On Chart Of Accounts, the hidden Budgeted Amount column shows each account’s budget over the Date Filter, for the budgets in its Budget Filter, beside the Net Change actually posted. An account schedule column of Budget Entries puts budget beside actual in a statement.