U.S. Bank Reconciling

 

NEVER hit the Back button in your browser or you will have to log in again!
Instead you can use the <<Back to Transaction List link at the bottom of the screen

  1. Log into US Bank web site at https://access.usbank.com/
    Remember that the organization short name is always "usda"
    Compatibility Update: I used US Bank with Firefox on Oct 30, 2009 and everything seemed to work (and faster that with Internet Explorer)
    There is no official update on this, but you may want to experiment.
    Some functions only seem to work properly in Internet Explorer, or on a Mac you can also use Safari, but currently you cannot use Firefox
    See the instructions below to get a desktop shortcut that forces USBank to open in Internet Explorer
  2. FIRST TIME ONLY set up an accounting shortcut
    1. Do NOT try and enter the favorites in the Managing Acct Codes Favorites.
      Go directly to your transactions and select a 'Pending' transaction
    2. Start with one of your newest transactions, as the old ones may still have the old accounting code format
    3. go to 'Comments' enter the 700# & received date as we did before
    4. Then go to 'Allocations' tab
    5. Next to the accounting code, click on the magnifying glass
    6. On the next screen, in the "Value:" box enter 3655120 (or other number for other units, eg: 3655110 or just 3655 to get a complete list)
    7. Change the "Search Type:" from "Begins with" to "Contains"
    8. click 'Search'
    9. When the accounting info appears, click on 'Select' next to the correct number, e.g. "036013655120"
    10. and then 'Save'
    11. The screen will return to the allocation section. Then scroll over to the right and check the BOC code and change that to 2670 if necessary (in the same manner as the accounting code)
    12. Select 'Save'
    13. Check to make sure they both changed in the upper right corner like you did before
    14. After both are changed then scroll to the right and click on 'Save as a Favorite'
    15. The 'My Favorites' screen will appear and you can name this account as you wish, just like you did before
    16. The next time you go into reallocate (reconcile) you can use the drop down selection and it should work. Please check to make sure all numbers are correct before 'Approving'.
     
    Important - If you have a grant, also set up a second shortcut for the grant, as you must reconcile to the grant in US Bank to have it properly credited. For example:
    For GrantUse appropriate account number
    CSREES/Simon031013655669?
    CSREES/Spooner031013655655?
    CSREES-SCRI/Havey031013655663?
    Michigan State/Jansky031013655674?
  3. Click on Transaction Management
  4. Click on View Pending Transactions
  5. Some users (not everyone) may see the following section. If you see it, you need to specify the cardholder (you), otherwise other cardholders will show up. Follow this additional step:
    specify Cardholder Account Search
    then enter Account # (Your Credit Card #) OR Your Last Name OR SS#
    search
  6. Select the transaction you want to approve by clicking on the blue underlined text for the Trans Date column
  7. Next click the Comments tab
  8. There are three boxes that we are required to fill in (This step was changed on November 10, 2009)
    1. In Agency Specific Data, we are required by headquarters to enter the complete CATS II number, 101-3655- acct# - CATS 700#, e.g.:
      601-3655-120-00045
      If the order is split into two or more charges, append "P" for partial, and "C" for the last charge that completes the order, e.g. 601-3655-120-00001P and 101-3655-120-00001C
    2. In Goods Recvd Date, enter the date received, e.g.:
      11/02/2026
    3. In the Item Description section, provide a brief description of items ordered, e.g.:
      gloves, seeds
    Example of filled-in comment fields
  9. Then click on Save Comments (Again don't forget this save step!)
  10. Click on the Allocations tab
  11. under Change to: where it says --Change Current Value--, select the favorite name you have previously defined, e.g. #FY26VCRU2670
    Be careful at the start of a new fiscal year, make sure you use the correct fiscal year when reconciling. If the purchase is from the previous fiscal year and was slow to be charged, use the previous year and not the current "26" version!
    (If Change to: is not on the screen, it means that you do not have any Active shortcuts, go back to step 2)
  12. Select the Save Allocations button to save the change (Don't forget this save step!)
  13. Make sure that the number under Accounting Code in the upper right on your Transaction Summary line has changed the 777 to the correct accounting code, if not you missed a step.
    e.g.correct is 03|10| | | | |013655120| | | | | |36 | |2670| as compared to incorrect 03|10| | | | |013655777| | | | | |36 | |3140|
  14. Select the Summary tab
  15. Click the Approve button
  16. FIRST TIME ONLY, select your default approver:
    Press Select Approver
    Enter the Last Name of your approver (supervisor); then click Search.
    If nothing shows up, try leaving the box empty and then click Search
    Click to the left of your approver to select
    (If your supervisor's name does not appear in the list, contact Dolores)
    Check the box at the bottom of the screen Set selection as your default approver so that you only have to do this once.
    then click Select Approver
  17. Click the Approve button
  18. At the bottom of the page, click on <<Back to Transaction List
  19. You have successfully "Approved" the transaction!
    (Note, the A-circle icon stands for "reAllocated", not for "Approved")
  20. Repeat the procedure for any remaining purchases

 

 

Send a Report to Julie Grogan

  1. Click on Reporting in the blue box in the upper left
  2. Click on Transaction Detail on the right side of the screen
  3. Change the following items from the default setting:
       Date section: change to Transaction Date Range:
       Change the Date boxes to an appropriate range of dates, that will include all the purchases you have just reallocated.
       Transactions Included section: click to the left of Approval Status: (For some reason this one is easy to forget)
       and click on Pending Manager Approval just below
       Transactions Included section: change Payments: to Include
       Transactions Included section: change Fees: to Include
       Additional Detail section: check both boxes (Important)
  4. Some users (not everyone) may see the following section. If you see it, you need to specify the cardholder (you), otherwise other cardholders will show up in your report. So do this:
    Group Report by
    Account Number
    click on Search for Accts
    then enter Account # (Your Credit Card #) OR Your Last Name OR SS#
    Select your name
    Select
  5. Click on Run Report at the very bottom of the screen
  6. Wait some time. When the report finally appears,
    Print the report and send it to Julie by the next morning, or save it and email it to julie.grogan@ars.usda.gov
  7. Save a copy for your file

 

 


Desktop Shortcuts to run USBank or CATS II using Internet Explorer

Since CATS and US Bank don't play well with others, you are forced to use Internet Explorer
Download these shortcuts to your desktop, they will allow you to easily access the programs directly without going through menus, by forcing the programs to open with Internet Explorer, even if your default browser is Firefox or something else
This method does not change or modify anything else! They are just normal Windows shortcuts.
Right click on the shortcut, select Save Link As... (Firefox) or Save Target As... (Internet Explorer)
and save to your desktop
CATS II with IExplorer windows shortcut
US Bank with IExplorer windows shortcut