RentCockpit — User Manual

Last update: — Tip: use the search box or Ctrl+F.

🚀 Quick start with RentCockpit

Follow these steps the first time you use it. This way RentCockpit can recognize payments automatically and you save manual work.

  1. Create your first company
    Go to Master data → Companies and add your company.
    👉 Enter the IBAN and link (if applicable) your bank account to this company. RentCockpit uses this IBAN to recognize incoming and outgoing payments.
    Optional: per account, set the import scope (All or Rent only).
  2. Import a CSV file from your bank
    Open 📥 Import payments, choose the account and configure the CSV template (date, amount, counterparty IBAN/name…).
    First view a Preview, then run the import.
    RentCockpit automatically links known counterparties via IBAN. Unknown counterparties are created as contacts (with their IBAN) and are ready to be linked—once you connect a building and lease—to the correct lease automatically.
  3. Create buildings and leases
    For each company, add at least one Building or Unit (Master data → Buildings).
    Then create your Lease under Operations → Leases, linked to a contact and a building.
  4. Link rent payments with one click
    Open the 📬 Payments Inbox and click Process rent payments at the top.
    RentCockpit finds INCOMING payments without allocation and links them based on IBAN → contact → lease.
    You’ll first see an overview (preview). After confirmation, the payments are linked and the type is set to LEASE where needed.
  5. Handle exceptions
    For payments without a match:
    • Add the contact under Master data → Contacts and register their IBAN, or
    • Link manually via the Process ▾ menu (Lease / Cost / Invoice),
    • then click Process rent payments again to auto-link remaining payments.
  6. Enable rules for recurring payments
    From the Inbox you can set up Rules for rent, utilities or recurring costs. Next month, RentCockpit recognizes the same payments automatically.
  7. Review your results
    Open the Dashboard or Rent payments (grid) for an overview of income, rent payments and open balances.
💡 Summary: the first time, importing rent money happens in two steps: (1) you import your bank CSV and link buildings/tenants/IBANs where needed, (2) you process the payments (e.g. via Process rent payments). Once buildings and tenants are recognized based on IBAN during import, future payments are automatically linked and processed for the correct lease.
⬆️ Back to contents

📬 Payments Inbox

This is where you process imported bank payments. By default the Status is NEW — payments that haven’t been handled yet (no lease/cost/invoice link yet).

🚀 Fastest way to start

  1. Double-click a row → a Cost is created immediately and the detail opens. Optionally add an invoice there.
  2. Right-click (or Process ▾) on a row for all actions: Split & allocate, Link (Lease/Cost/Invoice/Credit note/Investment/Loan), Status, etc.
  3. Done? Set the payment to PROCESSED. It disappears from NEW.

What you see in the overview

  • Type badges: Lease, Cost, Invoice. The document icon next to Cost shows whether a document is attached.
  • Remaining: total minus allocated. If this is > 0, the payment isn’t fully allocated yet.
  • Allocation count: the number next to a badge shows how many lines there are (e.g. “2” = split across 2 items).
  • Allocation icon (🧩) → open Split & allocate… to view/edit lines.

Filters, keywords and export

  • At the top you can filter by Company, Period, Direction (IN/OUT), Status and free search (comment/booking/keywords).
  • Adding keywords to a payment helps you find it instantly later.
  • Use filters + keywords to build the exact selection you then export to Excel.
  • You can save frequently used combinations as a “Saved view”.

🧩 Split & Allocations

Split a payment across multiple targets (e.g. two buildings or partly lease/partly cost).

  • Incoming (rent): link to a Lease or an Invoice. Refunds? Use a credit cost.
  • Outgoing: link to an existing Cost or create a new cost.
  • You always see Total, already allocated, and Remaining update live.

🔍 Show/hide sidebar

  • With the Panel button you show the left column (Buildings/Contacts/Costs).
  • Drag & drop: drag a payment onto a building/contact/cost to link quickly.
  • Your choice (visible/hidden) is remembered locally per device.

⚙️ Apply rules

  • Select your Company at the top → the associated rules become active.
  • Create rule based on this payment… for recurring patterns (fixed rent amount, utilities, …).
  • First Preview, then Apply within the current filters. Many NEW payments are processed automatically. See also Rules.

