Parish Accounts Wiki - User contributions [en-gb]

Main Page

2025-09-04T11:10:29Z

Joao:

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== OPAS ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

Main Page

2025-09-04T11:09:58Z

Joao: /* OPAS */

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

== OPAS ==

{{Special:PrefixIndex/OPAS:General/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

OPAS:General/Clear Browser Cache

2025-09-04T11:08:49Z

Joao: Created page with "To clear your browser cache, open your browser's settings or "Clear browsing data" window using keyboard shortcuts (Ctrl+Shift+Del for Windows, Command+Shift+Del for Mac) or by clicking the menu icon and navigating through the settings. Select "Cached images and files," choose a time range like "All time," and then click "Clear data" to complete the process. === For Google Chrome (Windows/Mac): === * Open Chrome: and click the three-dot menu icon (⋮) in the top right..."

To clear your browser cache, open your browser's settings or "Clear browsing data" window using keyboard shortcuts (Ctrl+Shift+Del for Windows, Command+Shift+Del for Mac) or by clicking the menu icon and navigating through the settings. Select "Cached images and files," choose a time range like "All time," and then click "Clear data" to complete the process.

=== For Google Chrome (Windows/Mac): ===

* Open Chrome: and click the three-dot menu icon (⋮) in the top right corner.
* Select More tools > Clear browsing data.
* In the "Clear browsing data" box, use the dropdown menu to select the Time range (e.g., "All time").
* Make sure the checkbox next to Cached images and files is selected.
* Click Clear data to finish.

=== For other browsers (general steps): ===

* Microsoft Edge: Navigate to Settings > Privacy, search, and services > Clear browsing data now.
* Mozilla Firefox: Go to Menu > Preferences > Privacy & Security > Cookies and Site Data and click Clear Data.
* Safari: Open Safari > Preferences.

MediaWiki:Sidebar

2025-08-27T04:11:25Z

Joao:

MediaWiki:Sidebar

2025-08-27T04:10:35Z

Joao:

MediaWiki:Sidebar

2025-08-27T04:09:38Z

Joao:

* navigation
** mainpage|mainpage-description
** recentchanges-url|recentchanges
** randompage-url|randompage
** helppage|help-mediawiki
** Category:OPAS
* SEARCH
* TOOLBOX
* LANGUAGES

MediaWiki:Sidebar

2025-08-27T04:08:47Z

Joao: Created page with " * navigation ** mainpage|mainpage-description ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help-mediawiki * Category:OPAS * SEARCH * TOOLBOX * LANGUAGES"

* navigation
** mainpage|mainpage-description
** recentchanges-url|recentchanges
** randompage-url|randompage
** helppage|help-mediawiki
* Category:OPAS
* SEARCH
* TOOLBOX
* LANGUAGES

Category:OPAS

2025-08-27T04:03:38Z

Joao:

Welcome to OPAS Wiki

In here you will find various guides on how to work with OPAS

=== General ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1|hideredirects=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1|hideredirects=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1|hideredirects=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1|hideredirects=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1|hideredirects=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1|hideredirects=1}}

OPAS:General/Two Factor Authentication

2025-08-27T04:02:56Z

Joao: Added category

== What is Two Factor Authentication? ==

Two factor authentication (2FA) is a security method that requires two forms of identification to access data and resources. It's also known as multi-factor authentication (MFA) or 2-step verification (2SV).

2FA adds an extra layer of security to your accounts, making it harder for cybercriminals to access your data. It's available on most major online services, including banking, email, and social media.

== How does 2FA work? ==
* You provide your email and password to log in
* You receive a code via an Authenticator app on your mobile
* You enter the code to verify your identity
* Should you not have access to your mobile at the time, you enter one of your recovery codes

== How to enable 2FA? ==

2FA can be enabled in your profile page, which you can access by clicking on your name on the top-right corner of OPAS

At the bottom of your profile page, you will see the Two Factor Authentication box where you can:

* Enable 2FA
* Disable 2FA
* Regenerate your 2FA recovery codes

Please click <code>Enable Two Factor Authentication</code>: [[File:2fa_step_1.png]]

A popup will appear. In this popup there will be a QR code (image on the left of the popup) which you can use to register your Authenticator app with your OPAS account:

'''PLEASE DO NOT SCAN THE QR CODE BELOW. IT IS FOR ILLUSTRATION PURPOSES ONLY.'''

'''Please scan the QR code that appears in the popup on your screen on OPAS.''' [[File:2fa_step_2.png]]

=== Add OPAS to your Authenticator App ===
There are many Authenticator apps available for mobile but we suggest '''Google Authenticator''' or '''Microsoft Authenticator''':

===== Before you do, please make sure date and time is correct on your device =====
Most devices have the option to synchronise time with internet time - this is normally the default setting.

If you do not have this option or are unable to use it, please make sure the time on your device is correct TO THE SECOND. You can compare it to https://time.now/

==== Google Authenticator ====
'''1. Install the Google Authenticator app:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2]][[File:AppleStore.png|link=https://apps.apple.com/us/app/google-authenticator/id388497605]]

'''2. Click the <code>+</code> (plus) button on the bottom-right corner:''' [[File:Google_Authenticator_step_1.png]]

'''3. Choose <code>Scan a QR code</code>:''' [[File:Google_Authenticator_step_2.png]]

'''4. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''5. A code will appear on the app, with the name <code>OPAS Authentication</code>''' [[File:Google_Authenticator_step_3.png]]

==== Microsoft Authenticator ====
'''1. Install the Microsoft Authenticator App:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.azure.authenticator]][[File:AppleStore.png|link=https://apps.apple.com/us/app/microsoft-authenticator/id983156458]]

'''2. Click the QR icon button on the bottom-right corner:''' [[File:Microsoft_Authenticator_step_1.png]]

'''3. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''4. <code>OPAS Authentication</code> will appear on the app. If you click that name, you will see a code:''' [[File:Microsoft_Authenticator_step_2.png]] [[File:Microsoft_Authenticator_step_3.png]]

This <code>OPAS Authentication</code> code is a 6-digit numeric code which is renewed every minute, as indicated by the timer next to it.

=== Enter an Authenticator code ===
On the right of the popup is a field to enter one of these 6-digit numeric codes. You must enter the code as it appears on your Authenticator app and click <code>Confirm</code>: [[File:2fa_step_3.png]]<blockquote>'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>If you entered the code correctly, you will have a confirmation on the popup that Two Factor Authentication has been enabled: [[File:2fa_step_4.png]]

=== Save your Recovery Codes ===
You will also see your recovery codes. These are 8 codes which you can use as an alternative, when you cannot access your Authenticator app codes. Please keep these in a safe place. There are options for copying the codes to the clipboard, print or download them onto a text file.<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

== How to log-in with 2FA ==

You still need to enter your email and password as usual. If you have 2FA enabled, you will be presented with a new screen where you need to enter a code from your Authenticator app: [[File:2fa_step_5.png]]<blockquote>

'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>

If you do not have access to the Authenticator app at that moment, please click <code>Use a recovery code</code>. On this screen you can enter one of your recovery codes: [[File:2fa_step_6.png]]<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

To go back to using an Authenticator app code, please click <code>Use a code from your authenticator app</code>.

== Remembering Your Device ==
During login you can tick the <code>Remember me on this device for 30 days</code> checkbox so you do not need to enter a 2FA code on the browser you are using.

If you would like OPAS to forget your browser, or all browsers you set to be remembered, click the relevant link on the 2FA box in your profile page: [[File:2fa_step_7.png]]

== Troubleshooting ==
Should you have any issues activating or logging-in with 2FA, please check the following:

==== Date and time on your device ====
The date and time on your device must be correct TO THE SECOND. You can either have it synchronise with internet time (if possible), or check it against https://time.now/

===== Scanning the correct QR code =====
Please make sure you scan the QR code that appears on OPAS, and not in a different page, such as this help page

==== Check the user on your Authenticator App ====
Once you have scanned the QR code and a 2FA code appears on your Authenticator App, it should also display beside it the email you use to log-in to OPAS. Please make sure this email is correct. If it is not, you might be trying to activate 2FA while being logged-in as another user

[[Category:OPAS]]

OPAS:General/Two Factor Authentication

2025-08-19T11:51:49Z

Joao: Added Troubleshooting section

OPAS:General/Two Factor Authentication

2025-08-19T11:46:04Z

Joao: Added note on checking your device time is correct

OPAS:Contactless Giving/Preparing For A Gift Aid Claim

2025-07-14T10:44:17Z

Joao:

The donations ticked for Gift Aid need to be allocated to the Parish GAD prior to running the claim.

The parish Gift Aid Organiser will run the Year End Declaration as usual, but will identify the Contactless claim by highlighting it, as this is the only total to be included at this point.

At diocesan admin level the claim will be processed as normal but using a slightly different route, i.e. tick in ‘Summary’ the parishes to be included in the claim, then proceed to <code>Claim Gift Aid</code> but click on <code>view sponsorship claims</code> ([[OPAS:Contactless Giving/Appendix 1 - Guidelines For Parish Users - Gift-Aid|See appendix 2]]). Because the Contactless Parish GADs have been set up for sponsorship these are the only totals that will be included in the claim.

After the claim has been successfully run, the contactless donations will be removed from the rest of the parish claim which can then be reprinted and claimed as normal.
[[Category:OPAS]]

OPAS:Contactless Giving/Appendix 1 - Guidelines For Parish Users - Gift-Aid

2025-07-14T10:44:11Z

Joao:

A new parish GAD has been set up under your parish name and the contactless donations which will be listed under Donations>One offs must be allocated to this.

The Gift Aid for Contactless donations will be claimed separately from the rest of your GA claim.

When you are ready to submit a claim, please run your Year End as normal, but after printing your declaration report highlight the parish GAD claim line and send in to the Gift Aid office, stating that the claim is being submitted for the highlighted contactless donation only.

Successful submission of this claim will remove it from your normal claim.
[[Category:OPAS]]

OPAS:Contactless Giving/Appendix 1 - Guidelines For Parish Users - Accounts

2025-07-14T10:44:02Z

Joao:

We have set up two new subcategories for you –

30010.10 – Contactless Offertories GA and 30020.10 – Contactless Offertories Non GA.

Your TapnGo system will frequently generate a total of donations made – you will see the corresponding amount on your bank statement for reconciliation.

As and when it comes in, each total needs to be enter into OPAS using the date it is received as per the bank statement and listed as a BACS payment. The Gift Aid total must be ticked as such, which will also identify it as a One Off. N.B. The credit to the account will show the donation minus the transaction fee, but the whole total of Gift Aided donations must be entered so that Gift Aid can be claimed on the whole amount. The difference between the donations and the credit can be shown in a third split line, as a ‘minus’ figure, under interest paid/bank charges, 70540.

e.g.
[[File:Conactless-trans.png|750px]]
[[Category:OPAS]]

OPAS:Statistics Accounts/Entering Statistics Accounts Data

2025-07-14T10:43:46Z

Joao:

[[Category:Parish]]

You can view all available Statistics Account by going to <code>Statistics</code> in the main menu. Click the Account you wish to enter or view data

You can create a new entry by clicking <code>Create New Entry</code> or edit an existing entry, if one exists

Once you are in the entry form, you can click <code>Save</code> at any point should you need to continue entering data at some other time

To complete the data entry, click <code>Submit</code>. This will lock the data for submission and prevent any further changes to it
[[Category:OPAS]]

OPAS:Gift-Aid/Correcting Errors And Faults

2025-07-14T10:43:32Z

Joao:

== Adding in donations to GA without first going through the parish accounts side ==

★ '''BE VERY CAREFUL''' – do not do this unless you are sure the donation did go through the bank but was not recorded in OPAS as such (usually only used when initially setting up a parish)

Go to <code>Admin > Gift-Aid</code> tab, then enter donations, type in parish reference and then click show turnround and change tax year if needed. Then add donations and change the date from the default end of tax year to the date which it actually was received.

== Gift Aid Envelopes – delete an entire weekly allocation ==

This is most likely to happen if a 2nd collection has been taken for another charity, e.g. CAFOD, where donations are not eligible for Gift Aid for the parish. Simply remove the tick from the split line, and update the transaction. This will remove it completely from the Gift Aid side, even if the donations had already been allocated to donors.

== Bounced cheque given via offertory envelope which is Gift Aided ==

Enter using the money out screen and code the bounced offertory cheque to whichever original category was used.

In the accounts side of OPAS alter the mix split of the original weekly income sheet so that the GA total is reduced by the amount of the cheque and the Offs Non GA is increased by the same amount so that the total banked stays the same. This will mean the total originally balanced to in the GA side of the programme changes. The batch of envelopes will return back to the unallocated or saved envelope folders within the donations black tab within the GA side of OPAS. Open the batch and delete the bounced cheque allocation donor line. This will then re-balance and get rid of it and make the donor record correct.

You will also need to make a note on the paper copy of the w i sheet to complete the audit trail.

''It is worth noting that bounced cheques can be dealt with at parish level but users may well need help and support and this topic is not covered in the parish user manual.''

== Other Common Mistakes ==

=== Not ticking the “One Off” box when entering one off G A donation in the weekly income ===

This will cause it to appear under the Envelope tab in the Gift Aid side. This can be corrected at parish level in the accounts side. For a single donation, ticking the one off box will move the donation in the GA side from the Envelope tab to the One Off tab. If multiple One Off donations are added as a single split line, and only ticked as Gift Aid. It must be corrected by first unticking the Gift Aid box, and clicking the update this transaction button. This will remove the envelope transaction from the G A side, and will also remove from the donors records any donations allocated by envelope number from this split. The weekly income transaction should then be edited to show each One Off on a separate split line, with the relevant donor name against each one, and both Gift Aid and One Off boxes ticked. CARE- make sure the overall total for the transaction remains unaltered.

=== Not setting up a new recurring transaction for a GA Standing Order if a donor’s spouse becomes the Gift Aid donor ===

If the donations wrongly posted to the original donor record have not been reconciled, this can be corrected at parish level, by simply deleting them. If they have been reconciled, or if the corrections require the year end to be rolled back, they have to be done by an Admin user.

=== Not closing an envelope number when a G A declaration is terminated ===

This means that the donations by the new user of the envelope number go onto the terminated record. This can be rectified at parish level by deleting the donations from the weekly envelope transactions, closing the envelope and then adding it to the correct donor and reallocating the donations.

=== Closing the envelope number on the wrong date ===

This can only be changed by an Admin level user.

=== Using the wrong template when adding a new GAD ===

One Off Donor instead of 99yr and vice versa. The only way out is to unallocate any donations, delete the wrong form and add the correct one, then re-allocate any donations.

=== A One Off donation has been allocated to the wrong donor ===

Go to the One Off tab under donations, and click on the blue cross to the left of the relevant donation. This will bring up the list of donors, select the correct one and then click on the “allocate donation” button.

=== A Standing Order has been allocated to the wrong donor, or the wrong GAD This should only be done if the SO has genuinely been allocated to the wrong donor ===

Go to Gift Aid, Donations, Standing Orders, allocated. Select the entry from the list and click on the red word “edit” at the right of the row. This opens up the allocation screen. Enter the name of the correct donor in the text boxes at the bottom left of the screen, select the correct Gad from the matched parishioner list, and click update Standing Order. This can be done at parish user level but it might be best not to publicise this too widely
[[Category:OPAS]]

OPAS:Gift-Aid/Correcting Standing Order Allocation Mistakes

2025-07-14T10:43:24Z

Joao:

Go to <code>donations > standing orders > allocated</code> and find the Standing Order you have wrongly allocated by sorting by the column heading.

On the right hand side of the row is <code>edit</code> in red type.

Click <code>edit</code>, this will open up the recurring entry screen. Go to the <code>allocation</code> section and type in the surname and this time select the correct gad.
[[Category:OPAS]]

OPAS:Gift-Aid/Entering Donations Where The Parish Is Using OPAS For Gift-Aid Only

2025-07-14T10:43:17Z

Joao:

N.B. For parishes using OPAS for Gift Aid only, it is necessary to activate it for Accounts in order to set up the bank account details. Once this is done it can be deactivated for Accounts.

=== Adding Weekly Income transactions. ===

Go to donations, then Add Donations. Enter the details in the fields, and then the overall total of the envelope donations. If there are one off donations within the weekly income, click on “Split” at the end of the line to add the one offs. Add each one on a separate split line with the name of the donor added after “Weekly Income”, and tick the one off box at the end of the split line. When all the donations are entered, click on the “submit all entries” button at the bottom of the screen.

[[File:Ga-add-dons.png|750px]]

=== Adding One Offs received outside of weekly collections. ===
Go to donations, then One Off donations, Post a one-off donation. Enter the details in the fields, one line for each donation, and then click the “submit all entries” button at the bottom of the screen.

=== Adding New Standing Orders ===

Make sure the donor’s Gad has been added and approved before you create the Standing Order.

Go to <code>Donations > Standing Orders > New Standing Order</code>. Enter the name of the donor in the relevant search fields, and then select the correct entry from the list on the right. Enter the transaction details in the relevant fields, check that the donor details displayed at the bottom of the screen are correct, and then click on the <code>Add This Standing Order</code> button. A message will appear on the screen when the process has been completed, and all the transactions up to date have been added to the donor record.

=== Allocating envelope donations to donors ===
Go to <code>Donations > Envelopes</code>, to bring up unallocated weekly envelope transactions. Click on the weekly total that you wish to allocate.

This will take you to <code>Allocate Envelopes</code>.

Here you are able to see the total required for you to allocate for that particular week’s income.

Insert the envelope number and tab to insert the amount paid via that number and keep using the tab key to move to the next envelope number or amount. The system will flag up a message if any envelope numbers you have inserted have not been matched to parishioners. There may also be a “Duplicate Number Found” message if the envelope number has not been closed on the previous user’s record. You will need to search for the envelope number in the ‘Parishioner Details’ tab and take the tick out of the ‘Status’ box. You will then see all the records for that particular number and can open the matched record, go to the Envelope tab and click on the word ‘close’ in red, insert the relevant date and then you will only have one record for that number.

If, however, there have been donations posted to the incorrect record, these must be removed prior to closing. To go back to allocating, go to <code>Donations > Envelopes > Saved Envelopes</code> and you should be able to continue.

The total allocated is shown at the top of the page along with an unallocated total so you can check your inputting as you progress. You are able to amend any mistakes in the amount box by overtyping with the correct amount as you go along. When you have finished inputting the weekly envelopes you should have £0.00 unallocated and then should click on <code>Process Envelopes</code> and this will remove the weekly income total from the ‘Unallocated Envelopes’ list.

Any amendments required AFTER the envelopes have been posted can be done by going to “All Envelopes” and selecting the relevant date, and double clicking on the line to open it. Amendments can then be made by clicking on the red cross to the left of the incorrect donation to remove it, and then adding the correct donation at the bottom. When all the amendments are done, and the unallocated amount has returned to £0.00, click the <code>Process</code> button to save the changes.

=== Allocating One Off Donations ===
Go to <code>Donations > One-Off Donations</code>. A list of one-off donations will appear. For any unallocated donations, the ‘Parishioner’ column will quote the word “Allocate” rather than the donor’s name.

Click on <code>Allocate</code> on the one off donation you wish to allocate. Choose the parishioner name from the drop down menu and click the ‘Allocate Donation’ button (care: if the donor has made one off donations before, you need to ensure you select the donor’s name with the correct Gad number from the list (the gad number you see when you create the most recent parishioner record).

THE DATE ON THE ENVELOPE MUST BE THE SAME AS THE DATE OF THE WEEKLY INCOME WHICH INCLUDES THE DONATION (EXCEPT WHERE THE DONATION HAS BEEN MADE AT A SATURDAY EVENING MASS AND IS THEREFORE DATED ONE DAY EARLIER THAN THE WEEKLY INCOME SUNDAY DATE.)
[[Category:OPAS]]

OPAS:Accounting/Correcting Cheque Numbers

2025-07-14T10:42:49Z

Joao:

Search for the incorrect cheque number (it will be the next no. presented on the money out screen less 1) and then correct the cheque number. This will then reset the counter to the next correct number.
[[Category:OPAS]]

OPAS:Accounting/Bounced Cheque Given Via Offertory Envelope Which Is Gift-Aided

2025-07-14T10:42:41Z

Joao:

Enter using the money out screen and code the bounced offertory cheque to whichever original category was used.

In the accounts side of OPAS alter the mix split of the original weekly income sheet so that the GA total is reduced by the amount of the cheque and the Offs Non GA is increased by the same amount so that the total banked stays the same. This will mean the total originally balanced to in the GA side of the programme changes. The batch of envelopes will return back to the unallocated or saved envelope folders within the donations black tab within the GA side of OPAS. Open the batch and delete the bounced cheque allocation donor line. This will then re-balance and get rid of it and make the donor record correct.

You will also need to make a note on the paper copy of the w i sheet to complete the audit trail.

''It is worth noting that bounced cheques can be dealt with at parish level but users may well need help and support and this topic is not covered in the parish user manual.''
[[Category:OPAS]]

OPAS:Accounting/Importing Bank Statements

2025-07-14T10:42:25Z

Joao:

As an alternative to manually entering and reconciling transactions in the OPAS ledger to the bank statement, you can import the bank data from a download generated in your online banking website which will facilitate the auto-matching of transactions on the reconciliation and ensure standing orders and direct debits appear on the ledger with the correct dates.

Currently supported banks are:

* NatWest
* Royal Bank of Scotland (RBS)
* Lloyds (business banking accounts only)
* Bank of Scotland

The Bank Import feature only supports CSV files. Please make sure you select the correct export options in your banking website.

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

== Prerequisites ==

In order to use this feature, you must make sure your bank accounts have a correct Account Number and Sort Code on OPAS.

Please go to <code>Bank Accounts > Accounts</code> and confirm the account number and sort code have been correctly entered. Please contact your Diocesan OPAS Administrator to ensure your Parish bank details are correct.

'''Please make sure all your bank accounts have unique account numbers.'''

[[File:Bank-account-dropdown.png]] [[File:Bank-account-edit-fields.png]]

== How To Import Bank Statements? ==

In order to use the Import Bank Statements facility, an administrator in your Diocese needs to enable this for your parish.

You can access the bank import page via the main menu - <code>Bank Accounts > Import Bank Statements</code>. If your Parish has more than one bank account you will need to select which account are you importing data to.

[[File:Bank-import-index.png]]

On this screen you can upload a bank statement by first choosing a file from your computer, and then clicking <code>Upload</code>.

'''Please note ONLY CSV files are supported.'''

Below you can also see a list of previously uploaded statements, if any. You can click the <code>Reconcile</code> button to resume the reconciliation of that statement.

== Reconciling a Bank Statement ==

Once you have successfully uploaded a statement, you will be presented with a list of transactions from the statement and possible reconciliation options:

[[File:Bank-import-transaction.png]]

The transaction information from the statement is presented on the left and the possible reconciliation options are presented on the right.

For each line on your bank statement:

* If OPAS finds an existing OPAS transaction that may match the bank import transaction, it will suggest the match(es)
* You can then either
** Match the line with an existing OPAS transaction - '''Match'''
** Reject the suggested match and create a new OPAS transaction - '''Create'''
* If OPAS cannot find a likely match, you can only create a new OPAS transaction - '''Create'''

This process is explained in more detail below.

== Match An Existing OPAS Transaction ==

If any possible matches are found you will see a list from which you can select the correct transaction:

[[File:Bank-import-match-transaction.png]]

If you spot any inconsistencies on the OPAS transaction, you can edit the matched transaction using the fields available. If the transaction has multiple lines, you can edit each line by clicking the <code>Edit</code> button below the lines:

[[File:Bank-import-match-lines.png]]

If the date in the statement line and the date in the OPAS transaction do not match, once the statement is reconciled, the OPAS transaction will be updated to the date in the statement - '''Please note this will not happen for Cheques or Cash.'''

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-match-saved.png]]

Furthermore, if the same OPAS transaction was found to be a match to more than one line on the statement, this match will be locked out of any other lines:

[[File:Bank-import-locked-match.png]]

'''If no matches are found, before considering creating that transaction on OPAS, please make sure that it doesn't exist already and the mismatch was due to a different reference.'''

== Create a new OPAS Transaction ==

'''Please note that all Gift-Aid standing orders must be set-up as recurring entries in OPAS to ensure they can be correctly allocated to the donor record.'''

You can create a new OPAS transaction using the data from the statement:

[[File:Bank-import-create-transaction.png]]

If you wish to add more lines to this transaction, please use the <code>Click here…</code> link:

[[File:Bank-import-create-lines.png]]

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-create-saved.png]]

== Ignoring a Transaction on the Statement ==

There will be some cases where you will be unable to match or create a transaction. Some examples are:

* A single transaction on the statement matches more than one OPAS transactions
* Multiple transactions on the statement match a single/split OPAS transaction
* A bank transfer on the statement matches an OPAS non-transfer transaction
* A non-transfer transaction on the statement matches an OPAS bank transfer

For such cases you would need to reconcile these particular OPAS transactions/bank transfers using the classic <code>Reconcile The Bank</code> page.

OPAS will indicate that these transactions still need to be reconciled. You can instruct the system to ignore them by clicking the <code>Ignore</code> button. This will mark the transaction as ignored:

[[File:Bank-import-transaction-ignore.png]]

You will need to click <code>Cancel Ignore</code> if you wish to reconcile the transaction at a future date.

'''Ignoring a transaction or canceling is applied immediately - you do not need to reconcile the statement.'''

== Committing the Reconciliation ==

Once you have saved at least one statement line, the Reconcile button will be enabled in the top bar:

[[File:Bank-import-top-bar.png]]

Please check that the Statement Number and Reconcile Up To date are correct.

'''The Reconcile Up To date should be the same date you entered when creating the CSV in your bank website - even if there are no transactions right up to that date. '''

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

Once you are ready, click the <code>Reconcile</code> button.

