USA Finding cash balance per books from bank reconciliation

Joined
May 11, 2012
Messages
7
Reaction score
0
I'm in my first accounting class and have a take home test and one of the questions covers material we have yet to talk about in class, and there are no examples on the book. The questions is finding the pre adjusted cash balance per the company using information from the bank statement. The reconciling information is as followed:

Cash balance per bank, end of month- $17,000
Note receivable collected by bank- $ 4,800
Outstanding checks- $ 6,500
Deposits-in-transit- $ 3,000
Bank Service Charge- $ 50
NSF check- $ 2,300


I don't really want the answer, but more how to find the answer to the question. I feel like for some reason this should be obvious to me, but I keep staring at the problem and draw a blank and am not sure where to even start with it.:confused:
 

Triest123

VIP Member
Joined
Feb 12, 2012
Messages
269
Reaction score
51
I'm in my first accounting class and have a take home test and one of the questions covers material we have yet to talk about in class, and there are no examples on the book. The questions is finding the pre adjusted cash balance per the company using information from the bank statement. The reconciling information is as followed:

Cash balance per bank, end of month- $17,000
Note receivable collected by bank- $ 4,800
Outstanding checks- $ 6,500
Deposits-in-transit- $ 3,000
Bank Service Charge- $ 50
NSF check- $ 2,300


I don't really want the answer, but more how to find the answer to the question. I feel like for some reason this should be obvious to me, but I keep staring at the problem and draw a blank and am not sure where to even start with it.:confused:
=> A bank reconciliaton statement is mainly used to explain the "time difference"
between the month-ended bank balance on the company's record and that on the
bank statement.

When comparing with the Bank Statement, you need to identify the items
as shown on the bank statements whether they are "adjusted items" (i.e. need to
adjust the company's record) or "non-adjusted items" (i.e. the "time difference" items -
no need to adjust the company's record)

1. Note receivable collected by bank $ 4,800
=> It is an adjusted item
The company omit to record this cash receipts on the company's record.

2. Outstanding checks $ 6,500
=> It is a non-adjusted item.
(The outstanding checks are also called the "Unpresented checks)
The company had issued the checks to their creditors for settling the trade debts
or for the payment of expenses and recorded them in the company's record.
However, the creditors did not deposit the checks into their banks immediately
upon receiving from the Company. So the Company's bank statement do not reflect
such check payments as they have not yet been presented by the Bank.
Whether this check payments reflect on the bank statement is the queston
of time (i.e. when will the creditor deposit the checks into their banks)

3. Deposits-in-transit $ 3,000
=> It is a non-adjusted item.
Such deposit will reflect on the bank statement is only the question of time
(i.e. the time difference)

4. Bank Service Charge $50
=> It is an adjusted item.
The company omit to record this cash payment in the company's record.

5. NSF check $2,300
=> It is an adjusted item.
NSF check is the returned check (or the dishonoured check) as there is insufficient
fund in the customer's bank account.
The Company's record has to be adjusted so as to reverse the cash receipts
which was previously recorded upon receiving this check (which is now proved to be
"dishonoured")


Your question requires you to find out the "pre-adjusted" cash balance per the
company from the Bank Statement, the approach is

1. add back the "non-adjusted" items (as shown on the bank statement) to the
bank balance per bank statement to find out the adjusted cash balance per
the company

2. add back the adjusted items as shown on the balance sheet to the adjusted
cash balance to find out the pre-adjusted cash balance per the company

Try to work out the answer by yourself !!!!

(p.s. the answer is $11,050)
 
Last edited:
Joined
May 11, 2012
Messages
7
Reaction score
0
Thank you very much for explaining this to me. I asked my instructor about this and he refused to give me any sort of help or point me in the right direction at all, while also admitting it wasn't something we really talked about or covered at all. Your help is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
11,631
Messages
27,576
Members
21,373
Latest member
datanalyticscourse

Latest Threads

Top