Share via

How to create a very simple P & L spreadsheet? in Excel.

Anonymous
2019-11-06T20:33:18+00:00

How do I create a very simple P & L spreadsheet?  I want to be able to put the expenses in one column, the income in another column and have the balance show in a third column.  The only other columns I need are company, description and date.  So I have six total columns.

THANK YOU.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-11-08T00:32:49+00:00

    All done - file has been sent back to you so you should be good to go.

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2019-11-07T22:40:21+00:00

    Out replies crossed paths so didn't see your second one when I answered

    In short - whenever you see me use the # sign and state that it refers to <Row#> that is the first # you see in front of every row (line) - see #1 in the screenshot provided in my previous reply regarding how to copy/paste your formula

    As for this being a check register idea - it really is that simple but have to make sure that the columns you refer to are the same from one response to the next.

    Just for comparison - the concept of a cheque register is as follows

    <Previous Balance> + <Deposits> - <Cheques> = <Current Balance>

    NOT as you originally described

    <Income> - <Expenses> = <Balance> (with a different company on each line

    Can only provide answers based on the info provided. Pretty sure that this is a very simple to resolve once we get the terminology resolved.

    1 person found this answer helpful.
    0 comments

19 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-11-06T21:12:17+00:00

    Are you saying that all you want is a single row for each company / desc /date with a single value for income & Expenses? (this isn't what's typically referred to as a P&L

    In any case, if it is as simple as what you describe - the process would be

    In Row1 - Enter the column descriptions (i.e.

    A1 - Company

    B1 - Desc

    C1 - Date

    D1 - Income

    E1 - Expenses

    F1 - Balance

    In the following rows - enter the applicable information with the difference being for column F2 where you would enter the formula =D1-E1

    Not at all clear as to what exactly you're after if there is one company per row. Generally a P&L would involve one or income categories from which multiple expense categorie are substracted to arrive at a "balance"

    Once you have entered all your rows of information, in the row following the last row of information you could enter the following formulas to get a total of the income & expenses

    in D(lastrow+1) enter: =sum(d2:d###) where ### represents the last row

    in E(lastrow+1) enter: =sum(e2:e###)

    in F(lastrow+1) you can enter either: =sum(f2:###) OR =D(lastrow+1)-E(lastrow+1) 

      \*\*\* either formula in the F cell should return the same result

    Can't provide anything more specific since there is far too much infomration missing to be able to provide exact row#s etc

    If you're not familiar with Excel and things like formulas - then the following online training may be of use

    Excel for Windows training

    https://support.office.com/en-us/article/excel-...

    0 comments
  2. Anonymous
    2019-11-06T20:49:42+00:00

    Thanks - didn't find anything quite as simple as I'm hoping for..

    0 comments
  3. Anonymous
    2019-11-06T20:38:39+00:00

    Hello naskawara

    Would suggest starting with one of the available Profit & Loss templates available from MS and adjust it according to your preferences

    Profit and loss

    https://templates.office.com/en-us/profit-and-loss

    0 comments