Re: [GNC] Bank account reconciled, will this change screw things up?

[Dr. David Kirkby]

On Sat, 31 Dec 2022 at 07:43, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

>
> >> I would only use them for cases where you are billed (incurred the
> >> expense) before you pay, not at the same time.
> >>
> >
> > Why is that?
>
> Because that is the purpose of Accounts Payable. It helps you keep track
> of short term liabilities.
>
> If you pay for something at the point of sale, there is no liability
> incurred.
>
> > I seem to have something that works for me, so I guess it’s okay. But
> > perhaps I am doing an excessive number of mouse clicks.
>
> By all means, do what works for you. When I first started, I was
> treating almost everyone as a Vendor and quickly figured out, most of
> them were unnecessary.
>
> As noted above, I now only raise bills for entities I really receive a
> bill from that isn't paid immediately, or that I don't need to otherwise
> track in such fashion. But that's just me.
>
>
> Regards,
> Adrien


You made me rethink my strategy. I decided to start the accounts from
scratch, only using vendors where I have a trade account.

My main reason was for thinking it’s going to be far more work for my and
to track money moving  around unnecessary accounts.

I would like a pound for every time that I wave started entering
transactions into GnuCash, then later starting again. But one might as well
start in the best way, and be consistent.

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.

[GNC] Budget report fails in multiple currencies

[ml enquirer]

Dear all,

I spend in two currencies and, historically, I chose to create separate
accounts under each expense line for each currency. In future I will do
this differently, employing trading accounts, but what I'm about to
describe should still work. I budget in my 'home' currency, and the budget
report would combine the "sub-spends" in each currency (using the price
database).

However, the "Actual" budget totals don't behave as I expected. I've set up
a simple scenario to explain:
1) I set up an assets and expense ("Groceries") account
Under each I set up a "GBP" and a "EUR" account
3) On 1st Jan of 2020, 2021, 2022, 2023 I spend 10,000 EUR and 10,000 GBP
on "Groceries"
4) I set up the price database with four entries, on 1st Jan:
 - 1/1/2020 1GBP = 1EUR
 - 1/1/2021 1GBP = 2EUR
 - 1/1/2022 1GBP = 1EUR

I've attached a simple reproducer ("bugreport.gnucash", though perhaps this
is not a bug so filename might be inappropriate!).

When I look at the default budget report, I see that the total per year is
always 10,000 of each currency in the sub-accounts, as expected, but the
budget's "Act" total under "Groceries" is:
1/1/2020: £15,000 [I expect £20,000 because EUR=GBP on 1/1/20]
1/1/2021: £15,000 [I expect £15,000 because 1EUR=0.5GBP on 1/1/21]
1/1/2022: £30,000 [I expect £20,000 because 1EUR=1GBP on 1/1/22]
1/1/2023: £20,000 [I expect £20,000 because 1EUR=1GBP on 1/1/23]

Can someone explain where my naive expectation is wrong? Is GnuCash doing
some strange interpolation between exchange rate values?

Many thanks in advance.


bugreport.gnucash
Description: application/gnucash
___
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] How to "Get Quotes" for a specific day?

[ml enquirer]

Hi Michael,

I've faced the same problem. I use the gnucash python bindings and the
following script, to import prices from a text file which has date
(-MM-DD) and price with a new date on each line.

Hope it could be some use. As always, test it before deploying! Best wishes.

```python
import datetime
from gnucash import Session, Account, Split, GncCommodity, GncPrice

url = "personal.gnucash"

# Initialize Gnucash session
session = Session(url, True, False, False)
book = session.book
pdb = book.get_price_db()
comm_table = book.get_table()

# Define commodities
sec_gbp = GncCommodity(book,"Pound Sterling", "CURRENCY", "GBP", "826", 100)
sec_chf = GncCommodity(book,"Swiss Franc", "CURRENCY", "CHF", "756", 100)

def extractFXrateFromFile(filename,book,pdb,sec_base,sec_curr):
  with open(filename) as myFile :
for line in myFile.readlines() :
  splitLine = line.split(' ')
  y,m,d = (int(x) for x in splitLine[0].split("-"))

  price = GncPrice(book)
  price.set_time64( datetime.datetime(y,m,d) )
  value = price.get_value()
  value.denom = int( 1e10 )
  rate = float(splitLine[1])
  value.num = int( rate * 1e10 )
  price.set_value(value)
  price.set_currency( sec_curr )
  price.set_commodity( sec_base )
  pdb.add_price(price)

extractFXrateFromFile("chf_per_gbp.txt", book, pdb, sec_chf, sec_gbp)

session.save()
session.end()
session.destroy()
```

On Fri, Dec 30, 2022 at 5:19 AM  wrote:

> How can I tell GNU Cash to update its "Price Database" for all known
> currencies, stocks, bonds, mutual funds, etc for a *specific* day?
>
> I'm trying trying to prepare a report for a date in the past. I've set the
> `Options` for the report to `nearest in time` so that it will grab the
> prices for the commodities from the Price Database that are closest to the
> date of the report as possible.
>
>  *
> https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports
>
> Well, I checked the Price Database, and I have gaps in the prices for some
> of my stocks. For many stocks, I don't have any prices defined for the day
> of the report. Therefore, my report may be inaccurate.
>
> I know that I can go to `Tools` -> `Price Database` and click the `Get
> Quotes` button. This will fetch the current quote (price) and add it to the
> Price Database for all defined currencies, stocks, bonds, mutual funds,
> etc. But that will fetch and add the prices for *today's date* only.
>
> How can I do the equivalent of `Get Quotes` but for a specific day in the
> *past*?
>
> (see also
> https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash
> )
> ___
> 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.

[GNC] Trial Balance Report Settings

[Benjamin Soffer]

Hello and Happy New Year!

I have lots of accounts with zero balances (which I must keep for legal 
reasons).  When I run a Trial Balance report, all of those accounts are 
included in the report, making the report much longer than necessary.  Is there 
a setting that would enable me to exclude zero-balance accounts from the Trial 
Balance report?

I am using Version: 4.8, Build ID: 4.8a+(2021-09-28)

Thank you!

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

Re: [GNC] Scary moment

[David G. Pickett via gnucash-user]

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.

[GNC] Undo a reconciliation?

[Simon Roberts]

Hi all, question from my bookkeeper.

She performed a reconciliation, but had not added an interest payment to
the account. Because of that the reconciliation was wrong. For reasons that
went unnoticed, and likely cannot be reproduced, the process completed,
leaving the "y" in the appropriate column.

We managed to undo this by clicking on all the "y" entries and reverting
them. This was not a big deal since this particular account, this
particular time, had only two transactions and the interest payment (well,
that's three transactions :) But, if this happened with dozens of
transactions, reverting each one by hand would be horrible, and likely
error prone too. Is there a proper/better way to do this?

TIA,
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] Undo a reconciliation?

[Gyle McCollam]

Yu could just add the interest payment and redo the reconciliation with the 
same date.  The items that were previously reconciled won't show up, but the 
added interest payment will.  Gnucash doesn't care how many times you reconcile 
to a date.  If you/she had noticed this before the reconciliation was 
completed, you could select postpone and redo it after entering the interest 
payment.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Simon Roberts 
Sent: Monday, January 2, 2023 1:05 PM
To: Gnucash Users 
Subject: [GNC] Undo a reconciliation?

Hi all, question from my bookkeeper.

She performed a reconciliation, but had not added an interest payment to
the account. Because of that the reconciliation was wrong. For reasons that
went unnoticed, and likely cannot be reproduced, the process completed,
leaving the "y" in the appropriate column.

We managed to undo this by clicking on all the "y" entries and reverting
them. This was not a big deal since this particular account, this
particular time, had only two transactions and the interest payment (well,
that's three transactions :) But, if this happened with dozens of
transactions, reverting each one by hand would be horrible, and likely
error prone too. Is there a proper/better way to do this?

TIA,
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.
___
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] Scary moment

[Gyle McCollam]

No Gnucash doesn't recognize that someone else had made an entry, because as I 
understand it Gnucash opens in memory.  It is not a multiuser program.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of David G. Pickett via gnucash-user 
Sent: Monday, January 2, 2023 12:09 PM
To: Gnucash Users 
Subject: Re: [GNC] Scary moment


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.
___
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] Undo a reconciliation?

[Simon Roberts]

Oh, thanks Gyle, that seems much simpler.


On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam  wrote:

> Yu could just add the interest payment and redo the reconciliation with
> the same date.  The items that were previously reconciled won't show up,
> but the added interest payment will.  Gnucash doesn't care how many times
> you reconcile to a date.  If you/she had noticed this before the
> reconciliation was completed, you could select postpone and redo it after
> entering the interest payment.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of Simon Roberts 
> *Sent:* Monday, January 2, 2023 1:05 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] Undo a reconciliation?
>
> Hi all, question from my bookkeeper.
>
> She performed a reconciliation, but had not added an interest payment to
> the account. Because of that the reconciliation was wrong. For reasons that
> went unnoticed, and likely cannot be reproduced, the process completed,
> leaving the "y" in the appropriate column.
>
> We managed to undo this by clicking on all the "y" entries and reverting
> them. This was not a big deal since this particular account, this
> particular time, had only two transactions and the interest payment (well,
> that's three transactions :) But, if this happened with dozens of
> transactions, reverting each one by hand would be horrible, and likely
> error prone too. Is there a proper/better way to do this?
>
> TIA,
> 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.
>


-- 
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] Undo a reconciliation?

[David Cousens]

Simon

I don't think there is any need to undo and redo the complete reconciliation.
Just add the correcting transaction and rerun the reconciliation. By default the
parameters are set for the next reconciliation, but you can reset the statement
date and ending balance to that for the current reconciliation and just check
the additional transactions you have added which will now appear unchecked in
the reconciliation dialogue and complete the process to reconcile them.

I
David Cousens

On Mon, 2023-01-02 at 11:05 -0700, Simon Roberts wrote:
> Hi all, question from my bookkeeper.
> 
> She performed a reconciliation, but had not added an interest payment to
> the account. Because of that the reconciliation was wrong. For reasons that
> went unnoticed, and likely cannot be reproduced, the process completed,
> leaving the "y" in the appropriate column.
> 
> We managed to undo this by clicking on all the "y" entries and reverting
> them. This was not a big deal since this particular account, this
> particular time, had only two transactions and the interest payment (well,
> that's three transactions :) But, if this happened with dozens of
> transactions, reverting each one by hand would be horrible, and likely
> error prone too. Is there a proper/better way to do this?
> 
> TIA,
> 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] Scary moment

[John Layman]

Writing to SSD is not instantaneous and I've found auto-save to be an
annoyance.  I much prefer creating backups at coherent checkpoints by
SAVEing.  I am frequently working with two books open (business and
personal) and transactions such as funds transfers affect both books.  For
backups to be coherent, I need to invoke them manually.

-Original Message-
From: gnucash-user 
On Behalf Of Simon Roberts
Sent: Friday, December 30, 2022 1:50 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Scary moment

New user (refugee from Intuit, finally) question on this topic:

Given that these days we tend to have vast disks, and they're often very
fast SSDs, I'm inclined to enable auto-save and set a relatively short
interval (perhaps as little as a minute?)

Are there issues with doing this that I've not thought of? If my file gets
to several years worth, will it get large enough that this actually takes a
non-trivial amount of time? Will it be unmanageable for other reasons?

Thanks for your wisdom,
Simon


On Fri, Dec 30, 2022 at 11:16 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 12/30/2022 1:02 PM, Derek Atkins wrote:
> > I suppose there could have been a bug..
> >
> > GnuCash is supposed to prevent you from exiting if there is unsaved
data.
>
> > However, I suppose there COULD be a way for you to shut down / close 
> > GnuCash in a way that prevents it from popping up that dialog box.
> >
> > -derek
>
> Of course there is. Simply shut down the computer over riding an 
> "there are apps still open" warnings.
>
>
> Michael D Novack
>
>
> ___
> 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.

[GNC] Trial Balance Report Error

[Murugan Muruganandam]

When i run Trial Balance Report, i am encountering the following error.  Can 
you please help what is causing this error, all other reports like balance 
sheet, income, expense are working fine.


i am attaching the trace file also, can any one help me where the issue could be


Report error

An error occurred while running the report.

  10 (apply-smob/1 #)
In c-interface.scm:
 35:4  9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  8 (catch _ _ # …)
In c-interface.scm:
39:40  7 (_)
In report-core.scm:
   752:25  6 (gnc:report-render-html #< type: "216cd0cf6931…> …)
In standard/trial-balance.scm:
   549:12  5 (trial-balance-renderer _)
In html-acct-table.scm:
545:4  4 (gnc:make-html-acct-table/env/accts _ _)
818:4  3 (gnc:html-acct-table-add-accounts! #<…> …)
   726:18  2 (traverse-accounts! _ 0 0 #)
In commodity-utilities.scm:
905:8  1 (gnc:sum-collector-commodity # …)
In unknown file:
   0 (+ 135226 190312 321500 241929 18593117 3873095 334397 0 …)

In procedure +: Wrong type: #f



Saludos Cordiales


Murugan


gnucash.trace.Q206X1.log
Description: gnucash.trace.Q206X1.log
___
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] Undo a reconciliation?

[Gyle McCollam]

Simon,
I should have mentioned that when you select reconciliation on an account the 
dialogue box has a button you can click on to "Enter Interest Payment...".  
From there you can enter your interest payment if you have forgotten to 
previously.  Also, if your financial institution allows you to export your 
transactions, you can import them into Gnucash.  You can then show matching 
transactions that you have entered during the month (checkbox at the bottom) 
and it will show any transactions that the institution has that you may have 
forgotten to enter.  You will be able to specify the expense/income account it 
should be posted to as well.  There is another checkbox to do the 
reconciliation once the import is finished if you want to do that or you can 
let the items be marks as cleared until you are ready to reconcile.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: Simon Roberts 
Sent: Monday, January 2, 2023 1:53 PM
To: Gyle McCollam 
Cc: Gnucash Users 
Subject: Re: [GNC] Undo a reconciliation?

Oh, thanks Gyle, that seems much simpler.


On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Yu could just add the interest payment and redo the reconciliation with the 
same date.  The items that were previously reconciled won't show up, but the 
added interest payment will.  Gnucash doesn't care how many times you reconcile 
to a date.  If you/she had noticed this before the reconciliation was 
completed, you could select postpone and redo it after entering the interest 
payment.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of Simon Roberts 
mailto:si...@dancingcloudservices.com>>
Sent: Monday, January 2, 2023 1:05 PM
To: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Undo a reconciliation?

Hi all, question from my bookkeeper.

She performed a reconciliation, but had not added an interest payment to
the account. Because of that the reconciliation was wrong. For reasons that
went unnoticed, and likely cannot be reproduced, the process completed,
leaving the "y" in the appropriate column.

We managed to undo this by clicking on all the "y" entries and reverting
them. This was not a big deal since this particular account, this
particular time, had only two transactions and the interest payment (well,
that's three transactions :) But, if this happened with dozens of
transactions, reverting each one by hand would be horrible, and likely
error prone too. Is there a proper/better way to do this?

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


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

[GNC] Are accountants happy with CVS exports?

[Dr. David Kirkby]

I asked my accountant about using GnuCash. He doesn’t know it, but said if
can export a CSV file that will be okay.

Previously I have used LibraOffice, with multiple tabs for different
things. Something like the following - he provided me with this as a
suggestion when I first contacted him.


1) PayPal account
2) Bank Account
3) Expenses
4) Assets
5) Stock - just a list of what I have at the end of the financial year.
6) Electricity usage

