Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an excel file for this assignment. Make sure that you are using formulas for all calculations. Post the General journal entries below to a

image text in transcribed
Create an excel file for this assignment. Make sure that you are using formulas for all calculations. Post the General journal entries below to a ledger in Excel. PAGE 12 PR DEBIT CREDIT GENERAL JOURNAL DATE PARTICULARS 20- Nov. 1 Cash Sales Sold services to W. Mason, Sales Slip 49. 130 000 100 400 130 000 2 75 00 500 100 2 75 00 3 Advertising Expense Cash Paid Ottawa Journal for a newspaper advertisement, Cheque 15. 502 2 50 00 5 Salaries Expense Cash Paid secretary's salary, Cheque 16. 100 25 000 100 70 000 400 70 000 6 Cash Sales Painted house for M. Blais, Sales Slip 50. Note: that in the real world each account would be on a separate page. For this assignment you may place this on one spreadsheet. The account number may appear in either the top right or the top left of a ledger account. Remember to use a formula' to calculate the running balance in the excel worksheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Advanced Financial Accounting Lawrence S C Good Condition ISBN 08512

Authors: S.C. Lawrence

1st Edition

9780851215099

More Books

Students also viewed these Accounting questions