🔌 Utilities (gas, water, electricity)

Link a utility to a payment so it flows neatly into your provisions/settlements. When splitting, you can mark a line as a utility.

Tip – first import: Make sure your company has its own IBAN and first import a CSV via Import payments. RentCockpit recognizes tenants based on IBAN + name. Afterwards, rent payments are automatically linked to Leases in the Inbox.
Good to know: when you return to the Inbox later, the page remembers where you were (filters, selection, scroll), so you can continue immediately.
⬆️ Back to contents

🧩 Split & Allocations

Split payments into lines and allocate amounts to Rent (Lease), Cost or Invoice.

An allocation is assigning (part of) a payment to a concrete target: for example a lease, a cost, or an invoice. The original payment always remains — it is never deleted or overwritten.

What does allocating mean?

Every payment you import is a fixed fact. You can split that payment into one or more allocations — think of puzzle pieces that together exactly match the payment amount.

  • An allocation can be linked to a Cost (outgoing, e.g. maintenance).
  • An allocation can be linked to an Invoice or Credit note (incoming).
  • An allocation can be linked to a Lease (rental contract, incoming).

For example, one payment can be €800 rent (Lease) + €200 costs (Cost), together €1,000. Both parts are tracked separately, but remain linked to the same payment.

How does Split & Allocate work?

  1. Double-click a payment to quickly turn it into a Cost (outgoing).
  2. Right-click a payment and choose Split & Allocate to break the amount down.
  3. In the split view you can:
    • add multiple lines;
    • link each part to a building, lease, invoice or cost;
    • set notes or categories per line.
  4. After saving, the lines appear in the Allocations column (with their target and amount).

Why is this important?

Thanks to the allocation system, RentCockpit can:

  • report accurately which part of a payment belongs to which cost, invoice or lease;
  • avoid double counting or incorrect postings;
  • automatically create the right links between payments and buildings;
  • keep all payments historically, even if you change links later.

Credit situations: allocate to the credit note first, then link any remaining difference to the invoice.

FAQ & Tips

  • Can I delete a payment? No, payments are always preserved. You can only adjust or remove allocations.
  • What if a payment spans multiple buildings? Use Split & Allocate to divide the amount and link each part to the correct building or contract.
  • What happens if I delete an invoice or cost? The allocation disappears, but the payment itself remains in the Inbox.
  • Can I allocate negative amounts (refunds)? Yes, RentCockpit also supports incoming or outgoing refunds via negative lines or credit notes.
⬆️ Back to contents

💸 Costs

In the cost detail you manage supplier, invoice data, an optional building link, a document (PDF) and the allocations coming from payments. This screen opens as an overlay and works together with the 📬 Payments Inbox.

1) Supplier & VAT

  • The linked supplier is shown at the top.
  • Enter or correct the VAT number (format recognizes BE0123456789 and automatically adds BE for 10 digits).
  • With Save VAT, the number is saved directly on the supplier contact.

No supplier linked? Then a message appears. You can link later (e.g. after creating the cost from the Inbox).

2) Basic details

  • Invoice number and Invoice date.
  • Building (optional): choose “— No building (general) —” if the cost doesn’t belong to one building.
  • Category (e.g. SERVICE_CHARGE, MAINTENANCE, …).
  • Recoverable cost (tick if this should be included in settlements).
  • Comment (internal notes).

At the bottom you see Amount, Allocated and Open. These are updated live by allocations from payments.

3) Invoice document (PDF)

  • Drag a file onto 📎 Drag file here, or click to choose.
  • After upload, the documentUrl is stored and you’ll see Open invoice.
  • The Payments Inbox sees this immediately (lightweight refresh on the affected rows).

Prefer PDF. Other formats are only stored and opened in a new tab.

4) Allocations (payments → cost)

Under Allocations you see all payments that are (partly) allocated to this cost.

  • Per allocation: payment ID, date, total amount, counterparty/description and the allocated amount.
  • You typically add allocations via the Split/Allocate action in the 📬 Inbox.
  • When you save here or upload a document, the Inbox is asked to refresh the relevant rows.

5) Working from the Payments Inbox

  • Double-click an OUTGOING payment ⇒ creates a (new) cost and opens this screen.
  • Right-click ⇒ use Split & allocate… to book amounts to this cost (multiple payments or partial sums).
  • After Save or Upload, the inbox automatically refreshes the relevant rows (document icon, amounts, status).

FAQ & Tips

  • VAT number shows a warning — The field normalizes automatically. Check country code + digits and click Save VAT.
  • Cost without building — Choose “— No building (general) —” for overhead. If needed, untick Recoverable.
  • Document doesn’t open — Check whether your browser allows pop-ups and whether the documentUrl is a valid (intranet/desktop) path or web URL.
  • Open/Allocated is incorrect — Reload the Inbox or reopen the Split dialog; allocations on other payments also count.
  • Accounting/export — During export, documentUrl is included so the accountant can retrieve documents.
⬆️ Back to contents

🧾 Invoices & Credit Notes

Create sales invoices and credit notes, with multiple lines, VAT, and automatic matching with payments.

Overview & filters

  • Filter by type (Invoice / Credit note / All), company, status and search (number, customer, comment).
  • The list shows per document: date, due date, status, total and open amount.
  • Click a row to view details; use Print to open a PDF.

Create a new invoice

  1. Choose Company and Customer (optionally also link a Lease).
  2. Enter Invoice number (or leave empty: numbering via server), Date, Due date and Currency.
  3. Add lines: description, unit, quantities, net price, discount, VAT% and VAT code.
    Tip: choose “+ line from product” to auto-fill standard prices/VAT.
  4. (Optional) Enter a Structured communication (+++xxx/xxxx/xxxxx+++). This improves automatic matching in the Payments Inbox.
  5. Click Save. The document appears in the list with status DRAFT or SENT (depending on your backend logic).

Create a credit note

  • Choose New credit note (type: CREDIT_NOTE).
  • (Recommended) Reference the original invoice (field originalInvoiceId) so reporting and matching stay clear.
  • Lines with negative quantities or amounts are not required; the credit note itself is already a negative document.
  • Due date/structured communication are typically ignored for credit notes.

Status & payments

  • The Open field shows the remaining unpaid balance (total − received allocations).
  • Matching happens in the 📬 Payments Inbox via allocations:
    • You can allocate incoming payments (partly) to an invoice.
    • Credit notes reduce the open balance; if you refund, link the outgoing payment to that credit note.
    • Structured communication (or amount + customer/iban) helps you quickly find the right invoice.
  • Typical statuses: DRAFTSENTPARTIALLY_PAIDPAID (or CANCELLED).

Common scenarios

  • Partial payment: allocate only part of the amount in the Inbox; the invoice becomes PARTIALLY_PAID with an open balance.
  • Overpaid: create a credit note or keep the surplus as an advance and settle it on the next invoice.
  • Wrong VAT rate: correct with a credit note on the incorrect invoice and then create the correct invoice.

FAQ & Tips

  • Do I always need to link a Lease? No. Lease is optional; it helps when invoices are consistently per rental contract.
  • How do I link payments? In the Payments Inbox (right-click or double-click → Split & Allocate) you link (parts of) payments to invoices/credit notes.
  • Structured communication improves matching on import. If your bank export includes this field, map it in the CSV template.
  • Print/PDF: with 🖨️ Print you instantly get a clean print/PDF of the document.
⬆️ Back to contents

📃 Lease agreements (Leases)

On this page you link a contact to a building/unit, set the start date and base rent, manage provisions and create settlements.

1) New or edit

  • Contact → tenant.
  • Building / Unit → location/space of the lease.
  • Start date → determines the indexation anniversary.
  • Base rent → monthly amount before indexation.
  • Indexation active → rent follows index values automatically.

Current rent = base × (new index / base index) + active provision. If there is an override in the selected month, the override wins.

2) Search & sort

  • On the left you can search by contact, building or ID.
  • Tick “Sort by buildings” to group by city/street/name (preference is stored locally).
  • In the list you always see current rent incl. provision and (if set) the share %.

3) Share in other costs (m² key)

For units in a complex, RentCockpit automatically calculates the share (%) for common/recoverable costs: unit m² / total m² of complex. This share is used later in settlements.

