Ok, so the Cheque Account Balance and the Bank Statement Balance need to match or have identifiable pending deposits /payments to reconcile.
Now taking your last screenshot of a reconciliation dated for July 1, it shows that the Bank Statement balance has increased from 7785.68 to 8198.68 (+413.00) yet for the same period your Cheque Account only has one transaction amounting to -187.00. This is an unexplained difference of 600.00 between the two.
So, on the Bank Statement, what transaction are there between Jun 29 & Jul 1 and why aren’t they included (posted) to the Cheque Account ?
It does, the discrepancy in values, not specific details - eg if your Bank Statement had a bank charge of 25.00, the Rec would show a balance variance of 25.00, but not that it was a bank charge.
The work through for the above Jul 1 reconciliation would be, take the Bank Statement transactions for the period of Jun 30 to Jul 1 and compare them to the transactions in the Cheque Account for the same period. Manager has listed those transactions under the reconciliation - in this case the -187.00.
But before going on, your screenshots have highlighted some other oddities which need clarifying and may assist in resolving your reconciliation issues.
In your screen shot listing the Cash Accounts:
- Undeposited funds - How is this being used ?
- Cheque Account - Large amount of Pending Withdrawals
In your screenshot showing the Cheque Account transactions:
- A couple of transaction with the account as Suspense. These are incomplete transactions