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.
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.
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,
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.
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.
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.
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.
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.
No, don't be persuaded to move to Sage. That would be like swapping your Smart car for a Morris Minor.
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.