ERPNext v15 Multi-Company Accounting System

We need a freelancer to deliver a full ERPNext v15 configuration package (CSV/JSON fixtures or Data Import templates). The system must support multi-company, multi-currency, multi-jurisdiction accounting and meet local statutory accounting standards.

Only pay if configuration is fully imported, validated, and compliant.

⸻

Deliverables

Company Setup
• Create 5 dummy companies with placeholders:
• Holding company in Andorra (EUR)
• Marketing/SaaS company in Andorra (EUR)
• Real estate company in Andorra (EUR)
• SaaS/Prop trading company in USA (USD)
• Legacy company in Spain (EUR)
• Include dummy tax IDs, currencies, and countries
• Deliver as companies.csv

Chart of Accounts (CoA)
• Must strictly follow local statutory frameworks:
• Spain → PGC (Plan General de Contabilidad)
• Andorra → based on PGC Spain, adapted to Andorran regulations
• USA → US GAAP chart of accounts, IRS tax compliance accounts
• Implement full consolidated CoA (1xxx–9xxx) for group reporting
• Include OBB (off-balance book) memo accounts (9xxx), excluded from statutory FS
• Deliver as chart_of_accounts.csv

Banking
• Preconfigure multiple dummy bank accounts per company (EUR and USD)
• Deliver as bank_accounts.csv

Intercompany Workflows
• Configure ERPNext Loan module for intercompany loans (holding → subsidiaries)
• Automate monthly interest accruals and repayments
• Setup dividend flow (subsidiary to holding)
• Deliver as intercompany_workflows.json

Cost Centers & Dimensions
• Dimension 1 = Company (auto)
• Dimension 2 = Cost Center / Business line (Treasury, Marketing, Real Estate, SaaS, Legacy)
• Deliver as cost_centers.csv

Tax Setup
• Andorra → corporate tax template (10%)
• Spain → VAT 21% (sales and purchases) + corporate tax accrual (25%)
• USA → Federal income tax (21%) + placeholder state tax (5%)
• Deliver as taxes.json

Off-Balance Book (OBB)
• Memo accounts for: BTC holdings, stablecoins, partner contributions, legacy buyout, family ledger
• Must not affect statutory FS but available for management dashboards
• Deliver as obb_accounts.csv

Payroll
• Multi-company payroll setup
• Dummy employees per entity (marketing specialist, property manager, software engineer, etc.)
• Deliver as employees_template.csv

Reporting
• Local statutory reports per company (PGC Spain, Andorran GAAP, US GAAP compliant)
• Group consolidated reports (Balance Sheet, P&L, Cash Flow)
• Custom dashboards for: contribution margin per cost center, intercompany loan balances, OBB overview
• Deliver as reports.json

Governance & Permissions
• Role-based access:
• Group finance = full access, all companies
• Local managers = own entity only
• Auditors = read-only access
• Deliver as roles_permissions.json

⸻

Acceptance Criteria
• All files import into a clean ERPNext v15 instance without errors
• Chart of Accounts per company complies with local statutory standards (Spain PGC, Andorra PGC variant, US GAAP)
• Intercompany workflows generate correct mirrored journal entries
• OBB accounts visible in dashboards but excluded from statutory FS
• Consolidated reports reconcile correctly
• Role-based access enforced