Archive

Posts Tagged ‘QuickBooks Blog’

This Blog sponsored by our Learning Center

November 19, 2009 Leave a comment

The reason we are able to bring you this is our Learning Center. Visit The Learning Center NOW to download full length tutorials from 1 – 3 hours. Just add a class to your cart, make your payment and our website shoots you an e-mail with a link to download what you need to watch your video class.

Visit our Excel Blog also for great free excel help and information: MS Excel Guru

QuickBooks Tips & Tricks

June 4, 2009 2 comments

We have a new QuickBooks class in our learning center – QuickBooks Tips & Tricks.

This is a GREAT download whether you are new to QuickBooks or a veteran!

Today’s Question

The Question:

Hello Seth,

Need your advice –

we are sending out samples to our clients – most of the time free of charge or we bill a flat fee.
when entering these ‘sales’ in QuickBooks – what would be the best practice?

Our vendors in turn send us samples sometimes free of charge or bill us – whenever sample invoices come in we enter them in an cog account that is called ” samples” and “sample freight cost” –

I have temporarily setup a “sample income ‘ account that books to ‘sales’ would that be correct?

 

Here is the answer:

I would actually post an invoice or a sales receipt for the samples you send out (this way your inventory quantities are properly reduced), but enter a selling price of ‘0’ so there will be nothing due. In other words, when you send out samples, you are essentially selling them for ‘0’.

On other side, when you receive samples, you want to enter it the same way as you would for products you have to pay for (so that inventory Quantities are properly increased) but you will be entering them with a cost of ‘0’ and the items will carry whatever selling price they are set up for. If you have to create the item then of course you will set up the appropriate selling price.

If/when you do pay for samples, then yes I would book directly to cost of goods sold.

If/when you charge for samples (assuming they are not counted in inventory), then yes you can set up an item called “Samples” as a non-inventory part and then map it to the income account called samples. If they are counted in inventory then you invoice them as you would on any sale of products.



Ask Us

June 1, 2009 2 comments

Ask your questions by simply posting your comments here. Then we will post our replys and others can feel free to do the same if you think you know the answer.

QuickBooks File Types

May 30, 2009 1 comment

There are many ways you can work with a QuickBooks Expert. You can search for QuickBooks training resources online and of course you can hire us to help you. Once you’ve made that decision (and hopefully you’ve chosen us) we can work with your QuickBooks file in a number of ways.

Most e-mail servers will not allow attachments through if the size exceeds 10MB (megabytes). Some even limit you to 5. Because we are experts in both QuickBooks and Computers in general, we can really help you understand not just your QuickBooks file issues, but also how really work with your QuickBooks file in general. This is especially helpful in the context described here when you have hired a QuickBooks Pro such as myself and you want to be able to work with someone who can help you with QuickBooks and who also understands how to work with the file such that the integrity of your data is protected.

Here are the different QuickBooks File Types:

1) QBW – QuickBooks Working file.

This is the full fledged working copy of your file. This is going to be the largest in size; however as large file transfer services become more prevalent it is more common to send your QuickBooks file without even making a backup. For example on our Home Page http://www.nerdenterprises.com there is a link to a virtual drop box http://dropbox.yousendit.com/SethDavid766754 in which we encourage people to “drop” their QuickBooks file. Even the QuickBooks backup options described below create large files and so these services become helpful and even necessary. Visit http://www.yousendit.com for more info on the service we use.

2) QBM – QuickBooks Portable Company File (I don’t know where the ‘M’ comes from, seems to me it should be QBP)

When you choose to back up your QuickBooks file, the QuickBooks Portable Company File creates the smallest file size. The idea was to give it more transferability. This option takes the longest to create and the longest to restore. Based on what I’ve read from Intuit, it is also supposed to better preserve data integrity during transfer, however I have transferred many files over the years and more recently because of the yousendit service I have been transferring the complete QuickBooks file (QBW) and I have not had any problems yet. Nevertheless the options are there, so I talk about them for your benefit and so that you can decide which option is best for you. If you are very conservative and “worried” – this is the choice for you. My aim is generally at efficiency so in my case, this is not the best choice.

3) QBB – QuickBooks Backup

This is the old fashioned Backup file. I still like to use this one – especially when I transfer QuickBooks files frequently with clients as I often do. This enables me to maintain a history of the client’s QuickBooks file at various stages of my work. Oftentimes the nature of what I am hired to do for example is to completely re-purpose the Chart of Accounts. I will choose the option to append the name of the QuickBooks file with the date and time so that the files stack nicely in a folder that I often name “Old QuickBooks Files.” Usually I find that my frame of reference is in terms of when I did something to the file, so this makes it easy get to the right file.

4) The Accountant’s Copy

This enables you to work on your own file while your accountant works on it and the accountant’s changes can be imported. The way this works is that when you create the file, you have to set a dividing date. Let’s say you choose December 31. This will allow your accountant to change anything prior to Dec 31 while you can still enter and pay bills in your QuickBooks file. In the top title bar of the file you will see the words “Accountant’s Changes Pending.” This can work real well in many instances; however I have found it to be a bit buggy – especially where there are a lot of changes. My suggestion when using this is to import the changes frequently. The working copy can be released from the accountant’s changes in the event you do not need to import them. Also the accountant’s copy may be converted to a permanent QuickBooks working file (QBW). This is helpful if you haven’t made many changes, your accountant has, and if you are having trouble importing the changes.

Finally if you are stuck, you can send both files to Intuit (you have to call them) and they can fix this for you.

What about transferring from QuickBooks for MAC to QuickBooks for PC and vice versa?

Yes you can and have been able to do this since QB for Mac version 7, and QB for PC version 2007 (all editions, perhaps except for QuickBooks Simple Start).
It’s in the file menu under Utilities in QuickBooks for PC. In the MAC, I believe the choice is right there in the File menu so save a copy or save a backup copy for windows. Whichever direction you are converting you wind up with the equivalent of the “QBB” file. This of course has to be restored.

When you do round trip conversions, what will happen with your bank and credit card reconciliations initially is that it will look like the reconciliations were “undone.” All that has to be done is to go to reconcile the account, then enter the ending balance of the last statement that was reconciled in QuickBooks. You will see all of the previously “cleared” items come in checked off and your difference will be ‘0’. Just click ‘reconcile now’ and you’re done. When you are doing this, it is important to save your reconciliation reports as a PDF each time you reconcile (on the initial reconciliation, not on the round trip conversions). Please don’t waste paper – just save the PDF – you can print it only if/when you need it. Create a folder on your computer called “Bank of xxx reconciliation reports” and save them there. It’s easy and efficient.

More on this here: The Accountant’s Copy

Please feel free to reply to this post with any questions.

Seth David
President
Nerd Enterprises, Inc.
http://www.nerdenterprises.com

Why “The QBW?”

Well it may be obvious and then it may not. I came up with the name for this blog because every QuickBooks working file ends with the file extension “.QBW”. I thought it was pretty clever and was actually a bit surprised that it wasn’t already taken. The purpose of this blog is to have one place to provide an exchange of information about QuickBooks. I will post articles with helpful information on how to do things in QuickBooks and I will answer your questions. I may also use your questions as the basis for a web cast or even a full length QuickBooks class that I will make available for download in the Learning Center on our Main Site. I also will post information here about upcoming QuickBooks webinars. These are live online seminars that you can register for and get live help with me. I will have content prepared and I will also allow time for Questions and answers. I also may call an open forum where the entire session will be based on your questions, which you can either submit here or ask during the live webinar.

Please feel free to offer your suggestions for what you might like to see more of here. You’ll be helping me out and in turn I will be very happy to help you by doing everything I can to provide you with the answers you are looking for.

 

Thanks for visiting “The QBW”

Seth David

Welcome to the new QuickBooks Blog from Nerd Enterprises, Inc.

May 30, 2009 1 comment

Got QuickBooks questions? This is the place to ask them.

I plan on posting lots of articles about QuickBooks, how to use it better, and how to use it to make your business more profitable

Of course there will also be plenty of links to video tutorials as well and as always when you are ready for a full length tutorial, simply visit our learning center and download our classes there.