Brightwater Provisions, Inc.
LedgerPro to new ERP
- Cutover
- Go-live
- Books
- USD
Loading this view
Public demoView-only · fictional data
Brightwater Provisions, Inc.
LedgerPro to new ERP
The file exactly as the legacy system exported it. Rows are stored once and never edited, so this is the evidence every canonical record and every finding traces back to.
Values are shown verbatim, including the whitespace and formatting the export contained.
| Row | Lines | Legacy Account | Legacy Description | Target Account | Target Description |
|---|---|---|---|---|---|
| 101 | 102 | 6520 | Insurance - Product Liability | 6500 | Insurance |
| 102 | 103 | 6600 | Repairs - Refrigeration & Equipment | 6600 | Repairs & Maintenance |
| 103 | 104 | 6610 | Forklift Lease | 6610 |
Lines the reader could not turn into a row. They are kept verbatim and excluded from every result, so anything here is missing from the migration.
What the reader observed per column, used to suggest a column mapping and to flag ambiguous dates.
| Column | Blank | Distinct | Max length | Patterns | Ambiguous dates |
|---|---|---|---|---|---|
| Legacy Account | 0 | 127 | 4 | integer 127 | 0 |
| Legacy Description | 0 | 127 | 38 | — | 0 |
| Target Account | 0 | 54 | 4 | integer 127 | 0 |
| Target Description | 0 |
| Equipment Leases |
| 104 | 105 | 6620 | Building Repairs | 6300 | Rent & Occupancy |
|---|
| 105 | 106 | 6630 | Small Tools & Equipment | 6600 | Repairs & Maintenance |
|---|
| 106 | 107 | 6700 | Depreciation Expense | 6700 | Depreciation & Amortization |
|---|
| 107 | 108 | 6710 | Amortization Expense | 6700 | Depreciation & Amortization |
|---|
| 108 | 109 | 6800 | Bad Debt Expense | 6800 | Bad Debt |
|---|
| 109 | 110 | 6810 | Collection Fees | 6800 | Bad Debt |
|---|
| 110 | 111 | 6900 | Office Supplies | 6900 | Office & Administrative |
|---|
| 111 | 112 | 6910 | Postage & Delivery | 6900 | Office & Administrative |
|---|
| 112 | 113 | 6920 | Bank Service Charges | 6920 | Bank & Merchant Fees |
|---|
| 113 | 114 | 6925 | Merchant Fees | 6920 | Bank & Merchant Fees |
|---|
| 114 | 115 | 6930 | Dues & Subscriptions | 6900 | Office & Administrative |
|---|
| 115 | 116 | 6935 | Software Subscriptions | 6960 | Software & IT |
|---|
| 116 | 117 | 6940 | Accounting Fees | 6940 | Professional Services |
|---|
| 117 | 118 | 6945 | Consulting Fees | 6940 | Professional Services |
|---|
| 118 | 119 | 6950 | Legal Fees | 6940 | Professional Services |
|---|
| 119 | 120 | 6960 | IT Services | 6960 | Software & IT |
|---|
| 120 | 121 | 6970 | Janitorial | 6970 | Facilities Services |
|---|
| 121 | 122 | 6980 | Pest Control | 6970 | Facilities Services |
|---|
| 122 | 123 | 6990 | Uniforms & Laundry | 6970 | Facilities Services |
|---|
| 123 | 124 | 7100 | Foreign Exchange Gain/Loss | 7100 | Foreign Exchange Gain/Loss |
|---|
| 124 | 125 | 7200 | Interest Expense | 7200 | Interest Expense |
|---|
| 125 | 126 | 7300 | Interest Income | 4100 | Other Revenue |
|---|
| 126 | 127 | 7400 | Gain/Loss on Asset Disposal | 7300 | Other Income & Expense |
|---|
| 127 | 128 | 7900 | Other Expense | 7300 | Other Income & Expense |
|---|
Showing 101–127 of 127 rows
| 54 |
| 36 |
| — |
| 0 |