He can export that as a CSV file. It will have a list of expenses something
like

2/1/2023, widgets, £12.34
1/1/2023, things, £178.12

All values are positive, and the sum of those is the sum of the expenses.
That’s quite different from the CSV export from GnuCash, where each line
has either a positive value or negative, and the sum is zero.

Do people get any complaints from accountants about the format of the
files, or are they happy with them?

I could write my own post-processor using Linux command line tools to get
data in a format that more resembles what he had before.

Normally I get my accounts to my accountant near the end of the month they
need to be submitted, which is 6 months after the end of the financial
year. Next time I hope to get them to him *much* earlier so if he has any
problems with the exported files, I can manipulate them.

It would be nice if one could export all the expenses without the dates
being in a random order. The only way I can find to get dates in a
chronological order is to export every single account separately, so there
are no sub accounts. I thought about trying to write some code that would
allow all the expenses to be exported in one file in chronological order.
That’s not an impossible task, but would take me quite a bit of coding. If
I did it, I would just create something that’s command line driven, using
as many as the unix tools as possible to cut down the work. It might be
possible to just make a fairly complex shell script.

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] Are accountants happy with CVS exports?

[Maf. King]

I run my business accounts out of GC into LibreOffice for pretty formatting and 
so on and thence to my accountant for his magic touch for companies house and 
HMRC.

dead easy to get calc to open the HTML export from GC, or you can copy-paste 
IIRC.

HTH,
Maf.


On Monday, 2 January 2023 21:30:04 GMT Dr. David Kirkby wrote:
> I asked my accountant about using GnuCash. He doesn’t know it, but said if
> can export a CSV file that will be okay.
> 
> Previously I have used LibraOffice, with multiple tabs for different
> things. Something like the following - he provided me with this as a
> suggestion when I first contacted him.
> 
> 
> 1) PayPal account
> 2) Bank Account
> 3) Expenses
> 4) Assets
> 5) Stock - just a list of what I have at the end of the financial year.
> 6) Electricity usage
> 
> He can export that as a CSV file. It will have a list of expenses something
> like
> 
> 2/1/2023, widgets, £12.34
> 1/1/2023, things, £178.12
> 
> All values are positive, and the sum of those is the sum of the expenses.
> That’s quite different from the CSV export from GnuCash, where each line
> has either a positive value or negative, and the sum is zero.
> 
> Do people get any complaints from accountants about the format of the
> files, or are they happy with them?
> 
> I could write my own post-processor using Linux command line tools to get
> data in a format that more resembles what he had before.
> 
> Normally I get my accounts to my accountant near the end of the month they
> need to be submitted, which is 6 months after the end of the financial
> year. Next time I hope to get them to him *much* earlier so if he has any
> problems with the exported files, I can manipulate them.
> 
> It would be nice if one could export all the expenses without the dates
> being in a random order. The only way I can find to get dates in a
> chronological order is to export every single account separately, so there
> are no sub accounts. I thought about trying to write some code that would
> allow all the expenses to be exported in one file in chronological order.
> That’s not an impossible task, but would take me quite a bit of coding. If
> I did it, I would just create something that’s command line driven, using
> as many as the unix tools as possible to cut down the work. It might be
> possible to just make a fairly complex shell script.
> 
> 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.

Re: [GNC] Crash on account delete

[R Losey]

Welcome!

I switched from Quicken to Gnucash seven years ago. I didn't bother to
import from Quicken - I tried once and had problems. I figured that if I
needed past data, I could just run Quicken, and the Quicken data would just
age off. I used Quicken a lot in the first month or two, but it's been 2-3
years since I have needed to use Quicken for anything... now it's old
enough that I don't believe I will.

In all that time, I have rarely found a problem with GnuCash. It may have
crashed on me a few times over the years, but then so has other items I've
used.

In my opinion, the biggest deficit to GnuCash is the reports... The "out of
the box" reports don't seem helpful to me. I know that they are can be made
very useful through customizing, but I have always found it hard to make it
report what I wanted to report.

I don't think it's especially buggy... I'm actually pretty impressed with
it.



On Sun, Jan 1, 2023 at 6:03 PM Xe Roy  wrote:

> I am a new user using GnuCash for the first time.
> About an hour into adding transactions, I already crashed the program.
> I was trying to delete an empty account that had a subaccount.
> Then the program disappeared and I lost the last few inputs.
> Is GnuCash buggy?
> Should I switch from XML to one of the database formats?
>
>
> Sent from Outlook
> ___
> 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] Scary moment

[R Losey]

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 <
gnucash-user@gnucash.org> 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] Are accountants happy with CVS exports?

[Stephen M. Butler]

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


On 1/2/23 13:30, Dr. David Kirkby wrote:

I asked my accountant about using GnuCash. He doesn’t know it, but said if
can export a CSV file that will be okay.

Previously I have used LibraOffice, with multiple tabs for different
things. Something like the following - he provided me with this as a
suggestion when I first contacted him.


1) PayPal account
2) Bank Account
3) Expenses
4) Assets
5) Stock - just a list of what I have at the end of the financial year.
6) Electricity usage

He can export that as a CSV file. It will have a list of expenses something
like

2/1/2023, widgets, £12.34
1/1/2023, things, £178.12

All values are positive, and the sum of those is the sum of the expenses.
That’s quite different from the CSV export from GnuCash, where each line
has either a positive value or negative, and the sum is zero.

Do people get any complaints from accountants about the format of the
files, or are they happy with them?

I could write my own post-processor using Linux command line tools to get
data in a format that more resembles what he had before.

Normally I get my accounts to my accountant near the end of the month they
need to be submitted, which is 6 months after the end of the financial
year. Next time I hope to get them to him *much* earlier so if he has any
problems with the exported files, I can manipulate them.

It would be nice if one could export all the expenses without the dates
being in a random order. The only way I can find to get dates in a
chronological order is to export every single account separately, so there
are no sub accounts. I thought about trying to write some code that would
allow all the expenses to be exported in one file in chronological order.
That’s not an impossible task, but would take me quite a bit of coding. If
I did it, I would just create something that’s command line driven, using
as many as the unix tools as possible to cut down the work. It might be
possible to just make a fairly complex shell script.

Dave





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

