Set up a repeating journal

Set up a repeating journal in Xero if you want to automate a series of recurring journal entries. You can insert placeholders into your repeating journal for values which depend on the date your repeating journal is created, for example, "Consulting fees for [Month-1]".

See also:

Video: Repeating journals with dynamic date placeholders (1:00)

Image showing repeating journal

About repeating journals

Information. Choose how often you want Xero to record a repeating journal. For example, you might want to choose weekly, monthly or every 3 months. If you choose a month-end date, Xero records your repeating journals at the end of each month. For example, if you set up a repeating monthly journal starting 30 June, Xero records the next journal in the series at 31 July, not 30 July.

Information. Decide if you want Xero to post each journal or save each one as a draft for you to approve. You may want to post your journals if the journal amount is the same for each journal. For example, select 'Post' if you're spreading out an annual prepaid expense. Or, you may want to save each journal as a draft if it's likely you will need to change the journal amount each time, for example, if you're accruing month-end interest expense.

Information. If you save your repeating journal as a draft you can later change it to 'Post'. However, once you've selected 'Post' you can't change to 'draft'.

Information. You're able to backdate your repeating journals.

Information. You can edit your repeating journals, but be aware if you roll back the first journal date, Xero creates a new set of journals in addition to your existing ones.

Information. View all the repeating journals set up for your organisation from the 'Repeating' tab on the Manual Journals screen.

How to create a repeating journal

  1. Go to Adviser > Manual Journals.

  2. Click + New Repeating Journal.

  3. Choose the dates and time period for your repeating journal.

  4. Select Save as Draft or Post.

    If you select Post, be aware that you won't be able to delete your repeating journals in bulk. That is, if you need to delete your repeating journals, you will need to void them one by one.

  5. Enter information into the manual journal fields.
    Manual journal details explained

  6. (Optional) Add placeholders to your Narration and Description fields

  7. Save.

If you have an existing manual journal that you would like to convert to a series of repeating journals, simply open the journal and select Repeat from the Journal Options drop-down.

Add placeholders to your Narration and Description fields

Placeholders are named markers where content will appear when a repeating journal is generated. The value of the placeholder will depend on the date your repeating journal is generated. You can have more than one placeholder in a field.

Place your cursor in the Narration or Description field to see the Insert Placeholder link. Click the link to select the placeholder option.

Image showing placeholders available.

Week calculations follow the ISO 8601 standard. Week 1 starts on Monday and always includes the first Thursday of the new year. The last week of the year will be either 52 or 53.

You can add or subtract within the placeholder to change the placeholder value. For example, [Month-1] will display the previous month to the repeating journal month.

Click Preview placeholders to see how your placeholders will appear in your journals.