Copy Multiple Transactions From One Company File To Another

 Copy Transactions Between QuickBooks file

How multiple transactions are copied from a single company file to a different ?

Solutions we will provide is useful for the 2014 version of QuickBooks or other newer version for the transactions listed below:

• Cheques
• Credits and Charge Card charges
• Deposits
• Credit and Invoice Memos
• Bill Credits and Bill
• Ensure that you try this process on accountant’s copy if transaction date is before dividing date.

Related Post: https://accountspro.weebly.com/blog/copy-multiple-transactions-from-one-company-file-to-another

1. Step One: Preferences must be set appropriately so that you can allow export

• Disabling the Account Number’s usea
• Go to Edit menu and then click on Preferences
• Choose Accounting and then tap in the tab of Company Preferences
• Ensure that checkmark is removed from Use account numbers and then click on OK
• Disabling the Sales Tax
• Go to Edit menu and then click on Preferences
• Choose Sales Tax and tap regarding the tab of Company Preferences
• Now into the area of Do you charge sales tax, select No and then click on OK

2. Step Two: Creating the report of Custom Transaction Detail

• Go to Reports menu and then choose the Custom Reports after that tap on the Transaction Detail
• Click on the Customize Reports and then result in the modifications in report as given below:
• Select desired date
• In Transaction Type, choose the transaction type which you want to keep
• In Detail Level choose all except summary

Then pick the columns in relation to the transaction type:

• Cheques/Checks
• Cheque Number
• Date
• Name of the Payee
• Debit Amount
• Memo
• Account
• Deposits
• Name
• Date
• Account
• Cheque Number
• Memo
• Credit Amount
• In order to run report, click on OK
• Make sure report is memorized by both you and you may want to save it by means of PDF

3. next step: Exporting the are accountable to the excel

• Keep carefully the report open and then go through the drop down of Excel
• Choose Create New Worksheet
• Then choose in a new workbook and then tap on Export
• Copying information from a single company file to the other one
• To copy information from a single file to another:

Go right to the current data file and then tap on File and then Utilities from then on on Lists. Choose the lists you are willing to be copied on New Data File, keeping the Chart of Account’s exception at heart, will work on it in next thing. Then find the place for which you wanted to save the file and also add the name for the file by applying the extension of IIF.

The in the current data file of yours, tap on File and then through the company file this is certainly existing, choose New Company. After typing the brand new Company Name, click on Create Company. This way, Chart of Accounts will undoubtedly be copied excluding data in New Data file. The info accounts might be deleted only at the moment, so ensure that the changes that you simply are willing to made are done during this period.

From then on obtain the New Data File opened and then go through the File then on Utilities then on Import and after that on IIF files. List that has been exported by you, will get copied with no balances. You can easily manage important computer data at this stage, by deleting those items, vendors and customers that you do not need any longer.

Here, you must have the information of New Company entered here, for example Business number etc. now in the setup, you will get the opening balances added. Remember never to go into the opening balances in the Accounts Payable and Accounts Receivable. To be able to create balances, be sure that Vendor Bills and Customer Invoices are created in New Company only.

Issues or Questions that Users face

Perhaps you are using QuickBooks Pro since long-time as a sole-proprietor. For example, you incorporated your account in 2015 and today your bank account is advising one to create the new Company File. Chart of Accounts is going to remain same using the Owner’s Equity as an exception being replaced using the Share structure.

What you need to understand is that whether you will be able to copy the present sales data and customer list to the new file. You want this because, you will not want to re-enter the consumer addresses of past years as well as all of your reports have the ability to show the previous/historical data. If you want to Copy Multiple Transactions From One Company File To Another please contact our experts.

If you're facing such issues/questions or just about any other situation similar to this, then without being hesitant get in touch with the QuickBooks technical support team. It is simple to get in touch with the QuickBooks tech support helpdesk.