Stokbeer
Jan 16, 2008, 09:08 PM
CR and CP are incomplete, when I do enter the extra details from the Bank Statement to the Cash Books and Cash Account in the ledger, the balance does not add to the balance of the reconciliation.
The balance I get from the reconciliation is 22,080. Any ideas please, or any good websites with extra learning material that would help. Thanks.
# = (tick) / entry on both sets
--- / entry in B/S only
Statement:
1 Balance b/d 19,623CR #
Interest 125CR---
Deposit 895CR---
00512 253DR---
3 Deposit 1,012CR #
4 00519 333DR---
00522 188DR #
5 Deposit 865CR #
7 Direct Debit - AA 555DR--------------------
9 00524 85DR #
00526 1,550DR #
10 Deposit 1,135CR #
13 Direct Debit - YY 675DR---
15 Deposit 789CR # (115 of this deposit was dishonoured)
00525 120DR #
18 00527 655DR #
00523 428DR #
22 Deposit 542CR #
Dishonour 115DR---
Dishonour fee 15DR---
23 Deposit 1,036CR #
25 Dividend - JJ 725CR---
28 Deposit 921CR #
30 00530 643DR #
Bank charges 25DR---
Closing Balance 22,028CR #
8,045 (total credits) - 5,640 (total debits) = 2,405 + 19,623 = 22,028CR #
Previous Month Bank Reconciliation
Credit Bal as per B/S: 19,623
Add: O/D 895
20,518
Less: U/C
00512 253
00518 690
00519 333
00521 188
1,464
Debit Bal as per C/B: 19,054
Additional Info:
Entry in B/S for 22 (dishonour) relates to a cheque included in deposit on 15 (noted on statement)
Extract of Cash Books
C/R Journal
1 Bal b/d 19,054 #
2 R $1,012 #
4 R 865 #
9 R 1,135 #
12 R 789 #
19 R 542 #
22 R 1,036 #
26 R 921 #
31 R 1,322 ----- O/D
C/P Journal
2 522 $188 #
4 523 428 #
7 524 85 #
525 120 #
526 1,550 #
14 527 655 #
17 528 815 ------ U/C
20 529 299 ------ U/C
27 530 643 #
31 531 156 ------ U/C
Hope the layout is not to confusing.
The balance I get from the reconciliation is 22,080. Any ideas please, or any good websites with extra learning material that would help. Thanks.
# = (tick) / entry on both sets
--- / entry in B/S only
Statement:
1 Balance b/d 19,623CR #
Interest 125CR---
Deposit 895CR---
00512 253DR---
3 Deposit 1,012CR #
4 00519 333DR---
00522 188DR #
5 Deposit 865CR #
7 Direct Debit - AA 555DR--------------------
9 00524 85DR #
00526 1,550DR #
10 Deposit 1,135CR #
13 Direct Debit - YY 675DR---
15 Deposit 789CR # (115 of this deposit was dishonoured)
00525 120DR #
18 00527 655DR #
00523 428DR #
22 Deposit 542CR #
Dishonour 115DR---
Dishonour fee 15DR---
23 Deposit 1,036CR #
25 Dividend - JJ 725CR---
28 Deposit 921CR #
30 00530 643DR #
Bank charges 25DR---
Closing Balance 22,028CR #
8,045 (total credits) - 5,640 (total debits) = 2,405 + 19,623 = 22,028CR #
Previous Month Bank Reconciliation
Credit Bal as per B/S: 19,623
Add: O/D 895
20,518
Less: U/C
00512 253
00518 690
00519 333
00521 188
1,464
Debit Bal as per C/B: 19,054
Additional Info:
Entry in B/S for 22 (dishonour) relates to a cheque included in deposit on 15 (noted on statement)
Extract of Cash Books
C/R Journal
1 Bal b/d 19,054 #
2 R $1,012 #
4 R 865 #
9 R 1,135 #
12 R 789 #
19 R 542 #
22 R 1,036 #
26 R 921 #
31 R 1,322 ----- O/D
C/P Journal
2 522 $188 #
4 523 428 #
7 524 85 #
525 120 #
526 1,550 #
14 527 655 #
17 528 815 ------ U/C
20 529 299 ------ U/C
27 530 643 #
31 531 156 ------ U/C
Hope the layout is not to confusing.