Page Comparison

...

On the Bank Reconciliation page, the table will display ALL of the unreconciled Bank Statement Line records where the Reconciliation Status is not Reconciled AND Excluded 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.

...

There are multiMulti-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 and the 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 field displays 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.

...

• and if the amount matches the Bank Statement Line’s amount then you can proceed with reconciling by clicking the reconcile button.

...

• When the Reconcile button is clicked,

  • If one of the selected records from the table is a Gift Transaction record,

    The

    the Gift Transaction record is updated where:

    • The Bank Statement Line

      = equivalent

      is populated with the Bank Statement

      Line record

      Record.

    • The Bank Reconciliation Status

      = Reconciled

      is updated to Reconcile.

    • Settlement Date

      =

      displays the Settlement Date of the Bank Statement

      Line’s Settlement Date

      Line

    • Receiving Bank Account

      = equivalent

      displays the Bank Account linked to the Bank Statement Line

      →

      in the Bank Statement

      → Bank Account

      .

      Image Added

  • If one of the selected records from the table is a Gift Refund record,

    The

    the Gift Refund record is updated where:

    • The Bank Statement Line

      = equivalent

      is populated with the Bank Statement

      Line record

      Record.

    • The Bank Reconciliation Status

      = Reconciled

    • Settlement Date = Bank Statement Line’s Settlement Date

    Refunding Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account

    is updated to Reconcile.

    • Settlement Date displays the Settlement Date of the Bank Statement Line

    • Receiving Bank Account displays the Bank Account linked to the Bank Statement Line in the Bank Statement.
      

      Image Added

  • If one of the selected records from the table is a Bank Deposit Batch record,

    All

    all of the Gift Transaction records linked to the Bank Deposit Batch and also the Bank Deposit Batch record are updated where:

    • The Bank Statement Line

      = equivalent

      is populated with the Bank Statement

      Line record

      Record.

    • The Bank Reconciliation Status

      = ReconciledSettlement Date = Bank Statement Line’s Settlement Date

      is updated to Reconcile.

    • Settlement Date displays the Settlement Date of the Bank Statement Line

    • 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

    displays the Bank Account linked to the Bank Statement Line in the Bank Statement.
    

    Image Added

  • If one of the selected records from the table is a Gateway Settlement record,

    All

    all of the Gateway Transaction records linked to the Gateway Settlement record are updated where:

    • The Bank Statement Line

      = equivalent

      is populated with the Bank Statement

      Line record

      Record.

    • The Bank Reconciliation Status

      = ReconciledSettlement Date = Bank Statement Line’s Settlement Date

      is updated to Reconcile.

    • Settlement Date displays the Settlement Date of the Bank Statement Line

    • Receiving Bank Account

      = equivalent

      displays the Bank Account linked to the Bank Statement Line

      →

      in the Bank Statement

      → Bank Account

      .

      Image Added

    • If the Gateway Transaction record has Gift Transaction, the Gateway Transaction’s Gift Transaction record is updated where:

      • The Bank Statement Line = equivalent is populated with the Bank Statement Line recordRecord.

      • The Bank Reconciliation Status = Reconciled

      • Settlement Date = Bank Statement Line’s Settlement Date

      • Receiving Bank Account = equivalent Bank Statement Line → Bank Statement → Bank Account is updated to Reconcile.

      • Settlement Date displays the Settlement Date of the Bank Statement Line

      • Receiving Bank Account displays the Bank Account linked to the Bank Statement Line in the Bank Statement.

        Image Added

    • 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
        

        Image Added

    • 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
        

        Image Added

  • If one of the selected records from the table is an Order record,

    The

    the Order’s Gift Transaction record and the Order record is updated where:

    • The Bank Statement Line

      = equivalent

      is populated with the Bank Statement

      Line record

      Record.

    • The Bank Reconciliation Status

      = Reconciled

      is updated to Reconcile.

    • 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

Exclude

...

• 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 displays the Settlement Date of the Bank Statement Line

    • Receiving Bank Account displays the Bank Account linked to the Bank Statement Line in the Bank Statement.
      Gift Transaction

      Image Added

      Order

      Image Added

When the reconciliation process of all the Bank Statement Line records are done a PosiPay Log is created displaying the Bank Statement Line record IDs that have been reconciled.

...

If the Bank Statement record has been reconciled a PosiPay Log is created stating that the Banks Statement has been reconciled. The Bank Statement Status is updated to Reconciled, and the Date Reconciled is populated .

...

Take note that the Bank Statement can only be reconciled if all of the Bank Statement Line records linked with it have been successfully reconciled otherwise, the Bank Statement won’t be reconciled.

When there is an error in the reconciliation process, a PosiPay Log record is created

...

Source = Bank Reconciliation

...

Details = error message

...

which it displays an error message in the Details field.