Share this content
0
739

Taxfiler Accounts - TB doesn't balance?

Error message, but it definitely balances!

Hi folks, does anyone use Taxfiler for accounts production, and if so, have you come across this before?

I'm importing a TB from VTT+ so I know it balances. I'm getting an error saying the TB is out by £12k. Yes, I've included all the lines, I've scanned through for any obvious issues. It's a perfect TB and I am baffled and frustrated. Any ideas? I'm also contacting Taxfiler.

Clearly, this has to be for a set of accounts due tomorrow for which the client has requested last minute changes! Always the way, eh?

Replies

Please login or register to join the discussion.

avatar
By RLK
30th Aug 2017 14:40

Hi, I use Taxfiler but have never had that issue. Have only imported from QuickBooks though, not VTT.

Thanks (0)
By mrme89
30th Aug 2017 14:48

Have you checked that your debits and credits are the correct way around? ;-)

Thanks (0)
avatar
By Monsoon
to mrme89
30th Aug 2017 14:52

Lol. Yes :) Given that it's literally copied and pasted from VT, I can't see how it could have transposed :)

Thanks (1)
30th Aug 2017 14:52

I import TBs from VTT+ quite regularly and have not encountered this problem. Taxfiler support are usually pretty good so hopefuly they will sort you out.

Thanks (1)
avatar
By Monsoon
to Tim Vane
30th Aug 2017 14:53

Thanks Tim. Yes, as do I, I've seen it once before but it was a while ago and I can't remember how I got round it :/

Thanks (0)
avatar
30th Aug 2017 15:03

It's not doing something like importing a profit line as well?

Thanks (0)
avatar
By Monsoon
30th Aug 2017 15:31

I have a solution!

"
It's because of the two accounts that have numbers against them - they need to have a description against them as at the moment Taxfiler is ignoring them when mapping - hence the difference."

So I just need to rename my bank accounts. Sorted!

Thanks (1)
By DJKL
30th Aug 2017 15:31

Can you spot the exact difference figure in the TB being imported ?

Thanks (0)
30th Aug 2017 17:58

Adding up the debits and credits and comparing the proof totals might help narrow the field.

Hopefully, it'll be in credits, as there are usually fewer of these.

Thanks (0)
avatar
31st Aug 2017 14:49

Export TB from Taxfiler into excel and ensure it matches up with VT

Thanks (0)
31st Aug 2017 17:30

I used to use my own excel template for copying & pasting to Tf but even then it was not 100% reliable and so I ended up checking every figure, making it quicker to manually enter the numbers. A common one was the corp tax charge being put to the liability or visa versa

Thanks (0)
avatar
04th Sep 2017 14:15

how much is it out by? if its 1 0r 2 pounds its because of rounding usually. if more then it will depend on whether its a direct link as in QBO or a pasted TB from another program in which case you neeed to check that extra lines are not imported as per other anwser such as Profit for year etc

Thanks (0)
Share this content