Opening balance

[sam]

Hai all

I want to install compiere in a company with is running so i want to
import all the recent trial balance entry and i have to close that
financial year and carry forward the financial entry's to new financial
year please help me to fix this problem

Thanx in advance and please it is little bit urgent..

[sam]

[sam]

[Robb Kunz]

Hey Sam, nice to hear from you again.

This is a pretty normal request/process.

Basically, here is what you should do:

1. Map the previous chart of accounts (COA) to the new Compiere COA to
create the new CSV import file (this is done manually)
2. Use the standard GL Journal Import in Compiere to load the trial
balance transactions. We usually batch the transactions by month to
allow easier reconciliation.
3. If the standard import does not work let me know, our guys probably
have developed custom code to do this since we do this all the time.
4. Run the financial reports to make sure all accounts balance back to
original system you are converting off of.
5. Capture the closing balances from the Financial Reports and use this
amount to input GL Journal entries on the first day of fiscal year as
the opening balances.
6. Run Financial Reports again comparing Closing Year to new Financial
Year and make sure they are in balance
7. Close the past period.

Courtesy of KnowledgeBlue
The largest Certified Compiere Partner in the World
http://compiere.knowledgeblue.com
http://knowledgeblue.com
801-746-5609