Urgenthomework logo
UrgentHomeWork
Live chat

Loading..

Acc106 The Ledger Accounts To Assessment Answers

1 The stocktake on 30 June revealed $668 worth of supplies on hand.
4.2 The next wages payment will occur on Thursday 5 July for the employee earnings in the final week of June. N Rider worked for 20 hours between 26th and 30th June; B Gee worked a usual week.
4.3 Calculate the amounts for depreciation expense for each of the three types of non-current Assets: office equipment; computer systems; vehicles (Estimate expense as though assets held for whole of month of June.)
4.4 Calculate and record the adjusting entry for rent for the end of the month given that June rent has been used up.
4.5 During the last week of June, Nelly’s Saddlery earned one third of the advance payment for the Paynter’s Pony Club saddlery work.
4.6 Calculate the Allowance for Doubtful Debts based on 5% of accounts receivable at the end of the year and make the necessary adjusting entry.
5 Accounting Requirements and Instructions

5.1 Spreadsheet software
The file on the course Blackboard site (ACC106 Task 2 Student Templates) contains a series of worksheets that you should use to complete the requirements below. Make changes as required including formulas and links.
5.2 Completing the Accounting Cycle
5.2.1 Record all the business transactions from section 3 above in the relevant special journals and post the Account totals to the relevant ledgers using EXCEL linking function. Use the accounts listed in the Chart of Accounts and enter names of the ledger accounts as required. In the ledgers, use formulas to create running totals. DO NOT POST

5.2.2 Prepare an ‘Unadjusted’ Trial Balance as at 30 June 2018 by linking balances in the ledger accounts to the Trial Balance. It will be a ‘Live’ Trial Balance but at this point it is unadjusted as the Adjustments have not yet been posted. When completed, check the debit and credit columns are equal in the Trial Balance. Then copy and special paste (as
values only) the Trial Balance into the Worksheet columns ‘Unadj Trial Balance’. These should not change now as they are raw figures. (Tip: Use Paste Special to paste in as values.)

5.2.3 Record the end of year Adjustments, listed above at section 4, in the Worksheet and complete the Worksheet by calculating balances in the Adjusted Trial Balance columns. Then complete the Income Statement and Balance Sheet columns in the Worksheet.

5.2.4 Record the Adjustments in the General Journal and post these adjustments to the General Ledger using new accounts as necessary. (This will change the figures in your Trial Balance which should now match the Adjusted Trial Balance figures in the Worksheet.)

5.2.5 Prepare the closing entries in the General Journal, and post these to the General Ledger. (As with adjustments, this will change your Trial Balance figures if you have linked correctly. NOW, your Adjusted Trial Balance figures in the Worksheet will NOT match the Trial Balance figures for the Revenue and Expense accounts and totals.)

Remember: for closing, close revenue and expense accounts to the Income Summary Account, then close Income Summary Account to the Capital account and finally, close drawings to the Capital account.
5.2.6 Finally, prepare the Financial Statements for 30 June 2018 by copying or linking the appropriate figures into your Financial Statements. Refer to your textbook or course Learning Materials for guidance on the format of these Statements. For Balance Sheet,use the Classified Balance Sheet in report form as demonstrated on p.184 of the text;
and Income Statement and Statement of Changes in Equity as demonstrated on p.240 of the text. (Note, for the Income Statement, there will be three revenue streams including discount received.) 

Answer:

