CSV2CSV (macOS): Convert CSV/Excel transactions to importable CSV

00:00​​ - Download CSV2CSV
00:20 - Start CSV2CSV and select a file with transactions
00:30 - Review the transactions before converting
00:38​​ - 'Output dates' option
00:52 - Set the CSV Target
00:57 - Convert to CSV file
01:06 - Switch to QB Online and go to 'Banking'
01:20​​ - Select the account to import data into
01:26​​ - Upload the file
01:40​ - Select the QB account
01:44 - Map the CSV file (select the Amount column)
02:01​​ - Select the transactions to import
02:07 - Review the transactions, select Payee and Category

Step by step instructions for macOS:

- Use ProperSoft CSV2CSV to convert CSV/Excel files to importable CSV format and import into Quickbooks Online, Quicken for Mac (as CSV Mint), Xero, and more. Download it and make sure you are using the latest version of the CSV2CSV.

- Start CSV2CSV and select a CSV file.

- Review transactions before converting, check that dates are correct, have the correct year, amount, withdrawals, and deposits are shown in corresponding columns.

- Set the Output Dates. The best option for Quickbooks Online is MM/DD/YYYY.

- Choose the CSV Target: CSV Mint, Quickbooks Online, Xero.

- Click the 'Convert' button to create a CSV file.

- Confirm the file name and location.

Import created CSV file into Quickbooks Online:

- Now the CSV file is created, let's switch to Quickbooks online and import created CSV file. Look for the 'Banking' and click on it.

- And then select the account you want to import your data into.

- Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file', or similar links to upload created CSV file.

- Then click the 'Browse' button and select the created CSV file. And click 'Next'.

- Then select an account in Quickbooks to import and click 'Next'.

- Confirm the mapping and the date format. Click 'Next'.

- Review transactions in Quickbooks online before importing.

- Once the transactions are imported, you can review, categorize them under the account and add to the register.