Home Page link  

% of a check

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
% of a check drew.laura@gmail.com 09-08-2006
| `--> Re: % of a check drew.laura@gmai...09-11-2006
  `--> Re: % of a check drew.laura@gmai...09-11-2006
Posted by drew.laura@gmail.com on September 8, 2006, 10:50 pm
Please log in for more thread options
Ok - I have NEVER used quickbooks and I just started a new job where I
have to process bills to
be paid-for the bookkeepe who then puts them in QB.
I have a maybe complicated question about what QB can do:
Say for instance I have an Electric Bill.
It has to be split up between 2 catagories (not sure what you call them
in quickbooks)
say for instance
Administration 10% usage
Main Store Front 90% usage
(this is oversimplified for the example)
Anyway, is there a way to have QB have those calculations and
catagories in certain
Payees ?
So for instance if the Electric Bill is $256.00, all the book keeper
need do is enter the 256.00 and because we set it up to automatically
allocate 90% for the Store and 10% for Admin, it will do the math
automatically?
(sort of like if you had a spreadsheet with calculations in it?)

Right now that is how I have to do it. The owner has the few payees
(actually there are more than a few)
on a spreadsheet and %'s assigned for each catagory.
Gosh, I used Quicken years ago and I could have sworn you could do that
automatically....
Thanks for any help on impressing my new boss!
Laura


Posted by Allan Martin on September 9, 2006, 6:52 am
Please log in for more thread options

> Ok - I have NEVER used quickbooks and I just started a new job where I
> have to process bills to
> be paid-for the bookkeepe who then puts them in QB.
> I have a maybe complicated question about what QB can do:
> Say for instance I have an Electric Bill.
> It has to be split up between 2 catagories (not sure what you call them
> in quickbooks)
> say for instance
> Administration 10% usage
> Main Store Front 90% usage
> (this is oversimplified for the example)
> Anyway, is there a way to have QB have those calculations and
> catagories in certain
> Payees ?

QuickBooks does not have the ability to set up and use "distribution sets"
for vendors. As a matter of fact it does not even have a feature for
associating a default general ledger account with each vendor. QB's
feature for recalling the last transaction made for a vendor is lacking.

The use of default GL accounts and distribution sets is quite common in
mid-range accounting products. In addition mid-range products also have a
feature that can
automatically allocate amounts posted to certain general ledger accounts to
other accounts based on formulas.






> So for instance if the Electric Bill is $256.00, all the book keeper
> need do is enter the 256.00 and because we set it up to automatically
> allocate 90% for the Store and 10% for Admin, it will do the math
> automatically?
> (sort of like if you had a spreadsheet with calculations in it?)
>
> Right now that is how I have to do it. The owner has the few payees
> (actually there are more than a few)
> on a spreadsheet and %'s assigned for each catagory.
> Gosh, I used Quicken years ago and I could have sworn you could do that
> automatically....
> Thanks for any help on impressing my new boss!
> Laura
>



Posted by drew.laura@gmail.com on September 9, 2006, 11:32 am
Please log in for more thread options
so, as I am reading this right ....the answer is NO? sorry, I really
don't know anything about accounting and its terms.
sorry.


Posted by Lisa C on September 9, 2006, 3:45 pm
Please log in for more thread options
> so, as I am reading this right ....the answer is NO? sorry, I really
> don't know anything about accounting and its terms.
> sorry.
>
Yes, you are reading it correctly.

Quickbooks will not automatically calculate and enter percentages and splits
between multiple accounts.



Posted by drew.laura@gmail.com on September 9, 2006, 7:59 pm
Please log in for more thread options
well, its really just in one 'account' a bank account.
The thing we are trying to do is split the catagories into %.
Seems very simple.
hmmmm


Similar ThreadsPosted
QB and check printing November 20, 2006, 4:00 pm
Check catagorizing? July 24, 2007, 12:12 pm
Check Report November 17, 2007, 1:59 pm
G/L How to order by check numbers March 9, 2007, 11:56 am
Check Card Purchases March 15, 2007, 8:50 am
Posting One Check Between Two Customers May 14, 2007, 1:45 pm
1. Refunds 2. Promotional Check Management January 2, 2007, 10:39 pm
QBP2004 Check Reconciliation with Group Deposits May 18, 2007, 2:03 pm
Reversing the order of check display in the checkbook April 23, 2008, 3:14 pm
New to Quickbooks - Direct entry of A/R from custom application? Check amount editing? September 5, 2008, 10:46 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap