Archives: Solution Manual
978-1259917011 Excel Chapter 16 Exercise
Current Month Year to Date Revenues Sales 295.00$ 0.33 295.00$ 0.10 Sales – Aviary 7,172.71 8.07 51,697.86 18.36 Sales – Books 149.75 0.17 7,293.10 2.59 Sales – Equipment 18,038.77 20.30 60,392.26 21.45 Sales – Food/Fert 1,176.86 1.32 5,374.05 1.91 Sales […]
978-1259917011 Excel Chapter 15 Exercise
Filter Criteria includes: Report order is by ID. Employee ID Employee Address line 1 Address line 2 City ST ZIP Masked SS No Fed Filing Status Pay Type C50 Rick Copley 10345 Atlantic Lane Norcross, GA 30092 XXX-XX-0003 Single Hourly […]
978-1259917011 Excel Chapter 14 Exercise
Filter Criteria includes: Report order is by Check Date. Report is printed in Detail Format. Date Account ID Transaction Ref Line Description Debit Amnt Credit Amnt 1/10/19 11000 Invoice 101 Invoice: 101 367.20 1/10/19 10200 Invoice 101 Abby Caron 367.20 […]
978-1259917011 Excel Chapter 13 Exercise
Filter Criteria includes: Report order is by Invoice/CM Date. Report is printed in Detail Format. Date Account ID Invoice/CM # Line Description Debit Amnt Credit Amnt 1/7/19 23100 101 GA: Georgia Dept. of Revenue 34.00 1/7/19 40200 101 Five tool […]
978-1259917011 Excel Chapter 12 Exercise
Filter Criteria includes: Report order is by ID. Report is printed with Accounts having Zero Amounts and in Detail Format. Account ID Account Description Active? Account Type 10200 Boulevard Bank Yes Cash 10300 Payroll Checking Account Yes Cash 10400 Enterprise […]
978-1259917011 Excel Chapter 11 Exercise Part 2
Filter Criteria includes: Report order is by Check Date. Report is printed in Detail Format. Date Account ID Transaction Ref Line Description Debit Amnt Credit Amnt 12/3/19 4050 Crafts income Crafts income 2,850.00 12/3/19 1020 Crafts income Deposit 2,850.00 12/7/19 […]
978-1259917011 Excel Chapter 11 Exercise Part 1
Filter Criteria includes: Report is printed in Detail Format. Beginning GL Balance 21,815.30 Add: Cash Receipts 4,305.00 Less: Cash Disbursements (874.47) Add (Less) Other (12.00) Ending GL Balance 25,233.83 Ending Bank Balance 25,353.55 Add back deposits in transit Nov 16, […]
978-1259917011 Excel Chapter 10 Exercise
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format. Account ID Account Description Debit Amt Credit Amt 1020 County Bank 21,815.30 1300 Prepaid Insurance 1,000.00 1400 Prepaid Rent 700.00 1450 Supplies 987.80 1500 Computer Equipment […]
978-1259917011 Excel Chapter 9 Exercise
Filter Criteria includes: Report order is by ID. Report is printed with Accounts having Zero Amounts and in Detail Format. Account ID Account Description Active? Account Type 1020 County Bank Yes Cash 1100 Accounts Receivable Yes Accounts Receivable 1200 Inventory […]
978-1259917011 Excel Chapter 8 Exercise
Filter Criteria includes: Report order is by ID. Report is printed including Balance Forward. Job ID Phase ID Cost Code ID GL Acct ID Trx Date Trans Description Jrnl Trans Ref Debit Amt Credit Amt Net DR/CR ASHFORD 04-Maintenance 012-Landscape […]
978-1259917011 Excel Chapter 6 Exercise
Filter Criteria includes: Report order is by ID. Report is printed including Balance Forward. Job ID Phase ID Cost Code ID GL Acct ID Actual Rev. Actual Exp. Profit $ Profit % BEATTY 75.00 BEATTY 40000-FF 99.90 BEATTY 53.94 BEATTY […]
978-1259917011 Excel Chapter 5 Exercise
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format. Account ID Account Description Debit Amt Credit Amt 10000 Petty Cash 327.55 10100 Cash on Hand 1,850.45 10200 Regular Checking Account 9,046.52 10300 Payroll Checking Account […]
978-1259917011 Excel Chapter 4 Exercise
Filter Criteria includes: Report order is by Check Date. Report is printed in Detail Format. Reference Date Employee Amount 1250 3/15/19 Amanda W. Chester 809.22 1251 3/15/19 Al L. Duke 379.50 1252 3/15/19 Anthony H. Hecter 787.54 1253 3/15/19 Alex […]
978-1259917011 Excel Chapter 3 Exercise
Filter Criteria includes: Report order is by Name. Report is printed in Detail Format. Customer ID Customer Date Trans No Type Debit Amt Credit Amt Balance Terms ALDRED Aldred Builders, Inc. 3/1/19 Balance Fwd 5,426.94 2% 10, Net 30 Days […]
978-1259917011 Excel Chapter 2 Exercise
Filter Criteria includes: Report order is by ID. Vendor ID Vendor Contact Telephone 1 Tax Id No ABNEY Abney and Son Contractors Wesley Abney 770-555-0000 ADLER Adler’s Landscaping Philip Adler AKERSON Akerson Distribution Cameron Akerson 678-555-1279 CALDWELL Caldwell Tools Company […]
978-1259917011 Excel Chapter 1 Exercise
Filter Criteria includes: Report order is by ID. Employee ID Employee Address line 1 Address line 2 City ST ZIP Masked SS No Fed Filing Status Pay Type ACHESTER Amanda W. Chester 4599 West Paces Ferry Road Atlanta, GA 30328 […]
978-1259917011 Excel CL Mftg CofA GLTB BS IS SCF SRE
Filter Criteria includes: Report order is by ID. Report is printed with Accounts having Zero Amounts and in Detail Format. Account ID Account Description Active? Account Type 10000 Petty Cash Yes Cash 10200 Lincoln Bank Yes Cash 10300 Penn Savings […]
978-1259917011 Excel Asset Depreciation Schedule
Jan 1, 2014 Initial cost $7,000 Salvage value $0 Annual depreciation amounts under various methods Useful life (years) 7 150% Declining Balance 1 $2,000 $1,000 $1,750 $1,500 2 $1,429 $1,000 $1,500 $1,179 3 $1,020 $1,000 $1,250 $926 4$729 $1,000 $1,000 […]
978-1259917011 Chapter 9 Solution Manual
167 – IMK CHAPTER 9 NEW COMPANY SETUP AND BEGINNING BALANCES Chapter 9 begins Part 2 of the book—Sage 50 2019 for Service Businesses. In this part of the book, students are the owners of an accounting practice. Their accounting […]
978-1259917011 Chapter 9 Going To The Net
GOING TO THE NET ANSWERS – Chapter 9 Students access information about the chart of accounts. The website is http://en.wikipedia.org/wiki/Chart_of_accounts. They read the information on Wikipedia’s chart of accounts website. Answers will vary. There are some inconsistencies on the Wikipedia […]
978-1259917011 Chapter 9 Assessment Rubric
CHAPTER 9, ASSESSMENT RUBRIC ANSWER Task Date Selections Window(s) Shortened Company Name October 1, 2019 Beginning Balances September 30, 2019 From the menu bar, File > New Company. Or from Sage 50’s startup window > Create a New Company. Create […]
978-1259917011 Chapter 8 Solution Manual Part 2
Stone Arbor Landscaping: Time & Billing 149 – IMK SOLUTION TO 8-2 (2): Job Ledger (continued) McGraw-Hill Education, Computer Accounting with Sage 50 2019, 21e 150 – IMK Chapter 8 SOLUTION TO 8-2 (2): Job Ledger (continued) McGraw-Hill Education, Computer […]
978-1259917011 Chapter 8 Solution Manual Part 1
137 – IMK CHAPTER 8 STONE ARBOR LANDSCAPING: TIME & BILLING When Sage 50 2019 is installed, two sample companies are included with the software: Bellwether Garden Supply and Stone Arbor Landscaping. In Chapters 1 through 7 students worked with […]
978-1259917011 Chapter 8 Going To The Net
1. Describe the topics within the Sage support resources: Sage Knowledgebase Overview Using the Sage Knowledgebase Browsing products Finding downloads Logging in Saving content Creating content 2. Watch the Sage Support video. Students can watch the video from the Sage […]
978-1259917011 Chapter 8 Assessment Rubric
CHAPTER 8, ASSESSMENT RUBRIC ANSWER Task Navigation Center and Menu Window Timesheet Inventory & Services > Inventory Items > View and Edit Inventory Items. From the Inventory List, select an Item ID. On the Time Tickets window, select Timesheet Time […]
978-1259917011 Chapter 7 Solution Manual Part 2
124 – IMK Chapter 7 ANSWER: The Purchase Discounts account is identified as Account No. 89500 and it has a $10.11 credit balance. The account classification for Purchase Discounts is usually Cost of Sales, not an Expense account. Refer to […]
978-1259917011 Chapter 7 Solution Manual Part 1
111 – IMK CHAPTER 7 FINANCIAL STATEMENTS In Chapters 1 through 6, your students used the sample company Bellwether Garden Supply. They learned how Sage 50’s graphical user interface works and how to navigate the software. In Chapters 1 through […]
978-1259917011 Chapter 7 Going To The Net
GOING TO THE NET ANSWERS – Chapter 7 1. What are liquid assets? Assets that can be easily converted into cash are called liquid assets. 2. What are the liquid assets called on a balance sheet? The first section on […]
978-1259917011 Chapter 7 Assessment Rubric
CHAPTER 7, ASSESSMENT RUBRIC ANSWER Report Date Menu Window Balance Sheet March 31, 2019 Reports & Forms > Financial Statements Or, Find a Report area of Business Status Navigation Center <Standard> Balance Sheet Income Statement For the three months ended […]
978-1259917011 Chapter 6 Solution Manual
97 – IMK CHAPTER 6 JOB COST In Chapter 6, Sage 50‘s Job Cost system is taught. Sage lets your students assign Job ID codes to purchases, sales, and employee hours. Your students will understand how each of these factors—purchases, […]
978-1259917011 Chapter 6 Going To The Net
GOING TO THE NET ANSWERS – Chapter 6 Access the Sage 50cloudaccounting website. The website address is https://www.sage.com/en-us/products/sage-50-accounting/. 1. Briefly describe Sage 50cloud accounting software. 2. What are two benefits of Sage 50cloud accounting software? Run your business more efficiently […]
978-1259917011 Chapter 6 Assessment Rubric
CHAPTER 6, ASSESSMENT RUBRIC ANSWER Date Transaction Navigation Center/Module Task Window Journal Dr./Cr. 3/26/19 Sold two Bell-Grow Impulse Sprinklers (EQWT-15160) to Franklin Botanical Gardens, $64.18 (includes sales tax); terms 2% 10, Net 30 days; Job ID Franklin Botanical Gardens. Customers […]
978-1259917011 Chapter 5 Solution Manual
81 – IMK CHAPTER 5 GENERAL LEDGER, INVENTORY, AND INTERNAL CONTROL In Chapter 5, your students learn how to use the General Ledger Chart of Accounts. When a company is set up, the following initial steps are performed: set up […]
978-1259917011 Chapter 5 Going To The Net
GOING TO THE NET ANSWERS – Chapter 5 Access the Bookkeeping and Accounting Basics article on the Nolo website. The website address is http://www.nolo.com/legal-encyclopedia/bookkeeping-accounting-basics-29653.html. Read the Bookkeeping and Accounting Basics article. (Hint: If this article is no longer available, link […]
978-1259917011 Chapter 5 Assessment Rubric
CHAPTER 5, ASSESSMENT RUBRIC ANSWER Date Transaction Navigation Center/Module Task Window Journal Dr./Cr. 3/18 Transfer $1,200 from the Regular Checking Account to the Payroll Checking Account. Banking > General Journal Entry > New General Journal Entry General Ledger General Journal […]
978-1259917011 Chapter 4 Solution Manual
67 – IMK CHAPTER 4 EMPLOYEES In Chapter 4, your students learn how Sage 50 processes payroll. Once default and employee maintenance information is set up, payroll is a simple process. The first step in setting up payroll is to […]
978-1259917011 Chapter 4 Going To The Net
GOING TO THE NET ANSWERS – Chapter 4 Access All Accounting Careers website. The website address is http://allaccountingcareers.com/. 1. What is the career outlook for accounting professionals? According to U.S. News & World Report, the professional service industry, which includes […]
978-1259917011 Chapter 4 Assessment Rubric
CHAPTER 4, ASSESSMENT RUBRIC ANSWER (Paycheck, page 72 – IMK) is used for account names or Payroll Journal Entry window) Date Transaction Navigation Center/Module Task Window Journal Dr./Cr. 3/29 Record paycheck information for Derrick P. Gross. Employees & Payroll > […]
978-1259917011 Chapter 3 Solution Manual
53 – IMK CHAPTER 3 CUSTOMERS Chapter 3 introduces the student to the basic way that Sage 50 works with customer transactions. Students learn about quotes and sales orders, and how the information entered into customer maintenance windows is used […]
978-1259917011 Chapter 3 Going To The Net
GOING TO THE NET ANSWERS – Chapter 3 1. How many board members serve on the Financial Accounting Standards Board? Do they serve part time or full time? There are seven members who serve on the Financial Accounting Standards Board […]
978-1259917011 Chapter 3 Assessment Rubric
CHAPTER 3, ASSESSMENT RUBRIC ANSWER Date Transaction Navigation Center/Module Task Window Journal Dr./Cr. 3/3/19 Bellwether Garden Supply sold one Rotary Mower – EQLW-14140 to Teesdale Real Estate, Invoice 102, $299.99; plus $18 sales tax. Customers & Sales > Sales Invoices […]
978-1259917011 Chapter 2 Solution Manual
McGraw-Hill Education, Computer Accounting with Sage 50 2019, 21e 35 – IMK CHAPTER 2 VENDORS Chapter 2 introduces students to the basic way that Sage 50 works with vendor transactions. The first thing the students do is select from the […]
978-1259917011 Chapter 2 Going To The Net
GOING TO THE NET ANSWERS – Chapter 2 1. What did Blake Oliver do before he became an accountant? I am not a traditional accountant. I was initially a musician before I got into accounting. I majored in cello performance […]
978-1259917011 Chapter 18 Solution Manual
385 – IMK CHAPTER 18 MICROSOFT WORD AND TEMPLATES LEARNING OBJECTIVES 1. Copy Sage 50 report data to Microsoft Word. 2. Use the write letters feature. 3. Edit and save letter templates. 4. Save Word files. 5. Extract the PAWMail.zip […]
978-1259917011 Chapter 18 Going To The Net
ANSWERS TO GOING TO THE NET, CHAPTER 18 Go online to the Sage Advice blog. The website is https://www.sage.com/en-us/blog/. Answers will vary. 1. In the Headlines section, read an article. Write a brief essay (no more than 100 words). Include […]
978-1259917011 Chapter 18 Assessment Rubric
CHAPTER 18, ASSESSMENT RUBRIC ANSWER File Program Location Extracted folders PAWMail.zip C:\Sage\Peachtree\Company\Letter There are three folders with letter templates: Customer letters Employee letters Vendor letters CHAPER 1, ASSESSMENT RUBRIC ANSWER Chart of Accounts or Account List Navigation Bar/Navigation Center Account […]
978-1259917011 Chapter 17 Solution Manual
371 – IMK McGraw-Hill Education, Computer Accounting with Sage 50 2019, 21e Sage 50 Spreadsheet Database file Other accounting program Database program Spreadsheet program Word processing program Sage 50 Other accounting program CHAPTER 17 IMPORT/EXPORT In this chapter your students […]
978-1259917011 Chapter 17 Going To The Net
ANSWERS TO GOING TO THE NET, CHAPTER 17 Access the Sage Knowledgebase about How to export a customer list and import it as a vendor list. List the steps for how to export a customer list and import it as […]
978-1259917011 Chapter 17 Assessment Rubric
CHAPTER 17, ASSESSMENT RUBRIC ANSWER Date Menu Selections and Links File Name, Extension, and Report ID Customer List File Menu > Select Import/Export > Accounts Receivable list > Customer List > Export icon. Save file to external media or default […]
978-1259917011 Chapter 16 Solution Manual
361 – IMK CHAPTER 16 CUSTOMIZING FORMS The rules are different for printing and designing each type of document. Chapter 16 explains the rules for printing and designing forms. In this book your students have used many different types of […]