Financial Documents

Fifth Third Bank Statement to Excel: Comerica's Split 2026

Comerica statements stop at the September 2026 conversion and Fifth Third's follow. Turn both banks' PDF statements into one Excel sheet for the year.

Published
Updated
Reading time
13 min
Topics:Financial DocumentsBank StatementsExcelFifth ThirdComericaUSPDF conversionbank conversion statement historybookkeeping reconciliation

Fifth Third keeps the last 24 months of eStatements and check images online, at no charge, for personal accounts, according to its paperless eStatements page. For accounting software, Fifth Third connects to Quicken and QuickBooks through Direct Connect and "does not support Web Connect download for QuickBooks". Former Comerica accounts moved to Fifth Third on September 8, 2026, after a conversion over Labor Day weekend, so a 2026 year for any of those accounts runs on Comerica statements until early September and on Fifth Third statements after that. For personal accounts, Fifth Third says the final Comerica statement reflected activity through September 4, 2026.

That split decides how a Fifth Third bank statement to Excel job works for any former Comerica account. A full year, a two- or three-year look-back for a lender or an auditor, or any spreadsheet that has to tie to opening and closing balances draws on two banks' statements, in two layouts, under two account numbers. The PDF statements from both banks are the record that covers all of it. Converted together, they give one sheet of transactions with the bank, the account and the statement period on every row, which is the same sheet whether you want Excel or a CSV to import.

What Fifth Third's pages leave out is a CSV or spreadsheet download from online banking. Claims that it has no export at all, or that it exports particular formats, do not trace to anything Fifth Third publishes, so check what the client's own login offers before relying on either.

The Comerica Conversion in Three Facts

The merger closed on February 1, 2026, as Fifth Third's Form 8-K filing with the SEC records. Comerica's accounts stayed on Comerica's systems and under its name for the next seven months, so every statement for that stretch is a Comerica statement, in Comerica's layout.

The systems and brand conversion ran over Labor Day weekend 2026. It moved about 600,000 customer accounts and 293 banking centers in Arizona, California, Florida, Michigan and Texas onto Fifth Third, which Fifth Third said made it the ninth-largest US bank, with more than $300 billion in assets. Former Comerica clients reached their accounts at Fifth Third from September 8, 2026: through Fifth Third Online and Mobile Banking, or, for a business, through those or Fifth Third Direct, depending on the services it uses.

Account numbers changed. Fifth Third's welcome pages for business and commercial clients say the new number appears on the first Fifth Third statement, and for commercial clients in Fifth Third Direct as well.

Those facts give every 2026 file the same seam. For personal accounts, Fifth Third says a final Comerica statement reflected activity through September 4, 2026; the first Fifth Third statement picks up from there. Whatever the account type, the last Comerica statement and the first Fifth Third statement are the two documents where one bank's record of the year hands over to the other's.

What Moved From Comerica to Fifth Third, by Account Type

Fifth Third published separate welcome pages for personal, business and commercial clients, and they do not say the same thing about history. The figure that gets repeated, 24 months of statements, comes from the personal page only.

Personal accounts. The consumer welcome page is specific: "Six months of transaction history, paperless statement preferences, and 24 months of statements have transferred automatically to Fifth Third." Customer service for personal accounts is 800-972-3030.

Business banking. The business welcome page gives no number of months or statements. It says "some historical account information transitioned from Comerica will be available in Fifth Third Direct® as early as September 8, 2026. Additional historical details will be added over time for your convenience." Where a client cannot find what they need, the page sends them to their relationship team or the Fifth Third Commercial Support Center.

Commercial banking. The commercial welcome page is similar: "Some historical data transitioned from Comerica will be available as early as September 8, 2026." For history not available through Fifth Third Direct, clients contact their relationship team or the Commercial Support Center at 866-475-0729.

Account typeWhat Fifth Third says movedWhere to get the rest
Personal24 months of statements and six months of transaction historyStatements the client saved, or copies requested from the bank
Business"Some historical account information", with more "added over time"Relationship team or the Fifth Third Commercial Support Center
Commercial"Some historical data"Relationship team or the Commercial Support Center, 866-475-0729

