rekon

https://img.shields.io/pypi/v/rekon.svg https://img.shields.io/travis/rjdscott/rekon.svg Documentation Status

rekon provides a suite of reconciliation tools for operations and finance

How to use this library

Set-up virtualenv and import rekon

$ pip install --user virtualenv
$ virtualenv .env
$ pip install rekon

Reconciliation inputs:

# import rekon library
from rekon import rekon

# instantiate an reconciliation instance
rec = rekon.Reconciliation()

# load sample data from package
rec.load_sample_data()

# run reconciliation on first column in col mapping and use sqlite db in memory
rec.reconcile(rec_col=1, sqlite_db=":memory:")

# view results (in pretty format)
rec.rec_results_pretty

# to output results to a zip and open file location
rec.output_report(output_dir='~/Desktop/EXAMPLE_OUTPUT',
                  file_name='rec-file',
                  output_format='zip',
                  open_file=True)

# to output results to a spreadsheet (i.e. 'xlsx') and open file location
rec.output_report(output_dir='~/Desktop/EXAMPLE_OUTPUT',
                  file_name='rec-file',
                  output_format='xlsx',
                  open_file=True)