Accounting Module building

[iLGunners]

Technical queries in this document: https://docs.google.com/document/d/1ESAoVM264Yor1sg8ZBylbuHVtr8J_k1mNq9V7IDuc90/edit

Make sure Accounting Module an actual independent module.

Note: Check #882 after completing this issue.

[iLGunners]

Pages

monetary-account

manage-monetary-accounts

Uses get-account-list { onlyMonetaryAccounts: true }

edit-monetary-account

Uses add-account / edit-account

report-monetary-account-ledger

Called inflow-outflow-statement

Uses get-transaction-list { filterByAccount }

account

manage-accounts

(dynamics to show different UI based on param)

Uses get-account-list { excludeMonetaryAccount: true }

edit-account

Uses add-account / edit-account

report-account-ledger

Uses get-transaction-list { filterByAccount }

transaction

manage-transactions

(dynamics to show different UI based on param. All expenses, All incomes)

Filter by Date Range

Uses get-transaction-list { filterByAccount, filterByNature, fromDate, toDate }

edit-transaction

Dynamics to show different UI based on param -

1. Add an Expense
2. Add an Income
3. Add a Manual Transaction
4. Edit a Manual Transaction

Uses add-transaction / edit-transaction

debt

manage-accounts-receivables

Uses get-transaction-list { filterByAccount, fromDate, toDate }

manage-accounts-payables

Uses get-transaction-list { filterByAccount, fromDate, toDate }

collect-receivable

Uses add-transaction

pay-payable

Uses add-transaction

reports

report-income-statement

report-trial-balance

report-balance-sheet

[iLGunners]

APIs

admin

• [x] admin-setup-accounting-module (made, used, now disabled)

account

• [x] add-account
• [x] edit-account
• [x] get-account-list

transaction

• [x] get-transaction-list (used by report-monetary-account-ledger, report-account-ledger and manage-transactions pages)
• [x] add-transaction
• [x] edit-transaction

[iShafayet]

Changes to existing pages

1. add-products (Add Payables/Monetary Account section)
2. Change name of "Collection Report" to "Sales Collection Report"

[iShafayet]

Changes to existing APIs

1. add-sales
2. add-product-to-inventory
3. add-additional-payment
4. add-organization (Create default accounts)

[iShafayet]

Steps

1. Account and Transaction DB
2. Account API and UI
3. Transaction API and UI
4. Debt Management API and UI (AP, AR)
5. Changes to existing APIs and Pages
6. Reports

[iLGunners]

Hamburger menu content

1. Manage Accounts a. Manage Monetary Accounts (Money Inflow-Outflow Statement) b. Manage Accounts (Ledger)

2. Accounts Receivable

3. Accounts Payable

4. Manage Transactions a. A list of all transactions b. Add a new transaction (expense, income and assets)

5. Accounting Reports a. Income Statement b. Trial Balance c. Balance Sheet d. Collection Report

[iShafayet]

Minor Tasks

• [x] Track createdByUserId for transaction collection.

[iLGunners]

Task 1

[done] a. Manage all transaction hub [done] b. View Journal

Task 2

[done] a. add edit transaction - manual
[done] b. add edit transaction - income, expense, asset

Task 3

[done] a. Monetary account - add, edit, view all (reuse from account) [done] b. Account ledger - view-account-ledger - one for both monetary and standard account

[iLGunners]

Compound Journal Entry

API

1. [Done] Update transaction.js collection
2. [Done] Update existing APIs (3)
3. [Done] Fix account test (if breaking)

Client

1. [Done] Update add and edit transaction pages (total 2 html files)
2. [Done] Update view-transaction-list UI only for single entry
3. [Done] Update view-account-ledger only for single entry

[iLGunners]

Task for 28th March Onward

• [x] add accounting for Cost of Goods Sold and Inventory during product sales

• [x] continue accounting for rest of the spread sheet actions

• [x] add conditional rendering for view-account-ledger and view-transaction-list action button. Disable edit icon for system (and/or compound) transactions

• [x] fix balance calculation in view-account-ledger

• [x] Conditional rendering in view-sales regarding sales discard and return; (Issue #963) Disable Discard if paymentList length > 1 Enable Refund if totalBilled == totalPaidAmount

• [x] Add Auto Generate Organization Specific transaction Number and show on ledger

[iLGunners]

Accounting Report

APIs

• [x] report-income-statement
• [x] report-balance-sheet
• [x] report-trial-balance
• Money Inflow-Outflow Statement [Decide later]

Pages

• [x] report-income-statement
• [x] report-balance-sheet
• [x] report-trial-balance

[iLGunners]

Party in Transactions

• [x] add party object in transaction

• [x] go through spreadsheet and check if system transactions are entering party

• [x] prepare (possibly shared) party selection element / form party type and id for client collectionName and documentId for server

• [x] add party selection to edit-manual-transaction and edit-usual-transaction

[iLGunners]

12th April to-do

• [x] do not allow empty note in transactions min(3), both client and server

• [x] includeOpeningBalance: true param in all get-transaction-list api calls

• [x] issue in api access control if it is a function

• [x] Retained earnings in trial balance