cancel
Showing results for 
Search instead for 
Did you mean: 
GolfNut72
Level 4

Accounts payable reporting

I'm working with a client who is using QBDT Pro 2019.

He is a General Contractor and as he receives bills from his subs, he waits until he is ready to pay them before he enters them into QBDT.  He then pays then.  BUT, usually a few times a month, he will pay a sub or a materials vendor with a check (no bill, yet).  Sometimes it's a downpayment for materials but usually, it's to pay a sub who wants his payment immediately (and sometimes never sends a bill). 

 

This causes his Accounts Payable to be out of balance because when he enters the check manually, he codes it to A/P instead of an expense account.

 

How would I run a report that would show details of A/P so I can determine where I need to make corrections or adjustments for the checks he has written... and is there a better way, where I can train him to enter the handwritten checks. 

 

Thank you

 

EJ

 

 

1 Comment 1
MichelleBh
Moderator

Accounts payable reporting

Hello, @GolfNut72.

 

I appreciate you for providing detailed scenarios of your concerns. I'm here to help you run a report in QuickBooks Desktop. So, you're able to determine where you need to make corrections or adjustments. 

 

You can run the A/P Aging Summary Report by going to the Report menu. Then, manually review the data if there is an A/P that has not been applied yet. 

 

Here's how: 

 

  1. Go to the Reports tab on the upper right side. 
  2. Choose Vendors & Payables, then click A/P Aging Summary

       3. Set the correct date range. 

       4. Hit Customize report and select the exact vendor's name. 

 

If there are transactions that have not been applied yet, I'd suggest going to the Bill page and apply for the credit on it. For more details, check out this article: Pay bills in QuickBooks Desktop.

 

If you didn't see any bills, I'd advise you to create a new bill by going to the Vendors menu, then hit Pay Bills. That way, you can apply the A/P and allocate the expense account. 

 

Additionally, you can let your contractor join our QuickBooks Training Webinars. We have various videos and an expert to discuss a lot of topics in handling checks or other topics in QuickBooks. You may refer to this link: https://quickbooks.intuit.com/au/learning-centre/webinars/

 

I've also added some pages about maintaining checks and other topics.

 

 

Let me know if you have other questions or other concerns. I'm always here to help. Keep safe!

Need to get in touch?

Contact us