Convert CSV/Excel files to the QBJ, IIF format
- ProperConvert (CSV2QBJ) extracts transactions data from General Journal Entries in CSV/Excel files. It creates QBJ, IIF files ready to import into Quickbooks 2013-2024.
- No data entry: convert data you already have in bank or credit card transactions data file format to the QBJ, IIF format
- Smart: ProperConvert understands many layouts. It finds columns like date, amount, description, etc. of your transactions.
- Easy to use: Converting your banking transactions into QBJ, IIF files could not be any easier. In a few clicks, you will have all your transactions converted to importable by Quickbooks 2013-2024 format in no time at all.
- Free trial and support: try it for Free before you buy and receive full support before and after you order.
- Safe to use: ProperConvert converts all your banking transactions on your computer.
Convert CSV General Journal Entries to QBJ and import into Quickbooks Desktop
This tutorial shows how to convert CSV general journal entry file to QBJ and import into Quickbooks Desktop. We will use the CSV2QBJ utility. IMPORTANT: CSV2QBJ is replaced with the ProperConvert app that supports more formats and conversion modes.
Step by step instructions for Windows
Follow the steps below for the Windows version, followed by the Mac version.
Make sure you are using the latest version of CSV2QBJ. Download it from the CSV2QBJ download page. Start CSV2QBJ and select the CSV or Excel file.
Review transactions data before converting.
Set the Company Name and Company ID, if you needed.
Click the 'Convert' button to create a QBJ file.
Confirm the file name and location.
Import created QBJ file into Quickbooks
Now the QBJ file is created, let's switch to Quickbooks and import created QBJ file. Backup your QuickBooks data file before importing. To import a QBJ file, select 'File' - Utilities' - 'Import' - 'General Journal Entries'. And select created QBJ file.
Review entries before importing.
Click 'Add general journal entry' and confirm that you are importing this file.
Now your data is imported.
Click the 'Company' - 'Make General Journal Entries'.
You can review entries here.
Step by step instructions for macOS
Make sure you are using the latest version of CSV2QBJ. Download it from the CSV2QBJ download page. Start CSV2QBJ and select the CSV or Excel file.
Review transactions data before converting.
Click the 'Convert' button to create a QBJ file.
Confirm the file name and location.
Import created QBJ file into Quickbooks
Now the QBJ file is created, let's switch to Quickbooks and import created QBJ file. Backup your QuickBooks data file before importing. To import a QBJ file, select 'File' - 'Import' - 'General Journal Entries'. And select created QBJ file.
Review entries before importing.
Click on the 'Select All' button and select entries before importing.
Then click on the 'Import' button.
Now your data is imported.
Related articles
- Convert QIF to QBO and import into QuickBooks Desktop or Quickbooks Online
- How to Import Bank Transactions into QuickBooks Desktop
- Convert QFX to QBO and import into Quickbooks
- Convert CSV/Excel files to OFX and import into Quickbooks Online, Xero, Microsoft Money
- Import Journal Entries into Quickbooks Desktop from CSV/Excel
- Import a Transaction File into Quickbooks Online
- Convert PDF to QBO and import into QuickBooks