Importing Accounting Balances

From Opentaps Wiki

Jump to: navigation, search

To set up your company's initial financial information in opentaps perform the following steps. You can import accounting balances from another accounting system by following these steps, or in a simpler start-up case you can manually post your financial balance sheet entries if you like.

General Scenario for Importing Data

These steps outline the procedure for importing initial accounting data into your opentaps database.

  1. First import the inventory using the Data Import application, Importing Data with Dataimport.
  2. 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.
  3. 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.
  4. Put these transaction entries in a file and import them into opentaps with Webtools, or directly into your database.
  5. Once the transactions are in the system, go to Financials > Ledger > [Unposted Transactions] You should see the transactions listed there and you can post them one by one, Click: [Post].
  6. After posting the transactions, check that your trial balances and balance sheets are correct.
  7. 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.


Importing Accounting Data Step-By-Step

The following step-by-step procedure provides much more detail for how to execute the importation of your accounting data.

                      .... This sections is being written ....


Manual pages >> Initial Values and Importing Accounting Balances



© Open Source Strategies, Inc. Development of this documentation site is sponsored by Open Source Strategies, Inc.
Help support opentaps with a subscription to this documentation site.