Re: [GNC] Import from Quicken to GnuCash not Working

[Tom R]

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 aborts and closes for both
segments with no error message or other indication of why it's
crashing.

Your suggestion though of importing things in one year at a time might
be a possible solution.  As a test I tried importing just one year
like that -- 2023 by itself.  And interestingly enough, GnuCash was
able to pull in that one year successfully.  So I guess I could try
doing more individual years that way, one at a time.  But that sure is
a long tedious process that I never thought would be necessary in
migrating to GnuCash.

The main problem with that method is: what happens when I find
individual years that cause GnuCash to crash?  Will I then need to
have to try importing that failing year one month at a time?  Then one
week at a time?  Then one day at a time?  All in an effort to isolate
the line in the QIF file that's causing GnuCash to fail?  It could
take a very long time to get 30 years of Quicken data into GnuCash
that way.

I can understand that GnuCash handles some data differently than
Quicken does.  But I would think that the Import process would be
capable of identifying any issues it detects, and then just provide a
log file at the end listing which lines in the QIF file are causing
problems and need to be corrected.  The fact that a QIF file can cause
GnuCash to just crash and close seems like a major bug in the program
that needs to be fixed.  Are the software developers aware that this
problem even exists?

On Sun, Sep 22, 2024 at 6:56 PM Ken Farley  wrote:
>
> A suggestion that comes up many times in the past and even in some of
> the responses you got is to break up the file and perhaps not try to
> import the whole thing in one go.
>
> That being said, 14Mb is really not a very large file. The last time I
> did this kind of thing a couple of years ago I loaded about 20 years of
> data in a year at a time. The files were maybe 3Mb max each and imported
> in minutes, not hours.
>
> I imported a year at a time, starting with the oldest. I found that
> Quicken had allowed me to make some bad transactions. Also, Quicken did
> some weird stuff to account for stock splits that don't concur with the
> method Gnucash uses. So I slogged through all the years by reading a
> year in, fixing all the messed up stuff, checking balances, saving. I'd
> copy the latest "good" file to a safe spot on my hard drive as I went
> along, in case a catastrophe occurred.
>
> If you're getting the kind of failure you're seeing, my approach would
> be to split the file into two pieces. First half of years in one file,
> second half of years in another file. Try importing each half of the
> data. If one fails and not the other, split the failed one into two
> halves and try importing each of them, etc. You  should be able to zero
> in on the portion(s) of the QIF data that is "bad". You might have to
> look into the actual QIF data (it's just a text file) and see if there
> are any weird characters in there or something. 30 years of data
> probably modified by dozens of different versions of Quicken might have
> some strange entries like corrupted text fields and the like.
>
> Once you find (and maybe fix) the bad QIF data, I'd suggest starting a
> fresh new Gnucash file and then import all the "good" QIF file(s) into
> that, oldest first.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import from Quicken to GnuCash not Working

[Joseph Keithley]

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
qdf file into individual accounts by year before I imported them (30+ years
and roughly 100 different accounts).  That was the only way I could get
gnucash to import my complete data without crashing.  Unfortunately it was
a few years back and I don't exactly remember what import settings and
options I chose.

The only help I can offer is that you can import one year at a time and
then save the file to create a backup file.  Then import the next year and
save the file as a new backup file.  Keep up the process until one of the
imports crashes.  At least then you can narrow down what year of data is
causing the issue and you will have a backup up file of all the prior
imports.  Since the qif file is a simple text file you can open the "bad"
qif file in notepad and look through the file for errors.  You can also
skip that "bad" file and continue the process with the remaining files just
to get as much imported as possible.

On Mon, Sep 23, 2024 at 4:15 AM Tom R  wrote:

> 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 aborts and closes for both
> segments with no error message or other indication of why it's
> crashing.
>
> Your suggestion though of importing things in one year at a time might
> be a possible solution.  As a test I tried importing just one year
> like that -- 2023 by itself.  And interestingly enough, GnuCash was
> able to pull in that one year successfully.  So I guess I could try
> doing more individual years that way, one at a time.  But that sure is
> a long tedious process that I never thought would be necessary in
> migrating to GnuCash.
>
> The main problem with that method is: what happens when I find
> individual years that cause GnuCash to crash?  Will I then need to
> have to try importing that failing year one month at a time?  Then one
> week at a time?  Then one day at a time?  All in an effort to isolate
> the line in the QIF file that's causing GnuCash to fail?  It could
> take a very long time to get 30 years of Quicken data into GnuCash
> that way.
>
> I can understand that GnuCash handles some data differently than
> Quicken does.  But I would think that the Import process would be
> capable of identifying any issues it detects, and then just provide a
> log file at the end listing which lines in the QIF file are causing
> problems and need to be corrected.  The fact that a QIF file can cause
> GnuCash to just crash and close seems like a major bug in the program
> that needs to be fixed.  Are the software developers aware that this
> problem even exists?
>
> On Sun, Sep 22, 2024 at 6:56 PM Ken Farley  wrote:
> >
> > A suggestion that comes up many times in the past and even in some of
> > the responses you got is to break up the file and perhaps not try to
> > import the whole thing in one go.
> >
> > That being said, 14Mb is really not a very large file. The last time I
> > did this kind of thing a couple of years ago I loaded about 20 years of
> > data in a year at a time. The files were maybe 3Mb max each and imported
> > in minutes, not hours.
> >
> > I imported a year at a time, starting with the oldest. I found that
> > Quicken had allowed me to make some bad transactions. Also, Quicken did
> > some weird stuff to account for stock splits that don't concur with the
> > method Gnucash uses. So I slogged through all the years by reading a
> > year in, fixing all the messed up stuff, checking balances, saving. I'd
> > copy the latest "good" file to a safe spot on my hard drive as I went
> > along, in case a catastrophe occurred.
> >
> > If you're getting the kind of failure you're seeing, my approach would
> > be to split the file into two pieces. First half of years in one file,
> > second half of years in another file. Try importing each half of the
> > data. If one fails and not the other, split the failed one into two
> > halves and try importing each of them, etc. You  should be able to zero
> > in on the portion(s) of the QIF data that is "bad". You might have to
> > look into the actual QIF data (it's just a text file) and see if there
> > are any weird characters in there or something. 30 years of data
> > probably modified by dozens of different versions of Quicken might have
> > some strange entries like corrupted text fields and the like.
> >
> > Once you find (and maybe fix) the bad QIF data, I'd suggest starting a
> > fresh new Gnucash file and then import all the "good" QIF file(s) into
> > that, oldest first.
>

Re: [GNC] Import from Quicken to GnuCash not Working

[Keld Sorensen]

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 hide all kinds of problems
that will rear their ugly heads in the double entry method.

Even the best of Quicken files is likely to have many issues from this and
other sources, which will require careful editing after an import.

These issues beget the question of whether it is worth the effort to import
a Quicken file.
Prior to importing from Quicken, it is worth the users time to better
understand double entry by reading up on all the help material. This will
also make the "edit" session easier after the import.

Starting "from scratch" with a GnuCash file has many advantages.
One such advantage is the consistent use of double entry to minimize risk
of accounting errors in the future.



On Mon, Sep 23, 2024 at 4:01 AM Joseph Keithley  wrote:

> 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
> qdf file into individual accounts by year before I imported them (30+ years
> and roughly 100 different accounts).  That was the only way I could get
> gnucash to import my complete data without crashing.  Unfortunately it was
> a few years back and I don't exactly remember what import settings and
> options I chose.
>
> The only help I can offer is that you can import one year at a time and
> then save the file to create a backup file.  Then import the next year and
> save the file as a new backup file.  Keep up the process until one of the
> imports crashes.  At least then you can narrow down what year of data is
> causing the issue and you will have a backup up file of all the prior
> imports.  Since the qif file is a simple text file you can open the "bad"
> qif file in notepad and look through the file for errors.  You can also
> skip that "bad" file and continue the process with the remaining files just
> to get as much imported as possible.
>
> On Mon, Sep 23, 2024 at 4:15 AM Tom R  wrote:
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Murugan Mariappan]

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


From: gnucash-user 
 on behalf of 
Boniforti Flavio 
Sent: 23 September 2024 10:18
To: gnucash-user@gnucash.org 
Subject: [GNC] How to record a transaction which covers a time period in the 
past which is not in GnuCash?

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 values in it and I put the "opening balances" for
my bank accounts dating on the 31st of December, 2023. I am now slowly (but
it is an exercise for me to understand how all this works) manually
entering my transactions - please don't comment about this being
time-consuming or similar: I know it already! :-)

I do now have a situation which I don't know how to handle, therefore I'm
posting here.
I've entered all my credit card expenses for the month of January 2023. The
credit card bill was emitted on January 14th and paid from my checking
account on January 25th. I did the "reconciliation" on my
Liabilities:Credit Card account but I did just reconcile 252.55 (which is
the amount of credit card payments between 1st and 14th of January). But of
course my checking account was reduced by the full amount of the credit
card bill (1136.80). Now my understanding is that I have to reduce my
checking account by the latter amount (1136.80), but I am under the
impression that it would be wrong to transfer this amount to the
"Liabilities:Credit Card" account, because there I don't have the credit
card expenses from December 2023.

So I'm confused on how to deal with the above. Is there a way I could enter
some sort of "corrective transaction" to have the correct balance on my
checking account (which should be -1136.80 and not only -252.55)?

Thanks for your help already!
F.


https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776832018%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=dGxU1K2G0qZO5XQl8ShqorEk%2B6ylsJzaD174oXfNaAI%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776855411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=NAIFuy2IQbWxSG3WlOYk2EIJICI6xkJJoFM2bN6yTIs%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776868625%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=0jYjPQVXwk1Ux9nXFVrxz9Q518U9SI3JxDIG3z%2BNFrM%3D&reserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776880128%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=guYfZIOVwu7dJ%2FrB%2B17udrO5WjVbsdbaYBIeP%2FK13YM%3D&reserved=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to treat a sale which involves more accounts?

[Boniforti Flavio]

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 have the account "Income:Music Equipment Sales CHF" and
"Income:Music Equipment Sales EUR".

I'm not understanding the use of the "Expenses:Cost of goods sold" account
- can you explain?

Thanks,
Flavio.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Fr., 20. Sept. 2024 um 00:58 Uhr schrieb David Cousens <
davidcousen...@gmail.com>:

> Flavio,
>
> > I would do the following when selling something for 120 which I bought
> for 100:
> > 1. increase the checking account by 120;
> > 2. increase the "Income:Sales" account by 120;
> > 3. increase the "Inventory:Music Equipment Sales" account by 120;
> > 4. decrease the "Expenses:Cost of Goods Sold" account by 100.
>
> These steps are not correct . Your inventory account records the value (at
> cost) of the items you are holding so the entry on sale o an item should
> equal the cost at purchaser  so you your transaction to record it should be:
>
> 1 . increase (debit) the checking account by 120
> 2. increase (credit) the Income:Sales account by 120
> 3. decrease (credit) the Inventory:Music Equipment Sales account  by 100
> 4. increase (debit) the Expenses: Cost of Goods Sold account by 100
>
>
> The Inventory:Music Equipment Sales account is what is known in
> accounting terms as a contra account to the Music Equipment Purchases
>  which is why it is credited to decrease the balance of Inventory (rather
> than debit as is usual to increase the balance of an asset account).  I
> have added the usual accounting column headings in brackets. Of the two
> columns with entries in themthe Debit column is always the first and the
> Credit column is always the second followed by the Balance colum last.
>
> Note that in any transaction  the sums of all the debit and all the credit
> entries have to be equal, which was not the case for your proposed entries.
>
> Cheers
> David
>
>
> On Thu, 2024-09-19 at 21:52 +0200, Boniforti Flavio wrote:
>
> Hi David and David :-)
> Thanks for your replies.
> I'm not running any business at all. I am a musician who also collects
> (vintage) music instruments. As I also do play them, it happens a couple of
> times a year that I'm not interested anymore in keeping one or the other
> instrument. For this reason, I sell a couple of items a year and given the
> fact that the majority of my items are "vintage" ones, prices are always
> fluctuating. So I want to keep track of how much I've gained (or lost) when
> selling an item.
> Given the above, I think that if I would only use a single "Music
> equipment" account, I could not see how much I made (plus or minus) while
> selling some items - right? This is the reason which led me to think
> about setting up some accounts to "correctly" keep track of this all.
>
> Using this:
> 1. Debit the Checking account for the total amount of the purchase paid by
> the customer;
> 2. Credit the Income:Sales account by the total amount of the purchase;
> 3. Credit the Inventory: MusicEquipment Sales account by the amount of the
> cost of the items sold;
> 4. Debit the Expenses:Cost of Goods Sold account by the amount of the
> cost of the items sold.
>
> I would do the following when selling something for 120 which I bought for
> 100:
> 1. increase the checking account by 120;
> 2. increase the "Income:Sales" account by 120;
> 3. increase the "Inventory:Music Equipment Sales" account by 120;
> 4. decrease the "Expenses:Cost of Goods Sold" account by 100.
>
> (of course previoulsy I'd had increased the "Inventory:Music Equipment
> Purchases" and decreased my "Assets:Checking Account" by 100).
>
> Am I correct with the above?
> TIA,
> F.
>
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Do., 19. Sept. 2024 um 03:52 Uhr schrieb David Cousens <
> davidcousen...@gmail.com>:
>
> Flavio,
>
> Why would you need a Music equipment sold account in the first place?
>
> If your business is making music then:
>
> when you buy equipment you credit your checking account and debit the
> Music Equipment asset account by the amount of the purchase;
> when you sell the equipment you debit your checking account and credit
> the music equipment account.
>
> In this case the equipment is not held for the purpose of selling it at
> a profit. You may however be subject to capital gains type taxes if
>  they apply in your jurisdiction and the value of the equipment sold
> exceeds the thresholds for such taxes.
>
> The situation may however be slightly different if your business is
> actually retailing music equipment. In this case the Music Equipment
> account is essentially an Inventory account 

Re: [GNC] Import from Quicken to GnuCash not Working

[Kalpesh Patel]

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, September 23, 2024 9:39 AM
To: Joseph Keithley 
Cc: Tom R ; gnucash-user@gnucash.org; Ken Farley 

Subject: Re: [GNC] Import from Quicken to GnuCash not Working

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 hide all kinds of problems 
that will rear their ugly heads in the double entry method.

Even the best of Quicken files is likely to have many issues from this and 
other sources, which will require careful editing after an import.

These issues beget the question of whether it is worth the effort to import a 
Quicken file.
Prior to importing from Quicken, it is worth the users time to better 
understand double entry by reading up on all the help material. This will also 
make the "edit" session easier after the import.

Starting "from scratch" with a GnuCash file has many advantages.
One such advantage is the consistent use of double entry to minimize risk of 
accounting errors in the future.



On Mon, Sep 23, 2024 at 4:01 AM Joseph Keithley  wrote:

> 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
> qdf file into individual accounts by year before I imported them (30+ 
> years and roughly 100 different accounts).  That was the only way I 
> could get gnucash to import my complete data without crashing.  
> Unfortunately it was a few years back and I don't exactly remember 
> what import settings and options I chose.
>
> The only help I can offer is that you can import one year at a time 
> and then save the file to create a backup file.  Then import the next 
> year and save the file as a new backup file.  Keep up the process 
> until one of the imports crashes.  At least then you can narrow down 
> what year of data is causing the issue and you will have a backup up 
> file of all the prior imports.  Since the qif file is a simple text file you 
> can open the "bad"
> qif file in notepad and look through the file for errors.  You can 
> also skip that "bad" file and continue the process with the remaining 
> files just to get as much imported as possible.
>
> On Mon, Sep 23, 2024 at 4:15 AM Tom R  wrote:
>
>
>


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Murugan Mariappan]

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 GnuCash?

Thanks.
So it becomes a "split transaction" looking like this?
[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 schrieb Murugan Mariappan 
mailto:m.muruganan...@hotmail.com>>:
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 mailto:bonifort...@gmail.com>>
Sent: 23 September 2024 11:44
To: Murugan Mariappan 
mailto:m.muruganan...@hotmail.com>>
Subject: Re: [GNC] How to record a transaction which covers a time period in 
the past which is not in GnuCash?

Hi Murugan. Thanks.
So it means I decrease my checking account as well as my Equity "Opening 
Balance"?
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 15:39 Uhr schrieb Murugan Mariappan 
mailto:m.muruganan...@hotmail.com>>:
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


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Boniforti Flavio 
mailto:bonifort...@gmail.com>>
Sent: 23 September 2024 10:18
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] How to record a transaction which covers a time period in the 
past which is not in GnuCash?

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 values in it and I put the "opening balances" for
my bank accounts dating on the 31st of December, 2023. I am now slowly (but
it is an exercise for me to understand how all this works) manually
entering my transactions - please don't comment about this being
time-consuming or similar: I know it already! :-)

I do now have a situation which I don't know how to handle, therefore I'm
posting here.
I've entered all my credit card expenses for the month of January 2023. The
credit card bill was emitted on January 14th and paid from my checking
account on January 25th. I did the "reconciliation" on my
Liabilities:Credit Card account but I did just reconcile 252.55 (which is
the amount of credit card payments between 1st and 14th of January). But of
course my checking account was reduced by the full amount of the credit
card bill (1136.80). Now my understanding is that I have to reduce my
checking account by the latter amount (1136.80), but I am under the
impression that it would be wrong to transfer this amount to the
"Liabilities:Credit Card" account, because there I don't have the credit
card expenses from December 2023.

So I'm confused on how to deal with the above. Is there a way I could enter
some sort of "corrective transaction" to have the correct balance on my
checking account (which should be -1136.80 and not only -252.55)?

Thanks for your help already!
F.


https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776832018%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=dGxU1K2G0qZO5XQl8ShqorEk%2B6ylsJzaD174oXfNaAI%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776855411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=NAIFuy2IQbWxSG3WlOYk2EIJICI6xkJJoFM2bN6yTIs%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776868625%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTi

Re: [GNC] Reconciliation question

[Kalpesh Patel]

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, 2024 12:19 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Reconciliation question

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 payment from my checking account?

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to treat a sale which involves more accounts?

[Boniforti Flavio]

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 "Profits selling
music equipment" under the main placeholder account "Equity"?
If so, are we in this situation talking about split transactions?

Or if I decide I ignore the profit I made, can I just use simple
transactions? Like adding the sale like this:
- decrease "Assets:Music Equipment" with a description "Yamaha Guitar -
sale"
- increase "Assets:Checking Account"?

TIA,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Do., 19. Sept. 2024 um 00:05 Uhr schrieb David Warren :

