Hey
I really need some help, this whole thing has made me realise that I am not fit to bookkeep, so I want to sort this absolute mess i've made out, have everything ready to send to the accountant for his year end then allow another bookkeeper to take over (So potential new client if someone is interested?!). I'm honestly embarrassed that i'm even posting this.
I'm going to phone the ICB tomorrow to see if they can help/ advise but I have really really messed up with my client's VAT on his software and I can not for the life of me fix it.
I'd been keeping all of my clients sales and purchases recorded on spreadsheets and calculating the VAT from there. After looking online for advise for something unrelated I realised I had been missing out purchases that should be on his returns, so had a massive massive comb through of my spread sheets, calculated exactly what should have been included on the VAT return for what periods, and for the VAT return that then needed submitting, it was basically the Aug/Sep/Oct period +/- any adjustments needed from any other periods.
I then realised that i've entered plenty of journals wrong relating to this, but as some are bank reconciled I couldn't delete them, so need to reverse. It also occured to me that I haven't been selecting 'include in vat return' when adding journal expenses to Sage either.
So, I decided to run the VAT returns and make the adjustments through there as they're automatically posted, and going forward, enter everything properly and calculate the VAT returns through Sage.
The VAT returns and adjustments all go through as they should. Apart from the last one where I accidently enter the figures for the actual Aug-Oct period rather than the adjusted figures. You can not delete saved VAT returns in Sage, so it needs reversing. Which I try to do through a journal and run a return on that too.
I enter via journals alll the payments that have been made for vat through the bank account.
Now, when i'm looking on the trial balance, the figures are just all over the place, going onto the balance sheet makes no sence as the figures are for eg showing:
VAT on sales: £59,642.72
VAT on purchases: £47,874.42
VAT liability: £24546.44
Then in the figure that's shown as the actual VAT owed: £12,778.14 (which if you subtract from the above 'VAT liability' figure, comes to what the actual difference between sales and purchases is).
I know it's likely just a case of a mammoth journal to sort it out, but I can't figure it out.
I've got a 2 month old baby asleep upstairs, as well as a toddler and an older child. I've been up all evening trying to sort this and it's honestly made me realise that I don't want to do this with this client anymore. The stress of dealing with my baby/ toddler/ sleep deprivation and this is just not a good mix, it's effecting my entire life negatively.
I do around 4 hours per week and charge him £18 per hour, but I just can not do it and it's getting me down.
Please help :(
My number is 07833462853 if anyone can. I'm going to email this to the ICB too to see what they say.
|