Ana içeriğe geç

Accounting Exports

FaithAdmin can export your financial data in formats compatible with popular accounting software, saving hours of manual data entry.

Supported Export Formats​

QuickBooks IIF​

The IIF (Intuit Interchange Format) file imports directly into QuickBooks Desktop:

  • Donations mapped to income accounts
  • Expenses mapped to expense accounts
  • Fund codes translate to GL account codes
  • Dates, amounts, and descriptions preserved

Xero CSV​

A CSV format structured for Xero's bank transaction import:

  • Compatible with Xero's CSV import template
  • Includes date, description, amount, and account code
  • Handles both income and expense transactions

Generic CSV​

A universal CSV export with GL codes for any accounting system:

  • Date, description, amount, fund code, account type
  • Can be adapted for Sage, Wave, FreshBooks, or any other system
  • Includes all transaction details for maximum flexibility

How to Export​

  1. Navigate to Accounting > Export.
  2. Select the date range for the export.
  3. Choose the export format (QuickBooks IIF, Xero CSV, or Generic CSV).
  4. Click Export.
  5. Download the file and import it into your accounting software.

What Gets Exported​

The export includes:

  • Donations -- All donations within the date range, with fund assignments
  • Expenses -- All recorded expenses with categories and funds
  • Deposits -- Bank deposits with references

GL Code Mapping​

Fund codes from Fund Accounting are used as GL (General Ledger) codes in exports. Ensure your fund codes match the account codes in your accounting software for smooth imports.

Best Practices​

  • Export monthly to keep your accounting software in sync.
  • Reconcile the export totals with your FaithAdmin giving reports before importing.
  • Set up fund codes that match your chart of accounts in QuickBooks or Xero.
ipucu

Do a test export with a small date range first to verify the GL code mapping matches your accounting software before exporting a full year.