% of a check


D

drew.laura

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
 
Ad

Advertisements

A

Allan Martin

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.
 
G

Gil Faver

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....
you are right about Quciken.
 
D

drew.laura

so, as I am reading this right ....the answer is NO? sorry, I really
don't know anything about accounting and its terms.
sorry.
 
L

Lisa C

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.
 
D

drew.laura

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
 
Ad

Advertisements

G

Gil Faver

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
yes, but when you buy software to help automate, you would like it to help
automate.
 
D

drew.laura

yes, but when you buy software to help automate, you would like it to help
automate.
Exactly....I would think it should be able to do this....I don't think
this is an uncommon thing.
bummer that it can't do it.
thanks anyway.
Laura
 
A

Allan Martin

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
You don't give up do you.
 
A

Allan Martin

Exactly....I would think it should be able to do this....I don't think
this is an uncommon thing.
bummer that it can't do it.
thanks anyway.
Laura

True but when one realizes that each user has their own wish list for
features they would like to see in software that list starts to get very
large.
 
L

Lisa C

well, its really just in one 'account' a bank account.
QB is a double-entry accounting system. By definition each entry always
affects MORE THAN ONE ACCOUNT.
The thing we are trying to do is split the catagories into %.
Seems very simple.
hmmmm
You are thinking in QUICKEN terms. Quicken 'categories' DO NOT EXIST in
QuickBooks.
 
Ad

Advertisements

L

Lisa C

Allan Martin said:
You don't give up do you.
Not giving up is admirable.

Not understanding the basic terminology of the software you want help
with.... well, that is less admirable.
 
D

drew.laura

Allen,
I believe I did state I did not know anything about QB, sorry if I have
offended you or anyone else by being persistant.
I was hoping someone else would come up with a creative solution.
Thanks anyway.
Laura
 
A

Allan Martin

Allen,
I believe I did state I did not know anything about QB, sorry if I have
offended you or anyone else by being persistant.
I was hoping someone else would come up with a creative solution.
Thanks anyway.

I understand. There are various parts of no that are difficult to understand
:)
 
G

Gil Faver

given the wide variety of responses available on the internet, including
correct, incorrect, misinformed, and just plain snotty, it often pays to be
persistent.
 
L

Lisa C

Allen,
I believe I did state I did not know anything about QB, sorry if I have
offended you or anyone else by being persistant.
I was hoping someone else would come up with a creative solution.
Thanks anyway.
Laura
You did not offend me. I am very sorry if I offended you.
 
Ad

Advertisements

A

Arno Martens

On 10 Sep 2006 10:42:10 -0700, "(e-mail address removed)"
Allen,
I believe I did state I did not know anything about QB, sorry if I have
offended you or anyone else by being persistant.
I was hoping someone else would come up with a creative solution.
Thanks anyway.
Laura
Laura,
I learned a lot on this list as there are very many helpful posters.
One of the very first things was to put a Kill Filter on Allen.
Unfortunately, he does bait enough people to react to his posts so you
will see that he has posted something. In that case, the delete key
works wonders.
 
R

RobertM

Arno Martens said:
On 10 Sep 2006 10:42:10 -0700, "(e-mail address removed)"


Laura,
I learned a lot on this list as there are very many helpful posters.
One of the very first things was to put a Kill Filter on Allen.
Unfortunately, he does bait enough people to react to his posts so you
will see that he has posted something. In that case, the delete key
works wonders.
Best advice yet. I added Captain Enron to my killfile shortly after I
bought QuickBooks. It's been peaceful ever since.

Bob
 
S

scfundogs

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.
Your bank account is one of many accounts associated with your company's
bookkeeping. Paying bills takes money out of the bank account and puts it
into an expense account (what you're calling categories).
 
Ad

Advertisements

S

scfundogs

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.
<snip>
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?
<snip>
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.
Maybe processing isn't a large part of your duties but if it is then you may
want to rethink finding ways to lessen the amount of work you have to
do...job security is a good thing Just a suggestion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top