A free trading journal template: one row per trade.

Download the free trading journal template below: a CSV file for Excel or Google Sheets with one row per trade and columns for the account, symbol, side, open and close times, size, entry, exit, gross P&L, commission, swap, fees, net P&L and notes. These are the same fields Journaly records for every trade, and net P&L is gross P&L minus commission, swap and fees.

Trading journal template (CSV)

14 columns, one row per trade. Opens in Excel or Google Sheets.

Download the free template

AccountSymbolSideOpenedClosedQuantityEntryExitGross P&LCommissionSwapFeesNet P&LNotes
Sample accountXAUUSDsell2026-11-10 09:122026-11-10 10:050.52384.002371.60620.003.500.000.00616.50Sample data, delete this row. Your setup and reason go here.
Sample accountEURUSDbuy2026-11-11 14:302026-11-12 09:1511.085001.08380-120.007.000.900.00-127.90Sample data, delete this row.

Sample data: the example rows are made up, not real trades. Delete them before you start.

How to use it

  1. Download the CSV and open it in Excel, or in Google Sheets with File > Import > Upload.
  2. Delete the sample rows. They are made-up examples, not real trades.
  3. When a trade closes, add one row: the account, symbol, buy or sell, open and close times, size, entry, exit and the gross P&L your platform shows.
  4. Add commission, swap and fees as positive numbers. For net P&L, put =I2-J2-K2-L2 in row 2 and fill it down.
  5. Write one line in Notes: the setup and why you took the trade.

What each column means

  • Account: the account the trade was on, such as a prop firm challenge or a personal account.
  • Symbol: the ticker as your platform shows it, such as XAUUSD or NAS100.
  • Side: buy for a long trade, sell for a short one.
  • Opened and Closed: the date and time, written as YYYY-MM-DD HH:MM.
  • Quantity: the position size, in lots, contracts or shares.
  • Entry and Exit: the prices you got in and out at.
  • Gross P&L: the result before costs, negative for a loss.
  • Commission, Swap and Fees: costs, as positive numbers. A swap you were paid goes in as a negative number.
  • Net P&L: Gross P&L minus Commission, Swap and Fees.
  • Notes: the setup, the reason and anything you would do differently.

The faster way

Journaly fills in these fields for you. Say the trade out loud, or send one screenshot of your MT5, MT4 or cTrader history to log up to 30 closed trades. Nothing is saved until you confirm.

Journaly does not import CSV files yet, so this template and the app are separate for now.

Questions.

Journaly

What columns should a trading journal have?

At least the account, symbol, side, open and close times, size, entry, exit, gross P&L, commission, swap, fees, net P&L and a note. This template has exactly those columns, the same fields Journaly records for every trade.

Is the trading journal template free?

Yes. Download the CSV from this page. There is no signup and no email needed.

Does it work in Google Sheets and Excel?

Yes. It is a plain CSV file. In Google Sheets, use File > Import > Upload; in Excel, open the file directly.

How do I work out net P&L?

Net P&L is gross P&L minus commission, swap and fees. With the template's columns, the formula for row 2 is =I2-J2-K2-L2.

Can I import the template into Journaly?

Not yet. Journaly does not import CSV files yet. In the app you log trades by voice, by a screenshot of your MT4, MT5 or cTrader history, or by typing them.

More guides.

Try Journaly on Android today.

The beta is free on Google Play. Three taps, with the Google account you use on your phone:

  1. Join the Journaly testers group (tap “Join group”)
  2. Become a tester (tap “Become a tester”)
  3. Install Journaly from Google Play

Something wrong or missing? Post it on the Feedback board in Profile. Beta testers shape what ships at launch.

On iPhone? Be first in line.

Journaly is on Android now and the App Store is next. Leave your email for the iPhone beta and launch day.

Only launch news. Unsubscribe any time.