Transactions mode Tutorial

This tutorial shows how to use the converter in the Transactions mode. See it as a video at the end of this article.

Introduction

This tutorial explains how to use the ProperConvert app in the Transactions mode:

For the General Journal Entries mode, please see this tutorial.

Step 1: Download and installation

To download the app, go to the main page and click the Download button. Once downloaded and installed, start the ProperConvert app.

Step 1: Download and installation

Read the welcome message that provides the main points about the conversion process.

Step 1: Welcome message

Step 2: Select a file with transactions to convert

Select a file with transactions that you would like to convert. In this example, I will try a PDF file and a CSV file. Depending on the file format, there are different tools to adjust how the file is parsed, like the mapping for CSV files.

Here is a sample CSV file sample.csv you can use to create transactions.

Step 2: Select a file with transactions to convert

Step 2: Review Transactions

Step 2: Review mapping

Step 3: Select the output format

The first thing to do is to select the output format. It could be QBO/QFX/OFX format, QIF format, IIF format, CSV format. The output format defines the transaction details.

Step 3: Select the output format

Step 4: Review loaded transactions before converting

Review transactions before converting, make sure dates are correct, expenses are negative, and payments to the account are positive.

Step 5: Set the output attributes

Set output attributes: account name or account id, account type and other applicable attributes. If you are converting for multiple accounts, make sure to adjust account properties to avoid importing into the previous account.

Please check other tutorials for a specific output format for more details for each setting for that specific format.

Step 6: The "Open after save" setting

Set the “Open after save” checkbox if you would like the software installed on your computer to open the created file. For example, for QBO files, If you have Quickbooks desktop installed, it would be Quickbooks to open this QBO file.

Open after save setting

Step 7: Convert to the output format

Click the Convert button and confirm the filename and the file location. For some required settings, the converter checks and asks to set it. In this case, the INTU.BID value (bank label) was not set.

Step 7: Set INTU.BID value

Step 7: Convert to the output format

Step 8: Import created file into Quickbooks

To import the created QBO file manually, in Quickbooks, click File, Utilities, Import, Web Connect.

Select create QBO file and choose a new or existing account to import. If your account is not listed, make sure that online services are disabled for this account.

Step 8: Import Web connect file into Quickbooks

Step 8: Select Quickbooks account to import

Step 9: Review imported transactions in accounting software

Review Imported transactions under the Bank Feeds in Quickbooks. Match payees to vendor records, assign expense/income accounts and add transactions to the register.

Step 9: Review imported transactions in accounting software

See a separate tutorial going in details for QBO file import in Quickbooks.

Related articles