2.5. Financial Tracker

The Financial Tracker is a Google Sheets document containing the financial summary, budget, amounts under procurement, amounts under commitment, disbursed amounts, and expenditure within the SCRP.

This guide shows how the PIU can:

• Access the tracker

• Add, Edit, and Delete records

• Export the financial data

2.5.1. Accessing The Financial Tracker

Use the link below to access the Financial Tracker:

• https://docs.google.com/spreadsheets/d/1wTRt8eGXsltipjuWRBtRkccvuEE-bY8EpkOC_Wgf8Cc/

Please note that you need access rights from the PIU MIS Administrator to view the tracker.

2.5.2. Adding, Editing, and Deleting Records

The Financial Tracker has 6 work sheets that track different aspects:

• Summary

• Budget

• Under Procurement

• Commitments

• Disbursements

• Expenditures

To get started on data entry/editing or deleting of records, do the following:

1. Select the summary sheet and enter data on the first empty row after the column headers

2. Edit data by selecting the specific cell you wish to Update

3. Click on any of the other worksheets and enter/edit component data

4. To delete data, you can either select a single cell or the entire row and hit the delete button

2.5.3. Exporting Financial Data

1. Access the Financial Tracker

2. Select “File” > “Download” from the navigation menu on Google Sheets

3. Choose the data format you want to begin download