QuickBooks Commerce’s QuickBooks integration allows you to split your sales invoices across multiple sales ledgers. You can choose to send sales invoices to a ledger based on the SKUs on the invoice (this splits the invoice by line item). Refer to this article on How to Assign Default Sales Account by Variant.
Here's how Sales Invoice work with us:
- Invoicing a Sales Order will debit Accounts Receivable, credit Revenue.
- Shipping a Sales Order will increase Cost of Goods Sold, decrease Stock On Hand account.
Note
Invoices created on QuickBooks Commerce before the integration with QuickBooks was set up cannot be synced over to QuickBooks. To sync your historical invoices, contact us today.
The table below shows how elements of a Sales Invoice sync over to a QuickBooks Bill.
| Elements in Sales invoice | Corresponding Response on QBO | QBO Invoice field | One-way sync or two-way sync? | Sync frequency |
| QuickBooks Commerce Invoice Number | Syncs as an Invoice number | Invoice number | One-way sync | Immediate |
| Bill to address | Syncs as Customer's Billing address | Billing address | One-way sync | Immediate |
| Ship to address | Syncs as Customer's Shipping address | Shipping address | One-way sync | Immediate |
| Ship from | Doesn't sync to QBO | NA | NA | NA |
| Customer email | Syncs as customer email | Customer email | One-way sync | Immediate |
| Terms | Doesn't sync to QBO | NA | NA | NA |
| Issued date | Syncs as Invoice date | Invoice Date | One-way sync | Immediate |
| Payment Due date | Syncs as Due date | Due Date | One-way sync | Immediate |
| Invoice currency |
Syncs as Invoice Currency
|
Currency code | One-way sync | Immediate |
| Exchange Rate | Syncs as currency rate in QBO non-USA. | Currency rate | One-way sync | Immediate |
| Line item Variant SKU | The variant SKU itself will sync as a service item in QBO | Line items | One-way sync | Immediate |
| Line item Variant description | The variant SKU itself will sync as a service item description in QBO | Description | One-way sync | Immediate |
| Line item Price | The price will sync in the line item as a non-discounted price | Line Item | One-way sync | Immediate |
| Line item Quantity | Quantity will sync in the line item as quantity | Line Item | One-way sync | Immediate |
| Line item Discount | QBO doesn't have line-item discounts, but there is a discount for the Invoice as a whole. All line items discount will be summed up and added as a total discount for the whole invoice. | Line Item | One-way sync | Immediate |
| Line items Tax |
QuickBooks Commerce sends line items as Exclusive, Inclusive, or No Tax Invoice to QuickBooks.
|
Line Item Sales Tax | One-way sync | Immediate |
| Message to customer | Syncs to 'Message on Invoice' field in QBO | Message on invoice |
One-way sync | Immediate |
For credit notes, understand the sync details between QuickBooks Commerce and Quickbooks Online by reading this article.