The Accounts Enquiry screen shows summary information about accounts, and detailed information about transactions in an account. It can also display budget information, and display information in a spreadsheet for ease of manipulation.
(Screenshot above is from a multi-currency test ledger)
Accounts section
This shows summarised information based on the accounts, period range and analysis categories selected.
- The Show Budgets slider can be switched to the On position to see the Period Budget, Variance $ and Variance % columns as well.
- The Show Budgeted Accounts Only checkbox can also be ticked if you only wish to see accounts / sub-account with budgets entered.
Transactions section
This shows all the transactions for the selected account for the period range selected.
- You can click on a row to drill into the Transaction Detail screen for further information, and to access the button to drill into the Journal Preview screen and see any journal attachments.
- In the Transaction Detail screen, the Description can be changed if required. Click the Update button to save the change.
Spreadsheet View slider
To display the inquiry data in a spreadsheet, switch the Spreadsheet View slider to the On position. Then complete the enquiry fields and click Search. The information is then displayed in a spreadsheet with two sheets - Accounts and Transactions.
- The Accounts sheet shows the information as per the Accounts section in the regular view, and the Transactions sheet shows the Transactions information, sorted by account.
- You can use the spreadsheet functionality provided for once off calculations, or you can save the file and open it in Excel (click File > Save. Complete the File Name field and navigate the appropriate place to save the file).