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 only file (can’t change the attributes either). My backup 4-floppys won’t restore either, they get through two floppy disks and the restore process begins all over from start. Help!!!!! Steve
Answer:
I have a few possibilites to consider. First, the file that is telling you that it is read only, is it a .QBB file or a .QBW file? If it is a .QBW file, these cannot be restored, it is a working file...not a backup. The problem with your disks, may be that the files have gotten corrupted. I have seen this with floppy disks. I reccomend that you use a CD-RW Drive, ZIP drive, or a USB Hard drive...I see problems with these much less frequenly.
This is something that you may need Intuit's help with. They may be able to help you get the .QBW file and it other componants off your old hard drive.
Otherwise you may have to rebuld your 2004-2005 data...Not Fun.
Friday, July 01, 2005
Repayment of an Employee Advance.
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.
Joe
Answer:
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 raise!
To answer your question, there are two ways to go about this:
1. Set up a payroll advance item on his payroll check. This is probably the way to go if you give advances fairly frequently. QuickBooks Payroll should walk you through this. You may have already done this when you gave him the advance. If so, tell him to keep his money and then deduct the amount from his next paycheck...via the same item that you used to give it to him (just input it as a negative this time).
2. If payroll advances occur infrequently for your company, just use a journal entry to put the money back.
DEBIT - Cash/Checking
CREDIT - The account that you put the advance in the first place. (Usually, Payroll advance - Employee Name (a current asset account)).
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.
Joe
Answer:
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 raise!
To answer your question, there are two ways to go about this:
1. Set up a payroll advance item on his payroll check. This is probably the way to go if you give advances fairly frequently. QuickBooks Payroll should walk you through this. You may have already done this when you gave him the advance. If so, tell him to keep his money and then deduct the amount from his next paycheck...via the same item that you used to give it to him (just input it as a negative this time).
2. If payroll advances occur infrequently for your company, just use a journal entry to put the money back.
DEBIT - Cash/Checking
CREDIT - The account that you put the advance in the first place. (Usually, Payroll advance - Employee Name (a current asset account)).
Applying A/P Credits.
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 is go into the Pay Bills Screen (Vendors - Pay Bills), make sure that the button for show all bills is selected. Hopefully, you have a bill that shows up for the vendor and amount in question (One of the bills that your accountant adjusted). If so select that bill, and select "Set Credits". The negative amount that your accountant entered should show as an available credit. Apply that credit to the bill that he adjusted out and you should be set!
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 is go into the Pay Bills Screen (Vendors - Pay Bills), make sure that the button for show all bills is selected. Hopefully, you have a bill that shows up for the vendor and amount in question (One of the bills that your accountant adjusted). If so select that bill, and select "Set Credits". The negative amount that your accountant entered should show as an available credit. Apply that credit to the bill that he adjusted out and you should be set!
Undeposited Funds.
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 undeposited funds (This is where you are). The deposit step simply moves the money from undeposited funds to the respective cash account.
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 undeposited funds (This is where you are). The deposit step simply moves the money from undeposited funds to the respective cash account.
Tuesday, June 28, 2005
Vendors Entered as Customers.
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.
Thanks
Answer:
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 customer contact list (Reports - Customers & Receivables - Customer Contact List). This will give you most of the information that you will need to key from.
NOTE: QuickBooks will not let you use the same name to describe vendors and customers, so you will have to alter the vendor name slightly (you can let the company name be the same, just not the vendor name field). The easiest thing to do might be to add an ",Inc." to the end or something like this.
After you have entered all the vendors, go to the customer list (Customers - Customer: Job List) and right click on and make inactive all the customers that you have replaced in the vendor list. QuickBooks will not let you delete vendors/customers that have transactions (Which yours do).
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.
Thanks
Answer:
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 customer contact list (Reports - Customers & Receivables - Customer Contact List). This will give you most of the information that you will need to key from.
NOTE: QuickBooks will not let you use the same name to describe vendors and customers, so you will have to alter the vendor name slightly (you can let the company name be the same, just not the vendor name field). The easiest thing to do might be to add an ",Inc." to the end or something like this.
After you have entered all the vendors, go to the customer list (Customers - Customer: Job List) and right click on and make inactive all the customers that you have replaced in the vendor list. QuickBooks will not let you delete vendors/customers that have transactions (Which yours do).
Internet Banking.
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.
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.
Question:
I am the bookkeeper for a retail windows store. Over half of our
business is custom orders. Our profit and loss is not recording cost
of
goods sold on custom orders correctly because of this senario:
A customer orders windows at the end of the month. We record a sales
receipt. This goes into Accounts Receivable towards sales for the
month.
We order the windows from the vendor--creating a purchase order. After
about 10 days, the windows arrive and we create an item receipt. The
item receipt records into Accounts Payable and this puts the Cost of
Goods sold for this item into the month following when the sales were
recorded. I use the item receipt and bill features to track our
merchandise and billing with the vendors. I really don't want to
change the date after the billing is closed to throw the expense back to the
same month as the sales.
The best solution would be to have purchase orders post to accounts
payable and count towards Cost of Goods Sold--since the sale and the
order happen on the same day. Does anyone know if this is possible?
If not, does anyone have any ideas how I can get an accurate monthly
P&L?
Answer:
It sounds like you are using QuickBooks very well. Actually, one would argue that your financials are correct, even though they may not be as you would like them to be. According to accounting principles, you do not book a payable until you have possession of the merchandise that you ordered. So if the windows are being shipped FOB buyer, then you don't record the payable until the goods reach your dock. On the other hand, if the windows ship FOB seller, then you are liable when the windows ship. In any case the date most likely would not be the date you ordered them. Actually I believe QuickBooks is making the accruals properly, and the only way to change it would be to override the item receipt/bill date, which I would not suggest.
I am the bookkeeper for a retail windows store. Over half of our
business is custom orders. Our profit and loss is not recording cost
of
goods sold on custom orders correctly because of this senario:
A customer orders windows at the end of the month. We record a sales
receipt. This goes into Accounts Receivable towards sales for the
month.
We order the windows from the vendor--creating a purchase order. After
about 10 days, the windows arrive and we create an item receipt. The
item receipt records into Accounts Payable and this puts the Cost of
Goods sold for this item into the month following when the sales were
recorded. I use the item receipt and bill features to track our
merchandise and billing with the vendors. I really don't want to
change the date after the billing is closed to throw the expense back to the
same month as the sales.
The best solution would be to have purchase orders post to accounts
payable and count towards Cost of Goods Sold--since the sale and the
order happen on the same day. Does anyone know if this is possible?
If not, does anyone have any ideas how I can get an accurate monthly
P&L?
Answer:
It sounds like you are using QuickBooks very well. Actually, one would argue that your financials are correct, even though they may not be as you would like them to be. According to accounting principles, you do not book a payable until you have possession of the merchandise that you ordered. So if the windows are being shipped FOB buyer, then you don't record the payable until the goods reach your dock. On the other hand, if the windows ship FOB seller, then you are liable when the windows ship. In any case the date most likely would not be the date you ordered them. Actually I believe QuickBooks is making the accruals properly, and the only way to change it would be to override the item receipt/bill date, which I would not suggest.
More Problems Getting Reports Out of QuickBooks.
Question:
Hi CPA,
I received your blog site from a friend just in time. Having tried to use the QB help topics and customer service without any success, I was hoping that perhaps you would be able to help me with a current dilemma that I have. I am using QB Pro 2005 and have been unable to get a profitability statement that will satisfy the owners of the company that I work for.
They want a statement/report that shows each invoice separately with customer name, invoice number, amount, and % of profit provided for them on a daily basis. I have tried to explain to them that this ends up being a cut and paste operation which takes a great deal of time. I've used as many filters to get a report that will work but at this time it is still a culminative gathering of three different reports. I've tried to convey to the bosses that QB has it's limitations and gives the % of profit for Customers, not individual invoices, and that the % of profit will be figured out for the total amount of sales for customers with multiple invoices. Furthermore, I have tried to let them know that the only way that I would be able to get a profitability statement for every invoice would be to run them separately every time an invoice is generated, slowly me down considerably and I would still have to use the cut and paste method because I have been unable to manipulate any report showing a separate invoice number with % of profit on one report.
Is there an easier way to generate a report that would be close to what the bosses want?
Any suggestions would be appreciated.
Thank you for this blog site.
Answer:
May I say...Holy Crap. It seems that your bosses are very demanding, and may or may not be financially savvy (they may just like paperwork).
From your question I can tell that you have a very good understanding of QuickBooks and how to manipulate the reports to the fullest extent possible.
As far as I can tell you are doing everything that you can to please your bosses with tools that you have been given. The only way that you could fix it, is to sell your bosses on more comprehensive accounting software. I believe that even something as simple as QuickBooks Enterprise Edition (Click Here for information about reports) would give you this functionality. Depending on the size of your operation, something as powerful as Microsoft's Great Plains might prove to be a fantastic solution for your bosses (they could have as many reports as they could imagine...and all you have to do is hit print). Unfortunately, with greater capability comes greater cost.
Hi CPA,
I received your blog site from a friend just in time. Having tried to use the QB help topics and customer service without any success, I was hoping that perhaps you would be able to help me with a current dilemma that I have. I am using QB Pro 2005 and have been unable to get a profitability statement that will satisfy the owners of the company that I work for.
They want a statement/report that shows each invoice separately with customer name, invoice number, amount, and % of profit provided for them on a daily basis. I have tried to explain to them that this ends up being a cut and paste operation which takes a great deal of time. I've used as many filters to get a report that will work but at this time it is still a culminative gathering of three different reports. I've tried to convey to the bosses that QB has it's limitations and gives the % of profit for Customers, not individual invoices, and that the % of profit will be figured out for the total amount of sales for customers with multiple invoices. Furthermore, I have tried to let them know that the only way that I would be able to get a profitability statement for every invoice would be to run them separately every time an invoice is generated, slowly me down considerably and I would still have to use the cut and paste method because I have been unable to manipulate any report showing a separate invoice number with % of profit on one report.
Is there an easier way to generate a report that would be close to what the bosses want?
Any suggestions would be appreciated.
Thank you for this blog site.
Answer:
May I say...Holy Crap. It seems that your bosses are very demanding, and may or may not be financially savvy (they may just like paperwork).
From your question I can tell that you have a very good understanding of QuickBooks and how to manipulate the reports to the fullest extent possible.
As far as I can tell you are doing everything that you can to please your bosses with tools that you have been given. The only way that you could fix it, is to sell your bosses on more comprehensive accounting software. I believe that even something as simple as QuickBooks Enterprise Edition (Click Here for information about reports) would give you this functionality. Depending on the size of your operation, something as powerful as Microsoft's Great Plains might prove to be a fantastic solution for your bosses (they could have as many reports as they could imagine...and all you have to do is hit print). Unfortunately, with greater capability comes greater cost.
Monday, June 27, 2005
QuickBooks Error # 12029.
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!
Tom
Answer:
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 is your settings, a firewall, or your DSL connection itself.
The following link gives dome steps that you can take that will hopefully narrow down your problem.
Click HERE
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!
Tom
Answer:
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 is your settings, a firewall, or your DSL connection itself.
The following link gives dome steps that you can take that will hopefully narrow down your problem.
Click HERE
Subscribe to:
Posts (Atom)
