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 | Period Ending | Debit | Credit |
|---|---|---|---|---|---|---|
| 796 | 797 | 1020 | Money Market - First Cascade 4490 | 06/30/2026 | 250,000.00 | |
| 797 | 798 | 1030 | Savings - Umpqua (closed) | 06/30/2026 | 0.00 | |
| 798 | 799 | 1100 | Undeposited Funds |
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 | 132 | 4 | integer 924 | 0 |
| Description | 0 | 132 | 38 | — | 0 |
| Period Ending | 0 | 7 | 10 | date mm dd yyyy 924 | 0 |
| Debit | 120 | 255 |
| 06/30/2026 |
| 0.00 |
| 799 | 800 | 1110 | Returned Checks | 06/30/2026 | 0.00 |
|---|
| 800 | 801 | 1200 | Accounts Receivable | 06/30/2026 | 2,135,769.00 |
|---|
| 801 | 802 | 1205 | Allowance for Doubtful Accounts | 06/30/2026 | 38,400.00 |
|---|
| 802 | 803 | 1215 | Employee Advances | 06/30/2026 | 0.00 |
|---|
| 803 | 804 | 1250 | Other Receivables | 06/30/2026 | 3,150.00 |
|---|
| 804 | 805 | 1260 | Notes Receivable | 06/30/2026 | 0.00 |
|---|
| 805 | 806 | 1300 | Inventory - Finished Goods | 06/30/2026 | 1,918,216.90 |
|---|
| 806 | 807 | 1310 | Inventory in Transit | 06/30/2026 | 0.00 |
|---|
| 807 | 808 | 1320 | Inventory - Samples | 06/30/2026 | 0.00 |
|---|
| 808 | 809 | 1400 | Prepaid Insurance | 06/30/2026 | 19,650.00 |
|---|
| 809 | 810 | 1410 | Prepaid Expenses - Other | 06/30/2026 | 18,400.00 |
|---|
| 810 | 811 | 1420 | Security Deposits | 06/30/2026 | 42,500.00 |
|---|
| 811 | 812 | 1500 | Warehouse Equipment | 06/30/2026 | 1,182,400.00 |
|---|
| 812 | 813 | 1510 | Vehicles | 06/30/2026 | 486,300.00 |
|---|
| 813 | 814 | 1520 | Leasehold Improvements | 06/30/2026 | 211,750.00 |
|---|
| 814 | 815 | 1530 | Office Furniture & Equipment | 06/30/2026 | 38,620.00 |
|---|
| 815 | 816 | 1540 | Computer Equipment | 06/30/2026 | 52,980.00 |
|---|
| 816 | 817 | 1590 | Accumulated Depreciation | 06/30/2026 | 483,740.00 |
|---|
| 817 | 818 | 1600 | Utility Deposits | 06/30/2026 | 6,200.00 |
|---|
| 818 | 819 | 1700 | Customer Lists | 06/30/2026 | 60,000.00 |
|---|
| 819 | 820 | 1790 | Accumulated Amortization | 06/30/2026 | 39,000.00 |
|---|
| 820 | 821 | 2000 | Accounts Payable | 06/30/2026 | 1,188,436.65 |
|---|
| 821 | 822 | 2050 | Cascade Visa Business | 06/30/2026 | 0.00 |
|---|
| 822 | 823 | 2060 | Amex Corporate (closed) | 06/30/2026 | 0.00 |
|---|
| 823 | 824 | 2100 | Accrued Liabilities | 06/30/2026 | 14,705.41 |
|---|
| 824 | 825 | 2150 | Payroll Liabilities | 06/30/2026 | 0.00 |
|---|
| 825 | 826 | 2160 | Accrued Commissions | 06/30/2026 | 17,103.33 |
|---|
| 826 | 827 | 2170 | Accrued Vacation | 06/30/2026 | 48,620.00 |
|---|
| 827 | 828 | 2200 | Sales Tax Payable | 06/30/2026 | 0.00 |
|---|
| 828 | 829 | 2210 | Use Tax Payable | 06/30/2026 | 0.00 |
|---|
| 829 | 830 | 2220 | Oregon CAT Payable | 06/30/2026 | 7,840.00 |
|---|
| 830 | 831 | 2300 | Customer Deposits | 06/30/2026 | 0.00 |
|---|
| 831 | 832 | 2400 | Deferred Revenue | 06/30/2026 | 0.00 |
|---|
| 832 | 833 | 2500 | Line of Credit - First Cascade | 06/30/2026 | 1,230,000.00 |
|---|
| 833 | 834 | 2700 | Equipment Loan - First Cascade | 06/30/2026 | 239,300.00 |
|---|
| 834 | 835 | 2710 | Vehicle Loans | 06/30/2026 | 94,200.00 |
|---|
| 835 | 836 | 2800 | Due to Shareholder | 06/30/2026 | 0.00 |
|---|
| 836 | 837 | 3000 | Common Stock | 06/30/2026 | 50,000.00 |
|---|
| 837 | 838 | 3100 | Additional Paid-In Capital | 06/30/2026 | 150,000.00 |
|---|
| 838 | 839 | 3900 | Retained Earnings | 06/30/2026 | 3,297,191.08 |
|---|
| 839 | 840 | 3950 | Shareholder Distributions | 06/30/2026 | 0.00 |
|---|
| 840 | 841 | 4000 | Sales - Wholesale Grocery | 06/30/2026 | 9,878,923.41 |
|---|
| 841 | 842 | 4010 | Sales - Foodservice | 06/30/2026 | 887,614.64 |
|---|
| 842 | 843 | 4100 | Sales - Export | 06/30/2026 | 170,497.53 |
|---|
| 843 | 844 | 4200 | Freight Income | 06/30/2026 | 0.00 |
|---|
| 844 | 845 | 4300 | Rebate Income | 06/30/2026 | 0.00 |
|---|
| 845 | 846 | 4400 | Miscellaneous Income | 06/30/2026 | 0.00 |
|---|
Showing 796–845 of 924 rows
| 12 |
| decimal 462, amount grouped 342 |
| 0 |
| Credit | 804 | 80 | 12 | decimal 3, amount grouped 117 | 0 |
|---|