Opening Balance Uploading Journal Entry

Opening Balance Uploading Entry

Accounts Payable

Prepayment Invoice (Advance) 

 

Prepayment Invoice
Ac Code	Ac Description	JV	Amount
200000	Advance to Supplier	Dr	1000
100000	To Supplier	Cr	1000

Payment through Dummy Bank (Create Dummy Bank)
Ac Code	Ac Description	JV	Amount
100000	Supplier	Dr	1000
900000	Advance Upload Control Ac	Cr	1000

Run trial balance at this stage after posting AP invoices into GL.

 

Trial balance as on 31-03-2012 balance will show:

Ac Code	Ac Description	JV	Amount
200000	Advance to Supplier	Dr	1000
900000	Advance Upload Control Ac	Cr	1000

While loading GL Trail balance

Change that Advance to Supplier Ac (200000) to Advance Upload Control Ac (900000)

Hence 900000 Ac will get knocked up at the end.

 

Standard Invoice Uploading:

Standard Invoice
Ac Code	Ac Description	JV	Amount
900001	Creditor Upload Control Ac	Dr	1000
100000	Supplier	Cr	1000

While loading GL Trail balance

Change that Supplier Ac (100000) to Creditor Upload Control Ac (900001)

Hence 900001 Ac will get knocked up.

Accounts Receivables

Prepayment Invoice (Advance)

Advance Transaction
Ac Code	Ac Description	JV	Amount
	Receivables Ac (Deposit)	Dr	100
	To Unearned Revenue	Cr	100

When Cash received against Deposits
Ac Code	Ac Description	JV	Amount
	Cash Ac	Dr	100
	To Receivables Ac (Deposit)	Cr	100

Standard Invoice Uploading:

Standard Transaction
Ac Code	Ac Description	JV	Amount
200001	Receivable Ac	Dr	1000
900004	To Debtor Upload Control Ac	Cr	1000

While loading GL Trail balance

Change that Receivable Ac (200001) to Debtor Upload Control Ac (900004)

Hence 900004 Ac will get knocked up.

Inventory

Inventory Uploading
Ac Code	Ac Description	JV	Amount
200003	Material Valuation Ac	Dr	1000
900005	Inventory Upload Control Ac	Cr	1000

While loading GL Trail balance

Change that Material Valuation Ac (200003) to Inventory Upload Control Ac (900005)

Hence 900005 Ac will get knocked up.