> Seems like you may want to read some basic accounting materials and
> afterward decide what it is you really want to use gnucash to track over
> time. Are you running a business selling music equipment? Or do you have a
> hobby where from time to time you might upgrade or buy new equipment etc.?
>
> Buying $100 of music equipment in a basic accounting set up might be
> Debit (increase) the music equipment asset account for $100 and
> Credit (reduce) the checking account asset account by the offsetting $100
>
> Then later selling that same original equipment for $120 would result in a
> more complex entry of
>
> Debit (increase) checking account asset account by $120
> Credit (reduce) the music equipment account by $100
> Credit (increase) an equity profits account by $20
>
> Depending on both the quantity of equipment and the frequency of trading,
> you might elect to have multiple asset accounts to reflect different types
> of equipment or even for individual pieces of equipment
>
> In standard accounting, I don't know what a Music Equipment Sold account
> would represent. Though your equity account could be labeled "Profits from
> music equipment sold"
>
> On Wed, Sep 18, 2024, 5:39 PM Boniforti Flavio 
> wrote:
>
>> Hi.
>> Still very noob here, so bear with me please.
>>
>> I've got the following accounts (among others):
>>
>> Music equipment
>> Music equipment sold
>> Checking account
>>
>> When I buy music equipment, I take the money from my checking account and
>> add it to the "music equipment" account.
>> When I sell music equipment, how should I register it? I thought that the
>> account "music equipment" would decrease by the sold value, the checking
>> account would increase by the same amount... but what happens with the
>> "Music equipment sold" account?
>> Or am I wrong in separating "music equipment" from "music equipment sold"?
>>
>> Thanks,
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 schrieb Murugan Mariappan <
m.muruganan...@hotmail.com>:

> 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:* Re: [GNC] How to record a transaction which covers a time
> period in the past which is not in GnuCash?
>
> Hi Murugan. Thanks.
> So it means I decrease my checking account as well as my Equity "Opening
> Balance"?
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 15:39 Uhr schrieb Murugan Mariappan <
> m.muruganan...@hotmail.com>:
>
> 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
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Boniforti Flavio <
> bonifort...@gmail.com>
> *Sent:* 23 September 2024 10:18
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] How to record a transaction which covers a time period
> in the past which is not in GnuCash?
>
> 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 values in it and I put the "opening balances" for
> my bank accounts dating on the 31st of December, 2023. I am now slowly (but
> it is an exercise for me to understand how all this works) manually
> entering my transactions - please don't comment about this being
> time-consuming or similar: I know it already! :-)
>
> I do now have a situation which I don't know how to handle, therefore I'm
> posting here.
> I've entered all my credit card expenses for the month of January 2023. The
> credit card bill was emitted on January 14th and paid from my checking
> account on January 25th. I did the "reconciliation" on my
> Liabilities:Credit Card account but I did just reconcile 252.55 (which is
> the amount of credit card payments between 1st and 14th of January). But of
> course my checking account was reduced by the full amount of the credit
> card bill (1136.80). Now my understanding is that I have to reduce my
> checking account by the latter amount (1136.80), but I am under the
> impression that it would be wrong to transfer this amount to the
> "Liabilities:Credit Card" account, because there I don't have the credit
> card expenses from December 2023.
>
> So I'm confused on how to deal with the above. Is there a way I could enter
> some sort of "corrective transaction" to have the correct balance on my
> checking account (which should be -1136.80 and not only -252.55)?
>
> Thanks for your help already!
> F.
>
>
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776832018%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=dGxU1K2G0qZO5XQl8ShqorEk%2B6ylsJzaD174oXfNaAI%3D&reserved=0
> 
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776855411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=NAIFuy2IQbWxSG3WlOYk2EIJICI6xkJJoFM2bN6yTIs%3D&reserved=0
> 
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776868625%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=0jYjPQVXwk1Ux9nXFVrxz9Q518U9SI3JxDIG3z%2BNFrM%3D&reserved=0
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
>
> https://na01.safelinks.protection.out

[GNC] Database Versions

[Mark at Lorimark]

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-line as to the differences in 
the database schema for these different versions, and also does GnuCash 
automatically apply schema changes to the data when things change?



mark@lsus2:~/LorimarkSolutions/gnucash$ sqlite3 Gnucash58Test.gnucash
sqlite> select * from versions;
Gnucash|508
Gnucash-Resave|19920


mark@lsus2:~/LorimarkSolutions/gnucash$ sqlite3 LorimarkSolutions.gnucash 
sqlite> select * from versions;

Gnucash|413
Gnucash-Resave|19920
books|1


--
~mark petryk
~w:http://www.lorimarksolutions.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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
> --
> *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 GnuCash?
>
> 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 schrieb Murugan Mariappan <
> m.muruganan...@hotmail.com>:
>
> 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:* Re: [GNC] How to record a transaction which covers a time
> period in the past which is not in GnuCash?
>
> Hi Murugan. Thanks.
> So it means I decrease my checking account as well as my Equity "Opening
> Balance"?
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 15:39 Uhr schrieb Murugan Mariappan <
> m.muruganan...@hotmail.com>:
>
> 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
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Boniforti Flavio <
> bonifort...@gmail.com>
> *Sent:* 23 September 2024 10:18
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] How to record a transaction which covers a time period
> in the past which is not in GnuCash?
>
> 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 values in it and I put the "opening balances" for
> my bank accounts dating on the 31st of December, 2023. I am now slowly (but
> it is an exercise for me to understand how all this works) manually
> entering my transactions - please don't comment about this being
> time-consuming or similar: I know it already! :-)
>
> I do now have a situation which I don't know how to handle, therefore I'm
> posting here.
> I've entered all my credit card expenses for the month of January 2023. The
> credit card bill was emitted on January 14th and paid from my checking
> account on January 25th. I did the "reconciliation" on my
> Liabilities:Credit Card account but I did just reconcile 252.55 (which is
> the amount of credit card payments between 1st and 14th of January). But of
> course my checking account was reduced by the full amount of the credit
> card bill (1136.80). Now my understanding is that I have to reduce my
> checking account by the latter amount (1136.80), but I am under the
> impression that it would be wrong to transfer this amount to the
> "Liabilities:Credit Card" account, because there I don't have the credit
> card expenses from December 2023.
>
> So I'm confused on how to deal with the above. Is there a way I could enter
> some sort of "corrective transaction" to have the correct balance on my
> checking account (which should be -1136.80 and not only -252.55)?
>
> Thanks for your help already!
> F.
>
>
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776832018%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=dGxU1K2G0qZO5XQl8ShqorEk%2B6ylsJzaD174oXfNaAI%3D&reserved=0
> 
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776855411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=NAIFuy2IQbWxSG3WlOYk2EIJICI6xkJJoFM2bN6yTIs%3D&reserved=0
> 
>
> https://na01.saf

[GNC] Reconciliation question

[Boniforti Flavio]

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 payment from my checking account?

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote expected digits after -

[Scott Steimle]

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 via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>1. Re:  Australian Mutual Funds (John Ralls)
>2. Re:  Australian Mutual Funds (John Ralls)
>3. Re:  Multiple accounts (John Ralls)
>4.  Inactive/Hidden accounts (Chris Miller)
>5. Re:  Multiple accounts (Stan Brown (using GC 4.14))
>6. Re:  Monthly Reports (Phyllis Bruce)
>7. Re:  Inactive/Hidden accounts (Stan Brown (using GC 4.14))
>8. Re:  Monthly Reports (Phyllis Bruce)
>9. Re:  Monthly Reports (David Carlson)
>   10.  Finance::Quote expected digits after - (Scott Steimle)
>
>
> --
>
> Message: 1
> Date: Sat, 21 Sep 2024 09:22:54 -0700
> From: John Ralls 
> To: flywire 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Australian Mutual Funds
> Message-ID: 
> Content-Type: text/plain;   charset=utf-8
>
>
>
> > On Sep 20, 2024, at 22:27, flywire  wrote:
> >
> >
> https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html
> > John
> > Ralls wrote:
> >
> >> ...
> >
> >
> > Posts with links can be opened directly if there is clear space around
> the
> > link.  Would commodity Wheat be Type Stock?
> >
> > While this is raised in the context of Managed Funds
> >
> https://www.gnucash.org/docs/v5/C/gnucash-guide/invest_concepts1.html#invest_types2
> > defines
> > Stocks and Mutual Funds:
> >
> >> ...A mutual fund is a group investment mechanism in which you can buy
> into
> >> many stocks simultaneously. For example, a ?S&P 500 index fund? is a
> fund
> >> which purchases all 500 stocks listed in the Standard and Poor?s index.
> >> When you buy a share of this fund, you are really buying a small amount
> of
> >> each of the 500 stocks contained within the fund. Mutual funds are
> treated
> >> exactly like e a single stock, both for tax purposes and in accounting.
> >
> >
> > Firstly, the definition applies equally to Exchange Traded Funds and
> > unlisted Managed Funds. Seems painful splitting the same stock exchange
> > (workspace) into two types. Why differentiate between Account Type Stock
> > and Mutual Fund?
> >
> > Secondly, assuming there is good reason to split from Stock, why not use
> a
> > more generic term "Fund" for Account Type instead of "Mutual Fund??
>
> Those choices were made early in GnuCash?s development by people who
> stopped contributing long ago. I don?t know why they made the choices they
> did; as you say, there?s no accounting difference between mutual funds and
> stocks, and there are lots of commodity types that don?t fit into either
> category. Unfortunately they made other design choices that deeply embed
> that choice into GnuCash?s data so changing it would be a lot of work and
> would require a data migration. It doesn?t seem to me to be worth the
> effort.
>
> Regards,
> John Ralls
>
>
>
>
>
> --
>
> Message: 2
> Date: Sat, 21 Sep 2024 09:32:22 -0700
> From: John Ralls 
> To: Megan Tilley 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Australian Mutual Funds
> Message-ID: <7845a433-a45f-4bd8-bb7c-1c3a81a2e...@ceridwen.us>
> Content-Type: text/plain;   charset=utf-8
>
> Megan,
>
> Perhaps it isn?t obvious that after selecting the account type you need to
> click the Select button in the Security/Currency row to get the Select
> security dialog box. One can?t have an account without an associated
> commodity. It would be a better UI design to disable the OK button when
> that field is empty, but the current code doesn?t do that.
>
> Regards,
> John Ralls
>
> > On Sep 21, 2024, at 02:53, Megan Tilley  wrote:
> >
> > Thanks John - I have moved a step forward, I think:
> >
> >
> > Open Tools>Security Editor ===> First thing is -- I thought you could
> only select the suggest fund (which showed as Stocks to me), not create
> another in the Namespace - I created Mutual, so that worked!
> >
> > New Account information ===> Created the Name, inserted the Code,
> selected the Brokerage Account Mutual Fund as the Parent (So that is
> different to your 2nd screenshot), Account Type set to Mutual Fund. Clicked
> OK - message popped up saying select the commodity.  Screenshot attached. I
> closed the message, moved to select the account name, clicked OK, same
> message popped up.
> >
> >
> > I hope you can see m

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[R Losey]

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 understand how
> it works and how I can apply it to my personal finances. At one point I
> decided to put some real values in it and I put the "opening balances" for
> my bank accounts dating on the 31st of December, 2023. I am now slowly (but
> it is an exercise for me to understand how all this works) manually
> entering my transactions - please don't comment about this being
> time-consuming or similar: I know it already! :-)
>

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 checking account is reduced by the full
bill, and your credit card has a payment of 1136.80, which -- if there are
no new transactions -- should leave the credit card balance at zero.

