Balance sheet does not match A/P aging

In BQE CORE, the Balance Sheet and Trial Balance (Accrual or Cash) do not match with the A/P Aging with Credits report after making journal entries.

To troubleshoot this discrepancy, please verify your A/P Aging with Credits report against the Accounts Payable register balance. If they match, then verify the journal type used when making the journal entries.

CORE gives you the ability to create journal entries using any of these entry types: Accrual, Cash or Accrual & Cash. All of these entries show up on the A/P Aging with Credits report. However, if you create journal entries using only Cash basis of accounting, they will not show up in the Balance Sheet and Trial Balance (Accrual) reports. Similarly, when creating journal entries using Accrual basis of accounting, they will not show up on the Balance Sheet and Trial Balance (Cash) reports. Currently, CORE does not allow you to post cash-based journal entries against the A/P accounts. Such cash-based entries can be posted to Bank or Credit Card type of accounts only.

Here are the most effective ways to work around these limitations:

  • Use only the Accrual & Cash journal entry type on all General Journal transactions. Then your A/P Aging with Credits report will balance with either of the Balance Sheet reports (Cash or Accrual).
  • You can also continue to match the A/P Aging with Credits report with the A/P register balance.