Reports issues

[Finbar Mahon]

I am trying to generate some reports, to see how it works, as a very new 
user.


I am trying to produce a simple profit and loss. Every time I go to 
report>profit and loss, it  seems to do some actions and then hangs. If 
I try to get help or do anything else it stops and says not responding.


Am I doing something wrong/

___
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 record Personal income tax ?

[Finbar Mahon]

Strike me that a sub category to the entry for 'expenses taxes' would do 
the trick? Cumulated, it should be enough if you calculate based on 
previous years?


Personally, I dump money every so often into a savings a/c and take it 
back out to pay the robbers


Downside is that the rate of return is so bad it is hardly worth the effort.

On 20/03/2020 00:23, David Cousens wrote:

Long,
Most personal income tax in many jurisdictions is based on a concept of
taxable income - i.e income sources which are subject to tax  and specific
expenses ( usually on the basis that they are incurred in earning that
income) which are able to be deducted from that income to provide a nett
income which is assessed for tax payable. What income is taxable and what
deductions are allowable will depend upon your local taxation legislation
for which you will need professional advice.

To be able to track and make provision so you have the money available when
taxes are due you will need to partition your income,i.e. have separate sub
accounts  for income subject to taxation and income which is not. Similarly
with expenses you need to establish subaccounts for expense categories which
can be legitimately and legally deducted from your taxable income and those
which can't.  the difference between your income subject to tax and
deductible expense sub account totals will then give you an estimate of the
taxable income against which you will be assessed. How accurate this will be
will depend on how accurate your partitioning of income and expenses is and
what other processes may affect your tax paid ( often rebates and tax
offsets for specific purposes.

Accountants usually create specific liability account to identify future
expenses that may be accruing like taxation. You may also want to set aside
money in a separate bank account specifically to pay you taxes when they
come due or you may want to keep the money in your bank account and just be
aweare that you have sufficient funds available to cover the taxes when they
become due. If you want to do this on a regular basis, e.g. monthly, you
will have to use the taxable income for the previous month and calculate the
tax you will expect to pay on the taxable income for that month.
Transactions similar to the following will achieve that:
  Dr
Cr
Asset:Bank:Checking   xx
Asset:Bank:TaxProvision  xx
Liability:Provision for Income Tax  xx
Expense:Provision for Income Taxxx

where xx is the amount of tax you have calculated is due for that month. If
you do not want to keep the funds in a separate account just delete the
first two splits in the above transaction. The expense account would have to
fall under the non tax deductible sub-account.

At the end of the year when your tax is actually calculated and assessed you
would make adjustments to the liability  and expense accounts  (and also
transfer to or from a specific asset account if you are using it) to reflect
any differences from your estimates during the year and then clear the
liability when you actually pay your tax  (debit the liability by the amount
paid and credit either your check account or a specific asset  account you
have created for the tax provision).

This is just an outline of a general approach to deal with taxation accrual
as your income is accrued. It would have to be adjusted to suit your
specific circumstances and taxation legislation (and local accounting
practice) so consult your accountant for that. Details of how to calculate
the tax similarly depend on your specific tax laws.

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-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] Reconciliation

[Finbar Mahon]

I have had a similar experience. Afaicr, the starting balance never 
coincided, so I thought it was because of (particularly?) income 
transaction(s) that hadn't cleared. I was able after a bit of detective 
work, based on my Quicken experiences, to find the anomalies. Now 
however, like Jack, it is always awry. I am only able to 'reconcile' by 
creating an 'orphan'


Most of the time I don't bother, if the difference is small, assuming it 
to be finger probs in entering data, but I do wonder why the balances 
don't align.


I have found that forgetting to 'c' items in the banks a/c, causes 
issues with reconciling.


Finbar


On 21/11/2019 17:11, Jack Lockard wrote:


For the past few months the starting balance shown by GNUcash did not match 
with the starting balance on the bank statement even though the reconciled 
balance shown by GNUcash for the previous months statement did indeed match the 
bank statement. I have completed the new reconciliation and the closing balance 
would again match with the bank statement.  I could not figure out what was 
going on but since the closing balance matched the bank statement I did not 
pursue it further.

Until now. This month the starting balances do not match and it will not 
reconcile as it has in the past. The amount shown as out of balance does not 
match the difference between GNUcash's starting balance and the Banks starting 
balance. Something is out of whack someplace and I have no idea where to even 
begin to get it corrected.

Any ideas? I could just start a new checking account and start fresh, but I 
have 7 years' worth of transactions in the checking account and would rather 
not lose that data.

Jack
___
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] Non-cash charity contributions

[Finbar Mahon]

The miserable Revenue in Ireland, where I tax reside, used to have the 
same but they restrict in now


On 24/11/2019 18:58, Art Chimes wrote:

In the US at least, many donations of stuff — other than money — to
charities is tax-deductible.

___
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] v3.8

[Finbar Mahon]

I very much appreciate, and depend a lot on, Gnucash. But could I make a 
small recommendation?


When a new version is launched would it be possible to announce when It 
works for 'ordinary' users?


I have no trouble waiting until it is 'clean'

HYN 2020 to all.

Finbar

On 01/01/2020 00:34, David Cousens via gnucash-user wrote:

It should but you will have to install all the dependencies and their
development headers to build successfully. There is a breakout page from the
building instruction which gives you the dependencies to install. (There are
occasionally some that are not covered as it depends on what the particular
Linux distribution installs as standard and what libraries have been
installed with other software but it is now pretty complete).

When you run cmake, it will stop with an error if anything is missing.
Identify the missing dependency or come back to the list, install it and
rerun cmake until it completes with out error. Library names can sometimes
vary slightly between distributions to complicate matters (usually addition
of a version number or "lib" in front

apt-cache search  is a good way to find libraries with a slightly
different package name.



-
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] v3.8

[Finbar Mahon]

I fully appreciate everything you say. My suggestion was only posted to 
see if there was any way that 'amateurs' like myself who use it under 
Windows 10 on a PC, can feel happy.


Of course there are no guarantees, even with expensive bought software, 
that is why I left more than one other accounting product. I normally 
wait to see if there is an 'uproar' even with MS so-called upgrades.


David's explanation and sequencing information in the post above is 
invaluable, than you so much.


Finbar

On 01/01/2020 17:37, Greg Feneis wrote:

Happy New Year, All

Perhaps a better strategy is for the ordinary user to do the waiting.  As
is the case with a variety of software, both FOSS and commercial, you take
some risk when immediately installing and running newly released software.
It's just too complicated to test for all possible contingencies.  Seems
like the developers have to make the best compromise between development
efforts and checking for every possible issue.  Don't forget, everyone
working on this project is doing it to benefit everyone for free.  They
somewhat rely on users to test and report back about their issues.



___
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] 3.8 and character set sizing

[Finbar Mahon]

Hello,

Congrats on 3.8, downloaded and installed and 3.x removed!

Small question, is there any way to increase the character set size? I 
cannot seem to find any instructions, apart from printing.


