Accounting Journal & Ledger Query

To facilitate research into balances of records on the Accounting Ledger - FY, a query exists that ties that ledger with the Accounting Ledger - APD and the Accounting Journal. Drill down ability exists from a Fiscal Year (FY) ledger record to Accounting Period (APD) ledger records to Accounting Journal records, where full transaction details along with a link to the transaction are available.

Although most fields on the three levels of inquiry are common fields already covered in the ledger and journal topics, this page has a couple of fields calculated with each inquiry that do not exist on the ledgers:

Field Name

Field Description

Beginning Balance

For real accounts, this is the sum for the account in all prior fiscal years to the one selected that have not yet been closed. For nominal accounts, this amount is always $0.00.

Ending Balance

This is the sum of the selected fiscal year and the Beginning Balance.