Difference between revisions of "How to process a month end"

From Catalyst
Jump to: navigation, search
Line 1: Line 1:
 
== Summary ==
 
== Summary ==
−
 
 
The following steps are will take you through what to do on you month end step by step allowing you to proceed will you next monthly accounting period
 
The following steps are will take you through what to do on you month end step by step allowing you to proceed will you next monthly accounting period
  
 
== Additional Information ==
 
== Additional Information ==
−
 
 
If you are running the full accounts system there are various procedures you have to go through at the end of a financial period (in Platinum this is one calendar month) to produce your end of month reports and to allow you to close off a period and move into the next financial period.  
 
If you are running the full accounts system there are various procedures you have to go through at the end of a financial period (in Platinum this is one calendar month) to produce your end of month reports and to allow you to close off a period and move into the next financial period.  
  
 
The majority of these processes will produce printouts. Please make sure your printer is switched on, is loaded with paper and is on line.  
 
The majority of these processes will produce printouts. Please make sure your printer is switched on, is loaded with paper and is on line.  
  
−
== 1. Financial Period Check ==
+
== Financial Period Check ==
−
 
+
Check the Financial Period is set to the month you wish to close off.
−
Check the Financial Period is set to the month you wish to close off  
 
  
−
*Go to Reports & Parameters  
+
Go to "Reports & Parameters" -> "Set New Financial Period".
−
*Select Set New Financial Period  
 
 
*Set the financial period to the one you wish to close.  
 
*Set the financial period to the one you wish to close.  
  
−
== 2. Sales Ledger ==
+
== Sales Ledger ==
−
 
 
 
After the last Sales Invoice for the month is complete, the following reports may be extracted:  
 
After the last Sales Invoice for the month is complete, the following reports may be extracted:  
  
−
Printing the Daybook Listing & Accepting it.
+
=== Daybook Listing ===
−
 
+
Go to the "Sales Ledger" -> "Daybook Listing" -> "Print Daybook and Update Nominal"
−
*Go to the Sales Ledger Main Menu
+
* This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your V.A.T. records.  
−
*Select Daybook Listing  
 
−
*Select Print Daybook and Update Nominal. This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your VAT records.
 
−
 
 
−
Make sure you have a complete printout before accepting the Daybook.
 
−
 
 
−
Print an Aged Debt List
 
−
 
 
−
*Go to the Sales Ledger Main Menu
 
−
*Select Aged Debtors Listing
 
−
*Select Print Debt List then tap F5 then F2. Type "Y" in the fourth parameter down ("Ignore Documents Beyond Current Accounting Period").  
 
−
*Tap Esc twice.  
 
−
*If you want a breakdown of the debts then type "1" into "Breakdown From Period" else leave this set to 0. Tap F2 to print the Debt List.  
 
  
−
Print a Specific Month Cost Centre Report
+
{{Warning|text=Make sure you have a complete printout before accepting the Daybook.}}
  
−
*Go to the Sales Ledger Main Menu
+
=== Aged Debt List ===
−
*Select Maintenance Options
+
Go to the "Sales Ledger" -> "Aged Debtors Listing".
−
*Select Centre Maintenance
+
*Select Print Debt List then press {{KeyPress|F5}} then {{KeyPress|F2}}.
−
*Select Print Monthly Turnover
+
*For {{DataPrompt|Ignore Documents Beyond Current Accounting Period}} set {{DataValue|Y}}.
−
*Select Specific Months Report and enter the month to produce the report for i.e. 06 - June or 10 - October.  
+
*Press {{KeyPress|ESC}} twice.
 +
*If you want a breakdown of the debts then type {{DataValue|1}} into {{DataPrompt|Breakdown From Period}} else leave this set to {{DataValue|0}}.
 +
*Press {{KeyPress|F2}} to print the Debt List.  
  
−
== 3. Purchase Ledger ==
+
=== Specific Month Cost Centre Report ===
 +
Go to the "Sales Ledger" -> "Maintenance Options" -> "Centre Maintenance" -> "Print Monthly Turnover".
 +
*Select Specific Months Report and enter the month to produce the report for i.e. {{DataValue|06}} - June or {{DataValue|10}} - October.
  
 +
== Purchase Ledger ==
 
