Re: Installing GnuCash using GoDaddy MySQL Server

[Colin Law]

On 16 January 2018 at 06:34, Jim_S  wrote:
> I am trying to install gnuCash using a MySQL database hosted by GoDaddy.  We
> also use GoDaddy for our WordPress web page, so I already have the hosting
> account.  GnCash keeps giving me an error "The server at URL
> mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
> error or encountered bad or corrupt data.".

Can you access the db using that url from a mysql client on the PC?

Colin

>
> I must create the database through GoDaddy's page as GnuCash.  It makes the
> user name the same as the dbname.  GoDaddy assigns a host name of
> "GnuCash.db.3879949.hostedresource.com".  I put in "GnuCash" for both the
> database name and the user name, and enter the password I've selected.
>
> Any help??
> TIA.
> Jim_S
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Filtered account report

[David T. via gnucash-user]

AC,
I went a different way.  I created Subaccounts for each grouping I wanted to 
track. So, if I want to track interest on a particular loan (for example, if I 
expected a 1099 for it), I created a subaccount under Expenses:Interest. That 
made it simple to track individual loans. I also can assign the account to a 
tax line, and have it turn up in the TXF report.
It only takes a few minutes really, to restructure like this. 
David

 
 
  On Tue, Jan 16, 2018 at 10:21, AC wrote:   The 
description for each split does have the specific loan to which it
applies.  I used the search to filter on all of those but the
transaction report still pulls everything in.

On 2018-01-15 21:14, Adrien Monteleone wrote:
> Have you tagged each interest payment split with the loan name? You could use 
> that as the filter, though I would think the memo field would suffice.
> 
> Regards,
> Adrien
> 
>> On Jan 15, 2018, at 10:29 PM, AC  wrote:
>>
>> No, that didn't work.  It still pulls the interest payments from
>> multiple loans and won't let me filter out the specific interest
>> payments for one of the loans.
>>
>> On 2018-01-15 20:13, Christopher Lam wrote:
>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>
>>> On 16 Jan 2018 11:54 AM, "AC"  wrote:
>>>
 I was looking at some of my loans and wanted to get an idea of how much
 I paid in interest to each loan over their life.  I've got one account
 that collects the amount of loan interest every time I pay (as part of a
 split transaction) while the principal portion of the payment goes to
 the specific loan account.

 There's a mix of different loans in the one interest paid account (Loan
 A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
 interest paid on Loan B.

 I thought I could run an account report on a search window but that
 doesn't work because it also finds the principal payments and tabulates
 them as well in the final total.

 What report and/or filtering mechanism could/should I use to show this
 information?
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 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
>> 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
> 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
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
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: Manually entering historic records

[Liz]

On Tue, 16 Jan 2018 15:03:04 +1000
Dave H  wrote:

> I use Dropbox however I maintain my gnucash data file on my local
> drive rather than directly in Dropbox.  I think from memory the lock
> file hangs around in Dropbox so when you try to re-open your data
> file the LCK file is still the and triggers the warning dialog.  As
> others have said you can just click on open anyway if you're sure no
> one else has it open..
> 
> Keep your data file locally and depending on your OS use something
> like FreeFileSync / Create Synchronicity / etc to sync it to Dropbox
> when you are good and ready.
> 
> Cheers Dave H.


I use Dropbox a little differently. 
My gnucash folder is not part of my dropbox folder, but I rsync certain
changed files to the folder which syncs. They are the data files, and
none of the backups or lock files. cron runs the rsync at specific
intervals.

Gnucash folder > intermediate folder > cloud storage

It's a backup system only.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Filtered account report

[Adrien Monteleone]

Or just add the new transaction report to GnuCash. It’s an attachment here on 
the list from a few months ago. Sorry I don’t have the link to the thread 
directly. But I’m sure a Google search will turn it up.

Regards,
Adrien

> On Jan 15, 2018, at 11:57 PM, Christopher Lam  
> wrote:
> 
> Ah the transaction report as it stands currently cannot do description text
> filtering. The next release will be. For now the easiest workaround is to
> export to spreadsheet and filter from there.
> 
> On 16 Jan 2018 13:33, "AC"  wrote:
> 
> The description for each split does have the specific loan to which it
> applies.  I used the search to filter on all of those but the
> transaction report still pulls everything in.
> 
> On 2018-01-15 21:14, Adrien Monteleone wrote:
>> Have you tagged each interest payment split with the loan name? You could
> use that as the filter, though I would think the memo field would suffice.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 15, 2018, at 10:29 PM, AC  wrote:
>>> 
>>> No, that didn't work.  It still pulls the interest payments from
>>> multiple loans and won't let me filter out the specific interest
>>> payments for one of the loans.
>>> 
>>> On 2018-01-15 20:13, Christopher Lam wrote:
 Try the Transaction Report which has an Account Filter in the first tab.
 
 On 16 Jan 2018 11:54 AM, "AC"  wrote:
 
> I was looking at some of my loans and wanted to get an idea of how much
> I paid in interest to each loan over their life.  I've got one account
> that collects the amount of loan interest every time I pay (as part of
> a
> split transaction) while the principal portion of the payment goes to
> the specific loan account.
> 
> There's a mix of different loans in the one interest paid account (Loan
> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
> interest paid on Loan B.
> 
> I thought I could run an account report on a search window but that
> doesn't work because it also finds the principal payments and tabulates
> them as well in the final total.
> 
> What report and/or filtering mechanism could/should I use to show this
> information?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
>>> 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
>> 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
> 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
> 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.



Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Year end issues

[Liz]

On Tue, 16 Jan 2018 07:08:23 +0100
Jeff Abrahamson  wrote:

> In France, even for small clubs like ours, we face a regulatory
> requirement that the books be immutable after end of year.  This makes
> sense in that if the tax authorities (even though we don't have to
> file taxes) ask us a question and then find out that our books for
> some past year have changed, they might reasonably be suspicious of
> our rigor and tax-exempt-worthiness.
> 
> Is there a way in gnucash to make a set of transactions or a period of
> time immutable?  For us, that's really the only reason we still have
> for "closing books" -- avoiding this sort of mistake where something
> gets accidentally entered or changed from a past year.
> 
> Jeff Abrahamson


This is a frequently asked question. There is no way to make any
electronic file immutable. 
I can change a file, and change its 'access time' on the disk, and if I
know that, so do forensic accountants.

Practical things to do are to make a read-only copy, for example on a
CD-R, and lodge that with your accountant, or equivalent (a small club
would not have an accountant, but should have some place where
read-only media can be stored for the required number of years).

We know that what the tax authorities ask is actually impossible, and
you get clever politicians like the Australian Prime Minister,
declaring that the law of the land overrides the laws of mathematics.
http://www.zdnet.com/article/the-laws-of-australia-will-trump-the-laws-of-mathematics-turnbull/

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Validation of OFX TLS Certificates?

[Christoph R]

Hi Jeff,

I do not think that aqbanking checks against the system certificates. But you 
should have to accept a certificate only once. BUT when called directly from 
Gnucash aqbanking this does not work. It only remembers the certificate when 
called from the the command line e.g. with 
"/Applications/Gnucash.app/Contents/MacOS/aqbanking-cli request —balance”. 
After that it will only ask you again when the certificate changes. 

Cheers,
Christoph

> Am 16.01.2018 um 04:33 schrieb Jeff Kletsky :
> 
> I haven't been able to find much on getting past AqBanking not verifying 
> certificates for OFX connections.
> 
> https://wiki.gnucash.org/wiki/De/Setting_up_OFXDirectConnect_in_GnuCash_2 
> says to "blindly" accept them, which seems risky in this day and age. I found 
> a question around it asked on the list, but unanswered on 2016-11-23, "OFX 
> connection certificate troubles"
> 
> http://www.linuxsecurity.com/content/view/188984/102/ suggests that 
> gwenhywfar was patched to "use system ca-certificates" in 2015.
> 
> Before I dig further into this, is there a way to have the certificates 
> properly validated and, ideally, the revocation list checked? MacOS X here, 
> but a "generic" solution as a framework would also help!
> 
> Thanks,
> 
> Jeff
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

Installing GnuCash using GoDaddy MySQL Server

[Jim_S]

I am trying to install gnuCash using a MySQL database hosted by GoDaddy.  We
also use GoDaddy for our WordPress web page, so I already have the hosting
account.  GnCash keeps giving me an error "The server at URL
mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an
error or encountered bad or corrupt data.".

I must create the database through GoDaddy's page as GnuCash.  It makes the
user name the same as the dbname.  GoDaddy assigns a host name of
"GnuCash.db.3879949.hostedresource.com".  I put in "GnuCash" for both the
database name and the user name, and enter the password I've selected.

Any help??
TIA.
Jim_S





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Year end issues

[Jeff Abrahamson]

In France, even for small clubs like ours, we face a regulatory
requirement that the books be immutable after end of year.  This makes
sense in that if the tax authorities (even though we don't have to file
taxes) ask us a question and then find out that our books for some past
year have changed, they might reasonably be suspicious of our rigor and
tax-exempt-worthiness.

Is there a way in gnucash to make a set of transactions or a period of
time immutable?  For us, that's really the only reason we still have for
"closing books" -- avoiding this sort of mistake where something gets
accidentally entered or changed from a past year.

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


On 15/01/18 22:23, Ronal B Morse wrote:
> This is what I do, but I'm only dealing with household and personal
> accounts and smallish investment portfolios. Because the statement
> closing dates for the investment and personal bank and credit accounts
> don't correspond exactly with the beginning date of the new book,
> there's always some monkey motion at the first of the year to "fix"
> opening balances or manually add transactions that were in float.
>
> Not much work, actually, and this keeps the year's data file (and
> backups) down to a reasonable size.  Access to past data is as easy as
> opening the appropriate file (one must remember to ensure you're
> working on the correct data at the start of the next session as the
> autobot opens the last data file you uses, not the newest by date).
>
> I understand that people using GnuCash for business purposes may be
> facing different issues and restrictions.
>
> RBM.
>
>
> On 01/15/2018 01:54 PM, Mike or Penny Novack wrote:
>> Let's discuss this (and possible options)
>>
>> First, you need to understand what "close the books" does do and what
>> is does not do. It creates a transaction (or transactions) to zero
>> out income and expense accounts to equity. It does NOT remove
>> transactions and so will not make your file smaller.
>>
>> It sounds like what you want is something more like to was in the old
>> days of books kept in BOOKS, pen and ink on paper.  What was common
>> at the end of each accounting period was to close the old books and
>> open new ones. The old volumes were put safely by in case they needed
>> to be referenced later.
>>
>> One of the advantages of software like gnucash is that it can create
>> the usual reports without actually closing the books. Easy to
>> reference old transactions (previous accounting periods) without
>> having to "bring them back" as they would have done in the old days
>> when physical books. But suppose you don't want this, you don't want
>> to be seeing all those accounts that have become obsolete cluttering
>> up your view, etc. Or are worried about the sheer size of the file, etc.
>>
>> You CAN simulate what was done in the old days when they opened new
>> books each period. This is just like when you created your gnucash
>> books in the first place. You run a final Balance Sheet report which
>> gives you the balances of all of the standing accounts (asset,
>> liability, and equity). You create a new set of books, say by
>> exporting the CoA and importing that to a new set of books (all
>> accounts zero) and can delete any accounts that are obsolete. You
>> then enter the initial values from the Balance Sheet << note: I never
>> use the facility to create accounts with an initial value but instead
>> with an opening transaction, or rather two so each is split on only
>> one side >>
>>
>> You of course SAVE the old file. If you at some future time want to
>> look at old (prior period) transactions you simply ask gnucash to
>> open THAT (saved) file instead of the one you are currently using.
>>
>> Michael D Novack
>>
>> PS: All of my books are small enough that I have never been tempted
>> to do this. The obsolete accounts do not appear in the reports as
>> furnished to the boards of the organizations because EDITED first <<
>> in other words, I do not expect gnucash to produce the final pretty
>> version of reports. I have to edit them anyway to add annotations
>> explaining and unusual entries so all the editing for "pretty print"
>> etc. can be done at that time >>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
> 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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/

