GO TO... for this page

1. create tx for a ...
   • sale in ...
     • cash 1053-4101 with (cogs 6549-1501).
     • credit 12xx-4101 with (cogs 6549-1501).
   • purchase in ...
     • cash 1501-1052
     • credit 22xx-1052.
   • operation cost in ...
     • cash
     • credit
   • other expense in ...
     • cash
     • credit
   • ...
   • ...
   • ...
   • ...
2. view :
   • sale
     • merchandise !
     • merchandise_to_sale !
     • merchandise_by_selection !
     • merchandise_sold !
   • ...
   • purchase
     • choose item to purchase !
     • merchandise_purchased !
     • ...
     • inventory vs inventory_tracks
     • inventory by selection !
     • ...
   • ...
   • ...
   • create
     • purchase inventory !
     • purchase inventory from items existing!
     • ...
   • ...
   • txs
     • view all !
     • view last 20 !
     • view selecting columns
     • create choosing a tx_type
     • create searching debit
     • ...
   • ...
3. ...
4. ...

---

feature : Financial Statements

1. Obligations
   • Monthly Rent to Agent Paybill 7289985, Account 0052020002878 Verosy Properties. 10k
   • Annual Operating Licence to County Government of Mombasa .../=
   • ...
2. ...
3. Journal Entries,
   • Journal Entries daily!

     select date ...

   • ...
   • Journal Entries monthly!

     select txs_month ...

   • ...
   • Journal Entries between start and end dates!

     select start_date

     select end_date

   • ...
4. ...
5. ledger account one.
6. ...
7. Trial Balance
   for the period ended 30th March 2025

   date_start

   As of at

8. ...
9. Balance Sheet, at this date.
   at this point in time

   date_balance_sheet

10. ...
11. Profit & Loss, start & end dates!
    for the period between ...

    date_start

    As at

12. Cash Flow,
13. ...,

---

feature : analysis;

1. ...,
2. ...,

---

feature : procedures ;

... etc.

1. new inventory!
2. new product!
3. *making a sale !
   • a user logins on with user rights!
   • acccesses the available invetory listing!
   • selects any of the listed available invetory!
   • fills the make a sale form, with quantity, ..., etx!
   • submit form
   • post to create_tx_process.php ...
     1. create a new tx in table:txs.
     2. create new tx_lines for debit and for credit in table:tx_lines.
     3. ...
     4. updates table:inventory ...on inventory decrement!
     5. create new row in table:inventory_tracks!
     6. ...
4. ...
5. ...
6. ...
7. etc

1. **making a purchase !
   • a user logins on with user rights!
   • acccesses the products listing, then selects one!
   • if doesnt exist create one,
   • ...
   • ...

---

feature : table; inventory; CRUD - 'follow the inventory!'

inventory available or un-available !

1. view/select inventory by...
   • select all in cruds/crud !
   • ...
2. create inventory
   • create one.
   • ...
3. ...
4. ...

total all inventory crud

---

feature : table; table: txs; CRUD - 'follow the money!'

my personal money transactions, create one. For each transaction, the total debits recorded must equal the total credits recorded. Total assets must always equal total liabilities plus equity (net worth or capital) of a business.

1. view/select txs by...
   • ...
   • last txs limit of all !
   • ...
   • last txs limit of 20 !
   • ...
   • selecting columns
   • ...
   • Check txs all by date ...
   • ...
2. create ...
   • create by form validate
   • create by choosing a tx_type
   • create by searching debit
   • create vanilla or raw tx !
   • create all tx table fields tx!
3. ...
4. ...

total all txs crud

---

feature : table; accounts ; CRUD - ' '

organized into accounts crud. total

1. search account by name,code,sub_type etx
2. create account, by user-generate account code.
3. create account by auto-generate a
   • expense account code!
   • asset account code!
   • income account code!
   • liability account code!
   • Equity account code!

or better still try AccountService!

---

others ;

feature : maintenance; bugs, extras, tools etc.

1. ...
2. app only backup!
3. db only backup! mariadb-dump -u root ngorano_biz > /data/data/com.termux/files/home/storage/shared/zangu/myApps/ngorano_biz_20250703/ngorano_biz_data/ngorano_biz.sql
4. app + db backup!
5. ...

---

feature : Admistrative

2. database tables :
   • admin rights access!
     • Inventory : crud
     • Inventory Tracks : crud
     • Products : crud
     • Vendors : crud
     • Customers : crud
     • ...
     • Accounts : crud
     • Txs : crud
     • Tx_Lines : crud
     • ...

     • select database table_name ... txs tx_lines accounts inventory

   • user rights access!
     • table: txs; manenos
     • table : tx_lines; CRUD
     • table : accounts ; manenos
     • table : tx_types ; manenos
     • ...
3. analysis :
   • feature: Financial Statements for ie daily txs etx
   • ...
   • feature: txs_extra for ie daily txs etx
   • ...
4. others :
   • others : eg db DUMP
   • ...
5. ...

---

ngorano_hardware_biz v0.1.0 © 2025,