Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowI 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! Go to Solution.
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:
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:
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.
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.
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.
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.
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:
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here