- auditors would prefer Bradley didn't perform reconciliation, ideally not Rosanne either

 - transactions are entered manually and reconciled after the fact, but importing from statements may be useful in some cases

Q. How are reconciliation reports created currently? How do you read them?

 - by hand from copying and pasting from the helper tool output

TODO/ISSUES:

 - AMEX statement doesn't provide bank balance or running total

"""

import argparse

import csv

#

# beancount.query.query_compile.compile() and

# beancount.query.query_execute.filter_entries() look useful in this respect,

# but I'm not clear on how to use compile(). An example would help.

entries, _, options = loader.load_file(args.beancount_file)

    AND date <= {end_date.isoformat()} AND META('bank-statement') != NULL"""

result_types, result_rows = run_query(

    entries,

    options,

    numberify=True,

)

cleared_total = result_rows[0][0]

# String concatenation looks bad, but there's no SQL injection possible here

# because BQL can't write back to the Beancount files. I hope!

query = f"SELECT filename, META('lineno') AS posting_line, META('bank-statement') AS posting_statement, date, number(cost(position)), payee, narration where account = '{args.account}' and date >= {begin_date} and date <= {end_date}"

result_types, result_rows = run_query(