Pay Bills Total does not Match Accounts Payable

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! 

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.

Hi,

This is still doesn't help.

In my case, the Supplier is already fully paid thus it is not in the AP Aging anymore but in the Balance sheet 0.02 is the difference and is increasing every month.

Hello @Heide1,

I'm glad to see you dropping by here in the Community. I'd be more than happy to help you figure out why the amount is increasing in the Balance Sheet report.

The AP account in the Balance Sheet report includes all transactions related to all of your suppliers. Your supplier may be fully paid, but there may be other payables from other vendors.

I recommend running the report and clicking the amount to determine the cause of the issue. The process allows you to view the related transactions and the affected suppliers.

Here's how:

1. Click the Reports tab at the top menu bar.
2. Open the Balance Sheet report.
3. Find the account that's increasing every month.
4. Click the amount to expand the details.

Your total assets should match your total liabilities on the report. If your balance sheet gets out of balance on an accrual basis, you should rebuild your company file. For more details, I've attached this article I find helpful for you: Fix a Balance Sheet that's out of balance.

Keep me posted for any assistance you need regarding running financial reports in QuickBooks. We'll keep an eye on this thread. Have a great day.

Hi,

I actually checked one by one all the transactions for the month of all the suppliers and I've noticed one supplier that in A/P aging it is already closed or fully paid but in the transactions for the month under AP in the balance sheet it has a balance.

And by the way, it is in the QB Online.

Hey there, @Heide1. 

Thanks for taking the time to follow up with us and letting us know you're using QuickBooks Online. 

I recommend contacting our QuickBooks Online Support team for this one. This way, one of our specialist can use their tools to review your account in a secure environment and take a look at the report to investigate it further. Once they investigate the report, they can let you know why you're seeing the amount on your Balance Sheet. 

Here's how to connect with an agent directly: 

• QuickBooks Online Support

Please let me know if you have any questions or concerns. Take care! 

Set the right Date - What is the right date?  Don't know what you mean.

1. Click the Customize Report button, Advanced, then As of Report Dat
2. There isn't an advanced nor As of Report Date.  I have All Dates set right now.  I'm using QBO
3. The old transactions I'm looking at go all the way back to 2009.  They show on the AP aging report but not in Pay Bills.

Sounds to me like a rounding problem of taxes (percentages). I'd just write it off.

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.