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

Calculus
1.2K views

ar positive integers Evaluate T T cos nx cos nxdx Find Aria of shaded Reyich...

Mechanical Engineering
1.2K views

AERODYNAMICS 5- What is the effect of a headwind which is 20% of the landing speed on...

Advance Math
1.2K views

If a function f(x) is odd about a point, say (a,0), on the x-axis what exactly...

Physics
1.2K views

In a YDSE experiment 2 540 nm D 1m d 1 mm A thin film...

Physics
1.2K views

26 Section AB of an electrical circuit shown in the figure If C 1 F...

Basic Math
1.2K views

10 points Save Ans Anthony s Bakery wants to know which dessert is the most...

Basic Math
1.2K views

Suppose that the concentration of a bacteria sample is 30,000 bacteria per milliliter. If the...

Accounting
1.2K views

Hepburn Company compr un derecho de autor por $90,000 el 1 de enero de...

Accounting
1.2K views

which of the following items increases the basis of property received in a partly nontaxable...

Accounting
1.2K views

6. Financial Statement Analysis (4pts): Using the attached excerpts from General Mills 2020 Annual Report...

Accounting
1.2K views

High Country, Incorporated, produces and sells many recreational products. The company just opened a new...

Accounting
1.2K views

Morgenstern Ltd. has the following units and costs for the month of April. Beginning inventory,...