Importing Accounting Balances
From Opentaps Wiki
Revision as of 01:45, 22 November 2007 by Sichen (talk | contribs) (Protected "Importing Accounting Balances": Sysop page [edit=sysop:move=sysop])
You can import accounting balances from another accounting system by following these steps:
- First import the inventory using the Data Import application.
- Create a time period immediately preceding the current one. For example, if you're implementing the GL system as of August 1, 2005, create a time period that ends August 1, 2005.
- Then, create accounting transactions and entries in that time period which describe the company's financial condition before it was transferred into opentaps. These can be done as a series of transactions all as of the last second of the time period (ie, July 31, 2005 at 23:59:59). You can create one transaction for the entire balance sheet with entries for every GL account, or a series of transactions.
- Put these transaction entries in a file and import them into opentaps with Webtools, or directly into your database.
- Once the transactions are in the system, go to [Financials] > [Transactions] > [Post Transaction]. You should see the transactions there and can post them one by one.
- After posting the transactions, check that your trial balances and balance sheets are corrected.
- If everything is correct, close out this time period. Then the initial financial conditions can no longer be changed, and you can start using your company with the opentaps.