1. Home
  2. QuickBooks Discussions
  3. Can I move ONLY customers/transactions to new file?

Can I move ONLY customers/transactions to new file?

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.

Reply to
ZenMasta
Loading thread data ...

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.

Reply to
Laura

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.

Reply to
Laura
*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.

Reply to
ZenMasta

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.