代写ACCTG/BTM 437 Accounting Information Systems Project 2代做Python语言

ACCTG/BTM 437 Accounting Information Systems

ACCT/BTM 437 Project 2

Objectives:

●    Gain proficiency in using a popular accounting software system

●    Be able to understand connections among relational tables in a simple enterprise information system

●    Better understand the strong connection between database systems and accounting software

Overview:

On January 1st this year, you opened astore in Edmonton (therefore Jan 1st  is the company start date).

Requirements:

Set up company by using the following basic information (using other information you deem proper in the tutorial):

●    Company Name: Use your own name.

●    Business Number: same as in tutorial

●    Accounts to create:

●    Owner (you already have).

●    Two separate employee accounts; one for serving Customers and the other for Suppliers (See Section 1.3.2)

●    You can reuse the accounts you have used in tutorials.

●    The checking account (CIBCCHK1) has the initial balance $3AAAA as of Oct 30th, this year, where AAAA is your last four digits of student ID.

Note:

QBO version we are using does not support create custom ID fields such as CustID and SupplierID, so you do not need to enter such info. The project will be marked on the correctness of your financial statements;

1.  Enter the following information for your customers, suppliers, and products (initial balances were last confirmed as of Oct 20th this year; and there have been no changes or transactions until the end of Oct):

Customers
			Telephone	Initial Balance (GST included)
C1	Amy Smith	11 11 st	666-6661	$500.00
C2	John Deol	22 22nd Ave	666-6662	$200.00
C3	Justin Johnson	33 33th Road	666-6663	$400.00
C4	Amanda Lam	44 44 Ave	666-6664	$700.00

 

Suppliers
SupplierID	Name	Address	Telephone	OpeningBal (GST included)
VD1	Best Supplies Inc.	105 105 St	888-8887	$1,000.00
VD2	Computer Components Inc.	106 106 Ave	888-8814	$1,500.00
VD3	Office & Computer Supplies Inc.	101 101 Road	888-8888	$2,000.00

Inventory
ItemID	UM	PurchCost	SellingPrice	ReorderPoint	# on Hand
BestSoftware	Each	$40.00	$50.00	10	15
HardDisk1	Each	$100.00	$120.00	15	26
LaserPrinter1	Each	$220.00	$260.00	10	13
Mouse1	Box of 2	$10.00	$20.00	10	12
Tape2	Box of 4	$15.00	$20.00	20	24
TaxSoftware1	Each	$110.00	$140.00	15	30

2.  Transactions in the month of November

They can be found at the Appendix 1. Draw a simple (draft) REA diagram to help yourself understand the connections of the tables in Appendix 1 and three tables (Customers, Suppliers, Inventory).

●    Both purchase and sales cycles should be on one diagram which includes attributes and relationships but not cardinalities (It will NOT be marked so strictly as in Project 1).

●    Lines can cross each other. Foreign keys can be ignored in the (conceptual) REA diagram.

●    You will need to turn it in with your project

Pay attention to the following:

●  Use the Suppliers account to enter transactions for acquisition process and the Customers account for sales process.

●  All sales transactions are credit sale, not cash sale.

●  Warning: Product prices could change over time; standard, quoted, and actual prices could be different. When you record transactions, use the actual numbers.

●  Cash receipts from customers are written in checks and you make bank deposit on the same day.

●  Also, use the Admin account enter the following transactions.

Date	Transaction
Nov 1	Purchased a BMW SUV for $80,000 (plus GST) with $24,000 down payment (with Check No 21). The rest $60,000 was financed on 5-year car loan from CIBC with simple annual interest rate 5%. The total service life of the vehicle is expected to be 10 years with salvage value $8,000.
Nov 2	You contributed $1,000 worth of office furniture for use in the business
Nov 3	Bought office equipment from West Edmon on credit $14,000 (GST included)

4.  John Deol, the customer left you a note saying that he was sorry, could not pay his balance and would not be found in the future. Wrote down his balance as bad debt on Nov 10th  using Bad Debt Expense Account.

5.  Complete the following month end adjustment transactions on Nov 30th :

●    The inventory count taken  on Nov 30th   showed  2 pieces of BestSoftware  are missing. Make adjustment if needed.

a.   Adjustment Account: use an Inventory Adjustment account

●    Use straight-line depreciation on the vehicle for the month.

●    Pay the first month carloan with the interest calculated as the following:

●    Monthly Interest amount =Loan outstanding x annual rate/12

●    Adjust rental expense for the month

6.   On Dec 5th, you received the bank statement (see the Appendix 2) and please do the bank reconciliation.

a. The initial balance is $3A,AAA and the ending balance should be $(4011.25+AAAA) where AAAA is your last four digits.

Turn in:

1.   Turn in a combined PDF file assembled in the following order (important):

●    The first page should be the cover page with your name and your last four digits of student ID

●    The second page should be your simple (draft) REA diagram. You can draw by hand and scan it using your smartphone.

●   Assemble the reports  in the  following order (important!) which should have professional looking, e.g., all columns for a report should be on the same page and so on.

o Profit and Loss Detailed Statement for the month of November.

o Balance Sheet Standard as of Dec 10th  this year

o Reconciliation Report

●   On the last page (optional), answer the following two optional questions:

o What do you like most about this project?

o What are the specific improvements for this project you would like to suggest?

2.   Invite me (yji@ualberta) as your company’s accountant.

Attention: This is an individual project. Avoid any behaviour which could potentially result in suspicions of cheating, plagiarism, misrepresentation of facts and/or participation in an offence. Academic dishonesty is a serious offence and can result in suspension or expulsion from the University.