File specifications for batch import of invoices

Developer Guide / Import / Export data / File specifications for batch import of invoices

Templates of invoice for payment

1) Simplified invoice template
2) Invoice template with VAT details
3) Extended invoice template

File format specifications for batch import of invoices

You can enter from 1 to 100 invoices per import iteration.

1) Simplified invoice template:
1.1) Fields specification in imported invoice files for batch mode

* - mandatory field

Column name	Field description	Data type	Value range and comment
Buyer IDNO *	IDNO (IDNP) code of the payer	String	7 or 13 digit string
Item *	Internal serial number of the product/service	Integer	From "0" and further in order
Name *	Name of the product/service	String	Any line up to 255 characters
Unit Price *	Price per unit of the product/service	Floating point number	> 0.00 and <= 1 000 000.00
Quantity *	Quantity of products/services	Integer	From 1 to 1 000 000

1.2) JSON file structure

{
    "0": {
        "Buyer IDNO": "",
        "Items": {
            "0": {
                "Name": "",
                "Unit Price": "",
                "Quantity": ""
            }
        }
    }
}

2) Invoice template with VAT details:
2.1) Fields specification in imported invoice files for batch mode

* - mandatory field

Column name	Field description	Data type	Value range and comment
Buyer IDNO *	IDNO (IDNP) code of the payer	String	7 or 13 digit string
Item *	Internal serial number of the product/service	Integer	From "0" and further in order
Name *	Name of the product/service	String	Any line up to 255 characters
Unit Price *	Price per unit of the product/service	Floating point number	> 0.00 and <= 1 000 000.00
Quantity *	Quantity of products/services	Integer	from 1 to 1 000 000
TVA Rate	VAT rate per invoice item	Integer	Rate in %. Can be: 0, 8, 12 or 20
Calc TVA	Method of calculating VAT per the invoice item	String	One of the values: "none" - without VAT "zero" - zero VAT rate "inner" - price includes VAT "over" - price does not include VAT

2.2) JSON file structure

{
    "0": {
        "Buyer IDNO": "",
        "Items": {
            "0": {
                "Name": "",
                "Unit Price": "",
                "Quantity": "",
                "TVA Rate": "",
                "Calc TVA": ""
            }
        }
    }
}

3) Advanced invoice template:
3.1) Fields specification in imported invoice files for batch mode

* - mandatory field

Column name	Field description	Data type	Value range and comment
Invoice Number	Invoice number	String	Any string up to 50 characters long
Buyer IDNO *	IDNO (IDNP) code of the payer	String	7 or 13 digit string
Amount	Amount to be paid	Floating point number	> 0.00 and <= 10 000 000.00
Currency	Invoice currency	String	Always "MDL"
Buyer TVA	Payer VAT code	String	7 digits
TVA Amount	Total VAT amount by invoice	Floating point number	> 0.00 and <= 2 000 000.00
wTVA Amount	Total amount without VAT by invoice	Floating point number	> 0.00 and <= 8 000 000.00
Status	Status	String	Acceptable statuses: "draft", "actual". When importing an invoice, the status is always reset to "draft".
Date	Invoice date	Date	Official invoice date
Due On	Invoice valid until	Date	Invoice expiration date
Buyer	Payer name	String	Registered name of the payer
Buyer E-Mai	Payer contact email	String
Buyer Phone	Payer contact phone number	String	Telephone number in international format - 16 digits
Reference	Reference document name	String	e.g., Tax invoice number
Remarks	Custom comments	String	e.g., Payment purpose (briefly)
Topic	Description of the service (for some templates)	String
Invoice Template	Name of the invoice template	String	Could be: "goods", "services", "freelance", "simple" или "proforma"
Language	Invoice language	String	"ro", "ru" или "en"
Item *	Internal serial number of the product/service	Integer	From "0" and further in order
Name *	Name of the product/service	String	Any line up to 255 characters
Unit Price *	Price per unit of the product/service	Floating point number	> 0.00 and <= 1 000 000.00
Quantity *	Quantity of products/services	Integer	From 1 to 1 000 000
Unit	Unit of measurement	String	A free string of up to 20 characters ("pcs.", "pcs", etc.)
TVA Rate	VAT rate for the invoice item	Integer	Rate in %. Can be: 0, 8, 12 or 20
Calc TVA	Method of calculating VAT for the invoice item	String	One of the values: "none" - without VAT "zero" - zero VAT rate "inner" - price includes VAT "over" - price does not include VAT
Total wTVA	Amount without VAT by invoice item	Floating point number	> 0.00 and <= 8 000 000.00
Total TVA	VAT amount by invoice item	Floating point number	> 0.00 and <= 2 000 000.00
Total Price	Total by invoice item	Floating point number	> 0.00 and <= 10 000 000.00
TVA Details	VAT details by invoice item	Integer	Could be: - 0 - do not show VAT details in the line - 1 - show VAT details in the line

3.2) JSON file structure

{
    "0": {
        "Number": "",
        "Buyer IDNO": "",
        "Amount": "",
        "Currency": "",
        "Buyer TVA": "",
        "TVA Amount": "",
        "wTVA Amount": "",
        "Status": "",
        "Date": "",
        "Due On": "",
        "Buyer": "",
        "Buyer E-Mail": "",
        "Buyer Phone": "",
        "Reference": "",
        "Remark": "",
        "Topic": "",
        "Pattern": "",
        "Language": "",
        "Items": {
            "0": {
                "Name": "",
                "Unit Price": "",
                "Quantity": "",
                "Unit": "",
                "TVA Rate": "",
                "Calc TVA": "",
                "Total wTVA": "",
                "Total TVA": "",
                "Total Price": "",
                "TVA Details": ""
            }
        }
    }
}

Changed: 24.10.2024 23:23