Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Nice! And if he is not using the Home & Business version, he can switch.
    Friday, February 7, 2020 4:04 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    I am using the Microsoft Money Plus Deluxe, Version 17.0.120.3817, I guess not the Home & Business version you refer to.
    Saturday, February 22, 2020 9:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, Money Home & Business is version 17.0.150.3817.  You can download it from the second "sticky" thrread in this forum:

    https://social.microsoft.com/Forums/en-US/479281b2-90f9-42ca-85f7-644fc6e1e5c3/download-microsoft-money-installation-files-solve-activation-and-some-other-errors?forum=money

    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:

    https://social.microsoft.com/Forums/en-US/d28d6921-1f01-430f-b33e-f5a3ec47077b/important-patch-for-money-plus-maybe-20062007-mnyob99dll?forum=money

    Bill Becker


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