HomeTallyPrimeSales ProcessRound Off Invoice and Ledger Values

 

Explore Categories

 

 PDF

Round Off Invoice and Ledger Values

At the time of sale of goods or services, depending on the rate, the total amount may have decimals. It is easier to use or understand if the numbers are rounded off. The total invoice value is not automatically rounded off when you record an invoice. To round off the value of the invoice or the value of the tax ledger in the invoice, you can use the round-off feature in TallyPrime. You can also create a voucher class and when you are recording the voucher using that voucher class, the round-off ledger automatically appears in the voucher.

 

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.
      • Not Applicable – Keep the invoice value as is.
      • 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.
      • 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).
      • 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.
      set to Upward Rounding then the invoice value will be rounded to 13.
      set to 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.
set to Upward Rounding then the invoice value will be rounded to 20.
set to Downward Rounding, the invoice value will be rounded to 10.

You can use this procedure to round off the invoice value.

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, go to 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.
      • Not Applicable – Keep the invoice value as is.
      • 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.
      • 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).
      • 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, click here.
    8. Remove if Zero – Set it to Yes to remove the ledger from the invoice if the ledger value is zero.
      Configuring voucher class for round off
    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, go to Gateway of Tally > Vouchers > press F8 (Sales) > select the voucher class.
      The round-off ledger appears automatically.
    2. Enter the sales details.
      Invoice round off using voucher class
    3. As always, press Ctrl+A to save.

You can use this procedure to use the voucher class to round off the invoice value.

 

Round Off only the Ledger Value

When you record an invoice, you may want to round off the value of the tax ledger. For this, you can use the round-off feature in TallyPrime.

  1. Alter the ledger created under Duties & Taxes.
    1. For the Rounding method, select the appropriate rounding method.
      • Not Applicable – Keep the invoice value as is.
      • 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.
      • 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).
      • 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, click here.
    3. As always, press Ctrl+A to save.
  2. In the sales voucher, select the ledger. The ledger value rounds off as per the rounding method and limit.Round off the ledger value

This procedure can round off the ledger value in the sales invoice.

Post a Comment

Is this information useful?
YesNo
Helpful?