Financial Documents

M&T Bank Statement to Excel: 7-Year PDFs and People's United

M&T's export covers recent transactions; eStatements stay seven years. Turn M&T, Treasury Center and People's United PDFs into Excel.

Published
Updated
Reading time
14 min
Topics:Financial DocumentsBank StatementsExcelM&T BankUSPDF conversionPeople's UnitedAccount AnalysisM&T Treasury Center statement downloadM&T eStatements seven years

M&T's Digital Services Agreement lets customers export account information to personal finance software such as Quicken, or to spreadsheet software such as Microsoft Excel, "for recent transaction history". The service covers certain eligible accounts only, M&T may change the download formats at any time without notice, and the agreement states no fixed export window. Electronic statements stay available for seven years as long as you remain enrolled, and M&T recommends printing or saving copies as they become available.

So the export suits current activity on a live account. A prior-year tax return, catch-up bookkeeping, an audit or a loan file reaches back further, and for that work the PDF statements are the record that exists. Getting an M&T Bank statement to Excel, for anything beyond recent activity, means converting those PDFs to one row per transaction.

Two situations are particular to M&T. Commercial clients on M&T Treasury Center can select up to 250 PDF statements and download them at once in a zip file, account analysis statements included if they select them. And businesses that banked with People's United, across New England, face a seven-year look-back that crosses the September 2022 systems conversion, when their accounts moved to M&T under new numbers.

What M&T's Agreement Says About Exporting Transactions, and What It Leaves Out

Search for how to export M&T transactions and the answers disagree. One page says M&T offers no CSV or Excel download at all; another walks through choosing Excel from a menu; a third says statements reach back 24 months. None of those claims points to an M&T page, and M&T's own figure for statements is seven years, not 24 months. What M&T publishes about the export is short.

Section B4 of the agreement covers the export:

"You may export account information for use with your personal financial management software (e.g., Quicken®) ... or other spreadsheet software (e.g., Microsoft Excel®) for recent transaction history."

It then adds two limits. "This service is limited to certain Eligible Accounts and is not compatible with all versions of PFM Software." And M&T reserves "the right to change the file format or formats available for download ... at any time, without notice."

Read together, the clauses say four things. An M&T Bank transaction history export exists. It covers "recent" history, a term the agreement does not define. Not every account has it. And whatever formats it offers today are not fixed. No M&T page we found states which file formats the export produces or how far back it reaches, so any page that names a format or a number of months as M&T's is not quoting M&T.

The figure most likely to be mistaken for an export limit comes from M&T's online and mobile banking FAQ, where account searches cover "transactions up to 90 days old" and searches of bill payments and transfers cover "up to 24 months". Those are the windows for finding a transaction in the app. The FAQ says nothing about exports, and the 90 days should not be read as the export's reach.

The working approach follows from what is documented. Open the download in your client's own online banking and see which accounts, formats and dates it offers; for current activity on a live account, it may be all you need. For a job that covers years, or that has to tie to the opening and closing balances on each statement, work from the statements.

How Far Back M&T Statements Go: Seven Years, While Enrolled

M&T's electronic statements page gives one figure across nearly every account type: statements are available "up to 7 years for checking, savings, CDs, credit cards, installment loans, lines of credit, mortgages and home equity accounts."

The agreement attaches a condition. Section E2 says documents are available "for 7 years in the Statements and Notices service, as long as you are enrolled in the service and have elected to receive documents electronically." The same section goes on: "We recommend that you print and/or save copies of your statements and other Electronic Documents as they become available."

That condition is the practical point. The seven years are an archive the bank holds for an enrolled customer, not a record the client owns, so a pull that will be needed should happen while the archive is there:

  • Before an account closes or the client moves its banking elsewhere.
  • Before the client switches back to paper statements, which ends the electronic election the agreement makes the archive depend on.
  • At the edge of the window. Seven years moves forward a month at a time, and the oldest statement drops off as it does. For a look-back that starts near the limit, save the oldest months first.

