Skip to content

8. CSV export (for the general ledger)

← Back to contents


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:

  1. Open an empty Excel document.
  2. Go to Data → From Text/CSV (or From File → From Text/CSV).
  3. Choose the CSV file.
  4. Excel will ask for parameters:
  5. File origin / Encoding: 65001: Unicode (UTF-8)
  6. Delimiter: Semicolon
  7. 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 UJP button (under development).
  • ⚠️ Partner accounts: if Buyer account or Supplier account is 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 by EDB against the seller_edb field 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 →