You do not need to reconcile the entire statement in a single session. If you only reconcile part of the statement, you can return to this page and resume work by clicking the statement on the previously uploaded list:

[[File:Bank-import-index-previously-uploaded.png]]

== Post Reconciliation procedures ==
Generate/print/save a Bank Reconciliation Report in accordance with your Diocesan Finance instructions.

If appropriate, deal with any unreconciled transactions as evidenced from the report above – this may include deleting transactions which are not going to happen or advancing the dates of standing orders for example.

If you input spoiled cheques as “nil” value transactions or if you have created a contra credit for cheques dated more than 6 months previously you will need to do a supplementary bank reconciliation using the standard OPAS bank reconciliation feature to “clear” these items. It is suggested you alter the suggested bank statement sheet number back to the one you just did and do not advance the date.

Once you have done all the above generate a further bank reconciliation report to check all is well and retain according to your Diocesan Finance instructions.
[[Category:OPAS]]

Category:OPAS

2025-07-14T10:40:37Z

Joao:

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== General ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1|hideredirects=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1|hideredirects=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1|hideredirects=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1|hideredirects=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1|hideredirects=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1|hideredirects=1}}

OPAS:Accounting/Input Weekly Income As 2 Or More Bank Transactions

2025-07-14T10:37:39Z

Joao:

'''Inputting weekly income as 2 separate paying in slips''' (where cheques have to be separated at the paying in stage at the bank and the credits may not hit the statement on the same day)

Input the entire weekly income sheet as if it were going to be paid in on one slip. Then add an extra line at the end categorising to Off Non GA , where weekly income has copied down in the reference field type “cheques” next to it, then input the value of the cheques paid in on a separate cheque in the box with a minus sign in front of it. This will reduce the total of the credit to the value of all the cash. Then do a second money in USING THE SAME SUNDAY DATE as a single line entry to Offs Non GA again annotating it “cheques” for the value of the cheques. This will make bank rec easy if the credits don’t hit the bank on the same day and also preserve the WI sheet split.
[[Category:OPAS]]

Category:OPAS

2025-07-14T10:36:01Z

Joao:

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== General ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

Category:OPAS

2025-07-14T10:35:36Z

Joao:

{{DISPLAYTITLE:OPAS}}

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== General ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

OPAS:General/Two Factor Authentication

2025-07-14T10:34:47Z

Joao:

== What is Two Factor Authentication? ==

Two factor authentication (2FA) is a security method that requires two forms of identification to access data and resources. It's also known as multi-factor authentication (MFA) or 2-step verification (2SV).

2FA adds an extra layer of security to your accounts, making it harder for cybercriminals to access your data. It's available on most major online services, including banking, email, and social media.

== How does 2FA work? ==
* You provide your email and password to log in
* You receive a code via an Authenticator app on your mobile
* You enter the code to verify your identity
* Should you not have access to your mobile at the time, you enter one of your recovery codes

== How to enable 2FA? ==

2FA can be enabled in your profile page, which you can access by clicking on your name on the top-right corner of OPAS

At the bottom of your profile page, you will see the Two Factor Authentication box where you can:

* Enable 2FA
* Disable 2FA
* Regenerate your 2FA recovery codes

Please click <code>Enable Two Factor Authentication</code>: [[File:2fa_step_1.png]]

A popup will appear. In this popup there will be a QR code (image on the left of the popup) which you can use to register your Authenticator app with your OPAS account: [[File:2fa_step_2.png]]

=== Add OPAS to your Authenticator App ===
There are many Authenticator apps available for mobile but we suggest '''Google Authenticator''' or '''Microsoft Authenticator''':

==== Google Authenticator ====
'''1. Install the Google Authenticator app:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2]][[File:AppleStore.png|link=https://apps.apple.com/us/app/google-authenticator/id388497605]]

'''2. Click the <code>+</code> (plus) button on the bottom-right corner:''' [[File:Google_Authenticator_step_1.png]]

'''3. Choose <code>Scan a QR code</code>:''' [[File:Google_Authenticator_step_2.png]]

'''4. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''5. A code will appear on the app, with the name <code>OPAS Authentication</code>''' [[File:Google_Authenticator_step_3.png]]

==== Microsoft Authenticator ====
'''1. Install the Microsoft Authenticator App:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.azure.authenticator]][[File:AppleStore.png|link=https://apps.apple.com/us/app/microsoft-authenticator/id983156458]]

'''2. Click the QR icon button on the bottom-right corner:''' [[File:Microsoft_Authenticator_step_1.png]]

'''3. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''4. <code>OPAS Authentication</code> will appear on the app. If you click that name, you will see a code:''' [[File:Microsoft_Authenticator_step_2.png]] [[File:Microsoft_Authenticator_step_3.png]]

This <code>OPAS Authentication</code> code is a 6-digit numeric code which is renewed every minute, as indicated by the timer next to it.

=== Enter an Authenticator code ===
On the right of the popup is a field to enter one of these 6-digit numeric codes. You must enter the code as it appears on your Authenticator app and click <code>Confirm</code>: [[File:2fa_step_3.png]]<blockquote>'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>If you entered the code correctly, you will have a confirmation on the popup that Two Factor Authentication has been enabled: [[File:2fa_step_4.png]]

=== Save your Recovery Codes ===
You will also see your recovery codes. These are 8 codes which you can use as an alternative, when you cannot access your Authenticator app codes. Please keep these in a safe place. There are options for copying the codes to the clipboard, print or download them onto a text file.<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

== How to log-in with 2FA ==

You still need to enter your email and password as usual. If you have 2FA enabled, you will be presented with a new screen where you need to enter a code from your Authenticator app: [[File:2fa_step_5.png]]<blockquote>

'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>

If you do not have access to the Authenticator app at that moment, please click <code>Use a recovery code</code>. On this screen you can enter one of your recovery codes: [[File:2fa_step_6.png]]<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

To go back to using an Authenticator app code, please click <code>Use a code from your authenticator app</code>.

== Remembering Your Device ==
During login you can tick the <code>Remember me on this device for 30 days</code> checkbox so you do not need to enter a 2FA code on the browser you are using.

If you would like OPAS to forget your browser, or all browsers you set to be remembered, click the relevant link on the 2FA box in your profile page: [[File:2fa_step_7.png]]
[[Category:OPAS]]

OPAS and Gift-Aid:Admin Manual/Two Factor Authentication

2025-07-14T10:34:09Z

Joao: Joao moved page OPAS and Gift-Aid:Admin Manual/Two Factor Authentication to OPAS:General/Two Factor Authentication

#REDIRECT [[OPAS:General/Two Factor Authentication]]

OPAS:General/Two Factor Authentication

2025-07-14T10:34:08Z

Joao: Joao moved page OPAS and Gift-Aid:Admin Manual/Two Factor Authentication to OPAS:General/Two Factor Authentication

== What is Two Factor Authentication? ==

Two factor authentication (2FA) is a security method that requires two forms of identification to access data and resources. It's also known as multi-factor authentication (MFA) or 2-step verification (2SV).

2FA adds an extra layer of security to your accounts, making it harder for cybercriminals to access your data. It's available on most major online services, including banking, email, and social media.

== How does 2FA work? ==
* You provide your email and password to log in
* You receive a code via an Authenticator app on your mobile
* You enter the code to verify your identity
* Should you not have access to your mobile at the time, you enter one of your recovery codes

== How to enable 2FA? ==

2FA can be enabled in your profile page, which you can access by clicking on your name on the top-right corner of OPAS

At the bottom of your profile page, you will see the Two Factor Authentication box where you can:

* Enable 2FA
* Disable 2FA
* Regenerate your 2FA recovery codes

Please click <code>Enable Two Factor Authentication</code>: [[File:2fa_step_1.png]]

A popup will appear. In this popup there will be a QR code (image on the left of the popup) which you can use to register your Authenticator app with your OPAS account: [[File:2fa_step_2.png]]

=== Add OPAS to your Authenticator App ===
There are many Authenticator apps available for mobile but we suggest '''Google Authenticator''' or '''Microsoft Authenticator''':

==== Google Authenticator ====
'''1. Install the Google Authenticator app:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2]][[File:AppleStore.png|link=https://apps.apple.com/us/app/google-authenticator/id388497605]]

'''2. Click the <code>+</code> (plus) button on the bottom-right corner:''' [[File:Google_Authenticator_step_1.png]]

'''3. Choose <code>Scan a QR code</code>:''' [[File:Google_Authenticator_step_2.png]]

'''4. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''5. A code will appear on the app, with the name <code>OPAS Authentication</code>''' [[File:Google_Authenticator_step_3.png]]

==== Microsoft Authenticator ====
'''1. Install the Microsoft Authenticator App:''' [[File:GooglePlay.png|link=https://play.google.com/store/apps/details?id=com.azure.authenticator]][[File:AppleStore.png|link=https://apps.apple.com/us/app/microsoft-authenticator/id983156458]]

'''2. Click the QR icon button on the bottom-right corner:''' [[File:Microsoft_Authenticator_step_1.png]]

'''3. The camera will be turned on, focus and frame the QR code on your screen with your phone camera'''

'''4. <code>OPAS Authentication</code> will appear on the app. If you click that name, you will see a code:''' [[File:Microsoft_Authenticator_step_2.png]] [[File:Microsoft_Authenticator_step_3.png]]

This <code>OPAS Authentication</code> code is a 6-digit numeric code which is renewed every minute, as indicated by the timer next to it.

=== Enter an Authenticator code ===
On the right of the popup is a field to enter one of these 6-digit numeric codes. You must enter the code as it appears on your Authenticator app and click <code>Confirm</code>: [[File:2fa_step_3.png]]<blockquote>'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>If you entered the code correctly, you will have a confirmation on the popup that Two Factor Authentication has been enabled: [[File:2fa_step_4.png]]

=== Save your Recovery Codes ===
You will also see your recovery codes. These are 8 codes which you can use as an alternative, when you cannot access your Authenticator app codes. Please keep these in a safe place. There are options for copying the codes to the clipboard, print or download them onto a text file.<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

== How to log-in with 2FA ==

You still need to enter your email and password as usual. If you have 2FA enabled, you will be presented with a new screen where you need to enter a code from your Authenticator app: [[File:2fa_step_5.png]]<blockquote>

'''Note: Please make sure you enter the code within the time period. If it ends, a new code will appear and you must enter this instead.'''</blockquote>

If you do not have access to the Authenticator app at that moment, please click <code>Use a recovery code</code>. On this screen you can enter one of your recovery codes: [[File:2fa_step_6.png]]<blockquote>'''Note: all recovery codes are single-use. Please erase any recovery codes you use for logging-in'''</blockquote>

To go back to using an Authenticator app code, please click <code>Use a code from your authenticator app</code>.

== Remembering Your Device ==
During login you can tick the <code>Remember me on this device for 30 days</code> checkbox so you do not need to enter a 2FA code on the browser you are using.

If you would like OPAS to forget your browser, or all browsers you set to be remembered, click the relevant link on the 2FA box in your profile page: [[File:2fa_step_7.png]]

Category:OPAS

2025-07-14T10:33:48Z

Joao:

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== General ===

{{Special:PrefixIndex/OPAS:General/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

OPAS:General/Browsers

2025-07-14T10:32:53Z

Joao:

OPAS works best with Google Chrome but will work with most browsers including those included on tablets and phones. It also works with Apple computers, tablets and phones. Particularly with MACS the screens may look a little different and keys such as “tab” will sometimes work differently and cause confusion.

Internet explorer often causes problems when a new version comes out. If this happened, it is worth checking that your version of I/E is not working in “compatibility mode. To do this, when viewing a page press the F12 button and a 4 window will pop up at the bottom of the screen. Look at the grey line at the top of this new screen to see. To change it click it and then select the current version of IE.

To be correct the screen should look like this (but latest version)

[[File:Admin-browsers.png|750px]]

Click file and exit to get rid of the window

[[Category:OPAS]]

OPAS and Gift-Aid:Admin Manual/Browsers

2025-07-14T10:32:35Z

Joao: Joao moved page OPAS and Gift-Aid:Admin Manual/Browsers to OPAS:General/Browsers

#REDIRECT [[OPAS:General/Browsers]]

OPAS:General/Browsers

2025-07-14T10:32:35Z

Joao: Joao moved page OPAS and Gift-Aid:Admin Manual/Browsers to OPAS:General/Browsers

{{DISPLAYTITLE:OPAS:General/Browsers}}

OPAS works best with Google Chrome but will work with most browsers including those included on tablets and phones. It also works with Apple computers, tablets and phones. Particularly with MACS the screens may look a little different and keys such as “tab” will sometimes work differently and cause confusion.

Internet explorer often causes problems when a new version comes out. If this happened, it is worth checking that your version of I/E is not working in “compatibility mode. To do this, when viewing a page press the F12 button and a 4 window will pop up at the bottom of the screen. Look at the grey line at the top of this new screen to see. To change it click it and then select the current version of IE.

To be correct the screen should look like this (but latest version)

[[File:Admin-browsers.png|750px]]

Click file and exit to get rid of the window

{{DEFAULTSORT:OPAS:General/Browsers}}
[[Category:OPAS]]

OPAS:General/Browsers

2025-07-14T10:32:00Z

Joao:

OPAS:General/Browsers

2025-07-14T10:30:14Z

Joao:

{{DISPLAYTITLE:OPAS:General/Browsers}}
{{DISPLAYTITLE:OPAS:General/Browsers}}

OPAS works best with Google Chrome but will work with most browsers including those included on tablets and phones. It also works with Apple computers, tablets and phones. Particularly with MACS the screens may look a little different and keys such as “tab” will sometimes work differently and cause confusion.

Internet explorer often causes problems when a new version comes out. If this happened, it is worth checking that your version of I/E is not working in “compatibility mode. To do this, when viewing a page press the F12 button and a 4 window will pop up at the bottom of the screen. Look at the grey line at the top of this new screen to see. To change it click it and then select the current version of IE.

To be correct the screen should look like this (but latest version)

[[File:Admin-browsers.png|750px]]

Click file and exit to get rid of the window

{{DEFAULTSORT:OPAS:General/Browsers}}
[[Category:OPAS]]

OPAS:General/Browsers

2025-07-14T10:28:11Z

Joao:

Category:OPAS

2025-07-14T10:26:28Z

Joao: /* OPAS */

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== General ===

{{Special:PrefixIndex/OPAS and Gift-Aid:Admin Manual/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

Category:OPAS

2025-07-14T10:25:23Z

Joao: Created page with "Welcome to OPAS and Parish DB Wiki In here you will find various guides on how to work with OPAS and Parish DB === OPAS === {{Special:PrefixIndex/OPAS and Gift-Aid:Admin Manual/|stripprefix=1}} === Accounting === {{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}} === Gift-Aid === {{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}} === Statistics Accounts === {{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}} === Contactless Gi..."

Welcome to OPAS and Parish DB Wiki

In here you will find various guides on how to work with OPAS and Parish DB

=== OPAS ===

{{Special:PrefixIndex/OPAS and Gift-Aid:Admin Manual/|stripprefix=1}}

=== Accounting ===

{{Special:PrefixIndex/OPAS:Accounting/|stripprefix=1}}

=== Gift-Aid ===

{{Special:PrefixIndex/OPAS:Gift-Aid/|stripprefix=1}}

=== Statistics Accounts ===

{{Special:PrefixIndex/OPAS:Statistics Accounts/|stripprefix=1}}

=== Contactless Giving (Tap 'N' Go) ===

{{Special:PrefixIndex/OPAS:Contactless Giving/|stripprefix=1}}

{{Special:PrefixIndex/OPAS:GDPR/|stripprefix=1}}

OPAS:General/Browsers

2025-07-14T10:24:14Z

Joao:

OPAS:Accounting/Importing Bank Statements

2025-06-03T10:28:11Z

Joao:

OPAS:Accounting/Importing Bank Statements

2025-05-07T09:26:46Z

Joao: Added disclaimer on how all bank accounts must be unique

As an alternative to manually entering and reconciling transactions in the OPAS ledger to the bank statement, you can import the bank data from a download generated in your online banking website which will facilitate the auto-matching of transactions on the reconciliation and ensure standing orders and direct debits appear on the ledger with the correct dates.

Currently supported banks are:

* NatWest
* Royal Bank of Scotland (RBS)
* Lloyds (business banking accounts only)
* Bank of Scotland

The Bank Import feature only supports CSV files. Please make sure you select the correct export options in your banking website.

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

== Prerequisites ==

In order to use this feature, you must make sure your bank accounts have a correct Account Number and Sort Code on OPAS.

Please go to <code>Bank Accounts > Accounts</code> and confirm the account number and sort code have been correctly entered. Please contact your Diocesan OPAS Administrator to ensure your Parish bank details are correct.

'''Please make sure all your bank accounts have unique account numbers.'''

[[File:Bank-account-dropdown.png]] [[File:Bank-account-edit-fields.png]]

== How To Import Bank Statements? ==

In order to use the Import Bank Statements facility, an administrator in your Diocese needs to enable this for your parish.

You can access the bank import page via the main menu - <code>Bank Accounts > Import Bank Statements</code>. If your Parish has more than one bank account you will need to select which account are you importing data to.

[[File:Bank-import-index.png]]

On this screen you can upload a bank statement by first choosing a file from your computer, and then clicking <code>Upload</code>.

'''Please note ONLY CSV files are supported.'''

Below you can also see a list of previously uploaded statements, if any. You can click the <code>Reconcile</code> button to resume the reconciliation of that statement.

== Reconciling a Bank Statement ==

Once you have successfully uploaded a statement, you will be presented with a list of transactions from the statement and possible reconciliation options:

[[File:Bank-import-transaction.png]]

The transaction information from the statement is presented on the left and the possible reconciliation options are presented on the right.

For each line on your bank statement:

* If OPAS finds an existing OPAS transaction that may match the bank import transaction, it will suggest the match(es)
* You can then either
** Match the line with an existing OPAS transaction - '''Match'''
** Reject the suggested match and create a new OPAS transaction - '''Create'''
* If OPAS cannot find a likely match, you can only create a new OPAS transaction - '''Create'''

This process is explained in more detail below.

== Match An Existing OPAS Transaction ==

If any possible matches are found you will see a list from which you can select the correct transaction:

[[File:Bank-import-match-transaction.png]]

If you spot any inconsistencies on the OPAS transaction, you can edit the matched transaction using the fields available. If the transaction has multiple lines, you can edit each line by clicking the <code>Edit</code> button below the lines:

[[File:Bank-import-match-lines.png]]

If the date in the statement line and the date in the OPAS transaction do not match, once the statement is reconciled, the OPAS transaction will be updated to the date in the statement - '''Please note this will not happen for Cheques or Cash.'''

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-match-saved.png]]

Furthermore, if the same OPAS transaction was found to be a match to more than one line on the statement, this match will be locked out of any other lines:

[[File:Bank-import-locked-match.png]]

'''If no matches are found, before considering creating that transaction on OPAS, please make sure that it doesn't exist already and the mismatch was due to a different reference.'''

== Create a new OPAS Transaction ==

'''Please note that all Gift-Aid standing orders must be set-up as recurring entries in OPAS to ensure they can be correctly allocated to the donor record.'''

You can create a new OPAS transaction using the data from the statement:

[[File:Bank-import-create-transaction.png]]

If you wish to add more lines to this transaction, please use the <code>Click here…</code> link:

[[File:Bank-import-create-lines.png]]

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-create-saved.png]]

== Ignoring a Transaction on the Statement ==

There will be some cases where you will be unable to match or create a transaction. Some examples are:

* A single transaction on the statement matches more than one OPAS transactions
* Multiple transactions on the statement match a single/split OPAS transaction
* A bank transfer on the statement matches an OPAS non-transfer transaction
* A non-transfer transaction on the statement matches an OPAS bank transfer

For such cases you would need to reconcile these particular OPAS transactions/bank transfers using the classic <code>Reconcile The Bank</code> page.

OPAS will indicate that these transactions still need to be reconciled. You can instruct the system to ignore them by clicking the <code>Ignore</code> button. This will mark the transaction as ignored:

[[File:Bank-import-transaction-ignore.png]]

You will need to click <code>Cancel Ignore</code> if you wish to reconcile the transaction at a future date.

'''Ignoring a transaction or canceling is applied immediately - you do not need to reconcile the statement.'''

== Committing the Reconciliation ==

Once you have saved at least one statement line, the Reconcile button will be enabled in the top bar:

[[File:Bank-import-top-bar.png]]

Please check that the Statement Number and Reconcile Up To date are correct.

'''The Reconcile Up To date should be the same date you entered when creating the CSV in your bank website - even if there are no transactions right up to that date. '''

'''The exception to this should be when you are only reconciling part of the statement, in which case you should set the Reconcile Up To date to match the most recent transaction you are reconciling.'''

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

