Bank Reconciliation - Manual Accounting Practice Set

This page provides instructions on how to prepare a bank reconciliation statement with Manual Accounting Practice Set. It includes step-by-step instructions on identifying reconciling items and recording them in appropriate journals. The page also provides a bank reconciliation statement as an example.

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 1/8
Your progress
Completed: 50% (approximately)
Remaining pages will take: up to 8.5 hours
The time frames we provide are a guide only. It may
take you more or less time to complete each step.
Your grading
Your grading outcome (still in progress)
Awarded Total
Points (prior to this page) 295 449
Points (on this page) 177 177
Points (after this page) − 410
Total 472 1,036
Manual Accounting Practice Set
Ball-Mart, Australasian Edition 3
Feedback: Bank reconciliation
This is a feedback page. Please review this page carefully because later pages in this practice set build on the feedback
provided here. After you have reviewed your feedback page, click Continue at the bottom of this page to move on to the
next page of your practice set.
Now that you have finished recording all of the transactions for the month of June, you are required to prepare a bank
reconciliaton as at 30 June 2018.
The purpose of the bank reconciliation process is to reconcile the balance of cash shown in the company's ledger account
against the balance of cash reported in the bank statement.
Instructions for bank reconciliation
Identify any reconciling items and record the relevant reconciling items in the appropriate journals. To do this, you will
need to use:
the previous month's bank reconciliation statement, and
the current month's bank statement
Note that the general journal is not provided on this page of the practice set because you are required to
use other journals to record those reconciling items.
When you enter items into the journals, if a cheque number is not required, you need to fill the appropriate input box
with an X.
Post entries recorded in the journals to the appropriate ledger accounts according to the company's accounting policies
and procedures.
Total the Cash at Bank columns in the special journals. Record the amount in the Total row of each journal. On this web
page, you are not required to total the rest of the columns in the special journals. You will total these columns and post
them to the ledger in the next stage of the practice set.
Post the total of the Cash at Bank columns in the special journals to their corresponding ledger account. To confirm that
the posting has been performed, a posting reference is recorded in the last row of the special journals.
Prepare the bank reconciliation statement as at 30 June 2018. The bank reconciliation statement provided below may
contain more rows than required.
1)
2)
3)
4)
5)

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 2/8
All answers can be entered as positive or negative numbers as required.
Back-On-Track functionality
Please note that any answers from previous pages carried through onto this page (either on the page or in a popup
information page) have been reset, if necessary, to the correct answers. Your particular answers from previous
pages are no longer shown.
Remember:
Enter all answers to the nearest whole dollar.
When completing the journals, if a cheque number is not required, you need to fill the appropriate input box with an
X.
You are also required to apply the journals and ledgers instructions provided in previous weeks.
Before pressing the Submit answers button, we recommend that you click the Show All tab and check that all relevant
accounting records have been completed.
If you want to print this page, please read and follow the special printing information to ensure you can print the special
journals in full.
Bank Reconciliation Special Journals Subsidiary Ledgers General Ledger
Ball-Mart
Bank Reconciliation Statement
As at 30/06/2018
Balance as per bank statement: 114659 CR
Add:
deposit in transit 2077
Total 2077
116736 CR
Less:
unpresented cheque No. 606 2211
unpresented cheque No. 609 2878
unpresented cheque No. 611 6300
No.
Total 11389
Adjusted bank balance 105347 CR
Balance as per ledger account 105347 DR
Feedback
Ball-Mart
Bank Reconciliation Statement as at 30/06/2018
Balance as per bank statement: 114,659 CR
Add:
Show All

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 3/8
Interest Revenue
ARC - Croquet and Cricke
deposit in transit 2,077 2,077
116,736 CR
Less:
unpresented cheque No. 606 2,211
unpresented cheque No. 609 2,878
unpresented cheque No. 611 6,300 11,389
Adjusted bank balance 105,347 CR
Balance as per ledger account 105,347 DR
(Q=801.cashJournalsBankRec)
CASH RECEIPTS JOURNAL
Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account',
as indicated under the additional instructions above. Since all transactions in this journal affect the Cash at Bank account,
you are asked to enter the name of the appropriate account credited in these transactions into the Account column so that
the type of transaction can be determined by the name of the account entered into this column.
Date Account Post
Ref.
Debit Credit
Cash at Bank Discount
Allowed
Sales
Revenue
Accounts
Receivable
Other
Accounts
Jun 1 Bank Loan Payable 250 50,000 50,000
Jun 5 Sales Revenue X 6,752 6,752
Jun 8 ARC - Great Sports 110-1 2,441 271 2,712
Jun 12 Sales Revenue X 9,892 9,892
Jun 19 Sales Revenue X 11,920 11,920
Jun 20 ARC - Croquet and Cricket 110-6 300 300
Jun 21 ARC - Mick's Sporting Goods 110-3 2,077 2,077
Jun 26 Sales Revenue X 11,297 11,297
Jun 30 ARC - Jump Around 110-4 3,479 3,479
Jun 30 Sales Revenue X 6,752 6,752
Jun 30 X 250 0 0 0 250
Jun 30 110-6 -300 0 0 -300 0
Jun 30
Jun 30
Jun 30
Jun 30
Total 104860
Post Reference ( 100 )
CASH PAYMENTS JOURNAL
Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account',
as indicated under the additional instructions above. Since all transactions in this journal affect the Cash at Bank account,
you are asked to enter the name of the appropriate account debited in these transactions into the Account column so that
the type of transaction can be determined by the name of the account entered into this column.
Date Account Cheque
No.
Post
Ref. Debit Credit

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 4/8
Bank Charges
Accounts
Payable
Purchases Other
Accounts
Cash at Bank Discount
Received
Jun 1 Purchases 603 X 513 513
Jun 4 APC - Extreme Sports Supplies 604 210-4 1,686 1,652 34
Jun 5 APC - Good Sports 605 210-2 1,171 1,159 12
Jun 9 APC - Sports 'R Us 606 210-5 2,211 2,211
Jun 15 Wages Expense 607 516 5,432 5,432
Jun 25 APC - J. J. Spud 608 210-3 3,187 3,187
Jun 27 APC - Hike 609 210-1 2,878 2,878
Jun 29 Wages Expense 610 516 5,867 5,867
Jun 30 Salary Expense 611 545 6,300 6,300
Jun 30 X 572 0 0 7 7 0
Jun 30
Jun 30
Jun 30
Jun 30
Jun 30
Total 29206
Post Reference ( 100 )
Feedback
CASH RECEIPTS JOURNAL
Date Account Post
Ref.
Debit Credit
Cash at
Bank
Discount
Allowed
Sales
Revenue
Accounts
Receivable
Other
Accounts
Jun 1 Bank Loan Payable 250 50,000 50,000
Jun 5 Sales Revenue X 6,752 6,752
Jun 8 ARC - Great Sports 110-1 2,441 271 2,712
Jun 12 Sales Revenue X 9,892 9,892
Jun 19 Sales Revenue X 11,920 11,920
Jun 20 ARC - Croquet and Cricket 110-6 300 300
Jun 21 ARC - Mick's Sporting Goods 110-3 2,077 2,077
Jun 26 Sales Revenue X 11,297 11,297
Jun 30 ARC - Jump Around 110-4 3,479 3,479
Jun 30 Sales Revenue X 6,752 6,752
Jun 30 ARC - Croquet and Cricket 110-6 -300 -300
Jun 30 Interest Revenue 403 250 250
Total 104,860
Post reference (100)
CASH PAYMENTS JOURNAL
Cheque Post

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 5/8
Date Account No. Ref. Debit Credit
Accounts
Payable Purchases Other
Accounts
Cash at
Bank
Discount
Received
Jun 1 Purchases 603 X 513 513
Jun 4 APC - Extreme Sports Supplies 604 210-4 1,686 1,652 34
Jun 5 APC - Good Sports 605 210-2 1,171 1,159 12
Jun 9 APC - Sports 'R Us 606 210-5 2,211 2,211
Jun 15 Wages Expense 607 516 5,432 5,432
Jun 25 APC - J. J. Spud 608 210-3 3,187 3,187
Jun 27 APC - Hike 609 210-1 2,878 2,878
Jun 29 Wages Expense 610 516 5,867 5,867
Jun 30 Salary Expense 611 545 6,300 6,300
Jun 30 Bank Charges X 572 7 7
Total 29,206
Post reference (100)
(Q=803-110-4.AcctsRec4_bankRec)
SUBSIDIARY LEDGERS
Account: ARC - Jump Around
Account No. 110-4
Date Description Ref. Debit Credit Balance
May 31 Balance 3,479 DR
Jun 30 Repayment CRJ 3,479 0
Jun 30
Jun 30
Jun 30
Feedback
There are no relevant entries in the Jump Around ledger for this week.
(Q=803-110-6.AcctsRec6_bankRec)
Account: ARC - Croquet and Cricket
Account No. 110-6
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 10 Credit sale SJ 832 832 DR
Jun 20 Repayment CRJ 300 532 DR
Jun 25 Credit sale SJ 1,886 2,418 DR
Jun 30 cheque dishounered CRJ 300 0 2718 DR
Jun 30
Jun 30

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 6/8
Feedback
Account: ARC - Croquet and Cricket
Account No. 110-6
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 10 Credit sale SJ 832 832 DR
Jun 20 Repayment CRJ 300 532 DR
Jun 25 Credit sale SJ 1,886 2,418 DR
Jun 30 Dishonoured cheque CRJ 300 2,718 DR
(Q=804-100.CashAtBank_bankRec)
GENERAL LEDGER
Account: Cash at Bank
Account No. 100
Date Description Ref. Debit Credit Balance
May 31 Balance 29,693 DR
Jun 30 cash recipt CRJ 104860 0 134553 DR
Jun 30 cash payment CPJ 0 29206 105347 DR
Jun 30
Feedback
Account: Cash at Bank
Account No. 100
Date Description Ref. Debit Credit Balance
May 31 Balance 29,693 DR
Jun 30 Total from cash receipts journal CRJ 104,860 134,553 DR
Jun 30 Total from cash payments journal CPJ 29,206 105,347 DR
(Q=804-110-0.ARControl_bankRec)
Account: ARC - Accounts Receivable Control
Account No. 110
Date Description Ref. Debit Credit Balance
May 31 Balance 11,539 DR
Jun 13 Sales return from Mick's Sporting Goods GJ 2,173 9,366 DR
Jun 30
Jun 30
Jun 30
Jun 30
Feedback

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 7/8
There are no relevant entries in the Accounts Receivable Control ledger for this week.
(Q=804-201.InterestPayable_bankRec)
Account: Interest Payable
Account No. 225
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30
Jun 30
Jun 30
Feedback
There are no relevant entries in the Interest Payable ledger for this week.
(Q=804-403.InterestRevenue_bankRec)
Account: Interest Revenue
Account No. 403
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30 income CRJ 0 250 250 CR
Jun 30
Jun 30
Feedback
Account: Interest Revenue
Account No. 403
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30 Interest received from the bank CRJ 250 250 CR
(Q=804-571.InterestExpense_bankRec)
Account: Interest Expense
Account No. 571
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30
Jun 30
Jun 30
Feedback
There are no relevant entries in the Interest Expense ledger for this week.

6/7/2018 Bank reconciliation
https://www.perdisco.com/elms/qsam/html/qsam.aspx 8/8
(Q=804-572.BankCharges_bankRec)
Account: Bank Charges
Account No. 572
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30 transaction fee CPJ 7 0 7 DR
Jun 30
Jun 30
Feedback
Account: Bank Charges
Account No. 572
Date Description Ref. Debit Credit Balance
May 31 Balance 0
Jun 30 Transaction fee CPJ 7 7 DR
Manual Accounting Practice Set
Ball-Mart, Australasian Edition 3 (VBA3q)
© 2009 - 2014 Perdisco / latin /. v., learn thoroughly
http://www.perdisco.com
Terms Of Use | Privacy Policy | Thursday, June 07, 2018, 19:03