Forum | Synoptix

Learn, Create, Report
It is currently Tue Jun 18, 2019 3:20 am

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Import Financial Data
PostPosted: Tue Jan 02, 2018 3:01 pm 
Site Admin
User avatar

Joined: Tue Dec 10, 2013 3:27 pm
Posts: 400
Position: Forum Administrator
Import Financial Data

Purpose

The software allows for importing of financial data from an Excel type worksheet. Once imported, data is stored and can be used to report from as you would any other data source. (Note that data imported from an Excel type worksheet does not support Drill Downs.)

To Import a worksheet, click Financial in the Maintain group on the Main Menu, then click Import Financial Data. The Spreadsheet Selection dialog box displays.

Image

Definitions

Path: Enter the file path of the workbook to be imported, or click the magnifying glass to browse for the workbook.

Sheet To Use: Select a specific worksheet from the imported workbook. The default is Sheet1.

Click Next to Continue

The Import Columns Definition dialog box allows you to select appropriate column types for the data being imported.

Image

Definitions

Balance Forward: Select this check box if balances being imported include beginning balances.

Column Headers: Select the correct data type for each column being imported.

Click Next to Continue

The Company Selection dialog box allows you to either select an existing company, or create a new company, to associate with the imported data.

Image

Definitions

Company: Select a previously used company to import the data for.

Create New Company: Create a new company if this is the first time you are importing data for it.

Click Next to Continue

If the data being imported includes accounts for which balances have not been previously imported, the Chart of Accounts Definition dialog box lists these accounts. If all accounts have had balances previously imported, the list is blank.

Leave any default entries as is and click Next.

Image

Click Next to Continue

The Periods and Import dialog box allows you to set the Year and Period data is being imported for.

Image

Enter a Year and Period, then click Import. When ready, click Finish to close the dialog box.


Top
   
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
cron
Powered by phpBB® Forum Software © phpBB Group
Powered by Reputation System © Pico88