Cash entry templates

DMF 070722 ACCOUNTING SETUP CASH ENTRY TEMPLATE

During the bank reconciliation, statements can include transactions that regularly come back and that will never generate a cash movement because it does not settle an invoice, for example account fees or loan payments.

In this case, it is possible to associate a cash entry template with a non-reconciled line in a statement. Each entry template is set up with one or several accounts so that entries can be directly generated in the accounting. Each template can be associated with a bank statement reference to help Akuiteo automatically link a non-reconciled statement line to an entry template.

The setup of cash entry templates can be accessed from General setup > Accounting > Cash entry templates.

The setup screen displays the setup for the company of the connected user. Cash entry templates can also be set up for the ***** company so they are available for all companies.

Click on in the action bar to create a new template or double-click on a template to open its record sheet.

To set up a new cash entry template, fill in the following fields:

Field Description
Code Give a unique code to the cash entry template.
Title Fill in the label of the cash entry template.
End date If needed, enter a validity end date. After this validity date has passed, the template can no longer be used.
Bank statement reference

Fill in a reference to automatically associate the cash entry template with statement lines.

During the import of a bank statement, a match is searched between the Bank statement reference of the template and the Label, wording (cont.), Comment, Discount reference and Sold-to-party account columns of the non-reconciled lines. If a match is found, the template will be entered in the Entry template column.

To add accounts to a template, click on at the top right of the Details section when the template is being modified, then fill in the following fields:

Field Description
Account and Label

Select the account from the help list. The Label associated with the account is directly filled in.

Project, Phase and Sub-phase Enter the project, phase and sub-phase from the help list.
Document Specify the document associated with the account.

Important

If you add several accounts to a cash entry template, it cannot be used to generate multiple entries at once. It will only be possible to generate single entries since you must break down the amount of the cash movement over the different accounts.

Note

The information of each account line is automatically specified in the entries generated from the template.