All templates
For crypto finance teams, Web3 accountants & digital asset controllers

Generate your Bitwave crypto gain and loss report every week automatically

Every Monday, WebRun opens Bitwave, pulls the realized gain and loss figures for the previous week broken down by asset and wallet, and appends a structured row to your Crypto P and L Google Sheet so your finance team has a rolling weekly view of taxable gains and losses without manual exports.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:00 AM WebRun
1 Bitwave pull realized gain and loss by asset and wallet
2 Google Sheets append weekly P and L summary row
Run a sample
In short

How can I automatically generate a weekly crypto gain and loss report from Bitwave?

WebRun opens Bitwave every Monday, pulls realized gain and loss figures for the prior week broken down by asset and wallet, and appends a structured row to your Crypto P and L Google Sheet. Your finance team has a rolling weekly P and L view built from live Bitwave data without manual exports or formatting work.

  • Weekly gain and loss figures available every Monday without manual exports
  • Rolling P and L sheet built from live Bitwave data
  • Cost basis method tracked on every row for full audit traceability

Built for crypto finance teams · Web3 accountants · digital asset controllers · crypto tax professionals

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.bitwave.io in a real browser with your saved login - no setup, no API keys.

  2. 1
    Bitwave - pull realized gain and loss by asset and wallet
    bitwave.io How to Automate Bitwave
    WebRun in Bitwave: pull realized gain and loss by asset and wallet
    WebRun opens Bitwave to pull realized gain and loss by asset and wallet.
    • Open Bitwave and navigate to the Gain and Loss report
    • Set the date range to the prior calendar week
    • Read the realized gain and loss figures by asset and wallet
    • Note the cost basis method in use (FIFO, LIFO, or Specific Identification)
    • Flag any asset with a data-quality warning in the report

    Done when All realized gain and loss figures for the prior week are collected and verified.

  3. 2
    Google Sheets - append weekly P and L summary row
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: append weekly P and L summary row
    WebRun opens Google Sheets to append weekly P and L summary row.
    • Open the Crypto P and L Google Sheet
    • Append a new row with the week ending date, realized gains total, realized losses total, and net figure
    • Add a per-asset breakdown tab for the week if one does not exist
    • Note any data-quality warnings in the comments column

    Done when The weekly P and L row is appended and the per-asset breakdown is ready for review.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.bitwave.io
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Gain and loss summary · Google Sheets
OutputWhat each run produces - A weekly row appended to your Crypto P and L Google Sheet with realized gains, losses, and net by asset and wallet.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Which cost basis method does it use for the gain and loss figures?

It reads whichever cost basis method is configured in your Bitwave account, such as FIFO, LIFO, or Specific Identification, and notes the method on each sheet row so the figures are always traceable.

Does it include unrealized gains and losses?

By default it reports realized gains and losses only. If you also want unrealized figures, tell WebRun during setup and it will add a separate unrealized column to the sheet.

Will it file or submit anything to a tax authority?

No. WebRun writes the gain and loss data to your Google Sheet for review. Any tax filing or submission is drafted for your accountant to approve before it goes anywhere.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.