For many rental businesses, reconciliation is the job nobody wants. A bank statement arrives as a long list of lines, each with a date, an amount and a reference that may or may not mean anything. Someone has to work out which booking each one belongs to, and what is still owing. Done by hand, it takes an afternoon and still leaves doubts. Done with a little discipline and the right tooling, it takes a few minutes.
Start with the reference
Matching works when each payment carries something that identifies the booking. If your bookings have clear sequential references (for example, YR-9001), ask customers to quote the booking reference when they pay by bank transfer, and put it prominently on confirmations and invoices. This one habit decides how much of the work can be automated.
A weekly routine
- Export the statement. Download a CSV from your online banking.
- Import it. Upload the CSV so each line can be matched to a booking by reference.
- Review the matches. Spot-check them rather than re-doing them.
- Deal with the leftovers. Assign unmatched lines to the right booking by hand, and unmatch anything that was matched wrongly.
- Check what is owing. Look at each booking's ledger and your aged debtors.
Why a booking ledger helps
A ledger on every booking, showing what has been paid and what is owing, calculated from the payments recorded, means you never need to add things up from several places. When a customer asks "have I paid?", the answer is on the booking.
Know who owes you, and for how long
An aged debtors view lists overdue balances by how long they have been outstanding. Colour coding at 30 and 60 days makes it obvious where to chase first. Chasing early is easier and more likely to succeed than chasing late.
Record every payment type consistently
Cash, credit card, EFTPOS, bank transfer and account payments all need to be recorded in a consistent way for your totals to be trustworthy. A payment recorded in a notebook is a payment that will not appear in your reports.
Reduce the volume of manual payments
The less you rely on bank transfers, the less reconciliation you have. Taking card payments online at the point of booking, with confirmation through the payment provider, turns many payments into automatically recorded ones. See online booking for car rental.
Common mistakes
- Letting statements pile up for a month, so the job becomes a project.
- Accepting transfers with no reference, then trying to guess from the amount.
- Matching by amount alone, which breaks when two bookings are the same price.
- Not recording partial payments and deposits against the right booking.
In Rentals360
Rentals360 imports a bank statement CSV and matches lines to bookings by reference, lets you assign or unmatch manually, shows a ledger on every booking and an aged debtors view with 30 and 60 day colour coding. Read about payments and debtors, or book a demo. Bank CSV import and matching is included from the Pro plan; check the pricing page for current plans.