LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
evinna
Level 3

Under progress invoicing created from estimate, how come my inventory item gets split up according to the percentage?

I create a progress invoice from my estimate. 30% of the total estimate value. However when i preview my invoice, my inventory item QTY which is 17 pieces, becomes 5.1 piece. How do I correct this problem?

Solved
Best answer 3 weeks ago

Best Answers
Lyn_D
QuickBooks Team

Under progress invoicing created from estimate, how come my inventory item gets split up according to the percentage?

In QuickBooks Online (QBO), if the product has been provided, we can record the down payment and retain the quantity through the deposit box, Evinna. 

 

To retain the quantity of 17 pieces on the invoice, we need to convert 100% of the Estimate. First, ensure that the Deposit option is enabled from the Gear icon. Next, manually calculate 30% of the total amount of the converted invoice and enter that value in the Deposit box. This will allow us to view the down payment, the remaining balance, and keep track of the item quantity.

 

Here's how:

 

  1. Open the Invoice converted from the Estimate.
  2. Click on the Deposit box below Invoice Total.
  3. Manually enter the amount (30%).
  4. k.png
  5. Click on the Manage icon and select the Payment options dropdown.
  6. Select the Manage Deposit to choose the Payment method and the Deposit account.
    • Note: You can add a memo to add more details related to the transaction (invoice)

kk.png

kkk.png

 

 

However, if the product is not yet provided for this down payment, follow the steps detailed in this article: Record a retainer or deposit

 

As for the Proforma, in QBO, there isn't a separate (Pro-Forma) form template, but you can customize the estimate template to create a Pro-Forma Invoice for your customers.

 

Check the steps below:

 

  1. Go to Gear, then Custom Form Styles.
  2. Click New Style and choose Estimate.
  3. Click the Content tab, then the Pencil icon at the top right panel and change "Estimate" from the Form section to "Pro-Forma Invoice".
  4. Save the form style by clicking Done.

 

After you've setup your Pro-Forma Estimate Style, you can create the Estimate by going to + New, then Estimate. Make sure to click the Manage icon at the top of the Invoice and click on the Design dropdown to choose the template you created.

 

I've also add this article to guide you track your inventory items, such as your best sellers, what's on hand, and the cost of goods in the future: Use reports to see your sales and inventory status.

 

Feel fee to reply on the thread for any of your concerns. We're always here to help.

View solution in original post

3 Comments 3
Jelayca V
QuickBooks Team

Under progress invoicing created from estimate, how come my inventory item gets split up according to the percentage?

Hi @evinna. It’s indeed puzzling to see your inventory quantity displayed as a decimal in your invoice. This situation occurs because QuickBooks automatically splits inventory quantities based on the percentage of the total estimate being invoiced.

 

While we're unable to make manual adjustments to the quantity at this time, there's no need to worry. As you create subsequent progress invoices, QuickBooks will accurately calculate the totals at each stage, ensuring everything remains balanced by the time the invoice is finalized.

 

You can also keep the Note section in your invoice to inform your customers that the quantity may appear as a decimal (e.g., 5.1) due to the invoicing process; however, it represents a calculated amount from the estimate. This can help avoid confusion for your clients.

image.png

 

When your customer makes a payment, please record it properly to connect it to the invoice and balance your accounts. Also, regularly review and reconcile your accounts to match your financial statements.

 

To further enhance your QuickBooks experience, our QuickBooks Live Expert Assisted team can guide you on best practices for managing invoices and customers effectively.

 

If you have further questions about your transactions, including processing invoice payments or reconciling accounts in QuickBooks, please click the Reply button, and I'll respond promptly. Take care.

evinna
Level 3

Under progress invoicing created from estimate, how come my inventory item gets split up according to the percentage?

Dear Jelayca

 

Thank you for your reply. I would like to check with you if there is any other option for creating invoices based on my customer's requirement.

For eg:

I created an estimate to the customer.  And I converted the estimate to an official invoice.  However, the customer only wants to pay 30% downpayment for this invoice.  And balance 70% payable after delivery of products (inventory items) in 30 days credit terms.

They need an invoice showing 30% of the total invoice value.  If I perform the progress invoice, like i mentioned, my QTY in the invoice becomes 30% of the actual QTY of 17.  They will need to see the QTY 17 pieces and not 5.1 in order for their finance to process the 30% downpayment.

Can you kindly advise what can be done?

And also is there an option in QBO to create proforma invoice for customers on prepayment terms?

 

Thank you.

Lyn_D
QuickBooks Team

Under progress invoicing created from estimate, how come my inventory item gets split up according to the percentage?

In QuickBooks Online (QBO), if the product has been provided, we can record the down payment and retain the quantity through the deposit box, Evinna. 

 

To retain the quantity of 17 pieces on the invoice, we need to convert 100% of the Estimate. First, ensure that the Deposit option is enabled from the Gear icon. Next, manually calculate 30% of the total amount of the converted invoice and enter that value in the Deposit box. This will allow us to view the down payment, the remaining balance, and keep track of the item quantity.

 

Here's how:

 

  1. Open the Invoice converted from the Estimate.
  2. Click on the Deposit box below Invoice Total.
  3. Manually enter the amount (30%).
  4. k.png
  5. Click on the Manage icon and select the Payment options dropdown.
  6. Select the Manage Deposit to choose the Payment method and the Deposit account.
    • Note: You can add a memo to add more details related to the transaction (invoice)

kk.png

kkk.png

 

 

However, if the product is not yet provided for this down payment, follow the steps detailed in this article: Record a retainer or deposit

 

As for the Proforma, in QBO, there isn't a separate (Pro-Forma) form template, but you can customize the estimate template to create a Pro-Forma Invoice for your customers.

 

Check the steps below:

 

  1. Go to Gear, then Custom Form Styles.
  2. Click New Style and choose Estimate.
  3. Click the Content tab, then the Pencil icon at the top right panel and change "Estimate" from the Form section to "Pro-Forma Invoice".
  4. Save the form style by clicking Done.

 

After you've setup your Pro-Forma Estimate Style, you can create the Estimate by going to + New, then Estimate. Make sure to click the Manage icon at the top of the Invoice and click on the Design dropdown to choose the template you created.

 

I've also add this article to guide you track your inventory items, such as your best sellers, what's on hand, and the cost of goods in the future: Use reports to see your sales and inventory status.

 

Feel fee to reply on the thread for any of your concerns. We're always here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us