Import / Export Add-on

The Import / Export add-on includes two capabilities that help the program communicate with other software programs outside the accounting system. These including importing transaction data and exporting report data.

Importing Transaction Data

Using the Import / Export add-on, transaction data from outside sources can be imported into many of the working modules. The system can import data that has been saved as a text file in .csv (comma-separated values) format.

Click these links for more instructions on importing General Ledger Transactions, Accounts Payable Invoices, Accounts Receivable Invoices, Purchase Orders and Payroll Timesheets.

Important Note

Purchasing the Import / Export add-on is not necessary for importing database information using the options from the Setup menu. The process of importing setup information such as vendor records, employee records, and customer records comes standard with the purchase of the accounting system. The purchase of the Import / Export add-on is only necessary if the user will be importing transactions such as timesheets, invoices, or adjusting G/L entries on a regular basis.

Exporting Report Data

The export feature included in the Import / Export add-on has to do with the information found on the Print Preview window for system-generated reports. At the top of the preview window, you will see the following option bar:

 Export This Report (toggle button)

If the Import / Export add-on has been purchased, the button at the far right allows the user to export the information from the displayed report and open it using the desired program type. To export the report, click the button and then close the print preview screen, the following window will appear:

Click the desired destination button, the report will be exported to a text file then opened using the selected program. If Save File to Disk is selected, a standard Windows file saving dialog box will be displayed for saving the file to the desired location and filename.

Open as a Spreadsheet (button)

If this option is selected, the following dialog box will appear:

When the system builds a spreadsheet from the report information, the user has the option of opening an existing spreadsheet and having the report information fill the sheet starting at a specific column and row.

Start Column / Start Row

Indicate the starting column and row for the report information to fill in the spreadsheet.

Template

If desired, enter the filename of an existing spreadsheet. The program will open that spreadsheet and insert the report data starting in the specified column and row.

File Name

Enter the name of the new spreadsheet file to be created. The system will provide a filename by default.