About App

This app is a Google sheets add-on. It is only for registered users. It is a part of the service provided by us, along with this we provide you the spreadsheets with full functionalities, we will set all the authorisations for your office staff members. From these sheets and other add-ons provided by us, you can automate the work of forest section office of district level. This is specially designed for the division office only. It will work only if the spreadsheet is in some specific format, which is provided by us. First register with us then use this add-on. This app has many functionalities like, to process the advice, to assign cheque numbers depending on different banks to a specific advice, to show advice deduction summary, to print the bank reports which are required to submit to bank managers to process the payment, to print TDS report and other monthly reports. 

Features

1. Process advice: Using this add-on, one can process the advice easily, one can select the voucher by filtering them on so many different criteria like Received at division office or not, range, scheme, class, model etc. It automatically calculates LC of all selected vouchers and compare with the available LC, if LC of selected vouchers Scheme and class is higher than the LC in hand, then the 'Shoe LC' button becomes red and it will not process the advice.

2. Assign cheque numbers to advice: Keep all banks cheque book with you and then click on this menu, then it will ask for cheque numbers for payment in different banks. You may write same cheque number for more than one banks, that is up to you that from which bank you want to give the cheque. Suppose for 'HDFC Bank' and 'IDBI Bank', you want to give cheque numbers from your 'SBI bank account', then write the same cheque number of your SBI bank in front of all those banks.

3. Bank Reports for advice: Once you have processed an advice and assigned the cheque numbers to the advice, you may download all the reports in few clicks using this menu. It will download PDF reports as well as excel or word files too. Take print on paper, stamp and sign then submit to the banks to process the payment. 

4. Advice Deduction Summary: It will show you the summary of all deductions of a particular advice.

5. Monthly reports: You can download the GST deduction report and TDS deduction report to submit to corresponding agency.

6. For No. 35: You should use it after the end of the month only. It will assign new voucher numbers in particular order to the vouchers of this month. It will create and download the form number 35 in any format you want.

7. Cashbook: To prepare the data for cashbook, it will create the data as required for the cashbook and then it will provide you the link of that spreadsheet to manually add sub totals and other data.

8. Change advice date: If you don't want to make changes other then the advice date for any advice then you can change the date of the advice using it.

9. Delete Advice: To delete the passed or processed advice, you can use it. It will not delete the vouchers but it will delete the data related to advice from the master all sheet. Be careful, you can not recover the advice once it is deleted.

Initializing

Step-1: Installation

This add-on must be installed using the following steps.

1. Open the Spreadsheet in which you want to install it

2. Click on “Extension” menu

3. Select “Get add-on”

4. Search "Division Finance System" in Google Workspace Marketplace

5. Choose the add-on (see above logo image) 

6. Click “Install”

7. Provide permissions

8. You are done, use it under extensions menu.

Step-2: Use

(In the beginning it may happen that there is no data in your spreadsheet, which are required to run this app. Some data like party registration, tender conditions should be filled in the master data file, so that the range offices can add voucher data.)

Follow the steps in below images:

Post Install Tips

Have you installed the DFS add-on ? If yes, then visit the Post Install Tips page.