Use this program to:

• Add new cash like deposits or payments to existing RAs. This cannot be used for importing credit card deposits or payments

I. CREATING THE SPREADSHEET

A. Entering data in the spreadsheet

Using a spreadsheet program (such as MicoSoft Excel) create a spreadsheet using the columns defined at the end of this chapter. The columns for the spreadsheet do not need to be in any particular order, and all columns need not be present. For your own purposes, the spreadsheet can contain additional columns unknown to CARS+. What is required is that the columns that contain data to be merged MUST have the column header specified in the chart shown at the end of this chapter.

• Create a row for each deposit or payment record that should be imported.
• Enter the data to be added or changed in the appropriate column(s). (See the "User Tip" below regarding the date format.)

User tip: Date format can be either:

YYYYMMDD (Example: 20160927 for September 27, 2016)

The local date format of either: MM-DD-YY or DD-MM-YY (This is specified in Edit Misc Control Record.)

B. Naming the spreadsheet file.

When saving the spreadsheet, the name assigned to it should follow Unix file name conventions which are:

• Maximum of 10 characters for example 20160930DP.csv for September 30, 2016, and DP for (D)eposit (P)ayment
• No spaces or slashes in the name

C. Saving the spreadsheet.

First save it in your spreadsheet program's native format (for example if using Microsoft's Excel program, save it as .xls).

Re-save a copy in .csv format.

If an error in the data is discovered by the merge program, go back to the file in the native format and easily make any corrections. Then re-save it again as a comma delimited file (.csv format).

It is the copy saved in .csv format that will be used for the import. The first row of column headers must be included.

II. UPLOADING THE FILE FROM THE PC TO CARS+

Create the spreadsheet on a PC or computer that is also used to access CARS+. Once the spreadsheet is saved in the csv format, sign into CARS+ using the same computer.

To access the Import RA Payments program, type IMPDEP (RET) at any menu "OPTION:" field or the appropriate line number on the Import Data sub-menu of the System Management menu.

• With the cursor at the "OPTION" field, press F4 to upload the file.
• A browser window will appear. Select the csv file from your PC and click "Send".

III. RUNNING THE IMPORT PROGRAM

The screen will then display:

OPTION: __ IMPORT RA PAYMENTS 1 Filename 1DO IMPORT2 3ERASE 4UPLOAD 5BACKUP 6 7HELP 8

Enter data as follows:

1.FILE NAME

The file can be loaded for processing by either: a. typing the file name in this field - or b. searching for it. To search, press F6 from this field. A search window will appear on the lower half of the screen. An example is shown below. Select the appropriate file by typing the row number.

OPTION: __ IMPORT DROP CHARGES 1. Filename Option: _ DROP FILE SEARCH F2=NEXT 8 F4=PREV 8 File Name Create Date 1 20160930DP.csv Oct 1 12:00 2 20160929DP.csv Sep 30 14:20 ** No More Records **

Press F1 to begin the import process.


A table listing the required column headers of the data in the spreadsheet is shown below.

DEPPAY Field	Required Column Header	Required/Optional	Notes
RA Number	RA_no	Required
Amount	Amount	Required	May be positive or negative
Date	Date	Required	This will be the DBR Date assigned to the deposit/payment
FOP Code	Fop	Required	This MUST be a "C" type FOP
Auth #	Auth	Optional
Res#	Res_no	Optional	Allows for uploading reservations deposits.

STORY BEHIND THIS PROGRAM

A client with long term rentals has arranged to do Electronic Funds Transfers from renter's bank accounts. These are entered as deposits using a cashlike FOP Code into the Deposit payment file. This program is used to import these EFT deposits into CARS+. Note, deposits which are imported to closed RAs will be written as payments.