Answering slightly different to the question in that rather than give you A, B, C instructions I'll give you an approach to adopt with this.
I find the UIS a little problematic as the descriptions don't tie up perfectly with everything that you might want to add using it. If I use it I load up everything seperately, i.e. bank transactions, receipts, payments, etc.
The first time that you use the sheet I would advise that you create a new company as a copy of the one that you want to update, create your load files and go with trial and error to ensure that everything is loaded as you would expect it to be.
Once you have loaded your dummy company correctly just use the files that you have created to apply the data to the live company books.
Going forwards those load files will be your templates for all future loads.
Generally the only reason that I use the UIS is for renumbering. i.e. when a client initially had missing paperwork and then once you have everything you want your front transaction list to at least be in some semblence of order.
HTH,
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.
Thanks Shaun that's a good idea regarding creating a dummy load first, and tbh I should have thought of doing that anyway. I reckon I can cut the input time by at least 50% if I get it right.
