Learn how to customize QuickBooks for your industry! Esther Friedberg Karp from Compubooks Business Services will be here to answer your toughest QuickBooks questions!
Esther is the author of QuickBooks LearnOnline, a QuickBooks Certified ProAdvisor, and a member of the Intuit Accountant Speakers' Bureau!
***This event is closed. You will not be able to ask questions but you can still read the posts.
You will have to create a Sales Receipt, but since I am guessing that you make deposits more often than once a week for your retail operation, you should do that every day.
The sales receipt should total to $0. You enter the items to reflect all your revenue accounts, sales taxes collected, and then create separate payment items that link to Undeposited funds to reflect cash/debit/check/visa/mc/amex etc. You probably don't put every penny you collect during the day into the bank the next day - there are differences for float variations, etc. So make an item that is linked to the Float account as well. That's where the difference (either positive or negative) between funds collected and funds deposited will go. You should be reconciling your float the same way you would reconcile any bank account.
Question:
Setting up new items for invoicing Dec 07, 2007 07:37 am
I have version 2008. I have been using 2004 and set up different item descriptions for my invoices, and I input the amount free form. When I tried to set up item descriptions in 2008, the software wants me to have a pre determined amount for the item description. My item description is basically "custom jewelry" and each piece is charged differently based on product cost and labor. Is there a work around in 2008 that will let me NOT set a standard price for the item description?
Question:
Purchase Order to Estimate Dec 07, 2007 07:40 am
I use a purchase order as a "price" request for lets say a custom door. Once I have received the price from my vendor is there a way to convert the purchase order into an Estimate/Proposal?
Not sure - try right-clicking on the folder in which the QBW file is located and see if the message is correct that it's read-only. Change it. Do the same thing with the file itself, and any folders that sequentially contain the folder housing the file.
Question:
Colorado Sales Tax Calculation Dec 07, 2007 10:41 am
Greetings
I am completing my sales tax for the city of Colorado Springs which has a sales tax rate of 2.5%. My return is very simple for the month of November....nothing special. Quickbooks and I come to the same taxable dollar amount of $7373.90. However, when I use any of the 4 calculators I have avalible to me to figure the taxes I should send to the city, I come up with $184.35 (7373.90X.025) .... Quickbooks on the other had comes up with $185.86. This is not a big $$$ difference for me, but it points to a possible calculation and software error in Quickbooks. Its straight forward multiplication.
Please contact me for supporting documents.
Thank You
Doug
Double-click and open each sales transaction including credit memos. Check the calculations. My guess is that there was an item with a negative number that was not taxable. OR, it's a rounding issue on a bunch of invoices. If it's the negative item, see if that needs to be made taxable. If it's a rounding thing, assuming the sales tax % is set up correctly in QB, you'd go with the QB number.
I manage the purchasing department and distribution warehouse for our company.
After we make a sale, I want to be able to create and print pick tickets for our warehouse workers with the following information:
Physical location of items in the warehouse
On-hand quantity of the items
Before printing, I also want to be able to sort the pick ticket by warehouse location so that items in close physical proximity in the warehouse are next to each other on the pick ticket.
You can create a custom field for location, and you can get that to print on an invoice. However, I'm unaware of being able to print the qty on-hand on the invoice.
From what I've seen, it can read the data files but you should look at the page listed above to see if there are any other considerations that would hinder the transfer of info.
Question:
Not for profit customersw Dec 08, 2007 06:53 pm
Hi Esther,
I am setting up the books for a not for profit organization. We have members who pay a fee, and people who donate to the organization. How do I keep the two "customers" separate. What I want to do is print a separate list of members and donors.We also sell some merchandise, and I want to keep the total income for this separate. I guess this means that I have at least three types of customers. Help!
I would use "customer types" so that when you want to print a customer list of Type A, you can filter for Type A and memorize the report with that filter and appropriate report title. Ditto for Type B.
Hello,
We are investigating QB as a replacement for Deltek FMS. We are a mechanical testing and balancing firm which fits in more with a professional services firm although we are in the construction field. An important feature for us is the contract backlog, (the balance on the contract not billed out). Is this a report available in the professional services version?
Also the ability to bill against a contract, bill time and expenses, phased contract, etc.
Also, any advise on Premier vs Enterprise?
Thanks
You could run a "Job Estimates vs. Actuals" Summary or Detail report to see the unbilled amount (i.e. the $Diff between Estimate and Actuals already invoiced). You can also bill time and expenses and % contract and you can do reports on what has yet to be invoiced.
Premier vs. Enterprise - see the chart on the following site:
Question:
Show total quantity on income statement Dec 08, 2007 07:06 pm
I am looking for a report that will show the total quantity of an item that has been sold in a given period of time. The custom reports do total the amount sold and show the quantity, but not the total quantity of a given item. Any suggestions.
Question:
check i entered for deposit is not showing Dec 08, 2007 07:07 pm
I entered a check to pay an invoice and that went through fine (invoice showing paid) however when I go to make a deposit it is not showing in the deposit.
My guess is that when you did the "Receive Payment,it already went directly to the bank in question. In your preferences (Edit/Preferences/Sales & Customers/Company Preferences), you need to have the checkmark in the box next to "Use Undeposited Funds as a default deposit to account"...