USA: +1(669)289-8683 
Sign in
Hello, I need help with the attached following Quickbooks project.Must be done using Quickbooks 2013 version
>Sheet name: Phoenix 7892
: 10755 West 51st Street, New York NY 32561
: 212 555 2121
tax
s
$32,000 Loans
$1,500 al
$3,800 0
$1,200 $250 $850 $950 $2,000 s
Company Fax 0.00 American Building Supply American Building Supply , 0.00 BP Gas/Oil BP Gas/Oil 0.00 Brodkey’s Carpet One Floor & Home Brodkey’s Carpet One Floor & Home 0.00 Builders Supply Co Builders Supply Co Omaha, NE 68127 0.00 0.00 Chicago Lumber Co of Omaha Chicago Lumber Co of Omaha 750.00 0.00 Christensen Grading Co Christensen Grading Co Omaha, NE 68127 500.00 0.00 Curry Tool Co Curry Tool Co 0.00 Floor Fashions Inc Floor Fashions Inc Omaha, NE 68137 0.00 Hempel Accounting Service Hempel Accounting Service 0.00 0.00 Home Depot Home Depot 200.00 0.00 Larson Cement Stone Co Larson Cement Stone Co 0.00 Menards Menards 0.00 0.00 Millard Lighting Millard Lighting 0.00 Millard Lumber Millard Lumber 400.00 0.00 National Electric Co National Electric Co 0.00 0.00 Nebraska Furniture Mart Nebraska Furniture Mart Omaha, NE 68114 0.00 0.00 Northern Lights Distributors LLC Northern Lights Distributors LLC Omaha, NE 68137 0.00 Omaha Drywall Omaha Drywall 0.00 0.00 Omaha Electric Omaha Electric 0.00 Omaha Gas Omaha Gas 0.00 Omaha Public Power District Omaha Public Power District 0.00 0.00 Omaha Steaks Omaha Steaks Omaha, NE 68117 0.00 0.00 Omaha Tools Omaha Tools 0.00 Qwest Qwest 0.00 RBC Tile & Stone RBC Tile & Stone Omaha, NE 68127 s
22,900.00 21st Century NE 1,000.00 Altech Construction Co Omaha NE 0.00 0.00 ARB Construction Omaha NE 500.00 500.00 Archistructure Inc Omaha NE 68154 890.00 Arctic Insulation Omaha NE 23,000.00 Ayars & Ayars Inc. Omaha NE 68117 4,400.00 Barry Larson & Son Gen Cont Omaha NE 68134 2,500.00 2,500.00 Bates Construction NE 0.00 0.00 Bennett’s Construction NE 500.00 500.00 Builders Equity Group LTD Omaha NE 68144 6,500.00 Building Consultants Inc uth
NE 2,800.00 Caddy Holmes 0.00 0.00 Centaur Development Omaha NE 0.00 0.00 Charles Vrana & Son Constr Co Omaha NE 68117 500.00 500.00 Clairmont Construction Inc Omaha NE 68138 0.00 0.00 Clark Contracting Inc NE 890.00 890.00 Customized Construction Mead NE 68041 0.00 0.00 DK Construction Co Omaha NE 68134 650.00 Doublas Building LLC Omaha NE 9,000.00 E W Nash Building co Omaha NE 0.00 0.00 Eagle Builders Inc NE 4,400.00 4,400.00 Eddy Contracting Omaha NE 68137 0.00 0.00 Eriksen Construction Inc NE 0.00 0.00 F & B Constructors Inc Omaha NE 68127 400.00 400.00 Fisher Building Svc IA 0.00 0.00 Frazier Construction Co Eagle NE 68347 0.00 0.00 Graham Family Builders In NE 650.00 650.00 Hardy Construction Inc NE 8,900.00 Image Builders Inc Omaha NE 68116 5,500.00 Intelligent Buildings LLC NE 2,000.00 2,000.00 Jeffrey Bowdino Inc NE 0.00 0.00 Jorgensen Contracting Inc Blair NE 68008 44,000.00 Kiewit Building Group Inc Omaha NE 0.00 0.00 L & L Custom Builders Omaha NE 0.00 0.00 Lacey Construction Omaha NE 68117 0.00 0.00 Leuder Construction Co Omaha NE 68127 0.00 0.00 Matzen Construction Inc Blair NE 68008 0.00 0.00 Midlands Construction Svc Omaha NE 650.00 650.00 Mulder Building Group Omaha NE 68144 0.00 0.00 National Elevator Industry Inc Omaha NE 68107 250.00 250.00 Nelson-Hill Contracting Inc Omaha NE 0.00 0.00 Nielsen Construction Co Blair NE 68008 0.00 0.00 Novotny Builders Inc Blair NE 68008 0.00 0.00 Oakview Deck LLC Omaha NE 68130 0.00 0.00 Omega Wealth Builders Omaha NE 68134 0.00 0.00 Paul D Anderson Construction Blair NE 68008 650.00 650.00 Paulsen Builders IA 0.00 0.00 Peter Kiewit Sons’ Inc Omaha NE 4,600.00 Pohlmeier Construction Plattsmouth NE 68048 6,000.00 Prairie Construction Co Omaha NE 68144 Address State , St. Joe MO 98790 1 mo 1 00 annualy
Omaha NE 89012 bi-weekly 3 mo 3 St. Joe MO 45612 bi-weekly 5 mo 2 Omaha NE 65412 1-01-2000 bi-weekly 2 mo 1 $2,500 $950 $450 $350 $45 $1,200 10-Feb $100 $250 $450 $32,000 15-Feb $1,000 20-Feb $2,500 20-Feb $4,000 22-Feb $200 $450 $2,500 Truck Depreciation $4,000 $120 $400 $400 $32,000 $400 $250 mailto:lm@aol.com mailto:rwest@kc.rr.com mailto:rust.turner@surewest.com mailto:ssmith@aol.com2
1
Instructions
1. Use the Easy Step interview to create a new company
2.
Company
3
3. Tax id: 12-34
5
4.
Address
5. Phone 212 555 1212
Fax
6. Email: Phoenix1@phoenix1.com
7. Industry: Retail Shop or Online Commerce
8. Partnership
9. Fiscal year January
10. Business is services and products
11. Record sales individually
12. We do collect
Sales
13. We do create estimates in QuickBooks
14. We do not track sales orders before invoicing customers
15. We do want to use billing statements in QuickBooks.
16. We do not use progress invoicing
17. We do want to track the bills we owe.
18. We do not track inventory in QuickBooks
19. We do want to track time in QuickBooks
20. We have employees- yes for w-2 and 1099 contractors
21. Have system set of chart of accounts
22. Beginning start date 01-01-2011
23. Create the following accounts from the accounts tab
24. Create the following vendor list from the vendor list tab
25. Create the following customer list from the customer list tab
26. Create the following employee list from the employee tab.
27. Enter the following transactions in the check register from the transaction tab
28. After all entries are completed, print chart of accounts, balance sheet standard, statement of cash flows, customer balances, A/P aging summary, A/R summary and check detail
29. Submit reports by excel—create separate tab for each report and upload QuickBooks file to elearn
Beginning
Balance
Start date :
1/1/03
Accounts:
Checking
$21,35
0.00
Savings
$43,000.00
Investments
$32,000
Accounts Receivable
Equipment
$65,000
Inventory
Trucks/Vehicles
$48,000
Depreciation/vehicles
$4,000
Prepaid insurance
$1,500
Employee
$2,500
Accounts Payable
Gas Credit Card
$1,200
Amex CC
$1,800
Visa CC
$3,600
Payroll liabilities
$6,500
Sales Tax Payable
$3,800
Notes Payable
$6,900
owners equity
$22,000
Bad debt
Equipment
rent
$2,300
office supplies
$2,200
rent
$3,200
Taxes: Federal
$4,400
Taxes:
State
Taxes local
$2,600
Water Bill
$250
Electric
$45
Trash
$100
Admin expense
$500
Temp expense
Gas bill
Computer rental
$350
Training expense
$650
Marketing expense
$950
entertainment expense
$850
Interest from checking
$20
miscellaneous expense
legal fees
$2,000
Accounting fees
sales
Advertising expense
$5,000
benefits expense
$4,300
Vendor
Vendor Balance
Balance Total
Bill from 1
Bill from 2
Bill from 3
Primary Contact
Job Title
Main Phone
Alt. Phone
Secondary Contact
American Building Supply
500.00
8950 J St.
Omaha
NE
68127
402-339-4734
402-537-3130
BP Gas/Oil
750.00
14789 England
New York, NY 78901
212-564-8888
Brodkey’s Carpet One Floor & Home
2,000.00
13805 Industrial Road
Omaha, NE
68137
800-394-3064
Builders Supply Co
2,500.00
5701 S 72nd St
402-331-4500
402-331-4688
402-331-2944
Chicago Lumber Co of Omaha
1324 Pierce St
Omaha, NE 68108
402-342-0840
Christensen Grading Co
7920 Drexel St
401-592-8900
Curry Tool Co
8951 H St
Omaha, NE 8127
402-331-5850
Floor Fashions Inc
1,
200.00
11339 P St.
402-597-3161
Hempel Accounting Service
1,500.00
9222 Burt St
Omaha, NE 68114
402-334-2724
Home Depot
1356 Peachtree Blvd
Atlanta, GA 56763
567-456-1456
Larson Cement Stone Co
4508 S 28th St
Omaha, NE
68107
402-733-1879
Menards
250.00
708 N 72nd St
Omaha, NE
68154
402-431-4665
402-498-0936
402-431-6667
Millard Lighting
12678 West 140th St.
Omaha, NE 78912
402-956-0000
Millard Lumber
2,
400.00
12789 I Street
Omaha, NE 67812
Bob
402-675-8888
National Electric Co
4115 S 57th St
Omaha, NE
68117
402-341-4008
Nebraska Furniture Mart
700 S. 72nd St
402-397-6100
Northern Lights Distributors LLC
4020 S. 147th St
402-492-1731
Omaha Drywall
350.00
13530 Grover St
Omaha, NE 68145
402-449-0388
402-968-4034
Omaha Electric
12345 Omaha Avenue
Omaha NE
68116
402-657-2467
Omaha Gas
450.00
4567 Old England Road
Omaha, NE 62787
Shirley
402-697-1567
402-678-2222
Omaha Public Power District
600.00
402-536-4131
Omaha Steaks
4808 G St
402-731-0404
Omaha Tools
13737 Chandler Road
Omaha NE
68138
402-334-8188
402-334-8285
Qwest
4,500.00
800-960-2528
RBC Tile & Stone
2,100.00
10401 I St
402-331-0665
Customer
Customer Balance Balance Total Company Main Phone Fax
Bill to 1
Bill to 2
Bill to 3
Bill to 4
21st Century
22,900.00
402-624-5040
408 Cedar Street
Mead
68041
Altech Construction Co
1,000.00
402-758-9500
402-334-0466
14921 Industrial Rd
68144
ARB Construction
402-598-4396
3155 N 84th Circle
68134
Archistructure Inc
401-965-9058
402-965-9073
13520 California St #200
Arctic Insulation
890.00
402-457-5064
402-457-5243
8615 N. 29th Street
68112
Ayars & Ayars Inc.
23,000.00
402-453-8600
402-334-5489
7021 L Street
Barry Larson & Son Gen Cont
4,400.00
402-571-3838
402-571-3939
6060 Wenninghoff Road
Bates Construction
402-201-8695
18 S Allen
Valley
68064
Bennett’s Construction
402-427-7425
205 Main St
Kennard
68034
Builders Equity Group LTD
402-333-9200
11725 Arbor St. #240
Building Consultants Inc
6,500.00
402-298-8260
RR 3
Platts
mo
68048
Caddy Holmes
2,800.00
712-527-4265
1201 1st St #A
Glenwood
IA
51534
Centaur Development
402-597-2402
6905 N 94th Plz
68122
Charles Vrana & Son Constr Co
402-733-5200
402-733-5203
4816 F St
Clairmont Construction Inc
402-861-4490
8802 S 135th St #100
Clark Contracting Inc
402-780-6009
1371 Prairie View Rd
Eagle
68347
Customized Construction
402-624-3020
110 E 5th St
DK Construction Co
402-571-0344
402-571-4254
8102 Maple St
Doublas Building LLC
650.00
402-345-1236
1314 Douglas St
68102
E W Nash Building co
9,000.00
402-553-1011
402-553-1001
6846 Pacific St #101
68106
Eagle Builders Inc
402-965-9230
11726 Laura Ave
Belleue
68123
Eddy Contracting
402-895-7250
4930 S 124th St
Eriksen Construction Inc
402-426-3150
2546 S Highway 30
Blair
68008
F & B Constructors Inc
402-592-7430
402-592-1039
4344 S 87th St
Fisher Building Svc
712-847-0287
1101 Avenue H #H
Carter Lake
51510
Frazier Construction Co
402-440-6846
1380 Percheron Dr
Graham Family Builders In
402-289-2240
3812 N 211th St
Elkhorn
68022
Hardy Construction Inc
402-426-5812
7726 County Road P26
Fort Calhoun
68023
Image Builders Inc
8,900.00
402-871-9308
16134 Taylor St
Intelligent Buildings LLC
5,500.00
402-905-2534
1210 Limerick Rd
Papillion
68046
Jeffrey Bowdino Inc
402-301-8575
317 Bryan St
Gretna
68028
Jorgensen Contracting Inc
402-426-4440
401-426-8323
530 Front St
Kiewit Building Group Inc
44,000.00
402-977-4500
402-943-1460
3921 Mason St
68105
L & L Custom Builders
402-359-1770
1526 S 192nd Avenue Cir
68130
Lacey Construction
402-443-1112
4601 S 50th St #213
Leuder Construction Co
402-339-1000
402-592-4769
9999 J St #B
Matzen Construction Inc
402-426-4143
2402 Lincoln St
Midlands Construction Svc
402-659-4150
7521 Arrow Rock Dr
68157
Mulder Building Group
402-614-5464
15066 A Cir
National Elevator Industry Inc
402-734-0405
5418 S 27th St #3
Nelson-Hill Contracting Inc
402-493-3432
402-493-4906
3824 N 108th St
68164
Nielsen Construction Co
402-426-2059
402-426-8326
1730 State St
Novotny Builders Inc
402-436-1302
4136 County Road 37
Oakview Deck LLC
402-330-7475
402-330-8439
2618 S 156th Cir
Omega Wealth Builders
402-571-3330
6400 N 91st Plz
Paul D Anderson Construction
402-426-5810
206 Lords Ct
Paulsen Builders
712-343-2337
903 N Grandview Dr
Avoca
51521
Peter Kiewit Sons’ Inc
402-342-2052
402-271-2939
3555 Farnam St #1000
68131
Pohlmeier Construction
4,600.00
402-296-1388
1902 1st Ave
Prairie Construction Co
6,000.00
402-330-8522
402-330-8544
13316 B St
Employees
Employee Main Phone Alt. Phone
SS No.
City
Zip
Main Email
Date of Birth
Date of hire
pay frequency
federal Tax allowance
State worked
state Tax allowance
salary/hourly
Lute Mckiver
816-456-1234
816-456-6000
145-09-1200
4512 West Turner Ave
St. Joe
MO
98790
lm@aol.com
2-03-1960
1-01-2000
bi-weekly
$450
Rosy West
816-234-1234
123-00-1290
12678 Maple Ave Omaha, NE
89012
rwest@kc.rr.com
5-10-1950
4-10-2010
$60,000 annualy
Rusty Turner
913-555-1212
913-512-2000
123-45-9876
12891 Acot Blvd St. Joe, MO
45612
rust.turner@surewest.com
3-05-1988
12-15-1999
$12.00 hr
Sam Smith
402-890-1234
123-45-6789
1256 Webster St Omaha, NE
65412
ssmith@aol.com
12-13-1990
$14.50 hr
Transactions
1/5/03
paid employee expense
8-Jan
rent expenseense
10-Jan
Marketing expense
$1,000
15-Jan
truck/Car payment
25-Jan
paid electric bill
26-Jan
paid water bill
31-Jan
Sales $32,000
2-Feb
paid Millard lumber
10-Feb
paid accountant
$24,000
year end taxes
paid gas bill
12-Feb
paid amex cc
paid visa cc
13-Feb
sales
deposit
15-Feb
interest revenue
$200
truck registration fees
$420
20-Feb
Omaha steak gift cert
paid employee salaries
Truck Depreciation
22-Feb
Gas expense
$150
Telephone expense
$120
23-Feb
deposit $2,300
24-Feb
Paid National Electric supply
$400
27-Feb
received payment from Clark contracting
28-Feb
Tax refund check
$44,000
1-Mar
Pair marketing expense
5-Mar
Employee salary
7-Mar
9-Mar
telephone expense
9-Mar
Paid Amex cc
$600
Paid Visa CC
10-Mar
bought office supplies
12-Mar
revenue from sales
15-Mar
Miscellaneous expense
17-Mar
Revenue from employee loan
Sheet2
Sheet3
