Re: [GNC] File format question

2024-01-31 Thread Simon Roberts
On Wed, Jan 31, 2024 at 1:12 PM Geert Janssens 
wrote:
[...]

> There's not much documentation other than the comments in the source
> files. The 'single characters' you refer to are briefly explained here:
>
>
> https://github.com/Gnucash/gnucash/blob/b7e68144154c3677293148a40d66bea36d492a96/libgnucash/engine/TransLog.h#L58
>
> Though I'm not sure the behaviour is exactly like described there. I don't
> think a D(elete) line is still preceded by a B(egin) line. But the meaning
> of the characters is still unchanged.
>
> B for "begin edit"
>
> C for "commit changes"
>
> R for "rollback changes"
>
> D for "delete"
>

Perfect!! I'm disappointed in myself that I didn't work that out. In
retrospect it seems like I should have. But thank you for this, I'm pretty
sure this is all I really need for my situation.

Note these log files are call transaction logs. And that's pretty accurate.
> They only log changes to transactions (and their splits). Changes to
> accounts or invoices or anything else is not recorded in these logs.
>

Also helpful too. I didn't know that limitation. I don't think it'll be
important to my situation, but it's certainly helpful to know that this is
the case, just in case my CPAs indicate anything of that sort has happened.

Much appreciate the help, thank you Geert,
Cheers,
Simon
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] File format question

2024-01-31 Thread Simon Roberts
Ah, excellent, thank you. I can continue with the compressed format for the
main file and simply use zcat when needed :)

The wiki description of the XML format doesn't seem to offer much, but I'm
not worried about that, I recall from previous forays in that file that
it's pretty self evident what's going on (at least for the purpose I have
in mind--i.e. putting names to UUIDs).

I guess the only part unresolved is whether there is anything outlining the
log format. the single character code at column 1 seems like it might be
important, but I'm at a loss for a guess as to what it's describing. It
*feels* like it might explain what the numerous seemingly duplicated, and
often zero-value, entries are about. But that's a wild stab in the dark :)

Many thanks Glenn for very helpful pointers!

Cheers,
Simon


On Wed, Jan 31, 2024 at 11:39 AM Glenn Fowler  wrote:

> Hi,
>
> Yes you have the option to compress the XML or not.
>
> Here is the info you are looking for:
>
> https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-files1.html
>
> https://wiki.gnucash.org/wiki/GnuCash_XML_format
> --
> *From:* gnucash-user  outlook@gnucash.org> on behalf of Simon Roberts <
> si...@dancingcloudservices.com>
> *Sent:* Wednesday, January 31, 2024 1:11 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] File format question
>
> Hi all, perhaps I should be asking this on the developer's list, but I
> figured that misdirecting here would be less disruptive / annoying than
> miscrirecting there. Please forgive me if this is the wrong place.
>
> I'm investigating using logfiles as a means to identify changes that will
> be made by my accountants for my year end. This leads me to two questions
>
> First, is there documentation I can look at on this topic"? I didn't find
> anything in the user guide, but am not particularly surprised at that.
>
> Second, I notice that the main data file is binary. I thought it was XML
> (perhaps that was at version 4?) But what's odder is that even if I
> expressly request "save as XML", I still get a binary file. Is this
> compressed, and if so, does anyone know what the compression is? I'm aware
> that interpreting the logs will be much easier if I can correlate the UUIDs
> of the accounts (used in the logs) with the actual account info (which I
> have previously seen in a tolerably intelligible format in the XML files of
> old).
>
> Any pointers / references?
>
> TIA
> Simon
>
> --
> Simon Roberts
> 303 249 3613
> https://www.youtube.com/@DancingCloudServices
> https://www.linkedin.com/in/simonhgroberts/
> ___
> 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
https://www.youtube.com/@DancingCloudServices
https://www.linkedin.com/in/simonhgroberts/
___
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] File format question

2024-01-31 Thread Simon Roberts
Hi all, perhaps I should be asking this on the developer's list, but I
figured that misdirecting here would be less disruptive / annoying than
miscrirecting there. Please forgive me if this is the wrong place.

I'm investigating using logfiles as a means to identify changes that will
be made by my accountants for my year end. This leads me to two questions

First, is there documentation I can look at on this topic"? I didn't find
anything in the user guide, but am not particularly surprised at that.

Second, I notice that the main data file is binary. I thought it was XML
(perhaps that was at version 4?) But what's odder is that even if I
expressly request "save as XML", I still get a binary file. Is this
compressed, and if so, does anyone know what the compression is? I'm aware
that interpreting the logs will be much easier if I can correlate the UUIDs
of the accounts (used in the logs) with the actual account info (which I
have previously seen in a tolerably intelligible format in the XML files of
old).

Any pointers / references?

TIA
Simon

-- 
Simon Roberts
303 249 3613
https://www.youtube.com/@DancingCloudServices
https://www.linkedin.com/in/simonhgroberts/
___
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] Compare two sets of accounts?

2024-01-20 Thread Simon Roberts
Gosh, many ideas, thank you. I will run some experiments to see if one of
these is easier/harder or more/less effective than others, but
clearly there are possibilities.

Many thanks everyone for all the time and thought you've put into these
suggestions, it's much appreciated.

Cheers,
Simon


On Fri, Jan 19, 2024 at 6:50 AM Simon Roberts <
si...@dancingcloudservices.com> wrote:

> Hi all,
>
> Does GNC provide any mechanism for comparing two versions of the same set
> of accounts?
>
> I'll be sending my books to my accountant soon, and I imagine they will
> have some corrections/adjustments. I'll be giving them a laptop with GNC
> installed, so they can most easily browse, and it occurs to me that they
> could also make their changes in place. But, unless they write down
> separately every entry they create or change, I would need to somehow
> re-integrate their work with my "master" file. Either that, or I'd have to
> freeze my bookkeeping while they're working on things, and that's likely to
> take too long to be acceptable.
>
> With the hostage-taker's rent-ware that I used to use, there was a
> specific mechanism for an "accountant's copy" and a means to merge the
> changes back automatically. But I've failed to find this in the docs for
> GNC (quite possibly as a result of poor / uninspired searching!)
>
> Is this supported directly? Is this something folks have found an approach
> for? I suppose, as a not quite worst case, I could simply diff the XML file
> itself, but that's going to produce results that will be somewhat messy, at
> best. But at least I'd know something about what changed.
>
> What ideas can you offer (or manual pages, if I've failed that
> embarrassingly!)
>
> TIA,
> Simon
>
>
> --
> Simon Roberts
> 303 249 3613
> https://www.youtube.com/@DancingCloudServices
> https://www.linkedin.com/in/simonhgroberts/
>
>

-- 
Simon Roberts
303 249 3613
https://www.youtube.com/@DancingCloudServices
https://www.linkedin.com/in/simonhgroberts/
___
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] Compare two sets of accounts?

2024-01-19 Thread Simon Roberts
Well, that's one possibility I suppose.

Is this not a feature that would find fairly widespread use? Indeed, is it
not a feature that might facilitate easier use of the software and
encourage wider adoption?

I'm still holding out hope that it might exist already :)

Thanks for the suggestion Gyle


On Fri, Jan 19, 2024 at 9:41 AM Gyle McCollam  wrote:

> The quick and dirty solution is to save a copy of what you send to the
> accounts, under a different name (say: B4A) and when you get back the file
> from the accountants review the accounts tab of the B4A with the returned
> file.  That will tell you which accounts have a change in value.  You can
> then open those accounts and see what changes/corrections they made.  ou
> can then make those same changes in your current file.  Just make sure that
> after you save a copy (B4A) that you aren't using that file going forward
> as GC usually opens the last saved file.
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> ------
> *From:* gnucash-user 
> on behalf of Simon Roberts 
> *Sent:* Friday, January 19, 2024 8:50 AM
> *To:* Gnucash Users 
> *Subject:* [GNC] Compare two sets of accounts?
>
> Hi all,
>
> Does GNC provide any mechanism for comparing two versions of the same set
> of accounts?
>
> I'll be sending my books to my accountant soon, and I imagine they will
> have some corrections/adjustments. I'll be giving them a laptop with GNC
> installed, so they can most easily browse, and it occurs to me that they
> could also make their changes in place. But, unless they write down
> separately every entry they create or change, I would need to somehow
> re-integrate their work with my "master" file. Either that, or I'd have to
> freeze my bookkeeping while they're working on things, and that's likely to
> take too long to be acceptable.
>
> With the hostage-taker's rent-ware that I used to use, there was a specific
> mechanism for an "accountant's copy" and a means to merge the changes back
> automatically. But I've failed to find this in the docs for GNC (quite
> possibly as a result of poor / uninspired searching!)
>
> Is this supported directly? Is this something folks have found an approach
> for? I suppose, as a not quite worst case, I could simply diff the XML file
> itself, but that's going to produce results that will be somewhat messy, at
> best. But at least I'd know something about what changed.
>
> What ideas can you offer (or manual pages, if I've failed that
> embarrassingly!)
>
> TIA,
> Simon
>
>
> --
> Simon Roberts
> 303 249 3613
> https://www.youtube.com/@DancingCloudServices
> https://www.linkedin.com/in/simonhgroberts/
> ___
> 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
https://www.youtube.com/@DancingCloudServices
https://www.linkedin.com/in/simonhgroberts/
___
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] Compare two sets of accounts?

