These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Having trouble matching taxes to transactions
Author
Previous Topic Next Topic
JonnyRandom
#1 - 2011-12-12 20:38:34 UTC
I want to include sales tax in my profit calculations, but the wallet window is giving me a huge headache trying to match sales taxes and broker's fees to the correct transactions. Is there an easier way to do that?
Kirin Falense
Some names are just stupid
#2 - 2011-12-12 20:46:47 UTC
Get your actual fees by looking in game, enter these into the program your writing, use to calculate profit based on actual sell and actual buy (- fees) from transaction log.

Cheers
JonnyRandom
#3 - 2011-12-12 20:52:47 UTC
Yeah but that's what I'm saying, the brokers fees and sales tax don't show for which item in the wallet.

The sales tax isn't hard to figure out because it comes right after the transaction payout, so I can find it using the time-stamp, but the broker fee is a nightmare, because it's deducted once the buy order is placed and the isk go into escrow. But it can be an indeterminable amount of time before the buy order is actually filled, so there's no time-stamp to go buy. And since the broker's fees line in the wallet doesn't show a description for which item it was, I only have the price to go buy, and with many items that have very similar prices this is giving me enormous amounts of headaches.

Maybe there's an API program that doesn't have problem doing this?
Lauren Hellfury
Super Happy Awesome Fun Times
#4 - 2011-12-12 21:26:06 UTC
There is no way to reliably do this automatically. The added complication are the 100isk modification charges.

The simplest way, if you only trade in one station, is to just do what Kirin said and manually add the percentage on in your spreadsheet or whatever.


I used to just calculate the profit from average buy to average sell for each item and deduct all fees/taxes from the total profit at the end. Since your fees/taxes are static across all items because of percentage this still gives you a decent guideline.

Help rid New Eden of T2 BPOs: ** https://forums.eveonline.com/default.aspx?g=posts&t=62797 **The Full Pocket Aggro blog:  http://fullpocketaggro.blogspot.com/ **Now showing: **Margin Trading Scams
Ilinea
Sebiestor Tribe
Minmatar Republic
#5 - 2011-12-12 21:27:21 UTC  |  Edited by: Ilinea
Make it for yourself easy and take an average broker fee percentage that you will have to pay on the stations you trade regularly (as the broker fee depends on standings). You can see in the advanced buy/sell order window the percentage. And just use this percentage in your calculations. So actually you won't have to match journal entries here.

They told me to mine... and I started to mine, the market ;)
JonnyRandom
#6 - 2011-12-12 21:37:02 UTC
Lol, now I feel stupid. Thanks for pointing out to just manually deduct the fees based on %

Cheers!
Agrapena
Center for Advanced Studies
Gallente Federation
#7 - 2011-12-15 08:17:04 UTC
try EveNexus. A simple yet effective program for calculating the profit and taking into account Fees/Taxes.

EveNexus