Data

Tools

Indexes

Applications

Experiments

Open Source Science

rxaf

The 'rxaf' package provides functionalities to read and analyze Dutch XML Audit Files (XAF) in R. These files are commonly used in the Netherlands for financial and auditing purposes.

https://github.com/koenderks/rxaf

Science Score: 44.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (9.1%) to scientific vocabulary

Keywords

audit audit-file dutch finance package r-stats xaf
Last synced: 4 months ago · JSON representation ·

Repository

The 'rxaf' package provides functionalities to read and analyze Dutch XML Audit Files (XAF) in R. These files are commonly used in the Netherlands for financial and auditing purposes.

Basic Info
  • Host: GitHub
  • Owner: koenderks
  • License: gpl-3.0
  • Language: R
  • Default Branch: development
  • Homepage:
  • Size: 1.22 MB
Statistics
  • Stars: 1
  • Watchers: 2
  • Forks: 0
  • Open Issues: 0
  • Releases: 1
Topics
audit audit-file dutch finance package r-stats xaf
Created about 2 years ago · Last pushed 4 months ago
Metadata Files
Readme Changelog License Citation

README.md

rxaf: Read and Analyze Dutch XML Audit Files

The rxaf package provides functionality in R for reading and analyzing Dutch XML Audit Files (XAF), which are used in the Netherlands for financial and auditing purposes.

Installation

You can install rxaf directly from the GitHub repository. To do this, you will need to have remotes package installed on your system. Once you have this package, you can install rxaf by running the following command in your terminal:

```r

install.packages("remotes")

remotes::install_github("koenderks/rxaf") ```

Usage

Here is a minimal working example of how to use rxaf to read and analyze a XAF file:

```r library(rxaf)

Read a XAF file as data.frame

dataset <- read_xaf("https://github.com/koenderks/rxaf/raw/development/tests/testthat/ExactOnline.xaf")

Create a balance sheet or income statement at december 20, 2023

xafbalancesheet(dataset, date = "20-12-2023") # or xafincomestatement(dataset, date = "20-12-2023")

Categorie Nummer Grootboek Saldo

1 Vaste activa en passiva 0110 Personeelsactiviteiten "buitenshuis" 8264.46

2 0300 Gebouwen 16987.60

3 0301 Afschrijving gebouwen -5000.00

4 Subtotaal 20252.06

5 Vlottende activa en passiva 1000 Kas -34358.00

6 1100 Bank 396704.46

7 1290 Kruisposten liquide middelen -11162.00

8 1300 Debiteuren -304220.09

9 1310 Voorziening oninbare debiteuren -1250.00

10 1500 Af te dragen BTW hoog -15898.04

11 1510 Af te dragen BTW laag -649.37

12 1520 Te vorderen BTW 12427.83

13 1600 Crediteuren -60400.00

14 1670 Tussenrekening assurantiën 13250.00

15 1700 Loonheffingen 77059.00

16 Subtotaal 71503.79

17 Tussenrekeningen 2000 Vraagposten 31127.70

18 2100 Netto lonen 2298.54

19 Subtotaal 33426.24

20 Voorraadrekeningen 3310 Voorraad indoor sports -48.17

21 3320 Voorraad outdoor sports -3677.90

22 3330 Voorraad supplementen -155.00

23 Subtotaal -3726.07

24 Totaal 121301.02

Write a XAF file to csv

write.csv(dataset, "example.csv", row.names = FALSE) ```

Owner

  • Name: Koen Derks
  • Login: koenderks
  • Kind: user
  • Location: Amsterdam
  • Company: Nyenrode Business University

Assistant Professor at Nyenrode Business University & Developer at JASP (www.jasp-stats.org), free and open-source statistical software.

Citation (CITATION.cff) 

# -----------------------------------------------------------
# CITATION file created with {cffr} R package, v0.5.0
# See also: https://docs.ropensci.org/cffr/
# -----------------------------------------------------------
 
cff-version: 1.2.0
message: 'To cite package "rxaf" in publications use:'
type: software
license: GPL-3.0-or-later
title: 'rxaf: Read Dutch XML Audit Files (XAF)'
version: 1.0.0
abstract: The 'rxaf' package provides functionalities to read and parse Dutch XML
  Audit Files (XAF). These files are commonly used in the Netherlands for financial
  and auditing purposes.
authors:
- family-names: Derks
  given-names: Koen
  email: koen-derks@hotmail.com
preferred-citation:
  type: manual
  title: 'rxaf: Read Dutch XML Audit Files (XAF)'
  authors:
  - family-names: Derks
    given-names: Koen
    email: koen-derks@hotmail.com
  year: '2023'
  notes: R package version 1.0.0
  url: https://github.com/koenderks/rxaf
repository-code: https://github.com/koenderks/rxaf
url: https://github.com/koenderks/rxaf
date-released: '2023-12-09'
contact:
- family-names: Derks
  given-names: Koen
  email: koen-derks@hotmail.com
keywords:
- audit
- audit-file
- dutch
- finance
- package
- r-stats
- xaf
references:
- type: software
  title: data.table
  abstract: 'data.table: Extension of `data.frame`'
  notes: Imports
  url: https://r-datatable.com
  repository: https://CRAN.R-project.org/package=data.table
  authors:
  - family-names: Barrett
    given-names: Tyson
    email: t.barrett88@gmail.com
  - family-names: Dowle
    given-names: Matt
    email: mattjdowle@gmail.com
  - family-names: Srinivasan
    given-names: Arun
    email: asrini@pm.me
  year: '2023'
- type: software
  title: utils
  abstract: 'R: A Language and Environment for Statistical Computing'
  notes: Imports
  authors:
  - name: R Core Team
  location:
    name: Vienna, Austria
  year: '2023'
  institution:
    name: R Foundation for Statistical Computing
- type: software
  title: xml2
  abstract: 'xml2: Parse XML'
  notes: Imports
  url: https://xml2.r-lib.org/
  repository: https://CRAN.R-project.org/package=xml2
  authors:
  - family-names: Wickham
    given-names: Hadley
    email: hadley@posit.co
  - family-names: Hester
    given-names: Jim
  - family-names: Ooms
    given-names: Jeroen
  year: '2023'
- type: software
  title: testthat
  abstract: 'testthat: Unit Testing for R'
  notes: Suggests
  url: https://testthat.r-lib.org
  repository: https://CRAN.R-project.org/package=testthat
  authors:
  - family-names: Wickham
    given-names: Hadley
    email: hadley@posit.co
  year: '2023'
  version: '>= 3.0.0'

GitHub Events

Total
  • Push event: 2
Last Year
  • Push event: 2

Issues and Pull Requests

Last synced: 7 months ago

All Time
  • Total issues: 0
  • Total pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Total issue authors: 0
  • Total pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels

Dependencies

.github/workflows/delete_runs.yml actions
  • Mattraks/delete-workflow-runs v2 composite
.github/workflows/lint.yaml actions
  • actions/checkout v3 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/r.yml actions
  • actions/checkout v2 composite
  • actions/setup-python v4 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/update-citation-cff.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
DESCRIPTION cran
  • curl * imports
  • reticulate * imports
  • testthat * suggests