Call or Whatsapp

+6012 663 9318

or Email

info@syntech.com.my

Ask Bryan Cheong SQL Accounting System Customer Deposit & Sales Invoice with Payment Info

SQL Accounting System - Syntax Technologies

Ask Bryan Cheong SQL Accounting System Customer Deposit & Sales Invoice with Payment Info

For certain industries, such as furniture shop, customer required to make upfront payment as deposit and the uit can be one time deposit or multiple deposit. At the end of the day, customer may request the Invoice show the original total minus deposit and nett total to be paid. 

Let’s create an Invoice as normal with total amount RM9,000.

There are two ways to do the deposit. First way, as usual, you may direct create a customer payment and knock off with the invoice. In this example we create an customer payment RM1,000 and knock off Invoice, which make the Invoice outstanding become RM8,000.


Second way, is to make use of Customer Deposit Module, at Customer->Customer Deposit. Key in customer deposit amount, then save the transaction. In this example, we create a deposit RM4,000.

When want to use the deposit for payment, go back to Customer Payment to key in, instead of direct key in the paid amount, select “From Deposit” and amend the amount that you want to use and knock off Invoice accordingly. You may use the Deposit for multiple Customer payment. In the example, we created three customer payments for that invoiceFirst payment is direct customer payment, and the other two is customer payment from one customer deposit.

We go back to the Sales Invoice, preview the Invoice using the customised Invoice template, and you will see that all the payment info will be shown and the original amount will deduct paid amount
and display a nett amount for customer to pay off. 

This template is very useful for certain industries especially furniture shop when want to chase for final payment.

Please refer below for the complete tutorial video.