Answered step by step
Verified Expert Solution
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!
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, 2023Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started