Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
September 5, 2026
Question

CUSTOM report vendor transactions

  • September 5, 2026
  • 1 reply
  • 11 views

I want to create a report for one vendor that shows all the sources for payment of a bill regardless of how many sources there are and if a bill payment includes partial payments for each bill.

1 reply

QuickBooks Team
September 5, 2026

You can generate the Bills and Applied Payments report to show all bill payments, their sources, and partial payments for a specific vendor.

 

Here's how to set it up:

 

  1. Go to the Reports menu.
  2. Select Standard reports and search for Bills and Applied Payments.
  3. Ensure the Report period is set to the correct date range.
  4. Click Customize in the top right corner.
  5. Filter by Vendor name, set a Condition, check the box for Vendor, and select your vendor from the list.
  6. In the Columns section, make sure the Amount, Account full name (shows the bank account or credit card used to make the payment), and Open Balance (shows any remaining amount still owed on each bill) boxes are checked.
  7. If you can't see a certain column, click More Columns to add it to the report.
  8. Then, Apply changes.

 

 

If a bill was paid in instalments or from more than one account, each payment will appear as its own separate line tied back to the original bill. This way, you'll have a full breakdown of every payment source, no matter how many there are.

 

Once you're happy with the layout, click Save As and give the report a name so you can access it anytime without having to rebuild it. It will be saved under Custom Reports.

 

 

Let me know if you have any questions.