Seb
It extracts data from exported xlsx file of SEB bank statments and generates a financial report.
Installation
$ gem install seb
Usage
Login to SEB private bank, go to "Mina konton", click "Kontohändelser" and download the exported the .xlsx file. Click "Exportera till kalkylblad (xls)" to export:
Then run:
$ seb report Export.xlsx
+---------+-------------------------+
| Summary |
+---------+-------------------------+
| Name | Rex |
| Account | 12345678 |
| Dates | 2014-04-14 ~ 2014-08-14 |
| Balance | 1000.0 |
| Expense | 500.0 |
| Income | 1100.0 |
+---------+-------------------------+
+---------+---------+--------+---------+
| Group by Month |
+---------+---------+--------+---------+
| Month | Expense | Income | Balance |
+---------+---------+--------+---------+
| 2014-08 | 200.0 | 1000.0 | 800.0 |
| 2014-07 | 100.0 | 0.0 | -100.0 |
| 2014-06 | 100.0 | 0.0 | -100.0 |
| 2014-05 | 100.0 | 0.0 | -100.0 |
| 2014-04 | 0.0 | 100.0 | 100.0 |
+---------+---------+--------+---------+
For help:
$ seb help
Commands:
seb help [COMMAND] # Describe available commands or one specific command
seb report FILE # Show the report of the xlsx file
seb summary FILE # Show the summary of the xlsx file
seb version # Show version
Contributing
- Fork it ( https://github.com/wangyuhere/seb/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create a new Pull Request