I was given aged debtors summary report for 3/3/21 taken on 4/3/21, for the value £A.
After 4/3/21 new transactions were created and date valued 3/3/21 and prior (combination of added invoices, edited invoice/payments, even moved transaction date)
Due to the changes back dated, if you run the aged debtors summary report now for 3/3/21 it has changed to £B.
Is there anyway to rerun the report showing value £A and running the detailed version showing the line entries?
It needs to somehow ignore any lines from the audit log after 4/3/21.
Does QB save daily end of day system snapshots that can be accessed?
Solved! Go to Solution.
Hello Rav22!
I understand that you need to get the same data prior to adding the back-dated transactions. Allow me to assist you.
Any transactions added to your books will affect the company data and reports. The Accounts Receivable (A/R) Ageing Summary report is based on the invoice date and due date, not on the creation date.
While we're unable to exclude the newly added transactions on the A/R Ageing Summary report, here's what I can suggest. You'll want to pull up the Open Invoices report. We can customise it and add the creation date, due date, as well as terms. Please follow these steps:
You can use this report to see the transactions added before 4/3/21. If you need more assistance in customising a report, you can check this link: Customise reports in QuickBooks Online.
Do you need help in handling sales taxes? Please check this link: File your VAT return and record tax payment . This will show you the steps on how to review what you owe and file your VAT returns.
Post again here if you have additional concerns. Take care!
Hello Rav22,
Welcome to the Community page,
Im not to sure what you are refering to when you say about a and b are you meaning the amounts showing on the reports after those dates? Could you give us more information please.
hiya, £A & £B are just generic values, you can say original report is £1m and when run again now it is £800k, it is to indicate the aged debtors report balance had changed.
The change was due to transactions created after 4/3/21 but given value dates 3/3/21 and prior. This means any new debtors report for date 3/3/21 will now include them making it difficult to get back to report value £A
I need to somehow create the aged debtors for 3/3/21 again, but ignoring any changes that were created after the user logged in from 4/3/21
Hello Rav22!
I understand that you need to get the same data prior to adding the back-dated transactions. Allow me to assist you.
Any transactions added to your books will affect the company data and reports. The Accounts Receivable (A/R) Ageing Summary report is based on the invoice date and due date, not on the creation date.
While we're unable to exclude the newly added transactions on the A/R Ageing Summary report, here's what I can suggest. You'll want to pull up the Open Invoices report. We can customise it and add the creation date, due date, as well as terms. Please follow these steps:
You can use this report to see the transactions added before 4/3/21. If you need more assistance in customising a report, you can check this link: Customise reports in QuickBooks Online.
Do you need help in handling sales taxes? Please check this link: File your VAT return and record tax payment . This will show you the steps on how to review what you owe and file your VAT returns.
Post again here if you have additional concerns. Take care!
Thank you for the advice.
Due to the number of deleted invoices and movement in value dates, the customise report can only provide limited information,
Really appreciated your time on the query.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.