| Pages: 1 2 3 4 :: [one page] |
|
|
| Author |
Reply to Topic | Show CCP posts - 0 post(s) |

Hexxx
Minmatar
 |
Posted - 2009.10.26 17:28:00 -
[1] - Quote
Challenge:
Lack of mature accounting tools for business owners who engage in manufacturing/trade and their auditors.
Solution:
A solution which automatically stores the most up-to-date API data and processes this data in a way that provides information (individual cost of manufactured items) and knowledge (what is my profit/costs for a given month). Likewise, tracking first in and first out (FIFO) allows not just for assigning specific costs to individual manufactured items but the profits for trading any given item. Doing so is a superior solution to simple cost averaging (though cost averaging remains a useful tool) for accounting for cash flows and balance sheets.
Supplemental: Reconciling on a daily basis allows for reconciling direct trades and pulls from Corporate hangers. By aggregating numerous accounting for each character into a single corporate account, multiple characters can provide inputs into a single automatic and near real-time business report.
Notes:
Technical requirements are high due to the not insignificant need to design some complex algorithms around the reconciliations. Manufactured cost is actually pretty simple since manufactured items and associated costs can be maintained in a separate table and then simply reconciled against transaction logs.
Why Hexxx, Why?!?!
I am attempting to provide a solution for my greatest failure. I am already coding this, but many of the reconciliation algorithms are not yet designed. These remain a great challenge to me but ones I believe I will eventually overcome. I submit this now to gain feedback from the public. Much of the code stems from my Insurance project and how to deal with API data there and my thinking on how to restrict API data in whole or mask it in parts. There is much that can be done to facilitate and assist in the task of auditing...I am trying to address that.
|

Claire Voyant
 |
Posted - 2009.10.26 17:42:00 -
[2] - Quote
Isn't FIFO kind of archaic? Does it make sense to say the profit on an item is based on materials purchased maybe months ago, instead of comparing current sales price against current material cost on the market. Then you also track you inventory (both materials and finished goods) against market value and try to manage the market risk of your inventory. Either by keeping inventory as low as possible, or by "hedging" by buying inventory when prices are low and not buying when prices are high. Anyway, that is what I would do if I could be bothered.
|

Hexxx
Minmatar
 |
Posted - 2009.10.26 17:51:00 -
[3] - Quote
Originally by: Claire Voyant Isn't FIFO kind of archaic? Does it make sense to say the profit on an item is based on materials purchased maybe months ago, instead of comparing current sales price against current material cost on the market. Then you also track you inventory (both materials and finished goods) against market value and try to manage the market risk of your inventory. Either by keeping inventory as low as possible, or by "hedging" by buying inventory when prices are low and not buying when prices are high. Anyway, that is what I would do if I could be bothered.
Operationally speaking, it does make sense to track current mineral valuation and current market valuation of finished products....however, from an accounting perspective, how do you account for the adjusted cost of what you build from the materials you purchased months ago?
This is more about accounting and reporting profits than it is about managing the operations of a business (which I think you were addressing above).
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.26 17:55:00 -
[4] - Quote
Hexxx and I talked about this, while Hexxx is looking at it from an accounting and consolidation point of view, I was looking at it from a "user" point of view. With my first hand experience of running a slightly complex large manufactures operation I had similar thoughts a while ago.
The issue at hand is inventory vs market value and how to account for that when calculating profits. If you persistently use averages you'll notice it works well for raw materials on the rise in price, but it starts to get ugly when materials drop in price.
FIFO Hexxx mentioned actually solves this issue, as mineral get consumed the cost of the minerals adjusts to real pricing rather then averages. This gives you a much better handle on how much something cost. While averages are OK for smaller or small number of items produces, it doesn't work really well for large bulk mass item production when you have large inventories of the materials needed.
An example of this would Shuttles.
You purchase enough Trit to manufacture 10,000 shuttles. But you only produce 5,000 of them, sell them, then purchase enough minerals to make another 5,000 shuttles while you are producing and selling the second batch of 5,000.
The Trit price has changed, gone down. Working on averages the trit average when you calculate the cost also went down. If the average went down low enough, the second lot of 5,000 Shuttles would actually be sold at a loss, even though according to the average you made a profit. With what Hexxx is thinking about, is account method the would report real time consumption and cost of those materials consumed.
Like I said for smaller businesses this is not a real major concern, but when you run multi-hundred billion ISK worth of production lines the "Average" can work against you.
 Amarr for Life |

Chi'kote
Serenity Ascension
 |
Posted - 2009.10.26 20:32:00 -
[5] - Quote
Technically, I don't think you're looking for textbook FIFO, but specific identification. Ex/
You built 3 harbingers in this order: 1 for 30 mill in jita, 1 for 32 mill in amarr, and 1 for 34 mill in rens. You first sell the one in Amarr. FIFO would assign the cost of the harbinger built in Jita (first in) to the one sold in amarr (first out). If you want to apply the 32 mill build cost for that specific ship built and sold in amarr (second in, first out), that is specific identification.
And no FIFO is not archaic. FIFO, LIFO, and specific identification are all common. SI isn't really even practical yet in most applications.
|

Chingyz
Caldari untaught Blade.
 |
Posted - 2009.10.26 20:43:00 -
[6] - Quote
If your program is going to be used by auditors then you are looking at a bigger problem then just the pros and cons of FIFO versus average (or any of the other types of valuation). For finding profit of historic transactions then it really doesn't matter that much which type of valuation you use (although there are more benefits to FIFO). The problem lies in the valuation of your assets. When it comes to assets like stock of finished goods or raw materials it's often better to use current prices for valuation rather than FIFO. This is due to the nature of assets, which is to show what they are worth at the end of the historic period
The best way to get around this is to have several layers/pages in your program. Use one for profit calculations, based on the FIFO principle. One for assets based on current prices. This can also be used as a tool for setting sale price of your items.
|

Claire Voyant
 |
Posted - 2009.10.26 20:58:00 -
[7] - Quote
If you are build real-word things like automobiles, FIFO makes sense. You contract with a company to make parts for your car, the parts are only for a limited number of car models, and you can't scrap them for anywhere near what you paid for them. Also the production chain from raw materials to finished goods has many more steps than in eve.
What I'm suggesting is something like the "mark to market" accounting rules for financial companies. For my business, I could take the inventory of all my raw materials, components, and finished products and calculate their value according to the current prices of 7 minerals. Seems a lot simpler to me.
It's a little more complicated for tech2 production, and named items would be another matter altogether.
|

Hexxx
Minmatar
 |
Posted - 2009.10.26 21:01:00 -
[8] - Quote
Originally by: Chingyz If your program is going to be used by auditors then you are looking at a bigger problem then just the pros and cons of FIFO versus average (or any of the other types of valuation). For finding profit of historic transactions then it really doesn't matter that much which type of valuation you use (although there are more benefits to FIFO). The problem lies in the valuation of your assets. When it comes to assets like stock of finished goods or raw materials it's often better to use current prices for valuation rather than FIFO. This is due to the nature of assets, which is to show what they are worth at the end of the historic period
The best way to get around this is to have several layers/pages in your program. Use one for profit calculations, based on the FIFO principle. One for assets based on current prices. This can also be used as a tool for setting sale price of your items.
I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.26 21:28:00 -
[9] - Quote
Originally by: Chingyz The best way to get around this is to have several layers/pages in your program. Use one for profit calculations, based on the FIFO principle. One for assets based on current prices. This can also be used as a tool for setting sale price of your items.
I believe Chingyz has raised the correct question. If you're just creating an accounting package to tie out all the numbers, FIFO makes complete sense.
If you're trying to provide information related to current valuation of the operation's assets, then you'll want to record current value and show that value on a separate set of reports.
I've been toying with the same idea, an acctng package for mfg/trade - the concept I came up with would record the API information (Transactions and Journal Entries) in their own table, then link each API transaction and journal entry to entries in a second set of tables that would handle the GL Journal, AR/AP Journals and the Inventory system. This way I can handle all the logic and records in the accounting tables, including posting correcting entries.
The downside of this for the auditors, is that the accounting information is a step removed from the API data. However, by using the book value for all assets, the auditor should be able to tie out the operation's assets between the financials and the API. Also, there should be reports/features that allow the auditor to inspect that individual book transactions are linked to existing API transactions and such.
-----------------------------------------------
- Who Dares, Wins
|

Claire Voyant
 |
Posted - 2009.10.26 21:35:00 -
[10] - Quote
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
Very difficult to do because the numbers on the two statements need to agree. You would probably need some inventory adjustment on the income statement to account for market changes, but that would make your whole FIFO valuation moot.
|
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.26 21:52:00 -
[11] - Quote
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
Clair Voyant beat me to the post 
In that case, you'll want to place a separate line just before your total net profit/loss, stating a profit/loss from mark-to-market (or whatever the correct term is). This way your income statement and balance sheet will match up, and you've accurately called out where the profits came from. This would be especially useful if you're playing the minerals market (stocking up when minerals are low, etc).
This could be difficult to calculate (totalling all the differences between your assets' market- and book-value) or easy (calculate the net profit/loss from the balance sheet, and use the difference between that and the actual profit/loss on the income statement).
Your auditor will probably be most happy with a solid inventory report - regardless of what the current value of the assets, the auditor should be able to confirm your inventory. -----------------------------------------------
- Who Dares, Wins
|

Varo Jan
Minmatar
 |
Posted - 2009.10.26 21:54:00 -
[12] - Quote
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
No, no! You can&t use one valuation method for one side of the balance sheet and another for the other side! 
Not if your intention is to provide a "mature" accounting tool, one in accordance with even the simplest accounting standards.
|

Dzil
Caldari Sausage Banking
 |
Posted - 2009.10.26 21:54:00 -
[13] - Quote
Originally by: Claire Voyant
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
Very difficult to do because the numbers on the two statements need to agree. You would probably need some inventory adjustment on the income statement to account for market changes, but that would make your whole FIFO valuation moot.
If I understand correctly, the point is to be better able to itemize your profits and losses. Thus being able to show that your manufacturing arm of the business still successfully generated X profit, but the businesss as a whole suffered a net loss of Y due to the devaluation of inventory that it's holding. This is useful when you have different folks leading different divisions and want to pay them for their performance, or just for self evaluation as you look for opportunities to improve your own overall money making operations.
 Dzil's Corp Sales - 200m |

Don Caetano
 |
Posted - 2009.10.26 21:59:00 -
[14] - Quote
I gave some hard thought to the subject recently (when I was setting up my manufacturing profit database) and what I was actually looking for was not FIFO but LIFO accounting, as I am more interested in accurate representation of current P/L than balance sheet. After some more hard thought on how it could be acheived (and how much time it would take) I settled on averaging as an acceptable compromise.
|

Varo Jan
Minmatar
 |
Posted - 2009.10.26 22:15:00 -
[15] - Quote
Quote: Tracking first in and first out (FIFO) allows not just for assigning specific costs to individual manufactured items but the profits for trading any given item.
You&re assuming all items are purchased from the market. How do you intend to value minerals obtained by mining, ore refining or module reprocessing? And how would you value modules acquired on missions or by PvP?
Quote: Doing so is a superior solution to simple cost averaging (though cost averaging remains a useful tool) for accounting for cash flows and balance sheets.
No, not so. That&s just a personal opinion. Both FIFO and average costing are acceptable in accounting. I prefer average costing in this specific case (minerals), but again that&s my personal opinion. However, if you intend to develop an application, I&d suggest you allow the user to decide which method he wishes to employ.
Quote: Reconciling on a daily basis allows for reconciling direct trades and pulls from Corporate hangers.
Is this information available from the API?
Quote: Multiple characters can provide inputs into a single automatic and near real-time business report.
Nice idea, but is it really, really necessary to aim for real-time reporting?
Quote: Manufactured cost is actually pretty simple since manufactured items and associated costs can be maintained in a separate table and then simply reconciled against transaction logs.
It is simple providing you assume all characters have Production Efficiency V, and all manufacturing is carried out at an NPC station at a standard rate including the good standings discount.
It is not so simple if carried out at a POS, unless you apply a standard rate. You&re then faced with the issue of reconciling POS running costs.
I don&t know anything about T2 production, but I&m guessing that&s not simple.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.26 22:19:00 -
[16] - Quote
How we do it here in Canada at least makes it relatively simple - which it really is once you sort it out on paper.
The value of the assets you have manufactured should always come down to exactly how much it really cost you to make said item. (i.e. materials, labor and other associated costs) The manufactured items remain in your inventory as assets on the balance sheet until they are sold which then affects both the balance sheet and income statement.
Not sure if this helps the discussion at all but there it is.
The FIFO method I agree is the one that should be used anyways. I mean does not everyone use this method anyways? When would averaging Costs of Goods Sold ever benefit any kind of analysis?
I mean, an asset line for say Tritanium in any companies balance sheet may have one value, but that is typically a consolidated value which represents a bunch of different amounts of tritanium listed at the price they were purchased at. Or in another example, if said tritanium was actually physically harvested then that trit should be valued at what you would get for selling that same amount of trit (how you average that figure is really up to each company and how they want to set that value)
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.26 22:21:00 -
[17] - Quote
Regarding the FIFO calculation, I've seen this handled before by using an Inventory Transaction Log. Every input and every output from inventory is added to the transaction log, with a datestamp. Every input includes the per item cost it was purchased/booked at. Much like any other account ledger, initial entries are made for starting inventory counts, along with their book value.
The transaction log can then be used for calculating the FIFO amounts.
-----------------------------------------------
- Who Dares, Wins
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.26 22:22:00 -
[18] - Quote
Originally by: Don Caetano I gave some hard thought to the subject recently (when I was setting up my manufacturing profit database) and what I was actually looking for was not FIFO but LIFO accounting, as I am more interested in accurate representation of current P/L than balance sheet. After some more hard thought on how it could be acheived (and how much time it would take) I settled on averaging as an acceptable compromise.
That is what got me about 5 months ago, if I had put the time and effort into it, I would have considered using my own take on the ideas of both. CIFO Cheapest In First Out. This would have allowed for a much higher margin of return. By my desire to create this was simply replaced with my laziness, and I went with averages.
Originally by: Claire Voyant What I'm suggesting is something like the "mark to market" accounting rules for financial companies. For my business, I could take the inventory of all my raw materials, components, and finished products and calculate their value according to the current prices of 7 minerals. Seems a lot simpler to me.
That would work for current valuation of the product as a check, for something like a Titan this would be different. By the time the Titan came out of Production the price of minerals would have changed enough to significantly impact the cost. You could either be turned a larger profit or a smaller one depending on when you purchased the materials. Cost needs to be collected before production, not after.
FIFO on Income and Market valuation on Balance, No I don't agree. Balance sheet would need to be FIFO as well, but assets would be considered market valuation, maybe as some sort of passive growth. Say you have 100mil units of trit which you purchased for 2ISK each, and it's now worth 2.1 ISK each. You'd show 10mil in asset growth, which on the balance sheet would be it's own line entry. Each month this could be up or down. However it doesn't effect FIFO as it's asset value is being captured on it's own record.
 Amarr for Life |

Krathos Morpheus
Gallente Legion Infernal ALPHA-0MEGA
 |
Posted - 2009.10.26 22:22:00 -
[19] - Quote
One issue that comes to my mind is what happens when you buy minerals, make different items and some of them sold and you make more of them while the others are unsold. Do you plan to track items as you make them until you sold them or do you plan to "discount" the minerals from the items you sell?
I thought about this FIFO (without that name) when thinking about the program I'd like to see/make (I lack the language knowledge to do it atm unfortunately, although I know the design and I know how to do it with logic and maths). But that was for trading purposes. If I had to do it for manufacturing I would match the manufactured items with the last unusued minerals bought at the time of manufacturing, putting that minerals out of the recorded pool and keeping the first ones as trade assets wich go out of the pool when they are sold directly. There is no point looking an item profit whith old mineral prices, because profit or lose on it is done through time, not manufacturing alone.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.26 22:44:00 -
[20] - Quote
Originally by: SencneS FIFO on Income and Market valuation on Balance, No I don't agree. Balance sheet would need to be FIFO as well, but assets would be considered market valuation, maybe as some sort of passive growth. Say you have 100mil units of trit which you purchased for 2ISK each, and it's now worth 2.1 ISK each. You'd show 10mil in asset growth, which on the balance sheet would be it's own line entry. Each month this could be up or down. However it doesn't effect FIFO as it's asset value is being captured on it's own record.
Asset "appreciation" (asset growth as you called it) does not make it on the balance sheet in its own line. On the balance sheet that becomes Gross Profit and valued against the Cost of Goods Sold line of the assets of your Balance Sheet.
The only time an assets market value is being considered is when said company is disposing of that asset (or i.e. selling said asset) is looking to sell shares of said company or selling the entire company or operation.
|
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.26 23:14:00 -
[21] - Quote
Edited by: SencneS on 26/10/2009 23:15:36
Originally by: Prodigal Asset "appreciation" (asset growth as you called it) does not make it on the balance sheet in its own line. On the balance sheet that becomes Gross Profit and valued against the Cost of Goods Sold line of the assets of your Balance Sheet.
The only time an assets market value is being considered is when said company is disposing of that asset (or i.e. selling said asset) is looking to sell shares of said company or selling the entire company or operation.
In real life this is acceptable, however in EVE, you never really "Dispose" of an asset. Sure you can, but why would you, you'd sell it for whatever you can get for it. Since items don't expire, appreciation and depreciation should be accounted for when running an audit. Although I can see it being used in "Gross Profit" I think it's a little dangerous in there, because unrealized gain or loss. You really shouldn't report it month after month in profits or losses for that matter.
Imagine you buy something for 100mil and it's value goes up to say 110mil and you don't move it for 3 months. It stays at 110mil for those three months, in which you finally sell it for 110mil. However, each month your profits would report 10mil profit for that month, over say 3 months it would appear you have 30mil Profit. An auditor or an investor would expect that profit to be those three months of Gross Profit ie 30MIL, which in this case it's not, it's just 10mil.
edit:- lol sorry I had a brain fart, you wouldn't report it 10mil per month LOL Just 10mil on the first month and 0 as it's value hasn't gone up any more. duh, been a long day. 
 Amarr for Life |

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.27 00:01:00 -
[22] - Quote
Edited by: Drab Cane on 27/10/2009 00:04:39 Can someone explain again why it would be advantageous (sp?) to show the assets at market value on the balance sheet?
In a period of rising mineral prices (and savvy purchasing), the book value of raw materials would be undervalued, and therefore so would the NAV. But is that a bad thing? Based on book value, the NAV would be more accurate, and so would the Return on Equity (ROE). In fact, the ROE would look slightly better when based on book value.
Edit: I think Sencnes has a valid point regarding the mark-to-market causing an unrealized gain/loss. Financial markets are one thing, but manufacturing/retail is not the same. -----------------------------------------------
- Who Dares, Wins
|

Akita T
Caldari Caldari Navy Volunteer Task Force
 |
Posted - 2009.10.27 00:07:00 -
[23] - Quote
In an inflation scenario (material prices go up), the FIFO inventory method undervalues your liabilities ("used up" stocks) and overvalues your remaining stock while the LIFO method (depending on how you look at it) either overvalues or perfectly estimates liabilities while possibly undervaluing remaining stock. In this case, FIFO lets you "claim" lower costs and higher profits early, drastically reducing future reportable profits if the inflation ceases or you try to liquidate the stocks ; conversely, LIFO more or less accurately reports current costs but can only claim lower profits, however in case the inflation ceases or you liquidate your stock your future reportable profits will actually go up.
In a deflation scenario (material prices go down), the FIFO inventory method overvalues your liabilities ("used up" stocks) and undervalues your remaining stock while the LIFO method (depending on how you look at it) either undervalues or perfectly estimates liabilities while possibly overvaluing remaining stock. In this case, LIFO more or less accurately reports current costs and can "claim" lower costs and higher profits early, but ignores older, more expensive stocks and therefore it drastically reduces reportable profits if the deflation ceases or you are trying to liquidate the stocks ; conversely, FIFO more or less accurately reports historic costs but claims lower profits, however in case the deflation ceases or you try to liquidate the stocks your future reportable profits will actually go up.
Obviously, your total profits in either case are exactly the same, it's only a matter of when you prefer them to be reported (and on whether you are planning to liquidate stocks or not). If there's no material price movement, both FIFO and LIFO methods perfectly evaluate your stock's value, as there's absolutely no difference in the calculations.
Obviously, the moving and/or weighted average methods fall somewhere in-between FIFO and LIFO, so, for all intents and purposes, it's a much more accurate (and "honest") depiction of inventory/stock/liabilities values.
_
We are recruiting | Beginer's ISK making guide | Manufacturer's helper |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.27 01:46:00 -
[24] - Quote
Ok, I could never be an accountant. Not that the math is hard, but keeping a straight face would be. Accounting isn't really math, it is literature. Fiction, actually. Historical fiction or speculative fiction. Usually both.
We do accounting not because it is useful to us, but because it satisfies outside parties. Governments, for example, mandate accounting standards either directly or through tax laws. That clearly does not apply in EVE. Additionally, if we carry debt, or if we desire to acquire debt, our creditors may require accounting statements.
So, what accounting methods do your creditors require? If they are clever, they should insist on your current ISK balance and your instant liquidation value. Anything else is an opportunity for deception. And not necessarily malicious either. The worst deceptions come from honest people. If someone is totally open and transparent, it is really easy for both of you to miss the structural problems. (Wanna buy a house? Maybe some credit default swaps?)
FIFO makes it really easy to hide today's mistakes because all data is, by definition, yesterday's data. And not just one yesterday either, a bunch of different yesterdays all rolled into one. It also, as someone else pointed out, makes your company look freaking awesome during inflation (which may or may not exist in EVE).
LIFO isn't any better. It lets you hide today's mistake for as long as you care to. Buy some trit for 3 million ISK each? Not a problem, just buy some more at the regular price and never dip deeply enough into your stockpile to dredge up that old purchase. Oh, and since it is the mirror version of FIFO, if there is any deflation in EVE, someone pointed out that it'll make everything look better.
I could go on and on. There are problems with other methods, and there are problems with timing of profits and losses, and there are problems with every possible option for every possible aspect of your accounting procedure. It really is a field where there are no right answers. Hell, there aren't even any right questions.
Keep in mind that beyond simple common sense, I am supremely unqualified to have any opinions on accounting. I have no formal education in the field. On the other hand, I have a lot of conversations with the people responsible for the accounting and finance of a local county government, and my roommate is an accountant that rips apart contract accounting statements looking for choices that were made in one party's favor (some honest, some less than honest), then applies them in the other party's favor, and bills for the difference. |

Varo Jan
Minmatar
 |
Posted - 2009.10.27 02:42:00 -
[25] - Quote
Originally by: SencneS Imagine you buy something for 100mil and it's value goes up to say 110mil and you don't move it for 3 months. It stays at 110mil for those three months, in which you finally sell it for 110mil. However, each month your profits would report 10mil profit for that month, over say 3 months it would appear you have 30mil Profit. An auditor or an investor would expect that profit to be those three months of Gross Profit ie 30MIL, which in this case it's not, it's just 10mil.
edit:- lol sorry I had a brain fart, you wouldn't report it 10mil per month LOL Just 10mil on the first month and 0 as it's value hasn't gone up any more. duh, been a long day. 
edit#2:- I still don't like it in Gross Profit though.. If you account for asset appreciation of materials in one month, then you use those materials the following month you'll have to remove the "Profit" the following month as now you're using those materials which will also have realized profits when the produced item sells.
Some simple, basic, fundamental accounting principles: 1. Stock is valued at the lower of cost or net realisable value. 2. Profit is only taken on sale.
So in your example, the stock you purchased at 300m sits in the balance sheet for three months at 300m. It does not get revalued to 310m, no profit is shown as it hasn&t been sold. The other side is a reduction in cash of 300m. Both stock and cash are classified as current assets.
When it is eventually sold for 310m, stock is reduced by 300m, cost of goods sold is 300m, sale is 310m, gross profit is 10m. Cash increases by 310m.
|

Dzil
Caldari Sausage Banking
 |
Posted - 2009.10.27 02:56:00 -
[26] - Quote
Originally by: SencneS Edited by: SencneS on 26/10/2009 23:20:10 Edited by: SencneS on 26/10/2009 23:15:36
Originally by: Prodigal Asset "appreciation" (asset growth as you called it) does not make it on the balance sheet in its own line. On the balance sheet that becomes Gross Profit and valued against the Cost of Goods Sold line of the assets of your Balance Sheet.
The only time an assets market value is being considered is when said company is disposing of that asset (or i.e. selling said asset) is looking to sell shares of said company or selling the entire company or operation.
In real life this is acceptable, however in EVE, you never really "Dispose" of an asset. Sure you can, but why would you, you'd sell it for whatever you can get for it. Since items don't expire, appreciation and depreciation should be accounted for when running an audit. Although I can see it being used in "Gross Profit" I think it's a little dangerous in there, because unrealized gain or loss. You really shouldn't report it month after month in profits or losses for that matter.
Heh. Ebank staff's lack of understanding regarding accounting practices shows it ugly colors. And you even quoted prodigal explaining what dispose/disposition means in accounting.
Its tricky business all the way around. Suppose you have a shareholder agreement to increase NAV by 10B in a given year. Now, if you only count NAV changes when you dispose of the inventory, it could mean rushing inventory out the door to prematurely spike the NAV. But to trace the change in value of your investory constantly is a nightmarish accounting task.
 Dzil's Corp Sales - 200m |

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.27 04:03:00 -
[27] - Quote
Wyehr, its a shame you've only seen the 'external' side of accounting. Yes, the tax laws and public securities laws place many requirements on how things are handled. Yes, it was the need for audited financial for public corporations that really spurred the accounting profession. Yes, the math involved in accounting is relatively simple - its mostly about where to put the numbers. And yes, the numbers can (and often are) manipulated. And fund accounting (used by government and non-profits) is a really strange world.
That said, accounting is very important for internal use. Owners and managers need to know where the money is going, where the money is coming from, what's selling, what's not, what expenses are getting out of control, what trends are appearing, how much reserve cash (or line of credit) is necessary to make it through the lean months, etc, etc, and so forth.
A successful operation can (and sometimes will) relax their recordkeeping and still turn a profit. But if the managers go too long without watching their numbers, expenses creep up, revenues creep downward, and suddenly there's no profit, no reserves, and eventually no business.
I believe this is why Hexx is trying to automate a true accounting system, so his operations have a solid system of reporting and tracking for the managers running the operations. And so the auditors can make sense of it all.
And yeah, I'm guilty of having a background in accounting. :) -----------------------------------------------
- Who Dares, Wins
|

Towaoc
Caldari Applied Technologies Inc
 |
Posted - 2009.10.27 04:41:00 -
[28] - Quote
We've had reasonable success utilizing a standard cost system - essentially an enhanced cost averaging system - for accounting for our manufacturing operations. All purchased materials are applied to work in process at predetermined standard costs. Finished goods coming out of production have a standard cost, which simplifies the task of accounting for inventory and gross margins, particularly when a wide range of goods are being distributed to multiple sales locations.
To ensure a high degree of accuracy, standard costs are set and adjusted frequently - typically concurrent with the preparation of weekly financial statements. Standards are set with some "head room" for the purchasers, usually near the midpoint between the bid and asked price of the purchased material, with consideration given to the general price trend of the material. A purchase price variance - the difference between the actual price paid and the standard cost - is recorded at the point of each purchase and accumulated into a running total. The total variance is accounted for as an adjustment to earnings when the financial statements are prepared.
Adjustments to standard costs result in inventory revaluations which must also be accounted for as an adjustment to earnings.
What about these variances - how accurate is this system? Using our financial results as an example, the year to date purchase price variance and inventory revaluation gain/(loss) combined is less than 1% of sales.
Properly managed, a standard cost accounting system can be accurate, reliable and relatively simple to use.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 05:37:00 -
[29] - Quote
Originally by: SencneS In real life this is acceptable, however in EVE, you never really "Dispose" of an asset.
People dispose of assets all the time. When you sell an asset (i.e. inventory) then you are disposing of it. Most folks just call it a sale but it is still technically disposing of the asset.
Originally by: SencneS Imagine you buy something for 100mil and it's value goes up to say 110mil and you don't move it for 3 months. It stays at 110mil for those three months, in which you finally sell it for 110mil. However, each month your profits would report 10mil profit for that month, over say 3 months it would appear you have 30mil Profit. An auditor or an investor would expect that profit to be those three months of Gross Profit ie 30MIL, which in this case it's not, it's just 10mil.
edit:- lol sorry I had a brain fart, you wouldn't report it 10mil per month LOL Just 10mil on the first month and 0 as it's value hasn't gone up any more. duh, been a long day. 
edit#2:- I still don't like it in Gross Profit though.. If you account for asset appreciation of materials in one month, then you use those materials the following month you'll have to remove the "Profit" the following month as now you're using those materials which will also have realized profits when the produced item sells.
This it totally wrong. This is the kind of accounting that Enron was doing (an oversimplification of the example but still valid non-the-less). It is the kind of accounting that caused the whole damn real estate bubble in North America which is still causing the rest of the world grief.
You cannot account for the "market" value of an asset in your statements. That market value is only relevant at the time you have disposed of said asset.
The math in this is pretty straightforward....
You have an inventory item which is worth 100M because either it cost you that much to make it or you bought it from someone else.
You now have an asset worth 100M.
When you dispose of the asset (i.e sell it) for 110M which is the current market value (i.e. current market value because someone was willing to pony up 110M for it) your reduce your inventory (asset) by 100M and increase your Gross Sales by 110M.
The Cost of Sales of that transaction was 100M which leaves you with a Net Profit of 10M.
This is essentially what you referred to as "asset appreciation" but you cannot record it as such UNTIL the sale has been made. And the transaction leaves you with net profit not "asset appreciation".
|

Mahke
Aeon Of Strife
 |
Posted - 2009.10.27 05:59:00 -
[30] - Quote
While FIFO seems like it would make sense to a manufacturer, as a trader LIFO makes a lot more sense (and all actual decisions are of course based on mark to market).
|
|

Freya Lorell
 |
Posted - 2009.10.27 10:19:00 -
[31] - Quote
When I first started my manufacturing bussiness I also attempted to do exact tracking based on FIFO. I stumbled upon some difficulties assigning the correct taxes to sold products. It had to do with timestamps not matching between the journal and the transaction log, if memory servers me correct. Unfortunately I did not have the time back then to get it to work properly, so now I just use an Excel sheet and overvalue my minerals to ensure I'm not selling at a loss.
I'm however still interested in such a tool and will definately want to use it when it is available. |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.27 11:33:00 -
[32] - Quote
Originally by: Prodigal You have an inventory item which is worth 100M because either it cost you that much to make it or you bought it from someone else.
You now have an asset worth 100M.
When you dispose of the asset (i.e sell it) for 110M which is the current market value (i.e. current market value because someone was willing to pony up 110M for it) your reduce your inventory (asset) by 100M and increase your Gross Sales by 110M.
The Cost of Sales of that transaction was 100M which leaves you with a Net Profit of 10M.
This is essentially what you referred to as "asset appreciation" but you cannot record it as such UNTIL the sale has been made. And the transaction leaves you with net profit not "asset appreciation".
I'm sorry, but this is totally wrong too. Thank you for demonstrating my point. :)
Your asset has no value until after you sell it. Until that point, the best you can do is estimate how much you might be able to sell it for. And your estimate necessarily depends on a bunch of assumptions that may or may not be true. |

Hoodat Bee
 |
Posted - 2009.10.27 13:19:00 -
[33] - Quote
I'd like to start with the part you got right in all this gobbledy ****.
Originally by: Wyehr I am supremely unqualified to have any opinions on accounting.
Onward and upward.
Originally by: Wyehr
We do accounting not because it is useful to us, but because it satisfies outside parties. Governments, for example, mandate accounting standards either directly or through tax laws. That clearly does not apply in EVE. Additionally, if we carry debt, or if we desire to acquire debt, our creditors may require accounting statements.
Incorrect. You cannot have any opinion whatsoever about your business without proper accounting. The further management moves from simply having an opinion to actually implementing policy, the more necessary accounting becomes. Unless you think it's possible to find cost savings without knowing your costs.
The rest of your post was so rage inducing-ly stupid that I simply won't be commenting on it, as I value my internal organs and I'd prefer not to have them explode from the angar.
|

Mme Pinkerton
Caldari
 |
Posted - 2009.10.27 13:50:00 -
[34] - Quote
Originally by: SencneS Imagine you buy something for 100mil and it's value goes up to say 110mil and you don't move it for 3 months. It stays at 110mil for those three months, in which you finally sell it for 110mil. However, each month your profits would report 10mil profit for that month, over say 3 months it would appear you have 30mil Profit. An auditor or an investor would expect that profit to be those three months of Gross Profit ie 30MIL, which in this case it's not, it's just 10mil.
At least in my country (Germany), you would usually continue to write 100m in your balance sheet - even if the market value of said asset has changed to 110m and only book the profit once the market value has been realized.
If - however - the market price of said asset would go down to 90m you would have to book a 10m depreciation, even if the asset is not sold.
So you can expect every asset to sell at least for the value listed in the balance sheet and don't have to fear nasty surpirises on liquidation (however, your balance sheet does not have to reflect short term fluctuations in the value of assets - would have to look up the exact rules on that).
Yes, we Germans are traditionally very conservative about accounting .
" Credit is the economic judgement on the morality of a man. " |

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 13:54:00 -
[35] - Quote
Edited by: SencneS on 27/10/2009 13:55:24 Dzil - Lucky for EBANK I never dealt with EBANK accounting, didn't handle ISK apart from Teller ISK, It wasn't what I brought on to do, so nana naana na. Besides my failure to read "ie Sell said asset" Disposal to me means literally trash the item. Which I even confirmed that is what I was thinking in my reply. If you read this line which I'm sure you just skimmed over "You really shouldn't report it month after month in profits or losses for that matter." So well done on you to graduating from Failure to Read 101.
Which brings me to the next point NAV. It appears or has been a part of "Monthly" reports in EVE that NAV be calculated for the only reason I can think of is "Share value" for people to gauge the value of the share when buying or selling.
In case no one realized this, what Hexxx is trying to do is create some sort of Automated Audit/Reporting system to allow people to run Cash Flow, Profit, NAV reports on any company that is in the system. NAV reporting must be a part of that, as MD have grown accustom to seeing it in reports. We all know MD/EVE Accounting differs from real life accounting, this is just one of them.
I now believe asset value SHOULD be included in a standard report. Looking back on what people class as "Great reporting" NAV and Share Value has been a part of every monthly report. So before anyone else gets on their high horse with a one credit in basic accounting, make sure you think about what it is in EVE players look for.
If held inventory appreciates that directly effects NAV, so it has to be somewhere, otherwise NAV will be off on the balance sheet. My choice to have it's own line makes the most sense as it could be up or down. The impact the inventory has on the NAV can't be ignored, and if that means adding some "new EVE only" line in the balance sheet then it should be there.
My suggestion is pretty simple solution, Before NAV, have a "Asset Appreciation/Depreciation" Line item.
 Amarr for Life |

Hexxx
Minmatar
 |
Posted - 2009.10.27 14:34:00 -
[36] - Quote
Just to drive a point home that may have been lost...
My intention is to develop an automated (or at the least, 90% automated) auditing tool. I also want to create something which gives the person being audited some measure of control on what actually is audited. If the person being audited wants to mask the location of sales...they have no way to do that.
Increasing the comfort a business owner has with their auditors, and increasing the effectiveness of the auditor by reducing the barriers to a high quality audit is my ultimate goal.
All of this is largely derived from technology I'm working on for my Insurance project which by necessity deals with managing multiple EVE Accounts under a single login. Expanding this base of technology to cover some simple audit functions and adding automated accounting functionality is my goal.
There is alot of technical work that remains but I did want to get some discussions around best practices for accounting in EVE.
|

Varo Jan
Minmatar
 |
Posted - 2009.10.27 14:40:00 -
[37] - Quote
Originally by: SencneS In case no one realized this, what Hexxx is trying to do is create some sort of Automated Audit/Reporting system to allow people to run Cash Flow, Profit, NAV reports on any company that is in the system.
His opening post deals with stock valuation only. That&s a far cry from developing a true accounting system capable of generating cash flow P&L and balance sheet statements. Yes, there isn&t a single application that currently is capable of doing that. Yes, it makes sense to develop an accounting package for EO.
However, Hexxx is not an accountant, and clearly lacks an understanding of what a balance sheet is, for example. Now that need not be an issue providing he sticks to his skillset - coding - and takes a qualified accountant on to specify the system.
Quote: NAV reporting must be a part of that, as MD have grown accustom to seeing it in reports.
Net asset value is simply one side of the balance sheet. However, the term is often used in MD to denote a more or less arbitrary company valuation. I say arbitrary because there is no standard here for reporting NAV.
Quote: We all know MD/EVE Accounting differs from real life accounting, this is just one of them.
Please... don&t go there. Acounting is accounting is accounting. It follows some basic, simple and conservative rules. What passes for accounting here is often an abortion of misunderstood principles inaccurately applied.
Two simple examples. I&ve lost count of the number of people here who confuse cost markup with profit margin. And there are those who don&t understand the difference between cash and profit.
|

Razalea
Caldari CompleXion Industries CompleXion Alliance
 |
Posted - 2009.10.27 14:46:00 -
[38] - Quote
Instead of using FIFO for minerals and basic components, since there is no difference between one unit of trit and another, it would be better to use a weighted average instead of a straight average or FIFO to value the trit that you have in stock for cost in manufacturing. I believe the same principle is used for goods in the real world where they get mixed with older supplies during the course of business, such as oil and natural gas, where the freshly imported fuel gets mixed in the tank with old fuel. Just like stacking the minerals in your hangar, unless you actually keep every single stack separate, in which case yer crazy, imho. FIFO would work best for manufactured items, such as the actual ships.
Let's use an example: shuttles use trit and trit only. Real nice and simple. I'd buy 1M units of trit from the market at 2.9 isk apiece, which gives me a nice stack worth 2.9M isk. Later on, after building 200 shuttles, or using up 0.5M trit (assuming perfect ME on the BPO), I have 1.45M isk of trit left, so i go buy another 1M units, but now the price has dropped to 2.85 isk p/u. Now, the straight average is merely (2.9 + 2.85)/2 = 2.875 isk p/u. The problem is that this doesn't account for the fact that you have twice as much trit at 2.85 than you do at 2.9. Using a weighted average would look like this: ((2.9*500,000)+(2.85*1,000,00))/(500,000+1,000,000) = 2.867 isk p/u, which more accurately reflects the value of your minerals at that point in time. Mark to market imo isn't an actual cost operation, it's a reflection of the opportunity cost of selling the minerals on the market compared to using the minerals to build a ship.
|

Claire Voyant
 |
Posted - 2009.10.27 15:23:00 -
[39] - Quote
Just to be clear, when I suggested "mark to market" I meant just the material cost. I did not mean to value the inventory of finished goods at their market price.
|

Dismantler
 |
Posted - 2009.10.27 15:29:00 -
[40] - Quote
Originally by: Hexxx Just to drive a point home that may have been lost... My intention is to develop an automated (or at the least, 90% automated) auditing tool. ...
Manufacturing tool can also benefit from this.
Back at my manufacturing days, I had to keep a log of the cost for every item/batch of items I've manufactured, so I never sell them at loss.
Because of this, soemtimes I had a lot of inventory laying around, because I was refusing to sell at loss, but at the end I think that I've made a lot more isk, then if I were using average or current material prices.
Best regards, Dismantler |
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 15:30:00 -
[41] - Quote
Originally by: Varo Jan
His opening post deals with stock valuation only.
You may have missed the part where I track stock valuation for the purpose of assigning cost to finished products and in doing so...calculate profit at the time of sale for that finished product. This was in my OP. The valuation of materials was a side bonus to people who engage in trading.
Originally by: Varo Jan
That&s a far cry from developing a true accounting system capable of generating cash flow P&L and balance sheet statements. Yes, there isn&t a single application that currently is capable of doing that. Yes, it makes sense to develop an accounting package for EO.
However, Hexxx is not an accountant, and clearly lacks an understanding of what a balance sheet is, for example. Now that need not be an issue providing he sticks to his skillset - coding - and takes a qualified accountant on to specify the system.
I am not an accountant, but I don't think I'm as off-base as you imply. I can read a balance sheet, tell you what the general terms mean. You can play "stump hexxx with obscure accounting terms" and you'll win...I don't aim to produce an exhaustive replica of the real world. I'm aiming for something:
1) Useful, and by implication, accurate 2) Understandable to owners, investors, and auditors (in EVE)
Originally by: Varo Jan
Quote: NAV reporting must be a part of that, as MD have grown accustom to seeing it in reports.
Net asset value is simply one side of the balance sheet. However, the term is often used in MD to denote a more or less arbitrary company valuation. I say arbitrary because there is no standard here for reporting NAV.
Quote: We all know MD/EVE Accounting differs from real life accounting, this is just one of them.
Please... don&t go there. Acounting is accounting is accounting. It follows some basic, simple and conservative rules. What passes for accounting here is often an abortion of misunderstood principles inaccurately applied.
Two simple examples. I&ve lost count of the number of people here who confuse cost markup with profit margin. And there are those who don&t understand the difference between cash and profit.
I don't think it's so arbitrary when it comes to company valuation...there is a simplified form of fair value accounting at work in producing a NAV report.
Anyway, you've got the criticism thing down...how about working on a solution with the rest of us? I'm not saying what I laid out is the best way, or the way it should be...I'm more than happy to tweak and change things so that the final product produces value for everyone in MD.
|

