Convert M&T Bank CSV to QuickBooks (.QBO)
Works with M&T Bank CSV and Excel exports Nothing uploaded
M&T Bank is one of the more frustrating banks to get into QuickBooks. Its online banking leans heavily on PDF statements and a Direct Connect feed that only reaches back about 90 days, and when you do find a transaction export, it lands as a plain CSV/spreadsheet, not a tidy QBO Web Connect file. QuickBooks Online won't ingest that CSV without you re-mapping the Date, Description, and Amount columns by hand, and QuickBooks Desktop flat-out wants a .QBO. So bookkeepers end up stuck between a 90-day feed and a spreadsheet QuickBooks doesn't like.
QBO Maker closes that gap. Take whatever M&T hands you, a downloaded CSV or an Excel export of your account activity, and convert it into a clean, valid .QBO (or .QFX / .OFX) that imports through QuickBooks' Web Connect / file-upload flow. It runs entirely in your browser, so your M&T account activity never touches a server, and there's nothing to install. If you only have PDF statements, you'll first need to get them into spreadsheet form; once you have a CSV with dates, descriptions, and amounts, drop it into the converter and you'll have a QuickBooks-ready file in seconds.
.QBO QuickBooks accepts. For M&T Bank, its dates are usually MM/DD/YYYY, and amounts arrive as a single signed column (debits negative, credits positive), both detected automatically.A typical M&T Bank export has columns like Date, Description, Amount, Balance and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import M&T Bank statements into QuickBooks
- Export your transactions from M&T Bank online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
M&T Bank-specific things to watch for
- No native QBO export. M&T's online banking doesn't offer a QuickBooks Web Connect (.QBO) download for personal, business, or commercial accounts, you get PDF statements or a CSV, which is exactly why a converter helps.
- Direct Connect only goes back ~90 days. The automatic QuickBooks/Quicken feed caps at roughly three months, so older history almost always has to come from a CSV or statement instead.
- PDF-first statements. If you only have a PDF, you'll need to extract it to CSV first, QBO Maker reads text-based PDFs directly (beta); only scanned PDFs need a CSV step first.
- Commercial logins differ. M&T commercial accounts use company ID / user ID / password and frequently won't link directly to QuickBooks, making manual CSV export the practical path.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID, M&T Bank's routing number is often 022000046, which we prefill when you open the converter from this page.
Frequently asked questions
Does M&T Bank give you a QBO file for QuickBooks?
No. M&T's online banking provides PDF statements and CSV/spreadsheet exports, plus a Direct Connect feed that only covers about 90 days. There's no native .QBO Web Connect download, so converting a CSV is the most reliable way to get a QuickBooks-ready file.
I only have M&T PDF statements. Can QBO Maker use those?
QBO Maker reads CSV, Excel and text-based PDFs (scanned/image PDFs need a CSV step first). You'll first need to get your M&T statement into a spreadsheet with Date, Description, and Amount columns. Once you have that CSV, the converter turns it into a clean .QBO.
Will the converted file import into QuickBooks Desktop?
Yes. The .QBO QBO Maker produces is a standard Web Connect file. In QuickBooks Desktop, go to Banking → Bank Feeds → Import Web Connect Files and select your converted file. For QuickBooks Online, upload it through Transactions → Upload from file.
Is it safe to convert my M&T transactions here?
Yes. Conversion happens entirely in your browser, nothing about your M&T account is uploaded or stored on a server. That privacy matters when you're working with real banking data.
Convert your M&T Bank statement now
Free, in your browser, nothing uploaded. We will prefill the M&T Bank routing number for you.
Open the converter