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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51 | 52 | C-0133 | Sawtooth Natural Foods | Invoice | INV-9941 | 12/22/2025 | 01/21/2026 | USD | 25,261.60 | 25,261.60 |
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 | 112 | 6 | — | 0 |
| Customer | 0 | 113 | 25 | — | 0 |
| Type | 1 | 1 | 7 | — | 0 |
| Num | 1 | 151 | 9 |
| 52 | 53 | C-0135 | Vine Bistro | Invoice | INV-9944 | 12/17/2025 | 01/01/2026 | USD | 3,748.06 | 3,748.06 |
|---|
| 53 | 54 | C-0136 | Redtail Brasserie | Invoice | INV-9902 | 12/11/2025 | 12/26/2025 | USD | 3,834.56 | 3,834.56 |
|---|
| 54 | 55 | C-0143 | Gorge Valley Co-op | Invoice | INV-9868 | 12/08/2025 | 01/07/2026 | USD | 24,120.85 | 24,120.85 |
|---|
| 55 | 56 | C-0143 | Gorge Valley Co-op | Invoice | INV-9959 | 12/22/2025 | 01/21/2026 | USD | 14,459.21 | 14,459.21 |
|---|
| 56 | 57 | C-0146 | Jetty Tavern | Invoice | INV-9972 | 12/23/2025 | 01/07/2026 | USD | 1,830.73 | 1,830.73 |
|---|
| 57 | 58 | C-0147 | Vashon Island Market | Invoice | INV-9883 | 12/05/2025 | 01/04/2026 | USD | 12,339.91 | 12,339.91 |
|---|
| 58 | 59 | C-0147 | Vashon Island Market | Invoice | INV-9971 | 12/22/2025 | 01/21/2026 | USD | 28,408.48 | 28,408.48 |
|---|
| 59 | 60 | C-0155 | Lodestar Cafe | Invoice | INV-9945 | 12/18/2025 | 01/02/2026 | USD | 3,336.33 | 3,336.33 |
|---|
| 60 | 61 | C-0156 | Hollow Noodle House | Invoice | INV-10005 | 12/29/2025 | 01/13/2026 | USD | 1,922.99 | 1,922.99 |
|---|
| 61 | 62 | C-0158 | Umber Grill | Invoice | INV-9961 | 12/19/2025 | 01/03/2026 | USD | 2,434.19 | 2,434.19 |
|---|
| 62 | 63 | C-0163 | Elk Rock Provisions | Invoice | INV-9874 | 12/10/2025 | 01/09/2026 | USD | 18,467.16 | 18,467.16 |
|---|
| 63 | 64 | C-0163 | Elk Rock Provisions | Invoice | INV-9975 | 12/23/2025 | 01/22/2026 | USD | 16,708.78 | 16,708.78 |
|---|
| 64 | 65 | C-0177 | Quarterdeck Tavern | Invoice | INV-9967 | 12/22/2025 | 01/06/2026 | USD | 2,525.93 | 2,525.93 |
|---|
| 65 | 66 | C-0183 | Madrona Food Co-op | Invoice | INV-9871 | 12/04/2025 | 01/03/2026 | USD | 13,392.73 | 13,392.73 |
|---|
| 66 | 67 | C-0183 | Madrona Food Co-op | Invoice | INV-9903 | 12/17/2025 | 01/16/2026 | USD | 22,250.98 | 22,250.98 |
|---|
| 67 | 68 | C-0186 | Hawthorne Fresh Market | Invoice | INV-9856 | 12/04/2025 | 01/03/2026 | USD | 25,894.56 | 25,894.56 |
|---|
| 68 | 69 | C-0186 | Hawthorne Fresh Market | Invoice | INV-9955 | 12/18/2025 | 01/17/2026 | USD | 26,764.42 | 26,764.42 |
|---|
| 69 | 70 | C-0189 | Ironclad Brasserie | Invoice | INV-9948 | 12/19/2025 | 01/03/2026 | USD | 3,271.05 | 3,271.05 |
|---|
| 70 | 71 | C-0190 | Magpie Tavern | Invoice | INV-9897 | 12/09/2025 | 12/24/2025 | USD | 2,224.26 | 2,224.26 |
|---|
| 71 | 72 | C-0191 | Riverstone Smokehouse | Invoice | INV-9988 | 12/29/2025 | 01/13/2026 | USD | 1,466.70 | 1,466.70 |
|---|
| 72 | 73 | C-0193 | Quinault Country Store | Invoice | INV-9875 | 12/04/2025 | 01/03/2026 | USD | 26,756.65 | 26,756.65 |
|---|
| 73 | 74 | C-0193 | Quinault Country Store | Invoice | INV-9916 | 12/19/2025 | 01/18/2026 | USD | 28,571.94 | 28,571.94 |
|---|
| 74 | 75 | C-0197 | Elderberry Deli | Invoice | INV-9974 | 12/22/2025 | 01/06/2026 | USD | 3,812.89 | 3,812.89 |
|---|
| 75 | 76 | C-0198 | GREEN VALLEY COOP #2 | Invoice | INV-9882 | 12/08/2025 | 01/07/2026 | USD | 27,326.69 | 27,326.69 |
|---|
| 76 | 77 | C-0198 | GREEN VALLEY COOP #2 | Invoice | INV-9914 | 12/18/2025 | 01/17/2026 | USD | 22,397.64 | 22,397.64 |
|---|
| 77 | 78 | C-0200 | Ember Lane Grocers | Invoice | INV-9886 | 12/09/2025 | 01/08/2026 | USD | 19,621.81 | 19,621.81 |
|---|
| 78 | 79 | C-0200 | Ember Lane Grocers | Invoice | INV-9910 | 12/18/2025 | 01/17/2026 | USD | 18,008.51 | 18,008.51 |
|---|
| 79 | 80 | C-0206 | Otter Brasserie | Invoice | INV-9994 | 12/29/2025 | 01/13/2026 | USD | 3,626.31 | 3,626.31 |
|---|
| 80 | 81 | C-0216 | Arbor Kitchen | Invoice | INV-9978 | 12/23/2025 | 01/07/2026 | USD | 1,007.32 | 1,007.32 |
|---|
| 81 | 82 | C-0219 | Huckleberry Grill | Invoice | INV-10006 | 12/29/2025 | 01/13/2026 | USD | 1,870.53 | 1,870.53 |
|---|
| 82 | 83 | C-0233 | Rose City Market Hall | Invoice | INV-9857 | 12/04/2025 | 01/03/2026 | USD | 21,035.01 | 21,035.01 |
|---|
| 83 | 84 | C-0233 | Rose City Market Hall | Invoice | INV-9950 | 12/22/2025 | 01/21/2026 | USD | 14,939.30 | 14,939.30 |
|---|
| 84 | 85 | C-0237 | Plover Supper Club | Invoice | INV-9995 | 12/29/2025 | 01/13/2026 | USD | 3,190.25 | 3,190.25 |
|---|
| 85 | 86 | C-0242 | Pumice Cantina | Invoice | INV-9989 | 12/29/2025 | 01/13/2026 | USD | 1,293.22 | 1,293.22 |
|---|
| 86 | 87 | C-0247 | Wren Noodle House | Invoice | INV-9887 | 12/08/2025 | 12/23/2025 | USD | 3,225.33 | 3,225.33 |
|---|
| 87 | 88 | C-0250 | Nettle Cantina | Invoice | INV-9892 | 12/09/2025 | 12/24/2025 | USD | 2,448.21 | 2,448.21 |
|---|
| 88 | 89 | C-0264 | Vale Brasserie | Invoice | INV-9962 | 12/19/2025 | 01/03/2026 | USD | 2,721.80 | 2,721.80 |
|---|
| 89 | 90 | C-0273 | Coldwater Creek Market | Invoice | INV-9855 | 12/04/2025 | 01/03/2026 | USD | 12,652.18 | 12,652.18 |
|---|
| 90 | 91 | C-0273 | Coldwater Creek Market | Invoice | INV-9942 | 12/22/2025 | 01/21/2026 | USD | 11,542.68 | 11,542.68 |
|---|
| 91 | 92 | C-0275 | Tamarack Smokehouse | Invoice | INV-9996 | 12/29/2025 | 01/13/2026 | USD | 863.93 | 863.93 |
|---|
| 92 | 93 | C-0276 | Mossy Rock Taproom | Invoice | INV-9990 | 12/29/2025 | 01/13/2026 | USD | 3,288.23 | 3,288.23 |
|---|
| 93 | 94 | C-0278 | Sorrel Cantina | Invoice | INV-9983 | 12/25/2025 | 01/09/2026 | USD | 3,242.64 | 3,242.64 |
|---|
| 94 | 95 | C-0282 | Yarrow Deli | Invoice | INV-9973 | 12/23/2025 | 01/07/2026 | USD | 2,350.59 | 2,350.59 |
|---|
| 95 | 96 | C-0295 | Zephyr Bakery | Invoice | INV-9991 | 12/29/2025 | 01/13/2026 | USD | 3,299.21 | 3,299.21 |
|---|
| 96 | 97 | C-0296 | Bluebird Smokehouse | Invoice | INV-9997 | 12/29/2025 | 01/13/2026 | USD | 1,876.35 | 1,876.35 |
|---|
| 97 | 98 | C-0299 | Orchard Bakery | Invoice | INV-9946 | 12/18/2025 | 01/02/2026 | USD | 1,220.39 | 1,220.39 |
|---|
| 98 | 99 | C-0305 | Bittern Bistro | Invoice | INV-9956 | 12/18/2025 | 01/02/2026 | USD | 1,449.33 | 1,449.33 |
|---|
| 99 | 100 | C-0306 | Tillamook Road Grocery | Invoice | INV-9881 | 12/04/2025 | 01/03/2026 | USD | 24,680.05 | 24,680.05 |
|---|
| 100 | 101 | C-0306 | Tillamook Road Grocery | Invoice | INV-9979 | 12/23/2025 | 01/22/2026 | USD | 24,793.84 | 24,793.84 |
|---|
Showing 51–100 of 152 rows
| — |
| 0 |
| Date | 1 | 19 | 10 | date mm dd yyyy 151 | 52 |
|---|
| Due Date | 1 | 25 | 10 | date mm dd yyyy 151 | 66 |
|---|
| Currency | 1 | 1 | 3 | — | 0 |
|---|
| Current | 24 | 128 | 12 | decimal 2, amount grouped 126 | 0 |
|---|
| 1 - 30 | 129 | 23 | 9 | decimal 4, amount grouped 19 | 0 |
|---|
| 31 - 60 | 151 | 1 | 4 | decimal 1 | 0 |
|---|
| 61 - 90 | 149 | 3 | 8 | amount grouped 3 | 0 |
|---|
| > 90 | 151 | 1 | 4 | decimal 1 | 0 |
|---|
| Open Balance (USD) | 0 | 152 | 12 | decimal 6, amount grouped 146 | 0 |
|---|