VT Transactions Create Historical Trial Balance

Didn't find your answer?

Ok so we have switched accountants (Not my choice, Directors think the new guys will save us some dosh as the company grows).

Our new one doesn't use VT Transactions (our old one did and anytime I got stuck on ANYTHING at all I just emailed them over the file and they fixed/did it for me then sent it right back).

I have finally figured out (with the help of you guys on here) how to get everything I've logged to VT for the year into Excel so the accountant can use it, but now they have asked me trial balances for 31/7/16 and 1/8/16. I barely have the ability to make the up to date one for today!

Can anybody shed some light on how I get VT+ to make me old ones please?

 

Replies (14)

Please login or register to join the discussion.

RLI
By lionofludesch
20th Oct 2017 18:14

Yes - go to the tab in the bottom margin and set the dates to what you want. Then Display > Trial Balance

TB at 1/8/16 can be a bit of an issue - VT will give you thed TB at the end of the day whereas the accountants are looking at the beginning of the day. You can fudge round this by (temporarily) changing transaction dates on 1st August to 2nd August. Don't forget to change them back.

Thanks (0)
Universe
By SteveOH
20th Oct 2017 23:00

If I understand correctly, your year end is 31st July and you want to print a trial balance as at 31st July 2016.

If you open VTT+ you will see on the bar at the bottom of the screen "Year to July 2017" or similar. If you click on that, you will see all the years that you ave entered onto VT. Select "Year to July 2016".

Click on "Edit" on the top menu bar and select "Export Trial Balance". Click "Browse" to select the folder where you want the TB to be exported to and click OK.

Hope that helps,

Thanks (1)
abc
By Kim Jong Un's Hair
21st Oct 2017 00:30

Send them the frigging file and get them to do it - that is what they are paid for.

Who needs a post ye balance sheet anyway.

Thanks (1)
avatar
By andy.partridge
21st Oct 2017 09:16

Other products such as Sage have what is known as a 'brought forward' trial balance which will not contain any new current year transactions. VTT+ doesn't have this facility, so the accountants should use the previous year's year end TB.

Lion is right about the workaround, but I would not do it. Unnecessary and risky.

Thanks (0)
Replying to andy.partridge:
RLI
By lionofludesch
21st Oct 2017 09:26

andy.partridge wrote:

Other products such as Sage have what is known as a 'brought forward' trial balance which will not contain any new current year transactions. VTT+ doesn't have this facility, so the accountants should use the previous year's year end TB.

Lion is right about the workaround, but I would not do it. Unnecessary and risky.

Ach - it depends how many transactions happen on day 1.

Risky ? What's the worst that can happen ? A few transactions that happen on Monday are booked in for Tuesday ? It's unlikely to affect anything.

Thanks (0)
Replying to lionofludesch:
avatar
By andy.partridge
21st Oct 2017 09:55

That the OP has not been able to think this through themselves is indicative of the risk. I agree the risk is negligible for you following your own advice.

Thanks (1)
Replying to andy.partridge:
RLI
By lionofludesch
21st Oct 2017 10:05

Fair point, well made.

Thanks (0)
Replying to lionofludesch:
avatar
By andy.partridge
21st Oct 2017 11:28

Oh [***], you agreed. Now I won't be able to use the anecdote I had planned!

Thanks (0)
Replying to andy.partridge:
RLI
By lionofludesch
21st Oct 2017 14:09

No - carry on. I like a good anecdote.

Thanks (0)
avatar
By Ken Howard
21st Oct 2017 11:46

Just tell the accountants to download it from the vt website and then they can import your data and do what they want with it. They can easily get a free trial version to do it. Either that or tell them to come to your office and they can look at your live version.

It sounds like they're one of those accountants that only use Sage - as they're asking for the type of thing that you'd routinely need on a Sage job. Next thing is that they'll be persuading your firm to buy Sage as they'll be rubbishing VT simply because it doesn't work how they want it to. That will not only be expensive, it will also mean you have to learn Sage and it will take you a lot more time to process the book-keeping etc. compared with VT.

Thanks (0)
avatar
By andy.partridge
21st Oct 2017 17:10

No, don't be persuaded to move to Sage. That would be like swapping your Smart car for a Morris Minor.

Thanks (0)
Replying to andy.partridge:
RLI
By lionofludesch
21st Oct 2017 17:25

I'm not sure whether that advice will still be Smart in 18 months' time.

Thanks (0)
Replying to andy.partridge:
paddle steamer
By DJKL
23rd Oct 2017 12:34

Well, on performance grounds you have a point, on holding value- not quite so sure in the long term.

Whilst Minors are not drooled over in the same way as Mark 1 Escorts might be (I offloaded my 1974 Escort in the later 1980s for about £160 , what a fool, and I previously had got rid of a Mark II Cortina for next to nothing - how not to spot future classics) they do have their attractions e.g the engine bay is so big, relative to the engine, that getting your arms anywhere is a doddle.

I have a great affection for Minors, my Mum had a Woody that rusted before your eyes and I took night school classes in the 1970s re car maintenance, the car in the classroom, a Minor.

Thanks (0)
avatar
By NatashaIEL
23rd Oct 2017 12:18

Thanks,
No our accountant is trying to convince us to move to Xero but I haven't heard good things and have no knowledge on how to use it so I'm trying my best not to budge!
Thanks for all the help people.

Thanks (0)