I am a retiree who's tax domicile is Israel who has a small portfolio of personal investments , and I am also the director of a Canadian based investment company investing on behalf of three family members.
Every month I currently download and annotate by hand the data from 9 different bank accounts, and using my own excel spread sheet I analyse the credits and debits from these statements. There are less than 50 relevant enteries every month.
Knowing that the bank statements can be downloaded directly in excel I am interested in streamlining my monthly recording.
I see three goals to my project:
1. to create a spreadsheet compatable with the banks' reporting features (excel or other) with drop-down choice boxes that allows me an easy way to annotate the enteries on the bank statements as there are a limited number of categories for discriptors for the "credit" and "debit" entries.
2. having entered the monthly data, according to the predetermined descriptors, I would like to be able to access easily the income from the various investments, the cummulative transfer of capital to and from the 3 partners and the company (individual investment and payouts) and between the partners (for example loans and their repayment) .
3. the final goal is to have the program integrate the data so as to be able to calculate the financial status of the company and of my personal equity at a single click at any given date.
I feel that it would be sufficienty for the program to generate tables for the above questions, but I would also be interested in learning about the extra cost entailed for converting these tables into more attractive graphic presentations for distribution to the 3 partners in the company.
My goal is receive a system that will run from month to month with little or no further input from the programmer; however, I imagine that some ongoing help miggt be needed from time to time to tweak the program or to modify, expand or improve it.
פרסום פרויקט
התחבר עם פייסבוק
התחבר עם LinkedIn