Re: Bank reconciliation question

[DaveC49]

It should be no problem at all. Just record the original transactions you
already have  recorded against something like a miscellaneous expenses
account. Add notes to the description that they were direct debits in error.
The refunds should also appear in your OFX records so just load then and use
the same miscellaneous expense account to record the refund against. Attach
notes in the Description field referencing the orignal incorrect
transactions in error so that your auditors will be happy. 

Reconciliation should be no problem as your bank statements should have both
the original debits to the account(credits in your books) and the credits
(debits in your books) to the account so they should reconcile against your
account as normal.

When you prepare the financial statements, you could put in an explanatory
note, referencing the transactions in error. 

Transactions hould appear something like

Original transaction:
debit  
credit
Asset: Bank 
Expenses:Miscellaneous  

corresponding Refund 

Asset: Bank    
Expense: Miscellaneous

You may need to consult any local legislation which governs your association
and its recording  of financial matters or your auditors. As long as the
explanation is clear and references any external
documentation/correspondence from your bank, your auditors should be happy. 

Note that you can also create links from transactions to associated
documents.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: counter number format not used in tax invoice (solved)

[Derek Atkins]

Geert Janssens  writes:

> li works because it represents an integral number.
> ld does not work because it represents a decimal number. Telling gnucash to 

This isn't quite right.  'd' is still an integer value.  The issue is
that some platforms use 'li' to represent long integers, and others use
'ld'.  It depends on the underlying 'printf' function, which is platform
dependent.

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

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: New File Name ??

[Colin Law]

On 24 January 2018 at 20:49, Mike Stillingfleet <
mikestillingfl...@fastmail.co.uk> wrote:

> Thank you Colin. That remedial action makes sense. I remain mystified as
> to how the name got changed. Verification of which file has all the right
> data in it isn't as simple as y sounds. I know the reconciliation dates are
> right in the new file.  But going back and checking thousands of prior
> period entries isn't feasible.
>

As I said, If you look at the date stamps embedded in the backup file names
you will be able to see in what order you edited things, so you can see if
the track is continuous down the original file, then switches to the new
file and stays there, in which case the new file should have everything in
it. If the timestamps of the two file tracks are interleaved then you have
a bigger problem.

Colin


>
>
> On Wed, Jan 24, 2018, at 2:51 PM, Colin Law wrote:
>
> On 24 January 2018 at 13:57, Mike Stillingfleet <
> mikestillingfl...@fastmail.co.uk> wrote:
>
> Dear All,
>
> I have just noticed (after doing a lot of work on GNU Cash) that the file
> name has changed. I now have a file  call Bank Expenses.gnucash.
>
> When I click on file I see my old file name as "2" and the new file new as
> "1".
>
> I didn't ever request a new file name.
>
>
> Where did this new file name come from???
>
> When I clicked on file 2 the screen went gray and said it was an unsaved
> file and the reconiliation dates do not match. i.e. vast amount of work
> missing from my old file.
>
> Can some one explain this. Can some please tell me how I should proceed
> without losing all my work!!
>
>
> If the new file has the correct data then open open it and select File >
> Save As to save it as another new name, then you can carry on using it
> while you try to understand where it came from.
>
> If you do a full directory listing of the folder then you will also see
> all the backup files with embedded timestamps in the name and should be
> able to work out what happened.
>
> When you clicked on file 2 and it says it was unsaved are you sure it was
> not saying that you had made just made a change to file 1 (possibly via a
> scheduled transaction) and that it was warning you that you were switching
> files without saving the work?
>
> Colin
>
>
>
> Thanks
>
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash Install Online Price Retrieval

[Dave H]

Hi Bob,

Yeah I think from memory Win 8.1 has a start screen instead of the start
menu - it's been awhile :-)  There are 3rd party addons out there to
restore the start menu if you want it.

How do you start gnucash without the Start Menu.  When you installed
gnucash did you also tell it to install the start / taskbar icons ?
Somewhere there with the GnuCash icon, there should also be an Install
Strawberry perl icon ?

You also can download and install it manually from
http://strawberryperl.com/releases.html

Cheers Dave H.

On 24 January 2018 at 09:03, Bob Wachtel  wrote:

