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 |
|---|---|---|---|---|---|
| 8 | 9 | 1205 | Allowance for Doubtful Accounts | 1200 | Accounts Receivable |
| 9 | 10 | 1215 | Employee Advances | 1250 | Other Receivables |
| 10 | 11 | 1250 | Other Receivables | 1250 |
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 |
| Other Receivables |
| 11 | 12 | 1260 | Notes Receivable | 1250 | Other Receivables |
|---|
| 12 | 13 | 1300 | Inventory - Finished Goods | 1300 | Inventory |
|---|
| 13 | 14 | 1310 | Inventory in Transit | 1300 | Inventory |
|---|
| 14 | 15 | 1320 | Inventory - Samples | 1300 | Inventory |
|---|
| 15 | 16 | 1400 | Prepaid Insurance | 1400 | Prepaid Expenses |
|---|
| 16 | 17 | 1410 | Prepaid Expenses - Other | 1400 | Prepaid Expenses |
|---|
| 17 | 18 | 1420 | Security Deposits | 1450 | Deposits |
|---|
| 18 | 19 | 1500 | Warehouse Equipment | 1500 | Property & Equipment |
|---|
| 19 | 20 | 1510 | Vehicles | 1500 | Property & Equipment |
|---|
| 20 | 21 | 1520 | Leasehold Improvements | 1500 | Property & Equipment |
|---|
| 21 | 22 | 1530 | Office Furniture & Equipment | 1500 | Property & Equipment |
|---|
| 22 | 23 | 1540 | Computer Equipment | 1500 | Property & Equipment |
|---|
| 23 | 24 | 1590 | Accumulated Depreciation | 1590 | Accumulated Depreciation |
|---|
| 24 | 25 | 1600 | Utility Deposits | 1450 | Deposits |
|---|
| 25 | 26 | 1700 | Customer Lists | 1700 | Intangible Assets, Net |
|---|
| 26 | 27 | 1790 | Accumulated Amortization | 1590 | Accumulated Depreciation |
|---|
| 27 | 28 | 2000 | Accounts Payable | 2000 | Accounts Payable |
|---|
| 28 | 29 | 2050 | Cascade Visa Business | 2050 | Credit Cards Payable |
|---|
| 29 | 30 | 2100 | Accrued Liabilities | 2100 | Accrued Expenses |
|---|
| 30 | 31 | 2150 | Payroll Liabilities | 2150 | Payroll Liabilities |
|---|
| 31 | 32 | 2160 | Accrued Commissions | 2100 | Accrued Expenses |
|---|
| 32 | 33 | 2170 | Accrued Vacation | 2100 | Accrued Expenses |
|---|
| 33 | 34 | 2200 | Sales Tax Payable | 2200 | Taxes Payable |
|---|
| 34 | 35 | 2210 | Use Tax Payable | 2200 | Taxes Payable |
|---|
| 35 | 36 | 2220 | Oregon CAT Payable | 2200 | Taxes Payable |
|---|
| 36 | 37 | 2300 | Customer Deposits | 2300 | Customer Deposits & Deferred Revenue |
|---|
| 37 | 38 | 2400 | Deferred Revenue | 2300 | Customer Deposits & Deferred Revenue |
|---|
| 38 | 39 | 2500 | Line of Credit - First Cascade | 2500 | Line of Credit |
|---|
| 39 | 40 | 2700 | Equipment Loan - First Cascade | 2700 | Long-Term Debt |
|---|
| 40 | 41 | 2710 | Vehicle Loans | 2700 | Long-Term Debt |
|---|
| 41 | 42 | 2800 | Due to Shareholder | 2800 | Related Party Payables |
|---|
| 42 | 43 | 3000 | Common Stock | 3000 | Common Stock & Paid-In Capital |
|---|
| 43 | 44 | 3100 | Additional Paid-In Capital | 3000 | Common Stock & Paid-In Capital |
|---|
| 44 | 45 | 3900 | Retained Earnings | 3900 | Retained Earnings |
|---|
| 45 | 46 | 3950 | Shareholder Distributions | 3900 | Retained Earnings |
|---|
| 46 | 47 | 4000 | Sales - Wholesale Grocery | 4000 | Revenue - Wholesale |
|---|
| 47 | 48 | 4010 | Sales - Foodservice | 4010 | Revenue - Foodservice |
|---|
| 48 | 49 | 4100 | Sales - Export | 4020 | Revenue - Export |
|---|
| 49 | 50 | 4200 | Freight Income | 4100 | Other Revenue |
|---|
| 50 | 51 | 4300 | Rebate Income | 4100 | Other Revenue |
|---|
| 51 | 52 | 4400 | Miscellaneous Income | 4100 | Other Revenue |
|---|
| 52 | 53 | 4900 | Sales Discounts | 4900 | Contra Revenue |
|---|
| 53 | 54 | 4950 | Returns & Allowances | 4900 | Contra Revenue |
|---|
| 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 |
|---|
Showing 8–57 of 127 rows
| 54 |
| 36 |
| — |
| 0 |