Computerized Accounting with

Sage 50 2017

COMPREHENSIVE PROBLEM ONE

Chapters 1 through 7

Tracy Madding is an attorney opening her own office on March 1, 2017. She operates her business as a sole proprietorship. The office is located at 1345 Main Street, Lodi, CA 95240. The owner of the building, Apex Business Management, signed Tracy to a one-year lease for $800 per month. The IRS issued her an employer identification number of 15-6789545. Tracy called the local telephone company, Pacific Bell, and arranged for two lines: telephone 209-555-9899; fax 209-555-3211.

Tracy spoke with an accountant, and together they decided that Tracy should use the accrual method of accounting because she may, in the future, give credit terms to her clients. Tracy's business will use real time posting, an accounting period of 12 months, and a fiscal year beginning January 2017.

Activities for March 2017

1.Set up the company with the name of Tracy Madding, Attorney-at-Law (Your Last Name).

2.Create a chart of accounts using the information below:

Assets:

Account IDDescriptionAccount Type

101CashCash

104Accounts ReceivableAccounts Receivable

106Office SuppliesOther Current Assets

108Prepaid InsuranceOther Current Assets

110Prepaid RentOther Current Assets

115Computer EquipmentFixed Assets

115.5Accum. Depr.-Computer Eq. Accumulated Depreciation

120Law LibraryFixed Assets

120.5Accum. Depr.-Law LibraryAccumulated Depreciation

125Furniture & FixturesFixed Assets

125.5Accum. Depr.-Furniture & Fxt.Accumulated Depreciation

Liabilities:

Account IDDescriptionAccount Type

211Accounts PayableAccounts Payable

213Notes PayableOther Current Liabilities

215Unearned RevenueOther Current Liabilities

217Salaries PayableOther Current Liabilities

Owner's Equity:

Account IDDescriptionAccount Type

311Tracy Madding, CapitalEquity-doesn't close

312Tracy Madding, Retained Earn.Equity-Retained Earnings

313Tracy Madding, DrawingEquity-gets closed

Revenue:

Account IDDescriptionAccount Type

410Consulting FeesIncome

412Court FeesIncome

Expenses:

Account IDDescriptionAccount Type

510Salaries ExpenseExpenses

512Rent ExpenseExpenses

514Utilities ExpenseExpenses

516Telephone ExpenseExpenses

518Paraprofessional Fees ExpenseExpenses

520Advertising/Printing Expenses

522Equipment RentalExpenses

524License FeesExpenses

526Office Supplies ExpenseExpenses

528Depr. Expense-Computer Eq.Expenses

529Depr. Expense-Law LibraryExpenses

530Depr. Expense-Furniture & Fxt.Expenses

532Miscellaneous ExpenseExpenses

534Maintenance ExpenseExpenses

536Insurance ExpenseExpenses

3.Change the accounting period to March 1, 2017 and begin posting all transactions described below to the appropriate accounts. Create any needed accounts that are not currently in the chart of accounts. Also, create vendor and customer accounts as needed. Terms for both vendor and customer accounts are net 30 days with no discount.

Transactions for March 2017

Mar. 1Tracy invested $50,000 cash, a law library valued at $25,000, and office furniture valued at $20,000 into her business.

Paid a business license fee of $250 to the City of Lodi, 234 West Main Street, Lodi, CA 95240, Vendor ID 001. Use check number 001.

Purchased a $10,000 computer system (Invoice 39987) paying $5,000 down (check number 002) and financing the balance with Circuit City of Modesto, 2115 Main Street, Modesto, CA 95355. Use Vendor ID 002.

Paid the March office rent of $800 (Rent Expense) and a security deposit of $1,200 (Prepaid Rent) to Apex Business Management, 1234 River Road, Lodi, CA 95240. Use Vendor ID 003, check number 003.

Paid insurance for the year of $3,600, one year in advance, to Forbes Casualty, 3667 Woodside Drive, Lodi, CA 95240, check 004. Use Vendor ID 004.

Mar. 4Paid for Yellow Page ad of $450, check 005, to Pacific Bell, 45 West Lane, Lodi, CA 95240, Vendor ID 005.

Paid $340 for office supplies, check 006, to Target, 13 North Highland Ave., Stockton, CA 95210, Vendor ID 006.

Received a $12,000 consulting fee from Michelle Anzures, 2334 Handle Ave., Lodi, CA 95240. Use Customer ID 100, reference 2364.

Mar. 7Paid $250 to Richard Martinez to have carpets cleaned (Maintenance Expense), check 007.

Provided consulting services to John Nance, 2112 Glen View Road, Stockton, CA 95210. Charged the customer $400 on account and used Customer ID 101, Invoice 200.

Represented new client David Henry, 356 Boston Way, Modesto, CA 95355, in court charging a $5,000 consulting fee and $125 per hour for the 2 hours of court time, on account, Invoice 201. Use Customer ID 102 and change the credit limit to $10,000.

Mar. 10Paid $1,200 for office supplies from Circuit City, check 008.

Paid $125 for a subscription, check 009, to the Law Review, 2936 Madison Ave., New York, NY 02663, Vendor ID 007. Create the account for the expense: Professional Publication, Account ID 538.

Paid $2,500 for Invoice 39987 to Circuit City, check 010.

Received $2,500 from David Henry on account, reference 2636.

