Reconcile Bank statement & Credit card statement & accounting data

B

Bklynhyc

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top