Get 50% 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.
CharlieB65
Level 2

Best practice to reconcile purchase order items for non-inventory items with the actual delivered items?

Hello all,

I would like to know the best practice to record what is actually being received from purchase orders or bills paid to suppliers?

 

Here is the situation:

 

My daughter's business buys deals for clothing online, but before she buys them she sells them to her followers.  These customers pay a percentage of the items.   After the advance payment is received she orders them from multiple suppliers.  These items are accounted as non-inventory because they are unique, limited quantity, high valued and rarely repeat.

 

In order to keep some control, she creates an invoice (not sent) to the online customers that records the client, item being purchased that is created as non-inventory item.  At the end of any day she orders what she sold.  The complexity arrises when the providers doesn't fulfill the order 100% (sometimes 1-3 weeks later) and thus is hard to follow what's missing.  Bear in mind that any shortage in an order fullfillment can seldom be purchased again, and then she is required to reimburse the customer.

 

How will you handle this situation for control within QBO?

 

All the best,

 

C.

1 Comment 1
IrizA
QuickBooks Team

Best practice to reconcile purchase order items for non-inventory items with the actual delivered items?

Hi @CharlieB65,

 

I can see that you're looking for the best way to record what you receive from purchase orders or bills paid to suppliers. 

 

It gets tricky when the suppliers don't fulfill the entire order and there are delays of 1-3 weeks, making it hard to figure out what's missing. 

 

I'm here to assist you in addressing this challenge effectively. 

 

To track customer orders and purchases with ease, we can utilize the Progress Invoicing feature in QBO. This feature allows us to monitor the quantity ordered and the items delivered, ensuring a clear balance between them.

 

Here's how: 

 

STEP 1: Turn on the Progress invoicing feature in QBO. 

 

  1.  Go to Settings. Then select  Account and Settings.
  2. Select the Sales tab. 
  3. In the Progress Invoicing section, click edit. Then click it on.
  4. In the Update your invoice template? window, select Update.
  5. Select Save, then Done.

 

STEP 2:  Create a bank deposit. Use the A/R category. 

 

   1. Go to the New icon. 

   2. Under Other, click Bank Deposit.

   3. Fill out the necessary information: 

  • RECEIVED FROM: name of the customer
  • ACCOUNT: Accounts Receivable.
  • PAYMENT METHOD: choose the method used by the customer
  • AMOUNT: received amount.

   4. Click Save.

 

STEP 3: Create an Estimate and fill out the field provided.  

 

   1. Go to the New icon. 

   2. Under Customers, click Estimate.

   3. Fill out the necessary information, then Save.

 

STEP 4: Copy the estimate to the purchase order

 

STEP 5: After the purchase order is fulfilled, create the invoice from the estimate and send it to the customer.

     

STEP 6: Apply the advanced payment to the invoice. 

 

However, I recommend contacting your accountant for best practices.

 

If you want to add estimates to the project, you can check out this article: Create and Manage Projects.

 

If you have other concerns aside from progress invoicing, please don't hesitate to reach out. Have a great day! 

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

Need to get in touch?

Contact us