CASH RECEIPTS JOURNAL—JUNE
DateParticularsDebitsCredits
Cash at BankCost of SalesDiscount Allowed ExpenseAccounts Receivable
(inc GST)
Inventory Sales RevenueService RevenueUnearned Service RevenueOther AccountsGST Collected
GST CollectedNetAccount NameAmt ex GST
01-JunEst business120000.00Capital120000.00
07-JunAll Purpose & Suede sale6732.001810.001810.006120.00612.00
09-JunService revenue2541.002310.00231.00
12-JunClamcey's Pony club8710.2416.16161.608888.00
13-JunTop Tack Rugs792.00320.00320.00720.0072.00
21-JunService revenue3740.003400.00340.00
21-JunUnerned service revenue8690.007900.00790.00
25-JunMr. Benjo4000.004000.00
Total columns here 155205.242130.0016.16161.6012888.002130.006840.005710.007900.000.00120000.002045.00
157513.00157513.00
DR1,57,513.00
CR1,57,513.00
difference0
all other acc's not listed
DetailsCreditsDebits
Cash at BankDiscount ReceivedWagesAccounts Payable (inc GST)InventoryPrepaid RentSuppliesWages ExpenseDrawingsAdvertising ExpElectricityOther AccountsGST Paid
GST PaidNetPAYG Tax PayablePrivate Health PayableEmployer Super PayableAccount NameAmt ex GST
Paid rent in advance2860.002600.00260.00
Supplies3520.003200.00320.00
Inventory purchase6160.005600.00560.00
Advertismenet1650.001500.00150.00
Wages1397.00255.0022.00159.031666.39166.64
Drawings1300.001300.00
Wages1524.00318.0022.00177.081855.53185.55
Electricity290.00263.6426.36
Tmart Purchase1858.365.2252.251915.83
Wages1475.00291.0022.00169.861779.87177.99
22034.365.2252.25864.0066.00505.971915.835600.002600.003200.005301.791300.001500.00263.640.001846.54
23527.8023527.80
SALES JOURNAL—JUNE
CreditDebitCreditDebit
DateDetails Sales RevenueGST CollectedAccounts ReceivableInventoryCost of Sales
05-JunClancey's Pony Club3200320.003,520.001,000.001,000.00
08-JunMr Benjo2440244.002,684.00795.00795.00
09-JunClancey's Pony Club4880488.005,368.001,590.001,590.00
20-JunMr Benjo2900290.003,190.001,657.141,657.14
21-JunMiss Sunshine2530253.002,783.00835.00835.00
Total columns here 15,950.001,595.0017,545.005,877.145,877.14
PURCHASES JOURNAL —JUNE
DebitDebitCredit
DateDetailsInventory VehiclesComputer SystemsOffice FurnitureGST PaidAccounts Payable
01-JunTmart Purchase21,200.002,120.0023,320.00
02-JunSaddleSeat Traders 6,240.00624.006,864.00
02-JunTecTime20,900.002,090.0022,990.00
03-JunMitsubishi23,620.002,362.0025,982.00
07-JunSaddleSeat Traders 2,340.00234.002,574.00
23-Jun
Total columns here8,580.0023,620.0020,900.0021,200.007,430.0081,730.00
81,730.0081,730.00
DR81,730.00
CR81,730.00
difference0
GENERAL JOURNAL
DateDetailsDebitCredit
ADJUSTING ENTRIES
June30Supplies Expense1332
Supplies1332
Supplies used up during the year 
June30Wages expenses1742.05
GST Paid174.20
Wages Payable1450.00
PAYG Tax Payable278.00
Private Health Payable22.00
Employer Super Payable166.25
Wages expenses payable
June30Depreciation Expense1241.47
Accum Dep - Office353.33
Accum Dep - Computer435.42
Accum Dep - Vehicles452.72
Depreciation Expense recorded
june 30Rent Expense650
Prepaid rent650.00
Rent expenses recorded
June 30Unearned Service Revenue2633.33
Service Revenue2633.33
Earned service revenue recorded
June 30Doubtful Debts expense232.85
Allowance for Doubtful Debts232.85
Doubtful Debts expense recorded
8005.908005.90
CLOSING ENTRIES
June30Sales Revenue43690.91
43,690.91-
Schedule of Accounts ReceivableSchedule of Accounts Payable
as at 30 June 2018as at 30 June 2018
Account NameAmount5%Account NameAmount
Clancey's Pony Club0.000.00Tmart23,320.00
Mr Banjo1,874.0093.70SaddleSeat Traders9,438.00
Miss Sunshine2,783.00139.15Techtime21,074.17
Mitsubhishi25,982.00
Total4,657.00232.85Total79,814.17
Amount showing in Accounts Receivable General Ledger Trial Balance4,657.00Amount showing in Accounts Payable General Ledger Trial Balance79,814.17
Difference between Schedule total and General Ledger balance0Difference between Schedule total and General Ledger balance0
ACCOUNTS RECEIVABLE SUBSIDIARY LEDGERACCOUNTS PAYABLE SUBSIDIARY LEDGER
Clancey's Pony ClubTmart
DateDetailsDebitCreditBalanceDateDetailsDebitCreditBalance
########1x Suede Seat3,520.003,520.0001-06-2018Office Furniture23,320.0023,320.00
########2x All purpose saddles5,368.008,888.0023,320.00
########Cash8,888.000.0023,320.00
0.0023,320.00
0.0023,320.00
Mr BanjoSaddleSeat Traders
DateDetailsDebitCreditBalanceDateDetailsDebitCreditBalance
########1x All purpose saddles2,684.002,684.0002-06-20184x All purpose saddles3,564.003,564.00
########2x Suede Seat Saddles3,190.005,874.0002-06-20183x Suede Seat saddles3,300.006,864.00
########cash received4,000.001,874.0007-06-20183x All purpose saddles2,574.009,438.00
1,874.009,438.00
1,874.009,438.00
Miss SunshineTechtime
DateDetailsDebitCreditBalanceDateDetailsDebitCreditBalance
########1x All purpose saddles2,783.002,783.0002-06-2018computre system22,990.0022,990.00
2,783.0027-06-2018monthly repaymeney1,915.8321,074.17
2,783.0021,074.17
2,783.0021,074.17
2,783.0021,074.17
Mitsubhishi
DateDetailsDebitCreditBalance
03-06-2018Utility25,982.0025,982.00
3,520.0025,982.00
2,684.0025,982.00
5,368.0025,982.00
3,190.0025,982.00
2,783.00
Inventory Reconciliation
30-Jun-18
Item NumberOn Hand $
All Purpose Saddle1,590.00
Suede Seat Saddles4,142.86
Top Tack Rugs440.00
Total6,172.86
Link to General Ledger Inventory6,172.86
Difference0
All Purpose SaddlePurchasesCost of SalesInventory on Hand
DateUnit No.Unit CostTotal costUnit No.Unit CostTotalUnit No.Unit CostTotal cost
Cost
02-Jun48103,240.004810.003,240.00
07-Jun0.001810.00810.003810.002,430.00
07-Jun37802,340.000.006795.004,770.00
08-Jun0.001795.00795.005795.003,975.00
09-Jun0.002795.001,590.003795.002,385.00
21-Jun0.001795.00795.002795.001,590.00
Suede Seat SaddlesPurchasesCost of SalesInventory on Hand
DateUnit No.Unit CostTotal costUnit No.Unit CostTotalUnit No.Unit CostTotal cost
Cost
02-Jun310003,000.0031000.003,000.00
05-Jun0.0011000.001,000.0021000.002,000.00
07-Jun0.0011000.001,000.0011000.001,000.00
10-Jun68004,800.000.007828.575,800.00
20-Jun0.002828.571,657.145828.574,142.86
Top Tack RugsPurchasesCost of SalesInventory on Hand
DateUnit No.Unit CostTotal costUnit No.Unit CostTotalUnit No.Unit CostTotal cost
Cost
10-Jun2040800.002040.00800.00
13-Jun0.00840.00320.001240.00480.00
21-Jun0.00140.0040.001140.00440.00
Trial Balance
As At 30/6/2018
Account NameDrCr
Cash at Bank1,33,170.88
Accounts Receivable4,657.00
Allowance for Doubtful Debts
Supplies3,200.00
Inventory6,172.86
Prepaid rent2,600.00
GST Paid9,271.32
Office Equipment21,200.00
Accum Dep - Office
Computer Systems20,900.00
Accum Dep - Computer
Vehicles23,620.00
Accum Dep - Vehicles
Accounts Payable79,814.17
GST Collected3,623.84
Unearned Service Revenue7,900.00
PAYG Tax Payable 864.00
Superannuation Payable505.97
Private health Payable66.00
Wages Payable
N Gee, Capital1,20,000.00
N Gee, Drawings1,300.00
Sales Revenue 22,790.00
Discount Received52.25
Service Revenue5,710.00
Cost of Sales8,007.14
Advertising Expense1,500.00
Electriciy Expense263.64
Doubtful Debts expense
Discount Allowed Expense161.60
Wages Expense5,301.79
Supplies Expense
Rent Expense
Depreciation Expense
Total2,41,326.232,41,326.23
Worksheet for Financial year end 30 June
Unadj Trial BalanceAdjustmentsAdjusted Trial BalanceIncome StatementBalance Sheet
DebitCreditDebitCreditDebitCreditDebitCreditDebitCredit
Cash at Bank133170.881701,33,170.881,33,170.88
Accounts Receivable465704,657.004,657.00
Allowance for Doubtful Debts00232.85232.85232.85
Supplies320001,332.001,868.001,868.00
Inventory6172.85714306,172.866,172.86
Prepaid rent26000650.001,950.001,950.00
GST Paid9271.3177270174.209,445.529,445.52
Office Equipment21200021,200.0021,200.00
Accum Dep - Office00353.33353.33353.33
Computer Systems20900020,900.0020,900.00
Accum Dep - Computer00435.42435.42435.42
Vehicles23620023,620.0023,620.00
Accum Dep - Vehicles00452.72452.72452.72
Accounts Payable079814.1666779,814.1779,814.17
GST Collected03623.843,623.843,623.84
Unearned Service Revenue079002,633.335,266.675,266.67
PAYG Tax Payable 0864278.001,142.001,142.00
Superannuation Payable0505.97166.25672.22672.22
Private health Payable06622.0088.0088.00
Wages Payable001,450.001,450.001,450.00
N Gee, Capital01200001,20,000.001,20,000.00
N Gee, Drawings130001,300.001,300.00
Sales Revenue 02279022,790.0022,790.00
Discount Received052.2552.2552.25
Service Revenue057102,633.338,343.338,343.33
Cost of Sales8007.14285708,007.148,007.14
Advertising Expense150001,500.001,500.00
Electriciy Expense263.63636360263.64263.64
Doubtful Debts expense00232.85232.85232.85
Discount Allowed Expense161.60161.60161.60
Wages Expense5301.79090901,742.057,043.847,043.84
Supplies Expense001,332.001,332.001,332.00
Rent Expense00650.00650.00650.00
Depreciation Expense001,241.471,241.471,241.47
3,77,658.223,77,658.228,005.908,005.902,44,716.792,44,716.79 $ 20,432.53 $ 31,185.58 $ 2,24,284.26 $ 2,13,531.21
Profit or Loss $ 10,753.05 0  0  $ 10,753.05
 $ 31,185.58 $ 31,185.58 $ 2,24,284.26 $ 2,24,284.26
