The Ledger has two functions: First, it displays all the accounting transactions on one screen. Multiple Views (reports) are available including a Transaction and Detailed Ledger view. Second, ledger transactions can be created including General Expenses, Customer Receipts and Supplier Payments.
The list of Transactions that can be created are grouped by Customer, Supplier and other Transactions for ease of navigation.
This page lists the buttons, filters and fields of the Ledger's list views: Transactions, Transaction Items, General Ledger Accounts, and Customer and Supplier Accounts.
Sets a specific time frame such as Today, This Month, This Year or Fin Year.
← →
Adjusts the Date forwards or backwards based on the selected period.
Date
Further refine the date selections.
Radio Buttons
Sort the records by Transaction, Period or Updated (Date).
These buttons only apply to Transaction Type (Items) and Transaction Type (Transactions).
When viewing Customer, Supplier or General Ledger Accounts the sort order is by Period.
Filter
Dropdown list to select:
Transaction Type (Items): Displays a list of transaction items (detailed transactions).
Transactions Type (Transactions): Displays a list of transactions.
Customer Account: Displays the customer ledger (chronological customer transactions per customer). Includes opening and running balances.
Supplier Account: Displays the supplier ledger (chronological supplier transactions per supplier). Includes opening and running balances.
Ledger Account: Displays general ledger transactions chronologically. Includes opening and running balances.
Transaction
View all or a specific Transaction Type. Only available when Transaction Types are selected.
Account
Select a specific account. Only applies to Customer, Supplier or General Ledger Accounts. Defaults to All.
Currency
Select a specific currency if multiple currencies are used. Only applies to Customer, Supplier and General Ledger Accounts.
Checkboxes
Checkboxes are only available when viewing Transaction Types.
Reconciled: When checked, only shows reconciled transactions.
Not Reconciled: When checked, only shows transactions that are unreconciled.
Trial Errors: When checked, only shows transactions that do not have matching Debit and Credit entries.
Allocated: Applies to Customer and Supplier transactions. When checked, only shows transactions that are allocated (e.g. payment allocated to an invoice).
Outstanding: Applies to customer and supplier transactions. When checked, only shows transactions that have no allocations (e.g. unpaid invoices).
VAT.: When checked only shows transactions where VAT was recorded (claimed or paid).
No VAT.: When checked only shows transactions on which no VAT was entered.
The Date on which the transaction was created or which the user selected as the Transaction Date.
Period
The Period for which the transaction was created.
Reference
An optional Reference entered by the user.
Currency
The Currency in which the transaction was recorded.
Category
The Category chosen for the transaction.
From
The source document number that the transaction originated from (if applicable).
Description
A Description entered by a user. The description shows the default if you do not overtype it.
Item No.
A sequential number allocated to each item on the same source document.
Allocated
The Amount allocated to an invoice.
Outstanding
The Amount that is still outstanding.
There are two allocated and outstanding columns: one for local and one for foreign currency. They are shown or hidden based on the selected Currency filter.
Department
The Department chosen for the transaction.
Debit
The Transaction Amount that was Debited to the account.
Credit
The Transaction Amount that was Credited to the account.
Balance
A running total of all the transactions in the account.