Journal Generator

.NET 6 Console Application that converts statement for international payment from Íslandsbanki online bank to a Payday journal import file.

Setup

Make sure you have .NET 6 SDK installed.

To run the app run in .NET CLI:

dotnet run

Further installation guide

How to export Islandsbanki international statement for international payment

Step 1. Table Capture browser extension

Make sure you have Table Capture browser extension installed.

• Google Chrome
• Firefox
• Microsoft Edge

Step 2. Export the statement using Table Capture

Right click the table and select Table Capture > Table Capture - Launch workshop

Step 3 Select Google Spreadsheets

Step 4. Paste the table in Google Spreadsheets

Paste the table that has been automatically been saved in your clipboard into cell A1

Step 5. Delete Column A

Step 6. Make sure you are using European standards in numbers and dates.

Best way to ensure you are using the date and number standards that is supported in Iceland is to go to the file settings and select Germany as your locality.

Example file

You can see how the input file should look like if you open up Journal.xlsx.

Using the application

Run the console application and select the first application to run.

Applications
  1: Generate Journal from Islandsbanki Foreign Payments

Enter the number of application to run or press 'x' to exit:
1
Enter file path:
C:\Users\egillanton\Desktop\Journal.xlsx
Successfully generated 24 journal entries to file: C:\Users\egill\Desktop\Journal_ouput.xlsx

• Input file: Journal.xlsx.
• Exported file: Journal_output.xlsx.

Note that 5 entry lines are generate for each entry.

Future Improvements

• Have a separate config JSON file for all accounts (as seen in PaydayJournalUtils).
• Add application to export it directly to Payday API when their API allows for it.
• Handle better the accounts that don't appear in the settings