Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will be provided with the year special journals for their company. You will be process for posting special journals to the ledgers. This is

You will be provided with the year special journals for their company. You will be process for posting special journals to the ledgers. This is a critical first step and will serve as the starting point for the project. You will be required to prepared a pre-adjusted trial balance, then record and post the end of the year adjusting journal entries

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

on January 1, 20X1, Alison the Architect opened the doors to her new business. She issued shares of the company to some family members who were nice enough to invest in her entrepreneurial dream. You are a friend and have offered to provide accounting services to her at a reduced cost. You have taught her how to produce the sales journal, cash receipts journal, purchases journal and cash disbursements journal. We are using a manual accounting system. Maintain your general ledger in pencil. The Board of Directors declared dividends as follows Date 30-Jun $ 30-Oct $ Dividend per Share 0.03 0.03 Payment Date 15-Jul 15-Nov Sales Journal for 20X1 Account Sales 8,360 X 11,210 X 12,880 X 12,200 X 11,970 11,620 X Sales on AIR sales Date Customer Number 15-Jan Customer 1001 11-Feb Customer 1002 15-Mar Customer 1003 18-Apr Customer 1004 7-May Customer 1005 9-Jun Customer 1006 16-Jul Customer 1007 4-Aug Customer 1008 13-Sep Customer 1009 11-Oct Customer 1010 16-Nov Customer 1011 7-Dec Customer 1012 Total 3,710 X 7,960 13,450 9,040 12,120 13,920 128,440 ,102 Cash Receipts for 20x1 401 Accounts Cash Receipts for 20X1 1oh 201 Accounts ** Customer Number Other Receivable Date Cash 319,600 Issuance of stc 1-Jan Stock broker 14-Feb Customer 1001 319,600 2,900 1,700X 3,900 2,900 1-Mar Customer 1001 13-Mar Customer 1002 1,700 RJ 3,900 22-Mar Customer 1001 3,760 3,760 28-Mar Customer 1002 2,200 2,200 CAS 14-Apr Customer 1003 4,500 4,500 18-Apr Customer 1002 5,110 5,110 29-Apr Customer 1003 2,600 4,300 2,600 18-May Customer 1004 4,300 20-May Customer 1003 5,780X 5,780 2-Jun Customer 1004 2,400 4,200X 2,400 6-Jun Customer 1005 4,200 21-Jun Customer 1005 2,400 2,400 23-Jun Customer 1004 5,500 5,500 9-Jul Customer 1006 4,100 4,100 12-Jul Customer 1005 5,370 5,370 24-Jul Customer 1006 2,300 2,300 14-Aug Customer 1006 15- Aug Customer 1007 5,220 1,300 5,220 1,300 30-Aug Customer 1007 700 700 3-Sep Customer 1008 2,800 2,800 18-Sep Customer 1008 1,600 1,600 20-Sep Customer 1007 1,710 1,710 9-Oct Customer 1008 3,560 3,560 13-Oct Customer 1009 4,700 4,700 28-Oct Customer 1009 2,700 2,700 10-Nov Customer 1010 3,200 3,200 18-Nov Customer 1009 6,050 1,800 4,200 6,050 25-Nov Customer 1010 1,800 16-Dec Customer 1011 4,200 16-Dec Customer 1010 4,040 4,040 31-Dec Customer 1011 2,400 2,400 Total 428,600 109,000 319,600 68,000 Number of $1.00 par value shares issued CR Page 1 20X1 Acct 306 Accounting Cycle Project v4.xlsm 420 Purchases Journal for 20X1 Kitchen Supplies Date Vendor 380 15-Jan Costco 810 28-Jan Costco 1,040 15-Feb Costco 1,080 1-Mar Costco 16-Mar Costco 300 2-Apr Costco 160 19-Apr Costco 140 10-May Costco 680 15-Jun Costco 530 16-Jul Costco 400 3-Aug Costco 920 1-Sep Costco 15-Oct Costco 970 14-Nov Costco 320 9-Dec Costco 400 18-Dec Costco 260 Total 8,810 Due Date 14-Feb 27-Feb 17-Mar 31-Mar 15-Apr 2-May 19-May 9-Jun 15-Jul 15-Aug 2-Sep 1-Oct 14-Nov 14-Dec 8-Jan 17-Jan 507 *Classify the purchases of kitchen supplies as kitchen supplies expense Acct. All purchase On Kitchen supplies epp C Accts Pav Salse 2.560 cm - Date 30-Aug 30 Aug 30-Aug 1-Sep 1-Sep 2-Sep 15-Sep 30 Sep 30-Sep 30 Sep 1-Oct 1-oct 30-Oct 30-Oct 30-Oct 1-Nov 14-Nov 15-Nov 15-Nov 30-Nov 30-Nov 30-Nov 1-Dec 14-Dec 30-Dec 30-Dec 30-Dec Check Number Vendor 1,050 Big Phone Company 1,051 Alison the Architect 1,052 Huge Utility Company 1,053 Lucy Landlord 1,054 Insurance for car*** - 10ss Costco Visa 1,056 Internal Revenue Service 1,057 Big Phone Company 1,058 Alison the Architect 1,059 Huge Utility Company 1,060 Lucy Landlord 1,061 Costco Visa 1,062 Big Phone Company 1,063 Alison the Architect 1,064 Huge Utility Company 1,065 Lucy Landlord 1,066 Costco Visa 1,067 Cheap Office Supplies 1,068 Shareholders 1,069 Big Phone Company 1,070 Alison the Architect 1,071 Huge Utility Company 1,072 Lucy Landlord 1,073 Costco Visa 1,074 Big Phone Company 1,075 Alison the Architect 1,076 Huge Utility Company 380 3,030 1,680 1,220 2.560 400 1.520 380 3,030 1,680 1,220 920 380 3,030 1,680 1,220 970 2,050 2,040 380 3,030 1,680 1,220 1.220 380 3,030 380 3,030 1,680 146,000 8,150 3 6,360 14,640 1.680 20,160 505 4560 505 6,050 103 . Total * Classify supplies as office supplies on hand ** Insurance for office is a prepayment for 7 months Insurance for automobile is prepayment for 8 months Useful lives - Straight line depreciation, no salvage value Useful life Automobile Computer Copier disbursement - 910 Cash use for 620 1,210 All ind enteries End Information for adjustments Ending office supplies on hand Ending kitchen supplies on hand Accrue professional service costs (accoutning) Adjust prepaid insurance Record depreciation Tax rate Dividends per share declared December 31 20% 0.06 $ on January 1, 20X1, Alison the Architect opened the doors to her new business. She issued shares of the company to some family members who were nice enough to invest in her entrepreneurial dream. You are a friend and have offered to provide accounting services to her at a reduced cost. You have taught her how to produce the sales journal, cash receipts journal, purchases journal and cash disbursements journal. We are using a manual accounting system. Maintain your general ledger in pencil. The Board of Directors declared dividends as follows Date 30-Jun $ 30-Oct $ Dividend per Share 0.03 0.03 Payment Date 15-Jul 15-Nov Sales Journal for 20X1 Account Sales 8,360 X 11,210 X 12,880 X 12,200 X 11,970 11,620 X Sales on AIR sales Date Customer Number 15-Jan Customer 1001 11-Feb Customer 1002 15-Mar Customer 1003 18-Apr Customer 1004 7-May Customer 1005 9-Jun Customer 1006 16-Jul Customer 1007 4-Aug Customer 1008 13-Sep Customer 1009 11-Oct Customer 1010 16-Nov Customer 1011 7-Dec Customer 1012 Total 3,710 X 7,960 13,450 9,040 12,120 13,920 128,440 ,102 Cash Receipts for 20x1 401 Accounts Cash Receipts for 20X1 1oh 201 Accounts ** Customer Number Other Receivable Date Cash 319,600 Issuance of stc 1-Jan Stock broker 14-Feb Customer 1001 319,600 2,900 1,700X 3,900 2,900 1-Mar Customer 1001 13-Mar Customer 1002 1,700 RJ 3,900 22-Mar Customer 1001 3,760 3,760 28-Mar Customer 1002 2,200 2,200 CAS 14-Apr Customer 1003 4,500 4,500 18-Apr Customer 1002 5,110 5,110 29-Apr Customer 1003 2,600 4,300 2,600 18-May Customer 1004 4,300 20-May Customer 1003 5,780X 5,780 2-Jun Customer 1004 2,400 4,200X 2,400 6-Jun Customer 1005 4,200 21-Jun Customer 1005 2,400 2,400 23-Jun Customer 1004 5,500 5,500 9-Jul Customer 1006 4,100 4,100 12-Jul Customer 1005 5,370 5,370 24-Jul Customer 1006 2,300 2,300 14-Aug Customer 1006 15- Aug Customer 1007 5,220 1,300 5,220 1,300 30-Aug Customer 1007 700 700 3-Sep Customer 1008 2,800 2,800 18-Sep Customer 1008 1,600 1,600 20-Sep Customer 1007 1,710 1,710 9-Oct Customer 1008 3,560 3,560 13-Oct Customer 1009 4,700 4,700 28-Oct Customer 1009 2,700 2,700 10-Nov Customer 1010 3,200 3,200 18-Nov Customer 1009 6,050 1,800 4,200 6,050 25-Nov Customer 1010 1,800 16-Dec Customer 1011 4,200 16-Dec Customer 1010 4,040 4,040 31-Dec Customer 1011 2,400 2,400 Total 428,600 109,000 319,600 68,000 Number of $1.00 par value shares issued CR Page 1 20X1 Acct 306 Accounting Cycle Project v4.xlsm 420 Purchases Journal for 20X1 Kitchen Supplies Date Vendor 380 15-Jan Costco 810 28-Jan Costco 1,040 15-Feb Costco 1,080 1-Mar Costco 16-Mar Costco 300 2-Apr Costco 160 19-Apr Costco 140 10-May Costco 680 15-Jun Costco 530 16-Jul Costco 400 3-Aug Costco 920 1-Sep Costco 15-Oct Costco 970 14-Nov Costco 320 9-Dec Costco 400 18-Dec Costco 260 Total 8,810 Due Date 14-Feb 27-Feb 17-Mar 31-Mar 15-Apr 2-May 19-May 9-Jun 15-Jul 15-Aug 2-Sep 1-Oct 14-Nov 14-Dec 8-Jan 17-Jan 507 *Classify the purchases of kitchen supplies as kitchen supplies expense Acct. All purchase On Kitchen supplies epp C Accts Pav Salse 2.560 cm - Date 30-Aug 30 Aug 30-Aug 1-Sep 1-Sep 2-Sep 15-Sep 30 Sep 30-Sep 30 Sep 1-Oct 1-oct 30-Oct 30-Oct 30-Oct 1-Nov 14-Nov 15-Nov 15-Nov 30-Nov 30-Nov 30-Nov 1-Dec 14-Dec 30-Dec 30-Dec 30-Dec Check Number Vendor 1,050 Big Phone Company 1,051 Alison the Architect 1,052 Huge Utility Company 1,053 Lucy Landlord 1,054 Insurance for car*** - 10ss Costco Visa 1,056 Internal Revenue Service 1,057 Big Phone Company 1,058 Alison the Architect 1,059 Huge Utility Company 1,060 Lucy Landlord 1,061 Costco Visa 1,062 Big Phone Company 1,063 Alison the Architect 1,064 Huge Utility Company 1,065 Lucy Landlord 1,066 Costco Visa 1,067 Cheap Office Supplies 1,068 Shareholders 1,069 Big Phone Company 1,070 Alison the Architect 1,071 Huge Utility Company 1,072 Lucy Landlord 1,073 Costco Visa 1,074 Big Phone Company 1,075 Alison the Architect 1,076 Huge Utility Company 380 3,030 1,680 1,220 2.560 400 1.520 380 3,030 1,680 1,220 920 380 3,030 1,680 1,220 970 2,050 2,040 380 3,030 1,680 1,220 1.220 380 3,030 380 3,030 1,680 146,000 8,150 3 6,360 14,640 1.680 20,160 505 4560 505 6,050 103 . Total * Classify supplies as office supplies on hand ** Insurance for office is a prepayment for 7 months Insurance for automobile is prepayment for 8 months Useful lives - Straight line depreciation, no salvage value Useful life Automobile Computer Copier disbursement - 910 Cash use for 620 1,210 All ind enteries End Information for adjustments Ending office supplies on hand Ending kitchen supplies on hand Accrue professional service costs (accoutning) Adjust prepaid insurance Record depreciation Tax rate Dividends per share declared December 31 20% 0.06 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Efficiency Through Automation

Authors: David Coderre

1st Edition

0470392428, 978-0470392423

More Books

Students also viewed these Accounting questions