Reports

Run profit and loss, balance sheet, cash flow, trial balance, ageing, Schedule III, GST and TDS reports, export CSV, or build one CA pack.

Eight reports come from your books. Each is a link you can share.

Before you start: you need Can view under Accounting ledger. Reports read one currency at a time, so use the Currency selector if you have several.

Steps

  1. Open Accounting › Reports. To give your accountant every report for a period in one file, choose CA pack; see Move from Tally and send books to your CA.
  2. Pick Profit & loss, Balance sheet, Cash flow, Trial balance, Ageing, Schedule III, GST returns or TDS. Profit and loss report
  3. Set the dates and read the table.
  4. Click Export CSV to download it.

Profit & loss

  • Set From (starts at 1 January this year) and To (today).
  • Shows Income, Expenses and Net profit (or Net loss).
  • CSV file: profit-loss-<currency>-<from>-<to>.csv, with columns Section, Code, Account, Amount.

Balance sheet

  • Set As of (today).
  • Shows Assets, Liabilities, Equity and Profit not yet closed to equity, then Liabilities + equity.
  • A badge says Balances when assets equal liabilities plus equity plus that profit line, otherwise Does not balance.
  • CSV file: balance-sheet-<currency>-<date>.csv.

Cash flow

Where cash came from and went over the period — operating, investing and financing — ending with a check against your actual cash and bank balances (Matches cash and bank or Does not match). See Cash flow statement.

Trial balance

  • Lists every account's total Debit, Credit and Balance to date. The totals row shows In balance when debits equal credits.
  • It has no date filter. It fills in as entries are posted.
  • CSV columns: Code, Account, Kind, Debit, Credit, Balance.

Ageing

Who owes you and whom you owe, by customer or supplier, split into Not due, 0–30, 31–60, 61–90 and Over 90 days, with each party's statement one click away. See Receivables and payables ageing.

Schedule III

The balance sheet and the statement of profit and loss in the format of Schedule III (Division I) of the Companies Act, 2013, with the previous year beside each figure. Set the dates and currency, then click Download PDF.

Each account is placed on a Schedule III line from its kind and name. To place one yourself, give accounts a Schedule III line field — click Add a "Schedule III line" field to accounts (needs permission to add fields) and pick the line on the account.

Above the statements, the report lists what to check:

  • Accounts placed by kind only — nothing in the name said which line, so the account went to its kind's catch-all line. Pick a Schedule III line if that is wrong.
  • Accounts left out of both statements — they have no account kind. Set the kind in the chart of accounts; until then the balance sheet will not balance by their amount.

Important: the report does not include notes to accounts or earnings per share. Have your CA check the line mapping before you use it for filing.

GST returns

GSTR-1 and GSTR-3B for a month, built from your issued GST documents, with Portal JSON, Excel and CSV downloads. See GST returns.

TDS

Two registers, picked at the top:

  • Deducted on bills — TDS you deducted from suppliers on issued purchase bills: date, bill, supplier, PAN, section, the amount the TDS was worked out on (Paid on) and the TDS.
  • Deducted by customers — TDS your customers deducted from your invoices, with the Form 16A certificate number.

Set From and To. The register is summed by month and section — the figures you deposit and reconcile against Form 26AS — with each bill or invoice listed below. Click CSV to download it. See TDS and reverse charge.

Two more reports compare your books by branch or project and against a budget. See Cost centres, projects and budgets.

Tips

  • Accounts without a kind are listed in a yellow warning ("N accounts have postings but no kind") and left out of the profit and loss and balance sheet. Give them a kind in the chart of accounts.
  • Amounts keep their exact decimals in the CSV.
  • The report you open is in the page address, such as /apps/accounting/reports/balance-sheet, so it can be bookmarked.

Troubleshooting

"The report could not be loaded" Click Retry.

Balance sheet says Does not balance Usually an unclassified account. Fix the kind and re-run.