CR-1: Column mapping for ledgerpro_chart_of_accounts.csv

Column mapping set proposed by Maya Chen.

applied

Financial data is never changed silently

Relay detects and investigates problems on its own, but it does not correct them on its own. A correction is proposed with evidence, approved by someone other than the person who proposed it, applied in a single transaction with its audit event, and then re-checked by a fresh deterministic run. The steps below say where this one stands.

Done
1. Proposed with evidence
Maya Chen submitted 2026-09-22 05:11:28Z
Done
2. Approved by other people
1 of 1 required approvals recorded
Done
3. Applied in one transaction
2026-09-22 05:11:28Z
Done
4. Re-verified by a fresh run
Deterministic checks re-ran on the new inputs

Requested by: Maya Chen
Origin: Proposed by an operator
Submitted: 2026-09-22 05:11:28Z
Applied: 2026-09-22 05:11:28Z

Justification

The reason of record. It is written into the audit trail when the change is submitted, and cannot be edited afterwards.

Mapping reviewed against the export header and sample rows.

What would change

Changes how the columns of one legacy export are read into canonical fields. The file itself is immutable: it is simply re-read under the new mapping.

Relay check result

ledgerpro_chart_of_accounts.csv: approved version — → 1; 4 fields change.

Before and after
Field	Before	After
account_code	—	{"steps":[{"step":"trim"}],"source":"Account"}
is_active	—	{"steps":[{"step":"trim"},{"step":"parse_boolean","true":["Yes"],"false":["No"]}],"source":"Active"}
name	—	{"steps":[{"step":"trim"}],"source":"Description"}

Approvals

Each role below has to be satisfied by a different person, and never by the requester. Segregation of duties is enforced by the API, not by hiding buttons.

approvedImplementation lead — Daniel Okafor

approvedDaniel Okafor(Implementation lead)2026-09-22 05:11:28Z— Approved.

Review is closed: this change request is applied

Decisions are final once recorded. A different outcome needs a new change request, which goes through the same approvals.

Reported by the API as: the change request is applied.

Verification after applying

Applying a change does not decide anything by itself. A fresh pipeline run re-ran every deterministic validation and reconciliation over the new inputs, and those results are what the readiness gates read.

Run requested by this change 01a0c786

History

Every step above as it was written to the hash-chained audit log.

2026-09-22 05:11:28ZChange request drafted
2026-09-22 05:11:28ZChange request submittedMapping reviewed against the export header and sample rows.
2026-09-22 05:11:28ZChange request approval recordedApproved.
2026-09-22 05:11:28ZChange request approved
2026-09-22 05:11:28ZMapping set approved
2026-09-22 05:11:28ZChange request applied
2026-09-22 05:11:29Z

{"steps":[{"step":"trim"},{"step":"value_map","mapping":{"Auto":"operating_expense","Travel":"operating_expense","Savings":"cash","Checking":"cash","Supplies":"operating_expense","Vehicles":"fixed_asset","Bad Debts":"operating_expense","Insurance":"operating_expense","Inventory":"inventory","Utilities":"operating_expense","Taxes Paid":"operating_expense","Credit Card":"accrued_liability","Amortization":"operating_expense","Bank Charges":"operating_expense","Cash on Hand":"cash","Common Stock":"common_stock","Depreciation":"operating_expense","Money Market":"cash","Interest Paid":"other_expense","Notes Payable":"long_term_debt","Line of Credit":"line_of_credit","Owner's Equity":"retained_earnings","Interest Earned":"other_income","Loans to Others":"other_current_asset","Deferred Revenue":"accrued_liability","Equipment Rental":"operating_expense","Payroll Expenses":"operating_expense","Prepaid Expenses":"prepaid","Intangible Assets":"fixed_asset","Retained Earnings":"retained_earnings","Sales Tax Payable":"accrued_liability","Security Deposits":"other_current_asset","Undeposited Funds":"cash","Service/Fee Income":"operating_revenue","Accrued Liabilities":"accrued_liability","Entertainment Meals":"operating_expense","Payroll Tax Payable":"payroll_liability","Dues & subscriptions":"operating_expense","Furniture & Fixtures":"fixed_asset","Other Current Assets":"other_current_asset","Repair & Maintenance":"operating_expense","Exchange Gain or Loss":"other_expense","Machinery & Equipment":"fixed_asset","Partner Distributions":"retained_earnings","Accounts Payable (A/P)":"accounts_payable","Employee Cash Advances":"other_current_asset","Leasehold Improvements":"fixed_asset","Advertising/Promotional":"operating_expense","Allowance for Bad Debts":"contra_asset","Discounts/Refunds Given":"operating_revenue","Other Business Expenses":"operating_expense","Sales of Product Income":"operating_revenue","Accumulated Amortization":"accumulated_depreciation","Accumulated Depreciation":"accumulated_depreciation","Charitable Contributions":"operating_expense","Accounts Receivable (A/R)":"accounts_receivable","Legal & Professional Fees":"operating_expense","Other Current Liabilities":"accrued_liability","Shareholder Notes Payable":"long_term_debt","Federal Income Tax Payable":"accrued_liability","Other Miscellaneous Income":"other_income","Paid-In Capital or Surplus":"common_stock","Rent or Lease of Buildings":"operating_expense","Other Miscellaneous Expense":"other_expense","Supplies & Materials - COGS":"cost_of_goods_sold","Shipping, Freight & Delivery":"operating_expense","Other Costs of Services - COS":"cost_of_goods_sold","Other Miscellaneous Service Cost":"operating_expense","Shipping, Freight & Delivery - COS":"cost_of_goods_sold","Office/General Administrative Expenses":"operating_expense"}}],"source":"Detail Type"}