Family Office ERP

Overview Transactions Treasury Statements

Bulk Import Transactions

Drop a CSV from the old system. Each row becomes a transaction; the journal-entry trigger fires per row, balances + statements update automatically.

📂

Drop CSV here or click to select

Headers required: date, type, subtype, account, amount, currency. Optional: asset, description, fx_rate, employee, attachment_url.

CSV format

date,type,subtype,asset,account,amount,currency,description,fx_rate,employee
2024-03-15,Real Estate Purchase,Purchase of Property,Mall of Berlin,SNB - USD,5000000,USD,Initial acquisition,3.75,
2024-06-01,Rental Income,Rental Income,Headquarter,SNB - SAR,250000,SAR,Q2 rental,,
2024-09-20,Investment,Capital Call Payment,ARP,Sparkle Bank,1000000,USD,Q3 cap call,3.75,

Names (type, subtype, asset, account, employee) match the existing records — case-insensitive but spelling must match.
Currency: SAR / USD / AED / GBP / EUR / TRY / EGP / CHF. fx_rate is optional and auto-fills from the peg if missing.
Amount uses commas as thousands separator OK; decimals with period only.
Rows with errors are flagged in preview — you can import only the clean rows.