BAO2000 Accounting Information MYOB Assignment Semester 2 2023
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
BAO2000 Accounting Information
MYOB Assignment Semester 2 2023
Assignment Due in Week 11
20% of your total marks
ASSUME IT IS NOW 1 July 2023. You are a newly appointed Accountant with "Exotic Handbags Pty Ltd", a retail business and store that operates in inner city Melbourne. The owner of “Exotic Handbags Pty Ltd” is Mrs Gucci Vuitton who has decided to employ you to help his store convert from its current manual accounting system to a new computerised accounting system using MYOB.
Now that you are employed as an accountant for the store, your first task will be to set up the MYOB company file by following the detailed requests of Mrs Vuitton. After completing the setup process, your next task will be to record transactions for the month of July into MYOB. You will then be required to journalise various end-of-month adjustments that are estimated by Mrs. Vuitton. During the month you will also be asked to prepare some reports to inform Mrs Vuitton about the financial situation of “Exotic Hand Bags Pty Ltd”.
Creating the Company File
The following list sets out basic information about business "Exotic Hand Bag s Pty Ltd." that is required to create the company file in MYOB using the New Company File Assistant. Each step in this list corresponds to a window in the New Company File Assistant.
· Enter information about your company. The table below shows the contact details and A.B.N. for
Exotic Hand Bags Pty Ltd
Please take the time to enter these details carefully and accurately into MYOB because they vary for every student and will be used to identify your personalised MYOB company file.
Company Name: |
Exotic Hand Bags Pty Ltd (insert your student ID )* |
A.B.N.: |
26 081 197 276 |
Address: |
10 Powell Street |
Phone Number: |
1800-082-5196 |
Fax Number and E-mail Address |
(leave those fields blank) |
*Remember, if your s1103657, your company name would be Exotic Hand Bags Pty Ltd (s1103657)'.
· About your accounting year. The date on which you are setting up the company file is assumed to be 1 July 2023 (the first day of the current month/Conversion month). Therefore, the current financial year for Exotic Hand Bags Pty Ltd is 2023 which starts in July 2023 and ends in June 2024. In the Current Financial Year field, Mrs Vuitton tells you to select the year in which the company's financial year ends.
· Mrs Vuitton then asks you to select July as the conversion month because you will begin recording transactions for the month of July. He mentions that there should be 12 accounting periods per financial year so that each month matches a calendar month. She also asks you to review your entries because you will not be able to change them after the company file is created.
· “Start with an accounts list provided by MYOB”. Mrs Vuitton tells you to create an accounts list (chart of accounts) starting from one of the lists provided by MYOB Accounting. This will ensure you select the appropriate default accounts list for ‘Exotic Handbags Pty Ltd’.
· The industry classification of Exotic Handbags Pty Ltd’ and select 'Retail Business’.
Accounts list (chart of accounts) information
The accounts list that you are asked to set up for Exotic Handbags Pty Ltd is presented below. For many of the account descriptions, Mrs Vuitton has chosen to use the default descriptions and abbreviations provided by MYOB. To modify the default accounts list that was created during the 'creating a new company file' process, from the options provided on the left side of the Accounts Easy Setup Assistant, click Accounts List. This opens the 'Set up the Accounts List to meet your business needs' window. Next, use that window to modify account names, add new accounts, and delete the unwanted default accounts.
Use the Accounts Easy Setup Assistant to enter the opening balances of detail accounts as at 1 July 2023. The following balance sheet provides the opening balances of those accounts as of 1 July2023.
In the Accounts Easy Setup Assistant, before clicking the Next button in the 'Enter your opening balances' window.
Balance Sheet
Opening Balances 1st July 2023
Account # |
Account |
YTD Debit ($) |
YTD Credit ($) |
1-1100 |
Cheque Account |
60,000 |
|
1-1200 |
Undeposited Funds |
0 |
|
1-1300 |
Payroll Cheque Account |
30,000 |
|
1-4000 |
Accounts Receivable |
0 |
|
1-1300 |
Inventory |
32,000 |
122,000 |
1-2100 |
Buildings |
160,000 |
|
1-2200 |
Office Equipment |
16,000 |
|
1-2300 |
Motor Vehicle |
124,000 |
300, 000 |
|
|
|
422, 000 |
2-1200 |
Accounts Payable |
13,200 |
|
2-1300 |
GST Collected |
-1,200 |
12,000 |
2-1400 |
GST Paid |
0 |
|
2-2100 |
Bank Loans |
68,000 |
|
2-2200 |
Mortgage |
100,000 |
168,000 |
3-1100 |
Share Capital |
|
242,000 |
3-1100 |
|
|
422,000 |
Create Customers, suppliers and inventory
Customers and sales details
Use the appropriate windows in the Sales Easy Setup Assistant to set up the default information for 'Exotic Hand Bags Pty Ltd’ customers. Do not change other information in that setup assistant.
Layout - Choose sale layout |
|
Choose Your Default Sales Layout: |
Item |
Selling Details - Decide on selling details |
|
Income Account: |
Sales Revenue |
Credit limit: |
$30,000 |
Tax Codes - Assign tax codes to your customers |
|
Tax Code: |
GST (Goods & Services Tax) |
Payment Information - Set up payment information |
|
Payment Method: |
Cheque |
Payment is Due |
In a Given No. Days |
Discount Days: |
0 |
Balance Due Days: |
0 |
% Discount for Early Payment: |
0% |
% Monthly Charge for Late Payment: |
0% |
Linked Accounts - Select the accounts to track customer receipts |
|
Account for Customer Receipts: |
Cheque Account |
Account for Undeposited Funds |
Undeposited Funds |
From the list of options provided on the left side of the Sales Easy Setup Assistant, click Customer Cards to open the 'Build your customer list' window. Next, use that window to set up the customers of Exotic Handbags Pty Ltd as listed below:
Profile tab |
|||
Card Type |
Customer |
Customer |
Customer |
Designation |
Company |
Company |
Company |
Name: |
Myer Holdings (H E) |
David Jones Ltd (P) |
Mimico Ltd |
Card ID: |
MH |
DJ |
ML |
Address: |
90 Flinders Street |
166 Burke Street |
87 Collin Street |
City, |
Melbourne, |
Melbourne, |
Melbourne, |
Country: |
Australia |
Australia |
Australia |
Phone#1: |
03 5008 7448 |
03 8052 1834 |
03 953 7136 |
Contact: |
Carol |
Danny |
Pauline |
Selling Details Tab |
|||
A.B.N.: |
77 825 735 728 |
78 105 145 609 |
79 412 215 857 |
Supplier purchase and details
Use the appropriate windows in the Purchases Easy Setup Assistant to set up the following default information for Exotic Hand bags Pty Ltd' suppliers. Do not change other information in that setup assistant.
Layout - Choose purchase layout |
|
Choose Your Default Purchase Layout: |
Item |
Buying Details- Decide on buying details |
|
Expense account: |
Leave this blank |
Credit Limit: |
$40,000 |
Tax Codes - Assign tax codes to your suppliers |
|
Tax Code: |
GST (Goods & Services Tax) |
Payment Information - Set up payment information |
|
Payment Method: |
Cheque |
Payment is Due |
In a Given No. of Days |
Discount Days: |
0 |
Balance Due Days: |
0 |
Discount for Early Payment: |
0% |
Linked Accounts - Select the account to pay your supplier bills |
|
Account for Paying Bills: |
Cheque Account |
2023-11-22