How would you calculate the fiscal year from a date field in a view in SQL Server?

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 sa...

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 ha...

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 ...

Assume there is a system with Double-Entry accounting: https://mcmap.net/q/219624/-relational-data-model-for-double-entry-accounting https://mcmap.net/q/219883/-how-to-design-a-relational-model-f...

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...

My reputation is not enough to comment on this post: Relational Data Model for Double-Entry Accounting For the data model from the linked question, can anyone explain the calculation for the...

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 whi...

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 ...

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 a...

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 doi...

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 | typ...

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 coun...

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.)?...

I have two tables, one for incoming inventory and one for outgoing inventory that look more or less like this: purchase (incoming) --------------+----------+-------+----------- inventory_id | qu...

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.0...

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 2012Q4. ftp://ftp.sec.gov/edgar/data/1001288/0001001288-12-0000...

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 ......

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 deci...

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 ve...

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 a...

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...

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 ...

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 N...

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 me...