Extracting the Total Value of Expenses incurred for specific Expense head.

(0) Share

Report

Posted on by Community Member

Hi,

Good Day !

In our GP we have divided the expenses into two categories , General and Administration and Projects based expenses, now i have to extract the Total value of costs incurred "General and Administration Expenses" . if I go individually its very time consuming, is there any way to extract the Total Value of General and Administration Expenses since Jan 2016 to Oct 2016.

Thanks in Advance.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Praveen Kumar RR 1,552 on at

Like (1)

Report

Hi Saqib,

How you are categorizing Accounts into General and Administration?

Using which reporting option you are generating this report currently?

Thanks,

Praveen

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

categorised into "General and Admin" and project based expenses... now I have to find the total value for "Gen & admin" only....

Currently, I am extracting values month wise for each expense head via

Inquiry>>Financial>>summary

then search for expense head i.e Stationary which gives me the month wise result of the expense incurred under stationary expense head. as shown in below snapshot.

Was this reply helpful? Yes No
Verified answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

Correct me if i am wrong, you want to generate Report with period wise for a set of Accounts right?

In the snapshot it is only one account selected, you want to generate for all required accounts in a same report with its periodical data

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes exactly... i want to generate report for "Gen & Admin" Category only from

Jan 2016 to oct 2016.

under this catogery i have more than 100 Expense heads i.e Stationary, salaries, office supplies, recruitment etc...

Was this reply helpful? Yes No
Verified answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

You can try this Report,

Smartlist >>Financial>>Account Summary.

This report will generate data for entire list of Accounts and you can export it to Excel.

In Excel you need to perform some Filtering and Data preparation.

More such reports can be generated using AA Module.

Thanks,

Praveen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks alot PRAVEEN, it really helped out me. i ectracted the list of all the accounts of both catogeries and then just removed the transactions prior to 2016 and transactions made under project related accounts.

you made my work easy ....

GOD bless you. thanks

Was this reply helpful? Yes No