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 |
|---|---|---|---|---|---|---|
| 8 | 9 | 1205 | Allowance for Doubtful Accounts | Other Current Asset | Allowance for Bad Debts | Yes |
| 9 | 10 | 1215 | Employee Advances | Other Current Asset | Employee Cash Advances | Yes |
| 10 | 11 | 1250 | Other Receivables |
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 |
| Other Current Asset |
| Other Current Assets |
| Yes |
| 11 | 12 | 1260 | Notes Receivable | Other Current Asset | Loans to Others | Yes |
|---|
| 12 | 13 | 1300 | Inventory - Finished Goods | Other Current Asset | Inventory | Yes |
|---|
| 13 | 14 | 1310 | Inventory in Transit | Other Current Asset | Inventory | Yes |
|---|
| 14 | 15 | 1320 | Inventory - Samples | Other Current Asset | Inventory | Yes |
|---|
| 15 | 16 | 1400 | Prepaid Insurance | Other Current Asset | Prepaid Expenses | Yes |
|---|
| 16 | 17 | 1410 | Prepaid Expenses - Other | Other Current Asset | Prepaid Expenses | Yes |
|---|
| 17 | 18 | 1420 | Security Deposits | Other Current Asset | Other Current Assets | Yes |
|---|
| 18 | 19 | 1500 | Warehouse Equipment | Fixed Asset | Machinery & Equipment | Yes |
|---|
| 19 | 20 | 1510 | Vehicles | Fixed Asset | Vehicles | Yes |
|---|
| 20 | 21 | 1520 | Leasehold Improvements | Fixed Asset | Leasehold Improvements | Yes |
|---|
| 21 | 22 | 1530 | Office Furniture & Equipment | Fixed Asset | Furniture & Fixtures | Yes |
|---|
| 22 | 23 | 1540 | Computer Equipment | Fixed Asset | Machinery & Equipment | Yes |
|---|
| 23 | 24 | 1590 | Accumulated Depreciation | Fixed Asset | Accumulated Depreciation | Yes |
|---|
| 24 | 25 | 1600 | Utility Deposits | Other Asset | Security Deposits | Yes |
|---|
| 25 | 26 | 1700 | Customer Lists | Other Asset | Intangible Assets | Yes |
|---|
| 26 | 27 | 1790 | Accumulated Amortization | Other Asset | Accumulated Amortization | Yes |
|---|
| 27 | 28 | 2000 | Accounts Payable | Accounts Payable | Accounts Payable (A/P) | Yes |
|---|
| 28 | 29 | 2050 | Cascade Visa Business | Credit Card | Credit Card | Yes |
|---|
| 29 | 30 | 2100 | Accrued Liabilities | Other Current Liability | Accrued Liabilities | Yes |
|---|
| 30 | 31 | 2150 | Payroll Liabilities | Other Current Liability | Payroll Tax Payable | Yes |
|---|
| 31 | 32 | 2160 | Accrued Commissions | Other Current Liability | Accrued Liabilities | Yes |
|---|
| 32 | 33 | 2170 | Accrued Vacation | Other Current Liability | Accrued Liabilities | Yes |
|---|
| 33 | 34 | 2200 | Sales Tax Payable | Other Current Liability | Sales Tax Payable | Yes |
|---|
| 34 | 35 | 2210 | Use Tax Payable | Other Current Liability | Sales Tax Payable | Yes |
|---|
| 35 | 36 | 2220 | Oregon CAT Payable | Other Current Liability | Federal Income Tax Payable | Yes |
|---|
| 36 | 37 | 2300 | Customer Deposits | Other Current Liability | Other Current Liabilities | Yes |
|---|
| 37 | 38 | 2400 | Deferred Revenue | Other Current Liability | Deferred Revenue | Yes |
|---|
| 38 | 39 | 2500 | Line of Credit - First Cascade | Other Current Liability | Line of Credit | Yes |
|---|
| 39 | 40 | 2700 | Equipment Loan - First Cascade | Long Term Liability | Notes Payable | Yes |
|---|
| 40 | 41 | 2710 | Vehicle Loans | Long Term Liability | Notes Payable | Yes |
|---|
| 41 | 42 | 2800 | Due to Shareholder | Long Term Liability | Shareholder Notes Payable | Yes |
|---|
| 42 | 43 | 3000 | Common Stock | Equity | Common Stock | Yes |
|---|
| 43 | 44 | 3100 | Additional Paid-In Capital | Equity | Paid-In Capital or Surplus | Yes |
|---|
| 44 | 45 | 3900 | Retained Earnings | Equity | Retained Earnings | Yes |
|---|
| 45 | 46 | 3950 | Shareholder Distributions | Equity | Partner Distributions | Yes |
|---|
| 46 | 47 | 4000 | Sales - Wholesale Grocery | Income | Sales of Product Income | Yes |
|---|
| 47 | 48 | 4010 | Sales - Foodservice | Income | Sales of Product Income | Yes |
|---|
| 48 | 49 | 4100 | Sales - Export | Income | Sales of Product Income | Yes |
|---|
| 49 | 50 | 4200 | Freight Income | Income | Service/Fee Income | Yes |
|---|
| 50 | 51 | 4300 | Rebate Income | Other Income | Other Miscellaneous Income | Yes |
|---|
| 51 | 52 | 4400 | Miscellaneous Income | Other Income | Other Miscellaneous Income | Yes |
|---|
| 52 | 53 | 4900 | Sales Discounts | Income | Discounts/Refunds Given | Yes |
|---|
| 53 | 54 | 4950 | Returns & Allowances | Income | Discounts/Refunds Given | Yes |
|---|
| 54 | 55 | 5000 | Cost of Goods Sold | Cost of Goods Sold | Supplies & Materials - COGS | Yes |
|---|
| 55 | 56 | 5010 | Inventory Adjustments | Cost of Goods Sold | Supplies & Materials - COGS | Yes |
|---|
| 56 | 57 | 5020 | Purchase Price Variance | Cost of Goods Sold | Other Costs of Services - COS | Yes |
|---|
| 57 | 58 | 5030 | Samples & Demos | Cost of Goods Sold | Other Costs of Services - COS | Yes |
|---|
Showing 8–57 of 127 rows
| — |
| 0 |
| Active | 0 | 1 | 3 | — | 0 |
|---|