Re: [GNC] Trial Balance Report Settings

[Adrien Monteleone]

Surprisingly, no, there is no such setting.

Many if not most other reports have it.

You can file an RFE (Request for Enhancement) at bugs.gnucash.org

In the meantime, export or copy/paste the report to a spreadsheet and 
edit them out from there.


Regards,
Adrien

On 1/2/23 9:51 AM, Benjamin Soffer wrote:

Hello and Happy New Year!

I have lots of accounts with zero balances (which I must keep for legal 
reasons).  When I run a Trial Balance report, all of those accounts are 
included in the report, making the report much longer than necessary.  Is there 
a setting that would enable me to exclude zero-balance accounts from the Trial 
Balance report?


___
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] Date format for QIF file

[Kalpesh Patel]

Tim -

 

This might be a bit late (I had to hunt down old Quicken QIF migration files
that I did back in 2020 to check), nonetheless I figure I respond in case if
there is any value.

 

If you are exporting out data in QIF format from Quicken (Windows 2017
version but this is likely to be true for any Quicken version), the format
of the date field is all over the place and it will definitely get barfed by
GNC QIF importer.

 

Bunch of *NIX shell sed commands worked like a charm to normalize them into
consistent form of MM/dd/ so that GNC would be happy (here is script
that did the dirty work - modified to include for year 2021 and 2022):

 

 

 

#!/bin/bash

# first parameter to the script is the file name that needs to be normalized
and will be modified in place. 

 

iam=${1}

 

if [ -z ${iam} ] ; then

 echo "Please pass in the file name as the first parameter."

  exit 255

fi

 

if [ -e ${iam} ] ; then

 echo "${iam} does not exist. Please provide a file that already exist."

  exit 254

fi

 

cat $(iam} > ${iam}.bak

 

 

#-##cat $iam | while read a ; do

#-##

#-##case $a in

#-##*\'[0-2][0-9]*)

#-##echo $a |sed -e "s+'+/20+g" ;;

#-##*\'[3-9][0-9]*)

#-##echo $a |sed -e "s+'+/19+g" ;;

#-##*\'\ [0-9]*)

#-##echo $a |sed -e "s+' +/200+g" ;;

#-##*/[9][0-9]*)

#-##echo $a |sed -e "s+/9+/199+g" ;;

#-##*/[8][0-9]*)

#-##echo $a |sed -e "s+/8+/198+g" ;;

#-##*/[7][0-9]*)

#-##echo $a |sed -e "s+/7+/197+g" ;;

#-##*)

#-##echo $a ;;

#-##esac

#-##

#-##done >> ${iam}_mod

 

set -x

 

sed -i.tmp -e "s+' 0+/2000+g" ${iam}

sed -i.tmp -e "s+' 1+/2001+g" ${iam}

sed -i.tmp -e "s+' 2+/2002+g" ${iam}

sed -i.tmp -e "s+' 3+/2003+g" ${iam}

sed -i.tmp -e "s+' 4+/2004+g" ${iam}

sed -i.tmp -e "s+' 5+/2005+g" ${iam}

sed -i.tmp -e "s+' 6+/2006+g" ${iam}

sed -i.tmp -e "s+' 7+/2007+g" ${iam}

sed -i.tmp -e "s+' 8+/2008+g" ${iam}

sed -i.tmp -e "s+' 9+/2009+g" ${iam}

sed -i.tmp -e "s+'10+/2010+g" ${iam}

sed -i.tmp -e "s+'11+/2011+g" ${iam}

sed -i.tmp -e "s+'12+/2012+g" ${iam}

sed -i.tmp -e "s+'13+/2013+g" ${iam}

sed -i.tmp -e "s+'14+/2014+g" ${iam}

sed -i.tmp -e "s+'15+/2015+g" ${iam}

sed -i.tmp -e "s+'16+/2016+g" ${iam}

sed -i.tmp -e "s+'17+/2017+g" ${iam}

sed -i.tmp -e "s+'18+/2018+g" ${iam}

sed -i.tmp -e "s+'19+/2019+g" ${iam}

sed -i.tmp -e "s+'20+/2020+g" ${iam}

sed -i.tmp -e "s+'21+/2021+g" ${iam}

sed -i.tmp -e "s+'22+/2022+g" ${iam}

 

sed -i.tmp -e "s+/81+/1981+g" ${iam}

sed -i.tmp -e "s+/82+/1982+g" ${iam}

sed -i.tmp -e "s+/83+/1983+g" ${iam}

sed -i.tmp -e "s+/84+/1984+g" ${iam}

sed -i.tmp -e "s+/85+/1985+g" ${iam}

sed -i.tmp -e "s+/86+/1986+g" ${iam}

sed -i.tmp -e "s+/87+/1987+g" ${iam}

sed -i.tmp -e "s+/88+/1988+g" ${iam}

sed -i.tmp -e "s+/89+/1989+g" ${iam}

sed -i.tmp -e "s+/90+/1990+g" ${iam}

sed -i.tmp -e "s+/91+/1991+g" ${iam}

sed -i.tmp -e "s+/92+/1992+g" ${iam}

sed -i.tmp -e "s+/93+/1993+g" ${iam}

sed -i.tmp -e "s+/94+/1994+g" ${iam}

sed -i.tmp -e "s+/95+/1995+g" ${iam}

sed -i.tmp -e "s+/96+/1996+g" ${iam}

sed -i.tmp -e "s+/97+/1997+g" ${iam}

sed -i.tmp -e "s+/98+/1998+g" ${iam}

sed -i.tmp -e "s+/99+/1999+g" ${iam}.

 

# End of Script

 

 

 

For what it is worth, there is an actual documentation that Intuit
(predecessor owner and original publisher of the QIF file format) published
it in 1997 at

http://www.intuit.com/quicken/technical-support/quicken/old-faqs/dosfaqs/600
06.html which no longer exists but cached copy by Google can be found at
https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm#:~:text=A%3A%20The%2
0Quicken%20interchange%20format,that%20supports%20the%20QIF%20format. In the
documentation you will notice that there is no definition of what the format
of the date should be so depending on the transaction date, Intuit decided
to implement it two different ways for date field: 

 

-   2000 and after years, the format is "D3/ 1' 8" (March one two
thousand eight - they were space filled to make it two digits for day and
year but not for month and a forward tick was used to mark that it was year
2000 and afterwards)  

-   before year 2000, the format is "D3/25/97" (March twenty five
nineteen nighty seven - the month day and year were all simply broken up by
a slash).

 

The rollover of the format happens for example from D12/23/99 to D3/24' 0
when y2k hit. GNC did not mind spaces in any field and it simply ignored
them so the script above made minimal change to be able to import the
modified QIF file into GNC.

 

When prompted by GNC during QIF import, you can tell it that it is in M/D/Y
format and it will go through fine.

 

 

 

 

 

 

--

Message: 3

Date: Thu, 29 Dec 2022 12:33:50 -0600

From: m...@tgr66.me

To: "gnucash-user@gnucash.org" 

Subject: [GNC] Date format for QIF file

Message

Re: [GNC] Date format for QIF file

[Kalpesh Patel]

I over looked format described by Wiki at
https://en.wikipedia.org/wiki/Quicken_Interchange_Format and it denoted that
in date field leading zeroes on month and day can be skipped and year can be
either 4 digits or 2 digits or '6 (=2006).

 

From: Kalpesh Patel  
Sent: Monday, January 02, 2023 5:18 PM
To: 'm...@tgr66.me' 
Cc: 'gnucash-user@gnucash.org' 
Subject: RE: Date format for QIF file

 

Tim -

 

This might be a bit late (I had to hunt down old Quicken QIF migration files
that I did back in 2020 to check), nonetheless I figure I respond in case if
there is any value.

 

If you are exporting out data in QIF format from Quicken (Windows 2017
version but this is likely to be true for any Quicken version), the format
of the date field is all over the place and it will definitely get barfed by
GNC QIF importer.

 

Bunch of *NIX shell sed commands worked like a charm to normalize them into
consistent form of MM/dd/ so that GNC would be happy (here is script
that did the dirty work - modified to include for year 2021 and 2022):

 

 

 

#!/bin/bash

# first parameter to the script is the file name that needs to be normalized
and will be modified in place. 

 

iam=${1}

 

if [ -z ${iam} ] ; then

 echo "Please pass in the file name as the first parameter."

  exit 255

fi

 

if [ -e ${iam} ] ; then

 echo "${iam} does not exist. Please provide a file that already exist."

  exit 254

fi

 

cat $(iam} > ${iam}.bak

 

 

#-##cat $iam | while read a ; do

#-##

#-##case $a in

#-##*\'[0-2][0-9]*)

#-##echo $a |sed -e "s+'+/20+g" ;;

#-##*\'[3-9][0-9]*)

#-##echo $a |sed -e "s+'+/19+g" ;;

#-##*\'\ [0-9]*)

#-##echo $a |sed -e "s+' +/200+g" ;;

#-##*/[9][0-9]*)

#-##echo $a |sed -e "s+/9+/199+g" ;;

#-##*/[8][0-9]*)

#-##echo $a |sed -e "s+/8+/198+g" ;;

#-##*/[7][0-9]*)

#-##echo $a |sed -e "s+/7+/197+g" ;;

#-##*)

#-##echo $a ;;

#-##esac

#-##

#-##done >> ${iam}_mod

 

set -x

 

sed -i.tmp -e "s+' 0+/2000+g" ${iam}

sed -i.tmp -e "s+' 1+/2001+g" ${iam}

sed -i.tmp -e "s+' 2+/2002+g" ${iam}

sed -i.tmp -e "s+' 3+/2003+g" ${iam}

sed -i.tmp -e "s+' 4+/2004+g" ${iam}

sed -i.tmp -e "s+' 5+/2005+g" ${iam}

sed -i.tmp -e "s+' 6+/2006+g" ${iam}

sed -i.tmp -e "s+' 7+/2007+g" ${iam}

sed -i.tmp -e "s+' 8+/2008+g" ${iam}

sed -i.tmp -e "s+' 9+/2009+g" ${iam}

sed -i.tmp -e "s+'10+/2010+g" ${iam}

sed -i.tmp -e "s+'11+/2011+g" ${iam}

sed -i.tmp -e "s+'12+/2012+g" ${iam}

sed -i.tmp -e "s+'13+/2013+g" ${iam}

sed -i.tmp -e "s+'14+/2014+g" ${iam}

sed -i.tmp -e "s+'15+/2015+g" ${iam}

sed -i.tmp -e "s+'16+/2016+g" ${iam}

sed -i.tmp -e "s+'17+/2017+g" ${iam}

sed -i.tmp -e "s+'18+/2018+g" ${iam}

sed -i.tmp -e "s+'19+/2019+g" ${iam}

sed -i.tmp -e "s+'20+/2020+g" ${iam}

sed -i.tmp -e "s+'21+/2021+g" ${iam}

sed -i.tmp -e "s+'22+/2022+g" ${iam}

 

sed -i.tmp -e "s+/81+/1981+g" ${iam}

sed -i.tmp -e "s+/82+/1982+g" ${iam}

sed -i.tmp -e "s+/83+/1983+g" ${iam}

sed -i.tmp -e "s+/84+/1984+g" ${iam}

sed -i.tmp -e "s+/85+/1985+g" ${iam}

sed -i.tmp -e "s+/86+/1986+g" ${iam}

sed -i.tmp -e "s+/87+/1987+g" ${iam}

sed -i.tmp -e "s+/88+/1988+g" ${iam}

sed -i.tmp -e "s+/89+/1989+g" ${iam}

sed -i.tmp -e "s+/90+/1990+g" ${iam}

sed -i.tmp -e "s+/91+/1991+g" ${iam}

sed -i.tmp -e "s+/92+/1992+g" ${iam}

sed -i.tmp -e "s+/93+/1993+g" ${iam}

sed -i.tmp -e "s+/94+/1994+g" ${iam}

sed -i.tmp -e "s+/95+/1995+g" ${iam}

sed -i.tmp -e "s+/96+/1996+g" ${iam}

sed -i.tmp -e "s+/97+/1997+g" ${iam}

sed -i.tmp -e "s+/98+/1998+g" ${iam}

sed -i.tmp -e "s+/99+/1999+g" ${iam}.

 

# End of Script

 

 

 

For what it is worth, there is an actual documentation that Intuit
(predecessor owner and original publisher of the QIF file format) published
it in 1997 at

http://www.intuit.com/quicken/technical-support/quicken/old-faqs/dosfaqs/600
06.html which no longer exists but cached copy by Google can be found at
https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm#:~:text=A%3A%20The%2
0Quicken%20interchange%20format,that%20supports%20the%20QIF%20format. In the
documentation you will notice that there is no definition of what the format
of the date should be so depending on the transaction date, Intuit decided
to implement it two different ways for date field: 

 

-   2000 and after years, the format is "D3/ 1' 8" (March one two
thousand eight - they were space filled to make it two digits for day and
year but not for month and a forward tick was used to mark that it was year
2000 and afterwards)  

-   before year 2000, the format is "D3/25/97" (March twenty five
nineteen nighty seven - the month day and year were all simply broken up by
a slash).

 

The rollover of the format happens for example from D12/23/99 to D3/24' 0
when y2k hit. GNC did not mind spaces in any field and it simply ignored
them so the script 

Re: [GNC] Scary moment

[Michael or Penny Novack]

On 1/2/2023 10:40 AM, John Layman wrote:

Writing to SSD is not instantaneous and I've found auto-save to be an
annoyance.  I much prefer creating backups at coherent checkpoints by
SAVEing.


I also (strongly) prefer doing periodic explicit saves and always reject 
"auto-save". The only exception might be if the ":auto-save" window 
opened up when I was NOT in the middle of entering a transaction, etc. 
That way I am sure about the state of the books that was just saved.



Michael D Novack


___
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] Scary moment

[Michael or Penny Novack]

On 1/2/2023 1:43 PM, Gyle McCollam wrote:

No Gnucash doesn't recognize that someone else had made an entry, because as I 
understand it Gnucash opens in memory.  It is not a multiuser program.

It is not a SIMULTANEOUS multiple user program. It is OK for multiple 
sequential users provided nobody overrides the "could not obtain lock" 
message.


Michael D Novack


___
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] Undo a reconciliation?

[Simon Roberts]

Thanks again Gyle and David. This is making good sense now, much
appreciated!

Cheers,
Simon


On Mon, Jan 2, 2023 at 1:59 PM Gyle McCollam  wrote:

