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

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

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

  1. Beginning balance + deposits − withdrawals = ending balance on the Washington Trust Bank statement, to the cent, using the statement's own period dates.
  2. 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.
  3. 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.
  4. 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.

Try your first statement free

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.