please do all instruction. check page numbers for sorting

1 answer below »
please do all instruction. check page numbers for sorting

Answered Same DayAug 22, 2021

Answer To: please do all instruction. check page numbers for sorting

Abr Writing answered on Aug 31 2021
147 Votes
All Journals.docx
 
 
 
 
 
General Ledger [Summary].pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
General Ledger [Summary]
7/1/2015 To 7/31/2015
8/31/2019
8:27:05 AM
Page 1
Acct# Account Name Beginning Balance Total Debit Total Credit Net Activity Ending Balance
1-1110 Cheque Account $100,000.00 $44,287.10 $35,665.10 $8,622.00 $108,622.00
1-1120 Payroll Cheque Ac $0.00 $0.00 $0.00 $0.00 $0.00
1-1130 Cash Drawer $0.00 $0.00 $0.00 $0.00 $0.00
1-1140 Petty Cash $0.00 $0.00 $0.00 $0.00 $0.00
1-1180 Undeposited Fund $0.00 $0.00 $0.00 $0.00 $0.00
1-1190 Electronic Clearin $0.00 $0.00 $0.00 $0.00 $0.00
1-1200 Trade Debtors $0.00 $44,287.10 $44,287.10 $0.00 $0.00
1-1210 Less Prov'n for Do $0.00 $0.00 $0.00 $0.00 $0.00
1-1300 Inventory $0.00 $0.00 $0.00 $0.00 $0.00
1-1310 Clothing $0.00 $21,850.00 $17,036.70 $4,813.30 $4,813.30
1-1320 Assessories $0.00 $4,761.36 $3,604.79 $1,156.57 $1,156.57
1-1410 Prepayments $0.00 $3,266.66 $0.00 $3,266.66 $3,266.66
1-1420 Deposits Paid $0.00 $0.00 $0.00 $0.00 $0.00
1-1960 Voluntary Withhol $0.00 $0.00 $0.00 $0.00 $0.00
1-1970 ABN Withholding $0.00 $0.00 $0.00 $0.00 $0.00
1-2110 Store Fittings $12,250.00 $0.00 $0.00 $0.00 $12,250.00
1-2120 Store Fittings Acc $0.00 $0.00 $51.04 $51.04cr $51.04cr
1-2210 Store $235,440.00 $0.00 $0.00 $0.00 $235,440.00
1-2220 Store Accum Dep' $0.00 $0.00 $0.00 $0.00 $0.00
1-3310 Improvements at $0.00
$0.00 $0.00 $0.00 $0.00
1-3320 Improvements Am $0.00 $0.00 $0.00 $0.00 $0.00
2-1110 Bankcard $0.00 $0.00 $0.00 $0.00 $0.00
2-1120 Diners Club $0.00 $0.00 $0.00 $0.00 $0.00
2-1130 MasterCard $0.00 $0.00 $0.00 $0.00 $0.00
2-1140 Visa $0.00 $0.00 $0.00 $0.00 $0.00
2-1200 Trade Creditors $0.00 $24,972.50 $29,272.50 $4,300.00cr $4,300.00cr
2-1210 A/P Accrual - Inve $0.00 $0.00 $0.00 $0.00 $0.00
2-1310 GST Collected $0.00 $0.00 $4,026.10 $4,026.10cr $4,026.10cr
2-1330 GST Paid $0.00 $3,599.32 $0.00 $3,599.32 $3,599.32
2-1350 Fuel Tax Credits A $0.00 $0.00 $0.00 $0.00 $0.00
2-1355 WET Payable $0.00 $0.00 $0.00 $0.00 $0.00
2-1360 Import Duty Payab $0.00 $0.00 $0.00 $0.00 $0.00
2-1370 Voluntary Withhol $0.00 $0.00 $0.00 $0.00 $0.00
2-1380 ABN Withholdings $0.00 $0.00 $0.00 $0.00 $0.00
2-1390 Luxury Car Tax P $0.00 $0.00 $0.00 $0.00 $0.00
2-1410 Payroll Accruals P $0.00 $0.00 $0.00 $0.00 $0.00
2-1420 PAYG Withholding $0.00 $0.00 $0.00 $0.00 $0.00
2-1600 Client Deposits $0.00 $0.00 $0.00 $0.00 $0.00
2-1620 Other Current Liab $0.00 $0.00 $0.00 $0.00 $0.00
2-2100 Bank Loans $120,000.00cr $0.00 $0.00 $0.00 $120,000.00cr
2-2200 Other Long Term $0.00 $0.00 $0.00 $0.00 $0.00
3-1110 Capital $227,690.00cr $0.00 $0.00 $0.00 $227,690.00cr
3-1210 Drawings $0.00 $0.00 $0.00 $0.00 $0.00
3-8000 Retained Earnings $0.00 $0.00 $0.00 $0.00 $0.00
3-9000 Current Year Earn $0.00 $0.00 $0.00 $0.00 $0.00
3-9999 Historical Balancin $0.00 $0.00 $0.00 $0.00 $0.00
4-1100 Clothings $0.00 $0.00 $34,038.00 $34,038.00cr $34,038.00cr
4-1200 Accessories $0.00 $0.00 $6,223.00 $6,223.00cr $6,223.00cr
4-4000 Miscellaneous Inc $0.00 $0.00 $0.00 $0.00 $0.00
4-5000 Frieght Collected $0.00 $0.00 $0.00 $0.00 $0.00
4-6000 Late Fees Collect $0.00 $0.00 $0.00 $0.00 $0.00
4-8000 Mis Income $0.00 $0.00 $0.00 $0.00 $0.00
5-1100 Clothing $0.00 $17,036.70 $0.00 $17,036.70 $17,036.70
5-1200 Accessories $0.00 $3,604.79 $0.00 $3,604.79 $3,604.79
5-1300 Discount Given $0.00 $0.00 $0.00 $0.00 $0.00
6-1000 General & Ad Exp $0.00 $0.00 $0.00 $0.00 $0.00
6-1050 Accounting Fees $0.00 $0.00 $0.00 $0.00 $0.00
6-1100 Rates $0.00 $900.00 $0.00 $900.00 $900.00
6-1200 Bank Charges $0.00 $12.00 $0.00 $12.00 $12.00
6-1300 Depreciation $0.00 $51.04 $0.00 $51.04 $51.04
6-1400 Insurance $0.00 $733.34 $0.00 $733.34 $733.34
6-1500 Other supplies $0.00 $100.91 $0.00 $100.91 $100.91
Sweet Dreams
General Ledger [Summary]
7/1/2015 To 7/31/2015
8/31/2019
8:27:05 AM
Page 2
Acct# Account Name Beginning Balance Total Debit Total Credit Net Activity Ending Balance
6-1600 Discount Taken $0.00 $0.00 $0.00 $0.00 $0.00
6-1700 Frieght Paid $0.00 $120.00 $0.00 $120.00 $120.00
6-1800 Late fees paid $0.00 $0.00 $0.00 $0.00 $0.00
6-2010 Discounts Given $0.00 $0.00 $0.00 $0.00 $0.00
6-2020 Discounts Taken $0.00 $0.00 $0.00 $0.00 $0.00
6-2300 Freight Charges $0.00 $0.00 $0.00 $0.00 $0.00
6-2400 Insurance $0.00 $0.00 $0.00 $0.00 $0.00
6-2500 Late Fees Paid $0.00 $0.00 $0.00 $0.00 $0.00
6-3100 Advertisment $0.00 $720.00 $0.00 $720.00 $720.00
6-3110 In store promotion $0.00 $995.45 $0.00 $995.45 $995.45
6-4200 Cleaning $0.00 $200.00 $0.00 $200.00 $200.00
6-4300 Printing $0.00 $0.00 $0.00 $0.00 $0.00
6-4500 Telephone $0.00 $101.82 $0.00 $101.82 $101.82
6-4600 Utilities $0.00 $333.73 $0.00 $333.73 $333.73
6-4700 Maintainence Supl $0.00 $650.00 $0.00 $650.00 $650.00
6-4800 Store Supplies $0.00 $574.55 $0.00 $574.55 $574.55
6-4900 Spoilage $0.00 $0.00 $0.00 $0.00 $0.00
6-5105 FBT $0.00 $0.00 $0.00 $0.00 $0.00
6-5110 Staff Amenities $0.00 $0.00 $0.00 $0.00 $0.00
6-5120 Superannuation $0.00 $0.00 $0.00 $0.00 $0.00
6-5130 Wages & Salaries $0.00 $289.60 $0.00 $289.60 $289.60
6-5140 Workers' Compen $0.00 $0.00 $0.00 $0.00 $0.00
6-5300 Uniform $0.00 $756.36 $0.00 $756.36 $756.36
8-1000 Interest Income $0.00 $0.00 $0.00 $0.00 $0.00
8-2000 Other income $0.00 $0.00 $0.00 $0.00 $0.00
9-1000 Interest Expense $0.00 $0.00 $0.00 $0.00 $0.00
9-2000 Income Tax Expe $0.00 $0.00 $0.00 $0.00 $0.00
9-3000 Other expenses $0.00 $0.00 $0.00 $0.00 $0.00

