AU2015100679A4 - The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation - Google Patents

The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation Download PDF

Info

Publication number
AU2015100679A4
AU2015100679A4 AU2015100679A AU2015100679A AU2015100679A4 AU 2015100679 A4 AU2015100679 A4 AU 2015100679A4 AU 2015100679 A AU2015100679 A AU 2015100679A AU 2015100679 A AU2015100679 A AU 2015100679A AU 2015100679 A4 AU2015100679 A4 AU 2015100679A4
Authority
AU
Australia
Prior art keywords
dec
nov
debit
accounting
check
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.)
Ceased
Application number
AU2015100679A
Inventor
Mark Ryder
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to AU2015100679A priority Critical patent/AU2015100679A4/en
Application granted granted Critical
Publication of AU2015100679A4 publication Critical patent/AU2015100679A4/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Abstract

This invention relates in general to a method, system and apparatus or device for providing bookkeeping services. More particularly, this invention relates to a system, method, apparatus and device for the rapid input of transactions into an accounting system using a unique combination of general journal entries and source document digitisation. 13 Dec 2010 Check rd Debit- TACO BELL #71 12.93 132.80 13 Dec 2010 Wthd ra11- CITI CARD ONLINE 55.00 145.73 13 Dec 2010 Withd I- HSBC RS 113.00 200.73 8 Dec 2010 WIthdraWal- FOOD UON #1557 29.65 313.73 6 Dec 2010 Overdratre-entry Fee 24.00 343.38 6 Dec 2010 Non-SuflIcient Funds Fee 140.00 367.38 6 Dec 2010 Check C rd Debit- GOOGLE *GoDeddy 10.00 507.38 6 Dec 2010 Check C ird Debit - MARQARLACOM SA 12.00 517.38 6 Dec 2010 Wthdraval - FOOD UON #0536 31.95 529.38 6 Dec 2010 Withdrawal - DISCOVER 152.32 561.33 3 Dec 2010 Check Card Debit- ARBY'S #7503 00075036 4.31 713.65 3 Dec 2010 ATM DeFosit - 4209 PLEASANT VALLERALEIGH NC 681.41 717.96 2 Dec 2010 Withdra I 300.00 36.55 1 Dec 2010 Check C rd Debit- NEO-ASIA RSTR RALEIGH 24.96 336.55 1 Dec 2010 Check C rd Debit - HAN-DEE HUGO'S 94 Q84 32.68 361.51 29 Nov 2010 Withdrawal - SHELL Service St 10.86 394.19 26 Nov 2010 Maintenl nce Fee 11.95 405.05 26 Nov2010 Withdra-a- FOODLON#1557 12.85 417.00 26 Nov 2010 Check C rd Debit- J&S QUICK STOP, INC. 20.07 42925 26 Nov 2010 Wthdraw al- FOOD UON #1557 21.39 449.92 24 Nov 2010 Check Card Debit- TACO BELL #71 7.58 471.31 23 Nov 2010 Withdrawal 0.87 478.89 23 Nov 2010 WithdrayaI - FOOD UON #1557 76.70 479.76 23 Nov 2010 Withdramal - SALLIE MAE 223.66 556.46 23 Nov 2010 Deposit 0.38 780.12 23 Nov 2010 Deposit 0.49 779.74 22 Nov 2010 Withdrawal - FOOD UON #1557 3.76 779.25 ~~~~~~~~~~~~3~~~~~~~~~^ ^ . %l % -.. ~ .. l-t' I.6 ~ 1 1 * l.*f. fA

Description

