Ledger Edit 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 and fields of the Ledger's edit views, for general transactions and for customer and supplier transactions.
Edit View
Information on Editing:
- When a Transaction only has one item, the amount and accounts can be edited in the transaction header.
- From the Menu button you can Enable Debit & Credit. When enabled, you can set the Debit/Credit Type and select any Account on the Debit and Credit side. This feature should ideally only be used in General Journal transactions.
- Transactions can be created directly in the Ledger or in separate Accounting modules. The source transactions created in separate modules (Customer Invoices, Customer Credit Notes, Supplier Invoices, Supplier Debit Notes) should not be edited in the Ledger, but transactions affecting them can (e.g. allocating a Customer Receipt).
General Transactions Buttons Explained
| Button | Description |
|---|---|
| Status Bar | Change the status of the transaction.
|
| ⬆ ⬇ | Arrow keys to scroll to the next or previous transaction. |
| Recent | Shows the most recent transactions created in the same session. |
| Output | Output PDF documents. Options are Print, Preview and Email. |
| Links | Links to any source documents used to create the transaction (also links to the document currently on screen). |
| New |
|
| Delete | Deletes the current transaction (if it is in Pending status). |
| Save | Saves or refreshes the current transaction.
|
| Done |
|
| Actions |
|
| Menu |
|
| Info (symbol) | Information block that provides details on the transactions and explains why a transaction cannot be edited. |
| Trial | Shows the transactions in a Trial Balance format. |
| Add Item | Add more items to split a transaction over multiple accounts. |
General Transactions Fields Explained
Header: Expenses
| Field | Description |
|---|---|
| Trans No. | A system-generated ledger number. |
| Date | The Date of the transaction. |
| Period | The Period of the transaction.
|
| Expenses (Dr) | The name of the Account that is Debited. |
| Bank (Cr) | The name of the Account that is Credited. |
| Amount | The transaction Amount. |
| VAT | The VAT Type selected for the transaction. |
| Inc. | Choose whether the amount includes VAT (Inc) or excludes VAT (Exc). |
| Reference | The user-entered Reference. |
| Note | The user-entered Note. |
| Reconcile | Indicates if the transaction was Reconciled or to mark the transaction as reconciled. |
| Recurring | Indicates if the transaction is on the list of Recurring transactions or to add the transaction to the list. |
Header: Other Transactions
| Field | Description |
|---|---|
| Trans No. | A system-generated ledger number. |
| Date | The Date of the transaction. |
| Period | The Period of the transaction.
|
| Reference | The user-entered Reference. |
| Note | The user-entered Note. |
| Reconcile | Indicates if the transaction was Reconciled or to mark the transaction as reconciled. |
| Recurring | Indicates if the transaction is on the list of Recurring transactions or to add the transaction to the list. |
Columns
Not all columns are available for every Transaction Type.
Fields marked in blue (✎) can be edited.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | The system-generated transaction number. |
| Description | The Description entered by a user. The description shows the default if you do not overtype it. |
| Dr Category | The Category to which the account that was Debited belongs. |
| Expense Allocation | Allocate an Expense to a Work Order or Sales Order. |
| Debit | The Account that was Debited for the line item. |
| Cr Category | The Category to which the account that was Credited belongs. |
| Credit | The Account that was Credited for the line item. |
| Cost Centre | A dropdown list from which a Cost Centre can be chosen. |
| Department | A dropdown list from which a Department can be chosen. |
| VAT Type | The VAT Type that was selected for the line item. |
| VAT % | The VAT percentage applicable to this transaction. |
| VAT | Choose whether the amount includes VAT (Inc) or excludes VAT (Exc). |
| Total ZAR | The line item's VAT Exclusive Amount in Local Currency. |
| Total ZAR (inc) | The line item's VAT Inclusive Amount. |
| Total ZAR (exc) | The line item's VAT Exclusive Amount in Local Currency. |
| Allocated Total | The amount of Expenses that were allocated. |
| VAT | The Amount of VAT applicable to the line item. |
| Total (inc) | The line item's VAT Inclusive Amount. |
| ... | Click the cross to delete the line item (if the transaction is still Pending). |
Customer and Supplier Transactions Buttons Explained
| Button | Description |
|---|---|
| Status Bar | Change the Status of the transaction.
|
| ⬆ ⬇ | Arrow keys to scroll to the next or previous transaction. |
| Recent | Shows the most recent transactions created in the same session. |
| Output | Output PDF documents. Options are Print, Preview and Email. |
| Links | Links to any source documents used to create the transaction (also links to the document currently on screen). |
| New |
|
| Delete | Deletes the current transaction (if it is in Pending status). |
| Save | Saves or refreshes the current transaction.
|
| Done |
|
| Actions |
|
| Menu |
|
| Info (symbol) | Information block that provides details on the transactions and explains why a transaction cannot be edited. |
| Trial | Click to view the transaction in a Trial Balance format. |
| Add Item | Add another line item. Used when a transaction is split across multiple accounts. |
| Clear | Clears all the allocated transactions. |
| Menu |
|
| Select |
|
| Allocate | Click the button to auto-allocate invoices (if none are selected) or to allocate the selected invoices. |
| From | Prefills the source document that was used to create the transaction (e.g. discount transactions). |
| Bank ID | Prefills the batch number if the transaction was created using a Bank Import. |
| Updated | User who last updated the transaction. |
| Date and Time | Date and Time of the last update (in the server's time zone). |
| Currency | The Currency of the current transaction. |
| Rate | The Rate of Exchange. |
Customer and Supplier Transactions Fields Explained
| Field | Description |
|---|---|
| Trans No. | A system-generated ledger number. |
| Date | The Date of the transaction. |
| Period | The Period of the transaction.
|
| Customer / Supplier | The name of the customer or supplier. |
| Bank | The name of the Bank Account where applicable (e.g. for Customer Receipts and Supplier Payments).
|
| Amount | The transaction Amount. |
| VAT | The VAT Type selected for the transaction. |
| Inc. | Choose whether the amount includes VAT (Inc) or excludes VAT (Exc). |
| Reference | The user-entered Reference. |
| Note | The user-entered Note. |
| Reconcile | Indicates if the transaction was Reconciled or to mark the transaction as reconciled. |
| Recurring | Indicates if the transaction is on the list of Recurring transactions or to add the transaction to the list. |
| Field Chooser (*) | Add or remove columns. |
| ID | The system-generated transaction number. |
| Description | The Description entered by a user. The description shows default if you do not overtype it. |
| Dr Category | The Category to which the account that was debited belongs. |
| Expense Allocation | Allocate an Expense to a Work Order or Sales Order. |
| Debit | The Account that was Debited for the line item. |
| Cr Category | The Category to which the account that was Credited belongs. |
| Credit | The Account that was Credited for the line item. |
| Cost Centre | A dropdown list from which a Cost Centre can be chosen. |
| Department | A dropdown list from which a Department can be chosen. |
| VAT Type | The VAT Type that was selected for the line item. |
| VAT % | The VAT percentage applicable to this transaction. |
| VAT | Choose whether the amount includes VAT (Inc) or excludes VAT (Exc). |
| Total ZAR | The line item's VAT Exclusive Amount in Local Currency. |
| Total ZAR (inc) | The line item's VAT Inclusive Amount. |
| Total (exc) | The line item's VAT Exclusive Amount. |
| Allocated Total | The amount of Expenses that were allocated. |
| VAT | The amount of VAT applicable to the line item. |
| Total (inc) | The line item's VAT Inclusive Amount. |
| ... | Click the cross to delete the line item (if the transaction is still Pending). |
| Trans | A code that indicates the Transaction Type of the allocated transaction. |
| No. | The number of the source document (e.g. invoice number) |
| Date | The Date of the allocated transaction. |
| Reference | The Reference entered in the allocated transaction. |
| Total | The Total Amount due on the source document. |
| Allocated | The Amount that was allocated. |
| ... A submenu that lets you: |
|
| Trans | A code that indicates the Transaction Type of the allocated transaction. |
| No. | The number of the source document (e.g. invoice number) |
| Date | The Date of the allocated transaction. |
| Reference | The Reference entered in the source document. |
| Total | The Total Amount due on the source document. |
| Outstanding | The Amount that is outstanding. |
| Allocate |
|
| Checkbox | To select outstanding items to allocate. |
| ... | A submenu that lets you:
|
| From | Prefills the source document that was used to create the transaction (e.g. discount transactions). |
| Bank ID | Prefills the batch number if the transaction was created using a Bank Import. |
| Updated | User who last updated the transaction. |
| Date and Time | Date and Time of the last update (in the server's time zone). |
| Currency | The Currency of the current transaction. |
| Rate | The Rate of Exchange. |
All transactions should have both Debit and Credit entries. However, in QuickEasy BOS Enterprise it is possible for someone to create or edit a transaction and leave it in an incomplete state. When this happens a red warning bar appears to warn of a Trial Error.