Is there a way to get unique expense IDs when pulling reports?
Is there a way to get unique expense IDs when pulling reports?
Looks like expense.transactionid is the same for all expenses in a report?
Answers
-
HI @edison There isn't a unique transaction id for each expense. You can, however, choose to use the {expense:receipt:url} to show the unique URL for each expense. You can find more expense specific formulas here. If you have any account specific questions, please don't hesitate to reach out to [email protected].
-
Found out Excel is actually converting the last two digits to 00.. making it look like the same ID.
-
@edison Awesome! Glad you were able to figure this out.
-
Sheena Trepanier Expensify Team, Approved! Accountant, Expensify Student Ambassador Posts: 1,362 Expensify TeamFor anyone else running across this, the formula to pull the expense ID is {expense:ID}, however, Excel will automatically change the information export for ID and we recommend using a different spreadsheet program or asking an Excel expert without your organization for how to resolve the issue.
A quick Google surfaced this article, which may be helpful.
-
Sheena Trepanier Expensify Team, Approved! Accountant, Expensify Student Ambassador Posts: 1,362 Expensify Team
In addition, another customer also found this solution!
I figured out a simple way by using the substring formula (in Expensify) to only export the final 15 digits which are unique to each expense. {expense:id|substr:5:17}
Thank you!
