Convert to CSV/Excel format settings

This tutorial is about converting to the CSV/Excel format.

Use the ProperConvert app to convert your transaction files to required by your accounting software file format.

Set attributes to convert to the CSV format Step 1: main menu

There is a CSV Tab on the right sidebar.

Set attributes to convert to the CSV format Step 2: csv tab

When we use this CSV option, we are presented with two parameters: CSV Target and Output Dates. The first is CSV Target: you can select how you want your CSV file to be created - is it 'Regular CSV', is it 'XLSX Excel', is it older 'XLS Excel'.

Set attributes to convert to the CSV format Step 3: csv target

In the 'Regular CSV' we output all columns you see on the screen.

Set attributes to convert to the CSV format Step 4: Regular CSV

But in the 'CSV Quickbooks Online' - Quickbooks Online imports only three columns: Date, Amount, and Description. So, you will see only three columns on the CSV file. Why we would do that? It is easy for Quickbooks Online to work with that file, when you upload such a file, it will imports 3-4 without no choosing anything, Quickbooks maps it automatically, it is less confusing for you in Quickbooks to get your Data imported. 'CSV Xero' provides more columns because Xero imports the references columns, so you have more fields here. 'Quicken Mac (CSV Mint)', which also requires special formatting for special rules to be followed, to have that CSV Mint file successfully imported by Quicken for Mac.

There are other things, like 'Quickbooks Batch Checks', 'Quickbooks Batch Deposits', 'Quickbooks Batch CCard', copy to 'Clipboard', same as this 'Clipboard', then you can paste it to Quickbooks. FreeAgent and two special cases for Splits: 'Simple CSV with Splits' and 'Full CSV with Splits' to output, let's say, QIF file Splits and two ways, that certain users needed to work with them in a certain way.

The second parameter is the Output Dates. You can specify Dates since the CSV file in the certain software will be processed this file and Dates are usually hard to process and they have to be in the specific format, so you can choose all available options here, how your dates should look like.

Set attributes to convert to the CSV format Step 5: output dates

There are also few settings, that are hidden just not to change accidentally, and then the software will not import: which 'Encoding' you want to use and how many 'Decimals' you want. And if want to use 'Dot' or 'Comma' Decimals separated. So, if you need it, you can find it in the 'Settings' and change it.

Set attributes to convert to the CSV format Step 6: settings

Related articles