90p Admin

 View Only
Expand all | Collapse all

Urgent! - Financial Presentation for MOTM 2021

  • 1.  Urgent! - Financial Presentation for MOTM 2021

    Posted 02-25-2021 16:49
    All,

    As soon as humanly possible, please take a look at the attachments. I'm trying to close in on the data that we want to present next Friday. 

    1.  I originally thought that we would just present the income statement, but some of the old-timers have expressed interest in knowing what the cash-in-bank balance is. Should we also present the balance sheet?
    2.  Balance Sheet data is only available in QB starting 01/01/2019. Robert gave me the old set of books that was in MAS90, but the computer that I had it installed on went south. It will take me quite a bit of time to get it working. Do I need to do that?
    3.  There are some inconsistencies in some of the postings done by the CPA. For instance, the D&O insurance is doubled in 2020 because one of the amounts should be in 2021. Of greater concern is the balance in Prepaid Expenses. Notice that the 2020 amount for Website Expenses is short by $15k because it's still sitting in prepaid. I assume that gets moved at some point, and then we will be far less profitable than the statement shows now.

    Other thoughts? @Robert Wood @Jerry Norman @Alan Clark @Jim Woodhead

    Thank you!​​​​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Attachment(s)



  • 2.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 15:05
      |   view attached
    @Jerry Norman - Please see revised statement. I'm working this weekend if you want to chat further. Thanks for your help!

    Karen​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Attachment(s)



  • 3.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 16:39
    I think the dues revenue and MOTM for 2019 are wonky. The dues should stay pretty consistent year over year.

    ------------------------------
    Admin Robert Wood
    Consultant
    90 Minds, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 4.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 16:44
    I should probably read the notes before commenting. LOL!

    ------------------------------
    Admin Robert Wood
    Consultant
    90 Minds, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 5.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 17:15
    @Robert Wood - Hey, we're on the same wavelength! The numbers are straight out of QB. I'll smooth them according to a ratio based on other years.

    Apart from that, do you guys like the format? What do you see that anyone of the members might ask about?

    @Jerry Norman @Alan Clark @Jim Woodhead​​​​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------



  • 6.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 17:23
    I think by year is fine.  If you want to do a trend that is fine.  The smoothing you discuss is great.  All in all I think the year have been flat to slight decreasing but we have made recent  change in due structure to help off set  it.

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 7.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 17:37
    Let me add... They look great..  perfect for what we need @Karen O'Lane thanks for the effort!, ​  I know it wasn't easy.

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 8.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 18:50
      |   view attached
    This does the job. I have suggestions for tweaking the presentation. See the tab I added on this attachment.

    I think making educated guesses about the correct numbers in 2019 to produce an accurate impression in the reader is what we're aiming at here.

    ------------------------------
    Jerry Norman
    VP, 90 Minds
    Smartbridge Partners
    512.419.1444 x112
    ------------------------------



  • 9.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 21:22
      |   view attached
    Jerry, I like your changes. It's really clean now. I balanced the revenue amounts for 2019 a bit better, and changed the yellow highlight to a nice 90 Minds green.  What does 'CYE' mean? And should the balance sheet columns say 'Jan' rather than 'Dec'?

    Thanks!

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------



  • 10.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 21:38
      |   view attached
    CYE = Calendar Year End (eg, Dec). I removed "Dec" from it -- Brainfart1
    Bal Sheets definitely should be Dec. Brainfart2

    I also added Fees to Prepaids, as the Vario item is more that than a license. 

    Also, "Margin" means %. So I change the bottom line to just "Net Contribution." Brainfart3

    Did we lose money on MOTM 2020? We should run a final gut check on the numbers before using this.

    ------------------------------
    Jerry Norman
    VP, 90 Minds
    Smartbridge Partners
    512.419.1444 x112
    ------------------------------



  • 11.  RE: Urgent! - Financial Presentation for MOTM 2021

    Posted 02-27-2021 21:51
      |   view attached
    Good answers!

    According to Moira, we made $20k. See attached budget worksheet. However, the numbers in my proposed presentation are straight out of QB. Might the answer lie in the unallocated revenue?

    Karen

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------

    Attachment(s)