Re: [GNC] End of Year?

[R Losey]

Absolutely; there is no reason to do anything special at the end of the
year; for many years, I have just kept using GnuCash and have had no
issues, but some people like to make yearly archives, or do the "close the
books" thing.

On Sat, Jan 13, 2024 at 5:53 PM Stan Brown (using GC 4.14) <
stan...@fastmail.fm> wrote:

> With older versions of GC, it used to take a long time to open a file.
> With 4.14, and I presume with 5.x, it's almost instantaneous.
>
> So why is there any discussion of saving previous-year data? It seems
> reasonable to me to archive a file as of 12-31-20XX, because you can't
> have too many archives. But after archiving that snapshot, what's the
> problem with just continuing to use the original of the file that copied
> into the archive? That's what I've been doing since 2018, and it seems
> to work just fine.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
>
> On 2024-01-13 14:29, David Carlson wrote:
> > Dumb question.  The original topic was about unreconncciled transactions
> > from the pervious year.  If they are not copied over to the new file
> > wouldn't that mess up the next reconciliation?
> >
> >
> >
> >
> > On Sat, Jan 13, 2024, 3:07 PM Liz  wrote:
> >
> >> On Sat, 13 Jan 2024 11:19:26 -0600
> >> R Losey  wrote:
> >>
> >>> But the larger issue is that I believe this email list could benefit
> >>> from a FAQ that is posted monthly or every other month to this group.
> >>> The wiki has some neat ideas about tracking year to year equity
> >>> growth.
> >>
> >> You will need to convince me, because I would get to implement it.
> >>
> >> Liz
> >> (Moderator Hat)
> >> ___
> >> 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.
>


-- 
_
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] register auto-complete

[Adrien Monteleone]

That is interesting.

Is this only for Descriptions or for Memos & Notes too?

*there is no preference. Bugs and kinks are being worked out though. 
This sounds like a bug, as I doubt that would be intended behavior. (it 
certainly isn't reasonable to expect, that I can see)


Regards,
Adrien

On 1/13/24 5:06 AM, chuck elliot wrote:
The behaviour of register auto-complete, where current transaction input 
is matched


against previous transactions within an account, seems to have changed 
recently (v.5.5).


It now seems to search only the active categories (unreconciled, cleared 
etc). I normally


hide 'reconciled' and so this is a nuisance as I have to fill in details 
that I know have


been input before. I could not find a preferences option for this. Is is 
configurable?


If not, could it be made so or go back to the old way please?

I did not find any reference to this in list archives but apologies if 
it has been raised before.


___
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] register auto-complete

[chuck elliot]

The behaviour of register auto-complete, where current transaction input 
is matched


against previous transactions within an account, seems to have changed 
recently (v.5.5).


It now seems to search only the active categories (unreconciled, cleared 
etc). I normally


hide 'reconciled' and so this is a nuisance as I have to fill in details 
that I know have


been input before. I could not find a preferences option for this. Is is 
configurable?


If not, could it be made so or go back to the old way please?

I did not find any reference to this in list archives but apologies if 
it has been raised before.


Regards.


___
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] Maddening!!!!!!!!

[John Layman via gnucash-user]

I have not found that situation (entering a missing transaction during 
reconciliation) to be unusual, and GnuCash handles it quite gracefully.

-Original Message-
From: gnucash-user  On 
Behalf Of David Carlson
Sent: Friday, January 12, 2024 12:44 PM
To: Jack Slater 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Maddening

It sounds like you are entering new transactions while part way through 
performing a reconciliation process.

I suspect that could confuse the reconciliation.



On Fri, Jan 12, 2024, 11:22 AM Jack Slater  wrote:

> Windows 11
>
> Was on 5.4 when problems started. Updated to 5.5 and finally slugged 
> my through doing exactly what you suggested - saving page and then 
> transaction at a time.
>
> On Fri, Jan 12, 2024 at 5:08 AM Liz  wrote:
>
> > On Thu, 11 Jan 2024 11:11:13 -0600
> > Jack Slater  wrote:
> >
> > > 90 minutes of reconciling down the drain with a crash near the end 
> > > of the final account. Oddly, even though GnuC auto saves 
> > > periodically, it seems none of any add/delete/balance transactions 
> > > were saved in any account! Why would that be
> >
> > Please give your OS and your version of Gnucash. It will make it 
> > easier for others to help.
> >
> > Personally I always save repetitively when reconciling. If its an 
> > account with a lot of transactions I may do a page at a time, and 
> > sometimes less. Every finalised reconciliation I save immediately.
> >
> > 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.
> >
> ___
> 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.

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

[John Layman via gnucash-user]

I have scheduled transactions with simple calculation.  They work just fine, 
but only when the transactions actually fire.

-Original Message-
From: gnucash-user  On 
Behalf Of David T. via gnucash-user
Sent: Thursday, January 11, 2024 3:56 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

Hello, 

Long time user working in Windows 10 with Gnucash 4.13. 

I have a number of scheduled transactions that I use; one of them has multiple 
splits. With the new year, I needed to update this scheduled transaction. I 
began modifying the amounts on different lines of the transaction, and when I 
got to entering the contra account against which all the other splits would 
balance, I was surprised to find that the automatic calculation feature of 
Gnucash registers was not active. I understand that there might be use cases in 
scheduled transactions where one might not want an automatic calculation, but 
is there a way to invoke it without manually adding up all the amounts in my 
head? 

⁣David T.​
___
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] List of fields checked by importer when matching transactions

[Etienne Boeziek via gnucash-user]