I hope this helps!


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey :

>
>
> 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 understand how
>> it works and how I can apply it to my personal finances. At one point I
>> decided to put some real values in it and I put the "opening balances" for
>> my bank accounts dating on the 31st of December, 2023. I am now slowly
>> (but
>> it is an exercise for me to understand how all this works) manually
>> entering my transactions - please don't comment about this being
>> time-consuming or similar: I know it already! :-)
>>
>
> 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 checking account is reduced by the full
> bill, and your credit card has a payment of 1136.80, which -- if there are
> no new transactions -- should leave the credit card balance at zero.
>
> I hope this helps!
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[R Losey]

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 date should I enter? The billing date or the date of
> the effective payment from my checking account?
>
> Thanks,
> F.
>



For credit cards, I find it best to use the date on which the statement is
closed out. It is possible to reconcile to "now"; I've done that for
checking / saving accounts  the main point of reconciling is to make
sure that (1) you haven't missed entering some charges/credits (2) There
aren't false charges/credits on your card (3) that the amounts of the
charges/credits in your records and from the bank are the same (most of the
time, any difference is caused by my own typo, but I have caught banks
making errors a few times).


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Boniforti Flavio]

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 past,
therefore I'm not yet fully up-to-date)...
It looks like this now:
[image: image.png]

What am I missing and/or doing wrong?

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 19:18 Uhr schrieb R Losey :

>
>
> 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 date should I enter? The billing date or the date
>> of
>> the effective payment from my checking account?
>>
>> Thanks,
>> F.
>>
>
>
>
> For credit cards, I find it best to use the date on which the statement is
> closed out. It is possible to reconcile to "now"; I've done that for
> checking / saving accounts  the main point of reconciling is to make
> sure that (1) you haven't missed entering some charges/credits (2) There
> aren't false charges/credits on your card (3) that the amounts of the
> charges/credits in your records and from the bank are the same (most of the
> time, any difference is caused by my own typo, but I have caught banks
> making errors a few times).
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[R Losey]

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 of constant -
it is where you "started", and it doesn't make sense to change that: When
you pay off a credit card, you are decreasing the amount of credit they
have extended to you -- not really changing the opening balance, and the
credit card should show that. But perhaps I am wrong.

If you previously used some other method of tracking finances, you'll want
the continuity of having the last balance in the old match the starting
balance in the new.


On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio 
wrote:

> 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.
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey :
>
>>
>>
>> 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 understand how
>>> it works and how I can apply it to my personal finances. At one point I
>>> decided to put some real values in it and I put the "opening balances"
>>> for
>>> my bank accounts dating on the 31st of December, 2023. I am now slowly
>>> (but
>>> it is an exercise for me to understand how all this works) manually
>>> entering my transactions - please don't comment about this being
>>> time-consuming or similar: I know it already! :-)
>>>
>>
>> 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 checking account is reduced by the full
>> bill, and your credit card has a payment of 1136.80, which -- if there are
>> no new transactions -- should leave the credit card balance at zero.
>>
>> I hope this helps!
>>
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Database Versions

[Mark at Lorimark]

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 this:
Gnucash|2060800
Gnucash-Resave|19920
accounts|1
books|1

Gnucash records the version of GnuCash that originally created the 
database. Gnucash-Resave indicates the subversion commit number from the 
original creation of the SQL schema; we’d bump that if we were to make a 
schema change so dramatic that we needed to recreate the whole database 
(we haven’t yet). The remaining records table schema versions. For those 
that aren’t 1 there will be a comment section in the respective table 
implementation file labelled Upgrade (e.g. 
https://github.com/Gnucash/gnucash/blob/63714e5e93b2091b35bbd0d28f69bce03a397d3e/libgnucash/backend/sql/gnc-transaction-sql.cpp#L459 ) with a brief explanation of the change; you can use git blame to find the commit for each of those lines to get to the commit which will usually provide more details about it.


Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 that there's no "Opening Balance" tab in the
credit card account. Is there any way to enter it anyway? Eventually just
as a simple transaction on the 31st of december, calling it "opening
balance"?

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 19:24 Uhr schrieb R Losey :

> 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 of constant
> - it is where you "started", and it doesn't make sense to change that: When
> you pay off a credit card, you are decreasing the amount of credit they
> have extended to you -- not really changing the opening balance, and the
> credit card should show that. But perhaps I am wrong.
>
> If you previously used some other method of tracking finances, you'll want
> the continuity of having the last balance in the old match the starting
> balance in the new.
>
>
> On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio 
> wrote:
>
>> 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.
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey :
>>
>>>
>>>
>>> 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 understand
 how
 it works and how I can apply it to my personal finances. At one point I
 decided to put some real values in it and I put the "opening balances"
 for
 my bank accounts dating on the 31st of December, 2023. I am now slowly
 (but
 it is an exercise for me to understand how all this works) manually
 entering my transactions - please don't comment about this being
 time-consuming or similar: I know it already! :-)

>>>
>>> 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 checking account is reduced by the full
>>> bill, and your credit card has a payment of 1136.80, which -- if there are
>>> no new transactions -- should leave the credit card balance at zero.
>>>
>>> I hope this helps!
>>>
>>>
>>> --
>>> _
>>> Richard Losey
>>> rlo...@gmail.com
>>> Micah 6:8
>>>
>>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Boniforti Flavio]

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
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 19:27 Uhr schrieb R Losey :

> 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 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 past,
>> therefore I'm not yet fully up-to-date)...
>> It looks like this now:
>> [image: image.png]
>>
>> What am I missing and/or doing wrong?
>>
>> Thanks,
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mo., 23. Sept. 2024 um 19:18 Uhr schrieb R Losey :
>>
>>>
>>>
>>> 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 date should I enter? The billing date or the
 date of
 the effective payment from my checking account?

 Thanks,
 F.

>>>
>>>
>>>
>>> For credit cards, I find it best to use the date on which the statement
>>> is closed out. It is possible to reconcile to "now"; I've done that for
>>> checking / saving accounts  the main point of reconciling is to make
>>> sure that (1) you haven't missed entering some charges/credits (2) There
>>> aren't false charges/credits on your card (3) that the amounts of the
>>> charges/credits in your records and from the bank are the same (most of the
>>> time, any difference is caused by my own typo, but I have caught banks
>>> making errors a few times).
>>>
>>>
>>> --
>>> _
>>> Richard Losey
>>> rlo...@gmail.com
>>> Micah 6:8
>>>
>>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[R Losey]

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 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 that there's no "Opening Balance" tab in the
> credit card account. Is there any way to enter it anyway? Eventually just
> as a simple transaction on the 31st of december, calling it "opening
> balance"?
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:24 Uhr schrieb R Losey :
>
>> 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 of constant
>> - it is where you "started", and it doesn't make sense to change that: When
>> you pay off a credit card, you are decreasing the amount of credit they
>> have extended to you -- not really changing the opening balance, and the
>> credit card should show that. But perhaps I am wrong.
>>
>> If you previously used some other method of tracking finances, you'll
>> want the continuity of having the last balance in the old match the
>> starting balance in the new.
>>
>>
>> On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio 
>> wrote:
>>
>>> 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.
>>> https://www.instagram.com/boniforti_music
>>> https://soundcloud.com/boniforti_music
>>> https://bonny-j.bandcamp.com
>>>
>>>
>>> Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey :
>>>


 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 understand
> how
> it works and how I can apply it to my personal finances. At one point I
> decided to put some real values in it and I put the "opening balances"
> for
> my bank accounts dating on the 31st of December, 2023. I am now slowly
> (but
> it is an exercise for me to understand how all this works) manually
> entering my transactions - please don't comment about this being
> time-consuming or similar: I know it already! :-)
>

 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 checking account is reduced by the full
 bill, and your credit card has a payment of 1136.80, which -- if there are
 no new transactions -- should leave the credit card balance at zero.

 I hope this helps!


 --
 _
 Richard Losey
 rlo...@gmail.com
 Micah 6:8

>>>
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Database Versions

[John Ralls]

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|4
splits|5
billterms|2
customers|2
employees|2
entries|4
invoices|4
jobs|1
orders|1
taxtables|2
taxtable_entries|3
vendors|1
recurrences|2
slots|4

Gnucash records the version of GnuCash that originally created the database. 
Gnucash-Resave indicates the subversion commit number from the original 
creation of the SQL schema; we’d bump that if we were to make a schema change 
so dramatic that we needed to recreate the whole database (we haven’t yet). The 
remaining records table schema versions. For those that aren’t 1 there will be 
a comment section in the respective table implementation file labelled Upgrade 
(e.g. 
https://github.com/Gnucash/gnucash/blob/63714e5e93b2091b35bbd0d28f69bce03a397d3e/libgnucash/backend/sql/gnc-transaction-sql.cpp#L459)
 with a brief explanation of the change; you can use git blame to find the 
commit for each of those lines to get to the commit which will usually provide 
more details about it.

Regards,
John Ralls


> On Sep 23, 2024, at 09:01, Mark at Lorimark  
> wrote:
> 
> 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-line as to the differences in the 
> database schema for these different versions, and also does GnuCash 
> automatically apply schema changes to the data when things change?
> 
>> mark@lsus2:~/LorimarkSolutions/gnucash$ sqlite3 Gnucash58Test.gnucash
>> sqlite> select * from versions;
>> Gnucash|508
>> Gnucash-Resave|19920
> 
>> mark@lsus2:~/LorimarkSolutions/gnucash$ sqlite3 LorimarkSolutions.gnucash 
>> sqlite> select * from versions;
>> Gnucash|413
>> Gnucash-Resave|19920
>> books|1
> 
> -- 
> ~mark petryk
> ~w:http://www.lorimarksolutions.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[R Losey]

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 negative numbers, but to some people, the negative and
positive numbers would be MORE confusing -- easier to have the credits and
debits separated. It is merely a design decision -- possibly influenced by
the background of the designer.



On Mon, Sep 23, 2024 at 12:32 PM 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.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:27 Uhr schrieb R Losey :
>
>> 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 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 past,
>>> therefore I'm not yet fully up-to-date)...
>>> It looks like this now:
>>> [image: image.png]
>>>
>>> What am I missing and/or doing wrong?
>>>
>>> Thanks,
>>> F.
>>>
>>> https://www.instagram.com/boniforti_music
>>> https://soundcloud.com/boniforti_music
>>> https://bonny-j.bandcamp.com
>>>
>>>
>>> Am Mo., 23. Sept. 2024 um 19:18 Uhr schrieb R Losey :
>>>


 On Mon, Sep 23, 2024 at 11:20 AM Boniforti Flavio <
 bonifort...@gmail.com> 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 date should I enter? The billing date or the
> date of
> the effective payment from my checking account?
>
> Thanks,
> F.
>



 For credit cards, I find it best to use the date on which the statement
 is closed out. It is possible to reconcile to "now"; I've done that for
 checking / saving accounts  the main point of reconciling is to make
 sure that (1) you haven't missed entering some charges/credits (2) There
 aren't false charges/credits on your card (3) that the amounts of the
 charges/credits in your records and from the bank are the same (most of the
 time, any difference is caused by my own typo, but I have caught banks
 making errors a few times).


 --
 _
 Richard Losey
 rlo...@gmail.com
 Micah 6:8

>>>
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[R Losey]

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 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 past,
> therefore I'm not yet fully up-to-date)...
> It looks like this now:
> [image: image.png]
>
> What am I missing and/or doing wrong?
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:18 Uhr schrieb R Losey :
>
>>
>>
>> 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 date should I enter? The billing date or the date
>>> of
>>> the effective payment from my checking account?
>>>
>>> Thanks,
>>> F.
>>>
>>
>>
>>
>> For credit cards, I find it best to use the date on which the statement
>> is closed out. It is possible to reconcile to "now"; I've done that for
>> checking / saving accounts  the main point of reconciling is to make
>> sure that (1) you haven't missed entering some charges/credits (2) There
>> aren't false charges/credits on your card (3) that the amounts of the
>> charges/credits in your records and from the bank are the same (most of the
>> time, any difference is caused by my own typo, but I have caught banks
>> making errors a few times).
>>
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Kalpesh Patel]

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). Once you put a 
check mark in the R column of that payment transaction, it will bring your 
overall balance in line with your statements as difference will change to zero, 
and the Finish button will become live button that you can click on.

 

You need to reconcile all transactions from the bill – i.e., all debits, and 
all credits resulting from either as a payment or as a result of returning back 
an item – not just purchases (debits).

 

 

PS: Please don’t forget to carbon copy to the mail list so that either other 
members can assist or can learn.

 

From: Boniforti Flavio  
Sent: Monday, September 23, 2024 12:54 PM
To: Kalpesh Patel 
Subject: Re: [GNC] Reconciliation question

 

Thank you Patel.

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 past, therefore I'm not 
yet fully up-to-date)...

It looks like this now:



 

What am I missing and/or doing wrong?

 

Thanks,

F.

 

https://www.instagram.com/boniforti_music

https://soundcloud.com/boniforti_music

https://bonny-j.bandcamp.com

 

 

Am Mo., 23. Sept. 2024 um 18:43 Uhr schrieb Kalpesh Patel 
mailto:kalpesh.pa...@usa.net> >:

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 mailto:bonifort...@gmail.com> > 
Sent: Monday, September 23, 2024 12:19 PM
To: gnucash-user@gnucash.org  
Subject: [GNC] Reconciliation question

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 payment from my checking account?

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Boniforti Flavio]

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 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).
> Once you put a check mark in the R column of that payment transaction, it
> will bring your overall balance in line with your statements as difference
> will change to zero, and the Finish button will become live button that you
> can click on.
>
>
>
> You need to reconcile all transactions from the bill – i.e., all debits,
> and all credits resulting from either as a payment or as a result of
> returning back an item – not just purchases (debits).
>
>
>
>
>
> PS: Please don’t forget to carbon copy to the mail list so that either
> other members can assist or can learn.
>
>
>
> *From:* Boniforti Flavio 
> *Sent:* Monday, September 23, 2024 12:54 PM
> *To:* Kalpesh Patel 
> *Subject:* Re: [GNC] Reconciliation question
>
>
>
> Thank you Patel.
>
> 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 past,
> therefore I'm not yet fully up-to-date)...
>
> It looks like this now:
>
> [image: image.png]
>
>
>
> What am I missing and/or doing wrong?
>
>
>
> Thanks,
>
> F.
>
>
>
> https://www.instagram.com/boniforti_music
>
> https://soundcloud.com/boniforti_music
>
> https://bonny-j.bandcamp.com
>
>
>
>
>
> Am Mo., 23. Sept. 2024 um 18:43 Uhr schrieb Kalpesh Patel <
> kalpesh.pa...@usa.net>:
>
> 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, 2024 12:19 PM
> To: gnucash-user@gnucash.org
> Subject: [GNC] Reconciliation question
>
> 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 payment from my checking account?
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 transaction, as shown in my earlier reply
with a screenshot.

Thanks for your help!
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 19:39 Uhr schrieb R Losey :

> 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 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 that there's no "Opening Balance" tab in the
>> credit card account. Is there any way to enter it anyway? Eventually just
>> as a simple transaction on the 31st of december, calling it "opening
>> balance"?
>>
>> Thanks,
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mo., 23. Sept. 2024 um 19:24 Uhr schrieb R Losey :
>>
>>> 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 of
>>> constant - it is where you "started", and it doesn't make sense to change
>>> that: When you pay off a credit card, you are decreasing the amount of
>>> credit they have extended to you -- not really changing the opening
>>> balance, and the credit card should show that. But perhaps I am wrong.
>>>
>>> If you previously used some other method of tracking finances, you'll
>>> want the continuity of having the last balance in the old match the
>>> starting balance in the new.
>>>
>>>
>>> On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio 
>>> wrote:
>>>
 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.
 https://www.instagram.com/boniforti_music
 https://soundcloud.com/boniforti_music
 https://bonny-j.bandcamp.com


 Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey :

>
>
> On Mon, Sep 23, 2024 at 8:20 AM Boniforti Flavio <
> bonifort...@gmail.com> 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 understand
>> how
>> it works and how I can apply it to my personal finances. At one point
>> I
>> decided to put some real values in it and I put the "opening
>> balances" for
>> my bank accounts dating on the 31st of December, 2023. I am now
>> slowly (but
>> it is an exercise for me to understand how all this works) manually
>> entering my transactions - please don't comment about this being
>> time-consuming or similar: I know it already! :-)
>>
>
> 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 checking account is reduced by the full
> bill, and your credit card has a payment of 1136.80, which -- if there are
> no new transactions -- should leave the credit card balance at zero.
>
> I hope this helps!
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>

>>>
>>> --
>>> _
>>> Richard Losey
>>> rlo...@gmail.com
>>> Micah 6:8
>>>
>>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Stan Brown (using GC 4.14)]

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 Opening Balance is a kind of constant -
> it is where you "started", and it doesn't make sense to change that: When
> you pay off a credit card, you are decreasing the amount of credit they
> have extended to you -- not really changing the opening balance, and the
> credit card should show that. But perhaps I am wrong.

I think you are spot on, not wrong. To me, the reconciliation revealed
that an error had been made in recording the opening balances, and the
proper thing to do was to correct the error. The error might be
corrected by going back and fixing the original recording of opening
balances, or by entering a new transaction specifically to correct the
error -- that's a mater or personal preference in keeping one's personal
books (as opposed to business records).

All of this discussion really shows what we often say: this is not a
GnuCash question, it's an accounting question. It's very, very important
to have a good grasp of double-entry bookkeeping then  these questions
become much simpler. In some of these discussions, I fear that people
ask how to record something in GC instead of thinking about how a given
event fits into the double-entry structure. In GC, we need the same
thought process we used to follow before recording a transaction in
leather-bound ledgers with pen and ink.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[David Carlson]

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/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 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).
> > Once you put a check mark in the R column of that payment transaction, it
> > will bring your overall balance in line with your statements as
> difference
> > will change to zero, and the Finish button will become live button that
> you
> > can click on.
> >
> >
> >
> > You need to reconcile all transactions from the bill – i.e., all debits,
> > and all credits resulting from either as a payment or as a result of
> > returning back an item – not just purchases (debits).
> >
> >
> >
> >
> >
> > PS: Please don’t forget to carbon copy to the mail list so that either
> > other members can assist or can learn.
> >
> >
> >
> > *From:* Boniforti Flavio 
> > *Sent:* Monday, September 23, 2024 12:54 PM
> > *To:* Kalpesh Patel 
> > *Subject:* Re: [GNC] Reconciliation question
> >
> >
> >
> > Thank you Patel.
> >
> > 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 past,
> > therefore I'm not yet fully up-to-date)...
> >
> > It looks like this now:
> >
> > [image: image.png]
> >
> >
> >
> > What am I missing and/or doing wrong?
> >
> >
> >
> > Thanks,
> >
> > F.
> >
> >
> >
> > https://www.instagram.com/boniforti_music
> >
> > https://soundcloud.com/boniforti_music
> >
> > https://bonny-j.bandcamp.com
> >
> >
> >
> >
> >
> > Am Mo., 23. Sept. 2024 um 18:43 Uhr schrieb Kalpesh Patel <
> > kalpesh.pa...@usa.net>:
> >
> > 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, 2024 12:19 PM
> > To: gnucash-user@gnucash.org
> > Subject: [GNC] Reconciliation question
> >
> > 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 payment from my checking account?
> >
> > Thanks,
> > F.
> >
> > https://www.instagram.com/boniforti_music
> > https://soundcloud.com/boniforti_music
> > https://bonny-j.bandcamp.com
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 worked very well and of course I also followed the suggestions to
read through some material :-)

Thanks again for the help I'm receiving from the list.
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 20:20 Uhr schrieb Stan Brown (using GC 4.14) <
stan...@fastmail.fm>:

> 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 Opening Balance is a kind of
> constant -
> > it is where you "started", and it doesn't make sense to change that: When
> > you pay off a credit card, you are decreasing the amount of credit they
> > have extended to you -- not really changing the opening balance, and the
> > credit card should show that. But perhaps I am wrong.
>
> I think you are spot on, not wrong. To me, the reconciliation revealed
> that an error had been made in recording the opening balances, and the
> proper thing to do was to correct the error. The error might be
> corrected by going back and fixing the original recording of opening
> balances, or by entering a new transaction specifically to correct the
> error -- that's a mater or personal preference in keeping one's personal
> books (as opposed to business records).
>
> All of this discussion really shows what we often say: this is not a
> GnuCash question, it's an accounting question. It's very, very important
> to have a good grasp of double-entry bookkeeping then  these questions
> become much simpler. In some of these discussions, I fear that people
> ask how to record something in GC instead of thinking about how a given
> event fits into the double-entry structure. In GC, we need the same
> thought process we used to follow before recording a transaction in
> leather-bound ledgers with pen and ink.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 values in it and I put the "opening balances" for
my bank accounts dating on the 31st of December, 2023. I am now slowly (but
it is an exercise for me to understand how all this works) manually
entering my transactions - please don't comment about this being
time-consuming or similar: I know it already! :-)

I do now have a situation which I don't know how to handle, therefore I'm
posting here.
I've entered all my credit card expenses for the month of January 2023. The
credit card bill was emitted on January 14th and paid from my checking
account on January 25th. I did the "reconciliation" on my
Liabilities:Credit Card account but I did just reconcile 252.55 (which is
the amount of credit card payments between 1st and 14th of January). But of
course my checking account was reduced by the full amount of the credit
card bill (1136.80). Now my understanding is that I have to reduce my
checking account by the latter amount (1136.80), but I am under the
impression that it would be wrong to transfer this amount to the
"Liabilities:Credit Card" account, because there I don't have the credit
card expenses from December 2023.

So I'm confused on how to deal with the above. Is there a way I could enter
some sort of "corrective transaction" to have the correct balance on my
checking account (which should be -1136.80 and not only -252.55)?

Thanks for your help already!
F.


https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Murugan Mariappan]

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: Re: [GNC] How to record a transaction which covers a time period in 
the past which is not in GnuCash?

Hi Murugan. Thanks.
So it means I decrease my checking account as well as my Equity "Opening 
Balance"?
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 15:39 Uhr schrieb Murugan Mariappan 
mailto:m.muruganan...@hotmail.com>>:
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


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Boniforti Flavio 
mailto:bonifort...@gmail.com>>
Sent: 23 September 2024 10:18
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] How to record a transaction which covers a time period in the 
past which is not in GnuCash?

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 values in it and I put the "opening balances" for
my bank accounts dating on the 31st of December, 2023. I am now slowly (but
it is an exercise for me to understand how all this works) manually
entering my transactions - please don't comment about this being
time-consuming or similar: I know it already! :-)

I do now have a situation which I don't know how to handle, therefore I'm
posting here.
I've entered all my credit card expenses for the month of January 2023. The
credit card bill was emitted on January 14th and paid from my checking
account on January 25th. I did the "reconciliation" on my
Liabilities:Credit Card account but I did just reconcile 252.55 (which is
the amount of credit card payments between 1st and 14th of January). But of
course my checking account was reduced by the full amount of the credit
card bill (1136.80). Now my understanding is that I have to reduce my
checking account by the latter amount (1136.80), but I am under the
impression that it would be wrong to transfer this amount to the
"Liabilities:Credit Card" account, because there I don't have the credit
card expenses from December 2023.

So I'm confused on how to deal with the above. Is there a way I could enter
some sort of "corrective transaction" to have the correct balance on my
checking account (which should be -1136.80 and not only -252.55)?

Thanks for your help already!
F.


https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776832018%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=dGxU1K2G0qZO5XQl8ShqorEk%2B6ylsJzaD174oXfNaAI%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsoundcloud.com%2Fboniforti_music&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776855411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=NAIFuy2IQbWxSG3WlOYk2EIJICI6xkJJoFM2bN6yTIs%3D&reserved=0
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbonny-j.bandcamp.com%2F&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776868625%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=0jYjPQVXwk1Ux9nXFVrxz9Q518U9SI3JxDIG3z%2BNFrM%3D&reserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C17395c88f962426cc87d08dcdbd29899%7C84df9e7fe9f640afb435%7C1%7C0%7C638626944776880128%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=guYfZIOVwu7dJ%2FrB%2B17udrO5WjVbsdbaYBIeP%2FK13YM%3D&reserved=0

Re: [GNC] Reconciliation question

[R Losey]

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 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 reconcile the right part, I do have the old "Funds In" on the
> right... the one I used for reconciling the previous month...
>
> So to me it feels like some sort of "delayed" reconciliation. First I agree
> on the "Funds Out" comparing the credit card bill of this month. Then the
> next month I will reconcile again the Funds Out with the credit card bill -
> but at the same time I have to reconcile the "previous" "Funds In"?
>
> Sorry, but maybe this is a lack of accounting knowledge on my end :-(
>
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 23:29 Uhr schrieb Maf. King :
>
> > 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 "reconcile" means (more or less) "to come to an agreement"
> >
> > You and the bank come to "agree" on the state of your account at some
> > point in
> > time. You "reconcile" your version against their statement.  If (for
> > example) they have charged you twice for something, then you tell them
> and
> > hopefully get a resolution you are happy with.
> >
> > naturally, you want to agree on both funds in and funds out of the
> account!
> >
> > HTH,
> > Maf.
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Boniforti Flavio]

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 used for reconciling the previous month...

So to me it feels like some sort of "delayed" reconciliation. First I agree
on the "Funds Out" comparing the credit card bill of this month. Then the
next month I will reconcile again the Funds Out with the credit card bill -
but at the same time I have to reconcile the "previous" "Funds In"?

Sorry, but maybe this is a lack of accounting knowledge on my end :-(

F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 23:29 Uhr schrieb Maf. King :

> 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 "reconcile" means (more or less) "to come to an agreement"
>
> You and the bank come to "agree" on the state of your account at some
> point in
> time. You "reconcile" your version against their statement.  If (for
> example) they have charged you twice for something, then you tell them and
> hopefully get a resolution you are happy with.
>
> naturally, you want to agree on both funds in and funds out of the account!
>
> HTH,
> Maf.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle a purchase I paid using money from two different sources?

[Phyllis Bruce]

   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 have not changed those figures since day one.  There may
   be a report you can run if the current amount is important to you but
   they are only your opening balances.  Any time you enter the
   reconciliation screen, the current former balance is shown first,
   followed by the date of your statement.  You take your ending balance
   from your statement and enter that amount.  Voila, now you simply
   proceed to compare your open items in the screen based on your
   statement.   Just the way you would if you were balancing your
   checkbook.

   Hope this helps at all.  To me you are doing extra, unnecessary work
   for no gain.  But then, we all have different needs.

   Po

 On Sep 23, 2024, at 4:27 PM, Boniforti Flavio
  wrote:

   
   Hi Phyllis.
   As you were typing the reply I played with the split transaction and
   indeed that was the solution! :-)
   Sorry for bothering.
   F.
   [1]https://www.instagram.com/boniforti_music
   [2]https://soundcloud.com/boniforti_music
   [3]https://bonny-j.bandcamp.com
   Am Mo., 23. Sept. 2024 um 23:23 Uhr schrieb Phyllis Bruce
   <[4]pobruc...@gmail.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
 <[5]bonifort...@gmail.com> wrote:
 >
 > 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.
 >
 > [6]https://www.instagram.com/boniforti_music
 > [7]https://soundcloud.com/boniforti_music
 > [8]https://bonny-j.bandcamp.com
 > ___
 > gnucash-user mailing list
 > [9]gnucash-user@gnucash.org
 > To update your subscription preferences or to unsubscribe:
 > [10]https://lists.gnucash.org/mailman/listinfo/gnucash-user
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.