Thanks

___
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] 3.8 and character set sizing

[Finbar Mahon]

Thanks, if I ever get 2019 sorted, i.e. reconciled and tax 'massaged', 
I'll look there.


3.x means I cannot remember which version I had installed, and was 
removed, before 3.8 was installed.


Finbar

On 08/02/2020 18:00, John Ralls wrote:



On Feb 8, 2020, at 1:28 AM, Finbar Mahon  wrote:

Hello,

Congrats on 3.8, downloaded and installed and 3.x removed!

Small question, is there any way to increase the character set size? I cannot 
seem to find any instructions, apart from printing.

3.x?

For appearance adjustment see https://wiki.gnucash.org/wiki/GTK3.

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.

[GNC] Hangs on startup

[Finbar Mahon]

I don't have a P+L for 1/1/192020!!

Hangs at this point, most times, sometimes loads the current operations.

Ideas?

___
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] Hangs on startup

[Finbar Mahon]

I attached a capture of the startup screen, but it didn't make it. It 
showed a "hang" while attempting to load a P+L I don't have, named P+L 
for 1.1.2020



On 03/08/2018 16:18, Finbar Mahon wrote:

I don't have a P+L for 1/1/192020!!

Hangs at this point, most times, sometimes loads the current operations.

Ideas?

___
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] Column labels in Credit Card accounts

[Finbar Mahon]

I tried the suggestion, but it doesn't seem to work with "normal" 
accounts, bank etc.


Barry


On 18/11/2018 19:53, Diane Trefethen wrote:

Dear Maf. King,

Thank you for your very helpful answer.

Diane


On 11/17/2018 04:22 PM, Maf. King wrote:

On Saturday, 17 November 2018 19:05:18 GMT Diane Trefethen wrote:

Dear Fellow Users,


Second: My Credit Card type account registers display Debits and
Credits, not Charges and Payments. Why?



Hi,

Edit -> Preferences -> Accounts -> Use Formal Accounting labels

HTH,
Maf.




___
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] Reconciling different periods?

[Finbar Mahon]

Hi,

My reconcile is a bit erratic. So, I thought of trying to find the error 
by reconciling for different periods. If I put in the date for the last 
statement for the period I want to check, can I just put in an amount as 
the ending balance that coincides with the starting period and that way 
check on a period by period basis?


I know it sounds complicated but I cannot think of a better way of doing it.

Thanks

___
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] Reconciling different periods?

[Finbar Mahon]

Thanks, Michael, I have been trying that using end March of this year as 
the last 'OK' date but doing it up to latest balance seems to catch 
other errors, so I  was wondering if  I could 'stage' the process.


Looks like D's reply indicates I could do it by varying the closing 
balance to coincide with one I am happy with. Maybe a slight problem if 
the closing balance is duplicated elsewhere? Maybe unlikely.


In fact by a combination of the two replies I can go back to the last 
'good' situation and use the closing balance there as a starting point?


I'll give the ending balance a try.

F

On 11/12/2018 17:56, Michael Hendry wrote:

On 11 Dec 2018, at 16:40, Finbar Mahon  wrote:

Hi,

My reconcile is a bit erratic. So, I thought of trying to find the error by 
reconciling for different periods. If I put in the date for the last statement 
for the period I want to check, can I just put in an amount as the ending 
balance that coincides with the starting period and that way check on a period 
by period basis?

I know it sounds complicated but I cannot think of a better way of doing it.

Thanks

Afternoon, Finbar.

As a user of GC since 2010 for my personal accounts, I would advise that you 
step back from this precipice before you jump over it!

I urge you go back far enough in your accounts to get to a bank statement that 
is in exact agreement with your accounts, then work your way systematically 
forward from that date, correcting any erroneous entries in your accounts as 
you go.

Ideally, you should mark everything beyond the reconciliation date as 
“unreconciled” and go forward from there - it’s very easy to click on a 
duplicate transaction and mark it as reconciled, or to miss digit 
transpositions and other typing errors.

Best of luck!

Michael




___
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] Reconciling different periods?

[Finbar Mahon]

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. So, 
what I wanted to do was go back to the last 'good' reconciliation that I 
had on the printed bank statements for that a/c and work forward to 
discover where things had gone wrong. I suspect a date anomaly, an entry 
on the wrong date, maybe even the wrong year, finger problems :-)


So, the ideas on this thread indicate the way to do it is to ensure the 
balance at the end of a good reconciliation is coincident with the bank 
statement and look to see what income/expenditures are listed in the 
attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this year as the 
last 'OK' date but doing it up to latest balance seems to catch other errors, 
so I  was wondering if  I could 'stage' the process.

Looks like D's reply indicates I could do it by varying the closing balance to 
coincide with one I am happy with. Maybe a slight problem if the closing 
balance is duplicated elsewhere? Maybe unlikely.

In fact by a combination of the two replies I can go back to the last 'good' 
situation and use the closing balance there as a starting point?

I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what we in the 
UK call a “current account”.

For this example, consider that your financial year starts on the 1st January 
2018, and you have a bank statement for the period ending 31 December 2017. 
This will have a figure (say £x) for the balance on 31 December 2017.

When you create this bank account in GnuCash, you set it up with a starting 
balance of £x.

Throughout January and into February you enter every transaction that involves 
that account (payments into the account of cash and cheques, withdrawals in 
cash, by cheque, direct debit, and so on).

When your statement arrives for the month ending 31st January, go ahead with 
the reconciliation. Because there are sometimes delays in transactions hitting 
the bank account, Gnucash will have the correct starting balance, but may have 
calculated the ending balance for the month incorrectly - let’s say you issued 
a cheque on 28th January and the recipient hasn’t paid it into his bank account 
yet. You should enter the bank’s version of the final balance for January into 
the “Reconcile information” in the box marked “Ending Balance”.

Now press OK, and work your way through the reconciliation procedure, ticking 
the box against each transaction on the screen that matches one on the bank 
statement, which you should mark as reconciled in pencil.

Once you have ticked all the transactions on the statement you should have a 
“Difference” at the bottom right of the Reconcile window of £0.00.

If there is a discrepancy (i.e. “Difference” is non-zero), you have a problem 
which you need to resolve NOW, because in my experience banks and computers can 
add or subtract quite accurately, and you’ve just ticked the computer’s and the 
bank’s versions of the same transactions and they don’t match!

Occasionally, you’ll discover that there’s a missing transaction in your 
records, leaving an unticked transaction in the bank statement. This could be a 
fraudulent transaction, but is more likely to be a standing order you’d 
forgotten to enter.

Unless your bank account has very little in the way of transactions, you’ll 
almost certainly have several transactions recorded in GC which haven’t been 
ticked - like the unpresented cheque.

Once you’ve cleaned up the reconciliation for January, wait for the February 
bank statement and reconcile that with GC.

If you’re catching up on reconciliation a month or two late, don’t rush it! 
Complete one reconciliation by correcting any errors before you move on to the 
next one.