2024-01-19 Thread Simon Roberts
Hi all,

Does GNC provide any mechanism for comparing two versions of the same set
of accounts?

I'll be sending my books to my accountant soon, and I imagine they will
have some corrections/adjustments. I'll be giving them a laptop with GNC
installed, so they can most easily browse, and it occurs to me that they
could also make their changes in place. But, unless they write down
separately every entry they create or change, I would need to somehow
re-integrate their work with my "master" file. Either that, or I'd have to
freeze my bookkeeping while they're working on things, and that's likely to
take too long to be acceptable.

With the hostage-taker's rent-ware that I used to use, there was a specific
mechanism for an "accountant's copy" and a means to merge the changes back
automatically. But I've failed to find this in the docs for GNC (quite
possibly as a result of poor / uninspired searching!)

Is this supported directly? Is this something folks have found an approach
for? I suppose, as a not quite worst case, I could simply diff the XML file
itself, but that's going to produce results that will be somewhat messy, at
best. But at least I'd know something about what changed.

What ideas can you offer (or manual pages, if I've failed that
embarrassingly!)

TIA,
Simon


-- 
Simon Roberts
303 249 3613
https://www.youtube.com/@DancingCloudServices
https://www.linkedin.com/in/simonhgroberts/
___
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] Can I print an account?

2023-12-18 Thread Simon Roberts
Aha, I will investigate that, thank you! 👍👍

On Mon, Dec 18, 2023, 17:15 Stephen M. Butler  wrote:

> Check out the Transaction Report.  You will have to configure it to get
> any useful information.  One or more accounts, date range, etc.
>
> Stephen M Butler
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> On 12/18/23 15:58, Simon Roberts wrote:
> > Hi all, I'd like to be able to print a range of transactions in a single
> > account. Essentially just a dump of what I see on the screen, though I
> > suppose I would need to select a range of rows and the columns that
> should
> > be in the output.
> >
> > Can this be done? Is it one of the business reports? My accounting
> > background is essentially nothing, so it's entirely possible I don't know
> > what one of them might do, though I believe I've tried all the options.
> >
> > Thanks for any input!
> > Cheers,
> > Simon
> >
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Can I print an account?

2023-12-18 Thread Simon Roberts
Hi all, I'd like to be able to print a range of transactions in a single
account. Essentially just a dump of what I see on the screen, though I
suppose I would need to select a range of rows and the columns that should
be in the output.

Can this be done? Is it one of the business reports? My accounting
background is essentially nothing, so it's entirely possible I don't know
what one of them might do, though I believe I've tried all the options.

Thanks for any input!
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] Payment of invoice in downloaded transactions?

2023-09-23 Thread Simon Roberts
Oh dear, that was embarrassingly easy in the end. Many thanks for the
guidance Mattia, it's much appreciated.

Cheers,
Simon



>
> From: Mattia Rizzolo 
>
[...]

>
> On Fri, Sep 22, 2023 at 03:42:29PM -0600, Simon Roberts wrote:
> > Today I did an import of bank transactions using OFX, and one of the
> > transactions is a payment of an invoice. How to I tie the two together?
>
> Right click on the transaction > "Assign as payment..."
>
> ?
>
> --
> regards,
> Mattia Rizzolo
>

-- 
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] Payment of invoice in downloaded transactions?

2023-09-22 Thread Simon Roberts
Hi all,

Today I did an import of bank transactions using OFX, and one of the
transactions is a payment of an invoice. How to I tie the two together?
That is, the bank account balances / reconciles, and the money has been
received for the invoice, but the invoice still thinks it's unpaid--clearly
there's something I should have done to let the system know that this
particular receipt goes against that particular invoice.

Thanks for any pointers!
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] Trouble building 5.3

2023-07-23 Thread Simon Roberts
Oh, so the dependency is specific to that feature? That's good to know, I
have no idea what that feature is, which suggests I don't use it.

All that said, I now, as if by way of a nudge, a crisis with that server, I
might have to rebuild it anyway, in which case perhaps I will upgrade it to
22.04 and be done.

My fingers are crossed I can get the machine back up--obviously that just
became my priority. Weekend? What's that?

Thanks for the input folks,
Cheers,
Simon


On Sun, Jul 23, 2023 at 9:10 AM mjchurc...@aol.com 
wrote:

> If you don't use AQBanking, you can build with it turned off. That's what
> I did with another distro. Mike
>
> On Saturday, July 22, 2023 at 02:15:43 PM PDT, Simon Roberts <
> si...@dancingcloudservices.com> wrote:
>
>
> Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
> a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
> on this 20.04 "production" machine, the same process is failing. I don't
> want to upgrade this at this time if I can help it--it would disturb too
> many other things that are working smoothly.
>
> I did this:
>
> $ sudo apt-get build-dep gnucash
> Reading package lists... Done
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.
>
> (I'm not sure why it installed nothing, I don't think I built GNC on this
> before)
> But then when I run the cmake process with:
>
> $ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/
>
> It progresses a while before reporting:
>
> -- Checking for module 'gwenhywfar>=5.6.0'
> --  Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
> CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
> (message):
>   A required package was not found
>
> At the risk of stating the obvious, it seems I have the older version:
>
> $ sudo apt list libgwenhywfar\*
> Listing... Done
> libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
> libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
> libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
> libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
> libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]
>
> And it doesn't seem that 20.04 is willing to upgrade this.
>
> Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
> successfully? Or can anyone offer a workaround (e.g. is it perhaps
> practical to build the newer version of this library by hand?)
>
> Thanks for any ideas!
> 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.
>


-- 
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] Trouble building 5.3

2023-07-22 Thread Simon Roberts
Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
on this 20.04 "production" machine, the same process is failing. I don't
want to upgrade this at this time if I can help it--it would disturb too
many other things that are working smoothly.

I did this:

$ sudo apt-get build-dep gnucash
Reading package lists... Done
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.

(I'm not sure why it installed nothing, I don't think I built GNC on this
before)
But then when I run the cmake process with:

$ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/

It progresses a while before reporting:

-- Checking for module 'gwenhywfar>=5.6.0'
--   Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
(message):
  A required package was not found

At the risk of stating the obvious, it seems I have the older version:

$ sudo apt list libgwenhywfar\*
Listing... Done
libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]

And it doesn't seem that 20.04 is willing to upgrade this.

Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
successfully? Or can anyone offer a workaround (e.g. is it perhaps
practical to build the newer version of this library by hand?)

Thanks for any ideas!
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] "Comparative" reports?

2023-07-20 Thread Simon Roberts
>
>
>
> From: Michael or Penny Novack 
>

Thanks, I can see a custom built "paper" report having merit. I think the
accountant is comparing with "that evil program" which allows side by side
"live" reports that they can click-to-dive in.


> --
>
> From: NoobAlice 
>
[...]

> In GnuCash 5.1 (not sure when feature first showed up, but I think it
> was recent), you can do this for nice divisions such as year, half-year,
> quarter, month, 2-weeks, and week.
>
> Reports > Income & Expense > Income Statement (Multicolumn)
> or
> Reports > Assets & Liabilities > Balance Sheet (Multicolumn)
>
> In Options > top tab General, choose Period Duration of how you want the
> info split, then choose start and end dates appropriately.
>

Wonderful thank you. All the more reason for me to upgrade. I'd been
putting it off on the "it's fine as it is" basis, but this sounds like a
good trigger.

[...]

> --
>
> Message: 9



> From: Adrien Monteleone 
>
[...]

> In addition to the new multi-column ability of some reports as NoobAlice
> pointed out, you can also run old-school 'Custom Multi Column' reports
> which lets you put multiple reports into 'one'. You can of course
> further manipulate this in a spreadhsheet app as Michael noted.
>
[...]
Aha, also helpful to know, thank you Adrien

Much appreciate everyone's input :)
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.


[GNC] "Comparative" reports?

2023-07-19 Thread Simon Roberts
Hi all, I just got home from a very positive meeting with my CPA (showing
them my books, since I took over my own bookkeeping, and thereby also
showing them GnC, with which they were impressed).

They raised a question; Is there a built in mechanism for "comparative"
reporting? For example, showing income from Jan 1 to date, alongside income
over the same months in the previous year?

Clearly not a big deal, since I can just create two reports and print them
then look at them side by side, but it's what that "other" program does,
and it makes them feel cozy.

Currently I'm using v4, but now I know they're happy I will be upgrading to
5.x in the next month or so.

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] New tax year - unexpected GnuCash display

2023-04-06 Thread Simon Roberts
Do you have UK date style selected? Or do you have the tax year starting
on  june 4th?

On Thu, Apr 6, 2023 at 9:23 AM aeg via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'm using GnuCash Version 4.12 on Windows 10, and today, 6 April, is the
> beginning of the new UK tax year.
> As I have the "Total (Period)" column showing in the COE, I was expecting
> to see mostly zeros in that column today, but was surprised to see many
> totals much higher than that, and in the region of what I might have
> expected if it had not been a new fiscal year.
> Under Preferences/Accounting Period/Start Date, the selection is
> Absolute:6/4/23, and under End Date, the selection is Relative:Today.
> In previous years, this arrangement has appeared to work as expected, and
> the only other change I've made since last year is an upgrade from GC 3.5
> to GC 4.12.
> Today, after a series of trial-and-error changes to the Preferences setup,
> each followed by a restart of the program, I've managed to get it working
> as expected, with the final setting the same was at the start. Although it
> now seems that all is well, I'd be interested to know how this problem
> might have occurred, and whether there is anything I should have done to
> prevent it, or whether there might be a bug in the program that others may
> be able to identify. Also, is there any possibility that other totals in
> that column may have been inaccurate during the last 12 months but were
> less easy to spot than they were today?
>
> Regards,Alan
> ___
> 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] Site certificate expiry warning

2023-03-24 Thread Simon Roberts
I agree--the reality of any risk is small enough to normal people to be
irrelevant, but the damage to credibility among those who might want to use
GNC but are not familiar with the significance of public key asymmetric
cryptography, is not at all trivial.

Meanwhile, thank you Dr. Kirbly, your note on letsencrypt was spectacularly
timely, I was literally just in the process of trying to work out how to
get a certificate for a "scratch domain" I'd set up in AWS, and this has
worked a treat :)

Cheers,
Simon


On Fri, Mar 24, 2023 at 11:53 AM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Fri, 24 Mar 2023 at 15:22,  wrote:
>
> > On Fri, Mar 24, 2023 at 11:16:09AM +, Michael Hendry wrote:
> > > I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and
> I’ve
> > > just been informed that www.gnucash.org is being flagged up as
> dangerous
> > > because its site certificate expired recently.
> > >
> > How does that make the site 'dangerous'?  All it means is that
> > communication between you (i.e. the user) and the site isn't
> > encrypted. As you don't need to send or receive any confidential
> > information the lack of encryption is wholly irrelevant!
> >
> > --
> > Chris Green
>
>
> Whilst I don’t disagree with you on a technical level, you need to bear in
> mind that browsers are going to warn people, and that will put people off.
>
> There’s a body of opinion that this will impact Google ranking.
>
> I have in the past paid for a fairly expensive EV SSL  certificate, but now
> I use
>
> https://letsencrypt.org/
>
> on Debian Linux. The certificates are valid for 90 days, but renewed after
> 60 days.
>
> 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.
>


-- 
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] Outstanding / due invoices report?

2023-03-20 Thread Simon Roberts
This report looks pretty good, however, I have a couple of questions:

1) I find the description field remains blank, despite my invoices having
non-blank descriptions. Is this normal? Do others find the same thing? Or
did I somehow find a way to mess up my descriptions?

2) In the report it has a row across the bottom listing "current", "0-30
days" and so forth. But two things strike me as odd here. One, what's
current as distinct from 0-30 days? And second, there's one invoice that's
over 30 days old, and that's the only thing that shows in the "0-30 days"
column. This seems wrong. Again, is this something others notice, or is
this something that I've done wrong?

Thanks again,
Cheers,
Simon


On Sun, Mar 19, 2023 at 1:32 PM Simon Roberts <
si...@dancingcloudservices.com> wrote:

> Ah, many thanks. Sorry for missing that, and much appreciate your help :)
>
> Cheers,
> Simon
>
>
> On Sun, Mar 19, 2023 at 11:29 AM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
>
>> Simon
>>
>> You can use the customer report to get a statement which you can send,
>> this includes the invoice paid and also outstanding with ageing.
>>
>>
>>
>> Saludos Cordiales
>>
>>
>> Murugan
>> --
>> *From:* gnucash-user > hotmail@gnucash.org> on behalf of Simon Roberts <
>> si...@dancingcloudservices.com>
>> *Sent:* Sunday, March 19, 2023 10:17 AM
>> *To:* Gnucash Users 
>> *Subject:* [GNC] Outstanding / due invoices report?
>>
>> Hi all,
>>
>> I'm wondering if there's a built-in report, in a form suitable for sending
>> to a client, that lists the invoices they currently owe. Or perhaps those
>> that are overdue?
>>
>> I'm creating a reminder as a simple email message, but this seems like
>> something others might need, and therefore something that might be part of
>> GNC already.
>>
>> Ideally, it would be nice to be able to append this to any new invoice for
>> that same customer, maybe.
>>
>> I have found Business->Customer->Invoices Due Reminder, but that seems to
>> be solely to tell me what's due/overdue and isn't printable.
>>
>> Does any such thing exist?
>>
>> 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.
>>
>
>
> --
> 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] Outstanding / due invoices report?

2023-03-19 Thread Simon Roberts
Ah, many thanks. Sorry for missing that, and much appreciate your help :)

Cheers,
Simon


On Sun, Mar 19, 2023 at 11:29 AM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Simon
>
> You can use the customer report to get a statement which you can send,
> this includes the invoice paid and also outstanding with ageing.
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Simon Roberts <
> si...@dancingcloudservices.com>
> *Sent:* Sunday, March 19, 2023 10:17 AM
> *To:* Gnucash Users 
> *Subject:* [GNC] Outstanding / due invoices report?
>
> Hi all,
>
> I'm wondering if there's a built-in report, in a form suitable for sending
> to a client, that lists the invoices they currently owe. Or perhaps those
> that are overdue?
>
> I'm creating a reminder as a simple email message, but this seems like
> something others might need, and therefore something that might be part of
> GNC already.
>
> Ideally, it would be nice to be able to append this to any new invoice for
> that same customer, maybe.
>
> I have found Business->Customer->Invoices Due Reminder, but that seems to
> be solely to tell me what's due/overdue and isn't printable.
>
> Does any such thing exist?
>
> 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.
>


-- 
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] Outstanding / due invoices report?

2023-03-19 Thread Simon Roberts
Hi all,

I'm wondering if there's a built-in report, in a form suitable for sending
to a client, that lists the invoices they currently owe. Or perhaps those
that are overdue?

I'm creating a reminder as a simple email message, but this seems like
something others might need, and therefore something that might be part of
GNC already.

Ideally, it would be nice to be able to append this to any new invoice for
that same customer, maybe.

I have found Business->Customer->Invoices Due Reminder, but that seems to
be solely to tell me what's due/overdue and isn't printable.

Does any such thing exist?

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] Help with downloading transactions.

2023-03-18 Thread Simon Roberts
I feel compelled to add my agreement with Alan. This kind of crime is on
the rise and we're all vulnerable. Credit card companies insist on giving
many fiscally prudent folks much higher credit limits than they actually
use, and that just adds to the risk. Debit cards are worse since the
protections are far weaker (at least in the U.S.). I check my data twice
monthly with downloads.

On Sat, Mar 18, 2023, 03:05 Alan A Holmes  wrote:

> I'm afraid I would disagree Phyllis. Having been scammed, through no fault
> of mine, I ALWAYS reconcile my accounts each month.
>
> 1. Banks do, and have made mistakes. Usually down to human error, though
> sometimes masked as being a computer error.
> 2. More importantly is fraudulent transactions. I've had 3 occasions where
> my credit card details have been scammed. If I hadn't checked my credit
> card statement against my receipts I would never have found 2 of the 3
> scams.
> a) The first occasion was in the days when you had to swipe the card,
> before chip and pin. Somehow the machine had been doctored and it made
> multiple transactions.
> b) The second scam was when my card details were used at exactly the same
> time to purchase things at locations over 100 miles apart. The bank called
> me and after investigation found that my details had been stolen by a phone
> agent when I'd made legitimate transaction, and then used to buy something
> for themselves.
> c) The third occasion I found a transaction I didn't recognise on my
> credit card statement and reported it to the bank. They investigated and
> found the transaction was at exactly the same time as another transaction
> at a Motorway Service Station when I'd paid by tapping my card. They found
> the cashier had their own machine under the counter so as I passed my card
> over the genuine machine it had also triggered the 2nd machine.
> In all 3 cases the offenders were caught and prosecuted, my card was
> stopped and replaced to prevent further thefts, and I was refunded. Had I
> not checked my statement every month the first and third scams might not
> have been picked up as quickly or even at all.
>
>
>
> Alan A Holmes
>
> -Original Message-
> From: gnucash-user  alanaholmes.me...@gnucash.org> On Behalf Of Phyllis Bruce
> Sent: 17 March 2023 21:17
> To: stepbystepf...@comcast.net
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Help with downloading transactions.
>
> I did for many years retain my receipts for credit card charges and match
> every one to the statement.  Same with checks, etc.  The banks so seldom
> make a mistake that I find it a waste of time.  In recent years one of my
> banks has issued a correction.  That's good enough for me.
>
> On Fri, Mar 17, 2023 at 10:50 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> >
> > > This is a philosophical point.
> > > There is group "M" who always enter every transaction first in their
> > > books and then use the bank documents to reconcile
> > >
> > > and
> > >
> > > There is group "K" who enter some things and use the bank download
> > > to keep their accounts.
> > >
> > > There are pros and cons to each method. Gnucash allows you to make
> > > your own choice.
> >
> > Well put, but more than a philosophical difference.
> >
> > The former group is "reconciling", confirming that their records match
> > those of the bank. Dealing with an errors or omissions. In my personal
> > experience, bank errors though rare do occur. Also rare but every now
> > and then, the error or omission at the books side.
> >
> > The second group is NOT reconciling anything. If the transactions in
> > the books came from a download from the bank it WILL match what the
> > bank bank statement. So the reconcile process in gnucash meaningless.
> > Any errors the bank might have made, say misreading a check, will not
> > be detected. We should also note that at any time the balance in the
> > books will be larger than the actual balance by the amount of the "float"
> > (checks written and sent but not yet cleared)
> >
> > 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.
> >
> ___
> 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/gnuc

Re: [GNC] The custom invoice problem

2023-03-05 Thread Simon Roberts
I second this... Even the simple ability to save the configuration of one
invoice so the next one comes out the same would help. I am willing to work
with the basic layout, but gave to go through all the tabs of configuration
with every invoice I send. Treating each as a different report seems like
an accident of development route, not a deliberate design choice.

But hey, I still prefer all this to being held hostage by Intuit, so my
grateful thanks to the developers all the same.

On Sun, Mar 5, 2023, 08:26 Roland Giesler via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi all,
>
> Since 2016 (and probably before that), there are have been questions
> about the lack of reasonably accessible tools for small business users
> to create invoices that contain the company logo and a customised layout
> for a particular setting.
>
> https://lists.gnucash.org/pipermail/gnucash-user/2016-June/065750.html
> https://lists.gnucash.org/pipermail/gnucash-user/2022-January/099232.html
>
> I sure there are many more of these and they have been raised years ago
> already.
>
> A software developer of a someone seasoned in the internals of eguile
> and css is probably able to hack something together, but an ordinary
> user (albeit somewhat technically proficient in css, html and some
> scripting languages) has little chance of addressing this issue.
>
> Questions I have are:
>
> 1. Do people in other parts of the world not want to send professional
> looking invoice to their clients?  Are they even using GNUCash for
> invoicing?  This seems like a core feature of GNUCash that is just being
> ignored. (2016 is 7 years ago!)
>
> 2. The GNUCash roadmap pages  say
> regarding Scheme: /"Scheme is impenetrable to most programmers.
> Expecting users to be able to write reports in Scheme is completely
> unreasonable."/  This is true, but the general usability of GNUCash
> reports must be expanded so that any report can be selected as the
> default for a particular feature (like invoicing). /*Surely this is a
> core requirement, is it not?*/ If we have the feature to add a menu
> option ,
> then it could be a fairly trivial matter for a developer to add the
> functionality to select a saved report (or some customised invoice) as
> the default when the "print invoice" button is pressed?
>
> 3. Is there some bounty system where one could contribute to speed up
> this feature?
>
> I'm a huge FOSS fan and if there is some way in which I could help to
> get this implemented, please let me know!
>
> regards
>
> Roland
>
> ___
> 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] Account Types -- what are the implications of getting them wrong?

2023-02-20 Thread Simon Roberts
>
> > > On 2023-02-19 05:32, m...@tgr66.me wrote:
> > >
> > > > The approach I’m taking in a migration app I’m writing will be
> > > > conservative, erring on the side of more general vice more specific.
> For
> > > > example, ASSET, LIABILITY, INCOME, EXPENSE, EQUITY are pretty easy to
> > > > accurately apply based on account names (for example, “assets:current
> > > > assets:cash”). In an initial round of type assignments, this account
> would
> > > > get ASSET as its type. In a deeper subsequent look, it should be
> > > > reassigned with a type of CASH.
> > > >
> > > > INCOME, EXPENSE and EQUITY types don’t have sub-types I see, so
> those will
> > > > be even easier. I don’t foresee any issues with those.
> > > >
> > > > LIABILITY and CREDIT don’t appear too difficult as there just aren’t
> that
> > > > many options. First I’ll assign LIABILITY and if the words “credit
> card”
> > > > or “credit cards” exist in the rest of the account path, I’ll switch
> to
> > > > CREDIT, otherwise, leave it alone.
> > > >
> > > > Assets and Investments will be the trickiest. Let me start with
> Assets
> > > > first.
> > > >
> > > > Assume an imported account has the path and name of
> “assets:savings:family
> > > > savings”. Getting this typed as an ASSET is pretty straightforward.
> > > > Ideally, however, it would be typed as BANK.
> > > >
> > > > Or SHOULD it? Perhaps this family puts its savings in old coffee cans
> > > > under the back porch. So, I’d be inclined to leave this as ASSET.
> The user
> > > > can change it, but are there any negative implications of assigning
> too
> > > > general of an account type to an account?
> > > >
> > > > However, if the name has the word “account” in it, well, then I’d be
> > > > confident assigning a type of BANK.
> > > >
> > > > Investment accounts will be the trickiest I believe. Heck, I’m not
> sure I
> > > > understand the differences.
> > > >
> > > > When I create a new account in GnuCash, I’m surprised at some of the
> > > > assignments made when creating the hierarchy. For example,
> > > > “Assets:Investments:Brokerage Account” is a placeholder with type of
> BANK.
> > > > I would be inclined to assign any placeholder accounts a more generic
> > > > type. In this case, ASSET. Again, are there any negative
> implications of
> > > > me taking this approach?
> > > >
> > > > Regardless, I will direct the user to review all of them once
> created in
> > > > GnuCash to ensure they align with their exceptions, but are there
> > > > consequences if I get them wrong?
> > > >
> > > > And finally, TRADING. I don’t see any of those in the initial
> account list
> > > > created when I make a new file. So, for now, I’ll ignore this. Is
> that
> > > > okay?
> >
> > ___
> > 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.
>


-- 
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] Splitting an imported transaction?

2023-02-04 Thread Simon Roberts
Thanks John, this makes sense. I'll try it in 3 months.

Cheers,
Simon

On Sat, Feb 4, 2023 at 10:17 AM john  wrote:

> > On Feb 4, 2023, at 7:23 AM, Simon Roberts <
> si...@dancingcloudservices.com> wrote:
> >
> > Hi all,
> >
> > I use a third party organization to run payroll, and they make two
> > withdrawals from my bank. One is the amount actually paid to employees
> (two
> > of us :) and the other is the sum of taxes collected from those
> employees,
> > plus the employer's tax contributions.
> >
> > Unsurprisingly, when this imports, from the bank records, it shows as two
> > transactions, and the tax stuff is all lumped into a single transaction.
> >
> > As yet, I've only handled this once and did it wrong anyway (I fixed it
> up
> > by hand OK though). However, in three months it'll happen again so I
> figure
> > if I ask now I could be ready to try to do it right next time.
> >
> > What I'd like--but suspect might be impossible, is to persuade the import
> > operation to create a split to the two accounts (payroll taxes: employer
> > and payroll taxes-employee). I'm not so concerned about how the money is
> > allocated across the split (there's really no way for the system to know
> > what to do about that, after all), but if there's a placeholder, that
> would
> > be a nice start.
> >
> > Or perhaps there's some other approach that I've not thought of?
> >
> > What do folks recommend?
>
> I suggest creating a scheduled transaction that creates the splits. Make
> the descriptions the same as the imported transaction and the posted date
> and amount as close as possible. The goal is for the matcher to see that as
> possibly the same as the imported transaction and offer to match it instead
> of creating a new one.
>
> Regards,
> John Ralls
>
>

-- 
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] Splitting an imported transaction?

2023-02-04 Thread Simon Roberts
Thanks Chris, I'll try this next time (in May!). I appreciate the guidance.

Cheers,
Simon

On Sat, Feb 4, 2023 at 10:52 AM Chris Skudder 
wrote:

> One way is to schedule a transaction to be created before you import the
> bank record. Then match the imported bank record to the scheduled
> transaction. The amounts on payrolls are often pretty consistent from
> one payroll run to the next, so it might match automatically, or you
> might have to select the match manually.
>
> You might also have to edit the created transaction, to exactly match
> the amounts for the current payroll run. But at least you can program in
> the splits with the right GL accounts (with a default amount),
> descriptions, etc. That way at least the transaction is all set up, with
> the possible exception of some minor edits.
>
> Chris
>
> Similar situation -
> I'm treasurer of our church, which has 4 employees and pays every 2
> weeks, with the same structure of 2 direct debits - one for what's paid
> to employees and the other for what's deposited to govt tax collection
> accts.
> We charge the wages and taxes to 8-10 different GL acct's in our books.
> The church is on Quickbooks Online which doesn't offer scheduled
> transactions unless you upgrade + pay them more money - argh.
> So when I run payroll, I copy the previous payroll run's transactions
> and edit the amounts to match the current payroll run, change date etc.
> The edited transactions match to the bank's record of the direct debits
> when they come in.
>
> ----
>
> On 2/4/23 11:43, gnucash-user-requ...@gnucash.org wrote:
> > Date: Sat, 4 Feb 2023 08:23:00 -0700
> > From: Simon Roberts
> > To: Gnucash Users
> > Subject: [GNC] Splitting an imported transaction?
> > Message-ID:
> >   <
> cadsqa7iyepresd6wdkhy_2nilu0y812yfyoj2s9l+jfyzvs...@mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Hi all,
> >
> > I use a third party organization to run payroll, and they make two
> > withdrawals from my bank. One is the amount actually paid to employees
> (two
> > of us 😄 and the other is the sum of taxes collected from those
> employees,
> > plus the employer's tax contributions.
> >
> > Unsurprisingly, when this imports, from the bank records, it shows as two
> > transactions, and the tax stuff is all lumped into a single transaction.
> >
> > As yet, I've only handled this once and did it wrong anyway (I fixed it
> up
> > by hand OK though). However, in three months it'll happen again so I
> figure
> > if I ask now I could be ready to try to do it right next time.
> >
> > What I'd like--but suspect might be impossible, is to persuade the import
> > operation to create a split to the two accounts (payroll taxes: employer
> > and payroll taxes-employee). I'm not so concerned about how the money is
> > allocated across the split (there's really no way for the system to know
> > what to do about that, after all), but if there's a placeholder, that
> would
> > be a nice start.
> >
> > Or perhaps there's some other approach that I've not thought of?
> >
> > What do folks recommend?
> >
> > 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.
>


-- 
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] Splitting an imported transaction?

2023-02-04 Thread Simon Roberts
Once every three months, this *particular* pair of transactions will occur.
There are plenty of others in that happen over those three months.

On Sat, Feb 4, 2023 at 9:43 AM William Prescott 
wrote:

> Maybe I'm missing something, but I don't understand why you are bothering
> to do an import if there are only two transactions once every three months.
> Wouldn't it be easier to just enter them by hand the way you want
>
> On Feb 4, 2023, at 09:23, Simon Roberts 
> wrote:
>
> Hi all,
>
> I use a third party organization to run payroll, and they make two
> withdrawals from my bank. One is the amount actually paid to employees (two
> of us :) and the other is the sum of taxes collected from those employees,
> plus the employer's tax contributions.
>
> Unsurprisingly, when this imports, from the bank records, it shows as two
> transactions, and the tax stuff is all lumped into a single transaction.
>
> As yet, I've only handled this once and did it wrong anyway (I fixed it up
> by hand OK though). However, in three months it'll happen again so I figure
> if I ask now I could be ready to try to do it right next time.
>
> What I'd like--but suspect might be impossible, is to persuade the import
> operation to create a split to the two accounts (payroll taxes: employer
> and payroll taxes-employee). I'm not so concerned about how the money is
> allocated across the split (there's really no way for the system to know
> what to do about that, after all), but if there's a placeholder, that would
> be a nice start.
>
> Or perhaps there's some other approach that I've not thought of?
>
> What do folks recommend?
>
> 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.
>
> ___
> 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] Splitting an imported transaction?

2023-02-04 Thread Simon Roberts
Hi all,

I use a third party organization to run payroll, and they make two
withdrawals from my bank. One is the amount actually paid to employees (two
of us :) and the other is the sum of taxes collected from those employees,
plus the employer's tax contributions.

Unsurprisingly, when this imports, from the bank records, it shows as two
transactions, and the tax stuff is all lumped into a single transaction.

As yet, I've only handled this once and did it wrong anyway (I fixed it up
by hand OK though). However, in three months it'll happen again so I figure
if I ask now I could be ready to try to do it right next time.

What I'd like--but suspect might be impossible, is to persuade the import
operation to create a split to the two accounts (payroll taxes: employer
and payroll taxes-employee). I'm not so concerned about how the money is
allocated across the split (there's really no way for the system to know
what to do about that, after all), but if there's a placeholder, that would
be a nice start.

Or perhaps there's some other approach that I've not thought of?

What do folks recommend?

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.


[GNC] The wacky idea and the accountant

2023-02-01 Thread Simon Roberts
First, thank you to everyone who put ideas in about providing an
easy-to-launch CD-based GNC to present to my accountant, and the ensuing
discussion w.r.t. portable apps. I shall look into that in due course.

But, for what it's worth, I figured I'd report back on my meeting with my
CPA. They had never heard of GnuCash, Gnu, Linux nor anything of this sort.
They had previously told me (when I asked if they could offer suggestions
on something I might use to replace QB) that they had no experience to
offer, but that several of their clients had expressed the same inquiry.

When I showed them GNC, admittedly briefly, they got quite excited--well,
by accountant standards at least :) They asked me to discuss it more with
them, and help them understand further, after tax time, and were very
interested in having it for themselves to browse my books interactively.
They also asked if I might be willing to make a small presentation to some
of their interested clients to help them understand the possibilities and
potential issues if they were to migrate.

I shall, of course, be hoping to get a much more thorough understanding of
the system myself before I do that :)

Perhaps there's hope yet :)

-- 
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] Reconciliation - Again

2023-01-31 Thread Simon Roberts
I'm confident that informational stuff, and the date, are irrelevant to
reconciliation. And many times, the transfer field won't matter. BUT, if
the transfer field is another account subject to reconciliation, and that
transaction has been reconciled in the other account (e.g. you made a
literal transfer from one account to another and it's all "gone through")
then you'll likely have some issues. But, if you successfully reconciled
that transaction on both sides... it can't possibly need you to change the
transfer account, so if what you're proposing is logically correct, then I
think it should be safe too.

Reconciliation, to my perspective, is simply the process of ensuring that
you and the bank agree on the transactions, and their amounts, that you
both think have happened. It doesn't matter if you have different
descriptions, or even dates so long as you correctly identify the two
records (yours and theirs) that represent the same actual transaction.

Open to being corrected, of course :)


On Tue, Jan 31, 2023 at 9:20 AM Eric Coates via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Good Afternoon
>
> I fully understand that changing the Payment/Charge (on a credit card
> account) or the Increase/Decrease  (on a bank account) will create
> difficulties with future reconciliations.
>
> However, is it possible to change the contents of other fields (Date,
> Description and, particularly, Transfer) without causing problems?
>
> Thanks
>
> Eric
>
>
> ___
> 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] Is this a wacky idea?

2023-01-28 Thread Simon Roberts
Oh, excellent news, thank you Liz, I'll go ahead and see if I can prepare a
CD on these lines, and if I can persuade them to use it :)

Much appreciate the input!


On Sat, Jan 28, 2023 at 2:36 PM Liz Dodd  wrote:

> On Sat, 28 Jan 2023 13:38:12 -0700
> Simon Roberts  wrote:
>
> > I envisage burning a CDROM with the books, and a Windows distribution
> > of GNC, hopefully so they can simply put the disk in and click to run.
> > Obviously, the books will be read-only in that event, but they'd be
> > navigable.
> >
> > Has anyone tried this? Is such an installation a possibility? (I'm a
> > Linux user, and it's not unusual to run software that's just "sitting
> > around in a directory tree", but such is not always possible in
> > windows, so that alone might prevent this.).
>
>
> I do it, and the year I didn't provide the .exe file I got asked for
> it. That was related to Covid lockdown and sending the files
> electronically, instead of my usual CD-ROM
>
>
> Liz
> ___
> 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] Is this a wacky idea?

2023-01-28 Thread Simon Roberts
Wow, does the state pay for your CPAs time doing that rekeying? That's a
major reason I'm looking at this. I want them to have instant access, easy
navigation, searching, and cross referencing, without having to run what I
call "hostageware" -- you all know, I'm sure, to which organizations I'm
referring :)

Fortunately, Colorado has no such evil requirements!


On Sat, Jan 28, 2023 at 2:48 PM Rich Shepard 
wrote:

> On Sun, 29 Jan 2023, Liz Dodd wrote:
>
> >> I envisage burning a CDROM with the books, and a Windows distribution
> >> of GNC, hopefully so they can simply put the disk in and click to run.
> >> Obviously, the books will be read-only in that event, but they'd be
> >> navigable.
>
> > I do it, and the year I didn't provide the .exe file I got asked for
> > it. That was related to Covid lockdown and sending the files
> > electronically, instead of my usual CD-ROM
>
> I've not followed this whole thread, so excuse me for jumping in. I've run
> my business using only linux since 1997 and gnucash for most of that time.
> I've sent business and personal end-of-year financials to my CPAs as PDF
> files ... generated by gnucash, with scanned supporting documents. As of
> last year I'm completely paperless. Saves a lot of file draw space. :-)
>
> Here in Oregon CPAs must use the state's software which limps along on only
> Windows, so no matter whatever form the client data arrives they have to
> rekey it. I suppose the feds have the same requirement.
>
> It's never been an issue.
>
> HTH,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] Is this a wacky idea?

