The Danish Tax Report is available via Financial > Tax File

More information about the file format can be found here

A demonstration video can be found here: Danish Tax Report

Configuration

The configuration for the tax file can be found at Financial > Tax File > Settings

General

The General configuration of the tax file includes details of your organisation.

CVR/SE Number

The CVR number of your organisation.

Name of sender

The name of your organisation to be included in the report.

Last file number submitted

The last number of the file submitted to the tax authority, leave this untouched.

Constituent type(s) to include

Select multiple constituent types which you would like to be included in the report.

 

Setting up your products

Add your Products to the configuration as below:

Product

Which Product/s you are including in the file

Relief type

Whether the product provides Common or Continuous relief.

Non-tax deductable amount

This is the amount of the transaction which is NOT tax deductable.

Calculation method

The calculation method used for the tax deductable amount.

For example, let's assume there are 3 separate payments of 50DKK and a non-tax deductable amount of 10DKK.

Per product will result in
(50 - 10) + (50 - 10) + (50 - 10) = 120DKK

Cumulative will result in

50 + 50 + 50 - 10 = 140DKK

 

 

Ensuring CPR numbers are valid

The tax report will only include transactions belonging to constituents who have a valid CPR number (National ID Number).

The rules which determine if a CPR is valid are:

If a constituent is NOT a group (I.E is an individual)

• Number begins with a valid date.
• Number passes mod 11 checks.
• Has a length of 10 characters.

If a constituent is a group (i.e an organisation)

• Has a length of 8 characters.

The CPR check is run before the tax file is generated, but it is also possible to run it at any time using a manual trigger.

Tags are added to the constituent after the check is run with a value of CPR Valid or CPR Invalid.

These tags can now be used to create lists to find all constituents who have a valid or invalid CPR number.

 

Generating the tax file

Multiple tax files can be generated for the same year.
Each subsequent generation of the tax file takes into account all of the previous tax files from that year, making corrections to any changes in data and outputs these only. Therefore it is important to submit ALL of the tax files generated.

 

To generate a tax file you should select the year required

Then click Build Report.

Once the report has finished generating your files they will be available to download on the same page. The files are separated into groups and non-group constituents, with a maximum of 25,000 rows in each file.

It is highly recommended to verify the contents of the tax files BEFORE submitting them.

It is possible to delete all of the tax files and start the generation again IF they have not already been submitted.

Note: Tax files should be opened or edited in a simple text editor such as Notepad to preserve the format of the data.

 

Adding receipts

Once the tax file has been submitted you should add the receipt provided to each of the files. This helps to keep track of the files and stops already submitted files from being deleted.

 

Configuration - FRADRAG Activity

As standard, the Activity Type FRADRAG is set up within your Donorfy. You can opt to add additional information about the Tax Report for each constituent within the extra fields section. This information will then show on the constituent timeline. 

To add the extra fields, open Settings > Configuration > Activities > FRADRAG

Within Text fields, you can add: Year and Type

Within Number fields, you can add: Amount

 

 

Constituent Activities

Once you have completed generating the tax files you can add an activity to the constituents who are part of the tax file.

Each constituent will get 2 activities added to their timeline for each tax file year.

One activity is for the common relief, and the second is for the continuous relief.

 

 

 

The Online Fundraising integration is a Professional-only feature. Danish Essential subscribers, please contact us to find out more about upgrading.

 

Other requirements: the integration only applies to Online Fundraising version 4 and later. Prior versions cannot be integrated.