Accounting Software Integrations

Export to QuickBooks, Xero, or any software that reads CSV.

Accountant Resources

QuickBooks

IIF-compatible CSV format designed for QuickBooks Desktop and Online. Columns are pre-mapped so you can import without manual adjustment.

Column Mapping
Date, Transaction Type, Reference, Name, Memo, Account, Amount, Currency
How to Import
  1. In QuickBooks, go to File → Utilities → Import
  2. Select CSV and choose the downloaded file
  3. Map columns (most will auto-match) and complete the import

Refunds appear as negative amounts. Both payments and refunds are included in every export.

Xero

Bank statement format compatible with Xero's CSV import. Ready to upload as a statement for reconciliation.

Column Mapping
Date, Amount, Payee, Description, Reference, Transaction Type
How to Import
  1. In Xero, go to Accounting → Bank Accounts
  2. Click Import a Statement on the relevant account
  3. Upload the CSV and review the imported transactions

Each payment appears as an individual line item with the order reference for easy matching.

Generic CSV

Comprehensive format with all transaction details. Works with any spreadsheet application or accounting software that supports CSV import.

All Fields Included
Date, Reference, Description, Category, BTC Amount, Sats, Fiat Amount, Currency, Payment Method, BTC Price at Payment, Cost Basis, Gain/Loss

Open in Excel, Google Sheets, or any spreadsheet application. This format includes every data point SatsRail tracks — ideal for custom analysis or import into specialized software.

How to Export

Exporting is available from the merchant dashboard for any user with the Accountant, Manager, or Owner role.

  1. Navigate to Reports → Export for Accounting in the merchant dashboard
  2. Select your date range using the date picker
  3. Choose your format: QuickBooks, Xero, or Generic CSV
  4. Click Download CSV to save the file
All exports include both payment receipts and refunds. Refunds appear as negative amounts. BTC prices are recorded at the exact time of each transaction.