Stack Overflow
Stack Overflow

Questions tagged [accounting]

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

357 questions
5
votes
2 answers

Best practices for doing accounting in Python

I am writing a web2py application that requires summing dollar amounts without losing precision. I realize I need to use Decimals for this, but I've found myself having to wrap every single number I get from the database…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
5
votes
1 answer

Java - Which accounting module is best to embed in my JAVA application?

I am developing a java application. I want to integrated some accounting module in my app. I don't want any feature-rich accounting module. I just want to maintain salaries expenses generating invoices So do you know any FREE OPEN SOURCE…
Amit
  • 33,847
  • 91
  • 226
  • 299
5
votes
1 answer

how to calculate balances in an accounting software using postgres window function

I'ved got a problem same as this but I am using Postgres. Calculate balance with mysql have a table which contains the following data: ID In Out 1 100.00 0.00 2 10.00 0.00 3 0.00 70.00 4 5.00 …
Axil
  • 3,606
  • 10
  • 62
  • 136
5
votes
1 answer

Financial Account pattern implementation in Clojure: ref or agent?

I'm working my way through Fowler's Analysis Patterns and programming examples for myself in Clojure as way of developing a better understanding of both. Putting persistence/durability issues to the side for the moment1, it seems that Clojure refs…
CBFraser
  • 435
  • 2
  • 8
4
votes
3 answers

mysql query of a date, between two date fields

I'm using MySql 5.5. I need to find a userid on a date with a particular ip address. The fields are userid, ipaddress, startdate, enddate. So for instance I am looking for a userid with ip address 192.168.1.1 on Sep 12 2011. the query would be…
notmyname
  • 69
  • 2
  • 6
4
votes
1 answer

online credit system table layout for transaction destinations foreign key

I'm trying to figure out how to properly store foreign keys when the key points to a different table based on a type. I searched but nothing I found seemed to help at all. There is a single table that will store most of the basics for the…
phazei
  • 5,323
  • 5
  • 42
  • 46
4
votes
2 answers

Double Entry Accounting pagination issue

There is a really serious issue about Double Entry Accounting systems with pagination, I think it is common but I still didn't find any solution for my problem yet. You can use this link to read about the simple Double Entry Accounting systems just…
tinyCoder
  • 350
  • 13
  • 37
4
votes
3 answers

What is the correct way to store payments and refunds in a transaction table?

I have an issue that touches both accounting and database principles. I have a table called Payments that, among other columns has this structure: ------------------------------- id | amount | type ------------------------------- 1 | 100.00 |…
Darshan Shakya
  • 71
  • 5
4
votes
3 answers

Database Design for a double entry accounting system

Should journal entries be recorded in a database design? In the real world it makes sense to keep a daily entry book, then later transfer the daily entry book into double entry accounts. but in the computerized version, doing this produces duplicate…
001
  • 62,807
  • 94
  • 230
  • 350
4
votes
1 answer

How to update balance in a accounting app with django ?

I'm learning Django, trying to do an accounting app for keeping track of my expenses, etc.. I created the database with two models, one for accounts and one for operations. But i have no idea how to keep my balance updated with each operation. I was…
Serphone
  • 107
  • 1
  • 1
  • 6
4
votes
3 answers

SQL: Creating aging buckets based on last payment date for financial reporting

I need to create an aging report of credit balances on the customer-level. Notes: Aging is based on customer's last payment date. A customer can have multiple accounts, and there are sometimes errors in which a payment is applied to the wrong…
texas_mike81
  • 71
  • 1
  • 2
  • 11
3
votes
6 answers

Financial tracking for software projects

The team I'm part of manage a number of software projects - and most of the stuff we do is end to end, from requirements tracking, to project management to purchasing and setup - a big pain is tracking of financials as we have a whole process to go…
anbanm
  • 13,425
  • 5
  • 22
  • 17
3
votes
2 answers

looking for a simple database design for accounts receivable

I am in the process of adding accounts receivable to one of my webapps. Essentially, I want to be able to create sales invoices and record payments received. The reports, I generate are statement with balance outstanding invoice receipt To create…
bumperbox
  • 10,166
  • 6
  • 43
  • 66
3
votes
1 answer

Linking payables and general ledger in the database schema

A December 13, 2010 a question was asked: I am looking for industry standard logical data model of general ledger and accounts >payable. Are there any readily available accounting data models? Ken Downs replied: Excerpt: The most basic ledger is…
kimmba
  • 31
  • 1
  • 2
3
votes
1 answer

rollback to the previous offset when an error is throw while pulling data from Intacct

When my script is pulling the data from Intacct 100 xml object at a time everything is working fine using my resultid to remember the offset and pull the next once, and for some reason, it gets to one of the loops and it throws an error saying not…
mongotop
  • 7,114
  • 14
  • 51
  • 76
1 2
3
…
23 24