QuickBooksBlog.com

Today's Tip - Changing what Prints on Paystubs.

2010-04-29T14:43:00.000-05:00

I received a question today from someone who wanted to adjust what prints on paycheck vouchers and pay stubs. Unfortunately you cannot add a bunch of information such as YTD hours worked (which is what he wanted). However, you can add or remove quite a bit. To adjust select "Preferences" under the "Edit" menu, and choose the "Company Preferences" tab of "Payroll & Employees". Then click "Pay

Today's Tip - Customize Quickbooks

2010-04-28T13:53:00.000-05:00

There are several ways that you can tweek Quickbooks to suit you. 1.) Do you want the "Home" screen to automatically come up when you open Quickbooks? Many like to work from this screen, I have never really adapted to it. To turn it off open Preferences under the Edit menu and select "Desktop View" on the left. Un-check "Show Home page when opening a company file" 2.) Another function I like

Federal Unemployment Problem - 501(c)3 Not-for-Profit

2010-04-28T08:29:00.002-05:00

Question:I am the volunteer treasurer for a non-profit (501(c)3) pre-school. I'm using QuickBooks 2008 with payroll.Everything was going just fine until the other day when an inactive employee was causing a Federal 940 payment to appear in my payroll liabilities. Being non-profit, we aren't subject to this tax and it isn't calculating the tax for the other two active employees. I went

QuickBooks Finance Charge Calculation

2010-04-27T14:56:00.002-05:00

Question:I am doing statements and the finance charge in Quickbooks doesn't match what my math says they should be. They seem slightly higher. Does QB go by the actual day or by month. I am going by month.Please Help! Answer:First of all I love the question. You Ma'am are an accountant! How many people would have just let the "computer" do the math. Um, just about everyone. "Trust but verify"

Today's Tip - Print your Signature on Checks

2010-04-27T12:15:00.000-05:00

In years past, I have had several clients ask if QuickBooks allows you to automatically print your signature on checks like all the big companies do. The answer is now yes! With the release of QuickBooks 2010, there is a new feature that allows you to print your signature on paychecks, bill payment checks, liability checks, and standard checks. If you would like to use this new feature, here are

I didn't get paid...Now what?

2010-04-26T14:03:00.000-05:00

I have heard over the last few years people have had trouble collecting money (read with the requisite amount of sarcasm). Question: How do you write of bad debt in QuickBooks? Answer: First make sure the Bad Debt account is set up. Many of my clients didn't know what a bad debt was until last year and therefore did not have an account for it. Next go to "Receive Payments" under the Customer

The Owner Bought a Plasma TV, What do I do with That?

2010-04-23T14:08:00.000-05:00

Question: The owner purchased a television on his company credit card for his uncle. A few days later the uncle sent a check for the price of the television. How should both of these transaction be recorded? Answer: You have no idea how many times I hear this question (not necessarily a TV but you get the idea). So let's talk about it. First of all, unless the TV (read also: bicycle, golf

Why are Payments in the Wrong Bank Account?

2010-04-23T12:31:00.000-05:00

Question: I run two bank accounts in Quickbooks. One was only active for 1 month, June 2009. I have invoices showing up randomly in that check registry. I have not used that bank account since June 2009 yet I have invoices showing up in that registry in Feb 2010. Any idea how an invoice would show up in the check registry? Thank you Answer: First understand that invoices don't post in the

Paying Contract Labor

2010-04-23T10:16:00.000-05:00

Question: Some employees are paid through on-line banking directly. I enter this transaction in QuickBooks as a General Journal crediting the bank and debiting the Contract Labour account. When the person asks for a print out for the previous year I cannot get the information to come up. I click on Company, Chart of Accounts and Contract Labour. In Contract Labour I click on Modify,

Help to Find Invoices.

2006-08-30T17:33:00.000-05:00

Question:Is there any way to search for a specific invoice without having to click through every invoices to find the one you want?Answer:Yes, QuickBooks has made it very easy to locate invoices. Simply open the “Create Invoices” screen and right click on any of the open white space (not on a field). Then select “Find Invoices…”From here you will be able to search by customer/job, date ranges,

No Questions?

2006-08-22T13:18:00.000-05:00

I haven't received any questions for a while, so everything must be going well.Here is something to waste time while looking productive. (Just make sure your sound is off)Thanks to American Express for providing such a great advertisement.By the way, American express business cards integrate nicely with QuickBooks software. Amex business cards also come with "OPEN for Business" which gives you

Bank Account Problem.

2006-07-20T16:05:00.000-05:00

Question:When I go to write a check, the balance does not match the ending balance in my check register for the same account. Where should I look for the discrepancy?Answer:My first question is…are you reconciling your bank account monthly? (Banking – Reconcile)If not you should be. This is the most effective way to ensure that your bank account balance is accurate.Another thing that you can do

Check Printing Options.

2005-09-24T08:52:00.000-05:00

Question:I was just given new blank paychecks to use - they already have the company name/address above the 'pay to the order of' section. The previous ones did not. How do I format in qb2005 contractor’s ed. the check printing so that it does not reprint this information over the pre-printed information? Please help!!Answer:When you select print paychecks and the print dialog box opens, there

