Re: [GNC] Import invoices ~ tax table

[Nelson Handcock]

Glad you got it sorted!

On Sat., 6 Mar. 2021, 00:50 R. Victor Klassen,  wrote:

> Bingo.
>
> This has been hanging around for a long time since 99% of our sales are
> zero-rated. Automatically catching the other 1% will reduce the opportunity
> for errors and speed up the process.
>
> Sent from my iPhone
>
> On Mar 5, 2021, at 7:13 AM, R. Victor Klassen  wrote:
>
> I’m wondering whether I left out the “Tax Included” column, and whether
> there are no important columns after that so it just (almost) works.
>
> I’ll have another chance to try it out this morning, as we have an
> importable invoice twice a week.  Something to try.
>
> On Mar 4, 2021, at 8:10 PM, Nelson Handcock 
> wrote:
>
> In your original email you say your GST Tax table is in column P - mine is
> in column Q. So perhaps that's the problem?
>
> Thanks & Regards,
>
> Nelson Handcock
> 0409 149919
>
> http://www.linkedin.com/in/nelsonhandcockaustralia
>
>
> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock 
> wrote:
>
>> Hello,
>>
>> Ahh yes - I mis-read your original email!
>>
>> Here's a snapshot of my recent loadfile:
>> 
>>
>> And here's a snapshot of my tax tables:
>> 
>>
>> The loaded invoice looks fine in GN - the GST amount is correct and is
>> showing in the liabilities account as defined.
>>
>>
>> Thanks & Regards,
>>
>> Nelson Handcock
>>
>>
>>
>> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen 
>> wrote:
>>
>>> When I said the x in the “Taxable?” column is correctly showing which
>>> items are taxable, I was referring to the column in the invoice after
>>> import.
>>>
>>> I do have a Y in the appropriate column of the csv file being imported -
>>> else I wouldn’t get the x in the “Taxable?” column.
>>>
>>>
>>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock 
>>> wrote:
>>>
>>> Hello,
>>>
>>> Try using "Y" in the Taxable column instead of "X"
>>>
>>> Regards, etc
>>>
>>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, 
>>> wrote:
>>>
 The documentation I’ve read has me specify the tax table in column 15
 (counting from 0) aka column P when the csv file is opened as a
 spreadsheet.

 When I put the three letters “HST” or the phrase “Harmonized Sales
 Tax”, both of which name sales tax tables, in that column, it is ignored.

 The x in the “Taxable?” Column is correctly showing which items are
 taxable.

 Is there a trick I am missing?


 Gnucash v 3.11 MacOS 10.13.6 if it matters.

 Sent from my iPhone
 ___
 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] OFX connect/AQbanking problem.

[David H]

Sorry Elmar, can't help you there as I'm in Oz and we don't use AQ Banking
oe the like here, just simple OFX/CSV downloads is all they'll give us.
Such is life.  I'm sure someone will come along when your time zone wakes
up and be able to give you some pointers to get it working.  Thanks for the
heads up on flatseal - didn't realise it even existed and it looks quite
nice.

Cheers David H.

On Sat, 6 Mar 2021 at 07:48, Elmar  wrote:

> thank you for your kind reply.  I have flatseal, and it shows the
> network permission set on for gnucash.  What diagnostic can I send? - Elmar
>
> On 3/5/21 4:42 PM, David H wrote:
> > See https://docs.flatpak.org/en/latest/sandbox-permissions.html -
> > flatpak works in it's own little world separated from the host os -
> > think of it as a VM I guess so you have to setup everything again.
> > You probably need to enable network permissions going by the network
> > error you received.
> >
> > Cheers David H.
> >
> > On Sat, 6 Mar 2021 at 07:28, Elmar  > > wrote:
> >
> > No ideas?  No responses?
> >
> > On 3/3/21 12:03 PM, Elmar wrote:
> > > I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my
> > > online banking credentials/profiles have vanished. So I have to
> > > recreate - but using the set-up online banking setup tool, I
> > created
> > > the user OK, but when it comes time to retrieve the account list
> > from
> > > the bank (which DOES show up in the bank list, btw) I get the
> > > following dialog:
> > >
> > > 14:01:12 Sending request...
> > > 14:01:12 Using GnuTLS default ciphers.
> > > 14:01:12 TLS: SSL-Ciphers negotiated:
> > TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> > > 14:01:12 Waiting for response...
> > > 14:01:12 No message received
> > > 14:01:12 Network error while waiting for response
> > > 14:01:12 Operation finished, you can now close this window.
> > >
> > > GC retrieved fine in earlier versions; what is going wrong here?
> > The
> > > bank involved is the Local Government Federal Credit Union, if that
> > > matters.  Since it showed up in the drop down list, I had hoped
> > that
> > > it would be all setup automagically.  Apparently not. Running under
> > > Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar
> > >
> >
> > ___
> > 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] OFX connect/AQbanking problem.

