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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1974 | 1975 | PMT-32028 | Receipt | 06/10/2026 | C-0301 | Alpenkost GmbH | WIRE | FT9724694457 | USD | 12,454.40 | 1.0000 | 12,454.40 |
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-10689 |
| 11,200.00 |
| 1,254.40 |
| 1975 | 1976 | PMT-32029 | Receipt | 06/11/2026 | C-0191 | Riverstone Smokehouse | CHECK | 9129 | USD | 1,904.20 | 1.0000 | 1,904.20 | INV-10733 | 1,904.20 | 0.00 |
|---|
| 1976 | 1977 | PMT-32030 | Receipt | 06/11/2026 | C-0348 | Foxglove Market | ACH | 978061774077151 | USD | 15,132.48 | 1.0000 | 15,132.48 | INV-10597 | 15,132.48 | 0.00 |
|---|
| 1977 | 1978 | PMT-32031 | Receipt | 06/11/2026 | C-0366 | Kettle Bistro | ACH | 893327893928772 | USD | 2,256.57 | 1.0000 | 2,256.57 | INV-10721 | 2,256.57 | 0.00 |
|---|
| 1978 | 1979 | PMT-32032 | Receipt | 06/12/2026 | C-0105 | Whidbey Harvest Co-op | ACH | 719385220664290 | USD | 20,659.14 | 1.0000 | 20,659.14 | INV-10626 | 20,659.14 | 0.00 |
|---|
| 1979 | 1980 | PMT-32033 | Receipt | 06/12/2026 | C-0217 | Paddle Eatery | CHECK | 5371 | USD | 3,350.58 | 1.0000 | 3,350.58 | INV-10725 | 3,350.58 | 0.00 |
|---|
| 1980 | 1981 | PMT-32034 | Receipt | 06/12/2026 | C-0233 | Rose City Market Hall | ACH | 632884063354200 | USD | 13,435.52 | 1.0000 | 13,435.52 | INV-10663 | 13,435.52 | 0.00 |
|---|
| 1981 | 1982 | PMT-32035 | Receipt | 06/12/2026 | C-0282 | Yarrow Deli | CHECK | 2486 | USD | 2,839.66 | 1.0000 | 2,839.66 | INV-10710 | 2,839.66 | 0.00 |
|---|
| 1982 | 1983 | PMT-32036 | Receipt | 06/12/2026 | C-0396 | Driftwood Pantry | ACH | 961880979789823 | USD | 17,186.20 | 1.0000 | 17,186.20 | INV-10638 | 17,186.20 | 0.00 |
|---|
| 1983 | 1984 | PMT-32037 | Receipt | 06/15/2026 | C-0046 | Yakima Orchard Market | ACH | 601936035631394 | USD | 26,561.22 | 1.0000 | 26,561.22 | INV-10694 | 26,561.22 | 0.00 |
|---|
| 1984 | 1985 | PMT-32038 | Receipt | 06/15/2026 | C-0122 | Owyhee Mercantile | ACH | 486642916322718 | USD | 12,643.50 | 1.0000 | 12,643.50 | INV-10656 | 12,643.50 | 0.00 |
|---|
| 1985 | 1986 | PMT-32039 | Receipt | 06/15/2026 | C-0143 | Gorge Valley Co-op | ACH | 669714658787526 | USD | 18,162.80 | 1.0000 | 18,162.80 | INV-10679 | 18,162.80 | 0.00 |
|---|
| 1986 | 1987 | PMT-32040 | Receipt | 06/15/2026 | C-0163 | Elk Rock Provisions | ACH | 991028034199431 | USD | 22,610.78 | 1.0000 | 22,610.78 | INV-10697 | 22,610.78 | 0.00 |
|---|
| 1987 | 1988 | PMT-32041 | Receipt | 06/15/2026 | C-0193 | Quinault Country Store | CHECK | 2384 | USD | 20,558.54 | 1.0000 | 20,558.54 | INV-10682 | 20,558.54 | 0.00 |
|---|
| 1988 | 1989 | PMT-32042 | Receipt | 06/15/2026 | C-0325 | Cobalt Cafe | CHECK | 8044 | USD | 1,250.06 | 1.0000 | 1,250.06 | INV-10761 | 1,250.06 | 0.00 |
|---|
| 1989 | 1990 | PMT-32043 | Receipt | 06/15/2026 | C-0330 | Alder Street Market | ACH | 666170980001820 | USD | 24,653.89 | 1.0000 | 24,653.89 | INV-10614 | 24,653.89 | 0.00 |
|---|
| 1990 | 1991 | PMT-32044 | Receipt | 06/15/2026 | C-0369 | Eddy Pizzeria | CHECK | 9632 | USD | 1,980.94 | 1.0000 | 1,980.94 | INV-10748 | 1,980.94 | 0.00 |
|---|
| 1991 | 1992 | PMT-32045 | Receipt | 06/15/2026 | C-0371 | Marrow Brasserie | ACH | 875432325040984 | USD | 3,740.30 | 1.0000 | 3,740.30 | INV-10752 | 3,740.30 | 0.00 |
|---|
| 1992 | 1993 | PMT-32046 | Receipt | 06/15/2026 | C-0399 | Larch Mountain Mercantile | CHECK | 7222 | USD | 20,252.27 | 1.0000 | 20,252.27 | INV-10680 | 20,252.27 | 0.00 |
|---|
| 1993 | 1994 | PMT-32047 | Receipt | 06/15/2026 | C-0400 | Salmonberry Market | CHECK | 2687 | USD | 28,174.62 | 1.0000 | 28,174.62 | INV-10630 | 28,174.62 | 0.00 |
|---|
| 1994 | 1995 | PMT-32048 | Receipt | 06/15/2026 | C-0420 | Nehalem Bay Grocers | CHECK | 1719 | USD | 22,305.54 | 1.0000 | 22,305.54 | INV-10681 | 22,305.54 | 0.00 |
|---|
| 1995 | 1996 | PMT-32049 | Receipt | 06/15/2026 | C-0427 | Deschutes Food Hall | ACH | 912401143339670 | USD | 21,125.60 | 1.0000 | 21,125.60 | INV-10665 | 21,125.60 | 0.00 |
|---|
| 1996 | 1997 | PMT-32050 | Receipt | 06/16/2026 | C-0012 | Olallie Market | CHECK | 6314 | USD | 19,959.39 | 1.0000 | 19,959.39 | INV-10676 | 19,959.39 | 0.00 |
|---|
| 1997 | 1998 | PMT-32051 | Receipt | 06/16/2026 | C-0082 | Chanterelle Supper Club | CHECK | 8462 | USD | 1,210.27 | 1.0000 | 1,210.27 | INV-10759 | 1,210.27 | 0.00 |
|---|
| 1998 | 1999 | PMT-32052 | Receipt | 06/16/2026 | C-0340 | Eastside Cafe | CHECK | 2353 | USD | 4,058.81 | 1.0000 | 4,058.81 | INV-10731 | 4,058.81 | 0.00 |
|---|
| 1999 | 2000 | PMT-32053 | Receipt | 06/16/2026 | C-0353 | Uproot Cafe | ACH | 050937674348507 | USD | 1,252.80 | 1.0000 | 1,252.80 | INV-10732 | 1,252.80 | 0.00 |
|---|
| 2000 | 2001 | PMT-32054 | Receipt | 06/17/2026 | C-0083 | Acorn Supper Club | CHECK | 4630 | USD | 1,531.54 | 1.0000 | 1,531.54 | INV-10774 | 1,531.54 | 0.00 |
|---|
| 2001 | 2002 | PMT-32055 | Receipt | 06/17/2026 | C-0147 | Vashon Island Market | ACH | 403708393381563 | USD | 11,293.13 | 1.0000 | 11,293.13 | INV-10627 | 11,293.13 | 0.00 |
|---|
| 2002 | 2003 | PMT-32056 | Receipt | 06/17/2026 | C-0158 | Umber Grill | CHECK | 3403 | USD | 2,123.77 | 1.0000 | 2,123.77 | INV-10712 | 2,123.77 | 0.00 |
|---|
| 2003 | 2004 | PMT-32057 | Receipt | 06/17/2026 | C-0379 | Filbert & Oak Market | ACH | 527760294931148 | USD | 28,835.76 | 1.0000 | 28,835.76 | INV-10647 | 28,835.76 | 0.00 |
|---|
| 2004 | 2005 | PMT-32058 | Receipt | 06/18/2026 | C-0081 | Fernwood Grill | CHECK | 5062 | USD | 1,493.36 | 1.0000 | 1,493.36 | INV-10717 | 1,493.36 | 0.00 |
|---|
| 2005 | 2006 | PMT-32059 | Receipt | 06/18/2026 | C-0088 | Palouse Provisions | CHECK | 5086 | USD | 19,811.31 | 1.0000 | 19,811.31 | INV-10669 | 19,811.31 | 0.00 |
|---|
| 2006 | 2007 | PMT-32060 | Receipt | 06/18/2026 | C-0183 | Madrona Food Co-op | ACH | 433580481800399 | USD | 14,671.41 | 1.0000 | 14,671.41 | INV-10704 | 14,671.41 | 0.00 |
|---|
| 2007 | 2008 | PMT-32061 | Receipt | 06/18/2026 | C-0185 | Gristmill Supper Club | CHECK | 7238 | USD | 2,919.02 | 1.0000 | 2,919.02 | INV-10747 | 2,919.02 | 0.00 |
|---|
| 2008 | 2009 | PMT-32062 | Receipt | 06/18/2026 | C-0247 | Wren Noodle House | ACH | 058750593555291 | USD | 2,313.25 | 1.0000 | 2,313.25 | INV-10718 | 2,313.25 | 0.00 |
|---|
| 2009 | 2010 | PMT-32063 | Receipt | 06/18/2026 | C-0337 | Saffron Taproom | CHECK | 5122 | USD | 2,297.20 | 1.0000 | 2,297.20 | INV-10720 | 2,297.20 | 0.00 |
|---|
| 2010 | 2011 | PMT-32064 | Receipt | 06/19/2026 | C-0002 | Flint Noodle House | ACH | 100630370530751 | USD | 1,224.29 | 1.0000 | 1,224.29 | INV-10775 | 1,224.29 | 0.00 |
|---|
| 2011 | 2012 | PMT-32065 | Receipt | 06/19/2026 | C-0031 | Oyster Taproom | CHECK | 9661 | USD | 2,691.10 | 1.0000 | 2,691.10 | INV-10729 | 2,691.10 | 0.00 |
|---|
| 2012 | 2013 | PMT-32066 | Receipt | 06/19/2026 | C-0096 | Pioneer Square Provisions | ACH | 896055449522905 | USD | 19,562.32 | 1.0000 | 19,562.32 | INV-10695 | 19,562.32 | 0.00 |
|---|
| 2013 | 2014 | PMT-32067 | Receipt | 06/19/2026 | C-0171 | Dune Cantina | ACH | 250222721915085 | USD | 1,300.26 | 1.0000 | 1,300.26 | INV-10743 | 1,300.26 | 0.00 |
|---|
| 2014 | 2015 | PMT-32068 | Receipt | 06/19/2026 | C-0186 | Hawthorne Fresh Market | ACH | 604105328992396 | USD | 15,803.46 | 1.0000 | 15,803.46 | INV-10646 | 15,803.46 | 0.00 |
|---|
| 2015 | 2016 | PMT-32069 | Receipt | 06/19/2026 | C-0306 | Tillamook Road Grocery | CHECK | 632 | USD | 27,723.37 | 1.0000 | 27,723.37 | INV-10675 | 27,723.37 | 0.00 |
|---|
| 2016 | 2017 | PMT-32070 | Receipt | 06/22/2026 | C-0033 | Treasure Valley Market | CHECK | 6164 | USD | 28,529.53 | 1.0000 | 28,529.53 | INV-10664 | 28,529.53 | 0.00 |
|---|
| 2017 | 2018 | PMT-32071 | Receipt | 06/22/2026 | C-0075 | Vesper Pizzeria | CHECK | 9001 | USD | 3,860.48 | 1.0000 | 3,860.48 | INV-10730 | 3,860.48 | 0.00 |
|---|
| 2018 | 2019 | PMT-32072 | Receipt | 06/22/2026 | C-0090 | Zigzag Mountain Grocery | CHECK | 6282 | USD | 23,793.90 | 1.0000 | 23,793.90 | INV-10667 | 23,793.90 | 0.00 |
|---|
| 2019 | 2020 | PMT-32073 | Receipt | 06/22/2026 | C-0130 | Cinder Kitchen | ACH | 718730896990057 | USD | 1,090.92 | 1.0000 | 1,090.92 | INV-10724 | 1,090.92 | 0.00 |
|---|
| 2020 | 2021 | PMT-32074 | Receipt | 06/22/2026 | C-0133 | Sawtooth Natural Foods | ACH | 878147709841159 | USD | 22,563.75 | 1.0000 | 22,563.75 | INV-10678 | 22,563.75 | 0.00 |
|---|
| 2021 | 2022 | PMT-32075 | Receipt | 06/22/2026 | C-0335 | Mountain Grocers Inc. | CHECK | 3148 | USD | 21,350.24 | 1.0000 | 21,350.24 | INV-10692 | 21,350.24 | 0.00 |
|---|
| 2022 | 2023 | PMT-32076 | Receipt | 06/22/2026 | C-0357 | Mountain Grocers LLC | ACH | 539681074281854 | USD | 27,683.39 | 1.0000 | 27,683.39 | INV-10648 | 27,683.39 | 0.00 |
|---|
| 2023 | 2024 | PMT-32077 | Receipt | 06/22/2026 | C-0359 | Yew Grill | ACH | 567410393671823 | USD | 2,330.34 | 1.0000 | 2,330.34 | INV-10755 | 2,330.34 | 0.00 |
|---|
Showing 1974–2023 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 |
|---|