How to display or report before tax amount

HGG

I'm not sure if I'm missing something, but is there a way to display the before tax or sub total amount for an expense?

I see that total amount is given but I'm looking for a way to display the before or sub total amount.

Thanks!

HGG

So, I figured this out. Pretty simple. I thought I'd leave here in case someone is looking for this insight quickly

Go to Settings then Preferences

CSV Export Formats

Create new

Name it however you'd like

Choose export format

Add column

Name new column (sub total)

Formula {expense:tax:net}

Save

The formulas I used were:

{expense:tax:net}

(For Sub total)

{expense:tax:amount}

(for Tax amount - make sure the tax is set up first)

{expense:amount:nosymbol}

(for Total amount)

Also check this out:

https://community.expensify.com/discussion/5794/deep-dive-understanding-custom-export-templates-and-formulas

Hope this helps someone, somewhere, some time :)

OliverKlosov

Exactly what I was looking for. Done and done. Thank you so much for taking the time to post the answer to your own question once you figured it out HGG. 😊