United Bank statement to QuickBooks or Xero: Business Edge exports, 18 months of history and tie-out
Several unrelated US banks use the name United Bank. This guide covers United Bank at bankwithunited.com, part of United Bankshares. It isn't United Community Bank, and it isn't BankUnited, which has its own guide (BankUnited statement to QuickBooks or Xero). United Bank calls its business online banking Business Edge (United Bank: Business Online Banking). Here's what United Bank's public pages say, and don't, about getting a business account's history into QuickBooks or Xero.
What United Bank's pages say
- 18 months of history and exports. The Business Online Banking page says Business Edge gives access to up to 18 months of account history, lets you quickly export data to accounting or spreadsheet software, and lets you adjust levels of access per user, set transaction limits and define your own approval process (United Bank: Business Online Banking).
- Output formats. The Business Edge reports guide (file dated 11/19/2021) says that under Reports, then Accounts, the Output To choices are Screen, CSV file, PDF, QIF file, QuickBooks, Microsoft Money or Quicken, for a specific date, a date range or the previous business day. Company profiles with several users get Reports, then Deposit Account Reporting, then Activity, which adds a BAI2 file and a CSV file with all fields, including the Additional Reference column. The guide says the QuickBooks, Microsoft Money and Quicken options might not be available to all company users (United Bank: Business Edge Account Reporting guide, linked from Quick Reference Guides).
- Statements in Business Edge. The same guide says Reports, then Statements and Documents shows recent statements and documents by account, with document types Analysis statement, Statement or Notice. For statements from before the last 60 days, use the link to search for older or specific documents and enter a document cycle date. Company administrators set up each account for online delivery, choosing Online or Online and Paper (United Bank).
- eStatement terms. The Electronic Online Documents Disclosure and Agreement (effective November 19, 2024) says the same terms apply to electronic documents as to paper ones and the deposit agreement stays in effect. You get an email when a new document is ready, and it's your responsibility to view, print or save your statements. To get a paper statement for the current cycle again, change delivery at least ten days before the document date. A paper copy request must give the account numbers and periods, and the agreement refers you to the current fee schedule for fees (United Bank: Electronic Online Documents Disclosure and Agreement).
- Review window for Treasury services. The Master Treasury Management Services Agreement (footer 04/2019) says you must tell the bank within 30 days after statements are made available about any discrepancy with transactions you started through the Services, and about a statement you didn't receive within a reasonable time not over 60 days from the statement date, or you can't claim damages for it. It strongly recommends dual control, and without it asks for a standard greater than ordinary care, including review of statements (United Bank: Master Treasury Management Services Agreement, linked from Treasury Management).
- Each user gets their own login. The same agreement says the bank issues credentials to the Administrator, who then assigns user IDs and passwords to other users, and that credentials go only to people authorized to use the system (United Bank). Ask the client's administrator for your own user with the accounts and reports you need, rather than using their sign-in.
- QuickBooks connection types. The QuickBooks Online instructions cover Express Web Connect and Web Connect, where you download a .qbo or .qfx file from online banking and upload it in QuickBooks Online (United Bank: QuickBooks Online Conversion Instructions). The QuickBooks Desktop instructions cover Direct Connect and Web Connect for Windows and Mac, say Direct Connect might require credentials that differ from your online banking ones, and warn that overlapping dates in a new .qbo download can create duplicates (United Bank: QuickBooks Desktop conversion instructions).
Where United Bank's pages don't line up
- Conversion notices, not setup guides. The QuickBooks pages are instructions for a system conversion dated December 2 and December 6, 2021, including a note that Express Web Connect would be unavailable for 5 business days after December 6 (United Bank). We found no current QuickBooks setup page. The Desktop page is also headed QuickBooks Online Conversion Instructions, though its steps are for QuickBooks Desktop on Windows and Mac (United Bank).
- Direct Connect, or no direct interface. The Online Banking FAQ says Quicken and Microsoft Money can't be used as a direct interface with eBanking, and describes downloading in a Quicken WebConnect format into Quicken 2005 (United Bank: Online Banking FAQs), while the QuickBooks Desktop page gives Direct Connect steps (United Bank). The FAQ also says eBanking covers personal deposit and loan accounts, so it reads as a dated personal page; ask the bank which connection your client's business login supports.
- Piedmont Bank dates with no year. The page for former Piedmont Bank customers sets Action Date 1 on March 20 (back up and make a final download, since transaction history might not be available after the conversion) and Action Date 2 on March 24 (deactivate and reactivate the connection), with no year given. It says the linked instructions' Express Web Connect delay doesn't apply to Piedmont customers, and that United Bank doesn't use the Bill Pay feature in QuickBooks or Quicken (United Bank: QuickBooks and Quicken Users). Check the months around that March line by line for duplicates or gaps, as the page itself advises.
- Two menu paths and three names. The eStatement page gives the path Accounts, then Statements and Documents, then Delivery Settings (United Bank: eStatement and eNotices), while the Business Edge guide uses Reports, then Statements and Documents (United Bank). The eStatement page sits in the personal section. The service is called Business Edge on the online banking page and Business eBanking on the checking and treasury pages (United Bank: United Free Business Checking, Treasury Management).
What United Bank's pages don't say
- Which file the QuickBooks output option produces in Business Edge (QBO is named only in the 2021 conversion steps), or what columns the CSV holds.
- Whether the 18 months of history also limits exports, or how far back the export date range reaches.
- How long statements stay in Statements and Documents, and whether they stay reachable after an account or online access closes.
- How long a business has to report an error on a statement for transactions outside the Treasury services. The eStatement terms defer to the deposit agreement, which we didn't find on the pages we read.
- What a statement copy or research costs. The eStatement terms point to a fee schedule we didn't find on the pages we read.
- Anything about Xero, or current QuickBooks Online steps outside the 2021 conversion.
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.
- If you export a CSV from Business Edge, check it against the list above and set the date range to the statement's own period, not the calendar month. Account history online covers 18 months, so anything older has to come from the statements.
- 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
- "United Bank" is on Xero's US list of banks with validated PDF extraction (checked 2 Nov 2026), but the list doesn't say which United Bank, so test one statement and check every line before a full catch-up. Xero recommends OFX over PDF when your bank offers it; United Bank's pages 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).
- 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: each statement from Statements and Documents, saved when the email arrives, plus an export for the same statement dates in a format your software takes.
- The last 18 months: a Business Edge export can cover these, but tie each month to its statement.
- Older months: search for older documents in Statements and Documents and save every statement it holds now, since the pages don't say how long they stay or what happens after an account closes.
- Anything online banking can't reach: request paper copies with the account numbers and periods, and ask about the fee first, since we found no published amount.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the United 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.
- Sum the export'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 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 Sandy Spring Bank? See Sandy Spring Bank statement to QuickBooks or Xero. Or First Citizens Bank? See First Citizens Bank statement to QuickBooks or Xero.
Where LedgerReady fits
For United Bank, the pages keep account history online for 18 months, describe QuickBooks steps only for a 2021 conversion and don't say which United Bank Xero validated, so the statements are the record for catch-ups, for Xero and for any month an export 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.