| |
You are here: Experts > Shopping > Credit/Debt Management > Quicken & Other Budget/Accounting Software > Quicken Unit Sales Reports
Expert: Linda Saltz, CPA, QBalance.com - 11/4/2009
Question
QUESTION: I use Quicken Home & Business for my online comic book business. I have about a dozen comics that I sell through 3 vendors. I would like to be able to track unit sales as well as sales in dollars. Is it possible to generate reports with unit sales in Quicken or Quickbooks?
ANSWER: Hi Jay,
QuickBooks includes a sales report, Sales by item summary which displays total Quantity and
total sales dollars by Item. You can filter this report to display just one customer, then
memorize the report for easy retrieval. You will need to run 3 reports, one per customer,
to get all the information you are looking for. You can also set up a Memorized Group, save the
3 reports to that group, and when it is time to display or print them, you can select all the
reports in that group at once, making fast work of getting the information you are looking for.
I do not use Quicken Home and Business and therefore, I cannot research the reports available.
I recommend running the sales reports that are available, clicking on the customize button in the top right corner and looking at the display tab. If the Columns section does not offer an
option to display Quantity, then you will not be able to retrieve the reports you need.
You can however, filter these reports under the same customize button by customer, by clicking on
the payee tab and selecting only one customer.
Hope this helps,
Linda Saltz, CPA
Advanced Certified QuickBooks Advisor
www.qbalance.com
We sell QuickBooks Checks at a discount!
---------- FOLLOW-UP ----------
QUESTION: Thanks so much for your very helpful answer! I do have another question on Items. (BTW it appears that Quicken Home & Business does not support items)
For my comic business, I pay artists (Vendors) for artwork. I'd like to associate the cost of the item (comic) with the sales of each item (comic) to gauge its profitability. It doesn't look like I can do that on Quickbooks Simple Start? Is this possible on Quickbooks Pro?
Also, when I sell the comics, some are sold through a Web Site that charges a fixed 20% sales fee. Others are sold directly through Paypal for a varying fee. Rather than list each customer (there are thousands) I'd like to just have sales by the Web Site and sales by Paypal. Can I automate the 20% fee and input the variable fee each month?
Thanks again!
Answer
Hi Jay,
Yes, QuickBooks Pro will track profitability by item, the report is called Item profitability.
In QuickBooks Pro on each expense transaction type (bill, check, credit card charge)
there is an item tab, you would use this tab to enter your purchases of comics.
You could accomplish it several ways.
You could memorize a sales receipt with that the following
Item sold
Discount item =20% (pointing to a sales fee expense
The net transaction being the amount you will actually deposit into your account
Click on the memorized transaction any time you make a sale.
If you are sending this sales receipt to a customer, the above solution would not work
but it does not sound like you would be sending sales receipts from QuickBooks
If you want an easy job of reconciling your bank account, you would want your deposits in QuickBooks to match your bank statement. You might ask your merchant account to
deduct the variable fee once a month instead of after each transaction. If they are deducting on each transaction and depositing the net amount, I recommend using the above procedure to enter
the transaction. If they are separately deducting the fee, then you could add them all up during the month and enter just one transaction.
Hope this helps,
Linda Saltz, CPA
Advanced Certified QuickBooks Advisor
We sell QuickBooks at a discount.
http://www.qbalance.com/Quickbooks.htm
Add to this Answer Ask a Question
|
|
