Nicolet National Bank statement to QuickBooks or Xero: eStatements, the MidWestOne conversion, three business logins and tie-out
Start by checking the bank. In the FDIC's BankFind records (checked 18 Nov 2026), Nicolet National Bank is certificate number 57038, with its main office in Green Bay, Wisconsin. It lists an establishment date in 2000, 117 offices (49 in Wisconsin, 37 in Iowa, 15 in Michigan, 14 in Minnesota and 1 each in Colorado and Florida) and Nicolet Bankshares as its holding company (FDIC BankFind). BankFind records MidWestOne Bank (certificate 14843) merging into Nicolet National Bank on February 13, 2026. A BankFind name search for Nicolet also turns up an inactive Nicollet County Bank in Minnesota, so match certificate 57038 before you follow this guide. This guide covers Nicolet National Bank business checking statements, including accounts that came over from MidWestOne Bank, as the pages on nicoletbank.com read on 18 Nov 2026. We never need a bank login.
What Nicolet's pages say
- Online statements need eStatements. The statement copy FAQ says you can get a copy "by stopping into your local branch, or through online banking": click the account, then "Online Statements" at the top of the page. It adds: "Online statements are only available for accounts enrolled in electronic statements." (Nicolet: How do I get a copy of my statement?). Turn eStatements on for every account before you plan a catch-up.
- Turning eStatements on. The Nicolet Bank Digital page says to log in, go to Additional Services, then Documents, select "Manage Paperless Settings", choose the accounts "and click Save" (Nicolet Bank Digital). The eStatements FAQ gives the same Additional Services and Documents path (Nicolet: How do I switch to eStatements?).
- Monthly or quarterly. The Digital Online Banking Services Agreement (Rev 2.2026) says you "will continue to receive Your regular account statement either monthly or quarterly, depending on the type of account", and that by enrolling in online banking you agree to receive eStatements (Nicolet: Digital Online Banking Services Agreement). The E-Sign Disclosure says you need to be able to view documents in PDF format to view account statements (Nicolet: E-Sign Disclosure).
- Three business logins. The login menu on every web page we read offers Nicolet Bank Digital, "Business Online (Treasury Management)" and, under Other Business Account Logins, "Digital Banking for Business (fmr. MidWestOne)" (Nicolet: MidWestOne Bank Merger). Ask the client which one each account uses; statements are pulled from that login.
- Treasury Management reporting. The Account Reporting page says business users can "view transaction history, retrieve statements" and more, and lists Reconciliation Services with "Multiple file formats available." (Nicolet: Account Reporting; the same access text is on Online and Mobile Access). The formats aren't named.
- Quicken, not QuickBooks. A FAQ says the personal connection to Quicken was "reestablished on 2/28/25" after the launch of Nicolet Bank Digital, for Web Connect and Direct Connect, that all users must register again, and that registration is "Desktop Only", under the Additional Services menu (Nicolet: personal Quicken connection). No page we read mentions QuickBooks.
- Business checking accounts. Small Business Checking is for fewer than 125 monthly transactions: a $15 monthly maintenance fee, waived with a $250 average collected balance or 5 or more non-ATM business debit card transactions, 35¢ each after the first 125 transactions, "Monthly eStatement FREE" and "Printed/Mailed Monthly Statement $8" (Small Business Checking). Business Checking is for 250 transactions or fewer: a $20 fee waived with a $1,000 daily ending balance, 35¢ each after 250, and a free monthly eStatement (Business Checking). Corporate Checking uses a monthly earnings credit to offset service fees and lists "Detailed monthly analysis statements" (Nicolet: Business Checking Accounts).
- MidWestOne Bank customers. The MidWestOne merger page says MidWestOne Bank has operated "as a division of Nicolet National Bank" since February 13, 2026, would "fully consolidate operations at the end of business on Friday, August 7, 2026", and would open as Nicolet National Bank on Monday, August 10, 2026, with changes to "accounts, cards, online banking, and more" explained before conversion weekend (Nicolet: MidWestOne Bank Merger). Statements for one account may carry the MidWestOne name before the conversion and the Nicolet name after it, but it is the same FDIC-insured bank, certificate 57038.
Where Nicolet's pages don't line up
- The MidWestOne page reads as if August 2026 hasn't come. On 18 Nov 2026 it still says "all locations will continue operating as MidWestOne Bank until August 10" and that a disclosure package will arrive "In July" (MidWestOne Bank Merger). We found no page saying how the conversion went.
- A MidWestOne login after the conversion date. The login menu still lists "Digital Banking for Business (fmr. MidWestOne)" separately from Nicolet Bank Digital and Business Online (MidWestOne Bank Merger). Check where a former MidWestOne account's statements live today before you plan around one login.
- Paper statement fee, by page. Small Business Checking lists a printed statement at $8 a month (Small Business Checking); the Business Checking page lists only the free monthly eStatement (Business Checking); the E-Sign Disclosure says that "depending on your account type, your account may be charged a monthly service fee for paper statements" (E-Sign Disclosure). Book the fee the statement actually shows.
- Monthly on one page, monthly or quarterly on another. The business checking pages say "Monthly eStatement"; the online banking agreement says monthly or quarterly depending on the type of account (Digital Online Banking Services Agreement). Check each account's statement period before you chain statements.
- An agreement written for personal accounts. The Digital Online Banking Services Agreement defines its accounts as those "for personal, family, or household use" (Digital Online Banking Services Agreement), and the Quicken FAQ is for the personal connection (Quicken FAQ). We found no business online banking agreement on the pages we read, so don't assume its terms apply to a business login.
What Nicolet's pages don't say
- How many months or years of statements online banking shows, for any of the three logins.
- Whether MidWestOne Bank statements from before the August 2026 conversion appear in Nicolet Bank Digital, or stay in the former MidWestOne login. Ask the client to keep every MidWestOne statement PDF they already saved.
- Whether business accounts can download transactions, and in which formats (CSV, QBO, QFX or OFX), or connect to QuickBooks. The Reconciliation Services formats aren't named. None mentions Xero.
- Statement copy and research fees. We found no business fee schedule among the pages we read; the business account Terms and Conditions are hosted elsewhere and we didn't open them.
- How long you have to report an error on a business statement, whether closed accounts keep their statements online, whether statement PDFs are password protected, and statement cycle dates.
QuickBooks Online
- Intuit's manual upload takes a PDF or image statement in English, or a QBO, QFX or CSV file. A list file must be 350 KB or less, with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), up to 1,000 lines per upload (Intuit: manually upload transactions into QuickBooks Online, updated Aug 24, 2026). Intuit says the file should start at least one day before your oldest QuickBooks transaction in that account (Intuit). If a feed or an earlier file already brought in some of a period, upload only the dates it missed, or see duplicate transactions after a bank upload.
- If a login offers a transaction download, it is a list of transactions, not a statement. Before you upload one, set its dates to the statement's own period and check it against the statement: same count of lines, same total in and out.
- To connect an account, Intuit's steps are in Intuit: connect bank and credit card accounts to QuickBooks Online. A connection doesn't reach back past what the bank sends, so fill older months from statements.
- For QuickBooks Desktop, Intuit says you can't download the same transactions into a company file more than once (Intuit: download bank feed transactions in QuickBooks Desktop, updated Aug 5, 2026). For periods with only a PDF, see can QuickBooks Desktop import a PDF bank statement.
Xero
- Our check of Xero's US list of banks with validated PDF extraction (18 Nov 2026) didn't turn up Nicolet National Bank. Xero still lets you import PDFs from banks not on the list, but says accuracy might vary, and it recommends OFX over PDF when your bank offers it. Xero's PDF import is for US and Canada organizations, not the Xero Ledger plan; files must be English, 35 MB or less, up to 100 pages, at least 200 DPI, not password protected, one file per bank account (Xero Central: import a PDF bank statement). Test one statement and check every line before a full catch-up.
- A CSV you have tied out first is the safer route. Xero's CSV needs at least Date and Amount, with money in positive and money out negative in one column, and no opening or closing balance columns (Xero Central: import a bank statement in CSV format). Nicolet's pages don't show a CSV layout, so check the signs and drop any balance column before you import.
- Xero treats lines matching ones already in Xero as duplicates and won't import them (Xero Central), but don't rely on that; import only the periods the account doesn't already have.
More detail: how to import bank statements into Xero from a PDF and closed bank account statements into QuickBooks or Xero.
Which route for which months
- Going forward: keep eStatements on for every account and save each statement PDF every month, since no page says how long they stay online.
- Past months online: open Online Statements for each account, note the oldest statement shown and download every one, oldest first. The download-before-the-window-closes checklist has the order.
- Months that aren't online, or MidWestOne months: use the client's saved PDFs or paper statements, check the former MidWestOne login if the client still has it, or ask the bank for copies and ask what they cost and how far back they go.
- Recent months, from a download: if a login offers one, a transaction download can fill the current period, but only after a one-month test matches the statement line by line.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance for each account on the Nicolet statement, to the cent, using the statement's own period dates.
- Chain the statements: each ending balance equals the next statement's beginning balance, and each period starts the day after the last one ended. Where an account moved from MidWestOne Bank to Nicolet in 2026, check that the last MidWestOne balance carries into the first Nicolet statement.
- Count the lines: the number of transactions you import should equal the number on the statement for that period.
- Look for charges: 35¢ per transaction over 125 or 250, the $15 or $20 monthly maintenance fee, the $8 printed statement fee, analysis charges net of earnings credit, and overdraft or stop payment fees. Book what the statement shows.
- Spot-check the first and last days of the period and the largest few items against the statement.
The full method is in check a bank statement PDF is complete before you import it. Our free tie-out checker runs in your browser and shows the row where a CSV stops balancing. Then reconcile one statement at a time, oldest first; if QuickBooks says the beginning balance is off, see beginning balance doesn't match.
Client also banks with Associated Bank, also based in Green Bay? See Associated Bank statement to QuickBooks or Xero. Or Premier Bank in Dubuque, Iowa? See Premier Bank (Dubuque, Iowa) statement to QuickBooks or Xero. Or Old National Bank? See Old National Bank statement to QuickBooks or Xero. Or BMO? See BMO statement to QuickBooks or Xero. Or Huntington? See Huntington statement to QuickBooks or Xero. Or Busey Bank? See Busey Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For Nicolet National Bank, no page says how many months of statements online banking keeps, or whether older MidWestOne statements carry over, so the statement PDFs you can get are the record for catch-ups. If you'd rather not convert and check each statement yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every statement matches its opening and closing balance. It costs $15 per statement-month, and we aim to deliver within 12 hours. Tie-out guarantee: if the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.
Skip the manual work
We turn statement PDFs into QBO, Xero and CSV files plus a tie-out sheet. $15 per statement-month, $149 for a 12-month catch-up. Prefer to check it yourself? Our tie-out checker runs in your browser. See how pros do catch-up.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.