How to Auto-Calculate Billing Rate from Inclusive Rate in SwilERP

Using Inclusive Rate to Calculate Product Price During Sales Billing in SwilERP

This guide explains how to calculate the billing rate of a product in SwilERP when you have the inclusive rate (tax-inclusive price) available. By using the "Deduct Tax From Rate" feature in the Sales Invoice screen, users can automatically get the tax-exclusive rate required for billing.

The article walks you through each step from creating a sales invoice to applying the correct settings—along with reference images and important system defaults to check.

Start with Login in the SwilERP dashboard to initiate the process:

Go to the Sales menu > Sales Invoice.
Now, to create an invoice, click on the New tab.

Reference Window:

Sales Invoice Window

After that Sales Invoice window will appear on the next slide.
Enter the Customer name in the column.
Enter the Reference number and other details of the customer, if required.
Select the Product name from the drop-down list, or create it manually from the 'new' option.
After selecting a product, select the Batch number if you have multiple batch numbers of the product.
All further details i.e. MRP and Rate, will automatically fill in columns.
Enter the quantity of the product.

Reference Image:

Sales Invoice

As you can view the inclusive rate of the selected product.

Reference Image:

Inclusive Rate

Now, "right-click" on the screen with your mouse.
Select Deduct Tax From Rate option and click on it.

Reference Image:

Calculate Rate

Note: Please ensure that there is no check mark on the 'Sale Rate Inclusive Rate' option in the System Default window. Only then will the user see the 'Deduct Tax From Rate' option during the Sales billing. For this process, the user can contact their Local Service provider or make a ticket on Support.swildesk.com.

Reference Image:

System Default

Now, the users can view that the billing rate will be automatically calculated according to the inclusive rate.
For example, Rs 65.10 as inclusive rate & 12% tax has been included, so the software has auto-calculated the item rate as Rs 58.12 (65.10*12/112).

Reference Image:

Calculated Rate

Now to save the transaction, click on the Save tab.

Reference Image:

Save the Transaction