The aim of the thesis was to improve the hardware and working methods of a local accounting company, Koontia Oy. Current computer hardware was insufficient and error-prone, therefore new, custom-built hardware was needed.

An improved VPN connectivity was desired, along with upgrades to Koontia Oy’s file server. The file server was updated from Ubuntu to Windows Server, and the VPN connectivity was updated to use Remote Desktop Protocol from OpenVPN.

Excel spreadsheets were used for customer details and billing tracking, and an improved solution was wanted. A database for customer data and billing track-ing were implemented but ended up not being used due to difficulties in finding suitable client software for access and editing, and issues in data migration.