Skip to main content
C
Crayola
July 20, 2024
Question

Everything since 2014 in exception report

  • July 20, 2024
  • 1 reply
  • 0 views

My QB was in an insane state, balances out by over 800K, deleted invoices, missing transactions for years, Two completely empty VAT100 reports, a random open VAT return, VAT and corporation tax payments deleted, accounts deleted. Unable to match £20k worth of VAT payments to old returns that were not submitted MTD.

How stupid of me that I attempted to bring it into order and have my QBO and bank balances match. I now have a completely erroneous 100 page exception report so it is well beyond ability to edit them out individually (not that I know how). I've downloaded it into spreadsheets and with many dates and descriptions missing, I can organise a lot of it, but not all. Most alarmingly, it has brought in a tonne of old (eg 2015/16) invoices that either don't exist, or it has duplicated them with different and incorrect VAT amounts .... sending my VAT due balance to extremes. 
VAT is due in less than 2 weeks, end of year is 31st August. Had Quickbooks since mid 2014 and I do NOT want to lose what is now 10 years of data input. Pre MTD, QB was just used as a way to create invoices and get paid. Nobody knew how to use it properly, the accountant refused to use it. I just want to put it right moving forward.

1 reply

Bryan_M
Bryan_M
July 20, 2024

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.

C
CrayolaAuthor
July 22, 2024

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..... 

Terms & ConditionsAccessibility statement