I ran an unpaid/open invoice report before and after applying payments and the report generated after applying payments is an additional $900 lower than the applied payments. I am trying to identify where the discrepancy is coming from. Report details and steps below

I ran a report using the following details:

Product/Service Detail Report

Filter A/R Paid - Unpaid

All Dates.

I then applied payments and reran the report as above. I did not save the original report, so I can't compare the two and I'm not seeing a way to run a report as if I didn't apply the payments. Numbers were copy pasted into google sheets.

I verified using the audit log that payments applied matched the payments received.

As an example, let's say I have $10,000 in unpaid invoices on the original report, apply $5,000 in payments, and then rerun the report and get $4,100 in unpaid invoices.

Any help is appreciated!