Using payment schedules

Payment schedules are used to perform bulk payment collections using direct debit, credit card, etc. This article explains how to create and run a payment schedule. For information on how payment schedules work, please see Introduction to payment schedules.

Payment schedules are also used to automatically collect payments. For further information on auto-collection, see Auto-collect payments.

Creating payment schedules

Before you create a new payment schedule, make sure you have gathered all the necessary details that define the scope and timing of the payment collection. These typically include:

  • Source
  • Payment method
  • Payment processor
  • Target
  • Run date
  • Selection date

To create a payment schedule:

  1. Launch the FinDock app.
  2. Click the Payment Schedule tab and click New.
    New payment schedule
  3. Fill out the schedule details as needed. For further information about each field, check the tooltips in the payment schedule or refer to the Payment Schedule object description.
  4. When you have entered all the details, click Save to store the payment schedule or Save & New to save the schedule and open a new one.

   The Additional SOQL should be used with caution and needs proper testing. If you are using Recurring Payment records, the SOQL may in certain cases return installments that should be excluded. If this happens, manually remove them from the schedule.

Running payment schedules

Payment schedules with Scheduled status are started automatically by the FinDock Heart Beat or the Apex class PaymentSchedulesSchedule. Alternatively, you can start a schedule right away by clicking the Start Generation button (on detail page and payment schedule path) after you create the schedule.

When the prepare phase is done, the payment schedule status is set to Generated. The next step is the charge file creation for the bank or API calls to the PSP. Before this step, we recommend using the Data Quality component to validate your payment collection data.

Once you have a valid schedule with valid installments, you can continue with next schedule phase. This is initiated by changing the status of the payment schedule from Generated to Process. This status change can be done manually, or automatically by using workflow, process builder, approval processes or any of the other automation tools available in Salesforce.

If the processing phase result is a file, it will be placed in the file exchange Chatter group by ProcessingHub. When the file is read, the status of the payment schedule changes to Pending Verification.

At this point you can fetch the file from Chatter and upload it to the bank. If the file is accepted, you can change the status of the payment schedule to Verified. This will initiate the final phase of the payment schedule which is closing the installment.

If the payment schedule is for a PSP, there are no manual actions needed during the process and close phases. The main thing in this scenario is to track progress.

Tracking payment collection progress

FinDock provides some basic means (outlined below) to track payment collection progress that can easily be enhanced using Salesforce capabilities to build reports, dashboards, notifications and so forth.

Schedule path component

The Payment Schedule Path component along the top of the payment schedule page is your quickest source of status information. The path shows:

  • The progress of the schedule through each phase. Green indicates the phase was completed successfully, and red indicates an error.
  • Below each phase is a tile with information about the phase events. Check show details at the top of the schedule to view extended details for each phase.

Tracking Payment Schedule with path

Under the details tab on the payment schedule, the Status field reflects the status of the path. If the status changes to Failed, the Last Status Reason field includes an additional error message.

Schedule stats component

The default payment schedule page layout includes the custom FinDock component Payment Schedule Stats for tracking and reporting key statistics. Payment Schedule Stats component

Click Calculate to get the latest details about the schedule. Use the Show details checkbox to see the full calculation process. Calculating Payment Schedule stats

Once calculated you have two tabs on the component. One shows counters for number of installments and for total amount of installments. Calculating Payment Schedule counters

The other shows a summary of failure reasons. Payment Schedule stats failures summary

In addition to the visuals on the component, each statistic includes a configurable Report button. You can change which report the button opens by changes the component settings. Payment Schedule stats failures summary

Tracking installment collection

For collection progress of a specific installment, you can check the details on the installment record. The main fields to follow are:

  • Status
  • Last Failure Reason
  • Last Status Reason

Tracking Payment Schedule installments

Was this page helpful?