Bank Reconciliation
Match your bank statements with accounting records
Last Reconciliation: December 15, 2024 • Status: PendingSelected Bank
Commercial Bank
Account: 1234567890
Current Balance:
$45,820.50
Statement Balance:
$45,575.00
Unreconciled Items
8
Transactions pending
Needs attention
Difference Amount
$245.50
Between book and bank
Book balance is higher
Bank Reconciliation Filter
Reconciliation Summary
$45,820.50
Book Balance
$45,575.00
Bank Statement Balance
$1,250.00
Outstanding Deposits
$1,004.50
Outstanding Checks
Difference: $245.50 (Book balance is higher)
Adjusted Bank Balance
| Bank Statement Balance | $45,575.00 |
| Add: Deposits in Transit | + $1,250.00 |
| Subtotal | $46,825.00 |
| Less: Outstanding Checks | - $1,004.50 |
| Adjusted Bank Balance | $45,820.50 |
Adjusted Book Balance
| Book Balance | $45,820.50 |
| Add: Bank Charges not recorded | - $245.50 |
| Adjusted Book Balance | $45,575.00 |
Reconciled! Adjusted balances match: $45,575.00
Reconciliation Details
|
|
Date | Transaction ID | Description | Type | Amount | Status | Bank Ref | Actions |
|---|---|---|---|---|---|---|---|---|
|
|
2024-12-30 |
DEP-2024-030
Deposit |
Cash DepositFront desk cash collection |
Deposit | + $450.00 | Unreconciled | Not cleared |
|
|
|
2024-12-28 |
CHK-2024-025
Check |
Check PaymentTo Food Supplies Co. - Invoice #INV-FS-2024-045 |
Withdrawal | - $250.00 | Unreconciled | Check #1025 |
|
|
|
2024-12-31 |
BCH-2024-001
Bank Charge |
Monthly Service FeeBank maintenance charges |
Fee | - $45.50 | Unreconciled | STMT-2024-12 |
|
|
|
2024-12-20 |
TRF-2024-010
Transfer |
Online TransferTo vendor - Linen Corporation |
Transfer | - $1,850.00 | Reconciled | REF: TRX789456123 |
|
|
|
2024-12-18 |
DEP-2024-029
Deposit |
Credit Card PaymentFrom Howard Martenstyn |
Deposit | + $495.00 | Reconciled | CC: ****1234 |
|
Report Details
Bank Statement Summary
| Statement Period | December 1 - 31, 2024 |
| Statement Number | STMT-2024-12 |
| Opening Balance | $42,125.50 |
| Total Deposits | $8,450.00 |
| Total Withdrawals | $5,000.50 |
| Closing Balance | $45,575.00 |
| Statement Date | January 5, 2025 |
Reconciliation Details
| Reconciliation Period | December 1 - 31, 2024 |
| Reconciliation Date | January 6, 2025 |
| Reconciled By | Admin Johnson |
| Total Transactions | 42 |
| Reconciled Transactions | 34 |
| Unreconciled Transactions | 8 |
| Reconciliation Status | In Progress |