I have a restaurant/bar and this has been driving me crazy ever since I switched credit card processors. Every night after bar closes my POS database has 4 entries. Master Card Sales, Visa Sales, Discover Sales, and American Express Sales. A few days later I get a deposit into my bank account for the total of all the sales. Sales from Thursday through the weekend are not deposited until the following week. This is where my problem starts. When these deposits finally come through they are sometimes lumped with another day. If I put all my deposits and all my sales in excel and match them up. There are usually 10 days of sales a month that I can't match. I then have to start adding days up and start trying different combinations until they match. To make this worse. They will sometimes separate the different credit card companies and deposit them on separate days. With 4 credit cards and an average of 10 unmatched deposits. That is a lot of combinations to try. No idea how to solve this, I'm sure one of you experts has a solution. I don't mind VB although I'm not great at it.
To Simplify:
column A = Date
Column B = MC
Column C = Visa
Column D = AmEx
Column E = Total
Column F = Blank
Column G = Date
Column H = Bank Deposit
Any combination of the numbers in Column A-D could match Column H. Column A-D are not always from the same date when matched to Column H.
Also in the less than 1% chance that there are multiple combinations that match the same number is there a way to make this known, maybe highlight all cells involved yellow.
To Simplify:
column A = Date
Column B = MC
Column C = Visa
Column D = AmEx
Column E = Total
Column F = Blank
Column G = Date
Column H = Bank Deposit
Any combination of the numbers in Column A-D could match Column H. Column A-D are not always from the same date when matched to Column H.
Also in the less than 1% chance that there are multiple combinations that match the same number is there a way to make this known, maybe highlight all cells involved yellow.
