Can I move ONLY customers/transactions to new file?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Can I move ONLY customers/transactions to new file? ZenMasta 10-27-2009  Re: Can I move ONLY customers/transactions to new ... Laura 10-27-2009  Re: Can I move ONLY customers/transactions to new ... ZenMasta 10-27-2009  Re: Can I move ONLY customers/transactions to new ... Laura 10-27-2009  Re: Can I move ONLY customers/transactions to new ... ZenMasta 10-29-2009
Posted by ZenMasta on October 27, 2009, 2:10 pm Please log in for more thread options Hi, I have a very very outdated QB file with a bad chart of accounts. bad as in A) haven't been updated with transactions in almost 10 years B) some accounts are closed etc. Basically this QB company file was ONLY used for tracking customer AR, so invoices/payments/credit memos. Also if you look at the company snapshot it will show that there is all this money as income and absolutely zero expenses.... and obviously that's because of reason A as mentioned above. I created a new company file that has 2 bank accounts which are currently balanced and I would sort of like to start fresh. 1) Is it possible copy (or import) ONLY my customers and their transactions (invoices/payments etc) into my new company file... 2) Also will this screw up stuff?.as in, will payments customers have made affect the bank accounts I have setup? going back to the original company file it seems like payments from customers are put into a certain bank account. When we deposit customer checks we don't deposit each one individually but say a whole days worth at a time etc. If I open the bank account in the OLD QB file I see there is an individual entry for each check. In the new QB File (I download the transactions from our bank) so each deposite is going to show as one line item for the lump sum. I just updated the old QB company file from 2001 to 2010. Thanks for the advice. Posted by Laura on October 27, 2009, 3:25 pm Please log in for more thread options > Hi, I have a very very outdated QB file with a bad chart of accounts. > bad as in > A) haven't been updated with transactions in almost 10 years > B) some accounts are closed etc. > > Basically this QB company file was ONLY used for tracking customer AR, > so invoices/payments/credit memos. > > Also if you look at the company snapshot it will show that there is > all this money as income and absolutely zero expenses.... and > obviously that's because of reason A as mentioned above. > > > I created a new company file that has 2 bank accounts which are > currently balanced and I would sort of like to start fresh. > > 1) Is it possible copy (or import) ONLY my customers and their > transactions (invoices/payments etc) into my new company file... > > 2) Also will this screw up stuff?.as in, will payments customers have > made affect the bank accounts I have setup? > > going back to the original company file it seems like payments from > customers are put into a certain bank account. > > When we deposit customer checks we don't deposit each one individually > but say a whole days worth at a time etc. If I open the bank account > in the OLD QB file I see there is an individual entry for each check. > > In the new QB File (I download the transactions from our bank) so each > deposite is going to show as one line item for the lump sum. > > I just updated the old QB company file from 2001 to 2010. > Thanks for the advice. > > You can export/import your customer names but not the indiv transactions. You would need a 3rd party app to accomplish that. To export your customer list go to File>>utilities>>import/export. It probably makes more sense to just take the current file and manually enter this year's invoices and payments. When you apply payments to invoices post them to Undeposited Funds instead of the bank account. Then open the lump sum deposit from the account register. "Make deposits" will open the transaction. Hit the "paymentss" button and you see the payments received that remain in Undeposited Funds account. Select the appropriate payments and add them to the deposit slip. Now delete the original deposit line so that the amount of the deposit is unchanged from before. Now save the deposit entry. Do this until there are no payments in the Undeposited Funds account. -- Laura Posted by ZenMasta on October 27, 2009, 3:44 pm Please log in for more thread options Manually re-entering all of this years invoices and payments isn't an options. We're talking about thousands of transactions here. Fiscal year ends on October 31st. Is there another solution I can use to take advantage of that? > > > > Hi, I have a very very outdated QB file with a bad chart of accounts. > > bad as in > > A) haven't been updated with transactions in almost 10 years > > B) some accounts are closed etc. > > > Basically this QB company file was ONLY used for tracking customer AR, > > so invoices/payments/credit memos. > > > Also if you look at the company snapshot it will show that there is > > all this money as income and absolutely zero expenses.... and > > obviously that's because of reason A as mentioned above. > > > I created a new company file that has 2 bank accounts which are > > currently balanced and I would sort of like to start fresh. > > > 1) Is it possible copy (or import) ONLY my customers and their > > transactions (invoices/payments etc) into my new company file... > > > 2) Also will this screw up stuff?.as in, will payments customers have > > made affect the bank accounts I have setup? > > > going back to the original company file it seems like payments from > > customers are put into a certain bank account. > > > When we deposit customer checks we don't deposit each one individually > > but say a whole days worth at a time etc. If I open the bank account > > in the OLD QB file I see there is an individual entry for each check. > > > In the new QB File (I download the transactions from our bank) so each > > deposite is going to show as one line item for the lump sum. > > > I just updated the old QB company file from 2001 to 2010. > > Thanks for the advice. > > You can export/import your customer names but not the indiv transactions. > You would need a 3rd party app to accomplish that. To export your custome= r > list go to File>>utilities>>import/export. > > It probably makes more sense to just take the current file and manually > enter this year's invoices and payments. When you apply payments to invoi= ces > post them to Undeposited Funds instead of the bank account. Then open the > lump sum deposit from the account register. "Make deposits" will open the > transaction. Hit the "paymentss" button and you see the payments received > that remain in Undeposited Funds account. Select the appropriate payments > and add them to the deposit slip. Now delete the original deposit line so > that the amount of the deposit is unchanged from before. Now save the > deposit entry. Do this until there are no payments in the Undeposited Fun= ds > account. > > -- > Laura Posted by Laura on October 27, 2009, 5:17 pm Please log in for more thread options Yeah...start a new file as of 11/1/09 and start using the proper posting procedures. Fix your chart of accounts, etc and move forward. Just use the old file for the 2009 taxes in the state that is in. -- Laura Manually re-entering all of this years invoices and payments isn't an options. We're talking about thousands of transactions here. Fiscal year ends on October 31st. Is there another solution I can use to take advantage of that? > > > > Hi, I have a very very outdated QB file with a bad chart of accounts. > > bad as in > > A) haven't been updated with transactions in almost 10 years > > B) some accounts are closed etc. > > > Basically this QB company file was ONLY used for tracking customer AR, > > so invoices/payments/credit memos. > > > Also if you look at the company snapshot it will show that there is > > all this money as income and absolutely zero expenses.... and > > obviously that's because of reason A as mentioned above. > > > I created a new company file that has 2 bank accounts which are > > currently balanced and I would sort of like to start fresh. > > > 1) Is it possible copy (or import) ONLY my customers and their > > transactions (invoices/payments etc) into my new company file... > > > 2) Also will this screw up stuff?.as in, will payments customers have > > made affect the bank accounts I have setup? > > > going back to the original company file it seems like payments from > > customers are put into a certain bank account. > > > When we deposit customer checks we don't deposit each one individually > > but say a whole days worth at a time etc. If I open the bank account > > in the OLD QB file I see there is an individual entry for each check. > > > In the new QB File (I download the transactions from our bank) so each > > deposite is going to show as one line item for the lump sum. > > > I just updated the old QB company file from 2001 to 2010. > > Thanks for the advice. > > You can export/import your customer names but not the indiv transactions. > You would need a 3rd party app to accomplish that. To export your customer > list go to File>>utilities>>import/export. > > It probably makes more sense to just take the current file and manually > enter this year's invoices and payments. When you apply payments to > invoices > post them to Undeposited Funds instead of the bank account. Then open the > lump sum deposit from the account register. "Make deposits" will open the > transaction. Hit the "paymentss" button and you see the payments received > that remain in Undeposited Funds account. Select the appropriate payments > and add them to the deposit slip. Now delete the original deposit line so > that the amount of the deposit is unchanged from before. Now save the > deposit entry. Do this until there are no payments in the Undeposited > Funds > account. > > -- > Laura Posted by ZenMasta on October 29, 2009, 3:30 pm Please log in for more thread options *sigh, I can't believe google exposes my email address using this... anyway In regards to your other post about making the payments towards the deposits. That would be impossible for us to figure out at this time because because of the age. Dang, I was really hoping I could somehow avoid creating a new company file with starting balances for customers who have AR. But it seems like the only way :/ So, can you help me set up my company correctly? As I mentioned already, I have already created a new company file that has my two bank accounts (I migraded the bank account transactions from Quicken) so they are completely balanced as Monday. My current chart of accounts is Checking Account 1 - Bank Checking Account 2 - Bank Opening Balance Equity - Equity (starting balance for checking account 2 until I can manually enter the missing transactions) Retained Earnings - Equity (opening balance for checking account 1 from 2001 and then a blank transaction for each year to date after that) Uncategorized Income - Income (deposits from both bank accounts, in person at branch or electronic from our visa/mastercard merchant) Insurance - Expense (payments made from bank accounts to health and auto insurance vendors) What other accounts do I need to create in order to test importing customers and creating invoices/receiving payments from them? And what is the account type? Accounts Receivable (I see this listed as "other account types") Accounts Payable (I see this listed as "other account types") Undeposited Funds unsure of the type. What other accounts? Also, when I begin to create invoices for customers and receive payments. How do I tie the AR balance of the customer to the AR account I would setup, as well how would I tie the payment I enter as received to an account. credit cards are deposited into checking account 2 automatically within 24 hours. When I download transactions it is described as "Misc Credit Merch myaccountnum Deposit". When we receive checks from a customer they are usually deposited within a day or two and they appear as "deposit" Thanks. > Yeah...start a new file as of 11/1/09 and start using the proper posting > procedures. Fix your chart of accounts, etc and move forward. > > Just use the old file for the 2009 taxes in the state that is in. > > -- > Laura > > > >> Similar Threads Posted Move PO to Estimate or other way October 4, 2006, 10:22 am Move company data from QB99 to QB2006? November 2, 2006, 1:40 pm How to Temporarily Move Transactions from Accounts Receivable? November 4, 2009, 9:55 pm 829e206e error...lost connection to file, but file is on the hard drive!!! November 19, 2006, 7:26 pm file location April 4, 2007, 9:17 pm file save February 13, 2007, 8:14 pm NEW FILE UPDATE December 17, 2007, 10:54 am Portable File January 6, 2008, 11:29 am QB V5 QBW file disappears April 29, 2008, 4:13 pm Is there a QB file reader program? July 11, 2006, 3:39 pm