Re: [GNC] Error message

[D via gnucash-user]

Reading the error, I'd say you have a scheduled transaction named "CHECKING 
STATEMENT" that refers to a no-longer-valid account ID. 

Did you by chance delete your checking account at some point and then create a 
new account for it?

David

On October 14, 2019, at 10:19 AM, RICHARD YENTZER  wrote:

each time i open gnucash i receive the following message before my user
data file loads:

Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.
Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.
Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.

it appears to me that this relates to the user data i'm accessing.

what is this? is it causing or potentially causing harm? How can i get rid
of it?

richard
ryentze...@gmail.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Error message

[RICHARD YENTZER]

each time i open gnucash i receive the following message before my user
data file loads:

Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.
Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.
Unknown account for guid [13f77f105c19b5a8b17edef872d7eed5], cancelling SX
[CHECKING STATEMENT] creation.

it appears to me that this relates to the user data i'm accessing.

what is this? is it causing or potentially causing harm? How can i get rid
of it?

richard
ryentze...@gmail.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Charts with Multiple Currency

[risokei]

Hello,

Thanks for your help.

I inputted 1,000,000 JPY as cash and 55 facebook(it worth almost 
10,000USD, this mean it worth almost 1,000,000 JPY)


So my expectation is asset chart shows the total value is 2,000,000 JPY,
but actually it shows 1,000,000 JPY as cash and 100,000 JPY as asset

On 2019/10/06 14:14, Christopher Lam wrote:
Hello, nice to hear users using multiple currencies in reports. Most 
reports were designed to run converting all currencies into a "target" 
currency. It would be useful to know exactly what report options you 
are using, and exactly what you're trying to achieve.


On Sun, 6 Oct 2019, 12:56 risokei, > wrote:


Hello,

I'm using Gnucash with Japanese Yen and USD
Some charts show the data by graph.
But the graph is wrong. It seems all data is treated as Japanese
Yen in
the graph.

For example, Networth line chart

I have 100 JPY and US asset which worth 1 USD(1USD is almost 100
JPY),
Gnucash draw the graph as 100 for currency and 1 for foreign asset
value.
I think JPY and USD asset should have same volume in the graph in
this
example.

I guess gnucash don't have the feature to draw a graph with multi
currency .

Is there any workaround or fix for this?

Thanks in advance.

Risok

___
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] Job and Invoice

[Adrien Monteleone]

Sadly, ‘jobs’ won’t work here that way, I don’t think.

They really should be named ‘purchase orders’. They aren’t another level of 
classification or tracking.

You would need to create each invoice separately with its own terms. However, 
you can import invoice data. Since this is such a large group you need to 
create invoices for, I’d set that up in a spreadsheet arranged for invoice data 
importing. That will allow you to copy/paste duplicate info and to set up the 
terms in blocks, then import them all into GnuCash. See the Help & Guide for 
the import format.

After the initial import, you could then simply duplicate invoices and edit 
dates when you need to invoice that customer again next time. But this too 
would be a one-at-a-time process. If that is too tedious, then just importing 
each billing cycle would be the way to go.

Also unfortunately, GnuCash doesn’t have a bulk invoice printing ability. 
(there is a bug/RFE filed on it though) And sadly, I don’t see a way to export 
a group of invoices for printing in bulk via some other software.

Regards,
Adrien

> On Oct 12, 2019 w41d285, at 12:37 PM, Patrick Walker  
> wrote:
> 
> Just installed GNUCash in hopes of managing finances for my Home Owners 
> Association. We have 218 homes which I set up as customers. we now wish to 
> issue invoices for a reserve fund we are creating. Total due is $48 per home, 
> payable at either six, twelve, or a one time intervals, of which each home 
> has pre-elected their pay terms upon submitting their commitment letter. My 
> thought is to create a "Job" for the $48 billing, then create terms of 
> semiannual,  annual or one time payment. 
> First, am I on the right path? Second , do I print each invoice or can I bulk 
> print all semiannual,  then all annual, then all one time payment invoices?
> Thank you in advance!
> Patrick


___
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 to find Bill that a Payment was applied to?

[Adrien Monteleone]

There is a report coming (hopefully for 4.0) which will help sort these 
scenarios out, but until then...

1. Open the AP register
2. Right click on the payment transaction
3. Choose “Edit Payment”

The payment window will then pop-up and show you the invoice(s) the payment is 
applied to. (cancel out of the window if you don’t need to make any actual 
changes)

If you don’t see “Edit Payment” and instead see “Assign as Payment” then the 
payment was not properly applied to *any* invoice.

Simply use the apply function and then all should be well.

Also, make sure you don’t have duplicate payment transactions, with one applied 
and one not.

Regards,
Adrien

> On Oct 12, 2019 w41d285, at 9:47 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> I've got a strange case here.
> Assets: Current Assets: Checking Account shows a 12/10/18 Payment to Vendor 
> XThe Split shows- Liabilities: Accounts Payable- Assets: Current Assets: 
> Checking Account
> The 12/10/18 Payment also shows in Accounts Payable with the same Split
> But when I run a Vendor Report on Vendor X the 12/10/18 Payment does not show.
> The Bill shows posted on 12/3/18 in the Vendor Report but when I View Bill it 
> shows unpaid.
> So I'm guessing I must have two Vendor X accounts and applied the 12/10/18 
> payment to the wrong one BUT when I look at Business > Vendor > Vendors 
> Overview only one Vendor X is listed.
> The Question: How can I find which Bill the 12/10/18 Payment was applied to?
> Thanks for any help.
> PS
> a - I searched everywhere for a 2nd account named Vendor X but can not find 
> it anywhere except in the List of Vendors
> b  - I'm running v3.7 on Windows 10


___
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 can I add statement balances to my accounts as

[David Carlson]

To David T's point, when there are un-reconciled items in the register, the
reconciled balance will still match the bank statement if the
reconciliation was completed successfully. Where GnuCash appears to
disagree is in the fact that there is no reconciliation report kept in the
data file or option to display the reconciled balance in the register.
However, Alan is entering the value that GnuCash is displaying in the
register when the reconciliation is complete, or the technically
un-reconciled balance.  Any change in the history preceding that date
should show a disagreement between the note and the displayed balance.

I agree with Alan that often there are very few outstanding un-reconciled
items so it would not be a challenge to mentally adjust for that if even
necessary.  Also, one could show both reconciled balance and un-reconciled
balance in a manual entry used to track those numbers.

Personally, I have used a method similar to Alan's in my bank and credit
card accounts for years.  Most of the errors that I make are in transfers
between accounts where whichever transaction was entered last 'breaks' the
reconciliation of another account if the transaction is assigned to the
incorrect account or if it clears on a different date.  For those date
mismatches I just choose one and leave the other one incorrect unless I
really want to track that float for some reason.  I have a special account
for those cases.

David Carlson

On Sun, Oct 13, 2019 at 8:20 AM AEG via gnucash-user <
gnucash-user@gnucash.org> wrote:

> My reconciliations normally match those of the bank unless I've made an
> error
> or, as you say, a transaction has not yet been presented to the bank. In
> the
> first case, I investigate and correct the error. In the second case, I
> enter
> the actual end-of-day balance in brackets after the statement amount. That
> way, I know both the statement amount and the balance amount on the date of
> the statement. That should never change unless extra transactions are
> inserted with earlier dates or others are deleted.
>
> Alan
>
>
>
> GnuCash - User mailing list wrote
> > This is interesting. Let's say that at a later point, a transaction were
> > added prior to one of these entries. How will this transaction help in a
> > way that looking at the statements wouldn't?
> > You see, one of the basic truisms of reconciliation is that your balance
> > as of a given date will differ from the bank's.  That's because you have
> > entered transactions that the bank won't know about. So, the account's
> > balance on the date of reconciliation *when correct* will not match the
> > bank's.  If at some later point, these change relative to one another,
> how
> > are you going to know?
> >
> >
> >   On Sun, Oct 13, 2019 at 13:47, AEG via gnucash-user
>
> > gnucash-user@
>
> >  wrote:   The way I deal with this is not entirely automatic as it
> > involves setting up
> > a scheduled transaction for every account that has a regular statement,
> > but
> > it does allow me to check back for errors later.
> >
> > For each of my bank or credit card accounts, the statements are normally
> > compiled on the same date every month so I set up a single line scheduled
> > transaction to trigger on that date in which the debit and credit cells
> > are
> > left blank. In the Description box I enter the name of the bank and in
> the
> > Notes box I enter the words "Statement:£" so that it is ready for me to
> > enter the statement total when it arrives. From this, I can check its
> > accuracy at the time of reconciliation and deal with any discrepancies I
> > find.
> >
> > In the future, if I notice a problem, I can look back through
> transactions
> > until I find the last time statements and balances matched, thereby
> > narrowing the dates to check for errors.
> >
> > Alan
> >
> >
> >
> > armanschwarz wrote
> >> Suppose on July 1, 2019 I get a statement that my account balance is
> >> $100.
> >> Since I know this is true and won't change in the future, I should be
> >> able
> >> to tell GnuCash that this is the expected balance, and for some kind of
> >> warning to appear if that condition is ever violated for the
> >> corresponding
> >> account in GnuCash (kind of like a unit test).
> >>
> >> Looking at the documentation for Reconciliation, it seems like this that
> >> feature more targeted at individual transactions rather than setting
> >> known
> >> values for balances at given points in time. If I reconcile an account
> >> for
> >> 12 months every month, and then stop reconciling it the year after,
> >> what's
> >> stopping all of those historic balances from getting thrown out of
> whack?
> >> Does GnuCash remember what the balances should be and prevent this?
> >>
> >> Also, if I accidentally enter a wrong date every 5% of the time, and I
> >> accidentally reconcile them incorrectly 5% of the time, then for a large
> >> number of transactions I'm virtually guaranteed to have my history
> >> broken,
> >> whereas 

