Unit 8 – Accounting Reports 203
Sales Register
Sales Register report displays both the cash and credit sales transactions. It contains information regarding the bill number, date, party, amount and so on of all the sales transaction. On clicking the Sales Register option, a Sales Register message box appears. In the message box, there are two options. The options are:
All Sale Type – Select this option if you want to view sales transactions entered for any Sale Type.
One Sale Type – Select this option if you want to view sales transactions entered for a single Sale Type.
On selecting any of the above option, a Sales Register message box appears. In the message box, there are four options. The options are:
All Parties – Select this option if you want to view sales transactions for all the parties.
One Party – Select this option if you want to view sales transactions for a single party.
Group of Parties – Select this option if you want to view sales transactions for a particular group of parties.
Selected Parties – Select this option if you want to view sales transactions for selected parties. On selecting this option, a List of Accounts window appears in which you can select the parties for which you want to view the report.
On selecting any of the above option, a Report Options window appears. Given here are the data fields that appear in the Report Options window.
Sale Type – Select the Sale Type for which you want to view the sales transactions.
Select Account / Group – Select the Party / Party Group for which you want to view the sales transactions.
Voucher Series – Select the voucher series whose vouchers are to be displayed. If you want to view all the vouchers then select All option from the list.
Starting Date – Enter the starting date from which Sales vouchers are to be picked for generating the report.
Ending Date – Enter the ending date up to which Sales vouchers are to be picked for generating the report.
Account to be Shown By – Select from the list whether the Account Name, Alias or Print Name is to be displayed in the report.
Show Bifurcation of Amount – Specify ‘Y’ in this data field if you want to view bifurcation of the bill amount in the report. On specifying ‘Y’ in this column, separate columns for displaying sale amount, tax amount, surcharge amount and any other amount will appear in the report.
Show Mobile No. of Parties – Specify ‘Y’ in this data field if you want to view mobile number of the party in the report.
204
Enter required data in the data fields of the Report Options window and click the Ok button. On clicking the Ok button, Sales Register report appears. Given here is a screenshot of Sales Register report.
Figure 8.8 Sales Register
è All other Accounts Registers are totally similar to the Sales Register. For detailed help on message boxes and Report Options that appear in other Accounts Registers, please refer to Sales Register.
Account Activity Report
Account Activity Report displays all the transactions for an account within a specified month range. Basically, it is a ledger report designed in a different format. On clicking the Account Activity Report 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.
Month – Select the starting month from which the report is to be generated.
To – Select the ending month up to which the report is to be generated.
Enter required data in all the data fields and click the Ok button. On clicking the Ok button, an Account Activity Report appears. Given here is a screenshot of Account Activity Report.
Figure 8.9 Account Activity Report
