Skip to main content
mikeshick
Oct 28, 2021 6:27 PM UTC
Solved

Pay Bills Total does not Match Accounts Payable

For some reason, our accounts payable and pay bills totals are off by $0.08.  We cannot figure out what is causing the discrepancy.  

 

We ran a detail report of Accounts Payable, and all the transactions are bills, bill-payments, credits, credit card charges, and one deposit.

Can you help.

 

 

AlexV
AlexVAnswer
Oct 29, 2021 12:49 AM UTC

Good day, mikeshick!

 

Thanks for reaching out back to us. Let me join this post so I can help you with the accounts payable.

 

You'll want to pull up the Unpaid Bills report and compare it to the Accounts Payable account. From there, you can identify what's causing the discrepancy. 

  1. Go to the Reports menu. From the Vendors & Payables, select Unpaid Bills Detail.
  2. Set the right Date.
  3. Click the Customize Report button, Advanced, then As of Report Date.

 

I also added some articles you can check. These will explain how to fix AR or AP issues:

 

Comment again here if you have other concerns. Take care!

View in thread

11 replies

Candice C
Candice C
Oct 28, 2021 8:29 PM UTC

Good evening, @mikeshick. 

 

It's great to see you back in the Community. I hope your day is going well so far. 

 

For security reasons, I'm unable to review your account on my end. However, our Customer Support Team can use a screen share tool to look over your account and help you resolve this discrepancy. Here's how: 

 

  1. Go to the Help menu.
  2. Press QuickBooks Desktop Help.
  3. Click the Contact Us button. 
  4. Give a brief description and tap Let's talk. 
  5. Scroll down and choose to Get a callback. 

 

Please inform me on how it goes. It's my priority that you're able to get back to running your business. Take care! 

mikeshickAuthor
Oct 28, 2021 10:16 PM UTC

Tried to do this, but was asked to pay for help.  This wasn't what I was looking for.  Still waiting for help.  Thank you.

AlexV
AlexVAnswer
Oct 29, 2021 12:49 AM UTC

Good day, mikeshick!

 

Thanks for reaching out back to us. Let me join this post so I can help you with the accounts payable.

 

You'll want to pull up the Unpaid Bills report and compare it to the Accounts Payable account. From there, you can identify what's causing the discrepancy. 

  1. Go to the Reports menu. From the Vendors & Payables, select Unpaid Bills Detail.
  2. Set the right Date.
  3. Click the Customize Report button, Advanced, then As of Report Date.

 

I also added some articles you can check. These will explain how to fix AR or AP issues:

 

Comment again here if you have other concerns. Take care!

    Cari4
    Jan 3, 2023 10:24 PM UTC

    I had the same problem, then realized what the difference is when using QBO versus QBDT.  QBO only pulls up Vendor Bills for the last 365 days.  You have to change that filter to "All" (top left of the screen) to see ALL outstanding bills and credits.  Once I did that, I was able to attach the offsetting credit/journal entry.  I hope this helps.

    Terms & ConditionsAccessibility statement