Sign in

QuickBooks Desktop Sync Error: The Account for the transaction must be of type Bank

Avatar
Zendesk API
Follow

OVERVIEW

When paying bills in QuickBooks Desktop, only a "Bank" account type can be used.

A sync error will appear when the General Ledger account associated with the payment in Bill.com is not a Bank Type account.

SYNC ERROR

There is an invalid reference to QuickBooks Check Account "XXXXXXXX-XXXXXXXXX" in the BillPaymentCheck. QuickBooks error message: The account for this transaction must be of type Bank.

SOLUTION

Update Bill.com Money Out Clearing Account

Note: the Bill.com Money Out Clearing account allows payment reconciliation and is required for Bill.com sync entries to function properly in QuickBooks.

For Bill.com Payments, the Payment Account is listed in the Bill.com Money Out Clearing Account field. Update as follows:

  1. Hover over the gear icon, then click Settings 
  2. Under the Sync section, click Preferences and then Click Edit
  3. Select the Bill.com Money Out Clearing account that is automatically created
  4. Click Save and run a Sync

Change the account

If the Money Out Clearing Account is already selected in the Sync Preferences, then the type of account may have changed. Update the setting as follows:

  1. Hover over the gear icon, then click Settings 
  2. Click on Chart of Accounts and the Edit icon
  3. Select "Bank" in the Type field
  4. Save the change and run another Sync

NOTE

For Offline Payments, the Payment Account can be changed to a Bank 'type' account on the Bill Payment Information screen by clicking the edit icon.

If the Sync Errors remain, please contact Bill.com Customer Support.