Sign in to get started
Connect to the Corvenia API to sync financial data into this workbook.
Open the workbook to check for Raw_* tables.
Company, year, and report options follow the Lite tab (switch to Lite to change them). Click Get latest data here or there before your first prompt if this file has no Raw_* data yet.
Sends Raw_* table names, columns, row counts, and sample rows to your API; the add-in builds the plan on a new sheet. No arbitrary code execution.
Refresh reports — Updates P&L, trial balance, and other sheets using numbers already stored in this workbook. Quick; no download.
Get latest data — Downloads fresh trial balances and account data from Corvenia, then updates your sheets. Use when data may have changed in the system.
1. Setup Workbook — companies, master chart, mappings, and trial balance (essential data).
2. Download reference data (optional) — currencies, exchange rates, ownership, eliminations.
3. Open _Config — set Sync Scope (what re-download pulls), Reports to build, then ⟳ Sync Data to refresh Rpt_* sheets.
Do this in order: (1) On _Config, choose Sync Scope and companies → (2) Re-download Raw Data here (uses that scope) → (3) On _Config, click ⟳ Sync Data to rebuild reports from Raw_*. While syncing, Status on _Config (F11) turns amber with the current step.
Open the workbook to load scope from _Config.
- Essential (setup): Raw_Parties, Raw_TrialBalance, Raw_MasterAccounts + Raw_AccountMappings
- Optional: Raw_Currencies, Raw_ExchangeRates, Raw_Ownership, Raw_Eliminations
Your pivots, formulas and reports are never overwritten. Only Raw_* table data is replaced on each sync.
- Click Setup Workbook, then use Download reference data if you need currency lists.
- On _Config: use the drop-down arrows (▼) — hover cells for tips. Reports to build controls P&L / Balance Sheet / Cash Flow.
- Go to Raw_TrialBalance sheet → Insert → PivotTable.