Download Version 2 - ChurchWatch

Import and Export Managers
Step 3 - Performing the Export
Once all desired records have been checked, click the FINISH button to begin the export.
When prompted, enter the file name of the file you want to place the export data in. You may
enter a file extension but it will be replaced with .IIF (QuickBooks) or .QIF (Quicken). For our
example above, here is the sample QuickBooks file created. The first 3 lines are header
information telling QuickBooks what is in this file.
!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,MEMO
!SPL,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,MEMO
!ENDTRNS
TRNS,DEP,11/15/01,Checking Account,Eldon Peters,30.00,
SPL,DEP,11/15/01,Budget,Eldon Peters,-30.00,
ENDTRNS
TRNS,DEP,11/15/01,Checking Account,Helen Smith,40.00,
SPL,DEP,11/15/01,Missions,Helen Smith,-40.00,
ENDTRNS
TRNS,DEP,11/15/01,Checking Account,Shiela Peters,5.00,
SPL,DEP,11/15/01,Kidz Club,Shiela Peters,-5.00,
ENDTRNS
TRNS,DEP,11/15/01,Checking Account,Joe Smith,50.00,
SPL,DEP,11/15/01,Missions,Joe Smith,-50.00,
ENDTRNS
Refer to your QuickBooks documentation for information on importing the file.
For our example above, here is the sample Quicken file created:
D2001.11.15
T30.00
NDEP
M
PEldon Peters
Lbudget
^
D2001.11.15
T40.00
NDEP
M
PHelen Smith
LMissions
^
D2001.11.15
T5.00
NDEP
M
PShiela Peters
LKidz Club
^
D2001.11.15
T50.00
NDEP
M
PJoe Smith
LMissions
^
“D”
“T”
“N”
“M”
“P”
“L”
stands
stands
stands
stands
stands
stands
for
for
for
for
for
for
deposit date
transaction amount
transaction type (DEP = deposit)
memo and holds your comment
payee
catagory (account)
Refer to your Quicken documentation for information on importing the file.
ChurchWatch User’s Guide
5-14