Contact Us

Data Export: CSV, BAI2, PDF, QBO and MT940 Downloads

Export Format Quick Reference

TD Business Central supports five export formats: CSV for spreadsheet and ERP import, BAI2 for automated bank reconciliation, PDF for formatted printable reports, QBO for QuickBooks direct import, and MT940 for SAP and international banking systems. Bulk exports handle up to 500,000 records. RESTful API available for automated extraction. UTF-8 encoding by default with Windows-1252 fallback.

Getting data out of your banking platform and into your accounting system should not be a multi-step manual process. TD Business Central data export delivers your financial records in the exact format your downstream systems expect — whether that is a CSV for Excel analysis, a BAI2 file for Sage reconciliation, or an MT940 feed for SAP.

Five formats. One interface. Select your accounts, set the date range, pick the format and click Export. Large files generate in the background and arrive in your inbox. Small exports download instantly to your browser.

TD Business Central data export interface showing format selection dropdown with CSV BAI2 PDF QBO and MT940 options

Five Export Formats for Every Integration Need

Each format serves a distinct purpose. Choose based on your accounting platform, compliance requirements and downstream processing workflow.

CSV: The Universal Format

CSV exports produce comma-delimited files compatible with Excel, Google Sheets, R, Python and every major ERP system. You select which data fields to include — up to all 47 available in the report builder. UTF-8 encoding handles French characters, accented beneficiary names and international currency symbols without corruption.

For legacy systems that choke on UTF-8 byte order marks, switch to Windows-1252 encoding in the export settings. Column headers are included by default and can be toggled off for systems that expect raw data without a header row.

BAI2: Bank Reconciliation Standard

BAI2 (Bank Administration Institute Version 2) is the industry standard for electronic bank statement delivery. TD Business Central generates BAI2 files that comply with the full specification, including group headers, account identifiers, transaction detail records and control totals. Compatible with Sage 50, Sage 300, Oracle NetSuite, SAP and any platform that supports BAI2 import.

The BAI2 format is particularly valuable for businesses running automated reconciliation. Import the file into your accounting system and matching algorithms process hundreds of transactions in seconds. Manual reconciliation drops by an estimated 80% according to CPA Canada automation benchmarks.

QBO: QuickBooks Direct Import

QBO files import directly into QuickBooks Online and QuickBooks Desktop without conversion. Transaction details map automatically to QuickBooks fields: date, payee, amount, memo and account. This eliminates the CSV-to-QBO conversion step that many businesses struggle with when using generic banking exports.

MT940: International Banking Standard

MT940 is the SWIFT message format used globally for electronic account statements. TD Business Central generates MT940 files for organizations using SAP, Oracle or other enterprise systems that expect the SWIFT statement format. Each file follows the tag structure defined in the SWIFT Standards, including opening balance, statement lines, closing balance and available balance fields.

PDF: Formatted and Print-Ready

PDF exports produce formatted documents with company headers, column labels, page numbers and summary totals. Use PDF for board presentations, regulatory submissions or any scenario where a human-readable formatted document is required. PDF files embed fonts and render identically across operating systems and devices.

As noted by Statistics Canada in their business digitization surveys, over 60% of Canadian mid-market businesses still rely on PDF bank statements for quarterly financial reviews.

Export Format Comparison

Side-by-side comparison of all five export formats available in TD Business Central data export.

Format Fields Included Compatible Software Primary Use Case Encoding Max Records
CSV Up to 47 (selectable) Excel, Xero, Sage, ERP systems Spreadsheet analysis, ERP import UTF-8 / Win-1252 500,000
BAI2 Standard BAI2 field set Sage 300, Oracle, SAP, NetSuite Automated bank reconciliation ASCII 500,000
PDF Up to 47 (selectable) Any PDF reader Board reports, regulatory submissions Embedded fonts 100,000
QBO QuickBooks-mapped fields QuickBooks Online, QuickBooks Desktop Direct QuickBooks import UTF-8 250,000
MT940 SWIFT standard tag set SAP, Oracle, international systems Enterprise ERP statement feeds ASCII / UTF-8 500,000

Bulk Export and API Integration

For high-volume operations and automated workflows, TD Business Central offers bulk export tools and a RESTful API.

Multi-Account Bulk Export

Select multiple accounts, define a shared date range and export everything in one operation. The system generates one file per account or a single consolidated file — your choice. Consolidated files include an account identifier column so your import process can route transactions to the correct ledger.

Bulk exports exceeding 100,000 records process asynchronously. The system notifies you by email when the file is ready, with a secure download link that expires after 72 hours. Files over 100 MB are automatically compressed into ZIP format.

RESTful API for Automation

TD Business Central provides a RESTful API for organizations that need automated, recurring data extraction without manual interaction. The API supports JSON and XML response formats, OAuth 2.0 authentication and rate limiting of 500 requests per minute.

Webhook notifications alert your systems when new transactions are available, enabling near-real-time data synchronization between TD Business Central and your ERP. Enterprise clients with high-frequency integration requirements can request elevated rate limits through their commercial banking advisor.

API documentation, sandbox credentials and sample code are available upon request. The sandbox environment mirrors production data structures with synthetic data, allowing your development team to build and test integrations without touching live financial records.

Related Reporting Services

Data export works alongside the full TD Business Central reporting suite to give you complete control over your financial data.

Custom Reports

Build tailored reports with drag-and-drop field selection before exporting. Custom reports let you define exactly which columns and filters to apply, then export the results in any of the five supported formats.

Transaction Reporting

Standard pre-built reports with scheduled delivery. Transaction reporting handles the most common export scenarios, while data export provides the format flexibility and bulk capacity for enterprise-scale operations.

Statements & Documents

Official bank-produced monthly statements and tax documents. Statements & Documents provides the authoritative records, while data export gives you the raw data for custom analysis and integration.

← Back to TD Business Central Home

Data Export: Frequently Asked Questions

TD Business Central exports are compatible with QuickBooks Online and Desktop (via QBO format), Sage 50 and Sage 300 (via BAI2 and CSV), Xero (via CSV), Oracle NetSuite (via BAI2), SAP Business One (via MT940 and CSV), and FreshBooks (via CSV). BAI2 is the most universally accepted format for automated bank reconciliation across enterprise accounting platforms.

Yes. The bulk export tool lets you select multiple accounts, define a shared date range and export all data in a single operation. The system generates one file per account or a consolidated file with account identifiers in each row, depending on your preference. Bulk exports support all five formats and process asynchronously for data sets exceeding 100,000 records.

TD Business Central provides a RESTful API for automated data extraction. The API supports JSON and XML response formats, OAuth 2.0 authentication, rate limiting of 500 requests per minute and webhook notifications for new transaction events. API documentation and sandbox credentials are available through your commercial banking advisor. Enterprise clients with high-frequency integration needs can request elevated rate limits.

CSV exports use UTF-8 encoding by default, which supports French-language characters, accented names and international currency symbols. You can switch to Windows-1252 encoding for legacy systems that do not support UTF-8. BAI2 files use ASCII encoding per the BAI2 specification. PDF files embed fonts and render correctly regardless of the recipient's system encoding settings.

A single export can contain up to 500,000 transaction records. For CSV files this typically produces a file between 50 MB and 150 MB depending on the number of fields selected. Files exceeding 100 MB are automatically compressed into ZIP format for faster download. There is no monthly cap on total export volume, and exports from the past seven years of data are included.