Pick up filesGet started

Valley National Bank statement to QuickBooks or Xero: business statements, QuickBooks integration and tie-out

Valley National Bank's business checking bundles all come with Business Online Banking and what Valley calls QuickBooks integration. Valley's written documents for business customers are mostly product pages and a 55-page agreement; its step-by-step help is a set of video tutorials, which this guide doesn't rely on. Here's what Valley's written pages and agreements say, and don't, about getting a business account's history into QuickBooks or Xero. This guide covers Valley's business checking bundles and Business Online Banking at valley.com only, not Valley's commercial platform or its personal online banking. Ask the client which bundle they have (Basic, Advantage or Premier), because it decides how many people can sign in.

What Valley gives you

  • Statements you can view and download. Valley's Treasury Solutions Terms and Conditions say Online Banking lets a client obtain balance and transaction information and "view and download statements and paid checks", and that if the client has agreed to receive online statements electronically, Online Banking provides access to account statements online (Valley: Treasury Solutions Terms and Conditions, Online Banking Schedule, effective March 10, 2026).
  • QuickBooks integration in every bundle. Valley's business checking page says it includes banking integration with QuickBooks in all of its bundles, describes it as automatically sharing information between the bank account and the accounting platform, and mentions automatic transaction reconciliation (Valley: business checking). The Basic Business Checking page says the integration is at no cost (Valley: Basic Business Checking), and the bundles comparison lists "Complimentary Online and Mobile Banking with Quickbooks Access" for all three bundles (Valley: business checking bundles comparison, 2025). The Manage your business page says that if you already use accounting software like QuickBooks, Valley can integrate your Valley accounts (Valley: manage your business).
  • User management. The Business Online Banking page lists managing, adding and deleting users in a user management center, and setting each employee's rights to create payments and access accounts (Valley: Business Online Banking). The agreement says the client designates at least one Administrator, who adds and deletes Online Users, chooses which linked accounts each one can reach, and can limit access by account or service (Valley: Treasury Solutions Terms and Conditions, Online Banking Schedule, sections 3(b) and 3(d)).
  • Multi-bank reporting and Valley Connect. Valley offers multi-bank reporting for a view across banks (Valley: manage your business), and the agreement describes Valley Connect, an API service through a third-party platform for reporting transactions and balances into supported ERP software (Valley: Treasury Solutions Terms and Conditions, Valley Connect Schedule). Neither says which accounting products are supported.

Before you start

  • Which bundle, and how many users. Valley's pages say Basic Business Checking comes with Online and Mobile Banking for a single user, while Advantage and Premier allow multiple users with different permissions for each employee (Valley: business checking; Valley: bundles comparison). On Advantage or Premier, ask the client's Administrator to add you as your own Online User with access only to the accounts you need.
  • Don't share the client's sign-in. The agreement says the client must train users about the risks of sharing security items, including sharing Online Users' passwords with other client employees, and must change passwords whenever anyone with access to security items is no longer authorized (Valley: Treasury Solutions Terms and Conditions, General Terms, section 7). It also says Valley will never ask by email or otherwise for a password.
  • New accounts. The bundle hub says new business customers get an email with Business Online Banking login credentials and a temporary password right after opening, and that Advantage and Premier customers complete an enrollment package through DocuSign to switch on treasury services (Valley: business bundle hub). The agreement says Online Users must change the password after the first sign-in (Valley).
  • Sign in on a computer for full features. The agreement says some Online Banking features may not be available through the mobile version, personal financial management (PFM) software or an indirect service, and that for optimal use you should sign in directly through valley.com from a personal computer (Valley: Treasury Solutions Terms and Conditions, Online Banking Schedule, section 2(b)). Download statements from the website, not from inside QuickBooks or the app.
  • Dormant access. The agreement says Online Banking may be terminated automatically after 120 consecutive days of inactivity, and that the client then has to contact Valley to set it up again (Valley, section 3(h)). If the client rarely signs in, or the account is about to close, download the statements you need while access works.

Where Valley's pages need checking

  • "Automatic transaction reconciliation." The business checking page says the QuickBooks integration makes tax season easier with automatic transaction reconciliation (Valley: business checking). Valley's agreement says the client is responsible for monitoring each transaction and must report errors within 30 calendar days after a statement or report is made available (Valley, General Terms, section 15). A feed that matches transactions isn't the same as tying a month out to the statement; still check the balances below.
  • A single user and a bookkeeper. On the Basic bundle, Valley's pages describe single-user online banking (Valley: Basic Business Checking), while the agreement warns against sharing passwords (Valley). The pages we read don't say how a Basic customer gives an outside bookkeeper access. Ask the client to download the statements themselves, or ask Valley about moving to a multi-user bundle.
  • Which terms apply. The Treasury Solutions Terms and Conditions say they bind each client who signs the Enrollment Form, and the bundle hub says only Advantage and Premier customers enroll in treasury services, while all customers get account disclosures at opening (Valley: business bundle hub). The pages don't say whether the Online Banking Schedule also governs a Basic customer who never signs an enrollment package. Treat the agreement as Valley's description of Business Online Banking, not as a promise for every bundle.
  • Business or commercial history. Valley's commercial online banking guides page says commercial customers can review up to 18 months of data and reports (Valley: commercial online banking guides). That page is for the commercial platform; the business pages we read give no number for Business Online Banking.

What Valley's pages don't say

  • File types. We didn't find a Valley business page or agreement that names an export format (QBO, QFX, OFX or CSV) for transaction history, or the format of a downloaded statement beyond "view and download".
  • How the QuickBooks integration connects. The pages don't say whether it's a direct bank feed, a file download or something else, which QuickBooks products it supports, or how far back it brings transactions. Check the bank connection in the client's QuickBooks file rather than assuming.
  • Statement history. We didn't find how many months of business statements stay online in Business Online Banking.
  • Older statements and copy costs. Valley's Schedule of Fees for Business Accounts lists research time at $25 per hour and doesn't list a statement copy fee, and says an additional schedule of fees may apply to some business checking accounts (Valley: Your Valley Bank Deposit Account, Rev. 07/01/2025). The deposit agreement says Valley stores canceled checks or copies for a reasonable retention period and you may request copies in the manner it requires. Neither says how to get statements older than what's online.
  • Xero. We didn't find a Valley page about a Xero bank feed; we haven't confirmed one either way.

Who should review the statements

Valley's deposit agreement says that for a business account, the client agrees to have at least two people review statements, notices and returned checks, or have them reviewed by someone without authority to transact on the account, and that unauthorized signatures or alterations must be reported in writing within 30 days of when Valley first sends or makes the statement available (Valley: Your Valley Bank Deposit Account, Statements section). A bookkeeper tying out each month can be part of that review, but the 30-day window means a catch-up done months later can't rely on it; flag any problem to the client right away.

Which route for which months

  • Going forward on QuickBooks Online or Desktop: whatever connection QuickBooks offers for Valley in the client's file, set up by the client, starting after the last month you've already imported.
  • Recent months: the statements downloaded from Business Online Banking, once you've confirmed what format they come in and how far back they go.
  • Older months, Xero, or an account about to close: the PDF statements, downloaded and saved while they're online.
  • Every month: tie the imported lines out to the statement before you reconcile (below).

QuickBooks Online

Xero

  • Valley National Bank is on Xero's US list of banks with validated PDF extraction (checked 27 Oct 2026), so high-quality results are likely, but Xero says it validates selected statement types and recommends OFX over PDF when your bank offers it. Valley's pages we read don't mention OFX. 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 month against the statement.
  • 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 months 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.

Tie out each month before you import

  1. Opening balance + deposits − withdrawals = closing balance on the Valley statement, to the cent.
  2. Chain the months: each closing balance equals the next statement's opening balance.
  3. Sum the file's or feed's lines for the statement period and compare them with the statement's net change. A difference usually means a missing transaction type, an overlapping download, or a date range off by a day.
  4. Spot-check the first and last days of the period and the largest few items against the PDF.

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 Old National Bank? See Old National Bank statement to QuickBooks or Xero. Or Webster Bank? See Webster Bank statement to QuickBooks or Xero.

Client also banks with Trustmark National Bank? See Trustmark National Bank statement to QuickBooks or Xero.

Client also banks with Prosperity Bank? See Prosperity Bank statement to QuickBooks or Xero.

Client also banks with BankUnited? See BankUnited statement to QuickBooks or Xero.

Where LedgerReady fits

For Valley, the business pages describe QuickBooks integration but don't name an export file type, say how far back statements go online, or say how a Basic single-user customer gives a bookkeeper access, so PDF statements, downloaded by the client and saved while they're online, are the record for older months, Xero and an account about to close. If you'd rather not convert and check each month yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every month 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.