Import G/L Accounts
Overview of FW75UPD
DDI-Connect FundWriter allows you to import G/L accounts into your Chart of Accounts. You can use a variety of formats for your source document, including Comma Separated Values (CSV), excel spreadsheet, fixed width and others.
- From the DDI Connect main menu, double-click FundWriter
- Double-click General Ledger Setup
- Double-click Import G/L Accounts. You will see this screen:
In order to import a file, you will first have to configure the Import mapping. Click the button to the right of the Import mapping field:
You will see this screen:
Mappings tab
To add a new table mapping, click the Add button on the toolbar. The fields will activate for editing:
The following fields are available on this screen:
Field | Description |
---|---|
Mapping name | Enter a descriptive mapping name, such as "CSV Format" |
File format | Click the drop down arrow to select the file format that you are setting up |
Header row | If your file contains a header row, select this box |
Click the Fields tab.
Fields tab
When you click the Fields tab, you will see a screen like this:
In the Position column, double-click the field row. The screen will enable like such:
Enter the column position in your spreadsheet for each field listed. Click OK when you have entered the field position. Your screen now appears something like this:
Click Save to retain your changes. If you are done configuring mapping templates, click OK. You will be returned to the Import G/L Accounts screen:
[[File:Import GL Accounts 8.png