Modified Date not matching Payment Date in reports after payment made

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.

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.

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!