> I have recently installed Gnucash with import from my previous Quicken
> files. I have not been able to find the Install Online Price Retrieval
> function to enable online stock price retrieval. I am running windows 8.1
> and do not find a "Start Menu Gnucash Group". Windows 8.1 does not seem to
> have the Start Menu function.
>
> Any help would be appreciated.
>
> --
> Bob Wachtel
> BPAB Chair
> BTPA Treasurer and Webmaster
> Home: 406-728-6398
> Cell: 406-218-1132 (text, voice)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: New File Name ??

[Mike Stillingfleet]

Thank you Colin. That remedial action makes sense. I remain mystified as
to how the name got changed. Verification of which file has all the
right data in it isn't as simple as y sounds. I know the reconciliation
dates are right in the new file.  But going back and checking thousands
of prior period entries isn't feasible.

On Wed, Jan 24, 2018, at 2:51 PM, Colin Law wrote:
> On 24 January 2018 at 13:57, Mike Stillingfleet
>  wrote:>> Dear All,
>> 
>>  I have just noticed (after doing a lot of work on GNU Cash) that the
>>  file name has changed. I now have a file  call Bank
>>  Expenses.gnucash.>> 
>>  When I click on file I see my old file name as "2" and the new file
>>  new as "1".>> 
>>  I didn't ever request a new file name.
>> 
>> 
>>  Where did this new file name come from???
>> 
>>  When I clicked on file 2 the screen went gray and said it was an
>>  unsaved file and the reconiliation dates do not match. i.e. vast
>>  amount of work missing from my old file.>> 
>>  Can some one explain this. Can some please tell me how I should
>>  proceed without losing all my work!!> 
> If the new file has the correct data then open open it and select File
> > Save As to save it as another new name, then you can carry on using
> it while you try to understand where it came from.> 
> If you do a full directory listing of the folder then you will also
> see all the backup files with embedded timestamps in the name and
> should be able to work out what happened.> 
> When you clicked on file 2 and it says it was unsaved are you sure it
> was not saying that you had made just made a change to file 1
> (possibly via a scheduled transaction) and that it was warning you
> that you were switching files without saving the work?> 
> Colin
>  
>> 
>> Thanks
>>
>>  --
>>Mike Stillingfleet mikestillingfl...@fastmail.co.uk
>>  ___
>>  gnucash-user mailing list gnucash-user@gnucash.org
>>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>  -
>>  Please remember to CC this list on all your replies. You can do this
>>  by using Reply-To-List or Reply-All.
--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

[Cam Ellison]

On 24/01/18 11:26 AM, Geert Janssens wrote:

David,

