Prolecto Labs

Prolecto Labs' mission is to drive continuous innovation to solve NetSuite.

Our mission is to drive continuous innovation to solve NetSuite.

Prolecto Accelerator Templates are pre-built to solve tough NetSuite problems. Our consultants tailor them to fit your business - bridging gaps, streaming workflows, and enhancing system capabilities.

BTC4ERP Crypto Tranche Manager 2.0

https://840889.app.netsuite.com/core/media/media.nl?id=7306622&c=840889&h=oqyCkDQEsUGkkTPAJbEr-eBl8hGO2JDH6_z0Tdf-rEGMILrE&_xt=.svg-BTC4ERP Crypto Tranche Manager 2.0

What It Does

The BTC4ERP Crypto Tranche Manager adds functionality to record the acquisition, transfer, and sale of Bitcoin and other cryptocurrencies in NetSuite.

Why It Matters

For organizations seeking native crypto transaction management in the financial system, the solution offers proper sub-ledger accounting which includes realized/unrealized gain/loss reporting.

Implementation Details

Led by practice: Accounting

Other Data

Build ID 146

Accelerator Versions

Version: 20230626.RC

Stability refinements


Version: 20230512.RC

Minor refinement.


Version: 20230428.RC

  1. Added bundle verify version installation routine. 
  2. Fix truncated processing message on Gain/Loss Batch
  3. Fix wallet group test when performing crypto transfer to prevent movement across wallet groups
  4. Remove extra deployments of Gain/Loss processing jobs
  5. Fix script execution limit on Gain/Loss Preview
  6. Add start and end time parameters to Setup for impairment price lookup
  7. Add warning message to Gain/Loss Preview if sales exceed inventory
  8. Add Impairment on/off configuration to Wallet Group record
  9. Add button to journal entry to allow sale in previous period to be assigned to new Gain/Loss batch


Version: 20221129.RC

  1. Add a feature to calculate realized gain/loss from impaired value instead of treating gain as recoup of impairment loss
  2. Add fix for impairment journal rounding when computing gain/loss on sale
  3. Add fix to crypto lookup to return false if currency is empty
  4. Log exchange rate dates for impairment search
  5. Show refresh button on gain/loss batch form when impairment job queued
  6. Fix missing impairment account error


Version: 20220722.RC

  • Minor UI Refinements for editing tranches
  • Batch enhancements to improve flows of gain/loss controls
  • Avoid clearing accounts when there are no wallet groups
  • Better wallet group handling
  • Consider empty wallet groups when transferring crypto between wallets
  • Detect tranche sales with multiple wallets where we have one gain/losses
  • Fix impairment calculations to handle monthly vs daily inspection
  • Add Coinbase file import handler
  • Add hour offset for brokerage date/time
  • Create tranche split in approved status
  • Handle gain/loss preview when there are more than 1,000 tranches
  • Link to crypto info table versus the hijacked NetSuite native currencies


Version: 20220301.RC

Enhancement for price fetches at the end-of-day rate for impairment testing.


Version: 20220109.RC

Minor revisions.


Version: 20220103.RC

  • Add scheduled script to create an impairment journal entry
  • Enhance Gain/Loss batch to add approvals and run impairment job
  • Add CSV download capability for Gain/Loss Preview
  • Display crypto denomination on the journal entry form
  • Add currency field to the account record and related script to keep it updated
  • Update Tagomi Brokerage RIEM import plug-in to use priced transactions for deposits and withdrawals, if available
  • Update warning message when creating GL entry that tries to transfer Crypto between wallet groups


Version: 20211130.RC

Revisions for minging operations and third-party crypto statement uploads.  Connection to shared Crypto Price Service


Version: 20210827.RC

After working with the bundle since 2014 for client BitPay, repackaged for wider distribution.


All Accelerator Templates are available exclusively to the Prolecto client community.