Ledger List Views

A ledger is a recordkeeping system used to track, organise and summarise financial transactions.

In QuickEasy BOS, the ledger interface lets you view transaction lists and general ledger accounts. (For the customer and supplier ledgers, see Customer Age Analysis and Statements and Supplier Age Analysis and Ledger Tutorials.)

You can also create all the transactions that are posted to the ledger from the New button.

Navigation Example

Main Menu > Accounting > Ledger


Buttons Explained

Button Description
ViewShows the entries that match the selected filters.
Arrow on View ButtonReset Data Filter: Resets all the selected data filters.
New

Creates a new transaction.

Select from a dropdown list of all the Transaction Types that post to the ledger, including those that post to the customer and supplier ledgers. The menu is grouped into Customer, Supplier and other.

When you create a transaction, the filters change to Date = Today with the Created and Transactions radio buttons selected, so that the new transaction appears when you return to the List View.

Output

Prints, previews or emails the output if Output Templates are set up for the module.

Export: Exports the list in .xlsx, .htm or .csv format.

Menu

Settings

Layout

Filters Explained

Filter Description
SetSelect a date option (e.g. No Date, Today, This Year).
ArrowsAdjusts the date in the direction of the arrow.
DateEnter or change the dates.
Created (radio button for date)Shows the records created during the selected date range.
Updated (radio button for date)Shows the records updated during the selected date range.
Trans (radio button for date)Shows the records with a transaction date in the selected date range (default selection).
Transactions
(radio button for type of display)
Shows a list of transactions.
Items
(radio button for type of display)
Shows the items on transactions.
Ledger
(radio button for type of display)
Shows a Detailed Ledger (e.g. opening balance, debits, credits).
Transaction Type / Ledger Account (dropdown list)
  • Transaction Types: Available when the Transactions or Items radio button is selected. Select a Transaction Type.
  • Ledger Account: Available when the Ledger radio button is selected. You must select a specific account. Otherwise, the message “Please select an Account.” appears when you click View.
Entity (dropdown list)

Select a registered entity to show only its records.

Unavailable if there is only one registered entity.

Local Currency

Checkbox. If checked, shows the local currency only.

Applies only to the Ledger (radio button) and Bank accounts.

Status Groups (checkboxes)

Check one or more statuses to show only the records with those statuses.

If none are checked, the records of all the statuses appear.

Applies only to Transactions and Items.

Fields Explained: Transactions

Info

When the Transactions radio button is selected, only the transaction totals appear. This option also shows transactions without items.

Screenshot of Ledger List View: Transactions
Ledger List View: Transactions

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number for the entry.
StatusThe transaction’s status.
TransThe Transaction Type’s code.
No.The transaction number.
DateThe transaction date.
FromThe code and number of the source transaction if a transaction was copied to create this transaction.
CompanyThe name of the Customer or Supplier.
ContactThe name of the customer or supplier’s contact person.
Entity (Reg)The registered entity selected for the transaction.
CategoryThe transaction’s category.
EntityThe branch or till selected for the transaction.
ReferenceThe reference on the transaction.
CurrencyThe transaction’s currency.
Total (exc)The VAT-exclusive total for the entry in the transaction’s currency.
VATThe VAT claimed or charged on the entry in the transaction’s currency.
Total (inc)The VAT-inclusive total for the entry in the transaction’s currency.
Outstanding

The amount outstanding in the transaction currency.

Outstanding refers to transactions that are not allocated to other transactions (e.g. customer invoices to which customer receipts are not allocated).

Outstanding (cur)

The amount outstanding in the local currency.

Outstanding refers to transactions that are not allocated to other transactions (e.g. customer invoices to which customer receipts are not allocated).

Total (exc cur)The VAT-exclusive total for the entry in the local currency.
VAT (cur)The VAT claimed or charged on the entry in the local currency.
Total (inc cur)The VAT-inclusive total for the entry in the local currency.
CreatedThe date on which the transaction was created.
UpdatedThe date on which the transaction was last updated.
Updated ByThe user who last updated the transaction.
Widget

A context menu (also opened by right-clicking the entry) with the following option:

  • Open Transaction: Opens the transaction.

