Hi,
I need to import Import Open AR invoices to load data from previous system. I am using the General journal data entity through a data management import. We would like to user the control account Trade Accounts Receivable as the offset account but since it is flagged for no manual entry, I am not able to use this account. Which account I should use instead?
Also in UAT, I have removed the flag for the no manual entry, and I imported that data using the Trade Accounts Receivable control account. But when I run the customer ledger reconciliation report the invoice amount is not showing under the Ledger balance, hence the balances are not matching. Also if I run the trial balance for the Trade Accounts Receivable the invoice amount is not reflecting. I am not sure what I am missing.
Kindly find below screen shots which could be helpfull.
Thank you all the picture is clear now.
Hi Hossam,
How did you match the Balance sheet if you are not Importing other main Accounts?
Let's see the scenario:
Total Assets: $ 100,000.00 (Excluding AR)
Account Receivable: $ 25,000.00
Total Equity & Liability: $ 125,000.00
You import Account Receivable as you mentioned:
Accounts Receivable Dr $25,000.00
Control Account Cr $25,000.00
Net : $ 0.00
Now you Post:
Assets Dr $ 100,000.00
Equity & Liability Cr $ 125,000.00
Control Account Dr $ 25,000.00
Net : $ 0.00
As the system follows the double-entry system, you'll have the same difference (Control Account) while posting other balances.
So please follow the basics of the Account and you will be able to solve the entire balancesheet.
Thanks,
Thanks everybody for the support. I am almost there, and I need your help in the last step.
I have created a new main account "980000" with main account type balance sheet. Posted the entry as below. Now the customer and ledger reconciliation report is matching which is perfect.
What is pending is to zero this new main account "980000". Or should I leave it as is?
Comparing the steps you have shared with me, since I am only importing opening balances for AR, the new main temp account "980000" will not zero by it self, since I am not importing bank, sales, vendor, and the other subledgers.
Opening Balance transaction
Trial Balance of temp new main account
Hi,
you can use separate "opening balance Account" which you can use against all balance migration.
You can look at this blog for approach:
Hi Hossam,
The main account type can be 'Balance'. You might use the same account for open vendor entries. You can also create separate suspense accounts.
The balance will not be cleared automatically. You have to do this yourself; part of the opening balance entry.
Hi André,
I really would like to use your approach but I need some clarifications. I need to create a new account example 999900 to be used as offset to the customer debit amount. Does this main account 999900 need to be of Main account type "Asset".
Do I need to create a new suspense account, and what would be the transaction debit and credit to zero the main account 999900. Or is there a property to be enabled on main account 999900 to make it zero automatically once I enter the transaction as debit customer and offset
Hi Hossam,
You can use a new balance account, specific for the conversion as offset. When you enter the opening balance, you can use this same account instead of the AR control account. If should then zero out that balance on the suspension account.
Hi Hossam,
I am unable to understand your process.
If I have to do the process:
In your case, I assume both accounts are the same, because of which impact of the Invoice nullifies.
Let us know if this helps.
Thanks,
Hi,
We are importing invoices to help us on aging and to be more detailed. Can you elaborate more on your proposed solutions. How the journal entry will look like.
Thanks.
Hello,
Why dont you import the balance instead?
Or else, why dont you import the original invoices with Sales Cr and Debtors DR?
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156