Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets
Topics: small business accounting, bookkeeping, bookkeeping spreadsheet, income, expenditure, accounting
Accounting software is used by accountants to enter many complex financial transactions into the financial books of account and is almost invariably based upon double entry bookkeeping principles. A major advantage to those companies and the finance staff is the extent to which financial information contained in the database can be queried for financial control purposes.
An accountant needs to not only ensure the financial records are accurate but also retrieve any part of the accounting records to answer accounting questions on the accounts, provide a legal basis for the transactions and report the financial statements at regular periodic intervals.
The small business has different accounting needs which are better described as bookkeeping than accounting. For non limited companies that do not need to produce a balance sheet then a simple income and expenditure account can be produced much simpler using single entry bookkeeping principles.
Less financial control is often required from small business accounting software as the bookkeeper is often the owner manager who already has an intimate knowledge of each transaction. Books are still required for tax purposes and a solid requirement of preparing a set of financial books for tax purposes is that each entry is supported by third party evidence.
Examples of third party evidence would be sales invoices, purchases invoices and bank statements. Financial transactions where no receipt exists can still be entered in the business books although all transactions not carrying third party evidence could subsequently be disallowed for tax purposes and certainly would be if the amounts entered indicated unusual income or expenditure.
Producing an income and expenditure statement using single entry bookkeeping is little more than making two lists of financial transactions. Those lists being one of sales income received from sales invoices or receipts issued to customers and the other of purchase expenditure being from purchase invoices received from suppliers.
To record sales income it would not normally be sufficient to simply add up the total of the invoices as such a summation does not leave an audit trail of the items which have been included. A written list of sales invoices does provide an audit trail.
Sales accounting for a small business accounting purposes can be either a manual list of the sales invoices or by using a spreadsheet package a list can be made on a bookkeeping spreadsheet. Using a spreadsheet for the bookkeeping has advantages as simple formula can be used to add up the column totals.
The essential information to enter for a sales invoice would be the date of the sale, name of the customer, sales invoice number if applicable and optional a brief description of the item sold. In the next column would be the total sales invoice amount. If items like value added tax are required to be accounted for then an additional column would be required to accommodate the vat or sales tax accounting.
A further small complication might be if at the discretion of the small business owner additional information was required from the bookkeeping records to indicate the totals of the different types of products and services then additional columns could be incorporated to enter the net sales figures in these columns.
There it is then, a simple list of sales invoices to satisfy the sales accounting requirements for a small business where a balance sheet is not required.
On the expenditure side of the business the bookkeeping can also be a simple list of the purchase invoices and receipts showing the amount spent. The list should also produce an audit trail by showing the date of the purchase invoice, name of the supplier, purchase invoice for identification purposes and the total amount spent.
Usually tax returns are the main purpose of producing small business accounts and invariably some analysis is required to show what the expenses have been spent on. That is not difficult to achieve and as with the sales accounting the owner manager can add additional standard columns to the bookkeeping spreadsheet.
The expenditure analysis columns do not need to be a different column for each type of expenditure. It is better to set up and group the analysis columns in general headings which can accommodate all the expenses.
Such columns may include stock, other direct costs, premises costs, general administrative costs, transport and delivery costs, repairs and maintenance, travelling and hotel costs, motor costs, bank and legal costs and other expenses. It is better not to enter too many items under a general heading of other expenses as this is more likely to be investigated as the type of expense has not been precisely identified.
One important column to also include is for asset purchases as fixed assets usually have different tax rules applying to the claim of the expense against tax and should be separated from other expenditure.
Having set up two bookkeeping spreadsheets the task is then to produce the income and expenditure account by collecting the totals of each of the analysis columns. The sales total is the sales turnover from which is deducted the totals of each of the expenditure classification totals with the result being the net profit and loss of the business.
Where stock is bought and sold a further adjustment may be required to account for the difference between opening and closing stock. This is done by taking a physical stock check and valuing the stock at the start and end of the financial period.
On the income and expenditure account adjust the stock purchases figure by adding the value of the opening stock and deducting the value of the closing stock. The result is not the stock purchases total as shown in the bookkeeping spreadsheets but the cost of the goods which have been sold to produce the sales turnover being reported.
Simple bookkeeping for a small business accounting purposes can be two lists of sales and purchases supported with sales invoices and purchases invoices.
Terry Cartwright, an accountant at DIY Accounting designs UK Accounting Software spreadsheets for companies at www.diyaccounting.co.uk and self employed bookkeeping software www.diyaccounting.co.uk
Previous Articles Highlighter:
Dog Training - Leash/Collar Training (1)
For instance, dogs that have an important job to do, such as rescue dogs, police dogs and guard dogs, generally benefit from leash and collar training. In leash and collar training, varying degrees of force can be used, ranging from slight prompts with the lead to very harsh corrections.
Buying A Good DVD Player (2)
A remote with simple layout and visibly labeled functions makes the navigation easy for the user. A well planned remote control will not only make the operation simple but will also help in swift management of the settings.
What Makes A Good Movie (3)
It should have the capacity to teach and inspire us and provoke us emotionally. Educative: It should be able to let us know about something new. Nowadays movies are considered to be one of the most effective educational tools used to teach or educate people regarding certain issues.
How To Setup A Website For The EBay Affiliate Program (4)
There are other steps you will have to take, and all of this can be quite daunting, especially to a beginner to internet marketing. You need all the help you can get, even if you already have your own websites.
Consolidate Debt Loans For More Convenience (5)
You can also make a success the payoff time to several years depending on your eligibility (though this will increase your total interest to be paid on the life of the loan).
Read This Before You Invest In Cheap Advertising (6)
Well, it probably is. A business without a sign is a sign of no business. This is an advertising banner or quotation that can be seen in large billboards along the roads and on the side or top of buildings that is vacant.
Shade Trees: A Wealth Of Landscaping Benefits (7)
Landscape Shade trees are the basic element for any landscape plan. They are versatile parts of our landscapes. The fact that these trees can cool temperatures in the surrounding landscape and cool off houses during the heat of the summer is well known.
Website Marketing: Do You Make These 3 Mistakes With Free Offers? (8)
So their offer all kinds of freebies to generate leads, convert visitors and attract clients: sample sessions, get-acquainted calls, bonus gifts, introductory and CDs. Being generous, they often toss off a free offer because "everybody does it." Free offers can be a rewarding investment of your time or a wasteful drain on your energies.
How To Write A Good Blog Post And Get Free Traffic From It (9)
OnlyWire is a quick way to submit to multiple directories with one click. If you write a good article and get it posted correctly you will soon find yourself attracting traffic.
Foreclosure Laws: Get Proper Legal Advise If You Are Facing Foreclosure (10)
Generally, they would rather try to work something out then to pursue the process and expense of a foreclosure. Hiring someone that fully understands and can advise you on the local foreclosure law may be a wise decision on your behalf.
Newer Articles Highlighter:
Indoor Cat Versus Outdoor Cat: What Do You Do? (1)
They can repose in their cat condos houses or cat condos with stairs to climb. There's a huge selection but you can usually find cheap cat condos on the net.
Origin, Development And History Of The Car Stereo System (2)
With the introduction of FM receiver, the seek function stepped in. The seek function would allow the user to tune from one station to the next at the push of a button.
PlayStation DVDs For Your PS (3)
The missions are so interesting that you cannot leave the game without completing it. Technology has made these games near perfect. Almost realistic sound and picture quality have given these games a new dimension.
SIP Insulated Garden Offices For A Warmer Working Environment (4)
Although the materials used, mainly polystyrene and timber (plywood in garden offices) are not considered to be strong individually, when bonded together they become extremely strong and form the main load bearing elements of any building that use them within their structure.
Training Your Dog To Heel (5)
Remember to train with love, patience and consistency and your dog will return you with devotion and many, many years of companionship. Anthony Stai is a proud contributing author and writes articles on several pet related topics including dog training.
Enjoy Teaching Your Children To Cook (6)
As they learn to cook more complicated recipes, let them be responsible for planning -- and cooking lunch or dinner one night. Letting your kids plan the meal -- and even shop for the ingredients will help them to realize and appreciate the effort that goes into cooking.
Directory Marketing Is Still Alive In 2007 (7)
Another benefit is "natural" search engine discovery. The search engines visit most directories daily and will pick up new site links and visit your site quickly and add you to the index - usually within about a week.
Buying A Home: Tips For Making A Solid Offer (8)
You will be able to move forward and make the purchase of the ideal piece of Tampa real estate, a place that truly will become the home of your dreams.
Top 3 Ways To Boost Your Affiliate Commissions Overnight (9)
Malia Wofford is an up and coming internet marketing guru!Malia is the owner of www.moneystatspackage.com and alia-internetmarketing.blogspot.com websites that offers a system that can help anyone succeed at having an automated business.
Which Affiliate Networks To Look Out For When Promoting (10)
Be aware of the things that members are not happy about in a program. Like with the ones mentioned above, you can do your checking at discussion forums. If you know someone in that same program, there is ho harm asking if there are many downsides involved.
Permalink to Small Business Accounting Software Equals Simple Bookkeeping Spreadsheets