General Ledger Runbook

The checklists in this topic are guides that can help you run your General Ledger programs in the correct sequence and at the correct time.  Simply print the appropriate section of this topic, and check off each program when it is complete.

Tips:

• Even if you have closed a period, you can reopen it at any time.  Then you can create new transactions and close the period again.  The General Ledger will not duplicate transactions when updating the balances.

• NDS strongly recommends following a schedule for performing normal Backups of your data.  The schedule should include daily, monthly, quarterly and annual backups.  In addition, run a full system backup quarterly or annually.  Be sure to use enough tapes in the rotation so that they are not overwritten too quickly.  The backups listed in the Year-End Checklist are in addition to your regular schedule.

To see the...

• Daily/Weekly Checklist, click More.

   

  General Ledger Daily/Weekly Checklist (optional) Tip:  You can perform the Daily/Weekly checklist every day, once a week, at your leisure, or not at all.  The timing depends on your facility's practices.  It is not required for closing a Period.
  Date		________________________________
  For G/L Period:		________________________________
  Section A:  Ongoing Tasks / Preparation Tip:  Perform these tasks as required.
  	Seq.	Programs
  	A-1.	Enter Manual Transactions (including reversals).
  	A-2.	Perform Recurring-Standard Entries File Maintenance.
  	A-3.	Print the Recurring-Standard Entries Listing (for recurring and standard journal entry templates). Tip: Required only if maintenance is performed.
  	A-4.	Perform Step-Down Allocations Maintenance.
  	A-5.	Post the interfacing modules to the General Ledger (A/R, A/P, Payroll, etc.).
  Section B:  Journal Import Tip:  This sequence of steps applies only if you import journal entries via text files from an external source.
  	Seq.	Programs
  	B-1.	Run the Journal Import.
  	B-2.	Confirm that there were no exceptions created by the Journal Import.
  Section C:  Daily Close Tip:  Performing these tasks every day is optional.  Follow the procedure for your facility.
  	Seq.	Programs
  	C-1.	Print the General Journal Exception Report.
  	C-2.	Make corrections indicated by the Exception Report, if applicable.
  	C-3.	Print the General Journal Listing (for unposted transactions). Tip:  Review the report and make sure journal entries are in balance.  Archive the report.
  	C-4.	Post Journal Entries (to update the Period Balances).   Period: _______________   Journal Codes: _______________
  	C-5.	Review Post report for errors.  Confirm that the Post amounts match the General Journal Listing amounts.
  	C-6.	Print the General Journal Report. Tip:  Retain this report for audit purposes.

  ---

   

• Period-End/Quarterly Checklist, click More.

   

  General Ledger Period-End Checklist
  Date		________________________________ Important:  You are not required to complete this checklist by any particular day.  General Ledger's flexibility allows periods to be closed any time, even months beyond the actual Period Closing Date.
  For G/L Period:		________________________________
  	Seq.	Programs
  	1.	Close and post interfacing modules to the General Ledger (A/P, A/R, Cash Receipts, Payroll, etc.).
  	2.	Perform any Daily Work required. Tip:  Refer to the Ongoing Tasks in the Daily Checklist.
  	3.	Create Standard Entries, if applicable.   Run Code: _______________
  	4.	Create Recurring Entries, if applicable.   Run Code: _______________
  	5.	Create Step-Down Allocations, if applicable.
  	6.	Print the General Journal Exception Report.
  	7.	Make corrections indicated by the Exception Report, if applicable.
  	8.	Print the General Journal Listing (for unposted transactions to compare to post report later).   Total Debits: ______________   Total Credits: ______________   Tip:  Review the report and make sure journal entries are in balance.  Archive the report.
  	9.	Post Journal Entries  (to update the Period Balances).   Period: _______________  Journal Codes: _______________     Total Debits: ______________   Total Credits: ______________   Tip:  Compare the balances to the journal listing.
  	10.	Review the Post report for errors.  Confirm that the posted totals match the General Journal Listing unposted totals.
  	11.	Print the General Journal Report. Tip:  Retain this report for audit purposes.
  	12.	Print the Single Period Activity Report.
  	13.	Print the Trial Balance Report.
  	14.	Prove Control Account Balances from modules such as A/R, A/P, and Cash Receipts. Tip:  If changes to Control Accounts are required, it is best to make them through the appropriate software module and then post.  Be sure to post again to the General Ledger.
  	15.	Print the monthly Management Reports, typically including the following: Income Statements Balance Sheets Tip:  If you run any quarterly reports, print them during this step.
  	16.	To close the period, which prevents further journal entries, set the Period Open Option in Period Descriptions Maintenance to N(o). Tip:  This step is optional.

  ---

   

