This book will walk you through Step-by-step, employing real-life conventional business processes and book-keeping techniques in developing real-world database engine for an accounting system that are robust, scalable and secured, using Microsoft SQL Server as the development tool. The author discusses the type of accounting modules, table design, entity-relationship and normalization concept.
The idea of writing a book, was not something I had in mind. It started as a coincidence. I have been working as an Accountant for many years. Back then, the computer software, accounting software in particular was revolutionalizing the way accountants work. As I started learning the user manual, which we all do, before we start to operate a machine, I realised there is this sense of curiosity of understanding the mechanism of the accounting software I was using. That, literally drives me to find out books that touches on Accounting Information System. Unfortunately, it is dissapointing to find most of these books, does not actually explain the mechanism of the functionality of a real accounting system. Most of these books only covers the theoritical concept of it, and not the technical aspect of it. That triggers my instinct to document all these knowledge and experience in a form of a book.
If you are looking for one that teaches on real database design and sql programming, then this might be the one you have been searching for. I given the title Accounting Database Design, instead of the conventional term of Accounting Information System, as I think it is only logical to use the conventional term, if you are literally talking about accounting system concept and theory. I incorporate the word design, because, the ingredient of this book, contains some technical guidance on creating tables for accounting modules, technical know how on entity relationship (linking your tables as an integrated system) and also some good lesson on sql programming. Sql in short, stands for structured query languange is a server-side scripting, that you need to master in order to create those financial reports (profit and loss, balance sheet, cash flow) that every Accountant or business manager would need.
Well, the intention of writing this book is not to profit from it. The fact that, the scarcity of such book is what drives me to write it down in the first place. If you are an accountant, a system engineer, a database designer or developer, this would serves as your source of information. An accountant would be equipped with GAAP knowledge, a system engineer would possess the designing skill, and to link and assimilate these two-side knowledge is what this book is trying to achieve. You would need this if your company is going through a system migration, developing in-house accounting system or churning out customised reports.
I have some that are harsh. The way of finding out whether you are buying the right book is to browse through a sample of pages of the book. In smashwords, readers are encouraged to browse some pages of the book and that will allow readers the discretion to decide whether to purchase the book. Of course, if you find the book interesting, I would encourage readers to purchase it directly from our official website (USD 20.00). The benefits of purchasing directly from our official site, is you will get a free pdf copy of the accounting database data diagram, detailing the relationship links between all the accounting tables, created from the book. If you are purchasing directly from our site, please send us your name, date and time of purchase to firstname.lastname@example.org. We will cross-check your purchase details against the information contained in our merchant account profile and will release a download link to our book by responding to your mail.
The book was written few years ago. Back then, digital publishing was not that popular. The traditional way of getting your book out in those bookstore, is the only way. I remembered those moments where I struggle to find an agent, an editor and a reputable publisher. Getting an agent is easy, not without a fee, but to get a trustworthy editor was demoralising. I lamented the decision of finding one, as I could not bear the pain of criticism. They would literally throw out any dissatisfaction or correction to you if they think there are some grammatical error or shortcoming from your writing skills. I recalled sending multiple mails to some potential publisher with a copy of my writing samples and all of them turned me down literally. I have given up hope of finding ways to publish the book for a few years, when suddenly one day I was casually browsing some ebook publishing site that I happenned to saw smashwords giving indie authors the privileges that most of us would dream of. Smashwords gives us the liberty of designing and pricing our books and best of all, at no charges, except for a small share of your book sales.
Learn how to write SQL for an accounting system. You will learn how to develop various modular graphical user interface with strong business logic control, how to create accounting tables and how to write powerful SQL statement involving the use of joins, subqueries, cursors, advanced data filtering, constraints, stored procedures and triggers in building a complete functional accounting system.
The root to SQL is programming. But, if you ask a programmer to code for an accounting system, does the programmer knows how to code, to begin with? Does that person knows what is accounting concept, double-entry principle, GAAP and other accounting treatment that are adopted in our working world? With this book, hopefully it may shade some lights.
Current ERP and business software is still thriving in PC-based, but eventually as time pass, we will slowly see some of these ERP and business software move towards the mobile-based platform.Technology is fast changing the human culture and life style. The way we communicate and socialize is so different compared to a decade ago.
Again, it is not profit motivated, but what I would like to do with this book, is to share some of my knowledge and experiences with those who are interested in accounting system development. There are a lot of missing business rules and weaknesses in some of the existing business applications, and hopefully with this book, these group of people may gain an insight into some of the proper development guideline and techniques, which was incorporated in DES 1.2.
Nop, not for this book, but there are some negative comments made on my first ebook, which I feel a bit discriminative and uncalled for. As a writer, I appreciate readers to give their fair share of thoughts, as it would help me to improve some of the shortcomings in some of the books which I have written. For those who are interested in buying a copy of these ebooks, I request that you send us your name, date and time of purchase to email@example.com. We will cross-check your purchase details against the information contained in our merchant account profile and will release a download link to our book by responding to your mail.
One apparent missing features in most of the application or ERP system, is audit trail. An audit trail not only can tell the end-user the process flow of an accounting transaction in the system, but, if we can see the flow of each transactional posting, we can determine the source of each transaction entry and we can pinpoint or gauge any missing elements (e.g. business rules) along the process. Another area which I believe, would be forthcoming, is having an in-built tool that can allow us easy access to the accounting database. We can develop a search engine tools, similar to Google Search Engine, which can then allow us to retrieve any kind of information that we want from the accounting system for further analysis. Just imagine the depth of information which we can obtained, if we can trace the flow of a particular documents or product item from its original source to the end of the process flow. The search result may shows us where is the product item is originally purchased, at what price and the location of the supplier. We can see to whom and where will this product item will be deliverred. By having this information, we are able to improve on our delivery and procurement system, with better update on customers' product ordering status.
I believe the role of accounting profession would not only be confined to pure accounting concepts and standards. Technology is fast over-taking the role of some of the work performed by the accountants. In the 90s we see emerging bookkeeping software that not only substitute the bookkeeping function, but also these application can also produce financial statements, with a click of a button. In the 20th century, we see tremendous integration of work processes across multiple functional department in various industry, hence, the emergence of enterprise resource planning (ERP). In the next decade, I believe, the next great exploration would be on business intelligence and social interaction. Business Intelligence (BI) would helps organization in making better decision-making, better predictive analysis and better forecasting. As for social interaction, most of the outsourcing provider are leveraging on social-media in improving their customer service via communicating with their clients via live-chat and social-networking. With these vast amount of data maintained in a database environment, we can expect to see greater auditing tools and forensic software being developed to assist auditors in performing their system auditing and audit testing analysis. We also can see some new development in the taxation area. Currently, there are tax software being developed for deferred tax computation, value added tax (VAT) reporting and other tax-related automation. In the next phase of growth, I think we can see some integration of all these taxation computation and reporting in a centralized system, given the vast expansion of our global economy. This will provide organisation a better overview of their current taxation status and exposure, which in turn will allow business leaders to make better taxation planning and restructuring across their overseas operations.