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 | Payment No | Type | Date | Name ID | Name | Method | Check/Ref No | Currency | Amount | Exchange Rate | Amount (USD) | Applied To | Applied Amount | Unapplied |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1274 | 1275 | PMT-31337 | Receipt | 01/19/2026 | C-0273 | Coldwater Creek Market | CHECK | 5835 | USD | 11,542.68 | 1.0000 | 11,542.68 |
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 |
|---|---|---|---|---|---|
| Payment No | 0 | 1971 | 10 | — | 0 |
| Type | 0 | 2 | 12 | — | 0 |
| Date | 0 | 132 | 10 | date mm dd yyyy 2054 | 838 |
| Name ID | 0 | 260 |
| INV-9942 |
| 11,542.68 |
| 0.00 |
| 1275 | 1276 | PMT-31338 | Receipt | 01/19/2026 | C-0275 | Tamarack Smokehouse | CHECK | 2934 | USD | 863.93 | 1.0000 | 863.93 | INV-9996 | 863.93 | 0.00 |
|---|
| 1276 | 1277 | PMT-31339 | Receipt | 01/19/2026 | C-0278 | Sorrel Cantina | CHECK | 8295 | USD | 3,242.64 | 1.0000 | 3,242.64 | INV-9983 | 3,242.64 | 0.00 |
|---|
| 1277 | 1278 | PMT-31340 | Receipt | 01/19/2026 | C-0296 | Bluebird Smokehouse | CHECK | 6465 | USD | 1,876.35 | 1.0000 | 1,876.35 | INV-9997 | 1,876.35 | 0.00 |
|---|
| 1278 | 1279 | PMT-31341 | Receipt | 01/19/2026 | C-0335 | Mountain Grocers Inc. | CHECK | 9466 | USD | 25,057.19 | 1.0000 | 25,057.19 | INV-9911 | 25,057.19 | 0.00 |
|---|
| 1279 | 1280 | PMT-31342 | Receipt | 01/19/2026 | C-0349 | Dovetail Taproom | ACH | 012825307538013 | USD | 2,076.85 | 1.0000 | 2,076.85 | INV-9999 | 2,076.85 | 0.00 |
|---|
| 1280 | 1281 | PMT-31343 | Receipt | 01/19/2026 | C-0379 | Filbert & Oak Market | ACH | 089927580633966 | USD | 27,887.86 | 1.0000 | 27,887.86 | INV-9928 | 27,887.86 | 0.00 |
|---|
| 1281 | 1282 | PMT-31344 | Receipt | 01/19/2026 | C-0389 | Umpqua Valley Foods | ACH | 359187276633855 | USD | 21,040.73 | 1.0000 | 21,040.73 | INV-9951 | 21,040.73 | 0.00 |
|---|
| 1282 | 1283 | PMT-31345 | Receipt | 01/19/2026 | C-0420 | Nehalem Bay Grocers | CHECK | 4251 | USD | 19,905.22 | 1.0000 | 19,905.22 | INV-9899 | 19,905.22 | 0.00 |
|---|
| 1283 | 1284 | PMT-31346 | Receipt | 01/19/2026 | C-0427 | Deschutes Food Hall | ACH | 220693202087756 | USD | 23,421.31 | 1.0000 | 23,421.31 | INV-9960 | 23,421.31 | 0.00 |
|---|
| 1284 | 1285 | PMT-31347 | Receipt | 01/20/2026 | C-0027 | Cascade Harvest Grocers | CHECK | 8104 | USD | 12,453.02 | 1.0000 | 12,453.02 | INV-9964 | 12,453.02 | 0.00 |
|---|
| 1285 | 1286 | PMT-31348 | Receipt | 01/20/2026 | C-0323 | Waxwing Eatery | CHECK | 9953 | USD | 1,981.70 | 1.0000 | 1,981.70 | INV-10010 | 1,981.70 | 0.00 |
|---|
| 1286 | 1287 | PMT-31349 | Receipt | 01/20/2026 | C-0330 | Alder Street Market | ACH | 577596758008262 | USD | 12,453.75 | 1.0000 | 12,453.75 | INV-9939 | 12,453.75 | 0.00 |
|---|
| 1287 | 1288 | PMT-31350 | Receipt | 01/20/2026 | C-0378 | Yellowjacket Taproom | CHECK | 9303 | USD | 3,434.88 | 1.0000 | 3,434.88 | INV-9981 | 3,434.88 | 0.00 |
|---|
| 1288 | 1289 | PMT-31351 | Receipt | 01/21/2026 | C-0069 | Riverbend Natural Grocers | ACH | 420892168675534 | USD | 28,235.12 | 1.0000 | 28,235.12 | INV-9938 | 28,235.12 | 0.00 |
|---|
| 1289 | 1290 | PMT-31352 | Receipt | 01/21/2026 | C-0076 | Thimbleberry Eatery | CHECK | 2101 | USD | 3,600.10 | 1.0000 | 3,600.10 | INV-10015 | 3,600.10 | 0.00 |
|---|
| 1290 | 1291 | PMT-31353 | Receipt | 01/21/2026 | C-0306 | Tillamook Road Grocery | CHECK | 8099 | USD | 24,793.84 | 1.0000 | 24,793.84 | INV-9979 | 24,793.84 | 0.00 |
|---|
| 1291 | 1292 | PMT-31354 | Receipt | 01/21/2026 | C-0324 | Obsidian Grill | ACH | 396507794274792 | USD | 1,842.72 | 1.0000 | 1,842.72 | INV-9998 | 1,842.72 | 0.00 |
|---|
| 1292 | 1293 | PMT-31355 | Receipt | 01/21/2026 | C-0337 | Saffron Taproom | CHECK | 6731 | USD | 2,321.36 | 1.0000 | 2,321.36 | INV-10041 | 2,321.36 | 0.00 |
|---|
| 1293 | 1294 | PMT-31356 | Receipt | 01/21/2026 | C-0357 | Mountain Grocers LLC | ACH | 326934336395752 | USD | 27,367.32 | 1.0000 | 27,367.32 | INV-9922 | 27,367.32 | 0.00 |
|---|
| 1294 | 1295 | PMT-31357 | Receipt | 01/21/2026 | C-0414 | Belmont Natural Foods | ACH | 181682135644516 | USD | 20,507.05 | 1.0000 | 20,507.05 | INV-9953 | 20,507.05 | 0.00 |
|---|
| 1295 | 1296 | PMT-31358 | Receipt | 01/22/2026 | C-0082 | Chanterelle Supper Club | CHECK | 6279 | USD | 1,954.82 | 1.0000 | 1,954.82 | INV-9986 | 1,954.82 | 0.00 |
|---|
| 1296 | 1297 | PMT-31359 | Receipt | 01/22/2026 | C-0083 | Acorn Supper Club | CHECK | 5255 | USD | 2,342.22 | 1.0000 | 2,342.22 | INV-10028 | 2,342.22 | 0.00 |
|---|
| 1297 | 1298 | PMT-31360 | Receipt | 01/22/2026 | C-0183 | Madrona Food Co-op | ACH | 540470868184546 | USD | 22,250.98 | 1.0000 | 22,250.98 | INV-9903 | 22,250.98 | 0.00 |
|---|
| 1298 | 1299 | PMT-31361 | Receipt | 01/22/2026 | C-0381 | Rookery Cafe | ACH | 936533242421874 | USD | 4,063.79 | 1.0000 | 4,063.79 | INV-10049 | 4,063.79 | 0.00 |
|---|
| 1299 | 1300 | PMT-31362 | Receipt | 01/23/2026 | C-0237 | Plover Supper Club | CHECK | 9504 | USD | 3,190.25 | 1.0000 | 3,190.25 | INV-9995 | 3,190.25 | 0.00 |
|---|
| 1300 | 1301 | PMT-31363 | Receipt | 01/23/2026 | C-0276 | Mossy Rock Taproom | ACH | 339182660761781 | USD | 3,288.23 | 1.0000 | 3,288.23 | INV-9990 | 3,288.23 | 0.00 |
|---|
| 1301 | 1302 | PMT-31364 | Receipt | 01/23/2026 | C-0415 | Kestrel Market Hall | ACH | 866355611666005 | USD | 25,849.00 | 1.0000 | 25,849.00 | INV-9969 | 25,849.00 | 0.00 |
|---|
| 1302 | 1303 | PMT-31365 | Receipt | 01/26/2026 | C-0012 | Olallie Market | CHECK | 3183 | USD | 16,152.03 | 1.0000 | 16,152.03 | INV-9977 | 16,152.03 | 0.00 |
|---|
| 1303 | 1304 | PMT-31366 | Receipt | 01/26/2026 | C-0040 | Parsnip Pizzeria | ACH | 015734455292666 | USD | 1,168.41 | 1.0000 | 1,168.41 | INV-10023 | 1,168.41 | 0.00 |
|---|
| 1304 | 1305 | PMT-31367 | Receipt | 01/26/2026 | C-0046 | Yakima Orchard Market | ACH | 214553938886298 | USD | 25,875.31 | 1.0000 | 25,875.31 | INV-9932 | 25,875.31 | 0.00 |
|---|
| 1305 | 1306 | PMT-31368 | Receipt | 01/26/2026 | C-0082 | Chanterelle Supper Club | CHECK | 5398 | USD | 910.83 | 1.0000 | 910.83 | INV-10030 | 910.83 | 0.00 |
|---|
| 1306 | 1307 | PMT-31369 | Receipt | 01/26/2026 | C-0143 | Gorge Valley Co-op | ACH | 710622689177281 | USD | 14,459.21 | 1.0000 | 14,459.21 | INV-9959 | 14,459.21 | 0.00 |
|---|
| 1307 | 1308 | PMT-31370 | Receipt | 01/26/2026 | C-0147 | Vashon Island Market | ACH | 493860893595306 | USD | 28,408.48 | 1.0000 | 28,408.48 | INV-9971 | 28,408.48 | 0.00 |
|---|
| 1308 | 1309 | PMT-31371 | Receipt | 01/26/2026 | C-0186 | Hawthorne Fresh Market | ACH | 136384875354276 | USD | 26,764.42 | 1.0000 | 26,764.42 | INV-9955 | 26,764.42 | 0.00 |
|---|
| 1309 | 1310 | PMT-31372 | Receipt | 01/26/2026 | C-0193 | Quinault Country Store | CHECK | 3554 | USD | 28,571.94 | 1.0000 | 28,571.94 | INV-9916 | 28,571.94 | 0.00 |
|---|
| 1310 | 1311 | PMT-31373 | Receipt | 01/26/2026 | C-0198 | GREEN VALLEY COOP #2 | CHECK | 1704 | USD | 22,397.64 | 1.0000 | 22,397.64 | INV-9914 | 22,397.64 | 0.00 |
|---|
| 1311 | 1312 | PMT-31374 | Receipt | 01/26/2026 | C-0233 | Rose City Market Hall | ACH | 820899884698203 | USD | 14,939.30 | 1.0000 | 14,939.30 | INV-9950 | 14,939.30 | 0.00 |
|---|
| 1312 | 1313 | PMT-31375 | Receipt | 01/26/2026 | C-0331 | Ironwood Grocery | ACH | 875065296521406 | USD | 13,178.94 | 1.0000 | 13,178.94 | INV-9933 | 13,178.94 | 0.00 |
|---|
| 1313 | 1314 | PMT-31376 | Receipt | 01/26/2026 | C-0353 | Uproot Cafe | ACH | 333276458363869 | USD | 1,539.17 | 1.0000 | 1,539.17 | INV-10000 | 1,539.17 | 0.00 |
|---|
| 1314 | 1315 | PMT-31377 | Receipt | 01/26/2026 | C-0400 | Salmonberry Market | CHECK | 4622 | USD | 14,264.15 | 1.0000 | 14,264.15 | INV-9921 | 14,264.15 | 0.00 |
|---|
| 1315 | 1316 | PMT-31378 | Receipt | 01/26/2026 | C-0411 | Iris Taproom | ACH | 999354758399799 | USD | 1,593.98 | 1.0000 | 1,593.98 | INV-10059 | 1,593.98 | 0.00 |
|---|
| 1316 | 1317 | PMT-31379 | Receipt | 01/26/2026 | C-0425 | Thistle Pizzeria | CHECK | 8558 | USD | 3,788.52 | 1.0000 | 3,788.52 | INV-9992 | 1,452.04 | 0.00 |
|---|
| 1317 | 1318 | PMT-31379 | Receipt | 01/26/2026 | C-0425 | Thistle Pizzeria | CHECK | 8558 | USD | 3,788.52 | 1.0000 | 3,788.52 | INV-10055 | 2,336.48 |
|---|
| 1318 | 1319 | PMT-31380 | Receipt | 01/27/2026 | C-0122 | Owyhee Mercantile | ACH | 610028158938326 | USD | 21,083.67 | 1.0000 | 21,083.67 | INV-9940 | 21,083.67 | 0.00 |
|---|
| 1319 | 1320 | PMT-31381 | Receipt | 01/28/2026 | C-0135 | Vine Bistro | CHECK | 9783 | USD | 4,001.12 | 1.0000 | 4,001.12 | INV-10069 | 4,001.12 | 0.00 |
|---|
| 1320 | 1321 | PMT-31382 | Receipt | 01/28/2026 | C-0221 | Kiln Deli | CHECK | 2163 | USD | 2,711.03 | 1.0000 | 2,711.03 | INV-10013 | 2,711.03 | 0.00 |
|---|
| 1321 | 1322 | PMT-31383 | Receipt | 01/28/2026 | C-0396 | Driftwood Pantry | ACH | 681139633075095 | USD | 11,041.27 | 1.0000 | 11,041.27 | INV-9943 | 11,041.27 | 0.00 |
|---|
| 1322 | 1323 | PMT-31384 | Receipt | 01/28/2026 | C-0415 | Kestrel Market Hall | ACH | 094814720662534 | USD | 25,029.58 | 1.0000 | 25,029.58 | INV-10018 | 25,029.58 | 0.00 |
|---|
| 1323 | 1324 | PMT-31385 | Receipt | 01/29/2026 | C-0050 | Aster Kitchen | ACH | 644479064406774 | USD | 3,906.86 | 1.0000 | 3,906.86 | INV-10029 | 3,906.86 | 0.00 |
|---|
Showing 1274–1323 of 2054 rows
| 6 |
| — |
| 0 |
| Name | 0 | 260 | 31 | — | 0 |
|---|
| Method | 0 | 3 | 5 | — | 0 |
|---|
| Check/Ref No | 0 | 1962 | 15 | integer 2047 | 0 |
|---|
| Currency | 0 | 2 | 3 | — | 0 |
|---|
| Amount | 0 | 1954 | 9 | decimal 109, amount grouped 1945 | 0 |
|---|
| Exchange Rate | 0 | 7 | 6 | decimal 2054 | 0 |
|---|
| Amount (USD) | 0 | 1954 | 9 | decimal 109, amount grouped 1945 | 0 |
|---|
| Applied To | 0 | 2054 | 9 | — | 0 |
|---|
| Applied Amount | 0 | 2037 | 9 | decimal 113, amount grouped 1941 | 0 |
|---|
| Unapplied | 83 | 2 | 8 | decimal 1970, amount grouped 1 | 0 |
|---|