Reconciling a bank statement

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

Is there an easey was to reconcile a bank statment that I
have on a spreadsheet to a spreadsheet of outstanding
checks? can any one help I now a little about excel
Thankyou
Jeff
 
One idea:
You might find justwhat you need/want by searching
google or yahoo or altavista for "Excel Template Bank
Statement"

Or, set up a spreadsheet like your checkbook then when
your checks clear, put an "x" in the column to the right
of the check amount-- then with an "if" statement, have
the spreadsheet list only the checks with no "x" in the
column and these are your outstanding checks.
If you have ATM transactions and automatic drafts, it gets
more complicated.

Hope this helps

For a complicated bank statement, reconcile the Deposits
and the payments (Bank statement --> Checkbook) and this
helps point out where the differences are (last months
outstanding checks are payments on this months' bank
statement but not on this months' check boook payments)
 
Back
Top