Please can anyone help. Whilst reconciling the accounts, I thought I hadn't registered the VAT refund I was given but I had, therefore it messed up the VAT return for the next quarter. I added the refund and realised it was already added therefore deleted it and because it was all reconciled it has messed it up. It is now saying because of this I owe £8,000 in VAT which I don't. How do I sort this out???? HELP please. Need to sort.
Pleased to have you here, @Kennels9.
Let's locate the transactions and make changes to them. Let me share an article that can help you Reconcile previously deleted and re-entered checking or credit card transactions.
The next move you need to do is to reconcile them on a month-by-month basis, starting from the oldest bank statement. Doing this will ensure that your balance, both opening and ending, for each month will be accurate.
Also, I'd suggest consulting with your accountant so you'll be properly assisted when reconciling your account.
I've attached a link about the best practices when doing reconciliation and the steps on how to do it. For more troubleshooting steps to fix reconciling differences such as combining multiple transactions, enter missing or handle transactions that are slightly off, I recommend the 2nd article:
Let me know if you have any other questions in the comment. I'll be happy to help you some more.
Re-creating the adjustment with the same date as the original adjusment will create an additional exception in your exception report which will essentially produce a net exception of zero. Rather than entering an adjustment, if the money received was a refund for a previous VAT filing made on QuickBooks you can select the drop-down beside the pior filing on the Taxes screen > Record refund (this again will reverse the exception if the date and amount is the same).
Please get back to us below if you have any questions!
Only just got chance to look at this again now, how do you recreate an adjustment? I did the second option but then it just said I was paid double the refund i was due? I am getting so confused now just because of my stupid mistake. This is not my forte!!
Thanks for your help
Thanks for getting back here, Kennels9.
I'll provide the steps on how you can do the adjustment. If you haven't set up an account for the VAT adjustment, let's do that by following these steps:
Once done, you can create the adjustment.
Here are the steps:
If you're unsure about the process, I'd recommend reaching out to our Customer Care Team. They can pull up your account and check the transactions affected.
For the new QuickBooks Assistant help update, you can follow these steps:
You can always visit us here if you have any follow-up questions or other concerns with your Intuit Online Payroll account. I'll be around to help you out again. Take care!