Re: [GNC] Invoice emailing?

[david whiting]

Gnucash can use SQLite and that works well. I set up what Cam Ellison
described for our football club, where I needed to send about 450
statements at the end of each month showing players how much they had paid
and how much they owed. Querying the SQLite database to create the
statements as pdf files was quite easy. I wasn't using the business
features for that, as each player was a sub-account in Assets, rather than
a customer, but I did some other queries with invoices and can see how you
can easily get what you need.

David



On Tue, 3 Jan 2023 at 03:54, Simon Roberts 
wrote:

> Also an interesting idea. I'll keep that in mind and in the meantime make a
> background task to investigate documentation on how one runs this against a
> DB, and what makes any given DB compatible or not. I would be happy to run
> it against something like Derby or MySQL. Well, any open source DB that I
> can reliably connect to from Java/Scala I guess.
>
> Thanks for the idea Cam, much appreciated.
>
> Cheers,
> Simon
>
>
> On Mon, Jan 2, 2023 at 8:24 PM Cam Ellison  wrote:
>
> > If you use GnuCash with a database, and have the coding skills, you
> > could generate whatever invoice you want, and convert and email it. This
> > would be straightforward in most cases, though not trivial. Access to
> > the database is not confined to GnuCash itself. Just the same, you'd
> > have to do it outside of GnuCash.
> >
> > Cheers
> >
> > Cam
> >
> > On 2023-01-02 17:48, Adrien Monteleone wrote:
> > > If by 'directly' you mean from 'within GnuCash', no, you can't.
> > >
> > > Since the customer's e-mail address can appear on the invoice in their
> > > info block, you might be able to set up a script, possibly combined
> > > with a folder 'watcher' that can automate e-mailing a resulting PDF
> > > from printing the invoice to that e-mail address and crafting a
> > > subject line perhaps with the invoice number taken from the document.
> > >
> > > You can of course do the same thing with HTML, via running the invoice
> > > report, then use the Export button rather than print-to-file.
> > >
> > > How much of this you want to automate to reduce clicks is up to you.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 1/2/23 7:15 PM, Simon Roberts wrote:
> > >> Can I directly email PDF, or was Adrien correct?
> > >
> > >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> >
>
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Whiting
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Invoice emailing?

[Maf. King]

Just a further 0.02 on this.

generating a PDF in a folder gives you (with no extra work) a handy archive of 
invoice documents actually generated.  If you ever need to quickly refer to 
one (or have the tax man come to visit), an archive of PDFs is IMHO quicker 
than firing up GC and searching.  

But maybe I'm too old school...

Maf.


On Tuesday, 3 January 2023 08:48:28 GMT david whiting wrote:
> Gnucash can use SQLite and that works well. I set up what Cam Ellison
> described for our football club, where I needed to send about 450
> statements at the end of each month showing players how much they had paid
> and how much they owed. Querying the SQLite database to create the
> statements as pdf files was quite easy. I wasn't using the business
> features for that, as each player was a sub-account in Assets, rather than
> a customer, but I did some other queries with invoices and can see how you
> can easily get what you need.
> 
> David
> 
> 
> 
> On Tue, 3 Jan 2023 at 03:54, Simon Roberts 
> 
> wrote:
> > Also an interesting idea. I'll keep that in mind and in the meantime make
> > a
> > background task to investigate documentation on how one runs this against
> > a
> > DB, and what makes any given DB compatible or not. I would be happy to run
> > it against something like Derby or MySQL. Well, any open source DB that I
> > can reliably connect to from Java/Scala I guess.
> > 
> > Thanks for the idea Cam, much appreciated.
> > 
> > Cheers,
> > Simon
> > 
> > On Mon, Jan 2, 2023 at 8:24 PM Cam Ellison  wrote:
> > > If you use GnuCash with a database, and have the coding skills, you
> > > could generate whatever invoice you want, and convert and email it. This
> > > would be straightforward in most cases, though not trivial. Access to
> > > the database is not confined to GnuCash itself. Just the same, you'd
> > > have to do it outside of GnuCash.
> > > 
> > > Cheers
> > > 
> > > Cam
> > > 
> > > On 2023-01-02 17:48, Adrien Monteleone wrote:
> > > > If by 'directly' you mean from 'within GnuCash', no, you can't.
> > > > 
> > > > Since the customer's e-mail address can appear on the invoice in their
> > > > info block, you might be able to set up a script, possibly combined
> > > > with a folder 'watcher' that can automate e-mailing a resulting PDF
> > > > from printing the invoice to that e-mail address and crafting a
> > > > subject line perhaps with the invoice number taken from the document.
> > > > 
> > > > You can of course do the same thing with HTML, via running the invoice
> > > > report, then use the Export button rather than print-to-file.
> > > > 
> > > > How much of this you want to automate to reduce clicks is up to you.
> > > > 
> > > > Regards,
> > > > Adrien
> > > > 
> > > > On 1/2/23 7:15 PM, Simon Roberts wrote:
> > > >> Can I directly email PDF, or was Adrien correct?
> > > 
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > 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.
> > 
> > --
> > Simon Roberts
> > (303) 249 3613
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
To update your subscription preferences or to unsubscribe:
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: [GNC] Fields present in invoices?

[Steve Brown]

I've been wrestling with this too, specifically with regard to
invoices. This is a rather lengthy comment. I hope it is useful. Also,
if some of this is inaccurate, which is likely, please let me know.

I've looked at the wiki and sifted through the code trying to
understand how reports work. There appear to be two approaches.

One uses scheme to wrap html around the report variables. These report
files live in gnucash/report/reports/standard. Each has at least 3
sections, one to define the report, it's location in the menu and a
guid identifier, one for the options menu and one to render the report.
A report file can contain several report definitions that may share the
same render section. My opinion is that these files are quite opaque
and very fragile.

The other and apparently newer approach has a report file that contains
the same report and option sections as above, but preprocesses a html
document with embedded scheme tags and a companion css file to generate
scheme for the render section. The template and css files live in
gnucash/report/reports/support. At this point, only 3 reports have been
converted/rewritten using this approach. Only one is for invoices.

This second approach is discussed in the eguile section of the wiki but
seems out of sync with the implementation. A better explanation is in
the source of the preprocessor. It lives at gnucash/report/eguile.scm.

The report for printing invoices is chosen at Edit->preferences-
>business->Report for printing. That is a glade screen and is hardwired
to the guids of 4 specific reports, Printable, Fancy, Easy and Tax.
Only the latter uses the equile preprocessor. The first 3 are packaged
in a single file, invoice.scm. 

At this point, I plan to modify the tax invoice to meet my needs. This
seems to be the only way the Print Invoice button on the View Invoice
screen will generate my custom invoice. 




On Mon, 2023-01-02 at 17:32 -0700, Simon Roberts wrote:
> Still working on the invoice mechanism...
> 
> Is there any control over the fields displayed, auxiliary text, and
> perhaps
> the position of fields?
> 
> When I looked up how to change the appearance of the invoice, the
> docs only
> seem to talk about adding images.
> 
> In most cases I don't need "net price", "tax" or "total price" (I
> almost
> invariably bill a single "item" on a single invoice). Similarly the
> "Action", "Quantity", "Unit price", "discount" and "taxable" fields
> are
> generally irrelevant for me.
> On the other hand it would be nice to be able to include the Job
> description.
> 
> Thanks again,
> Cheers,
> Simon
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Problem adding a split to a currency conversion.

[Murugan Muruganandam]

David

your entries should be

Dr Assets:Bank account £424
Cr Income:Sales:Services sold worldwide (USD) : 540
Dr Expenses: Bank Fees : £7


when entering the transacitons , conversion pop up will be enabled, use the 
debit amount option and enter the action amount to avoid conversion issues.


Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Dr. 
David Kirkby 
Sent: Tuesday, January 3, 2023 10:08 AM
To: GNU Cash User 
Subject: [GNC] Problem adding a split to a currency conversion.

I have the following situation

I'm in the UK, where the currency is GBP
A customer in Poland paid $540 for consultancy via Zoom. He paid in
advance, so I've not added him as a customer under the business features.
My bank used an exchange rate of 1 USD = 0.7981499 GBP
540* 0.7981499 is approximately 431
Bank took a service charge of £7
Bank credited my company with £424

I tried to enter the above into GnuCash. The first thing was

DR: Assets:Bank account
CR: Income:Sales:Services sold worldwide (USD)

I did not enter the exchange rate, but entered the amount of £431 GBP.

So far that looked okay - the sales account credited with $540 and the bank
account a debit of £431.

Next I tried to split the £431 from the bank account, so £7 could be moved
into an account for bank fees. However, this brings up the currency
conversion tool, because it thinks the debit account is USD.

Is trying to split the transaction fundamentally flawed? Or a bad idea?

I can see two ways around this. I'm not sure what is technically best, but
I don't suppose my accountant will be too bothered, as long as explain the
transaction.

1) Add a completely new transaction for the movement of £7 to bank fees.

2) Ignore the £7, and just debit the bank account with £424 instead of
£431. The bank account statement makes no mention of the £431 gross or £7
fees, but only shows the £424 net.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Missing "Buy" action after import of QIF file

[ml]

Oops, I guess the mailing list doesn’t show attached images.

> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
> 
> In my import file:
> 
> ```
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ```
> 
> Import and GnuCash creates the correct account, but notice the lack of a 
> “Buy” action:
> 
> 
> 
> Is this a known issue or am I misunderstanding the need for the action to be 
> shown there?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
To update your subscription preferences or to unsubscribe:
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: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Hi,

On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
> Oops, I guess the mailing list doesn’t show attached images.

You need to attach it as a file, not embed it in HTML.

>
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>
>> In my import file:
>>
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>>
>> Import and GnuCash creates the correct account, but notice the lack of a
>> “Buy” action:

