Changeset - 3bff7845d55d
[Not reviewed]
0 1 0
Ben Sturmfels (bsturmfels) - 2 years ago 2022-02-09 03:05:09
ben@sturm.com.au
reconcile: Fix usage example.
1 file changed with 1 insertions and 1 deletions:
0 comments (0 inline, 0 general)
conservancy_beancount/reconcile/prototype_amex_reconciler.py
Show inline comments
 
"""Reconcile an AMEX CSV statement against the books and print differences.
 

	
 
Run like this:
 

	
 
$ python3 -m pip install thefuzz
 
$ python3 conservancy_beancount/reconcile/prototype_amex_reconciler.py \
 
  --beancount-file=$HOME/conservancy/beancount/books/2021.beancount \
 
  --csv-statement=$HOME/conservancy/confidential/2021-09-10_AMEX_activity.csv \
 
  --account=amex
 
  --account=Liabilities:CreditCard:AMEX
 

	
 
Conservancy currently enter data by hand rather than using Beancount importers.
 
This tool is still somewhat like an importer in that it needs to extract
 
transaction details from a third-party statement. Instead of creating
 
directives, it just checks to see that similar directives are already present.
 

	
 
Problems this attempts to address:
 
 - errors in the books take hours to find during reconciliation ("you're entering a world of pain")
 
 - adding statement/reconciliation metadata to books is manual and prone to mistakes
 
 - paper checks are entered in the books when written, but may not be cashed until months later (reconcile errors)
 
 - balance checks are manually updated in svn/Financial/Ledger/sanity-check-balances.yaml
 
 - creating reconciliation reports
0 comments (0 inline, 0 general)