Investment Adviser Compliance Software Problems: The 7 That Surface During an Examination, and How to Avoid Them
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.
The evidence behind this guide
Independent findings on why this investment pays off. Every link goes to the primary source.
- 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) →
- 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) →
- 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) →
- 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 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.
Frequently asked questions
Which policy should a first release cover if we cannot do everything at once?
Can we reconstruct the history of a restricted list that has always been overwritten?
How do we stop brokerage feed coverage shrinking without noticing?
What is the check that manual preclearance processes almost never perform?
How much of our own time will encoding the code of ethics take?
Should we keep ComplySci or SmartRIA and build only part of the solution?
Will the vendor's security master handle the instruments we actually trade?
How do we make the annual review an output rather than a writing exercise?
Can we start on Airtable or Retool now and move to custom software later?
How small can the first version of my software be and still be worth building?
What does an internal tool cost for a small business with 20 to 50 employees?
When does a company outgrow Airtable?
How long does it take to build an internal tool from scratch?
What should I prepare before contacting a software development agency?
How do I vet a development agency for an internal tools project?
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.