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.
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)