Investments & Debt - Current Solutions & Workarounds
Google Sheets
- What it is: Spreadsheet for manual investment tracking
- How they use it: Track all investments with columns for bank, type, currency, principal, duration, start/end dates, rates, credit ratings
- Limitations: Manual upkeep, error-prone, no automation, screenshot into PowerPoint for reporting
- Used by: Personio
Bank Websites
- What it is: Each bank publishes credit ratings on their website
- How they use it: Manually check each bank's site to gather credit ratings
- Limitations: Different terminology per bank (secured/unsecured, short-term/long-term), time-consuming, no alerts
- Used by: Personio
AI Agents (Experimental)
- What it is: Custom AI agent for scraping credit ratings
- How they use it: Attempted automation of credit rating gathering
- Limitations: "Works once and then it's not working again" - unreliable
- Used by: Personio
Bloomberg (Not Used)
- What it is: Industry-standard financial data terminal
- Why not used: Too expensive, not in budget
- Mentioned by: Personio
Excel (Debt Management)
- What it is: Spreadsheets for debt tracking and accrual calculations
- How they use it: Calculate monthly accruals, track maturities, generate reports for accounting/cash flow/FNA
- Limitations: Formula errors, manual rate updates, multiple spreadsheets for different views
- Used by: Avramar
- What it is: Bank-provided platform for factoring visibility
- How they use it: See total factored amounts
- Limitations: No client-level breakdown, can't see financing status per client
- Used by: Avramar
Bank APIs (Cash Management)
- What it is: Direct API connections with banks
- How they use it: Automated bank statement imports for cash management
- Limitations: Debt data not available via API, factoring details limited
- Used by: Avramar (Eurobank)
Manual Workarounds
Spreadsheet-Based Investment Tracking
- What they do: Maintain detailed G-sheet with all investments, rates, maturities, credit ratings
- Why: No integrated tool provides this tracking
- Source: Personio (2025-10-21)
Monthly Credit Rating Updates
- What they do: Manually update credit ratings on a monthly basis (ideal would be daily)
- Why: Can't automate reliably, too time-consuming for daily updates
- Source: Personio (2025-10-21)
Manual Accrual Calculations (Debt)
- What they do: Calculate monthly accruals in Excel with floating rate formulas, penalty calculations, withholding tax splits
- Why: No system handles complex debt with multiple tranches, rate changes, penalties
- Source: Avramar (2025-07-09)
Multiple Report Generation
- What they do: Transform same debt data into different formats for accounting, cash flow, and FNA reporting
- Why: Each stakeholder needs different view; "three different figures that we need to put in the system"
- Source: Avramar (2025-07-09)