You cannot match invoice payments to downloaded transactions in Money (832772)



The information in this article applies to:

  • Microsoft Money 2004 Small Business
  • Microsoft Money 2003 Deluxe and Business
  • Microsoft Money 2005 Small Business
  • Microsoft Money 2007 Home & Business
  • Microsoft Money Small Business 2006

SYMPTOMS

You cannot match download transactions to invoice payments in any one of the products that is listed in the "Applies To" section.

CAUSE

This issue occurs because Microsoft Money does not support matching downloaded transactions to invoice payments.

WORKAROUND

To work around this issue, match transactions that were downloaded from the bank to payments that were received for an invoice by creating a Cash account in Money to temporarily hold the transactions. Deposit all Payment for Invoice transactions into the Cash account instead of the Business account. Then, transfer the Payment for Invoice transactions from the Cash account to the Business account. You can then download the statements and match them to the correct transactions.

MORE INFORMATION

To create a cash account in Money as described in the "Workaround" section, follow the steps that are appropriate for your version of Money.

Microsoft Money 2005 or later versions

  1. Start Money 2005, and then click the Banking tab.
  2. Click Account Tools, and then click Account Setup on the Account Tools menu.
  3. On the Choose an account type screen, click Other account type, and then click Next.
  4. In the Account Type list, click Cash, and then click Next.
  5. On the Choose level of detail screen, configure as much detail as you want to track, and then click Finish.

    Suggestion Name the account Invoice Payments or something to identify that this account is to be used for your invoice payments.

Microsoft Money 2004 and Microsoft Money 2003

  1. Start Money 2004 or Money 2003, and then click Account Setup on the Account & Bills menu.
  2. In the Assign a financial institution dialog box, click Not held at a bank, broker or other financial institution, and then click Next.
  3. In the Account Type list, click Cash, and then click Next.
  4. Type a name for the account, and then click Next.

    Suggestion Name the account Invoice Payments or something to identify that this account is to be used for your invoice payments.

  5. Click Business to designate the account type, and then click Next.
  6. Type 0 (zero) to set the account balance, and then click Finish.
Once you have created the cash account in Money, you will choose to record all payments received for invoices into this new Cash account. To do this, follow these steps:
  1. Start Money, and then click the Business tab.
  2. Click Receive payment for invoice, in the left pane.
  3. Enter your information for the payment. In the Where will you deposit the payment box, select the new Cash account that you just created.
  4. Repeat for all invoice payments you need to record.
After you have recorded all of your invoice payment, you will then transfer those payment amounts to your Business checking (or regular account you are using to track your business transactions) account. To do this, follow these steps:
  1. Start Money, and then click the Banking tab.
  2. Click to open the Cash account you created above.
  3. Enter a new Transfer transaction for the amount of the invoice payment. The Transfer to account should be your Business checking account.
  4. Repeat for all invoice payments you need to record.
You will need to repeat this process everytime you have an invoice payment to record.

After you complete this process, you will then be able to download your online statements and have them match with the transfers you have created from the Cash account to your Business checking account.

Modification Type:MinorLast Reviewed:7/14/2006
Keywords:kbprb KB832772