Table of Contents

Trading Between Host Companies

Terms are set on the debtor and show on the creditor normally.

When you have a number of host companies in the system that operate loans rather than payment terms.  The payment terms can be replaced by a term called "Loan".

Typical example is a 100% owned company that you settle up the trading every month or quarter.

Both companies need to be host companies in the system

A transaction created in one Host company will create the required transaction in the other Host Company

The only transactions allowed are:

1. Debtor Invoice (Creates Creditor Invoice in other company) with Creditor Invoice Subtype = "Trading Loan Mirror"
2. Creditor Payment (Creates Debtor Payment in other company)

The loan total value is visible on the Host Company.  The Loan Total Value is also visible on the Balance Sheet

1. Where the net value of the loan is money owed to you - it will appear as part of Trade Debtors
2. Where the net value of the loan is money owed by you - it will appear as part of Trade Creditors

Transactions

Create a manual debtor invoice

The Matching Creditor Invoice will be created by the system in the other Host Company

The Creditor Payment - must have bank information entered that matches the target Host Company Bank Account

When the creditor payment is created = a debtor payment is created in the other host company - and the reference from the other host company will show as external ref number.

The Debtor payment that was created in the other Host Company

View the loan value anytime

On the host company

On the Balance Sheet

Setup

Create the loan and indicate the start date.  A loan can be setup at any time. 

Define the loan in one of the Host Companies - Status will be "Proposed".  From the other Host Company status will show as "Awaiting Approval" - Change Status to "Active"

The loan can be ended at any time and any transactions after the end of the loan will use normal collection terms.

This will put the terms on the Debtor and Creditor in both Host Companies of "Loan"

Importing mass multi-entity Journals

When one business pays suppliers or employees and then recharges other companies in the group - a lot of transactions can be created.  This can be simplified the following way.

1. Define the journal you want in Excel across the multiple entities
2. Upload to the entity that is sending a debtor invoice to the others
3. All mirror creditor invoices will be created in the other entities

Here is an example upload file that will create Debtor invoices for 4 entities (and matching creditor invoices in those entities).

1. Debtor Code
2. Date for Journal (same date will be on same journal created)
3. External Ref (used to group journal lines onto the same journal for the same date
4. DR amount inc GST
5. CR amount inc GST
6. Tax Code
7. Tax $
8. Service Code.  You will need to define a service in the system with both a Buy GL account and a Sell GL account so the system knows what GL accounts to use.