Open Forum

Expand all | Collapse all

direct deposit exporting information

  • 1.  direct deposit exporting information

    Posted 8 days ago
    I am looking for a way to export employee direct deposit information with their contribution % or fixed amount per account.
    We need to export this information into an excel spreadsheet to send this information to our new payroll specialists to set up our employees for payroll.

    I ran the ACH report "account master" for the account# and routing # with account type so that is good but need the contribution % or fixed amount for each account as well.

    Thanks in advance for your help,
    Tammy


    ------------------------------
    Tammy Bies
    Surgical Management Professionals
    ------------------------------


  • 2.  RE: direct deposit exporting information

    TOP CONTRIBUTOR
    Posted 8 days ago
    The best options are to create a SmartList on the Direct Deposit Employee Master tables or use a query to pull from DD00200.

    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------



  • 3.  RE: direct deposit exporting information

    Posted 7 days ago

    Hi Mr. Allen;

     

    Do you have steps on creating this Smartlist; or to see if we have access to that option in our GP module.

     

    Tammy Bies

    Corporate Staff Accountant

     






  • 4.  RE: direct deposit exporting information

    Posted 7 days ago
    Tammy,

    If it's just a one time thing, it's probably not worth creating the SmartList.  Do the query that Charles suggested.  You need to have access to SQL Management Studio or have someone who does have access to run it.  Just do:  Select * from DD00200

    You can then copy and paste that into Excel.  You might need to do a little formatting, removing excess information before sending.

    ------------------------------
    Stefanie Christiana
    Glidewell Laboratories
    Irvine CA
    ------------------------------



  • 5.  RE: direct deposit exporting information

    Posted 6 days ago

    I am looking at the way to pull the direct deposit set up in each employees account based on percentage or fixed amount per each of the banking accounts. I already have the accounts and routing #'s but I should be able to generating something that give me the employee Direct deposit set up.

     

    Kind of like the report for 401K is broken out by how the employee is contributing like on the check File report.

     

    Benefit: 401K 401k Employer Match 3.00% of Gross Wages

    Deduction: 401K 401K 10.00% of Gross Wages

     

     

    Tammy Bies

    Corporate Staff Accountant

     






  • 6.  RE: direct deposit exporting information

    Posted 6 days ago

    Tammy,

    That table, DD00200, contains that information.



    ------------------------------
    Stefanie Christiana
    Glidewell Laboratories
    Irvine CA
    ------------------------------



  • 7.  RE: direct deposit exporting information

    Posted 6 days ago

    How do I help my IT understand where to go to find the DD00200 in the SQL studio if we have it?

    Our IT is not really familiar with GP so steps would be amazing to give them.

     

    Thanks.

     

    Tammy Bies

    Corporate Staff Accountant

     






  • 8.  RE: direct deposit exporting information

    Posted 6 days ago
    1. Open SQL Management Studio
    2. Connect to the SQL Server GP is on
    3. Expand databases
    4. Click on the one corresponding to the company you are working on
    5. Click New Query at the top
    6. Type in:  Select * from DD00200
    7. Hit the Execute button
    8. Right-click the top left square in the results grid and click Copy with Headers
    9. Paste in Excel


    ------------------------------
    Stefanie Christiana
    Glidewell Laboratories
    Irvine CA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role