Last update: 04/15/2008
Card Data Export and Import Options
US Bank offers several options with regards to exporting card data from Access Online and importing into your GL. US Bank operates on a self-service model so that you do not have to rely on the bank to administer your process. This is a proven concept that allows organizations to independently manage their data and facilitates easier adaptation when changes in systems occur.
Transaction Detail Report: This is the most basic of exports and is simply pulling transaction detail from Access Online and placing into an Excel report. You can then manipulate the data in Excel to meet your GL import requirements. You can extract data based on date range, approval status, department, MCC, etc. This form of extract is most commonly used by programs not using Transaction Management.
Extract Administrator: This is a common form of extract for those programs using Transaction Management and Approval. You can run a transaction extract at any time based on date, approval status, etc. When using this function the transactions extracted become locked in Access Online so that no changes can be made to account coding. This data extract is then formatted into the SBF – Statement Billing File and delivered to the Data Exchange box in Access Online.
SBF – Statement Billing File: This is a straight ASCII character fixed field length variable file/record type. This file contains all of the data passed by VISA and includes account code information. US Bank can automatically deliver this file to your Access Online Data Exchange box based on your cycle date or it can be a daily feed. Additionally, the SBF can be set up to be delivered via FTP.
