Reports - Unpaid invoices & Receivables Reconciliations reports not matching

I run the Receivables reconciliation with tax report and see there is a difference between the report & ledger amount totals. So I then run the Unpaid invoices report to try and find any payments that have been made against a customer, but before the invoice has been issued. But the unpaid invoices report doesn't show the amount unpaid at a specific date. It shows the current balance (as at today) of invoices dated on or before the set date. So I'm running a report as at 30 november 2023. The unpaid invoices report shows invoices dated 30/11/23 or prior, that are still unpaid as at today. Doesn't this defeat the purpose of have a report option to report figures as at a certain date? Bring back MYOB essentials as I didn't have this problem under that platform. Business edition is rubbish!!!