M&T Bank Statement to Excel Converter

M&T's steps: log in to online banking, choose Update Delivery Settings, accept the Digital Service Agreement, and start viewing statements and notices digitally. For most accounts, paper statements then stop.

Paper statements from before the switch still convert: scan them flat, one per file, and FlowParse reads them through OCR and proves each against its printed balances, so the paper years and online years merge into one history.

Commercial customers also find account analysis statements in the same place. An account analysis statement typically summarises the services used and what they cost, rather than listing payments in and out. They explain the fee line on the bank statement; they are not a list of the account's transactions.

Convert the checking and savings statements; keep the analysis statements beside them. When the converted sheet shows an analysis fee, the matching analysis statement tells you what it paid for.

M&T checking statements open with the account, the period and the starting balance, list the month's credits, checks and debits, and close with the ending balance. FlowParse takes each transaction once.

The result is a row per transaction: date, M&T's description, check number in its own column, and one signed amount in dollars — debits negative, credits positive. The rows for a statement sum to the difference between its two balances, which is exactly what the proof relies on.

FlowParse adds every signed row to the M&T starting balance and requires the total to equal the ending balance printed on the statement, checking rows against the running balance where one is shown.

When a page break hides a check or a credit is read as a debit, the totals miss, and the preview reports by how much and where. Only exact matches are marked reconciled — which matters when the workbook is going to an auditor.

With up to seven years online across checking, savings, cards, loans and home equity, an M&T customer can rebuild a long history. Smart Merge takes up to 100 PDFs at a time and returns one workbook in date order, account and source file on each row, checking that every ending balance carries into the next statement.

For a longer period, merge a year at a time. Statements from KeyBank, Citizens, TD Bank, PNC or Chase can join the same workbook.

Businesses using M&T's Commercial eStatements often keep several accounts — operating, payroll, sweep — each with its own statement in Treasury Center. Converted together, each account's rows can be exported as its own QBO file for QuickBooks Online or Desktop, or as CSV for Xero and other packages.

Check numbers and descriptions come with every row, so the cleared checks match the register and the vendor payments match their bills after import.

Auditors and grant funders ask for bank reconciliations that tie to the statement, and a reconciliation built from retyped figures carries every typing error with it — a transposed check amount, a deposit entered twice.

Converting the statement removes the retyping, and the balance proof means the figures in the workbook are the figures M&T printed. The auditor can trace any row back to its page in the PDF.

A small nonprofit in Buffalo banks with M&T: an operating account, a restricted-gifts savings account, and Commercial eStatements in Treasury Center. Its auditor needs the fiscal year's statements and a reconciliation of every account. The figures here are an illustration, not a real organization's.

The treasurer downloads twelve statements per account and uploads them. FlowParse returns one workbook, every statement proved, both accounts chained. Donations, grant draws and payroll are filtered by description; transfers between operating and restricted accounts pair up; the cleared-check numbers match the register. The auditor gets the PDFs and a sheet that ties to every ending balance.

Coverage: each ending balance equal to the next beginning balance, per account. Checks: the check-number column matched against the register and the Cleared Checks Summary. Enrollment: PDFs saved so the seven years don't depend on a setting. Reconciled: every statement proved before its totals are used.

And keep the PDFs. The converted file is a working copy; the statement is the record.

Checking, savings, money market, line of credit, home equity and credit card statements list transactions between two balances and convert the same way, as do commercial checking and savings statements.

Account analysis statements, mortgage escrow statements, CD notices and tax forms are summaries or single documents. Keep them with the file; convert the statements.

M&T's seven-year storage includes mortgage and home equity statements. They show payments, interest and principal between two balances — figures that matter for a mortgage interest deduction or a refinance.

Merged with the checking statements that pay them, each payment appears on both sides. Filtered for a year, the interest rows give the figure to compare with the year's mortgage interest statement.

M&T makes each month's statement available in online banking. Saving it into a folder named by account and year takes a minute and makes your archive independent of delivery settings and account closures.

At year end, upload the folder. FlowParse returns one proved workbook, ready for your accountant or auditor, with nothing retyped.

M&T lets you switch back to paper statements at any time. Its Digital Services Agreement ties the seven-year online archive to staying enrolled with electronic delivery, so switching back is also the moment to download what you have online.

Paper statements that arrive afterwards still convert: scan them flat, one per file, and FlowParse proves each against its printed balances. Merged with the earlier PDFs, they keep the history unbroken.