Add Total to Profit Loss Report

Google Sheets
,
1

Hi, It would be very helpful and useful if you added a total col on the P &L report. I am getting tired of having to add it manually every time I want to see what the total is.

1 Like
2

You can do some customization to the report template to make this easier.

  1. Unhide and open the template called Report Template: P&L
  2. Create a new column to the right of column O
  3. Add the formula below to cell P6
  4. Rehide the template called Report Template: P&L 
={"Total";arrayformula(if(isblank($A7:$A)*isblank($B7:$B)*isblank($C7:$C),iferror(1/0),IFERROR($D7:$D,0)+IFERROR($E7:$E,0)+IFERROR($F7:$F,0)+IFERROR($G7:$G,0)+IFERROR($H7:$H,0)+IFERROR($I7:$I,0)+IFERROR($J7:$J,0)+IFERROR($K7:$K,0)+IFERROR($L7:$L,0)+IFERROR($M7:$M,0)+IFERROR($N7:$N,0)+IFERROR($O7:$O,0)))}

You can slide the extra column over after your run the report if you don’t like the total off to the right.

Cheers,
Randy

1 Like
3

Thank you for the help.
Quick question.
Do you need to do this every time you run a new monthly P&L?

4

No. If you change the local report template, it will be there every time you run it.

5

Great love this! Been wanting it as well. However, is there a way to get the formatting to look the same on the column that shows the totals? On mine it looks out of place from how the rest of the report looks. Thanks @randy

6

@randy I’m also getting totals ($0) across from section titles like “income” or “expense” that don’t need a total. How do I get rid of those?

7

I have been asking for this total column for years. I know I can do it manually. It seems to me to be a quick thing that Tiller can add, no? Why not put in on the to do list to add the total column to the template?

Blake

1 Like
8

These are good questions, @alkrongold and @Blake. I’ll discuss this change with @heather, who is now in charge of prioritizing changes to Tiller Community Solutions.

9

Thanks for the suggestion— and your patience— @lisarichweb.
Just built this out tonight.

Please let me know what you think.