Discuss Accounting Systems And Advanced Reporting Applications

Question:

  • You must use SoundBytes Electronics Practice Set (ISBN 978-0-17-664180-1).
  • You will set up the company manually from scratch using Chapter 4A as a guide.
  • DO NOT use the data files referred to on page 1.
  • Using the data files will result in a mark of 0%
  • NOTE: For any settings not clearly defined or described in these pages use your discretion as to the appropriate setting.
  • Provide me with a list of any assumptions that you make in setting up the company in a work document.
  1. Pages 1, 2, 3 and 4 are provided as background information and need to be used as guidelines for setting up the company
    Page 5 is a guide for the Ratios for the company – see list of reports
  2. Your chart of accounts must be based upon the Adjusted Trial Balance on page 6 (Account codes must have a 0 added to them i.e.: 101 is 1010). You must use appropriate account codes (H, T, A, S, G)
    1. Use history to enter the account balances on page 6.
  3. Use tax settings for GST @ 6% and PST @ 7% wherever HST is used in the practice set.
    HST on Sales and HST on Purc/Serv accounts will need to be changed to reflect the above settings and new accounts created as necessary.
    The opening balance of $1,387 for Account 241 will need to be allocated between the GST and PST accounts.  No allocation is necessary for Account 243
    NOTE: All purchase transactions that have HST will be posted only to the GST account.
    All sales transactions will be posted to both GST and PST accounts.
  4. Set up Customers, Vendors and Inventory according to the lists on page 7.
    Use history to enter the account balances on page 7 (the HST amounts are all allocated to GST accounts).
  5. Page 8 is information needed to calculate and enter the monthly depreciation expense at month end.
  6. Page 9 can be ignored.
  7. Pages 10 and 11 reports to be used as the basis to compare your setup results prior to entering the transactions for April.
  8. Page 12 is information needed to calculate and enter the monthly loan payment at month end.
  9. You must create two employees for the company – one born in 1990 and the other in 1992. Use page 400 as a guide for salaried and hourly employee deductions.
    1. You will need to add the accounts listed on page 378 to your chart of accounts – only those accounts that are necessary to process the payroll need to be added. Use only one account for their earnings.
    2. Use any two names. Use the same federal and provincial tax credits and settings that are used in Chapter 7 pages 392-399. Both employees accrue 4% vacation pay.
    3. One person will be paid a salary or $1,500 every two weeks on April 14 and 28.
    4. The other employee is paid $15 per hour.
      This employee worked 35 hours April 1 to 14; 20 hours April 15 to 28.
  10. Create two projects – Surrey and Kelowna. All revenue and expense transactions must be allocated 50% to each project (100% in total)
  11. Set the modules to ready once you have confirmed your results.
  12. Use pages 13 and 14 as guidelines for entering the April transactions on pages 16 to 30. Vendors and Customers will be created for all sales, receipts, purchases and payments.
  • The April 13 payment to Receiver General will need to be separated into the GST and PST portions (assume that the PST owing is sent to Receiver General). A journal entry on March 30 is required.
  • Create a vendor for Mr. Stammers to record the April 13 cheque for car repairs – do not add taxes to the payment.
  • The April 30 cheque to you is not payroll.
  1. Calculate the ratios listed on page 15 and 59. Submit the ratios in a Word document.
  2. NOTE: Pages 31 to 58 inclusive, 61, 62, 64 to 66 are not used for this project.
  3. A bank reconciliation will be completed at the end of April using the information on page 63. All the payroll cheques for April 14 and 28 have NOT cleared the bank.

Submit the following reports as PDF files in Moodle prior to the due date and time. 

  • Chart of Accounts April 30
  • Trial Balance at March 31
  • Income Statement for the month of April
  • Balance Sheet at April 30
  • Detailed Customer Aged report at April 30
  • Detailed Vendor Aged report at April 30
  • Pending Sales Orders Detail by Customer
  • Inventory Summary at April 30
  • All Journal Entries April 1 to 30
  • General Ledger listing by date for April
  • Bank Account Reconciliation Detail for April 1 to 30
  • Bank Reconciliation Transactions Detail Report April 1 to 30
  • Employee Detail for April 1 to 30
  • Tax Detail by Tax Code for April 1 to 30
  • Income detail reports for the two projects April 1 to April 30

This one report is submitted as a Word Document Ratios calculated from reports at the end of April.

 

 

Pressed for time?

 

Hire a skilled expert and get original paper for 3+ hours now

More Similar Essays

White’s The Clash of Economic Ideas

Pick one of the topics to write a 6 page paper on. Please use citations and quotes mentioned in the topic you chose (An Outline of the history of Economic Thought by Screpanti or The Clash of Economic Ideas by White). 1. Screpanti/Zamagni in chapter 12 provide a host...

read more

Philosophy

1. Wright a summary of content and methods used in the chronological development of metaphysics. 2. Choose a philosopher from the ancient, medieval, or modern period then discuss and compare his distinct metaphysical teaching and method with Martin Heidegger (a...

read more

EXAM 4 History

5 short answer questions 2 essay questions. This exam covers Chapters 13-16 in the textbook.George Brown Tindall and David Emory Shi, America: A Narrative History (11th Edition, Volume 1) ISBN # 978-0-393-66893-3Joshua D. Rothman, Reforming America, 1815-1860. ISBN #...

read more