Skip to main content
S
shlomo
December 17, 2020
Solved

Does the accounts payable report include bills that you've already paid BUT whose payments are post dated for a future date? (So you haven't really paid them yet)

  • December 17, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by shlomo

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.


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.

1 reply

M
MaryAnn_E
December 17, 2020

 

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!

 

S
shlomoAuthor
December 20, 2020

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

MJoy_D
MJoy_D
December 20, 2020

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!

Terms & ConditionsAccessibility statement