Washington Trust Bank statement to QuickBooks or Xero: 12 months of eStatements, two business platforms and tie-out
This guide is about Washington Trust Bank of Spokane, Washington (watrust.com), which has more than 40 locations in Washington, Idaho and Oregon. It is not about the Rhode Island bank with a similar name. Washington Trust Bank business clients use one of two platforms: WTB Online, which the bank calls a simplified digital banking platform for businesses (Washington Trust Bank: Digital Banking in WTB Online), or Business Digital Banking, the platform with ACH, BAI reporting and scheduled exports (Washington Trust Bank: Business Digital Banking). Here's what the bank's pages and agreements say, and don't, about getting a business account's history into QuickBooks or Xero.
What Washington Trust Bank's pages and agreements say
- Up to 12 months of eStatements. The WTB Online Agreement (for Businesses) says you can view, print or save the current month's eStatement and previous eStatements up to a maximum of 12 months from the current statement date (Washington Trust Bank: WTB Online Agreement (for Businesses), TAC-0008 8/26). The Business Services Terms and Conditions say the same, up to a maximum of twelve (12) months (Washington Trust Bank: Business Services Terms and Conditions, TAC-0001 7/25).
- How eStatements start. Both agreements describe the eStatement as an electronic text document you can view and save to your computer or print, and say you enroll by following the prompts within the Statements screen; once an account is enrolled, paper statements stop. They also say you must view the current eStatement within five (5) days of the email notification that it is available (WTB Online Agreement (for Businesses)).
- A download, file type not named. Under Account Information, both agreements list the ability to download your account information to specific file formats, without naming them. The WTB Online agreement adds that transaction activity shown in WTB Online is for informational purposes only and is not equivalent to the official statement information on the bank's records, and that the bank's records control in any conflict (WTB Online Agreement (for Businesses)).
- Exports and reporting in Business Digital Banking. The Business Digital Banking page lists BAI reporting, ACH EDI reporting and scheduled exports, and describes the platform as running from basic daily balance information and transaction activity to reporting and data exports (Washington Trust Bank: Business Digital Banking). The Treasury Management page describes prior-day account reporting in various formats, sent by SFTP to your preferred vendor or ERP on a schedule (Washington Trust Bank: Treasury Management).
- Reports and aggregation in WTB Online. The WTB Online page lists Reports and Secure data aggregation under reporting and connectivity, and says business enrollment starts with the Priority Service team or a local branch (Washington Trust Bank: Digital Banking in WTB Online). The Business Services Terms and Conditions say that access to WTB Online for account aggregation through external applications may be limited to account balance and transaction data only (Business Services Terms and Conditions).
- No charge for eStatements, paper statements or copies. The small business checking comparison lists no charge for eStatements and images with statement at no additional charge for Smart Business Checking and Performance Business Checking (Washington Trust Bank: Small Business Checking). The Common Features (Limits and Fees) disclosure lists Paper Statement, Additional Statement Mailed and Statement Copy at no charge (Washington Trust Bank: Common Features (Limits and Fees), 12/2025).
- Sharing a login makes that party your agent. The WTB Online agreement says anyone you share your login information with is deemed your authorized agent, that you are solely responsible for all transactions they conduct, and that to revoke a third-party application's access you need to change your username and password (WTB Online Agreement (for Businesses)). Have the client download statements, or set you up as your own user, rather than handing you their login.
Before the client changes or closes anything
- Save the oldest months first. Only up to 12 months of eStatements stay in digital banking (WTB Online Agreement (for Businesses)), so each new statement can push the oldest one out of reach. Download from the oldest statement forward, every month.
- Inactive logins can be shut off. Both agreements say the bank may terminate Digital Banking for inactivity after 12 months (WTB Online Agreement (for Businesses)). For a client who rarely logs in, save the statements before access lapses.
- Older months are copies from the bank. The fee disclosure lists Statement Copy at no charge (Common Features (Limits and Fees)), so for months past the 12-month window, ask the bank for copies rather than rebuilding them from transaction history.
Where Washington Trust Bank's documents don't line up
- Paper statement charge. Both agreements say that if you are enrolled in eStatements when Services are canceled, you will begin to receive and be charged for paper statements (WTB Online Agreement (for Businesses)). The Common Features (Limits and Fees) disclosure lists Paper Statement, mailed and not electronic, at no charge (Common Features (Limits and Fees)). Confirm with the bank before a client cancels digital banking.
- A fee for digital banking, or not. The WTB Online agreement says Washington Trust Bank does not charge a fee to access Digital Banking (WTB Online Agreement (for Businesses)). The Business Services Terms and Conditions say the bank may charge a fee to access Digital Banking (Business Services Terms and Conditions), and the small business checking page lists a Business Digital Banking Business Module among services added for an additional charge under the Commercial Services Price List (Washington Trust Bank: Small Business Checking).
- Which platform has the eStatements. The small business checking page promises 24-hour account access with Business Digital Banking and eStatements available through your digital banking account (Washington Trust Bank: Small Business Checking), while the small business digital banking page presents WTB Online as the platform for businesses (Washington Trust Bank: Digital Banking in WTB Online). On the Business Digital Banking page, the notice for businesses using WTB Online links to the personal digital banking page (Washington Trust Bank: Business Digital Banking). The Business Services Terms and Conditions say available services may vary by application (Business Services Terms and Conditions). Ask the client which login they use before you plan the download.
- History that never expires, next to 12 and 18 months. The personal digital banking page lists transaction history that never expires in WTB Online (Washington Trust Bank: Digital Banking), the help center says Bill Pay transaction history shows up to 18 months from the current date (Washington Trust Bank: Help Center), and the agreements cap eStatements at 12 months (WTB Online Agreement (for Businesses)). Transaction history isn't the official statement, so treat 12 months as the window for statements.
- Two error windows. The WTB Online agreement says to tell the bank no later than 60 days after the date of the first statement on which an error appeared (WTB Online Agreement (for Businesses)). The Business Terms and Conditions for Washington say the time to examine a statement and report unauthorized signatures or alterations will not, in any circumstance, exceed a total of 30 days from when the statement is first sent or made available, with 60 days for other errors (Washington Trust Bank: Business Terms and Conditions - Washington, 12/2025). Review each statement as it arrives, not at year end.
- Another bank's name in the business terms. The ACH Electronic Data Interchange section of the Business Services Terms and Conditions refers to "Associated Bank's EDI Reporting" (Business Services Terms and Conditions). It reads as a leftover from a template; it doesn't change anything about statements.
What Washington Trust Bank's pages don't say
- QuickBooks, Quicken or Xero. None of the pages or agreements we read mention them, and none mentions a bank feed or Web Connect.
- Which file formats the account download offers (CSV, QBO, QFX, OFX or other), what columns a file has, or how far back a download reaches.
- Whether WTB Online and Business Digital Banking keep the same eStatement history, and whether eStatements stay reachable after an account closes.
- The Small Business Price List and Commercial Services Price List the checking page refers to. Neither is linked from the disclosures page.
- Whether the Idaho and Oregon business terms use the same statement review windows. We read the Washington terms only; the disclosures page lists separate Idaho and Oregon versions (Washington Trust Bank: Disclosures).
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.
- Whatever file the account download produces, check its dates and totals against the eStatement before you rely on it. The agreements say displayed activity isn't the official statement (WTB Online Agreement (for Businesses)), so the eStatement is the record to tie out to.
- To connect an account, Intuit's steps are in Intuit: connect bank and credit card accounts to QuickBooks Online. Washington Trust Bank's pages don't mention a QuickBooks connection, and the business terms say aggregation access through WTB Online may be limited to balance and transaction data. A connection doesn't reach back past what the bank holds online, so fill the 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). Washington Trust Bank's pages don't say whether a .QBO download exists. 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 includes "Washington Trust Bank" (checked 1 Nov 2026). That is this bank's name, but Xero doesn't say which bank it means, so check the first import closely. Xero says it validates selected statement types and recommends OFX over PDF when your bank offers it; Washington Trust Bank's pages don't mention an OFX download, so for most months the eStatement PDF is the likely route. 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 statement against the PDF.
- If you build a CSV instead, for example from an account 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, saved within days of the email notice, plus an account download for the same statement dates if the client's platform offers one.
- The last 12 months: the eStatements in digital banking, with any download checked against them.
- Older months: the client's saved statements, or statement copies from the bank.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the Washington Trust 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. A gap or overlap usually means a missing statement.
- 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 Banner Bank? See Banner Bank statement to QuickBooks or Xero. Or First Interstate Bank? See First Interstate Bank statement to QuickBooks or Xero. Or Spokane Teachers Credit Union? See Spokane Teachers Credit Union statement to QuickBooks or Xero. Or Boeing Employees Credit Union? See Boeing Employees Credit Union statement to QuickBooks or Xero.
Client also banks with Glacier Bank? See Glacier Bank statement to QuickBooks or Xero.
Client also banks with Heritage Bank? See Heritage Bank NW statement to QuickBooks or Xero.
Client also banks with WaFd Bank? See WaFd Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For Washington Trust Bank, only up to 12 months of eStatements stay in digital banking, the agreements name no download file type, and the bank's pages don't mention QuickBooks or Xero, so the PDF statements are the record for most catch-ups, for Xero and for an account about to close. 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.