Profit
DR3,77,658.22DR8,005.90DR2,44,716.79
CR3,77,658.22CR8,005.90CR2,44,716.79
difference0difference0difference0
FINANCIAL STATEMENTS
Income Statement
Sales Revenue  $ 22,790.00
Service Revenue $ 8,343.33
total revenue $ 31,133.33
Less: Cost of Sales $ 8,007.14
Cost of goods sold $ 23,126.19
Add:
Discount Received $ 52.25 $ 52.25
Less: 
Advertising Expense $ 1,500.00
Electriciy Expense $ 263.64
Doubtful Debts expense $ 232.85
Discount Allowed Expense $ 161.60
Wages Expense $ 7,043.84
Supplies Expense $ 1,332.00
Rent Expense $ 650.00
Depreciation Expense $ 1,241.47
Tota expenses $ 12,425.39
Net income $ 10,753.05
Balance sheet
Assets
Current assets
Cash at Bank $ 1,33,170.88
Accounts Receivable $ 4,657.00
Allowance for Doubtful Debts $ 232.85 $ 4,424.15
Supplies $ 1,868.00
Inventory $ 6,172.86
Prepaid rent $ 1,950.00
GST Paid $ 9,445.52
Total current assets $ 1,57,031.41
Non-current assets
Office Equipment $ 21,200.00
Accum Dep - Office $ 353.33 $ 20,846.67
Computer Systems $ 20,900.00
Accum Dep - Computer $ 435.42 $ 20,464.58
Vehicles $ 23,620.00
Accum Dep - Vehicles $ 452.72 $ 23,167.28
Total non-current assets $ 64,478.53
Total assets $ 2,21,509.94
Liabilities and equity
Liabilities
Accounts Payable $ 79,814.17
GST Collected $ 3,623.84
Unearned Service Revenue $ 5,266.67
PAYG Tax Payable  $ 1,142.00
Superannuation Payable $ 672.22
Private health Payable $ 88.00
Wages Payable $ 1,450.00
Total liabilities $ 92,056.89
Equity
N Gee, Capital $ 1,29,453.05
Total equity $ 1,29,453.05
Total liabilties and equity $ 2,21,509.94
Changes in equity
N Gee, Capital 1 july $ 1,20,000.00
Profit $ 10,753.05
 $ 1,30,753.05
