Back to Main Page
Golioth Enterprises Consulting Ltd.
 
 

 

 

 

Unlimited Accounting support for your green business!  

Check these templates out!

Bank Rec Workbook

Travel Template
Self Employment  
Operations Reporter  
 
   

Why use database and spreadsheet as a solution to accounting?

 

Spreadsheets have come a long way in the last few years since around the year 2000 if not before then. The fact is there is almost virtually you cannot do with them now a days! From my many years of experience using them I know a lot but there is so much to learn. Virtually you only ever use 10% of a spreadsheet's capability. There are tasks that a spreadsheet can perform which most people do not realize. We bring this information to everyone's attention because these tools are there to make our life easier if one knows how to use them properly!

 

 

 

 


 

 

Do database and spreadsheet applications frighten you? We'll have you smiling and enjoying your time looking through financial reports!

 
   

Extra! Extra!  Do not fear technology...

Here at Golioth Enterprises we believe that technology is a useful tool in the aid of cost analysis and financial reporting.  It makes life much easier; and this is why we use them as a tool to calculate and perform financial analysis to aid you the customer in timely reporting so you can go about your busy day worrying about other things than making sure that your financial reports are correct.

I have had many years of experience in dealing with advanced level reconciliations performed in Microsoft excel and access to aid controllers and VP's make financial decisions. I hope that some of the examples to your right will be of assistance to you and your organization's needs.


Enterprises Resource Planning (ERP) Woes?

Is your accounting system less than helpful in compiling your businesses' financial information? Did you know that if your system can perform data transfers into excel that there is a way around such problems? With the use of  v-lookup tables there is much information that can be brought to light as per use of financial performance reporting? 

When you set up your v-lookup table remember to trim the columns appropriately in excel so data is recognized as being of equal value. If this is the case you will be able to pull information from totally separate data tables and create a complete financial picture that you are looking for. 

 

 

 

 

 

 

Extra! Extra!  Keep track of your data

Keeping track of one's data or databases if you will is imperative. This is not only imperative for your financial/accounting information, but as well as up keeping your information about your vendors, sales contacts, and business contacts. This is just one of the examples! The point is learn how to back up your data... IT IS IMPERATIVE TO THE LIFE OF YOUR BUSINESS!

In recent experiences in working for a client, they disregarded the first rule of safe keeping your data, perform daily backups of all you business information. They switched their system to a different server thinking everything was peachy. In setting up the new server they could not access any of their business contact information. Suffice it to say the next day when everyone was looking for their contacts information, not one person was thrilled to find out that they could not retrieve information from their new server!

Some staff went as far as saying they wish they just had written their contacts' information on a piece of paper! Don't let this happen to you. Golioth Enterprises provides training, tips and tools to help you back up your business information and keep it safe. We have years of experience in data safe keeping and management.


 

 

 

 
 

Copyright © 2008 [Golioth Enterprises Ltd]. All rights reserved.
Revised: 11/09/08