CA—Simply Accounting for Windows, 6.0G Update Page 14
COMPUTERIZED ACCOUNTING WITH CASIMPLY ACCOUNTING FOR WINDOWS, VERSION 6.0 G
UPDATES AND ERRATA
CHAPTER 4
Page 4-8: Document 29: Transaction amount should be $62.50.
Page 4-18: Document 36: Use the General Journal.
Page 4-55: Amount of 12/12/1997 Deposit 407 should be $570.00.
IMAGE ART APPRAISAL
Page S1-22: Document 40: Amount should be $49.95.
Page S1-26: 12/26/1997 Check 1684 amount should be 49.95. Final Ending Balance should be $14,607.28.
CHAPTER 5
Page 5-18: Action at the bottom of the page should be A...Upon examining the printed copy of Invoice 2168, you realize that Applegate Vineyards has an item listed as RWire and it should have been RWood...@
Page 5-36: Document 10: Item should be Ski2-W
Page 5-37: Document 11: Quantity sold should be 100 Explore Oregon-Attractions maps; use sales discount terms of 2/15, net 30.
Page 5-37: Document 12: Use discount terms of 2/15, net 30; print the sales invoice.
Pages 5-44 and 5-45: Action at the bottom of page 5-44 should include the instruction to make sure the account number is 4700. The screen shot at the top of page 5-45 should show 4700 as the account number. (This will necessitate changes to some of the reports in Chapters 5, 6, 7, and8.)
Page 5-54: Action at the bottom of the page: italicize account numbers 5660 and 1060.
Page 5-57: Document 24: Total is $311.90.
Page 5-64: Journal Entry 1 1220 Ski Map Inventory should have a credit of 900.00
Page 5-66: The debit and credit amounts for J11 should be 100.00.
Page 5-67: J21 date should be 12/04/1997; J22 CM57 date should be 12/04/1997 and account number 4230 should be 4700.
Page 5-70: Applegate Vineyard 7237 12/12/1997 Payment should have 9.00 in the Currentcolumn.
Page 5-71: Northwest Pipeline the column for 91+ should show the following:
18,000
-18,000
18,000
-
-
18,000
Solutions Manual: Windmill Wheels: In the General Journal J5 and J15 should use Sales Returns and Allowances as the account.
12/12/97 Trial Balance: Use the following Balances: Sales $341,125.00; Sales Returns and Allowances $1,350.00; and Totals $414,315.06
CHAPTER 6
Page 6-27 and 6-28: The Purchases Journal entry numbers should start with J32 and go through J45. (The three cash transactions for J29, 30, and 31 in Chapter 5 are missing in Chapters 6-8. The number of the Journal entry will be incorrect by three numbers throughout the chapters. In addition, there will be a few changes in some of the account balances that will be noted on the appropriate pages.)
Page 6-28: The Action at the bottom of the page should begin with: Open the Purchases Journal.
Page 6-32: The Action at the bottom of the page should say ...double-click anywhere on the purchase order for Storage Systems, Inc. except the name...
Page 6-41: The date for Document 50 should be December 16.
Page 6-46: The second Action on the page should say ...Click Yes when you see the following screen.
Pages 6-57 through 6-59: Journal entries will begin with number 32 and end with number 64.
J32 should be changed to J35 and should show the following:
12/14/1997 J35 ADJ634, Reversing J34. Correction is J36.
J45 should be changed to J48 and should have a date of 12/19/1997
J46 should be changed to J49 and should the following:
12/19/1997 J49 ADJ003-295, Reversing J48. Correction is J50.
J59 should be changed to J62 and should have 2340 as the account number for Medicare Tax Payable
J60 should be changed to J63 and should have a date of 12/16/1997
J61 should be changed to J64 and should have a date of 12/16/1997
Page 6-61: Edwards Business Supply #1726 date should be 12/16/1997
Federal Reserve Bank #1735 date should be 12/16/1997
Metro Graphics #1727C Current column should be -16,742.00
Oregon Wine Press 12/16/1997 Payment numbered 1737 should be 1731, and the Total and Current columns should have a balance of 600.00
Page 6-62 and 6-63: Storage Systems, Inc. should have a 12.00 balance in the Total and Current columns.
Change the following accounts and balances in the Trial Balance:
Debit Credit
1060 Cash 27,881.37
1210 Golf Map Inventory 674.77
1220 Ski Map Inventory 14,785.97
4210 Wholesale Golf Map Sales 8,800.59
4220 Wholesale Ski Map Sales 6,736.19
4230 Wholesale Wine Map Sales 6,643.19
4700 Sales Returns and Allowances 2,058.75
5010 COGS-Golf Maps 15,716.42
5020 COGS-Ski Maps 15,137.66
Total Debits and Credits 390,919.35 390,919.35
Solutions Manual: Windmill Wheels:12/26/97 Trial Balance: Use the following Balances: Sales $341,125.00; Sales Returns and Allowances $1,350.00; and Totals $413,497.69.
CHAPTER 7
The text was written using Version 6.0B of CABSimply Accounting software. However, the text was shipped with a newer release, Version 6.0G. Essentially, the software is the same for both versions except for the tax tables. As a result of this update, the amounts withheld for taxes such as FIT and SIT will be different from the text. Rather than detail each tax change on each page where a difference occurs, Chapter 7 update information will contain a listing of each employee paycheck with the figures obtained using Version 6.0G of the software. Updated figures for the Payroll Journal on pages 7-16 through 7-18 may be obtained by viewing the amounts on the paychecks shown below. Individual pages will be listed when a change does not necessarily effect a paycheck.
CA—Simply Accounting for Windows, 6.0G Update Page 14
CA—Simply Accounting for Windows, 6.0G Update Page 14
Check Before Correction:
After Correction:
Pages 7-27 through 7-29:
EMPLOYEE YEAR-TO-DATE SUMMARY CHANGESNAME / FIT / SIT / WITHHELD / NET PAY
Graham, Joyce / 1,094.38 / 881.49 / 3,652.87 / 14,347.13
Richman, Arlie / 2,004.38 / 1,465.62 / 6,389.60 / 20,010.40
White, Alice / 2,160.06 / 1,231.63 / 5,160.49 / 14,039.51
York, Sam / 1,209.96 / 747.06 / 2,941.27 / 9,924.73
Page 7-31: Employee Detail Report:
Page 7-34: The FIT Report should show:
The last Action on the page should include the instruction: From the Employees window Reports menu, choose Print W-2 Forms.
Page 7-35: The last line of Sam York=s W-2 should show:
OR 6644529 12866.00 747.06 0.00
Page 7-37 and 7-38: Trial Balance: The following accounts have different balances:
Cash 22,979.29
Golf Map Inventory 674.77
Ski Map Inventory 14,785.97
FIT Payable 491.92
SIT Payable 364.62
Wholesale Golf Map Sales 8,800.59
Wholesale Ski Map Sales 6,736.19
Wholesale Wine Map Sales 6,643.19
Sales Returns and Allowances 2,058.75
COGS-Golf Maps 15,716.42
COGS-Ski Maps 15,137.66
Total Debits and Credits 393,098.64 393,098.64
Page 7-42: Session date should be 12/31/1997. Rogello Lopez should have a social security number of 541-88-3227.
Solutions Manual: Windmill Wheels:
CHANGES TO EMPLOYEE PAYCHECKSNAME / FIT / SIT / WITHHELD / NET PAY
Roper, Art / 155.63 / 127.66 / 530.42 / 1,719.58
Soley, Jennifer / 91.88 / 82.40 / 321.68 / 1,278.32
Watson, Annette / 184.38 / 108.99 / 446.51 / 1,228.49
Zoe, Scott / 175.00 / 104.51 / 402.57 / 1,209.93
Payroll Journal will have the same amounts as shown in the table above.
EMPLOYEE YEAR-TO-DATE SUMMARY CHANGESNAME / FIT / SIT / WITHHELD / NET PAY
Lopez, Rogello / 0.00 / 0.00 / 0.00 / 0.00
Roper, Art / 2,019.38 / 1,473.26 / 6,419.90 / 20,080.10
Soley, Jennifer / 1,124.38 / 896.79 / 3,713.47 / 14,486.53
Watson, Annette / 2,182.56 / 1,243.11 / 5,205.95 / 14,144.05
Zoe, Scott / 1,302.88 / 794.45 / 3,128.99 / 10,356.51
CA—Simply Accounting for Windows, 6.0G Update Page 14
Report 941 FIT Summary should show:
FITGROSS TAXABLE / WITHHELD
Lopez, Rogello / 0.00 / 0.00
Roper, Art / 6,700.00 / 500.63
Soley, Jennifer / 4,700.00 / 291.88
Watson, Annette / 4,950.00 / 556.89
Zoe, Scott / 3,881.50 / 396.61
Totals / 20,231.50 / 1,746.01
W-2 for Scott Zoe should show a total of 13,485.50. The column on the right should have 1,302.88; 836.11; and 195.55. The last row of the W-2 should have the following:
OR 6644529 13485.50 794.45 0.00
The Trial Balance should have the following changes: Cash 44,844.73; FIT Payable 606.89; SIT Payable 423.26; Sales 341,125.00; Sales Returns and Allowances 1,350.00; Totals 415,747.19.
CHAPTER 8
Page 8-6: The Select Inventory screen should show the quantities shown for Golf1 as 977 and for Ski1 as 321.
Pages 8-16, 8-19, 8-20: The Quantity column in the Inventory & Services screen should show 977 for Golf 1 and 1 for Ski1.
Page 8-22: The Qty on Hand for Golf 1 should be 977 and for Ski1 should be 321.
Pages 8-23 and 8-24: The adjustment for Ski1 should be -321 and the amount of the adjustment should be 263.22. The total for the Adjustment Journal entry on Page 8-24 should be -613.06.
Page 8-25: The total of the Adjustments Journal should be $1,818.58.
Page 8-26: The new item should be Golf2-W.
Page 8-34: The Inventory Synopsis should have the following changes: quantity for Golf 1 977, value for Golf1 674.77, and the Total Value 32,698.40.
Page 8-38: Attraction Map Sales Summary Detail Report: Account number for Advertising Expense is 5430.
Golf Map Sales Summary Detail Report: 4210 should show two cash sales of 6.00 and 3.00. The total for the account should be 159.00. Total after Sales Returns and Allowances should show 153.00; Account number for COGS-Golf Maps should be 5010. Account 5010 transactions should include the two cash sales in the amounts of 1.38 and 0.69. The total for 5010 should be 35.23. The total of Revenue minus Expense should be 117.77.
Page 8-39: Rack Sales Summary Detail Report: The date for the Applegate Vineyard Winery transactions should be 12/2/1997.
Ski Map Sales Summary Detail Report: 4220 should show two cash sales of 9.00 and 3.00. The total for the account should be 252.00. Total after Sales Returns and Allowances should be 4,962.00; Account 5020 transactions should include the two cash sales in the amounts of 2.46 and 0.82 and the last Dated Inventory transaction should be 263.22. The total for 5020 should be 1,897.40. The total of Revenue minus Expense should be 1,564.60.
Page 8-40: Wine Map Sales Summary Detail Report: 12/4/1997 Transaction for Applegate Vineyard Winery shown under Account 4230 should be moved to 4700. The total for Account 4230 should be 165.00. The total for Account 4700 should be -9.00.
Page 8-47: Account Reconciliation Journal at the top of the page should be the same as the one at the bottom of the page.
Page 8-50: The unresolved amount for the screen shot at the top of the page should be -26,355.62.
Page 8-55: The last action on the page should have the amount of Check 1738 as $1,208.62.
Page 8-65: The Account Reconciliation Detail Report should include three cash sale transactions dated 12/12/1997 with a Status of Outstanding. The first cash sale is for 6.00 and uses Deposit Slip 2143. The next two cash sales are for 9.00 and 6.00 and use Deposit Slip 2144. Because of the change in the payroll tax tables, the following checks written to employees should be changed:
1738 to $1,208.62; 1739 to $1,684.73; 1740 to $1,176.22; 1741 to $744.68; ADJ 1741 to $744.68; and 1471 to $832.51.
Page 8-66: The Account Reconciliation Journal at the top of the page should include the three cash sale transactions and the outstanding payroll checks showing the same amounts as listed on page 865.
Pages 8-66 through 68: Changes in account balances on the Trial Balance: Cash 22,966.24; Golf Map Inventory 674.77; FIT Payable 491.92; SIT Payable 364.62; Wholesale Golf Map Sales 8,800.59; Wholesale Ski Map Sales 6,736.19; Wholesale Wine Map Sales 6,643.19; Sales Returns and Allowances 2,058.75; COGS-Golf Maps 15,716.42; Totals 396,560.86.
CA—Simply Accounting for Windows, 6.0G Update Page 14
Pages 8-68 and 8-69: Changes in amounts for the Income Statement: Wholesale Golf Map Sales 8,800.59; Wholesale Ski Map Sales 6,736.19; Total Wholesale Sales 44,308.94; Sales Returns and Allowances -2,058.75; Total Sales Revenue 282,586.66; Total Revenue 282,689.17; COGS-Golf Maps 15,716.42; Total Cost of Goods Sold 80,475.36; Total Expense 241,684.08; Net Income 41,005.09.
Pages 8-69 and 8-70: Change in amounts for the Balance Sheet: Cash 22,966.24; Golf Map Inventory 674.77; Total Inventory 32,698.40; Total Current Assets 98,429.68; Total Assets 114,496.46; FIT Payable 491.92; SIT Payable 364.62; Total Current Liabilities 19,834.92; Long Term Liabilities should appear between Total Current Liabilities and Total Liabilities; Loans Payable 2,970.83; Total Long-term Liabilities 2,970.83; Total Liabilities 22,805.75; Current Earnings 41,005.09; Total Owner’s Equity 91,690.71; Total Equity 91,690.71; and Liabilities and Equity 114,496.46.
Pages 8-73 and 8-74: The changes are the same as the ones listed for pages 8-66 through 8-68 except that Karen Bailey, Capital is 91,690.71 and the final total is 124,429.68.
Page 8-79: Windmill Wheels’ bank statement item for service charge should show $8.00 for Service Charge and $15.00 for NSF Charge.
Solutions Manual: Windmill Wheels:
Trial Balance: Cash 44,948.23; FIT Payable 606.89; SIT Payable 423.26; Sales 341,125.00; Sales Returns and Allowances 1,350.00; Totals 418,741.08.
Income Statement: Sales 341,125; Sales Returns and Allowances 1,350.00.
Balance Sheet: Cash 44,948.23; Total Current Assets 96,433.67; Total Assets 103,949.96; FIT Payable 606.89; SIT Payable 423.26; Total Current Liabilities 12,892.91; Total Liabilities 15,462.74; Liabilities and Equity 103,949.96.
Trial Balance 1/1/1998: Cash 44,948.23; FIT Payable 606.89; SIT Payable 423.26; Alton Long, Capital 88,487.22; Totals 109,532.67.
Camera Corner Practice Set
Page S 2-5: Document 4 should have a note to allow the $72.70 Sales Discount.
Page S 2-9: Document 16 should have Invoice 5879 as $3,034.55 and the Discount as $60.69.
Page S 2-10: Document 25 should say...Make this correction by using the Adjust Invoice feature for purchase invoices... not sales invoices.
Page S 2-16: Document 32 should have a note to allow the $17.48 Sales Discount. Use Deposit Slip 3275 for Documents 32 and 35.
CA—Simply Accounting for Windows, 6.0G Update Page 14
Solutions Manual Packet 5:
CHANGES TO EMPLOYEE PAYCHECKSNAME / FIT / SIT / WITHHELD / NET PAY
Reed, April / 159.38 / 129.57 / 562.99 / 1,712.01
Sakamoto, Jim / 95.63 / 84.31 / 334.25 / 1,290.75
Webster, Alexander / 188.13 / 110.90 / 459.08 / 1,240.92
Yanez, Lupe / 98.50 / 65.19 / 248.04 / 854.46
Journal entries will have the same amounts as shown in the table above.