XGL

XGL - Total balance of general ledger accounts for a given period

Description

This function returns the total balance of General Ledger accounts on a specific date.

Parameters

Accounts [Optional]

General ledger account number or name for which the balance is requested.

If this parameter remains empty, the current earnings value will be reported.

See accounts parameter for more information on how you can use this parameter.

Date [Optional]

Date at which the balance is required.

When entering dates in Excel, use the format for your computer's regional settings or use the ISO format (YYYY-MM-DD).

Departments [Optional]

If this parameter remains empty, only the accounts parameter will be utilized.

See the departments parameter for more information on how you can utilize this parameter.

Debit/Credit [Optional]

Utilize debit to return the positive sum value of a debiting account or credit to return the positive sum value of a crediting account.

Use As debit to return the amount as a debiting amount or As credit to return the amount as a crediting amount.

Currency [Optional]

Currency code for which the balance is required, for example, CAD or USD.

Connections [Optional]

Sage 50 connection to query. If left empty, the default connection will be used.

Usage

The total balance of a General Ledger account can be generated on any date, past or future. When this parameter remains empty, the latest transaction date will be utilized by default.

Examples

It is strongly recommended to use Excel cells address (ex. A1:B19) containing the information of the parameters requested in all Logicim XLGL functions, such as: accounts, date, departments, etc. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.

Returns the total balance of the general ledger for accounts 1010-1090

=XGL("1010-1090")

Returns the total balance of General Ledger for account 1010 on June 06, 2015, for administration department

=XGL("1010","30/06/2015","Administration")