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 ConnectWise PSA 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 ConnectWise PSA 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 PSA. If there is a Vendor Invoice Number on the item receipt in ConnectWise PSA it will be used as Document No. in QuickBooks Online (see Bill #1337 above). If there is no Vendor Invoice Number on the ConnectWise PSA 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 that 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 PSA 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 ConnectWise PSA Item Types as follows, and will apply the following transactions:

  1. ConnectWise PSA Inventory > QuickBooks Online Product with Track Inventory on Hand enabled (Only available in Mobius Standard)

    • Purchase (Item Receipt)

      • Accounts Payable     Credit

      • Inventory         Debit

    • Sale (AR Invoice)

      • *Inventory         Credit

      • *COGS             Debit

      • Revenue         Credit

      • Accounts Receivable     Debit

  2. ConnectWise PSA 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.