Pardon me if I have misjudged your situation and made you feel you’re being 
patronised,

Michael








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

[GNC] Getting the date order in a report ?

[Finbar Mahon]

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

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

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


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


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


Ideas?

Thanks, and best wishes of the season, Barry

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

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

[Finbar Mahon]

Thanks, but I am not too sure what options I should chose to get the 
registry sort order.


I used the edit>report options and after bit of fiddling I have a result 
by month in 'proper' date order.


That is OK, but I would like to get Source of Salary from Income > 
Salary and annual/by month, in date order.


The selection I have under report options > sorting is -

Primary Key - Account Name; Primary Subtotal clicked; Primary Sort order 
-  Ascending; Secondary Key - date; Secondary Subtotal for date key - 
monthly


I am using 2.6.19 on Windows 10

Barry

On 24/12/2018 20:18, David Carlson wrote:
I am not sure if this will help.  Check that the register sort order 
is set to date posted.  If that does not work please let us know which 
GnuCash release you are using and your operating system.


David C

On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon <mailto:mahon.fin...@neuf.fr> wrote:


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

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

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

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

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

Ideas?

Thanks, and best wishes of the season, Barry

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] Updating advice

[Finbar Mahon]

Hello,

I want to do a backup of the current installation as of 31.12.2018 and 
install the latest version (3.3?) from 1.1.2019. First is this a 
worthwhile action and is there any particular process I should follow? I 
have looked around the documentation but I didn't find a "how to"


I am using 2.6.19 on Windows 10.

TIA, Barry

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

Re: [GNC] Updating advice

[Finbar Mahon]

Sorry, I meant doing the first option (as I  should have been:-[) before 
updating to 3.3.


Thanks for the information. I'll have a look at the wiki.

B

On 30/12/2018 10:57, Colin Law wrote:

On Sun, 30 Dec 2018 at 09:49, Finbar Mahon  wrote:

Hello,

I want to do a backup of the current installation as of 31.12.2018 and
install the latest version (3.3?) from 1.1.2019. First is this a
worthwhile action and is there any particular process I should follow? I
have looked around the documentation but I didn't find a "how to"

Do you mean backing up your accounts data?  If so then that is
something everyone should already be doing regularly.  A computer or
disk may go up in smoke (literally or metaphoricallly) at any time,
taking all your account history with it if you are not doing regular
backups.  See this for information on what to backup.
https://wiki.gnucash.org/wiki/Backup

If you mean you want to backup the software itself so you can easily
revert to the old version should you need to then that is not normally
something one would do, though I believe Windows has a mechanism for
keeping a snapshot of the current system so you can revert if you want
to.  You can always uninstall the latest and install an earlier one if
you want to, though it is not guaranteed that accounts data which have
been used with 3.3 will be usable with an earlier version, so you
might have to go back to an earlier backup of your accounts

Colin


I am using 2.6.19 on Windows 10.

TIA, Barry

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

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

Re: [GNC] Updating advice

[Finbar Mahon]

Sorry, I'm afraid you are dealing with a neophyte here.

I read the wiki, and I looked for the data files but didn't find 
anything that looked like 'gnucash.20140131150812.gnucash.'


I recall having seen on here various discussions on backing up - is 
there a place where I could find a set of questions/answers on doing a 
backup?


TIA for any advice.

Barry

On 30/12/2018 11:50, Finbar Mahon wrote:
Sorry, I meant doing the first option (as I  should have been:-[) 
before updating to 3.3.


Thanks for the information. I'll have a look at the wiki.

B

On 30/12/2018 10:57, Colin Law wrote:

On Sun, 30 Dec 2018 at 09:49, Finbar Mahon  wrote:

Hello,

I want to do a backup of the current installation as of 31.12.2018 and
install the latest version (3.3?) from 1.1.2019. First is this a
worthwhile action and is there any particular process I should 
follow? I

have looked around the documentation but I didn't find a "how to"

Do you mean backing up your accounts data?  If so then that is
something everyone should already be doing regularly.  A computer or
disk may go up in smoke (literally or metaphoricallly) at any time,
taking all your account history with it if you are not doing regular
backups.  See this for information on what to backup.
https://wiki.gnucash.org/wiki/Backup

If you mean you want to backup the software itself so you can easily
revert to the old version should you need to then that is not normally
something one would do, though I believe Windows has a mechanism for
keeping a snapshot of the current system so you can revert if you want
to.  You can always uninstall the latest and install an earlier one if
you want to, though it is not guaranteed that accounts data which have
been used with 3.3 will be usable with an earlier version, so you
might have to go back to an earlier backup of your accounts

Colin


I am using 2.6.19 on Windows 10.

TIA, Barry

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

___
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] Location of GnuCash data files

[Finbar Mahon]

Of course! I found everything since Feb 2018! Many thanks and a Happy 
New Year!


Off to load 3.3, I hope that command works there too.

Barry

On Dec 31, 2018, at 2:20 PM, David Carlson  
wrote:


The thread GNCupdating advice seems to have answers that could apply 
to this thread.


Adding to both: In the release 2.6.xx family, a simple method to 
find the last used data file is to start the File > Save as process 
and see where GnuCash wants to put the new file. Then cancel before 
actually saving.


David C


___
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] GNU generated report in HTML to XL

[Finbar Mahon]

Hello,

I exported a GNUCash report to HTMl, but I don't seem to be able to 
import it to LibreOffice Calc, the LibreOffice xl equivalent.


Does anybody know if I must use 'real' MS XL to receive the HTML file? 
In LibreOffice you can save calc files in MS format. Are there any 
special tricks for importing?


I am using 3.3 on Windows 10.

Thanks, Barry

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

Re: [GNC] GNU generated report in HTML to XL

[Finbar Mahon]

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p&l2018.html

If I try to cut and paste the data to a new libreoffice calc file I get 
only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.


I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'


There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:

Finbar,

You may need to first open a new blank spreadsheet then cut and paste 
from the html document into the spreadsheet rather than trying to 
directly open HTML with Calc.


My experience with LibreOffice Calc is that it will import several 
different kinds of files.  I use it regularly to convert transaction 
detail exports from a certain department store website to a form from 
which I can manually extract data to enter into GnuCash, although I 
have not figured out how to restructure it to use the CSV importer for 
that case.


David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon <mailto:mahon.fin...@neuf.fr>> wrote:


Hello,

I exported a GNUCash report to HTMl, but I don't seem to be able to
import it to LibreOffice Calc, the LibreOffice xl equivalent.

Does anybody know if I must use 'real' MS XL to receive the HTML
file?
In LibreOffice you can save calc files in MS format. Are there any
special tricks for importing?

I am using 3.3 on Windows 10.

Thanks, Barry

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


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

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

[Finbar Mahon]

Thanks, but I have found, via various 'tests', a set of options that 
works. It requires a bit of homework, trying various combinations.


IMO, the options under edit>report options are sufficient, if a bit 
laborious to set up. There is a 'bonus' if you have any spelling errors 
in transactions, for ex, they show up as new entries in a  report!


