Trying to export the Transaction ID as it appears it the Recon reports. Can't find the formula

SBP1

I'd like to export the transaction ID. See it appears in the Reconciliation reports and I'd like to add it to my own export

Rachael Hopkins

Hi @SBP1 I believe it's {expense:id}

Let me know if I can help with anything further!

SBP1

Tried that but it is the ID for the Expense report.

I'm trying to find the formula for the unique transaction id for each expense. This is in the Reconciliation report

Rachael Hopkins

Hi @SBP1 The Report id is {report:id}. {expense:id} should output the unique number associated with each individual expense e.g "4294967579".

SBP1

Thanks Rachael.

Tried again...but getting whole columns of same numbers: here is part of the transaction id column

Expense id 291121.PNG

Rachael Hopkins

Hi @SBP1 it might be more effective if you write into [email protected] or use chat from within Expensify so that we can dig into files, look at specific meta data etc.

SBP1

I did and they referred me to the community!

Jason Li

@SBP1 - I had a look at your chat via Concierge, and it sounds like you're trying to export the unique transaction ID. I believe that this is generally associated with credit card expenses (and is bank-issued), whereas the expense ID formula that you've looked into is designated by Expensify (and is Expensify-issued). Apologies for any confusion!

SBP1

Thanks Jason.

In the recon report, there is a transaction ID. I have created an export of my own in which I'd like to extract the same so that I can do some vlookups and get exactly what I want

Jason Li

Hi @SBP1 - I'm thinking it might be easier to move this conversation to Concierge, so we can interact directly. Could you please write in to us, and share where you're seeing the transaction ID? Is this from your bank statement?