[Due for payment 2026-03-30] [$250] Update Reports -> Expenses default shown columns

[dylanexpensify]

Coming from an internal discussion (reference), we're looking to update the default columns we show when a user visits the Reports > Expenses page. The new default columns we have enabled should be:

• Receipt
• Type
• Date
• Status
• Merchant
• From
• Category
• Total

Reference image:

Issue Owner

Current Issue Owner: @mallenexpensify

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~022028470352370166588
• Upwork Job ID: 2028470352370166588
• Last Price Increase: 2026-03-31

EXFY-19617

[melvin-bot]

Triggered auto assignment to Contributor-plus team member for initial proposal review - @eVoloshchak (External)

[melvin-bot]

Job added to Upwork: https://www.upwork.com/jobs/~022028470352370166588

[daledah]

Proposal

Please re-state the problem that we are trying to solve in this issue.

Actual Result: The default columns on the Reports > Expenses page currently display Type, Date, Status, Merchant, From, Category, Total. The Receipt column is not visibly present in the table headers.

What is the root cause of that problem?

The default columns for the Reports > Expenses page are defined in src/CONST/index.ts. The TYPE_DEFAULT_COLUMNS.EXPENSE array currently includes Receipt, Date, Merchant, From, To, Category, Tag, Total Amount, and Action—but omits Type and Status in the default order, and includes columns (To, Tag, Action) that are not in the desired default set. This configuration does not match the intended default columns: Receipt, Type, Date, Status, Merchant, From, Category, Total.

App/src/CONST/index.ts

Lines 7261 to 7272 in 706ef83

	return {
	EXPENSE: [
	this.TABLE_COLUMNS.RECEIPT,
	this.TABLE_COLUMNS.DATE,
	this.TABLE_COLUMNS.MERCHANT,
	this.TABLE_COLUMNS.FROM,
	this.TABLE_COLUMNS.TO,
	this.TABLE_COLUMNS.CATEGORY,
	this.TABLE_COLUMNS.TAG,
	this.TABLE_COLUMNS.TOTAL_AMOUNT,
	this.TABLE_COLUMNS.ACTION,
	],

What changes do you think we should make in order to solve the problem?

1. Update TYPE_DEFAULT_COLUMNS.EXPENSE in src/CONST/index.ts to add Type and Status, remove To, Tag, and Action, and reorder columns to match the intended default: Receipt, Type, Date, Status, Merchant, From, Category, Total.

2. Optional: Update the columns object in getColumnsToShow in src/libs/SearchUIUtils.ts: when visibleColumns is empty or equals the default, the display uses this object. Set STATUS: true and ACTION: false so the default view matches the new columns.

--- a/src/CONST/index.ts
+++ b/src/CONST/index.ts
@@ -7259,13 +7259,12 @@ const CONST = {
         get TYPE_DEFAULT_COLUMNS() {
             return {
                 EXPENSE: [
                     this.TABLE_COLUMNS.RECEIPT,
+                    this.TABLE_COLUMNS.TYPE,
                     this.TABLE_COLUMNS.DATE,
+                    this.TABLE_COLUMNS.STATUS,
                     this.TABLE_COLUMNS.MERCHANT,
                     this.TABLE_COLUMNS.FROM,
-                    this.TABLE_COLUMNS.TO,
                     this.TABLE_COLUMNS.CATEGORY,
-                    this.TABLE_COLUMNS.TAG,
                     this.TABLE_COLUMNS.TOTAL_AMOUNT,
-                    this.TABLE_COLUMNS.ACTION,
                 ],

--- a/src/libs/SearchUIUtils.ts
+++ b/src/libs/SearchUIUtils.ts
@@ -4212,8 +4212,8 @@ function getColumnsToShow(
               [CONST.SEARCH.TABLE_COLUMNS.REPORT_ID]: false,
               [CONST.SEARCH.TABLE_COLUMNS.TITLE]: false,
               [CONST.SEARCH.TABLE_COLUMNS.EXPORTED_TO]: false,
-              [CONST.SEARCH.TABLE_COLUMNS.STATUS]: false,
+              [CONST.SEARCH.TABLE_COLUMNS.STATUS]: true,
               [CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT]: true,
-              [CONST.SEARCH.TABLE_COLUMNS.ACTION]: true,
+              [CONST.SEARCH.TABLE_COLUMNS.ACTION]: false,
           };

Note: We can adjust the column if needed

What alternative solutions did you explore? (Optional)

Reminder: Please use plain English, be brief and avoid jargon. Feel free to use images, charts or pseudo-code if necessary. Do not post large multi-line diffs or write walls of text. Do not create PRs unless you have been hired for this job.

[Eskalifer1]

Proposal

Please re-state the problem that we are trying to solve in this issue.

Update Reports -> Expenses default shown columns

What is the root cause of that problem?

The default columns for Reports > Expenses are defined with the old set, and the runtime fallback logic for the page also hardcodes a different old visibility map. Because these two places are not aligned with the new requirement, users still see outdated defaults.

App/src/CONST/index.ts

Lines 7279 to 7288 in b16a951

	EXPENSE: [
	this.TABLE_COLUMNS.RECEIPT,
	this.TABLE_COLUMNS.DATE,
	this.TABLE_COLUMNS.MERCHANT,
	this.TABLE_COLUMNS.FROM,
	this.TABLE_COLUMNS.TO,
	this.TABLE_COLUMNS.CATEGORY,
	this.TABLE_COLUMNS.TAG,
	this.TABLE_COLUMNS.TOTAL_AMOUNT,
	this.TABLE_COLUMNS.ACTION,

App/src/libs/SearchUIUtils.ts

Lines 4190 to 4218 in b16a951

	[CONST.SEARCH.TABLE_COLUMNS.RECEIPT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.TYPE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.DATE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.POSTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.SUBMITTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.APPROVED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.MERCHANT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION]: false,
	[CONST.SEARCH.TABLE_COLUMNS.FROM]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.POLICY_NAME]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CARD]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CATEGORY]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAG]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BILLABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BASE_62_REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TITLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED_TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.STATUS]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.ACTION]: true,
	};

What changes do you think we should make in order to solve the problem?

Update both default definitions used by Reports > Expenses to the new column set:
Receipt, Type, Date, Status, Merchant, From, Category, Total.

App/src/CONST/index.ts

Lines 7279 to 7288 in b16a951

	EXPENSE: [
	this.TABLE_COLUMNS.RECEIPT,
	this.TABLE_COLUMNS.DATE,
	this.TABLE_COLUMNS.MERCHANT,
	this.TABLE_COLUMNS.FROM,
	this.TABLE_COLUMNS.TO,
	this.TABLE_COLUMNS.CATEGORY,
	this.TABLE_COLUMNS.TAG,
	this.TABLE_COLUMNS.TOTAL_AMOUNT,
	this.TABLE_COLUMNS.ACTION,

EXPENSE: [
    this.TABLE_COLUMNS.RECEIPT,
    this.TABLE_COLUMNS.TYPE,
    this.TABLE_COLUMNS.DATE,
    this.TABLE_COLUMNS.STATUS,
    this.TABLE_COLUMNS.MERCHANT,
    this.TABLE_COLUMNS.FROM,
    this.TABLE_COLUMNS.CATEGORY,
    this.TABLE_COLUMNS.TOTAL_AMOUNT,
],

App/src/libs/SearchUIUtils.ts

Lines 4190 to 4218 in b16a951

	[CONST.SEARCH.TABLE_COLUMNS.RECEIPT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.TYPE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.DATE]: true,
	[CONST.SEARCH.TABLE_COLUMNS.POSTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.SUBMITTED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.APPROVED]: false,
	[CONST.SEARCH.TABLE_COLUMNS.MERCHANT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.DESCRIPTION]: false,
	[CONST.SEARCH.TABLE_COLUMNS.FROM]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.POLICY_NAME]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CARD]: false,
	[CONST.SEARCH.TABLE_COLUMNS.CATEGORY]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAG]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REIMBURSABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BILLABLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TAX_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXCHANGE_RATE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.ORIGINAL_AMOUNT]: false,
	[CONST.SEARCH.TABLE_COLUMNS.BASE_62_REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.REPORT_ID]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TITLE]: false,
	[CONST.SEARCH.TABLE_COLUMNS.EXPORTED_TO]: false,
	[CONST.SEARCH.TABLE_COLUMNS.STATUS]: false,
	[CONST.SEARCH.TABLE_COLUMNS.TOTAL_AMOUNT]: true,
	[CONST.SEARCH.TABLE_COLUMNS.ACTION]: true,
	};

{
    [CONST.SEARCH.TABLE_COLUMNS.STATUS]: true,
    [CONST.SEARCH.TABLE_COLUMNS.ACTION]: false,
    // keep other values
}

Additionally we should hide column To for expense type here:

App/src/libs/SearchUIUtils.ts

Lines 4302 to 4306 in b16a951

	const toFieldValue = getToFieldValueForTransaction(transaction, report, data.personalDetailsList, reportAction);
	if (toFieldValue.accountID && toFieldValue.accountID !== currentAccountID && !columns[CONST.SEARCH.TABLE_COLUMNS.TO]) {
	columns[CONST.SEARCH.TABLE_COLUMNS.TO] = !!report && !isOpenReport(report);
	}
	}

if (toFieldValue.accountID && toFieldValue.accountID !== currentAccountID && !columns[CONST.SEARCH.TABLE_COLUMNS.TO] && type !== CONST.SEARCH.DATA_TYPES.EXPENSE)

Or

if (toFieldValue.accountID && toFieldValue.accountID !== currentAccountID && !columns[CONST.SEARCH.TABLE_COLUMNS.TO] && isExpenseReportView)

What alternative solutions did you explore? (Optional)

[github-actions]

⚠️ @Eskalifer1 Your proposal is a duplicate of an already existing proposal and has been automatically withdrawn to prevent spam. Please review the existing proposals before submitting a new one.

[Eskalifer1]

Not a dupe, My proposal includes an important part regarding the To column. If this is not done, the task will not correspond to the expected behavior and, accordingly, cannot be accepted.