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...

60.1K

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

Physics
1.2K views

A piece of luggage is being loaded onto an airplane by way of an inclined conveyor...

Electrical Engineering
1.2K views

Write a term paper on free space optics?Write the problem Statement?Draw a block digram?What are the...

Psychology
1.2K views

Explain how elements of social influence may have a role in the development of the norms...

Economics
1.2K views

Part 1   (1 point) See Hint Suppose that nominal GDP was $9250000.00 in 2005 in Orange County California. In...

Economics
1.2K views

True or False? The 2017 Tax Cuts and Jobs Act will make it more costly for...

Biology
1.2K views

estio After being fed glucose a cell increases its intracellular glucose concentrations by O decreasing...

Physics
1.2K views

A uniform disc of mass m and radius R is given a linear speed vo...

Geometry
1.2K views

U Which equation represents a circle with the same radius as the circle shown but...

Calculus
1.2K views

a Po lal B sin COS tan 7 4 1 0 8 9 5 6...

Calculus
1.2K views

A paperweight is thrown straight up with an initial upward velocity of 60 meters per...

Calculus
1.2K views

5 Determine the intervals of increasing myopenmath com Determine the intervals of decreasing If an...

Accounting
1.2K views

When a contract for the purchase and sale of a business is concerned, a term...