Finance Processing

Created by Migration Bot, Modified on Fri, 23 Oct at 2:29 PM by Migration Bot

Originally written by John Hardwick, last updated Oct 24, 2023, on the Swan Retail knowledge base (FRS).


Based on SwanFRS release version 1207

Overview

Click to see the PDF download of this document.

FRS-Finance Processing-150823-160125.pdf

SwanFRS offers the ability to process ‘off-line’ finance applications. This document details how to configure and process a finance application.

The system accommodates multiple finance claims against a single sales order, with an option to limit the ability to fulfil multiple sales orders from a single finance application.

The system allows part payment of finance applications along with the ability to reclaim (refund) finance payments.

The process consists of –

  • Finance application

  • Allocation of application to a sales order

  • Payment claim

  • Payment notification

  • Finance reclaim (repayment back to finance house)

Finance applications in SwanFRS track applications - There is currently no online application process.

Configuration

Application Parameters

Menu Location: System > Administration > Set Up Application Parameters

The following application parameters are required for this process to operate.

Parameter

Description

ALLOW_DEALLOCATE_RECEIVED_FINANCE

Should SwanFRS allow finance payments logged against one order to be reallocated to another order from the same customer.

ALLOW_UNALLOCATED_FINANCE

Is it possible to allow a single finance agreement to be linked to more than one sales order.

BALANCE_INC_FINANCE

Should SwanFRS show include unreceived finance in the customer balance due.

DELIVERY_FINANCE_LEVEL

Specify how financed sales orders are to be restricted when processing the delivery. Do orders required to be finance approved.

Choose from

  • Finance Approved

  • Finance Not Approved

FINANCE_PROCESS_TYPE

This is a system controlled setting defined by the implementation team and defines how finance applications can be applied to sales orders. 

SCHEDULE_WITHOUT_FINANCE_APPR

Specify whether a sales order with an unapproved finance payment can be scheduled for delivery.

Choose from

  • Allow

  • Warn

  • Disallow

USE_CAN_APPROVE_FINANCE_PRIVILEGE

Should SwanFRS control finance approval protocols on. When operational, only users with the appropriate privilege can approve finance applications.

USE_FINANCE_RECEIVED

Should SwanFRS calculate the value of finance expected using the subsidy rates set against the tender type.

Tender Groups

Menu Location: System > System Settings > Sales > Set Tender Groups

To process finance transactions, it is necessary to set the appropriate tender processing controls.

It is recommended that a finance group be set per ‘finance house’

It is recommended that a finance reclaim/refund tender group be built for each finance house set.  This allows for detailed tracing of finance reclaims. It is not essential, however, it will allow transactions to be more closely controlled and monitored.

To enable this tender group to be used as part of finance processing, the finance tick box must be set.

Tender Types

Menu Location: System > System Settings > Sales > Set Tender Types

Once you have the tender groups, it is necessary to define the ‘finance products’

It is recommended that a refund tender is created for each payment type.   It is not possible to refund monies unless the Refund option it ticked.  To be able to refund a finance payment, it is necessary to have a refund finance payment tender type.

Tender Types Bank Codes

Menu Location: System > System Settings > Sales > Set Tender Type Bank Codes

Tender Types are controlled by location, only tender types with a ‘nominal code’ (usually a bank account) will be allowed in the specific location.

Only applications configured to the trading location will be accepted.

The feedback request is also excluded for orders / services for the following codes. Please check your system to ensure these codes are not used.

Role Access

Menu Location: System > System Settings > Security > Set Roles

The following privileges control the operator’s access to specific features within the application.

Parameter

Description

CAN_APPROVE_FINANCE

Allows the user to alter the ‘approved finance’ tick box – this privilege is used in partnership with USE_CAN_APPROVE_FINANCE application parameter.

CAN_REFUND_FINANCE

Allows the operator to process a finance refund.

EDIT_FINANCE

Allows the operator to edit the details of a finance application.

RECONCILE_FINANCE

Allows the reconciliation of finance transactions for all visible locations.

RECONCILE_FINANCE_LOCAL

Allow the reconciliation of finance payments for the operator’s trading branch only.

SCHEDULE_WITHOUT_FINANCE_APPR

Allows the scheduling of deliveries without the approval of a finance claim linked to the sales order.

Operator Profiles

Menu Location: System > System Settings > Security > Set Users

The operator must be linked to one or more role containing the relevant access privilege to be able to process the related task within SwanFRS.

Operation

The process of creating a sales order is not affected by how the customer intends to finance the sale.

When a customer wishes to take out finance (sometimes referred to as a loan) the sales order should be generated as per normal. I.e. create the order and then add the customer and products in your preferred order.

In the example above the customer has paid a deposit with a view to funding the remainder of the order with a financed loan.

To add finance to the order, click the Arrange Finance from the side panel

The screen will then display a listing of all the currently available finance applications for the specified customer.

