MidFirst Bank statement to QuickBooks or Xero: 18 months of business eStatements, the QuickBooks download and tie-out
Start by checking the name on the statement. In the FDIC's BankFind records (checked 11 Nov 2026), the active MidFirst Bank is in Oklahoma City, Oklahoma, was established in 1911, has 95 offices and uses midfirst.com as its web address (FDIC BankFind). BankFind also lists two inactive institutions with the same name in the same city, so match the certificate number 4063 if you look it up yourself. Client banks with BancFirst or BOK Financial (Bank of Oklahoma) instead? See BancFirst statement to QuickBooks or Xero or BOK Financial statement to QuickBooks or Xero. This guide covers MidFirst business checking statements, as its pages read on 11 Nov 2026. MidFirst's product pages are location-based and say "These accounts may not be available in your area." (MidFirst: Business Checking), so check the account name on your client's statement. We never need a bank login.
What MidFirst's pages say
- Two business online banking tiers. Business Online Banking Express is "Free for all MidFirst business checking accounts", and "Business Online Banking offers all of the Business Online Banking Express features, plus additional payment options and enhanced security." (MidFirst: Business Online and Mobile Banking).
- A QuickBooks download. Business Online Banking Express lists "View account balances, transactions and check images online", "View eStatements and eNotices" and "Download information to QuickBooks®" (MidFirst: Business Online Banking Express).
- Business eStatements, for up to 18 months. You can "Receive deposit, analysis and/or loan statements electronically through Business Online Banking and Business Online Banking Express with eStatements." (MidFirst: Business eStatements and eNotices). The treasury management page adds "Download and print statements conveniently for up to 18 months" (MidFirst: Information Management).
- The administrator turns eStatements on, account by account. The enrollment guide has the administrator "select Online as the Delivery Preference for the Account Statement, Analysis Statement and/or Notice for each account", and other users only see them once entitled: "To entitle Users to receive eStatements and/or eNotices, the Administrator or Administrative User should complete the following steps" (MidFirst: Online Statements and Documents Enrollment Guide, dated 09-2021). If a user can't see a statement, ask the administrator to check that user's entitled accounts.
- Basic and Advantage checking fees. Basic Business Checking lists "175 transactions per month included", a "Monthly statement that includes check images", "Free eStatements", a "$11 monthly fee if average monthly ledger balance falls below $750", "$0.45 per excess transaction posted" and "$2.50 per $1,000 in cash deposited if total monthly cash deposits exceed $7,500" (MidFirst: Basic Business Checking). Business Advantage Checking lists a "$90 monthly fee if combined monthly average ledger balance in company’s checking, savings and/or money market accounts falls below $100,000", "$0.40 per excess transaction posted over 500" and "Free eStatements including check images" (MidFirst: Business Advantage Checking).
- Commercial Checking has an analysis statement. The Commercial Checking page lists a "Detailed monthly analysis statement consolidates all account charges and service fees" and says "Earnings credit may offset fees for transactions, account activity and treasury management services". For prices it says "please ask your business banker for our Fee Schedule for Commercial Checking Accounts and our Fee Schedule for Treasury Management and Online Banking Services." (MidFirst: Commercial Checking).
- Reconciliation reports are for checks. With Full Reconciliation, "A detailed report lists the status of all items in your company's disbursement account, both paid and outstanding." (MidFirst: Information Management). That helps with an outstanding checks list; it is not a statement.
- Autobooks sits inside online banking. MidFirst's Autobooks page says you can "View all your transactions in one place, automate tedious bookkeeping tasks and quickly generate a variety of financial reports", that "Customer payments are deposited within two business days" and that "Transaction fees are just 3.49% when you accept a payment via card and 1% when you accept a bank transfer (ACH)." (MidFirst: Autobooks).
- Personal Online Banking is different. For personal accounts, the online banking FAQ says "You are able to view 13 months of online account activity history and 48 months of account statements.", that "Your documents will be available as PDF documents online." and that you can "download account information to Microsoft Money® or Quicken" (MidFirst: Online Banking FAQs). That matters if a sole owner runs business money through a personal account.
Where MidFirst's pages don't line up
- "Any time" or 18 months. The business eStatements page says "Access current and historical statements any time" (Business eStatements), while the treasury management page says statements can be downloaded and printed "for up to 18 months" (Information Management). Plan on 18 months, and save older ones before they drop off.
- 18 months for business, 48 months for personal. Personal Online Banking keeps 48 months of statements (Online Banking FAQs), so don't assume a business login reaches back as far as a personal one.
- A QuickBooks download with no format. Business Online Banking Express says "Download information to QuickBooks®" (Business Online Banking Express), but no business page we read says whether that is a QBO (Web Connect) file, a CSV or something else, or how far back it reaches. The personal FAQ names Microsoft Money and Quicken, not QuickBooks. Try the download for one recent month and compare it line by line with that month's statement before you rely on it.
- Two kinds of monthly statement on Commercial Checking. The enrollment guide lists the Account Statement and the Analysis Statement as separate documents (Enrollment Guide), and the Commercial page describes the analysis statement as consolidating charges and fees (Commercial Checking). Tie out to the account statement; use the analysis statement to explain the fees.
What MidFirst's pages don't say
- Which file format the business QuickBooks download produces, or whether a CSV, QFX or OFX download exists for business accounts. No business page we read names QBO, QFX, OFX or CSV.
- Whether business eStatements are PDFs (only the personal FAQ says so), whether they are password protected, and what happens to a closed account's statements.
- What a statement copy or a business paper statement costs (the fee schedules aren't published on the pages we read), and statement cycle dates.
- How long a business has to report a statement error.
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.
- 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 holds online, 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). If you use MidFirst's QuickBooks download, check which dates already came in before you add anything from statements. For periods with only a PDF, see can QuickBooks Desktop import a PDF bank statement.
Xero
- MidFirst Bank isn't on Xero's US list of banks with validated PDF extraction (checked 11 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; MidFirst's business 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 MidFirst 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: have the administrator set Online delivery for each account and entitle the users who need statements, then save each statement once it posts.
- The last 18 months: open the statements list, 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 fee schedule isn't published on the pages we read.
- Recent months, from the QuickBooks download: only after the one-month test above matches the statement line by line.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance for each account on the MidFirst statement, to the cent, using the statement's own period dates. On Commercial Checking, use the account statement, not the analysis statement.
- Chain the statements: each ending balance equals the next statement's beginning balance, and each period starts the day after the last one ended.
- Look for charges: the $11 fee on Basic below a $750 average ledger balance, the $0.45 excess transaction fee, the $90 fee on Business Advantage below $100,000, the $0.40 fee over 500 transactions and the cash deposit fee. Book what the statement shows.
- If the client uses Autobooks, match each Autobooks deposit on the statement to the payments behind it. The page gives the card and ACH fee rates but doesn't say whether fees come out of the deposit or are charged separately, so check one month before you set up a rule.
- 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 BancFirst? See BancFirst statement to QuickBooks or Xero. Or BOK Financial (Bank of Oklahoma)? See BOK Financial statement to QuickBooks or Xero. Or Commerce Bank? See Commerce Bank statement to QuickBooks or Xero. Or Simmons Bank, which also has Oklahoma offices? See Simmons Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For MidFirst, the QuickBooks download's file format isn't named and business statements stay online for up to 18 months, 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.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.