Problems & solutions · Internal Tools

Investment Adviser Compliance Software Problems: The 7 That Surface During an Examination, and How to Avoid Them

Investment Adviser Compliance Software product interface illustration showing common problems and fixes.
The short answer

The most expensive failure is a restricted list stored as a table that gets updated in place. Every preclearance decision you made is then unprovable, because the version of the list that existed on the morning of the trade no longer exists anywhere. A firm whose employees never traded anything improper still looks uncontrolled, and the cost lands as weeks of senior time during an examination plus a finding about implementation rather than conduct. Nothing here is legal advice, so confirm your obligations with counsel.

Why does the every policy at once scope keep failing?

The chief compliance officer lists what hurts, and the list is long: preclearance, personal trading reconciliation, attestations, gifts and entertainment, political contributions, marketing review, outside business activities, the annual review. All of it goes into release one, because all of it is a real obligation and none of it feels optional. Four months later the firm has a half built system covering eight policies shallowly and is still running preclearance through the compliance inbox, which is the thing that actually carries enforcement risk.

What makes this specific to advisers is that the policies are not equally weighted. Personal trading is where the exposure concentrates, and it is also the area where a good system changes behaviour rather than just recording it. When preclearance answers in seconds, employees use it. When it takes a day, they quietly stop asking, and the population of unprecleared trades grows in a place nobody is looking.

Sequence accordingly. Release one is preclearance against a versioned restricted list, brokerage feed and statement ingestion with reconciliation, and the attestation cycle. Marketing review, gifts and political contributions belong in phase two. That ordering is not about engineering convenience, it is about which gap an examiner is most likely to find and which one is hardest to remediate after the fact.

What goes wrong when you migrate historical compliance records?

Three migrations look easy and are not. Brokerage history is the first. Years of statements sit as PDFs in folders named by person and year, with duplicates, missing months, and accounts for spouses that were disclosed verbally and never written down. Extracting all of it into structured transactions sounds thorough and usually produces a partial dataset that reads as authoritative, which is worse than an obviously incomplete one, because somebody will eventually run a report against it and treat the output as fact.

The restricted list is the second and it is the one that cannot be recovered. If the list has been overwritten in place since the day it was created, its history genuinely does not exist. No migration retrieves it. Pretending otherwise by loading the current list with a backdated effective date creates a record that asserts something you cannot support, which is a materially worse position than an honest gap.

Attestations are the third. Historic completions live in email threads and a spreadsheet with a tick, and there is often no record of who was chased and when, which is exactly the follow up question examiners ask about non responders.

The fix in all three cases is to draw a clean line. Migrate what you can verify, mark the boundary date explicitly in the system, and keep the pre boundary archive intact and accessible in its original form rather than transformed into structured data that implies a precision you do not have. Then start the point in time record from go live and never edit it.

Why do custodian and internal system integrations break after launch?

Brokerage feeds break in ways that are invisible from inside the system. A custodian stops sending duplicate statements for an account because a paperwork authorisation lapsed. An employee opens an account at a broker that sends nothing electronically. A feed keeps arriving but a new account on it does not match any person in your register, so it lands in a queue nobody has been assigned to watch. In every case the system looks healthy and your coverage has quietly shrunk.

The fix is coverage monitoring rather than feed monitoring. Reconcile the set of accounts you believe each access person holds against the set of accounts actually producing data, every month, and treat any account with no activity and no statement as an exception requiring a human answer. That single report catches most of what goes wrong here.

Internal integrations break differently. The link to your customer relationship management (CRM) and portfolio accounting systems is usually the reason to build in the first place, and it depends on identifiers matching between systems maintained by different teams. A security master that models equities well and options, futures, private credit or digital assets badly will silently misclassify the instruments your strategies actually trade, which means preclearance rules evaluate against the wrong attributes. Test that with your real instrument mix during selection, not after.

What happens when point in time records and trade reconciliation are not covered?

Two gaps produce findings rather than inconvenience. The first is the mutable restricted list. Examiners assess whether a compliance programme is reasonably designed and actually implemented, and implementation is demonstrated with records. If you cannot show what the list contained at a specific hour on a specific past day, you cannot evidence that a preclearance decision was correct, however correct it was. The structure required is append only and point in time, queryable by date, with every version preserved.

The second is reconciling what was precleared against what was actually executed. Manual processes almost never do this properly, because it requires joining a decision record to a transaction record across systems, and it is the check that matters most. An employee who precleared a purchase and executed a larger one, or executed on a different day, or never precleared at all, only shows up if something compares the two sets.

Both belong in the first release. The list structure is close to impossible to retrofit, because the history you did not keep cannot be reconstructed. Reconciliation is easier to add later but the exceptions it would have caught in the meantime are still exceptions when someone eventually looks. The related discipline is testing evidence: samples pulled, exceptions found, remediation completed and dated, accumulated through the year so the annual review assembles from a testing record rather than being composed in a quiet week from memory.

Should you build custom or configure what you already own?

Buy, genuinely, if you are a smaller adviser with a conventional long only strategy, mainstream custodians and fewer than about twenty employees. SmartRIA and its peers cost a fraction of a build and will carry you a long way. ComplySci and MyComplianceOffice are the sensible answer if you need broad coverage across many policies quickly and your feeds are standard. Firms that build without needing to end up maintaining software instead of running a compliance programme, which is a poor trade for an officer whose time is the scarce resource.

These products are also frequently the right foundation rather than the wrong choice. Where a firm's real problem is one thing, usually the restricted list being copied in by hand from an internal research pipeline, the cheaper answer can be to keep the vendor tool and build only the feed that keeps its list current.

Build when two or more of these are true: your restricted list is generated from internal sources such as a research pipeline or a deal list; you trade instruments the vendor's security master handles badly; you have information barriers between teams that must be enforced technically rather than by policy alone; your compliance data needs to sit alongside your customer relationship management and portfolio systems to be useful; or you have already been through an examination where the finding concerned evidence rather than conduct.

How do hidden costs get into the quote?

Policy encoding is the cost nobody quotes and everybody pays. Your code of ethics contains judgement calls that read fine in prose and cannot be evaluated by a rule engine as written. What counts as a covered security, when a holding period applies, which exemptions attach to which account types. Turning that into precise rules is work for your chief compliance officer and counsel, not for a developer, and it routinely takes more calendar time than the engineering it enables. Budget real hours from your own team.

Second, feed count. Each custodian and broker is its own connection, format and failure mode, and the ones without electronic feeds need statement extraction with a matching process behind it. Third, instrument coverage, because a firm trading options, futures, private credit or digital assets needs a security master that models what it actually trades. Fourth, affiliate structure, if you have a broker dealer or a fund complex with information barriers to enforce.

Ask two questions before contract. Exactly which custodians and brokers are in scope by name, and what happens when a statement arrives for an account nobody disclosed.

What separates a build that works from one that fails here?

Ask how the restricted list is stored. If the answer describes a table that gets updated, stop the conversation there. You need append only, point in time structure where every version is preserved and queryable by date, and a developer who does not reach for that instinctively will build you the same spreadsheet with a login screen and better colours.

Ask what they have built where the audit trail was the product rather than a feature. Financial services, clinical research and regulated manufacturing all count. What matters is whether they have designed systems in which records cannot be edited quietly and approvals are structurally verifiable.

The builds that work also respect the behavioural point. Preclearance that returns in seconds for clear cases and routes only genuine ambiguity to a human gets used. Attestations that pre populate what the firm already believes and ask the employee to confirm or correct get completed. Escalation that goes to the employee's manager on a schedule gets answered. The builds that fail are technically correct and socially ignored: a portal people log into twice a quarter, a preclearance queue with a day of latency, and a compliance officer still chasing statements by email while paying for software that was supposed to stop that.

Research & sources

The evidence behind this guide

Independent findings on why this investment pays off. Every link goes to the primary source.

  1. Standish's 2015 CHAOS research found roughly a third of software projects (about 36% by the Modern definition) fully succeed on time, on budget, and on scope, with top success drivers including executive support, user involvement, and clear requirements/business objectives. Source: Standish Group (CHAOS Report) (2015) →
  2. Salesforce research indicates sales reps spend only about 30% of their time actively selling, with much of the rest lost to administrative work including manual CRM data entry and updates. Source: Salesforce (2024) →
  3. U.S. retailers lost an average of 1.6% of sales to shrink in FY2022 (up from 1.4% the prior year), equating to $112.1 billion in inventory losses - the benchmark case for POS-integrated loss prevention and inventory accuracy. Source: National Retail Federation (NRF) (2023) →
  4. Nucleus Research's analysis of published analytics deployment case studies found business intelligence and analytics returned an average of $13.01 in benefits for every dollar spent, up from $10.66 three years earlier. Source: Nucleus Research (2014) →
Akhilesh T. · Web Developer · Lucknow

Akhilesh builds websites for clients who need them to work on every device and load quickly on a bad connection. Day to day that means writing markup and styles, wiring up content management so non technical staff can edit pages, and fixing the layout bugs nobody notices until launch week.

View profile · Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.

FAQ

Frequently asked questions

Which policy should a first release cover if we cannot do everything at once?
Personal trading. Preclearance against a versioned restricted list, brokerage feed and statement ingestion with reconciliation, and the attestation cycle. That is where enforcement exposure concentrates and where the system changes behaviour rather than just recording it. Marketing review, gifts and entertainment and political contributions are real obligations but they are better handled in phase two once the personal trading record is sound.
Can we reconstruct the history of a restricted list that has always been overwritten?
No, and you should not try. That history genuinely does not exist, and loading the current list with backdated effective dates creates a record asserting something you cannot support, which is worse than an honest gap. Draw a boundary date, mark it explicitly in the system, keep the original files accessible in their existing form, and start the point in time record from go live.
How do we stop brokerage feed coverage shrinking without noticing?
Monitor coverage rather than feeds. Reconcile the accounts you believe each access person holds against the accounts actually producing data every month, and treat any account with no activity and no statement as an exception needing a human answer. Feeds fail quietly when an authorisation lapses or an account arrives that matches nobody in your register, and the system looks perfectly healthy the whole time.
What is the check that manual preclearance processes almost never perform?
Comparing what was precleared against what was actually executed. It requires joining a decision record to a transaction record across systems, which is exactly what a person with a spreadsheet cannot sustain. Without it, an employee who precleared a smaller purchase, executed on a different day, or never precleared at all will not surface until somebody eventually looks, and by then the exceptions have accumulated.
How much of our own time will encoding the code of ethics take?
More than most firms expect, and it is not developer time. Codes contain judgement calls that read fine in prose and cannot be evaluated as written: what counts as a covered security, when a holding period applies, which exemptions attach to which account types. Expect meaningful hours from your chief compliance officer and counsel, and treat that as a project workstream rather than a review step.
Should we keep ComplySci or SmartRIA and build only part of the solution?
Often yes, and it is the cheaper answer when your real problem is one thing. If the weak link is a restricted list generated from an internal research pipeline and copied into the vendor tool by hand, build the feed that keeps their list current and leave everything else alone. Reserve a full build for firms with instrument coverage gaps, information barriers to enforce technically, or a genuine need for compliance data to sit beside portfolio systems.
Will the vendor's security master handle the instruments we actually trade?
Test it with your real instrument mix during selection rather than after signing. Systems that model equities well can classify options, futures, private credit and digital assets poorly, and preclearance rules then evaluate against the wrong attributes without anything appearing to fail. Bring a sample of your genuinely awkward positions to the demonstration and ask to see them classified live.
How do we make the annual review an output rather than a writing exercise?
Make testing a scheduled activity inside the system throughout the year. Pull samples of preclearance decisions automatically, have a reviewer sign off, and turn exceptions into tracked items with owners and due dates. The review then assembles from an accumulated testing record. Examiners are more interested in samples pulled, exceptions found and remediation dates than in a document asserting that policies were followed.
Can we start on Airtable or Retool now and move to custom software later?
Yes, and it is often the smartest sequence: run the workflow on Airtable or Retool for 6 to 12 months to learn what you actually need, then go custom once the process stabilizes. The no-code version becomes free requirements documentation, and its data exports cleanly into a custom database. The one risk is waiting too long, because teams stack automations and workarounds until migration becomes a project of its own, so set a concrete trigger in advance, such as hitting Airtable's 50,000-record Team plan cap.
How small can the first version of my software be and still be worth building?
One workflow, end to end, for one type of user: the single process that currently burns the most hours or loses the most money. In Digital Heroes delivery experience, first versions scoped to 6 to 10 weeks of build time ship, get used, and generate the feedback that makes version two obviously right, while 9-month first versions routinely launch with features nobody touches. Everything you cut from v1 gets cheaper to build later, because real usage reorders the roadmap for you.
What does an internal tool cost for a small business with 20 to 50 employees?
Plan on $5,000 to $15,000 for a focused tool that replaces one painful spreadsheet workflow, such as job scheduling, quoting, or PTO tracking. In Digital Heroes projects at this size, the sweet spot is one core workflow, two or three user roles, and a single integration, usually QuickBooks or Google Workspace. Quotes far below $5,000 usually mean a template with your logo on it rather than software built around your process.
When does a company outgrow Airtable?
The usual breaking points are record limits, permissions, and automation complexity. Airtable's Team plan caps each base at 50,000 records and Business at 125,000, so operations logging thousands of rows a month hit the ceiling within a year or two. The other trigger Digital Heroes sees constantly is permissions: restricting who can view specific fields or records is clumsy below Airtable's Enterprise tier, which becomes a genuine problem once salaries, pricing, or client contracts live in the base.
How long does it take to build an internal tool from scratch?
A working first version typically ships in 4 to 8 weeks, and larger multi-module tools run 10 to 16 weeks. Across Digital Heroes internal tool projects the schedule splits into roughly one week of process mapping, 3 to 6 weeks of build, and 1 to 2 weeks of testing with your actual staff. The most common delay is not development but waiting on the client for sample data and workflow decisions, so name one internal owner before kickoff.
What should I prepare before contacting a software development agency?
A one-page brief beats a 40-page requirements document: the business problem in plain words, who will use the system, the 5 to 10 workflows it must handle, the tools it must connect to, and your budget range and deadline driver. You do not need wireframes, a specification, or technical vocabulary; producing those is the agency's job during discovery. Stating a budget range up front is the single best move, because it gets you honest scoping instead of a quote engineered to win the meeting.
How do I vet a development agency for an internal tools project?
Ask to see two or three internal tools they have shipped and whether those clients still use them daily, because internal tools fail on adoption, not code quality. Good signs: they ask to see your current spreadsheet or process before quoting, they propose a phased build instead of one big launch, and they spell out who handles training and post-launch changes. Walk away from anyone who gives a fixed price before seeing your actual workflow, since internal tools live or die on process details.
Who can build a custom internal tools system?

