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 used.
See Departments Parameter for more information on how you can use this parameter.
- Debit/Credit [Optional]
-
Use 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. By default, the latest transaction date will be used when this parameter remains empty.
Examples
It is strongly recommended to use Excel cells address (ex. A1:B19) containing the information of the parameters requested in all 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 General Ledger for account 1010-1090
- =XGL("1010-1090")
- Returns the total balance of General Ledger for account 1010 in June 06, 2015 for Administration department
- =XGL("1010","30/06/2015","Administration")