What that means for a file you are building:

  • Personal accounts: with 24 months of statements carried over at the September 2026 conversion, Fifth Third's archive reaches back to around September 2024. Earlier Comerica statements exist as the PDFs the client downloaded at the time, or as copies requested from the bank.
  • Business and commercial accounts: no depth is stated, so treat each month as unconfirmed until you have found its statement in Fifth Third Direct. Make a list of the periods the job needs and tick them off there; whatever is missing goes to the relationship team, or comes from the client's own saved Comerica PDFs.
  • All of them: January to early September 2026 is a Comerica record, whichever system now displays it.

Two habits save time later. Keep the Comerica PDFs the client already holds, even where Fifth Third now shows the same months, since they are the statements as Comerica issued them. And file the last Comerica statement with the first Fifth Third statement for each account: the pair is the record that links the old account number to the new one. A short list of each Comerica number beside its Fifth Third replacement, kept with the file, does the same job for anyone who reviews it after you.

Fifth Third is not the only US bank where a look-back now runs through a predecessor's statements. The same mapping comes up with M&T and People's United statements, with Truist, BB&T and SunTrust statements, and with U.S. Bank and Union Bank statements.

How Far Back Fifth Third Statements Go, and What Its Pages Say About Downloads

Fifth Third's figure is on its paperless page: "Fifth Third Bank customers enjoy the ability to access the last 24 months of their online bank account eStatements and check images at no charge." That page sits in Fifth Third's personal banking section. Fifth Third's pages give no figure for how far back statements go in Fifth Third Direct, so for a business client the answer is whatever the client's own login shows.

Twenty-four months is a rolling window. Each month a new statement arrives and the oldest one drops out of reach, so a look-back that begins near the edge should be saved from the oldest month forward. A lender asking in late 2026 for statements back to January 2024 is already asking for more than the window holds, which is one more reason to keep the PDFs the client saved at the time, Comerica's included. Huntington keeps the same 24 months online, so a look-back on Huntington, Cadence, Veritex or TCF statements meets the same edge.

To get a Fifth Third bank statement PDF for each period, download it from the statements area of online banking or Fifth Third Direct, keep one file per account per period, and name each with the account's last four digits and the statement period. Gaps in the run become obvious before you convert anything, and the file names stay meaningful when every converted row points back to its source file.

Fifth Third's pages say nothing about downloading transactions from online banking itself: whether it can be done, in which formats, or over what dates. Open the download options in the client's login and look: which accounts are listed, which formats, how far back the date picker goes. For recent activity on a live account, that download may be all you need.

The PDF statement is the source in three cases:

  1. Comerica history, for any period before the September 2026 conversion that a Fifth Third download would not contain.
  2. Older periods: anything beyond the 24-month eStatement window, or beyond whatever history moved into Fifth Third Direct for a business account.
  3. Anything that must tie to balances. A statement prints the opening and closing balance for its period, the two figures that reconciliation, an audit file or a year-end tie-out is checked against, period by period.

Building One 2026 Sheet From Comerica and Fifth Third Statements

Take a Phoenix distributor that banked with Comerica and now banks with Fifth Third, with two accounts: operating and payroll. Its CPA needs every 2026 transaction in one workbook for the year-end close and the return. For each account, the year arrives as eight monthly Comerica statements, January to August, a final Comerica statement for the days before the conversion, and Fifth Third statements from September onward under a new account number. That is two statement layouts and two account numbers for each account, about 26 PDFs in all by the December statements.

Put them all in one task. You can convert bank statement PDFs to Excel with Comerica's and Fifth Third's statements side by side: a task takes up to 6,000 files and a single PDF can run to 5,000 pages, and neither layout needs setting up, because the prompt describes the spreadsheet you want and the AI reads each statement for itself. A statement that exists only on paper can be scanned and added as a PDF, JPG or PNG. The ready-made bank statement prompt, one row per transaction, is a reasonable starting point; for this job, write in the columns that hold the two banks together:

One row per transaction: Bank (as named on the statement), Account (last four digits as printed), Current Account, Statement Period, Date (YYYY-MM-DD), Description, Debit, Credit, Balance. For Current Account, use the Fifth Third account's last four digits. Where the statement is from Comerica, use the Fifth Third account that replaced it: 2214 is now 7031, 2230 is now 7058.

Across the conversion, the operating account then reads as one run (illustrative figures):

BankAccountCurrent AccountStatement PeriodDateDescriptionDebitCreditBalance
Comerica221470312026-08-01 to 2026-08-312026-08-31ACH debit, freight carrier4,860.25211,402.18
Comerica221470312026-09-01 to 2026-09-042026-09-03Deposit15,730.00227,132.18
Fifth Third703170312026-09-05 to 2026-09-302026-09-09Wire in, customer payment28,115.40255,247.58
Fifth Third703170312026-09-05 to 2026-09-302026-09-11Transfer to 705836,500.00218,747.58

Filter or pivot on Current Account and the year is one account's history, whichever bank issued the statement, while the Account column still shows what each statement printed for anyone checking rows against the PDFs. The same columns serve any Fifth Third business statement to Excel job, with or without a Comerica stretch, and a Comerica-only look-back for 2024 and 2025 runs through the same prompt. Download the result as Excel, CSV or JSON. In Excel, numbers come through as numbers and dates as dates, so the pivot works straight away.

Every row also carries a Source File column with the file and page it came from. A panel of AI agents has to agree on every value, and a value or a row it cannot agree on is flagged as Review Needed, with what to check. In the results viewer, clicking the file name on a row opens its page beside it, which is the quickest way to settle a flagged row or a period that does not tie.

The tie-out is the part that proves the sheet is complete, and it works the same way as reconciling the converted transactions against each statement at any bank. Add Opening Balance and Closing Balance, as printed on each statement, to the prompt's columns and the check can run in the sheet itself. For each Current Account and Statement Period, the opening balance printed on the statement, plus the period's credits, minus its debits, should equal the printed closing balance. Then check the seam: the closing balance on the last Comerica statement should meet the opening balance on the first Fifth Third statement, if the balance carried across at the conversion. A gap at that join is the first place to look, since it means a transaction or a whole statement is missing between the two banks' records.

Once every period ties, the workbook is the bank side of the 2026 close and the return. For a client who brings a year of statements in March, the same sheet is where tax-season catch-up bookkeeping begins, with the categorizing done against one list of transactions instead of two banks' worth of PDFs.

Fifth Third Statement to QuickBooks: Direct Connect or a Converted File

Fifth Third's Quicken and QuickBooks FAQ settles which connection it supports: "Fifth Third does not support Web Connect download for QuickBooks®, but Direct Connect provides statement transaction downloads." Direct Connect, in the same FAQ's words, is "a connection between your personal financial management (PFM) software and Fifth Third Bank". So a downloaded Web Connect file is not the route; the bank feed is.

The FAQ does not say how far back Direct Connect brings in transactions. Treat the feed as the route for activity from when it is connected, and ask Fifth Third before counting on it for anything older. For a former Comerica account, the January to early September 2026 transactions belong to the Comerica account, under its old number, and the FAQ does not say the feed carries them.

History from before the feed comes from the statements. Converted, they arrive as Excel or CSV, not as a QBO file, so they go into QuickBooks through its bank transaction upload:

  • Match the columns the upload expects. A Structured Prompt names each column header in the order you need, Date, Description and Amount for a single amount column, or Date, Description, Debit and Credit for two, and the spreadsheet comes back in that shape.
  • Keep the file to those columns. The Source File and Review Needed columns can be left out of downloads in Preferences when the file must carry nothing but the upload's columns. Settle any Review Needed rows before you switch them off.
  • One account per file. Upload each account's history to the QuickBooks account it belongs to, with the Comerica months and the Fifth Third months for the same account in one file if the client's books treat them as one account.
  • Stop where the feed starts. End the converted history the day before the first transaction Direct Connect downloaded, so no month comes in twice.

The converted file imports; nothing is posted to QuickBooks for you, and matching and categorizing stay in QuickBooks. The CSV format requirements, date-format mismatches and duplicate transactions are covered step by step in the guide to importing converted bank statements into QuickBooks.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours