Dealer Software

Lender Funding Reconciliation for Independent Used-Car Dealers

14 min read · Updated 2026-11-11 · by the Loturn team

Lender Funding Reconciliation for Independent Used-Car Dealers

Bookkeeper matching a lender payment to a deal

Lender funding reconciliation is the routine of proving that the money a lender sends you matches the deal you booked, vehicle by vehicle. You start from the contract you signed with the customer. You compare it with the lender’s approval, stips and remittance, and you explain every difference before the cash is posted. Done daily, it keeps contracts in transit from turning into old, forgotten receivables. It also keeps your per-car gross honest.

Loturn
See Each Vehicle’s True Profit
Loturn tracks vehicle costs from purchase through reconditioning, helping independent dealers understand per-car profit alongside lender funding.
Visit

TL;DR

  • A contract in transit (CIT) is a signed deal the lender has not yet funded. Reconcile it every day, not at month end.
  • Compare four things for each VIN: the deal as booked, the lender’s approval and stips, the funding package, and the amount that actually arrives.
  • Funding that regularly takes more than twelve days from the sale points to a paperwork or process problem, according to a dealership accounting firm.
  • Book finance income when the deal is booked, then post the lender’s cash against it. The gap is your exception list.
  • Unreconciled funding distorts per-vehicle profit and your cash forecast, so tie each lender payment back to a VIN.

Table of Contents

What lender funding reconciliation means on a small lot

A large franchise store has a controller and a full back office. On an independent lot, the owner, a manager or one office person often does it all. The task is the same, though. You deliver a car on financing, the customer signs a retail installment contract, and you wait for the lender to pay you.

Until that happens, you hold a contract in transit. A dealer-facing glossary from an auction company defines CIT as a purchase contract signed but not yet funded by the financing institution. It says funding typically follows within one to three business days, and that an aged CIT balance signals funding delays or compliance issues. Treat those figures as a glossary’s general view. Your own lenders may be slower or faster, so measure them yourself.

Reconciliation answers three plain questions about each deal:

  1. Did the lender fund it at all?
  2. Did it fund the amount we expected?
  3. Is the cash posted to the right vehicle, the right receivable and the right income account?

If you can answer all three for every unit sold last week, you are reconciled. If you can’t, money is sitting somewhere you can’t see.

The records you compare for every deal

Each financed sale produces a small stack of documents. The reconciliation is a matter of lining them up, and the lender’s own funding requirements show you what that stack looks like. One lender’s published funding checklist asks for the credit approval and a credit application signed by the borrowers. It also asks for the promissory note, disclosure and security agreement, with accurate TILA and payment schedule sections, and a copy of the bill of sale. It lists driver’s license copies, title paperwork and insurance information as well. Your lenders will have their own version, so keep each one’s checklist handy.

For reconciliation, the useful comparison looks like this:

Record What it tells you What to check against
Deal jacket and bill of sale Sale price, down payment, trade, fees, date of sale The amount financed on the contract
Retail installment contract Amount financed, APR, term, payment schedule Lender approval terms
Lender approval and stips What the lender required before funding Which stips are cleared and submitted
Funding package or submission record What you sent and when Lender’s acknowledgment
Lender remittance or bank deposit What was paid, on what date Expected amount, less any reserve or fee
General ledger Contract receivable, finance income, vehicle cost All of the above

The goal is not to rebuild the deal. It is to find the one line where two records disagree.

A daily process that works

The most practical method comes from a dealership accounting firm. Withum’s dealership procedures guide recommends compiling the CIT report daily in summary form with aging information. It also says the report is more useful in its detail version, including zero balances. That version shows the date each contract receivable was posted, which should match the sale date. It also shows the date each contract was funded, which should match the date the bank paid.

Here is that approach as a routine you can run in about fifteen minutes a day.

Step 1: Pull the open contracts

List every financed deal that has been delivered but not funded. For each one, note the VIN, customer, lender, sale date, amount financed and days open.

Step 2: Age them

Group the list into buckets: one to three days, four to ten, eleven to twelve, and over twelve. Anything past the lender’s usual funding time gets a phone call or a portal check today.

Step 3: Contact the lender on the stragglers

The same guide says that when contracts do not fund, you should ask the funding source through your dealer system, by email or by phone. Open items the lender’s analysts point to usually mean the submission was incomplete or missing documentation. Ask for the exact list of what is missing and write it on the deal.

Step 4: Match the cash that arrived

When a lender payment lands in the bank, match it to the deal it belongs to. Check the amount against what you expected. Clear the receivable for that VIN only when the amounts agree, or when you have booked a documented difference.

Step 5: Review the exceptions weekly

