on 12-26-2013 12:23 PM
Hi experts,
I would like to ask your suggestions on how you can clear the opening balance gl account and what drawer should it be placed? For example, after the inventory beginning balance has been uploaded and debited to an inventory gl account under the assets drawer, what gl account should I used to offset (credit) the balances. Should I used an inventory suspense beg. balance gl account under assets or a temp gl account like SAP opening balances under Equity drawer? and how can I clear those opening balance accounts?
Thanks in advance,
Maria
Hi Maria,
You can open the OB clearing account under any drawer as at the end of importing the OB, the clearing account should be zero.
Now, in your case, after entering OB for stock, the JE would look like:
Stock --- Dr
OB Clearing account--- Cr
To clear the amount in OB clearing account, when you post the OB of GL, replace the inventory account by OB clearing account, as a result, the value which was credited in the OB account when you posted the stock opening, will get debited with the same value once you post the GL balance and thereby making it zero.
Hope this helps.
Thanks,
Joseph
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Maria,
If your all opening balances are uploaded correctly, the opening balance gl account should be cleared automatically.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi again,
I can't seem to attached the screenshot. but here is the JE created from my Inventory Beginning Balance upload:
JE:
324000 SAP Go Live Inventory Suspense Acct $107,100 (Credit)
141000 Inventory $107,100 (Debit)
SAP Go Live Suspense account is under Equity now how can I make it zero or cleared in the system?
Thanks,
Maria
Hi,
For example:
Assets = 10
Liabilities = 4
Capital & Reserve = 6
Now, you upload to B1
1) Dr Assets 10
Cr Opening balance account 10
2) Dr Opening balance account 4
Cr Liabilities 4
3) Dr Opening balance account 6
Cr Capital & Reserve 6
You can see, after finishing OB transfer, account balance of that account is zero
Hope this helps,
TVSon
Hi Maria,
Yes, you are right. You should use an "Opening Balance" GL account of clearing nature under Equity Drawer and use this account for Opening Balance Transfer. Similarly for year end closing you should have an account with name "Closing Balance" Account. Both of these accounts should show zero balance when the process is done.
Regards,
Azeem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.