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 | Customer ID | Customer | Type | Num | Date | Due Date | Currency | Current | 1 - 30 | 31 - 60 | 61 - 90 | > 90 | Open Balance (USD) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 102 | C-0301 | Alpenkost GmbH | Invoice | INV-10617 | 06/05/2026 | 09/03/2026 | EUR | 6,621.57 | 6,621.57 |
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 |
|---|---|---|---|---|---|
| Customer ID | 1 | 74 | 6 | — | 0 |
| Customer | 0 | 75 | 31 | — | 0 |
| Type | 1 | 2 | 7 | — | 0 |
| Num | 1 | 146 | 9 |
| 102 | 103 | C-0301 | Alpenkost GmbH | Payment | PMT-32028 | 06/10/2026 | USD | -1,254.40 | -1,254.40 |
|---|
| 103 | 104 | C-0301 | Alpenkost GmbH | Invoice | INV-10707 | 06/16/2026 | 09/14/2026 | EUR | 13,491.85 | 13,491.85 |
|---|
| 104 | 105 | C-0301 | Alpenkost GmbH | Invoice | INV-10632 | 06/26/2026 | 09/24/2026 | EUR | 12,897.39 | 12,897.39 |
|---|
| 105 | 106 | C-0303 | Trillium Bistro | Invoice | INV-10811 | 06/15/2026 | 06/30/2026 | USD | 3,198.60 | 3,198.60 |
|---|
| 106 | 107 | C-0306 | Tillamook Road Grocery | Invoice | INV-10764 | 06/04/2026 | 07/04/2026 | USD | 23,021.93 | 23,021.93 |
|---|
| 107 | 108 | C-0306 | Tillamook Road Grocery | Invoice | INV-10835 | 06/22/2026 | 07/22/2026 | USD | 16,269.23 | 16,269.23 |
|---|
| 108 | 109 | C-0330 | Alder Street Market | Invoice | INV-10812 | 06/15/2026 | 07/15/2026 | USD | 18,003.05 | 18,003.05 |
|---|
| 109 | 110 | C-0330 | Alder Street Market | Invoice | INV-10882 | 06/30/2026 | 07/30/2026 | USD | 13,568.77 | 13,568.77 |
|---|
| 110 | 111 | C-0331 | Ironwood Grocery | Invoice | INV-10703 | 05/25/2026 | 06/24/2026 | USD | 16,633.65 | 16,633.65 |
|---|
| 111 | 112 | C-0331 | Ironwood Grocery | Invoice | INV-10788 | 06/08/2026 | 07/08/2026 | USD | 26,225.65 | 26,225.65 |
|---|
| 112 | 113 | C-0331 | Ironwood Grocery | Invoice | INV-10822 | 06/23/2026 | 07/23/2026 | USD | 11,742.95 | 11,742.95 |
|---|
| 113 | 114 | C-0335 | Mountain Grocers Inc. | Invoice | INV-10723 | 06/01/2026 | 07/01/2026 | USD | 20,989.44 | 20,989.44 |
|---|
| 114 | 115 | C-0335 | Mountain Grocers Inc. | Invoice | INV-10804 | 06/15/2026 | 07/15/2026 | USD | 17,113.03 | 17,113.03 |
|---|
| 115 | 116 | C-0335 | Mountain Grocers Inc. | Invoice | INV-10857 | 06/29/2026 | 07/29/2026 | USD | 21,455.17 | 21,455.17 |
|---|
| 116 | 117 | C-0340 | Eastside Cafe | Invoice | INV-10866 | 06/24/2026 | 07/09/2026 | USD | 3,972.83 | 3,972.83 |
|---|
| 117 | 118 | C-0348 | Foxglove Market | Invoice | INV-10751 | 06/04/2026 | 07/04/2026 | USD | 28,280.75 | 28,280.75 |
|---|
| 118 | 119 | C-0348 | Foxglove Market | Invoice | INV-10843 | 06/22/2026 | 07/22/2026 | USD | 27,314.36 | 27,314.36 |
|---|
| 119 | 120 | C-0355 | Jackdaw Kitchen | Invoice | INV-10876 | 06/25/2026 | 07/10/2026 | USD | 3,517.19 | 3,517.19 |
|---|
| 120 | 121 | C-0357 | Mountain Grocers LLC | Invoice | INV-10794 | 06/08/2026 | 07/08/2026 | USD | 25,680.79 | 25,680.79 |
|---|
| 121 | 122 | C-0357 | Mountain Grocers LLC | Invoice | INV-10849 | 06/22/2026 | 07/22/2026 | USD | 22,346.83 | 22,346.83 |
|---|
| 122 | 123 | C-0366 | Kettle Bistro | Invoice | INV-10862 | 06/22/2026 | 07/07/2026 | USD | 3,401.33 | 3,401.33 |
|---|
| 123 | 124 | C-0378 | Yellowjacket Taproom | Invoice | INV-10856 | 06/23/2026 | 07/08/2026 | USD | 2,476.56 | 2,476.56 |
|---|
| 124 | 125 | C-0379 | Filbert & Oak Market | Invoice | INV-10740 | 05/26/2026 | 06/25/2026 | USD | 26,076.09 | 26,076.09 |
|---|
| 125 | 126 | C-0379 | Filbert & Oak Market | Invoice | INV-10785 | 06/11/2026 | 07/11/2026 | USD | 20,442.75 | 20,442.75 |
|---|
| 126 | 127 | C-0379 | Filbert & Oak Market | Invoice | INV-10837 | 06/25/2026 | 07/25/2026 | USD | 20,527.84 | 20,527.84 |
|---|
| 127 | 128 | C-0389 | Umpqua Valley Foods | Invoice | INV-10778 | 06/10/2026 | 07/10/2026 | USD | 11,113.59 | 11,113.59 |
|---|
| 128 | 129 | C-0389 | Umpqua Valley Foods | Invoice | INV-10838 | 06/26/2026 | 07/26/2026 | USD | 19,171.74 | 19,171.74 |
|---|
| 129 | 130 | C-0390 | Dogwood Bistro | Invoice | INV-10795 | 06/08/2026 | 06/23/2026 | USD | 1,595.14 | 1,595.14 |
|---|
| 130 | 131 | C-0396 | Driftwood Pantry | Invoice | INV-10715 | 05/25/2026 | 06/24/2026 | USD | 25,385.77 | 25,385.77 |
|---|
| 131 | 132 | C-0396 | Driftwood Pantry | Invoice | INV-10777 | 06/08/2026 | 07/08/2026 | USD | 26,569.22 | 26,569.22 |
|---|
| 132 | 133 | C-0396 | Driftwood Pantry | Invoice | INV-10830 | 06/22/2026 | 07/22/2026 | USD | 13,922.73 | 13,922.73 |
|---|
| 133 | 134 | C-0399 | Larch Mountain Mercantile | Invoice | INV-10744 | 06/01/2026 | 07/01/2026 | USD | 14,034.75 | 14,034.75 |
|---|
| 134 | 135 | C-0399 | Larch Mountain Mercantile | Invoice | INV-10813 | 06/15/2026 | 07/15/2026 | USD | 13,092.94 | 13,092.94 |
|---|
| 135 | 136 | C-0399 | Larch Mountain Mercantile | Invoice | INV-10883 | 06/29/2026 | 07/29/2026 | USD | 28,431.97 | 28,431.97 |
|---|
| 136 | 137 | C-0400 | Salmonberry Market | Invoice | INV-10758 | 06/08/2026 | 07/08/2026 | USD | 15,860.18 | 15,860.18 |
|---|
| 137 | 138 | C-0400 | Salmonberry Market | Invoice | INV-10841 | 06/23/2026 | 07/23/2026 | USD | 23,581.08 | 23,581.08 |
|---|
| 138 | 139 | C-0414 | Belmont Natural Foods | Invoice | INV-10800 | 06/09/2026 | 07/09/2026 | USD | 13,904.28 | 13,904.28 |
|---|
| 139 | 140 | C-0414 | Belmont Natural Foods | Invoice | INV-10853 | 06/22/2026 | 07/22/2026 | USD | 24,609.11 | 24,609.11 |
|---|
| 140 | 141 | C-0415 | Kestrel Market Hall | Invoice | INV-10793 | 06/16/2026 | 07/16/2026 | USD | 26,000.70 | 26,000.70 |
|---|
| 141 | 142 | C-0415 | Kestrel Market Hall | Invoice | INV-10879 | 06/30/2026 | 07/30/2026 | USD | 18,114.28 | 18,114.28 |
|---|
| 142 | 143 | C-0420 | Nehalem Bay Grocers | Invoice | INV-10756 | 06/01/2026 | 07/01/2026 | USD | 15,832.00 | 15,832.00 |
|---|
| 143 | 144 | C-0420 | Nehalem Bay Grocers | Invoice | INV-10814 | 06/15/2026 | 07/15/2026 | USD | 20,282.87 | 20,282.87 |
|---|
| 144 | 145 | C-0420 | Nehalem Bay Grocers | Invoice | INV-10881 | 06/29/2026 | 07/29/2026 | USD | 28,964.35 | 28,964.35 |
|---|
| 145 | 146 | C-0427 | Deschutes Food Hall | Invoice | INV-10742 | 06/02/2026 | 07/02/2026 | USD | 12,970.24 | 12,970.24 |
|---|
| 146 | 147 | C-0427 | Deschutes Food Hall | Invoice | INV-10799 | 06/17/2026 | 07/17/2026 | USD | 16,080.94 | 16,080.94 |
|---|
| 147 | 148 | TOTAL | 1,892,341.99 | 239,837.14 | 0.00 | 0.00 | 3,589.87 | 2,135,769.00 |
|---|
Showing 101–147 of 147 rows
| — |
| 0 |
| Date | 1 | 33 | 10 | date mm dd yyyy 146 | 47 |
|---|
| Due Date | 2 | 36 | 10 | date mm dd yyyy 145 | 57 |
|---|
| Currency | 1 | 2 | 3 | — | 0 |
|---|
| Current | 18 | 129 | 12 | decimal 4, amount grouped 125 | 0 |
|---|
| 1 - 30 | 130 | 17 | 10 | amount grouped 17 | 0 |
|---|
| 31 - 60 | 146 | 1 | 4 | decimal 1 | 0 |
|---|
| 61 - 90 | 146 | 1 | 4 | decimal 1 | 0 |
|---|
| > 90 | 144 | 3 | 8 | amount grouped 3 | 0 |
|---|
| Open Balance (USD) | 0 | 147 | 12 | decimal 4, amount grouped 143 | 0 |
|---|