Setting up a portfolio
With the Set up portfolio dialogue, you turn an imported bank portfolio into a complete portfolio in Finaure in about a minute: with owner, settlement account, positions and assigned securities bookings. Afterwards, the portfolio cockpit shows you its value, performance and dividends.
Takes about a minute. You only need two things: the portfolio and the account through which purchases, sales and dividends run.
What is “Set up portfolio”?
When you connect your bank, Finaure retrieves accounts and portfolios automatically. At that point, though, a portfolio is still incomplete: Finaure does not yet know who owns it and which account the money runs through. The dialogue clarifies exactly that in three steps:
| Step | Question in the dialogue | What Finaure does with it |
|---|---|---|
| 1 | Who owns the portfolio? | Assigns the portfolio to an entity. Wealth, reports and cockpits depend on this. |
| 2 | Which account does the money go through? | Links the settlement account. Finaure uses it to calculate your performance. |
| 3 | Review and finish | Assigns the securities bookings and compares the holdings with the bank. |
Terms in brief: The entity is the owner, i.e. a person, a company or a foundation. The settlement account is the current account on which the purchases, sales and dividends of your portfolio are booked.
Before you start
- Your bank is connected (Banking → Connect bank) or the portfolio is already visible in Banking.
- Ideally, the owner already exists as an entity. If not, owners and admins can create it directly in the dialogue.
Depending on the security settings, “Connect bank” requires two-factor authentication (2FA). If it is required and you have not set it up yet, Finaure asks you to do so before you log in to your bank. You need an authenticator app for this; setting it up takes about two minutes.
Step-by-step guide
- Connect your bank via Banking → Connect bank. The login runs through our BaFin-regulated partner finAPI. Your login details go only to finAPI and your bank.
- Finaure detects the portfolio and opens the Set up portfolio dialogue automatically.
- If the portfolio is already in Banking, click Assign on its card.
- At the start, the “What happens now” start page shows you what to expect. Click Let’s go.
The start page appears until you tick “Don’t show again”.
- Under Who owns the portfolio?, click the person, company or foundation that owns the portfolio.
- If it does not exist yet, click Create new entity (owner or admin).
- If the portfolio belongs to several people, tick Joint portfolio (several owners).
- Click Next.
Not sure? Expand “Why?”: you will find an example there. “Ask the SmartGuide” gets you help directly in the dialogue.
- Under Which account does the money go through?, Finaure shows the owner’s accounts.
- Click the account in which purchases, sales and dividends arrive. If Finaure finds a matching account at your bank, it is already preselected.
- If your account is not listed, depending on your permissions you can connect it at your bank, Create account manually (an account name is enough, the IBAN is optional; the account belongs to the same owner as the portfolio) or Link later (the portfolio is created anyway).
- If the chosen account already serves another portfolio, also confirm “Yes, use it for both portfolios”.
- Click Create portfolio. The button only becomes active once you have chosen an account or used one of the options.
- Finaure assigns the securities bookings to the portfolio. If bookings are found, confirm them with Confirm all … (the button shows the number).
- You then see the summary Your portfolio is set up (if no bookings were found, click Next first): portfolio, owner, settlement account, positions and assigned bookings.
- Below it is the holdings comparison: for each security, you see the holding according to the bank and according to the bookings. “matches” means the two agree.
- Click Done. You will find your portfolio under Portfolios, with positions, allocation and performance.
Are past purchases missing? Add the cost basis via Add cost basis, or upload a statement with cost values via SmartUpload → Portfolio statement, for example as a PDF, XLSX or CSV file.
Without a settlement account, Finaure cannot calculate the performance in full. In the portfolio, the note “Settlement account missing – link now” reminds you of this and takes you back to the dialogue.
Good to know
- Later closes the dialogue without creating the portfolio. An entity newly created in the dialogue or a manually created account is kept. Via Assign on the portfolio card in Banking, you can reopen the dialogue at any time and continue at the open step.
- If you have several open portfolios, Finaure opens the dialogue for each one in turn (“1 of 16 portfolios”). Later takes you to the next portfolio.
- If the portfolio belongs to a person who has not yet been created in Finaure, you can create them in the dialogue. With so many details to record (for example date of birth or tax data), though, it is worth setting the person up fully under Entities beforehand.
Importing a portfolio from a file
If your bank does not deliver the portfolio automatically, or you want to add portfolio holdings later, you can take the positions from a file from your bank. This works via SmartUpload → Portfolio statement with PDF, XLSX, XLS, CSV or TSV files.
The import writes to an existing portfolio. If you do not have one yet, create it first (first tab). If the portfolio belongs to another person, create that person under Entities beforehand.
- Open Assets and click Add Asset.
- Under Financial Investments, choose Portfolio.
- Enter a Name (e.g. “HAL Portfolio Jonas”) and choose the Owner.
- Under Account Data, add the Bank / Broker and the Portfolio Number.
- Click Save.
- Open Portfolios and click SmartUpload at the top.
- Choose Portfolio statement (Import portfolio statement / broker export).
- Choose the Entity and the Portfolio and click Next.
- Drag your bank’s file into the upload field, or click into it and select the file.
- Click Analyze.
If Finaure already knows your bank’s format or the automatic column mapping succeeds (“Mapped automatically”), skip this step. Otherwise, Map bank format opens:
- Give the profile a name under Name for this bank profile (e.g. “Hauck Aufhäuser Lampe holdings”).
- Finaure shows you all Detected columns in your file.
- Under Map fields, map at least the required fields ISIN and Description, ideally also quantity, market value, current price, cost price, cost value, currency and price date.
- Click Save & import.
The profile is saved for your account. The next time you upload a file from the same bank, Finaure recognises the format automatically.
- In Portfolio statement import, you see the detected format, the as-of date and the file.
- Below that are all Positions with ISIN, quantity and value. Use the tick boxes to decide what is imported.
- If the file contains your complete portfolio holdings, tick File contains the complete portfolio.
- Check the Total and click Import.
- After “Successfully processed”, you will find the portfolio under Portfolios with positions, gain/loss and allocation.
If you tick “File contains the complete portfolio”, positions that are in the portfolio but missing from the file are booked out with a holding of 0 (not deleted). Only tick it if the file really contains all positions.
If you did not choose a settlement account during the import, link one in the portfolio via the pencil icon next to “Settlement account” so that Finaure can assign purchases, sales and dividends.
Frequently asked questions
What happens if I link the settlement account later?
The portfolio is created immediately. The portfolio cockpit then shows a note that the settlement account is missing. Clicking it takes you back to the dialogue. Until then, purchases, sales and dividends are missing from the performance calculation.
My account is at a different bank from the portfolio. Does that work?
Yes. You can choose any of the owner’s accounts. If it is not yet in Finaure, create it via “Create account manually” or connect the second bank.
The portfolio belongs to several people. What do I choose?
In the first step, tick “Joint portfolio (several owners)” and select all owners.
The holdings comparison does not match. What now?
Usually, older purchases are missing because the bank only supplies transactions for 12 to 24 months. Add the cost basis via Add cost basis or upload a statement with cost values via SmartUpload. If a booking is in the wrong portfolio, check it via Open bookings in the portfolio.
Can I undo the setup?
You change the settlement account in the portfolio cockpit via the pencil icon (Edit) next to “Settlement account”. Owners and admins change the owner in Banking via Edit on the card.
Why does “Connect bank” require two-factor authentication?
To protect your bank data, 2FA may be required for connecting a bank, for example if your account requires it. Set it up once under Settings → Security with an authenticator app and then click Connect bank again.
Which files can I upload as a portfolio statement?
PDF, XLSX, XLS, CSV and TSV. Your bank’s holdings list or portfolio export works best. For a holdings spreadsheet, Finaure reads the first file; Finaure processes several files at once (up to 30) for PDFs and transaction exports.
Do I have to map the columns again for every upload?
No. Finaure saves the mapping as a bank profile for your account. The next time you upload a file from the same bank, Finaure recognises the format automatically and you go straight to the preview.
Can I create a new portfolio when uploading a portfolio statement?
No, the import always writes to an existing portfolio. Create it beforehand under Assets → Add Asset → Portfolio.
What happens if I upload a newer file for the same portfolio?
Finaure creates new positions and updates existing ones; no duplicate positions are created. Tick “File contains the complete portfolio” if positions that are no longer in the file should be booked out.
Where can I find the uploaded file later?
Finaure stores the file under Documents.
Next step: keep track of all portfolios with their total value and performance on the Portfolios page.