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:
- Go to the Reports menu, then search and select Open Invoices.
- Set the Report period. Click the Customise button and proceed to the Rows/Columns section.
- Make sure to add the Terms, Due Date, and Create Date. You can add more columns by checking the corresponding tickbox.
- Tap Run report.
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!
