Firstly I am not that familiar with Quick Books.
However have you tried setting up different VAT accounts for each foreign business so that you have somewhere to post the results of the excell spreadsheet without interfering with the UK VAT position.
That should cure the foreign business VAT messing up the UK's.
Will QB allow you to do that ??
|