Importing your payroll journal

Export the journal entry of a pay run from Employes, Nmbrs or another package and import it month by month. Karet books it and links the payments of net salary, wage tax and pension.

Updated 16 October 20263 minutes

Karet does not run payroll. Your payroll package does the pay run and the payroll tax return; Karet books the result. Each month you import the journal entry of the pay run. Karet puts it in your books as one entry and then links the payments to your bank.

Which file

Most packages can give the journal entry of a pay run as a file. Karet reads CSV, text files (.txt) and Excel (.xlsx, the first sheet), up to 950 kB.

Employes

  1. In Employes, find the report with the pay run's journal entries — usually under Rapporten › Journaalposten.
  2. Pick the month and download the report as a file (CSV or Excel, whichever Employes offers).

A button that sends the journal entry to a linked accounting package usually does not give you a file. For Karet, use a download.

Nmbrs

  1. In Nmbrs, find the export of the journal entries of that month's pay run. Choose Excel (.xlsx) or a text file (.csv/.txt) if you have the choice; Karet cannot read a PDF.
  2. If you can choose between one line per employee and everything merged, choose per employee.

Save the export straight away: in some packages a download link expires after a while.

Another package

Export the journal entry of one month as CSV, a text file or Excel. Keep an employee column if there is one.

What the file must hold

  • The ledger account or the description of each line.
  • Debit and credit in two columns, or one amount with a column that says debit or credit (D/C).
  • When they are there: the employee and the date or period.

Karet recognises the columns by their headers. If it does not recognise one, you pick it once under Columns; Karet remembers it for next month. The file must balance: debit and credit equal. Karet does not book a file that does not balance.

If the file has a date or period, Karet takes the month from the file. If the file names another month than the one you chose, Karet does not book it.

Importing

  1. Go to Boeken › Loonjournaal.
  2. Choose your payroll package, the month and the file, and click Preview.
  3. Check under Book to where each of your package's accounts lands. Karet proposes an account from the name. With several employees in the file, mark who the DGA is.
  4. Click Book.

The entry is dated the last day of the month.

The payments

After booking, Karet waits for the bank lines that pay the net salary, the wage tax and the pension premium. A certain payment, such as the salary to the employee's name for exactly the amount, Karet books itself. The rest waits in To review with the payment as its proposal. Karet never books the wage tax itself: which period a payment to the Belastingdienst settles is your call.

Did you book the salary as a cost yourself before the import, for example on 4000 Wages? Then the preview shows those payments. Tick them and Karet turns them into the payment of the net salary, so the wage cost does not count twice.

Importing a month again

The same file again changes nothing, as long as you changed nothing in the mapping. A corrected file for the same month replaces the old one: Karet reverses the old entry and books the new file. There is one payroll journal per month, also when you switch packages.

Was this helpful?