Ledger List Views

Overview

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.

Navigation Example

Main Menu > Accounting > Ledger

Buttons Explained

Button Description
ViewGenerates a report based on the selected Data Filters.
NewOpens a dropdown list from which a Transaction Type can be selected to create a transaction.
  • Click the button to create a transaction using the same Transaction Type as most recently used.
  • Click the arrow on the new button for the dropdown list.
OutputOutput PDF documents. Options are Print, Preview and Email.
Actions > Batch UpdateOnly available with Transaction Type (Items).
  • Department: Change the Department for all the selected transactions.
  • VAT: Change the VAT Type, Inclusive or Exclusive option, and VAT Percentage for all the selected transactions.
Menu
  • Reset Data Filter
  • Open Recurring
    • Opens transactions that were set as recurring when they were created.
    • This feature lets you quickly record transactions that recur.
  • Copy to New:
    • Select Date, Reference, Note (or a combination of them)
    • Applies to recurring transactions. Duplicates the selected transaction.
  • Date Grouping: Option to group records only in Transaction Type (Items).
    • By Date
    • By Month
    • By Year
    • Relative
  • Export
    • Email Excel
    • Email Grid
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Filters Explained

Filter Description
SetSets 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.
DateFurther refine the date selections.
Radio ButtonsSort 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.
FilterDropdown 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.
TransactionView all or a specific Transaction Type. Only available when Transaction Types are selected.
AccountSelect a specific account. Only applies to Customer, Supplier or General Ledger Accounts. Defaults to All.
CurrencySelect a specific currency if multiple currencies are used. Only applies to Customer, Supplier and General Ledger Accounts.
CheckboxesCheckboxes 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.

Transactions Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated overall number allocated to the transaction.
StatusThe current status of the transaction.
TypeA code indicating the source Transaction Type.
Trans No.The system-generated transaction number allocated to the source document.
Bank IDThe Bank Import batch number.
VAT IDThe linked VAT Reconciliation ID (if the transactions are added to a VAT Reconciliation).
FromThe source document number that the transaction originated from (if applicable).
DateThe date on which the transaction was created or which the user selected as the Transaction Date.
PeriodThe Period for which the transaction was created.
CompanyThe name of the customer or supplier.
Acc No.The Account Number of the customer or supplier.
DescriptionThe user-provided description.
ReferenceAn optional reference entered by the user.
Alloc CURThe amount allocated in Foreign Currency. Only displayed if allocations are used.
Out CURThe amount outstanding in Foreign Currency. Only displayed if allocations are used.
Alloc ZARThe amount allocated in Local Currency. Only displayed if allocations are used.
Out ZARThe amount outstanding in Foreign Currency. Only displayed if allocations are used.
Total (Exc)The transaction amount excluding VAT.
VATThe VAT component of the transaction.
Total (Inc)The transaction amount including VAT.
RepThe Sales Representative selected when the transaction was created.
CategoryThe Category chosen for the transaction.
RIndicates if the transaction is a recurring transaction.
OTE(Override Trial Error) Checkbox that is ticked if the transaction was overwritten because of a Trial Balance Error.
  • Ticking the box prevents the transaction from appearing when searching for Trial Balance Errors.
  • Tick it only when a debit and credit transaction must be created separately.
  • Keep a record of these transactions for audit purposes.
Updated byThe name of the User who updated the transaction.
UpdatedThe system-generated Date on which the transaction was updated.
✔Indicates if the transaction was Reconciled.
CurrencyThe Currency symbol used in the original transaction.
Total CURThe Total Amount of the transaction in local currency.
UserName of the User who created the transaction.
...A submenu to:
  • Open Transaction: Opens the source transaction.
  • Delete Transaction: Deletes a pending transaction.
  • Open Customer/Supplier Summary: Opens a summary display with tabs for Detail, Account and Transactions.
  • View linked Transactions: Opens a report on the right with all the linked transactions.
  • View Audits: Displays a detailed record of who created and edited the transaction.

