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?
- Go to Accounting and then Entry templates.
- Click New template, at the top right. A window opens with the editor; to leave, use the × or Close.
- Give it a name you will search for it by (‘Monthly payroll’). It can’t be repeated.
- Type the description you want to be suggested for the journal entry.
- 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:
| Way | When it is used | Example |
|---|---|---|
| Fixed | The amount is always the same | Rent of 850 € |
| Prompted | It changes every month and you type it when applying | The tax base of the electricity bill |
| Percentage of another line | It comes from another line in the same template | VAT, 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. | Account | Side | Amount | Label |
|---|---|---|---|---|
| 1 | 62900001 Utilities | Debit | Prompted | Tax base |
| 2 | 47200000 Input VAT | Debit | 21 % of line 1 | — |
| 3 | 40000001 Supplier | Credit | Prompted | Invoice 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?
- Go to the Journal.
- Click Template in the top bar.
- Choose the template from the list.
- Fill in the amounts it asks for, each one with its label.
- 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 see | What has happened | What to do |
|---|---|---|
| ‘A template needs at least two lines’ | You have only added one | A one-line journal entry can’t balance: add the contra line |
| ‘… takes the percentage of a later line’ | The reference points downwards | Move it, or refer to a line above |
| ‘All lines are percentages’ | There is nothing to start from | At least one must be fixed or prompted |
| ‘There is already a template called …’ | The name is repeated | Give it another: the name is what you search for when applying it |
| ‘Line … has no amount’ | You left a gap empty | Fill in all the amounts it asks for |
| The journal entry comes out unbalanced when applying it | The amounts you typed don’t balance with each other | Check them; the journal lets you correct it before saving |
See also: Make a manual journal entry · Find and correct journal entries
More about Accounting
- How do I depreciate fixed assets?
- How do I find a journal entry and correct it?
- How do I close and open the financial year?
- How do I view an account’s general ledger?
- How do I add a ledger account?
- How do I define the line items of the balance sheet and the income statement?
- How do I make a manual journal entry?
- How do I print or export what I see in accounting?
- How do I assign costs by department and by project?
- Keeping the accounts
- How do I write the notes to the annual accounts?
- What is the accounting dashboard?