Download Bank Transactions

Bank transactions should be downloaded daily

1. Select the Banking tab on the main menu in QuickBooks
2. From the dropdown select Online Banking > Online Banking Center
3. Answer [Yes] to the pop-up box asking for exclusive use
4. In  the Financial Intuition box select Union Bank – Web from the drop down
5. Then click the [Receive Transactions] button
6. Enter the user name and when prompted enter the password
7. Select the Graphtek account
8. The click on Download Account Detail
9. In the Account box select Graphtek-2407
10. Date range should be from the last download date to today
11. Download to box select QuickBooks
12. Then click [Next]
13. Then click [Begin Download]
14. If prompted allow the file to download
15. Leave default setting on download options
16. The file will download and you will get pop-up acknowledgment – click [OK]
17. In the Items Received window you will see Union Bank under Item
18. Click on the Button [Add Transactions to QuickBooks]
19. The Majority of the transactions will automatically be entered the window will display unmatched transactions; these have to be manually matched.
20. Click on the [Add Multiple..] button
21. Map the Payee and Account for each of the Renamed/Unmatched items. Leave deposit items for the next step
22. (see special account matching spreadsheet for guidelines)
23. Leave unmatched items (items that need input from Mike or Nona) and click [Add Selected]
24. Deposit- Match a deposit to a deposit in the Undeposited Funds Tab on the right. If there are no corresponding items listed on the right and there are still unmatched transactions they will need to be manually researched and added to Undeposited funds.
25. Once all possible transactions have been posted click the [Finish Later] button. If all transactions have been posted click the [Finish Now] button. If you have been unable to match all transactions, send email to Mike and Nona advising them to review. Click [Yes] to the pop-up window advising you of unfinished matching.
26. Close the window and release exclusive use. Close the banking browser window
27. Review check register