Others

How Many Custom Cost Fields Are Available in Microsoft Project?

Ayan Masood Oct 9, 2026 869 views

Question details

The user wants to know the availability and limits of custom cost fields in Microsoft Project for detailed financial planning.

How Many Custom Cost Fields Are Available in Microsoft Project?

Product: Microsoft Project
Device & OS: not provided
Scenario: Setting up detailed financial metrics and tracking budgets within a project plan.
Observed behavior: Users need to know the specific limits on cost fields as Microsoft Project limits the number of built-in Cost custom fields, which may constrain advanced accounting workflows.

Before you start

Verify whether you are using the desktop version of Microsoft Project or an enterprise edition (like Project Online), as the availability of custom fields varies significantly between them.

Solution 1Recommended

Using Built-in Custom Fields in the Desktop Version

Leverage the available custom Cost, Number, and Text fields provided in Microsoft Project Desktop for your financial tracking needs.

The desktop version of Microsoft Project includes 10 additional Cost fields, 20 Number fields, and 30 Text fields. While Number fields can provide alternative calculations for budgets, they may not automatically apply currency formatting or behave like native Cost fields.

Open Custom Fields dialog

Navigate to the 'Project' tab on the main ribbon and click on the 'Custom Fields' button in the Properties group.

Select the Cost type

In the Custom Fields dialog box, click the 'Type' dropdown menu in the upper right corner and select 'Cost' to access Cost1 through Cost10.

Utilize Number or Text fields

If you exceed the 10 Cost fields, change the 'Type' dropdown to 'Number' (to access Number1 through Number20) or 'Text' (Text1 through Text30) to store additional financial metrics.

Using Built-in Custom Fields in the Desktop Version

Accounting Limitations: Microsoft Project is a scheduling tool, not an accounting system. For financial records requiring strict accounting accuracy, you should export your data to dedicated accounting software.

Solution 2

Leveraging Enterprise Custom Fields

Use Enterprise Custom Fields if your organization uses Project Server or Project Online, which allows for a much higher limit of tracking fields.

Free Microsoft Office alternative

Manage Project Budgets Flexibly with WPS Spreadsheet

If the strict limit of 10 custom cost fields in Microsoft Project is restricting your project's financial planning, consider using WPS Spreadsheet. It offers unlimited flexibility for tracking project costs and is highly compatible with Microsoft Office files.

1. Download and Install: Download WPS Office Free from the official website and open WPS Spreadsheet.
2. Set Up Your Project Budget: Create a new spreadsheet or search for 'Project Budget' in the template library.
3. Customize Your Cost Fields: Add as many custom cost, text, and numerical columns as your specific project requires without hitting software limits.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless file sharingNo limits on custom cost columns, text fields, or complex financial calculationsHundreds of free, ready-to-use project management and budget templatesFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I rename the default custom cost fields in Microsoft Project?

Yes. To rename a field, go to the Project tab, click Custom Fields, select the field (e.g., Cost1) from the list, and click the Rename button. Type your custom name and click OK.

Why do Number fields behave differently than Cost fields in Project?

Number fields are generic data fields and do not inherently include currency symbols or behave in standard cost roll-ups for summary tasks. You may need to manually configure formulas or formatting for Number fields to mimic Cost fields.

Can I use Microsoft Project as my primary accounting software?

No. Microsoft Project provides basic cost tracking tied to project schedules, but it lacks the stringent auditing, double-entry bookkeeping, and accuracy standards required of dedicated accounting software.

Office Quick Solutions