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 |
|---|---|---|---|---|---|
| 51 | 52 | 4400 | Miscellaneous Income | 4100 | Other Revenue |
| 52 | 53 | 4900 | Sales Discounts | 4900 | Contra Revenue |
| 53 | 54 | 4950 | Returns & Allowances | 4900 | Contra Revenue |
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 |
| 54 | 55 | 5000 | Cost of Goods Sold | 5000 | Cost of Goods Sold |
|---|
| 55 | 56 | 5010 | Inventory Adjustments | 5000 | Cost of Goods Sold |
|---|
| 56 | 57 | 5020 | Purchase Price Variance | 5000 | Cost of Goods Sold |
|---|
| 57 | 58 | 5030 | Samples & Demos | 5000 | Cost of Goods Sold |
|---|
| 58 | 59 | 5100 | Inbound Freight - COGS | 5100 | Freight & Fulfillment |
|---|
| 59 | 60 | 5150 | Packaging Materials | 5150 | Packaging |
|---|
| 60 | 61 | 5200 | Spoilage & Shrink | 5000 | Cost of Goods Sold |
|---|
| 61 | 62 | 5300 | Co-Packing Fees | 5100 | Freight & Fulfillment |
|---|
| 62 | 63 | 6000 | Advertising & Marketing | 6000 | Marketing |
|---|
| 63 | 64 | 6010 | Trade Shows | 6000 | Marketing |
|---|
| 64 | 65 | 6020 | Website | 6000 | Marketing |
|---|
| 65 | 66 | 6030 | Meals & Entertainment | 6900 | Office & Administrative |
|---|
| 66 | 67 | 6040 | Travel | 6900 | Office & Administrative |
|---|
| 67 | 68 | 6050 | Donations | 6900 | Office & Administrative |
|---|
| 68 | 69 | 6060 | Licenses & Permits | 6980 | Taxes & Licenses |
|---|
| 69 | 70 | 6070 | Property Taxes | 6980 | Taxes & Licenses |
|---|
| 70 | 71 | 6080 | Business Taxes | 6980 | Taxes & Licenses |
|---|
| 71 | 72 | 6090 | Recruiting | 6190 | Other Personnel Costs |
|---|
| 72 | 73 | 6100 | Wages - Warehouse | 6100 | Salaries & Wages |
|---|
| 73 | 74 | 6105 | Wages - Drivers | 6100 | Salaries & Wages |
|---|
| 74 | 75 | 6110 | Wages - Office | 6100 | Salaries & Wages |
|---|
| 75 | 76 | 6120 | Payroll Taxes | 6120 | Payroll Taxes & Benefits |
|---|
| 76 | 77 | 6130 | Employee Benefits | 6120 | Payroll Taxes & Benefits |
|---|
| 77 | 78 | 6140 | Workers Compensation | 6120 | Payroll Taxes & Benefits |
|---|
| 78 | 79 | 6150 | Sales Commissions | 6150 | Commissions |
|---|
| 79 | 80 | 6160 | Temporary Labor | 6100 | Salaries & Wages |
|---|
| 80 | 81 | 6170 | Training | 6190 | Other Personnel Costs |
|---|
| 81 | 82 | 6180 | Employee Relations | 6190 | Other Personnel Costs |
|---|
| 82 | 83 | 6190 | Payroll Processing Fees | 6190 | Other Personnel Costs |
|---|
| 83 | 84 | 6200 | Utilities - Electric | 6200 | Utilities |
|---|
| 84 | 85 | 6210 | Utilities - Water & Sewer | 6200 | Utilities |
|---|
| 85 | 86 | 6220 | Telephone & Internet | 6220 | Telecommunications |
|---|
| 86 | 87 | 6230 | Utilities - Gas | 6200 | Utilities |
|---|
| 87 | 88 | 6240 | Waste Removal | 6200 | Utilities |
|---|
| 88 | 89 | 6300 | Rent - Portland Warehouse | 6300 | Rent & Occupancy |
|---|
| 89 | 90 | 6310 | Rent - Seattle Warehouse | 6300 | Rent & Occupancy |
|---|
| 90 | 91 | 6320 | Rent - Boise Warehouse | 6300 | Rent & Occupancy |
|---|
| 91 | 92 | 6330 | Third-Party Storage | 6300 | Rent & Occupancy |
|---|
| 92 | 93 | 6400 | Freight-In | 5100 | Freight & Fulfillment |
|---|
| 93 | 94 | 6410 | Freight Rebates | 5100 | Freight & Fulfillment |
|---|
| 94 | 95 | 6420 | Delivery Fuel | 6420 | Vehicle & Delivery |
|---|
| 95 | 96 | 6430 | Vehicle Repairs & Maintenance | 6420 | Vehicle & Delivery |
|---|
| 96 | 97 | 6440 | Tolls & Parking | 6420 | Vehicle & Delivery |
|---|
| 97 | 98 | 6450 | Vehicle Registration | 6420 | Vehicle & Delivery |
|---|
| 98 | 99 | 6460 | Vehicle Leases | 6420 | Vehicle & Delivery |
|---|
| 99 | 100 | 6500 | Insurance - General | 6500 | Insurance |
|---|
| 100 | 101 | 6510 | Insurance - Vehicles | 6500 | Insurance |
|---|
Showing 51–100 of 127 rows
| 54 |
| 36 |
| — |
| 0 |