Varo Jan
Minmatar
 |
Posted - 2009.10.27 16:21:00 -
[42] - Quote
Quote: I am not an accountant, but I don't think I'm as off-base as you imply. I can read a balance sheet
You may have missed my earlier post:
Originally by: Varo Jan
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
No, no! You can&t use one valuation method for one side of the balance sheet and another for the other side! 
Not if your intention is to provide a "mature" accounting tool, one in accordance with even the simplest accounting standards.
Quote: You can play "stump hexxx with obscure accounting terms" and you'll win...I don't aim to produce an exhaustive replica of the real world. I'm aiming for something:
1) Useful, and by implication, accurate 2) Understandable to owners, investors, and auditors (in EVE)
There is no need for obscure accounting terms here. Eve accounting is a very simple subset of normal accounting. The difficulties lie with the API gaps.
Quote: Anyway, you've got the criticism thing down...how about working on a solution with the rest of us?
Tsk, tsk! Tetchy when criticised? Again, you may have missed my earlier posts - plural.
You&re not going to get a solution in an MD thread. You&ll get a lot of uninformed opinions and some informed which will contradict each other (eg the merits of FIFO vs LIFO, average and standard costing).
I&ve already suggested a solution: recruit a qualified accountant to spec the system for you. Then have the system peer reviewed by other qualified accountants here.
You could also avoid reinventing the wheel by adapting an open source accounting package. Have a look at Source Forge, for example.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 16:22:00 -
[43] - Quote
I sorted Hexxx out, to the shock and horror some of you are experiancing when reading "I sorted Hexxx out" 
Unlike the apparent lack of understanding goals and objectives of this thread, with every other poster heavy in criticizing. I enjoy a rather unique perspective of holding enough knowledge to be dangerous and enough stupids to see a non-ground in perspective of accounting.
Everyone needs to think outside their little accounting classes because EVE is not the same as Real life.
A Raven is a Raven is a Raven made up of exactly the same materials in "similar" quantity and when reprocessed results in the same number of minerals being produced because of the reprocessing. The item never expires or gets old or damaged and holding on to either the minerals or the Raven doesn't change or reduce the cost it took to acquire the Raven or the Minerals.
This pretty much negates a good part of real life accounting consideration and brings it down to a really simple math. Cost in and Value out
I realized why the big hangup most have mentioned about asset valuation on the balance sheet. It's cost viewed as a item rather then a cost.
Dumbed down version, if I purchase 100mil of something, and sell 50mil worth of something, I still have 50mil worth of something to sell. Regardless of how much that 50mil worth of something or how much it's sold for, I have 50mil worth of cost to sell, so it should be accounted for as 50mil and nothing else.
Where the hangup was, that 50mil of something could be worth 100mil or could be worth 5mil on the market. While a NAV would show either 50mil gain or 45mil loss because that asset is only worth 100mil or 5mil. However the balance sheet is pure, so it must say, I have 50mil of something to sell. At the time of sale of that 50mil for whatever price, the balance sheet is then back to zero.
Like Hexxx, I believe asset value is important enough for overall corporation health. Trying to include that on the Balance sheet was trying to simplify it enough for normal people without the slightest understanding of accounting practices, to at least understand the corp is worth more then it was last month.
Now that all of that is out of the way, can we get to what else would make a good automated report LOL
 Amarr for Life |

