Customer Transaction Log - Checking A Customer's History of Transactions
The Customer Transaction Log report will give you a chronological history of all transactions and statements for a particular customer.
To access this report, open the Customer screen and select the customer you require.
Click the Menu button, if it does not automatically open, and then click the Customer Transaction Log button.
The options window will allow you to filter the results to show more or less information.
The Customer Transaction Log can be used as one of the tools to see how payments and credits were allocated against invoices and charges. Simply run the report over a date range, with the option ticked to Show Payment Details. Each Payment or Credit will then list which invoices or charges it pays off.
Report Options
Choose a start and stop date to select a range of transactions.
Choose the same date for both options to report on a single day.
Itemised Order Charges/Transactions - If ticked the report will show every item of each transaction.
Do Not Show Any Cash Transaction - Ticking this box will exclude all cash/Eftpos transactions from the report.
Do Not Show Any Layby Transaction - Ticking this box will exclude all layby transactions from the report.
Show Short Description - Tick this to use the short description instead of the long description.
Show Serial Numbers - Tick this box to display the serial number of an item sold if applicable.
Show Payment Details - If this box is ticked the report will display the invoice number/s that a payment has been applied to.
Show Unpaid Invoices Only - Ticking this box will only select invoices that are outstanding and filter the rest from the report.
Show Order Number & Delivery Notes - If an order number or delivery note has been applied to a sale ticking this box will show it on the report.
Show Serial Numbers - Tick this box to display the serial number of an item sold if applicable.
Show Payment Details - If this box is ticked the report will display the invoice number/s that a payment has been applied to.
Show Unpaid Invoices Only - Ticking this box will only select invoices that are outstanding and filter the rest from the report.
Show Order Number & Delivery Notes - If an order number or delivery note has been applied to a sale ticking this box will show it on the report.
Show Sale Notes - Ticking this will show any sales notes applied to a transaction
Show Delivery Address - Tick this box to show the delivery address used for a transaction where applicable.
Show Order Date Periods - Ticking this box will show the start/stop dates a standing order has set on relevant transactions.
Reading the Report
The transaction list will show each individual interaction the customer has had through Retailer with a totals section at the bottom.
Between each line you will see various information, depending on the options selected above, for that transaction if applicable.
E.g. Delivery details, serial numbers, notes, payment details.
Headings:
Date - The date of the transaction.
Date - The date of the transaction.
Number - The sale stamp of the transaction. (A unique number to identify that transaction)
Description - A description of the type of transaction e.g. Layby Deposit, Invoice payment.
Staff - The staff initials used during the transaction.
Amount - The value of the transaction.
Balance - The amount owing on a transaction.
Amount - The value of the transaction.
Balance - The amount owing on a transaction.
Related Articles
Sales Transaction Log
The Sales Transaction Log can be used to show all your previous transactions for the date range specified, which can be further separated based on transaction type, staff member, terminal used and payment type. Generating the Report On the top menu ...How to Add a Customer
We have a video guide on configuring new customer-specific settings and how to add new customers - ? Adding Customers There are 2 ways to add a customer in Retailer: Customer Screen Find Customer Screen Customer Screen On the main screen of ...Adding and Reviewing Transaction Notes
Transaction Notes allow you to type in notes against transactions, which can then be reviewed later on. Prompting for Transaction Notes On the top menu bar of Retailer, click on Setup -> General. Click on the Txn Notes tab. Tick the types of ...How do I do balance adjustments to Customer accounts?
To manually change a customer’s account balance, the easiest way is via a Balance Adjustment. The Balance Adjustment function can be used to write off bad customer debt. The adjustment will create a transaction that pays or charges the account. This ...Processing / Ageing Statements (Print / Preview / Email)
Considerations Customer statements are generally printed and sent once a month and are only used if you have customer accounts in Retailer. These are similar to statements that one would receive from the bank or utility (water, electricity etc.) ...