Banks will receive a single check payment for multiple invoices. For Canadian clients this can be up to 50% of all payments. The solution or way to handle this scenario is through the file format or layout. The mock up the file layout on the left that’s what is currently in use. This layout creates a payment per row. So it doesn’t accurately create the 1 payment received but it creates 2 payments, one for each invoice. But if it was structured in a way like on the right, then you can see that 1 Check payment for a total of $4162.75 applies to 2 invoices. So that would correctly create 1 payment record in Zuora that would then apply to 2 invoices. Zuora Invoice Number Payment Amount Check Number Payment Date Check Number Payment Amount Payment Date Zuora Invoice Number INV00708401 395.48 123 10/2/2017 123 4162.75 10/2/2017 INV00708401 (invoice balance is 395.48) INV00707646 3767.27 123 10/2/2017 INV00707646 (invoice balance is 3767.27) INV00709861 464.86 456 10/2/2017 456 5267.97 10/2/2017 INV00709861 (invoice balance is 464.86) INV00710197 423.23 456 10/2/2017 INV00710197 (invoice balance is 423.23) INV00707548 4379.88 456 10/2/2017 INV00707548 (Invoice balance is 4379.88) INV00707705 6930.77 789 10/2/2017 789 6930.77 10/2/2017 INV00707705 1 payment for 1 invoice
... View more
Couple things that I would love to see on Configurable Lockbox: - Ability to use invoice sequence numbers instead of Zuora OOTB assigned invoice number. Our customer's only see the sequence numbers and reference these on payments. (Makes it hard to automate this application for our payments application team) - One format for Wires/ACH and checks. Currently we need to create two formats and uploads for payments. One for checks and another one for wires.
... View more