We have created a solution to do bank reconciliation here: [url removed, login to view]
The solution is half-finished and has several bugs/limitations. In order to speed up the development, I want another developer on the project. The starting point is the new feature described here in this project.
To read some background about what a bank reconciliation is and hence the purpose of the software, have a look at the document I have written here: [url removed, login to view]
At [url removed, login to view] the left table shows receipts we have typed, and the right column shows the transactions found in the bank.
A limitation of the current solution is that sometimes a receipt will be in a non-danish-currency amount (short form DKK) (like for example dollars). In these cases, the [url removed, login to view] interface will set an amount in the amount_original_currency column in the database in the receipt table, but leave the "amount" column empty. The database can be inspected here: [url removed, login to view]
The change I need is that when a row in the database has a row with an empty value in the "amount" column at the point when the [url removed, login to view] is accessed, then the amount should get converted to DKK so that this converted amount is presented in the "amount" column in the left table in [url removed, login to view] The amount in the table should be red to indicate that it may not be the exactly correct amount (the exchange rate might be slightly off).
When the record is matched with a column in the right table in [url removed, login to view], the amount should get updated to the amount from the bank (but it should stay red, in the case where the match was wrong and should be redone). Basically it means that all receipts that have a currency set to something else than DKK, should be in red.
We have already developed a solution to convert currencies at historical rates, created as a part of this project: [url removed, login to view] It can be seen in action here: [url removed, login to view] That solution utilizes [url removed, login to view] to download historical rates. I will provide the source code shortly.
Please read the requirements/getting started guide here before starting on this task. [url removed, login to view]