Re: [GNC] Basic Question (I hope) - End of Year Procedure

[David T. via gnucash-user]

Hello,
Welcome to gnucash, if rather belatedly. 
Your question is one that comes up at this time of the year, and can generate 
quite a bit of responses. You should definitely read the wiki page on this 
subject: 
Closing Books - GnuCash  
|  
|   
|   
|   ||

   |

  |
|  
|   |  
Closing Books - GnuCash
 

  |   |

  |

  |

  
Best,David 
 
  On Mon, Dec 24, 2018 at 10:32, Jennym<55.jennifer.mas...@gmail.com> wrote:   
Hi

I only started using GNUCash last April for simple, personal accounting, so
I'm at the 'basic' stage. I'm using it with:

a) Current bank account
b) Two credit card accounts
c) Personal Wallet
d) Three income accounts
e) Normal household accounts
f) Budgeting (manually entered, not automatic via the system)

So what I'd like to do:  Retain all of 2018 accounts (having them to hand
for easy access), but have them zeroed for 2019.

My worry is that if I do anything wrong, there's no historical 'undo' button
to backtrack.

Would really appreciate any advice. (Basic of course). Thank you 








--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[David T. via gnucash-user]

Apologies.  My mail program ate the link. 
wiki.gnucash.org/wiki/Closing_Books
 
 
  On Mon, Dec 24, 2018 at 13:46, David T. via 
gnucash-user wrote:   Hello,
Welcome to gnucash, if rather belatedly. 
Your question is one that comes up at this time of the year, and can generate 
quite a bit of responses. You should definitely read the wiki page on this 
subject: 
Closing Books - GnuCash  
|  
|  
|  
|  |    |

  |

  |
|  
|  |  
Closing Books - GnuCash
 

  |  |

  |

  |

  
Best,David 
 
  On Mon, Dec 24, 2018 at 10:32, Jennym<55.jennifer.mas...@gmail.com> wrote:  Hi

I only started using GNUCash last April for simple, personal accounting, so
I'm at the 'basic' stage. I'm using it with:

a) Current bank account
b) Two credit card accounts
c) Personal Wallet
d) Three income accounts
e) Normal household accounts
f) Budgeting (manually entered, not automatic via the system)

So what I'd like to do:  Retain all of 2018 accounts (having them to hand
for easy access), but have them zeroed for 2019.

My worry is that if I do anything wrong, there's no historical 'undo' button
to backtrack.

Would really appreciate any advice. (Basic of course). Thank you 








--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[David Cousens]

Jenny 
As well as the wiki that David T mentioned the help manual also has a
section on closing the books:

https://www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html
and the wiki:
https://wiki.gnucash.org/wiki/Closing_Books .

Gnucash's report structure is also capable of preparing standard end of year
type reports without having to perform a formal closing of the books as per
standard accounting practice. The main function in a business is to transfer
the profit into equity in the case of a business and deal with tax and other
matters which might depend upon the profit for the period. For personal
accounts this may not really be necessary.

David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Getting the date order in a report ?

[Finbar Mahon]

Hello, this is not urgent, just so I don't forget.

I am trying to print a listing of salary payments for the year.

I have selected the description for the transaction report and the data 
I want appears, fine.


However the dates are random, typically the output is date, the 
description, the amount, but the sequence of the dates is all over the 
place.


I've looked through and selected the various options I think I need but 
cannot find a way of getting things in date order.


Ideas?

Thanks, and best wishes of the season, Barry

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[Michael or Penny Novack]

On 12/24/2018 4:22 AM, David Cousens wrote:

Jenny
As well as the wiki that David T mentioned the help manual also has a
section on closing the books:


I will add something to this because of your "no magic undo button"

There sort of is. You can always make a copy of a file before you do 
some irrevocable change (this of course doesn't apply just to gnucash files)


Even if you do not ordinarily make backup copies of your books, 
especially if you are going to do a "close the books" operation, I 
suggest a backup copy before this operation and after (represents the 
state of the file at the start of the next year)


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help on Installation of Gnucash-Mac Version

[Stephen M. Butler]

On 12/23/18 3:24 PM, MNT wrote:

During the importing of a QIF (Quicken) file, after taking all the steps, in 
the final step that I click “Start Import” the import stops halfway and shows 
“Failed Import” and a message says the “there was an error”?  Any idea what I 
should do to complete the import.  I am using a Mac version.

Regards,

Moe


Moe,

I'm not a Mac user so can't help much.  However, I know that those who 
have Mac experience will want to know which version of GnC you have and 
the version of your Mac O/S.


In addition, can you find the log file (have to check the wiki for where 
it is located for your setup) and see if there are any additional 
messages there.


--Steve

--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] .deb package

