cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Stacie13
Level 1

Accounts Payable aging report that shows partial payment amounts

In QuickBooks desktop, I would like an Accounts Payable report that shows, for each vendor:

 

Bill Date

Reference Number

Due Date

Amount (original amount of the invoice)

Amount Paid (amount of partial payments made on each invoice)

Open Balance (difference between 2 amounts above)

 

This is for an accounting client who enters large bills to vendors, then pays them down periodically in partial payments. 

 

I have attempted to create this by customizing the Unpaid Bills Detail report by adding the needed columns, but the "Amount Paid" column always shows $0, even though there have been payments on these bills.  

 

Any help is appreciated. Screenshot of my failed report attached.

 

1 Comment 1
ChristineJoieR
QuickBooks Team

Accounts Payable aging report that shows partial payment amounts

Good day, @Stacie13.

 

I appreciate your effort in running the reports in QuickBooks Desktop. I'll jump in this thread to give some light on how to show partial payments.

 

An unpaid bills report is a list of all outstanding bills. The report contains information such as the vendor's name and phone number, the amount, the due date, the number of days past due, and open balances. This report can help you quickly identify bills that are past due. However, we're unable to see the partial payments in this report.

 

The thing we can do is find a different report that displays the remaining vendor balances. Let's try to run Vendor Balance Details. This report shows you what transactions make up your current balance with each vendor.

 

Here's how:

 

  1. Open the Reports menu, then click on Vendors & Payables.
  2. Select Vendor Balance Detail report.
  3. Click on Customize Report.
  4. From the Display tab and choose Balance under Column.
  5. Once done, click on OK.

 

Furthermore, I recommend sending feedback to our product developers about creating reports for partial payments.

 

Follow the steps below:

 

  1. Select Help from the menu.
  2. Choose Send Feedback Online.
  3. Click the Product Suggestion.
  4. Fill up the following details and hit Submit button.

 

Feel free to read these guides about handling reports in QBDT: 

 

 

I want to ensure everything is taken care of for you, so please let me know if you have any other issues or concerns. I'm always here to help. 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up