• Period-Begin Checklist, click More.

   

  General Ledger Period-Begin Checklist (optional)
  Date		________________________________
  For G/L Period:		________________________________
  	Seq.	Programs
  	1.	Create Reversing Entries, if applicable.

  ---

   

• Year-End Checklist, click More.

   

  General Ledger Year-End Checklist
  For Fiscal Year:		Closing Year:  ___________  New Opening Year:  ___________
  Section A. - Prepare the New Year for Data
  	Seq.	Date	Programs
  	A-1.		Run a Normal Backup: Perform a normal backup before initializing the periods for the new year. Mark the medium (tape, disk etc.) as "NEW YEAR for CCYY, performed MMDDCCYY), where CCYY is the new year, and MMDDCCYY is the actual date you run the backup. Do not re-use the tape until after the Year-End checklist is complete. Tip:  This does not replace an annual system backup, that should be part of your regular backup procedures.
  	A-2.		Print the General Journal Listing (for all unposted journal entry transactions to confirm all transactions have been posted).   Periods:  ______________ (Enter the Period that will be initialized.)
  	A-3.		Post Journal Entries for the Period(s) you want to initialize.   Periods:  ______________ (Enter the Period that will be initialized.) Tips: This post is required only if you found unposted journal entries. Compare the totals to the journal listing.
  	A-4.		Run the GL YTD Activity Report for the entire Fiscal year for all accounts.
  	A-5.		Run the desired financial reports including an Income Statement, Trial Balance and Balance Sheet reports.
  	A-6.		Print the General Journal Report for the archive.
  Section B - Process the Year-End for the Closing Fiscal Year Tip:  When you and your accountant are ready to close the year, perform the following tasks.
  	Seq.	Date	Programs
  	B-1.		Complete Year-End processing in all interfacing applications such as A/P and Payroll. Tip:  You do not have to wait for adjusting entries from the accountant.
  	B-2.		Run a Normal Backup: Perform a normal backup for the Year-End. Mark the medium (tape, disk etc.) as "YEAR END CCYY, performed MMDDCCYY), where CCYY is the closing year, and MMDDCCYY is the actual date you run the backup. Do not re-use the tape. Tip:  This does not replace an annual system backup, that should be part of your regular backup procedures.
  	B-3.		Run Start Fiscal Year End.
  	B-4.		Review Restrict Fiscal Year Processing.
  	B-5.		After the above steps are completed, processing in the new fiscal year can be started.
  	B-6.		If your facility uses Clear To Accounts, verify that each revenue and expense account has the correct Clear To Account identified. Tip:  Print the Chart of Accounts Report with the Print Clear To Account option selected, and sort the report by Type/Account.
  	B-7.		Run Clear and Close Accounts, which performs the following functions: The clearing journal entries are posted to period 14.   Function:  Makes appropriate debit or credit entries to transfer the balances from income and expense accounts to the Clear To Account, which is a Retained Earnings Account. Tip:  You can re-run this routine as many times as necessary before running the Year-End Post Journal Entries routine.
  	B-8.		Print the General Journal Report for an archive.   Period: _______________ (unposted entries only) (same as Clear & Close, period 14)   Note:  Verify the journal.  If corrections are required to the account balances: Make the corrections. Run Clear and Close Accounts again. Print the Year-End Journal Listing again.
  Section C - Adjustments (optional) Tip:  You can run adjustments for a closed year anytime during the following year.  The adjustments are posted to the closed year, the ending balances (always a calculated value) are updated, and the beginning balances for the current year are brought up to date.
  	Seq.	Date	Programs
  	C-1.		Obtain the accountant's closing entries.
  	C-2.		Enter adjustments using  Year-End Adjustments Processing. Adjustments are entered into Period 13 of the current year.
  	C-3.		Print the Adjustments Journal Listing for Adjustments. Note:  Verify that the adjustments are correct.  If not, make corrections using Adjustments Processing and run this report again.   Period: _______________ (unposted entries only) Period 13 of the current year

   

  ---