Editorial Note 2015100679 There are 8 pages of description only SEQUENCE LISTING 1. Abstract 2. Description 3. Claims 4. Drawings AUSTRALIA Patents Act 1990 COMPLETE SPECIFICATION INNOVATION PATENT THE RAPID INPUT OF TRANSACTIONS INTO AN ACCOUNTING SYSTEM USING A UNIQUE COMBINATION OF GENERAL LEDGER JOURNALS AND SOURCE DOCUMENT DIGITISATION By Mark Ryder (mark@rydercid.au) 22/05/2015 FIELD OF INVENTION This invention relates in general to a method, system and apparatus or device for providing 5 bookkeeping services. More particularly, this invention relates to a system, method, apparatus and device for the rapid input of transactions into an accounting system using a unique combination of general journal entries and source document digitisation. BACKGROUND .0 Prior to computers and software, the bookkeeping for small businesses usually began by writing entries into journals. Journals were defined as the books of original entry. In order to reduce the amount of writing in a general journal, special journals or daybooks were introduced. The special or specialized journals consisted of a sales journal, purchases journal, cash receipts journal, and cash .5 payments journal. The company's transactions were written in the journals in date order. Later, the amounts in the journals would be posted to the designated accounts located in the general ledger. Examples of accounts include Sales, Rent Expense, Wages Expense, Cash, Loans Payable, etc. Each account's .0 balance had to be calculated and the account balances were used in the company's financial statements. In addition to the general ledger, a company may have had subsidiary ledgers for accounts such as Accounts Receivable. Handwriting the many transactions into journals, rewriting the amounts in the accounts, and .5 manually calculating the account balances would likely result in some incorrect amounts. To determine whether errors had occurred, the bookkeeper prepared a trial balance. A trial balance is an internal report that lists 1) each account name, and 2) each account's balance in the appropriate debit column or credit column. If the total of the debit column did not equal the total of the credit column, there was at least one error occurring somewhere between the journal entry and the trial 10 balance. Finding the one or more errors often meant spending hours retracing the entries and postings. After locating and correcting the errors the bookkeeping phase was completed and the accounting phase began. It began with an accountant preparing adjusting entries so that the accounts reflected 35 the accrual basis of accounting. Adjusting entries were necessary for the following reasons: additional revenues and assets may have been earned but were not recorded, additional expenses and liabilities may have been incurred but were not recorded, some of the amounts that had been recorded by the bookkeeper may have been prepayments which are no longer prepaid, and depreciation and other non-routine adjustments needed to be computed and recorded. 40 After all of the adjustments were made, the accountant presented the adjusted account balances in the form of financial statements. After each year's financial statements were completed, closing entries were needed. The purpose of closing entries is to get the balances in all of the income statement accounts (revenues, expenses) to be zero before the start of the new accounting year. 45 The net amount of the income statement account balances would ultimately be transferred to the proprietor's capital account or to the stockholders' retained earnings account.
These days, the electronic speed of computers and accounting software gives the appearance that many of the bookkeeping and accounting tasks have been eliminated or are occurring 00 simultaneously. For example, the preparation of a sales invoice will automatically update the relevant general ledger accounts (Sales, Accounts Receivable, Inventory, Cost of Goods Sold), update the customer's detailed information, and store the information for the financial statements as well as other reports. 15 The accounting software has been written so that every transaction must have the debit amounts equal to the credit amounts. The electronic accuracy also eliminates the errors that had occurred when amounts were manually written, rewritten and calculated. As a result, the debits will always equal the credits and the trial balance will always be in balance. No longer will hours be spent looking for errors that occurred in a manual system. After the sales invoices, vendor invoices, payroll and other transactions have been processed for each accounting period, some adjusting entries are still required. The adjusting entries will involve: revenues and assets that were earned, but not yet entered into the software, expenses and liabilities that were incurred, but not yet entered into the software, prepayments that are no longer prepaid, i5 recording depreciation expense, bad debts expense, etc. The adjusting entries will require a person to determine the amounts and the accounts. Without adjusting entries the accounting software will be producing incomplete, inaccurate, and perhaps misleading financial statements. After the financial statements for the year are released, the 'O software will transfer the balances from the income statement accounts to the sole proprietor's capital account or to the stockholders' retained earnings account. This allows for the following year's income statement accounts to begin with zero balances. (The balance sheet accounts are not closed as their balances are carried forward to the next accounting year). '5 Bookkeeping (and accounting) involves the recording of a company's financial transactions. The transactions will have to be identified, approved, sorted and stored in a manner so they can be retrieved and presented in the company's financial statements and other reports. Here are a few examples of some of a company's financial transactions: the purchase of supplies 80 with cash, the purchase of merchandise on credit, the sale of merchandise on credit, rent for the business office, salaries and wages earned by employees, buying equipment for the office, borrowing money from a bank. The transactions will be sorted into perhaps hundreds of accounts including Cash, Accounts 85 Receivable, Loans Payable, Accounts Payable, Sales, Rent Expense, Salaries Expense, Wages Expense Dept 1, Wages Expense Dept 2, etc. The amounts in each of the accounts will be reported on the company's financial statements in detail or in summary form. 90 All of the foregoing proposals or methods, however, contain one or more of the following limiting features: " The input of transaction can be slow as you have to use different sub modules in accounting )5 systems to enter in specific transactions. For example, in Quickbooks, to input in raise a sales invoice you need to go into Customers/Create Invoices. To then receive payment you click Customers/Receive Payments. If you are a bookkeeper and have various clients all using different accounting packages, then they have to get used to each method of inputting transactions. )0 * A lot of the accounting sub-modules request for information input that is doubling up on what has already been input, or is either irrelevant. Thus the bookkeeper is often wasting time inputting in data which is not needed, or it doesn't add any value. For example, why would you need to input in data about what an creditors invoice is, when you have already )5 input information in beforehand when raising a purchase order? e With each new accounting system, there is a continuously "dumbing down" of the accounting process. Back in the day, one had to input in the specific debits and credits relating to the transaction. These days the process has been simplified, so much so, that if .0 something goes wrong many bookkeepers (and indeed accountants) have trouble fixing things. SUMMARY OF THE INVENTION .5 To refrain from using the typical methods of accounting systems i.e. sub-modules, to enter in transactions. To also stop manual filing of paperwork i.e. source documents. In its place, a new system will be used, where transactions are input directly into the accounting system by General Journals. Each General Journal number will correspond to a Unique Identifier 20 which references the transaction to the bank statement for easy identification. After the transaction have been input, the source documentation will be digitized (scanned) and kept in the Cloud or on a backed up Server. This will allow for easy file retrieval, and will reduce the need for paperwork filing. 25 DESCRIPTION OF A PREFERRED EMBODIMENT In order to enable a clearer understanding of the invention, diagrams illustrating the preferred embodiment are attached, and in those diagrams: 30 FIG. 1 is a bank statement / list of transactions in which a box has been drawn by ruler around those transactions needing to be input into the accounting system. FIG. 2 is a bank statement / list of transactions in which those transactions needing to be input into 35 the accounting system have been labelled with a Unique Identifier letter.
FIG. 3 is an example of a General Journal being used to input a transaction found on the bank statement / list of transactions. [0 FIG. 4 is shows the digitized source documents being stored in the Cloud / Backed Up Server. Each document has been renamed (renumbered) to the specific General Journal entry it relates to. FIG. 5 is an example of a source document with the General Journal number that it corresponds to being written at the top of the page. [5 DETAILED DESCRIPTION OF A PREFERRED EMBODIMENT Referring to the figures above, the preferred embodiment starts with the creation of two data depositories labelled "Unpaid / Undeposited" and "Paid / Deposited". ("Unpaid" refers to unpaid i0 Creditor invoices, and "Undeposited" refers to unpaid Debtor invoices). All incoming financial paperwork is placed in the "Unpaid / Undeposited" repository. This is reviewed regularly and a payment / receipt runs takes place each week, where invoices are paid and receipted when they fall due. 15 Details of payment / receipt are recorded on the respective paperwork i.e. date paid, cheque number and amount on the document, and then the paperwork is placed in the repository "Paid / Deposited". i0 Periodically throughout the month the bookkeeper logs onto the Client's Internet Banking portal and prints off the latest statement / transaction list. It is then necessary to mark on the bank statement / transaction list a box around which transactions need to be entered into the accounting system (refer Fig. 1 for example). This will most likely be the 65 date from which the last bank reconciliation was performed until a couple of days before the current date. A Unique Identifier is then assigned to each transaction within the box. This is made up of the transaction date plus a letter from the alphabet. To start it off, one records an "A" to the left of the 70 first transaction's date. If the next transaction date is different, then one records an "A" to the left of this transaction date too, and so on. However, if there are other transactions on the same date then label the next one with a "B", and then "C" and so on (refer Appendix B for example). Continue to give a Unique Identifier to all transactions within the box (refer Fig. 2 for example). 75 The Unique Identifier becomes the transactions General Journal number by reading the Unique Identifier number backwards. For example a Unique Identifier of "A 2 Dec 2010" translates to General Journal Number "101202 A". The defined prefix is YEAR / MONTH / DAY / ALPHABET LETTER. Importantly, by using this number system, it makes it very easy to locate source documentation when it is referenced from the accounting system. For example, if a transaction had 80 a General Journal Number of "120105 B", one would be able to look at the bank statement for that period and see that the transaction occurred on 5 January 2012, and it was the second transaction on that day put through. Working from the oldest transaction towards the newest, enter each transaction into the accounting 15 system as a General Journal keeping within the following parameters (refer Fig. 3 for example): e Importantly, the emphasis is to enter only the minimum amount of information necessary to record the transaction as per Generally Accepted Accounting Principles. e The date must be the date in which the transaction hit the bank statement / transaction list. )0 e The journal number must be the Unique Identifier listed backwards, i.e. the journal number for a Unique Identifier of "A 6 Dec 2010", would be, "101206 A". Ensure there is one space between the number and the letter. * Code to the correct debit and credit accounts. * Ensure the tax item is recorded correctly. )5 e In the memo column, only record payment / receipt numbers, and a short description of the transaction (if it is necessary). * In the name column, ensure that the creditor / debtor are recorded on both lines. Write the journal number in bold letters at the top of all source documents (refer Fig. 5 for example) )0 as found in the "Paid / Deposited" repository folder. If a transaction doesn't have any source documentation, then one should write up a quick file note by hand using a Legal Pad if it is of a material nature. Digitise (scan) each source document, naming the softcopy file according the journal number (as per )5 Fig. 5). The following scanning parameters apply: * B&W colour mode. * 400 dpi image quality. * Double sided scanning (duplex mode). 10 0 Continue scanning after current scan is finished. * Use automatic document feeder scanner. Save all scanned documents to a Scanning folder in the Cloud / Backed Up Server (refer Fig. 4 for example). All hardcopies are kept for prosperity in an Archive Repository. Importantly, there is no 15 need to file these (as a traditional bookkeeping method would entail) as they have already been digitized. A Bank Reconciliation is performed to check that all transaction have been correctly captured. Next the Reconciliation Summary is printed (as is). After that the Reconciliation Detail Report is printed 20 with the following modifications made (in Quickbooks):): * Reduce type to "Gen..." from "General Journal" to save space. * Remove "clr" tab, and add "description" tab. * Make sure it all fits to one page. 25 The process comes to an end. COPYRIGHT STATEMENT 10 A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever.

