Spenno7
Level 1
‎May 05, 2023 08:30 PM

Invoice a selected percentage multiplied by an input value

We are a freight merchant that calculates customs duty payable and invoices that to the customer plus our processing fees. We would like to be able to select a duty tariff code for each line item (let's call that 'a'), input the value of the merchandise being shipped by our customer ('b'), and charge 'a' x 'b' on the customer's invoice. For example, the customer imports $1,000 worth of bananas, the applicable duty rate might be 10%: we want to be able to select the tariff rate for bananas (item?), input $1,000 and have Quickbooks charge the customer $100 (10% x $1,000). Then move onto line item two and choose a different tariff and input a different value and so on. I have tried with service charge rates but this seems to be on all other line item totals rather than line by line, and does not allow me to enter a line item value to multiply out.

 

We are using QuickBooks Desktop.

Reply
FateCandylaneT
QuickBooks Team
QuickBooks Team
‎May 05, 2023 11:05 PM

About QB Community

I appreciate you reaching out to us, Spenno7. Let me share details to help you enter and manage the invoices sent to your customers.

 

In QuickBooks Desktop, having the ability to calculate custom duty tariff codes for each line item and being able to charge the customer with the total percentage multiplied by an input value is an excellent feature. As QuickBooks can't multiply numbers line by line, I understand the convenience to easily track and charge customers with the associated custom tariff codes. However, we can enter these totals in each line item manually. You'll have to enter the total amount directly per line item.

 

Additionally, you'll want to consider looking for a third-party app that will help you calculate and invoice a selected percentage by an input value.

 

Moreover, you can review and track your business finances and company accounting data by running specific reports.

 

Let us know in the comments below if you have additional questions or other QuickBooks-related concerns. We're always here to help. Take care!

Reply