Question
The interactive assignment is designed to provide introductory accounting students with an overview of the practical skills essential to financial accounting, through the completion of
The interactive assignment is designed to provide introductory accounting students with an overview of the practical skills essential to financial accounting, through the completion of a one month accounting cycle for a fictional business. This interactive assignment will expose you to the accounting transactions (both external and internal) in business, and the accounts used in the General Journals and General Ledger.To assist with understanding the accounting cycle and the information given, this interactive assignment is intended to be completed under the guidance of your tutor. The interactive assignment consists of NINE weeks' work from Week 4 to Week 12, which is worth 10% of your overall grade in ACCG100.
Introduction to the fictional business (FlixCity) is provided at the end of this information pack. From Week 4 to Week 12, additional information about the business along with the task requirements will be provided on iLearn. You will be given 15 minutes in each week's tutorial to seek advice and guidance from your tutor on completing the task requirements. The interactive assignment is undertaken in Excel. Thus, you are required to attend the class with your ELECTRONIC DEVICE (i.e. laptop or tablet) from Week 4 to Week 12 which enables you to undertake and save your work in Excel.
Student ID: FlixCity & Gaming General Journal for July 2016 Date Day Month Jnl Ref Account & Journal Details JOURNAL TOTALS Entries Dr Cr HINTS: 1 Journals should be prepared in the same sequence as the tr 2 Journal Reference Numbers should correspond to the transa 3 When there are multiple accounts required for debit or credit ascending account number order; 4 Do not enter $ signs & do not round amounts - express value 5 Do not leave blank lines between journals; NB: Take care with your journal entries. If you select the inc your T-Accounts will be wrong when you post your entries to incorrect $ values. 0.00 0.00 he same sequence as the transactions are presented; uld correspond to the transaction numbers; s required for debit or credit entries within a journal, ensure they appear in ; nd amounts - express values in dollars & cents; journals; entries. If you select the incorrect accounts for your transaction journals, then hen you post your entries to them & your 10-Column Worksheet will not accept Student ID: 0 ASSET ACCOUNTS 100 - Cash at Bank Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 130 - Prepaid Advertising Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 140 - Prepaid Insurance Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 160 - Building Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 170 - Equipment Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 LIABILITY ACCOUNTS 200 - Accounts Payable Date 2016 Balance c/d (difference) TOTAL Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 220 - Interest Payable Date 2016 Explanation Balance c/d (difference) TOTAL Amount Date 2016 0.00 0.00 TOTAL Balance b/d 240 - Wages Payable Date 2016 Explanation Balance c/d (difference) Amount Date 2016 0.00 0.00 TOTAL Balance b/d TOTAL EQUITY ACCOUNTS 300 - Nicholas Robbins, Capital Date 2016 Explanation Balance c/d (difference) Amount Date 2016 0.00 0.00 TOTAL Balance b/d TOTAL REVENUE ACCOUNTS 400 - Sales - Cinema Date Explanation Amount Date 2016 Explanation Balance c/d (difference) TOTAL Amount 2016 0.00 0.00 TOTAL Balance b/d 402 - Sales - Candy Bar Date 2016 Explanation Balance c/d (difference) Amount Date 2016 0.00 0.00 TOTAL Balance b/d TOTAL EXPENSE ACCOUNTS 600 - Accounting Fees Date 2016 Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 TOTAL Balance b/d 602 - Candy Bar Expense Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 604 - Depreciation Expense - Building Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 608 - Utilities Expense Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 610 - Insurance Expense Date 2016 TOTAL Balance b/d Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 612 - Leasing Expense - Cinema Seating & Screen Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 614 - Licensing Expense - Nintendo Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 618 - Wages Expense Date 2016 Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 TOTAL Balance b/d PROFIT & LOSS SUMMARY 800 - P&L Summary Account Date 2016 Explanation Amount Date 2016 TOTAL Balance c/d (difference) 0.00 TOTAL Balance b/d 0.00 nk Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d tising Explanation Amount 0.00 0.00 ance Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 165 Explanation Amount 0.00 0.00 Date 2016 Balance c/d (difference) TOTAL nt 175 - A Explanation Amount 0.00 0.00 Date 2016 Balance c/d (difference) TOTAL yable Explanation Amount Date 2016 Balance c/d (difference) 0.00 0.00 TOTAL able Explanation Amount 0.00 0.00 Date 2016 Balance c/d (difference) TOTAL ble Explanation Amount Date 2016 Balance c/d (difference) 0.00 0.00 TOTAL s, Capital Explanation Amount 0.00 0.00 Date 2016 TOTAL Balance b/d ma Explanation Amount Date Explanation Amount 0.00 0.00 2016 Balance c/d (difference) TOTAL y Bar Explanation Amount 0.00 0.00 Fees Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d pense 603 Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d se - Building Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d ense Explanation Amount 0.00 0.00 pense Explanation Amount Date 2016 0.00 0.00 Seating & Screen TOTAL Balance b/d 613 - Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d - Nintendo Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d Date 2016 TOTAL Balance b/d nse Explanation Amount 0.00 0.00 Account Explanation Amount 0.00 0.00 110 - Accounts Receivable Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 150 - Land Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 165 - Accumulated Depreciation - Building Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 175 - Accumulated Depreciation - Equipment Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 210 - Unearned Revenue Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 230 - Loan Payable Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 250 - Utilities Payable Explanation Amount Date 2016 0.00 0.00 TOTAL Balance b/d 301 - Nicholas Robbins, Drawings Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 401 - Sales - Gaming Explanation Amount Date Explanation Amount 2016 0.00 0.00 TOTAL Balance b/d 601 - Advertising Expense Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 603 - Computer Consumables Expense Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 605 - Depreciation - Equipment Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 611 - Interest Expense Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 613 - Leasing Expense - Gaming Furniture Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 615 - Licensing Expense - Sony Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 617 - Stationery & Office Expense Explanation Amount Date 2016 Balance c/d (difference) 0.00 TOTAL 0.00 ceivable Explanation Amount Instructions: 1. Entries must be posted to the T-Accounts in date 2. Do not leave blank lines between entries NB: Take care with posing your journal entries. If yo your journals, then your T-Accounts will be wrong w 10-Column Worksheet will not accept incorrect $ val 0.00 0.00 Explanation Amount 0.00 0.00 iation - Building Explanation Amount 0.00 0.00 ation - Equipment Explanation Amount 0.00 0.00 evenue Explanation Amount 0.00 0.00 able Explanation Amount 0.00 0.00 yable Explanation Amount 0.00 0.00 s, Drawings Explanation Amount 0.00 0.00 ming Explanation Amount Explanation Amount 0.00 0.00 Expense Explanation Amount 0.00 0.00 ables Expense Explanation Amount 0.00 0.00 Equipment Explanation Amount 0.00 0.00 pense Explanation aming Furniture Amount 0.00 0.00 Explanation Amount 0.00 0.00 nse - Sony Explanation Amount 0.00 0.00 ce Expense Explanation Amount 0.00 0.00 posted to the T-Accounts in date order k lines between entries posing your journal entries. If you have selected the incorrect accounts for our T-Accounts will be wrong when you post your entries to them & your et will not accept incorrect $ values. Fill Fields Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul 15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 25-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul Explanation Balances P&L Summary Explanation Opening Balance ASSETS Balance b/d Opening Balance ASSETS Cash at Bank Accounts Receivable Prepaid Advertising Prepaid Insurance Land Building Accumulated Depreciation - Building Equipment - computer/console/candybar/projector Accumulated Depreciation - Equipment LIABILITIES Accounts Payable Unearned revenue Cash at Bank Balance c/d (difference) Accounts Receivable Prepaid Advertising Prepaid Insurance Land Building Accumulated Depreciation - Building Equipment - computer/console/candyba Accumulated Depreciation - Equipment LIABILITIES Accounts Payable Unearned revenue Interest Payable & Loan Payable Utilities Payable Wages Payable EQUITY Nicholas Robbins, Capital Nicholas Robbins, Drawings Interest Payable Loan Payable - principal due May 2030 Wages Payable Utilities Payable EQUITY Nicholas Robbins, Capital REVENUE Sales - Cinema Sales - Gaming Sales - Candy Bar Nicholas Robbins, Drawings REVENUE Sales - Cinema Sales - Gaming EXPENSES Accounting Fees Advertising Expense Candy Bar Expense Computer Consumables Expense Depreciation Expense - Building Depreciation Expense - Equipment Utilities Expense Insurance Expense Sales - Candy Bar EXPENSES Accounting Fees Advertising Expense Candy Bar Expense Computer Consumables Expense Depreciation Expense - Building Depreciation Expense - Equipment Utilities Expense Interest Expense Leasing Expense - cinema seating/screen Leasing Expense - gaming furniture Licensing Expense - Nintendo Licensing Expense - Sony Stationery & Office Supplies Expense Wages Expense Insurance Expense Interest Expense Leasing Expense - cinema seating/scree Leasing Expense - gaming furniture Licensing Expense - Nintendo Licensing Expense - Sony Stationery & Office Supplies Expense Wages Expense P&L Summary P&L Summary Closing off Revenue Closing off Expenses Closing off P&L Summ Close to P&L Summ Closing off Drawings Adj - Advertising expired Adj - Deposits earned Adj - Depreciation recorded Adj - Insurance expired Adj - Interest accrued mary Explanation ed Depreciation - Building - computer/console/candybar/projector ed Depreciation - Equipment ble - principal due May 2030 obbins, Capital obbins, Drawings Consumables Expense on Expense - Building on Expense - Equipment pense - cinema seating/screen pense - gaming furniture Expense - Nintendo Expense - Sony & Office Supplies Expense Student ID: FlixCity & Gaming General Journal for July 2016 Date Day Jnl Ref Account & Journal Details Month JOURNAL TOTALS 0 Entries Dr Cr HINTS: 1 Journals should be prepared in the same sequence as the adjustm 2 Journal Reference Numbers should correspond to the adjustment 3 4 5 When there are multiple accounts required for debit or credit entri appear in ascending account number order; Do not enter $ signs & do not round amounts - express values in d Do not leave blank lines between journals; NB: Take care with your journal entries. If you select the incorrec journals, then your T-Accounts will be wrong when you post your Column Worksheet will not accept incorrect $ values. 0.00 0.00 prepared in the same sequence as the adjustments are presented; umbers should correspond to the adjustment numbers; ple accounts required for debit or credit entries within a journal, ensure they account number order; & do not round amounts - express values in dollars & cents; nes between journals; our journal entries. If you select the incorrect accounts for your adjusting -Accounts will be wrong when you post your entries to them & your 10will not accept incorrect $ values. Fill Lists 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 July August September October November December January February March April May June ASSETS 100 - Cash at Bank 110 - Accounts Receivable 130 - Prepaid Advertising 140 - Prepaid Insurance 150 - Land 160 - Building 165 - Accumulated Depreciation - Building 170 - Equipment 175 - Accumulated Depreciation - Equipment LIABILITIES 200 - Accounts Payable 210 - Unearned Revenue 220 - Interest Payable 230 - Loan Payable - principal due May 2030 240 - Wages Payable 250 - Utilities Payable EQUITY 300 - Nicholas Robbins, Capital 301 - Nicholas Robbins, Drawings REVENUE 400 - Sales - Cinema 401 - Sales - Gaming 402 - Sales - Candy Bar EXPENSES 600 - Accounting Fees 601 - Advertising Expense 602 - Candy Bar Expense 603 - Computer Consumables Expense 604 - Depreciation Expense - Building 605 - Depreciation Expense - Equipment 608 - Utilities Expense 610 - Insurance Expense 611 - Interest Expense 612 - Leasing Expense - cinema seating/screen 613 - Leasing Expense - gaming furniture 614 - Licensing Expense - Nintendo 615 - Licensing Expense - Sony 617 - Stationery & Office Supplies Expense 618 - Wages Expense 800 - P & L Summary Student ID: 0 FlixCity & 10-Column For the month en Account No's Account Names Trial Balance Dr ASSETS 100 Cash at Bank 110 Accounts Receivable 130 Prepaid Advertising 140 Prepaid Insurance 150 Land 160 Building 165 Accumulated Depreciation - Building 170 Equipment - computer/console/candy bar/projector 175 Accumulated Depreciation - Equipment LIABILITIES 200 Accounts Payable 210 Unearned Revenue 220 Interest Payable 230 Loan Payable - principal due May 2030 240 Wages Payable 250 Utilities Payable EQUITY 300 Nicholas Robbins, Capital 301 Nicholas Robbins, Drawings REVENUE 400 Sales - Cinema 401 Sales - Gaming 402 Sales - Candy Bar EXPENSES 600 Accounting Fees 601 Advertising Expense 602 Candy Bar Expense 603 Computer Consumables Expense 604 Depreciation Expense - Building 605 Depreciation Expense - Equipment 608 Utilities Expense 610 Insurance Expense 611 Interest Expense 612 Leasing Expense - cinema seating/screen 613 Leasing Expense - gaming furniture 614 Licensing Expense - Nintendo 615 Licensing Expense - Sony 617 Stationery & Office Supplies Expense 618 Wages Expense Profit/Loss for period 800 P&L Summary Account TOTALS 0.00 FlixCity & Gaming 10-Column Worksheet For the month ended 31 July 2016 Trial Balance Adjustments Cr Dr Cr Adjusted Trial Balance Dr Cr Statement of Profit or Loss Dr Cr 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Statement of Financial Position Dr Cr HINTS: 1 List Accounts in numerical order under headings; 2 Do not enter zero balances; 3 Do not round values; 4 Do not enter $ signs. 0.00 0.00 der headings; Fill Lists ASSETS 100 Cash at Bank 110 Accounts Receivable 130 Prepaid Advertising 140 Prepaid Insurance 150 Land 160 Building 165 Accumulated Depreciation - Building 170 Equipment - computer/console/candybar/projector 175 Accumulated Depreciation - Equipment LIABILITIES 200 Accounts Payable 210 Unearned Revenue 220 Interest Payable 230 Loan Payable - principal due May 2030 240 Wages Payable 250 Utilities Payable EQUITY 300 Nicholas Robbins, Capital 301 Nicholas Robbins, Drawings REVENUE 400 Sales - Cinema 401 Sales - Gaming EXPENSES 600 Accounting Fees 601 Advertising Expense 602 Candy Bar Expense 603 Computer Consumables Expense 604 Depreciation Expense - Building 605 Depreciation Expense - Equipment 608 Utilities Expense 611 Interest Expense 612 Leasing Expense - cinema seating/screen 613 Leasing Expense - gaming furniture 614 Licensing Expense - Nintendo 615 Licensing Expense - Sony 617 Stationery & Office Supplies Expense 800 Profit/Loss Summary Account Student ID: FlixCity & Gaming General Journal for July 2016 Date Day Jnl Ref Account & Journal Details Month JOURNAL TOTALS 0 Entries Dr Cr HINTS: 1 2 Journals should be prepared in the same sequence as the c Journal Reference Numbers should correspond to the closin 3 When there are multiple accounts required for debit or credi appear in ascending account number order; 4 Do not enter $ signs & do not round amounts - express valu Do not leave blank lines between journals; 5 NB: Take care with your journal entries. If you select the inc journals, then your T-Accounts will be wrong when you post Worksheet will not accept incorrect $ values. 0.00 0.00 ame sequence as the closing entries are presented; correspond to the closing entry numbers; quired for debit or credit entries within a journal, ensure they r order; amounts - express values in dollars & cents; rnals; ies. If you select the incorrect accounts for your closing e wrong when you post your entries to them & your 10-Column values. Fill Lists 1 2 3 4 5 6 7 8 July August September October November December January February ASSETS 100 - Cash at Bank 110 - Accounts Receivable 130 - Prepaid Advertising 140 - Prepaid Insurance 150 - Land 160 - Building 165 - Accumulated Depreciation - Building 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 March April May June 170 - Equipment 175 - Accumulated Depreciation - Equipment LIABILITIES 200 - Accounts Payable 210 - Unearned Revenue 220 - Interest Payable 230 - Loan Payable - principal due May 2030 240 - Wages Payable 250 - Utilities Payable EQUITY 300 - Nicholas Robbins, Capital 301 - Nicholas Robbins, Drawings REVENUE 400 - Sales - Cinema 401 - Sales - Gaming 402 - Sales - Candy Bar EXPENSES 600 - Accounting Fees 601 - Advertising Expense 602 - Candy Bar Expense 603 - Computer Consumables Expense 604 - Depreciation Expense - Building 605 - Depreciation Expense - Equipment 608 - Utilities Expense 610 - Insurance Expense 611 - Interest Expense 612 - Leasing Expense - cinema seating/screen 613 - Leasing Expense - gaming furniture 614 - Licensing Expense - Nintendo 615 - Licensing Expense - Sony 617 - Stationery & Office Supplies Expense 618 - Wages Expense 800 - P & L Summary Student ID: 0 DR ASSETS LIABILITIES EQUITY TOTALS 0.00 CR 0.00 Student ID: 0 REVENUE TOTAL REVENUE 0.00 EXPENSES TOTAL EXPENSES NET PROFIT / (LOSS) FOR THE PERIOD 0.00 0.00 Student ID: 0 Add: Less: ` Student ID: 0 Column1 Column2 ASSETS Current Assets: TOTAL CURRENT ASSETS Non-Current Assets: TOTAL NON-CURRENT ASSETS TOTAL ASSETS LIABILITIES Current Liabilities: TOTAL CURRENT LIABILITIES Non-Current Liabilities: TOTAL NON-CURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS Column3 OWNER'S EQUITY TOTAL EQUITY Column4 Column5 $0.00 $0.00 $0.00 Column6Step 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