Is there a way of finding out how many transactions have been entered in a month in VT Transaction?
I thought it was the number in the bottom right hand corner, but when i count the transactions entered Vs this number its always less than the number. For example i counted 36 transactions but the program said 98 in the month i just don't know where its getting the figure from, or more importantly where i can get my figure from.
This is just a guess (I purchased VT Transaction last week, but haven't actually used it yet) but could it be that your 36 transactions are split into their component parts and stored internally as 98?
e.g. consider this transaction: Purchase invoice of £100 + VAT for some wojams. It may be that VT is internally storing that as:
Transaction 1: Credit: £120 on the relevant purchase ledger account
Transaction 2: Debit: £100 on the relevant P&L account for wojams
Transaction 3: Credit: £20 on the inputs VAT account
If the internal database works along those lines, simple transactions that carry a VAT element will require three entries in the database, and those that don't two.
As I said, though, I'm just making a random guess. There are some here who swear by VT, and might be able to offer an accurate answer.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
you hit the nail on the head John, different input types keep different numbering. Also, if you delete an entry it doesn't renumber everything else so the number is not a reflection of volume but simply a unique reference.
If you want to know how many transactions exist for a period I would be more prone to dropping the whole VT file to an Excel spreadsheet and then letting Excel count the entries between the two dates.
I would go with sort by date, then use countifs to count the number of records between two date.
i.e.
The following assumes that the date is held in column A
Enter a start date in column I1 Enter an end date in column I2
find a cell and use the following formulae (you can just copy and paste this in) :
=COUNTIFS(A:A,">="&I1,A:A,"<="&I2)
Ever so easy and once you've done it once all that you need to do is copy and paste the VT file into your spreadsheet (which will also serve as an additional handy backup) and update the dates to what you want.
kind regards,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
yep, just swap from normal to spreadsheet mode, copy and paste away.
It is quite a nice feature.
glad the suggestion helped,
kind regards,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I just listed every transaction for the year and right mouse clicked copy all and then went to excel and paste as text.
Your formula was spot on, whilst I would say I'm an advanced user of excel there are still so many parts I wish I knew more about, like more of the formulas and macros but hey can't have everything.
Whilst I thought of myself as quite an advanced user I have to say that there are many new things espechially shortcuts and alternate methods that I've learnt from that channel.
There are a couple of thousand vid's so its one that you dip in and out of rather than trying to go start to end.
Try starting with Conditional Formatting, Pivot Tables, Lookups, Matching and Indexing. Even if you think that you already know those subjects like myself you will probably be surprised how much you don't.
Well worth setting haf an hour a day for
All the best,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
