How can I formulate a reconciliation?

[Gorilla Show]

I am trying to wrap my head around doing account reconciliations more
effectively. The source data has been exported from an accounting program.
Now, I need a quick way of producing a formula that will assist in the
matching process.

 

[Alan]

You need to be little more specific about what you your goal is and what
you are trying to achieve,
Regards,
Alan.

 

[Fred Smith]

My first question is why doesn't the accounting software do the
reconciliation. That would be much more efficient.

However, if the only choice is to do it in Excel, you will need to sum the
outstanding checks and deposits, then deduct this from the register balance.
This should give you the bank balance.

First, create a column where it can be indicated whether the transaction has
cleared the bank (like 'R'). Then your bank balance formula is:

=RegisterBalance + Sumif (checks not 'r') - sumif(deposits not 'r')

Hope this helps,
Fred.