Once you are ready, click the <code>Reconcile</code> button.

You do not need to reconcile the entire statement in a single session. If you only reconcile part of the statement, you can return to this page and resume work by clicking the statement on the previously uploaded list:

[[File:Bank-import-index-previously-uploaded.png]]

OPAS:Accounting/Importing Bank Statements

2025-04-15T11:36:22Z

Joao: Created page with "As an alternative to manually entering and reconciling transactions in the OPAS ledger to the bank statement, you can import the bank data from a download generated in your online banking website which will facilitate the auto-matching of transactions on the reconciliation and ensure standing orders and direct debits appear on the ledger with the correct dates. Currently supported banks are: * NatWest * Royal Bank of Scotland * Lloyds (business banking accounts only)..."

As an alternative to manually entering and reconciling transactions in the OPAS ledger to the bank statement, you can import the bank data from a download generated in your online banking website which will facilitate the auto-matching of transactions on the reconciliation and ensure standing orders and direct debits appear on the ledger with the correct dates.

Currently supported banks are:

* NatWest
* Royal Bank of Scotland
* Lloyds (business banking accounts only)

The Bank Import feature only supports CSV files. Please make sure you select the correct export options in your banking website.

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

== Prerequisites ==

In order to use this feature, you must make sure your bank accounts have a correct Account Number and Sort Code on OPAS.

Please go to <code>Bank Accounts > Accounts</code> and confirm the account number and sort code have been correctly entered. Please contact your Diocesan OPAS Administrator to ensure your Parish bank details are correct.

[[File:Bank-account-dropdown.png]] [[File:Bank-account-edit-fields.png]]

== How To Import Bank Statements? ==

In order to use the Import Bank Statements facility, an administrator in your Diocese needs to enable this for your parish.

You can access the bank import page via the main menu - <code>Bank Accounts > Import Bank Statements</code>. If your Parish has more than one bank account you will need to select which account are you importing data to.

[[File:Bank-import-index.png]]

On this screen you can upload a bank statement by first choosing a file from your computer, and then clicking <code>Upload</code>.

'''Please note ONLY CSV files are supported.'''

Below you can also see a list of previously uploaded statements, if any. You can click the <code>Reconcile</code> button to resume the reconciliation of that statement.

== Reconciling a Bank Statement ==

Once you have successfully uploaded a statement, you will be presented with a list of transactions from the statement and possible reconciliation options:

[[File:Bank-import-transaction.png]]

The transaction information from the statement is presented on the left and the possible reconciliation options are presented on the right.

For each line on your bank statement:

* If OPAS finds an existing OPAS transaction that may match the bank import transaction, it will suggest the match(es)
* You can then either
** Match the line with an existing OPAS transaction - '''Match'''
** Reject the suggested match and create a new OPAS transaction - '''Create'''
* If OPAS cannot find a likely match, you can only create a new OPAS transaction - '''Create'''

This process is explained in more detail below.

== Match An Existing OPAS Transaction ==

If any possible matches are found you will see a list from which you can select the correct transaction:

[[File:Bank-import-match-transaction.png]]

If you spot any inconsistencies on the OPAS transaction, you can edit the matched transaction using the fields available. If the transaction has multiple lines, you can edit each line by clicking the <code>Edit</code> button below the lines:

[[File:Bank-import-match-lines.png]]

If the date in the statement line and the date in the OPAS transaction do not match, once the statement is reconciled, the OPAS transaction will be updated to the date in the statement - '''Please note this will not happen for Cheques or Cash.'''

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-match-saved.png]]

Furthermore, if the same OPAS transaction was found to be a match to more than one line on the statement, this match will be locked out of any other lines:

[[File:Bank-import-locked-match.png]]

'''If no matches are found, before considering creating that transaction on OPAS, please make sure that it doesn't exist already and the mismatch was due to a different reference.'''

== Create a new OPAS Transaction ==

'''Please note that all Gift-Aid standing orders must be set-up as recurring entries in OPAS to ensure they can be correctly allocated to the donor record.'''

You can create a new OPAS transaction using the data from the statement:

[[File:Bank-import-create-transaction.png]]

If you wish to add more lines to this transaction, please use the <code>Click here…</code> link:

[[File:Bank-import-create-lines.png]]

Once you are happy with the match, please click the <code>Save</code> button. This will mark the transaction as being ready to reconcile:

[[File:Bank-import-transaction-create-saved.png]]

== Ignoring aTransaction on the Statement ==

There will be some cases where you will be unable to match or create a transaction. Some examples are:

* A single transaction on the statement matches more than one OPAS transactions
* Multiple transactions on the statement match a single/split OPAS transaction
* A bank transfer on the statement matches an OPAS non-transfer transaction
* A non-transfer transaction on the statement matches an OPAS bank transfer

For such cases you would need to reconcile these particular OPAS transactions/bank transfers using the classic <code>Reconcile The Bank</code> page.

OPAS will indicate that these transactions still need to be reconciled. You can instruct the system to ignore them by clicking the <code>Ignore</code> button. This will mark the transaction as ignored:

[[File:Bank-import-transaction-ignore.png]]

You will need to click <code>Cancel Ignore</code> if you wish to reconcile the transaction at a future date.

'''Ignoring a transaction or canceling is applied immediately - you do not need to reconcile the statement.'''

== Committing the Reconciliation ==

Once you have saved at least one statement line, the Reconcile button will be enabled in the top bar:

[[File:Bank-import-top-bar.png]]

Please check that the Statement Number and Reconcile Up To date are correct.

'''The Reconcile Up To date should be the same date you entered when creating the CSV in your bank website - even if there are no transactions right up to that date. '''

'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

Once you are ready, click the <code>Reconcile</code> button.

You do not need to reconcile the entire statement in a single session. If you only reconcile part of the statement, you can return to this page and resume work by clicking the statement on the previously uploaded list:

[[File:Bank-import-index-previously-uploaded.png]]

File:Bank-import-index-previously-uploaded.png

2025-04-15T11:36:06Z

Joao:

File:Bank-import-top-bar.png

2025-04-15T11:34:53Z

Joao:

File:Bank-import-transaction-ignore.png

2025-04-15T11:33:39Z

Joao:

File:Bank-import-transaction-create-saved.png

2025-04-15T11:32:01Z

Joao:

File:Bank-import-create-lines.png

2025-04-15T11:31:08Z

Joao:

File:Bank-import-create-transaction.png

2025-04-15T11:30:07Z

Joao:

File:Bank-import-locked-match.png

2025-04-15T11:28:46Z

Joao:

File:Bank-import-transaction-match-saved.png

2025-04-15T11:27:34Z

Joao:

File:Bank-import-match-lines.png

2025-04-15T11:26:15Z

Joao: