CAS to Excel, without uploading the PDF

Sachfolio reads your CAS on your device and saves holdings or transactions as CSV files, which Excel and other spreadsheets open. The PDF is never sent anywhere.

Steps

  1. Open the PDF with Open your CAS and enter its password. Which password?
  2. Go to Save a copy and choose Holdings as CSV or Transactions as CSV.
  3. Open the downloaded file in Excel, Google Sheets or any spreadsheet app.

No account, email or phone number is asked for first. Everything as JSON is also there, for developers.

What is in the files

FileContents
HoldingsOne row per holding: fund house, folio, scheme, ISIN, plan, option, closing units, NAV, value, as of the statement date, with a check column and the page it was printed on.
TransactionsEvery transaction in statement order, with the page it was printed on. Only from a detailed statement; a summary has no transactions.
  • Dates appear twice: as printed (DD-Mon-YYYY) and as ISO (YYYY-MM-DD), so a spreadsheet can sort them.
  • Amounts are plain numbers with no thousands separators. An empty cell means the statement didn't show a value.
  • The files include folio numbers and names exactly as printed. Saved files stay on your device, outside Sachfolio: clearing the app doesn't delete them.

You can also save the rows currently shown in the transaction explorer, and the capital gains files (Schedule 112A and others) from their own sections.

Try it with the sample

An invented statement shows the files without using your own.