Difference between revisions of "How do I set up repetitive journals?"

From Catalyst
Jump to: navigation, search
(Bulk update)
(Bulk update)
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
{{Update}}
 
 
== Summary ==
 
== Summary ==
−
This article explains how to setup repetitive journals.
+
This article explains how to set up repetitive or recurring journals.
  
 
== More Information ==
 
== More Information ==
−
Repetitive or frequent transactions can be set up in the {{NL}}. They will be posted automatically for you based on the posting date and frequency.
+
Repetitive or frequent transactions can be set up in the {{NL}}. They will be posted automatically for you based on the posting date and frequency.
  
−
{{Information|text=Regular postings need to be of a fixed value.}}
+
{{Information|text=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 {{Menu|{{NL}}|Maintenance Options|Regular Postings}}.
 
Go to {{Menu|{{NL}}|Maintenance Options|Regular Postings}}.
 
* Click {{Button|Add}} to add a new journal.
 
* Click {{Button|Add}} to add a new journal.
−
* Enter a {{DataPrompt|Posting Code}}. This is simply unique code that you use to differentiate between journals. e.g. {{DataValue|A00001}}, {{DataValue|HPI CAR1}} etc.
+
 
−
* Enter a brief description for the posting e.g. {{DataValue|HPI CAR LOAN}}.
+
=== Details ===
 +
* Enter a {{DataPrompt|Posting Code}}. This is simply a unique code that you use to differentiate between journals, e.g. {{DataValue|A00001}}.
 +
* Enter a brief description for the posting.
 
* Enter the frequency of the posting.
 
* Enter the frequency of the posting.
−
** {{DataPrompt|Posts every}} depends on whether you select {{DataValue|
+
** {{DataPrompt|Posts every}} depends on whether you select {{DataValue|Months}} or {{DataValue|Days}} from the dropdown option.
−
In the "Posting dates" section, choose how often you want the transactions to be posted. If you select {{DataValue|Months}}, you will be required to also choose a "day of the month" on which the transactions will be posted.
+
** If you choose {{DataValue|Months}} enter the {{DataValue|Day}} on which the posting should be made.
−
*Set the {{DataValue|Last posted}} date. This defaults to the system date but should be set differently depending on whether you chose {{DataValue|Days}} or {{DataValue|Months}} in {{DataPrompt|Post every}}.
+
* Enter the {{DataValue|Last posted}} date. This defaults to the system date but should be set differently depending on whether you chose {{DataValue|Days}} or {{DataValue|Months}} in {{DataPrompt|Post every}}.
−
**If you chose {{DataValue|Days}}, you should set the {{DataPrompt|Last posted}} date to the same number of days before the date you want to start posting as how often you want the transactions to post, 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 {{DataValue|Days}}, you should set the {{DataPrompt|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 {{DataValue|Months}}, you should set the {{DataPrompt|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.
+
** If you chose {{DataValue|Months}}, you should set the {{DataPrompt|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.
 +
 
 +
{{Note|text=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 {{DataPrompt|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 {{DataPrompt|Last posted}} date no earlier than the previous month.}}
 +
 
 +
* If applicable, enter the {{DataPrompt|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 {{DataPrompt|Expiry Date}}.
 +
 
 +
=== Amounts ===
 +
* Select the {{Tab|Amounts}} tab.
 +
* Enter the first nominal centre for the journal.
 +
** You may [[How do I Search for a Nominal Centre?|search]] for a centre by pressing {{KeyPress|C-F1}}.
 +
* Enter a brief comment which will appear in the [[What does nominal review show me?|nominal review]] and [[Reconciling your bank account|bank reconciliation]], if applicable.
 +
* Enter the {{DataValue|Amount}}. If this is the credit value, enter the amount as a minus.
 +
* If this part of the journal is vatable, press {{KeyPress|F7}}.
 +
** Select the {{DataPrompt|VAT indicator}} - {{DataValue|Input}} for Purchases or {{DataValue|Output}} for Sales.
 +
** Select the {{DataPrompt|VAT rate}} from the drop down menu. This ensures the transaction will appear in the correct box on your VAT return.
 +
** Click {{Button|OK}}.
 +
** VAT will be added to the amount. If the value you entered included VAT, press {{KeyPress|F4}} to calculate the VAT in the amount entered.
 +
* Click {{Button|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 [[What does nominal review show me?|nominal review]] and [[Reconciling your bank account|bank reconciliation]], if applicable.
 +
* Enter the {{DataValue|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.
  
−
{{Note|text=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. Check your {{DataPrompt|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 {{DataPrompt|Last posted}} date no earlier than the previous month.}}
+
{{Warning|text=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.}}
  
−
*Enter the Expiry Date of the posting if there is one. For example, if the posting is for an HP agreement, then it will expire at the end of the term, which might be three years or more. If it is a depreciation posting, then it may well expire every year if you are working on a reducing balance method.
+
* Press {{KeyPress|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.
  
−
{{Tip|text=This option can be used for ''HP postings'', ''Depreciation'', ''Accruals'',''Prepayments'' and any other fixed value items.}}
+
* Click {{Button|Done}} and {{Button|Accept}}.
  
 
== See also ==
 
== See also ==
 +
* [[How do I set up a fixed asset register?]]
 
* [[Why can't I Set up a Regular Journal to Profit & Loss Centres?]]
 
* [[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?]]
  
 
{{KB_Tags|journals, regular, memorised, repetitive, month, expiry, hp, hire purchase, accruals, depreciation, fixed value, prepayments}}
 
{{KB_Tags|journals, regular, memorised, repetitive, month, expiry, hp, hire purchase, accruals, depreciation, fixed value, prepayments}}
−
{{Hint}}{{KB_NL}}{{ZN_Accounts}}
+
{{How}}{{Hint}}{{KB_NL}}{{ZN_Accounts}}

Latest revision as of 06:28, 24 December 2019

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.

Details

  • 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".

Amounts

  • 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


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
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_do_I_set_up_repetitive_journals%3F&oldid=41020"