All guides
Guide · Group (multi-entity)

Running a group of companies

Several companies as one group — intercompany invoices mirrored as bills, entries posted in both companies at once, and consolidated statements with the eliminations done for you.

3 min read

Watch it done: Several companies, one set of reports

Each legal entity you run is its own company in BeanDish, with its own books. A group ties them together so the business can be reported as one, with what the companies owe each other taken out.

Your companies

The company switcher at the top of the sidebar shows the company you're working in. Manage companies lists every company you belong to, with your role, its currency and its fiscal year start.

Setting up the group

Open Group › Group settings. Member companies lists the group's companies and their recorded ownership; consolidation includes every member in full. Add a company puts another company you administer into the group. All members must share the group's currency and fiscal year start.

The account map consolidates one company's account code into the group's code where the two charts differ. Codes you don't map consolidate as themselves.

Telling BeanDish what is intercompany

In each company's chart of accounts, tag the accounts that hold amounts due to or from another member with that company. On the customer or supplier that stands for a group company, set the company it stands for.

Trading between the companies

  • Invoices. Post an invoice to a customer that stands for a group company, and BeanDish puts a matching draft bill in the other company. The invoice's Intercompany card says so. Until that bill is posted, Group › Intercompany shows the pair as Differs, and Consolidated reports warns that the eliminations don't net to zero. Switch to the other company, open the draft under Purchases – A/P › Bills, check it and post it; the pair then agrees.
  • Charges with no invoice. On Group › Intercompany, click Intercompany entry: the counterpart company, the date, a memo, and balanced lines for each company. Post both entries posts them in both sets of books together.

Consolidated statements

Open Group › Consolidated reports, choose a statement and its dates, and click Run. The worksheet shows each company side by side, the eliminations and the group total; the consolidated statement sits below it. Download either to Excel. On the balance sheet, what the companies owe each other cancels out.

See every step

The video above shows an advance, a mirrored invoice and the consolidated statements in a minute and a half. The tutorial below goes slower, from Group settings to the eliminations. The same tutorial is in BeanDish under Learn › Tutorials.

Run a group of companies, step by step

Two companies as one group: Group settings with its members and account map, intercompany tags, an invoice mirrored as a draft bill in the other company, an intercompany entry posted in both at once, and consolidated statements with their eliminations. (4:57)