Fields Explained: Items

Info

Selecting Items (radio button) shows only transactions with associated items.

Screenshot of Ledger List View: Items
Ledger List View: Items

Field Description
Field Chooser (*)Add or remove columns.
Status (Trans)The transaction’s status.
TransThe Transaction Type’s code.
No.The transaction number.
Ver No.The transaction’s version number.
DateThe transaction date.
CompanyThe name of the Customer or Supplier.
ContactThe name of the customer or supplier’s contact person.
RepThe name of the rep selected for the transaction.
ReferenceThe reference entered on the transaction.
Entity (Reg)The registered entity selected for the transaction.
Trans CategoryThe transaction’s category.
Trans FromThe code and number of the source transaction.
Dr TypeThe type of account that is debited (e.g. Ledger, Customer or Inventory). Inventory works like Ledger; the account comes from the entry’s location.
Cr TypeThe type of account that is credited (e.g. Ledger, Supplier or Inventory). Inventory works like Ledger; the account comes from the entry’s location.
Date CreatedThe date on which the transaction was created.
Date UpdatedThe date on which the transaction was last updated.
Updated ByThe user who last updated the transaction.
Status (Item)The status of the item on the transaction.
IDThe system-generated number for the entry.
Trans IDThe system-generated number for the transaction.
EntityThe branch or till selected for the transaction.
ItemThe sequence number for the item on the transaction.
Group byThe name of the group.
TypeThe type of item (e.g. EST for Estimate, CTM for Custom).
DescriptionThe item’s description.
Item CategoryThe item’s category.
Note

The item’s note.

The note created with View/Edit Note on the item’s context menu when capturing the transaction.

LocationThe item’s location if the item is an inventory item.
ResolveThe item’s resolve selection (e.g. purchase, receive, issue).
Dr AccountThe account that is debited.
Cr AccountThe account that is credited.
QtyThe item’s quantity.
Total (exc)The VAT-exclusive total for the entry in the transaction’s currency.
VATThe VAT claimed or charged on the entry in the transaction’s currency.
Total (inc)The VAT-inclusive total for the entry in the transaction’s currency.
Total (exc cur)The VAT-exclusive total for the entry in the local currency.
VAT (cur)The VAT claimed or charged on the entry in the local currency.
Total (inc cur)The VAT-inclusive total for the entry in the local currency.
Widget

A context menu (also opened by right-clicking the entry) with the following option:

  • Open Transaction: Opens the transaction.

  • The totals in the footer include all the displayed or selected transactions.
  • If some transactions are selected, the footer shows the total for the selected transactions.
  • The totals add up all the amounts, whether they are debits or credits.

Fields Explained: Detailed Ledger

Ledger in the Detailed Ledger view, listing the entries posted to each account
Ledger

Field Description
StatusThe transaction’s status.
Trans No.The transaction number.
DateThe transaction date.
Entity (Reg)The registered entity that the transaction is assigned to.
EntityThe transaction’s selected entity, which can be a registered entity, branch or till.
CompanyThe name of the Customer or Supplier.
ReferenceThe reference entered on the transaction.
Dr AccountThe name of the account that was debited.
Cr AccountThe name of the account that was credited.
CurrencyThe currency selected for the transaction.
DebitThe amount that was debited.
CreditThe amount that was credited.
Balance

The balance on the account.

The balance is calculated as follows:

  • Assets and Expenses: Credit entries are deducted from Debit entries (Dr – Cr).
  • Liabilities, Equity and Revenue: Debit entries are deducted from Credit entries (Cr – Dr).
Trans IDThe system-generated number for the transaction.
Widget

A context menu (also opened by right-clicking the entry) with the following option:

  • Open Transaction: Opens the transaction. The opening balance row has no transaction: the message “Unable to open the Opening Balance record.” appears.

Field Description
Column TotalsTotals appear below the Debit and Credit columns.
OpeningThe Opening Balance for the selected period.
Movement

The debits less credits for the selected period.

Movements that do not match the expected balance for an account appear in red (e.g. Credit Note entries in Sales).

Closing

The Closing Balance for the selected period.

Balances that do not match the expected balance for an account appear in red.

Report an issue with this page

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