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 | Account | Description | Type | Detail Type | Active |
|---|---|---|---|---|---|---|
| 58 | 59 | 5100 | Inbound Freight - COGS | Cost of Goods Sold | Shipping, Freight & Delivery - COS | Yes |
| 59 | 60 | 5150 | Packaging Materials | Cost of Goods Sold | Supplies & Materials - COGS | Yes |
| 60 | 61 | 5200 | Spoilage & Shrink |
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 |
|---|---|---|---|---|---|
| Account | 0 | 127 | 4 | integer 127 | 0 |
| Description | 0 | 127 | 38 | — | 0 |
| Type | 0 | 15 | 23 | — | 0 |
| Detail Type | 0 | 67 | 38 |
| Cost of Goods Sold |
| Other Costs of Services - COS |
| Yes |
| 61 | 62 | 5300 | Co-Packing Fees | Cost of Goods Sold | Other Costs of Services - COS | Yes |
|---|
| 62 | 63 | 6000 | Advertising & Marketing | Expense | Advertising/Promotional | Yes |
|---|
| 63 | 64 | 6010 | Trade Shows | Expense | Advertising/Promotional | Yes |
|---|
| 64 | 65 | 6020 | Website | Expense | Advertising/Promotional | Yes |
|---|
| 65 | 66 | 6030 | Meals & Entertainment | Expense | Entertainment Meals | Yes |
|---|
| 66 | 67 | 6040 | Travel | Expense | Travel | Yes |
|---|
| 67 | 68 | 6050 | Donations | Expense | Charitable Contributions | Yes |
|---|
| 68 | 69 | 6060 | Licenses & Permits | Expense | Taxes Paid | Yes |
|---|
| 69 | 70 | 6070 | Property Taxes | Expense | Taxes Paid | Yes |
|---|
| 70 | 71 | 6080 | Business Taxes | Expense | Taxes Paid | Yes |
|---|
| 71 | 72 | 6090 | Recruiting | Expense | Other Business Expenses | Yes |
|---|
| 72 | 73 | 6100 | Wages - Warehouse | Expense | Payroll Expenses | Yes |
|---|
| 73 | 74 | 6105 | Wages - Drivers | Expense | Payroll Expenses | Yes |
|---|
| 74 | 75 | 6110 | Wages - Office | Expense | Payroll Expenses | Yes |
|---|
| 75 | 76 | 6120 | Payroll Taxes | Expense | Payroll Expenses | Yes |
|---|
| 76 | 77 | 6130 | Employee Benefits | Expense | Payroll Expenses | Yes |
|---|
| 77 | 78 | 6140 | Workers Compensation | Expense | Insurance | Yes |
|---|
| 78 | 79 | 6150 | Sales Commissions | Expense | Payroll Expenses | Yes |
|---|
| 79 | 80 | 6160 | Temporary Labor | Expense | Payroll Expenses | Yes |
|---|
| 80 | 81 | 6170 | Training | Expense | Other Business Expenses | Yes |
|---|
| 81 | 82 | 6180 | Employee Relations | Expense | Other Business Expenses | Yes |
|---|
| 82 | 83 | 6190 | Payroll Processing Fees | Expense | Other Business Expenses | Yes |
|---|
| 83 | 84 | 6200 | Utilities - Electric | Expense | Utilities | Yes |
|---|
| 84 | 85 | 6210 | Utilities - Water & Sewer | Expense | Utilities | Yes |
|---|
| 85 | 86 | 6220 | Telephone & Internet | Expense | Utilities | Yes |
|---|
| 86 | 87 | 6230 | Utilities - Gas | Expense | Utilities | Yes |
|---|
| 87 | 88 | 6240 | Waste Removal | Expense | Utilities | Yes |
|---|
| 88 | 89 | 6300 | Rent - Portland Warehouse | Expense | Rent or Lease of Buildings | Yes |
|---|
| 89 | 90 | 6310 | Rent - Seattle Warehouse | Expense | Rent or Lease of Buildings | Yes |
|---|
| 90 | 91 | 6320 | Rent - Boise Warehouse | Expense | Rent or Lease of Buildings | Yes |
|---|
| 91 | 92 | 6330 | Third-Party Storage | Expense | Rent or Lease of Buildings | Yes |
|---|
| 92 | 93 | 6400 | Freight-In | Expense | Shipping, Freight & Delivery | Yes |
|---|
| 93 | 94 | 6410 | Freight Rebates | Expense | Shipping, Freight & Delivery | Yes |
|---|
| 94 | 95 | 6420 | Delivery Fuel | Expense | Auto | Yes |
|---|
| 95 | 96 | 6430 | Vehicle Repairs & Maintenance | Expense | Auto | Yes |
|---|
| 96 | 97 | 6440 | Tolls & Parking | Expense | Auto | Yes |
|---|
| 97 | 98 | 6450 | Vehicle Registration | Expense | Auto | Yes |
|---|
| 98 | 99 | 6460 | Vehicle Leases | Expense | Auto | Yes |
|---|
| 99 | 100 | 6500 | Insurance - General | Expense | Insurance | Yes |
|---|
| 100 | 101 | 6510 | Insurance - Vehicles | Expense | Insurance | Yes |
|---|
| 101 | 102 | 6520 | Insurance - Product Liability | Expense | Insurance | Yes |
|---|
| 102 | 103 | 6600 | Repairs - Refrigeration & Equipment | Expense | Repair & Maintenance | Yes |
|---|
| 103 | 104 | 6610 | Forklift Lease | Expense | Equipment Rental | Yes |
|---|
| 104 | 105 | 6620 | Building Repairs | Expense | Repair & Maintenance | Yes |
|---|
| 105 | 106 | 6630 | Small Tools & Equipment | Expense | Supplies | Yes |
|---|
| 106 | 107 | 6700 | Depreciation Expense | Expense | Depreciation | Yes |
|---|
| 107 | 108 | 6710 | Amortization Expense | Expense | Amortization | Yes |
|---|
Showing 58–107 of 127 rows
| — |
| 0 |
| Active | 0 | 1 | 3 | — | 0 |
|---|