Edit Bank Statement Transactions Before Exporting to CSV, Excel, or QBO

When you export bank statement transactions to CSV, Excel, or QBO, the raw data is rarely ready for your accounting software. Payee names are unreadable codes, categories are missing, and dates might have the wrong year. Most people export first and then spend an hour cleaning up in Excel. There is a better way: edit everything before you export, so the file you download is the file you actually need.

CapyParse's Export Editor sits between extraction and export. It gives you a spreadsheet-like view of your bank transactions with AI tools to clean payee names, assign categories, fix dates, and reverse signs -- then export to CSV, Excel, or QBO with all your changes included.

What Is the Export Editor?

The Export Editor is a spreadsheet-like interface built into CapyParse that sits between extraction and export. After CapyParse processes your bank statement PDF, you can open the Export Editor to review, clean up, and enhance the transaction data before downloading it.

To open it, select any processed document from your dashboard and click the Edit & Export CSV / QBO button in the right sidebar.

This opens a full-width editor where every transaction is displayed in an editable table. The toolbar across the top gives you access to AI-powered tools for bulk cleanup.

AI Payee/Memo: Clean Up Cryptic Descriptions

Bank transaction descriptions are notoriously messy. A simple Zelle transfer shows up as Zelle Transfer Conf# T09WYHB9G; ASHLEY SANCHEZ. A Robinhood withdrawal looks like ROBINHOOD WEB DES:Funds ID:XXXXXXXXX INDN:Mykel Williams CO ID:1464364776. These descriptions are useless in a bookkeeping context.

The AI Payee/Memo button splits each description into a clean payee name and a memo field that preserves the original text. You get two cleanup modes:

After selecting a mode, the AI processes every transaction. Here is the result with Aggressive mode applied -- notice how "ROBINHOOD WEB DES:Funds..." became simply "Robinhood", and "Zelle Transfer Conf# T09WYHB9G; ASHLEY SANCHEZ" became "Zelle Transfer" with the full text moved to memo:

The original description is never lost -- it moves to the Memo column, so your audit trail stays intact.

AI Categorize: Assign Categories Automatically

Manually categorizing dozens (or hundreds) of transactions is one of the most tedious parts of bookkeeping. AI Categorize does it in seconds. Click the button and choose your category scheme:

After categorization, every transaction has a category assigned. You can click any category cell to override it manually if the AI got one wrong.

Fix Dates: Correct Years and Months in Bulk

Date issues are common when converting bank statements. A statement that spans December to January might have all dates extracted as the same year. Scanned statements sometimes get the year wrong entirely. The Fix Dates tool lets you change the year or month across all transactions at once.

The dialog shows a preview of every date change before you apply it -- current date on the left, corrected date on the right. Nothing changes until you click Apply.

Reverse Signs: Flip Deposits and Withdrawals

Some accounting software expects deposits as negative and withdrawals as positive (or vice versa). Different banks also format amounts differently -- some show withdrawals as negative numbers, others show them as positive with a "W" type indicator. Reverse Signs flips every amount in one click. Click again to undo.

This is especially useful when importing into QuickBooks or Xero, where sign conventions can cause reconciliation errors.

Inline Editing, Add Row, and Save Draft

Every cell in the table is directly editable. Click any field to change a date, payee name, memo, amount, transaction type, or category. Beyond cell editing, you have:

Export to CSV, Excel, or QBO

Once your data looks right, export it in the format you need. The toolbar has three export buttons:

Every edit you have made -- cleaned payee names, assigned categories, corrected dates, added or removed rows -- is included in the export. What you see in the editor is exactly what you get in the file.

For more on QBO files, see our guide on how to convert QBO to CSV. If you are importing into specific software, check out our guides for QuickBooks, FreshBooks, and Wave.

AI Chat: Ask Questions About Your Data

The AI Chat button opens a sidebar assistant that has full context of your transaction data. You can ask it questions like "What is the total amount of Robinhood transfers?" or give it instructions like "Categorize all transactions over $1,000 as Large Expenses." It is a natural-language interface for working with your bank statement data.

The Full Workflow: Statement to Clean Export

Here is how it all fits together, from PDF upload to a bookkeeping-ready file:

Frequently Asked Questions

Related Articles