Exporting Account Transactions
How to Export
- Open the Data Exchange Center from the Business menu
- Click Export on the Account Transactions card
- Select the Location from the dropdown. This filters the export to transactions recorded at the selected location.
- The wizard displays the number of transaction records available for export
- Click Export to CSV and choose a save location
What Gets Exported
The CSV file includes one row per transaction entry with the following columns:
| Column | Description |
|---|---|
| Transaction Date | The date the journal entry was recorded |
| Description | The transaction description |
| Debit Account Code | The account code that was debited |
| Credit Account Code | The account code that was credited |
| Amount | The transaction amount |
| Reference | The reference identifier, if one was assigned |
| Payee Name | The payee or payer name, if recorded |
| Notes | Any additional notes attached to the transaction |
Transactions are sorted by date in ascending order. Grouped journal entries (those sharing the same reference) appear as consecutive rows.
Location Filtering
The export is filtered by the location you select. If your business has multiple locations and you need transactions for all of them, you will need to run a separate export for each location.
Common Uses
- Period-end review — Export all journal entries for a given period and share the CSV with your accountant for review before closing the books
- Audit trail — Maintain exported copies of your journal entries as part of your audit documentation
- Backup — Keep periodic exports of your account transactions as a supplementary backup of your financial records
- Analysis — Open the export in Excel to filter by account, date range, or reference number. Use pivot tables to summarize transaction activity by account or category.
- Migration — If you need to move your transaction history to another system, the exported CSV provides a portable format
Understanding the Export Format
Each row in the export represents one double-entry record. For a simple journal entry that debits one account and credits another, you will see a single row. For complex entries that were imported or created with multiple lines sharing a reference, each line appears as a separate row. You can identify which rows belong together by their shared Reference value.
Tips
- Export before closing a period — Once an accounting period is closed, transactions in that period are locked. Export beforehand so you have a working copy for review.
- Use the reference column for filtering — If you assigned meaningful reference numbers to your journal entries (e.g., "PAY-001" for payroll, "ADJ-003" for adjustments), you can easily filter the export in Excel to find related entries.
- Compare with bank exports — Cross-reference your account transaction export with your bank transaction export to verify that all bank activity has been properly recorded in the general ledger.