Financial Statement Question

Fred_Deutsch · 2007-05-18

New CFO wants to change Financial Statements as follows:

After Revenue and COGS, for each dept we have expenses (payroll, benefits, T & E, etc.), he wants to include amortization and depreciation for each department.
Then, after all the departments have been shown, he wants to "reverse out" the amortization and depreciation for all departments, get a total, and continue on with other expenses, show some kind of total, then put back the amortization and depreciation for all departments and continue.

Any ideas ? Reversing the sign doesn't help as you probably already know

Alex_Chow · 2007-05-18

You need to use the recurring journal ot make those entries so your report can pick it up.

themave · 2007-05-18

I think I understand what you want. in the account schedule you want

REV
..
..
..
COGS
Expenses
Payroll
Benefits
..
..
..
Amort/Deprec
Total expense w/Amort (on this line - include all the expenses in the formula

Total expense w/o Amort ( on this line - in the formula include only the range of lines excluding Amort/Depr. line) (by not including this line in later formulas below, it will just appear as an informaitonal line. which is what it sounds like you want.

then continue on, when you get to your bottom line, the formula should include the Total rev line, the total COGS line, and the Total Expense with Amort. line

Fred_Deutsch · 2007-06-24

I will do that , makes sense - Thanks

Financial Statement Question

Comments

Categories