Re: [GNC] best accounting practice for refund

[Adrien Monteleone]

You’re welcome. Glad to help any time.

> On Jul 4, 2019, at 12:50 AM, Eric Rathhaus (general)  
> wrote:
> 
> Thanks, Adrien for your assistance and patience.  
> 
>> On Jul 3, 2019, at 10:35 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Short answer — yes.
>> 
>> Slightly longer answer — figure out what caused that to happen, undo it, and 
>> then redo the payment properly.
>> 
>> The reason for doing so rather than just creating a correcting entry is so 
>> that you learn what went wrong and don’t repeat the same situation in the 
>> future. (you’d also need to make good notations in the correcting entry so 
>> that far in the future, you don’t question why it is there)
>> 
>> I’d suspect that you chose the liability account as a source account like 
>> you’d choose some asset account. You don’t need to select an account when 
>> doing an offset.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jul 4, 2019, at 12:04 AM, Eric Rathhaus (general) 
>>>  wrote:
>>> 
>>> So I did assign the credit note to the AR account and then processed two 
>>> payments by selecting the posted invoices and the credit note all in the AR 
>>> account.  I didn’t do anything else but somehow the remaining balance of 
>>> the credit note ended up in a liability account. Should I just move it back 
>>> to the AR account to keep it simple?  
>>> 
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 


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

Re: [GNC] best accounting practice for refund

[Eric Rathhaus (general) via gnucash-user]

Thanks, Adrien for your assistance and patience.  

> On Jul 3, 2019, at 10:35 PM, Adrien Monteleone 
>  wrote:
> 
> Short answer — yes.
> 
> Slightly longer answer — figure out what caused that to happen, undo it, and 
> then redo the payment properly.
> 
> The reason for doing so rather than just creating a correcting entry is so 
> that you learn what went wrong and don’t repeat the same situation in the 
> future. (you’d also need to make good notations in the correcting entry so 
> that far in the future, you don’t question why it is there)
> 
> I’d suspect that you chose the liability account as a source account like 
> you’d choose some asset account. You don’t need to select an account when 
> doing an offset.
> 
> Regards,
> Adrien
> 
>> On Jul 4, 2019, at 12:04 AM, Eric Rathhaus (general) 
>>  wrote:
>> 
>> So I did assign the credit note to the AR account and then processed two 
>> payments by selecting the posted invoices and the credit note all in the AR 
>> account.  I didn’t do anything else but somehow the remaining balance of the 
>> credit note ended up in a liability account. Should I just move it back to 
>> the AR account to keep it simple?  
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] How do I double check scheduled transactions?

[ToddAndMargo via gnucash-user]

On 7/3/19 9:04 PM, David Carlson wrote:
Read Chapter 6 section 6.12 of the help manual.  If you have any further 
questions please ask.


David Carlson


Hi David,

Ah Ha!  It was the edit button I was missing.  I had presumed
that it was a floating windows and that the buttons were from
the prior menu and inactive as they were inactive until I
clicked on a transaction.

Thank you!

-T


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

Re: [GNC] Change a batch of transactions from income to Expense

[David Cousens]

If you post it again but Select View->Transaction Journal it will expand the
transaction splits so we can better see what is happening on import.  Might
also help to be able to see one or two records of the CSV file.Cheers

David Cousens



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

Re: [GNC] best accounting practice for refund

[Adrien Monteleone]

Short answer — yes.

Slightly longer answer — figure out what caused that to happen, undo it, and 
then redo the payment properly.

The reason for doing so rather than just creating a correcting entry is so that 
you learn what went wrong and don’t repeat the same situation in the future. 
(you’d also need to make good notations in the correcting entry so that far in 
the future, you don’t question why it is there)

I’d suspect that you chose the liability account as a source account like you’d 
choose some asset account. You don’t need to select an account when doing an 
offset.

Regards,
Adrien

> On Jul 4, 2019, at 12:04 AM, Eric Rathhaus (general)  
> wrote:
> 
> So I did assign the credit note to the AR account and then processed two 
> payments by selecting the posted invoices and the credit note all in the AR 
> account.  I didn’t do anything else but somehow the remaining balance of the 
> credit note ended up in a liability account. Should I just move it back to 
> the AR account to keep it simple?  
> 


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

Re: [GNC] best accounting practice for refund

[Eric Rathhaus (general) via gnucash-user]

So I did assign the credit note to the AR account and then processed two 
payments by selecting the posted invoices and the credit note all in the AR 
account.  I didn’t do anything else but somehow the remaining balance of the 
credit note ended up in a liability account. Should I just move it back to the 
AR account to keep it simple?  

> On Jul 3, 2019, at 10:58 AM, Adrien Monteleone 
>  wrote:
> 
> If you didn’t involve a liability account initially, the remaining credit on 
> the credit note would sit in AR. But if you ‘paid’ the credit note with a 
> liability, you transferred that amount from AR to the liability, which is the 
> account you will ‘pay’ future invoices from when offsetting with the credit.
> 
> Be mindful that the credit note should have been posted to AR initially.
> 
> Also that the credit note’s line items should have all been assigned to some 
> income account, NOT a liability account. You want to decrease your income 
> accounts with a credit note that the original invoice(s) increased. Not sure 
> I follow u here. The first transaction was an invoice and payment to the 
> business checking account. Now part of that payment is the credit note.  I 
> assumed that paying the invoices in the AR account with the credit note is a 
> reduction of an income account.  
> 
> Here’s a simplified transaction walk through:
> 
> 
> Original Invoice
> -
> Dr. Accounts Receivable   $1000
>   Cr. Income  $1000
> 
> 
> Original Payment by check
> -
> Dr. Undeposited funds $1000
>   Cr. Accounts Receivable $1000
> 
> 
> Depositing of check
> -
> Dr. Checking  $1000
>   Cr. Undeposited Funds   $1000
> 
> 
> Issuance of Credit Note
> -
> Dr. Income$100
>   Cr. Accounts Receivable $100
> 
> 
> IF you ‘pay’ (transfer) the credit note with a liability account
> -
> Dr. Accounts Receivable   $100
>   Cr. Customer Deposits   $100
> 
> 
> When you offset a future invoice with the liability
> -
> Dr. Customer Deposits $100
>   Cr. Accounts Receivable $100
> 
> 
> OR if you don’t involve a liability account at all, offsetting a future 
> invoice
> -
> Dr. Accounts Receivable   $100
>   Cr. Accounts Receivable $100
> 
> (in this case the money doesn’t move accounts, but gets ‘assigned’ to a 
> different document, from the credit note to the invoice)
> 
> Regards,
> Adrien
> 
>> On Jul 3, 2019, at 12:15 AM, Eric Rathhaus (general) 
>>  wrote:
>> 
>> Hi again - so everything worked the first time.  I back off all the 
>> transactions and put the credit note in the AR account, selected two 
>> invoices and the credit note , credit note reduced by that amount and the 
>> payments showed.  But I need to run another offset and the credit note no 
>> longer appears in the AR account.  The system moved it to a liabilities 
>> account and automatically opens the liabilities account when processing a 
>> payment for that company.  Is this how it should work?
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] How do I double check scheduled transactions?

[David Carlson]

Read Chapter 6 section 6.12 of the help manual.  If you have any further
questions please ask.

David Carlson

On Wed, Jul 3, 2019 at 8:15 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi All,
>
> Looks like I figured out how to do scheduled transactions.
> A very useful feature!
>
> Questions:
>
> 1)  when I get paranoid that I put the wrong amount in,
> how can I go back and double check it?
>
> 2)  how do I change the amount (Netflix raises its prices,
> etc..)?
>
> 3) how do I terminate a scheduled transaction?
>
> 4) how do I get them to update without exiting and restarting GnuCash?
>
>
> Many thanks,
> -T
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

[GNC] How do I double check scheduled transactions?

[ToddAndMargo via gnucash-user]

Hi All,

Looks like I figured out how to do scheduled transactions.
A very useful feature!

Questions:

1)  when I get paranoid that I put the wrong amount in,
how can I go back and double check it?

2)  how do I change the amount (Netflix raises its prices,
etc..)?

3) how do I terminate a scheduled transaction?

4) how do I get them to update without exiting and restarting GnuCash?


Many thanks,
-T

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

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

[David Carlson]

On Wed, Jul 3, 2019 at 6:43 PM John Ralls  wrote:

> Only slightly. The tarball release is e.g. 3.6. The first Windows bundle
> is 3.6, but if there's a dependency problem or I screw up the bundle
> subsequent bundles of that same release will be 3.6-1, 3.6-2, etc. The
> MacOS bundles work the same way except that the first one is 3.6-1...
> 1-based counting instead of 0-based, if you like.
>
> I like.😃

> Regards,
> John Ralls
>
> > On Jul 3, 2019, at 9:55 AM, David Carlson 
> wrote:
> >
> > Is it normal for MAc releases to have a different number than Windows,
> Linus, BSD, and tarballs?
> >
> > On Wed, Jul 3, 2019 at 9:16 AM John Ralls  wrote:
> >
> >
> > > On Jul 3, 2019, at 6:46 AM, Marco Rossi  wrote:
> > >
> > > Hi everybody,
> > > I’m experiencing an issue with Gnucash 3.6.1 installed on macOS Mojave
> 10.14.5. My default language is “italian” but Gnucash always run in english.
> > > When trying to start the application from the Terminal I’ve got this
> warning:
> > >
> > > (process:6569): gnc.gui-WARNING **: 15:31:44.760:
> [mac_set_languages()] Language list: it:it_IT
> > > The locale defined in the environment isn't supported. Falling back to
> the 'C' (US English) locale
> > >
> > > Anybody else has got the same issue? I’ve searched for some infos
> about this but with no success.
> >
> > You're in the wrong list, user support questions should go to
> gnucash-u...@lists.gnucash.org.
> >
> > To directly answer your question, see
> https://bugs.gnucash.org/show_bug.cgi?id=797297.
> >
> > Regards,
> > John Ralls
> >
> > ___
> > gnucash-devel mailing list
> > gnucash-de...@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> >
> >
> > --
> > David Carlson
>
>

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

Re: [GNC] Change a batch of transactions from income to Expense

[David Cousens]

You will find it useful to have a basic account structure already in place
but you can usually add extra accounts as you need then. I think the
dialogue which comes up when you select an account has a new account button
but GnuCash's windows are not generally modal so you can usually go back to
the Accounts tab on the main window and create the account in the account
tree heirarchy and then swap back to the window you were working on to use
it. 

If you are getting 4 entries for each column it sounds as though you may
have too many columns assigned. Iusually set the base account in the import
setup window in the field labelled Account at the top right. This sets the
account the first split or entry of the transaction will be applied to. I
usually don't specify a transfer account in the Import setup step and only
set the Date Description and Deposit columns and ignore any others. The
usual situation is you are importing transactions from a single account ie a
check or savings account in which one split(entry) of the transaction
affects that account and the second split of the transaction will debit or
credit the appropriate expense or income account respectively. This second
entry is quite often referred to as the transfer account in the
documentation and here on the list.

The next window that comes up is the import matcher.  It is used for both
CSV and OFX imports. QIF imports usually specify both accounts or an account
and an expense category which can be matched to an account so the matcher is
not used with QIF import s(here you can map the imported account names onto
GnuCash account  names). This matches records to Expense and Income  or
other accounts by matching dates within a range, the description field and
the amount. 

If you have not imported anything before the rows will come up in a yellow
background. This indicates that the record is to be added to the accounts (A
checkbox checked) and a transfer account has to be specified for the
transaction. Double clicking on the row will bring up an account selection
dialog which you can use to select the appropriate income or expense or
other account. Once you have selected the account the row will come up with
a green backgoround.

If the row comes up in red background it means that the record has been
flagged not to be imported. If the R checkbox is checked it matches an
exising record. If the U checkbox is checked, it matches an existing record
but some detail may be different and it will update the record.  A will be
unchecked. ALl the checkboxes may be unchecked if GnuCash is not able to
decide whether it matches an existing transaction well enough to be
reconciled(R) or updateable (U). All of these checkboxes may be overridden.
If a U or R is checked if you double click on the row it will bring up a
dialog which allows you to examine the match detail and decide whether it
really does match a transaction that exists or matches but has to update
some detail. ( This can occur if you use scheduled transactions which might
have a generic amount but the actual amount varies). If you decide the
record doesnt match ( the matcher is not perfect) or doesnt need to be
updated, you can uncheck the U or R boxes as appropriate and check the A
checkbox.  You can then assign a transfer account if it comes up with a
yellow background. 

If GnuCash decides the record contains enough matching information in the
description field to identify which account should be assigned as the
transfer account, the row will come up with a green background indicating
the record is ready to import. It will identify the transfer account it has
decided is appropriate in the Info field. If you wish to assign another
account, double click on the row to bring up the account selection dialog
and select an appropriate account. The selection dialogue has a New Account
button if there is not an appropriate existing account to assign the
transaction to. Again once you have assigned the transfer account the row
will show up with a green backgound.

Once you have processed all rows and they are flagged as either to be
imported( green) or not imported (red) and there are no yellow rows, click
on the Apply button to import them.

Using the importer can be difficult if you don't have a very good
understanding of the way GnuCash handles transactions and the basics of the
double entry system. The GnuCash tutorial and concepts guide covers this
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_basics.html. The
help manual https://www.gnucash.org/docs/v3/C/gnucash-help/help.html is more
process oriented.

The CSV importer as well as handling the case of importing records form a
bank account can also handle importing quite complex multi-split transaction
records exported from GnuCash so there are  a lot of options you don't need
for the import of bank records. 
If your bank does supply records in OFX format (and they implement the OFX
format correctly) it is generally easier to import records in

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

[John Ralls]

Only slightly. The tarball release is e.g. 3.6. The first Windows bundle is 
3.6, but if there's a dependency problem or I screw up the bundle  subsequent 
bundles of that same release will be 3.6-1, 3.6-2, etc. The MacOS bundles work 
the same way except that the first one is 3.6-1... 1-based counting instead of 
0-based, if you like.

Regards,
John Ralls

> On Jul 3, 2019, at 9:55 AM, David Carlson  wrote:
> 
> Is it normal for MAc releases to have a different number than Windows, Linus, 
> BSD, and tarballs?
> 
> On Wed, Jul 3, 2019 at 9:16 AM John Ralls  wrote:
> 
> 
> > On Jul 3, 2019, at 6:46 AM, Marco Rossi  wrote:
> > 
> > Hi everybody,
> > I’m experiencing an issue with Gnucash 3.6.1 installed on macOS Mojave 
> > 10.14.5. My default language is “italian” but Gnucash always run in english.
> > When trying to start the application from the Terminal I’ve got this 
> > warning:
> > 
> > (process:6569): gnc.gui-WARNING **: 15:31:44.760: [mac_set_languages()] 
> > Language list: it:it_IT
> > The locale defined in the environment isn't supported. Falling back to the 
> > 'C' (US English) locale
> > 
> > Anybody else has got the same issue? I’ve searched for some infos about 
> > this but with no success.
> 
> You're in the wrong list, user support questions should go to 
> gnucash-u...@lists.gnucash.org.
> 
> To directly answer your question, see 
> https://bugs.gnucash.org/show_bug.cgi?id=797297.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> 
> 
> -- 
> David Carlson

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

Re: [GNC] Change a batch of transactions from income to Expense

[David Carlson]

Are your sub-accounts assets under your bank account?  Your screenshot
looks like every transaction has both a debit and a credit to the same
sub-account, thus zero net.  Most transactions should be either an income
or an expense resulting in either a deposit or a withdrawal resp. to or
from a bank account, eg.

David Carlson

On Wed, Jul 3, 2019 at 3:59 PM morayweb  wrote:

> Hi Sorry for the bother.
> My exact method was.
> 1.  Create a new company
> 2. Create a New Main Bank account.
> 3. Create all the sub accounts ie Camps in Camps out etc
> 4. Import the transactions csv file.
> 5. Map using date for date.  Account for type ie Camps in Camps out,
> Description and deposit credit. Witdrawal Debit.  Account new main
> 6. it comes up  "A" ticked all the way down
> 7. End up like the screenshot.
> Hope this is clearer.
> Thank you.
> I only have about 170 transactions but dont want to reenter them all in.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

[GNC] Transaction matching on import

[Kenneth Schneider]

Is it possible to “manually match” a transaction when importing a transaction , 
method of import does not matter, into an account? I’ve had a problem with the 
importer making the wrong choice.

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

Re: [GNC] Income vs expense

[David Cousens]

Peter,

This section of the Gnucash Tutorial and Concepts guide should give you an
introduction to the concepts in using GnuCash
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_basics.html. GnuCash
is  a double entry system so every transaction has two or more components
which each affect two or more accounts. Chapters 5 and 6 in the Help manual
will give you some help with how to  record transactions in GnuCash,

David Cousens



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

Re: [GNC] Change a batch of transactions from income to Expense

[morayweb]

Hi Sorry for the bother.
My exact method was.
1.  Create a new company
2. Create a New Main Bank account.
3. Create all the sub accounts ie Camps in Camps out etc
4. Import the transactions csv file.  
5. Map using date for date.  Account for type ie Camps in Camps out,
Description and deposit credit. Witdrawal Debit.  Account new main
6. it comes up  "A" ticked all the way down
7. End up like the screenshot.
Hope this is clearer.
Thank you.
I only have about 170 transactions but dont want to reenter them all in.





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

Re: [GNC] Editing List of Income/Expenses

[Colin Law]

You can change the name of an account, if that is what you mean by
right clicking the account in the Accounts tab and selecting Edit
Account.  You can also move it in the hierarchy in the edit dialog.

On Wed, 3 Jul 2019 at 18:25, Amanda Schafer  wrote:
>
> I'm wanting to edit the list of income and expenses so that my transactions
> are more specific to my situation, but I can't find that anywhere in the
> menu listing or in the Help Guide.  Can someone direct me to that area
> please?
> ASchafer
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change a batch of transactions from income to Expense

[Adrien Monteleone]

Sorry, I might have misunderstood. Does the csv file contain 8 splits per 
transaction or are you just ending up with duplicates after the imports?

The importer is supposed to check for duplicates so it doesn’t re-import 
something, but if you’re importing with different assignments it might not 
catch that. You’d have to manually delete the extras.

> On Jul 3, 2019, at 2:40 PM, morayweb  wrote:
> 
> This is one of the imported accounts Camps In
> I have own server so could upload files for you to have a look.  If
> possible.
> Screenshot   


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

Re: [GNC] Change a batch of transactions from income to Expense

[morayweb]

This is one of the imported accounts Camps In
I have own server so could upload files for you to have a look.  If
possible.
Screenshot   




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

Re: [GNC] Change a batch of transactions from income to Expense

[Adrien Monteleone]

You can just copy and paste it into a reply. (might have to format it a bit 
with tabs or spaces to make it readable)

If you use the list directly instead of through Nabble you can try posting a 
screenshot. (though image hosting services like imgur work best)

Regards,
Adrien


> On Jul 3, 2019, at 1:33 PM, morayweb via gnucash-user 
>  wrote:
> 
> can i email you the file or attach it somewhere on the forum
> Thanks
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


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

Re: [GNC] print check register

[Chris Tsuji]

   Thank you
   I will give it a try
   Chris

   Sent: Tuesday, July 02, 2019 at 11:57 PM
   From: "Geert Janssens" 
   To: gnucash-user@gnucash.org
   Cc: "Chris Tsuji" , sunfis...@yahoo.com
   Subject: Re: [GNC] print check register
   Hi Chris,
   You can use View->Filter By... on the register to filter on a date
   range.
   After that select Reports->Account Report as David mentioned.
   Regards,
   Geert
   Op woensdag 3 juli 2019 05:20:33 CEST schreef Chris Tsuji:
   > David
   > Thank you
   > How about printing a range of date.
   > Example 6/1/18 to 7/1/19
   > Thanks in advance.
   > chris tsuji
   >
   > Sent: Tuesday, July 02, 2019 at 7:57 PM
   > From: "David T." 
   > To: "cts...@cheerful.com" ,
   > "gnucash-user@gnucash.org" 
   > Subject: Re: [GNC] print check register
   > While in the register, try Reports->Account Report.
   >
   >
   > HTH,
   > David
   >
   >
   >
   > On Wed, Jul 3, 2019 at 6:40, Chris Tsuji
   >  wrote:
   >
   >
   >
   > HI
   > How do you print the check register?
   > thanks
   > Chris Tsuji
   > ___
   > gnucash-user mailing list
   > [1]gnucash-user@gnucash.org
   > To update your subscription preferences or to unsubscribe:
   > [2][1]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   > If you are using Nabble or Gmane, please see
   > [3][2]https://wiki.gnucash.org/wiki/Mailing_Lists for more
   information.
   > -
   > Please remember to CC this list on all your replies.
   > You can do this by using Reply-To-List or Reply-All.
   >
   > References
   >
   > 1. mailto:gnucash-user@gnucash.org
   > 2. [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   > 3. [4]https://wiki.gnucash.org/wiki/Mailing_Lists
   > ___
   > gnucash-user mailing list
   > gnucash-user@gnucash.org
   > To update your subscription preferences or to unsubscribe:
   > [5]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   > If you are using Nabble or Gmane, please see
   > [6]https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
   -
   > Please remember to CC this list on all your replies.
   > You can do this by using Reply-To-List or Reply-All.

References

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

[GNC] Import Customers to Acct Rec

[Bruce Irving via gnucash-user]

Thanks, Adrien.  I didn't find it in the first 100 pages (and, for some reason, 
find would not work, then!).  For the benefit of others, since all of my 
customers are individuals and not companies and, since Company is what one sees 
when selecting the customer, I formatted the company as [last], [first] and the 
name in normal order.  
>Check the Tutorial & Concepts Guide, Chapter 18.2 ? Importing Customers & 
>Vendors.
>
>Regards,
>Adrien
>
>> On Jul 2, 2019, at 12:49 PM, Bruce Irving via gnucash-user 
>>  wrote:
>> 
>> I use GC with a club that currently has about 100 members, any can become 
>> A/R Customers.  I >would like to import all of my members into A/R Customers 
>> from my Excel member sheet. but have >been unable to find any way to do this 
>> (All I have found is importing transactions.)  I can convert my list >to CSV 
>> and, since there a lot of columns that are not needed, I can remove them.  
>> Is there any way I >can import these members?

Bruce Preach the Gospel wherever you go.  If necessary, use words. 

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

Re: [GNC] Employees function fields

[Scott A. Wozny via gnucash-user]

Hi Derek,

Thanks very much for the clarification.

Scott


From: Derek Atkins 
Sent: July 2, 2019 4:38 PM
To: Scott A. Wozny
Cc: gnucash-user
Subject: Re: [GNC] Employees function fields

Hi,

"Scott A. Wozny"  writes:

> GNUCash Gurus,
>
> I have a couple questions about the Employees section of GNUCash.  I
> have gone through all the available online documentation I was able to
> find and tried searching the list archives but wasn’t able to locate
> what I needed so I thought I’d try posting to the list.
>
> 1) What is the purpose of the Username field when creating a new user.
> If the employee is uniquely identified by the Employee Number field,
> what does the Username field add / do differently?

Nothing.  It was put in for future features which have never been
implemented.

> 2) What is the Credit Account field in the Billing section for?  At
> first I thought it would be the credit account for vouchers (i.e. the
> A/P liability) but that seems to be handled at the point I post a
> voucher and this field only allows me to choose accounts of type
> Credit Card so I’m at a loss as to its purpose. The docs don’t say
> anything about it other than that it exists so I thought I’d inquire
> here.

It would be for an employee's credit card.  I.e., if the employee has a
company card, this would be the card's account.  It's used in the "Cash"
vs "Card" option in an expense voucher.  Cash implies pay the employee
by check.  Card implies pay the card.

> Thanks very much,
>
> Scott

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change a batch of transactions from income to Expense

[morayweb via gnucash-user]

can i email you the file or attach it somewhere on the forum
Thanks



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

Re: [GNC] best accounting practice for refund

[Adrien Monteleone]

If you didn’t involve a liability account initially, the remaining credit on 
the credit note would sit in AR. But if you ‘paid’ the credit note with a 
liability, you transferred that amount from AR to the liability, which is the 
account you will ‘pay’ future invoices from when offsetting with the credit.

Be mindful that the credit note should have been posted to AR initially.

Also that the credit note’s line items should have all been assigned to some 
income account, NOT a liability account. You want to decrease your income 
accounts with a credit note that the original invoice(s) increased.

Here’s a simplified transaction walk through:


Original Invoice
-
Dr. Accounts Receivable $1000
Cr. Income  $1000


Original Payment by check
-
Dr. Undeposited funds   $1000
Cr. Accounts Receivable $1000


Depositing of check
-
Dr. Checking$1000
Cr. Undeposited Funds   $1000


Issuance of Credit Note
-
Dr. Income  $100
Cr. Accounts Receivable $100


IF you ‘pay’ (transfer) the credit note with a liability account
-
Dr. Accounts Receivable $100
Cr. Customer Deposits   $100


When you offset a future invoice with the liability
-
Dr. Customer Deposits   $100
Cr. Accounts Receivable $100


OR if you don’t involve a liability account at all, offsetting a future invoice
-
Dr. Accounts Receivable $100
Cr. Accounts Receivable $100

(in this case the money doesn’t move accounts, but gets ‘assigned’ to a 
different document, from the credit note to the invoice)

Regards,
Adrien

> On Jul 3, 2019, at 12:15 AM, Eric Rathhaus (general)  
> wrote:
> 
> Hi again - so everything worked the first time.  I back off all the 
> transactions and put the credit note in the AR account, selected two invoices 
> and the credit note , credit note reduced by that amount and the payments 
> showed.  But I need to run another offset and the credit note no longer 
> appears in the AR account.  The system moved it to a liabilities account and 
> automatically opens the liabilities account when processing a payment for 
> that company.  Is this how it should work?
> 


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

Re: [GNC] Change a batch of transactions from income to Expense

[Adrien Monteleone]

8 splits for each transaction?

Could you provide an example. (you can make up amounts of course, or make the 
payee/description generic if you like)

I’m curious to see what accounts those 8 splits are assigned to.

Are they generally the same for each transaction. Are one set of 4 always the 
same?

Regards,
Adrien

> On Jul 3, 2019, at 6:24 AM, morayweb  wrote:
> 
> Ok story so far.
> Managed to import the file but when checking the transactions I have 4
> entries for each one 4 incomes and 4 charges.
> Set the transfer account setting to account date etc ok.  When i go to the
> next stage everything is green but then all as mentioned at the start.
> Back to dear old excel i think.  


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

Re: [GNC] Income vs expense

[Adrien Monteleone]

Peter,

Welcome to GnuCash.

Your expense transactions should be split between where the money is coming 
from (cash, checking, credit card, etc.) and the relevant expense account.

Your income transactions should be split between where the money is going to 
(cash, checking, undeposited funds, etc.) and an income account.

Check your transactions to make sure this is the case and that you aren’t 
splitting income transactions with expense accounts or expense transactions 
with income accounts.

You may find it helpful to ‘view splits’ or turn on Transaction Journal view in 
the View menu at least till you get it sorted out.

Otherwise, if you spend exactly what you take in, they of course, will net to 
zero.

Regards,
Adrien

> On Jul 3, 2019, at 3:52 AM, Peter Peterson  wrote:
> 
> Hi my name is Peter. Iam a new user. I did something wrong i don't know
> what precisely. My income and expenses always show the same to the cent. I
> cannot evaluate the difference between income. Whatever for income becomes
> a expense.please advice.
> Regard,
> Peter

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

Re: [GNC] cut/paste problem in 3.4?

[Adrien Monteleone via gnucash-user]

Seeing how it functions I doubt it would use the OS clipboard. It isn’t just 
copying/cutting text. It also re-assigns the anchor split to the new account 
you paste it in. So this is certainly held in an internal ‘clipboard’ of sorts 
until pasted.

I would say the feature is much more complicated than a simple cut/copy/paste 
operation though that is the eventual effect.

Regards,
Adrien

> On Jul 2, 2019, at 8:06 PM, David Carlson  wrote:
> 
> Working with release 2.6.19 in Ubuntu 18.04 I also noticed that the
> transaction  copy or cut action does not use the clipboard there either.  I
> didn't have time to test pasting, however.
> 
> David Carlson

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

Re: [GNC] Editing List of Income/Expenses

[David T. via gnucash-user]

Each entry in your list of expenses is a separate account in your chart of 
accounts.  You edit the list by removing accounts.  Bear in mind that if your 
account has transactions in it, you will be asked the account to which you want 
these transactions to be moved. 
David

 
 
  On Wed, Jul 3, 2019 at 22:38, Amanda Schafer wrote:   
I'm wanting to edit the list of income and expenses so that my transactions
are more specific to my situation, but I can't find that anywhere in the
menu listing or in the Help Guide.  Can someone direct me to that area
please?
ASchafer
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Editing List of Income/Expenses

[Amanda Schafer]

I'm wanting to edit the list of income and expenses so that my transactions
are more specific to my situation, but I can't find that anywhere in the
menu listing or in the Help Guide.  Can someone direct me to that area
please?
ASchafer
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [GNC-dev] Announcement: GnuCash 3.6 Released

[Stephen M. Butler]

It appears that dpkg-buildpackage didn't setup the environment correctly
for the xenial/bionic build.  I have removed that version from the
Google drive.

It will take some more experimentation to figure out how to do this
reliably.

--Steve

On 7/2/19 2:04 PM, Manfred Usselmann wrote:
>
>  
>
> Hi Stephen,
>
> thanks a lot for providing the .deb files.
>
> I'm using version 3.5 on Ubuntu 18.04 (bionic) successfully. I did
> install it from files provided by you.
>
> Now I try to upgrade to 3.6.  Unfortunately it has some requirements
> which don't fit:  
>
> gnucash : Hängt ab von: libofx7 (>= 1:0.9.14) aber 1:0.9.12-1 soll
> installiert werden
> python3-gnucash : Hängt ab von: python3 (>= 3.7~) aber 3.6.7-1~18.04
> soll installiert werden
>
> Regards
> Manfred
>
>  
>
> Am 01.07.2019 07:37, schrieb Stephen M. Butler:
>
>> This Google Drive location now has debian downloads of v3.6 for both
>> Disco and Xenial-Bionic:
>>
>>  https://drive.google.com/open?id=1s-E6t-snmQiEFaT_hlWF2KHWrIB_LV2x
>>
>> I have fired up the Disco verion on my box.  I have no way to
>> checking that the Xenial-Bionic version works on that release.  Any
>> brave soul?
>>
>>  --Steve
>>
>>
>> On 6/30/19 10:07 PM, Stephen M. Butler wrote:
>>> On 6/30/19 4:02 PM, John Ralls wrote:
 The GnuCash development team announces GnuCash 3.6, the seventh
 release of the 3.x stable release series.

>>> For those on the Disco release of Ubuntu, you can download the debian
>>> files from the Disco/GnuCash_3.6 folder within this directory.  I'm
>>> seeing if I can generate one for Xenial/Bionic next.
>>>
>>> https://drive.google.com/open?id=1s-E6t-snmQiEFaT_hlWF2KHWrIB_LV2x
>>>
>>>
>>> sudo apt install ./*.deb
>>>
>>> Reading package lists... Done
>>> Building dependency tree  
>>> Reading state information... Done
>>> Note, selecting 'gnucash' instead of './gnucash_3.6-0_amd64.deb'
>>> Note, selecting 'gnucash-common' instead of
>>> './gnucash-common_3.6-0_all.deb'
>>> Note, selecting 'python3-gnucash' instead of
>>> './python3-gnucash_3.6-0_amd64.deb'
>>> Suggested packages:
>>>   libdbd-mysql
>>> The following packages will be upgraded:
>>>   gnucash gnucash-common python3-gnucash
>>> 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>>> Need to get 0 B/9,398 kB of archives.
>>> After this operation, 166 kB of additional disk space will be used.
>>> Get:1 /home/steve/Projects/GnuCash/gnucash_3.6-0_amd64.deb gnucash amd64
>>> 1:3.6-0 [3,986 kB]
>>> Get:2 /home/steve/Projects/GnuCash/gnucash-common_3.6-0_all.deb
>>> gnucash-common all 1:3.6-0 [5,141 kB]
>>> Get:3 /home/steve/Projects/GnuCash/python3-gnucash_3.6-0_amd64.deb
>>> python3-gnucash amd64 1:3.6-0 [271 kB]
>>> (Reading database ... 263596 files and directories currently installed.)
>>> Preparing to unpack .../gnucash_3.6-0_amd64.deb ...
>>> Unpacking gnucash (1:3.6-0) over (1:3.5) ...
>>> Preparing to unpack .../gnucash-common_3.6-0_all.deb ...
>>> Unpacking gnucash-common (1:3.6-0) over (1:3.5) ...
>>> Preparing to unpack .../python3-gnucash_3.6-0_amd64.deb ...
>>> Unpacking python3-gnucash (1:3.6-0) over (1:3.5) ...
>>> Setting up python3-gnucash (1:3.6-0) ...
>>> Setting up gnucash-common (1:3.6-0) ...
>>> Processing triggers for desktop-file-utils (0.23-4ubuntu1) ...
>>> Processing triggers for mime-support (3.60ubuntu1) ...
>>> Processing triggers for hicolor-icon-theme (0.17-2) ...
>>> Processing triggers for gnome-menus (3.32.0-1ubuntu1) ...
>>> Processing triggers for libglib2.0-0:amd64 (2.60.4-0ubuntu0.19.04.1) ...
>>> Processing triggers for libglib2.0-0:i386 (2.60.4-0ubuntu0.19.04.1) ...
>>> Processing triggers for man-db (2.8.5-2) ...
>>> Setting up gnucash (1:3.6-0) ...
>>>
>  
>

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

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

Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

[David Carlson via gnucash-user]

Is it normal for MAc releases to have a different number than Windows,
Linus, BSD, and tarballs?

On Wed, Jul 3, 2019 at 9:16 AM John Ralls  wrote:

>
>
> > On Jul 3, 2019, at 6:46 AM, Marco Rossi  wrote:
> >
> > Hi everybody,
> > I’m experiencing an issue with Gnucash 3.6.1 installed on macOS Mojave
> 10.14.5. My default language is “italian” but Gnucash always run in english.
> > When trying to start the application from the Terminal I’ve got this
> warning:
> >
> > (process:6569): gnc.gui-WARNING **: 15:31:44.760: [mac_set_languages()]
> Language list: it:it_IT
> > The locale defined in the environment isn't supported. Falling back to
> the 'C' (US English) locale
> >
> > Anybody else has got the same issue? I’ve searched for some infos about
> this but with no success.
>
> You're in the wrong list, user support questions should go to
> gnucash-u...@lists.gnucash.org.
>
> To directly answer your question, see
> https://bugs.gnucash.org/show_bug.cgi?id=797297.
>
> Regards,
> John Ralls
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


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

Re: [GNC] Balance sheet report period

[Rich Shepard]

On Wed, 3 Jul 2019, Christopher Lam wrote:


Or, you could download 3.6 and test the new experimental multi date
balance sheets :-)


Christopher,

My accountant has been happy with the information I've provided. My question
was my own, not hers.

I missed the announcement for 3.6. Just built and installed it in
Slackware-3.6.

Regards,

Rich

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

Re: [GNC] Balance sheet report period

[Mike or Penny Novack]

On 7/3/2019 9:44 AM, Christopher Lam wrote:

Or, you could download 3.6 and test the new experimental multi date balance
sheets :-)

THAT, however, has nothing to do with this question. The "multi date 
balance sheet" report ISN'T a balance sheet with multiple dates but a 
report that shows multiple balance sheets each for some different date.


It is STANDARD for certain financial reports to show two balance sheet 
reports in parallel. For example, a balance sheet at the start of an 
interval (end of previous period) and at the end plus the Income 
statement (aka P&L aka Revenue statement) for the interval. Following 
advice of the accountants, I put this together OUTSIDE of gnucash using  
raw reports exported from gnucash. I suppose lots of folks here would 
have preferred I had coded this << a retired software professional, I 
could have >> but the accountants were right, I am ALWAYS having to do 
some editing.


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

Re: [GNC] Balance sheet report period

[Christopher Lam]

Or, you could download 3.6 and test the new experimental multi date balance
sheets :-)

On Wed., 3 Jul. 2019, 21:37 Rich Shepard,  wrote:

> On Wed, 3 Jul 2019, benny.webs...@gmail.com wrote:
>
> > The balance sheet is a snapshot in time. It reflects the asset, liability
> > and equity account balances as of the date you choose. Compare two or
> more
> > balance sheets to see how those balances change over time (eg. month-end
> > to month-end or year-end to year-end). Income and cash flow statements
> > cover a period of time and should reflect the changes in the balance
> sheet
> > accounts.
>
> Benny,
>
> That makes sense. Since I'm not an accountant I did not recognize that it's
> a snapshot and thought it represented an unspecified time range up to the
> current (or otherwise selected) date.
>
> Thanks for clarifying,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] best accounting practice for refund

[John Griessen]

On 6/26/19 8:51 PM, Eric Rathhaus (general) via gnucash-user wrote:

In the past I created a credit note under the special job and sent my client a 
check.  This year they want me to use the credit to offset invoices for 
subsequent work.  I like the idea of creating a credit note under the special 
filing fee job I use for these payments and then applying the credit against 
other invoices I issue but I’m not sure if it will work from an accounting 
standpoint.


Since you are dealing with government and could be audited, I would ask the 
customer to receive a check
as refund, then buy more services with another check of theirs so as to clearly 
document this for an audit trail.

But, if they really want you to hold money and pay current invoices with it, using the liabilities account made just for them 
seems sane and auditable.


On 7/3/19 12:15 AM, Eric Rathhaus (general) via gnucash-user wrote:
> I back off all the transactions and put the credit note in the AR account, selected two invoices and the credit note , credit 
note reduced by that amount and the payments showed.  But I need to run another offset and the credit note no longer appears in 
the AR account.  The system moved it to a liabilities account and automatically opens the liabilities account when processing a 
payment for that company.  Is this how it should work?


Seems good.  If you pay the last of that liabilities account out and still need more to pay invoices, you can ignore the suggested 
account to pay from and then reprint the invoice with payments sown and send them that

to ask for a check for the remaining amount.

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

Re: [GNC] Balance sheet report period

[Rich Shepard]

On Wed, 3 Jul 2019, benny.webs...@gmail.com wrote:


The balance sheet is a snapshot in time. It reflects the asset, liability
and equity account balances as of the date you choose. Compare two or more
balance sheets to see how those balances change over time (eg. month-end
to month-end or year-end to year-end). Income and cash flow statements
cover a period of time and should reflect the changes in the balance sheet
accounts.


Benny,

That makes sense. Since I'm not an accountant I did not recognize that it's
a snapshot and thought it represented an unspecified time range up to the
current (or otherwise selected) date.

Thanks for clarifying,

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

Re: [GNC] Balance sheet report period

[Mike or Penny Novack]

On 7/2/2019 4:20 PM, Rich Shepard wrote:
Looking in the Guide the only reference I see to 'balance sheet 
report' is a
brief description. When I prepare the report the only date option I 
see is

the ending date.

Is the start date that of the first entry in GnuCash? Can I produce a
balancve sheet account for only the year-to-date and exclude previous 
years?

Or does that violate accounting practices?

Rich 


The Balance Sheet is a "snapshot" of the books as of a specific date, 
not an interval. There is neither a start date nor an end date; just an 
"as of" date. It includes explicitly all of the standing account 
balances  (account types asset, liability, and equity). The accounts 
types income and expense are not shown because they are actually 
temporary accounts of fundamental type equity. Their NET will appear as 
the unrealized gain or loss in the Balance Sheet.


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

Re: [GNC] Balance sheet report period

[Ben via gnucash-user]

Rich,

The balance sheet is a snapshot in time. It reflects the asset, liability and 
equity account balances as of the date you choose. Compare two or more balance 
sheets to see how those balances change over time (eg. month-end to month-end 
or year-end to year-end). Income and cash flow statements cover a period of 
time and should reflect the changes in the balance sheet accounts.

B.W.

Sent from my iPhone

> On Jul 3, 2019, at 08:47, Rich Shepard  wrote:
> 
>> On Wed, 3 Jul 2019, D wrote:
>> 
>> Although it might not be fully clear, the Guide states that the Balance
>> Sheet report "provides totals as of a given date."
> 
> David,
> 
> This is fully clear. I wanted to confirm that it meant the results include
> everything for the past three years (since I switched back to GnuCash at the
> beginning of 2017).
> 
> If that's how accounting works, so be it. I pay my accountant to do the
> right things with the numbers I provide from GunCash.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Balance sheet report period

[Rich Shepard]

On Wed, 3 Jul 2019, D wrote:


Although it might not be fully clear, the Guide states that the Balance
Sheet report "provides totals as of a given date."


David,

This is fully clear. I wanted to confirm that it meant the results include
everything for the past three years (since I switched back to GnuCash at the
beginning of 2017).

If that's how accounting works, so be it. I pay my accountant to do the
right things with the numbers I provide from GunCash.

Thanks,

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

Re: [GNC] Custom reports don't survive upgrade to v3

[Christopher Lam]

Hi Macho
There were API changes between 2.x and 3.x, and there'll be further ones
from 3.x and 4.x
Perhaps you'd be kind to post your custom .scm files on bugzilla, and the
stack traces?


On Tue, 2 Jul 2019 at 01:50, Macho Philipovich  wrote:

> Dear gnucash users,
>
> I decided to upgrade from the long-term support version of Ubuntu to the
> current stable version this weekend.
>
> This change, I would later learn, entailed upgrading gnucash from
> v2.6.19 to v3.4.
>
> The upgrade went fine, except that none of my four or five custom
> reports work any more.
>
> They mostly don't give any helpful error information but just show:
>
> *Report error*
> An error occurred while running the report.
>
> One of the reports does, however, give some sort of stack trace, though
> it's not terribly instructive either.
>
> It's been quite a while since I've looked at any of this, so revisions
> currently feel a bit daunting, but I do rely significantly on these
> custom reports.
>
> If anyone could point me to any resources on the changes to the reports
> API since v2 and to any debugging resources, it would also be greatly
> appreciated.
>
> The reports are my own creations, except that one is an extremely
> helpful year-to-date budget report that Phil Longstaff (in cc) provided
> me some time ago over this list in a file he called ytd-budget.scm.
> Phil, if by chance you've revised your report, I'd greatly appreciate a
> copy. And I would very much +1 this report becoming part of the standard
> reports provided within gnucash.
>
> Many thanks,
>
> Macho
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change a batch of transactions from income to Expense

[morayweb]

Ok story so far.
Managed to import the file but when checking the transactions I have 4
entries for each one 4 incomes and 4 charges.
Set the transfer account setting to account date etc ok.  When i go to the
next stage everything is green but then all as mentioned at the start.
Back to dear old excel i think.  



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

[GNC] Income vs expense

[Peter Peterson]

Hi my name is Peter. Iam a new user. I did something wrong i don't know
what precisely. My income and expenses always show the same to the cent. I
cannot evaluate the difference between income. Whatever for income becomes
a expense.please advice.
Regard,
Peter
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change a batch of transactions from income to Expense

[morayweb]

Good Morning David
Thats a great bit of help.  I will keep at it and see how I get on, I only
have about 170 transactions I need to import.  I was using an online tool to
convert the csv to other formats also my date is different it was coming up
with error as I have the / rather than the -.  To be honest I was nearly
going to try another package but I will keep at it and let you know what
happens.
One other thing I wasnt sure about is would I need to pre create the account
names before I import or will gnucash reate on the import.

Keep up the good work will report back.  



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