How to Import Bank Statements into Bench Accounting

Quick Answer: To import bank statements into Bench Accounting, convert your PDF statements to CSV using [QuickBankConvert](/), format the CSV with Date, Description, and Amount columns, then provide the file to your Bench bookkeeper via the Bench messaging center or their specified upload process.

Bench Accounting and Bank Data Import

Bench is a US-based online bookkeeping service that combines bookkeeping software with human bookkeepers. Businesses subscribe to Bench for monthly bookkeeping, tax preparation, and financial reporting. Bench uses a hybrid model: automated transaction import via bank connections, augmented by bookkeeper review and categorization.

For most Bench clients, transaction data flows automatically via Plaid-powered bank connections. You connect your bank accounts and credit cards to Bench, and transactions import in near real-time. This is the primary and preferred data flow for Bench bookkeeping.

However, there are important situations where automatic connection is insufficient and manual bank statement import becomes necessary — and this is where converting PDF statements to CSV becomes essential.

When Manual Bank Statement Import Is Needed

Your Bank Is Not Supported by Bench's Connection

Not every bank supports Plaid or Bench's connection protocols. Community banks, credit unions, smaller regional banks, and international accounts may not have automatic connection support. For these accounts, manual CSV upload is the only way to get transaction data into Bench.

Historical Data Before Your Connection Date

When you onboard with Bench mid-year or start using Bench after running your business for several years, you need historical data from before your bank connection was established. Bench bookkeepers need this historical data to reconcile accounts, prepare annual returns, and build accurate financial statements. Manual CSV import fills this gap.

A Bank Connection Breaks or Lapses

Bank connections through Plaid can break when banks update their security protocols, require re-authentication, or change their API. If a connection lapses for several weeks, transactions for that period will not be automatically imported. Manual statement upload covers the gap.

Closing an Account After It Is Already Closed

If you need to back-fill data from a business bank account that is now closed, the bank connection approach is not available. Download statements from the bank's archive (or request certified copies) and convert them to CSV for manual import.

Callout — Coordinate with Your Bench Bookkeeper First: Before uploading any manual bank statement files to Bench, contact your bookkeeper through the Bench messaging center. They will confirm the import format, the date range to cover, and how to avoid duplicate transactions with any existing automatic feed data.

Preparing Your Bank Statement CSV for Bench

The key to a successful Bench manual import is preparing a CSV that your bookkeeper can use without additional cleanup. Here is the workflow.

Step 1: Download Bank Statement PDFs

Log in to your bank's online portal and download PDF statements for the period you need to import. Download one month at a time if possible, as this makes it easier to verify completeness.

Step 2: Convert to CSV with QuickBankConvert

Visit [QuickBankConvert](/) — no account or installation needed. Upload each PDF and download the resulting CSV. QuickBankConvert processes your statements entirely in your browser — your financial data never leaves your device.

Step 3: Open and Review the CSV

Open each converted CSV in Excel or Google Sheets. Verify that:

• Every transaction row is present (spot-check a few against the original PDF)
• Dates are in a consistent format
• Amounts are in numeric format (not text or currency-formatted strings)
• Debit and credit amounts are clearly separated (or combined with negative/positive signs)

Step 4: Format for Bench

Bench bookkeepers typically work with a standard three-column format:

Where:

• Date: MM/DD/YYYY format
• Description: Transaction description as it appears on the statement
• Amount: Debits as negative (-), credits as positive (+)

If your converted CSV has separate Debit and Credit columns, combine them into a single Amount column in Excel:

=IF(D2<>"", -D2, E2)

(Where D is Debit, E is Credit — debits become negative, credits remain positive.)

Callout — Ask Your Bookkeeper for a Template: Many Bench bookkeepers have a preferred CSV template. Ask your bookkeeper to send their template before you prepare the file — this avoids rework if their preferred format differs from the standard structure above.

Step 5: Combine Multiple Months

If importing multiple months, combine all monthly CSV files into a single file sorted by date. Remove any duplicate header rows that appear when combining files.

Uploading Bank Statement Data to Bench

Via the Bench Messaging Center

The most reliable way to deliver manual import files to Bench is through the in-platform messaging center:

1. Log in to your Bench account at bench.co.
2. Open the Messaging section and start a conversation with your bookkeeper.
3. Attach your CSV file and explain which account and date range it covers.
4. Your bookkeeper will confirm receipt and let you know when the import is complete.

Via the Bench Upload Feature (if available)

Some Bench accounts have a direct file upload feature in the bank accounts section. Navigate to the relevant bank account in your Bench dashboard and look for an Import or Upload Statement option. If available, follow the on-screen instructions to map columns and submit.

Bench Bank Data Import Method Comparison

Tips for Smooth Bench Imports

Keep Dates Consistent

Bench is sensitive to date format. Use MM/DD/YYYY consistently throughout. Do not mix formats (e.g., some rows as 01/15/2025 and others as January 15, 2025).

Use a Single Amount Column

While some formats support separate Debit and Credit columns, a single signed Amount column (negatives for outflows, positives for inflows) is the most universally accepted format and reduces mapping errors.

Add an Account Reference

If importing statements from multiple accounts simultaneously, add an Account column (e.g., "Chase Business Checking" or "AMEX Business Card") so your bookkeeper can assign each row to the correct account in Bench.

Document What You Uploaded

Keep a note of which periods and accounts you imported manually. This prevents future duplicate imports and helps you and your bookkeeper maintain a clear data record.

Bottom Line

For most Bench clients, automatic bank connections handle day-to-day bookkeeping data. But when you need historical data, have an unsupported bank, or need to fill a connection gap, manual CSV import is essential. [QuickBankConvert](/) converts your bank statement PDFs to clean, properly formatted CSV files in minutes, ready for Bench import. The combination — QuickBankConvert for PDF conversion and Bench for bookkeeping — gives small business owners a complete, professional bookkeeping data flow.