Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 06-09-2006, 04:28 PM
R. Ian Lee
Guest
 
Posts: n/a
Default Re: Working with automatic sweeps

I would add to Cal's #1 process by mentioning that the order of events seems
to be important. I've noticed that when I first download and import all of
my transactions and then start stepping through and "Accept"ing them then
Money sometimes doesn't do such a good job of matching. It appears that the
match is done at the time of the import. I would recommend doing the #1
process in this order:

1. Download transactions from account A.
2. Process ("Accept") transactions from account A.
3. Download transactions from account B.
4. Process transactions from account B.


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Roger wrote:
> > I have paired savings and checking accounts. Every day money is swept
> > either from or too savings to keep a fixed balance.
> > > When I pull in the transactions I get entries in both accounts but neither

> > shows up as a Transfer. If I edit one of these in the Savings account, for
> > example, to make it a transfer from Checking a second entry appears in
> > Checking, which I then have to delete.
> > > Is there any sensible way to handle this? If you miss one of these

> > duplicated entries it screws up your accounts.

> You can handle this like a credit card payment.
> Here are three ways I like for credit cards, and one of them should
> be adaptable for your situation:
> 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). 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.
> 2. In method 2, don't handle credit card payments as transfers .
> 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. [this is Bonnie Synhorst's favorite credit card method.].
> This method is relatively simple with the least impact if you
> neglect to change the category.
> 3. Create a suspense account.
> I have one I call "In Transit", and I called it a "cash or other"
> account. Change each of the downloaded transactions into transfer
> to/from that account. That account will normally have a zero
> balance except while funds are in transit. Make your credit card
> payments as transfers to and from that account. This method will
> appeal to the desire for best representing what is happening.
> It has particular appeal if each end is dated differently, and you
> want to preserve both dates. If you miss changing one of the
> transactions to a transfer, only the "In Transit" account will have
> the wrong amount.

  #1  
Old 06-09-2006, 03:42 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Working with automatic sweeps

In microsoft.public.money, Roger wrote:

- quote -

> I have paired savings and checking accounts. Every day money is swept
> either from or too savings to keep a fixed balance.
> When I pull in the transactions I get entries in both accounts but neither
> shows up as a Transfer. If I edit one of these in the Savings account, for
> example, to make it a transfer from Checking a second entry appears in
> Checking, which I then have to delete.
> Is there any sensible way to handle this? If you miss one of these
> duplicated entries it screws up your accounts.


You can handle this like a credit card payment.

Here are three ways I like for credit cards, and one of them should
be adaptable for your situation:

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). 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.

2. In method 2, don't handle credit card payments as transfers .
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. [this is Bonnie Synhorst's favorite credit card method.].
This method is relatively simple with the least impact if you
neglect to change the category.

3. Create a suspense account.
I have one I call "In Transit", and I called it a "cash or other"
account. Change each of the downloaded transactions into transfer
to/from that account. That account will normally have a zero
balance except while funds are in transit. Make your credit card
payments as transfers to and from that account. This method will
appeal to the desire for best representing what is happening.

It has particular appeal if each end is dated differently, and you
want to preserve both dates. If you miss changing one of the
transactions to a transfer, only the "In Transit" account will have
the wrong amount.

 
Old 06-09-2006, 03:41 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Working with automatic sweeps

As with all account-to-account transfers when both accounts are downloaded,
Money is supposed to offer to match the second transaction downloaded with
the first transaction that has already been entered based on things like
date and amount. I can't say why it isn't in your case.

"Roger" <x[at]y> wrote in message
news:uI3%239i9iGHA.4504[at]TK2MSFTNGP03.phx.gbl...
- quote -

> I have paired savings and checking accounts. Every day money is swept
> either from or too savings to keep a fixed balance.
> When I pull in the transactions I get entries in both accounts but neither
> shows up as a Transfer. If I edit one of these in the Savings account,

for
> example, to make it a transfer from Checking a second entry appears in
> Checking, which I then have to delete.
> Is there any sensible way to handle this? If you miss one of these
> duplicated entries it screws up your accounts.



  #-1  
Old 06-09-2006, 03:24 PM
Roger
Guest
 
Posts: n/a
Default Working with automatic sweeps

I have paired savings and checking accounts. Every day money is swept
either from or too savings to keep a fixed balance.

When I pull in the transactions I get entries in both accounts but neither
shows up as a Transfer. If I edit one of these in the Savings account, for
example, to make it a transfer from Checking a second entry appears in
Checking, which I then have to delete.

Is there any sensible way to handle this? If you miss one of these
duplicated entries it screws up your accounts.

Roger


 

Tags
automatic, sweeps, working
Similar Threads
Thread Forum Replies Last Post
Can't Get Automatic Updates
Cultcab: I recently got a new PC with Money 2005, and I'm not able to set it up to automatically update when I open the program. I've read all the "help"...
Microsoft Money 5 01-22-2006 01:54 AM
Automatic updates
Paul Keller: BlankRecently converted to 05 from 04. In 04 my accounts updated automatically each day when I first opened money. Now I have to click on the...
Microsoft Money 7 12-02-2004 10:03 PM
Automatic Deposits
Dan: I have a recurring deposit set up in the bills and deposits for my weekly paycheck. I have it as an estimate though because it is different every...
Microsoft Money 1 11-12-2003 01:51 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 08:01 PM.