Export Transactions from Reports

Run transaction detail from the Reports page, narrow the results to the account or ledger slice you need, and export or print the report for review outside SPRK.

General Ledger report account selector showing account ordering controlled by Preferences

General Ledger report table showing transaction detail columns and column-control gear

When To Use This

Use this workflow when you need transaction-level report detail for an account, subtype, or ledger slice and need to send the results to a client or reviewer as a spreadsheet or PDF.

Before You Start

  • You are signed in to SPRK.
  • The correct active company is selected.
  • The transactions you expect to review are already posted.
  • You know the date range and account you want to report on.

Steps

  1. Open Reports from the left sidebar.
  2. Select the report view that exposes transaction detail:
  • Use General Ledger when you want ledger activity by account for a date range.
  • Use Account Detail when you want detail for one selected account.
  1. Set the date range for the activity you need to review.
  2. Narrow the report before you export:
  • In General Ledger, use the current filter bar as needed: Account Type, Account SubType, Accounts, Vendor, Text, Group By, and Include opening balance.
  • In Account Detail, select the required account and optional text filter.
  • Account selectors follow your Account dropdown sorting preference, so the list may be grouped by account type or shown as a flat A-Z list depending on your saved preference.
  • Supported report selectors are searchable and sorted by their visible labels, but each report still exposes its own filter set.
  1. Select Run.
  2. Review the results before exporting:
  • Confirm the active company is correct.
  • Confirm the date range is correct.
  • Confirm the report rows are limited to the account or ledger slice you intended.
  • Confirm the transaction dates, descriptions, accounts, debits, credits, balances, and any visible dimension columns match the review request.
  1. Use the visible column controls on transaction-detail tables such as General Ledger and Account Detail when you need to hide, show, or reorder review columns before export or print.
  • Treat column controls as a review-scope setting for the current report table.
  • After changing visible columns, open the exported or printed file and confirm it contains the column set you intended.
  1. To create a spreadsheet file for the active report context, select Export.
  2. To create a PDF, select Print, then use the system print dialog to save or print the report as a PDF.
  • If you are working inside a register modal opened from vendor or account-detail review, Export and Print use the modal’s current filtered rows and visible columns, not a broader report package.
  1. Open the exported or printed file and confirm it contains the expected filtered detail before sending it outside SPRK.
  • Current General Ledger CSV exports include Account Code, Account Name, Date, Entry #, Memo, Description, Name, Debit, Credit, and Balance.
  • If the current report includes dimensions in the live table, confirm those dimensions are also present in the exported output where SPRK exposes them.

What Happens Next

SPRK produces an outbound copy of the current report results for review outside the app.

  • Running the report does not post, edit, reverse, or reclassify journal entries.
  • Export and print actions do not change ledger balances.
  • The exported or printed file reflects the report filters in effect at the time you create it, rather than exporting unfiltered rows from other pages of the result set.
  • Transaction-detail column controls change the review table you are looking at; confirm exported or printed output after changing columns.
  • Register-level export and print reflect the open register context and title. They do not post, reverse, or reclassify ledger activity.
  • The visible Reports page exports or prints the active report context. Do not assume SPRK will create a multi-report package unless that action is visible in your app.
  • Report exports are review outputs, not tax filing, payroll filing, or statutory submission workflows.

If Something Looks Wrong

What You See What To Check What To Do Next
You are about to take an action that may affect the result Exporting before selecting the correct active company Confirm the visible company, page, and workflow state before continuing
A needed review step is missing Forgetting to rerun the report after changing the account, type, vendor, text, or date filter Go back to that check before continuing
The result looks ready, but a key check is unresolved Assuming Export creates a PDF Use Print and the system PDF option when you need a PDF
The result looks ready, but a key check is unresolved Assuming Export creates a complete tax package or agency filing Verify the visible SPRK state before continuing
You are about to take an action that may affect the result Sending the file before opening it and confirming the account and date range Confirm the visible company, page, and workflow state before continuing
The result does not match what you expected Hiding or showing report columns and then assuming the outbound file is correct without checking it Review the visible state and use the related workflow before continuing
The page does not show the expected result Expecting an inactive or unavailable account to appear in every account selector Review the visible action or related workflow before continuing
The result looks ready, but a key check is unresolved Assuming another user’s account selector order will match yours if your Account dropdown sorting preferences differ Verify the visible SPRK state before continuing

Troubleshooting

If the account you need is not available in the Accounts filter, or the selector shows No data after you type the account name:

  1. Check Chart of Accounts and confirm the account exists for the active company.
  2. Confirm the account is active.
  3. Confirm the account name or code matches what you are searching for.
  4. Try the other transaction-detail report view, such as Account Detail instead of General Ledger.
  5. Open Preferences and check Account dropdown sorting if the account appears in an unexpected part of the list.
  6. If the account exists and is active but still does not appear in the report filter, check whether it is a nonposting summary account or otherwise restricted from that selector.
  7. Contact support with the company name, account name, account code, report name, date range, and a screenshot of the missing account selector if the account should be eligible but still does not appear.