Perhaps related to your question.
I did notice as I was closing last quarter that in the GNU Cash latest version 
something seems to have changed with the importer matching.
I create my own CSV files in Python based on the export from suppliers/payments.
I had to change the Transfer memo field I believe, to match either the Memo 
field or the description field. Else transactions no longer matched. Before, I 
could have different texts there.

Etienne
On 11 Jan 2024 at 18:01 +0100, John Haiducek , wrote:
> Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
> those it says "Match missing!", even for cases where every imported field
> is identical to an existing transaction.
>
> On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam  wrote:
>
> > I've been having the same issue with qfx/ofx files, but I find when I
> > click on the clear check box it finds the matching transaction. You might
> > want to try that.
> >
> >
> >
> > Sent from Samsung Galaxy smartphone.
> >
> >
> >
> >  Original message 
> > From: John Haiducek 
> > Date: 1/11/24 10:43 AM (GMT-05:00)
> > To: GNU Cash User 
> > Subject: [GNC] List of fields checked by importer when matching
> > transactions
> >
> > Hi,
> >
> > Is there a list somewhere of what fields are checked by the importer when
> > matching transactions? I'm trying to import a CSV file that contains
> > already-existing transactions and the importer is failing to detect them
> > (there are hundreds so I don't want to manually de-select them all).
> >
> > John
> > ___
> > 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.

Re: [GNC] End of Year?

[Adrien Monteleone]

Sorry, I would not like to see an FAQ pop up in this list on any 
periodic basis.


What you are describing there is akin to a 'sticky' or 'pinned' post in 
a web forum.


This is not a web forum.

We have the Wiki, which has the FAQ section. We also have the Help 
Manual, and the Tutorial & Concepts Guide. Those are better places for 
standard, regular advice on how to use the software. This list serves a 
different purpose — to offer assistance that those sources don't (maybe 
yet) cover.


Some redesign of the website pointing to the FAQ might be in order, but 
that would take some careful analysis, and of course, someone to code 
the changes.


Regards,
Adrien

On 1/13/24 11:19 AM, R Losey wrote:

But the larger issue is that I believe this email list could benefit from a
FAQ that is posted monthly or every other month to this group. The wiki has
some neat ideas about tracking year to year equity growth.


___
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] End of Year?

[Adrien Monteleone]

That would be the case at first glance, but see my reply up the chain 
concerning correcting entries and usual procedures when starting with 
fresh books each year.


I'd hazard that with Pen & Paper, Reconciliation is *not* necessarily a 
function of the T-Accounts or General Journal. That is something done 
independently that happens to now be rolled into GnuCash along with 
everything else. Thus, it likely wouldn't even be a consideration.


Folks trying to imitate Pen & Paper using a computer are always going to 
have to adjust their workflow or make concessions for the difference in 
formats. This is true no matter the task at hand, or the software used, 
and is true of things not even accounting related at all.


I'm glad GnuCash gives the choice. Some software forces you to do what 
*it* wants.


Regards,
Adrien

On 1/13/24 4:29 PM, David Carlson wrote:

Dumb question.  The original topic was about unreconncciled transactions
from the pervious year.  If they are not copied over to the new file
wouldn't that mess up the next reconciliation?


___
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] Budget car payment

[Adrien Monteleone]

You can indeed save as CSV after opening in LibreOffice or Excel. Once 
it is opened, the spreadsheet app now controls what you do with it.


Regards,
Adrien

On 1/13/24 5:27 PM, David Carlson wrote:

I just tried opening a GnuCash report saved in Html format with Libre
Office writer and found that it would offer to save in ODT format as soon
as I tried to save anything.  I am sure that it would also save in csv or
other common formats.


___
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] End of Year?

[Stan Brown (using GC 4.14)]

With older versions of GC, it used to take a long time to open a file.
With 4.14, and I presume with 5.x, it's almost instantaneous.

So why is there any discussion of saving previous-year data? It seems
reasonable to me to archive a file as of 12-31-20XX, because you can't
have too many archives. But after archiving that snapshot, what's the
problem with just continuing to use the original of the file that copied
into the archive? That's what I've been doing since 2018, and it seems
to work just fine.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2024-01-13 14:29, David Carlson wrote:
> Dumb question.  The original topic was about unreconncciled transactions
> from the pervious year.  If they are not copied over to the new file
> wouldn't that mess up the next reconciliation?
> 
> 
> 
> 
> On Sat, Jan 13, 2024, 3:07 PM Liz  wrote:
> 
>> On Sat, 13 Jan 2024 11:19:26 -0600
>> R Losey  wrote:
>>
>>> But the larger issue is that I believe this email list could benefit
>>> from a FAQ that is posted monthly or every other month to this group.
>>> The wiki has some neat ideas about tracking year to year equity
>>> growth.
>>
>> You will need to convince me, because I would get to implement it.
>>
>> Liz
>> (Moderator Hat)
>> ___
>> 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.

Re: [GNC] Budget car payment

[David Carlson]

I just tried opening a GnuCash report saved in Html format with Libre
Office writer and found that it would offer to save in ODT format as soon
as I tried to save anything.  I am sure that it would also save in csv or
other common formats.



On Sat, Jan 13, 2024 at 3:14 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 1/13/2024 1:34 PM, Dennis Powless wrote:
> > Are there other options to export besides HTML?  Say to excel in csv or
> txt?
> >
> If you open an HTML document, do you know how to get the content saved
> as .xlsx or .cvs or .txt?  The point here is that asking the developers
> to add the option of adding export to format X just kicks the can down
> the road to "how about format Y:.
>
>
> Michael D Novack
>
>
> ___
> 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] End of Year?

[David Carlson]

Dumb question.  The original topic was about unreconncciled transactions
from the pervious year.  If they are not copied over to the new file
wouldn't that mess up the next reconciliation?




