Hello

Recently I have notice the bills owing amount is not matching the bills owing amount in the reports for example

As you can see the difference is massive! Does anyone know how is this fixed?

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

Hi ,

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.

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.

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?

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 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.

Hi , 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 I understand that, that was not my initial query though.

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

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.