Accounts Enquiry

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.

Open

(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.

Open

• 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).