Re: [GNC] How can I add statement balances to my accounts as

[AEG via gnucash-user]

My reconciliations normally match those of the bank unless I've made an error
or, as you say, a transaction has not yet been presented to the bank. In the
first case, I investigate and correct the error. In the second case, I enter
the actual end-of-day balance in brackets after the statement amount. That
way, I know both the statement amount and the balance amount on the date of
the statement. That should never change unless extra transactions are
inserted with earlier dates or others are deleted.

Alan



GnuCash - User mailing list wrote
> This is interesting. Let's say that at a later point, a transaction were
> added prior to one of these entries. How will this transaction help in a
> way that looking at the statements wouldn't?
> You see, one of the basic truisms of reconciliation is that your balance
> as of a given date will differ from the bank's.  That's because you have
> entered transactions that the bank won't know about. So, the account's
> balance on the date of reconciliation *when correct* will not match the
> bank's.  If at some later point, these change relative to one another, how
> are you going to know?
>  
>  
>   On Sun, Oct 13, 2019 at 13:47, AEG via gnucash-user

> gnucash-user@

>  wrote:   The way I deal with this is not entirely automatic as it
> involves setting up
> a scheduled transaction for every account that has a regular statement,
> but
> it does allow me to check back for errors later.
> 
> For each of my bank or credit card accounts, the statements are normally
> compiled on the same date every month so I set up a single line scheduled
> transaction to trigger on that date in which the debit and credit cells
> are
> left blank. In the Description box I enter the name of the bank and in the
> Notes box I enter the words "Statement:£" so that it is ready for me to
> enter the statement total when it arrives. From this, I can check its
> accuracy at the time of reconciliation and deal with any discrepancies I
> find.
> 
> In the future, if I notice a problem, I can look back through transactions
> until I find the last time statements and balances matched, thereby
> narrowing the dates to check for errors.
> 
> Alan
> 
> 
> 
> armanschwarz wrote
>> Suppose on July 1, 2019 I get a statement that my account balance is
>> $100.
>> Since I know this is true and won't change in the future, I should be
>> able
>> to tell GnuCash that this is the expected balance, and for some kind of
>> warning to appear if that condition is ever violated for the
>> corresponding
>> account in GnuCash (kind of like a unit test).
>> 
>> Looking at the documentation for Reconciliation, it seems like this that
>> feature more targeted at individual transactions rather than setting
>> known
>> values for balances at given points in time. If I reconcile an account
>> for
>> 12 months every month, and then stop reconciling it the year after,
>> what's
>> stopping all of those historic balances from getting thrown out of whack?
>> Does GnuCash remember what the balances should be and prevent this?
>> 
>> Also, if I accidentally enter a wrong date every 5% of the time, and I
>> accidentally reconcile them incorrectly 5% of the time, then for a large
>> number of transactions I'm virtually guaranteed to have my history
>> broken,
>> whereas remembering statement balances would avoid this problem.





--
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] Understanding Transaction Report options

[Christopher Lam]

> Christopher, thank you. Let me ensure I understand.
> and 2. When Account tab filter is set to "Include," and
> Asset:Bank:Current, Filter-Type: Include to/from, Filter-By:
> Expenses:School:Fees --> will show only school
> fees.
>
Comment: "Include" appears to me to work similarly to the exclusionary
> Boolean "AND" operator, since the system will only report the intersection
> of the two sets. "Exclude," then, should show everything except the school
> fees, and appears to operate as a Boolean "NOT" operator.
>
3. Filter tab: Account Name Filter: Comment: This is another way to
> accomplish what might have selected on the Account tab and is not a
> completely separate function.
>

Correct. Case example. My book as numerous household expense accounts, e.g.
Expenses:House:Electricity, etc.

My accountant lets me deduct a proportion of house electricity bills for
home office, and when I submit my annual statements, I find it error-prone
to carefully select from the Accounts tab. Hence I modified the transaction
report in 2017 to offer the ability to tag the desired accounts with "^"
e.g. Income:Job^, Income:Bank-Interest^, Expenses:House:Electricity^ which
means an account fullname filter for '^' gets me everything I need for my
annual tax. The accountant then gets the responsibility of calculating the
proportion of home office use.

> With this new understanding as a baseline I'll practice a few reports. I
do recall, however, that prior to selecting filter accounts on the Accounts
tab, I used the Transaction Filter and needed the Filter By "Exclude" in
order to achieve anything useful. I expect I should have chosen "None" if I
were not going to select a Filter account

Correct. the Filter-By and Filter-Type were old-style account-only
filtering options and it would be confusing to users to find the option
names modified or removed. See amendments to transaction.scm in
https://github.com/Gnucash/gnucash/commit/5eb7ddb4e9 originally from 2001.
___
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 can I add statement balances to my accounts as

[David T. via gnucash-user]

This is interesting. Let's say that at a later point, a transaction were added 
prior to one of these entries. How will this transaction help in a way that 
looking at the statements wouldn't?
You see, one of the basic truisms of reconciliation is that your balance as of 
a given date will differ from the bank's.  That's because you have entered 
transactions that the bank won't know about. So, the account's balance on the 
date of reconciliation *when correct* will not match the bank's.  If at some 
later point, these change relative to one another, how are you going to know?

 
 
  On Sun, Oct 13, 2019 at 13:47, AEG via gnucash-user 
wrote:   The way I deal with this is not entirely automatic as it involves 
setting up
a scheduled transaction for every account that has a regular statement, but
it does allow me to check back for errors later.

For each of my bank or credit card accounts, the statements are normally
compiled on the same date every month so I set up a single line scheduled
transaction to trigger on that date in which the debit and credit cells are
left blank. In the Description box I enter the name of the bank and in the
Notes box I enter the words "Statement:£" so that it is ready for me to
enter the statement total when it arrives. From this, I can check its
accuracy at the time of reconciliation and deal with any discrepancies I
find.

In the future, if I notice a problem, I can look back through transactions
until I find the last time statements and balances matched, thereby
narrowing the dates to check for errors.

Alan



armanschwarz wrote
> Suppose on July 1, 2019 I get a statement that my account balance is $100.
> Since I know this is true and won't change in the future, I should be able
> to tell GnuCash that this is the expected balance, and for some kind of
> warning to appear if that condition is ever violated for the corresponding
> account in GnuCash (kind of like a unit test).
> 
> Looking at the documentation for Reconciliation, it seems like this that
> feature more targeted at individual transactions rather than setting known
> values for balances at given points in time. If I reconcile an account for
> 12 months every month, and then stop reconciling it the year after, what's
> stopping all of those historic balances from getting thrown out of whack?
> Does GnuCash remember what the balances should be and prevent this?
> 
> Also, if I accidentally enter a wrong date every 5% of the time, and I
> accidentally reconcile them incorrectly 5% of the time, then for a large
> number of transactions I'm virtually guaranteed to have my history broken,
> whereas remembering statement balances would avoid this problem.





--
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] How can I add statement balances to my accounts as checks?

[AEG via gnucash-user]

The way I deal with this is not entirely automatic as it involves setting up
a scheduled transaction for every account that has a regular statement, but
it does allow me to check back for errors later.

For each of my bank or credit card accounts, the statements are normally
compiled on the same date every month so I set up a single line scheduled
transaction to trigger on that date in which the debit and credit cells are
left blank. In the Description box I enter the name of the bank and in the
Notes box I enter the words "Statement:£" so that it is ready for me to
enter the statement total when it arrives. From this, I can check its
accuracy at the time of reconciliation and deal with any discrepancies I
find.

In the future, if I notice a problem, I can look back through transactions
until I find the last time statements and balances matched, thereby
narrowing the dates to check for errors.

Alan



armanschwarz wrote
> Suppose on July 1, 2019 I get a statement that my account balance is $100.
> Since I know this is true and won't change in the future, I should be able
> to tell GnuCash that this is the expected balance, and for some kind of
> warning to appear if that condition is ever violated for the corresponding
> account in GnuCash (kind of like a unit test).
> 
> Looking at the documentation for Reconciliation, it seems like this that
> feature more targeted at individual transactions rather than setting known
> values for balances at given points in time. If I reconcile an account for
> 12 months every month, and then stop reconciling it the year after, what's
> stopping all of those historic balances from getting thrown out of whack?
> Does GnuCash remember what the balances should be and prevent this?
> 
> Also, if I accidentally enter a wrong date every 5% of the time, and I
> accidentally reconcile them incorrectly 5% of the time, then for a large
> number of transactions I'm virtually guaranteed to have my history broken,
> whereas remembering statement balances would avoid this problem.





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