Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. liberation sans 12 aa h wrap led ten paste..

Liberation Sans 12 AA H Wrap led Ten Paste...

90.2K

Verified Solution

Question

Accounting

Liberation Sans 12
AA
H
Wrap led
Ten
Paste
B
I W
A
Merge & Center
5-%952
Condo Femal
Clipboard
Font
Alignment
Hunter
A1
fx
Function: SUM; Formula: Add, Subtract; Cell Referencing:
E D
F C
1 Function: SUM: Formula: Add, Subtract; Cell Referencing
BE7.10 Using Excel to Prepare a Bank Reconciliation
4
PROBLEM
5 The following information relates to Southco Limited's Cash
6 account.
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 ares as
indicated
7
Prepare the necessary journal entries required on July 31 for Southco
10
11
Add:
12
13
Less
14
Reconciled cash balance from
June's bank reconciliation
$ 18,920
Amounts from the general ledger July cash receipts
21,700
July cash payments
24,300
Amounts from the July bank statement: Balance, July 31)
19,260
Outstanding cheques
3,6301,450
Deposit in transit
EFT collections on account that were not yet recorded on the books
2.170
NSF cheque
1.27050
NSF fee
Bank service charge
90
15
16
17
Add:
18
19
Less: Bank service charge
20
21
22
23
26
27
211

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

Advance Math
1.2K views

Brooklyn Inc. offers boat tours down the Hudson River. The company has signed a lease for...

Biology
1.2K views

For each acronym, indicate if it’s either a technique, a molecule or a cellular/molecular event Note: If...

Biology
1.2K views

What is a scientific definition for evolution? A. how modern organisms descended from older organisms...

Basic Math
1.2K views

onsider the mathematical system indicated by the table Assume that the associative property holds for...

Basic Math
1.2K views

Which of the following transformations are linear 0 A B PE 91 7 C Y2...

Algebra
1.2K views

6 T 7 y 2 2 3 4 6 10 12 F14 16 18 2...

Accounting
1.2K views

Dawrmart is an intemational retai store. Drwmarts mansgees are considening implementing...

Accounting
1.2K views

Machinery purchased for $66,600 by Whispering Co. in 2016 was originally estimated to...

Accounting
1.2K views

Which does NOT occur during the budget facilitation and control process phase? Communicating organization...

Accounting
1.2K views

Given the financial statements below for Dragonfly Enterprises, what is the external financing...

Accounting
1.2K views

Harmon comes to you to help filling return this year because he received a firm...

Accounting
1.2K views

5. Describe the main features or statements in an audit report. 6. What is PCAOB's...