Billing Bazaar 
How to export reports to Excel and PDF in Vyapar
Your CA, partner or bank may want reports in Excel. Every Vyapar report has export and print icons at the top right.
| Time needed | 2 minutes |
|---|---|
| Steps | 3, each with a screenshot |
| Tested on | Vyapar Desktop for Mac, October 2026 |
| Last updated | 11 October 2026 |
Before you start
- The report open with the right period selected.
1Use the Excel icon on any report
Open the report (for example Profit And Loss) and set the period. Click the Excel icon at the top right to download it; the printer icon prints it or saves it as PDF.
2Party statement: Excel Report
On Party Statement, the buttons are labelled Excel Report and Print.
3GSTR-1: JSON and Excel
The GSTR 1 report also offers a JSON export for uploading to the GST portal, plus Excel and print.
Good to know
- Choose Save as PDF in the print window to get a PDF.
- Exports reflect the filters you set, so check the period first.
- Large Excel files open faster if you export one month at a time.
Questions people ask
How do I export a Vyapar report to Excel?
Open the report and click the Excel icon at the top right.
Can I save a report as PDF?
Yes. Click print and choose Save as PDF.
Can I export GSTR-1 for the GST portal?
Yes. Use the JSON export on the GSTR 1 report.
Related guides
- How to see the profit and loss report in Vyapar
- How to see and share a party statement (ledger) in Vyapar
- How to generate the GSTR-1 report in Vyapar
- How to export data from Vyapar to Tally
Screenshots are from a demo company in Vyapar Desktop for Mac, October 2026. Menus can move slightly between app versions. Guide by Billing Bazaar, a Vyapar partner.