Difference between revisions of "How do I reconcile a nominal centre?"

From Catalyst
Jump to: navigation, search
(More Information)
(Bulk update)
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
== Summary==
+
== Summary ==
 
The Nominal Reconciliation allows you to reconcile a centre to check all the Debit and Credit entries agree.
 
The Nominal Reconciliation allows you to reconcile a centre to check all the Debit and Credit entries agree.
  
== More Information ==  
+
== More Information ==
This is a useful option to allow you to balance your Vehicle Purchase Accrual centre, Work In Progress, Stock Accruals, Cash, Cheque and Credit Card centres and any other centres you consider this feature useful for.
+
This is a useful option to allow you to balance your Unit Purchase Accrual centre, Work In Progress, Stock Accruals, Cash, Cheque and Credit Card centres and any other centres you consider this feature useful for.
  
 
You will not be able to enter a value to reconcile to as the intention is that you are reconciling movements in and out as opposed to reconciling to a value. To reconcile your bank account or other similar accounts, please follow [[Reconciling your bank account|this]] article.
 
You will not be able to enter a value to reconcile to as the intention is that you are reconciling movements in and out as opposed to reconciling to a value. To reconcile your bank account or other similar accounts, please follow [[Reconciling your bank account|this]] article.
Line 10: Line 10:
  
 
=== Configuration ===
 
=== Configuration ===
Go to {{Menu|{{NL}}|Maintenance Options|Centre Maintenance|Insert/Amend/Delete Centres}}.  
+
Go to {{Menu|{{NL}}|Maintenance Options|Centre Maintenance|Add or Edit Nominal Centres}}.
 
* Search for the centre that you want to be able to reconcile.
 
* Search for the centre that you want to be able to reconcile.
 
* Press {{KeyPress|F5}} or click {{Button|Edit}} to edit the centre.
 
* Press {{KeyPress|F5}} or click {{Button|Edit}} to edit the centre.
* At {{DataPrompt|Reconciled?}}, select {{DataValue|Nominal Reconciled}} from the drop down menu.  
+
* At {{DataPrompt|Reconciled?}}, select {{DataValue|Nominal Reconciled}} from the drop down menu.
 
* Click {{Button|Done}} and {{Button|Accept}} to save the change.
 
* Click {{Button|Done}} and {{Button|Accept}} to save the change.
 
* Press {{KeyPress|ESC}} to exit from here back to the {{NL}} main menu.
 
* Press {{KeyPress|ESC}} to exit from here back to the {{NL}} main menu.
 
  
 
=== Usage ===
 
=== Usage ===
Line 25: Line 24:
 
* Enter the centre to reconcile by typing the code or press {{KeyPress|C-F1}} to [[How do I Search for a Nominal Centre?|search]] for a centre.
 
* Enter the centre to reconcile by typing the code or press {{KeyPress|C-F1}} to [[How do I Search for a Nominal Centre?|search]] for a centre.
  
{{Tip|text=If you press {{KeyPress|F1/S-F1}} you will scroll through only those centres available to be reconciled via the Nominal Reconciliation program.}}
+
{{Tip|text=If you press {{KeyPress|F1}} or {{KeyPress|S-F1}} you will scroll through only those centres available to be reconciled via the Nominal Reconciliation program.}}
  
 
* Enter the date range of transactions to display.
 
* Enter the date range of transactions to display.
* Press {{KeyPress|Enter}} or click {{Button|Search}}.
+
* Press {{KeyPress|ENTER}} or click {{Button|Search}}.
 
* Debit transactions will be shown in the column on the left and Credit transactions in the column on the right. Either side of the columns, the details relating to the selected transaction will be displayed.
 
* Debit transactions will be shown in the column on the left and Credit transactions in the column on the right. Either side of the columns, the details relating to the selected transaction will be displayed.
 
* Depending on the type of transaction you will have options available to allow you to see further details:
 
* Depending on the type of transaction you will have options available to allow you to see further details:
  
** Press {{KeyPress|F7}} to view the vehicle details.
+
** Press {{KeyPress|F7}} to view the unit details.
 
** Press {{KeyPress|S-F2}} to view the transaction details.
 
** Press {{KeyPress|S-F2}} to view the transaction details.
 
** Press {{KeyPress|F6/S-F6}} to view or reprint an Invoice/Credit document.
 
** Press {{KeyPress|F6/S-F6}} to view or reprint an Invoice/Credit document.
Line 42: Line 41:
 
==== Linking Items ====
 
==== Linking Items ====
 
* The system will try to match any obvious linked items for you. These will be highlighted in green.
 
* The system will try to match any obvious linked items for you. These will be highlighted in green.
* To match transactions yourself, click the relevant item or items in either of the two columns (either {{DataPrompt|Debit}} or {{DataPrompt|Credit}}) and press {{KeyPress|F5}} or click {{Button|Select}} on each one, then click the items to match up in the other column.  
+
* To match transactions yourself, click the relevant item or items in either of the two columns (either {{DataPrompt|Debit}} or {{DataPrompt|Credit}}) and press {{KeyPress|F5}} or click {{Button|Select}} on each one, then click the items to match up in the other column.
 
* The selected items will turn purple.
 
* The selected items will turn purple.
 
* When the selected items balance to zero, you will be prompted to link the transactions together.
 
* When the selected items balance to zero, you will be prompted to link the transactions together.
Line 50: Line 49:
 
Continue selecting and linking items until the overall difference, displayed on the right of your screen, returns to zero.
 
Continue selecting and linking items until the overall difference, displayed on the right of your screen, returns to zero.
  
{{Note|text=To de-select any unlinked items, press {{KeyPress|Esc}} or click {{Button|Cancel}}.}}
+
{{Note|text=To de-select any unlinked items, press {{KeyPress|ESC}} or click {{Button|Cancel}}.}}
  
 
{{Note|text=To de-link an item, click on one of the linked items and press {{KeyPress|F10}} or click {{Button|Delink}}.  This will only remove the link between items related to the one you have selected.}}
 
{{Note|text=To de-link an item, click on one of the linked items and press {{KeyPress|F10}} or click {{Button|Delink}}.  This will only remove the link between items related to the one you have selected.}}
  
{{Note|text=To abandon the reconciliation, click {{Button|Cancel}} and click {{Button|Done}}. Choose {{Button|Discard}}.}}  
+
{{Note|text=To abandon the reconciliation, click {{Button|Cancel}} and click {{Button|Done}}. Choose {{Button|Discard}}.}}
  
 
==== Confirm or Save the Reconciliation ====
 
==== Confirm or Save the Reconciliation ====
  
When you have linked all the relevant transactions, click {{Button|Done}}.  
+
When you have linked all the relevant transactions, click {{Button|Done}}.
  
* Click {{Button|Confirm}} to complete the reconciliation or click {{Button|Save}} to save the reconciliation as in progress. See [[How do I Load a Saved Nominal Reconciliation?|this]] article to load a saved reconciliation.
+
* Click {{Button|Confirm}} to complete the reconciliation or click {{Button|Save}} to save the reconciliation as {{DataValue|In Progress}}. See [[How do I Load a Saved Nominal Reconciliation?|this]] article to load a saved reconciliation.
  
 
The transactions will be marked as reconciled and will not reappear in this screen unless the reconciliation event is reversed. See [[How do I Reverse a Nominal Reconciliation?|this]] article.
 
The transactions will be marked as reconciled and will not reappear in this screen unless the reconciliation event is reversed. See [[How do I Reverse a Nominal Reconciliation?|this]] article.
  
== See also ==  
+
== See also ==
* [[How do I Set a Nominal Centre to be Reconciled?]]
+
* [[How do I set a nominal centre to be reconciled?]]
 
* [[How do I Reverse a Nominal Reconciliation?]]
 
* [[How do I Reverse a Nominal Reconciliation?]]
 
* [[How do I Load a Saved Nominal Reconciliation?]]
 
* [[How do I Load a Saved Nominal Reconciliation?]]
Line 72: Line 71:
 
* [[What should I consider at month end?]]
 
* [[What should I consider at month end?]]
  
