1
.xlsx
keyboard_arrow_up
School
TAFE NSW - Sydney Institute *
*We aren’t endorsed by this school
Course
FNS30322
Subject
Accounting
Date
Jan 9, 2024
Type
xlsx
Pages
11
Uploaded by ColonelRiver12870
OFFICIAL
#_x000D_
_x000D_
#
OFFICIAL
Part 5 Task 1 Prepare a bank deposit
Deposit for: BSB:
024 442
$100
Account No:
654987
$50
Account Name:
Azure Beach Finance and Accounting Services
$20
Paid in By:
Melinda Thomas
$10
No. Cheques
1
$5
Coin
Drawer
Bank
Branch
The Technology Network
AYZ
Armidale
Total
$ 500.00
OFFICIAL
#_x000D_
_x000D_
#
OFFICIAL
Credit
300.00 9-May
700.00 Cash:
1,572.45 380.00 Cheques
1.00 70.00 2,072.45 80.00 Teller:
42.45 500
Date:
Deposit Total:
Amoun
t
OFFICIAL
#_x000D_
_x000D_
#
OFFICIAL
Task 2: Organisational policies and procedures regarding banking
Refer to the Bank account policy and answer the following questions in the space provided. Each answer should be no more than 50 words. 1. What proof of lodgement will you need to keep for a bank deposit? Proof of ‘lodgement’ documents for a bank deposit includes the stamped deposit slip from the bank (which must be banked within 2 business days from receipt)
2.
You have been asked by your supervisor to bank funds for the week as the employee responsible for banking is away. What steps will you take to determine the organisational policy and industry requirements for banking and apply these to bank funds in a safe and secure manner?
Steps - Locate the organisations Policy and Procedure documents. Ask a supervisor to help if required. Follow all the steps outlined in the company Policy and Procedures documents for all tasks. Safety -
Ensure a different route and time of day is taken to the bank each time, and where possible having more than one person go.
Security -
Bank reciepts within 2 business days from receipt to reduce the amount to deposit at once. Could also recommend customers bank transfer funds to reduce cash at the office 3.
What action needs to be taken in case some entries on the bank statement do not show up in the associated cash journal?
Any entries on the bank statement that are not showing in the cash journals, must be entered into the cash journals before preparing the bank reconciliation statement.
OFFICIAL
#_x000D_
_x000D_
#
OFFICIAL
Joe Posterino
Bank Reconciliation as at 28 February 20X1
$
$
1,337.00 Add outstanding deposits:
854.00 2,191.00 Less unpresented cheques:
125359
297.00 125360
696.00 993.00 Balance as per general ledger
1,198.00 Credit bank account balance (28 February)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
lemic Calendar My MCBS Library English (en) -
ndamentals of Financial Accounting
Summer Session 12021/ACT 140/D2 / Final Examination/ AC
In a bank reconciliation statement, explain.
A. Non-sufficient-funds (NSF) check
B. What is a deposit in transit?
A BI -
mcbs.proctoring.online is sharing your screen.
Stop
11
arrow_forward
Bank Reconciliation Statements lecture
Homework #1
ZipFlyer Inc. 's cash T-Account for May shows the foliowing information:
Cash
Date
Commenis
Amount
S13,846
1.550
2,700
Date
Comments
Amount
Cheque 75
Cheque #76
Cheque 877
Cheque 78
Cheque #79
Cheque #80
Cheque #81
Cheque #82
Cheque #83
Cheque #84
Cheque #85
Cheque 486
Opening balance
Deposit
May !
May 3
May 1
May I
May 3
May 15
May 21
Миу 31
5550
875
Deposit
Deposit
Deposit
Deposit
May 4
1,256
May 7
May 10
May 13
Миу 17
May 21
May 25
May 28
May 29
May 31
4.950
3.684
2.600
3,000
1,100
486
548
3,058
1,244
983
68
175
May 31
Ending Balance
$14,619
The following comes from the company's April 2024 Bank Statement:
Date
Description
Balance Forward
Depasit
Cheque #75
Depasit
Cheque #77
NSF Cheque- W. White
Cheque #76
Cheyue #78
Bank Collection
Cheque #79
EFT - ltilities bill
Deposit
Cheque #80
Depasit
EFT- Telephone
Cheque #82
Cheque #83
Bank plan fee
Withdrawals
Deposits
Balance
$13846
15,396
14.846
17.546
16,290
15,690
April 30
Мay 2
May 3…
arrow_forward
Item2
10points
Print
Check my workCheck My Work button is now enabled3
Item 2
Use the following bank statement and T-account to prepare the May 31 bank reconciliation.
BANK STATEMENT
Date
Checks
Deposits
Other
Balance
May 1
$ 560
May 4
#2
$ 100
$ 140
600
May 12
#4
190
NSF check
$ 140
270
May 28
#5
110
160
May 30
#6
105
560
615
May 31
#8
145
Service charge
95
375
Cash (A)
Debit
Credit
May 1
560
May 3
140
100
May 3 #2
100
May 4 #3
190
May 8 #4
110
May 11 #5
105
May 21 #6
May 29
560
115
May 29 #7
May 30
330
145
May 30 #8
May 31
725
arrow_forward
Ad
JuSte d
cosn
Cash balance per bank $4,500
Outstanding checks $200
Deposits in transit $1,000
Credit memo for interest $50
Bank service charge $25
arrow_forward
Please answer letter B
arrow_forward
Use the following bank statement and T-account to identify outstanding deposits that should be included in the May 31 bank
reconciliation.
Date
May 11
May 4
May 12
May 28,
May 30
May 31
May 11
May 3
May 29
May 30
May 31
#2
#4
#5
#6
#8
Debit
ESCUCC
Outstanding Deposits
Checks
$ 10
100
20
15
55
Cash (A)
200
50
200
150
305
BANK STATEMENT
Deposits
$50
200
NSF check
Other
Service charge
Credit
10 May 3 #2
70 May 4 #3
100 May 884
20 May 11 #5
15 May 21 #61
25 May 29 87
55 May 30 8
$50
5
Balance
$ 200
240
90
70
255
195
arrow_forward
e - Prod x
Module 8 Assessments - ACG20
* CengageNOWv2 | Online teachir
ngagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
eBook
Show Me How
Entries for Bank Reconciliation
The following data were accumulated for use in reconciling the bank account of Mathers Co. for July:
1. Cash balance according to the company's records at July 31, $32,110.
2. Cash balance according to the bank statement at July 31, $31,350.
3. Checks outstanding, $2,870.
4. Deposit in transit, not recorded by bank, $4,150.
5. A check for $170 in payment of an account was erroneously recorded in the check register as $710.
6. Bank debit memo for service charges, $20.
Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge
a. July 31 Cash
Accounts Payable v
b. July 31 Miscellaneous Expense v
Cash v
Feedback
Check My Work
Keep in mind that the company needs to journalize any adjusting items in the company section…
arrow_forward
QUESTION 8
You are provided with information relating to Umdoni Stores.
The following information appeared in the Bank Reconciliation Statement of Umdoni Stores on 30 September 20.19:
Balance per bank statement
R5 000 Debit
7.
An EFT payment made by a receivable for R4 300 on 31
October 20.19 appeared in the bank statement but not in the
Balance per Cash Book
R6 500 credit
October Cash Book.
Outstanding deposit dated 30 September 20.19
R20 500
On comparing the September bank Reconciliation statement, the October bank statement and the Cash Book for October,
the following was noted:
To reconcile the balance of the Cashbook with the balance of the Bank statement on 31 October, the R4 300 deposit (no. 7)
must be recorded as follows:
In the debit column of the Bank reconciliation statement as R4 300
O In the credit column of the Bank reconciliation statement as R4 300
Not recorded in the Bank account or the Bank reconciliation statement
On the debit side of the Bank account as R4 300
On…
arrow_forward
Correct amount of cash in bank to be presented in the balance sheet
arrow_forward
Question is attached in the screenshot
greatly appreciate the help
thank you
uye
reye
arrow_forward
Calculator
chapter 8
eBook
The following June 30 bank reconciliation was prepared for Poway Co.
Poway Co.
Bank Reconciliation
For the Month Ended June 30
$16,185
Cash balance according to bank statement
Add outstanding checks:
$575
No. 1067
470
1106
1.050
1110
910
3,005
1113
$19,190
6,600
Deduct deposit of June 30, not recorded by bank
512,590
Adjusted balance
$8,985
Cash balance according to company's records
Addı Proceeds of note collected by banki
Principal
$6,000
Interest
300
$6,300
Service charges
15
6,315
$15.300
0685
5,400
Deduct: Check returned because of Insufficient funds
Error in recording June 17 deposit of S7.150 as 31,750
6,290
s 9,010
Adjusted belance
a. Identfy the errors in the above bank reconci lation.
Check My Work
Assignment Score: 45.08%
Type here to search
arrow_forward
Please kindly help me with the following question
arrow_forward
Question 25
December 3, you received your bank statement showing a balance of $5,055.06. Your
checkbook shows a balance of $5,221.98. Outstanding checks are $934.22, $1,579.99, and
$1,112.45. The account earned interest of $146.05. Deposits in transit amount to $3,931.63,
and there is a service charge of $8.00. Calculate the reconciled balance.
Use the following format on a separate sheet of paper to calculate the adjusted checkbook
balance and adjusted statement balance. Respond with the adjusted amount only. There is
no need to provide the reconciliation on the assignment or space provided.
CHECKBOOK BALANCE
Add:
Interest Earned & Other
Credits
SUBTOTAL
Deduct:
Services Charges &
Other Debits
ADJUSTED CHECKBOOK
BALANCE
STATEMENT BALANCE
Add:
Deposits in Transit
SUBTOTAL
Deduct
Outstanding Checks
ADJUSTED STATEMENT
BALANCE
arrow_forward
BANK STATEMENT
Date
Checks
Deposits
Other
Balance
$ 48,000
40, 380
67,830
53,930
৪9,938
৪৪, 978
88,470
88,520
88,370
Dec. 1
$ 7,620
550 $28, 0e
13,900
11
17
23
36, e00
26
960
30
19,200
19, e00
NSF*
$300
Interest earned
Service charge
31
50
31
150
NSF check from J. Left, a customer.
Cash (A)
Dec. 1 Balance
48, 000
Deposits
Checks written during December:
7,620
550
28, e00
36, 000
19,000
13,e00
Dec. 11
23
13,900
960
30
31
150
19, 200
4,500
Dec. 31 Balance
97,128
There were no deposits in transit or outstanding checks at November 30.
4. Prepare any journal entries that the company should make as a resuit of the bank reconciliatio
transaction/event, select "No Journal Entry Required" In the first account fleld.)
View transaction list
Journal entry worksheet
B C D E
A
Record the interest of $50 received from the bank.
Note: Enter debits before credits.
Transaction
General Journal
Debit
Credit
1
Record entry
Clear entry
View general journal
arrow_forward
vnt.2
arrow_forward
Week 3 Bank Reconciliation Homework 2
PR.05.01
PR.05.03
Hide or show questions
Progress:2/2 items
eBook
Bank Reconciliation and Entries
The cash account for Highlander Diamond Co. on April 1, 20Y5, indicated a balance of $35,400. During April, the total cash deposited was $120,255, and checks written totaled $109,200. The bank statement indicated a balance of $60,927 on April 30, 20Y5. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:
Checks outstanding totaled $21,450.
A deposit of $13,913, representing receipts of April 30, had been made too late to appear on the bank statement.
A check for $710 had been incorrectly charged by the bank as $170.
A check for $220 returned with the statement had been recorded by Highlander Diamond Co. as $2,200. The check was for the payment of an obligation to Dirt Dog Inc. on account.
The bank had collected for Highlander Diamond $6,480 on a…
arrow_forward
My Transactions
Deposits
Withdrawals
Balance
T
Success In-process
Refund
Failed
Withdraw is usually processed in minutes
04/13/2024
d012404131907201959881
EO
Copy
BANK
07:07 pm
In-Payment
1000.00
04/11/2024
d012404111534241952032
BANK
Success
Copy
Need help with this order? Tap to contact us.
03:34 pm
509.00
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- lemic Calendar My MCBS Library English (en) - ndamentals of Financial Accounting Summer Session 12021/ACT 140/D2 / Final Examination/ AC In a bank reconciliation statement, explain. A. Non-sufficient-funds (NSF) check B. What is a deposit in transit? A BI - mcbs.proctoring.online is sharing your screen. Stop 11arrow_forwardBank Reconciliation Statements lecture Homework #1 ZipFlyer Inc. 's cash T-Account for May shows the foliowing information: Cash Date Commenis Amount S13,846 1.550 2,700 Date Comments Amount Cheque 75 Cheque #76 Cheque 877 Cheque 78 Cheque #79 Cheque #80 Cheque #81 Cheque #82 Cheque #83 Cheque #84 Cheque #85 Cheque 486 Opening balance Deposit May ! May 3 May 1 May I May 3 May 15 May 21 Миу 31 5550 875 Deposit Deposit Deposit Deposit May 4 1,256 May 7 May 10 May 13 Миу 17 May 21 May 25 May 28 May 29 May 31 4.950 3.684 2.600 3,000 1,100 486 548 3,058 1,244 983 68 175 May 31 Ending Balance $14,619 The following comes from the company's April 2024 Bank Statement: Date Description Balance Forward Depasit Cheque #75 Depasit Cheque #77 NSF Cheque- W. White Cheque #76 Cheyue #78 Bank Collection Cheque #79 EFT - ltilities bill Deposit Cheque #80 Depasit EFT- Telephone Cheque #82 Cheque #83 Bank plan fee Withdrawals Deposits Balance $13846 15,396 14.846 17.546 16,290 15,690 April 30 Мay 2 May 3…arrow_forwardItem2 10points Print Check my workCheck My Work button is now enabled3 Item 2 Use the following bank statement and T-account to prepare the May 31 bank reconciliation. BANK STATEMENT Date Checks Deposits Other Balance May 1 $ 560 May 4 #2 $ 100 $ 140 600 May 12 #4 190 NSF check $ 140 270 May 28 #5 110 160 May 30 #6 105 560 615 May 31 #8 145 Service charge 95 375 Cash (A) Debit Credit May 1 560 May 3 140 100 May 3 #2 100 May 4 #3 190 May 8 #4 110 May 11 #5 105 May 21 #6 May 29 560 115 May 29 #7 May 30 330 145 May 30 #8 May 31 725arrow_forward
- Ad JuSte d cosn Cash balance per bank $4,500 Outstanding checks $200 Deposits in transit $1,000 Credit memo for interest $50 Bank service charge $25arrow_forwardPlease answer letter Barrow_forwardUse the following bank statement and T-account to identify outstanding deposits that should be included in the May 31 bank reconciliation. Date May 11 May 4 May 12 May 28, May 30 May 31 May 11 May 3 May 29 May 30 May 31 #2 #4 #5 #6 #8 Debit ESCUCC Outstanding Deposits Checks $ 10 100 20 15 55 Cash (A) 200 50 200 150 305 BANK STATEMENT Deposits $50 200 NSF check Other Service charge Credit 10 May 3 #2 70 May 4 #3 100 May 884 20 May 11 #5 15 May 21 #61 25 May 29 87 55 May 30 8 $50 5 Balance $ 200 240 90 70 255 195arrow_forward
- e - Prod x Module 8 Assessments - ACG20 * CengageNOWv2 | Online teachir ngagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false eBook Show Me How Entries for Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: 1. Cash balance according to the company's records at July 31, $32,110. 2. Cash balance according to the bank statement at July 31, $31,350. 3. Checks outstanding, $2,870. 4. Deposit in transit, not recorded by bank, $4,150. 5. A check for $170 in payment of an account was erroneously recorded in the check register as $710. 6. Bank debit memo for service charges, $20. Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge a. July 31 Cash Accounts Payable v b. July 31 Miscellaneous Expense v Cash v Feedback Check My Work Keep in mind that the company needs to journalize any adjusting items in the company section…arrow_forwardQUESTION 8 You are provided with information relating to Umdoni Stores. The following information appeared in the Bank Reconciliation Statement of Umdoni Stores on 30 September 20.19: Balance per bank statement R5 000 Debit 7. An EFT payment made by a receivable for R4 300 on 31 October 20.19 appeared in the bank statement but not in the Balance per Cash Book R6 500 credit October Cash Book. Outstanding deposit dated 30 September 20.19 R20 500 On comparing the September bank Reconciliation statement, the October bank statement and the Cash Book for October, the following was noted: To reconcile the balance of the Cashbook with the balance of the Bank statement on 31 October, the R4 300 deposit (no. 7) must be recorded as follows: In the debit column of the Bank reconciliation statement as R4 300 O In the credit column of the Bank reconciliation statement as R4 300 Not recorded in the Bank account or the Bank reconciliation statement On the debit side of the Bank account as R4 300 On…arrow_forwardCorrect amount of cash in bank to be presented in the balance sheetarrow_forward
- Question is attached in the screenshot greatly appreciate the help thank you uye reyearrow_forwardCalculator chapter 8 eBook The following June 30 bank reconciliation was prepared for Poway Co. Poway Co. Bank Reconciliation For the Month Ended June 30 $16,185 Cash balance according to bank statement Add outstanding checks: $575 No. 1067 470 1106 1.050 1110 910 3,005 1113 $19,190 6,600 Deduct deposit of June 30, not recorded by bank 512,590 Adjusted balance $8,985 Cash balance according to company's records Addı Proceeds of note collected by banki Principal $6,000 Interest 300 $6,300 Service charges 15 6,315 $15.300 0685 5,400 Deduct: Check returned because of Insufficient funds Error in recording June 17 deposit of S7.150 as 31,750 6,290 s 9,010 Adjusted belance a. Identfy the errors in the above bank reconci lation. Check My Work Assignment Score: 45.08% Type here to searcharrow_forwardPlease kindly help me with the following questionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning