[GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[flywire]

Chris, you are a second class user. GnuCash was written to use fiscal year
but a change made in 2001, exposed to users in 2006, dropped fiscal
year and introduced calendar year(s) and an accounting period. Years (this
and previous) is the first class service, automatic relative to current
date but accounting period is very much a second class service requiring
manual changes to start and end period *preferences*, particularly annoying
when working with multiple periods at the same time.

If the start and end of the year are redefined the reports still work on
the redefined year, as demonstrated by the code I wrote, supplied, and used
seamlessly without issues other than having to apply it to each new version
released and fixing a bug. With GnuCash V5 those definitions have been
*removed* from editable scheme code in reports and placed in compiled C++
code.

Clearly, the program works, it's only a matter of customising the start and
end date of a year for reports. I recently asked for guidance on how to
reinstate the configurable years in V5 but I don't have a reply yet.
___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Stan Brown]

On 2023-04-07 17:35, p...@kroitor.ca wrote:
> That being said, there are comments in various Gnucash places
> (Documentation, Wiki, Mailing List histories) to the effect that closing
> books is considered a slightly old-fashioned way of doing things, and
> although perhaps not discouraged, isn't strictly necessary. My own
> preference is to do annual closings on all five sets of books I track. It
> makes some reporting a little trickier to obtain, but on balance I like it
> better.

I close my books each year so that the balances in my income and expense
accounts will be totals for the current year only. If I had to redo
prior-year reports or some reason it would be slightly awkward; but
that's minor against the convenience (for me) of being able to see
year-to-date income in the Accounts page and in the registers of the
individual accounts. That's faster than pulling a report, at least for me.

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] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Michael or Penny Novack]

That's certainly possible, and I agree it's much better than undoing
things. But there's a very large caveat:

When you open GnuCash, it opens the file you were working on most
recently. So you need to be very sure that you have opened the file you
intended to, after you have finished whatever you wanted to do with the
pre-closing file.

My advice: when you're working on the pre-closing file, don't close
GnuCash. Instead, close that file, open your current file, and _then_
close GnuCash.


Ah .. probably because I maintain several sets of books under 
gnucash I am so used to always SELECTING what set of books I want 
gnucash to open that I forget many/most gnucash users do not realize 
that the behavior "open last set of books that was open" is optional. In 
other words, it is a default runtime parameter that can be overridden by 
passing a different parameter, a parameter telling gnucash NOT to begin 
by opening a file but just to open and wait for you to specify the file 
you want opened.


These days I am keeping few enough sets of books all that I usually work 
with fit on the "last open" selection list, but you can specify any by 
name (which is how you would get one no longer on that short list -- as 
would be the case were you opening the back-up* of a prior year, etc.


Michael D Novack

* A retired ex-pro, I'm rather fussy, and would treat that sort of 
backup "read only". If there were ANY chance of writing to it/altering 
it I would first make a copy and open that copy with gnucash. Normally 
MY copy of a back-up would be on re-writable storage and only the copy 
given into the custody of another organizational officer burned to DVD, 
etc.





___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[paul]

Hi,

I'm sure many here will consider the following to be a less "legit"
approach, but I just wanted to chime in to say that I use a very different
way of dealing with year-ends closings.

Firstly, you should know three things:

1. All the Close Book function really does is create two split transactions
on the specified closing date: one that zeroes out all the Income Accounts,
and another that zeroes the Cost (Expense) Accounts. This allows you to
start the next fiscal year with zero balances in income and expense
accounts. The other side of each transaction is booked to whatever Equity
account you specify when closing.

2. You can easily reverse the effect of the effect of closing by simply
deleting the two closing transactions, and you can redo the closing again at
any time too. In fact, if you must "fix" a closed prior year (see note
below), it's easier to delete the closing entries, make the fix, and rerun
the closing than it is to manually tweak the closing entries.

3. I have found some reports do allow stripping out the closing entries --
and avoiding a nonsensical report -- but others don't have this feature.
There's a post of mine here a few weeks ago about a five-year history report
that always shows zeros for the first four years, because the report
includes the closing entries for each year, which (by design) reverses the
effect of all other transactions in the year. One (messy) approach to
solving this involves making a temporary copy of the data file, deleting the
closing transactions for all prior years, running the historical reports,
and finally deleting the temporary copy (note that the approach described by
others here doesn't work when trying to get a five-year cost history).

That being said, there are comments in various Gnucash places
(Documentation, Wiki, Mailing List histories) to the effect that closing
books is considered a slightly old-fashioned way of doing things, and
although perhaps not discouraged, isn't strictly necessary. My own
preference is to do annual closings on all five sets of books I track. It
makes some reporting a little trickier to obtain, but on balance I like it
better.

The other point relates to what I said before about "fixing" a closed prior
year. When I was a systems designer for corporate accounting systems in the
80s, it was entirely anathema for anything to be modified, EVER. The only
way to fix an error, even one made seconds ago, was to add a reversing entry
and then re-add (the correct version of) the original. Later systems became
more and more liberal about this -- there are still always audit trails if
one really must dig into things in cases like fraud -- and now we have
reached a point where nothing is really locked in stone forever.

Everyone here will have their own policies / morals about what is allowed to
be modified later. In my case, I'm retired and the books I track aren't for
legal / tax reporting, so I can change prior years and rerun things when
appropriate. I'm sure many others here have much stricter requirements!

Paul

-Original Message-
From: gnucash-user  On
Behalf Of CJN ...
Sent: Friday, April 7, 2023 7:37 PM
To: Stan Brown ; GnuCash User List

Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5
April 2023), and start new Data set for the New Tax Year starting 6 April
2023

8 April 2023

WOW - Thanks to all of you who have sent me advice of setting up GNU-Cash
for a new Financial Year.

Read all your messages - all very helpful.
Looked at the Help-Contents on Closing (after Year End 5 April) Closed
Accounts. And started new set of data.
And entered data for the Transactions of the last few days from New Year
Start 6 April.

And as far as I can see from Trial Balance, and Income/Expenses Reports, all
data is as it should be!

It's been a long Good Friday for this accounting novice. But I think I got
there.
Just hope I remember it all for the next Year End :) - Or I might be back
for more Help!

Chris
London
cjn-internatio...@hotmail.com


-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org] On
Behalf Of Stan Brown
Sent: Saturday, April 8, 2023 12:09 AM
To: GnuCash User List 
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5
April 2023), and start new Data set for the New Tax Year starting 6 April
2023


On 2023-04-07 14:09, Michael or Penny Novack wrote:
> 
> The point is, if you ever want to look at the books in their state 
> prior to the 2023 close you don't undo anything. Instead you retrieve 
> the back-up and open a copy of that.

That's certainly possible, and I agree it's much better than undoing things.
But there's a very large caveat:

When you open GnuCash, it opens the file you were working on most recently.
So you need to be very sure that you have opened the file you intended to,
after you have finished whatever you wanted to do with the pre-closing file.

My advice: when you're 

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[CJN.... ...]

8 April 2023

WOW - Thanks to all of you who have sent me advice of setting up GNU-Cash for a 
new Financial Year.

Read all your messages - all very helpful.
Looked at the Help-Contents on Closing (after Year End 5 April)
Closed Accounts. And started new set of data.
And entered data for the Transactions of the last few days from New Year Start 
6 April.

And as far as I can see from Trial Balance, and Income/Expenses Reports, all 
data is as it should be!

It's been a long Good Friday for this accounting novice. But I think I got 
there.
Just hope I remember it all for the next Year End :) - Or I might be back for 
more Help!

Chris
London
cjn-internatio...@hotmail.com


-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org] On 
Behalf Of Stan Brown
Sent: Saturday, April 8, 2023 12:09 AM
To: GnuCash User List 
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023


On 2023-04-07 14:09, Michael or Penny Novack wrote:
> 
> The point is, if you ever want to look at the books in their state 
> prior to the 2023 close you don't undo anything. Instead you retrieve 
> the back-up and open a copy of that.

That's certainly possible, and I agree it's much better than undoing things. 
But there's a very large caveat:

When you open GnuCash, it opens the file you were working on most recently. So 
you need to be very sure that you have opened the file you intended to, after 
you have finished whatever you wanted to do with the pre-closing file.

My advice: when you're working on the pre-closing file, don't close GnuCash. 
Instead, close that file, open your current file, and _then_ close GnuCash.

If you're like me (and like several people every month who run into this and 
ask about it on the mailing list) you're used to having your current file open 
when you open GnuCash, and you may not notice if some other file opens.

That's why I recommend closing the pre-closing file and opening your current 
file before you close GC. Sure, if you have to work on your pre-closing file 
again, you'll have to open it again, which is an extra step. But at least 
you're never in the position of entering a bunch of transactions and _then_ 
discovering that you weren't in the file you meant to be in.

P.S. There's a workaround for this in Windows, and I believe in Linux as well. 
Put the name of your current file on the GnuCash command line (which is 
probably inside a shortcut if you're running Windows), and when GC starts it 
will open that file regardless of which file you were working on last. (In 
MacOS, the file on the command line is ignored.)

--
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.

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Stan Brown]

On 2023-04-07 14:09, Michael or Penny Novack wrote:
> 
> The point is, if you ever want to look at the books in their state prior
> to the 2023 close you don't undo anything. Instead you retrieve the
> back-up and open a copy of that.

That's certainly possible, and I agree it's much better than undoing
things. But there's a very large caveat:

When you open GnuCash, it opens the file you were working on most
recently. So you need to be very sure that you have opened the file you
intended to, after you have finished whatever you wanted to do with the
pre-closing file.

My advice: when you're working on the pre-closing file, don't close
GnuCash. Instead, close that file, open your current file, and _then_
close GnuCash.

If you're like me (and like several people every month who run into this
and ask about it on the mailing list) you're used to having your current
file open when you open GnuCash, and you may not notice if some other
file opens.

That's why I recommend closing the pre-closing file and opening your
current file before you close GC. Sure, if you have to work on your
pre-closing file again, you'll have to open it again, which is an extra
step. But at least you're never in the position of entering a bunch of
transactions and _then_ discovering that you weren't in the file you
meant to be in.

P.S. There's a workaround for this in Windows, and I believe in Linux as
well. Put the name of your current file on the GnuCash command line
(which is probably inside a shortcut if you're running Windows), and
when GC starts it will open that file regardless of which file you were
working on last. (In MacOS, the file on the command line is ignored.)

-- 
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.

[GNC] Assign as payment does nothing

[Tom Weichmann]

GNUCash 5.0
Ubuntu 22.04
Compiled from source

Right click on item in regester, click assign as payment, choose
customer from dialog -> choose open invoice from dialog (highlighting open
invoice).  Click OK.  The items transfer account should change to Accounts
receivable and mark the invoice as paid, but neither of these happen.

Wanted to check if anyone else has seen this behaviour or if I need to file
a bug report.

Thanks,

Tom
___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Michael or Penny Novack]

On 4/7/2023 10:58 AM, Gyle McCollam wrote:

1st , you should run your yearend reports before you "Close" and if you need to rerun at 
some future point, you could just delete the "closing" entries and rerun any reports then 
reclose after.  As for not closing, when you run reports for the next fiscal year you would use the 
start date of that year as the starting date for the new reports.  Either way, you can get what you 
need, the choice is yours.

IF you make and save backups (of the data on your computer) you should 
not have to "undo" closing to later go back.


You presumably should have (good idea) made a back-up of the file right 
after the YE reports and before the "close". You give that file a name 
that means you can always correctly identify it --- say 
BooksYE3023.gnucash.  << my file name for the "books" would probably 
change each year --- so it would be perhaps Books2023.gnucash and after 
the close I'd rename it Books2024 >>


The point is, if you ever want to look at the books in their state prior 
to the 2023 close you don't undo anything. Instead you retrieve the 
back-up and open a copy of that.



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] Company plan for stocks and stock options

[Michael or Penny Novack]

On 4/5/2023 9:01 AM, Wolfgang Paul Rauchholz wrote:

Hi Stan / Murugan all,

Thanks for picking up and providing your insight. That was very helpful.
I would assume that options and stocks I have not exercised yet cannot get
managed in gnucash?
Only when exercising options into stocks or selling stock or options?

The objective with gnucash is that I want to manage personal finances;
expense control, planning, etc..

Let me ask you  simple question that should clarify the can do/can;t do 
in gnucash matter.


Assume we are 50+ years ago and so you are still doing bookkeeping the 
old fashioned way, pen and in on accounting lined paper (either in bound 
volumes or loose leaf)  --- Could you THEN do this accounting you want 
for options not yet exercised, stock you were given but not allowed to 
sell immediately, etc. ?  That of course assumes knowing HOW to do the 
accounting for these things*.


If so, if doable the old fashioned way pen and ink on paper then you can 
certainly do using gnucash. ll gnucash is doing is partially automating 
the process. Very simple (two account) transactions can be entered 
without filling in a "journal" entry (you are actually entering "journal 
mode" when entering a split transaction) and posting form journal to 
ledger is automated, no errors.


Michael D Novack

* In other words, you might have to look up HOW to account for options 
you were given (as opposed to an option you purchased) in an accounting 
text that dealt with that topic.



___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Stan Brown]

> On 4/7/23 9:16 AM, G R Hewitt wrote:
>> And don't forget, as per the manual, if you close the books, the 
>> reports mightn't run right.>> I tested this out and they don't - the totals 
>> are not right; the
>> TB and P

On 2023-04-07 11:35, Adrien Monteleone wrote:
> The manual needs to be fixed on that point. Reports can be cognizant of
> closing entries for some years now. This was mentioned in a recent
> thread and I think a formal bug has been filed to track the change(s).
> 
> Open the report Options and see the Entries tab. (the Trial Balance can
> also filter Adjusting Entries) 

I close the books every year, and yet my Income Statement ("P") each
year is exactly right. (I've never run a trial balance -- can't see the
need as long as Orphan and Imbalance are both empty.)

As Adrien says, you may need to set the appropriate "closing" string in
Report Options to make this happen.

The documentation bug is number 798798.

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] Find not working in Gnucash for Windows 5.0

[Patrick James]

Tute Terner,

Will you please upload your sample data set.


> On 04/07/2023 11:46 AM Adrien Monteleone  
> wrote:
> 
>  
> Do the splits *that match the open account register* have 'paid' in 
> their memos?
> 
> If the 'paid' text is in a memo assigned to some *other* account, you 
> will not get results. Memos are not for the open register, but only for 
> accounts matching *for that split*.
> 
> e.g.,
> 
> Dr. Expenses:Utilities100
>-(Memo = "paid")
>Cr. Assets:Checking100
>  -(Memo is blank)
> 
> And you do a search with the Checking account register in view, for 
> "paid" you will get no results, because there are no splits *assigned to 
> the Checking account* with that memo. The splits that have that memo, 
> are assigned (in this case) to Expenses:Utilities.
> 
> You can do the search from the Accounts page, and set additional 
> criteria as needed to refine the search.
> 
> Regards,
> Adrien
> 
> On 4/7/23 5:57 AM, Tute Terner wrote:
> > On 2023-04-05 07:18, Tute Terner wrote:
> >> /When I search in the Find dialog box using the Description field, 
> >> />/everything works. But when I search by the Memo field or the 
> >> />/'Description, Notes or Memo' field or the Action field the Search 
> >> />/Results always turn out empty, even though the search string is 
> >> present />/in the Memo or Action fields of some transactions.  I am 
> >> using Gnucash />/5.0 for Windows, but I have noticed this in some 
> >> previous versions too. />/Am I doing something incorrect or is this a 
> >> bug. I don't see that />/anybody has mentioned this behaviour in the 
> >> mailing list or in the bug />/list. Thank you. /
> > 
> > 
> > The specific search instance I had is this. I have a Gnucash file with 
> > accounts X, Y, and Z. X and Y have split Memo fields containing the 
> > search string 'paid'. I display account register X and search for 'paid' 
> > in the Memo field. Zero results. I then go to 'List of accounts' tree 
> > tab and search the same, using 'New Search' every time. I get results 
> > from both X and Y. So this works, but I don't want the result from Y.
> > 
> > So again I search from the accounts tree tab adding the 'and' condition 
> > of Account and set it to X. Again 0 results. I display account register 
> > Y and run the search on Memo field only. Again 0 results.
> > 
> > To make doubly sure I created a dummy gnucash file with accounts X, Y 
> > and Z as above. Same results. So looks like a bug to me.
> 
> ___
> 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] Find not working in Gnucash for Windows 5.0

[Adrien Monteleone]

Do the splits *that match the open account register* have 'paid' in 
their memos?


If the 'paid' text is in a memo assigned to some *other* account, you 
will not get results. Memos are not for the open register, but only for 
accounts matching *for that split*.


e.g.,

Dr. Expenses:Utilities100
  -(Memo = "paid")
  Cr. Assets:Checking100
-(Memo is blank)

And you do a search with the Checking account register in view, for 
"paid" you will get no results, because there are no splits *assigned to 
the Checking account* with that memo. The splits that have that memo, 
are assigned (in this case) to Expenses:Utilities.


You can do the search from the Accounts page, and set additional 
criteria as needed to refine the search.


Regards,
Adrien

On 4/7/23 5:57 AM, Tute Terner wrote:

On 2023-04-05 07:18, Tute Terner wrote:
/When I search in the Find dialog box using the Description field, 
/>/everything works. But when I search by the Memo field or the 
/>/'Description, Notes or Memo' field or the Action field the Search 
/>/Results always turn out empty, even though the search string is 
present />/in the Memo or Action fields of some transactions.  I am 
using Gnucash />/5.0 for Windows, but I have noticed this in some 
previous versions too. />/Am I doing something incorrect or is this a 
bug. I don't see that />/anybody has mentioned this behaviour in the 
mailing list or in the bug />/list. Thank you. /



The specific search instance I had is this. I have a Gnucash file with 
accounts X, Y, and Z. X and Y have split Memo fields containing the 
search string 'paid'. I display account register X and search for 'paid' 
in the Memo field. Zero results. I then go to 'List of accounts' tree 
tab and search the same, using 'New Search' every time. I get results 
from both X and Y. So this works, but I don't want the result from Y.


So again I search from the accounts tree tab adding the 'and' condition 
of Account and set it to X. Again 0 results. I display account register 
Y and run the search on Memo field only. Again 0 results.


To make doubly sure I created a dummy gnucash file with accounts X, Y 
and Z as above. Same results. So looks like a bug to me.


___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Adrien Monteleone]

On 4/7/23 9:48 AM, CJN ... wrote:


So, if the consensus is that better not to Close Book at year end, how would I 
then continue forward in GNU-Cash  to store new transactions for current 
financial year?


You just keep entering transactions. I'm not certain of the conundrum here.

And get subsequent Trial Balance & Reports that only includes current 
year transactions (excluding data from previous financial periods)?


All reports have a General tab in their Options where you select the 
date range for the Transactions. (Balance Sheet would be ending date 
from the beginning of the book)


This defaults to 'current period' which is by default 'this year' but 
you can change that in Preferences.



Regards,
Adrien

___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Adrien Monteleone]

The manual needs to be fixed on that point. Reports can be cognizant of 
closing entries for some years now. This was mentioned in a recent 
thread and I think a formal bug has been filed to track the change(s).


Open the report Options and see the Entries tab. (the Trial Balance can 
also filter Adjusting Entries)


Regards,
Adrien

On 4/7/23 9:16 AM, G R Hewitt wrote:

And don't forget, as per the manual, if you close the books, the reports
mightn't run right.
I tested this out and they don't - the totals are not right; the TB and P
where way out.


___
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] Find not working in Gnucash for Windows 5.0

[Patrick James]

I am not a programmer, but this has a similar behavior to the bug I reported, 
in that the selected tab makes a big difference.

Sure, I reported the bug as a "second search" as that is how I associated it at 
the time, but with this added information the bug might be more about the tab 
selected.

I added this to my bug report here:

https://bugs.gnucash.org/show_bug.cgi?id=798803


> On 04/07/2023 3:57 AM Tute Terner  wrote:
> 
>  
> On 2023-04-05 07:18, Tute Terner wrote:
> >/When I search in the Find dialog box using the Description field, 
> >/>/everything works. But when I search by the Memo field or the 
> >/>/'Description, Notes or Memo' field or the Action field the Search 
> >/>/Results always turn out empty, even though the search string is present 
> >/>/in the Memo or Action fields of some transactions.  I am using Gnucash 
> >/>/5.0 for Windows, but I have noticed this in some previous versions too. 
> >/>/Am I doing something incorrect or is this a bug. I don't see that 
> >/>/anybody has mentioned this behaviour in the mailing list or in the bug 
> >/>/list. Thank you. /
> 
> 
> The specific search instance I had is this. I have a Gnucash file with 
> accounts X, Y, and Z. X and Y have split Memo fields containing the 
> search string 'paid'. I display account register X and search for 'paid' 
> in the Memo field. Zero results. I then go to 'List of accounts' tree 
> tab and search the same, using 'New Search' every time. I get results 
> from both X and Y. So this works, but I don't want the result from Y.
> 
> So again I search from the accounts tree tab adding the 'and' condition 
> of Account and set it to X. Again 0 results. I display account register 
> Y and run the search on Memo field only. Again 0 results.
> 
> To make doubly sure I created a dummy gnucash file with accounts X, Y 
> and Z as above. Same results. So looks like a bug to me.
___
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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Gyle McCollam]

