Skip to main content
R
Rav22
August 11, 2021
Solved

running reports with the filter of audit log cut off dates

  • August 11, 2021
  • 1 reply
  • 0 views

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?

 

 

Best answer by AlexV

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:

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

1 reply

A
Ashleigh1
August 11, 2021

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. 

R
Rav22Author
August 11, 2021

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 

AlexV
AlexVAnswer
August 11, 2021

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:

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

Terms & ConditionsAccessibility statement