On Sat, Jan 13, 2024, 3:07 PM Liz  wrote:

> On Sat, 13 Jan 2024 11:19:26 -0600
> R Losey  wrote:
>
> > But the larger issue is that I believe this email list could benefit
> > from a FAQ that is posted monthly or every other month to this group.
> > The wiki has some neat ideas about tracking year to year equity
> > growth.
>
> You will need to convince me, because I would get to implement it.
>
> Liz
> (Moderator Hat)
> ___
> 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] Budget car payment

[Michael or Penny Novack]

On 1/13/2024 1:34 PM, Dennis Powless wrote:

Are there other options to export besides HTML?  Say to excel in csv or txt?

If you open an HTML document, do you know how to get the content saved 
as .xlsx or .cvs or .txt?  The point here is that asking the developers 
to add the option of adding export to format X just kicks the can down 
the road to "how about format Y:.



Michael D Novack


___
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] End of Year?

[Liz]

On Sat, 13 Jan 2024 11:19:26 -0600
R Losey  wrote:

> But the larger issue is that I believe this email list could benefit
> from a FAQ that is posted monthly or every other month to this group.
> The wiki has some neat ideas about tracking year to year equity
> growth.

You will need to convince me, because I would get to implement it.

Liz
(Moderator Hat)
___
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] Budget car payment

[Stan Brown (using GC 4.14)]

On 2024-01-13 10:34, Dennis Powless wrote:
> Are there other options to export besides HTML?  Say to excel in csv or txt?

Directly, no. But you can open the exported HTML file in Excel and then
File » Save As a variety of formats including CSV and text. I've never
done this myself, but it has been posted many times on this mailing list.

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] End of Year?

[David Cousens]

A section in the Tutorial and Concepts Guide may be even more appropriate and
then link the FAQ to it.

That then provides the option when the question comes up repeatedly in the list
of just providing the link to it.

David Cousens

On Sat, 2024-01-13 at 11:19 -0600, R Losey wrote:
> Pretty much, yes, although I found it a bit weak on the note that it is not
> really necessary.
> 
> But the larger issue is that I believe this email list could benefit from a
> FAQ that is posted monthly or every other month to this group. The wiki has
> some neat ideas about tracking year to year equity growth.
> 
> I gather that the main reason for "closing" books is that on the "Accounts"
> tab, one can see the year-to-date expenses and income instead of the total
> since one started using GnuCash. It's a neat idea.
> 
> On Sat, Jan 13, 2024 at 10:59 AM sunfish62--- via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
> > https://wiki.gnucash.org/wiki/Closing_Books
> > 
> > Does that cover it?
> > 
> > ⁣David T.
> > 
> > On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> > > You could add A2b:
> > > 
> > > Export your Chart of Accounts and write down the ending balances as
> > > needed. Start a new file, import your exported chart of accounts and
> > > set
> > > opening balances to the old ending balances.
> > > 
> > > This method is more like Pen & Paper days in that each file only
> > > contains one period (year in this case) of data.
> > > 
> > > -
> > > As for A2(a), there's not really a solid way to 'mark' a file as
> > > read-only if you have access to the file. (anyone determined enough can
> > > 
> > > edit it) Some folks write it to a CD-ROM, but that's about as good as
> > > you could expect.
> > > 
> > > In addition, some folks also archive PDF copies of their year-end
> > > reports with the file. While the file could always be changed after the
> > > 
> > > fact, the reports reflect the state of the accounts as of when they
> > > were
> > > generated. (which of course are no more immutable than the file, but at
> > > 
> > > least offer a reference point)
> > > 
> > > Regards,
> > > Adrien
> > > 
> > > On 1/13/24 12:16 AM, R Losey wrote:
> > > > I suspect that this topic comes up about every New Year - perhaps it
> > > is
> > > > worth putting in a FAQ (if it's not in one), and perhaps posting the
> > > FAQ
> > > > monthly to this list. In the relatively short time I've been on this
> > > list,
> > > > I definitely see some repeated questions, including this end-of-year
> > > > question that I created, and therefore may have errors in it.
> > > > 
> > > > ---
> > > > Question: "How do I start a new year in GnuCash?" Alternatively, "How
> > > do I
> > > > close out the old year in GnuCash?"
> > > > 
> > > > Answers as far as I can remember them:
> > > > General Answer: You need to determine precisely what you are trying
> > > to
> > > > accomplish in GnuCash. You may not need to do anything (see A1). If
> > > you
> > > > want to keep a backup-copy of the previous year, see A2. If you want
> > > to
> > > > close the books in the accounting sense (reset the balances of the
> > > income
> > > > and expense accounts), see A3.
> > > > 
> > > > A1: There is no necessity to take any action at the start of a New
> > > Year.
> > > > GnuCash can keep several years of data in its compressed XML file
> > > without
> > > > it growing too large.
> > > > 
> > > > A2: The best thing to do here is to be sure that there is no
> > > additional
> > > > transactions for end-of-year, run whatever end-of-year reports you
> > > need,
> > > > then shut down GnuCash and copy your main data file to some safe
> > > place. If
> > > > that area supports it, consider marking the file as read-only. You
> > > should
> > > > probably note the year in the name: "SmithFamilyFY2022.gnucash" or
> > > > something like that. There is no need to delete old data (see A1).
> > > > 
> > > > A3: See the GnuCash Manual, section 8.9 for a discussion about how to
> > > do
> > > > this task, along with the caveats.
> > > > 
> > > 
> > > ___
> > > 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 

Re: [GNC] Budget car payment

[Dennis Powless]

I realize that Gnucash is not a budgeting tool and I don't expect it to
provide the functionality that one can get from excel or open office.  So,
I think I will just export the data to excel and do the budget/dashboard
from there. I can get what I need from the reports quite easily in gnucash.

D

On Sat, Jan 13, 2024 at 1:34 PM Dennis Powless 
wrote:

> Are there other options to export besides HTML?  Say to excel in csv or
> txt?
>
> D
>
> On Wed, Jan 10, 2024 at 2:50 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Signs in Budgets need more testing. (I had plans to do so long ago,
>> perhaps I might get to it now as I'm way behind in my own budgeting!)
>>
>> You might have to play around a bit to see if it is possible to come up
>> with a sane entry method that produces a sane bottom line result. Or you
>> may have discovered a bug that needs fixing.
>>
>> I'll endeavor to work on my budget this week and see if I can duplicate
>> your issue.
>>
>>
>> 
>> And no, I don't think the Budget Module docs have been updated in many
>> moons and suns.
>>
>> Regards,
>> Adrien
>>
>> On 1/10/24 12:12 PM, Dennis Powless wrote:
>> > I'm trying to create a budget and am having some issues with setting it
>> up.
>> > I have a liability for car loan and expense for interest for that loan.
>> >
>> > I pay out of the checking account, say 500.
>> > I split to the Liability loan 200 and expense interest 300.
>> >
>> > In a spreadsheet I would budget out 500 for the car payment.  However,
>> > Gnucash is not set up this way (or I have it wrong).
>> >
>> > The liability payment is a negative entry in the budget and the expense
>> is
>> > a positive value.
>> > The same in the "budget report" created.
>> >
>> > The help docs are not very helpful, nor are internet searches.  Most in
>> the
>> > end, state to use a separate spreadsheet for budgeting.
>> > Which I have been doing for many years, but figured I'd give it another
>> try
>> > as it's been about 9 years.
>>
>> ___
>> 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] Budget car payment

[Dennis Powless]

Are there other options to export besides HTML?  Say to excel in csv or txt?

D

On Wed, Jan 10, 2024 at 2:50 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Signs in Budgets need more testing. (I had plans to do so long ago,
> perhaps I might get to it now as I'm way behind in my own budgeting!)
>
> You might have to play around a bit to see if it is possible to come up
> with a sane entry method that produces a sane bottom line result. Or you
> may have discovered a bug that needs fixing.
>
> I'll endeavor to work on my budget this week and see if I can duplicate
> your issue.
>
>
> 
> And no, I don't think the Budget Module docs have been updated in many
> moons and suns.
>
> Regards,
> Adrien
>
> On 1/10/24 12:12 PM, Dennis Powless wrote:
> > I'm trying to create a budget and am having some issues with setting it
> up.
> > I have a liability for car loan and expense for interest for that loan.
> >
> > I pay out of the checking account, say 500.
> > I split to the Liability loan 200 and expense interest 300.
> >
> > In a spreadsheet I would budget out 500 for the car payment.  However,
> > Gnucash is not set up this way (or I have it wrong).
> >
> > The liability payment is a negative entry in the budget and the expense
> is
> > a positive value.
> > The same in the "budget report" created.
> >
> > The help docs are not very helpful, nor are internet searches.  Most in
> the
> > end, state to use a separate spreadsheet for budgeting.
> > Which I have been doing for many years, but figured I'd give it another
> try
> > as it's been about 9 years.
>
> ___
> 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] End of Year?

[Fred Tydeman]

On Sat, Jan 13, 2024 at 9:20 AM R Losey  wrote:

> I gather that the main reason for "closing" books is that on the "Accounts"
> tab, one can see the year-to-date expenses and income instead of the total
> since one started using GnuCash. It's a neat idea.
>

Another option is to use the "Total(Period)" column.
Click the down arrow in the upper right on the Accounts page.
___
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] QIF import ignore account

[Fred Tydeman]

GnuCash 4.14 on Linux

As part of a QIF import, I have the following transaction:
^
D1/12'24
NDiv
Yblue owl cap
CX
T122.50
Mblue owl cap
LIncome:us:NoTax:Roth-F-Fid:div:blue owl cap
^

However, when I do the Import in GnuCash, it shows up as:
Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl cap

I do not understand why the QIF importer is ignoring the L... line
Now, the account on the L... line does not yet exist (so that might be the
reason).

In case it matters, the first few lines in the QIF are:
!Account
NAssets:us:Investments:TaxFree:f:Roth-F-Fid
TInvst
^
!Type:Invst
___
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] End of Year?

[R Losey]

Pretty much, yes, although I found it a bit weak on the note that it is not
really necessary.

But the larger issue is that I believe this email list could benefit from a
FAQ that is posted monthly or every other month to this group. The wiki has
some neat ideas about tracking year to year equity growth.

I gather that the main reason for "closing" books is that on the "Accounts"
tab, one can see the year-to-date expenses and income instead of the total
since one started using GnuCash. It's a neat idea.

On Sat, Jan 13, 2024 at 10:59 AM sunfish62--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

> https://wiki.gnucash.org/wiki/Closing_Books
>
> Does that cover it?
>
> ⁣David T.
>
> On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >You could add A2b:
> >
> >Export your Chart of Accounts and write down the ending balances as
> >needed. Start a new file, import your exported chart of accounts and
> >set
> >opening balances to the old ending balances.
> >
> >This method is more like Pen & Paper days in that each file only
> >contains one period (year in this case) of data.
> >
> >-
> >As for A2(a), there's not really a solid way to 'mark' a file as
> >read-only if you have access to the file. (anyone determined enough can
> >
> >edit it) Some folks write it to a CD-ROM, but that's about as good as
> >you could expect.
> >
> >In addition, some folks also archive PDF copies of their year-end
> >reports with the file. While the file could always be changed after the
> >
> >fact, the reports reflect the state of the accounts as of when they
> >were
> >generated. (which of course are no more immutable than the file, but at
> >
> >least offer a reference point)
> >
> >Regards,
> >Adrien
> >
> >On 1/13/24 12:16 AM, R Losey wrote:
> >> I suspect that this topic comes up about every New Year - perhaps it
> >is
> >> worth putting in a FAQ (if it's not in one), and perhaps posting the
> >FAQ
> >> monthly to this list. In the relatively short time I've been on this
> >list,
> >> I definitely see some repeated questions, including this end-of-year
> >> question that I created, and therefore may have errors in it.
> >>
> >> ---
> >> Question: "How do I start a new year in GnuCash?" Alternatively, "How
> >do I
> >> close out the old year in GnuCash?"
> >>
> >> Answers as far as I can remember them:
> >> General Answer: You need to determine precisely what you are trying
> >to
> >> accomplish in GnuCash. You may not need to do anything (see A1). If
> >you
> >> want to keep a backup-copy of the previous year, see A2. If you want
> >to
> >> close the books in the accounting sense (reset the balances of the
> >income
> >> and expense accounts), see A3.
> >>
> >> A1: There is no necessity to take any action at the start of a New
> >Year.
> >> GnuCash can keep several years of data in its compressed XML file
> >without
> >> it growing too large.
> >>
> >> A2: The best thing to do here is to be sure that there is no
> >additional
> >> transactions for end-of-year, run whatever end-of-year reports you
> >need,
> >> then shut down GnuCash and copy your main data file to some safe
> >place. If
> >> that area supports it, consider marking the file as read-only. You
> >should
> >> probably note the year in the name: "SmithFamilyFY2022.gnucash" or
> >> something like that. There is no need to delete old data (see A1).
> >>
> >> A3: See the GnuCash Manual, section 8.9 for a discussion about how to
> >do
> >> this task, along with the caveats.
> >>
> >
> >___
> >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] End of Year?

[sunfish62--- via gnucash-user]

https://wiki.gnucash.org/wiki/Closing_Books

Does that cover it?

⁣David T.​

On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone 
 wrote:
>You could add A2b:
>
>Export your Chart of Accounts and write down the ending balances as 
>needed. Start a new file, import your exported chart of accounts and
>set 
>opening balances to the old ending balances.
>
>This method is more like Pen & Paper days in that each file only 
>contains one period (year in this case) of data.
>
>-
>As for A2(a), there's not really a solid way to 'mark' a file as 
>read-only if you have access to the file. (anyone determined enough can
>
>edit it) Some folks write it to a CD-ROM, but that's about as good as 
>you could expect.
>
>In addition, some folks also archive PDF copies of their year-end 
>reports with the file. While the file could always be changed after the
>
>fact, the reports reflect the state of the accounts as of when they
>were 
>generated. (which of course are no more immutable than the file, but at
>
>least offer a reference point)
>
>Regards,
>Adrien
>
>On 1/13/24 12:16 AM, R Losey wrote:
>> I suspect that this topic comes up about every New Year - perhaps it
>is
>> worth putting in a FAQ (if it's not in one), and perhaps posting the
>FAQ
>> monthly to this list. In the relatively short time I've been on this
>list,
>> I definitely see some repeated questions, including this end-of-year
>> question that I created, and therefore may have errors in it.
>> 
>> ---
>> Question: "How do I start a new year in GnuCash?" Alternatively, "How
>do I
>> close out the old year in GnuCash?"
>> 
>> Answers as far as I can remember them:
>> General Answer: You need to determine precisely what you are trying
>to
>> accomplish in GnuCash. You may not need to do anything (see A1). If
>you
>> want to keep a backup-copy of the previous year, see A2. If you want
>to
>> close the books in the accounting sense (reset the balances of the
>income
>> and expense accounts), see A3.
>> 
>> A1: There is no necessity to take any action at the start of a New
>Year.
>> GnuCash can keep several years of data in its compressed XML file
>without
>> it growing too large.
>> 
>> A2: The best thing to do here is to be sure that there is no
>additional
>> transactions for end-of-year, run whatever end-of-year reports you
>need,
>> then shut down GnuCash and copy your main data file to some safe
>place. If
>> that area supports it, consider marking the file as read-only. You
>should
>> probably note the year in the name: "SmithFamilyFY2022.gnucash" or
>> something like that. There is no need to delete old data (see A1).
>> 
>> A3: See the GnuCash Manual, section 8.9 for a discussion about how to
>do
>> this task, along with the caveats.
>> 
>
>___
>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] End of Year?

[Phyllis Bruce]

Just to clarify further, I'm referring to Adrien's A2b option above of just
entering ending balances for a new year.

On Sat, Jan 13, 2024 at 10:52 AM Phyllis Bruce  wrote:

> Thanks for the explanation.   I guess it's a matter of personal
> preference.  If I'm starting a new file I want to be able to reconcile to
> my statement when it's received in 2024.  It does not bother me to have
> uncleared items in the archived file.  I could even go so far as to delete
> them from the 2023 archive but that would be overkill imho.
>
> On Sat, Jan 13, 2024 at 10:37 AM Gyle McCollam  wrote:
>
>> Phyllis,
>> If you enter unreconciled transactions again in 2024 you will have
>> doubled counted them because they will be in 2023 and 2024.  They are
>> already accounted for in the balance.  Since reconciliation is just
>> matching what has cleared with the statement it is OK that the transactions
>> are not in 2024 as long as you know that they were in 2023 and any that
>> have not clear in 2024 are the difference between your statement and
>> account balance per the statement.
>>
>> Thank You,
>>
>> *Gyle McCollam*
>>
>> Gyle McCollam
>>
>> gmccol...@live.comemail
>> --
>> *From:* gnucash-user 
>> on behalf of Phyllis Bruce 
>> *Sent:* Saturday, January 13, 2024 10:56 AM
>> *To:* adrien.montele...@lusfiber.net 
>> *Cc:* gnucash-u...@lists.gnucash.org 
>> *Subject:* Re: [GNC] End of Year?
>>
>> I did mean checking/savings and credit card accounts.  Thanks
>>
>> Since I use Gnucash for personal rather than business use, I don't
>> "close" the books.  However, if I wanted to archive 2023 and start fresh
>> on
>> Jan 1, 2024, I would enter any unreconciled transactions in those accounts
>> in your A2b example because the beginning balances would include them.
>>
>> On Sat, Jan 13, 2024 at 8:19 AM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>> > *ALL accounts are 'credit and debit' accounts. But perhaps you mean
>> > Checking & Credit Card accounts? (i.e., those held at a 3rd party
>> > financial institution, since you are referencing 'reconciliation'.)
>> >
>> > Reconciliation is usually done prior to a Trial Balance as part of the
>> > End of Year process and that not infrequently is done up to a month
>> > (sometimes more) after the calendar date of the end of the period. It is
>> > not uncommon to see P and Balance Sheet reports published in February
>> > for periods ending December 31.
>> >
>> > Otherwise, correcting entries are employed. This is usually the case
>> > with Accruals that cross period boundaries. You reverse the portion of
>> > an amount that doesn't apply to the period being closed, and add it back
>> > in the following period. (this also occurs for interim periods such as
>> > months or quarters)
>> >
>> > Exactly what you do, depends on the requirements of your local
>> > jurisdiction.
>> >
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 1/13/24 8:03 AM, Phyllis Bruce wrote:
>> > > H, would you not also need to re-enter any unreconciled
>> transactions
>> > in
>> > > your credit and debit accounts?
>> >
>> > ___
>> > 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.

Re: [GNC] End of Year?

[Phyllis Bruce]

Thanks for the explanation.   I guess it's a matter of personal
preference.  If I'm starting a new file I want to be able to reconcile to
my statement when it's received in 2024.  It does not bother me to have
uncleared items in the archived file.  I could even go so far as to delete
them from the 2023 archive but that would be overkill imho.

On Sat, Jan 13, 2024 at 10:37 AM Gyle McCollam  wrote:

> Phyllis,
> If you enter unreconciled transactions again in 2024 you will have doubled
> counted them because they will be in 2023 and 2024.  They are already
> accounted for in the balance.  Since reconciliation is just matching what
> has cleared with the statement it is OK that the transactions are not in
> 2024 as long as you know that they were in 2023 and any that have not clear
> in 2024 are the difference between your statement and account balance per
> the statement.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of Phyllis Bruce 
> *Sent:* Saturday, January 13, 2024 10:56 AM
> *To:* adrien.montele...@lusfiber.net 
> *Cc:* gnucash-u...@lists.gnucash.org 
> *Subject:* Re: [GNC] End of Year?
>
> I did mean checking/savings and credit card accounts.  Thanks
>
> Since I use Gnucash for personal rather than business use, I don't
> "close" the books.  However, if I wanted to archive 2023 and start fresh on
> Jan 1, 2024, I would enter any unreconciled transactions in those accounts
> in your A2b example because the beginning balances would include them.
>
> On Sat, Jan 13, 2024 at 8:19 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > *ALL accounts are 'credit and debit' accounts. But perhaps you mean
> > Checking & Credit Card accounts? (i.e., those held at a 3rd party
> > financial institution, since you are referencing 'reconciliation'.)
> >
> > Reconciliation is usually done prior to a Trial Balance as part of the
> > End of Year process and that not infrequently is done up to a month
> > (sometimes more) after the calendar date of the end of the period. It is
> > not uncommon to see P and Balance Sheet reports published in February
> > for periods ending December 31.
> >
> > Otherwise, correcting entries are employed. This is usually the case
> > with Accruals that cross period boundaries. You reverse the portion of
> > an amount that doesn't apply to the period being closed, and add it back
> > in the following period. (this also occurs for interim periods such as
> > months or quarters)
> >
> > Exactly what you do, depends on the requirements of your local
> > jurisdiction.
> >
> >
> > Regards,
> > Adrien
> >
> > On 1/13/24 8:03 AM, Phyllis Bruce wrote:
> > > H, would you not also need to re-enter any unreconciled
> transactions
> > in
> > > your credit and debit accounts?
> >
> > ___
> > 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.

Re: [GNC] End of Year?

[Gyle McCollam]

Phyllis,
If you enter unreconciled transactions again in 2024 you will have doubled 
counted them because they will be in 2023 and 2024.  They are already accounted 
for in the balance.  Since reconciliation is just matching what has cleared 
with the statement it is OK that the transactions are not in 2024 as long as 
you know that they were in 2023 and any that have not clear in 2024 are the 
difference between your statement and account balance per the statement.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Phyllis Bruce 
Sent: Saturday, January 13, 2024 10:56 AM
To: adrien.montele...@lusfiber.net 
Cc: gnucash-u...@lists.gnucash.org 
Subject: Re: [GNC] End of Year?

I did mean checking/savings and credit card accounts.  Thanks

Since I use Gnucash for personal rather than business use, I don't
"close" the books.  However, if I wanted to archive 2023 and start fresh on
Jan 1, 2024, I would enter any unreconciled transactions in those accounts
in your A2b example because the beginning balances would include them.

On Sat, Jan 13, 2024 at 8:19 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> *ALL accounts are 'credit and debit' accounts. But perhaps you mean
> Checking & Credit Card accounts? (i.e., those held at a 3rd party
> financial institution, since you are referencing 'reconciliation'.)
>
> Reconciliation is usually done prior to a Trial Balance as part of the
> End of Year process and that not infrequently is done up to a month
> (sometimes more) after the calendar date of the end of the period. It is
> not uncommon to see P and Balance Sheet reports published in February
> for periods ending December 31.
>
> Otherwise, correcting entries are employed. This is usually the case
> with Accruals that cross period boundaries. You reverse the portion of
> an amount that doesn't apply to the period being closed, and add it back
> in the following period. (this also occurs for interim periods such as
> months or quarters)
>
> Exactly what you do, depends on the requirements of your local
> jurisdiction.
>
>
> Regards,
> Adrien
>
> On 1/13/24 8:03 AM, Phyllis Bruce wrote:
> > H, would you not also need to re-enter any unreconciled transactions
> in
> > your credit and debit accounts?
>
> ___
> 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.

Re: [GNC] End of Year?

[Phyllis Bruce]

I did mean checking/savings and credit card accounts.  Thanks

Since I use Gnucash for personal rather than business use, I don't
"close" the books.  However, if I wanted to archive 2023 and start fresh on
Jan 1, 2024, I would enter any unreconciled transactions in those accounts
in your A2b example because the beginning balances would include them.

On Sat, Jan 13, 2024 at 8:19 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> *ALL accounts are 'credit and debit' accounts. But perhaps you mean
> Checking & Credit Card accounts? (i.e., those held at a 3rd party
> financial institution, since you are referencing 'reconciliation'.)
>
> Reconciliation is usually done prior to a Trial Balance as part of the
> End of Year process and that not infrequently is done up to a month
> (sometimes more) after the calendar date of the end of the period. It is
> not uncommon to see P and Balance Sheet reports published in February
> for periods ending December 31.
>
> Otherwise, correcting entries are employed. This is usually the case
> with Accruals that cross period boundaries. You reverse the portion of
> an amount that doesn't apply to the period being closed, and add it back
> in the following period. (this also occurs for interim periods such as
> months or quarters)
>
> Exactly what you do, depends on the requirements of your local
> jurisdiction.
>
>
> Regards,
> Adrien
>
> On 1/13/24 8:03 AM, Phyllis Bruce wrote:
> > H, would you not also need to re-enter any unreconciled transactions
> in
> > your credit and debit accounts?
>
> ___
> 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] Template Transactions Behavior in Scheduled Transaction Editor

[Fred Bone]

On 12 January 2024 at 23:36, Adrien Monteleone said:

> That's moving beyond Scheduled Transactions and into a more general case
> of Templates. I'm pretty sure I've already filed an RFE for that long ago.
> 
> I see Scheduled Transactions as a special use case of Templates, though
> Scheduled was implemented first.
> 
> The more general Template case is when you definitely want to re-enter the
> format of a transaction (which may or may not be complicated) but you
> don't want to do so on a set periodic basis.

Which is of course simple enough to achieve. Just set your SX to "once", 
and when you want to run it change its date to "today".



___
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] End of Year?

[Adrien Monteleone]

*ALL accounts are 'credit and debit' accounts. But perhaps you mean 
Checking & Credit Card accounts? (i.e., those held at a 3rd party 
financial institution, since you are referencing 'reconciliation'.)


Reconciliation is usually done prior to a Trial Balance as part of the 
End of Year process and that not infrequently is done up to a month 
(sometimes more) after the calendar date of the end of the period. It is 
not uncommon to see P and Balance Sheet reports published in February 
for periods ending December 31.


Otherwise, correcting entries are employed. This is usually the case 
with Accruals that cross period boundaries. You reverse the portion of 
an amount that doesn't apply to the period being closed, and add it back 
in the following period. (this also occurs for interim periods such as 
months or quarters)


Exactly what you do, depends on the requirements of your local jurisdiction.


Regards,
Adrien

On 1/13/24 8:03 AM, Phyllis Bruce wrote:

H, would you not also need to re-enter any unreconciled transactions in
your credit and debit accounts?


___
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] End of Year?

[Phyllis Bruce]

H, would you not also need to re-enter any unreconciled transactions in
your credit and debit accounts?

On Sat, Jan 13, 2024 at 7:24 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> You could add A2b:
>
> Export your Chart of Accounts and write down the ending balances as
> needed. Start a new file, import your exported chart of accounts and set
> opening balances to the old ending balances.
>
> This method is more like Pen & Paper days in that each file only
> contains one period (year in this case) of data.
>
> -
> As for A2(a), there's not really a solid way to 'mark' a file as
> read-only if you have access to the file. (anyone determined enough can
> edit it) Some folks write it to a CD-ROM, but that's about as good as
> you could expect.
>
> In addition, some folks also archive PDF copies of their year-end
> reports with the file. While the file could always be changed after the
> fact, the reports reflect the state of the accounts as of when they were
> generated. (which of course are no more immutable than the file, but at
> least offer a reference point)
>
> Regards,
> Adrien
>
> On 1/13/24 12:16 AM, R Losey wrote:
> > I suspect that this topic comes up about every New Year - perhaps it is
> > worth putting in a FAQ (if it's not in one), and perhaps posting the FAQ
> > monthly to this list. In the relatively short time I've been on this
> list,
> > I definitely see some repeated questions, including this end-of-year
> > question that I created, and therefore may have errors in it.
> >
> > ---
> > Question: "How do I start a new year in GnuCash?" Alternatively, "How do
> I
> > close out the old year in GnuCash?"
> >
> > Answers as far as I can remember them:
> > General Answer: You need to determine precisely what you are trying to
> > accomplish in GnuCash. You may not need to do anything (see A1). If you
> > want to keep a backup-copy of the previous year, see A2. If you want to
> > close the books in the accounting sense (reset the balances of the income
> > and expense accounts), see A3.
> >
> > A1: There is no necessity to take any action at the start of a New Year.
> > GnuCash can keep several years of data in its compressed XML file without
> > it growing too large.
> >
> > A2: The best thing to do here is to be sure that there is no additional
> > transactions for end-of-year, run whatever end-of-year reports you need,
> > then shut down GnuCash and copy your main data file to some safe place.
> If
> > that area supports it, consider marking the file as read-only. You should
> > probably note the year in the name: "SmithFamilyFY2022.gnucash" or
> > something like that. There is no need to delete old data (see A1).
> >
> > A3: See the GnuCash Manual, section 8.9 for a discussion about how to do
> > this task, along with the caveats.
> >
>
> ___
> 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] End of Year?

[Adrien Monteleone]

You could add A2b:

Export your Chart of Accounts and write down the ending balances as 
needed. Start a new file, import your exported chart of accounts and set 
opening balances to the old ending balances.


This method is more like Pen & Paper days in that each file only 
contains one period (year in this case) of data.


-
As for A2(a), there's not really a solid way to 'mark' a file as 
read-only if you have access to the file. (anyone determined enough can 
edit it) Some folks write it to a CD-ROM, but that's about as good as 
you could expect.


In addition, some folks also archive PDF copies of their year-end 
reports with the file. While the file could always be changed after the 
fact, the reports reflect the state of the accounts as of when they were 
generated. (which of course are no more immutable than the file, but at 
least offer a reference point)


Regards,
Adrien

On 1/13/24 12:16 AM, R Losey wrote:

I suspect that this topic comes up about every New Year - perhaps it is
worth putting in a FAQ (if it's not in one), and perhaps posting the FAQ
monthly to this list. In the relatively short time I've been on this list,
I definitely see some repeated questions, including this end-of-year
question that I created, and therefore may have errors in it.

---
Question: "How do I start a new year in GnuCash?" Alternatively, "How do I
close out the old year in GnuCash?"

Answers as far as I can remember them:
General Answer: You need to determine precisely what you are trying to
accomplish in GnuCash. You may not need to do anything (see A1). If you
want to keep a backup-copy of the previous year, see A2. If you want to
close the books in the accounting sense (reset the balances of the income
and expense accounts), see A3.

A1: There is no necessity to take any action at the start of a New Year.
GnuCash can keep several years of data in its compressed XML file without
it growing too large.

A2: The best thing to do here is to be sure that there is no additional
transactions for end-of-year, run whatever end-of-year reports you need,
then shut down GnuCash and copy your main data file to some safe place. If
that area supports it, consider marking the file as read-only. You should
probably note the year in the name: "SmithFamilyFY2022.gnucash" or
something like that. There is no need to delete old data (see A1).

A3: See the GnuCash Manual, section 8.9 for a discussion about how to do
this task, along with the caveats.



___
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] Template Transactions Behavior in Scheduled Transaction Editor

[Adrien Monteleone]

Not general templates, no. It only has scheduled transactions.

There is a request for templates.

Regards,
Adrien

On 1/12/24 11:56 PM, R Losey wrote:

I'm sensing a learning opportunity here... GnuCash has templates? I never
noticed that; I only use the templates in the Scheduled Transaction Editor.


___
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] List of fields checked by importer when matching transactions

[GNUCash via gnucash-user]

John,
Yes the description had to match the tranfer memo. To clarify.
In my transaction CSV I had 3 rows belonging to 1 transaction.
Description on all 3 rows: “Order 1234”
Receivables and deposit rows where identical in all fields (memo, transfer 
memo, description).
But the third row contained the transaction fee.
So I had in the transfer memo: “Order 1234; payment cost”. Then the importer 
failed to match it to the first 2 rows.

Etienne
On 12 Jan 2024 at 12:43 +0100, GNUCash via gnucash-user 
, wrote:
> Perhaps related to your question.
> I did notice as I was closing last quarter that in the GNU Cash latest 
> version something seems to have changed with the importer matching.
> I create my own CSV files in Python based on the export from 
> suppliers/payments.
> I had to change the Transfer memo field I believe, to match either the Memo 
> field or the description field. Else transactions no longer matched. Before, 
> I could have different texts there.
>
> Etienne
> On 11 Jan 2024 at 18:01 +0100, John Haiducek , wrote:
> > Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
> > those it says "Match missing!", even for cases where every imported field
> > is identical to an existing transaction.
> >
> > On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam  wrote:
> >
> > > I've been having the same issue with qfx/ofx files, but I find when I
> > > click on the clear check box it finds the matching transaction. You might
> > > want to try that.
> > >
> > >
> > >
> > > Sent from Samsung Galaxy smartphone.
> > >
> > >
> > >
> > >  Original message 
> > > From: John Haiducek 
> > > Date: 1/11/24 10:43 AM (GMT-05:00)
> > > To: GNU Cash User 
> > > Subject: [GNC] List of fields checked by importer when matching
> > > transactions
> > >
> > > Hi,
> > >
> > > Is there a list somewhere of what fields are checked by the importer when
> > > matching transactions? I'm trying to import a CSV file that contains
> > > already-existing transactions and the importer is failing to detect them
> > > (there are hundreds so I don't want to manually de-select them all).
> > >
> > > John
> > > ___
> > > 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.
___
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.