Once a week, pull the detail report for deals that took twelve or more days to fund. The same Withum procedure lists exceptions by customer name and traces each one back through the dealer management system to find the delay reason. Then you look for trends: one lender, one salesperson, one missing document type. Update your protocol and repeat the review regularly.

What counts as a normal funding time

Measure your own numbers against a benchmark. Withum describes a healthy funding rate as four to ten days from sale to receipt of payment. It says consistent funding beyond twelve days strongly suggests inefficiencies in the sales department.

The path of the paperwork matters too. An F&I industry magazine article on CIT says electronically contracted deals fund within 24 hours. It gives three to four business days as the average for mailed-in contracts. Its typical timeline runs nine to ten business days from a Saturday deal, and 11 to 13 business days if stipulations or a re-sign are involved. That article dates from 2017, so read it as a pattern rather than a current standard. The lesson holds: every extra handoff and every correction adds days.

For a small lot, those days cost real money. If you carry the unit on a floorplan line or your own capital, you are paying to wait. Our guide to month-end VIN floorplan reconciliation shows how to tie that cost back to each unit.

Why funding does not match the deal

Most mismatches fall into a few buckets. Knowing them lets you fix the cause rather than the symptom.

Incomplete or incorrect paperwork. The lender’s checklist says plainly that errors or omissions in the funding package pend the contract and delay funding. A missing signature, a wrong payment schedule or an unsigned application is enough.

Open stipulations. A stip is a condition the lender attaches to approving the deal. Common ones are proof of income, employment verification, proof of insurance, a second ID, an updated application or a corrected contract page. According to a dealer software company’s explainer on stips and CIT, until every stip is cleared and submitted, the deal is not commercially complete. The same piece notes that when a car is delivered before funding and the lender then declines or asks for stip resolution, the dealership may have to unwind or re-fund the transaction.

Amount differences. The lender may pay a different figure than you booked. Typical causes are a fee or product that was added or removed, a change to the amount financed after approval, or a reserve or holdback in the lender’s program. Your lender agreement tells you which applies. Never assume.

Booking errors on your side. Sometimes the lender is right. The deal was keyed with the wrong price, trade allowance or product cost, and the error only surfaces when the payment does not match.

Timing. A payment can land in the bank before you have matched it, or a deal can be booked in one month and funded in the next. That is not an error, but it needs to be visible on your aging list.

Why funding does not match the deal

Book the income first, then match the cash

The cleanest control is to record finance and insurance income when you record the deal, not when the check arrives. In an Auto Dealer Today article, CPA David Keller advises recording F&I income at the same time as the car deal in the general ledger. Posting the cash received afterward highlights differences. Those differences may come from the F&I calculations, the bank’s calculations or an inaccurate recording of the car deal. The article dates from 2006, but the logic does not depend on any software.

Keller also suggests setting a threshold for investigation, for example $5. Any difference over that amount goes to the F&I manager on a schedule, and the manager must explain it. He recommends a separate income adjustment account for each product so you can see what you wrote off. Pick a threshold that fits your volume and stick to it.

This pairs naturally with proper revenue timing. Our article on per-VIN revenue recognition for used car dealers covers when a deal counts as sold. For fee income that rides along with the deal, see our setup guide on doc fee tracking. If you pay salespeople spiffs on financed deals, spiff accounting entries keep those costs attached to the same unit.

Book the income first, then match the cash

A worked example

Say you sell a used SUV on a Saturday. Your deal shows an amount financed of $18,400. The customer drives away that day, and you book the receivable from the lender.

On Monday, your daily open-contract list shows the deal at day two. Nothing to do. By the following Friday it is at day seven, still inside a healthy range. The next Tuesday it hits day ten, so you call the lender. They tell you one stip is open: a proof of insurance document was never uploaded. You get it from the customer, send it the same day, and note the date on the deal.

The payment arrives two days later at $18,400. You match it to the VIN, clear the receivable and record the funding date. The deal took twelve days. That is at the edge of the range, so it goes on your weekly exception list with the reason: missing insurance proof at delivery.

A month later you notice three of your last eight exceptions were the same missing document. The fix is a line on your delivery checklist, not more phone calls. That is what the reconciliation is for.

Tighten the front end so the back end is quiet

Most reconciliation work is really prevention. Before a deal is submitted, have a second person check it. The dual-signoff idea is common in dealer compliance templates, with the F&I manager and the billing clerk both confirming the deal jacket before it goes to the lender. On a lot with two or three people, the second pair of eyes can be the owner on a quick pass.

A short pre-submission check should confirm:

  • Every signature and initial is on the contract and the application.
  • The amount financed matches the bill of sale.
  • Every stip on the approval is attached.
  • Insurance, ID and title items match what that lender requires.
  • Products and fees on the contract match what you booked.

