Wine collection
In Finaure, your wines are kept in a wine collection per owner. The collection counts as one asset, and the individual wines are positions within it. You create the collection from an Excel or CSV list or enter wines one by one.
After that, you manage your stock in the wine cockpit: movements, storage locations, your own prices and a discount. If your list changes, upload it again and Finaure compares it with your stock.
Overview
| Task | Where | Result |
|---|---|---|
| Create a collection | Assets → Add Asset → Wine | New wine collection for one owner |
| Import a wine list | “I have a list” or SmartUpload → Wine list tile | All wines on the list as positions |
| Enter individual wines | “Enter individual wines” or “Add wine” in the cockpit | One new position |
| Manage stock | Wine cockpit, Positions tab | Movements, own price |
| Adjust the value | Wine cockpit, Valuation tab | Discount on the collection value |
| Reconcile a list | Wine cockpit → “List via SmartUpload” | Comparison with your stock |
The value of your collection is based on your own price, otherwise on the purchase price. Market prices for wine are planned. Positions without a price count as 0.
Prerequisites
- The owner of the wines has been created in Finaure as an entity.
- For the import: your wine list is available as an Excel (.xlsx, .xls), CSV or TSV file, one file per import. At least one column contains the name of the wine.
Step-by-step guide
- Open Assets and click Add Asset.
- Choose the Wine category. The “Wine collection” dialogue opens.
- Under Owner, choose the person or company that owns the wines.
- Choose how you want to start: I have a list for an Excel or CSV list in any format (continue with “Import wine list”) or Enter individual wines for a few bottles or one or two cases (continue with “Single wine”).
- Drag your file into the “Drop files here or click” field, or click into it and choose the file. Alternatively, start via SmartUpload → Wine list tile → entity → Next.
- Click Analyze (1). The “Import wine list” dialogue opens.
- Step 1 of 3: Under “How Finaure reads your list”, check the first wines. Answer any follow-up questions, for example “1 rows have no vintage. What does that mean?” with “The information is missing, check later” or “These are non-vintage wines”. If everything is clear, you see “Everything is clear, no questions.”
- Open Check and correct columns and click the worksheet. Check the target field of each column. If one does not fit, choose a different target field or “— do not import —” and click Reapply.
- Click Next. Finaure recognises the individual wines (“Recognising wines: … of …”).
- Step 2 of 3: Wines that were not recognised are marked “Not recognised”. Click Keep as is if an entry is correct. Open wines as Excel downloads the open rows. Rest later lets you continue without settling everything now.
- Step 3 of 3: Check the Owner. Under Collection, choose an existing collection or “Create new collection” and enter a name, for example “Wine collection Katharina Reinholt”.
- Under Where are the … positions without a location?, assign a storage location. If your list contains its own storage locations, choose an existing location or “Create new” for each one under “Locations from the list”.
- Check the totals (Positions, Bottles, Purchase value, To review) and click Save.
- Finaure confirms the import, for example “Saved: 17 new, 0 changed, 0 removed”. Click Go to collection.
- In the “Wine collection” dialogue, choose Enter individual wines, or click Add wine at the top right of the wine cockpit.
- In the “Add wine” form, fill in at least Wine and Number of bottles.
- Add the producer, vintage (or “Non-vintage”), format, type, packaging, storage location, region, country, purchase price per bottle, purchase date, own price and a note as needed.
- Click Save.
At the top of the cockpit you see the current value, purchase value, bottles and positions. Below them are the tabs Overview, Positions, Locations, Movements, Valuation and Documents.
Record a movement
- Open the Positions tab.
- Click the Record movement icon (⇄) next to the position.
- Under What happened?, choose Added, Drunk, Sold, Given away or Moved.
- Enter the number of bottles, the date and, if required, a note. For “Moved”, also choose the New location.
- Click Save. You can see all movements in the Movements tab.
Set your own price
- Click Edit wine (pencil icon) next to the position.
- Under Own price per bottle (EUR), enter your price and click Save.
Set a discount
- Open the Valuation tab.
- Under Discount on the collection value (%), enter a value, for example 10, and click Save.
- The current value is reduced by the discount. Below it you see “Value before discount” and the value history.
Other tabs
- Overview: stock by storage location and by region, with a notice about open positions
- Locations: bottles and value per storage location
- Documents: opens the documents page, filtered to the collection
- In the wine cockpit, click List via SmartUpload and upload the updated list.
- Step 1 of 3: Under “Check and correct columns” you see “Profile (no AI)”. Finaure uses your saved mapping.
- Step 2 of 3: Settle any open wines or click Rest later.
- Step 3 of 3: The existing collection is preselected. Choose the same storage location as for the first import.
- Check the Comparison with stock line, for example “0 new, 2 changed, 15 unchanged, 2 no longer listed”.
- For each wine that is no longer on the list, choose Keep, Drunk, Sold or Given away.
- Click Save. If the comparison does not look right, close the dialogue without saving.
Finaure remembers a corrected mapping. The next time you upload the same format, you see “Profile (no AI)” and do not need to set anything up again.
Fields in the column mapping
| Target field | Meaning |
|---|---|
wein_bezeichnung | Full name of the wine. Either this field or, with separate columns, wein is required; it must be filled in for at least 90% of rows |
erzeuger | Winery or producer |
wein | Name of the wine without the producer |
region / land | Wine region and country |
art | Type of wine, for example red, white, sparkling |
jahrgang | Vintage |
format | Bottle size, for example 0.75, 75 cl or Magnum |
menge | Quantity in bottles or cases; if this is unclear, Finaure asks |
gebinde | Packaging, for example case |
einkaufspreis | Purchase price per bottle, per case or for the row; if this is unclear, Finaure asks |
gesamtpreis | Price for all bottles in the position |
waehrung | Currency |
kaufdatum | Purchase date |
lagerort | Place where the wine is stored |
notizen | Free text, for example remarks |
| — do not import — | The column is ignored |
Frequently asked questions
Can I create several collections?
Yes. Each collection belongs to one owner. An owner can have several collections, for example one per house or cellar.
Which file formats can I upload?
Excel (.xlsx, .xls), CSV and TSV. Column names and order do not matter: Finaure maps the columns itself. You upload one file per import.
Do I have to answer all follow-up questions straight away?
No. The follow-up questions in step 1 are pre-filled. In step 2, you skip open wines with “Rest later” and then save the import in step 3. Open wines remain visible and marked in the collection until you review them.
What is “Open wines as Excel” for?
You receive an Excel file with the wines that Finaure has not yet recognised with certainty. These wines remain marked in the collection until you review them.
What is the difference between my own price and the discount?
Your own price applies to one position and takes priority over any other price. It is never overwritten automatically. The discount applies to the whole collection and reduces its value by a fixed percentage.
What happens if I upload the same list again?
If you choose the existing collection in step 3, Finaure does not create duplicate wines and shows the comparison: new, changed, unchanged and no longer listed.
How is the value of my collection calculated?
Finaure uses your own price, otherwise the purchase price. Positions without a price count as 0. A discount reduces the total value. Market prices for wine are planned.
Next step: record other assets such as real estate, art or portfolios under Creating assets.