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 |
|
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
Do not do without a Backup
|
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;
|
3. |
Sundry Transactions can be consolidated to a single Invoice for each Student in Debtors Proper, you will need to enter;
|
4. |
Sundry Transactions can be consolidated to a single Balance Forward within Sundry Debtors you will need to enter;
|
5. |
Sundry Transactions can be consolidated to a single Balance Forward for each Student within Sundry Debtors you will need to enter;
|
6. |
Transactions receipted to the Cost Centre for Voluntary Payments can be automatically transferred;
|
7. |
Transactions receipted to a Cost Centre for the Foundation can be automatically transferred;
|
8. |
Transactions receipted to the Cost Centre for either the Held Deposit or Homestay can be automatically transferred;
|
9. |
Delete Transactions will clear out all finalised sundry invoices with a Zero Balance against the selected Cost Centres.
|
10. |
Delete Transactions will Delete all Transactions regardless as to whether or not they have been paid, against the selected Cost Centres;
|
11. |
Select the Cost Centres to use when Consolidating Sundries;
|
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;
|
14. |
Click OK and in the Debtor End of Period click Begin Process. |
Housekeeping
Only do from advice from PCSchool help desk and backups have been done
There are two options in Housekeeping –
- 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
Only do from advice from PCSchool help desk and backups have been done
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. |
Comments
0 comments
Article is closed for comments.