Claims (5)

  1. 2. The method claimed at 1 allows for very quick input of transactions into the accounting system. This is because it utilizes the General Ledger to directly input transactions, as opposed to most, if not all accounting systems which use sub modules for data input. Sub modules in general require more information than the method claimed at 1 which equates 00 to more key strokes (and this time) to input the same transaction.
  2. 3. The method claimed at 1 allows for the digitisation of source material. A scanned document can easily be found and viewed with very little trouble, as opposed to having to file a hardcopy document by hand, and then have to search and retrieve it by hand with a manual 05 filing system. As such very little information is needed to be recorded in the accounting system about a transaction with a digitized copy, this is because if one needs to refer to a transaction, it can be easily accessed.
  3. 4. The method claimed at 1 promotes better accounting knowledge and understanding. As 10 each transaction requires a General Journal entry to be input, one needs to think about the respective debits and credits (i.e. double entry accounting) each time an entry is made. This helps one to understand the transaction better than alot of the newer accounting packages which now use a single entry interface that can dumb down your understanding of what is going on. 15
  4. 5. The method claimed at 1 reduces the likelihood of systems errors. As the system promotes the predominant use of the General Ledger, less accounting sub-modules are used meaning that fewer issues may arise due to the fact that those additional sub-modules aren't being utilised. .0
  5. 6. The method claimed at 1 extends the use of the Bank Reconciliation report which in addition to its normal purpose is also now used to help cross reference transactions back to the bank statement.
