Skip to calculator

Reconcile a forex trade from the ticket values you hold.

Enter the quoted prices, base-unit exposure, pip size, reporting conversion and costs yourself. The worksheet does not load rates, infer lots or recommend a trade.

Private in your browserBuy or sell P&LLocal PDF and data exports

Values from one ticket or statement

Keep the price convention consistent: quote-currency units per one base-currency unit.

Quote units for one base unit.
Copy actual units; do not convert from a “lot” unless your statement defines it.
Used only to display pip movement and pip value.
Enter 1 when the quote and reporting units are the same.
Commission, swap, spread or slippage only if not already embedded in entry/exit prices.

Statement reconciliation

Net P&L in reporting unit—
Net P&L in quote currency—
Gross P&L in quote currency—
Entered costs in reporting unit—
Signed pip movement—
Pip value in quote currency—
Opening notional in quote currency—
Conversion direction used—

Do not double-count spread or slippage already reflected in the entry or exit price. Compare this result with the broker statement; taxes, financing and platform adjustments not entered here are excluded.

Formula and units

Buy gross P&L = (exit − entry) × base units. Sell gross P&L = (entry − exit) × base units. Net P&L subtracts entered non-negative costs, then multiplies by your quote-to-reporting conversion.

No pip or lot assumptions

Pip size varies by instrument and venue, while “lot” and contract definitions can differ. Copy the pip size and actual base-unit exposure from the same ticket or specification.

Privacy and evidence

Calculations and exports run locally. Do not enter account numbers, names or login details. Retain the dated ticket, broker statement and fee breakdown as the evidence source.

Decision boundary

This is a reconciliation estimate, not trading or investment advice, a live quote, broker endorsement, leverage recommendation, margin calculation, tax result or profitability forecast.

Forex statement questions

Why must I enter the reporting conversion?

The trade P&L is naturally in the quote currency. An explicit “reporting units per one quote unit” rate prevents hidden conversion direction assumptions.

Can costs turn a gross gain into a net loss?

Yes. The worksheet subtracts every separately entered cost even when gross P&L is positive.

Does the pip result determine profit?

No. Pip movement is a display derived from your entered pip size. Monetary P&L comes directly from price movement and base units.