These 5 accounts - Assets, Liabilities, Equity, Revenues, & Expenses - are the account types that you typically see in an accounting system. We can expand the above equation to break down the EquityĪssets = Liabilities + Beginning Equity + Revenues - Expenses The right-hand side describes how the assets were financed - either thru Liabilities or Equity. and Equity, the accumulation of all the owner’s investment, drawings, profit or loss.Assets are all the resources of the entity.But this is a very interesting project so let’s do it! Accounting 101īefore you get excited too much, let’s have a crash course first on accounting. Certainly, the SQL presented here is not the exact SQL design that Xero use as their system needs to scale. The good thing about Xero is that it has a nice clean interface and a lot of apps to choose from to extend its functionality.ĭisclaimer: I’m not an engineer nor developer at Xero and these observations may not exactly correspond to how the system works as it is always updated. It has now expanded to Australia, the US, Canada, and the UK.
For those who are not familiar with it, Xero is a cloud accounting software originated in New Zealand. I got the inspiration to create an accounting system using SQL by observing how Xero works. Hence, might as well “solve” a difficult one to fully learn SQL. After all, programming is a tool to solve problems. The reason is that creating an accounting database is advance enough to cover all the aspects of databases and SQL - from queries to joins to views and CTEs.Ĭoming from an accounting background, I think that this is the best project to learn SQL.
So, why create an accounting database? Why not just copy public data, shove them to SQLite, and practice from there? In this post, I’m going to show you how to build a crude accounting database using SQLite. will get you nowhere if you’re starting to learn programming.
Mindlessly going to tutorials in Youtube, reading programming books, copying code from Reddit posts, etc. Practically, it means that you have to solve things or choose projects that are relevant to you - either in your work or personal life. This is the advice that I always give whenever someone asks me how to learn programming.
0 kommentar(er)
