Basic AR interface table

Payments – Journal Type = General Journal

Manual Posting

Seq	GL Account Type	Particulars	DR Account	CR Account	Doc type	Payment Type
10	A-A/R Cash	CASH RECEIPTS	Cash at bank	Trade Debtors	1	CSH
20	A-A/R Cash	CHEQUE RECEIPTS	Cash at bank	Trade Debtors	1	CHQ
30	A-A/R Cash	C/C RECEIPTS	Cash at bank	Trade Debtors	1	B/C AMX etc
40	A-A/R Cash	B-PAY RECEIPTS	Cash at bank	Trade Debtors	1	BPAY
50	A-A/R Cash	OTHER PAY’T	Cash at bank	Trade Debtors	1	DFT L/C MO
60	A-A/R Cash	DIRECT PAY’T	Cash at bank	Trade Debtors	1	DD

Bank Rec Daily Interface to A/R via ARO140

A-A/R Cash

Receipts

Clearing Account

Trade Debtors

Journals – Journal type = General Journals

Seq	GL Account Type	Particulars	DR Account	CR Account	Doc type	Payment Type
10	J-A/R	Bad Debts	Trade Debtors	Bad Debts	2	BAD
20	J-A/R	Adjustment	Trade Debtors	Debtors Adj	2	ADJ
30	J-A/R	Intercompany	Trade Debtors	Intercompany Loans	2	IC
40	J-A/R	Realised Exchange	Trade Debtors	Exch Var Real	2	EXR
50	J-A/R	Unrealised Exchange	Trade Debtors	Exch Var Un-Real	2	EXC
60	J-A/R	Adjustments	Trade Debtors	Debtors Adj	2	JNL
70	A-A/R	Settle Discount	Settle Disc	Trade Debtors	3	DSC
80	J-A/R	Rebates	Trade Debtors	Rebates	2	RBT
90	J-A/R	Transfers	Trade Debtors	Debtors Adj	2	TFR

Basic Sales interface table

Sales – Journal Type = Distribution

Seq	GL Account Type	Particulars	DR Account	CR Account	Doc type
10	Return	Rebates TOS = RB	Rebates Accrued	Rebates B/S	B
20	Sales	Invoice & Credits	Trade Debtors	Sales	A & B
30	Sales	Intercompany	Trade Debtors	Sales	A & B
40	Sales	No charge	Trade Debtors	Sales	A & B
50	Sales	Freight Charge Enter freight Item	Trade Debtors	Freight Recovered	A & B

Transfers – Journal Type = Distribution

Seq

GL Account Type

Particulars

DR Account

Cost

CR Account

Cost

Doc type

Inventory

Transfers

Inventory

Inventory Clearing

C & D

Receipts – Journal Type = Distribution

Seq

GL Account Type

Particulars

DR Account

Cost

CR Account

Cost

Doc type

Inventory

Purchase Receipts

Inventory

Inventory Clearing

Adjustments – Journal Type = Distribution

Seq	GL Account Type	Particulars	DR Account Cost	CR Account Cost	Doc type	Stock Adj Code
10	inventory	Cost Adjustment	Inventory	Inventory clearing	E	CA
20	Inventory	Std Cost Adj	Inventory Reval	Inventory B/S	E	SD
30	Inventory	Stock Take Adj	Inventory Write	Inventory B/S	E	ST
40	Inventory	Inventory Write off	Inventory Write	Inventory B/S	E	WO
50	Inventory	Stock Adjust others	Inventory Write	Inventory B/S	E	Others
60	Inventory	Auto Pack/System Makeup	Inventory	Inventory Clearing	E	Sub Doc type = Y

Intercompany inventory interface example

The following examples of intercompany inventory transfer may be used as a guideline when establishing various interfaces. Each company will need to structure their General Ledger in a way that suits their business operations. In the following example each company records the Cost of Sales for their respective sales which creates a credit against the inventory account. The inventory values are manually transferred to the various companies by Debits or Credits to the Intercompany/Current accounts and the inventory accounts. The journal can be a standing journal where the figures/values are taken from a report in distribution rather than using the General Ledger Accounts balance or movements.

Stock Receipt in AUS$
	DR stock CR Creditors	AUS$ 9,000 AUS$ 9,000

GL Interface	Interface Purchase
Sell stock to NZ customer for NZ$$12,000 being AUS$10,000
Customer company = NZ Company Level 1 = product classification G/L Company = NZ Company
	DR Debtors CR Sales DR Cost of Sales CR Stock	AUS$10,000 AUS$10,000 AUS$ 9,000 AUS$ 9,000

To account for sale and cost of sale of inventory from Australia
	Manual via G/L Journal Entry Company = AUS Company DR I/Co Stock Transfer CR Stock	AUS$ 9,000 AUS$ 9,000

To raise charge to NZ Company for Cost of sales and to adjust stock balance
	DR Stock CR I/Co Stock Transfer	AUS$ 9,000 AUS$ 9,000

Manual Journals	To Raise stock expense and to raise liability to Australia
	Company = AUS company

	DR I/Co Commission CR Commission received	AUS$ 900 AUS$ 900

	Company = NZ company

	DR Commission paid CR I/Co commission	AUS$ 900 AUS$ 900

	To raise commission expense and liability

When an Australian Company item is sold to Australian customers:

Invoice to customer for AUS$ 10,000 cost @ $ 9,000

Stock receipt in AUS$

	Company = Australia Company

	DR Stock CR Creditors	AUS$ 9,000 AUS$ 9,000

Through G/L Interface	Inventory

Sell stock to AUS customer for AUS$ 10,000
Customer company = Australia company Level 1 = Australian products G/L Co = Australian company

	DR Debtors CR Sales DR Cost of Sales CR Stock	AUS$ 10,000 AUS$ 10,000 AUS$ 9,000 AUS$ 9,000

	To account for sale and cost of sale of inventory from Australia

When an Australian company ABC (or other company/currency) item is sold to NZ customers, the following transaction takes place:

Invoice to NZ customer for NZ 12,000 which translates into AUS$ 10,000 cost @ $ 9,000 NZ is charged cost + 10%.

Stock Receipt in AUS$
Company = Australian ABC

	DR Stock CR Creditors	AUS$ 9,000 AUS$ 9,000

Through G/L Interface	Inventory Purchase

Sell stock to NZ customer for NZ$ 12,000 being AUS$ 10,000
Customer Company = NZ Company Item Level 1 = ABC Items C/L Company = ABC NZ company

	DR Debtors CR Sales DR Cost of Sales CR Stock	AUS$ 10,000 AUS$ 10,000 AUS$ 9,000 AUS$ 9,000

	To account for sale and cost of sale of inventory from Australia