Skip to content

How do I use entry templates?

An entry template holds the lines of a journal entry that repeats every month —payroll, rent, the electricity bill—, saved so you don’t have to type them again. When you apply it, the journal entry appears ready-made in the journal, and you review it and save it.

What exactly does it save me?

The rent journal entry is always the same: the same accounts, the same side, the same withholding percentage. Typed by hand, that is twelve times a year, and each time is a chance to pick the wrong account.

How do I create a template?

  1. Go to Accounting and then Entry templates.
  2. Click New template, at the top right. A window opens with the editor; to leave, use the × or Close.
  3. Give it a name you will search for it by (‘Monthly payroll’). It can’t be repeated.
  4. Type the description you want to be suggested for the journal entry.
  5. Add the lines. Each one needs:
    • The account.
    • The side: Debit or Credit.
    • Where its amount comes from (see below).
    • An optional label, which is the caption you will be asked for the amount with.

A template needs at least two lines: a journal entry with only one can’t balance.

Where does each line’s amount come from?

There are three ways, and with them you can build almost any recurring journal entry:

WayWhen it is usedExample
FixedThe amount is always the sameRent of 850 €
PromptedIt changes every month and you type it when applyingThe tax base of the electricity bill
Percentage of another lineIt comes from another line in the same templateVAT, which is 21 % of the tax base

Percentage lines can only refer to an earlier line. That is what lets you calculate ‘VAT = 21 % of the tax base’ without ambiguity, and that is why the drop-down only offers you the ones above.

At least one line must have a fixed amount or be prompted: if they were all percentages, the template would have nothing to start from.

Example: the utilities invoice

No.AccountSideAmountLabel
162900001 UtilitiesDebitPromptedTax base
247200000 Input VATDebit21 % of line 1—
340000001 SupplierCreditPromptedInvoice total

When you apply it, it asks you for two amounts —the tax base and the total—, calculates the VAT by itself and builds the journal entry.

How do I apply a template?

  1. Go to the Journal.
  2. Click Template in the top bar.
  3. Choose the template from the list.
  4. Fill in the amounts it asks for, each one with its label.
  5. Confirm.

The journal entry appears ready-made in the journal, with its accounts, its amounts and its description.

Is it posted automatically?

No, and that is on purpose. The journal entry stays in editing, ready but unsaved. You review it, change whatever is needed —the date, an amount, the description— and you save it yourself.

A template that posted itself would be dangerous: the month the account changed or the amount wasn’t the usual one, the error would repeat without anyone looking at it.

Can I change a template?

Yes, and you can also delete or reorder its lines. If you delete a line in the middle, the others are renumbered and the percentage references adjust themselves so they keep pointing to the same line.

What if I don’t use it any more?

Untick it as active. It stops appearing when you apply templates, but it is kept. You can also delete it completely: a template leaves no accounting trace, and the journal entries you made with it are normal journal entries that don’t depend on it.

If something goes wrong

What you seeWhat has happenedWhat to do
‘A template needs at least two lines’You have only added oneA one-line journal entry can’t balance: add the contra line
‘… takes the percentage of a later line’The reference points downwardsMove it, or refer to a line above
‘All lines are percentages’There is nothing to start fromAt least one must be fixed or prompted
‘There is already a template called …’The name is repeatedGive it another: the name is what you search for when applying it
‘Line … has no amount’You left a gap emptyFill in all the amounts it asks for
The journal entry comes out unbalanced when applying itThe amounts you typed don’t balance with each otherCheck them; the journal lets you correct it before saving

See also: Make a manual journal entry · Find and correct journal entries

More about Accounting