Thanks to all  for the suggestions. Happy New Year!

Barry

On 04/01/2019 02:16, Christopher Lam wrote:
This set of options sounds about right. What's the output? You can 
attach a screenshot, blanking out confidential data.

Don't forget to set General/Add options summary to 'always'

On Thu, 27 Dec 2018 at 17:47, Finbar Mahon <mailto:mahon.fin...@neuf.fr>> wrote:


Thanks, but I am not too sure what options I should chose to get the
registry sort order.

I used the edit>report options and after bit of fiddling I have a
result
by month in 'proper' date order.

That is OK, but I would like to get Source of Salary from Income >
Salary and annual/by month, in date order.

The selection I have under report options > sorting is -

Primary Key - Account Name; Primary Subtotal clicked; Primary Sort
order
-  Ascending; Secondary Key - date; Secondary Subtotal for date key -
monthly

I am using 2.6.19 on Windows 10

Barry

On 24/12/2018 20:18, David Carlson wrote:
> I am not sure if this will help.  Check that the register sort
order
> is set to date posted.  If that does not work please let us know
which
> GnuCash release you are using and your operating system.
>
> David C
>
> On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon mailto:mahon.fin...@neuf.fr>
> <mailto:mahon.fin...@neuf.fr <mailto:mahon.fin...@neuf.fr>> wrote:
>
>     Hello, this is not urgent, just so I don't forget.
>
>     I am trying to print a listing of salary payments for the year.
>
>     I have selected the description for the transaction report
and the
>     data
>     I want appears, fine.
>
>     However the dates are random, typically the output is date, the
>     description, the amount, but the sequence of the dates is
all over
>     the
>     place.
>
>     I've looked through and selected the various options I think I
>     need but
>     cannot find a way of getting things in date order.
>
>     Ideas?
>
>     Thanks, and best wishes of the season, Barry
>
>     ___
>     gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org <mailto: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 <mailto: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] GNU generated report in HTML to XL

[Finbar Mahon]

Hello again.

I think I solved the problem.

I did what David suggested, but copied the whole doc, title and 
all,after 'select all. Then I tried just the data, no title, it worked! 
Offered me all the 'paste' options in calc


Don't ask me why!

Thanks, Barry

On 03/01/2019 13:09, Finbar Mahon wrote:

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p&l2018.html

If I try to cut and paste the data to a new libreoffice calc file I 
get only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.


I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'


There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:

Finbar,

You may need to first open a new blank spreadsheet then cut and paste 
from the html document into the spreadsheet rather than trying to 
directly open HTML with Calc.


My experience with LibreOffice Calc is that it will import several 
different kinds of files.  I use it regularly to convert transaction 
detail exports from a certain department store website to a form from 
which I can manually extract data to enter into GnuCash, although I 
have not figured out how to restructure it to use the CSV importer 
for that case.


David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon <mailto:mahon.fin...@neuf.fr>> wrote:


    Hello,

    I exported a GNUCash report to HTMl, but I don't seem to be able to
    import it to LibreOffice Calc, the LibreOffice xl equivalent.

    Does anybody know if I must use 'real' MS XL to receive the HTML
    file?
    In LibreOffice you can save calc files in MS format. Are there any
    special tricks for importing?

    I am using 3.3 on Windows 10.

    Thanks, Barry

    ___
    gnucash-user mailing list
    gnucash-user@gnucash.org <mailto: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] Reconciliation Report -- Can't find transactions

[Finbar Mahon]

Wow, very comprehensive, love the colour scheme ;-)

On 06/01/2019 23:17, David Cousens wrote:

Steve,

The attached screenshot shows what I get and the Report Options setting I
used. Have you tried saving, closing GnuCash and Opening again? (I have
closed and reopened Gnucash since putting that data in 2 days ago).

screen_20180107.jpg


David



-
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] GNU generated report in HTML to XL

[Finbar Mahon]

I did post that  it worked for me by doing a copy and paste of the 
original exported report but not copying the title!


On 06/01/2019 16:55, Geert Janssens wrote:

On Thursday, January 3, 2019 5:33:06 PM CET David Carlson wrote:

I was able to run a quick test using release 2.6.17 in Ubuntu 16.04 and
found that first, when I tried to save a P&L report in HTML format GnuCash
did not append a .html suffix.  In Linux this did not create a problem, but
Windows did not recognize the file as html.  Appending ".html" to the
filename solved that problem.

Once I had appended ".html" to the filename I could open it in Firefox or
whichever browser and I could get a nice printout directly or select all
[ctrl-A, ctrl-C] and paste [ctrl-V] into a waiting new LibreOffice 6.0.7.3
Calc doc in WIN 7.


It should even be possible to  copy and paste directly from gnucash to
libreoffice as far as I know. The detour via firefox or similar is not needed.
That's only needed for a printout that's not cutting lines in half.

Geert


___
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

[Finbar Mahon]

Thanks all for the replies. Many many good ideas.

Personally, I think doing it with each bank statement as soon as 
received, with the relevant dates entered,  is the most foolproof, if 
boring, way to see what is happening.


Afaik, it is the best way to keep track of 'finger problems' putting 
stuff in the wrong place, wrong amount, etc., etc.


Barry

On 11/01/2019 20:18, Mark Phillips wrote:

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.


___
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] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

I understand the logic of what you describe, but, I started using 
GNUCash with effect from 1.1.2018.


The opening balance on the bank statement for one of the asset a/c was 
€3,986.22 and the ending balance on 16.2.2018 was €5,117.09


Gnucash shows the ending balance as €5,117.02 but the reconcile shows 
another figure of €1,674.47 as the opening balance (bottom right hand 
side) while the left hand panel (funds in) shows the correct opening 
balance


The outcome of the reconcile is the same as the opening balance above 
but now it is -ve!!


Confused :-(

On 19/01/2019 22:26, David Cousens wrote:

The reconciliation procedure works fine for me  on several bank accounts, my
credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and
V3.4 provided previous reconciliations of the account were correct and no
transactions have been accidentally unreconciled.

In the example you quote you have a starting difference of 72.15. The net
movement of 72.15  and an end balance of 144.30 which is as it should be:

closing balance = starting balance +funds in -funds out
144.30 = 72.15 + 331.12 - 258.97 = 114.30

You can only get a reconciliation difference of 0 if the starting balance
(generated by previous reconciliation) is actually the balance in your
account at the specified start date. AFAIK the starting balance shown in the
dialog is the reconciled balance at the end of the last reconciled period.
Any changes made to reconciled transactions before that date after they have
been reconciled will change the actual starting balance in the account from
the reconciled value. I think it was possible to make changes to reconciled
transactions in one register by editing one of the other splits to the
transaction in some earlier versions of GnuCash and this automatically
unreconciled the transaction. I think recent changes only unreconcile a
transaction if specific information about the transaction and/or the amount
of the split affecting the reconciled account are changed but not sure
whether this is the case for the current release or not.

First thing to check is for any unreconciled transactions before the start
date of the reconciliation you are having problems with. If you find any go
back and redo the reconciliations forward from the period which contained
the unreconciled transaction to make sure everything is correct. The
starting difference of 72.15 being the same as the difference in funds in
and funds out suggests some sort of regular transaction for 72.15 might be
unrecorded or unreconciled.
Good luck

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-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] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

I don't understand where you are seeing the figures you describe.  Can
you post a screenshot showing it?

This what I get at the bottom right hand side.

On 24/01/2019 17:51, D wrote:

As noted in the Tutorial, the opening balance in a reconciliation is 
immaterial. What matters is the ending balance. If they match, then you can 
finish reconciliation.

The Tutorial explains some of the circumstances that might cause an opening 
balance not to match.

David T.

On January 24, 2019, at 9:30 PM, Colin Law  wrote:

On Thu, 24 Jan 2019 at 13:59, Finbar Mahon  wrote:

I understand the logic of what you describe, but, I started using
GNUCash with effect from 1.1.2018.

The opening balance on the bank statement for one of the asset a/c was
€3,986.22 and the ending balance on 16.2.2018 was €5,117.09

Gnucash shows the ending balance as €5,117.02 but the reconcile shows
another figure of €1,674.47 as the opening balance (bottom right hand
side) while the left hand panel (funds in) shows the correct opening
balance

When you start a reconcile it should show the opening balance the same
as on your bank statement and you should manually enter the ending
balance to the value it shows on the bank statement.  Are you doing
that?

I don't understand where you are seeing the figures you describe.  Can
you post a screenshot showing it?

Colin


The outcome of the reconcile is the same as the opening balance above
but now it is -ve!!

Confused :-(

On 19/01/2019 22:26, David Cousens wrote:

The reconciliation procedure works fine for me  on several bank accounts, my
credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and
V3.4 provided previous reconciliations of the account were correct and no
transactions have been accidentally unreconciled.

In the example you quote you have a starting difference of 72.15. The net
movement of 72.15  and an end balance of 144.30 which is as it should be:

closing balance = starting balance +funds in -funds out
144.30 = 72.15 + 331.12 - 258.97 = 114.30

You can only get a reconciliation difference of 0 if the starting balance
(generated by previous reconciliation) is actually the balance in your
account at the specified start date. AFAIK the starting balance shown in the
dialog is the reconciled balance at the end of the last reconciled period.
Any changes made to reconciled transactions before that date after they have
been reconciled will change the actual starting balance in the account from
the reconciled value. I think it was possible to make changes to reconciled
transactions in one register by editing one of the other splits to the
transaction in some earlier versions of GnuCash and this automatically
unreconciled the transaction. I think recent changes only unreconcile a
transaction if specific information about the transaction and/or the amount
of the split affecting the reconciled account are changed but not sure
whether this is the case for the current release or not.

First thing to check is for any unreconciled transactions before the start
date of the reconciliation you are having problems with. If you find any go
back and redo the reconciliations forward from the period which contained
the unreconciled transaction to make sure everything is correct. The
starting difference of 72.15 being the same as the difference in funds in
and funds out suggests some sort of regular transaction for 72.15 might be
unrecorded or unreconciled.
Good luck

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

Re: [GNC] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

No, as I said in the original post, I started on 1.1.2018 with GNU, so 
the first entry in this a/c should be the opening balance for the a/c 
from the bank statement, €3986.22. The ending balance is correct.


Finbar

On 26/01/2019 18:12, Colin Law wrote:
Do the starting and ending balances shown there match the ones on the 
bank statement you are reconciling against?


Colin

On Sat, 26 Jan 2019 at 11:51, Finbar Mahon <mailto:mahon.fin...@neuf.fr>> wrote:


I don't understand where you are seeing the figures you describe.  Can
you post a screenshot showing it?

This what I get at the bottom right hand side.



___
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] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

OK,

As I said, I started on 1.1.2018 with 'nothing' I entered the closing 
balance for 2017 for the a/c and started entering transactions.


Unfortunately, coming from Quicken, I didn't do any reconciliations 
until about December. But casually examining the entries from time to 
time they seemed 'ok' just a few centimes 'off' probably due to finger 
problems, as I had also experienced with Quicken and sorted them at year 
end.


The Opening Balance in the latest iteration of reconcile was what I 
showed in the screen grab a while back -


While the a/c entries starting entry shows the bank balance figure 
€3986.22 and the €5.117.09 ending balance tallies with the bank 
statement..


Aha, maybe there is another issue. When I do, as you suggested, View > 
Filter By > Status > Reconciled I get nothing!! even when I just chose 
'reconcile' or 'select all'


:-( thanks for the help :-)
:-)



On 27/01/2019 10:46, Colin Law wrote:
On Sun, 27 Jan 2019 at 09:36, Finbar Mahon <mailto:mahon.fin...@neuf.fr>> wrote:


No, as I said in the original post, I started on 1.1.2018 with
GNU, so the first entry in this a/c should be the opening balance
for the a/c from the bank statement, €3986.22. The ending balance
is correct.


Actually you still haven't stated it clearly.  The question is what 
does the Opening Balance show when you reconcile?  If this is the 
first time you have reconciled it then it should show zero (unless the 
opening balance has been already reconciled).  If it is not zero then 
that means some transactions have already been reconciled (possibly 
accidentally).  If you go to the account and then View > Filter By > 
Status > Reconciled then it should show you just the reconciled 
transactions.  Clear the reconcile state on all these and you should 
be good to start the reconcile with a starting balance of zero.  Then 
the Opening Balance in the account should match the Starting Balance 
on your bank statement so you can reconcile that one.


Colin

Finbar

On 26/01/2019 18:12, Colin Law wrote:

Do the starting and ending balances shown there match the ones on
the bank statement you are reconciling against?

Colin

On Sat, 26 Jan 2019 at 11:51, Finbar Mahon mailto:mahon.fin...@neuf.fr>> wrote:

I don't understand where you are seeing the figures you describe.  Can
you post a screenshot showing it?

This what I get at the bottom right hand side.



___
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] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

OK, let's go again.

1. I started using GNUCash with effect from 1.1.2018

2. For this particular a/c the figure €3986.22 is the balance in the 
a/c, taken from the bank statement on 28.12.2017, after the last 
transaction on that date.


3. I had a non-zero opening balance, in the sense that I created (named) 
the a/c in Gnucash and then started with the figure above, so that I 
could continue from the previous a/c into 2018. Should I have ignored 
the opening balance, the amount in the bank on 28.12.2017??


4. Having worked our the logic of 'view' (not a whole lot in the help 
about it, afaics.) I am working my way along another a/c tidying up 
things like cheques being entered on the date they were  written as 
opposed to the date they were cleared, etc. I am making good progress, 
learning that I should do reconciliations more often, some people take a 
long time to present the cheques ;-)


