Start page /periodandyear/help/start-page section Import accounting data. Lock periods. Copy data between periods and run auto checks. 2024-09-30T16:52:08+02:00 # Start page Import accounting data. Lock periods. Copy data between periods and run auto checks. The start page of Period & Year gives you an overview of the status of the reconciliation of the company that you are working with. You can quickly see how much of the reconciliation that is done, and how much is left to do. It is also where you import new accounting data from ERP or from a SIE4 file, SAF-T file or an Excel file, where you lock periods and where you run the auto checks. Read more in the topics below: Import accounting data /periodandyear/help/start-page/import section 2025-02-21T16:41:02+01:00 # Import accounting data There are several ways to import accounting data into Period & Year. Read more about the different alternatives below. To import data, simply click the button **Setup import source** at the top of the page and choose which type of import you would like to do. You can also import data under **Settings - Settings**.

The status of the import can be seen in Settings - Import settings.

> [!NOTE] Mapping of reference account with ERP import > Period & Year automatically suggests linking to a reference account with different priorities depending on whether a client account has been manually created in Period & Year, or whether it is imported from an import source. > >When importing via an import source, the reference account is linked based on the following priority: > >1. Import source mapping (standard mapping for selected import source defined by Period & Year) >2. Periode & Year mapping > >Read more about [Chart of accounts.](/periodandyear/help/settings/chart-of-accounts) ## Tripletex *To setup import:* : 1. Select import source **Tripletex** in the list. 2. Paste your Tripletex Employee Key or Accounting office key for authentication and save your changes. - To open up for API-access and create an employee key please [read this information in Tripletex](https://hjelp.tripletex.no/hc/no/articles/4409557117713#aktivering_av_api_tilgang_i_klient). - The application name should be Period & Year. - It is also possible to create an accounting office key for multiple clients. [Please read this information on how to proceed](https://hjelp.tripletex.no/hc/no/articles/10961043417233). 3. Select **Import from Tripletex** to start the import. ## PowerOffice Go *To setup import:* : 1. Select import source **PowerOffice Go** in the list. 2. Paste your Poweroffice Go **Client key** for authentication and save your changes. To create a client key, log in to PowerOffice Go and go to **Settings **- **Extensions**, select **Add extensions** and **Visma Period & Year** from the drop down. Copy the displayed client key. 3. Click **OK** to save. 4. Select **Import from PowerOffice Go** to start the import. ### Import of agricultural clients When importing agricultural clients, Period & Year also imports the associated agricultural departments as part of the chart of accounts. The agricultural department is distinguished by 2 digits after the general ledger account separated by a period punctuation mark. Agricultural departments: - 10 Finance - 20 Agriculture - 30 Forestry - 60 Other industry Examples of general ledger accounts including agricultural department: | Complete account number and name | Belongs to the following agricultural department | | -------- | ------- | | 3000.20 Sales revenue, grain, seeds, straw fodder (taxable) | 20 Agriculture | | 3000.30 Sales revenue, special timber, (taxable) | 30 Forestry | | 3000.60 Sales revenue, taxable | 60 Other industry | In the case of sole proprietorships, on the other hand, all transactions linked to agricultural department 90 Private will be imported and linked to the following earmarked 2 accounts: - 2089 Net capital primary industry accounts department private - 8989 Private profit and loss accounts (PowerOffice agriculture) ### Export of agricultural clients Export of manual vouchers and system vouchers will also include agricultural department as part of the closing entries. For example: - Debit 8975.60 - Private use of business vehicle - Credit 7099.60 - Private use of business vehicle (recognized as income) ## eAccounting *To setup import:* : 1. Select import source **eAccounting** in the list. 2. Select **Import from Visma eAccounting** to start the import. : > [!NOTE] The user in Period & Year must also be an administrator in eAccounting to complete the import. ## Visma Business *To setup import:* : 1. Select import source **Visma Business** in the list. 2. Paste your Visma Business client id and pairing key for authentication and save your changes.

When importing from Visma Business, an "agent" must be installed in advance for communication between Period & Year (cloud) and Visma Business (local installation). Click on this link for more information on how to install the agent and how to receive a pairing key.

