Skip to main content
July 2, 2024
Question

Accounts Payable GL balance does not tie-up with Subsidiary ledger per vendor.

  • July 2, 2024
  • 1 reply
  • 0 views

Hello Guys, need your help on how to solve the discrepancy between GL balance of Accounts payable versus SL balance per vendor. There is a minimal difference around USD 300 which I cannot tie-up.

 

Thanks!

1 reply

July 3, 2024

You can export both accounts to see the difference, Ronnel. Let me guide you on how to achieve this.

 

Here's how:

 

  1. From the left pane go to Transactions and choose Chart of accounts.
  2. Find the Accounts Receivable.
  3. Once you find it, click the dropdown beside View register and select Run report.
  4. Then click Switch to classic view.
  5. Go to the Report period and modify it as All Dates.
  6. Once done, click Export beside Print icon and then select either Export to Excel or Export to PDF.
  7. Follow the same process as for the Subsidiary Ledger.

 

From there, manually compare each transaction to determine the root cause of the discrepancy. After you find the transaction that caused the discrepancy, you can delete or add it to resolve the difference.

 

Furthermore, you can check out this article if you want to personalize and add specific info to your sales forms: Customize invoices, estimates, and sales receipts in QBO.

 

If you have any further questions about the chart of accounts, feel free to reply below. We're here to assist you 24/7.