Question

In: Accounting

What should be included on spreadsheets and in accounts payable reports that are prepared for ratification...

What should be included on spreadsheets and in accounts payable reports that are prepared for ratification by management? List seven features.

Solutions

Expert Solution

Today, spreadsheet software is practically a required part of any collection of office software, and it remains as useful now as it was in the beginning. Spread sheet also consists of grids, rows, columns, formulas, commands, text manipulation, printing, title bar, menu bar etc.,
Virtual design:-
Most people process data most easily when it is presented visually, rather than simply existing as a set of hypothetical numbers in the mind. Spreadsheets allow you to lay figures out on a grid, calculating and manipulating them visually.
Automatic calculations:-
This is done in a simple and intuitive manner; to perform a calculation with two different cells on the spreadsheet, simply click a cell, press a key for a mathematical operator such as the "+" sign and click the second cell.
Dynamic Updates:-
Because the value displayed in the cell is based on the values in two other cells, the cell dynamically updates when you change either of the referenced cells. This allows you to test different scenarios by changing the cost of an item, or the percentage of profit. Any time you base the value of one cell on the value of other cells, the value of one cell updates automatically when the other is changed.
Analysis of Data:-
Most spreadsheet software can automatically create graphs and charts from your data, giving you different ways of comparing and analyzing information. These visual representations can also be printed and emailed, or exported into slide shows for presentations.

Reports in account payable:-
Reports within accounts payable are time sensitive in that the financial records only apply to specific periods of time. These time periods can vary depending on the frequency a business owner pays debts and other financial obligations. Usually, reports within accounts payable update monthly to reflect new payments made on recurring debts. These payments apply to larger debts tied to private loans or costs of doing business, including monthly utility payments, private loan payments and mortgage or rent. Accounts payable can also include one-time payments made for purchases of assets, including equipment, replacement parts and advertising fees.

Features of spread sheet:-
1)A spreadsheet allows user to enter and calculate numerical data.
2)Speadsheet greatly increases productivity for anyone who needs to manage receipts, create ‘budgets’ generate financial reports.

3)It combines the features of a general ledger with the flexibility of powerful data analysis and reporting function.

4) It offers integral charting/graphic add database operation.
5) It had keyboard driven pop ups menus as well as key commands making it fast to operate.
6) It uses Macro to produce graphs and charts.

7)It offers graphical tools, pivot tables and chart.
8)It helps to manage data in various formats, thus increasing productivity.


Related Solutions

Historical cost accounting would suggest that items included in reports prepared by accountants should be supported...
Historical cost accounting would suggest that items included in reports prepared by accountants should be supported by contracts and be capable of measurement in dollars. If accountants are to prepare Integrated Reports do you believe this ‘traditional’ view would be able to be implemented? Discuss in the context of measurement. Provide examples.
If a short-term note payable is included in the accounts payable balance on the financial statements,...
If a short-term note payable is included in the accounts payable balance on the financial statements, there is a violation of which of the following balance-related management assertions and the corresponding auditor objectives: A. Completeness assertion and Completeness objective. B. Valuation and Allocation assertion and Cutoff objective. C. Valuation and Allocation assertion and Accuracy objective. D. Valuation and Allocation assertion and Classification objective.
In what situation should short-term debt or notes payable be included as part of the cost...
In what situation should short-term debt or notes payable be included as part of the cost of debt when calculating the WACC?
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable   &nb
ABC reports the following accounts and balances at December 31, 2017: Accounts Payable                     $22,800 Accounts Receivable                  18,800 Cash                                           24,400 Land                                           82,400 Machine                                   129,200 Merchandise Inventory              63,600 Long-term Note Payable            79,200 Short-term Note Payable            14,400 Paid-in Capital                         200,000 Retained Earnings                             ? Sales Revenue                          122,000 Cost of Goods Sold                     80,000 Operating Expenses                   40,000 Required: Prepare a balance sheet at December 31, 2017 Also, prepare an income statement for the year ended December 31, 2017. Ignore depreciation expense and interest expense.
The Zaarour Corporation's October 31 adjusted trial balance included many accounts, including the following. Accounts Payable...
The Zaarour Corporation's October 31 adjusted trial balance included many accounts, including the following. Accounts Payable $21,000 Accounts Receivable $27,000 Cash $23,000 Dividends $13,000 Fees Revenue $152,000 Income Taxes Expense $16,000 Income Taxes Payable $10,700 Insurance Expense $21,000 Interest Revenue $12,000 Prepaid Insurance $12,300 Retained Earnings $53,000 Supplies $16,000 Supplies Expense $15,000 Unearned Fees $12,000 Wages Expense $65,000 Wages Payable $11,000 Determine the dollar balance in the Corporation's income summary account before it was closed to retained earnings. a. $152,000...
accounts payable and accounts receivable
What is the difference between accounts payable and accounts receivable?
Paying $10,000 on an accounts payable results in a ______ to accounts payable. Select one: a)...
Paying $10,000 on an accounts payable results in a ______ to accounts payable. Select one: a) Debit b) Credit c) None of the above
What information is included in the balance-of-payments accounts of a nation? Why are these accounts important?...
What information is included in the balance-of-payments accounts of a nation? Why are these accounts important? Will the balance-of-payments accounts of a country always be in balance? Will the balance of trade always be in balance?
What is the purpose of an AEP? What should be included in an AEP? What is...
What is the purpose of an AEP? What should be included in an AEP? What is NIMS? How do FAA Part 139 Airports use NIMS? What are irregular operations? What are some causes of irregular operations and how can we as airport operations managers prevent them?
Discuss the relationship between the balance in the accounts payable general ledger control account and what is found in the accounts payable subsidiary ledger.
Discuss the relationship between the balance in the accounts payable general ledger control account and what is found in the accounts payable subsidiary ledger.  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT