How to work with loaded transactions

This video shows how to work with transactions after you loaded in the Transactions converter.

Step by step instruction

Regardless of the input format - is it CSV or PDF, or another format, you would see transactions here the same way.

How to work with loaded transactions Step 1: main window

The first thing to mention about working with transactions is the output format. Before you start working with doing anything else - set the output format, because it defines the columns you see.

How to work with loaded transactions Step 2: OFX output format

Certain formats have certain fields, that do not apply to other formats, so, for example, you would not see the category for the OFX files, but you would see the category for the QIF files.

How to work with loaded transactions Step 3: QIF output format

You would see Name and Split Name for the IIF file, but for the QIF file only Name. Set the output format before anything else.

How to work with loaded transactions Step 4: IIF output format

The second thing is 'Show dates as'. It defines how dates are shown to you, when once they are parsed. So, in your CSV file or PDF file - the date format could be different, and you could be telling the converter - what the date format is in that CSV file, but how you see dates once after they are parsed is defined by this. You know, that, let's say, in that CSV file dates would be day/month/year, but it is not usual to you to see those dates this way, and you would tell the converter: my CSV dates are this, but I would like to see dates my usual way, as month/day/year.

How to work with loaded transactions Step 5: Show dates as

The next thing is 'Set year'. Some files, like some CSV files, some QIF files, some PDF files have a year missing or could not be determined exactly clearly. So you have the way to set the year for all dates without touching month and day.

How to work with loaded transactions Step 6: Set year

Another thing, that is for certain files, like Credit Card files, they may have expenses supplied as positive numbers and payments to the account supplied as negative numbers, but regardless of the Account type, expenses should be always negative and payments to the account should be always positive. This is how accounting software expects those transactions to be. If there is Amount and it has a sign: 'minus' means - take from the account, 'plus' means - put into the account. If you see, that everything is reversed after loading the file: Deposits are Withdrawals, Withdrawals are Deposits, click the 'Change +/- for all' button to quickly reverse all Amounts once.

How to work with loaded transactions Step 7: Change +/- for all

The next thing is 'Add transaction'. There is a way here to quickly add one or two transactions, as a quick edit, let's say, sometimes you would like teens on the fly before converting, so that's the button for that.

How to work with loaded transactions Step 8: Add transaction

The next thing - checkboxes, which define if a transaction will be included in the output, so you may say: "I don't want this transaction", so you just exclude it. Also, only transactions, that are checked off, will be used for the output. Those are called selecting transactions.

How to work with loaded transactions Step 9: checkboxes

Let's talk about highlighting transactions. Let's say if you click on a transaction - it's highlighted, so if you want to highlight three transactions - click the first one and then hold the 'Shift' key on the keyboard and then click the last one. Then you would have this range of transactions selected.

How to work with loaded transactions Step 10: three highlighted transactions

If you want №1 and №3 transactions - you would hold the 'Ctrl' key and then click that another transaction you would like to select. So, now you have two highlighted transactions.

How to work with loaded transactions Step 11: two highlighted transactions

What can you do with highlighted transactions? If it's one or more, the same thing, you right-click on the highlighted area, and then you do 'Uncheck' - they are not selected.

How to work with loaded transactions Step 12: uncheck

You could 'Change +/-' only for those two.

How to work with loaded transactions Step 13: change +/-

There are other things like you can change 'Year +' or 'Year -' only for those specific lines. Sometimes, this is helpful for, let's say, you have a PDF statement, and it goes over year, and in some cases, the converter would not detect that year change, so you would have December, December, December 2016 and then you would have January, which supposed to be 2017, but it's still 2016. So, you would select those January dates and just adjust the year quickly.

How to work with loaded transactions Step 14: Year

There are other things, like 'Add payee(s) to category mapping', 'Add payee(s) to payee mapping'.

How to work with loaded transactions Step 15: Add payee(s) to category mapping

Related articles