Hi angela
Try this:
Column A =Date
Column B=Description
Column C=Deposits
Column D=Withdrawals
Column E= Balance

In my example put a starting balance in E8, say 0
In E9 put the following formula and copy down as far as needed.
=IF(B9="","",IF(C90,E8+C9,IF(D90,E8-D9,E8)))

When the user puts something in the decription column and either a deposit
or withdrawal it will adjust the balance accordingly
This is about as simple as it gets !!

HTH
Michael


"angela" wrote:

Yes, but I'm just not sure how to build this spreadsheet for helping the
users reconcile the amounts. Suggestions?
--
angela


"JMB" wrote:

There is, and it is (ironically) called SUM. Check Excels help for details
on how to use.

"angela" wrote:

Hi Community~

I need to create a spreadsheet to help non-technical users to reconcile
expenses (checks) and revenue to a general ledger account. Simple for me as
an accountant but I'm struggling on how to make it EASY for users who aren't
accountants and don't know Excel. Is there a SUM function or anything else I
could build in the sheet?

Simple spreadsheet is:
Date Description (ck# perhaps) Expense$ (Debit) Income$(Credit)

Users need to reconcile this spreadsheet to a specific general ledger
account and they should be identical. If not, they research discrepancies.

Any suggestions would be appreciated!
--
angela