The QIF Importer should set the Action field, but it's possible it only
sets it on "one side" (which may not be the side you're looking at).

-derek

>>
>>
>>
>> Is this a known issue or am I misunderstanding the need for the action
>> to be shown there?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Fields present in invoices?

[Adrien Monteleone]

Interesting approach concerning modifying the tax invoice.

I'd say all of that sounds correct to my understanding as well, save I 
think you have the Scheme—HTML bit reversed.


The files are in Scheme, which generate the report as an HTML table. 
(not the other way around)


I'm pretty sure there are already several RFE's filed, but the ability 
to set one's own default report and default spreadsheet would greatly 
enhance the reporting system and avoid hacks like re-writing an existing 
report. (entirely inaccessible to most folks)


Regards,
Adrien

On 1/3/23 5:03 AM, Steve Brown wrote:

I've been wrestling with this too, specifically with regard to
invoices. This is a rather lengthy comment. I hope it is useful. Also,
if some of this is inaccurate, which is likely, please let me know.

I've looked at the wiki and sifted through the code trying to
understand how reports work. There appear to be two approaches.

One uses scheme to wrap html around the report variables. These report
files live in gnucash/report/reports/standard. Each has at least 3
sections, one to define the report, it's location in the menu and a
guid identifier, one for the options menu and one to render the report.
A report file can contain several report definitions that may share the
same render section. My opinion is that these files are quite opaque
and very fragile.

The other and apparently newer approach has a report file that contains
the same report and option sections as above, but preprocesses a html
document with embedded scheme tags and a companion css file to generate
scheme for the render section. The template and css files live in
gnucash/report/reports/support. At this point, only 3 reports have been
converted/rewritten using this approach. Only one is for invoices.

This second approach is discussed in the eguile section of the wiki but
seems out of sync with the implementation. A better explanation is in
the source of the preprocessor. It lives at gnucash/report/eguile.scm.

The report for printing invoices is chosen at Edit->preferences-

business->Report for printing. That is a glade screen and is hardwired

to the guids of 4 specific reports, Printable, Fancy, Easy and Tax.
Only the latter uses the equile preprocessor. The first 3 are packaged
in a single file, invoice.scm.

At this point, I plan to modify the tax invoice to meet my needs. This
seems to be the only way the Print Invoice button on the View Invoice
screen will generate my custom invoice.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Problem adding a split to a currency conversion.

[Adrien Monteleone]

On 1/3/23 7:08 AM, Dr. David Kirkby wrote:

I have the following situation

I'm in the UK, where the currency is GBP
A customer in Poland paid $540 for consultancy via Zoom. He paid in
advance, so I've not added him as a customer under the business features.
Murugan answered the main question on how to complete the transaction, 
but I'm curious:


Will this customer ever pay after receiving an invoice, rather than in 
advance?


Will you ever want a 'statement' of his activity?

If so, I'd treat him as a customer using the Business Features. If not, 
regular transactions are fine. I'm sure some folks have customers and 
vendors but never use the business features at all. (they are not 
strictly necessary, just convenient in some cases) Activity 'statements' 
are still possible, but take a bit more work with manual transactions.


Again, the route you take depends on your taste for convenience and 
tolerance for clicks. (You can always transition a customer or vendor 
without having to start over every time—just re-enter the historical 
data in the other format and then delete the old.)


However, if you did raise an invoice, the payment in this case requires 
a few more clicks. You have to make the payment first, then edit it to 
reflect the service charge. The end result will be the same though. 
(this is true of any 'business' payments where a part is not collected 
by you for whatever reason and is not limited to multi-currency 
transactions.)



Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Delete / Edit invoice doesn't?

[Simon Roberts]

Back again, and very grateful for your ongoing tolerance and help!

We just created an erroneous invoice, specifically it was assigned to the
wrong customer. Now we're finding two problems and I'm not sure if it's
user error, or something else.

1) If we try to edit the invoice, and use the pop-up dialog to change the
customer, it creates a *new* customer. This actually creates a duplicate,
as we've given it the customer number and the name. We can see two
customers side by side (well one on top of the other :) when we go for a
customer list.

2) If we try to delete the invoice, it seems to half-succeed. The entry
goes blank in the pane it was showing on, but if we do Customers->Find
Invoice, it still finds it, and that Find window shows its details. If we
click on it, it brings up the blank entry in the main tab that lists
invoices.

We've patched round this by re-opening the saved gnucash file that preceded
this mistake, but how should we do this, that obviously isn't what's
intended.

Cheers,
Simon


-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Fields present in invoices?

[Simon Roberts]

Steve, Adrien, thanks again. I think I shall have a look at hacking the
source for the default invoice. It's important to me to keep my
bookkeeper's life as easy as possible during this transition. Fortunately,
we have a very simple business with very few clients, and virtually all the
work is the same kind of service-based thing, so I should have no
difficulty creating a build-specific default that "just works" for our
needs. Then I'll wait till some of these RFEs are acted on and the world
will continue to improve :)

As a side question, Adrien, you commented that one of my replies had been
delayed. I notice there seem to be two distinct (although similar) email
addresses for the list:  gnucash-user@gnucash.org and
gnucash-u...@lists.gnucash.org. Evidently they end up in the same place,
but is one or other preferred?

Thanks again,
Simon


On Tue, Jan 3, 2023 at 9:44 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Interesting approach concerning modifying the tax invoice.
>
> I'd say all of that sounds correct to my understanding as well, save I
> think you have the Scheme—HTML bit reversed.
>
> The files are in Scheme, which generate the report as an HTML table.
> (not the other way around)
>
> I'm pretty sure there are already several RFE's filed, but the ability
> to set one's own default report and default spreadsheet would greatly
> enhance the reporting system and avoid hacks like re-writing an existing
> report. (entirely inaccessible to most folks)
>
> Regards,
> Adrien
>
> On 1/3/23 5:03 AM, Steve Brown wrote:
> > I've been wrestling with this too, specifically with regard to
> > invoices. This is a rather lengthy comment. I hope it is useful. Also,
> > if some of this is inaccurate, which is likely, please let me know.
> >
> > I've looked at the wiki and sifted through the code trying to
> > understand how reports work. There appear to be two approaches.
> >
> > One uses scheme to wrap html around the report variables. These report
> > files live in gnucash/report/reports/standard. Each has at least 3
> > sections, one to define the report, it's location in the menu and a
> > guid identifier, one for the options menu and one to render the report.
> > A report file can contain several report definitions that may share the
> > same render section. My opinion is that these files are quite opaque
> > and very fragile.
> >
> > The other and apparently newer approach has a report file that contains
> > the same report and option sections as above, but preprocesses a html
> > document with embedded scheme tags and a companion css file to generate
> > scheme for the render section. The template and css files live in
> > gnucash/report/reports/support. At this point, only 3 reports have been
> > converted/rewritten using this approach. Only one is for invoices.
> >
> > This second approach is discussed in the eguile section of the wiki but
> > seems out of sync with the implementation. A better explanation is in
> > the source of the preprocessor. It lives at gnucash/report/eguile.scm.
> >
> > The report for printing invoices is chosen at Edit->preferences-
> >> business->Report for printing. That is a glade screen and is hardwired
> > to the guids of 4 specific reports, Printable, Fancy, Easy and Tax.
> > Only the latter uses the equile preprocessor. The first 3 are packaged
> > in a single file, invoice.scm.
> >
> > At this point, I plan to modify the tax invoice to meet my needs. This
> > seems to be the only way the Print Invoice button on the View Invoice
> > screen will generate my custom invoice.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Delete / Edit invoice doesn't?

[Derek Atkins]

Hi,

On Tue, January 3, 2023 12:33 pm, Simon Roberts wrote:
> Back again, and very grateful for your ongoing tolerance and help!
>
> We just created an erroneous invoice, specifically it was assigned to the
> wrong customer. Now we're finding two problems and I'm not sure if it's
> user error, or something else.
>
> 1) If we try to edit the invoice, and use the pop-up dialog to change the
> customer, it creates a *new* customer. This actually creates a duplicate,
> as we've given it the customer number and the name. We can see two
> customers side by side (well one on top of the other :) when we go for a
> customer list.

First, you need to ensure the Invoice is not posted.
Second, you need to click "Edit Invoice" to get the popup.
>From there, you should be able to [SELECT] the Customer.  (If it says
[EDIT] and not [Select] then you've probably not unposted the invoice
properly).

It should not create a new Customer.


> 2) If we try to delete the invoice, it seems to half-succeed. The entry
> goes blank in the pane it was showing on, but if we do Customers->Find
> Invoice, it still finds it, and that Find window shows its details. If we
> click on it, it brings up the blank entry in the main tab that lists
> invoices.

There is no way to "delete" an invoice.  How are you attempting to do this?

The two things you can do if you make an erroneous invoice is:

1) You make mark it inactive.  This will hide if from the searches, or
2) You can re-use it by selecting a new customer.

>
> We've patched round this by re-opening the saved gnucash file that
> preceded
> this mistake, but how should we do this, that obviously isn't what's
> intended.
>
> Cheers,
> Simon

-derek

>
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Fields present in invoices?

[Steve Brown]

Looking further, the taxinvoice report Options->Display screen allows
using an alternate template and css file. On my system,
~/.local/share/gnucash is on the search path. I put the modified and
renamed files there and they get used. This works with a standard
distribution.

Unless you want to do your own build, you are stuck with the
taxinvoice.scm file that comes with the distribution.

I now have a new default invoice that places the company and addressee
properly in my window envelopes.


