Direct Deposit Automation Toolkit
Direct DepositAutomation ToolkitContentsWhat we’re doing . 1How to Participate . 1How to Prepare the Electronic Direct Deposit Excel Spreadsheet . 2Creating the Text File (Key Tab) . 3File Naming Convention. 4File Transfer to SCO . 4How to Resolve Errors . 6Solutions . 7Needed / Useful Documents. 7What we’re doingWe’re giving agencies the ability to request their Direct Deposit enrollments digitally using Excel, and send thedata in a text file to SCO through EFTP file transfer.This allows for paperless processing of Direct Deposit Open Enrollment documents, increases processing speed,and gives agencies an efficient way to document/transfer requests.Note: Agencies will be responsible for maintaining direct deposit request forms.How to Participate1. Fill out the State Controller’s Office Enterprise File Transfer New User Request form.For more information about the SCO Enterprise File Transfer Service, please see the included“SCOEFT Reference.pdf” document.2. Submit the completed form to the following e-mail: PPSDDirectDeposit@sco.ca.gov3. A follow up email will be sent, giving login credentials for the file transfer site.4. Prepare the digital 699 file according to the instructions below.1
Follow the step-by-step instructions starting on page 7 in the SCOEFT Reference document. Skip Step 3.5. Download, open, and populate the Direct Deposit Excel file with data. (see How to Prepare the ElectronicDirect Deposit Excel File below)6. Using the “Key” tab, export the data to a text file.7. Send the exported text file to SCO through EFTP.8. If errors are generated during processing, they will be returned to the sender through EFTP.9. Make any corrections, send the new exported text file to SCO through EFTP.10. Continue steps 1-4 until the open enrollment period has ended.How to Prepare the Electronic Direct Deposit Excel SpreadsheetAn Excel spreadsheet is used in lieu of the Direct Deposit form for establishing or changing a direct depositenrollment. The preferred method for Direct Deposit cancellations is still a phone call to the Direct Deposit unit.Upon opening the spreadsheet for the first time, you will be prompted to type in your three-digit agency code.oIf a mistake is made, you can always edit the agency code in the “Sheet Info” tab.To start a new record, type in data in any of the fields.ooMissing information is highlighted in yellow.Invalid information is highlighted in red.Each entry is separated by a line break, and contains the following information: Direct Deposit Request Type (New or Change)Employee Social Security Number;Employee Name (First initial, middle initial, last name)Type of Account (Checking or Savings)Bank Routing NumberBank Account NumberHere is an example of2
Creating the Text File (Key Tab)After filling out the “Sheet Entry” tab with employee data, the next step is to convert the data to a text file.The text file is created in one click by navigating to the “Key” tab, and clicking the Key button.Pushing the Key button will: Write all valid data to a text file.Prompt the user to pick a folder to save toCreate a file using the naming convention below.Move all written data from “Sheet Entry” tab to the “Already Keyed” tab.Sort data in “Sheet Entry” & “Already Keyed” tabs.Note: The Key button will only export VALID records. Any records that have missing or invalid information will notbe written to the text file.First the user is prompted to select a folder to save to.3
After a save folder is selected, a dialog box will pop up informing the user how many records were successful, andwhere the text file was saved to.The exported text file can be found in the directory that was selected.File Naming ConventionWhenever a text file is created, it is automatically named according to the following .txtAgency CodeDateForm Type No. of Records Time User NamePlease do not change the file name after it is generated, or duplicate the file.File Transfer to SCOThe exported text files should be sent to SCO through EFTP (Enterprise File Transfer Protocol).To access the SCO EFT site, navigate to https://eft.sco.ca.gov and log in using your credentials. The site is bestaccessed in Internet Explorer.4
After logging in, navigate to your agency’s folder.Files can be submitted by dragging and dropping the files into the folder.Once files are successfully uploaded, the Direct Deposit unit will complete the enrollment process.5
How to Resolve ErrorsUpon import of an agency-submitted 699 file, there are four possible validation errors: Duplicate SSN’s in fileImproper 699 file name formatNon-existent agency codeDuplicate 699 file nameIf an error is detected upon import of a 699 text file, the agency will receive email notification of the error(s). Thefollowing is an example of an error email sent out to the agency:The purpose of this email is to list identified STD699 Import File Name Validation errors forDirect Deposit Unit staff. Text file names which are not structured properly cannot beimported and therefore were not processed.AGENCY TEXT FILE NAME STRUCTURAL ERRORSAgency Code: 123Request Type (1 New, 2 Change): 1SSN (Last 4 Digits): 1234Employee Name: J T DOEType of Account (Checking or Saving): CEffective Date: 6/1/2020Submission Date: 3/5/2020Text File Date: 03052020Text File Name: rds,Direct Deposit Tracker STD-699 ImportPERSONNEL and PAYROLL SERVICES DIVISIONUpon receiving this email, the necessary corrections should be made, and a new 699 file should be sent via FTPcontaining ONLY THE CORRECTIONS MENTIONED IN THE EMAIL.6
Solutions Duplicate SSN’s in file (Multiple records for single SSN)o Using SSN provided, eliminate the invalid duplicate SSN entries.Improper 699 file name formato Make sure that the 699 text file is named according to the file naming convention above.Non-existent agency codeo Double check the agency code on the “Sheet Info” tab of the spreadsheet.Duplicate 699 file nameo Implies that a file by the same name has already been submitted. Check to make sure that aduplicate file is not being submitted, if the file is not a duplicate, rename the file according to thefile naming convention above, and re-submit.Needed / Useful Documents State Controller’s Office Enterprise File Transfer New User Request formSCO EFT Reference699 Example Text File7
How to Prepare the Electronic Direct Deposit Excel Spreadsheet An Excel spreadsheet is used in lieu of the Direct Deposit form for establishing or changing a direct deposit enrollment. The preferred method for Direct Deposit cancel
Update My Direct Deposit Last changed on: 11/28/19 Page 3 Step Action 5. The Direct Deposit page displays all of your direct deposits. In this example, change the bank account on your direct deposit checking account. Click the Direct Deposit Account link. Step Action 6. To help locate the Routing Number and Account Number on your check, click
the Pension Direct Deposit occurs 12 times per year. The Pension Direct Deposit is a condition for all new retirees. Currently, 97% of the pensioners participate in Pension Direct Deposit. Pensioners can split their payments over multiple banks or accounts. Currently, there are approximately 27,000 Direct Deposit transactions per pay period.
The Cashier Office will provide pre‐numbered 3‐part deposit slips and plastic tamper resistant deposit bags for the bank deposit. The first 3 digits of the deposit slip is a location number and will identify your department to the Cashiers and the bank. The last 4 digits is a sequential deposit number. All bank deposit slips and bags must .
1.2 European history of deposit insurance 11 1.3 Deposit insurance as an element in the financial safety net 12 2 Deposit insurance fundamentals 15 2.1 Aims and requirements of a modern deposit insurance scheme 15 2.1.1 Aims of deposit insurance 15 2.1.2 Requirements of a deposit insurance scheme 17 2.2 Guarantee promises 19
01/13 consol elec deposit 1 30.00 01/13 deposit intuit pymt soln boyette springs homeow 60.00 01/13 consol elec bill pay deposit 3 90.00 01/17 deposit intuit pymt soln boyette springs homeow 30.00 01/17 consol elec bill pay deposit 7 210.00 01/18 deposit intuit pymt soln boyette springs homeow 60.00 01/18 consol elec bill pay deposit 8 240.00
8. In the Deposit Order field: Enter the number sequence that direct deposit should process. Deposits will process in numerical order. 9. For example: 100 will go first to the account that was selected as the first deposit order, 50.00 will go to the deposit order that was selected as the second deposit order and the remaining Balance of Net
The Deposit Approver role allows one company user to create, scan, and balance a deposit, and second company user to approve that same deposit before transmitting it to the bank – A deposit approver is an internal approver within your group, not an approver at the bank (you can have multiple deposit approvers)
Hasil Budidaya Ikan Air Tawar Terhadap Peningkatan Ekonomi Masyarakat Dalam Perspektif Ekonomi Islam (Studi Pada Pekon Kebumen Kecamatan Sumberejo Kabupaten Tanggamus)”. Shalawat serta salam disampaikan kepada Nabi Muhammad SAW, para sahabat dan pengikut-pengikutnya yang setia. Skripsi ini ditulis untuk menyelesaikan studi di jurusan Ekonomi Syariah, Fakultas Ekonomi dan Bisnis Islam UIN .
