Redwood Credit Union statement to QuickBooks or Xero: 60 months of statements, Web Connect downloads, the business fee schedule and tie-out

Redwood Credit Union is a credit union, so it appears in the NCUA's records rather than the FDIC's. The NCUA's credit union locator (checked 9 Nov 2026) lists 33 locations for the name "RedWood". Of the first 20 shown, 18 belong to REDWOOD, at redwoodcu.org, and 2 belong to NORTHERN REDWOOD, a separate credit union with its own web address; all 20 are in California. This guide is about the first one. Its business checking page says a business qualifies if its primary operation is in Sonoma, Marin, Napa, Mendocino, Lake, San Francisco, Solano or Contra Costa County, among other routes (Redwood Credit Union: Business Checking). Xero's bank list spells the name "RedWood Credit Union"; the credit union's own pages write "Redwood". Check that the statement header and web address match before you rely on the menus and fees below; the tie-out steps apply either way. Here's what Redwood Credit Union's public pages say, and don't, about getting a business account's history into QuickBooks or Xero.

What Redwood Credit Union's pages say

  • Statements online. The statements article says "RCU account statements are available up to 5 years (60 months) for free through digital banking", that you can view all paperless statements in one place, and that you pick statements by the last 4 digits of the account number. On a computer, it gives the dashboard's three-dot menu, then Documents and Statements, with Statements and Documents, Credit Card Statements or Mortgage Statements in the sidebar; All Account statements show by default. It calls these "your monthly or quarterly statements", separate from end-of-year tax statements, and notes that with loans only you cannot access statements (Redwood Credit Union: Where can I view my statements in digital banking?). The paperless page says the credit union will email you as soon as a new statement is ready (Redwood Credit Union: Paperless).
  • Older statements. The same article says that if you don't use digital banking or need a statement older than 5 years, you can request it from the Member Service Center or any branch, and "There is a $3.00 fee for this service" (Where can I view my statements).
  • Transaction downloads. The download article says "Transaction detail can only be downloaded using a computer. This feature is not available in the mobile app." The steps: from the Dashboard select the account or card, click More then Export at the top right of the account details page, select your file format preference and the accounts, select the transaction date range, then click Export (Redwood Credit Union: How do I download my transactions into Microsoft Excel?). Transactions can also be searched by merchant, date or amount (Redwood Credit Union: How do I look up my transactions in digital banking?).
  • QuickBooks and Quicken. The credit union's QuickBooks and Quicken article says the instructions "have been provided by Intuit", and that Intuit completed the switch to the new digital banking platform on July 26, 2023 and removed the connection to the old online banking platform on February 14, 2024. For QuickBooks Desktop it says to download your transactions to a QuickBooks (.qbo) file and import it as a Web Connect file. For QuickBooks Online it covers Express Web Connect (search "Redwood Credit Union" and select Redwood Credit Union Digital) and Web Connect, where you download "a Web Connect file (.qbo or .qfx)" and use File Upload. It warns that overlapping transaction dates can create duplicates, and that reactivating a Quicken connection "may result in a re-download of the most recent 90 days of transactions" (Redwood Credit Union: connect Quicken and QuickBooks to digital banking).
  • Business online banking. The business online banking page lists checking balances, viewing statements, transfers and bill pay, Remote Deposit Capture, and sub-users so you can "Give your accounting team permissions you control" (Redwood Credit Union: Business Online Banking). The knowledge base says the credit union does not recommend sharing your username and password with anyone, including an accountant (Redwood Credit Union: Digital Banking Knowledge Base), so a sub-user is the route for a bookkeeper.
  • Business checking. The compare page lists Business Essential Checking at $8 a month with up to 300 items deposited and paid per month, Business Choice Checking at $15 with a combined 300 items, and Business Analysis Checking at $20 with a combined 500 items and an earnings credit to offset the fee. The Essential fee is waived with a $1,000 average daily balance or a $5,000 combined average daily business deposit balance, and the Choice fee with $5,000 or $10,000, or for either with merchant services; the 501(c)(3) monthly fee is $0 on all three. Coin and currency processing is $5 per $1,000, $2,500 or $5,000 deposited or withdrawn on the three accounts in turn (Business Checking).
  • The fee schedule. The Cost Recovery and Fee Schedule for Business Accounts (effective 6/29/2026) repeats the $8, $15 and $20 monthly fees and adds Business Savings at $3.00 and two accounts marked "not available for new accounts": Active Business Checking at $12.00 and Premium Business Checking at $15.00, which carry a $2.00 deposit activity fee after 30 or 50 deposits a month and $0.20 per item paid after 250 or 500. It lists Paper Statement at $2.00 per statement, Printed Account Transactions at $1.00 per page, Record Research at $25.00 per hour (1 hour minimum), Stop Payment at $22.00, Non-Sufficient Funds at $7.00 per presentment and Overdraft Pay Advantage at $14.00 per presentment, Remote Deposit Capture at $30.00 a month, Positive Pay at $45.00 a month, and domestic outgoing wires at $25.00 each or $20.00 each online. Business ACH fees are on a separate schedule (Redwood Credit Union: Cost Recovery and Fee Schedule, Business Accounts, PDF; Fee Schedules).

