[GNC-dev] Import Time besides Date if provided from QIF FIle

[john]

Please copy the list on all replies.

I don't know why you think that recording times is more common behavior in accounting. It's not. The normal minimum time unit in accounting is 1 day, so the eventual real fix will be to change the design to use a date representation. Doing that isn't a high priority, the 10:59:59 Z method works well enough most of the time.

As for matching your bank statement, it's not supposed to. You're keeping your own books, not the bank's. 

The default sort order is date posted, if-close-book, number, date entered (not visible in the UI), and description. If-close-book applies to transactions in income and expense accounts that transfer the balance to an Equity account (usually called Retained Earnings) when the books are closed at the end of an accounting period. Those transactions always appear after any others on the day you closed the book.

Regards,
John Ralls

> On Mar 28, 2023, at 11:58 PM, Alexander Damm <alex.damm.m1 at gmail.com> wrote:
> 
> Hi John, 
> ok understood. Thanks for the link. 
> 
> Is there a plan or Road map to change it to a more common behavior. From my understanding a "home" timezone will be set in the settings and all bookings will be calculated in relation to that timezone. 
> 
> Anyway I can live only dates, although it does not match a banking statement on a particular day.
> 
> One more question: How are the bookings sorted if only the date is choosen?
> 
> regards alex  
> 
> On Tue, 28 Mar 2023 at 17:53, john <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> 
>> 
>>> On Mar 28, 2023, at 6:59 AM, Alexander Damm <alex.damm.m1 at gmail.com <mailto:alex.damm.m1 at gmail.com>> wrote:
>>> 
>>> Hello, I'm not sure if the gnucash importer could be extended to import the
>>> time as well besides the date.
>>> 
>>> I couldn't  find a specification whether the time can be added to the date
>>> in the qif format.
>>> 
>>> I have the following qif statement that imports only the date but not the
>>> time, But the mariadb adds an odd default value in the datetime. 10:59:00
>>> 
>>> QIF File:
>>> 
>>> !Account
>>> N08. sonstige betriebliche Aufwendungen:a) ordentliche betriebliche
>>> Aufwendungen:1) Raumkosten:Gas, Strom, Wasser:Gas, Strom, Wasser für
>>> Gebäude, die nicht zum Betriebsvermögen gehören
>>> TBank
>>> DDescriptionmissing
>>> ^
>>> !Type:Bank
>>> D02-02-2023 07:04:00
>>> T40.00
>>> MStrom Gas Wasser Betrieb
>>> L[Penta-EUR]
>>> ^
>>> 
>>> In the MariaDB
>>> 
>>> 2023-02-02 10:59:00 Strom Gas Wasser Betrieb
>>> 
>>> It would be great, if the script could handle datetime and import the time
>>> as well, if provided.
>> 
>> We do that on purpose, see https://bugs.gnucash.org/show_bug.cgi?id=137017.
>> 
>> Regards,
>> John Ralls
>> 
> 
> 
> -- 
> Alexander Damm (ehemals Ritzer)
> Drosselweg 4
> 61440 Oberursel
> Tel.: 016092173081 <https://hangouts.google.com/?action=chat&pn=+4916092173081&hl=en&authuser=0>