Prudent Documentation

Prudent Documentation

  • Blog
  • Reference

›Extensions

Getting Started

  • What is Prudent?
  • Installing Prudent
  • Overview
  • Opening balances
  • Next steps

Mobile apps

  • Prudent Expenses iOS

Guides

  • Journals
  • Currencies and Commodities
  • Base Currency
  • Price movements
  • Accounts
  • Transactions
  • Calendar
  • Import transactions
  • Import auto-suggest
  • Import memory
  • Dealing with stocks
  • Dealing with properties

Use cases

  • Combining Journals
  • Navigating Accounts
  • Tracking Reconciliation

Extensions

  • OCBC CSV
  • UOB XLS
  • CPF PDF
  • CPF Tabula
  • QIF
  • SG Property Price
  • Standard Chartered CSV
  • DBS/POSB CSV
  • Public Bank CSV
  • Interest
  • Reconciliation
  • Expenses vs Envelope budgeting
  • All extensions

Developers

  • Creating extensions
  • Local Extensions
  • Sharing extensions
  • Creating update extensions
  • Extension creation helpers

Coverage

  • Singapore
  • Banks

Useful

  • Prudent and Ledger
  • Samples

Standard Chartered CSV

Standard Chartered is a multinational bank with presences throughout the world. Get this Prudent add-on to import transactions exported from Standard Chartered online banking in CSV format.

This add-on had been tested with Standard Chartered banking accounts based in Singapore.

Format


Account transactions shown:,01/05/2019 To 01/07/2019

Account Name,Account Number,Currency,Current Balance,Available Balance
Bonus$aver (Online),'5392873823,SGD,"3,130.19 CR","3,130.19 CR"

    Date,Transaction,Currency,Deposit,Withdrawal,Running Balance,SGD Equivalent Balance
                            01/07/2019,WITHDRAWAL,SGD,"","5.00","3,129.92 CR","3,129.92 CR"
                            29/06/2019,CR INTEREST,SGD,"0.17","","3,134.92 CR","3,134.92 CR"
                            15/06/2019,US3PO23424003945IBANKING TRF FROM 0923485333,SGD,"2,300.00","","3,134.75 CR","3,134.75 CR"
                            01/06/2019,WITHDRAWAL,SGD,"","5.00","834.75 CR","834.75 CR"
                            31/05/2019,CR INTEREST,SGD,"0.07","","839.75 CR","839.75 CR"
    

Getting the CSV

  1. Log-on to your Standard Chartered online banking account as usual.

  2. Click on the desired account.

  3. If you want, click on 'Refine search' to adjust the date range you desire.

  4. Click on 'Download & Print' and choose Download as CSV.

Installing the Standard Chartered CSV extension

Find Standard Chartered CSV in Extensions settings, then click on GET.

Importing the CSV

To import the CSV as transactions in your ledger, within Prudent, click on Import, then choose SC CSV.

Point Prudent to the CSV file that you had downloaded and you'll get to a confirmation window.

Sample

sc_sample.csv

Recommended workflow

Download once per month. On the 1st of every month, download the transactions for the previous month.

Note

All product names, trademarks and registered trademarks cited herein are property of their respective owners. All company, product and service names are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

← SG Property PriceDBS/POSB CSV →
  • Format
  • Getting the CSV
  • Installing the Standard Chartered CSV extension
  • Importing the CSV
  • Sample
  • Recommended workflow
  • Note
Prudent Documentation
Docs
Getting StartedCurrencies and Commodities
Community
Join our mailing listTwitter
More
GitHubTerms and ConditionsAcknowledgements