Stack Overflow
Stack Overflow

Questions tagged [accounting]

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

357 questions
77
votes
24 answers

Use float or decimal for accounting application dollar amount?

We are rewriting our legacy accounting system in VB.NET and SQL Server. We brought in a new team of .NET/ SQL Programmers to do the rewrite. Most of the system is already completed with the dollar amounts using floats. The legacy system language, I…
Gerhard Weiss
  • 9,343
  • 18
  • 65
  • 67
59
votes
2 answers

Database schema design for a double entry accounting system?

Does anybody know or have any links to websites describing details of how to design a database schema for a double entry accounting system ??. I did find a bunch of articles but non were very explanatory enough. Would appreciate it if someone could…
soden
  • 587
  • 1
  • 5
  • 6
56
votes
2 answers

Relational Data Model for Double-Entry Accounting

Assume there is a bank, a large shop, etc, that wants the accounting to be done correctly, for both internal accounts, and keeping track of customer accounts. Rather than implementing that which satisfies the current simple and narrow requirement,…
Alex
  • 972
  • 1
  • 9
  • 16
50
votes
7 answers

Accounting Software Design Patterns

Are there any good resources (books, authoritative guides, etc.) for design patterns or other best practices for software that includes financial accounting features? Specifically, where is good information about handling issues like the…
Kristopher Johnson
  • 81,409
  • 55
  • 245
  • 302
24
votes
10 answers

Find out which combinations of numbers in a set add up to a given total

I've been tasked with helping some accountants solve a common problem they have - given a list of transactions and a total deposit, which transactions are part of the deposit? For example, say I have this list of numbers: 1.00 2.50 3.75 8.00 And I…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
23
votes
5 answers

Rehash: Accounting Software Design Patterns

Back in October, Kristopher Johnson asked about Accounting Software Design Patterns He received several answers, but they were all basically the same, pointing to Martin Fowlers Accounting Patterns. I don't really find Fowlers patterns all that…
Erik Funkenbusch
  • 92,674
  • 28
  • 195
  • 291
19
votes
8 answers

Double-entry accounting libraries for Java?

What double-entry accounting libraries are available for Java?
Derek Mahar
  • 27,608
  • 43
  • 124
  • 174
18
votes
22 answers

Calculate fiscal year in SQL Server

How would you calculate the fiscal year from a date field in a view in SQL Server?
R0b0tn1k
  • 4,256
  • 14
  • 46
  • 64
17
votes
7 answers

Evenly divide a dollar amount (decimal) by an integer

I need to write an accounting routine for a program I am building that will give me an even division of a decimal by an integer. So that for example: $143.13 / 5 = 28.62 28.62 28.63 28.63 28.63 I have seen the article here: Evenly divide in c#,…
Amberite
  • 1,379
  • 3
  • 14
  • 27
13
votes
4 answers

Is a document/NoSQL database a good candidate for storing a balance sheet?

If I were to create a basic personal accounting system (because I'm like that - it's a hobby project about a domain I'm familiar enough with to avoid getting bogged-down in requirements), would a NoSQL/document database like RavenDB be a good…
Neil Barnwell
  • 41,080
  • 29
  • 148
  • 220
13
votes
7 answers

Accounting and Database design, storing debit and credit amount

QUESTION: In the case below should I have stored all my amount as positives decimal amounts then flag the amount as either being a "Debit" or "Credit" rather than storing debits as negative amount and credits as positive amount? In my database…
001
  • 62,807
  • 94
  • 230
  • 350
13
votes
2 answers

Accounting Database - storing credit and debit?

When you store a transaction into a database 1) Do you store Credit and debit in the same record under two different columns? (without the positive or the negative sign) Example 1A TABLENAME ... ... (Credit) null (Debit) 100 Example…
001
  • 62,807
  • 94
  • 230
  • 350
12
votes
13 answers

Which open source database is the best option for an accounting-related system?

I am in the early stages of planning and designing a custom accounting application for my firm. My goal is to utilize an open source relational database for the data storage portion and I'm aware of two solid databases that are widely supported:…
Randy Burgess
  • 4,835
  • 6
  • 41
  • 59
11
votes
2 answers

xbrl us gaap contextRef standard?

Please tell me this is standardized, or at least there is some way to decipher it. I'm looking at these 3 random 10-Qs and Ks from…
user1382306
10
votes
11 answers

Writing a web application in excel? Why not?

Before you start flaming, I'm going to tell you that I am trying to convince myself that this is a bad idea. Basically, I'm trying to create a website with some basic accounting functions. My friend, a consultant who only knows excel, asked if this…
Chris
  • 1,475
  • 1
  • 20
  • 35
1
2 3
…
23 24