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 |
|---|---|---|---|---|---|---|
| 101 | 102 | 6520 | Insurance - Product Liability | Expense | Insurance | Yes |
| 102 | 103 | 6600 | Repairs - Refrigeration & Equipment | Expense | Repair & Maintenance | Yes |
| 103 | 104 | 6610 | Forklift Lease |
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 |
| 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 |
|---|
| 108 | 109 | 6800 | Bad Debt Expense | Expense | Bad Debts | Yes |
|---|
| 109 | 110 | 6810 | Collection Fees | Expense | Bad Debts | Yes |
|---|
| 110 | 111 | 6900 | Office Supplies | Expense | Office/General Administrative Expenses | Yes |
|---|
| 111 | 112 | 6910 | Postage & Delivery | Expense | Office/General Administrative Expenses | Yes |
|---|
| 112 | 113 | 6920 | Bank Service Charges | Expense | Bank Charges | Yes |
|---|
| 113 | 114 | 6925 | Merchant Fees | Expense | Bank Charges | Yes |
|---|
| 114 | 115 | 6930 | Dues & Subscriptions | Expense | Dues & subscriptions | Yes |
|---|
| 115 | 116 | 6935 | Software Subscriptions | Expense | Dues & subscriptions | Yes |
|---|
| 116 | 117 | 6940 | Accounting Fees | Expense | Legal & Professional Fees | Yes |
|---|
| 117 | 118 | 6945 | Consulting Fees | Expense | Legal & Professional Fees | Yes |
|---|
| 118 | 119 | 6950 | Legal Fees | Expense | Legal & Professional Fees | Yes |
|---|
| 119 | 120 | 6960 | IT Services | Expense | Other Business Expenses | Yes |
|---|
| 120 | 121 | 6970 | Janitorial | Expense | Other Business Expenses | Yes |
|---|
| 121 | 122 | 6980 | Pest Control | Expense | Other Business Expenses | Yes |
|---|
| 122 | 123 | 6990 | Uniforms & Laundry | Expense | Other Business Expenses | Yes |
|---|
| 123 | 124 | 7100 | Foreign Exchange Gain/Loss | Other Expense | Exchange Gain or Loss | Yes |
|---|
| 124 | 125 | 7200 | Interest Expense | Other Expense | Interest Paid | Yes |
|---|
| 125 | 126 | 7300 | Interest Income | Other Income | Interest Earned | Yes |
|---|
| 126 | 127 | 7400 | Gain/Loss on Asset Disposal | Other Expense | Other Miscellaneous Expense | Yes |
|---|
| 127 | 128 | 7900 | Other Expense | Other Expense | Other Miscellaneous Expense | Yes |
|---|
Showing 101–127 of 127 rows
| — |
| 0 |
| Active | 0 | 1 | 3 | — | 0 |
|---|