___
gnucash-user mailing list
gnucash-user@gnucash.org

Re: Filtered account report

[Christopher Lam]

Ah the transaction report as it stands currently cannot do description text
filtering. The next release will be. For now the easiest workaround is to
export to spreadsheet and filter from there.

On 16 Jan 2018 13:33, "AC"  wrote:

The description for each split does have the specific loan to which it
applies.  I used the search to filter on all of those but the
transaction report still pulls everything in.

On 2018-01-15 21:14, Adrien Monteleone wrote:
> Have you tagged each interest payment split with the loan name? You could
use that as the filter, though I would think the memo field would suffice.
>
> Regards,
> Adrien
>
>> On Jan 15, 2018, at 10:29 PM, AC  wrote:
>>
>> No, that didn't work.  It still pulls the interest payments from
>> multiple loans and won't let me filter out the specific interest
>> payments for one of the loans.
>>
>> On 2018-01-15 20:13, Christopher Lam wrote:
>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>
>>> On 16 Jan 2018 11:54 AM, "AC"  wrote:
>>>
 I was looking at some of my loans and wanted to get an idea of how much
 I paid in interest to each loan over their life.  I've got one account
 that collects the amount of loan interest every time I pay (as part of
a
 split transaction) while the principal portion of the payment goes to
 the specific loan account.

 There's a mix of different loans in the one interest paid account (Loan
 A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
 interest paid on Loan B.

 I thought I could run an account report on a search window but that
 doesn't work because it also finds the principal payments and tabulates
 them as well in the final total.

 What report and/or filtering mechanism could/should I use to show this
 information?
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 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
>> 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
> 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
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
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: Installation on Windows 10

[Ronal B Morse]

Did you install GnuCash using the same user account as you are using 
now?  Or with an Administrator account?


If you installed GnuCash while logged in as an administrator or 
different user GnuCash may not have the correct permissions to access 
the directory in which the data file is located even though you do.


I wish I could offer some specific things to check, but the Windows file 
protection schema is opaque to me.


RBM



On 01/15/2018 08:11 PM, David Carlson wrote:

