Question

Design a report useful to management and describe how to obtain it from the accounting system. Detail the entities and attributes needed, the database relationships needed to obtain those attributes, any other report criteria, and the purpose or use of the report

Answer 1

Answer:- There are many reports are available for management reporting in daily routine working. The following are some examples that are required by the management in the routine office work.

1-Debtors Outstanding Reports.

2-Creditors Outstanding Reports.

3-Fund Flow Statement

4-Daily Stock Statement.

Debtors Outstanding Reports- Debtors Outstanding Reports is basically relating to the accounts receivables from whom we have to receive the payments against goods or services delivered. in business, mostly transaction is made on a credit basis and credit period is also pre-defined before the business is done. the firm to whom goods or services are delivered is called customers or debtors. Debtors Outstanding reports is shows how much due payments are pending from the customers. This report is made through accounts receivable in financial books. Format of the same is given below-

Customer Name	Address	0-30 days	31-60 days	61-180 days	180-365 days	Total Outstanding
X
Y

Creditors Outstanding Reports- Creditors Outstanding Reports is basically relating to accounts payable accounts from whom we purchase or receive goods or services. we have to pay our suppliers on due date after receiving the goods or services. this report is made through accounts payables in financial books. Format of the same is given below-

Supplier Name	Address	0-30 days	31-60 days	61-180 days	180-365 days	Total Outstanding
X
Y

Fund Flow Statement- Fund Flow Statement is usually made on a daily basis this report is showed that how much cash inflow and outflow in routine business working. The formate of the same is given below.

Bank Name	Opening Balance	Cash Inflow(+)	Cash Outflow(-)	Closing Balance
XYZ BANK
ABC BANK

Daily Stock Statement- Daily Stock Statement is relating to the daily incoming and outgoing of stock. Incoming is relating to how much goods are produce and outgoing means how much goods are sale. Rest stock is called closing stock.

Product Name	Opening Stock	Goods Produce(+)	Goods Sale(-)	Closing Balance
Product A
Product B