Skip to main content

How to manage Project exports and imports?

Use them to easily track your cashflow across different projects and distribute amounts wherever needed.

Updated over 2 months ago

Export Project Transactions

  1. Go to your Bank or Expected page.

  2. Apply a filter for the desired Project to see only relevant transactions.

  3. Select all transactions, then click Export in the side panel.

    • Every exported transaction file will include a column named Project that indicates each transaction’s current project.

Import Project Transactions

  1. In your transaction import CSV file, add or fill the Project column (Seetings -> Import data).

  2. If a transaction should be associated with a single project, simply type ProjectName or ProjectName=FullAmount (e.g., Project 1=1000).

  3. For distribution across multiple projects, separate them with a \.

    • Example: Project1=500\Project2=500

  4. When you upload your file back into Agicap, each project association will be created if it matches an existing project name.

Important Points

  • Case & accent sensitivity: Project names are matched without considering case or accents; still ensure names are typed consistently.

  • Project does not exist: That transaction will import but have no project assigned.

  • Same project repeated: If you distribute across two identical project names, nothing is assigned.

  • Exceeding amounts: If a project amount is bigger than the transaction total, no project is assigned.

  • Negative amounts:

    • Negative transaction total + negative distributed amounts ⇒ valid distribution.

    • Positive transaction total + negative distributed amount ⇒ no project is assigned.

  • Common separator mistakes (e.g., using , / | ! instead of \) lead to no project association.

  • Thousand or decimal markers: If you add thousand separators (1 000, 1,000, or 1.000) in the project amount, no project is recognized.

💡 Tips

  • Always keep your project names clear and unique to avoid spelling mismatches.

  • Use the backslash \ to split amounts across projects (e.g., ProjectA=600\ProjectB=400).

  • Double-check separators and spacing (like extra spaces or wrong symbols).

FAQ ❓

How can I allocate one transaction to multiple projects?

Use \ to separate each project and its amount. For example:

Project 1=300\Project 2=200

This ensures both projects receive the correct share of the transaction.

Can I use a negative value for one project and a positive for another?

No. If your total transaction is positive but one project distribution is negative, no project will be assigned. Negative distribution only works if the entire transaction is negative.

What if the project name in the file doesn’t match exactly?

The transaction will be imported with no project assigned. Double-check spelling, spaces, and accents before uploading.

Is there a way to import projects into Cashflow planning or KPIs?

Not yet. Project imports and exports currently apply to transactions and forecasts only, so you can’t link them to your Cashflow plan or KPI metrics at this time.

Did this answer your question?