> Simon,
> I should have mentioned that when you select reconciliation on an account
> the dialogue box has a button you can click on to "Enter Interest
> Payment...".  From there you can enter your interest payment if you have
> forgotten to previously.  Also, if your financial institution allows you to
> export your transactions, you can import them into Gnucash.  You can then
> show matching transactions that you have entered during the month (checkbox
> at the bottom) and it will show any transactions that the institution has
> that you may have forgotten to enter.  You will be able to specify the
> expense/income account it should be posted to as well.  There is another
> checkbox to do the reconciliation once the import is finished if you want
> to do that or you can let the items be marks as cleared until you are ready
> to reconcile.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* Simon Roberts 
> *Sent:* Monday, January 2, 2023 1:53 PM
> *To:* Gyle McCollam 
> *Cc:* Gnucash Users 
> *Subject:* Re: [GNC] Undo a reconciliation?
>
> Oh, thanks Gyle, that seems much simpler.
>
>
> On Mon, Jan 2, 2023 at 11:40 AM Gyle McCollam  wrote:
>
> Yu could just add the interest payment and redo the reconciliation with
> the same date.  The items that were previously reconciled won't show up,
> but the added interest payment will.  Gnucash doesn't care how many times
> you reconcile to a date.  If you/she had noticed this before the
> reconciliation was completed, you could select postpone and redo it after
> entering the interest payment.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of Simon Roberts 
> *Sent:* Monday, January 2, 2023 1:05 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] Undo a reconciliation?
>
> Hi all, question from my bookkeeper.
>
> She performed a reconciliation, but had not added an interest payment to
> the account. Because of that the reconciliation was wrong. For reasons that
> went unnoticed, and likely cannot be reproduced, the process completed,
> leaving the "y" in the appropriate column.
>
> We managed to undo this by clicking on all the "y" entries and reverting
> them. This was not a big deal since this particular account, this
> particular time, had only two transactions and the interest payment (well,
> that's three transactions :) But, if this happened with dozens of
> transactions, reverting each one by hand would be horrible, and likely
> error prone too. Is there a proper/better way to do this?
>
> TIA,
> 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.
>
>
>
> --
> Simon Roberts
> (303) 249 3613
>
>

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

[GNC] Invoice emailing?

[Simon Roberts]

We're getting to the point of preparing and sending invoices, and so far
things are seeming generally pretty clear, but I have one quick question.

Is it possible to integrate directly with a desktop email client for
sending invoices? It's not a big problem to copy / paste the HTML image
from the print preview, but if there's something that prepares the
recipients and subject line and sets it up in a POP, SMTP, or IMAP client
program directly that would rock.

I noted that when I set up the customer, GC allows me to provide an email
address, but I've not found anything in the documentation regarding sending
emails. As usual, of course, perhaps I don't have the right search term. Is
there such a thing?

Thanks in advance,
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] Date format for QIF file

[ml]

Thanks Kalpesh—

I’m on a Mac and Quicken doesn’t have a QIF export, only CSV. 

I’m writing a NodeJS app/lib to convert csv exports to QIF. The dates in the 
csv are consistently M/D/. 

I can export non investment accounts to QMTF which is a QIF but certain fields 
(like tags) aren’t included so I’ll be working that one too.

This migration might take most of this year to accomplish :-)

> On Jan 2, 2023, at 16:51, Kalpesh Patel  wrote:
> 
> I over looked format described by Wiki at 
> https://en.wikipedia.org/wiki/Quicken_Interchange_Format 
>  and it denoted 
> that in date field leading zeroes on month and day can be skipped and year 
> can be either 4 digits or 2 digits or '6 (=2006).
>  
> From: Kalpesh Patel  
> Sent: Monday, January 02, 2023 5:18 PM
> To: 'm...@tgr66.me' 
> Cc: 'gnucash-user@gnucash.org' 
> Subject: RE: Date format for QIF file
>  
> Tim –
>  
> This might be a bit late (I had to hunt down old Quicken QIF migration files 
> that I did back in 2020 to check), nonetheless I figure I respond in case if 
> there is any value.
>  
> If you are exporting out data in QIF format from Quicken (Windows 2017 
> version but this is likely to be true for any Quicken version), the format of 
> the date field is all over the place and it will definitely get barfed by GNC 
> QIF importer.
>  
> Bunch of *NIX shell sed commands worked like a charm to normalize them into 
> consistent form of MM/dd/ so that GNC would be happy (here is script that 
> did the dirty work – modified to include for year 2021 and 2022):
>  
>  
>  
> #!/bin/bash
> # first parameter to the script is the file name that needs to be normalized 
> and will be modified in place. 
>  
> iam=${1}
>  
> if [ -z ${iam} ] ; then
>  echo “Please pass in the file name as the first parameter.”
>   exit 255
> fi
>  
> if [ -e ${iam} ] ; then
>  echo “${iam} does not exist. Please provide a file that already exist.”
>   exit 254
> fi
>  
> cat $(iam} > ${iam}.bak
>  
>  
> #-##cat $iam | while read a ; do
> #-##
> #-##case $a in
> #-##*\'[0-2][0-9]*)
> #-##echo $a |sed -e "s+'+/20+g" ;;
> #-##*\'[3-9][0-9]*)
> #-##echo $a |sed -e "s+'+/19+g" ;;
> #-##*\'\ [0-9]*)
> #-##echo $a |sed -e "s+' +/200+g" ;;
> #-##*/[9][0-9]*)
> #-##echo $a |sed -e "s+/9+/199+g" ;;
> #-##*/[8][0-9]*)
> #-##echo $a |sed -e "s+/8+/198+g" ;;
> #-##*/[7][0-9]*)
> #-##echo $a |sed -e "s+/7+/197+g" ;;
> #-##*)
> #-##echo $a ;;
> #-##esac
> #-##
> #-##done >> ${iam}_mod
>  
> set -x
>  
> sed -i.tmp -e "s+' 0+/2000+g" ${iam}
> sed -i.tmp -e "s+' 1+/2001+g" ${iam}
> sed -i.tmp -e "s+' 2+/2002+g" ${iam}
> sed -i.tmp -e "s+' 3+/2003+g" ${iam}
> sed -i.tmp -e "s+' 4+/2004+g" ${iam}
> sed -i.tmp -e "s+' 5+/2005+g" ${iam}
> sed -i.tmp -e "s+' 6+/2006+g" ${iam}
> sed -i.tmp -e "s+' 7+/2007+g" ${iam}
> sed -i.tmp -e "s+' 8+/2008+g" ${iam}
> sed -i.tmp -e "s+' 9+/2009+g" ${iam}
> sed -i.tmp -e "s+'10+/2010+g" ${iam}
> sed -i.tmp -e "s+'11+/2011+g" ${iam}
> sed -i.tmp -e "s+'12+/2012+g" ${iam}
> sed -i.tmp -e "s+'13+/2013+g" ${iam}
> sed -i.tmp -e "s+'14+/2014+g" ${iam}
> sed -i.tmp -e "s+'15+/2015+g" ${iam}
> sed -i.tmp -e "s+'16+/2016+g" ${iam}
> sed -i.tmp -e "s+'17+/2017+g" ${iam}
> sed -i.tmp -e "s+'18+/2018+g" ${iam}
> sed -i.tmp -e "s+'19+/2019+g" ${iam}
> sed -i.tmp -e "s+'20+/2020+g" ${iam}
> sed -i.tmp -e "s+'21+/2021+g" ${iam}
> sed -i.tmp -e "s+'22+/2022+g" ${iam}
>  
> sed -i.tmp -e "s+/81+/1981+g" ${iam}
> sed -i.tmp -e "s+/82+/1982+g" ${iam}
> sed -i.tmp -e "s+/83+/1983+g" ${iam}
> sed -i.tmp -e "s+/84+/1984+g" ${iam}
> sed -i.tmp -e "s+/85+/1985+g" ${iam}
> sed -i.tmp -e "s+/86+/1986+g" ${iam}
> sed -i.tmp -e "s+/87+/1987+g" ${iam}
> sed -i.tmp -e "s+/88+/1988+g" ${iam}
> sed -i.tmp -e "s+/89+/1989+g" ${iam}
> sed -i.tmp -e "s+/90+/1990+g" ${iam}
> sed -i.tmp -e "s+/91+/1991+g" ${iam}
> sed -i.tmp -e "s+/92+/1992+g" ${iam}
> sed -i.tmp -e "s+/93+/1993+g" ${iam}
> sed -i.tmp -e "s+/94+/1994+g" ${iam}
> sed -i.tmp -e "s+/95+/1995+g" ${iam}
> sed -i.tmp -e "s+/96+/1996+g" ${iam}
> sed -i.tmp -e "s+/97+/1997+g" ${iam}
> sed -i.tmp -e "s+/98+/1998+g" ${iam}
> sed -i.tmp -e "s+/99+/1999+g" ${iam}.
>  
> # End of Script
>  
>  
>  
> For what it is worth, there is an actual documentation that Intuit 
> (predecessor owner and original publisher of the QIF file format) published 
> it in 1997 at 
> http://www.intuit.com/quicken/technical-support/quicken/old-faqs/dosfaqs/60006.html
>  
> 
>  which no longer exists but cached copy by Google can be found at 
> https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm#:~:text=A%3A%20The%20Quicken%20interchange%20format,that%20supports%20the%20QIF%20format
>  
> 

