Solutions Manual for Computer Accounting with QuickBooks 2013 15e By Donna Kay (All Chapters, 100% Original Verified, A+ Grade) Excel Files Solutions Download Link is at The End of This File.
Computer Accounting with QuickBooks 2013 by Donna Kay
Go Paperless Documents 1. Download Go Paperless Document templates at www.myquickbooks.me. 2. Save your QuickBooks Documents to the templates using the following steps. Step 1
Go to www.myquickbooks.me.
Step 2
Select QB2013.
Step 3
Download the Go Paperless Documents template for the assignment you are completing (Chapter or Case).
Step 4
Open the Excel workbook. Select File > Save As. Use the filename: [YourFirstName LastName] [CH/CASE][No] DOCS. Example: YourFirstName LastName CH1 DOCS. Don't forget to use the same first name as appears on your instructor's classlist.
Step 5
Follow the instructions in your Computer Accounting with QuickBooks text until you are asked to print a document (such as a check or invoice). (Note: There are two sets of Go Paperless Excel templates: Go Paperless Reports templates and Go Paperless Documents templates. For REPORTS that can be exported to Excel, you will use a Go Paperless REPORTS template and not this DOCUMENTS template.) Ask your instructor if you should use a screen capture or a PDF to save the document paperlessly. This may depend upon the software you have available.
Step 6a
If you are saving PDF files using CutePDF, SnagIT, or Adobe, install the PDF software. Then from QuickBooks, select Print > Printer. Select the drop-down list to view the installed printers. Select the PDF software option > Print. Capture or copy the PDF file to the appropriate sheet in Excel. Note: Some documents can be printed as PDF files by selecting File menu > Save as PDF.
OR Step 6b
If you are saving screen captures, there are several different software options available for this. Ask your instructor which screen capture software you should use. Many computers come with screen capture software already installed, such as Grab, SnagIT, or Snipping Tool. Most keyboards have a Print Screen key so you can display the document on your screen and then select the Print Screen key. Although it may appear nothing has happened, the capture was copied to the clipboard. Place your cursor in the appropriate Excel sheet. Select Paste. The screen capture should appear in the sheet. Resize as needed.
Step 7
On the DOCS sheet, check off the deliverables that you have completed with an "x".
Step 8
Save your Excel workbook. See Step 4 above.
Step 9
Ask your instructor if you should email the Excel spreadsheet or use a courseware dropbox.
Computer Accounting with QuickBooks 2013 by Donna Kay
Chapter 1 Documents x x x x
Chapter 1 Export To Excel Help Exercise 1.2 Help Topic Printout Exercise 1.3 Your Choice Help Topic Printout Exercise 1.4 Intuit App Center Printout
Sheetname CH1 EXCEL HELP EX1.2 EX1.3 EX1.4
Students are to select a Help Topic of their choice and print out the information. The student may choose from a variety of help topics by clicking Help on the Menu bar, selecting QuickBooks Help, and typing in a request for information.
Intuit Marketplace offers a variety of apps that work with QuickBooks data. Students are to select an app of their choice from Intuit Marketplace and print out the information.
Computer Accounting with QuickBooks 2013 by Donna Kay
Go Paperless Reports Save your QuickBooks reports using the following steps. Step 1
Go to www.myquickbooks.me.
Step 2
Select QB2013.
Step 3
Download the Go Paperless Excel REPORTS template for the assignment you are completing (Chapter or Case).
Step 4
Open the Excel workbook. Select File > Save As. IMPORTANT! To receive credit for your work, use the filename: [YourFirstName LastName] [CH/CASE][No] REPORTS. Example: YourFirstName LastName CH1 REPORTS
Step 5
When your Computer Accounting with QuickBooks text asks you to print a report, use the Report Center to display the report on your screen.
Step 6
With the report displayed onscreen, select Excel > Update Existing Worksheet.
Step 7
Select Replace an existing worksheet.
Step 8
Browse for the Excel REPORTS template with your name in the filename.
Step 9
Select the correct sheetname from the drop-down list.
Step 10
Select Advanced.
Step 11
Uncheck Space between columns.
Step 12
Uncheck Include QuickBooks Export Guide worksheet with helpful advice.
Step 13
Click OK.
Step 14
Click Export.
Step 15
Select Yes if a message appears that you are replacing an existing worksheet with new data. Excel software should open on your screen with your QuickBooks report inserted into the correct sheet.
Step 16
On the REPORTS sheet, check the reports that you have completed with an "x". Failure to check the completed reports may result in a score of -0-.
Step 17
Save your Excel workbook using the appropriate file name. Select File > Save As. IMPORTANT! To receive credit for your work, use the filename: [YourFirstName LastName] [CH/CASE][No] REPORTS. Example: YourFirstName LastName CH1 REPORTS (Note: With some versions, you must close the workbook before inserting the next report.)
Step 18
Ask your instructor if you should email the Excel spreadsheet or use a courseware dropbox.
Good job!
Computer Accounting with QuickBooks 2013 by Donna Kay
Chapter 1 Reports x
Chapter 1 * Trial Balance
Sheetname CH1 TB
x x
Exercise 1.1 * Task 2: Profit & Loss Statement * Task 3: Balance Sheet
EX1.1.2 PL EX1.1.3 BS
Project 1 Reports x x x x
* * * *
Project 1 Profit & Loss Statement, Standard Profit & Loss Statement, Detail Balance Sheet, Standard Balance Sheet, Summary
Sheetname PR1.3 PL PR1.4 PL DET PR1.5 BS PR1.6 BS SUM
Accrual Basis
YourName Chapter 1 Rock Castle Construction
Trial Balance As of November 30, 2017 Nov 30, 17 Debit 10100 · YourName Checking
55,641.39
10300 · Savings
43,410.19
10400 · Petty Cash 11000 · Accounts Receivable 12000 · Undeposited Funds 12100 · Inventory Asset
500.00 83,547.91 0.00 27,872.63
12800 · Employee Advances
770.00
13100 · Pre-paid Insurance
0.00
13400 · Retainage Receivable
5,418.02
15000 · Furniture and Equipment
34,326.00
15100 · Vehicles
78,936.91
15200 · Buildings and Improvements
325,000.00
15300 · Construction Equipment
15,300.00
16900 · Land
90,000.00
17000 · Accumulated Depreciation 18700 · Security Deposits
Credit
110,344.60 1,720.00
20000 · Accounts Payable
58,345.02
20500 · QuickBooks Credit Card
25.00
20600 · CalOil Credit Card
436.80
24000 · Payroll Liabilities:24010 · Federal Withholding
841.00
24000 · Payroll Liabilities:24020 · FICA Payable
1,293.78
24000 · Payroll Liabilities:24030 · AEIC Payable
0.00
24000 · Payroll Liabilities:24040 · FUTA Payable
0.00
24000 · Payroll Liabilities:24050 · State Withholding 24000 · Payroll Liabilities:24060 · SUTA Payable
191.21 0.00
24000 · Payroll Liabilities:24070 · State Disability Payable
82.57
24000 · Payroll Liabilities:24080 · Worker's Compensation
805.83
24000 · Payroll Liabilities:24100 · Emp. Health Ins Payable
75.00
25500 · Sales Tax Payable
1,629.27
23000 · Loan - Vehicles (Van)
11,001.86
23100 · Loan - Vehicles (Utility Truck)
19,936.91
23200 · Loan - Vehicles (Pickup Truck)
22,641.00
28100 · Loan - Construction Equipment
13,911.32
28200 · Loan - Furniture/Office Equip
21,000.00
28700 · Note Payable - Bank of Anycity
2,693.21
28900 · Mortgage - Office Building
296,283.00
30000 · Opening Bal Equity
38,773.75
30100 · Capital Stock
500.00
32000 · Retained Earnings 40100 · Construction Income
61,756.76 0.00
40100 · Construction Income:40110 · Design Income
33,729.25
40100 · Construction Income:40130 · Labor Income
187,847.42
40100 · Construction Income:40140 · Materials Income
107,518.76
40100 · Construction Income:40150 · Subcontracted Labor Income 40100 · Construction Income:40199 · Less Discounts given
67,249.10 48.35
40500 · Reimbursement Income:40520 · Permit Reimbursement Income
1,223.75
40500 · Reimbursement Income:40530 · Reimbursed Freight & Delivery 50100 · Cost of Goods Sold 54000 · Job Expenses:54200 · Equipment Rental 54000 · Job Expenses:54300 · Job Materials
896.05 11,717.74 300.00 89,890.04
Page 1 of 2
Accrual Basis
YourName Chapter 1 Rock Castle Construction
Trial Balance As of November 30, 2017 Nov 30, 17 Debit 54000 · Job Expenses:54400 · Permits and Licenses
525.00
54000 · Job Expenses:54500 · Subcontractors
57,380.95
54000 · Job Expenses:54520 · Freight & Delivery
727.50
54000 · Job Expenses:54599 · Less Discounts Taken
201.81
60100 · Automobile:60110 · Fuel
1,507.08
60100 · Automobile:60120 · Insurance
2,850.24
60100 · Automobile:60130 · Repairs and Maintenance
2,406.00
60600 · Bank Service Charges
125.00
62100 · Insurance:62110 · Disability Insurance
582.06
62100 · Insurance:62120 · Liability Insurance
5,885.96
62100 · Insurance:62130 · Work Comp
12,442.76
62400 · Interest Expense:62420 · Loan Interest
1,963.07
62700 · Payroll Expenses:62710 · Gross Wages
96,551.65
62700 · Payroll Expenses:62720 · Payroll Taxes
7,386.20
62700 · Payroll Expenses:62730 · FUTA Expense
168.00
62700 · Payroll Expenses:62740 · SUTA Expense
1,123.50
63100 · Postage
Credit
35.00
64200 · Repairs:64220 · Computer Repairs
0.00
64200 · Repairs:64230 · Equipment Repairs
1,350.00
64800 · Tools and Machinery
2,010.68
65100 · Utilities:65110 · Gas and Electric
1,041.48
65100 · Utilities:65120 · Telephone
841.15
65100 · Utilities:65130 · Water
264.00
70100 · Other Income
103.27
70200 · Interest Income
229.16
TOTAL
1,061,566.46
1,061,566.46
Page 2 of 2
Accrual Basis
YourName Exercise 1.1 Rock Castle Construction
Profit & Loss November 2017 Nov 17 Ordinary Income/Expense Income 40100 · Construction Income 40130 · Labor Income
13,384.50
40140 · Materials Income
21,256.00
40150 · Subcontracted Labor Income
32,910.00
Total 40100 · Construction Income
67,550.50
40500 · Reimbursement Income 40520 · Permit Reimbursement Income Total 40500 · Reimbursement Income Total Income
225.00 225.00 67,775.50
Cost of Goods Sold 50100 · Cost of Goods Sold
2,127.16
54000 · Job Expenses 54200 · Equipment Rental 54300 · Job Materials 54400 · Permits and Licenses 54500 · Subcontractors 54599 · Less Discounts Taken Total 54000 · Job Expenses Total COGS Gross Profit
300.00 9,578.79 225.00 26,990.00 -106.40 36,987.39 39,114.55 28,660.95
Expense 60100 · Automobile 60110 · Fuel
111.80
60130 · Repairs and Maintenance
218.00
Total 60100 · Automobile
329.80
60600 · Bank Service Charges
12.50
62100 · Insurance 62110 · Disability Insurance
82.06
62120 · Liability Insurance
748.83
62130 · Work Comp
1,255.83
Total 62100 · Insurance
2,086.72
62400 · Interest Expense 62420 · Loan Interest
101.14
Total 62400 · Interest Expense
101.14
62700 · Payroll Expenses 62710 · Gross Wages
8,456.33
62720 · Payroll Taxes
646.89
62730 · FUTA Expense
0.00
62740 · SUTA Expense Total 62700 · Payroll Expenses
0.00 9,103.22
Page 1 of 2
Accrual Basis
YourName Exercise 1.1 Rock Castle Construction
Profit & Loss November 2017 Nov 17
64200 · Repairs 64220 · Computer Repairs Total 64200 · Repairs 64800 · Tools and Machinery
0.00 0.00 350.00
65100 · Utilities 65110 · Gas and Electric
97.53
65120 · Telephone
91.94
65130 · Water
24.00
Total 65100 · Utilities
213.47
Total Expense Net Ordinary Income
12,196.85 16,464.10
Other Income/Expense Other Income 70100 · Other Income Total Other Income Net Other Income Net Income
43.89 43.89 43.89 16,507.99
Page 2 of 2
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Invoice
08/25/2017 49
Invoice
12/19/2016 9
Invoice
04/11/2017 17
Invoice
05/02/2017 21
Sales Receipt
08/19/2017 6
Sales Receipt
10/15/2016 1
Invoice
10/17/2016 4
Invoice
12/09/2016 7
Sales Receipt
12/18/2016 4
Invoice
02/11/2017 12
Invoice
04/11/2017 17
Bill
04/24/2017
Invoice
07/09/2017 37
Invoice
07/21/2017 39
Invoice
08/20/2017 47
Invoice
08/20/2017 48
Invoice
08/22/2017 136
Invoice
08/23/2017 137
Invoice
08/25/2017 49
Invoice
09/03/2017 54
Invoice
09/24/2017 56
Paycheck
01/13/2017
Paycheck
01/13/2017
Paycheck
01/13/2017
Paycheck
01/27/2017
Paycheck
01/27/2017
Paycheck
01/27/2017
Paycheck
02/10/2017
Paycheck
02/10/2017
Paycheck
02/10/2017
Paycheck
02/24/2017
Paycheck
02/24/2017
Paycheck
02/24/2017
Paycheck
03/10/2017
Num
Adj
Total Retail Sales Service
Total Service Total Income Cost of Goods Sold Cost of Goods Sold
Total Cost of Goods Sold Total COGS Gross Profit Expense Payroll Expenses
Page 4 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Paycheck
03/10/2017
Paycheck
03/10/2017
Paycheck
03/24/2017
Paycheck
03/24/2017
Paycheck
03/24/2017
Paycheck
04/07/2017
Paycheck
04/07/2017
Paycheck
04/07/2017
Paycheck
04/21/2017
Paycheck
04/21/2017
Paycheck
04/21/2017
Paycheck
05/05/2017
Paycheck
05/05/2017
Paycheck
05/05/2017
Paycheck
05/19/2017
Paycheck
05/19/2017
Paycheck
05/19/2017
Paycheck
06/02/2017
Paycheck
06/02/2017
Paycheck
06/02/2017
Paycheck
06/16/2017
Paycheck
06/16/2017
Paycheck
06/16/2017
Paycheck
06/30/2017
Paycheck
06/30/2017
Paycheck
06/30/2017
Paycheck
07/14/2017
Paycheck
07/14/2017
Paycheck
07/14/2017
Paycheck
07/28/2017
Paycheck
07/28/2017
Paycheck
07/28/2017
Paycheck
08/11/2017
Paycheck
08/11/2017
Paycheck
08/11/2017
Paycheck
08/25/2017
Paycheck
08/25/2017
Paycheck
08/25/2017
Paycheck
09/08/2017
Paycheck
09/08/2017
Paycheck
09/08/2017
Paycheck
09/22/2017
Paycheck
09/22/2017
Paycheck
09/22/2017
Credit Card Charge
10/07/2016
Credit Card Charge
10/14/2016
Credit Card Charge
10/21/2016
Num
Adj
Total Payroll Expenses Automobile Fuel
Page 5 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Credit Card Charge
10/28/2016
Credit Card Charge
11/04/2016
Credit Card Charge
11/11/2016
Credit Card Charge
11/18/2016
Credit Card Charge
11/25/2016
Credit Card Charge
12/02/2016
Credit Card Charge
12/05/2016
Credit Card Charge
12/16/2016
Credit Card Charge
12/23/2016
Credit Card Charge
12/30/2016
Credit Card Charge
01/06/2017
Credit Card Charge
01/13/2017
Credit Card Charge
01/20/2017
Credit Card Charge
01/27/2017
Credit Card Charge
02/03/2017
Credit Card Charge
02/10/2017
Credit Card Charge
02/17/2017
Credit Card Charge
02/24/2017
Credit Card Charge
03/03/2017
Credit Card Charge
03/10/2017
Credit Card Charge
03/17/2017
Credit Card Charge
03/24/2017
Credit Card Charge
03/31/2017
Credit Card Charge
04/07/2017
Credit Card Charge
04/14/2017
Credit Card Charge
04/21/2017
Credit Card Charge
04/28/2017
Credit Card Charge
05/05/2017
Credit Card Charge
05/12/2017
Credit Card Charge
05/19/2017
Credit Card Charge
05/26/2017
Credit Card Charge
06/02/2017
Credit Card Charge
06/09/2017
Credit Card Charge
06/16/2017
Credit Card Charge
06/23/2017
Credit Card Charge
06/30/2017
Credit Card Charge
07/07/2017
Credit Card Charge
07/14/2017
Credit Card Charge
07/18/2017
Credit Card Charge
07/28/2017
Credit Card Charge
08/04/2017
Credit Card Charge
08/11/2017
Credit Card Charge
08/18/2017
Credit Card Charge
08/21/2017
Credit Card Charge
08/25/2017
Credit Card Charge
09/01/2017
Credit Card Charge
09/08/2017
Num
Adj
Total Fuel Total Automobile
Page 6 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Num
Adj
Bank Service Charges Check
10/15/2016 Debit
Check
10/24/2016 DED
Check
11/15/2016 Debit
Check
11/24/2016 DED
Check
12/15/2016 Debit
Check
12/24/2016 DED
Check
01/15/2017 Debit
Check
01/24/2017 DED
Check
02/15/2017 Debit
Check
02/24/2017 DED
Check
03/15/2017 Debit
Check
03/24/2017 DED
Check
04/15/2017 Debit
Check
04/24/2017 DED
Check
05/15/2017 Debit
Check
05/24/2017 DED
Check
06/15/2017 Debit
Check
06/24/2017 DED
Check
07/15/2017 Debit
Check
07/24/2017 DED
Check
08/15/2017 Debit
Check
08/22/2017 DED
Check
09/15/2017 Debit
Check
09/24/2017 DED
Bill
04/04/2017 GN-03-1234
Bill
06/25/2017
Bill
07/15/2017
Bill
08/21/2017
Bill
08/21/2017
General Journal
09/30/2017 A104
General Journal
05/31/2017 A100
General Journal
06/30/2017 A101
General Journal
07/31/2017 A102
General Journal
08/31/2017 A103
General Journal
09/30/2017 A105
Bill
10/16/2016 2
Bill
11/18/2016 3
Total Bank Service Charges Delivery Fee
Total Delivery Fee Depreciation Total Depreciation Insurance
Total Insurance Interest Expense
Page 7 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Num
Bill
12/16/2016 4
Bill
01/16/2017 5
Bill
02/17/2017 6
Bill
03/17/2017 7
Bill
04/16/2017 8
Bill
05/15/2017 9
Bill
06/16/2017 10
Bill
07/16/2017 11
Bill
08/15/2017 12
Bill
09/16/2017 13
Check
07/23/2017
Check
12/31/2016 1016
Bill
07/15/2017
Bill
04/04/2017 GN-03-1234
Invoice
04/11/2017 17
Bill
05/05/2017 GN-04-2168
Invoice
05/05/2017 22
Invoice
08/25/2017 49
Bill
04/08/2017
Paycheck
01/13/2017
Paycheck
01/27/2017
Paycheck
02/10/2017
Paycheck
02/24/2017
Paycheck
03/10/2017
Paycheck
03/24/2017
Paycheck
04/07/2017
Paycheck
04/21/2017
Paycheck
05/05/2017
Paycheck
05/19/2017
Paycheck
06/02/2017
Adj
Total Interest Expense Job Expenses Equipmental Rental Total Equipmental Rental Job Materials Decks & Patio
Total Decks & Patio Plants & Sod
Total Plants & Sod Sprinkler's & Drip Systems Total Sprinkler's & Drip Systems Total Job Materials Total Job Expenses Mileage Reimbursement
Page 8 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Num
Paycheck
06/16/2017
Paycheck
06/30/2017
Paycheck
07/14/2017
Paycheck
07/28/2017
Paycheck
08/11/2017
Paycheck
08/25/2017
Paycheck
09/08/2017
Paycheck
09/22/2017
Bill
08/19/2017
Check
05/13/2017
Bill
07/08/2017
Bill
09/30/2017 124a
Bill
10/14/2016
Bill
11/14/2016
Bill
12/14/2016
Bill
01/14/2017
Bill
02/14/2017
Bill
03/14/2017
Bill
04/14/2017
Bill
05/14/2017
Bill
06/14/2017 06/03
Bill
07/14/2017
Bill
08/14/2017
Bill
09/14/2017
Bill
10/21/2016 10/02
Bill
11/15/2016 11/02
Bill
12/15/2016 12/02
Bill
01/15/2017 01/03
Bill
02/15/2017 02/03
Bill
03/15/2017 03/03
Bill
04/15/2017 04/03
Bill
05/15/2017 05/03
Adj
Total Mileage Reimbursement Miscellaneous Total Miscellaneous Office Supplies
Total Office Supplies Repairs Computer Repairs Total Computer Repairs Total Repairs Utilities Gas and Electric
Total Gas and Electric Telephone
Page 9 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Type
Date
Num
Bill
06/15/2017 06/03
Bill
07/15/2017 07/03
Bill
08/15/2017 08/03
Bill
09/15/2017 09/03
Bill
10/04/2016 10/02
Bill
11/04/2016 11/02
Bill
12/04/2016 12/02
Bill
01/04/2017 01/03
Bill
02/04/2017 02/03
Bill
03/04/2017 03/03
Bill
04/04/2017 04/03
Bill
05/04/2017 05/03
Bill
06/04/2017 06/03
Bill
07/04/2017 07/03
Bill
08/04/2017 08/03
Bill
09/04/2017 09/03
Invoice
12/31/2016 FC 1
Adj
Total Telephone Water
Total Water Total Utilities Total Expense Net Ordinary Income Other Income/Expense Other Income Interest Income Total Interest Income Total Other Income Net Other Income Net Income
Page 10 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense Income Discounts Hermann, Jennifer:Residential Maintenance Total Discounts Landscaping Services Design Services Lo, David:Landscaping Lochrie, Steven Hermann, Jennifer:Residential Maintenance Total Design Services Job Materials Misc Materials Cheknis, Benjamin Total Misc Materials Decks & Patios Lee, Laurel:Lee Residence McCale, Ron:Residential Total Decks & Patios Fountains & Garden Lighting Lee, Laurel:Lee Residence Gregory, Dru Cheknis, Benjamin Lo, David:Landscaping McCale, Ron:Residential Lochrie, Steven Balak, Mike:330 Main St Balak, Mike:330 Main St Jasmine Park Molotsi, Hugh:6856 Ocean View Total Fountains & Garden Lighting Plants and Sod Sonnenschein, Russ Crenshaw, Bob Cheknis, Benjamin Lo, David:Landscaping Balak, Mike:Residential Morearty, Brian Tumacder, Jacint Hermann, Jennifer:Residential Maintenance Wood's Garden Cafe McCale, Ron:Residential Lochrie, Steven Balak, Mike:330 Main St Balak, Mike:330 Main St Lochrie, Steven
Page 11 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Heldt, Bob Jasmine Park Molotsi, Hugh:6856 Ocean View
Total Plants and Sod Sprinklers & Drip systems Walker, Rich Cheknis, Benjamin Lo, David:Landscaping McCale, Ron:Residential McCale, Ron:Residential Lochrie, Steven Molotsi, Hugh:1487 Silverbell Ave Jasmine Park Molotsi, Hugh:4697 W. Indian Trail Molotsi, Hugh:4697 W. Indian Trail Molotsi, Hugh:6856 Ocean View Total Sprinklers & Drip systems Total Job Materials Labor Installation Blackwell, Edward Gregory, Dru Blackwell, Edward Walker, Rich Blackwell, Edward Blackwell, Edward Cheknis, Benjamin Blackwell, Edward Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Lo, David:Landscaping Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Balak, Mike:Residential Chapman, Natalie Lo, David:4631 W Indian Trail Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Hermann, Jennifer:Residential Maintenance Lo, David:4631 W Indian Trail Corcoran, Carol Blackwell, Edward Cheknis, Benjamin McCale, Ron:Residential Hermann, Jennifer:Residential Maintenance
Page 12 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Lochrie, Steven Lo, David:4631 W Indian Trail Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Hermann, Jennifer:Residential Maintenance Molotsi, Hugh:1487 Silverbell Ave Jasmine Park Lo, David:4631 W Indian Trail Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Molotsi, Hugh:4697 W. Indian Trail Hermann, Jennifer:Residential Maintenance Molotsi, Hugh:6856 Ocean View Lo, David:4631 W Indian Trail Corcoran, Carol Blackwell, Edward Cheknis, Benjamin Balak, Mike:330 Main St
Total Installation Maintenance & Repairs Perry, Dave Muchemu, Margaret Tumacder, Jacint Cheknis, Benjamin Lo, David:Landscaping Andres, Cristina Hermann, Jennifer:Residential Maintenance Lochrie, Steven Hermann, Jennifer:Residential Maintenance Andres, Cristina Lo, David:4631 W Indian Trail Balak, Mike:330 Main St Balak, Mike:330 Main St Total Maintenance & Repairs Total Labor Total Landscaping Services Retail Sales Lee, Laurel:Lee Residence Sonnenschein, Russ Tumacder, Jacint Retail Sales Cheknis, Benjamin Chapman, Natalie Morearty, Brian McCale, Ron:Residential
Page 13 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Jasmine Park
Total Retail Sales Service Muchemu, Margaret Lo, David:Landscaping Balak, Mike:Residential Heldt, Bob Total Service Total Income Cost of Goods Sold Cost of Goods Sold Lee, Laurel:Lee Residence Gregory, Dru Walker, Rich Crenshaw, Bob Cheknis, Benjamin Lo, David:Landscaping Nolan Hardware and Supplies McCale, Ron:Residential Lochrie, Steven Molotsi, Hugh:1487 Silverbell Ave Balak, Mike:330 Main St Lochrie, Steven Heldt, Bob Jasmine Park Molotsi, Hugh:4697 W. Indian Trail Molotsi, Hugh:6856 Ocean View Total Cost of Goods Sold Total COGS Gross Profit Expense Payroll Expenses Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher
Page 14 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby Duncan Fisher Jenny Miller Shane B. Hamby
Total Payroll Expenses Automobile Fuel Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service
Page 15 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service Bayshore CalOil Service
Total Fuel Total Automobile
Page 16 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense Bank Service Charges Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Total Bank Service Charges Delivery Fee Gussman's Nursery Nolan Hardware and Supplies McCale, Ron:Residential Balak, Mike:330 Main St Balak, Mike:330 Main St Total Delivery Fee Depreciation Accumulated Depreciation Total Depreciation Insurance
Total Insurance Interest Expense Great Statewide Bank Great Statewide Bank
Page 17 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank Great Statewide Bank
Total Interest Expense Job Expenses Equipmental Rental Brown Equipment Rental Total Equipmental Rental Job Materials Decks & Patio Patio & Desk Designs McCale, Ron:Residential Total Decks & Patio Plants & Sod Corcoran, Carol Lo, David:Landscaping -MULTIPLEChapman, Natalie Jasmine Park Total Plants & Sod Sprinkler's & Drip Systems Conner Garden Supplies Total Sprinkler's & Drip Systems Total Job Materials Total Job Expenses Mileage Reimbursement Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller
Page 18 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller Jenny Miller
Total Mileage Reimbursement Miscellaneous Sowers Office Equipment Total Miscellaneous Office Supplies Sowers Office Equipment Sowers Office Equipment Total Office Supplies Repairs Computer Repairs Computer Services by DJ Total Computer Repairs Total Repairs Utilities Gas and Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Cal Gas & Electric Total Gas and Electric Telephone Cal Telephone Cal Telephone Cal Telephone Cal Telephone Cal Telephone Cal Telephone Cal Telephone Cal Telephone
Page 19 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Name Ordinary Income/Expense
Cal Telephone Cal Telephone Cal Telephone Cal Telephone
Total Telephone Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Bayshore Water Total Water Total Utilities Total Expense Net Ordinary Income Other Income/Expense Other Income Interest Income Blackwell, Edward Total Interest Income Total Other Income Net Other Income Net Income
Page 20 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo
Class
Clr
Ordinary Income/Expense Income Discounts 10% Discount
Landscaping
Custom Landscape Design
Landscaping
Custom Landscape Design
Design
Custom Landscape Design
Landscaping
-MULTIPLE-
Landscaping
Total Discounts Landscaping Services Design Services
Total Design Services Job Materials Misc Materials Total Misc Materials Decks & Patios Deck Lumber Deck Lumber
Landscaping
Total Decks & Patios Fountains & Garden Lighting Fountain pump Garden Lighting -MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
Garden Lighting
Landscaping
-MULTIPLE-
Landscaping
Custom rock fountain and sculpture
Landscaping
Garden Lighting
Landscaping
Garden Lighting Total Fountains & Garden Lighting Plants and Sod Citrus Tree - 50 gal., 2-Orange, 1, Grapefruit -MULTIPLE-MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
Citrus Tree - 50 gal.
Landscaping
Citrus Tree - 50 gal.
Landscaping
Citrus Tree - 50 gal.
Landscaping
Garden rocks - 60 lbs.
Landscaping
-MULTIPLE-
Landscaping
Citrus Tree - 50 gal.
Landscaping
-MULTIPLE-
Landscaping
Ornamental
Landscaping
-MULTIPLESoil, 2 cubic ft bag
Page 21 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Clr
Soil, 2 cubic ft bag -MULTIPLE-
Landscaping
Citrus Tree - 50 gal. Total Plants and Sod Sprinklers & Drip systems -MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
Sprinkler heads
Landscaping
Plastic sprinkler piping
Landscaping
-MULTIPLE-
Landscaping
-MULTIPLE-MULTIPLE-
Landscaping
Sprinkler heads Plastic sprinkler piping -MULTIPLETotal Sprinklers & Drip systems Total Job Materials Labor Installation Weekly gardening services
Maintenance
Installation of landscape design Weekly gardening services
Maintenance
Installation of landscape design
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Installation of landscape design
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Installation of landscape design
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Installation of landscape
Landscaping
Installation of landscape design Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Contract gardening services
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Installation of landscape design
Landscaping
Contract gardening services
Maintenance
Page 22 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Installation of landscape design
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
-MULTIPLE-
Landscaping
Clr
Installation of landscape design Installation of landscape design
Landscaping
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Installation of landscape design Contract gardening services
Maintenance
Installation of landscape design Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
Weekly gardening services
Maintenance
-MULTIPLE-
Maintenance
-MULTIPLE-
Maintenance
-MULTIPLE-
Maintenance
Tree and shrub trimming
Landscaping
Tree and shrub trimming
Landscaping
Total Installation Maintenance & Repairs
-MULTIPLEPest control services
Landscaping
Tree and shrub trimming
Landscaping
Pest control services
Landscaping
-MULTIPLE-MULTIPLE-
Maintenance
Pest control services
Landscaping
Pest control services
Maintenance
Total Maintenance & Repairs Total Labor Total Landscaping Services Retail Sales -MULTIPLE-MULTIPLE-MULTIPLELawn & Garden Fertilizer 20-14-7 -MULTIPLE-
Landscaping
Plant & Tree Fertilizer 6-6-10 Plant & Tree Fertilizer 6-6-10
Landscaping
-MULTIPLE-
Landscaping
Page 23 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
-MULTIPLE-
Landscaping
Tree Removal Service
Maintenance
Tree removal
Landscaping
Tree Removal Service
Landscaping
Clr
Total Retail Sales Service
Tree Removal Service - 2 Trees Total Service Total Income Cost of Goods Sold Cost of Goods Sold Fountain pump Garden Lighting -MULTIPLE-
Landscaping
Soil, 2 cubic ft bag -MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
Sprinkler head #BLS9081-09 -MULTIPLE-
Landscaping
-MULTIPLE-
Landscaping
-MULTIPLEGarden Lighting
Landscaping
Soil, 2 cubic ft bag Soil, 2 cubic ft bag -MULTIPLE-
Landscaping
-MULTIPLE-MULTIPLETotal Cost of Goods Sold Total COGS Gross Profit Expense Payroll Expenses Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping
Page 24 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Clr
Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead Landscaping Design Overhead
Total Payroll Expenses Automobile Fuel Landscaping Landscaping Landscaping
Page 25 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Clr
Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping Landscaping
Total Fuel Total Automobile
Page 26 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo
Class
Clr
Ordinary Income/Expense Bank Service Charges Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Monthly Service Charge
Overhead
Service Charge
Overhead
Surcharge for orders under $100
Overhead
Delivery Fee
Landscaping
Total Bank Service Charges Delivery Fee
Total Delivery Fee Depreciation Total Depreciation Insurance May portion of rider policy monthly alloc of rider pol, june July portion of rider pol rider policy, august sept rider policy Total Insurance Interest Expense Overhead Overhead
Page 27 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Clr
Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead
Total Interest Expense Job Expenses Equipmental Rental bulldozer fuel on return Total Equipmental Rental Job Materials Decks & Patio Rough Lumber
Landscaping
Tree, Citrus - 50 gal. Arizona Sweet
Landscaping
Fruit Tree - Apple
Landscaping
-MULTIPLE-
Landscaping
Fruit Tree - Orange, Lemon
Landscaping
Fruit Tree -
Landscaping
Total Decks & Patio Plants & Sod
Total Plants & Sod Sprinkler's & Drip Systems Total Sprinkler's & Drip Systems Total Job Materials Total Job Expenses Mileage Reimbursement Design Design Design Design Design Design Design Design Design Design Design
Page 28 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
Clr
Design Design Design Design Design Design Design Design
Total Mileage Reimbursement Miscellaneous New furniture
Overhead
Total Miscellaneous Office Supplies Printer ink Total Office Supplies Repairs Computer Repairs Overhead Total Computer Repairs Total Repairs Utilities Gas and Electric Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Overhead Total Gas and Electric Telephone (415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
Page 29 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Memo Ordinary Income/Expense
Class
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
(415)555-4567
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Acct #370C-99336622
Overhead
Clr
Total Telephone Water
Total Water Total Utilities Total Expense Net Ordinary Income Other Income/Expense Other Income Interest Income Finance Charges on Overdue Balance Total Interest Income Total Other Income Net Other Income Net Income
Page 30 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split
Debit
Credit
Balance
Ordinary Income/Expense Income Discounts Accounts Receivable Total Discounts
11.98 11.98
-11.98 0.00
-11.98
Accounts Receivable
55.00
55.00
Accounts Receivable
220.00
275.00
Accounts Receivable
55.00
330.00
330.00
330.00
11.25
11.25
11.25
11.25
Landscaping Services Design Services
Total Design Services
0.00
Job Materials Misc Materials Accounts Receivable Total Misc Materials
0.00
Decks & Patios Undeposited Funds
0.00
Accounts Receivable Total Decks & Patios
0.00
0.00 470.00
470.00
470.00
470.00
Fountains & Garden Lighting Undeposited Funds
75.00
75.00
Accounts Receivable
252.00
327.00
Accounts Receivable
1,885.00
2,212.00
Accounts Receivable
1,409.99
3,621.99
Accounts Receivable
455.00
4,076.99
Accounts Receivable
55.00
4,131.99
Accounts Receivable
555.00
4,686.99
Accounts Payable
175.00
4,511.99
Accounts Receivable
467.50
4,979.49
Accounts Receivable
300.00
5,279.49
5,454.49
5,279.49
Checking
198.00
198.00
Checking
233.25
431.25
Accounts Receivable
798.00
1,229.25
Accounts Receivable
534.00
1,763.25
Accounts Receivable
66.00
1,829.25
Accounts Receivable
66.00
1,895.25
Accounts Receivable
264.00
2,159.25
Accounts Receivable
9.75
2,169.00
Accounts Receivable
350.00
2,519.00
Accounts Receivable
198.00
2,717.00
Accounts Receivable
579.00
3,296.00
Accounts Receivable
72.50
3,368.50
Total Fountains & Garden Lighting
175.00
Plants and Sod
Accounts Payable Accounts Receivable
330.00
3,038.50 81.00
3,119.50
Page 31 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Accounts Receivable
94.50
3,214.00
Accounts Receivable
1,878.00
5,092.00
Accounts Receivable
198.00
5,290.00
5,620.00
5,290.00
Accounts Receivable
1,328.50
1,328.50
Accounts Receivable
248.75
1,577.25
Accounts Receivable
1,016.20
2,593.45
Total Plants and Sod
330.00
Sprinklers & Drip systems
Accounts Receivable
0.00
2,593.45
Accounts Receivable
176.00
2,769.45
Accounts Receivable
163.75
2,933.20
Accounts Receivable
154.25
3,087.45
712.50
3,799.95
Accounts Receivable Accounts Receivable
0.00
3,799.95
Accounts Receivable
134.75
3,934.70
Accounts Receivable
394.25
4,328.95
0.00
4,328.95
4,328.95
505.00
15,884.69
15,379.69
Accounts Receivable
480.00
480.00
Accounts Receivable
105.00
585.00
Accounts Receivable
480.00
1,065.00
Accounts Receivable
455.00
1,520.00
Accounts Receivable
480.00
2,000.00
Accounts Receivable
480.00
2,480.00
Accounts Receivable
315.00
2,795.00
Accounts Receivable
480.00
3,275.00
Accounts Receivable
240.00
3,515.00
Accounts Receivable
480.00
3,995.00
Accounts Receivable
300.00
4,295.00
Accounts Receivable
1,820.00
6,115.00
Accounts Receivable
240.00
6,355.00
Accounts Receivable
480.00
6,835.00
Accounts Receivable
300.00
7,135.00
Accounts Receivable
35.00
7,170.00
Accounts Receivable
70.00
7,240.00
Accounts Receivable
316.00
7,556.00
Accounts Receivable
240.00
7,796.00
Accounts Receivable
480.00
8,276.00
Accounts Receivable
300.00
8,576.00
Accounts Receivable
75.00
8,651.00
Accounts Receivable
316.00
8,967.00
Accounts Receivable
240.00
9,207.00
Accounts Receivable
480.00
9,687.00
Accounts Receivable
300.00
9,987.00
Accounts Receivable
525.00
10,512.00
Accounts Receivable
35.00
10,547.00
Total Sprinklers & Drip systems Total Job Materials Labor Installation
Page 32 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Accounts Receivable
315.00
10,862.00
Accounts Receivable
316.00
11,178.00
Accounts Receivable
240.00
11,418.00
Accounts Receivable
480.00
11,898.00
Accounts Receivable
300.00
12,198.00
Accounts Receivable
70.00
12,268.00
Accounts Receivable
490.00
12,758.00
Accounts Receivable
945.00
13,703.00
Accounts Receivable
316.00
14,019.00
Accounts Receivable
240.00
14,259.00
Accounts Receivable
480.00
14,739.00
Accounts Receivable
300.00
15,039.00
Accounts Receivable
490.00
15,529.00
Accounts Receivable
35.00
15,564.00
Accounts Receivable
910.00
16,474.00
Accounts Receivable
316.00
16,790.00
Accounts Receivable
240.00
17,030.00
Accounts Receivable
480.00
17,510.00
Accounts Receivable
300.00
17,810.00
Accounts Receivable
140.00
17,950.00
17,950.00
17,950.00
Accounts Receivable
250.00
250.00
Accounts Receivable
150.00
400.00
Accounts Receivable
215.00
615.00
Accounts Receivable
35.00
650.00
Accounts Receivable
140.00
790.00
Accounts Receivable
108.50
898.50
Accounts Receivable
35.00
933.50
Accounts Receivable
70.00
1,003.50
Accounts Receivable
200.00
1,203.50
Accounts Receivable
108.50
1,312.00
Accounts Receivable
193.00
1,505.00
Accounts Receivable
40.00
1,545.00
Accounts Receivable
40.00
1,585.00
0.00
1,585.00
1,585.00
0.00
19,535.00
19,535.00
505.00
35,749.69
35,244.69
Undeposited Funds
33.80
33.80
Checking
57.17
90.97
Checking
50.41
141.38
Checking
22.68
164.06
Accounts Receivable
30.82
194.88
Accounts Receivable
7.45
202.33
Accounts Receivable
5.96
208.29
Accounts Receivable
27.84
236.13
Total Installation
0.00
Maintenance & Repairs
Total Maintenance & Repairs Total Labor Total Landscaping Services Retail Sales
Page 33 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Accounts Receivable
Credit
Balance
165.44
401.57
401.57
401.57
Accounts Receivable
485.00
485.00
Accounts Receivable
650.00
1,135.00
Accounts Receivable
378.00
1,513.00
Checking
900.00
2,413.00
0.00
2,413.00
2,413.00
516.98
38,564.26
38,047.28
Total Retail Sales
0.00
Service
Total Service Total Income Cost of Goods Sold Cost of Goods Sold Undeposited Funds
56.00
Accounts Receivable
120.00
176.00
Accounts Receivable
961.80
1,137.80
Checking
78.00
1,215.80
Accounts Receivable
329.35
1,545.15
Accounts Receivable
977.80
2,522.95
Accounts Payable
8.75
2,531.70
Accounts Receivable
311.17
2,842.87
Accounts Receivable
233.21
3,076.08
Accounts Receivable
161.74
3,237.82
Accounts Receivable
120.00
3,357.82
Accounts Receivable
63.60
3,421.42
Accounts Receivable
74.20
3,495.62
Accounts Receivable
548.15
4,043.77
Accounts Receivable
161.74
4,205.51
Accounts Receivable
351.22
Total Cost of Goods Sold Total COGS Gross Profit
56.00
4,556.73
4,556.73
0.00
4,556.73
4,556.73
0.00
4,556.73
5,073.71
38,564.26
33,490.55
Expense Payroll Expenses Checking
1,570.44
1,570.44
Checking
1,903.96
3,474.40
Checking
2,407.30
5,881.70
Checking
1,541.29
7,422.99
Checking
1,801.07
9,224.06
Checking
2,277.20
11,501.26
Checking
1,570.44
13,071.70
Checking
1,903.97
14,975.67
Checking
2,407.31
17,382.98
Checking
1,569.15
18,952.13
Checking
1,801.07
20,753.20
Checking
2,277.22
23,030.42
Checking
1,570.44
24,600.86
Page 34 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Checking
1,903.96
26,504.82
Checking
2,407.30
28,912.12
Checking
1,570.44
30,482.56
Checking
1,903.97
32,386.53
Checking
2,317.41
34,703.94
Checking
1,570.44
36,274.38
Checking
1,819.99
38,094.37
Checking
2,277.22
40,371.59
Checking
1,541.29
41,912.88
Checking
1,801.07
43,713.95
Checking
2,277.20
45,991.15
Checking
1,491.72
47,482.87
Checking
1,801.08
49,283.95
Checking
2,277.20
51,561.15
Checking
1,569.15
53,130.30
Checking
1,801.07
54,931.37
Checking
2,277.20
57,208.57
Checking
1,485.57
58,694.14
Checking
1,801.07
60,495.21
Checking
2,277.20
62,772.41
Checking
1,485.57
64,257.98
Checking
1,801.07
66,059.05
Checking
2,277.21
68,336.26
Checking
1,485.57
69,821.83
Checking
1,801.07
71,622.90
Checking
2,277.21
73,900.11
Checking
1,485.57
75,385.68
Checking
1,801.07
77,186.75
Checking
2,277.21
79,463.96
Checking
1,541.28
81,005.24
Checking
1,801.07
82,806.31
Checking
2,277.22
85,083.53
Checking
1,485.57
86,569.10
Checking
1,801.07
88,370.17
Checking
2,277.20
90,647.37
Checking
1,569.16
92,216.53
Checking
1,801.07
94,017.60
Checking
2,277.20
96,294.80
Checking
1,485.57
97,780.37
Checking
1,801.07
99,581.44
Checking
2,277.21
101,858.65
Checking
1,485.57
103,344.22
Checking
1,801.07
105,145.29
Checking Total Payroll Expenses
2,277.21 107,422.50
107,422.50 0.00
107,422.50
Automobile Fuel CalOil Card
27.00
27.00
CalOil Card
22.71
49.71
CalOil Card
22.80
72.51
Page 35 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Total Fuel Total Automobile
Debit
Credit
Balance
CalOil Card
26.25
98.76
CalOil Card
19.21
117.97
CalOil Card
27.27
145.24
CalOil Card
26.00
171.24
CalOil Card
25.00
196.24
CalOil Card
25.00
221.24
CalOil Card
27.00
248.24
CalOil Card
29.50
277.74
CalOil Card
26.50
304.24
CalOil Card
25.50
329.74
CalOil Card
18.75
348.49
CalOil Card
19.80
368.29
CalOil Card
20.50
388.79
CalOil Card
21.00
409.79
CalOil Card
24.50
434.29
CalOil Card
26.25
460.54
CalOil Card
26.00
486.54
CalOil Card
25.00
511.54
CalOil Card
25.00
536.54
CalOil Card
26.00
562.54
CalOil Card
27.00
589.54
CalOil Card
26.00
615.54
CalOil Card
25.00
640.54
CalOil Card
25.00
665.54
CalOil Card
27.00
692.54
CalOil Card
26.50
719.04
CalOil Card
24.00
743.04
CalOil Card
24.50
767.54
CalOil Card
25.00
792.54
CalOil Card
25.25
817.79
CalOil Card
26.75
844.54
CalOil Card
24.75
869.29
CalOil Card
25.00
894.29
CalOil Card
26.50
920.79
CalOil Card
26.00
946.79
CalOil Card
28.50
975.29
CalOil Card
26.00
1,001.29
CalOil Card
25.00
1,026.29
CalOil Card
26.00
1,052.29
CalOil Card
25.00
1,077.29
CalOil Card
26.50
1,103.79
CalOil Card
26.50
1,130.29
CalOil Card
24.70
1,154.99
CalOil Card
26.50
1,181.49
CalOil Card
26.50
1,207.99
CalOil Card
22.00
1,229.99
CalOil Card
26.50
1,256.49
1,256.49
0.00
1,256.49
1,256.49
0.00
1,256.49
Page 36 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split
Debit
Credit
Balance
Ordinary Income/Expense Bank Service Charges Savings
7.50
7.50
Checking
18.00
25.50
Savings
7.50
33.00
Checking
18.00
51.00
Savings
7.50
58.50
Checking
18.00
76.50
Savings
7.50
84.00
Checking
18.00
102.00
Savings
7.50
109.50
Checking
18.00
127.50
Savings
7.50
135.00
Checking
18.00
153.00
Savings
7.50
160.50
Checking
18.00
178.50
Savings
7.50
186.00
Checking
18.00
204.00
Savings
7.50
211.50
Checking
18.00
229.50
Savings
7.50
237.00
Checking
18.00
255.00
Savings
7.50
262.50
Checking
18.00
280.50
Savings
7.50
288.00
Checking
18.00
306.00
Total Bank Service Charges
306.00
0.00
306.00
Delivery Fee Accounts Payable
25.00
25.00
Accounts Payable
25.00
50.00
Accounts Payable
25.00
75.00
Accounts Payable
45.00
120.00
Accounts Payable
40.00
160.00
Total Delivery Fee
160.00
0.00
160.00
Depreciation Accumulated Depreciation Total Depreciation
575.00 575.00
575.00 0.00
575.00
Insurance Prepaid Insurance
100.00
100.00
Prepaid Insurance
100.00
200.00
Prepaid Insurance
100.00
300.00
Prepaid Insurance
100.00
400.00
Prepaid Insurance
100.00
Total Insurance
500.00
500.00 0.00
500.00
Interest Expense Accounts Payable
132.35
132.35
Accounts Payable
127.16
259.51
Page 37 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Accounts Payable
121.91
381.42
Accounts Payable
116.62
498.04
Accounts Payable
111.28
609.32
Accounts Payable
105.89
715.21
Accounts Payable
100.46
815.67
Accounts Payable
94.97
910.64
Accounts Payable
89.43
1,000.07
Accounts Payable
83.84
1,083.91
Accounts Payable
78.20
1,162.11
Accounts Payable
72.51
1,234.62
Total Interest Expense
1,234.62
0.00
1,234.62
Job Expenses Equipmental Rental Cash Expenditures Total Equipmental Rental
48.90 48.90
48.90 0.00
48.90
Job Materials Decks & Patio Checking Accounts Payable Total Decks & Patio
1,150.00
1,150.00
390.00
1,540.00
1,540.00
0.00
1,540.00
Plants & Sod Accounts Payable
92.00
Accounts Receivable Accounts Payable
542.00
Accounts Receivable Accounts Receivable Total Plants & Sod
92.00 55.00
37.00 579.00
110.00
469.00
220.00
249.00
634.00
385.00
249.00
0.00
0.00
0.00
2,174.00
385.00
1,789.00
2,222.90
385.00
1,837.90
Sprinkler's & Drip Systems Accounts Payable Total Sprinkler's & Drip Systems Total Job Materials Total Job Expenses
0.00
Mileage Reimbursement Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Page 38 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
0.00
Checking
0.00
Total Mileage Reimbursement
0.00
0.00 0.00
0.00
Miscellaneous Accounts Payable Total Miscellaneous
847.00 847.00
847.00 0.00
847.00
Office Supplies Cash Expenditures
25.87
25.87
Accounts Payable
270.00
295.87
Total Office Supplies
295.87
0.00
295.87
Repairs Computer Repairs Accounts Payable Total Computer Repairs Total Repairs
75.00
75.00
75.00
0.00
75.00
75.00
0.00
75.00
Utilities Gas and Electric Accounts Payable
137.50
137.50
Accounts Payable
133.26
270.76
Accounts Payable
143.33
414.09
Accounts Payable
156.22
570.31
Accounts Payable
122.51
692.82
Accounts Payable
113.89
806.71
Accounts Payable
118.50
925.21
Accounts Payable
121.46
1,046.67
Accounts Payable
125.66
1,172.33
Accounts Payable
141.15
1,313.48
Accounts Payable
158.74
1,472.22
Accounts Payable Total Gas and Electric
132.40 1,604.62
1,604.62 0.00
1,604.62
Telephone Accounts Payable
45.00
Accounts Payable
51.60
45.00 96.60
Accounts Payable
74.16
170.76
Accounts Payable
66.56
237.32
Accounts Payable
52.48
289.80
Accounts Payable
72.74
362.54
Accounts Payable
81.09
443.63
Accounts Payable
67.55
511.18
Page 39 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Profit & Loss Detail October 2016 through September 2017 Split Ordinary Income/Expense
Debit
Credit
Balance
Accounts Payable
59.48
570.66
Accounts Payable
45.00
615.66
Accounts Payable
45.00
660.66
Accounts Payable
45.00
Total Telephone
705.66
705.66 0.00
705.66
Water Accounts Payable
25.32
25.32
Accounts Payable
22.16
47.48
Accounts Payable
24.07
71.55
Accounts Payable
26.89
98.44
Accounts Payable
27.80
126.24
Accounts Payable
29.78
156.02
Accounts Payable
33.56
189.58
Accounts Payable
38.75
228.33
Accounts Payable
44.12
272.45
Accounts Payable
52.15
324.60
Accounts Payable
57.38
381.98
Accounts Payable
54.63
Total Water Total Utilities Total Expense Net Ordinary Income
436.61
436.61
0.00
436.61
2,746.89
0.00
2,746.89
117,642.27
385.00
117,257.27
122,715.98
38,949.26
-83,766.72
6.58
6.58
0.00
6.58
6.58
0.00
6.58
6.58
0.00
6.58
6.58
122,715.98
38,955.84
-83,760.14
Other Income/Expense Other Income Interest Income Accounts Receivable Total Interest Income Total Other Income Net Other Income Net Income
Page 40 of 40
Accrual Basis
YourName Project 1 Larry's Landscaping
Balance Sheet As of September 30, 2017 Sep 30, 17 ASSETS Current Assets Checking/Savings Checking Cash Expenditures Savings Total Checking/Savings
108,030.44 225.23 20,510.00 128,765.67
Accounts Receivable Accounts Receivable
4,306.94
Total Accounts Receivable
4,306.94
Other Current Assets Prepaid Insurance
700.00
Inventory Asset
6,613.17
Undeposited Funds
-1,859.70
Total Other Current Assets
5,453.47
Total Current Assets
138,526.08
Fixed Assets Truck Accumulated Depreciation
-1,725.00
Original Purchase
13,750.00
Total Truck
12,025.00
Total Fixed Assets
12,025.00
TOTAL ASSETS
150,551.08
LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable Accounts Payable
1,056.32
Total Accounts Payable
1,056.32
Credit Cards CalOil Card Total Credit Cards
1,355.49 1,355.49
Other Current Liabilities Payroll Liabilities
4,172.74
Payments on Account
-1,520.00
Sales Tax Payable
1,207.46
Total Other Current Liabilities
3,860.20
Total Current Liabilities
6,272.01
Long Term Liabilities
Page 1 of 2
Accrual Basis
YourName Project 1 Larry's Landscaping
Balance Sheet As of September 30, 2017 Sep 30, 17 Bank of Anycity Loan
20,801.07
Equipment Loan
4,343.11
Bank Loan Total Long Term Liabilities Total Liabilities
7,283.56 32,427.74 38,699.75
Equity Opening Bal Equity
151,970.07
Retained Earnings
43,641.40
Net Income
-83,760.14
Total Equity TOTAL LIABILITIES & EQUITY
111,851.33 150,551.08
Page 2 of 2
Accrual Basis
YourName Project 1 Larry's Landscaping
Summary Balance Sheet As of September 30, 2017 Sep 30, 17 ASSETS Current Assets Checking/Savings
128,765.67
Accounts Receivable
4,306.94
Other Current Assets
5,453.47
Total Current Assets
138,526.08
Fixed Assets
12,025.00
TOTAL ASSETS
150,551.08
LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable
1,056.32
Credit Cards
1,355.49
Other Current Liabilities
3,860.20
Total Current Liabilities
6,272.01
Long Term Liabilities
32,427.74
Total Liabilities
38,699.75
Equity
111,851.33
TOTAL LIABILITIES & EQUITY
150,551.08
Page 1 of 1
Computer Accounting with QuickBooks 2013 by Donna Kay
Go Paperless Documents 1. Download Go Paperless Document templates at www.myquickbooks.me. 2. Save your QuickBooks Documents to the templates using the following steps. Step 1
Go to www.myquickbooks.me.
Step 2
Select QB2013.
Step 3
Download the Go Paperless Documents template for the assignment you are completing (Chapter or Case).
Step 4
Open the Excel workbook. Select File > Save As. Use the filename: [YourFirstName LastName] [CH/CASE][No] DOCS. Example: YourFirstName LastName CH1 DOCS. Don't forget to use the same first name as appears on your instructor's classlist.
Step 5
Follow the instructions in your Computer Accounting with QuickBooks text until you are asked to print a document (such as a check or invoice). (Note: There are two sets of Go Paperless Excel templates: Go Paperless Reports templates and Go Paperless Documents templates. For REPORTS that can be exported to Excel, you will use a Go Paperless REPORTS template and not this DOCUMENTS template.) Ask your instructor if you should use a screen capture or a PDF to save the document paperlessly. This may depend upon the software you have available.
Step 6a
If you are saving PDF files using CutePDF, SnagIT, or Adobe, install the PDF software. Then from QuickBooks, select Print > Printer. Select the drop-down list to view the installed printers. Select the PDF software option > Print. Capture or copy the PDF file to the appropriate sheet in Excel. Note: Some documents can be printed as PDF files by selecting File menu > Save as PDF.
OR Step 6b If you are saving screen captures, there are several different software options available for this. Ask your instructor which screen capture software you should use. Many computers come with screen capture software already installed, such as Grab, SnagIT, or Snipping Tool. Most keyboards have a Print Screen key so you can display the document on your screen and then select the Print Screen key. Although it may appear nothing has happened, the capture was copied to the clipboard. Place your cursor in the appropriate Excel sheet. Select Paste. The screen capture should appear in the sheet. Resize as needed. Step 7
On the DOCS sheet, check off the deliverables that you have completed with an "x".
Step 8
Save your Excel workbook. See Step 4 above.
Step 9
Ask your instructor if you should email the Excel spreadsheet or use a courseware dropbox.
Computer Accounting with QuickBooks 2013 by Donna Kay
Chapter 2 Documents x x x
Exercise 2.3 Your Choice: List of Industry-Specific Features Exercise 2.4 Schedule C Tax Form 1120S Tax Form
Sheetname EX2.3.1 QB ED EX2.4.1 SCH C EX2.4.2 1120S
Students are to select two sample companies of their choice (other than a sample product-based business or a sample service-based business) and list the different industry-specific features.
Computer Accounting with QuickBooks 2013 by Donna Kay
Go Paperless Reports Save your QuickBooks reports using the following steps. Step 1
Go to www.myquickbooks.me.
Step 2
Select QB2013.
Step 3
Download the Go Paperless Excel REPORTS template for the assignment you are completing (Chapter or Case).
Step 4
Open the Excel workbook. Select File > Save As. IMPORTANT! To receive credit for your work, use the filename: [YourFirstName LastName] [CH/CASE][No] REPORTS. Example: YourFirstName LastName CH1 REPORTS
Step 5
When your Computer Accounting with QuickBooks text asks you to print a report, use the Report Center to display the report on your screen.
Step 6
With the report displayed onscreen, select Excel > Update Existing Worksheet.
Step 7
Select Replace an existing worksheet.
Step 8
Browse for the Excel REPORTS template with your name in the filename.
Step 9
Select the correct sheetname from the drop-down list.
Step 10
Select Advanced.
Step 11
Uncheck Space between columns.
Step 12
Uncheck Include QuickBooks Export Guide worksheet with helpful advice.
Step 13
Click OK.
Step 14
Click Export.
Step 15
Select Yes if a message appears that you are replacing an existing worksheet with new data. Excel software should open on your screen with your QuickBooks report inserted into the correct sheet.
Step 16
On the REPORTS sheet, check the reports that you have completed with an "x". Failure to check the completed reports may result in a score of -0-.
Step 17
Save your Excel workbook using the appropriate file name. Select File > Save As. IMPORTANT! To receive credit for your work, use the filename: [YourFirstName LastName] [CH/CASE][No] REPORTS. Example: YourFirstName LastName CH1 REPORTS (Note: With some versions, you must close the workbook before inserting the next report.)
Step 18
Ask your instructor if you should email the Excel spreadsheet or use a courseware dropbox.
Good job!
Computer Accounting with QuickBooks 2013 by Donna Kay
Chapter 2 Reports Chapter 2 x x x x
Sheetname
* Chart of Accounts (Account Listing) Exercise 2.1 * Task 3: Statement of Cash Flows * Task 4: To Do List Exercise 2.2
CH2 COA
* Task 3: Revised Chart of Accounts
EX2.2.3 COA
EX2.1.3 SCF EX2.1.4 To Do
Project 2 Reports x x
* *
Project 2 Chart of Accounts (Account Listing) Statement of Cash Flows
Sheetname PR2.6 COA PR2.7 SCF
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Account
Type
Balance Total
10100 · YourName Checking
Bank
46,969.10
10300 · Savings
Bank
17,910.19
10400 · Petty Cash
Bank
11000 · Accounts Receivable
Accounts Receivable
12000 · Undeposited Funds
Other Current Asset
2,440.00
12100 · Inventory Asset
Other Current Asset
30,683.38
12800 · Employee Advances
Other Current Asset
832.00
13100 · Pre-paid Insurance
Other Current Asset
4,050.00
13400 · Retainage Receivable
Other Current Asset
3,703.02
15000 · Furniture and Equipment
Fixed Asset
34,326.00
15100 · Vehicles
Fixed Asset
78,936.91
15200 · Buildings and Improvements
Fixed Asset
325,000.00
15300 · Construction Equipment
Fixed Asset
15,300.00
16900 · Land
Fixed Asset
90,000.00
17000 · Accumulated Depreciation
Fixed Asset
-110,344.60
18700 · Security Deposits
Other Asset
1,720.00
20000 · Accounts Payable
Accounts Payable
26,636.92
20500 · QuickBooks Credit Card
Credit Card
94.20
20600 · CalOil Credit Card
Credit Card
382.62
Subcontracted Federal WH
Other Current Liability
20700 · Due to Owner
Other Current Liability
0.00
24000 · Payroll Liabilities
Other Current Liability
5,404.45
24000 · Payroll Liabilities:24010 · Federal Withholding Other Current Liability
1,364.00
24000 · Payroll Liabilities:24020 · FICA Payable
Other Current Liability
2,118.82
24000 · Payroll Liabilities:24030 · AEIC Payable
Other Current Liability
0.00
24000 · Payroll Liabilities:24040 · FUTA Payable
Other Current Liability
100.00
24000 · Payroll Liabilities:24050 · State Withholding
Other Current Liability
299.19
24000 · Payroll Liabilities:24060 · SUTA Payable
Other Current Liability
110.00
500.00 93,007.93
0.00
24000 · Payroll Liabilities:24070 · State Disability Payable Other Current Liability
48.13
24000 · Payroll Liabilities:24080 · Worker's Compensation Other Current Liability
1,214.31
24000 · Payroll Liabilities:24090 · Direct Deposit Liabilities Other Current Liability
0.00
24000 · Payroll Liabilities:24100 · Emp. Health Ins Payable Other Current Liability
150.00
25500 · Sales Tax Payable
Other Current Liability
957.63
23000 · Loan - Vehicles (Van)
Long Term Liability
10,501.47
23100 · Loan - Vehicles (Utility Truck)
Long Term Liability
19,936.91
23200 · Loan - Vehicles (Pickup Truck)
Long Term Liability
22,641.00
28100 · Loan - Construction Equipment
Long Term Liability
13,911.32
28200 · Loan - Furniture/Office Equip
Long Term Liability
21,000.00
28700 · Note Payable - Bank of Anycity
Long Term Liability
2,693.21
28900 · Mortgage - Office Building
Long Term Liability
296,283.00
30000 · Opening Bal Equity
Equity
38,773.75
30100 · Capital Stock
Equity
500.00
31400 · Shareholder Distributions
Equity
0.00
32000 · Retained Earnings
Equity
40100 · Construction Income
Income
40100 · Construction Income:40110 · Design Income Income 40100 · Construction Income:40120 · Equipment RentalIncome Income 40100 · Construction Income:40130 · Labor Income
Income
40100 · Construction Income:40140 · Materials IncomeIncome 40100 · Construction Income:40150 · Subcontracted Labor Income Income 40100 · Construction Income:40199 · Less Discounts given Income
Page 1 of 6
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Account 40500 · Reimbursement Income
Type
Balance Total
Income
40500 · Reimbursement Income:40510 · Mileage Income Income 40500 · Reimbursement Income:40520 · Permit Reimbursement Income Income 40500 · Reimbursement Income:40530 · Reimbursed Freight Income& Delivery 50100 · Cost of Goods Sold
Cost of Goods Sold
54000 · Job Expenses
Cost of Goods Sold
54000 · Job Expenses:54100 · Bond Expense
Cost of Goods Sold
54000 · Job Expenses:54200 · Equipment Rental
Cost of Goods Sold
54000 · Job Expenses:54300 · Job Materials
Cost of Goods Sold
54000 · Job Expenses:54400 · Permits and Licenses Cost of Goods Sold 54000 · Job Expenses:54500 · Subcontractors
Cost of Goods Sold
54000 · Job Expenses:54520 · Freight & Delivery
Cost of Goods Sold
54000 · Job Expenses:54599 · Less Discounts Taken Cost of Goods Sold 60100 · Automobile
Expense
60100 · Automobile:60110 · Fuel
Expense
60100 · Automobile:60120 · Insurance
Expense
60100 · Automobile:60130 · Repairs and Maintenance Expense 60300 · Bad debt
Expense
60400 · Advertising & Promotion
Expense
60600 · Bank Service Charges
Expense
60900 · Depreciation Expense
Expense
61200 · Dues and Subscriptions
Expense
61500 · Union Dues
Expense
62100 · Insurance
Expense
62100 · Insurance:62110 · Disability Insurance
Expense
62100 · Insurance:62120 · Liability Insurance
Expense
62100 · Insurance:62130 · Work Comp
Expense
62100 · Insurance:62199 · Less Employee Portion - Health Expense 62400 · Interest Expense
Expense
62400 · Interest Expense:62410 · Finance Charge
Expense
62400 · Interest Expense:62420 · Loan Interest
Expense
62700 · Payroll Expenses
Expense
62700 · Payroll Expenses:62710 · Gross Wages
Expense
62700 · Payroll Expenses:62720 · Payroll Taxes
Expense
62700 · Payroll Expenses:62730 · FUTA Expense
Expense
62700 · Payroll Expenses:62740 · SUTA Expense
Expense
63000 · Office Supplies
Expense
63100 · Postage
Expense
63600 · Professional Fees
Expense
63600 · Professional Fees:63610 · Accounting
Expense
63600 · Professional Fees:63620 · Legal Fees
Expense
63900 · Rent
Expense
64200 · Repairs
Expense
64200 · Repairs:64210 · Building Repairs
Expense
64200 · Repairs:64220 · Computer Repairs
Expense
64200 · Repairs:64230 · Equipment Repairs
Expense
64500 · Taxes
Expense
64500 · Taxes:64510 · Federal
Expense
64500 · Taxes:64520 · State
Expense
64500 · Taxes:64530 · Property
Expense
64500 · Taxes:64540 · Local
Expense
Page 2 of 6
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Account
Type
64800 · Tools and Machinery
Expense
65100 · Utilities
Expense
65100 · Utilities:65110 · Gas and Electric
Expense
65100 · Utilities:65120 · Telephone
Expense
65100 · Utilities:65130 · Water
Expense
69000 · Miscellaneous
Expense
70100 · Other Income
Other Income
70200 · Interest Income
Other Income
80100 · Other Expenses
Other Expense
90100 · Purchase Orders
Non-Posting
90200 · Estimates
Non-Posting
90300 · Sales Orders
Non-Posting
Balance Total
Page 3 of 6
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Description
Accnt. #
Tax Line
Cash
10100
B/S-Assets: Cash
Savings
10300
B/S-Assets: Cash
Petty Cash
10400
B/S-Assets: Cash
Accounts Receivable
11000
B/S-Assets: Accts. Rec. and trade notes
Undeposited Funds
12000
B/S-Assets: Other current assets
Inventory Asset
12100
B/S-Assets: Other current assets
Employee Advances
12800
B/S-Assets: Other current assets
Pre-paid Insurance
13100
B/S-Assets: Other current assets
Retainage Receivable
13400
B/S-Assets: Other current assets
Furniture and Equipment
15000
B/S-Assets: Buildings/oth. depr. assets
Vehicles
15100
B/S-Assets: Buildings/oth. depr. assets
Buildings and Improvements
15200
B/S-Assets: Buildings/oth. depr. assets
Construction Equipment
15300
B/S-Assets: Buildings/oth. depr. assets
Land
16900
B/S-Assets: Land
Accumulated Depreciation
17000
B/S-Assets: Buildings/oth. depr. assets
Security Deposits
18700
B/S-Assets: Other assets
Moneys you owe to vendors and suppliers
20000
B/S-Liabs/Eq.: Accounts payable
QuickBooks Credit Card
20500
B/S-Liabs/Eq.: Other current liabilities
20600
B/S-Liabs/Eq.: Other current liabilities B/S-Liabs/Eq.: Other current liabilities
Short Term Loan from Owner - No Note or Bond
20700
B/S-Liabs/Eq.: Other current liabilities
Payroll Liabilities
24000
B/S-Liabs/Eq.: Other current liabilities
24010
B/S-Liabs/Eq.: Other current liabilities
24020
B/S-Liabs/Eq.: Other current liabilities
24030
B/S-Liabs/Eq.: Other current liabilities
24040
B/S-Liabs/Eq.: Other current liabilities
24050
B/S-Liabs/Eq.: Other current liabilities
24060
B/S-Liabs/Eq.: Other current liabilities
24070
B/S-Liabs/Eq.: Other current liabilities
24080
B/S-Liabs/Eq.: Other current liabilities
24090
B/S-Liabs/Eq.: Other current liabilities
24100
B/S-Liabs/Eq.: Other current liabilities
25500
B/S-Liabs/Eq.: Other current liabilities
Sales Tax Payable
3/4 Ton PU - 48 months 6.9% purchased 12/01/2005 23000
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan - Vehicles (Utility Truck)
23100
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan - Vehicles (Pickup Truck)
23200
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan for Construction Equipment
28100
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan for purchase of furniture and office equipment
28200
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
28700
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
28900
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Mortgage - Office Building
Offset account for use during the setup of the company's 30000 QuickBooks <Unassigned> data file only. Capital Stock
30100
<Unassigned>
Distributions paid to shareholders
31400
<Unassigned>
Retained Earnings
32000
<Unassigned>
Construction Income
40100
<Unassigned>
40110
<Unassigned>
40120
<Unassigned>
40130
<Unassigned>
40140
<Unassigned>
40150
<Unassigned>
40199
<Unassigned>
Page 4 of 6
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Description
Account for reimbursable mile
Accnt. #
Tax Line
40500
<Unassigned>
40510
<Unassigned>
40520
<Unassigned>
40530
<Unassigned>
QuickBooks Automatically Increases the balance in this50100 account when <Unassigned> you use inventory items on invoices or sales receipts. 54000
<Unassigned>
54100
<Unassigned>
Equipment Rental
54200
<Unassigned>
Job Materials
54300
<Unassigned>
Licenses
54400
<Unassigned>
Subcontractors Expense
54500
<Unassigned>
Freight and Delivery
54520
<Unassigned>
54599
<Unassigned>
Automobile
60100
<Unassigned>
Fuel Expense
60110
<Unassigned>
Business Truck Policies
60120
<Unassigned>
60130
<Unassigned>
60300
<Unassigned>
60400
Deductions: Advertising
Bank Service Charges
60600
<Unassigned>
Depreciation Expense
60900
<Unassigned>
Dues and Subscriptions
61200
<Unassigned>
Union Dues
61500
<Unassigned>
Insurance
62100
<Unassigned>
Disability Insurance
62110
<Unassigned>
Liability Insurance
62120
<Unassigned>
Workman's Compensation
62130
<Unassigned>
62199
<Unassigned>
Interest Expense
62400
<Unassigned>
Finance Charge
62410
<Unassigned>
Loan Interest Expense
62420
<Unassigned>
62700
<Unassigned>
62710
<Unassigned>
62720
<Unassigned>
62730
<Unassigned>
62740
<Unassigned>
63000
<Unassigned>
63100
<Unassigned>
Professional Fees
63600
<Unassigned>
Accounting Fees
63610
<Unassigned>
Legal Fees
63620
<Unassigned>
Rent
63900
<Unassigned>
Repairs and Maintenance
64200
<Unassigned>
Building Repairs
64210
<Unassigned>
Computer Repairs
64220
<Unassigned>
Equipment Repairs
64230
<Unassigned>
Taxes
64500
<Unassigned>
Federal Taxes
64510
<Unassigned>
64520
<Unassigned>
64530
<Unassigned>
64540
<Unassigned>
Office Supplies
Property Taxes
Page 5 of 6
YourName Chapter 2 Rock Castle Construction
Account Listing December 15, 2017 Description
Accnt. #
Tax Line
Tools and Machinery
64800
<Unassigned>
Utilities
65100
<Unassigned>
Gas and Electric
65110
<Unassigned>
Telephone
65120
<Unassigned>
Water
65130
<Unassigned>
Miscellaneous
69000
<Unassigned>
Other Income
70100
<Unassigned>
Interest Income
70200
<Unassigned>
Other Expenses
80100
<Unassigned>
90100
<Unassigned>
90200
<Unassigned>
90300
<Unassigned>
Page 6 of 6
YourName Exercise 2.1 Rock Castle Construction
Statement of Cash Flows November 2017 Nov 17 OPERATING ACTIVITIES Net Income
16,507.99
Adjustments to reconcile Net Income to net cash provided by operations: 11000 · Accounts Receivable
-2,612.85
12100 · Inventory Asset
-2,472.84
13100 · Pre-paid Insurance
605.89
13400 · Retainage Receivable
-2,174.50
20000 · Accounts Payable
16,210.77
20500 · QuickBooks Credit Card
-1,025.00
20600 · CalOil Credit Card 24000 · Payroll Liabilities:24010 · Federal Withholding
388.52 1.00
24000 · Payroll Liabilities:24020 · FICA Payable
7.28
24000 · Payroll Liabilities:24050 · State Withholding
-0.60
24000 · Payroll Liabilities:24070 · State Disability Payable
-16.66
24000 · Payroll Liabilities:24080 · Worker's Compensation
1.67
24000 · Payroll Liabilities:24100 · Emp. Health Ins Payable
-50.00
25500 · Sales Tax Payable
-353.74
Net cash provided by Operating Activities
25,016.93
FINANCING ACTIVITIES 23000 · Loan - Vehicles (Van)
-494.69
28100 · Loan - Construction Equipment
-216.61
28700 · Note Payable - Bank of Anycity
-2,675.56
Net cash provided by Financing Activities
-3,386.86
Net cash increase for period
21,630.07
Cash at beginning of period
77,921.51
Cash at end of period
99,551.58
Page 1 of 1
YourName Exercise 2.1 Rock Castle Construction
To Do Notes December 15, 2017 Priority
Type With
No
Done
07/27/2012 Call Doug about grout in the kitchen.
Date
Description
Low
Task
No
07/27/2012 Call Lynn about back porch.
Low
Task
No
07/27/2012 Finish Jacobsen poolhouse estimate
Low
Task
No
01/01/2018 Print financial statements for Mr. Castle.
High
Task
Yes
07/27/2012 Call Erika Pretell about new property.
Low
Task
Yes
07/27/2012 Call Patton Hardware Supplies about Mason job.
Low
Task
Yes
12/12/2017 Print financial statements for Mr. Castle.
High
Task
Page 1 of 1
YourName Exercise 2.2 Rock Castle Construction
Account Listing December 15, 2017 Account
Type
Balance Total
10100 · YourName Checking
Bank
46,969.10
10300 · Savings
Bank
17,910.19
10400 · Petty Cash
Bank
11000 · Accounts Receivable
Accounts Receivable
12000 · Undeposited Funds
Other Current Asset
2,440.00
12100 · Inventory Asset
Other Current Asset
30,683.38
12800 · Employee Advances
Other Current Asset
832.00
13100 · Pre-paid Insurance
Other Current Asset
4,050.00
13400 · Retainage Receivable
Other Current Asset
3,703.02
15000 · Furniture and Equipment
Fixed Asset
34,326.00
15100 · Vehicles
Fixed Asset
78,936.91
15200 · Buildings and Improvements
Fixed Asset
325,000.00
15300 · Construction Equipment
Fixed Asset
15,300.00
16900 · Land
Fixed Asset
90,000.00
17000 · Accumulated Depreciation
Fixed Asset
-110,344.60
18700 · Security Deposits
Other Asset
1,720.00
20000 · Accounts Payable
Accounts Payable
26,636.92
20500 · QuickBooks Credit Card
Credit Card
94.20
20600 · CalOil Credit Card
Credit Card
382.62
Subcontracted Federal WH
Other Current Liability
20700 · Due to Owner
Other Current Liability
0.00
24000 · Payroll Liabilities
Other Current Liability
5,404.45
24000 · Payroll Liabilities:24010 · Federal Withholding Other Current Liability
1,364.00
24000 · Payroll Liabilities:24020 · FICA Payable
Other Current Liability
2,118.82
24000 · Payroll Liabilities:24030 · AEIC Payable
Other Current Liability
0.00
24000 · Payroll Liabilities:24040 · FUTA Payable
Other Current Liability
100.00
24000 · Payroll Liabilities:24050 · State Withholding
Other Current Liability
299.19
24000 · Payroll Liabilities:24060 · SUTA Payable
Other Current Liability
110.00
500.00 93,007.93
0.00
24000 · Payroll Liabilities:24070 · State Disability Payable Other Current Liability
48.13
24000 · Payroll Liabilities:24080 · Worker's Compensation Other Current Liability
1,214.31
24000 · Payroll Liabilities:24090 · Direct Deposit Liabilities Other Current Liability
0.00
24000 · Payroll Liabilities:24100 · Emp. Health Ins Payable Other Current Liability
150.00
25500 · Sales Tax Payable
Other Current Liability
957.63
23000 · Loan - Vehicles (Van)
Long Term Liability
10,501.47
23100 · Loan - Vehicles (Utility Truck)
Long Term Liability
19,936.91
23200 · Loan - Vehicles (Pickup Truck)
Long Term Liability
22,641.00
28100 · Loan - Construction Equipment
Long Term Liability
13,911.32
28200 · Loan - Furniture/Office Equip
Long Term Liability
21,000.00
28700 · Note Payable - Bank of Anycity
Long Term Liability
2,693.21
28900 · Mortgage - Office Building
Long Term Liability
296,283.00
30000 · Opening Bal Equity
Equity
38,773.75
30100 · Capital Stock
Equity
500.00
31400 · Shareholder Distributions
Equity
0.00
32000 · Retained Earnings
Equity
40100 · Construction Income
Income
40100 · Construction Income:40110 · Design Income Income 40100 · Construction Income:40120 · Equipment RentalIncome Income 40100 · Construction Income:40130 · Labor Income
Income
40100 · Construction Income:40140 · Materials IncomeIncome 40100 · Construction Income:40150 · Subcontracted Labor Income Income 40100 · Construction Income:40199 · Less Discounts given Income
Page 1 of 6
YourName Exercise 2.2 Rock Castle Construction
Account Listing December 15, 2017 Account 40500 · Reimbursement Income
Type
Balance Total
Income
40500 · Reimbursement Income:40510 · Mileage Income Income 40500 · Reimbursement Income:40520 · Permit Reimbursement Income Income 40500 · Reimbursement Income:40530 · Reimbursed Freight Income& Delivery 50100 · Cost of Goods Sold
Cost of Goods Sold
54000 · Job Expenses
Cost of Goods Sold
54000 · Job Expenses:54100 · Bond Expense
Cost of Goods Sold
54000 · Job Expenses:54200 · Equipment Rental
Cost of Goods Sold
54000 · Job Expenses:54300 · Job Materials
Cost of Goods Sold
54000 · Job Expenses:54400 · Permits and Licenses Cost of Goods Sold 54000 · Job Expenses:54500 · Subcontractors
Cost of Goods Sold
54000 · Job Expenses:54520 · Freight & Delivery
Cost of Goods Sold
54000 · Job Expenses:54599 · Less Discounts Taken Cost of Goods Sold 60100 · Automobile
Expense
60100 · Automobile:60110 · Fuel
Expense
60100 · Automobile:60120 · Insurance
Expense
60100 · Automobile:60130 · Repairs and Maintenance Expense 60300 · Bad debt
Expense
60400 · Selling Expense
Expense
60400 · Selling Expense:60410 · Advertising Expense Expense 60400 · Selling Expense:60420 · Promotion Expense Expense 60600 · Bank Service Charges
Expense
60900 · Depreciation Expense
Expense
61200 · Dues and Subscriptions
Expense
61500 · Union Dues
Expense
62100 · Insurance
Expense
62100 · Insurance:62110 · Disability Insurance
Expense
62100 · Insurance:62120 · Liability Insurance
Expense
62100 · Insurance:62130 · Work Comp
Expense
62100 · Insurance:62199 · Less Employee Portion - Health Expense 62400 · Interest Expense
Expense
62400 · Interest Expense:62410 · Finance Charge
Expense
62400 · Interest Expense:62420 · Loan Interest
Expense
62700 · Payroll Expenses
Expense
62700 · Payroll Expenses:62710 · Gross Wages
Expense
62700 · Payroll Expenses:62720 · Payroll Taxes
Expense
62700 · Payroll Expenses:62730 · FUTA Expense
Expense
62700 · Payroll Expenses:62740 · SUTA Expense
Expense
63000 · Office Supplies
Expense
63100 · Postage
Expense
63600 · Professional Fees
Expense
63600 · Professional Fees:63610 · Accounting
Expense
63600 · Professional Fees:63620 · Legal Fees
Expense
63900 · Rent
Expense
64200 · Repairs
Expense
64200 · Repairs:64210 · Building Repairs
Expense
64200 · Repairs:64220 · Computer Repairs
Expense
64200 · Repairs:64230 · Equipment Repairs
Expense
64500 · Taxes
Expense
64500 · Taxes:64510 · Federal
Expense
64500 · Taxes:64520 · State
Expense
Page 2 of 6
YourName Exercise 2.2 Rock Castle Construction
Account Listing December 15, 2017 Account
Type
64500 · Taxes:64530 · Property
Expense
64500 · Taxes:64540 · Local
Expense
64800 · Tools and Machinery
Expense
65100 · Utilities
Expense
65100 · Utilities:65110 · Gas and Electric
Expense
65100 · Utilities:65120 · Telephone
Expense
65100 · Utilities:65130 · Water
Expense
69000 · Miscellaneous
Expense
70100 · Other Income
Other Income
70200 · Interest Income
Other Income
80100 · Other Expenses
Other Expense
90100 · Purchase Orders
Non-Posting
90200 · Estimates
Non-Posting
90300 · Sales Orders
Non-Posting
Balance Total
Page 3 of 6
YourName Exercise 2.2 Rock Castle Construction
Account Listing December 15, 2017 Description
Accnt. #
Tax Line
Cash
10100
B/S-Assets: Cash
Savings
10300
B/S-Assets: Cash
Petty Cash
10400
B/S-Assets: Cash
Accounts Receivable
11000
B/S-Assets: Accts. Rec. and trade notes
Undeposited Funds
12000
B/S-Assets: Other current assets
Inventory Asset
12100
B/S-Assets: Other current assets
Employee Advances
12800
B/S-Assets: Other current assets
Pre-paid Insurance
13100
B/S-Assets: Other current assets
Retainage Receivable
13400
B/S-Assets: Other current assets
Furniture and Equipment
15000
B/S-Assets: Buildings/oth. depr. assets
Vehicles
15100
B/S-Assets: Buildings/oth. depr. assets
Buildings and Improvements
15200
B/S-Assets: Buildings/oth. depr. assets
Construction Equipment
15300
B/S-Assets: Buildings/oth. depr. assets
Land
16900
B/S-Assets: Land
Accumulated Depreciation
17000
B/S-Assets: Buildings/oth. depr. assets
Security Deposits
18700
B/S-Assets: Other assets
Moneys you owe to vendors and suppliers
20000
B/S-Liabs/Eq.: Accounts payable
QuickBooks Credit Card
20500
B/S-Liabs/Eq.: Other current liabilities
20600
B/S-Liabs/Eq.: Other current liabilities B/S-Liabs/Eq.: Other current liabilities
Short Term Loan from Owner - No Note or Bond
20700
B/S-Liabs/Eq.: Other current liabilities
Payroll Liabilities
24000
B/S-Liabs/Eq.: Other current liabilities
24010
B/S-Liabs/Eq.: Other current liabilities
24020
B/S-Liabs/Eq.: Other current liabilities
24030
B/S-Liabs/Eq.: Other current liabilities
24040
B/S-Liabs/Eq.: Other current liabilities
24050
B/S-Liabs/Eq.: Other current liabilities
24060
B/S-Liabs/Eq.: Other current liabilities
24070
B/S-Liabs/Eq.: Other current liabilities
24080
B/S-Liabs/Eq.: Other current liabilities
24090
B/S-Liabs/Eq.: Other current liabilities
24100
B/S-Liabs/Eq.: Other current liabilities
25500
B/S-Liabs/Eq.: Other current liabilities
Sales Tax Payable
3/4 Ton PU - 48 months 6.9% purchased 12/01/2005 23000
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan - Vehicles (Utility Truck)
23100
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan - Vehicles (Pickup Truck)
23200
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan for Construction Equipment
28100
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Loan for purchase of furniture and office equipment
28200
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
28700
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
28900
B/S-Liabs/Eq.: L-T Mortgage/note/bonds pay.
Mortgage - Office Building
Offset account for use during the setup of the company's 30000 QuickBooks <Unassigned> data file only. Capital Stock
30100
<Unassigned>
Distributions paid to shareholders
31400
<Unassigned>
Retained Earnings
32000
<Unassigned>
Construction Income
40100
<Unassigned>
40110
<Unassigned>
40120
<Unassigned>
40130
<Unassigned>
40140
<Unassigned>
40150
<Unassigned>
40199
<Unassigned>
Page 4 of 6
YourName Exercise 2.2 Rock Castle Construction
Account Listing December 15, 2017 Description
Account for reimbursable mile
Accnt. #
Tax Line
40500
<Unassigned>
40510
<Unassigned>
40520
<Unassigned>
40530
<Unassigned>
QuickBooks Automatically Increases the balance in this50100 account when <Unassigned> you use inventory items on invoices or sales receipts. 54000
<Unassigned>
54100
<Unassigned>
Equipment Rental
54200
<Unassigned>
Job Materials
54300
<Unassigned>
Licenses
54400
<Unassigned>
Subcontractors Expense
54500
<Unassigned>
Freight and Delivery
54520
<Unassigned>
54599
<Unassigned>
Automobile
60100
<Unassigned>
Fuel Expense
60110
<Unassigned>
Business Truck Policies
60120
<Unassigned>
60130
<Unassigned>
60300
<Unassigned>
60400
Deductions: Advertising
60410
Deductions: Advertising
60420
Deductions: Advertising
Bank Service Charges
60600
<Unassigned>
Depreciation Expense
60900
<Unassigned>
Dues and Subscriptions
61200
<Unassigned>
Union Dues
61500
<Unassigned>
Insurance
62100
<Unassigned>
Disability Insurance
62110
<Unassigned>
Liability Insurance
62120
<Unassigned>
Workman's Compensation
62130
<Unassigned>
62199
<Unassigned>
Interest Expense
62400
<Unassigned>
Finance Charge
62410
<Unassigned>
Loan Interest Expense
62420
<Unassigned>
62700
<Unassigned>
62710
<Unassigned>
62720
<Unassigned>
62730
<Unassigned>
62740
<Unassigned>
63000
<Unassigned>
Office Supplies
63100
<Unassigned>
Professional Fees
63600
<Unassigned>
Accounting Fees
63610
<Unassigned>
Legal Fees
63620
<Unassigned>
Rent
63900
<Unassigned>
Repairs and Maintenance
64200
<Unassigned>
Building Repairs
64210
<Unassigned>
Computer Repairs
64220
<Unassigned>
Equipment Repairs
64230
<Unassigned>
Taxes
64500
<Unassigned>
Federal Taxes
64510
<Unassigned>
64520
<Unassigned>
Page 5 of 6