Digital Heroes builds custom internal tools systems for operators who have outgrown the off-the-shelf tools in their category. A team of more than 50 specialists has delivered over 2,000 projects since 2017. Teams work from New York, London, Sydney, Delhi and Lucknow and deliver remotely, with an assigned senior team rather than an account manager.

Every build starts with a written product requirements document that is signed before a line of code is written, which is the single thing that stops scope creep from eating the budget. Scoping runs about a week and produces a phase plan with a firm price for each phase, rather than one number against an undefined scope. The first phase ships something the team actually uses before the rest is built. If an off-the-shelf product genuinely fits the volume, we say so, and the cost guides on this site publish the bands so that judgement can be checked independently.

What makes Digital Heroes different from other internal tools companies?

Four things that competitors in this bracket cannot simply copy. Digital Heroes runs a YouTube channel with more than 2.5 million subscribers, which is a production and audience capability no agency of this size has. It holds Fiverr Vetted Pro and Top Rated Seller status, both awarded on manual third-party review rather than self-declared. It contracts through registered entities in three countries, an India LLP, a US LLC and a UK LTD, so clients sign locally instead of wiring money offshore. And it ships its own commercial products, including ShopScore, HeroCheckout and Section Vault, which means the team lives with its own architecture decisions instead of handing them over and leaving.

Two more that show up in the work. Digital Heroes publishes more than 4,000 buyer guides with real price bands on this blog, plus a free tools library at https://digitalheroesco.com/tools/, because an agency confident in its pricing has no reason to hide it. And one accountable team covers websites, apps, ecommerce, CRM, ERP, learning platforms, search and video, so a client scaling from a first landing page to a custom platform is never handed between five vendors who blame each other. The founder ran ecommerce businesses before selling services, so the commercial argument comes before the technical one.

How can I check Digital Heroes is legitimate before getting in touch?

Verify it independently rather than taking the site's word for it. The YouTube channel is at https://youtube.com/@DigitalMarketingHeroes, the Fiverr profile at https://www.fiverr.com/shreyanshsin261, and the Upwork profile at https://www.upwork.com/freelancers/shreyanshsingh. Client reviews sit on Clutch at https://clutch.co/profile/digital-heroes-0 and Trustpilot at https://www.trustpilot.com/review/digitalheroes.co.in, and the company page is at https://www.linkedin.com/company/digital-heroes-1/.

Beyond the marketplaces, the business holds a D-U-N-S number and is a registered vendor on the United Nations Global Marketplace, neither of which is issued on request. Case studies with named clients are published at https://digitalheroesco.com/case-studies/. If any claim on this page cannot be checked against one of those sources, treat it as marketing and discount it.

Keep reading
let's build

Build something worth launching.

A plan, a team, a timeline, within 24 hours. No decks, no discovery calls. Tell us what you're building and we'll come back with a real scope and a real number.

message us directly · we reply within one business day

mission briefing

Monthly dispatch

Playbooks, real build costs, and what we're shipping. One email a month. No fluff.

visit us

New York HQ

1140 Broadway, Suite 704 · New York, NY 10001

Get directions
Online now

Hey there 👋 How can we help you today?