Re: [GNC] Invoice emailing?

[Adrien Monteleone]

Not that I'm aware of.

You could export or print to file for each invoice, then attach the 
resulting document.


This is entirely a manual operation though.

You may want to investigate gnucash-cli, but I don't know if the 
business features are exposed there.


A third option may be to script your way through it, reading the data 
file directly outside of GnuCash.


Regards,
Adrien

On 1/2/23 5:54 PM, Simon Roberts wrote:

We're getting to the point of preparing and sending invoices, and so far
things are seeming generally pretty clear, but I have one quick question.

Is it possible to integrate directly with a desktop email client for
sending invoices? It's not a big problem to copy / paste the HTML image
from the print preview, but if there's something that prepares the
recipients and subject line and sets it up in a POP, SMTP, or IMAP client
program directly that would rock.

I noted that when I set up the customer, GC allows me to provide an email
address, but I've not found anything in the documentation regarding sending
emails. As usual, of course, perhaps I don't have the right search term. Is
there such a thing?


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

[Simon Roberts]

Ah well, that's a bit sad, but not the end of the world (my business
probably sends less than six invoices per month, often only one or two).

The fastest manual route certainly seems to be do use the print dialog, and
then copy/paste from the resulting screen (that gets you an HTML paste that
easily goes into most email senders). I toyed with print to file or export,
but it still seems easier to just copy/paste.

In a way, it's having to fill out the recipient and subject line that I'm
most sad about. Can't help feeling that if I knew the code base (well
there's a year of work 😂) I could probably code that up. Fingers crossed
perhaps someone else will choose to. Still, I'm not remotely tempted to go
back to Intuit over this!!!

Thanks for the input Adrien!
Cheers,
Simon


On Mon, Jan 2, 2023 at 4:59 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Not that I'm aware of.
>
> You could export or print to file for each invoice, then attach the
> resulting document.
>
> This is entirely a manual operation though.
>
> You may want to investigate gnucash-cli, but I don't know if the
> business features are exposed there.
>
> A third option may be to script your way through it, reading the data
> file directly outside of GnuCash.
>
> Regards,
> Adrien
>
> On 1/2/23 5:54 PM, Simon Roberts wrote:
> > We're getting to the point of preparing and sending invoices, and so far
> > things are seeming generally pretty clear, but I have one quick question.
> >
> > Is it possible to integrate directly with a desktop email client for
> > sending invoices? It's not a big problem to copy / paste the HTML image
> > from the print preview, but if there's something that prepares the
> > recipients and subject line and sets it up in a POP, SMTP, or IMAP client
> > program directly that would rock.
> >
> > I noted that when I set up the customer, GC allows me to provide an email
> > address, but I've not found anything in the documentation regarding
> sending
> > emails. As usual, of course, perhaps I don't have the right search term.
> Is
> > there such a thing?
>
> ___
> 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.

[GNC] Fields present in invoices?

[Simon Roberts]

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

-- 
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] Invoice emailing?

[Dr. David Kirkby]

On Tue, 3 Jan 2023 at 00:23, Simon Roberts 
wrote:

> Ah well, that's a bit sad, but not the end of the world (my business
> probably sends less than six invoices per month, often only one or two).
>
> The fastest manual route certainly seems to be do use the print dialog, and
> then copy/paste from the resulting screen (that gets you an HTML paste that
> easily goes into most email senders). I toyed with print to file or export,
> but it still seems easier to just copy/paste.
>

Most companies I am aware of want a PDF invoice - not HTML in an email.
Whilst you may consider copy/paste faster, I think most customer would
prefer a PDF

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.

Re: [GNC] Invoice emailing?

[Simon Roberts]

Quot homines tot sententiae for sure; my clients seem quite happy with HTML.

That said, I don't *object* to pdf, but I would like to find a faster way
to send whatever I'm going to send. It's connecting it to email that I want
to simplify. If I can send pdf directly in email, with subject and
recipient address automatically configured, then great, I'll send pdf. If I
can't, I'll copy/paste the HTML from the print preview.

Can I directly email PDF, or was Adrien correct?


On Mon, Jan 2, 2023 at 5:43 PM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Tue, 3 Jan 2023 at 00:23, Simon Roberts 
> wrote:
>
>> Ah well, that's a bit sad, but not the end of the world (my business
>> probably sends less than six invoices per month, often only one or two).
>>
>> The fastest manual route certainly seems to be do use the print dialog,
>> and
>> then copy/paste from the resulting screen (that gets you an HTML paste
>> that
>> easily goes into most email senders). I toyed with print to file or
>> export,
>> but it still seems easier to just copy/paste.
>>
>
> Most companies I am aware of want a PDF invoice - not HTML in an email.
> Whilst you may consider copy/paste faster, I think most customer would
> prefer a PDF
>
> Dave
>


-- 
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] Invoice emailing?

[Adrien Monteleone]

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.

Re: [GNC] Fields present in invoices?

[Adrien Monteleone]

The Options allow you to turn some things on or off explicitly, but they 
are not all-inclusive.


You might want to investigate customizing a stylesheet, but that does 
muck with the workflow to get an invoice report in most cases, resulting 
in lots of clicks.


Using a CSS rule like 'display: none;' on certain fields/elements might 
work.


Otherwise, you'd need to write a custom invoice report, or do 
manipulation outside of GnuCash.


