Exporting Your Data
Finanzapp allows you to export your financial data in multiple formats for analysis, record-keeping, tax preparation, or backup purposes.Available Export Formats
Choose the format that best suits your needs:CSV
Excel
Exporting Transactions
Export your transaction history in your preferred format.Navigate to Transactions
Filter Your Data (Optional)
- Date range (this month, this year, custom range)
- Transaction type (income, expenses, or both)
- Categories (select specific categories)
- Account (if you have multiple accounts)
- Amount range (minimum and maximum)
Click Export Button
Select Export Format
CSV Export
- Best for importing into Excel, Google Sheets, or other software
- Includes all transaction fields in plain text
- Smallest file size
- Easy to process programmatically
PDF Export
- Professional-looking report
- Includes charts and summaries
- Ready for printing or emailing
- Cannot be edited
Excel Export
- Native .xlsx format
- Includes formatting and formulas
- Organized in sheets by category
- Pivot tables for analysis
Download File
- System processes your request
- File is generated (may take a few seconds for large datasets)
- Download automatically starts
- Save the file to your computer
Transaction Export Fields
Exported transaction files include:Basic Transaction Data
Basic Transaction Data
- Date: Transaction date
- Description: Transaction description or notes
- Amount: Transaction amount
- Type: Income or Expense
- Category: Assigned category
- Account: Account name
Additional Fields
Additional Fields
- Transaction ID: Unique identifier
- Created Date: When transaction was added to Finanzapp
- Modified Date: Last edit date (if applicable)
- Tags: Any assigned tags
- Notes: Additional notes or comments
Calculated Fields (Excel only)
Calculated Fields (Excel only)
- Running Balance: Cumulative total
- Month: Extracted month name
- Year: Extracted year
- Weekday: Day of week
- Category Total: Sum by category
Exporting Dashboard Data
Export comprehensive financial reports with visualizations.Access Dashboard Export
Choose Report Type
- Summary Report: High-level overview with key metrics
- Detailed Report: Complete breakdown of all data
- Charts Only: Just the visualizations
- Full Dashboard: Everything visible on your dashboard
Select Time Period
- Current week
- Current month
- Current quarter
- Current year
- Custom date range
Choose Format
- Preserves charts and formatting
- Professional presentation
- Ready to share or print
- Includes raw data and charts
- Editable and customizable
- Great for further analysis
Generate and Download
- Cover page with date range
- Summary statistics
- Income and expense charts (from
index.php:154-189) - Category breakdowns
- Budget performance
- Goal progress
Dashboard Export Contents
Summary Section
Summary Section
- Total income for the period
- Total expenses for the period
- Net balance
- Average daily spending
- Comparison to previous period
Charts and Visualizations
Charts and Visualizations
- Income vs. Expenses chart (matching dashboard display)
- Spending by category pie chart
- Trend line chart
- Budget performance bars
Detailed Breakdowns
Detailed Breakdowns
- Top spending categories
- Largest transactions
- Budget variance analysis
- Goal progress summary
Exporting Goals Data
Export information about your financial goals and progress.Navigate to Goals
Select Export Option
Choose What to Export
- All Goals: Every goal (active, completed, archived)
- Active Goals Only: Currently in-progress goals
- Completed Goals: Achieved goals history
- Specific Goals: Select individual goals to export
Select Format
Download
Goals Export Fields
Goal Information
Goal Information
- Goal name
- Target amount
- Current amount
- Percentage complete
- Target date
- Days remaining
- Priority level
- Category
- Status (active, completed, archived)
Progress Tracking
Progress Tracking
- Required monthly savings
- Actual monthly savings
- On track status
- Projected completion date
- Number of contributions
Contribution History (Excel only)
Contribution History (Excel only)
- Date of each contribution
- Amount contributed
- Running total
- Notes
Scheduled Exports
Automate regular data exports for backups or reporting.Access Export Scheduler
Create New Schedule
Configure Export Settings
- Transactions
- Dashboard summary
- Goals
- All data
- Daily
- Weekly (choose day)
- Monthly (choose date)
- Quarterly
- Date range (last 30 days, last month, etc.)
- Categories to include
- Minimum/maximum amounts
Choose Delivery Method
- Enter email address
- Optional: Add multiple recipients
- Connect Google Drive, Dropbox, or OneDrive
- Choose destination folder
Activate Schedule
Bulk Export Operations
Export selected transactions or data in bulk.Exporting Selected Transactions
Select Transactions
Open Bulk Actions
Choose Export Selected
Pick Format and Download
Export File Formats Explained
CSV Format Details
Structure:- First row: Column headers
- Each row: One transaction/goal/data point
- Comma-separated values
- UTF-8 encoding
- Importing into other financial software
- Data analysis in Excel or Google Sheets
- Creating pivot tables
- Programmatic data processing
- Tax preparation software import
PDF Format Details
Structure:- Cover page with report title and date range
- Executive summary with key metrics
- Visual charts and graphs
- Detailed data tables
- Footer with page numbers and generation date
- Sharing with financial advisors
- Tax documentation
- Printing for physical records
- Email distribution to family members
- Professional presentations
- Include/exclude charts
- Color or black & white
- Page orientation (portrait/landscape)
- Logo and branding (premium feature)
Excel Format Details
Structure:- Multiple worksheets:
- Summary sheet with key metrics
- Transactions sheet with all data
- Charts sheet with visualizations
- Categories sheet with breakdowns
- Goals sheet (if applicable)
- Pre-formatted with:
- Cell formatting (currency, dates)
- Formulas for calculations
- Conditional formatting for easy reading
- Filters on header rows
- Freeze panes for navigation
- Advanced financial analysis
- Creating custom reports
- Building your own charts
- Comparing multiple time periods
- Financial modeling
- Pivot tables for category analysis
- Charts and graphs
- Formulas for totals and averages
- Conditional formatting (red for expenses, green for income)
- Data validation on certain fields
Export Settings and Preferences
Customize how your exports are generated.Default Export Settings
Access Export Preferences
Set Default Format
- CSV
- Excel
Configure Export Options
- MM/DD/YYYY
- DD/MM/YYYY
- YYYY-MM-DD
- 1,000.00
- 1.000,00
- 1 000.00
- Include in exports
- Exclude from exports
- Default to current month
- Default to current year
- Default to custom range
Save Preferences
Advanced Export Options
Encryption
Encryption
- Enable password protection for sensitive exports
- Set a password or generate a random one
- Applies to PDF and Excel formats
Compression
Compression
- Automatically compress exports over a certain size
- Reduces download time
- Useful for year-end exports with lots of transactions
Custom Fields
Custom Fields
- Select specific transaction fields
- Include or exclude certain data points
- Create custom export templates
Export Use Cases
Tax Preparation
Filter to Tax Year
Select Tax-Deductible Categories
- Business expenses
- Charitable donations
- Medical expenses
- Home office
Export as CSV or Excel
Review Before Importing
Financial Review Meeting
Generate PDF Dashboard Report
Include Charts and Summaries
Print or Share Digitally
Data Backup
Export All Data
Choose Excel or CSV
Save to Secure Location
- External hard drive
- Encrypted cloud storage
- Password-protected folder
Schedule Regular Backups
Sharing with Family
Generate PDF Summary
Choose Appropriate Detail Level
Password Protect
Send Securely
Export Limits and Considerations
- Split by date range (export year by year)
- Split by account or category
- Use multiple exports and combine manually
- Contact support for assistance with very large exports
Data Privacy and Security
Export Security
Data Transmission
Data Transmission
- Exports are generated server-side
- Files transferred via HTTPS
- No data stored in temporary locations
- Files automatically deleted after download
Access Control
Access Control
- Only you can export your data
- Session must be active
- Re-authentication required for sensitive exports
Export Logging
Export Logging
- All exports are logged for security
- View export history in account settings
- See what was exported and when
Troubleshooting Exports
Export Fails or Doesn't Start
Export Fails or Doesn't Start
- Check your internet connection
- Try a smaller date range
- Clear browser cache and try again
- Disable browser extensions that might block downloads
- Try a different browser
File Won't Open
File Won't Open
- Ensure you have appropriate software (Excel for .xlsx, PDF reader for .pdf)
- Try opening with different software
- Re-download the file (it may have been corrupted)
- Check if the file was fully downloaded
Data Appears Incorrect
Data Appears Incorrect
- Verify your filters before exporting
- Check date range selection
- Ensure you selected the right account or category
- Review the data in-app to confirm it matches
Scheduled Export Not Received
Scheduled Export Not Received
- Check spam/junk email folder
- Verify email address in settings
- Confirm schedule is active
- Check export history to see if it was generated
- Verify cloud storage connection (if using cloud delivery)