Another thing to try is run gnucash from the command line (I  believe this is
also possible on OS X, though I don't know the details).

Normally gnucash prints the version of F::Q it finds to the console during
startup. That may give a hint already.



You can force discovery of the version by doing this on the command line:
gnucash --add-price-quotes /path/to/gnucash_file

It's probably better to do this when gnucash is not running, but it 
should work even when it does. It just won't access the file because 
it's already locked.


Cheers

Cam

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[Geert Janssens]

Op woensdag 24 januari 2018 08:54:03 CET schreef David T. via gnucash-user:
> Yes. 
> https://bugzilla.gnome.org/show_bug.cgi?id=790789
> 
> 
> 
>   On Wed, Jan 24, 2018 at 11:37, David Carlson
> wrote:   OK, I missed the reference.  Has a bug been submitted?
> 
> David C
> 
> On Wed, Jan 24, 2018 at 12:32 AM, David T.  wrote:
> 
> David, 
> Christopher is referring to a thread in which windows users reported that
> gnucash was imposing a substantial delay on the first run report. This is
> different from the general problem of slow report loading, I believe.  As
> for the delay,  I have not seen anyone say that they have a fix. David T.
> 
> 
> 
>   On Wed, Jan 24, 2018 at 1:58, David Carlson
> wrote:   There has been a long standing problem with reports that need to
> process a lot of records being slow to open for most every release in the
> 2.6 series in Windows, if I recall.  However, if release 2.6.19 is now slow
> even with simple reports, that is a new issue.  I think that the upcoming
> 3.0 series will be substantially improved.
> 
> Do you have any memorized reports that are very simple to process, say a
> balance report for a small number of accounts?  Are those slow to open too?
> 
> David C

Gnucash switched to a much more recent report rendering engine in 2.7.x/3.0. 
Compared to the 2.6.x series. It would be helpful if someone encountering this 
bad delay could install 2.7.3 and check whether this issue is still present 
there.

Be aware the 2.7.x series is unstable and can potentially corrupt your data, 
so please only use it after making a backup of your data file!

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

[Geert Janssens]

David,

Op woensdag 24 januari 2018 04:01:23 CET schreef D via gnucash-user:
> Derek,
> 
> I did edit the environment file.
> 
As a sneak preview, with 3.0 this will become a thing of the past. Instead of 
updating the environment file over and over, you will be creating an 
"environment.local" file right next to the environment file and make your 
local customizations in there. Gnucash will never override that file, so your 
customizations will survive gnucash updates.

Of course that's not much help right now. I thought it was worth mentioning 
already.

Even better would be if gnucash would provide a gui somewhere to allow the 
user to enter the alphavantage key. There are several pitfalls to that 
approach as well though and in the context of this mail I won't go into those.

> This experience makes it clear to me that it would be nice if Gnucash had
> some way of showing F::Q information to the end user, like a screen showing
> the version installed, and maybe having buttons to trigger the various gnc-
> scripts and show the output. This would make debugging just a tad easier...
> (Note that I am not asking for better error messages, which certainly would
> be nice, but not likely, since finance quote isn't Gnucash).

Totally agreed indeed.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Installation on Windows 10

[Geert Janssens]

Op dinsdag 23 januari 2018 21:47:39 CET schreef David Carlson:
> Glad you were able to resolve your write issue.  Why your AV is that
> sensitive, I am not sure.  Did you have to whitelist all the other programs
> that you use regularly?
> 
> Anyway, your comment about GnuCash doing unnecessary things like repeatedly
> asking for random numbers in Windows is interesting.  I wonder if a
> developer would suggest creating a bug report for that.
> 
> David C
> 
It is a bug indeed that gnucash on Windows attempts to access a file that's 
only available on linux.

However in this case don't bother submitting a bug report. This particular bad 
behaviour has already been eliminated for the upcoming 3.0 release.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: info about action field in double-line view

[Geert Janssens]

Op maandag 22 januari 2018 17:30:32 CET schreef David T.:
> Geert,
> 
> What is the current status on the File Association feature set? I know that
> there was a wave of activity a few years back when the feature was first
> added, but I haven’t seen anything about it since. My recollection of the
> traffic at the time was that it had potential to be very useful, but that
> after the initial basic implementation, additional work to enhance its
> utility was lacking.
> 
> As far as I can tell, there is nothing in the documentation about file
> associations, either. At the very least, it would be good to have some kind
> of state-of-the-feature information put out there somewhere, maybe on the
> wiki, if the feature isn’t yet ready for general use.
> 
> David
> 

David,

I think the file association feature is currently pretty basic, but useful.

The most common complaints about the initial implementation were
- the lack of an indication of whether a file was associated with it or not
- a way to remove an existing association

The former has been fixed in 2.6 already, the latter was implemented for the 
upcoming 3.0 release.

By checking this, I find the option to remove an association hidden too far 
away, so it may need another revision in the future. Currently to remove an 
existing association one has to select "Associate File with transaction" a 
second time. The file dialog that pops up will now have an additional "Remove" 
button to remove the existing association.


Future potential improvements I can think of:
- Make removing a file association more visible.
- Show a file icon instead of "F"/"U". While a no-brainer from a usability 
point of view it would require huge changes in the current register code, so 
it's unlikely to be implemented anytime soon unfortunately.
- Provide an option to store a copy of the associated file near the gnucash 
file. I don't know what the best equivalent would be in case the gnucash data 
is stored in a database. We may have to store it as a binary blob in that 
case. The primary use case here would be to prevent the association being 
moved or deleted from underneath gnucash, or in case of the db backend, to 
make the association available to all gnucash clients interacting with the db.
- Make file associations more universally useful: allow them to be associated 
with invoices, bills, vendors, customers,...


Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: New File Name ??

[Colin Law]

On 24 January 2018 at 13:57, Mike Stillingfleet <
mikestillingfl...@fastmail.co.uk> wrote:

> Dear All,
>
> I have just noticed (after doing a lot of work on GNU Cash) that the file
> name has changed. I now have a file  call Bank Expenses.gnucash.
>
> When I click on file I see my old file name as "2" and the new file new as
> "1".
>
> I didn't ever request a new file name.
>
>
> Where did this new file name come from???
>
> When I clicked on file 2 the screen went gray and said it was an unsaved
> file and the reconiliation dates do not match. i.e. vast amount of work
> missing from my old file.
>
> Can some one explain this. Can some please tell me how I should proceed
> without losing all my work!!
>

If the new file has the correct data then open open it and select File >
Save As to save it as another new name, then you can carry on using it
while you try to understand where it came from.

If you do a full directory listing of the folder then you will also see all
the backup files with embedded timestamps in the name and should be able to
work out what happened.

When you clicked on file 2 and it says it was unsaved are you sure it was
not saying that you had made just made a change to file 1 (possibly via a
scheduled transaction) and that it was warning you that you were switching
files without saving the work?

Colin


>
> Thanks
>
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash Install Online Price Retrieval

[Fross, Michael]

Hello Bob,

You're going to want to install perl.  I use activeperl from activestate,
but there are others that work.  Ensure perl.exe is in your path.  Should
happen during install, but just check.   Running 'perl -V' from the command
line should tell you if it's found.

Secondly, you'll want to run install-fq-mods.cmd in c:\program files
(x86)\gnucash\bin (or wherever you installed gnucash.)

Lastly, read the wiki about setting up online quotes.  I use yahoo-json
since yahoo no longer is working.  That may work for you or you may need to
use alphavantage depending on what you are pulling.  A search of the
mailing list will pull up a ton of info concerning that.

Best of luck.

Michael

On Tue, Jan 23, 2018 at 5:03 PM, Bob Wachtel  wrote:

> I have recently installed Gnucash with import from my previous Quicken
> files. I have not been able to find the Install Online Price Retrieval
> function to enable online stock price retrieval. I am running windows 8.1
> and do not find a "Start Menu Gnucash Group". Windows 8.1 does not seem to
> have the Start Menu function.
>
> Any help would be appreciated.
>
> --
> Bob Wachtel
> BPAB Chair
> BTPA Treasurer and Webmaster
> Home: 406-728-6398
> Cell: 406-218-1132 (text, voice)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

New File Name ??

[Mike Stillingfleet]

Dear All,

I have just noticed (after doing a lot of work on GNU Cash) that the file name 
has changed. I now have a file  call Bank Expenses.gnucash. 

When I click on file I see my old file name as "2" and the new file new as "1".

I didn't ever request a new file name.


Where did this new file name come from???

When I clicked on file 2 the screen went gray and said it was an unsaved file 
and the reconiliation dates do not match. i.e. vast amount of work missing from 
my old file.

Can some one explain this. Can some please tell me how I should proceed without 
losing all my work!!

Thanks

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Bank reconciliation question

[Colin Law]

On 24 January 2018 at 10:31, David Goodenough <
david.goodeno...@linkchoose.co.uk> wrote:

> A community association for which I am treasurer for recently had someone
> succeed in
> getting our bank to open a Direct Debit on our account without our
> authorisation.
> They took 4 payments before we noticed, and now the DD has been cancelled
> and the
> money refunded.  We use GnuCash to manage the association's money.
>
> How do we reconcile this?  I know how to reconcile a pay transaction
> against an
> invoice, but here I need to reconcile four payments for which there are no
> invoices
> against one receipt.  We have already imported the OFX file with the four
> payments in
> it (which is when we noticed them), and will shortly import a subsequent
> one with the
> re-payment in it.
>

You could just enter them (and the refund) against one of your expense
accounts, expense:miscellaneous or whatever you put small items against, or
invent a new expense acct Expenses:BankErrors or something.  Since it will
go out and then back in again it will have no effect on the end result.

Colin


>
> Thank you
>
> David
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

GnuCash Install Online Price Retrieval

[Bob Wachtel]

I have recently installed Gnucash with import from my previous Quicken files. I 
have not been able to find the Install Online Price Retrieval function to 
enable online stock price retrieval. I am running windows 8.1 and do not find a 
"Start Menu Gnucash Group". Windows 8.1 does not seem to have the Start Menu 
function.

Any help would be appreciated.

--
Bob Wachtel
BPAB Chair
BTPA Treasurer and Webmaster
Home: 406-728-6398
Cell: 406-218-1132 (text, voice)
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.