Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 03-18-2006, 07:55 PM
RickR
Guest
 
Posts: n/a
Default Re: Anyway to Combine Customer Deposits

If you're using my methond correctly, Invoice Payments will always have ZERO
balance - all 'Invoice Payments' coming in, are immediatedly transferred out
to the checking account where the deposit will be made. After posting a
bunch of invoice payments, the balance is the actual total amount you will be
transferring to your bank account (and depositing) so I don't normally have
to add anything up. But thanks Chris for confirming my 'self-taught' method.
--
RickR


"Chris Cowles" wrote:

- quote -

> "RickR" <RickR[at]discussions.microsoft.com> wrote in message
> news:7E8ACCD6-B6BC-45BD-97D8-899016511510[at]microsoft.com...
> > Here's how I do it. I created a 'cash' account called "Invoice Payments"
> > and whenever I post a receipt against an invoice I specify this account
> > to receive the funds. ... Then I simply create a new transaction in
> > Invoice
> > Payments, transferring the TOTAL of these 5 payments to my regular
> > checking.

> Years ago I helped someone with QuickBooks. There was a similar scheme built
> into it. The 'cash' account was titled 'Pending deposits'.
> What was nice was a function to 'build' a deposit, by picking multiple
> invoice payments off a list. As you did that, it summed them up as a single
> deposit into checking, with a balancing transfer to the 'Pending deposits'
> account. It also flagged the invoice payments as having already been
> deposited, so they weren't listed for picking on subsequent deposits.
> With the exception of the automatic pick list, the method you describe
> recreates the same process. I suggest reconciliation of the "invoice
> payments" account on a regular basis.
> --
> Chris Cowles
> Gainesville, FL

  #3  
Old 03-18-2006, 07:48 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Anyway to Combine Customer Deposits

"RickR" <RickR[at]discussions.microsoft.com> wrote in message
news:7E8ACCD6-B6BC-45BD-97D8-899016511510[at]microsoft.com...
- quote -

> Here's how I do it. I created a 'cash' account called "Invoice Payments"
> and whenever I post a receipt against an invoice I specify this account
> to receive the funds. ... Then I simply create a new transaction in
> Invoice
> Payments, transferring the TOTAL of these 5 payments to my regular
> checking.


Years ago I helped someone with QuickBooks. There was a similar scheme built
into it. The 'cash' account was titled 'Pending deposits'.

What was nice was a function to 'build' a deposit, by picking multiple
invoice payments off a list. As you did that, it summed them up as a single
deposit into checking, with a balancing transfer to the 'Pending deposits'
account. It also flagged the invoice payments as having already been
deposited, so they weren't listed for picking on subsequent deposits.

With the exception of the automatic pick list, the method you describe
recreates the same process. I suggest reconciliation of the "invoice
payments" account on a regular basis.
--
Chris Cowles
Gainesville, FL



  #2  
Old 03-18-2006, 07:38 PM
RickR
Guest
 
Posts: n/a
Default RE: Anyway to Combine Customer Deposits

No worry here - 'cash' is a way of identifying the way Micorsoft Money will
handle an account, assett, liability, cash, etc. In the subject we are
discussing, the issue was how to combine customer deposits. Here's how I do
it. I created a 'cash' account called "Invoice Payments" and whenever I post
a receipt against an invoice I specify this account to receive the funds.
Let's suppose I receive 5 payments that I post to five different invoices.
I'll have 5 different 'received' items in the Invoice Payments. Then I
simply create a new transaction in Invoice Payments, transferring the TOTAL
of these 5 payments to my regular checking. Then when the 'deposit'
transaction is downloaded from my bank, it 'matches' my transfer. Now my
bank account is accurate, the invoices have been posted correctly, and the
transactions in the "Invoice Payments" account are all links between the bank
deposit and the receivables invoices. This would probably work just as well
with only 'customers' as opposed to invoices. The point is, you want one
place to identify the individual receipts, but then you turn right around and
transfer these funds out of the Invoice Payments account to your checking
account, so the downloaded deposit (shich included all these items) will
'match' your transfer. There's no IRS 'gotcha' involved here.
--
RickR


"Brent" wrote:

- quote -

> Don't send anything to a cash account unless you are 100% sure you will never
> be audited by the IRS. They see the word "cash" and your world gets ugly
> really fast.
> "RickR" wrote:
> > I'm not speaking from experience (I haven't tried this yet) but I have been
> > researching this a bit, and think I've figured out how to get around some of
> > MMSB shortcomings. First off (as discussed in the Money 2005 thread) when
> > you receive a payment for an invoice, use a 'cash' account for the deposit
> > account (I called mine Invoice Payments). Let's say you receive two
> > different payments this way. Now, within the Invoice Payments account you
> > create a transfer for the full amount of the deposit (i.e. both 'payments
> > received') to your checking account. Now you have an item in your checking
> > account for the total deposit, which will match up to your downloaded deposit
> > transaction. Let me know if this helps.
> > --
> > RickR
> > > > "srazook" wrote:
> > > > Using Money 2006 Small Business, how can I combine customer deposits? ie, in
> > > my company receivables section there’s an option to “Receive payment for
> > > Invoice” but you can only group together payments for the same customer. If
> > > I receive payment for $500 from one customer and $400 from another how can my
> > > total deposit equal $900?

  #1  
Old 03-18-2006, 06:45 PM
Brent
Guest
 
Posts: n/a
Default RE: Anyway to Combine Customer Deposits

Don't send anything to a cash account unless you are 100% sure you will never
be audited by the IRS. They see the word "cash" and your world gets ugly
really fast.

"RickR" wrote:

- quote -

> I'm not speaking from experience (I haven't tried this yet) but I have been
> researching this a bit, and think I've figured out how to get around some of
> MMSB shortcomings. First off (as discussed in the Money 2005 thread) when
> you receive a payment for an invoice, use a 'cash' account for the deposit
> account (I called mine Invoice Payments). Let's say you receive two
> different payments this way. Now, within the Invoice Payments account you
> create a transfer for the full amount of the deposit (i.e. both 'payments
> received') to your checking account. Now you have an item in your checking
> account for the total deposit, which will match up to your downloaded deposit
> transaction. Let me know if this helps.
> --
> RickR
> "srazook" wrote:
> > Using Money 2006 Small Business, how can I combine customer deposits? ie, in
> > my company receivables section there’s an option to “Receive payment for
> > Invoice” but you can only group together payments for the same customer. If
> > I receive payment for $500 from one customer and $400 from another how can my
> > total deposit equal $900?

 
Old 03-11-2006, 06:55 PM
RickR
Guest
 
Posts: n/a
Default RE: Anyway to Combine Customer Deposits

I'm not speaking from experience (I haven't tried this yet) but I have been
researching this a bit, and think I've figured out how to get around some of
MMSB shortcomings. First off (as discussed in the Money 2005 thread) when
you receive a payment for an invoice, use a 'cash' account for the deposit
account (I called mine Invoice Payments). Let's say you receive two
different payments this way. Now, within the Invoice Payments account you
create a transfer for the full amount of the deposit (i.e. both 'payments
received') to your checking account. Now you have an item in your checking
account for the total deposit, which will match up to your downloaded deposit
transaction. Let me know if this helps.
--
RickR


"srazook" wrote:

- quote -

> Using Money 2006 Small Business, how can I combine customer deposits? ie, in
> my company receivables section there’s an option to “Receive payment for
> Invoice” but you can only group together payments for the same customer. If
> I receive payment for $500 from one customer and $400 from another how can my
> total deposit equal $900?

  #-1  
Old 02-22-2006, 06:15 PM
srazook
Guest
 
Posts: n/a
Default Anyway to Combine Customer Deposits

Using Money 2006 Small Business, how can I combine customer deposits? ie, in
my company receivables section there’s an option to “Receive payment for
Invoice” but you can only group together payments for the same customer. If
I receive payment for $500 from one customer and $400 from another how can my
total deposit equal $900?
 

Tags
combine, customer, deposits
Similar Threads
Thread Forum Replies Last Post
Combine
Dutch: I have two files in money. One is Investments, where I record all my Investments and the other is Bank, where I record all Banking transactions....
Microsoft Money 3 07-31-2005 03:20 PM
How to combine two Money Files?
Seamus: I have two separate money files, one with all my stock info, and the other with checking, savings accounts, etc. I would like to combine the two...
Microsoft Money 1 09-16-2004 03:43 PM
Combine Files??
Donnie: Me and my Fiancee both use Money 2004. We will be getting married in August. What would be the easiest way to combine the 2 files together so...
Microsoft Money 1 02-16-2004 05:11 PM
can you combine 2 Money files
Getter: My partner and I both use Money. We would like to combine our 2 separate file into one large file. Is this possible? If so, what are the steps to...
Microsoft Money 1 01-14-2004 02:37 AM
Combine two loans? 2003
W Elwyn Gaige: This question come from a 'lender' perspective. I hold two loans which I want to combine into one. How do I set this up so that the new loan...
Microsoft Money 1 08-24-2003 08:36 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 05:32 PM.