8.4 Account Summaries
Account Summaries reports display various summarised reports for all the accounting transactions of the company. Account Summaries reports include various reports such as Daily Balances, Transactions Summary and so on. On clicking the Account Summaries option, a list of reports is displayed. Various reports in the list are:
Daily Balances
Daily Summary
Monthly Summary
Consolidated Summary
Transaction Summary
Profit & Loss A/c
Profit & Loss Summary
Min / Max Cash Balances
Account Ledger Comparison
Let us discuss these reports in detail.
Daily Balances
Daily Balances report displays date-wise closing balance for an account for the specified date range. Closing balance will be calculated based on the opening balance of the account and the vouchers that affect the account on a particular date. On selecting the Daily Balances option, a Report Options window appears. Enter the required data in the data fields of the Report Options window and click the Ok button. On clicking the Ok button, a Daily Balances report appears. The report displays the debit / credit closing balance of the account for the dates on which the account has been used in any transaction.
Daily Summary
Daily Summary report displays date-wise opening balance, totals of debit entries and credit entries and the closing balance of an account for the specified date range. On selecting the Daily Summary option, a Report Options window appears. Given here are the data fields that appear in the Report Options window.
Account Name – Select the account for which you want to view the report.
Starting Date – Enter the starting date from which the report is to be generated.
Ending Date – Enter the ending date up to which the report is to be generated.
Show Unmoved Dates Also – Specify ‘Y’ in this data field if you want to view opening / closing balance of the dates on which no transaction has taken place.
206
Enter required data in the data fields of Report Options window and click the Ok button. On clicking the Ok button, a Daily Summary report appears. The report displays the opening balance, debit / credit amount and the closing balance on various dates.
Monthly Summary
Monthly Summary report displays month-wise opening balance, totals of debit entries and credit entries and the closing balance of an Account / All Accounts / Account Group. On clicking the Monthly Summary option, two options appear. The options are:
Vertical – Click this option if you want to view the Monthly Summary report with the months arranged vertically. In other words, the months are listed in one column and the related information for each month is displayed in a separate row. On selecting this option, a Monthly Summary message box appears. In the message box there are following two options:
o One Account – Select this option if you want to view report for a single account.
o Account Group – Select this option if you want to view report for a single Account Group.
Horizontal – Click this option if you want to view the Monthly Summary report with the months arranged horizontally. In other words, the accounts are listed in one row and the related information for each account is displayed month-wise in separate columns. On selecting this option, a Monthly Summary message box appears with following two options:
o Group of Accounts – Select this option if you want to view report for a particular Group of Accounts.
o All Accounts – Select this option if you want to view report for all the accounts.
On selecting the required options, a Report Options window appears. Given here are the data fields that appear in the Report Options window.
Select Account – Select the account for which the report is to be generated.
Select Group – Select the Account Group for which the report is to be generated.
Accounts to be Shown By – Select from the list whether the Account Name, Alias or Print Name is to be displayed in the report.
Enter required data in the data fields of Report Options window and click the Ok button. On clicking the Ok button, a Monthly Summary window appears displaying month-wise debit / credit and closing balance of Account / Account Group.
Consolidated Summary
Consolidated Summary report displays consolidated opening balance, totals of debit entries and credit entries and the closing balance of Accounts / Account Group for a specified date range. On clicking the Consolidated Summary option, two options appear. The options are: