Contents
- Index
- Previous
Import Export
Export Payee Transaction
Payee details from main screen plus items that in the transaction (see fields below)
Excel format only
Fields: Payee, Other Name, Memorandum, Misc, Check Date, Amount, Type, Late, PartialPay, Redeposit
Export Transaction Detail
Excel or Quicken (qif)
Excel Fields: tran_date tran_acct_no amount tran_totItems
Quicken Fields:
!Type:Bank
D8/19' 5
U3,789.78
T3,789.78
CX
NEZD
PDeposit
MEZ-Deposit
LCategory
^
Import Payees Rules
1. Must be in an Excel File 4.0 or 5.0 format (newer versions may work)
2. Must use EZ-DepositSlip import payee template field names (See C:C:\Program Files\EZ-DepositSlip\SamplePayeeImport.xls for sample file or below for example field names)
3. The file name and path cannot contain any hyphens or punctuation (ie SamplePayee-Import.xls is invalid SamplePayeeImport.xls is valid)
4. The Excel file name (ie SamplePayeeImport.xls) must have only one worksheet with the same prefix name (ie SamplePayeeImport)
5. All fields must be text (left justified). Do not mix text with numbers (digits)
If the payee name exists, the import routine will skip that payee and all associated fields
If you attempt to import a payee and do not have any transactions (deposit history/details such as a check) that payee will not import.
Example of required Field Names (Note: import file must use the Payee_Name field)
Payee_Name Payee_Addr1 Payee_Addr2 Payee_City Payee_State Payee_Zip Payee_Notes Payee_Country Payee_Phone Payee_Mobile Payee_Email Payee_Faxno Payee_SSN Payee_DriverLic Payee_DOB
Note: Large data files with up to 10,000 records may take up to 10 minutes