Prairie Community Bank statement to QuickBooks or Xero: Web Connect .qbo, eStatements, the fee schedule and tie-out
Prairie Community Bank says it was established on April 2, 1998 as Prairie State Bank, a locally owned and independent bank, and opened as Prairie Community Bank on January 1, 2004 (Prairie Community Bank: Our Story). Its account agreement (Rev. Sept 2026) lists offices in Marengo, Union, Elgin and Woodstock, Illinois (Prairie Community Bank: Account Agreement and Disclosures, PDF). In the FDIC's BankFind records (checked 8 Nov 2026) only one active US bank has "Prairie Community" in its name, this one, headquartered in Marengo, Illinois, with the same April 2, 1998 start date. Our search covered only "Prairie Community", not every bank with "Prairie" in its name, so check that the statement header and web address match before you rely on the menus and terms below; the tie-out steps apply either way. Here's what Prairie Community Bank's public pages say, and don't, about getting an account's history into QuickBooks or Xero.
What Prairie Community Bank's pages say
- QuickBooks through Web Connect, for business customers. The How to Connect to Quickbooks page, under Business, says that using Web Connect, Prairie's business customers can manually import transactions from their online business banking accounts: you download a transaction file (.qbo) from the bank's website, then import it into QuickBooks. It says the option may be called "Download account activity," "Download account history," or something similar, and the import steps are File, Import, From Web Connect. Checking, savings and money market accounts map to QuickBooks bank accounts, credit cards to credit card accounts, and a line of credit to an Other Current Liability account (Prairie Community Bank: How to Connect to Quickbooks).
- Business eStatements. The Business Digital Banking page lists "Access eStatements" among the online banking features and says you can "Access and print or download your account statements online", with eStatements available "the first business day of the month" (Prairie Community Bank: Business Digital Banking). Every business checking account and the Business Money Market Account list "Free eStatements with check imaging" (Prairie Community Bank: Business Checking and Money Market).
- Personal online banking: Quicken, not QuickBooks. The Personal Digital Banking page lists "Download account information and activity to Quicken" and, for eStatements, "Next-day statement retrieval" and an email notification when a statement is ready (Prairie Community Bank: Personal Digital Banking).
- Statement frequency. The agreement says you will get at least a monthly account statement unless there are no transfers in a particular month, and a statement at least quarterly in any case. It also says the bank may choose not to send statements on accounts it considers inactive (Account Agreement and Disclosures).
- Business accounts and their charges. Small Business Checking: $100 to open, the first 150 debit items per statement cycle free, then $0.25 per check or debit item. Advantage Business Checking: $100 to open, a $10.00 monthly service fee and $0.20 per check or debit item, with an earnings credit applied to fees. Business Interest Checking: $5,000 to open, no monthly service fee with a $5,000 average monthly balance (the table shows $15), the first 100 debit items per statement cycle free, then $0.20 each, interest paid monthly. Community Checking is for non-profits and municipalities only. The Business Money Market Account charges a $10.00 service fee for each debit over 6 in a cycle (Business Checking and Money Market). Business Savings pays interest quarterly, charges a $10.00 quarterly fee below the $500 minimum daily balance and $3.00 for each debit over 6 in a quarter, and lists free eStatements (Prairie Community Bank: Business Savings).
- Personal accounts. Simply Checking charges $3.00 per month for paper statements, waived for those 60 and over; the Let's Grow Earnings and Let's Grow Rewards accounts require you to be enrolled in eStatements rather than paper statements to earn their rewards; the Premiere Money Market Account has a $10.00 monthly fee below its $1,000 minimum daily balance (Prairie Community Bank: Personal Checking and Money Market).
- The fee schedule. The Service and Fee Schedule printed at the end of the agreement lists an interim statement at $5.00, check images at $1.00 each, photocopies at $1.00 per page, account research and account reconcilement at $25.00 per hour each, and a dormant account fee of $5.00 per month (Account Agreement and Disclosures).
- Error-reporting windows. Business customers must report errors or discrepancies within 14 calendar days after the statement is sent or made available. For consumers, an unauthorized signature or alteration must be reported within 60 days, and electronic transfer errors no later than 60 days after the first statement on which the problem appeared (Account Agreement and Disclosures). For a business catch-up, that means a month nobody reviewed may already be past the window.
Where Prairie Community Bank's pages don't line up
- QuickBooks Online or QuickBooks Desktop. The QuickBooks page says to log into your QuickBooks Online account first, but the rest of its steps use Web Connect, File, Import and Downloaded Transactions (How to Connect to Quickbooks), and Intuit describes Web Connect in its QuickBooks Desktop help (Intuit: set up bank accounts for Bank Feeds in QuickBooks Desktop). In QuickBooks Online, upload the .qbo file through Intuit's manual upload instead (see below).
- The download is described on one page and missing from another. The .qbo download is on a Business page, yet the Business Digital Banking feature list mentions no download or export at all (Business Digital Banking), and the personal list names Quicken but not QuickBooks (Personal Digital Banking). Try one download on one account before you plan a catch-up around it.
- Two timings for eStatements. The business page says eStatements become available the first business day of the month (Business Digital Banking); the personal page promises next-day statement retrieval (Personal Digital Banking). Neither gives cycle dates, so take each period from the statement itself.
- A fee schedule "available upon request" that is already printed. The agreement says the current Service and Fee Schedule is available upon request, while the same PDF ends with a Service and Fee Schedule (Account Agreement and Disclosures). Confirm the printed one is current before you plan around a copy or research fee.
- Free check imaging, or $1.00 per image. The account pages list free eStatements with check imaging (Business Checking and Money Market), while the fee schedule lists check images at $1.00 each (Account Agreement and Disclosures). Neither says which images the fee covers; ask before you order images the eStatement may already show.
What Prairie Community Bank's pages don't say
- Any file type other than .qbo: no CSV, OFX or QFX file is named, the Quicken download's file type isn't given, and Xero is never mentioned.
- How far back the Web Connect download reaches, or how many months of eStatements stay online.
- What happens to eStatement access after an account closes.
- Statement cycle dates, and whether Business Savings, with its quarterly interest and fee, gets a monthly or a quarterly statement.
- What a copy of a past statement costs: the schedule lists an interim statement, photocopies and research, but no line for a statement copy.
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.
- The .qbo file from Prairie's Web Connect option is one of the file types Intuit's manual upload accepts; check its size and date range against the rules above before you upload it.
- 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 describes Web Connect as a .QBO file you download from your bank and import (Intuit: set up bank accounts for Bank Feeds in QuickBooks Desktop), and 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). That is the route Prairie's QuickBooks page describes; for periods with only a PDF, see can QuickBooks Desktop import a PDF bank statement.
Xero
- "Prairie Community Bank" is on Xero's US list of banks with validated PDF extraction (checked 8 Nov 2026). Xero says it can extract data from selected statement types from these banks, so test one statement and check every line before a full catch-up. Xero recommends OFX over PDF when your bank offers it; Prairie Community Bank's pages 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).
- 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: use eStatements and save each statement PDF when it posts, one file per account.
- Recent activity, QuickBooks: the Web Connect .qbo download covers it, but the bank gives no date range, so tie every file to that month's statement.
- Everything online now: download every eStatement you can see, since the pages don't say how long they stay online or what happens after an account closes.
- Before that: ask the bank for copies, and ask what they will cost first, since the schedule lists photocopies at $1.00 per page and research at $25.00 per hour but no statement copy line.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the Prairie Community Bank 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.
- Look for the per-item charges (over 150 debit items on Small Business Checking, over 100 on Business Interest Checking, $0.20 per item on Advantage), the $10.00 Advantage monthly fee and its earnings credit, and the $10.00 money market charge per debit over 6.
- For Business Savings, expect interest and any $10.00 fee quarterly, not monthly. Then 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 Byline Bank? See Byline Bank statement to QuickBooks or Xero. Or Old National Bank? See Old National Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For Prairie Community Bank, the public pages describe a Web Connect .qbo download aimed at QuickBooks Desktop and a Quicken download, but give no date range, name no CSV or OFX file and say nothing about Xero, so the statements are the record for catch-ups, for Xero and for any month the download doesn'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.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.