First of all:
To carry out this process correctly, you have at your disposal a CSV/Excel template that you simply have to download, fill in and upload again to the platform.
1. Download the import template
Open the import modal as explained above.
Download the CSV/Excel template to view the import format
Open the downloaded document to be able to work on it.
2. Fill in the template
Fill in the fields below. Those that are essential are marked with an asterisk (*).
Write the employee's NIF so that he/she can identify himself/herself correctly.
Enter the date of issue of the payslip.
Add an explanatory text to identify the payroll in the payroll list.
The total amount paid
Salary Account (640)
Add the accounting account of group 640 to which you want the amount entered in the Wages column to be posted.
The amount of S.S. payable by the company + S.S. payable by the worker
Total S.S. Account (476)
Specifies the accounting account of group 476 to which you want the amount entered in the Total S.S. column to be posted.
S.S. Expense Company*
The amount of S.S. payable by company
H.S. Expense Company Account (642)
Indicates the accounting account of group 642 to which you want the amount entered in the Company S.S. Expense column to be posted.
IRPF* (PERSONAL INCOME TAX)
The income tax amount
IRPF Account (4751)
Enter the accounting account of group 4751 to which you want the amount entered in the Income Tax column to be posted.
Tags separated by -
Add the tags for analytical accounting
Amount of the payment
It is calculated as follows: (Salary + Company S.S. Expense) - (Total S.S. + IRPF) . By leaving this column empty, payrolls are imported without payments registered as pending.
To register the payroll payment. Enter the payment date in order to be able to reconcile later the bank statement movement with the registered payment.
Indicates the accounting account of the bank you have previously created and assigned. The payment will be recorded in this bank for subsequent reconciliation.
Remember that you cannot import payroll documents as such into Holded, the imported information corresponds to the fields detailed above.
3. Upload the template information
From Expenses>Payrolls, access the three-dot menu (⋮) again.
Click on Import
Click the Upload file button
Select the spreadsheet with the completed fields that you have previously saved.
Confirm the action
I would like to receive personalised help
If you would prefer our Import team to give you a hand with the preparation of your files, at Holded we have a team of experts who can advise you and carry out the import for you.
Our team will assist you with the preparation of your journal, sales and purchase invoices, contacts, accounts and products. They will also help you to detect errors, correct them and organise each of your files.
This will ensure that all your business information is transferred correctly and give you peace of mind that the import will be successful.
To find out more about the service and pricing, please contact us at [email protected].