Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. using excel to prepare a bank reconciliation probl

Using Excel to Prepare a Bank Reconciliation PROBLEM The following information relates to Ceilo Limited's...

70.2K

Verified Solution

Question

Accounting

Using Excel to Prepare a Bank Reconciliation
PROBLEM
The following information relates to Ceilo Limited's Cash account.
Reconciled cash balance from
June's bank reconciliation
Amounts from the general ledger:
July cash receipts
July cash payments
Amounts from the July bank statement:
Balance, July 31
Outstanding cheques
Deposit in transit
EFT collections on account that were not yet recorded on the books
NSF cheque
NSF fee
Bank service charge
$18,920
21,700
24,300
19,260
3,630
1,450
2,170
1,270
50
90
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work area as indicated.
Prepare the necessary journal entries required on July 31 for Ceilo.
Cash balance per bank
Add: Deposits in transit
Less: Outstanding cheques
Reconciled cash balance per bank
Cash balance per books
Add: EFT collections on account
Less: NSF cheque and fee
Reconciled cash balance per books
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

People say same-sex marriage devalues the traditional marriage. What is your opinion on the issue?

Psychology
Q

Case 4-1 Toyota Motor Corporation Toyota Motor Corporation is a leading, global manufacturer of motor vehicles. It...

General Management
Q

es Required information Cash flows from operating activities FORTEN COMPANY Statement of Cash Flows For...

Basic Math
Q

A 400-lb cable is 250 feet long and hangs vertically from the top of abuilding.How...

Basic Math
Q

Find all the first and second order partial derivatives of f x y 8 sin...

Calculus
Q

Dividends Per Share Windborn Company has 10,000 shares of cumulative preferred 2% stock, $100 par...

Accounting
Q

explain the issues relating to the fair value hierarchy measurement (IFRS13)?

Accounting
Q

1) Suppose you decide to purchase a 1-year zero-coupon bond today and alsocontract today to...

Accounting
Q

Based on this data info: Task: Analyzed data and respond the following questions: ...

Accounting
Q

Los dividendos se convierten en un pasivo de una corporacin: a. En la fecha...

Accounting
Q

The income statement, balance sheets, and additional information for Video Phones, Inc., are provided. ...

Accounting
Q

for investing activities and financing activities Blossom...

Accounting