2020/11/02

Copy Multiple Transactions From One Company File To Another

Transferring Transactions in one QuickBooks File to some other one.

There is no built-in function to transfer transactions from one QuickBooks File to some other one (alternatively: Batch Enter Transactions feature in QuickBooks Accountant and Enterprise), but there are lots of tools available for sale that facilitate this technique, one of them are the immediate following:

Transaction Pro Importer & Exporter 6.0 by Bay State Consulting
Transaction Copier by Big Red Consulting
Data Transfer Utility by Karl Irving CPA (FEATURED HERE)
At some point, i am going to compare and contrast them four, nevertheless the time being i’ll show you Data Transfer Utility (DTU) because it is quite simple to utilize.

First you open within the QuickBooks file from which you wish to bring transactions from (Source), then load DTU which will appear such as this:

Observe that DTU will be based upon Microsoft Access, which means you will need to have it installed in order to put it to use. Should you not have Access, you can easily download a totally free Access Runtime Engine through the Microsoft website.



Step 1, click on ADD/CHANGE when it comes to source file, you're getting the familiar window asking you to definitely grant use of DTU to get into the QB file:

Step 2, click on CHANGE under “Select kind of Data to Export”, that will take you to definitely this screen:

In the bottom right, you will observe: “Pass 1, Pass 2, Pass 3, and Pass 4”, because it is recommended which you import certain items to be able and 4 passes are recommended to transfer an ENTIRE QuickBooks File. For example: Pass 1 transfers all the Lists, Pass 2 transfers most of the transactions except Deposits, Bill Payments and Customer Deposits, Pass 3 will bring only Bill Payments and Customer Deposits, and Pass 4 Brings Deposits.
Related Post: https://accountinpro.blogspot.com/2020/11/copy-multiple-transactions-from-one.html

Why this way? It is to avoid errors from linked transactions.. you Must first have an invoice, then payment, not only that a deposits; if it comes down in out of order it breaks. Hope which makes sense to you.

Anyway, i am going to do an easy example and just bring BILLS and BILL PAYMENTS. Which means that i would like 3 passes.

First, Pass 1: Vendor List. Click on Pass 1, Clear All, then just pick the Vendors and Vendor Type

Click on Close Form, Click on ALL DATES and Then on EXPORT DATA.

Then, switch up to the Destination QuickBooks File, then in DTU, head to OPEN DESTINATION COMP, it's going to ask you to grant access to the File in QuickBooks, and after you agree return to DTU and then click on IMPORT DATA

You can find error messages about setting up an organization e-email address, turning on sales tax, and multiple units of measure.. if it is the case, go right ahead and stick to the instructions to make it work.

Following the import is complete, you are able to click on 6c. VIEW IMPORT are accountable to inspect how it went, and find out if any errors occurred in the procedure.

Perfect… the on to Pass 2: Bills. In DTU click on CLOSE CONNECTION, plus in QuickBooks Switch back once again to the foundation Company File in, and back in DTU go to CHANGE under Select Data to Export, Click on Pass 2, Clear All, then just choose simply the bills.

Then you click on Close Form, and click on EXPORT DATA. Note: Every Bill, Item Receipt, and Vendor Credit from the same vendor will need an unusual reference number! Karl makes a free of charge add-on utility that automatically adds numbers to blank ref number bills.
Also Read: https://accountspro.weebly.com/blog/copy-multiple-transactions-from-one-company-file-to-another

Anyway, now we are ready to import the Bills, so we repeat the same steps from before, switch back our QB company file to the destination file, back in DTU click on OPEN DESTINATION COMP after which IMPORT DATA

Assuming that your Chart of Accounts in addition to Items list provides the exact ones being used here, then you would be OK. Or even, go back to PASS 1, and make sure the Chart of Accounts and Item List is roofed for the reason that import. Same goes if you are job costing with Customer names or Using Classes. This should all be section of that PASS 1 we had been discussing earlier, if not there will be ERRORS throughout the importing.

At the end , you should see a report without any errors, similar to this:

And Lastly, Pass 3: Bill Payment Checks and BillPayment Credit Card Charges:

Stick to the same steps in export and import the data.. and you should be finished.

Now, it is possible to pull a transaction detail report on both company files to make sure 100% can add up.

If numbers are OFF, then these has been a mistake message during the import/export process and it was ignored.

If you want to Copy Multiple Transactions From One Company File To Another please contact our experts.

So, what do consider this utility?

Cons: The interface is a but hard navigate for first timers working together with Karl Irving Tools, you will find lots of error checking which makes the user believe that the process takes forever.

Pros: The interface is consistent with other Karl Irving Tools, so its not too difficult to obtain familiar with. The error checking on this system is phenomenal, nothing is more frustrating than importing 99% associated with the data.. because almost always you need to start all over again anyway even for a susceptibly “measly” 1% variance.

All and all, i love this tool quite definitely, I have used if it for a couple of projects. it offers a $169 price tag which is among the most inexpensive searching for so it does.

Karl, has working demos of almost all his tools at q2q.us, and that means you are welcome to try it yourself.