Converting transactions to CSV/Excel/TXT

This video shows how to convert to the CSV format. We will use Bank2QBO utility. IMPORTANT: Bank2QBO is now replaced with the Transactions app, which converts from more formats and converts to more formats.

All converters have the option to save a CSV file.  

Bank2QBO converter can convert to the QBO file and the CSV file.  

There are different CSV options, called CSV Target.  

It could be:

• Regular CSV (all columns will be converted to the CSV file);

• XLSX EXCEL;

• XLS EXCEL;

• CSV Quickbooks Online (only three columns will be saved);

• CSV Quickbooks Online (+Account);

• CSV Xero: more columns to save;

• Quicken Mac (CSV Mint);

• POSH;

• Quickbooks Batch Checks;

• Quickbooks Batch Deposits;

• Quickbooks Batch Ccard;

• Positive Pay;

You can use it to create a CSV file, that is ready for your accounting software. If it imports a CSV file, but the CSV file needs some additional formatting for that software, instead of saving and formatting it, you've just to select this option and the file will be ready to import into that accounting software. 

• Clipboard (the file will not be saved, but it will be copied to the clipboard, then you can switch to spreadsheet software, like Excel, click 'Paste' - to paste data);

• FreeAgent;

• Simple CSV with Splits;

• Full CSV with Splits.