Understand the Cash Reconciliation Report
The Cash Reconciliation Report in Rillet gives you a detailed view of your bank reconciliation activity. It compares your Rillet balances with your bank balances, shows any reconciliation differences, and highlights the unmatched transactions that cause those differences. To learn how to access the report, see View the Cash Reconciliation Report.
Understand the Rillet Side
The Rillet side of the report shows all cash activity recorded in Rillet for the selected bank account and period.
Starting balance: Pulled from the prior month's ending balance. If there’s no closed month, it uses the balance from the day before the selected date.
Cash receipts: Inbound transactions matched during the selected month. Click any receipt to open the related invoice.
Cash disbursements: Outbound transactions matched during the selected month. Click any disbursement to open the related bill.
Ending balance (Rillet): Starting balance plus receipts minus disbursements.
Understand the Bank Side
The bank side shows the running total of all transactions in Rillet affecting the bank account, including manual journal entries.
Ending balance (Bank): Reflects the bank’s ending balance based on all transactions recorded in Rillet.
Reconciliation difference: The difference between the Rillet and bank ending balances.
Review Unmatched Items
The reconciliation difference is broken down into unmatched items:
Unmatched Bank Transactions
Bank transactions not matched to any bill or invoice.
These are shown by date but are not drillable.
Unmatched Manual Entries
Journal entries that affect the bank account but aren’t matched to bank transactions.
These can be clicked to view the entry.
Unmatched Expense Payments
Bills marked as paid before the transaction appeared in Rillet ("paid uncleared").
These also include payments not yet matched to a transaction.
Unmatched Invoice Payments
Similar to expense payments, but for customer invoices.
These payments were marked as received before being matched with a transaction.
Note: The report includes differences from previous periods if they haven’t been resolved, even if you filter for a specific date range.
Last updated