90.2K
Verified Solution
Link Copied!
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, 2023
Answer & Explanation
Solved by verified expert