In accounting, Supplier Accounts are records that track the financial transactions between a business and its individual suppliers. This account is essential for monitoring purchases, payments made, and any outstanding balances.
These tutorials explain how to view Supplier Ledger Accounts and Transactions. They also explain how to create Supplier Payments, Overpayments, Refunds, and Discounts.
Navigation Example: Main Menu > Accounting > Ledger
Table of Contents
ℹ️ Supplier Accounts display all the Debit and Credit Entries. Most of the search and filter options are greyed out because they do not apply. Certain filters may switch the interface to Transaction Type View.
Navigate to the Ledger.
Select the dates by either choosing pre-set dates next to Set or entering specific dates.
Filter = Select Supplier Account from the dropdown list.
Account = Select a Supplier from the dropdown list or select All.
Click View (button).
Navigate to the Ledger.
Select the dates by either choosing pre-set dates next to Set or entering specific dates.
Filter = Select Transaction Type (Transactions) from the dropdown list.
Transaction = Select a Transaction Type that involves Suppliers (e.g. Supplier Invoices, Debit Notes) from the dropdown list.
Supplier = Select a Supplier from the dropdown list or select All.
Click View (button).
Navigate to the Ledger.
Select the dates by either choosing pre-set dates next to Set or entering specific dates.
Filter = Select Transaction Type (Items) from the dropdown list.
Transaction = Select a Transaction Type applicable to Suppliers (e.g. Supplier Invoices, Debit Notes).
Supplier = Select a Supplier from the dropdown list or select All.
Click View (button).
ℹ️ There are two types of discounts applicable to Suppliers:
1. If a supplier gives you a reduced price, it is shown on their invoice and reduces your cost of sales. This discount is not shown separately.
2. If a supplier gives you a settlement discount or a discount as a token of goodwill, the discount is entered following this procedure and appears on the Statement of Profit or Loss as Discount Received.
Navigate to the Ledger.
Click the arrow on New (button) > Supplier Transactions > Supplier Discounts (SD).
Enter the Date and Period.
Supplier = Select the supplier that the discount applies to from the dropdown list.
Amount = Enter the discount amount.
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 checking the applicable invoices.
Change the Status to Complete.
Click Save (button).
ℹ️ If you receive a Settlement Discount, you can apply that discount while doing the Supplier Payment as follows:
1. Right click the outstanding amount in the Outstanding (column) and select Discount Outstanding from the context menu.
2. Click Yes (button) on the popup to confirm the discount.
3. The full balance remaining for that transaction is written off as Discount Received.
Navigate to the Ledger.
Click New (button) > Supplier Transactions > Supplier Payments (SP).
Enter the Date and Period.
Supplier = Select the supplier that made the payment.
Bank = Select the bank account from which the payment was made.
Amount = Enter the amount paid.
VAT = Select No VAT from the dropdown list next to Amount.
Enter a Reference and Note.
Click Save (button) to display a list of outstanding items.
Allocate the Payment 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 you overpaid the Supplier, and the supplier has now refunded you.
Navigate to the Ledger.
Click New (button) > Supplier Transactions > Supplier Refund (SF).
Enter the Date and Period.
Supplier = Select the supplier that is refunding you.
Bank = Select the bank account into which the refund was paid.
Amount = Enter the amount refunded.
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 you overpaid a Supplier, and you want to write off the overpayment as a loss.
Navigate to the Ledger.
Click New (button) > Supplier Transactions > Supplier Overpayment (SOP).
Enter the Date and Period.
Supplier = Select the Supplier that was overpaid.
Amount = Enter the amount that was overpaid.
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 (e.g. 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.
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.