Hello, did you get a resolution for this? I am having the same issue.
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
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,
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
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?
