Everything since 2014 in exception report

I'm glad you raised this concern here, @Crayola.

I see how challenging it is on your end to view your exception report having incorrect data. Yet, we appreciate your effort in organising your transactions to correct them. Let me help you fix this.

First off, you can utilize the Audit log and customise the Date to see the deleted transactions and accounts and recreate them. Also, you can check here if someone made changes to your account.

About the exceeding balance of 800k, you can compare the bank statement to your records in QuickBooks Online (QBO). Once you find the cause of the discrepancy, you can add entries or delete them if they're not included.

With your missing transactions, you can run a report based on what data is lacking. Moreover, you can review the Chart of Accounts (COA) if it's a categorised bank transaction.

However, if the report and COA don't show the missing data, you can return to the Audit log to find and recreate them. Moreover, you have the option to make an Excel or CSV format to import them in QBO.

On the other hand, when running a VAT 100 report, there are things you need to take note of to show the correct data. You can read this article for detailed info: Run a VAT 100 report in QuickBooks Online.

Furthermore, QBO follows certain criteria to match the £20k worth of VAT payments to your old returns.

You can read the bullet lists below:

• Ensure that the transaction isn't reconciled.

• Verify if it was entered using the same bank account.

• The transaction has not been matched to another bank-downloaded transaction.

• If it is a deposit or payment received, ensure it isn't on the Bank Deposit page (undeposited).

• The Date, Amount, and Currencies should be the same.

If the solutions don't work, you can contact the QBO Care Team to help you identify and resolve the issue.

Additionally, if you want to adjust your VAT, feel free to read this article: Create or delete a VAT adjustment in QuickBooks Online.

Let me know if you have further questions about managing your account transactions. We'll be willing to help. Keep safe, and have a good one.

I will check everything that you have guided me with. I am still trying to put a full report together, because I 100% will need tier 2 support intervention to put it right, and I want it to go smoothly. This is TEN years of "books", and even your audit logs will not exceed 7 years. This is going to be a ONE time wonder, believe me. I would have liked to have taken the accounts back the remaining 3 years of business back to 2011, but obviously the MTD nonsense has carbolshed(SP) that idea, because this nightmare is quite enough thanks.
The accountant has run off with head under the sand I think, after I pointed a few things out in my internal book keeping against the filings. Doing my best to bring you support team something concise... and have weeded out a few issues on my own.....