[Elmar]

thank you for your kind reply.  I have flatseal, and it shows the 
network permission set on for gnucash.  What diagnostic can I send? - Elmar


On 3/5/21 4:42 PM, David H wrote:
See https://docs.flatpak.org/en/latest/sandbox-permissions.html - 
flatpak works in it's own little world separated from the host os - 
think of it as a VM I guess so you have to setup everything again.  
You probably need to enable network permissions going by the network 
error you received.


Cheers David H.

On Sat, 6 Mar 2021 at 07:28, Elmar > wrote:


No ideas?  No responses?

On 3/3/21 12:03 PM, Elmar wrote:
> I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my
> online banking credentials/profiles have vanished. So I have to
> recreate - but using the set-up online banking setup tool, I
created
> the user OK, but when it comes time to retrieve the account list
from
> the bank (which DOES show up in the bank list, btw) I get the
> following dialog:
>
> 14:01:12 Sending request...
> 14:01:12 Using GnuTLS default ciphers.
> 14:01:12 TLS: SSL-Ciphers negotiated:
TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> 14:01:12 Waiting for response...
> 14:01:12 No message received
> 14:01:12 Network error while waiting for response
> 14:01:12 Operation finished, you can now close this window.
>
> GC retrieved fine in earlier versions; what is going wrong here?
The
> bank involved is the Local Government Federal Credit Union, if that
> matters.  Since it showed up in the drop down list, I had hoped
that
> it would be all setup automagically.  Apparently not. Running under
> Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar
>

___
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] OFX connect/AQbanking problem.

[David H]

See https://docs.flatpak.org/en/latest/sandbox-permissions.html - flatpak
works in it's own little world separated from the host os - think of it as
a VM I guess so you have to setup everything again.  You probably need to
enable network permissions going by the network error you received.

Cheers David H.

On Sat, 6 Mar 2021 at 07:28, Elmar  wrote:

> No ideas?  No responses?
>
> On 3/3/21 12:03 PM, Elmar wrote:
> > I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my
> > online banking credentials/profiles have vanished.  So I have to
> > recreate - but using the set-up online banking setup tool, I created
> > the user OK, but when it comes time to retrieve the account list from
> > the bank (which DOES show up in the bank list, btw)  I get the
> > following dialog:
> >
> > 14:01:12 Sending request...
> > 14:01:12 Using GnuTLS default ciphers.
> > 14:01:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> > 14:01:12 Waiting for response...
> > 14:01:12 No message received
> > 14:01:12 Network error while waiting for response
> > 14:01:12 Operation finished, you can now close this window.
> >
> > GC retrieved fine in earlier versions; what is going wrong here? The
> > bank involved is the Local Government Federal Credit Union, if that
> > matters.  Since it showed up in the drop down list, I had hoped that
> > it would be all setup automagically.  Apparently not. Running under
> > Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar
> >
>
> ___
> 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] OFX connect/AQbanking problem.

[Elmar]

No ideas?  No responses?

On 3/3/21 12:03 PM, Elmar wrote:
I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my 
online banking credentials/profiles have vanished.  So I have to 
recreate - but using the set-up online banking setup tool, I created 
the user OK, but when it comes time to retrieve the account list from 
the bank (which DOES show up in the bank list, btw)  I get the 
following dialog:


14:01:12 Sending request...
14:01:12 Using GnuTLS default ciphers.
14:01:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
14:01:12 Waiting for response...
14:01:12 No message received
14:01:12 Network error while waiting for response
14:01:12 Operation finished, you can now close this window.

GC retrieved fine in earlier versions; what is going wrong here? The 
bank involved is the Local Government Federal Credit Union, if that 
matters.  Since it showed up in the drop down list, I had hoped that 
it would be all setup automagically.  Apparently not. Running under 
Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar




___
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] Selecting appropriate report [RESOLVED]

[Rich Shepard]

On Sat, 6 Mar 2021, David H wrote:


The Transaction report certainly allows you to select Liability and
Expense accounts, this doesn't fit with your requirements ? You need to go
in and tweak the options obviously.


David,

I was (erroniously) under the impression that only a single account's
transaction could be selected. Thanks to you I've learned differently.

