---
title: How to add a transaction
description: "There are two ways of adding transactions to Asora’s platform: This method is recommended when you have a small number of transactions to add. Transactions are split up into 6 different types: Followi"
---

[Skip to content](https://service.asora.com/knowledge-base/add-transaction#main-content)

![](https://service.asora.com/hs-fs/hubfs/Favicon-2.png?width=100&height=75&name=Favicon-2.png)

- [Knowledge base](https://service.asora.com/knowledge-base)
- [Releases & Updates](https://service.asora.com/release-notes)
- [Blog](https://asora.com/blog/)
- [Newsletter](https://asora.com/sign-up-newsletter/)
- [Customer Portal](https://service.asora.com/tickets-view)
- [File a Support Ticket](https://service.asora.com/tickets-view/new)

Open main navigation

Close main navigation

- [Knowledge base](https://service.asora.com/knowledge-base)
- [Releases & Updates](https://service.asora.com/release-notes)
- [Blog](https://asora.com/blog/)
- [Newsletter](https://asora.com/sign-up-newsletter/)
- [Customer Portal](https://service.asora.com/tickets-view)
- [File a Support Ticket](https://service.asora.com/tickets-view/new)

 Search the Asora Knowledge Base

- There are no suggestions because the search field is empty.

1. [Asora Knowledge Base](https://service.asora.com/knowledge-base?hsLang=en)
2. [Onboarding Guide](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en)
3. [Transactions](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#transactions)

July 31, 2025

# How to add a transaction

There are two ways of adding transactions to Asora’s platform:

1. [The Add (+) button](https://service.asora.com/knowledge-base/add-transaction#add_button)
2. [Bulk Import](https://service.asora.com/knowledge-base/add-transaction#Bulk_Import)

### Adding a transaction through the ‘+’ button

This method is recommended when you have a small number of transactions to add.

**Transactions** are split up into 6 different types:

1. Buy
2. Sell
3. Income
4. Expense
5. Contribution
6. Withdrawal

Following these steps should allow you to add a new transaction with the specified details.

<iframe src="https://www.loom.com/embed/aff07ece32c34dab825708e76455e339?sid=0f847b74-2df1-4f0b-bcbc-107d27d09401" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;" allowfullscreen data-mce-src="https://www.loom.com/embed/aff07ece32c34dab825708e76455e339?sid=0f847b74-2df1-4f0b-bcbc-107d27d09401" data-mce-style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;" data-mce-fragment="1"></iframe>

### Bulk importing transactions

This method is recommended if you wish to add a large number of transactions, or transactions for different accounts at once.

#### Preparing the import file

The following file can be used as a template to import transactions.

[Transactions import file template](https://service.asora.com/hubfs/asora-transactions-upload-template.xlsx?hsLang=en)

We require a number of column headings in order to display accurate transactions:

- **Trade Date & Settlement Date**  
  Here we need the date the actual transaction was placed or ordered and the date it was settled.
- **Type & Sub Type**  
  This is the transaction type which you are uploading.   
  If you are unsure of the transaction type, the [import file template](https://service.asora.com/knowledge-base/add-transaction#Import-file-template) attached above should help clarify which Type & Sub Type to use for your transactions.
- **Account Plain ID**   
  Here we simply need the account number to which the transaction relates.   
  This can also be the account in which the asset or liability is held.
- **Asset ID & Asset Name**   
  We need the ISIN, SEDOL or CUSIP for the asset which is involved in the transaction.   
  You can input the asset name also however our server will pick up on the Asset Identifier and display the official name of the security.

The Account ID and the Asset ID (account\_plain\_id and asset\_id in templates above) are two identifiers that help transactions and holdings to be mapped correctly. Both these IDs can be located in the Datahub \> Financial \> Assets & Liabilities. In the image below, the Account ID is highlighted in yellow and the Asset ID is highlighted in green. If you don't see these columns in your table, you will need to add them to the view by clicking on the Column Selector icon (highlighted in blue) and selecting the respective columns.

![Account and asset ID](https://service.asora.com/hs-fs/hubfs/Account%20and%20asset%20ID.jpg?width=688&height=314&name=Account%20and%20asset%20ID.jpg)

- **Units & Amount**   
  Here we require the amount of units involved in the transaction, for example if you are buying or selling X amount of an asset.

#### Importing

Once your file is ready, these steps should be followed to import your transactions in bulk:

1. Once logged into your Asora account, navigate to **Connections** on your left navigation menu. Then click on **Import**.
2. Click on **Import Transactions**. You can either choose a file from your computer or drag and drop it on the page.
3. Once your file is chosen, click on **Import**.
4. Your transactions are now imported.

- [Onboarding Guide](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#main-content)

    - [Getting Started](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#getting-started)
    - [People & Entities](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#people-entities)
    - [Accounts](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#accounts)
    - [Assets & Liabilities](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#assets-liabilities)
    - [Transactions](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#transactions)
    - [Reporting](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#reporting)
    - [Family Admin, Permissions, and Settings](https://service.asora.com/knowledge-base/onboarding-guide?hsLang=en#family-admin-permissions-and-settings)
- [Data Automation](https://service.asora.com/knowledge-base/data-automation?hsLang=en)
- [Performance Monitoring](https://service.asora.com/knowledge-base/performance-monitoring?hsLang=en)
- [Private Assets](https://service.asora.com/knowledge-base/private-assets?hsLang=en)
- [Accounting](https://service.asora.com/knowledge-base/accounting?hsLang=en)
- [Document Vault](https://service.asora.com/knowledge-base/document-vault?hsLang=en)
- [Workflow & Alerts](https://service.asora.com/knowledge-base/workflow-alerts?hsLang=en)
- [Mobile](https://service.asora.com/knowledge-base/mobile?hsLang=en)

[![asora\_logo](https://service.asora.com/hs-fs/hubfs/asora_logo_dark.png?width=300&height=65&name=asora_logo_dark.png "asora_logo")](http://www.asora.com)

20 Hatch Street, Dublin 02, Dublin, Ireland

<https://twitter.com/AsoraTech> [mailto:support@asora.com](mailto:support@asora.com) <https://www.linkedin.com/company/asoratechnologies/>

Copyright © 2025, Asora