Client Payment Import
This article is part of the Imports section.
Find all related articles here:
The Client Payment Import tool in CPL allows you to upload a file from your bank or provider, so CPL can record payments against the relevant client accounts.
Getting Started
- Go to the Tools menu.
- Select Data Import from the drop-down, then choose Client Payments.
This will open the Client Payments Import Wizard on the Data File Import screen.
Uploading the File
Here you'll find the import templates you've requested, which CPL has configured for you. CPL will also provide a sample .csv file to assist you before you start importing client payments.
To upload your file:
- Highlight the appropriate import template.
- Click the folder icon in the bottom-right corner to browse for the .csv file:
Make sure the file isn't open, as open files cause import errors. - Select the file and click Open to begin the upload. A progress bar will appear and a pop-up will confirm when this is complete. Click OK.
- When the progress bar reaches 100%, it will show the number of processed payments. Click Show Details for more information:
- If you see "0 rows were not understood", it means all rows were processed successfully. If issues appear in red, they need to be resolved before proceeding. Click Next:
Validating the Data
On the Validation screen each payment appears in the grid at the top, displaying one of the following icons:
- A green tick indicates that the payment row can be imported:
- A stop sign shows that there are missing posting details, preventing import:
- A document with an arrow indicates it has been imported previously and will not be imported again:
Review and resolve any data issues:
- Check the box in front of each row you wish to import.
Only the rows marked with a green tick can be imported.
- To organise the grid by the symbols, click on the empty cell above the column. An arrow will appear. Click the cell again to reverse the row order:
- To view details for a specific row, click on it to display the details in the Posting Details section at the bottom. Here you can adjust some details as needed.
For example, if the correct client hasn't matched automatically, click on the binoculars icon to search for them:
To search for a client, do the following:
- Enter the client's name, address or account number in the search box.
- Highlight the correct result.
- Click Open Client to view the client account (optional).
- Click Select to choose the client.
- You can also use the Search by Balance Due checkbox to enter a balance range and display clients who owe within that range:
Once you've finished selecting a client, click on another row in the grid to refresh the selection there.
- You'll also need to address any other missing information until the stop sign turns into a green tick.
- As you resolve any missing information, each payment will auto-select itself in the Select column once it has all the required details:
- The Nominal and Payment Type columns should be populated in the grid. You can amend these manually for each payment as needed.
If a payment reference doesn’t match the client account number in CPL, you can manually match it to the correct client. In future imports, CPL will automatically match the payment as long as the reference stays the same.
Splitting the Client Payment
While a payment is highlighted in the grid, you can use the Posting Details section to allocate a percentage of the total payment to any outstanding Float or Proposed Works balance:
- Adjust the Amount field to split the payment between the Float and PW Amount fields. If part of the payment should go toward a proposed work, select the appropriate one from the Proposed Work drop-down.
- The last column on the right shows any outstanding amounts, helping you split the payment correctly:
- In the next screen, you’ll have the option to pay off the outstanding float first for all clients, before applying the payment to the balance.
- Once all payments have green ticks, make sure they’re selected and click Next to move to the Payment Posting screen.
You can process only some payments now. Upload the same file again later and the system will display the document icon with an arrow at the start of the rows that have already been imported.
Posting the Data
The Payment Posting screen displays the selected payments. Review them before posting to CPL. If you need to make changes, click Back to return to the Validation screen.
At the bottom-left, you can choose to settle clients' floats as part of their balance. By default, the system processes one payment per client, but selecting Settle Float will pay off any outstanding float first, then the remainder will go toward the balance:
Ticking this option will move the relevant amounts into the Float column:
This applies to all clients in the list.
A warning will appear, click OK to continue:
Once you've confirmed everything is correct, click Post to process the payments. Click Show Details to double-check that everything is being posted correctly.
The progress bar will update and once finished, click Next to continue.
Reconciliation Import Screen
The next screen is the Reconciliation Import screen. If it's blank, no further action is needed. Click Next to move to the final Summary screen.
This screen is used when importing reconciliation entries, not payments. For example, payments may have already been posted into CPL through the usual methods, such as client telephone payments or web portal payments. Users can then import their bank statement and use it as a reference to reconcile their bank. In this case, you would perform a payment reconciliation import. During the first steps of this process, you would select an import template specifically for payment reconciliation imports.
Summary Screen
A Processing Report message appears, followed by the Data Import Payment Report. This lists the posted payments and the batch number:
You can save or print this report using the icons at the top.
This is the final step of the import process. Click Finish to complete it.
The imported payments appear in the Transaction Activity tab of the relevant client accounts.
The Bank Nominal from your .csv file and the Client Control Nominal are also updated. To check this, go to Reports > Nominal Reports > Nominal Batches Report, then enter the batch number in the filter on the left.
Related Articles
Diarised Charges Import
This article is part of the Imports section.. Find all related articles here: Imports Diarised Charges This guide walks you through using the Diarised Charges Import tool to upload diarised charges for specific developments and clients. Getting ...Purchase Ledger Invoices Import
This article is part of the Imports section. Find all related articles here: Imports This guide walks you through using the PL Invoices Import tool to upload purchase ledger invoices for your PL accounts. Getting Started If your import is set up to ...Client Payments
You will find links below to Invoicing Guides and Helpsheets related to client payments in CPL. Client Payments Helpsheet - Receiving Payments - Daily Posting Screen v1.0 Helpsheet - Client Payment Import v1.0 Helpsheet - Payment Reconciliation v1.0Client Web Portal
You will find links below to Training Guides related to the CPL Client Web Portal. Client Web Portal Training Guides and Helpsheets Authorising New Web User Accounts Helpsheet - Client Portal Tab Options v1.1 Working with Client Portal Documents ...Blink - Card Payments
This article is part of the Client Payments section. Find all related articles here: Client Payments The Blink integration allows you to accept card payments from clients either through the Web Portal or directly in CPL. Card Payments in the Web ...