Use the spreadsheet template provided to complete the following requirements. When using the spreadsheet you are required to provide the links from the General Ledger Accounts to the Live Trial Balance. 1. Link the balances of the General Ledgers to the Live Trial Balance 2. Enter the transactions into the appropriate Special Journals. 3. Important: After each transaction that particular journal should be in balance. If it is not, fix it before recording the next transaction. 4. Do the Bank Reconciliation and enter transactions as required. 5. Post (Link) the transactions from the Special Journals to the appropriate General Ledger Accounts the balances of which should flow to the Live Trial Balance. 6. Important: Posting should be done from the total of each column unless recorded in “Other Account” column. 7. Important: Post the entire journal and check that the Live Trial Balance is in balance before moving to the other journals. If it is not in balance, fix it before moving on. 8. Copy the Live Trial Balance and create a Fixed Trial Balance using Special Paste Values into your worksheet. 9. Do the adjustments into and complete the worksheet • Note well: the worksheet is a separate document. No linking is permitted from the worksheet to any of the financial statements. It is used as a checking mechanism that ensures your financial statements prepared in step 13 match the worksheet. 10. Journalise the adjustments in the General Journal and post to the General Ledgers. Check that the Live Trial Balance is in Balance ïŠ before moving to the next transaction. If it is not in balance, fix it before moving on. 11. After all adjustments have been posted the Live trial Balance should be the same as the adjusted trial balance of the worksheet. 12. Copy the Live Trial Balance worksheet and create a Fixed Trial Balance worksheet using Special Paste Values into the worksheet. 13. Use the Fixed Trial balance to help you complete a Profit & Loss statement, Statement of Partners Equity and a Balance Sheet for month of trading.
top of page
Search
Recent Posts
See All1. Estimate the costs for the four tires using an activity-based approach. (Hint: You will need to consider how the new information...
860
Background: Clinton and Jennifer Andrews live in Sydney with their two school-age children. They bought their home 15 years ago. With the...
180
Budget profit statement for sales and overheads and information for the preparation of a cash budget
Task 1: INDIVIDUAL ACTIVITY Included in the file are: a summary budget profit statement for sales and overheads and information for the...
180
bottom of page
Comentarios