Areas are managed on the buildings page. Recalculate via Recalculate.

4) Rent periods (Overrides)

  • Define a temporary different rent for a period (e.g. agreed discount or increase).
  • An override always wins over base/indexation as long as the date falls within the period.
  • Multiple periods are possible; edit and delete inline.

5) Provisions

  • Add one or more provision periods (amount per month).
  • Leave the end date empty for an ongoing provision.
  • Provisions count in current rent and in the settlement (expected vs. actual).
  • One-off corrections can be entered as a short period or a negative provision.

In the final settlement, a shortage is automatically incorporated (offset or refunded — see below).

6) 🧾 Generate settlement

Click 🧾 Settlement (top right) to choose a period and generate a letter for the tenant.

  1. Choose from / to (month). The UI helps you start from the previous settlement or lease start.
  2. Optional: Mark as settled — the result is recorded in the administration.
  3. If there is a credit:
    • Offset with rent (recommended if there is arrears) — applied automatically to rent arrears.
    • Refund — show the refund in the letter.
  4. Review the preview (total costs, expected advance, balance S). The recommended choice is shown.
  5. Click Print → letter opens printer-friendly with amounts and instructions (IBAN/BIC, communication).

If you tick “Mark as settled”, the system logs the choice (offset/refund) and may apply (part of) the credit to outstanding rent.

7) How amounts are calculated

  • Current rent = base × index factor (on anniversary) + active provision.
  • Override in the month? Then override + provision applies.
  • Settlement balance (S) = actual costsexpected/paid advances.
  • If credit (S < 0): offset against rent debt (APPLY) or paid out (REFUND).
Tip: You can always return to the inbox via “← Back to payments” when you jumped from a payment to the lease.

FAQ & Tips

  • Ongoing provision: leave end-date empty. Temporary correction? Create a short negative or positive provision period.
  • Indexation “base index”: comes from the index values before start (month -1). Up-to-date index series are important for correct calculations.
  • Share % missing: set m² on units in the complex and press Recalculate.
  • Settlement letter without address: fill in address details on the contact (tenant) or company.
⬆️ Back to contents

🗃️ Rent payments (grid)

This screen shows, per tenant/contract, a timeline of months with for each month Due vs. Paid, plus a summary of the open rent up to last month. From this overview you can also create arrears analysis & letters and drill down into payments per month.

Top toolbar

  • Contracts:
    • Current — only active leases (end date empty or in the future).
    • Ended — finished leases, useful to follow up old arrears.
    • All (window) — all leases that have movement/expectations within the selected window.
  • Window: choose how many months you want to see in the timeline
    (e.g. 12 months = the last 12 months up to last month, plus optionally the current month as an extra column).
  • Show “Total due” — toggles the column Due (up to last month) on/off.
  • Show “Total paid” — toggles the column Paid (up to last month) on/off.
  • Show “Due” per month — shows/hides the month columns Due. Useful if you temporarily only want to see paid amounts.
  • Too little paid red from — threshold in € above which a shortfall in a month is marked red (e.g. 50 = only mark if at least €50 too little was paid).
  • Too much paid green from — threshold in € above which an overpayment is marked green.

The selected settings (window, columns, thresholds) only affect the display, not the calculations in the backend.

⬆️ Back to contents

🏢 Buildings

Manage complexes and units, link them to a company, and navigate quickly to Utilities and Return (ROI).

What you see (left column)

  • Grouped by city with per complex: # units, ∑ m² and ∑ value.
  • Expand/collapse per complex; this state is remembered per device.
  • Search by city, street, name or ID and/or Show only complexes.
  • Quick buttons per item: ✏️ Edit, 📈 ROI, 🔌 Utilities, 🗑 Delete.

No companies? You’ll see a message at the top with a button to create a company first.

New building

  1. Click + New and choose Type: UNIT or COMPLEX.
  2. Company (required) — a building always belongs to one company.
  3. Enter address, Purchase date and Value. For UNIT also enter Area (m²).
  4. (Optional) For UNIT: choose Under complex. The company then follows automatically from the complex.
  5. Click Add.

Purchase date + value are later used for indexation/analysis; the area is important for allocation keys (m²) in settlements.

