Post payroll to Odoo, Daftra or any accounting system
By Sayed Zakrea · 29 October 2026
To post payroll without retyping it, map each part of the payroll to an account once, then export each approved run as a journal entry and import that file into your accounting system. In Dawmly's payroll the export is a CSV or Excel file in two layouts: one that Odoo imports as it is, and a generic one for Daftra or any other ledger. The entry always balances.
What a payroll journal entry looks like
Salaries and allowances are expenses, so they are debits. What you hold back from employees (social insurance, late deductions) and what you still owe them (net salaries payable) are credits. A month with 90,000 basic, 10,000 housing allowance and 4,500 overtime, less 9,900 social insurance and 300 late deductions, posts like this:
| Account | Debit | Credit |
|---|---|---|
| Salaries expense | 90,000.00 | |
| Housing allowance | 10,000.00 | |
| Overtime | 4,500.00 | |
| Social insurance payable | 9,900.00 | |
| Late deductions | 300.00 | |
| Net salaries payable | 94,300.00 | |
| Total | 104,500.00 | 104,500.00 |
The figures are an example. Your own account codes and amounts come from your chart of accounts and your payroll run.
Map your accounts once
In Dawmly, open Payroll, then Settings, then Accounting export. Enter an account code (and, if you like, a name) for basic salary, overtime, each allowance and deduction you have defined, late deductions, absence deductions, adjustments and net salaries payable. Choose a cost centre if you track one: none, branch or department. If a run needs an account you have not mapped yet, Dawmly refuses the export and shows which lines are missing. It never posts to a placeholder account.
Export an approved run
Open an approved or paid payroll run and choose Export journal entry. Pick the layout and the format:
- Odoo import: the columns of Odoo's own journal-entry template (Reference, Date, Journal, Journal Items / Account, Journal Items / Debit, Journal Items / Credit, Journal Items / Label). The reference, date and journal sit on the first row only, and no row carries a zero or a negative amount, as Odoo requires.
- Any accounting system: one self-contained row per line with date, reference, currency, account code, account name, debit, credit, cost centre and description.
Amounts are totalled per account and cost centre, never one row per employee, so the ledger shows payroll totals and individual salaries stay on the payslips. A run paid in two currencies gives one balanced entry per currency.
Import into Odoo
- Make sure every account code you mapped exists in your Odoo chart of accounts.
- In Odoo, open Accounting, then Journal Entries, open the actions menu and choose Import.
- Upload the Odoo file from Dawmly. The columns match Odoo's fields on their own; test, then import.
- Odoo creates the entry as a draft. Review it and post it.
Odoo imports amounts in the company's main currency, so for a run in several currencies Dawmly offers one Odoo file per currency.
Daftra and other systems
For Daftra, on the Growth plan and above you can connect your Daftra account directly under Integrations (using a Daftra API key with permission to manage journal accounts), map each payroll part to a Daftra account, and click Post to Daftra on an approved or paid run to create one balanced draft journal entry per currency (totalled per account, dated the period end, without cost centres; posting the same run again does not duplicate it). Or, for any system, use the generic CSV/Excel layout: every row repeats the date, reference and currency and names the account by code and name, so it can be imported from a spreadsheet or keyed in from one short summary.
Plans
The journal export is part of payroll, which is included from the Growth plan. See pricing.
Frequently asked questions
Does the journal entry show each employee's salary?
No. Amounts are totalled per account and cost centre, so the entry shows total basic salary, total overtime, each deduction and total net pay. Individual amounts stay on the payslips in Dawmly.
Can I import the file into Odoo without editing it?
Yes. The Odoo layout uses the columns of Odoo's own journal-entry import template (Reference, Date, Journal, Journal Items / Account, Debit, Credit, Label). Import it from Accounting, Journal Entries, Import, then review the draft and post it.
What about Daftra or another system?
On Growth+, you can connect Daftra directly under Integrations (see the Daftra connector) to post one balanced draft journal entry per currency, totalled per account without cost centres, or use the Generic CSV/Excel layout for any accounting system.
What happens to an employee who works in two branches?
With branch cost centres turned on, that employee's amounts are left without a cost centre and the line says "multiple branches", so your accountant decides where they belong. Dawmly does not split or guess.
Which plan includes the journal export?
It is part of payroll, which is included from the Growth plan.
Want this to happen automatically for your team? Try the Dawmly attendance app: each employee clocks in from their phone with the time and location, free for up to 3 employees.