How to edit loaded transactions

The ProperConvert app provides few editing options to loaded transactions. The input format could be any supported format: CSV, PDF, QBO, QFX, OFX, QIF, MT940. You may need to set the year, reverse the amount sign or edit specific details.

Edit Option 1: Select the Output format

The first thing you should do is to select the Output format because the Output format defines which fields or which columns you can work with.

Edit Option 1: Select the Output format

For example, for the output QBO, QFX, OFX formats there is no category column.

Edit Option 1: OFX output format selected

But there is a category column for the QIF or IIF files.

Edit Option 1: QIF Output format selected

Edit Option 2: How dates are shown

There is a control "Show Dates as", which defines how dates are shown inside the application. In your source file, like a CSV file or PDF file dates could be in a different date format than you used to see them.

Edit Option 2: How dates are shown

They could be in Day/Month/Year (DD/MM/YYYY) format, they could be just Month/Day format, and it's not how you expect to see dates usually inside accounting apps, like Quickbooks or Xero, so, it could be quite confusing if dates are not shown in an expected format. This dropdown control defines, that dates regardless of how they are presented in the input file, they will be shown always the same way inside the application.

Edit Option 3: Missing or Incorrect year on dates

If you have a missing year in your CSV file or the year cannot be determined, you can quickly change the year of dates, without touching month, and day. User the 'Set year' control to apply a set year to all loaded trandsaction dates.

Edit Option 3: Missing or Incorrect year on dates

Edit Option 4: Change the amount sign (Change +/-)

Another button, that works a similar way is a 'Change +/-' for all. It applies to all transactions loaded inside the application and some CSV files may have a reverse amount sign like especially Credit Card files - they could have expenses as positive numbers and payments to the account as negative numbers. Expenses must be always negative and payments to the account must be always positive. So, to quickly adjust that, click the button once profile.

Edit Option 5: Add a new transaction

The next thing you can do is to click 'Add Transaction' to add just an additional transaction, as part of your conversion. Sometimes you need to do this quickly add a couple of transactions and this button allows you to do that.

Edit Option 6: Select transactions for conversion (checkboxes on the left side)

Checkboxes define if a transaction will be included in the Output. If you want all transactions to be included - make sure all of them have checkboxes checked off.

Edit Option 6: Select transactions for conversion

If you want some transactions excluded - just exclude once you don't want to.

You can use the checkbox on the header to quickly check or uncheck all transactions.

Edit Option 7: Highlight transactions to edit

Another thing to do is highlight transactions. When you work with transactions, you would want to do certain things to a group of transactions, so for this, you have to first highlight them. If you click on one transaction left-click, then you would highlight this transaction, and you click another one - you highlight this one.

Edit Option 7: Highlight transactions to edit

If you want to highlight a few of them, let's say the range, click the first one, hold the 'Shift' key on your keyboard, and click the last one to select transaction range, so those are highlighted ranges.

Edit Option 7: Highlight transactions to edit with Shift key

You can click one and then hold 'Ctrl' and click another one and that would make them those two highlighted.

Edit Option 7: Highlight transactions to edit with CTRL key

Once you highlighted them, you can right-click on any highlighted area to bring this menu. This will apply to highlighted transactions, so you can check them, you can uncheck them, and you can change +/-, you can add the year.

Edit Option 7: Highlight transactions to edit, right click menu

So, this is useful if, let's say, you have a statement, that goes over year-end and the year-end is not detected. Then you would have December 2015, December 2015, then January 2015, which should be 2016. So, what would you do - is just select those January dates, and then right-click and then say 'Year +'.

Edit Option 8: Edit transaction details

You can edit any cell in this table, so you can edit it any way you like. Dates should stay Dates, Amounts should stay Amounts, and for Names and Memos, you can enter anything you like. That's it about working with transactions inside the application.

Edit Option 8: Edit transaction details

Video of this tutorial is included below:

Related articles