bivio - accounting, reports, taxes, and administration for your investment club
Go to my Club Site Become a bivio user
Google
Help
  Introduction 
  Account Detail 
  Account Summary 
  Account Transactions 
  Accounting Reports 
  Accounts Report 
  Adding Members and Guests 
  Administrative Tools 
  Balance Sheet 
  Capital Gains and Losses Report 
  Change User Preferences 
  Changing Privileges 
  Club Configuration 
  Club Home Page 
  Club Info 
  Club Roster 
  Cookies 
  Creating New Accounts 
  Deleting Transactions 
  Downloading Files with Internet Explorer 
  Editing Opening Balances 
  Editing Transactions 
  Enabling Cookies in your Browser 
  Expense Allocation Methods 
  Exporting Club Data 
  Files 
  Font Size 
  Importing ICLUBcentral Accounting(tm) 
  Income Statement 
  Income and Expense History 
  Investment Detail 
  Investment Lots 
  Investment Performance Detail Report 
  Investment Performance Report 
  Investment Summary 
  Investment Transactions 
  Investments Report 
  Mail Message Board 
  Member Detail 
  Member Performance Detail Report 
  Member Performance Report 
  Member Status Report 
  Member Summary 
  Member Tax Allocations Report 
  Member Transactions 
  Member Withdrawal Report 
  Member Withdrawal Summary 
  Multiple Officers 
  Out of Pocket Expenses 
  Performance Benchmark Report 
  Price Database 
  Printing 
  Privileges 
  Problems Importing ICLUBcentral Accounting(tm) 
  Public Access 
  Secure Data Fields 
  Site Security 
  Suspense Account 
  Switchover Date 
  Taking Members Offline 
  Tax Allocation Methods 
  Tax ID (EIN) 
  Transaction History 
  Transaction Ledger 
  Transaction Limit 
  Unit Value 
  Unlisted Investments 
  Valuation (NAV) Report 
  Valuation Date 
  Value Unlisted Investments 
 
Importing ICLUBcentral Accounting(tm)
 
Previous Topic: Font Size Next Topic: Income Statement
Club officers can import a club's iCLUBcentral® Club Accounting data directly into bivio with this easy and reliable three step process.

Before importing, the club's treasurer must Export the club's data from iCLUBcentral® Club Accounting. This is done by starting iCLUBcentral® Club Accounting and going to Utilities > Export and saving the export file on a floppy disk or some other convenient and easy to locate place on your computers hard drive. Once complete, you may close the iCLUBcentral® Club Accounting program.

Note: It is important you run the iCLUBcentral® Club Accounting audit function before importing. bivio's auditing is automatic, but it cannot reconcile unaudited iCLUBcentral® Club Accounting data files.

Next, in preparation to Import that data into bivio an officer of your club must go to club's area in bivio, click on Administration > Tools > Import iCLUBcentral® Club Accounting. A page will open confirming that you desire to have all existing accounting transactions cleared from bivio's computers. Click on OK. Note: This action will result in all of your club's transactions and unlisted investments being deleted from bivio's computers.

And finally, the Import Process consists of up to three steps:

Importing ICLUBcentral Accounting(tm) - This step imports the data file from your computer into the bivio database. You will be asked to identify the location of the file exported from iCLUBcentral® Club Accounting. This file is named NCADATA.DAT. Also during this step, you may identify specific member information to import or exclude from your Club Accounting files, including address, phone, and/or Social Security Number. If imported, Social Security Numbers are only viewable by club officers and by the person to which they belong. The officers and bivio use this information to generate correct tax forms. If any or all of the above mentioned member data is excluded from your club's database, the club tax returns will be produced minus this required information. bivio will include a warning message when creating your club tax return indicating which information is missing. The club will then be required to manually add this missing information to the club's tax return.

Identify Listed Investments - This step is only necessary if our software cannot automatically match the ticker symbols listed in your database to those listed in bivio's pricing database. If unable to automatically match all ticker symbols, you are given the chance to attempt to manually match your investments to those tickers in bivio's pricing database. If unable to create a match, the investments will remain unlisted and you will have to enter future valuations explicitly.

Bring Members Online - This last step allows you to invite your members to your bivio club. If this is a re-import, the last step will probably be skipped. Our software automatically reconciles your current online members with those in your imported data.

Note: Club's desiring to run parallel books using both iCLUBcentral® Club Accounting and bivio may re-import their data as often as they like.

Note: Splits, mergers, and spin-offs that have cash in lieu entries and member withdrawals cannot be edited. Such transactions will not have an Edit Action next to them and will have to be deleted and reentered.

Related help topics:


 
Previous Topic: Font SizePrevious Next Topic: Income StatementNext
 
Switch to secure mode (slower)
Home About bivio Books Getting Started Safe & Private Register Login
top
 
BetterInvesting - National Association of Investors Corp. Copyright © 1999-2008, bivio Inc. All Rights Reserved. 
Use of this Web site constitutes acceptance of the bivio Terms of Service