Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Stripe Payout

When reconciling donations with a Stripe Payout as the payment method, ensure that the Amount field value in each Bank Statement Line matches the Payment Amount field value in each Gateway Settlement, and that the Date field value in each Bank Statement Line matches the Reconciliation Date field value in each Gateway Settlement.

...

  • Bank Statement

    image-20240918-053610.pngimage-20240918-053448.png

  • PosiPay Log

    image-20240918-053155.png

...

Bank Deposit Batch

Combined Cash and Check

...

(Cheque) in Bank Statement Line

In reconciling Bank Statement Lines for both Cash and Check payment methods, ensure that each Bank Statement Line’s Amount value matches each Bank Deposit Batch’s Total Transaction Amount value.

...

The Bank Statement Line records linked to the Bank Statement record have a Reconciliation Status as Reconciled OR Excluded and a PosiPay Log is also created.

...

Cash

...

Lump Sum in Bank Statement Line

Please remember the following: “Multiple Bank Deposit Batch records are created with only Gift Transaction records where the Payment Method is Cash. Create a Bank Statement and generate Bank Statement Line records under the Bank Statement. Ensure that the Amount field value of each Bank Statement Line matches the Total Transaction Amount field value of each Bank Deposit Batch.”

...

After the reconciliation process of Bank Statement Line records, a PosiPay Log is created.

...

Check (Cheque) Lumped together in Bank Statement Line

To proceed in Bank Reconciliation make sure that multiple Bank Deposit Batch has been created where the Payment Method is 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 Transaction Amount field value.

...

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.

Cash

...

Lump Sum in Mixed Transaction

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.

...

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

...

Check

...

(Cheque) Lump Sum in Mixed Transaction

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 the Bank Deposit Batch’s Total Check Amount field value.

...

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

...

Individual

...

Check (Cheque) Bank Statement Line

To proceed in Bank Reconciliation make sure that multiple Gift Transaction records that have been created have Check as the Payment Method and the Payment Identifier check number, and should be linked to Bank Deposit Batch.

...

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.

...

Direct Deposit

To proceed with Bank Reconciliation, make sure that each Bank Statement Line’s Transaction Reference field value matches each Gift Transaction’s Payment Identifier field value

...