The issue: In our ERP system we have to reconcile bank deposits coming in to ERP to Apex tickets. The bank deposit comes in as a lump sum for the location for a date, but that day's deposit can be composed of one or more days worth of tickets/cash collection. It is also typically not the same deposit date as the ticket date. We would like a better way to match the ticket data to the bank deposit date.
Suggested solution: *Keep in mind we are still on the Apex 5.1 version of Cash Recon...maybe some things have changed.
Provide a way to record and match up the following data:
Tickets->Single Bank Deposit
Single Bank Deposit->Bank deposited date
This should help us develop a system to electronically reconcile cash tickets to deposits (which is currently somewhat manual). Even if the bank doesn't record the deposit until the day after reported we will put some variables looking for deposit amount for dates in and around reported date for the purposes of auto reconciling so that is still good enough.
*Because we deposit checks electronically day of this is intended for true cash sales, but wouldn't hurt much if we had to do it for all.
**Credit cards for us are handled through a Credit Card processor and we already record date, etc.. in that system so we can match credit cards well enough, and even more so with the future Apex 2018 credit card processing software.
