Reconcile Payments for Customer Invoices through Direct Debiting and Factoring

This document explains how you reconcile customer payments executed through direct debiting and factoring based on a printed report from the bank or the factoring company.

Outcome

See Reconciling Customer Payments through Direct Debiting and Factoring.

Before you start

See Reconciling Customer Payments through Direct Debiting and Factoring.

Follow These Steps

Initiate Reconciliation

  1. Start ‘Bank Remittance. Reconcile Payment’ (ARS350/B).

  2. Select one of the following alternatives:

    • If all invoices in the remittance are paid, go directly to step 9
    • If not all invoices are paid, go to step 3.

    Report Unpaid Invoices

  3. In (ARS350/B), select option 11=’Remitted payments’ for the remittance.

    You can also report an unpaid invoice by selecting option 20=’Reverse payment’ for the payment transaction in one of the following programs: ‘Voucher. Display’ (GLS200/B), ‘General Ledger. Display Transactions’ (GLS210/B), ‘GL. Display Statement of Account’ (GLS220/B), ‘AR. Display Statement of Account’ (GLS222/B) and ‘Customer Invoice. Display Separate’ (ARS215/B). This option displays (ARS351/B); see next step.

  4. In ‘Bank Remittance. Update Payment’ (ARS351/B), select one of the following alternatives:

    • If the invoices were sent for factoring, use the Delete option to remove each one. Then go to step 6.
    • If the invoices were sent for direct debiting, select whether to list either all invoices (sorting order 1) or invoice totals per payer and payment date (sorting order 2). Then go to next step.
  5. Select one of the following alternatives:

    • To delete a single invoice, select sorting order 1 and then select option Delete for the invoice.
    • To delete all invoices for the payer with the same payment date in the remittance, select sorting order 1, click on an invoice for that payer and payment date, and then select option 14=’Delete all’. Or, select sorting order 2, click on a record and select option Delete.
  6. In (ARS351/D), confirm the deletion by pressing Enter.

  7. In (ARS351/E), change the proposed accounting date, if necessary, and enter a voucher text. Press Enter.

  8. In ‘Standard Letter. Print’ (ARS115/E), select a standard letter of type 1 and press Enter to retrieve any predefined text for the standard letter.

  9. If necessary, enter up to two lines of additional text to the text retrieved from the standard letter. Press Enter to return to (ARS351/B) and then F3 to return to (ARS350/B).

    Reconcile Payments

  10. In (ARS350/B), select option 9=Reconcile for the remittance.

  11. On the E panel, change the proposed accounting date in the ‘Remittance date’ field, if necessary, and enter a voucher text (optional).

    Depending on how the FAM function is defined, an accounting string for account supplementation is also opened on the panel.

  12. Select one of the following alternatives:

    • If there are no bank fees connected to the payment, press Enter to create the voucher.
    • If there are bank fees to be paid, go to step 12.
  13. Select the ‘Bank fee’ check box on the same panel. Press Enter.

  14. On the F panel, enter the fees and, if when applicable, their respective VAT code or a VAT amount. Press Enter to update the ‘Total charges’ and ‘Total bank reconciliation’ fields at the bottom of the panel.

  15. Press F3 to create the voucher and return to (ARS350/B).

Related topics