Hi WestOne
I have imported into a new QB file for a client who had virtually no bookkeeping for 6 months. If I remember right the VAT goes on a separate line rather than a separate column. eg rent of £1200, 1k net, 200 VAT:
SPL rent 1000 SPL VAT 200 SPL C Card -1200 (There are of course several other columns to include as well as the '!' words)
Now, my client had already filed VAT returns himself, so it wasn't very important to include the net of VAT figures (boxes 6&7). Unfortunatley I can't see that it is possible to include that in the import. The import does tend to confuse the QB VAT workings slightly as well so you need to know what you are doing!
If you have a spreadsheet as default (perhaps a download) you may be better off journalling through the totals for each month. Otherwise do what you are trying to avoid - enter each line!
By the way there is a help topic called Importing transactions to Quickbooks, have you seen it?
Regards
Andrew
(Edited for format 26/08/11)
Edited at 26 Aug 2011 08:27 AM GMT
|