Emailing Invoices.

2005-09-16T16:05:00.000-05:00

Question:To email invoices and statements do you have to purchase something additional besides having QuickBooks premier?Answer:No, QuickBooks Premier includes this function for invoices and statements.To email invoices, find the invoice you are interested in so that it is on the screen. On the menu bar next to print, there is a button that says "Send". Click "Send" and follow the

Backup Problem.

2005-09-16T15:53:00.000-05:00

Question:I have backed up a company file to a cd. It won't open because it says it's a read only, change file to read-writable. I can't figure out how to do this-- please help! Need info on new computer. Thanks, HarriettAnswer:When you do a back-up in QuickBooks, it creates a .qbb file (for QuickBooks Backup) the working file uses a .qbw extension (for QuickBooks Working file). Many people have

"Slightly" Forgotton Password.

2005-09-16T12:12:00.000-05:00

Question:Help! Is there any assistance for retrieving a slightly forgotten password on QuickBooks? thanks!Answer:First I would try everything to remember my password (try using all of your other passwords).If after exhausting this process you still cannot remember your password, then you will have to have QuickBooks remove it for you.Here is a link to their Password Removal Service.Even though

Reimburseing Employees.

2005-09-16T12:03:00.000-05:00

Question:I am very new to QuickBooks, but I have to ask this question.How do I record a payment to an employee when that employee submits an expense report for expense he incurred on behalf of the company. Mileage or office supplies for example. Is the employee just a vendor just like any other. Thanks. Carol in Augusta MaineAnswer:In this case, your employee is in essence a vendor. However, if

Bank of America Problem

2005-09-16T11:52:00.000-05:00

Question:I have several independent accounts set up in QuickBooks Pro 2004. I have been connecting to my bank via QuickBooks and downloading processed checks.Recently, I got the message, “Your last on line connection was not completed. QuickBooks is having a problem recovering from this condition. Please contact Tech Support for on line banking. I don’t get this message with all of my accounts

A/P Problems.

2005-09-13T13:36:00.000-05:00

Question:When I enter bills, it has a section at the top that says a/p account. It’s beside the bill/credit section. Is this supposed to be there? Whenever I enter the bill to the vendor whatever is in that a/p section is what prints in the check register as account monies to be paid from.How do I fix this? Answer:To your first question, yes this is supposed to be there. Some companies use

Faxing Invoices.

2005-09-13T13:18:00.000-05:00

Question:I just bought a laptop in hopes that I could work while I was traveling. Our business (manufacturing custom mantels) requires that I fax invoices to certain builders but I do not know how to do this from my laptop. I have qb2005, please help! ThanksBrendaAnswer:Unfortunately, QuickBooks does not have a mechanism that will allow you to fax directly from the program. You can however

Windows ME Compatible?

2005-09-13T12:56:00.000-05:00

Question:Can you tell me whether QuickBooks Pro 2005 - PN 284456 is compatible with Windows Millennium Edition - I've heard yes and no and really don't want to upgrade my operating system .Answer:According to the QuickBooks website, 2005 is not compatible with Windows ME...So I would be leery of installing on that machine. I had a machine a few years ago with ME on it, and I had considerable

Tracking Expenses.

2005-09-13T12:23:00.000-05:00

Question:Hello,I am starting a new company in the Portland, Oregon area. www.stainlesscablesolutions.com it is a stainless steel cablerail in fill company that uses sailing hardware and cable for decks interior and exterior.I have quicken Premier and I can not figure out how to put my expenses into the program. It has bills on a cash basis or accrual but I do not know how to put just expenses in

Recording SBA Loan distributions.

2005-08-15T07:49:00.000-05:00

Question:I am in the process of opening a smoothies business and have secured a $150,000 SBA loan. The way that SBA works is that you (over a period of several months to 1 year max) take out disbursements to pay for your startup costs (including equipment, fees, tenant improvements, inventory, etc). The disbursements can be in uneven succession ($200, $40,000, $3583, etc). For the first year

Help Needed.

2005-08-12T15:26:00.000-05:00

Question:Hello, I sure hope that someone can help me. I'm using QuickBooks Pro 2001. My problem is that: in my (Item Listing List) I set it up to automatically type a sentence (the body text of an invoice) that corresponds with a certain number in the item field in an invoice. For example: by typing in 01. example text, 02. example text, 03. example text...appears in the DISCRIPTION field. But

Help Needed.

2005-08-12T15:08:00.000-05:00

Question:Help! We are and aerial survey company and we give volume discounts on certain products and I cannot see a way in QB2005 Pro to set up volume discounts or any discounts with arbitrary controls tied to the item not the customer. To be specific, we give a discounted per negative charge based on the number of units sold. We also have an up charge per negative for high altitude photography

Printing Bank Information on Checks in QuickBooks.

2005-08-12T14:55:00.000-05:00

Question:I'm having trouble getting my bank account and routing number to print out on my checks. Is there a certain way to enter this?Answer:Unfortunately, QuickBooks will not let you print the bank information on blank check stock or plain paper. If you want to print checks with QuickBooks you will need to order checks from Intuit or some other supply company that offers QuickBooks formatted

