Personal Accounting

Written for the people who keep other people’s books — chartered accountants, tax consultants and family offices carrying hundreds of individuals, each with their own accounts, their own portfolio and their own return to file. It works just as well for one person with a real portfolio and no patience for spreadsheets.

At its heart it is share accounting: broker bills read in, holdings kept lot by lot, and capital gain worked out from the trades. Everything sits in one database: the bank entries, the shares, the capital gain those shares produced, and the computation that gets filed at the end of it. This is the personal edition — the sales, stock and billing screens of the company edition are not shown, so the menus stay short.

Share accounting and portfolio

• Application, allotment, refund, increase, decrease and quantity adjustment — the full life of a holding, not just a buy and a sell
• Total holding and lot-wise holding, market valuation, script ledger and return on investment
• Capital gain regenerated from the transactions rather than typed, with long-term gain and loss as per income tax
• Dividend and interest analysis, speculation statement, maturity reports, investment-business holdings and an all-in-one summary
• Market rates and NAV imported, and scripts imported from BSE
• Transfers between persons and between DPs, with a mismatch report against actual holdings
• Insurance policies per person, with a status report and premium payment and receipt analysis

Broker bills, imported

Contract notes are read straight out of the broker’s own file — no re-typing a hundred trades. Each trade keeps its own date and settlement, so a whole year’s trades go in with one import:

• Ventura (Excel, compact, currency, commodity), Sharekhan (cash, F&O, HTML), Angel (daily contract, summary, F&O), HDFC (HTML and cash Excel), Kotak Securities, Motilal Oswal, Nirmal Bang, Religare, Tradebulls, Sushil Finance, Karmic, Arham, Monarch, Samurai, FRR Shares & Securities and MF Global, plus mutual fund and broker holding imports
• An import either lands completely or not at all

Many people, many years, one program

• Switch person, period, login or date without leaving the program
• Cash, bank, petty cash, journal, debit and credit note entries copied to other persons or carried forward from the previous year, and auto entries for the ones that repeat
• An account master imported from another person, so a shared bank or a family firm is entered once
• Any single person or group exported and imported elsewhere
• Rights per user on every menu, so an assistant sees entry screens and not the computation
• Audited periods locked, selectively or entirely

The daily books

• Cash, bank and petty cash payments and receipts, journal, debit and credit notes, and bank and cash entries imported from Excel
• Ledger, ledger statement, head-wise grouping, cash, bank and petty cash books, journal and note registers
• Bank reconciliation, with opening BRS
• Cheque printing with per-bank settings, bank slip statement and cheques to be deposited
• Narration, cheque book and date range masters, so repeated typing becomes a pick list
• Accounts merged where a duplicate crept in, and multiple delete

Income tax, from AIS to ITR

With the income tax module switched on:

• AIS imported from the portal, as PDF or JSON, and carried into income
• AIS reconciliation against the books — matched, only in books, only in AIS, and major and minor differences counted, so only the mismatches need attention
• Tax computation in one screen: regime, age category and business loss set-off chosen, tax computed, saved and exported
• Long-term capital gain for the computation imported straight from Upstox (realised P&L), Zerodha (Console export) or Groww (capital gains export)
• ITR built from the same data
• TDS entry

Final accounts and audit

• Statement of affairs in V format and T format, two column and three column
• Statement of capital, trial balance, income and expenditure, fund flow, cash flow and cost-centre-wise income and expenditure, and the final accounts as one Excel workbook — balance sheet, profit and loss, capital account, schedules, trial balance and fixed asset schedule
• Loan and balance confirmation, interest calculation, capital investment at a glance, cash withdrawals and deposits, over/below listing, travelling expenses, cost-centre-wise statement, entry list and statistics
• Outstanding statement with aging analysis and aging adjustment

Everyday things

• Document tracker — documents scanned and saved against the entry they belong to
• Reminders per user, shown on startup and at the times you set
• Tally data migrated in — accounts, opening balances, scripts and the daybook
• Every report out as Excel or PDF on a single switch, or straight into a mail
• Every grid filters, sorts, groups and re-orders columns like Excel, and exports as you left it
• Several windows open at once
• Updates arrive automatically, so every machine in the office is on the same version

Technical details

• Front end: Microsoft .NET (VB.NET) on Windows, .NET Framework 4.8
• Back end: Microsoft SQL Server, from SQL Server 2005 through SQL Server 2022
• Output: native Excel and PDF, SMTP mail