Amarillo National Bank statement to QuickBooks or Xero: QBO, QFX and CSV exports, eStatements and tie-out
This guide covers Amarillo National Bank (ANB) at anb.com. Its online banking platform for businesses is called Business Online (Amarillo National Bank: Business Digital Banking). Here's what ANB's public pages say, and don't, about getting a business account's history into QuickBooks or Xero.
What Amarillo National Bank's pages say
- Export formats. The online banking FAQ says you download transactions with the Export Feature in your online banking account: open the account, use the filter option to pull specific transactions or the download option below your balance, and pick a format. The formats listed are .CSV (Microsoft Excel), .QIF (Quicken), .QFX (Quicken version 2003 or later), .QBO (QuickBooks version 2003 or later) and .QFX (Money) (Amarillo National Bank: Frequently Asked Questions).
- What Business Online covers. The Business Digital Banking page lists account and transaction inquiries, eStatements, ACH, bill pay, funds and wire transfers, Positive Pay and stop payments (Amarillo National Bank: Business Digital Banking). The Terms and Conditions list the business services as including a transaction list, transaction search and exporting transaction information (Amarillo National Bank: Terms and Conditions).
- eStatements. ANB sends an email each month as soon as the statement is available online. You can review the current statement by logging in, review images of checks that have cleared, print or save the statement for your permanent records, and view statements in the app (Amarillo National Bank: Business Digital Banking). The Business Checking page says check images are included with statements (Amarillo National Bank: Business Checking). The personal Digital Banking page gives the steps: Statements, then Statement Delivery, then confirm or add an email, repeated for each account; to view one, choose Statements from the main menu, then the account and the statement (Amarillo National Bank: Digital Banking).
- The review clock starts on the email date. The eStatement Agreement says your eStatement is dated the day you're notified by email, that you must promptly review it and report any error, unauthorized signature or alteration within the time periods in your deposit agreement, and that those periods begin on the email date regardless of when you open the statement. Accounts enrolled in eStatements no longer get a paper statement by mail, and a request to withdraw consent should arrive before the end of your normal statement cycle (Amarillo National Bank: eStatement Agreement). The Terms and Conditions also ask you to examine each paper or electronic statement as soon as you receive it, and say transfers made through online banking appear on the account statements rather than on a separate statement (Amarillo National Bank: Terms and Conditions).
- Each user gets their own login. The How to Get Started page says every business customer designates an online banking administrator, who adds, removes and maintains users and their permissions (Amarillo National Bank: How to Get Started). The User Management Guide says the administrator adds users under User Management, and on the accounts tab sets each user's access to each account as View, Deposit or Withdraw; View controls whether the account shows in menus and whether the user can see its balances and transactions (Amarillo National Bank: Business Online Banking User Management Guide). Ask the client's administrator for your own user with View access to the accounts you need, rather than using their sign-in. The FAQ adds that business users must change their password every 180 days (Amarillo National Bank).
- Published fees. The Fees and Charges page lists a Statement Printout at $2.00 and Research Bank Records at $20.00 per hour plus 50 cents per copy (Amarillo National Bank: Fees and Charges).
- Credit cards are separate. The FAQ says ANB credit cards use a Credit Card Account Access service where you can view, print and save up to 2 years of statements, and that a billing error must be reported in writing no later than 60 days after you received the first statement showing it (Amarillo National Bank). Treat a card as its own account with its own statements.
Where Amarillo National Bank's pages don't line up
- Two same-day cut-off times. The FAQ says online banking transactions completed on weekdays before 7 p.m. post the same day (Amarillo National Bank), while the Terms and Conditions say transfers made before 5:00 PM Central Time on a business day post the same day, and later ones the next business day (Amarillo National Bank). For a transfer made late on the last day of a statement period, check which statement it landed on before you call a month short.
- Export steps only in a FAQ. The export formats sit in the general Online Banking section of the FAQ, which ends with "Step by Step guide coming soon" (Amarillo National Bank). The How-To Guides page lists guides for logging in, the homepage, external accounts, enrolling in services, settings, and transfers and payments, but none for exporting (Amarillo National Bank: How-To Guides), and the Business Digital Banking page doesn't mention exports at all (Amarillo National Bank). Only the Terms and Conditions name exporting as a business service.
- Dated software names. The FAQ describes the QBO file as for QuickBooks version 2003 or later and lists a Microsoft Money format (Amarillo National Bank). It doesn't mention QuickBooks Online or Xero.
- An agreement that isn't where the links point. The Business Digital Banking page links to "our eStatement agreement (PDF)" (Amarillo National Bank), but the link opens a web page, and that page continues past the eStatement terms into an Exhibit D with MoneyDesktop Terms and Conditions updated November 22, 2013 (Amarillo National Bank: eStatement Agreement). The eStatement terms defer to the Terms and Conditions for Depository Accounts, which we didn't find on the pages we read, and the Terms and Conditions section on errors reads "Please refer to the on the Bank's website", with the name of the page missing (Amarillo National Bank).
- Business steps on a personal page. The eStatement enrollment and viewing steps are on the personal Digital Banking page (Amarillo National Bank); the business page describes eStatements but gives no steps (Amarillo National Bank).
What Amarillo National Bank's pages don't say
- How far back an export can reach, or what columns the CSV holds.
- How long eStatements stay online. The pages say you can easily access past statements but give no period, and say nothing about access after an account or online access closes.
- How long a business has to report an error on a deposit statement. The eStatement terms defer to the deposit agreement, which we didn't find on the pages we read.
- Whether a user with View access can also open statements; the guide only mentions balances and transactions.
- Whether the Statement Printout and records research fees apply per statement, or the same way to business accounts.
- Anything about Xero or QuickBooks Online.
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 QBO or CSV file from ANB online banking, set the date range to the statement's own period, not the calendar month, and check a CSV against the column list above before you upload it.
- 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
- "Amarillo National Bank" is on Xero's US list of banks with validated PDF extraction (checked 2 Nov 2026), so high quality results are likely, but test one statement and check every line before a full catch-up. Xero recommends OFX over PDF when your bank offers it; ANB's FAQ lists QFX and QBO but not OFX by name. 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: save each eStatement when the email arrives, since any review period runs from that email date, plus an export for the same statement dates in a format your software takes.
- Recent months: an online banking export can cover these, but tie each month to its statement.
- Older months: save every eStatement online banking 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: ask the bank for copies, and check the published Statement Printout and records research fees first, since the pages don't say how they apply to a run of business statements.
Tie out each statement before you import
- Beginning balance + deposits − withdrawals = ending balance on the Amarillo National 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 Frost Bank? See Frost Bank statement to QuickBooks or Xero. Or PlainsCapital Bank? See PlainsCapital Bank statement to QuickBooks or Xero. Or F&M Bank? See F&M Bank statement to QuickBooks or Xero. Or Security Service Federal Credit Union? See Security Service Federal Credit Union statement to QuickBooks or Xero.
Where LedgerReady fits
For Amarillo National Bank, the pages list QBO, QFX and CSV exports but don't say how far back they reach, how long eStatements stay online or which deposit agreement sets the error window, 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.