In this article, you will learn how deferred income is calculated, how to create the export and what its columns mean.
Contents
- Quick Guide
- How deferred income is calculated
- Creating the export
- Columns of the export
- Case examples
Quick Guide
- Go to Finance / Tax consultant / Export lists.
- Click Create Export list and choose the deferred income export in Type.
- Select the Period and create the list.
- Check each debt claim with its service period in the columns DEF-I Days, DEF-II Days and Resolution.
How deferred income is calculated
Deferred income covers payments for a service period that reaches into another accounting period. The export calculates it individually for each debt claim. Look at each entry on its own instead of simply adding up the columns.
Creating the export
- Go to Finance / Tax consultant / Export lists.
- Click Create Export list.
- In Type, choose the deferred income export. Which types are offered depends on whether deferred income is set up in your accounting configuration:
- Deferred income not set up: Revenue deferment.
- Deferred income set up: Deferred income (summary), Deferred income (single bookings) and Deferred income (debt claim based).
- Select the time frame: Period for Revenue deferment, Deferred income (summary) and Deferred income (single bookings), or a single date in Reference date (absolute) for Deferred income (debt claim based).
- For Revenue deferment, select which debt claims to include: Fees, Modules and Flat fees. With Flat fees selected, you can also tick Include flat fee contracts with non recurring payment frequency.
- Create the list. All deferred income exports are created as Excel files.
The columns and examples below refer to the Revenue deferment export.
Columns of the export
| Column | Content |
|---|---|
| Number | Member number |
| Name | Member name |
| Reason for payment | Description of the debt claim |
| Original allocation | Original net amount of the debt claim in the observation period |
| Due date | Due date of the debt claim |
| From | Start of the service period |
| Until | End of the service period |
| Total | Total days of the service period |
| DEF-I Days | Days of the service period before the observation period |
| DEF-II Days | Days of the service period after the observation period |
| Resolution | Days of the service period within the observation period |
| DEF-I Amount | Amount of the debt claim deferred before the observation period |
| Credit | Credit amount from cancellations or idle periods in the observation period |
| Supply | Amount due in the observation period |
| Resolution | Amount resolved in the observation period |
| DEF-II Amount | Amount of the debt claim deferred after the observation period |
| Gross | Gross amount |
| Net | Net amount |
| Tax amount | Tax amount |
| Correction | Correction of the tax amount |
Case examples
Observation period: 01.01.2024 to 31.12.2024
| Example | Start of service period | End of service period | Total days | DEF-I Days | DEF-II Days | Resolution |
|---|---|---|---|---|---|---|
| 1 | 01.02.2024 | 31.01.2025 | 366 | 0 | 31 | 335 |
| 2 | 01.10.2023 | 31.12.2024 | 458 | 92 | 0 | 366 |
| 3 | 01.12.2023 | 31.12.2025 | 762 | 31 | 365 | 366 |
Example 1: the service period starts within the observation period, so DEF-I Days is 0. It extends 31 days beyond the observation period (01.01.2025 to 31.01.2025), so DEF-II Days is 31. The remaining 335 days fall within the observation period and are resolved.
Example 2: 92 days of the service period (01.10.2023 to 31.12.2023) precede the observation period. The service period ends with the observation period, so DEF-II Days is 0. 366 days are resolved.
Example 3: 31 days (01.12.2023 to 31.12.2023) precede the observation period and 365 days (01.01.2025 to 31.12.2025) follow it. The 366 days of 2024 are resolved.
Note: This article was created with the help of artificial intelligence and editorially reviewed.