2023-01-28 Thread Simon Roberts
I'm aware I could work this out for myself, but it could involve a lot of
wasted time if the answer is no, and this list might have a quick answer
either way.

At some point, I'll need to submit my books to my CPA. They'll take the
usual reports (general ledger, trial balance, stuff like that) on paper,
but is seems that GNC is not that hard to navigate around, and it might be
worth giving them, or offering them at least, a "live" set of books along
with GNC to interact with them.

I envisage burning a CDROM with the books, and a Windows distribution of
GNC, hopefully so they can simply put the disk in and click to run.
Obviously, the books will be read-only in that event, but they'd be
navigable.

Has anyone tried this? Is such an installation a possibility? (I'm a Linux
user, and it's not unusual to run software that's just "sitting around in a
directory tree", but such is not always possible in windows, so that alone
might prevent this.).

Anyway, if anyone has thoughts or relevant experience, I'd be pleased to
hear from you.

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] another beginner question

2023-01-06 Thread Simon Roberts
That does make sense, thanks again Derek.

Cheers,
Simon

On Thu, Jan 5, 2023 at 5:54 PM Derek Atkins  wrote:

> Well, if you put your O-B on all your Assets and Liabilities, then yes,
> that *IS* your current equity in the company.
>
> If you think the balance is too big, then most likely you haven't added
> all your liabilities.
>
> Keep in mind that Income and Expense are actually Equity-type accounts, in
> the sense that In & Ex affect your instantaneous equity.  So when you
> restart, you are rolling up a decade of equity built via Income (-
> Expense).
>
> Hope this helps,
>
> -derek
>
> On Thu, January 5, 2023 7:28 pm, Simon Roberts wrote:
> > Right now I have set up my transition from quickbucks to Gnc such that
> all
> > the bank accounts have an opening balance, which is drawn from
> > "Equity:Opening Balances". However, I think that's ... wrong/misleading,
> > in
> > that this is most definitely not money I just handed over to create the
> > business. It's been running 18 year, and it's just that the transition to
> > this software is happening now. it makes the balance sheet look like I
> > have
> > a bunch more equity in there than perhaps I really do (although I'm a
> > single-owner LLC, so I'm not really sure!)
> >
> > Is there a better way to create those opening balances that makes better
> > sense, or is this really the right way to do it?
> >
> > Thanks for any guidance/suggestions!
> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] another beginner question

2023-01-05 Thread Simon Roberts
Right now I have set up my transition from quickbucks to Gnc such that all
the bank accounts have an opening balance, which is drawn from
"Equity:Opening Balances". However, I think that's ... wrong/misleading, in
that this is most definitely not money I just handed over to create the
business. It's been running 18 year, and it's just that the transition to
this software is happening now. it makes the balance sheet look like I have
a bunch more equity in there than perhaps I really do (although I'm a
single-owner LLC, so I'm not really sure!)

Is there a better way to create those opening balances that makes better
sense, or is this really the right way to do it?

Thanks for any guidance/suggestions!
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.


[GNC] beginner bookkeeping question

2023-01-05 Thread Simon Roberts
Can I check an understanding? I have an account "Liabilities:CreditCard"

Assuming I owe them money, the balance of this would be positive, am I
correct?

Thanks!
Simon

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fields present in invoices?

2023-01-03 Thread Simon Roberts
This sounds great Steve, thanks. I'll pursue that!

Cheers,
Simon


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

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

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

2023-01-03 Thread Simon Roberts
Hah, well, I did:

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

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

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

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

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

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

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

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

Cheers,
Simon


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

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

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fields present in invoices?

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

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

Thanks again,
Simon


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

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


-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Delete / Edit invoice doesn't?

2023-01-03 Thread Simon Roberts
Back again, and very grateful for your ongoing tolerance and help!

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

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

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

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

Cheers,
Simon


-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Invoice emailing?

2023-01-02 Thread 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?

2023-01-02 Thread 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?

2023-01-02 Thread 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] Invoice emailing?

2023-01-02 Thread 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.


[GNC] Fields present in invoices?

2023-01-02 Thread 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?

2023-01-02 Thread 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] Invoice emailing?

2023-01-02 Thread 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] Undo a reconciliation?

2023-01-02 Thread 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.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  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.


Re: [GNC] Undo a reconciliation?

2023-01-02 Thread 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.


[GNC] Undo a reconciliation?

2023-01-02 Thread 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] Autofill on import OFX?

2022-12-31 Thread Simon Roberts
Thanks for this Jean, Murugan, that's very helpful (and rather impressive!)

Do I infer that I need to use the " right click on a transaction in the
transaction matching window, you can edit various fields prior to the
transaction being imported" feature so it knows I'm trying to teach it,
rather than editing after the import is complete?

Cheers,
Simon


On Sat, Dec 31, 2022 at 12:15 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Simon
>
> GNUCash learns the transactions matching when you start input, and stores
> it for future reference. Same is the case with imported files, you can view
> the  import map editor for details.  please note you cannot directly enter
> the assocation here, but you can delete any wrong association and allow
> GNUCash to relearn.
>
> it takes some time for the system to learn the associations.
>
>
>
> Saludos Cordiales
>
>
> Murugan
> ------
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Simon Roberts <
> si...@dancingcloudservices.com>
> *Sent:* Saturday, December 31, 2022 3:20 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] Autofill on import OFX?
>
> Now that I have GC 4.13 and my imported transactions are correctly
> recognized and not dumped, I have another question.
>
> If I have a transaction with, for example, a description field of XYZ, and
> I start to enter a new transaction with the same description, and then hit
> tab, GC auto-fills all the rest of the fields; Transfer, Amount, Memo, etc.
> This is great.
>
> However, this behavior doesn't seem to occur with imported transactions.
>
> To be clear, I don't expect (nor want!) it to overwrite transaction
> details, but inferring the Transfer field, which is of course not specified
> (nor could it be) in the OFX file, would be enormously helpful. Similarly,
> copying over the most recent memo field would be good too.
>
> Is there a way to configure this behavior, or does this constitute a
> feature request?
>
> Another question, which I think is sufficiently related to be OK to put in
> the same message, is that in the system we're migrating away from
> (quickbooks--washes mouth with soap and water :) there are "rules" one can
> apply. For example, "if the description field of the import contains this
> text, then fill out that field with that text". Is there such a mechanism
> in GnuCash, and if so, what's it called (so I can read about it in
> documentation)?
>
> Thanks for all your ongoing help everyone, it's very reassuring that
> there's a community as active and willing to help when making a transition
> as critical as this!
>
> 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.
>


-- 
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] Matching error in OFX import

2022-12-31 Thread Simon Roberts
Good to know, but for 20.04,it gave me 3.8.


On Sat, Dec 31, 2022 at 1:27 PM john  wrote:

>
>
> On Dec 31, 2022, at 8:14 AM, Simon Roberts 
> wrote:
>
> But, I will get back when I'm not using 3.8. It's sad (but clearly nobody
> here is in control of this!) that Ubuntu is packaging such an old version.
>
>
> They're not. You're using Ubuntu 20.04. The current Ubuntu release, 22.10,
> has GnuCash 4.11.
>
> Regards,
> John Ralls
>
>

-- 
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] Autofill on import OFX?

2022-12-31 Thread Simon Roberts
Now that I have GC 4.13 and my imported transactions are correctly
recognized and not dumped, I have another question.

If I have a transaction with, for example, a description field of XYZ, and
I start to enter a new transaction with the same description, and then hit
tab, GC auto-fills all the rest of the fields; Transfer, Amount, Memo, etc.
This is great.

However, this behavior doesn't seem to occur with imported transactions.

To be clear, I don't expect (nor want!) it to overwrite transaction
details, but inferring the Transfer field, which is of course not specified
(nor could it be) in the OFX file, would be enormously helpful. Similarly,
copying over the most recent memo field would be good too.

Is there a way to configure this behavior, or does this constitute a
feature request?

Another question, which I think is sufficiently related to be OK to put in
the same message, is that in the system we're migrating away from
(quickbooks--washes mouth with soap and water :) there are "rules" one can
apply. For example, "if the description field of the import contains this
text, then fill out that field with that text". Is there such a mechanism
in GnuCash, and if so, what's it called (so I can read about it in
documentation)?

Thanks for all your ongoing help everyone, it's very reassuring that
there's a community as active and willing to help when making a transition
as critical as this!

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] OFX import date questions

2022-12-31 Thread Simon Roberts
A side thought Phylls, I think your first observation was about some
transactions that you had imported not showing up?

If that's the case, what version of GnuCash are you running? I was running
3.8, which was the default from the Ubuntu Linux repositories. It was
indeed failing to import some transactions (because it deemed them
duplicates, even though they most definitely were not). However, after
building version 4.13, I no longer see that problem.



On Sat, Dec 31, 2022 at 6:53 AM Phyllis Bruce  wrote:

> Thanks Jean and David,
> My thresholds are prolly set to the defaults.  Another thing I will do is
> filter for "Unreconciled" before I start my reconciliation.  I often have
> some withdrawals that don't occur within two months.  If I know they're
> there, I can change the threshold to look for them.
>
> Second thought, clearly a preference because we are looking at
> "statements" from the bank.  How might I keep the date issued as part of my
> record?  Where should I enter that since, in the reconciliation the date is
> always changed to date cleared?  Just finished reconciling for the month so
> it will be a while before I can test this.  New year - new start
>
> On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts <
> si...@dancingcloudservices.com> wrote:
>
>> Thank you for the help to this point. I think I've worked out the date
>> issue (very embarrassing, nothing to do with GC). Now I have a bunch more
>> questions, but I'll ask them in dedicated threads to minimize confusion.
>>
>> I did notice that the CSV version of the transaction information contains
>> two different date columns one called "Posting" and the other "Effective",
>> but in all my samples so far, they're the same. That had nothing to do
>> with
>> my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any
>> relevance to anyone looking at this thread years from now. The OFX file
>> only seems to contain a single date field ("DTPOSTED").
>>
>> But yeah, overwhelm induced stupidity on my part, sorry. Next question
>> will
>> be a bit more real, but many thanks to everyone who was kind enough to
>> pitch in their ideas.
>>
>>
>> On Fri, Dec 30, 2022 at 3:19 PM David Cousens 
>> wrote:
>>
>> > Simon,
>> >
>> > The OFX file will be the immediate position in the banks records at the
>> > time of
>> > download. What appears in a statement may be after completion of
>> interbank
>> > clearances of funds and the dates in the statement may reflect when this
>> > occurred rather than when the transaction was first received by the
>> bank.
>> > Clearnce times are generally a lot shorter with electronic clearances
>> than
>> > they
>> > used to be can sometimes be delayed. SInce this is a disagreement
>> between
>> > OFX
>> > records and statement both produced by the bank, they are best placed to
>> > explain
>> > what such discrepancies are and why they occur.
>> >
>> > David Cousens
>> >
>> >
>> > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote:
>> > > Beginner/refugee from QuickBooks here (more context below if you
>> > > care).  I'm working in a scratch file, so I can do stupid things while
>> > > learning without damaging anything "important".
>> > >
>> > > I'm working with importing my bank transactions using OFX format
>> (though
>> > > I've also tinkered with CSV, and am willing to use that if it
>> > > solves my problem).
>> > >
>> > > I imported some transactions using OFX. Several things surprised me,
>> but
>> > > the one that I think needs resolving first is that the transaction
>> dates
>> > do
>> > > not match the bank statement.
>> > >
>> > > Earlier I tried the CSV import and saw there were *two* date fields
>> > > (presumably difference between being received and being acted on?
>> > >
>> > > Can someone tell me what I should do to fix this? Is there a way to
>> > "tweek"
>> > > the OFX import, or do I need to use CSV? Or is this something else
>> > entirely
>> > > that's gone amiss?
>> > >
>> > > Thanks for any hints,
>> > > Cheers,
>> > > Simon
>> > >
>> > > Background in case it's relevant:
>> > >
>> > > I'm a refugee from Intuit, and very early i

Re: [GNC] Matching error in OFX import

2022-12-31 Thread Simon Roberts
I've built 4.13 and the problem seems to have been fixed :)


On Sat, Dec 31, 2022 at 9:14 AM Simon Roberts <
si...@dancingcloudservices.com> wrote:

> Gach, yes, sorry meant to reply all, will pay attention in future,
> hopefully not do that again :(
>
> But FWIW, these transactions have different FITIDs and are in a single
> import from a single file (and do not duplicate anything pre-existing).
> But, I will get back when I'm not using 3.8. It's sad (but clearly nobody
> here is in control of this!) that Ubuntu is packaging such an old version.
>
> On Fri, Dec 30, 2022 at 7:08 PM Jean L  wrote:
>
>> Don't forget to reply to the list.
>>
>> Bear in mind: if you import an OFX file, match its transactions to some
>> of your register transactions, the matched transactions will be silently
>> ignored when you re-import the same OFX. That's by design. So if you match
>> everything then re-import the same OFX, you'll have nothing to match.
>>
>> GC uses the FITID to verify that an OFX transaction was already imported
>> and matched (it compares the FITID value of the transaction in the register
>> to that in the OFX file). When GC imports an OFX transaction, it copies the
>> OFX FITID to the register transaction.
>>
>> But yes, update to a recent version as there were bugs in this mechanism
>> that were recently fixed.
>>
>> J
>> On 12/30/2022 6:03 PM, Simon Roberts wrote:
>>
>> Yes, different FITIDs.
>>
>> I'm now finding that actually silently dumping some of these similar
>> transactions. (But I've also discovered I'm not using the latest
>> version--I'm on 3.8, so I think I should upgrade it and try again.)
>>
>>
>>
>> On Fri, Dec 30, 2022 at 6:57 PM Jean L  wrote:
>>
>>> We might need a bit more info to give a useful answer. But just to be
>>> sure:
>>> - The FITID of the transactions in the OFX file are all different,
>>> right? That's an absolute requirement, not just within a single OFX
>>> file, but from ofx to ofx, the FITID is supposed to identify one and
>>> only 1 transaction. If you re-download the same transaction the FITID is
>>> supposed to be the same as the first time you downloaded it. GC uses
>>> this to know which transactions have already been matched when it looks
>>> at an imported OFX file.
>>>
>>> - Is the problem that you have similar transactions in your register
>>> (that you've entered manually) with the same amount and close dates?
>>> It's not impossible that GC is a bit confused because it finds 2 or more
>>> transactions in your register than seem to match 1 or more transactions
>>> in your OFX. In other words, GC does not have a way to figure out which
>>> OFX transaction should be matched with which transaction in your
>>> register if everything is very similar between them.
>>> I must say I've never run into this issue, so I don't know for a fact
>>> what GC does in that case.
>>>
>>> J
>>>
>>> On 12/30/2022 5:36 PM, Simon Roberts wrote:
>>> > With the same caveat about my being new to this...
>>> >
>>> > My transaction records show regular, very similar, transactions. The
>>> same
>>> > institution, identical amounts, usually close but not identical dates.
>>> >
>>> > The importer's matcher is confused by these similar transactions. It
>>> marks
>>> > them in red and refuses to do anything with them directly. I can unmark
>>> > them, and then get them to import, but there are other fields
>>> (specifically
>>> > there is a field "" in the OFX file that seems like it should
>>> > distinguish them, even if everything else is identical (I'm assuming
>>> FITID
>>> > is "Financial Transaction ID", but I could be wrong since that's just a
>>> > guess!)
>>> >
>>> > In the interest of being clear, these "conflicting" transactions are
>>> in the
>>> > *same* OFX file, it's not trying to match against something already in
>>> > place.
>>> >
>>> > Can I do anything to get this to behave more helpfully?
>>> >
>>> > Cheers,
>>> > Simon
>>> >
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>> --
>> Simon Roberts
>> (303) 249 3613
>>
>>
>
> --
> 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] Matching error in OFX import

2022-12-31 Thread Simon Roberts
Gach, yes, sorry meant to reply all, will pay attention in future,
hopefully not do that again :(

But FWIW, these transactions have different FITIDs and are in a single
import from a single file (and do not duplicate anything pre-existing).
But, I will get back when I'm not using 3.8. It's sad (but clearly nobody
here is in control of this!) that Ubuntu is packaging such an old version.

On Fri, Dec 30, 2022 at 7:08 PM Jean L  wrote:

> Don't forget to reply to the list.
>
> Bear in mind: if you import an OFX file, match its transactions to some of
> your register transactions, the matched transactions will be silently
> ignored when you re-import the same OFX. That's by design. So if you match
> everything then re-import the same OFX, you'll have nothing to match.
>
> GC uses the FITID to verify that an OFX transaction was already imported
> and matched (it compares the FITID value of the transaction in the register
> to that in the OFX file). When GC imports an OFX transaction, it copies the
> OFX FITID to the register transaction.
>
> But yes, update to a recent version as there were bugs in this mechanism
> that were recently fixed.
>
> J
> On 12/30/2022 6:03 PM, Simon Roberts wrote:
>
> Yes, different FITIDs.
>
> I'm now finding that actually silently dumping some of these similar
> transactions. (But I've also discovered I'm not using the latest
> version--I'm on 3.8, so I think I should upgrade it and try again.)
>
>
>
> On Fri, Dec 30, 2022 at 6:57 PM Jean L  wrote:
>
>> We might need a bit more info to give a useful answer. But just to be
>> sure:
>> - The FITID of the transactions in the OFX file are all different,
>> right? That's an absolute requirement, not just within a single OFX
>> file, but from ofx to ofx, the FITID is supposed to identify one and
>> only 1 transaction. If you re-download the same transaction the FITID is
>> supposed to be the same as the first time you downloaded it. GC uses
>> this to know which transactions have already been matched when it looks
>> at an imported OFX file.
>>
>> - Is the problem that you have similar transactions in your register
>> (that you've entered manually) with the same amount and close dates?
>> It's not impossible that GC is a bit confused because it finds 2 or more
>> transactions in your register than seem to match 1 or more transactions
>> in your OFX. In other words, GC does not have a way to figure out which
>> OFX transaction should be matched with which transaction in your
>> register if everything is very similar between them.
>> I must say I've never run into this issue, so I don't know for a fact
>> what GC does in that case.
>>
>> J
>>
>> On 12/30/2022 5:36 PM, Simon Roberts wrote:
>> > With the same caveat about my being new to this...
>> >
>> > My transaction records show regular, very similar, transactions. The
>> same
>> > institution, identical amounts, usually close but not identical dates.
>> >
>> > The importer's matcher is confused by these similar transactions. It
>> marks
>> > them in red and refuses to do anything with them directly. I can unmark
>> > them, and then get them to import, but there are other fields
>> (specifically
>> > there is a field "" in the OFX file that seems like it should
>> > distinguish them, even if everything else is identical (I'm assuming
>> FITID
>> > is "Financial Transaction ID", but I could be wrong since that's just a
>> > guess!)
>> >
>> > In the interest of being clear, these "conflicting" transactions are in
>> the
>> > *same* OFX file, it's not trying to match against something already in
>> > place.
>> >
>> > Can I do anything to get this to behave more helpfully?
>> >
>> > Cheers,
>> > Simon
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> 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] Config files?

2022-12-30 Thread Simon Roberts
Thanks Murugan, that's really useful. First it tells me that I'm using a
significantly old release (3.8, from the Ubuntu "built in" stuff). Better
fix that, methinks.

Are the data files I'm working on in 3.8 going to read directly into
version 4, or does that need some more deliberate action?

And in the online docs, I don't see a simple text search mechanism for the
documentation. Am I missing something? I know that often it's hard to find
things in documentation that's just organized by sections/topics if you
don't know the terminology yet.





On Fri, Dec 30, 2022 at 6:54 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> You can click on Help->About where you can see the basic file paths
>
> for more detailed  you can refer to
> https://wiki.gnucash.org/wiki/Configuration_Locations
> Configuration Locations - GnuCash
> <https://wiki.gnucash.org/wiki/Configuration_Locations>
> GnuCash stores several categories of information regarding your setup in
> several locations on your machine. In addition to your financial data file
> itself, there are; configuration settings that control how your copy of
> GnuCash looks and acts, including . custom report settings, key binding
> maps…Finally there are
> wiki.gnucash.org
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Simon Roberts <
> si...@dancingcloudservices.com>
> *Sent:* Friday, December 30, 2022 10:48 PM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] Config files?
>
> I've realized that GnuCash stores configuration information somewhere other
> than just the "account" file.
>
> Can anyone tell me where that is? (or where those places are?)
>
> Thanks!
>
> --
> 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] Config files?

2022-12-30 Thread Simon Roberts
I've realized that GnuCash stores configuration information somewhere other
than just the "account" file.

Can anyone tell me where that is? (or where those places are?)

Thanks!

-- 
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] Matching error in OFX import

2022-12-30 Thread Simon Roberts
With the same caveat about my being new to this...

My transaction records show regular, very similar, transactions. The same
institution, identical amounts, usually close but not identical dates.

The importer's matcher is confused by these similar transactions. It marks
them in red and refuses to do anything with them directly. I can unmark
them, and then get them to import, but there are other fields (specifically
there is a field "" in the OFX file that seems like it should
distinguish them, even if everything else is identical (I'm assuming FITID
is "Financial Transaction ID", but I could be wrong since that's just a
guess!)

In the interest of being clear, these "conflicting" transactions are in the
*same* OFX file, it's not trying to match against something already in
place.

Can I do anything to get this to behave more helpfully?

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] OFX import date questions

2022-12-30 Thread Simon Roberts
Thank you for the help to this point. I think I've worked out the date
issue (very embarrassing, nothing to do with GC). Now I have a bunch more
questions, but I'll ask them in dedicated threads to minimize confusion.

I did notice that the CSV version of the transaction information contains
two different date columns one called "Posting" and the other "Effective",
but in all my samples so far, they're the same. That had nothing to do with
my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any
relevance to anyone looking at this thread years from now. The OFX file
only seems to contain a single date field ("DTPOSTED").

But yeah, overwhelm induced stupidity on my part, sorry. Next question will
be a bit more real, but many thanks to everyone who was kind enough to
pitch in their ideas.


On Fri, Dec 30, 2022 at 3:19 PM David Cousens 
wrote:

> Simon,
>
> The OFX file will be the immediate position in the banks records at the
> time of
> download. What appears in a statement may be after completion of interbank
> clearances of funds and the dates in the statement may reflect when this
> occurred rather than when the transaction was first received by the bank.
> Clearnce times are generally a lot shorter with electronic clearances than
> they
> used to be can sometimes be delayed. SInce this is a disagreement between
> OFX
> records and statement both produced by the bank, they are best placed to
> explain
> what such discrepancies are and why they occur.
>
> David Cousens
>
>
> On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote:
> > Beginner/refugee from QuickBooks here (more context below if you
> > care).  I'm working in a scratch file, so I can do stupid things while
> > learning without damaging anything "important".
> >
> > I'm working with importing my bank transactions using OFX format (though
> > I've also tinkered with CSV, and am willing to use that if it
> > solves my problem).
> >
> > I imported some transactions using OFX. Several things surprised me, but
> > the one that I think needs resolving first is that the transaction dates
> do
> > not match the bank statement.
> >
> > Earlier I tried the CSV import and saw there were *two* date fields
> > (presumably difference between being received and being acted on?
> >
> > Can someone tell me what I should do to fix this? Is there a way to
> "tweek"
> > the OFX import, or do I need to use CSV? Or is this something else
> entirely
> > that's gone amiss?
> >
> > Thanks for any hints,
> > Cheers,
> > Simon
> >
> > Background in case it's relevant:
> >
> > I'm a refugee from Intuit, and very early in my learning process.
> >
> > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a
> > software person--she would have continued paying the annual ransom to
> > Intuit but I'm sick of their hostage taking. Of course this means I need
> to
> > do a decent part of the legwork for this transition.
> >
> > Of course because I'm not a bookkeeper, I don't understand the accounting
> > side of this stuff, and likely won't know how to ask/phrase the
> questions.
> >
> > Neither of us are going to be great at searching the documentation since
> it
> > seems like the terminology is different between GC and QB (and I don't
> > really know the terminology anyway)
> >
> > So, please forgive the idiot question, and if the simple answer to a
> > question is RTFM, we're very happy to do so, but likely are asking as
> we've
> > failed to find the relevant part of said references.
> >
> > Anyway, thanks for your indulgence :)
> > ___
> > 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.
>


-- 
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] OFX import date questions

2022-12-30 Thread Simon Roberts
Beginner/refugee from QuickBooks here (more context below if you
care).  I'm working in a scratch file, so I can do stupid things while
learning without damaging anything "important".

I'm working with importing my bank transactions using OFX format (though
I've also tinkered with CSV, and am willing to use that if it
solves my problem).

I imported some transactions using OFX. Several things surprised me, but
the one that I think needs resolving first is that the transaction dates do
not match the bank statement.

Earlier I tried the CSV import and saw there were *two* date fields
(presumably difference between being received and being acted on?

Can someone tell me what I should do to fix this? Is there a way to "tweek"
the OFX import, or do I need to use CSV? Or is this something else entirely
that's gone amiss?

Thanks for any hints,
Cheers,
Simon

Background in case it's relevant:

I'm a refugee from Intuit, and very early in my learning process.

I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a
software person--she would have continued paying the annual ransom to
Intuit but I'm sick of their hostage taking. Of course this means I need to
do a decent part of the legwork for this transition.

Of course because I'm not a bookkeeper, I don't understand the accounting
side of this stuff, and likely won't know how to ask/phrase the questions.

Neither of us are going to be great at searching the documentation since it
seems like the terminology is different between GC and QB (and I don't
really know the terminology anyway)

So, please forgive the idiot question, and if the simple answer to a
question is RTFM, we're very happy to do so, but likely are asking as we've
failed to find the relevant part of said references.

Anyway, thanks for your indulgence :)
___
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

2022-12-30 Thread Simon Roberts
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.