Sage 100

Customer/Bank Reconciliation of Credit Card Deposits: Was wondering if anyone has suggestions on the best standard report or the most efficient way to create a custom report that would help with reconciliation of customer deposits. I've never really dealt with this kind of volume before, and now I'm working with a client that has to reconcile approx. 200 paypal and credit card payments coming in from web orders on a daily basis. The GL Detail report is not great since we can't really see ""reconciled"" transactions come off the report, and there's no report that would show remaining transactions to be transferred from deposit account to cash account. Any ideas to make the client more efficient and accurate would be appreciated. Thanks!

Have you looked at the AR, Reports, Deposit Transaction Report? Select a credit card payment type.

I'm familiar with that report, but it doesn't help me figure out which deposits still need to be reconciled from the deposit account into the cash account.

Reach out to @ThereseLogeais - She has a Crystal report that may be helpful.

I use a report of the Deposit amount on open sales orders to reconcile the GL.

Here is the report.

Thanks Myron. I wasn't clear, but I'm pulling from invoice history, since deposits don't post until the Sales Journal update. I talked the client into performing lump-sum Bank Rec adjustments of credit card deposits from the Asset account into the Cash account, instead of trying to reconcile each individual invoice.