Transaction Items Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
TransIDThe system-generated transaction number.
StatusThe current Status of the transaction.
TypeCode indicating the source Transaction Type.
Trans No.The system-generated Transaction Number allocated to the source document.
Bank IDThe Bank Import batch number.
FromThe source document number that the transaction originated from (if applicable).
DateThe Date on which the transaction was created or which the user selected as the transaction date.
CompanyThe name of the customer or supplier.
Acc No.The Account Number of the customer or supplier.
CategoryThe Category chosen for the transaction.
DepartmentThe Department chosen for the transaction.
DescriptionThe department's Description.
ReferenceAn optional Reference entered by the user.
Updated byName of the User who updated the transaction.
UpdatedThe system-generated Date on which the transaction was updated.
ItemIDA system-generated number allocated to the item.
Item No.A sequential number allocated to each item on the same source document.
DescriptionThe user-provided Description when entering the transaction.
Dr. CategoryThe Category of the account that was Debited.
Dr. AccountThe Account that was Debited.
Cr. CategoryThe Category of the account that was Credited.
Cr. AccountThe Account that was Credited.
VAT TypeThe VAT Type used on the source transaction.
VATWhether the source transaction was entered Exc or Inc VAT.
Total (exc)The transaction amount excluding VAT.
VATThe amount of VAT on the transaction.
Total (inc)The transaction amount including VAT.
Dr. Acc No.The Account number of the account Debited.
Cr. Acc No.The Account Number of the account Credited.
VAT %The percentage of VAT included in the transaction.
Cost CentreThe Cost Centre allocated to the transaction.
Expense AllocationThe Account to which the expense was allocated.
Allocated TotalThe Total Amount of the transaction that was allocated.

General Ledger Accounts Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
Trans IDA system-generated number allocated to the transaction.
StatusThe Status of the transaction.
TypeA code indicating the source Transaction Type.
Bank IDThe Bank Import batch number.
DateThe Date on which the transaction was created or which the user selected as the transaction date.
PeriodThe Period for which the transaction was created.
ReferenceAn optional Reference entered by the user.
CurrencyThe Currency in which the transaction was recorded.
CategoryThe Category chosen for the transaction.
FromThe source document number that the transaction originated from (if applicable).
DescriptionThe 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.
Dr Acc. No.The Account Number that was Debited.
Dr AccountThe Account Name that was Debited.
Cr Acc. No.The Account Number that was Credited.
Cr AccountThe Account Name that was Credited.
DepartmentThe Department chosen for the transaction.
DebitThe transaction amount that was Debited to the account.
CreditThe transaction amount that was Credited to the account.
BalanceA running total of all the transactions in the account. Balances are calculated as follows:
  • Assets and Expenses: Debits less Credits. If credits exceed the debits the balance is negative.
  • Liabilities, Equity and Revenues: Credits less Debits. If debits exceed the credits the balance is negative.
✔Indicates if the transaction was Reconciled.

Customer and Supplier Accounts Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
Trans IDA system-generated number allocated to the transaction.
StatusThe Status of the transaction.
TypeCode indicating the source Transaction Type.
Trans No.The source document's number.
Bank IDThe Bank Import batch number.
DateThe Date on which the transaction was created or which the user selected as the Transaction Date.
PeriodThe Period for which the transaction was created.
ReferenceAn optional Reference entered by the user.
CurrencyThe Currency in which the transaction was recorded.
CategoryThe Category chosen for the transaction.
FromThe source document number that the transaction originated from (if applicable).
DescriptionA 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.
AllocatedThe Amount allocated to an invoice.
OutstandingThe 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.
DepartmentThe Department chosen for the transaction.
DebitThe Transaction Amount that was Debited to the account.
CreditThe Transaction Amount that was Credited to the account.
BalanceA running total of all the transactions in the account.
✔Indicates if the transaction was Reconciled.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.