8.5.2.2 Single Payment Multiple Cash Flows

This topic provides systematic instructions to reconcile multiple cashflow records with a single payment.

If you select this option, then a list of unreconciled and partially-reconciled payments appears. You can select a payment and one or more cash flow records to reconcile. Upon selection, you can save these details, and add another payment-cash flows record to be reconciled in the same transaction.

To manually reconcile cashflow records against a single payment:
  1. From the Dashboard, click the Toggle Menu, then click Receivables/Payables, Manual Reconciliation, and then Cash Flow against Payment.
    The Cash Flow against Payment screen appears.
  2. From the Reconciliation Type field, select the Single Payment Multiple Cash Flows option.
    A list of unreconciled or partially reconciled payment records appears.
  3. In the Select Payment step, select the required payment to reconcile. You can use the Search field and filter options to find the required record.

    Table 8-37 Select Payment - Field Description

    Field Name Description
    Select Payment This step appears if you select the Single Payment Multiple Cash Flows option from the Reconciliation Type field. A list of unreconciled / partially-reconciled payments is displayed. You can select one payment from the list.
    Payments (number) Displays the total number of payments available in the list.
    Search Indicates an option to search for specific payments.
    Filter Click this icon to filter the payments based on certain criteria. The Payment Search overlay window appears. For more information on the fields in this window, refer the Payment Search section in this document.
    Date Reference Number Displays the date of the payment and its reference number as a hyperlink. You can click this link to view the payment details in an overlay window. For more information on the fields displayed, refer the Payment Details overlay window section below.
    Real Account Virtual Account Displays the real and virtual account numbers (in masked format), from which the payment was initiated.
    Remitter Account Number / Beneficiary Account Number Displays the default account number of the remitter / beneficiary, based on whether the payment is incoming or outgoing
    Amount Displays the total payment amount.
    Unreconciled Amount Displays the payment amount that has not yet been reconciled.
    Reconciliation Details section

    Reconciliation Details

    This section, present on the right hand side of the Manual Reconciliation screen, is automatically updated when you select the payment and cash flow records for reconciliation.
    Payment to be reconciled Displays the payment amount to be reconciled, once you select a payment in the 1st step of manual reconciliation.
    Reconciled Amount Displays the total cash flow amount. This field is updated once you select the cash flow records in the 2nd step of manual reconciliation.
    Pending for Reconciliation Displays the difference between the amounts in the fields above.
    View Selected Records Click this link to view the details of the selected payment and cash flow records. An overlay window appears with the details of the selected records.

Payment Details overlay window

This window appears when you click the payment reference number hyperlink.

Table 8-38 Select Payment - Field Description

Field Name Description
Payment Reference Number Displays the payment reference number assigned by the host.
External Reference Number Displays the external payment reference number.
Payment Date Displays the date of the payment.
Type Displays the type of payment, whether incoming or outgoing.
Status Displays the status of the payment.
Remitter Account Number / Beneficiary Account Number Displays the remitter account number in case of an incoming payment, and beneficiary account number in case of an outgoing payment.
Amount Displays the payment amount.
Unreconciled Amount Displays the amount that is not yet reconciled.
Real Account Displays the real account number involved in the payment.
Virtual Account Displays the virtual account number involved in the payment.
Remark Displays remarks, if any.

  1. Click Continue to proceed to the Reconcile with Cash Flows step. Or, do one of the following:
    • Click Cancel to cancel the transaction.
    • Click Back to go to the dashboard.

    Figure 8-76 Reconcile with Cash Flows



    Table 8-39 Reconcile with Cash Flows - Field Description

    Field Name Description
    Reconcile with Cash Flows This step appears when you select a payment and click Continue. You can select multiple cash flow records for reconciliation.
    Cash Flow (number) Displays the total number of cash flow records available in the list.
    Search Indicates an option to search for specific cash flow records.
    Filter Click this icon to filter the cash flow records based on certain criteria. The Cash Flow Search overlay window appears. For more information on the fields in this window, refer the Cash Flow Search section in this document.
    Date Reference Number Displays the date of the cash flow and its reference number as a hyperlink. You can click this link to view the cash flow details in an overlay window. For more information on the fields displayed, refer the Cash Flow Details overlay window section below.
    Associated Party Name Displays the name of the associated or counter party.
    Amount Displays the total cash flow amount.
    Unreconciled Amount Displays the unreconciled cash flow amount.
    Amount to be Reconciled Indicates the cash flow amount to be reconciled. You can click Edit to edit and modify the amount if required, and then click Save to save it.
    Reconciliation Details section

    Reconciliation Details

    This section, present on the right hand side of the Manual Reconciliation screen, is automatically updated when you select the payment and cash flow records for reconciliation.
    Payment to be reconciled Displays the payment amount to be reconciled, once you select a payment in the 1st step of manual reconciliation.
    Reconciled Amount Displays the total cash flow amount. This field is updated once you select the cash flow records in the 2nd step of manual reconciliation.
    Pending for Reconciliation Displays the difference between the amounts in the fields above.
    View Selected Records Click this link to view the details of the selected payment and cash flow records. An overlay window appears with the details of the selected records.
    Selected Record This overlay window appears when you click the View Selected Records link. It displays the details of the selected payment and cash flow records to be reconciled.
    Reconciled Records This section (present on the top right side of the Manual Reconciliation screen) displays the number of records that you have saved for reconciliation by clicking Save and Add Another. You can click the View Details link to view the details of these saved payment-cash flows records, which appear in an overlay window. To remove a saved record, click Delete beside it.
    Cash Flow Details overlay window This window appears when you click the cash flow reference number hyperlink.
    Cash Flow Reference Number Displays the cash flow reference number assigned by the host.
    External Reference Number Displays the external cash flow reference number.
    Payment Date Displays the date of the payment.
    Type Displays the type of cash flow, whether inflow or outflow.
    Status Displays the status of the cash flow.
    Amount Displays the cash flow amount.
    Unreconciled Amount Displays the amount that is not yet reconciled.
    Real Account Displays the real account number involved in the cash flow.
    Virtual Account Displays the virtual account number involved in the cash flow.
    Associated Party ID and Name Displays the name and ID of the counter party involved in the cash flow.
    Linked Reference Number Displays the linked reference number of the cash flow.
    Narration Displays any narration text/comments.
  2. In the Reconcile with Cash Flows step, select the required cash flow records to reconcile.
  3. In the Amount To Be Reconciled field, click Edit to edit the amount and then click Save to save the changes, if required.
  4. Click Save and Add Another to save the details and select another payment to reconcile against cash flow records.
    • To view a list of records that you have already saved, click the View Details link in the Reconciled Records section, on the top right side of the Manual Reconciliation screen. An overlay window appears with the saved payment-cash flows records. To delete a record, click Delete.
  5. Click Submit to submit the transaction. The Review screen appears. Or, do one of the following:
    • Click Cancel to cancel the transaction.
    • Click Back to go to the dashboard.
  6. In the Review screen, verify the selected details and click Confirm. A confirmation message appears, with the status and reference number of the transaction. Or, do one of the following:
    • Click Cancel to cancel the transaction.
    • Click Back to go to the dashboard.
Once the transaction is submitted, the approver is notified. If any modifications are required, the approver can add relevant comments and send the transaction back to the maker, using the Send to Modify feature. Once the required modifications are made, the maker can re-submit the transaction.