Keeping track of property,
investments and securities.
To keep track of property, investments and securities accounts, bring all values together in one place, value each asset class according to a fixed rule, file documents and deadlines with the asset concerned and review a few key figures at regular intervals. This guide shows how in six steps.
In short: with only a few positions, a spreadsheet is enough. As soon as rented property with loans, companies and lots of receipts come into play, family office software such as Finaure takes a lot of the upkeep off your hands, such as transferring account balances and filing receipts.
The bank only shows the securities account, the property manager only the property, and the value of an investment is in the latest annual accounts. That does not add up to a complete picture.
Step 1: Record all assets
First list everything there is: bank and securities accounts at each bank, property, investments and companies, loans, insurance policies with a surrender value, tangible assets such as art or vehicles. For each position, note who owns it, that is, which person or which company. This step takes the most work. If the wealth belongs to several family members, see the guide Consolidating the wealth of several family members.
Step 2: Bring everything together in one place
Decide where the overview should live. Three typical options:
- Spreadsheet: flexible and usually free, but every figure has to be maintained by hand.
- Portfolio tracker: strong on securities, often with import of account statements. Some now also record property and tangible assets at a value you maintain yourself. Tenancy agreements, receipts and companies with their owners are not their focus.
- Family office software such as Finaure: brings bank and securities accounts together via a bank connection and maps property, investments and companies with their owners. You can upload existing documents and spreadsheets; the AI recognises people, companies, assets and accounts in them and suggests them for import.
Step 3: Value each asset class according to a fixed rule
Securities and bank accounts have a daily value. For property and investments, you have to decide how to value them yourself, and stick to it:
- Property: market value from an appraisal, an online valuation or your own estimate, with a date. Keep the loans right next to it so the net value is visible. An example: a flat with an estimated market value of €600,000 and a loan of €350,000 counts towards net worth with €250,000.
- Investments without a share price: book value, last transaction price or a simple income-based model. Doing it the same way every year matters more than precision. Inheritance and gift tax have their own valuation rules.
- Tangible assets: purchase price and an occasional estimate.
In Finaure, every asset has a current value with a date and a value history; property and tangible assets also have their purchase price. Connected securities accounts and precious metals are updated daily.
Step 4: Define the key figures
A few figures are enough for the overview: total assets, liabilities, net worth, liquid funds and the split by asset class. If you let property, also keep an eye on rental income, costs and the remaining surplus per month. What a complete report contains beyond that is covered in the guide Wealth reporting.
Step 5: Assign documents and deadlines to the assets
Each property comes with tenancy agreements, loan agreements, insurance policies and invoices. Do not file them in a general folder but with the asset concerned, and note notice periods and the end of fixed interest periods. In Finaure, you choose the person or company when uploading; the AI reads the document and suggests the matching property. You review and confirm. As soon as a notice period is recognised in a contract or the end of a fixed interest period is recorded for a loan, Finaure creates a task for it. How the reading works is described in the guide Reading statements, receipts and contracts automatically.
Step 6: Set a regular routine
An overview only helps if it is up to date. One possible routine: check accounts, rents and unpaid invoices every month; key figures and the split by asset class every quarter; and once a year, revalue property and investments and prepare the documents for your tax adviser.
When a spreadsheet is enough and when it is not
A spreadsheet is enough as long as you bank with one or two banks, do not let any property and do not hold any companies. With the first rented property with a loan, or the first company, the upkeep becomes the real work: rents, interest and receipts then come in every month. From that point, software pays off: it fetches balances automatically and suggests where receipts belong. The switch is described step by step in the guide Managing wealth without Excel.
Frequently asked questions
How do I keep track of property, investments and securities accounts?
By bringing all values together in one place, valuing each asset class according to a fixed rule and updating the overview regularly. A spreadsheet, a portfolio tracker or family office software such as Finaure can do this.
Which tool shows property and investments together with securities accounts?
Family office software, for example Finaure: it maps bank and securities accounts, property, investments and companies together, each assigned to its owner, and also manages contracts and receipts. Portfolio trackers specialise in securities; some also record property at a value you maintain yourself.
How do I value an investment that has no share price?
With a fixed rule, such as book value or last transaction price, and a valuation date. Doing it the same way every year matters more than precision. Inheritance and gift tax have their own valuation rules.
More guides
- What is a family office? Meaning and tasks
- When is a family office worth it?
- Family offices and taxes in Germany
- Family office software: features and costs
- Excel or software? Managing wealth without Excel
- Holding company assets: structure and reporting
- Consolidating the wealth of family members
- Reading statements, receipts and contracts
- Private equity: capital calls and open commitments
- Wealth reporting: what a good report shows
Last updated: