memetax’s blog

妊娠中のアラサー経理がUSCPA取得を目指すブログ

Pros and Cons of using spread sheet as reporting formats

 I am now working as an accountant in a huge Industrial company.

 I have to receive reports from dozns of divisions and branch companies, and I use spread sheets and specific programs to gather those reports.

 Usually, my headquarter decides what should be reported using specific programs, so I have to make spread sheet reporting format for the rest.

 Today I’m going to write Pros and Cons of using spread sheet as reporting formats.

 

Pros

1.Flexible

 It is easy to add points what we want to ask because spread sheet is free from restriction.

2.Easy to add/remove reporting company

 Using e-mail to ask, there is no restriction of companies to send.

3.Have no additional expense

 Microsoft Excel is installed in each PC, so using spread sheet doesn't cost aditional expenses.

 

Cons

1.Have to gather data by ourselves

 We have to make by ourselves. It took time.

2.have to check which company submitted and which company doesn’t

 As we ask by e-mail, we have to check which company submitted reports.

 When we have to ask many companies, it is very bothering.

 

Conclusions

 Using spread sheets to ask, it is suitable to ask extraordinary things to a small number of divisions/branch companies.