cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member

Like to combine accounts payables transactions recorded in two separate companies

I like to import vendors history from one company to the second one in QB.

2 Comments
QuickBooks Team

Re: Like to combine accounts payables transactions recorded in two separate companies

I am delighted to have you here, @Sherry5.

 

You can export your account Payable transactions and import it to the second company file using an IIF file. I can walk you through on how to do them.

 

First. let’s download all your AP transactions. Here’s how:

  1. Go to the Reports menu.
  2. Choose Vendors and Payables.
  3. Select the Transactions List by Vendors.
    1. Set the date range of the AP transactions you want to download.
    2. Click the Excel drop-down menu,
    3. Choose to Create New Worksheet.
    4. Select Create a comma-separated values (.csv) file.
    5. Click Export.
  4. Enter the filename of the downloaded AP transactions.
  5. Click Save.

 

Once completed, download the .IIF import kit. Look for the specific IIF file format for bill transactions. Edit the downloaded file to ensure that it exactly matches with it.  You can refer to this article for detailed information: IIF Overview: import kit, sample files, and header.

 

You can also use the exported AP reports as a reference when entering a Batch Transaction. This feature is available in QuickBooks Desktop for Accountant version.

 

Here’s how:

  1. Open the QuickBooks second company file.
  2. Go to the Accountant menu.
  3. Choose Batch Enter Transactions.
    1. Click the Transaction Type drop-down.
    2. Select either Bills & Bill Credits or Credit Card Charges & Credits
    3. Choose Accounts Payable in the A/P Account drop-down.
    4. Enter the transactions detail.
  4. Click Save Transactions.

You can refer to this article for step-by-step instructions: Enter transactions by batch in QuickBooks Desktop.

 

Keep me posted if you have other questions. I’m always here to help.

BRC
Established Community Backer ***

Re: Like to combine accounts payables transactions recorded in two separate companies

You can do this much more easily using our BRC Transaction Copier 

 

Use it to pull Bills for a date range from one file for import into another file.  You can even review them along the way in Excel to see if you're about to import the correct set of transactions into the destination company file.