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 Number | Account Name | Account Type | Account Subtype |
|---|---|---|---|---|---|
| 1 | 2 | 1000 | Cash - Operating | Asset | cash |
| 2 | 3 | 1005 | Cash - Payroll | Asset | cash |
| 3 | 4 | 1010 | Cash - Savings & Money Market | Asset | cash |
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 Number | 0 | 69 | 4 | integer 69 | 0 |
| Account Name | 0 | 69 | 36 | — | 0 |
| Account Type | 0 | 5 | 9 | — | 0 |
| Account Subtype | 0 | 21 |
| 4 |
|---|
| 5 |
| 1015 |
| Cash on Hand & Undeposited |
| Asset |
| cash |
| 5 | 6 | 1100 | Short-Term Investments | Asset | other_current_asset |
|---|
| 6 | 7 | 1200 | Accounts Receivable | Asset | accounts_receivable |
|---|
| 7 | 8 | 1210 | Allowance for Credit Losses | Asset | contra_asset |
|---|
| 8 | 9 | 1220 | Unbilled Receivables | Asset | other_current_asset |
|---|
| 9 | 10 | 1250 | Other Receivables | Asset | other_current_asset |
|---|
| 10 | 11 | 1300 | Inventory | Asset | inventory |
|---|
| 11 | 12 | 1310 | Inventory Reserve | Asset | contra_asset |
|---|
| 12 | 13 | 1400 | Prepaid Expenses | Asset | prepaid |
|---|
| 13 | 14 | 1450 | Deposits | Asset | other_current_asset |
|---|
| 14 | 15 | 1500 | Property & Equipment | Asset | fixed_asset |
|---|
| 15 | 16 | 1590 | Accumulated Depreciation | Asset | accumulated_depreciation |
|---|
| 16 | 17 | 1600 | Right-of-Use Assets | Asset | fixed_asset |
|---|
| 17 | 18 | 1700 | Intangible Assets, Net | Asset | fixed_asset |
|---|
| 18 | 19 | 1800 | Deferred Tax Assets | Asset | other_current_asset |
|---|
| 19 | 20 | 1999 | Suspense | Asset | suspense |
|---|
| 20 | 21 | 2000 | Accounts Payable | Liability | accounts_payable |
|---|
| 21 | 22 | 2010 | Accounts Payable - Intercompany | Liability | accounts_payable |
|---|
| 22 | 23 | 2050 | Credit Cards Payable | Liability | accrued_liability |
|---|
| 23 | 24 | 2100 | Accrued Expenses | Liability | accrued_liability |
|---|
| 24 | 25 | 2150 | Payroll Liabilities | Liability | payroll_liability |
|---|
| 25 | 26 | 2200 | Taxes Payable | Liability | accrued_liability |
|---|
| 26 | 27 | 2300 | Customer Deposits & Deferred Revenue | Liability | accrued_liability |
|---|
| 27 | 28 | 2350 | Lease Liabilities - Current | Liability | accrued_liability |
|---|
| 28 | 29 | 2500 | Line of Credit | Liability | line_of_credit |
|---|
| 29 | 30 | 2700 | Long-Term Debt | Liability | long_term_debt |
|---|
| 30 | 31 | 2750 | Lease Liabilities - Non-Current | Liability | long_term_debt |
|---|
| 31 | 32 | 2800 | Related Party Payables | Liability | long_term_debt |
|---|
| 32 | 33 | 2900 | Deferred Tax Liabilities | Liability | long_term_debt |
|---|
| 33 | 34 | 3000 | Common Stock & Paid-In Capital | Equity | common_stock |
|---|
| 34 | 35 | 3900 | Retained Earnings | Equity | retained_earnings |
|---|
| 35 | 36 | 4000 | Revenue - Wholesale | Revenue | operating_revenue |
|---|
| 36 | 37 | 4010 | Revenue - Foodservice | Revenue | operating_revenue |
|---|
| 37 | 38 | 4020 | Revenue - Export | Revenue | operating_revenue |
|---|
| 38 | 39 | 4030 | Revenue - E-Commerce | Revenue | operating_revenue |
|---|
| 39 | 40 | 4100 | Other Revenue | Revenue | other_income |
|---|
| 40 | 41 | 4900 | Contra Revenue | Revenue | operating_revenue |
|---|
| 41 | 42 | 5000 | Cost of Goods Sold | Expense | cost_of_goods_sold |
|---|
| 42 | 43 | 5100 | Freight & Fulfillment | Expense | cost_of_goods_sold |
|---|
| 43 | 44 | 5150 | Packaging | Expense | cost_of_goods_sold |
|---|
| 44 | 45 | 5200 | Landed Cost Variance | Expense | cost_of_goods_sold |
|---|
| 45 | 46 | 6000 | Marketing | Expense | operating_expense |
|---|
| 46 | 47 | 6100 | Salaries & Wages | Expense | operating_expense |
|---|
| 47 | 48 | 6120 | Payroll Taxes & Benefits | Expense | operating_expense |
|---|
| 48 | 49 | 6150 | Commissions | Expense | operating_expense |
|---|
| 49 | 50 | 6190 | Other Personnel Costs | Expense | operating_expense |
|---|
| 50 | 51 | 6200 | Utilities | Expense | operating_expense |
|---|
Showing 1–50 of 69 rows
| 24 |
| — |
| 0 |