Hawthorn Bank statement to QuickBooks or Xero: 18 months of E-Statements from enrollment, the $3 paper fee rule and tie-out
Start by checking the bank. In the FDIC's BankFind records (checked 17 Nov 2026), Hawthorn Bank is certificate number 10619, with its main office in Jefferson City, Missouri. It lists an establishment date in 1911, 27 offices (26 in Missouri and 1 in Overland Park, Kansas) and Hawthorn Bancshares as its holding company (FDIC BankFind). An older Hawthorn Bank in Mundelein, Illinois is inactive in BankFind, so match certificate 10619 before you follow this guide. Hawthorn's own About page gives the same certificate number (Hawthorn Bank: About). This guide covers Hawthorn Bank business checking statements, as the pages on hawthornbank.com read on 17 Nov 2026. We never need a bank login.
What Hawthorn's pages say
- E-Statements start when you enroll. The E-Statements page says "E-Statements begin archiving once you enroll, and you'll be able to view, print or save electronic statements for up to 18 months." An email goes out when statements are ready "at the end of each statement cycle" (Hawthorn Bank: E-Statements). Ask the client when they enrolled before you count on older months being online.
- Where to find them. In online banking, select Documents from the left-hand menu (or use the Documents widget below your accounts), then Delivery Preferences, and choose the accounts to enroll (Hawthorn Bank: Online Banking). The business online banking list includes "View E-Notices including E-Statements" (Hawthorn Bank: Mobile and Online Banking). To get a paper copy of a stored statement, the E-Statements page says to log in to Digital Banking, select the account and statement, then select Print (E-Statements).
- Exports to accounting programs. Hawthorn's Online Cash Management list includes "Account Reconciliation" and "Export records to popular accounting programs" (Mobile and Online Banking), and its Online and Payment Solutions page lists the "Ability to export records to popular accounting programs" (Hawthorn Bank: Online and Payment Solutions). The same page describes a separate Treasury Management app that you sign in to "with your Hawthorn Treasury Management credentials", with "custom reporting".
- Business checking accounts. Small Business Checking includes up to 150 free items, and "Items over 150 are $0.40 each". On Business Checking, "Your first 300 items are only $10 per statement cycle", the "Fee disappears with a minimum daily balance of $10,000", and "Items over 300 are $0.40 each". Business Analysis Checking uses a monthly earnings credit that "reduces or even eliminates monthly fee", and the Business NOW Account (for non-profit or governmental entities and sole proprietorships) needs a $2,500 minimum daily balance "to avoid fee of $3.00 per statement cycle" (Hawthorn Bank: Business Checking).
- The 120-day login rule. The same page says "In order to avoid a $3.00 paper statement fee, you must enroll in online banking, opt in for eStatements and maintain an active online banking enrollment." Staying active means logging in "at least once every 120 days", and "If requirements are not met, you will automatically receive paper statements and your account will be charged $3.00 per month." (Business Checking). If nobody logs in for four months, statements may switch to paper, so ask the client for the paper copies too.
- Statement fees. The Business Fee Schedule effective 01/26/2026 lists Electronic Statement "FREE", Paper Statement Fee (Monthly) $3.00, Statement Reprint $3.00, Duplicate Paper Statement (Monthly) $3.00, Check Images with Statement (Monthly) $2.00, Check Copy (Per page) $3.00, Activity Statement Printout $3.00, and Account Research and Account Reconciliation or Balancing at $50.00 per hour, minimum one hour (Hawthorn Bank: Business Fee Schedule, linked from the Fees page). Budget $3.00 a statement for reprints of months that aren't online.
Where Hawthorn's pages don't line up
- Two fee schedules. The Fees page links the schedule effective 01/26/2026 (2026 schedule), while the Business Fee Schedule link on the Business Checking page opens one effective 08/01/2024 (2024 schedule). The statement fees match in both, but the 2024 file also lists card, money order and medallion fees the 2026 file doesn't, and the 2026 file's second page (Online Cash Management) still carries the footer "Version 08/01/2024". Use the 2026 file and ask the bank if a fee you need isn't in it.
- 18 months, but only from enrollment. The 18 months starts when archiving begins at enrollment, so it isn't a look-back (E-Statements). A client who enrolled six months ago has six months online, not 18.
- Several logins. The site's login menu lists Online Banking, Treasury Management, Remote Deposit, Credit Card, Loan Payment, Corporate Credit Card and Trust Portal logins, and the business pages call the main one Business Online Banking on one page (Online and Payment Solutions) and Business Digital Banking on another (Digital Banking Solutions). Ask the client which login holds each account, and whether card statements are separate.
- Office counts and age. The About page says "We have 18 locations throughout Missouri" and "For more than 160 years, we've served families, local businesses, and community groups." (About). BankFind lists 27 offices, including one in Kansas, and an establishment date in 1911 (FDIC BankFind). Neither page explains the difference.
What Hawthorn's pages don't say
- Which "popular accounting programs" the export supports, and in which formats. No page we read names QBO, QFX, OFX or CSV, none mentions Web Connect or Direct Connect for QuickBooks, and none mentions Xero. None says how far back an export or the transaction history reaches.
- How far back a Statement Reprint can go, and how to order one (Business Fee Schedule gives only the price).
- Whether the Treasury Management login shows statements, or only reports (Online and Payment Solutions).
- How long you have to report an error on a business statement. We didn't find a business deposit account agreement in the pages we read.
- Whether closed accounts keep their E-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.
- An export from online banking is a file of transactions, not a statement. Before you upload one, check it against the statement for the same dates: 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
- Hawthorn Bank isn't on Xero's US list of banks with validated PDF extraction (checked 17 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. 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). Hawthorn's pages don't show an export layout, so expect to rearrange columns.
- 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 E-Statements on for every account, have someone log in at least once every 120 days, and save each statement PDF when the email says it's ready.
- Past months online: open Documents, note the oldest statement shown and download every one, oldest first. Statements from before enrollment won't be there. The download-before-the-window-closes checklist has the order.
- Months that aren't online: use the client's paper statements, or ask the bank for reprints ($3.00 each on the 2026 schedule) and ask how far back they go.
- Recent months, from a download: an online banking export 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 Hawthorn 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 a month came on paper, check it chains into the E-Statements on both sides.
- Look for charges: items over 150 or 300 at $0.40 each, the $10 Business Checking fee below a $10,000 daily balance, the $3.00 paper statement fee, check images with statement, 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 Central Bank, also based in Jefferson City? See Central Bank (Missouri) statement to QuickBooks or Xero. Or Commerce Bank? See Commerce Bank statement to QuickBooks or Xero. Or Great Southern Bank in Springfield? See Great Southern Bank statement to QuickBooks or Xero. Or UMB Bank in Kansas City? See UMB Bank statement to QuickBooks or Xero. Or Busey Bank, which also has offices in Missouri? See Busey Bank statement to QuickBooks or Xero. Or BOK Financial (Bank of Oklahoma)? See BOK Financial statement to QuickBooks or Xero.
Where LedgerReady fits
For Hawthorn Bank, online E-Statements only reach back to the enrollment date and no more than 18 months, and no page names the export formats, 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.