Intercompany Trading Setup for Balance Sheet / Trial Balance

This setup for for companies that:

1. participate in trading within its own group of companies (subsidiaries, sister company, parent organisation etc.), and need to
   
2. generate Balance Sheet and Trial Balance reports that separate Debtor and Creditor amounts accumulated from intercompany trading apart from Trade Debtors and Trade Creditors accounts.
   

Take note that this setup does not affect reports from Ageing Analysis, Debtor/Creditor Ledger and Statement of Account.

To facilitate this process the system needs to know:

1. Which account(s) are being used for intercompany trading, and
2. which Business Partners are part of the intercompany trading group.
   

Follow the steps below to perform the required setup.

[For 1] First, create the Debtor and Creditor accounts for Intercompany Trading.

The account category should be Trade Debtor and Trade Creditor respectively.

Duplicate the existing Customer group and replace "Trade Debtor" with the account created to hold Debtor amount for intercompany trading.

(do the same for Vendor group if you also make intercompany purchases)

[For 2] Register your affiliated company as a Business Partner.

Then set choose the intercompany Customer/Vendor group as their group. (If already done, edit and change the group)

This makes the custom double-entries apply to documents created for this Business Partner.

See the setup in action shown in screenshot below:

On the Balance Sheet, you can see the amounts separated by account.

In Ageing Analysis, there is a subtotal for each Business Partner; the total is combined amount from all Debtors/Creditors.

This is because Ageing Analysis does not discriminate by Debtor/Creditor account.

Ageing Analysis for Purchases:

Ageing Analysis for Sales:

• Related Articles

• Date range in Trial Balance, Balance Sheet and P&L

  When generating reports in the system the date range filters affect the values you generate. Our system has the following range filters. Balance:  Include all entries till today's date. If today's date is in 2019. when i select balance filter it will ...

• Trial Balance/General Ledger values not matching with Ageing values.

  When comparing the Trial Balance values against Ageing, we are looking at the Trade Debtor/Creditor accounts. Ageing Report In order for the report to generate values, the Trade Debtor/Creditor accounts needs to have the following information. 'Who' ...

• Entering Company Information

  1.3.1 Entering Company Information Location Action Remark       Setup Activity> Company      Click SETUP activity      Click COMPANY DETAILS      Click COMPANY module      Click EDIT This is to edit the company information        ADDRESS      ...

• How do I setup Multiple Running Number Series?

  6.1 SETTINGS 6.1.1.1 How do I setup Multiple Running Number Series? This is useful if you need more than one set of running number series.Let’s say if you have 2 sales departments, each needed to have their own set of running numbers, you can create ...

• Drill Down Function

  4.3 FINANCIAL REPORTS 4.3.1 Drill Down Function Location Action Remark Report> Trial Balance  Click REPORT activity  Click FINANCIAL  Click TRIAL BALANCE module At Trial Balance: This will trigger the General Ledger to pop-up.  ...