Question

In: Accounting

What tasks are aided by a work sheet? Why are the debit and credit entries in...

What tasks are aided by a work sheet? Why are the debit and credit entries in the Adjustments columns of the work sheet identified with letters? What is meant by the term “operating cycle?”

Solutions

Expert Solution

a) Accounting worksheets are most often used in the accounting cycle process to draft an unadjusted trial balance, adjusting journal entries, adjusted trial balance, and financial statements.The main purpose of a worksheet is that it reduces the likelihood of forgetting an adjustment and it also reveals arithmetic errors. A worksheet acts as a tool for an accountant and it is not usually intended to be used by third parties.

The major tasks aided by a worksheet are :

Preparing Unadjusted Trial Balances: Listing the current balances for all of a company’s accounts provides accountants a starting point for preparing financial statements.

Entering Adjusted Trial Entries :Accountants can write out any information that they would need to adjust balances before actually doing so. They can provide a thorough assessment of a company’s financial activity by explaining each adjustment for an account. For example,adjustments may be made for accruals, depreciation or inventory adjustments.

Entering Adjusted Balances:Accounting worksheets show how adjusted entries would affect the relevant accounts. Debits and credits should equal out, providing an accurately adjusted trial balance that would allow the adjusting entries to be put into the company’s general ledger.

Entering Relevant Adjusted Balances to Income Statements: After an accountant has confirmed that adjusted trial balances are correct, they can transfer all revenue and expense account balances to the income statement columns on an accounting worksheet. They can then use this income statement as the basis for their formal financial statements.

Entering Relevant Adjusted Balances to Balance Sheets:If the company has earned a profit, credits will outweigh debits and the resulting net income would be added to the balance sheet. If debits exceed credits, a net loss is posted to the company’s balance sheet. All other account balances not included in the accounting worksheet’s income statement columns also are transferred to the balance sheet columns. These include account balances like assets, liabilities and owner’s capital and drawing. Accountants can then prepare the statement of owner’s equity, prepare the company’s financial statements and journalise and post adjusting entries.

b) As each adjustment is entered in the adjustment column of the worksheet , a letter is used to identify the debit and credit parts of the same entry. In practice, this letter may be used as references to supporting computations or documentation underlying the adjusting entry.

c) The operating cycle is the average period of time required for a business to make an initial outlay of cash to produce goods, sell the goods, and receive cash from customers in exchange for the goods.

A manufacturer's operating cycle is amount of time required for the manufacturer's cash to be used to:

  • pay for the raw materials needed in its products
  • pay for the labor and overhead costs needed to convert the raw materials into products
  • hold the finished products in inventory until they are sold
  • wait for the customers' cash payments to be collected

Related Solutions

Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial balance(credit) Cash 32,236.75 32,236.75 baking supplies 18,500 18,500 merchandise inventory(fifo) 175.65 175.65 prepaid rent 1500 1500 prepaid insurance 2400 2400 baking equipment 6000 6000 accumulated depreciation 208.33 208.33 office supplies 600 600 accounts receivable 7700 7700 notes payable 10,000 10,000 wages payable 480 480 common stock 16,000 16,000 dividends 10,000 10,000 bakery sales 55,000 55,000 merchandise sales 221 221 baking supplies expense rent expense...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Mar. 1...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Mar. 1 Bal., 7,200 units, 4/5 completed 12,528 31 Direct materials, 129,600 units 168,480 181,008 31 Direct labor 49,490 230,498 31 Factory overhead 27,838 258,336 31 Goods finished, 131,400 units 249,372 8,964 31 Bal. ? units, 3/5 completed 8,964 a. Based on the above data, determine each cost listed below. Round "cost per equivalent unit" answers to the nearest cent. 1. Direct materials cost per equivalent...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Dec. 1...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Dec. 1 Bal., 24,000 units, 3⁄4 completed 116,700 31 Direct materials, 134,000 units 234,500 351,200 31 Direct labor 150,000 501,200 31 Factory overhead 375,000 876,200 31 Goods finished, 128,000 units 760,700 115,500 31 Bal., ? units, 1⁄2 completed 115,500 a. Based on the above data, determine each cost listed below. Round "cost per equivalent unit" answers to the nearest cent. 1. Direct materials cost per equivalent...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Mar. 1...
ACCOUNT Work in Process—Baking Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit Mar. 1 Bal., 4,800 units, 2/5 completed 11,232 31 Direct materials, 86,400 units 172,800 184,032 31 Direct labor 50,600 234,632 31 Factory overhead 28,456 263,088 31 Goods finished, 87,600 units 253,944 9,144 31 Bal. ? units, 3/5 completed 9,144 The following information concerns production in the Baking Department for March. All direct materials are placed in process at the beginning of production. a. Based on the...
Record these transactions of the XYZ Corporation company by recording the debit and credit entries directly...
Record these transactions of the XYZ Corporation company by recording the debit and credit entries directly in the T-accounts. Use the date for each transaction to identify the entries, placing the date in the left-hand cell and the amount in the right-hand cell on the appropriate side of the T-account. Then determine the balance of each account using the starting balances as shown, and write 'Balance' (or 'Bal') next to it, in the left-hand cell on the appropriate side. August...
What is a debit? What is a credit? What is the fundamental accounting equation?
  What is a debit? What is a credit? What is the fundamental accounting equation?
For each of the following incorrect entries. Entry Description Debit Credit a. Office Supplies 1,800 Cash...
For each of the following incorrect entries. Entry Description Debit Credit a. Office Supplies 1,800 Cash 1,800 (Purchase of office supplies on credit.) b. Cash 4,500 Revenue 4,500 (Received from customer. A credit customer paid their account in full) c. Salaries Expense 1,500 Cash 1,500 (Withdrawal of cash for personal use.) d. Cash 750 Accounts Receivable 750 (Performed services and received payment from customer on the same day.) Journalize the appropriate correcting entry(ies). Next prepare journal entries
Prepare an income statement and a balance sheet using the journal entries below. Date Particulars Debit...
Prepare an income statement and a balance sheet using the journal entries below. Date Particulars Debit ($) Credit ($) Jan 1 Cash 260,000 Office Equipment 90,000 Common Stock 350,000 Jan 1 Land 20,000 Building 120,000 Cash 50,000 Notes Payable 90,000 Jan 1 Insurance Expense 2,400 Cash 2,400 Jan 3 Office Supplies 3,600 Accounts Payable 3,600 Jan 5 Petty Cash 400 Cash 400 Jan 7 Advertising Expense 1,800 Cash 1,800 Jan 10 Accounts Receivable 12,000 Consulting Revenue 12,000 Jan 12 Cash...
DEBIT AND CREDIT ANALYSIS: Complete the following statements using either “debit” or “Credit” The cash account...
DEBIT AND CREDIT ANALYSIS: Complete the following statements using either “debit” or “Credit” The cash account is increased with a                                                 ___________Debit________ The common stock account is increased with a                                   ____________Credit________ The equipment account is increased with a                                            ____________________ The cash account is decreased with a                                                 ____________________ The accounts payable account is increased with a                    ___________Credit_________ The revenue account Delivery Fees is increased with a                               ____________________ The asset account Accounts...
Why an increase in cash equivalents called debit and not credit according to the journal entry?...
Why an increase in cash equivalents called debit and not credit according to the journal entry? Bank statements show as a credit the increase in the cash equivalents of our account (e.g payroll)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT