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 | Invoice No | Customer ID | Customer Name | Invoice Date | Due Date | Terms | Currency | Subtotal | Tax | Total | Exchange Rate | Total (USD) | Balance Due | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1012 | 1013 | INV-9978 | C-0216 | Arbor Kitchen | 12/23/2025 | 01/07/2026 | Net 15 | USD | 1,007.32 | 0.00 | 1,007.32 | 1.0000 |
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 |
|---|---|---|---|---|---|
| Invoice No | 0 | 1033 | 9 | — | 0 |
| Customer ID | 0 | 166 | 6 | — | 0 |
| Customer Name | 0 | 166 | 31 | — | 0 |
| Invoice Date | 0 | 146 |
| 1,007.32 |
| 0.00 |
| Paid |
| 1013 | 1014 | INV-9979 | C-0306 | Tillamook Road Grocery | 12/23/2025 | 01/22/2026 | Net 30 | USD | 24,793.84 | 0.00 | 24,793.84 | 1.0000 | 24,793.84 | 0.00 | Paid |
|---|
| 1014 | 1015 | INV-9980 | C-0328 | Drumlin Bakery | 12/23/2025 | 01/07/2026 | Net 15 | USD | 2,300.54 | 0.00 | 2,300.54 | 1.0000 | 2,300.54 | 0.00 | Paid |
|---|
| 1015 | 1016 | INV-9981 | C-0378 | Yellowjacket Taproom | 12/25/2025 | 01/09/2026 | Net 15 | USD | 3,434.88 | 0.00 | 3,434.88 | 1.0000 | 3,434.88 | 0.00 | Paid |
|---|
| 1016 | 1017 | INV-9982 | C-0106 | Fiddlehead Taproom | 12/25/2025 | 01/09/2026 | Net 15 | USD | 1,501.38 | 0.00 | 1,501.38 | 1.0000 | 1,501.38 | 0.00 | Paid |
|---|
| 1017 | 1018 | INV-9983 | C-0278 | Sorrel Cantina | 12/25/2025 | 01/09/2026 | Net 15 | USD | 3,242.64 | 0.00 | 3,242.64 | 1.0000 | 3,242.64 | 0.00 | Paid |
|---|
| 1018 | 1019 | INV-9984 | C-0390 | Dogwood Bistro | 12/25/2025 | 01/09/2026 | Net 15 | USD | 2,744.02 | 0.00 | 2,744.02 | 1.0000 | 2,744.02 | 0.00 | Paid |
|---|
| 1019 | 1020 | INV-9985 | C-0001 | Meadowlark Bistro | 12/26/2025 | 01/10/2026 | Net 15 | USD | 1,814.84 | 0.00 | 1,814.84 | 1.0000 | 1,814.84 | 0.00 | Paid |
|---|
| 1020 | 1021 | INV-9986 | C-0082 | Chanterelle Supper Club | 12/26/2025 | 01/10/2026 | Net 15 | USD | 1,954.82 | 0.00 | 1,954.82 | 1.0000 | 1,954.82 | 0.00 | Paid |
|---|
| 1021 | 1022 | INV-9987 | C-0132 | Jubilee Cantina | 12/29/2025 | 01/13/2026 | Net 15 | USD | 778.29 | 0.00 | 778.29 | 1.0000 | 778.29 | 0.00 | Paid |
|---|
| 1022 | 1023 | INV-9988 | C-0191 | Riverstone Smokehouse | 12/29/2025 | 01/13/2026 | Net 15 | USD | 1,466.70 | 0.00 | 1,466.70 | 1.0000 | 1,466.70 | 0.00 | Paid |
|---|
| 1023 | 1024 | INV-9989 | C-0242 | Pumice Cantina | 12/29/2025 | 01/13/2026 | Net 15 | USD | 1,293.22 | 0.00 | 1,293.22 | 1.0000 | 1,293.22 | 0.00 | Paid |
|---|
| 1024 | 1025 | INV-9990 | C-0276 | Mossy Rock Taproom | 12/29/2025 | 01/13/2026 | Net 15 | USD | 3,288.23 | 0.00 | 3,288.23 | 1.0000 | 3,288.23 | 0.00 | Paid |
|---|
| 1025 | 1026 | INV-9991 | C-0295 | Zephyr Bakery | 12/29/2025 | 01/13/2026 | Net 15 | USD | 3,299.21 | 0.00 | 3,299.21 | 1.0000 | 3,299.21 | 0.00 | Paid |
|---|
| 1026 | 1027 | INV-9992 | C-0425 | Thistle Pizzeria | 12/29/2025 | 01/13/2026 | Net 15 | USD | 1,452.04 | 0.00 | 1,452.04 | 1.0000 | 1,452.04 | 0.00 | Paid |
|---|
| 1027 | 1028 | INV-9993 | C-0330 | Alder Street Market | 01/02/2026 | 02/01/2026 | Net 30 | USD | 12,093.45 | 0.00 | 12,093.45 | 1.0000 | 12,093.45 | 0.00 | Paid |
|---|
| 1028 | 1029 | INV-9994 | C-0206 | Otter Brasserie | 12/29/2025 | 01/13/2026 | Net 15 | USD | 3,626.31 | 0.00 | 3,626.31 | 1.0000 | 3,626.31 | 0.00 | Paid |
|---|
| 1029 | 1030 | INV-9995 | C-0237 | Plover Supper Club | 12/29/2025 | 01/13/2026 | Net 15 | USD | 3,190.25 | 0.00 | 3,190.25 | 1.0000 | 3,190.25 | 0.00 | Paid |
|---|
| 1030 | 1031 | INV-9996 | C-0275 | Tamarack Smokehouse | 12/29/2025 | 01/13/2026 | Net 15 | USD | 863.93 | 0.00 | 863.93 | 1.0000 | 863.93 | 0.00 | Paid |
|---|
| 1031 | 1032 | INV-9997 | C-0296 | Bluebird Smokehouse | 12/29/2025 | 01/13/2026 | Net 15 | USD | 1,876.35 | 0.00 | 1,876.35 | 1.0000 | 1,876.35 | 0.00 | Paid |
|---|
| 1032 | 1033 | INV-9998 | C-0324 | Obsidian Grill | 12/29/2025 | 01/13/2026 | Net 15 | USD | 1,842.72 | 0.00 | 1,842.72 | 1.0000 | 1,842.72 | 0.00 | Paid |
|---|
| 1033 | 1034 | INV-9999 | C-0349 | Dovetail Taproom | 12/29/2025 | 01/13/2026 | Net 15 | USD | 2,076.85 | 0.00 | 2,076.85 | 1.0000 | 2,076.85 | 0.00 | Paid |
|---|
Showing 1012–1033 of 1033 rows
| 10 |
| date mm dd yyyy 1033 |
| 384 |
| Due Date | 0 | 182 | 10 | date mm dd yyyy 1033 | 425 |
|---|
| Terms | 0 | 3 | 6 | — | 0 |
|---|
| Currency | 0 | 2 | 3 | — | 0 |
|---|
| Subtotal | 0 | 1030 | 9 | decimal 32, amount grouped 1001 | 0 |
|---|
| Tax | 0 | 1 | 4 | decimal 1033 | 0 |
|---|
| Total | 0 | 1030 | 9 | decimal 32, amount grouped 1001 | 0 |
|---|
| Exchange Rate | 0 | 15 | 6 | decimal 1033 | 0 |
|---|
| Total (USD) | 0 | 1030 | 9 | decimal 32, amount grouped 1001 | 0 |
|---|
| Balance Due | 0 | 145 | 9 | decimal 893, amount grouped 140 | 0 |
|---|
| Status | 0 | 2 | 4 | — | 0 |
|---|