Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Changing all transactions to expenses RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi.  I use the basic free Microsoft Money Plus that came with my pc - version 17.0.120.3817 (yes, it's old).  I use it for personal finance planning on my personal computer.  I do not connect to the internet with this program.

    I need to know if I can do a batch change on transactions from deposit to expense.  These were inadvertently entered backwards so my balance is skewed to showing a high amount of "debt" (what I owe).

    Thank you for any help.

    Saturday, February 24, 2018 6:29 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    1. You could change the numbers that are there by editing in a minus sign. That will move the numbers over to the other column.

    2. You could delete the account, and maybe reload much of the account with an OFX file that covers the time period. If you name the financial institution, and account type, somebody may know what they offer.

    Saturday, February 24, 2018 8:12 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you for your help Cal Learner.

    I have 6 months of data entered opposite of what they should be (deposits rather than expenses).  I was hoping there would be a way to do it in a batch (all at one time).

    I don't understand the next option you gave.  I don't think it would apply.  For me Money is set up as a local program on my personal computer as a way to track/curb spending and follow a budget.  I don't even connect the program to the internet.

    Hopefully someone out there has an answer to the "batch resolution"  I am asking about.

    Sunday, February 25, 2018 3:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Option 2 was in regards to a bank's data.  You have the ability to download transactions in an OFX format, which MS Money would read, and import directly into money.  That way you could just delete the account in question, and replace it with a new one that contains the data from the bank.  Depending on the bank, you could have most of the 6 months of data available for download.  Then it's just clicking the category for each item.

    I doubt there will be a batch resolution as you are thinking.  You could export an account into qif format, edit it, and then import it as a different account (ie Chase 1 vs. Chase), but I don't know if it will be easier than manually adjusting each transaction.

    Sunday, February 25, 2018 3:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi joeags.  Thanks for the reply.  

    I enter every receipt in a basic account.  I bank at a credit union and their system is so antiquated that when I DL their statement is generic and all kinds of junk DL with it.  I understand what you are saying.  It just doesn't work for what I am trying to do.  I'm looking for a function in the program that will make batch changes to any of the data fields.  Is there one?

    Sunday, February 25, 2018 3:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

     I'm looking for a function in the program that will make batch changes to any of the data fields.  Is there one?

    No.

    How many are there? Changing 100 might take 10 minutes or so, once you establish a rhythm.

    Sunday, February 25, 2018 4:44 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you decide to change these transactions one at a time, one thing that might speed up the process is to right-click on a transaction.  The dropdown menu that appears will have an option to "Change transaction type to" with the choices of "Withdrawal", Deposit", or "Transfer".  This might be faster than changing the sign of the amount.

    A limitations is that this right-click process only works with transactions that have not been reconciled. You'll have to un-reconcile each one first using the "Mark as" option in the same right-click menu. And transactions that are already transfers need to handled individually because there are two accounts involved. 

    Also, if you have a category associated with the transaction, that may also need to be changed.  Or maybe you noticed that whenever you entered a deposit Money complained that you were assigning an expense category rather than an income category?

    Bill Becker

    Sunday, February 25, 2018 5:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you decide to change these transactions one at a time, one thing that might speed up the process is to right-click on a transaction.  The dropdown menu that appears will have an option to "Change transaction type to" with the choices of "Withdrawal", Deposit", or "Transfer". 

    Bill, I decided to try that for the heck of it, since I had not noticed that before. That choice appeared when I turned on transactions forms. I normally don't use transaction forms.

    I also decided to find a way to count how many transactions there were in a given account. I settled on customizing an Account Transactions report.

     Rows&Columns->Subtotal by: none.

    Date->Range: all dates

    Account: Clear all, then tick the account I was trying to count.

    OK.

    Right-click into the midst of the report, and choose Copy.

    Paste into a blank spreadsheet. Use the row number to figure out how many transactions there were.

    The reason this could be relevant is to estimate the magnitude of adding minus signs.

    I also tried the QIF method. If I were doing it, I would use a text editor I am familiar with. The plan:

    Change all <newline>T into <newline>T-

    Then change all '--' (two minus in a row) into nothing.

    Save the modified QIF file, and import into a new empty account. Transfers would be a problem, so they would be attended to if they exist.


    Monday, February 26, 2018 1:19 AM
    Moderator