Excel to Entera - new way of importing documents to Entera. It makes easy to upload lots of documents almost in one click. Useful for those working with table format or upload table format from another program.
Before upoading check
File Mandatory file requirements:
Formats: .xls, .xlsx, .csv
.xls and .xlsx are formats for Excel
Maximum 1 000 rows per file
1-sheet file
You can upload any table, we don’t have any compulsory template to follow
You can upload only 1-list Excel file
To catch table headers and data for example column Entera scans 5 first rows. So in first 5 rows file should contain at least header.
Don’t forget that you can work in matching only with 100 rows at once. So it’s impossible to upload a table on 1 000 row and then match them all at once. In this case you neeed to import documents without further matching, and then export docs to matching from portal, as usual.
Table example (not obligatory): https://docs.google.com/spreadsheets/d/1Md6IcD72KcqsxIK4Y0tQnmUeWXzji5LJ/edit?usp=drive_link&ouid=104545087358632908376&rtpof=true&sd=true
Fields we recognize - see in 'Full list of fields we recognize' chapter
Entera remembers all headers that’ve been recognized. So when you recognize the table with the same headers next time - headers wll be automatically matched.
...
Full list of fields we recognize
Signed with * - obligatory:
Column name in Entera | Definition | Comment |
|---|---|---|
Document number* | Document number | |
Document type | Type of uploded document | We recognise invoices and tax invoice. If there is something different from these types, by default will be tax invoice (VAT invoice) |
Document date* | Document date in ISO formatIf date format is different from ISO, Entera will automatically rewrite it in ISO format | |
Supplier name | Supplier company name | |
Customer name | Customer company name | |
Supplier ID | Supplier Tax ID/GSTIN | |
Customer ID | Customer Tax ID/GSTIN | |
Supplier address | Company address in plane text format | Depicted in Company address field name in matching |
Customer address | Company address in plane text format | Depicted in Company address field name in matching |
Item name | Item name | |
Item code | HSN, SAC | |
Quantity | Amount of items | |
Price | Price per item | |
Item amount without tax | Item amount without tax | |
Item amount | Price * quantity sum, inluding taxes | |
IGST | Tax rate, % | If there are more than 2 tax rates in these fields for a document or an item at once, it won’t be recognized |
SGST | Tax rate, % | |
CGST | Tax rate, % | |
Vat rate | Tax rate, % for UAE | |
Tax | This field contains amount of tax for each tax, it should be chosen for each tax value column, so it will be the same for SGST, CGST, IGST | |
Batch number | ||
Expiry date | ||
Location | ||
Item category | ||
Round off | Round off amount | |
TCS | TCS amount | |
TDS | TDS amount | |
Unit | Units of measure | |
Document sum without tax | Document sum without tax, Round off, TCS nd TDS | |
Document sum | Document sum with tax, Round off, TCS nd TDS | |
Comment | Document comment |
...