AU2015100679A 2015-05-22 2015-05-22 The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation Ceased AU2015100679A4 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2015100679A AU2015100679A4 (en) 2015-05-22 2015-05-22 The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
AU2015100679A AU2015100679A4 (en) 2015-05-22 2015-05-22 The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation

Publications (1)

Publication Number Publication Date
AU2015100679A4 true AU2015100679A4 (en) 2015-06-18

Family

ID=53370335

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2015100679A Ceased AU2015100679A4 (en) 2015-05-22 2015-05-22 The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation

Country Status (1)

Country Link
AU (1) AU2015100679A4 (en)

Similar Documents

Publication Publication Date Title
US5285384A (en) Payroll trust check system
CN105825425A (en) Financial data processing method applied to ameba management depositing and withdrawing style
Eisen Accounting
US8320656B1 (en) Automatic creation of after-the-fact payroll journal
EP3086271A1 (en) Method and computer system for automatic handling and payment of invoices
AU2015100679A4 (en) The rapid input of transactions into an accounting system using a unique combination of general ledger journals and source document digitisation
JP2012108619A (en) Discount application form preparation support system and discount application form preparation support method
KR20120014359A (en) Method for automatically journalizing using an act
JP6535179B2 (en) Bond transaction settlement management system and bond transaction settlement management method
CN115456747B (en) Automatic intelligent account settling method and device for ERP system and storage medium
Abrahams et al. The outcome of the discontinuation of cheques on bank reconciliation in South Africa
JP3871106B2 (en) Accounting system
Quinn Brilliant Accounting: Everything you need to know to manage the success of your accounts
JP2004272304A (en) Borrowing data creation device and borrowing data creation program
Horne Quickbooks 2014: A Complete Course
JP3116396U (en) Borrowing material creation and display device
Murray Accounting At Your Fingertips, 2e
Receivable Accounts Receivable
Costa Alpha teach yourself bookkeeping in 24 hours
JP2002099696A (en) Automatic journal processing system for reusing journal data generated in past
Lieurance Keeping records
JP2006092576A (en) Expense journalizing system
Mantovani Sage 50 Accounts 2016 in easy steps
Smails et al. Accounting Principles and Practice
Morse Examination, For Credit Purposes, of a Book Publishing House

Legal Events

Date Code Title Description
FGI Letters patent sealed or granted (innovation patent)
MK22 Patent ceased section 143a(d), or expired - non payment of renewal fee or expiry