In the third and final update to the Restricted Funds we have just released a new enhancement to OPAS.

Filter by Fund in the Trial Balance

We have added filters onto the Trial Balance report so that you can filter by Restricted Fund.  This filtering allows you to not only analyse the income & expenditure codes but also full analysis of the balance sheet codes including the bank accounts and funds (or reserve) balance.

Oh, and we have also added the ability to filter by Location also!

Diocesan Parish Accounts Export (Admin Only)

The second upgrade we have released today is an OPAS parish accounts export facility.  This report is purely for diocesan admin users as it allows them to export parish accounts data in a format that can be imported into their accounting program and calculates the movement on the accounts in the balance sheet and income & expenditure codes.

Although the facility allows for the export of separate figures on a restricted or non restricted basis it is essentially an export facility that can be used without any funds set up within the Parish.

The report is accessed via a new Reports tab within the admin section and is called "Diocesan Report".  If you don't use Restricted Funds then simply select "Unrestricted funds" from the option list.

The resulting csv file represents the following fields:

Date:  This will display the year end date for the parish and is used for the journal date.

Reference:  Will be left blank and so can be manually entered within the CSV files if required.

Debit:  The total movement of the category within the current financial year on the debit side.

Credit:  The total movement of the category within the current financial year on the credit side.

Sub Category:  This is the sub category reference within OPAS.

Cost Centre:  The cost centre will normally represent the parish reference number.

Department:  R=Restricted, U=Unrestricted

Narrative:  Will show FR2009 (OPAS)

There may well be some columns that are not needed within your Diocese but as you have exported the data into CSV you can manipulate it as required.

Where this report will benefit is where admin have mirrored their main accounting codes into OPAS so that they are the same.  Therefore, it is a quick and easy process of generating the export and then importing the files into their main accouting program for each parish.

Other Updates, fixes etc

• We have been working hard to try and reduce the time it takes to load a full sub category activity report within OPAS.  As you can appreciate this can be a huge report just purely on the number of transactions a parish generates each year.  However, it is also a hugely complex report also.
• Fixed an error that was appearing on the "Add a Donation" section within the GAD details box which caused a section of the page to error.
• Fixed an error that caused an allocation problem within the envelope allocation screen if an entry in OPAS had their sub-category changed.
• Put in a block on the bank reconciliation screen to prevent dates being entered into the future under the field "Reconcile up to"