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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 36 | C-0090 | Zigzag Mountain Grocery | Invoice | INV-10818 | 06/16/2026 | 07/16/2026 | USD | 25,329.28 | 25,329.28 |
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 |
| 36 | 37 | C-0090 | Zigzag Mountain Grocery | Invoice | INV-10884 | 06/29/2026 | 07/29/2026 | USD | 22,790.07 | 22,790.07 |
|---|
| 37 | 38 | C-0096 | Pioneer Square Provisions | Invoice | INV-10741 | 06/01/2026 | 07/01/2026 | USD | 24,245.29 | 24,245.29 |
|---|
| 38 | 39 | C-0096 | Pioneer Square Provisions | Invoice | INV-10808 | 06/17/2026 | 07/17/2026 | USD | 21,354.06 | 21,354.06 |
|---|
| 39 | 40 | C-0102 | Indigo Deli | Invoice | INV-10826 | 06/17/2026 | 07/02/2026 | USD | 3,394.22 | 3,394.22 |
|---|
| 40 | 41 | C-0102 | Indigo Deli | Invoice | INV-10839 | 06/19/2026 | 07/04/2026 | USD | 3,668.83 | 3,668.83 |
|---|
| 41 | 42 | C-0105 | Whidbey Harvest Co-op | Invoice | INV-10782 | 06/10/2026 | 07/10/2026 | USD | 19,487.39 | 19,487.39 |
|---|
| 42 | 43 | C-0105 | Whidbey Harvest Co-op | Invoice | INV-10865 | 06/24/2026 | 07/24/2026 | USD | 26,294.77 | 26,294.77 |
|---|
| 43 | 44 | C-0107 | Green Valley Co-op | Invoice | INV-10737 | 05/26/2026 | 06/25/2026 | USD | 17,716.88 | 17,716.88 |
|---|
| 44 | 45 | C-0107 | Green Valley Co-op | Invoice | INV-10801 | 06/11/2026 | 07/11/2026 | USD | 25,515.70 | 25,515.70 |
|---|
| 45 | 46 | C-0107 | Green Valley Co-op | Invoice | INV-10836 | 06/24/2026 | 07/24/2026 | USD | 16,907.39 | 16,907.39 |
|---|
| 46 | 47 | C-0122 | Owyhee Mercantile | Invoice | INV-10779 | 06/11/2026 | 07/11/2026 | USD | 16,177.42 | 16,177.42 |
|---|
| 47 | 48 | C-0122 | Owyhee Mercantile | Invoice | INV-10845 | 06/24/2026 | 07/24/2026 | USD | 26,912.41 | 26,912.41 |
|---|
| 48 | 49 | C-0133 | Sawtooth Natural Foods | Invoice | INV-10753 | 06/01/2026 | 07/01/2026 | USD | 24,896.19 | 24,896.19 |
|---|
| 49 | 50 | C-0133 | Sawtooth Natural Foods | Invoice | INV-10791 | 06/15/2026 | 07/15/2026 | USD | 24,146.77 | 24,146.77 |
|---|
| 50 | 51 | C-0133 | Sawtooth Natural Foods | Invoice | INV-10874 | 06/29/2026 | 07/29/2026 | USD | 28,456.37 | 28,456.37 |
|---|
| 51 | 52 | C-0139 | Greenhouse Bistro | Invoice | INV-10855 | 06/23/2026 | 07/08/2026 | USD | 1,269.80 | 1,269.80 |
|---|
| 52 | 53 | C-0142 | Sextant Bakery | Invoice | INV-10783 | 06/08/2026 | 06/23/2026 | USD | 3,702.34 | 3,702.34 |
|---|
| 53 | 54 | C-0143 | Gorge Valley Co-op | Invoice | INV-10728 | 06/01/2026 | 07/01/2026 | USD | 14,422.98 | 14,422.98 |
|---|
| 54 | 55 | C-0143 | Gorge Valley Co-op | Invoice | INV-10792 | 06/15/2026 | 07/15/2026 | USD | 24,214.79 | 24,214.79 |
|---|
| 55 | 56 | C-0143 | Gorge Valley Co-op | Invoice | INV-10868 | 06/29/2026 | 07/29/2026 | USD | 22,487.66 | 22,487.66 |
|---|
| 56 | 57 | C-0147 | Vashon Island Market | Invoice | INV-10726 | 05/27/2026 | 06/26/2026 | USD | 15,399.28 | 15,399.28 |
|---|
| 57 | 58 | C-0147 | Vashon Island Market | Invoice | INV-10772 | 06/08/2026 | 07/08/2026 | USD | 15,669.79 | 15,669.79 |
|---|
| 58 | 59 | C-0147 | Vashon Island Market | Invoice | INV-10821 | 06/23/2026 | 07/23/2026 | USD | 17,548.42 | 17,548.42 |
|---|
| 59 | 60 | C-0154 | Green Valley Cooperative Market | Invoice | INV-10815 | 06/19/2026 | 07/19/2026 | USD | 3,215.40 | 3,215.40 |
|---|
| 60 | 61 | C-0158 | Umber Grill | Invoice | INV-10847 | 06/22/2026 | 07/07/2026 | USD | 1,783.65 | 1,783.65 |
|---|
| 61 | 62 | C-0163 | Elk Rock Provisions | Invoice | INV-10757 | 06/04/2026 | 07/04/2026 | USD | 24,212.80 | 24,212.80 |
|---|
| 62 | 63 | C-0163 | Elk Rock Provisions | Invoice | INV-10834 | 06/22/2026 | 07/22/2026 | USD | 20,463.72 | 20,463.72 |
|---|
| 63 | 64 | C-0172 | Driftless Tavern | Invoice | INV-10858 | 06/22/2026 | 07/07/2026 | USD | 2,740.14 | 2,740.14 |
|---|
| 64 | 65 | C-0182 | Jasper Bakery | Invoice | INV-10873 | 06/25/2026 | 07/10/2026 | USD | 4,183.83 | 4,183.83 |
|---|
| 65 | 66 | C-0183 | Madrona Food Co-op | Invoice | INV-10769 | 06/04/2026 | 07/04/2026 | USD | 17,915.23 | 17,915.23 |
|---|
| 66 | 67 | C-0183 | Madrona Food Co-op | Invoice | INV-10820 | 06/19/2026 | 07/19/2026 | USD | 24,360.04 | 24,360.04 |
|---|
| 67 | 68 | C-0186 | Hawthorne Fresh Market | Invoice | INV-10727 | 05/28/2026 | 06/27/2026 | USD | 22,287.57 | 22,287.57 |
|---|
| 68 | 69 | C-0186 | Hawthorne Fresh Market | Invoice | INV-10770 | 06/10/2026 | 07/10/2026 | USD | 26,642.23 | 26,642.23 |
|---|
| 69 | 70 | C-0186 | Hawthorne Fresh Market | Invoice | INV-10864 | 06/23/2026 | 07/23/2026 | USD | 27,185.27 | 27,185.27 |
|---|
| 70 | 71 | C-0189 | Ironclad Brasserie | Invoice | INV-10833 | 06/19/2026 | 07/04/2026 | USD | 2,289.61 | 2,289.61 |
|---|
| 71 | 72 | C-0190 | Magpie Tavern | Invoice | INV-10816 | 06/15/2026 | 06/30/2026 | USD | 3,398.17 | 3,398.17 |
|---|
| 72 | 73 | C-0193 | Quinault Country Store | Invoice | INV-10760 | 06/01/2026 | 07/01/2026 | USD | 11,004.35 | 11,004.35 |
|---|
| 73 | 74 | C-0193 | Quinault Country Store | Invoice | INV-10819 | 06/16/2026 | 07/16/2026 | USD | 18,501.15 | 18,501.15 |
|---|
| 74 | 75 | C-0197 | Elderberry Deli | Invoice | INV-10848 | 06/22/2026 | 07/07/2026 | USD | 3,280.89 | 3,280.89 |
|---|
| 75 | 76 | C-0198 | GREEN VALLEY COOP #2 | Invoice | INV-10765 | 06/08/2026 | 07/08/2026 | USD | 13,535.35 | 13,535.35 |
|---|
| 76 | 77 | C-0198 | GREEN VALLEY COOP #2 | Invoice | INV-10859 | 06/22/2026 | 07/22/2026 | USD | 21,328.06 | 21,328.06 |
|---|
| 77 | 78 | C-0200 | Ember Lane Grocers | Invoice | INV-10738 | 05/26/2026 | 06/25/2026 | USD | 18,710.90 | 18,710.90 |
|---|
| 78 | 79 | C-0200 | Ember Lane Grocers | Invoice | INV-10784 | 06/08/2026 | 07/08/2026 | USD | 18,048.28 | 18,048.28 |
|---|
| 79 | 80 | C-0200 | Ember Lane Grocers | Invoice | INV-10844 | 06/23/2026 | 07/23/2026 | USD | 14,277.58 | 14,277.58 |
|---|
| 80 | 81 | C-0207 | Wildwood Tavern | Invoice | INV-10851 | 06/22/2026 | 07/07/2026 | USD | 1,761.49 | 1,761.49 |
|---|
| 81 | 82 | C-0209 | Kelp Grill | Invoice | INV-10828 | 06/17/2026 | 07/02/2026 | USD | 862.53 | 862.53 |
|---|
| 82 | 83 | C-0215 | Nook Eatery | Invoice | INV-10810 | 06/15/2026 | 06/30/2026 | USD | 1,432.16 | 1,432.16 |
|---|
| 83 | 84 | C-0215 | Nook Eatery | Invoice | INV-10860 | 06/22/2026 | 07/07/2026 | USD | 3,192.39 | 3,192.39 |
|---|
| 84 | 85 | C-0233 | Rose City Market Hall | Invoice | INV-10776 | 06/08/2026 | 07/08/2026 | USD | 19,104.72 | 19,104.72 |
|---|
Showing 35–84 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 |
|---|