1st , you should run your yearend reports before you "Close" and if you need to 
rerun at some future point, you could just delete the "closing" entries and 
rerun any reports then reclose after.  As for not closing, when you run reports 
for the next fiscal year you would use the start date of that year as the 
starting date for the new reports.  Either way, you can get what you need, the 
choice is yours.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: CJN ... 
Sent: Friday, April 7, 2023 10:48 AM
To: G R Hewitt ; Gyle McCollam 
Cc: gnucash-user@gnucash.org 
Subject: RE: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023


7 April 2023



Thanks to Gyle & GR Hewiitt for useful tips.



I’ve been reading the Help  section on Closing the Book at Year End.



And can see a benefit in starting the New Year with clean sheet for Income & 
Expenses. (Hopefully it carries forward Year End Assets – for bank accounts, 
etc).



And I see the note on reservations about accuracy of Reports for TB & P ( - 
that’s  a bit worrying of course).

(Quote: Note that closing the books in GnuCash is unnecessary. You do not need 
to zero out your income and expense accounts at the end of each financial 
period. GnuCash’s built-in reports automatically handle concepts like retained 
earnings between two different financial periods. In fact, closing the books 
reduces the usefulness of the standard reports because the reports don’t 
currently understand closing transactions. So from their point of view it 
simply looks like the net income or expense in each account for a given period 
was simply zero. ).

So, if the consensus is that better not to Close Book at year end, how would I 
then continue forward in GNU-Cash  to store new transactions for current 
financial year? And get subsequent Trial Balance & Reports that only includes 
current year transactions (excluding data from previous financial periods)?

My bookkeeping needs nowadays are probably very simply – simply managing income 
& expenses for couple rented properties (in retirement!). And being able to 
collate the data for the annual tax returns.



Any further comments or advice most welcome.

This is my (boring but necessary) Easter weekend project.



Have a good Easter Hol Weekend wherever!



Chris



London

cjn_internatio...@hotmail.com





From: G R Hewitt [mailto:hewit...@gmail.com]
Sent: Friday, April 7, 2023 3:16 PM
To: Gyle McCollam 
Cc: CJN ... ; gnucash-user@gnucash.org
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023



And don't forget, as per the manual, if you close the books, the reports 
mightn't run right.

I tested this out and they don't - the totals are not right; the TB and P 
where way out.



On Fri, 7 Apr 2023 at 14:05, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:

Chris,
In the "Tools" option there is a "Close Book..." selection, but before you use 
that click on "Help", then "Contents" and search for close book.  That will 
explain how to "Close Book" and explain that you don't actually have to do that 
for Gnucash to function correctly for the new year.  It is your choice whether 
to do that or not.  I do it every year, but some don't as it is not necessary 
for proper functioning.  You could also copy the and rename the current data 
file, before you start the new year to preserve a backup of the year end status.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com>
   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of CJN ... 
mailto:cjn_internatio...@hotmail.com>>
Sent: Friday, April 7, 2023 1:28 AM
To: CJN ... 
mailto:cjn_internatio...@hotmail.com>>; 
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023

7 April 2023

I'm not sure I'm using the GNU-Cash subscriber message system correctly to get 
feedback & help.
But no doubt someone will advise me if the message is received at Help Line.
Chris

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org]
 On Behalf Of CJN ...
Sent: Friday, April 7, 2023 6:21 AM
To: gnucash-user@gnucash.org
Subject: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 
2023), and start new Data set for the New Tax Year starting 6 

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[CJN.... ...]

7 April 2023

Thanks to Gyle & GR Hewiitt for useful tips.

I’ve been reading the Help  section on Closing the Book at Year End.

And can see a benefit in starting the New Year with clean sheet for Income & 
Expenses. (Hopefully it carries forward Year End Assets – for bank accounts, 
etc).

And I see the note on reservations about accuracy of Reports for TB & P ( - 
that’s  a bit worrying of course).

(Quote: Note that closing the books in GnuCash is unnecessary. You do not need 
to zero out your income and expense accounts at the end of each financial 
period. GnuCash’s built-in reports automatically handle concepts like retained 
earnings between two different financial periods. In fact, closing the books 
reduces the usefulness of the standard reports because the reports don’t 
currently understand closing transactions. So from their point of view it 
simply looks like the net income or expense in each account for a given period 
was simply zero. ).

So, if the consensus is that better not to Close Book at year end, how would I 
then continue forward in GNU-Cash  to store new transactions for current 
financial year? And get subsequent Trial Balance & Reports that only includes 
current year transactions (excluding data from previous financial periods)?
My bookkeeping needs nowadays are probably very simply – simply managing income 
& expenses for couple rented properties (in retirement!). And being able to 
collate the data for the annual tax returns.

Any further comments or advice most welcome.
This is my (boring but necessary) Easter weekend project.

Have a good Easter Hol Weekend wherever!

Chris

London
cjn_internatio...@hotmail.com


From: G R Hewitt [mailto:hewit...@gmail.com]
Sent: Friday, April 7, 2023 3:16 PM
To: Gyle McCollam 
Cc: CJN ... ; gnucash-user@gnucash.org
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023

And don't forget, as per the manual, if you close the books, the reports 
mightn't run right.
I tested this out and they don't - the totals are not right; the TB and P 
where way out.

On Fri, 7 Apr 2023 at 14:05, Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Chris,
In the "Tools" option there is a "Close Book..." selection, but before you use 
that click on "Help", then "Contents" and search for close book.  That will 
explain how to "Close Book" and explain that you don't actually have to do that 
for Gnucash to function correctly for the new year.  It is your choice whether 
to do that or not.  I do it every year, but some don't as it is not necessary 
for proper functioning.  You could also copy the and rename the current data 
file, before you start the new year to preserve a backup of the year end status.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com>
   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of CJN ... 
mailto:cjn_internatio...@hotmail.com>>
Sent: Friday, April 7, 2023 1:28 AM
To: CJN ... 
mailto:cjn_internatio...@hotmail.com>>; 
gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023

7 April 2023

I'm not sure I'm using the GNU-Cash subscriber message system correctly to get 
feedback & help.
But no doubt someone will advise me if the message is received at Help Line.
Chris

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org]
 On Behalf Of CJN ...
Sent: Friday, April 7, 2023 6:21 AM
To: gnucash-user@gnucash.org
Subject: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 
2023), and start new Data set for the New Tax Year starting 6 April 2023

6 April 2023

I have just completed using GNUCash for my first full year of data.
As I'm UK based the tax reporting year ends 5 April.
I've printed out all the data that I need for a hard copy record.

But in the HELP Manual I cannot seem to find instructions on how I would run 
any Year End Procedure, possibly clear out data files for the year just ended. 
(Or save/store the previous year data files) Or how to set up the GNUCash 
programme to start the New Year 6 April 2023 to 5 April 2024.

Can you help with advice?

Thanks

Chris
cjn-internatio...@hotmail.com>
London

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription 

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[G R Hewitt]

And don't forget, as per the manual, if you close the books, the reports
mightn't run right.
I tested this out and they don't - the totals are not right; the TB and P
where way out.

On Fri, 7 Apr 2023 at 14:05, Gyle McCollam  wrote:

> Chris,
> In the "Tools" option there is a "Close Book..." selection, but before you
> use that click on "Help", then "Contents" and search for close book.  That
> will explain how to "Close Book" and explain that you don't actually have
> to do that for Gnucash to function correctly for the new year.  It is your
> choice whether to do that or not.  I do it every year, but some don't as it
> is not necessary for proper functioning.  You could also copy the and
> rename the current data file, before you start the new year to preserve a
> backup of the year end status.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of CJN ... 
> Sent: Friday, April 7, 2023 1:28 AM
> To: CJN ... ; gnucash-user@gnucash.org
> 
> Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end
> 5 April 2023), and start new Data set for the New Tax Year starting 6 April
> 2023
>
> 7 April 2023
>
> I'm not sure I'm using the GNU-Cash subscriber message system correctly to
> get feedback & help.
> But no doubt someone will advise me if the message is received at Help
> Line.
> Chris
>
> -Original Message-
> From: gnucash-user [mailto:gnucash-user-bounces+cjn_international=
> hotmail@gnucash.org] On Behalf Of CJN ...
> Sent: Friday, April 7, 2023 6:21 AM
> To: gnucash-user@gnucash.org
> Subject: [GNC] How to run Year End Procedures for the Tax Year (UK end 5
> April 2023), and start new Data set for the New Tax Year starting 6 April
> 2023
>
> 6 April 2023
>
> I have just completed using GNUCash for my first full year of data.
> As I'm UK based the tax reporting year ends 5 April.
> I've printed out all the data that I need for a hard copy record.
>
> But in the HELP Manual I cannot seem to find instructions on how I would
> run any Year End Procedure, possibly clear out data files for the year just
> ended. (Or save/store the previous year data files) Or how to set up the
> GNUCash programme to start the New Year 6 April 2023 to 5 April 2024.
>
> Can you help with advice?
>
> Thanks
>
> Chris
> cjn-internatio...@hotmail.com
> London
>
> ___
> 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] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Gyle McCollam]

