Fetching the year from Tally

Fetching reads a year's books out of Tally and into the workspace.

The statement type is already chosen

You chose it at New — Financial Statements (NCE) or Financial Statements (LLP) — and the screen is headed with it. It decides the face, the notes and the classification vocabulary for the year's statements, and it is saved with them. There is nothing to choose again here.

The company

The fetch reads the company the client is linked to, and refuses any other. A client not yet linked is offered the company open in Tally, on a card above the Fetch button; a mismatch names the company to switch to. See Starting a statement.

Choosing the year

Pick the financial year the statements are for. OptiVida asks Tally which years it holds rather than making you remember.

Include the previous year

The ICAI's format requires comparatives, so fetch the previous year too unless these are the entity's first financial statements.

Doing it now is easier than discovering the omission on the Checks sheet later — and it is the only way the prior year's stock reaches the report. Ticking it fetches the previous year as a whole second period, inventory included, which is what fills the Stock PY sheet and Note 24's comparative inventory lines.

What comes across

LedgersWith opening and closing balances, and the year's debit and credit totals

The trial balance itself. The two Transactions columns need connector 0.2.2 or later; on an older connector they stay blank rather than guessed.

GroupsThe whole tree

A ledger's parent group is the strongest evidence of what it is.

Stock itemsOpening and closing valuation

Inventory is not a ledger, so this is the only place opening and closing stock come from — the balance sheet's Inventories line and Note 24's cost of goods sold are both built from it.

Only where the company's accounts are integrated with inventory. A company can track stock in detail and still keep it out of the books; Tally then values nothing from the items, and neither do these statements. If such a company posts its closing stock through a Stock-in-Hand ledger instead, that ledger is the figure — exactly as it is in Tally. The items still appear on the Stock sheet, because Tally holds them — they just do not become an asset the books do not have.

Bills outstanding

For trade receivables and payables.

The company's particulars

Name and financial year, which pre-fill Basic Info.

Tally's own net profit and trial balance totals

Never used in the statements — only compared against them, on the Checks sheet. Tally's Profit and Loss includes the stock movement a trial balance cannot carry, which is what makes it worth checking against.

What moved through the fixed-asset ledgers, and against what

Note 13's additions and deletions. A trial balance nets a purchase and a disposal in the same year into one figure that is neither; the entries behind each ledger keep them apart.

What moved through the cash, bank, reserve and borrowing ledgers, and against whatConnector 0.2.4 or later

For the Ind AS format's Cash Flow Statement and Statement of Changes in Equity. Every entry through a cash or bank ledger comes across with the ledger it was posted against, so a payment against a plant ledger is the purchase of property, plant and equipment, one against an investment is a purchase of investments, and one against a loan is a repayment — each placed by how you classified the other ledger, never by its name. The reserve ledgers' entries fill in the transfers and the dividends on the Statement of Changes in Equity the same way, the borrowings' entries the net debt reconciliation, and each dated debit to a capital work-in-progress ledger the under-a-year band of its ageing. Every figure is a starting point you can overtype, and on an older connector every one of them is simply yours to enter.

What moved through the partners' accounts, and against whatConnector 0.2.3 or later

For the LLP format's notes 3a and 3b. Each partner's capital and current account comes across with its entries, so remuneration credited, interest credited, the share of profit transferred, money introduced and drawings are told apart by the ledger each was posted against — as you classified it. On an older connector the notes are still filled from the ledgers' balances and turnover, with remuneration and interest left for you to type; every figure remains yours to overtype either way.

Two things the fetch deliberately does not do

It does not age your bills

Outstanding bills come across as Tally holds them. Ageing is a judgement, and OptiVida will not make it on your behalf.

It never substitutes zero

Where a figure is absent, it is reported as missing rather than treated as nil. A blank you can see is safer than a zero you cannot.

Fetching again

You can re-fetch at any time — after posting adjusting entries, say.

Fetching again brings the books forward and keeps your work. The balances, groups and supporting schedules come from Tally as they now stand; everything you decided stays: classifications you confirmed or changed, the figures you typed, your non-current splits, the entity and signature details.

Classifications OptiVida made for you — an AI suggestion you have not reviewed, one carried from last year, one a rule proposed — are re-made against the balances that just arrived. That is how a ledger whose balance has flipped since you last looked gets moved off the line it would otherwise net against, and how a rule added since you saved reaches work already in progress.

Afterwards the banner says what moved: how many of your decisions were kept, how many balances changed, how many were reclassified, and anything new or gone.

If Tally will not answer

The workspace says which of the several possible things went wrong, rather than a generic failure. The commonest are Tally closed, no company loaded, or the wrong company open.