Intercompany transactions

Good evening, @Carolynwells18.

I hope you're having a wonderful week so far. You upload transactions into other accounts by downloading them from your bank and bringing them into QuickBooks. This will allow you to get the transactions from the bank directly instead of trying to move them between files. The steps below will show you how:

1. First, go to your bank's website, log in, and download the transactions using a .qbo file.
2. In QuickBooks, select the File menu and press Utilities.
3. Hover over Import and choose Web connect files.
4. Next, find the file you saved and Open it.
5. Then, you'll either need to pick a bank account that already exists or create a new one.
6. Hit Continue when the dialogue box tells you the transactions were imported correctly, then push OK.

Now you can make sure your transactions uploaded correctly by going to the Bank Feeds Center and viewing them there. You may find this article about downloading bank feed transactions helpful as well.

As for moving your transactions to a liability account, I recommend reaching out to your accountant to make sure that is the best process for your books. They'll be able to tell you how to best record the assets and liabilities, so your book's balance isn't negatively affected.

Just hit the Reply button if you have any other questions. Enjoy the rest of your week!

This is the same question that I have and I am wondering if you found the answer you were looking for. I know that this is a very simple process in dynamics or great plains but no one this forum or anyone that works here can see to tell me if the intercompany transfer or entries are able to line up on subsidiary ledgers or through multiple corporations. If you have an answer let m me know please

Thanks for posting to the Community, @LPercn.

Since you have the same questions with Carolynwells18, you can follow the same steps provided by my colleague, @Anna S, on how to get transactions directly from your bank to QuickBooks.

There you can add the transactions from your bank and able to match them in QuickBooks.

Also, I'd suggest consulting your accountant about how can inter-company transfers can line up on subsidiary ledgers or multiple corporations. They know how to account, and give the best advice to keep your books accurate for this kind of scenario. Besides, it makes sense when they share with you the answer.

In case you need more answers about topics such as accounting synopsis, you can look for them here: Reports and accounting.

Please feel free to drop a comment below if you need further assistance. I'll be around to help. Stay safe and well!

Hi - I have a similar request and the previously given solution of linking expenses to the bank feed won't work for us, as the entity that is paying bills on behalf of other entities, is doing so on behalf of several different entities and sometimes one single payment might even be allocated across several group entities. I.e. importing the entire bank feed to any given entity would import too many transactions.

Basically what I am hoping for, is a function whereby I can link an intercompany account in Entity A, with a corresponding intercompany account in Entity B. Then, I would raise bills and pay them in Entity A (Dr. Receivable from B; Cr. Bank) and add all details of the bill (Customer, Job, Class) in Entity A's file. This information would then be mapped to Entity B's file, where it would automatically record Dr. Expense (including Customer, Job, Class); Cr. Payable to Entity B.

Well that's the dream - is there any functionality like that out there? Currently I need to duplicate the entries in Entity A and Entity B, C, D...

Nice to have you join this thread, @SDS808.

Currently, the option to link your account from one entity to another isn't possible in QuickBooks Desktop (QBDT). 

As a workaround, you'll want to import those transactions to your other company. Ensure to only import the transaction that hasn't been imported yet to avoid duplicates. To be guided, you can refer to the Import Web Connect (.qbo) file section in this: Set up bank accounts for Bank Feeds in QuickBooks Desktop. 

You can also search for a third-party app that has this feature. You can go to the App Center from your QBDT or visit our Apps for QuickBooks Desktop page for reference.

Also, I encourage you to check our Product Updates page. Here, you'll stay updated on the latest features and releases about QuickBooks.

You might also want to utilize this link for guidance in reconciling your accounts: Reconcile an account in QuickBooks Desktop. This resource provides detailed steps in ensuring your accounts are well accounted for.

Keep me posted if you have other follow-up questions managing your accounts. I'd be more than happy to lend a helping hand. Have a great weekend ahead!

I would like to chime in as well. I am working with a client that has three entities and three separate QBO accounts, which seems a bit overkill on QuickBooks part of gaining profit.

The issue is that Company A used say $100,000 of Company B's money to pay for bills.

They then used Company B's money to pay for Company A's bills. It was more like $400,000. Company C also used about $500.00 of Company B's money.

Company C can simply cut a check and pay the $500.00 from a bill created by Company B to zero out this balance owed.

If I create bills for what Company A owes to Company B, it will create a huge negative balance in the banking account for Company A, which the owner would like to avoid.

If I create bills for what Company B owes to Company A, there will be a huge surplus in the banking account for Company A, which the owner would like to avoid.

How can I clean it up so that it balances out on both sides? From what I can see, there were four different people in the course of one year that entered these expenses as bills, transfers, journal entries, and invoices. 

I would much prefer to change everything to a bill and a payment instead of having four different methods that do not add up between the two companies. Any advice?

Hi there, Vietjohn.

I can share some tips in handling that transaction.

Since company A is using company B's money to pay the bills, you can set up a liability account in company B's chart of accounts. This account is for company A's payables. Once done, you can create a journal entry to pay company A's expenses. Then, use that liability account as the expense account for the transaction.

In company A, create a journal entry for the expenses paid by company B. Take note that you may need to consult an accounting professional in performing this process if you're not familiar with accounting.

I'm also adding this article to learn how to move money from one account to another: Transfer funds between accounts.

You can always find me here if you have any other concerns or follow-up questions. Have a good one.  

I would like to chime in as well. I have Company A that pays multiple credit card bills that have some charges belonging to Company B. We import the transactions into Company A since company A pays the bills. But every transaction that belongs to Company B gets coded to a Due From Company B account on Company A's QBO. There are hundreds of transactions that get imported this way. We lose detail as to the specific expense and have to manually record the transactions again into Company B's QBO in order to offset the Due From account with a Due To company A account and then expense them to the appropriate expense account. Is there an easier way to transfer or import the transactions being imported into Company A to also import them into company B and avoid manual entry?

I have a similar issue where at times company A pays company B's credit card bills, and vice versa.

I created a balance sheet account for each company, called intercompany debt, which is an asset/(or liability) account, but will be a liability account if the amount is negative, depending on which way a transaction is moving. 

At the end of the year, the intercompany debt of one company should equal the intercompany debt on the other company (with the sign being reversed.)

For example if company A owes company B a net of $20,000 at year end, this will show up on company B's balance sheet as a $20,000 intercompany debt (receivable/asset) and on Company A balance sheet as a $20,000 intercompany debt (payable/liability)

My question is, as these two entities are separate corporate entities with common ownership (both are S-corps), is there a need for a year end journal entry to eliminate this intercompany debt/asset, and if so, why, and what is that journal entry?  And if there is a year end journal entry, does this entry get reversed on the following day of the entities' first day of the fiscal year?

Please note that the expense is already properly recorded on each company's P&L, because the credit card transactions of each company are already recorded and coded into their proper expense category (taken from each company's monthly cc statement.)  To clarify, each company has its own company credit card, and thankfully, that makes things a bit easier.  Therefore, the P&L of each company is already represented accurately and needs no adjustment.

Thank you in advance.