Page Comparison

This functionality enables automatic reconciliation of the bank statement line by simply clicking the “Automatic Reconciliation” button in the Bank Statement record. You This functionality enables automatic reconciliation of the bank statement line by simply clicking the “Automatic Reconciliation” button in the Bank Statement record. You can only reconcile the bank statement if its status is Unreconciled.

...

• Gateway Settlement’s Reconciliation Date (date) = Bank Statement Line’s Settlement Date

• Gateway Settlement’s Payout Amount = Bank Statement Line’s Amount

>>>>> Insert SS

Once a matched Gateway Settlement record is found,

The Gateway Settlement 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

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.

>>>>> Insert SS

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

  = 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

  .

>>>>> Insert SS

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 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 displays the Bank Account

  = equivalent

  linked to the Bank Statement Line

  →

  in the Bank Statement

  → Bank Account

  .

>>>>> Insert SS

If the Gateway Transaction record has Gift Refund, the Gateway Transaction’s 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.

>>>>> Insert SS

• The Bank Statement Line record is updated where:

  • Reconciliation Status = Reconciled

>>>>> Insert SS

Once the reconciliation process is done a PosiPay log is created where,

• Source = Bank Reconciliation

• Details = Here is the list

>>>>> Insert SS

After the reconciliation process of Bank Statement Line records

...

, a PosiPay Log is created with the following details:

>>>>> Insert SS

If all of the Bank Statement Line records linked to the Bank Statement record has a Reconciliation Status = of Reconciled OR Excluded,

...

the Bank Statement

...

is updated

...

and a PosiPay Log is created.

• Bank Statement

  • Status is updated to 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 populated to current date.
    >>>>> Insert SS

• PosiPay Log

  • >>>>> Insert SS

• If one or more Bank Statement Line records linked to the Bank Statement record have a Reconciliation Status that is not set to Reconciled or Excluded, the Bank Statement record will not be reconciled.

>>>>> Insert SS

Donation with Cash and Check Payment Method Combination

...

To proceed in Bank Reconciliation make sure that multiple Bank Deposit Batch has been created where the Payment Method is Cash and Check. Create a Bank Statement and create Bank Statement Lines records under this record you’ve just created. Ensure that each Bank Statement Line’s Amount field value matches each Bank Deposit Batch’s Total Cash Amount field value.

>> INSERT SS 1:10

Once a matched Bank Deposit Batch record is found, all of the Gift Transaction with Cash as Payment Method linked to it are updated.

• The Bank Statement Line value is equivalent to the Bank Statement record.

• The Bank Reconciliation Status is updated to Reconciled.

• The Settlement Date displays the same date as the Bank Statement Line’s Settlement Date.

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

• >> INSERT SS 1:10

If all of the Gift Transaction records linked to the Bank Deposit Batch record have a Bank Reconciliation Status of Reconciled, the Bank Deposit Batch record is updated.

• The Bank Statement Line value is equivalent to the Bank Statement record.

• The Bank Reconciliation Status is updated to Reconciled.

• The Settlement Date displays the same date as the Bank Statement Line’s Settlement Date.

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

>> INSERT SS

If the Bank Deposit Batch’s Bank Reconciliation Status is Reconciled, then the Bank Statement Line Reconciliation Status is updated to Reconciled.

>> INSERT SS

After the reconciliation process of Bank Statement Line records, a PosiPay Log is created with the following details:

>> INSERT SS

If all of the Bank Statement Line records linked to the Bank Statement record has a Reconciliation Status is Reconciled or Excluded, the Bank Statement is updated and a PosiPay Log is created.

>> INSERT SS “Bank Statement“

>> INSERT SS “ PosiPay Log“

If one of the Bank Statement Line Reconciliation Status is not Reconciled or Excluded, the Bank Statement will not be reconciled and a PosiPay Log is created.

...

To proceed in Bank Reconciliation make sure that multiple Bank Deposit Batch has been created where the Payment Method is Cash and Check. Create a Bank Statement and create Bank Statement Lines records under this record you’ve just created. Make sure that each Bank Statement Line’s Amount field value matches each Bank Deposit Batch’s Total Check Amount field value.

>> INSERT SS

When reconciling the Bank Statement Line, its record is reconciled and each record matched the Bank Deposit Batch record where:

...

• The Bank Statement Line value is equivalent to the Bank Statement record.

• The Bank Reconciliation Status is updated to Reconciled.

• The Settlement Date displays the same date as the Bank Statement Line’s Settlement Date.

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

>> INSERT SS

If the Bank Deposit Batch’s Bank Reconciliation Status is Reconciled, then the Bank Statement Line Reconciliation Status is updated to Reconciled.

>> INSERT SS

After the reconciliation process of Bank Statement Line records, a PosiPay Log is created with the following details:

>> INSERT SS

If all of the Bank Statement Line records linked to the Bank Statement record has a Reconciliation Status is Reconciled or Excluded, the Bank Statement is updated and a PosiPay Log is created.

>> INSERT SS “Bank Statement“

>> INSERT SS “ PosiPay Log“

If one of the Bank Statement Line Reconciliation Status is not Reconciled or Excluded, the Bank Statement will not be reconciled and a PosiPay Log is created.

...

If the Bank Deposit Batch’s Bank Reconciliation Status is Reconciled, then the Bank Statement Line Reconciliation Status is updated to Reconciled.

>> INSERT SS

After the reconciliation process of Bank Statement Line records, a PosiPay Log is created with the following details:

>> INSERT SS

If all of the Bank Statement Line records linked to the Bank Statement record has a Reconciliation Status is Reconciled or Excluded, the Bank Statement is updated and a PosiPay Log is created.

>> INSERT SS “Bank Statement“

>> INSERT SS “ PosiPay Log“

If one of the Bank Statement Line Reconciliation Status is not Reconciled or Excluded, the Bank Statement will not be reconciled and a PosiPay Log is created.