Unit 8 – Accounting Reports 213

Enter required data in all the data fields of Report Options window and click the Ok button. On clicking the Ok button, an Ageing Analysis (Receivable) report appears displaying various bills and the time slab under which the bill falls. Given here is a screenshot of Ageing Analysis (Receivable) report.

Figure 8.13 Ageing Analysis (Receivable)

è Amount Payable, Bills Payable, Ageing (Payable) reports are totally similar to the Amount Receivable, Bills Receivable and Ageing (Receivable) reports respectively. The only difference is that the former reports display details about the amount / bills payable and the later reports display the amount / bills receivable.

On Account Entries

This option appears only if you have enabled the Bill-by-bill Details checkbox in Administration à Configuration à Features / Options à Accounts tab. On Account entries are those transactions for which bill-by-bill details have not been maintained but Bill-by-Bill Details feature is enabled for the Account used in the voucher. In others words, the transactions in which no bill-by-bill details are maintained are known as On Account Entries. For example, you may not require to maintain account of all parties on bill-by-bill basis or may not need to keep bill-by-bill details for all the transactions related to a party. In such a case, the entries for parties for which Bill-by-bill Details feature is disabled and the entries for which bill-by-bill details are not entered will come under On Account Entries. Thus, On Account Entries report displays the amount receivable from / payable to a Party Account / Party Account Group / All Party Accounts that is not against a particular bill.

Bills Summary

This option appears only if you have selected the Bill-by-bill Details checkbox in Administration à Configuration à Features / Options à Accounts tab. Bills Summary report displays the Bills Receivable, Bills Payable, On Account Entries, Ledger Balance amounts for an Account / Account Group

/ All Accounts. Thus, this report provides an overview of the account status with respect to Bills Receivable / Payable and On Account Entries.

Bill-Wise Statement

This option appears only if you have selected the Bill-by-bill Details checkbox in Administration à Configuration à Features / Options à Accounts tab. Bill-Wise Statement report displays a bill-wise detailed report for an account for a specified date range.

214

Bill Reference Details

This option appears only if you have selected the Bill-by-bill Details checkbox in Administration à Configuration à Features / Options à Accounts tab. Bill Reference Details report displays a detailed report for a particular bill reference of an account. On clicking the Bill Reference Details option, a Report Options window appears. Given here are the data fields that appear in the Report Options window.

Select Account – Select the account whose bill reference is to be considered.

Bill-Ref. No. – Enter the bill reference number whose details you want to view.

Enter the required data in the data fields of Report Options window and click the Ok button. On clicking the Ok button, a Reference Details window appears displaying details of the bill reference.

Review

ü Outstanding Analysis reports provide information regarding outstanding status of payments.

ü Bills Receivable / Payable reports appear only if Bill-by-Bill Details feature is enabled in Features / Options. The reports display details of various bills receivable / payable from / to the party.

ü You can filter various reports on the basis of amount receivable / payable. For example, you want to view report for those parties from whom more than Rs. 10,000 is due. In this case, you can use the Specify Filter on Amount data field provided in the Report Options window.

ü On Account entries are those transactions for which bill-by-bill details have not been maintained but Bill-by-Bill Details feature is enabled in the relevant account.

ü Bills Summary report displays the Bills Receivable, Bills Payable, On Account Entries, Ledger Balance amounts for an Account / Account Group / All Accounts.

ü Bill-Wise Statement report displays a bill-wise detailed report for an account for a specified date range.

Exercise

1 . Balance Sheet lists the:

a) Assets of the company c) Liabilities of the company

b) Net Profit / Loss d) All of the above

2 . Trial Balance is prepared to check:

a) Debit Balances c) Arithmetic Accuracy of Record

b) Credit Balances d) All of the above

3 . Cash / Bank Book displays: