anjanee001
Please tell me how to manage all site expanse and material in one excel sheet for one company...please share any sheet for maintaining all detail in one sheet and reporting in one click.
From India, Chandigarh
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Dinesh Divekar
Business Mentor, Consultant And Trainer

Dinesh Divekar
7855

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 Accounts Executive or a Data Entry Operator (DEO) working independently at each site or all the invoices, vouchers etc are 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 also. Additionally, the senior management professionals can monitor the Master Sheet remotely also.

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

Thanks,

Dinesh Divekar

From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHR

All Copyright And Trademarks in Posts Held By Respective Owners.