Centennial Bank statement to QuickBooks or Xero: Direct Connect, 24 months of e-statements, the Mountain Commerce conversion and tie-out

More than one US bank uses the name Centennial Bank. This guide covers Centennial Bank at my100bank.com, a Home BancShares company, and its business online banking and Cash Management platform. If your client's Centennial Bank uses another website, its rules may differ. Xero's list of supported banks names a Centennial Bank without saying which one. Here's what this bank's public pages say, and don't, about getting a business account's history into QuickBooks or Xero.

What Centennial Bank's pages say

  • Direct Connect for Quicken and QuickBooks. Centennial's Quicken and QuickBooks page offers automated transaction downloads through its Direct Connect service, with separate instructions for Cash Management and Online Banking customers by program and operating system, and says the service is optional: you can keep updating accounts manually. Transfers work only in Quicken and QuickBooks for Windows (Centennial Bank: Quicken and QuickBooks).
  • What switching to Direct Connect involves. The Cash Management guide for QuickBooks for Windows says Direct Connect may require registration with Cash Management first, and to back up the data file, update QuickBooks, switch to single-user mode and use Classic Mode (Register Mode). All downloaded transactions must be matched or added to the register before you deactivate the old connection. The Cash Management super user then enables each sub-user for Direct Connect, and you reconnect by choosing Centennial Bank-my100bank.com and Direct Connect. The guide puts the job at 15 to 30 minutes (Centennial Bank: QuickBooks for Windows, Direct Connect for Cash Management).
  • 24 months of e-statements. The Online Banking page says customers can view transaction history, check statements and view processed checks, and that with E-Statements they can view statements for 24 consecutive months from the date of enrollment (Centennial Bank: Online Banking). The eStatements page describes free online statements with the same information as the paper version, including front images of cancelled checks, and an email each month when a statement is ready (Centennial Bank: eStatements and eNotices). The page counts the 24 months from enrollment and doesn't say whether months before enrollment show.
  • A download button, no format named. The Internet Banking Update page says the Download feature is still accessible on the redesigned landing page (Centennial Bank: Internet Banking Update). Commercial clients get balance and transaction information through the Cash Management online platform (Centennial Bank: Treasury Management Services).
  • 30 days to report errors on a business account. The Supplement to Deposit Account Agreement for Business Accounts, printed in the Mountain Commerce conversion booklet, says statements are made available monthly or on request, that where online access is available a statement's items count as made available the day they first appear online, and that exceptions must be reported within 30 days after the statement is sent or made available. Unauthorized ACH debits must be reported within one business day of discovery and no later than two business days after posting (Centennial Bank: Mountain Commerce 30-day letter booklet).
  • Copies and research. The Schedule of Fees (revised 06.08.2026) lists Account Research/Reconciliation at $25.00 per hour, check image copies at $2.00 each and statement copies at $5.00 each (Centennial Bank: Schedule of Fees). The booklet's fee schedule shows the same three amounts.
  • The November 2026 Mountain Commerce conversion. Mountain Commerce Bank became part of Centennial on April 1, 2026, with the system conversion set for November 6-9, 2026. Centennial asks customers to print or save any previous e-statements before 11/06/26, since they won't be available in Centennial's online banking. Final Mountain Commerce statements are generated 11/06/26 and mailed on paper 11/09/26, e-statements must be re-accepted on Centennial's platform, Personal Finance Management tools go away, and Treasury Management moves to Centennial's Commercial system, available Monday, Nov. 9, 2026 at 8:00 a.m. ET. Business Analysis charges are applied early, on 11/06/26 (Centennial Bank: Mountain Commerce Bank Conversion Information).

