|
#3
| |||
| |||
| Neither of the solutions mentioned work for small business purposes... I'm still stuck with this problem... and I went through the pain of switching from Quicken just for this one problem... only to find that MS Money has the same damn problem! Let me explain: Split : This solution does not capture the accounting that needs to happen for a business because Money only sees a category and not which customer. Can't link it back to the invoice that the payment was for, etc. Another Account: Money already has an Accounts Receivable account set-up for my invoice tracking. I go there, and make a payment and tell it that the payment will be deposited into my checking. I do this for two customers ($100, $50), and then go to the bank and hand them both checks for which they make a $150 deposit. Automatic reconcile imports a $150 deposit, and the "Change" button will not let me select the two unreconciled deposits for $100 & $50 as it would for normal transactions because they are invoice payments. Does Microsoft even run this product through user trials at all? I would imagine that all small businesses operate this way!! Okay, so I can set-up still another account, make the invoice payments to that account, and then make transfers out of that account into the checking, but then that "virtual account" is completely managed by me and I end up with _TWO_ accounts receivable accounts just to deal with this stupid program. "Chris Cowles" wrote: - quote - > An alternative is to create a second dummy bank account called 'deposits'. > (I wouldn't bother with this unless I was a small business or something like > that.) Record the individual checks into the deposits account as income, > transfers from accounts receivable, etc. Record the actual bank deposit in > your checking account as a transfer from deposits. > Reconcile the deposits account when you receive record of the deposit. The > balance in the deposits account should always be zero, unless you have some > undeposited checks sitting on your desk. > Using splits is easier. Using the separate deposit account may provide more > information. > -- > Chris Cowles, > Gainesville, FL > "Mark Vetrano" <mvetrano[at]newbreed.com> wrote in message > news:%23n3UuGs3EHA.3416[at]TK2MSFTNGP09.phx.gbl... > > I have this same situation and the way I record it as follows: > > > Enter a single transaction and set up SPLITS for the category. Each split > > would be categorized for one check and put the check payee in the > > memo/description field. If your bank works like mine when I hand them 3 > > checks they break it our on the receipt but it actually show up on my > > statement as 1 deposit. I hope that helps. |
|
#2
| |||
| |||
| On Thu, 9 Dec 2004 22:58:06 -0600, "No Name" <not[at]gonnahappen.com> wrote: - quote - > Hi All,
I only download my bank transactions once a week, and then for the preceding> I was wondering if anyone has figured out a solution to this one... > I go the bank and deposit a few checks. At home, I record each of the > checks because their from different sources/categories, etc. Money > downloads a lump sum desposit from the bank and now I try to match to the > different transactions. I match them up, and accept them all and so far so > good. Until I try to update the accounts again, and the lump sum shows up > again. Any idea how to get Money to realize that it downloaded that > transaction already and I accepted it? BTW I'm using Money 2005, but have > had this problem for many versions. Thanks. > -David ten days. So I see that issue at most on only one download. OTOH, if I were downloading bank transactions daily, for the preceding ten days, I would see the problem on nine downloads. Perhaps you can alter the look back for your bank downloads? --ron |
|
#1
| |||
| |||
| An alternative is to create a second dummy bank account called 'deposits'. (I wouldn't bother with this unless I was a small business or something like that.) Record the individual checks into the deposits account as income, transfers from accounts receivable, etc. Record the actual bank deposit in your checking account as a transfer from deposits. Reconcile the deposits account when you receive record of the deposit. The balance in the deposits account should always be zero, unless you have some undeposited checks sitting on your desk. Using splits is easier. Using the separate deposit account may provide more information. -- Chris Cowles, Gainesville, FL "Mark Vetrano" <mvetrano[at]newbreed.com> wrote in message news:%23n3UuGs3EHA.3416[at]TK2MSFTNGP09.phx.gbl... - quote - > I have this same situation and the way I record it as follows: > Enter a single transaction and set up SPLITS for the category. Each split > would be categorized for one check and put the check payee in the > memo/description field. If your bank works like mine when I hand them 3 > checks they break it our on the receipt but it actually show up on my > statement as 1 deposit. I hope that helps. |
| | |||
| |||
| I have this same situation and the way I record it as follows: Enter a single transaction and set up SPLITS for the category. Each split would be categorized for one check and put the check payee in the memo/description field. If your bank works like mine when I hand them 3 checks they break it our on the receipt but it actually show up on my statement as 1 deposit. I hope that helps. Mark "No Name" <not[at]gonnahappen.com> wrote in message news:-PWdnT1VrZpCsSTcRVn-gw[at]giganews.com... - quote - > Hi All, > I was wondering if anyone has figured out a solution to this one... > I go the bank and deposit a few checks. At home, I record each of the > checks because their from different sources/categories, etc. Money > downloads a lump sum desposit from the bank and now I try to match to the > different transactions. I match them up, and accept them all and so far so > good. Until I try to update the accounts again, and the lump sum shows up > again. Any idea how to get Money to realize that it downloaded that > transaction already and I accepted it? BTW I'm using Money 2005, but have > had this problem for many versions. Thanks. > -David |
|
#-1
| |||
| |||
| Hi All, I was wondering if anyone has figured out a solution to this one... I go the bank and deposit a few checks. At home, I record each of the checks because their from different sources/categories, etc. Money downloads a lump sum desposit from the bank and now I try to match to the different transactions. I match them up, and accept them all and so far so good. Until I try to update the accounts again, and the lump sum shows up again. Any idea how to get Money to realize that it downloaded that transaction already and I accepted it? BTW I'm using Money 2005, but have had this problem for many versions. Thanks. -David |
| Tags |
| matching, multiple, transaction |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Transaction matching NOT Scott Jones: What are the "rules" for money's matching transactions? I find that it constantly mismatches items when the name is different and the amount is... | Microsoft Money | 2 | 10-13-2004 01:11 AM | |
| M2005- No Transaction Matching Gregg: I can manually enter a transaction into my Bank of America Checking register and then synchronize and exact matching transactions are entered as new... | Microsoft Money | 10 | 10-05-2004 01:07 AM | |
| RE:M2005-MSN Transaction Matching from BofA Glenn B.: I have 05 Premium. I've been banging my head the last two days trying to figure this out and am glad it's not me doing something wrong! No... | Microsoft Money | 7 | 10-04-2004 05:39 AM | |
| Money 2003 - duplicate downloads when matching multiple transactions David: I have a problem with downloading statements from my bank. If a downloaded deposit needs to be matched with multiple entries in the register as when... | Microsoft Money | 3 | 06-02-2004 05:24 PM | |
| transaction matching for invoice payments? Jason: I'm just setting up Money 2004 Small Business, and am having a problem using the transaction matching features with "Payment for Invoice"... | Microsoft Money | 4 | 10-30-2003 07:35 PM | |
| Thread Tools | |
| Display Modes | |
| |