Reports are an excellent tool for monitoring business expenses. Once created, you will have access to all essential details about each transaction of your company within a given period. This greatly streamlines the reconciliation process and account management. The transaction report should not be used for recording transactions.
Transaction reports can be generated in three different ways:
1. From the general transaction history
TRANSACTION HISTORY -> GENERATE TRANSACTION REPORT
2. From the transaction history of a specific card
CARDS -> Select a card -> GENERATE TRANSACTION REPORT
3. From account details
ACCOUNTS -> Select account -> TRANSACTION HISTORY -> GENERATE TRANSACTION REPORT
All reports will be based on filters that include only the information you select. After clicking "Generate transaction report", a table will appear containing options for filtering the data. Available filters include: currency, amount range, transaction status, and label.
The Date Range and Account fields are mandatory when creating a report. You must select a specific time period and the account from which you want to generate the report.
After selecting the appropriate filters and clicking the GENERATE TRANSACTION REPORT you will need to choose the type of report. It can be generated either with all attachments from the account (e.g., receipts or invoices for transactions) or without them.
Your report is ready! You will find it in one of the main tabs: REPORTS, along with a link that allows you to easily download it to your device. The report is valid for 1 month (after which it will be deleted from the system).
The report table will be generated in .csv format, which can be opened in programs such as Microsoft Excel, Google Sheets or Numbers.
The report will be packaged in a .zip file, along with all invoices, receipts, and transaction confirmations.
NOTE!
DO NOT USE THE REPORT FOR ACCOUNTING PURPOSES, DUE TO THE BALANCE AFTER TRANSACTION FIELD, WHICH IS NOT UPDATED AFTER AUTHORIZATIONS ARE REVERSED
Detailed Description of All Report Columns:
CardID - Identification number of the card
Transaction ID - Identification number of the transaction
Transaction Internal ID - UUID of transaction
Card last four digits - Last four digits of the card used for the transaction
Created at - The date the report was created
Amount - Amount spent
Currency - Currency of the transaction
Status - Status of the transaction
Customer ID - Identification number of the customer (employee)
Customer email - Email address of the customer (employee)
Customer phone number - Phone number of the customer (employee)
Attachment Status - Corporate admin must confirm all attached documents (e.g., EMPTY = no attachments, TO_APPROVE = pending approval, APPROVED, REJECTED)
Description - A short description of the transaction (e.g., last four digits of the card and date) generated automatically
Comment - Comments added by the employee
Transaction channel - channel of the transaction
Merchant name - Name of the vendor or seller
Transaction country code - Country code of the vendor
Type - type of operation
Original amount - Account balance at the time of the transaction
Original currency - Currency of the transaction (before currency conversion)
Exchange rate - Currency exchange rate for international transactions
Commission - commission
Balance after transaction - Account balance after the transaction. Note, do not use this field for accounting transactions; for the account balance, use the statement
Balance before transaction - Account balance before the transaction
Balance ID - Account UUID
Merchant Category Code (MCC) - Code identifying the type of business of the vendor
Labels - Labels assigned to transactions for classification
Clearing date - Transaction posting date
Customer external ID - Extenal identification number of a customer
Corporation ID - UUID of the corporation
Merchant transaction ID - Transaction ID generated by the merchant.
Anomalous transaction - Flag indicating whether the transaction is suspicious
Reversal amount - Refund amount
