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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1. Calculate the current price of a $1,000 par value bond that has a coupon rate...

Finance
Q

How are the ovarian cycle, the uterine circle, and folliculogenesis all interrelated and regulated to ensure reproduction...

Medical Sciences
Q

In an essay (250-500 words), use the scenario presented above to thoroughly answer the following questions: What...

Basic Math
Q

In single slit diffraction experiment if slit width is made double of original then intensity...

Physics
Q

Given that g(x)=x-2x-6, find (g o g)(-3).

Algebra
Q

Let T VV be a linear transformation Suppose v EV and y EV satisfy T...

Algebra
Q

Roberst, which began business at the start of the current year, had the following data:...

Accounting
Q

2009 Absorption and Variable Costing Comparisons Peachtree Company manufactures peach jam. Because of bad weather,...

Accounting
Q

In each of the cases below, assume Division X has a product that can be...

Accounting
Q

its financial statements for the fiscal year P20.14 Dubois Steel Corporation, as lessee, signed...

Accounting
Q

Scenario 5.1 Obtaining Pirated Software Abroad Carol works as a computer consultant for a...

Finance
Q

3. The value of a share of stock currently selling for $100 after a 1...

Finance