Open Bills total not matching Unpaid bills report figure for same time period

Hi KellyWSM , yes indeed it does (display bills that are - today - paid and unpaid), but every bill in the report on it was UNpaid as at the date selected for the report, typically a prior date.

In V19, the bills that had since been paid were handily grouped at the end of each supplier section, which made it easier to focus on what still needed paying.

Thank you I understand that, that was not my initial query though.

Also the 'Payables reconciliation with tax report' displays paid and unpaid bills for me.

Hi KellyWSM , the Payables Reconciliation with tax report shows (at any previous date) all the bills that were unpaid at that date. 

The Unpaid bills report shows the current balance of all invoices up to x date (that are still unpaid). These are two entirely different reports.

What's missing from the Payables Reconciliation with tax is the aging in the summary/collapsed view. You only get aging in the expanded view. After being used to AccountRight desktop, this seems a fairly reasonable request.

Thank you for the reply. I understand what the 'Payables reconciliation with tax report' and 'Unpaid Bills' reports displays, but was wondering why I was advised to compare these reports by Princess if they display bills of different statuses.

When comparing the total of my list of Open Bills from 1/11/24 to 30/11/24, I found this did not match the total for the 'Unpaid bills' report as of 30/11/24. I had checked the date range for the last financial year and there were zero open bills prior to 1/11/24, and there were no outstanding debits to apply. The original poster of this thread seems to have had the same issue without a resolution. I also found a large discrepancy between these totals, of approx $120k in my case. For each supplier listed in the 'Unpaid bills' report, I checked their total of open bills individually, and found the individual total for each supplier in open bills matched the individual total displayed in the 'Unpaid bills' report. But the total for all suppliers in Open Bills did not match the 'Unpaid bills' report. Why would this be?

Hi KellyWSM,

The 'Payables reconciliation with tax report' includes both paid and unpaid bills, which is why it shows paid bills as well. This report is designed to provide a comprehensive view of all payables, including those that have been settled.

On the other hand, the 'Unpaid bills report' specifically lists only the bills that are still outstanding and have not been paid. This is why there is a discrepancy between the two reports.

To address the issue of open bills not matching the unpaid bills report, you need to ensure that the date filters for both reports are set to the same period. Sometimes, mismatched date ranges can cause discrepancies in this issue.

I hope this helps!

Regards,
Earl

The 'Payables reconciliation with tax report' shows paid bills also, how would this match to the 'Unpaid bills report'?

This also doesn't answer the original query of Open Bills not matching the Unpaid Bills Report.

Hi KellyWSM,

To match the "Unpaid Bills Report," you can compare it with the "Payables Reconciliation with Tax Report." This report helps in reconciling the unpaid bills with what is recorded in the system. If there are discrepancies, you might need to check for issues such as date filters, duplicate entries, or unmatched transactions.

Cheers,

Princess

Hello, did you get a resolution for this? I am having the same issue.

Hi OGS,

Thank you for your post and I understand that the open bills doesn't match with the unpaid bills. To ensure accuracy, you should compare the balances on your balance sheet's payables/receivables accounts to your respective payables/receivables reconciliation with tax reports balance. When these are run on the same date and use the same accounting method, they should align by then.

Feel free to write a post if you need further assistance.

Cheers,

Jem