This knowledge base article will review the tools we have created to make it easier for you and your team to move customers onto ACH from check.
Customers like check payments, however they are costly and time consuming to manage - between chasing and depositing the checks, late payments and reminding customers about outstanding balances - these are all tasks that take your team hours every week that could be better spent driving more revenue.
The goal of this guide is to provide you an easy path to converting customers to ACH payment. This guide will go through how to consolidate all your check paying customers, and their contact information, and allow you to filter these based on volume of check payments so you can convert the heaviest users first.
You cannot change customer behavior, but you can nudge them. First thing you need to do is get a list of check paying customers and call them to move them to ACH. Some customers choose to pass on a check processing fee (and no fee for ACH) to nudge people to the preferred payment method. ACH is more reliable than check since you can store it on file for recurring or future charges.
- Download the excel spreadsheet here
- Login to ServiceCore - navigate to your payment page (Accounting > payments) and then filter the payments by Payment method = check, and payment date range = this year. Click export to Excel. You will find this download on your computer in your downloads folder.
- Now that you have the list of check payments, you need to download your customer list for contact information. Navigate to customers, and download your customer list as an Excel spreadsheet. This spreadsheet will get emailed to your user email address. Download the CSV from your emails
- Now that you have downloaded the check customer list and the contact information, you have to import everything into our template. We recommend that you use google sheets for this process, however if you have a lot of customers downloading everything and doing the work in Microsoft excel would be better.
Open your copy of the template. Once open, Click file > import. Click on the upload tab, and pick the payments file (This is the check payment list, and should be called payments.csv) - Change import location to "Insert new sheet(s)". Repeat steps 4 & 5 and import the customer list, again creating a new sheet. (Customer list should be called Customers_Export_xxxxxxxxxxx.csv (xxx= a string of random letters and numbers))
- Next step is to copy the data to where we need it to be. Open the Customers_export tab, and copy all of the data into the Customers tab from the template. To do so press Ctrl+A, Ctrl+C and then click the customers tab, click on cell A1 and press Ctrl+V (if you use a mac, press Command + A/C/V instead of Ctrl)
- Complete step 6 again but for the payments data.
- When you click on the summary tab, you now have all of the information needed to call your customers. So that you can target the highest using accounts, we need to replace the formulas with the raw data. To do so press Ctrl+A, Ctrl+C, Ctrl+Shift+V (For mac replace Ctrl with Command). You know this will have worked by clicking on Cell C3 -n you should see just the customer name in the formula line, rather than the formula (=unique, Payments!$AI$2:$AI)
- Now you can filter and sort the list based on most transactions / most volume. To do so, click on the filter button on cell F2/G2. And click sort Z to A.
You can now call out to your customers and get them moved over.
If you have any questions about this, please reach out to servicecorepay@servicecore.com