[$250] [CFI] Show cash back to Expensify Card reconciliation in NewDot

[joekaufmanexpensify]

Coming from this Slack thread, we want to surface cash back activity as a dedicated row in the NewDot Bank Reconciliation view for the Expensify Card.

Details

• In Classic, cash back credits appear as their own non-expandable row in Reconciliation > Settlements, with a Cash Back Credit merchant label, the credit amount, and a Cleared status (see screenshot below). NewDot currently shows nothing for cashback, making it impossible to reconcile cashback credits against bank activity.
• To address that, we want to add a top-level cashback row to the Bank Reconciliation view to match this. The row should follow the existing NewDot rec table structure (Withdrawn date, Withdrawal status, Bank account, Withdrawal ID, Expenses, Total), but with no expand arrow option.
• The plan is for the row to be identifiable by Withdrawal status: Cash back (analogous to how card payments use Cleared).
• The total should display as a negative amount, consistent with OldDot and reflecting that cashback is a credit back to the bank account. The opposite direction from a card payment settlement.
• This should be scoped to ACH cashback credits only, since the rec view is tied to bank activity. Cashback applied to billing is out of scope here, same as in OldDot.
• We will pursue making these rows expandable in a follow-up issue, showing the individual underlying transactions that earned cashback in the period.

Existing cash back credit row (OldDot)

Cash back row in NewDot (final mock)

Issue Owner

Current Issue Owner: @ShridharGoel

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~022069481062860149447
• Upwork Job ID: 2069481062860149447
• Last Price Increase: 2026-06-23

[melvin-bot]

Triggered auto assignment to Design team member for new feature review - @dannymcclain (NewFeature)

[melvin-bot]

📣 @coclock! 📣
Hey, it seems we don’t have your contributor details yet! You'll only have to do this once, and this is how we'll hire you on Upwork.
Please follow these steps:

1. Make sure you've read and understood the contributing guidelines.
2. Get the email address used to login to your Expensify account. If you don't already have an Expensify account, create one here. If you have multiple accounts (e.g. one for testing), please use your main account email.
3. Get the link to your Upwork profile. It's necessary because we only pay via Upwork. You can access it by logging in, and then clicking on your name. It'll look like this. If you don't already have an account, sign up for one here.
4. Copy the format below and paste it in a comment on this issue. Replace the placeholder text with your actual details.
   
   Format:

Contributor details
Your Expensify account email: <REPLACE EMAIL HERE>
Upwork Profile Link: <REPLACE LINK HERE>

[joekaufmanexpensify]

One question to the group. Cash back rows in classic can have a Cleared or Failed badge. If we take the above approach, they would only have a Cash back badge under Withdrawal status in NewDot. Personally, I think this is fine. Cash back settlements fail only if we're unable to deposit funds into an account, which is very rare. If that happens, we automatically create an internal GH issue to investigate and resolve it. As far as I can see, it's been a few years since this has occurred, so I don't think we need to optimize for it.

Curious if others agree? cc @Expensify/product

[joekaufmanexpensify]

If so, we would just need to decide on the new cash back badge color before we implement this. Interested in your thoughts on that Danny!

[twisterdotcom]

If it does fail, would we ever bother showing it at all in ND?

[joekaufmanexpensify]

We would show a failed cash back deposit with the proposed design above. There wouldn't be any indication in the UI that it failed, though. It's very rare for this to happen because banks almost never block deposits to an account. I can't find evidence that it's happened since 2023, so I'm not concerned about it. Especially because we create a GH issue for our team to reach out to the customer if it does.

[dannymcclain]

I think if we take the approach you're describing above, the green badge might make sense? Like this:

But it is a little weird to me to put cashback in that status column, because it's not a settlement status, it's like a settlement type or something. 🤔 I don't feel too strongly though. Let's see if @Expensify/design has any strong feelings. (Figma)

[shawnborton]

I don't mind the badge, but I do find it a bit odd that all of the rows are grouped header rows that expand, yet the cashback row doesn't.