Stack Overflow
Stack Overflow

Questions tagged [accounting]

Systematic recording, reporting, and analysis of financial transactions of a business.

357 questions
9
votes
3 answers

MySQL Double Entry Accounting System Database Design?

i am going to create a database for double-entry accounting system in MySQL. i recently read the article: http://homepages.tcp.co.uk/~m-wigley/gc_wp_ded.html i found in this article that it would be convenient to have three tables ACCOUNT, JOURNAL…
user617447
8
votes
1 answer

Use Integer Cents or Decimal for Accounting Amounts?

I'm working on a rails application with Postgres and ActiveRecord that is keeping track of payments and transaction fees (which are based on percentages). Currently I'm using BigDecimal (and decimal columns in ActiveRecord) to keep track of the…
Cyrus
  • 3,687
  • 5
  • 35
  • 67
8
votes
4 answers

How to convert in OpenERP from one chart of account to another?

I have installed chart of accounts A for company1. This chart was used couple months for accounting. How can I convert into chart of accounts B and keep old data for accounts (debit, credit, etc.)? In other words, is possible migrate data from one…
Nikola Stevanovic
  • 251
  • 6
  • 18
7
votes
4 answers

Javascript recursion for money laundering detection

I'm performing a statistical analysis to determine the possibility of whether a larger transaction has been hidden by breaking it into smaller transactions within a certain time frame. What I'm doing is breaking the larger data set into smaller…
asetniop
  • 523
  • 1
  • 5
  • 12
7
votes
2 answers

Accounting Database - storing a transaction

You make a gaming website where the user can buy gaming credits and the funds are deposited/credited into the user's virtual account to play some game etc...etc.. 1 If you got an accountant to record the transaction, it would be recorded like this…
001
  • 62,807
  • 94
  • 230
  • 350
7
votes
7 answers

Accounting System for Winforms / SQL Server applications

If you were going to write a vertical market C# / WinForms / SQL Server application and needed an accounting "engine" for it, what software package would you chose ? By vertical market, I mean the application is intended to solve a particular set of…
Craig L
  • 117
  • 1
  • 1
  • 6
6
votes
11 answers

How do people create re-usable databases?

How do people make reusable databases that can be used for many products? For example,if we have a database designed for a school...Can it be easily modified to be given to a college? What is the way to create a database that can be used as a…
Josh
  • 13,530
  • 29
  • 114
  • 159
6
votes
1 answer

High level transactions with states in a double entry accounting system

Assume there is a system with Double-Entry accounting: https://stackoverflow.com/a/59465148/4896540 https://stackoverflow.com/a/59857806/4896540 I prefer the latter model with normalised Transaction. There are long running complex operations with…
Alex
  • 972
  • 1
  • 9
  • 16
6
votes
1 answer

How to design a relational model for double-entry accounting with job costing

I would like to commend to readers the answers here and here for the depth and thought that went into them. I stumbled across them while searching for something tangential for a project I'm working on, and I got caught up reading them from top to…
Andy
  • 576
  • 1
  • 9
  • 23
6
votes
3 answers

Correct way to calculate prices including tax in foreign currencies

I'm trying to upgrade an application so that I can sell to multiple countries. I store all of my prices in the database in GBP excluding tax up to 4dp and I need to calculate the prices in the country's currency including tax. Do I multiply the…
nfplee
  • 7,643
  • 12
  • 63
  • 124
6
votes
3 answers

Why do Excel values in parentheses become negative values?

A colleague and I encountered a behavior in Excel which isn't clear to us. Background: We have a tool which converts an Excel sheet into a table format. The tool calculates the formulas which are in excel and replaces variables inside it with…
Bongo
  • 2,933
  • 5
  • 36
  • 67
6
votes
1 answer

Calculating Cost of Goods Sold

I have two tables, one for incoming inventory and one for outgoing inventory that look more or less like this: purchase (incoming) --------------+----------+-------+----------- inventory_id | quantity | price | timestamp…
zakm
  • 175
  • 7
6
votes
2 answers

Anyone got a nifty credit expiry algorithm?

Our website uses a credit system to allow users to purchase inexpensive digital goods (eg. photos). We use credits, rather than asking the user to pay for items individually, because the items are cheap and we are trying to keep our…
user163240
  • 61
  • 1
5
votes
1 answer

Basic SQL double-entry accounting ledger - how to split journal entries

Using the basic SQL schema from this Gist: https://gist.github.com/NYKevin/9433376 , how would one go about creating split journal entries? I understand why the entries table has a single amount with pointers to accounts to be credited / debited -…
Jordan Dimov
  • 1,268
  • 12
  • 26
5
votes
2 answers

What's the best way to ensure balanced transactions in a double-entry accounting app?

What's the best way to ensure that transactions are always balanced in double-entry accounting? I'm creating a double-entry accounting app in Django. I have these models: class Account(models.Model): TYPE_CHOICES = ( ('asset',…
Ryan Nowakowski
  • 811
  • 7
  • 10
1
2
3
…
23 24