The reconciled bank balance and the trial balance cash line should agree. When they don't, it is usually one of a few causes.
The bank reconciliation proves that your books agree with the bank. The trial balance proves that debits equal credits across all accounts. They check different things, so they can disagree even when each looks right on its own. When the reconciled cash balance doesn't equal the cash line on the trial balance, the cause is usually one of these:
Export the ledger's cash account transactions and your bank statement to Excel or CSV and upload both to Reconciliation. It flags unmatched items, variances, sign mismatches and possible duplicates, and it does a no-date match by reference or account number when the files have no usable date column, which is common for trial-balance work. For the single-amount hunt, see Find My Discrepancy. The same logic runs every time, so results don't change between runs.
Upload the bank statement and the ledger cash transactions. Sheet Audit flags what doesn't line up.
Go to Reconciliation →Yes, once the reconciling items are included. If the reconciled balance and the ledger cash balance differ, something has not been booked or the two reports use different dates.
Usually not. A trial balance that doesn't balance means total debits don't equal total credits, a posting problem. A bank reconciliation difference is a separate check against external records.
If the export lists cash account transactions, yes. A trial balance with only account totals gives you one number to compare against, so you need the transaction detail from the ledger to find what's different.
Yes. When neither file has a usable date column it matches by reference or account number and amount instead.