klnaco,

I ran into the same problem, when setting up the "dummy account" for Account
Receivables. If I where you, create the AR dummy account as a BUSINESS
account, then you might be able to transfer the money from Accounts
Receivables to the dummy CASH account.

I have run into another issues with the Accounts Receivable issue. Maybe
someone has seen it.

I use the CASH METHOD of accounting. (It seems to be the simplest.) In the
Cash Accounting method, you realize your income when you actually receive the
money from your customer. NOT when you issue the bill to your customer. Well,
that is great, except MS Money records the income based on the Invoice date.
I issued a Invoice in Dec. 2007, and received the payment in Jan. 2008. So,
my Profit and Loss statement, in Business Reports, does not show the income
in 2008. GRRR.

Anyone run into this problem?

I searched the help for anything on Cash Method accounting, and came up with
nothing.

I am running MS Money Plus Home & Business, Version 17.0.150.1415

-TeamData

"klnaco" wrote:

- quote -

I´m understanding that your problem is to have duplicate entries on the
registry.
If this is the problem, here is how I solve this:
When electronic statements are downloaded, they show up in bold letters. You
have your previous entry, of the same transaction, so it gets doubled.
Right click the dowloaded transaction(bold letters), and choose CHANGE.
There will show up a screen with numerous entries already on your registry,
just choose the entry which is duplicated, and click match.
The transactions will match, and, from now on, won´t be totalized as
different entries.


I hope it helps.

Regards,

Felipe


Apologies for my poor english sometimes.

"klnaco" wrote:

- quote -

Thanks Chris and Thanks Cal.

I've been able to resolve some of this mystery. As for not being able to
import the past history statements, it turns out the bank only allows
downloads of current month and previous months data, even though they give
you the option to choose other date ranges. The files would fail when
importing them due to their being empty.

MS Money support suggested the same course of action, meaning set up a dummy
or "suspense" account to apply the payments to. The problem is there is no
reference I could find anywhere in MS Money where it is stated you should do
this. It stills seems like a work-around to me.

I'm going to try to do this and hopefully all will be weel again.

I appreciate you guys offering your advice. Best of luck to you.

Ken

"Chris Cowles" wrote:

- quote -

Accounts Receivable is not your deposit suspense account. AR are customers
who owe you money that have not yet paid.

There must be some way to flag the deposit account that activates it as an
account into which payments can be deposited. Did you set it up as a bank
account?
--
Chris Cowles
Gainesville, FL

"klnaco" <klnaco[at]discussions.microsoft.com> wrote in message
news:444F2A40-8DB0-4768-BA6E-DD3BF4614C25[at]microsoft.com...
- quote -

In microsoft.public.money, klnaco wrote:

<snip
- quote -

I think in accounting the term "suspense account" is used rather
than "dummy account".

http://www.m-w.com/cgi-bin/dictionar...spense+account

http://encarta.msn.com/encnet/featur...fid=1861717301

http://www.bloomberg.com/invest//glo...spense_account

Thank you for taking the time to respond Chris and for the advice.

To answer your questions:
-Yes it records each check deposited check individually in the register.
-Yes the bank records it as a single aggregate deposit.

As far as using the dummy acount, I already have an "accounts recievable"
acccount set up in addition to my bank accounts. This is similar to the
'dummy account' approach you had suggested. The problem is that when you
'accept payment' from a client the only options it offers for deposit are
either the checking account and the savings account.

To me, this seems to be pretty basic fucntionality for a program like this,
whether it be MS Money, Quickbooks or some other program. I have to beleive
there is some way to reconcile these differences without having to set up
other dummy accounts as wrk arounds. I just haven't found the right answer
yet.

BUT I'M HOPING....

"Chris Cowles" wrote:

- quote -

I don't have a business version so I'm guessing a bit on the functionality.

When you tie a payment to an invoice and it shows up in your register, does
it list each payment separately? When you download the deposit, can I safely
assume it downloads a single aggregate deposit?

If payments are listed as separate deposits, is there a means to deposit
those payments to an 'in-between' dummy account? Call it 'Pending Deposits'
or something like that. When you make an actual deposit to your checking
account, record it as a transfer from 'Pending Deposits'. When you download
the transaction from the bank, use the 'Change' button to match it to the
transferred download.

If all of this is a reasonable approach, reconcile the deposit transfer
against the payments in 'Pending Deposits' account. Otherwise it will be
hard to keep track of which payment was in which deposit.

Years ago (> 10) QuickBooks had a function to 'Record a bank deposit'. That
opened the pending deposits account and you checked off the checks that were
included. The result was a deposit in checking and it printed a list of the
checks included for the deposit slip.

--
Chris Cowles
Gainesville, FL

"klnaco" <klnaco[at]discussions.microsoft.com> wrote in message
news:8EA8AB2F-E709-4296-A2F9-2C2C9104970D[at]microsoft.com...
- quote -

Hi,

I have a very basic issue that I haven't been able to resolve, that I would
welcome advice on.

I'm using MS Money Small Business 2006 and am set up for online bank
statement updates. I've recently been getting my accounting in tighter shape
and have begun to create customer lists and invoices for these customers.

The problem I have is when I tie a payment to an invoice for a customer, the
payment shows up in my bank register. When I make the deposit at the bank the
deposit come through electronically. I know show double the amount in my
register even if I try to reconcile and balance the with the statement.

Does anyone have any advice on how to correct this?

Thanks.

Ken