Link complex ↔ units

  • For a COMPLEX you see two lists: Available (left) and Linked (right).
  • Double-click left to add a free unit, double-click right to remove.
  • Only units of the same company appear on the left; units already linked to this complex remain selectable.
  • Click Save to store the new set of links.

Working with existing buildings (right panel)

  • Edit: change fields and click Save.
  • Navigate: via buttons to 🔌 Utilities (readings/consumption) and 📈 ROI (return per complex or unit).
  • Delete: asks for confirmation. Not possible if there are dependencies (depending on backend rules).

FAQ & Tips

  • Unit without complex? Leave Under complex as “— none —”. You can link later.
  • Forgot company? The save button stays disabled. Choose a company first (or create one).
  • m² and settlements — The Area of units is used to calculate the tenant’s share (%) for recoverable costs.
  • ROI — Start from a complex or unit to immediately see the correct return view.
  • Normalize addresses — Consistent street/postcode/city keeps groups tidy and filtering fast.
Next: Read the next chapter 📈 Return (ROI) for analyses on complexes and units.
⬆️ Back to contents
7

📈 Return (ROI)

See per building, at a glance, your income, costs and net return. Choose a month-to-month period; amounts are automatically annualized so percentages are comparable.

What do the KPIs show?

  • Income (excl. provisions) — Ideal base rent for the selected period (and “actual” = truly received).
  • Operating costs — recurring costs (OPEX). “All” shows OPEX + investments/one-off costs.
  • Net income — income − costs (without/with one-off costs).
  • Current value — the current value of the building (basis for yield).
  • Net yield — Net (annualized) ÷ current value, as % (without/with one-off costs).
  • Provisions & Recoverables — compare your expected provisions with recoverable costs. The difference shows whether advances were sufficient.

The period is annualized: 6 months ⇒ ×2; 12 months ⇒ ×1. This makes returns fairly comparable.

Choose a period

  1. Select From (YYYY-MM) and To (YYYY-MM).
  2. Click Apply. KPIs and tables recalculate automatically.

“From” may not be after “To”; the period includes both months.

Cost tables

  • Operating costs — recurring (OPEX) + separately marked one-off items.
  • Recoverable costs — costs that are passed on to tenants via settlement/provisions.
  • Columns: date, direction (IN/OUT), category, amount, supplier, Recoverable, One-off.

A Recoverable toggle works only on a cost (not on a standalone payment). First link a payment to a cost via the 📬 Payments Inbox.

How is the return calculated?

  • Net excl. one-off = Income − OPEX (period total, then annualized).
  • Net incl. all = Income − (OPEX + one-off) (same).
  • Net yield = Net (annualized) ÷ Current value × 100%.

One-off items (e.g. renovations) reduce the return in the year of the expense, but give a more realistic picture of cash-out.

Auto-linking: via 📬 Payments Inbox and ⚙️ Rules costs and invoices are automatically linked to buildings, so ROI stays up to date without extra work.
⬆️ Back to contents

🔌 Utilities & Consumption

Manage your water/gas/electricity/… meter(s) per building (or unit) and record readings. Consumption feeds your provisions and later settlement.

How does it work?

  1. Create a meter (type, unit, optional label/serial). Tick Main meter for the building’s main meter.
  2. Then add meter readings: date + value. Your history appears per meter.
  3. Choose a period at the top and click 📈 Calculate consumption (per meter or “for all” meters).

The calculation takes into account RESET (meter goes to zero) and REPLACED (meter replaced). Consumption segments show where a “break” occurred.

Fields & meaning

  • Type — WATER, GAS, ELECTRICITY, HEATING, OTHER.
  • Unit — e.g. m³ or kWh (shown everywhere with consumption).
  • Event on a reading:
    • NORMAL — regular reading.
    • RESET — meter jumps to 0 (e.g. counter reset).
    • REPLACED — meter replaced; segmentation prevents incorrect negative consumption.

Link with Inbox & provisions

  • Utility invoices from the 📬 Payments Inbox are linked to building/unit via rules and allocations.
  • Meter consumption supports your provision settings and final settlement (see Leases).
  • In ROI you see the impact of utilities on OPEX and recoverable costs.

