Document Imports

• Documents created on other software can be imported into the system e.g. you may use another software for payroll on a monthly basis, however that needs to be imported into the system for accounting purposes.

• Templates must be setup to import document, this will usually be done during implementation. If this has not happened or you need a new template, please contact support@iplicit.com.

How to view Document imports

Viewing a Document Import

Select GL / Import from the Main section of the pulse menu -

Note

This is an example screen shot of the pulse menu.

Position of the menu items within pulse will vary according to available options and dependant on personal screen resolution.

or from the Main Menu select GL then Import -

or enter Document Import in the Quick Launch Side Menu.

This will then show the Document imports on the system where normal customisation of Sets can be used.

• Status: The status of the document import e.g. draft.

• Batch no: The batch number.

• Description: This is a description of the document being imported

• Last modified: When the document import was last modified.

  Tip

  To modify the columns displayed, select on the top right of the page, then tick/untick the information you want to hide or display.

How to create Document Imports

Create a new document import

1. Select Document imports from one of the options as shown above in Viewing Document imports.

2. Press New.

   

3. Select the Document type that you would like to import and select Apply.

   

4. Fill out the document import information.

   

   • Input file: select the file that you would like to import.

   • Import Description: Enter a description of the import to be logged in the finder.

   • Legal entity: Select the Legal entity that you would like the imported document to logged under.

   • Document type: Select the Document type e.g. sales invoice.

   • Period: Select the Period that you would like the document to be logged in.

   • Currency: select the Currency of the document.

   • Exchange rate: Select the Exchange rate.

   • UOM: Select the Unit of measurement.

5. Apply default values: Use account defaults where not populated in the import file.

   • When this option is selected, if the import values are blank then the values will use the above default values.

   • When this option is not selected, if import values are blank then they will be imported as blank.

6. Press Import.

   Warning

   iplicit allows a maximum of 5,000 rows in a single Import.

   If your Import is too large, an error message will tell you that the Import cannot be processed and will advise you to create smaller Import files.

   If the latter is not possible, please contact Customer support.

7. Once Import has completed, then a new document in Imports will be created.

Examples:

Note

Please only contact support if you need customisation or guidance with the import templates below.

• Purchase Invoices
• Purchase Orders
• Expenses
• Manual Journals
• Cashbooks
• Contact Customer
• Payment Batch
• Receipt Batch

Download file - Purchase Invoice Example - Save the resulting .csv file on your local storage, then select the downloaded file to open as an Excel file.

b.description,h.doc_no,h.doc_serie,h.doc_type,h.legal_entity,h.contact_account,h.trans_no,h.description,h.doc_date,h.period,h.payment_terms,h.due_date,h.tax_date,h.currency,h.currency_rate,h.base_currency,h.account,h.their_doc_no,d.description,d.tax_date,d.tax_rate,d.net_currency_unit_price,d.gross_currency_unit_price,d.uom,d.quantity,d.net_amount,d.gross_amount,d.tax_amount,d.line_no,d.net_currency_amount,d.tax_currency_amount,d.gross_currency_amount,d.account,d.currency,d.currency_rate,d.tax_band,d.tax_code,d.post.department,d.deferred.disabled,d.deferred.profile,d.deferred.date_from,d.deferred.date_to,d.deferred.periods,d.partial_tax_ignore
Purchase Batch Import,1,DTO_PIN,PIND,PARTLEGE,11320,1,1,01/10/2023,202310,60,01/10/2023,01/10/2023,GBP,1,GBP,2210,2310-22,Consultancy,01/10/2023,20,600,720,EA,1,600,720,120,1,600,120,720,10998,GBP,1,S,SP,ADM,1,,,,,TRUE
Purchase Batch Import,2,DTO_PIN,PIND,PARTLEGE,11320,2,2,01/10/2023,202310,60,01/10/2023,01/10/2023,GBP,1,GBP,2210,2310-23,Consultancy,01/10/2023,20,600,720,EA,1,600,720,120,1,600,120,720,10998,GBP,1,S,SP,ADM,1,,,,,1
Purchase Batch Import,3,DTO_PIN,PIND,PARTLEGE,11320,3,3,01/10/2023,202310,60,01/10/2023,01/10/2023,GBP,1,GBP,2210,2310-24,Consultancy,01/10/2023,20,600,720,EA,1,600,720,120,1,600,120,720,10998,GBP,1,S,SP,ADM,1,,,,,FALSE
Purchase Batch Import,4,DTO_PIN,PIND,PARTLEGE,11320,4,4,01/10/2023,202310,60,01/10/2023,01/10/2023,GBP,1,GBP,2210,2310-25,Consultancy,01/10/2023,20,600,720,EA,1,600,720,120,1,600,120,720,10998,GBP,1,S,SP,ADM,1,,,,,0
Purchase Batch Import,5,DTO_PIN,PIND,PARTLEGE,11320,5,5,01/10/2023,202310,60,01/10/2023,01/10/2023,GBP,1,GBP,2210,2310-26,Consultancy,01/10/2023,20,600,720,EA,1,600,720,120,1,600,120,720,10998,GBP,1,S,SP,ADM,1,,,,,T

Updated June 2026