For companies especially Property Management companies that need to generate hundreds or even thousands of Invoices every month with the same amount or need to charge late payment interest on overdue amount, it definitely a lengthy and tiring hassle job. With SQL Accounting System Recurring Invoice and Charging Late Payment Interest Module. It will be definitely be a great relieve for you. Let’s check out how it works.

#Please take note, for all old SQL Recurring Module User, you need to upgrade your customisation using a patch file when you upgrade your SQL Accounting System, else the module will not function correctly. You need to send the backup file to your dealer for this process and charges apply accordingly.
For this customisation to generate multiple Invoices, it is actually base on Quotation Template. In quotation, you can create different template. In each template you may insert different charges using different item/service code. Each template is to generate Invoice with same content for a group of customers. The most important is set the Quotation Number as Customer Category.

In maintain Customer, you need to categorise your customer under customer category. Just categorise them according to same charges. Example from total 1000 customer, 500 customer will be charging the same amount, these 500 customers should be under same customer category.

So that, when you click “Generate Bill” in Quotation, system will generate 500 Invoice with a single click for 500 customer under the same category instead you create Invoice one by one.

Another way to do especially when each customer may have different charges but still to charge monthly, you can go to Maintain Customer, under Water Meter Tab, maintain the Build Up Square Feet and Unit Price per Square Feet. If you do not charge base on square feet only, maybe need to add on parking lot plus other charges, then may key “1” under Square Feet and “Total Amount to Charge” in Price per Square Feet. The same concept can apply for other industries. Example Syntax charge SQL Accounting System Maintenance for Single User is RM800 per year, so, I will set “1” under Square Feet and “800” in Price per Square Feet. Remember to “Tick” at “Use Maintain Customer Price” option.

Let’s go back to Quotation, select the template that you want, set all the relevant info, and click on “Generate Bill”. System will show you the customer and amount that involve, click “Ok” when you satisfied and the system will run and generate all the Invoices. Imagine, with a single click, 500 Invoice will be generated instead you manually create those 500 Invoices.

For late payment interest, first, go to Maintain Item, maintain an item call Overdue, set the Reference Price as the Yearly Interest Rate, example 15% per year, you need to key as 0.15.

Next step, go to Customer->Print Customer Due Document, just make sure “Overdue” option is “Tick”, then click “Apply”, all overdue Invoice will be list out. You may change the Interest over this screen also.
 

Then click “Post To DN”. The system will generate Debit Note for the Interest Charge accordingly.

Please refer below for the Tutorial videos:

​