Bay Book and Software has two sales departments: Book and Software. After recording and posting all adjustments, including the adjustments for merchandise inventory, the accountant prepared the adjusted trial balance (shown on the next page) at the end of the fiscal year. Merchandise inventories at the beginning of the year were as follows: Book Department, 53,410; Software Department, 23,839. The bases (and sources of figures) for apportioning expenses to the two departments are as follows (rounded to the nearest dollar): Sales Salary Expense (payroll register): Book Department, 45,559; Software Department, 35,629 Advertising Expense (newspaper column inches): Book Department, 550 inches; Software Department, 450 inches Depreciation Expense, Store Equipment (property and equipment ledger): Book Department, 7,851; Software Department, 2,682 Store Supplies Expense (requisitions): Book Department, 205; Software Department, 199 Miscellaneous Selling Expense (volume of gross sales): Book Department, 240; Software Department, 110 Rent Expense and Utilities Expense (floor space): Book Department, 9,000 square feet; Software Department, 7,000 square feet Bad Debts Expense (volume of gross sales): Book Department, 1,029; Software Department, 441 Miscellaneous General Expense (volume of gross sales): Book Department, 364; Software Department, 156 Required Prepare an income statement by department to show income from operations, as well as a nondepartmentalized income statement (using the Total columns) to show net income for the entire company.

Instructions This assignment is designed for practicing both the retailer/merchandiser accounting cycle and your basic excel skills. Below are select sales transactions for two companies. You will need to enter the missing pieces of each transaction on the journal entry tab. Each missing piece of information is highlighted in yellow. The only cell where an actual number is to be input is on the journal entries worksheet. Please note: not every yellow cell requires input (it could be left blank if appropriate). After completing the journal entries, you must then complete the missing pieces of the T accounts, trial balance, and statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on these pages. DO NOT INPUT THE ACTUAL NUMBER INTO THE T ACCOUNTS, TRIAL BALANCE, OR STATEMENTS. Use excel functions (such as making a cell equal another from the journal entry page, summing numbers together, or using the plus or minus symbols to help you…

Plumb Line Surveyors provides survey work for construction projects. The office staff use office supplies, while surveying crews use field supplies. Purchases on account completed by Plumb Line Surveyors during May are as follows: Instructions 1. Insert the following balances in the general ledger as of May 1: 2. Insert the following balances in the accounts payable subsidiary ledger as of May 1: 3. Journalize the transactions for May, using a purchases journal (p. 30) similar to the one illustrated in this chapter. Prepare the purchases journal with columns for Accounts Payable, Field Supplies, Office Supplies, and Other Accounts. Post to the creditor accounts in the accounts payable subsidiary ledger immediately after each entry. 4. Post the purchases journal to the accounts in the general ledger. 5. a. What is the sum of the creditor balances in the subsidiary ledger at May 31? b. What is the balance of the accounts payable controlling account at May 31? 6. What type of e-commerce application would be used to plan and coordinate transactions with suppliers?

MacDonald Bookshop had the following transactions that occurred during February of this year: Required 1. Journalize the transactions for February in the cash payments journal. Assume the periodic inventory method is used. 2. If you are using Working Papers, total and rule the journal. Prove the equality of the debit and credit totals.

Maddie Inc. has the following transactions for its first month of business. A. What are the individual account balances, and the total balance, in the accounts receivable subsidiary ledger? B. What is the balance in the accounts receivable general ledger (control) account?

Using the following revenue journal for Zeta Services Inc., identify each of the posting references, indicated by a letter, as representing (1) posting to general ledger accounts or (2) posting to subsidiary ledger accounts:

The first step in posting the sales journal to the general ledger is to total and verify the equality of the amount columns. enter the date in the Date column of the ledger account. enter the new balance in the Balance columns of the ledger account. enter the ledger account number below the column totals in the journal.

Which of the following will be the Correct source document assuming that your business received invoices from various suppliers each day? a. Credit note b. Purchase invoice c. Sales invoice d. Receipt

ACCOUNTING PROCEDURES, POLICIES, AND INSTRUCTIONS I. Maja’s Consultancy reports its operations monthly. II. Maja’s Consultancy uses voucher system for every cash disbursement. III. Prepaid expenses are recorded using asset method. IV. Instructions: a) Journalize each transaction using the source documents provided. b) Post the journalized transactions to its corresponding general ledger. c) Prepare trial balance. d) Determine the balances in each account and prepare the unadjusted trial balance in the worksheet. e) Answer the data for adjustments. f) Journalize the adjusting entries and prepare it in the worksheet. g) Complete the worksheet. h) Prepare the financial statements. i) Post the adjusting entries j) Journalize and post the closing entries. k) Prepare the post-closing trial balance. V. Data for adjusting entries: a) Per count, the office supplies on hand amounted to P2,000. b) Received the September billing from PLDT, P1,500. c) 1% of accounts receivable is uncollectible.…