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
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
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
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
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
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
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
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
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
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
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
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)
My CPA accepts the Balance Sheet and Profit/Loss Statement along with a
multi-page Q 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
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",
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
44 matches
Mail list logo