Coinbase trading journal: statements, recurring buys and perps

Last checked: 8 October 2026. Exchange menus, fees and rules change, so confirm on the exchange’s own site before you rely on them.

Most Coinbase users are not day traders. They buy on a schedule, hold for months, and occasionally trade on Coinbase Advanced. That changes what a journal is for. Instead of grading entries to the tick, you are tracking average cost, the real price of fees on small purchases, and whether the trades you make outside the plan help or hurt.

Export a statement

1. Click your profile picture and open Settings › Accounts › Statements. On mobile it sits under Account and settings.
2. Monthly statements are already there in HTML, PDF or CSV. For a journal, use Generate custom statement instead.
3. Choose the asset (or all assets), the transaction types, and the date range. Pick CSV and generate.

Statements cover the regular Coinbase app and Coinbase Advanced trades. Coinbase’s help pages do not publish the column list, so open the file before you do anything else and look at the header row.

Clean the file before importing

A statement mixes trades with everything else your account did: sends, receives, staking rewards, conversions. Only trades belong in a trading journal.

1. Keep only buy and sell rows. Delete transfers, rewards and deposits. Treat a conversion from one coin to another as a sell of the first and a buy of the second, or leave it out and note it.
2. Rename the headers so the journal’s mapper recognises them: the asset column to Symbol, the buy or sell column to Side, the amount of coin to Quantity, the price per coin to Price, the fee column to Fee, and the timestamp to Time.
3. Check the price column is the price per coin, not the total. If only a total is given, divide it by the quantity.

A file with symbol, side, quantity and price on every row is read as a fill export. The journal pairs buys and sells first in, first out, and the buys you still hold show as an open position.

What a recurring buy really costs

Coinbase Advanced uses maker and taker fees that depend on your 30-day volume, and Coinbase shows your current rates when you are signed in. Use those numbers, not a figure from a blog.

Coinbase futures and perp-style contracts

Coinbase offers derivatives through different entities depending on where you live. Its regulated derivatives, including US perpetual-style futures, are open to eligible customers in the US, Canada and most of the EEA, while Coinbase’s international derivatives serve eligible non-US regions only. Two details matter for a journal:

• Funding is hourly on US perpetual-style futures, paid on the hour, and accrued funding settles to your derivatives cash account on weekdays. A position held over a weekend builds up funding that only shows in your balance on Monday.
• They are not truly perpetual. The US contracts carry a long-dated expiry in December 2030, so the name and expiry on your statement will look different from an offshore perp.

Derivatives statements come from the same Statements area or via Visit Statements on the Orders tab, with a custom report filtered by contract, transaction type and dates, in CSV or PDF. Positions show a funding column. Add the funding for each trade to the journal’s swap field so the net R includes it.

How to judge a Coinbase account in the journal

• Two accounts, not one. Put recurring buys on a long-term account and Advanced trades on a trading account. The All Accounts view combines them when you want one total.
• Tag the off-plan buys. Anything outside the schedule gets a tag. Six months later, filter by it and compare with the scheduled buys.
• Set the cost preset to Spot exchange or Custom with your Advanced taker rate, so trades you log by hand carry realistic fees.