Options available:

Option 1) Period End rollover

Depending upon how the Period ID is setup, when performing a month or term rollover, the End of Period routine effectively consolidates all current transactions into a brought forward balance on the Family Accounts.

This means;

The closing balance on a Family Account will be the b/fwd opening balance on the next Family Account printed.

All transactions for the current year are still available in the Family Account Master File and can be printed via the Transaction Listing Report or Open Item Printing from Account Printing.

This End of Period procedure will automatically create an Accrual batch of all current transactions in the Debtors ‘proper’ to update the Ledger. Once the procedure is complete go to General Ledger/Batch Transaction Entry and finalise this batch.

Option 2) Utilities rollover

A Utilities Only rollover will create a Ledger Accrual Batch or consolidation of the Sundries without rolling into a new Period.

This means;

It will still show all transactions on the Family Account

This Utilities roll procedure will automatically create an Accrual batch of all current transactions in the Debtors ‘proper’ to update the Ledger. Once the procedure is complete go to General Ledger/Batch Transaction Entry and finalise this batch.

Check List to print

Click on link for Check List for the first few times of doing end of month to see that you have completed all tasks before rolling over.

End of Period – steps 1 to 9

Procedures to perform prior to Rolling.

1.	Account Printing	Print Family Accounts. It is suggested you also print a copy to Document Manager or to a PDF file.
2.	Receipt Entry	All Receipt Batches must be Finalised.
3.	Batch Billing View	Finalise any Billing Batches to be included in the current periods Family Account. Unfinalise any Billing Batch if you want the entries to be included in the next periods Account.
4.	Account Validity	Run an Account Validity, you must have no errors.
5.	Debtors Transaction Listing	Run a Debtors Reconciliation via Debtors Transaction Listing, the variance must be zero. (If not here you may be set up to run this from the Family Based Debtor Reports)
6.	Debtors Transaction Listing	Family List – drop down box - Print or save to PDF (if required)
7.	Family based Debtors reports	Print Family Based Debtors – Save PDF (if required)
8.	Check Trial Balance	In Finance > Run a Trial Balance to see if it balances – as most times when it is out it could be a Debtors receipt batch (this saves doing rebuilds later on which can take time) - If you do not have access to this get your Finance person to run it – before rolling your Debtors.
9.	Stop Processing	Halt all processing in Receipt Entry, Batch Billing View and Invoice View until the End of Month process is finished.

Step 10: Backup Debtors

Path: Utilities > Backup

If you do not have access to Backup see if you can be given access or have your IT staff complete this process for you.
Your backup must be completed as the process below prior to Performing the Period End, this process can be performed while others are working in PCSchool.

1.	Go to [Utilities]
2.	Select [Backup]
3.	Click [Select All]
4.	Click [Backup Data]
5.	At the next window, click [Create Backup] - OK.

Step 11: End of Period

Path: Debtors > Debtor’s End of Period

Example of End of month roll over.

There should not be any need to edit this view before clicking on Begin Process as the defaults are usually the standard procedure.

1.	Select [Perform Period End]
2.	[Reset Account Messages] - If you do not wish to Reset the Account Messages the tick can be removed from this option before proceeding. This is set as default to ensure a Message, which may be a Reminder to pay the previous Account, is not inadvertently left against a family and printed on the next Account
3.	[Clear Finalised Prior Year Invoices] - will simply tidy up any prior year invoices that have been paid since the last rollover. It is suggested this box be checked for this procedure
4.	[Create Ledger Accrual Batch] – this should have tick in it
5.	[Current Period] + [Next Period] – this could be monthly or termly however your system is setup
6.	[Date Performed] If doing end of month you may wish to date this back to the end of month date
7.	[Begin Process]

Other options are more likely to be used when performing the End of Year Procedure.

If Split Billing has been utilised, but a split has not yet taken place;

Batch Billing where the Accounts have not been run
Entries through Invoice View
Sundry items

You will be asked if you want to create the split now. Splitting an account creates a finalised billing batch under Billing Batch View.

If Billing Batches have been left open the system will confirm if these batches are to be left as unfinalised:

Yes will proceed with the period end process

No will abort the process to allow you to finalise these batches before proceeding.

All Receipt batches must be finalised.

If you selected Yes to Split Billing a Billing Batch will be created.

