Bug 442052 - transaction date vs post date
Summary: transaction date vs post date
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 5.1.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-05 19:22 UTC by jesse
Modified: 2021-09-06 20:17 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jesse 2021-09-05 19:22:11 UTC
SUMMARY
Allow for tracking of both transaction date and post date. 

After some research, it seems that most banks keep track of the post date. However, this make it very difficult for personal financing. 

Keep in mind the following goals: 
- I want to track when I made transactions for taxes purposes. Here the date on which I made the purchase or sell, matters most. 
- I want to keep in sych with my financial institution. 

Here is one scenario: 
I make charges to my credit card on the weekend. Most transactions, will post on Monday, not when made. The financial institution does know the transaction date, but their OFX will use the POST date. Statements do show both, transaction date and post date. 
In KMyMoney, I enter the transaction manually on the day it was made. But now it will not match my banks. 

Scenario two: Paying my Credit card bill. 
When I pay my credit card from my checking account, it will reflect that the transaction is pending as of the date I sent it. 
My Credit card will not receive the money and process it until a few days later. 
In Double entry accounting, both accounts have to be modified at the same time/date. Should we be using the transaction date(when I sent the payment) or when the transaction posted? Or should we keep track of both. 



STEPS TO REPRODUCE
1. 
2. 
3. 

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION

It may be a duplicate or an expansion of this 
https://bugs.kde.org/show_bug.cgi?id=135198
Comment 1 mahueb55 2021-09-06 20:17:51 UTC
Just having the transaction date in addition to the posting date may not even be enough for what you need - if I'm not mistaken, all splits currently share the same posting date (so a transfer between two accounts (e.g. checking <> credit card) would always show the same posting date on both accts).

One way to deal with this is to run the transactions through a separate account.

E.g. for the cc payment (scenario 2), you could create a "cash in transit" (CIT) account and use the following posting logic:
on the day the payment posts to your checking, post a transfer from the checking to the CIT account (dr CIT, cr checking).
on the day the payment clears on the cc, post another transfer from CIT to the CC (dr CC, cr CIT).
Your CIT should now be zero; and both the checking and cc accounts should show the proper dates.

You could do a similar thing for the expense transactions (scenario 1) as well - you'd probably want a separate account for that (I've seen this being called "outgoing checks" in the past, you may want to look for a better term, especially if you don't do check payments).
on the day you make the purchase, post the expense and set up a liability (dr expense, cr outgoing checks)
on the day the charge posts to the cc, reclass the liability into the actual cc account (dr outgoing checks, cr CC).

Depending on the number of transactions you're dealing with, it may not be worth the effort to do all of this (I certainly don't do it for my personal finances) - but if having the dates 100% right is a must-have for you, this may be a workaround for now.