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 |
|---|---|---|---|---|---|---|
| 853 | 854 | 5150 | Packaging Materials | 06/30/2026 | 212,470.92 | |
| 854 | 855 | 5200 | Spoilage & Shrink | 06/30/2026 | 0.00 | |
| 855 | 856 | 5300 | Co-Packing Fees |
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 |
| 856 | 857 | 6000 | Advertising & Marketing | 06/30/2026 | 1,864.15 |
|---|
| 857 | 858 | 6010 | Trade Shows | 06/30/2026 | 2,584.62 |
|---|
| 858 | 859 | 6020 | Website | 06/30/2026 | 0.00 |
|---|
| 859 | 860 | 6030 | Meals & Entertainment | 06/30/2026 | 0.00 |
|---|
| 860 | 861 | 6040 | Travel | 06/30/2026 | 0.00 |
|---|
| 861 | 862 | 6050 | Donations | 06/30/2026 | 0.00 |
|---|
| 862 | 863 | 6060 | Licenses & Permits | 06/30/2026 | 2,241.93 |
|---|
| 863 | 864 | 6070 | Property Taxes | 06/30/2026 | 0.00 |
|---|
| 864 | 865 | 6080 | Business Taxes | 06/30/2026 | 0.00 |
|---|
| 865 | 866 | 6090 | Recruiting | 06/30/2026 | 0.00 |
|---|
| 866 | 867 | 6100 | Wages - Warehouse | 06/30/2026 | 737,041.89 |
|---|
| 867 | 868 | 6105 | Wages - Drivers | 06/30/2026 | 456,456.52 |
|---|
| 868 | 869 | 6110 | Wages - Office | 06/30/2026 | 412,496.46 |
|---|
| 869 | 870 | 6120 | Payroll Taxes | 06/30/2026 | 130,724.22 |
|---|
| 870 | 871 | 6130 | Employee Benefits | 06/30/2026 | 0.00 |
|---|
| 871 | 872 | 6140 | Workers Compensation | 06/30/2026 | 0.00 |
|---|
| 872 | 873 | 6150 | Sales Commissions | 06/30/2026 | 103,002.71 |
|---|
| 873 | 874 | 6160 | Temporary Labor | 06/30/2026 | 41,144.01 |
|---|
| 874 | 875 | 6170 | Training | 06/30/2026 | 0.00 |
|---|
| 875 | 876 | 6180 | Employee Relations | 06/30/2026 | 0.00 |
|---|
| 876 | 877 | 6190 | Payroll Processing Fees | 06/30/2026 | 2,227.32 |
|---|
| 877 | 878 | 6200 | Utilities - Electric | 06/30/2026 | 7,613.10 |
|---|
| 878 | 879 | 6210 | Utilities - Water & Sewer | 06/30/2026 | 3,020.83 |
|---|
| 879 | 880 | 6220 | Telephone & Internet | 06/30/2026 | 7,792.90 |
|---|
| 880 | 881 | 6230 | Utilities - Gas | 06/30/2026 | 0.00 |
|---|
| 881 | 882 | 6240 | Waste Removal | 06/30/2026 | 3,766.39 |
|---|
| 882 | 883 | 6300 | Rent - Portland Warehouse | 06/30/2026 | 51,000.00 |
|---|
| 883 | 884 | 6310 | Rent - Seattle Warehouse | 06/30/2026 | 38,520.00 |
|---|
| 884 | 885 | 6320 | Rent - Boise Warehouse | 06/30/2026 | 29,250.00 |
|---|
| 885 | 886 | 6330 | Third-Party Storage | 06/30/2026 | 18,159.86 |
|---|
| 886 | 887 | 6400 | Freight-In | 06/30/2026 | 391,060.50 |
|---|
| 887 | 888 | 6410 | Freight Rebates | 06/30/2026 | 0.00 |
|---|
| 888 | 889 | 6420 | Delivery Fuel | 06/30/2026 | 76,814.00 |
|---|
| 889 | 890 | 6430 | Vehicle Repairs & Maintenance | 06/30/2026 | 10,168.99 |
|---|
| 890 | 891 | 6440 | Tolls & Parking | 06/30/2026 | 0.00 |
|---|
| 891 | 892 | 6450 | Vehicle Registration | 06/30/2026 | 0.00 |
|---|
| 892 | 893 | 6460 | Vehicle Leases | 06/30/2026 | 0.00 |
|---|
| 893 | 894 | 6500 | Insurance - General | 06/30/2026 | 19,650.00 |
|---|
| 894 | 895 | 6510 | Insurance - Vehicles | 06/30/2026 | 16,543.88 |
|---|
| 895 | 896 | 6520 | Insurance - Product Liability | 06/30/2026 | 0.00 |
|---|
| 896 | 897 | 6600 | Repairs - Refrigeration & Equipment | 06/30/2026 | 27,652.89 |
|---|
| 897 | 898 | 6610 | Forklift Lease | 06/30/2026 | 13,499.69 |
|---|
| 898 | 899 | 6620 | Building Repairs | 06/30/2026 | 11,165.34 |
|---|
| 899 | 900 | 6630 | Small Tools & Equipment | 06/30/2026 | 1,365.67 |
|---|
| 900 | 901 | 6700 | Depreciation Expense | 06/30/2026 | 71,100.00 |
|---|
| 901 | 902 | 6710 | Amortization Expense | 06/30/2026 | 3,000.00 |
|---|
| 902 | 903 | 6800 | Bad Debt Expense | 06/30/2026 | 3,400.00 |
|---|
Showing 853–902 of 924 rows
| 12 |
| decimal 462, amount grouped 342 |
| 0 |
| Credit | 804 | 80 | 12 | decimal 3, amount grouped 117 | 0 |
|---|