Total: $174,204.33 $174,204.33

Items List Summary.pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
Items List [Summary]
9/1/2019
11:13:30 AM
Page 1
Item # Item Name Supplier Units On Hand Total Value Average Cost Current Price
ACC101 Slippers 104 $984.57 $9.467 $11.00
ACC102 Socks 172 $172.00 $1.00 $5.50
LOU001 Lounge wear Sets 124 $1,008.64 $8.1342 $13.20
ROB001 Robes 219 $2,036.39 $9.2986 $25.30
SLE001 Night wear Sets 99 $1,208.08 $12.2028 $29.70
SLE002 Nightwear Separates 123 $560.19 $4.5544 $9.90
Grand Total:

$5,969.87

Profit & Loss [Accrual].pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
Profit & Loss Statement
July 2015
8/31/2019
8:25:14 AM
Sales
Clothings $34,038.00
Accessories $6,223.00
Miscellaneous Income $0.00
Frieght Collected $0.00
Late Fees Collected $0.00
Mis Income $0.00
Total Sales $40,261.00
Cost of Sales
Clothing $17,036.70
Accessories $3,604.79
Discount Given $0.00
Total Cost of Sales $20,641.49
Gross Profit $19,619.51
Expenses
General & Ad Exp $0.00
Accounting Fees $0.00
Rates $900.00
Bank Charges $12.00
Depreciation $51.04
Insurance $733.34
Other supplies $100.91
Discount Taken $0.00
Frieght Paid $120.00
Late fees paid $0.00
Discounts Given $0.00
Discounts Taken $0.00
Freight Charges $0.00
Insurance $0.00
Late Fees Paid $0.00
Advertisment $720.00
In store promotions $995.45
Cleaning $200.00
Printing $0.00
Telephone $101.82
Utilities $333.73
Maintainence Suplies $650.00
Store Supplies $574.55
Spoilage $0.00
Employment Expenses
FBT $0.00
Staff Amenities $0.00
Superannuation $0.00
Wages & Salaries $289.60
Workers' Compensation $0.00
Uniform $756.36
Total Expenses $6,538.80
Operating Profit $13,080.71
Other Income
Interest Income $0.00
Other income $0.00
Total Other Income $0.00
Other Expenses
Interest Expense $0.00
Income Tax Expense $0.00
Other expenses $0.00
Sweet Dreams
Profit & Loss Statement
July 2015
8/31/2019
8:25:14 AM
Total Other Expenses $0.00
Net Profit / (Loss) $13,080.71

