FLOW OF DATA IN AN ACCOUNTING SYSTEM

Finnish the requirements A

\fACCOUNTS PAYABLE SUBSIDIARY LEDGER Name: CITY GAZETTE Date 2013 July 1 Balance 16 Cash Acct Code: CITG Explanation Post. Ref. Debit Balance 1100.00 1100.00 Name :DANDENONG POWER Date 2013 July 1 Balance 10 Cash Credit Explanation Acct Code: DANP Post. Ref. Debit Credit Balance 514.25 514.25 Name: JORDAN, MITCHELL Date Explanation 2013 July 1 Balance 10 Cash 27 Invoice no.2245 31 Cash Acct Code:JORM Post. Ref. Debit Credit Balance 1892.00 1892.00 1474.00 1166.00 ACCOUNTS PAYABLE SUBSIDIARY LEDGER Name: SKICENTRAL NZ WHOLESALERS Date Explanation 2013 July 11 Invoice no. 13408 Acct Code: SKIW Post. Ref. Debit Balance 16455.00 Name: SNOWSPORTS PTY LTD Date Explanation 2013 July 1 Balance 3 Invoice no. 3403 5 Invoice no. 3408 Credit Acct Code: SNOS Post. Ref. Debit Credit Balance 5505.00 4015.00 165.00 Name: THE SOUTH FACE Date 2013 July 1 Balance Explanation Acct Code: SNOF Post. Ref. Debit Credit Balance 2464.00 1540.00 23 Invoice no.9467 1672.00 ACCOUNTS PAYABLE SUBSIDIARY LEDGER Name: SPIDA HEADGEAR Date Explanation 2013 July 16 Invoice no. 23211 25 cash Name: Debit Credit Balance 1870.00 1776.50 Post. Ref. Debit Credit Explanation 30 Cash Balance 4876.30 Alpine Shire Council Date 2013 July Post. Ref. Acct Code: Date Explanation 2013 July 17 Invoive no.3371 Name: Acct Code:SPIH Acct Code: Post. Ref. Debit 536.70 Credit Balance ACCOUNTS RECEIVABLE SUBSIDIARY LEDGER Name: ALPINE SPORTS Date 2013 July 1 Balance Explanation Acct Code:ALPS Post. Ref. Debit Credit Balance 2112.00 3465.00 ### Cash 5577.00 Name: MOUNTAIN LAKE RESORT Date Explanation 2013 July 1 Invoice No. 3366 5 Acct Code.:MOUR Post. Ref. Debit Credit 6732.00 6395.40 Name: SNOWLINK Date 2013 July 1 Balance ### Cash Balance Acct Code:SNOL Explanation Post. Ref. Debit Credit Balance 3405.60 3405.50 ACCOUNTS RECEIVABLE SUBSIDIARY LEDGER Name:SNOW SKI HOLIDAYS Date 2013 July 1 ### ### ### ### ### Explanation Acct Code: SNOH Post. Ref. Balance Cash Invoive no.3371 Invoice no 3372 Invoice no 3373 Invoice no Debit Credit 3168.00 3168.00 4876.30 4400.00 198.00 330.00 Name: SNOW SKI TOURS Date Explanation 2013 July 9 Invoice no. 3368 Name: Bright Motors Balance Acct Code: SNOT Post. Ref. Debit Credit 6699.00 Acct Code: BRIGHTM Balance Date 2013 July 5 5 Explanation Post. Ref. Debit Credit 22550.00 22550.00 Balance LET IT SNOW BALANCE SHEET as at 31 July 2013 CURRENT ASSETS TOTAL CURRENT ASSETS NON-CURRENT ASSETS TOTAL NON-CURRENT ASSETS TOTAL ASSETS CURRENT LIABILITIES TOTAL CURRENT LIABILITIES NON-CURRENT LIABILITIES TOTAL NON-CURRENT LIABILITIES TOTAL LIABILITIES NET ASSETS EQUITY TOTAL EQUITY BANK RECONCILIATION STATEMENT as at 31 July 2013 $ Balance as per Cheque Account on 1/07/2013 Add Receipts Less Payments Balance as per Cheque Account on 31/07/2013 Add Less Balance as per the Bank Statement (31/07/2013) CASH PAYMENTS JOURNAL Page: 12 Debits Cheque Date Account 2013 July 2 Service Motor Vehicle 2 Fuel 17 Utilities Post Accounts GST Paid No. Ref. Payable (Outlays) Credits Cash at Other Discounts GST Paid Bank Received (Outlays) 385.00 77.00 12.55 CASH RECEIPTS JOURNAL Page: 14 Debits Credits Post Date 2013 July Account Cash Sales Cash at Discounts GST Cost of Ref. Bank Given Collected Sales 1,738.00 158.00 Accounts Sales GST Receivable Collected Other GENERAL JOURNAL Date 2013 July Description Page: 20 Post Ref. 1 Wages and Salaries Payable Wages and Salaries Expenses Debit Credit 80.00 80.00 Motor Vehicle Bank Loan 39600.00 39600.00 Depreciation Expenses Accumulated Depreciation- Motor Vehicle 65.00 Bright Motors Accumulated Depreciation- Motor Vehicle Motor Vehicle Profit on sale of Motor Vehicle 22550.00 65.00 8 Prepaid Insurance Cash 5130.50 5130.50 12 Wages Expenses Cash 1760.00 1760.00 Superanuation Expenses Cash 414.00 414.00 15 Council Expenses Cash 2146.80 25 Drawing Cah 1500.00 26 Wages Expenses Cash 1855.00 31 Wages Expenses Wages Payable 1400.00 2146.80 1500.00 1855.00 1400.00 Insurance Expenses Prepaid Insurance 427.54 Superanuation Expenses Superanuation Payable 369.00 427.54 369.00 Depreciation Expenses Accumulated Depreciation - Building & Improvements Accumulated Depreciation - Motor Vehicles Accumulated Depreciation - Stores Equipments 1416.00 Interest Expenses Interest Payable 1242.12 729.00 503.00 184.00 1242.12 GENERAL JOURNAL Date Description Page: 21 Post Ref. Debit Credit GENERAL JOURNAL Date Description Page: 22 Post Ref. Debit Credit GENERAL LEDGER Name: CHEQUE ACCOUNT - SNOWY CREDIT UNION Date Details 2013 July 1 Balance Post Ref Acct No.: 100 Debit Date 2013 6486.93 July Details Name: PETTY CASH Date Details 2013 July 1 Balance Credit Acct No.: 105 Post Ref Debit Date 2013 185.15 July Details Name: ACCOUNTS RECEIVABLE Date Details 2013 July 1 Balance Post Ref Post Ref Post Ref Credit Acct No.: 110 Debit Date 2013 12150.60 July Details Post Ref Credit GENERAL LEDGER Name: INVENTORY Date Details 2013 July 1 Balance Acct No.: 120 Post Ref Debit Date 2013 46500.00 July Details Name: GST PAID (OUTLAYS) Date Details 2013 July 1 Balance 16 20 Cash 23 27 Post Ref Credit Acct No.:130 Post Ref Debit Date 2013 3269.19 170.00 July 5597.00 152.00 134.00 Details Post Ref Credit Name: PREPAID INSURANCE Date 2013 July Details Acct No.140 Post Ref Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name: PREPAID RATES & TAXES Date 2013 July Details Post Ref Acct No.: 150 Debit Date 2013 July Details Name: BUILDINGS & IMPROVEMENTS (COST) Date Details 2013 July 1 Balance Post Ref Debit Date 2013 July Details Date 2013 350000.00 July Debit Credit Acct No.: 150 Details Name: ACCUM DEPRECIATION - BLDGS & IMP Post Ref Post Ref Post Ref Credit Acct No.: 151 Date Details 2013 July 1 Balance Post Ref Credit 44479.00 GENERAL LEDGER Name: MOTOR VEHICLES (COST) Date Details 2013 July 1 Balance Post Ref Acct No.: 170 Debit Date 2013 29900.00 July Details Name: ACCUM DEPRECIATION - MOTOR VEHICLES Date 2013 July Details Post Ref Debit Date Details 2013 July 1 Balance Credit Acct No.: 171 Date Details 2013 July 1 Balance Name: STORE EQUIPMENT (COST) Post Ref Post Ref Post Ref Credit 9468.00 Acct No.: 180 Debit Date 2013 14700.00 July Details Post Ref Credit GENERAL LEDGER Name: ACCUM DEPRECIATION - STORE EQUIP Date 2013 July Details Post Ref Debit Acct No.: 181 Date Details 2013 July 1 Balance Name: ACCOUNTS PAYABLE Date 2013 July Details Post Ref Credit 6799.00 Acct No.: 200 Post Ref Debit Date Details 2013 July 1 Balance Post Ref Credit 12515.25 Name: GST COLLECTED Date Details 2013 July 19 Invoice no. 3373 Acct No.:210 Post Ref Debit Date Details 2013 18.00 July 1 Balance 1 Invoice No. 3366 Cash sales 9 Invoice no. 3368 11 Invoice no. 3369 16 Invoice no. 3370 17 Invoice no. 3371 18 Invoice no. 3372 22 Invoice no. 3374 27 Invoice no. 29 Invoice no. 3376 Post Ref Credit 7206.70 612.00 158.00 609.00 62.00 90.00 443.30 400.00 90.00 30.00 732.00 GENERAL LEDGER Name: PAYG WITHHOLDING PAYABLE Date 2013 July Details Post Ref Acct No.: 220 Debit Date Details 2013 July 1 Balance Name: SUPERANNUATION PAYABLE Date 2013 Details Post Ref Debit Date 2013 July Details 1660.00 Post Ref 1 Balance Name: WAGES & SALARIES PAYABLE Post Ref Credit 414.00 Acct No.:240 Debit Date Details 2013 80.00 July 1 Balance Post Ref Credit 80.00 GENERAL LEDGER Name: BANK LOAN Credit Acct No.: 230 July Date Details 2013 July 1 Reversing Post Ref Acct No.: 280 Name: BANK LOAN Date 2013 July Details Acct No.: 280 Post Ref Debit Date Details 2013 July 1 Balance Name: OWNER'S CAPITAL Date 2013 Details Details Credit 219191.67 Acct No.: 310 Post Ref Debit Post Ref Date Details 2013 July 1 Balance Name:OWNER'S DRAWINGS Date 2013 July Post Ref Credit 161378.25 Acct No.: 315 Post Ref Debit Date 2013 July Post Ref Details Credit GENERAL LEDGER Name: PROFIT & LOSS SUMMARY Date 2013 July Details Post Ref Acct No.: 390 Debit Name: SALES Date Details 2013 July 19 Invoice no. 3373 Date 2013 July Post Ref Details Credit Acct No.: 400 Post Ref Debit Date Details 2013 180.00 July 1 Invoice No. 3366 Cash sales 9 Invoice No. 3368 11 Invoice no. 3369 16 Cash sales 17 Invoice no. 3371 18 Invoice no. 3372 22 Invoice no. 3374 Post Ref Credit 6100.00 1580.00 4060.00 620.00 990.00 3220.00 2820.00 900.00 29 Invoice no. 3376 Name: SERVICE INCOME Date 2013 July Details 7300.00 Acct No.:410 Post Ref Debit Date Details 2013 July 9 Invoice No. 3368 17 Invoice no. 3371 18 Invoice no. 3372 Post Ref Credit 1980.00 1188.00 1100.00 GENERAL LEDGER Name: DISCOUNTS RECEIVED Date 2013 July Details Acct No.: 420 Post Ref Debit Date 2013 July Name: FREIGHT COLLECTED Date 2013 July Details Details Credit Acct No.: 430 Post Ref Debit Date 2013 July 1 9 17 18 29 Post Ref Post Ref Details Ivoice No. 3366 Invoice no. 3368 Invoice no. 3371 Invoice no. 3372 Invoice no. 3376 Name: PROFIT ON SALE OF PP&E Date 2013 July Post Ref Details Credit 20.00 50.00 525.00 80.00 20.00 Acct No.: 440 Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name: COST OF SALES Date 2013 Details Acct No.: 510 Post Ref Debit Date 2013 Details Post Ref Credit July July Name: DISCOUNTS GIVEN Date 2013 July Details Acct No.: 520 Post Ref Debit Date 2013 July Details Name: FREIGHT EXPENSE Date 2013 July 16 23 Details Post Ref Credit Acct No.: 530 Post Ref Debit Date 2013 100.00 July 20.00 Details Post Ref Credit GENERAL LEDGER Name: SKI LESSONS Date 2013 July 27 Details Acct No.: 540 Post Ref Debit Date 2013 1340.00 July Details Name: ADVERTISING Date 2013 July Details Name: BANK CHARGES Post Ref Credit Acct No.: 600 Post Ref Debit Date 2013 July Details Post Ref Acct No.: 605 Credit Date 2013 July Details Post Ref Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name: CLEANING Date 2013 July Details Acct No.: 610 Post Ref Debit Date 2013 July Details Name:DEPRECIATION Date 2013 July Details Post Ref Debit Date 2013 July Details Post Ref Credit Acct No.: 620 Post Details Credit Acct No.: 615 Name: ELECTRICITY Date Post Ref Ref Post Debit 2013 Date Details Ref Credit 2013 July July GENERAL LEDGER Name: INSURANCE Date 2013 July Details Acct No.: 625 Post Ref Debit Date 2013 July Details Post Ref Credit Name: INTEREST EXPENSE Date 2013 July Details Acct No.: 630 Post Ref Debit Date 2013 July Details Name: MOTOR VEHICLE EXPENSES Date 2013 July Details Post Ref Post Ref Credit Acct No.: 635 Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name: OFFICE SUPPLIES Date 2013 July Details Acct No.: 640 Post Ref Debit Date 2013 July Details Name: PRINTING & POSTAGE Date 2013 July Details Name: RATES & TAXES Post Ref Credit Acct No.: 645 Post Ref Debit Date 2013 July Details Post Ref Acct No.: 650 Credit Date 2013 July Details Post Ref Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name: REPAIRS & MAINTENANCE Date 2013 July Details Post Ref Acct No.: 655 Debit Date 2013 July Details Name: STAFF AMENITIES Date 2013 July Details Details Credit Acct No.: 660 Post Ref Debit Date 2013 July Details Name: SUPERANNUATION Date 2013 July Post Ref Post Ref Credit Acct No.: 665 Post Ref Debit Date 2013 July Details Post Ref Credit GENERAL LEDGER Name:TELEPHONE Date 2013 July Details Acct No.: 670 Post Ref Debit Date 2013 July Details Post Ref Credit Name: WAGES & SALARIES Date 2013 July Details Acct No.: 675 Post Ref Debit Date 2013 July 1 Name: Date Details Post Ref Reversing Credit 80.00 Acct No.: Details Post Ref Debit Date Details Post Ref Credit LET IT SNOW INCOME STATEMENT for the period 1 July 2013 to 31 July 2013 INCOME Revenue: Total Revenue COST OF SALES Total Cost of Sales GROSS PROFIT Other Income: Total Other Income TOTAL INCOME EXPENSES TOTAL EXPENSES NET PROFIT/(LOSS) INVENTORY SUBSIDIARY LEDGER Item: JACKETS Item Code: SF100 Date 2013 July 1 1 11 ### ### Min Stock 20 Explanation Units Purchases Cost Total Balance Sale Sale Sale Sale Cost of Sales Units Cost Total 5 1 5 5 Item: PANTS Item Code: SF200 Date 2013 July 1 1 11 ### ### Explanation Units Purchases Cost Total Balance Sale Sale Sale Sale Units 5 1 5 5 Cost of Sales Cost Total Balance Cost Total 100.00 3100.00 100.00 100.00 100.00 100.00 Units 52 Balance Cost Total 30.00 1560.00 Units 28 Balance Cost Total 90.00 2520.00 Units 24 Balance Cost Total 80.00 1920.00 500.00 100.00 500.00 500.00 Min Stock: 50 Explanation Units Balance Sale Sale Sale Sale Sale Sale Return Purchases Sales Sales Units 31 750.00 150.00 750.00 750.00 Min Stock: 20 Item: GLOVES Item Code: SF300 Date 2013 July 1 9 11 ### ### ### ### ### ### ### 150.00 150.00 150.00 150.00 Units 27 Balance Cost Total 150.00 4050.00 Purchases Cost Total Units Cost of Sales Cost Total 4 2 4 12 6 30.00 30.00 120.00 60.00 120.00 360.00 180.00 5 10 3 50 30.00 30.00 30.00 30.00 30.00 30.00 30.00 150.00 300.00 90.00 1500.00 INVENTORY SUBSIDIARY LEDGER Item: GOGGLES Item Code: SH100 Date 2013 July 1 9 ### ### Min Stock: 20 Explanation Units Purchases Cost Total Balance Sale Sale Sale Units 2 2 2 Item: HELMETS Item Code: SH200 Date Explanation 2013 July 1 Balance Cost of Sales Cost Total 90.00 90.00 90.00 180.00 180.00 180.00 Min Stock: 20 Units Purchases Cost Total Units Cost of Sales Cost Total 9 ### ### ### Sale Purchases Sale Sale 2 80.00 80.00 160.00 2 2 20 80.00 80.00 160.00 160.00 1600.00 Item: SNOWBOARDS Item Code: SS100 Date 2013 July 1 1 3 ### ### Min Stock: 25 Explanation Purchases Cost Total Units Balance Sale Purchase Sale Sale Cost of Sales Units Cost Total 4 300.00 300.00 300.00 300.00 Units 23 Balance Cost Total 150.00 3450.00 Units 29 Balance Cost Total 450.00 13050.00 Units 25 Balance Cost Total 250.00 6250.00 1200.00 2 1 8 Units 26 Balance Cost Total 300.00 7800.00 600.00 300.00 2400.00 INVENTORY SUBSIDIARY LEDGER Item: SNOWBOARD BOOTS Item Code: SS200 Date 2013 July 1 1 3 5 ### ### Min Stock: 25 Explanation Purchases Cost Total Units Balance Sale Purchases Purchases Sale Sale Units 4 150 150.00 150.00 600.00 2 1 8 1 150.00 150.00 300.00 150.00 1200.00 150.00 Item: SKIS Item Code: SW100 Date Explanation 2013 July 1 Balance Sale 9 Sale 11 Purchases ### Sale Min Stock: 25 Units Purchases Cost Total Units Cost of Sales Cost Total 1 2 400.00 450.00 900.00 3 20 450.00 450.00 450.00 1350.00 8000.00 Item: SKI BOOTS Item Code: SW200 Date Explanation 2013 July 1 Balance Sale 9 Sale 11 Purchases ### Sale Cost of Sales Cost Total Min Stock: 25 Units Purchases Cost Total Cost of Sales Units Cost Total 1 2 24 200.00 250.00 250.00 250.00 500.00 3 250.00 750.00 4800.00 INVENTORY SUBSIDIARY LEDGER Item: SKI POLES Item Code: SW300 Date Explanation 2013 July 1 Balance Sale 9 Sale 11 Purchases Min Stock: 50 Units Purchases Cost Total Units 2 4 20 40.00 Balance Cost Total 50.00 2800.00 Units Balance Cost Total Units Balance Cost Total 100.00 200.00 Min Stock: Explanation Units Purchases Cost Total Item: Item Code: Date 50.00 50.00 Units 56 800.00 Item: Item Code: Date 2013 July Cost of Sales Cost Total Units Cost of Sales Cost Total Min Stock: Explanation Units Purchases Cost Total Cost of Sales Units Cost Total LET IT SNOW Post-Closing Trial Balance as at 31 July 2013 Acc No 100 105 110 120 130 140 150 160 161 180 181 190 191 200 210 220 230 240 280 310 Account Cheque Account - Snowy Credit Union Petty Cash Accounts Receivable Inventory GST Paid (Outlays) Prepaid Insurance Prepaid Rates & Taxes Buildings & Improvements (Cost) Accum Depn - Bldgs & Imp Motor Vehicles (Cost) Accum Depn - Motor Vehicles Store Equipment (Cost) Accum Depn - Store Equip Accounts Payable GST Collected PAYG Withholding Payable Superannuation Payable Wages & Salaries Payable Bank Loan Owner's Capital Balances Debit Credit PURCHASES JOURNAL Inv. Date 2013 July No. Page: 11 Post. Account Terms Ref. GST Paid Inventory Freight (Outlays) Expense Accounts Other Payable SALES JOURNAL Inv. Date 2013 July No. Page:10 Post Account Terms Cost of Ref. Sales Service Sales Freight GST Accounts Income Collected Collected Receivable Note: The total of the Cost of Sales column is posted to the Cost of Sales account AND the Inventory account in the general ledger. Schedules of Subsidiary Ledgers Schedule of Accounts Receivable Acc Code as at 31 July 2013 Account Amount Schedule of Accounts Payable Acc Code as at 31 July 2013 Account Amount Schedule of Inventory on Hand Item Code as at 31 July 2013 Description Quantity Total Cost WORKSHEET Worksheet for period ended 31 July 2013 Acc No 100 105 110 120 130 140 150 160 161 170 171 180 181 200 210 220 230 240 280 310 315 400 410 420 430 440 510 520 530 540 600 605 610 615 620 625 630 635 640 645 650 655 660 665 670 675 Account Cheque Account - Snowy Credit Petty Cash Accounts Receivable Inventory GST Paid (Outlays) Prepaid Insurance Prepaid Rates & Taxes Buildings & Improvements (Cost) Accum Depn - Bldgs & Imp Motor Vehicles (Cost) Accum Depn - Motor Vehicles Store Equipment (Cost) Accum Depn - Store Equip Accounts Payable GST Collected PAYG Withholding Payable Superannuation Payable Wages & Salaries Payable Bank Loan Owner's Capital Owner's Drawings Sales Service Income Discounts Received Freight Collected Profit on Sale of PP&E Cost of Sales Discounts Given Freight Expense Ski Lessons Advertising Bank Charges Cleaning Depreciation Electricity Insurance Interest Expense Motor Vehicle Expenses Office Supplies Printing & Postage Rates & Taxes Repairs & Maintenance Staff Amenities Superannuation Telephone Wages & Salaries Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet