How do you prepare a bank reconciliation?

What format should i use?

MaggieMouse

There is no set format as long as you get it done. You just need to put bank and book on separate sides, left and right or top and bottom.

delite

easiest software is excel spreadsheet. start with opening balance; add all deposits for month, less all withdrawals and paid checks.any checks not on statement add back to balance, conversely any deposits not on statement delete. after tallying plus and minuses ,net is derived to get ending balance.From the prior month any checks appearing currently and not recorded in prior month reduce ending balance for current month; and any deposits not recorded previously, add to current month's total