Sage 100

I have a customer with a fairly simple request. They are on 4.4 STD (soon to be 2016) and looking for a way for accounting to enter and allocate AP invoices against a couple dozen GL accounts. The allocation is based on headcount and changes frequently. I've mentioned GL allocations but they really want an Excel spreadsheet for accounting and then for that to generate a CSV to read into AP Invoice Entry through VI. I'm sure there must be several solutions people have come up with before I reinvent .. TIA

What about using Expense Distribution Tables?

We've used Expense Distribution Tables for a client and have also set up VI imports for many clients wanting to allocate credit card charges or other long and tedious manual keying of invoices

I thought about the built in Sage distributions but they say that the percentage change so much they prefer to do them in Excel

You could use a button script to read the excel file and write the GL Lines. I do something similar with Cash Receipts.