Reconcile Checkbook

 

Reconcile Checkbook Application

the information you enter here runs only on your browser on your machine, no data is transmitted to a server unless you use bookmark URL button, then it submits to same page (nothing active on server side) and builds a URL. you should be able to save it and double-click on it to use it.

The debugging stuff like /2 is handy when there are duplicate entries somewhere, and it's near to the last item you have left (have not found a use for *2, forgot if there was a use for it). this may find them if it's the last or near-to-last item and can get you closer to the result you want, such as if something is off by $50 or $21.33.

bold items are formulas. duplicate items can be found with /2 if it's last item left. for instance, for 1-2 outstanding items, this can get you nearer to a good result. a positive adj-by means the bank has erred in your favor, or you have to adjust by putting the adj amoutn in that column.

Finally got it to work in both Firefox and IE. Don't know if you can print your results, but you probably can, it's basically a table. You might want to print in landscape mode. if you refresh (hit F5 or ctrl-F5), the page will reset (lose its rows).




Real Balance= (money you have left, after allocating money for outstanding/Unposted items)
Pmt Adj=, Dep Adj=
Pmt Adj/2=, Dep Adj/2=
Pmt Adj*2=, Dep Adj/2=
@

Outstanding/Unposted Debits and Credits
  Pmt Tot.: Dep Tot.:            
             
item# Wdl/Debit/Pmt Dep/Credit Date Check# Description Delete Delete Insert

Download Now
reconcile-example.xlsx - Excel checkbook reconciliation spreadsheet (updated 7/12/2017, 183KB)

Download Now
reconcile-example.xls - Excel checkbook reconciliation spreadsheet (updated 7/12/2017, 183KB)

Download Now
reconcile-example.xml - Excel checkbook reconciliation spreadsheet (updated 7/12/2017, 183KB)

Download Now
reconcile-example.ods - Apache OpenOffice.org checkbook reconciliation spreadsheet (updated 7/12/2017, 39KB)


page updated 9/12/2016