How to manage all site expenses and material in one excel sheet for one company?

Please tell me how to manage all site expenses and materials in one Excel sheet for a company. Please share any template for consolidating all details in a single sheet and generating reports with one click.

Dear Anjanee001,

You could have given a little more information on your requirement. How many sites do you have? Who updates the expenditure incurred at the site? Is there an Accounts Executive or a Data Entry Operator (DEO) working independently at each site, or are all the invoices, vouchers, etc., sent to the Head Office (HO)?

Whatever the type of functioning may be, you may use Google Sheets. The benefit of using Google Sheets is that the sheets can be linked to the Master Sheet at the HO. By linking the sheets, the Master Sheet gets updated automatically, and no separate data entry is required. Secondly, in these times of the COVID-19 pandemic, Google Sheets, which are cloud-based, can be updated remotely as well. Additionally, senior management professionals can monitor the Master Sheet remotely too.

On YouTube, there are videos on how to link Google Sheets. You may watch them.

Thanks,

Dinesh Divekar