8. CSV export (for the general ledger)¶
eFakturaWin supports exporting the lists of outbound and inbound invoices to CSV (Comma-Separated Values) format, specifically tuned for transferring data into accounting systems and general-ledger programs.
8.1. When to use the CSV export¶
- 📊 Transfer to the general ledger. Your accountant works in a separate general-ledger program and wants to receive issued-invoice data regularly.
- 📈 Analysis in Excel/LibreOffice. You want to produce your own reports, totals, charts.
- 🗂 Archiving. A text format that remains readable for 20 years (unlike some proprietary databases).
- 🔄 Data migration. Replacing one accounting system with another.
8.2. Where and how¶
CSV export is available from two lists. In both cases the same principle applies: only the selected rows are exported — both via the CSV button below the list, and via the Export to CSV option in the right-click context menu.
Outbound invoices — Invoicing → Invoice List¶
- CSV button (below the list) — exports the selected invoices.
- Right click → Export to CSV — the same.
Inbound invoices — e-Invoice (UJP) → Inbound invoices¶
- CSV button (below the list) — exports the selected inbound invoices.
- Right click → Export to CSV — the same.
All invoices into one CSV
If you want several invoices to go into a single CSV in one operation — e.g. a whole month for an accountant — select them first: Ctrl+A (or context menu → Select all) on the currently filtered list, then click CSV. The order in the CSV will reflect the current sorting of the grid.
8.3. CSV format¶
The output file is UTF-8 text with ; (semicolon) delimiter and Windows line breaks (CRLF). The first row is always a header with column names in English.
Both CSV types have six columns with the same layout — they differ only in columns 3, 4 and 5:
The header is identical for the two CSV types — only column 3 differs (Buyer account for outbound, Supplier account for inbound) and which of the Debit/Credit columns the amount goes into:
| # | Column | Outbound | Inbound |
|---|---|---|---|
| 1 | Date (DD.MM.YYYY) |
invoice date | invoice date |
| 2 | Number |
invoice number | invoice number |
| 3 | Buyer account / Supplier account |
buyer's account | supplier's account |
| 4 | Debit |
amount | 0 |
| 5 | Credit |
0 |
amount |
| 6 | Cur. |
currency code (MKD, EUR, …) |
currency code |
The logic follows the standard double-entry principle: an outbound invoice debits the buyer (Debit = amount), an inbound invoice credits the supplier (Credit = amount).
Example — outbound invoices¶
Date;Number;Buyer account;Debit;Credit;Cur.
03.12.2026;1;1200;9300.00;0;MKD
05.12.2026;2;1200;15850.50;0;MKD
12.12.2026;3;1201;47000.00;0;EUR
Example — inbound invoices¶
Date;Number;Supplier account;Debit;Credit;Cur.
03.12.2026;FX-2245;4280;0;5200.00;MKD
07.12.2026;ENRG-1001;4282;0;3100.00;MKD
8.4. Opening the CSV in Excel¶
When you open a CSV directly (double-click), Excel often fails to recognise Cyrillic characters or uses the wrong delimiter. Recommended procedure:
- Open an empty Excel document.
- Go to Data → From Text/CSV (or From File → From Text/CSV).
- Choose the CSV file.
- Excel will ask for parameters:
- File origin / Encoding:
65001: Unicode (UTF-8) - Delimiter:
Semicolon - Press Load.
LibreOffice Calc detects these parameters automatically — just open the file.
8.5. Tips¶
- 💡 Monthly export. Standard work routine: at the end of each month, apply the filter "From 01.MM to 30.MM" and produce a CSV. Send it to the accountant.
- 💡 No UJP-generated numbers. The CSV shows your local invoice numbers — not UJP EUIDs. For the UJP EUID, use the
Send to UJPbutton (under development). - ⚠️ Partner accounts: if
Buyer accountorSupplier accountis blank in the CSV, that means you have not populated that field on the partner (or, for inbound invoices, that the supplier does not exist as a local partner at all). Fix it in Codebooks → Partners before the next export — for inbound invoices the partner is matched byEDBagainst theseller_edbfield from UJP. - ⚠️ Amount: is in the invoice's currency, not converted into denars. If you have EUR/USD invoices, the accountant has to apply the exchange rate themselves.
- 💡 Archive the CSV together with the PDFs. If the CSV is regenerated every month, it acts as a backup of part of your database. Keep it together with the PDFs.
← Back to contents | Previous: PDF printing ← | Next: Inbound invoices →