Prajjwal Subedi
HomeAboutAccountingSoftwareCGT DeskLedgerDeskContact

CGT Desk Documentation

Spreadsheet Import Guide

How to map, preview, validate and import Excel or CSV transaction data while preserving source references.

Supported formats

Excel .xlsx, Excel .xls and CSV .csv.

Mandatory mappings

  • Transaction Date
  • Action
  • Share / Asset Code
  • Quantity

Some transaction types require additional mappings, such as the received asset and quantity for a crypto swap.

Import stages

  1. Select source.
  2. Match headings.
  3. Normalize and validate.
  4. Review duplicates.
  5. Import after a before-import backup is created.

Live preview

The heading-matching step displays the first 10 normalized transactions. Changes to mapping selections immediately refresh the preview and clear the confirmation checkbox until the revised mapping is reconfirmed.

Source audit trail

Imported transactions can preserve original filename, source row, transaction reference, account link and statement reference for later drill-down and review.