Share this content


Good morning

Does anybody know how to get moving period totals from VT.

This can be 3, 6, 9 or 12 months - needs vary.

It should not  have bfwd balances.

Any help greatly appreciated.

Many thanks


Please login or register to join the discussion.

08th Sep 2010 11:56


You can set periods in VT and report on those.  Or set a period to a particular month end, export the TB to Excel, and do the same for following months, getting Excel to calculate the difference and report it on another sheet.

If that sounds painful, there is probably a VBA routine (referred to n VT help as Objects I think) that you could create that would extract what you wanted.  I have never got the hang of it:

Accessing VT Transaction+ files from other applications

Top  Previous 

Other applications (including macros written in Microsoft Excel or Access) can have full read/write access to VT Transaction+ data files using the VT Accounting Objects (VTA.dll) software component.

Other applications can also invoke most of the dialogs used by VT Transaction+ using the VT Accounting Dialogs (VTADlgs.ocx) software component.

Full details for both components are contained in the help file VTComponents.chm. The components and the help file are installed as a standard part of the VT Transaction+ installation and are stored in the C:\Windows\System32 folder. The components are intended for use by programmers.

A Microsoft Excel workbook containing sample macros can be downloaded from

Even if you have no programming knowledge, you can still run the sample macros in this workbook to get an idea of what is possible.

VT Accounting Objects has a wide range of uses. For instance, you could use it to write a program to automatically generate, save and print the sales invoices for your business. The sample macros workbook includes a macro for generating and printing an invoice.

If you are a programmer, the Concepts topic may help you understand the object model underlying VT Accounting Objects.

If you get one to work, please let me know and I'd love to borrow it from you!

Thanks (0)
09th Sep 2010 09:40

There are buttons for this at the bottom of the account window

The following buttons the bottom of the account window will do the trick:

Display/hide movements in balanceChange the balance reporting interval

Thanks (0)