A good journal template makes it hard to post a bad journal.
A journal entry template records the date, period, description, account, cost centre, debit, credit and supporting evidence for each line, plus who prepared and approved it. Build checks that block posting if debits and credits differ, if any line lacks an account or description, or if the preparer and approver are the same person.
| Column | Content |
|---|---|
| A | Account number |
| B | Account name (looked up from the chart of accounts) |
| C | Cost centre or department |
| D | Line description |
| E | Debit |
| F | Credit |
Look up the account name from a chart of accounts sheet, so a mistyped account number shows as an error immediately:
=IFERROR(XLOOKUP(A10,COA!A:A,COA!B:B),"INVALID ACCOUNT")
Balanced: =ROUND(SUM(E10:E60)-SUM(F10:F60),2)=0
No line with both a debit and a credit: =COUNTIFS(E10:E60,"<>0",F10:F60,"<>0")=0
Every line has an account and description: =COUNTIFS(E10:E60,"<>0",A10:A60,"")+COUNTIFS(F10:F60,"<>0",A10:A60,"")=0
No invalid accounts: =COUNTIF(B10:B60,"INVALID ACCOUNT")=0
Preparer isn't approver: =PreparedBy<>ApprovedBy
Ready to post: an AND of all the checks above. Show it in large text at the top: READY or NOT READY.
The manual journal controls guide covers the risks journals carry and how to review them after posting.
Mark reversing journals clearly and check next month that the reversal posted. Keep recurring journals on a separate list with an owner and an end date, so they don't run forever. See accruals and prepayments.
Lock the formula cells and the check cells, so nobody can overwrite a check to make a journal look ready. Keep the master template in one shared location and copy it for each journal, rather than editing last month's file. Save completed journals with the journal number in the file name, and keep them with the period's close documents. A consistent naming pattern makes it easy to find any journal an auditor asks about, months later.
The template is the same in both countries. Auditors in both look for evidence of review and approval of manual journals, particularly those posted near period end.
Risk-ranks every journal entry with an on-device AI and 17 audit tests, catches descriptions posted to the wrong account, runs Benford's law and selects a repeatable sample. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
They often have to be, for accruals and adjustments, but late journals carry more risk. Give them a second review, and question any journal posted after the reconciliations were signed off.
For as long as your accounting records must be kept under local law and company policy, which is several years in most countries. Keep the evidence with the journal.
Date, period, description, accounts, cost centres, debits, credits, supporting evidence, and who prepared and approved it.
Every manual journal should be approved by someone other than the preparer. System-generated postings are controlled through the system instead.
So a mistyped account number shows as invalid immediately, instead of being posted to the wrong or a non-existent account.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.