Modified Date not matching Payment Date in reports after payment made

We are using QuickBooks reports to export invoice and bill data. We observed that the “Modified On” field in the exported report does not match the actual payment date.

For example:

• Payment is made on a specific date (visible correctly in invoice details)

• But the same time after payment, “Modified On” field shows an earlier date and time

We would like to understand:

1. What exactly does the “Modified On” field represent in reports?

2. Does it update when a payment is applied to an invoice or bill?

3. Is there any report that provides Payment Date along with Invoice/Bill Number in a single export?

This is important for us to correctly sync payment data with our system.