How do I create invoices in bulk from an Excel (CSV) file?

Bulk Invoicing is the fastest way to create a large number of documents in Számlázz.hu. Instead of entering invoices one by one, you can prepare your data in an Excel template, save it as a CSV file, and upload it to generate all documents in a single upload.

With Bulk Invoicing you can create:

paper invoices,
e-invoices,
pro forma invoices.

When is Bulk Invoicing the best solution?

Bulk Invoicing is a great choice if you:

issue a large number of invoices at regular intervals,
invoice recurring charges, such as monthly, semi-annual or annual subscription fees,
already have your invoicing data stored in Excel or another system,
create the same or very similar invoices repeatedly.

Using a CSV import can save significant time and reduce manual data entry, especially when you need to generate many documents at once.

You can generate only one document type per upload, but invoices within the same file may use different currencies.

How does Bulk Invoicing work?

The process consists of the following steps:

Go to Számla / Tömeges számlázás and click "Minta Excel-fájl letöltése: Letöltöm" to download the Excel template.
Fill in the required invoice data.
Save the file as a CSV.
Upload (Számla / Tömeges számlázás) the CSV file and generate your documents.

How do I prepare the Excel template?

To create your documents, first download our sample Excel template and fill it in with your invoice data. The template contains sample values and headers to help you complete it correctly.

When editing the template, keep the following in mind:

Do not modify or delete the first three header rows. They are required for the import process.
Each invoice starts with a header row, followed by one or more line item rows.
Every invoice must contain at least one line item.
Once you've finished, save the file as a semicolon-separated CSV (.csv) before uploading it.

The following fields are mandatory for every invoice:

Column	Hungarian column name	English translation
A	Vevő neve	Customer name
G	Fizetési mód	Payment method
H	Fizetési határidő	Payment due date
I	Teljesítés dátuma	Performance date
J	Kiállítás dátuma	Invoice issue date
M	Tétel neve	Item name
N	Mennyiség	Quantity
O	Egység	Unit
P	Nettó egységár (or Bruttó egységár, depending on your account settings)	Net unit price (or Gross unit price)
R	ÁFA	VAT rate

The required price column depends on your account settings. If your account uses net pricing, fill in the Nettó egységár (P) column. If it uses gross pricing, fill in the Bruttó egységár (Q) column instead.

You can also complete additional optional fields, such as customer e-mail address, tax number, foreign currency, bank account details, invoice notes and accounting information.

Do not use line breaks (Alt+Enter) anywhere in the template, as they may prevent the file from being imported correctly. If you want to display multiple lines in an invoice note, use the [br] tag instead.

Which character encoding should I use?

Bulk Invoicing supports the following character encodings:

UTF-8
ISO-8859-2 (Central European)

When uploading your CSV file, select the same character encoding that you used when saving the file.
If the selected encoding does not match the CSV file, special characters may appear incorrectly after upload.

How do I upload a CSV file and generate invoices?

Once you've finished preparing your CSV file, go to Számla / Tömeges számlázás (Invoice / Bulk Invoicing), then upload your file.

When uploading the file:

Select the CSV file you want to import.
Choose the same character encoding that was used when saving the file (UTF-8 or ISO-8859-2).
Add attachments if needed ("Csatolmányok").
Before continuing, select the checkbox to acknowledge that the Bulk Invoicing service fee will be charged based on the number of documents generated.
Click "Előnézet a számlákról" (Preview) to review the documents that will be generated. Check the data carefully.
If everything looks correct, click "Számlagenerálás" (Generate invoices).

After you start the invoice generation, the system validates the uploaded file. If any issues are detected, an error message indicates which row or field needs to be corrected. Update your CSV file, save it again, and repeat the upload.

If the validation is successful, a progress panel appears at the top of the page, where you can monitor the invoice generation process.
The information is refreshed approximately every 5 seconds, and you can leave the page at any time while the generation continues in the background.

What happens after I upload the CSV file?

When the process of uploading the Exel (CSV) file is complete:

the generated documents appear on page "Számla / Kimenő számláim" (Invoices / Outgoing invoices),
invoice notifications are sent if you've provided your customers' email addresses,
and you can download all generated documents as a single merged PDF.

Bulk Invoicing is available as a separate add-on service with all Számlázz.hu subscription plans, including #free. The service is billed separately using tiered pricing.