[Stephen M. Butler]

On 12/23/18 8:54 PM, Andrew Clark wrote:

Thanks Stephen,

How is this different to the package in the testing distribution by 
Dmitry Smirnov that's listed as 3.3-2+b2 
(https://packages.debian.org/buster/gnucash)? Is it based on his 
package? Will it be merged with the main debian packages?




Andrew,

I don't know about Dmitry's package.  I simply pulled the source from 
Github (where the developers keep the latest source) and checked out the 
appropriate tag/branch to build on my Ubuntu 18.04 box.


Based on the 3.3-2+b2, I am presuming that Dmitry used the second commit 
after the 3.3 tag as his code.  At least if I interpret John's 
explanation correctly.


--Steve




On Sat, 22 Dec 2018 at 04:54, Stephen M. Butler > wrote:


I heard back from the user that requested a .deb package of GnC for
Ubuntu 18.04.  Apparently it is working well for him.

So, for others that might want to check this out on other debian
platforms, here is a link to the folder on my Google Drive:

https://drive.google.com/open?id=1fV_fURy6c77e7gf6S41lTacM7dFyy7VD

There I have the following:

  3.3-0  This has the 3.3 tag on it in git source

3.3-153 and 3.3-159  From when the recent maint fixes were merged
into
the main-line (master)

3.3-170 from maint branch back on the 9th.

Note that these are compiled and built on a Ubuntu 18.04 box using
checkinstall to create the .deb file.

--Steve

-- 
Stephen M Butler, PMP, PSM

stephen.m.butle...@gmail.com 
kg...@arrl.net 
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8



--
Cheers,

Andrew.



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Getting the date order in a report ?

[David Carlson]

I am not sure if this will help.  Check that the register sort order is set
to date posted.  If that does not work please let us know which GnuCash
release you are using and your operating system.

David C

On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon  Hello, this is not urgent, just so I don't forget.
>
> I am trying to print a listing of salary payments for the year.
>
> I have selected the description for the transaction report and the data
> I want appears, fine.
>
> However the dates are random, typically the output is date, the
> description, the amount, but the sequence of the dates is all over the
> place.
>
> I've looked through and selected the various options I think I need but
> cannot find a way of getting things in date order.
>
> Ideas?
>
> Thanks, and best wishes of the season, Barry
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Getting the date order in a report ?

[Stephen M. Butler]

On 12/24/18 2:47 AM, Finbar Mahon wrote:

Hello, this is not urgent, just so I don't forget.

I am trying to print a listing of salary payments for the year.

I have selected the description for the transaction report and the 
data I want appears, fine.


However the dates are random, typically the output is date, the 
description, the amount, but the sequence of the dates is all over the 
place.


I've looked through and selected the various options I think I need 
but cannot find a way of getting things in date order.


Ideas?

Thanks, and best wishes of the season, Barry



If this is the Transaction report, then one of the configuration options 
(I think on the right-most tab) allows you to specify the sort order.


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[Stephen M. Butler]

On 12/24/18 7:13 AM, Michael or Penny Novack wrote:

On 12/24/2018 4:22 AM, David Cousens wrote:

Jenny
As well as the wiki that David T mentioned the help manual also has a
section on closing the books:


I will add something to this because of your "no magic undo button"

There sort of is. You can always make a copy of a file before you do 
some irrevocable change (this of course doesn't apply just to gnucash 
files)


Even if you do not ordinarily make backup copies of your books, 
especially if you are going to do a "close the books" operation, I 
suggest a backup copy before this operation and after (represents the 
state of the file at the start of the next year)


Michael D Novack

There is another option if you are using the GnC method that simply 
writes a set of transactions that zero out the Income and Expense items 
and places the opposing entry in the appropriate location chosen by the 
user.  You can simply delete those two transactions and the books are 
magically no longer closed.


I found that out when I used that option to close a series of years one 
after the other only to discover I'd messed up on an entry on year 1.  I 
simply removed the closing transactions for that year, made the 
appropriate changes, and redid the close for that year.



Note:  You don't really have to close the books for each year and GnC 
will keep track of things for you.  But, I wanted to have a set of 
Equity accounts showing the retained earnings for each year.  After all 
that hard work, my wife indicated it wasn't really necessary.  <>



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help on Installation of Gnucash-Mac Version

[John Ralls]

> On Dec 24, 2018, at 11:04 AM, Stephen M. Butler  wrote:
> 
> On 12/23/18 3:24 PM, MNT wrote:
>> During the importing of a QIF (Quicken) file, after taking all the steps, in 
>> the final step that I click “Start Import” the import stops halfway and 
>> shows “Failed Import” and a message says the “there was an error”?  Any idea 
>> what I should do to complete the import.  I am using a Mac version.
>> 
>> Regards,
>> 
>> Moe
> 
> Moe,
> 
> I'm not a Mac user so can't help much.  However, I know that those who have 
> Mac experience will want to know which version of GnC you have and the 
> version of your Mac O/S.
> 
> In addition, can you find the log file (have to check the wiki for where it 
> is located for your setup) and see if there are any additional messages there.
> 

It’s not likely to be a Mac-only issue.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help on Installation of Gnucash-Mac Version

[John Ralls]

> On Dec 23, 2018, at 3:24 PM, MNT  wrote:
> 
> During the importing of a QIF (Quicken) file, after taking all the steps, in 
> the final step that I click “Start Import” the import stops halfway and shows 
> “Failed Import” and a message says the “there was an error”?  Any idea what I 
> should do to complete the import.  I am using a Mac version.

GnuCash source code doesn’t have a “Failed Import” message, and the only “there 
was an error” message is in the CSV importer, not the QIF one. How about a 
screenshot showing what GnuCash really displayed? Be sure to put it at the end 
of the message or use a link to something like Pastebin: The list server 
doesn’t like inline images.

You can also take a look at the trace file 
(https://wiki.gnucash.org/wiki/Tracefile 
) to see if there are any clues.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[Colin Law]

On Mon, 24 Dec 2018 at 05:03, Jennym <55.jennifer.mas...@gmail.com> wrote:
> ...
> So what I'd like to do:  Retain all of 2018 accounts (having them to hand
> for easy access), but have them zeroed for 2019.