READ THIS POST - Applying Credits.

2005-08-12T14:29:00.000-05:00

Question:I am new at QuickBooks. The A/P department before me had entered some credits on different vendors. Why does the credit show on the vendor unpaid detail list. Were the credits entered incorrectly?Answer:This is a common problem. I was discussing this with someone the other day.The problem is that when you enter a credit...or issue a credit memo QuickBooks will show the amount in the

Entering and Paying Bills.

2005-08-09T14:22:00.000-05:00

Question:Thanks for your answer, perhaps I am trying to do the wrong thing here. What I need to do is show the invoice numbers of each invoice I am paying along with the amount on the voucher. I typically pay 3 or more invoices to a vendor with one check. Is there a way to do this?ThanksAnswer:I must have misunderstood. What you seek to do is definitely possible. (However, the invoice information

Printing Memos on Check Vouchers.

2005-08-08T21:41:00.000-05:00

Question:I’m using QB pro 2005 and printing voucher checks for bill paying. I fill in the memo field, not the one on the picture of the check but the lines below in the register portion after the account and amount. When my checks print the memo information does not print. Is there a way to do this? I cannot find one.Thanks for your help,Answer:As I understand it, the memo that is on the face of

Trouble Emailing Invoices.

2005-08-08T20:59:00.000-05:00

Question: I wonder if you can help me. Twice a month I need to e-mail my invoices via QuickBooks Basic 2004. Sometimes the invoices go right out without a problem. Usually, however, I encounter various error messages and most often the whole QuickBooks program gets kicked off and shut down before it even connects to the QuickBooks server. I have to try over and over and over to get my

I Lost the Installation CD.

2005-08-08T20:44:00.000-05:00

Question:I have a new computer and would like to install QB’s on the new laptop. Unfortunately, I’ve lost the installation CD. Is there anyway to install QB’s from one computer to another w/out the installation CD? ThanksAnswer:I know that there is a way to transfer all your old programs from your old computer to your new one with a crossover cable (Assuming both your old and new computer have

Merging Files.

2005-08-07T14:37:00.000-05:00

Question: Help! I have 2004 info on one computer while 2005 data has been entered on another. I want to merge the two without overriding any of the data. Let me explain further;I have some 2004 info on one computer and prior data from 2004 and before as well as 2005 data on another how can I merge the two without overriding and destroying it? Please let me know if you can help ASAP. If this

QuickBooks Wants to do an Update.

2005-08-05T12:30:00.000-05:00

Question:I had lost my networking but now it is reconnected but when I go to get into my QuickBooks it tells me to update my QuickBooks, I have to turn off QuickBooks and it will reset itself. I do not understand what it is asking for. PLEASE HELPAnswer:Without seeing it, it sounds like QuickBooks has detected the internet through the LAN and has determined that there is an available update.

Using Classes for a Balance Sheet.

2005-08-05T11:33:00.000-05:00

Question:Can I get a completely "classed" out balance sheet? I have two stores (classes) operating off of one set of QuickBooks. The P & L classes out fine, but the balance sheet doesn't. I class my expenses when I enter them as a bill into A/P. Many of the bills are split between the classes. When the bill payment check is written, it doesn't reflect the change in the checking account by class

Networking Question.

2005-08-05T11:20:00.000-05:00

Question:The computer we have our quickbooks on is networked to others using windows xp pro peer to peer networking. That computer serves many tasks, and sometimes we have to arm wrestle for access time to that station. What would be involved in accessing quickbooks from another network computer? Only one person would need access to quickbooks at a time. Do I need to buy a second copy of

Tracking Inventory.

2005-08-04T18:42:00.000-05:00

Question:I work in a body shop that is having trouble with it's inventory. I thought I would try doing it on my QuickBooks 2004. Problem is, (maybe I'm just not doing this right) when we buy from our supplier, a lot of times it is a box or case of something, but when counted on hand for physical inventory, we count by the piece.Example:Box of scuff pads (20 per box) cost is $20.00 or $1.00

Using an Accountant's Reveiw Copy.

2005-08-04T18:12:00.000-05:00

Question:Does QuickBooks or any of their preferred providers offer the ability to Synchronize multiple QuickBooks files? For example – if a client sends a QuickBooks disk to us, his accountant there are now 2 files. The client makes changes to his file by writing checks or booking deposits. We, the accounting firm, make changes to our file by writing journal entries. Is there any way to

Emailing Invoices/Statements.

2005-08-04T13:35:00.000-05:00

Question:I have a customer who uses QuickBooks pro 2003, they have 3 accounts one is the administrator. When the email icon is clicked on the administrator account to send an invoice/ statement...not very familiar with QuickBooks here.....then it sends, but on the other users accounts it just freezes after being clicked until escape is pressed twice, I’m off to see this customer at 1:00pm here

Writing Off Bad Debt.

2005-08-04T12:44:00.000-05:00

Question:I have taken over the office for a landscaping company whose internal books are all over the place. We still show outstanding receivables from as far back as 1998. How do I handle these in QuickBooks? My assumption is to void the ones we cannot collect on to remove them from the receivables list, but I am wondering how to keep track of the non-collectibles in a report. Thanks in

Lost QuickBooks Installation Code.

2005-08-04T11:37:00.000-05:00

Question:I am a senior citizen who makes a little money doing bookkeeping for friends. I bought QuickBooks pro for Mac 2004 last year and have now got around to installing it. I cannot find the installation codes or the receipt. Naturally QuickBooks will not help me. Any ideas? I remember it cost me around $200.00 and I hate to waste the money. I also have done a lot of work on it.Answer:Usually,

Prepaid Taxes.

2005-08-03T12:21:00.000-05:00

Question:I have a client who deposits estimated federal and state amounts periodically. I took over an existing chart of accounts which shows the estimated tax deposits under "Other Current Assets". The procedure is that she has a certain amount withdrawn automatically from her business checking which goes into a special Savings. From that Savings she deposits (automatically) the estimated taxes.

QuickBooks Version 5.0 & Windows XP.

2005-08-02T17:51:00.000-05:00

Question:We have QuickBooks Version 5.0 for Windows which will load on 3.1 or Windows 95. I have been trying to load it from the original installation disks onto a new computer which has windows XP. So far, NO luck. Can anyone offer any suggestions? Has anyone else dealt with this problem? We are a very small church and cannot see paying Intuit $199.00 per year for a schedule E disk to update

New Computer.

2005-08-02T16:36:00.000-05:00

Question:I just bought a new computer and used my Quickbooks Premier Retail Edition disk to add Quickbooks to it. However, I have no idea how to get my data from my old computer to my new one. I would like to use a flash card (I think that's what it called). Help! JanetAnswer:You simply need to make a backup on the old computer (File - Backup). Select the flash drive. QuickBooks should tell

Help Needed!

2005-08-02T16:26:00.000-05:00

Question:Hi, Has anyone had a problem with Quickbooks Pro running after installing XoftSpy (anti - spyware software). I get the error message described below. The answer I get from XoftSpy is : "We do not interfere with QuickBooks. QuickBooks has its own autoupdate feature to keep itself up to date. I would go into QuickBooks and check the Check for Updates. It brings up a window which will

Emailed Invoices.

2005-08-02T16:06:00.000-05:00

Question:If you send an invoice via email through Quickbooks, is there anyway to go back and view/print the message you sent to the customer?Answer:I am not aware of any way to veiw them once they are sent unless you can get them through your sent email folder. In the future, you might CC yourself into the emails so that you will have a copy.

Refund After Taxes Were Prepared.

2005-08-02T15:44:00.000-05:00

Question:How do I adjust an amount for a prior year? For example: I bought a fax machine in 2003 and then I returned it. However; in 2004 I got a refund for the machine but I didn’t adjust the office supplies account in 2003 and the taxes have been filed. I would appreciate a tip on how to handle this kind of transaction.Answer:The following answer assumes that you are on an accrual basis.

Lost Password.

2005-08-02T14:45:00.000-05:00

Question:A client of mine is locked out of QuickBooks and no one knows the password used when originally set up. Any way to access database to change password?Answer:Check out this post.

Is QuickBooks Right for a Wholesale Distributor?

2005-08-02T11:39:00.000-05:00

Question:I am looking for the best software solution for my company. My (new) accountant likes QuickBooks. My old accountant (now ex) had our company's accounting totally "un-integrated". Accounts receivables in Maccola which I despise since most reports must be generated thru Crystal (ugh!). Accounts Payable, Payroll and G/L are run in QuickBooks but for some reason I can't understand it's

Posting A/P & A/R entries.

2005-07-30T22:05:00.000-05:00

Question:My name is Greg and I am a Business Manager for a non profit. Our year goes from July 1 to June 30 and our full year audit is due today. I went to post the year-end journal entry and quickbooks is telling me that a customer name must be provided on this split line entry. I am confused and getting frustrated. Any advise or help would be greatly appreciated.........Answer:Anytime that

The FAIR TAX - Finally a Solution to our Income Tax System.

2005-07-29T14:51:00.000-05:00

I have been an avid listener to the Neal Boortz show, I also make it a point to read "Neal's Nuze". He has done a great job over the last few months explaining how the travails of our current tax system can be fixed by the "Fair Tax." Through my experience as a CPA, I have seen both low income and high income taxpayers for lack of a better word...screwed by our tax system.With a consumption tax,

Customer Insurance Payments.

2005-07-29T14:07:00.000-05:00

Question:We are an insurance company and are setting up QuickBooks for the first time. In some cases the insurance company we are placing the business with will not accept customer check. We write the insurance company a check and the customer writes us a check. We are unsure how to enter these transactions into QuickBooks as they are not income or expenses. They just wash each other out. Thanks

NetSuite Conversion. Help Needed!

2005-07-27T17:15:00.000-05:00

Question:We are converting from QuickBooks to Netsuite. Is there an easy data transfer program so that we do not lose all of our previous data?Answer:I am not aware of anything designed for this purpose...Is anyone else aware of something?Netsuite is a big time accounting package, so I am sure that they offer a conversion service. However, with any of the big time accounting software packages

Cougar Mountain Sucks!!

2005-07-19T20:59:00.000-05:00

Question:We are a small company (9 employees) that does amazing business! We currently use Cougar Mountain Software and we all agree on one thing: it BITES! We are interested in converting to QuickBooks. However, it took the owner of our small company 6 weeks to convert us to CMS! Needless to say, she is not too interested in that process again. Is there anyway to convert easily? Do you

Changing Classes for Many Transactions.

2005-07-19T20:51:00.000-05:00

Question:Hello, I am going through the tedious process of reclassifying several posted expense accounts from one class to another. There are multiple entries in each category. Is there a way to "select all" or "fill down" and change class without opening each entry and laboriously changing class one by one. This client has 300 entries a month and I am working back from January due to her decision

QuickBooks Data Loss Problem.

2005-07-01T15:36:00.000-05:00

Question:I had a win 95; QuickBooks 4.0 computer which crashed. I’m trying to restore my 4.0 and the company data to a win 98se computer. I am able to copy the QuickBooks 4.0 with no problem, but the one data file that I am able to restore successfully, is current to only 2003. The other two files (one of which is my more current data file) won’t allow me to copy it because it says it’s a read

Repayment of an Employee Advance.

2005-07-01T15:20:00.001-05:00

Question:I gave an employee an advance to his pay via check (not through payroll)He now wants to pay it back but I am not sure on how to enter this part of the transaction.JoeAnswer:First of all congratultions, its rare to see an employee who wants to pay back an advance. The question I usually get is how do I set up a garnishment on their payroll check to get my money back. So give the guy a

2005-07-01T15:20:00.000-05:00

Applying A/P Credits.

2005-07-01T15:07:00.000-05:00

Question:When my accountant makes general journal adjustments to correct AP account for checks not cashed for the year I end up with a bill with a negative amount and a bill with a positive amount listed on my bills to pay window. When making the journal entries the vendor is noted with each AP entry. How do I get these entries to cancel each other out?Answer:The first thing that you need to do

Undeposited Funds.

2005-07-01T14:56:00.000-05:00

Question:When receiving a payment that is sitting in the undeposited funds account, how do you then assign to the correct income account when making the deposit?Answer:The income account is not determined when you record deposits. The income account is chosen when you create the invoice (each item is assigned an account). When you receive the payments, the A/R is cleared and the amount is put in

Vendors Entered as Customers.

2005-06-28T14:47:00.000-05:00

Question:I’m a brand new user of Quick Books. I have vendors set up in my customer list. How do I delete them from the customer list and put them in as vendors? There are transactions on log for them because they are vendors.ThanksAnswer:Hopefully, you haven't entered very many of vendors as customers, because you are going to have to re-key all of them.The best thing to do, would be to print a

Internet Banking.

2005-06-28T14:42:00.000-05:00

Question:I have 3 different bank accounts and would like to transfer the Debit Card transactions into the check register I went to internet banking to sign on and received an error page..Answer:Unless I am missing something, you need to check with your bank's technical support.

My Payables are Not Posting Properly.

2005-06-28T14:19:00.000-05:00

Question:I am the bookkeeper for a retail windows store. Over half of ourbusiness is custom orders. Our profit and loss is not recording costofgoods sold on custom orders correctly because of this senario:A customer orders windows at the end of the month. We record a salesreceipt. This goes into Accounts Receivable towards sales for themonth.We order the windows from the vendor--creating a

QuickBooks Error # 12029.

2005-06-27T13:36:00.000-05:00

Question:I have upgraded to quickbooks basic 2005. I cannot recieve updates, quickbooks gives me an error #12029.I can connect to the internet with internet explorer. I am using Windows XP and DSL.Thanks!TomAnswer:The quickbooks error that you speak of means that QuickBooks is unable to reach the internet. To resolve, you will need to find the problem with your internet connection...whether it

Help Needed!

2005-06-27T13:28:00.000-05:00

Question:When I pull up a P&L and go into the transaction detail by account I see several duplicates. Some are credits and some are charges. There are as few as 2 and as many as 9. Any ideas as to what the problem is or how to remedy it? Also, how can I print a customer list for specific dates and a chart of accounts for only one class? Thanks for your help!Answer:I'm not sure I understand..

Buying and Selling Property Business in QuickBooks.

2005-06-27T12:56:00.000-05:00

Question:I buy and sell property. I cannot figure out how to set up the following scenario:I contract to purchase a lot for $20,000 with a $1000.00 deposit and a 60 day close& issue the $1000.00 checkDuring the 60 day close period, I contract to sell the lot for $25,000.00 to a different party.The close on the purchase is the same date as the close on the sell - after signing the docs at the

Fixed Assets and Depreciation.

2005-06-27T10:32:00.000-05:00

Question:I need to book an asset that wasn't booked in Quick Books, instead the payments that were made every month is being directly entered into the asset account. My depreciation is not being deducted every month. What is the correct way to book these assets?ThanksCharmaineAnswer: Without knowing numbers and circumstances, I can't really tell you how to straiten up what you have. So let me

Using Financial Statement Designer.

2005-06-24T17:17:00.000-05:00

Question:It appears that the new Financial Statement Designer program (QuickBooks 2005 Accountant Edition) does not allow you to prepare Budget vs. Actual or Budget Performance reports. These reports are available only in the Reports menu. Is this correct? Are there templates that can be downloaded from the website? Perhaps this can be customized in the FSD program but I am not seeing it?Ps.

Help Needed! QuickBooks Problem on Tiger OS

2005-06-24T13:27:00.000-05:00

Question:I operate on a Powerbook G4 and recently installed Tiger. Since then, when entering a transaction in QuickBooks, I am not allowed to record, but have to scroll across the top to edit then click and click again before I am allowed to record the transaction. I am using QuickBooks Pro 6.0. Do you have any suggestions?Thank you,

Setting up Your Beginning Balance Sheet.

2005-06-24T12:32:00.000-05:00

Question: 1. What is the proper way to record fixed assets (our building and land) that we already own when setting up QuickBooks?2. Is there anyway to show appreciation of fixed assets?BillAnswer:When you set up quickbooks for a business that is alraedy in operation, it is important to get all the opening balances in correctly. This is why I usually advise clients to begin using quickbooks at

Inventory Aging Report.

2005-06-23T14:07:00.000-05:00

Question:I’m getting the feeling that this one’s beyond the scope of what QB is designed to do, but I’ll give it a shot.Is there any way to get QB (either internally or by a 3rd party app) to create an inventory aging report? I’ve been told by one 3rd party vendor that it can be done as long as we track things by lot or serial #, which (as far as I know) we haven’t done to date. It seems to me

Manufacturing Inventory.

2005-06-23T13:44:00.000-05:00

Question:Do you know anything about manufacturing with QuickBooks for Mac? Currently, I convert raw material inventory to finished product inventory via inventory adjusts and “zero” bills. But is there any add-on program or tricks I haven’t thought of to create BOM and/or inventory/manufacturing projection?Answer:QuickBooks does not have a very good process for manufacturing inventory. To be

Help Needed!

2005-06-23T13:33:00.000-05:00

I am exporting report data to sheet1 of a workbook, and trying to link sheet 1 data to a more comprehensive report in sheet 2.using copy-paste-link. When I change the date range in QB and export to sheet1l sheet 2 has #REF..... What am I doing wrong????? Thanks for any help... JohnThis sounds more like an Excel problem. I can't think of anything that would cause

Opening a Mortgage Account.

2005-06-22T16:22:00.000-05:00

Question:What is the proper way to enter a mortgage (initially) and make payments so that it reflects on the Balance Sheet?Thanks, BillAnswer:Well, a mortgage is in most instances a long term liability. So if this is the case, create a new account (Company - Chart of Accounts - Ctrl + N). Enter the account number if you use them. Make the account type Long-Term Liability. Give the account an

Sorting Bills by Due Date.

2005-06-22T15:31:00.000-05:00

Question:I have QBooks Basic 2004 Windows I can't sort a unpaid bill report by Due Date ----- nothing happens. HELP !Sid Answer:You are not the first person to bring this up. This repost I believe is fundamentally flawed in that it breaks the bills down by vendor FIRST. So when you sort by due date it will only sort multiple bills to the same vendor. Unfortunatly the report you are looking for…

Problem with Customer Balance.

2005-06-22T15:17:00.000-05:00

Question:I recently posted a payment through the Receive payment window. Somehow I got the amount in the system twice because when I go to my receivables report, it is showing up a negative balance due. I have tried repeatedly to change the payment, delete it, etc. I always get an error message that I have to delete it from the deposit before I can delete the payment. I go the deposits and delete

Balance Sheet Problems.

2005-06-22T14:38:00.000-05:00

Question:I have having problems creating an accurate balance sheet. I have used QB for several years but, I have not needed to create balance sheets with it. Unfortunately, now I do.Under current assets, all of the amounts showing up with the exception of National City Bank should be zero. How do I eliminate these amounts?The accounts payable should be zero. How do I eliminate this balance?

Changing the QuickBooks Invoice Templates.

2005-06-22T14:09:00.000-05:00

Question:I am using a QuickBooks template for my company invoicing, and I want to change the font, add my company phone number, Which I have put on the original template but it does not print on the invoice. I also want to change the size of the columns on the invoice template?Answer:QuickBooks doesn't allow you much flexibility when you are using one of their predefined templates. However, if

Applying Payments

2005-06-22T14:00:00.000-05:00

Question:How do you mark several invoices paid that were made as one deposit in the checking acct?Answer:If you have deposited funds, and the invoice is not marked paid, then you have not properly applied the payments.To apply payments, right click on the invoice screen and select "Receive Payments". Select the customer and fill in the screen accordingly...applying the payment to the correct

I Deleted a Transaction...I Need it Back.

2005-06-22T13:52:00.000-05:00

Question:I accidentally deleted a reconciled split deposit. I know the amount but is there anyway I can get the split details back? I am using QuickBooks Version 2000.Answer:If you delete a transaction (instead of voiding it) then it is gone forever. Unless you have a back up for that time period that includes that deposit. If you do have a back-up, you can restore it using a different file name

I Don't Have My QuickBooks Password.

2005-06-22T13:37:00.000-05:00

Question:For a variety of reasons, I have purchased a new computer. The sales team dutifully transferred my files to the new hard disc. However I learned that I could not start QuickBooks on the new drive without re-installing the program. I have now installed my old QuickBooks Pro 2003 but my account will not open without entering the password. As far as I know, this would be the password I

Duplicate Deposits in the Check Register

2005-06-22T13:22:00.000-05:00

Question:Found your blog site and thought I would get advice,1- Our small co. has a duplicate deposit that it seems QuickBooks will not allow me to delete from the QB check registry2- Three of the first deposits were made, however still show in the undeposited funds, when we try to remove them they end up as deposited again, thus the balance of the registry doubles the original deposit.QB

Trouble with Backup.

2005-06-22T13:16:00.000-05:00

Question:When I attempt to back up my company to cd or floppy I get a message that I do not have permission to open the file and that I must get permission from the owner or administrator. I am the owner/administrator and have set my self up in set users as such complete with password. I can only back up to my hard drive. Any suggestions?Answer:First log on with the user mane "Admin" and the

Recording Merchant Fees.

2005-06-22T13:08:00.000-05:00

Question:How do I account for merchant card fees if my processor deposits sales into my bank account after discount fees?If I receive a $400 payment for services from a customer and deposit $400 in QB's but my bank received $392, it doesn't reconcile. I use to have the whole amount deposited from my previuos merchant provider and would just write a check for merchant expenses they billed each

Rental Business Sample File.

2005-06-22T12:58:00.000-05:00

Question:I am new to QB and was wondering if you know of where I might find asample company file for managing rental property or other resource forsetting up QB for Rentals? Thanks in advance, SarahAnswer:I am not aware of a place where you can get sample files...other than the ones included with QuickBooks.If you want to practice with a file, you can use the service based business sample file

Tracking Salesman Commissions.

2005-06-21T16:08:00.000-05:00

Question: Specifically, we are interested in automatically generating commissions for sales reps associated with a given invoice and setting up the system to notify that a commission is payable based on entry of payment received in the system. Basically, when I enter an invoice into the system can I link each line item to a specific sales rep at a specific commission rate? Answer: This one is

Saving to Pay the Tax Man.

2005-06-21T15:12:00.000-05:00

Question:When using QuickBooks basic for Mac, can I transfer money between accounts- such as transferring money form checking to savings? Can I do this as a historical transaction? As a contractor, is there a recommended method, or account, to set aside money for quarterly taxes? I currently am using a savings account. Is there a recommended method for taking money out of payments from invoices

Help Needed!

2005-06-20T22:16:00.000-05:00

Question: I have the need for a listing (that I can export to excel) of all transactions that impact an invoice, showing the date of the item, item description, amount, AND INVOICE NUMBER. Something that would look like this: Date Item Description Amount Invoice Number 6-1-05 Payment 40.22

Tracking Manufacturing Profitability.

2005-06-20T21:19:00.000-05:00

Question:Need some help with how to set up my sales receipts? I make shirts for dogs. I buy the material, make the shirt, and then sell the shirt. I can't figure out which item to use in the sales receipt column. The closest I can come to is inventory part, but that really isn't accurate. I need to be able to track the material expenses for each shirt too. I looked up in the help & support, and

Sending a Deposit with a Purchase Order.

2005-06-20T18:31:00.000-05:00

Question:Is there a version that will allow me to make partial payments on a purchase orders? I am a manufacturer’s rep. When I send the manufacturer a PO, I must also send a 50% deposit with the order. In other words, if the PO is for a $2,000 sofa I must send a deposit payment with the PO for $1,000. Therefore, I need to track partial payment on POs as well as see the credit and balance due

I'm Back!

2005-06-20T18:21:00.000-05:00

Sorry, I have been away so long...it has been a crazy week. It's not supposed to be this way after tax season. I will be posting as many questions and answers as can.

Deleting Memorized Transactions.

2005-06-14T21:41:00.000-05:00

Question:How do you delete memorized transactions?Answer:Go to the "Memorized Transactions List" (Banking - Memorized Transactions). Highlight the transaction that you are SURE you want to delete by clicking on it once. Hit "Control + D" or select "Edit" - "Delete Memorized Transaction"

Help Needed.

2005-06-14T21:32:00.000-05:00

Here is a question that I have never delt with...maybe you have some ideas.I changed my service item list, and want to export this from QB to the Timer. I have tried this both from the timer to do an import, and from QB to do an export. Either way, the dialog box does not contain any file that appears to be the service item list. Starting with the timer, the only iif files are actually my

Changing Currency... Can it be Done?

2005-06-14T21:20:00.000-05:00

Question: I’m trying to print an invoice, and the final total is shown with a Euro symbol instead of a $. Where can I set the currency type? I can’t find anything under preferences that affects this. I would like to be able to switch back and forth, as I deal with contracts in different countries. Thank you Answer: In the QuickBooks versions that I have used, you cannot deal with different

My Font Size "Magically" Changed.

2005-06-10T15:56:00.000-05:00

Question: I turned on my computer this morning only to find that all my settings had been “magically” changed overnight. When opening QuickBooks, the font displayed on my desktops is about a size 8. Every place that I found to change the font already shows it being at my original default setting of size 11. But that’s not what is displaying. I did a couple virus scans and restarted my

Tracking Groups of Funds in "Super-Classes"

2005-06-10T15:39:00.000-05:00

Question: I'm looking at the books of a non-profit that has over a dozen funds they need to track. It would be nice to create a class for each fund. It would be nice to have a super-class of similar funds, so a report could have columns like these: Operating Fund Endowment - Unassigned Fund Endowment - Assigned Funds - This column would contain a total of numerous "sub-class" funds

My Backups are Using Too Many Disks! (Condensing Data)

2005-06-10T14:53:00.000-05:00

Question:How can I limit my number of disks needed for daily back ups. I started with one and now I am up six. What is the procedure? Or should I just keep adding disks? Answer: Here are a few suggestions to your problem: You can condense your data. If you have many years of transactions in your company file, then you can remove those transactions...leaving only the general ledger entries. The

Help Needed!

2005-06-10T14:41:00.000-05:00

Question: I work with Africa for Jesus, a non-profit missionary org., and the Office Manager and I are having a problem with our QuickBooks information. We are under the Non-Profit Navigator section of QuickBooks 2004 ed., and in inputing the support monies under donations (sales receipts), the totals are showing up in the deposits (which they should be) in the check registry, AS WELL AS

QuickBooks Enterprise Solutions 5.0 vs. QB Enterprise Solutions, Accountant's Edition.

2005-06-10T08:36:00.000-05:00

Question: What is the difference between QuickBooks Enterprise Solutions, Accountant's Edition ($849) and QuickBooks Enterprise Solutions 5.0 ($3,500)? Thanks for your help! Answer: As I understand it, the accountant's edition is a single license version of the software. The regular Enterprise Edition includes the ability for up to 10 simultaneous users.

Finally Help Importing .IIF Files.

2005-06-09T22:08:00.000-05:00

To further prove that we have the smartest readers on the internet, our readerAmos solved his own problem with importing .IIF files. Which seems to be a common problem. He points us to a QuickBooks support site that deals with this issue. Click here for the site. I hope you find it helpful, and thank you Amos for the tip.

QuickBooksBlog.com

Today's Tip - Changing what Prints on Paystubs.

Today's Tip - Customize Quickbooks

Federal Unemployment Problem - 501(c)3 Not-for-Profit

QuickBooks Finance Charge Calculation

Today's Tip - Print your Signature on Checks

I didn't get paid...Now what?

The Owner Bought a Plasma TV, What do I do with That?

Why are Payments in the Wrong Bank Account?

Paying Contract Labor

Help to Find Invoices.

No Questions?

Bank Account Problem.

Check Printing Options.

Emailing Invoices.

Backup Problem.

"Slightly" Forgotton Password.

Reimburseing Employees.

Bank of America Problem

A/P Problems.

Faxing Invoices.

Windows ME Compatible?

Tracking Expenses.

Recording SBA Loan distributions.

Help Needed.

Help Needed.

Printing Bank Information on Checks in QuickBooks.

READ THIS POST - Applying Credits.

Entering and Paying Bills.

Printing Memos on Check Vouchers.

Trouble Emailing Invoices.

I Lost the Installation CD.

Merging Files.

QuickBooks Wants to do an Update.

Using Classes for a Balance Sheet.

Networking Question.

Tracking Inventory.

Using an Accountant's Reveiw Copy.

Emailing Invoices/Statements.

Writing Off Bad Debt.

Lost QuickBooks Installation Code.

Prepaid Taxes.

QuickBooks Version 5.0 & Windows XP.

New Computer.

Help Needed!

Emailed Invoices.

Refund After Taxes Were Prepared.

Lost Password.

Is QuickBooks Right for a Wholesale Distributor?

Posting A/P & A/R entries.

The FAIR TAX - Finally a Solution to our Income Tax System.

Customer Insurance Payments.

NetSuite Conversion. Help Needed!

Cougar Mountain Sucks!!

Changing Classes for Many Transactions.

QuickBooks Data Loss Problem.

Repayment of an Employee Advance.

Applying A/P Credits.

Undeposited Funds.

Vendors Entered as Customers.

Internet Banking.

My Payables are Not Posting Properly.

More Problems Getting Reports Out of QuickBooks.

QuickBooks Error # 12029.

Help Needed!

Buying and Selling Property Business in QuickBooks.

Fixed Assets and Depreciation.

Using Financial Statement Designer.

Help Needed! QuickBooks Problem on Tiger OS

Setting up Your Beginning Balance Sheet.

Inventory Aging Report.

Manufacturing Inventory.

Help Needed!

Opening a Mortgage Account.

Sorting Bills by Due Date.

Problem with Customer Balance.

Balance Sheet Problems.

Changing the QuickBooks Invoice Templates.

Applying Payments

I Deleted a Transaction...I Need it Back.