Our deal posting checklist for used car dealers turns the booking side of this into steps, so the numbers you post on the day of the sale are the numbers you later expect from the lender.

Where AI help fits, and where it should not

Software can speed up the matching. A tool can read a remittance, find the likely deal and propose an entry. AI tools for dealer operations are one place dealers are exploring this kind of work. The control stays the same, though. As one 2026 dealer-industry blog post argues, a match between a funding confirmation and a schedule line is a proposal, and a person with the controller’s login should accept it. Nothing should post to the ledger or go to a lender on its own. On a small lot, that person is you or your bookkeeper.

If you want the general discipline behind this, a primer on accounts reconciliation basics explains why comparing two sets of records and resolving each difference is the core of all reconciliation.

How funding reconciliation sharpens profit and forecasts

This is the part many dealers miss. Funding is not just a cash event. It decides whether the profit you think you made on a car is real.

Per-vehicle gross. If finance income, product income or a lender fee is booked on a deal but never matches what the lender paid, the gross on that VIN is wrong. It may be overstated, or it may be understated by a chargeback. Reconciling each payment to its VIN means every unit’s profit includes what was actually collected. Pair this with a clean per-VIN unit cost rollup, which captures purchase price, transport and recon, and you can see true profit on each car instead of guessing.

Cash forecasting. Money owed by lenders is cash you will receive soon, but only if you know how soon. Your own funding-time history, by lender, lets you predict when receivables turn into cash. That feeds directly into a 13-week dealership cash flow forecast. If one lender averages six days and another averages eleven, your forecast should treat them differently.

Floorplan cost. When a financed car is sold, you usually need to pay off the floorplan line. Late lender funding can delay that payoff and add interest. Our floorplan payoff checklist shows how to clear liens quickly once funds arrive.

Bank reconciliation. Lender deposits are among the largest items on a dealership’s bank statement. If you have matched them to VINs already, your monthly bank reconciliation becomes a short check instead of a hunt.

Perspective

We built Loturn around one idea: a dealer should know what each car really earned, and know it before the paperwork is a month old. Funding is where that idea is tested. A deal can look great on the desk and then leak profit through a missed stip, a changed amount or a payment nobody tied back to the car.

That is why we think funding belongs inside the same system as your inventory, your costs and your books, not in a separate spreadsheet that someone updates when they have time. When purchase price, transport, recon, deal details and the ledger all live per VIN in one place, a lender payment has an obvious home. A difference stands out because everything around it is already organized.

Small lots do not need more complexity. They need fewer places to look. Our approach is flat monthly pricing with every tool included, free data import and support from real people who answer the phone, so the discipline of reconciling every deal does not depend on how many add-ons you can afford.

Eric Dosset

See per-car profit without the spreadsheet

Loturn is a financial management platform built for independent used-vehicle dealers. It tracks every cost against each vehicle, from purchase price to transport and recon, and gives you native double-entry accounting with an automotive chart of accounts. You get real-time gross tracking, floorplan interest tracking, reporting and a mobile inventory app, all under one flat monthly price with no add-on module or per-transaction fees. We offer free data import to get you set up.

Loturn

Plans are published at three levels: Flipper at $99 per month, Dealer at $349 per month and Multi-Lot at $699 per month. You can compare them on the Loturn pricing page and choose the one that fits your lot’s size and volume.

FAQ

What is a contract in transit?

A contract in transit is a retail installment contract the customer has signed but the lender has not yet funded. The dealer has typically delivered the vehicle already. It stays on your books as a receivable until the lender pays, so it should be tracked daily and aged.

How often should I reconcile lender funding?

Review open contracts every day and match incoming payments as they arrive. A dealership accounting firm recommends compiling the CIT report daily in summary form with aging. Do a deeper exception review weekly, then reconcile the bank account at month end.

What do I do when the lender pays a different amount than I booked?

First compare the contract, the lender’s approval and the remittance detail to find what changed: a fee, a product, the amount financed or a reserve. If the error is in your booking, correct the deal. If it is the lender’s, contact them with the VIN and documents. Record any write-off in a separate adjustment account so it stays visible.

Why are some of my deals taking more than twelve days to fund?

The usual causes are incomplete paperwork, open stipulations and slow submission. A dealership accounting firm treats funding that is consistently beyond twelve days as a sign of inefficiency in the sales process. Trace each late deal back to its cause and fix the pattern at the delivery checklist.

Sources

See your real profit on every car

Loturn puts every cost on the VIN as it happens, so the profit on screen is the profit in the bank. Flat price, no contract, we import your data.

Start free trial