ML for GL - Machine Learning for General Ledger
current release: v0.18
next planned release: v0.20 Aug 27, 2023.
Please do NOT download source code until v0.20 release.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!! source code will available v0.20 Aug 27, 2023 !!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
planned feature requests:
v0.20 Bug fixes, enhance ELT, ETL Datawarehouse support
v0.30 real time Visualizations
v0.30 real time null hypothesis
v0.40 Light Graphs/Network science analysis
v0.60 Blockchain distributed ledger
v0.70 bug fixes
v1.00 final stable releaseObjective
GeneralLedger.jl provide a complete Data Science Framework for Finance Data Analytics.
Scope of this package includes General Ledger, Sub-Ledgers, Accounting Analytics & Data Science operations using 
language. GeneralLedger.jl supports analytics using structured data from ERP systems like Oracle, PeopleSoft, SAP, Tally, Intuit, QuickBooks etc.
Finance General Ledger sits at core of ERP systems and supporting sub-ledger/accounting entries/details are necessary to accurately predict/analyze complete General Ledger functionalities.
This site is also available for free as PDF and YouTube Video Tutorials. If you can afford, please consider buying this book from Amazon, Kindle, Google, Apple iBook.
Please consider subscribing 
, following me at 
and giving a star to GitHub GeneralLedger.jl repository.
This package supports all Finance analytical computations for a complete BuytoPay life cycle operation from big ERP systems like Oracle, PeopleSoft, SAP, Tally, Intuit, QuickBooks etc.
I will cover examples from ERP Domains like GL (General Ledger), AP (Accounts Payable), AR (Account Receivables), B2P (Buy to Pay), Expense, Travel & Time, HCM Human Capital Management, CRM etc.
Requisitions -> Orders -> Procurement -> Inventory cycle counting -> Match Exceptions -> Receivables -> Accounts Payable/Billing/Liability -> GL Accounting -> General Ledger book keeping.
Future work : - All sub-ledger/domain specific account will be covered in their own domains like Account Payable.jl, AccountsReceivables.jl, Procurement.jl etc. Procure2Pay.jl, TaxAnalytics.jl
This project is accepting funding/sponsorship proposals.
Table of Contents
- ML for GL - Machine Learning for General Ledger
- Objective
- Introduction
- About General Ledger
- p-value, null hypothesis and real time analytics (onlinestat)
- Open AI ChatGPT
- Machine Learning for General Ledger
- Machine Learning for General Ledger
- ELT vs ETL.jl
- GL ERD
- Finance Data
- GL Processes
- Implementing Graph Theory
- Hypothesis, p - value
- what is a gradient, derivatives, gradients, Jacobians, Hessians
- what is optimization
- ForwardDiff, ReverseDiff
- ChainRules, AutoDiff
- Optimization using gradient
- what is gradient descent
- UAT Universal Approximation theorem
- Linear regression
- Taylor Series
- Fourier Transformation
- Loss function
- Gradient & Gradient Descent
- Curse of Dimensionality
- what is a Neural network
- Neurons
- Why we need layers
- What are activation functions
- Training neural networks
- Predicting results
- p-value, null hypothesis and real time analytics (onlinestat)
- Installing Julia Environment
- on local windows, mac, linux
- on Cloud Windows VM
- on Cloud Linux VM
- run Julia REPL on Cloud Windows, Linux VMs through SSH client
- run Jupyter & Pluto notebook through remote browser
- 5a. How to run & access Jupyter notebook through remote browser
- 5b. How to run & access Pluto notebook through remote browser
- use GitHub to sync your work
- run VS Code on iPad/Tablet devices using coder-server
- Understanding Julia Project, Application, Environment, Package
- Machine Learning for General Ledger
- Natural Language Processing for General Ledger
- Optimization
- Visualizations, Buttons, sliders, filters, n-D plots, plots vs graphs
- Would, Could, Should, What if scenarios
- Income, Cash-Flow & Balance sheet statements
- Dynamic roll ups
- Invoices by Diversity Vendor groups
- Vendor Ranking
- Product Ranking
- Cost per Invoice
- Operating Expenses trend
- Supply chain Inventory Dashboard
- Balance Sheet, Income, CashFlow statement with Stock prices, Stock volume trading
- Probability
- Probability Distributions
- What is a Probability
- Sample space
- Probability space
- Cumulative Probability
- Dependent and Independent events
- Probability axioms
- Probability consequences
- Addition probability
- Marginal probability
- Joint probability
- Conditional probability
- Bayes Theorem
- Permutations and Combinations
- Combinations
- Permutations
- Probability Distributions Functions (PDFs)
- Probability Mass Function (PMF)
- Probability Density Function (PDF)
- Cumulative Density Function (CDF)
- CDF for Discrete variables
- CDF for Continuous variables
- PDF - CDF Relation
- Calculating Probability Distributions on Finance data
- Self Service Analytics
- Statistics
- Statistical Distributions
- Mean, Median, Mode, Average, Weighted average, Expected Value
- Variance, Standard Deviation, Mean Square, Entropy Deviation
- Discrete Probability Distributions
- Bernoulli Distributions
- Binomial Distributions
- Continuous Probability Distributions
- Normal Gaussian Distributions
- Poisson Distributions
- Exponential Distributions
- Geometric Distributions
- Negative Binomial Distributions
- Multinomial Distributions
- variance, standard deviation, mean square, entropy deviation, residual, coefficient, covariance, corelation
- moments, entropy, skewness, kurtosis, entropy
- p value, quantile, quartile
- regression is another blog with optimization
- CLT - Central limit Theorem
- Time Series
- Transformers models
Index
GeneralLedger.DepositGeneralLedger.SubRecordINSMetadataGeneralLedger.SubRecordUPDMetadataGeneralLedger.getArrangedWordsGeneralLedger.getCategoryDataGeneralLedger.getDBConnectionGeneralLedger.getDSNsGeneralLedger.getDriversGeneralLedger.getDuplicateRowsGeneralLedger.getFileGeneralLedger.getFuzzyWuzzyGeneralLedger.getJSONintoDataFrameGeneralLedger.getKeyColumnsGeneralLedger.getMaskedDataGeneralLedger.getPullFilesGeneralLedger.getSQLsGeneralLedger.getSampleBDepositGeneralLedger.getSampleCDepositGeneralLedger.getSampleDataTimeTakenGeneralLedger.getSampleDepositsDataGeneralLedger.getSampleRDepositGeneralLedger.getTokensGeneralLedger.getTreeDataGeneralLedger.getWebLinksGeneralLedger.getXLSinDirectoryGeneralLedger.getXMLintoDataFrameGeneralLedger.runSQLGeneralLedger.setCloseConnectionGeneralLedger.setColNamesGeneralLedger.setRemDuplicateRowsGeneralLedger.setRemoveTextGeneralLedger.setRemoveTokensGeneralLedger.setReplaceText