How do I set up repetitive journals?

Summary

This article explains how to set up repetitive or recurring journals.

More Information

Repetitive or frequent transactions can be set up in the Nominal Ledger. They will be posted automatically for you based on the posting date and frequency.

Regular postings need to be of a fixed value. This option is particularly useful for HP postings, Depreciation, Accruals, Prepayments and any other fixed value items.

Go to " Nominal Ledger Maintenance Options Regular Postings".

• Click [Add] to add a new journal.
• Enter a "Posting Code". This is simply a unique code that you use to differentiate between journals, e.g. 'A00001'.
• Enter a brief description for the posting.
• Enter the frequency of the posting.
  • "Posts every" depends on whether you select 'Months' or 'Days' from the dropdown option.
  • If you choose 'Months' enter the 'Day' on which the posting should be made.
• Enter the 'Last posted' date. This defaults to the system date but should be set differently depending on whether you chose 'Days' or 'Months' in "Post every".
  • If you chose 'Days', you should set the "Last posted" date to the same number of days before the date you want to start posting, i.e. if you want to start posting on 15th January and continue posting every 7 days, then enter 8th January here.
  • If you chose 'Months', you should set the "Last posted" date to be last day of the Month before you want the posting to start, i.e. if you want the posting to start in January, enter 31st December.

Once you have set up the posting with the correct dates, the system will then start to post any outstanding journals automatically from the day after you have set up the journal but only as far back as your current financial period. Check your "Last posted" date very carefully to prevent any unnecessary postings being made. To avoid confusion, you should post any old, out of date journals manually, and set the "Last posted" date no earlier than the previous month.

• If applicable, enter the "Expiry Date" for the posting. You may leave this blank if there is no fixed end date.
  • You may return to your posting at a later date and edit it to set the "Expiry Date".

• Select the [Amounts] tab.
• Enter the first nominal centre for the journal.
  • You may search for a centre by pressing <Ctrl+F1>.
• Enter a brief comment which will appear in the nominal review and bank reconciliation, if applicable.
• Enter the 'Amount'. If this is the credit value, enter the amount as a minus.
• If this part of the journal is vatable, press <F7>.
  • Select the "VAT indicator" - 'Input' for Purchases or 'Output' for Sales.
  • Select the "VAT rate" from the drop down menu. This ensures the transaction will appear in the correct box on your VAT return.
  • Click [OK].
  • VAT will be added to the amount. If the value you entered included VAT, press <F4> to calculate the VAT in the amount entered.
• Click [Add] to add the next part of the journal.
• Enter the second nominal centre for the journal.
• Enter a brief comment which will appear in the nominal review and bank reconciliation, if applicable.
• Enter the 'Amount'. If this is the credit value, enter the amount as a minus.
• If this part of the journal is vatable follow the steps described previously.

Typically only one part of the journal should be vatable, if at all. If you are unsure which part of the journal is subject to VAT, please check with your accountant.

• Press <Enter> to complete the line.

• Repeat this for the individual lines of the journal.

• The journal totals should balance to zero else you will be unable to save the posting.
• Click [Done] and [Accept].

See also

• Why can't I Set up a Regular Journal to Profit & Loss Centres?
• Reconciling your bank account
• What does nominal review show me?
• How do I Search for a Nominal Centre?

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

journals, regular, memorised, repetitive, month, expiry, hp, hire purchase, accruals, depreciation, fixed value, prepayments