Date of transactions in paisa have offset -1 day compared with ledger journal

[archtur]

Describe your Environment

OS: Manjaro Linux (latest updates)
Paisa Version: 0.7.4
App Variant: CLI

Timezone settings

In my paisa.yaml I have set the following configurations (also time_zone explicitely,, because I thought it could have influence on that after reading your previous issue #162)

[...]
locale: de-DE
time_zone: Europe/Berlin
financial_year_starting_month: 1
week_starting_day: 1
[...]

In addition I set the environment variable TZ explicitely, before running paisa update and paisa serve:

  export TZ=Europe/Berlin
  paisa update
  paisa serve &

Before I tried it without setting TZ environment variable and time_zone configuration variable, but the issue was not influenced by this.

Describe the bug

The dates of my transactions in paisa UI have offset -1 day compared with the hledger journal transactions.

To Reproduce

Steps to reproduce the behavior:

1. Go to 'Expenses -> Monthly'
2. Choose your month
3. Scroll down to any shown transaction and look at the date
4. Click on the description of the transaction to open the journal date of the transaction:

ISSUE: The date shown in paisa UI is ONE DAY BEHIND the date in the journal

Example:

• paisa transaction:
  

• journal entry (shown via paisa web interface)

  2025-12-03 MY DESCRIPTION; MY COMMENT
      Vermögen:Girokonto:Laufende          €-30,8
      Ausgaben:Bildung                      €30,8
  

Expected behavior

The dates shown in paisa UI should be exactly the same as in the hledger journals.

Side effect 1: Expense view shows dates that are out of the current month

The monthly expense view seems to show the correct transactions / sums matching the right journal dates. But if you do not see that the dates shown in the UI are wrong, you think that transactions from the last day of the month before are displayed.

Side effect 2: Sum of account different in Expense view and in sheets

I have another bad behavior: The account sums in 'Expenses -> Monthly' view are different to sums shown via sheets.

I have the following sheet:

# Zeitraum
zeitraum = {date = [2025-12]}

# Lebensmittel
lebensmittel = zeitraum AND {account = Expenses:Lebensmittel}
cost(lebensmittel)

The sum does not match the shown sum in the 'Expenses -> Monthly' view. If I substract the transactions that are shown in the paisa UI with the date of the last day of the month before, I get exactly the cost sum shown in my sheet.

So it seems, that the sheet is using the paisa dates to calculate the costs and because those dates are incorrect, the sheet queried data is also wrong.