Applicable in Singapore (for Singaporeans and permanent residents), CPF (Central Provident Fund) is a compulsory comprehensive savings plan administered by the Central Provident Fund Board. It is an employment based savings scheme with employers and employees contributing a mandated amount to the Fund.
Get this Prudent add-on to import transactions exported from "my cpf Online Services" to PDF then extracted via Tabula.
The import process described here involves extraction of table data with Tabula first before importing to Prudent. The CPF PDF extension can import the PDF exported by CPF directly but can only work on Windows and only support import of one page of transactions at a time. This CPF Tabula extension supports importing of multiple pages at the same time.
Getting the PDF
Log-on to "my cpf Online Services" as usual.
Choose My Statement
Go to Section B, select Transaction History up to the last 15 months and specify the period of interest, then click on Proceed:
- At the top of the Transaction History table that will be shown, there is a link to download the PDF.
Installing the CPF Tabula extension
Find CPF Tabula in Extensions settings, then click on GET.
Tabula is an open source tool for liberating data tables locked inside PDF files and can be downloaded here.
Extracting transaction information via Tabula
From Tabula, browse to the PDF file you'd downloaded and click on
Then click on
Tabula will then highlight the table area that will be imported.
Slightly move the table section highlighted to start from the first transaction data. The autodetect function includes part of the header which we don't need.
Do the same for the other pages.
Once you're done, click on
Preview & Export Extracted Data.
Preview of Extracted Tabular Data page, check that all the data to be extracted looks ok.
Make sure you choose
Stream extraction method for all pages.
JSON (Data) for the Export Format selection.
If all is OK, click on
Export to get the file ready for import to Prudent.
Importing the JSON
To import the JSON as transactions in your ledger, within Prudent, click on Import, then choose CPF Tabula.
Point Prudent to the PDF file that you had downloaded and you'll get to a confirmation window that looks similar to this:
If employed, download once a month on the day after employer contribution to CPF for the previous month. This day is usually regular and can be seen in the "Last Contribution" section of "my cpf Home".
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.