References

   1. https://www.instagram.com/boniforti_music
   2. https://soundcloud.com/boniforti_music
   3. https://bonny-j.bandcamp.com/
   4. mailto:pobruc...@gmail.com
   5. mailto:bonifort...@gmail.com
   6. https://www.instagram.com/boniforti_music
   7. https://soundcloud.com/boniforti_music
   8. https://bonny-j.bandcamp.com/
   9. mailto:gnucash-user@gnucash.org
  10. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Maf. King]

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 reconcile the right part, I do have the old "Funds In" on the
> right... the one I used for reconciling the previous month...
> 
> So to me it feels like some sort of "delayed" reconciliation. First I agree
> on the "Funds Out" comparing the credit card bill of this month. Then the
> next month I will reconcile again the Funds Out with the credit card bill -
> but at the same time I have to reconcile the "previous" "Funds In"?
> 
> Sorry, but maybe this is a lack of accounting knowledge on my end :-(
> 
> F.
> 


No problem.

if i understand your flow correctly:

You made various transactions in Dec 2023 (the opening balance) and recorded 
detailed transactions in Jan 2024.

on (say) 20th Jan, You were sent a statement, which reconciled OK.

on say 21 Jan, you pay that bill.
Then you spend more during late jan & feb

On Feb 20 you get a bill, and reconcile.  Since the last statement, you have 
sent the CCard bank the payment for the Jan statement, so that is shown on the 
feb statement as a transaction which happened after the previous bill was 
sent?

Does that explain why both sides get reconciled, even though the "bill 
payment" feels like you are seeing it a month late?

or am I misunderstanding your question?

Maf.






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote expected digits after -

[Fred Tydeman]

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
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle a purchase I paid using money from two different sources?

[Boniforti Flavio]

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://bonny-j.bandcamp.com


Am Mo., 23. Sept. 2024 um 23:45 Uhr schrieb Phyllis Bruce <
pobruc...@gmail.com>:

> 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 have not
> changed those figures since day one.  There may be a report you can run if
> the current amount is important to you but they are only your opening
> balances.  Any time you enter the reconciliation screen, the current former
> balance is shown first, followed by the date of your statement.  You take
> your ending balance from your statement and enter that amount.  Voila, now
> you simply proceed to compare your open items in the screen based on your
> statement.   Just the way you would if you were balancing your checkbook.
>
> Hope this helps at all.  To me you are doing extra, unnecessary work for
> no gain.  But then, we all have different needs.
> Po
>
> On Sep 23, 2024, at 4:27 PM, Boniforti Flavio 
> wrote:
>
> 
> 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 Phyllis Bruce <
> pobruc...@gmail.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.
>> > 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
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[R Losey]

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 just enter correcting transactions,
which would have the effect of "undoing" the errors in the original entry,
but it's not as immediately clear as to how it should be entered.



On Mon, Sep 23, 2024 at 1:16 PM Boniforti Flavio 
wrote:

> 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 transaction, as shown in my earlier
> reply with a screenshot.
>
> Thanks for your help!
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:39 Uhr schrieb R Losey :
>
>> 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 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 that there's no "Opening Balance" tab in the
>>> credit card account. Is there any way to enter it anyway? Eventually just
>>> as a simple transaction on the 31st of december, calling it "opening
>>> balance"?
>>>
>>> Thanks,
>>> F.
>>>
>>> https://www.instagram.com/boniforti_music
>>> https://soundcloud.com/boniforti_music
>>> https://bonny-j.bandcamp.com
>>>
>>>
>>> Am Mo., 23. Sept. 2024 um 19:24 Uhr schrieb R Losey :
>>>
 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 of
 constant - it is where you "started", and it doesn't make sense to change
 that: When you pay off a credit card, you are decreasing the amount of
 credit they have extended to you -- not really changing the opening
 balance, and the credit card should show that. But perhaps I am wrong.

 If you previously used some other method of tracking finances, you'll
 want the continuity of having the last balance in the old match the
 starting balance in the new.


 On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio <
 bonifort...@gmail.com> wrote:

> 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.
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey  >:
>
>>
>>
>> On Mon, Sep 23, 2024 at 8:20 AM Boniforti Flavio <
>> bonifort...@gmail.com> 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
>>> understand how
>>> it works and how I can apply it to my personal finances. At one
>>> point I
>>> decided to put some real values in it and I put the "opening
>>> balances" for
>>> my bank accounts dating on the 31st of December, 2023. I am now
>>> slowly (but
>>> it is an exercise for me to understand how all this works) manually
>>> entering my transactions - please don't comment about this being
>>> time-consuming or similar: I know it already! :-)
>>>
>>
>> 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 checking account is reduced by the 
>> full
>> bill, and your credit card has a payment of 1136.80, which -- if there 
>> are
>> no new transactions -- should leave th

[GNC] How to handle a purchase I paid using money from two different sources?

[Boniforti Flavio]

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
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle a purchase I paid using money from two different sources?

[Phyllis Bruce]

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.
> 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
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle a purchase I paid using money from two different sources?

[Boniforti Flavio]

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 Phyllis Bruce <
pobruc...@gmail.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.
> > 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
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[Maf. King]

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 "reconcile" means (more or less) "to come to an agreement"

You and the bank come to "agree" on the state of your account at some point in 
time. You "reconcile" your version against their statement.  If (for 
example) they have charged you twice for something, then you tell them and 
hopefully get a resolution you are happy with.

naturally, you want to agree on both funds in and funds out of the account!

HTH,
Maf.
 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Maf. King]

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 checking account is reduced by the full
> bill, and your credit card has a payment of 1136.80, which -- if there are
> no new transactions -- should leave the credit card balance at zero.
> 

Exactly what I would have done.  

Murugan's method works too, and is probably the more accurate answer for "how 
do i do this".rather than "should i be in this place to start with, could 
i do something different to avoid this".

Maf.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to receive a Daily Digest

[Megan Tilley]

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
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record a transaction which covers a time period in the past which is not in GnuCash?

[Boniforti Flavio]

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 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 just enter correcting transactions,
> which would have the effect of "undoing" the errors in the original entry,
> but it's not as immediately clear as to how it should be entered.
>
>
>
> On Mon, Sep 23, 2024 at 1:16 PM Boniforti Flavio 
> wrote:
>
>> 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 transaction, as shown in my earlier
>> reply with a screenshot.
>>
>> Thanks for your help!
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mo., 23. Sept. 2024 um 19:39 Uhr schrieb R Losey :
>>
>>> 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 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 that there's no "Opening Balance" tab in the
 credit card account. Is there any way to enter it anyway? Eventually just
 as a simple transaction on the 31st of december, calling it "opening
 balance"?

 Thanks,
 F.

 https://www.instagram.com/boniforti_music
 https://soundcloud.com/boniforti_music
 https://bonny-j.bandcamp.com


 Am Mo., 23. Sept. 2024 um 19:24 Uhr schrieb R Losey :

> 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 of
> constant - it is where you "started", and it doesn't make sense to change
> that: When you pay off a credit card, you are decreasing the amount of
> credit they have extended to you -- not really changing the opening
> balance, and the credit card should show that. But perhaps I am wrong.
>
> If you previously used some other method of tracking finances, you'll
> want the continuity of having the last balance in the old match the
> starting balance in the new.
>
>
> On Mon, Sep 23, 2024 at 12:13 PM Boniforti Flavio <
> bonifort...@gmail.com> wrote:
>
>> 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.
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am Mo., 23. Sept. 2024 um 19:09 Uhr schrieb R Losey > >:
>>
>>>
>>>
>>> On Mon, Sep 23, 2024 at 8:20 AM Boniforti Flavio <
>>> bonifort...@gmail.com> 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
 understand how
 it works and how I can apply it to my personal finances. At one
 point I
 decided to put some real values in it and I put the "opening
 balances" for
 my bank accounts dating on the 31st of December, 2023. I am now
 slowly (but
 it is an exercise for me to understand how all this works) manually
 entering my transactions - please don't comment about this being
 time-consuming or similar: I know it already! :-)

>>>
>>> Well, your opening balance for your cred

Re: [GNC] How to handle a purchase I paid using money from two different sources?

[Phyllis Bruce]

   👍😁

 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,
   F.
   [1]https://www.instagram.com/boniforti_music
   [2]https://soundcloud.com/boniforti_music
   [3]https://bonny-j.bandcamp.com
   Am Mo., 23. Sept. 2024 um 23:45 Uhr schrieb Phyllis Bruce
   <[4]pobruc...@gmail.com>:

   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 have not changed those figures since day one.  There may
   be a report you can run if the current amount is important to you but
   they are only your opening balances.  Any time you enter the
   reconciliation screen, the current former balance is shown first,
   followed by the date of your statement.  You take your ending balance
   from your statement and enter that amount.  Voila, now you simply
   proceed to compare your open items in the screen based on your
   statement.   Just the way you would if you were balancing your
   checkbook.
   Hope this helps at all.  To me you are doing extra, unnecessary work
   for no gain.  But then, we all have different needs.
   Po

 On Sep 23, 2024, at 4:27 PM, Boniforti Flavio
 <[5]bonifort...@gmail.com> wrote:

   
   Hi Phyllis.
   As you were typing the reply I played with the split transaction and
   indeed that was the solution! :-)
   Sorry for bothering.
   F.
   [6]https://www.instagram.com/boniforti_music
   [7]https://soundcloud.com/boniforti_music
   [8]https://bonny-j.bandcamp.com
   Am Mo., 23. Sept. 2024 um 23:23 Uhr schrieb Phyllis Bruce
   <[9]pobruc...@gmail.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
 <[10]bonifort...@gmail.com> wrote:
 >
 > 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.
 >
 > [11]https://www.instagram.com/boniforti_music
 > [12]https://soundcloud.com/boniforti_music
 > [13]https://bonny-j.bandcamp.com
 > ___
 > gnucash-user mailing list
 > [14]gnucash-user@gnucash.org
 > To update your subscription preferences or to unsubscribe:
 > [15]https://lists.gnucash.org/mailman/listinfo/gnucash-user
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.

References

   1. https://www.instagram.com/boniforti_music
   2. https://soundcloud.com/boniforti_music
   3. https://bonny-j.bandcamp.com/
   4. mailto:pobruc...@gmail.com
   5. mailto:bonifort...@gmail.com
   6. https://www.instagram.com/boniforti_music
   7. https://soundcloud.com/boniforti_music
   8. https://bonny-j.bandcamp.com/
   9. mailto:pobruc...@gmail.com
  10. mailto:bonifort...@gmail.com
  11. https://www.instagram.com/boniforti_music
  12. https://soundcloud.com/boniforti_music
  13. https://bonny-j.bandcamp.com/
  14. mailto:gnucash-user@gnucash.org
  15. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to receive a Daily Digest

[Liz]

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 Sydney
> 2024-09-24  0813hrs
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Of course
See a few lines above 
"update subscription preferences" 
that link will ask you to log in and then you can change your messages
to the "Digest" 

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import from Quicken to GnuCash not Working

[Ernie Wakamatsu]

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 did the following hack.


  1.
 Imported by accounts. This made deciphering QIF commands easier
  2.
If an import failed, I investigated the QIF commands.  If memory doesn't fail 
me, there were some commands which were not complete or formatted differently 
(sorry I didn't keep notes) than the documented QIF commands or expected by GC
  3.
I also had to setup my investment securities and things first, before I 
imported investment accounts

That is it in a nutshell.  As you can tell, I hacked my way through, but glad I 
made the switch.

Hope this helps,



From: gnucash-user  on 
behalf of Kalpesh Patel 
Sent: 24 September 2024 01:51
To: 'Keld Sorensen' ; 'Joseph Keithley' 

Cc: gnucash-user@gnucash.org ; 'Ken Farley' 

Subject: Re: [GNC] Import from Quicken to GnuCash not Working

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, September 23, 2024 9:39 AM
To: Joseph Keithley 
Cc: Tom R ; gnucash-user@gnucash.org; Ken Farley 

Subject: Re: [GNC] Import from Quicken to GnuCash not Working

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 hide all kinds of problems 
that will rear their ugly heads in the double entry method.

Even the best of Quicken files is likely to have many issues from this and 
other sources, which will require careful editing after an import.

These issues beget the question of whether it is worth the effort to import a 
Quicken file.
Prior to importing from Quicken, it is worth the users time to better 
understand double entry by reading up on all the help material. This will also 
make the "edit" session easier after the import.

Starting "from scratch" with a GnuCash file has many advantages.
One such advantage is the consistent use of double entry to minimize risk of 
accounting errors in the future.



On Mon, Sep 23, 2024 at 4:01 AM Joseph Keithley  wrote:

> 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
> qdf file into individual accounts by year before I imported them (30+
> years and roughly 100 different accounts).  That was the only way I
> could get gnucash to import my complete data without crashing.
> Unfortunately it was a few years back and I don't exactly remember
> what import settings and options I chose.
>
> The only help I can offer is that you can import one year at a time
> and then save the file to create a backup file.  Then import the next
> year and save the file as a new backup file.  Keep up the process
> until one of the imports crashes.  At least then you can narrow down
> what year of data is causing the issue and you will have a backup up
> file of all the prior imports.  Since the qif file is a simple text file you 
> can open the "bad"
> qif file in notepad and look through the file for errors.  You can
> also skip that "bad" file and continue the process with the remaining
> files just to get as much imported as possible.
>
> On Mon, Sep 23, 2024 at 4:15 AM Tom R  wrote:
>
>
>


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote expected digits after -

[Bruce Schuck]

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 have come from 0 / 0


Scott and I took the conversation to the SourceForge finance-quote-user 
email list - 
https://sourceforge.net/p/finance-quote/mailman/message/58820313/


Unfortunately many of the F::Q modules, old and new, have minimal data 
validation. In this case the code was attempting to multiply "nan" by 
100 (the annual yield in the JSON is a decimal fraction and needs to be 
multiplied by 100 to convert to percentage). Seems some securities from 
YahooJSON with no dividends have a 0 (MXL for example) in the field, and 
others like SICP will have "nan".


Fixed in trial release 1.63_03 (CPAN: 
BPSCHUCK/Finance-Quote-1.63_03.tar.gz).


Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation question

[David Cousens]

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 Credits to your credit account record your record of the
chrges(Funds Out) and the Payments you have made in the period (Funds
in). 

Closing Balance= Starting Balance - Funds Out + Funds In

For a good reconciliation all of the following quantities ( including
the individual transactions) should match exactly between the  bank's
record (statement) and your record, the Credit Card account in GnuCash.

David Cousens

On Mon, 2024-09-23 at 23:40 +0200, 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 reconcile the right part, I do have the old "Funds In" on the
> right... the one I used for reconciling the previous month...
> 
> So to me it feels like some sort of "delayed" reconciliation. First I
> agree
> on the "Funds Out" comparing the credit card bill of this month. Then
> the
> next month I will reconcile again the Funds Out with the credit card
> bill -
> but at the same time I have to reconcile the "previous" "Funds In"?
> 
> Sorry, but maybe this is a lack of accounting knowledge on my end :-(
> 
> F.
> 
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
> 
> 
> Am Mo., 23. Sept. 2024 um 23:29 Uhr schrieb Maf. King
> :
> 
> > 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 "reconcile" means (more or less) "to come to an agreement"
> > 
> > You and the bank come to "agree" on the state of your account at
> > some
> > point in
> > time. You "reconcile" your version against their statement.  If
> > (for
> > example) they have charged you twice for something, then you tell
> > them and
> > hopefully get a resolution you are happy with.
> > 
> > naturally, you want to agree on both funds in and funds out of the
> > account!
> > 
> > HTH,
> > Maf.
> > 
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Fwd: Re: How to treat a sale which involves more accounts?

[David Cousens]

--- 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 any subsequent sale is

Asset:bank                                             debit yyy
Income:Musical Instrument Sales credit  yyy

and you may or may not be required to pay tax on that income depending
on your jurisdictions tax rules (in most cases probably not if below
some legislated threshold for business activity), and that would be the
end of it.  In most jurisdictions you will also likely be below the
threshold where any such activities are treated on a cash accounting
basis, i.e. they are recorded at the point where the money changes
hands.

When you purchase instruments where the intention is to either resell
them or otherwise use them to generate income usually on some form of
fairly regular basis, then when they are purchased, they are an asset
to your enterprise, whether that is simply personal or a business, so
the purchase becomes an asset rather than an expense. For business
usually where turnover is above a specified threshold set by taxation
legislation, you will be required to record transactions on an accrual
timing basis and for purchases, this is generally at the time when the
agreement to make a specific purchase is entered into, not when the
actual; cash changes hands.  Similarly on sales, when you agree to sell
an item, the receipt of income is recorded at the time you agree to do
so not necessarily when you actually receive the funds.  

There is another accounting principle which requires that the recording
of expense of items sold should be matched in timing to the recording
of the income. recording purchases as an asset class inventory meets
the first requirement and recording it as an expense against the Cost
of Goods Sold at the timing of the sale meets the second. The Cost of
Goods Sold title just arises because most businesses will sell many
different types of items. If the expense were recorded at the time of
purchase, then the calculation of profit   is thrown out of whack and
if you do that your taxation authorities tend to start accusing you of
trying to avoid tax. 
 Such Inventory and CoGS accounts can have subaccounts for specific
items or classes of items where knowing that information is  material
to the management of the business.  There are also sales taxes, VAT,
GST type taxes to deal with as well in some jurisdictions.

On Mon, 2024-09-23 at 17:26 +0200, Boniforti Flavio wrote:
> 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 have the account "Income:Music Equipment Sales CHF" and
> "Income:Music Equipment Sales EUR".
> 
> I'm not understanding the use of the "Expenses:Cost of goods sold"
> account - can you explain?
> 
> Thanks,
> Flavio.
> 
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
> 
> 
> Am Fr., 20. Sept. 2024 um 00:58 Uhr schrieb David Cousens
> :
> > Flavio,
> > 
> > > I would do the following when selling something for 120 which I
> > bought for 100:
> > > 1. increase the checking account by 120;
> > > 2. increase the "Income:Sales" account by 120;
> > > 3. increase the "Inventory:Music Equipment Sales" account by 120;
> > > 4. decrease the "Expenses:Cost of Goods Sold" account by 100.
> > 
> > These steps are not correct . Your inventory account records the
> > value (at cost) of the items you are holding so the entry on sale o
> > an item should equal the cost at purchaser  so you your transaction
> > to record it should be:
> > 
> > 1 . increase (debit) the checking account by 120
> > 2. increase (credit) the Income:Sales account by 120
> > 3. decrease (credit) the Inventory:Music Equipment Sales account
> >  by 100
> > 4. increase (debit) the Expenses: Cost of Goods Sold account by 100
> > 
> > 
> > The Inventory:Music Equipment Sales account is what is known in
> > accounting terms as a contra account to the Music Equipment
> > Purchases  which is why it is credited to decrease the balance of
> > Inventory (rather than debit as is usual to increase the balance of
> > an asset account).  I have added the usual accounting column
> > headings in brackets. Of the two columns with entries in themthe
> > Debit column is always the first and the Credit column is always
> > the second followed by the Balance colum last.
> > 
> > Note that in any transaction  the sums of all the debit and all the
> > credit entries have to be equal, which was not the case for your
> > proposed entries.
> > 
> > Cheers
> > David
> > 
> > 
> > On Thu, 

Re: [GNC] Reconciliation question

[David Cousens]

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 agreement for the period of the statement so the end date of the
period covered by the statement is the date reconciled to ..
David Cousens

On Mon, 2024-09-23 at 18:18 +0200, 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 date should I enter? The billing date or the
> date of
> the effective payment from my checking account?
> 
> Thanks,
> F.
> 
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.