Edit

Account Code

Used to include information for a specific account code. Enter the desired account code or pattern into the Code box.

Account Code Patterns: You can also use the wildcard characters “@” and “?” to get a range of accounts based on account code.

Use a question mark to denote that any single character is an acceptable match. Use an @ at the end of the account code or at the end of the department code to match any sequence of zero or more characters or use @ on its own to match all account codes.

For example, the pattern “?10?-A@” will match all departmentalised accounts having a department beginning with “A” (only sub-ledgers with a department beginning with “A” will be included) and having a four-digit account code with a “1” in the second place and a “0” in the third place (E.g. 0100-ART, 1105-ADM, 2100-ACRIM, 3107-AM, etc. will be included; 1010-ADM, 210-AM, 0100-BOT, 5100 etc. will not be included).

Accounts of Type

Used to include information from all accounts of a specific type—all income or bank accounts for example. The type is selected from the pop-up menu which appears when you choose this option.

Sometimes the apparent type of an account can change (e.g. your cheque account is no longer an asset if it is overdrawn).

If you set the Accounts are Floating option for the Part, accounts from the “other side of the ledger” will also be included in this Part if they have an inappropriate balance. Note that, for reports spanning more than one period, one account may appear in two places if it has a debit balance in one period and a credit in another. The floating account types are:

Type CodeType (Base Type)Float to
SASales accountsCS
CSCost of SalesSA
INIncome accountsEX
EXExpense accountsIN
CACurrent Asset accountsCL
TATerm Asset accountsTL
CLCurrent Liability accountsCA
TLTerm Liability accountsTA

In addition, you can use range of accounts “Sales and Income” (which combines types of IN and SA), and “Cost of Sales and Expenses” (combining types of CS and EX). Each floats to the other.