Can you save other documents such as spreadsheets to that folder?  Is there
plenty of free space on your C: drive (like several GIG's)? is this machine
owned by someone else such as your employer?

David C

On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email  wrote:


David,

I did create subfolder but the same error pops up.  I definetly have full
access to the folder and subfolder.  Is there any special first time steps
that I could be missing?



*Sent:* Sunday, January 14, 2018 at 3:51 PM
*From:* "David Carlson" 
*To:* "Snarky Email" 
*Cc:* "Gnucash Users" 
*Subject:* Re: Installation on Windows 10
Snarky,

It does seem very odd that GnuCash is unable to write to that folder.  Can
you save other documents to that folder?

I would recommend creating a special subfolder for GnuCash data files as
GnuCash will be creating a lot of temporary files in the same folder.

David C


On Jan 14, 2018 12:52 PM, "Snarky Email"  wrote:

I installed gnucash on my Windows 10 system and the new file setup
fails.  I am using defaults for a new account to practice/test with.
When I try to save as xml I get this error:  GnuCash could not write to
C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be on a
read-only file system, or you may not have write permission for the
directory."
I do have full access on the folder.
Any help would be appreciated.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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
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: Filtered account report

[AC]

The description for each split does have the specific loan to which it
applies.  I used the search to filter on all of those but the
transaction report still pulls everything in.

On 2018-01-15 21:14, Adrien Monteleone wrote:
> Have you tagged each interest payment split with the loan name? You could use 
> that as the filter, though I would think the memo field would suffice.
> 
> Regards,
> Adrien
> 
>> On Jan 15, 2018, at 10:29 PM, AC  wrote:
>>
>> No, that didn't work.  It still pulls the interest payments from
>> multiple loans and won't let me filter out the specific interest
>> payments for one of the loans.
>>
>> On 2018-01-15 20:13, Christopher Lam wrote:
>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>
>>> On 16 Jan 2018 11:54 AM, "AC"  wrote:
>>>
 I was looking at some of my loans and wanted to get an idea of how much
 I paid in interest to each loan over their life.  I've got one account
 that collects the amount of loan interest every time I pay (as part of a
 split transaction) while the principal portion of the payment goes to
 the specific loan account.

 There's a mix of different loans in the one interest paid account (Loan
 A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
 interest paid on Loan B.

 I thought I could run an account report on a search window but that
 doesn't work because it also finds the principal payments and tabulates
 them as well in the final total.

 What report and/or filtering mechanism could/should I use to show this
 information?
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 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
>> 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
> 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
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: Filtered account report

[Adrien Monteleone]

Have you tagged each interest payment split with the loan name? You could use 
that as the filter, though I would think the memo field would suffice.

Regards,
Adrien

> On Jan 15, 2018, at 10:29 PM, AC  wrote:
> 
> No, that didn't work.  It still pulls the interest payments from
> multiple loans and won't let me filter out the specific interest
> payments for one of the loans.
> 
> On 2018-01-15 20:13, Christopher Lam wrote:
>> Try the Transaction Report which has an Account Filter in the first tab.
>> 
>> On 16 Jan 2018 11:54 AM, "AC"  wrote:
>> 
>>> I was looking at some of my loans and wanted to get an idea of how much
>>> I paid in interest to each loan over their life.  I've got one account
>>> that collects the amount of loan interest every time I pay (as part of a
>>> split transaction) while the principal portion of the payment goes to
>>> the specific loan account.
>>> 
>>> There's a mix of different loans in the one interest paid account (Loan
>>> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
>>> interest paid on Loan B.
>>> 
>>> I thought I could run an account report on a search window but that
>>> doesn't work because it also finds the principal payments and tabulates
>>> them as well in the final total.
>>> 
>>> What report and/or filtering mechanism could/should I use to show this
>>> information?
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> 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
> 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
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: Invoices: multilingual & tax detail questions

[Macho Philipovich]

Thanks Derek,


On 2018-01-15 11:51 AM, Derek Atkins wrote:
> Unfortunately the report translation is based on your system locale.

Ah, of course! I can just run Gnucash from terminal after changing the
locale environment variable whenever I want to print French invoices.
Excellent!

>
>> Is there any way to separate the two VAT taxes within the invoice?
> Of course.  Set a tax table with two entries (one for GST, one for PST)
> and when you print the invoice select the "show individual taxes" option
> (which may be called something else, but that's the gist of the option).

I was initially perplexed by this, and then I realized: I'm using a
customized version of the "Tax Invoice" report, which is the only
invoice report that doesn't include the option that you're referring to.
This seems to be because this report shows taxes beside each invoice
item, as well as at the end as a total, which I guess is reasonable.

The only reason I'm using "tax invoice" in particular is that it was the
only one for which I could easily locate the eguile source to customize
it, whereas I could not figure out how to edit the other invoice
reports. You've already helped more than enough, but if you have any
pointers on how I can incorporate an arbitrary css style into one of the
other invoices, the way tax invoice allows in its options, I'd be grateful.

Thanks again for your answers above! Simple, yet very helpful.

Macho


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Recording transactions

[Adrien Monteleone]

> On Jan 15, 2018, at 10:26 PM, sszd  wrote:
> 
> I’d like to thank you for your time and response.  You’ve cleared up a few
> things I was confused about, and made me feel better about how I was setting
> things up.
> 
> Aside from how you’ve categorized some of the accounts, it looks like my 1st
> example was right on the money (no pun intended), or at least pretty close. 
> I’d like to go over each itemized line just to clarify a few things and make
> sure I understand.
> 
> 1. Dr. Assets:Business:Current Assets:Bank $16.32
> 
> As I mentioned in my original post, the “Etsy” account is actually a real
> physical account, or at least we’re treating it that way.  Monies from Etsy
> sales go into this account maintained by Etsy.  If refunds are issued, those
> monies are used to reimburse the customer.  Once a week, whatever balance is
> in the account is automatically transferred to my wife’s business checking
> account.  So we simply treat the Etsy account just like a bank account. 
> When transfers are made, we enter a transfer of monies from the Etsy account
> to a checking account.  The Etsy account can also be used to make online
> purchases to other Etsy vendors.  This is exactly how PayPal works (with the
> exception of automated transfers of deposits).  In fact, Etsy customers can
> also make their purchases through PayPal.  But of course, monies from that
> sale would go to a PayPal account and not Etsy.

Then in the sales transactions, be sure to debit the Etsy account instead.

When you transfer funds manually, or automatically, then you do that between 
the Etsy account and your bank account.

> 
> 2. Dr. Expenses:Business:Fees:Etsy Sale Fees $  .76 
> 
> It looks like I’ve set this up correctly.
> 
> 3. Dr. Expenses:Business:Cost of Goods Sold $ 5.00 
> 
> We do not track cost of goods sold or track an inventory.  My wife’s
> business (as mentioned) is very small.  She puts together banners for
> special occasions (weddings, birthdays, etc.).  It would be a nightmare (if
> not impossible) to try to determine the cost of supplies in putting one of
> these banners together.  In addition, she makes so little money it would be
> far too much effort to try to do this extra work.  Tax season is already
> hard enough as it is, and it takes me many weeks to complete every year. 
> Ultimately, I don’t know if this is the right thing to do or not.  But years
> ago I was advised that as long as we keep detailed records of her business
> expenses and sales, we should be fine.  It seems to work out okay when we
> file schedule C.

It’s your call, but if you aren’t tracking this, it looks like your taxable 
income is much higher than it really is. Certainly, follow the advice of a 
local CPA on this one.

> 
> 4.Cr. Revenue:Sales:Product $10.00 
> 
> I like your idea of the Revenue account vice the Income account.  Both, of
> course, are income, but I guess this makes it a little more clear.  I’m
> assuming you’d still keep a separate top level Income account for paychecks
> from my job (totally unrelated from the business)?

Yep.

It helps with separation in the same book.

Technically, everything that comes in is not ‘income.’ Income is Revenue - 
Expenses. (which is why tracking Cost of Goods, which is an expense, is so 
important. It’s probably at least 30% of your total expenses unless you are 
mostly service oriented.)

Any confusion on the income concept is entirely the making of 100+ years of 
murky laws. For a business, income is revenue - expenses. For an individual - 
ask a CPA or a lawyer. (you’ll probably get 2 different answers as well)

> 
> 5.Cr. Revenue:Shipping $ 6.65 
> 
> You are correct, my wife will collect shipping costs from her customers at
> time of sale, which will go into the Etsy account (and eventually her
> checking).  Etsy does not handle any product directly.  A couple of times a
> week she will make a trip to the post office to ship multiple packages to
> multiple customers and pay for all the postage at that time.  She does not
> collect excess postage from customers.  If a customer overpays, or it costs
> less to ship than expected, she always issues a refund back to the customer
> for excess postage.  She feels bad and does not like customers paying more
> for shipping than what it really costs (unlike many other vendors).
> 
> It’s interesting how you’ve categorized this.  I’ve always considered
> shipping a business expense.  In Quicken, I considered what we received from
> the customer for shipping as income, and then later, when it’s actually
> shipped, the cost as an expense.  So actually, I guess I considered it both
> income and an expense.  With that in mind, I thought that putting it under
> Expenses in GnuCash was the appropriate thing to do.  I noticed that when
> it’s done this way the balance is negative when the customer has payed for
> shipping and then zeros out when the cost is incurred upon actual shipping. 
> I’m assuming doing it you

Re: Manually entering historic records

[Dave H]

I use Dropbox however I maintain my gnucash data file on my local drive
rather than directly in Dropbox.  I think from memory the lock file hangs
around in Dropbox so when you try to re-open your data file the LCK file is
still the and triggers the warning dialog.  As others have said you can
just click on open anyway if you're sure no one else has it open..

Keep your data file locally and depending on your OS use something like
FreeFileSync / Create Synchronicity / etc to sync it to Dropbox when you
are good and ready.

Cheers Dave H.


On 16 January 2018 at 14:39, David Carlson 
wrote:

> Trevor,
>
> Have you tried making a copy of the file on your local drive and working on
> it there.  I have never worked with dropbox so I have no idea if it could
> confused by the way GnuCash makes backups, for example.
>
> David C
>
> On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith  wrote:
>
> > If you don't have it open elsewhere you can click "Open anyway"
> >
> > Depending on how it shutdown the lock file may be there.
> >
> >
> > On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> > gnucash-user@gnucash.org> wrote:
> >
> > I'm not making much progress... I see I got some replies to my manual
> entry
> > issues but now unable to investigate further... see attached
> screen-prints.
> >
> >
> >
> > On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> > tr...@yahoo.co.uk> wrote:
> >
> >  I'll bet I'm doing something dumb... but even with date drop-down menu,
> I
> > am unable to insert any date before 11Jan. See attached.
> >
> >
> > On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> > r...@copplecleaningservice.com> wrote:
> >
> >  Hi Trevor,
> >
> > What exactly is it doing to prevent you from entering past dates? I enter
> > them all the time. You do have to enter the / dividers. Like instead of
> > 11418 you would have to enter 1/14/18 to get the date to come out right.
> > --Rick Copple
> >
> >
> > On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
> >
> >
> > I've been following the user group for years but still not started the
> move
> > from 20yrs of MSmoney... all looks too hard with an MSM file with records
> > back to 1997.
> > I thought I could test the water with a new business and associated bank
> > account that started in 2016.I've been managing this with a spreadsheet
> as
> > very few transactions.
> > So I set up a business set of accounts and tried entering manually, the
> > historic records... I'm immediately stumped. It does not let me enter
> past
> > dates. Clearly I'm going about this in the wrong way.Advice
> > appreciated.Trevor
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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
> > 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
> > 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
> 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
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: Manually entering historic records

[David Carlson]

Trevor,

Have you tried making a copy of the file on your local drive and working on
it there.  I have never worked with dropbox so I have no idea if it could
confused by the way GnuCash makes backups, for example.

David C

On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith  wrote:

> If you don't have it open elsewhere you can click "Open anyway"
>
> Depending on how it shutdown the lock file may be there.
>
>
> On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> gnucash-user@gnucash.org> wrote:
>
> I'm not making much progress... I see I got some replies to my manual entry
> issues but now unable to investigate further... see attached screen-prints.
>
>
>
> On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> tr...@yahoo.co.uk> wrote:
>
>  I'll bet I'm doing something dumb... but even with date drop-down menu, I
> am unable to insert any date before 11Jan. See attached.
>
>
> On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> r...@copplecleaningservice.com> wrote:
>
>  Hi Trevor,
>
> What exactly is it doing to prevent you from entering past dates? I enter
> them all the time. You do have to enter the / dividers. Like instead of
> 11418 you would have to enter 1/14/18 to get the date to come out right.
> --Rick Copple
>
>
> On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
>
>
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
> 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
> 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
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: Manually entering historic records

[Adrien Monteleone]

I’d choose “Open Anyway” as well, but you could also delete that LCK file. 
That’s the one causing the problem. (Note, it is supposed to be there if you 
have the file already open, but since you know for a fact you don’t, you can 
delete it. Normally, this file is deleted when you close the application, or 
open a different book.)


> On Jan 15, 2018, at 9:39 PM, Chris Smith  wrote:
> 
> If you don't have it open elsewhere you can click "Open anyway"
> 
> Depending on how it shutdown the lock file may be there.
> 
> 
> On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
> gnucash-user@gnucash.org> wrote:
> 
> I'm not making much progress... I see I got some replies to my manual entry
> issues but now unable to investigate further... see attached screen-prints.
> 
> 
> 
>On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
> tr...@yahoo.co.uk> wrote:
> 
> I'll bet I'm doing something dumb... but even with date drop-down menu, I
> am unable to insert any date before 11Jan. See attached.
> 
> 
>On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
> r...@copplecleaningservice.com> wrote:
> 
> Hi Trevor,
> 
> What exactly is it doing to prevent you from entering past dates? I enter
> them all the time. You do have to enter the / dividers. Like instead of
> 11418 you would have to enter 1/14/18 to get the date to come out right.
> --Rick Copple
> 
> 
> On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:
> 
> 
> I've been following the user group for years but still not started the move
> from 20yrs of MSmoney... all looks too hard with an MSM file with records
> back to 1997.
> I thought I could test the water with a new business and associated bank
> account that started in 2016.I've been managing this with a spreadsheet as
> very few transactions.
> So I set up a business set of accounts and tried entering manually, the
> historic records... I'm immediately stumped. It does not let me enter past
> dates. Clearly I'm going about this in the wrong way.Advice
> appreciated.Trevor
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
> 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
> 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.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Filtered account report

[AC]

No, that didn't work.  It still pulls the interest payments from
multiple loans and won't let me filter out the specific interest
payments for one of the loans.

On 2018-01-15 20:13, Christopher Lam wrote:
> Try the Transaction Report which has an Account Filter in the first tab.
> 
> On 16 Jan 2018 11:54 AM, "AC"  wrote:
> 
>> I was looking at some of my loans and wanted to get an idea of how much
>> I paid in interest to each loan over their life.  I've got one account
>> that collects the amount of loan interest every time I pay (as part of a
>> split transaction) while the principal portion of the payment goes to
>> the specific loan account.
>>
>> There's a mix of different loans in the one interest paid account (Loan
>> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
>> interest paid on Loan B.
>>
>> I thought I could run an account report on a search window but that
>> doesn't work because it also finds the principal payments and tabulates
>> them as well in the final total.
>>
>> What report and/or filtering mechanism could/should I use to show this
>> information?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
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: Recording transactions

[sszd]

I’d like to thank you for your time and response.  You’ve cleared up a few
things I was confused about, and made me feel better about how I was setting
things up.

Aside from how you’ve categorized some of the accounts, it looks like my 1st
example was right on the money (no pun intended), or at least pretty close. 
I’d like to go over each itemized line just to clarify a few things and make
sure I understand.

1. Dr. Assets:Business:Current Assets:Bank $16.32

As I mentioned in my original post, the “Etsy” account is actually a real
physical account, or at least we’re treating it that way.  Monies from Etsy
sales go into this account maintained by Etsy.  If refunds are issued, those
monies are used to reimburse the customer.  Once a week, whatever balance is
in the account is automatically transferred to my wife’s business checking
account.  So we simply treat the Etsy account just like a bank account. 
When transfers are made, we enter a transfer of monies from the Etsy account
to a checking account.  The Etsy account can also be used to make online
purchases to other Etsy vendors.  This is exactly how PayPal works (with the
exception of automated transfers of deposits).  In fact, Etsy customers can
also make their purchases through PayPal.  But of course, monies from that
sale would go to a PayPal account and not Etsy.

2. Dr. Expenses:Business:Fees:Etsy Sale Fees $  .76 

It looks like I’ve set this up correctly.

3. Dr. Expenses:Business:Cost of Goods Sold $ 5.00 

We do not track cost of goods sold or track an inventory.  My wife’s
business (as mentioned) is very small.  She puts together banners for
special occasions (weddings, birthdays, etc.).  It would be a nightmare (if
not impossible) to try to determine the cost of supplies in putting one of
these banners together.  In addition, she makes so little money it would be
far too much effort to try to do this extra work.  Tax season is already
hard enough as it is, and it takes me many weeks to complete every year. 
Ultimately, I don’t know if this is the right thing to do or not.  But years
ago I was advised that as long as we keep detailed records of her business
expenses and sales, we should be fine.  It seems to work out okay when we
file schedule C.

4.        Cr. Revenue:Sales:Product $10.00 

I like your idea of the Revenue account vice the Income account.  Both, of
course, are income, but I guess this makes it a little more clear.  I’m
assuming you’d still keep a separate top level Income account for paychecks
from my job (totally unrelated from the business)?

5.        Cr. Revenue:Shipping $ 6.65 

You are correct, my wife will collect shipping costs from her customers at
time of sale, which will go into the Etsy account (and eventually her
checking).  Etsy does not handle any product directly.  A couple of times a
week she will make a trip to the post office to ship multiple packages to
multiple customers and pay for all the postage at that time.  She does not
collect excess postage from customers.  If a customer overpays, or it costs
less to ship than expected, she always issues a refund back to the customer
for excess postage.  She feels bad and does not like customers paying more
for shipping than what it really costs (unlike many other vendors).

It’s interesting how you’ve categorized this.  I’ve always considered
shipping a business expense.  In Quicken, I considered what we received from
the customer for shipping as income, and then later, when it’s actually
shipped, the cost as an expense.  So actually, I guess I considered it both
income and an expense.  With that in mind, I thought that putting it under
Expenses in GnuCash was the appropriate thing to do.  I noticed that when
it’s done this way the balance is negative when the customer has payed for
shipping and then zeros out when the cost is incurred upon actual shipping. 
I’m assuming doing it your way (as Revenue) it would show as a positive
value when the customer pays, and then gets zeroed out upon actual shipping.

6.        Cr. Liability:Business:Sales Tax Payable $ 0.43

Actually, I was torn about this particular item.  I thought about putting it
in as a liability, but then every example I found online showed it as a
business expense.  Your explanation makes a lot of sense, and I agree with
what you’re saying.  Oh, and by the way, we only pay the sales tax to the
state once a year instead of quarterly.  The business generates about 99% of
its sales from out of state.  There are so little in-state sales that if we
payed quarterly, we’d rarely owe anything due to the formulas and rounding
used to calculate what’s owed.

7.        Cr. Assets:Current Assets:Business:Inventory $ 5.00 

See #3 above.

8. Dr. Expenses:Business:Postage 
        Cr. Assets:Current Assets:Bank-Business 

Okay, I see what you’re doing now with postage.  You’re considering it both
an income and an expense.  So that means you have two separate Postage (i.e.
Shipping) accounts.  I didn’t know if it w

Re: Filtered account report

[Christopher Lam]

Try the Transaction Report which has an Account Filter in the first tab.

On 16 Jan 2018 11:54 AM, "AC"  wrote:

> I was looking at some of my loans and wanted to get an idea of how much
> I paid in interest to each loan over their life.  I've got one account
> that collects the amount of loan interest every time I pay (as part of a
> split transaction) while the principal portion of the payment goes to
> the specific loan account.
>
> There's a mix of different loans in the one interest paid account (Loan
> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
> interest paid on Loan B.
>
> I thought I could run an account report on a search window but that
> doesn't work because it also finds the principal payments and tabulates
> them as well in the final total.
>
> What report and/or filtering mechanism could/should I use to show this
> information?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

Filtered account report

[AC]

I was looking at some of my loans and wanted to get an idea of how much
I paid in interest to each loan over their life.  I've got one account
that collects the amount of loan interest every time I pay (as part of a
split transaction) while the principal portion of the payment goes to
the specific loan account.

There's a mix of different loans in the one interest paid account (Loan
A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
interest paid on Loan B.

I thought I could run an account report on a search window but that
doesn't work because it also finds the principal payments and tabulates
them as well in the final total.

What report and/or filtering mechanism could/should I use to show this
information?
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Installation on Windows 10

[Chris Smith]

Try run in gnucash as administrator by right clicking on the icon and
selecting "Run as administrator"

What does that do?

On Jan 15, 2018 9:13 PM, "David Carlson" 
wrote:

> Can you save other documents such as spreadsheets to that folder?  Is there
> plenty of free space on your C: drive (like several GIG's)? is this machine
> owned by someone else such as your employer?
>
> David C
>
> On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email  wrote:
>
> > David,
> >
> > I did create subfolder but the same error pops up.  I definetly have full
> > access to the folder and subfolder.  Is there any special first time
> steps
> > that I could be missing?
> >
> >
> >
> > *Sent:* Sunday, January 14, 2018 at 3:51 PM
> > *From:* "David Carlson" 
> > *To:* "Snarky Email" 
> > *Cc:* "Gnucash Users" 
> > *Subject:* Re: Installation on Windows 10
> > Snarky,
> >
> > It does seem very odd that GnuCash is unable to write to that folder.
> Can
> > you save other documents to that folder?
> >
> > I would recommend creating a special subfolder for GnuCash data files as
> > GnuCash will be creating a lot of temporary files in the same folder.
> >
> > David C
> >
> >
> > On Jan 14, 2018 12:52 PM, "Snarky Email"  wrote:
> >>
> >>I installed gnucash on my Windows 10 system and the new file setup
> >>fails.  I am using defaults for a new account to practice/test with.
> >>When I try to save as xml I get this error:  GnuCash could not write
> to
> >>C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be
> on a
> >>read-only file system, or you may not have write permission for the
> >>directory."
> >>I do have full access on the folder.
> >>Any help would be appreciated.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> 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
> 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
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: Manually entering historic records

[Chris Smith]

If you don't have it open elsewhere you can click "Open anyway"

Depending on how it shutdown the lock file may be there.


On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" <
gnucash-user@gnucash.org> wrote:

I'm not making much progress... I see I got some replies to my manual entry
issues but now unable to investigate further... see attached screen-prints.



On Sunday, 14 January 2018, 19:27:21 GMT+8, Trevor Richards <
tr...@yahoo.co.uk> wrote:

 I'll bet I'm doing something dumb... but even with date drop-down menu, I
am unable to insert any date before 11Jan. See attached.


On Sunday, 14 January 2018, 16:43:58 GMT+8, Rick Copple <
r...@copplecleaningservice.com> wrote:

 Hi Trevor,

What exactly is it doing to prevent you from entering past dates? I enter
them all the time. You do have to enter the / dividers. Like instead of
11418 you would have to enter 1/14/18 to get the date to come out right.
--Rick Copple


On Jan 14, 2018, at 12:15 AM, Trevor Richards  wrote:


I've been following the user group for years but still not started the move
from 20yrs of MSmoney... all looks too hard with an MSM file with records
back to 1997.
I thought I could test the water with a new business and associated bank
account that started in 2016.I've been managing this with a spreadsheet as
very few transactions.
So I set up a business set of accounts and tried entering manually, the
historic records... I'm immediately stumped. It does not let me enter past
dates. Clearly I'm going about this in the wrong way.Advice
appreciated.Trevor
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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
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.

Validation of OFX TLS Certificates?

[Jeff Kletsky]

I haven't been able to find much on getting past AqBanking not verifying 
certificates for OFX connections.


https://wiki.gnucash.org/wiki/De/Setting_up_OFXDirectConnect_in_GnuCash_2 
says to "blindly" accept them, which seems risky in this day and age. I 
found a question around it asked on the list, but unanswered on 
2016-11-23, "OFX connection certificate troubles"


http://www.linuxsecurity.com/content/view/188984/102/ suggests that 
gwenhywfar was patched to "use system ca-certificates" in 2015.


Before I dig further into this, is there a way to have the certificates 
properly validated and, ideally, the revocation list checked? MacOS X 
here, but a "generic" solution as a framework would also help!


Thanks,

Jeff


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Installation on Windows 10

[David Carlson]

Can you save other documents such as spreadsheets to that folder?  Is there
plenty of free space on your C: drive (like several GIG's)? is this machine
owned by someone else such as your employer?

David C

On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email  wrote:

> David,
>
> I did create subfolder but the same error pops up.  I definetly have full
> access to the folder and subfolder.  Is there any special first time steps
> that I could be missing?
>
>
>
> *Sent:* Sunday, January 14, 2018 at 3:51 PM
> *From:* "David Carlson" 
> *To:* "Snarky Email" 
> *Cc:* "Gnucash Users" 
> *Subject:* Re: Installation on Windows 10
> Snarky,
>
> It does seem very odd that GnuCash is unable to write to that folder.  Can
> you save other documents to that folder?
>
> I would recommend creating a special subfolder for GnuCash data files as
> GnuCash will be creating a lot of temporary files in the same folder.
>
> David C
>
>
> On Jan 14, 2018 12:52 PM, "Snarky Email"  wrote:
>>
>>I installed gnucash on my Windows 10 system and the new file setup
>>fails.  I am using defaults for a new account to practice/test with.
>>When I try to save as xml I get this error:  GnuCash could not write to
>>C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be on a
>>read-only file system, or you may not have write permission for the
>>directory."
>>I do have full access on the folder.
>>Any help would be appreciated.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
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: Installation on Windows 10

[Snarky Email]

   David,

   I did create subfolder but the same error pops up.  I definetly have
   full access to the folder and subfolder.  Is there any special first
   time steps that I could be missing?



   Sent: Sunday, January 14, 2018 at 3:51 PM
   From: "David Carlson" 
   To: "Snarky Email" 
   Cc: "Gnucash Users" 
   Subject: Re: Installation on Windows 10
   Snarky,

   It does seem very odd that GnuCash is unable to write to that folder.
   Can you save other documents to that folder?

   I would recommend creating a special subfolder for GnuCash data files
   as GnuCash will be creating a lot of temporary files in the same
   folder.

   David C


   On Jan 14, 2018 12:52 PM, "Snarky Email" <[1]snarkyem...@gmx.com>
   wrote:

I installed gnucash on my Windows 10 system and the new file
 setup
fails.  I am using defaults for a new account to practice/test
 with.
When I try to save as xml I get this error:  GnuCash could not
 write to
C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may be
 on a
read-only file system, or you may not have write permission for
 the
directory."
I do have full access on the folder.
Any help would be appreciated.
 ___
 gnucash-user mailing list
 [2]gnucash-user@gnucash.org
 [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.

References

   1. mailto:snarkyem...@gmx.com
   2. mailto:gnucash-user@gnucash.org
   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Recording transactions

[Adrien Monteleone]

The first question I’d ask is where does that money collected from the Etsy 
sale go?
Does it get auto-deposited into a bank account, or do you have to transfer it 
manually? (like Paypal)

Let’s assume it’s auto-deposited. (more like a regular merchant account with a 
credit card company)

To keep some sanity, I’d also rename the parent top level ‘Income’ account to 
‘Revenue.’ Or you could add a separate top-level Revenue account as type Income 
and only put business data there. (draws or payments to your wife from the 
business would translate to a personal Income account in that case)

I’ll also for simplicity assume a product cost of $5.00.


Here’s how I’d record that transaction:


Dr. Assets:Business:Current Assets:Bank $16.32
Dr. Expenses:Business:Fees:Etsy Sale Fees   $  .76
Dr. Expenses:Business:Cost of Goods Sold$ 5.00
Cr. Revenue:Sales:Product   $10.00
Cr. Revenue:Shipping$ 6.65
Cr. Liability:Business:Sales Tax Payable$ 0.43
Cr. Assets:Current Assets:Business:Inventory$ 5.00

This shows you charged the customer $17.08.

Of that, $16.32 went into your business bank account, and 76¢ was retained by 
Etsy as a selling fee. (an expense)

The total sale was based on a $10 product, $6.65 shipping fee, and you 
collected Sales Tax on behalf of the government of 43¢.

Sales Tax is NOT income. It is money you collect in-trust for someone else. It 
was never yours.
Accumulate what you collect into a Sales Tax Payable liability account. When 
you make your payments (likely monthly) to the local jurisdictions, you balance 
that between your bank account and the Sales Tax Payable account. Sales Tax is 
NOT a business expense.

I’m also making the assumption that you charge for shipping, but pay the 
carrier separately. (perhaps weekly or monthly, even one at a time to the Post 
Office) If Etsy handles order fulfillment that’s a different story and requires 
a different approach. You could possibly treat this as a liability-payable 
similar to sales tax if the amount is calculated in real time and you know that 
is the actual shipping cost. But if you’re doing a separate shipping charge but 
might pay more or less to the carrier when actually sending it, you need to 
handle that money as revenue. (note, I help some small businesses with their 
e-commerce sites and they NEVER pay exactly what was calculated even in real 
time for shipping. The carriers always have a discrepancy)


When you pay the shipping carrier enter this transaction:

Dr. Expenses:Business:Postage
Cr. Assets:Current Assets:Bank-Business 

An Income Statement after that one transaction and you paying the shipping 
carrier, using only business accounts would look like this:

Revenue
Sales:Product   $10.00
Shipping$ 6.65
==
Total Revenue   $16.65

Cost of Goods Sold  $ 5.00

Gross Revenue   $11.65

Expenses
Fees:Etsy Sale Fees $  .76
Postage $ 6.65
==
Total Expenses  $ 7.41

==
Taxable Income  $ 4.24


Notice that Sales Tax appears no where on that statement. It is neither 
income/revenue nor an expense. It is merely pass-through money. (but the 
payable will show up on your Balance Sheet if the account is not zero when you 
run the report)

Assuming you started with only that one product in inventory and no cash on 
hand with no other liabilities, here’s what the Balance Sheet would look like 
after that sale, after paying the shipping carrier, but before remitting the 
sale tax to the government:

Assets
Business:Bank   $ 9.67
Inventory   $ 0.00
==
Total Assets$ 9.67

Liabilities
Sales Tax Payable   $  .43

Equity
Owner’s Equity  $ 9.24
==
Total Liabilities & Equity  $ 9.67



Regards,
Adrien

> On Jan 15, 2018, at 2:35 PM, sszd  wrote:
> 
> http://gnucash.1415818.n4.nabble.com/file/t377851/Sale_Sample_3.png

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Crash/Freeze on Reconcile

[Jeremy Lawrence]

Well, this is embarrassing. Turns out there was an Interest Charge dialog
box on a display that I had turned off. So upgrading to 2.6.18 fixed the
crash, and there was no freeze. Thanks for your help!

On Sat, 13 Jan 2018 at 21:51 David Carlson 
wrote:

> The Windows versions can get very slw.  Did you watch the bottom panel
> of the splash screen to see if it changes every now and then?  It can take
> several minutes with some files.
>
> David C
>
>
> On Sat, Jan 13, 2018 at 11:51 AM, Jeremy Lawrence 
> wrote:
>
>> I've been using Gnucash for years without issue, but today when trying to
>> reconcile a Liabilities account on 2.6.13 (Windows), Gnucash crashed. I
>> updated to 2.6.18 and Gnucash no longer crashes - but it becomes
>> unresponsive until I kill the process.
>>
>> There's no logs from the freezes on 2.6.18, but I have the trace logs from
>> the crashes on 2.6.13:
>>
>> * 12:29:07  CRIT  gnc_xfer_dialog_create: assertion 'to_info ==
>> NULL && from_info == NULL' failed
>> * 12:29:07  CRIT  gnc_amount_edit_gtk_entry: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gtk_widget_grab_focus: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gtk_toggle_button_set_active: assertion
>> 'GTK_IS_TOGGLE_BUTTON (toggle_button)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_set_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gtk_toggle_button_set_active: assertion
>> 'GTK_IS_TOGGLE_BUTTON (toggle_button)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_set_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gnc_amount_edit_gtk_entry: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gtk_entry_set_text: assertion 'GTK_IS_ENTRY
>> (entry)'
>> failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_amount_edit_evaluate: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gnc_amount_edit_set_amount: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gnc_amount_edit_gtk_entry: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gtk_entry_set_text: assertion 'GTK_IS_ENTRY
>> (entry)'
>> failed
>> * 12:29:07  CRIT  gnc_amount_edit_set_amount: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gnc_amount_edit_gtk_entry: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gtk_entry_set_text: assertion 'GTK_IS_ENTRY
>> (entry)'
>> failed
>> * 12:29:07  CRIT  gtk_widget_show_all: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:07  CRIT  gnc_amount_edit_set_amount: assertion 'gae !=
>> NULL' failed
>> * 12:29:07  CRIT  gtk_toggle_button_set_active: assertion
>> 'GTK_IS_TOGGLE_BUTTON (toggle_button)' failed
>> * 12:29:07  CRIT  gnc_tree_view_account_set_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:24  CRIT  gnc_xfer_dialog_create: assertion 'to_info ==
>> NULL && from_info == NULL' failed
>> * 12:29:24  CRIT  gnc_amount_edit_gtk_entry: assertion 'gae !=
>> NULL' failed
>> * 12:29:24  CRIT  gtk_widget_grab_focus: assertion 'GTK_IS_WIDGET
>> (widget)' failed
>> * 12:29:24  CRIT  gtk_toggle_button_set_active: assertion
>> 'GTK_IS_TOGGLE_BUTTON (toggle_button)' failed
>> * 12:29:24  CRIT  gnc_tree_view_account_set_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:24  CRIT  gtk_toggle_button_set_active: assertion
>> 'GTK_IS_TOGGLE_BUTTON (toggle_button)' failed
>> * 12:29:24  CRIT  gnc_tree_view_account_set_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:24  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:24  CRIT  gnc_tree_view_account_get_selected_account:
>> assertion 'GNC_IS_TREE_VIEW_ACCOUNT (view)' failed
>> * 12:29:24  CRIT  gtk_widget_set_sensitive: assertion 'GTK_IS_WIDGET
>

[MAINT] VM System upgrade tonight at 2100 EST (0200 UTC)

[Derek Atkins]

Hi,

I need to upgrade the VM system so I'd like to take it down at 2100
US/EST (0200 UTC) tonight.  I expect only ~1 hour (or less) of downtime.
I'll make a quick announcement on IRC before I start.

Please let me know if this is a problem.

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Year end issues

[Ronal B Morse]

This is what I do, but I'm only dealing with household and personal 
accounts and smallish investment portfolios. Because the statement 
closing dates for the investment and personal bank and credit accounts 
don't correspond exactly with the beginning date of the new book, 
there's always some monkey motion at the first of the year to "fix" 
opening balances or manually add transactions that were in float.


Not much work, actually, and this keeps the year's data file (and 
backups) down to a reasonable size.  Access to past data is as easy as 
opening the appropriate file (one must remember to ensure you're working 
on the correct data at the start of the next session as the autobot 
opens the last data file you uses, not the newest by date).


I understand that people using GnuCash for business purposes may be 
facing different issues and restrictions.


RBM.


On 01/15/2018 01:54 PM, Mike or Penny Novack wrote:

Let's discuss this (and possible options)

First, you need to understand what "close the books" does do and what 
is does not do. It creates a transaction (or transactions) to zero out 
income and expense accounts to equity. It does NOT remove transactions 
and so will not make your file smaller.


It sounds like what you want is something more like to was in the old 
days of books kept in BOOKS, pen and ink on paper.  What was common at 
the end of each accounting period was to close the old books and open 
new ones. The old volumes were put safely by in case they needed to be 
referenced later.


One of the advantages of software like gnucash is that it can create 
the usual reports without actually closing the books. Easy to 
reference old transactions (previous accounting periods) without 
having to "bring them back" as they would have done in the old days 
when physical books. But suppose you don't want this, you don't want 
to be seeing all those accounts that have become obsolete cluttering 
up your view, etc. Or are worried about the sheer size of the file, etc.


You CAN simulate what was done in the old days when they opened new 
books each period. This is just like when you created your gnucash 
books in the first place. You run a final Balance Sheet report which 
gives you the balances of all of the standing accounts (asset, 
liability, and equity). You create a new set of books, say by 
exporting the CoA and importing that to a new set of books (all 
accounts zero) and can delete any accounts that are obsolete. You then 
enter the initial values from the Balance Sheet << note: I never use 
the facility to create accounts with an initial value but instead with 
an opening transaction, or rather two so each is split on only one 
side >>


You of course SAVE the old file. If you at some future time want to 
look at old (prior period) transactions you simply ask gnucash to open 
THAT (saved) file instead of the one you are currently using.


Michael D Novack

PS: All of my books are small enough that I have never been tempted to 
do this. The obsolete accounts do not appear in the reports as 
furnished to the boards of the organizations because EDITED first << 
in other words, I do not expect gnucash to produce the final pretty 
version of reports. I have to edit them anyway to add annotations 
explaining and unusual entries so all the editing for "pretty print" 
etc. can be done at that time >>


___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Year end issues

[Mike or Penny Novack]

Let's discuss this (and possible options)

First, you need to understand what "close the books" does do and what is 
does not do. It creates a transaction (or transactions) to zero out 
income and expense accounts to equity. It does NOT remove transactions 
and so will not make your file smaller.


It sounds like what you want is something more like to was in the old 
days of books kept in BOOKS, pen and ink on paper.  What was common at 
the end of each accounting period was to close the old books and open 
new ones. The old volumes were put safely by in case they needed to be 
referenced later.


One of the advantages of software like gnucash is that it can create the 
usual reports without actually closing the books. Easy to reference old 
transactions (previous accounting periods) without having to "bring them 
back" as they would have done in the old days when physical books. But 
suppose you don't want this, you don't want to be seeing all those 
accounts that have become obsolete cluttering up your view, etc. Or are 
worried about the sheer size of the file, etc.


You CAN simulate what was done in the old days when they opened new 
books each period. This is just like when you created your gnucash books 
in the first place. You run a final Balance Sheet report which gives you 
the balances of all of the standing accounts (asset, liability, and 
equity). You create a new set of books, say by exporting the CoA and 
importing that to a new set of books (all accounts zero) and can delete 
any accounts that are obsolete. You then enter the initial values from 
the Balance Sheet << note: I never use the facility to create accounts 
with an initial value but instead with an opening transaction, or rather 
two so each is split on only one side >>


You of course SAVE the old file. If you at some future time want to look 
at old (prior period) transactions you simply ask gnucash to open THAT 
(saved) file instead of the one you are currently using.


Michael D Novack

PS: All of my books are small enough that I have never been tempted to 
do this. The obsolete accounts do not appear in the reports as furnished 
to the boards of the organizations because EDITED first << in other 
words, I do not expect gnucash to produce the final pretty version of 
reports. I have to edit them anyway to add annotations explaining and 
unusual entries so all the editing for "pretty print" etc. can be done 
at that time >>


___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Recording transactions

[sszd]

I’ve become very confused and am hoping someone can provide some basic help. 
I’m attempting to transition from Quicken to GnuCash.  I will be starting
from a set of accounts that I already have in Quicken, but I have no
intention of importing data from Quicken.  I’ll be obtaining balance
information from my latest statements and starting anew.  I know very little
about double entry bookkeeping, but I’ve been going through the GnuCash
documentation and I’ve already read about 90% of the tutorial and have gone
through the examples.  I’ve already begun setting up accounts for my own
GnuCash file but haven’t actually entered any data yet other than some
experimenting.  Now, let me provide a little background.  I’m going to be
tracking household expenses as well as a “very” small business that my wife
has on the side.  I do not want separate files for these two sets of
bookkeeping as sometimes monies are transferred between personal accounts
and business accounts, and I want to simplify things as much as possible. 
But I do require the ability to track our business expenses/income
separately for tax purposes.  I believe I’ve got a good handle on this with
the accounts I’ve begun to set up that I’m mimicking from my Quicken
accounts/categories.  My wife’s business is simply a shop she has on an
internet site known as Etsy.  I don’t want to deal with accounts receivable
or accounts payable.  We do not issue invoices or anything like that.  Etsy
takes care of all that.  With Quicken we had accounts and categories set up
to deal with basic sales, shipping, sales taxes, refunds, expenses, and a
few other minor things.  I’ve set up accounts for all those things we’d like
to track in GnuCash.  With all the reading and research I’ve done I thought
I was beginning to get a basic understanding on double entry bookkeeping. 
Then, I started to put some of it into practice and suddenly realized I am
just as lost as I was in the beginning.  Here’s an example of a business
sale entry as it would appear in our Quicken accounts.

 

Now here’s the same entry I’ve attempted in GnuCash.

 

The only true real physical account here is the Etsy account under Assets. 
The others are simply abstract or virtual accounts.  This method certainly
seems to breakout the expenses we’d like to track.  I would like to confirm
whether or not this is the appropriate way to do this.  Are the entries in
the appropriate Dr/Cr columns?  Is there a better or more accurate way?  I
started looking at this and got confused when I started to generate some
reports.  Then I thought, is this the correct way to represent this?  So I
tried another example where we see the total amount a customer payed and
then broke it down.  Here is that example.

 

The problem here is that it doesn’t represent the amount that was actually
deposited into the real account (Etsy).  So unless I’m missing something,
this couldn’t possible be the correct representation.  So I then tried
something that would more accurately represent the transaction.

 

The problem here is now you’re missing important information that requires
tracking (again, unless I’m missing something).  Any help that someone can
provide would be greatly appreciated.  Thanks for taking the time to look
this over and provide some constructive feedback.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Year end issues

[jeffrey black]

On 1/15/2018 10:26 AM, Jack Whyte wrote:
> Thanks Ken
>
> I wrote a reply before reading yours!
>
> The file is very large and unwieldy already - are there any limits on the
> file size?  One of the impacts is also that each time I update the file at
> least one copy is made - the folder on my MAC for December grew to >130MB.
>
> JACK
>
> On 15 January 2018 at 16:11, Ken Pyzik  wrote:
>
>> David -- Excellent point.  To expand upon it let's demonstrate this:
>>
>> At 12/31/2017 -- you have balances in all your accounts -- for brevity,
>> will just use one real simple example:
>>
>> At 12/31/2017 -  let's assume the checking account has a balance of $500.
>>   If you eliminate all 2017 transactions, the balance would be different --
>> as it would be the balance as of the end of 2016 (since the net effect of
>> all of the 2017 transactions would have been eliminated).   Now let's say
>> at the end of 2016, the balance of the checking account was $1200 (i.e., as
>> a result of all the transactions for 2017, the net effect was a -$700).
>> But you eliminated the transactions so the starting balance is now $1200 --
>> but that is not what your starting balance was on 1/1/2018.
>>
>> So, one could isolate all the 2017 transactions -- place them in 2017
>> accounts -- calculate the net effect of all of those transactions on each
>> account -- plug "net-effect-transactions" to the existing accounts with
>> contra (balancing transactions) to "other balancing / opening balances
>> adjustments account" and in effect do what you want.  But the labor to do
>> this would probably be more than just doing as David has said -- start a
>> new file for 2018.
>>
>> Finally, if you really want to isolate 2017 - you could set up "checking
>> account-2017 " and then another "checking account -2018' as 2 separate
>> accounts and start charging the new expenses, etc. to the new 2018
>> account.  But again - this has a tendency to double all your accounts.
>> That is why the reporting mechanism in there.   You can have continuous
>> accounts, and isolate, for reporting, a number of transactions for any
>> given period (a month, a year, a calendar year, a fiscal year, a 6-30 to
>> 6-30 time period, etc.)
>>
>> Hope that helps and did not confuse the subject.
>>
>>
>> -Original Message-
>> From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org]
>> On Behalf Of David T. via gnucash-user
>> Sent: Monday, January 15, 2018 7:39 AM
>> To: Jack Whyte 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: Year end issues
>>
>> No, there isn’t. The Close book feature simply creates a transaction that
>> zeroes out your income and expense accounts as of a given date.
>>
>> In a double entry accounting system, if you delete the expense side of the
>> transaction, what do you suggest doing for the Checking account side? If
>> you are desperate to clear out older transactions, you will most likely
>> have to create a new file with a new set of opening balances. See
>> https://wiki.gnucash.org/wiki/Closing_Books > wiki/Closing_Books>
>>
>> Of course, many people prefer to keep historical transactions, and use
>> reports to extract subsets of their file as needed.
>>
>> David
>>
>>> On Jan 15, 2018, at 8:03 PM, Jack Whyte  wrote:
>>>
>>> Hi there
>>>
>>> I have used GNU Cash for a number of years to monitor my personal
>> finances.   I have just run the Tools > Close book function to clear down
>> all my expense & income account balances as at 31/12/17 however I seem to
>> have transactions in all of these accounts going back, in some cases, to
>> 2009/2010.
>>> Can someone please advise me if there is a straightforward mechanism to
>> delete all transactions in these accounts - say, up to and including
>> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will
>> become unwieldy and unmanageable.
>>> Thanks & regards
>>> Jack
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> 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
>> 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
> 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.

Jack:

I vaguely remember an answer to your question about file size from one 
of the team of developers.  If I remember correctly it is only limited 
by the OS, memory, and drive size.

At this time I would

Re: Year end issues

[Maf. King]

On Monday, 15 January 2018 15:03:33 GMT Jack Whyte wrote:
> I am concerned the file, currently at around 1.3MB, will
> become unwieldy and unmanageable.
> 
> Thanks & regards
> Jack


Hi Jack,

My business data file is around the 25 MB mark at the moment, my personal file 
is more like 5.6MB, so you are not about to hit a file size limit.

HTH,
Maf.
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: NUM Column Defaults

[David Carlson]

I suspect that it is not easy to have both auto increment and auto fill at
the same time.  You can still ask.

David C

On Jan 15, 2018 11:18 AM, "Jack Slater"  wrote:

> Is there a place/method I should use to request?
>
> > On Jan 15, 2018, at 11:12 AM, Kenneth Schneider <
> kschnei...@bout-tyme.net> wrote:
> >
> > Auto fill is not enabled for the NUM column. Maybe a feature request
> would get it added in a future release.
> >
> > Ken Schneider
> >
> >> On Jan 15, 2018, at 12:04 PM, Jack Slater 
> wrote:
> >>
> >> I was hoping AutoFill was an option as well but it’s not seeming to
> remember what I’ve typed.
> >>
> >>> On Jan 15, 2018, at 10:53 AM, Derek Atkins  wrote:
> >>>
> >>> Hi,
> >>>
> >>> Jack Slater  writes:
> >>>
>  Is it possible to create/save default NUM items such as:
> 
>  EFT (electronic funds transfer)
>  DEP (deposit)
>  TRN (transfer)
>  ATM (auto teller machine)
>  And a simple free form text entry (this would allow for sequenced
> check
>  number entries)
> >>>
> >>> The Num column is a text entry, so you could put these in.  I don't
> know
> >>> if there is an autofill for that particular column, but I *think* there
> >>> is -- which means once you enter an EFT in there in an account, it can
> >>> autofill that in future transaction entries.
> >>>
> >>> (If there is not an autofill for that column then I'm afraid you'll
> have
> >>> to type it in every time).
> >>>
>  Please remember to CC this list on all your replies.
>  You can do this by using Reply-To-List or Reply-All.
> >>>
> >>> -derek
> >>>
> >>> --
> >>> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>> Member, MIT Student Information Processing Board  (SIPB)
> >>> URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
> >>> warl...@mit.eduPGP key available
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> 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
> 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
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.

Where Does GnuCash store exchange rates

[Ilan Sebba]

Hello

I hope this is the right forum/email address to ask questions. This is the
first time I am posting a question on GnuCash.


My question is: where does GnuCash store exchange rates for balance sheet
items, where the balance sheet items have two (or more) currencies? I will
illustrate my problem with an example.

I have an account say MyAsset (in USD), with a MyAssetSubAccount (in GBP).
GnuCash gives me the total value of MyAsset, in USD. That is, GnuCash takes
the value of MyAssetSubAccount (in GBP) and converts it to USD, and adds
this USD amount to MyAsset.

When I enter the value of the MyAssetSubAccount (in GBP) I do not get an
opportunity to enter the appropriate exchange rate. That is because I am
entering a GBP value into an account expecting a value in GBP. So there is
no exchange rate to convert.  Also, with time, the exchange rate
fluctuates, and the value of MyAsset (in USD) changes. This is because the
value of MyAssetSubAccount, when measured in USD changes on a daily basis.

When I generate a balance sheet on a given date, GnuCash must convert
MyAssetSubAccount to USD using the exchange rate on the balance sheet date.

In doing that conversion, what exchange rate does GnuCash use, and where
does it store that exchange rate? Can I enter these exchange rates
manually? If so, where? I am new to GnuCash so please give detailed
instructions.

Best regards
Ilan
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Correcting Opening Balances

[Richard Claeys]

Thank you for the responses to date.  I will work on the bank accounts
first, then go back to the manual for direction before turning to investment
accounts.

Here is an example of what I am encountering:  One of the accounts that
popped up after the conversion from Quicken is a credit card that I dropped
in 1998; when I click on "Delete Account" I receive a response along the
lines of "Do you want to combine this with credit card ?"  Apparently
the double-entry accounting doesn't allow me to simply dispose of accounts
that no longer exist.

And as mentioned before, both our bank accounts are inflated by a factor of
10.  Can I just go back to January 1, 2018 and enter a fresh Opening Balance
that matches our printed statements?  Or is there another way to reset
balances without reinstalling and starting from scratch?

I will be out of town a few days and will not be working on cleaning up
GnuCash until next week, so no rushbut I could sure use some help in
getting the program in sync with our actual financial statements.

Thanks again,

Richard Claeys

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+rclaeys=accesscom@gnucash.org] On Behalf Of
Mike or Penny Novack
Sent: Sunday, January 14, 2018 5:33 AM
To: gnucash-user@gnucash.org
Subject: Re: Correcting Opening Balances

On 1/13/2018 5:17 PM, David Carlson wrote:
> Did you check the transactions as you imported them to weed out 
> duplicates and correct errors?
>
> If not, I would suggest starting over to get at least reasonably close 
> to a good starting point.
Also, this is a case where the solution to the problem more obvious if you
understand what "opening balance" is doing, how you would be doing that if
setting up your books manually (hand creating the opening TRANSACTIONs), and
the proper/formal method of correcting "errors" and omissions << entering a
correcting transaction instead of editing an existing one>>

If you are going to import from another system, run a Balance Sheet (of that
other system) as of the date you will be using for the import. That will
show you what the opening values SHOULD be.

Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Year end issues

[Ken Pyzik]

Jack - - Not sure on the size constraints – someone else can maybe answer. 

 

With respect to getting it down to a manageable size – I can only speak from my 
experience.  When I transferred over from Quicken, I had transactions dating 
back to 2003.  Bringing them all over was messy.  But I did it on a test basis. 
 So, I was able to start over rather easily. 

When instead, I transferred over only from 2014 and forward, it still was not 
clean.  

 

So, what I finally decided to do was transfer over everything – and then 
eliminated all transactions I did not want “in mass”.  But before I did that – 
I noted what the beginning balances were for specific accounts BEFORE 
eliminating the transactions, plugged them in as the opening balances in a 
separate account and then started eliminating.  Interesting, the best part 
about GNU-CASH is that it has an automatic “imbalance” account that accumulates 
all the “out-of-balance” situations.  When I was finally done, I made sure 
everything was in balance – altered the opening balances according – and I was 
where I wanted to be.  

 

This may or may not work for you.  There is a little bit of trial and error 
involved.  The best thing to do is to make a backup copy – and work on it until 
you get it the way you like.  If you screw up – no biggie – you still have your 
production version.  When the test is finally the way you want it – enter any 
current transactions – rename the production file something new – and then go 
and rename the test account to the production name and make it your production 
going forward.  That’s what worked for me – and it worked like a charm in 
eliminating 9 years of data.  Good luck! 

 

 

From: johnv.wh...@gmail.com [mailto:johnv.wh...@gmail.com] On Behalf Of Jack 
Whyte
Sent: Monday, January 15, 2018 8:27 AM
To: Ken Pyzik 
Cc: David T. ; Gnucash Users 
Subject: Re: Year end issues

 

Thanks Ken

I wrote a reply before reading yours!

The file is very large and unwieldy already - are there any limits on the file 
size?  One of the impacts is also that each time I update the file at least one 
copy is made - the folder on my MAC for December grew to >130MB.

JACK

 

On 15 January 2018 at 16:11, Ken Pyzik mailto:py...@cox.net> > 
wrote:

David -- Excellent point.  To expand upon it let's demonstrate this:

At 12/31/2017 -- you have balances in all your accounts -- for brevity, will 
just use one real simple example:

At 12/31/2017 -  let's assume the checking account has a balance of $500.   If 
you eliminate all 2017 transactions, the balance would be different -- as it 
would be the balance as of the end of 2016 (since the net effect of all of the 
2017 transactions would have been eliminated).   Now let's say at the end of 
2016, the balance of the checking account was $1200 (i.e., as a result of all 
the transactions for 2017, the net effect was a -$700).  But you eliminated the 
transactions so the starting balance is now $1200 -- but that is not what your 
starting balance was on 1/1/2018.

So, one could isolate all the 2017 transactions -- place them in 2017 accounts 
-- calculate the net effect of all of those transactions on each account -- 
plug "net-effect-transactions" to the existing accounts with contra (balancing 
transactions) to "other balancing / opening balances adjustments account" and 
in effect do what you want.  But the labor to do this would probably be more 
than just doing as David has said -- start a new file for 2018.

Finally, if you really want to isolate 2017 - you could set up "checking 
account-2017 " and then another "checking account -2018' as 2 separate accounts 
and start charging the new expenses, etc. to the new 2018 account.  But again - 
this has a tendency to double all your accounts.  That is why the reporting 
mechanism in there.   You can have continuous accounts, and isolate, for 
reporting, a number of transactions for any given period (a month, a year, a 
calendar year, a fiscal year, a 6-30 to 6-30 time period, etc.)

Hope that helps and did not confuse the subject.


-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01 
 =cox@gnucash.org 
 ] On Behalf Of David T. via gnucash-user
Sent: Monday, January 15, 2018 7:39 AM
To: Jack Whyte mailto:jvwh...@gmail.com> >
Cc: gnucash-user@gnucash.org  
Subject: Re: Year end issues

No, there isn’t. The Close book feature simply creates a transaction that 
zeroes out your income and expense accounts as of a given date.

In a double entry accounting system, if you delete the expense side of the 
transaction, what do you suggest doing for the Checking account side? If you 
are desperate to clear out older transactions, you will most likely have to 
create a new file with a new set of opening balances. See 
https://wiki.gnucash.org/wiki/Closing_Books 


Of course, ma

Re: NUM Column Defaults

[Jack Slater]

Is there a place/method I should use to request?

> On Jan 15, 2018, at 11:12 AM, Kenneth Schneider  
> wrote:
> 
> Auto fill is not enabled for the NUM column. Maybe a feature request would 
> get it added in a future release.
> 
> Ken Schneider 
> 
>> On Jan 15, 2018, at 12:04 PM, Jack Slater  wrote:
>> 
>> I was hoping AutoFill was an option as well but it’s not seeming to remember 
>> what I’ve typed. 
>> 
>>> On Jan 15, 2018, at 10:53 AM, Derek Atkins  wrote:
>>> 
>>> Hi,
>>> 
>>> Jack Slater  writes:
>>> 
 Is it possible to create/save default NUM items such as:
 
 EFT (electronic funds transfer)
 DEP (deposit)
 TRN (transfer)
 ATM (auto teller machine)
 And a simple free form text entry (this would allow for sequenced check
 number entries)
>>> 
>>> The Num column is a text entry, so you could put these in.  I don't know
>>> if there is an autofill for that particular column, but I *think* there
>>> is -- which means once you enter an EFT in there in an account, it can
>>> autofill that in future transaction entries.
>>> 
>>> (If there is not an autofill for that column then I'm afraid you'll have
>>> to type it in every time).
>>> 
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.
>>> 
>>> -derek
>>> 
>>> -- 
>>> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>> Member, MIT Student Information Processing Board  (SIPB)
>>> URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>> warl...@mit.eduPGP key available
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
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: NUM Column Defaults

[Kenneth Schneider]

Auto fill is not enabled for the NUM column. Maybe a feature request would get 
it added in a future release.

Ken Schneider 

> On Jan 15, 2018, at 12:04 PM, Jack Slater  wrote:
> 
> I was hoping AutoFill was an option as well but it’s not seeming to remember 
> what I’ve typed. 
> 
>> On Jan 15, 2018, at 10:53 AM, Derek Atkins  wrote:
>> 
>> Hi,
>> 
>> Jack Slater  writes:
>> 
>>> Is it possible to create/save default NUM items such as:
>>> 
>>> EFT (electronic funds transfer)
>>> DEP (deposit)
>>> TRN (transfer)
>>> ATM (auto teller machine)
>>> And a simple free form text entry (this would allow for sequenced check
>>> number entries)
>> 
>> The Num column is a text entry, so you could put these in.  I don't know
>> if there is an autofill for that particular column, but I *think* there
>> is -- which means once you enter an EFT in there in an account, it can
>> autofill that in future transaction entries.
>> 
>> (If there is not an autofill for that column then I'm afraid you'll have
>> to type it in every time).
>> 
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> -derek
>> 
>> -- 
>>  Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>  Member, MIT Student Information Processing Board  (SIPB)
>>  URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>>  warl...@mit.eduPGP key available
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: NUM Column Defaults

[Jack Slater]

I was hoping AutoFill was an option as well but it’s not seeming to remember 
what I’ve typed. 

> On Jan 15, 2018, at 10:53 AM, Derek Atkins  wrote:
> 
> Hi,
> 
> Jack Slater  writes:
> 
>> Is it possible to create/save default NUM items such as:
>> 
>> EFT (electronic funds transfer)
>> DEP (deposit)
>> TRN (transfer)
>> ATM (auto teller machine)
>> And a simple free form text entry (this would allow for sequenced check
>> number entries)
> 
> The Num column is a text entry, so you could put these in.  I don't know
> if there is an autofill for that particular column, but I *think* there
> is -- which means once you enter an EFT in there in an account, it can
> autofill that in future transaction entries.
> 
> (If there is not an autofill for that column then I'm afraid you'll have
> to type it in every time).
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: [GNUCASH] Commas on graph

[Irving Duran]

Hi David,
Yes, that is exactly what I am referring to and yes, that is what I have
noticed as well :).

Adrien - I took a look, but still no commas in my graphs :(.  Maybe this
could be a feature request, but for now I can keep surviving without it :)
- it would just be a nice to have.


Thank You,

Irving Duran

On Fri, Jan 12, 2018 at 8:50 AM, David Carlson 
wrote:

> Irving,
>
> If you are referring to the values on the Ordinate axis of a graph produced
> by GnuCash, you are quite observant.  There are no thousands separators in
> values displayed.  Everywhere else, as far as I know, there are thousands
> separators.
>
> I suspect that the reason lies in the graphic code used by GnuCash for that
> function, but since I am not a programmer, I do not know why this exception
> exists.
>
> David C
>
> On Fri, Jan 12, 2018 at 6:59 AM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
>
> > I normally use a Mac, but I just opened my file in a Ubuntu Xenial
> virtual
> > machine and ran a report. It shows comma separators.
> >
> > Check your OS system settings under Language. Make sure the local is set
> > for US and check the currency example at the bottom of the window.
> (second
> > tab) It should show commas and a decimal with two places.
> >
> > If that all checks-out I’m stumped.
> >
> > Regards,
> > Adrien
> >
> > > On Jan 11, 2018, at 8:07 PM, Irving Duran 
> > wrote:
> > >
> > > Hi Adrien,
> > >
> > > Yes, that is what I meant and Thanks for the info.  I looked on my
> > > settings under... "locales" (en_US.UTF-8) and GnuCash "Reports" and
> > > "Accounts" under "Preferences" and they are set as "USD (US Dollar)",
> > > but there are no commas separator on the graphs.  I am on Ubuntu 16.04
> > LTS.
> > >
> > > Any thoughts?
> > >
> > > Thank you,
> > >
> > > Irving Duran
> > >
> > > On 01/09/2018 05:24 PM, Adrien Monteleone wrote:
> > >> If you mean you want to see commas as a thousands separator, that is
> > dependent on currency/locale I should think. I have mine set to US
> > Dollar/US. I don’t see any setting for that display in particular, but
> this
> > option does exist in my OS locale settings.
> > >>
> > >> All reports I run that are over $1,000.00 show a thousands separator.
> > >>
> > >> If you want to use commas as a decimal separator, then you’ll have to
> > set the appropriate currency/locale.
> > >>
> > >> Regards,
> > >> Adrien
> > >>
> > >>> On Jan 9, 2018, at 2:17 PM, Irving Duran 
> > wrote:
> > >>>
> > >>> Is there a way to place commas on the income vs. expense report graph
> > >>> without having to build a special report?
> > >>>
> > >>> Thanks!
> > >>>
> > >>> Irving
> > >>>
> > >>>
> > >>> --
> > >>> Thank You,
> > >>>
> > >>> Irving Duran
> > >>> ___
> > >>> gnucash-user mailing list
> > >>> gnucash-user@gnucash.org
> > >>> 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
> > >> 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
> > 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
> 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
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: NUM Column Defaults

[Derek Atkins]

Hi,

Jack Slater  writes:

> Is it possible to create/save default NUM items such as:
>
> EFT (electronic funds transfer)
> DEP (deposit)
> TRN (transfer)
> ATM (auto teller machine)
> And a simple free form text entry (this would allow for sequenced check
> number entries)

The Num column is a text entry, so you could put these in.  I don't know
if there is an autofill for that particular column, but I *think* there
is -- which means once you enter an EFT in there in an account, it can
autofill that in future transaction entries.

(If there is not an autofill for that column then I'm afraid you'll have
to type it in every time).

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Invoices: multilingual & tax detail questions

[Derek Atkins]

Hi,

Macho Philipovich  writes:

> Dear fellow Gnucash users,
>
> I have two questions about invoices.
>
> First, I deal with some of my clients in French, some in English. I'd
> like to be able to provide invoices in either language. Gnucash reports
> generally allow me to edit all of the headings in the options menu and
> then save the report configuration, which is helpful, but is there a way
> that I can switch the display to use the French style for currency
> amounts, i.e. use a comma instead of period to indicate cents, and show
> the dollar sign after the amount instead of before?

Unfortunately the report translation is based on your system locale.  If
you are running GnuCash in English, your reports will be in English.  To
get reports in French you will need to change your locale and run
GnuCash in French.  Note that this will NOT translate any data
entries.  If your data is in English (including Account Names, etc) then
that will NOT get translated in a report.

The same is true for decimal and thousands separators -- it's based on
your locale.

> Second, in Quebec we have to charge two VAT taxes (federal GST and
> provincial QST), and my understanding is that the authorities prefer
> that we show the calculation of those taxes separately on invoices and
> that we provide customers with our registration numbers for each tax as
> part of the invoice, so that they can provide them when claiming those
> taxes back if need be. Is there any way to separate the two VAT taxes
> within the invoice? Currently I've just added a note explaining this and
> providing the registration numbers in the notes/terms part of the
> invoice, but I wonder if there isn't a better way.

Of course.  Set a tax table with two entries (one for GST, one for PST)
and when you print the invoice select the "show individual taxes" option
(which may be called something else, but that's the gist of the option).

> Thanks, as always,
>
> Macho

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Year end issues

[Jack Whyte]

Thanks Ken

I wrote a reply before reading yours!

The file is very large and unwieldy already - are there any limits on the
file size?  One of the impacts is also that each time I update the file at
least one copy is made - the folder on my MAC for December grew to >130MB.

JACK

On 15 January 2018 at 16:11, Ken Pyzik  wrote:

> David -- Excellent point.  To expand upon it let's demonstrate this:
>
> At 12/31/2017 -- you have balances in all your accounts -- for brevity,
> will just use one real simple example:
>
> At 12/31/2017 -  let's assume the checking account has a balance of $500.
>  If you eliminate all 2017 transactions, the balance would be different --
> as it would be the balance as of the end of 2016 (since the net effect of
> all of the 2017 transactions would have been eliminated).   Now let's say
> at the end of 2016, the balance of the checking account was $1200 (i.e., as
> a result of all the transactions for 2017, the net effect was a -$700).
> But you eliminated the transactions so the starting balance is now $1200 --
> but that is not what your starting balance was on 1/1/2018.
>
> So, one could isolate all the 2017 transactions -- place them in 2017
> accounts -- calculate the net effect of all of those transactions on each
> account -- plug "net-effect-transactions" to the existing accounts with
> contra (balancing transactions) to "other balancing / opening balances
> adjustments account" and in effect do what you want.  But the labor to do
> this would probably be more than just doing as David has said -- start a
> new file for 2018.
>
> Finally, if you really want to isolate 2017 - you could set up "checking
> account-2017 " and then another "checking account -2018' as 2 separate
> accounts and start charging the new expenses, etc. to the new 2018
> account.  But again - this has a tendency to double all your accounts.
> That is why the reporting mechanism in there.   You can have continuous
> accounts, and isolate, for reporting, a number of transactions for any
> given period (a month, a year, a calendar year, a fiscal year, a 6-30 to
> 6-30 time period, etc.)
>
> Hope that helps and did not confuse the subject.
>
>
> -Original Message-
> From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org]
> On Behalf Of David T. via gnucash-user
> Sent: Monday, January 15, 2018 7:39 AM
> To: Jack Whyte 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Year end issues
>
> No, there isn’t. The Close book feature simply creates a transaction that
> zeroes out your income and expense accounts as of a given date.
>
> In a double entry accounting system, if you delete the expense side of the
> transaction, what do you suggest doing for the Checking account side? If
> you are desperate to clear out older transactions, you will most likely
> have to create a new file with a new set of opening balances. See
> https://wiki.gnucash.org/wiki/Closing_Books  wiki/Closing_Books>
>
> Of course, many people prefer to keep historical transactions, and use
> reports to extract subsets of their file as needed.
>
> David
>
> > On Jan 15, 2018, at 8:03 PM, Jack Whyte  wrote:
> >
> > Hi there
> >
> > I have used GNU Cash for a number of years to monitor my personal
> finances.   I have just run the Tools > Close book function to clear down
> all my expense & income account balances as at 31/12/17 however I seem to
> have transactions in all of these accounts going back, in some cases, to
> 2009/2010.
> >
> > Can someone please advise me if there is a straightforward mechanism to
> delete all transactions in these accounts - say, up to and including
> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will
> become unwieldy and unmanageable.
> >
> > Thanks & regards
> > Jack
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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
> 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
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: Year end issues