Another day, another lesson learned.

Regards,

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

Re: [GNC] Selecting appropriate report

[David H]

The Transaction report certainly allows you to select Liability and Expense
accounts, this doesn't fit with your requirements ?  You need to go in and
tweak the options obviously.

Cheers David H.


On Sat, 6 Mar 2021 at 01:15, Rich Shepard  wrote:

> The SBA-PPP loan program allows businesses to apply for repayment
> forgiveness if the loan is used for specific purposes. I want to produce a
> report that shows the loan amount (a long term liability) and its
> distribution (an expense account).
>
> Looking at the available reports, I don't find one that will allow me to
> select both a liability and an expense account.
>
> I need to learn how to produce such a report so all suggestions and advice
> are appreciated.
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Access GNUCash From Different Devices

[David H]

Dated but probably still usable ?
https://github.com/codinguser/gnucash-android

Cheers David H.


On Sat, 6 Mar 2021 at 05:40, David Carlson 
wrote:

> You are making me jealous.  I have Android devices. 
>
> On Fri, Mar 5, 2021 at 11:19 AM Kenneth Schneider <
> kschnei...@bout-tyme.net>
> wrote:
>
> > This is going to a much welcome addition to the GNUCash family.
> >
> > Ken Schneider
> >
> > > On Mar 5, 2021, at 11:52 AM, John Ralls  wrote:
> > >
> > > This just in: A developer just now requested a wiki editing account
> > because he's created a simple GnuCash data-entry app for iOS and iPadOS.
> > See https://apps.apple.com/us/app/gnucash-mobile/id1556325950
> > >
> > > Regards,
> > > John Ralls
> > >
> > >> On Mar 5, 2021, at 4:58 AM, John Donnee  wrote:
> > >>
> > >> Thanks
> > >>
> > >> John
> > >>
> > >> On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:
> > >> Unfortunately no. The GUI framework GnuCash is built on doesn't
> support
> > iOS.
> > >>
> > >> Regards,
> > >> John Ralls
> > >>
> > >>
> >  On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
> > >>>
> > >>> Hi, I’ve been using GNYCash for nine years.
> > >>>
> > >>> Question:  I run my GNU system from a iMac. Is there a way to also
> > access
> > >>> my GNU system from my iPad?
> > >>>
> > >>> Thanks
> > >>>
> > >>> John Donnee
> > >>> --
> > >>> John J Donnee
> > >>>
> > >>> 317 Mount Eden Place
> > >>> Cary, NC 27518
> > >>> ___
> > >>> 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.
> > >>
> > >> --
> > >> John J Donnee
> > >>
> > >> 317 Mount Eden Place
> > >> Cary, NC 27518
> > >
> > > ___
> > > 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.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Access GNUCash From Different Devices

[David Carlson]

You are making me jealous.  I have Android devices. 

On Fri, Mar 5, 2021 at 11:19 AM Kenneth Schneider 
wrote:

> This is going to a much welcome addition to the GNUCash family.
>
> Ken Schneider
>
> > On Mar 5, 2021, at 11:52 AM, John Ralls  wrote:
> >
> > This just in: A developer just now requested a wiki editing account
> because he's created a simple GnuCash data-entry app for iOS and iPadOS.
> See https://apps.apple.com/us/app/gnucash-mobile/id1556325950
> >
> > Regards,
> > John Ralls
> >
> >> On Mar 5, 2021, at 4:58 AM, John Donnee  wrote:
> >>
> >> Thanks
> >>
> >> John
> >>
> >> On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:
> >> Unfortunately no. The GUI framework GnuCash is built on doesn't support
> iOS.
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
>  On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
> >>>
> >>> Hi, I’ve been using GNYCash for nine years.
> >>>
> >>> Question:  I run my GNU system from a iMac. Is there a way to also
> access
> >>> my GNU system from my iPad?
> >>>
> >>> Thanks
> >>>
> >>> John Donnee
> >>> --
> >>> John J Donnee
> >>>
> >>> 317 Mount Eden Place
> >>> Cary, NC 27518
> >>> ___
> >>> 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.
> >>
> >> --
> >> John J Donnee
> >>
> >> 317 Mount Eden Place
> >> Cary, NC 27518
> >
> > ___
> > 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.
>


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

Re: [GNC] Access GNUCash From Different Devices

[Kenneth Schneider]

This is going to a much welcome addition to the GNUCash family.

Ken Schneider 

