Accountant Forums


Reply
Thread Tools

Invoices in Quicken Home and Business

 
 
Anita
Guest
Posts: n/a
Thanked:
 
      08-26-2009, 12:49 PM
We have Quicken Premier Home and Business 2004 and tried to use the
invoice feature for a 50 unit storage park. Each month, we deposit 2 or 3
batches of small rent checks. However, each invoice I recorded as paid
showed up in the bank account as a separate deposit, which was a nightmare
when reconciling with the bank statement. I was never able to find
anything that would allow me to lump more than one invoice payment into a
single deposit, in the way that Quickbooks allows you to do. Within two
months, we went to keeping paper records of all the accounts, and only
using Quicken to keep track of the bank account. After several years of
keeping records on paper, we are very ready to return to the computer age.

Finally, the question! Anyone know if this is still the way it works with
the current H & B version? Or experience with the Quicken Rental Property
Manager? Or a way to get around the problem in the software we have?
Can't find any detailed information at all about the invoice feature on
the intuit website.


Anita
-------------------------------------



##-----------------------------------------------#
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forum
Web and RSS access to your favorite newsgroup -
alt.comp.software.financial.quicken - 18333 messages and counting
##-----------------------------------------------##
 
Reply With Quote
 
 
 
 
John Pollard
Guest
Posts: n/a
Thanked:
 
      08-26-2009, 01:29 PM
Anita wrote:
> We have Quicken Premier Home and Business 2004 and tried to use the
> invoice feature for a 50 unit storage park. Each month, we deposit 2
> or 3 batches of small rent checks. However, each invoice I recorded
> as paid showed up in the bank account as a separate deposit, which
> was a nightmare when reconciling with the bank statement. I was
> never able to find anything that would allow me to lump more than one
> invoice payment into a single deposit, in the way that Quickbooks
> allows you to do. Within two months, we went to keeping paper
> records of all the accounts, and only using Quicken to keep track of
> the bank account. After several years of keeping records on paper,
> we are very ready to return to the computer age.
>
> Finally, the question! Anyone know if this is still the way it works
> with the current H & B version? Or experience with the Quicken
> Rental Property Manager? Or a way to get around the problem in the
> software we have? Can't find any detailed information at all about
> the invoice feature on the intuit website.


I'm not sure what Quickbooks allows you to do for your type problem,
though I have long thought that it was Intuit (and/or Quickbooks users)
that suggested the technique for handling your problem.

The approach typically recommended is to create a holding account in
Quicken; have your Quicken deposit transactions deposited (transferred,
when necessary) into the Quicken holding account. When it comes time to
make an actual bank deposit, transfer the amount of the bank deposit from
the Quicken holding account into the Quicken bank account ... producing
one deposit transaction in the Quicken bank account to agree with one
deposit transaction in the real-world bank account.

If you download transactions, an alternative approach is to use Quicken's
"Manual Match" feature to match a single downloaded deposit transaction to
multiple existing Quicken register transactions ... replacing the multiple
original transactions and creating a single split transaction with each
original deposit in a separate split line. This has the drawback of
eliminating the individual payee name fields (putting the payee name in
the Memo field of each split line), which can hamper subsequent searches,
selections, subtotals, etc.
[I have not tested this, but logically I would expect that the newer
versions of Quicken - which allow for over 240 split lines - could handle
many more deposit transaction this way, than the older Quicken versions
which were limited to 30 split lines.]

Q2009 works the same as Q2004 in this regard (except possibly for the
increased number of split lines - I don't know when that number was
increased). I have Q2009 Rental Property Manager, but I do not believe
that it differs from any other Q2009 version in this regard.

--

John Pollard


 
Reply With Quote
 
 
 
 
Laura
Guest
Posts: n/a
Thanked:
 
      08-26-2009, 09:24 PM
"John Pollard" <(E-Mail Removed)> wrote in message
news:kNalm.24374$la3.10320@attbi_s22...
> Anita wrote:
>> We have Quicken Premier Home and Business 2004 and tried to use the
>> invoice feature for a 50 unit storage park. Each month, we deposit 2
>> or 3 batches of small rent checks. However, each invoice I recorded
>> as paid showed up in the bank account as a separate deposit, which
>> was a nightmare when reconciling with the bank statement. I was
>> never able to find anything that would allow me to lump more than one
>> invoice payment into a single deposit, in the way that Quickbooks
>> allows you to do. Within two months, we went to keeping paper
>> records of all the accounts, and only using Quicken to keep track of
>> the bank account. After several years of keeping records on paper,
>> we are very ready to return to the computer age.
>>
>> Finally, the question! Anyone know if this is still the way it works
>> with the current H & B version? Or experience with the Quicken
>> Rental Property Manager? Or a way to get around the problem in the
>> software we have? Can't find any detailed information at all about
>> the invoice feature on the intuit website.

>
> I'm not sure what Quickbooks allows you to do for your type problem,
> though I have long thought that it was Intuit (and/or Quickbooks users)
> that suggested the technique for handling your problem.
>
> The approach typically recommended is to create a holding account in
> Quicken; have your Quicken deposit transactions deposited (transferred,
> when necessary) into the Quicken holding account. When it comes time to
> make an actual bank deposit, transfer the amount of the bank deposit from
> the Quicken holding account into the Quicken bank account ... producing
> one deposit transaction in the Quicken bank account to agree with one
> deposit transaction in the real-world bank account.


What you describe is the QuickBooks current asset account known as
Undeposited Funds that functions like a holding account. It is a special
account to be used for just this purpose. All payments can be received into
this holding account and then transferred in batches to line up with the
actual bank deposit.

Since H&B is the Q attempt at being like QB I am surprised that this
function is not available.

>
> If you download transactions, an alternative approach is to use Quicken's
> "Manual Match" feature to match a single downloaded deposit transaction to
> multiple existing Quicken register transactions ... replacing the multiple
> original transactions and creating a single split transaction with each
> original deposit in a separate split line. This has the drawback of
> eliminating the individual payee name fields (putting the payee name in
> the Memo field of each split line), which can hamper subsequent searches,
> selections, subtotals, etc.
> [I have not tested this, but logically I would expect that the newer
> versions of Quicken - which allow for over 240 split lines - could handle
> many more deposit transaction this way, than the older Quicken versions
> which were limited to 30 split lines.]
>
> Q2009 works the same as Q2004 in this regard (except possibly for the
> increased number of split lines - I don't know when that number was
> increased). I have Q2009 Rental Property Manager, but I do not believe
> that it differs from any other Q2009 version in this regard.
>
> --
>
> John Pollard
>


 
Reply With Quote
 
jo
Guest
Posts: n/a
Thanked:
 
      08-27-2009, 01:58 AM
On Aug 26, 5:24*pm, "Laura" <(E-Mail Removed)> wrote:
> "John Pollard" <(E-Mail Removed)> wrote in message
>
> news:kNalm.24374$la3.10320@attbi_s22...
>
>
>
>
>
> > Anita wrote:
> >> We have Quicken Premier Home and Business 2004 and tried to use the
> >> invoice feature for a 50 unit storage park. *Each month, we deposit 2
> >> or 3 batches of small rent checks. *However, each invoice I recorded
> >> as paid showed up in the bank account as a separate deposit, which
> >> was a nightmare when reconciling with the bank statement. *I was
> >> never able to find anything that would allow me to lump more than one
> >> invoice payment into a single deposit, in the way that Quickbooks
> >> allows you to do. *Within two months, we went to keeping paper
> >> records of all the accounts, and only using Quicken to keep track of
> >> the bank account. *After several years of keeping records on paper,
> >> we are very ready to return to the computer age.

>
> >> Finally, the question! *Anyone know if this is still the way it works
> >> with the current H & B version? *Or experience with the Quicken
> >> Rental Property Manager? *Or a way to get around the problem in the
> >> software we have? Can't find any detailed information at all about
> >> the invoice feature on the intuit website.

>
> > I'm not sure what Quickbooks allows you to do for your type problem,
> > though I have long thought that it was Intuit (and/or Quickbooks users)
> > that suggested the technique for handling your problem.

>
> > The approach typically recommended is to create a holding account in
> > Quicken; have your Quicken deposit transactions deposited (transferred,
> > when necessary) into the Quicken holding account. *When it comes timeto
> > make an actual bank deposit, transfer the amount of the bank deposit from
> > the Quicken holding account into the Quicken bank account ... producing
> > one deposit transaction in the Quicken bank account to agree with one
> > deposit transaction in the real-world bank account.

>
> What you describe is the QuickBooks current asset account known as
> Undeposited Funds that functions like a holding account. It is a special
> account to be used for just this purpose. All payments can be received into
> this holding account and then transferred in batches to line up with the
> actual bank deposit.
>
> Since H&B is the Q attempt at being like QB I am surprised that this
> function is not available.
>
>
>
>
>
> > If you download transactions, an alternative approach is to use Quicken's
> > "Manual Match" feature to match a single downloaded deposit transactionto
> > multiple existing Quicken register transactions ... replacing the multiple
> > original transactions and creating a single split transaction with each
> > original deposit in a separate split line. *This has the drawback of
> > eliminating the individual payee name fields (putting the payee name in
> > the Memo field of each split line), which can hamper subsequent searches,
> > selections, subtotals, etc.
> > [I have not tested this, but logically I would expect that the newer
> > versions of Quicken - which allow for over 240 split lines - could handle
> > many more deposit transaction this way, than the older Quicken versions
> > which were limited to 30 split lines.]

>
> > Q2009 works the same as Q2004 in this regard (except possibly for the
> > increased number of split lines - I don't know when that number was
> > increased). *I have Q2009 Rental Property Manager, but I do not believe
> > that it differs from any other Q2009 version in this regard.

>
> > --

>
> > John Pollard- Hide quoted text -

>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -


The Undeposited funds capability is available. I've used it for years
in Home and Busines. If the account isn't defined by default, create
one.

jo
 
Reply With Quote
 
Laura
Guest
Posts: n/a
Thanked:
 
      08-27-2009, 12:00 PM

"jo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
On Aug 26, 5:24 pm, "Laura" <(E-Mail Removed)> wrote:
> "John Pollard" <(E-Mail Removed)> wrote in message
>
> news:kNalm.24374$la3.10320@attbi_s22...
>
>
>
>
>
> > Anita wrote:
> >> We have Quicken Premier Home and Business 2004 and tried to use the
> >> invoice feature for a 50 unit storage park. Each month, we deposit 2
> >> or 3 batches of small rent checks. However, each invoice I recorded
> >> as paid showed up in the bank account as a separate deposit, which
> >> was a nightmare when reconciling with the bank statement. I was
> >> never able to find anything that would allow me to lump more than one
> >> invoice payment into a single deposit, in the way that Quickbooks
> >> allows you to do. Within two months, we went to keeping paper
> >> records of all the accounts, and only using Quicken to keep track of
> >> the bank account. After several years of keeping records on paper,
> >> we are very ready to return to the computer age.

>
> >> Finally, the question! Anyone know if this is still the way it works
> >> with the current H & B version? Or experience with the Quicken
> >> Rental Property Manager? Or a way to get around the problem in the
> >> software we have? Can't find any detailed information at all about
> >> the invoice feature on the intuit website.

>
> > I'm not sure what Quickbooks allows you to do for your type problem,
> > though I have long thought that it was Intuit (and/or Quickbooks users)
> > that suggested the technique for handling your problem.

>
> > The approach typically recommended is to create a holding account in
> > Quicken; have your Quicken deposit transactions deposited (transferred,
> > when necessary) into the Quicken holding account. When it comes time to
> > make an actual bank deposit, transfer the amount of the bank deposit
> > from
> > the Quicken holding account into the Quicken bank account ... producing
> > one deposit transaction in the Quicken bank account to agree with one
> > deposit transaction in the real-world bank account.

>
> What you describe is the QuickBooks current asset account known as
> Undeposited Funds that functions like a holding account. It is a special
> account to be used for just this purpose. All payments can be received
> into
> this holding account and then transferred in batches to line up with the
> actual bank deposit.
>
> Since H&B is the Q attempt at being like QB I am surprised that this
> function is not available.
>
>
>
>
>
> > If you download transactions, an alternative approach is to use
> > Quicken's
> > "Manual Match" feature to match a single downloaded deposit transaction
> > to
> > multiple existing Quicken register transactions ... replacing the
> > multiple
> > original transactions and creating a single split transaction with each
> > original deposit in a separate split line. This has the drawback of
> > eliminating the individual payee name fields (putting the payee name in
> > the Memo field of each split line), which can hamper subsequent
> > searches,
> > selections, subtotals, etc.
> > [I have not tested this, but logically I would expect that the newer
> > versions of Quicken - which allow for over 240 split lines - could
> > handle
> > many more deposit transaction this way, than the older Quicken versions
> > which were limited to 30 split lines.]

>
> > Q2009 works the same as Q2004 in this regard (except possibly for the
> > increased number of split lines - I don't know when that number was
> > increased). I have Q2009 Rental Property Manager, but I do not believe
> > that it differs from any other Q2009 version in this regard.

>
> > --

>
> > John Pollard- Hide quoted text -

>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -


>The Undeposited funds capability is available. I've used it for years
>in Home and Busines. If the account isn't defined by default, create
>one.


Where's the "make Deposit" tool that automates selecting the payments in the
UF account? Sure, you can manually mimic the QB UF capability but it should
already exist.

 
Reply With Quote
 
jo
Guest
Posts: n/a
Thanked:
 
      08-29-2009, 01:46 AM
On Aug 27, 8:00*am, "Laura" <(E-Mail Removed)> wrote:
> "jo" <(E-Mail Removed)> wrote in message
>
> news:(E-Mail Removed)...
> On Aug 26, 5:24 pm, "Laura" <(E-Mail Removed)> wrote:
>
>
>
>
>
> > "John Pollard" <(E-Mail Removed)> wrote in message

>
> >news:kNalm.24374$la3.10320@attbi_s22...

>
> > > Anita wrote:
> > >> We have Quicken Premier Home and Business 2004 and tried to use the
> > >> invoice feature for a 50 unit storage park. Each month, we deposit 2
> > >> or 3 batches of small rent checks. However, each invoice I recorded
> > >> as paid showed up in the bank account as a separate deposit, which
> > >> was a nightmare when reconciling with the bank statement. I was
> > >> never able to find anything that would allow me to lump more than one
> > >> invoice payment into a single deposit, in the way that Quickbooks
> > >> allows you to do. Within two months, we went to keeping paper
> > >> records of all the accounts, and only using Quicken to keep track of
> > >> the bank account. After several years of keeping records on paper,
> > >> we are very ready to return to the computer age.

>
> > >> Finally, the question! Anyone know if this is still the way it works
> > >> with the current H & B version? Or experience with the Quicken
> > >> Rental Property Manager? Or a way to get around the problem in the
> > >> software we have? Can't find any detailed information at all about
> > >> the invoice feature on the intuit website.

>
> > > I'm not sure what Quickbooks allows you to do for your type problem,
> > > though I have long thought that it was Intuit (and/or Quickbooks users)
> > > that suggested the technique for handling your problem.

>
> > > The approach typically recommended is to create a holding account in
> > > Quicken; have your Quicken deposit transactions deposited (transferred,
> > > when necessary) into the Quicken holding account. When it comes time to
> > > make an actual bank deposit, transfer the amount of the bank deposit
> > > from
> > > the Quicken holding account into the Quicken bank account ... producing
> > > one deposit transaction in the Quicken bank account to agree with one
> > > deposit transaction in the real-world bank account.

>
> > What you describe is the QuickBooks current asset account known as
> > Undeposited Funds that functions like a holding account. It is a special
> > account to be used for just this purpose. All payments can be received
> > into
> > this holding account and then transferred in batches to line up with the
> > actual bank deposit.

>
> > Since H&B is the Q attempt at being like QB I am surprised that this
> > function is not available.

>
> > > If you download transactions, an alternative approach is to use
> > > Quicken's
> > > "Manual Match" feature to match a single downloaded deposit transaction
> > > to
> > > multiple existing Quicken register transactions ... replacing the
> > > multiple
> > > original transactions and creating a single split transaction with each
> > > original deposit in a separate split line. This has the drawback of
> > > eliminating the individual payee name fields (putting the payee name in
> > > the Memo field of each split line), which can hamper subsequent
> > > searches,
> > > selections, subtotals, etc.
> > > [I have not tested this, but logically I would expect that the newer
> > > versions of Quicken - which allow for over 240 split lines - could
> > > handle
> > > many more deposit transaction this way, than the older Quicken versions
> > > which were limited to 30 split lines.]

>
> > > Q2009 works the same as Q2004 in this regard (except possibly for the
> > > increased number of split lines - I don't know when that number was
> > > increased). I have Q2009 Rental Property Manager, but I do not believe
> > > that it differs from any other Q2009 version in this regard.

>
> > > --

>
> > > John Pollard- Hide quoted text -

>
> > - Show quoted text -- Hide quoted text -

>
> > - Show quoted text -
> >The Undeposited funds capability is available. *I've used it for years
> >in Home and Busines. If the account isn't defined by default, create
> >one.

>
> Where's the "make Deposit" tool that automates selecting the payments in the
> UF account? Sure, you can manually mimic the QB UF capability but it should
> already exist.- Hide quoted text -
>
> - Show quoted text -


I'm about 99% sure that the QB "make Deposit" tool doesn't exist in
Quicken H&B. You have to "transfer" the total amount you are
depositing to your bank account. For the simple business I ran, it
was never an issue to do it that way.

jo
 
Reply With Quote
 
Anita
Guest
Posts: n/a
Thanked:
 
      08-31-2009, 04:07 PM
Anita had written this in response to
http://www.rockryno.com/quicken/Re-I...ess-18920-.htm
:
Thanks to all of you that replied. All your comments have been really
helpful,
and I now have some ideas to work with. Any other comments out there from
H & B
users on this subject would be very much appreciated. Anita



> I'm not sure what Quickbooks allows you to do for your type problem,
> though I have long thought that it was Intuit (and/or Quickbooks users)


> that suggested the technique for handling your problem.


> The approach typically recommended is to create a holding account in
> Quicken; have your Quicken deposit transactions deposited (transferred,


> when necessary) into the Quicken holding account. When it comes time
> to
> make an actual bank deposit, transfer the amount of the bank deposit
> from
> the Quicken holding account into the Quicken bank account ... producing


> one deposit transaction in the Quicken bank account to agree with one
> deposit transaction in the real-world bank account.


> If you download transactions, an alternative approach is to use
> Quicken's
> "Manual Match" feature to match a single downloaded deposit
> transaction to
> multiple existing Quicken register transactions ... replacing the
> multiple
> original transactions and creating a single split transaction with each


> original deposit in a separate split line. This has the drawback of
> eliminating the individual payee name fields (putting the payee name in


> the Memo field of each split line), which can hamper subsequent
> searches,
> selections, subtotals, etc.
> [I have not tested this, but logically I would expect that the newer
> versions of Quicken - which allow for over 240 split lines - could
> handle
> many more deposit transaction this way, than the older Quicken versions


> which were limited to 30 split lines.]


> Q2009 works the same as Q2004 in this regard (except possibly for the
> increased number of split lines - I don't know when that number was
> increased). I have Q2009 Rental Property Manager, but I do not believe


> that it differs from any other Q2009 version in this regard.





##-----------------------------------------------#
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forum
Web and RSS access to your favorite newsgroup -
alt.comp.software.financial.quicken - 18379 messages and counting
##-----------------------------------------------##
 
Reply With Quote
 
Anita
Guest
Posts: n/a
Thanked:
 
      08-31-2009, 04:11 PM
Anita had written this in response to
http://www.rockryno.com/quicken/Re-I...ess-18923-.htm
:
Perhaps it is and I just didn't realize how to use it. I will keep
searching.
Anita


> What you describe is the QuickBooks current asset account known as
> Undeposited Funds that functions like a holding account. It is a
> special
> account to be used for just this purpose. All payments can be received
> into
> this holding account and then transferred in batches to line up with
> the
> actual bank deposit.


> Since H&B is the Q attempt at being like QB I am surprised that
> this
> function is not available.




##-----------------------------------------------#
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forum
Web and RSS access to your favorite newsgroup -
alt.comp.software.financial.quicken - 18379 messages and counting
##-----------------------------------------------##
 
Reply With Quote
 
Laura
Guest
Posts: n/a
Thanked:
 
      08-31-2009, 06:05 PM
The account does not exist by default in Quicken. You have to create it
yourself plus you need to do the manual grouping of deposits too. QuickBooks
has this feature automated. Quicken does not.


"Anita" <(E-Mail Removed)> wrote in message
news:4cf7a$4a9bf63c$43de0cc0$(E-Mail Removed) roups.com...
> Anita had written this in response to
> http://www.rockryno.com/quicken/Re-I...ess-18923-.htm
> :
> Perhaps it is and I just didn't realize how to use it. I will keep
> searching.
> Anita
>
>
>> What you describe is the QuickBooks current asset account known as
>> Undeposited Funds that functions like a holding account. It is a
>> special
>> account to be used for just this purpose. All payments can be received
>> into
>> this holding account and then transferred in batches to line up with
>> the
>> actual bank deposit.

>
>> Since H&B is the Q attempt at being like QB I am surprised that
>> this
>> function is not available.

>
>
>
>
> ##-----------------------------------------------##
> Newsgroup Access Courtesy http://www.rockryno.com/
> Tax and Accounting Software Forums
> Web and RSS access to your favorite newsgroup -
> alt.comp.software.financial.quicken - 18379 messages and counting!
> ##-----------------------------------------------##


 
Reply With Quote
 
 
 
Reply

Thread Tools

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 On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plus Home and Business Clearing deposited invoices SteveC Microsoft Money 7 05-10-2008 02:17 PM
Home & Business - Accounts Receivable and Invoices currency? XL Microsoft Money 0 08-06-2006 11:28 PM
Invoices with Quicken 2004 Premier Home & Business Danny Kile Quicken 28 09-21-2004 06:19 PM
Archiving invoices in MS Money 2004 (Home and Business) Gary Microsoft Money 0 04-25-2004 05:10 PM
Quicken 2004 Premier Home & Business v. Quicken 2001 Home & Business Zoro Quicken 6 09-10-2003 11:36 AM


All times are GMT. The time now is 09:30 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.