How to work with loaded transactions

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

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

The first thing to mention 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.

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.

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.

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.

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.

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 an 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.

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.

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.

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.

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.

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.

You could ‘Change +/-’ only for those two.

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.

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

Originally published at www.propersoft.net.

--

--

--

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

OOP: 3 types of inheritance

How to Track Custom Events & Player Progression Events in Your Unity Game with ByteBrew

Implementing Data Structures with python without using modules(Basics)

Creating SSH Key for BizCloud

VSCode Remote development on Digitalocean

Git log pretty print aliases

Approach to select the browsers and versions for automated software testing

Hwp Reader For Mac Download

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sergiy Tytarenko

Sergiy Tytarenko

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

More from Medium

Why SAP? — Why industries use SAP system?

[WORK AROUND] Build and Optimize Data Warehouses with BigQuery: Challenge Lab

How to deal with missing data with Python: using the 2009 H1N1 vaccination survey

Scraping Data and from Spotify’s API