> On Mar 5, 2021, at 11:52 AM, John Ralls  wrote:
> 
> This just in: A developer just now requested a wiki editing account because 
> he's created a simple GnuCash data-entry app for iOS and iPadOS. See 
> https://apps.apple.com/us/app/gnucash-mobile/id1556325950
> 
> Regards,
> John Ralls
> 
>> On Mar 5, 2021, at 4:58 AM, John Donnee  wrote:
>> 
>> Thanks
>> 
>> John
>> 
>> On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:
>> Unfortunately no. The GUI framework GnuCash is built on doesn't support iOS.
>> 
>> Regards,
>> John Ralls
>> 
>> 
 On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
>>> 
>>> Hi, I’ve been using GNYCash for nine years.
>>> 
>>> Question:  I run my GNU system from a iMac. Is there a way to also access
>>> my GNU system from my iPad?
>>> 
>>> Thanks
>>> 
>>> John Donnee
>>> -- 
>>> John J Donnee
>>> 
>>> 317 Mount Eden Place
>>> Cary, NC 27518
>>> ___
>>> 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.
>> 
>> -- 
>> John J Donnee
>> 
>> 317 Mount Eden Place
>> Cary, NC 27518
> 
> ___
> 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] Access GNUCash From Different Devices

[John Ralls]

This just in: A developer just now requested a wiki editing account because 
he's created a simple GnuCash data-entry app for iOS and iPadOS. See 
https://apps.apple.com/us/app/gnucash-mobile/id1556325950

Regards,
John Ralls

> On Mar 5, 2021, at 4:58 AM, John Donnee  wrote:
> 
> Thanks
> 
> John
> 
> On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:
> Unfortunately no. The GUI framework GnuCash is built on doesn't support iOS.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
> > 
> > Hi, I’ve been using GNYCash for nine years.
> > 
> > Question:  I run my GNU system from a iMac. Is there a way to also access
> > my GNU system from my iPad?
> > 
> > Thanks
> > 
> > John Donnee
> > -- 
> > John J Donnee
> > 
> > 317 Mount Eden Place
> > Cary, NC 27518
> > ___
> > 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.
> 
> -- 
> John J Donnee
> 
> 317 Mount Eden Place
> Cary, NC 27518

___
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] Access GNUCash From Different Devices

[John Donnee]

Thanks John

John Donnee

On Fri, Mar 5, 2021 at 11:40 AM John Ralls  wrote:

> This just in: A developer just now requested a wiki editing account
> because he's created a simple GnuCash data-entry app for iOS and iPadOS.
> See https://apps.apple.com/us/app/gnucash-mobile/id1556325950
>
> Regards,
> John Ralls
>
> > On Mar 5, 2021, at 4:58 AM, John Donnee  wrote:
> >
> > Thanks
> >
> > John
> >
> > On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:
> > Unfortunately no. The GUI framework GnuCash is built on doesn't support
> iOS.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
> > >
> > > Hi, I’ve been using GNYCash for nine years.
> > >
> > > Question:  I run my GNU system from a iMac. Is there a way to also
> access
> > > my GNU system from my iPad?
> > >
> > > Thanks
> > >
> > > John Donnee
> > > --
> > > John J Donnee
> > >
> > > 317 Mount Eden Place
> > > Cary, NC 27518
> > > ___
> > > 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 replie
> 
> s.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > --
> > John J Donnee
> >
> > 317 Mount Eden Place
> > Cary, NC 27518
>
> --
John J Donnee

317 Mount Eden Place
Cary, NC 27518
___
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] Selecting appropriate report

[Rich Shepard]

The SBA-PPP loan program allows businesses to apply for repayment
forgiveness if the loan is used for specific purposes. I want to produce a
report that shows the loan amount (a long term liability) and its
distribution (an expense account).

Looking at the available reports, I don't find one that will allow me to
select both a liability and an expense account.

I need to learn how to produce such a report so all suggestions and advice
are appreciated.

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

Re: [GNC] Import invoices ~ tax table

[R. Victor Klassen]

Bingo.  

This has been hanging around for a long time since 99% of our sales are 
zero-rated. Automatically catching the other 1% will reduce the opportunity for 
errors and speed up the process. 

Sent from my iPhone

> On Mar 5, 2021, at 7:13 AM, R. Victor Klassen  wrote:
> 
> I’m wondering whether I left out the “Tax Included” column, and whether 
> there are no important columns after that so it just (almost) works.
> 
> I’ll have another chance to try it out this morning, as we have an importable 
> invoice twice a week.  Something to try.
> 
>> On Mar 4, 2021, at 8:10 PM, Nelson Handcock  
>> wrote:
>> 
>> In your original email you say your GST Tax table is in column P - mine is 
>> in column Q. So perhaps that's the problem?
>> 
>> Thanks & Regards,
>> 
>> Nelson Handcock
>> 0409 149919
>> 
>> http://www.linkedin.com/in/nelsonhandcockaustralia
>> 
>> 
>> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock  
>> wrote:
>>> Hello,
>>> 
>>> Ahh yes - I mis-read your original email!
>>> 
>>> Here's a snapshot of my recent loadfile:
>>> 
>>> 
>>> And here's a snapshot of my tax tables:
>>> 
>>> 
>>> The loaded invoice looks fine in GN - the GST amount is correct and is 
>>> showing in the liabilities account as defined.
>>> 
>>> 
>>> Thanks & Regards,
>>> 
>>> Nelson Handcock
>>> 
>>> 
>>> 
>>> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen  
>>> wrote:
 When I said the x in the “Taxable?” column is correctly showing which 
 items are taxable, I was referring to the column in the invoice after 
 import.
 
 I do have a Y in the appropriate column of the csv file being imported - 
 else I wouldn’t get the x in the “Taxable?” column.
 
 
> On Mar 2, 2021, at 2:50 PM, Nelson Handcock  
> wrote:
> 
> Hello,
> 
> Try using "Y" in the Taxable column instead of "X"
> 
> Regards, etc
> 
> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen,  
> wrote:
>> The documentation I’ve read has me specify the tax table in column 15 
>> (counting from 0) aka column P when the csv file is opened as a 
>> spreadsheet. 
>> 
>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, 
>> both of which name sales tax tables, in that column, it is ignored. 
>> 
>> The x in the “Taxable?” Column is correctly showing which items are 
>> taxable. 
>> 
>> Is there a trick I am missing?
>> 
>> 
>> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
>> 
>> Sent from my iPhone
>> ___
>> 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] Access GNUCash From Different Devices

[John Donnee]

Thanks

John

On Thu, Mar 4, 2021 at 9:28 PM John Ralls  wrote:

> Unfortunately no. The GUI framework GnuCash is built on doesn't support
> iOS.
>
> Regards,
> John Ralls
>
>
> > On Mar 4, 2021, at 2:27 PM, John Donnee  wrote:
> >
> > Hi, I’ve been using GNYCash for nine years.
> >
> > Question:  I run my GNU system from a iMac. Is there a way to also access
> > my GNU system from my iPad?
> >
> > Thanks
> >
> > John Donnee
> > --
> > John J Donnee
> >
> > 317 Mount Eden Place
> > Cary, NC 27518
> > ___
> > 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.
>
> --
John J Donnee

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

Re: [GNC] Import invoices ~ tax table

[R. Victor Klassen]

I’m wondering whether I left out the “Tax Included” column, and whether there 
are no important columns after that so it just (almost) works.

I’ll have another chance to try it out this morning, as we have an importable 
invoice twice a week.  Something to try.

> On Mar 4, 2021, at 8:10 PM, Nelson Handcock  wrote:
> 
> In your original email you say your GST Tax table is in column P - mine is in 
> column Q. So perhaps that's the problem?
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 0409 149919
> 
> http://www.linkedin.com/in/nelsonhandcockaustralia 
> 
> 
> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock  > wrote:
> Hello,
> 
> Ahh yes - I mis-read your original email!
> 
> Here's a snapshot of my recent loadfile:
> 
> 
> And here's a snapshot of my tax tables:
> 
> 
> The loaded invoice looks fine in GN - the GST amount is correct and is 
> showing in the liabilities account as defined.
> 
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 
> 
> 
> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen  > wrote:
> When I said the x in the “Taxable?” column is correctly showing which items 
> are taxable, I was referring to the column in the invoice after import.
> 
> I do have a Y in the appropriate column of the csv file being imported - else 
> I wouldn’t get the x in the “Taxable?” column.
> 
> 
>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock > > wrote:
>> 
>> Hello,
>> 
>> Try using "Y" in the Taxable column instead of "X"
>> 
>> Regards, etc
>> 
>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, > > wrote:
>> The documentation I’ve read has me specify the tax table in column 15 
>> (counting from 0) aka column P when the csv file is opened as a spreadsheet. 
>>  
>> 
>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, 
>> both of which name sales tax tables, in that column, it is ignored. 
>> 
>> The x in the “Taxable?” Column is correctly showing which items are taxable. 
>> 
>> Is there a trick I am missing?
>> 
>> 
>> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
>> 
>> Sent from my iPhone
>> ___
>> 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.