Report of accounting system

Job ID: 33792404

Budget: $10 – $30 USD

we want to obtain report about the predefined accounts in our system
the report contain how much cashes passes through the account
there four main classes using the account to pass cash
1- transaction contain account in and account out
2- liquidation contain liquidation line that have account
3- invoice contain invoice line that has item that has account
4-payment contain payment line that has item that has account
we want to sum the input from invoice and transaction and minus it from the output of the sum of liquidation , payment and transaction
we want query or eloquent statement
we will provide copy of the required tables
Related categories: PHP Accounting MySQL Laravel