5. The numbers on the screen grab are exactly what my problem is. In 
some of my (very simple, not many entries) a/cs the numbers balance out 
nicely, as they should. I appreciate that a 'perfect' reconciliation 
should have no 'loose' centimes, but if the figures are within that sort 
of limit, I don't worry, I am not auditing a multinational.


Maybe I should just work on the appropriate 'view' in this a/c, say, 
month by month, tidying up the issues, and see what happens?


Thanks again for your patience.

Finbar



On 28/01/2019 13:12, David T. wrote:

There is a lot to unpack here.

You say you started at the beginning of 2018 and entered "the closing 
balance for 2017.


Was that balance taken from a statement? Or just from the bank website 
as of that date?


I can't see how any of the various numbers (the numbers on the screen 
grab or provided in your message) could be combined to balance out. 
And where does this 3986.22 figure come from?


Next, if this truly is your first reconciliation, how is it that you 
have a non zero opening balance? Gnucash derives this number by taking 
all entries that were previously reconciled. So maybe you reconciled 
something already?


Finally, you will not be able to reconcile your account if it's 
inaccurate by even "a few centimes." Gnucash insists on a full match 
in amount before it allows you to complete the process.  So, you will 
need to address those as well.


Figure out why Gnucash shows a non zero opening balance and clean up 
the erroneous transactions, and see where that puts you.


David

On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
 wrote:

OK,

As I said, I started on 1.1.2018 with 'nothing' I entered the
closing balance for 2017 for the a/c and started entering
transactions.

Unfortunately, coming from Quicken, I didn't do any
reconciliations until about December. But casually examining the
entries from time to time they seemed 'ok' just a few centimes
'off' probably due to finger problems, as I had also experienced
with Quicken and sorted them at year end.

The Opening Balance in the latest iteration of reconcile was what
I showed in the screen grab a while back -

While the a/c entries starting entry shows the bank balance figure
€3986.22 and the €5.117.09 ending balance tallies with the bank
statement..

Aha, maybe there is another issue. When I do, as you suggested, 
View > Filter By > Status > Reconciled I get nothing!! even when I
just chose 'reconcile' or 'select all'

:-( thanks for the help :-)
:-)



On 27/01/2019 10:46, Colin Law wrote:
On Sun, 27 Jan 2019 at 09:36, Finbar Mahon mailto:mahon.fin...@neuf.fr>> wrote:

No, as I said in the original post, I started on 1.1.2018 with
GNU, so the first entry in this a/c should be the opening
balance for the a/c from the bank statement, €3986.22. The
ending balance is correct.


Actually you still haven't stated it clearly.  The question is
what does the Opening Balance show when you reconcile?  If this is
the first time you have reconciled it then it should show zero
(unless the opening balance has been already reconciled).  If it
is not zero then that means some transactions have already been
reconciled (possibly accidentally).  If you go to the account and
then View > Filter By > Status > Reconciled then it should show
you just the reconciled transactions.  Clear the reconcile state
on all these and you should be good to start the reconcile with a
starting balance of zero.  Then the Opening Balance in the account
should match the Starting Balance on your bank statement so you
can reconcile that one.

Colin

Finbar

On 26/01/2019 18:12, Colin Law wrote:

Do the starting and ending balances shown there match the
ones on

Re: [GNC] Reconciliation is not adding up correctly - what t

[Finbar Mahon]

Thanks for all that. There may have been some transactions before 
28.12.2017 which 'snuck' in and were deleted, that is possible and might 
explain the non zero start point.


I saw in another post a query on whether a filtered view could show 
deleted transaction, if there is a possibility I may be able to find the 
'culprits'


Apropos the centimes, I appreciate your point, but I can use the option 
to enter a reconciliation amendment to cover them


As I said, I'll soldier on with the view option and hopefully find the 
errors. I have made a new years resolution to do reconciliations more 
often :-)


Many, many thanks for the observations and advice.

Finbar

On 29/01/2019 12:59, David T. wrote:

Finbar,

On Tue, Jan 29, 2019 at 16:54, Finbar Mahon
 wrote:

2. For this particular a/c the figure €3986.22 is the balance in
the a/c, taken from the bank statement on 28.12.2017, after the
last transaction on that date.

That clarifies this issue.  You created a transaction in the
amount of 3986.22, presumably from Equity into Checking.

Did you perform any reconciliation at this point?

3. I had a non-zero opening balance, in the sense that I created
(named) the a/c in Gnucash and then started with the figure above,
so that I could continue from the previous a/c into 2018. Should I
have ignored the opening balance, the amount in the bank on
28.12.2017??

No, entering an opening balance transaction is necessary for
practically everything.  It's what happens at reconciliation that
is messed up...

5. The numbers on the screen grab are exactly what my problem is.

And I agree, but probably not for the same reason as you. My
problem is that your reconcile window shows a non zero starting
balance.  Gnucash calculates this amount from the transaction data
directly, counting up all the transactions that have been
reconciled before. So, the first time you reconcile an account, it
should be zero. (Indeed, the first reconciliation starting balance
merits a specific mention in the Guide)

The fact that your window shows something else there means that
there is something else going on.

 I appreciate that a 'perfect' reconciliation should have no
'loose' centimes, but if the figures are within that sort of
limit, I don't worry, I am not auditing a multinational.

Again, while it might not bother you, Gnucash will not allow you
to finish reconciliation until the numbers match exactly.


Thanks again for your patience.

Finbar



On 28/01/2019 13:12, David T. wrote:
There is a lot to unpack here.

You say you started at the beginning of 2018 and entered "the
closing balance for 2017.


Was that balance taken from a statement? Or just from the bank
website as of that date?

I can't see how any of the various numbers (the numbers on the
screen grab or provided in your message) could be combined to
balance out. And where does this 3986.22 figure come from?

Next, if this truly is your first reconciliation, how is it that
you have a non zero opening balance? Gnucash derives this number
by taking all entries that were previously reconciled. So maybe
you reconciled something already?

Finally, you will not be able to reconcile your account if it's
inaccurate by even "a few centimes." Gnucash insists on a full
match in amount before it allows you to complete the process. 
So, you will need to address those as well.

Figure out why Gnucash shows a non zero opening balance and clean
up the erroneous transactions, and see where that puts you.

David

On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
 <mailto:mahon.fin...@neuf.fr> wrote:

OK,

As I said, I started on 1.1.2018 with 'nothing' I entered the
closing balance for 2017 for the a/c and started entering
transactions.

Unfortunately, coming from Quicken, I didn't do any
reconciliations until about December. But casually examining
the entries from time to time they seemed 'ok' just a few
centimes 'off' probably due to finger problems, as I had also
experienced with Quicken and sorted them at year end.

The Opening Balance in the latest iteration of reconcile was
what I showed in the screen grab a while back -

While the a/c entries starting entry shows the bank balance
figure €3986.22 and the €5.117.09 ending balance tallies with
the bank statement..

Aha, maybe there is another issue. When I do, as you
suggested,  View > Filter By > Status > Reconciled I get
nothing!! even when I just chose 'reconcile' or 'select all'

:-( thanks for the help :-)
 

Re: [GNC] undo needed, was Re: Reconciliation is not adding up correctly

[Finbar Mahon]

Often the justification for not having undo in accounting software  is 
security. Maybe an option to edit the starting balance?


I know that it is there to manage the reconciliation process, but errors 
in transaction entries can modify the starting balance.


Finbar

On 31/01/2019 10:08, Bert Riding wrote:

On Wed, 30 Jan 2019 13:30:47 -0500
Elmar  wrote:


I bet the ability to  have a few levels of "undo" is on the desired
enhancements list, no?  I certainly have cursed a few times when I
hit delete by mistake.

- Elmar

On 1/30/19 12:00 PM, gnucash-user-requ...@gnucash.org wrote:

Message: 9 Date: Wed, 30 Jan 2019 12:17:20 + From: Colin Law  >
 ... Once you have deleted a transaction then it

  > is gone, so you won't be able to find it in by filtering.
___
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.

If you can reload your data file before it's saved or auto-saved, you
can undo all transactions back to the last save.


___
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] Recording/Reporting transfers between accounts

[Finbar Mahon]

Hello,

At year end I need to record the transactions that have been made 
between accounts.


Firstly, I am not sure of the logic to  be used -

So, if I want to transfer €1000 to another a/c, I fill in 'transfer to 
x' in description; what do I put in the 'transfer' box ? - 'assets 
account from which transfer is to be made'? and €1000 in 'withdrawal'?


OK, assuming that is right then the transferred to a/c should show €1000 
in the deposit window?


To check what transfers I made after a period, can I create a report? If 
so, under what heading in reports?


TIA Finbar

___
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] Recording/Reporting transfers between accounts

[Finbar Mahon]

Thanks for all that, I just need to examine in some detail the results 
of transfers as they arrive in the end of year P&L, some seem to be 
misapplied.


Finbar

On 01/02/2019 15:55, Maf. King wrote:

On Friday, 1 February 2019 14:31:21 GMT Finbar Mahon wrote:

Hello,

At year end I need to record the transactions that have been made
between accounts.

Firstly, I am not sure of the logic to  be used -

So, if I want to transfer €1000 to another a/c, I fill in 'transfer to
x' in description; what do I put in the 'transfer' box ? - 'assets
account from which transfer is to be made'? and €1000 in 'withdrawal'?


Hi Finbar,

Assuming that you are in basic  single line view mode in the register of the
account that you are transferring from, then Description sounds right,
Transfer would be the "destination" account and withdrawal of 1000.
(effectively exactly the same as paying a credit card bill etc.)


OK, assuming that is right then the transferred to a/c should show €1000
in the deposit window?


Yes.  (assuming both are bank (asset) accounts - the labels might be different
in other type account.)



To check what transfers I made after a period, can I create a report? If
so, under what heading in reports?


I'd start with the transaction report.

HTH,
Maf.



TIA Finbar







___
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] Backup recovery

[Finbar Mahon]

Hi,

I know this has been asked before and I have read some of the the 
threads, however...


I am trying out Backblaze, the continuous backup to the cloud service.

I wanted to check if my files were recoverable and I found -

and more, all dated the day before yesterday, when I did the backup 
trial.


1. Do I need to restore all of these, if not which ones?

2. I found them in my file explorer, is there any other place, by 
default, where the files are?


3. Can somebody point me to a link or links which explain the 'best' way 
of storing GNU files?


Using Windows 10 PC with Version: 3.4 Build ID: 3.4+ (2018-12-30)

Thanks, Finbar

___
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] Backup recovery

[Finbar Mahon]

Thanks, I read the guide and was a bit confused when backblaze showed 
the most recent save was yesterday at 3.55pm but with two dates/times of -



GNU 5 Feb 2018 .gnucash.20180305171639.gnucash.20190208155508.gnucash<<


Is the second date from the left [20180305171639] the date the file was 
created originally, and the first one [GNU 5 Feb 2018] the file name  ?


Not critical as the backblaze file is the last save before I closed gnucash.

Finbar



On 08/02/2019 22:56, David Cousens wrote:

Finbar,

The directory with your data file will also contain log files  and backup
files.

See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html for
details

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-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] postpone reconciliation broken: ignores my changes

[Finbar Mahon]

Just a minor point doesn't it  change from 'c' or 'n' to 'y' in the R 
column after 'finish' ?


I have had some issues with 'quit' - there have been times when I was 
sure that I had done save/quit but the next time I fired up GNUCash it 
said it could not find the file and did I want to open it anyway? Does 
that happen if I haven't 'finished' the reconciliation?


Finbar

On 08/02/2019 22:09, Jamestk wrote:

Michael, just a thought - individual transactions should save after each
entry, tapping the return key will move onto the next one auto saving the
previous - the reconciliation process is likely to be somewhat different,
GNC marks the entries but doesn't save these until the process is finalized
by activating 'finish' button, this will change entries from 'c' to 'r'
writing the result back to file -

Could I ask what button is used when you mention 'marked as complete', if
its the green reconciled tick button this appears to be non functional?

Thanks,


"Yesterday morning I reconciled a single account, marked it complete,
clicked “Save” and quit Gnucash - I was going to be out all day, and wasn’t
planning to do any more work on the books. The unusual aspect was the quick
sequence of finishing the reconciliation, clicking Save and Quit - usually I
would tidy up the papers before shutting down. The Mac itself was left
running."





--
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] Backup recovery

[Finbar Mahon]

Thanks for that, I probably did, but not (yet) in backblaze, does that 
matter?


Finbar

On 09/02/2019 12:59, D wrote:

That file name indicates that you opened, and saved, a backup of your main data 
file. You might not have intended to do this.

See 
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_is_my_file_name_getting_longer_and_longer.3F

David

On February 9, 2019, at 5:15 PM, Finbar Mahon  wrote:

Thanks, I read the guide and was a bit confused when backblaze showed
the most recent save was yesterday at 3.55pm but with two dates/times of -


GNU 5 Feb 2018 .gnucash.20180305171639.gnucash.20190208155508.gnucash<<

Is the second date from the left [20180305171639] the date the file was
created originally, and the first one [GNU 5 Feb 2018] the file name  ?

Not critical as the backblaze file is the last save before I closed gnucash.

Finbar



On 08/02/2019 22:56, David Cousens wrote:

Finbar,

The directory with your data file will also contain log files  and backup
files.

See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html for
details

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-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] Backup recovery

[Finbar Mahon]

Yes, I appreciate the comment.

In my original post I mentioned that I was testing out an app called 
backblaze, an automatic backup to the the cloud. I asked where and how I 
would find the GNU backups, since the folder where GNU stuff is saved is 
full of files, and would have been backed up by backblaze it its 
entirity.. I got the answer(s) and the link to the manual. It was only 
then that I discovered, after I asked another question about the file 
name, that I was working on another backup. I don't recall making one 
specifically but it was probably part of a 'general' HD backup. However, 
I have no idea how or when I restored it, if I ever did, I have not had 
any reason to restore any files.


