1. Receivables and Payables User Guide
  2. Manual Reconciliation
  3. Reconcile

9.2 Reconcile

This topic describes the systematic instruction to select multiple records or single record to reconcile.

  1. On Manual Recon screen, specify the required details and click Search.
    The Reconciliation screen displays with the invoices/debit notes/cashflows and payments/credit notes are populated in the grid. In case, multiple unreconciled invoices/debit notes/cashflows and/or payments/credit notes will be populated.

    Figure 9-4 Reconciliation


    Description of Figure 9-4 follows
    Description of "Figure 9-4 Reconciliation"

  2. In the Reconcile By field, select any of the following:
    • One Invoice/cashflows to Many Payment/Credit Notes – To reconcile single invoice/cashflow from multiple payments/credit notes.
    • One Payment to Many Cashflow – To reconcile multiple cashflow from single payment.
    • Many Invoice to One Payment/Credit Note – To reconcile multiple invoices from single payment/credit note.

For One Invoice/cashflow to Many Payment/Credit Notes:

  1. In the Invoices/Debit Note/Expected CashflowInvoices/Debit Notes section, select the invoice/debit note/cashflow to reconcile.
    The One Invoice/Cashflow to Many Payment/Credit NotesOne Invoice to Many Payment/Credit Notes option selected.

    Figure 9-5 One Invoice to Many Payment/Credit Notes


    Description of Figure 9-5 follows
    Description of "Figure 9-5 One Invoice to Many Payment/Credit Notes"

    Figure 9-6 One Invoice/Cashflow to Many Payment/Credit Notes


    Description of Figure 9-6 follows
    Description of "Figure 9-6 One Invoice/Cashflow to Many Payment/Credit Notes"

  2. In the Payments/Credit Notes section,
    1. Select the payment(s)/credit notes to reconcile.
    2. In the Amt to be Reconciled (Pay/Cr Note Ccy) column, enter the amount to reconcile in payment/credit notes currency.

For One Payment to Many Cashflow:

  1. In the Payments section, select the payment to reconcile by.
    The One Payment to Many Cashflow option selected.

    Figure 9-7 One Payment to Many Cashflow


    Description of Figure 9-7 follows
    Description of "Figure 9-7 One Payment to Many Cashflow"

  2. In the Expected Cashflow section,
    1. Select the cashflow records to reconcile with.
    2. In the Amt to be Reconciled (Exp Ccy) column, enter the amount to be reconciled in cashflow currency.

For Many Invoices to One Payment/Credit Note:

  1. In the Payments/Credit Notes section, select the payment/credit note to reconcile by.
    The Many Invoices to One Payment/Credit Note option selected.

    Figure 9-8 Many Invoices to One Payment/Credit Note


    Description of Figure 9-8 follows
    Description of "Figure 9-8 Many Invoices to One Payment/Credit Note"

  2. In the Invoices section,
    1. Select the invoice(s) to be reconciled.
    2. In the Amt to be Reconciled (Inv Ccy) field, enter the amount to be reconciled in invoice currency.
  3. Optional: In the Rule Details column, click Details hyperlink to view rule details.
  4. Click Proceed to move to the Allocation stage.
    The Allocation screen displays.
  5. Perform the following steps to allocate payment manually:
    1. In the Allocation Required column, enable the toggle to allocate account and percentage.
    2. In the Virtual Account column, select the account to be allocated.
    3. In the Allocated Amount column, specify the amount to be allocated for the respective virtual account.
    4. In the Percentage column, specify the percentage of the amount.
  6. Click Submit to confirm the reconciliation and send the record for authorization.

Note:

A cashflow record is automatically created for every new invoice/debit note record, if the ‘Create Cashflow from Invoice’ system-level configuration flag is set to ‘Yes’. In this case, the ‘Not to be Reconciled Directly’ record-level flag is also defaulted to ‘Y’, so that if the invoice is reconciled with payments or credit notes, then the corresponding cashflow record should not be considered for auto or manual reconciliation. The same is true with reconciliation of debit notes with payments or credit notes.

Parent topic: Manual Reconciliation