Manual Bank Reconciliation - PosiGive

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.

Open

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.

Open

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 the Bank Statement Line is empty.

• The Total field displays the total amount of the selected records 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 Gift Transaction record is updated where:

    • The Bank Statement Line is populated with the Bank Statement Record.

    • The Bank Reconciliation Status 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.

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

    • The Bank Statement Line is populated with the Bank Statement Record.

    • The Bank Reconciliation Status 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.
      
      

  • 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 and also the Bank Deposit Batch record are updated where:

    • The Bank Statement Line is populated with the Bank Statement Record.

    • The Bank Reconciliation Status 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.
      
      

  • 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:

    • The Bank Statement Line is populated with the Bank Statement Record.

    • The Bank Reconciliation Status 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.

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

      • The Bank Statement Line is populated with the Bank Statement Record.

      • The Bank Reconciliation Status 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.

    • 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 and the Order record is updated where:

    • The Bank Statement Line is populated with the Bank Statement Record.

    • The Bank Reconciliation Status 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.
      Gift Transaction

      Order

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 which it displays an error message in the Details field.