Category: Other

15 posts

The WordPress.com stats helper monkeys surprised me today with their 2012 annual report.

Here’s an excerpt:

My blog had 33,000 views in 2012. The busiest day of the year was September 4th with 644 views. The most popular post that day was How I replaced the CloudStack Virtual Router with my own physical Linux router that was featured on Linux Today.

Visitors came from 165 different countries.. wow! Most came from The United States, followed by The Netherlands and Germany. A lot of the visitors were searching on Google, some on Twitter, and found my blog that way.

Click here to see the complete report.

Thank you all and I wish you all the best in 2013!

See ya there 🙂

To track my spendings, I started using the Account Tracker iPad app by Graham Haley. It’s a very solid and well written app that I’ve been using for some weeks now. I really like it, especially because it has a clearly designed gui and rich feature set. Another big plus is that the developer responds very quickly.

But, entering all transactions by hand for me was a no-go. I just don’t want to do that because it’s a lot of work and we might also forget to enter some. Furthermore, almost all transactions we do are done electronically. That’s when I started to think about importing transactions from our Bank Account into the iPad app. Fortunately the app has a feature that let’s you import a csv file. Our bank’s website also has an export feature so that should be doable!

Of course, the formats differ so a direct import is not possible. Also, I want to track spendings by category without entering the category for each and every transaction. I wanted to create something that would work as automatic as possible.

Good news: I just pushed the first public version to GitHub! Let me tell you more..

My goal was to enter all our 2012 transactions to the app. To start, I created the accounts in the app and set their opening balance to the balance on 01/01/2012.

You can create as many accounts as you like, order them in groups, sort them and so on.

That’s all (for now) you’ve to do in the app.

I assume you know how to export transactions from your Bank Account. There should be an option to download a ‘csv’ file, also often referred to as ‘Comma Separated Values’. Contact your bank, it’s a common feature.

Different banks, different export formats
Most banks have their own format (order of columns and number of them to be exact) in which they export transactions. Therefore, a solution that works for anyone out-of-the-box is not possible. But, I did the next best thing: wrote something that can be easily extended. I have accounts at two different banks: ASN Bank and Triodos Bank and have added support for both. I’ll ask some people I know for a dummy export, so I will be able to add support for more banks later on. If you want to do it yourself: the README on Github describes how to add support for your own bank.

Download the scripts
You can download my scripts for free from the GitHub project page.

Let’s see how this works
I login to my ASN Bank account and export a csv-file. The ASN Bank is pretty smart: they remember what transactions I downloaded last time, and only let me download new ones. This is pretty cool, since that prevents double transactions. Triodos Bank let’s you download transactions by a date range you enter. Be careful not to download the same transaction multiple times.

Save this file to: ./files/exported_from_bankaccount/asnbank/
If you have more than one file, just add them to the same directory. The script will combine them so you don’t have to worry about that. Different accounts is fine, as long as they are from the same bank.

To get started with the scrips, edit the settings. First, copy the example, then edit it:

cp -pr ./conf/settings.example.inc.php ./conf/settings.inc.php
vim ./conf/settings.inc.php

Add the accounts you also added to the app, like this:

$_SETTING['my_account']['0707711122'] = "ASN Account";
$_SETTING['my_account']['300.03.83.213'] = "Triodos Account";

The names of the Accounts (ASN Account and Triodos Account in this example) need to match the names in the app. See the image above. The number refers to the Account Number that is in the export file (this is your own account). Be careful to enter it exactly as in the export file. As you can see ASN Bank has no separators, while Triodos Bank has.

Categories
You will get better reports if you set a category with each transaction. The script supports a system where transactions can be matched to categories. For example, when I buy something at ‘Albert Heijn’ or ‘Digros’, it’s always ‘Groceries’. You enter them like this to the settings file:


$_SETTING['billing_category']['Albert Heijn'] = "Groceries";
$_SETTING['billing_category']['Digros'] = "Groceries";
$_SETTING['billing_category']['BP '] = "Fuel";
$_SETTING['billing_category']['Shell'] = "Fuel";

