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 timeWe would like to understand:What exactly does the “Modified On” field represent in reports?Does it update when a payment is applied to an invoice or bill?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.

Question

Modified Date not matching Payment Date in reports after payment made

Forum|Forum|3 months ago
March 19, 2026
1 reply
9 views

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:

What exactly does the “Modified On” field represent in reports?
Does it update when a payment is applied to an invoice or bill?
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.

QuickBooks Online

RazzieE

QuickBooks Team

Hi there, @soumya91. The Modified On field shows the timestamp of the most recent update made to the transaction itself. It does not reflect the actual payment date you entered in the transaction. So if you are backdate a payments or enter it later the two dates won't match.

In QuickBooks, applying a payment to an invoice or bill is treated as a change to the transaction's status. Because of that, the Modified On date will update the moment the payment is applied, even if the payment you entered is earlier. This is why you may see a mismatch between the payment date and the modified date.

If you need a report that shows both the payment date and the related invoice or bill number in one export, you can use the Transactions List by Customer report. This report give you a combined view that's easier to synch with your system.

If you have follow-up questions, please don't hesitate to click the Reply button.

S

soumya91Author

Thank you for your explanation.

However, the issue I am facing is slightly different. The "Modified On" field in the report is not reflecting the expected date and time (it appears to be showing a different timezone, such as PDT).

I have already raised this concern earlier, and it is currently being investigated by your team under case number 15156005328.

Could you please refer to that case and provide any updates if available?

Thank you for your support.

EduardA

QuickBooks Team

Hi @soumya91. Since your concern has already been raised with our Live Support team, I recommend reaching out to them directly for the latest updates. They have their own tools to see exactly where your case stands. Just give them your case number during support hours, and they'll take it from there.

Feel free to leave a comment below if you have any other QuickBooks concerns!

Sign up

Login with SSO

Let's get you signed in

Login with SSO