›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Costbasis calculation and Tax report - FIFO method

Ben_WienBen_Wien
in Excel Workbook
Hi Vidas,
Thanks for the amazing work and much valuable model. I was wondering if you have any recommendations how to handle Costbasis calculations using First in first out method, particularly in the context of calculating the tax report, which is from what I understand, based on the average cost basis, indeed, our tax authority protocol is based on the FIFO method. Do you think this could be a possible upgrade for the Version 3.0?
All the best, Ben

Comments

  • VidasMatelisVidasMatelis
    In v2.4 and v3.0 releases cost basis is calculated using average cost accounting. This calculation is complicated and not easily implemented in PowerPivot because PowerPivot engine does not support recursive calculations that are required for proper cost basis calculation. Because of this I am not planning at this point to implement FIFO method, sorry.
  • Ben_WienBen_Wien
    Ok that's all clear, and understand now the discrepancy with my broker platform calculations. Thank you the feedback Vidas
Sign In or Register to comment.