Aspel NOI payroll import

The problem

Plenty of companies run payroll in Aspel NOI and keep their books in Odoo. Moving the payroll calculation is not on the table — it works, the accountant knows it, and tax filing is already solved — so every period somebody opens the NOI report and types the journal entry into Odoo by hand.

That is dozens of lines per period: every earning, every deduction, every department. It gets typed wrong, it gets balanced by hand, and when somebody asks where a figure came from, you go back to the spreadsheet.

How it works

You upload the NOI payroll report exactly as it is exported, as an Excel file. The module finds the header row on its own and reads the report's own data — company, tax ID, payroll number and issue date — without you pointing at anything.

Then it splits the columns: employee data on one side — code, name, social security and tax IDs, department, position, daily wage, contribution base, days worked and absences — and payroll concepts on the other. It recognises NOI's taxable / exempt breakdown, tells earnings from deductions by where they sit relative to the taxable total, and skips the report's own total columns so nothing is counted twice. A concept that appears twice under the same name — housing or meals, which are both an earning and a deduction — is treated as two separate concepts, which is what they are.

What you get is an import you can review before touching the books: totals per employee, the concept-by-concept detail, and an analytic view of the lines grouped by department and concept.

Accounts are configured once: each combination of concept + type + department points to an account. A mapping with no department applies to all of them, and one with a department wins over the general rule, so you only enter the exceptions. Before anything is generated, a validation button tells you exactly which combinations are still missing an account.

The entry is generated grouped by concept and area: earnings on the debit side, deductions on the credit side, and the net to the payable account you choose. It comes out as a draft, in the journal and on the date you set, for the accountant to review and post.

What it does not do

It does not calculate payroll or file it: that stays in NOI. It does not create employees in Odoo or link them to existing ones — this is an accounting entry, not an HR record. And it never posts the entry on its own: it always stays a draft.

What changes

Payroll close goes from typing dozens of lines to uploading a file and reviewing it. The account setup is done once and serves every period after that, and every figure in the entry can be traced back to the employees behind it.