GL Account Balance Enquiry

Navigator > Maintain > General Ledger > GL Account Balance Enquiry

View account and report balances for specified standard, non-posting or total accounts, Branch and Department codes (Accredo Saturn Only) and period ranges. Total accounts show accounts that contribute to balances, that is, those that Add To or Consolidate To the selected total account. The Report Balance field shows balances as they are calculated on a financial report, that is, after applying the effect of Alternate accounts. The Account Balance field shows the balances per the GL Account - Balances tab. Alternated balances will appear dimmed.


Period From Period To	Choose a period range from the Lookup.
Branch Department	Choose a Branch and / or Department (if applicable) from the Lookup. (Accredo Saturn Only)
Account	Choose the account to enquire on.
Validate Ledger `(Alt+V)`	Validate the ledger.
Fields
Account		The account name and code.
Report Balance		Period opening balance for Period From plus Period Activity for the range of periods selected, taking into account the effect of Alternate accounts, that is, the balances as they are calculated on a financial report.
Account Balance		Period opening balance for Period From plus Period Activity for the range of periods selected.
Type		The GL Account Type, can be Standard, Non Posting, Total, or Heading.
Add To		The account the balance is added to, for example, sales accounts add to total sales, or total sales adds to gross profit. The account specified must be a total account. Sub-accounts normally have the same add to account as their main account.
Consolidate		Alternative totalling path for use with the GL Financial Report Design Wizard.
Alternate		The account for the balance to be transferred to when the account balance goes negative, that is, when a Debit account has a credit balance or vice versa. The alternate account must be a non-standard account and of opposite sign, that is, debit for Credit accounts and vice versa. A typical use for alternate accounts is for bank account and bank overdraft. Alternate accounts must be specified in pairs. When an alternate Account code is set for an account, the selected account is set as the alternate Account code for the other account. For total accounts, the Non-posting alternate account must be the higher numbered account of the pair. Alternate accounts are not available for Heading accounts.
Post To		The Standard account to which the balance of this account (if a zeroing account, that is, Income or Expense) is to be transferred at the End Of Period. This transfers profits at the end of the period to be retained earnings next period, to transfer the closing balance of a shareholders current account to the opening balance for next period.
Inactive		GL Accounts marked inactive will be hidden from view with full financial information and history retained for reporting.