UMB Bank statement to QuickBooks or Xero: 18 months of statements online, three online banking platforms and tie-out

Start by checking the name on the statement. In the FDIC's BankFind records (checked 12 Nov 2026), UMB Bank, National Association is in Kansas City, Missouri, was established in 1902, has 209 offices (45 in Missouri, 30 in Kansas, 28 in Colorado, 21 each in Arizona, New Mexico and Texas, 13 in Wisconsin, 8 each in California and Iowa, 7 in Illinois, 3 in Oklahoma, 2 in Minnesota and 1 each in Nebraska and Utah) and uses umb.com as its web address, certificate number 8273 (FDIC BankFind). BankFind also lists many older, inactive banks with UMB in the name, among them UMB Oklahoma Bank, so match the certificate number. This guide covers UMB Bank business and commercial checking statements, as the bank's pages read on 12 Nov 2026. UMB's account agreements and user guide PDFs sit on a document host whose robots file asks crawlers to stay out, so we didn't use them, and anything only those documents would say is marked as not stated below. We never need a bank login.

What UMB Bank's pages say

  • Three online banking platforms. UMB's business online banking page lists Business Online Banking, for small business owners, to "manage accounts, track cash flow, make payments and transfers, and view transaction history"; UMB Premier Business Online Banking, with "user management, fund transfers and more"; and UMB Direct® Commercial Online Banking. It says "Your UMB partner will help you enroll and select the right online banking platform for your business." (UMB Bank: Business and Commercial Banking Online). Ask the client which one they log in to before you plan the catch-up.
  • Up to 18 months of statements online. The small business banking page says that with UMB's online banking dashboard "you can easily transfer funds between accounts or view up to 18 months of statements, check images and deposit slips." (UMB Bank: Small Business Banking).
  • Statements are under Services and Settings. The business online banking help says Services and Settings covers "accessing account statements", and its user guide topics include "Account Statements", "Tax Statements" and "Statement Delivery Preferences" (UMB Bank: Services and Settings Help).
  • Business checking, three tiers. The business checking page lists Essential Business Checking with "100 transactions included per cycle", Advantage Business Checking with "200 transactions included per cycle" and Premier Business Checking with "300 transactions included per cycle", each additional transaction at $0.40. The monthly service fees are $10, $25 and $55, waived with a "$500 average collected balance", a "$10,000 average collected balance" or a "$25,000 average collected balance" (or the combined-balance options listed), and the waiver "must satisfy one of these conditions each monthly service charge cycle" (UMB Bank: Business Checking Accounts).
  • A QuickBooks access fee on two tiers. The same table lists "QuickBooks Monthly Access" at "$9.95 per month" for Essential and Advantage, and Included for Premier, which the page describes as having "upgraded online banking features, QuickBooks access, bundled wires, ACH and more." (Business Checking Accounts). If the client pays it, you'll see that charge on the statement.
  • What counts as a transaction. The footnotes say the included transactions exclude "received ACH debits and credits, bill pay debits, debit card transactions, and ATM transactions", and "Mobile remote deposit and desktop remote deposit items count toward allotted transactions." (Business Checking Accounts). So the item count behind a $0.40 charge won't match the number of lines on the statement.
  • Commercial checking uses an earnings credit. The commercial checking page lists Commercial Checking with "Unlimited deposits and withdrawals" and to "Receive earnings credit to offset treasury services fees", Commercial Performance Checking as interest bearing, and Solutions Commercial Checking with "500 transactions per cycle" (UMB Bank: Commercial Checking Accounts). Expect a net service charge line, not one line per fee.
  • New accounts go online the next business day. "In most cases, new UMB business customers will have online account access one business day after they open their accounts." (Business Checking Accounts).

Where UMB Bank's pages don't line up

  • Reports for everyone, or only Premier. The online banking page says "Online banking with UMB allows you to create reports" (Business and Commercial Banking Online), but the help page marks Reporting as a "Premier Business Online Banking Feature" (UMB Bank: Business Online Banking Help). A client on plain Business Online Banking may not have reports at all; statements are the record either way.
  • 18 months is stated once. The 18-month figure is on the small business banking page only (Small Business Banking). The online banking page says Business Online Banking lets you "view transaction history" without a period, and says nothing about how far back Premier or UMB Direct show statements (Business and Commercial Banking Online). Plan on 18 months, and save every month you can see now, oldest first.
  • The statements help link opens a different topic. On the Services and Settings help page, the "Account Statements" topic links to page 84 of UMB's online user guide, which we found showing "Bill Pay Activity" (UMB Digital Banking User Guide, page 84). Don't rely on that link for statement steps.
  • The fee details live in documents the page doesn't link. The business checking page says "See the Business Schedule of Service Fees and Charges for additional fees." and points to a "Business Checking Solutions Guide" for fees and waivers, and the commercial page to a "Commercial Checking Solutions Guide" (Business Checking Accounts, Commercial Checking Accounts), but we found no link to any of them on those pages. Book the fees the statement shows.

What UMB Bank's pages don't say

  • Which file format, if any, online banking downloads transactions in. No page we read names QBO, QFX, OFX or CSV, says whether QuickBooks Monthly Access is a Web Connect download or a Direct Connect link, or mentions Xero.
  • Whether statements are PDFs, whether they are password protected, and what happens to a closed account's statements.
  • What a statement copy costs, or how to get months older than 18. The fee schedule isn't linked from the pages we read (see above).
  • Statement cycle dates (the checking page only says "monthly service charge cycle"), and how long a business has to report a statement error. Those would be in the deposit account agreement, which we didn't read (see above).

QuickBooks Online

Xero

  • UMB Bank isn't on Xero's US list of banks with validated PDF extraction (checked 12 Nov 2026). 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; UMB Bank's pages we read don't mention 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). Test one statement and check every line before a full catch-up.
  • Because UMB Bank isn't on the validated list, 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).
  • 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: check Statement Delivery Preferences for each account, and save each statement once it posts.
  • The last 18 months: open Account Statements, note the oldest month shown and download every statement, oldest first. The download-before-the-window-closes checklist has the order.
  • Older months: ask the bank for statement copies, and ask the fee first, since the pages we read don't give one.
  • Recent months, from a download or the QuickBooks connection: only after a one-month test matches the statement line by line.

Tie out each statement before you import

  1. Beginning balance + deposits − withdrawals = ending balance for each account on the UMB Bank 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.
  3. Look for charges: the monthly service fee when the waiver wasn't met, the $0.40 per transaction over the allowance and the $9.95 QuickBooks access fee. On commercial checking, look for the net analysis charge. Book what the statement shows.
  4. 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 Commerce Bank, also in Kansas City? See Commerce Bank statement to QuickBooks or Xero. Or nbkc bank? See nbkc bank statement to QuickBooks or Xero. Or BOK Financial (Bank of Oklahoma, Bank of Texas)? See BOK Financial statement to QuickBooks or Xero. Or INTRUST Bank in Wichita? See INTRUST Bank statement to QuickBooks or Xero. Or Great Southern Bank, also in Missouri? See Great Southern Bank statement to QuickBooks or Xero.

Where LedgerReady fits

For UMB Bank, statements stay online for about 18 months and no page we read names a download file format, so the statement PDFs 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.

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.