Where Centennial Bank's pages don't line up

  • How to turn on e-statements. The Online Banking page says to visit a branch to stop paper statements and get them by email (Centennial Bank), while the eStatements page gives self-service steps in online banking (Profile, then Documents/Support, then Statements/Notices, then Paperless Settings) (Centennial Bank), and the booklet's electronic banking disclosure says to edit your profile (Centennial Bank). The enrollment page also sits under personal banking, with no business version we found.
  • When converted clients can sign in. The conversion page says Centennial plans online banking sign-in from Monday, 11/09/2026, but no later than Tuesday, 11/10/2026, and its mobile section says both that mobile banking will be available Tuesday, 11/10/26 and that sign-in is planned from Monday (Centennial Bank). The booklet's letter, dated October 6, 2026, says Tuesday, 11/10/26 for online banking (Centennial Bank).
  • When Bill Pay freezes. The conversion page says you can't add, edit or cancel payments from 4:00 p.m. ET on Friday, November 6 (Centennial Bank), but the booklet says from 3pm EST on Thursday, 11/05/26 (Centennial Bank). Plan around the earlier time.
  • Dated QuickBooks guides. The Quicken and QuickBooks page labels its Mac guides for Quicken for Mac 2007 and 2015 to 2018, and its Online Banking guide for QuickBooks for Windows links to a staging host rather than the main site, so we didn't open it (Centennial Bank).

What Centennial Bank's pages don't say

  • Which formats the Download feature offers (QBO, QFX, OFX, CSV or Excel), its columns, or how far back it reaches. The QuickBooks page covers Direct Connect only and never mentions Web Connect files.
  • Whether statements older than 24 months from enrollment can be retrieved online, or whether statements stay reachable after an account or online access closes.
  • Whether Mountain Commerce clients' Quicken or QuickBooks connections carry over. The conversion page and booklet don't mention either program.
  • Xero by name.

QuickBooks Online

Xero

  • Xero's US list of banks with validated PDF extraction for selected statement types includes a Centennial Bank (checked 2 Nov 2026), but the list doesn't say which one, so test one statement before a full catch-up. Xero also recommends OFX over PDF when your bank offers it; Centennial's pages don't say whether its download includes OFX. 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). Check every imported line against the PDF.
  • If you build a CSV instead, Xero 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).
  • 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: each e-statement PDF, saved when it posts, plus a Direct Connect or file download for the same statement dates if it fits your software.
  • Whatever is online now: download every statement PDF online banking offers today, since the 24 months count from enrollment and the pages don't say what happens after an account closes.
  • Mountain Commerce clients, before 11/06/26: save every Mountain Commerce e-statement PDF and finish a last download, then keep the paper final statement mailed 11/09/26, since the old e-statements won't move to Centennial.
  • Anything missing: statement copies from Centennial at the fee schedule's price, after confirming it applies to your client's account.
  • Before you're done: report anything wrong within 30 days of the statement being made available, which can be the day items first show online, not the day you open the PDF.

Tie out each statement before you import

  1. Beginning balance + deposits − withdrawals = ending balance on the Centennial statement, to the cent, using the statement's own period dates.
  2. Chain the statements: each ending balance equals the next statement's beginning balance, and each period starts the day after the last one ended. Across the November 2026 conversion, check the ending balance on the final Mountain Commerce statement, generated 11/06/26, against the first Centennial beginning balance.
  3. Sum the download's lines for the same dates and compare them with the statement's net change. A difference usually means a date range cut at month end instead of the statement end, a duplicate from an overlapping download or a reconnect, or an item that posted after the file was made.
  4. Spot-check the first and last days of the period and the largest few items against the PDF, using the check images for any check that doesn't match.

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 Bank OZK? See Bank OZK statement to QuickBooks or Xero. Or SmartBank? See SmartBank statement to QuickBooks or Xero. Or First Service Bank? See First Service Bank statement to QuickBooks or Xero.

Where LedgerReady fits

For Centennial Bank, the pages don't name a download format, e-statements reach back only 24 months from enrollment, and Mountain Commerce clients lose their old e-statements at the conversion, so the PDF statements are the record for catch-ups, for Xero and for any month a download or connection can't reach. 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.

Try your first statement free

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.