Hexxx
Minmatar
 |
Posted - 2009.10.27 16:40:00 -
[44] - Quote
Originally by: Varo Jan
Quote: Anyway, you've got the criticism thing down...how about working on a solution with the rest of us?
Tsk, tsk! Tetchy when criticised? Again, you may have missed my earlier posts - plural.
You&re not going to get a solution in an MD thread. You&ll get a lot of uninformed opinions and some informed which will contradict each other (eg the merits of FIFO vs LIFO, average and standard costing).
I&ve already suggested a solution: recruit a qualified accountant to spec the system for you. Then have the system peer reviewed by other qualified accountants here.
You could also avoid reinventing the wheel by adapting an open source accounting package. Have a look at Source Forge, for example.
Contact me on MSN then and we can bump heads about how to get this to work. I'm wrestling with the design of how to get this to function appropriately.
dave.carter at gmail dot com
|

Phoebe Halliwel
 |
Posted - 2009.10.27 16:44:00 -
[45] - Quote
Originally by: SencneS
Everyone needs to think outside their little accounting classes because EVE is not the same as Real life.
Dumbed down version, if I purchase 100mil of something, and sell 50mil worth of something, I still have 50mil worth of something to sell. Regardless of how much that 50mil worth of something or how much it's sold for, I have 50mil worth of cost to sell, so it should be accounted for as 50mil and nothing else.
Where the hangup was, that 50mil of something could be worth 100mil or could be worth 5mil on the market. While a NAV would show either 50mil gain or 45mil loss because that asset is only worth 100mil or 5mil. However the balance sheet is pure, so it must say, I have 50mil of something to sell. At the time of sale of that 50mil for whatever price, the balance sheet is then back to zero.
Like Hexxx, I believe asset value is important enough for overall corporation health.
It's not a dumbed down version; it's just dumb and demonstrates your lack of understanding of basic accounting.
3 or 4 different people have explained to you simply that profits are only realised at the point of sale on statutory reports, which the P&L/Balance sheet are. These are governed by global accounting standards. You and Hexx appear to be taking this as a criticism of your point of view, it's not, it's basic accounting. No matter how many times it's explained to you, you apparently aren't going to get it.
If you want to produce share reports that show unrealised profits in stock; fine. Create a separate branch of reports. But don't try to forcibly change/bastardise statutory reporting, as it will invite criticism. Management accounting reports for internal or shareholder use can be created without reference to statutory reports, provided you rationalise and highlight where they are different, and why. You may be quite correct and Eve may require a rather unique set of stock reports. Fair enough, get on with it.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 16:45:00 -
[46] - Quote
Originally by: Wyehr
Originally by: Prodigal You have an inventory item which is worth 100M because either it cost you that much to make it or you bought it from someone else.
You now have an asset worth 100M.
When you dispose of the asset (i.e sell it) for 110M which is the current market value (i.e. current market value because someone was willing to pony up 110M for it) your reduce your inventory (asset) by 100M and increase your Gross Sales by 110M.
The Cost of Sales of that transaction was 100M which leaves you with a Net Profit of 10M.
This is essentially what you referred to as "asset appreciation" but you cannot record it as such UNTIL the sale has been made. And the transaction leaves you with net profit not "asset appreciation".
I'm sorry, but this is totally wrong too. Thank you for demonstrating my point. :)
Your asset has no value until after you sell it. Until that point, the best you can do is estimate how much you might be able to sell it for. And your estimate necessarily depends on a bunch of assumptions that may or may not be true.
 OMG - I will just leave it at that.
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 16:49:00 -
[47] - Quote
Originally by: Phoebe Halliwel
Originally by: SencneS
Everyone needs to think outside their little accounting classes because EVE is not the same as Real life.
Dumbed down version, if I purchase 100mil of something, and sell 50mil worth of something, I still have 50mil worth of something to sell. Regardless of how much that 50mil worth of something or how much it's sold for, I have 50mil worth of cost to sell, so it should be accounted for as 50mil and nothing else.
Where the hangup was, that 50mil of something could be worth 100mil or could be worth 5mil on the market. While a NAV would show either 50mil gain or 45mil loss because that asset is only worth 100mil or 5mil. However the balance sheet is pure, so it must say, I have 50mil of something to sell. At the time of sale of that 50mil for whatever price, the balance sheet is then back to zero.
Like Hexxx, I believe asset value is important enough for overall corporation health.
It's not a dumbed down version; it's just dumb and demonstrates your lack of understanding of basic accounting.
3 or 4 different people have explained to you simply that profits are only realised at the point of sale on statutory reports, which the P&L/Balance sheet are. These are governed by global accounting standards. You and Hexx appear to be taking this as a criticism of your point of view, it's not, it's basic accounting. No matter how many times it's explained to you, you apparently aren't going to get it.
If you want to produce share reports that show unrealised profits in stock; fine. Create a separate branch of reports. But don't try to forcibly change/bastardise statutory reporting, as it will invite criticism. Management accounting reports for internal or shareholder use can be created without reference to statutory reports, provided you rationalise and highlight where they are different, and why. You may be quite correct and Eve may require a rather unique set of stock reports. Fair enough, get on with it.
Phoebe,
I want to create an Income Statement based on FICO, not including fair value of materials (unrealized gains). Now, originally I wanted to include fair value valuations of materials on the balance sheet but this too I realize is incorrect.
Now, MD likes it's NAV reports...I'm not sure how to address that just yet but I do know that I don't want to entirely bastardized years and years of basic accounting principles.
Just wanted to clear that up. I earned some of the criticism but not all of it. I tried to correct where I felt the criticism was warranted.
|

Phoebe Halliwel
 |
Posted - 2009.10.27 16:58:00 -
[48] - Quote
Originally by: Hexxx
Phoebe,
I want to create an Income Statement based on FICO, not including fair value of materials (unrealized gains). Now, originally I wanted to include fair value valuations of materials on the balance sheet but this too I realize is incorrect.
Now, MD likes it's NAV reports...I'm not sure how to address that just yet but I do know that I don't want to entirely bastardized years and years of basic accounting principles.
Just wanted to clear that up. I earned some of the criticism but not all of it. I tried to correct where I felt the criticism was warranted.
Hexx - thanks for the reply. My criticisms aren't directed at you; if you're willing to create a discussion and change how you percieve this should be done, fair play to you. You are quite correct, you are doing more for the community than many others who have the knowledge and tools to do so. You're probably the first person I've seen who's taken the recommendation of getting a qualified accountant's advice on a project like this. It's a massive undertaking IMO to create an accounting package from the ground up, but one that I definitely support and see the need for. I'd be willing to contribute ISK wise to the development, but we need to get away from forum drama queening and move onto a dispassionate discussion about the appropriate standards to apply.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 17:08:00 -
[49] - Quote
Originally by: Phoebe Halliwel 3 or 4 different people have explained to you simply that profits are only realised at the point of sale on statutory reports, which the P&L/Balance sheet are. These are governed by global accounting standards. You and Hexx appear to be taking this as a criticism of your point of view, it's not, it's basic accounting. No matter how many times it's explained to you, you apparently aren't going to get it.
I don't understand why you think I'm saying something different..
In fact what I said in there is exactly what you say right here, where in what I said indicated anything other then keeping the remainder of the 50mil of unsold assets should be recorded as 50mil ONLY...
Did you even READ what I said?
 Amarr for Life |

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 17:13:00 -
[50] - Quote
I for one hope that Hexx can develop this tool as it is in sore need for Corp finances.
Any help that I can provide is being extended and I hope a few more "accountant like" folks would come forward also. If Hexx would have us that is.
I also agree with some of the generalists here that Eve IS NOT like RL and therefore the accounting does not need to be as complicated as it can get in RL (thank "insert deity here" for that!!)
I simply believe and hope that a standard can be developed that will acceptable by all and my sincere hopes that said standard will at least adhere to some basic accounting principles.
From an accountants POV - the current standard set (as Hexx mentions) with the NAV reports are a joke at best (imho) and do not make any sense at all to accountants let alone to the general public or "joe investor" for that matter.
We need this tool more than most of us realise. Once its there things can finally move along as they should.
Cheers,
|
|

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.27 17:25:00 -
[51] - Quote
Originally by: Prodigal
Originally by: Wyehr
Originally by: Prodigal You have an inventory item which is worth 100M because either it cost you that much to make it or you bought it from someone else.
You now have an asset worth 100M.
When you dispose of the asset (i.e sell it) for 110M which is the current market value (i.e. current market value because someone was willing to pony up 110M for it) your reduce your inventory (asset) by 100M and increase your Gross Sales by 110M.
The Cost of Sales of that transaction was 100M which leaves you with a Net Profit of 10M.
This is essentially what you referred to as "asset appreciation" but you cannot record it as such UNTIL the sale has been made. And the transaction leaves you with net profit not "asset appreciation".
I'm sorry, but this is totally wrong too. Thank you for demonstrating my point. :)
Your asset has no value until after you sell it. Until that point, the best you can do is estimate how much you might be able to sell it for. And your estimate necessarily depends on a bunch of assumptions that may or may not be true.
 OMG - I will just leave it at that.
Well, I guess that is sure easier than reading or responding to the post. Let me repeat the first couple of lines:
You have an inventory item. That much can objectively be true.
It may or may not be "worth" 100M. The only way to be sure is to sell it for that much.
If it turns out to have been worth 100M, it sure as hell wasn't "because" you paid that much for it. And if you sell it for 110M, that should make it even more clear that 1) the "value" you had recorded for it was wrong, and 2) the lie you told yourself to explain the value you imagined for it was also wrong.
Back to Hexxx's topic. I think an automated tool is a great idea. Not that I imagine that the reports it generates will be any more honest than the ones done by hand, but by automating the procedure everyone can have the same flaws rather than picking the flaws most favorable to them at the moment.
What he should not do is feel overly constrained by real world conventions. There are no "statutory reports". Those laws do not exist here. There is no advantage in recording a profit or loss at any time more than another. The tax laws and wall street reporting cycles that make this important in real life do not exist here. |

Phoebe Halliwel
 |
Posted - 2009.10.27 18:06:00 -
[52] - Quote
Originally by: SencneS
Did you even READ what I said?
I did; your numbers suggested you agreed, but the final statement contradicted the principle.
Originally by: SencneS
Like Hexxx, I believe asset value is important enough for overall corporation health.
Either way I agree with you in part. For internal or even external reporting you may wish to analyse your stock in more detail. Personally, I think you should do this away from recognisable financial statements and create something bespoke for Eve, that becomes a generally accepted form of reporting. At the moment the NAV is nowhere near that.
Originally by: Wyehr
What he should not do is feel overly constrained by real world conventions. There are no "statutory reports". Those laws do not exist here. There is no advantage in recording a profit or loss at any time more than another. The tax laws and wall street reporting cycles that make this important in real life do not exist here.
Don't agree with this, although its a valid point of view. Even if Eve users are not subject to RL legislation(yet), statutory reports are also bound by Generally Accepted Accounting Principles (GAAP) - not all accountants adhere to these principles because of legislation in their native country. If you look at GAAP you'll see concepts like prudence, materiality and consistency. There is every reason these principles should be considered in Eve reporting as much as in RL, regardless of whether we are legally bound to use them.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 18:27:00 -
[53] - Quote
Edited by: SencneS on 27/10/2009 18:33:43
Originally by: Wyehr What he should not do is feel overly constrained by real world conventions. There are no "statutory reports". Those laws do not exist here. There is no advantage in recording a profit or loss at any time more than another. The tax laws and wall street reporting cycles that make this important in real life do not exist here.
As it's plainly clear a simple question like "Should assets be recorded as cost or value" on a the balance sheet yielded a heap of posts, people from different countries and different point of views, all had similar tones. What's funny is the same argument used in a different case would indicate that "MINED MINERALS ARE FREE".
In a Balance sheet any minerals you had mind could have a "Zero" cost. Mining companies use the costs associated with mining as the "Cost" of the materials they have mined. It also includes depreciated fixed assets. In EVE there is no depreciation of your mining equipment apart from Mining Crystals (If you use them). You also don't have to pay out workers or any other real cost. While the initial cost is there, you could depreciate the value of the equipment as some sort of cost. However, after a while you will have mined out enough to have paid back 100% of the initial cost, or be fully depreciated.
What now? You have this equipment, which doesn't "cost" you anything yet can grow the value of your company to an infinite value over time. You could potentially have an endless supply of raw materials that cost nothing on your balance sheet if you go with what these "accountants" say. This goes against the "Mined minerals should be marked at market value" these same accountants peddle every time someone asks!
Don't get me wrong I'm on the side of using fair value for mined minerals. However it's a classic example of Real Life and EVE Life simply do NOT translate. So why would a Balance sheet need to be 1:1 translation when a 1:1 translation could land you in some SERIOUS trouble in EVE..
Edit:- MIND into MINED
 Amarr for Life |

Chingyz
Caldari untaught Blade.
 |
Posted - 2009.10.27 19:02:00 -
[54] - Quote
Originally by: Varo Jan
Originally by: Hexxx I'd imagine I would use FIFO for the Income statement and then asset valuation on current market prices for the Balance Sheet.
No, no! You can&t use one valuation method for one side of the balance sheet and another for the other side!  Not if your intention is to provide a "mature" accounting tool, one in accordance with even the simplest accounting standards.
English is not my first language so bear with me on this.
It is not only possible to use different valuation for your income statement and your balance sheet, it is actually in some ways recommended that you do it. Take a look at the IAS, which is what most countries in some way is moving towards when it comes to accounting standards.
You use FIFO, LIFO average or whatever for pricing in your income statemnet and then you use most recent market prices in your balance sheet under your assets. The diffrence is then offset under asset depreciation or appreciation.
The difference between the income statement and the balance sheet is that the income statement shows your historic transactions, while the Balance sheet shows the value of your company at the end of your accounting period.
|

Mme Pinkerton
Caldari
 |
Posted - 2009.10.27 19:04:00 -
[55] - Quote
Edited by: Mme Pinkerton on 27/10/2009 19:05:17
Originally by: SencneS Don't get me wrong I'm on the side of using fair value for mined minerals. However it's a classic example of Real Life and EVE Life simply do NOT translate. So why would a Balance sheet need to be 1:1 translation when a 1:1 translation could land you in some SERIOUS trouble in EVE..
but minerals you mine yourself *are* free IRL - let's say I have inherited a piece of land and discover it has a natural spring on it. So, I am going to build a well and bottle the water for selling.
Guess what, the "value" of the actual water will never appear on my balance sheet (only the cost of refining/bottling the water). Not any different from EVE. Yes, even in EVE, ore/minerals you mine yourself are free - only the time you needed to mine/refine them is not.
The only difference is that for statuary purposes you cannot book opportunity costs, while for internal management usage it might be useful to include some kinds of opportunity costs in your "balance" sheet (e.g. if you don't pay yourself a wage, but only pay yourself out of your ventures' profit, you should definetely have a look at your labor's opportunity cost - but that's only for *internal* decision making).
" Credit is the economic judgement on the morality of a man. " |

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 19:21:00 -
[56] - Quote
Originally by: Mme Pinkerton Guess what, the "value" of the actual water will never appear on my balance sheet (only the cost of refining/bottling the water). Not any different from EVE. Yes, even in EVE, ore/minerals you mine yourself are free - only the time you needed to mine/refine them is not.
The only difference is that for statuary purposes you cannot book opportunity costs, while for internal management usage it might be useful to include some kinds of opportunity costs in your "balance" sheet (e.g. if you don't pay yourself a wage, but only pay yourself out of your ventures' profit, you should definetely have a look at your labor's opportunity cost - but that's only for *internal* decision making).
That really didn't address the issue :) However, I have applied bold your statement. From my understanding the costs associated with the refining and bottling of the water IS the cost of the bottled water in inventory. While the water is in the spring it's not in sell able form and you certainly can't claim it as an asset on your balance sheet. Only until it's been extracted from the spring and placed in sell able form can you actually sell it. The costs associated with making it sell able is what is used.
Mind you I don't work for a Mining company I'm going of a few investment sites information about how to read a mining companies balance sheet. Apparently it's vastly different then an average companies balance sheet.
The issue that it didn't solve is how do you account for magical items that appear in inventory with no "Cost" associated with them. Things like Mined minerals, Mission Loot, Exploration rewards, and salvage etc.
 Amarr for Life |

Mme Pinkerton
Caldari
 |
