In accounting, Customer Accounts are records that track the financial transactions between a business and its individual customers. This account is essential for monitoring sales, payments received, and any outstanding balances.
In this tutorial, you will learn how to view Customer Accounts and Transactions in the Ledger. You will also learn how to process Customer Receipts, Overpayments, Refunds, and Discounts.
Navigation: Main Menu > Accounting > Ledger.
Table of Contents
Navigate to Main Menu > Accounting > Ledger.
Select the dates by either choosing a pre-set view in the Set (bar), or choose specific dates in the Date (bar).
Navigate to Filter (bar) > select Customer Account.
To filter on specific customers, located the Account (bar), then select the desired Customer.
Click View (button).
ℹ️ The Customer Account report in the Ledger shows all the Debit and Credit Entries for a particular customer. Most of the search and filter options will be greyed out. Using Filters that are not greyed out will switch the interface to Transaction View.
⚠️ When viewing a Customer Account in a Foreign Currency, transactions that were made in the Local Currency will not show on the Ledger (e.g. foreign exchange gains and losses). Local Currency transactions are only displayed when the Ledger is viewed in the Local Currency.
Navigate to Main Menu > Accounting > Ledger.
Select the dates by either choosing a pre-set view in the Set (bar), or choosing specific dates in the Date (bar).
Navigate to Filter (bar) > select Transaction Type (Transactions).
Locate the Transaction (bar), then select a Transaction Type linked with customers (e.g. Customer Invoices, Credit Notes, Customer Receipts).
Locate the Customer (bar) and select the desired Customer.
Click View (button).
Navigate to Main Menu > Accounting > Ledger.
Select the dates by either choosing a pre-set view in the Set (bar), or choosing specific dates in the Date (bar).
Navigate to Filter (bar) > select Transaction Type (Items).
Locate the Transaction (bar), then select a Transaction Type linked with Customers (e.g. Customer Invoices, Credit Notes, Customer Receipts).
Locate the Customer (bar) and select the desired Customer.
Click View (button).
Navigate to Main Menu > Accounting > Ledger.
Select New (button) > Customer Transactions > Customer Discounts (CD).
Enter the appropriate Date and Period.
Navigate to Customer (bar) > select the appropriate customer.
Navigate to Amount (bar) and enter the discount amount.
(Optional) Enter a Reference and Note.
Click Save (button) to display a list of outstanding items.
Allocate the Discount to the applicable invoices (see the Outstanding section on the bottom right):
Click Allocate (button) to automatically allocate the payment.
Click Select to choose the invoices by ticking the box next to the applicable invoices.
Change the Status to Complete.
Click Save (button).
ℹ️ There are two types of discounts applicable to Customers:
1. If you give a customer a reduced price, it will be shown on the invoice as a discount and reduce the invoice amount.
2. If you give a customer a settlement discount or a discount as a token of goodwill, the discount is entered following this procedure and will appear on the Statement of Profit and Loss as Discount Allowed.
Navigate to Main Menu > Accounting > Ledger.
Select New (button) > Customer Transactions > Customer Receipts (CR).
Enter the appropriate Date and Period.
Navigate to Customer (bar) > Select the appropriate Customer.
Navigate to Bank (bar) > Select the appropriate Bank.
Navigate to Amount (bar) > Enter the Amount paid.
Note: The VAT status of the payment can be edited next to the Amount (bar).
(Optional) Enter a Reference and Note.
Click Save (button) to display a list of outstanding items.
Allocate the Receipts to the applicable invoices (see the Outstanding section on the bottom right):
Click Allocate (button) to automatically allocate the payment.
Click Select to choose the invoices by ticking the box next to the applicable invoices.
Change the Status to Complete.
Click Save (button).
ℹ️ If the customer takes a Settlement Discount, you can apply that discount while doing the Customer Receipt as follows:
1. Right click on the outstanding amount in the Outstanding (column) and select Discount Outstanding.
2. Click Yes (button) on the pop-up.
3. The full balance remaining for that transaction will be written to Discount Allowed.
ℹ️ This is the process to follow if a Customer overpaid, and a refund is being issued.
Navigate to Main Menu > Accounting > Ledger.
Select New (button) > Customer Transactions > Customer Refund (CF).
Enter the appropriate Date and Period.
Navigate to Customer (bar) > Select the appropriate Customer.
Select the Bank (bar) > Select the desired Bank Account.
Navigate to Amount (bar) and enter the Amount refunded.
(Optional) Enter a Reference and Note.
Click Save (button) to display a list of outstanding items.
Allocate the Refund to the applicable invoices (see the Outstanding section on the bottom right):
Click Allocate (button) to automatically allocate the payment.
Click Select to choose the invoices by ticking the box next to the applicable invoices.
Change the Status to Complete.
Click Save (button).
ℹ️ This is the process to follow if a Customer overpaid, and it is being written off.
Navigate to Main Menu > Accounting > Ledger.
Select New (button) > Customer Transactions > Customer Overpayment (COP).
Enter the appropriate Date and Period.
Navigate to Customer (bar) > Select the appropriate Customer.
Navigate to Amount (bar) > Enter the Amount overpaid.
(Optional) Enter a Reference and Note.
Click Save (button) to display a list of outstanding items.
Allocate the Overpayment to the applicable invoices (see the Outstanding section on the bottom right):
Click Allocate (button) to automatically allocate the payment.
Click Select to choose the invoices by ticking the box next to the applicable invoices.
Change the Status to Complete.
Click Save (button).
Click Output (button) to display a dropdown list.
Click Print to print the report to the default printer, or click Print (Show Dialogue) to select a printer, for example, a .pdf printer.
Select Detailed Ledger or Transactions from the dropdown list.
Click Output (button) to display a dropdown list.
Click Preview to display the Transaction Items or Account on the screen.
Note: You can click the printer (icon) to print the list to a printer of your choice, including PDF.
Click Menu (button) > Email Excel to email the list of Transactions in Excel format, or
Click Output (button) > Email > Detailed Ledger to email the ledger account in PDF format.
Click Output (button) > Email > Transactions to email the list of Transactions in PDF format.