Let's see how we can customise the report you mentioned, anel.
When you pull up the Supplier Balance Detail report, the A/P Paid is filtered to Unpaid by default. I understand why you can see zero balance after selecting All in the A/P Paid. The transactions with zero balances are the following:
- bills that were paid in full.
- bill payments that were applied to the bills.
- vendor credits that were applied as bill payments.
If the transactions still have amounts in the BALANCE column, these means that they are still open or not settled yet.
Aside from this report, we can also customise the Transaction List by Supplier report to get the data you need. Here's how to do it:
- Click Reports on the left menu and search Transaction List by Supplier.
- Click the Customise button and set the correct Report period under the General section.
- Go to the Rows/Columns section and click Change columns.
- Mark the following column headers:
• A/P Paid
• Open Balance
- Go to the Filter section and set the necessary filters to get the data.
- Click Run report.
This report will show you the paid bills and the applied payments/credits. Note that the AMOUNT column indicates the full amount of the transaction, while the OPEN BALANCE column will the unsettled difference of the said transactions.
You might also find these links helpful when customising reports in QuickBooks Online:
Keep us posted if you need additional assistance in customizing the report. We'll be right here to get the data you need. Have a great day!