FAQ & Tips

  • Enter today? Use the Today button when adding a “New reading”.
  • Negative consumption? Check whether a RESET/REPLACED event is missing or a date is wrong.
  • Main meter vs. submeter — label submeter(s) clearly (e.g. “Unit 1”).
⬆️ Back to contents

📥 Import payments (CSV)

Import CSV files from your bank to process all transactions in the Payments Inbox. The first time you set up a template per account; after that it’s almost automatic.

Before you start

  • Bank export: download a CSV from your bank.
    Some banks only provide Excel (XLS/XLSX) → open it in Excel/LibreOffice and Save as CSV (UTF-8).
  • Select account: choose the account linked to your company whose CSV you’re importing.
  • Our IBAN: in the template, set your own IBAN (column or fixed) so direction/counterparty are interpreted correctly.

Tip — Per account, RentCockpit remembers your CSV template and the import scope (All / Rent only).

What happens on the first import?

The first time you import for an account, an discovery scan runs: we extract IBANs and names from the CSV and automatically create/link Contacts (tenants).

  • Then the import pauses: first process the candidates (create/link/skip).
  • From then on, RentCockpit recognizes your tenants automatically on the next imports (IBAN match).

Important — Do this per company/account once before importing lots of historical CSVs.

Step-by-step

  1. Choose account (top) and optionally set Import scope: All or Rent only.
  2. Select file (CSV) or paste the contents into the text box.
  3. Click Scan headers → column names are detected.
  4. Map fields in the Template editor:
    • Date, Amount, Counterparty IBAN, Counterparty name, Description, Our IBAN (column or fixed value).
    • Direction: “from amount sign” or “from column” (fill Credit/Debit values).
    • Number format: decimal/thousand separators, and “negative as (…)” if your bank exports that way.
    • Unique key column (recommended) for de-dupe (e.g. endToEndId or bookingRef, if present).
  5. Click Save template (per account).
  6. Optional: enable Avoid duplicates and choose “Rent only (one-time)” for a quick rent run.
  7. Click Preview → verify counts and errors.
  8. First time? Process the Discovery scan candidates (create/link tenants). Then you can import for real.
  9. Click Import → transactions appear in the Inbox and tenant recognition happens automatically via IBAN.

Template fields (overview)

  • Delimiter: usually “;” or “,”.
  • Date: choose column + provide preferred formats (e.g. DD/MM/YYYY & YYYY-MM-DD).
  • Amount: ensure decimal/thousands are correct; tick “negative as (…)” if needed.
  • Direction:
    • fromAmountSign → positive/negative amount.
    • column → choose direction column + list of values for Credit/Debit (e.g. C/CR/CREDIT and D/DR/DEBIT).
  • Counterparty IBAN / name: helps matching & contact detection.
  • Our IBAN: via column or fixed value (recommended) for correct interpretation.
  • Unique key (column + “required”): maximizes de-dupe on source ID.
  • Extra columns (optional): endToEndId, bookingRef, currency, buildingId.

Special modes

  • Import scope per account: “All” or “Rent only (LEASE_ONLY)”. This is the default setting for this account.
  • “Rent only (one-time)”: temporary override for a run (without changing the default).
  • Auto-add unknowns: immediately creates contacts during preview/import (without manual “discovery scan”).
  • Advanced (JSON): save/share your template as JSON text; Load into form to edit visually.

Unknown counterparties

If an IBAN/name isn’t linked to a contact yet and auto-add is off, a list of unknowns appears. Per row you can:

  • Link to an existing contact (suggestion shown if matched).
  • Create a new contact (enter a name or accept the suggestion).
  • Bulk: select multiple, “Process selected”.

After processing, rows with the same IBAN disappear automatically. “Import” remains blocked as long as unknowns exist (unless auto-create is enabled).

Preview & Import

  • Preview shows record count, detection errors and unknowns. Adjust your template if needed and try again.
  • Import writes transactions. Recognized tenants are linked automatically via IBAN (from the second time onward).

Common issues

  • CSV with strange characters: save as UTF-8.
  • Commas & dots: set Decimal/Thousands correctly; use “negative as (…)” if your bank writes (123,45).
  • Direction is wrong: choose “From column” and fill Credit/Debit values (e.g. CR/DR).
  • Duplicates: enable de-dupe and use a Unique key column (endToEndId/bookingRef).
  • No tenant match: run the discovery scan first and create/link contacts based on IBAN.
