Question: Can you please help me create a balance sheet ? October 1 Issued check #4404 for office rent for the current month. (Debit rent expense)

 Can you please help me create a balance sheet ? October1 Issued check \#4404 for office rent for the current month. (Debitrent expense) AMOUNT: $4,080 2 Performed services for customer on account. AMOUNT:$13,500 3 Received net amount of cash on account from customer infull settlement of the account receivable from last month. AMOUNT: $12,600 4Purchased supplies on account. AMOUNT: $2,500 5 Performed services for customer and

Can you please help me create a balance sheet ?

October 1 Issued check \#4404 for office rent for the current month. (Debit rent expense) AMOUNT: $4,080 2 Performed services for customer on account. AMOUNT: $13,500 3 Received net amount of cash on account from customer in full settlement of the account receivable from last month. AMOUNT: $12,600 4 Purchased supplies on account. AMOUNT: $2,500 5 Performed services for customer and was paid cash. AMOUNT: $9,900 6 Issued check \#4405 to purchase computer equipment for cash. AMOUNT: $4,800 9 Issued check \#4406 to pay vendor for the supplies purchased on the 4 th of the month. AMOUNT: $2,500 11 Performed services for customer on account. AMOUNT: $7,000 12 Received net amount of cash on account from customer in full settlement of the account receivable from the 2nd of the month. AMOUNT: $13,500 16 Issued check \#4407 to pay salaries. AMOUNT: $6,000 23 Performed services for customer on account. AMOUNT: $8,700 28 Purchased advertising on account. AMOUNT: $1,100 31 Received net amount of cash on account from customer in full settlement of the account receivable from the 11th of the month. Amount was deposited into the bank account too late to be recorded by the bank until tomorrow. AMOUNT: $7,000 31 Issued check \#4408 to pay owner for personal withdrawal. AMOUNT: $6,700 THE CHART OF ACCOUNTS ALSO INCLUDES THE FOLLOWING ACCOUNTS: \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ ACCOUNT NAME } & \multicolumn{2}{|c|}{ Unadj. Trial Bal. } & & \multicolumn{3}{|c|}{ Adjustments } & \multicolumn{2}{|c|}{ Adjusted Trial Bal. } & \multicolumn{2}{|c|}{ Income Statement } & \multicolumn{2}{|c|}{ Balance Sheet } \\ \hline & DR & CR & & DR & & CR & DR & CR & DR & CR & DR & CR \\ \hline CASH & 62,240 & & & & & 0 & 62,240 & 0 & & & 62,240 & \\ \hline ACCOUNTS RECEIVABLE & 16,500 & & & & & 0 & 16,500 & 0 & & & 16,500 & \\ \hline ALLOWANCE FOR UNCOLLECTIBLE ACCOUNTS & & 900 & & & & 0 & & 900 & & & & 900 \\ \hline NOTES RECEIVABLE & 5,200 & & & & & 0 & 5,200 & 0 & & & 5,200 & \\ \hline SUPPLIES & 3,100 & & & 800 & A & 2,300 & 3,900 & 2,300 & & & 3,900 & 2,300 \\ \hline COMPUTER EQUIPMENT & 39,000 & & & & & 0 & 39,000 & 0 & & & 39,000 & 0 \\ \hline ACCUMULATED DEPRECIATION & & 24,300 & c & & c & 4,000 & & 28,300 & & & & 28,300 \\ \hline ACCOUNTS PAYABLE & & 1,100 & & & & 0 & & 1,100 & & & & 1,100 \\ \hline SALARY PAYABLE & & & B & & B & 2,200 & 0 & 2,200 & & & 0 & 2,200 \\ \hline OWNER'S WITHDRAWAL & 6,700 & & & & & 0 & 6,700 & 0 & & & 6,700 & 0 \\ \hline OWNER'S CAPITAL & & 61,300 & & & & 0 & & 61,300 & & 61,300 & & 61,300 \\ \hline FEE REVENUE & & 39,100 & & & & 0 & & 39,100 & & 39,100 & & 39,100 \\ \hline INTEREST INCOME & & & & & & 100 & & 0 & 100 & & & 0 \\ \hline SALARY EXPENSE & 0 & & B & 2,200 & B & 0 & 2,200 & 0 & 4,400 & & 2,200 & 0 \\ \hline RENT EXPENSE & & & & & & 0 & & 0 & 0 & & & 0 \\ \hline SUPPLIES EXPENSE & & 5,000 & A & 2,300 & A & 0 & 2,300 & 5,000 & 4,600 & 5,000 & 2,300 & 5,000 \\ \hline ADVERTISING EXPENSE & & 1,100 & & & & 0 & & 1,100 & 0 & 1,100 & & 1,100 \\ \hline DEPRECIATION EXPENSE & & & c & 4,000 & & 0 & 4,000 & 0 & 8,000 & 0 & 4,000 & 0 \\ \hline BAD DEBT EXPENSE & & & & 214 & & 0 & 214 & 0 & 428 & 0 & 214 & 0 \\ \hline MISCELLANEOUS EXPENSE & & & & 12 & & 0 & 12 & 0 & 24 & 0 & 12 & 0 \\ \hline & 132,740 & 132,800 & & 9,526 & & 8,600 & 142,266 & 141,300 & 151,792 & 141,300 & 142,266 & 141,300 \\ \hline & & & & & & & & net income: & 10,492 & & & -10492 \\ \hline & & & & & & & & & 141,300 & 141,300 & 142,266 & 130,808 \\ \hline \end{tabular} Bank Balance at Beginning of Month $26,600 Plus Deposits \begin{tabular}{llr} October & 3 & 12,600 \\ October & 5 & 9,900 \\ October & 12 & 13,500 \end{tabular} Credit Memo's: \begin{tabular}{lr} Collection of Notes Receivable & 5,200 \\ Collection of Interest on Notes Receivable & 100 \\ \hline \end{tabular} Total increases in account 41,300 Minus Checks cleared Check Number: 4404 Check Number: 4405 Check Number: 4406 Debit Memo's: Monthly Bank Fee Charges Total decreases in account Bank Balance at End of Month (4,080) (4,800) (2,500) (11,405) $56,495 Use this sheelt for the Balance Sheet October 1 Issued check \#4404 for office rent for the current month. (Debit rent expense) AMOUNT: $4,080 2 Performed services for customer on account. AMOUNT: $13,500 3 Received net amount of cash on account from customer in full settlement of the account receivable from last month. AMOUNT: $12,600 4 Purchased supplies on account. AMOUNT: $2,500 5 Performed services for customer and was paid cash. AMOUNT: $9,900 6 Issued check \#4405 to purchase computer equipment for cash. AMOUNT: $4,800 9 Issued check \#4406 to pay vendor for the supplies purchased on the 4 th of the month. AMOUNT: $2,500 11 Performed services for customer on account. AMOUNT: $7,000 12 Received net amount of cash on account from customer in full settlement of the account receivable from the 2nd of the month. AMOUNT: $13,500 16 Issued check \#4407 to pay salaries. AMOUNT: $6,000 23 Performed services for customer on account. AMOUNT: $8,700 28 Purchased advertising on account. AMOUNT: $1,100 31 Received net amount of cash on account from customer in full settlement of the account receivable from the 11th of the month. Amount was deposited into the bank account too late to be recorded by the bank until tomorrow. AMOUNT: $7,000 31 Issued check \#4408 to pay owner for personal withdrawal. AMOUNT: $6,700 THE CHART OF ACCOUNTS ALSO INCLUDES THE FOLLOWING ACCOUNTS: \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ ACCOUNT NAME } & \multicolumn{2}{|c|}{ Unadj. Trial Bal. } & & \multicolumn{3}{|c|}{ Adjustments } & \multicolumn{2}{|c|}{ Adjusted Trial Bal. } & \multicolumn{2}{|c|}{ Income Statement } & \multicolumn{2}{|c|}{ Balance Sheet } \\ \hline & DR & CR & & DR & & CR & DR & CR & DR & CR & DR & CR \\ \hline CASH & 62,240 & & & & & 0 & 62,240 & 0 & & & 62,240 & \\ \hline ACCOUNTS RECEIVABLE & 16,500 & & & & & 0 & 16,500 & 0 & & & 16,500 & \\ \hline ALLOWANCE FOR UNCOLLECTIBLE ACCOUNTS & & 900 & & & & 0 & & 900 & & & & 900 \\ \hline NOTES RECEIVABLE & 5,200 & & & & & 0 & 5,200 & 0 & & & 5,200 & \\ \hline SUPPLIES & 3,100 & & & 800 & A & 2,300 & 3,900 & 2,300 & & & 3,900 & 2,300 \\ \hline COMPUTER EQUIPMENT & 39,000 & & & & & 0 & 39,000 & 0 & & & 39,000 & 0 \\ \hline ACCUMULATED DEPRECIATION & & 24,300 & c & & c & 4,000 & & 28,300 & & & & 28,300 \\ \hline ACCOUNTS PAYABLE & & 1,100 & & & & 0 & & 1,100 & & & & 1,100 \\ \hline SALARY PAYABLE & & & B & & B & 2,200 & 0 & 2,200 & & & 0 & 2,200 \\ \hline OWNER'S WITHDRAWAL & 6,700 & & & & & 0 & 6,700 & 0 & & & 6,700 & 0 \\ \hline OWNER'S CAPITAL & & 61,300 & & & & 0 & & 61,300 & & 61,300 & & 61,300 \\ \hline FEE REVENUE & & 39,100 & & & & 0 & & 39,100 & & 39,100 & & 39,100 \\ \hline INTEREST INCOME & & & & & & 100 & & 0 & 100 & & & 0 \\ \hline SALARY EXPENSE & 0 & & B & 2,200 & B & 0 & 2,200 & 0 & 4,400 & & 2,200 & 0 \\ \hline RENT EXPENSE & & & & & & 0 & & 0 & 0 & & & 0 \\ \hline SUPPLIES EXPENSE & & 5,000 & A & 2,300 & A & 0 & 2,300 & 5,000 & 4,600 & 5,000 & 2,300 & 5,000 \\ \hline ADVERTISING EXPENSE & & 1,100 & & & & 0 & & 1,100 & 0 & 1,100 & & 1,100 \\ \hline DEPRECIATION EXPENSE & & & c & 4,000 & & 0 & 4,000 & 0 & 8,000 & 0 & 4,000 & 0 \\ \hline BAD DEBT EXPENSE & & & & 214 & & 0 & 214 & 0 & 428 & 0 & 214 & 0 \\ \hline MISCELLANEOUS EXPENSE & & & & 12 & & 0 & 12 & 0 & 24 & 0 & 12 & 0 \\ \hline & 132,740 & 132,800 & & 9,526 & & 8,600 & 142,266 & 141,300 & 151,792 & 141,300 & 142,266 & 141,300 \\ \hline & & & & & & & & net income: & 10,492 & & & -10492 \\ \hline & & & & & & & & & 141,300 & 141,300 & 142,266 & 130,808 \\ \hline \end{tabular} Bank Balance at Beginning of Month $26,600 Plus Deposits \begin{tabular}{llr} October & 3 & 12,600 \\ October & 5 & 9,900 \\ October & 12 & 13,500 \end{tabular} Credit Memo's: \begin{tabular}{lr} Collection of Notes Receivable & 5,200 \\ Collection of Interest on Notes Receivable & 100 \\ \hline \end{tabular} Total increases in account 41,300 Minus Checks cleared Check Number: 4404 Check Number: 4405 Check Number: 4406 Debit Memo's: Monthly Bank Fee Charges Total decreases in account Bank Balance at End of Month (4,080) (4,800) (2,500) (11,405) $56,495 Use this sheelt for the Balance Sheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!