Bank reconciliation is the one bookkeeping task every travel agent knows they should do — and the one most of them avoid. It has a reputation for being tedious and confusing, especially for independent travel advisors who weren't trained as accountants. But here's the truth: once you have a system, reconciling a travel agency bank account takes about 10 minutes a month. Here's exactly how to do it.
Why Reconcile in the First Place?
Reconciliation is the process of matching every transaction on your bank statement to a transaction in your books. The goal is to verify that your books reflect reality — that every dollar in your bank account is accounted for, and every transaction in your books actually happened.
For a travel agent, reconciliation catches three common problems:
- Missing commission payments — a host payout that never arrived, or arrived for the wrong amount
- Forgotten transactions — a charge you never recorded in your books because you didn't have time
- Duplicate entries — the same transaction recorded twice because you imported it and then entered it manually
Skipping reconciliation means your books are guessing. Your Profit & Loss report might look fine, but it might also be off by $500 because of a clawback you didn't notice. Reconciling catches these problems before they snowball.
What You Need Before You Start
You'll need three things to reconcile a travel agency bank account:
- Your bank statement — either the PDF your bank sends monthly, or the online transaction list
- Your books — the bookkeeping software or spreadsheet where you track transactions
- 10 uninterrupted minutes — reconciliation is easier when you can focus
That's it. No special training required.
The 5-Step Reconciliation Process
Step 1: Set the Period
Pick the time period you're reconciling — usually a single calendar month. Note the starting balance (the balance your books showed on the first day of the month) and the ending balance (what the bank statement says on the last day).
If you're reconciling for the first time, start with the most recent month. Don't try to catch up on 12 months of missed reconciliations all at once — you'll burn out. Just do the most recent month, then do the next one next week.
Step 2: Mark Every Transaction as Cleared
Go through each transaction on the bank statement, one by one. For each one, find the matching transaction in your books and mark it as "cleared" or "reconciled." In UrTravelPro Books, this is a single checkbox per transaction. In other systems, you might be updating a column in a spreadsheet.
Most transactions will match perfectly on the first pass. A few won't. That's fine — come back to those in step 3.
Step 3: Investigate the Mismatches
The transactions that don't match are where reconciliation pays off. Each mismatch falls into one of four categories:
- On bank, not in books — you missed recording a transaction. Add it to your books now.
- In books, not on bank — you recorded something that didn't actually happen (double entry? typo? pending transaction that bounced?). Investigate and delete or fix.
- Wrong amount — check both the bank statement and the original receipt. The bank is almost always right, so update your books to match.
- Wrong date — the transaction happened on one day but posted on another. This is common with weekend transactions. Update your books to match the bank's posted date.
Step 4: Check the Running Difference
As you mark transactions cleared, your bookkeeping software should calculate a running difference — the gap between the ending balance on the bank statement and the sum of all cleared transactions in your books. When the difference is zero, you're reconciled. When it's not, there's still a mismatch somewhere.
If the difference is small (say, $0.01 or $0.05), it's usually a rounding issue and you can adjust. If it's larger, go back through step 3 and find what you missed.
Step 5: Attach the Bank Statement and Close the Reconciliation
Once the difference is zero, mark the reconciliation as complete and attach the bank statement PDF to the reconciliation record. This gives you a paper trail that proves you did the work, and a quick reference if you ever need to look back.
Congratulations — you're reconciled. That whole process should have taken about 10 minutes for a typical independent travel advisor with 30-60 transactions in a month. The more you do it, the faster it gets.
Common Reconciliation Problems and How to Fix Them
"The Difference Won't Go to Zero"
The most common reconciliation headache. Usually, this is caused by one of these:
- A transaction with the wrong amount (off by 10x, or a digit swapped — check every non-round amount)
- A duplicate entry in your books
- A missed transaction (check the bank statement line by line)
- A commission payment that hit the bank but was recorded as a different amount in your books
If you're close but not exact, the amount of the difference is often a clue. A $120 difference is probably a single transaction — find it and fix it. A $0.37 difference is probably a rounding issue with a foreign currency charge.
"Old Transactions Won't Clear"
Sometimes a transaction from a previous month hasn't cleared yet (a check that was cashed late, a deposit that's still processing). That's normal. Leave it uncleared and move on. It'll clear on a future reconciliation.
"I Have Too Many Transactions to Reconcile Quickly"
If you're drowning in transactions, it usually means two things: you have too many small transactions (consolidate where possible), or you have a backlog (reconcile last month first, then work forward). The good news: once you're caught up, staying caught up is easy.
The Habit That Makes Reconciliation Painless
The single most important reconciliation habit is this: do it every month, on the same day. Pick the 5th of each month (after your bank statement closes) and block 15 minutes on your calendar. Treat it like a meeting you can't skip.
If you reconcile monthly, it takes 10 minutes and catches every mistake while it's fresh. If you reconcile quarterly, it takes 45 minutes and you can't remember half the transactions. If you reconcile annually, it takes a weekend and you need a stiff drink. The time cost compounds against you.
Let the Software Do the Heavy Lifting
A good bookkeeping tool should make reconciliation painless. Look for these features:
- One-click clear — mark transactions as cleared with a single checkbox, not a multi-step form
- Running difference display — always visible so you know how close you are
- Attach statement — upload the bank statement PDF to the reconciliation for your records
- Resume later — save a reconciliation as "in progress" and come back to it
- Previous reconciliation history — see every reconciliation you've ever done
Our reconciliation workflow in UrTravelPro Books was built specifically around this — the running difference is always visible, cleared transactions are one click, and the bank statement PDF attaches directly to the reconciliation record. Most users report their first reconciliation takes about 15 minutes (including learning the interface) and every one after that takes 10 or less. Free during public beta — and your monthly close will never be a source of dread again.
