CA2411617A1 - System, computer product and method for web-enabled accounting - Google Patents
System, computer product and method for web-enabled accounting Download PDFInfo
- Publication number
- CA2411617A1 CA2411617A1 CA002411617A CA2411617A CA2411617A1 CA 2411617 A1 CA2411617 A1 CA 2411617A1 CA 002411617 A CA002411617 A CA 002411617A CA 2411617 A CA2411617 A CA 2411617A CA 2411617 A1 CA2411617 A1 CA 2411617A1
- Authority
- CA
- Canada
- Prior art keywords
- facility
- data
- financial documents
- books
- documents
- 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
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
- G06Q30/00—Commerce
- G06Q30/04—Billing or invoicing
Abstract
A system, computer product and method for providing a set of documents reconciled in accordance with business rules via the Internet is provided. The system, computer product and method of the present invention enables web-based bookkeeping in particular. A client provides a plurality of business documents to the operator of a web server. The business documents are provided electronically or in the form of scanned images the documents or via data entry interfaces. The web server includes a series of tools that enable the business documents to be converted into reconciled books such that access to supporting documents is readily available in accordance with a series of business rules.
Description
System. Computer Product and Method for Web-Enabled Accounting Field of the Invention s This invention relates in general to a method, system and apparatus for providing accounting over the Internet. More particularly, this invention relates to a system, method and computer product for creating a reconciled set of electronic books based on paper supporting documents such as cheques, invoices, receipts, contracts, purchase orders, shipping documents io and the like.
Background of the Invention The typical accounting cycle for an organization begins with i s bookkeeping. Bookkeeping relates to the creation of "reconciled" books whereby transactions against a client's various bank accounts is accounted for, explained, and documented. This process involves, for example, the cross-referencing of transactions reflected in a bank statement for a particular bank account with the various underlying financial documents such as 2o cheques, receipts, invoices, and so on.
Bookkeeping is generally contrasted from other accounting services such as financial statement preparation, tax filing, tax planning, audit services and so on.
Once the reconciled books have been completed for the target reporting period, the next step is the preparation of Financial Statements. In this step, an accountant starts with the reconciled books and makes adjustments for accruals and amortization. Typically, the results are an 3o Income Statement Report and Balance Sheet Report. After this step, the accountant may then do tax filings and tax planning, as may be required by the client.
Background of the Invention The typical accounting cycle for an organization begins with i s bookkeeping. Bookkeeping relates to the creation of "reconciled" books whereby transactions against a client's various bank accounts is accounted for, explained, and documented. This process involves, for example, the cross-referencing of transactions reflected in a bank statement for a particular bank account with the various underlying financial documents such as 2o cheques, receipts, invoices, and so on.
Bookkeeping is generally contrasted from other accounting services such as financial statement preparation, tax filing, tax planning, audit services and so on.
Once the reconciled books have been completed for the target reporting period, the next step is the preparation of Financial Statements. In this step, an accountant starts with the reconciled books and makes adjustments for accruals and amortization. Typically, the results are an 3o Income Statement Report and Balance Sheet Report. After this step, the accountant may then do tax filings and tax planning, as may be required by the client.
Electronic banking is well known. It includes a series of electronic financial transactions such as INTERAC, direct deposit and direct withdrawal, as well as access to bank statements electronically. In addition, e-business s implementations have become relatively widespread whereby transactions that were formerly paper based such as exchange of sales and delivery documentation (including trade documents such as orders, shipping documents, receipts etc.) have been replaced by electronic transactions.
~o This has somewhat reduced the importance of paper based financial documents such as cheques, receipts, and trade documents. However, many financial and trade transactions are still verified using paper based documents especially as a means of implementing control procedures such as sign off procedures. In the case of other clients, paper based transactions continue to ~ s be important notwithstanding the availability of electronic banking and e-business systems.
Wherever there is an occurrence of paper based documents, the cross-referencing of transactions with underlying documents, and storage of such 2o documents in a manner that supports the verification of documents in support of verification of the reconciled books represents a significant investment of time and effort.
Prior art bookkeeping methods generally involve cross-referencing Zs individual transactions with either paper-based financial documents or data recording underlying electronic transactions. Missing support for transactions are flagged, and support documents or data is then obtained and then cross-referenced with the books.
3o This type of bookkeeping has traditionally been performed by bookkeepers or accountants based on principally manual processes. While there are numerous software accounting packages that are available, because of the relative complexity of the rules around creation of proper reconciled books, these accounting packages have not generally altered these manual processes substantially.
s There is a need for a system, computer product, and method for web based bookkeeping, whereby functions related to the creation of reconciled books are reduced to data entry functions with built in control mechanisms.
There is a further need for a system, computer product and method of i o web based bookkeeping whereby reconciled books, financial statements and other accounting documents are generated that permit financial documents relating to particular entries in such accounting documents to be verified from the accounting documents.
~s Summary of the Invention It is an object of the present invention to provide a system, computer product and method for a system, computer product, and method for web based bookkeeping, whereby functions related to the creation of reconciled 2o books are reduced to data entry functions with built in control mechanisms..
Another aspect of the present invention is that for a system, computer product and method of web based bookkeeping whereby reconciled books, financial statements and other accounting documents are generated that 2s permit financial documents relating to particular entries in such accounting documents to be verified from the accounting documents.
Brief Description of the Drawings ;o A detailed description of the preferred embodiments) is(are) provided herein below by way of example only and with reference to the following drawings, in which:
~o This has somewhat reduced the importance of paper based financial documents such as cheques, receipts, and trade documents. However, many financial and trade transactions are still verified using paper based documents especially as a means of implementing control procedures such as sign off procedures. In the case of other clients, paper based transactions continue to ~ s be important notwithstanding the availability of electronic banking and e-business systems.
Wherever there is an occurrence of paper based documents, the cross-referencing of transactions with underlying documents, and storage of such 2o documents in a manner that supports the verification of documents in support of verification of the reconciled books represents a significant investment of time and effort.
Prior art bookkeeping methods generally involve cross-referencing Zs individual transactions with either paper-based financial documents or data recording underlying electronic transactions. Missing support for transactions are flagged, and support documents or data is then obtained and then cross-referenced with the books.
3o This type of bookkeeping has traditionally been performed by bookkeepers or accountants based on principally manual processes. While there are numerous software accounting packages that are available, because of the relative complexity of the rules around creation of proper reconciled books, these accounting packages have not generally altered these manual processes substantially.
s There is a need for a system, computer product, and method for web based bookkeeping, whereby functions related to the creation of reconciled books are reduced to data entry functions with built in control mechanisms.
There is a further need for a system, computer product and method of i o web based bookkeeping whereby reconciled books, financial statements and other accounting documents are generated that permit financial documents relating to particular entries in such accounting documents to be verified from the accounting documents.
~s Summary of the Invention It is an object of the present invention to provide a system, computer product and method for a system, computer product, and method for web based bookkeeping, whereby functions related to the creation of reconciled 2o books are reduced to data entry functions with built in control mechanisms..
Another aspect of the present invention is that for a system, computer product and method of web based bookkeeping whereby reconciled books, financial statements and other accounting documents are generated that 2s permit financial documents relating to particular entries in such accounting documents to be verified from the accounting documents.
Brief Description of the Drawings ;o A detailed description of the preferred embodiments) is(are) provided herein below by way of example only and with reference to the following drawings, in which:
Figure 1 is a system component chart in accordance with one embodiment of the present invention.
s Figure 2 illustrates the resources of the software product of the present invention, in accordance with one embodiment thereof.
In the drawings, preferred embodiments of the invention are illustrated by way of example. It is to be expressly understood that the description and io drawings are only for the purpose of illustration and as an aid to understanding, and are not intended as a definition of the limits of the invention.
Detailed Description of the Preferred Embodiment Referring to Fig. 1, there is illustrated a system component flow chart for the system of the present invention. By means of the Internet medium 10, Server 12 is made accessible to one or more Users.
2o In accordance with the method of the present invention, there are generally three categories of Users. The first category is "Data Entry Personnel" 14 generally comprising data entry clerks.
The second category is "Supervising Personnel" or "Accounting 2s Personnel" 16. As explained below, the function of the "Accounting Personnel" is to exercise quality control in regard to the data entry functions fulfilled by the Data Entry Personnel 14 to ensure that the reconciled books created in accordance with the present invention meet generally accepted accounting standards, as well as standards of accuracy. The Accounting 3o Personnel is contrasted from the Data Entry Personnel 14 and generally comprises an accountant, bookkeeper, or trained quality control resource.
The Accounting Personnel may include accountants associated with the operator of the present invention. Alternatively, the Accounting Personnel may include accountants associated with a licensee accounting firm of the present invention whereby the accountants supervise the creation of reconciled books in accordance with the present invention.
A third category is "Clients" 18. "Clients" may be accountants who are outsourcing the creation of reconciled books to the operator of the present solution and who are not involved in the supervisory role of the Accounting Personnel 16. "Clients" 18 may also include in addition to such accountants io the originators of the accounting data, such as for example a business having financial documents. The level of access to the present invention given to Clients will depend on whether they are accountants or clients of accountants.
It should be further understood that the description of the present i s invention draws principally on the example of the bookkeeping, and also functions in support of accounting. It should also be understood, however, that the present invention applies to other contexts as well where generation of reports depends on the reconciling of a plurality of supporting documents in accordance with a set of business rules, and whereby verification of the 2o reports requires ready access to the underlying supporting documents.
One aspect of the present invention is the provision of a web site 20 that facilitates the creation of reconciled books in accordance with the present invention, and further the access to such reconciled books, or other ?s documents that depend on such reconciled books, including underlying supporting financial or other documents in electronic form.
In the embodiments of the present invention illustrated herein, Server 12 comprises a computer 13, an Internet connection 20, communication ~o facility 24 and database 26. A computer product is loaded on the server 12 that includes a number of facilities including a database management facility 28, a linking facility 30, a reconciling facility 32, a web publication tool 34 and an administration facility 36.
The functionality of each of these elements of Server 12 is discussed s below. It should be understood, however, that the present invention encompasses providing the Internet environment described herein through the auspices of a variety of types of Internet connections, whether LAN
connections, fiber optic cable connections, wireless Internet connections, and so on. It should also be understood that the present invention encompasses to providing the Server 12 through any number of equivalents including any combination of hardware and software which enables the functions of this invention to be provided via the Internet, or any other inter-connected network of computers. Also, database 26 and database management facility 28 can be provided by a wide array of custom or off-the-shelf database and database is management products. In addition, said database management facility 28 can also incorporate a number of tools for identifying and manipulating relevant data, such as known knowledge management tools.
The present invention also contemplates interoperability of database 20 26 and database management facility 28 with other networks such as a corporate LAN, for example, to access from such LAN the data contained in database 26 or to make changes to the settings of database management facility 28 on a remote basis.
2s Administration facility 36 is a known tool that is controlled by the operator of Server 12 for controlling access to the resources of the Server 12, which are particularized below. The administration facility 36 is an important aspect of the present invention in that it ensures segregation of functions as between Data Entry Personnel 14, Accounting Personnel 16 and Clients 18.
3o This segregation of functions ensures the integrity of the reconciled books created in accordance with the present invention. The Administration facility 36, for example, is the technical means for ensuring that Data Entry _7_ Personnel 14 can only access the specific data entry interfaces referenced below; that only Accounting Personnel 16 can access the reconciling interfaces referenced below; and Client 18 can only access particular areas of the web site 20 that show the results of the present invention, i.e. their s reconciled books, without revealing the underlying linking and reconciliation process described herein.
The Administration facility 36 and web publication tool 34 cooperate to provide an "ADMINISTRATOR'S HOME PAGE" which includes the various io functions associated with the operation of the present invention. This home page provides a number of functions.
A first representative function is the ability to monitor the "SYSTEM
STATUS". This function allows the Administrator to verify the users that are is currently logged in, and also to access a "TIME STAMPED LOG". This function has a number of benefits. It allows management of resources, but also tracking of activities of Data Entry Personnel 14.
A second representative function is the "USER ADMINISTRATION"
2o function which permits such sub-functions as "FIND CLIENT USER", "FIND
STAFF USER", "CHANGE PASSWORD", "CREATE NEW CLIENT USER", "CREATE NEW STAFF USER", and "ADD NEW USER GROUP".
A third representative function is the "WIP" function that permits the 2s monitoring of workflow on the system of the present invention. This function permits the creation and display of a number of reports related to the workflow in progress on the system, for example, "FILES LOGGED IN BY MONTH", "CLIENT STATUS BALANCE SHEET", "YEAR ENDS NOT LOGGED IN BY
YEAR END MONTH", "ACCOUNT MANAGER PERFORMANCE" and so on.
~o In a fourth representative function, there is an "IMAGE HANDLING
FUNCTION" whereby the process of capturing of electronic images described _$_ below is managed by such sub-functions as "INSTALL IMAGES", "SHOW ALL
REWORKS", "SHOW ALL REWORKS FOR USER" and so on, In a fifth representative function, a "SYSTEM MAINTENANCE" function s includes a number of sub-functions that allow administration of the various components of the present system described herein, in a manner that is known.
In one embodiment of the Administration Facility 36, the various Users to are assigned username/password combinations corresponding to the access levels assigned by the administrator of the Server 12. Accordingly, the various Users can log on to the Server 12 and access the particular resources of the Internet Server 12 to which they are given access. using a known Internet browser.
IS
The web publication tool 34 permits, in a manner that is known, the creation, publication and population with data of the variety of web pages 36 discussed herein, including data entry interfaces, reconciling interfaces, reports, and web-based reconciled books and other accounting documents.
Web publication tool 34 also includes a series of known tools for selecting and/or altering the look and feel of the web pages in a manner that is known including for example having regard to fonts, colors, web formats, web layouts, navigation etc. One particular aspect of the web publication tool 2s 34 is that it permits the creation of custom areas of the Server 12. This permits, for example, the branding of web pages with the logos, symbols and text of particular Clients 18 such as an accounting firm licensee. To the clients of such an accounting firm, the web pages would have the "look and feel" of the accounting firm or other organization with whom they are familiar.
~o It should be understood that web publication tool 34 provides means for easily updating the web pages and related web templates 38 on a regular _9_ basis. This may be to account for new forms of reconciled books or data entry interfaces for new types of financial documents and the like.
It should be understood that the description of the steps of the present s invention in consecutive order is not meant to convey that the order of such steps is an essential element of the present invention.
In a first step of the present invention, an Administrator of the present invention establishes the various business rules associated with creating a io reconciled and linked document based on underlying supporting documents in accordance with the present invention. There are two aspects to these business rules. The first aspect is the business rules for reconciling a plurality of supporting documents to create a higher level document, such as a reconciled set of books based on underlying financial or other documents.
is The second aspect of the business rules are the rules for linking the underlying supporting documents such that when the higher level document is accessed the supporting documents can also be accessed through a known Internet browser, for example, during verification of the higher level document.
2o The above described business rules are established in accordance with known principles and stored in a known business rules repository 40 which is part of database 26. The business rules included in the business rule repository 40 are essentially parsing rules. The business rules repository in association with the database management facility 28 and database 26 ?s provide the aspects of the present invention described as the linking facility 30 and reconciling facility 32.
In a second step of the present invention, the database 26 is populated with data of Clients 18. In regard to the bookkeeping implementation of the ~o present invention, this data includes data regarding such documents as bank statements, bank deposits, bank withdrawals, expenses, and cancelled cheques. This data constitutes electronic data regarding such documents obtained, for example, from a known electronic banking facility.
In accordance with one particular embodiment of the present invention, s however, the data includes scanned images of paper based documents such as signed cancelled cheques, copies of bank statements received from banks, signed bank deposits, invoices from suppliers and so on. The scanned images are obtained through a variety of means. For example, clients may scan such paper based documents using known technology in to the memory lo of a computer, and then transmit the resultant data electronically to the Server 12 via the communication facility 24 in a manner that is known.
Alternatively, the underlying paper based documents are delivered to the operator of the Internet server 12 or to a licensee of the solution described ~s herein, and the paper based documents are then scanned to produce a series of electronic files.
As a still further alternative, the present invention includes a known fax database utility, whereby a particular Client 18 wishing to submit a particular 2o supporting document logs into the Server 12 and the web publication tool 34 cooperates with the database management facility 28 and database 26 to display a fax cover sheet that includes a bar code. The fax cover sheet is printed out by the Client 18 and the cover sheet is faxed along with the supporting document to a particular fax number associated with a fax machine 2s connected to Server 12. The Server 12 is provided with a computer application whereby the bar code is read from the electronic transmission which identifies the Client 18 to the Server. The electronic data comprising the supporting document is tagged and stored to the database 26. The supporting document is now available via the Internet.
The database management facility 28 of the present invention includes a known data import interface whereby the data described above is received and stored in a compatible format to the database 26, in a manner that is known. Each packet of data imported is tagged in a manner that is known within database 26.
Database 26 is a known relational database that supports queries made via the database management facility 28 across a particular segregation of tagged data, in a manner that is known. In a particular embodiment of the present invention, one aspect of the database management facility 28 of the present invention is a known database engine ~o to store document data such as IE ORACLE TM.
In another particular aspect of the database management facility 28, and a particular aspect of the web publication facility 34, a known electronic document storage and retrieval system is used to populate the database 26 is with further tagged data provided through a series of web interfaces as described below, and also to retrieve data from the database 26 in a series of web interfaces including web reports. In a particular implementation of the present invention this specific aspect of the present invention is provided using an IE NetscapeT"" web server.
ao In a third step of the present invention, paper based documents of a particular client are entered into the database 26, or electronic data is verified or enhanced in accordance with known data entry methods.
2s Data Entry Personnel 14 logs into the web site 20 and begins work.
One aspect of the present invention is a web page tailored to a particular member of the Data Entry Personnel 14 that helps the member manage their workflow. For example, when the particular member logs in to the web site 20, the web page displayed allows the particular member to begin with data ~o entry where they left off; review log of work completed in the past; and so on.
It is also contemplated by the present invention that the administration facility 36 will incorporate tools for managing labor standards whereby Data Entry J7 _ Personnel 14 performance is measured against engineered labor standards, and the web pages for particular members of the Data Entry Personnel 14 is used to report to the members on their performance compared to these labor standards.
s The web pages accessed by the Data Entry Personnel 14 permit a number of functions. First, they permit a search for a particular client.
Second, they provide a series of data entry screens, as mentioned above.
Third, they permit the Data Entry Personnel to engage both the linking facility io 30 and the reconciling facility 32 as stated below.
The web pages provide the Data Entry Personnel 14 with a known search engine for searching for data associated with a particular Client 18 based on key words, alphabetical drop down lists of Clients 18 and so on.
is Once a particular Client 18 has been located, a link is displayed which provides access via a browser to any data that exists on the database 26 for that particular client. In relation to a Client 18 who has been entered on the database 26 but the process of creating reconciled books in accordance with the present invention has not yet begun, the web publication tool 34 will 2o display in a web page a list of links corresponding with data objects (electronic data or images of paper based documents).
In accordance with a particular embodiment of the present invention, if the Data Entry Personnel 14 clicks on a link associated with a particular data 2s object, a data entry interface is displayed by the web publication tool 34.
In one aspect of the present invention, the Data Entry Personnel views the data object and determines based on a drop down menu the type of document that is represented by the data (bank statement, deposit, etc.). In another aspect of the present invention, the database management facility 28 and business ~o rule repository 4d cooperate to analyze the data objects and based on business rules determine the type of document that is likely represented by the data object.
- ~ .i -Generally speaking, the data entry process begins with a document that tends to summarize the various transactions that will have to be reconciled. For example, in relation to the creation of reconciled accounting s books for a business, the data entry process begins with the various bank statements of that business. In accordance with one aspect of the present invention therefore, if the bank statements are not available electronically, the Data Entry Personnel 14 will click on each bank statement in the list of data objects. This will bring up a web page that consists of a particular data entry io interface for bank statements. It is an aspect of the present invention, that once the type of document is identified for a data object, a web template 38 corresponding to that type of document is accessed and displayed for managing the workflow of the Data Entry Personnel 14.
~s The business rule repository 40 contains the various rules determining the workflow process for keying the data for a particular financial document, in association with the web templates 38. Generally speaking each web template 38 consists of a display area that displays the actual data object.
This display area generally permits the Data Entry Personnel 14 to scroll up or 2o down on the data object, vary the size of the data objects vis-a-vis the balance of the data entry interface, vary the size of the characters in the data object, and zoom in on parts of the data object that are particularly difficult to read. The web templates 38 also generally include a series of drop down menus that permit certain values to be selected, for example, the type of Zs transaction represented by a data object, or a particular transaction listed in a data object such as a bank statement. Lastly, the web templates 38 also include one or more data entry fields wherein information is entered manually by the Data Entry Personnel 14.
~o For example, in relation to a bank statement, the Data Entry Personnel 14 will generally pick the nature of the transaction, "BANK STATEMENT", from a scroll down menu. The Data Entry Personnel 14 will then proceed line by line and ensure that each line of the data in the bank statement is entered.
Scroll down menus are provided to pick the nature of the particular entry in the bank statement, for example, "CASH WITHDRAWAL", "CHEQUE", "DEBIT CARD WITHDRAWAL", "DEPOSIT", "SERVICE CHARGE", s "TRANSFER IN", "TRANSFER OUT", "UNKNOWN CREDIT" and "UNKNOWN DEBIT". In relation to the particular entries, the data entry interface requires the entry of specific information. For example, in relation to a cheque, the "DATE", "AMOUNT", and "CHEQUE NUMBER" is required.
~o The various underlying documents are also entered. For example, data entry interface specific to cancelled cheques shown in the bank statements, expenses corresponding to payments reflected in the bank statements are also accessed and the pertinent data is entered in a similar fashion.
~s The result of the above process is that the data contained in the data objects displayed in the list of documents of a particular Client 18 is fully entered in the database 26. In one aspect of the present invention, when the requisite data for a particular data object, in accordance with the business 2o rules contained in the business rules repository 40, has been entered, the particular data object will be "CHECKED" or indicated in some other way in the list of documents of a particular Client 18. This also assists in managing workflow.
2s In a fourth step of the present invention, the reconciling facility 32 is engaged to reconcile the various documents of a Client 18 in accordance with the rules provided to the business rule repository 40. The purpose of the reconciling facility 32 is the application to the data of a particular Client 18 of logic processes aimed at identifying data entry errors and gaps in the Client's ~o data as compared to data required to provide reconciled books in accordance with accounting standards in a particular jurisdiction.
-l5-The operation of the reconciling facility 32 is best understood in relation to an example in operation. The example provided illustrates, among other things, how the accounting rules for a particular jurisdiction (in this case Canada) are reflected in the business rules that provide the reconciling s facility's 32 logic.
Bank Statements As stated earlier, the central document is generally a document such io as a bank statement. For every line on the bank statement there is a record in the database that records:
1 ) Transaction Date 2) Transaction Amount ~s 3) Transaction Type (cheque, deposit, debit card withdrawal, service charge, etc) 4) Cheque Number (if applicable) 5) Description (if applicable) 2o For a given date range (i.e. a business cycle such as a tax year) the reconciling facility 32 examines each bank transaction recorded in the database 26 and locates other documents stored to the database 26 for the same Client 18 as per the following table:
Transaction Type Source Documents Deposit Deposit slip or an Invoice that has been recorded as deposited Cheque Cancelled cheque and an expense receipt Service Charge None Debit Card WithdrawalExpense receipt Cash Withdrawal None Transfer Out Corresponding transfer in from another bank account Transfer In Corresponding transfer out to this bank account Documents are located using the following rules:
Document Rules for Locating Type Deposit Slip A deposit for the target amount (in the same currency as the bank account) into the target bank account dated on the bank statement date or up to 3 days before.
Failing this mixed or foreign currency deposit slips are examined to find one that has an amount that is in between the notional exchange rate HIGH and LOW
values into the target bank account on the bank statement date or up to 3 days before.
Invoice An invoice for the target amount (in the same currency as the bank account) dated on the bank statement date or up to 3 days before. Failing this, foreign currency invoices are examined to find one that is dated on the bank statement date or up to 3 days before for an amount that is in between the notional exchange rate HIGH and LOW.
Cheque The cheque number, bank account, and amount must match. Failing this, foreign currency cheques are examined to find one that is drawn on the target bank account for an amount that is in between the notional exchange rate HIGH and LOW.
Expense An expense receipt for the target amount and cheque Receipt paid number. Failing this, foreign currency expense by receipts cheque are examined to find one that has the same cheque '' _17_ number and with an amount that is in between the notional exchange rate HIGH and LOW.
Debit Card An expense receipt for the target amount that is paid Withdrawal using a debit card that belongs to the target bank account. Failing this, foreign currency expense receipts are examined to find one that was paid using a debit card that is associated with the target bank account and with an amount that is in between the notional exchange rate HIGH and LOW.
Transfer Out A transfer in transaction on the target bank account that is dated on the transfer out transaction date or up to 7 days after for the same amount. If the target bank account is in a foreign currency then the amount must match within the notional exchange rate HIGH and LOW.
Transfer In A transfer out transaction on the target ~ bank account ~ that is dated on the transfer in transaction date or up to 7 days before for the same amount. If the target bank account is in a foreign currency then the amount must match within the notional exchange rate HIGH and LOW.
When searching foreign currency documents, the reconciling facility 32 relies on a notional exchange rate table that specifies a factor that converts the foreign currency to Canadian funds (in this example). These rates are s generally the monthly average exchange rates published by the Bank of Canada. In addition there is a HIGH and LOW exchange rate value that creates a band around the published rate. This accounts for the fact the actual settling rate for any given foreign exchange transaction is not bound by the Bank of Canada after the fact published rates. If the target values fall within io the band it is deemed to be a match.
In order to locate all supporting documents, the reconciling facility 32 also verifies:
1 ) That when the transactions recorded for a given bank statement are s applied to the opening balance the closing balance is obtained.
Failure of this to occur indicates a data keying error or the omission of transaction (s).
2) That the opening balance on one bank statement matches the closing balance on the previous statement.
io 3) That the bank statements for all the bank accounts cover the entire reporting period - that is there are no gaps.
Deposit Slips After examining the bank transactions, in accordance with this particular example provided for illustration purposes, the reconciling facility 28, then examines the deposit slips, if any. Each deposit slip has one or more entries as specified in the following table:
Deposit Entry Data Collected Type Invoice Payment Amount, Invoice Number Credit Account Amount, Account Number, and optional GST and PST amounts For the Invoice Payment entries, the reconciling facility 32 verifies that an invoice with the given invoice number exists, and that the amount recorded on the deposit slip matches the total amount of the invoice.
For Credit Account entries, the reconciling facility 32 verifies that the Account Number is valid and that the GST and PST (in this particular example - provincial and federal taxes applicable in Canada) do not add up to more than the amount. Certain account numbers such as the ones set up for the various bank accounts, foreign exchange gain and loss, and transfer clearing are not permitted.
s Expense Recepts The reconciling facility 32 scans all expense receipts for the target date range that have not been linked to the bank statement to determine how they were paid. All receipts that are not paid by a director generate an error with a 1 o hyperlink to the expense receipt. If, for example, an expense receipt is recorded as having been paid by a corporate debit card and there is not a corresponding entry in the bank transactions, then an error is issued.
Cancelled Cheques The reconciling facility 32 reports all cancelled cheques that are not linked to the bank statements.
I nwnirc~c The reconciling facility 32 reports all Invoices that are not paid (i.e. not linked to a bank transaction or deposit slip) In accordance with the representative business rules identified above, 2s the reconciling facility 32 generates in relation to a particular Client 18 an "ISSUES LIST" that includes information regarding missing documents, uncleared cheques, receivables, errors and the like. Depending on the rules determined by the business rule repository, remediation of some issues may fall on the Data Entry Personnel 18. For example, data entry errors identified ~o in accordance with the above are generally reported immediately to the Data Entry Personnel 14 for rectification. Once the data entry errors have been addressed, the remaining "ISSUES LIST" is generally reported to Accounting Personnel 16 for problem resolution as a reconciling interface. For example, if there are missing documents, the accountant will contact the Client 18 and ask that they submit the missing documents. A list of the missing documents can be sent by email by the accountant in conjunction with communication s facility 24. Also, the Accounting Personnel 16 generally can exercise on "OVERRIDE" function provided that an explanation is given, which is as a "READ ONLY" file in database 26.
The "ISSUES LIST" is generally a series of entries containing the ~o following information. First, a reference to a particular business rule (e.g. 408 - Missing Cancelled Cheque) from the business rule repository 40 detailing the reason for identification of the issues. Data Entry Personnel 14 or Accounting Personnel 16 can access, for example, from an on-line manual the detailed explanation of the business rule, and proper procedure for is remediation. Second, the particular "ISSUE" entry references the other data pertinent to the entry. For example, in relation to a Cancelled Cheque -"MISSING CANCELLED CHEQUE FOR $218 DATE 02-FEB-1999 DRAWN
FROM ACCOUNT CIBC (414100 9911411 (CANADIAN)". The "ISSUES
LIST" also generally contains at the end a "PROCESSING SUMMARY" which zo identifies the categories of the various issues, for example, "NUMBER OF
BANK STATEMENTS: 13; NUMBER OF BANK TRANSACTIONS: 189;
NUMBER OF INVOICES: 32; NUMBER OF EXPENSES: 202; NUMBER OF
DEPOSIT SLIPS: 27.
2s It should be understood that the reconciling facility 32 is generally engaged after each round of data entry. Further rounds of data entry will generally occur until all the documents are processed for the given reporting period (i.e. usually the tax year) for a particular Client 18.
~o In a sixth step of the present invention, the linking facility 30 of the present invention is engaged. The linking of various data objects within the database 26 in a known capability. In a particular implementation of the -2~ -present invention, the linking facility 30 processes data in conjunction with the reconciling facility 32 such that once a batch of data has been reconciled as described above, the associated documents are linked by the linking facility 30. The linking occurs by analyzing the captured data from the source s documents and creating links between them. Each and every source document has a unique serial number. Documents are linked by adding the serial number of one document to the data recorded about another document in a manner that is known. For example, if a data object corresponding to a cheque is entered into the system, and a cheque for the same amount, on the io same date appears in a bank statement, the cheque and that item in the bank statement will be linked. This process is generally applied across the various data objects included in the database 26.
The result of the above, is the generation of a linked log of all of the is documents of a particular Client 18 whereby a User can drive down to documentation supporting any particular entry in the log. In addition, in association with the web publication tool 34 a number of reports can be accessed organizing data retrieved from the database 26 regarding a particular Client 18.
For example, "INVOICES BY CUSTOMER NAME FOR TAX YEAR X "
can be accessed. Selection can be made as to whether invoices are to be viewed by "INVOICE NUMBER", by "DATE DESCENDING", by "DATE
ASCENDING", etc.
Similar reports and related selections are available for cancelled cheques, bank deposits, bank statements, and so on. Obviously, the selections will vary according to the type of report. For example, in relation to a bank deposit report, data can be viewed "BY ACCOUNT AND DATE".
As a seventh step of the present invention, it is generally desirable to export the data created in accordance with the present invention. The present invention also includes a data export facility 42 that permits the reconciled and linked data to be exported to an accounting software package.
In one aspect of the present invention, the date export facility 42 converts the reconciled and linked data into a format that is understood by an accounting s packages such as for example the known CASEWARET"" accounting software package.
One of the aspects of the present invention, is that the data exported supports the processes of accounting software packages such as ~o CASEWARET"" whereby the accounting data is converted from single accounting entry method data to double accounting entry method data.
Another aspect of the present invention is that the business rule repository 40 includes rules for ensuring that the reconciled and linked data i s provided in accordance with the present invention is consistent with the data conversion rules of accounting software packages such as CASEWARET"".
For example, the CASEWARET"" accounting package uses a set of rules that can be expressed as 'T-Accounts' to convert data from single entry 2o to double entry. In the examples below the following nomenclature is used:
$Total Amount - total amount captured by data entry $GST - GST amount captured by data entry $Settle Amount - total amount of a foreign currency actual settling 2s value $Settle_GST - GST portion of total amount of foreign currency actual settling value [... ] - A named general ledger account ~o Transaction DescriptionT-Accounts Non-capital office Credit: [Bank] $TotahAmount expense paid by cheque using Debit: [Office] $Total Amount short GST method and Canadian currency Non-capital office Credit: [Bank] $Total Amount expense paid by cheque using Credit: [FEX] ($Syn-rate - 1.0) * $Total short Amount GST method and foreignDebit: [Office]
currency Capital office expenseCredit: [Bank] $Total, Amount paid by cheque using short Debit: [Office] $Total Amount - $GST
GST
method and Canadian Debit: [GST Payable] $GST
currency Capital office expenseCredit: [Bank] $Settle Amount paid by cheque using short Credit [FEX] $Settle_Amount - $Total GST Amount method and foreign Debit: [Office] $Settle_Amount - $Settle_GST
currency Debit: [GST Payable] $Settle_GST
Non-capital office Credit: [Bank] $Total Amount expense paid by cheque using Debit [Office] $Total Amount - $GST
long GST method and CanadianCredit: [GST Paybale] $GST
Currency Non-deductible expenseCredit: (Bank] $Total Amount paid by a company directorDebit: [Director Advances] $Total Amount card in Canadian Currency Non-capital office Debit: [Office]: $Total Amount expense paid by a director Credit: [Director Advances] $Total Amount using GST short method and Canadian currency The above T-Account rules or similar rules are readily entered into the Business Rule Repository 40 whereby the reconciled and linked data can be entered into a third party accounting software package so as to generate financial statements based on such data. These financial statement permit to s drive down to reviewing supporting documents. This in turn promotes transparency of financial statements, in that spot audits of financial statement entries can be readily verified by driving down to earmarked supporting documentation.
~o It should be understood that one of the aspects of the present invention is that the data entry function can be delegated to the Data Entry Personnel 14 whereby data is entered over the Internet in a disparate geographic location, for example, one where labour costs are lower. The quality control function, on the other hand, is delegated to Accounting Personnel 16 in the is jurisdiction of the Clients 18 such that they can verify that reconciled books created in accordance with the present invention meet the accounting rules of that particular jurisdiction.
Another aspect of the present invention is that the database 24 and the 2o known database management facility 26 are provided in a manner that, for example, Clients 18 can only access their own data. In cooperation with Administration Facility, for example, in an implementation of the present invention with an accounting firm, accountants associated with a particular office can only view Client 18 data wherein the clients are clients of that office.
Other variations and modifications of the invention are possible. For example, as stated above, the present invention can be readily modified to extract reconciled books from a variety of commonly used documents in a number of industries such as Real Estate Contracts, Waybills, Purchase ~o Orders, Shipping Documents, Inventory Reports, General Contracts and so on. For each new type of document data entry screens would be added to support the data capture and the reconciling facility 32 would be extended to apply the appropriate tests. It would also be obvious to modify the present invention to permit exporting to a number of other accounting packages such as Quickbooks, MYOB, Simply Accounting, and so on. Various other features can be associated with the web publication tool 34 that in turn enhance the features of the various web pages described herein. Additional features can be added to the system contemplated herein, without departing from the spirit of this invention. All such modifications or variations are believed to be within the sphere and scope of the invention as defined by the claims appended hereto.
~o
s Figure 2 illustrates the resources of the software product of the present invention, in accordance with one embodiment thereof.
In the drawings, preferred embodiments of the invention are illustrated by way of example. It is to be expressly understood that the description and io drawings are only for the purpose of illustration and as an aid to understanding, and are not intended as a definition of the limits of the invention.
Detailed Description of the Preferred Embodiment Referring to Fig. 1, there is illustrated a system component flow chart for the system of the present invention. By means of the Internet medium 10, Server 12 is made accessible to one or more Users.
2o In accordance with the method of the present invention, there are generally three categories of Users. The first category is "Data Entry Personnel" 14 generally comprising data entry clerks.
The second category is "Supervising Personnel" or "Accounting 2s Personnel" 16. As explained below, the function of the "Accounting Personnel" is to exercise quality control in regard to the data entry functions fulfilled by the Data Entry Personnel 14 to ensure that the reconciled books created in accordance with the present invention meet generally accepted accounting standards, as well as standards of accuracy. The Accounting 3o Personnel is contrasted from the Data Entry Personnel 14 and generally comprises an accountant, bookkeeper, or trained quality control resource.
The Accounting Personnel may include accountants associated with the operator of the present invention. Alternatively, the Accounting Personnel may include accountants associated with a licensee accounting firm of the present invention whereby the accountants supervise the creation of reconciled books in accordance with the present invention.
A third category is "Clients" 18. "Clients" may be accountants who are outsourcing the creation of reconciled books to the operator of the present solution and who are not involved in the supervisory role of the Accounting Personnel 16. "Clients" 18 may also include in addition to such accountants io the originators of the accounting data, such as for example a business having financial documents. The level of access to the present invention given to Clients will depend on whether they are accountants or clients of accountants.
It should be further understood that the description of the present i s invention draws principally on the example of the bookkeeping, and also functions in support of accounting. It should also be understood, however, that the present invention applies to other contexts as well where generation of reports depends on the reconciling of a plurality of supporting documents in accordance with a set of business rules, and whereby verification of the 2o reports requires ready access to the underlying supporting documents.
One aspect of the present invention is the provision of a web site 20 that facilitates the creation of reconciled books in accordance with the present invention, and further the access to such reconciled books, or other ?s documents that depend on such reconciled books, including underlying supporting financial or other documents in electronic form.
In the embodiments of the present invention illustrated herein, Server 12 comprises a computer 13, an Internet connection 20, communication ~o facility 24 and database 26. A computer product is loaded on the server 12 that includes a number of facilities including a database management facility 28, a linking facility 30, a reconciling facility 32, a web publication tool 34 and an administration facility 36.
The functionality of each of these elements of Server 12 is discussed s below. It should be understood, however, that the present invention encompasses providing the Internet environment described herein through the auspices of a variety of types of Internet connections, whether LAN
connections, fiber optic cable connections, wireless Internet connections, and so on. It should also be understood that the present invention encompasses to providing the Server 12 through any number of equivalents including any combination of hardware and software which enables the functions of this invention to be provided via the Internet, or any other inter-connected network of computers. Also, database 26 and database management facility 28 can be provided by a wide array of custom or off-the-shelf database and database is management products. In addition, said database management facility 28 can also incorporate a number of tools for identifying and manipulating relevant data, such as known knowledge management tools.
The present invention also contemplates interoperability of database 20 26 and database management facility 28 with other networks such as a corporate LAN, for example, to access from such LAN the data contained in database 26 or to make changes to the settings of database management facility 28 on a remote basis.
2s Administration facility 36 is a known tool that is controlled by the operator of Server 12 for controlling access to the resources of the Server 12, which are particularized below. The administration facility 36 is an important aspect of the present invention in that it ensures segregation of functions as between Data Entry Personnel 14, Accounting Personnel 16 and Clients 18.
3o This segregation of functions ensures the integrity of the reconciled books created in accordance with the present invention. The Administration facility 36, for example, is the technical means for ensuring that Data Entry _7_ Personnel 14 can only access the specific data entry interfaces referenced below; that only Accounting Personnel 16 can access the reconciling interfaces referenced below; and Client 18 can only access particular areas of the web site 20 that show the results of the present invention, i.e. their s reconciled books, without revealing the underlying linking and reconciliation process described herein.
The Administration facility 36 and web publication tool 34 cooperate to provide an "ADMINISTRATOR'S HOME PAGE" which includes the various io functions associated with the operation of the present invention. This home page provides a number of functions.
A first representative function is the ability to monitor the "SYSTEM
STATUS". This function allows the Administrator to verify the users that are is currently logged in, and also to access a "TIME STAMPED LOG". This function has a number of benefits. It allows management of resources, but also tracking of activities of Data Entry Personnel 14.
A second representative function is the "USER ADMINISTRATION"
2o function which permits such sub-functions as "FIND CLIENT USER", "FIND
STAFF USER", "CHANGE PASSWORD", "CREATE NEW CLIENT USER", "CREATE NEW STAFF USER", and "ADD NEW USER GROUP".
A third representative function is the "WIP" function that permits the 2s monitoring of workflow on the system of the present invention. This function permits the creation and display of a number of reports related to the workflow in progress on the system, for example, "FILES LOGGED IN BY MONTH", "CLIENT STATUS BALANCE SHEET", "YEAR ENDS NOT LOGGED IN BY
YEAR END MONTH", "ACCOUNT MANAGER PERFORMANCE" and so on.
~o In a fourth representative function, there is an "IMAGE HANDLING
FUNCTION" whereby the process of capturing of electronic images described _$_ below is managed by such sub-functions as "INSTALL IMAGES", "SHOW ALL
REWORKS", "SHOW ALL REWORKS FOR USER" and so on, In a fifth representative function, a "SYSTEM MAINTENANCE" function s includes a number of sub-functions that allow administration of the various components of the present system described herein, in a manner that is known.
In one embodiment of the Administration Facility 36, the various Users to are assigned username/password combinations corresponding to the access levels assigned by the administrator of the Server 12. Accordingly, the various Users can log on to the Server 12 and access the particular resources of the Internet Server 12 to which they are given access. using a known Internet browser.
IS
The web publication tool 34 permits, in a manner that is known, the creation, publication and population with data of the variety of web pages 36 discussed herein, including data entry interfaces, reconciling interfaces, reports, and web-based reconciled books and other accounting documents.
Web publication tool 34 also includes a series of known tools for selecting and/or altering the look and feel of the web pages in a manner that is known including for example having regard to fonts, colors, web formats, web layouts, navigation etc. One particular aspect of the web publication tool 2s 34 is that it permits the creation of custom areas of the Server 12. This permits, for example, the branding of web pages with the logos, symbols and text of particular Clients 18 such as an accounting firm licensee. To the clients of such an accounting firm, the web pages would have the "look and feel" of the accounting firm or other organization with whom they are familiar.
~o It should be understood that web publication tool 34 provides means for easily updating the web pages and related web templates 38 on a regular _9_ basis. This may be to account for new forms of reconciled books or data entry interfaces for new types of financial documents and the like.
It should be understood that the description of the steps of the present s invention in consecutive order is not meant to convey that the order of such steps is an essential element of the present invention.
In a first step of the present invention, an Administrator of the present invention establishes the various business rules associated with creating a io reconciled and linked document based on underlying supporting documents in accordance with the present invention. There are two aspects to these business rules. The first aspect is the business rules for reconciling a plurality of supporting documents to create a higher level document, such as a reconciled set of books based on underlying financial or other documents.
is The second aspect of the business rules are the rules for linking the underlying supporting documents such that when the higher level document is accessed the supporting documents can also be accessed through a known Internet browser, for example, during verification of the higher level document.
2o The above described business rules are established in accordance with known principles and stored in a known business rules repository 40 which is part of database 26. The business rules included in the business rule repository 40 are essentially parsing rules. The business rules repository in association with the database management facility 28 and database 26 ?s provide the aspects of the present invention described as the linking facility 30 and reconciling facility 32.
In a second step of the present invention, the database 26 is populated with data of Clients 18. In regard to the bookkeeping implementation of the ~o present invention, this data includes data regarding such documents as bank statements, bank deposits, bank withdrawals, expenses, and cancelled cheques. This data constitutes electronic data regarding such documents obtained, for example, from a known electronic banking facility.
In accordance with one particular embodiment of the present invention, s however, the data includes scanned images of paper based documents such as signed cancelled cheques, copies of bank statements received from banks, signed bank deposits, invoices from suppliers and so on. The scanned images are obtained through a variety of means. For example, clients may scan such paper based documents using known technology in to the memory lo of a computer, and then transmit the resultant data electronically to the Server 12 via the communication facility 24 in a manner that is known.
Alternatively, the underlying paper based documents are delivered to the operator of the Internet server 12 or to a licensee of the solution described ~s herein, and the paper based documents are then scanned to produce a series of electronic files.
As a still further alternative, the present invention includes a known fax database utility, whereby a particular Client 18 wishing to submit a particular 2o supporting document logs into the Server 12 and the web publication tool 34 cooperates with the database management facility 28 and database 26 to display a fax cover sheet that includes a bar code. The fax cover sheet is printed out by the Client 18 and the cover sheet is faxed along with the supporting document to a particular fax number associated with a fax machine 2s connected to Server 12. The Server 12 is provided with a computer application whereby the bar code is read from the electronic transmission which identifies the Client 18 to the Server. The electronic data comprising the supporting document is tagged and stored to the database 26. The supporting document is now available via the Internet.
The database management facility 28 of the present invention includes a known data import interface whereby the data described above is received and stored in a compatible format to the database 26, in a manner that is known. Each packet of data imported is tagged in a manner that is known within database 26.
Database 26 is a known relational database that supports queries made via the database management facility 28 across a particular segregation of tagged data, in a manner that is known. In a particular embodiment of the present invention, one aspect of the database management facility 28 of the present invention is a known database engine ~o to store document data such as IE ORACLE TM.
In another particular aspect of the database management facility 28, and a particular aspect of the web publication facility 34, a known electronic document storage and retrieval system is used to populate the database 26 is with further tagged data provided through a series of web interfaces as described below, and also to retrieve data from the database 26 in a series of web interfaces including web reports. In a particular implementation of the present invention this specific aspect of the present invention is provided using an IE NetscapeT"" web server.
ao In a third step of the present invention, paper based documents of a particular client are entered into the database 26, or electronic data is verified or enhanced in accordance with known data entry methods.
2s Data Entry Personnel 14 logs into the web site 20 and begins work.
One aspect of the present invention is a web page tailored to a particular member of the Data Entry Personnel 14 that helps the member manage their workflow. For example, when the particular member logs in to the web site 20, the web page displayed allows the particular member to begin with data ~o entry where they left off; review log of work completed in the past; and so on.
It is also contemplated by the present invention that the administration facility 36 will incorporate tools for managing labor standards whereby Data Entry J7 _ Personnel 14 performance is measured against engineered labor standards, and the web pages for particular members of the Data Entry Personnel 14 is used to report to the members on their performance compared to these labor standards.
s The web pages accessed by the Data Entry Personnel 14 permit a number of functions. First, they permit a search for a particular client.
Second, they provide a series of data entry screens, as mentioned above.
Third, they permit the Data Entry Personnel to engage both the linking facility io 30 and the reconciling facility 32 as stated below.
The web pages provide the Data Entry Personnel 14 with a known search engine for searching for data associated with a particular Client 18 based on key words, alphabetical drop down lists of Clients 18 and so on.
is Once a particular Client 18 has been located, a link is displayed which provides access via a browser to any data that exists on the database 26 for that particular client. In relation to a Client 18 who has been entered on the database 26 but the process of creating reconciled books in accordance with the present invention has not yet begun, the web publication tool 34 will 2o display in a web page a list of links corresponding with data objects (electronic data or images of paper based documents).
In accordance with a particular embodiment of the present invention, if the Data Entry Personnel 14 clicks on a link associated with a particular data 2s object, a data entry interface is displayed by the web publication tool 34.
In one aspect of the present invention, the Data Entry Personnel views the data object and determines based on a drop down menu the type of document that is represented by the data (bank statement, deposit, etc.). In another aspect of the present invention, the database management facility 28 and business ~o rule repository 4d cooperate to analyze the data objects and based on business rules determine the type of document that is likely represented by the data object.
- ~ .i -Generally speaking, the data entry process begins with a document that tends to summarize the various transactions that will have to be reconciled. For example, in relation to the creation of reconciled accounting s books for a business, the data entry process begins with the various bank statements of that business. In accordance with one aspect of the present invention therefore, if the bank statements are not available electronically, the Data Entry Personnel 14 will click on each bank statement in the list of data objects. This will bring up a web page that consists of a particular data entry io interface for bank statements. It is an aspect of the present invention, that once the type of document is identified for a data object, a web template 38 corresponding to that type of document is accessed and displayed for managing the workflow of the Data Entry Personnel 14.
~s The business rule repository 40 contains the various rules determining the workflow process for keying the data for a particular financial document, in association with the web templates 38. Generally speaking each web template 38 consists of a display area that displays the actual data object.
This display area generally permits the Data Entry Personnel 14 to scroll up or 2o down on the data object, vary the size of the data objects vis-a-vis the balance of the data entry interface, vary the size of the characters in the data object, and zoom in on parts of the data object that are particularly difficult to read. The web templates 38 also generally include a series of drop down menus that permit certain values to be selected, for example, the type of Zs transaction represented by a data object, or a particular transaction listed in a data object such as a bank statement. Lastly, the web templates 38 also include one or more data entry fields wherein information is entered manually by the Data Entry Personnel 14.
~o For example, in relation to a bank statement, the Data Entry Personnel 14 will generally pick the nature of the transaction, "BANK STATEMENT", from a scroll down menu. The Data Entry Personnel 14 will then proceed line by line and ensure that each line of the data in the bank statement is entered.
Scroll down menus are provided to pick the nature of the particular entry in the bank statement, for example, "CASH WITHDRAWAL", "CHEQUE", "DEBIT CARD WITHDRAWAL", "DEPOSIT", "SERVICE CHARGE", s "TRANSFER IN", "TRANSFER OUT", "UNKNOWN CREDIT" and "UNKNOWN DEBIT". In relation to the particular entries, the data entry interface requires the entry of specific information. For example, in relation to a cheque, the "DATE", "AMOUNT", and "CHEQUE NUMBER" is required.
~o The various underlying documents are also entered. For example, data entry interface specific to cancelled cheques shown in the bank statements, expenses corresponding to payments reflected in the bank statements are also accessed and the pertinent data is entered in a similar fashion.
~s The result of the above process is that the data contained in the data objects displayed in the list of documents of a particular Client 18 is fully entered in the database 26. In one aspect of the present invention, when the requisite data for a particular data object, in accordance with the business 2o rules contained in the business rules repository 40, has been entered, the particular data object will be "CHECKED" or indicated in some other way in the list of documents of a particular Client 18. This also assists in managing workflow.
2s In a fourth step of the present invention, the reconciling facility 32 is engaged to reconcile the various documents of a Client 18 in accordance with the rules provided to the business rule repository 40. The purpose of the reconciling facility 32 is the application to the data of a particular Client 18 of logic processes aimed at identifying data entry errors and gaps in the Client's ~o data as compared to data required to provide reconciled books in accordance with accounting standards in a particular jurisdiction.
-l5-The operation of the reconciling facility 32 is best understood in relation to an example in operation. The example provided illustrates, among other things, how the accounting rules for a particular jurisdiction (in this case Canada) are reflected in the business rules that provide the reconciling s facility's 32 logic.
Bank Statements As stated earlier, the central document is generally a document such io as a bank statement. For every line on the bank statement there is a record in the database that records:
1 ) Transaction Date 2) Transaction Amount ~s 3) Transaction Type (cheque, deposit, debit card withdrawal, service charge, etc) 4) Cheque Number (if applicable) 5) Description (if applicable) 2o For a given date range (i.e. a business cycle such as a tax year) the reconciling facility 32 examines each bank transaction recorded in the database 26 and locates other documents stored to the database 26 for the same Client 18 as per the following table:
Transaction Type Source Documents Deposit Deposit slip or an Invoice that has been recorded as deposited Cheque Cancelled cheque and an expense receipt Service Charge None Debit Card WithdrawalExpense receipt Cash Withdrawal None Transfer Out Corresponding transfer in from another bank account Transfer In Corresponding transfer out to this bank account Documents are located using the following rules:
Document Rules for Locating Type Deposit Slip A deposit for the target amount (in the same currency as the bank account) into the target bank account dated on the bank statement date or up to 3 days before.
Failing this mixed or foreign currency deposit slips are examined to find one that has an amount that is in between the notional exchange rate HIGH and LOW
values into the target bank account on the bank statement date or up to 3 days before.
Invoice An invoice for the target amount (in the same currency as the bank account) dated on the bank statement date or up to 3 days before. Failing this, foreign currency invoices are examined to find one that is dated on the bank statement date or up to 3 days before for an amount that is in between the notional exchange rate HIGH and LOW.
Cheque The cheque number, bank account, and amount must match. Failing this, foreign currency cheques are examined to find one that is drawn on the target bank account for an amount that is in between the notional exchange rate HIGH and LOW.
Expense An expense receipt for the target amount and cheque Receipt paid number. Failing this, foreign currency expense by receipts cheque are examined to find one that has the same cheque '' _17_ number and with an amount that is in between the notional exchange rate HIGH and LOW.
Debit Card An expense receipt for the target amount that is paid Withdrawal using a debit card that belongs to the target bank account. Failing this, foreign currency expense receipts are examined to find one that was paid using a debit card that is associated with the target bank account and with an amount that is in between the notional exchange rate HIGH and LOW.
Transfer Out A transfer in transaction on the target bank account that is dated on the transfer out transaction date or up to 7 days after for the same amount. If the target bank account is in a foreign currency then the amount must match within the notional exchange rate HIGH and LOW.
Transfer In A transfer out transaction on the target ~ bank account ~ that is dated on the transfer in transaction date or up to 7 days before for the same amount. If the target bank account is in a foreign currency then the amount must match within the notional exchange rate HIGH and LOW.
When searching foreign currency documents, the reconciling facility 32 relies on a notional exchange rate table that specifies a factor that converts the foreign currency to Canadian funds (in this example). These rates are s generally the monthly average exchange rates published by the Bank of Canada. In addition there is a HIGH and LOW exchange rate value that creates a band around the published rate. This accounts for the fact the actual settling rate for any given foreign exchange transaction is not bound by the Bank of Canada after the fact published rates. If the target values fall within io the band it is deemed to be a match.
In order to locate all supporting documents, the reconciling facility 32 also verifies:
1 ) That when the transactions recorded for a given bank statement are s applied to the opening balance the closing balance is obtained.
Failure of this to occur indicates a data keying error or the omission of transaction (s).
2) That the opening balance on one bank statement matches the closing balance on the previous statement.
io 3) That the bank statements for all the bank accounts cover the entire reporting period - that is there are no gaps.
Deposit Slips After examining the bank transactions, in accordance with this particular example provided for illustration purposes, the reconciling facility 28, then examines the deposit slips, if any. Each deposit slip has one or more entries as specified in the following table:
Deposit Entry Data Collected Type Invoice Payment Amount, Invoice Number Credit Account Amount, Account Number, and optional GST and PST amounts For the Invoice Payment entries, the reconciling facility 32 verifies that an invoice with the given invoice number exists, and that the amount recorded on the deposit slip matches the total amount of the invoice.
For Credit Account entries, the reconciling facility 32 verifies that the Account Number is valid and that the GST and PST (in this particular example - provincial and federal taxes applicable in Canada) do not add up to more than the amount. Certain account numbers such as the ones set up for the various bank accounts, foreign exchange gain and loss, and transfer clearing are not permitted.
s Expense Recepts The reconciling facility 32 scans all expense receipts for the target date range that have not been linked to the bank statement to determine how they were paid. All receipts that are not paid by a director generate an error with a 1 o hyperlink to the expense receipt. If, for example, an expense receipt is recorded as having been paid by a corporate debit card and there is not a corresponding entry in the bank transactions, then an error is issued.
Cancelled Cheques The reconciling facility 32 reports all cancelled cheques that are not linked to the bank statements.
I nwnirc~c The reconciling facility 32 reports all Invoices that are not paid (i.e. not linked to a bank transaction or deposit slip) In accordance with the representative business rules identified above, 2s the reconciling facility 32 generates in relation to a particular Client 18 an "ISSUES LIST" that includes information regarding missing documents, uncleared cheques, receivables, errors and the like. Depending on the rules determined by the business rule repository, remediation of some issues may fall on the Data Entry Personnel 18. For example, data entry errors identified ~o in accordance with the above are generally reported immediately to the Data Entry Personnel 14 for rectification. Once the data entry errors have been addressed, the remaining "ISSUES LIST" is generally reported to Accounting Personnel 16 for problem resolution as a reconciling interface. For example, if there are missing documents, the accountant will contact the Client 18 and ask that they submit the missing documents. A list of the missing documents can be sent by email by the accountant in conjunction with communication s facility 24. Also, the Accounting Personnel 16 generally can exercise on "OVERRIDE" function provided that an explanation is given, which is as a "READ ONLY" file in database 26.
The "ISSUES LIST" is generally a series of entries containing the ~o following information. First, a reference to a particular business rule (e.g. 408 - Missing Cancelled Cheque) from the business rule repository 40 detailing the reason for identification of the issues. Data Entry Personnel 14 or Accounting Personnel 16 can access, for example, from an on-line manual the detailed explanation of the business rule, and proper procedure for is remediation. Second, the particular "ISSUE" entry references the other data pertinent to the entry. For example, in relation to a Cancelled Cheque -"MISSING CANCELLED CHEQUE FOR $218 DATE 02-FEB-1999 DRAWN
FROM ACCOUNT CIBC (414100 9911411 (CANADIAN)". The "ISSUES
LIST" also generally contains at the end a "PROCESSING SUMMARY" which zo identifies the categories of the various issues, for example, "NUMBER OF
BANK STATEMENTS: 13; NUMBER OF BANK TRANSACTIONS: 189;
NUMBER OF INVOICES: 32; NUMBER OF EXPENSES: 202; NUMBER OF
DEPOSIT SLIPS: 27.
2s It should be understood that the reconciling facility 32 is generally engaged after each round of data entry. Further rounds of data entry will generally occur until all the documents are processed for the given reporting period (i.e. usually the tax year) for a particular Client 18.
~o In a sixth step of the present invention, the linking facility 30 of the present invention is engaged. The linking of various data objects within the database 26 in a known capability. In a particular implementation of the -2~ -present invention, the linking facility 30 processes data in conjunction with the reconciling facility 32 such that once a batch of data has been reconciled as described above, the associated documents are linked by the linking facility 30. The linking occurs by analyzing the captured data from the source s documents and creating links between them. Each and every source document has a unique serial number. Documents are linked by adding the serial number of one document to the data recorded about another document in a manner that is known. For example, if a data object corresponding to a cheque is entered into the system, and a cheque for the same amount, on the io same date appears in a bank statement, the cheque and that item in the bank statement will be linked. This process is generally applied across the various data objects included in the database 26.
The result of the above, is the generation of a linked log of all of the is documents of a particular Client 18 whereby a User can drive down to documentation supporting any particular entry in the log. In addition, in association with the web publication tool 34 a number of reports can be accessed organizing data retrieved from the database 26 regarding a particular Client 18.
For example, "INVOICES BY CUSTOMER NAME FOR TAX YEAR X "
can be accessed. Selection can be made as to whether invoices are to be viewed by "INVOICE NUMBER", by "DATE DESCENDING", by "DATE
ASCENDING", etc.
Similar reports and related selections are available for cancelled cheques, bank deposits, bank statements, and so on. Obviously, the selections will vary according to the type of report. For example, in relation to a bank deposit report, data can be viewed "BY ACCOUNT AND DATE".
As a seventh step of the present invention, it is generally desirable to export the data created in accordance with the present invention. The present invention also includes a data export facility 42 that permits the reconciled and linked data to be exported to an accounting software package.
In one aspect of the present invention, the date export facility 42 converts the reconciled and linked data into a format that is understood by an accounting s packages such as for example the known CASEWARET"" accounting software package.
One of the aspects of the present invention, is that the data exported supports the processes of accounting software packages such as ~o CASEWARET"" whereby the accounting data is converted from single accounting entry method data to double accounting entry method data.
Another aspect of the present invention is that the business rule repository 40 includes rules for ensuring that the reconciled and linked data i s provided in accordance with the present invention is consistent with the data conversion rules of accounting software packages such as CASEWARET"".
For example, the CASEWARET"" accounting package uses a set of rules that can be expressed as 'T-Accounts' to convert data from single entry 2o to double entry. In the examples below the following nomenclature is used:
$Total Amount - total amount captured by data entry $GST - GST amount captured by data entry $Settle Amount - total amount of a foreign currency actual settling 2s value $Settle_GST - GST portion of total amount of foreign currency actual settling value [... ] - A named general ledger account ~o Transaction DescriptionT-Accounts Non-capital office Credit: [Bank] $TotahAmount expense paid by cheque using Debit: [Office] $Total Amount short GST method and Canadian currency Non-capital office Credit: [Bank] $Total Amount expense paid by cheque using Credit: [FEX] ($Syn-rate - 1.0) * $Total short Amount GST method and foreignDebit: [Office]
currency Capital office expenseCredit: [Bank] $Total, Amount paid by cheque using short Debit: [Office] $Total Amount - $GST
GST
method and Canadian Debit: [GST Payable] $GST
currency Capital office expenseCredit: [Bank] $Settle Amount paid by cheque using short Credit [FEX] $Settle_Amount - $Total GST Amount method and foreign Debit: [Office] $Settle_Amount - $Settle_GST
currency Debit: [GST Payable] $Settle_GST
Non-capital office Credit: [Bank] $Total Amount expense paid by cheque using Debit [Office] $Total Amount - $GST
long GST method and CanadianCredit: [GST Paybale] $GST
Currency Non-deductible expenseCredit: (Bank] $Total Amount paid by a company directorDebit: [Director Advances] $Total Amount card in Canadian Currency Non-capital office Debit: [Office]: $Total Amount expense paid by a director Credit: [Director Advances] $Total Amount using GST short method and Canadian currency The above T-Account rules or similar rules are readily entered into the Business Rule Repository 40 whereby the reconciled and linked data can be entered into a third party accounting software package so as to generate financial statements based on such data. These financial statement permit to s drive down to reviewing supporting documents. This in turn promotes transparency of financial statements, in that spot audits of financial statement entries can be readily verified by driving down to earmarked supporting documentation.
~o It should be understood that one of the aspects of the present invention is that the data entry function can be delegated to the Data Entry Personnel 14 whereby data is entered over the Internet in a disparate geographic location, for example, one where labour costs are lower. The quality control function, on the other hand, is delegated to Accounting Personnel 16 in the is jurisdiction of the Clients 18 such that they can verify that reconciled books created in accordance with the present invention meet the accounting rules of that particular jurisdiction.
Another aspect of the present invention is that the database 24 and the 2o known database management facility 26 are provided in a manner that, for example, Clients 18 can only access their own data. In cooperation with Administration Facility, for example, in an implementation of the present invention with an accounting firm, accountants associated with a particular office can only view Client 18 data wherein the clients are clients of that office.
Other variations and modifications of the invention are possible. For example, as stated above, the present invention can be readily modified to extract reconciled books from a variety of commonly used documents in a number of industries such as Real Estate Contracts, Waybills, Purchase ~o Orders, Shipping Documents, Inventory Reports, General Contracts and so on. For each new type of document data entry screens would be added to support the data capture and the reconciling facility 32 would be extended to apply the appropriate tests. It would also be obvious to modify the present invention to permit exporting to a number of other accounting packages such as Quickbooks, MYOB, Simply Accounting, and so on. Various other features can be associated with the web publication tool 34 that in turn enhance the features of the various web pages described herein. Additional features can be added to the system contemplated herein, without departing from the spirit of this invention. All such modifications or variations are believed to be within the sphere and scope of the invention as defined by the claims appended hereto.
~o
Claims (20)
1. A method of providing web-enabled accounting comprising the steps of:
(a) providing a plurality of financial documents for loading to a database functionally linked to a web server;
(b) providing a reconciling facility that reconciles financial documents in accordance with a plurality of predetermined business rules; and (c) applying the reconciling facility to the plurality of financial documents to produce a reconciled set of books.
(a) providing a plurality of financial documents for loading to a database functionally linked to a web server;
(b) providing a reconciling facility that reconciles financial documents in accordance with a plurality of predetermined business rules; and (c) applying the reconciling facility to the plurality of financial documents to produce a reconciled set of books.
2. The method claimed in claim 1, comprising the further steps of:
(a) providing a linking facility that links the plurality of financial documents;
and (b) applying the linking facility to the financial documents such that access to financial documents that either support an entry in the reconciled set of books, or another financial document, is enabled from the web server by means of a remote browser by clicking a corresponding link in the browser.
(a) providing a linking facility that links the plurality of financial documents;
and (b) applying the linking facility to the financial documents such that access to financial documents that either support an entry in the reconciled set of books, or another financial document, is enabled from the web server by means of a remote browser by clicking a corresponding link in the browser.
3. The method of claim 2, comprising the further steps of:
(a) indexing the data comprising the reconciled set of books for supporting export to an accounting computer program;
(b) exporting the data comprising the reconciled set of books to an accounting computer program; and (c) producing double entry account statements using the accounting computer program.
(a) indexing the data comprising the reconciled set of books for supporting export to an accounting computer program;
(b) exporting the data comprising the reconciled set of books to an accounting computer program; and (c) producing double entry account statements using the accounting computer program.
4. The method of claim 1, comprising the further steps of:
(a) identifying gaps between the financial documents and the data required to produce a reconciled set of books using the reconciling facility; and (b) producing an error list identifying the information required to fill such gaps.
(a) identifying gaps between the financial documents and the data required to produce a reconciled set of books using the reconciling facility; and (b) producing an error list identifying the information required to fill such gaps.
5. The method of claim 4, comprising the further step of designating the error list for rectification in accordance with a rectification protocol.
6. The method of claim 5, whereby the rectification of the error list involves designated personnel.
7. The method of claim 1, comprising the further step of electronically entering data to the web server that is required to produce a reconciled set of books and is otherwise not available electronically, using one or more data entry interfaces.
8. The method of claim 7, comprising the further step of ensuring the integrity and accuracy of financial documents provided to the web server in accordance with one or more data input interfaces, wherein the data input interfaces include quality control routines.
9. The method of claim 3, comprising the further step of providing access to a user to his/her reconciled set of books and underlying financial documents electronically by accessing the web server using a browser upon providing predetermined identification data.
10. A method of obtaining web-enabled accounting comprising the steps of:
(a) subscribing to a web-enabled accounting service;
(b) providing financial documents to a remote web server for processing the financial documents to produce a reconciled set of books in electronic form;
(c) responding to an error list where data is required to complete the web-enabled accounting process;
(d) accessing the reconciled set of books, and supporting financial documents, by accessing a web page provided by the web server via a browser by clicking one or more corresponding links.
(a) subscribing to a web-enabled accounting service;
(b) providing financial documents to a remote web server for processing the financial documents to produce a reconciled set of books in electronic form;
(c) responding to an error list where data is required to complete the web-enabled accounting process;
(d) accessing the reconciled set of books, and supporting financial documents, by accessing a web page provided by the web server via a browser by clicking one or more corresponding links.
11. A system for providing web-enabled accounting comprising:
(a) a web server connected to the Internet;
(b) a database functionally linked to the web server; and (c) a server application loaded on the web server, whereby the web server, database and server application are functionally linked to provide:
i) a data input facility for receiving a plurality of financial documents and storing said plurality of financial documents to the database in an electronic form; and ii) a reconciling facility that reconciles financial documents in accordance with a plurality of business rules for reconciling financial documents;
wherein the reconciling facility reconciles the plurality of financial documents to produce a reconciled set of books in an electronic form.
(a) a web server connected to the Internet;
(b) a database functionally linked to the web server; and (c) a server application loaded on the web server, whereby the web server, database and server application are functionally linked to provide:
i) a data input facility for receiving a plurality of financial documents and storing said plurality of financial documents to the database in an electronic form; and ii) a reconciling facility that reconciles financial documents in accordance with a plurality of business rules for reconciling financial documents;
wherein the reconciling facility reconciles the plurality of financial documents to produce a reconciled set of books in an electronic form.
12. The system claimed in claim 11, further comprising a linking facility that links the plurality of financial documents such that financial documents that either support an entry in the reconciled set of books, or another financial document, can be accessed from the database via web server and viewed in a remote browser by clicking a corresponding link.
13. The system claimed in claim 11, wherein the reconciling facility is further adapted to:
(a) identify gaps between the financial documents and the data required to produce a reconciled set of books using the reconciling facility; and (b) produce an error list identifying the information required to fill such gaps.
(a) identify gaps between the financial documents and the data required to produce a reconciled set of books using the reconciling facility; and (b) produce an error list identifying the information required to fill such gaps.
14.The system claimed in claim 13, wherein the reconciling facility escalates the error list in accordance with a rectification protocol.
15.The system claimed in claim 14, wherein the system further comprises a communication facility, and wherein the reconciling facility and the communication facility cooperate to communicate the error list to designated personnel for rectification.
16. The system claimed in claim 15, wherein the database is a relational database and the system further includes a database management facility, wherein the relational database supports queries from the database management facility across the database.
17.The system as claimed in claim 16, wherein the system further includes an administration facility for controlling access to the resources of the web server.
18.The system as claimed in claim 16, wherein the system further includes a data export facility which is adapted to:
(a) index the data comprising the reconciled set of books for supporting export to an accounting computer program; and (b) export the data comprising the reconciled set of books to an accounting computer program such that generation of a double entry account statement based on such data is enabled.
(a) index the data comprising the reconciled set of books for supporting export to an accounting computer program; and (b) export the data comprising the reconciled set of books to an accounting computer program such that generation of a double entry account statement based on such data is enabled.
19. The system as claimed in claim 18, wherein the data input facility further includes one or more data input interfaces for managing the workflow of data entry of the financial data to the database in accordance with a quality control process.
20.A server computer product for loading on a web server, said server computer product comprising:
(a) a data input facility for receiving a plurality of financial documents and storing said plurality of financial documents to the database in an electronic form; and (b) a reconciling facility that reconciles financial documents in accordance with a plurality of business rules for reconciling financial documents;
wherein the reconciling facility reconciles the plurality of financial documents to produce a reconciled set of books in an electronic form.
(a) a data input facility for receiving a plurality of financial documents and storing said plurality of financial documents to the database in an electronic form; and (b) a reconciling facility that reconciles financial documents in accordance with a plurality of business rules for reconciling financial documents;
wherein the reconciling facility reconciles the plurality of financial documents to produce a reconciled set of books in an electronic form.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002411617A CA2411617A1 (en) | 2002-11-08 | 2002-11-08 | System, computer product and method for web-enabled accounting |
| US10/345,246 US20040143522A1 (en) | 2002-11-08 | 2003-01-16 | System, computer product and method for web-enabled accounting |
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002411617A CA2411617A1 (en) | 2002-11-08 | 2002-11-08 | System, computer product and method for web-enabled accounting |
| US10/345,246 US20040143522A1 (en) | 2002-11-08 | 2003-01-16 | System, computer product and method for web-enabled accounting |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA2411617A1 true CA2411617A1 (en) | 2004-05-08 |
Family
ID=33311366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002411617A Abandoned CA2411617A1 (en) | 2002-11-08 | 2002-11-08 | System, computer product and method for web-enabled accounting |
Country Status (2)
| Country | Link |
|---|---|
| US (1) | US20040143522A1 (en) |
| CA (1) | CA2411617A1 (en) |
Families Citing this family (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9226975B1 (en) * | 2004-09-17 | 2016-01-05 | Deem, Inc. | Apparatus and method to provide community pricing |
| US9161994B1 (en) | 2005-03-29 | 2015-10-20 | Deem, Inc. | Cost model analysis and breakdown for cost buildup |
| US7496520B1 (en) * | 2005-07-22 | 2009-02-24 | Rearden Commerce, Inc. | System and method for optimization of group shipments to reduce shipping costs |
| EP1748366A1 (en) * | 2005-07-28 | 2007-01-31 | Sap Ag | A data processing system and method |
| US8095437B2 (en) * | 2005-09-02 | 2012-01-10 | Honda Motor Co., Ltd. | Detecting missing files in financial transactions by applying business rules |
| US8099340B2 (en) * | 2005-09-02 | 2012-01-17 | Honda Motor Co., Ltd. | Financial transaction controls using sending and receiving control data |
| US8540140B2 (en) * | 2005-09-02 | 2013-09-24 | Honda Motor Co., Ltd. | Automated handling of exceptions in financial transaction records |
| US8126776B2 (en) | 2006-06-30 | 2012-02-28 | Rearden Commerce, Inc. | Method and systems for personal restaurant assistant |
| US7966213B2 (en) * | 2006-10-16 | 2011-06-21 | Rearden Commerce, Inc. | System and method for automatic review of travel changes and improved suggestions and rules set |
| CN101350727B (en) * | 2007-07-18 | 2010-10-20 | 华为技术有限公司 | Method and apparatus for snapshot of account data, method for balancing account and real time billing system |
| US20090244600A1 (en) * | 2007-11-27 | 2009-10-01 | Todd Haycock | Billing and remittance payment system |
| US10304095B2 (en) * | 2008-02-04 | 2019-05-28 | Thomson Reuters Global Resources Unlimited Company | System and method for accounting gateway |
| US10453043B2 (en) * | 2008-06-25 | 2019-10-22 | Thomson Reuters Global Resources Unlimited Company | System and method for online bill payment |
| US9858624B2 (en) * | 2012-10-04 | 2018-01-02 | Qvinci Software, Llc | Methods and apparatus for providing data normalization, scalability and maintainability |
| CA2863303A1 (en) * | 2014-09-11 | 2016-03-11 | Patrice Carle | Automated accounting entry and processing system and method |
| US11625662B2 (en) | 2016-09-22 | 2023-04-11 | Qvinci Software, Llc | Methods and apparatus for the manipulating and providing of anonymized data collected from a plurality of sources |
| US11393045B2 (en) * | 2017-06-27 | 2022-07-19 | Fin Box Technologies, Inc. | Methods and systems for efficient delivery of accounting and corporate planning services |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6574661B1 (en) * | 1997-09-26 | 2003-06-03 | Mci Communications Corporation | Integrated proxy interface for web based telecommunication toll-free network management using a network manager for downloading a call routing tree to client |
| US6115690A (en) * | 1997-12-22 | 2000-09-05 | Wong; Charles | Integrated business-to-business Web commerce and business automation system |
| US6032132A (en) * | 1998-06-12 | 2000-02-29 | Csg Systems, Inc. | Telecommunications access cost management system |
| US6513019B2 (en) * | 1999-02-16 | 2003-01-28 | Financial Technologies International, Inc. | Financial consolidation and communication platform |
| US7437304B2 (en) * | 1999-11-22 | 2008-10-14 | International Business Machines Corporation | System and method for project preparing a procurement and accounts payable system |
| US7565311B2 (en) * | 1999-12-16 | 2009-07-21 | Sumitomo Mitsui Banking Corporation | Conversion engine and financial reporting system using the conversion engine |
| US6629081B1 (en) * | 1999-12-22 | 2003-09-30 | Accenture Llp | Account settlement and financing in an e-commerce environment |
| WO2003017150A2 (en) * | 2001-08-13 | 2003-02-27 | Accenture Global Services Gmbh | A computer system for managing accounting data |
| US20030212617A1 (en) * | 2002-05-13 | 2003-11-13 | Stone James S. | Accounts payable process |
-
2002
- 2002-11-08 CA CA002411617A patent/CA2411617A1/en not_active Abandoned
-
2003
- 2003-01-16 US US10/345,246 patent/US20040143522A1/en not_active Abandoned
Also Published As
| Publication number | Publication date |
|---|---|
| US20040143522A1 (en) | 2004-07-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2001256575B2 (en) | Method and apparatus for managing credit inquiries within account receivables | |
| AU2001252496B9 (en) | Method and apparatus for managing remittance processing within account receivables | |
| US8024778B2 (en) | System and method for defining attributes, decision rules, or both, for remote execution, claim set I | |
| US6873972B1 (en) | Systems and methods for credit line monitoring | |
| US8019843B2 (en) | System and method for defining attributes, decision rules, or both, for remote execution, claim set II | |
| US8688860B2 (en) | Personalized account migration system and method | |
| US6807533B1 (en) | Web-based method and system for managing account receivables | |
| US7295998B2 (en) | Methods and systems for managing tax audit information | |
| US8019828B2 (en) | System and method for defining attributes, decision rules, or both, for remote execution, claim set III | |
| AU2001258683B2 (en) | Method, apparatus and computer program for managing accounting system interfaces | |
| US7415471B1 (en) | Methods and systems for automated data collection and analysis for use in association with asset securitization | |
| CN108090823A (en) | accounting data management system based on SaaS | |
| CA2411617A1 (en) | System, computer product and method for web-enabled accounting | |
| US20060074799A1 (en) | Method and system for integrated payment processing | |
| US20020032651A1 (en) | Method and apparatus for making payments and delivering payment information | |
| US20020194125A1 (en) | Method and software article for selecting electronic payment of vendors in an automated payment environment | |
| AU2001256600B2 (en) | Method and apparatus for managing account receivables | |
| AU2001287013A1 (en) | Method and system for financial data aggregation, analysis and reporting | |
| CA2317209A1 (en) | Methods and apparatus for collateral risk monitoring | |
| EP1200917A1 (en) | Electronic statement, bill presentment and payment system and method | |
| AU4186700A (en) | Portfolio investment guideline compliance and financial fund administration system | |
| Coderre | Fraud analysis techniques using ACL | |
| JP2004288058A (en) | Management accounting information processing system, equipment thereof, method therefor, and computer program therefor | |
| KR20200086861A (en) | Accounting management program, medium with the program, accounting management processing device, and accounting management system | |
| Hughes | The Accounting Centric Data WarehouseTM |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| FZDE | Discontinued |