Vendor balance detail report

Your report looks normal. The Balance detail report shows all transactions for each vendor, whether paid or not, adding up to their ending balance.

However, you can use it to look for unapplied/unpaid transactions in two ways:

1. Add the Open Balance column. It will be empty for transactions that are fully applied/paid. Looks for Bill Payments that have an open balance, which is unusual and usually something to fix. Fix the open balance by editing the Bill Payments and applying them to open bills, which will display in their voucher areas.

2. Filter the report for only open transactions. Add the Paid Status filter and set it to "Open". Once you do, everything that remains should have an amount in the Open Balance column added in #1 above.

I need to know how to apply the bill-pmt-check to the bill. The vendor accounts are zero , I am just trying to clean up the report.

Hi there, @Troop457.

I agree with @BigRedConsulting, everything looks good on your report. There's no need for you to apply any bill payment checks to a bill since the report already shows zero balance.

On the other hand, if you like, you have the option to use the report to review unapplied or unpaid transactions. There are two ways to do that.

By adding the Open Balance column:

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, select Balance under Column.
5. Once done, click on OK.

After that, you can check for transactions that are reflected in error. If there's any, you can click on it to open the balance and make changes from there.

By filtering the report to only show open transactions:

1. Open the Reports menu then click on Vendors & Payables.
2. Select Vendor Balance Detail report.
3. Click on Customize Report.
4. From the Filters tab, select Paid Status under Filter drop-down.
5. Click on the Open radio button.
6. Then click on OK once done.

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

• Customize reports in QuickBooks Desktop
• Understand reports

We're here to back you up if you need additional help with reports or QuickBooks. Just reply to this thread. Have a great week!

---

@Troop457 wrote:

I need to know how to apply the bill-pmt-check to the bill. The vendor accounts are zero , I am just trying to clean up the report.

---

From my last post:

" Fix the open balance by editing the Bill Payments and applying them to open bills, which will display in their voucher areas."