Stack Overflow
Stack Overflow

Questions tagged [accounting]

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

323 questions
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,127
  • 5
  • 37
  • 46
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
  • 55,049
  • 82
  • 210
  • 324
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
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
  • 11,961
  • 5
  • 20
  • 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
  • 9,575
  • 6
  • 40
  • 63
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

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
  • 512
  • 1
  • 5
  • 13
3
votes
0 answers

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 get to a one of the loops and it throw an error saying not…
mongotop
  • 5,758
  • 13
  • 43
  • 70
3
votes
1 answer

Programmatically pushing data to Quickbooks Online?

Our company uses Quickbooks Online to track our books. When our application bills a customer, it would be nice to have that information recorded automatically in QB rather than logging in to QB Online to fill in the info. Is there a way to…
QuickbooksUser
  • 31
  • 1
  • 2
3
votes
3 answers

Ruby on Rails REST design question - transfer money between accounts

I have an Account class, want to implement transfer screens to allow a user to transfer money between 2 accounts. How would I implement this ins RESTfull way? I have the standard account and rest actions for that, thats fine. But how would I…
Joelio
  • 4,402
  • 6
  • 36
  • 74
3
votes
2 answers

How can I set contents of a spreadsheet cell to Accounting format with EPPlus?

I need to set the contents of certain columns to Accounting format. This attempt: public static readonly string NUMBER_FORMAT_ACCOUNTING = "$"; . . . bidPriceCell.Style.Numberformat.Format = NUMBER_FORMAT_ACCOUNTING; ...simply gives "$" and "-$" as…
B. Clay Shannon
  • 1,055
  • 124
  • 399
  • 759
3
votes
1 answer

Storing (Sub)Journals and (Sub)Ledgers in DB for accounting app

Among many different implementations of accounting apps there are 2 main approaches to db design when it comes to keeping Journal & Ledger data. Keep Journal information only & then Ledger is just a view on Journal (as journal always keeps more…
dee zg
  • 10,582
  • 7
  • 33
  • 59
3
votes
2 answers

Exact Online import GLTransactions with automatic reconciliation

I am using our query tool to generate XML files for the topic GLTransactions of the XML API of Exact Online. The input for these files are XML Audit Files coming from Twinfield (XAF 3.1 format). Since Exact Online has a mixed ledger and lots of…
Guido Leenders
  • 4,110
  • 1
  • 19
  • 41
1 2
3
…
21 22