The page includes the current order balance to pay (shown in red).  The screen may also show a listing of all the applications previously made by this customer.

Having navigated to the arrange finance for sales order page, if the customer has a finance history the screen will show all previously process transactions.

In this example, the customer has applications in the system, which have already been allocated to a sales order. 

There are four options available at this stage (dependent upon your system settings).

  • Instruct the system that a new application is being made (click either New Application on the side panel or the NEW APPLICATION button).

  • Amend the composition of an existing finance agreement via the icon. 

  • Allocate funds from an existing finance agreement to this sales order. (Shown in the last table column when available).

  • Edit the allocation of funds to the sales order. (shown in the last table column when available).

New Applications

A new application requires entry of application details.

To complete the finance application, it is necessary to enter the application date and terms as well as the value of funds to be borrowed.

Once the Finance Amount has been specified it is then possible to allocate all or part of these funds to the sales order.  

In this mode, the Finance Amount may exceed the value of the outstanding balance on the sales order.

Once specified it is then necessary to tell the system the value of funds to be allocated to this sales order.

The routine will not allow the finance to apply to order value to exceed the finance amount or the current order balance.

Where repayment is fixed over a period of months (via tender types) the system will show the calculated monthly payment, which can be viewed by clicking the CALC PAYMENT button which will display to the right of the Finance Amount value.

If the finance application has not been approved by the finance house leave the approved, approval number and date blank and click the ACCEPT button. These fields may be completed later once the finance house has approved the application.

When the USE_CAN_APPROVE_FINANCE application parameter is set only users with the CAN_APPROVE_FINANCE privilege will be allowed to alter the status of the approved tick box and set approval data.

Clicking the ACCEPT button redisplays the finance status page.

The following screens indicate unapproved finance.

Note the finance values are shown in red text to indicate there is a risk that the application may not be approved.

To approve after the initial application, click the to edit the application from the Application History page.

Subject to permission, click the Approved checkbox and fill in the approval data.

Optionally enter notes against the application.

Once approved the screens will change to reflect the application status.

Note the finance values are shown in green text to indicate the application has been approved.

Editing the Application

Once the application has been entered if changes are required to the reference, terms, if the application has been approved or total funds borrowed change,it will be necessary to edit the application.

To alter the composition of the finance agreement, click the icon, this will produce a screen like that shown below –

The system limits the changes available to the finance amount field. 

  • It is not possible to reduce the finance amount below the sum of funds already received from the finance house.

  • It is not possible to reduce the finance amount below the value already allocated to the sales order.

  • It is not possible to increase the application above the current order balance when operating with unallocated fund switched off.

Allocating Finance Applications

If a finance agreement with unallocated funds is available, which is currently not linked to the selected sales order, it will show the Allocate hyperlink.  

To associate the finance application to the sales order, click the allocate link which will produce a screen like that shown below –

This screen allows some or all the unallocated funds to be used to fulfil all or part of the current order balance.

Funds allocated cannot exceed the available to allocate to this sales order or the current order balance values.

To confirm the allocation of funds to the sales order click the ACCEPT button.

Editing the Allocation

Where an application has been associated with a sales order with an incorrect allocation value or if the application has been rejected and the funds need to be removed from the sale to facilitate the closure of the application the Edit hyperlink should be used.

Editing the application allocation presents the following

To alter the value of allocated funds, revise the amount to allocate field. The routine will not accept a zero in the amount to allocate field.

To remove the application from the sales order / unlink it, click the VOID button.  This removes the funds from the sales order.  It does not void the application – it simply de-allocates funds from the sales order thus leaving them available to be allocated to another sales order. 

If the application itself is to be voided click the   icon after releasing the funds from the sale and void the entire application.

When operating in single application mode the void button also voids the application.  As shown in the example below –

When operating with unallocated funds the application is left available for future allocation

Voiding the Application

To void an application, it must be free from allocations to sales order and have no financial payments recorded against it.

  • If the application is linked to a sales order, follow the steps in Editing the Application to remove sales order associations. 

  • The finance application does not have funds allocated to sales orders the icon will produce a void button one clicked.

 The edit page now shows the VOID button.

 Clicking the void button cancels the application thus stopping further allocations to it.

History

The history option is common to both forms of operation.

There are two places within SwanFRS to view the finance history of a customer.

  • Click the arrange finance from the side panel when viewing the sales order detail and then click the HISTORY button.

  • Use the find customer to identify the customer and use the Finance History button at the top of the page.

The history options generates a transaction history of finance activity against the customer, an example is shown below –

Order Flow

Controls relating to the acceptance, planning and scheduling of deliveries are system dependant. 

Limits may be set to stop sales orders without approved finance from being delivered.

Finance Claiming

Finance claiming is common to both modes of operation.

The finance claims report may be used as a pre or post-delivery step to ensure payment is sought from the appropriate finance house in a timely manner.

An example of the finance claims report is shown below –

See Finance Claims Report for more details.

Finance Payments

Menu Location: Accounts > Finance Reconciliation

Selecting the option from the menu produces the following screen –

The branch will default to that of the user and listed below are the finance companies where outstanding payments exist.

Payments cannot be allocated to unapproved finance applications.

To process a payment, select the appropriate  icon, the screen will then list all the orders linked to the selected finance company.

Options available

  • To indicate full payment has been received click the Fully Paid tick box for the appropriate item.  This will automatically complete the payment, cost and received fields for the chosen item using the preset subsidy value to calculate the cost of the service.

  • Manually enter the value of payment and / or cost of the service in the appropriate fields.  Payment cannot exceed the value of the Order Claim.   Specifying a value less than the outstanding order claim effectively instructs the system that a part payment has been received.

  • The Payment received relates to the full value including costs and is the value used to update the sales order.

  • The Cost relates to the cost levied by the finance house in facilitating the service and will either be calculated by the system using the pre-set subsidy percentage against the tender type or may be manually specified or altered.

  • The Received value is not user accessible.  It is displayed as a user check and indicates the value to be paid in to the retailer’s bank account.

Having specified either a payment or cost value clicking the calculate option instructs the system to calculate the other value again using any pre-specified subsidy percentage set against the tender type.

Payments are processed at sales order level and not at application level.

Where payment has not been received for a finance application, leave the payment and cost column blank.

Once all transaction have been recorded click the ACCEPT button.

This records the payments but leaves them amendable. No postings are made to a third-party accounts package and the sales order is not updated.  I.e. the payment has not officially occurred at this stage and is not visible within the sales order / customer account enquiry routines.

Confirming the Payments

Once payments have been recorded against the finance application/sales order the finance reconciliation page shows the pending payments in the reconciled / cost columns.

To finalise the transaction (point of no return), click the POST button.  This instructs the system to post the payments, thus updating the accounts interface and recording the payment against the sales order.

Payments entered will only show on the customer’s account once they have been posted.  If searching for missing funds use the finance reconciliation page (shown above) to establish if payments have been entered but not posted, values will show in the received column.

In common with the cash reconciliation process the routine will require confirmation of the posting date for the tenders being posted.

The routine produces a final confirmation of action message

Prior to producing an audit of the values processed.

Auditing the Account

Once a finance payment has completed the reconciliation process it will be visible via the customer account/sales order.

The sales order detail page shows reconciled finance payments in blue. (this field is only visible when finance payments exist against the sales order)

Processed finance payments are shown with blue text.

Customer Account

Clicking the customer name on the sales order produces the customer details tab

Selecting the Accounts tab shows the financial status of the sale..

Clicking the Payments tab shows individual payments processed.

Selecting Customer Accounts from the side panel whilst viewing the sales order shows the payment history of the sale.

Refunding Payments (Reclaim)

Menu Location: Accounts > Finance Reclaims

Only users possessing the CAN_REFUND_FINANCE privilege are allowed to refund finance payments.

Once a payment has been posted via the finance reconciliation process it may be necessary to reverse the transaction effectively giving monies back to the finance house. 

To progress with the refund, it is necessary to know the sales order reference being refunded.  Enter this in the relevant field and click the in FIND button.

The screen will redisplay showing the details of the selected sales order.

It is recommended that prior to defining the value of reclaim, the repayment type and agreement reference are selected.

  • Repayment type - Specify the tender type to be used as a refund method.  The system will only show tender types flagged as ‘refunds’.

  • Agreement reference - Select the appropriate agreement reference from the drop-down list.  This list will only show agreements where finds have been received (and posted)

Having selected the correct agreement reference the screen will redisplay showing the value of funds received/costs incurred to date. 

The Finance Amount is the total funds allocated to the sales order and includes costs.

 To process a reclaim specify –

  • Total value of repayment - Specify the sum of funds being reclaimed from the finance house. This value includes costs incurred. The value specified will be used to reduce the value of finance paid on the sales order.

  • Finance cost - Specify the costs to you the retailer as levied by the finance house and indicates the rebate they are giving in respect of the finance being repaid.

The system will then calculate the monies to be ‘removed’ from the bank account.

Check to ensure the details are correct and then click the POST button to update the sales order and begin the process of sending the information to an accounts package.

There is on pending status in this mode.  Reclaims must be fully transacted in a single step.

Clicking the POST button generates the posing date entry page prior to generating a transaction audit.

Once the posting date has been confirmed the system generates an audit of the transactions confirmed which are now capable of being sent / imported into an accounts package.

Viewing the customer’s account highlights the reclaim transactions (reclaim highlighted in with a red box).

The finance agreement will stay in place and allocated to the sales order. To cancel return to the Arrange Finance feature and Void the application.

Files from the Confluence page

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article