Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 11-22-2004, 11:17 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money gets confused by transfers with different dates in each account

In microsoft.public.money, Ethan Solomita wrote:

- quote -

> I would've thought that Money could handle what I'm trying to do, so
> maybe I'm just doing it wrong. I have a checking and credit card
> account, both of which have the statements entered electronically. I
> also have other investment accounts, all of which are entered
> manually.
> In one of the investment accounts, I had the account do a direct debit
> from my checking account to buy new mutual fund shares. My bank
> statement already has an entry, downloaded electronically, that shows
> the debit. I want to convert that into a transfer to my investment
> account.
> I can do it -- almost. The problem is that the date of the debit is a
> few days earlier than the date of the credit. Float time. Money seems
> unable to link two transactions which occur on different dates.
> This scenario comes up in many other contexts. My credit card does a
> direct debit from my checking account, but because the dates differ I
> can't get Money to reconcile them.
> What am I missing?


Your choices for a transfer are to select one date or the other, or
let each transfer be to/from an asset account that you set up for
the purpose. You can name that account "In transit", or whatever
else you like. This might be called a suspense account.
http://encarta.msn.com/encnet/featur...fid=1861717301


In the case of credit cards, there are some other possibilities.
Here are two ways I like:

1. When you process the first transaction of the credit card
payment, set the category as a transfer to the other ( credit card
or bank account), or use the equivalent "SPECIAL Credit Card
Payment"
category. When you process the second transaction,Money should
match it. Be careful to not just Accept if Money did not find the
match on its own for some reason. Click Change and match it to the
transfer you already made if Money did not match it for you. I
would consider this the classic of the ways I like. Note that for
this you would *not* use the Money 2005 "EXPENSE Credit Card
Payment".

2. In method 2, don't handle credit card payments as transfers or
the pre-defined "Credit Card Payment Instead create one category of
"CC payment" or some such. If you define the category as an
expense category, expect a warning when you use it to represent the
payment within the credit card account -- if you have the warning
enabled. Just click Yes in response to the warning. The category
should net at zero in reports across accounts, and you can still
customize to ignore the category if you like. use the Money 2005
"EXPENSE Credit Card Payment". For this method you could use
the Money 2005 "EXPENSE Credit Card Payment".

  #-1  
Old 11-22-2004, 11:07 PM
Ethan Solomita
Guest
 
Posts: n/a
Default Money gets confused by transfers with different dates in each account

I would've thought that Money could handle what I'm trying to do, so
maybe I'm just doing it wrong. I have a checking and credit card
account, both of which have the statements entered electronically. I
also have other investment accounts, all of which are entered
manually.

In one of the investment accounts, I had the account do a direct debit
from my checking account to buy new mutual fund shares. My bank
statement already has an entry, downloaded electronically, that shows
the debit. I want to convert that into a transfer to my investment
account.

I can do it -- almost. The problem is that the date of the debit is a
few days earlier than the date of the credit. Float time. Money seems
unable to link two transactions which occur on different dates.

This scenario comes up in many other contexts. My credit card does a
direct debit from my checking account, but because the dates differ I
can't get Money to reconcile them.

What am I missing?

Thanks!
-- Ethan
 

Tags
account, confused, dates, money, transfers
Similar Threads
Thread Forum Replies Last Post
Money 2002 account transfers cause erroneous ROI
Jon: I transferred several mutual fund accounts to a different broker using the instructions of KBA 128135, special transactions. They moved correctly...
Microsoft Money 1 02-17-2004 03:36 AM
Reconciling transfers between account
Mary: Whenever I make transfers from one account to pay for a credit card statement, Money easily recogniozes the transfer. But after I later download...
Microsoft Money 1 02-05-2004 04:48 PM
Transfers from one account to another.
BGuthrie: I am using Money 2003. I have about 8 accounts at 2 different banks. I update MS Money online only, I never input any other transactions any other...
Microsoft Money 4 01-08-2004 05:56 PM
Money 2004: separate dates for transfers between 2 accounts?
Nick: Money requires that you have a single date for a transfer between 2 accounts. However, in reality, this is often not the case. For example, when...
Microsoft Money 2 10-03-2003 07:42 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 02:30 AM.