This functionality enables manual reconciliation of the bank statement line by simply clicking the Manual Reconciliation button in the Bank Statement record. You can only reconcile the bank statement if its status is Unreconciled.
When the Manual Reconciliation button the Bank Statement status is updated to Processing and the Bank Reconciliation page for manual bank reconciliation will display.
On the Bank Reconciliation page, the table will display ALL of the unreconciled Bank Statement Line records under the Bank Statement record.
The “Exclude” button allows you to remove the Bank Statement Line records from the table. This button will only become clickable if one or more Bank Statement Line records are selected. When you click the "Exclude" button after selecting Bank Statement Line records, the status of the Bank Statement Line Reconciliation will be updated to “Excluded” and those records will be removed from the table.
Multi-action buttons are displayed in each row.
When Find and Match is clicked the page for the matching period will display below the row. A table will be displayed where it displays the following sorted records where the Bank Reconciliation Status is not Reconciled AND Bank Statement Line is empty
Below the table, the following details will be displayed.
A Total field will display where it is populated based on the total amount of the selected records from the table
If the total amount of Total is equal to Bank Statement Line’s Amount, the Reconcile button is enabled for clicking otherwise if not equal the Reconcile button is disabled for clicking.
When the Reconcile button is clicked,
If one of the selected records from the table is a Gift Transaction record,
The Gift Transaction record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If one of the selected records from the table is a Gift Refund record,
The Gift Refund record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Refunding Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If one of the selected records from the table is a Bank Deposit Batch record,
All of the Gift Transaction records linked to the Bank Deposit Batch record are updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
The Bank Deposit Batch record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If one of the selected records from the table is a Gateway Settlement record,
All of the Gateway Transaction records linked to the Gateway Settlement record are updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If the Gateway Transaction record has Gift Transaction, the Gateway Transaction’s Gift Transaction record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If the Gateway Transaction record has Gift Refund, the Gateway Transaction’s Gift Refund record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Refunding Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
The Gateway Settlement record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
If one of the selected records from the table is an Order record,
The Order’s Gift Transaction record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
The Order record is updated where:
Bank Statement Line = equivalent Bank Statement Line record
Bank Reconciliation Status = Reconciled
Settlement Date = Bank Statement Line’s Settlement Date
Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account
The equivalent Bank Statement Line record of the row is updated where:
Reconciliation Status = Reconciled
The Bank Statement Line record that has been updated is expected to be removed in the table
The “Exclude” button allows you to remove the Bank Statement Line records from the table. This button will only become clickable if one or more Bank Statement Line records are selected.
When you click the "Exclude" button after selecting Bank Statement Line records, the status of the Bank Statement Line Reconciliation will be updated to “Excluded” and those records will be removed from the table.
Once the OK button is clicked,
A PosiPay Log record is created where:
Source = Bank Reconciliation
Details = Here is the list of Bank Statement Line records under the Bank Statement + (<Bank Statement record ID>) + record that have been reconciled: + <Bank Statement Line record IDs where Reconciliation Status = Reconciled OR Excluded> + .
Type = Information
If all of the Bank Statement Line records linked to the Bank Statement record have a Reconciliation Status = Reconciled OR Excluded,
The Bank Statement record is updated where:
Status = Reconciled
Date Reconciled = date today
A PosiPay Log record is created where:
Source = Bank Reconciliation
Details = The Bank Statement + (<Bank Statement record ID>) + record has been reconciled.
Type = Information
If one or more Bank Statement Line records linked to the Bank Statement record has a Reconciliation Status != Reconciled OR Excluded,
The Bank Statement record will NOT be reconciled
After the process,
If the Bank Statement record has been reconciled,
A notification message will display: The Bank Reconciliation process has been completed successfully and there are no outstanding items on this Bank Statement.
When the OK button is clicked again, the Bank Reconciliation page will close and the current Bank Statement record will be refreshed
If the Bank Statement record has NOT been reconciled,
A notification message will display: There are still unreconciled items on this Bank Statement. Would you like to leave?
When the Yes button is clicked, the Bank Reconciliation page will close and the current Bank Statement record will be refreshed
When the No button is clicked, the Bank Reconciliation page will NOT close
When there is an error in the reconciliation process, a PosiPay Log record is created where:
Source = Bank Reconciliation
Details = error message
Type = Error