Manual journals in Xero: how to post, reverse, repeat and import them, with accrual and prepayment examples
Manoj Tutika · Published 17 November 2026 · Last checked 17 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
What is a manual journal in Xero?
A manual journal is a journal entry you post straight to the general ledger, without a source document such as an invoice or bill behind it. In Xero it is the tool for adjustments: accruals, prepayment releases, depreciation for assets outside the register, payroll from an external bureau, reclassifications and corrections.
Most day-to-day transactions should not be journals. Sales go through invoices, purchases through bills and bank items through reconciliation. Journals are for what is left at month end.
You need the administrator role, or the standard role with the manual journals permission, to add and post them. A user with the viewer role can only look at them.
How to post a manual journal in Xero
- In the Accounting menu, select Manual journals.
- Click New manual journal entry.
- Enter a narration. It is mandatory, it becomes the journal title in the list and on the Journal Report, so make it searchable, for example "Oct 2026 accrual, electricity".
- Pick the date. This is the date the journal hits the ledger.
- Add the lines with account, description, tax rate, tracking if you use it, and a debit or credit amount.
- Check the totals. Xero will not post a journal until debits equal credits.
- Click Post, or use the arrow to save as draft or post and add another.
Draft journals do not affect the ledger. You can tick several drafts on the Draft tab and post them together, which suits a reviewer who approves the month's adjustments in one sitting.
Settings worth knowing on the journal screen
- Tax inclusive or tax exclusive. Choose whether line amounts include VAT. If you select a VAT rate on a line, Xero posts the VAT to the VAT account when you post, so the journal flows into your VAT return. For most month-end adjustments you want the No VAT rate.
- Show journal on cash basis reports. Tick this only if the journal should appear on cash-based reports such as the Statement of Cash Flows.
- Auto-reversing date. Optional. Pick a future date and Xero posts the exact reverse of the journal on that date.
- Tracking. If you track only one side of a journal, Xero balances it through the Tracking Transfers system account. Track both sides when you want branch or department reports to stay complete.
Which accounts can you not journal to?
Xero blocks manual journals to several system accounts. The most important are Accounts Receivable and Accounts Payable: you cannot journal directly to the debtors or creditors control account.
| System account | Manual journals allowed? |
|---|---|
| Accounts Receivable | No |
| Accounts Payable | No |
| Bank Revaluation | No |
| Current Earnings | No |
| Tracking Transfers | No |
| Unrealised Currency Gains | No |
| Unpaid Expense Claims | No |
| Wage Payables | No |
| VAT | Yes |
| Historical Adjustments | Yes |
| Realised Currency Gains | Yes |
| Retained Earnings | Yes |
| Rounding | Yes |
If you need to move a balance in or out of debtors or creditors, raise a credit note or an invoice against the customer or supplier instead, so the contact's balance and the aged reports stay right. Where you genuinely need a journal next to a system account, Xero's own advice is to add a secondary balance sheet account of the same type, journal to that, and group the two on a custom Balance Sheet layout.
For anything that moved cash, use spend money, receive money or a bank transfer instead of a journal, so the entry can be matched to the bank statement line.
If you use multicurrency, manual journals can only be entered in your base currency.
Accruals with an auto-reversing date
An accrual books a cost in the month it was incurred when the supplier's bill has not arrived yet. The classic pattern is a journal at month end that reverses on the first day of the next month. Xero's auto-reversing date does the second half for you.
Worked example. October electricity is estimated at £1,200 before VAT. The bill will come in November.
| Account | Debit (£) | Credit (£) | VAT rate |
|---|---|---|---|
| Electricity | 1,200.00 | No VAT | |
| Accruals | 1,200.00 | No VAT |
On 1 November Xero posts the reverse: debit Accruals £1,200, credit Electricity £1,200. When the real bill arrives on 12 November for £1,260 plus VAT, you enter it as a bill dated 12 November. November's electricity line shows £1,260 less the £1,200 reversal, so only the £60 under-estimate lands in November. October carries the £1,200 it consumed. The VAT is reclaimed on the real bill, which is why the accrual uses No VAT.
Two cautions from Xero Central. Editing the original journal does not update its reversing journal, so fix both by hand. And if you edit a posted journal, Xero reverses the original and posts a new journal with a new ID; all three show on the Journal Report.
More on the method, including how to estimate accruals, is in accruals: how to book them and automate them.
Prepayments with a repeating journal
A prepayment works the other way: you paid in advance and release the cost month by month. Xero's repeating journal handles the release.
Worked example. On 1 October the company pays £3,600 for twelve months of insurance. The bill is coded to a Prepayments asset account. Each month £300 moves to the profit and loss.
- In the Reporting menu, open the Journal Report and click Go to manual journals.
- Click New Repeating Journal.
- Set the first journal date to 31 October 2026, repeat every 1 month, and the end date to 30 September 2027.
- Choose Post if the amount never changes, or Save as Draft if someone should check each one.
- Add the lines: debit Insurance £300, credit Prepayments £300, both No VAT.
- Click Save.
Twelve releases of £300 clear the £3,600 exactly. Because the first date is a month end, Xero keeps every journal on the month end, so November's lands on 30 November and December's on 31 December.
Three rules from Xero Central are worth knowing before you rely on repeating journals:
- A repeating journal set to Post cannot be switched back to Save as Draft.
- Posted repeating journals cannot be voided in bulk. Each one has to be voided separately.
- If you edit the schedule and roll back the next journal date, Xero creates a new set of journals on top of the existing ones.
Placeholders help with narration. Typing [Month] in the narration fills in the month of each generated journal, so the November release reads "Insurance release November" without editing.
You can also turn an existing journal into a repeating one from the Journal Options menu on that journal, by choosing Repeat.
Importing manual journals from CSV
For payroll from an outside bureau or a batch of year-end adjustments, importing is faster than typing.
- In the Accounting menu, select Manual journals, then click Import.
- Click Download template file. Do not change the column headings, or the import fails.
- Fill in Narration, Date, Description, AccountCode, TaxRate, Amount and, if you track, TrackingName and TrackingOption.
- Enter debits as positive amounts and credits as negative.
- Put the narration and date only on the first row of each journal. Rows with both left blank join the journal above.
- Save as .csv, browse to the file, click Import and then Complete Import.
A template file can hold up to 300 lines. Imported journals arrive as drafts, so someone still reviews and posts them. Use the account code only, not the name, and enter the VAT rate exactly as it is named in your Xero settings.
Finding and reviewing journals
The Journal Report under All reports lists every journal for a date range, including system-generated ones from invoices and bills. Filter it to posted manual journals only when you review the month's adjustments, and filter by tracking category if you need to see one branch.
A short review routine at each close catches most problems: every journal has a clear narration, nothing has VAT on it that should not, accruals have a reversing date, and nothing has been posted into a locked period. For the last point, see lock dates in Xero.
Where an agent fits
Most month-end journals in a small company are the same each month with different amounts: accruals for bills that are late, prepayment releases, payroll from the bureau's report and recharges between branches. Thred's agents prepare those journals in Xero from the underlying documents, with the narration, tracking and reversal date set, and leave them as drafts for a person to post. The reviewer sees the evidence next to each line instead of rebuilding the calculation.
Frequently asked questions
How do I do a manual journal in Xero?
In the Accounting menu, select Manual journals, then New manual journal entry. Enter a narration and date, add lines with accounts and debit or credit amounts that balance, choose the VAT rate per line, then click Post or save as draft.
How do I reverse a manual journal in Xero?
For a new or draft journal, set an auto-reversing date and Xero posts the reverse on that date. A journal that is already posted can be reversed from the journal itself; check the reversal date before you confirm, because it decides which month takes the adjustment.
Can you journal to accounts receivable in Xero?
No. Accounts Receivable and Accounts Payable are system accounts that do not accept manual journals. Use an invoice or credit note against the contact, or journal to a secondary balance sheet account of the same type.
How many lines can I import in a Xero manual journal template?
Up to 300 lines in one CSV template file. Imported journals arrive as drafts, which you then review and post.
Can a repeating journal in Xero auto-reverse?
No auto-reversing date is offered on repeating journals in the steps Xero documents. Use repeating journals for amounts released each month, such as prepayments, and single journals with an auto-reversing date for accruals.
Should a manual journal have VAT on it?
Usually not. A VAT rate on a journal line posts VAT to the VAT account and into the VAT return. Month-end accruals and prepayment releases normally use No VAT, because VAT is handled on the real invoice or bill.
Sources
- Xero Central, Add, import and post manual journals
- Xero Central, Set up a repeating journal
- Xero Central, View, edit or copy a manual journal
- Xero Central, Locked and system accounts in your chart of accounts
Read next
- Accruals: how to book them, with examples, and how to automate them
- Month-end close checklist for Xero: the steps, checks and who does what
- Year end in Xero: lock dates, adjustments, unlocking and UK filing deadlines
- Journal entry
- Suspense account in Xero: how to create, use, clear and reconcile it, with a worked example
Where Thred comes in
For finance leaders who want more capacity without more headcount.
