Reports in Excel and PDF

Which reports are available

All of them come from the same synced Tally data, so a PDF from the app matches what Tally shows for that period.

Excel or PDF: which to send

PDF is for reading and filing: a bank's loan file, a partner who wants the year's Profit & Loss, a supplier asking for a ledger confirmation. It looks the same on every screen and cannot be edited by accident.

Excel is for working: your CA adjusting entries for the final accounts, an accountant ticking a supplier's statement against your ledger, an owner comparing two branches side by side, or a sales manager sorting customers by outstanding. Our guide on signs you have outgrown spreadsheets is a reminder that Excel works best as an output of the books, not a second set of them.

Date ranges across financial years

Reports run for any financial year, and for custom date ranges that span several financial years. That matters more than it sounds. A bank asking for a three-year sales trend, a dispute with a party that goes back eighteen months, or a comparison of this Diwali season with the last one all cross the 31 March line. In Tally that often means opening reports year by year. Here you set the range once. See Tally reports across financial years for the general approach.

Who uses exports

Exports are where the books meet people outside the accounts team. A few typical users:

• Owners sending numbers to banks, investors and family partners.
• Accountants reconciling with suppliers and preparing month-end packs.
• CAs who have been invited with the accountant role, reviewing a client's books.
• Branch managers sharing their branch's figures with head office.
• Purchase staff sending a supplier our ledger for confirmation before a payment.

When several companies sit in one account, the same report can be exported for each company in turn and combined in Excel, which is how many family groups prepare a single view of their firms for a meeting. Keep the same date range for each so the figures compare fairly.

A worked example: the bank renewal

A trader's cash credit limit of ₹50,00,000 is up for renewal and the bank wants the latest Profit & Loss, Balance Sheet, a debtors list with ageing and stock as on the last month-end. Before, this meant a request to the accountant, a wait for the Tally PC, and four separate prints. In Cashflow OS the owner opens each report on the web app, sets the date to 31 October, exports the financial statements as PDF, the debtors ageing and stock summary as Excel, and emails them to the bank the same afternoon. The figures match Tally because they come from Tally. If the bank then asks for the previous year's statements, those take a minute more. For what banks usually ask for, see the business loan documents checklist.

Tips

• Check the sync before you export something important; the report reflects Tally as of the last sync.
• Name files clearly, with company, report and date, before sending.
• Send PDF outside the business and Excel inside it, unless someone specifically needs to work on the figures.
• Use Hindi for partners or family members more comfortable reading it; each person picks their own language.
• Remember roles. A salesperson does not see the company's accounts, so financial reports are not available to that role.

What it does not do

• It does not create audited or certified statements; it exports what is in Tally.
• It does not change the books; corrections are made in Tally, or from the app if writing is switched on.
• It does not file GST returns; GST views and JSON are prepared for filing on the portal.
• It does not show data newer than the last sync from the connector.