OPAS:Accounting/Importing Bank Statements - Revision history

Joao at 10:42, 14 July 2025

2025-07-14T10:42:25Z

← Older revision		Revision as of 10:42, 14 July 2025
Line 137:		Line 137:

	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.		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]]

Joao at 10:28, 3 June 2025

2025-06-03T10:28:11Z

← Older revision		Revision as of 10:28, 3 June 2025
Line 128:		Line 128:

	[[File:Bank-import-index-previously-uploaded.png]]		[[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.

Tim: Removed line about reconciling up to the last transaction date on partial reconciliations.

2025-05-09T14:01:41Z

Removed line about reconciling up to the last transaction date on partial reconciliations.

← Older revision		Revision as of 14:01, 9 May 2025
Line 120:		Line 120:

	'''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 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.'''		'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

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

2025-05-07T09:26:46Z

Added disclaimer on how all bank accounts must be unique

← Older revision		Revision as of 09:26, 7 May 2025
Line 17:		Line 17:

	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 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]]		[[File:Bank-account-dropdown.png]] [[File:Bank-account-edit-fields.png]]

Tim: Added advice about partial reconciliations and the Reconcile Up To date

2025-04-29T09:25:41Z

Added advice about partial reconciliations and the Reconcile Up To date

← Older revision		Revision as of 09:25, 29 April 2025
Line 118:		Line 118:

	'''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 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.'''		'''Please check with your Diocesan Support Team for what periods you should regularly reconcile your statements - commonly to the end of each calendar month.'''

Tim: Updated supported banks list

2025-04-25T14:12:53Z

Updated supported banks list

← Older revision		Revision as of 14:12, 25 April 2025
Line 4:		Line 4:

	* NatWest		* NatWest
	* Royal Bank of Scotland		* Royal Bank of Scotland (RBS)
	* Lloyds (business banking accounts only)		* 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.		The Bank Import feature only supports CSV files. Please make sure you select the correct export options in your banking website.

Tim: corrected typo

2025-04-15T11:38:54Z

corrected typo

← Older revision		Revision as of 11:38, 15 April 2025
Line 89:		Line 89:
	[[File:Bank-import-transaction-create-saved.png]]		[[File:Bank-import-transaction-create-saved.png]]

	== Ignoring ~~aTransaction~~ on the Statement ==		== 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:		There will be some cases where you will be unable to match or create a transaction. Some examples are:

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)..."

2025-04-15T11:36:22Z

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)..."

New page

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]]