Sage 100

SAGE 100 Standard v4.40 - GL & BR brain teaser question - Client running with GL, BR, AP, and Payroll - no VI. Just started using the BR module. Has 12 retail locations & 3 managers with four stores each. Wants to enter into GL daily cash receipts in GL with one entry per manager. However each manager has four deposit slips (one per store) and summarizes the revenue for all four stores. The GL Transaction Journal Entry only allows one debit to cash per journal entry and Bank Reconciliation Entry does not let you post to multiple revenue accounts. Any creative ideas?

What about crediting cash clearing in the transaction journal and debiting cash clearing and making the revenue entries in General Journal.

I'm with Ron. This is a very typical approach to recording sales and cash in a retail environment. Chain to VI jobs together. The first is to import sales data with an offset to cash clearing. This can either go into the GL module or into AR / SO if sales on account or inventory are involved. If using credit sales, use a ""Cash"" customer to record all cash sales. The second goes VI job feeds into Bank Rec to record the 4 deposits with offsets to cash clearing. These entries, if imported and posted correctly, should offset the clearing entries from the first import job on a daily basis. I recommend posting comments that are unique to the 5 entries so it is easy to electronically match the datasets to find days that are out of balance.

Thanks @RonGouveia and @ShawnSlavin I'll run the Cash Clearing account idea past my client to see if they are happy with that suggestion. Thanks for your help!