Question

In: Accounting

Why do some accountants prepare an end-of-period spreadsheet?

Expert Solution

End-of-period spreadsheet - Meaning:

End-of-period spreadsheet refers to a six-columner or ten-columner schedule containing data

related to account titles, un-adjusted trial balance, adjustments, adjusted trial balance, income

statement and balance sheet. Six-columner is restricted to contain data related till adjustments

whereas ten-columner spreadsheet is designed to contain all data. Each component mentioned

above will occupy two rows namely 'Debit' and 'Credit' and at any cost, totals of 'Debit' and 'Credit'

shall be equal which is the checking point in terms of mathematical accuracy of the data posted

into respective ledger items.

End-of-period spreadsheet - Working method:

In end-of-period spreadsheet, the subtotal row of both income statement and balance sheet

columns will never be equal if the firm has earned profit or loss; will be equal if the firm is at

break-even level, that is, no profit - no loss situation. The difference between totals of debit

and credit of both income statement and balance sheet blocks is nothing but the profit or loss

earned or sufferred by the firm during the reporting period for which the spreadsheet is prepared. If totals of debit exceed credit of income statement, it is considered as 'loss' sufferred;

otherwise 'profit' earned. Similarly, if totals of debit of balance sheet exceed credit of balance

sheet block, it is considered as 'profit' earned; otherwise 'loss' sufferred. However, the difference

in totals of debit and credit under both income statement as well as balance sheet blocks shall

be the same at any cost.

End-of-period spreadsheet - How is it useful for the accountants?

As the spreadsheet contain all data from unadjusted trial balance thru balance sheet in a single

page, in case of 10-columner spreadsheet, accountants could gain good control over all such

adjusting entries recorded at the period-end. If any errors were made in terms of wrong posting

to credits and debits in terms of mathematical figures, the spreadsheet will throw error
immediately. So, accountant will be in a position to trace such error in recording in respective line item and will be able to rectify the same easily. Also, both income statement and balance sheet blocks are prepared from the figures of udjusted trial balance. So, firm's income earned or loss sufferred during the reporting period can be easily calculated by looking at the end-of-period spreadsheet itself instead of calculating after preparing financial statements. The end-of-period spreadsheet serves as a self-evaluating tool in terms of mathematical accuracy as well as a single medium that explain both mathematical accuracy of data recorded and financial performance of the firm.

ekkarill92 answered 1 year ago

Q: If you use an end-of-period spreadsheet (work sheet), why do you still have to prepare...

Q: If you use an end-of-period spreadsheet (work sheet), why do you still have to prepare the financial statements? Isn’t all the information the user needs on the spreadsheet? Q: Why do we use the income summary account each month to clear out the revenue and expense accounts? Q: Does anyone make manual entries anymore or even keep a manual set of books?

Why do accountants prepare a trail balance?

Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare...

Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 13.00 5 Accounts Receivable 108.00 6 Supplies 8.00 7 Prepaid Insurance 2.00 8 Land 184.00 9 Equipment 50.00...

Some accounts do not need to be adjusted at the end of the period, since the...

Some accounts do not need to be adjusted at the end of the period, since the day-to-day transactions provide all the data for these accounts. A) True B) False Explain the answer

Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For...

Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For the Year Ended December 31, 20-1 1 ACCOUNT TITLE TRIAL BALANCE DEBIT TRIAL BALANCE CREDIT ADJUSTMENTS DEBIT ADJUSTMENTS CREDIT ADJUSTED TRIAL BALANCE DEBIT ADJUSTED TRIAL BALANCE CREDIT 2 Cash 18,000.00 18,000.00 3 Accounts Receivable 12,600.00 12,600.00 4 Merchandise Inventory 67,500.00 (b) 76,500.00 (a) 67,500.00 76,500.00 5 Estimated Returns Inventory 2,880.00 (e) 3,870.00 (d) 2,880.00 3,870.00 6 Supplies 7,200.00 (f) 4,230.00 2,970.00 7 Prepaid Insurance...

At the end of the accounting period, accountants often need to estimate the receivables and payables...

At the end of the accounting period, accountants often need to estimate the receivables and payables to arrive at the net income. What are the methods to estimate the amounts?

Chapter 4: Completing the Accounting Cycle The end of period spreadsheet is useful in preparing an...

Chapter 4: Completing the Accounting Cycle The end of period spreadsheet is useful in preparing an Adjusted Trial Balance from which the three Financial Statements can be prepared. Please indicate the results in the adjusted Trial Balance under the following circumstances. Please provide an example. a. An account has a debit balance. The adjustment requires a credit to that account. The debit amount is higher than the credit amount. Is the result in the Adjusted Trial Balance a debit or...

on the end-of-period spreadsheet, prepaid insurance has a balance of $2400 in the unadjusted trail balance...

on the end-of-period spreadsheet, prepaid insurance has a balance of $2400 in the unadjusted trail balance debit column and an adjustment of $200 in the adjustments credit column. what amount should appear for prepaid insurance in the adjusted trail balance column and ultimately the balance sheet?

Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet?...

Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet? Select one: a. Unearned Revenue b. Cash c. Prepaid Insurance d. Net Loss

Complete the following end-of-period spreadsheet for Danilo Enterprises. If an amount box does not require an...

Complete the following end-of-period spreadsheet for Danilo Enterprises. If an amount box does not require an entry, leave it blank or enter "0". Danilo Enterprises End-of-Period Spreadsheet For the Year Ended December 31 Adjusted Trial Balance Income Statement Balance Sheet Account Title Debit Credit Debit Credit Debit Credit Cash 14,500 Accounts Receivable 7,500 Supplies 500 Equipment 20,500 Accumulated Depr-Equip 15,000 Accounts Payable 9,500 Wages Payable 3,060 Common Stock 18,240 Dividends 1,000 Fees Earned 34,000 Wages Expense 18,000 Rent Expense 9,300...