Moneybox Capital Gains Tax Calculator

    How to upload your Moneybox transaction history and calculate CGT on taxable investments.

    Updated 12 October 20264 min readChecked against published GOV.UK/HMRC guidance

    Published by FiscalFox · Editorial accountability: Grant Christopher Sloane

    Moneybox is popular with UK investors using stocks and shares accounts, ISAs, LISAs and pensions. For capital gains tax, the relevant data is the taxable General Investment Account activity outside an ISA or pension wrapper. FiscalFox reads the Moneybox transaction history, imports every purchase and sale with its units, ISIN and net cash, and applies HMRC's same-day, 30-day and Section 104 share matching rules.

    How to prepare your Moneybox file

    Use the transaction history for your General Investment Account rather than a valuation, statement summary or holdings snapshot. Choose a date range that starts before your first investment and runs through 5 May after the completed tax year ends. This supplies the Section 104 pool history and purchases within 30 days of year-end sales; the report still covers only the selected year.

    1. Open Moneybox and go to your General Investment Account.
    2. Download its transaction history as an Excel file, starting before your first investment.
    3. Check that the file includes TransactionDate, Details, MoneyOut, MoneyIn, Balance and Type columns.
    4. Upload the file unchanged to FiscalFox and select Moneybox as the broker.

    FiscalFox only imports taxable trades and income

    ISA, Lifetime ISA and pension accounts are outside CGT, so only upload your General Investment Account history. Deposits, withdrawals and platform fees are not trades and are left out.

    Once the file is ready, open the FiscalFox calculator, choose Moneybox, and upload the Excel file. FiscalFox parses the file in your browser where possible. A copy is also kept privately for support and troubleshooting, whether or not you are signed in, normally for 14 days, with the exceptions explained in our privacy policy.

    File format details

    The Moneybox transaction history lists every cash movement in the account, one row each:

    • TransactionDate - the date used for share matching
    • Details - for a trade, the units, fund name, ISIN, price and net cost or net proceeds
    • MoneyOut and MoneyIn - the cash paid or received, checked against the trade details
    • Type - Buy, UnitSell, CashSell, BuyReversal, Dividend, InterestPaid, fees, deposits and withdrawals
    • Balance, IsBuyOrSell and IsConfirmed - account balance and status flags

    How FiscalFox processes Moneybox data

    FiscalFox reads each purchase and sale from the Details text, for example a purchase of 6.72 units at £1.06 with a net cost of £7.10. The net cost or net proceeds is the GBP figure used for CGT, and the per-unit price is that amount divided by the units. Trades are pooled by ISIN, so a fund that Moneybox renames stays in the same holding.

    FiscalFox checks each trade's net cash against the MoneyOut or MoneyIn figure on the same row. If they differ, the trade is held for review instead of being used silently. The final report shows the disposal proceeds, matched acquisition cost, gain or loss, and the HMRC rule used for each sale.

    Common Moneybox upload issues

    Only ISA or pension history

    If the file is for a Moneybox ISA, Lifetime ISA or pension, FiscalFox will not import any CGT transactions. That is expected: those wrappers are outside capital gains tax.

    History starts too late

    If the file starts after your first purchase, a sale can look larger than the units you hold. Download the history again from before your first investment so every acquisition is included.

    Cancelled purchases

    A purchase reversal cancels the purchase it names. FiscalFox removes that purchase from the pool. If the reversed purchase is not in the file, the upload stops so you can download a longer history.

    Supported transaction types

    Moneybox RowHow FiscalFox Uses It
    BuyAdded to the Section 104 pool for that fund's ISIN
    UnitSell or CashSellTreated as a disposal and matched using HMRC share matching rules
    BuyReversalRemoves the cancelled purchase it names
    DividendImported as dividend income
    InterestPaidImported as cash interest, which is savings income
    Fees, deposits and withdrawalsLeft out because they are not trades or allowable costs

    Frequently asked questions

    Does FiscalFox support Moneybox?

    Yes. FiscalFox reads the Moneybox transaction history Excel file for your General Investment Account and imports every purchase, sale, dividend and cash interest payment.

    Which Moneybox file should I upload?

    Upload the transaction history Excel file for your Moneybox General Investment Account. It has TransactionDate, Details, MoneyOut, MoneyIn, Balance and Type columns. An order history workbook with Investment, Date, Order Status, Account, Buy/Sell, Quantity and Cost/Proceeds columns is also accepted.

    Do Moneybox ISA or pension investments count for CGT?

    No. Gains inside a Moneybox ISA, Lifetime ISA or pension are not chargeable to UK capital gains tax, so FiscalFox leaves those accounts out.

    How does FiscalFox match Moneybox funds?

    Each purchase and sale in the Moneybox transaction history names the fund and its ISIN. FiscalFox pools trades by ISIN, so a fund that Moneybox later renames stays in the same Section 104 pool.

    Official UK tax references

    This guide is checked against published GOV.UK and HMRC material. FiscalFox is a calculation tool, not personal tax advice; review unusual transactions with a qualified adviser.

    Ready to calculate your capital gains?

    Upload your broker files and generate reviewable SA108 supporting reports. Start free.