Data Checks¶
The check command is provided to validate exported data while the
reconcile command is provided to ensure different sets of exported data are consistent with
each other.
Data Validation¶
You can check the integrity of your exported data to ensure it’s complete and consistent. If any issues are found, you’ll see detailed error messages showing exactly what’s wrong.
Validate journal entries:
xerotrust check journals */journals-*.jsonl
xerotrust check journals *\journals-*.jsonl
This checks for:
Duplicate journal IDs
Duplicate journal numbers
Missing journal numbers in sequence
Validate bank transactions:
xerotrust check transactions */transactions-*.jsonl
xerotrust check transactions *\transactions-*.jsonl
This checks for:
Duplicate transaction IDs
Data Reconciliation¶
Compare data between different sources to verify consistency.
Basic reconciliation:
xerotrust reconcile journals=*/journals-*.jsonl transactions=*/transactions-*.jsonl
xerotrust reconcile journals=*\journals-*.jsonl transactions=*\transactions-*.jsonl
This compares account totals between journal entries and bank transactions, showing any discrepancies in a clear table format.
Stop on first difference:
xerotrust reconcile --stop-on-diff journals=*/journals-*.jsonl transactions=*/transactions-*.jsonl
xerotrust reconcile --stop-on-diff journals=*\journals-*.jsonl transactions=*\transactions-*.jsonl
This stops on the first date where differences are found. It’s useful for digging into differences if they do occur.
Compare different exports:
xerotrust reconcile journals=old-export/journals-*.jsonl journals=new-export/journals-*.jsonl
xerotrust reconcile journals=old-export\journals-*.jsonl journals=new-export\journals-*.jsonl