As you so rightly pointed out I may have fd up, thanks.

I asked, in effect if the version that is in the backblaze app backup 
folder is a complete backup up to the 8 Feb, or is it just an update of 
the March 5 2018 file? If it is a 'catch-up' then is that ok?


Sorry for any confusion, it is not deliberate.

Thanks again, Finbar

On 10/02/2019 16:23, David T. wrote:

I don’t know. What is backblaze?

Based on the info in the FAQ to which I referred, it appears that on Feb 8, 
2019, you opened a backup copy of “GNU 5 Feb 2018”, which itself was made on 
March 5, 2018, made some changes, and saved from that backup. I don’t know your 
workflow or immediate purpose for doing that; in my situation, if I had opened 
a backup file from 11 months ago and made changes to that file which I then 
saved, I would most likely have f**ked up. YMMV.

David


On Feb 10, 2019, at 8:00 PM, Finbar Mahon  wrote:

Thanks for that, I probably did, but not (yet) in backblaze, does that matter?

Finbar

On 09/02/2019 12:59, D wrote:

That file name indicates that you opened, and saved, a backup of your main data 
file. You might not have intended to do this.

See 
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_is_my_file_name_getting_longer_and_longer.3F

David

On February 9, 2019, at 5:15 PM, Finbar Mahon  wrote:

Thanks, I read the guide and was a bit confused when backblaze showed
the most recent save was yesterday at 3.55pm but with two dates/times of -


GNU 5 Feb 2018 .gnucash.20180305171639.gnucash.20190208155508.gnucash<<

Is the second date from the left [20180305171639] the date the file was
created originally, and the first one [GNU 5 Feb 2018] the file name  ?

Not critical as the backblaze file is the last save before I closed gnucash.

Finbar



On 08/02/2019 22:56, David Cousens wrote:

Finbar,

The directory with your data file will also contain log files  and backup
files.

See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html for
details

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-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] Backup recovery

[Finbar Mahon]

OK, thanks. So, it is 'normal' to be using it?

Finbar

On 11/02/2019 10:28, Maf. King wrote:

On Monday, 11 February 2019 09:10:30 GMT Finbar Mahon wrote:



that I was working on another backup. I don't recall making one
specifically but it was probably part of a 'general' HD backup. However,
I have no idea how or when I restored it, if I ever did,



Finbar,

re-read the GC info about backups & filenames.  GC normally makes a backup each
time you save the data file - and puts the timestamp numbers on the end of the
"working" filename.  It is one of these auto-backups that you opened (actually,
a backup-of-a-backup, hence the 2x digit strings) not anything that you
backed-up/restored external to GC.

HTH,
Maf.




___
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] Backup recovery

[Finbar Mahon]

Wow, this is getting (more) complicated -

You said -

[When Gnucash starts, it *normally* opens the file that was open when 
you shutdown last time around,


so it is fairly easy to get the wrong one by mistake if you've been 
digging in the folder.]


I just booted up GNUcash without any 'digging' and got  -

On the bottom of the screen.

which follows your information, as the 'second' file? right ? so, I go 
to file>open and I get -


etc., etc. None of which have the date that is on the open GNUcash file. 
Maybe it is one of the files marked 'wed'? but the dates don't match.


So I look further down the list of files under file > open and I finally 
come to -


The only file on these two grabs which fits your name criteria is the 
very first one above but the date is almost a year ago, and none of the 
others in the second grab seem to fit the criteria.


:-( I am truly sorry for the long sequence of q&a but I am accustomed to 
assuming the file I last used opens again after I 'save' and 'quit'


Thank you very much for your patience.

Finbar

On 11/02/2019 12:08, Maf. King wrote:

On Monday, 11 February 2019 10:35:30 GMT you wrote:

OK, thanks. So, it is 'normal' to be using it?


No, you risk data loss at the point of opening the backup.

let me clarify.

Your data file is called (for example) "mybooks.gnucash" All timestamps are
made up (but plausible)

you enter a transaction and save and quit.  GC renames the old
"mybooks.gnucash" to "mybooks.gnucsh.201901022345.gnucash" and saves the
changes into a new file on disk called "mybooks.gnucash"

you later open the backup (by mistake) and enter another transaction, save and
quit again.  GC creates the backup mybooks.gnucash.201901022345.gnucash.
201901081256.gnucash

GC now has 3 files in the folder:

mybooks.gnucash<-- has the 1st edit in it
mybooks.gnucash.201901022345.gnucash  <-- has the 2nd edit in it
mybooks.gnucash.201901022345.gnucash.201901081256.gnucash <--no edits in it

as you can see, by using a backup, you loose the previous edit session - go a
few edits down the road and you can be in proper mess with transactions
seeming to go missing from months ago!

When Gnucash starts, it *normally* opens the file that was open when you shut
down last time around, so it is fairly easy to get the wrong one by mistake if
you've been digging in the folder.  On Windows & Linux, you can make GC open
with a different file by clicking... but not so on mac.  No matter what file you
try to open GC with, it WILL use the previous one. So if you've been looking
at backups, on a Mac you NEED to File->Open once GC is running.

HTH,
Maf,






___
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] Backup recovery

[Finbar Mahon]

Well, I hope I understood all that.

I did a save as in a new folder called GNU FEB 12 2019, >Saved all the 
open accounts, >closed them, >quit and then reopened GNUcash.


Voila, afaics, a file opened called GNU FEB12 2019.gnucash and it 
contains the last transactions, so far so good.


Just have to remember to save and quit ??

Thanks again, Finbar

On 11/02/2019 15:10, Maf. King wrote:


Good luck,
Maf.




___
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] Help! Decimal point won't enter; description freezes

[Finbar Mahon]

Hello,

Using - Version: 3.4
Build ID: 3.4+ (2018-12-30)

On Windows 10 Home, version 1803, on a Lenovo PC

Entering data in a bank account, exisiting, not new.

Entering description, freezes, won't move on; then, if it does, entering 
amount won't take the decimal point.


This does not happen for every entry, but when it does it is irritating, 
sometimes the work around is to delete the transaction and retry, but 
not always.


Finbar

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

Re: [GNC] Help! Decimal point won't enter; description freezes

[Finbar Mahon]

OK, thanks, will do that.  Meanwhile a save>quit and restart seems to 
have sorted the issues.


Thanks.

On 27/02/2019 15:09, Colin Law wrote:

Have a look in the gnucash trace file to see if there is anything of note there.

Colin

On Wed, 27 Feb 2019 at 11:53, Finbar Mahon  wrote:

Hello,

Using - Version: 3.4
Build ID: 3.4+ (2018-12-30)

On Windows 10 Home, version 1803, on a Lenovo PC

Entering data in a bank account, exisiting, not new.

Entering description, freezes, won't move on; then, if it does, entering
amount won't take the decimal point.

This does not happen for every entry, but when it does it is irritating,
sometimes the work around is to delete the transaction and retry, but
not always.

Finbar

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