Screenshots How to Buy
This program transfers list names and transactions from a QuickBooks file that has multicurrency turned on to a QuickBooks file that doesn't have multicurrency turned on. During the transfer all multicurrency information is removed from the list names and transactions.
Use this program if you primarily entered transactions in the home currency. The program doesn't translate any non home currency amounts to the home currency amount but you can manually change the amounts on any transferred non home currency transactions to the home currency amount.
This program is basically the same as our Data Transfer Utility program except that it has been modified to remove all multicurrency information from the transferred data. Video clips 1 to 3 at http://www.q2q.us/dtuvideos.htm are applicable to both of these programs and the web page at http://www.q2q.us/dtudatatypes.htm shows the types of data that can and cannot be transferred.
If transferring the data to a new file, create the new file by starting QuickBooks and clicking File>New Company and filling in the blanks as requested (you can skip the full interview). When asked to choose one of the canned charts of accounts, choose “No Type” and save the new file. When you create the new file it will not contain the following information. See the following paragraphs for comments on how to handle this information.
Open the new file and
a. Edit Sales & Customer Preferences and check the Company Preferences tab box labeled "Use Undeposited Funds as a default deposit to account". Then open and close the Receive Payments screen. This automatically creates the Undeposited Funds account with a special internal flag that identifies it as the real Undeposited Funds account. If you don't let QuickBooks setup the Undeposited Funds account, payments transferred will not show up the Banking>Make Deposits, Payments to be Deposited screen.
b. Open and close the Create Invoices and Enter Bills screens so that QuickBooks will create the accounts receivable and accounts payable accounts.
c. Set all the Preferences in the new file to match the Preferences in the old file. For example, if you collect sales taxes, turn on sales tax preferences. You will have to set up a sales tax item to complete this step. Also, if needed, turn on inventory tracking, units of measure, multicurrency etc. but don't turn on multicurrency.
d. Using QuickBooks, transfer any custom templates from the old file to the new file.
d. If you use QuickBooks Assisted Payroll, contact them about adding payroll checks to your file. Do this before adding any transactions to the new file.
f. In QuickBooks, click Company>Company Information and enter an email address if you will be importing any transactions marked "to be emailed. If you don't, QuickBooks will reject the transactions on transfer with a message that "the email address marked for this company is invalid".
g. Transfer all list names (accounts, customers etc.) from the old file to the new file.
k. Transfer all transactions (invoices, bills etc) from the old file to the new file. When transferring transactions, follow the sequencing recommendations in the "Transfer Strategies" document in the Help section of the program.
l. This program can't transfer tax liability and payroll checks. Tax liability and prior year payroll checks can be transferred using our Check Transfer Utility program from http://www.q2q.us/ctuoverview.htm . Current year payroll checks can't be transferred and have to manually recreated and/or entered using the QuickBooks year-to-date payroll adjustment feature ( if not using QuickBooks Assisted Payroll).
m. If any transactions didn't use the home currency in the old file, edit those transactions and change the amounts.
n. At this point the balance sheets and profit and loss reports in the old and new files should agree.
The steps below can be completed after you use the this program but they will be needed to fully complete the new file setup.
l. Setup users and passwords.
m. If you have employees, edit each employee and assign their earnings, taxes and deductions to them.
n. Edit customers and complete their credit card number. QuickBooks only transfers the last 4 digits.
o. Unfortunately QuickBooks does not provide any way to transfer multiple ship-to addresses. You can add these as needed or create an IIF file with a job for each ship-to address and import that file twice (once won't work). Then you can delete the un-necessary jobs but the ship-to's will still be associated with the customer. If you want to do this, send a request to firstname.lastname@example.org and we can send you a sample file.
p. Transfer the memorized reports.
q. Re-memorize the memorized transactions.
1. Pro or higher version of QuickBooks Pro 2009 and later or Enterprise Solutions 9 and later..
2. Microsoft Access 2000 to 2013 or the free Microsoft Access Runtime engine which can be downloaded from the "How to Buy" page.
3. Works with Win 2000, XP Vista, Win 7, Win 8.
QuickBooks is a registered trademark and service mark of of Intuit, Inc. in the United States and other countries. This program is designed for use with QuickBooks and Enterprise Solutions software only. (See the "How to Buy" page for more information)
Copyright 2010-2014 By Karl Irvin