On Tue, 2023-01-03 at 10:47 -0700, Simon Roberts wrote:
> Steve, Adrien, thanks again. I think I shall have a look at hacking
> the
> source for the default invoice. It's important to me to keep my
> bookkeeper's life as easy as possible during this transition.
> Fortunately,
> we have a very simple business with very few clients, and virtually
> all the
> work is the same kind of service-based thing, so I should have no
> difficulty creating a build-specific default that "just works" for
> our
> needs. Then I'll wait till some of these RFEs are acted on and the
> world
> will continue to improve :)
> 
> As a side question, Adrien, you commented that one of my replies had
> been
> delayed. I notice there seem to be two distinct (although similar)
> email
> addresses for the list:  gnucash-user@gnucash.org and
> gnucash-u...@lists.gnucash.org. Evidently they end up in the same
> place,
> but is one or other preferred?
> 
> Thanks again,
> Simon
> 
> 
> On Tue, Jan 3, 2023 at 9:44 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > Interesting approach concerning modifying the tax invoice.
> > 
> > I'd say all of that sounds correct to my understanding as well,
> > save I
> > think you have the Scheme—HTML bit reversed.
> > 
> > The files are in Scheme, which generate the report as an HTML
> > table.
> > (not the other way around)
> > 
> > I'm pretty sure there are already several RFE's filed, but the
> > ability
> > to set one's own default report and default spreadsheet would
> > greatly
> > enhance the reporting system and avoid hacks like re-writing an
> > existing
> > report. (entirely inaccessible to most folks)
> > 
> > Regards,
> > Adrien
> > 
> > On 1/3/23 5:03 AM, Steve Brown wrote:
> > > I've been wrestling with this too, specifically with regard to
> > > invoices. This is a rather lengthy comment. I hope it is useful.
> > > Also,
> > > if some of this is inaccurate, which is likely, please let me
> > > know.
> > > 
> > > I've looked at the wiki and sifted through the code trying to
> > > understand how reports work. There appear to be two approaches.
> > > 
> > > One uses scheme to wrap html around the report variables. These
> > > report
> > > files live in gnucash/report/reports/standard. Each has at least
> > > 3
> > > sections, one to define the report, it's location in the menu and
> > > a
> > > guid identifier, one for the options menu and one to render the
> > > report.
> > > A report file can contain several report definitions that may
> > > share the
> > > same render section. My opinion is that these files are quite
> > > opaque
> > > and very fragile.
> > > 
> > > The other and apparently newer approach has a report file that
> > > contains
> > > the same report and option sections as above, but preprocesses a
> > > html
> > > document with embedded scheme tags and a companion css file to
> > > generate
> > > scheme for the render section. The template and css files live in
> > > gnucash/report/reports/support. At this point, only 3 reports
> > > have been
> > > converted/rewritten using this approach. Only one is for
> > > invoices.
> > > 
> > > This second approach is discussed in the eguile section of the
> > > wiki but
> > > seems out of sync with the implementation. A better explanation
> > > is in
> > > the source of the preprocessor. It lives at
> > > gnucash/report/eguile.scm.
> > > 
> > > The report for printing invoices is chosen at Edit->preferences-
> > > > business->Report for printing. That is a glade screen and is
> > > > hardwired
> > > to the guids of 4 specific reports, Printable, Fancy, Easy and
> > > Tax.
> > > Only the latter uses the equile preprocessor. The first 3 are
> > > packaged
> > > in a single file, invoice.scm.
> > > 
> > > At this point, I plan to modify the tax invoice to meet my needs.
> > > This
> > > seems to be the only way the Print Invoice button on the View
> > > Invoice
> > > screen will generate my custom invoice.
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
To update your subscription preferences or to unsubscribe:

Re: [GNC] Delete / Edit invoice doesn't?

[Simon Roberts]

Hah, well, I did:

Business->Customer->FindInvoice.
Double click the invoice in the list, close the finder window.
Select the invoice "row"
Click "Delete" in the toolbar, brings up "Are you sure you want to delete
the selected entry"
Click yes.

But having just tried this with more than one item in the invoice (that was
an inspiration--it literally never happens in my business!) I now see
what I actually achieved--it just deleted the single line item, not the
invoice.

So, next question, and this might not have an answer other than opinion, in
which case that's fine, sometimes the answer is "the software design makes
that kinda hard and it's not a priority"; but is there a rationale behind
not being able to delete an invoice? Humans make mistakes, and being able
to undo them would seem to be... helpful?

And on poking around, it seems like one cannot delete a Customer either
(even if there are no transactions associated with it). Again, it seems
somewhat suboptimal in the face of the inevitable human propensity to err.

The "Edit..." right next to Customer:
[image: image.png]
... yeah, I see now that you point it out, it brings up a window marked "*Edit
Customer*"--meaning edit the customer itself. It doesn't equate to "edit
which customer this invoice is applied to", that's represented by "Select"
in a whole other window that comes from the "Edit Invoice" button on the
top line.

I would never have cottoned-on to the significance of that wording, nor
worked out how to do this, if you hadn't pointed it out, many thanks.

OK, well, if there's a rationale that might help me, great, but I think I
get what's going on here now.

Again, many thanks for rescuing me yet again everyone, and thank you for
all of your input Derek.

Cheers,
Simon


On Tue, Jan 3, 2023 at 10:55 AM Derek Atkins  wrote:

> Hi,
>
> On Tue, January 3, 2023 12:33 pm, Simon Roberts wrote:
> > Back again, and very grateful for your ongoing tolerance and help!
> >
> > We just created an erroneous invoice, specifically it was assigned to the
> > wrong customer. Now we're finding two problems and I'm not sure if it's
> > user error, or something else.
> >
> > 1) If we try to edit the invoice, and use the pop-up dialog to change the
> > customer, it creates a *new* customer. This actually creates a duplicate,
> > as we've given it the customer number and the name. We can see two
> > customers side by side (well one on top of the other :) when we go for a
> > customer list.
>
> First, you need to ensure the Invoice is not posted.
> Second, you need to click "Edit Invoice" to get the popup.
> From there, you should be able to [SELECT] the Customer.  (If it says
> [EDIT] and not [Select] then you've probably not unposted the invoice
> properly).
>
> It should not create a new Customer.
>
>
> > 2) If we try to delete the invoice, it seems to half-succeed. The entry
> > goes blank in the pane it was showing on, but if we do Customers->Find
> > Invoice, it still finds it, and that Find window shows its details. If we
> > click on it, it brings up the blank entry in the main tab that lists
> > invoices.
>
> There is no way to "delete" an invoice.  How are you attempting to do this?
>
> The two things you can do if you make an erroneous invoice is:
>
> 1) You make mark it inactive.  This will hide if from the searches, or
> 2) You can re-use it by selecting a new customer.
>
> >
> > We've patched round this by re-opening the saved gnucash file that
> > preceded
> > this mistake, but how should we do this, that obviously isn't what's
> > intended.
> >
> > Cheers,
> > Simon
>
> -derek
>
> >
> >
> > --
> > Simon Roberts
> > (303) 249 3613
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Fields present in invoices?

[Simon Roberts]

This sounds great Steve, thanks. I'll pursue that!

Cheers,
Simon


On Tue, Jan 3, 2023 at 11:34 AM Steve Brown  wrote:

> Looking further, the taxinvoice report Options->Display screen allows
> using an alternate template and css file. On my system,
> ~/.local/share/gnucash is on the search path. I put the modified and
> renamed files there and they get used. This works with a standard
> distribution.
>
> Unless you want to do your own build, you are stuck with the
> taxinvoice.scm file that comes with the distribution.
>
> I now have a new default invoice that places the company and addressee
> properly in my window envelopes.
>
>
> On Tue, 2023-01-03 at 10:47 -0700, Simon Roberts wrote:
> > Steve, Adrien, thanks again. I think I shall have a look at hacking
> > the
> > source for the default invoice. It's important to me to keep my
> > bookkeeper's life as easy as possible during this transition.
> > Fortunately,
> > we have a very simple business with very few clients, and virtually
> > all the
> > work is the same kind of service-based thing, so I should have no
> > difficulty creating a build-specific default that "just works" for
> > our
> > needs. Then I'll wait till some of these RFEs are acted on and the
> > world
> > will continue to improve :)
> >
> > As a side question, Adrien, you commented that one of my replies had
> > been
> > delayed. I notice there seem to be two distinct (although similar)
> > email
> > addresses for the list:  gnucash-user@gnucash.org and
> > gnucash-u...@lists.gnucash.org. Evidently they end up in the same
> > place,
> > but is one or other preferred?
> >
> > Thanks again,
> > Simon
> >
> >
> > On Tue, Jan 3, 2023 at 9:44 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> > > Interesting approach concerning modifying the tax invoice.
> > >
> > > I'd say all of that sounds correct to my understanding as well,
> > > save I
> > > think you have the Scheme—HTML bit reversed.
> > >
> > > The files are in Scheme, which generate the report as an HTML
> > > table.
> > > (not the other way around)
> > >
> > > I'm pretty sure there are already several RFE's filed, but the
> > > ability
> > > to set one's own default report and default spreadsheet would
> > > greatly
> > > enhance the reporting system and avoid hacks like re-writing an
> > > existing
> > > report. (entirely inaccessible to most folks)
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 1/3/23 5:03 AM, Steve Brown wrote:
> > > > I've been wrestling with this too, specifically with regard to
> > > > invoices. This is a rather lengthy comment. I hope it is useful.
> > > > Also,
> > > > if some of this is inaccurate, which is likely, please let me
> > > > know.
> > > >
> > > > I've looked at the wiki and sifted through the code trying to
> > > > understand how reports work. There appear to be two approaches.
> > > >
> > > > One uses scheme to wrap html around the report variables. These
> > > > report
> > > > files live in gnucash/report/reports/standard. Each has at least
> > > > 3
> > > > sections, one to define the report, it's location in the menu and
> > > > a
> > > > guid identifier, one for the options menu and one to render the
> > > > report.
> > > > A report file can contain several report definitions that may
> > > > share the
> > > > same render section. My opinion is that these files are quite
> > > > opaque
> > > > and very fragile.
> > > >
> > > > The other and apparently newer approach has a report file that
> > > > contains
> > > > the same report and option sections as above, but preprocesses a
> > > > html
> > > > document with embedded scheme tags and a companion css file to
> > > > generate
> > > > scheme for the render section. The template and css files live in
> > > > gnucash/report/reports/support. At this point, only 3 reports
> > > > have been
> > > > converted/rewritten using this approach. Only one is for
> > > > invoices.
> > > >
> > > > This second approach is discussed in the eguile section of the
> > > > wiki but
> > > > seems out of sync with the implementation. A better explanation
> > > > is in
> > > > the source of the preprocessor. It lives at
> > > > gnucash/report/eguile.scm.
> > > >
> > > > The report for printing invoices is chosen at Edit->preferences-
> > > > > business->Report for printing. That is a glade screen and is
> > > > > hardwired
> > > > to the guids of 4 specific reports, Printable, Fancy, Easy and
> > > > Tax.
> > > > Only the latter uses the equile preprocessor. The first 3 are
> > > > packaged
> > > > in a single file, invoice.scm.
> > > >
> > > > At this point, I plan to modify the tax invoice to meet my needs.
> > > > This
> > > > seems to be the only way the Print Invoice button on the View
> > > > Invoice
> > > > screen will generate my custom invoice.
> > >
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:

Re: [GNC] Scary moment

[David G. Pickett via gnucash-user]

Yes, currently we depend on a lock file, which is sensible in a very 
traditional model.  In many apps, you can mod a file in one app and other app 
notifies you that the file changed and you can reload, like two text editors on 
the same machine.

If you have unsaved changes in the less current GnuCash instance, that is a 
mixed deal of your own making (merging changes is an AI or diff3 sort of 
problem).  But if you are modifying and saving successively on two machines in 
cloud backed files, it'd be "nice" (a modest enhancement) if the less current 
GnuCash instance read in the changes, or offered to/warned you.  Just a thought 
in passing!

-Original Message-
From: R Losey 
To: David G. Pickett 
Cc: Gnucash Users 
Sent: Mon, Jan 2, 2023 5:08 pm
Subject: Re: [GNC] Scary moment

If I  have GnuCash on one machine and then attempt to open it on another 
machine, there is a warning that the LCK file is present. (I don't know if that 
was what you intended to ask, but I have done this a couple of times by 
accident).

On Mon, Jan 2, 2023 at 11:10 AM David G. Pickett via gnucash-user 
 wrote:


If open on multiple machines, does gnuCash notice save on one machine in open 
session on other machine, as many apps do when the local copy is updated ?  
Should it?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.



-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Delete / Edit invoice doesn't?

[Murugan Muruganandam]

Simon

Deleting invoices are not allowed as per law in many states.  The reason is the 
tax authorities prefer to see your continous running invoice numbers.   i think 
this came from  the tax authorities to avoid any errors/frauds. Again with 
newer connected tax systems where invoices are transmitted to Tax authorities, 
it is impossible to delete the same.
So the best way to negate an invoice is to issue a credit note and close it, so 
you will have a trail to show.




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Simon Roberts 
Sent: Tuesday, January 3, 2023 4:11 PM
To: Derek Atkins 
Cc: Gnucash Users 
Subject: Re: [GNC] Delete / Edit invoice doesn't?

Hah, well, I did:

Business->Customer->FindInvoice.
Double click the invoice in the list, close the finder window.
Select the invoice "row"
Click "Delete" in the toolbar, brings up "Are you sure you want to delete
the selected entry"
Click yes.

But having just tried this with more than one item in the invoice (that was
an inspiration--it literally never happens in my business!) I now see
what I actually achieved--it just deleted the single line item, not the
invoice.

So, next question, and this might not have an answer other than opinion, in
which case that's fine, sometimes the answer is "the software design makes
that kinda hard and it's not a priority"; but is there a rationale behind
not being able to delete an invoice? Humans make mistakes, and being able
to undo them would seem to be... helpful?

And on poking around, it seems like one cannot delete a Customer either
(even if there are no transactions associated with it). Again, it seems
somewhat suboptimal in the face of the inevitable human propensity to err.

The "Edit..." right next to Customer:
[image: image.png]
... yeah, I see now that you point it out, it brings up a window marked "*Edit
Customer*"--meaning edit the customer itself. It doesn't equate to "edit
which customer this invoice is applied to", that's represented by "Select"
in a whole other window that comes from the "Edit Invoice" button on the
top line.

I would never have cottoned-on to the significance of that wording, nor
worked out how to do this, if you hadn't pointed it out, many thanks.

OK, well, if there's a rationale that might help me, great, but I think I
get what's going on here now.

Again, many thanks for rescuing me yet again everyone, and thank you for
all of your input Derek.

Cheers,
Simon


On Tue, Jan 3, 2023 at 10:55 AM Derek Atkins  wrote:

> Hi,
>
> On Tue, January 3, 2023 12:33 pm, Simon Roberts wrote:
> > Back again, and very grateful for your ongoing tolerance and help!
> >
> > We just created an erroneous invoice, specifically it was assigned to the
> > wrong customer. Now we're finding two problems and I'm not sure if it's
> > user error, or something else.
> >
> > 1) If we try to edit the invoice, and use the pop-up dialog to change the
> > customer, it creates a *new* customer. This actually creates a duplicate,
> > as we've given it the customer number and the name. We can see two
> > customers side by side (well one on top of the other :) when we go for a
> > customer list.
>
> First, you need to ensure the Invoice is not posted.
> Second, you need to click "Edit Invoice" to get the popup.
> From there, you should be able to [SELECT] the Customer.  (If it says
> [EDIT] and not [Select] then you've probably not unposted the invoice
> properly).
>
> It should not create a new Customer.
>
>
> > 2) If we try to delete the invoice, it seems to half-succeed. The entry
> > goes blank in the pane it was showing on, but if we do Customers->Find
> > Invoice, it still finds it, and that Find window shows its details. If we
> > click on it, it brings up the blank entry in the main tab that lists
> > invoices.
>
> There is no way to "delete" an invoice.  How are you attempting to do this?
>
> The two things you can do if you make an erroneous invoice is:
>
> 1) You make mark it inactive.  This will hide if from the searches, or
> 2) You can re-use it by selecting a new customer.
>
> >
> > We've patched round this by re-opening the saved gnucash file that
> > preceded
> > this mistake, but how should we do this, that obviously isn't what's
> > intended.
> >
> > Cheers,
> > Simon
>
> -derek
>
> >
> >
> > --
> > Simon Roberts
> > (303) 249 3613
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

--
Simon Roberts
(303) 249 3613

Re: [GNC] Fields present in invoices?

[Adrien Monteleone]

I don't think they end up in the same place. I also checked the archive 
and the message was not there. I only saw it because you also happened 
to copy me personally.


gnucash-user@gnucash.org works

gnucash-u...@lists.gnucash.org did not go through.

Regards,
Adrien

On 1/3/23 11:47 AM, Simon Roberts wrote:

As a side question, Adrien, you commented that one of my replies had been
delayed. I notice there seem to be two distinct (although similar) email
addresses for the list:  gnucash-user@gnucash.org and
gnucash-u...@lists.gnucash.org. Evidently they end up in the same place,
but is one or other preferred?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Delete / Edit invoice doesn't?

[Adrien Monteleone]

That is true, but not the reason GnuCash doesn't offer the facility to 
delete them. (you could edit and change the invoice number, as a work 
around)


Maybe Derek can shed light on the code reasoning. I vaguely recall it 
being discussed a few years ago, but I long since lost that thread.


Since I don't need an auditable trail, I just re-use errant 
invoices/bills either assigning them to another customer/vendor and/or 
changing the details like date and number.


When I end up in this case but can't re-use just yet, I change the 
invoice number to "USE NEXT" and then I try to remember to do a Find 
Invoice on that phrase next time I need one.


Regards,
Adrien

On 1/3/23 1:53 PM, Murugan Muruganandam wrote:

Deleting invoices are not allowed as per law in many states.  The reason is the 
tax authorities prefer to see your continous running invoice numbers.   i think 
this came from  the tax authorities to avoid any errors/frauds. Again with 
newer connected tax systems where invoices are transmitted to Tax authorities, 
it is impossible to delete the same.
So the best way to negate an invoice is to issue a credit note and close it, so 
you will have a trail to show.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Problem adding a split to a currency conversion.

[Dr. David Kirkby]

On Tue, 3 Jan 2023 at 17:00, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
> On 1/3/23 7:08 AM, Dr. David Kirkby wrote:
> > I have the following situation
> >
> > I'm in the UK, where the currency is GBP
> > A customer in Poland paid $540 for consultancy via Zoom. He paid in
> > advance, so I've not added him as a customer under the business features.
> Murugan answered the main question on how to complete the transaction,
> but I'm curious:
>
> Will this customer ever pay after receiving an invoice, rather than in
> advance?
>

No.

>
> Will you ever want a 'statement' of his activity?
>

No.

>
> If so, I'd treat him as a customer using the Business Features. If not,
> regular transactions are fine. I'm sure some folks have customers and
> vendors but never use the business features at all. (they are not
> strictly necessary, just convenient in some cases) Activity 'statements'
> are still possible, but take a bit more work with manual transactions.
>


>
> Again, the route you take depends on your taste for convenience and
> tolerance for clicks. (You can always transition a customer or vendor
> without having to start over every time—just re-enter the historical
> data in the other format and then delete the old.)
>

Unless I am mistaken, it is not easy to delete transactions when using the
business features. I don't think one can simply delete a transaction and it
goes away.

It would be helpful if the manual had a section on how to edit transactions
that used the business features. My experience tends to be

* Unpost
* Edit
* Post
* Struggle to find how to mark the invoice as paid. *This part is tricky!*

However, if you did raise an invoice, the payment in this case requires
> a few more clicks. You have to make the payment first, then edit it to
> reflect the service charge. The end result will be the same though.
> (this is true of any 'business' payments where a part is not collected
> by you for whatever reason and is not limited to multi-currency
> transactions.)
>

I did originally have this person as a customer and used the business
features. But I think yourself and others pointed out that Accounts Payable
or Accounts Receivable are really designed for when offers or receives
credit, not where the payment is settled at the time of purchase or sale.

As I wrote, it's unlikely that I will keep this person as a regular
customer. However, there are a few vendors I use on a regular basis that I
don't have credit facilities with, but which it might be beneficial to keep
a record of what I spend with them.

Is it possible to add a company as a customer or vendor, but then pay them
directly, without the transactions going through Accounts Receivable or
Accounts Payable?

Regards,
> Adrien
>

Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Clarification of Total (Period) column

[Kalpesh Patel]

Hi GNC community –

 

I have added a column called ‘Total (Period)’ in the accounts view page but
I am not sure what that period is? I made changes to it in the ‘Edit à
Preference à Accounting Period’ but didn’t change the value there so I don’t
think the “period” denoted is in anyway reflected from there. I am curious
to know what that “period” entails, if that is something changeable and if
so where.

 

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] new user, new file

[Jamie Tolbert]

Starting a new business. For the next month or so, what few bills I have 
will be paid by me, until I get my business checking set up. Its been 
years since I studied double entry accounting, but I thought if I paid a 
bill for lets say 100.00, I would credit my owner account for 100.00 and 
debit whatever expense account it is. I cant find how to credit my owner 
account, or opening balance.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Problem adding a split to a currency conversion.

[Adrien Monteleone]

On 1/3/23 2:43 PM, Dr. David Kirkby wrote:

Unless I am mistaken, it is not easy to delete transactions when using the
business features. I don't think one can simply delete a transaction and it
goes away.


You can't delete invoices, but you can remove their entries in your 
books by un-posting.


You can then re-use those invoices by assigning them to another Customer 
and/or changing the invoice number and other details. (date, line items, 
terms, etc.)



It would be helpful if the manual had a section on how to edit transactions
that used the business features. My experience tends to be

* Unpost
* Edit
* Post


That's the correct procedure for posted invoices/bills and should be 
covered in the documentation.



* Struggle to find how to mark the invoice as paid. *This part is tricky!*


Where are you struggling?

When viewing the invoice click the Pay Invoice button on the toolbar, or 
use Business > Customer > Process Payment...


If you've already manually entered a payment transaction, or imported 
it, then right-click the transaction and choose "Assign as payment"


All of those methods get you to the Process Payment window.

1. Search & Select the customer
2. Select the invoice(s) being paid
3. Edit the amount paid if different than the outstanding balance 
(auto-filled by GnuCash for you)

4. Confirm the date.
5. Enter notes if needed
6. Assign the Transfer account. (usually matches the payment method: 
cash, undeposited funds, bank, etc.)


If you have pre-payments or previous over-payments retained, then select 
them also in step 2 above to offset the invoices accordingly.


If you have a more complicated payment transaction, similar to the one 
you describe with a bank fee, perform the above steps, then edit the 
payment transaction directly in the register to reflect the fee and 
reduce the amount that ended up in your hands.


Most cases will be as simple as 'Process Payment' on a one-to-one basis 
of payments-invoices.



I did originally have this person as a customer and used the business
features. But I think yourself and others pointed out that Accounts Payable
or Accounts Receivable are really designed for when offers or receives
credit, not where the payment is settled at the time of purchase or sale.


Generally true, but as noted then and in my previous reply here, there 
may be good reasons to keep them as a Customer and use the Business 
Features. Also as noted, you'll have to weigh that for yourself. And 
that consideration I offered was specific to people you pay, not 
necessarily people who pay you. For example, it may not be worth the 
trouble to treat your corner gas station as a vendor if you pay them 
each fill-up, even for a company vehicle, but it might well be worth it 
to treat a pre-paying customer, as a customer with invoices, statements, 
etc. Only you will know what works best for you. There are no hard and 
fast rules, outside of what your lawyer & CPA tell you.


As an illustration, a business I used to work for had a point of sale 
system that captured name, address & phone number for each sale. This 
was because usually, those customers were having some item delivered, or 
wanted us to retain a purchase history for them. But there were plenty 
of 'cash sales' (even paid by credit card) for small parts or one-off 
purchases where the customer was not interested in giving such info. We 
still entered an invoice in the point of sale system because it adjusted 
our inventory, but the 'customer' on those invoices was literally "CASH 
SALE" with the store address and phone number.


There were also cases of 'cash sale' repair payments. Those were done 
with a paper receipt book and entered as an aggregate for the day, not 
even individual transactions. (the sales from the POS system were also 
entered as a daily summary in the books, not as individual transactions 
- the systems were separate entirely.)



As I wrote, it's unlikely that I will keep this person as a regular
customer. However, there are a few vendors I use on a regular basis that I
don't have credit facilities with, but which it might be beneficial to keep
a record of what I spend with them.

Is it possible to add a company as a customer or vendor, but then pay them
directly, without the transactions going through Accounts Receivable or
Accounts Payable?


You can, but then there's little or no point to having them as a Vendor. 
The associated built-in reports or other features aren't cognizant of 
manual transactions.


You can still get something like a 'Vendor Report', but you'll have to 
finagle that from other existing reports on your own. (the Transaction 
Report comes to mind)


Think of it this way:

You can do everything manually the old-school way.

You can optionally use some built-in functionality to reduce workload 
and for added convenience in the case of Payables & Receivables.


Where you draw that line is up to you, and may involve simple trial, 
error, time, and experience.


Regar

Re: [GNC] Clarification of Total (Period) column

[Adrien Monteleone]

Hmmm... I'm seeing the same thing.

It appears to default to 'this year' regardless of the setting.

I'd call that a bug.

Regards,
Adrien

On 1/3/23 3:14 PM, Kalpesh Patel wrote:

I have added a column called ‘Total (Period)’ in the accounts view page but
I am not sure what that period is? I made changes to it in the ‘Edit à
Preference à Accounting Period’ but didn’t change the value there so I don’t
think the “period” denoted is in anyway reflected from there. I am curious
to know what that “period” entails, if that is something changeable and if
so where.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] new user, new file

[Adrien Monteleone]

It sounds like you are considering your current personal payments as 
your equity investment as you pay, rather than fronting the money and 
then using it from there.


You should be able to simply:

Dr. Expense
  Cr. Equity:Owner's Capital

(or whatever you determine is the best name for that account)

There is nothing special about the 'opening balance' entries.

If you need to edit one, just do so.

If you need to add one, just add it. They are just transactions between 
the respective asset/liability and Equity:Opening Balances account.


Regards,
Adrien

On 1/3/23 3:15 PM, Jamie Tolbert wrote:
Starting a new business. For the next month or so, what few bills I have 
will be paid by me, until I get my business checking set up. Its been 
years since I studied double entry accounting, but I thought if I paid a 
bill for lets say 100.00, I would credit my owner account for 100.00 and 
debit whatever expense account it is. I cant find how to credit my owner 
account, or opening balance.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] new user, new file

[Adrien Monteleone]

Jamie,

Please use Reply-List or Reply-All to keep the discussion on the list. 
I've copied your personal reply below.



I'm not sure why that would happen. I just added an Equity account with 
no issue.


Let's be sure we're discussing the same thing.

At initially creating a new book with the opening Wizard, you should 
have in the Accounts tab:


Equity
Equity:Opening Balances

If you double-click the Opening Balances account line, it should open a 
register with your various opening balance transactions. They should all 
be editable. You can also add more or delete some if needed. (You do 
this *in the register* for the Opening Balances account, *not* via 
'Edit' on an account. The opening balance transaction for any account is 
usually the first one. You can also edit it from those registers.)


From that same Accounts tab, if you select (single click):

Equity

(the parent account)

Then click the New button on the toolbar, you will be in the New Account 
dialog, with Equity already chosen as the parent of the new account. 
(you can change that if you want to)


Simply finish creating the new account as desired. You can then open the 
register for that account to enter transactions.



Regards,
Adrien

On 1/3/23 3:51 PM, Jamie Tolbert wrote:

When I try to edit an opening balance account, to add a subaccount Owners 
capital, it says the account is read only ?!?!?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] new user, new file

[Jamie Tolbert]

I tried that, same results.screenshot attached.  I did find where to 
remove the placeholder option, but same result:





-- Original Message --

From "Adrien Monteleone" 

To gnucash-u...@lists.gnucash.org
Date 1/3/2023 5:03:54 PM
Subject Re: [GNC] new user, new file


Jamie,

Please use Reply-List or Reply-All to keep the discussion on the list. I've 
copied your personal reply below.


I'm not sure why that would happen. I just added an Equity account with no 
issue.

Let's be sure we're discussing the same thing.

At initially creating a new book with the opening Wizard, you should have in 
the Accounts tab:

Equity
Equity:Opening Balances

If you double-click the Opening Balances account line, it should open a 
register with your various opening balance transactions. They should all be 
editable. You can also add more or delete some if needed. (You do this *in the 
register* for the Opening Balances account, *not* via 'Edit' on an account. The 
opening balance transaction for any account is usually the first one. You can 
also edit it from those registers.)

From that same Accounts tab, if you select (single click):

Equity

(the parent account)

Then click the New button on the toolbar, you will be in the New Account 
dialog, with Equity already chosen as the parent of the new account. (you can 
change that if you want to)

Simply finish creating the new account as desired. You can then open the 
register for that account to enter transactions.


Regards,
Adrien

On 1/3/23 3:51 PM, Jamie Tolbert wrote:

When I try to edit an opening balance account, to add a subaccount Owners 
capital, it says the account is read only ?!?!?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Missing "Buy" action after import of QIF file

[Kalpesh Patel]

Your QIF may not be complete. I believe it is not documented but need first
four lines and the last line as shown in the below example; carets are
important in qif format as well! This would be the minimal example:

!Account
NTest
TInvst
 ^
!Type:Invst
D12/2/2022
NBuy
PXYZ, INC
YXYZ
I150
T450
Q3
CR
M3 shares @ 150; Nothing to see here
^


With that qif file contents, a top level 'Test' account created, child
account called 'XYZ' created under 'Test' account, a buy entry for 3 shares
created and a new security called XYZ under NONCURRENCY namespace created. I
also think back ticks at beginning and end of the one you provided in the
message are extraneous when included.

I am on Windows 11 running GNC v4.11.

--

Message: 2
Date: Tue, 3 Jan 2023 09:37:05 -0600
From: m...@tgr66.me
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Missing "Buy" action after import of QIF file
Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
Content-Type: text/plain;   charset=utf-8

Oops, I guess the mailing list doesn?t show attached images.

> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
> 
> In my import file:
> 
> ```
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ```
> 
> Import and GnuCash creates the correct account, but notice the lack of a
?Buy? action:
> 
> 
> 
> Is this a known issue or am I misunderstanding the need for the action to
be shown there?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



--

Message: 3
Date: Tue, 3 Jan 2023 10:46:56 -0500
From: "Derek Atkins" 
To: m...@tgr66.me
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Missing "Buy" action after import of QIF file
Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
Content-Type: text/plain;charset=utf-8

Hi,

On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
> Oops, I guess the mailing list doesn?t show attached images.

You need to attach it as a file, not embed it in HTML.

>
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>
>> In my import file:
>>
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>>
>> Import and GnuCash creates the correct account, but notice the lack 
>> of a ?Buy? action:

The QIF Importer should set the Action field, but it's possible it only sets
it on "one side" (which may not be the side you're looking at).

-derek

>>
>>
>>
>> Is this a known issue or am I misunderstanding the need for the 
>> action to be shown there?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant



--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] new user, new file

[Stan Brown]

On 2023-01-03 13:15, Jamie Tolbert wrote:
> Starting a new business. For the next month or so, what few bills I have
> will be paid by me, until I get my business checking set up. Its been
> years since I studied double entry accounting, but I thought if I paid a
> bill for lets say 100.00, I would credit my owner account for 100.00 and
> debit whatever expense account it is. I cant find how to credit my owner
> account, or opening balance.

Welcome to GnuCash!

I strongly recommend a quick review of double-entry bookkeeping, for
instance in GC's Tutorial and Concepts manual. Believe me, it'll save
you a world of pain. (GC just automates the big leatherbound ledgers of
traditional bookkeeping. The "rules" of using GC are just the same as
the rules of bookkeeping.)

In your example, you would not credit Equity ("my owner account") when
you pay a bill. Crediting an equity account increases its balance, and
you don't own anything more than you did before you paid the bill. Your
equity in the business is the net of assets minus liabilities, but it's
quite rare that you would make any transaction in an equity account
directly. (The net of current-period income minus expenses is a special
kind of equity, often called Retained Earnings.)

Liabilities, Equity, Income -- credits increase, debits decrease
Assets, Expenses -- credits decrease, debits increase

The bill is a liability, specifically in Accounts Payable, and credits
also increase liability balances. So you would _debit_ Accounts Payable
to reduce the amount you owe.

What are you paying the bill with? Presumably cash, or maybe a check or
bank transfer, possibly a credit card. You would _credit_ the account
for whatever method you used to pay the bill.

Your cash and bank accounts are assets, so a credit reduces their
balance. Your credit cards are liabilities, just like Accounts Payable,
so a credit _increases_ their balance.(*) Either way it makes sense: you
give up some cash or money-in-bank (credit an asset) to wipe out a bill
(debit a liability), _or_ you_ add to your credit-card balance (credit a
liability) to wipe out a bill (debit a different liability).

In every transaction, total credits must equal total debits.

(*)People often get confused about credits and debits when dealing with
a bank account or credit card, a credit on the bank's books is a debit
on yours, and vice versa. When you write a check, you are reducing the
amount in your bank account (crediting an asset). But to the bank, your
checking account is a liability, so when your check is cashed the bank
reduces the amount in your checking account (debiting a liability).
Similarly, when you return a purchase for a "credit", it's a credit on
the bank's books (reducing an asset, Accounts Receivable) but it's
really a debit to you (reducing your liability, Accounts Payable).

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new user, new file

[Adrien Monteleone]

Strange.

Placeholder would stop you from editing or adding transactions in the 
account, but it doesn't stop me from creating a sub-account.


Try creating Owner's Capital as a sub of the parent: Equity instead.

Also, what version of GnuCash and what OS?

Regards,
Adrien

On 1/3/23 4:07 PM, Jamie Tolbert wrote:
I tried that, same results.screenshot attached.  I did find where to 
remove the placeholder option, but same result:


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] new user, new file

[Jamie Tolbert]

I got it, thanksjust need to wrap my head around the software,


-- Original Message --

From "Adrien Monteleone" 

To gnucash-u...@lists.gnucash.org
Date 1/3/2023 5:12:36 PM
Subject Re: [GNC] new user, new file


Strange.

Placeholder would stop you from editing or adding transactions in the account, 
but it doesn't stop me from creating a sub-account.

Try creating Owner's Capital as a sub of the parent: Equity instead.

Also, what version of GnuCash and what OS?

Regards,
Adrien

On 1/3/23 4:07 PM, Jamie Tolbert wrote:

I tried that, same results.screenshot attached.  I did find where to remove the 
placeholder option, but same result:


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Missing "Buy" action after import of QIF file

[ml]

I only included the snippet relevant to the question; my real file has the 
header lines and carets. The back ticks were included because I’m used to using 
those to show a code block :-) They’re not in the real file. I’ll include the 
entire test file at the end of this message.

So I just double checked, and the Buy action is not selected in either the 
`XYZ` account or in “Joint Brokerage” account. I don’t know where else I should 
be looking.

I’m on Mac with GnuCash v4.13. 

I can also try on a Linux box.

!Account
NAssets:Investments:Brokerage Account:Joint Brokerage
TInvst
^
!Type:Bank
D01/11/2020
NPayment/Deposit
PTrf My Bank
CX
T1,000.00
MDeposit
LAssets:Current Assets:My Bank
^
!Type:Invst
D12/2/2022
NBuy
PXYZ, INC
YXYZ
I150
T450
Q3
CR
M3 shares @ 150; Nothing to see here
^
!Type:Invst
D1/1/2023
NDiv
PXYZ, INC
YXYZ
T16.23
CR
MInvestments:Dividend Income; Still nothing
^


> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
> 
> Your QIF may not be complete. I believe it is not documented but need first
> four lines and the last line as shown in the below example; carets are
> important in qif format as well! This would be the minimal example:
> 
> !Account
> NTest
> TInvst
> ^
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ^
> 
> 
> With that qif file contents, a top level 'Test' account created, child
> account called 'XYZ' created under 'Test' account, a buy entry for 3 shares
> created and a new security called XYZ under NONCURRENCY namespace created. I
> also think back ticks at beginning and end of the one you provided in the
> message are extraneous when included.
> 
> I am on Windows 11 running GNC v4.11.
> 
> --
> 
> Message: 2
> Date: Tue, 3 Jan 2023 09:37:05 -0600
> From: m...@tgr66.me
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
> Content-Type: text/plain; charset=utf-8
> 
> Oops, I guess the mailing list doesn?t show attached images.
> 
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>> 
>> In my import file:
>> 
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>> 
>> Import and GnuCash creates the correct account, but notice the lack of a
> ?Buy? action:
>> 
>> 
>> 
>> Is this a known issue or am I misunderstanding the need for the action to
> be shown there?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
> 
> 
> 
> --
> 
> Message: 3
> Date: Tue, 3 Jan 2023 10:46:56 -0500
> From: "Derek Atkins" 
> To: m...@tgr66.me
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
> Content-Type: text/plain;charset=utf-8
> 
> Hi,
> 
> On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
>> Oops, I guess the mailing list doesn?t show attached images.
> 
> You need to attach it as a file, not embed it in HTML.
> 
>> 
>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>> 
>>> In my import file:
>>> 
>>> ```
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ```
>>> 
>>> Import and GnuCash creates the correct account, but notice the lack 
>>> of a ?Buy? action:
> 
> The QIF Importer should set the Action field, but it's possible it only sets
> it on "one side" (which may not be the side you're looking at).
> 
> -derek
> 
>>> 
>>> 
>>> 
>>> Is this a known issue or am I misunderstanding the need for the 
>>> action to be shown there?
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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
>> To update your subscription preferences or to unsubscribe:
>> 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.
>> 
> 
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> 
> 
> --
> 

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Are you in double-line mode?  If not, try turning that on..

-derek

On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
> I only included the snippet relevant to the question; my real file has the
> header lines and carets. The back ticks were included because I’m used to
> using those to show a code block :-) They’re not in the real file. I’ll
> include the entire test file at the end of this message.
>
> So I just double checked, and the Buy action is not selected in either the
> `XYZ` account or in “Joint Brokerage” account. I don’t know where else I
> should be looking.
>
> I’m on Mac with GnuCash v4.13.
>
> I can also try on a Linux box.
>
> !Account
> NAssets:Investments:Brokerage Account:Joint Brokerage
> TInvst
> ^
> !Type:Bank
> D01/11/2020
> NPayment/Deposit
> PTrf My Bank
> CX
> T1,000.00
> MDeposit
> LAssets:Current Assets:My Bank
> ^
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ^
> !Type:Invst
> D1/1/2023
> NDiv
> PXYZ, INC
> YXYZ
> T16.23
> CR
> MInvestments:Dividend Income; Still nothing
> ^
>
>
>> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
>>
>> Your QIF may not be complete. I believe it is not documented but need
>> first
>> four lines and the last line as shown in the below example; carets are
>> important in qif format as well! This would be the minimal example:
>>
>> !Account
>> NTest
>> TInvst
>> ^
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ^
>>
>>
>> With that qif file contents, a top level 'Test' account created, child
>> account called 'XYZ' created under 'Test' account, a buy entry for 3
>> shares
>> created and a new security called XYZ under NONCURRENCY namespace
>> created. I
>> also think back ticks at beginning and end of the one you provided in
>> the
>> message are extraneous when included.
>>
>> I am on Windows 11 running GNC v4.11.
>>
>> --
>>
>> Message: 2
>> Date: Tue, 3 Jan 2023 09:37:05 -0600
>> From: m...@tgr66.me
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
>> Content-Type: text/plain;charset=utf-8
>>
>> Oops, I guess the mailing list doesn?t show attached images.
>>
>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>>
>>> In my import file:
>>>
>>> ```
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ```
>>>
>>> Import and GnuCash creates the correct account, but notice the lack of
>>> a
>> ?Buy? action:
>>>
>>>
>>>
>>> Is this a known issue or am I misunderstanding the need for the action
>>> to
>> be shown there?
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>
>>
>>
>> --
>>
>> Message: 3
>> Date: Tue, 3 Jan 2023 10:46:56 -0500
>> From: "Derek Atkins" 
>> To: m...@tgr66.me
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>> Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
>> Content-Type: text/plain;charset=utf-8
>>
>> Hi,
>>
>> On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
>>> Oops, I guess the mailing list doesn?t show attached images.
>>
>> You need to attach it as a file, not embed it in HTML.
>>
>>>
 On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:

 In my import file:

 ```
 !Type:Invst
 D12/2/2022
 NBuy
 PXYZ, INC
 YXYZ
 I150
 T450
 Q3
 CR
 M3 shares @ 150; Nothing to see here
 ```

 Import and GnuCash creates the correct account, but notice the lack
 of a ?Buy? action:
>>
>> The QIF Importer should set the Action field, but it's possible it only
>> sets
>> it on "one side" (which may not be the side you're looking at).
>>
>> -derek
>>



 Is this a known issue or am I misunderstanding the need for the
 action to be shown there?
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 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
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please rememb

Re: [GNC] Missing "Buy" action after import of QIF file

[ml]

Yes. Trying again to paste a screen cap.



I also tried on my Linux box and got the same result. No action showing.


> On Jan 3, 2023, at 18:27, Derek Atkins  wrote:
> 
> Are you in double-line mode?  If not, try turning that on..
> 
> -derek
> 
> On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
>> I only included the snippet relevant to the question; my real file has the
>> header lines and carets. The back ticks were included because I’m used to
>> using those to show a code block :-) They’re not in the real file. I’ll
>> include the entire test file at the end of this message.
>> 
>> So I just double checked, and the Buy action is not selected in either the
>> `XYZ` account or in “Joint Brokerage” account. I don’t know where else I
>> should be looking.
>> 
>> I’m on Mac with GnuCash v4.13.
>> 
>> I can also try on a Linux box.
>> 
>> !Account
>> NAssets:Investments:Brokerage Account:Joint Brokerage
>> TInvst
>> ^
>> !Type:Bank
>> D01/11/2020
>> NPayment/Deposit
>> PTrf My Bank
>> CX
>> T1,000.00
>> MDeposit
>> LAssets:Current Assets:My Bank
>> ^
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ^
>> !Type:Invst
>> D1/1/2023
>> NDiv
>> PXYZ, INC
>> YXYZ
>> T16.23
>> CR
>> MInvestments:Dividend Income; Still nothing
>> ^
>> 
>> 
>>> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
>>> 
>>> Your QIF may not be complete. I believe it is not documented but need
>>> first
>>> four lines and the last line as shown in the below example; carets are
>>> important in qif format as well! This would be the minimal example:
>>> 
>>> !Account
>>> NTest
>>> TInvst
>>> ^
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ^
>>> 
>>> 
>>> With that qif file contents, a top level 'Test' account created, child
>>> account called 'XYZ' created under 'Test' account, a buy entry for 3
>>> shares
>>> created and a new security called XYZ under NONCURRENCY namespace
>>> created. I
>>> also think back ticks at beginning and end of the one you provided in
>>> the
>>> message are extraneous when included.
>>> 
>>> I am on Windows 11 running GNC v4.11.
>>> 
>>> --
>>> 
>>> Message: 2
>>> Date: Tue, 3 Jan 2023 09:37:05 -0600
>>> From: m...@tgr66.me
>>> To: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
>>> Content-Type: text/plain;   charset=utf-8
>>> 
>>> Oops, I guess the mailing list doesn?t show attached images.
>>> 
 On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
 
 In my import file:
 
 ```
 !Type:Invst
 D12/2/2022
 NBuy
 PXYZ, INC
 YXYZ
 I150
 T450
 Q3
 CR
 M3 shares @ 150; Nothing to see here
 ```
 
 Import and GnuCash creates the correct account, but notice the lack of
 a
>>> ?Buy? action:
 
 
 
 Is this a known issue or am I misunderstanding the need for the action
 to
>>> be shown there?
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 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.
>>> 
>>> 
>>> 
>>> --
>>> 
>>> Message: 3
>>> Date: Tue, 3 Jan 2023 10:46:56 -0500
>>> From: "Derek Atkins" 
>>> To: m...@tgr66.me
>>> Cc: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
>>> Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
>>> Content-Type: text/plain;charset=utf-8
>>> 
>>> Hi,
>>> 
>>> On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
 Oops, I guess the mailing list doesn?t show attached images.
>>> 
>>> You need to attach it as a file, not embed it in HTML.
>>> 
 
> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
> 
> In my import file:
> 
> ```
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ```
> 
> Import and GnuCash creates the correct account, but notice the lack
> of a ?Buy? action:
>>> 
>>> The QIF Importer should set the Action field, but it's possible it only
>>> sets
>>> it on "one side" (which may not be the side you're looking at).
>>> 
>>> -derek
>>> 
> 
> 
> 
> Is this a known issue or am I misunderstanding the need for the
> action to be shown there?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo

Re: [GNC] Missing "Buy" action after import of QIF file

[Derek Atkins]

Screen cap came through (at least to me) -- but you cut out too much info
so I can't tell what I'm supposed to be seeing or not.

-derek

On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote:
> Yes. Trying again to paste a screen cap.
>
>
>
> I also tried on my Linux box and got the same result. No action showing.
>
>
>> On Jan 3, 2023, at 18:27, Derek Atkins  wrote:
>>
>> Are you in double-line mode?  If not, try turning that on..
>>
>> -derek
>>
>> On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
>>> I only included the snippet relevant to the question; my real file has
>>> the
>>> header lines and carets. The back ticks were included because I’m used
>>> to
>>> using those to show a code block :-) They’re not in the real file. I’ll
>>> include the entire test file at the end of this message.
>>>
>>> So I just double checked, and the Buy action is not selected in either
>>> the
>>> `XYZ` account or in “Joint Brokerage” account. I don’t know where else
>>> I
>>> should be looking.
>>>
>>> I’m on Mac with GnuCash v4.13.
>>>
>>> I can also try on a Linux box.
>>>
>>> !Account
>>> NAssets:Investments:Brokerage Account:Joint Brokerage
>>> TInvst
>>> ^
>>> !Type:Bank
>>> D01/11/2020
>>> NPayment/Deposit
>>> PTrf My Bank
>>> CX
>>> T1,000.00
>>> MDeposit
>>> LAssets:Current Assets:My Bank
>>> ^
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ^
>>> !Type:Invst
>>> D1/1/2023
>>> NDiv
>>> PXYZ, INC
>>> YXYZ
>>> T16.23
>>> CR
>>> MInvestments:Dividend Income; Still nothing
>>> ^
>>>
>>>
 On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:

 Your QIF may not be complete. I believe it is not documented but need
 first
 four lines and the last line as shown in the below example; carets are
 important in qif format as well! This would be the minimal example:

 !Account
 NTest
 TInvst
 ^
 !Type:Invst
 D12/2/2022
 NBuy
 PXYZ, INC
 YXYZ
 I150
 T450
 Q3
 CR
 M3 shares @ 150; Nothing to see here
 ^


 With that qif file contents, a top level 'Test' account created, child
 account called 'XYZ' created under 'Test' account, a buy entry for 3
 shares
 created and a new security called XYZ under NONCURRENCY namespace
 created. I
 also think back ticks at beginning and end of the one you provided in
 the
 message are extraneous when included.

 I am on Windows 11 running GNC v4.11.

 --

 Message: 2
 Date: Tue, 3 Jan 2023 09:37:05 -0600
 From: m...@tgr66.me
 To: gnucash-user@gnucash.org
 Subject: Re: [GNC] Missing "Buy" action after import of QIF file
 Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
 Content-Type: text/plain;  charset=utf-8

 Oops, I guess the mailing list doesn?t show attached images.

> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>
> In my import file:
>
> ```
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ```
>
> Import and GnuCash creates the correct account, but notice the lack
> of
> a
 ?Buy? action:
>
>
>
> Is this a known issue or am I misunderstanding the need for the
> action
> to
 be shown there?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.



 --

 Message: 3
 Date: Tue, 3 Jan 2023 10:46:56 -0500
 From: "Derek Atkins" 
 To: m...@tgr66.me
 Cc: gnucash-user@gnucash.org
 Subject: Re: [GNC] Missing "Buy" action after import of QIF file
 Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
 Content-Type: text/plain;charset=utf-8

 Hi,

 On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
> Oops, I guess the mailing list doesn?t show attached images.

 You need to attach it as a file, not embed it in HTML.

>
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>
>> In my import file:
>>
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>>
>> Import and GnuCash creates the correct account, but notice the lack
>> of a ?Buy? action:

 The QIF Importer should set the Action field, but it's possible it
 only
 sets
 it on "one side" (which may not be the side you're looking at

Re: [GNC] Missing "Buy" action after import of QIF file

[ml]

This is what I would expect to see. Note the “Buy” in the Action field.



However, I had to add that as the QIF import process doesn’t appear to be doing 
it.



Thank you.

> On Jan 3, 2023, at 18:50, Derek Atkins  wrote:
> 
> Screen cap came through (at least to me) -- but you cut out too much info
> so I can't tell what I'm supposed to be seeing or not.
> 
> -derek
> 
> On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote:
>> Yes. Trying again to paste a screen cap.
>> 
>> 
>> 
>> I also tried on my Linux box and got the same result. No action showing.
>> 
>> 
>>> On Jan 3, 2023, at 18:27, Derek Atkins  wrote:
>>> 
>>> Are you in double-line mode?  If not, try turning that on..
>>> 
>>> -derek
>>> 
>>> On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote:
 I only included the snippet relevant to the question; my real file has
 the
 header lines and carets. The back ticks were included because I’m used
 to
 using those to show a code block :-) They’re not in the real file. I’ll
 include the entire test file at the end of this message.
 
 So I just double checked, and the Buy action is not selected in either
 the
 `XYZ` account or in “Joint Brokerage” account. I don’t know where else
 I
 should be looking.
 
 I’m on Mac with GnuCash v4.13.
 
 I can also try on a Linux box.
 
 !Account
 NAssets:Investments:Brokerage Account:Joint Brokerage
 TInvst
 ^
 !Type:Bank
 D01/11/2020
 NPayment/Deposit
 PTrf My Bank
 CX
 T1,000.00
 MDeposit
 LAssets:Current Assets:My Bank
 ^
 !Type:Invst
 D12/2/2022
 NBuy
 PXYZ, INC
 YXYZ
 I150
 T450
 Q3
 CR
 M3 shares @ 150; Nothing to see here
 ^
 !Type:Invst
 D1/1/2023
 NDiv
 PXYZ, INC
 YXYZ
 T16.23
 CR
 MInvestments:Dividend Income; Still nothing
 ^
 
 
> On Jan 3, 2023, at 16:09, Kalpesh Patel  wrote:
> 
> Your QIF may not be complete. I believe it is not documented but need
> first
> four lines and the last line as shown in the below example; carets are
> important in qif format as well! This would be the minimal example:
> 
> !Account
> NTest
> TInvst
> ^
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ^
> 
> 
> With that qif file contents, a top level 'Test' account created, child
> account called 'XYZ' created under 'Test' account, a buy entry for 3
> shares
> created and a new security called XYZ under NONCURRENCY namespace
> created. I
> also think back ticks at beginning and end of the one you provided in
> the
> message are extraneous when included.
> 
> I am on Windows 11 running GNC v4.11.
> 
> --
> 
> Message: 2
> Date: Tue, 3 Jan 2023 09:37:05 -0600
> From: m...@tgr66.me
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me>
> Content-Type: text/plain; charset=utf-8
> 
> Oops, I guess the mailing list doesn?t show attached images.
> 
>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>> 
>> In my import file:
>> 
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>> 
>> Import and GnuCash creates the correct account, but notice the lack
>> of
>> a
> ?Buy? action:
>> 
>> 
>> 
>> Is this a known issue or am I misunderstanding the need for the
>> action
>> to
> be shown there?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
> 
> 
> 
> --
> 
> Message: 3
> Date: Tue, 3 Jan 2023 10:46:56 -0500
> From: "Derek Atkins" 
> To: m...@tgr66.me
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org>
> Content-Type: text/plain;charset=utf-8
> 
> Hi,
> 
> On Tue, January 3, 2023 10:37 am, m...@tgr66.me wrote:
>> Oops, I guess the mailing list doesn?t show attached images.
> 
> You need to attach it as a file, not embed it in HTML.
> 
>> 
>>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote:
>>> 
>>> In my import file:
>>> 
>>

[GNC] Transfer between receivable accounts

[davidvernonlong]

I run the accounting for a member's club. Members are customers in the
accounts receivables. 

Sometime a member may pay the invoices of several other members in one cash
payment.  For example, in family situations where father pays membership
invoices of his children who are also members.

What I would like to do is to transfer the balances from the children's
account in A/R to the father's account in A/R, and then process the total
payment in the fathers A/R.

 

The only way I can find to do this is through intermediary accounts which I
set up for that purpose. But it is rather clunky  and looks ugly om the
individual accounts receivable at the transfer  transaction is entitled
"refund" or "payment", as the only way I could find of making the transfer
was though the process payment transaction .

 

Is there a more direct way of making a transfer between A/R accounts?  

 

Thanks

 

David Long

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Are accountants happy with CVS exports?

[Dr. David Kirkby]

On Mon, 2 Jan 2023 at 22:08, Stephen M. Butler 
wrote:

> My CPA accepts the Balance Sheet and Profit/Loss Statement along with a
> multi-page Q&A his office provides.


Do you not provide details of what the individual transactions to your
accountant? If you do provide that, do you just use the unedited CSV files
exported from GnuCash?

Dave
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Transfer between receivable accounts

[Adrien Monteleone]

There's no direct method of transferring balances or payments between AR 
accounts. (sadly, but GnuCash is not unique in this regard)


Some type of intermediary account would be required. (likely, one that 
is a sub-account of AR so as not to disrupt the overall AR balance)


While not as 'clean' as a direct method, what do you find is 'clunky'?

What is your exact workflow?

Note, the intermediary account(s) might not touch AR directly unless you 
need them to. (indeed you might)


Another way to think of such payments is akin to someone purchasing a 
Gift Card for someone else.


How you'd handle *that* accounting should be similar to one AR account 
paying on another's behalf.


If strictly necessary, you may find it cleaner and easier (though more 
clicks) to 'sell' a Gift Certificate type 'line item' on an invoice to a 
Customer, and then Process Payment for it.


And all of the above with the usual caveat: "I am not an accountant and 
this is not professional advice."



Regards,
Adrien

On 1/3/23 7:38 PM, davidvernonl...@gmail.com wrote:

I run the accounting for a member's club. Members are customers in the
accounts receivables.

Sometime a member may pay the invoices of several other members in one cash
payment.  For example, in family situations where father pays membership
invoices of his children who are also members.

What I would like to do is to transfer the balances from the children's
account in A/R to the father's account in A/R, and then process the total
payment in the fathers A/R.

  


The only way I can find to do this is through intermediary accounts which I
set up for that purpose. But it is rather clunky  and looks ugly om the
individual accounts receivable at the transfer  transaction is entitled
"refund" or "payment", as the only way I could find of making the transfer
was though the process payment transaction .

  


Is there a more direct way of making a transfer between A/R accounts?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Are accountants happy with CVS exports?

[Stephen M. Butler]

On 1/3/23 17:43, Dr. David Kirkby wrote:


multi-page Q&A his office provides.


Do you not provide details of what the individual transactions to your 
accountant? If you do provide that, do you just use the unedited CSV 
files exported from GnuCash?


Dave


I do print off a detailed transaction report by account/date.  So far 
they haven't asked for it.


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] import settings file

[Kevin T via gnucash-user]

All,
I have moved the base gnucash data files to a different location on the file 
system (windows).
All of the 'saved' import settings have been lost.
Where are these import settings saved?  Is it a single file or embedded in some 
other ?
The import settings aren't covered in the 
https://wiki.gnucash.org/wiki/Configuration_Locations document.  Searching 
through AppData I find nothing.
Thanks.
Kevin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Clarification of Total (Period) column

[devaps]

I think one shows total as of today and the other shows total for today and 
beyond…

This distinction helps me and I don’t think it’s a bug. For my use case, I 
setup any future known income or future tax payments till the end of my tax 
year., by entering all those future transactions at the beginning of the year 
itself. 

So if my current balance is 100, that’s shown in Total (Period) column. But in 
the register I have future dated entries for all the interest incomes due 
during the year as well as any taxes owed by year end. Let’s say the future 
income is 20 and future tax liability is 5, then my total column will show -

100+20~5 = 115.

This distinction tells me how much I have at my disposal to spend till end of 
year. 

I think the budget report can be used to do something similar, but this is easy 
enough for me to track and understand. 

Cheers. 

--
> 
> Date: Tue, 3 Jan 2023 15:28:57 -0600
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Clarification of Total (Period) column
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Hmmm... I'm seeing the same thing.
> 
> It appears to default to 'this year' regardless of the setting.
> 
> I'd call that a bug.
> 
> Regards,
> Adrien
> 
> On 1/3/23 3:14 PM, Kalpesh Patel wrote:
> > I have added a column called ?Total (Period)? in the accounts view page but
> > I am not sure what that period is? I made changes to it in the ?Edit ?
> > Preference ? Accounting Period? but didn?t change the value there so I don?t
> > think the ?period? denoted is in anyway reflected from there. I am curious
> > to know what that ?period? entails, if that is something changeable and if
> > so where.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Request for Automatic Reconciliation Function

[Bite Gao]

   GnuCash Developers and Maintainers:
  Hello! While your software has done many tedious jobs previously
   done by
   accountants manually, it cannot automatically reconcile its accounting
   data
   to the bank statement in its digital form. In my opinion, the
   automation of
   reconciliation is not only efficient but also accurate since it reduces
   human-caused errors.
  I would appreciate you a lot if you could add an auto-reconciliation
   function to your software.
  Yours,
 Bite Gao
   Jan 4th, 2023
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.