Anything that you can put to Excel you can put into VT via bulk inserts but generally things are so convoluted that there just isn't any point and the best method is to enter your prior period closing balances into VT then bulk together the entries for each customer and supplier account for the period to the point of switchover (so at least you have correct individual balances rather than just general buckets).
When you are done, run a set of accounts off Quickbooks and one off VT to make sure that they are the same and once they are continue with VT.
The downside is that all of your history will remain in QB up to the point of switchover.
Is not really so different to a start of period switchover, just a bit messier.
Allocate a minimum of half a day for this but allow up to two days to allow for things going wrong.
__________________
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.