Hi Ken. Thanks for the detailed suggestions. I did go ahead and try
splitting the 30 years of Quicken into two segments -- one for the
first 20 years, and another for the most recent 10 years.
Unfortunately, they both resulted in the GnuCash Import process
crashing the same way. GnuCash just abo
You could try checking the integrity of your Quicken file first by running
one of the "Validate and Repair" options in the "File" menu under "File
Operations". Sometimes parts of the qdf file gets corrupted and the repair
procedure may point you to various issues within your data.I broke my
qd
Obviously, Quicken will do what they can to avoid customers switching away
from their software!
While a technically correct Quicken file is a good starting point for an
import into GnuCash, it is worth remembering that Quicken uses "single
entry".
This means that even a technically good file may h
You pass the balance entry to equity account ( the same account you used for
offsetting your opening balance, this is to reflect your spending before your
start period)
Cr checking account 1136.80
Dr Credit Card account 252.55
Dr equity (opening balance)884.25
Saludos Cordiales
Murugan
__
Hi David.
Thanks for correcting me.
I have a few more questions:
As of today, I've got "Assets:Current Assets:Music Equipment CHF" and
"Assets:Current Assets:Music Equipment EUR" which I consider my inventory
accounts. There I entered the price of a musical instrument which I bought.
I also do hav
Once you have gone through below mentioned reply, you might want to review my
prior posts on it at
https://www.mail-archive.com/gnucash-user@gnucash.org/msg40455.html which is
likely to provide good pointers for migration.
-Original Message-
From: Keld Sorensen
Sent: Monday, Septembe
Yes, that is correct.
Saludos Cordiales
Murugan
From: Boniforti Flavio
Sent: 23 September 2024 12:40
To: Murugan Mariappan
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] How to record a transaction which covers a time period in
the past which is not in
You should use the closing date (which might be the billing date) for
reconciliation. Your credit card statement should have date range for which the
bill is applicable. Last day of that range is the closing date.
-Original Message-
From: Boniforti Flavio
Sent: Monday, September 23, 20
Hi David.
You suggested following when selling an item I had bought previously:
Debit (increase) checking account asset account by $120
Credit (reduce) the music equipment account by $100
Credit (increase) an equity profits account by $20
Would you therefore suggest creating an account called "Pr
Thanks.
So it becomes a "split transaction" looking like this?
[image: image.png]
(That's from the "Assets:Current Assets:Checking Account" view).
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
Am Mo., 23. Sept. 2024 um 17:12 Uhr
Hi,
I was looking at my back-end data, and find that there is a version
reference there. In my old accounting file that I've been working in
for a while, it shows "Gnucash|413". If I create a new file with no
data, it shows "Gnucash|508".
I'm curious, are there any references on-li
Thanks for confirming!
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
Am Mo., 23. Sept. 2024 um 18:05 Uhr schrieb Murugan Mariappan <
m.muruganan...@hotmail.com>:
> Yes, that is correct.
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
Hi there.
When I reconcile my credit card, I'm faced with two dates:
- the date when the bill was created (e.g. 13.02.2024);
- the date when the bill was paid from my checking account (e.g. 28.02.2024)
When I reconcile, what date should I enter? The billing date or the date of
the effective payme
Looking at the JSON, I see this being returned, so indeed there is an issue
with the service response not being parsed well: "div_yield":-nan
On Sat, Sep 21, 2024 at 3:17 PM wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe
On Mon, Sep 23, 2024 at 8:20 AM Boniforti Flavio
wrote:
> Hi list.
>
Hello, and welcome!
>
> I don't know how to phrase it with a one-liner, thus the subject line might
> be unclear :-(
> I'll try to explain.
>
It was clear
> I've started with GnuCash a couple of weeks ago, trying to unde
Hi Richard.
So you suggest setting the opening balance on the "Liabilities:Credit Card"
to 884.25 instead of deducting that amount from the opening balance of my
"Equity:Opening Balances"? Because the latter is what I did, following
Murugan's reply...
Thanks for helping me better understand.
F.
ht
On Mon, Sep 23, 2024 at 11:20 AM Boniforti Flavio
wrote:
> Hi there.
>
> When I reconcile my credit card, I'm faced with two dates:
> - the date when the bill was created (e.g. 13.02.2024);
> - the date when the bill was paid from my checking account (e.g.
> 28.02.2024)
>
> When I reconcile, what
Thank you Richard.
I replied to Patel, but forgot to "reply to all" - so here it is:
This leads to the next question: why am I not able to click "Finish" when
doing this? I do know that I have other credit card transactions which have
not yet been reconciled (I'm registering transactions from the
I saw his reply.
It is possible that I am ignorant of "correct" procedure, but it seems to
me that you really did have an opening balance in your credit card of
884.25, and the payment paid that off as well as the subsequent charges.
In my (admittedly simple) mind, the Opening Balance is a kind o
Wow! Beautiful, thank you for the code references as well!
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/23/24 12:40, John Ralls wrote:
This applies to the SQL backend only, the XML file has no version
information.
Once you’ve populated the database the versions table should look like
mmm... now reading your latest reply I start to see it. Indeed I had an
open balance (not yet paid) on 31st of December 2023 on my credit card
account. Therefore it sounds logical to set the "opening balance" on this
account, instead of the "Equity:Opening Balance" account.
Trying to do this, I see
Oh, ok!
So I have to tick "R"econcile on the left part (Funds In) as well?! Indeed,
by doing so it lets me finish the reconciliation.
Now I'm curious to understand why it has to be done like this - can you
explain?
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
Yes, on my credit card, I had an entry on 31 Dec of the prior year that
called "Opening Balance" - the amount is the amount carried forward, and
the other account is "Equity:Opening Balances".
On Mon, Sep 23, 2024 at 12:30 PM Boniforti Flavio
wrote:
> mmm... now reading your latest reply I star
This applies to the SQL backend only, the XML file has no version information.
Once you’ve populated the database the versions table should look like this:
Gnucash|2060800
Gnucash-Resave|19920
accounts|1
books|1
budgets|1
budget_amounts|1
commodities|1
lots|2
prices|3
schedxactions|1
transactions|
Assuming your statement shows the payment (and I'm sure it does), yes --
you need to reconcile the payment as well as the charges.
Why? Well, the GnuCash reconciliation screen separates the credits and
debits into two different columns. The alternative would be one column with
positive and negativ
The system will not allow you to select "Finish" until the reconciliation
is complete -- that is, the difference is zero. In your example below, it
appears that you neglected to mark the payment as reconciled.
On Mon, Sep 23, 2024 at 12:23 PM Boniforti Flavio
wrote:
> Thank you Richard.
> I rep
When you finish reconciling, the difference between the statement and the GNC
should be zero which is not the case (as shown in the picture in red color) –
“Funds In” side of transaction in the amount of CHF252.55 is not checked
(payments that you made which would be part of your statement). Onc
Thank you all!
I've learnt another tiny bit today! :-)
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
Am Mo., 23. Sept. 2024 um 20:01 Uhr schrieb Kalpesh Patel <
kalpesh.pa...@usa.net>:
> When you finish reconciling, the differe
mmm... OK, so now it can get very tricky (at least for me) to "revert" this
situation.
Can I simply change the transaction I entered in the "Equity:Opening
Balances" and transfer it to the "Liabilities:Credit Card" account? Or will
this mess up something?
The actual transaction is a split transacti
On 2024-09-23 10:24, R Losey wrote:
> It is possible that I am ignorant of "correct" procedure, but it seems to
> me that you really did have an opening balance in your credit card of
> 884.25, and the payment paid that off as well as the subsequent charges.
>
> In my (admittedly simple) mind, the
Carbon Copy! I haven't heard that phrase lately. I haven't bought carbon
paper lately either! 🤠
On Mon, Sep 23, 2024 at 1:13 PM Boniforti Flavio
wrote:
> Thank you all!
> I've learnt another tiny bit today! :-)
>
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/bonif
Thank you Stan for your contribution. I understand that my questions are
not GC-related ones, but instead more related to accounting. As I'm no
accountant and I'm trying to use GC to keep track of my personal finances
and my total wealth, I try to rely on this mailing list for help.
So far it worke
Hi list.
I don't know how to phrase it with a one-liner, thus the subject line might
be unclear :-(
I'll try to explain.
I've started with GnuCash a couple of weeks ago, trying to understand how
it works and how I can apply it to my personal finances. At one point I
decided to put some real value
To represent using normal labels
Decrease Checking account 1136.80
Payment Credit Card account 252.55
Decrease Equity (opening balance)884.25
Saludos Cordiales
Murugan
From: Boniforti Flavio
Sent: 23 September 2024 11:44
To: Murugan Mariappan
Subject:
Consider if you had returned charges, or a cashback credit... they would
show up in the left side and need to be reconciled. Or what if you typo'd a
payment... you owned 102 and paid 120?
Certainly you want to reconcile BOTH the funds in and the funds out.
On Mon, Sep 23, 2024 at 4:41 PM Bonifor
Hi Maf.
I understand reconciling the "Fund Out" - I compare the right part of the
window with what's stated on the credit card bill.
I have a hard time understanding the reconciliation of the "Funds In" part:
when I reconcile the right part, I do have the old "Funds In" on the
right... the one I u
Boniforti, I must admit to being a little confused about your earlier
question regarding equity. The first thing I did when I started
populating gnu was to enter the outstanding balances in my checking,
savings, credit cards, and bank accounts. Each asset and each
liability. I hav
On Monday, 23 September 2024 22:40:12 BST Boniforti Flavio wrote:
> Hi Maf.
>
> I understand reconciling the "Fund Out" - I compare the right part of the
> window with what's stated on the credit card bill.
> I have a hard time understanding the reconciliation of the "Funds In" part:
> when I reco
On Mon, Sep 23, 2024 at 5:34 PM Scott Steimle wrote:
> Looking at the JSON, I see this being returned, so indeed there is an issue
> with the service response not being parsed well: "div_yield":-nan
>
'nan' means Not A Number
In this case, it would have come from 0 / 0
_
Thanks Phyllis.
I also started by populating the initial balances... but this has nothing
to do with the question regarding how to register a split-transaction -
which you perfectly answered already.
Thanks,
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https
Well, the "convenient" way would just be to delete the payment transaction
and then add an opening balance to the credit card account, and re-enter
the payment, all going to the credit card. (If the account has been
reconciled, you may need to re-reconcile).
Purists advocate leaving mistakes and j
Hi.
As per the subject line: I bought an item for 4500 and paid 2000 with my
credit card and 2500 by wire transfer.
How should I proceed to correctly register this transaction?
Thanks,
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
What account was the wire transfer drawn from. If checking, I would do a split
from your checking account. You might indicate the wire transfer in the
description. The other split would be the 200 charged to your credit card.
> On Sep 23, 2024, at 4:18 PM, Boniforti Flavio wrote:
>
> Hi.
>
Hi Phyllis.
As you were typing the reply I played with the split transaction and indeed
that was the solution! :-)
Sorry for bothering.
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
Am Mo., 23. Sept. 2024 um 23:23 Uhr schrieb Ph
On Monday, 23 September 2024 18:31:48 BST Boniforti Flavio wrote:
> Oh, ok!
> So I have to tick "R"econcile on the left part (Funds In) as well?! Indeed,
> by doing so it lets me finish the reconciliation.
> Now I'm curious to understand why it has to be done like this - can you
> explain?
> F.
To
On Monday, 23 September 2024 18:09:15 BST R Losey wrote:
> On Mon, Sep 23, 2024 at 8:20 AM Boniforti Flavio
>
>
> Well, your opening balance for your credit cards should have been whatever
> it was on 31 Dec... per your records below, that should have been
> 1136.80-252.55 (884.25). Then your c
Hi everyone, mailing list question - I have just received 12 separate
gnucash-user messages overnight.
Is there a way I can have them all as a daily digest (bulk email of all
postings once a day)?
Thanks!
Megan in Sydney
2024-09-24 0813hrs
___
gnuca
Wow! It worked! :-)
Thanks,
F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
Am Mo., 23. Sept. 2024 um 21:03 Uhr schrieb R Losey :
> Well, the "convenient" way would just be to delete the payment transaction
> and then add an open
👍😁
On Sep 23, 2024, at 5:00 PM, Boniforti Flavio
wrote:
Thanks Phyllis.
I also started by populating the initial balances... but this has
nothing to do with the question regarding how to register a
split-transaction - which you perfectly answered already.
Thanks,
On Tue, 24 Sep 2024 08:13:10 +1000
Megan Tilley wrote:
> Hi everyone, mailing list question - I have just received 12 separate
> gnucash-user messages overnight.
>
> Is there a way I can have them all as a daily digest (bulk email of
> all postings once a day)?
>
>
> Thanks!
>
>
> Megan in S
First, apologies if I repeat anything old here.
Secondly, apologies again for not taking notes when I jumped ship from Quicken
(Reckon) to GC last year. I encountered the same issues as well when GC would
terminate a QIF import without any apparent error message. To overcome the
situation, I
On 9/23/24 22:58:31 +0100, Fred Tydeman wrote:
On Mon, Sep 23, 2024 at 5:34?PM Scott Steimle
wrote:
Looking at the JSON, I see this being returned, so indeed there is
an issue with the service response not being parsed well:
"div_yield":-nan
'nan' means Not A Number In this case, it would
Flavio,
If you look at your bank statement for the Credit card it records both
the charges you made against the account (Funds Out) and the Payments
received by the bank in that period (Funds In), which in most cases
will be payment of an amount for the previous periods bill and
similarly the Cr
--- Begin Message ---
Flavio,
If you were just buying musical instruments with no intention of
earning income with them or in the future, you would simply record the
purchase transaction as
Asset :Bank account credit xxx
Expenses: Musical Instruments debit xxx
and a
Flavio,
As well as those two times, the bill usually includes a statement of
transactions from a specific date to another specified date, usually
1st of the month to the last day of the month. When you are reconciling
you are making sure your record of the transactions and the banks are
in agreeme
55 matches
Mail list logo
