QuickBooks Online and Invoice before packing

October 29, 2019


QuickBooks Online and Invoice before packing

stacked parcels
1. Introduction
One of our clients asked us: “What happens with QuickBooks Online integration with Sales Orders which are invoiced before packing?”.
Our answer was: “You have to keep an eye on Cost of Goods Sold (COGS)”.
For someone who is not an accountant, this looks confusing. In this blog, we will represent a detailed case scenario.
2. Invoice before packing
Packing items in ERPAG is a moment when the items are “taken” from the stock. In case you don’t have sufficient quantity in stock, you won’t be able to pack the items.
The usual chronological order of documents is:
  1. Purchase order
  2. Goods Received Note
  3. Supplier Invoice
  4. Payment to supplier
  1. Work order
  2. Load Materials
  3. Work operations
  4. Deliver Finished Goods
  1. Sales order
  2. Packing list
  3. Shipment
  4. Invoice
  5. Payment from customer
Of course, nothing is ideal in practice, so we always have some deviations. One example is an Advance payment.
For practical reasons, ERPAG allows us to generate an Invoice before packing the items.
In our case, we generated an Invoice on October 22nd.
invoiced sales order
The reasons are different – from closing the advance payment to the customer’s wish to have an invoice before the items are delivered to him.
In our example, we did an Invoice before we even got the goods for the customer from our supplier.
3. Procurement
The next day, through the fulfillment option, we generated a Purchase order for the missing quantity.
And we received items to our stock:
receive purchase order
After that, we “got” a supplier invoice:
purchase order supplier invoice
4. Packing previously invoiced Sales Order
After we received the items, we have sufficient quantity in our stock, in order to pack the Sales Order:
generate packing list
And this is how the synchronization list looks like:
qbo synchronization list
5. QuickBooks Online results
On the COGS account, we have an adequate value:
COGS in quickbooks online
This is the recommended workflow.
6. What would happen if we synchronize the Sales Order, that is not packed?
sales order
We can achieve a similar effect if we sync only the “Sales Order”.
synchronize sales order to quickbooks
The COGS in QuickBooks Online will be 0.
qbo cogs account
That’s because we don’t have adequate data in QuickBooks Online to calculate this value.
After we sync the PO to QuickBooks Online
synchronize purchase order to quickbooks online
The result will be corrected:
We got the same result like we followed the recommended workflow and packed the sales order first.


In some cases when doing Invoice before pack (eg when we don’t have enough stock), Cost of Goods Sold (COGS) may be incorrect.

It is advised that you pay more attention to such documents and consult your accountant.

2019. ERPAG Inc

Start NOW

Read More

Related Posts

JSON / XML Designer

JSON / XML Designer

JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...

read more
Change log 05/29/2023

Change log 05/29/2023

The biggest change we developed is Automatization and Customization. This change is a huge milestone for us, and we will publish individual instructions for using the new features in the upcoming period. This module is divided into individual wholes: JSON Designer -...

read more
#SLACK API – step by step integration instructions

#SLACK API – step by step integration instructions

ERPAG has the ability to use Blockly Script to send or receive data via the HTTP protocol. Integration of two systems via API (Application Programming Interface) is always a complex process, especially for someone with little experience. In this blog we will explain a...

read more