Open links in new tab
  1. Towards Data Science
    https://towardsdatascience.com/how-to-build-an-accounting-system-using-sqlite-2ce31f8b8652

    How to Build an Accounting System using SQLite

    • In this post, I’m going to show you how to build a crude accounting database using SQLite. The reason is that creating an accounting database is advance enough to cover all the aspects of databases an… See more

    Accounting 101

    Before you get excited too much, let’s have a crash course first on accounting. The fundamental accounting equation is Assets = Liabilities + Equity That equation has basically th… See more

    Towards Data Science
    Xero’s Implementation of Accounting

    The important thing to remember is that Xero is designed in such a way that it will be useful to business owners (not accountants) in the day-to-day operations of the busin… See more

    Towards Data Science
    Caveat: We’Re Not Going Down The Rabbit Hole

    Designing an accounting is really complex. It will take multiple blog posts just to cover this topic. Hence, for simplicity, we’re going to create the following assumptions (not exactly ho… See more

    Towards Data Science
    SQL Basics

    Now before reconstructing our version of Xero’s database structure, let’s have a crash course on databases. A database is a collection of tables. Each table consists of rows of dat… See more

    Towards Data Science
    How to design a financial accounting application database?
    Designing simple yet functional database for financial accounting application In the previous article, we discussed general financial accounting application database design concepts and defined a very basic roadmap for the whole database like: defining the business domain, basic requirements to be met, primary key usage policy, naming conventions.
    codeproject.com
    Feedback
    Table of Contents
    Accounting 101
    Xero’s Implementation of Accounting
    Caveat: We’Re Not Going Down The Rabbit Hole
    SQL Basics
    How to design a financial accounting application database?
     
  1. Question & Answer
  2. CodeProject
    https://www.codeproject.com/Articles/5…

    Database for Financial Accounting Application II: …

    Aug 9, 2019 · In this article, we have developed database schema for the core accounting infrastructure: general ledger, chart of accounts, (source) documents and financial statements. We also proved that the application schema is …

  3. asme.org
    https://cie-advances.asme.org/GR-8-06/Resources/...
    [PDF]

    Database Design For Accounting System (book)

  4. Database Administrators Stack Exchange
    https://dba.stackexchange.com/questions/1…

    Double entry bookkeeping database design

    May 24, 2015 · All there is to accounting data is a set of transactions which give amount and the accounts from which and to which they flow, along with their date, some description (and other attachements). Ledgers and balances are simple …

    database design - Understanding a double entry accounting DB Schema ...Dec 26, 2021
    database design for accounting systemsNov 7, 2018
    See more results
  5. Stack Overflow
    https://stackoverflow.com/questions/5943…

    Relational Data Model for Double-Entry Accounting

    Dec 21, 2019 · This answer is remarkable for two things (apart from its length): a) there are no citations to established practice/textbooks; b) the design of "a …

    • Reviews: 4
      Designing Accounting DatabaseJul 19, 2021
      How to design a relational model for double-entry accounting with job ...Jan 20, 2020
      Database Design for a double entry accounting systemJun 14, 2010
      Database schema design for a double entry accounting system?
      See more results
    • AccountingTools
      https://www.accountingtools.com/articles/...

      Accounting system design — AccountingTools

    • ResearchGate
      https://www.researchgate.net/publication/29…

      Accounting Database Design And SQL Implementation …

      Jul 29, 2011 · This paper extends previous work in the context of database design in the accounting area and illustrates the power of the Structured Query Language (SQL) with more advanced business and ...

    • GeeksForGeeks
      https://www.geeksforgeeks.org/how-to-design-a...

      How to Design a Database for Financial Applications

    • CodeProject
      https://www.codeproject.com/Articles/5…

      Database for Financial Accounting Application I: Basic …

      Sep 15, 2019 · In this article as the first in the series, I’m going to discuss general database design concepts and define a very basic roadmap for the whole database like: defining the business domain, basic requirements to be met, …

    • Center for Open Education
      https://open.umn.edu/opentextbooks/tex…

      Database Design - 2nd Edition - Open Textbook Library

      Database Design - 2nd Edition. (13 reviews) Adrienne Watt, City University. Copyright Year: 2014. Publisher: BCcampus. Language: English. Formats Available. PDF. Online. eBook. Conditions of Use. Attribution. CC BY. …

    • Some results have been removed