Reconcile company credit card bank deposits to books

A co-worker is trying to reconcile monthly credit card deposits to our accounting records. The problem is that what we have listed on one date may not show up on bank records for several days at times. Also, especially on weekends several of our individual deposits may be totalled together as one amount on the bank records. The opposite can also occur where 2 or 3 amounts on the bank statement represent one amount on our accounting records.

Right now she's reconciling manually, trying to add several amounts from around the same date on one listing to one or more amounts on the other. Can anybody suggest a way to mechanize the process at all?

I realize this may not be possible, but thank you in advance for any replies.

Depending on how frequent the variances are by day, you could try a sumif formula to add all of the days debits and/or credits. Apply this to both your accounting records and the bank statement to see what dates do not reconcile. If there are a great deal of variances this won't help much, but it could eliminate a handful of days from the reconciliation process.

Thanks, Snax.

Not a bad suggestion, but I think she does have too many days where that wouldn't match. I think most days she has a combination of the differences that I mentioned, including the timing differences which would make the daily totals not tie.