Purchases Detail.pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
Purchases [Item Detail]
July 2015
9/1/2019
11:13:08 AM
Page 1
Name ID# Date Quantity Amount Status Promised Date
ACC101 Slippers
Bits N pieces 00000001 7/1/2015 175 $1,575.00 Closed
Bits N pieces 00000006 7/15/2015 250 $2,386.36 Closed

Slippers Total: 425 $3,961.36
ACC102 Socks
Bits N pieces 00000001 7/1/2015 300 $300.00 Closed
Bits N pieces 00000006 7/15/2015 500 $500.00 Closed

Socks Total: 800 $800.00
LOU001 Lounge wear Sets
Every Wear 00000004 7/1/2015 200 $1,600.00 Closed
Every Wear 00000007 7/15/2015 200 $1,636.36 Open

Lounge wear Sets Total: 400 $3,236.36
ROB001 Robes
MAZ Supplies 00000003 7/1/2015 200 $2,000.00 Closed
MAZ Supplies 00000008 7/16/2015 250 $2,272.73 Open

Robes Total: 450 $4,272.73
SLE001 Night wear Sets
Sleepwear 00000002 7/1/2015 300 $4,500.00 Closed
Sleepwear 00000005 7/9/2015 500 $5,681.82 Closed

Night wear Sets Total: 800 $10,181.82
SLE002 Nightwear Separates
Sleepwear 00000002 7/1/2015 400 $2,000.00 Closed
Sleepwear 00000005 7/9/2015 500 $2,159.09 Closed

