NPO-Accounting/conservancy_beancount Changeset - 5d45171ed7c4

Changeset - 5d45171ed7c4

Parent rev.

Child rev.

[Not reviewed]

0 1 0

Ben Sturmfels (bsturmfels) - 3 years ago 2022-02-09 23:15:01
ben@sturm.com.au

reconcile: Add statement total and cleared total.

1 file changed with 17 insertions and 0 deletions:

conservancy_beancount/reconcile/prototype_amex_reconciler.py

0 comments (0 inline, 0 general)

conservancy_beancount/reconcile/prototype_amex_reconciler.py

➞

Show inline comments

@@ ... / @@ -28,4 +28,5 @@ Problems in scope: @@
 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:
@@ ... / @@ -111,6 +112,9 @@ parser.add_argument('--grep-output-filename') @@
 # parser.add_argument('--report-group-regex')
 parser.add_argument('--show-reconciled-matches', action='store_true')
 parser.add_argument('--statement-total', required=True)
 args = parser.parse_args()
 statement_total = decimal.Decimal(args.statement_total)
 # TODO: Should put in a sanity check to make sure the statement you're feeding
 # in matches the account you've provided.
@@ ... / @@ -136,4 +140,14 @@ end_date = statement_trans[-1]['date'] @@
 entries, _, options = loader.load_file(args.beancount_file)
 total_query = f"""SELECT sum(COST(position)) AS aa WHERE account = "{args.account}"
     AND date <= {end_date.isoformat()} AND META('bank-statement') != NULL"""
 result_types, result_rows = run_query(
     entries,
     options,
     total_query,
     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!
@@ ... / @@ -184,4 +198,7 @@ for _, output in sorted(matches): @@
     print(output)
 print('-' * 155)
 print(f'STATEMENT TOTAL: {statement_total}')
 print(f'CLEARED TOTAL:   {cleared_total:12,.2f}')
 print('-' * 155)
 # Write statement metadata back to books

0 comments (0 inline, 0 general)