When you create a Purchase Order on TradeGecko 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 TradeGecko will increase the Stock On Hand and decrease the Purchases account.
- Purchase Orders created on TradeGecko 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 TradeGecko, 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 |
|
TradeGecko 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 |
Price will sync in the line item as 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 TradeGecko and Quickbooks by reading this article.