Nightwear Separates Total: 900 $4,159.09
Standard Balance Sheet.pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
Balance Sheet
As of July 2015
8/31/2019
8:22:50 AM
Assets
Current Assets
Cash On Hand
Cheque Account $108,622.00
Payroll Cheque Account $0.00
Cash Drawer $0.00
Petty Cash $0.00
Undeposited Funds $0.00
Electronic Clearing Account $0.00
Total Cash On Hand $108,622.00
Trade Debtors $0.00
Less Prov'n for Doubtful Debts $0.00
Inventory $0.00
Clothing $4,813.30
Assessories $1,156.57
Other Current Assets
Prepayments $3,266.66
Deposits Paid $0.00
Total Other Current Assets $3,266.66
Withholding Credits
Voluntary Withholding Credits $0.00
ABN Withholding Credits $0.00
Total Withholding Credits $0.00
Total Current Assets $117,858.53
Store Fittings
Store Fittings $12,250.00
Store Fittings Accum Dep'n ($51.04)
Total Store Fittings $12,198.96
Store
Store $235,440.00
Store Accum Dep'n $0.00
Total Store $235,440.00
Fixed Assets
Leasehold Improvements
Improvements at Cost $0.00
Improvements Amortisation $0.00
Total Leasehold Improvements $0.00
Total Fixed Assets $0.00
Total Assets $365,497.49
Liabilities
Current Liabilities
Credit Cards
Bankcard $0.00
Diners Club $0.00
MasterCard $0.00
Visa $0.00
Total Credit Cards $0.00
Trade Creditors $4,300.00
A/P Accrual - Inventory $0.00
GST Liabilities
GST Collected $4,026.10
GST Paid ($3,599.32)
Total GST Liabilities $426.78
Fuel Tax Credits Accrued $0.00
WET Payable $0.00
Import Duty Payable $0.00
Voluntary Withholdings Payable $0.00
ABN Withholdings Payable $0.00
Luxury Car Tax Payable $0.00
Payroll Liabilities
Payroll Accruals Payable $0.00
Sweet Dreams
Balance Sheet
As of July 2015
8/31/2019
8:22:50 AM
PAYG Withholding Payable $0.00
Total Payroll Liabilities $0.00
Client Deposits $0.00
Other Current Liabilities $0.00
Total Current Liabilities $4,726.78
Long Term Liabilities
Bank Loans $120,000.00
Other Long Term Liabilities $0.00
Total Long Term Liabilities $120,000.00
Total Liabilities $124,726.78
Net Assets

