Skip to content

Beta recipe. External connectors depend on your AI provider and plan. Review and approve the invoice preview before anything is issued.

Bulk invoicing from a spreadsheet with an AI assistant

Recipe3 min read

For bulk invoicing, share a Google Sheets or Excel spreadsheet with your AI assistant. It can check each row and prepare the corresponding invoice in Zéró Számla. Review the details before approving issuance, then check NAV submission and delivery status. Approve each preview first; connector availability and permissions depend on your AI provider.

The situation

Fictional example: a self-employed coach invoices a sports club's membership fees to 40 families every six months. The list lives in Google Sheets: name, address, email, group and fee. Copying each row into the invoicing system used to take an entire evening.

The goal: prepare all 40 invoices from the spreadsheet in a single conversation.

What you need

  • An AI assistantthat supports custom connectors, such as Claude, ChatGPT, Le Chat or Grok, depending on the provider and plan.
  • Your spreadsheet. If your assistant can read spreadsheets through its Google Drive connector, you can give it the filename. Alternatively, download an XLSX or CSV file and upload it to the conversation.
  • The Zéró Számla connectorwith your NAV connection configured.

Step-by-step setup

  1. Add Zéró Számla to your AI assistantand configure your NAV connection.
  2. Clean up the spreadsheet. Use one row per invoice and separate columns for the customer's name, postcode, city, street, email address, item and price. Indicate whether prices include VAT in the column heading.
  3. Start with three rowsand inspect the resulting invoices before processing the full list.

Prompt to copy

Prepare an invoice in Zéró Számla for each row of the uploaded spreadsheet. Customer: name, address (country HU), email. Item: the text in the “group” column plus “membership fee, first half of 2026”; quantity 1; VAT-inclusive unit price from the “fee” column. VAT: [enter the VAT rate or exemption basis]. Skip rows with missing or suspicious data. Show a summary with totals and skipped rows. Do not issue invoices until I approve the preview.

What to check

  • NAV submission: check the invoice number and the final NAV submission status after issuance.
  • Delivery: check the invoice email address and delivery status, or download the PDF and send it yourself.
  • Payment reminders: review outstanding balances before sending any reminder; automated scheduling is not a beta promise.
  • Storage: invoices issued with Zéró Számla are stored for 8 years and remain searchable.

Things to watch for

  • VAT. Sports, educational and association activities may qualify for different VAT exemptions. Do not let your AI assistant decide the tax treatment: ask your accountant and include the exact exemption basis in the prompt.
  • Gross or net. If the spreadsheet contains VAT-inclusive prices, ask your assistant to calculate the net amounts. Compare the total in the summary with the spreadsheet total.
  • Accented characters. CSV imports can use the wrong character encoding. If characters look wrong, save the file again using UTF-8.
  • The same customer twice. If a family enrols two children, decide whether to use one invoice with two items or two separate invoices, and include that instruction in the prompt.

If you get stuck

If Zéró Számla rejects a field, read the error and correct the data before retrying. If NAV rejects a submission, investigate and correct the reporting error; do not blindly issue a second invoice. Check the existing invoice's NAV status first.

Frequently asked questions

How many invoices should I process at once?

For a long list, batches of 20–30 rows are easier to review. Track what has been prepared, issued or skipped, and respect the current service limits.

Can I use an Excel file?

Upload an XLSX or CSV file to the conversation if your AI assistant supports file uploads. CSV is a useful fallback when spreadsheet connectors are unavailable.

What if a row is incorrect?

Do not approve an invoice with incorrect or incomplete data. Ask your AI assistant to list skipped rows, then correct and process them separately.

Start with a preview.

Connect Zéró Számla and review the preview before you approve the first invoice.