In Progress

Do some Excel Work

In this case, you will record the effects of transactions using the accrual method of accounting.

Prepare general journal entries using an Excel spreadsheet to record the transactions listed below for

the Spade Company.

Assignment Template attached below in the file name "Project Template"

Use the following chart of accounts:

Cash

Accounts receivable

Office supplies

Office equipment

Accounts payable

K. Spade, capital

K. Spade, withdrawals

Fees earned

Rent expense

Use the letters beside each transaction to identify your entries:

a. Kacy Spade, owner, invested $10,750 cash in the company.

b. The company purchased office supplies for $312 cash.

c. The company purchased $5,945 of office equipment on credit.

d. The company received $1,268 cash as fees for services provided to a customer.

e. The company paid $5,945 cash to settle the payable for the office equipment purchased in

transaction c.

f. The company billed a customer $2,279 as fees for services provided.

g. The company paid $510 cash for the monthly rent.

h. The company collected $957 cash as partial payment for the account receivable created in

transaction f.

i. Kacy Spade withdrew $1,000 cash from the company for personal use.

Instructions:

In an Excel spreadsheet, prepare journal entries a through i. Make sure that the debits equal the credits

for each journal entry. Under each journal entry, include one sentence that explains the transaction.

Skills: Data Entry, Data Processing, Excel

See more: freelance work excel vba, track work excel, contract work excel access, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

About the Employer:
( 0 reviews ) Los Angeles, United States

Project ID: #14667747

Awarded to:

MdAlamgirHoosain

Dear Sir, I have gone through your job-posting and become very eager to do the task.Because I have a team & good knowledge in the field.Please give a chance to prove my skills. Md Alamgir Relevant Skills and Experienc More

$13 USD in 0 days
(53 Reviews)
4.8

11 freelancers are bidding on average $23 for this job

avidusman

I have over 9 years of experience in accounts and finance. Let's discuss to start your assignment.

$35 USD in 1 day
(4 Reviews)
2.8
$25 USD in 1 day
(0 Reviews)
0.0
dinesheee

I'm well experienced in excel.

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
Leljack47

A proposal has not yet been provided

$25 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
uic15mca8175

A proposal has not yet been provided

$26 USD in 1 day
(0 Reviews)
0.0
SyedAhasan

hello sir, I read your job,its a easy job for me,i can do this in 100% accuracy,you can trust me sir. wait for your reply. Have a nice day. Thank you. Relevant Skills and Experience excel,Acoounting,Va Proposed Miles More

$20 USD in 1 day
(0 Reviews)
0.0
JERRINTKG

Hi sir i am new freelancer please give me a chance to do your work and i will prove myself . Relevant Skills and Experience Data entry,web scraping Proposed Milestones $10 USD - nothing

$10 USD in 1 day
(0 Reviews)
0.0