Save one PDF per account per statement period, with the account's last four digits and the period in the file name. It makes gaps obvious before the conversion, and it keeps the file and page reference on each converted row meaningful later.

What M&T's pages state about how far back each source reaches:

SourceHow far back, per M&T
Transaction search in online and mobile bankingUp to 90 days
Bill payment and transfer searchUp to 24 months
Export to Quicken or Excel"Recent transaction history" (no window stated)
eStatements (checking, savings, CDs, cards, loans, mortgages, home equity)Up to 7 years, while enrolled
Treasury Center Online StatementsUp to seven years of history (2021 user guide)

The jobs that reach furthest back are the ones where this matters. A client who arrives in March with two unfiled years needs 24 or more statements per account, which is the kind of tax-season catch-up bookkeeping for CPA firms that starts with gathering the statements. Other US banks draw the line between online activity and statements in different places: Capital One, for one, shows two years of activity online against seven years of statements, as set out in Capital One statement to Excel.

M&T Treasury Center: Up to 250 PDF Statements in One Zip

Commercial clients who bank through M&T Treasury Center have a bulk route to their statements. M&T's Online Statements in M&T Bank Treasury Center User Guide, dated March 2021, describes it this way: the service lets you "view your checking, savings, and account analysis statements," with "access to up to seven years of history."

The guide's search runs on three filters: the statement type, a date range, and the account number or nickname. Choosing the statement type "All (Checking and Analysis)" returns account statements and account analysis statements in the same results grid. From there, "Statements are downloaded in PDF format," and the guide allows "up to 250 statements to be selected and downloaded at one time into a zip file." Treasury Center's screens may have changed since 2021; the guide is M&T's own published description of the feature.

The 250-statement ceiling is generous for most jobs. A year of monthly statements for four accounts is 48 PDFs. Select "All" and, if each account is analyzed, its analysis statements come too, another 48, for 96 files in one zip. Three years for the same four accounts, analysis statements included, is 288, which takes two downloads.

What arrives in that zip is two kinds of document, and only one of them is a list of transactions. An account analysis statement is the commercial fee statement: it itemizes the services the account used in the period, the charge for each, the balances that earn credit, and the earnings credit that offsets part of the fees. Its lines are calculations. Only the net analysis charge, if there is one, posts to the checking account, where it already appears in the account statement's transactions. Converted into the same sheet as the account statements, the analysis lines would read as transactions that never happened.

Keep them apart. Either set the analysis PDFs aside before converting the account statements, or convert them on their own, into a sheet of service codes, volumes and charges that is useful in its own right for reviewing what the client pays the bank. For the layout of those statements and how the earnings credit is worked out, see the guide to reading an account analysis statement.

People's United Statements From Before the September 2022 Conversion

M&T completed its acquisition of People's United on April 1, 2022, adding People's United's customers in Connecticut, Massachusetts, Vermont, New Hampshire and Maine to its own in New York and the Mid-Atlantic. As the Hartford Courant reported on August 4, 2022 (Kenneth R. Gosselin), the systems conversion took People's United online and mobile banking offline from 5 p.m. on Friday, September 2 until Tuesday, September 6, 2022, new account numbers were mailed to account holders, and "M&T also advises saving or printing People's United online statements and documents because they will no longer be accessible after the conversion."

For a business that banked with People's United, that date splits any long look-back in two. Seven years back from late 2026 is late 2019, so close to three of those seven years fall before September 2022. The M&T statements from the conversion onward sit in M&T's archive under the new account numbers. The months before it are no longer online; for them, the record is the People's United statements the client saved at the time, printed or downloaded, under the old account numbers and in People's United's statement design. The M&T pages quoted here say nothing about supplying copies of earlier People's United statements, so if a period is missing from the client's files, that is a question to put to M&T directly.

A workable order for assembling the file:

  1. List the statement periods the job needs, account by account.
  2. Download the M&T statements from September 2022 onward from online banking or Treasury Center.
  3. Fill the earlier months from the client's saved People's United PDFs, scanning any paper copies.
  4. Record each old People's United account number beside the M&T number that replaced it, so the two runs of statements read as one account's history.

