Download Daily Bank Reconciliation as a PDF
Daily Bank Reconciliation compares your trust bank account balance with the transactions recorded in BookingTrust.
All recorded transactions appear in Trust Account > Cashbook, but some may not yet have appeared in your bank account. For example, a bank transfer already recorded in BookingTrust may take 2–3 days to appear on your bank statement. Daily Bank Rec and the Transaction List help you identify these late payments and reconcile your current bank balance with them in mind.
1. Confirm daily transactions
Go to Trust Account > Bank Rec > Transaction List (Grouped).
The Transaction List shows all recorded transactions, including money paid out for invoices and management fees, as well as booking payments.
- Match transactions using the Payment Method and Date columns. For example, two transactions may make up one booking.
- Adjust the date to the date the transaction appeared in the bank account.
- Click the orange Confirm button on the right for transactions already recorded in your bank account. Leave transactions unconfirmed if they have not yet affected the trust account balance.
Daily Rec takes into account only confirmed transactions that have affected your trust account balance. We highly recommend reconciling your BookingTrust transactions every day.
UnConfirm a transaction
If you accidentally confirm a transaction, go to Trust Account > Bank Rec > Confirmed Transactions and click the red UnConfirm button. The transaction returns to the Transaction List.
2. Run Daily Rec
Next, record your actual trust account balance and compare it with the BookingTrust records.
- Go to Trust Account > Bank Rec > Daily Rec.
- Enter the date of your bank statement and your trust account bank balance.
- Click Submit.
We recommend using the previous day’s date and balance each time, because same-day transactions may still be processing.
3. View the Daily Rec report
If the balances match, BookingTrust generates a Bank Rec Report entry with the same amount in the Bank Balance and Cash Book columns.
You can access this report at any time at Trust Account > Bank Rec > Rec Report.
If the bank balance does not match BookingTrust’s record, a message on the screen shows the discrepancy.