Finance Reports Manual
Was this helpful?
Was this helpful?
This is a summary report of how much amount is pending for reconciliation for the selected bank account.
To generate reconciliation summary report
Navigate to Finance > Transactions > Bank Reconciliation > Reconciliation Summary Report option in the sidebar. Select the applicable Bank, Branch, Bank Account, and Bank Statement Balance details.
Enter the relevant Bank Statement Date. Click on the View Summary button.
To generate Income Expenditure Statement
Navigate to Finance > Reports > Financial Statements > Income Expenditure Statement option in the sidebar.
Select the relevant Period, Year, Rupees format, Department, Fund and Function details. Select As On Date detail to generate the statement till a specified date.
Click on the Submit button to view the statement.
Click on the Schedule Number hyperlink to open the individual schedule report. Click on the Amount to drill down to the ledger report for the selected account code. Click on View All Minor Schedules button to see the schedule report at minor code level.
Click on the View All Schedules button to see the schedule report. Click on the Amount to get the further details of the transaction.
To generate the Balance Sheet
Navigate to Finance > Reports > Financial Statement > Balance Sheet option in the sidebar. Select the relevant Period, Year, Rupees format, Department, Fund and Function details.
Select As On Date detail to generate the statement till a specified date. Click on the Submit button to view the statement.
Click on the Schedule Number hyperlink to open the individual schedule report. Click on the Amount to drill down to the ledger report for the selected account code.
Click on View All Minor Schedules button to see the schedule report at minor code level.
Click on the View All Schedules button to see the schedule report.
Click on the Amount to get the further details of the transaction.
To generate the budget information department wise
Navigate to Finance > Reports > Budget Reports > Departmentwise Budget menu option in the sidebar. Select the applicable Financial Year, Department, and Type.
Click on the Search button to get the report.
Click on the Save as PDF or Save as Excel option to download the reports in PDF or Excel format.
To generate budget information function wise
Navigate to Finance > Reports > Budget Reports > Departmentwise Budget menu option in the sidebar.
Select the applicable Financial Year, Department, Type and Function. Click on the Search button to get the report.
Click on the Print button to print the report. Click on the Save as PDF or Save as Excel option to download the reports in PDF or Excel format.
To fetch the budget utilization details for any specific budget item
Navigate to Finance > Reports > Budget Reports > Budget Watch Register menu option in the sidebar.
Select the applicable Fund, Department, Function, Type, Budget Head, and As On Date details. Click on the Search button to get the report. Click on the Print button to print the report. Click on the Save as PDF or Save as Excel option to download the reports in PDF or Excel format.
The Budget Variance report provides the comparison on what was planned in the budget and how it is being utilized.
To generate the budget variance report
Navigate to Finance > Reports > Budget Reports > Budget Variance Report menu option in the sidebar. Select the applicable Department, Function, Fund, Account Type, Budget Head, and As On Date details.
Click on the Search button to get the report.
Click on the Print button to print the report. Click on the Save as PDF or Save as Excel option to download the reports in PDF or Excel format.
The budget upload report provides information that is uploaded in the system using the upload facility and is currently not approved.
To generate the budget upload report
Navigate to Finance > Reports > Budget Reports > Budget Upload Report menu option in the sidebar.
Select the applicable Budget, Reference Budget, Fund, Department, and Function details. Click on the Search button to get the report.
Click on the Print button to print the report. Click on the Save as PDF or Save as Excel option to download the reports in PDF or Excel format.
To generate the general ledger report
Navigate to Finance > Reports > Accounting Records > General Ledger Report option in the sidebar.
Enter the applicable Account Code, Fund, Department, Starting Date, Ending Date, and Function details.
Click on the Search button to view the report. These reports can be downloaded in PDF as well as in Excel format. Also drilldown is available from the Voucher Number field.
To generate the Trial Balance
Navigate to Finance > Reports > Accounting Records > Trial Balance option in the sidebar.
Select the relevant Report Type. Select the period using the From Date and To Date fields. Select the applicable Fund, Department, Function, Functionary, and Field details.
Click on View HTML button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Bank Book report
Navigate to Finance > Reports > Accounting Records > Bank Book option in the sidebar.
Select the relevant Fund, Department, Function, Bank Name, Account Number, Start Date and End Date details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Subledger Schedule report
Navigate to Finance > Reports > Accounting Records > Sub Ledger Schedule Report option in the sidebar.
Enter the relevant Account Code, Fund, Starting Date , End Date, Sub Ledger Type, and Department details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
Click on the Name field to see the transactions made by any particular entity.
To generate the Subledger Report
Navigate to Finance > Reports > Accounting Records > Sub Ledger Report option in the sidebar.
Enter the relevant Account Code, Fund, Starting Date , End Date, Sub Ledger Type, Entity Details and Department details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
Click on the Voucher Number field to see the details of the voucher.
To generate the Day book report
Navigate to Finance > Reports > Accounting Records > Day Book Report option in the sidebar. Enter the relevant Start Date , End Date, and Fund details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Journal book report
Navigate to Finance > Reports > Accounting Records > Day Book Report option in the sidebar.
Enter the relevant Starting Date , End Date, Fund, Voucher Name, Function and Department details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Opening Balance report
Navigate to Finance > Reports > Accounting Records > Opening Balance Report option in the sidebar.
Enter the relevant Financial Year, Fund, and Department details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Complete Bill Register Report
Navigate to Finance > Reports > MIS Reports > Complete Bill Register Report option in the sidebar.
Enter the relevant Fund, Department, From Date, To Date, Expenditure Type, Bill Type, Voucher Number, and Bill Number details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate the Bank Advice for RTGS
Navigate to Finance > Reports > MIS Reports > Bank Advice Report for RTGS option in the sidebar.
Enter the relevant Bank Name, Bank Branch, Account Number, and RTGS Number details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate RTGS Register Report
Navigate to Finance > Reports > MIS Reports > RTGS Register Report option in the sidebar.
Enter the relevant Fund, Department, RTGS Assigned From Date, RTGS Assigned To Date, Bank, Bank Branch, Account Number, and RTGS Number details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate Voucher Status Report
Navigate to Finance > Reports > MIS Reports > Voucher Status Report option in the sidebar.
Enter the relevant Fund, Department, Voucher Type, Voucher Name, From Date, To Date, and Status details. Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
To generate Cheque Issue Register
Navigate to Finance > Reports > MIS Reports > Cheque Issue Register option in the sidebar. Enter the relevant Fund, Department, Voucher Type, Voucher Name, From Date, To Date, and Status details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
Click on the Multiple link in the Bank Payment Voucher & Date columns to see the vouchers associated.
Click on View Voucher to see the details of the selected voucher.
To generate the report on the surrendered cheques
Navigate to Finance > Reports > MIS Reports > Surrendered Cheque option in the sidebar. Enter any or a combination of the listed parameters - Fund, Bank Branch, Bank Account, Reason for Surrender, From Date and To Date details. The report view will be filtered based on the selected parameters. The fields marked in red star are mandatory.
Click on the Search button to generate the report. Once the Report is generated, the user can see all the relevant information why the cheque is surrendered and the voucher attached to the cheque and so on.
Click on the PDF or Excel button to download the report in pdf or excel format. Click the Print button to print the report. Users can drill down from the Voucher Number to see more details about the voucher that is associated with the surrendered cheque.
Note: Users have a feature to click on the search tab on the right top and easily navigate to the desired cheque.
To generate the Remittance Pending Report
Navigate to Finance > Reports > Deduction Reports > Remittance Pending option in the sidebar.
Enter the relevant Fund, Department, Voucher Type, Voucher Name, From Date, To Date, and Status details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
Deductions Summary
To generate Deduction Summary
Navigate to Finance > Reports > Deduction Reports > Deduction Summary option in the sidebar. Enter the relevant Recovery Code, Fund, From Date, As On Date, Department, and Party Name details.
Click on the Search button to generate the report. These reports can be downloaded in PDF as well as Excel format.
The cash and cheque remittance feature is used to remit the amount into the bank account after the collection is made through the Revenu/Collection - Misc Receipt.
The cash remittance feature is used to remit the amount into the bank account after the collection is processed through Misc Receipt.
To do the cash remittance
Navigate to Finance > Revenue/Collections > Cash Remittance option in the sidebar.
Select the Bank account number and Financial Year from the drop down. The cash remittance search can be either done by selecting the Financial year or by the Date Range as well. Once the search parameter is selected the list of total cash collected which need to be remitted is displayed on the screen
Now the user can select a particular amount which needs to be remitted or select multiple amounts which need to be remitted into the bank account. Once the user selects the amount which needs to be remitted a pop message appears for the confirmation of receipt remittance.
Once the user clicks on the ok the cash remittance will be processed and the receipt number will be generated.
Users can also print the bank challan as well.
To do the cheque remittance
Navigate to Finance > Revenue/Collections > Cheque Remittance option in the sidebar.
Select the Bank account number and Financial Year from the drop down. The cash remittance search can be either done by selecting the Financial year or by the Date Range as well. Once the search parameter is selected the list of total cheque collected which need to be remitted is displayed on the screen
Now the user can select a particular amount which needs to be remitted or select multiple amounts which need to be remitted into the bank account. Once the user selects the amount which needs to be remitted a pop message appears for the confirmation of receipt remittance.
Once the user clicks on the ok the cheque remittance will be processed and the receipt number will be generated.
Users can also print the bank challan as well.
The Bank Reconciliation feature is used to reconcile the books of accounts with the bank statement report received from a bank. There are multiple options available under the bank reconciliations module.
This feature is used to manually reconcile all the instruments that are currently not reconciled.
To reconcile with bank manually
Navigate to Finance > Transactions > Bank Reconciliation > Reconcile With Bank Manual option in the sidebar. Select the relevant Bank, Bank Account, Branch, Reconciliation Date and the Bank Statement From and To Date for which the reconciliation needs to be done. Refer to the bank statement provided by the bank to input bank statement dates.
Click on the Search option to list all the instruments that are not reconciled.
Click on the Show Pendings button to view unreconciled totals for each instrument.
Provide the Reconciliation Date and click on the Reconcile button.
At this point the bank statements and instruments are marked as Reconciled.
This feature provides the facility to capture the entries that are missing in the books of the organization when compared with the Bank statement received from Bank.
To capture bank statement entries not in bank book
Navigate to Finance > Transactions > Bank Reconciliation > Bank Statement Entries - Not in Bank Book option in the sidebar. Select the applicable Fund, Scheme, Sub Scheme, Department, Function, Bank, Bank Branch, and Account Number details. Input the mandatory details (fields marked in red star).
Click on the Search button to fetch entries based on the selected parameters. Select Type as Receipts or Payments for the listed entries. Input the Account Code details and check the Create Voucher option.
Click on the Save button.
System will make a voucher for the corresponding entry. If the Create Voucher option is not selected, a voucher will not be created, but an entry is made in the organization’s book which is reflected in the Reconciliation Summary Report.
This is a summary report of how much amount is pending for reconciliation for the selected bank account.
To generate reconciliation summary report
Navigate to Finance > Transactions > Bank Reconciliation > Reconciliation Summary Report option in the sidebar. Select the applicable Bank, Branch, Bank Account, and Bank Statement Balance details.
Enter the relevant Bank Statement Date. Click on the View Summary button.
This feature provides the facility to process the reconciliation books of accounts with the Bank statement automatically by filling in the excel template with all the relevant information and uploading into the system.
To auto reconcile uploaded bank statements
Navigate to Finance > Transactions > Bank Reconciliation > Auto Reconcile Uploaded Statement option in the sidebar. Click on the Download Template link in blue.
Once the template is downloaded the user can go through on how to update the template using the information available in the Details tab. Users must have the bank statement ready. Update the relevant information into the excel by converting the bank statement into excel format.
Select the Bank, Branch, and the Bank Account details.
Click on the Choose File button to select the updated bank statement file. Click on the Upload button to upload the bank statement.
If the data provided in the file are as per the standard the records get uploaded which can be used for further processing. If there are mistakes in the data, the same will be notified in the acknowledgement page.
This feature provides the facility to process the bank statement uploaded in the auto-reconcile statement upload screen. The system reconciles the bank statements.
To reconcile uploaded statements
Navigate to Finance > Transactions > Bank Reconciliation > Reconcile Uploaded Statement option in the sidebar.
Select the applicable Bank, Bank Account, Branch, Reconciliation Date, Bank Statement From Date and Bank Statement To Date to process reconciliation. Click on the Process button to trigger the auto reconciliation. System will pick all the files associated with the bank account selected and try to reconcile the instruments mentioned in the files. All instruments that system can match properly will be marked as reconciled and the remaining will come as failed.
Click on Generate Report to see the details of entries that are not reconciled.
Failed transactions need to be assessed why the reconciliation was not processed and to amend the transaction accordingly and process again or to do manual reconciliation.
This option is used to see all the files that are uploaded for reconciliation along with its processing status.
To view uploaded bank statements
Navigate to Finance > Transactions > Bank Reconciliation > View Bank Statement Uploaded option in the sidebar. Select applicable Bank, Bank Branch, and Account Number.
Select the relevant AsOnDate to specify the date till which you want to view the bank statement upload details. Click on the Search button to view the list of uploaded files.
Click on the file name link to directly open the file or download and save the file into the system.
Open the file to view the details of all the transactions which were updated in the excel template and uploaded into the system. The status of individual transactions indicates whether it was uploaded successfully or was there any error in the transaction.
With the status of individual transactions updated in the file, users can take necessary action if there are any errors in updating the information in the excel file. User can amend the error transaction and re-upload the file into the system for auto reconciliation.
To view vouchers
Navigate to Finance > Transactions > View Voucher option in the sidebar. Enter the required filters to narrow down the search for specific vouchers. Enter the Voucher Number directly to fetch a specific voucher.
Select the applicable Voucher Type, Voucher Name, Voucher Date From, Voucher Date To, Fund, and Department details to fetch vouchers matching the given criteria.
Click on the Voucher Number link to view the details. A pop-up window opens with the basic details of the selected voucher. Click on the Source link in blue to open the source of the voucher.
Click on the Print button to print the voucher.
To generate the Opening Balance report
Navigate to Finance > Reports > Accounting Records > Opening Balance Report option in the sidebar.
Select the applicable Financial Year, Fund and Department details. Click on the Search button to generate the report.
The report is generated. Click on the relevant Export Option to download the report in PDF or Excel format.
Drill downs are provided from the amount fields to see the details of the summary amount.
Drill downs are provided from the amount fields to see the details of the summary amount.
