actualbudget / actualbudget/actual

[Bug]: error on importing from csv when only a single decmal digit in transaction

Open
#5,020 0 comments 1 reaction 0 assignees View on GitHub
transaction import
Dominant language
TypeScript
Stars
28.7k
Forks
3k
Avg merge
2d 11h
Merged PRs (30d)
65

Description

### Verified issue does not already exist?

- [x] I have searched and found no existing issue

### What happened?

The following CSV gives an error. The first record "SHOPPING STORE" tries to import a value of "-1,107.00" rather than "-110,70". The reason is that the people who create the CSV do not put two digits after the dot if the last decimal digit is a zero. This causes Actual to move the dot and add a couple of zeros as decimals.

```
Date;Affilié;Montant
17-05-2025;"Dépense SHOPPING STORE (Transaction 7fadbaae-631a-469d-a1c8-7a2c613ccb88)";" -110.7 €"
17-05-2025;"Dépense ANOTHER STORE (Transaction f432ba17-f272-4bd3-b89f-bdb67c6fbe1a)";" -116.62 €"
06-05-2025;"Dépense YET ANOTHER STORE (Transaction 0743b082-854c-4128-addd-d8fa80f0f793)";" -109.78 €"
```

### How can we reproduce the issue?

Simply import the above CSV into an account with [these import settings](https://paste.pics/890e3b2fc742b7c42e74d972fc6e5b21).

### Where are you hosting Actual?

Docker

### What browsers are you seeing the problem on?

Firefox

### Operating System

Linux

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.