That somehow seems to be an entirely justified substitution in my case!
Original Message
From: John Ralls
Sent: Fri May 01 10:34:54 GMT+05:30 2020
To: "D."
Cc: Hal Vaughan , "D. via gnucash-user"
Subject: Re: [GNC] Adding Transactions From Another Program
Maybe one
Thanks for the reply. I do understand the challenges this poses-- both from the
perspective of managing it on a daily basis, and from that of the difficulty of
changing the underlying system. At least, conceptually!
Is there any option to simply ignore the time portion in these timestamps? It
Just in case GnuCash gets hysterical??
David
On Thu, 2020-04-30 at 22:04 -0700, John Ralls wrote:
> Maybe one supplied by a drug manufacturer. Google tells me that Clozapine is
> an antipsychotic.
>
> Regards,
> John Ralls
>
>
> > On Apr 30, 2020, at 9:54 PM, D. via gnucash-user
> > wrote:
David,
It's not that the Oz government is giving people money, but allowing you to
withdraw your money from their Superannuation accounts (normally you can't
because superannuation funds accrue tax benefits as retirement savings) to
meet immediate needs while unemplyed or unable to work during
Maybe one supplied by a drug manufacturer. Google tells me that Clozapine is an
antipsychotic.
Regards,
John Ralls
> On Apr 30, 2020, at 9:54 PM, D. via gnucash-user
> wrote:
>
> "clozapine"="compile"
>
> Not sure what dictionary my machine is using!
>
>
> Original Message
No, but using the money to buy gold is.
Regards,
John Ralls
> On Apr 30, 2020, at 9:31 PM, outlook_a062af9f159be...@outlook.com
> wrote:
>
> The idea behind the Australian Govt. allowing early access to one’s
> superannuation is economic stimulation NOT speculation.
>
>
> Sent from
David,
I don't know why the decision was made to use time, it was taken long before I
joined the project, but it probably has to do with that being the way computers
keep time, in UTC and the accompanying date-time manipulation functions in the
C standard library were readily available. Over
"clozapine"="compile"
Not sure what dictionary my machine is using!
Original Message
From: "D. via gnucash-user"
Sent: Fri May 01 09:21:46 GMT+05:30 2020
To: Hal Vaughan
Cc: "D. via gnucash-user"
Subject: Re: [GNC] Adding Transactions From Another Program
Hal,
John
The idea behind the Australian Govt. allowing early access to one’s
superannuation is economic stimulation NOT speculation.
Sent from [1]Mail for Windows 10
From: [2]flywire
Sent: Friday, 1 May 2020 11:19 AM
To: [3]Gnucash Users
Subject: [GNC] Superannuation Co-Vid payment
oz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
John,
I somewhat remember the discussion back in 2011 about the timestamp, but do not
recall all the details. Remind me why it is that GnuCash uses timestamps in
these date fields? All these steps and workarounds that take place to present
the proper date around the world.
Wouldn't it be
Hal,
John Ralls, the person who manages the Mac end of GnuCash, has pointed out that
Homebrew simply uses the GnuCash dmg for its installation. That dmg does not
include python bindings, so the answer to your question is "No, Homebrew does
not include python. You would need to clozapine
I want to know which government is giving out money to speculate in
precious metals with.
On Thu, Apr 30, 2020 at 9:19 PM Chris Taylor
wrote:
> Hi everyone
> Looking for some advice on how to setup a account system
> Ok. What I have done is take up the Gov on the Co-Vid superannuation
> payment
10:59:00 UTC is a very clever fix, or "kludge" as some put it. So
just using the bash shell:
$ date +%F-%Z # Format Strings %F with %Z for time zone
2020-04-30-CDT
This, of course, depends on locale on whatever system you're using.
You could even try:
$ date +%F-TZ=%Z-Week=%U-Day=%u
Adrein, thank you for those tips.
I've simplified the example too much. There are multiple accounts, some
with more than a handful of transactions to be moved, but your workflow
seems to work using the transaction report to open up the account register.
I understand you're suggesting if the bulk
Hi everyone
Looking for some advice on how to setup a account system
Ok. What I have done is take up the Gov on the Co-Vid superannuation
payment (withdrawal) of $10,000
What I wish to do is have it show up in bank account AAA that works day
to day, I will be buying Gold this this money on a
You shouldn’t need a report for this.
If you want to move a handful of transactions, just open Expenses:Unallocated
and re-assign the split for that account to Expenses:Household on each
transaction.
As you do so, they’ll disappear from the current register view. (because they
are no longer
@Christopher Lam - Would you mind giving a bit of a workflow? Nothing stood
out in the manual or guide.
Say I want to select and change most of Expenses:Unallocated to
Expenses:Household.
To run the transaction report.
- Run report: Reports, Transaction report
- Setup report: Edit, Report
Newsflash "Catalina is already here" :-)
Python 2.7.16 is retained as "python" when upgrading to Catalina and Python
3.8.1 is also installed as "python3" so you can presumably use both in
parallel.
davidhalverson@Davids-MBP ~ % python3 --version
Python 3.8.1
davidhalverson@Davids-MBP ~ %
I would like to have a dark theme on my GnuCash on Windows 10 64 bit.
Could someone provide a step-by-step set of instructions to accomplish this?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to
We show no times at all. The smallest useful division of time in accounting is
a day.
Unfortunately someone decided a long time ago to use unix time to represent
dates, probably because in 1998 that was what was readily available. Naturally
you want to display in local time, otherwise you have
Sorry, I have used a wrong example with 2017-12-31 21:00:00, should be
22:00:00+02 - not summer time.
My SQL conversion of that gives 2018-01-01
Like 22:00 + 2 hours = next day.
Cyprus and British territories here have the same time.
>
> On Apr 30, 2020 at
Curious about this. So is the goal to show all times in UTC on
invoices along with local time? I tend to default most things to UTC
(including local time on computers) and just display in some local
time if necessary. If GMT is available as a time zone, I use that
(GMT is a timezone; UTC is
John, I have found lost 4 transactions, they are from invoices but not
connected with invoices.
Found using your SQL with left outer join and ordering by invoices.date_posted.
They have Null in invoices columns.
They have vendor names In transactions.description...
Found!
GnuCash stores all dates as UTC but displays them as local, applying the
timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00
displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but
2020-02-21 21:00:00 displays as 2020-02-21.
Regards,
John Ralls
> On Apr
That’s quite an undertaking.
The business features probably won’t be able to help since you need to group
members by team as well as you noted.
The member accounts can still be treated as ‘other receivables’ and even be
under the A/R account. They just should be of type ‘asset’ instead of type
It is not just adding one day, it depends on the time.
Looks like time 00:00:00 is the same date, not next.
From 21:00:00 is the next date in most cases, but I did not check all
transactions manually =)
How the program converts this wrong dates to the correct ones in its GUI?
I believe I
On Thu, 30 Apr 2020 at 05:02, Adrien Monteleone
wrote:
>
> That’s another valid and safe option.
>
> The OP noted 1000+ accounts to migrate though. So even 1 transaction per
> account would not be fun.
>
> On the upside, I discovered that accounts with zero transactions can have
> their type
Hmm, true. Should be always, since you're in a time zone east of the prime
meridian. So you also want to increment the day on those. I think it would be
safest to do it in two queries, the first one being
update transactions post_date = post_date + interval '1 day' where
post_date::TIME !=
If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real date
is 2018-01-01. At least in cases where I manually checked the invoices.
Setting all times to 10:59:00 will give wrong dates in the program.
Now they are displayed correctly in the program somehow...
On Thu, 30 Apr 2020 at 11:05, Geert Janssens wrote:
>
[snip]
>
> It could be called a bug. However business accounts (AR and AP) hold more
> data than other accounts. Moving away from that account could hence result in
> data loss that's not immediately obvious.
>
> As it turned out to be too
I don't think that's necessary.
To fix the wrong times just do an update query, something like
update transactions set post_date::TIME = 10:59:00 where post_date::TIME !=
10:59:00;
I don't know Postgresql's date-time functions well enough to know if that
syntax works, you might have to
How can I help?
I can send you my gnucash file if it helps to find all the bugs.
And how can I change now my wrong dates in transactions?
>
> On Apr 30, 2020 at 20:41, mailto:jra...@ceridwen.us)> wrote:
>
>
>
> Yeah, it's definitely a bug. I easily found the
Yeah, it's definitely a bug. I easily found the wrong code and I'll fix it for
3.903 and 3.11.
The query actually accounts for only 543 of the 547 wrong times, so there's
another error somewhere else.
Regards,
John Ralls
> On Apr 30, 2020, at 10:27 AM, Finfort wrote:
>
> Also I tried to
Also I tried to unpost and post again. No changes.
>
> On Apr 30, 2020 at 19:44, mailto:finf...@gmail.com)> wrote:
>
>
>
> Hi John, The result is: 22:00:00 253 00:00:00 18 21:00:00 250 23:00:00 22 So
> wrong dates are only when I use invoices. On 29/04/2020
I also unzipped GNUCASH file to check the date format and values inside - it
is the same timestamp as in Postgres
>
> On Apr 30, 2020 at 19:44, mailto:finf...@gmail.com)> wrote:
>
>
>
> Hi John, The result is: 22:00:00 253 00:00:00 18 21:00:00 250 23:00:00 22 So
On 4/29/2020 6:51 PM, Ruaraidh wrote:
I'm in the UK where married couples are taxed separately and have to file
separately.
And if you did the research you said in that you perhaps also saw
reference to arranging assets (income producing assets) between the
marriage partners to that into
Op dinsdag 28 april 2020 12:11:57 CEST schreef gnucash.dg...@ncf.ca:
> I had created a ticket about a year ago when new counter formats would not
> save in 3.4. That issue was resolved. The problem here is that they no
> longer increment in 3.10 in my working file (XML format). However, I did
>
Have you subscribed to the mailing list ? If not our moderator has to let your
mails through
manually and she won't keep on doing so.
You can find how to subscribe on this wiki page:
https://wiki.gnucash.org/wiki/Mailing_Lists
Geert
PS the reply is quite late as your private messages to me
Hi John,
The result is:
22:00:00 253
00:00:00 18
21:00:00 250
23:00:00 22
So wrong dates are only when I use invoices.
On 29/04/2020 23:56, John Ralls wrote:
Please remember to copy the list on all replies.
I take it that that means that you do in fact use the business invoice
We don't build the python bindings in the MacOS or Windows bundles because they
must be linked to libpython, and it obviously has to be the same libpython to
which the python executing the user's program is linked to. You can see where
that's going: We'd have to include an entire python
Christopher,
I think the point Ruaraidh is making here is that *their* contribution isn't
income-- not the government piece. I agree this can easily be handled in one
file though.
Original Message
From: Christopher Lam
Sent: Thu Apr 30 19:57:36 GMT+05:30 2020
To: Ruaraidh
Ah, then yes it's a terminology thing. In my own case, money from my income
goes directly into the SIPP as a payroll deduction, so I just transfer from
income into the SIPP. It can just as easily go from an asset to another asset.
Original Message
From: Ruaraidh Sackville
Indeed the government's contribution appears correctly as income however
it's recorded, as it is a genuine income. No problem there. The personal
contribution is not an income as it doesn't increase my net worth - it's
just a transfer from one account to another. And you are right,
the government
On Thu, 30 Apr 2020 at 14:15, Ruaraidh Sackville Hamilton <
ruaraidh...@gmail.com> wrote:
> In my reply I replaced your "Income:Me" with "Assets:my bank account". The
> point is that, when the SIPP is in the same GC file as my other assets, the
> transaction is from one asset (the bank account I
David, are the Python bindings not supported in Windows? I don't see any
mention of Windows setup on this page:
https://wiki.gnucash.org/wiki/Python_Bindings#Setting_things_up I do have
Python 3.8 on my Win 10 system.
My second question is with regard to budgets. If I don't see anything
Sorry David, I didn't mean to imply I prefer the second to the first
option. I just thought it easier to show by editing one of your versions,
and happened to pick the second. I could as easily have picked the first.
In my reply I replaced your "Income:Me" with "Assets:my bank account". The
point
???
Perhaps this is a terminology thing, but aren't you just re-presenting the
second option I gave originally?
Think of it another way: there are two sources for the funding of your SIPP:
your contribution, and the government's. How you handle your own contribution
depends on your workflow;
Yes, thanks, that's what I already have
On Thu, 30 Apr 2020, 12:43 Fred Bone, wrote:
> On 29 April 2020 at 17:51, Ruaraidh said:
>
> > I'm in the UK where married couples are taxed separately and have to file
> > separately. I'm not a tax expert, but I've just googled it and find
> >
On Thursday, 30 April 2020 10:30:04 BST Ruaraidh Sackville Hamilton wrote:
> Thanks Maf,
>
> You're right it's not a big deal, there aren't many additional calculations
> to do, and they're easy calculations. But hey, GC is an accounting system
> and it can do the sums needed for our tax reports,
Janet,
Good luck with online banking. If you are unable to get online banking to
work, there's a fairly easy alternative. Most banks allow their customers
to log into the bank's web site and download transactions and banking
activity in various formats, which you can import into GnuCash.
On Wednesday, 29 April 2020 23:51:13 BST Ruaraidh wrote:
> I'm in the UK where married couples are taxed separately and have to file
> separately. I'm not a tax expert, but I've just googled it and find
> confirmation on both government and accountants' web sites: husbands and
> wives (the words
That covers it if the SIPP is in a separate GC file of its own, where my
contribution is an income (and an expense from my bank account in the main
GC file, which I use to fund the contribution).
But if it's all in one GC file we have
01-01-2020 SIPP Contribution Assets:SIPP £100
My
Set up an independent income account for the government contributions:
Income:GovContrib
Then add either a split to your contribution for the government,
01-01-2020 SIPP Contribution Assets:SIPP £125
My contribution Income:Me £100
Government contribution Income:GovContrib
Op donderdag 30 april 2020 00:03:06 CEST schreef Stephen M. Butler:
> On 4/29/20 1:37 PM, david whiting wrote:
> > On Wed, 29 Apr 2020 at 21:31, Stephen M. Butler wrote:
> >> On 4/29/20 1:14 PM, david whiting wrote:
> >>> On Wed, 29 Apr 2020 at 20:29, Maf. King wrote:
> Just a thought - if
Op donderdag 30 april 2020 06:04:10 CEST schreef Chris Good:
> Hi Geert,
>
>
>
> I think options 2-5 are too disruptive and more work than the benefits
> deserve.
>
>
>
> Re option 1,
>
> I’d prefer to put logs and backups in separate folders. Maybe (going with
> your name) book.dir/backup
Thanks Maf,
You're right it's not a big deal, there aren't many additional calculations
to do, and they're easy calculations. But hey, GC is an accounting system
and it can do the sums needed for our tax reports, so I thought the most
elegant solution is to have GC do those calculations. If it
On 29 April 2020 at 17:51, Ruaraidh said:
> I'm in the UK where married couples are taxed separately and have to file
> separately. I'm not a tax expert, but I've just googled it and find
> confirmation on both government and accountants' web sites: husbands and
> wives (the words used on the web
I have another question related to UK tax reporting obligations.
In the UK we can have a type of asset called a SIPP (Self-invested Personal
Pension). You pay money into a SIPP with the idea of building up an income
for your retirement. The carrot is, you get a tax rebate. For example if you
pay
Hmm, I'm pretty sure I tried this (because I had the same issue), & it
worked. However, that was years ago, probably on Gnucash 2.4. I'm
still on 2.6 (I tried 3.7, & didn't care for the "look").
I was so "burned" early on by the handling of A/P & A/R accounts, that I
moved all my
Have you investigated Homebrew vs. MacPorts?
Just curious if the Perl issues are the same.
Regards,
Adrien
> On Apr 30, 2020 w18d121, at 12:29 AM, Hal Vaughan wrote:
>
> I’ve checked out the bindings - as I mentioned in my original post, the
> problem is that using the bindings on a Mac
Interesting!
Did you consider having GC use XML in your save file instead of SQL?
If I do pursue this, I’ll be glad to make the code available and let people
know what happens.
Hal
> On Apr 28, 2020, at 5:41 PM, Stu Perlman wrote:
>
> Hal,
>
> I'm sort of doing a liter version of what you
CVS works fine. I can still read the data I need to by opening the GC file
with my script, checking to see what entries I’ve already added, and add the
ones that are still needed to a temporary CSV file I import.
That works fine.
I just want don’t want to have to do the math.
Eventually,
63 matches
Mail list logo
