Sage vat query
Hiya.
My 'Box 4' number does not agree with my N/C 2201 ( Purchase Tax ) for the same date range.
I have gone through each transaction and cannot find the amount - any ideas as to how to reconcile these figures?
The amount is only £2.27 but I still need to know how to sort this out.
Thanks
Moozy
My 'Box 4' number does not agree with my N/C 2201 ( Purchase Tax ) for the same date range.
I have gone through each transaction and cannot find the amount - any ideas as to how to reconcile these figures?
The amount is only £2.27 but I still need to know how to sort this out.
Thanks
Moozy
0
Comments
-
Did you have any transactions to bring forward from an earlier period? Sage will have told you if this was the case. This happens when a transaction for an earlier quarter is entered after the VAT return for that quarter has been reconciled. The only other thing I can think of is that you have a T9 transaction in the PLCA, just scan down the Tax code column and look for it.0
-
VAT return
I usually compare the Box 4 figure to the TB figure at the quarter end date rather than the history total.That way any transactions from an earlier periods are included. This assumes you are using standard VAT. If you are using cash accounting, the figures won't necessarily match and you would need to do a difference reconciliation.
Box 4 will include the VAT on any EU purchases. Depending on how your EU VAT codes are set up, and which version of Sage you are using, your might also see the £2.27 in box 2 and the corresponding Net figure in box 8. That's fine, you just exclude the £2.27 from your journal.
Lastly, you could have accidentally posted to nominal code 2201. As coojee says, T9 is easy to spot, but you could have posted any transaction to nominal code 2201 in error. Try using FIND in financials to search for £2.27 as Amount Paid, Net Amount or Tax amount0 -
Hiya.
My 'Box 4' number does not agree with my N/C 2201 ( Purchase Tax ) for the same date range.
I have gone through each transaction and cannot find the amount - any ideas as to how to reconcile these figures?
The amount is only £2.27 but I still need to know how to sort this out.
Thanks
Moozy
Sage is VERY date sensitive!
Make sure that each transaction's date fall within your vat period. (both for the transactions on the vat report and N/C 2201)
next step if that all right!
Export your VAT input data to sage
and export N/C 2201 date to sage
total every month's vat in the spread sheet and compare the data.
soon you will be able to narrow the data range where the difference is.0 -
£2.27? Write it off. It'll cost you more trying to find it.0
-
Thanks so much for all your replies.
I know that £2.27 is a small amount - and I probably will.
But if I can work this out, and go through the motions, then i can sort out any bigger messes if they happen in the future.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 328 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 57 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 203 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 583 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