1st Source Bank statement to QuickBooks or Xero: 24 months of e-Statements, CSV and OFX exports, BBO Treasury and tie-out
Start by checking the bank. In the FDIC's BankFind records (checked 19 Nov 2026), 1st Source Bank is certificate number 9087, with its main office in South Bend, Indiana. It lists an establishment date in 1922, 81 offices (72 in Indiana, 8 in Michigan and 1 in Florida) and 1st Source Corp as its holding company (FDIC BankFind). BankFind shows no merger of 1st Source Bank into another bank; the last bank it absorbed was First National Bank, Valparaiso, in 2008. A BankFind name search also turns up two inactive banks with 1st Source in the name, both absorbed decades ago, so match certificate 9087 before you follow this guide. This guide covers 1st Source Bank business checking statements, as the pages on 1stsource.com read on 19 Nov 2026. We never need a bank login.
What 1st Source's pages say
- 24 months of e-Statements. The Electronic Statement Consent and Authorization (July 2025) says e-Statements are delivered through Online and Mobile Banking or BBO Treasury, and that an e-Statement "will be available for viewing, downloading, or printing for up to twenty-four (24) months from the date that any such statement is made available to you" (1st Source: Electronic Statement Consent and Authorization). For a catch-up older than two years, the client's saved PDFs or bank copies are the only source.
- Two business logins. Online and Mobile Banking for Business is the standard login; for Treasury Services the page says "don't enroll through the standard app setup" and to work with a Treasury Specialist instead (1st Source: Online and Mobile Banking for Business). Treasury Services clients use Business Banking Online Treasury, which the bank calls BBO Treasury (1st Source: Business Banking Online Treasury). Ask the client which one each account uses.
- CSV or OFX from the standard business login. The business online banking page lists "Export data in CSV (spreadsheets) or OFX (Quicken/QuickBooks) formats." Its FAQ says you can "Search and filter transactions by date or keyword" and "Export in CSV (spreadsheets) or OFX (for QuickBooks and Quicken)" (Online and Mobile Banking for Business).
- An accountant login. The same page says you can "Grant dedicated logins to employees and accountants." with custom permissions (Online and Mobile Banking for Business). Ask the client for view-only access rather than their own password.
- BBO Treasury: 18 months of history. The BBO Treasury page lists the "Ability to export account history in various formats, including QuickBooks" and says you can "Accumulate up to 18 months of rolling transaction history on deposit accounts which includes a running balance" (Business Banking Online Treasury; the Treasury Services page says much the same, Treasury Services).
- Turning e-Statements on in BBO Treasury. The FAQ says to log in, scroll to "Resource Center", click "Other Resources", then under "Additional Resources" select "Go Paperless With e Statements", and that "An Authorized Signer on the account must request e statement enrollment or the request will be declined." (1st Source: FAQ). For the standard login, the FAQ says to click "View e-Statements" on the e-Statements tab and accept the disclosure.
- Dormant accounts drop out of online banking. The e-Statement consent says a checking account with no customer activity for one year becomes dormant, that "Dormant Accounts are not viewable through the Online and Mobile Banking service", and that it reverts to paper statements (Electronic Statement Consent and Authorization). For a quiet side account, expect paper statements, not PDFs.
- Business checking accounts. The Business Fee Schedule (effective August 2026) lists Business Value Checking at $5 a month, waived with a $100 minimum daily balance, 200 items included and $0.40 each over; Business Checking at $20, waived with a $20,000 minimum daily balance, 500 items and $0.50 each over; Business Analysis Checking and Business Checking with Interest at $20 with an earnings credit and per-item pricing ($0.40 per deposit posted, $0.20 per check paid, $0.15 per ACH debit or credit, $0.15 per item deposited); and a $3 paper statement fee "per statement cycle" on each (1st Source: Business Fee Schedule).
- Statement copies and check images. The same schedule lists an Additional Statement Fee of $5 per statement for a one-time copy, a Check Copy Fee of $3 per check, and a $5 per cycle fee to put images of the back of checks on paper statements only; it says images of the front of checks are free on paper and electronic statements (Business Fee Schedule).
Where 1st Source's pages don't line up
- How to avoid the paper statement fee. For Business Value Checking and Business Checking, the comparison table on the checking page says to meet the minimum daily balance or be "signed up for BBO Treasury and enrolled in eStatements" (1st Source: Business Checking Accounts). The fee schedule says the minimum daily balance, or simply "By enrolling in electronic statements" (Business Fee Schedule). Book the fee the statement actually shows.
- Check images. The checking page lists "Digital scans of your processed checks (check images) on your monthly statements" for every checking account (Business Checking Accounts); the fee schedule says only the fronts are free, and the backs cost $5 a cycle and come on paper statements only (Business Fee Schedule). If you need check payees, the fronts are what an e-Statement will show.
- 24 months of statements, 18 months of history. e-Statements stay online up to 24 months (e-Statement consent), while BBO Treasury keeps up to 18 months of rolling transaction history (BBO Treasury). Months 19 to 24 back may exist only as statement PDFs.
- Named formats on one page, not the other. The standard business login names CSV and OFX (Online and Mobile Banking for Business); BBO Treasury says only "various formats, including QuickBooks" (BBO Treasury). Check what each login actually offers before you plan around one file type.
What 1st Source's pages don't say
- How far back the standard business login's CSV or OFX export reaches.
- Whether e-Statements for a closed account stay online, or how to get statements older than 24 months, beyond the $5 copy fee. The fee schedule doesn't say how far back copies go.
- A direct connection to QuickBooks or Xero. The Quicken Direct Connect page describes Quicken as "the personal financial software" (1st Source: Quicken Direct Connect), and no page we read mentions Xero.
- How long you have to report an error on a business statement (the consent PDF refers to the account agreement, which we didn't open), 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). OFX isn't on that list, so for QuickBooks Online use the CSV export or the statement. 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.
- A CSV or OFX export is a list of transactions, not a statement. Before you upload one, set its dates to the statement's own period and check it against the statement: 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
- Our check of Xero's US list of banks with validated PDF extraction (19 Nov 2026) didn't turn up 1st Source Bank. 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). Since the standard business login offers OFX, test one month of OFX against the statement first.
- 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). 1st Source's pages don't show its CSV layout, so check the signs and drop any balance column before you import.
- 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 and save each statement PDF every month, since each one leaves online banking after 24 months.
- The last 24 months: download every e-Statement now, oldest first, starting with the oldest still shown. The download-before-the-window-closes checklist has the order.
- Older than 24 months, or dormant accounts: use the client's saved PDFs or paper statements, or ask the bank for copies ($5 per statement on the fee schedule) and ask how far back they go.
- Recent months, from an export: a CSV or OFX 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 1st Source 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.
- Count the lines: the number of transactions you import should equal the number on the statement for that period.
- Look for charges: the $5 or $20 account service fee, $0.40 or $0.50 per item over the included count, per-item analysis charges net of earnings credit, the $3 paper statement fee, $5 check image fee, and overdraft, NSF 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 Horizon Bank, also in northern Indiana and Michigan? See Horizon Bank statement to QuickBooks or Xero. Or German American Bank in Jasper? See German American Bank statement to QuickBooks or Xero. Or Old National Bank? See Old National Bank statement to QuickBooks or Xero. Or First Internet Bank? See First Internet Bank statement to QuickBooks or Xero. Or Huntington? See Huntington statement to QuickBooks or Xero.
Where LedgerReady fits
For 1st Source Bank, e-Statements leave online banking after 24 months and BBO Treasury keeps 18 months of history, 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.