Working with transactions (2020)

This video shows how to work with transactions inside the converter.

This video is for the Bank2QBO converter. IMPORTANT: Bank2QBO is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Working with transactions Step 1: main menu

But the transaction part, which starts from here and goes to the bottom, is similar for all converters, so, if you work with one converter, and you work with another converter - this part would be the same. This video is focused on this part, what you can do in this window. It applies to the Windows version, Mac version, and any other different converter, because it is the same, and looks the same, it works the same.

Working with transactions Step 2: same part of converters

So, first, you can uncheck any transaction - it means that these transactions will not be used for the conversion.

Working with transactions Step 3: uncheck

If you want to uncheck several transactions, then you have to select several transactions. First, you need to click the first transaction and then you have to hold the 'Shift' button and click the last transaction. For example, in this case, this is a selected transaction range. When you right-click on this selection - you will see a Menu - what you can do with these selected transactions. It is applicable to 1 transaction or 10 transactions, or 25, or all transactions. You can check them, you can uncheck them.

Working with transactions Step 4: check

You can change the Amount sign from the Deposits to Withdrawals, and back.

Working with transactions Step 5: change +/-

You can add these Payee Names to Payee mapping, or Category mapping.

Working with transactions Step 6: add payee

And you can adjust the year on dates. This is useful, when you have the transactions across in a year-end, and there is no clear way to determine: this is really a year-end, so you see the converter did not pick year-end, and you need to adjust previous year transactions, you can select them quickly, let's say, those are December transactions, and you want to decrease year on dates, you would select this group of transactions and say 'Year -' and you see all dates change 'Year -'.

Working with transactions Step 7: year

We can edit any transaction, any field on this transaction, so, let's say, we want to change Name, we can edit it, and then we press 'Enter' to save our change.

Working with transactions Step 8: change name

Then we can change the Amounts, if you change Withdrawal to Deposit, then it would be 24610.

Working with transactions Step 9: change Withdrawal to Deposit

And then it would jump here, right-click.

Working with transactions Step 10: change, right-click

If you work with dates - make sure the dates are correct. When you enter incorrect dates, then it will be ignored.

Working with transactions Step 11: dates

You can also scroll this way if there more fields.

Working with transactions Step 12: scroll

There's only one column 'Splits'. If you use Splits, then Splits will be shown here, how the Parser understood them, you cannot edit them, but you will see how they are parsed, so you will see that Splits, two Splits, or three Splits, and how they work if they parse your CSV file.

Working with transactions Step 13: splits

The next part is the bottom controls. They all applicable for all converters. What do they do? They allow us to manipulate a whole file, so in the previous case - we select transactions and right-click, now - we can use this button 'Change +/- for all' to quickly adjust all transactions.

Working with transactions Step 14: bottom controls

So, in this case, we click once and the Amount sign changes from '+' and from '-' to '+'.

Working with transactions Step 15: Amount sign changes

If you want to adjust the year quickly on all transactions, we may also use that.

Working with transactions Step 16: set year

So, in our case, it will be 2016 and we can quickly adjust it.

Working with transactions Step 17: adjust year

We can use these parts: 'Switch Payee and Memo', we can 'Get missing name from Memo', so usually, this is required for the PDF files because they provide the description only.

Working with transactions Step 18: Get missing name from Memo

When the Parser does, it takes the Memo, cleans it up and tries to figure out what the Payee name is, and puts it in a Payee column.

Working with transactions Step 19: Name, Memo

In some cases, you need to 'Remove Memo' - you don't want to see some formats or some specific situations - this is provided for the specific case.

Working with transactions Step 20: remove Memo

'Use Post date' - if the document PDF file, or CSV file, or another format has transaction date and post date, and you want to use that post date, and you can use this checkbox.

Working with transactions Step 21: Use Post date

The last control is 'Show dates as'.

Working with transactions Step 22: Show dates as

Dates in your document could be different formats, than dates in your output document, and could be different from us, then you look at your states. So, let's say, your CSV file could have dates as year/month/date, but you look at dates, it is used to look at this as month/day/year - this is how you look at those dates - this how converter show your dates. So, you know, that dates are always shown in this way, no matter how they look on your CSV file, on your PDF file, on your source file and no matter how they look in your output file, this is the way for you to quickly see the dates are correct, because you expect to see them as months/day/year, but they could be in different formats, depending on the format, from where they extracted, or where they have written down.

Working with transactions Step 23: month/day/year

Related articles