{{KB_Tags|bank, account, reconcile, balance, rec, acc, month end, month, end, Nominal Reconciliation, Reconciliation, bank recon, bank reconcilliation, Nominal}}
+
{{KB_Tags|bank, account, reconcile, balance, rec, acc, month end, month, end, nominal reconciliation, reconciliation, bank recon, bank reconcilliation, nominal}}
{{KB_NL}}{{ZN_Accounts}}
+
{{How}}{{KB_NL}}{{ZN_Accounts}}
 +
 
 
{{KB_Ref|RP11}}
 
{{KB_Ref|RP11}}

Latest revision as of 05:34, 19 June 2019

Summary

The Nominal Reconciliation allows you to reconcile a centre to check all the Debit and Credit entries agree.

More Information

This is a useful option to allow you to balance your Unit Purchase Accrual centre, Work In Progress, Stock Accruals, Cash, Cheque and Credit Card centres and any other centres you consider this feature useful for.

You will not be able to enter a value to reconcile to as the intention is that you are reconciling movements in and out as opposed to reconciling to a value. To reconcile your bank account or other similar accounts, please follow this article.

Please note only Balance Sheet centres can be reconciled in this way.

Configuration

Go to " Nominal Ledger Maintenance Options Centre Maintenance Add or Edit Nominal Centres".

  • Search for the centre that you want to be able to reconcile.
  • Press <F5> or click [Edit] to edit the centre.
  • At "Reconciled?", select 'Nominal Reconciled' from the drop down menu.
  • Click [Done] and [Accept] to save the change.
  • Press <Esc> to exit from here back to the Nominal Ledger main menu.

Usage

Go to " Nominal Ledger Nominal Reconciliation".

You will only be able to reconcile transactions that are in the Nominal Ledger, i.e. Journals and Sales and Purchase transactions which have been updated to the Nominal Ledger as part of the End of Month routine.
  • Enter the centre to reconcile by typing the code or press <Ctrl+F1> to search for a centre.
If you press <F1> or <Shift+F1> you will scroll through only those centres available to be reconciled via the Nominal Reconciliation program.
  • Enter the date range of transactions to display.
  • Press <Enter> or click [Search].
  • Debit transactions will be shown in the column on the left and Credit transactions in the column on the right. Either side of the columns, the details relating to the selected transaction will be displayed.
  • Depending on the type of transaction you will have options available to allow you to see further details:
    • Press <F7> to view the unit details.
    • Press <Shift+F2> to view the transaction details.
    • Press <F6/S-F6> to view or reprint an Invoice/Credit document.
    • Press <Ctrl+F7> to view Order details.
    • Press <Alt+F7> to view Stock details.
Click the [Functions] menu or press <F12> at any point to see the options available for the transaction you have selected.

Linking Items

  • The system will try to match any obvious linked items for you. These will be highlighted in green.
  • To match transactions yourself, click the relevant item or items in either of the two columns (either "Debit" or "Credit") and press <F5> or click [Select] on each one, then click the items to match up in the other column.
  • The selected items will turn purple.
  • When the selected items balance to zero, you will be prompted to link the transactions together.
  • Enter a suitable comment and click [Link]. You may leave the comment blank.
    • If you wish to continue without linking items together at this point, click [Cancel] and the items will remain selected but no link has yet been made.

Continue selecting and linking items until the overall difference, displayed on the right of your screen, returns to zero.

To de-select any unlinked items, press <Esc> or click [Cancel].
To de-link an item, click on one of the linked items and press <F10> or click [Delink]. This will only remove the link between items related to the one you have selected.
To abandon the reconciliation, click [Cancel] and click [Done]. Choose [Discard].

Confirm or Save the Reconciliation

When you have linked all the relevant transactions, click [Done].

  • Click [Confirm] to complete the reconciliation or click [Save] to save the reconciliation as 'In Progress'. See this article to load a saved reconciliation.

The transactions will be marked as reconciled and will not reappear in this screen unless the reconciliation event is reversed. See this article.

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
bank, account, reconcile, balance, rec, acc, month end, month, end, nominal reconciliation, reconciliation, bank recon, bank reconcilliation, nominal
Tags

RP11