...
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.
- Define the journal you want in Excel across the multiple entities
- Upload to the entity that is sending a debtor invoice to the others
- All mirror creditor invoices will be created in the other entities
Here is an example upload file that will create Debtor invoices for 3 entities (and matching creditor invoices in those entities).
- Debtor Code
- Date for Journal (same date will be on same journal created)
- External Ref (used to group journal lines onto the same journal for the same date
- DR amount inc GST
- CR amount inc GST
- Tax Code
- Tax $
- 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.
| Debtor | Date | Extern Ref | Description | Debit (GST Incl) | Credit (GST Incl) | Tax Code | Tax Amount | Service Code |
| ALX | 3/31/2018 | PAY 2018 03 | Salaries/Wages recharged | $15,198.18 | GST | $1,381.65 | PAY | |
| ALX | 3/31/2018 | PAY 2018 03 | Superannuation recharged | $1,443.83 | GST | $131.26 | PAY | |
| ALX | 3/31/2018 | PAY 2018 03 | Annual leave provision recharged | $1,168.74 | GST | $106.25 | PAY | |
| ALX | 3/31/2018 | PAY 2018 03 | Payroll tax recharged | $970.68 | GST | $88.24 | PAY | |
| ALX | 3/31/2018 | PAY 2018 03 | Workers comp insurance recharged | $355.64 | GST | $32.33 | PAY | |
| ALX | 3/31/2018 | PAY 2018 03 | Payroll processing fee | $683.91 | GST | $62.17 | PAYF | |
| BON | 3/31/2018 | PAY 2018 03 | Salaries/Wages recharged | $25,506.86 | GST | $2,318.81 | PAY | |
| BON | 3/31/2018 | PAY 2018 03 | Superannuation recharged | $2,423.16 | GST | $220.29 | PAY | |
| BON | 3/31/2018 | PAY 2018 03 | Annual leave provision recharged | $1,961.48 | GST | $178.32 | PAY | |
| BON | 3/31/2018 | PAY 2018 03 | Payroll tax recharged | $1,629.09 | GST | $148.10 | PAY | |
| BON | 3/31/2018 | PAY 2018 03 | Workers comp insurance recharged | $596.86 | GST | $54.26 | PAY | |
| BON | 3/31/2018 | PAY 2018 03 | Payroll processing fee | $1,147.81 | GST | $104.35 | PAYF | |
| CAR | 3/31/2018 | PAY 2018 03 | Salaries/Wages recharged | $24,707.28 | GST | $2,246.12 | PAY | |
| CAR | 3/31/2018 | PAY 2018 03 | Superannuation recharged | $2,347.19 | GST | $213.38 | PAY | |
| CAR | 3/31/2018 | PAY 2018 03 | Annual leave provision recharged | $1,899.99 | GST | $172.73 | PAY | |
| CAR | 3/31/2018 | PAY 2018 03 | Payroll tax recharged | $1,578.02 | GST | $143.46 | PAY | |
| CAR | 3/31/2018 | PAY 2018 03 | Workers comp insurance recharged | $578.15 | GST | $52.56 | PAY | |
| CAR | 3/31/2018 | PAY 2018 03 | Payroll processing fee | $1,111.83 | GST | $101.08 | PAYF | |
| CAS | 3/31/2018 | PAY 2018 03 | Salaries/Wages recharged | $14,579.74 | GST | $1,325.43 | PAY | |
| CAS | 3/31/2018 | PAY 2018 03 | Superannuation recharged | $1,385.08 | GST | $125.92 | PAY | |
| CAS | 3/31/2018 | PAY 2018 03 | Annual leave provision recharged | $1,121.19 | GST | $101.93 | PAY | |
| CAS | 3/31/2018 | PAY 2018 03 | Payroll tax recharged | $931.18 | GST | $84.65 | PAY | |
| CAS | 3/31/2018 | PAY 2018 03 | Workers comp insurance recharged | $341.17 | GST | $31.02 | PAY | |
| CAS | 3/31/2018 | PAY 2018 03 | Payroll processing fee | $656.08 | GST | $59.64 | PAYF |