Step 12: Finalise Batch

Path: Debtors> General Ledger > Batch Transaction Entry > Debtors

Finalise batch make sure the date is correct and finalise in to the correct month.

Utilities Rollover

To transfer your figures to your General Ledger you can complete a Utilities only rollover this enables the creation of the Ledger Accrual Batch or consolidation of the Sundries without rolling into a new Period.

Your Debtors Statements will still show all transactions.

Creates a Ledger Accrual Batch.

1.	Select Utilities Only.
2.	The Current and Next periods will be the same.
3.	Check the Items you wish to act upon.
4.	Click Begin Process.

Sundry Debtors Consolidation

	Select if you decided not to go further.
2.	Sundry Transactions can be consolidated to a single Invoice in Debtors Proper, you will need to enter; A Cost Centre with No GST component, compulsory. A Cost Centre with a GST component, compulsory. Select the Date to consolidate up to. Select the Cost Centre range for consolidation.
3.	Sundry Transactions can be consolidated to a single Invoice for each Student in Debtors Proper, you will need to enter; A Cost Centre with No GST component, compulsory. A Cost Centre with a GST component, compulsory. Select the Date to consolidate up to. Select the Cost Centre range for consolidation.
4.	Sundry Transactions can be consolidated to a single Balance Forward within Sundry Debtors you will need to enter; A Cost Centre with No GST component, compulsory. A Cost Centre with a GST component, compulsory. Select the Date to consolidate up to. Select the Cost Centre range for consolidation.
5.	Sundry Transactions can be consolidated to a single Balance Forward for each Student within Sundry Debtors you will need to enter; A Cost Centre with No GST component, compulsory. A Cost Centre with a GST component, compulsory. Select the Date to consolidate up to. Select the Cost Centre range for consolidation.
6.	Transactions receipted to the Cost Centre for Voluntary Payments can be automatically transferred; Select the Date to transfer up to. Select the Cost Centre range for transferring.
7.	Transactions receipted to a Cost Centre for the Foundation can be automatically transferred; Select the Pledge Plan Code to transfer. Select the Date to consolidate up to. Select the Cost Centre range for transferring.
8.	Transactions receipted to the Cost Centre for either the Held Deposit or Homestay can be automatically transferred; Select the Date to transfer up to. Select the Cost Centre range for transferring.
9.	Delete Transactions will clear out all finalised sundry invoices with a Zero Balance against the selected Cost Centres. Select the Date to delete invoices from. Select the Cost Centre range for deletion.
10.	Delete Transactions will Delete all Transactions regardless as to whether or not they have been paid, against the selected Cost Centres; Select the Date to delete invoices from. Select the Cost Centre range for deletion.
11.	Select the Cost Centres to use when Consolidating Sundries; You must have one Cost Centre with no GST Component. You must have a second Cost Centre with a GST Component.
12.	This field is only active if the Foundation transactions are being Transferred.
13.	Select details for Sundries, Voluntary, Foundation, Held Deposit, Homestay and Deleting; Select charges to a Date to or leave blank for all Transactions. Select the Cost Centres from and to.
14.	Click OK and in the Debtor End of Period click Begin Process.

Housekeeping

There are two options in Housekeeping – only do from advice from PCSchool help desk.

Set Family Balances based on Transactions is used when; in some instances such as data being restored you have all or may families with an account Validity.
Validate Receipt Batches is used to; run through Receipt batched for a selected Period and the dissections.

Set Family Balances based on Transactions

If you have account validities for many Families you must check that the Calculated Balance is correct before running the following procedure. It is suggested that you randomly check 5 to 10 families.

	The Master File Figures are the figures from the General Ledger and should match the Calculated Balance.
2.	The Calculated balance derives its figures from Debtors and the figures totalled should equal the balance.

Validate Receipt Batches

(note: This should only be run after a Backup and PCSchool advises you to do this)

Validating receipt batches could be run before every End of Month Rollover to check the Data is correct, the process will correct some issues and may also show some errors as below.

	Select the Period to Validate.
2.	Click Verify Batches and Dissection to Debtors, if there are any problems they will be listed.
3.	The Receipt Batch number is the # number, it would be best to unfinalised and validated before continuing.

End of Month Debtors.pdf
1000 KB Download

Articles in this section

End of Month Debtors & Housekeeping