Please tell me how to manage all site expenses 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
From India, Chandigarh
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
7879You 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.
Effectively Manage Workplace Diversity.doc
How to Manage Training - A Guide to Design and Delivery for High Performance.[20 03.ISBN08144077 9.zip
How to manage your boss.pdf