a simple command line tool for reconciling two sets of financial data.
python setup.py install
In the following example, I reconcile my credit card statement with my bank statement. You'll notice that sometimes money settles out of order or is batched.
Input data:
Left: Right:
$138,831.25 $116,096.01
$149,066.73 $143,409.75
$269,099.84 $149,066.73
$143,409.75 $269,099.84
$116,096.01 $252,897.59
$125,499.93 $125,499.93
$127,700.74 $127,700.74
$252,897.59 $162,988.06
$162,988.06 $144,852.92
$144,852.92 $255,859.17
$182,512.97 $828,120.40
$144,047.30 $571,593.77
$145,067.95
$190,242.65
$331,703.13
$161,106.67
$313,562.43
$258,031.34
Command:
recontool left.csv right.csv
Output:
1: $ 138,831.25 : $ 0.00
--------------------------------------------------------------------------------
$ 138,831.25 $ 0.00
================================================================================
2: $ 149,066.73 1: $ 116,096.01
3: $ 269,099.84 2: $ 143,409.75
4: $ 143,409.75 3: $ 149,066.73
5: $ 116,096.01 4: $ 269,099.84
6: $ 125,499.93 5: $ 252,897.59
7: $ 127,700.74 6: $ 125,499.93
8: $ 252,897.59 7: $ 127,700.74
9: $ 162,988.06 8: $ 162,988.06
10: $ 144,852.92 9: $ 144,852.92
--------------------------------------------------------------------------------
$ 1,491,611.57 $ 1,491,611.57
================================================================================
11: $ 182,512.97 10: $ 255,859.17
12: $ 144,047.30 : $ 0.00
--------------------------------------------------------------------------------
$ 326,560.27 $ 255,859.17
================================================================================
13: $ 145,067.95 11: $ 828,120.40
14: $ 190,242.65 12: $ 571,593.77
15: $ 331,703.13 : $ 0.00
16: $ 161,106.67 : $ 0.00
17: $ 313,562.43 : $ 0.00
18: $ 258,031.34 : $ 0.00
--------------------------------------------------------------------------------
$ 1,399,714.17 $ 1,399,714.17
================================================================================
python setup.py develop
python setup.py test