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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112 | 113 | INV-10111 | C-0093 | Heron Cafe | 01/22/2026 | 02/06/2026 | Net 15 | USD | 3,165.40 | 0.00 | 3,165.40 | 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 |
| 3,165.40 |
| 0.00 |
| Paid |
| 113 | 114 | INV-10112 | C-0133 | Sawtooth Natural Foods | 01/23/2026 | 02/22/2026 | Net 30 | USD | 20,378.49 | 0.00 | 20,378.49 | 1.0000 | 20,378.49 | 0.00 | Paid |
|---|
| 114 | 115 | INV-10113 | C-0273 | Coldwater Creek Market | 01/26/2026 | 02/25/2026 | Net 30 | USD | 11,212.05 | 0.00 | 11,212.05 | 1.0000 | 11,212.05 | 0.00 | Paid |
|---|
| 115 | 116 | INV-10114 | C-0389 | Umpqua Valley Foods | 01/28/2026 | 02/27/2026 | Net 30 | USD | 12,274.09 | 0.00 | 12,274.09 | 1.0000 | 12,274.09 | 0.00 | Paid |
|---|
| 116 | 117 | INV-10115 | C-0186 | Hawthorne Fresh Market | 01/21/2026 | 02/20/2026 | Net 30 | USD | 22,832.55 | 0.00 | 22,832.55 | 1.0000 | 22,832.55 | 0.00 | Paid |
|---|
| 117 | 118 | INV-10116 | C-0193 | Quinault Country Store | 01/21/2026 | 02/20/2026 | Net 30 | USD | 25,719.27 | 0.00 | 25,719.27 | 1.0000 | 25,719.27 | 0.00 | Paid |
|---|
| 118 | 119 | INV-10117 | C-0033 | Treasure Valley Market | 01/22/2026 | 02/21/2026 | Net 30 | USD | 24,848.73 | 0.00 | 24,848.73 | 1.0000 | 24,848.73 | 0.00 | Paid |
|---|
| 119 | 120 | INV-10118 | C-0217 | Paddle Eatery | 01/22/2026 | 02/06/2026 | Net 15 | USD | 841.09 | 0.00 | 841.09 | 1.0000 | 841.09 | 0.00 | Paid |
|---|
| 120 | 121 | INV-10119 | C-0340 | Eastside Cafe | 01/22/2026 | 02/06/2026 | Net 15 | USD | 2,480.66 | 0.00 | 2,480.66 | 1.0000 | 2,480.66 | 0.00 | Paid |
|---|
| 121 | 122 | INV-10120 | C-0423 | Salt Marsh Kitchen | 01/23/2026 | 02/07/2026 | Net 15 | USD | 1,855.36 | 0.00 | 1,855.36 | 1.0000 | 1,855.36 | 0.00 | Paid |
|---|
| 122 | 123 | INV-10121 | C-0198 | GREEN VALLEY COOP #2 | 01/26/2026 | 02/25/2026 | Net 30 | USD | 13,070.19 | 0.00 | 13,070.19 | 1.0000 | 13,070.19 | 0.00 | Paid |
|---|
| 123 | 124 | INV-10122 | C-0334 | Isle Smokehouse | 01/22/2026 | 02/06/2026 | Net 15 | USD | 2,282.07 | 0.00 | 2,282.07 | 1.0000 | 2,282.07 | 0.00 | Paid |
|---|
| 124 | 125 | INV-10123 | C-0116 | Ember Eatery | 01/23/2026 | 02/07/2026 | Net 15 | USD | 2,608.97 | 0.00 | 2,608.97 | 1.0000 | 2,608.97 | 0.00 | Paid |
|---|
| 125 | 126 | INV-10124 | C-0275 | Tamarack Smokehouse | 01/23/2026 | 02/07/2026 | Net 15 | USD | 2,865.84 | 0.00 | 2,865.84 | 1.0000 | 2,865.84 | 0.00 | Paid |
|---|
| 126 | 127 | INV-10125 | C-0349 | Dovetail Taproom | 01/23/2026 | 02/07/2026 | Net 15 | USD | 2,703.42 | 0.00 | 2,703.42 | 1.0000 | 2,703.42 | 0.00 | Paid |
|---|
| 127 | 128 | INV-10126 | C-0335 | Mountain Grocers Inc. | 01/26/2026 | 02/25/2026 | Net 30 | USD | 20,927.01 | 0.00 | 20,927.01 | 1.0000 | 20,927.01 | 0.00 | Paid |
|---|
| 128 | 129 | INV-10127 | C-0381 | Rookery Cafe | 01/23/2026 | 02/07/2026 | Net 15 | USD | 1,812.51 | 0.00 | 1,812.51 | 1.0000 | 1,812.51 | 0.00 | Paid |
|---|
| 129 | 130 | INV-10128 | C-0403 | Basalt Grill | 01/26/2026 | 02/10/2026 | Net 15 | USD | 867.36 | 0.00 | 867.36 | 1.0000 | 867.36 | 0.00 | Paid |
|---|
| 130 | 131 | INV-10129 | C-0427 | Deschutes Food Hall | 01/26/2026 | 02/25/2026 | Net 30 | USD | 28,242.76 | 0.00 | 28,242.76 | 1.0000 | 28,242.76 | 0.00 | Paid |
|---|
| 131 | 132 | INV-10130 | C-0012 | Olallie Market | 01/27/2026 | 02/26/2026 | Net 30 | USD | 23,546.12 | 0.00 | 23,546.12 | 1.0000 | 23,546.12 | 0.00 | Paid |
|---|
| 132 | 133 | INV-10131 | C-0008 | Alder Cantina | 01/26/2026 | 02/10/2026 | Net 15 | USD | 1,176.23 | 0.00 | 1,176.23 | 1.0000 | 1,176.23 | 0.00 | Paid |
|---|
| 133 | 134 | INV-10132 | C-0207 | Wildwood Tavern | 01/27/2026 | 02/11/2026 | Net 15 | USD | 2,944.57 | 0.00 | 2,944.57 | 1.0000 | 2,944.57 | 0.00 | Paid |
|---|
| 134 | 135 | INV-10133 | C-0355 | Jackdaw Kitchen | 01/27/2026 | 02/11/2026 | Net 15 | USD | 2,104.32 | 0.00 | 2,104.32 | 1.0000 | 2,104.32 | 0.00 | Paid |
|---|
| 135 | 136 | INV-10134 | C-0414 | Belmont Natural Foods | 02/02/2026 | 03/04/2026 | Net 30 | USD | 17,925.31 | 0.00 | 17,925.31 | 1.0000 | 17,925.31 | 0.00 | Paid |
|---|
| 136 | 137 | INV-10135 | C-0301 | Alpenkost GmbH | 02/19/2026 | 05/20/2026 | Net 90 | EUR | 7,327.85 | 0.00 | 7,327.85 | 1.0826 | 7,933.13 | 0.00 | Paid |
|---|
| 137 | 138 | INV-10136 | C-0047 | Gable Brasserie | 01/26/2026 | 02/10/2026 | Net 15 | USD | 2,048.80 | 0.00 | 2,048.80 | 1.0000 | 2,048.80 | 0.00 | Paid |
|---|
| 138 | 139 | INV-10137 | C-0105 | Whidbey Harvest Co-op | 01/26/2026 | 02/25/2026 | Net 30 | USD | 22,021.92 | 0.00 | 22,021.92 | 1.0000 | 22,021.92 | 0.00 | Paid |
|---|
| 139 | 140 | INV-10138 | C-0122 | Owyhee Mercantile | 01/26/2026 | 02/25/2026 | Net 30 | USD | 25,699.62 | 0.00 | 25,699.62 | 1.0000 | 25,699.62 | 0.00 | Paid |
|---|
| 140 | 141 | INV-10139 | C-0264 | Vale Brasserie | 01/26/2026 | 02/10/2026 | Net 15 | USD | 2,444.12 | 0.00 | 2,444.12 | 1.0000 | 2,444.12 | 0.00 | Paid |
|---|
| 141 | 142 | INV-10140 | C-0325 | Cobalt Cafe | 01/26/2026 | 02/10/2026 | Net 15 | USD | 2,410.22 | 0.00 | 2,410.22 | 1.0000 | 2,410.22 | 0.00 | Paid |
|---|
| 142 | 143 | INV-10141 | C-0425 | Thistle Pizzeria | 01/26/2026 | 02/10/2026 | Net 15 | USD | 1,726.37 | 0.00 | 1,726.37 | 1.0000 | 1,726.37 | 0.00 | Paid |
|---|
| 143 | 144 | INV-10142 | C-0295 | Zephyr Bakery | 01/27/2026 | 02/11/2026 | Net 15 | USD | 3,334.78 | 0.00 | 3,334.78 | 1.0000 | 3,334.78 | 0.00 | Paid |
|---|
| 144 | 145 | INV-10143 | C-0040 | Parsnip Pizzeria | 01/28/2026 | 02/12/2026 | Net 15 | USD | 4,034.80 | 0.00 | 4,034.80 | 1.0000 | 4,034.80 | 0.00 | Paid |
|---|
| 145 | 146 | INV-10144 | C-0330 | Alder Street Market | 01/30/2026 | 03/01/2026 | Net 30 | USD | 16,639.26 | 0.00 | 16,639.26 | 1.0000 | 16,639.26 | 0.00 | Paid |
|---|
| 146 | 147 | INV-10145 | C-0088 | Palouse Provisions | 02/02/2026 | 03/04/2026 | Net 30 | USD | 17,217.68 | 0.00 | 17,217.68 | 1.0000 | 17,217.68 | 0.00 | Paid |
|---|
| 147 | 148 | INV-10146 | C-0069 | Riverbend Natural Grocers | 01/28/2026 | 02/27/2026 | Net 30 | USD | 14,278.74 | 0.00 | 14,278.74 | 1.0000 | 14,278.74 | 0.00 | Paid |
|---|
| 148 | 149 | INV-10147 | C-0129 | Anchor Pizzeria | 01/28/2026 | 02/12/2026 | Net 15 | USD | 1,667.20 | 0.00 | 1,667.20 | 1.0000 | 1,667.20 | 0.00 | Paid |
|---|
| 149 | 150 | INV-10148 | C-0334 | Isle Smokehouse | 01/28/2026 | 02/12/2026 | Net 15 | USD | 2,353.10 | 0.00 | 2,353.10 | 1.0000 | 2,353.10 | 0.00 | Paid |
|---|
| 150 | 151 | INV-10149 | C-0102 | Indigo Deli | 01/29/2026 | 02/13/2026 | Net 15 | USD | 2,929.56 | 0.00 | 2,929.56 | 1.0000 | 2,929.56 | 0.00 | Paid |
|---|
| 151 | 152 | INV-10150 | C-0064 | Juniper Hill Foods | 01/30/2026 | 03/01/2026 | Net 30 | USD | 21,526.81 | 0.00 | 21,526.81 | 1.0000 | 21,526.81 | 0.00 | Paid |
|---|
| 152 | 153 | INV-10151 | C-0379 | Filbert & Oak Market | 02/02/2026 | 03/04/2026 | Net 30 | USD | 21,569.17 | 0.00 | 21,569.17 | 1.0000 | 21,569.17 | 0.00 | Paid |
|---|
| 153 | 154 | INV-10152 | C-0415 | Kestrel Market Hall | 02/02/2026 | 03/04/2026 | Net 30 | USD | 23,169.81 | 0.00 | 23,169.81 | 1.0000 | 23,169.81 | 0.00 | Paid |
|---|
| 154 | 155 | INV-10153 | C-0096 | Pioneer Square Provisions | 02/03/2026 | 03/05/2026 | Net 30 | USD | 22,449.62 | 0.00 | 22,449.62 | 1.0000 | 22,449.62 | 0.00 | Paid |
|---|
| 155 | 156 | INV-10154 | C-0306 | Tillamook Road Grocery | 02/04/2026 | 03/06/2026 | Net 30 | USD | 11,928.82 | 0.00 | 11,928.82 | 1.0000 | 11,928.82 | 0.00 | Paid |
|---|
| 156 | 157 | INV-10155 | C-0027 | Cascade Harvest Grocers | 01/28/2026 | 02/27/2026 | Net 30 | USD | 17,584.48 | 0.00 | 17,584.48 | 1.0000 | 17,584.48 | 0.00 | Paid |
|---|
| 157 | 158 | INV-10156 | C-0076 | Thimbleberry Eatery | 01/28/2026 | 02/12/2026 | Net 15 | USD | 3,299.57 | 0.00 | 3,299.57 | 1.0000 | 3,299.57 | 0.00 | Paid |
|---|
| 158 | 159 | INV-10157 | C-0136 | Redtail Brasserie | 01/28/2026 | 02/12/2026 | Net 15 | USD | 2,912.70 | 0.00 | 2,912.70 | 1.0000 | 2,912.70 | 0.00 | Paid |
|---|
| 159 | 160 | INV-10158 | C-0348 | Foxglove Market | 01/28/2026 | 02/27/2026 | Net 30 | USD | 20,363.41 | 0.00 | 20,363.41 | 1.0000 | 20,363.41 | 0.00 | Paid |
|---|
| 160 | 161 | INV-10159 | C-0276 | Mossy Rock Taproom | 01/29/2026 | 02/13/2026 | Net 15 | USD | 2,756.06 | 0.00 | 2,756.06 | 1.0000 | 2,756.06 | 0.00 | Paid |
|---|
| 161 | 162 | INV-10160 | C-0031 | Oyster Taproom | 01/30/2026 | 02/14/2026 | Net 15 | USD | 3,386.36 | 0.00 | 3,386.36 | 1.0000 | 3,386.36 | 0.00 | Paid |
|---|
Showing 112–161 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 |
|---|