Convert CSV/Excel files to the QBJ, IIF format

convert CSV or Excel general journal entries

qbj transactions data imported in quickbooks

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 ProperConvert utility.

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 ProperConvert. Download it from the download page. Start ProperConvert 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 ProperConvert. Download it from the download page. Start ProperConvert 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