Sage1 Acc417-W24-sage2021 txt sw-Karas Kitchens- online w Excel reports v13a
docx
keyboard_arrow_up
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
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
Related Documents
Related Questions
X
Topic: Discussion - What is the rol X +
rses/1545/discussion_topics/15677?module_item_id=111468
Q Search entries or author...
All
>
↓ Sort
View Split Screen
Expand Threads
You must post before seeing replies. Edit history will be available to instructors.
Due Jan 4, 2025 11:59pm
时☆
10 points possib
Discussion - What is the role of ethics in accounting?
Requirement:
Include Introduction, Body, and Conclusion.
Your initial Discussion posting should be at least 150 words in length.
9 Replies, 9 Unread
Be sure to include a related Title, at least two different citations and references to support your statement
Read and post brief responses to at least two of your classmates' postings (minimum 75 words).
arrow_forward
Computer Accounting with Quicl X
G Google
+ x
A platform.virdocs.com/r/s/0/doc/1530270/sp/174566355/mi/561968185?dfi=%2F4%2F4
EQ 514
+-
514 Chapter 9
Complete the following adjusting entry for Mookie The Beagle Concierge.
In anticipation of stocking Mookie The Beagle Concierge branded inventory, Cy charged
$864 for 6 months storage locker rental from Lynne's Space to Mookie The Beagle
Concierge's VISA credit card on January 1, 2022. So at the end of the accounting period on
January 31, Mookie The Beagle Concierge has used 1 month of rent @ $144 ($864/6 months
$144 per month). The unused rent ($720) is Prepaid Expense: Prepaid Rent, an asset account
with future benefit. Since Cy had not recorded anything related to the storage locker rental,
an adjusting entry is needed to bring accounts up to date at January 31.
1. Complete the following table.
Account
Account Type Increase or Decrease? Debit or Credit? Amount
Rent & Lease
Expense
Asset
Prepaid Expenses: Rent
VISA Credit Card
$.…
arrow_forward
Question 10
What are 2 ways to check a client's subscription level in QuickBooks
Online Accountant?
From the Subscriptions and billing screen from the Gear icon
From the Advanced tab in Account and Settings
From the Clients tab in Account and Settings
By hovering over the qb icon in the Clients menu
From the Company Settings screen from the Gear icon
arrow_forward
Please do question 2
arrow_forward
Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).
arrow_forward
>
A Blackboard Learn
A My Grades - ACCT-1170-017-F X | +
1
U
CA
k
个
N
= X
myCT
ctccs.blackboard.com/ultra/courses/_209880_1/cl/outline
Λ
P*
ACCT-1170-017-Fall 2024-Principles of Managerial Accounting
Question Completion Status:
>
QUESTION 1
Take Test: Unit 4 Homework
Relaunch to update:
Freeman Furnishings has summarized its data as shown. Direct labor hours will be used as the activity
base to allocate overhead:
Raw materials purchased
$ 320,000
Raw materials, beginning inventory
Raw materials, ending inventory
15,000
14,000
Work in process, beginning inventory
35,000
0
Work in process, ending inventory
37,000
Estimated overhead
300,000
Depreciation of factory building
50,000
Factory real estate taxes
Factory utility expenses
Indirect materials
7,382
45,000
20,000
Indirect labor
Direct labor cost
Direct labor hours incurred
11,000
100,000
24,000
Estimated direct labor hours
25,000
Compute the cost of goods manufactured.
ہے
Click Save and Submit to save and submit. Click Save All…
arrow_forward
you will find an article in a scholarly journal dealing with items from the reading of chapters 1 to 4 in the textbook. Topics may include Accounting Information Systems, Enterprise Systems, E-business, and understanding how accounting information systems works. Then, you will write a summary on this article, The student will post one thread of at least 1000 - 2000 words
arrow_forward
Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".
arrow_forward
please help me answer
arrow_forward
I need help filling in my spreadsheet and I have looked up in the library but everyone's answer are coming out wrong. Can you please help me because this is due tomorrow.
Company Accounting Workbook Template Spreadsheet
https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Company%20Accounting%20Workbook%20Template.xlsx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513
Accounting Data Appendix Word Document.
https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Accounting%20Data%20Appendix%201.docx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513
arrow_forward
Recommended Implementation Process
Please do the following:
Introduce yourself to your peers by sharing something unique about your background. Explain how you expect this course will help you move forward in your current or future career.
Use the Internet or Strayer University Library databases and Internet, to select and review a firm that has multiple lines of businesses. For example, review the FedEx Corporation to see how it is a multiple-line business organization.
You reviewed the FedEx Corporation's 2019 annual report and focused on the detailed accounting information. In this week's reading, Lin demonstrates that successful implementation of the shipping company's financial accounting information management systems must go through three steps; implementation of management system module; implementation of financial accounting function; and implementation of management accounting function.
Review the recommended implementation suggested by Lin in Design and Implementation of…
arrow_forward
"iew
History
Bookmarks
Window Help
A education.wiley.com
WP NWP Assessment Player UI Application
DAXMED WALI FURI
Question 30 of 42
View Policies
Current Attempt in Progress
The information for preparing a trial balance on a worksheet is obtained from
general journal entries.
financial statements.
business documents.
general ledger accounts.
Save for Later
OOOO
arrow_forward
Strictly type-written
Required:
• Ledger
• Guide Questions
arrow_forward
Accounting Excel Practice Problem - I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formula figured out.
arrow_forward
NTEGRATE
FABM1 21-22 WEEK 4 TASK
Learning Competency
• The learners shall be able to illustrate the accounting equation (ABM_FABM11-llb-c-8);
Perform operations involving simple cases with the use of the accounting equation (ABM_FABM11-Illb-c-9)
S.Y. 2021-2022
ARISTOTLE
PARMENIDES
EPICURUS
WEEK 4- LEARNING TASK 3 PAGE 21
Learning Task 3: The following transactions were made during the first month of a single
proprietor's business operation.
1. Mr. Y started a grocery store. He invested P 200,00 as initial investment.
2. He registered his business paying P 1,500 for registration.
3. He paid P 20,000 for store rent applicable for one year.
4. He incurred and paid P25,000 for the repair of the grocery store.
5. He purchased merchandise for sale amounting to P 300,000, paying P
200,000 with the balance to be paid after 60 days.
6. He paid P2,000 for the transportation of the merchandise purchased.
7. He hired a saleslady for a contract of P 5,000 per month salary.
8. He sold P100,000 worth…
arrow_forward
Answer the following questionsYou were hired to assist Oman based Company in designing an accounting system for Oman Co., Ltd. has developed a list of the journals, ledgers, reports and documents that he thinks Oman Co., Ltd. The company asks you to complete the following tasks:a) Specify what data you think should be collected on each of the following four documents: Sales invoice, purchase order, receiving report, employee time card.b) Design a report to manage inventory.
arrow_forward
Where can a primary admin accountant user view the apps connects to a client's quickbooks online from within quickbooks online accountant?
arrow_forward
PDE IM-MODULE-3-Account X
+
file:///C:/Users/user/Documents/QUIJANO,%20JAN%20CLEO%20C/ACCOUNTING/IM-MODULE-3-Accounting-Fundamentals-P1-M.Chan%20(1).pdf
Journalizing, Posting and Preparing a Trial Balance
After several years with a large accounting firm, Virgie Dal decided to establish her own
accounting practice. The following transactions of Virgie Dal, CPA, were completed
during May 2012:
May 2
Transferred P92,500 cash from a personal savings account to a checking
account, Virgie Dal, CPA.
Acquired office equipment on account from Gicain Furniture, P36,800.
Acquired office supplies on account from Lorenzo Office Supply
Company, P17,100.
Performed accounting services for Cayaco Computer Company and
submitted a bill of P29,200 for those services.
Paid for accounting and tax books for use in the practice, P19,500.
Paid Lorenzo Office Supply Company, P4,100 on account.
Acquired a condominium unit for the accounting practice, P265,000. A
down payment of P38,000 was made and issued a note…
arrow_forward
Bookmarks
Window
Help
Fri Apr 30 7:38 PM
edugen.wileyplus.com
W WileyPLUS
Bb Upload Assignment: Exercise16b - 2021 Spring Term (1)...
Return to Blackboard
Weygandt, Accounting Principles, 13th Edition, Custom WileyPLUS Course for Bronx Community College
Help | System Announcements
CALCULATOR
PRINTER VERSION
4 ВАСK
NEXT
Exercise 9-12 a-b (Part Level Submission)
Oriole Supply Co. has the following transactions related to notes receivable during the last 2 months of 2020. The company does not make entries to accrue interest except at
December 31.
Nov. 1
Loaned $23,50Chcash to Manny Lopez on a 12-month, 12% note.
Dec. 11
Sold goods to Ralph Kremer, Inc., receiving a $61,200, 90-day, 10% note.
16
Received a $97,200, 180 day, 8% note in exchange for Joe Fernetti's outstanding accounts receivable.
31
Accrued interest revenue on all notes receivable.
(a)
Your answer is correct.
lournalize the transactions for Oriole Supply Co. (Ignore entries for cost of goods sold.) (Credit account titles are…
arrow_forward
Question is attached in the screenshot thanks
grealty appreciated
420ti2492i409y490idf9ib0fi90i
arrow_forward
E Chapter 5 Homework - FINANCIA X
O NWP Assessment Player UI Appli X
b Answered: The accountant of Lati x
M Inbox - dhyani11141999@gmail. X
b My Questions | bartleby
+
i assessment.education.wiley.com/was/ui/v2/assessment-player/index.html?launchld3D1d52287e-dfd8-4d2a-80c9-4cbf51a01297#/question/0
E Chapter 5 Homework
Question 1 of 6
>
-/ 1
View Policies
Current Attempt in Progress
Koch Corporation's adjusted trial balance contained the following asset accounts at December 31, 2020: Cash $7,000, Land
$40,000, Patents $12,500, Accounts Receivable $90,000, Prepaid Insurance $5,200, Inventory $30,000, Allowance for Doubtful
Accounts $4,000, and Equity Investments (to be sold in the next quarter) $11,000.
Prepare the current assets section of the balance sheet. (List Current Assets in order of liquidity.)
КОСН СORPORATION
Balance Sheet (Partial)
2$
2$
1:37 PM
O Type here to search
9/24/2020
2
..
arrow_forward
multiplymovement.com/english_multiply.pdf
WileyPLUS
WileyPLUS: MyWileyPLUS | Help I Contact Us | Log C
Weygandt, Accounting Principles, 13e
FINANCIAL/MANAGERIAL ACCOUNTING (ACC 124/125/201/20
CALCULATOR
STANDARD VIEW
PRINTER VERSION
1 BACK
NEXT
Exercise 10-13 a1-a2 (Part Level Submission) (Video)
Gill Company, organized in 2020, has the following transactions related to intangible assets.
1/2/20
Purchased patent (7-year life)
$595,000
4/1/20
Goodwill purchased (indefinite life)
360,000
7/1/20
10-year franchise
480,000
9/1/20
Research and development costs
185,000
- (a1)
Prepare the necessary entries to record these intangibles. All costs incurred were for cash. Make the adjusting entries as of December 31, 2020, recording any necessary amortization. (Credit
account titles are automatically indented when amount is entered. Do not indent manually. Record journal entries in the order presented in the problem. If no entry is required,
select "No Entry" for the account titles and enter 0…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Related Questions
- X Topic: Discussion - What is the rol X + rses/1545/discussion_topics/15677?module_item_id=111468 Q Search entries or author... All > ↓ Sort View Split Screen Expand Threads You must post before seeing replies. Edit history will be available to instructors. Due Jan 4, 2025 11:59pm 时☆ 10 points possib Discussion - What is the role of ethics in accounting? Requirement: Include Introduction, Body, and Conclusion. Your initial Discussion posting should be at least 150 words in length. 9 Replies, 9 Unread Be sure to include a related Title, at least two different citations and references to support your statement Read and post brief responses to at least two of your classmates' postings (minimum 75 words).arrow_forwardComputer Accounting with Quicl X G Google + x A platform.virdocs.com/r/s/0/doc/1530270/sp/174566355/mi/561968185?dfi=%2F4%2F4 EQ 514 +- 514 Chapter 9 Complete the following adjusting entry for Mookie The Beagle Concierge. In anticipation of stocking Mookie The Beagle Concierge branded inventory, Cy charged $864 for 6 months storage locker rental from Lynne's Space to Mookie The Beagle Concierge's VISA credit card on January 1, 2022. So at the end of the accounting period on January 31, Mookie The Beagle Concierge has used 1 month of rent @ $144 ($864/6 months $144 per month). The unused rent ($720) is Prepaid Expense: Prepaid Rent, an asset account with future benefit. Since Cy had not recorded anything related to the storage locker rental, an adjusting entry is needed to bring accounts up to date at January 31. 1. Complete the following table. Account Account Type Increase or Decrease? Debit or Credit? Amount Rent & Lease Expense Asset Prepaid Expenses: Rent VISA Credit Card $.…arrow_forwardQuestion 10 What are 2 ways to check a client's subscription level in QuickBooks Online Accountant? From the Subscriptions and billing screen from the Gear icon From the Advanced tab in Account and Settings From the Clients tab in Account and Settings By hovering over the qb icon in the Clients menu From the Company Settings screen from the Gear iconarrow_forward
- Please do question 2arrow_forwardAccounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).arrow_forward> A Blackboard Learn A My Grades - ACCT-1170-017-F X | + 1 U CA k 个 N = X myCT ctccs.blackboard.com/ultra/courses/_209880_1/cl/outline Λ P* ACCT-1170-017-Fall 2024-Principles of Managerial Accounting Question Completion Status: > QUESTION 1 Take Test: Unit 4 Homework Relaunch to update: Freeman Furnishings has summarized its data as shown. Direct labor hours will be used as the activity base to allocate overhead: Raw materials purchased $ 320,000 Raw materials, beginning inventory Raw materials, ending inventory 15,000 14,000 Work in process, beginning inventory 35,000 0 Work in process, ending inventory 37,000 Estimated overhead 300,000 Depreciation of factory building 50,000 Factory real estate taxes Factory utility expenses Indirect materials 7,382 45,000 20,000 Indirect labor Direct labor cost Direct labor hours incurred 11,000 100,000 24,000 Estimated direct labor hours 25,000 Compute the cost of goods manufactured. ہے Click Save and Submit to save and submit. Click Save All…arrow_forward
- you will find an article in a scholarly journal dealing with items from the reading of chapters 1 to 4 in the textbook. Topics may include Accounting Information Systems, Enterprise Systems, E-business, and understanding how accounting information systems works. Then, you will write a summary on this article, The student will post one thread of at least 1000 - 2000 wordsarrow_forwardAccounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".arrow_forwardplease help me answerarrow_forward
- I need help filling in my spreadsheet and I have looked up in the library but everyone's answer are coming out wrong. Can you please help me because this is due tomorrow. Company Accounting Workbook Template Spreadsheet https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Company%20Accounting%20Workbook%20Template.xlsx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513 Accounting Data Appendix Word Document. https://learn.snhu.edu/content/enforced/1059513-ACC-201-R5781-OL-TRAD-UG.22EW5/Course%20Documents/ACC%20201%20Accounting%20Data%20Appendix%201.docx?_&d2lSessionVal=z4RVl9IawPfmsxCM81JBkzX5v&ou=1059513arrow_forwardRecommended Implementation Process Please do the following: Introduce yourself to your peers by sharing something unique about your background. Explain how you expect this course will help you move forward in your current or future career. Use the Internet or Strayer University Library databases and Internet, to select and review a firm that has multiple lines of businesses. For example, review the FedEx Corporation to see how it is a multiple-line business organization. You reviewed the FedEx Corporation's 2019 annual report and focused on the detailed accounting information. In this week's reading, Lin demonstrates that successful implementation of the shipping company's financial accounting information management systems must go through three steps; implementation of management system module; implementation of financial accounting function; and implementation of management accounting function. Review the recommended implementation suggested by Lin in Design and Implementation of…arrow_forward"iew History Bookmarks Window Help A education.wiley.com WP NWP Assessment Player UI Application DAXMED WALI FURI Question 30 of 42 View Policies Current Attempt in Progress The information for preparing a trial balance on a worksheet is obtained from general journal entries. financial statements. business documents. general ledger accounts. Save for Later OOOOarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L