Get your toughest QuickBooks questions answered! Find out what's new in QuickBooks 2008!
Join us for an "Ask the QuickBooks Expert" event featuring Joe Limmer from JCL Accounting Services LLC. Joe is a QuickBooks Advanced Certified Professional Advisor and a member of the Intuit Accountants Speakers Bureau!
***This event is closed. You will not be able to ask questions but you can still read the posts.
Question:
New non-profit set up Oct 27, 2007 06:55 am
Hello Mr. Limmer:
I am going to set up our very small church accounting system. Will quickbooks work? I recently went to a clergy tax seminar and the speaker mentioned that quickbooks doesn't work as a church accounting program as it doesn't "mirror" the IRS chart of accounts. What does that mean?
A large part of this answer depends on what information you are trying to keep in QBs.
I'm aware of many churches that use QB's to keep track of contributions, other income, and expenses. The COA can be modified in QBs to set up new accounts to mirror IRS requirements, if necessary.
Because of the special tax situation with clergy, payroll could be a tricky setup but I believe it would be possible. I don't specialize in church accounting, so I won't dispute your speakers comment. I will suggest you talk with other churches in your area. Many QB's users are more than happy to share info (pros & cons) with potential users.
Also check the QBs website for ProAdvisors in your area who may specialize in church accounting. They could give you some straight answers.
Previously, if you had Premier Accountants edition you could open any other version of a QB file and work with it, as long as it was the same version (i.e. 2006, 2007, etc).
With 2008 Intuit has increased the flexibility of this feature. With 2008 an accountant can not only work on 2008 files and return them to the client but by using an Accountant's copy you can make changes to 2007 data files as well.
This saves the hassle of opening a separate version for to work on files of clients using 2007.
Question:
Can I enter and keep track vendor invoices to be paid in Simple Start Oct 27, 2007 07:23 am
Hi Joe,
I am new to Quickbooks and just got the Simple Start Free edition. We just opened an internet business and we sell some products that we purchase from another company. We receive invoices from this company with terms of net 30. Can I use Simple Start to keep track of these invoices, their due dates and pay them?
Question:
certified Pro. Advisor Oct 27, 2007 07:32 am
Joe,
I have been looking into other company websites that are in my field, and found several that say they are certified. I have recently graduated college with an Accounting degree and have used Q.B. in both class and a business that I have.
Where would I go to find out about becoming an advisor, What is involved, and about how much time would be involved in learning about it?
One other question, I have just recently installed the '07 version on to my computer, and was trying to make a backup copy on to a CD using the wizard. The trouble came when I clicked on burning the CD now, and after that was locked into the screen that asked if I wanted to burn it now or later. The buttons at the bottom were greyed out, and I was unable to exit that screen in any way possible. I finally had to just turn off the computer itself. I have never had a problem like that before. The message was of a pop-up nature that prevented from closing by the red x button in the top right, and all ways as well.
I do like the ability to e-mail customer billing for my clients though, and have had some good feed back on it. Thanks, Henry
Regarding your backup problem, it sounds as if the problem was with the "burning" program. Once the copied to your computer for burning, QB relinquishes control to your operating system. If it only happened one time, it could have been a system "fluke". If it continues to happen, verify your data file to make sure everything is straight.
Question:
Invoicing for services provided Oct 27, 2007 07:41 am
I am a building owner having 300 customers who rent office space from us. In addition we provide services such as administrative, fax transmission, copies, postage, etc. We just got QB's 2008 and I would like to know how I can invoice our customers for these services once a month and keep track of all of this in Qb's.
You will need to setup your customers as vendors. A slight variation in their name will be necessary. For example, placing a "v" before the name of the vendor record will work in QBs and it helps keep you from becoming confused when working with these files.
With a vendor for your customer, you can now invoice them for any services you provide. The drawback? You're dealing with 2 sets of accounts/paperwork for each customer.
There is a procedure for "swapping" or netting services with your customers. It it more complex and requires additional accounts to set up. I apologize but I can't find my file (yes, I have those days) or I would send you a copy with this post.
Question:
Payroll/Multiple states Oct 27, 2007 11:07 am
Hello,
I am a self made booker and not exactly saavy at it. Where can I find information about setting up state withholdings if our employees work it 2 states? Also, I hope I don't have to create 2 paychecks for each employee, 1 check for each state? Please advise.
I hate to be the one to break the news but you answered your own question. QBs will not handle multiple state withholdings with Basic, Standard, or Enhanced payroll.
I believe the Assisted Payroll can handle this situation. Contact the Sales Dept. at (877) 683-3280 to verify this info.
Is there a way to send an email batch to certain customers? I have them identified by type and would like to send everyone of that type the same email message
Question:
INVOICING PROBLEMS Oct 27, 2007 06:14 pm
When I set up the invoicing last year, each invoice/account receivable automatically set up as a new job. We are a job based organization and the invoicing (so far) has only applied to the job of "Program Ads" but I ended up with about 40 new jobs, the titles of which were the people who owed us money. How do I set up the invoices so that they will apply only to accounts receivable for the "Program Ads" job and not automatically create all those new jobs? Thanks for any help you can offer.
I have to apologize because I don't understand what you are trying to do. Usually when you bill different individuals/companies, they are your Customers. You then have Jobs associated with each Customer.
It sounds to me as if you have set up a Customer called "Program Ads" with associated Jobs that just happen to be your customers. This would occur if you attempted to invoice each client under the Customer, Program Ads.
Without further clarification, I can't determine what you are trying to do and how to correct the situation. Please discuss your setup with your accountant or a Certified ProAdvisor in your area before you get too far along.
Question:
Matching historical online Bank Transactions with Bills/ Invoices Oct 27, 2007 06:27 pm
Hi,
I am new to QB and QB Pro2008. I am entering my company's historical data from January 2007 onwards. First I created the chart of A/C with bank info, invoices for customers and then bills for the utilities,rent and other vendors{Jan-Oct,2007}. Then I downloaded the bank statements and categorised the data. But now, I see that the bills are pending and the checks for each vendor also went through. How do I map it ? When I run a expense report for the vendor it shows double the actual amount. It is the same for the customer deposits too. How do I resolve this?
Thnx,
GS
When using the bill payment feature in QBs, you must first create the bill payment check to tell QBs which bills you are paying.
The download from your bank only works on the reconciling side of the system. In other words, when you download the data from the bank, it must match an entry already in QBs or it gets entered as a check when you add it to your register to simplify reconciling. The bank data never relieves the bills in A/P. Here is the procedure that should have been followed:
1) Create COA's and add beginning balances.
2) Enter the invoices and bills (if you are planning on using the Bill Pay feature). If you are not going to use Bill Pay, don't even enter the bills.
3) Receive payments against invoices and make deposits.
4) Again, if you're going to use Bill Pay, pay your bills using the original check #'s and dates.
If you're not going to use Bill Pay, skip this step completely.
5) Now download your bank data. QBs will match as many deposits and Bill Payment checks as it possibly can. You will need to add the other checks and "categorize" them.
If you are not using Bill Pay, you will have to add and "categorize" all the checks coming from online banking.
6) Reconcile your bank account.
I hope I didn't confuse you with this long-winded response.
I need to enter a check that is a deposit to commence ordering by the vendor on a P.O.
When I enter the "Write a check" section and select a vendor that has an open PO, a dialog box pops up that asks if I would like to receive against the PO. The answer is no because I have not received anything but if I say no, it will not connect the dots so to speak. Help
Not so laughable. PO's belong to a group of non-posting accounts, therefore, you can't post a prepayment against a PO.
I haven't been able to figure out a way to do this, other than to receive the PO with a future date. But...this could get real messy, real quick if there is any volume of prepayments outstanding. I wouldn't recommend it.
Hopefully, another ProAdvisor monitoring this sight will have a solution for you. If I hear of anything, I will forward it to you.
Many thanks to all who submitted questions/problems this week. I'm sorry I was unable to answer them all but the numbers were overwhelming.
For those I couldn't get to, please contact a Certified ProAdvisor in your area for help. There are many very knowledgeable ProAdvisors waiting for your call.
Use the ProAdvisor locator on the QuickBooks.com website to find someone near you.