Reducing Data Entry Errors

Written by Marc | September 25, 2006 | Comments Off

There are many methods for reducing input errors in your online accounting file. Accountants use workflow processes that they know will create more predictable accuracy. Learning about some of these and adopting them in your accounting routine is a good investment in time that will reward you for many years to come. Some of these methods are discussed below, however there are many more:

Basic review of your transaction listings

As you create transactions they will appear in your transaction list for the date period applicable. The process is usually to Add a new transaction to the List, Save and Close the transaction and then check the transaction for correctness. You cannot check all the detail for transaction but the main items such as Date, Amount and Contact can be verified. This is the most basic and quickest, but least thorough, of checks you can do.

Review of your Transactions by Account report

This is a good report for checking you have used correct tax codes and ensuring you have chosen the correct Account for you transactions. You might scan the report to ensure that (for example) all your sales appearing in an Account for Income: light fittings would have the same tax code. You might also check that there aren’t any stray transactions in this Account that shouldn’t be there.

Use the duplicate function for adding transactions

When you use the Duplicate button on any Add/Edit Transaction screen you are creating an exact copy of the transaction you are viewing with a few fields cleared like the Date for example. This helps produce consistency in your transaction adding over time as you will be using the same Account, Tax Codes and Summary as you are duplicating the information not entering it.

Use Transactions Lists to help in adding transactions

A good example of this is when you have regular periodical payments you make for things such as subscriptions, rent, bank fees that are often the same each month except for the transaction date.

  1. Load the Transactions for a Contact and click the plus icon next to the transaction to load a duplicate.
  2. Then you can include the date for this new transaction and amend any other differences (eg. Summary..”Jul08 rent” to “Aug08 Rent”) and then save the transaction.

Use the Transaction Lists to help in adding transactions

As in the above example you can create a list of transaction for the previous month (or period). Use the same process to create new transactions for the new month (or period).

Additional

Make sure you have paperwork, invoices, and bank statements to back up you data entry. Just assuming these things will happen each month (or period) doesn’t mean they actually do!

  • Share/Save/Bookmark

Payment Centric Accounting

Written by Marc | January 22, 2003 | 0 Comments

Many small business use the Just-In-Time approach to payment processing and invoice issuing. This means writing cheques, using a credit card or paying online when vendors start demanding payment or when a bill reminder comes in. This can work when your cashflow is tight. A method that may appeal to some small businesses or investors (but not all) is a Payment Centric method. In a nutshell you choose a frequency that you plan to make payments (or issue invoices), you then write your cheques or process your Bpays, and book the transactions in your accounting system, all on one day. Let’s call this the ‘accounts day’. Then you don’t touch the accounts until the next assigned ‘accounts day’.

With any business system or procedure it’s a case of what works best for your specific needs. Who are the experts at processing and doing accounts efficiently? Accountants must be on this list. They are not just there for tax advice.

We have a listed a few pro’s and con’s that you might like to consider.

Why does this work?

  • Get all your cheques prepared and then signed in one session by the cheque writer or cheque signatory.
  • Allows you to use Internet banking templates to process multiple payments on that day.
  • It may help to manage you cashflow in a more predictable way. e.g. If you know that the 5th of each month is payment processing day and you have $X dollars to make your payments then cashflow becomes more predictable.
  • Doing a task 20 times in one sitting is nearly always more efficient than doing 1 task over 20 sittings.
  • When you do everything on one day, filing is a lot easier.
  • Your vendors and customers will find your organisation more predictable and professional.
  • Your work colleagues and employees will know that its the ‘accounts’ day. You can deal with it on that day rather than interrupting work.
  • If you have a bookkeeper or a bookkeeping company to do this work, it will nearly always be cheaper to have them in for one full day, rather than have them in spasmodically over time.
  • Your Profit and Loss and Cash Flow reports (and others), may end up cleaner and clearer.

When doesn’t it work?

  • When the gaps between ‘accounting days’ are set too far apart your management information may get out of date, your vendors may get impatient and you might hate the idea of spending a whole day just doing ‘accounts’. Select a frequency that suits your business model from a holistic perspective.
  • When your customer insists on invoices immediately or very regularly. Note that there are legislated requirements for invoices to be issued within a certain time after services have been provided.
  • When vendors insist on getting cash on delivery
  • When you forget to pay a vendor then they have to wait until your next ‘accounts day’. This can really upset vendors. Then they might charge you more. Ouch!
  • Share/Save/Bookmark
delic16.jpg  twitter.png