Page tree


 

 

For AE/AO Ledger, AccountRight Live, Essentials Cashbook, and Essentials Accounting, you can view the transactions in the Workpapers trial balance sheet, group and filter transactions, and export to Excel.

How to view transactions
  1. Open the Workpapers period. See Opening an existing period. The Prepare Trial Balance (Workpapers) table is displayed.
  2. Select one account in the table.
    OR
    Click the checkbox in the first column of the selected account.
  3. To display the transactions, either:
    • click View transactions on the Tasks bar

    • right-click on the account in the table and select View transactions.

You can open multiple View Transactions windows to view different accounts, for example.
All the settings (e.g. group, filter) to change the display of transactions are retained. When you close the View Transactions window and reopen it, the display settings are the same.

The Summary section shows the following information:

Field

Description

Opening Balance

The opening balance of the transactions displayed in the table.

Net Change

The difference between the opening and closing balances of the displayed transactions.

Closing Balance

The closing balance of the transactions displayed in the table.

 

The fields that are displayed in the View Transactions window are outlined in the table below.

 FieldDescription

Date

Date of the transaction, in the format dd/mm/yyyy.

Type

The type of transaction—withdrawal, general journal, deposit.

Reference

The transaction reference number.

Description

A description of the transaction, such as the purpose.

The line description is shown added to the contents of the Journal Note field for AccountRight Live, Practice Ledger, and Cashbook.

Debit

Amounts debited for withdrawals and general journal transactions.

Credit

Amount of credit for deposits.

Tax code

The type of tax applying to each transaction.

GST

Amount of goods and services tax for each transaction.

 

 

How to group transactions by field
  1. In the View Transactions window, click and drag a column header (field) into the grouping bar “Drag a column header here to group by that column”. The transactions are grouped by the data in that column.
  2. To remove grouping, drag the column name from the grouping bar back into the transaction table.
  3. If you want to further group transactions within each group, that is grouping within a group, drag a second column header into the grouping bar. The transactions are displayed by the first column header, and then further groupings within each of those groups.
How to filter transactions
  1. In the View Transactions window, click in the filter bar just below the column header that you want to sort transactions for. The filter bar has a  icon at the left.
  2. In the filter bar field, either:
    • select a data name from the drop-down

    • type the data name.

    The transactions that match the data name are displayed.

    You can use the asterisk character (*) as a wildcard. For example, type *BP* to find all transactions that contain ‘BP’ somewhere in the description.
  3. To remove the filter and display all transactions, click on the  icon on the field in the filter bar.

How to display transactions by period
  1. In the View Transactions window, enter the From date and To date.

    The dates must be within the workpaper period start and end dates.
  2. Click on the Search button. The transactions that occurred in that period are displayed.
How to move columns

In the View Transactions window, click and drag a column header to the left or right to change the order in which the columns are displayed.

How to export transactions to Excel
  1. When you have selected transactions by grouping and filtering, you can export the transactions to Excel.

  2. In the View Transactions window, click on the Export to Excel button. An Excel spreadsheet will open, showing the selected transactions.

  3. Save the spreadsheet.