⬆️ Back to contents

⚙️ Rules (Auto-linking)

Create rules based on real payments, test with Preview, and apply them within your current selection.

What do rules do?

Rules recognize recurring patterns in bank payments (e.g. supplier, IBAN, amount, or text in the description) and automatically link to the right target: Lease, Cost, Invoice/Credit note, Utility, Loan or Investment. They can also set fields/flags such as Recoverable cost, One-off cost, Category, Building or Keywords.

Rules work within your current filters/scope in the 📬 Payments Inbox (company, period, direction, status, search…).

Create a rule (from a payment)

  1. Open the 📬 Payments Inbox and right-click a representative payment (or use the Process ▾ menu).
  2. Choose Create rule based on this payment…. The screen pre-fills useful match criteria (e.g. IBAN, supplier, part of the description, direction, amount).
  3. Configure the actions (link to Lease/Cost/Invoice/Credit note/Utility/Loan/Investment, building, category, recoverable, one-off, keywords, status…).
  4. Click Preview to see which payments are hit and what changes exactly.
  5. Happy? Click Apply to commit the changes within your current scope.

Match criteria (when does the rule trigger?)

  • Amount — exact amount or (if provided) a margin/range.
  • Counterparty — name contains/matches; IBAN exact.
  • Text fields — search in description/communication/comment (contains / starts with / ends with).
  • Direction — INCOMING (received) or OUTGOING (paid).
  • Company/Account — link to the correct company/IBAN.
  • Optional — currency, date window, keywords present/absent.

Tip: start narrow (e.g. exact IBAN + keyword) and broaden only after a successful preview.

Actions (what should happen?)

  • Link to — Lease, Cost, Invoice or Credit note, Utility, Loan, Investment.
  • Fields/flags — Category, Building, Recoverable cost, One-off, Status, Keywords.
  • “Overwrite existing fields” — if ticked, the rule may also change existing values:
    • Was a payment previously marked “Recoverable” but the rule turns it off? Then it is unticked.
    • Same for “One-off”, Category, Building, …

Use overwrite intentionally. Leave it off if you only want to fill empty/new fields.

Preview & Apply

  • Preview shows: number of hits, list of payments, and per rule what is changed (links/flags).
  • Apply applies it within your current filters/scope. You can also use this to correct already processed payments.
  • Unsure? First make a smaller selection (period/status) and test step by step.

Priority & conflicts

  • Rules have a priority/order. Higher priority (or earlier in the list) wins when multiple rules match.
  • Keep overlapping rules as specific as possible or use keywords to avoid collisions.

Examples

  • Rent — INCOMING + tenant IBAN + “RENT” in description → Link to Lease.
  • Electricity supplier — OUTGOING + name contains “Fluvius/Engie” → Cost, category “UTILITIES”, recoverable, building X.
  • Loan repayment — OUTGOING + amount ≈ 1,234.56 → Link to Loan, mark one-off=off (recurring opex).
  • Investment dividends — INCOMING + “DIVIDEND” → Link to Investment, keyword “dividend”.

FAQ & Tips

  • Undo — apply a rule again with “Overwrite existing fields” to correct wrong fields, or edit the payment manually.
  • No hits in Preview — broaden your criteria or check that your Inbox filters/scope aren’t too strict.
  • Too many hits — add an extra word (keyword) or an IBAN match and test Preview again.
  • Work step-by-step — start with 1 supplier or 1 IBAN, and build your rules library gradually.
⬆️ Back to contents

💼 Finance

Manage all your investments and loans in one place. Compare performance, record snapshots (valuations) and auto-link bank payments via Rules.

Navigation

  • Investments — list, detail, valuations and cash transactions (+ performance comparison between selected investments).
  • Loans — list, detail and loan transactions (drawdown, repayment, interest, fees, …).

Auto-linking

Accounts/payments that arrive in the 📬 Payments Inbox can be automatically linked to an investment or loan via ⚙️ Rules. This way they appear here immediately as Transactions or Fees/Interest.

⬆️ Back to contents