BUG - [your bug title here] about dbt_xero HOT 5 CLOSED

Hi @ayushonplan

Thanks for opening this issue. It seems the issue you are describing is that the net_value amounts within the final dbt model are not matching the Xero UI generated reports. I actually previously helped an individual with a similar question in this Issue.

Would you be able refer to the resolution we achieved in the previous issue and let me know if that resolves the discrepancy you are seeing as well.

Thanks!

from dbt_xero.

from dbt_xero.

Thanks for the clarification @ayushonplan

I would imagine the inverse values are a result of the journal entry is a credit and the Xero is recognizing the increase as a negative value. We then adjust for this in the final model by multiplying by -1 to ensure the final PL reports do not display negative values when they are in fact increases.

Would you be able to confirm the account that you are noticing this for. My suspicion is that it is an account that is increased with a credit and that is why the journal entries are showing negative values, when in fact they should be represented as positive values in the P&L (i.e a revenue amount will usually be adjusted to be positive and an expense to be negative).

from dbt_xero.

HI @ayushonplan 👋

I wanted to check back in if my above explanation helped answer your question?

from dbt_xero.

Hi @ayushonplan 👋

I will be closing this issue as I believe the above message addresses your initial question. Please feel free to re-open this issue if you would like to discuss further.

Thanks!

from dbt_xero.