Customer Detailed Ledger

The Customer Detailed Ledger shows all the transactions with a specific customer in the selected period, with a running balance.

In QuickEasy BOS, this ledger is linked to the Customer Age Analysis and is accessed from there.

Customer Detailed Ledger, listing a customer’s transactions with a running balance — Customer Detailed Ledger

Buttons Explained

Button	Description
View	Shows the entries that match the selected filters.
Arrow on View Button	Reset Data Filter: Resets all the data filters.
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	Views Age Analysis Detailed Ledger Transactions Settings Edit User Access Layout

Filters Explained

Filter	Description
Set	Select a date option from the dropdown list: No Date (shows all the entries) User Date This month Last month Last 3 months Last 6 months Last 12 months Last 24 months This year Last year
Navigational Arrows	Adjusts the dates in the direction of the arrow.
Date … to …	Enter your own dates.
Customer	Select a customer from the dropdown list. If none is selected, the message “Please select a Customer.” appears when you click View (button).
Entity	Select an entity from the dropdown list.
Local Currency	A checkbox. If checked, foreign currency transactions are converted and shown in the local currency.

Fields Explained

Field	Description
Field Chooser (*)	Add or remove columns.
Trans ID	The system-generated number for the transaction.
Status	The colour-coded status of the transaction.
Trans	The Transaction Type’s code.
No.	The transaction number.
Trans No.	The Transaction Type’s code (e.g. CI for Customer Invoice) and number. Combines the Trans and No. fields.
Date	The date of the transaction.
Entity (Reg)	The registered entity to which the transaction is allocated.
Entity	The entity selected for the transaction, which can be a till, branch or registered entity.
Reference	The reference entered on the transaction.
Currency	The transaction’s currency. Appears only if the customer is invoiced in a foreign currency.
Debit	The amount that was debited for the specific entry.
Credit	The amount that was credited for the specific entry.
Allocated	The amount allocated (e.g. customer invoices allocated to payments).
Outstanding	The amount that is still outstanding.
Balance	The running total (balance) on the account.
	A context menu (also opened by right-clicking the entry) with the following options: View/Edit Allocation: Opens the allocation for the selected entry. If the transaction can be edited, the allocation can be edited. If the transaction is read-only, the allocation is also read-only. Open Transaction: Opens the original transaction.

Field	Description
Opening	The opening balance at the start of the selected period.
Closing	The closing balance at the end of the selected period.