I receive telephone data from a number of different suppliers each
month for my clients. Obviously, they all use a different format. I
have devised a number of "translators" - excel files which take the
data in a particular format and convert it into "my" standard format.

If you are not successful in persuading the accountants to change to
your data format, then perhaps you could set out to do something
similar.

Hope this helps.

Pete

On Oct 27, 10:35 pm, "mttmwsn" wrote:
If you must use Excel spreadsheets then you could provide an Excel
template that all of the accountants must use to report their data and
get into your hands. That would freeze the form of the data coming in
to you so you'll only need to deal with the thing you created.

I'm probably going to end up using an Excel template, but I'm anticipating
that these accountants have their own invoice templates which are linked to
their inventory spreadsheet. They will probably raise Kane if I try to ask
them to migrate over to my template. What can I do about this?