Reconciles

Lockbox reconciliation software that ties every deposit to its checks

Reconciles is lockbox reconciliation software for finance teams that receive customer checks through a bank lockbox. You upload the bank statement and the lockbox detail report that lists each check, and Reconciles matches the batch deposit to the checks inside it and each check to the open invoices it pays. Short pays, unapplied checks and missing items go to an exceptions queue with the exact amount. Plans start at $888 a year, and the first matches appear before you create an account.

Your files are processed in your browser and never stored. No card needed.

Why a lockbox deposit never matches one ledger line

A bank lockbox collects the mail, opens the envelopes, deposits the checks and sends you a report. The bank statement then shows one credit for the day, while your ledger has to show one receipt per customer. Those two views are never the same size.

  • One deposit of $41,860.15 holds 23 checks, and no ledger entry has that amount.
  • A check pays three invoices, or pays two and leaves a third open.
  • A customer short pays and writes a deduction code on the stub, or nothing at all.
  • A check arrives with no invoice number, so cash application cannot place it.
  • A returned check reverses a deposit that was already matched.
  • Checks from one batch post on different days in the ledger than in the bank.

Teams close this gap with a spreadsheet. They paste the lockbox report beside the statement, add up checks by hand until the total equals the deposit, then look up each invoice. With 30 checks a day that is an hour of ticking, and the month end difference is hard to trace afterwards.

How to reconcile a lockbox with Reconciles, step by step

  1. 01 Export the three records

    Download the bank statement for the lockbox account as CSV, XLSX, OFX, QFX, MT940 or CAMT.053. Export the lockbox detail report from your bank portal as CSV or XLSX, one row per check. Export open invoices or the cash receipts journal from your accounting system.

  2. 02 Upload them together

    Drop the statement, the lockbox report and the ledger export into one workspace. Reconciles reads columns by content, so there is no template to build for each bank.

  3. 03 Review deposits, checks and invoices

    Each bank credit is matched to the lockbox batch that adds up to it, and each check is matched to the invoices it pays. A deposit whose checks add up to a different total is held back with the difference shown.

  4. 04 Work the exceptions and export

    Short pays, unapplied checks, duplicates and returned items sit in one queue. Export approved adjustments as journal entries and keep the report as the evidence for month end.

Who uses lockbox reconciliation software

  • Accounts receivable and cash application teams at companies that still receive paper checks, such as distributors, manufacturers, utilities, schools and healthcare billers.
  • Controllers who must prove the lockbox account at month end and explain every difference.
  • Property managers and associations that collect rent or dues by mail, see property management bank reconciliation.
  • Bookkeeping firms that reconcile lockbox accounts for several clients on one workflow.
  • Medical and dental practices whose payer checks come through a lockbox next to insurance EFTs, see healthcare payment reconciliation software for matching each EFT to its 835 remittance.

If you are hiring a cash application specialist to take this work over, a work sample test from Skillsvalidator can show who is fast in Excel and careful with reconciliations before you make an offer.

What the matching catches in a lockbox

  • Deposits where the checks in the batch add up to a different amount than the bank credited.
  • Checks paid against the wrong invoice or against an invoice that is already closed.
  • Short pays with the exact gap, so collections can chase it the same day.
  • Checks on the lockbox report that never reached the bank, and credits with no report behind them.
  • Duplicate checks and returned items that reverse an earlier match.
  • Bank fees for the lockbox service that nobody has booked.

Every match shows its reason and a confidence score, so a reviewer accepts it in one click or opens the exception. For the application side, see cash application software.

Reconciles compared with a bank portal, a spreadsheet and a cash application suite

Your bank's portal gives you the lockbox report and the images, which you need. It does not prove that the report agrees with the statement and the ledger. Large receivables suites, such as the ones covered in our Billtrust alternative and HighRadius competitors pages, automate remittance capture and application, and they are quoted as annual contracts.

NeedBank portalSpreadsheetCash application suiteReconciles
Lockbox report and check images Yes No Yes No, uses the report
Prove deposit equals checks in batch No By hand Yes Yes
Match each check to open invoices No By hand Yes Yes
List short pays with the gap No By hand Yes Yes
Match other bank accounts and processors No By hand Often extra Yes
Published price Part of lockbox fees Staff hours Quote $888 to $5,988 a year

Keep the bank lockbox for collecting the checks. Add Reconciles as the second check that the money in the bank is the money in the books. The bank reconciliation software page shows the same matching on every other account.

One lockbox day, line by line

Say the bank credits $9,415.50 on the 12th. The lockbox report lists 6 checks, $2,100.00, $1,850.25, $3,000.00, $1,200.00, $750.00 and $515.25. They add up to $9,415.50, so the deposit ties out.

Now the invoices. The $1,200.00 check was written against invoice 4417 for $1,250.00. Reconciles matches the check to the invoice, sees the $50.00 gap and sends it to the exceptions queue as a short pay with the customer name and invoice number. The $750.00 check has no invoice number on the stub, so Reconciles lists the two open invoices of that customer that could equal it and proposes the one whose amount is exactly $750.00.

If the bank had credited $9,165.50 instead, the deposit would fall out of the match with a $250.00 difference, and the $750.00 check would be the first candidate to check, because a check on the report with no credit behind it usually means a check deposited a day later.

Plans for lockbox volumes

Starter is $888 a year billed yearly for 3,000 matched transactions a month. Growth is $2,388 a year for 20,000 a month across 5 entities, for companies with lockboxes at several banks or in several entities. Scale is $5,988 a year for 100,000 a month across 25 entities. Monthly billing is $149, $399 and $999. See pricing for the full limits.

Lockbox reconciliation questions

Check last month's lockbox against the bank

Upload the lockbox report and the bank statement. You will see which deposits tie to their checks and which lines do not, before you create an account.