Commit graph

649 commits

Author SHA1 Message Date
5a8da108b9
statement_reconciler: Add initial Chase bank CSV statement matching
We currently don't have many examples to work with, so haven't done any
significant testing of the matching accuracy between statement and books.
2024-07-19 15:57:07 +10:00
bd07154fbb
statement_reconciler: Fix example usage docs 2024-07-19 15:52:57 +10:00
1473d24d6e
statement_reconciler: Improve the path matching to handle relative paths and symlinks 2024-07-19 15:52:19 +10:00
9129a4af6a
Pin to Beancount v2
Beancount v3 has been recently released. It's a major rewrite and is currently
unstable and not compatible with this codebase. We need to remain on v2.
2024-07-18 21:49:54 +10:00
52ea12d4cf
statement_reconciler: switch to generator expression 2024-07-18 21:49:08 +10:00
45bc99e9ac
Add colorama dependency
Used by statement reconciler.
2024-07-18 21:48:28 +10:00
Bradley M. Kuhn
5784068904 payroll-type — US:403b:Employee:Roth — needed separate since taxable
Since Roth contributions are taxable, there are some reports that
need to include these amounts in total salary (i.e., when running a
report that seeks to show total taxable income for an employee).  As
such, we need a `payroll-type` specifically for Roth 403(b)
contributions.
2023-12-23 10:40:07 -08:00
Bradley M. Kuhn
6deaacb11b Add US:TN:Unemployment as a valid payroll-type metadata for taxes 2023-12-21 21:12:36 -08:00
Bradley M. Kuhn
1a0ccd39b0 Add tax-implication metadata type of Asset-Sale
This will be used for sale of stocks, for example.
2023-12-19 17:57:34 -08:00
9a0ff8da96
Remove unused import 2023-05-02 14:32:53 +10:00
Rosanne Dimesio
2840a64215
Add new payroll type codes
Oregon added a new payroll tax for disability so we need to add the
payroll-types for Ohio's state and local taxes.
2023-05-02 14:32:03 +10:00
5793a55dbc
reconciler: Fix reconciler lumping unmatched books items together (#20737)
Issue was that the subset matching was passing through the grouped transactions
rather than the original transactions when it failed to match.
2023-02-11 18:54:52 +11:00
86f4232df1
reconciler: Move other score thresholds to constants 2023-02-11 18:30:22 +11:00
baa299c4c5
reconciler: Apply black -S -l 90 2023-02-11 16:04:00 +11:00
8b08997fda
reconciler: Add --full-months option to round statement dates to month boundaries 2023-02-11 16:00:21 +11:00
07d7737bd0
reconciler: Format BQL query 2023-02-11 15:25:44 +11:00
e764f3d0ef
reconcile: Factor out the output formatting 2023-02-11 15:23:15 +11:00
a4bba120eb
reconlicer: Move match thresholds to top of module 2023-02-11 14:53:30 +11:00
93d102539a
reconciler: Re-wrap module docstring at 80 chars 2023-02-11 14:51:13 +11:00
3acc097d32 reconcile: Update to support standard FR CSV format
It seems as though we were previously using a transaction search export CSV,
rather than the official statement CSV.
2023-01-30 23:21:42 +11:00
0968f7f051
reconciler: Handle comma separators in some FR statements 2023-01-13 13:58:36 +11:00
82ec68962a
Use typing.List for compatibility with Python 3.6 2023-01-12 14:09:05 +11:00
71bf8137a5
reconcile.helper: Add entry_point to avoid traceback 2023-01-11 19:36:43 +11:00
026f54bca1
reconcile.helper: Check file specified with --beancount-file exists 2023-01-11 19:36:43 +11:00
7f7f325f73
reconcile.helper: Appease code linter 2023-01-11 19:36:42 +11:00
9be7fdd95f
reconcile.helper: Avoid rt >= 3.0 library due to breaking changes
Error relates to rt.Rt not existing.
2023-01-11 19:36:42 +11:00
Bradley M. Kuhn
c0f83dfda8 payroll_type — Expenses:Payroll:Tax — CA:WCB 2022-03-05 16:08:07 -08:00
581ef0fa23
reconcile: Update docs, move a few things around. 2022-03-03 10:55:09 +11:00
97a05003f3
reconcile: Fix linter warnings. 2022-03-03 09:36:33 +11:00
da5caa3e6c
reconcile: Remove totals, highlight payee mismatches orange. 2022-03-02 18:26:19 +11:00
519542b1fa
reconcile: Add entrypoints for statement reconciler and helper. 2022-03-02 18:26:19 +11:00
20d242c7c7
reconcile: Fix a mutation bug causing not all matches to be passed through. 2022-03-02 18:26:10 +11:00
fb5d0a57f3
reconcile: CLI entrypoint, improve docs. 2022-03-02 10:05:07 +11:00
59dfbb78d1
reconcile: Add prototype CSV reconciliation report. 2022-03-01 23:09:50 +11:00
54d11f2437
reconcile: Add further typing info; update tests. 2022-02-24 22:43:37 +11:00
9ae36feed2
reconciler: Remove debug warning. 2022-02-24 21:11:02 +11:00
72385fd0bd
reconcile: Quote metadata, fix hiding of matched + reconciled lines. 2022-02-24 20:58:04 +11:00
7c5e98c588
reconcile: Simplify multirecord sorting. 2022-02-23 17:34:52 +11:00
405dd553cb
reconcile: Implement "subset sum" feature matching multiple books entries to a single statement entry. 2022-02-23 17:25:02 +11:00
965aeabde9
reconcile: Update tests with renamed module. 2022-02-23 09:58:53 +11:00
e1edffda9a
reconcile: Fix usage docs. 2022-02-23 08:21:06 +11:00
80dace59b3
reconcile: Rename statement reconciler. 2022-02-23 08:18:52 +11:00
517d4027b4
reconcile: Explicitly avoid payee matching when check-id provided in books. 2022-02-21 22:43:22 +11:00
c9dd9ffb28
reconciler: Fix totals. Never consider payee if check_id in books. 2022-02-21 22:22:42 +11:00
3377918279
reconcile: Make bank-statement path relative to $CONSERVANCY_BEANCOUNT.
Also add CSV metadata.
2022-02-21 18:31:07 +11:00
a3e60c639f
reconcile: Add special case for payee first word match. 2022-02-21 12:16:24 +11:00
32fc4517a0
reconcile: show check number, remove duplicate words in payee. 2022-02-19 00:27:48 +11:00
d8f4eac53b
reconcile: Improve reconciler matching and add test cases. 2022-02-18 20:36:11 +11:00
6d7df795cb
reconcile: Move code into functions, add totals. 2022-02-10 22:02:08 +11:00
4bb6177e45
reconcile: Update cleared query. 2022-02-10 10:23:00 +11:00