Practical Completion Point 1
Minnie Armim runs a business Min Armim Wasteage that specialises in energy saving products and advice. She has contacted you for some assistance in setting up a new accounting system. Minnie has managed to collect enough information to create a chart of accounts for you to work from.
This completion point comprises two tasks. Setting up a new system by completing an opening entry and any other relevant journal entries then posting these appropriately; and entering a set of transactions into the general journal and then recording these in the relevant ledgers. After completing these task you will need to review your work and submit.
Task 1
You have been provided with an Excel File which contains the General Journal and Ledger Accounts. The necessary accounts as well as blank accounts to be used if needed have been included. You will need to complete this task by entering the relevant information into the excel spreadsheet provided.
Enter the information below from the chart of accounts and schedules in order to set up Richardâs new system as an Opening Entry into General Journal and post the relevant information to the General Ledger Accounts provided in the excel file.
Min Armim Wasteage - Chart of Accounts as at 1 July 2017
103
Petty Cash
250.00
105
Bank
3,860.00
107
Accounts Receivable Control
15,038.00
109
Allowance for Bad and Doubtful Debts
462.00
111
Inventory on Hand
8,208.00
113
Stationery on Hand
130.00
115
Prepaid Insurance
1,800.00
116
Prepaid Rent
10,000.00
140
Premises
140,000.00
150
Vehicle
23,000.00
151
Acc. Depreciation âVehicle
229.00
160
Equipment
6,400.00
161
Accumulated Depreciation â Equip
1,460.00
199
GST Receivable
1,000.00
207
Accounts Payable Control
5,687.00
205
Wages Expense Payable
862.00
210
Accrued Telephone Expense
481.00
220
Office Supplies Owing
186.00
299
GST Payable
1,950.00
250
Big 4 Bank Mortgage Loan (5-year)
123,000.00
303
Capital â Minnie Armim
75,369.00
Additional Notes
Schedule of Accounts Receivable
as at 1 July 2017
Acc. No.
10701 Unplugged Limited 660
10703 Vin Walker 1,795
10705 The Charity Stores 480
10707 Developing Naturally 6,111
10709 Dental Services SA 2,552
10711 Hotels United 3,440
15,038
Schedule of Accounts Payable
as at 1 July 2017
20701 Get Connected Limited 4,250
20703 Reduce, Reuse, Get Rich 568
20705 Flooded Industries 869
5,687
You will need to enter this information into the appropriate subsidiary ledger accounts.
Task 2
Using the excel file you have already been working on, enter the transactions below into the General Journal and then update the Ledger accounts as required.
Transactions
July 1 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST).
July 2 Received a cheque for $575 from Vin Walker as part payment of their account.
July 5 Issued Cheque number 718 to Flooded Industries. The cheque amount was $782.10 and a discount of $86.9 (including GST of $7.90) was received for early payment.
July 8 Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a total freight charge of $50 and total GST of $85.
July 12 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report.
July 13 Purchased 1000 Energy Saving light globes for $3 each from Get Connected Ltd. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726.
July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST)
Practical Completion Point 1
Minnie Armim runs a business Min Armim Wasteage that specialises in energy saving products and advice. She has contacted you for some assistance in setting up a new accounting system. Minnie has managed to collect enough information to create a chart of accounts for you to work from.
This completion point comprises two tasks. Setting up a new system by completing an opening entry and any other relevant journal entries then posting these appropriately; and entering a set of transactions into the general journal and then recording these in the relevant ledgers. After completing these task you will need to review your work and submit.
Task 1
You have been provided with an Excel File which contains the General Journal and Ledger Accounts. The necessary accounts as well as blank accounts to be used if needed have been included. You will need to complete this task by entering the relevant information into the excel spreadsheet provided.
Enter the information below from the chart of accounts and schedules in order to set up Richardâs new system as an Opening Entry into General Journal and post the relevant information to the General Ledger Accounts provided in the excel file.
| Min Armim Wasteage - Chart of Accounts as at 1 July 2017 | ||
| 103 | Petty Cash | 250.00 |
| 105 | Bank | 3,860.00 |
| 107 | Accounts Receivable Control | 15,038.00 |
| 109 | Allowance for Bad and Doubtful Debts | 462.00 |
| 111 | Inventory on Hand | 8,208.00 |
| 113 | Stationery on Hand | 130.00 |
| 115 | Prepaid Insurance | 1,800.00 |
| 116 | Prepaid Rent | 10,000.00 |
| 140 | Premises | 140,000.00 |
| 150 | Vehicle | 23,000.00 |
| 151 | Acc. Depreciation âVehicle | 229.00 |
| 160 | Equipment | 6,400.00 |
| 161 | Accumulated Depreciation â Equip | 1,460.00 |
| 199 | GST Receivable | 1,000.00 |
| 207 | Accounts Payable Control | 5,687.00 |
| 205 | Wages Expense Payable | 862.00 |
| 210 | Accrued Telephone Expense | 481.00 |
| 220 | Office Supplies Owing | 186.00 |
| 299 | GST Payable | 1,950.00 |
| 250 | Big 4 Bank Mortgage Loan (5-year) | 123,000.00 |
| 303 | Capital â Minnie Armim | 75,369.00 |
Additional Notes
Schedule of Accounts Receivable
as at 1 July 2017
Acc. No.
10701 Unplugged Limited 660
10703 Vin Walker 1,795
10705 The Charity Stores 480
10707 Developing Naturally 6,111
10709 Dental Services SA 2,552
10711 Hotels United 3,440
15,038
Schedule of Accounts Payable
as at 1 July 2017
20701 Get Connected Limited 4,250
20703 Reduce, Reuse, Get Rich 568
20705 Flooded Industries 869
5,687
You will need to enter this information into the appropriate subsidiary ledger accounts.
Task 2
Using the excel file you have already been working on, enter the transactions below into the General Journal and then update the Ledger accounts as required.
Transactions
July 1 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST).
July 2 Received a cheque for $575 from Vin Walker as part payment of their account.
July 5 Issued Cheque number 718 to Flooded Industries. The cheque amount was $782.10 and a discount of $86.9 (including GST of $7.90) was received for early payment.
July 8 Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a total freight charge of $50 and total GST of $85.
July 12 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report.
July 13 Purchased 1000 Energy Saving light globes for $3 each from Get Connected Ltd. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726.
July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST)
Related questions
Now that you have reviewed information about Hi-Fi Way, you are ready to begin the first step in the accounting cycle, recording transactions. On this page of the practice set, you are asked to record transactions that occurred during the first week of June into the company's journals and post the appropriate entries to the ledger accounts. The following transactions occurred throughout the first week of June:
| Week 1 | ||
| Date | Transaction description | |
| 1 | Issued Check No. 570 for $8,400 to pay Realty Bites for two month's worth of rent in advance. | |
| 1 | Obtained a loan of $59,000 from ZNZ Bank at a simple interest rate of 6% per year. The first interest payment is due at the end of August 2017 and the principal of the loan is to be repaid on June 1, 2021. | |
| 3 | Made payment of $764 to Integer Energy for 3 months of electricity up to and including May 31, Check No. 571. | |
| 4 | Turbo Tech paid the full amount owing on their account. | |
| 4 | Paid sales staff wages of $13,224 for the week up to and including yesterday, Check No. 572. Note that $6,637 of this payment relates to the wages expense incurred during the last week of May. | |
| 5 | Paid the full amount owing to Big Telco, Check No. 573. | |
| 7 | Issued Check No. 574 to Office Supplies Warehouse for the purchase of $301 worth of office supplies. | |
After completing this practice set page, you should know how to record basic transactions in the journals provided below and understand the posting process in the manual accounting system. Note that you will record the remaining June transactions in the following sections of this practice set.
Remember, one purpose of using special journals is to make the posting process more efficient by posting the total of most columns in the special journals after all of the transactions for the period have been recorded. However, some parts of a journal entry are still required to be posted on a daily basis. View the company's accounting policies and procedures for details of what is to be posted daily or monthly.
Instructions for week 1
1)Record all week 1 transactions in the relevant journals.
Note that special journals must be used where applicable. Any transaction that cannot be recorded in a special journal should be recorded in the general journal.
2)Post entries recorded in the journals to the appropriate ledger accounts according to the company's accounting policies and procedures.
Note that the relevant totals of the special journals will be posted to the general ledger accounts at the end of the month. You will enter this before you prepare the Bank Reconciliation Statement.
Remember to enter all answers to the nearest whole dollar. When calculating a discount, if a discount is not a whole number, round the discount to the nearest whole dollar. Then, to calculate the cash amount, subtract the discount from the original amount.
Additional instructions
Displaying selected accounting records:
To save space, not all accounting records (e.g. journals and ledgers) will be displayed on every page. However, on each page you can access all accounting records necessary to answer the questions on that page.
There are several tabs representing different views of the accounting records. The active tab by default is Show All, but you may also select to view just one particular accounting record by selecting the appropriate tab.
If you fill in any accounting records and change the view on the page by selecting a different tab, the information that you have entered will remain in that accounting record and be displayed whenever you can see that accounting record.
Before submitting your answers, we recommend that you click the Show All tab and check that all relevant accounting records have been completed. You are required to complete all relevant accounting records before pressing the Submit answers button. Once submitted, you will not be able to return to the page to re-enter or alter your answers.
Journals:
Each transaction recorded in a special journal must be entered in one line. In order to receive full points, you must not split up the relevant transaction into more than one line in the special journal.
For certain transactions in special journals, some accounting textbooks do not always require an account to be chosen under the column labeled Account. In this practice set you arerequired to select an account for each transaction in the special journals. Specifically, in all special journals, under the column labeled Account, you must select the correct account name for each transaction in order to receive full points. Note that for some transactions, this will mean that the account name selected will correspond to the heading of one of the columns in that special journal.
For each journal, in the Post Ref. column you will need to correctly type the account number of the account you are posting to. In particular, in special journals, some accounting textbooks do not always require a reference to be recorded in the Post Ref. column. In this practice set, in order to receive full points, every transaction entered in a special journal requires an entry in the Post Ref. column. Note that in the special journals, if the account name selected for a transaction corresponds to the heading of one of the columns in that special journal, the post ref is to be recorded as an X. This is because these transactions are not posted on a daily basis. In order to receive full points, you must record only the letter Xin the Post Ref. column for these transactions.
Note that in special journals, the Other Accounts column should not be used to record movements of inventory.
There may be entries in the general journal that require posting to both a control account and a subsidiary ledger. In these cases, after you have posted to both ledgers, you should enter the reference for both the general ledger account and the subsidiary ledger account in the Post Ref. column to indicate that you have posted to both accounts. For example, if the reference number for the control account is 110 and the reference number for the subsidiary ledger account is 110-1, you should type '110/110-1' into the Post Ref. column.
General journal entries do NOT require a description of the journal entries.
Ledgers:
When posting a transaction to a ledger account, under the Description column, please type the description of the transaction directly into the field. The exact wording does not matterfor grading purposes. For example, it does not matter in an electricity transaction if you type 'Paid for electricity' or 'Paid electricity bill'.
For each ledger, under the Ref. column, you need to select the correct journal from a list in the drop-down box provided in order to receive full points.
If the balance of a ledger account is zero you do not need to select a debit or credit from the drop-down box.
Each transaction posted to the subsidiary ledgers must be entered in one line. In order to receive full points, you must not split up the relevant transaction into more than one line in the subsidiary ledger.
Both journals and ledgers:
Most journals and ledgers will have blank rows left at the end of the page.
Some journals and ledgers may not require any entries.
When purchases and sales are recorded in special journals, changes in inventory must not be posted to the Merchandise Inventory account in the general ledger on a daily basis.
| And can you all please help me do the Job cost sheet 1, job cost sheet 2, general journal, to accounts ledger,
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