Where Redwood Credit Union's pages don't line up

  • An Excel article with no format list. The download article is titled for Microsoft Excel but only says to select your file format preference, without naming the choices (download transactions), while the QuickBooks article, written from Intuit's instructions, names a .qbo file for QuickBooks Desktop and ".qbo or .qfx" for QuickBooks Online (connect Quicken and QuickBooks). Neither page says how far back an export reaches. Check the format list in the Export dialog before you plan a catch-up around it.
  • A $3.00 copy fee that isn't in the business schedule. The statements article charges $3.00 for a statement older than 5 years or for members not on digital banking (Where can I view my statements). The business fee schedule has no statement copy line; the nearest are Paper Statement at $2.00 per statement, Printed Account Transactions at $1.00 per page and Record Research at $25.00 per hour with a 1 hour minimum (Business Accounts fee schedule). Ask which charge applies before you order a run of old business statements.
  • Items, or checks. The compare page counts items deposited and paid, with $0.20 per item over the combined limit on Choice and Analysis (Business Checking), while the fee schedule's row counts checks deposited and paid and charges $0.20 per item over the combined limit of 300 or 500 checks per month (Business Accounts fee schedule). Neither says whether electronic items count, so check the item fee on each statement rather than estimating it.
  • No fees for online services, but some online services have fees. The business online banking page lists "No fees for online services" next to Remote Deposit Capture (Business Online Banking), while the fee schedule lists Remote Deposit Capture at $30.00 a month, Positive Pay at $45.00 a month and online domestic wires at $20.00 each (Business Accounts fee schedule). Expect those charges on the statement if the business uses the services.
  • Monthly or quarterly. The statements article calls them monthly or quarterly statements (Where can I view my statements), and the fee schedule sets its item and deposit limits per month (Business Accounts fee schedule). No page we read says which accounts get a quarterly statement, so use the period dates printed on each statement.

What Redwood Credit Union's pages don't say

  • Xero: no page we read mentions it, and the download article doesn't name CSV.
  • How far back a transaction export or a QuickBooks or Quicken connection reaches, beyond the 90-day re-download note.
  • Statement cycle dates, and whether business checking and business savings share one statement; the statements page shows all accounts by default.
  • The time limit for reporting a statement error. We did not read the account agreement, so check it for the review window before you rely on an old statement being correctable.
  • Whether statements for a closed account stay in digital banking.

QuickBooks Online

Xero

  • "RedWood Credit Union" is on Xero's US list of banks with validated PDF extraction (checked 9 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; Redwood Credit Union's pages don't mention an OFX download, so check the Export dialog. 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 a statement covers more than one account, check that the lines Xero extracts belong to the account you're importing into.
  • 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: save each statement PDF when the email says it's ready, and note which accounts it covers.
  • The last 5 years: download every statement digital banking shows now, filtering by the last 4 digits of each account, and use a Web Connect or other export where it reaches.
  • Anything older: ask the credit union for copies, and ask what they will cost first, since the statements article says $3.00 and the business fee schedule lists research at $25.00 an hour.

Tie out each statement before you import

  1. Beginning balance + deposits − withdrawals = ending balance for each account on the Redwood Credit Union 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.
  3. Look for the charges that depend on activity: the monthly fee if the balance fell short, $0.20 per item over the limit on Choice and Analysis, coin and currency fees, deposit activity fees on Active and Premium, NSF and Overdraft Pay Advantage fees, stop payments, wires, Remote Deposit Capture and Positive Pay.
  4. For Business Choice Checking, expect dividends on balances of $50,000 or more; for Analysis Checking, expect an earnings credit against the fees. 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 Mechanics Bank? See Mechanics Bank statement to QuickBooks or Xero. Or Montecito Bank and Trust? See Montecito Bank and Trust statement to QuickBooks or Xero.

Where LedgerReady fits

For Redwood Credit Union, the download help doesn't list its formats or say how far back an export reaches, and statements older than 5 years cost money to get, so the statements are the record for catch-ups and for any month a download 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.

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.