Ga naar hoofdinhoud

Excel Template Files

Factview includes several Excel template files that can be used to import data into a dossier, such as General Ledger Accounts, transactions, and planning data.

The available templates are explained below.

Template Overview

This overview shows all available templates in Factview.

The numbers shown in this screen correspond to the descriptions below.

Templates for Master Data

1. General Ledger Accounts Template​

This template is used to import General Ledger Accounts and their descriptions into Factview.

It can also be used to add additional accounts, such as P accounts.

After the import, these accounts are added to the dossier and must still be mapped in the Report Structure.

2. Standard General Ledger Accounts Template​

This is the same template as above, but it is pre-filled with standard General Ledger Accounts.

It is intended for use with an empty dossier, providing a foundation for further processing, such as reporting and forecasting.

3. Structure Report Template​

This template is used to import Structure Reports.

It is a technical template that links General Ledger Accounts to structure groups.

In practice, this template is rarely used because it is generally easier to create report structures directly within Factview.

Templates for Transactions

4. Transaction Template​

This is one of the most important templates in Factview.

It is used to import transaction amounts for each reporting period, including:

  • Actuals

  • Budgets

  • Adjustments

  • Non-financial data

The template consists of multiple worksheets, including:

  • Cover Page

  • Instructions

  • Accounts

  • Transactions

  • Customers and Suppliers

Only the light blue and dark blue worksheets are imported.

Transaction Layout​

Transaction amounts are entered on the Transactions worksheet.

Each row represents a transaction for a specific reporting period.

The columns determine how the data is processed:

  • General Ledger Account → The account to which the transaction is posted.

  • Period → The reporting period in which the transaction is processed.

  • Amount → The transaction value.

  • Additional columns → Extra information, such as Cost Centers or descriptions.

You can add additional columns for purposes such as calculations or allocations.

Important Notes

  • Budgets do not need to be balanced.

  • All other imports must be balanced.

  • The Period column determines when the transaction is processed.

  • Supports Period 0 (opening balance) and Period 13.

5. Cumulative Amounts Template​

This template works in the same way as the Transaction Template, but is intended for cumulative figures.

Factview automatically converts these cumulative values into period transactions.

6. Cumulative Amounts Template with Sample Data​

This template contains sample data.

It can be used to populate a dossier for testing how data is processed. After testing, the dossier can be cleared again.

Planning Templates

7. Basic Planning Import Template​

This template is used to import budgets and forecasts.

The cover page contains general information, such as:

  • Organization name

  • Start year

  • Planning metadata

Additional information required for the planning process is entered here, such as the planning name, date, and version.

The various worksheets contain the following information for each row:

  • Planning item

  • General Ledger Account

  • Monthly amounts

Data is entered in separate sections, such as Revenue and Expenses.

Based on this information, Factview automatically calculates:

  • Profit and Loss Statement

  • Balance Sheet

  • Cash Flow Statement

  • VAT and payment schedules

These results are processed in the Planning Module.

8. Monthly Planning Import Template​

This template is intended for creating a quick multi-year forecast.

Compared to the comprehensive planning template, this version includes:

  • A single input worksheet

  • A simpler structure

  • Less detail, allowing for faster data entry

Obsolete Templates

Templates 9 through 11 are no longer used.