Mar. 15Paid the paraprofessional's fee of $1,450 to Janice Smith, 64 Black St., Lodi, CA 95240, Vendor ID 008, check 011.

Consulted with Michelle Anzures charging $250 on account, Invoice 202.

Tracy Madding took a cash draw of $1,500, check 012.

Mar. 18Leased a postage machine, paying $250 for the initial fee (check 013), from Pitney Bowes, 1112 Mission Blvd., San Francisco, CA 94112. Use Vendor ID 009.

Billed $450 for consulting services to Henry James, 3467 Natural Rock Drive, Ceres, CA 95223. Use Customer ID 103, Invoice 203.

Mar. 25Henry James paid $225 on account, reference 360.

Leased a copy machine for $225 per month from Xerox Copy Machines, 2332 Pacific Avenue, Stockton, CA 95210, paying 3 months in advance (check 014). Establish a new account for Prepaid Copier Expense, Account ID 109. Use Vendor ID 010. (Remember that a prepaid expense is an asset account.)

Received the balance from David Henry on account, reference 611.

Paid The Valley Register, 67 Forrest Glen Road, Modesto, CA 95352, for a newspaper ad, $600. Use Vendor ID 011 and check 015.

Performed $1,050 worth of consulting services for Jim Nelson, 2123 Woodward Lane, Lodi, CA 95240, Customer ID 104, receiving half the balance (reference 1820) immediately and placing the remainder of the balance on account, Invoice 204.

Mar. 31Paid the City of Lodi for the water bill of $45, issuing check 016. Use Utilities Expense.

Paid MID, 2334 March Lane, Modesto, CA 95355, for the utility bill of $57, issuing check 017. Use Vendor ID 012.

Paid Pacific Bell for the monthly telephone bill of $125, issuing check 018.

Received a postage bill of $27.50 from Pitney Bowes, issuing check 019. Establish a new account for Postage Expense, Account ID 540.

4.Print a general ledger trial balance as of March 31, 2017.

5.Enter the following adjusting entries as of March 31, 2017:

a.Office supplies on hand, $1,086.

b.Salaries accrued, $1,450.

c.Depreciation on computer equipment, $200.

d.Depreciation on law library, $150.

e.Depreciation on furniture and fixtures, $125.

f.One month of insurance expired.

g.One month of prepaid copier expense expired. Use Equipment Rental as the expense account.

6.Prepare an income statement for the month of March 2017.

7.Prepare a balance sheet as of March 31, 2017.

8.Print the journal entries for the month of March.

Activities for April 2017

1.Change the accounting period to April.

2.Post all transactions described below to the appropriate accounts. Create any needed accounts that are not currently in the chart of accounts. Also, create vendor and customer accounts as needed.

TRANSACTIONS FOR APRIL 2017

Apr. 1Paid accrued salary from the March 31 adjusting entry, issuing check 020. Pay to the order of Jim Bowen. Hint: Debit Salaries Payable.

Earned $1,890 on account for consulting services rendered to Jennifer Cullum, 345 South Fork Drive, Modesto, CA 95357. Use Customer ID 105 and Invoice 205.

Paid the office rent for April, check 021.

Apr. 4Collected the balance due from Jim Nelson, reference 2651.

Paid Office Depot for repairs to office furniture (Maintenance Expense), $250, check 022.

Purchased $250 of office supplies from Tracy Business Supply, 25 West 10th St., Tracy, CA 95376. Use Vendor ID 013 and check 023.

Apr. 6Received $890 of the balance due from Jennifer Cullum, reference 6223.

Earned 3 hours in court fees on account at the rate of $135 per hour from Michelle Anzures, Invoice 206.

Received and paid the $125 postage machine lease bill (Equipment Rental) from Pitney Bowes, check 024.

Apr. 12Received the balance due from Jennifer Cullum, reference 6255.

Apr. 15Paid the paraprofessional's fee of $1,450 to Lucy Henderson, issuing check 025.

Received $2,500 for consulting services from Heather Cady, 543 North Hass Blvd., Manteca, CA 95337. Use Customer ID 106 and reference 925.

Apr. 20Earned $450 in consulting fees on account from Heather Cady, Invoice 207.

Apr. 23Tracy Madding took a $1,200 cash draw, issuing check 026.

Apr. 26Paid MID $124 for the monthly utility bill, issuing check 027.

Paid the City of Lodi $42 for the water bill, issuing check 028.

Paid Pacific Bell for the telephone bill of $345, issuing check 029.

Paid Pitney Bowes $29.25 for the postage due, issuing check 030.

Apr. 30Arranged for a $1,345 newspaper ad campaign from The Valley Register, Invoice 1723.

3.Print a general ledger trial balance as of April 30, 2017.

4.Enter the following adjusting entries as of April 30, 2017:

a.Office supplies on hand, $960.

b.Salaries accrued, $1,450.

c.Depreciation on computer equipment, $200.

d.Depreciation on law library, $150.

e.Depreciation on furniture and fixtures, $125.

f.One month of insurance expired.

g.One month of prepaid copier expense expired.

5.Prepare an income statement for the month of April 2017.

6.Prepare a balance sheet as of April 30, 2017.

7.Print the journal entries for the month of April.

8.Print the following reports for the period of March 1, 2017 to April 30, 2017:

a.Vendor Ledgers

b.Customer Ledgers