Manual Journal Templates

Note

To view the legacy version, please select Legacy User Guide.

Manual journal templates are pre-designed formats used to record financial transactions manually in accounting. These templates help ensure that all necessary information is captured consistently and accurately. Here are some key points about manual journal templates:

  • Structure: They typically include fields for the date, account names, debit and credit amounts, and a description of the transaction.

  • Consistency: Using a template helps maintain uniformity in recording transactions, which is crucial for accurate financial reporting.

  • Efficiency: Templates save time by providing a ready-made format, reducing the need to create a new layout for each entry.

  • Accuracy: They help minimize errors by ensuring that all required information is included.

How to view Manual Journal Templates

Viewing Manual Journal Templates

As per Generic Navigation options, either from left-hand navigation panel, expand Settings and select Manual journal templates from the GL folder or enter Manual journal templates in the Search option.

This will then show the Manual journal templates on the system where normal customisation of Sets can be used.

Tip

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

How to create a Manual Journal Template

Create a Manual Journal Template

  1. Select Manual journal templates from one of the options as shown above in Viewing Manual Journal Templates.

  2. Select New.

  3. Select a template, followed by Create.

  4. Add appropiate data to the following fields.

  5. At least one entry must be entered on the Lines tab and Description, Tax band and Tax code are required.

  6. Select Submit to complete creation of new template.

How to Import Manual Journal Templates

Importing Manual Journal Templates

  1. Select Manual Journal Templates from one of the options as shown above in Viewing Manual Journal Templates.

  2. Select Manual journal templates import from the option.

  3. Enter the filename to Import.

  4. Select Submit.

    Selecting Queue from the dropdown option will queue the import process until other actions in iplicit are completed.

    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.

Manual Journal Upload Example

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

doc_type,doc_no,import_doc_ref,batch_description,period,legal_entity,account,doc_description,description,currency,currency_rate,doc_date,tax_date,currency_amount,tax_code,tax_rate,tax_currency_amount,post.Department,post.BankAccount,BankAccount,bank_currency_rate,PartialTaxIgnore
MJ,,1,Partial Tax Ignore Test,202612,PARTLEGE,6260,Partial Tax Ignore Test,Partial Tax Ignore Test,GBP,1,01/02/2026,01/02/2026,-1000,0,0,0,CSRV,,,,TRUE
MJ,,1,Partial Tax Ignore Test,202612,PARTLEGE,6270,Partial Tax Ignore Test,Partial Tax Ignore Test,GBP,1,01/02/2026,01/02/2026,1000,0,0,0,CSRV,,,,TRUE
MJ,,2,Partial Tax Ignore Test,202612,PARTLEGE,6260,Partial Tax Ignore Test,Partial Tax Ignore Test,GBP,1,01/02/2026,01/02/2026,-500,0,0,0,CSRV,,,,TRUE
MJ,,2,Partial Tax Ignore Test,202612,PARTLEGE,6270,Partial Tax Ignore Test,Partial Tax Ignore Test,GBP,1,01/02/2026,01/02/2026,500,0,0,0,CSRV,,,,TRUE

Updated August 2026