Montecito Bank and Trust statement to QuickBooks or Xero: 18 months of statements, Web Connect and tie-out
This guide is about Montecito Bank and Trust (montecito.bank), whose deposit account terms say accounts are governed by California law (Montecito Bank and Trust: Deposit Account Terms and Disclosures). The bank offers Business Online Banking, with layered employee permissions and dual control (Montecito Bank and Trust: Business Online and Mobile Banking), and Commercial Center, an online banking and cash management platform for commercial clients (Montecito Bank and Trust: Commercial Center). Here's what the bank's pages say, and don't, about getting a business account's history into QuickBooks or Xero.
What Montecito Bank and Trust's pages say
- 18 months of statements as PDFs. The Business Online Banking Guide (Rev. 08/25) says 18 months of statements and notices are available under Statements and Documents, that statements open in a PDF format you can view, print or save, that they look identical to the ones you get in the mail, and that they are available for checking, analyzed checking, savings, loan and line accounts. You can search them by account and by start and end date (Montecito Bank and Trust: Business Online Banking Guide).
- A transaction download and Web Connect. The same guide says you can search account activity by type, description, check number, amount or date range, then select Download to get the filtered transactions as an Excel file. It also lists Web Connect for downloading Quicken and QuickBooks compatible files (Montecito Bank and Trust: Business Online Banking Guide). The business online banking page says you can review and export transaction history (Montecito Bank and Trust: Business Online and Mobile Banking).
- Three ways to connect QuickBooks or Quicken. The Quicken and QuickBooks page lists an online connection for QuickBooks Online and Quicken Online that syncs when you're logged in, Direct Connect for QuickBooks Desktop and Quicken that downloads when you update your accounts in the software, and Web Connect, a file you download from Online Banking and import into QuickBooks Desktop, QuickBooks Online or Quicken. A first Direct Connect attempt may show an error until you authorize it under Settings, Authorized Apps (Montecito Bank and Trust: Quicken and QuickBooks).
- eStatements. The guide says eStatements send an email when the statement is ready in Online Banking and stop paper statements by mail, and that you enroll under Statement Delivery after agreeing to the Electronic Communications Agreement (Montecito Bank and Trust: Business Online Banking Guide). The deposit terms say you need a valid email address to receive eStatement notifications (Montecito Bank and Trust: Deposit Account Terms and Disclosures). Basic Business Checking lists an $8 monthly maintenance fee, avoided by enrolling in eStatements (Montecito Bank and Trust: Basic Business Checking).
- Review windows. The deposit terms (Rev. 3/16/2026) say the time to examine a statement and report unauthorized signatures or alterations will not exceed 30 days from when it is first sent or made available, and that if you don't report unauthorized signatures, alterations, forgeries or any other errors within 60 days, you can't assert a claim on any items in that statement (Montecito Bank and Trust: Deposit Account Terms and Disclosures).
- Fees. The general Schedule of Fees and Charges, effective October 1, 2026, lists interim statements at $5 per statement, hold statements at $5 per month, check imaging on paper statements at $2.50 per statement, and record retrieval research at $40 per hour with a one-hour minimum, plus $0.25 per copy (Montecito Bank and Trust: Schedule of Fees and Charges).
Before the client changes or closes anything
- Save every statement PDF while it's inside the 18 months. Anything older has to come from the client's saved files or a research request.
- Closing an account. The Electronic Communications Agreement says it becomes void when a deposit account closes and that all online banking services for that account end immediately (Montecito Bank and Trust: Electronic Communications Agreement). Download the statements and check images first.
- Check images. The guide says you can view images of posted checks and deposits from account activity (Montecito Bank and Trust: Business Online Banking Guide), and the deposit terms say originals are destroyed after a set retention period, with microfilm or electronic copies kept instead (Montecito Bank and Trust: Deposit Account Terms and Disclosures).
Where Montecito Bank and Trust's pages don't line up
- A consumer agreement for business eStatements. The business guide says to agree to the Electronic Communications Agreement to enroll in eStatements (Montecito Bank and Trust: Business Online Banking Guide), but the agreement as published says it amends the Consumer Online Banking Agreement for consumer accounts, and its list of electronic communications doesn't include statements (Montecito Bank and Trust: Electronic Communications Agreement).
- Two review windows. The deposit terms give 30 days for unauthorized signatures and alterations and 60 days for any errors (Montecito Bank and Trust: Deposit Account Terms and Disclosures). Plan on reviewing each statement within 30 days.
- An online agreement we couldn't find. The deposit terms refer to an Online Banker Agreement and say online banking error resolution is in the Online Agreement and Disclosure (Montecito Bank and Trust: Deposit Account Terms and Disclosures), but the disclosures page lists only the consumer online banking agreement and the Commercial Center bill pay terms (Montecito Bank and Trust: Disclosures and Rates).
- Real time or on update. The business online banking page says the QuickBooks and Quicken connection keeps your data updated in real time (Montecito Bank and Trust: Business Online and Mobile Banking), while the Quicken and QuickBooks page says Direct Connect downloads when you update your accounts and the online connection syncs when you're logged in (Montecito Bank and Trust: Quicken and QuickBooks). Check the feed's last date against the statement.
What Montecito Bank and Trust's pages don't say
- Xero. No page we read mentions it.
- The file extension behind Web Connect (QBO, QFX or other) or the Excel download (XLSX or CSV), what columns the download has, or how far back either reaches. The guide is dated August 2025, so the screens may have changed.
- Statement access and history depth in Commercial Center. Its page mentions custom reports in the file type you choose, delivered by email with an optional password (Montecito Bank and Trust: Commercial Center), and the guide covers Business Online Banking only.
- A business online banking agreement, so no online-banking-specific error window for business accounts beyond the deposit terms. For business customers the deposit terms say other agreements, such as an account analysis agreement, may override some terms (Montecito Bank and Trust: Deposit Account Terms and Disclosures).
- Any merger or system conversion. None of the pages we read mention one.
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 Excel download isn't one of those file types, so it would need saving as CSV in the right columns first. Check its dates and totals against the statement PDF before you rely on 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, and once you delete downloaded transactions you can't download them again (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
- Xero's US list of banks with validated PDF extraction for selected statement types includes Montecito Bank and Trust, written there with an ampersand (checked 1 Nov 2026). Xero also recommends OFX over PDF when your bank offers it; the bank's pages don't mention an OFX download. 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). Check every imported line against the PDF.
- If you build a CSV instead, for example from the Excel download, 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: each eStatement PDF, saved when the email arrives, plus a QuickBooks connection or a Web Connect file for the same statement dates if one fits your software.
- The last 18 months: the statements in Statements and Documents, with any download checked against them.
- Older than 18 months: the client's saved statements, or a record retrieval request, which the fee schedule prices at $40 per hour with a one-hour minimum plus $0.25 per copy.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the Montecito Bank and Trust 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.
- Sum the download's lines for the same dates and compare them with the statement's net change. A difference usually means a date range cut at month end instead of the statement end, a duplicate from an overlapping download, or an item that posted after the file was made.
- Spot-check the first and last days of the period and the largest few items against the PDF, using the check images for any check that doesn't match.
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 Mechanics Bank? See Mechanics Bank statement to QuickBooks or Xero. Or City National Bank? See City National Bank statement to QuickBooks or Xero. Or Redwood Credit Union? See Redwood Credit Union statement to QuickBooks or Xero.
Where LedgerReady fits
For Montecito Bank and Trust, statements stay online for 18 months, the pages don't name the download file types, and the review window can be as short as 30 days, so the PDF statements are the record for catch-ups, for Xero and for any month a download or feed can'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.