...
There are multi-action buttons displayed in each row.
Find and Match
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:
Gift Transaction records where the Original Amount = Bank Statement Line’s Amount
Gift Transaction records regardless of the amount
Gift Refund records regardless of the amount
Bank Deposit Batch records regardless of the amount
Gateway Settlement records regardless of the amount
Order records regardless of the amount
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.
...