When you create a Purchase Order on QuickBooks Commerce a Bill will be created on QuickBooks. All line items on the Purchase Order will push on the same Bill (including the landed costs i.e. freight, duty, shipping, etc).
Receiving a Purchase Order on QuickBooks Commerce will increase the Stock On Hand and decrease the Purchases account.
- Purchase Orders created on QuickBooks Commerce before the integration with QuickBooks was set up cannot be synced over to QuickBooks. To sync your historical purchase orders, please contact us.
- If you would like to sync the bill to QuickBooks only once the Purchase Order has been received on QuickBooks Commerce, please contact us.
To separate landed costs from the bill, you need to split the bill into multiple bills by following these steps:
- Log into your QuickBooks account.
- Duplicate the bill on QuickBooks, and remove all line items except for the landed cost. Choose the correct vendor for the landed cost.
- Go to the original bill, remove the landed cost line items, and save.
- You will now have 2 bills, one with the stock items addressed to the supplier, and another with the landed cost addressed to the correct vendor.
The table below shows how elements of a Purchase Order sync over to QuickBooks. Purchase orders will only sync after the PO is marked as ‘received’.
|
Elements in PO |
Corresponding response on QBO |
QBO Bill |
|
QuickBooks Commerce PO number |
Syncs as is |
Bill number |
|
Create date of PO |
Syncs as is |
Bill date |
|
Stock due date |
Syncs as is |
Due date |
|
Reference |
Does not sync to QBO |
- |
|
PO currency |
Syncs as is* |
Currency code |
|
Exchange rate |
Syncs as currency rate in QBO* |
Currency rate |
|
Line item variant SKU |
Variant SKU will sync as a service item |
Line items |
|
Line items totals/tax |
Line items are sent as Exclusive, Inclusive, or No tax invoice to QBO** |
Line items |
|
Line item price |
The price will sync in the line item as the price |
Line items |
|
Line item quantity |
Quantity will sync in the line item as quantity |
Line items |
|
Message to customer |
Does not sync to QBO |
- |
*For QuickBooks USA, everything will be sent in USD as Quickbooks USA does not support multi-currency by default
**For QuickBooks USA, line items totals will always be sent as tax exclusive
For sales invoices, understand the sync details between QuickBooks Commerce and Quickbooks by reading this article.