Finconsol help centre
Each article answers one question about setting up or using Finconsol. For the accounting behind consolidation, read the guides. For anything not covered here, write to the Finconsol team at info@aaxonix.com.
Getting started
Bringing in your companies
- Connect Zoho BooksWho signs in, what Finconsol reads from each organization, and how often.
- Connect XeroWho signs in to Xero, how organisations are added, and what Finconsol reads.
- Connect QuickBooks OnlineOne sign-in per company, what Finconsol reads, and what to do with QuickBooks Desktop.
- When figures refresh, and how to refresh nowThe nightly refresh, Refresh now during the day, and the monthly allowance.
- What a trial balance upload needsThe CSV columns, the opening month, the templates, and the checks on each file.
- Map each company's accounts to the group chartMapping once to the group chart, and what happens when a new account appears.
Consolidation
- How minority interest is worked out and recordedOwnership by month, the monthly share of profit, the approved journal and the statement lines.
- Which exchange rate is used for which figureClosing, average and historical rates, where the suggested rates come from, and typing over one.
- How the translation reserve appearsWhy the difference arises, where it is shown, and the outside shareholders' share of it.
- How intercompany eliminations are prepared and approvedHow pairs are compared, who drafts and approves the elimination, and what happens to a difference.
- Post a group adjustment journalJournal entries for the group, drafted by one person and approved by another.
- Report a holding company and its subsidiaries as a sub-groupA holding company with the companies it owns, and reporting groups for regions or divisions.
Month-end close and controls
Statistical accounts
- Add statistical accounts such as headcountSetting up a line, three ways to bring figures in, and how the group figure is worked out.
- Set up a statistic lineThe fields of a line, the choices that decide how it adds up, and archiving or deleting a line.
- Enter statistics in the gridThe two grid views, pasting from Excel, the flag on unusual figures, and closed months.
- Upload statistics from a CSV fileThe long and wide layouts, the template, the limits and the messages for refused rows.
- Send statistics from another system with a push keyCreating a key, the request and the reply, the daily allowance, and the ready-made scripts and guides.
- How statistics add up over time and for the groupSum or last month over a period, the three group figure rules, and missing figures.
- Add an industry packThe five packs, what each adds, adding one, and removing it again.
Custom reports
- Build a custom reportWhere to start, the kinds of row, the column choices and the exports.
- Start a report from a templateThe 3 standard statements, the 9 templates, a blank report, copying a report, and Customise on a standard statement.
- Add rows to a custom reportThe seven kinds of row, moving and indenting rows, hiding them, and accounts in no row.
- Add a calculation or a statistic rowThe six kinds of calculation, ready-made ratios, your own formula, and statistic rows.
- Choose the periods and columns of a reportPeriods and comparisons, the figures in each period, and arranging the columns.
- Save, publish and share a custom reportDrafts, the check before publishing, who can read a published report, and where they find it.
- Export a report to Excel, CSV or PDFWhat can be exported, the three formats, and how the file matches the screen.
Dashboards and KPIs
- Create a dashboardCreating, publishing, duplicating and deleting dashboards, the home page, and the limits.
- Add a component to a dashboardThe six kinds of component, their options, and arranging them on the page.
- Choose the figures a component showsThe groups of figures, the seven ratios, and the options for each measure.
- Write a formula for a KPIBuilding a KPI by clicking or typing, the extra functions, the format, and errors.
- Set the period and companies a dashboard showsThe period and scope filters, the comparison, and pinning a component.
- Export a dashboard or add it to a board packExporting the whole dashboard, downloading one component, and board packs.
See your group in one picture
The free trial runs for 15 days and needs no card. It includes all features and up to 2 companies. In a demo, we show you Finconsol on a group set up like yours, in 30 minutes.