- jumping to an individual transaction in a large ledger isn't trivial - Emacs grep mode is the current best option

 - Pam and other staff don't use Emacs

 - 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?

TODO/ISSUES:

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

"""

import argparse

parser.add_argument('--beancount-file', required=True)

parser.add_argument('--csv-statement', required=True)

parser.add_argument('--account', required=True, help='eg. Liabilities:CreditCard:AMEX')

parser.add_argument('--grep-output-filename')

# parser.add_argument('--report-group-regex')

parser.add_argument('--show-reconciled-matches', action='store_true')

args = parser.parse_args()

# TODO: Should put in a sanity check to make sure the statement you're feeding

# in matches the account you've provided.

if 'AMEX' in args.account:

    standardize_statement_record = standardize_amex_record

else:

    standardize_statement_record = standardize_fr_record

#

# 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)

# 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(

    entries,

    options,

print('-' * 155)

print(f'{"Statement transaction":<38}            {"Books transaction":<44}   Notes')

print('-' * 155)

for _, output in sorted(matches):

    print(output)

print('-' * 155)

# Write statement metadata back to books

if metadata_to_apply:

    print('Mark matched transactions as reconciled in the books? (y/N) ', end='')

    if input().lower() == 'y':

        files = {}