QuickBooks Commerce pushes and manages the integration of your inventory, purchasing, and stock control with your QuickBooks Online (QBO) accounting software. Hence, QuickBooks Commerce pushes purchase invoices, sales invoices payments, and relevant contact information to QuickBooks, allowing you to manage your debtors and creditors on QuickBooks.
Stock Transactions such as Stock on Hand (SOH), Cost of Goods Sold (COGS), and Purchases sync once a day at 12 AM GMT. All other transactions sync/push immediately.
How QuickBooks Commerce and QuickBooks Online work together
The following table lists the details of transactions that are synced/pushed from QuickBooks Commerce to QuickBooks.
|
Transactions in QuickBooks Commerce |
Corresponding Transaction Response on QBO |
QBO Account |
Sync Frequency |
|
New Sales Invoice |
Creates an Invoice
|
Sales |
Immediate |
|
Update Sales Invoice |
Updates invoice |
Sales |
Immediate |
|
Delete Sales Invoice |
Deletes invoice |
Sales |
Immediate |
|
New Payment on Invoice |
Creates a new payment |
Payment |
Immediate |
|
Delete Payment on Invoice |
Deletes an existing payment |
Payment |
Immediate |
|
Sales Return |
Creates a new credit memo |
Sales |
Immediate |
|
Update Sales Return |
Updates an existing credit memo |
Sales |
Immediate |
|
Delete Sales Return |
Deletes an existing credit memo |
Sales |
Immediate |
|
New Purchase Order |
Creates a Bill on Quickbooks
|
Purchases |
Immediate |
|
Update Purchase Order |
Updates an existing bill |
Purchases |
Immediate |
|
Delete Purchase Order |
Deletes an existing bill |
Purchases |
Immediate |
|
Receiving a Purchase Order |
Creates a stock journal with a +SOH and -Purchases transaction |
+ Stock on hand - Purchases |
Daily at 12 AM GMT |
|
Shipping a Sales Order |
Creates a stock journal with a +COGS and -SOH transaction |
+ Cost of goods sold - Stock on hand |
Daily at 12 AM GMT |
|
Receiving a Sales Return |
Creates a stock journal with a +SOH and -COGS transaction |
+ Stock on hand - Cost of goods sold |
Daily at 12 AM GMT |
|
Creating a Stock Adjustment |
Creates a stock journal with a +/- Inventory Adjustment Ledger Account and corresponding +/- SOH transaction |
+/- Inventory Adjustment Ledger Account -/+ Stock on hand |
Daily at 12 AM GMT |
Inventory transactions for the day are consolidated and pushed into a single stock journal by default at 12 AM GMT. If you want to change it at a different time than 12 AM GMT, then you can set up different timings.
QuickBooks Commerce pulls all Tax Types from QuickBooks, and these can be matched with the correct QuickBooks Commerce Tax Types.
If you have created draft Purchase Orders, they will not sync to QBO, until the order has been marked as 'received'.