Quick books - Vat reconcile
mc25
Registered Posts: 232 Dedicated contributor 🦉
Just a quick question. One of my client did VAT return on Quick books forgot to reconcile the amount on that period, I know what went through that period as i have got a print out. which is the easiest way of tieing it up before next Vat return. I had manually started reconciling it by going on to chart of account then vat control account and make all the transactions I know fall on the previous qtr as (Filed)reconcilled. The only problem is this is not recording the figures in box 6 and 7.
Any ideas...
Any ideas...
0
Comments
-
If it's anything like sage and you only need to the transactions marked in sage so it doesn't pick up those figures next quarter would be to post this quarters as normal and run the return (which would pull in 2 quarters figures) and deduct the previous return.0
-
Thanks for your reply, will give it a try.0
-
I do this on a regular basis and I think that the best way to do it is run the VAT detail report and compare it to the original figures that were filed. It's usually just a case of a few extra transactions entered since the filing date, so I double click on each new transaction to open it and then change the date to 10 years in the future (ie an invoice dated 15/03/2010 I would change to 15/03/2020). Once all the additional transactions have been moved out of the way the VAT report should correspond with what was filed, then you can file the return and then run the VAT detail report again extending the date range to 2020 and change all the transactions back to 2010. On the rare occasion where I can't find all the discrepencies I enter a bill/credit note to 'bodge' the figures to match and then enter the reverse of the adjustment in the following period to keep it right.
Also, if you don't have a list of the actual transactions that made up the figures filed it's often worth seeing if a backup was made around that time and restoring that to see whether it's got a more accurate list.0 -
Jodier thanks for your help. I did that, sorry took so long to reply I haven't had internet for nearly a month.. thats virgin media for you. I am back now.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership