Manual Journal Templates

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

Select GL / Manual journal templates from the Settings 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 enter Manual journal templates in the Quick Launch Side Menu.

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 on the top right of the page, 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 icon.

  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

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 March 2026