I don't do this, for me there is no point. It is possible to view or
report on only transactions within a date range if one wants so I
don't see the advantage of closing the books.  If you do then you
loose easy access to the history, so for example when the dishwasher
fails and you think when and where did I buy that then you cannot
immediately find out.  I now have 18 years of personal accounts
history immediately accessible.

> My worry is that if I do anything wrong, there's no historical 'undo' button
> to backtrack.

If you do decide to do it then as others have pointed out, if you mess
things up then you can always go back to your previous backup.  If you
don't take regular backups then start doing so immediately.  Your disk
drive or PC may go up in smoke, literally or metaphorically, at any
time and the accounts file may be irretrievably lost.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Basic Question (I hope) - End of Year Procedure

[Michael or Penny Novack]

On 12/24/2018 3:45 PM, Colin Law wrote:


I don't do this, for me there is no point. It is possible to view or
report on only transactions within a date range if one wants so I
don't see the advantage of closing the books.  If you do then you
loose easy access to the history, so for example when the dishwasher
fails and you think when and where did I buy that then you cannot
immediately find out.  I now have 18 years of personal accounts
history immediately accessible.

Misunderstanding of what  "close the books" does?

It doesn't existing transactions in the "temporary" income and expense 
accounts.


Assuming that it is implemented approximating the traditional process, 
it enters a giant split transaction that closes (brings the balance to 
zero) for all of these accounts with whatever is necessary going to 
equity as the gain or loss for the period. In the old days, that was by 
moving through another temporary account called "profit and loss" (all 
the income and expense accounts closed to this account) which was then 
closed to equity by the gain or loss amount.


Since gnucash can produce the report without this step (the "profit and 
loss" account served as the report back then) there is no need to close 
the books.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.