Reconcile Bank statement & Credit card statement & accounting data
 

Hi,

I would like to know how to go about formulate a formula to lookup info.
with three of this statement and data list.

they all have
Date , Amount, and merchant no. I hard part is that the bank date are late
and there is a fee on the credit card that would link the bank statement and
the accounting data.

it look something like the following;

Bank statement:
amex 06/17/09 590.00
mc/v 06/18/09 490.00

credit card statement:
amex 06/16/09 600.00
amex 06/16/09 -10.00
amex 06/16/09 590.00
---
mc/v 06/17/09 500.00
mc/v 06/17/09 -10.00
mc/v 06/17/09 490.00

accounting data
amex 06/16/09 600.00
mc/v 06/17/09 500.00


best regards