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

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:

  1. Go to the Sales menu > Sales Invoice.
  2. Now, to create an invoice, click on the New tab.
Reference Window:

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

Sales Invoice
  1. As you can view the inclusive rate of the selected product.
Reference Image:

Inclusive Rate
  1. Now, "right-click" on the screen with your mouse.
  2. 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
  1. Now, the users can view that the billing rate will be automatically calculated according to the inclusive rate.
    1. 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
    1. Now to save the transaction, click on the Save tab.
    Reference Image:

    Save the Transaction



        • Related Articles

        • Creating Sales Invoices with SwilPOS Mobile App

          Generate Sales Invoices effortlessly using the SwilPOS Mobile App The SwilPOS Mobile App makes it easy for businesses to create sales invoices without any hassle. With just a few taps on the app, professional-looking invoices can be generated ...
        • Billing Head

          Creating and Managing Billing Heads in SwilERP In the SwilERP software, there is an option in the Masters section to create a Billing Head: Now here you will follow the steps for creating Billing Heads in SwilERP. Go to the SwilERP Dashboard: Select ...
        • Create Sales Invoice in SwilERP

          How to Generate Sales Invoice in SwilERP Software A Sales Invoice is a formal document issued by a vendor to customers for products or services rendered. In SwilERP, users can generate sales invoices from the sales menu, containing transaction ...
        • Create Sales Challan & Convert Into Sales Bill

          How to Create and Manage a Sales Challan in SwilERP Sales Challan is an agreement to sell the goods in which property/ownership of the goods is not passed to the buyer till an Invoice is prepared. The customer only has possession of the goods but is ...
        • Fast Moving Counter Billing Flow in SwilERP

          Overview: Handling high-volume sales at your store? The Fast Counter Billing feature enables quick checkout, reducing wait times and enhancing customer experience. Steps to Process Sales at Fast-Moving Counters: Go to the Sales Menu → Select Counter ...