Do you use invoicing for your small business? We want your feedback! Learn More

Weird Stock Split question - 1:7109 split penny stock (edit)

JF73 Member ✭✭
edited November 16 in Investing (Windows)

One of the securities in my Schwab portfolio had a 1:7109 stock split. Any idea how to enter this into Quicken? It won't allow it



  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    edited November 15


    You got 7,109 shares for each 1 share owned? Is that correct? Or is that 1 for every 7,109?

    I guess you could use a Remove and then an Add, or series of Adds if you have more than one lot if the former.

  • JF73
    JF73 Member ✭✭

    Tom, it's the other way around. They reduced my shares, and I can't figure out how to do the math in Quicken


  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭

    Not at my Quicken, but I can imagine the problem. Using the inverse 0.000141 is not (may not be) accurate enough.

    Is this one or two lots or many lots?

    My basic alternate would be:

    • Assume you had a lot of 15,000 shares
    • You would be due 2.11 shares
    • You would receive 2 shares and a cash-in-lieu amount for the 0.11 shares
    • I would Remove Shares for the 15,000
    • Add Shares for the 2.11 with the full basis of that lot and the applicable Acquisition Date
    • Sell the 0.11 shares for the cash-in-lieu amount.

    For multiple lots. You could consolidate the Remove Shares and the Sell to individual transactions rather than per lot.

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭

    You can't do this directly into Quicken, either way, using the stock split wizard. You're going to have to do all your calculations outside of Quicken and then do the Remove and Add(s) that get you to the correct ending point. It will be pretty easy if you only have one lot, or just a few.

    You may want to see how Schwab actually ends up showing this at their site and just copy their results (manually of course) though I'd expect that they probably will download the something into your file for this split so you may want to wait for that to show up.

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭

    @JF73, did you get any "cash in lieu" for fractional shares sold?

    How many shares did you own before this transaction? How many shares after?

    And, if you'd name the security it would make our effort to help you easier.

    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • Ps56k2
    Ps56k2 SuperUser ✭✭✭✭✭

    have never seen anything like this -

    What is the stock symbol ?

    QWin Deluxe Subscription - sticking with R47.15 - Win10

  • JF73
    JF73 Member ✭✭

    Thanks for your help guys!! The stock symbol is MCHA (used to be GEAR). Some shady penny company, it's now pretty much dead....I know, stupid trade..…but I'm just trying to figure out how to at least get the worthless share count correct in Quicken.

    Thanks again!

  • Ps56k2
    Ps56k2 SuperUser ✭✭✭✭✭
    edited November 16

    QWin Deluxe Subscription - sticking with R47.15 - Win10

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭

    Since the company actually is worthless, and probably will be history soon, if all you want is an accurate share count and nothing more, then do a Remove of ALL the shares, do an Add for the correct amount of shares that you've calculated outside of Quicken. Round down to the whole number of shares resulting from your calculation.