How do I check that my batch went into QuickBooks Online?

Validating a Batch

Invoices

To verify invoices in QuickBooks Online, navigate to Home > Transactions > Sales.

Expenses


To verify expenses in QuickBooks Online, navigate to Home > Transactions > Expenses.

With Transfer as Bill Enabled

With the “Transfer as Bill” option enabled in the Manage Accounting Package Configuration, an expense will be created in QuickBooks Online as an expense with the type set to “Bill”.

With Transfer as Bill Disabled

With the “Transfer as Bill” option disabled in the Manage Accounting Package Configuration, an expense will be created in QuickBooks Online as an expense with the type set to “Expense”.

Item Receipts

To verify item receipts in QuickBooks Online, navigate to Home > Transactions > Expenses. Please note that Item Receipts are created in QuickBooks Online as an expense with the type set to “Bill”. In other words, Expenses (with Transfer as Bill enabled) and Item Receipts are side by side in Expense Transactions as Type “Bill”. 

Please Note that existing Item Receipts are validated using the Vendor Invoice Number coming out of ConnectWise. If there is a Vendor Invoice Number on the item receipt in ConnectWise it will be used as the Document No. in QuickBooks Online (see Bill #1337 above). If there is no Vendor Invoice Number on the ConnectWise item receipt, no Document No. will be applied in QuickBooks Online. The Mobius Connect integration will not transfer item receipts if the Vendor Invoice Number has already been used in QuickBooks Online. If your item receipt has partially received items which are closed and batched, it's possible the remaining items will fail to transfer when received and closed if a Vendor Invoice Number is used on the ConnectWise item receipt. To prevent this type of validation failure it is recommended to batch item receipts only after all the items have been received. If the item receipt does not use a Vendor Invoice Number, each batch of separately received items will transfer onto a separate QuickBooks Online transaction Bill.

GL Entries

These product types are mapped to Manage Item Types as follows, and will apply the following transactions:

  1. Manage Inventory > QuickBooks Online Product with Track Inventory on Hand enabled (Only available in Standard and Plus)

    • Purchase (Item Receipt)

      • Accounts Payable     Credit

      • Inventory         Debit

    • Sale (AR Invoice)

      • *Inventory         Credit

      • *COGS             Debit

      • Revenue         Credit

      • Accounts Receivable     Debit

  2. Manage Non-Inventory, Service, Other Charge (or NULL/Unknown) > QuickBooks Online Product with Track Inventory on Hand disabled

    • Purchase (Item Receipt)

      • Accounts Payable     Credit

      • COGS             Debit

    • Sale (AR Invoice)

      • Revenue         Credit

      • Accounts Receivable      Debit

*This transaction is handled by the accounting package directly, not the integration. 



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.