Skip to main content

Transactions by Account

The Transactions by Account Report in Fiskl offers a comprehensive view of all transactions across all accounts over a specified period. This unified report is especially powerful for businesses managing multiple currencies, providing detailed insights with unparalleled granularity in transaction details.

Why is the Transactions by Account report important?

The Transactions by Account report is essential because it:

  • Offers a detailed view of all transactions for selected accounts
  • Provides multi-currency support at an unprecedented level of detail
  • Helps track and reconcile transactions across different currencies
  • Allows for in-depth analysis of account activity over time

Key Features of the Transactions by Account Report​

This report stands out for its comprehensive multi-currency support:

  • Multiple currency views: See the original currency amounts, ledger account currency, and base (accounting) currency
  • Detailed transaction breakdown: View gross amount, net amount, and tax amount for each transaction (per respective currency)
  • Exchange rate information: Includes FX rates for easy currency conversion tracking

Generating a Transactions by Account Report in Fiskl​

To create and customize your Transactions by Account report:

  1. Go to Accounting > Reports from the left menu and select "Transactions by Account"
  2. Use the account selector to choose all accounts or specific ones
  3. Set your desired date range
  4. Customize your report using the available options:
    • Switch between Cash and Accrual accounting methods
    • Toggle between summary and detailed views
    • Divide large numbers by 1000 for easier reading
    • Hide empty accounts (those with no transactions in the selected period)
    • Show or hide opening and closing balances for each account

Customizing Your Report View​

Fiskl offers several options to tailor the report to your needs:

  • Account selection: Choose to view all accounts or focus on one or more specific accounts
  • Date range: Set the time period for which you want to see transactions
  • Cash vs. Accrual: Switch between cash and accrual accounting methods
  • Summary/Detail toggle: Choose between a high-level summary or a detailed transaction view
  • Empty account visibility: Option to hide accounts with no activity in the selected period
  • Balance display: Show or hide opening and closing balances for each account

Understanding the Report Columns​

The Transactions by Account report provides extensive information for each transaction:

See a break down of the columns in the report
  1. Account: The name of the account
  2. Date: The date of the transaction
  3. Type: The type of transaction (e.g., invoice, expense, transfer)
  4. Name: The name of the client or vendor
  5. Category: The category assigned to the transaction
  6. Description: A brief description of the transaction

For amounts, the report shows:

  1. Gross amount: Total transaction amount
  2. Net amount: Amount excluding tax
  3. Tax amount: Tax portion of the transaction

**Each of these amounts (Gross, Net, Tax) is shown in three currencies:

  • Original currency: The currency in which the transaction was originally recorded
  • Account currency: The currency of the account (for revenue and expenses, this is the base currency)
  • Base currency: Your company's base accounting currency
  1. Balance: Running balance of the account (if enabled)
  2. Tax rate: Applicable tax rate for the transaction
  3. FX rate: Exchange rate between the base currency and account currency

Customizing Report Columns​

Given the complexity and depth of information in the Transactions by Account report, Fiskl allows you to customize which columns are displayed. This feature helps you focus on the most relevant data for your needs and simplifies the report view.

To customize your report columns:

  1. Click on the gear icon in the report view
  2. In the column selector, add or remove columns as needed
  3. Your selection will be applied to the report view and respected in exports

Available columns for customization include:

Available columns for customization include
  • Number
  • Type
  • Client/Vendor
  • Description
  • Gross Amount (Original currency)
  • Net Amount (Original currency)
  • Tax Amount (Original currency)
  • FX rate
tip

Customizing your columns can significantly streamline your report, especially when dealing with specific multi-currency scenarios or focusing on particular transaction details.

Exporting your Transactions by Account Report​

Fiskl makes it easy to share and further analyze your report:

  1. Export to spreadsheet:
    • Click the export button at the top right of the screen
    • Choose between Google Sheets or Excel format
tip

Exporting to a spreadsheet allows for further customization and analysis, especially useful for complex multi-currency scenarios.

Remember, the Transactions by Account report is a powerful tool for managing multi-currency transactions and gaining deep insights into your account activities. Regular review can help you maintain accurate books, understand currency impacts on your finances, and make informed business decisions.