cancel
Showing results for 
Search instead for 
Did you mean: 
shlomo
Level 2
 
Solved
Best answer January 04, 2021

Best Answers
shlomo
Level 2

Hi Everyone,

So i worked out the answer:

 

If you run the A/P Aging Summary, on the top left of the screen, there is an option called "Aging method" with an option to choose "Current" or "report date".

If you choose 'current', the report will show you only bills that are actually payable in the system - the report  wont include any bills that you have paid with post dated/ future dated cheques.

 

However, if you choose "report date" the report will show you all bills that you owe including bills that you have paid BUT with post dated FUTURE dated cheques. This way, if a company needs to see what they actually owe right now, including bills that have been paid with post dated future dated cheques (as those are not really considered paid yet), he can select the 'report date' option.

 

thanks everyone for your help.

View solution in original post

8 Comments
MaryAnn_E
QuickBooks Team

 

Hi there, @shlomo.

 

The Accounts Payable Aging Report provides a list of your bills separated by the number of days the bills are overdue. This is a useful report to make sure you don’t miss a vendor payment. Also useful when you are low on cash and must focus on which bills get paid.

 

There are two available Accounts Payable reports in QBO, Detail or Summary. Choose either of the two, then customize the date to get the data you need.

 

Here’s how:

  1. Go to Reports from the left menu.
  2.  Enter Accounts Payable on the search box and choose from the suggested reports.
  3.  Once the report opens, select Custom on the Report period drop-down.
  4.  Then, enter the date on the as of field.
  5. Click Run report.

 

You can check out this article for additional information: Run Reports.

 

That should get you the information you’re looking for. Please touch base with me here if you have any questions or clarifications. I’ll be here to help you out. Take care always!

 

shlomo
Level 2

Hi

thanks for your help. However, this is not what im looking for.

I know how to run the A/P reports.

However, my question is, does the A/P report includes the payable which you have paid with post dated cheques, or once you've paid them, even with a post dated cheque, its removed from the report.

 

In otherwords, if someone wants to know how much they owe, do they have to run 2 reports, the A/P report and an post dated cheque report. For example, if i owe 20K to a vendor and i printed them a cheque for the full amount but dated it for 2 months time, does that 20K of payables still appear in the A/P report or will it be excluded from the report.

 

thanks

MaryJoyD
QuickBooks Team

It's our pleasure to help, @shlomo.

 

Thank you for providing us with more information about this. It really helps in identifying the concern that you're having. 

 

You can generate Accounts Payable Aging Summary report to know the total amount of your unpaid bills, grouped by days past due. Then, have the Bills Payments List report to know the bills you’ve paid.

 

That being said, as long as it affects your Accounts Payable account, that'll show in your Accounts Payable reports. 

 

You can check this article for more information on how to run reports and to customize reports in QuickBooks Online.

 

See this memorize reports in QuickBooks Online article to show you how to save it with its current customization settings. 

 

Let me know if you have any other questions with your reports. I'm always here to answer them for you. Take care and have a wonderful day!

shlomo
Level 2

thanks- i dont think this is the solution to my question.

Furthermore, to make things further complicated, i have checked a couple of my online accounts and each account seems to handle post dated payments differently in regards to the Accounts payable report.

 

One account doesnt include bills in the accounts payable report, even if you've paid them with post dated cheques. the other account keeps the bills in the accounts payable report if you've paid the bills with post dated payments.

So maybe its a setting in the settings.......

Mary, how do we get some more people to join this thread and help us solve this please??

 

thanks

MirriamM
Moderator

Hello again, @shlomo. Thanks for keeping us updated and providing detailed information about your concern. 

 

When running the Accounts Payable Aging Detail and Accounts Payable Aging Summary report, it'll show all your unpaid bills. Thus, if on the period range set on the report, you still have a balance on the Bill. Then, the bill will show. But if you set the period range to the date after the post-dated check, then the system will recognize the payment in which the bill will no longer show on the report. 

 

You can check out this article for additional information: Run Reports.

 

You may also wish to run your Accounts Payable register to show all the related transactions under this account. To run, here's how:

  1. In the left menu, click Accounting.
  2. Go to the Chart of Accounts tab. 
  3. In the search field, type in Accounts Payable.
  4. Under ACTION column, hit View register link.

Touch base with me here if you have any questions or clarifications. I’ll be here to help you out. Take care and have a great day!

SteveChase
Community Champion

Another report to consider is running the "unpaid bills" report. This will show all unpaid bills even if the date today has a post dated future bill payment.

shlomo
Level 2

Hi Everyone,

So i worked out the answer:

 

If you run the A/P Aging Summary, on the top left of the screen, there is an option called "Aging method" with an option to choose "Current" or "report date".

If you choose 'current', the report will show you only bills that are actually payable in the system - the report  wont include any bills that you have paid with post dated/ future dated cheques.

 

However, if you choose "report date" the report will show you all bills that you owe including bills that you have paid BUT with post dated FUTURE dated cheques. This way, if a company needs to see what they actually owe right now, including bills that have been paid with post dated future dated cheques (as those are not really considered paid yet), he can select the 'report date' option.

 

thanks everyone for your help.

View solution in original post

SteveChase
Community Champion
Very good work. Thanks
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us