VT users, would anyone be so kind as to email...

VT users, would anyone be so kind as to email...

Didn't find your answer?

... me one of the templates of VT accounts - pref. the sole trader template or small co. template? I don't need any of the other parts or the upgrades and support etc hence I don't want to purchase, just could do with a VT template so that I can use as a base to build my own customised program. Just started out. I will pay for this i.e. BACS.

This would be very much appreciated. Many thanks.

email : TAXWISE @ HOTMAIL.CO.UK
Richard Ryder

Replies (13)

Please login or register to join the discussion.

avatar
By carnmores
04th Jan 2006 14:32

you have more time when you strart..
but dont be tempted to breach copyright laws or others to do the same

Thanks (0)
avatar
By AnonymousUser
04th Jan 2006 19:28

.
I simply wondered if anybody was kind enough to mail me a template as a gesture so that I could use some of the VBA codes to build user forms / macros etc.

I have designed my own accounts, that look a lot better, presentation wise than VT or even Iris - VT only has one column for the P&L acc which is not in my view correct i.e. turnover is in same column as expenses and overheads whereas the overheads for example are usually in a seperate column to the left of the (turnover) colums which generally contains the totals of the left hand column.

I have built macros which change for examply net profit to net loss depending upon the values entered (pos or neg) and I have a macro that hides all cells containing zero.

However, I need some guidance as to how to get the notes to accounts numbered automatically. If i want to add a note for a particular client about share premium or investments for example, this would throw all the other note numbers out.

Seeing as most respondants are being what most businesmen percieve accountants to be anyway i.e. pompus, I will have to do without a template.

Does anyone have any advice on how to get round this problem - apart from this my accounts package is perfect.

Thanks.

Thanks (0)
avatar
By User deleted
04th Jan 2006 21:42

.
Richard,

The respondents have not been pompus from what I have read, they have offered you their help and advise.

I find your reply to be a very aggressive and pompus one, I really do hope NO ONE offers you any help if this is your manner!

Well done for having created a ‘perfect’ accounting package, now how very pompus is that offering such an inflated opinion.

I hope you find my posting unhelpful, it’s a shame that you are such a child and have thrown the help offered thus far back in the faces of those kind enough to take the time to reply and then to call them names, I happen to be a businessman who from time to time uses this forum and I can assure you, you would be the last accountant on my list with such an arrogant and inflated opinion of yourself, I would most definitely contact one of those on here who have tried to help you as they are obviously approachable and that’s number one on the list for us businessmen, so please don’t assume we think accountants are pompus when that’s your view!

Thanks (0)
avatar
By ACDWebb
04th Jan 2006 22:16

What are you using as the underlying program?
Access, Excel, Word?

I can't help you with the template - because I don't have it - but user forms in VBA are relatively easy once you get the hang of them. If you have VBA knowledge already then a little time with a slightly more advanced "teach yourself VBA" is more likely to get you there.

Sorry, not much help but there you go

Thanks (0)
avatar
By vtsoftware
05th Jan 2006 08:48

VT Software reply
I would just like to point out that anyone who gives a copy of one of our templates to another person is in breach of copyright.

The macros in VT are contained in an add-in program and not in the templates themselves. It is not possible to access the source code for the add-in.

We have tried to keep the templates as simple as possible, but if you want a more sophisticated (complicated?) format it is possible to design your own templates for use with the VT add-in and take advantage of all features such as automatic note numbering, auto switch from profit to loss etc.

For your info Richard, all note number cells in a VT template are given a unique name beginning Note_. After AutoHide has been re-evaluated a macro examines each of these cells to see if they are on a visible row. Sequential numbers are then inserted into the relevant note number cells.

The above methodology is largely hidden from the user. The names in a pre-formatted template are already set up, and for a custom template one just chooses the Insert Note Number command.

Philip Hodgson
VT Software

Thanks (0)
avatar
By AnonymousUser
04th Jan 2006 17:01

Buy VT
Richard,

I thought about doing a similar thing when I first started out, ie. developing my own solution, as I have used Visual Basic etc. in the past.

However, it's not worth it. The amount of time you'll spend will be considerable and I would suggest better spent building your client base. If your lucky, you could end up with a similar product to VT, but with all the maintenace headaches and no clients to use it on. Also VT comes with a simple bookkeeping app also which links automatically to the templates.

My advice, bite the bullet and purchase VT. Its an excellent product at a fantastic price. Then concentate on networking etc. to build your practice - you'll probably cover the cost with your first client !!

Thanks (0)
avatar
By jasonholden
04th Jan 2006 11:45

Look at their site
Richard,

I think VT have templates on their site.

VT is not expensive to buy and far less hastle than doing your own!

Jason
http://www.holdenassociates.co.uk

Thanks (0)
avatar
By User deleted
04th Jan 2006 16:04

Calling VT
Is there anyone out there from VT who would like to contribute to this thread?

Thanks (0)
avatar
By AnonymousUser
05th Jan 2006 11:33

Message to Philip from VT
Given the response by Richard that we are all 'pompus', I am extremely impressed that you are still willing to offer some practical advice on how to solve his problem.

Well done on an excellent product and an even better attitude. Lets hope he decides to buy VT !!!

Thanks (0)
avatar
By listerramjet
05th Jan 2006 12:03

notwithstanding the confusion
being an Excel and VBA anorak, and also having used a variety of accounts production packages in anger...

I would suggest that there is no economic case for a sole practitioner to write his own accounts production application. Not only is there the overhead of writing the application, but you also have to keep the templates up to date.

You may have the "perfect" formats but your effort has some defects that you do not seem to have your own solutions to, and although there is some advice on here that will help you get there, I suspect that you don't have the competencies required to make this work for you - if you did then you would not have needed the help you are asking for.

Thanks (0)
avatar
By AnonymousUser
05th Jan 2006 12:35

Suggestion
I've set up various template sets of accounts in the past for firms that I've worked for. It was based upon this experience that AccountsVision was originally initiated.

One suggestion, and one that I've used before, is to set up a control sheet that monitors and determines which notes are going to be required. In this way, you can control numbering and cross-reference the numbers to the P+L, Balance Sheet and the notes, ensuring the same number is used throughout. A formulaic approach can also help other people see how the system works.

Hope that helps.

Steve Checkley
www.AccountsVision.co.uk

Thanks (0)
avatar
By AnonymousUser
05th Jan 2006 14:42

Accountant programmers?
this thread got me wondering how many accountants dabble with programming. VBA
appears to be common for those that do, although apparantly Microsoft has signalled its intention for this to be phased out.

What do colleagues do with VBA apart from producing accounts production templates (not wise in the long run for limited companies, in my opinion)?

I have spent some effort learning .Net (C#) programming and have produced my own deadline management system (simple but suits my needs).
Have any other accountants taken the time to learn .Net (or Java or any other mainstream languages) and what have they done with those skills.

I'm just curious!

Thanks (0)
avatar
By ACDWebb
05th Jan 2006 19:08

Build routines to
print/update selected comps in a large partnership model

extract totals in that model into a separate sheet/report rather than have loads of different formulae referring to the result sheet

automate a lot of things that are done regularly, including hiding/unhiding selected rows/columns/sheets from within a selection of the same and applying conditional formatting to subtotal cells.

run/expand mailmerge routines

convert extracts from the accounts and tax systems into a useable format

Thanks (0)