Reconcile Provider Statement against Bank Transaction
This article will show you how to reconcile a Provider Statement to a Bank Transaction.
There are 2 different options, both are explained below.
Click Income Reconciliation under Business
Click Bank Statements
Alternatively, you can also go in via the relevant month:
Then select Bank Statements on the side menu:
Locate the Bank Statement you want to reconcile a Provider Statement against and click the 'View Bank Statement' eye icon
On the next screen, you can select multiple Bank Statement transactions to reconcile to a Provider Statement
Tick the relevant Bank Statement transactions
Click reconcile to statement transactions
You'll then be asked to select if you would like to reconcile to a provider statement or individual transactions:
If you want to reconcile to a full statement, then select Provider Statements. If you want to reconcile to individual provider statement transactions, select Individual Transactions.
You can reconcile to multiple Individual Transactions, but only to 1 Provider Statement
In both screens, you have the option to search by Client Name and Policy Number. You also have More Filters available:
Select Provider Statements or Individual Transactions (Provider Statements for this example)
Tick the relevant Provider Statement
Click Reconcile
You'll then receive a notification stating the system has attempted to reconcile the selected provider statement to the selected bank transactions:
If you refresh the screen, if reconciled successfully, it'll show a green tick indicating the Bank Statement is fully reconciled to the Provider Statements/Transactions.
Click Income Reconciliation under Business
Click Bank Statements
Alternatively, you can also go in via the relevant month:
Then select Bank Statements on the side menu:
Locate the Bank Statement you want to reconcile a Provider Statement against and click the 'View Bank Statement' eye icon
Once you're within the relevant Bank Statement, click the 'View bank transaction' eye icon, for the transaction you'd like to reconcile a Provider Statement against
On the next screen, click 'add provider statement reconciliation'
You'll then be asked to select if you would like to reconcile to a provider statement or individual transactions:
If you want to reconcile to a full statement, then select Provider Statements. If you want to reconcile to individual provider statement transactions, select Individual Transactions.
You can reconcile to multiple Individual Transactions, but only to 1 Provider Statement
In both screens, you have the option to search by Client Name and Policy Number. You also have More Filters available:
Select Provider Statements or Individual Transactions (Individual Transactions for this example)
Tick the relevant Provider Statement Transaction
Click Reconcile
A pop up box will then appear in the top right hand corner, advising you that the system has attempted to reconcile the selected provider statement transactions to the selected bank transactions.
When you refresh the page, if it has reconciled successfully, you will see the relevant Provider Statement Reconciliation showing under the Bank Statement Transaction.
Should you need to remove the Provider Statement Reconciliation, you can do this within this screen too.
If you then go back to the Bank Statement Screen, if you've reconciled 100% of the Bank Statement, it'll show a green tick indicating the Bank Statement is fully reconciled to the Provider Statements/Transactions.
There are 2 different options, both are explained below.
Option 1
Click Income Reconciliation under Business
Click Bank Statements
Alternatively, you can also go in via the relevant month:
Then select Bank Statements on the side menu:
Locate the Bank Statement you want to reconcile a Provider Statement against and click the 'View Bank Statement' eye icon
On the next screen, you can select multiple Bank Statement transactions to reconcile to a Provider Statement
Tick the relevant Bank Statement transactions
Click reconcile to statement transactions
You'll then be asked to select if you would like to reconcile to a provider statement or individual transactions:
If you want to reconcile to a full statement, then select Provider Statements. If you want to reconcile to individual provider statement transactions, select Individual Transactions.
You can reconcile to multiple Individual Transactions, but only to 1 Provider Statement
In both screens, you have the option to search by Client Name and Policy Number. You also have More Filters available:
Select Provider Statements or Individual Transactions (Provider Statements for this example)
Tick the relevant Provider Statement
Click Reconcile
You'll then receive a notification stating the system has attempted to reconcile the selected provider statement to the selected bank transactions:
If you refresh the screen, if reconciled successfully, it'll show a green tick indicating the Bank Statement is fully reconciled to the Provider Statements/Transactions.
Option 2
Click Income Reconciliation under Business
Click Bank Statements
Alternatively, you can also go in via the relevant month:
Then select Bank Statements on the side menu:
Locate the Bank Statement you want to reconcile a Provider Statement against and click the 'View Bank Statement' eye icon
Once you're within the relevant Bank Statement, click the 'View bank transaction' eye icon, for the transaction you'd like to reconcile a Provider Statement against
On the next screen, click 'add provider statement reconciliation'
You'll then be asked to select if you would like to reconcile to a provider statement or individual transactions:
If you want to reconcile to a full statement, then select Provider Statements. If you want to reconcile to individual provider statement transactions, select Individual Transactions.You can reconcile to multiple Individual Transactions, but only to 1 Provider Statement
In both screens, you have the option to search by Client Name and Policy Number. You also have More Filters available:
Select Provider Statements or Individual Transactions (Individual Transactions for this example)
Tick the relevant Provider Statement Transaction
Click Reconcile
A pop up box will then appear in the top right hand corner, advising you that the system has attempted to reconcile the selected provider statement transactions to the selected bank transactions.
When you refresh the page, if it has reconciled successfully, you will see the relevant Provider Statement Reconciliation showing under the Bank Statement Transaction.
Should you need to remove the Provider Statement Reconciliation, you can do this within this screen too.
If you then go back to the Bank Statement Screen, if you've reconciled 100% of the Bank Statement, it'll show a green tick indicating the Bank Statement is fully reconciled to the Provider Statements/Transactions.
Updated on: 24/12/2024
Thank you!