[Jack Whyte]

Thanks David

Yes but as it’s a double entry system, the net effect of deleting a year’s
worth of transactions in an account where close book has been applied
should be nil so the Checking account should not be effected?

Am I missing something?

It could be a bit laborious deleting all these transactions but if the net
effect is zero I should be ok.

Perhaps I’ll give it a try with a couple of accounts + report back.

Jack

On 15 January 2018 at 15:38, David T.  wrote:

> No, there isn’t. The Close book feature simply creates a transaction that
> zeroes out your income and expense accounts as of a given date.
>
> In a double entry accounting system, if you delete the expense side of the
> transaction, what do you suggest doing for the Checking account side? If
> you are desperate to clear out older transactions, you will most likely
> have to create a new file with a new set of opening balances. See
> https://wiki.gnucash.org/wiki/Closing_Books
>
> Of course, many people prefer to keep historical transactions, and use
> reports to extract subsets of their file as needed.
>
> David
>
> On Jan 15, 2018, at 8:03 PM, Jack Whyte  wrote:
>
> Hi there
>
> I have used GNU Cash for a number of years to monitor my personal
> finances.   I have just run the Tools > Close book function to clear down
> all my expense & income account balances as at 31/12/17 however I seem to
> have transactions in all of these accounts going back, in some cases, to
> 2009/2010.
>
> Can someone please advise me if there is a straightforward mechanism to
> delete all transactions in these accounts - say, up to and including
> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will
> become unwieldy and unmanageable.
>
> Thanks & regards
> Jack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Year end issues

[Ken Pyzik]

David -- Excellent point.  To expand upon it let's demonstrate this: 

At 12/31/2017 -- you have balances in all your accounts -- for brevity, will 
just use one real simple example: 

At 12/31/2017 -  let's assume the checking account has a balance of $500.   If 
you eliminate all 2017 transactions, the balance would be different -- as it 
would be the balance as of the end of 2016 (since the net effect of all of the 
2017 transactions would have been eliminated).   Now let's say at the end of 
2016, the balance of the checking account was $1200 (i.e., as a result of all 
the transactions for 2017, the net effect was a -$700).  But you eliminated the 
transactions so the starting balance is now $1200 -- but that is not what your 
starting balance was on 1/1/2018.

So, one could isolate all the 2017 transactions -- place them in 2017 accounts 
-- calculate the net effect of all of those transactions on each account -- 
plug "net-effect-transactions" to the existing accounts with contra (balancing 
transactions) to "other balancing / opening balances adjustments account" and 
in effect do what you want.  But the labor to do this would probably be more 
than just doing as David has said -- start a new file for 2018.  

Finally, if you really want to isolate 2017 - you could set up "checking 
account-2017 " and then another "checking account -2018' as 2 separate accounts 
and start charging the new expenses, etc. to the new 2018 account.  But again - 
this has a tendency to double all your accounts.  That is why the reporting 
mechanism in there.   You can have continuous accounts, and isolate, for 
reporting, a number of transactions for any given period (a month, a year, a 
calendar year, a fiscal year, a 6-30 to 6-30 time period, etc.)

Hope that helps and did not confuse the subject. 


-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org] On 
Behalf Of David T. via gnucash-user
Sent: Monday, January 15, 2018 7:39 AM
To: Jack Whyte 
Cc: gnucash-user@gnucash.org
Subject: Re: Year end issues

No, there isn’t. The Close book feature simply creates a transaction that 
zeroes out your income and expense accounts as of a given date.

In a double entry accounting system, if you delete the expense side of the 
transaction, what do you suggest doing for the Checking account side? If you 
are desperate to clear out older transactions, you will most likely have to 
create a new file with a new set of opening balances. See 
https://wiki.gnucash.org/wiki/Closing_Books 


Of course, many people prefer to keep historical transactions, and use reports 
to extract subsets of their file as needed.

David

> On Jan 15, 2018, at 8:03 PM, Jack Whyte  wrote:
> 
> Hi there
> 
> I have used GNU Cash for a number of years to monitor my personal finances.   
> I have just run the Tools > Close book function to clear down all my expense 
> & income account balances as at 31/12/17 however I seem to have transactions 
> in all of these accounts going back, in some cases, to 2009/2010.
> 
> Can someone please advise me if there is a straightforward mechanism to 
> delete all transactions in these accounts - say, up to and including 
> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will become 
> unwieldy and unmanageable.
> 
> Thanks & regards
> Jack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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
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: Year end issues

[David T. via gnucash-user]

No, there isn’t. The Close book feature simply creates a transaction that 
zeroes out your income and expense accounts as of a given date.

In a double entry accounting system, if you delete the expense side of the 
transaction, what do you suggest doing for the Checking account side? If you 
are desperate to clear out older transactions, you will most likely have to 
create a new file with a new set of opening balances. See 
https://wiki.gnucash.org/wiki/Closing_Books 


Of course, many people prefer to keep historical transactions, and use reports 
to extract subsets of their file as needed.

David

> On Jan 15, 2018, at 8:03 PM, Jack Whyte  wrote:
> 
> Hi there
> 
> I have used GNU Cash for a number of years to monitor my personal finances.   
> I have just run the Tools > Close book function to clear down all my expense 
> & income account balances as at 31/12/17 however I seem to have transactions 
> in all of these accounts going back, in some cases, to 2009/2010.
> 
> Can someone please advise me if there is a straightforward mechanism to 
> delete all transactions in these accounts - say, up to and including 
> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will become 
> unwieldy and unmanageable.
> 
> Thanks & regards
> Jack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Year end issues

[Jack Slater]

I was about to ask the same question! Thanks.

On Mon, Jan 15, 2018 at 9:03 AM, Jack Whyte  wrote:

> Hi there
>
> I have used GNU Cash for a number of years to monitor my personal
> finances.   I have just run the Tools > Close book function to clear down
> all my expense & income account balances as at 31/12/17 however I seem to
> have transactions in all of these accounts going back, in some cases, to
> 2009/2010.
>
> Can someone please advise me if there is a straightforward mechanism to
> delete all transactions in these accounts - say, up to and including
> 31/12/2016 as I am concerned the file, currently at around 1.3MB, will
> become unwieldy and unmanageable.
>
> Thanks & regards
> Jack
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

Year end issues

[Jack Whyte]

Hi there

I have used GNU Cash for a number of years to monitor my personal finances.   I 
have just run the Tools > Close book function to clear down all my expense & 
income account balances as at 31/12/17 however I seem to have transactions in 
all of these accounts going back, in some cases, to 2009/2010.

Can someone please advise me if there is a straightforward mechanism to delete 
all transactions in these accounts - say, up to and including 31/12/2016 as I 
am concerned the file, currently at around 1.3MB, will become unwieldy and 
unmanageable.

Thanks & regards
Jack
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.