Connect your Visma e-conomic account to import actuals into Francis. You can connect multiple accounts if you operate across several companies. Once connected, your chart of accounts is available in the Mappings view, where you map e-conomic accounts to line items in your model.
Connect Visma e-conomic
Go to Settings > Integrations > Visma e-conomic > Connect. A prompt will appear asking you to authorize Francis as an application in your Visma e-conomic account. This requires Admin rights.
Before you begin, open the e-conomic company you want to connect in a separate tab and make sure you’re signed in to it. The connect flow uses whichever account is signed in, so having the right one open keeps it on track. Signing in or switching accounts during the flow can break it. To connect multiple companies, do them one at a time, switching to the right account in the separate tab before each.
What Francis sources
Francis pulls the following data from e-conomic:
- Posted journal entries (bogførte posteringer): amount, date, and description
- Optional: Draft entries (kassekladder): amount, date, and description
- GL accounts
- Dimension tags, available for breakdowns within Francis
Adjustments
Francis automatically adjusts imported data in three ways. All three rely on the asset range and retained earnings configuration, so it’s important that these are set correctly to ensure correct numbers.
Number convention
Balance sheet
Retained earnings
Francis flips the sign for income, expenses, liabilities, and equity accounts to follow the Francis sign convention:
- Positive (+): Income (I), Asset (A), Liability (L), and Equity (EQ)
- Negative (-): Expense (EX)
Francis presents balance sheet values as accumulated amounts at a point in time, not as period movements. Imported data is adjusted on the way in to match this convention.For this reason, in Francis, summarize balance sheet items using ENDING instead of SUM.
Throughout the fiscal year, e-conomic holds net profit in a system-generated “Retained earnings current year” account that isn’t exposed via the API. To capture this, Francis recreates it as a synthetic account named “Periodens resultat efter skat”.When you close a fiscal year, e-conomic moves retained earnings from the “Retained earnings current year” account to a “Retained earnings from previous years” account. Francis mirrors this movement and offsets it from the synthetic account.
Settings to enable adjustments
Francis relies on two user-set settings to make the adjustments.
Asset range
You must specify your asset range in Francis. Set asset_range_start and asset_range_end. If your chart of accounts matches the default e-conomic template, Francis picks up the values automatically.
The default asset range for Visma e-conomic is 5000 to 5990. Francis may prompt you to confirm even if your chart follows this default.
Retained earnings
You must also set your retained earnings from previous years. If your chart of accounts matches the default e-conomic template, Francis picks up the value automatically.
In most cases this is account 6130 “Retained earnings last year”. To verify in e-conomic, go to Regnskab > Systemkonti > Årsafslutning.
