I am responsible for account reconciliation for 15 businesses. Each business has 4 accounts (let's call them checking, savings, money market, and credit). The businesses transfer funds among each other to their matching accounts (so, a business transfers $200 from their checking to another checking, never from checking to savings).

I get a print out every month of all the transfers, both in and out. Right now I manually go and check to make sure they all match up. Of course they don't, and I have to mark the discrepancies.

I'm hoping to use Excel for this, but a) don't know how to input the data (so I can properly classify that it's out or in from this business, from this account, and this amount) and b) what I would do after that. Any help would be appreciated!