cancel
Showing results for 
Search instead for 
Did you mean: 
SLI
Level 2

Accounts Payable in Pay Bills Amt Due does not match Balance Sheet

I have QB 2019 Desktop for Mac. Why does the Amt. Due Total in Pay Bills not match my Vendor Aging Reports nor my Balance Sheet? The only way to get them to match is to select "All Dates" on the Vendor Aging and Balance Sheet.

Currently, all my Payables are past due - nothing in the future. I have paid 4 bills with future dates, however even if I account for these amounts, I cannot reconcile the balance sheet to Bills Due.

I want my Balance Sheet to accurately reflect what accounts payables are due as of today, but it does not. 

 

3 Comments 3
ShiellaGraceA
QuickBooks Team

Accounts Payable in Pay Bills Amt Due does not match Balance Sheet

Hi @SLI,

 

The total amount of the pay bills page is from your bills. The balance sheet and vendor aging reports include other transactions such as item receipts.

 

You can pull up the A/P Aging Detail report to check the item receipts. Let me walk you through how.

 

  1. Go to Reports, then Vendors & Payables.
  2. Select A/P Aging Detail.

With these steps, you'll be able to verify each transaction and reconcile. You can learn more about accounts payable at this link: Accounts Payable workflows in QuickBooks Desktop.

 

We also have a guide on income and expenses that I'm sure you'll find helpful.

 

Stay in touch if you have other questions about reports or bills, we're always here to help. Thanks for coming in, I wish you a wonderful rest of the day.

SLI
Level 2

Accounts Payable in Pay Bills Amt Due does not match Balance Sheet

Yes, I can manually reconcile the Accounts Payable from the Balance Sheet and the A/P Aging Detail with the "Pay Bills" Total Amt. Due, however these should all match. I have no receipts. The only "receipts" that you may be referring to would be a credit, however we do not have any open credits from our vendors. Our sales receipts are posted in the GL to our sales accounts.

We use the very simple process (as shown on the workflows link you provided) of entering a bill and paying a bill (which generates a check). 

"Accounts Payables" are bills that are due to creditors by definition. So the bills due on a certain date should be reflected in the total  Accounts Payable on the Balance Sheet as of that date. Otherwise the report is unreliable.

Having the User have to reconcile report totals defeats the purpose of having accounting software that produces trustworthy reports. 

While I appreciate your response, it does not directly address the real problem of Quickbooks producing a report with an Accounts Payable Total that does not accurately reflect the bills due at the time of the report.

JenoP
Moderator

Accounts Payable in Pay Bills Amt Due does not match Balance Sheet

Thanks for getting back to us with additional details, SLI.

 

We'd really want to sort this out for you.

 

Since you've mentioned that there aren't any item receipts or other transactions that might have affected your Balance Sheet and aging reports, our Technical Support Team will have to take a closer look at this. This is for them to determine what's causing the amount difference and provide steps that can resolve the issue.

 

Here's how to reach out to them: 

 

  1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Click QuickBooks Mac Desktop.
  3. Select Using QuickBooks for Mac.
  4. Scroll-down a little bit and click Start a Message.

As always, visit us again in the Community if you need anything else. 

Need to get in touch?

Contact us