Monday, January 21, 2013

e-SPT related

F.A.Q eSPT PPN

Edit file .txt utk ganti masa (misal: 2013 ke 2014) sebelum di-import ke e-SPT
Buat copy dari file txt tsb
Jalankan Excel
Buka file txt, pastikan Text Import Wizard muncul
Pilih "Delimited" \ Semicolon
Pastikan format=Text utk kolom "NPWP Lawan Transaksi" dan "Masa Pajak"
Finish
Pastikan kolom numerik tetap benar (pemisah ribuan dan desimal)
Lakukan perubahan yg diinginkan (misal: ubah "Tahun Pajak" jadi 2014)
File \ Save As \ pastikan type = "CSV (Comma delimited)"
Lewat Explorer, ubah extension file dari .csv menjadi .txt

Create new database:
Go to folder Program Files \ DJP \ ... \ Database
Make duplicate of empty database file and rename it to something like 'my company.mdb'
Follow instruction on Help \ ... \ Connect to Database \ Setting Database untuk Multi NPWP
... on file selection step, point to 'my company.mdb' file previously created


No comments:

Post a Comment