After the last Purchase Invoice for the month has been received and posted onto the system or you have reached an appropriate cut-off point, the following reports may be extracted:  
 
After the last Purchase Invoice for the month has been received and posted onto the system or you have reached an appropriate cut-off point, the following reports may be extracted:  
  
−
Printing the Daybook Listing & Accepting it.
+
=== Daybook Listing ===
−
 
+
Go to the "Purchase Ledger" -> "Daybook Listing" -> "Print Daybook and Update Nominal".
−
*Go to the Purchase Ledger Main Menu
+
* This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your V.A.T. records.  
−
*Select Daybook Listing  
 
−
*Select Print Daybook and Update Nominal. This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your VAT records.  
 
  
−
Make sure you have a complete printout before accepting the Daybook.  
+
{{Warning|text=Make sure you have a complete printout before accepting the Daybook.}}
  
−
Printing an Aged Creditors List  
+
=== Aged Creditors List ===
−
 
+
Go to "Purchase Ledger" -> "Aged Creditors Listing" -> "Print Debt List".
−
Go to the Purchase Ledger Main Menu
+
*Select Print Debt List then press {{KeyPress|F5}} then {{KeyPress|F2}}.
−
Select Aged Creditors Listing  
+
*For {{DataPrompt|Ignore Documents Beyond Current Accounting Period}} set {{DataValue|Y}}.
−
*Select Print Debt List then tap F5 then F2. Type "Y" in the fourth parameter down ("Ignore Documents Beyond Current Accounting Period").  
 
 
*Tap Esc twice.  
 
*Tap Esc twice.  
−
*If you want a breakdown of the debts then type "1" into "Breakdown From Period" else leave this set to 0. Tap F2 to print the Creditors List.  
+
*Press {{KeyPress|ESC}} twice.
 +
*If you want a breakdown of the debts then type {{DataValue|1}} into {{DataPrompt|Breakdown From Period}} else leave this set to {{DataValue|0}}.
 +
*Press {{KeyPress|F2}} to print the Creditors List.  
  
−
Printing a Specific Month Cost Centre Report
+
=== Specific Month Cost Centre Report ===
−
 
+
Go to "Purchase Ledger" -> "Maintenance Options" -> "Centre Maintenance" -> "Print Monthly Turnover".
−
*Go to the Purchase Ledger Main Menu
+
*Select Specific Months Report and enter the month to produce the report for i.e. {{DataValue|06}} - June or {{DataValue|10}} - October.  
−
*Select Maintenance Options  
 
−
*Select Centre Maintenance  
 
−
*Select Print Monthly Turnover  
 
−
*Select Specific Months Report and enter the month to produce the report for i.e. 06 - June or 10 - October.  
 
−
 
 
−
== 4. Reports & Parameters ==
 
  
 +
== Reports & Parameters ==
 
The following report needs to be run from the Reports & Parameters system.  
 
The following report needs to be run from the Reports & Parameters system.  
  
−
Printing VAT Audit & Cashbook  
+
=== V.A.T. Audit & Cashbook ===
 +
Go to "Reports & Parameters" -> "Reports" -> "Monthly Audit & Cashbook" -> "Normal Monthly Audit".
 +
* Press {{KeyPress|Enter}} to use the Current Accounting Period as the month to audit.
  
−
*Go to the Reports & Parameters Main Menu
+
This forms another very important part of your V.A.T. records (V.A.T. Audit) and also provides a cashbook. When you have a complete printout, Press {{KeyPress|Enter}} to accept the audit.  
−
*Select Reports
+
{{Note|text=If you get a message that there is ''UNPROCESSED DATA'' for any months, press {{KeyPress|Enter}} to continue you will then be asked to accept or ignore the report. When you have a copmplete printout, press {{KeyPress|Enter}} to accept the audit trail. Go back to the "Monthly Audit & Cashbook" Menu and select Audit For Months Before a Given Date.  
−
*Select Monthly Audit & Cashbook.  
 
−
*Select Normal Monthly Audit. Tap Enter to use the Current Accounting Period as the month to audit.  
 
  
−
This forms another very important part of your VAT records (VAT Audit) and also provides a cashbook. When you have a complete printout, tap Enter to accept the audit.
+
Press {{KeyPress|Enter}} to use the same dates as for the Normal Monthly Audit and this will process any data which has fallen into previous months so has not been through the Monthly Audit report.  
−
 
 
−
If you get a message that there is UNPROCESSED DATA for any months, tap Enter to continue you will then be asked to accept or ignore the report. When you have a copmplete printout, tap Enter to accept the audit trail. Go back to the Monthly Audit & Cashbook Menu and select Audit For Months Before a Given Date.
 
−
 
 
−
Tap Enter to use the same dates as for the Normal Monthly Audit and this will process any data which has fallen into previous months so has not been through the Monthly Audit report.  
 
−
 
 
−
== 5. Nominal Ledger ==
 
  
 +
== Nominal Ledger ==
 
The following reports/processes need to be run from the Nominal Ledger.  
 
The following reports/processes need to be run from the Nominal Ledger.  
  
−
Printing a Trial Balance  
+
=== Trial Balance ===
−
 
+
Go to "Nominal Ledger" -> "Trial Balance".
−
*Go to the Nominal Ledger Main Menu
+
*When the report is on the screen, press {{keyPress|F2 }}to print the Trial Balance. This allows you to check balances on each Nominal Code especially for the major control accounts e.g. Current Bank Account, Cash in Hand, Sales & Purchase Control and V.A.T. Outstanding.  
−
*Select Trial Balance  
 
−
*When the report is on the screen, tap F2 to print the Trial Balance. This allows you to check balances on each Nominal Code especially for the major control accounts e.g. Current Bank Account, Cash in Hand, Sales & Purchase Control and VAT Outstanding.  
 
  
−
Printing the Profit & Loss Report  
+
=== Profit & Loss Report ===
 +
Go to "Nominal Ledger" -> "Run Profit & Loss Report" -> "Print the Audit Trail & Cleardown".
 +
* Once you have a complete report, accept it.
  
−
*Go to the Nominal Ledger Main Menu
+
=== Balance Sheet ===
−
*Select Run Profit & Loss Report
+
Go to "Nominal Ledger" -> "Balance Sheet" -> "Run Balance Sheet" -> "Print the Audit Trail & Cleardown".
−
*Select Print the Audit Trail & Cleardown and accept it.
+
* Once you have a complete report. accept it.  
−
 
 
−
Printing the Balance Sheet  
 
−
 
 
−
*Go to the Nominal Ledger Main Menu
 
−
*Select Balance Sheet  
 
−
*Select Run Balance Sheet  
 
−
*Select Print the Audit Trail & Cleardown and accept it.  
 
−
 
 
−
== 6. Reports & Parameters ==
 
  
 +
== Reports & Parameters ==
 
The following reports/processes need to be run from the Reports & Parameters system.  
 
The following reports/processes need to be run from the Reports & Parameters system.  
  
−
The VAT Report need only be run if required.  
+
The V.A.T. Report need only be run if required.  
  
−
Printing  VAT Reports  
+
=== V.A.T. Reports ===
 +
Go to "Reports & Parameters" -> "Reports" -> "V.A.T. Reports" -> "Print End of Quarter V.A.T. Report if required".
 +
* The figures here should be checked against the Daybook Listings and the V.A.T. Audit Trails to ensure accuracy.
  
−
*Go to the Reports & Parameters Main Menu
+
=== Final Financial Period Change ===
−
*Select Reports
+
Go to "Reports & Parameters" -> "Set New Financial Period".
−
*Select VAT Reports
 
−
*Select Print End of Quarter VAT Report if required. The figures here should be checked against the Daybook Listings and the VAT Audit Trails to ensure accuracy.
 
−
 
 
−
Final Financial Period Change  
 
−
 
 
−
*Go to the Reports & Parameters Main Menu
 
−
*Select Set New Financial Period  
 
 
*Move the Financial Period on to the next month in the financial year.  
 
*Move the Financial Period on to the next month in the financial year.  
  
−
== 7. Sales Ledger ==
+
== Sales Ledger ==
−
 
+
The cleardown will clear all transactions from the Sales Ledger which have been fully processed. They are then archived and stored in Document History (provided the {{DataPrompt|Transaction Archive Parameter}} is set to {{DataValue|Y}}).  
−
The cleardown will clear all transactions from the Sales Ledger which have been fully processed. They are then archived and stored in Document History (provided the Transaction Archive Parameter is set to "Y" - Yes).
 
−
 
 
−
Clearing down
 
−
 
 
−
*Go to the Sales Ledger Main Menu.
 
−
*Select Cleardown
 
−
*Tap F2 to cleardown all the complete documents. This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the Transaction Archives option in Reports & Parameters. It is nevertheless useful to have a full system backup.  
 
  
−
== 8. Purchase Ledger ==
+
=== Clearing down ===
 +
Go to "Sales Ledger" -> "Cleardown".
 +
*Press {{KeyPress|F2}} to cleardown all the complete documents.
 +
{{Note|text=This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the "Transaction Archives" option in "Reports & Parameters". It is nevertheless useful to have a full system backup.}}
  
−
The cleardown will clear all transactions from the Purchase Ledger which have been fully processed. They are then archived and stored in Document History (provided the Transaction Archive Parameter is set to "Y" - Yes).  
+
== Purchase Ledger ==
 +
The cleardown will clear all transactions from the Purchase Ledger which have been fully processed. They are then archived and stored in Document History (provided the {{DataPrompt|Transaction Archive Parameter}} is set to {{DataValue|Y}}).  
  
−
Clearing down
+
=== Clearing down ===
−
 
+
Go to "Purchase Ledger" -> "Cleardown".
−
*Go to the Purchase Ledger Main Menu.  
+
*Press {{KeyPress|F2}} to cleardown all the complete documents.
−
*Select Cleardown
+
{{note|text=This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the "Transaction Archives" option in "Reports & Parameters". It is nevertheless useful to have a full system backup.}}
−
*Tap F2 to cleardown all the complete documents. This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the Transaction Archives option in Reports & Parameters. It is nevertheless useful to have a full system backup.  
 
  
 
== See also ==
 
== See also ==
−
 
 
*[[What should I consider at month end?]]
 
*[[What should I consider at month end?]]
  
−
{{KB_Tags|Month, end, daybook, audit, debt list, nominal, update}}{{KB_VS}}
+
{{KB_Tags|Month, end, daybook, audit, debt list, nominal, update}}{{KB_SL}}{{KB_PL}}{{KB_NL}}{{ZN_Accounts}}

Revision as of 19:54, 19 February 2008

Summary

The following steps are will take you through what to do on you month end step by step allowing you to proceed will you next monthly accounting period

Additional Information

If you are running the full accounts system there are various procedures you have to go through at the end of a financial period (in Platinum this is one calendar month) to produce your end of month reports and to allow you to close off a period and move into the next financial period.

The majority of these processes will produce printouts. Please make sure your printer is switched on, is loaded with paper and is on line.

Financial Period Check

Check the Financial Period is set to the month you wish to close off.

Go to "Reports & Parameters" -> "Set New Financial Period".

  • Set the financial period to the one you wish to close.

Sales Ledger

After the last Sales Invoice for the month is complete, the following reports may be extracted:

Daybook Listing

Go to the "Sales Ledger" -> "Daybook Listing" -> "Print Daybook and Update Nominal"

  • This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your V.A.T. records.
Make sure you have a complete printout before accepting the Daybook.

Aged Debt List

Go to the "Sales Ledger" -> "Aged Debtors Listing".

  • Select Print Debt List then press <F5> then <F2>.
  • For "Ignore Documents Beyond Current Accounting Period" set 'Y'.
  • Press <Esc> twice.
  • If you want a breakdown of the debts then type '1' into "Breakdown From Period" else leave this set to '0'.
  • Press <F2> to print the Debt List.

Specific Month Cost Centre Report

Go to the "Sales Ledger" -> "Maintenance Options" -> "Centre Maintenance" -> "Print Monthly Turnover".

  • Select Specific Months Report and enter the month to produce the report for i.e. '06' - June or '10' - October.

Purchase Ledger

After the last Purchase Invoice for the month has been received and posted onto the system or you have reached an appropriate cut-off point, the following reports may be extracted:

Daybook Listing

Go to the "Purchase Ledger" -> "Daybook Listing" -> "Print Daybook and Update Nominal".

  • This will give an audit trail for the posting to the Nominal Ledger and forms one very important part of your V.A.T. records.
Make sure you have a complete printout before accepting the Daybook.

Aged Creditors List

Go to "Purchase Ledger" -> "Aged Creditors Listing" -> "Print Debt List".

  • Select Print Debt List then press <F5> then <F2>.
  • For "Ignore Documents Beyond Current Accounting Period" set 'Y'.
  • Tap Esc twice.
  • Press <Esc> twice.
  • If you want a breakdown of the debts then type '1' into "Breakdown From Period" else leave this set to '0'.
  • Press <F2> to print the Creditors List.

Specific Month Cost Centre Report

Go to "Purchase Ledger" -> "Maintenance Options" -> "Centre Maintenance" -> "Print Monthly Turnover".

  • Select Specific Months Report and enter the month to produce the report for i.e. '06' - June or '10' - October.

Reports & Parameters

The following report needs to be run from the Reports & Parameters system.

V.A.T. Audit & Cashbook

Go to "Reports & Parameters" -> "Reports" -> "Monthly Audit & Cashbook" -> "Normal Monthly Audit".

  • Press <Enter> to use the Current Accounting Period as the month to audit.

This forms another very important part of your V.A.T. records (V.A.T. Audit) and also provides a cashbook. When you have a complete printout, Press <Enter> to accept the audit. {{Note|text=If you get a message that there is UNPROCESSED DATA for any months, press <Enter> to continue you will then be asked to accept or ignore the report. When you have a copmplete printout, press <Enter> to accept the audit trail. Go back to the "Monthly Audit & Cashbook" Menu and select Audit For Months Before a Given Date.

Press <Enter> to use the same dates as for the Normal Monthly Audit and this will process any data which has fallen into previous months so has not been through the Monthly Audit report.

Nominal Ledger

The following reports/processes need to be run from the Nominal Ledger.

Trial Balance

Go to "Nominal Ledger" -> "Trial Balance".

  • When the report is on the screen, press <F2>to print the Trial Balance. This allows you to check balances on each Nominal Code especially for the major control accounts e.g. Current Bank Account, Cash in Hand, Sales & Purchase Control and V.A.T. Outstanding.

Profit & Loss Report

Go to "Nominal Ledger" -> "Run Profit & Loss Report" -> "Print the Audit Trail & Cleardown".

  • Once you have a complete report, accept it.

Balance Sheet

Go to "Nominal Ledger" -> "Balance Sheet" -> "Run Balance Sheet" -> "Print the Audit Trail & Cleardown".

  • Once you have a complete report. accept it.

Reports & Parameters

The following reports/processes need to be run from the Reports & Parameters system.

The V.A.T. Report need only be run if required.

V.A.T. Reports

Go to "Reports & Parameters" -> "Reports" -> "V.A.T. Reports" -> "Print End of Quarter V.A.T. Report if required".

  • The figures here should be checked against the Daybook Listings and the V.A.T. Audit Trails to ensure accuracy.

Final Financial Period Change

Go to "Reports & Parameters" -> "Set New Financial Period".

  • Move the Financial Period on to the next month in the financial year.

Sales Ledger

The cleardown will clear all transactions from the Sales Ledger which have been fully processed. They are then archived and stored in Document History (provided the "Transaction Archive Parameter" is set to 'Y').

Clearing down

Go to "Sales Ledger" -> "Cleardown".

  • Press <F2> to cleardown all the complete documents.
This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the "Transaction Archives" option in "Reports & Parameters". It is nevertheless useful to have a full system backup.

Purchase Ledger

The cleardown will clear all transactions from the Purchase Ledger which have been fully processed. They are then archived and stored in Document History (provided the "Transaction Archive Parameter" is set to 'Y').

Clearing down

Go to "Purchase Ledger" -> "Cleardown".

  • Press <F2> to cleardown all the complete documents.
This routine may take quite a long time to complete, so ensure that you have plenty of time in which to do this. This removes from the system all transactions with zero balances that have had all the necessary analysis done on them and either puts them into the transaction archives or eliminates them into free space. In most cases, they will be archived and can be retrieved using the "Transaction Archives" option in "Reports & Parameters". It is nevertheless useful to have a full system backup.

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
Month, end, daybook, audit, debt list, nominal, update
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_to_process_a_month_end&oldid=297"