Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

hi could you do the journal entries on excel please i really need help please A. General Journal in Excel Caliso Ltd. For some years,

hi could you do the journal entries on excel please i really need help please
image text in transcribed
A. General Journal in Excel Caliso Ltd. For some years, Shawn operated a part-time web design service from home. In 2020, he went full-time with a start-up named Caliso Ltd The company recorded the following transactions in Jul 1 Jl Received $12.000 cash and $2.000 supplies from Shaun's Investment of $14.000 in his start- MP 1 Jul Purchased a $13.000 server equipment from Offical of which $11,000 was paid in cash and $2,000 on credit Paid three months' rent on a lease rental contract 56, 570 6. Jul Borrowed S24.590 through a 18-month bank loan to provide the desired business liquidity 17 Jul Paid $490 cash for a magazine advertisement 8 Jul Paid 53 740 premiums for a business Insurance policy Jul Completed 54,920 design services for YonBiz Amount is to be received within 120 days 10 Jul Paid part-time assistant for 4 weeks Salary S1 220 16 Jul Received $3,800 cash payment for business services provided to Dotcop. 17 Jul Received $5,660 cash from TriCom for design services to be provided in Oct. 20 Jul paid $160 taxes to the authorities in cash 22 Jul Received cash $1,930 from Yonbiz as partial payment for work completed on 9 Jul 23 Jul Pad 970 cash for supplies 25 Jul Paid Officely 51,730 as part of the debt incurred on 1 Jul 28 Jul Cash withdrawal 51.500 by Shawn to pay for his expense 31 Jul nsurance expired in Jus IS $330. 31 Jul Rent expired in Jul is 51.690 31 Jul Paid 5230 interest in cash to bank for the loan that the company took on 6 Jul 31 Jul Recorded depreciation of server equipment for Jul using straight-line depreciation The equipment has an estimated useful life of 40 months. The company expects to sell it for 5800 at its end of life. 31 Jol Supplies used in Jul is $890

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

18th Edition

9781119790976

Students also viewed these Accounting questions