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 |
|---|---|---|---|---|---|
| 1 | 2 | 1000 | Petty Cash | 1015 | Cash on Hand & Undeposited |
| 2 | 3 | 1010 | Operating Account - First Cascade 4471 | 1000 | Cash - Operating |
| 3 | 4 | 1015 | Payroll Account - First Cascade 4488 | 1005 |
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 |
| Cash - Payroll |
| 4 | 5 | 1020 | Money Market - First Cascade 4490 | 1010 | Cash - Savings & Money Market |
|---|
| 5 | 6 | 1100 | Undeposited Funds | 1015 | Cash on Hand & Undeposited |
|---|
| 6 | 7 | 1110 | Returned Checks | 1250 | Other Receivables |
|---|
| 7 | 8 | 1200 | Accounts Receivable | 1200 | Accounts Receivable |
|---|
| 8 | 9 | 1205 | Allowance for Doubtful Accounts | 1200 | Accounts Receivable |
|---|
| 9 | 10 | 1215 | Employee Advances | 1250 | Other Receivables |
|---|
| 10 | 11 | 1250 | Other Receivables | 1250 | 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 |
|---|
Showing 1–50 of 127 rows
| 54 |
| 36 |
| — |
| 0 |