$240,770.71
Equity
Equity
Capital
Capital $227,690.00
Total Capital $227,690.00
Drawings
Drawings $0.00
Total Drawings $0.00
Total Equity $227,690.00
Retained Earnings $0.00
Current Year Earnings $13,080.71
Historical Balancing $0.00
Total Equity

$240,770.71
Statement of Cash Flow.pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
Statement of Cash Flow
July 2015
8/31/2019
8:38:48 AM
Cash Flow from Operating Activities
Net Income $13,080.71
Clothing ($4,813.30)
Assessories ($1,156.57)
Prepayments ($3,266.66)
Store Fittings Accum Dep'n $51.04
Trade Creditors $4,300.00
GST Collected $4,026.10
GST Paid ($3,599.32)
Net Cash Flows from Operating Activities $8,622.00
Cash Flow from Investing Activities
Net Cash Flows from Investing Activities $0.00
Cash Flow from Financing Activities
Net Cash Flows from Financing Activities $0.00
Net Increase/Decrease for the period $8,622.00
Cash at the Beginning of the period $100,000.00
Cash at the End of the period $108,622.00
Subledger to General Ledger [Detail].pdf
Sweet Dreams
Shop 380 AFB Canberra Centre Canerra ACT 2600
General Ledger [Detail]
7/1/2015 To 7/31/2015
9/1/2019
11:15:29 AM
Page 1
ID# Src Date Memo Debit Credit Job No. Net Activity Ending Balance
1-1110 Cheque Account
Beginning Balance: $100,000.00
1 CD 7/1/2015 In Store promoti $880.00 $99,120.00
1 CD 7/1/2015 Supplies $1,332.00 $97,788.00
2 CD 7/1/2015 Uniform Purcha $352.00 $97,436.00
3 CD 7/3/2015 Rates $2,970.00 $94,466.00
4 CD 7/3/2015 Insurnace $2,420.00 $92,046.00
5 CD 7/3/2015 Advertisment E $132.00 $91,914.00
26 CD 7/4/2015 Salary $72.40 $91,841.60
CR000001 CR 7/4/2015 Cash Sales for $2,789.60 $94,631.20
CR000002 CR 7/6/2015 Cash Sales for $5,316.30 $99,947.50
6 CD 7/7/2015 Uniform purchs $120.00 $99,827.50
CR000003 CR 7/9/2015 Cash Sales for $2,025.10 $101,852.60
10 CD 7/11/2015 Sleepwear $7,150.00 $94,702.60
27 CD 7/11/2015 Salary $72.40 $94,630.20
7 CD 7/11/2015 Bits N pieces $2,062.50 $92,567.70
8 CD 7/11/2015 Every Wear $1,760.00 $90,807.70
9 CD 7/11/2015 MAZ Supplies $2,200.00 $88,607.70
11 CD 7/14/2015 Uniform $120.00 $88,487.70
12 CD 7/14/2015 Advertisment $330.00 $88,157.70
CR000004 CR 7/14/2015 Cash Sales for $7,779.20 $95,936.90
13 CD 7/16/2015 In store promoti $215.00 $95,721.90
14 CD 7/17/2015 Store supplies $126.00 $95,595.90
15 CD 7/18/2015 Advertisment $330.00 $95,265.90
28 CD 7/18/2015 Salary $72.40 $95,193.50
16 CD 7/21/2015 Uniform $120.00 $95,073.50
17 CD 7/21/2015 Sleepwear $8,625.00 $86,448.50
CR000005 CR 7/21/2015 Cash Sales for $11,783.20 $98,231.70
18 CD 7/25/2015 Bits N pieces $3,175.00 $95,056.70
29 CD 7/25/2015 Salary $72.40 $94,984.30
19 CD 7/28/2015 Uniform $120.00 $94,864.30
CR000006 CR 7/28/2015 Cash Sales for $10,617.20 $105,481.50
20 CD 7/30/2015 Water charges $71.00 $105,410.50
21 CD 7/30/2015 Cleaning charg...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here