Step 1: Prepare Your Transaction File
Ensure your transactions are organized in a CSV or Excel file. Include columns such as Date, Amount, Description, and any other relevant details.
Step 2: Access the Import Feature in Agicap
Log in to your Agicap account.
Navigate to the 3 dashes of the treasury section.
Click on the Import data button.
Step 3: Upload Your Transaction File
In the import window, select "Transactions" as import type and specify if you're importing in- or outflows.
click on Choose File and select your prepared transaction file.
Select the correct file format (CSV or Excel).
Click Next to proceed.
Step 4: Map Your Data Fields
Agicap will display a preview of your data.
Match each column in your file to the corresponding Agicap fields (e.g., Date, Amount, Description).
Ensure all required fields are correctly matched.
Click Next to continue.
Step 5: Review and Confirm the Import
Review the summary of transactions to be imported.
If everything looks correct, click Import to finalize the process.
Your transactions will now appear in the Transactions section.
💡 Tips
Categorization: Include category names in your import file to automatically categorize transactions.
Handling Duplicate Categories: If you have categories with identical names, temporarily rename them before importing to ensure accurate categorization.
Large Files: For very large files, consider splitting them into smaller batches (e.g., 10,000 lines each) to ensure a smooth import process.
Example File: If you experience any difficulties please use this template.
FAQ ❓
Can I import expected (future) transactions?
Yes, by including the expected dates and marking the transactions accordingly in your import file, you can import future transactions to assist in cashflow forecasting.
What file formats are supported for imports?
Agicap supports CSV and Excel file formats for importing transactions.
How do I ensure transactions are correctly categorized upon import?
Make sure the category names in your import file exactly match those in Agicap. If there are categories with the same name, rename them temporarily to avoid miscategorization.
Can I import transactions with foreign currencies?
Yes, you can import transactions in foreign currencies. Agicap will handle the conversion based on the exchange rates provided or the default rates set in your account.