My State U/C percentage was incorrect for the first qtr of 2008. I printed a help page that said I had to go into each employee and create a payroll liability adjustment and also adjust the affected liability accounts. I can do this, but I also saw a note that stated the quickbooks will adjust my future payrolls to make up for the shortage. Does that mean that after the 2nd qtr, when the amounts have caught up, that I have to go back and reverse all the payroll adjustments that I made in the 1st qtr to each employee? Is there a easier way to do this until quickbooks makes my catchup amounts?

• LanceWilkins (Mar 29, 2008 9:48 am)

QuickBooks is going to look at payroll tax calculations on an annual basis. So, it will look at the total payroll for one employee for year to date and make the payroll tax calculation based on that. So, if I made an error in setup and an amount had been overclaculated in the past, QuickBooks will claculate less on the current payroll to try and make up for it.

So, the answer is no, if you make corections now, QuickBooks won't make an error that needs to be corrected next quarter. If it calculates the amount year to date and it is correct, it will make the correct calculation on the current paycheck.

How do you set up and track commissions to a salesperson based on job profit. Specifically, the salesperson receives a 30% commission on whatever the profit of the job is.
Can this be handled within QuickBooks or will we have to export to Excel and do the calculation that way?

• LanceWilkins (Mar 29, 2008 9:50 am)

This would require either manual or Excel claculation, probably off of the Profit/Loss by Job report.

I have a small business and I am new to quick books. I am a bit confused on the general journal, journal entry. I am trying to enter credit and debits from my banking statement , but not sure how to do it.

• LanceWilkins (Mar 29, 2008 9:52 am)

I generally use journal entries as a last resort to getting information into QuickBooks. I would click on the Check Register icon on the Home Page and make my entries that way. The form looks and works just like a paper check register and has columns for checks and deposits.

Accounts payable - bills paid through bill pay with a check and a bill credit - the amount paid by the credit still shows as open in the ap aging summary and the vendor balance summary for the amount of the credit. However, the bill does not show as open in the unpaid bills detail. It also does not appear in the "pay bills" window. In addition, the credit is no longer available. When we click on the bill we can see transaction history of the bill payment. However, when we pull up the bill credit it shows no transaction history. Under the bill tranasaction history it shows a balance due. The "balance due" is showing in the +30, +60 +90 days columns in the aging. We know all bills have been paid and, again, the unpaid bills detail verifies that.

I have tried to verify/rebuild data and receive a c=224 error.

Please advise.

Thank you,

Susan

I am going on vacation and need to run payroll the Friday before I go away for the next Wed. scheduled payroll. Can I run an unscheduled payroll on the Friday before without creating problems with my payroll liabilities? Thank you.

• LanceWilkins (Mar 29, 2008 9:59 am)

You could but you would have to edit your scheduled payroll setup as QuickBooks would show that payroll as delinquent and needing to be completed. You could just run the scheduled payroll and change the paycheck date in the screen where you enter hours.

I have a client that emailed me 2 qbx files, both as a portable file. One I was able to open and the either I can't. Once I create the working file and try to open it it tells me that the username or password is incorrect. I have spoken with the client and both companies have the same username & pw. Any suggestions?
Thanks

• LanceWilkins (Mar 29, 2008 10:04 am)

.qbx files are accountants review files and are different from portable company files. You cannot work with a portable company file the way you can an accountants review and send changes back to the client.

In either case, if you have problems with the user name, the first thing I clarify with the client is which letters are upper case and which are lower case. The password is case sensitive. I usually find that once I have the capitalization right, I can open the file.

I have some checks cashed from bank account in January 2008, but those are belongs to 2007 tax period. I have already reconciled my statements.
How do i make changes in the register to reflect them part of 2007 profit and loss?
If i change the date of transaction in register then, how will it be reconciled again?

• LanceWilkins (Mar 29, 2008 10:07 am)

You don't need to change anything. The transaction will occur in QuickBooks as of the date on the check not the date it was reconciled. The fact that the checks cleared the bank in 2008 will not affect the transaction in QuickBooks.

Hi Lance,

I updated our company's QuickBook Version Premier Small Business 2004 to Premier 2008 yesterday, I have yet to download 2008, I cannot decide which version of Premier is most compatible with the system I currently have. I do not want to incur problems when I merge the data. By the way this is a medical practice, one plastic surgeon.

• LanceWilkins (Mar 29, 2008 10:10 am)

You would probably opt for the Professional Services Edition.

we use quickbooks payroll. The employee center to pay our laborers who we treat as independant contractors for tax purposes. They receive a 1099 at the end of the year. We pay them weekly by the hour. We enter their hours on the timesheet. How can we not have the payrol checks be displayed as employee but independand contractor

• LanceWilkins (Mar 29, 2008 10:12 am)

They should not be employees. Set them up as Vendors in QuickBooks.

My question is probably an easy one, but I'm a new user, so it's tough to me. Why, when I want an A/R Aging Summary Report do customers with 0 balances in all columns still show up on the report?

• LanceWilkins (Mar 29, 2008 10:19 am)

My suspician is you have open transactions for those customers that result in a zero balance. Look at an Open Invoices report and see if this is the case. You can correct this by creating a zero payment through Receive Payments applying the credits to the open invoices.

Many years ago I wrote the Access database program to run my business. I want all records from the past including expense, income, contacts and payroll to all be moved to QuickBooks. Each record is a history of our business and are needed. How do I export from Microsoft Access to QuickBooks? - or worst of all I can't? No way can we afford the time and effort to do this manually. Neither can we afford to not have access to all our business records from one program. Thanks so much, Howard

• LanceWilkins (Mar 29, 2008 10:22 am)

I don't think this can be done. Your only hope is to loook for some kind of third party software at quickbooks.com that will format your Access data and import it to QuickBooks.

How can I add accounts to an existing budget?

• LanceWilkins (Mar 29, 2008 10:23 am)

If the account is on your chart of accounts, it should be available to create busget numbers.

Hello Lance,

There are a few of us who could really use your help. We are interested in knowing about invoicing customers for retainers. You can read the dilemma here - http://www.quickbooksgroup.com/webx/forums/accounts_receivable/InvoicingIssues/3285/3?50.

PLEASE HELP!

Thanks so much!
Kimberly

• LanceWilkins (Mar 29, 2008 10:47 am)

There really isn't space here to go into all the details of what the options might be, but I see your dliemma and wanted to reply at least briefly. There really isn't a way to do this that isn't labor intensive and a pain to do on a regular basis. Some of it you must be doing already though. I would assume you are using monthly journal entries to move amounts for each customer out of Unearned Revenue into Revenue.

You could give the invoice a later date, but I suspect that you would like the earlier date for generating customer statements and showing current amounts that are due.

The estimate form is another option. That has limitations as well since it makes things difficult for billing the customer.

This is not an issue that I have dealt with a lot, so if someone has a better idea, I'd love to hear it. But I know QuickBooks well enough to be pretty sure you are not going to get around the idea of multiple entries to move these balances around on a monthly basis.