Accounts parameter

Accounts - General ledger account(s)

Description

Many Logicim XLGL worksheet functions have an accounts parameter.

This parameter can be utilized to specify which account(s) are to be used in the calculation.

This article describes the different ways you can use this parameter.

 Sage 50 US edition

The account corresponds to the beginning partof a GL Account. It can be a single segment, multiple segment, or only part of a segment. You can specify the account(s) using the following methods:

• The beginning part of an account number, or the complete account number Ex: 40100 or 40 (any account starting with 40)
• Account name Ex: Account Receivable (It is recommended to avoid this and use Account Number instead.)
• Comma-separated list of account numbers Ex: 40100, 40200, 40400
• A range of accounts using a colon Ex: 40100:40400
• Wildcards using '?' Ex: 40??? (wildcards can be used in comma-separated lists and ranges as well)
• Combination of the previous methods Ex: 40100, 40400:40800, 42???

It is also possible to create an exclude list by using '' (backslash) and another set of accounts to remove from the original list. For example, to get all accounts between 40000 and 45000, except 41000 and 42000: 40000-45000 41000, 42000

 Sage 50 Canadian edition

You can specify the account(s) using the following methods:

• Account number Ex: 40100
• Account name Ex: Account receivable (It is recommended to avoid this and utilize account number instead.)
• Comma-separated list of account numbers Ex: 40100, 40200, 40400
• A range of accounts using a dash Ex: 40100-40400
• Combination of the previous two methods Ex: 40100, 40400-40800, 41000