Working with transactions
This video shows how to work with transactions inside the converter.
This video is for the Bank2QBO converter.
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.
So, first, you can uncheck any transaction — it means that these transactions will not be used for the conversion.
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.
You can change the Amount sign from the Deposits to Withdrawals, and back.
You can add these Payee Names to Payee mapping, or Category mapping.
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 -’.
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.
Then we can change the Amounts, if you change Withdrawal to Deposit, then it would be 24610.
And then it would jump here, right-click.
If you work with dates — make sure the dates are correct. When you enter incorrect dates, then it will be ignored.
You can also scroll this way if there are more fields.
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.
The next part is the bottom controls. They are 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.
So, in this case, we click once and the Amount sign changes from ‘+’ and from ‘-’ to ‘+’.
If you want to adjust the year quickly on all transactions, we may also use that.
So, in our case, it will be 2016 and we can quickly adjust it.
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.
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.
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.
‘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.
The last control is ‘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.
Originally published at www.propersoft.net.