Accounting period processings
The following processings are available from the Accounting period table:
Create acc balances for all periods
This processing is used to create accounting balances for all periods on accounts and organisational units for which creating all balances is enabled.
Balance lines with 0 (zero) in movement are created for a full financial year and can't be created for individual accounting periods. Balance lines will be created for all the accounting periods that have the same year as the selected row.
For example, to generate lines for 2 years (=24 periods) for the following:
- 100 general ledger accounts
- 20 organisational units within organisational unit class 1
- 5 organisational units within organisational unit class 2
- 5 organisational units within organisational unit class 3
100 * 20 * 5 * 5 * 24 = 1,200,000 lines will be generated.
Starting the processing
- Select the Accounting period rows you want to process.
- In the Processing menu, select Create acc balances for all periods.
| Table | Field | Setting |
|---|---|---|
| Accounting period | Acc. period processing | Physical balance row created is enabled for all accounting periods with the same year as the selected record. |
| General ledger account | Balance processing | Create all balance periods is enabled. |
| Organisational unit 1-Organisational unit 12 | Balance processing | Create all balance periods is enabled. |
Excluding lines
If you want to remove individual balance lines with 0 (zero) in movement or all balance lines with 0 (zero) in movement for all periods within a year, perform the following steps:
- Disable Create all balance periods in the Balance processing field in the General ledger account table.
- Disable Create all balance periods in the Balance processing field in the Organisational unit 1-Organisational unit 12 tables.
- Run the Regenerate account balances processing from the Company information table.
See also: Regenerate account balances
Set year and period on updated transactions
This processing is used to set accounting year and period on all relevant transactions.
You can use this processing to change the Year and Period for transactions that you have entered for accounting periods in the future. It is used only if the company's financial year is changed between non-deviating (the financial year is set to Jan-Dec) and deviating financial year (the financial year is differing from Jan-Dec). This is mainly in use in Sweden.
Starting the processing
- Select the Accounting period rows you want to process.
- In the Processing menu, select Set year and period on updated transactions.
- Click OK to accept that batches that aren't updated won't be handled. If you want to cancel the processing and update batches before you proceed, click Cancel.
- Click OK to regenerate balances, and the processing is started.
| Table | Field | Comment |
|---|---|---|
| General ledger transaction | Year, Period, Account. year/period | |
| Customer transaction | Year, Period, Account. year/period | |
| Supplier transaction | Year, Period, Account. year/period | |
| Capital asset transaction | Year, Period, Account. year/period | |
| Open customer entry | Year, Period, Account. year/period | |
| Open supplier entry | Year, Period, Account. year/period | |
| Updated batch | Year, Period | |
| Updated voucher | Year, Period | |
| Order line | Account. year/period | Based on Trans. date |
| Product transaction | Balance processing | Based on 1. Invoice date, 2. Finish date and 3. Trans. date |
See also: Regenerate account balances