M&T is not the only bank where a long look-back now crosses a predecessor's statements. The same mapping job comes up when converting Truist, BB&T and SunTrust statements to Excel, with U.S. Bank statements and the Union Bank conversion of May 2023, and with Comerica statements giving way to Fifth Third's at the September 2026 conversion.


Converting M&T and People's United PDFs to One Spreadsheet

Take a distributor outside Hartford that banked with People's United until 2022 and now uses M&T Treasury Center for three accounts: operating, payroll and a money market sweep. Its lender wants every transaction from January 2022 through December 2025 for a loan file. September 2022 onward is 40 months of M&T statements per account, 120 in all, which fit in one Treasury Center zip. January to August 2022 is 24 People's United statements the controller saved at the conversion, a few of them as paper scans.

Unzip the Treasury Center download first. Invoice Data Extraction takes PDF, JPG and PNG files, not zip files, so extract the PDFs from the zip into a folder. If the download included account analysis statements, move those into a folder of their own; they go in a separate task, or the prompt can tell the AI to skip them.

You can then convert M&T bank statement PDFs to Excel in one task. A task takes up to 6,000 files, and a single PDF can run to 5,000 pages, so the 120 M&T statements, the 24 People's United PDFs and the scans all go in together. Neither bank's layout needs its own setup: the prompt describes the spreadsheet you want, and the AI reads each statement for itself. The ready-made bank statement prompt, which asks for one row per transaction, is a reasonable starting point to adjust. For this job, the prompt adds the columns that hold the two banks' statements 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 M&T account's last four digits. Where the statement is from People's United, use the M&T account that replaced it: 4471 is now 8820, 4472 is now 8836, 5190 is now 9014. Leave Balance empty where the statement prints no balance for that transaction. Skip any account analysis statements.

The last weeks of People's United and the first of M&T then sit in one continuous run for the operating account (illustrative figures):

BankAccountCurrent AccountStatement PeriodDateDescriptionDebitCreditBalance
People's United447188202022-08-01 to 2022-08-312022-08-29Deposit18,450.00142,310.55
People's United447188202022-08-01 to 2022-08-312022-08-31ACH debit, freight carrier6,212.80136,097.75
M&T882088202022-09-01 to 2022-09-302022-09-07Wire in, customer payment22,900.00158,997.75
M&T882088202022-09-01 to 2022-09-302022-09-09Transfer to 883631,400.00127,597.75

Filter or pivot on Current Account and four years of the operating account read as one history, whichever bank's name is on the statement; the Account column still shows what each statement printed, for anyone checking the rows against the PDFs. The same shape serves any M&T business statement to Excel job, with or without a People's United stretch in it. 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: 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 month that does not tie. A page that could not be processed is reported, never skipped in silence.

The tie-out stays with you. 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 closing balance. The join that matters most is the conversion itself: the closing balance on each account's last People's United statement should match the opening balance on its first M&T statement, which confirms that nothing fell between the two banks' statements.

M&T Statement to QuickBooks: Direct Connect or a Converted File

M&T's own route into accounting software is Direct Connect, which links an M&T account to Quicken or QuickBooks for $9.95 a month, the price on M&T's personal banking page. That page does not say how far back the connection brings in transactions, and it gives no separate price for business accounts. Ask M&T for both before counting on the feed for anything but current activity.

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

  • Match the columns. Write a Structured Prompt with the headers the upload expects, such as Date, Description and Amount, in that order, and the spreadsheet comes back in that shape.
  • Leave out the extra columns. Turn off the Source File and Review Needed columns in Preferences, so the file carries nothing but those headers.
  • One file per account. QuickBooks imports each file into a single bank account, so run one task per account, or keep a Current Account column to filter on and delete it before the upload.
  • Stop where the feed starts. Load only dates before the feed's first transaction, so the two never overlap and nothing is recorded twice.

The upload steps and the column mapping are covered in importing bank statement transactions 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