Blog Home

Accelerate your Salesforce Org with a Lockbox Payment Applicator

What is Lockbox?

Due to the increase of teleworking amidst the global coronavirus pandemic, Associations that still receive checks in the mail to their physical address have had to address: who goes in to collect the mail, logs the checks, and the next steps to deposit the checks and apply payments against orders in your CRM. If your organization uses a lockbox functionality, you have seen your return on investment with a low risk to human capital. A lockbox is simply a PO Box that’s accessible by the bank. It allows the bank to open the mail, log and deposit checks, and then provide your organization with a detailed report tying the customer to the order and payment amount.

Rather than applying payments one by one, fusionSpan developed an online payment applicator built on the Salesforce platform. The Lockbox feature allows organizations to streamline posting payments into your Salesforce CRM. In fact, if your check logs can replicate the data template received from your Lockbox, this will streamline the process for you as well.

Through our custom Salesforce object, Payment Request Header, organizations can upload, validate, and apply payment to multiple orders with just a few simple clicks! The product provides ease of access for the user to apply and receive mass payments to invoices and has been designed into three simple stages: Import, Validate, and Apply.


Built with the user in mind, the Lockbox Accelerator can be used with a variety of CSV and Excel formats. The product takes the bank supplied files to automatically pay orders related to that file. We created our Lockbox Accelerator to use a custom metadata type, allowing your Salesforce Admin to easily configure your file format by criteria such as column index. This allows your organization to update your file structure without interruption.

Furthermore, the system uses packaged custom objects for uploading Lockbox files (meaning the user doesn’t have to create anything, we create the object structure for transferring file details into Salesforce). This allows us to upload all data and separate the good from the bad ( misformatted rows, orders that have already been paid, etc.) in the second stage: Validation.


fusionSpan developed a very customizable platform to allow the user to choose which fields are brought in and how they are validated during this phase. Using batch apex, the system can process up to 50 million orders at once, supporting almost any file size.

Our standard verification process includes identifying the order of the payment within the system, validating the payment amount, verifying that two payments do not apply to the same order, and more. Furthermore, while we do have our standard code, the system allows custom validation. This allows the user to write their own custom apex class for handling the validation of each payment from the lockbox file.

Checking each field off the customizable fields provided, the lockbox application will mark all bad data with error messages. The system allows you to run reports on all rows from your Lockbox file that were improper. An end user can easily validate each row of payment received in the file with the click of a button. Once validated, payment request details with errors will be flagged for review and payment request details without errors will be ready for the last stage, applying payment.


The final step is applying payment! Once your payment request details are ready for application, one click and all payments are processed in the system. Staff will be able to create necessary data in the system for a whole file, as opposed to manually applying payment to each order for each payment. Our clients that use lockbox said this has saved hours or even days of work.

Payment Application can take some time since the lockbox must interact with payment gateways and process any additional data necessary from the purchase. All integrations relying on orders in the system will be able to perform their standard functionality and the system will create an automated generation of any receipts or transactions from the user paying their order.

Schedule a Demo Today!

As other organizations have begun to create similar products, we have developed our Lockbox with the user in mind, allowing for speed and ease of use. fusionSpan is cognizant of the fact that different customers have different needs, and our system gives leeway all the way from the standpoint of the imported fields to the validation checklist. We have provided extensibility in addition to standard functionality built into the system, and this has been a very popular application since it’s recent development. Schedule a demo with us today to see how Lockbox could be a fit for your organization!

Schedule Demo

The following two tabs change content below.
Christopher Mudd

Christopher Mudd

Christopher Mudd is a Software Developer at fusionSpan who mainly helps with Salesforce Implementations. He graduated from University of Maryland, College Park where he studied both Psychology and Computer Science. Christopher is always looking to spread positivity and is passionate about making the world a happier place. In his spare time he enjoys reading, creating content on social media, video games and spending time with his soon-to-be two year-old son, Jaxon, and his dog, Link (He’s a Min Pin!)
Comment Image

Share your insight