Mualinadya Paramita, . and Ambajeng Wahyu Wijiatningrum, . and Nada Nazihah, . (2026) SISTEM ADMINISTRASI INVOICING BERBASIS EXCEL VBA UNTUK OTOMASI DATA IMPOR PADA SKEMA CORETAX. Tugas Akhir thesis, Universitas Pembangunan Nasional Veteran Jakarta.
![[img]](http://repository.upnvj.ac.id/style/images/fileicons/text.png) |
Text
ABSTRAK.pdf Download (137kB) |
|
Text
AWAL.pdf Download (2MB) |
|
Text
BAB 1.pdf Download (131kB) |
|
Text
BAB 2.pdf Restricted to Repository UPNVJ Only Download (3MB) |
|
Text
BAB 3.pdf Restricted to Repository UPNVJ Only Download (181kB) |
|
Text
BAB 4.pdf Restricted to Repository UPNVJ Only Download (99kB) |
|
Text
DAFTAR PUSTAKA.pdf Download (95kB) |
|
Text
RIWAYAT HIDUP.pdf Restricted to Repository UPNVJ Only Download (441kB) |
|
Text
LAMPIRAN.pdf Restricted to Repository UPNVJ Only Download (1MB) |
|
Text
HASIL PLAGIARISME.pdf Restricted to Repository staff only Download (6MB) |
|
Text
ARTIKEL KI.pdf Restricted to Repository staff only Download (1MB) |
Abstract
This research aims to develop an Excel VBA-Based Invoicing Administration System to automate the process of importing transaction data into the Coretax schema for Micro, Small, and Medium Enterprises (MSMEs). The implementation of the Coretax system by the Directorate General of Taxes has brought significant changes by mandating an Extensible Markup Language (XML)-based data format. However, limited technological understanding and the subscription costs of commercial applications remain the primary obstacles for MSMEs in meeting this new standardization. As a solution to these issues, the TAXIVO application was designed utilizing the Microsoft Excel platform with a Binary Workbook (.xlsb) format and Macro VBA programming. The evaluation method used in this study was Black Box Testing to examine the functionality of all system features. Based on the testing results, the TAXIVO application successfully functions according to requirements in managing tax administration processes offline. The system successfully integrates the sales database, executes automatic validation on the 16-digit NPWP (Taxpayer Identification Number) structure, and instantly transforms all transaction data records into a valid XML schema format in accordance with tax authority standards without requiring any additional costs.
| Item Type: | Thesis (Tugas Akhir) |
|---|---|
| Additional Information: | [No.Panggil: 2310102019] [Pembimbing: Masripah] [Penguji 1: Murdhaningsih] [Penguji 2: Yongky Rangga Yuda Nugraha] |
| Uncontrolled Keywords: | Invoicing, Excel VBA, Automation, XML, Coretax, MSMEs. |
| Subjects: | H Social Sciences > HF Commerce T Technology > TK Electrical engineering. Electronics Nuclear engineering |
| Divisions: | Fakultas Ekonomi dan Bisnis > Program Studi Akuntansi (DIII) |
| Depositing User: | MUALINADYA PARAMITA |
| Date Deposited: | 23 Jul 2026 03:57 |
| Last Modified: | 23 Jul 2026 03:57 |
| URI: | http://repository.upnvj.ac.id/id/eprint/51099 |
Actions (login required)
 |
View Item |