Accounting exports
For any accounting software without a connector (Sage, Zoho Books, Ciel, EBP, Wave, a firm working in Excel), Hela produces the ledger and trial balance in the formats these programs import.
Charts of accounts
Hela projects its movements onto a chart of accounts:
| Chart | Countries | Accounts used |
|---|---|---|
syscohada |
OHADA (DRC, Côte d'Ivoire, Senegal, Cameroon, Benin…) | 411 customers, 401 suppliers, 571 cash, 521 bank, 701 sales, 601 purchases, 4431 output VAT |
pcmn |
Belgium | 400 customers, 440 suppliers, 570 cash, 550 bank, 700 sales, 604 purchases, 451 VAT payable |
pcg |
France | 411 customers, 401 suppliers, 530 cash, 512 bank, 707 sales, 607 purchases, 44571 output VAT |
GET /companies/{id}/reports/exports/charts returns the list and, for each chart, the accounts.
Files
| Route | Format | For whom |
|---|---|---|
GET …/reports/exports/ledger?from&to&chart= |
Ledger CSV: date, document, account, label, debit, credit, currency | Any spreadsheet, Sage, Zoho Books |
GET …/reports/exports/ledger.fec?from&to |
FEC (French Fichier des écritures comptables, order of 29 July 2013), 18 columns, ` | ` separator |
GET …/reports/exports/ledger.datev.csv?from&to |
DATEV Buchungsstapel (EXTF 700) | Germany, Austria |
GET …/reports/ohada/ledger.csv?period&chart= |
OHADA ledger, CSV | OHADA |
GET …/reports/ohada/balance.csv?period&chart= |
Trial balance | OHADA |
In the app: Finance → Reports → Exports.
Importing into…
- Sage 50 / Sage Business Cloud: Import → Journals, CSV format, columns mapped to date, account, label, debit, credit.
- Zoho Books: Accountant → Manual Journals → Import.
- Ciel / EBP: import the FEC directly (Tools → FEC import).
- DATEV Unternehmen online: Belege → Buchungsstapel importieren, EXTF file.
Rules
- Amounts are written in major units with the format's decimal separator (dot for CSV and FEC, comma for DATEV).
- Foreign-currency sales are converted to the base currency at the rate frozen on the sale; the original currency and amount are in the columns meant for them (
Idevise,Montantdevisein the FEC). - An exported period does not change: exporting a closed month always gives the same lines.
Automating
An export can be requested through the API and dropped automatically into Drive, OneDrive or Dropbox every month. An accountant can also be given a read-only API key (reports:view, exports:create) and pull the file themselves.