The system, consisting of many spreadsheets, can be easily navigated through the Main Menu, providing access to:
- Transaction registers, to record daily transactions in cash or through current/credit card accounts;
- A quick recap of cash, current account, and credit card balances;
- Investment Menu, with dedicated input sheets for each type of investment plus additional sheets for recording, amortized debt (mortgages/consumer loans), at fixed or variable interest rates;
- Charts, divided by type (namely Profitability, Profit & Loss, Net Worth), with interactive function through drop-down windows;
- Reporting Menu, with the ability to select the desired report, already in printable form;
- Administration Menu, to be used for system maintenance actions such as:
- updating market rates
- modifying transaction formats that populate drop-down windows in input screens
- current account reconciliation, with the ability to search movements for a specified time period and for each account
- expenses/revenues budget input
- investigation and resolution of transaction/system errors, avoiding impact on data quality and report accuracy
- access to individual databases
- report maintenance, due dates tickler, etc.
- Dashboard, summarising key performance indicators in the form of graphs, all-in-one;
- Initial Data Upload, that walks you through all steps to be taken to get started, with the ability to select a specific Starting Date, if initial upload takes place in the course of the year;
- New Year Reset button, which similarly describes the start-of-year procedure for balances re-setting, to be completed before recording new transactions for the year.
Whenever necessary, to assist in data input, warnings and explanation messages are displayed to prevent or correct errors. Easy navigation between sheets is provided through a set of icons displayed at the top of each sheet.
Important Note: The system was developed using Excel 2016 for Mac. System requirement at least 8GB RAM. Depending on computer capacity the file may take between 30 and 50 seconds to open
This model template comes as a PREMIUM version in .xlsx file type which can be opened using MS Excel.