Sage1 Acc417-W24-sage2021 txt sw-Karas Kitchens- online w Excel reports v13a

docx

School

Seneca College *

*We aren’t endorsed by this school

Course

417

Subject

Accounting

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by SargentHeat5769

Report
ACC417 - Sage 50 Assignment #1 Winter 2024 Chapter 10 – Kara’s Kitchens - Using Sage50 Accounting 2021 textbook version, M Purbhoo, Pearson You should already know from your prior course how to use the Sage50 2021 software Accounting program and how to use your textbook to complete these cases and to enter new types of transactions. As usual, you should review the company information in the text before beginning this case for any special company procedures you may need to know. Be sure and note the special instructions below – some will be specific to our class section. o Record only the first 23 transactions (up to only part of Aug 17 ) o Do NOT record transactions #24 - #34. Many marks will be deducted if any of these are in your file , even if you entered them and subsequently deleted or reversed them o Personalize your assignment by adding the extra information as noted below You are required to personalize your assignment by 1. Adding your name to the company name so all your reports say “ Karas Kitchens – your name at the top 2. For the transaction(s) below: add to field indicated your initials + the last 3 digits of your student number Page# Trans # Date Transaction Field 370 3 Aug 2, 2024 Purchase Invoice KC-884 -xx-### Invoice # Example: name P eter A lpaugh, [ PA ] + student number is 123-156- 789 , [ 789 ] then item 3 above will be KC-884 -PA-789 [initials = 1 st letter of first name + 1 st letter of last name] If your submission shows any of these transactions processed without your initials and number or if “corrected” by inserting information after initial entry , 20% will be deducted. Please backup your work often. Keep past backups named sequentially. If you lose your file you won’t have to restart. (If you use Seneca Virtual Commons be sure to backup to your Onedrive or home computer. [not just Seneca computer]) Required submissions: On or before the due date Upload to Blackboard 2 files (not a zip file) - “ backup” file of final Sage data + Excel file with your reports. In Blackboard choose the menu item that says “Sage 50 Assignment submission files upload here”. 1. Reports - as 5 separate worksheets in a single Excel workbook file (use “Reports”, not “Report Center”) [Actual information in Excel worksheet cells, as you would send to head office, not a picture of a report on screen] Name your Excel reports file “ Kara - yourfirstname.yourlastname .xls (or .xlsx) a) TB: Trial balance – Aug 17 Choose “Hide accounts with zero balances” . Otherwise use default options . b) GL: General Ledger account #1540 Refrigerators only - Aug 1 to Aug 17 with corrections c) JE: All journal entries - Aug 1-17 , date order , with corrections (must be with corrections) There will be a 40% deduction if your Journal entry report is not done with “include corrections” d) Products: Retail Reports => Product Analysis- Top 20% [must change to 100% ] - Summary version - Aug 1-17 e) Questions: Copy these to a separate worksheet (in your single Excel file) and type answers based on your reports Choose only goods (eg. F010 Refrigerator ….) not services (eg. C010 Cooking 101 …) for your typed answers 1) Which goods had the most sales $? _ eg. R110 Gas Cooktop 5 Burner w/grill _ 2) Which goods had the most gross profit $? __________________ 3) Which goods had the highest return on average investment? __________________ 2. “Backup” file of your final Sage data file [using Sage50 2021 software version] Name your Sage50 backup file “ Kara - yourfirstname.yourlastname .CAB If the reports from your backup file do not match your Excel reports you may be awarded a mark of “0” ! Due Date – as specified in class due dates list on Blackboard (approximately Week 6 ). Generally late assignments cannot be accepted. Some special situations may be able to mark out of 50% . 0225ac4cd8975f0c30401ad615cfc67c5eee8fe6.docx 1 2 3 3a 3b
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help