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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 493 | 494 | INV-10492 | C-0406 | Wharf Cantina | 04/06/2026 | 04/21/2026 | Net 15 | USD | 2,723.76 | 0.00 | 2,723.76 | 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 |
| 2,723.76 |
| 0.00 |
| Paid |
| 494 | 495 | INV-10493 | C-0064 | Juniper Hill Foods | 04/07/2026 | 05/07/2026 | Net 30 | USD | 17,562.79 | 0.00 | 17,562.79 | 1.0000 | 17,562.79 | 0.00 | Paid |
|---|
| 495 | 496 | INV-10494 | C-0069 | Riverbend Natural Grocers | 04/07/2026 | 05/07/2026 | Net 30 | USD | 15,402.42 | 0.00 | 15,402.42 | 1.0000 | 15,402.42 | 0.00 | Paid |
|---|
| 496 | 497 | INV-10495 | C-0105 | Whidbey Harvest Co-op | 04/07/2026 | 05/07/2026 | Net 30 | USD | 17,108.04 | 0.00 | 17,108.04 | 1.0000 | 17,108.04 | 0.00 | Paid |
|---|
| 497 | 498 | INV-10496 | C-0237 | Plover Supper Club | 04/07/2026 | 04/22/2026 | Net 15 | USD | 3,261.65 | 0.00 | 3,261.65 | 1.0000 | 3,261.65 | 0.00 | Paid |
|---|
| 498 | 499 | INV-10497 | C-0261 | Harbor Tavern | 04/08/2026 | 04/23/2026 | Net 15 | USD | 1,984.46 | 0.00 | 1,984.46 | 1.0000 | 1,984.46 | 0.00 | Paid |
|---|
| 499 | 500 | INV-10498 | C-0369 | Eddy Pizzeria | 04/08/2026 | 04/23/2026 | Net 15 | USD | 2,229.04 | 0.00 | 2,229.04 | 1.0000 | 2,229.04 | 0.00 | Paid |
|---|
| 500 | 501 | INV-10499 | C-0045 | Bridgetown Pantry | 04/13/2026 | 05/13/2026 | Net 30 | USD | 27,823.40 | 0.00 | 27,823.40 | 1.0000 | 27,823.40 | 0.00 | Paid |
|---|
| 501 | 502 | INV-10500 | C-0089 | Kinfolk Pizzeria | 04/07/2026 | 04/22/2026 | Net 15 | USD | 3,323.82 | 0.00 | 3,323.82 | 1.0000 | 3,323.82 | 0.00 | Paid |
|---|
| 502 | 503 | INV-10501 | C-0208 | Ursa Noodle House | 04/08/2026 | 04/23/2026 | Net 15 | USD | 1,721.60 | 0.00 | 1,721.60 | 1.0000 | 1,721.60 | 0.00 | Paid |
|---|
| 503 | 504 | INV-10502 | C-0390 | Dogwood Bistro | 04/08/2026 | 04/23/2026 | Net 15 | USD | 3,223.65 | 0.00 | 3,223.65 | 1.0000 | 3,223.65 | 0.00 | Paid |
|---|
| 504 | 505 | INV-10503 | C-0400 | Salmonberry Market | 04/08/2026 | 05/08/2026 | Net 30 | USD | 14,718.34 | 0.00 | 14,718.34 | 1.0000 | 14,718.34 | 0.00 | Paid |
|---|
| 505 | 506 | INV-10504 | C-0200 | Ember Lane Grocers | 04/10/2026 | 05/10/2026 | Net 30 | USD | 17,070.41 | 0.00 | 17,070.41 | 1.0000 | 17,070.41 | 0.00 | Paid |
|---|
| 506 | 507 | INV-10505 | C-0154 | Green Valley Cooperative Market | 04/13/2026 | 05/13/2026 | Net 30 | USD | 13,130.59 | 0.00 | 13,130.59 | 1.0000 | 13,130.59 | 0.00 | Paid |
|---|
| 507 | 508 | INV-10506 | C-0301 | Alpenkost GmbH | 05/26/2026 | 08/24/2026 | Net 90 | EUR | 11,239.37 | 0.00 | 11,239.37 | 1.1124 | 12,502.68 | 11,239.37 | Open |
|---|
| 508 | 509 | INV-10507 | C-0037 | Bellwether Tavern | 04/08/2026 | 04/23/2026 | Net 15 | USD | 1,118.39 | 0.00 | 1,118.39 | 1.0000 | 1,118.39 | 0.00 | Paid |
|---|
| 509 | 510 | INV-10508 | C-0136 | Redtail Brasserie | 04/08/2026 | 04/23/2026 | Net 15 | USD | 1,859.03 | 0.00 | 1,859.03 | 1.0000 | 1,859.03 | 0.00 | Paid |
|---|
| 510 | 511 | INV-10509 | C-0047 | Gable Brasserie | 04/10/2026 | 04/25/2026 | Net 15 | USD | 3,288.07 | 0.00 | 3,288.07 | 1.0000 | 3,288.07 | 0.00 | Paid |
|---|
| 511 | 512 | INV-10510 | C-0121 | Upland Kitchen | 04/10/2026 | 04/25/2026 | Net 15 | USD | 3,430.57 | 0.00 | 3,430.57 | 1.0000 | 3,430.57 | 0.00 | Paid |
|---|
| 512 | 513 | INV-10511 | C-0204 | Foundry Bakery | 04/10/2026 | 04/25/2026 | Net 15 | USD | 2,450.20 | 0.00 | 2,450.20 | 1.0000 | 2,450.20 | 0.00 | Paid |
|---|
| 513 | 514 | INV-10512 | C-0297 | Canopy Deli | 04/10/2026 | 04/25/2026 | Net 15 | USD | 788.25 | 0.00 | 788.25 | 1.0000 | 788.25 | 0.00 | Paid |
|---|
| 514 | 515 | INV-10513 | C-0396 | Driftwood Pantry | 04/14/2026 | 05/14/2026 | Net 30 | USD | 25,736.54 | 0.00 | 25,736.54 | 1.0000 | 25,736.54 | 0.00 | Paid |
|---|
| 515 | 516 | INV-10514 | C-0428 | Birchwood Bistro | 04/10/2026 | 04/25/2026 | Net 15 | USD | 3,549.64 | 0.00 | 3,549.64 | 1.0000 | 3,549.64 | 0.00 | Paid |
|---|
| 516 | 517 | INV-10515 | C-0379 | Filbert & Oak Market | 04/16/2026 | 05/16/2026 | Net 30 | USD | 13,443.71 | 0.00 | 13,443.71 | 1.0000 | 13,443.71 | 0.00 | Paid |
|---|
| 517 | 518 | INV-10516 | C-0414 | Belmont Natural Foods | 04/17/2026 | 05/17/2026 | Net 30 | USD | 23,124.59 | 0.00 | 23,124.59 | 1.0000 | 23,124.59 | 0.00 | Paid |
|---|
| 518 | 519 | INV-10517 | C-0331 | Ironwood Grocery | 04/13/2026 | 05/13/2026 | Net 30 | USD | 20,370.14 | 0.00 | 20,370.14 | 1.0000 | 20,370.14 | 0.00 | Paid |
|---|
| 519 | 520 | INV-10518 | C-0014 | Rivet Supper Club | 04/13/2026 | 04/28/2026 | Net 15 | USD | 1,844.79 | 0.00 | 1,844.79 | 1.0000 | 1,844.79 | 0.00 | Paid |
|---|
| 520 | 521 | INV-10519 | C-0365 | Quarry Bistro | 04/13/2026 | 04/28/2026 | Net 15 | USD | 1,331.67 | 0.00 | 1,331.67 | 1.0000 | 1,331.67 | 0.00 | Paid |
|---|
| 521 | 522 | INV-10520 | C-0357 | Mountain Grocers LLC | 04/14/2026 | 05/14/2026 | Net 30 | USD | 21,933.71 | 0.00 | 21,933.71 | 1.0000 | 21,933.71 | 0.00 | Paid |
|---|
| 522 | 523 | INV-10521 | C-0186 | Hawthorne Fresh Market | 04/15/2026 | 05/15/2026 | Net 30 | USD | 19,367.27 | 0.00 | 19,367.27 | 1.0000 | 19,367.27 | 0.00 | Paid |
|---|
| 523 | 524 | INV-10522 | C-0198 | GREEN VALLEY COOP #2 | 04/20/2026 | 05/20/2026 | Net 30 | USD | 18,863.48 | 0.00 | 18,863.48 | 1.0000 | 18,863.48 | 0.00 | Paid |
|---|
| 524 | 525 | INV-10523 | C-0330 | Alder Street Market | 04/20/2026 | 05/20/2026 | Net 30 | USD | 21,678.85 | 0.00 | 21,678.85 | 1.0000 | 21,678.85 | 0.00 | Paid |
|---|
| 525 | 526 | INV-10524 | C-0122 | Owyhee Mercantile | 04/13/2026 | 05/13/2026 | Net 30 | USD | 21,869.83 | 0.00 | 21,869.83 | 1.0000 | 21,869.83 | 0.00 | Paid |
|---|
| 526 | 527 | INV-10525 | C-0146 | Jetty Tavern | 04/13/2026 | 04/28/2026 | Net 15 | USD | 2,562.11 | 0.00 | 2,562.11 | 1.0000 | 2,562.11 | 0.00 | Paid |
|---|
| 527 | 528 | INV-10526 | C-0177 | Quarterdeck Tavern | 04/13/2026 | 04/28/2026 | Net 15 | USD | 1,272.36 | 0.00 | 1,272.36 | 1.0000 | 1,272.36 | 0.00 | Paid |
|---|
| 528 | 529 | INV-10527 | C-0189 | Ironclad Brasserie | 04/13/2026 | 04/28/2026 | Net 15 | USD | 3,541.41 | 0.00 | 3,541.41 | 1.0000 | 3,541.41 | 0.00 | Paid |
|---|
| 529 | 530 | INV-10528 | C-0281 | Tidewater Deli | 04/13/2026 | 04/28/2026 | Net 15 | USD | 1,476.37 | 0.00 | 1,476.37 | 1.0000 | 1,476.37 | 0.00 | Paid |
|---|
| 530 | 531 | INV-10529 | C-0298 | Nimbus Cafe | 04/13/2026 | 04/28/2026 | Net 15 | USD | 2,645.37 | 0.00 | 2,645.37 | 1.0000 | 2,645.37 | 0.00 | Paid |
|---|
| 531 | 532 | INV-10530 | C-0193 | Quinault Country Store | 04/16/2026 | 05/16/2026 | Net 30 | USD | 12,232.81 | 0.00 | 12,232.81 | 1.0000 | 12,232.81 | 0.00 | Paid |
|---|
| 532 | 533 | INV-10531 | C-0233 | Rose City Market Hall | 04/16/2026 | 05/16/2026 | Net 30 | USD | 20,075.79 | 0.00 | 20,075.79 | 1.0000 | 20,075.79 | 0.00 | Paid |
|---|
| 533 | 534 | INV-10532 | C-0090 | Zigzag Mountain Grocery | 04/20/2026 | 05/20/2026 | Net 30 | USD | 11,085.11 | 0.00 | 11,085.11 | 1.0000 | 11,085.11 | 0.00 | Paid |
|---|
| 534 | 535 | INV-10533 | C-0163 | Elk Rock Provisions | 04/21/2026 | 05/21/2026 | Net 30 | USD | 23,060.37 | 0.00 | 23,060.37 | 1.0000 | 23,060.37 | 0.00 | Paid |
|---|
| 535 | 536 | INV-10534 | C-0411 | Iris Taproom | 04/13/2026 | 04/28/2026 | Net 15 | USD | 3,631.28 | 0.00 | 3,631.28 | 1.0000 | 3,631.28 | 0.00 | Paid |
|---|
| 536 | 537 | INV-10535 | C-0145 | Hearth Cantina | 04/14/2026 | 04/29/2026 | Net 15 | USD | 719.22 | 0.00 | 719.22 | 1.0000 | 719.22 | 0.00 | Paid |
|---|
| 537 | 538 | INV-10536 | C-0147 | Vashon Island Market | 04/15/2026 | 05/15/2026 | Net 30 | USD | 13,833.21 | 0.00 | 13,833.21 | 1.0000 | 13,833.21 | 0.00 | Paid |
|---|
| 538 | 539 | INV-10537 | C-0399 | Larch Mountain Mercantile | 04/16/2026 | 05/16/2026 | Net 30 | USD | 15,429.41 | 0.00 | 15,429.41 | 1.0000 | 15,429.41 | 0.00 | Paid |
|---|
| 539 | 540 | INV-10538 | C-0033 | Treasure Valley Market | 04/20/2026 | 05/20/2026 | Net 30 | USD | 27,765.59 | 0.00 | 27,765.59 | 1.0000 | 27,765.59 | 0.00 | Paid |
|---|
| 540 | 541 | INV-10539 | C-0133 | Sawtooth Natural Foods | 04/20/2026 | 05/20/2026 | Net 30 | USD | 21,418.70 | 0.00 | 21,418.70 | 1.0000 | 21,418.70 | 0.00 | Paid |
|---|
| 541 | 542 | INV-10540 | C-0143 | Gorge Valley Co-op | 04/20/2026 | 05/20/2026 | Net 30 | USD | 16,168.35 | 0.00 | 16,168.35 | 1.0000 | 16,168.35 | 0.00 | Paid |
|---|
| 542 | 543 | INV-10541 | C-0218 | Undertow Bakery | 04/14/2026 | 04/29/2026 | Net 15 | USD | 4,192.04 | 0.00 | 4,192.04 | 1.0000 | 4,192.04 | 0.00 | Paid |
|---|
Showing 493–542 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 |
|---|