3. Click the button **Import from Visma Business** to start the import. ## Visma Net *To setup import:* : 1. Select import source **Visma Net** in the list. 2. Click on **Connect client**. 3. Select which client you want to link in the client list that appears in Visma Net. : > [!NOTE] The user in Period & Year must ensure that they have access to the same clients in Visma Net and Period & Year in order to be able to connect the clients and later run imports. 4. Select branches if the client you are connected to uses multiple branches. :

The clients and/or branches in Visma Net and Period & Year MUST use the same organization number.

: 5. Click on **Save changes**. The client is now connected to the associated client in Visma Net and ready for import. : 6. Click on the button **Import from Visma Net** to start the import. : > [!NOTE] Reconnect client The connection to the client in Visma Net is valid for 3 months. You must then reconnect to import new accounting data. ## Business NXT *To setup import:* : 1. Select import source **Business NXT** in the list. 2. Select **Import from Business NXT** to start the import. : : > [!NOTE] The user in Period & Year must ensure that the clients in Business NXT and Period & Year use the same organization number. ## 24SevenOffice *To setup import:* : 1. Select import source **24SevenOffice** in the list. 2. Enter your ERP **User name** and **Password**and save your changes. 3. Select **Import from 24SevenOffice** to start the import. ## DNB Regnskap *To setup import:* : 1. Select import source **DNB Regnskap** in the list. 2. Select **Import from DNB Regnskap** to start the import. 3. Fill in the username and password to login to DNB Regnskap. > [!NOTE] The login to DNB Regnskap is valid for 45 days then you must reconnect to import new accounting data. 4. Click **Allow** to give Period & Year access to your data in DNB Regnskap. 5. Select which client to import from the client list in DNB Regnskap. 6. Click **Continue** to start the import process and be redirected to Period & Year. ## Duett Økonomi *To setup import:* : 1. Select import source **Duett Økonomi** in the list. 2. Paste your Duett Økonomi **Client API key** for authentication and save your changes.

Client API key can be found in the following menu in Duett Economy: Settings - Company setup integrations

