Re: [GNC] Deb 3.4.0.1 not working for me in ubuntu 18.04

[Liz]

On Wed, 09 Jan 2019 12:36:46 +0100
Geert Janssens  wrote:

> Indeed. Last time I checked (which is 10+ years ago already)
> checkinstall didn't do dependency tracking. What it does is recording
> everything that gets installed by 'make install' and wrapping that in
> a .deb package (or .rpm package for that matter).

There is an option to list "Depends" when you create the deb with
checkinstall.
>From the man page
  --requires
 Dependencies required by this package.
Checkinstall does not populate that data set, the user of checkinstall
needs to.

It is noted that checkinstall is not intended to build packages for
distribution, other tools are 'preferred'.

Liz

___
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] Present Reconcile Is Showing Previous Reconciled Items UnReconciled

[Colin Law]

You should get a warning if you edit a reconciled transaction.  If you
aren't getting that then that probably means you accepted the warning
at some point and selected don't tell me again. If you want to
re-enable it then select Actions > Reset Warnings.

Colin

On Fri, 11 Jan 2019 at 02:15, Matt Hanning  wrote:
>
> Thank you for sharing your thoughts. After reading everything I believe I
> have been editing the transactions which makes them show back up
> un-reconciled. I will be keeping a closer eye on this and see if this has
> been the problem all along.
>
> Thank you both for all your help and info.Matt
>
>
> On Thu, Jan 10, 2019 at 12:30 AM D via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > David's points here are all well-considered. See notes inline.
> >
> > On January 10, 2019, at 9:42 AM, David Cousens 
> > wrote:
> >
> > >Normally the only way a reconciled transaction becomes unreconciled is if
> > the
> > >split to the account which has been reconciled is editied, either in the
> > >register for the reconciled account or in another register conatining the
> > >split from the reconciled account to that registers. The splits of a
> > >transaction can be edited from any register for any account which contains
> > >splits to it from the transaction. In V3.4 editing details (description,
> > >memo) other than the amount, date and account does not affect the
> > >reconciliation flag status.  You will normally get a dialogue indicating
> > >that you are editing a reconciled split.
> > >I think earlier versions of GnuCash may have also changed the status when
> > >other splits and any information in a reconciled transaction were edited
> > >were edited but I am unsure of this and when only editing specific fields
> > in
> > >the reconciled split triggered changing of the status was introduced.
> > >The easiest way to fix this is to rerun the reconciliation process for
> > >periods covering the earliest unreconciled transaction forward, checking
> > >that opening balances, closing balances and transaction amounts agree with
> >
> > I disagree here. I think the easiest first method is to enter the *last*
> > statement balance (ignoring the opening balance altogether), and see
> > whether checking those earlier entries results in a zero balance. I often
> > find that it does.
> >
> > I only go to more specificity if this one doesn't work.
> >
> > >the statements. GnuCash will often start the reconciliation window with
> > some
> > >transactions marked even if that period has not been previously reconciled
> > >as it attempts to identify transactions which lead to a reconciliation. I
> >
> > For the record, Gnucash pre-checks only those transactions that have a
> > reconcile status of "c," which usually occurs with imported transactions.
> > Users can also set this status in the register themselves.
> >
> > >have been caught believing this in the past and I now clear (uncheck) all
> > >transactions in the reconciliation window and match them individually by
> > >hand. Tedious but it can pick up 2 errors cancelling each other out so
> > that
> > >the opening and closing balances are OK but the transactions are
> > incorrect.
> > >Any unreconciled transaction should show up in the reconciliation
> > procedure
> > >window as unchecked with any already reconciled splits being initially
> >
> > Again, transactions with a status "c" will be checked; reconciled items by
> > definition will be excluded from the window (except insofar as they
> > contribute to the opening balance figure).
> >
> > OP might check to see whether he accidentally re-entered transactions that
> > have already been entered and reconciled, as might happen, for example when
> > importing transactions from a second account (say a credit card) whose
> > transaction details don't fully match the existing entry.
> >
> > The OP could supply further details (OS, Gnucash version, specific
> > circumstances of his problem) to get better answers. Until then, we are
> > speculating on a host of possibilities.
> >
> > David T.
> >
> >
> > >checked which can help identify the unreconciled transactions
> > >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.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash

Re: [GNC] editing reconciled transactions changes reconcile status

[Geert Janssens]

Hi all,

Thanks for the feedback, though I preferred to have received it while we were 
actually working in that area :(

So really the only elements to reconcile on are transaction date and amount ?

Geert

Op vrijdag 11 januari 2019 03:36:15 CET schreef David Cousens:
> Geert,
> 
> My opinion is much the same as Adriens' . The critical information you are
> verifying against a statement is:
> 
> the timing (date and/or time) and
> amount of the split to the account being reconciled.
> 
> Where data has been manually eneterd into GnuCash, the date may not be the
> same necessarily as a statement as they will record the date and/or time
> relevant to the handling of the transaction in their hands which may be
> different from your own -  can be importnat for contracts for example.
> 
> I also feel that changing the amount in splits other than the split to the
> reconciled account should not trigger unreconciliation of a reconciled split
> ( which is the crrent position).
> 
> Any other information, while it may assist with identifying reconciliation
> (e.g description memo etc), it is not the information which is being
> reconciled itself.
> 
> In addition the critical information that defines that transaction's
> identity, i.e. internal GnuCash transaction ID needs to be protected.
> 
> My bank doesn't provide in a statement their transaction ID's, or
> transaction time and any description provided is from their perspective not
> mine. My statement is pretty minimal:
> 
> Date   DescriotionDebit   Credit   Balance
> Balance State (Db/Cr)
> 
> It is interesting that the OFX files I import from my bank often contain
> much more information than the statements. They however are created on
> demand whereas my statement often comes out a few weeks weeks after the end
> of the relevant period and does not contain any pending events etc and any
> clearances have been resolved. With electronic clrearance times now being
> very short, these sort of discrepancies in accounts are now generally fairly
> infrequent now
> 
> While accounts with bank statements (asset, liabilities) will be the most
> commonly reconciled accounts, they are not necessarily the only ones. In the
> days when I ran a business, I could request and received statements form
> vendors and supplied them to customers to verify that we agreed on what was
> owed to them or by them. If you track income or expense by customer or
> vendor then you may also find yourself reconciling these, especially if
> there is a dispute.
> 
> 
> David Couens
> 
> 
> 
> -
> 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.




___
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] Copy a month's budget

[Andre Powell]

Patrick,
The method that I use for budgeting is well "old-fashioned". My salary is
paid every fifteen days and my wife once a month, hence the two-week setup,
and the quarterly view because in my prior career we managed our P&Ls
monthly but with quarterly plans so mentally I am kind of used to that way
of thinking (or maybe I don't  want to scroll so much).

When income comes in is when I actually use the budget to plan where the
money is going to go (a mixture of Dave Ramsey and YNAB). I use the
Bills/Invoice feature to keep track of the bills that need to be paid, but
they don't get paid until they are planned for.

For monitoring purposes, I use the Budget Report to do exactly that. You
can set it up to see a period before and after your current account period
(mine being set at a quarter), which will show your carryover. I am always
striving for a balanced budget (move/spend less money to make sure that the
budget is balanced. But in theory, you could create a second report with a
longer view (perhaps yearly) to see your overall progress with the period
before.

I hope this helps.

On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:

> Andre,
>
> Thank you for the response. For each two-week period within the quarter,
> did you just have to copy the budget entries from each column to the next?
> That is what I would like to avoid, if possible.
>
> I would like to use one budget so that it is easy to see carryover from
> one budget period to the next. If I create a new budget for each quarter, I
> don't know of a way to get cumulative surplus/deficit for each budget
> category from the previous quarter.
>
> Thanks,
> Patrick
>
> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell  wrote:
>
>> Patrick,
>> I made a template and under the Budget menu just make a duplicate/copy as
>> needed (my accounting period is quarterly and the budgets are every two
>> weeks).
>>
>>
>> On Wed, Jan 9, 2019, 10:34 PM Patrick >
>>> Hello,
>>>
>>> I recently started using GnuCash. Is there a way to copy one month's
>>> budget
>>> to the next month? I have a budget with a large number of entries, and
>>> copying each entry individually is somewhat cumbersome.
>>>
>>> Any help is appeciated.
>>>
>>> Regards,
>>> 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.
>>>
>>

-- 
Andre
___
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 reconciled transactions changes reconcile status

[John Ralls]

Dates can be different. Even electronic transfers have clearing time, never 
mind paper checks (my bleeping water company can’t seem to get electronic 
transfers to work). I often pay for something with a debit or credit card and 
book it in GnuCash, then find that the payment actually cleared the following 
business day at reconciliation time.

On the other hand if one is using paper checks and using the Number field to 
record them then that’s usually also on one’s bank statement so would be 
included in the reconciliation... but there are other ways to use that field, 
so including it would have to be optional.

Regards,
John Ralls


> On Jan 11, 2019, at 1:37 AM, Geert Janssens  
> wrote:
> 
> Hi all,
> 
> Thanks for the feedback, though I preferred to have received it while we were 
> actually working in that area :(
> 
> So really the only elements to reconcile on are transaction date and amount ?
> 
> Geert
> 
> Op vrijdag 11 januari 2019 03:36:15 CET schreef David Cousens:
>> Geert,
>> 
>> My opinion is much the same as Adriens' . The critical information you are
>> verifying against a statement is:
>> 
>> the timing (date and/or time) and
>> amount of the split to the account being reconciled.
>> 
>> Where data has been manually eneterd into GnuCash, the date may not be the
>> same necessarily as a statement as they will record the date and/or time
>> relevant to the handling of the transaction in their hands which may be
>> different from your own -  can be importnat for contracts for example.
>> 
>> I also feel that changing the amount in splits other than the split to the
>> reconciled account should not trigger unreconciliation of a reconciled split
>> ( which is the crrent position).
>> 
>> Any other information, while it may assist with identifying reconciliation
>> (e.g description memo etc), it is not the information which is being
>> reconciled itself.
>> 
>> In addition the critical information that defines that transaction's
>> identity, i.e. internal GnuCash transaction ID needs to be protected.
>> 
>> My bank doesn't provide in a statement their transaction ID's, or
>> transaction time and any description provided is from their perspective not
>> mine. My statement is pretty minimal:
>> 
>> Date   DescriotionDebit   Credit   Balance
>> Balance State (Db/Cr)
>> 
>> It is interesting that the OFX files I import from my bank often contain
>> much more information than the statements. They however are created on
>> demand whereas my statement often comes out a few weeks weeks after the end
>> of the relevant period and does not contain any pending events etc and any
>> clearances have been resolved. With electronic clrearance times now being
>> very short, these sort of discrepancies in accounts are now generally fairly
>> infrequent now
>> 
>> While accounts with bank statements (asset, liabilities) will be the most
>> commonly reconciled accounts, they are not necessarily the only ones. In the
>> days when I ran a business, I could request and received statements form
>> vendors and supplied them to customers to verify that we agreed on what was
>> owed to them or by them. If you track income or expense by customer or
>> vendor then you may also find yourself reconciling these, especially if
>> there is a dispute.
>> 
>> 
>> David Couens
>> 
>> 
>> 
>> -
>> 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.
> 
> 
> 
> 
> ___
> 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] Currencies not being converted

[John Ralls]

Last warning: Copy the list on all replies or you go to spam and get no more 
replies.

You may have to specify the path if you’re not using Linux. 

On Windows it’s c:\Program Files (x86)\gnucash\bin\gnc-fq-update, but you also 
need to install perl. GnuCash installed a small program to set it all up for 
you, “Install Online Price Retrieval” in the GnuCash folder of the Start Menu.

On MacOS it’s /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update. 
You need to run gnc-fq-upate in sudo. There’s a similar helper app in the 
GnuCash dmg, install it in the same folder as GnuCash and double-click it, then 
accept all of the defaults in the ensuing script.

Regards,
John Ralls

> On Jan 11, 2019, at 8:35 AM, Tom Delarge  wrote:
> 
> Okay the problem I'm having is that gnc-fq-update and all similar commands 
> bring back "command not found"
> 
> On Wed, Jan 9, 2019 at 7:55 PM John Ralls  > wrote:
> Please remember to copy the list on all replies.
> 
> If “Get Quote” returns an error it means that either you don’t have online 
> quote retrieval setup or that there’s a problem with it. Please study 
> https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_howto1.html 
>  for 
> your options in getting current exchange rates.
> 
> Regards,
> John Ralls
> 
>> On Jan 9, 2019, at 7:41 AM, Tom Delarge > > wrote:
>> 
>> I did that and it worked, thank you very much. 
>> 
>> But...the prices that GNUcash gives don't reflect the real price that I see 
>> on google.
>> 
>> On the chart of accounts screen in GC I have it show me New Taiwan Dollars 
>> (for many accounts are in that currency) and have a columb showing me the 
>> USD balance. But it is using a very incorrect conversion rate and I'm not 
>> sure why it won't update. I hit "get quote" and it just tells me there is an 
>> error. 
>> 
>> Is there no way way I can keep my accounting data and have the program 
>> itself properly update the prices? 
>> 
>> On Thu, Jan 3, 2019 at 10:29 AM John Ralls > > wrote:
>> 
>> 
>> > On Jan 2, 2019, at 9:43 AM, salmichaels > > > wrote:
>> > 
>> > I have just returned from overseas with laptop and now gnucash does not
>> > convert currencies. I have some accounts in a foreign currency, others in
>> > USD. In making reports or having a Total (USD) column, GC doesn't convert
>> > the accts in foreign currency to USD, but just lists the amounts as if they
>> > are US dollars. If I change the report currency to the foreign currency, it
>> > handles it fine; it converts the USD accounts to the foreign currency, no
>> > issues. 
>> > 
>> > The program is set to default to local (US) currency, and was even when I
>> > was overseas as far as I know. Now it is also set to local US. My local
>> > settings on my computer are also set for the US. So yeah, I cannot for the
>> > life of me figure this out. 
>> > 
>> > thanks in advance! 
>> 
>> Check the price database for both USD->??? and ???->USD and make sure that 
>> the most recent price is correct in both directions.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
> 

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

Re: [GNC] Copy a month's budget

[Patrick]

Andre,

Thanks for the advice. This definitely gives me some possible alternatives
to consider.

I am not able to find a page that gives the etiquette rules for this
mailing list. Is top-posting preferred on this list? I noticed that some
people do and some don't.

Thanks,
Patrick

On Fri, Jan 11, 2019 at 6:24 AM Andre Powell  wrote:

> Patrick,
> The method that I use for budgeting is well "old-fashioned". My salary is
> paid every fifteen days and my wife once a month, hence the two-week setup,
> and the quarterly view because in my prior career we managed our P&Ls
> monthly but with quarterly plans so mentally I am kind of used to that way
> of thinking (or maybe I don't  want to scroll so much).
>
> When income comes in is when I actually use the budget to plan where the
> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
> Bills/Invoice feature to keep track of the bills that need to be paid, but
> they don't get paid until they are planned for.
>
> For monitoring purposes, I use the Budget Report to do exactly that. You
> can set it up to see a period before and after your current account period
> (mine being set at a quarter), which will show your carryover. I am always
> striving for a balanced budget (move/spend less money to make sure that the
> budget is balanced. But in theory, you could create a second report with a
> longer view (perhaps yearly) to see your overall progress with the period
> before.
>
> I hope this helps.
>
> On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>
>> Andre,
>>
>> Thank you for the response. For each two-week period within the quarter,
>> did you just have to copy the budget entries from each column to the next?
>> That is what I would like to avoid, if possible.
>>
>> I would like to use one budget so that it is easy to see carryover from
>> one budget period to the next. If I create a new budget for each quarter, I
>> don't know of a way to get cumulative surplus/deficit for each budget
>> category from the previous quarter.
>>
>> Thanks,
>> Patrick
>>
>> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
>> wrote:
>>
>>> Patrick,
>>> I made a template and under the Budget menu just make a duplicate/copy
>>> as needed (my accounting period is quarterly and the budgets are every two
>>> weeks).
>>>
>>>
>>> On Wed, Jan 9, 2019, 10:34 PM Patrick >>
 Hello,

 I recently started using GnuCash. Is there a way to copy one month's
 budget
 to the next month? I have a budget with a large number of entries, and
 copying each entry individually is somewhat cumbersome.

 Any help is appeciated.

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

>>>
>
> --
> Andre
>
>
>
___
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] Bank Reconciliation Report with Beginning and Ending Balances

[eNews]

I have run the reconciliation report for my checking account; however, it
only shows the "funds in" and the "funds out" for the period.  I was hoping
for a more traditional reconciliation that shows the ending balance that I
can agree to my bank statement. If this can be done, how do I do it?  [I am
using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+
(2018-06-24)]

 

My comments are marked as:  

 



 

 

I searched for an existing string of comments on this matter and did not
find any.  If it has already been discussed, perhaps you could explain how I
could find it on my own.

 

Thank you,

Kate



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


image006.emz
Description: Binary data


image008.emz
Description: Binary data


image010.emz
Description: Binary data


image012.emz
Description: Binary data
___
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 reconciled transactions changes reconcile status

[Adrien Monteleone]

I would say date is one of those ‘depends’ cases. Changing it to another date 
within the same period won’t alter the reconciled balance, but changing it to a 
date outside of the reconciled period of course would. Trying to determine the 
date range a reconciliation was done for is asking too much most likely. So for 
simplicity, I’d leave it as is and let it unset the flag. With a warning, the 
user can decide on the spot to proceed and then re-reconcile right away to keep 
things tidy if this is an in-period date change.

I know more options means more code and more mental ‘cost’ but should perhaps 
this list be a set of options? If the user sets the options for their needs, 
they get a warning and the flag unsets. Otherwise, the default could sanely be 
to only unset the flag on date and amount. This might also work as a poor 
substitute for the ’security’ that some users ask for. If they have the option 
to unset the reconcile flag based on the transaction data they prefer, they 
might set it for everything. Then they can easily see with a reconcile filter 
if any transactions before the last reconciliation have been edited. (not 
perfect or ideal as it won’t prevent the change or tell you who made it)

Just a thought. I certainly am not advocating to create more work.

Regards,
Adrien

> On Jan 11, 2019, at 3:37 AM, Geert Janssens  
> wrote:
> 
> Hi all,
> 
> Thanks for the feedback, though I preferred to have received it while we were 
> actually working in that area :(
> 
> So really the only elements to reconcile on are transaction date and amount ?
> 
> Geert
> 
> Op vrijdag 11 januari 2019 03:36:15 CET schreef David Cousens:
>> Geert,
>> 
>> My opinion is much the same as Adriens' . The critical information you are
>> verifying against a statement is:
>> 
>> the timing (date and/or time) and
>> amount of the split to the account being reconciled.
>> 
>> Where data has been manually eneterd into GnuCash, the date may not be the
>> same necessarily as a statement as they will record the date and/or time
>> relevant to the handling of the transaction in their hands which may be
>> different from your own -  can be importnat for contracts for example.
>> 
>> I also feel that changing the amount in splits other than the split to the
>> reconciled account should not trigger unreconciliation of a reconciled split
>> ( which is the crrent position).
>> 
>> Any other information, while it may assist with identifying reconciliation
>> (e.g description memo etc), it is not the information which is being
>> reconciled itself.
>> 
>> In addition the critical information that defines that transaction's
>> identity, i.e. internal GnuCash transaction ID needs to be protected.
>> 
>> My bank doesn't provide in a statement their transaction ID's, or
>> transaction time and any description provided is from their perspective not
>> mine. My statement is pretty minimal:
>> 
>> Date   DescriotionDebit   Credit   Balance
>> Balance State (Db/Cr)
>> 
>> It is interesting that the OFX files I import from my bank often contain
>> much more information than the statements. They however are created on
>> demand whereas my statement often comes out a few weeks weeks after the end
>> of the relevant period and does not contain any pending events etc and any
>> clearances have been resolved. With electronic clrearance times now being
>> very short, these sort of discrepancies in accounts are now generally fairly
>> infrequent now
>> 
>> While accounts with bank statements (asset, liabilities) will be the most
>> commonly reconciled accounts, they are not necessarily the only ones. In the
>> days when I ran a business, I could request and received statements form
>> vendors and supplied them to customers to verify that we agreed on what was
>> owed to them or by them. If you track income or expense by customer or
>> vendor then you may also find yourself reconciling these, especially if
>> there is a dispute.
>> 
>> 
>> David Couens
>> 
>> 
>> 
>> -
>> 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.
> 
> 
> 
> 
> ___
> 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 o

Re: [GNC] Copy a month's budget

[Adrien Monteleone]

Personal preference.

For example, depending on the nature of the conversation, (like for multiple 
points/questions to discuss) I’ll use in-line, but I usually use top posting, 
as in this case.

While I see it occasionally, bottom-posting is the least used in these parts as 
it means you have to scroll to read the reply.

Regards,
Adrien

> On Jan 11, 2019, at 11:08 AM, Patrick  wrote:
> 
> Andre,
> 
> Thanks for the advice. This definitely gives me some possible alternatives
> to consider.
> 
> I am not able to find a page that gives the etiquette rules for this
> mailing list. Is top-posting preferred on this list? I noticed that some
> people do and some don't.
> 
> Thanks,
> Patrick
> 
> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell  wrote:
> 
>> Patrick,
>> The method that I use for budgeting is well "old-fashioned". My salary is
>> paid every fifteen days and my wife once a month, hence the two-week setup,
>> and the quarterly view because in my prior career we managed our P&Ls
>> monthly but with quarterly plans so mentally I am kind of used to that way
>> of thinking (or maybe I don't  want to scroll so much).
>> 
>> When income comes in is when I actually use the budget to plan where the
>> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
>> Bills/Invoice feature to keep track of the bills that need to be paid, but
>> they don't get paid until they are planned for.
>> 
>> For monitoring purposes, I use the Budget Report to do exactly that. You
>> can set it up to see a period before and after your current account period
>> (mine being set at a quarter), which will show your carryover. I am always
>> striving for a balanced budget (move/spend less money to make sure that the
>> budget is balanced. But in theory, you could create a second report with a
>> longer view (perhaps yearly) to see your overall progress with the period
>> before.
>> 
>> I hope this helps.
>> 
>> On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>> 
>>> Andre,
>>> 
>>> Thank you for the response. For each two-week period within the quarter,
>>> did you just have to copy the budget entries from each column to the next?
>>> That is what I would like to avoid, if possible.
>>> 
>>> I would like to use one budget so that it is easy to see carryover from
>>> one budget period to the next. If I create a new budget for each quarter, I
>>> don't know of a way to get cumulative surplus/deficit for each budget
>>> category from the previous quarter.
>>> 
>>> Thanks,
>>> Patrick
>>> 
>>> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
>>> wrote:
>>> 
 Patrick,
 I made a template and under the Budget menu just make a duplicate/copy
 as needed (my accounting period is quarterly and the budgets are every two
 weeks).
 
 
 On Wed, Jan 9, 2019, 10:34 PM Patrick >>> 
> Hello,
> 
> I recently started using GnuCash. Is there a way to copy one month's
> budget
> to the next month? I have a budget with a large number of entries, and
> copying each entry individually is somewhat cumbersome.
> 
> Any help is appeciated.
> 
> Regards,
> 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.
> 
 
>> 
>> --
>> Andre
>> 
>> 
>> 
> ___
> 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] Bank Reconciliation Report with Beginning and Ending Balances

[Mark Phillips]

Kate,

Are you trying to reconcile your account? If so, then select your account
tab and go to Actions -> Reconcile for an interactive account
reconciliation process for your account.

If you want a report post-reconciliation of your account, I normally use
Reports -> Transactions, then use the report configuration options to
define what I want in the report.

Sorry to be shooting in the dark for your answer. Your images did not come
through.

Mark

On Fri, Jan 11, 2019 at 12:11 PM eNews  wrote:

> I have run the reconciliation report for my checking account; however, it
> only shows the "funds in" and the "funds out" for the period.  I was hoping
> for a more traditional reconciliation that shows the ending balance that I
> can agree to my bank statement. If this can be done, how do I do it?  [I am
> using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+
> (2018-06-24)]
>
>
>
> My comments are marked as:
>
>
>
>
>
>
>
>
>
> I searched for an existing string of comments on this matter and did not
> find any.  If it has already been discussed, perhaps you could explain how
> I
> could find it on my own.
>
>
>
> Thank you,
>
> Kate
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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] Bank Reconciliation Report with Beginning and Ending Balances

[Adrien Monteleone]

Kate,

I did see the images, so I understand what you are looking for, but I can’t 
seem to make the report produce anything similar.

Here are your options:

1. The reconciliation tool provides this info at the bottom right, along with 
the variance of what has been reconciled to what should be reconciled. 
(indicating transactions left to reconcile, or an adjusting entry needs to be 
made) Note that you can leave that window open as long as you like. You don’t 
have to complete the reconciliation in one go.

2. Run the reconciliation report, and either export or copy/paste to a 
spreadsheet and add the formulas for the additional calculations you want to 
see. If you really need a piece of paper with this info, this is the only 
route. But if that isn’t important, the reconciliation tool is the better 
option.

With regard to searching the mailing list archives, prefix your search terms 
with “site:lists.gnucash.org ” (without the quotes) and most search engines 
will limit your search to that domain rather than the entire internet. Some 
search engines like DuckDuckGo have shorthand versions of the “site:” part. 
(which is pretty short already) For this example, keep your query simple and 
then narrow down as needed. I’d start with “site:lists.gnucash.org 
reconciliation”.

Regards,
Adrien

> On Jan 11, 2019, at 1:11 PM, eNews  wrote:
> 
> I have run the reconciliation report for my checking account; however, it
> only shows the "funds in" and the "funds out" for the period.  I was hoping
> for a more traditional reconciliation that shows the ending balance that I
> can agree to my bank statement. If this can be done, how do I do it?  [I am
> using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+
> (2018-06-24)]
> 
> 
> 
> My comments are marked as:  
> 
> 
> 
> 
> 
> 
> 
> 
> 
> I searched for an existing string of comments on this matter and did not
> find any.  If it has already been discussed, perhaps you could explain how I
> could find it on my own.
> 
> 
> 
> Thank you,
> 
> Kate
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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] Import QIF error (from Android to Windows)

[michalbike]

There is final step during import. Finally, I can't import QIF file.

 



--
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] Import QIF error (from Android to Windows)

[David Cousens]

This tends to suggest that there is a problem with the format of the file or
with GnuCash's parsing of the file. 

The following text file  file-format.txt
  
contains what is known about the QIF format. It is a proprietary format and
does not have a well standardized specification and varies in its
implementation as noted in the attached file.  It is not clear but you seem
to be importing a QIF file exported by the GnuCash version on Android. This
program is not maintained or produced by the GnuCash team. It is a separate
product and does not use the same code base.

The first thing to do will be to check the GnuCash log files (it may be
worth enabling logging and debug information) and rerunning the import in
GnuCash (https://wiki.gnucash.org/wiki/Logging). You may also find the
following information on file locations useful in locating the log files
(https://wiki.gnucash.org/wiki/Configuration_Locations). This may give you
some information about where in the import process GnuCash is failing and
possibly enough to identify where in the imported file it is failing.

The QIF file can be examined with a text editor. Make a copy of the file and
only work on a copy not the original. Once you have identified where in the
file it is failing, locate that point in the file and compare the syntax
with that described in the above document. If it is a syntax element missing
you may simply be able to correct it and then try importing the modified
copy.

Are you able to import files exported from the most recent Android GnuCash
version (which version?) into versions less than 2.19 on your Windows 10
system? 
Is it only failing for Windows 10 GnuCash V3.0 and up? 

This will help in more clearly identifying whether it is a bug in the latest
Windows 10 GnuCash version causing the problem or whether the problem lies
with the export from the Android program.

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] Copy a month's budget

[Patrick]

Ok, thanks. Yes, I'd always appreciated that about top-posting - not having
to scroll to the bottom. I'd just recalled in the past having used mailing
lists that didn't allow it.

Thanks,
Patrick

>Personal preference.
>
>For example, depending on the nature of the conversation, (like for
multiple points/questions to discuss) I’ll use in-line, but I usually use
top posting, as in this case.
>
>While I see it occasionally, bottom-posting is the least used in these
parts as it means you have to scroll to read the reply.
>
>Regards,
>Adrien
>
>> On Jan 11, 2019, at 11:08 AM, Patrick  wrote:
>>
>> Andre,
>>
>> Thanks for the advice. This definitely gives me some possible
alternatives
>> to consider.
>>
>> I am not able to find a page that gives the etiquette rules for this
>> mailing list. Is top-posting preferred on this list? I noticed that some
>> people do and some don't.
>>
>> Thanks,
>> Patrick
>>
>> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell 
wrote:
>>
>>> Patrick,
>>> The method that I use for budgeting is well "old-fashioned". My salary
is
>>> paid every fifteen days and my wife once a month, hence the two-week
setup,
>>> and the quarterly view because in my prior career we managed our P&Ls
>>> monthly but with quarterly plans so mentally I am kind of used to that
way
>>> of thinking (or maybe I don't  want to scroll so much).
>>>
>>> When income comes in is when I actually use the budget to plan where the
>>> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
>>> Bills/Invoice feature to keep track of the bills that need to be paid,
but
>>> they don't get paid until they are planned for.
>>>
>>> For monitoring purposes, I use the Budget Report to do exactly that. You
>>> can set it up to see a period before and after your current account
period
>>> (mine being set at a quarter), which will show your carryover. I am
always
>>> striving for a balanced budget (move/spend less money to make sure that
the
>>> budget is balanced. But in theory, you could create a second report
with a
>>> longer view (perhaps yearly) to see your overall progress with the
period
>>> before.
>>>
>>> I hope this helps.
>>>
>>> On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>>>
 Andre,

 Thank you for the response. For each two-week period within the
quarter,
 did you just have to copy the budget entries from each column to the
next?
 That is what I would like to avoid, if possible.

 I would like to use one budget so that it is easy to see carryover from
 one budget period to the next. If I create a new budget for each
quarter, I
 don't know of a way to get cumulative surplus/deficit for each budget
 category from the previous quarter.

 Thanks,
 Patrick

 On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
 wrote:

> Patrick,
> I made a template and under the Budget menu just make a duplicate/copy
> as needed (my accounting period is quarterly and the budgets are
every two
> weeks).
>
>
> On Wed, Jan 9, 2019, 10:34 PM Patrick 
>> Hello,
>>
>> I recently started using GnuCash. Is there a way to copy one month's
>> budget
>> to the next month? I have a budget with a large number of entries,
and
>> copying each entry individually is somewhat cumbersome.
>>
>> Any help is appeciated.
>>
>> Regards,
>> Patrick
>> ___
>> gnucash-user mailing list
>> gnucash-user at 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.
>>
>
>>>
>>> --
>>> Andre
>>>
>>>
>>>
>> ___
> gnucash-user mailing list
> gnucash-user at 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] Import a transaction from a CSV file with both the debit and credit account set

[Patrick]

Hello,

When I am importing transactions from a CSV, I see a way to set one of the
accounts involved with the transaction, but not the other account. The only
way I know to set the other account is to do it manually in the import
wizard for each transaction. Is there a way to set both accounts in the CSV
file so that I don't have to do it manually for each transaction?

I like to keep a log of transactions in a CSV file separately from my
Gnucash file, and then import that CSV. If Gnucash doesn't allow setting
both accounts in a CSV file, maybe there is a way to use the QIF format to
set both accounts and then import the QIF file? I am open to that, if that
is possible.

Regards
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] Retained Earnings Loss account appears after closing out year

[Christopher Lam]

In the balance sheet, Retained Earnings is calculated as the difference 
of non-void balances between the selected income and expense accounts as 
of the balance-sheet date.


There must be an errant transaction associated with the pre-payment 
somewhere in your books?


C

On 11/1/19 5:49 am, bwiper79 wrote:

Hello!

I'm hoping somebody may have run into this and can help me out. The balance
sheet is balanced as per auditor and year end adjusting entries, but for
some reason I've got $5.24 stuck in retained earnings losses after closing
out the year to RE.

The Total Equity value is correct, but only with the $5.24 loss displayed.

I found a the invoice that was $5.24 + $0.79 tax.

My fiscal year starts 10/1/2017 but when I first started using Gnucash, I
entered the date of a pre-incorporation/start of year date as 4/1/2017.

I deleted the payment transaction, which for some reason I marked as paid
6/8/2018 but it was posted as a pre-payment and not applied to the invoice.

I then deleted the pre-payment via journal, and I think this may be where I
went wrong, then went in a paid the invoice using the AP module.

The tax portion seems to be fine, but I'm left with this $5.24, which I
think is associated with the pre-payment I deleted via journal instead of AP
module.

Any ideas how I can fix this to make my statement look pretty, not
displaying the retained losses automatic sub-total by bringing it to $0?

Thanks,
Ben



--
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] Currencies not being converted

[Liz]

On Fri, 11 Jan 2019 08:48:54 -0800
John Ralls  wrote:

> Last warning: Copy the list on all replies or you go to spam and get
> no more replies.

and if you are not a list member then John won't get the reply until
your message is released by me.
And if I've had to process too many of your messages I may be tired and
grumpy ;)

Liz
___
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] Copy a month's budget

[Liz]

On Fri, 11 Jan 2019 13:17:33 -0600
Adrien Monteleone  wrote:

> Personal preference.
> 
> For example, depending on the nature of the conversation, (like for
> multiple points/questions to discuss) I’ll use in-line, but I usually
> use top posting, as in this case.
> 
> While I see it occasionally, bottom-posting is the least used in
> these parts as it means you have to scroll to read the reply.
> 
> Regards,
> Adrien

There is another version again, where you remove all the text which is
unneeded and type at the bottom.

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