Use Excel tables, for example: vertical can be the department and name, horizontal can be items and time, quantity, etc.

Use Excel formulas can also aspect of statistical accounting, such as summation, departmental summaries, sorting and so on

Since you do the job, learn more about the good ideas and methods of work, I wish you success