Read more about activation of the integration at [Duett Økonomi](https://duett.no/regnskapsprogram/integrasjoner/visma-periode-ar). 3. Click **Save changes**. 4. Click **Import from Duett Økonomi** to start the import. ## Eika Regnskap *To setup import:* : 1. Select import source **Eika Regnskap** in the list. 2. Click **Import from Eika Regnskap** to start the import. 3. Fill in the username and password to login to Eika Regnskap. > [!NOTE] The login to Eika Regnskap is valid for 45 days then you must reconnect to import new accounting data. 4. Click **Allow** to give Period & Year access to your data in Eika Regnskap. 5. Select which client to import from the client list in Eika Regnskap. 6. Click **Continue** to start the import process and be redirected to Period & Year. ## SpareBank 1 Regnskap *To setup import:* : 1. Select import source **SpareBank 1 Regnskap** in the list. 2. Select **Import from SpareBank 1 Regnskap** to start the import. 3. Fill in the username and password to login to SpareBank 1 Regnskap. > [!NOTE] The login to SpareBank 1 Regnskap is valid for 45 days then you must reconnect to import new accounting data. 4. Click **Allow** to give Period & Year access to your data in SpareBank 1 Regnskap. 5. Select which client to import from the client list in SpareBank 1 Regnskap. 6. Click **Continue** to start the import process and be redirected to Period & Year. ## Unimicro *To setup import:* : 1. Select import source **Unimicro** in the list. 2. Select **Import from Unimicro** to start the import. 3. Fill in the username and password to login to Unimicro. > [!NOTE] The login to Unimicro is valid for 45 days then you must reconnect to import new accounting data. 4. Click **Allow** to give Period & Year access to your data in Uni Economy. 5. Select which client to import from the client list in Unimicro. 6. Click **Continue** to start the import process and be redirected to Period & Year. ## Xledger *To setup import:* : 1. Select import source **Xledger** in the list. 2. Paste your Xledger *API token*. - The API token can be found under the following menu options in Xledger and requires the user to have the role of administrator: Administration > System Access > GraphQL > API Tokens - It is recommended to create your own named API token for the use of Period & Year and which respectively has read and write access to the following scopes: | Scope | Read access | Write access | | :---------------- | :------: | :----: | | *Common:* | | | | - Company | x | | | - Entity | x | | | - ObjectValue | x | | | - Period | x | | | - PeriodStatusItem | x | | | - Url | x | | | *General ledger:* | | | | - Account | x | | | - Account balance | x | | | - GLImportItem | x | x | | - JournalEntry | x | | | - Transaction | x | | | - TransactionHeader | x | | 3. Click **Save changes**. 4. Click **Import from Xledger** to start the import. > [!NOTE] The user in Period & Year must ensure that the clients in XLedger and Period & Year use the same organization number. ## SAF-T file *To set up import:* : 1. Select import source **SAF-T file** in the list. *The import supports the following file formats:* - SAF-T files in XML format. - SAF-T files in XML format packed in ZIP format. 2. Select **Import from SAF-T file** and **Select file** button to select your file. 3. Click **Continue** to start the import process. ## SIE4 file *To set up import:* : 1. Select import source **SIE4** file in the list. 2. Select **Import from SIE4 file** and **Select file** button to select your file. 3. Click **Continue** to start the import process. ## Microsoft Excel To set up import: : 1. Select import source **Microsoft Excel** in the list. When importing from Microsoft Excel, it is important that the file has the following format layout. | | | | | | | |----|----|----|----|----|----| | Column A2 | Column B2 | Column C2 | Column C1 | Column D2 | Column D1 | | Account number | Account description | Closing balance | Year | Closing balance | Year | ![](./img/ExcelImportFormat.JPG) **Account number** - One row for each account in the trial balance for the actual accounting year. **Account description** - Assigned account name from the accounts (ERP system). **Closing balance** - Closing balance on the actual account for the imported accounting year. **Year** - Year-end closing year, can be last year and/or this year. When importing deviating accounting years, the following format must be used in the heading for the year: dd.mm.yyyy-dd.mm.yyyy ![](./img/ExcelImportDeviatingYear.JPG) Import from Excel does not include any transactional data, only annual balances. This means that it is more relevant for Year-end closing than for Period-end. An excel file can contain up to two accounting years, which makes it possible to import the current and previous year from the same Excel file. If you choose to import two financial years in separate Excel files, you must ensure that you import the previous year before the current year. This is necessary for the program to calculate the correct opening balance for the current year.

A standard client chart of accounts based on the reference chart of accounts in Period & Year is created automatically during import.

2. Click on **Import from Microsoft Excel** and the **Select file** button to select your file. 3. Click **Continue** to start the import process. > [!NOTE]Last three financial years When importing data from the ERP system, all accounting data from the last three financial years that you have created in the ERP system is imported into Period & Year. Deviating accounting year /periodandyear/help/start-page/import/deviating-accounting-year page 2024-10-14T16:23:18+02:00 # Deviating accounting year For seasonal businesses, you have the option in Period & Year to prepare annual report with deviating financial years. For example, it could be a ski resort where you want to have the winter season in its entirety in a financial year. The financial year can then, for example, be the period from 1 July to 30 June. Annual report entities that are branches of, or subsidiaries in Norway of, a foreign enterprise that uses a different financial year than the calendar year, can choose to use deviating financial years in order to have the same financial year as the foreign enterprise. Period & Year supports the import of clients with deviating accounting years from Total, Finale and Altinn.

All areas should be reviewed after conversion to Period & Year, and we point out that certain elements under the following areas must be filled in manually/checked:

  • Trial balance; check alternative links

  • Various information - State aid, relevant public support is added manually

  • Property, check calculated wealth values from the Tax Agency

  • Financial products, check that financial products are displayed under the right tab and tick the exemption method if relevant

  • Taxi and cargo transport businesses; taximeter type is added manually

  • Accommodation and public house; any sales revenue in cash and cash register type are added manually

  • Group contributions, attachment and treatment rule must be entered manually

  • Wealth, overridden values from RF-1028 Tax declaration must be added to the field Other wealth from commercial activities

  • Salary and pension costs, relevant additional lines for correction of reconciliation are added manually

When importing to a new deviating accounting year, it may happen that the client has a balance on the reference account 2500 "Betalbar skatt, ikke fastsatt". This balance may apply to the previous deviating accounting year\'s allocated payable tax that has not yet been paid. If that is the case, the relevant balance must be reposted from the reference account 2500 "Betalbar skatt, ikke fastsatt" to reference account 2510 "Betalbar skatt, fastsatt". This is to avoid errors in this year\'s taxable cost. After reposting, you must go to **Wealth** and correct the relevant amount in the manual field on the row \'Code 2510 Payable tax, determined\'. This is to avoid the amount being erroneously included in the company\'s wealth. #### Procedure in Period & Year {#procedure-in-period-year} Importing accounting data that spans over two calendar years will be interpreted by Period & Year as a deviating fiscal year and this is displayed under **Settings** in the heading of imported data where the relevant period is displayed, for example 2023/2024. On the **Start page**, you enter the deviating financial year in the same way as when preparing an ordinary year-end closing. When you enter the period **Year-end closing**, please note that constants and other amount limits apply to the income year in which the deviating financial year expires. This is because it is the tax rules for the income year/calendar year in which the deviating financial year expires that must be used. This applies, for example, to depreciation rates and other rates/amount limits that are important for determining the tax base. Prepare the year-end closing and submit the **Annual report** as soon as this has been completed and determined. When the next year-end closing version is ready in Period & Year, you can submit the **Tax return** when it opens up for submission to Altinn. Please note that there may have been changes to the program in connection with the new year-end closing version, which means that some data will have to be changed in order to match the previously submitted annual report and the determination of the tax return. After the tax return has been submitted for the previous year-end closing period, you can import the following year\'s deviating financial year and begin the preparation of the year-end closing and submission of the annual report. Read more about [Client with deviating fiscal year.](/periodandyear/help/client/client-companies/deviating-accounting-year). Reporting periods /periodandyear/help/start-page/periods page 2024-09-30T16:52:08+02:00 # Reporting periods When data has been imported into Period & Year, the start page will show all periods of all financial years that have been imported according to selected reporting period when the client was created. It is possible to change rerporting period when working with period closing in Period & Year. Read more about [Change reporting period](/periodandyear/help/settings/company-information/change-reporting-period).

The period that you are currently working with can be seen on all views in Period & Year, in the top right corner of the page.

## Lock periods When you have completed the reconciliation of a period, you lock it on the start page.

A period must be locked before you can start working with the next period.

It is possible to add data to a period that is not yet started, such as an external appendix, however you cannot add amounts. If you need to add more information to a period that is already locked, it can be unlocked temporarily. The next period will then be paused, so that you only work in one period at a time. You can add external appendices and add accounts to appendices in a paused period, but you cannot add amounts. You can always view locked periods. If a period is locked, the checks will not be run for this period, so the results of the checks will remain the same. Copying of data between periods /periodandyear/help/start-page/copying-between-periods page 2024-09-30T16:52:08+02:00 # Copying of data between periods Only appendices with the setting **Yes, with data** are copied between regular periods (P1-P2 up to P11-P12). When P12 is locked and the year-end period (P13) is started, the following is copied from P12 to P13: - Account statuses. - Statuses and comments in the checklist. - All appendices created during P12 (regardless of setting).

All external appendices with the setting Yes, with data to year-end period created during the year are also copied to P13.

Also, the following rules applies when copying between P12, P13 and P1: - If P12 is locked and P13 is not started, appendices with the setting **Yes, with data** are copied from P12 to P1 when P1 is started. - If P12 is locked and P13 is started, appendices with the setting **Yes, with data** are copied from P13 to P1 when P1 is started. - If P13 is locked and P1 is started, appendices are copied from P13 to P1. Run auto checks /periodandyear/help/start-page/run-checks page 2024-09-19T15:50:46+02:00 # Run auto checks The automated checks in Period & Year can be run from the page **Transaction analysis**. The outcome of the checks are shown in the overview and appendices in **Reconciliation BS**, and in the overview in **Analysis IS**, as well as under **Transaction analysis**.

Period & Year comes with a set of default checks. These cannot be changed or deleted. They can, however, be disabled. You can also add your own checks. Read more in Check settings.