I have 3 Point of Sale systems, Hotel Management, Food & Beverage and a Retail Liquor store. Only the hotel software will produce flat files and it's the lowest transaction volume.

I have 2 objectives I need to accomplish. 1. I need to reconcile each sales clerk's cashout against their sales and 2. I need to accumulate their sales, taxes and tender received by GL account/Department for import into the GL.

I also need a pause between the data entry and the GL posting for review because there are a lot of small reconciliations that must take place before it's ready to go.

It sounds like a job for Excel but the data entry folks can be a bit ham fisted from time to time and are happy to 'save as' something with a different name and put it on their desktop instead of the server, etc. etc. so looking for a solution that will impose some structure on the data entry part of the process....

and yes, i do NOT need actual invoices... but I was thinking we could generate an invoice to 'Cash Sales' for each clerk so that I could record what they sold and what they submitted. Then each 'invoice' would be a proof of the clerk's sales and cashout for each day.