Reconciling bank statments

**Excel Eejit** · 01-25-2009, 03:16 PM

Hello

I should very grateful if someone would help with an excel problem.

I need to be able to reconcile my cashbook with bank statments. On the spreadsheet I have attached I would like to enter a formula on the reconciliation tab in cell B7 which would calculate the following:

Take the start balance in B3 take away the expenditure that has cleared in January from the expenditure tab and add the income that has cleared in January in the income tab.

This is far more complex than anything I have ever needed to do and would be glad for any help.

Many thanks
EE

**shg** · 01-25-2009, 03:50 PM

Welcome to the forum.

This could certainly be done in Excel, but I have to ask: Why not just use Quicken, which does a lot more? At $40, it costs a fraction of the effort to recreate a tiny fraction of its functionality, and is brain-dead simple to use.