Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Oder of Credit/Debit Entries RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am using Microsoft Money which I find to be very good.  However, I am unable to setup a system whereby Credits are entered before Debits on the same day.  On scheduled days, both debits and credits appear on the Account Register inline with the Bills Summary.  

    What is happening is that debits are being entered before credits.  On the first day of the month,  my salary is entered after debits, thereby showing that I am in the red.

    If possible I would like to arrange for the credits to be entered before debits if they both occur on the same day. 

    Wednesday, April 29, 2020 2:24 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Use the option "automatically enter transaction into my register the following number of days before the payment date"  to enter your credits perhaps 3 days prior to the actual date.  The order is time-stamped entry.

    • Edited by ameridan Wednesday, April 29, 2020 4:55 PM
    Wednesday, April 29, 2020 4:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm not quite sure what you are asking.  What do you mean by "inline with the Bills Summary"?

    I'm running US Money Sunset, and in, for example, my checking account, if I enter a withdrawal and then enter a deposit for the same day, the deposit always precedes the withdrawal in the register.   The same ordering (deposits before withdrawals) is shown in the Cash Flow Flow Forecast.  I think that Money is programmed to avoid just the situation that you are asking about. 

    Maybe you are running a different version of Money?

    Or are you asking about the order of the bills and deposits in the Bills Summary screen?

    Bill Becker

    Wednesday, April 29, 2020 8:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Using Money 2000 International English, my bank account 'View' is 'Sorted by Date'.  I then 'force' the order of transactions by including a letter in the number field of the transaction. So on the 1st of the month my net pension (a credit) is 'a', the amount of pension withheld to cover tax (a credit) is 'b', the tax remitted to HMRC (a debit) is 'c', council tax (a debit) is 'd', electricity bill (a debit) is 'e', etc etc.

    An alternative 'View' option is to 'Sort by Entry Order' ~ but the problem here is that if you make any corrections they will always drop to the bottom.

    Teabag

     
    Thursday, April 30, 2020 7:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Using Money 2000 International English, my bank account 'View' is 'Sorted by Date'.  I then 'force' the order of transactions by including a letter in the number field of the transaction. So on the 1st of the month my net pension (a credit) is 'a', the amount of pension withheld to cover tax (a credit) is 'b', the tax remitted to HMRC (a debit) is 'c', council tax (a debit) is 'd', electricity bill (a debit) is 'e', etc etc.

    An alternative 'View' option is to 'Sort by Entry Order' ~ but the problem here is that if you make any corrections they will always drop to the bottom.

    Teabag

     

    Brilliant.

    I tried adding a check number  starting with P, and those came last. It would seem possible to make a scrubber for those that use OFX to insert a <CHECKNUM> for payments, that moves them below the other cash transactions for the same day.

    I am not going to work on that at this point. We don't even know if Paul uses OFX import.

    Friday, May 1, 2020 4:34 AM
    Moderator