Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 19, 2021
Question

streamlining or automating intercompany transactions?

  • November 19, 2021
  • 1 reply
  • 16 views

Has anyone come across any means, apps, integrations, hacks or tips/tricks in QBO for streamlining intercompany transactions? I reconcile transactions between a few associated companies each month and always strikes me as a job for software that posting a bank download to Debit Cash Credit Due to/from (for simple cash transfers) or, say, paying expenses of one company from the bank account of a sister company could somehow trigger matching in another company's bank downloads (if that makes sense)? I've been told Sage300cloud  has an add-on for this but I've never used it nor talked to anyone that's used it.  

1 reply

QuickBooks Team
November 19, 2021

Hi SSWap5922,

 

Thank you for reaching out to Community for suggestions and recommendations for streamlining intercompany transactions. Although there's currently no way to perform this directly in QuickBooks Online, feel free to review your options in our QuickBooks App Store.  This is a great question and I'll also be following for any additional tips or tricks others may have to offer.

 

Please feel free to reach out with any other questions.  We'd be happy to help!

SSWap5922Author
November 19, 2021

Hi Trish,

 

 

Thanks for the reply! Confused by your response though wrt to part where you say " feel free to review your options in our QuickBooks App Store. "

 

Are you saying there are third party apps that can integrate with QBO? Can you point them out to me please? I looked a bit ago but didn't find anything. 

 

Thank you!

 

Fiat Lux - ASIA
Level 14
August 16, 2022

OP Resurrecting this discussion : )

 

@Fiat Lux - ASIA the way I read your post is that you are describing a specific accounting application (that isn't QBO)? Is that correct? Or are you saying QBO Advanced and/or QBO Desktop Enterprise both give users that functionality?

 

Correct me if I am wrong @A-Frame but what we want is basically the equivalent of a crisp excel template for both tracking and checking intercompany transactions that can be used in tandem with, say, a recurring transaction or single JE that can be copied month-to-month. Using it in tandem means that the spreadsheet "drives" the entry (i.e., number of lines, accounts hit, amounts all basically come from that spreadsheet).

 

I haven't come across anything new since posting this. I am doing more intercompany transactions tho : ). How I manage it is (A) print off email instructions or whatever source document I have, (B) make a table using bulleted requests for interco (C) make another column (so you can check off FROM, TO for each co involved and as you enter the transactions into QBO). I've got one company up in Chrome and another one up using incognito - so I can input the two sides as a single activity (to avoid forgetting the notorious "other side"!).

 

Pretty basic but it is what it is until we find something better!



@SSWap5922 wrote:

@Fiat Lux - ASIA the way I read your post is that you are describing a specific accounting application (that isn't QBO)? Is that correct? 

 

Correct.