US20070192222A1 - System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction - Google Patents
System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction Download PDFInfo
- Publication number
- US20070192222A1 US20070192222A1 US11/689,958 US68995807A US2007192222A1 US 20070192222 A1 US20070192222 A1 US 20070192222A1 US 68995807 A US68995807 A US 68995807A US 2007192222 A1 US2007192222 A1 US 2007192222A1
- Authority
- US
- United States
- Prior art keywords
- folio
- data
- item
- item code
- host computer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 238000004519 manufacturing process Methods 0.000 title description 2
- 238000013507 mapping Methods 0.000 claims abstract description 12
- 238000000034 method Methods 0.000 claims description 66
- 238000012545 processing Methods 0.000 claims description 26
- 230000008569 process Effects 0.000 claims description 17
- 230000003750 conditioning effect Effects 0.000 claims description 9
- 238000003860 storage Methods 0.000 claims description 9
- 230000029305 taxis Effects 0.000 claims description 8
- 230000005540 biological transmission Effects 0.000 claims description 7
- 238000001914 filtration Methods 0.000 claims description 5
- 238000005201 scrubbing Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 22
- 238000004891 communication Methods 0.000 description 17
- 230000006870 function Effects 0.000 description 15
- 230000008901 benefit Effects 0.000 description 7
- 238000004590 computer program Methods 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 4
- 238000007726 management method Methods 0.000 description 4
- 230000008520 organization Effects 0.000 description 4
- 238000004422 calculation algorithm Methods 0.000 description 3
- 235000012054 meals Nutrition 0.000 description 3
- 230000001413 cellular effect Effects 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000033001 locomotion Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 240000005020 Acaciella glauca Species 0.000 description 1
- 208000022120 Jeavons syndrome Diseases 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000001143 conditioned effect Effects 0.000 description 1
- 238000007596 consolidation process Methods 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000013481 data capture Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 230000035515 penetration Effects 0.000 description 1
- 235000003499 redwood Nutrition 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000013515 script Methods 0.000 description 1
- 230000011664 signaling Effects 0.000 description 1
- 230000026676 system process Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0235—Discounts or incentives, e.g. coupons or rebates constrained by time limit or expiration date
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0238—Discounts or incentives, e.g. coupons or rebates at point-of-sale [POS]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
Definitions
- the present invention generally relates to providing data to customers on-line, and more particularly, to a system and method to enable charge card holders and others with a certain web application to access charge card detail on-line via a network and view transaction level detail relating to travel expenses, such as hotel expenditures.
- previous reports and/or transaction card billing statements provided limited information regarding the nature of the transaction card spend transaction.
- This limited information may include, for example, an amount billed against a transaction card on a given date for a specific hotel in a specific city.
- clients were particularly unsatisfied with the amount of hotel folio data classified in “Other” and “Miscellaneous” categories, particularly because existing systems were unable to present hotel folio data at a detailed level.
- a hotel charge may appear on a billing statement as a single line item in the amount of $1,360.
- An apparatus and method of the present invention provides on-line financial account spend data to users.
- item code mapping the present invention enables an account issuer to compile and present hotel spend transactions with descriptive item codes, specifying previously unknown details regarding general spend transactions.
- the method and apparatus retrieve data from multiple sources and conditions the data according to pre-configured item code to item code mappings to compile the hotel folio data.
- the hotel folio data is then provided to the client via any means known in the art.
- FIG. 1 is a schematic diagram of a system for providing on-line account data in accordance with exemplary embodiments of the present invention
- FIG. 2 is a schematic diagram of components of computers and servers used in the system in accordance with exemplary embodiments of the present invention
- FIG. 3 is a flow chart of an exemplary method to provide on-line account data in accordance with exemplary embodiments of the present invention
- FIG. 4 is a diagram of a web page for submitting an on-line request for account data in accordance with exemplary embodiments of the present invention
- FIG. 5 is a diagram of a web page for providing on-line account data in accordance with exemplary embodiments of the present invention.
- FIG. 6 is a diagram illustrating a web page for a user to log into the system in accordance with exemplary embodiments of the present invention
- FIG. 7 is a diagram illustrating a detailed web page for submitting an on-line request for account data in accordance with exemplary embodiments of the present invention.
- FIG. 8 is a diagram illustrating a web page for providing on-line account data in accordance with exemplary embodiments of the present invention.
- FIG. 9 is a combination process flow chart and diagram showing the application of predefined logic in order to map hotel folio line items to more descriptive hotel folio line items accordance with exemplary embodiments of the present invention.
- FIG. 10 is a combination process flow chart and system diagram of data processing and data movement for matching folios with transaction data in accordance with exemplary embodiments of the present invention.
- FIG. 11 is a combination process flow chart and system diagram of a system and method for processing hotel folio line items to ensure proper assignment if item codes and item code descriptions in accordance with exemplary embodiments of the present invention.
- Exemplary embodiments include a web application that enables access to a client's specific account transaction detail for the purposes of, for example, vendor negotiation and card program management.
- the charge transaction detail includes, for example, travel transaction detail, corporate card detail, loyalty information detail and corporate purchasing card detail.
- the transaction detail is global in nature (e.g., data captured from all regional systems) and can include third party data regarding card, travel and hotel, as well as reference data which can be purchased from multiple industry vendor sources.
- charge card is intended to include transaction cards, credit cards, debit cards, stored value cards, transponders, and non-card based financial accounts.
- the web application and web page access that clients use to access the data and create report views of the information can be implemented with, for example, a third party software package called MicroStrategy from a company called MicroStrategy.
- MicroStrategy a third party software package from a company called MicroStrategy.
- the product enables clients to manage their corporate program with a host as the card provider, along with their own travel management performance and policies.
- the product enables the clients to negotiate purchase opportunities with key vendors (airlines, hotels etc).
- the system can also include a “create a report capability” which allows users to add filters and data elements to an existing report format and create a report specific to their needs and data.
- the system includes access for the clients to individual market level detail, along with LAC, EMEA, and JAPA (Latin America/Caribbean, Europe, Middle East, Africa, and Japan, Asia, Pacific, Australia) transaction detail.
- the system also allows report generation wherein the reports include LID (line item detail) data from the clients' Corporate Purchase Card (CPC) purchases, thereby allowing the user to view specific detailed transactions from their selected vendors.
- This feature includes full hierarchy information and enhanced reporting capabilities.
- the system also includes Corporate Purchasing card data in its warehouse, which allows clients to view their total program with the host. It also allows clients to combine the data sets and have a single report generated on both CPC and Card spend. The functionality and access allows faster delivery of information to clients which results in, for example, increased client loyalty.
- the web application eliminates or reduces the need for any ‘helper’ applications on the web browser, provides a more scalable application and allows clients to access certain data and create report views of the information.
- Removal of the ‘helper apps’ e.g., Active-X or Java Applets
- the invention also eliminates the need for a separate security log-in function and allows implementation of a single sign-on capability. As such, clients can log into a single portal and are automatically logged into applications within the portal without having to re-authenticate.
- a product implementing an exemplary embodiment is a combination of function, features, data and support service. More particularly, in one embodiment, the product is accessed via a web site which is specifically focused on corporate accounts, the program administrator and the corporate card member.
- the database is a combination of charge card information (transactions) from every region and country that the host operates as a wholly owned organization or as a franchise or partnership. The collection, consolidation, data management and conditioning of that data are unique in several areas.
- the database adds and conditions data with proprietary information relating to the host supplier network. This allows the clients using the product to view and report on their corporate spend in key categories (e.g., industries).
- the data conditioning process for the database captures and consolidates multiple data sources from industry providers.
- the client can report on this data in multiple views, either an individual country, a region, or on a global basis.
- the reporting functionality is also a combination of unique products and services.
- the tool provides a single sign on capability which allows the client to sign on once at the central web site and then access multiple services and functions, wherein one of these functions is the enhanced reporting capability.
- the client has the ability to view their spend via a web browser while no software is required to be loaded on the client PC.
- the clients have access to a set of standard reports or have the ability to develop a view of the data (report) that they request and create on-line.
- the reports can be viewed on-line, printed or exported into other software formats such as Excel at the client site.
- the charge card information is provided in, for example, two forms such as billed and unbilled; and the client can view either through the reporting tool. Additionally, the client can view their Corporate Purchase Card data and their Corporate Card charges as separate sets of data or on a combined report.
- FIG. 1 is a schematic diagram of a system 10 for providing on-line classified hotel folio data.
- System 10 provides daily transaction-level reports, as well as summary-level reports that are broken out by spend categories. Such reports will strengthen efforts by travel managers and Corporate Card program managers to enhance the value of their hotel programs and ensure compliance with established policies and procedures. Moreover, the reports can help companies monitor employee compliance with corporate lodging policies governing use of preferred hotels
- a user at a user computer 12 may submit an on-line request to a server computer 16 , via a network 14 , for charge card transaction details.
- Server computer 16 via a network 14 , can access multiple data sources 20 , 22 , and 24 to obtain the hotel folio detail for the user. Once it obtains the data, server computer 16 processes, filters, and scrubs the data, as it often will be retrieved from multiple disparate sources (including any combination of internal or external data sources), and format the data into a report and/or billing statement.
- the processing of the data includes retrieving a list of hotel item codes corresponding to the source and mapping each hotel item code with a defined item code including a detailed description.
- Server computer 16 then sends the report to user computer 12 via network 14 in, for example, a web page or other format.
- Networks 14 and 18 can include any wireline or wireless network for data communication. The communication across the network may be achieved using web services technology, including but not limited to Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), or Universal Description, Discovery and Integration (UDDI).
- SOAP Simple Object Access Protocol
- WSDL Web Services Description Language
- UDDI Universal Description, Discovery and Integration
- Three data sources are shown for illustrative purposes only; embodiments can include more or fewer data sources depending upon a particular implementation.
- the data sources 20 , 22 , and 24 represent any source of data such as, a local or remote memory or database, possibly in conjunction with an associated computer.
- the network may include any system for exchanging data or transacting business, such as the Internet, an intranet, an extranet, WAN, LAN, satellite communications, and/or the like. It is noted that the network may be implemented as other types of networks, such as an interactive television (ITV) network.
- ITV interactive television
- the users may interact with the system via any input device such as a keyboard, mouse, kiosk, personal digital assistant, handheld computer (e.g., Palm Pilot®), cellular phone and/or the like.
- the invention could be used in conjunction with any type of personal computer, network computer, workstation, minicomputer, mainframe, or the like running any operating system such as any version of Windows, Windows NT, Windows2000, Windows 98, Windows 95, MacOS, OS/2, BeOS, Linux, UNIX, Solaris or the like.
- any operating system such as any version of Windows, Windows NT, Windows2000, Windows 98, Windows 95, MacOS, OS/2, BeOS, Linux, UNIX, Solaris or the like.
- the invention is frequently described herein as being implemented with TCP/IP communications protocols, it will be readily understood that the invention could also be implemented using IPX, Appletalk, IP-6, NetBIOS, OSI or any number of existing or future protocols.
- the system contemplates the use, sale or distribution of any goods, services or information over any network having similar functionality described herein.
- the computing units may be connected with each other via a data communication network.
- the network may be a public network and assumed to be insecure and open to eavesdroppers.
- the network may be embodied as the internet.
- the computers may or may not be connected to the internet at all times.
- the customer computer may employ a modem to occasionally connect to the internet, whereas the bank computing center might maintain a permanent connection to the internet. Specific information related to the protocols, standards, and application software utilized in connection with the Internet may not be discussed herein.
- the systems may be suitably coupled to network via data links.
- a variety of conventional communications media and protocols may be used for data links.
- ISP Internet Service Provider
- Merchant system might also reside within a local area network (LAN) which interfaces to network via a leased line (T1, D3, etc.).
- LAN local area network
- T1, D3, etc. Such communication methods are well known in the art, and are covered in a variety of standard texts. See, e.g., GILBERT HELD, UNDERSTANDING DATA COMMUNICATIONS (1996), hereby incorporated by reference.
- FIG. 2 is a schematic diagram of an exemplary computer 30 illustrating typical components of the computers and server shown in FIG. 1 for the system.
- Computer 30 may include a connection with a network 46 such as the Internet or communications networks through any suitable network connection using, for example, TCP/IP for data transmission.
- Computer 30 typically includes a memory 32 , a secondary storage device 40 , a processor 42 , an input device 36 for entering information into computer 30 , a display device 38 for providing a visual display of information, and an output device 44 for outputting information such as in hard copy or audio form.
- Memory 32 may include random access memory (RAM) or similar types of memory and it may store one or more applications 34 for execution by processor 42 .
- Applications 34 may include programming to perform the methods discussed herein.
- Secondary storage device 40 may include any hardware and/or software for storing data such as, for example, a hard disk drive, floppy disk drive, CD-ROM drive, or other types of non-volatile data storage.
- Processor 42 may execute applications or programs stored in memory 32 or secondary storage 40 , or received from the Internet or other network 46 .
- computer 30 is depicted with various components, one skilled in the art will appreciate that the computer may contain different components.
- Computer 30 may include local or remote databases for storing and retrieving information for processing transactions. Any databases discussed herein may be any type of database, such as relational, graphical, hierarchical, object-oriented, and/or the like.
- Common database products that may be used to implement the databases include UDB by IBM (White Plains, N.Y.), any of the database products available from Oracle Corporation (Redwood Shores, Calif.), Microsoft Access or MSSQL by Microsoft Corporation (Redmond, Wash.), or any other database product.
- the database may be organized in any suitable manner, including as data tables or lookup tables. Association of certain data may be accomplished through any data association technique known and practiced in the art. For example, the association may be accomplished either manually or automatically. Automatic association techniques may include, for example, a database search, a database merge, GREP, AGREP, SQL, and/or the like.
- the association step may be accomplished by a database merge function, for example, using a “key field” in each of the manufacturer and retailer data tables.
- a “key field” partitions the database according to the high-level class of objects defined by the key field. For example, a certain class may be designated as a key field in both the first data table and the second data table, and the two data tables may then be merged on the basis of the class data in the key field.
- the data corresponding to the key field in each of the merged data tables is preferably the same.
- data tables having similar, though not identical, data in the key fields may also be merged by using AGREP, for example.
- the system may include a host server or other computing systems including a processor for processing digital data, a memory coupled to said processor for storing digital data, an input digitizer coupled to the processor for inputting digital data, an application program stored in said memory and accessible by said processor for directing processing of digital data by said processor, a display coupled to the processor and memory for displaying information derived from digital data processed by said processor and a plurality of databases, said databases including client data, merchant data, financial institution data and/or like data that may be used in association with the present invention.
- a host server or other computing systems including a processor for processing digital data, a memory coupled to said processor for storing digital data, an input digitizer coupled to the processor for inputting digital data, an application program stored in said memory and accessible by said processor for directing processing of digital data by said processor, a display coupled to the processor and memory for displaying information derived from digital data processed by said processor and a plurality of databases, said databases including client data, merchant data, financial institution data and/or like data that may be used in association with the present
- user computer may typically include an operating system (e.g., Windows NT, 95/98/2000, Linux, Solaris, etc.) as well as various conventional support software and drivers typically associated with computers.
- User computer may be in a home or business environment with access to a network. In an exemplary embodiment, access is through the Internet through a commercially-available web-browser software package.
- Communication between the parties to the transaction and the system of the present invention may be accomplished through any suitable communication means, such as, for example, a telephone network, Intranet, Internet, point of interaction device (point of sale device, personal digital assistant, cellular phone, kiosk, etc.), online communications, off-line communications, wireless communications, transponder communications and/or the like.
- any databases, systems, or components of the present invention may include any combination of databases or components at a single location or at multiple locations, wherein each database or system includes any of various suitable security features, such as firewalls, access codes, encryption, decryption, and/or the like.
- the computers discussed herein may provide a suitable website or other Internet-based graphical user interface which is accessible by users.
- the Internet Information Server, Microsoft Transaction Server, and Microsoft SQL Server are used in conjunction with the Microsoft operating system, Microsoft NT web server software, a Microsoft SQL database system, and a Microsoft Commerce Server.
- components such as Access or SQL Server, Oracle, Sybase, Informix MySQL, Interbase, etc., may be used to provide an ADO-compliant database management system.
- the present invention may be described herein in terms of functional block components, screen shots, optional selections and various processing steps. It should be appreciated that such functional blocks may be realized by any number of hardware and/or software components configured to perform the specified functions.
- the present invention may employ various integrated circuit components, e.g., memory elements, processing elements, logic elements, look-up tables, and the like, which may carry out a variety of functions under the control of one or more microprocessors or other control devices.
- the software elements of the present invention may be implemented with any programming or scripting language such as C, C++, Java, COBOL, assembler, PERL, Visual Basic, SQL Stored Procedures, extensible markup language (XML), with the various algorithms being implemented with any combination of data structures, objects, processes, routines or other programming elements.
- the present invention may employ any number of conventional techniques for data transmission, signaling, data processing, network control, and the like.
- the invention may be used to detect or prevent security issues with a client-side scripting language, such as JavaScript, VBScript or the like.
- the present invention may be embodied as a method, a data processing system, a device for data processing, and/or a computer program product. Accordingly, the present invention may take the form of an entirely software embodiment, an entirely hardware embodiment, or an embodiment combining aspects of both software and hardware. Furthermore, the present invention may take the form of a computer program product on a computer-readable storage medium having computer-readable program code means embodied in the storage medium. Any suitable computer-readable storage medium may be utilized, including hard disks, CD-ROM, optical storage devices, magnetic storage devices, and/or the like.
- These computer program instructions may also be stored in a computer-readable memory that may direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flow chart block or blocks.
- the computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer-implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flow chart block or blocks.
- fumctional blocks of the block diagrams and flow chart illustrations support combinations of means for performing the specified functions, combinations of steps for performing the specified functions, and program instruction means for performing the specified functions. It may also be understood that each functional block of the block diagrams and flow chart illustrations, and combinations of functional blocks in the block diagrams and flow chart illustrations, may be implemented by either special purpose hardware-based computer systems which perform the specified functions or steps, or suitable combinations of special purpose hardware and computer instructions.
- Hotel folio mapping has resulted in about 20% of all folio line items being reclassified according to this mapping logic. This reclassification is significant, as this number represents a very large number of transactions that would not have otherwise been precisely revealed to large corporate clients. Of this 20%, the amount of hotel folio line items that were previously classified as “miscellaneous” has been reduced by about 74%. These hotel folio line items have been successfully reclassified into more detailed item types. For example, the number of line items previously classified as “hotel restaurant & bar” that are reclassified to “room service” line items was up about 70% with the present invention. Moreover, the number of hotel folio line items classified as “other taxes” have been reduced by about 21%, which has resulted in the movement of these line items into detailed tax categories such as, for example, GST tax, PST tax, and occupancy tax.
- detailed tax categories such as, for example, GST tax, PST tax, and occupancy tax.
- system 1000 uses programming logic to standardize item code categorization of item details across hotel chains and remaps items that are misclassified such as, for example, miscellaneous charges and tax types.
- the programming logic maps folio line items to the correct item code and item code description through, for example, key words/phrases in the associated merchant's item description.
- the logic is flexible to allow for the application of specific requirements relating to certain transactions, identified for an item code or range of item codes, for specific merchants, or for a particular market (e.g., merchant location). If, for any reason, system 1000 is not able to map line items to the correct item code, then the line item may be assigned to a “miscellaneous” category. Practitioner will appreciate that the system may report such line items to an administrator in order to attempt to manually assign a correct item code and/or modify the programming logic in order to correctly process such, line items in the future.
- FIG. 9 an example is provided showing how logic is applied to map a hotel's item description and item code to a predefined new item code and item code description when reclassification of a folio item is required.
- logic is applied, the system is capable of providing a more precise item code and item code description as will be appreciated from the example provided by the figure. Practitioners will appreciate that the following description is very basic and that any number of variables may be considered according to the defined logic in order to produce the desired results.
- system 1000 processes folio data, determination is made as to whether any of the folio line items include an inaccurate or vague item code and item code description. When such folio line items are found, system 1000 processes each to reclassify them to the proper item code and item code description through mapping. To map a folio line item to an appropriate predefined item code and item code description, the system may perform an analysis of the item code applied to the folio line item by the merchant. Through such analysis, the system may determine by way of a lookup table, or any other means known in the art, the appropriate item code and corresponding item code description to apply to the folio line item.
- the system uses predefined logic to retrieve line items corresponding to the determined logic rules (step 900 ).
- the system may further use the predefined logic to construct a SQL query to retrieve compliant transaction records (step 905 ).
- a SQL query may be constructed as follows:
- execution of the above SQL query against a staging database may return one or more records with an item description of “rm serv” 915 and an item code of either “2001” or “5008” 920 .
- the retrieved item code description 925 states that the charge was for the “hotel restaurant & bar.” This description would be of little use to an accounting department of a corporation when determining compliance with company policy. For example, a corporation may issue traveling employees a per diem for meals at a hotel restaurant. However, because ordering meals by room service is generally more expensive than dining in a hotel restaurant, the corporation may not cover such expenses.
- the system applies a new item code and item code description to any records that are retrieved by the SQL query (step 930 ). Therefore, according to this example, the new item code is “3001” and the new item code description is “room service.” With this new item code description, an organization is now able to precisely classify the expense into an appropriate category. Moreover, the new item code is in a format and value that can be used by the organization's accounting systems to properly chart the expense. Finally, mapped folio transaction items are stored in a staging database (step 950 ) where they may subsequently be matched with transaction information stored by the card provider (step 955 ).
- FIG. 10 provides a high level view of the folio data retrieval and processing steps according to an embodiment of the present invention.
- a hotel folio parser 1010 receives folio data from various merchants in the form of folio data files 1005 .
- Folio parser 1010 filters and scrubs the folio data before loading it to the folio database 1015 .
- the system 1000 queries folio database 1015 to detect newly added folio data. When new folio data is detected, system 1000 loads the data into a staging database (step 1020 ).
- system 1000 further analyzes folio data to map property specific item codes and item code descriptions to more descriptive item codes and item code descriptions (step 1025 ) prior to loading the folio data into staging database 1030 .
- folio data For example, most merchants currently classify all room taxes under a very general description (e.g., “taxes”). However, most room charges include taxes at various levels (e.g., Federal, state, city, etc.).
- system 1000 analyzes the item codes and item code descriptions and maps each of the taxes to more descriptive item codes and item code descriptions.
- System 1000 further retrieves data from staging database and uses a matching algorithm to match folio data with individual financial transactions stored by the card provider (step 1035 ). As matches are identified, the matched folio data is moved into matched items database 1040 while matched folios are deleted from the staging database 1030 .
- a matching algorithm to match folio data with individual financial transactions stored by the card provider.
- the matched folio data is moved into matched items database 1040 while matched folios are deleted from the staging database 1030 .
- Practitioners will appreciate that the disclosed data flow and physical database structures may be supplemented with any number of databases, database tables, and configurations without departing from the scope of the invention.
- the invention enables hotel folio data (folio data) capture and matching to a client's specific account transaction detail for the purposes of, for example, more efficient client accounting, spend analysis, policy enforcement, vendor negotiation, and card program management.
- the folio data is received in a specific file format from the merchants/hotels (step 1102 ), which is, in one embodiment, separate from the financial capture data.
- the merchants may include a specific hotel property, a hotel chain, or any grouping or subset of hotels.
- folio data As folio data is received, in one embodiment, it is consolidated across properties within a hotel chain and subjected to a series of processing (step 1104 ), filtering (step 1106 ), and scrubbing (step 1108 ) steps to ensure that there are no errors within the data file. Processing, filtering, and scrubbing further serves to standardize folio data across merchants, and to scrub for any data due to personal privacy concerns. Scrubbed folio data is stored in a folio database, which is an initial point of capture (step 1110 ). Practitioners will appreciate that the folio database may include any number of tables for storing folio data within various defined categories. Moreover, the invention contemplates the use of any number of databases, files, formats, and configurations for storing folio data retrieved from merchants.
- hotel folio data includes information used by the system to process the folio data such that, when required, hotel folio items may be mapped to accurate and/or more descriptive folio items.
- This information includes, for example, descriptors relating to the hotel type, number of days in stay, room type, various services provided by the hotel, various applicable taxes, and the like.
- Folio data may further include information that can be used by accounting systems to properly record folio data within the appropriate systems of an enterprise. Such data may include, for example, a reference number, item codes, item amount, as well as any other information useful in ensuring compliance with an organization's accounting systems and policies.
- folio data from various merchants may be captured throughout a defined time period. At a predetermined time, data captured during the previous time period is moved to a staging database (step 1112 ). However, if it is determined that one or more folio line items does not include an accurate item code and item code description (step 1112 ), then the system maps the one or more items (step 1114 ) as described in reference to FIG. 9 . Folio line items that have been mapped along with folio line items not requiring mapping are moved to a staging database (step 1116 ).
- the system processes data in the staging database to attempt to match each hotel folio data record against an original charge transmission.
- the system 1000 establishes matches by analyzing, for example, the card number and transaction information (step 1118 ). The process may continue to attempt to match the folio data to an original charge transmission for a pre-determined amount of time. If the folio data is matched, then the matching transaction identifiers are captured and the data is loaded to a matched items database for client reporting (step 1120 ).
- the system 1000 facilitates the collection of transactional data from various sources, conditioning, and combining the information into a meaningful report and/or billing statement, and issuing the report/statement to a corporate client through an online interface.
- the system reports on information from various other sources such as a hotel.
- spend transactions card side
- vendor information supply side
- a user is able to determine the volume of spend based on some very specific parameters. For example, a user could use the system to determine how much spend resulted from cancellation fees for rooms that were reserved in New York City over a given period of time.
- the system architecture collects this data from many different sources and in many different forms, conditions the data so that it is all in the same format, and matches hotel folios with specific spend transactions.
- each hotel property is responsible for transmitting the folio data file to the system at regular time periods, defined time periods, upon the occurrence of an event, after a certain number of transactions and/or the like.
- the hotel folio data is global in nature (e.g. data captured from all regional systems) and can include third party data regarding both card and reservation, as well as reference data which can be purchased from multiple industry vendor sources.
- the web application and webpage access that clients use to access the data and create report views of the information is, for example, a third party software package.
- the product enables clients to manage their corporate program with a host as the card provider, along with their own travel management performance and policies.
- the product enables the clients to negotiate purchase opportunities with key vendors (airlines, hotels etc).
- the system may calculate and issue reward or loyalty points based on the processing steps described above.
- the system may determine, for example, that the cardholder's spend on meals fell bellow the allowed per diem, and issue a number of reward points to the card holder based on the summed savings.
- Such points may be applied to a card holder account according to rules defined by the master account holder (e.g., corporation). For example, in order to encourage employees to stay in economy hotels, a corporation may award a number of reward points to the card holder for personal use.
- the transaction card issuer, the hotel, or any other merchant may also award loyalty points to the customer, employer, hotel or any other entity or person.
- FIG. 3 is a flow chart of an exemplary method 50 to provide on-line account data, which may include card data.
- Method 50 may be implemented in, for example, software modules for execution by user computer 12 and server computer 16 . Although the steps of method 50 are shown in a particular order, they may alternatively be executed in other orders and more steps may be added or steps removed, if necessary or desired.
- server computer 16 receives a request from a user at user computer 12 for account data (step 52 ).
- the “account data” can include any data related to transactions involving credit cards, charge cards, or other financial cards.
- account data may include, for example, hotel folio data.
- User computer 12 may include, for example, a software application to help facilitate the user's communication with server computer 16 .
- the request may be received from a user or other person, for example, at the requesting entity.
- the term “end user”, “consumer”, “customer”, “supplier”, “cardmember”, “business” or “merchant” may be used interchangeably with each other, and each shall mean any person, entity, machine, hardware, software or business.
- the card issuing institutions may include credit card companies, card sponsoring companies, or third party issuers under contract with financial institutions. It is further noted that other participants may be involved in some phases of the transaction, such as an intermediary settlement institution, but these participants are not shown.
- FIG. 4 is a diagram of an exemplary screen 70 for a user to enter a request for account data and submit it to server computer 16 .
- FIGS. 6 and 7 illustrate examples of more detailed screens for a user to log into the system and submit an on-line request for account data.
- Screen 70 can be implemented in, for example, a web page for network transmission.
- the term “web page” as it is used herein is not meant to limit the type of documents and applications that might be used to interact with the user.
- a typical website might include, in addition to standard HTML documents, various forms, Java applets, JavaScript, active server pages (ASP), common gateway interface scripts (CGI), extensible markup language (XML), dynamic HTML, cascading style sheets (CSS), helper applications, plug-ins, and the like.
- a server may include a webservice which receives a request from a browser which includes a URL and an IP address (e.g., 127.0.0.1). The webservice retrieves the appropriate web pages and sends the web pages to the IP address.
- IP address e.g., 127.0.0.1
- a user can enter a user name or other identifier in a section 72 and a password in a section 74 .
- a section 76 allows a user to enter a particular query, which can include a request for account data within certain parameters, examples of which are provided above.
- the user can select a section 78 to submit the request or select a section 80 . to cancel the request.
- the request may optionally include an account number.
- An “account number”, as used herein, may include any device, code, number, letter, symbol, digital certificate, smart chip, digital signal, analog signal, biometric or other identifier/indicia suitably configured to allow the consumer to interact or communicate with the system, such as, for example, authorization/access code, personal identification number (PIN), Internet code, other identification code, and/or the like which is optionally located on a rewards card, charge card, credit card, debit card, prepaid card, telephone card, smart card, magnetic stripe card, bar code card, transponder, radio frequency card and/or the like.
- the account number may be distributed and stored in any form of plastic, electronic, magnetic, radio frequency, wireless, audio and/or optical device capable of transmitting or downloading data from itself to a second device.
- a customer account number may be, for example, a sixteen-digit credit card number, although each credit provider has its own numbering system, such as the fifteen-digit numbering system used by American Express.
- Each company's credit card numbers comply with that company's standardized format such that the company using a sixteen-digit format may generally use four spaced sets of numbers, as represented by the number “0000 0000 0000 0000”.
- the first five to seven digits are reserved for processing purposes and identify the issuing bank, card type and etc. In this example, the last sixteenth digit is used as a sum check for the sixteen-digit number.
- the intermediary eight-to-ten digits are used to uniquely identify the customer.
- server computer 16 polls or otherwise contacts data sources 20 , 22 , and 24 to obtain the account data for the user's request (step 54 ).
- Server computer 16 conditions the data and can store it (step 56 ).
- Server computer 16 can use, for example, metadata in order to determine how to locate and retrieve the account data.
- a relationship can be defined between the query (request) attributes and metrics, and target data sources to assure the integrity of the account data report returned to the user.
- Server computer 16 also determines if the user's request includes a query, as represented in section 76 of screen 70 (step 58 ). If the request does not include a query, server computer 16 can format the conditioned data into a standard or default report (step 60 ). If the request included a query (step 58 ), server computer 16 processes the query to extract the relevant data satisfying the query parameters (step 62 ).
- a query, as submitted by a user can include a request for account data satisfying certain parameters. Processing the query can include parsing the natural language submitted query to generate search parameters. Those parameters can be used to obtain the relevant data using, for example, the metadata.
- Server computer 16 can format the extracted data into a custom report (step 64 ). Once the report is compiled and formatted, server computer 16 can send the standard or custom report to user computer 12 via network 14 (step 66 ).
- FIG. 5 is a diagram of an exemplary screen 82 for providing on-line account data.
- FIG. 8 illustrates an example of a more detailed screen for providing on-line account data.
- Screen 82 can be implemented, for example, in a web page for network transmission.
- Screen 82 can include a section 84 for providing the report details and can optionally include a section 86 to repeat the user's query, if one was submitted.
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
- This application is a continuation-in-part of, and claims priority to, U.S. patent application Ser. No. 10/608,764, filed on Jun. 27, 2003, which itself claim priority to U.S. Provisional Patent Application Ser. No. 60/468,495, filed on May 6, 2003, the entire contents of which are incorporated herein by reference.
- The present invention generally relates to providing data to customers on-line, and more particularly, to a system and method to enable charge card holders and others with a certain web application to access charge card detail on-line via a network and view transaction level detail relating to travel expenses, such as hotel expenditures.
- Previous options for clients to view and receive certain reports (e.g., Management Information Reports) were, for example, to receive the reports on paper each month, receive the reports as a data file, or receive data on diskette and/or a CD which was loaded into PC based applications for viewing and reporting. However, these delivery mechanisms were slow (in some cases 90-days after the close of a quarter) and costly. As such, a need existed for an on-line capability to replace or enhance the distribution options. However, on-line tools, for example, were not able to be sufficiently developed because of the complexity of data capture, conditioning from multiple sources, the excessive volume of transaction level detail needed to provide the full functionality required and the lack of technology options to create solutions.
- Moreover, previous reports and/or transaction card billing statements provided limited information regarding the nature of the transaction card spend transaction. This limited information may include, for example, an amount billed against a transaction card on a given date for a specific hotel in a specific city. However, clients were particularly unsatisfied with the amount of hotel folio data classified in “Other” and “Miscellaneous” categories, particularly because existing systems were unable to present hotel folio data at a detailed level. For example, a hotel charge may appear on a billing statement as a single line item in the amount of $1,360. However, it was not clear how much of that sum is attributed to room charges, applicable taxes, hotel restaurant and room service charges, business services (e.g., faxing, computer services, photocopying), parking, ground transportation, and the like. Moreover, while some hotels may employ more descriptive item codes, others are not so descriptive. As such, a need exists for a capability to classify hotel folio line item data into comprehensive and descriptive item types for the hotel spend.
- An apparatus and method of the present invention provides on-line financial account spend data to users. Through item code mapping, the present invention enables an account issuer to compile and present hotel spend transactions with descriptive item codes, specifying previously unknown details regarding general spend transactions. In response to an on-line request from a client for hotel folio information, the method and apparatus retrieve data from multiple sources and conditions the data according to pre-configured item code to item code mappings to compile the hotel folio data. The hotel folio data is then provided to the client via any means known in the art.
- The accompanying drawings, wherein like reference numerals represent like elements, are incorporated in and constitute a part of this specification and, together with the description, explain the advantages and principles of the invention. In the drawings,
-
FIG. 1 is a schematic diagram of a system for providing on-line account data in accordance with exemplary embodiments of the present invention; -
FIG. 2 is a schematic diagram of components of computers and servers used in the system in accordance with exemplary embodiments of the present invention; -
FIG. 3 is a flow chart of an exemplary method to provide on-line account data in accordance with exemplary embodiments of the present invention; -
FIG. 4 is a diagram of a web page for submitting an on-line request for account data in accordance with exemplary embodiments of the present invention; -
FIG. 5 is a diagram of a web page for providing on-line account data in accordance with exemplary embodiments of the present invention; -
FIG. 6 is a diagram illustrating a web page for a user to log into the system in accordance with exemplary embodiments of the present invention; -
FIG. 7 is a diagram illustrating a detailed web page for submitting an on-line request for account data in accordance with exemplary embodiments of the present invention; -
FIG. 8 is a diagram illustrating a web page for providing on-line account data in accordance with exemplary embodiments of the present invention; -
FIG. 9 is a combination process flow chart and diagram showing the application of predefined logic in order to map hotel folio line items to more descriptive hotel folio line items accordance with exemplary embodiments of the present invention; -
FIG. 10 is a combination process flow chart and system diagram of data processing and data movement for matching folios with transaction data in accordance with exemplary embodiments of the present invention; and, -
FIG. 11 is a combination process flow chart and system diagram of a system and method for processing hotel folio line items to ensure proper assignment if item codes and item code descriptions in accordance with exemplary embodiments of the present invention. - Exemplary embodiments include a web application that enables access to a client's specific account transaction detail for the purposes of, for example, vendor negotiation and card program management. The charge transaction detail includes, for example, travel transaction detail, corporate card detail, loyalty information detail and corporate purchasing card detail. In one embodiment, the transaction detail is global in nature (e.g., data captured from all regional systems) and can include third party data regarding card, travel and hotel, as well as reference data which can be purchased from multiple industry vendor sources.
- The term “charge card” is intended to include transaction cards, credit cards, debit cards, stored value cards, transponders, and non-card based financial accounts.
- The web application and web page access that clients use to access the data and create report views of the information can be implemented with, for example, a third party software package called MicroStrategy from a company called MicroStrategy. The product enables clients to manage their corporate program with a host as the card provider, along with their own travel management performance and policies. In addition, the product enables the clients to negotiate purchase opportunities with key vendors (airlines, hotels etc).
- The system can also include a “create a report capability” which allows users to add filters and data elements to an existing report format and create a report specific to their needs and data. The system includes access for the clients to individual market level detail, along with LAC, EMEA, and JAPA (Latin America/Caribbean, Europe, Middle East, Africa, and Japan, Asia, Pacific, Australia) transaction detail. The system also allows report generation wherein the reports include LID (line item detail) data from the clients' Corporate Purchase Card (CPC) purchases, thereby allowing the user to view specific detailed transactions from their selected vendors. This feature includes full hierarchy information and enhanced reporting capabilities. The system also includes Corporate Purchasing card data in its warehouse, which allows clients to view their total program with the host. It also allows clients to combine the data sets and have a single report generated on both CPC and Card spend. The functionality and access allows faster delivery of information to clients which results in, for example, increased client loyalty.
- In an exemplary embodiment, the web application eliminates or reduces the need for any ‘helper’ applications on the web browser, provides a more scalable application and allows clients to access certain data and create report views of the information. Removal of the ‘helper apps’ (e.g., Active-X or Java Applets), in one embodiment, allows greater market penetration since these applications have been shown in some instances to be security risks. The invention also eliminates the need for a separate security log-in function and allows implementation of a single sign-on capability. As such, clients can log into a single portal and are automatically logged into applications within the portal without having to re-authenticate.
- A product implementing an exemplary embodiment is a combination of function, features, data and support service. More particularly, in one embodiment, the product is accessed via a web site which is specifically focused on corporate accounts, the program administrator and the corporate card member. The database is a combination of charge card information (transactions) from every region and country that the host operates as a wholly owned organization or as a franchise or partnership. The collection, consolidation, data management and conditioning of that data are unique in several areas. The database adds and conditions data with proprietary information relating to the host supplier network. This allows the clients using the product to view and report on their corporate spend in key categories (e.g., industries). The data conditioning process for the database captures and consolidates multiple data sources from industry providers. There are also multiple airline data feeds and computerized reservation system (CRS) data feeds providing additional enriched data such as air sectors (travel itinerary) fare basis codes, etc. Many of these data feeds can be purchased by the host on behalf of the client and the data is integrated with their account data.
- The client can report on this data in multiple views, either an individual country, a region, or on a global basis. The reporting functionality is also a combination of unique products and services. The tool provides a single sign on capability which allows the client to sign on once at the central web site and then access multiple services and functions, wherein one of these functions is the enhanced reporting capability. The client has the ability to view their spend via a web browser while no software is required to be loaded on the client PC. The clients have access to a set of standard reports or have the ability to develop a view of the data (report) that they request and create on-line. The reports can be viewed on-line, printed or exported into other software formats such as Excel at the client site. The charge card information is provided in, for example, two forms such as billed and unbilled; and the client can view either through the reporting tool. Additionally, the client can view their Corporate Purchase Card data and their Corporate Card charges as separate sets of data or on a combined report.
- Portfolio Web Network
- Practitioners will appreciate that the present invention may use any combination of proprietary and/or commercially available hardware and/or software products to carry out the process steps described herein. However, for explanation and understanding, a system diagram describing such components is disclosed. This simplified diagram describes the invention according to one embodiment where hotel folio data can be retrieved from multiple data sources, processed (as will be described in greater detail herein), and delivered to a client via the Internet.
-
FIG. 1 is a schematic diagram of asystem 10 for providing on-line classified hotel folio data.System 10 provides daily transaction-level reports, as well as summary-level reports that are broken out by spend categories. Such reports will strengthen efforts by travel managers and Corporate Card program managers to enhance the value of their hotel programs and ensure compliance with established policies and procedures. Moreover, the reports can help companies monitor employee compliance with corporate lodging policies governing use of preferred hotels - In
system 10, a user at auser computer 12 may submit an on-line request to aserver computer 16, via anetwork 14, for charge card transaction details.Server computer 16, via anetwork 14, can accessmultiple data sources server computer 16 processes, filters, and scrubs the data, as it often will be retrieved from multiple disparate sources (including any combination of internal or external data sources), and format the data into a report and/or billing statement. As will be discussed in greater detail herein, the processing of the data includes retrieving a list of hotel item codes corresponding to the source and mapping each hotel item code with a defined item code including a detailed description.Server computer 16 then sends the report touser computer 12 vianetwork 14 in, for example, a web page or other format.Networks - It will be appreciated, that many applications of the present invention could be formulated. One skilled in the art will appreciate that the network may include any system for exchanging data or transacting business, such as the Internet, an intranet, an extranet, WAN, LAN, satellite communications, and/or the like. It is noted that the network may be implemented as other types of networks, such as an interactive television (ITV) network. The users may interact with the system via any input device such as a keyboard, mouse, kiosk, personal digital assistant, handheld computer (e.g., Palm Pilot®), cellular phone and/or the like. Similarly, the invention could be used in conjunction with any type of personal computer, network computer, workstation, minicomputer, mainframe, or the like running any operating system such as any version of Windows, Windows NT, Windows2000, Windows 98, Windows 95, MacOS, OS/2, BeOS, Linux, UNIX, Solaris or the like. Moreover, although the invention is frequently described herein as being implemented with TCP/IP communications protocols, it will be readily understood that the invention could also be implemented using IPX, Appletalk, IP-6, NetBIOS, OSI or any number of existing or future protocols. Moreover, the system contemplates the use, sale or distribution of any goods, services or information over any network having similar functionality described herein.
- The computing units may be connected with each other via a data communication network. The network may be a public network and assumed to be insecure and open to eavesdroppers. In the illustrated implementation, the network may be embodied as the internet. In this context, the computers may or may not be connected to the internet at all times. For instance, the customer computer may employ a modem to occasionally connect to the internet, whereas the bank computing center might maintain a permanent connection to the internet. Specific information related to the protocols, standards, and application software utilized in connection with the Internet may not be discussed herein. For further information regarding such details, see, for example, DILIP NAIK, INTERNET STANDARDS AND PROTOCOLS (1998);
JAVA 2 COMPLETE, various authors, (Sybex 1999); DEBORAH RAY AND ERIC RAY, MASTERING HTML 4.0 (1997). LOSHIN, TCP/IP CLEARLY EXPLAINED (1997). All of these texts are hereby incorporated by reference. - The systems may be suitably coupled to network via data links. A variety of conventional communications media and protocols may be used for data links. Such as, for example, a connection to an Internet Service Provider (ISP) over the local loop as is typically used in connection with standard modem communication, cable modem, Dish networks, ISDN, Digital Subscriber Line (DSL), or various wireless communication methods. Merchant system might also reside within a local area network (LAN) which interfaces to network via a leased line (T1, D3, etc.). Such communication methods are well known in the art, and are covered in a variety of standard texts. See, e.g., GILBERT HELD, UNDERSTANDING DATA COMMUNICATIONS (1996), hereby incorporated by reference.
-
FIG. 2 is a schematic diagram of anexemplary computer 30 illustrating typical components of the computers and server shown inFIG. 1 for the system.Computer 30 may include a connection with anetwork 46 such as the Internet or communications networks through any suitable network connection using, for example, TCP/IP for data transmission.Computer 30 typically includes amemory 32, asecondary storage device 40, aprocessor 42, aninput device 36 for entering information intocomputer 30, adisplay device 38 for providing a visual display of information, and anoutput device 44 for outputting information such as in hard copy or audio form. -
Memory 32 may include random access memory (RAM) or similar types of memory and it may store one or more applications 34 for execution byprocessor 42. Applications 34 may include programming to perform the methods discussed herein. -
Secondary storage device 40 may include any hardware and/or software for storing data such as, for example, a hard disk drive, floppy disk drive, CD-ROM drive, or other types of non-volatile data storage.Processor 42 may execute applications or programs stored inmemory 32 orsecondary storage 40, or received from the Internet orother network 46. Althoughcomputer 30 is depicted with various components, one skilled in the art will appreciate that the computer may contain different components. -
Computer 30 may include local or remote databases for storing and retrieving information for processing transactions. Any databases discussed herein may be any type of database, such as relational, graphical, hierarchical, object-oriented, and/or the like. - Common database products that may be used to implement the databases include UDB by IBM (White Plains, N.Y.), any of the database products available from Oracle Corporation (Redwood Shores, Calif.), Microsoft Access or MSSQL by Microsoft Corporation (Redmond, Wash.), or any other database product. The database may be organized in any suitable manner, including as data tables or lookup tables. Association of certain data may be accomplished through any data association technique known and practiced in the art. For example, the association may be accomplished either manually or automatically. Automatic association techniques may include, for example, a database search, a database merge, GREP, AGREP, SQL, and/or the like. The association step may be accomplished by a database merge function, for example, using a “key field” in each of the manufacturer and retailer data tables. A “key field” partitions the database according to the high-level class of objects defined by the key field. For example, a certain class may be designated as a key field in both the first data table and the second data table, and the two data tables may then be merged on the basis of the class data in the key field. In this embodiment, the data corresponding to the key field in each of the merged data tables is preferably the same. However, data tables having similar, though not identical, data in the key fields may also be merged by using AGREP, for example.
- For the sake of brevity, conventional data networking, application development and other functional aspects of the systems (and components of the individual operating components of the systems) may not be described in detail herein. Furthermore, the connecting lines shown in the various figures contained herein are intended to represent exemplary functional relationships and/or physical couplings between the various elements. It should be noted that many alternative or additional functional relationships or physical connections may be present in a practical electronic transaction system.
- The system, as shown in
FIG. 1 , may include a host server or other computing systems including a processor for processing digital data, a memory coupled to said processor for storing digital data, an input digitizer coupled to the processor for inputting digital data, an application program stored in said memory and accessible by said processor for directing processing of digital data by said processor, a display coupled to the processor and memory for displaying information derived from digital data processed by said processor and a plurality of databases, said databases including client data, merchant data, financial institution data and/or like data that may be used in association with the present invention. As those skilled in the art may appreciate, user computer may typically include an operating system (e.g., Windows NT, 95/98/2000, Linux, Solaris, etc.) as well as various conventional support software and drivers typically associated with computers. User computer may be in a home or business environment with access to a network. In an exemplary embodiment, access is through the Internet through a commercially-available web-browser software package. - Communication between the parties to the transaction and the system of the present invention may be accomplished through any suitable communication means, such as, for example, a telephone network, Intranet, Internet, point of interaction device (point of sale device, personal digital assistant, cellular phone, kiosk, etc.), online communications, off-line communications, wireless communications, transponder communications and/or the like. One skilled in the art may also appreciate that, for security reasons, any databases, systems, or components of the present invention may include any combination of databases or components at a single location or at multiple locations, wherein each database or system includes any of various suitable security features, such as firewalls, access codes, encryption, decryption, and/or the like.
- The computers discussed herein may provide a suitable website or other Internet-based graphical user interface which is accessible by users. In one embodiment, the Internet Information Server, Microsoft Transaction Server, and Microsoft SQL Server, are used in conjunction with the Microsoft operating system, Microsoft NT web server software, a Microsoft SQL database system, and a Microsoft Commerce Server. Additionally, components such as Access or SQL Server, Oracle, Sybase, Informix MySQL, Interbase, etc., may be used to provide an ADO-compliant database management system.
- The present invention may be described herein in terms of functional block components, screen shots, optional selections and various processing steps. It should be appreciated that such functional blocks may be realized by any number of hardware and/or software components configured to perform the specified functions. For example, the present invention may employ various integrated circuit components, e.g., memory elements, processing elements, logic elements, look-up tables, and the like, which may carry out a variety of functions under the control of one or more microprocessors or other control devices. Similarly, the software elements of the present invention may be implemented with any programming or scripting language such as C, C++, Java, COBOL, assembler, PERL, Visual Basic, SQL Stored Procedures, extensible markup language (XML), with the various algorithms being implemented with any combination of data structures, objects, processes, routines or other programming elements. Further, it should be noted that the present invention may employ any number of conventional techniques for data transmission, signaling, data processing, network control, and the like. Still further, the invention may be used to detect or prevent security issues with a client-side scripting language, such as JavaScript, VBScript or the like. For a basic introduction of cryptography and network security, the following may be helpful references: (1) “Applied Cryptography: Protocols, Algorithms, And Source Code In C,” by Bruce Schneier, published by John Wiley & Sons (second edition, 1996); (2) “Java Cryptography” by Jonathan Knudson, published by O'Reilly & Associates (1998); (3) “Cryptography & Network Security: Principles & Practice” by William Stalling, published by Prentice Hall; all of which are hereby incorporated by reference.
- As may be appreciated by one of ordinary skill in the art, the present invention may be embodied as a method, a data processing system, a device for data processing, and/or a computer program product. Accordingly, the present invention may take the form of an entirely software embodiment, an entirely hardware embodiment, or an embodiment combining aspects of both software and hardware. Furthermore, the present invention may take the form of a computer program product on a computer-readable storage medium having computer-readable program code means embodied in the storage medium. Any suitable computer-readable storage medium may be utilized, including hard disks, CD-ROM, optical storage devices, magnetic storage devices, and/or the like.
- The present invention is described herein with reference to screen shots, block diagrams and flow chart illustrations of methods, apparatus (e.g., systems), and computer program products according to various aspects of the invention. It may be understood that each functional block of the block diagrams and the flow chart illustrations, and combinations of functional blocks in the block diagrams and flow chart illustrations, respectively, may be implemented by computer program instructions. These computer program instructions may be loaded onto a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions which execute on the computer or other programmable data processing apparatus create means for implementing the functions specified in the flow chart block or blocks.
- These computer program instructions may also be stored in a computer-readable memory that may direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flow chart block or blocks. The computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer-implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flow chart block or blocks.
- Accordingly, fumctional blocks of the block diagrams and flow chart illustrations support combinations of means for performing the specified functions, combinations of steps for performing the specified functions, and program instruction means for performing the specified functions. It may also be understood that each functional block of the block diagrams and flow chart illustrations, and combinations of functional blocks in the block diagrams and flow chart illustrations, may be implemented by either special purpose hardware-based computer systems which perform the specified functions or steps, or suitable combinations of special purpose hardware and computer instructions.
- Hotel Folio Mapping
- Hotel folio mapping, as described herein, has resulted in about 20% of all folio line items being reclassified according to this mapping logic. This reclassification is significant, as this number represents a very large number of transactions that would not have otherwise been precisely revealed to large corporate clients. Of this 20%, the amount of hotel folio line items that were previously classified as “miscellaneous” has been reduced by about 74%. These hotel folio line items have been successfully reclassified into more detailed item types. For example, the number of line items previously classified as “hotel restaurant & bar” that are reclassified to “room service” line items was up about 70% with the present invention. Moreover, the number of hotel folio line items classified as “other taxes” have been reduced by about 21%, which has resulted in the movement of these line items into detailed tax categories such as, for example, GST tax, PST tax, and occupancy tax.
- In general,
system 1000 uses programming logic to standardize item code categorization of item details across hotel chains and remaps items that are misclassified such as, for example, miscellaneous charges and tax types. The programming logic maps folio line items to the correct item code and item code description through, for example, key words/phrases in the associated merchant's item description. The logic is flexible to allow for the application of specific requirements relating to certain transactions, identified for an item code or range of item codes, for specific merchants, or for a particular market (e.g., merchant location). If, for any reason,system 1000 is not able to map line items to the correct item code, then the line item may be assigned to a “miscellaneous” category. Practitioner will appreciate that the system may report such line items to an administrator in order to attempt to manually assign a correct item code and/or modify the programming logic in order to correctly process such, line items in the future. - With reference to
FIG. 9 , an example is provided showing how logic is applied to map a hotel's item description and item code to a predefined new item code and item code description when reclassification of a folio item is required. When such logic is applied, the system is capable of providing a more precise item code and item code description as will be appreciated from the example provided by the figure. Practitioners will appreciate that the following description is very basic and that any number of variables may be considered according to the defined logic in order to produce the desired results. - As
system 1000 processes folio data, determination is made as to whether any of the folio line items include an inaccurate or vague item code and item code description. When such folio line items are found,system 1000 processes each to reclassify them to the proper item code and item code description through mapping. To map a folio line item to an appropriate predefined item code and item code description, the system may perform an analysis of the item code applied to the folio line item by the merchant. Through such analysis, the system may determine by way of a lookup table, or any other means known in the art, the appropriate item code and corresponding item code description to apply to the folio line item. - In one embodiment, the system uses predefined logic to retrieve line items corresponding to the determined logic rules (step 900). The system may further use the predefined logic to construct a SQL query to retrieve compliant transaction records (step 905). In this example, a SQL query may be constructed as follows:
- SELECT item_desc, item_code, item_code_desc FROM staging_table
- WHERE item_desc=“rm serv” AND item_code=“3001” OR item_code=“5008”
- Thus, execution of the above SQL query against a staging database may return one or more records with an item description of “rm serv” 915 and an item code of either “2001” or “5008” 920. Note that the retrieved item code description 925 states that the charge was for the “hotel restaurant & bar.” This description would be of little use to an accounting department of a corporation when determining compliance with company policy. For example, a corporation may issue traveling employees a per diem for meals at a hotel restaurant. However, because ordering meals by room service is generally more expensive than dining in a hotel restaurant, the corporation may not cover such expenses.
- The system applies a new item code and item code description to any records that are retrieved by the SQL query (step 930). Therefore, according to this example, the new item code is “3001” and the new item code description is “room service.” With this new item code description, an organization is now able to precisely classify the expense into an appropriate category. Moreover, the new item code is in a format and value that can be used by the organization's accounting systems to properly chart the expense. Finally, mapped folio transaction items are stored in a staging database (step 950) where they may subsequently be matched with transaction information stored by the card provider (step 955).
-
FIG. 10 provides a high level view of the folio data retrieval and processing steps according to an embodiment of the present invention. At various intervals, ahotel folio parser 1010 receives folio data from various merchants in the form of folio data files 1005.Folio parser 1010 filters and scrubs the folio data before loading it to thefolio database 1015. At regular and/or defined time intervals, thesystem 1000 queriesfolio database 1015 to detect newly added folio data. When new folio data is detected,system 1000 loads the data into a staging database (step 1020). If necessary,system 1000 further analyzes folio data to map property specific item codes and item code descriptions to more descriptive item codes and item code descriptions (step 1025) prior to loading the folio data intostaging database 1030. For example, most merchants currently classify all room taxes under a very general description (e.g., “taxes”). However, most room charges include taxes at various levels (e.g., Federal, state, city, etc.). To provide the client with a more descriptive summary of room charges,system 1000 analyzes the item codes and item code descriptions and maps each of the taxes to more descriptive item codes and item code descriptions. -
System 1000 further retrieves data from staging database and uses a matching algorithm to match folio data with individual financial transactions stored by the card provider (step 1035). As matches are identified, the matched folio data is moved into matcheditems database 1040 while matched folios are deleted from thestaging database 1030. Practitioners will appreciate that the disclosed data flow and physical database structures may be supplemented with any number of databases, database tables, and configurations without departing from the scope of the invention. - With reference to
FIG. 11 , and according to an exemplary embodiment, the invention enables hotel folio data (folio data) capture and matching to a client's specific account transaction detail for the purposes of, for example, more efficient client accounting, spend analysis, policy enforcement, vendor negotiation, and card program management. The folio data is received in a specific file format from the merchants/hotels (step 1102), which is, in one embodiment, separate from the financial capture data. As used herein, the merchants may include a specific hotel property, a hotel chain, or any grouping or subset of hotels. As folio data is received, in one embodiment, it is consolidated across properties within a hotel chain and subjected to a series of processing (step 1104), filtering (step 1106), and scrubbing (step 1108) steps to ensure that there are no errors within the data file. Processing, filtering, and scrubbing further serves to standardize folio data across merchants, and to scrub for any data due to personal privacy concerns. Scrubbed folio data is stored in a folio database, which is an initial point of capture (step 1110). Practitioners will appreciate that the folio database may include any number of tables for storing folio data within various defined categories. Moreover, the invention contemplates the use of any number of databases, files, formats, and configurations for storing folio data retrieved from merchants. - In one embodiment, hotel folio data includes information used by the system to process the folio data such that, when required, hotel folio items may be mapped to accurate and/or more descriptive folio items. This information includes, for example, descriptors relating to the hotel type, number of days in stay, room type, various services provided by the hotel, various applicable taxes, and the like. Folio data may further include information that can be used by accounting systems to properly record folio data within the appropriate systems of an enterprise. Such data may include, for example, a reference number, item codes, item amount, as well as any other information useful in ensuring compliance with an organization's accounting systems and policies.
- According to one embodiment, folio data from various merchants may be captured throughout a defined time period. At a predetermined time, data captured during the previous time period is moved to a staging database (step 1112). However, if it is determined that one or more folio line items does not include an accurate item code and item code description (step 1112), then the system maps the one or more items (step 1114) as described in reference to
FIG. 9 . Folio line items that have been mapped along with folio line items not requiring mapping are moved to a staging database (step 1116). - The system processes data in the staging database to attempt to match each hotel folio data record against an original charge transmission. The
system 1000 establishes matches by analyzing, for example, the card number and transaction information (step 1118). The process may continue to attempt to match the folio data to an original charge transmission for a pre-determined amount of time. If the folio data is matched, then the matching transaction identifiers are captured and the data is loaded to a matched items database for client reporting (step 1120). - In one embodiment, the
system 1000 facilitates the collection of transactional data from various sources, conditioning, and combining the information into a meaningful report and/or billing statement, and issuing the report/statement to a corporate client through an online interface. In addition to reporting spends, the system reports on information from various other sources such as a hotel. Because spend transactions (card side) are matched up and reported with vendor information (supplier side); a user is able to determine the volume of spend based on some very specific parameters. For example, a user could use the system to determine how much spend resulted from cancellation fees for rooms that were reserved in New York City over a given period of time. The system architecture collects this data from many different sources and in many different forms, conditions the data so that it is all in the same format, and matches hotel folios with specific spend transactions. - Practitioners will appreciate that the system may capture folio data by any means known in the art including, for example, real-time and batch mode. According to one embodiment, each hotel property is responsible for transmitting the folio data file to the system at regular time periods, defined time periods, upon the occurrence of an event, after a certain number of transactions and/or the like.
- In an exemplary embodiment, the hotel folio data is global in nature (e.g. data captured from all regional systems) and can include third party data regarding both card and reservation, as well as reference data which can be purchased from multiple industry vendor sources. The web application and webpage access that clients use to access the data and create report views of the information is, for example, a third party software package. The product enables clients to manage their corporate program with a host as the card provider, along with their own travel management performance and policies. In addition, the product enables the clients to negotiate purchase opportunities with key vendors (airlines, hotels etc).
- According to one embodiment, the system may calculate and issue reward or loyalty points based on the processing steps described above. In performing an analysis of a merchant's item codes, the system may determine, for example, that the cardholder's spend on meals fell bellow the allowed per diem, and issue a number of reward points to the card holder based on the summed savings. Such points may be applied to a card holder account according to rules defined by the master account holder (e.g., corporation). For example, in order to encourage employees to stay in economy hotels, a corporation may award a number of reward points to the card holder for personal use. The transaction card issuer, the hotel, or any other merchant may also award loyalty points to the customer, employer, hotel or any other entity or person.
- Portfolio Reporting
-
FIG. 3 is a flow chart of anexemplary method 50 to provide on-line account data, which may include card data.Method 50 may be implemented in, for example, software modules for execution byuser computer 12 andserver computer 16. Although the steps ofmethod 50 are shown in a particular order, they may alternatively be executed in other orders and more steps may be added or steps removed, if necessary or desired. - In
method 50,server computer 16 receives a request from a user atuser computer 12 for account data (step 52). The “account data” can include any data related to transactions involving credit cards, charge cards, or other financial cards. In one embodiment, account data may include, for example, hotel folio data.User computer 12 may include, for example, a software application to help facilitate the user's communication withserver computer 16. The request may be received from a user or other person, for example, at the requesting entity. As used herein, the term “end user”, “consumer”, “customer”, “supplier”, “cardmember”, “business” or “merchant” may be used interchangeably with each other, and each shall mean any person, entity, machine, hardware, software or business. The card issuing institutions may include credit card companies, card sponsoring companies, or third party issuers under contract with financial institutions. It is further noted that other participants may be involved in some phases of the transaction, such as an intermediary settlement institution, but these participants are not shown. -
FIG. 4 is a diagram of anexemplary screen 70 for a user to enter a request for account data and submit it toserver computer 16.FIGS. 6 and 7 illustrate examples of more detailed screens for a user to log into the system and submit an on-line request for account data. -
Screen 70 can be implemented in, for example, a web page for network transmission. The term “web page” as it is used herein is not meant to limit the type of documents and applications that might be used to interact with the user. For example, a typical website might include, in addition to standard HTML documents, various forms, Java applets, JavaScript, active server pages (ASP), common gateway interface scripts (CGI), extensible markup language (XML), dynamic HTML, cascading style sheets (CSS), helper applications, plug-ins, and the like. A server may include a webservice which receives a request from a browser which includes a URL and an IP address (e.g., 127.0.0.1). The webservice retrieves the appropriate web pages and sends the web pages to the IP address. - In
screen 70, a user can enter a user name or other identifier in asection 72 and a password in asection 74. Asection 76 allows a user to enter a particular query, which can include a request for account data within certain parameters, examples of which are provided above. The user can select asection 78 to submit the request or select asection 80. to cancel the request. - The request may optionally include an account number. An “account number”, as used herein, may include any device, code, number, letter, symbol, digital certificate, smart chip, digital signal, analog signal, biometric or other identifier/indicia suitably configured to allow the consumer to interact or communicate with the system, such as, for example, authorization/access code, personal identification number (PIN), Internet code, other identification code, and/or the like which is optionally located on a rewards card, charge card, credit card, debit card, prepaid card, telephone card, smart card, magnetic stripe card, bar code card, transponder, radio frequency card and/or the like. The account number may be distributed and stored in any form of plastic, electronic, magnetic, radio frequency, wireless, audio and/or optical device capable of transmitting or downloading data from itself to a second device. A customer account number may be, for example, a sixteen-digit credit card number, although each credit provider has its own numbering system, such as the fifteen-digit numbering system used by American Express. Each company's credit card numbers comply with that company's standardized format such that the company using a sixteen-digit format may generally use four spaced sets of numbers, as represented by the number “0000 0000 0000 0000”. The first five to seven digits are reserved for processing purposes and identify the issuing bank, card type and etc. In this example, the last sixteenth digit is used as a sum check for the sixteen-digit number. The intermediary eight-to-ten digits are used to uniquely identify the customer.
- After receiving the request,
server computer 16 polls or otherwisecontacts data sources Server computer 16 conditions the data and can store it (step 56).Server computer 16 can use, for example, metadata in order to determine how to locate and retrieve the account data. In particular, a relationship can be defined between the query (request) attributes and metrics, and target data sources to assure the integrity of the account data report returned to the user. -
Server computer 16 also determines if the user's request includes a query, as represented insection 76 of screen 70 (step 58). If the request does not include a query,server computer 16 can format the conditioned data into a standard or default report (step 60). If the request included a query (step 58),server computer 16 processes the query to extract the relevant data satisfying the query parameters (step 62). A query, as submitted by a user, can include a request for account data satisfying certain parameters. Processing the query can include parsing the natural language submitted query to generate search parameters. Those parameters can be used to obtain the relevant data using, for example, the metadata.Server computer 16 can format the extracted data into a custom report (step 64). Once the report is compiled and formatted,server computer 16 can send the standard or custom report touser computer 12 via network 14 (step 66). -
FIG. 5 is a diagram of anexemplary screen 82 for providing on-line account data.FIG. 8 illustrates an example of a more detailed screen for providing on-line account data.Screen 82 can be implemented, for example, in a web page for network transmission.Screen 82 can include asection 84 for providing the report details and can optionally include asection 86 to repeat the user's query, if one was submitted. - Benefits, other advantages, and solutions to problems have been described herein with regard to specific embodiments. However, the benefits, advantages, solutions to problems, and any element(s) that may cause any benefit, advantage, or solution to occur or become more pronounced are not to be construed as critical, required, or essential features or elements of any or all the claims or the invention. As used herein, the terms “comprises”, “comprising”, or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Further, no element described herein is required for the practice of the invention unless expressly described as “essential” or “critical”.
- The detailed description of exemplary embodiments of the invention herein makes reference to the accompanying drawings and pictures, which show the exemplary embodiment by way of illustration and its best mode. While these exemplary embodiments are described in sufficient detail to enable those skilled in the art to practice the invention, it should be understood that other embodiments may be realized and that logical and mechanical changes may be made without departing from the spirit and scope of the invention. Thus, the detailed description herein is presented for purposes of illustration only and not of limitation. For example, the steps recited in any of the method or process descriptions may be executed in any order and are not limited to the order presented.
Claims (26)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/689,958 US20070192222A1 (en) | 2003-05-06 | 2007-03-22 | System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction |
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US46849503P | 2003-05-06 | 2003-05-06 | |
US10/608,764 US7647257B2 (en) | 2003-05-06 | 2003-06-27 | System and method for web access to financial data |
US11/689,958 US20070192222A1 (en) | 2003-05-06 | 2007-03-22 | System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/608,764 Continuation-In-Part US7647257B2 (en) | 2003-05-06 | 2003-06-27 | System and method for web access to financial data |
Publications (1)
Publication Number | Publication Date |
---|---|
US20070192222A1 true US20070192222A1 (en) | 2007-08-16 |
Family
ID=33423743
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/608,764 Expired - Fee Related US7647257B2 (en) | 2003-05-06 | 2003-06-27 | System and method for web access to financial data |
US11/551,778 Abandoned US20070073588A1 (en) | 2003-05-06 | 2006-10-23 | System and method for administering spend driven rebates |
US11/689,958 Abandoned US20070192222A1 (en) | 2003-05-06 | 2007-03-22 | System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction |
Family Applications Before (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/608,764 Expired - Fee Related US7647257B2 (en) | 2003-05-06 | 2003-06-27 | System and method for web access to financial data |
US11/551,778 Abandoned US20070073588A1 (en) | 2003-05-06 | 2006-10-23 | System and method for administering spend driven rebates |
Country Status (2)
Country | Link |
---|---|
US (3) | US7647257B2 (en) |
WO (1) | WO2004102358A2 (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20100153242A1 (en) * | 2008-12-17 | 2010-06-17 | Mastercard International, Inc. | Interactive Online Spending Analysis Tool |
US20110218893A1 (en) * | 2007-12-07 | 2011-09-08 | Jpmorgan Chase Bank, N.A. | System for Associating Financial Transaction Data with User's Project Data |
US20110313830A1 (en) * | 2006-12-29 | 2011-12-22 | American Express Travel Related Services Company, Inc. | System and method for targeting transaction account product holders to receive upgraded transaction account products |
US20120317003A1 (en) * | 2011-06-09 | 2012-12-13 | Mcgrane Russell | Automated expense account report generator |
US8447666B1 (en) * | 2009-02-19 | 2013-05-21 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with user's project data using a portable electronic device |
US9922375B1 (en) | 2014-09-22 | 2018-03-20 | Certify, Inc. | Systems and methods of parsing receipts |
US10210579B1 (en) | 2014-09-22 | 2019-02-19 | Certify, Inc. | Automated expense reports systems and methods |
CN110502511A (en) * | 2019-07-01 | 2019-11-26 | 招联消费金融有限公司 | Numeric value transfer and device, computer equipment and storage medium |
US10497065B1 (en) * | 2014-11-19 | 2019-12-03 | Ab Initio Technology Llc | Automatically correcting records |
US11687519B2 (en) | 2021-08-11 | 2023-06-27 | T-Mobile Usa, Inc. | Ensuring availability and integrity of a database across geographical regions |
Families Citing this family (74)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080215472A1 (en) * | 2000-06-27 | 2008-09-04 | Nicholas Ahthony Lindsay Brown | Variable use advanced messaging system and method |
US7340422B2 (en) | 2003-02-10 | 2008-03-04 | Asentinel Llc | Systems and method for managing and processing of telecommunications invoices |
US8601049B2 (en) | 2004-03-04 | 2013-12-03 | The United States Postal Service | System and method for providing centralized management and distribution of information to remote users |
US8630929B2 (en) * | 2004-10-29 | 2014-01-14 | American Express Travel Related Services Company, Inc. | Using commercial share of wallet to make lending decisions |
US8204774B2 (en) | 2004-10-29 | 2012-06-19 | American Express Travel Related Services Company, Inc. | Estimating the spend capacity of consumer households |
US20060224628A1 (en) * | 2005-03-29 | 2006-10-05 | Bea Systems, Inc. | Modeling for data services |
CA2664616A1 (en) * | 2006-09-26 | 2009-04-03 | Behruz Nader Daroga | Secure on line accounts (sola) system using cell phones and other wireless devices |
US20080201178A1 (en) * | 2007-02-20 | 2008-08-21 | Yuri Vizitei | On-demand travel management service and platform |
US8566239B2 (en) * | 2007-02-22 | 2013-10-22 | First Data Corporation | Mobile commerce systems and methods |
US8452636B1 (en) * | 2007-10-29 | 2013-05-28 | United Services Automobile Association (Usaa) | Systems and methods for market performance analysis |
US20090254413A1 (en) * | 2008-04-07 | 2009-10-08 | American Express Travel Related Services Co., Inc., A New York Corporation | Portfolio Modeling and Campaign Optimization |
US8171451B2 (en) * | 2008-05-09 | 2012-05-01 | International Business Machines Corporation | Providing reports as web services |
US9818118B2 (en) * | 2008-11-19 | 2017-11-14 | Visa International Service Association | Transaction aggregator |
US20100131344A1 (en) * | 2008-11-25 | 2010-05-27 | Amorim Manuel Albeto De Abreu | Electronic transaction methods of a retail merchant with a retail consumer |
US20100250355A1 (en) * | 2009-03-30 | 2010-09-30 | Bank Of America Corporation | Redemption of Reward Points as Cash and Deposit of Cash to Checking, Savings or Other Accounts |
US10546332B2 (en) | 2010-09-21 | 2020-01-28 | Visa International Service Association | Systems and methods to program operations for interaction with users |
US9841282B2 (en) | 2009-07-27 | 2017-12-12 | Visa U.S.A. Inc. | Successive offer communications with an offer recipient |
US9443253B2 (en) | 2009-07-27 | 2016-09-13 | Visa International Service Association | Systems and methods to provide and adjust offers |
US8266031B2 (en) * | 2009-07-29 | 2012-09-11 | Visa U.S.A. | Systems and methods to provide benefits of account features to account holders |
US20110035278A1 (en) | 2009-08-04 | 2011-02-10 | Visa U.S.A. Inc. | Systems and Methods for Closing the Loop between Online Activities and Offline Purchases |
US20110035280A1 (en) * | 2009-08-04 | 2011-02-10 | Visa U.S.A. Inc. | Systems and Methods for Targeted Advertisement Delivery |
US8533177B2 (en) * | 2009-08-27 | 2013-09-10 | Mastercard International Incorporated | Multi-database query system and method |
US20110087547A1 (en) * | 2009-10-09 | 2011-04-14 | Visa U.S.A. | Systems and Methods for Advertising Services Based on a Local Profile |
US20110087530A1 (en) * | 2009-10-09 | 2011-04-14 | Visa U.S.A. Inc. | Systems and Methods to Provide Loyalty Programs |
US20110087519A1 (en) * | 2009-10-09 | 2011-04-14 | Visa U.S.A. Inc. | Systems and Methods for Panel Enhancement with Transaction Data |
US9342835B2 (en) | 2009-10-09 | 2016-05-17 | Visa U.S.A | Systems and methods to deliver targeted advertisements to audience |
US9031860B2 (en) * | 2009-10-09 | 2015-05-12 | Visa U.S.A. Inc. | Systems and methods to aggregate demand |
US8595058B2 (en) * | 2009-10-15 | 2013-11-26 | Visa U.S.A. | Systems and methods to match identifiers |
US20110093324A1 (en) | 2009-10-19 | 2011-04-21 | Visa U.S.A. Inc. | Systems and Methods to Provide Intelligent Analytics to Cardholders and Merchants |
US8676639B2 (en) | 2009-10-29 | 2014-03-18 | Visa International Service Association | System and method for promotion processing and authorization |
US8626705B2 (en) | 2009-11-05 | 2014-01-07 | Visa International Service Association | Transaction aggregator for closed processing |
US20110125565A1 (en) | 2009-11-24 | 2011-05-26 | Visa U.S.A. Inc. | Systems and Methods for Multi-Channel Offer Redemption |
US20110231224A1 (en) * | 2010-03-19 | 2011-09-22 | Visa U.S.A. Inc. | Systems and Methods to Perform Checkout Funnel Analyses |
US20110231258A1 (en) * | 2010-03-19 | 2011-09-22 | Visa U.S.A. Inc. | Systems and Methods to Distribute Advertisement Opportunities to Merchants |
US20110231225A1 (en) * | 2010-03-19 | 2011-09-22 | Visa U.S.A. Inc. | Systems and Methods to Identify Customers Based on Spending Patterns |
US8639567B2 (en) * | 2010-03-19 | 2014-01-28 | Visa U.S.A. Inc. | Systems and methods to identify differences in spending patterns |
US8738418B2 (en) | 2010-03-19 | 2014-05-27 | Visa U.S.A. Inc. | Systems and methods to enhance search data with transaction based data |
US20110231305A1 (en) * | 2010-03-19 | 2011-09-22 | Visa U.S.A. Inc. | Systems and Methods to Identify Spending Patterns |
US9697520B2 (en) | 2010-03-22 | 2017-07-04 | Visa U.S.A. Inc. | Merchant configured advertised incentives funded through statement credits |
US9471926B2 (en) | 2010-04-23 | 2016-10-18 | Visa U.S.A. Inc. | Systems and methods to provide offers to travelers |
US8359274B2 (en) | 2010-06-04 | 2013-01-22 | Visa International Service Association | Systems and methods to provide messages in real-time with transaction processing |
US8781896B2 (en) | 2010-06-29 | 2014-07-15 | Visa International Service Association | Systems and methods to optimize media presentations |
US9760905B2 (en) | 2010-08-02 | 2017-09-12 | Visa International Service Association | Systems and methods to optimize media presentations using a camera |
US9972021B2 (en) | 2010-08-06 | 2018-05-15 | Visa International Service Association | Systems and methods to rank and select triggers for real-time offers |
US9679299B2 (en) | 2010-09-03 | 2017-06-13 | Visa International Service Association | Systems and methods to provide real-time offers via a cooperative database |
US9477967B2 (en) | 2010-09-21 | 2016-10-25 | Visa International Service Association | Systems and methods to process an offer campaign based on ineligibility |
US10055745B2 (en) | 2010-09-21 | 2018-08-21 | Visa International Service Association | Systems and methods to modify interaction rules during run time |
US9558502B2 (en) | 2010-11-04 | 2017-01-31 | Visa International Service Association | Systems and methods to reward user interactions |
US10007915B2 (en) | 2011-01-24 | 2018-06-26 | Visa International Service Association | Systems and methods to facilitate loyalty reward transactions |
US10438299B2 (en) | 2011-03-15 | 2019-10-08 | Visa International Service Association | Systems and methods to combine transaction terminal location data and social networking check-in |
US10223707B2 (en) | 2011-08-19 | 2019-03-05 | Visa International Service Association | Systems and methods to communicate offer options via messaging in real time with processing of payment transaction |
US9466075B2 (en) | 2011-09-20 | 2016-10-11 | Visa International Service Association | Systems and methods to process referrals in offer campaigns |
US10380617B2 (en) | 2011-09-29 | 2019-08-13 | Visa International Service Association | Systems and methods to provide a user interface to control an offer campaign |
US9361620B2 (en) | 2011-10-14 | 2016-06-07 | Leisure Pass Group Limited | Electronic transaction system with entitlement and promotion engines |
US10290018B2 (en) | 2011-11-09 | 2019-05-14 | Visa International Service Association | Systems and methods to communicate with users via social networking sites |
US10497022B2 (en) | 2012-01-20 | 2019-12-03 | Visa International Service Association | Systems and methods to present and process offers |
US9477988B2 (en) | 2012-02-23 | 2016-10-25 | American Express Travel Related Services Company, Inc. | Systems and methods for identifying financial relationships |
US10672018B2 (en) | 2012-03-07 | 2020-06-02 | Visa International Service Association | Systems and methods to process offers via mobile devices |
WO2013166204A1 (en) * | 2012-05-02 | 2013-11-07 | Oxygen Finance Americas, Inc. | Systems for and methods of capturing and analyzing benefits in commercial transactions |
US9213966B2 (en) | 2012-06-22 | 2015-12-15 | Intuit Inc. | Regulation compliant data integration for financial institutions |
US9646316B2 (en) * | 2012-08-31 | 2017-05-09 | Ncr Corporation | Techniques for deployment of universal promotion conditions for offer evaluations |
US10360627B2 (en) | 2012-12-13 | 2019-07-23 | Visa International Service Association | Systems and methods to provide account features via web based user interfaces |
US10489754B2 (en) | 2013-11-11 | 2019-11-26 | Visa International Service Association | Systems and methods to facilitate the redemption of offer benefits in a form of third party statement credits |
US10419379B2 (en) | 2014-04-07 | 2019-09-17 | Visa International Service Association | Systems and methods to program a computing system to process related events via workflows configured using a graphical user interface |
US10354268B2 (en) | 2014-05-15 | 2019-07-16 | Visa International Service Association | Systems and methods to organize and consolidate data for improved data storage and processing |
US10650398B2 (en) | 2014-06-16 | 2020-05-12 | Visa International Service Association | Communication systems and methods to transmit data among a plurality of computing systems in processing benefit redemption |
US9961059B2 (en) * | 2014-07-10 | 2018-05-01 | Red Hat Israel, Ltd. | Authenticator plugin interface |
US10438226B2 (en) | 2014-07-23 | 2019-10-08 | Visa International Service Association | Systems and methods of using a communication network to coordinate processing among a plurality of separate computing systems |
GB201413258D0 (en) * | 2014-07-25 | 2014-09-10 | Wealthchart Ltd | Report generation |
US11210669B2 (en) | 2014-10-24 | 2021-12-28 | Visa International Service Association | Systems and methods to set up an operation at a computer system connected with a plurality of computer systems via a computer network using a round trip communication of an identifier of the operation |
US20160260097A1 (en) * | 2015-03-06 | 2016-09-08 | Mastercard International Incorporated | Assignment of transactions to sub-accounts in payment account system |
US9691085B2 (en) | 2015-04-30 | 2017-06-27 | Visa International Service Association | Systems and methods of natural language processing and statistical analysis to identify matching categories |
US10719667B1 (en) * | 2015-06-30 | 2020-07-21 | Google Llc | Providing a natural language based application program interface |
US10891445B2 (en) * | 2019-02-28 | 2021-01-12 | International Business Machines Corporation | Using decay characteristics for natural language understanding output |
Citations (88)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5047269A (en) * | 1987-01-14 | 1991-09-10 | Lanxide Technology Company, Lp | Assembly for making ceramic composite structures and method of using the same |
US5189608A (en) * | 1987-06-01 | 1993-02-23 | Imrs Operations, Inc. | Method and apparatus for storing and generating financial information employing user specified input and output formats |
US5255184A (en) * | 1990-12-19 | 1993-10-19 | Andersen Consulting | Airline seat inventory control method and apparatus for computerized airline reservation systems |
US5477040A (en) * | 1994-05-23 | 1995-12-19 | Lalonde; Michael G. | Structure for a method of facilitating charge transactions |
US5521363A (en) * | 1994-02-16 | 1996-05-28 | Tannenbaum; David H. | System and method for tracking memory card transactions |
US5557516A (en) * | 1994-02-04 | 1996-09-17 | Mastercard International | System and method for conducting cashless transactions |
US5570283A (en) * | 1994-11-18 | 1996-10-29 | Travelnet, Inc. | Corporate travel controller |
US5638519A (en) * | 1994-05-20 | 1997-06-10 | Haluska; John E. | Electronic method and system for controlling and tracking information related to business transactions |
US5649115A (en) * | 1994-06-02 | 1997-07-15 | Intuit, Inc. | Tracking method and apparatus |
US5699528A (en) * | 1995-10-31 | 1997-12-16 | Mastercard International, Inc. | System and method for bill delivery and payment over a communications network |
US5701466A (en) * | 1992-03-04 | 1997-12-23 | Singapore Computer Systems Limited | Apparatus and method for end user queries |
US5704044A (en) * | 1993-12-23 | 1997-12-30 | The Pharmacy Fund, Inc. | Computerized healthcare accounts receivable purchasing, collections, securitization and management system |
US5710889A (en) * | 1995-02-22 | 1998-01-20 | Citibank, N.A. | Interface device for electronically integrating global financial services |
US5740271A (en) * | 1994-07-27 | 1998-04-14 | On-Track Management System | Expenditure monitoring system |
US5749079A (en) * | 1992-03-04 | 1998-05-05 | Singapore Computer Systems Limited | End user query facility including a query connectivity driver |
US5787403A (en) * | 1995-03-08 | 1998-07-28 | Huntington Bancshares, Inc. | Bank-centric service platform, network and system |
US5832451A (en) * | 1996-01-23 | 1998-11-03 | Electronic Data Systems Corporation | Automated travel service management information system |
US5832460A (en) * | 1995-06-02 | 1998-11-03 | International Business Machines Corporation | Method and system for bill presentation and payment reconciliation |
US5842185A (en) * | 1993-02-18 | 1998-11-24 | Intuit Inc. | Method and system for electronically tracking financial transactions |
US5852812A (en) * | 1995-08-23 | 1998-12-22 | Microsoft Corporation | Billing system for a network |
US5859419A (en) * | 1995-09-28 | 1999-01-12 | Sol H. Wynn | Programmable multiple company credit card system |
US5903881A (en) * | 1997-06-05 | 1999-05-11 | Intuit, Inc. | Personal online banking with integrated online statement and checkbook user interface |
US5948040A (en) * | 1994-06-24 | 1999-09-07 | Delorme Publishing Co. | Travel reservation information and planning system |
US5963925A (en) * | 1996-10-09 | 1999-10-05 | Visa International Service Association | Electronic statement presentment system |
US6009408A (en) * | 1996-04-01 | 1999-12-28 | Electronic Data Systems Corporation | Automated processing of travel related expenses |
US6012050A (en) * | 1996-11-29 | 2000-01-04 | Ncr Corporation | Multi-transaction service system |
US6029144A (en) * | 1997-08-29 | 2000-02-22 | International Business Machines Corporation | Compliance-to-policy detection method and system |
US6047268A (en) * | 1997-11-04 | 2000-04-04 | A.T.&T. Corporation | Method and apparatus for billing for transactions conducted over the internet |
US6068194A (en) * | 1998-02-12 | 2000-05-30 | Cummins-Allison Corporation | Software loading system for an automatic funds processing system |
US6072870A (en) * | 1996-06-17 | 2000-06-06 | Verifone Inc. | System, method and article of manufacture for a gateway payment architecture utilizing a multichannel, extensible, flexible architecture |
US6078907A (en) * | 1998-02-18 | 2000-06-20 | Lamm; David | Method and system for electronically presenting and paying bills |
US6115458A (en) * | 1995-07-14 | 2000-09-05 | American Express Travel Related Services Company, Inc. | Method and apparatus for summaries of prepaid instrument transaction activity |
US6119456A (en) * | 1998-01-21 | 2000-09-19 | Sauer Inc. | Displacement control with load feedback and stroke control for a hydraulic unit |
US6128602A (en) * | 1997-10-27 | 2000-10-03 | Bank Of America Corporation | Open-architecture system for real-time consolidation of information from multiple financial systems |
US6128603A (en) * | 1997-09-09 | 2000-10-03 | Dent; Warren T. | Consumer-based system and method for managing and paying electronic billing statements |
US6154729A (en) * | 1998-06-19 | 2000-11-28 | First Data Corporation | Method of reporting merchant information to banks |
US6178409B1 (en) * | 1996-06-17 | 2001-01-23 | Verifone, Inc. | System, method and article of manufacture for multiple-entry point virtual point of sale architecture |
US6185544B1 (en) * | 1996-06-07 | 2001-02-06 | Shimizu Construction Co., Ltd. | Processing system for charge request data |
US6185542B1 (en) * | 1998-07-31 | 2001-02-06 | Lucent Technologies Inc. | Communication of transaction data via the internet |
US6202054B1 (en) * | 1989-12-08 | 2001-03-13 | Online Resources & Communications Corp. | Method and system for remote delivery of retail banking services |
US6285991B1 (en) * | 1996-12-13 | 2001-09-04 | Visa International Service Association | Secure interactive electronic account statement delivery system |
US6292789B1 (en) * | 1997-08-26 | 2001-09-18 | Citibank, N.A. | Method and system for bill presentment and payment |
US6304857B1 (en) * | 1998-06-08 | 2001-10-16 | Microsoft Corporation | Distributed electronic billing system with gateway interfacing biller and service center |
US20010047336A1 (en) * | 2000-04-03 | 2001-11-29 | Maycock Sidney M. | Credit card management system |
US20010056387A1 (en) * | 2000-02-17 | 2001-12-27 | Newriver, Inc. | Method and apparatus for providing financial transaction data via the internet |
US6343279B1 (en) * | 1998-08-26 | 2002-01-29 | American Management Systems, Inc. | System integrating credit card transactions into a financial management system |
US6345261B1 (en) * | 1999-09-21 | 2002-02-05 | Stockback Holdings, Inc. | Customer loyalty investment program |
US6351739B1 (en) * | 1995-07-07 | 2002-02-26 | Netcraft Corporation | Internet billing method |
US20020026416A1 (en) * | 2000-08-25 | 2002-02-28 | Provinse Shirely J. | System and method for account reconciliation |
US20020069122A1 (en) * | 2000-02-22 | 2002-06-06 | Insun Yun | Method and system for maximizing credit card purchasing power and minimizing interest costs over the internet |
US20020087410A1 (en) * | 1998-12-31 | 2002-07-04 | Walker Jay S. | Multiple party reward system utilizing single account |
US20020099635A1 (en) * | 2001-01-24 | 2002-07-25 | Jack Guiragosian | Control of account utilization |
US6442526B1 (en) * | 1995-09-06 | 2002-08-27 | The Sabre Group, Inc. | System for corporate travel planning and management |
US6446048B1 (en) * | 1999-09-03 | 2002-09-03 | Intuit, Inc. | Web-based entry of financial transaction information and subsequent download of such information |
US20020123948A1 (en) * | 2001-03-01 | 2002-09-05 | Kazutaka Yumoto | Account management system |
US20020133605A1 (en) * | 2001-03-19 | 2002-09-19 | Alok Khanna | Generation and use of rules for reading of data for online account aggregation |
US20020138343A1 (en) * | 2001-03-21 | 2002-09-26 | Harry Weatherford | Method of providing merchant rebates to purchasers |
US6493685B1 (en) * | 1999-02-10 | 2002-12-10 | The Chase Manhattan Bank | Electronic account presentation and response system and method |
US20020194127A1 (en) * | 2001-04-30 | 2002-12-19 | Randell Wayne L. | Method and system for processing invoices |
US20030023550A1 (en) * | 2000-02-10 | 2003-01-30 | Lee Sang Won | Method and system for billing on the internet |
US20030023524A1 (en) * | 2001-07-30 | 2003-01-30 | Fujitsu Limited | Notifying program and detailed statement display method |
US20030040987A1 (en) * | 2000-05-19 | 2003-02-27 | Hudson K. Dean | Global travel reporting system and method |
US20030061132A1 (en) * | 2001-09-26 | 2003-03-27 | Yu, Mason K. | System and method for categorizing, aggregating and analyzing payment transactions data |
US20030088487A1 (en) * | 2001-06-01 | 2003-05-08 | Wen-Che Cheng | Travel expense reimbursement system and method |
US20030097331A1 (en) * | 1998-03-30 | 2003-05-22 | Cohen Morris E. | Systems for financial and electronic commerce |
US20030120526A1 (en) * | 2001-10-16 | 2003-06-26 | Jonathan Altman | System and method for managing booking and expensing of travel products and services |
US20030144956A1 (en) * | 2002-01-28 | 2003-07-31 | Yu Mason K. | System and method for capturing payments data onto uniquely identified payer-carried chips for periodic upload and download with institutions |
US6609658B1 (en) * | 1997-06-24 | 2003-08-26 | Richard P. Sehr | Travel system and methods utilizing multi-application traveler cards |
US20030191711A1 (en) * | 2001-11-01 | 2003-10-09 | Jamison Eric W. | System and method for obtaining customer bill information and facilitating bill payment at biller websites |
US20030225690A1 (en) * | 2002-05-29 | 2003-12-04 | Xerox Corporation | Billing process and system |
US20030229588A1 (en) * | 2002-06-05 | 2003-12-11 | Pitney Bowes Incorporated | Voice enabled electronic bill presentment and payment system |
US20040002876A1 (en) * | 2002-03-06 | 2004-01-01 | Sommers Mark O. | System, method and computer program product for on-line travel and expense management |
US20040019560A1 (en) * | 1999-03-12 | 2004-01-29 | Evans Scott L. | System and method for debt presentment and resolution |
US6704039B2 (en) * | 1999-10-16 | 2004-03-09 | Martin Rangel Pena | Method and system for computer-aided telecommunication and financial transactions |
US20040054626A1 (en) * | 2002-09-17 | 2004-03-18 | Adn Technologies | Device for processing local accounts data with different formats, equipment and a method for treating associated data |
US20040122736A1 (en) * | 2002-10-11 | 2004-06-24 | Bank One, Delaware, N.A. | System and method for granting promotional rewards to credit account holders |
US20040249703A1 (en) * | 2002-11-18 | 2004-12-09 | Stefan Weiszfeiler | Method and system for providing an incentive to customers |
US6959339B1 (en) * | 1998-11-06 | 2005-10-25 | International Business Machines Corporation | Technique for handling a universal image format on the internet |
US20050289025A1 (en) * | 2004-06-23 | 2005-12-29 | Michael Fredericks | System and method for expense management |
US7181419B1 (en) * | 2001-09-13 | 2007-02-20 | Ewinwin, Inc. | Demand aggregation system |
US7353208B1 (en) * | 2000-02-02 | 2008-04-01 | Transaction Network Services, Inc. | Transaction processing using intermediate server architecture |
US7383218B1 (en) * | 2002-07-31 | 2008-06-03 | Charles Schwab & Co., Inc. | Method and system for integrating investment advice with financial account statement information |
US20080201291A1 (en) * | 2007-02-16 | 2008-08-21 | Fussner John W | Personnel accounting system |
US20080319808A1 (en) * | 2004-02-17 | 2008-12-25 | Wofford Victoria A | Travel Monitoring |
US20090313053A1 (en) * | 2002-08-14 | 2009-12-17 | John S. Gengarella | Guest Relationship Management System |
US20090322560A1 (en) * | 2008-06-30 | 2009-12-31 | General Motors Corporation | In-vehicle alert delivery maximizing communications efficiency and subscriber privacy |
US20120072521A1 (en) * | 2009-05-26 | 2012-03-22 | Motify Pty Ltd | System and method for tracking events |
US8458067B2 (en) * | 2003-05-06 | 2013-06-04 | American Express Travel Related Services Company, Inc. | System and method for emergency tracking |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6119458A (en) * | 1998-12-29 | 2000-09-19 | Harris; James Jeffrey | Immiscible, direct contact, floating bed enhanced, liquid/liquid heat transfer process |
-
2003
- 2003-06-27 US US10/608,764 patent/US7647257B2/en not_active Expired - Fee Related
-
2004
- 2004-03-15 WO PCT/US2004/007856 patent/WO2004102358A2/en active Application Filing
-
2006
- 2006-10-23 US US11/551,778 patent/US20070073588A1/en not_active Abandoned
-
2007
- 2007-03-22 US US11/689,958 patent/US20070192222A1/en not_active Abandoned
Patent Citations (90)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5047269A (en) * | 1987-01-14 | 1991-09-10 | Lanxide Technology Company, Lp | Assembly for making ceramic composite structures and method of using the same |
US5189608A (en) * | 1987-06-01 | 1993-02-23 | Imrs Operations, Inc. | Method and apparatus for storing and generating financial information employing user specified input and output formats |
US6202054B1 (en) * | 1989-12-08 | 2001-03-13 | Online Resources & Communications Corp. | Method and system for remote delivery of retail banking services |
US5255184A (en) * | 1990-12-19 | 1993-10-19 | Andersen Consulting | Airline seat inventory control method and apparatus for computerized airline reservation systems |
US5749079A (en) * | 1992-03-04 | 1998-05-05 | Singapore Computer Systems Limited | End user query facility including a query connectivity driver |
US5701466A (en) * | 1992-03-04 | 1997-12-23 | Singapore Computer Systems Limited | Apparatus and method for end user queries |
US5842185A (en) * | 1993-02-18 | 1998-11-24 | Intuit Inc. | Method and system for electronically tracking financial transactions |
US5704044A (en) * | 1993-12-23 | 1997-12-30 | The Pharmacy Fund, Inc. | Computerized healthcare accounts receivable purchasing, collections, securitization and management system |
US5557516A (en) * | 1994-02-04 | 1996-09-17 | Mastercard International | System and method for conducting cashless transactions |
US5521363A (en) * | 1994-02-16 | 1996-05-28 | Tannenbaum; David H. | System and method for tracking memory card transactions |
US5638519A (en) * | 1994-05-20 | 1997-06-10 | Haluska; John E. | Electronic method and system for controlling and tracking information related to business transactions |
US5477040A (en) * | 1994-05-23 | 1995-12-19 | Lalonde; Michael G. | Structure for a method of facilitating charge transactions |
US5649115A (en) * | 1994-06-02 | 1997-07-15 | Intuit, Inc. | Tracking method and apparatus |
US5948040A (en) * | 1994-06-24 | 1999-09-07 | Delorme Publishing Co. | Travel reservation information and planning system |
US5740271A (en) * | 1994-07-27 | 1998-04-14 | On-Track Management System | Expenditure monitoring system |
US5570283A (en) * | 1994-11-18 | 1996-10-29 | Travelnet, Inc. | Corporate travel controller |
US5710889A (en) * | 1995-02-22 | 1998-01-20 | Citibank, N.A. | Interface device for electronically integrating global financial services |
US5890140A (en) * | 1995-02-22 | 1999-03-30 | Citibank, N.A. | System for communicating with an electronic delivery system that integrates global financial services |
US5787403A (en) * | 1995-03-08 | 1998-07-28 | Huntington Bancshares, Inc. | Bank-centric service platform, network and system |
US5832460A (en) * | 1995-06-02 | 1998-11-03 | International Business Machines Corporation | Method and system for bill presentation and payment reconciliation |
US6351739B1 (en) * | 1995-07-07 | 2002-02-26 | Netcraft Corporation | Internet billing method |
US6115458A (en) * | 1995-07-14 | 2000-09-05 | American Express Travel Related Services Company, Inc. | Method and apparatus for summaries of prepaid instrument transaction activity |
US5852812A (en) * | 1995-08-23 | 1998-12-22 | Microsoft Corporation | Billing system for a network |
US6442526B1 (en) * | 1995-09-06 | 2002-08-27 | The Sabre Group, Inc. | System for corporate travel planning and management |
US5859419A (en) * | 1995-09-28 | 1999-01-12 | Sol H. Wynn | Programmable multiple company credit card system |
US5699528A (en) * | 1995-10-31 | 1997-12-16 | Mastercard International, Inc. | System and method for bill delivery and payment over a communications network |
US5832451A (en) * | 1996-01-23 | 1998-11-03 | Electronic Data Systems Corporation | Automated travel service management information system |
US6009408A (en) * | 1996-04-01 | 1999-12-28 | Electronic Data Systems Corporation | Automated processing of travel related expenses |
US6185544B1 (en) * | 1996-06-07 | 2001-02-06 | Shimizu Construction Co., Ltd. | Processing system for charge request data |
US6072870A (en) * | 1996-06-17 | 2000-06-06 | Verifone Inc. | System, method and article of manufacture for a gateway payment architecture utilizing a multichannel, extensible, flexible architecture |
US6178409B1 (en) * | 1996-06-17 | 2001-01-23 | Verifone, Inc. | System, method and article of manufacture for multiple-entry point virtual point of sale architecture |
US6385595B1 (en) * | 1996-10-09 | 2002-05-07 | Visa International Service Association | Electronic statement presentment system |
US5963925A (en) * | 1996-10-09 | 1999-10-05 | Visa International Service Association | Electronic statement presentment system |
US6012050A (en) * | 1996-11-29 | 2000-01-04 | Ncr Corporation | Multi-transaction service system |
US6285991B1 (en) * | 1996-12-13 | 2001-09-04 | Visa International Service Association | Secure interactive electronic account statement delivery system |
US5903881A (en) * | 1997-06-05 | 1999-05-11 | Intuit, Inc. | Personal online banking with integrated online statement and checkbook user interface |
US6609658B1 (en) * | 1997-06-24 | 2003-08-26 | Richard P. Sehr | Travel system and methods utilizing multi-application traveler cards |
US6292789B1 (en) * | 1997-08-26 | 2001-09-18 | Citibank, N.A. | Method and system for bill presentment and payment |
US6029144A (en) * | 1997-08-29 | 2000-02-22 | International Business Machines Corporation | Compliance-to-policy detection method and system |
US6128603A (en) * | 1997-09-09 | 2000-10-03 | Dent; Warren T. | Consumer-based system and method for managing and paying electronic billing statements |
US6128602A (en) * | 1997-10-27 | 2000-10-03 | Bank Of America Corporation | Open-architecture system for real-time consolidation of information from multiple financial systems |
US6047268A (en) * | 1997-11-04 | 2000-04-04 | A.T.&T. Corporation | Method and apparatus for billing for transactions conducted over the internet |
US6119456A (en) * | 1998-01-21 | 2000-09-19 | Sauer Inc. | Displacement control with load feedback and stroke control for a hydraulic unit |
US6068194A (en) * | 1998-02-12 | 2000-05-30 | Cummins-Allison Corporation | Software loading system for an automatic funds processing system |
US6078907A (en) * | 1998-02-18 | 2000-06-20 | Lamm; David | Method and system for electronically presenting and paying bills |
US20030097331A1 (en) * | 1998-03-30 | 2003-05-22 | Cohen Morris E. | Systems for financial and electronic commerce |
US6304857B1 (en) * | 1998-06-08 | 2001-10-16 | Microsoft Corporation | Distributed electronic billing system with gateway interfacing biller and service center |
US6154729A (en) * | 1998-06-19 | 2000-11-28 | First Data Corporation | Method of reporting merchant information to banks |
US6185542B1 (en) * | 1998-07-31 | 2001-02-06 | Lucent Technologies Inc. | Communication of transaction data via the internet |
US6343279B1 (en) * | 1998-08-26 | 2002-01-29 | American Management Systems, Inc. | System integrating credit card transactions into a financial management system |
US6959339B1 (en) * | 1998-11-06 | 2005-10-25 | International Business Machines Corporation | Technique for handling a universal image format on the internet |
US20020087410A1 (en) * | 1998-12-31 | 2002-07-04 | Walker Jay S. | Multiple party reward system utilizing single account |
US6493685B1 (en) * | 1999-02-10 | 2002-12-10 | The Chase Manhattan Bank | Electronic account presentation and response system and method |
US20040019560A1 (en) * | 1999-03-12 | 2004-01-29 | Evans Scott L. | System and method for debt presentment and resolution |
US6446048B1 (en) * | 1999-09-03 | 2002-09-03 | Intuit, Inc. | Web-based entry of financial transaction information and subsequent download of such information |
US6345261B1 (en) * | 1999-09-21 | 2002-02-05 | Stockback Holdings, Inc. | Customer loyalty investment program |
US6704039B2 (en) * | 1999-10-16 | 2004-03-09 | Martin Rangel Pena | Method and system for computer-aided telecommunication and financial transactions |
US7353208B1 (en) * | 2000-02-02 | 2008-04-01 | Transaction Network Services, Inc. | Transaction processing using intermediate server architecture |
US20030023550A1 (en) * | 2000-02-10 | 2003-01-30 | Lee Sang Won | Method and system for billing on the internet |
US20010056387A1 (en) * | 2000-02-17 | 2001-12-27 | Newriver, Inc. | Method and apparatus for providing financial transaction data via the internet |
US20020069122A1 (en) * | 2000-02-22 | 2002-06-06 | Insun Yun | Method and system for maximizing credit card purchasing power and minimizing interest costs over the internet |
US20010047336A1 (en) * | 2000-04-03 | 2001-11-29 | Maycock Sidney M. | Credit card management system |
US20030040987A1 (en) * | 2000-05-19 | 2003-02-27 | Hudson K. Dean | Global travel reporting system and method |
US20020026416A1 (en) * | 2000-08-25 | 2002-02-28 | Provinse Shirely J. | System and method for account reconciliation |
US20020099635A1 (en) * | 2001-01-24 | 2002-07-25 | Jack Guiragosian | Control of account utilization |
US20020123948A1 (en) * | 2001-03-01 | 2002-09-05 | Kazutaka Yumoto | Account management system |
US20020133605A1 (en) * | 2001-03-19 | 2002-09-19 | Alok Khanna | Generation and use of rules for reading of data for online account aggregation |
US20020138343A1 (en) * | 2001-03-21 | 2002-09-26 | Harry Weatherford | Method of providing merchant rebates to purchasers |
US20020194127A1 (en) * | 2001-04-30 | 2002-12-19 | Randell Wayne L. | Method and system for processing invoices |
US20030088487A1 (en) * | 2001-06-01 | 2003-05-08 | Wen-Che Cheng | Travel expense reimbursement system and method |
US20030023524A1 (en) * | 2001-07-30 | 2003-01-30 | Fujitsu Limited | Notifying program and detailed statement display method |
US7181419B1 (en) * | 2001-09-13 | 2007-02-20 | Ewinwin, Inc. | Demand aggregation system |
US20030061132A1 (en) * | 2001-09-26 | 2003-03-27 | Yu, Mason K. | System and method for categorizing, aggregating and analyzing payment transactions data |
US20030120526A1 (en) * | 2001-10-16 | 2003-06-26 | Jonathan Altman | System and method for managing booking and expensing of travel products and services |
US20030191711A1 (en) * | 2001-11-01 | 2003-10-09 | Jamison Eric W. | System and method for obtaining customer bill information and facilitating bill payment at biller websites |
US20030144956A1 (en) * | 2002-01-28 | 2003-07-31 | Yu Mason K. | System and method for capturing payments data onto uniquely identified payer-carried chips for periodic upload and download with institutions |
US20040002876A1 (en) * | 2002-03-06 | 2004-01-01 | Sommers Mark O. | System, method and computer program product for on-line travel and expense management |
US20030225690A1 (en) * | 2002-05-29 | 2003-12-04 | Xerox Corporation | Billing process and system |
US20030229588A1 (en) * | 2002-06-05 | 2003-12-11 | Pitney Bowes Incorporated | Voice enabled electronic bill presentment and payment system |
US7383218B1 (en) * | 2002-07-31 | 2008-06-03 | Charles Schwab & Co., Inc. | Method and system for integrating investment advice with financial account statement information |
US20090313053A1 (en) * | 2002-08-14 | 2009-12-17 | John S. Gengarella | Guest Relationship Management System |
US20040054626A1 (en) * | 2002-09-17 | 2004-03-18 | Adn Technologies | Device for processing local accounts data with different formats, equipment and a method for treating associated data |
US20040122736A1 (en) * | 2002-10-11 | 2004-06-24 | Bank One, Delaware, N.A. | System and method for granting promotional rewards to credit account holders |
US20040249703A1 (en) * | 2002-11-18 | 2004-12-09 | Stefan Weiszfeiler | Method and system for providing an incentive to customers |
US8458067B2 (en) * | 2003-05-06 | 2013-06-04 | American Express Travel Related Services Company, Inc. | System and method for emergency tracking |
US20080319808A1 (en) * | 2004-02-17 | 2008-12-25 | Wofford Victoria A | Travel Monitoring |
US20050289025A1 (en) * | 2004-06-23 | 2005-12-29 | Michael Fredericks | System and method for expense management |
US20080201291A1 (en) * | 2007-02-16 | 2008-08-21 | Fussner John W | Personnel accounting system |
US20090322560A1 (en) * | 2008-06-30 | 2009-12-31 | General Motors Corporation | In-vehicle alert delivery maximizing communications efficiency and subscriber privacy |
US20120072521A1 (en) * | 2009-05-26 | 2012-03-22 | Motify Pty Ltd | System and method for tracking events |
Cited By (29)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110313830A1 (en) * | 2006-12-29 | 2011-12-22 | American Express Travel Related Services Company, Inc. | System and method for targeting transaction account product holders to receive upgraded transaction account products |
US8688503B2 (en) | 2006-12-29 | 2014-04-01 | American Express Travel Related Services Company, Inc. | System and method for targeting family members of transaction account product holders to receive supplementary transaction account products |
US8229784B2 (en) * | 2006-12-29 | 2012-07-24 | American Express Travel Related Services Company, Inc. | System and method for targeting transaction account product holders to receive upgraded transaction account products |
US8332273B1 (en) * | 2007-12-07 | 2012-12-11 | Jpmorgan Chase Bank, Na | System and method for associating financial transaction data with a user's project data |
US8204804B2 (en) * | 2007-12-07 | 2012-06-19 | Jpmorgan Chase Bank, N.A. | System for associating financial transaction data with user's project data |
US20140188678A1 (en) * | 2007-12-07 | 2014-07-03 | Jpmorgan Chase Bank, N.A. | System and Method for Associating Financial Transaction Data with a User's Project Data Using a Portable Electronic Device |
US8712874B2 (en) * | 2007-12-07 | 2014-04-29 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with a user's project data using a portable electronic device |
US8738475B2 (en) * | 2007-12-07 | 2014-05-27 | Jpmorgan Chase Bank, Na | System and method for associating financial transaction data with a user's project data using a portable electronic device |
US8725602B1 (en) * | 2007-12-07 | 2014-05-13 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with user's project data in real time |
US8712875B2 (en) * | 2007-12-07 | 2014-04-29 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with user's project data |
US8515836B1 (en) * | 2007-12-07 | 2013-08-20 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with user's project data using a portable electronic device |
US20130218734A1 (en) * | 2007-12-07 | 2013-08-22 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with a user's project data using a portable electronic device |
US20130325675A1 (en) * | 2007-12-07 | 2013-12-05 | Marcia Keld | System and Method for Associating Financial Transaction Data with a User's Project Data Using a Portable Electronic Device |
US20140012722A1 (en) * | 2007-12-07 | 2014-01-09 | Jpmorgan Chase Bank, N.A. | System and Method for Associating Financial Transaction Data with User's Project Data |
US20110218893A1 (en) * | 2007-12-07 | 2011-09-08 | Jpmorgan Chase Bank, N.A. | System for Associating Financial Transaction Data with User's Project Data |
US8332288B2 (en) | 2008-12-17 | 2012-12-11 | Mastercard International Incorporated | Interactive online spending analysis tool |
US20100153242A1 (en) * | 2008-12-17 | 2010-06-17 | Mastercard International, Inc. | Interactive Online Spending Analysis Tool |
US8027891B2 (en) | 2008-12-17 | 2011-09-27 | Mastercard International, Inc. | Interactive online spending analysis tool |
US8447666B1 (en) * | 2009-02-19 | 2013-05-21 | Jpmorgan Chase Bank, N.A. | System and method for associating financial transaction data with user's project data using a portable electronic device |
US20120317003A1 (en) * | 2011-06-09 | 2012-12-13 | Mcgrane Russell | Automated expense account report generator |
US10909637B1 (en) | 2014-09-22 | 2021-02-02 | Certify, Inc. | Automated expense report systems and methods |
US10210579B1 (en) | 2014-09-22 | 2019-02-19 | Certify, Inc. | Automated expense reports systems and methods |
US10909636B1 (en) | 2014-09-22 | 2021-02-02 | Certify, Inc. | System, method and non-transitory computer readable medium for parsing receipt information |
US9922375B1 (en) | 2014-09-22 | 2018-03-20 | Certify, Inc. | Systems and methods of parsing receipts |
US11568497B2 (en) | 2014-09-22 | 2023-01-31 | Certify, Inc. | Automated expense report systems and methods |
US10497065B1 (en) * | 2014-11-19 | 2019-12-03 | Ab Initio Technology Llc | Automatically correcting records |
CN110502511A (en) * | 2019-07-01 | 2019-11-26 | 招联消费金融有限公司 | Numeric value transfer and device, computer equipment and storage medium |
US11687519B2 (en) | 2021-08-11 | 2023-06-27 | T-Mobile Usa, Inc. | Ensuring availability and integrity of a database across geographical regions |
US12045226B2 (en) | 2021-08-11 | 2024-07-23 | T-Mobile Usa, Inc. | Ensuring availability and integrity of a database across geographical regions |
Also Published As
Publication number | Publication date |
---|---|
US20040225603A1 (en) | 2004-11-11 |
WO2004102358B1 (en) | 2005-07-21 |
US7647257B2 (en) | 2010-01-12 |
US20070073588A1 (en) | 2007-03-29 |
WO2004102358A2 (en) | 2004-11-25 |
WO2004102358A3 (en) | 2005-06-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20070192222A1 (en) | System and Method for Producing Transaction Level Detail Based on a Card Spend Transaction | |
US8458067B2 (en) | System and method for emergency tracking | |
US7386528B2 (en) | System and method for acquisition, assimilation and storage of information | |
US20040010458A1 (en) | Methods and systems for organizing information from multiple sources | |
US8332378B2 (en) | File listener system and method | |
US20180046947A1 (en) | Data processing framework | |
US7548615B2 (en) | Rate validation system and method | |
CA2647250A1 (en) | Information management system and method | |
US20110119178A1 (en) | Metadata driven processing | |
US20110119188A1 (en) | Business to business trading network system and method | |
US7650301B2 (en) | System and method for monitoring acquisition channels | |
AU2010322245B2 (en) | Metadata driven processing | |
CA2686296A1 (en) | Metadata driven processing |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:MIKA, LAWRENCE;PITTSON, MALINDA;NICHOLLS, ANDY;REEL/FRAME:019052/0496;SIGNING DATES FROM 20070312 TO 20070321 |
|
AS | Assignment |
Owner name: III HOLDINGS 1, LLC, DELAWARE Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.;REEL/FRAME:032722/0746 Effective date: 20140324 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |
|
AS | Assignment |
Owner name: LIBERTY PEAK VENTURES, LLC, TEXAS Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:III HOLDINGS 1, LLC;REEL/FRAME:045660/0060 Effective date: 20180315 |