Chris,
In the "Tools" option there is a "Close Book..." selection, but before you use 
that click on "Help", then "Contents" and search for close book.  That will 
explain how to "Close Book" and explain that you don't actually have to do that 
for Gnucash to function correctly for the new year.  It is your choice whether 
to do that or not.  I do it every year, but some don't as it is not necessary 
for proper functioning.  You could also copy the and rename the current data 
file, before you start the new year to preserve a backup of the year end status.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of CJN ... 
Sent: Friday, April 7, 2023 1:28 AM
To: CJN ... ; gnucash-user@gnucash.org 

Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 
April 2023), and start new Data set for the New Tax Year starting 6 April 2023

7 April 2023

I'm not sure I'm using the GNU-Cash subscriber message system correctly to get 
feedback & help.
But no doubt someone will advise me if the message is received at Help Line.
Chris

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org] On 
Behalf Of CJN ...
Sent: Friday, April 7, 2023 6:21 AM
To: gnucash-user@gnucash.org
Subject: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 
2023), and start new Data set for the New Tax Year starting 6 April 2023

6 April 2023

I have just completed using GNUCash for my first full year of data.
As I'm UK based the tax reporting year ends 5 April.
I've printed out all the data that I need for a hard copy record.

But in the HELP Manual I cannot seem to find instructions on how I would run 
any Year End Procedure, possibly clear out data files for the year just ended. 
(Or save/store the previous year data files) Or how to set up the GNUCash 
programme to start the New Year 6 April 2023 to 5 April 2024.

Can you help with advice?

Thanks

Chris
cjn-internatio...@hotmail.com
London

___
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] Find not working in Gnucash for Windows 5.0

[Tute Terner]

On 2023-04-05 07:18, Tute Terner wrote:

/When I search in the Find dialog box using the Description field, />/everything works. But when I 
search by the Memo field or the />/'Description, Notes or Memo' field or the Action field the Search 
/>/Results always turn out empty, even though the search string is present />/in the Memo or 
Action fields of some transactions.  I am using Gnucash />/5.0 for Windows, but I have noticed this 
in some previous versions too. />/Am I doing something incorrect or is this a bug. I don't see that 
/>/anybody has mentioned this behaviour in the mailing list or in the bug />/list. Thank you. /



The specific search instance I had is this. I have a Gnucash file with 
accounts X, Y, and Z. X and Y have split Memo fields containing the 
search string 'paid'. I display account register X and search for 'paid' 
in the Memo field. Zero results. I then go to 'List of accounts' tree 
tab and search the same, using 'New Search' every time. I get results 
from both X and Y. So this works, but I don't want the result from Y.


So again I search from the accounts tree tab adding the 'and' condition 
of Account and set it to X. Again 0 results. I display account register 
Y and run the search on Memo field only. Again 0 results.


To make doubly sure I created a dummy gnucash file with accounts X, Y 
and Z as above. Same results. So looks like a bug to me.

___
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 run Year End Procedures on GNUCash, and start new files for the New Tax/Accounting Year

[CJN International]

6 April 2023



I have just completed using GNUCash for my first full year of data.

As I'm UK based the tax reporting year ends 5 April.

I've printed out all the data that I need for a hard copy record.



But in the HELP Manual I cannot seem to find instructions on how I would
run any Year End Procedure, possibly clear out data files for the year just
ended. (Or save/store the previous year data files)

Or how to set up the GNUCash programme to start the New Year 6 April 2023
to 5 April 2024.



Can you help with advice?



Thanks



Chris

cjn-internatio...@hotmail.com

London
*cjn.internatio...@gmail.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.