Printing a report with only Monthly sub-totals/Without details RRS feed

  • Question

  • I'm wondering if anyone is still monitoring these questions??  Let's find out:

    I have used Money basically since it went on the market, i.e. many years.  I'm now using the Sunset Version.  I have a small business and every year for tax purposes I run reports relating to the various income and expenses.  One of the expenses relates to the PayPal fess that I have paid and recorded in MS Money, a lot of detail.  At the end of the years I print a report so I can get the total.  I would like to print this out but doing so involves dozens of pages.  I would like to only print the monthly sub-totals and year total, without all of the details.  How?  I've tried numerous ways but nothing seems to work. Any help greatly appreciated!!

    Thursday, February 6, 2020 10:44 PM

All replies

  • If you can find a grep, I could tell you a way:

    1. Right-click the report, and choose ExportToExcel. That will produce a *.csv. Let's say it is X.csv for example.
    2. grep -v "^" > x2.csv

    Then open x.csv as a spreadsheet. Print the spreadsheet.

    A line that would have a blank first column in the spreadsheet would start the line with a comma. That grep command says output all lines that do not start with a comma.

    I could also make a Python file that could do that if you wanted to install Python.

    Somebody may know how to use the Windows Find command for this task, but I don't know how its strings would represent the start of a line.

    https://en.wikipedia.org/wiki/UnxUtils  might point to a grep or egrep that can run on Windows.

    Friday, February 7, 2020 1:01 AM
  • If you are using the Home & Business version, after insuring that PayPal fees category "Usage" has been changed to Business, rather than Personal, select Reports > Business Reports > Tax-related business transactions >  and for Report Type, select Tax Summary, instead of Tax transactions.  It works perfectly!

    • Edited by ameridan Friday, February 7, 2020 3:59 AM
    Friday, February 7, 2020 3:53 AM
  • Nice! And if he is not using the Home & Business version, he can switch.
    Friday, February 7, 2020 4:04 AM
  • Thanks for the response. Unfortunately for me your suggestion is completed over my head, i.e. I don't even know what a grep is.
    Saturday, February 22, 2020 9:23 PM
  • I am using the Microsoft Money Plus Deluxe, Version, I guess not the Home & Business version you refer to.
    Saturday, February 22, 2020 9:25 PM
  • Yes, Money Home & Business is version  You can download it from the second "sticky" thrread in this forum:


    It will read your current Money file.  Be sure to do the mnyob99.dll replacement that is described in the first "sticky" thread in this forum:


    Bill Becker

    • Edited by Bill Becker Sunday, February 23, 2020 1:51 AM
    Sunday, February 23, 2020 12:33 AM