Reports & Analytics
Export Options
Learn how to export your VAT data from bVAT in various formats. Export reports, returns, and entries in CSV, PDF, or Excel formats for analysis and record-keeping.
4 min read
Introduction
bVAT provides multiple export options to help you work with your VAT data outside the platform. You can export data in CSV, PDF, or Excel formats, depending on your needs. Exports are useful for:
- Further analysis in spreadsheet applications
- Record-keeping and compliance documentation
- Sharing data with accountants or advisors
- Creating custom reports and visualizations
- Data backup and archival
Available Export Formats
CSV
Comma-separated values format for spreadsheet applications
Use Cases
- Import into Excel, Google Sheets, or other spreadsheet software
- Further data analysis and manipulation
- Creating custom reports and charts
- Data backup and archival
- Sharing data with accountants or advisors
Features
- Lightweight and fast to generate
- Compatible with all major spreadsheet applications
- Easy to parse and process programmatically
- Preserves all data fields and values
- Can be opened in text editors for inspection
Limitations
- No formatting or styling
- Large files may be slow to open
- Date formats may need adjustment in some applications
PDF
Portable Document Format for official documentation
Use Cases
- Official documentation and record-keeping
- Printing reports for physical filing
- Sharing with stakeholders who need formatted reports
- Compliance documentation
- Professional presentation of data
Features
- Professional formatting and layout
- Preserves visual structure and styling
- Can include charts and graphics
- Password protection available
- Universal compatibility across devices
Limitations
- Not easily editable
- Larger file sizes than CSV
- Requires PDF reader software
- Limited data manipulation capabilities
Excel (XLSX)
Microsoft Excel format with formatting and formulas
Use Cases
- Advanced data analysis with Excel features
- Creating pivot tables and charts
- Applying formulas and calculations
- Professional business reports
- Collaborative editing in Excel
Features
- Rich formatting and styling
- Support for formulas and calculations
- Chart and pivot table capabilities
- Multiple worksheets support
- Excel-specific features and functions
Limitations
- Requires Excel or compatible software
- Larger file sizes
- May have compatibility issues with older Excel versions
- Not as universal as CSV or PDF
Available Export Types
VAT Summary
Period summary with input/output VAT totals
Available Formats:
CSV
Location:
Reports > Export tab
Includes:
- Includes period totals for input and output VAT
- Summary statistics and calculations
- Period dates and business information
- VAT payable or credit amount
Vendor Analysis
Detailed vendor transaction analysis
Available Formats:
CSV
Excel
Location:
Reports > Export tab
Includes:
- Vendor-by-vendor breakdown
- Transaction totals and counts
- VAT amounts by vendor
- Purchase location and class information
Input VAT Entries
All input VAT entries with full details
Available Formats:
CSV
Location:
Reports > Export tab or Input VAT page
Includes:
- Complete entry details including dates, amounts, and VAT
- Vendor information and invoice numbers
- Purchase location and class
- Cleared status and notes
- Invoice URLs if attached
Output VAT Entries
All output VAT entries with full details
Available Formats:
CSV
Location:
Reports > Export tab or Output VAT page
Includes:
- Complete entry details including dates and amounts
- Sales totals and VAT amounts
- Rate codes and sales types
- Period information and notes
VAT Return (RET-005)
Complete VAT return in official format
Available Formats:
PDF
Location:
Returns > Preview > Export PDF
Includes:
- Formatted RET-005 return document
- All line items and calculations
- Business information and period details
- Ready for submission or filing
Custom Reports
Generated custom reports
Available Formats:
CSV
PDF
Excel
Location:
Reports > Custom Reports tab
Includes:
- Format depends on report type
- Filtered data based on report criteria
- Includes all selected fields and filters
- Date range or period-specific data
How to Export Data
Export Process
Follow these steps to export your data
1Navigate to Export Section
- Go to the Reports page from the main navigation
- Click on the "Export" tab
- Or use export options from specific pages (Input VAT, Output VAT, Returns)
- Select the type of data you want to export
2Select Export Type and Period
- Choose the export type (VAT Summary, Vendor Analysis, Input VAT, etc.)
- Select the period or date range for the export
- For date range exports, specify start and end dates
- Verify the period contains the data you need
3Choose Export Format
- Select your preferred format (CSV, PDF, or Excel)
- Note: Some export types may only support specific formats
- Consider your use case when choosing format
- CSV is best for data analysis, PDF for documentation
4Generate and Download
- Click "Export" or "Download" button
- Wait for the export to generate (may take a moment for large datasets)
- The file will automatically download to your default download folder
- File name includes export type, period, and date
5Verify and Use Export
- Open the downloaded file to verify contents
- Check that all expected data is included
- For CSV files, ensure proper encoding if opening in Excel
- Save the file in a secure location for your records
Tips & Best Practices
Format Selection
- Use CSV for data analysis and manipulation in spreadsheet software
- Use PDF for official documentation and record-keeping
- Use Excel format if you need advanced Excel features
- Consider file size - CSV is typically smallest, PDF/Excel larger
Data Preparation
- Ensure all data is complete before exporting
- Review entries to verify accuracy
- Check that the selected period contains all needed data
- Consider filtering data if exports are very large
File Management
- Use descriptive file names or rename after download
- Organize exports by period or date in folders
- Keep exports for compliance and record-keeping
- Back up important exports to secure storage
Common Issues & Troubleshooting
Export file is empty or missing data
Verify that the selected period contains data. Check that entries are not filtered out. Try exporting a different period to confirm the issue.
CSV file doesn't open correctly in Excel
Excel may need encoding adjustment. Try opening Excel first, then use Data > Get Data > From File > From Text/CSV and select UTF-8 encoding.
Export is taking too long
Large datasets may take time to export. Try narrowing the date range or period. For very large exports, consider splitting into multiple periods.
PDF export has formatting issues
Ensure you have the latest version of your PDF reader. Try opening in a different PDF viewer. Contact support if formatting problems persist.
Can't find the export option
Export options are available in the Reports > Export tab, or from specific pages like Input VAT, Output VAT, or Returns. Check that you have the appropriate permissions.
Related Articles
Next Steps
Continue your reporting journey with these recommended guides
Report Builder
Or explore other documentation: