Guide to monthly fee collection for EFT service
Contents
1. u ss essere eee eee eee ee eee beeen neces eens 022 222 22222 Prepare the batch oiouuiuuuiuuuuusuuullllllllllsllllsis2zcIllml222cl1222c222222220222 0222 222222 Create the EFT file ss rer Next section Upload to CAFT for processing 23 Guide to monthly fee collection for EFT service Folder and file number This is the first of five sets of steps where you use the EFT Scheduler program to create a CPA standard 005 file These steps are done once a month by the designated cash management officer 2 1 Start EFT Scheduler program To open the EFT Scheduler program go to Corporate Applications click on EFT Sched uler CPA Version 2 Go to EFT Fee Collection folder Under Folder in Folders select EFT Fee Collection When prompted for a password enter our standard password to display the following screen 3 Confirm file number In Transaction Information confirm the File Number value is correct Create a CPA Standard 005 file with EFT Scheduler Folder and file number 24 Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay The file number automatically gets incremented after a file is created so you shouldn t need to change the file number value However if for some reason the file number does not get incremented the file will be rejected by Central 1 The file number of 3 is for February 2011 volumes collected in March 2011 4 Move to Name of import fil2. i m F p E Mas TIN CLE 2om mn 3 E Guide to monthly fee collection for EFT service Version 2 0 li r i te space Copyright 2015 Great Pacific Credit Union All rights reserved This document was created using Madcap Flare Contents What is this guide about 02 cece ccc eee e cece cece cee e cee eeeeeeeeseeeeeees 1 Originators in EFT Master spreadsheet 2 2 02 02 occ cece cence ee ec ec ceeecceeecceeees 4 Add DOF e FS x OE see Sete sects Sie eae ete ee Bes tees cat oo he a r ae eN Raai 5 Change oan originator RNC 9 Bi e s pelas MMERENRRRRCNCNRRMK 11 Copy monthly data from Central 1 soouuuuuuuiusssslsslllllsllssllslllllllllll2 13 Retrieving AFTM report data iussis deme t E Mead Ru de dresse Nd De ub pra sam lUa dade NU Rie sut 14 Create a comma delimited file 000 ole cece cece cece cece cece IIR rrr r noe 17 Refreshing data for upload file 2 oe ee eee ee eee cee cece ee eee renere eee 18 Copy and paste data to new spreadsheet _ 2 2 2 lec llle le cece nec cece rrr rrr rrr 20 Save new spreadsheet as csv file L 2 2 2 22000 eee eee cc ee cc el cee cece eee c eee eee accoeacc ecce 22 Create a CPA Standard 005 file with EFT Scheduler sseeeeeeeeeeeess 23 Folder dnd Me MUMDECr 22 c2c2eececcescee ceees usecase EU EGE EDER SURE GET EROS IS
3. 614637 BC LTD GA amp B FARM TOOL RENTALS LTD 11 Save and close spreadsheet Save and close the spreadsheet Originators in EFT Master spreadsheet Add an originator 8 Guide to monthly fee collection for EFT service Great Pacific CreditUnion yy Change an originator These are the steps to change originator information in the EFT Master spreadsheet You may need to change originator information because e The service type changed For example the customer may switch to CAFT F to take advantage of the efficiencies of uploading files into CAFT e The pricing changed For example we may have waived the fee for the first month e The account number changed Note The only time in the month originators information cannot be changed is when the spread sheet is locked for a day or two during fee collection 1 Have information available Find and have available the information you are going to change Make sure you have the originator number because there may be more than one originator for the customer 2 Open spreadsheet From the Z xDCM EFT folder open the EFT Master spreadsheet 3 Select tab On the bottom of the spreadsheet click the Step 1 Update Master List tab 4 Find the originator Find the originator in the list by using one of the following methods e Scroll down the list which should be sorted in alphabetical order e Press Ctri F and then type customer s name e Press C
4. Data for Upload File tab 3 Open a new spreadsheet To use to create a new comma delimited file open a new Excel spreadsheet 4 Copy data from EFT Master spreadsheet To copy the contents of cells A7 to the bottom of column F where the list of originators ends 1 Move to the top of the Step 6 Data for Upload File sheet 2 Start at cell A7 and then click down on cell A7 and drag the mouse down to where the list of originators ends in column F 3 Release the mouse button 4 Press Ctrl C or right click and click Copy 5 Paste data to new spreadsheet To ensure you paste the values rather than the formulas from the EFT Master spreadsheet 1 Goto the new spreadsheet click on cell A1 and then right click and press Paste Special 2 In the Paste section click the Values option and then click OK Create a comma delimited file Copy and paste data to new spreadsheet 2 Guide to monthly fee collection for EFT service eure EM 6 Delete tabs To delete the Sheet 2 tab right click on the Sheet 2 tab and click Delete To delete the Sheet 3 tab right click on the Sheet 3 tab and click Delete 7 Move to Save as csv file steps Go to next page Create a comma delimited file Copy and paste data to new spreadsheet 21 Guide to monthly fee collection for EFT service Brest Pacii Ure A b Save new spreadsheet as csv file This is the last of three sets of steps to create the comma delimited file These steps a
5. TA YB BE ToT a Be Wee Favorites o pep t r Favres Bot Customer Automated Funds ee Iv Transfer zi Cumeni System Dae 2011 46 23 Upload Results Your fle has been placed on the CAFT system According bo the Z7 records in your Me it contains Orginator 8090161111 File Hoc 0003 Number of Debit Bema 429 Nurnber of Creda ema o Value of Debit Rems 523 084 92 Value of Credit tems HO Total Bytes Viren 111416 Chen Mame 2011 656TRANSIMT TXT Upload to CAFT for processing Upload the file into CAFT 36 comin S 4 Move to Check CAFT report and setup spreadsheet for next use steps Go to next page Guide to monthly fee collection for EFT service Upload to CAFT for processing Upload the file into CAFT 37 Guide to monthly fee collection for EFT service reu raus EN E vem i Check CAFT report and setup spreadsheet for next use This is the second of two sets of steps to upload the CPA standard 005 file into CAFT This is the final stage of the EFT service fee collection process These steps are done once a month by the designated cash management officer 2 1 Open Activity Report in CAFT To open the Activity Report in CAFT click on Main Menu and then click View Activity Log Customer Automated Funds Transfer Cimer ppm Cie Ai Fem ii Originator Main Menu Beia rigena Er ORO IM MITI GFAC EFT FEE 5 05 Cwgeus Gega due Currency uon reli Fe
6. 466084 IH 100 TON i B 5 Move to Create EFT file steps Go to next page Create a CPA Standard 005 file with EFT Scheduler Hx Prepare the batch 3 Guide to monthly fee collection for EFT service eure Create the EFT file This is the last of five sets of steps where you use the EFT Scheduler program to create a CPA standard 005 file These steps are done once a month by the designated cash management officer 2 1 Click on Create EFT File Under Prepare Click Create EFT File 2 Check count and dollar value On EFT FILE INFORMATION make sure the transaction count and dollar value are the same as the ones checked previously If everything agrees click OK If not call the Cash Management Manager Create a CPA Standard 005 file with EFT Scheduler Create the EFT file 32 Guide to monthly fee collection for EFT service GreatPacific Credit nien EFT FILE INFORMATION File Location 7 xDCM Officers Team EFT Monthly Fee Ducem File Name TRANSMIT TXT Credit Transactions 0 0 00 Debit Transactions 439 23 084 92 E The above information provides ef the name and contents of the file to send to the bank 3 Exit EFT Scheduler To exit EFT Scheduler click File and then click Exit 4 Check for file To confirm a file called TRANSMIT TXT with today s date has been created by the EFT Sched uler program look for the file in th
7. Contents Add an originator sssuuuuuusslllllllllllllsssssssmIlllIIllzlLl2lll222I222212222222222222222 22 5 Change an originator sms sense ss ss LALALA D ODAL DDAL D ALDADA DDAL La 122222 9 Delete an originator sssuussusssslllsllss sss ses eee eee e econ cece seeeeeeeseeeeeeseeees 11 Next section Copy monthly data from Central 1 Guide to monthly fee collection for EFT service Add an originator ME usd These are the steps to add a new originator to the EFT Master spreadsheet To ensure we collect a fee from the customer each month you must follow these steps when a new CAFT originator is setup for a business customer Note The only time in the month originators cannot be added is when the spreadsheet is locked for a day or two during fee collection 1 Get information for new originators Find the following information for each new originator Required originator information Item Description Originator 10 digit number starting with 809 number provided by Central 1 The four service options are e CAFT Service option e CAFT F e CAFT A e FIP e Account number to be debited for ser Account vice charges information e Branch number 2 Open spreadsheet Source e AFT Online e LOO3 Report e AFMS or AFMT data e AFT Online e EFT Service Request and Fee Schedule EFT Service Request and Fee Schedule From the Z xDCM EFT folder open the EFT Master
8. Scheduler port Specification ci pra eg ee 577 Read races lg s 2011 12 EFT MASTER Fee Collection is Home Inert Page Layout Formulas Ee Make sure the RBA Scheduler numbers and the CAFT W numbers match to the above numbers 3 Check Preview Report information Click Preview Report and then make sure the information at the top of the report is cor rect zooms 107 Page Hl ota ure 20 Mus 2021 15 300 Page 1 Settle Account T5118 OBOS See Bebera amp rcpumt dad Currancy oT Bering Centre 7 DCM Olea Team EFT Monthly Pee Pewag TRAHSMIT TXT iDelauht 1361 Byta Airam Na Anus PEIHZI BST Iud Career Due Chatter BPA 011 4 Check dollar totals Go to the end of the report and compare the total dollar value to the total dollar value show ing on the EFT Fee Collection spreadsheet If the numbers do not match contact the Cash Management Manager Create a CPA Standard 005 file with EFT Scheduler Prepare the batch 30 Guide to monthly fee collection for EFT service ER Fee Collection v5 Armendec Atr bat Insert Page Layout Formulas 5 85 C nmma rlalimitni Fia i Eor Make sure the RBA Scheduler numbers and the CAFT 6 Payors name W numbers match to the above numbers T 8 9 10 q 12 H tep amp Data For Upload File Step 7 GL Postings ija Average 15536 28 Count3 Sum
9. Used to determine EFT service fee for each originator CAFT Web based service for issuing EFT transactions provided by Central 1 and used by business cus tomers Service used by us to collect monthly EFT fee from CAFT business subscribers Comma delimited file A file created in our case from Excel used by EFT Scheduler program to create a CPA Standard 005 file Also known as CSV ASCII or text file CPA standard 005 file File format for an uploaded EFT file created by the Canadian Payments Association This is the only file format permitted by CAFT for file upload File specifications are available from Central 1 and the Canadian Payments Association EFT Scheduler Third party program from R A Anderson used to create CPA Standard 005 file for upload to CAFT Glossary 41 Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay G Greenbar Application used by Great Pacific to view Central 1 reports LOOS Monthly report provided by Central 1 and posted to Z drive showing CAFT originators service type and limits Master EFT Spreadsheet Excel spreadsheet of CAFT originator data used to keep track of originators and for EFT service fee collection Latest file is saved to Z xDCM EFT folder O Originator Term used to describe each individual CAFT service subscribed to by a business customer Ori ginator meaning the customer who originates EFT transactions A business customer who sends EFT
10. Caen EEN 9 Locate the AFTM report Scroll down the list of reports until you find the following report AFT Monthly Fee Report aft m080916000 rpt 10 Open the report To open the report double click on the report 11 Convert the report to a spreadsheet To convert the report into data that can be copied to our spreadsheet on the Quick Access Toolbar click Display Database Table L CREDIT UNIQ i E TYTRALL 92 28 42 Arm ososasonn DEplay Database Table 7 E CAD APT TON AT HLY FILE ROEFORT 12 Copy data to EFT Master spreadsheet Copy and paste the four columns of data into the space you created in the EFT Master spreadsheet 13 Sort data To check for any originators that have not been added to the spreadsheet you need to sort the new data in originator number order as follows 1 In the Originator column header click the Autofilter sort arrow 2 From the menu click Sort Smallest to Largest 14 Save the spreadsheet Save the spreadsheet 15 Move to Creating a comma delimited file steps Go to next page Copy monthly data from Central 1 Retrieving AFTM report data 1 6 Create a comma delimited file GENE GENE CN Setup customer on CAFT service Type originator information into Excel Sn wo customer far EFT senes i a 2 Beer through Central 1 spreadsheet You are hare mm Create text file of monthly fee data Copy monthly data from Central 1 into
11. Iud Create a comma delimited file Refreshing data for upload file 18 Guide to monthly fee collection for EFT service reat Pacific Credit Union me i 5 Copy formulas down You now need to copy the row 7 formulas from row 8 to row 999 To select the designated area and copy the formulas 1 Click on cell A8 2 To select cells from A8 to A99 hold down the Shift key press the End key and then press the Down Arrow key 3 To paste the formulas press Ctrl V or right click and click Paste 6 Check month Make sure the month in cell E is the correct month for the month of activity you are col lecting the fee If the month is not correct go to cell A1 and adjust the minus number accordingly 7 Save the spreadsheet Before moving to the next steps save the spreadsheet 8 Move to Copy and paste data to new spreadsheet steps Go to next page Create a comma delimited file Refreshing data for upload file 19 Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay Copy and paste data to new spreadsheet This is the second of three sets of steps to create the comma delimited file These steps are done once a month by the designated cash management officer 2 1 Open EFT Master spreadsheet If the EFT Master spreadsheet is not already opened from the Z xDCM EFT folder open the EFT Master spreadsheet 2 Select tab On the bottom of the spreadsheet click the Step 6
12. deposits The EFT service provided by Central 1 our service provider is called CAFT or Customer Auto mated Funds Transfer Why are we collecting a fee Each month we are charged fees by Central 1 for the transactions and files submitted by our cus tomers using CAFT A transaction is the individual debit or credit transaction and the file is the batch of transactions sent for processing at one time by the business customer We charge a fee to recover our Central 1 costs and to make some money from this service Who is the intended audience The audience for this guide are the cash management officers who add and maintain the EFT ori ginators in the master spreadsheet and the one or two officers who collect the monthly fee from the customers Whatis this guide about 1 Guide to monthly fee collection for EFT service Roles and Responsibilities The following table shows the roles and responsibilities associated with the EFT service fee col lection Role Responsibilies Cash Management Officer 1 e Cash Management Officer 2 e Cash Management Manager Add new originators Modify existing originators Delete originators Add new originators Modify existing originators Delete originators Perform monthly fee collection pro cedures Answer questions from officers Update this guide Where are the steps for collecting the setup fee The steps for collecting the initial setup fee are not cove
13. folder open the EFT Master spreadsheet 3 Select tab On the bottom of the spreadsheet click the Step 4 Copy in AFTM Data tab 4 Delete AFTM data in spreadsheet To prepare the spreadsheet you have to first delete the AFTM data in the spreadsheet To delete the data 1 Click on cell B3 2 Scroll down to where the data in column F ends 3 To highlight all the data in columns B to F hold down the Shift key and then click on the last cell with data in column F 4 When all the data is highlighted press the Delete key 5 Open Greenbar Open Greenbar and sign in using your Windows password 6 Find folder Find the following folder GPAC CUCBC REPORTS MISCELLANEOUS REPORT Copy monthly data from Central 1 Retrieving AFTM reportdata 14 Guide to monthly fee collection for EFT service Great Pacific Credit Union Nl k Open Document 5 RETURNS i REINSTAT sp i niii ihi HOHER FH E aD 7 Change File Date In the File Date section in both the From box and the To box select the last day of last month 8 Widen Document s columns To locate the AFTM report you need to be able to read the contents of the column inform ation To widen the Document Name column in the Document s section drag the column sep arator to the right Do the same for the File Name column Copy monthly data from Central 1 Retrieving AFTM report data 1 5 Guide to monthly fee collection for EFT service erent racc Crema
14. in these columns the originator number you typed may be wrong For example if the originator is using the service for biweekly payroll for 20 employees and the AFTM Trns column column AD is not showing a volume of around 40 check the originator number you typed Originators in EFT Master spreadsheet Add an originator Guide to monthly fee collection for EFT service 9 Repeat steps for next originator If you have more originators to add repeat steps 1 through 8 10 Sort spreadsheet After you have added all the new originators to make it easier for you and other people to find originators sort the spreadsheet in Customer Name order as follows 1 In row 13 in the Customer Name Primary Sort column header click the Autofilter sort arrow 2 From the menu click Sort A to Z ES id 04 2011 12 EFT MASTER Fee Collection v de Microsoft Excel non commercial use ceo tm Home Insert Paget Layout Formulas Data Review View Developer Ameba F o og amp pis d fe 123 Place Co op Housing Association 13 m zi d Tent i gortAtoz e axi SartZtes a ro 16 e Sort by Calor 17 BW A Fitter by Calor Test Filters LAC ickthe anowi in this column header ae Step 2 SelectSort Ato Z Search P Select A amp 123 Place Co op Housing Associsbor 7 123455 CANADA INC v 1978 Burnaby Ltd 5A 381234 BC LTD jl 54321 BC LTD i
15. payments and who also collects payments with EFT will have two separate EFT originators Originator number Unique 10 digit number for CAFT subscriber provided by Central 1 Number starts with 809 Num ber is made available in Central s AFT Online and Central s L003 report Glossary 42
16. spreadsheet 3 Select tab On the bottom of the spreadsheet click the Step 1 Update Master List tab Originators in EFT Master spreadsheet Add an originator 5 Guide to monthly fee collection for EFT service 4 Copy template row You now need to copy row 14 the template row which contains all the formulas and insert it into a new row in the spreadsheet To copy row 14 1 Select the row by clicking on the number 14 on the leftmost side of the spreadsheet 2 Press Ctrl C or right click and then click Copy 5 Insert template row to create new row To insert the template row anywhere below row 14 1 Select any row below row 14 2 Right click on the selected row s number on the leftmost side of the spreadsheet 3 From the menu click Insert Copied Cells aa Home C F 201112 EFT MASTER Fee Collection v5 xlsx Microsoft Excel non commercial use gt ell Insert Pagelayout Formulas Data Review View Developer Acobat Qj c dg 8 fx 8050007271 v Step 5 Movedown and Insert Copied Cells Clear Contents RM Forma Celi Bow Height Hide jnhide Originators in EFT Master spreadsheet Add an originator 6 Guide to monthly fee collection for EFT service Great Pacific CreditUnion dy 6 Type originator information into new row Type required information for the new originator into the new row IMPORTANT 1 To convert
17. EDEL E GE SENE DSE PSI EE 24 Name or import file oc cos chante en teduens sneen neuen ennen ennen eee ennen toe aad andae Esa da ad mu di E E E 26 SU eC 2 og ce RTI we ee NER KV 27 Prepare the batch ioe oe eae eee cen de ened cue ee Lees ME I nse aie hain een ELE LE 29 Greate Te EFT ME aie ene eee oc eudace E bie euch sone bade tade eel peesuceseatece seca 32 Upload to CAFT for processing ssssssssssslmIssI Is ee cee cecceesceeeseeeeseeeeeee 34 Upload the file into CAFT RE 35 Check CAFT report and setup spreadsheet for next use ___ 2 22 eee eee eee eee ccc eee e ee eceeeeees 38 GIOSS AE NNCRRRRRRETRREERRRERTRRRER P CEM 41 table of contents i Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay What is this guide about This guide provides step by step instructions on how to setup and collect the monthly EFT ser vice fee from customers This section answers some basic questions about the EFT service and shows what the monthly fee collection process looks like What is the EFT service EFT or electronic funds transfer is the service used by many of our business customers to collect money from customers or pay money to suppliers and employees For example property man agers use EFT to collect the monthly maintenance fee from strata property owners Many busi nesses use EFT for payroll direct
18. a Fia ipia Rp Pape P irm ap ik DPF upirk Perig Ween diate bo Pane Tura Dia Ferte Lal Uinta Pireja Parere Euer os Mpasi CAF T Data Eje rem Cte AF T aeree Ahora Upinades Pies Fe Pelee Duas duane Dnhy Uuaruj ei Peper Pepe Horr cede oe anas cans Cr ran kr a 2 Check report Check the Activity Log Information to confirm the file completed successfully If the file did not complete successfully contact the Cash Management Manager Upload to CAFT for processing Check CAFT report and setup spreadsheet for next use 38 dD At i uiid dd Lnd renee eh a Gu hitg pareri doct cmniral cem sis arma actes vw fi Li e x cco Fr Ferber CNT i i H E ocm Eam myr Tak e ustomer Automatec g J Funds Transfer Pere T Os a TOCH NT NN Help Current System Date 2011 Feb 16 View Activity Log Information Activity Log Search Criteria Activty Date From pon Feb 16 to fon o Feb fie Today mona Created Originator Message Date By ID Type File Name 2011 Feb 16 851 Valdwefie 5090161111 2010DecTRANSMIT TXT L Vakten of this fie completed successtuly Z011 Fab 12 2851 Vaii 5018111 i 20 ODE TRANSAT TET Vakuns Qu TT Lisl aia ny 9 EE Fie Creseon Number pog Page i 3 Log off from CAFT To log off from CAFT click Log Log Off 4 Create new EFT Master Fee Collection spreadsheet TO prepare the spreadsheet f
19. are the steps to delete an originator from the EFT Master spreadsheet You will need to delete an originator when the service is terminated for the business customer Note e The only time in the month originators cannot be added is when the spreadsheet is locked for a day or two during fee collection e Do not delete the originator until the fee for the final activity is collected from the cus tomer This may mean that you need to wait until next month before deleting the ori ginator 1 Check to make sure Before deleting an originator from the EFT Fee Collection spreadsheet check to make sure either e an online request has been submitted via AFT Online to close service or e the originator no longer appears on the L003 report 2 Open spreadsheet From the Z NXxDCM EFT folder open the EFT Master spreadsheet 3 Select tab On the bottom of the spreadsheet click the Step 1 Update Master List tab 4 Find the originator Find the originator in the list by using one of the following methods e Scroll down the list which should be sorted in alphabetical order e Press Ctri F and then type customer s name e Press Ctrl F and then type originator number e Click the Autofilter sort arrow in the Customer Name column and then type the cus tomer s name in the search box and click OK Originators in EFT Master spreadsheet Delete an originator 11 Guide to monthly fee collection for EFT service reat Pac
20. e following folder Z xDCM EFT Monthly Fee Posting 5 Rename file From Windows Explorer rename the file using the following convention yyyymmmTRANSMIT TXT for example 2011FebTRANSMIT TXT 5 Move to Upload to CAFT for processing steps Go to next page Create a CPA Standard 005 file with EFT Scheduler Create the EFT fie 33 Upload to CAFT for processing Setup customer on CAFT service Type originator information into Excel Sn ub customer for EFT senes i T ir p through Central 1 spreadsheet You ane ena 4 Create text file of f monthly y fee data Copy monthly data from Central 1 inte from spreadsheet data and then Upload CPA standard 005 file into CAFT Excel spreadsheet convert to CPA standard 005 file using tor processing EFT Scheduler program Contents Upload the file into CAFT ssssssssssssllllIIIII cece cece cece cece e ee eeeeceeesseeeeeeeseee 35 Check CAFT report and setup spreadsheet for next use 2 222 e cece eee eee ec ceeeees 38 34 Guide to monthly fee collection for EFT service erent races Cremona Rn 1 Upload the file into CAFT This is the first of two sets of steps to upload the CPA standard 005 file into CAFT This is the final stage of the EFT service fee collection process These steps are done once a month by the designated cash management officer 2 1 Log into CAFT 1 Tolog into CAFT click the link for CAFT 2 Enter your user ID and pa
21. e steps Go to next page Create a CPA Standard 005 file with EFT Scheduler Folder and file number 2 5 Guide to monthly fee collection for EFT service Name of import file This is the second of five sets of steps where you use the EFT Scheduler program to create a CPA standard 005 file These steps are done once a month by the designated cash management officer 2 1 Go to Organization Information in EFT Scheduler Under Tools in User Profile select Organization Information 2 Change the Import File name In Import File Information in Import File type the name ofthe file you are going to upload into EFT Scheduler 3 Save changes To save the changes click Save Setup 4 Move to Set due date steps Go to next page Create a CPA Standard 005 file with EFT Scheduler Name of import file 20 Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay Set the due date This is the third of five sets of steps where you use the EFT Scheduler program to create a CPA standard 005 file These steps are done once a month by the designated cash management officer 2 1 Determine due date for file Determine the date you want Central 1 to process the EFT transactions With the file upload version of CAFT you can upload transactions today with a due date up to 7 days into the future Make sure the date is not a weekend or statutory holiday Typically you should select a date two business da
22. from spreadsheet data and then Upload CPA standard 005 file into CAFT Excel spreadsheet convert to CPA standard 005 file using tor processing EFT Scheduler program Contents Refreshing data for upload file 00 2 20 lec ee cee ee ee ec ceeeeceeeeeees Copy and paste data to new spreadsheet LlL ll e eee cece cece cece ee eeeees Save new spreadsheet as csv file _ 0 022 2 eee cee eee erne eee rener Next section Create a CPA Standard 005 file with EFT Scheduler 17 Guide to monthly fee collection for EFT service ren race vro S Refreshing data for upload file This is the first of three sets of steps to create the comma delimited file These steps are done once a month by the designated cash management officer 2 2 Open spreadsheet If the spreadsheet is not already opened from the Z xDCM EFT folder open the EFT Master spreadsheet 3 Select tab On the bottom of the spreadsheet click the Step 6 Data for Upload File tab 4 Copy formula row To copy the formulas from cells A7 to J7 1 Select cells A7 to J7 by holding your mouse button down and dragging across these cells 2 Release the mouse 3 Press Ctrl C or right click and click Copy jid 0 RA EFT MASTER Fee Collection vi Amended lam Miaka Microsoft Excel non commercial use Peay kaart Paget Layee Formulas Tats Rey Vue Deep Birgit E Make sure the RBA Scheduler numbers and the CAFT Pa runes mate iL wi
23. ific Credit Union me i 5 Delete row Right click on the row number of the row you need to delete and then click Delete 6 Save and close spreadsheet Save and close the spreadsheet Originators in EFT Master spreadsheet Delete an originator 12 Copy monthly data from Central 1 3 Sion up customer for EFT service Setup customer on CAFT service Type originator information inte Excel iL IURIS aia through Central 1 spreadsheet Create text file of monthly fee data Copy monthly data from Central 1 into from spreadsheet data and then Upload CPA standard 005 file into CAFT Excel spreadsheet convert to CPA standard 005 file using for processing EFT Scheduler program d Cie Contents Retrieving AFTM report data ssssssssssllsllsIlsI slm e cece eceeseeeseeeseesseessenees Next section Create a comma delimited file 13 Guide to monthly fee collection for EFT service GreatPacific CreditUnion pay Retrieving AFTM report data This topic shows the steps for downloading and copying the AFTM report These are the first set of steps done once a month by the designated cash management officer 2 1 Send notice to not use spreadsheet To make sure no one uses the EFT Master spreadsheet until you complete the fee col lection send an email to all the cash management officers telling them to not use the spreadsheet until further notice 2 Open spreadsheet From the Z xDCM EFT
24. or the next use and save the spreadsheet used to create the file you uploaded into CAFT 1 Open the latest EFT Fee Collection spreadsheet 2 To create a new file click File then click Save As 3 Type a new file name for the next month using the following naming convention yyyymm EFT Master Fee Collection xlsx for example 2011 03 EFT Fee Collection xlsx 4 Close all files Upload to CAFT for processing Check CAFT report and setup spreadsheet for nextuse 39 Guide to monthly fee collection for EFT service Brent Facile Cre Unin m i 5 Move the old Master spreadsheet to the archive folder Go to the Z drive and move the old EFT Master Fee Collection spreadsheet to the archive folder at Z xDCM EFT xArchive 6 Notify officers the new spreadsheet is available for use To let the officers know that you have finished the fee collection for the month and that there is a new EFT Master Fee Collection spreadsheet they can use send all the officers an email Upload to CAFT for processing Check CAFT report and setup spreadsheet for next use 40 Guide to monthly fee collection for EFT service GreatPacific CreditUnion iy Glossary A AFT Online Web based service from Central 1 available through Central 1 s secure website used to setup ori ginators and change limits Also known as Web Mainframe AFTM Monthly Report Report from Central 1 showing number of files total transactions and total charge for files for CAFT subscribers
25. re done once a month by the designated cash management officer 2 1 Click to save On the new spreadsheet click File and then click Save As 2 Select folder Change the folder to Z xDCM EFT FEE Automation Monthly Fee Posting NRBANEFTFEE 3 Give file name Type the file name using the following convention yyyymmm e g 2011Feb csv 4 Indicate file type In Save as type click CSV Comma delimited csv and then click OK to save file 5 Close file Close the file If you leave it open the conversion steps will not run 6 Move to Create a CPA Standard 005 file with EFT Scheduler steps Go to next page Create a comma delimited file Save new spreadsheet as csv file 22 Create a CPA Standard 005 file with EFT Scheduler Setup customer on CAFT service Type originator information into Excel Sgn up customer for EFT service i hf gn up cust l through Central 1 spreadsheet You are hene Create text file of monthly fee data Copy monthly data from Central 1 into from spreadsheet data and then Upload CPA standard 005 file into CAFT Excel spreadsheet convert to CPA standard 005 file using tor processing EFT Scheduler program si X Contents Folder and file number seesnsnnllIIIIIIIIIImImIlmllIlIllllLlIlllIllllllllllllllllllllll 24 Name of import file 2 00 00 colic ccc cece e ss eee LPLP ALD DALDA DALDAL LALL aLaaa a 26 Set the due date
26. red in this guide For the steps for col lecting the initial setup fee see Procedures for collecting the setup fee for the EFT service What is this guide about Guide to monthly fee collection for EFT service Great Pacific Credit Union b What does the monthly EFT fee collection process look like The following diagram gives you a high level view of the 6 stages in the EFT fee collection pro cess This guide covers stages 3 to 6 Sign up customer for EFT Setup customer on CAFT Du Rad intei ation into Excel spread service service through Central 1 sheet ICAFT CAT gt Wo gt a Sal Create Textile of monthly fee data from Upload CPA standard 005 Copy monthly data from py y spreadsheet data and file into CAFT for pro ae nich Orel io Gir cessin P standard 005 file using J EFT Scheduler program HAE CAFT 5 Bus S GERE unc 000 Whatis this guide about 3 Originators in EFT Master spreadsheet ELIT IBI Setup customer on CAFT service Type onginator information into Excel Sogn up customer tar EFT senace mini marin ege i ae a rel Es ri obe through Central 1 spreadsheet Create text file of monthly fee data Copy monthly data from Central 1 into from spreadsheet data and then Upload CPA standard 005 file into CAFT py E nc Excel soneadsheet convert to CPA standard 005 file using for processing EFT Scheduler program gt Xs H Cie
27. ssword and then click Log On Note CAFT only allows three tries before you are locked out and need to get Central 1 to reset you password 2 Go to Upload CAFT Data File On the Main Menu click Upload CAFT Data File Customer Automated Funds Transfer ed EC NN Curam mamme Ai Fem ii Originator Main Menu fala va Gigas ir BOGOTA I1TI GFAC EFT FIT a 20 Cage mpa Mame Gamea Tira apaa oTe heii Pep P irm bogre o em Updates aia a ST Prier bjir Uefa Pireja Parere Ebi ohi D pea CAET Duta Fe deer PE io CART Sara duos Lips den P ze Desh ha da merce Dep R Minna Peper Pepe Horr cede oe anas cans Cr rani se Meraner hie Lon fae Bepi Mars itasse LR egt len CR Crave Pup lr Cumas iir fe EE T a RIEN 4 3 Locate file to be uploaded Click Browse find the file to be uploaded and then click Upload Data File Upload to CAFT for processing Upload the file into CAFT 35 Guide to monthly fee collection for EFT service Sron Pacii Grodi Hulen al Custom er Autom ated Funds Ld Main Menu i Current System Dale 2011 Mar 28 Upload CPA STDO005 AFT Files 4 Check Upload Results information Compare the information in the Upload Results page to the spreadsheet If the numbers match the spreadsheet click Accept If the numbers don t match click Decline and contact the Cash Management Manager volt Internet Explorer pr ided by inventure X aded xj Cose
28. the originator number to a text value for sorting purposes type an apostrophe into column A before you enter the originator number 2 Foran explanation of the contents of the cell refer to comments in column headings Cells with comments have a red triangle in the top right corner of the cell 3 Do not type into the cells that have a formula Refer to the row 11 heading to see which cells contain formulas 4 If the account to be debited is not Z1 type Z and the Z number into column M 5 For any nonstandard pricing values please insert a comment in the cell containing the non standard arrangements to explain why the customer was given the nonstandard pri cing To insert a comment in a cell right click on the cell and then click Insert Com ment 7 Reformat row after entering the originator information To indicate that you have typed all the originator information e Select the row change the font colour to black and remove the bold format 8 Verify new originator against monthly data for originator Actual monthly volumes and charges data from Central 1 is added to the spreadsheet each month The monthly originator data shows in columns Z to AE of the spreadsheet If you know the new originator had no activity in the previous month move to next step Compare the numbers in columns Z to AE to what you expected for the originator If the actual data doesn t seem reasonable for the new originator or there are no numbers
29. trl F and then type originator number e Click the Autofilter sort arrow in the Customer Name column and then type the cus tomer s name in the search box and click OK Originators in EFT Master spreadsheet Change an originator 9 Guide to monthly fee collection for EFT service Great Pacific CreditUnion dy 5 Type changed originator information Type changed information for the new originator into the appropriate cell IMPORTANT 1 To convert the originator number to a text value for sorting purposes type an apostrophe into column A before you enter the originator number 2 Foran explanation of the contents of the cell refer to comments in column headings Cells with comments have a red triangle in the top right corner of the cell 3 Do not type into the cells that have a formula Refer to the row 11 heading to see which cells contain formulas 4 If the account to be debited is not Z1 type Z and the Z number into column M 5 Forany nonstandard pricing values please insert a comment in the cell containing the non standard arrangements to explain why the customer was given the nonstandard pri cing To insert a comment in a cell right click on the cell and then click Insert Com ment 6 Save and close spreadsheet Save and close the spreadsheet Originators in EFT Master spreadsheet Change an originator 10 Guide to monthly fee collection for EFT service Great Pacific CreditUnion yy Delete an originator These
30. ys from the day you will upload the file into CAFT 2 Goto Prepare Click on Prepare 3 Set the due date To set the due date for the file 1 In the first dropdown box below the Folders section click Scheduler Import unless it is already selected 2 In the second dropdown box below the Folders section click Set Due Date unless it is already selected 3 In Set Date select the due date you decided on earlier Create a CPA Standard 005 file with EFT Scheduler Set the due date 27 Step 2 Click Set Due Date Step 3 Typedue date Usually two daysfrom date file uploaded to CAFT 4 Move to Prepare batch steps Go to next page Create a CPA Standard 005 file with EFT Scheduler Set the due date 28 Guide to monthly fee collection for EFT service Great Pacific Credit Union N T Prepare the batch This is the fourth of five sets of steps where you use the EFT Scheduler program to create a CPA standard 005 file These steps are done once a month by the designated cash management officer 2 1 Click on Prepare Batch To prepare the file records under Prepare click Prepare Batch 2 Is record count correct Make sure the number of records processed in EFT Scheduler matches the Transaction Count value in the EFT Fee Collection spreadsheet If the numbers do not match contact the Cash Management Manager Create a CPA Standard 005 file with EFT Scheduler Prepare the batch 29 00 00
Download Pdf Manuals
Related Search