Posted - 2009.10.27 19:42:00 -
[57] - Quote
Edited by: Mme Pinkerton on 27/10/2009 19:43:12 Edited by: Mme Pinkerton on 27/10/2009 19:42:18
Originally by: SencneS The issue that it didn't solve is how do you account for magical items that appear in inventory with no "Cost" associated with them. Things like Mined minerals, Mission Loot, Exploration rewards, and salvage etc.
For statuary accounting, you account for them once you have sold them.
I think what you still have not completely realized is that every serious company IRL uses a number of very different accounting schemes in parallel. There's a reason why there are 3 accounting lectures (general statuary accounting, internal & external accounting, accounting for finance/investment) in my university curriculum - and I am doing economics, not business administration.
For external accounting (and that's what an auditor should confirm) the key idea is to create as much comparability between enterprises as possible (i.e. strict standards) while giving equity holders/investors data they can rely on (say, in case of a chapter 7-like insolvency).
In internal accounting (you would generally not base any business decisions on the balance sheet done for the external world) you can do whatever you deem to be useful - but no analyst or investor is ever going to see these balance sheets. In internal accounting you are more concerned with getting a realistic estimate of the state of your business (not a super-conservative one), e.g. one of my professors suggests that you should include the projected value of your customer-base and your human capital ressources in your internal balance sheets - you could ofc never write these in any officially published balance sheet.
I get the feeling that you think that internal accounting practices should be applied to the balance sheets you are going to publish - that's generally not the case (reasons listed above).
" Credit is the economic judgement on the morality of a man. " |

Hexxx
Minmatar
 |
Posted - 2009.10.27 20:22:00 -
[58] - Quote
Originally by: Mme Pinkerton Edited by: Mme Pinkerton on 27/10/2009 19:43:12 Edited by: Mme Pinkerton on 27/10/2009 19:42:18
Originally by: SencneS The issue that it didn't solve is how do you account for magical items that appear in inventory with no "Cost" associated with them. Things like Mined minerals, Mission Loot, Exploration rewards, and salvage etc.
For statuary accounting, you account for them once you have sold them.
I think what you still have not completely realized is that every serious company IRL uses a number of very different accounting schemes in parallel. There's a reason why there are 3 accounting lectures (general statuary accounting, internal & external accounting, accounting for finance/investment) in my university curriculum - and I am doing economics, not business administration.
For external accounting (and that's what an auditor should confirm) the key idea is to create as much comparability between enterprises as possible (i.e. strict standards) while giving equity holders/investors data they can rely on (say, in case of a chapter 7-like insolvency).
In internal accounting (you would generally not base any business decisions on the balance sheet done for the external world) you can do whatever you deem to be useful - but no analyst or investor is ever going to see these balance sheets. In internal accounting you are more concerned with getting a realistic estimate of the state of your business (not a super-conservative one), e.g. one of my professors suggests that you should include the projected value of your customer-base and your human capital ressources in your internal balance sheets - you could ofc never write these in any officially published balance sheet.
I get the feeling that you think that internal accounting practices should be applied to the balance sheets you are going to publish - that's generally not the case (reasons listed above).
So from the perspective of external accounting, how do we account for items which "magically" appear in inventory with no trace in any API record?
Should these instances be flagged and manual categorization be performed?
|

Phoebe Halliwel
 |
Posted - 2009.10.27 20:26:00 -
[59] - Quote
Originally by: Mme Pinkerton
For statuary accounting, you account for them once you have sold them.
I get the feeling that you think that internal accounting practices should be applied to the balance sheets you are going to publish - that's generally not the case (reasons listed above).
Better said than I could, this was essentially what I was getting at.
In the UK it's financial vs management accounting. Financial accountants produce the stat reports, management produces internal reports that are used to look at specific areas to analyse cost/profit. To be qualified you need to be able to produce both. What's interesting and perhaps relevant is that management accounting evolved from Cost Accounting and is perhaps relevant to this discussion. Large scale businesses do need to report in detail on specific areas that are not covered by stat reports to aid decision making.
I don't think the accountants that are posting have been "yapping" SencneS or being overtly hostile. They are offering their opinion and being countered repeatedly with "Eve isn't the real world", "MD is used to the (laughable) NAV report" and "I think it should be like this". At which point they'll either try to explain their POV or walk away. What's the point of creating a discussion thread about accounting standards if you are not willing to accept these points of view without throwing a forum tantrum and abusing the very people whose opinions may be useful?
|

Varo Jan
Minmatar
 |
Posted - 2009.10.27 20:28:00 -
[60] - Quote
Originally by: Chingyz
Originally by: Varo Jan You can&t use one valuation method for one side of the balance sheet and another for the other side!
English is not my first language so bear with me on this.
It is not only possible to use different valuation for your income statement and your balance sheet, it is actually in some ways recommended that you do it. Take a look at the IAS, which is what most countries in some way is moving towards when it comes to accounting standards.
You use FIFO, LIFO average or whatever for pricing in your income statemnet and then you use most recent market prices in your balance sheet under your assets. The diffrence is then offset under asset depreciation or appreciation.
Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
I suspect you may be confusing current assets with fixed assets, where the latter are depreciated as a matter of course and are very occasionally revalued.
Quote: The difference between the income statement and the balance sheet is that the income statement shows your historic transactions, while the Balance sheet shows the value of your company at the end of your accounting period.
I prefer to think of it like this. The P&L or Income statement is one line in the balance sheet. It tells you how well or badly you have done over a period of time. The balance sheet is a snapshot of a company&s financial status/health at a specific point in time.
|
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 20:46:00 -
[61] - Quote
Originally by: Varo Jan
Originally by: Chingyz
Originally by: Varo Jan You can&t use one valuation method for one side of the balance sheet and another for the other side!
English is not my first language so bear with me on this.
It is not only possible to use different valuation for your income statement and your balance sheet, it is actually in some ways recommended that you do it. Take a look at the IAS, which is what most countries in some way is moving towards when it comes to accounting standards.
You use FIFO, LIFO average or whatever for pricing in your income statemnet and then you use most recent market prices in your balance sheet under your assets. The diffrence is then offset under asset depreciation or appreciation.
Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
I suspect you may be confusing current assets with fixed assets, where the latter are depreciated as a matter of course and are very occasionally revalued.
Quote: The difference between the income statement and the balance sheet is that the income statement shows your historic transactions, while the Balance sheet shows the value of your company at the end of your accounting period.
I prefer to think of it like this. The P&L or Income statement is one line in the balance sheet. It tells you how well or badly you have done over a period of time. The balance sheet is a snapshot of a company&s financial status/health at a specific point in time.
So the balance sheet valuation can only be valued at the cost that item was acquired at. Is it correct that items that have no direct costs (say for example, minerals mined) would then not be listed in the balance sheet?
The problem I keep bumping into is how to account and deal with potential additions to inventory that are not captured in any API record (direct trade, mining, etc).
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 20:47:00 -
[62] - Quote
Originally by: Hexxx
Originally by: Mme Pinkerton Edited by: Mme Pinkerton on 27/10/2009 19:43:12 Edited by: Mme Pinkerton on 27/10/2009 19:42:18
Originally by: SencneS The issue that it didn't solve is how do you account for magical items that appear in inventory with no "Cost" associated with them. Things like Mined minerals, Mission Loot, Exploration rewards, and salvage etc.
For statuary accounting, you account for them once you have sold them.
I think what you still have not completely realized is that every serious company IRL uses a number of very different accounting schemes in parallel. There's a reason why there are 3 accounting lectures (general statuary accounting, internal & external accounting, accounting for finance/investment) in my university curriculum - and I am doing economics, not business administration.
For external accounting (and that's what an auditor should confirm) the key idea is to create as much comparability between enterprises as possible (i.e. strict standards) while giving equity holders/investors data they can rely on (say, in case of a chapter 7-like insolvency).
In internal accounting (you would generally not base any business decisions on the balance sheet done for the external world) you can do whatever you deem to be useful - but no analyst or investor is ever going to see these balance sheets. In internal accounting you are more concerned with getting a realistic estimate of the state of your business (not a super-conservative one), e.g. one of my professors suggests that you should include the projected value of your customer-base and your human capital ressources in your internal balance sheets - you could ofc never write these in any officially published balance sheet.
I get the feeling that you think that internal accounting practices should be applied to the balance sheets you are going to publish - that's generally not the case (reasons listed above).
So from the perspective of external accounting, how do we account for items which "magically" appear in inventory with no trace in any API record?
Should these instances be flagged and manual categorization be performed?
If something magically appears in a Companies hangars then for it be included in any reports then it must be given a value. I am of the opinion that whatever the market value of said item IS within the timeframe of the statements is the value that should used.
I would argue the fact that mined minerals have no cost associated with them but that is just little old anal me.
|

Claire Voyant
 |
Posted - 2009.10.27 21:09:00 -
[63] - Quote
Originally by: Varo Jan Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
While I understand the need for this rule in the real world with real-word products, we are playing an internet space ship game with the possibility of perfectly efficient production and perfectly efficient reprocessing. I for one would like to talk more about why you feel this rule is appropriate in Eve, and less about the way it is done in the real world.
If I am producing shuttles, give me one good reason why I shouldn't value them based upon the current value of the trit they contain, or for that matter, why I shouldn't value a pile of trit at it's current market price.
|

Selene D'Celeste
Caldari The D'Celeste Trading Company ISK Six
 |
Posted - 2009.10.27 21:24:00 -
[64] - Quote
Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world. Hexxx, if you're actually going to spend time on this, then go for what's practical. People care about estimated value. So do that. No one is going to give a **** that money is tied up in a Raven as opposed to liquid. If that raven is worth around X, then mark it down as X, and move on.
 |

Hexxx
Minmatar
 |
Posted - 2009.10.27 21:27:00 -
[65] - Quote
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world. Hexxx, if you're actually going to spend time on this, then go for what's practical. People care about estimated value. So do that. No one is going to give a **** that money is tied up in a Raven as opposed to liquid. If that raven is worth around X, then mark it down as X, and move on.
I'm trying to tackle this issue and others...I really do appreciate the amount of discussion so far.
|

Varo Jan
Minmatar
 |
Posted - 2009.10.27 21:37:00 -
[66] - Quote
Originally by: Hexxx So from the perspective of external accounting, how do we account for items which "magically" appear in inventory with no trace in any API record?
Should these instances be flagged and manual categorization be performed?
I&ll assume we&re interested in setting an Eve Standard - Accounting for Magic Manifestations. [ES1]
Off the top of my head that includes:
1. Mined ores 2. Mission rewards (including Cosmos, Epic Arc, Data Centre... Any others?) 3. Mission drops 4. PvP drops (or can the API extract this info from kill mails?) 5. Salvage (from missions, ratting and ninja activities) 6. Direct Trades (?)
Am I missing any?
For starters, it would help immensely if we lobbied for them all to be included in the API. But I doubt anything will happen in the short term.
In practice, what happens currently if you use an application like jEveAssets is that these magic apparitions end up being valued using whatever method you have chosen to value all your assets (Hek highest buy cost, Jita lowest selling price, whatever.)
As to a standard, the simplest route, and the most conservative, is to value all except direct trades at zero. Yes, there are indirect costs in mining, missioning and PvP - but establishing such costs would be highly arbitrary, subjective and overly complicated.
The alternative would be to value them at market cost on the day they magically manifest. Accounting entries would be debit stock and credit stock revaluation reserve, or some such.
Valuation at market cost gets my vote.
|

Phoebe Halliwel
 |
Posted - 2009.10.27 21:38:00 -
[67] - Quote
Originally by: Hexxx
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world. Hexxx, if you're actually going to spend time on this, then go for what's practical. People care about estimated value. So do that. No one is going to give a **** that money is tied up in a Raven as opposed to liquid. If that raven is worth around X, then mark it down as X, and move on.
I'm trying to tackle this issue and others...I really do appreciate the amount of discussion so far.
Glad you do Hexxx, so do I, it's a nice change from normal MD discussions 
^^ The above statement, if you were to replace the word Raven with Golem, Rhea, Wyvern or Leviathan right now... you'd be looking at some extremely creative accounting if you try to value unsold stock (build, partially built or materials for production) at this point at current market value. Hence the argument about what stock should be valued at.
Selene, explain where "pragmatism" outweighs showing a "true and fair picture" in financial reporting.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 21:43:00 -
[68] - Quote
Originally by: Phoebe Halliwel
Originally by: Hexxx
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world. Hexxx, if you're actually going to spend time on this, then go for what's practical. People care about estimated value. So do that. No one is going to give a **** that money is tied up in a Raven as opposed to liquid. If that raven is worth around X, then mark it down as X, and move on.
I'm trying to tackle this issue and others...I really do appreciate the amount of discussion so far.
Glad you do Hexxx, so do I, it's a nice change from normal MD discussions 
^^ The above statement, if you were to replace the word Raven with Golem, Rhea, Wyvern or Leviathan right now... you'd be looking at some extremely creative accounting if you try to value unsold stock (build, partially built or materials for production) at this point at current market value. Hence the argument about what stock should be valued at.
Selene, explain where "pragmatism" outweighs showing a "true and fair picture" in financial reporting.
I'd buy that for a dollar Phoebe. Here Here!
|

Varo Jan
Minmatar
 |
Posted - 2009.10.27 21:58:00 -
[69] - Quote
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world.
Enough already with this smokescreen. If you want to run a successful business long term *anywhere* you need realistic accounting standards. If MD wants to evolve, it needs consistent accounting standards applied to all businesses - your bank-to-be included.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 22:00:00 -
[70] - Quote
Originally by: Varo Jan
Off the top of my head that includes:
1. Mined ores 2. Mission rewards (including Cosmos, Epic Arc, Data Centre... Any others?) 3. Mission drops 4. PvP drops (or can the API extract this info from kill mails?) 5. Salvage (from missions, ratting and ninja activities) 6. Direct Trades (?)
Am I missing any?
Valuation at market cost gets my vote.
Exploration items. Which is a tricky one because you literally go up to a can and open it. Even API would have a hard time tracking that, good luck getting CCP and CMSs to push for some way to track items that came from a can out in space. You could also account for pirate activity this way, you blow up a ship and steel the mods. Now EVE API does track ship kills and loot drops from kills so you "could" account for that. But it doesn't account for the random drive by can thievery 
There is also a small issue of Contracts, lets assume you did all of these and purchased stuff on contract. Manual and Automatic are going to have a hard time knowing what came from the contract. :(
Maybe the solution is as simple as a "Magic Bucket" for these items. Anything that API can't account for in some way, including contract cost and profit, and any disappearing items that don't have a API record should be included in that bucket. Anything "new" unaccounted for is Profit according to it's fair value. Anything that disappears and doesn't have previous API records simply shows up at a loss from the bucket.
Originally by: Phoebe Halliwel I don't think the accountants that are posting have been "yapping" SencneS or being overtly hostile. They are offering their opinion and being countered repeatedly with "Eve isn't the real world", "MD is used to the (laughable) NAV report" and "I think it should be like this". At which point they'll either try to explain their POV or walk away. What's the point of creating a discussion thread about accounting standards if you are not willing to accept these points of view without throwing a forum tantrum and abusing the very people whose opinions may be useful?
If that is what it takes to get a working censorious on something both accounting nerds and EVE nerds can agree on then call me evil for doing it. I have a feeling somewhere in the MD Archives a similar discussion took place a long time ago. The conclusion that MD came to back then was "Use NAV". I have a beef with NAV myself, sure it's an OK way to judge corporate worth, but it does squat to actually judge if the corporation is actually doing good. Hence why I'm "battling" this a little more aggressively then I wanted to.
If that comes across as a tantrum sorry, desire to come to a censorious of what works in real life and how it could work in EVE along with what the general MD community want and are use to seeing is a thin line.
Just to clear here:-
NAV is good for only one thing - Corporate value. Using NAV as a be all end all account practices for internal, external, auditing is indeed laughable. However, it should be at least part of any report simply because it's the only real way to capture the entire corporations growth or shrinkage within EVE. NAV is the easy way out to account for all the non-real life things like magical items appearing and disappearing out of thin air.
 Amarr for Life |
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 22:02:00 -
[71] - Quote
Originally by: Varo Jan
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world.
Enough already with this smokescreen. If you want to run a successful business long term *anywhere* you need realistic accounting standards. If MD wants to evolve, it needs consistent accounting standards applied to all businesses - your bank-to-be included.
So how do we account for the problem areas I listed; loot, mining your own minerals, salvage, etc?
I'm looking for possible solutions here.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 22:11:00 -
[72] - Quote
Edited by: Prodigal on 27/10/2009 22:12:07 I would suggest to keep things simple for the following items:
1. Mined ores - Current market values (would have to be an average) 2. Mission rewards (including Cosmos, Epic Arc, Data Centre... Any others?) - Current market values (would have to be an average) 3. Mission drops - Current market values (would have to be an average) 4. PvP drops (or can the API extract this info from kill mails?) - Current market values (would have to be an average) 5. Salvage (from missions, ratting and ninja activities) - Current market values (would have to be an average) 6. Direct Trades (?) not sure how this would be handled as it really depends on the actual traded items are but if they are any of the above then (yep you guessed it) - Current market values (would have to be an average)- Unless of course the trade was made at a certain value then THAT value should be applied
I mean, how else could a value be assigned?
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 22:12:00 -
[73] - Quote
Originally by: Hexxx
Originally by: Varo Jan
Originally by: Selene D'Celeste Yes, let's apply real world rules and reasoning to accounting in an environment which is distinctly different from the real world.
Enough already with this smokescreen. If you want to run a successful business long term *anywhere* you need realistic accounting standards. If MD wants to evolve, it needs consistent accounting standards applied to all businesses - your bank-to-be included.
So how do we account for the problem areas I listed; loot, mining your own minerals, salvage, etc?
I'm looking for possible solutions here.
Magic Bucket  Anything in it, is valued at "Fair Value" It's probably the only real way to be reasonable about it.
 Amarr for Life |

Varo Jan
Minmatar
 |
Posted - 2009.10.27 22:18:00 -
[74] - Quote
Originally by: Claire Voyant
Originally by: Varo Jan Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
While I understand the need for this rule in the real world with real-word products, we are playing an internet space ship game with the possibility of perfectly efficient production and perfectly efficient reprocessing. I for one would like to talk more about why you feel this rule is appropriate in Eve, and less about the way it is done in the real world.
If I am producing shuttles, give me one good reason why I shouldn't value them based upon the current value of the trit they contain, or for that matter, why I shouldn't value a pile of trit at it's current market price.
Is coding in Eve any different to the real world? Is marketing in Eve different? Is man-management different? Is researching a market different? No, no, no and no. So what&s with all the angst about accounting?
One of the foundations of accounting is conservatism. That principle doesn&t disappear here in Eve. That&s why you should show your shuttles at cost - not at some hypothetical selling price. In fact, the principle applies very strongly here. Look at the recent massive drop in trit alone. Look at the wild fluctuations in module prices you see on a daily basis.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 22:25:00 -
[75] - Quote
Originally by: SencneS Direct Trade doesn't tell you what it was that was traded, it's like contract, shows up as a journal entry with a value on it. But doesn't tell you what it is.
Direct Trade and Contracts can be accounted for in terms of value, just not what items where associated with it. Maybe that's what needs to be done. Account for these as raw cash expense/profits. Any item that magically appears gets filed as fair value.
You are right about that.
Some transactions will inevitably need to be recorded manually, not to mention some adjusting entries that will always be needed.
I also think we should simplify the accounting by assuming everyone has the same fiscal year end.
Standards for periods of reporting may also need to be set so that everyone is comparing apples to apples. Wether that be monthly, quarterly and annually, or bi-weekly or whatever.
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 22:28:00 -
[76] - Quote
Originally by: Varo Jan
Originally by: Claire Voyant
Originally by: Varo Jan Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
While I understand the need for this rule in the real world with real-word products, we are playing an internet space ship game with the possibility of perfectly efficient production and perfectly efficient reprocessing. I for one would like to talk more about why you feel this rule is appropriate in Eve, and less about the way it is done in the real world.
If I am producing shuttles, give me one good reason why I shouldn't value them based upon the current value of the trit they contain, or for that matter, why I shouldn't value a pile of trit at it's current market price.
Is coding in Eve any different to the real world? Is marketing in Eve different? Is man-management different? Is researching a market different? No, no, no and no. So what&s with all the angst about accounting?
One of the foundations of accounting is conservatism. That principle doesn&t disappear here in Eve. That&s why you should show your shuttles at cost - not at some hypothetical selling price. In fact, the principle applies very strongly here. Look at the recent massive drop in trit alone. Look at the wild fluctuations in module prices you see on a daily basis.
So *IF* we can account for exact cost, we do so.
If we can't account for exact cost (so called "magic bucket" items), what do we do then? Are they zero cost? From an income statement perspective I'm ok with that, but how do we show that in a balance sheet? Do they not show up on the balance sheet?
I think this is what drove most people to adopt a NAV report, it's just easier....easier isn't what I want. I want something more accurate and more detailed than just a NAV dump.
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.27 22:57:00 -
[77] - Quote
Edited by: Drab Cane on 27/10/2009 23:00:44 Hexx, you're going to have to manually record the 'magic bucket' items.
Record the items at whatever market price you would reasonably pay for them. It will constitute an increase to your assets, and an increase to your revenue. Show the revenue as "Revenue from . . ." whatever the source was (mining, salvage, loot) on the income statement.
Edit: In our mfg operation, the operation buys the minerals from the characters that mine them, at Jita's current high buy price. Any reasonable standard will do just as well, as long as you're consistent. -----------------------------------------------
- Who Dares, Wins
|

Hexxx
Minmatar
 |
Posted - 2009.10.27 23:00:00 -
[78] - Quote
Originally by: Drab Cane Hexx, you're going to have to manually record the 'magic bucket' items.
Record the items at whatever market price you would reasonably pay for them. It will constitute an increase to your assets, and an increase to your revenue. Show the revenue as "Revenue from . . ." whatever the source was (mining, salvage, loot) on the income statement.
The problem is, I don't think I could show this on an income statement reliably....it allows too much fudging.
I think this is fair for the balance sheet (you have the assets....your not saying what you paid for them).
Now in theory....numbers should largely add up I think if we tried to manually show cost for magic bucket items but they would ABSOLUTELY need to be flagged for inspection.
What I'm trying to do is automate a HUGE part of auditing and if anything is left to manual work, it needs to be organized in such a way to make auditing faster/easier/more effective.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.27 23:03:00 -
[79] - Quote
Originally by: Hexxx So *IF* we can account for exact cost, we do so.
If we can't account for exact cost (so called "magic bucket" items), what do we do then? Are they zero cost? From an income statement perspective I'm ok with that, but how do we show that in a balance sheet? Do they not show up on the balance sheet?
I think this is what drove most people to adopt a NAV report, it's just easier....easier isn't what I want. I want something more accurate and more detailed than just a NAV dump.
Assigning a zero value to simplify does make sense and it can satisfy the accounting equation also.
|

Phoebe Halliwel
 |
Posted - 2009.10.27 23:06:00 -
[80] - Quote
You could consider that this tool may be best utilised by corporations rather than individuals; in which case items obtained "freely" which are later accounted for in stock could be added to stock via an API recordable transfer, i.e. contract to corporation for 0.01 isk?
It's not perfect but will allow you to create an identifiable transaction which can be flagged for later inspection. Just an idea, but I'd suggest workarounds to API limitations rather than designing the software around the gaps.
|
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.27 23:08:00 -
[81] - Quote
Another option is to actually have the mining characters put the minerals up on a buy order and have the corp purchase them immediately. That way you're pushing the mineral transaction through the API. Same with other items that can be sold through the market.
Have the characters donate the proceeds from the mineral sale - that will show on the API as well.
This is assuming that you're only capturing the corporate wallets.
-----------------------------------------------
- Who Dares, Wins
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.27 23:09:00 -
[82] - Quote
I was thinking on the way home that about how to account for magically disappearing items.
For example. Buy a Raven Buy Rigs Sell on contract.
For this an automated system would pick up the cost of the Raven and Rigs but all of a sudden they disappear and the API reports a journal entry as say +120mil. While you could determine a "one time" instance of this per month if it's part of the business this would be increasingly difficult.
If you toss magically appearing and disappearing items in the 'magic bucket' and there is a pre-existing cost associated with those items, then you're golden. Your balance sheet shows a loss of those items, but you get profit in the magic bucket so it's accounted for.
 Amarr for Life |

Freya Lorell
 |
Posted - 2009.10.27 23:40:00 -
[83] - Quote
Edited by: Freya Lorell on 27/10/2009 23:43:34 The risk you run with a "magic bucket" is that it can be a large part of the bussiness. What if a bussiness is run mostly not on the regular market? While the "magic bucket" could be a way to get started, to be useful in all situations bussinesses probably need to employ an accountable way of doing their bussiness.
Edit: Forgot to mention: I think if the "magic bucket" is a large part of the bussiness, it does not help with the goal of the OP.
|

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.27 23:57:00 -
[84] - Quote
Originally by: SencneS That really didn't address the issue :) However, I have applied bold your statement. From my understanding the costs associated with the refining and bottling of the water IS the cost of the bottled water in inventory. While the water is in the spring it's not in sell able form and you certainly can't claim it as an asset on your balance sheet. Only until it's been extracted from the spring and placed in sell able form can you actually sell it. The costs associated with making it sell able is what is used.
Mind you I don't work for a Mining company I'm going of a few investment sites information about how to read a mining companies balance sheet. Apparently it's vastly different then an average companies balance sheet.
The issue that it didn't solve is how do you account for magical items that appear in inventory with no "Cost" associated with them. Things like Mined minerals, Mission Loot, Exploration rewards, and salvage etc.
I don't know if other types of mines are different, but gold mines typically list their gold in the ground (at various levels of fantasy) as assets on their balance sheets. Buying a share of a gold mining company is very similar to buying a claim on 1/[total shares] of the amount of gold they can dig up and refine.
Eve mining is a bit different, of course. :)
Hexxx: Have you considered that a single system might not be enough? There are a ton of different types of ventures in Eve, with a ton of different needs, and for that matter, some with totally different views of the world. |

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.28 00:04:00 -
[85] - Quote
Along the same vein as Wyehr's question, Hexxx, are you looking at building a system for your operations only, or are you looking at a system that could be rolled out for other, interested players? -----------------------------------------------
- Who Dares, Wins
|

Hexxx
Minmatar
 |
Posted - 2009.10.28 00:15:00 -
[86] - Quote
Originally by: Drab Cane Along the same vein as Wyehr's question, Hexxx, are you looking at building a system for your operations only, or are you looking at a system that could be rolled out for other, interested players?
What I would like first is something used for external account, something an auditor would inspect and something public investors would be given access to.
Now....once that is done or near done, THEN I will put serious thought into developing a more operationally focused method of accounting.
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.28 00:20:00 -
[87] - Quote
Again, regarding recording items that have not been obtained through the EVE market (and thus through the API):
Would it be safe to say that an NAV worksheet is pretty much the standard financial statement for EVE? I would think that assets are relatively easy for an auditor to tie out with the NAV, and any liabilities would just have to be confirmed.
My point is, your balance sheet and income statement could be used as internal reports, and the NAV would be used for external purposes (auditors and investors).
You could reflect whatever asset value seems reasonable for your internal accounting, and reflect market value on your NAV. As long as your accounting system correctly tracks how many assets (inventory, etc.) you have, and how much cash you have in your wallet(s), producing both the internal and external reports should be straightforward.
-----------------------------------------------
- Who Dares, Wins
|

Hexxx
Minmatar
 |
Posted - 2009.10.28 00:28:00 -
[88] - Quote
Originally by: Drab Cane Again, regarding recording items that have not been obtained through the EVE market (and thus through the API):
Would it be safe to say that an NAV worksheet is pretty much the standard financial statement for EVE? I would think that assets are relatively easy for an auditor to tie out with the NAV, and any liabilities would just have to be confirmed.
My point is, your balance sheet and income statement could be used as internal reports, and the NAV would be used for external purposes (auditors and investors).
You could reflect whatever asset value seems reasonable for your internal accounting, and reflect market value on your NAV. As long as your accounting system correctly tracks how many assets (inventory, etc.) you have, and how much cash you have in your wallet(s), producing both the internal and external reports should be straightforward.
I'm not satisfied with trying to calculate profits that way. At the very least I want to do FIFO on the income statement. I haven't talked about it alot but a cash flow should be doable as well.
The big trick is....how do you calculate and track and GROUP a group of alts dedicated to a business? This is what I spend part of my day working on since linking and grouping characters is part of the underlying technology i'm developing for my insurance project.
There are other services as well....giving the IPO owner finer control of what details to release in an audit for one.
|

Drab Cane
Carbenadium Industries
 |
Posted - 2009.10.28 00:51:00 -
[89] - Quote
It sounds like you do want to have an auditor confirm not just the value of the operation, but its profits and expenses as well. I don't think you'll find a shortcut, you'll have to go 'all in'. The API simply does not track enough information to properly track most asset transactions, and you will need to generate your own records that fill the gaps (as I believe someone suggested above already).
Why is grouping alts that much of a challenge? As far as I know, all transaction/journal/asset IDs are system-wide. Track individual alts as their own 'department'. Add a 'department' field to your import tables, and fill it with either the ID of the character you're importing from, or the number of the corp wallet.
You should be able to code the 'department' field in such a way that you can automatically handle 'inter-departmental' transactions (at least, that's the theory).
-----------------------------------------------
- Who Dares, Wins
|

Hexxx
Minmatar
 |
Posted - 2009.10.28 01:00:00 -
[90] - Quote
Originally by: Drab Cane It sounds like you do want to have an auditor confirm not just the value of the operation, but its profits and expenses as well. I don't think you'll find a shortcut, you'll have to go 'all in'. The API simply does not track enough information to properly track most asset transactions, and you will need to generate your own records that fill the gaps (as I believe someone suggested above already).
Why is grouping alts that much of a challenge? As far as I know, all transaction/journal/asset IDs are system-wide. Track individual alts as their own 'department'. Add a 'department' field to your import tables, and fill it with either the ID of the character you're importing from, or the number of the corp wallet.
You should be able to code the 'department' field in such a way that you can automatically handle 'inter-departmental' transactions (at least, that's the theory).
cash transfers are easy, yes.
just getting everything easily configured and tracking things in aggregate is going to be a technical hurdle to clear.
|
|

Varo Jan
Minmatar
 |
Posted - 2009.10.28 05:20:00 -
[91] - Quote
The Dominion loot logger should help: Link
|

Claire Voyant
 |
Posted - 2009.10.28 12:23:00 -
[92] - Quote
Originally by: Varo Jan
Originally by: Claire Voyant
Originally by: Varo Jan Read IAS2. The fundamental principle of that accounting standard is: "Inventories(stock) are required to be stated at the lower of cost and net realisable value (NRV). [IAS 2.9]" In practice, that means that stock enters the balance sheet at cost and remains at cost unless seriously adverse conditions occur. You do *not* revalue stock (a current asset & part of your working capital) upwards. Ever.
While I understand the need for this rule in the real world with real-word products, we are playing an internet space ship game with the possibility of perfectly efficient production and perfectly efficient reprocessing. I for one would like to talk more about why you feel this rule is appropriate in Eve, and less about the way it is done in the real world.
If I am producing shuttles, give me one good reason why I shouldn't value them based upon the current value of the trit they contain, or for that matter, why I shouldn't value a pile of trit at it's current market price.
Is coding in Eve any different to the real world? Is marketing in Eve different? Is man-management different? Is researching a market different? No, no, no and no. So what&s with all the angst about accounting?
One of the foundations of accounting is conservatism. That principle doesn&t disappear here in Eve. That&s why you should show your shuttles at cost - not at some hypothetical selling price. In fact, the principle applies very strongly here. Look at the recent massive drop in trit alone. Look at the wild fluctuations in module prices you see on a daily basis.
I have repeatedly said I'm not talking about valuing manufactured items at their hypothetical selling price. What I am talking about is updating the "cost" to reflect current mineral prices, call it "current production cost" and updating the value of raw mineral inventory to current market prices. If you ask me, the recent massive drop in trit supports my case.
My first coding project thirty years ago was an accounting program for a commodities futures trader. We used mark-to-market accounting because that was the standard and our statements had to agree with the statements the customers were receiving from their brokers. I know for a fact that accounting standards do change to reflect new technologies, etc.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.28 13:52:00 -
[93] - Quote
Originally by: Claire Voyant I have repeatedly said I'm not talking about valuing manufactured items at their hypothetical selling price. What I am talking about is updating the "cost" to reflect current mineral prices, call it "current production cost" and updating the value of raw mineral inventory to current market prices. If you ask me, the recent massive drop in trit supports my case.
The recent drop in Trit price is the finest reason of all to NOT do what you suggest.
If I purchased 100mil units of trit for 3ISK p/u, build stuff that uses 40mil units. The items I build I would list consists of 3ISK p/u of trit used. If I then adjust the price of the Trit to the now market value of 2.5 ISK, for the remainder of the inventory. I have lost 30mil ISK value. That is simply bad business, regardless of how much the material is worth right now, the cost is ALWAYS what I paid for it.
This is the bases for the whole issue and why NAV is junky.. NAV works well when everything is going up in price, but when it's crashing it's a nightmare waiting to happen.
Now I understand where you're coming from, you're saying. "If I was to buy that trit for 2.5 to replace the Trit I used in my inventory, I why would I use the 3 ISK price I purchased the other units for." That's is LIFO. You use your inventory and instantly replace it with current market value material. It's a fair call and I can see that, in fact I was thinking of using a new term in my sheet and am currently testing it out in theoretical production and marketing runs.. CIFO (Cheapest In - First Out) meaning if I have a stack of raw materials that I have purchased over time, for different prices, I always use the production cost of the cheapest component (Like NASA) 
Example. I build shuttles, I want to produce 1,000,000 shuttles, and I have a perfect ME BPO. I goto Jita and refuse to purchase 2.5B units of Trit off sell orders, so I place buy orders. Lets say I get 2.5B in batchs of 500mil units.
Batch one I paid 2.78 p/u Batch two I paid 2.63 p/u Batch Three I paid 2.53 p/u Batch four I paid 2.69 p/u Batch five I paid 2.9 p/u
The first 200,000 shuttles I produce use the 2.53ISK p/u batch. The second 200,000 shuttles the 2.63ISK p/u batch.
If I chose to purchase another 1B units of Trit and the market price is say 2.51 ISK. The next 400,000 shuttles I produce use the 2.51 price.
In real life this would be a crazy idea because there is cost for storing inventory, this cost doesn't exist in EVE so holding onto ancient raw materials carries no burden. What it does do is allow you to ALWAYS get close or better market value (Depending on how often you purchase materials). As the price of materials decline you consume those materials first, as the price of materials goes up, you still consume the cheapest material which could be the 2.9 ISK p/u price.
If you always carry an inventory of Raw materials the "inventory" will always be made up of the most expensive price you paid for the raw material. In the case of the shuttles it's likely I would be holding onto the 2.9 Trit forever if I held an inventory and keep purchasing quantity of trit I consumed in production. My Profit margin would always be higher then LIFO and FIFO even if I sold at the same price.
The point of all of this is you MUST keep your inventory of the unused material at the price you paid for it regardless of what it's worth. If you the price of Trit say raised to 4 per unit, why would you adjust the price to 4 ISK. You would sell your inventory to get that opportunity cost profit. Then purchase more trit at 4 ISK.
The ONLY way I could justify adjusting inventory cost to market value is if you record the adjustment as a profit or loss.
Meaning if you lose 30mil ISK adjusting the price to current market value you report a 30mil loss.
 Amarr for Life |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 14:23:00 -
[94] - Quote
SencneS, please stop and read your post carefully. You are saying that two identical units of tritanium have different values depending on how much you paid for them. This may be "good accounting", but is it totally ****ing wrong.
If you are wondering, the least insane way for a builder to view the value their inventory is at the price their next batch will cost.
In your example, when the price of trit swung from 2.9 to 2.51, you can put that trit into a new pile, shine it up real good and pass it down to your children as a cherished family heirloom, but that money is gone. If you wait for the value to come back up over 2.9, you'll get your 195M ISK back, but it'll cost you however much you could have earned if you hadn't idled 1.255B ISK of your assets for the duration, and if it never comes back you won't have lost 195M ISK, but 1.45B ISK. |

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.28 14:47:00 -
[95] - Quote
Edited by: SencneS on 28/10/2009 14:48:45
Originally by: Wyehr SencneS, please stop and read your post carefully. You are saying that two identical units of tritanium have different values depending on how much you paid for them. This may be "good accounting", but is it totally ****ing wrong.
If you are wondering, the least insane way for a builder to view the value their inventory is at the price their next batch will cost.
In your example, when the price of trit swung from 2.9 to 2.51, you can put that trit into a new pile, shine it up real good and pass it down to your children as a cherished family heirloom, but that money is gone. If you wait for the value to come back up over 2.9, you'll get your 195M ISK back, but it'll cost you however much you could have earned if you hadn't idled 1.255B ISK of your assets for the duration, and if it never comes back you won't have lost 195M ISK, but 1.45B ISK.
You do realize in the example I'm also purchasing what was consumed. If I used 1b units of trit I repurchase 1b to recovery the consumption.
I didn't say it was a smart business plan, just the way I was considering accounting for consumption and the rather quick market changes in materials.
What I don't think you understand is I could care less about that trit that cost 2.9 ISK, if it sits there for an eternity, so be it. If I used it in production, a Shuttle would cost 7,250 ISK in materials. There is no way it will ever sell if people are selling for 7,249 and making a 974 ISK per shuttle because they purchased trit for 2.51. It would be utter stupidity for me to keep the shuttles at build cost on the market when everyone else is buying new trit at 2.51 and selling them cheaper.
Sure I could take a loss, but I'd rather sit on the inventory which costs nothing to sit on, and hope one day the price of trit gets above 2.9. And here is why - You say "You'll get your 195M back but it'll cost you however much you could have earned if you hadn't idled 1.255B ISK in your assets..." I didn't idle anything, you can only produce at a given rate, if I choose to purchase materials cheaper then my inventory cost, use it, and sell, my production didn't idle. You can only produce so fast.
Maybe it might help if I added ONE SINGLE LINE to the example.
"I produce shuttles at the fastest rate possible and at the maximum production rate I can obtain, constantly without break."
There does that make it better for you? 
 Amarr for Life |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 16:04:00 -
[96] - Quote
Originally by: SencneS Edited by: SencneS on 28/10/2009 14:48:45 You do realize in the example I'm also purchasing what was consumed. If I used 1b units of trit I repurchase 1b to recovery the consumption.
I didn't say it was a smart business plan, just the way I was considering accounting for consumption and the rather quick market changes in materials.
What I don't think you understand is I could care less about that trit that cost 2.9 ISK, if it sits there for an eternity, so be it. If I used it in production, a Shuttle would cost 7,250 ISK in materials. There is no way it will ever sell if people are selling for 7,249 and making a 974 ISK per shuttle because they purchased trit for 2.51. It would be utter stupidity for me to keep the shuttles at build cost on the market when everyone else is buying new trit at 2.51 and selling them cheaper.
Sure I could take a loss, but I'd rather sit on the inventory which costs nothing to sit on, and hope one day the price of trit gets above 2.9. And here is why - You say "You'll get your 195M back but it'll cost you however much you could have earned if you hadn't idled 1.255B ISK in your assets..." I didn't idle anything, you can only produce at a given rate, if I choose to purchase materials cheaper then my inventory cost, use it, and sell, my production didn't idle. You can only produce so fast.
Maybe it might help if I added ONE SINGLE LINE to the example.
"I produce shuttles at the fastest rate possible and at the maximum production rate I can obtain, constantly without break."
There does that make it better for you? 
Of course I realize that you are replacing what you use. That's my whole point. Are you sure that you understand the implications?
As a builder, your cost for production is how much it will cost you in the future to replace the materials you are using right now, not how much you paid for them in the past.
I bolded the funny parts. Your production of shuttles might be humming right along, but you are sitting on a half billion units of trit (or two billion) which are idle, or if you prefer, you are sitting on the liquidation value of that trit in ISK, which is idle. You are throwing good money (the ISK you could earn if you sold that trit and put the proceeds to productive use) after bad (the money you already lost when the price dropped).
By holding onto it in hopes that the value comes back up you aren't engaged in building activity, you are speculating at best, or gambling at worst. This may or may not be a good move for you, but at the very least you should recognize what you are doing.
To tie this back into the main thread, and to the points I've been trying to make since page 1, there is no one right way to do accounting. Even if you follow good practices and make an effort to be open, honest and transparent (as I believe SencneS is) your numbers will lead you into fantasy land if you aren't careful. If you've been paying attention to the real world for the last two years, you've seen thousands of examples this, from real estate to banking and beyond. |

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.28 16:12:00 -
[97] - Quote
My idea - After speaking with Hexxx he said "It's a way for you to ever account for a loss." Which I can see, if the price of Trit never got above 2.9, I'd sit on that inventory forever, assuming the margins I where making where less then the loss I would take by using it.
The issue that I'm trying to solve is one I had in EVE. I would consume a lot of Trit at any given time, between a few mil and up to as much as 80mil units when I ran a production cycle. So in order to get the product out as quick as possible I would hold an inventory of about 100-120mil units of trit. For convenience sake I would use "Average cost" as the cost of the Trit (NOT Market value, but average cost to me). I believe most people do this, some may use market value but I wanted to know how much it cost, not how much it's worth. When I stopping producing close to Trit crashing, the average cost of my almost 100mil units in inventory cost 3.13.
I couldn't sell it for 3.13 even though for a month I was purchasing trit at about 2.95. It was lowering the average every time I purchased but I realized that the average over all had to have a limit on how much to average. I started working using FIFO in my cost of materials but realized there must be a different way. At any given time I would have between 40-60mil units of trit. I ALWAYS had that, while I could have adjusted my inventory to 80mil in stock I didn't because the potential to use 100mil units WAS there.
I realized that in some weeks the rate of consumption was low and FIFO was actually working against me. I had purchased trit for 3, and using it at that price, but there was no way I could use it fast enough to compete with people using 2.8 valued trit. It was then I rationalized myself into using the cheapest inventory I had on hand, regardless of when I purchase it. I couldn't compete with lower prices because EVE's margins are razor thin, and in the ammo business volume is king.
I know that not using the more expensive inventory can lead to artificially inflated profits. My rationalization was pretty simple - While I'm sitting on it, it on my books and the cost in which I paid for it. It's just an asset sitting there not costing anything and I haven't take a loss on it, and eventually trit will be back up over 3 ISK a unit in which I would then be ahead of market cost.
It's like a gamble, at the time the business shuts down the asset at whatever price it is worth then takes a loss. I'm not disputing that, what I'm suggesting is if the company has the means to sit on inventory that may never get used why wouldn't they?
Maybe this is an argument for depreciation, assets sitting in inventory for over a month start to take losses, after a while the depreciated value of the asset is below market value in which you sell it or use it. I could live with depreciation on stagnant assets.
 Amarr for Life |

Amentis Artaurus
 |
Posted - 2009.10.28 16:28:00 -
[98] - Quote
Originally by: Wyehr This may be "good accounting", but is it totally ****ing wrong.
I've been reading this thread through, especially your posts, because I couldn't understand your line of thinking, but now I think I understand. You are thinking like an economist, not an accountant. Which is fine, and it explains a lot, for me anyway.
Originally by: Wyehr If you are wondering, the least insane way for a builder to view the value their inventory is at the price their next batch will cost.
I would respectfully disagree. This presupposes that you will actually build a next batch. It may be the best way to view it when you make decisions on what to build or not build, but remember that the op's objective is a representation of assets at a moment in time, existing outside of future decisions, for auditing purposes. Future building costs are irrelevant for the ops purpose, though a builder will obviously need to follow them closely and make decisions based on them. The correct way accounting represents this is cost. Past costs cannot be eliminated for convenience, ever. Except in maybe one case in mergers and acquisitions.
Originally by: Wyehr In your example, when the price of trit swung from 2.9 to 2.51, you can put that trit into a new pile, shine it up real good and pass it down to your children as a cherished family heirloom, but that money is gone. If you wait for the value to come back up over 2.9, you'll get your 195M ISK back, but it'll cost you however much you could have earned if you hadn't idled 1.255B ISK of your assets for the duration, and if it never comes back you won't have lost 195M ISK, but 1.45B ISK.
Accounting does not attempt to look into the future or record theoretical ways money/materials could be or should be used better. An economist or a financier takes what you describe into account when they make decisions, but auditors simply record things, looking into the past.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.28 16:29:00 -
[99] - Quote
I just remembered the biggest reason why I rationalized doing that. I considered the fact that I had IDLE Cash/Capital. Which is worse, Idle cash or idle inventory?
Using the idle inventory is guaranteed to take a loss. Using idle cash to purchased cheaper inventory, use it, and sell product results in a profit.
 Amarr for Life |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 17:22:00 -
[100] - Quote
Originally by: SencneS I just remembered the biggest reason why I rationalized doing that. I considered the fact that I had IDLE Cash/Capital. Which is worse, Idle cash or idle inventory?
Using the idle inventory is guaranteed to take a loss. Using idle cash to purchased cheaper inventory, use it, and sell product results in a profit.
While I understand your process, I still think that it is an artifact of your accounting method and doesn't reflect reality. In my view, if your inventory is idle because you paid more for it in the past than it is worth now, the loss has already happened. And the fact that you aren't using it means that you know you've taken a loss, even if you don't put it in your books yet.
You are using accounting to justify an irrational decision that you made on an emotional basis.
Holding onto it is a bet that the price is going to come up in the future. If you are sure that the price is going to come back up, you should hold it. Actually, you should buy as much of it as you can afford. If it was a good deal (in this example) at 2.9, surely it must be even better at 2.51, right? |
|

Hexxx
Minmatar
 |
Posted - 2009.10.28 18:43:00 -
[101] - Quote
My solution:
For accountable transactions (cost is known AND price of item sold is known) a cashflow report, income statement, and balance sheet can be automatically constructed using FIFO.
For unaccountable transactions (cost is unknown OR price of item sold is unknown) a cashflow report and NAV report can be automatically constructed.
Now, an auditor/analyst would then probably comment on these published reports. These reports would be generated on a monthly basis for businesses with shareholders and for businesses without shareholders, prior to a bond sale (to assess ability to repay debt).
Whew.
So, how's that look? Also, for private businesses, a regulator could attest that these reports are being generated (preventing a possible EBANK situation from happening again.) Bonus. 
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.28 20:55:00 -
[102] - Quote
Originally by: Wyehr As a builder, your cost for production is how much it will cost you in the future to replace the materials you are using right now, not how much you paid for them in the past.
 ZOMG 
Sry Hexx (I know this is your thread) but I simply cannot resist stomping all over this one.
Are you really serious about that statement!?!?
This is fundamentally wrong no matter what "accounting method" you are using.
Cheers,
|

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 21:44:00 -
[103] - Quote
Originally by: Prodigal
Originally by: Wyehr As a builder, your cost for production is how much it will cost you in the future to replace the materials you are using right now, not how much you paid for them in the past.
Are you really serious about that statement!?!?
This is fundamentally wrong no matter what "accounting method" you are using.
Yes, I am totally serious. If there is another way to look at (from a builder's point of view) that is more right, it isn't obvious to me.
I'll do a car analogy. You buy a new car and it either comes with a full tank of gas or you fill it up. The cost of that gas either way is part of the cost of the car. As you drive, you borrow from the tank, and you have to refill it at some future rate. If you get screwed and end up paying way too much for gas one day, you sure as hell don't park the car and tell yourself that it is the right thing to do because the gas in it is "worth" a fortune. The gas is "worth" as much as it is going to cost you to replace it after you use it, regardless of how much you paid for it, or how much you should have paid for it.
|

Prodigal
Caldari New Genesis Project
 |
Posted - 2009.10.28 22:18:00 -
[104] - Quote
Originally by: Wyehr I'll do a car analogy. You buy a new car and it either comes with a full tank of gas or you fill it up. The cost of that gas either way is part of the cost of the car. As you drive, you borrow from the tank, and you have to refill it at some future rate. If you get screwed and end up paying way too much for gas one day, you sure as hell don't park the car and tell yourself that it is the right thing to do because the gas in it is "worth" a fortune. The gas is "worth" as much as it is going to cost you to replace it after you use it, regardless of how much you paid for it, or how much you should have paid for it.
Only one problem with your analogy....
When you buy a BPO or BPC - It DOES NOT come along with a manufacturing job running in it already.
If this does not make sense to you, then you will have to accept the fact that I simply cannot waste any more time explaining it.
We will simply have to write you off of the books.
Cheers,
|

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 22:42:00 -
[105] - Quote
Originally by: Prodigal
Originally by: Wyehr I'll do a car analogy. You buy a new car and it either comes with a full tank of gas or you fill it up. The cost of that gas either way is part of the cost of the car. As you drive, you borrow from the tank, and you have to refill it at some future rate. If you get screwed and end up paying way too much for gas one day, you sure as hell don't park the car and tell yourself that it is the right thing to do because the gas in it is "worth" a fortune. The gas is "worth" as much as it is going to cost you to replace it after you use it, regardless of how much you paid for it, or how much you should have paid for it.
Only one problem with your analogy....
When you buy a BPO or BPC - It DOES NOT come along with a manufacturing job running in it already.
If this does not make sense to you, then you will have to accept the fact that I simply cannot waste any more time explaining it.
We will simply have to write you off of the books.
You've not made any attempt to explain anything. Actually, I don't see any evidence to suggest that you've made any effort to understand anything either. Unless there was some insight hidden in the numerous smileys and veiled insults that you've offered so far.
I'll admit the car analogy was inexact. I should have anticipated that a person could focus on the car part and totally miss the point. Hint: it was the gas, not the car. It would have been more clear if I'd said "siphon the gas out, store it, and fill it up with new cheap gas" rather than "park the car". Does that help?
Back in Eve production terms, a builder's inventory is part of the investment. On a daily basis, it is the zero point. To build is to borrow from the inventory, and when a sale is made, that loan is paid back. If there is money left over after putting the materials back and paying expenses, that is profit, otherwise there is loss. That profit can be paid out in dividends, used to increase the size of the inventory (aka reinvestment), or whatever. |

Wyehr
Shadow Of The Light
 |
Posted - 2009.10.28 23:09:00 -
[106] - Quote
Hexxx:
Sorry if it seems like I'm derailing your thread by inviting and following arguments about the utility of accounting in general and about the universality of particular methods thereof. I like to hope that someone has profited from the discussions.
For the record, I think that what you are trying to do is a good thing, and will even be useful. However, I don't think that it will make more than a small dent in the real problem which I see as our inability to understand, assess and price risk.
Just like in real life, a standard for accounting will help assess the risks that we already understand, but won't do much for the risks we don't understand, it I'm not at all sure that it'll help us price any of them. |

Varo Jan
Minmatar
 |
Posted - 2009.10.30 04:06:00 -
[107] - Quote
Originally by: Claire Voyant What I am talking about is updating the "cost" to reflect current mineral prices, call it "current production cost"
Financial accounts are compiled from actual data. A company paid 100 for its materials and sold the finished product for 110, resulting in a profit of 10. What the cost price of the materials happened to be on the date the finished product was sold, or any other date between material purchase date and product sale date, is irrelevant.
However, updating costs (outside the financial accounts) to reflect current prices is very relevant for decision-making purposes. I suspect you are failing to differentiate between statutory financial records and management accounts or financial tools to assist in decision-making.
Quote: My first coding project thirty years ago was an accounting program for a commodities futures trader. We used mark-to-market accounting because that was the standard and our statements had to agree with the statements the customers were receiving from their brokers. I know for a fact that accounting standards do change to reflect new technologies, etc.
None of the 26 industry sectors I&ve worked or consulted in used mark-to-market accounting, so I can&t comment. However, commodities futures trading is not manufacturing, where stock is valued at the lower of cost or net realisable value, and that cost could be standard, average - or very rarely FIFO.
|

SencneS
Rebellion Against Big Irreversible Dinks
 |
Posted - 2009.10.30 13:32:00 -
[108] - Quote
Wyehr is "partly" correct about manufactures using future cost of raw materials as "cost" of materials on current production runs. However what he failed to include is it always comes with a contract from the raw materials supplier and the finished goods producer.
I work for a Automotive Supplier company, one of the, if not largest ones in the world. The process that happens is this.
I'll use Ford because it's smaller to type.
Ford says We need x amount of y component. Company says We can supply x amount of y component, quote will come shortly. Company says to Raw materials provider - We will need z amount of w materials, contingent of Ford signing contract i. Raw materials provider says z amount of w materials will cost v amount. Company sign contract with Raw materials provider to provide raw z amount of w materials at v amount only if Ford signs contract i. Company goes back to Ford to with quote where x amount of y component is based on v amount. Ford signs contract i. Company doesn't wait for the Raw materials provider to deliver z amount of w materials but starts producing from raw material inventory, or in some cases y component in inventory if that component was cheaper then components made up of w materials, and a discontinued contract on Ford behalf (Which they would have paid part of for breach of contract). 
So it does happen in real life, I can't speak for any other industries but for automotive this IS the way it works. The only reason it is this way for automotive is Ford and pretty much all vehicle manufactures have incredible time constraints. When they want x amount of y components part of the contract is time, how quickly the supplier can provide them. So it's in the best interest of the supplier to maintain a full inventory of raw materials.
I wouldn't be surprised if other suppliers for finished goods manufactures work the same way. It makes sense and is GOOD business for the supplier. To translate that in EVE you would need to be a T2 Component Manufacture suppling JUST T2 ship builders. However in EVE, Raw materials are quick, and easy to get and every raw material you get as exactly the same quality level (perfect) so there is no need to keep an inventory of materials. So in EVE this methodology is extremely redundant and offers no benefit of doing it, and adds complexity that doesn't need to be there.
 Amarr for Life |
|
| |
Reply to Topic |
| Pages: 1 2 3 4 :: [one page] |