Regards,
Adrien

On 1/2/23 6:32 PM, 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.


___
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] Missing "Buy" action after import of QIF file

[ml]

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.

Re: [GNC] Fields present in invoices?

[Simon Roberts]

Ah yes! I just found Edit->Report Options, which at first glance looks like
it'll help a lot.

I also found a bunch of ...hmm, looks like Lisp (which I used to know) but
I think it's actually scheme (which I don't know) files that appear to be
programmatic definitions of these.

I shall tinker and see what happens. Thanks for the pointer Adrien.

On Mon, Jan 2, 2023 at 6:37 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The Options allow you to turn some things on or off explicitly, but they
> are not all-inclusive.
>
> You might want to investigate customizing a stylesheet, but that does
> muck with the workflow to get an invoice report in most cases, resulting
> in lots of clicks.
>
> Using a CSS rule like 'display: none;' on certain fields/elements might
> work.
>
> Otherwise, you'd need to write a custom invoice report, or do
> manipulation outside of GnuCash.
>
> Regards,
> Adrien
>
> On 1/2/23 6:32 PM, 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.
>
> ___
> 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] Fields present in invoices?

[Simon Roberts]

Oh, but to make it extra interesting, the menu entry for "report options"
is only offered when already looking at a "printable invoice"... That
seems... like a bug. given that the Edit -> Style Sheets menu entry is
visible in other tabs, perhaps?

Anyway, I believe this is likely adequate to my concerns, many thanks again
Adrien.

On Mon, Jan 2, 2023 at 7:05 PM Simon Roberts 
wrote:

> Ah yes! I just found Edit->Report Options, which at first glance looks
> like it'll help a lot.
>
> I also found a bunch of ...hmm, looks like Lisp (which I used to know) but
> I think it's actually scheme (which I don't know) files that appear to be
> programmatic definitions of these.
>
> I shall tinker and see what happens. Thanks for the pointer Adrien.
>
> On Mon, Jan 2, 2023 at 6:37 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> The Options allow you to turn some things on or off explicitly, but they
>> are not all-inclusive.
>>
>> You might want to investigate customizing a stylesheet, but that does
>> muck with the workflow to get an invoice report in most cases, resulting
>> in lots of clicks.
>>
>> Using a CSS rule like 'display: none;' on certain fields/elements might
>> work.
>>
>> Otherwise, you'd need to write a custom invoice report, or do
>> manipulation outside of GnuCash.
>>
>> Regards,
>> Adrien
>>
>> On 1/2/23 6:32 PM, 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.
>>
>> ___
>> 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
>
>

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

[Adrien Monteleone]

Scheme.

See the Wiki development section for links to details of the reporting 
system. (which isn't much as it is not well documented, for programmers, 
so far)


Regards,
Adrien

On 1/2/23 8:05 PM, Simon Roberts wrote:

Ah yes! I just found Edit->Report Options, which at first glance looks like
it'll help a lot.

I also found a bunch of ...hmm, looks like Lisp (which I used to know) but
I think it's actually scheme (which I don't know) files that appear to be
programmatic definitions of these.

I shall tinker and see what happens. Thanks for the pointer 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.

Re: [GNC] Fields present in invoices?

[Adrien Monteleone]

Not a bug. Most likely a design decision. Not sure how you'd figure out 
what options to show if you don't know yet which report you want options 
for...


Stylesheets are not peculiar to a certain report. You can edit them 
independently, then assign them to reports for use.


Unfortunately, I don't think any report has the ability to re-assign a 
default stylesheet other than the 'default'. This makes customizations a 
cumbersome workflow. Most places where you select an invoice for 
viewing/printing will 'default' and then you'd have to assign the 
stylesheet each time.


Regards,
Adrien

On 1/2/23 8:13 PM, Simon Roberts wrote:

Oh, but to make it extra interesting, the menu entry for "report options"
is only offered when already looking at a "printable invoice"... That
seems... like a bug. given that the Edit -> Style Sheets menu entry is
visible in other tabs, perhaps?


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

[Cam Ellison]

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.

Re: [GNC] Invoice emailing?

[Simon Roberts]

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.

Re: [GNC] Fields present in invoices?

[Adrien Monteleone]

Simon,

I'm not sure why this reply from you was not appearing on the list. The 
server must have had a hiccup.


I'm quoting and replying inline below.

Regards,
Adrien

On 1/2/23 9:21 PM, Simon Roberts wrote:

Oh... so the fields to show are specific to the invoice? Oh, that's a pity, and 
we were doing so well!


I'm not sure what you mean, but the invoice fields are generic to all 
invoices.


The *options* are a feature of Reports. Different reports have different 
options. There is no way for GnuCash to know what options to show you to 
customize until a report is run. Otherwise, there is no sane context for 
those options. That's why the button on the toolbar and the menu entry 
are not visible until you have a report on screen.



Is there a mechanism for configuring the default selections? Having to do the 
same selections (well, de-selections) every time will have my bookkeeper 
whining.
Yes. Read up in the Help &/or Tutorial documents about Saved Report 
Configurations. However, as I noted earlier, while this lets you save a 
set of options (including which stylesheet to use) you have to run it 
first, then select an invoice, then apply that change to see the final 
invoice as desired. It is quite cumbersome especially if you're dealing 
with many invoices.


There are other places in the app, such as the Find Invoice dialog, the 
Customer Report, and the AR register, where you can click an invoice 
number to generate an Invoice Report with less effort. But there is no 
way to apply a saved configuration automatically as a default. In fact, 
there's no way to apply a saved configuration to an already open Invoice 
Report. (or any report) You have to 'run' the saved configuration first. 
That works okay for things like a Balance Sheet or Income Statement. It 
isn't fun for invoices.


Think of Saved Configurations as their own customized reports. But you 
can't specify one to always be 'your default' for that type of report. 
The workflow/UX in that regard could use a major revamp.



I guess if all else fails, I try to learn scheme. It looks a helluvalot like 
lisp, and I had a handle on that 35 years or so ago, so that's not completely 
inconceivable.


Scheme is indeed, a dialog of Lisp.

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

That's "dialect" of Lisp. (please excuse my fingers not syncing with my 
brain)


Regards,
Adrien

On 1/3/23 12:15 AM, Adrien Monteleone wrote:


Scheme is indeed, a dialog of Lisp.


___
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] Scheduled transactions

[Fred Tydeman]

I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the term:
"scheduled transaction" and got no hits.

My question is:  Is it possible to select a scheduled transaction from the
future and have it be done now?  I was hoping I could click on the calendar
entry and get a popup offering choices:  Skip, Run now, Edit, ...
___
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] Scheduled transactions

[Adrien Monteleone]

Is this just a one-off? I'd just enter the transaction. If it is 
complicated and you already have an instance in a register, duplicate it.


If it hasn't ever occurred, and you don't want to manually enter it, 
edit to run today, click Actions > Since Last Run to fire it off, then 
edit to revert to your future date.


But no, there is no way I can see to otherwise execute it.

Regards,
Adrien

On 1/3/23 12:36 AM, Fred Tydeman wrote:

I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the term:
"scheduled transaction" and got no hits.

My question is:  Is it possible to select a scheduled transaction from the
future and have it be done now?  I was hoping I could click on the calendar
entry and get a popup offering choices:  Skip, Run now, Edit, ...


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