Drawings-$ 1,300.00
N Gee, Capital 30 june $ 1,29,453.05
Jun-18
MonTuesWedThursFriSatSun
123
45678910
11121314151617
18192021222324
252627282930
Jul-18
MonTuesWedThursFriSatSun
1
2345678
9101112131415
16171819202122
23242526272829
3031
CreditDebit
Pay Dateper weekper hourno. hoursGross PayLess PAYGP HealthNet PayEm'r SuperWage Exp
B Gee $ 990.00 $ 990.00 $ 179.00 $ 22.00 $ 789.00 $ 94.05 $ 1,084.05990
N Rider3818 $ 684.00 $ 76.00 $ 608.00 $ 64.98 $ 748.98
Wage Payable $ 255.00 $ 22.00 $ 1,397.00 $ 159.03 $ 1,833.03
CreditDebit194
Pay Dateper weekper hourno. hoursGross PayLess PAYGP HealthNet PayEm'r SuperWage Exp
B Gee $ 990.00 $ 990.00 $ 179.00 $ 22.00 $ 789.00 $ 94.05 $ 1,084.05
N Rider3823 $ 874.00 $ 139.00 $ 735.00 $ 83.03 $ 957.03
Wage Payable $ 318.00 $ 22.00 $ 1,524.00 $ 177.08 $ 2,041.08
CreditDebit
Pay Dateper weekper hourno. hoursGross PayLess PAYGP HealthNet PayEm'r SuperWage Exp
B Gee $ 990.00 $ 990.00 $ 179.00 $ 22.00 $ 789.00 $ 94.05 $ 1,084.05
N Rider3821 $ 798.00 $ 112.00 $ 686.00 $ 75.81 $ 873.81
Wage Payable $ 291.00 $ 22.00 $ 1,475.00 $ 169.86 $ 1,957.86

Buy Acc106 The Ledger Accounts To Assessment Answers Online


Talk to our expert to get the help with Acc106 The Ledger Accounts To Assessment Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.


Get Online Support for Acc106 The Ledger Accounts To Assessment Answers Assignment Help Online


Copyright © 2009-2023 UrgentHomework.com, All right reserved.