There is no limit in how many you can add. All you need to know is that the first one that maches, is used (it works top down). In the example above, when ‘Albert Heijn’ is in the description of the transaction, the category is set to ‘Grocaries’. When ‘Shell’ is found, the category is set to ‘Fuel’. I hope you get the idea. It works for both spendings and income.

If no match is found, the category ‘Unknown’ is used. (configurable in the settings file) When this happens, the script warns you, so you can easily see what line did not match any category. You can either safely ignore it, or add an extra category to the settings (and re-run the script). You just have to do it once, all transactions that match will be handled automatically from then onwards. But remember: you can always edit the categories in the app later on as well. Even split them between two categories.

Also have a look at the timezone setting, if you’re not in ‘Europe/Amsterdam’, like me. It is used to calculate the right date in the ’18/09/2012′ format since the app expects to read it like this.

Generating the import csv file
To start generating, run this command:

php run_import_asnbank.php

Make sure you select the script that matches the Bank Account(s) you want to process.

When everything goes well, it tells you where to find the generated file. If something goes wrong it tells you what went wrong.

Done! Wrote file ./files/generated_ipad_import/import_asnbank_20120918161644.csv
Please open the file for manual review, then upload it to the Account Tracker iPad app.

Importing the generated file
Time to import the generated file. I’ll show you using some screenshots:

1. Open the app, tap Settings, tap Backups, tap ‘Import / Export by WiFi’. It looks like this:

2. On your computer, open a browser and enter the url shown. A page will be displayed that looks like this one:

3. Click ‘Choose File’ and select the generated file on your computer. Then click ‘Copy’ to transfer it to your device.

4. Back to your device: click ‘Stop’ and select the file you just uploaded. A screen like this appears:

5. Click ‘Import CSV File’ to import the file. The app will validate your file. When the file is corrupt, a clear message is displayed:

In this case, the ‘Account Name’ in the app does not match the one in the settings file. Double check! If all goes well you’ll see:

6. Now, click ‘Import’!

The transactions are imported successfully. Now go to the Accounts screen and let’s a look to the ‘ASN Account’. You will notice the balance changed. When you tap on the account, you’ll see its transactions:

As you can see, the transaction has been added and it detected ‘Groceries’ as category. In a bit more detail:

Now, that’s cool, isn’t it?! 🙂 You should check if the balance now matches the one on your bank’s website. If you entered the correct opening balance and imported all transactions, the balance should match.

Budgets
It becomes even better when you setup Budgets in the app. You can create a Budget once you have a category. Just tap ‘Budgets’, then ‘+’, and select ‘Groceries’. Finally, enter the budget:

The spendings (and income too) are then calculated against this budget. It gives a pretty clear picture:

In this example we’ve imported a single transaction. I’ve added over 600 transactions at once and that works perfect. The app detects transfers between your own accounts and does not calculate those as spending. That only works when you add all your accounts, of course.

Once you have some data, you can play with the reports and see how money comes in and goes out. It’s pretty detailed and very well designed. You can even export to PDF to save the report somewhere offline.

Don’t forget to protect the app with a PIN code. This way, when you lose your device your data cannot be seen. A PIN code on the backups as well is coming.

I really recommend the Account Tracker app and hope my scripts will be useful to others as well. Let me know!

How do you think I can improve my blog?

— 124 views — No comments

Now that I have some time off, I enjoy spending some of it on my blog. I played with some WordPress settings and redesigned the right column. My most important goal here is to make sharing easy.

Why? Because I benefit a lot from what others post and want to give back a bit. That’s why I write my blogs. If you find them useful, it’s now easy to share them on Twitter, Facebook, Linked-In and others. The more people benefit, the better, don’t you think?

Finally, to give my blog a personal touch, I changed the address bar to: blog.remibergsma.com

How do you think I can improve my blog? I appreciate your feedback 🙂

Great run, great weather!

— 69 views — No comments

Today is a very nice day with a lot of sun shine. This morning I decided to go for a run, to get rid of the stress and to enjoy being outside. Just running for some time makes me calm and relax again. I love that feeling!

I haven’t been running for almost a year. Today I took my Garmin Forerunner 305 with me. The nice thing is that the device has a GPS chip and can track many things, like distance, pace, heartbeat, calories etc. When I got home, I uploaded the run data to the MapMyRun website. It produces these nice images:

As you’ll probably see the distance and pace are not quite impressive yet 😉 Over time it should get better.. and as long as it makes me feel good it’s ok with me!

In augustus 2011 was het stroomverbruik van ons gezin (2 volwassenen en een zoon van bijna 1) 297kWh. Al enige tijd was ik de standen aan het bijhouden en zo’n 300kWh per maand vond ik simpelweg teveel. Twee dingen hebben geholpen om dit verbruik in 3 maanden tijd terug te brengen naar zo’n 180kWh: een besparing van 40%!

Dit is hoe we dat gedaan hebben:
1. Inzicht krijgen in hoeveel “sluipverbruik” er is
Hiervoor hebben we een Wattcher aangeschaft: dit apparaat geeft op 10 watt nauwkeurig aan hoeveel stroom er op een bepaald moment gebruikt wordt. Dus wordt er ‘s avonds als je op het punt staat naar bed te gaan nog 400 watt gebruikt dan weet je dat als je 7 uur slaapt je ‘s ochtends 7×400 = 2,8kWh verder bent. En dan heb je alleen geslapen 😉

Inmiddels schommelt dit bij ons zo rond de 100 watt. Dit zijn dan hoofdzakelijk de vriezer en de koelkast.

2. Inzicht krijgen in hoeveel stroom per aparaat er gebruikt wordt
Om gedetailleerder te kunnen kijken is een goede energiemeter essentieel. Het liefst een die ook hele kleine waardes weergeeft. Wij hebben er een van GoGreen die vanaf zo’n 0,2 watt het goed weergeeft (bij de goedkopere varianten is dat 7 watt). Kleine waardes goed kunnen meten is met name handig om opladers en andere kleine sluipverbruikers in kaart te brengen.

Het sluipverbruik was in ons geval steeds tussen de 250 en 300 watt ‘s nachts. Na allerlei dingen gemeten te hebben bleek de 11 jaar oude koelkast een enorme hoeveelheid stroom te gebruiken. Totale kosten 120 euro per jaar. Die hebben we meteen door de gemeente laten ophalen. Voor 400 euro een A++ koelkast gekocht die slechts zo’n 20 euro stroom per jaar kost. Kortom: nieuwe koelkast (die toch een keer vervangen moest worden) verdient zichzelf in 4 jaar terug.

Ook hebben we de laatste gloei- en halogeenlampen de deur uit gedaan en alles vervangen door LED lampen. Bij LedItLight.net koop je mooie LED lampen waarmee je 90% energie bespaart.

Het zit echter ook in kleine dingen: de oplader van de tandenborstel bijvoorbeeld: 2,5 watt continue, of de tandenborstels er nu op staan of niet. Dat lijkt niet veel, maar kost per jaar toch 2,5 watt x 24 uur x 365 dagen /1000 = 22kWh Bij 23 cent per kWh is dit ruim 5 euro per jaar. Een oude tijdschakelklok heb ik ertussen gezet. Die gaat ‘s nachts een uur aan, voldoende op om te laden. Besparing: 23 van de 24 uur geen stroomverbruik. Tijdschakelaar kost een paar euro en is dus snel terugverdiend.

Met de energiemeter kun je alle apparaten in huis nagaan, op zien naar soortgelijke situaties. Je komt veel tegen en word je bewust van het verbruik.

Nu we onder de 200kWh per maand zitten moet het mogelijk zijn om voldoende te hebben aan de verwachtte 2.400 kWh opbrengst van onze zonnepanelen. Ben benieuwd!