Forum Discussion

VirgB's avatar
VirgB
Contributing User
3 years ago

Invoice addition of % Fuel Levy

Hi MYOB team,

Due to fuel increases we have to add a fuel levy to product we sell + delivery of the product.

Is there a way that we can add a % amount to the total of a sales invoice ?

The invoice may contain multiple lines of different priced product + a delivery rate.

Or

do I have to use a pre created item that is calculated out to be equivalent to the % of the fuel levy for each individual product ? 

+ another line for the item which = the % Levy for the different delivery areas ?

Any help appreciated

  • Hi VirgB 

     

    Currently AccountRight doesn’t have the capability to automatically calculate and add additional percentages to the sale.

     

    If you were using Item invoices, you could create an inventory item to calculate it for you. The item would need to have I sell this item ticked to be selectable on the invoice, but not I inventory this item.

    In terms of the item price it would be the percentage you were wanting to calculate, so a 10% calculation would be an item price of $0.10 or 10 cents

     

    When using the item, enter in all the other transaction lines to get the total of the invoice before the levy, then add the levy as an item for sale. Using the pre levy total of the invoice as the quantity for the levy will let it calculate and add the amount to the invoice.

     

    Let me know if this solves it for you.

  • Hi VirgB 

     

    Currently AccountRight doesn’t have the capability to automatically calculate and add additional percentages to the sale.

     

    If you were using Item invoices, you could create an inventory item to calculate it for you. The item would need to have I sell this item ticked to be selectable on the invoice, but not I inventory this item.

    In terms of the item price it would be the percentage you were wanting to calculate, so a 10% calculation would be an item price of $0.10 or 10 cents

     

    When using the item, enter in all the other transaction lines to get the total of the invoice before the levy, then add the levy as an item for sale. Using the pre levy total of the invoice as the quantity for the levy will let it calculate and add the amount to the invoice.

     

    Let me know if this solves it for you.

    • VirgB's avatar
      VirgB
      Contributing User

      Sorry I did not reply earlier.

      Appreciate you took the time to reply.

      I created individual items calculated to the fuel levy percentage for approx 30 different products that we sell by the tonne. 

      Have a little more time now so will try your suggestion. Thank You

    • The_Doc's avatar
      The_Doc
      Ultimate Cover User

      Hi VirgB 

       

      Yanike_S  suggestion would work perfectly - and is exactly how we add a component of fees if someone is using a credit card for payment - we add this on the bottom as a calculation of the total invoice.

       

      The Doc