Importing Expenses via CSV

Alpha Insights provides a powerful CSV import feature for bulk expense entry. This is ideal for migrating from other systems, importing from accounting software, or adding many expenses at once.

When to Use CSV Import

Accessing the Import Interface

  1. Go to Alpha Insights → Expense Manager
  2. Click Import Expenses from the navigation
  3. You'll see two tabs:

CSV Import Process

Step 1: Prepare Your Data

Your CSV file should include the following columns:

Required Columns:

Optional Columns:

Note: CSV import currently supports one-time expenses only. For recurring expenses, use the manual Add Expense interface.

Step 2: Format Your CSV File

CSV Format Requirements:

Example CSV Content:

title,amount,currency,date_paid,expense_category,supplier,reference
Office Rent,2500,USD,2024-01-01,Operating Expenses,Property Management Co,Invoice-2024-01
Adobe Creative Cloud,52.99,USD,2024-01-15,Software & Tools,Adobe,SUB-2024-01
Marketing Campaign,1500,USD,2024-01-20,Marketing,Agency XYZ,Campaign-Q1-2024
"Office Supplies, Various",145.32,USD,2024-01-25,Operating Expenses,Office Supply Co,Receipt-012524
Employee Salary,3500,USD,2024-01-31,Personnel,,Payroll-Jan-2024

Step 3: Upload Your CSV

  1. Click the CSV Import tab
  2. Click Choose File or drag and drop your CSV file
  3. The system will validate your file format
  4. If errors are found, you'll see specific error messages
  5. If validation passes, you'll see a preview of what will be imported

Step 4: Review Preview

The preview shows:

Step 5: Confirm Import

  1. Review the preview carefully
  2. If everything looks correct, click Import Expenses
  3. The system will process your import
  4. You'll see a progress indicator
  5. When complete, you'll see a success message with:

Manual Bulk Entry

For smaller imports or when you don't have a CSV file ready, use the Manual Bulk Entry feature:

Using Manual Bulk Entry:

  1. Click the Manual Bulk Entry tab
  2. You'll see a form with fields for multiple expenses
  3. Enter each expense:
  4. Click Add Another Row to add more expenses
  5. Click Remove to delete a row
  6. When all expenses are entered, click Import All
  7. Review and confirm

Benefits of Manual Bulk Entry:

Category and Supplier Handling

Auto-Creation

When you import expenses with categories or suppliers that don't exist:

Matching Existing Taxonomies

The import system tries to match categories and suppliers by:

  1. ID: If you provide numeric IDs, it uses exact matches
  2. Name: If you provide names, it searches for exact name matches (case-sensitive)
  3. Create: If no match found, creates new taxonomy term

Best Practice: Use consistent naming to avoid duplicate categories/suppliers. Review the Manage Taxonomies page after importing to merge any duplicates.

Common Import Scenarios

Scenario: Importing from QuickBooks

  1. Export expense report from QuickBooks to CSV
  2. Open CSV in Excel or Google Sheets
  3. Map QuickBooks columns to Alpha Insights columns:
  4. Save as CSV with correct column headers
  5. Import into Alpha Insights

Scenario: Importing from Excel Spreadsheet

  1. Open your expense tracking spreadsheet
  2. Add a header row with Alpha Insights column names
  3. Ensure dates are in YYYY-MM-DD format
  4. Ensure amounts have no currency symbols or thousands separators
  5. Save as CSV (not XLSX)
  6. Import into Alpha Insights

Scenario: Importing Historical Data

When importing years of historical expenses:

  1. Break into smaller files (e.g., by year or quarter) for easier management
  2. Import oldest data first
  3. Review each import before proceeding to next
  4. Verify totals match your source data
  5. Use the export feature to create a backup after each successful import

Troubleshooting Import Errors

Error: "Invalid CSV format"

Cause: File is not a proper CSV or has encoding issues

Solution:

Error: "Missing required column: title"

Cause: Column header is missing or misspelled

Solution:

Error: "Invalid date format in row X"

Cause: Date is not in YYYY-MM-DD format

Solution:

Warning: "Invalid date format, used today's date instead"

Cause: Date couldn't be parsed but import continued using current date

Solution:

Error: "Amount must be positive number"

Cause: Amount contains non-numeric characters or is negative

Solution:

Warning: "Category 'X' not found, created new category"

Not an error: System created a new category automatically

Action:

Import Limits and Performance

File Size Limits:

Processing Time:

Performance Tips:

Post-Import Verification

After Importing:

  1. Check Counts: Verify total expense count matches your expectations
  2. Review Categories: Check Manage Taxonomies for any duplicates
  3. Spot Check: View a few random expenses to verify data accuracy
  4. Check Totals: Compare total amounts to source data
  5. Review Dashboard: Check that metrics updated correctly
  6. Test Filters: Try filtering by category, date, etc. to ensure data is accessible

If Something Went Wrong:

Exporting for Backup

After successful import, create a backup:

  1. Go to Manage All Expenses
  2. Click Export All
  3. Save the CSV file
  4. This serves as a backup and template for future imports

Best Practices for CSV Imports

Before Importing:

During Import:

After Importing:

CSV Template

Here's a template you can copy/paste to get started:

title,amount,currency,date_paid,expense_category,supplier,reference
Sample Expense 1,100.00,USD,2024-01-01,Operating Expenses,Supplier A,INV-001
Sample Expense 2,250.50,USD,2024-01-15,Marketing,Supplier B,INV-002
Sample Expense 3,75.25,USD,2024-01-20,Software & Tools,Supplier C,SUB-2024-01

To use this template:

  1. Copy the above code
  2. Paste into a text editor or Excel
  3. Replace sample data with your actual expenses
  4. Save as CSV
  5. Import into Alpha Insights

Advanced: Programmatic Import

For developers or advanced users, expenses can also be imported via:

Note: Programmatic import requires developer knowledge. See the Developer Documentation for API details.