Add to Favourites

Round Off Invoice and Ledger Values in TallyPrime

When recording sales or purchase transactions, the invoice value may include decimal amounts due to item rates, discounts, or tax calculations. While you can retain these decimal values, rounding them off can make invoice totals and financial statements easier to read. In TallyPrime, you can round off the total invoice value or an individual ledger value, such as the tax amount. You can also configure a voucher class to automatically include the round-off ledger while recording transactions.

Invoice Round Off – Using Predefined Ledger

You may want to maintain a ledger exclusively to round off the invoice value when you record an invoice. For this, you can create an Invoice Rounding ledger under Indirect expenses in TallyPrime.

1. Create a ledger for round-off.
   1. Create the ledger under Indirect Expenses.
   2. Type of Ledger – Select Invoice Rounding.
   3. In Rounding method, select the appropriate rounding method.
      1. Not Applicable – Keep the invoice value as is.
      2. Downward Rounding – Round off the invoice value to the nearest lower number, a multiple of the specified rounding limit.
         For example, if the invoice value is 125.60, the invoice value is rounded off to 125 (when the Rounding limit is set to 1), and the round-off ledger will have the value (-)0.60.
      3. Normal Rounding – Round off the invoice value to the following:
         • Nearest lower number that is a multiple of the rounding limit specified if the decimal value is less than 0.5. For example, if the invoice value is 125.30, the value is rounded off to 125, and the round-off ledger shows the value (-)0.30.
         • Nearest higher number that is a multiple of the rounding limit specified if the decimal value is more than or equal to 0.5. For example, if the value is 125.60, the value is rounded off to 126, and the round-off ledger shows the value 0.40 (when the Rounding limit is set to 1).
      4. Upward Rounding – Round off the invoice value to the nearest higher number, a multiple of the specified rounding limit. For example, if the invoice value is 125.30, the value is rounded off to 126, and the round-off ledger shows the value of 0.70 (when the Rounding limit is set to 1).
   4. For Rounding limit, enter the number to calculate the nearest number as a multiple of this number to round off. For example, if you mention 1, the invoice value is rounded off to the nearest number which is a multiple of 1. In this case, if the original invoice value is 12.30 and the Rounding Method is set to:

      • Normal Rounding: The invoice value will be rounded to 12.

      • Upward Rounding: The invoice value will be rounded to 13.

      • Downward Rounding: The invoice value will be rounded to 12.

        
   5. As always, press Ctrl+A to save. 
2. Use the round-off ledger in the sales invoice. The invoice value is rounded off, and the difference in value due to rounding off is displayed as a positive or negative number.
3. As always, press Ctrl+A to save.

Similarly, if you mention 5 as the Rounding Limit, the invoice value is rounded off to the nearest number which is a multiple of 5. For example, if the original invoice value is 14 and the Rounding Method is set to:

• Normal Rounding: The invoice value will be rounded to 15.
• Upward Rounding: The invoice value will be rounded to 20.
• Downward Rounding: The invoice value will be rounded to 10.

Invoice Round Off – Using Voucher Class

You may want the round-off ledger to appear automatically in the invoice to avoid selecting it every time you record a transaction. For this, you can create a voucher class in TallyPrime with the round-off ledger and use this voucher class to automatically display the round-off ledger in the invoice.

1. Create a voucher class for sales.
   1. Press Alt+G (Go To) > Alter Master > Voucher Type > type or select Sales > press Enter.
      Alternatively, Gateway of Tally > Alter > Voucher Type > type or select Sales > press Enter.
   2. Enter a name for the voucher class under Name of Class.
   3. Press Enter to view the Voucher Type Class screen.
   4. Under Additional Accounting Entries, select a ledger created under Indirect Expenses for accounting invoice round-off. In this ledger, set Use ledger for auto calculation of to Not Applicable.
   5. For the Type of Calculation, select As Total Amount Rounding.
   6. In Rounding method, select the appropriate rounding method.
      1. Not Applicable – Keep the invoice value as is.
      2. Downward Rounding – Round off the invoice value to the nearest lower number, a multiple of the specified rounding limit. For example, if the invoice value is 125.60, the invoice value is rounded off to 125 (when the Rounding limit is set to 1), and the round-off ledger shows the value (-)0.60.
      3. Normal Rounding – Round off the invoice value to the following:
         • Nearest lower number that is a multiple of the rounding limit specified if the decimal value is less than 0.5. For example, if the invoice value is 125.30, the value is rounded off to 125, and the round-off ledger shows the value (-)0.30.
         • Nearest higher number that is a multiple of the rounding limit specified if the decimal value is more than or equal to 0.5. For example, if the value is 125.60, it is rounded off to 126, and the round-off ledger shows the value 0.40 (when the Rounding limit is set to 1).
      4. Upward Rounding – Round off the invoice value to the nearest higher number, a multiple of the specified rounding limit. For example, if the invoice value is 125.30, the value is rounded off to 126, and the round-off ledger shows the value of 0.70 (when the Rounding limit is set to 1).
   7. For Rounding Limit, enter the number to calculate the nearest number as a multiple of this number to round off. For example, if you mention 5, the invoice value is rounded off to the nearest number which is a multiple of 5. To look at a few more detailed examples, refer to the Invoice Round Off – Using Predefined Ledger section.
   8. Remove if Zero – Set it to Yes to remove the ledger from the invoice if the ledger value is zero.
      
   9. As always, press Ctrl+A to save.
2. Use the voucher class in the sales invoice.
   1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales) > select the voucher class.
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales) > select the voucher class.
      The round-off ledger appears automatically.
   2. Enter the sales details.
      
   3. As always, press Ctrl+A to save.

By using the Voucher Class you don’t have to add the rounding off ledger every time you record a transaction. It automatically gets added to the voucher once the voucher class is selected.

Round Off only the Ledger Value

You can round off a particular ledger value instead of using the rounding off ledger to round off the invoice value. To do so you need to configure the specific ledger with the rounding off details. When you record an invoice, you may want to round off the value of the tax ledger. You need to configure the tax ledger created under Duties and Taxes with the appropriate rounding method.

1. Alter the ledger created under Duties & Taxes.
   1. For the Rounding method, select the appropriate rounding method.
      1. Not Applicable – Keep the invoice value as is.
      2. Downward Rounding – Round off the invoice value to the nearest lower number, a multiple of the specified rounding limit. For example, if the invoice value is 125.60, the invoice value is rounded off to 125 (when the Rounding limit is set to 1), and the round-off ledger shows the value (-)0.60.
      3. Normal Rounding -Round off the invoice value to the following:
         • Nearest lower number that is a multiple of the rounding limit specified if the decimal value is less than 0.5. For example, if the invoice value is 125.30, the value is rounded off to 125, and the round-off ledger shows the value (-)0.30.
         • Nearest higher number that is a multiple of the rounding limit specified if the decimal value is more than or equal to 0.5. For example, if the value is 125.60, it is rounded off to 126, and the round-off ledger shows the value 0.40 (when the Rounding limit is set to 1).
      4. Upward Rounding – Round off the invoice value to the nearest higher number, a multiple of the specified rounding limit. For example, if the invoice value is 125.30, the value is rounded off to 126, and the round-off ledger shows the value of 0.70 (when the Rounding limit is set to 1).
   2. For Rounding limit, enter the number to calculate the nearest number as a multiple of this number to round off. For example, if you mention 5, the invoice value is rounded off to the nearest number which is a multiple of 5. To look at a few more detailed examples, refer to the Invoice Round Off – Using Predefined Ledger section.
   3. As always, press Ctrl+A to save.
2. In the sales voucher, fill in other details.
   The tax ledger value rounds off as per the rounding method and limits set for that ledger. 
   
3. As always, press Ctrl+A to save the Sales Voucher.

The invoice values in decimal can be a bit difficult to read while viewing the financial statements. To simplify the view of financial statements and ensure maximum readability to the users, TallyPrime helps you round off such values.