Every company relies on data, and Costpoint has some powerful reporting options right out of the box. As much as we might try, we couldn’t function without the ability to export a report to Excel in a tabular format. When a company is small, with a smaller data set and fewer stakeholders, the reports provided by Deltek work really well, and a little bit of customization or formatting is easy to manage.
However, standard reports have some limitations that you start to discover as the business grows in size. With the number of transactions increasing, the organization growing in complexity, and the number of stakeholders growing, standard reports start to become insufficient.
Limitation 1 – Report Limited to a Specific Module
Deltek Costpoint reports and inquiries contain solid reporting options within each module, but oftentimes a need arises for information that is not contained within a single module. For example, you might run a labor report and wish you could add the Supervisor and Project Manager fields. Another example could be an AP report showing checks paid, but you just wish you could search to see vouchers that hit a specific project.
The previous solution would be to run two detailed reports, filter them to the data you need, and then use XLOOKUP to combine the two sources. This can work on a small scale, but it has limitations. It is cumbersome to set up and especially to repeat each month. Excel only returns the first instance of whatever you are looking up; this could leave data out that you did not intend to filter out.
These are easy to mitigate at the beginning, but as data sets grow, these downsides become harder to check for.
Limitation 2 – Report Does Not Render Well into Excel from Costpoint
In the early days of Deltek Costpoint, printing a report into PDF works just fine for analyzing the data. Or, if rendering to Excel, there might be some formatting issues, but with a small volume of data, it’s not a huge hurdle to perform reconciliations or analysis. As companies grow, it could be administratively infeasible to look through a multi-page PDF document for discrepancies. Or, with Excel, you could end up having to spend hours realigning headers and columns in Excel to make the report usable and then repeat that task each month.
These basic reports could be written into Costpoint (with customizations, if desired) so that no additional formatting is necessary and the data comes out in a clean tabular format. Additionally, formatting will be consistent each month.
Limitation 3 – Standard Report Has Information on It That Requires Limited Access
In the early days of a company’s life cycle, segregating pay information slows business down. You may only have one or two PMs who are privy to all contracts within the company. The back-office staff likely wears many hats, including handling labor, payroll, and HR data. Creating data silos slows down the pace of things. However, as a company grows, the need for segregating pay information can become more important. Program managers need to focus only on their programs, and back-office staff start to have further segregated duties. This is where standard Costpoint reports might not be sufficient. For example, you might want a PM to see certain pay information, but only for their specific programs. Or in another case, you might want to segregate pay information from HR and benefit information in the back office.
There are some ways to accomplish these items using built-in user security, project roles, or org security, but creating a custom Business Intelligence report could give users access to only the data they need without adding to the administrative burden of running Costpoint.
Limitation 4 – Information Is Unavailable Through the Front End or Standard Reports
Lastly, there is some information that is simply not available through standard reporting. One example is timestamping. Just after implementing Costpoint, there are probably few people actually entering information into the system. Running down who performed a specific transaction is pretty simple if only two people have access to a particular screen.
As a company grows and more personnel are added, you might need to hunt down who entered a transaction and what time it was entered or posted.
Another example is timestamping in Time and Expense. Unfortunately, situations sometimes arise where it is important to establish the date and time someone made a change to their timesheet.
This information would need to be gathered through a custom Business Intelligence report. There are many benefits to custom reporting as your business grows. Repeatability, security, efficiency, and consistency are all benefits to be gained with an investment in custom reports.
When Custom Deltek Costpoint Reporting Makes Sense
If your team rebuilds the same Excel report every month or maintains a separate tracker for information already in Costpoint, that recurring work can help you decide where to invest in custom reporting. Redstone GCI assists government contractors with identifying which reports are worth customizing and developing Costpoint Business Intelligence reports that bring together data from multiple modules, produce consistent Excel exports, and show each team the information it needs. When a report returns incomplete or unexpected results, we also assist with reviewing the report logic, source data, and Costpoint configuration to find the cause and make targeted adjustments. The goal is to give your team reliable information and more time to use it.


Senior Managing Consultant
Shannon is a Senior Managing Consultant in Redstone GCI’s Costpoint Consulting Team. She has used Deltek Costpoint with government contractors for over 10 years. Her experience has covered multiple areas within the system and involved more than the standard day-to-day transactions. She led teams through several system modifications and upgrades, including reorganizations, merging databases and system enhancements.
Shannon is extremely organized and deadline-focused and brought these strengths to her team by utilizing technology to streamline workflows, develop job documentation and use the system to ensure the organization worked smarter, not harder.
She enjoys writing custom reports for her clients and has published many reports that have helped end-users retrieve the data they need in the format they require. Providing automated reports that save them time, improve accuracy and alleviate the need to juggle multiple spreadsheets manually.
Professional Experience
Shannon started her career supporting a large manufacturing company, working in corporate accounting on mark to market accounting for hedge and derivative activities, preparing filings and intercompany eliminations. She then transitioned to an operating group responsible for centralizing all accounting functions for all plants. She was selected for the process improvement team to streamline all templates and close processing.
After obtaining her CPA license, she spent several years working in public accounting preparing individual and trust tax returns. She then entered the world of Deltek Costpoint, working at a not-for-profit. She was responsible for all general ledger and intercompany activities for four entities and creating standardized processes for these areas.
Then, she transitioned to the for-profit world, becoming the director of finance and accounting. She successfully led all financial, DCAA, NASA, and ERISA audits and was instrumental in obtaining a certified accounting system and preparing the annual incurred cost submissions. She also served as the SAAS admin, leading multiple successful Costpoint upgrades and reorganizations. She also functioned as the main report writer for the company – turning ad hoc data requests into repeatable reports that stakeholders could run ad hoc, or have delivered to their inboxes.