Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with correction to the worksheet and general journal. Both need to be correct in excel to access the next part. I cant figure

Need help with correction to the worksheet and general journal. Both need to be correct in excel to access the next part. I cant figure out where the worksheet went wrong in excel to balance it out. Help would be much appreciated THANK YOU!

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed EIT Village Production 50Sheet Legal Pad Building Blocks of Accounting .. A Financial Perspective Chart of Accounts A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. \begin{tabular}{|r|r|r|l|l|r|r|} \hline 21 & Jun 28 & 1120 & Accounts Receivable & record of revenue & 5,385.00 & \\ \hline 21 & Jun 28 & 4100 & Computer 2 Consulting record of revenue & & 5,385.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} 22 & Jun 29 & 1110 & Cash & Receive payment & 5,101.00 & \\ \hline 22 & Jun 29 & 1120 & Accounts Receivable & Receive payment & & 5,101.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|c|l|l|r|r|} \hline 23 & Jun 29 & 2101 & Accounts Payable & Payment of Computer repair & 1,115.00 & \\ \hline 23 & Jun 29 & 1110 & Cash & Payment of Computer repair & & 1,115.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 24 & Jun 29 & 5020 & Salary Expense & Receive payment & 935.00 & \\ \hline 24 & Jun 29 & 1110 & Cash & Receive payment & & 935.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 25 & Jun 30 & 5050 & Dil \& Gas Expense & oil \& gsd expense & 890.00 & \\ \hline 25 & Jun 30 & 2101 & Accounts Payable & oil \&ssd expense & & 890.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 26 & Jun 30 & 3300 & Hudson Bloom, Withdr withdrawls made & 1,600.00 & \\ \hline 26 & Jun 30 & 1110 & Cash & withdrawls made & & 1,600.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 27 & Jun 30 & 5010 & Rent Expense & Rent expense recognised & 4,600.00 & \\ \hline 27 & Jun 30 & 1140 & Prepaid Rent & Rent expense recognised & & 4,600.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} 28 & Jun 30 & 5080 & Supplies Expense & Supplies expense & 236.00 & \\ \hline 28 & Jun 30 & 1150 & Dffice Supplies & Supplies expense & & 236.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 29 & Jun 30 & 5090 & Interest Expense & interest adjustment & 1,500.00 & \\ \hline 29 & Jun 30 & 2103 & Interest Payable & interest adjustment & & 1,500.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 30 & Jun 30 & 5100 & Insurance Expense & insurance adjustment & 389.58 & \\ \hline 30 & Jun 30 & 1130 & Prepaid Insurance & insurance adjustment & & 389.58 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 31 & Jun 30 & 1120 & Accounts Receivable & Unbilled revenue & 9,250.00 & \\ \hline 31 & Jun 30 & 4100 & Computer \& Consulting Unbilled revenue & & 9,250.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 31 & Jun 30 & 1120 & Accounts Receivable & Unbilled revenue & 9,250.00 & \\ \hline 31 & Jun 30 & 4100 & Computer Consulting Unbilled revenue & & 9,250.00 \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 32 & Jun 30 & 5110 & Depreciation Expense & Depreciation expense & & \\ \hline 32 & Jun 30 & 1412 & Accum. Depr.-Building & \#PEF! & & \\ \hline 32 & Jun 30 & 1312 & Acoum. Depr.-Comput: Depreciation expense & & \\ \hline 32 & Jun 30 & 1212 & Acoum. Depr.-DFfice Eq Depreciation expense & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 33 & Jun 30 & 5020 & Salary Expense & Salary expense & 561.00 & \\ \hline 33 & Jun 30 & 2105 & Salaries Payable & Salary expense & & 561.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 34 & Jun 30 & 5090 & Interest Expense & Interest adjustment & 1,128.33 & \\ \hline 34 & Jun 30 & 2103 & Interest Payable & Interest adjustment & & 1,128.33 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 35 & Jun 30 & 4100 & Computer \& Consulting Closing revenue & 23,575.00 & \\ \hline 35 & Jun 30 & 3400 & Income Summary & Closing revenue & & 23,575.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 37 & Jun 30 & 3400 & Income Summary & Closing income Summary & 10,920.62 & \\ \hline 37 & Jun 30 & 3100 & Hudson Bloom, Capita & Closing income Summary & & 10,920.62 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|r|} \hline 38 & Jun 30 & 3100 & Hudson Bloom, Capita & Closing withdrawls & 2,400.00 & \\ \hline 38 & Jun 30 & 3300 & Hudson Bloom, Withdr. Closing withdrawls & & 2,400.00 \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2023 EIT Village Production 50Sheet Legal Pad Building Blocks of Accounting .. A Financial Perspective Chart of Accounts A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. \begin{tabular}{|r|r|r|l|l|r|r|} \hline 21 & Jun 28 & 1120 & Accounts Receivable & record of revenue & 5,385.00 & \\ \hline 21 & Jun 28 & 4100 & Computer 2 Consulting record of revenue & & 5,385.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} 22 & Jun 29 & 1110 & Cash & Receive payment & 5,101.00 & \\ \hline 22 & Jun 29 & 1120 & Accounts Receivable & Receive payment & & 5,101.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|c|l|l|r|r|} \hline 23 & Jun 29 & 2101 & Accounts Payable & Payment of Computer repair & 1,115.00 & \\ \hline 23 & Jun 29 & 1110 & Cash & Payment of Computer repair & & 1,115.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 24 & Jun 29 & 5020 & Salary Expense & Receive payment & 935.00 & \\ \hline 24 & Jun 29 & 1110 & Cash & Receive payment & & 935.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 25 & Jun 30 & 5050 & Dil \& Gas Expense & oil \& gsd expense & 890.00 & \\ \hline 25 & Jun 30 & 2101 & Accounts Payable & oil \&ssd expense & & 890.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 26 & Jun 30 & 3300 & Hudson Bloom, Withdr withdrawls made & 1,600.00 & \\ \hline 26 & Jun 30 & 1110 & Cash & withdrawls made & & 1,600.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 27 & Jun 30 & 5010 & Rent Expense & Rent expense recognised & 4,600.00 & \\ \hline 27 & Jun 30 & 1140 & Prepaid Rent & Rent expense recognised & & 4,600.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} 28 & Jun 30 & 5080 & Supplies Expense & Supplies expense & 236.00 & \\ \hline 28 & Jun 30 & 1150 & Dffice Supplies & Supplies expense & & 236.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 29 & Jun 30 & 5090 & Interest Expense & interest adjustment & 1,500.00 & \\ \hline 29 & Jun 30 & 2103 & Interest Payable & interest adjustment & & 1,500.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 30 & Jun 30 & 5100 & Insurance Expense & insurance adjustment & 389.58 & \\ \hline 30 & Jun 30 & 1130 & Prepaid Insurance & insurance adjustment & & 389.58 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 31 & Jun 30 & 1120 & Accounts Receivable & Unbilled revenue & 9,250.00 & \\ \hline 31 & Jun 30 & 4100 & Computer \& Consulting Unbilled revenue & & 9,250.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 31 & Jun 30 & 1120 & Accounts Receivable & Unbilled revenue & 9,250.00 & \\ \hline 31 & Jun 30 & 4100 & Computer Consulting Unbilled revenue & & 9,250.00 \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 32 & Jun 30 & 5110 & Depreciation Expense & Depreciation expense & & \\ \hline 32 & Jun 30 & 1412 & Accum. Depr.-Building & \#PEF! & & \\ \hline 32 & Jun 30 & 1312 & Acoum. Depr.-Comput: Depreciation expense & & \\ \hline 32 & Jun 30 & 1212 & Acoum. Depr.-DFfice Eq Depreciation expense & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|l|r|r|} \hline 33 & Jun 30 & 5020 & Salary Expense & Salary expense & 561.00 & \\ \hline 33 & Jun 30 & 2105 & Salaries Payable & Salary expense & & 561.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 34 & Jun 30 & 5090 & Interest Expense & Interest adjustment & 1,128.33 & \\ \hline 34 & Jun 30 & 2103 & Interest Payable & Interest adjustment & & 1,128.33 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 35 & Jun 30 & 4100 & Computer \& Consulting Closing revenue & 23,575.00 & \\ \hline 35 & Jun 30 & 3400 & Income Summary & Closing revenue & & 23,575.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 37 & Jun 30 & 3400 & Income Summary & Closing income Summary & 10,920.62 & \\ \hline 37 & Jun 30 & 3100 & Hudson Bloom, Capita & Closing income Summary & & 10,920.62 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r|r|r|} \hline 38 & Jun 30 & 3100 & Hudson Bloom, Capita & Closing withdrawls & 2,400.00 & \\ \hline 38 & Jun 30 & 3300 & Hudson Bloom, Withdr. Closing withdrawls & & 2,400.00 \\ \hline & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2023

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_2

Step: 3

blur-text-image_3

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

Authors: Richard Lewis, David Pendrill

5th Edition

0273622919, 978-0273622918

More Books

Students also viewed these Accounting questions