Re: [GNC] gnucash-user Digest, Vol 255, Issue 13

2024-06-12 Thread Mark at Lorimark

oh... the memories!

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/12/24 15:56, Bruce Irving wrote:


I used to know 6502 Machine language, dBase III as
well as some Lotus Macros and  Excel VBA.

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


Re: [GNC] Missing Register Right Click Options

2024-06-11 Thread Mark at Lorimark

gnucash 5.5, linux, flatpak,

my register-right-click still works

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/11/24 14:42, j a wrote:

Hello,

I recently upgraded GnuCash from 4.13 to 5.6, and immediately noticed that
the options presented when performing right click options in a register
have been removed.

Please advise of how to implement options that were previously accessible
by right click in a register, including the following:
- sort register entries;
- filter register entries;
- jump to a different register;
- split a transaction
- schedule a transaction
___
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] Can I set an option to stop auto-fill ?

2024-06-03 Thread Mark at Lorimark

I don't see an option to turn off the auto-complete.

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 14:44, fromvendor wrote:

Hi y'all!

I am finding the auto-complete function to be more troublesome than not and I'd 
like a way to turn it off.  I don't mind it overmuch filling in the account so 
much as the amount and the splits.  I'd rather have none of it that have the 
confustion (that's confusion and frustration in a word) caused by the auto-fill.

I, BTW, am loving the software.  I'm sure the setting is in there somewhere, 
I'm just not finding it.


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


Re: [GNC] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark

Yes, pretty basic simple small business file, checking, savings, CD's...

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 07:17, Derek Atkins wrote:

I presume the accounts have the same currency?
I honestly do not recall what algorithm is used to choose options there.

-derek


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


Re: [GNC] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark
Yea, I tried that, thinking the same.  It didn't work.  One of the 
assets it presented was in a different tree.  I added a 'test' account 
there and it didn't show, then moved that test account to the same 
branch as the account I was trying to delete, still no joy.


~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 06:57, Derek Atkins wrote:

Hi,

I admit I have not used the function, but my recollection is that it only
lets you roll it up into a parent account -- so if you want to choose a
specific account you need to re-parent the account-to-be-deleted under the
account you want to move the transactions into, and then when you delete
it you should be able to choose the new parent.

I'll note that I have not tried to verify this belief, so YMMV.

-derek

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


Re: [GNC] Delete acct + move txns - can't specify acct

2024-06-03 Thread Mark at Lorimark

I'm curious what your account tree looks like.

I just tried to delete an account, and it only shows a couple of my 
other asset accounts.  I created a 'test' account, and even that didn't 
show up... interesting.


Never used that before, not sure what's expected of it.

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/2/24 17:21, Chris Skudder wrote:

I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db).

I tried to delete a closed checking acct, and move the transactions to 
another checking acct.


When in the "Delete Acct" dialog box, I get the button to move 
transactions to another acct, and GnuCash offers another asset acct - 
but not the one I want.


I cannot change this "move to" acct - I can't type the name of the acct 
that I want into the box. I can type characters, but whatever I type, it 
only offers the one single acct which it first offers. The dropdown also 
offers Imbalance + Orphan.


I looked here -
https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html
... didn't find any mention of how to specify the "move-to" acct.

Any ideas? Thanks in advance.


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

2024-05-23 Thread Mark at Lorimark

Hi Joe,

I'm likely stepping way out of my reach here, but,

Gnucash will not import from IIF, but you might have success if you can 
convert your IIF file to a CSV file.  Then you can import from that to 
GnuCash like you would if you had fetched a CSV file from your bank.


The 'transaction importer' is somewhat smart too that it can remember 
your associations...


That's me shooting from the hip, though.  I left quickbooks a few years 
ago, and while the GnuCash transition was a bit of a brain bender at 
times, what a reward!  Never looking back!  Trying to web-enable gnucash 
even, love the software!


When I left quickbooks I did not pull anything across, so I'm no help 
there.  As far as my transactions, I was able to import a bunch from my 
bank accounts, and the rest I just hand keyed, given it's just my tiny 
business, and plus that exercise helped me to become super familiar with 
the GnuCash interface, and how I wanted to set up accounts and all that.


I loaded my historical data back only a few years, to 2020, just so I 
could compare the most recent years... but, you can start from any date 
that makes sense to you.


~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 14:03, Joe Padavic wrote:

I hadn't imported any Quickbook file to GNUCASH, but the "Welcome to
GNUCASH" (splash page) wasn't showing up so I didn't know when to go to
import the files. I eventually uninstalled the app and deleted the registry
entry and the Welcome page is being displayed.
[image: image.png]

My intentions are to convert personal checking/credit card accounts from
Quicken and business data from Quickbooks. Having all transactions make
Year End Tax Reporting for the business easier. Any comparisons from
previous to current year would be helpful. This would hold true for
budgeting purposes for personal accounts, also.

So the question remains - can I import the IIF files from Quickbooks and
what files can be imported from Quicken?
The first time I import my bank transactions, both business and personal,
what date would these transactions start with?



___
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] GnuCash works on clean install of Ubuntu 24.04

2024-05-23 Thread Mark at Lorimark

That's my understanding.

~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 13:24, John Ralls wrote:

Good that it works, I guess. Is the cause of the problem the broken Nvidia 
drivers?

Regards,
John Ralls



___
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] GnuCash works on clean install of Ubuntu 24.04

2024-05-23 Thread Mark at Lorimark

Hey, run gnucash with this to get it to show reports;


WEBKIT_DISABLE_COMPOSITING_MODE=1 gnucash


~mark petryk
~w:http://www.lorimarksolutions.com

On 5/23/24 11:25, Bruce Griffis wrote:

I saw the message on GnuCash not working on an upgrade to Ubuntu 24.04.
Just wanted to say that it works on a fresh install. I wanted to go 24.04,
so did a fresh install than restored /home from backups. While that works,
if you have a lot of customized packages installed instead of just things
from the Ubuntu Software store or snaps - it can get hard to maintain. For
me, Rocksmith 2014 under Steam just doesn't work on 24.04 - so there are
broken things. But GnuCash was pretty cool (other than reports not
displaying).


___
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] Easier way to print to PDF

2024-05-20 Thread Mark at Lorimark
Keep two Folder explorers open, one where it prints to, and one where 
you want to move the file to.  Once it's printed, drag the file to the 
preferred location.


Yea, I don't like it either.

~mark petryk
~w:http://www.lorimarksolutions.com

On 5/19/24 18:33, Daffy Duck wrote:

Linux.  The issue is, every time I try to print to PDF, it starts at
home directory, which takes forever to get back to where I was printing
to.


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

2024-05-13 Thread Mark at Lorimark

Hi Scott,

I am running a flatpak version and so launching through that.  I added a 
'shortcut' to my start-menu so that I could launch the program.  The 
shortcut uses a script file at ~/bin/gnuchash.sh


Here is the script file contents;

11:03 AM mark@nixhp:~/bin $ cat gnucash.sh 
WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash


That resolved my blank-report issue without mucking with the nvidia driver.

~mark petryk
~w:http://www.lorimarksolutions.com

On 5/13/24 08:44, Scott Ellsworth wrote:

Dear all,

I had a problem of reports being blank after switching from Ubuntu to Linux 
Mint (to GC v5.6 thru Flatpak). I was able to see reports after switching the 
Nvidia driver from version 535 to version 470. I found this fix online, and it 
worked. But starting a few weeks ago reports were suddenly all blank again. In 
the meantime I understood that I can print reports to PDF in order to see them, 
but this is pretty cumbersome, especially because GnuCash's interface for 
saving them does not know about the folders I've bookmarked in Nemo, and 
doesn't remember where I saved a PDF last. Today I tried switching to Invidia’s 
driver version 545 (later than the recommended version, so apparently beta), 
and it failed to install. So I switched the Nvidia driver from Performance Mode 
to On-Demand Mode. This is working for now, but I don't prefer it because video 
movements on my screens are choppy this way.

Is there any plan to resolve the blank-reports issue in an upcoming version? Or 
is there another fix or workaround that could help me?

Be Well,
  
Scott

<<<< Scott Ellsworth || +1 (775) 386-2519 >>>>
___
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] Split Transactions Version 5.6

2024-04-10 Thread Mark at Lorimark

Hi Kevin,

(not an expert)

When you open the 'checking' register, and put in a transaction, you 
assign that transaction to another account.


Example:
  1. open 'checking'
  2. enter an item
  3. set the "Transfer" column to the proper account
a. electricity
b. phone
c. school taxes

You NOW have a "split".   The "checking" account is on one side, the 
"other" account is on the other side.  That's a split!


If you want to make a 'multi-split' then there's a button in the 
register that you can hit to show the 'splits'.  When this view is 
showing, then you can take that one check and assign it to multiple 
other accounts to split it in multiple ways.


HTH

~mark petryk
~w:http://www.lorimarksolutions.com

On 4/10/24 14:26, Kevin Wilcoxon via gnucash-user wrote:
Newbie here. You're a very sophisticated group! I believe I have 
mastered all the tasks I need in GnuCash 5.6 except creating split 
transactions. I've tried searching the internet and following 
instructions without sucess. Would some wise user please provide simple 
and workable instructions to enter these split transactions, or point me 
to where I can find them.


Thank you very much
Kevin Wilcoxon

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

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


[GNC] Accounts Receivable: How do I handle a Tip?

2024-04-09 Thread Mark via gnucash-user
Apr 9, 2024 08:45:34 Eric H. Bowen via gnucash-user :

> I'm very leery about hand editing anything to do with the AP and AR systems; 
> there's a caution against that in the documentation. And the invoice is 
> already posted, I'd prefer not to unpost and edit it.

I believe you can hand edit the splits that aren't to AR or AP. You could enter 
the payment of the invoice and then edit the transaction to add a split for the 
tip and increase whatever account the money is going to, leaving the AR split 
alone. I do similar to account for fees when someone uses PayPal to pay an 
invoice.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Accounts Receivable: How do I handle a Tip?

2024-04-09 Thread Mark at Lorimark
I 'unpost' the invoices and edit for a new line containing 'tip' and 
post that to a different income account (cuz I like to count my tips) 
re-post the invoice, and pay it.


It bothered me too until I asked around and then I got over it.

I love gnucash because it allows me to 'fix' or 'redo' or 'delete it 
all' without restriction.  It's my data!


~mark petryk
~w:http://www.lorimarksolutions.com

On 4/9/24 08:44, Eric H. Bowen via gnucash-user wrote:
I just completed a job for a satisfied customer. Very satisfied; he 
voluntarily paid $50 over and above the invoiced amount and told me to 
keep it as a tip. Now, how do I account for that?


I'm very leery about hand editing anything to do with the AP and AR 
systems; there's a caution against that in the documentation. And the 
invoice is already posted, I'd prefer not to unpost and edit it. When I 
post the payment received, AP shows it as a "pre-payment," but I'm not 
sure of the proper way to redirect that to an income account.


Suggestions?

___
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] Request for help with libgnucash/engine

2024-03-25 Thread Mark at Lorimark

Thank you, John.

~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com

On 3/23/24 12:34, john wrote:



On Mar 23, 2024, at 17:16, Mark at Lorimark 
 wrote:


Hi Guys,

I've started up a project to create a web-interface for GnuCash.  Been 
tinkering with it for a while now.


I was hoping to be able to reach out to the developers to ask for some 
help with regards to getting connected to gnucash via the libgnucash 
engine.


I have been somewhat successful getting the engine open, but it feels 
like I'm just swimming upstream, guessing about the api calls.



https://gnucashew.lorimarksolutions.com/demo
https://gnucashew.lorimarksolutions.com/dox/html/SessionGnuCash_8cpp_source.html


The demo I have running is just making direct sql calls, but I really 
want the engine.


I know it's a tall request to coldly ask for developer support this 
way, but I'm asking none-the-less.  I just need a little nudge to get 
over this api hump and I'll be trucking on my way!!!


Thank you in advance


I'll point you at the API documentation: 
https://code.gnucash.org/docs/STABLE 
<https://code.gnucash.org/docs/STABLE>. It's not complete, but it might 
help. You're right that you need the engine, there's no business logic 
in the database, not even referential integrity.


You should be aware that GnuCash is still far from clean in separating 
the GUI from the computation, so while you'll need to learn the engine 
you'll also need to study the rest of the program too. You can ask 
specific questions about particular function, but I don't have time to 
review your code or write more documentation for you. I can't speak for 
the other devs on that regard. Maybe one of them has more time.


Another thing to note: There is *NO* stability guarantee with any part 
of GnuCAash. Things you learned last year may change next year.


Regards & Good Luck,
John Ralls


___
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] Request for help with libgnucash/engine

2024-03-25 Thread Mark at Lorimark

Thank you, Geoff.

~mark petryk
~w:http://www.lorimarksolutions.com

On 3/23/24 20:04, Geoff wrote:

This may (or may not) be useful:

https://github.com/sdementen/piecash

Regards

Geoff
=

On 24/03/2024 3:16 am, Mark at Lorimark wrote:

Hi Guys,

I've started up a project to create a web-interface for GnuCash.  Been 
tinkering with it for a while now.


I was hoping to be able to reach out to the developers to ask for some 
help with regards to getting connected to gnucash via the libgnucash 
engine.


I have been somewhat successful getting the engine open, but it feels 
like I'm just swimming upstream, guessing about the api calls.



https://gnucashew.lorimarksolutions.com/demo
https://gnucashew.lorimarksolutions.com/dox/html/SessionGnuCash_8cpp_source.html


The demo I have running is just making direct sql calls, but I really 
want the engine.


I know it's a tall request to coldly ask for developer support this 
way, but I'm asking none-the-less.  I just need a little nudge to get 
over this api hump and I'll be trucking on my way!!!


Thank you in advance


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


[GNC] Request for help with libgnucash/engine

2024-03-23 Thread Mark at Lorimark

Hi Guys,

I've started up a project to create a web-interface for GnuCash.  Been 
tinkering with it for a while now.


I was hoping to be able to reach out to the developers to ask for some 
help with regards to getting connected to gnucash via the libgnucash engine.


I have been somewhat successful getting the engine open, but it feels 
like I'm just swimming upstream, guessing about the api calls.



https://gnucashew.lorimarksolutions.com/demo
https://gnucashew.lorimarksolutions.com/dox/html/SessionGnuCash_8cpp_source.html


The demo I have running is just making direct sql calls, but I really 
want the engine.


I know it's a tall request to coldly ask for developer support this way, 
but I'm asking none-the-less.  I just need a little nudge to get over 
this api hump and I'll be trucking on my way!!!


Thank you in advance

--
~mark
~w:http://www.lorimarksolutions.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Bill total does not match real total

2024-03-10 Thread Mark via gnucash-user
Mar 10, 2024 11:01:45 Michael or Penny Novack :

> AFAIK no team in the open software world is trying to organize a "business 
> system" project.

There's Odoo ( https://www.odoo.com/ ). I haven't used it and don't know much 
about it. (I think someone on this list mentioned it awhile back.)
___
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] Import CSV settings location

2024-02-07 Thread Mark at Lorimark

Hi Aryeh

Can you click on Help->About and does it show the various paths in use?

~mark petryk
~w:http://www.lorimarksolutions.com

On 2/7/24 08:57, Aryeh Gielchinsky wrote:

Hello,

I'm a new user.

I saved some CSV import settings on computer A, synced my
account/transaction file to computer B, but I'm unable to use the saved
import CSV settings on Computer B. Are these import CSV settings saved
somewhere on each computer separately? I've checked
$HOME/.var/app/org.gnucash.GnuCash but I didn't successfully find the
settings for importing CSVs. Is there a way to save these import settings
with my account/transactions file?

I'm on Ubuntu 22.04 (Linux) using GNUcash 5.5 via Flatpak.

Thanks
Aryeh
___
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] Advanced portfolio report picking up wrong price

2024-02-03 Thread Mark at Lorimark

your screenshot didn't come through.

~mark

On 2/3/24 11:16, Dan O'Brien wrote:

I can’t make heads or tails of scheme code, so I’m not sure where to even look 
for the issue here.

I’m using the Advanced Portfolio report and want to include a GnuCash account 
for certificates of deposit. The account is set up as an Asset and the 
Security/Currency is set to USD.

When I run the Advanced Portfolio report, however, instead of using a price of 
$1.00 for USD, it’s picking up the price of another security. I had some cruft 
in the price database related to an account that I incorrectly set up in 
dollars. Advanced Portfolio was picking up the price from that item until I 
cleaned it up and how it’s picking up the last price in the database from 
another stock (I deleted the last price entry for that security and the price 
shown on the report changed when I refreshed it).

I’ve attached a screen shot of the report and the price entry that GnuCash 
shows when I click the value in the Price column.

The CD account isn’t going to significantly affect the report, so I could just 
deselect the account when I generate the report, but I like the way Advanced 
Portfolio calculates the rate of return and gives me the overall return for all 
the CDs that were put into the account (I use one GnuCash account for multiple 
CDs). I’m concerned I may have done something to bork up the price or 
securities tables, though.

Any thoughts on this? Is there somewhere I should look in the SQLite database 
for a problem?
___
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] Maddening!!!!!!!!

2024-01-11 Thread Mark at Lorimark

Going out on a limb...

These folks have a free virus scanner;


https://www.eset.com/us/home/online-scanner/


Based on how you described the symptom, I'd start to be a little curious 
about that copy of Windows.


~w:http://www.lorimarksolutions.com

On 1/11/24 15:29, Joseph Keithley wrote:
I have had similar issues.  My only "solution" was to hit the "Save" 
button after any action or entry.  Gnucash can then crash as it always 
does and I will only have lost at most one transaction.  I have the 
autosave feature enabled for every 5 minutes.  The constant crashing 
seems to be related to my Windows 10 installation.  Windows will 
initiate some background process which I notice becuase the mouse pauses 
for a microsecond and the screen will briefly flash as if a messsage box 
were trying to pop up but it goes away so quickly I can't really figure 
out what is going on.  Once this happens, if Gnucash is open I can bet 
on a crash in short order.  There will be no notification, Gnucash just 
quits and any unsaved work is lost.  If I reboot Wndows then Gnucash 
doesn't crash until the next time Windows has its little hiccup.  The 
hiccup happens at most once a month but it is still irritating to lose 
my work.  The hiccup doesn't seem to bother any other running programs 
to include Quicken 2016, Excel, and Comodo A/V and Firewall.




On Thu, Jan 11, 2024 at 3:33 PM Mark at Lorimark 
mailto:m...@lorimarksolutions.com>> wrote:


You can post an image as an attachment to your email, it will be
available to the group here.

~w:http://www.lorimarksolutions.com <http://www.lorimarksolutions.com>

On 1/11/24 13:00, Jack Slater wrote:
 > Is there a way I post the image?
 >
 >
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<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.



--
iii

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

2024-01-11 Thread Mark at Lorimark
You can post an image as an attachment to your email, it will be 
available to the group here.


~w:http://www.lorimarksolutions.com

On 1/11/24 13:00, Jack Slater wrote:

Is there a way I post the image?



___
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] Windows Customer Report Crash

2023-12-30 Thread Mark at Lorimark

Hi,

I have a Windows 5.5 installed and ran in to a crash on opening customer 
report.  I then created a new data file (sql) and created a customer, 
created an AR account, created an invoice for said customer, and for one 
thing is said it could not write back to the database when trying to 
post the invoice, but when trying to open a specific 'customer report' 
from the 'customers list' screen, it crashes.


I would like to continue testing so that I can prepare a comprehensive 
report, or/and fix it.


Where I find the logs or crashlogs for windows.

--
~mark petryk
~w:http://www.lorimarksolutions.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GnuCash getting worse?

2023-12-29 Thread Mark at Lorimark

yes... losing... my speling sucks!

~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com

On 12/29/23 14:16, R Losey wrote:

Assuming you meant "losing", I completely agree with you.


On Fri, Dec 29, 2023 at 12:58 PM Mark at Lorimark 
mailto:m...@lorimarksolutions.com>> wrote:


We are loosing projects like this.

I hope... i hope... not this one.

~mark petryk
~w:http://www.lorimarksolutions.com <http://www.lorimarksolutions.com>

On 12/27/23 22:33, R Losey wrote:
 > Let me start off by trying to avoid hateful responses...
 >
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
_
Richard Losey
rlo...@gmail.com <mailto:rlo...@gmail.com>
Micah 6:8

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


Re: [GNC] GnuCash getting worse?

2023-12-29 Thread Mark at Lorimark

We are loosing projects like this.

I hope... i hope... not this one.

~mark petryk
~w:http://www.lorimarksolutions.com

On 12/27/23 22:33, R Losey wrote:

Let me start off by trying to avoid hateful responses...


___
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] gnucash crashes on vendor or customer searches

2023-12-28 Thread Mark via gnucash-user
Dec 28, 2023 14:28:59 Eric Hammond :

> I would very much appreciate if you would show somehow how much of this email 
> you would like included in my replies?

Only the part you're replying to.
___
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] IRC access

2023-12-19 Thread Mark at Lorimark

When I try to 'join' #gnucash on libera.chat I get;


Cannot join #gnucash (Channel is invite only).



--
~mark petryk
~w:http://www.lorimarksolutions.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Account Colors

2023-12-18 Thread Mark at Lorimark

never mind!  I have to turn-on an preference.

~mark petryk
~w:http://www.lorimarksolutions.com

On 12/18/23 12:26, Mark at Lorimark wrote:

I don't seem to be able to set 'account colour'.

I've had them set, and in version 5.5, freshly compiled, Linux Mint 22, 
the colours do not show, and editing them causes no change.



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

2023-12-18 Thread Mark at Lorimark

I don't seem to be able to set 'account colour'.

I've had them set, and in version 5.5, freshly compiled, Linux Mint 22, 
the colours do not show, and editing them causes no change.


--
~mark petryk
~w:http://www.lorimarksolutions.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] ANNOUNCE: GnuCash 5.5 Released

2023-12-18 Thread Mark at Lorimark



I've just fetched and built the latest, so far no trouble, I'll keep 
testing;



Version: 5.5
Build ID: git 5.5+(2023-12-16)
Finance::Quote: 1.51

~mark petryk
~w:http://www.lorimarksolutions.com

On 12/17/23 15:45, John Ralls wrote:

The GnuCash development team announces GnuCash 5.5, the sixth release in the 
stable 5.x series.

Between 5.4 and 5.5, the following bugfixes were accomplished:


___
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] Nice to Have?

2023-12-14 Thread Mark at Lorimark

Did you close the program and re-open it after resetting the option?

~mark petryk
~w:http://www.lorimarksolutions.com

On 12/14/23 14:43, Adrien Monteleone wrote:

This is weird.

I managed to trigger this complete listing, but now I can't fix it back.

At first, my Since Last Run (SLR) showed only a list of reminders and 
created SX.


After playing with the option to remind in advance, unticking it removed 
that SX as expected as it wasn't yet time to fire.


But setting it back, and re-running the SLR, now all Enabled SX are 
listed (below the Reminders unlike Grace's screenshot) and I can't seem 
to make them go away and get back to the original behavior.


Regards,
Adrien


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


Re: [GNC] How to delete unposted invoice?

2023-12-13 Thread Mark at Lorimark

You can't delete invoices.  You can re-use them.

~mark petryk
~w:http://www.lorimarksolutions.com

On 12/13/23 13:46, Eric Chapman wrote:
I accidentally put in an invoice dated 01/01/2023 for a customer. There 
are no amounts in it (i.e., it's zero). I can't figure out how to delete 
it.


Attached is a screenshot of the invoice. I've tried "Delete" and 
"Cancel", but don't know what else to try.


Thank you!


___
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] GNU Cash not performing math functions correctly on entry [SOLVED]

2023-12-01 Thread Mark via gnucash-user
Dec 1, 2023 13:37:32 Adrien Monteleone :

> It seems the code for auto-decimal is occurring with each numerical entry, 
> rather than the final result.

To me it seems the least surprising way for auto-decimal to work would be if it 
only applied when you enter an amount directly. I wouldn't expect it to apply 
to the result of a calculation. (Issues like this is why I don't use 
auto-decimal. I don't like decimals appearing where I didn't put them.)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Mark via gnucash-user
Nov 22, 2023 10:14:49 Glenn Fowler :

> @binding-set Switch-Page
> {
>   bind "F2" { "change-current-page" (1) };
>   bind "F3" { "change-current-page" (-1) };
> }
>
> entry
> {
> -gtk-key-bindings: SwitchPage;
> }
>
> but it doesn't work. The syntax is correct as I can do other keybindings
> for clipboard copy, clipboard paste, move the cursor, etc.

I don't know anything about it, but I see there's Switch-Page one place and 
SwitchPage (without the hyphen) another. Typo?
___
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 set accounts to read-only?

2023-11-21 Thread Mark at Lorimark
You can set an account to 'placeholder' after you have transactions in 
it.  This will prevent you from double-click in the accounts view to 
open it, you'll have to right-click to view it's contents.


But, it will also remove it from your pick-lists in the registries.

~mark

On 11/21/23 12:46, David Kirkby wrote:

I have a few accounts that I will use very occasionally, but not normally.
Can I set them to read-only, so I just mark them writable when I need to?
This will avoid transactions accidentally getting put in there. I
discovered something in the Travel account the other day that should not
have been there. I will probably use that account once per year, so it
makes sense to stop things accidentally going into them.

I  believe setting them to placeholder accounts will achieve the same
effect, but I'm not sure.


___
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] Hidden and duplicated accounts.

2023-11-21 Thread Mark at Lorimark

Look for;

View-> Filter by-> Other

~mark
On 11/21/23 12:37, David Kirkby wrote:

I have a couple of questions related to accounts, and my ability to see
them and delete them.

1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD)
and bank fees.

[image: image.png]


___
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] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Mark at Lorimark
Ok, to get familiar, I went to 'edit a payment' (did not know that was 
there) and I got a pop-up payment editor with a message box reading;


"You have no valid 'post to' accounts.  Please create an account of type 
'' (double quotes with nothing in them)


(see attached)

~mark___
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] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Mark at Lorimark

Thank you!

~mark

___
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] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Mark at Lorimark

I'm curious what causes register entries to go read-only?

I have an "income" account, where I post invoices.  Some of the entries 
there are editable, and some are not.  I'm wondering what causes these 
entries to be read-only or read-write?


The ones that are read-write seem to be entries that I made manually... 
to 'add bonus payments' to invoices - like adding a 'tip' to a bill. The 
invoice is $100 and the 'bonus payment' is $20, so I went back and 
"somehow I guess" added the additional $20.  Today, I just 'unpost' the 
invoice and add the necessary lines to change the value, re-post it, and 
then pay it (not sure if that's the 'right' way).


The ones that are read-only seem to be entries that came directly from 
the posted invoice.


So, I'm wondering what is controlling the editable-status of those entries?

~mark


___
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] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Mark at Lorimark

bah!  sorry... didn't mean this to be inside this thread!

~mark
___
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] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Mark at Lorimark

I'm curious what causes register entries to go read-only?

I have an "income" account, where I post invoices.  Some of the entries 
there are editable, and some are not.  I'm wondering what causes these 
entries to be read-only or read-write?


The ones that are read-write seem to be entries that I made manually... 
to 'add bonus payments' to invoices - like adding a 'tip' to a bill. 
The invoice is $100 and the 'bonus payment' is $20, so I went back and 
"somehow I guess" added the additional $20.  Today, I just 'unpost' the 
invoice and add the necessary lines to change the value, re-post it, and 
then pay it (not sure if that's the 'right' way).


The ones that are read-only seem to be entries that came directly from 
the posted invoice.


So, I'm wondering what is controlling the editable-status of those entries?

~mark

___
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, copy and paste to fix mistakes?

2023-11-19 Thread Mark via gnucash-user
Nov 19, 2023 03:18:25 Wu Ming via gnucash-user :

> With a text file it is easy to diff and find what changed and by who. And 
> merge or roll back version. With a database is not. Data model is likely 
> relational, db file is binary so it requires another tool to interact with, 
> backup up as well and concurrent use requires checks and locks. I have read 
> GNU Cash uses SQLlite.

You could use the default XML if you want to diff different versions.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Delete, copy and paste to fix mistakes?

2023-11-19 Thread Mark at Lorimark

Gnucash can;

1. add/change/delete freely
2. works with sqlite, can't really do multi-user there
3. works with postgres/mysql (multi-user capable)



~mark
On 11/18/23 21:08, Wu Ming via gnucash-user wrote:

Hello,

I am not an accountant. Nevertheless was recently asked to administer a family 
micro business.

With few tens of customers and a handful of transactions a year for each, 
volume doesn’t seem large. I can possibly manage with a spreadsheet.

The newly hired, first employee is an unknown. There’s no transactions history 
to look at.

One concern is the learning process. On a text document or spreadsheet I am 
used to fix mistakes by deleting what is wrong. And start over with ample copy 
and paste to reuse. On a spreadsheet also everything is, mostly, under sight. I 
can literally use the zoom in and out function.

I have the idea of accounting books being this sacred repository carved in 
stone. Where only adding transactions is allowed. What is the reality for who 
uses GNU Cash?

Another concern is of reproducibility. With a text file it is easy to diff and 
find what changed and by who. And merge or roll back version. With a database 
is not. Data model is likely relational, db file is binary so it requires 
another tool to interact with, backup up as well and concurrent use requires 
checks and locks. I have read GNU Cash uses SQLlite. How do you deal with 
versioning / backups and uncoordinated, albeit rare, access from few users?

On the subject I was also toying with the idea to implement something with GNU 
Recutils. Relational, plain text file based data store. But I don’t think have 
the skills or time for it.

I helped at developing web applications for medium sized businesses. Have some 
experience of databases and UNIX. Not with accounting on a shoestring though.

Thanks for sharing.
___
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] budget reports 'YTD' vs 'use accumulated amounts'

2023-11-17 Thread Mark Penner via gnucash-user
On Friday, November 17, 2023 1:53:38 PM CST larry johnston wrote:
> I got as far as upgrading to GC 4.14 and was planning to use the Use
> Accumulated Amounts report but I could not find it. Do I have to upgrade to
> ver 5 or am I not looking in the correct place?

I don't know where you've looked, but in the Budget Report options, on the 
General tab, there is a checkbox labelled 'Use accumulated amounts'. Is that 
what you're looking for? When checked the accumulated amount budgeted over all 
periods up to the that period is shown. When unchecked only the amount 
budgeted for that period is shown.


___
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 it safe to change description of reconciled translation?

2023-11-14 Thread Mark at Lorimark

Make a back-up of your data and test it.

You can edit notes and memos and it won't change the reconciliation 
status (when I tested just now).


~mark

On 11/14/23 07:12, David Kirkby wrote:

I have a reconciled transaction in my bank account, but the description is
vague as to what it is. Can I change that safely - I don't need to change
the amount.


___
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] Old book not opening

2023-11-12 Thread Mark Penner via gnucash-user
On Sunday, November 12, 2023 7:17:21 AM CST Phil Reynolds wrote:
> "No suitable backend was found"

If it is a SQLite file, you need to have `libdbd-sqlite3` installed.



___
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] reports does not work

2023-11-05 Thread Mark at Lorimark

My command line (launcher) reads like this;


/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash 
--file-forwarding org.gnucash.GnuCash @@ %f @@


(Mint 20)

~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com

On 11/5/23 03:02, Elmar wrote:

I tried this, and I get -

Command 'gnucash' not found, but can be installed with:
sudo apt install gnucash

My gnucash is flatpak (Build ID: Flathub 5.4.1), so that is why I'd 
guess.  How should I modify the command line? thanks


- Elmar

On 10/31/23 06:29, gnucash-user-requ...@gnucash.org wrote:

Message: 11
Date: Tue, 31 Oct 2023 11:29:42 +0100
From: Sylvain M 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Gnucash 5.4 - reports does not work
Message-ID: <76bf3109-1f86-4bd9-8b6e-68ee531b1...@free.fr>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hello, I have found a workaround : launching gnucash from the terminal
with this command :

export WEBKIT_DISABLE_DMABUF_RENDERER=1; gnucash


It's ok,

Thank you for your help,

Sylvain





___
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] All Saved Reports Return Empty

2023-11-01 Thread Mark at Lorimark

I have found that I can 'print to pdf' and get the same result.

~q:tap out!  it's a holiday!

On 11/1/23 12:23, Robert Stocker wrote:

This is not a fix, but I found a workaround that gets me where I need to be
without modifying environment variables or tinkering with drivers, neither
of which are in my comfort zone:

Since the problem is not with *creating* the report but with *displaying*
it on the screen, after I run my report, I choose the Export option, save
the file to my desktop, then drag that file onto a blank browser tab.

Maybe this will help some others afflicted by this upstream issue.


___
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] I need basic help

2023-10-24 Thread Mark at Lorimark

two thumbs up!

On 10/24/23 16:35, Liz wrote:

On Sat, 21 Oct 2023 09:12:57 -0700
"Stan Brown (using GC 4.14)"  wrote:


It strikes me that you're trying to use GnuCash without first reading
the documentation. That's like trying to run before you can walk.
Others have already made the suggestion, but maybe you missed their
messages.


People learn in different ways.
So Edwin learns by doing and asking when reaching a difficulty.


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.

___
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] Bravo, Adrien, well explained! [was: Re: I need basic help]

2023-10-22 Thread Mark at Lorimark
Geez, I scraped it and put it in my database and  called it "Accounting 
Principles Explained".


Thank you Adrien!

On 10/22/23 15:23, Jim DeLaHunt wrote:

Bravo, Adrien!

You weren't writing this message for me, but you happened to write the 
explanation of "debit" and "credit" which I found very clear. I realise 
that this won't be the ideal explanation for everyone, but it was for me.



___
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] I need basic help

2023-10-20 Thread Mark via gnucash-user
Oct 20, 2023 09:06:46 Michael or Penny Novack :

> That might not be of much help (understanding the terms "debit" and "credit")
>
> History might, …


My point was that you don't *have* to learn all that before GnuCash will be 
useful to you. The history *is* helpful to understand the terms fully, but to 
start using GnuCash, you can start with learning how to enter where the money 
comes from and where it goes, and learn more as you need it.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] I need basic help

2023-10-20 Thread Mark via gnucash-user
Oct 20, 2023 00:03:40 Edwin Booth via gnucash-user :

> I need to wrap my head around the whole “debit/credit” concept.

One thing that helps me keep it straight is that money flows from credit to 
debit. Credit the account that money is coming from, debit the account that 
money is going to. There is more to consider of course, like whether an account 
usually has a credit or debit balance, but you don't have to learn everything 
at once.
___
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 of accounts is not permanent

2023-09-28 Thread Mark Truelove
Hi, I just wanted to say wow, Gnucash has never suggested today as the
reconciliation date for me.  It is typically 30 days/a month after the last
reconciled date, which I then need to adjust to the statement date about
half the time (if it's a day or two off).  I can't remember it ever not
being that way.  Just an observation, not really relevant to my problem.

On Wed, Sep 27, 2023 at 8:20 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Good catch. But that would imply some serious mass editing on the part
> of the OP to clear the reconcile flag. (and most likely dimissing the
> warning during those edits)
>
> Neither is out of the question, but either or both would be rare for the
> OP to not remember doing so.
>
> Regards,
> Adrien
>
> On 9/27/23 3:53 PM, John Layman via gnucash-user wrote:
> > I can assure you that GnuCash reconciliations 'stick'.  I very rarely
> encounter a discrepancy in the opening balance of a bank or credit card
> account.  When I do, there is always a data-related explanation to account
> for it.  It is not related to a software bug or quirk.  Any transaction
> mistakenly backdated or inadvertently deleted may throw those balance
> figures off, but it's your error, not the software.  The software does not
> 'lock' reconciled accounts such that you are prevented from making the sort
> of inadvertent goof that inserts or deletes a transaction prior to the date
> of the previous reconciliation.
>
> ___
> 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] Reconciliation of accounts is not permanent

2023-09-27 Thread Mark Truelove
Hi David, long in the past I probably reconciled multiple accounts in one
session without thinking about it, but after the first incident I started
saving after I reconcile each statement.  This is the third time this has
occurred over about 5 years, prompting me to reach out about it instead of
just catching up all the lost reconciliations as I did in the past.

Consider that while I'm reconciling without issue across several accounts
each month (or maybe up to three, admittedly, for inactive accounts), that
the glitch when it appears takes me back several months or a year, over
which I definitely did not skip saving my activities. I also handle basic
activities (paying bills) twice a month, saving of course as I go.  My
ledger is currently up to date with no lost transactions, it's only the
reconciliation of those accounts that has been forgotten.

Besides the main credit card account I mentioned earlier, I have another
whose recommended reconciliation date fell back to 8/18/2021.  I'm holding
off on new activity for now for the sake of this conversation.

I'll take this to the next level and open a ticket to see if it goes
anywhere.

Thanks.

On Wed, Sep 27, 2023 at 1:27 PM David Carlson 
wrote:

> Mark,
>
> From this side of the Internet it almost appears that you are forgetting
> to save the data file after reconciling, but always remembering to save
> other times, which is not very likely.
>
> Have you tried breaking down your procedure and inserting cross-checks?
>
> ie, just before starting a reconciliation, save the file, then reconcile
> one month, save the file, review the reconcile box of the freshly
> reconciled transactions to verify that they are still reconciled on the
> correct reconcile date, save again, rinse and repeat as needed?
>
> I just tried the reconciliation report for the first time and found that
> it shows mountains of information about reconciliation status down to split
> details when they exist, so that may help you too.
>
> If, as I suspect, you do indeed discover that some reconciliations are not
> being properly recorded in your file, please both let us know here and also
> file a bug report.
>
> On Wed, Sep 27, 2023, 10:49 AM Mark Truelove  wrote:
>
>> Hi again. Besides my tendency to be details-specific (given my
>> professional
>> background), I also had some college level accounting and understand
>> double-entry, reconciliation, and the basics.  No, I am not an accountant,
>> but I have been using GnuCash mostly successfully for more than twelve
>> years now.  I am new to this list, but not to the topics we're discussing.
>>
>> Regarding using the wrong year for the reconciliation date, the program
>> suggests an approximate date based on the last, and at the moment that
>> recommendation is 9/24/22.  This is not in a vacuum, however, because all
>> of the unreconciled transactions between August '22 and present are still
>> in the ledger awaiting reconciliation against these 12 or so monthly
>> statements that I just re-downloaded.  If I'd simply entered the wrong
>> year, this would not be the case.
>>
>> I'd hoped this would have been something familiar to someone, only that I
>> didn't know about because I hadn't been on the list previously.  Based on
>> the responses, it's beginning to look a little obscure now.
>>
>> On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack <
>> stepbystepf...@comcast.net> wrote:
>>
>> >
>> >
>> > > The purpose of reconciliation is to verify that from the last closing
>> > > date to the new closing date, the listed transactions cleared the
>> > > account and thus explain the change from the opening balance (last
>> > > closing balance) to the new closing balance listed on the statement.
>> > >
>> > > The actual balance, in your books, on a given day, or as of a given
>> > > day, is irrelevant to that reconciliation.
>> >
>> >
>> > Precisely. You EXPECT there to be a difference based on checks written
>> > (appear in the gnucash account) that have not yet cleared. In other
>> > words, the main part of the job (if no errors) is to verify that the
>> > total of checks written but uncleared matches the difference between the
>> > bank statement of the account and the gnucash account as of the date of
>> > the statement.
>> >
>> > When it still doesn't match you then need to find the error, a check not
>> > entered for the correct amount. Usually at your end but once I had one
>> > of these at a bank end.
>> >
>> > Michael D Novack
>> >
>> > __

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Mark Truelove
Hi again. Besides my tendency to be details-specific (given my professional
background), I also had some college level accounting and understand
double-entry, reconciliation, and the basics.  No, I am not an accountant,
but I have been using GnuCash mostly successfully for more than twelve
years now.  I am new to this list, but not to the topics we're discussing.

Regarding using the wrong year for the reconciliation date, the program
suggests an approximate date based on the last, and at the moment that
recommendation is 9/24/22.  This is not in a vacuum, however, because all
of the unreconciled transactions between August '22 and present are still
in the ledger awaiting reconciliation against these 12 or so monthly
statements that I just re-downloaded.  If I'd simply entered the wrong
year, this would not be the case.

I'd hoped this would have been something familiar to someone, only that I
didn't know about because I hadn't been on the list previously.  Based on
the responses, it's beginning to look a little obscure now.

On Wed, Sep 27, 2023 at 10:52 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > The purpose of reconciliation is to verify that from the last closing
> > date to the new closing date, the listed transactions cleared the
> > account and thus explain the change from the opening balance (last
> > closing balance) to the new closing balance listed on the statement.
> >
> > The actual balance, in your books, on a given day, or as of a given
> > day, is irrelevant to that reconciliation.
>
>
> Precisely. You EXPECT there to be a difference based on checks written
> (appear in the gnucash account) that have not yet cleared. In other
> words, the main part of the job (if no errors) is to verify that the
> total of checks written but uncleared matches the difference between the
> bank statement of the account and the gnucash account as of the date of
> the statement.
>
> When it still doesn't match you then need to find the error, a check not
> entered for the correct amount. Usually at your end but once I had one
> of these at a bank end.
>
> 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.


Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
Hi, thanks, I'm certain I didn't add anything after the fact.

On Tue, Sep 26, 2023 at 12:40 PM Jediator  wrote:

> Did you perhaps modified/added/deleted transactions after
> reconciliation?  Any changes could easily break your reconciled
> balance.  This is typical in a double-entry system: you changed one
> account and didn't realized it affected the balance of another.  I guess
> the only way to make the reconciliation permanent in GC would be to
> reset your accounting period in settings after recon, so to prevent any
> changes to transactions before your the end date..  Hope this helps.
> Cheers!  -- JC
>
> On 9/26/23 12:05 PM, Mark Truelove wrote:
> > Hi all, I just joined the list. I thought I'd give this a try before
> moving
> > to a bug report, because I can't believe this happens to me and no one
> else
> > has experienced it.  I did try searching list history as suggested with
> > google, but didn't find anything referring to this specifically.
> >
> > Also, this is not the first time experiencing this phenomenon, probably
> the
> > third.
> >
> > I use gnucash for personal finances, so I have a checking or cash account
> > and a number of credit card accounts.  All of these are reconciled
> several
> > times a year as I receive statements, although not always on time every
> > month.  However I don't go three months without catching up on all my
> > accounts in any case.
> >
> > Today (and on previous occasions), I started my periodic reconciliations
> > because I had statement notifications in email.  I opened my credit card
> to
> > reconcile and had the month's statement in a browser window.  At first I
> > was unable to match the "beginning of month" figures to fill out the
> small
> > prompt window when reconciling.  After a few glances I realized that it
> was
> > trying to match the beginning balance to September of LAST YEAR instead
> of
> > last month.  I have reconciled this account to its statements 9 or10
> times
> > in the last year, including last month.
> >
> > In previous months, I reconciled this account and saved it normally, and
> > that information was retained for the following months' reconciliations.
> > Now when it forgets, it is losing/ignoring several months of previous
> > reconciliations, but not all of them (since this account is at least 20
> > years old).  When I checked them all, it has forgotten reconciliation
> data
> > for three other accounts as well (while another six accounts in the same
> > file are fully up-to date).
> >
> > I have backups of my files, both through GC's own backup system and my
> own
> > rotating backups.  Loss of data files is not an issue here.  This got me
> > thinking, and I went back and reloaded some of these backup files
> > directly.  When loaded, they are all missing the same information as my
> > current file.
> >
> > So, one could say, user error - he actually didn't reconcile for months,
> > and the files show that.  Unfortunately, I DID reconcile all of these
> > accounts, and the program is treating some aspect of the data as if it
> > doesn't exist beyond that point, regardless of the source file.
> >
> > I'm a retired IT pro, an IT Manager and other roles over 40 years.  I
> know
> > how this looks at first glance.  If this hadn't happened to me twice
> > previously I wouldn't be taking the time to report this in detail today.
> >
> > I'm currently running v5.3.  I downloaded 5.4 but haven't upgraded yet
> bc I
> > didn't want to compound the problem.  If this is a known issue and 5.4
> > fixes it, then great, I'll just upgrade.
> >
> > I hope this scenario seems familiar to one of the users out there.
> >
> > __
> >
> > *Mark Truelove*true9...@gmail.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> 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] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
Hi, sorry, this is running on Windows 10 22H2.

On Tue, Sep 26, 2023 at 12:16 PM Derek Atkins  wrote:

> HI,
>
> One piece of data you don't provide:  what OS/Distro are you using?
>
> For example, if you are on a Mac, there is a known behavior that GnuCash
> on Mac ALWAYS opens the last-used gnucash file, regardless of how you open
> it.  Even if you double-click on a GnuCash data file, GnuCash on Mac will
> still open the LAST USED file, not the one you clicked on.
>
> This behavior has caused many people to think there's a data issue.
>
> -derek
>
> On Tue, September 26, 2023 12:05 pm, Mark Truelove wrote:
> > Hi all, I just joined the list. I thought I'd give this a try before
> > moving
> > to a bug report, because I can't believe this happens to me and no one
> > else
> > has experienced it.  I did try searching list history as suggested with
> > google, but didn't find anything referring to this specifically.
> >
> > Also, this is not the first time experiencing this phenomenon, probably
> > the
> > third.
> >
> > I use gnucash for personal finances, so I have a checking or cash account
> > and a number of credit card accounts.  All of these are reconciled
> several
> > times a year as I receive statements, although not always on time every
> > month.  However I don't go three months without catching up on all my
> > accounts in any case.
> >
> > Today (and on previous occasions), I started my periodic reconciliations
> > because I had statement notifications in email.  I opened my credit card
> > to
> > reconcile and had the month's statement in a browser window.  At first I
> > was unable to match the "beginning of month" figures to fill out the
> small
> > prompt window when reconciling.  After a few glances I realized that it
> > was
> > trying to match the beginning balance to September of LAST YEAR instead
> of
> > last month.  I have reconciled this account to its statements 9 or10
> times
> > in the last year, including last month.
> >
> > In previous months, I reconciled this account and saved it normally, and
> > that information was retained for the following months' reconciliations.
> > Now when it forgets, it is losing/ignoring several months of previous
> > reconciliations, but not all of them (since this account is at least 20
> > years old).  When I checked them all, it has forgotten reconciliation
> data
> > for three other accounts as well (while another six accounts in the same
> > file are fully up-to date).
> >
> > I have backups of my files, both through GC's own backup system and my
> own
> > rotating backups.  Loss of data files is not an issue here.  This got me
> > thinking, and I went back and reloaded some of these backup files
> > directly.  When loaded, they are all missing the same information as my
> > current file.
> >
> > So, one could say, user error - he actually didn't reconcile for months,
> > and the files show that.  Unfortunately, I DID reconcile all of these
> > accounts, and the program is treating some aspect of the data as if it
> > doesn't exist beyond that point, regardless of the source file.
> >
> > I'm a retired IT pro, an IT Manager and other roles over 40 years.  I
> know
> > how this looks at first glance.  If this hadn't happened to me twice
> > previously I wouldn't be taking the time to report this in detail today.
> >
> > I'm currently running v5.3.  I downloaded 5.4 but haven't upgraded yet bc
> > I
> > didn't want to compound the problem.  If this is a known issue and 5.4
> > fixes it, then great, I'll just upgrade.
> >
> > I hope this scenario seems familiar to one of the users out there.
> >
> > __
> >
> > *Mark Truelove*true9...@gmail.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
Hi all, I just joined the list. I thought I'd give this a try before moving
to a bug report, because I can't believe this happens to me and no one else
has experienced it.  I did try searching list history as suggested with
google, but didn't find anything referring to this specifically.

Also, this is not the first time experiencing this phenomenon, probably the
third.

I use gnucash for personal finances, so I have a checking or cash account
and a number of credit card accounts.  All of these are reconciled several
times a year as I receive statements, although not always on time every
month.  However I don't go three months without catching up on all my
accounts in any case.

Today (and on previous occasions), I started my periodic reconciliations
because I had statement notifications in email.  I opened my credit card to
reconcile and had the month's statement in a browser window.  At first I
was unable to match the "beginning of month" figures to fill out the small
prompt window when reconciling.  After a few glances I realized that it was
trying to match the beginning balance to September of LAST YEAR instead of
last month.  I have reconciled this account to its statements 9 or10 times
in the last year, including last month.

In previous months, I reconciled this account and saved it normally, and
that information was retained for the following months' reconciliations.
Now when it forgets, it is losing/ignoring several months of previous
reconciliations, but not all of them (since this account is at least 20
years old).  When I checked them all, it has forgotten reconciliation data
for three other accounts as well (while another six accounts in the same
file are fully up-to date).

I have backups of my files, both through GC's own backup system and my own
rotating backups.  Loss of data files is not an issue here.  This got me
thinking, and I went back and reloaded some of these backup files
directly.  When loaded, they are all missing the same information as my
current file.

So, one could say, user error - he actually didn't reconcile for months,
and the files show that.  Unfortunately, I DID reconcile all of these
accounts, and the program is treating some aspect of the data as if it
doesn't exist beyond that point, regardless of the source file.

I'm a retired IT pro, an IT Manager and other roles over 40 years.  I know
how this looks at first glance.  If this hadn't happened to me twice
previously I wouldn't be taking the time to report this in detail today.

I'm currently running v5.3.  I downloaded 5.4 but haven't upgraded yet bc I
didn't want to compound the problem.  If this is a known issue and 5.4
fixes it, then great, I'll just upgrade.

I hope this scenario seems familiar to one of the users out there.

______

*Mark Truelove*true9...@gmail.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Using GC for Property Management

2023-09-22 Thread Mark at Lorimark

well...

I don't know how to answer your question, but considering what I would 
do if I were asking the same questions...


I went to ChatGPT and asked the big AI.  Here is what it said;

My Prompt (from you):

I am trying to set up GC for a small property management business. There are 
three actors involved:  Renter, Property Owner, and Property Manager.  Renter 
pays rent on a monthly basis to property management, and the manager pays the 
property owner after taking out certain percentage of management fee.write 
a workflow to process that.




ChatGPT

Setting up a workflow for a small property management business involving 
Renters, Property Owners, and Property Managers requires careful consideration 
of the steps and interactions between these actors. Here's a workflow to help 
you process rent payments and management fees:

Workflow: Rent Payment and Management Fee Processing

Renter Pays Rent:
On a monthly basis, the Renter pays their rent to the Property 
Management company.
Rent can be paid through various methods, such as bank transfers, 
checks, or online payment portals.

Rent Receipt and Acknowledgment:
The Property Management company issues a rent receipt or acknowledgment 
to the Renter upon receiving the rent payment.
The receipt should include details like the payment amount, payment 
date, property address, and a unique reference number.

Record Rent Payment:
The Property Manager records the rent payment in the property 
management system or accounting software.
Ensure accuracy in recording payment details for future reference and 
reporting.

Deduction of Management Fee:
After receiving the rent payment, the Property Manager calculates and 
deducts the agreed-upon management fee percentage.
The remaining amount represents the net income from rent.

Payment to Property Owner:
The Property Manager initiates a payment to the Property Owner for 
their share of the rent income.
This payment is typically done through bank transfers or checks, and it 
should include a breakdown of income and deductions.

Monthly Reporting:
Prepare monthly financial reports for both the Property Owner and the 
Property Manager.
The report should detail rent collected, management fees deducted, and 
any expenses incurred on behalf of the property owner.

Reserve Fund Allocation (Optional):
If agreed upon, allocate a portion of the rent income to a reserve fund 
for property maintenance and repairs.
Maintain transparency by documenting the allocation and use of these 
funds.

Communication with Property Owner:
Keep open lines of communication with the Property Owner regarding rent 
payments, property maintenance, and any issues that require their attention.

Ongoing Property Management:
Continuously manage the property, address maintenance requests, and 
ensure the property is well-maintained to retain tenants.

Annual Financial Statements and Tax Reporting:
Prepare annual financial statements and provide necessary tax 
documentation to Property Owners for tax filing purposes.

This workflow ensures a systematic and transparent process for handling rent 
payments, management fees, and property owner payments. It helps maintain good 
relationships with both Renters and Property Owners while ensuring financial 
accuracy and accountability. Additionally, consult with legal and financial 
professionals to ensure compliance with local regulations and tax requirements.


My Follow-up Prompt:

User
can you express those elements as they pertain to accounting steps
ChatGPT

Certainly, let's break down the workflow into accounting steps for your 
property management business:

Accounting Workflow: Rent Payment and Management Fee Processing

Renter Pays Rent:
Debit: Rent Receivable (Asset Account)
Credit: Rental Income (Revenue Account)

Rent Receipt and Acknowledgment:
Issue a rent receipt with details of the payment, including the rent 
amount, payment date, property address, and reference number.

Record Rent Payment:
Debit: Bank Account (Asset Account)
Credit: Rent Receivable (Asset Account)

Deduction of Management Fee:
Calculate the management fee as a percentage of the total rent received.
Debit: Management Fee Expense (Expense Account)
Credit: Rental Income (Revenue Account)

Payment to Property Owner:
Debit: Management Fee Expense (Expense Account)
Credit: Owner's Equity or Due to Property Owner (Liability Account)
Issue a payment to the Property Owner, including a breakdown of income 
and deductions.

Monthly Reporting:
Prepare monthly financial reports, including an income statement and a 
balance sheet.
Include details of rent collected, management fees deducted, and any 
other property-related expenses.

Re: [GNC] Transaction inconsistency when deleting account

2023-09-05 Thread Mark via gnucash-user

Sep 5, 2023 10:18:53 Gyle McCollam :

> No Mark, it is not a bug.  If you made credit card purchases and subsequent 
> payments to that card, those transactions have already been made and if you 
> were to delete an account and the transaction within, it would be the same as 
> if the transactions had never happened and they did.  Gnucash, offering to 
> move them to another account is the only way not to screw up all the account 
> affected by the account you are deleting.

I'm not the OP that wanted to mass delete transactions. What I was referring to 
as possibly a bug was what Maf. King said that choosing "delete all 
transactions" when deleting an account effectively moves them to Imbalance. If 
that is what that option is supposed to do, it would probably be good to make 
that clearer in the dialog box. Sorry I didn't word that clearly.
___
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] Transaction inconsistency when deleting account

2023-09-05 Thread Mark via gnucash-user

Sep 5, 2023 08:33:44 Maf. King :

> I just tried deleting an account.   As expected, I was presented with the
> choice to "move transactions to..." or "Delete all transactions" (see
> screenshot - this is GC 4.x, maybe the wording is different in v5)
>
> Deleting the transactions does not really seem to delete anything, the
> transaction splits effectively moved to Imbalance-GBP. 
>
> One could argue that "splits" in the deleted account have been deleted, and
> GC has auto-created new splits to the Imbalance account - I don't know what
> the internal process is- but it "feels" to the end user like a move, not a
> delete.
>
> Given a "transaction" is a collection of "at least 2 splits",  then I think I
> agree with the OP, (whatever the validity of the reason for wanting to delete
> an account), being told that "transactions" will be deleted and them still
> existing seems a bug (maybe only in wording in the dialog box)

Ah, it's been a while since I deleted an account, and I don't remember the 
option to delete all transactions being there (maybe I just forgot). I agree 
that is confusing at least, and maybe a bug.

I don't think I would ever use that option, though. That seems like a confusing 
side effect to have transactions deleted by deleting an account. Maybe I'm just 
used to the way GnuCash has done things.
___
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] Transaction inconsistency when deleting account

2023-09-05 Thread Mark via gnucash-user

Sep 4, 2023 23:30:59 Jediator :

> It's a valid user function in GC to delete a non-empty account. 

And that will delete the account and move any transactions in it to another 
account, which you can select. Personally, I think that makes sense, I don't 
want to be mass deleting transactions as a side effect of deleting an account.

It sounds like what you're actually wanting is some way to mass delete 
transactions. I'm not sure if there is a way to do that, maybe someone else 
knows. If there is not, you could make a feature request. (Unless that is 
something you could implement yourself.)
___
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] Consolidation of family member accounts

2023-08-13 Thread Mark at Lorimark
I'm not a CPA.  Just someone that uses and loves GnuCash, so... grains 
of salt needed here...


Those are really separate "accounting systems" are they not?  Would not 
each person maintain their own set of books?


If so, then when you transfer funds to your son, you ~could~ expense 
that, and to you it shows as an 'expense' or 'gift', and you have to 
account for that.  If you're giving someone money, don't you have to 
account for and report on that?  That's 'one side' of the transactional 
relationship (a double-post in YOUR account system showing a transfer).


Then, in your sons 'accounting system' he would show an double-posted 
'income' and 'asset', where he would receive income, and it would land 
as an asset.


Your expense and liability (to the tax man) is covered in your entries, 
and your sons 'income and subsequent expenses' are also tracked 
accordingly and properly in HIS accounting system.


Same with your wife.

Then, at tax time, everyone runs their 'books' to see all their incomes 
and expenses...


Does it make sense to break it up this way, to at least understand the 
'flow of monies' between all these individuals?  Because, if so, I think 
it would be possible to 'combine but separate' the 'Son' and 'Wife' 
systems in to a single (hierarchical) account file, and then get your 
taxes report by separating those accounts accordingly...


~mark petryk
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper

On 8/13/23 12:04, Paras Desai wrote:

Hello sirs,

1. I am adopting GNC for my family members (me, wife and son)
2. There are lots of transfer takes place between family members. For example, 
I transfer an amount to wife account , for her expense or investment. Same for 
son.
3. At present I can adopt two approach for such transfer
Either I can show transferred amount as gift expense or create account 
receivable in name of family member.
4. Neither is a good practice, as at family level, it will erroneously show 
duplicate expenses (mine as gift to wife and, wife's actual expenses with 
gifted fund)

So my question is

Is there a way in GNC to consolidate family members account to arrive at net 
worth of entire family?

When we do consolidation of accounts, we eliminate inter transaction between 
members (as we do between a parent and subsidiary company in business scenario)

I will be happy to explore the way, if there is any way I can achieve this in 
GNC

Thank you

Paras


___
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] GnuCash preferred OS - Windows or Linux

2023-07-26 Thread Mark at Lorimark
I am a staunch Linux user, and came from the Quickbooks world as well. 
I am running a very small database, but have it in the sqlite, since 
that (for me) is very easy to work inside of if i need to poke around in 
the database (which I do).


I much prefer the 'double entry' approach to things rather than the 
bubble wrapped QB environment, and yes QB is getting expensive!


I can't imagine any functional difference between any of the platforms 
as it pertains to GnuCash.



On 7/25/23 15:15, Ben Kamen wrote:

Hey all,

Noob user here just getting started with GnuCash (as QuickBooks Desktop 
has gone from about $66/yr to almost $600 in Intuits efforts to push 
users to SaaS online and I refused to put my financial info on "the 
cloud" -- file under "Equifax protects credit info with login -> 
Admin:Admin").


So --

That being said, I have Linux systems. I have Windows system.

I have Windows systems running Linux VMs and Linux systems running 
Windows VMs.


I really dig the idea that GnuCash can use MySQL and might set that up 
once I get used to GnuCash.


But first, am I better off running it in Linux or Windows (It looks like 
the answer is Linux from what I've see of the Wiki).


And while I have a super basic setup configured, the first thing I'd 
like to test out is my banking connection.


I think there's a dead link in the wiki:

https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#U.S._Bank 
says:

U.S. Bank
Fee $3.95/month for home user, $9.95-12.95/month for business (See 
Bank With Quicken).

Which points to a 404 page.

It *looks* like more useful information might be found here:

https://www.quicken.com/support/important-notice-quicken-users-us-bank-accounts-avoid-mistakenly-migrating-direct-connect

but I might be wrong.

Anyway - as mentioned, I'd be coming off Quickbooks not Quicken... but 
in Quickbooks, USbank lists as PFM-DirectConnect. Not sure if that's the 
same.


SO -- to setup/test/troubleshoot my US Bank connections, should I be 
emailing the AqBanking list or is that something to discuss here as well?
(it also seems like the AqBanking list of banks when doing the setup 
yields no results typing in the search bar - I'm assuming that's due to 
lacking the list... but


LIke -> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings 
lists my bank. Is that all I need?
There's also ->    wget 
http://www.jongsma.org/gc/bankinfo/getfidata.sh.gz which seems broken.


It resolved, but there's nothing running on port:80 - So  perhaps a note 
to the Wiki is recommended?





Thanks a bunch,

  -Ben

___
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] Accounts which are both Income and Expense accounts

2023-07-24 Thread Mark at Lorimark

I think you need four accounts?

Asset:Me
Asset:Jim
Expense:Me
Expense:Jim

Transactions;

Asset:Me  -> (dec) $10 -> Expense:Jim (inc) $10 (bal) $10
Asset:Me  -> (dec) $15 -> Expense:Jim (inc) $10 (bal) $25
Asset:Jim -> (dec) $5  -> Expense:Me  (inc) $5  (bal) $5

Jim's expenses == $25
Me's expenses  == $5

Jim owes me $20 ?

~mark petryk
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper

On 7/24/23 10:53, Chris Green wrote:

Is there a 'right' way to handle an account which gets payments in two
directions?

E.g. I have good relations with a friend and we often buy things for
each other and settle up at the end of the month.  Sometimes I owe the
friend some money, other times the friend owes me some money but it's
very definitely one account and one wants to see all the payments in
one place.

I guess one can just say it's an 'Expense' account and make payments
in either direction as required, is this the only way or is there a
special name for such an account?


___
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] Finance::Quote terminal commands not working with Flatpack v:5.3 install

2023-07-11 Thread Mark at Lorimark

Here's one thought;


https://www.redhat.com/sysadmin/launch-flatpaks-terminal-fuzzpak


I just googled that.

I've got the same question/issue... but hadn't looked up for it yet.
___
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] Gnucash 5.1 Ledger Issues

2023-06-02 Thread Mark at Lorimark

Les,

Can you post a screen shot.

When you say "no offsets", I'm not fully clear... do you mean no 
"children" in the "accounts-tree-view" ?


~mark petryk
~c:469-556-5075
~t:4695565...@mms.att.net
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper

On 6/2/23 12:45, Les wrote:

I do not have a different PC.

Les


On 6/2/23 10:14, Mark at Lorimark wrote:

Hi Les,

Can you try opening the file with a different PC?

~mark

On 6/2/23 10:04, Les wrote:

Hi all:

I opened my accounts this morning and all that is displayed are the 
top levels. (There are no offsets  being displayed).  How to fix?  I 
am using Linux Mint 21.0 and the source of Gnucash is flatpak. I have 
closed and reopened the accounts without any change.


Thanks for any assistance.

Les
___
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/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] Gnucash 5.1 Ledger Issues

2023-06-02 Thread Mark at Lorimark

Hi Les,

Can you try opening the file with a different PC?

~mark

On 6/2/23 10:04, Les wrote:

Hi all:

I opened my accounts this morning and all that is displayed are the top 
levels. (There are no offsets  being displayed).  How to fix?  I am 
using Linux Mint 21.0 and the source of Gnucash is flatpak. I have 
closed and reopened the accounts without any change.


Thanks for any assistance.

Les
___
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] Building 5.1 on Ubuntu 22.04

2023-05-30 Thread Mark at Lorimark

Hi Mike,

I am just trying to get set up with a dev enviro myself.  To that end, I 
have made two efforts.


1. docker
2. VM

I have docker scripts that seem to work to set up a new image with all 
the necessary build-tools, but running gnucash from within docker 
creates some challenges so I started a second effort to build a VM.


For the VM I have two scripts that I execute to "build up" the box.  I 
have attached both here (note these scripts are brand-new, so still some 
editing to do within them - hope they help);


serveradmin@gnucash-dev:~$ cat -n gnucash-dev-setup.sh 
 1	

 2  #
 3  # This will install all the necessary libraries and development
 4  #  of gnucash
 5  #
 6  # run as root
 7  #
 8  
 9  echo "update..."
10  apt-get update -q
11  apt-get upgrade -y
12  apt-get dist-upgrade -y
13  apt-get autoremove -y
14  
15  #
16  # base stuff
17  #
18  echo "base stuff..."
19  apt-get install -y \
20  wget \
21  mc \
22  vim \
23  lynx \
24  wget
25  
26  #
27  # library build stuff
28  #
29  echo "library build stuff..."
30  apt-get install -y \
31  libglib2.0-dev \
32  pkg-config \
33  make\
34  dconf-cli\
35  git  \
36  gettext  \
37  gcc  \
38  g++  \
39  libxml2-dev  \
40  libxslt1-dev \
41  xsltproc \
42  webkit2gtk-4.0-dev   \
43  swig \
44  guile-2.2-dev\
45  gwenhywfar-tools \
46  build-essential  \
47  libofx-dev   \
48  libgtest-dev \
49  libdbi-dev   \
50  libxml2-utils\
51  libboost-all-dev \
52  libboost-date-time-dev   \
53  libboost-filesystem-dev  \
54  libboost-locale-dev  \
55  libboost-regex-dev   \
56  libboost-program-options-dev \
57  libboost-system-dev
58  
59  #
60  # gnucash build-dep stuff
61  # update sources.list so we can pull the "build-dep gnucash" below
62  #
63  echo "gnucash build-dep stuff"
64  # sed -i '/^#.*deb-src/s/^#//' /etc/apt/sources.list
65  echo "build-dep"
66  apt-get -y build-dep gnucash
67  
68  echo ""
69  echo ""
70  echo ""
71  echo ""
72  echo ""
73  echo "all set!  run 'gnucash-src-setup.sh' as your regular user to fetch and 
set up your dev working environment"
74  


serveradmin@gnucash-dev:~$ cat -n gnucash-src-setup.sh 
 1	#

 2  # Run this script to fetch and set up a dev
 3  #  environment.  This will create the project
 4  #  folder called 'gnucash-dev' in your current
 5  #  folder, and then fetch the gnucash sources
 6  #  and set up a build-directory and then cause
 7  #  gnucash to build.   At the end, you should
 8  #  have a good working gnucash binary available
 9  #  for executing.
10  #
11  
12  mkdir gnucash-dev
13  cd gnucash-dev
    14  git clone https://github.com/Gnucash/gnucash.git src
15  mkdir build
16  cd build
17  cmake ../src
18  




~mark petryk
~c:469-556-5075
~t:4695565...@mms.att.net
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper

On 5/30/23 12:52, M wrote:

I am trying to build gnucash 5.1 on Ubuntu 22.04, if thats possible.

I have run apt-get update and apt-get upgrade, and everything is up to 
date.

I have run sudo apt build-dep gnucash, and receive:
   0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

When running cmake, I get the following error:
   Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3

Any idea how to install this update on Ubuntu 22.04?
When I run
   sudo apt-get install gwenhywfar-tools
I get
   gwenhywfar-tools is already the newest version (5.1.3-1build1)

Is there any way to get the newer package on Ubuntu 22.04?

Thanks,

Mike

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

2023-05-24 Thread Mark at Lorimark

Hi,

I was wondering what I need to get an invitation to #gnucash in libera?



Cannot join #gnucash (Channel is invite only)




--
~mark petryk
~c:469-556-5075
~t:4695565...@mms.att.net
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper
___
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] credit account negative balance increases with payment

2023-03-06 Thread Mark via gnucash-user


Mar 6, 2023 10:11:40 Custom Shots :

> This is happening with only one credit account. I have four credit
> accounts. The other three are working properly. This one in question is the
> only one that is incorrect.

Are they all set as type "credit card"? If you right click the account and 
click edit account you can see and change what type the account is.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] how to remove sqlite lock

2023-02-11 Thread Mark Hedges via gnucash-user
Ooh snap... the warning came back even on the new file that I generated by
saving out to XML first.  I was using 4.10.  I upgraded to 4.13 and tried
saving out to XML and back to SQLite3 again.  It seems to work now.
Mark

On Sat, Feb 11, 2023 at 12:23 PM Mark Hedges 
wrote:

> I seem to have a stuck lock in my SQLite GnuCash book.  Every time I open
> the file, it says:
>
> GnuCash could not obtain the lock for /Users/hedges/[...]/myfile.gnucash.
> That database may be in use by another user, in which case you should not
> open the database. What would you like to do?
> Open Read-only | Create New File | Open Anyway | Open Folder | Quit
>
> I tried "Open Anyway" but it apparently does not remove the lock.
>
> Is there a way to remove locks on SQLite books?
>
> Saving as a new SQLite file did not work.  I had to save as XML, open that
> book, and save again as SQLite to get a new file that I could open without
> a lock warning.
>
> Thanks.
> Mark
>
___
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] how to remove sqlite lock

2023-02-11 Thread Mark Hedges via gnucash-user
I seem to have a stuck lock in my SQLite GnuCash book.  Every time I open
the file, it says:

GnuCash could not obtain the lock for /Users/hedges/[...]/myfile.gnucash.
That database may be in use by another user, in which case you should not
open the database. What would you like to do?
Open Read-only | Create New File | Open Anyway | Open Folder | Quit

I tried "Open Anyway" but it apparently does not remove the lock.

Is there a way to remove locks on SQLite books?

Saving as a new SQLite file did not work.  I had to save as XML, open that
book, and save again as SQLite to get a new file that I could open without
a lock warning.

Thanks.
Mark
___
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] Importing csv files

2023-01-21 Thread Mark Bole
I *did* provide a "well-detailed example", as shown in my post copied 
below (one line with header info, one line of data).  But apparently no 
one looked at it to the point of finding my somewhat obvious error (not 
complaining, I realize this is a volunteer resource).


So, the other thing I did was put it aside for a few days and take 
another look with fresh eyes.  And the problem was simply that I omitted 
the column for "Account Code", even though it was present in my first 
successful import file.  Not sure why I missed it in the second file, 
perhaps because (so far) I'm not using account codes for bottom-level 
accounts. In the process of massaging the QB export data for input, I 
must have just accidentally deleted or over-wrote the Code column.



On 2023-01-19 22:42, David Carlson wrote:

Mark,

The Help manual chapter 6 gives a good starting point to configuring a 
successful CSV transaction import.  However, it does not describe 
importing accounts.


GnuCash is supposed to be able to import anything that it can export, 
so if you try to find an existing account tree example in a test file, 
possibly created by the Gnucash account setup wizard, you can try 
exporting it to see what might work in the import direction.  If you 
have tried that and it still fails, you should at least have a well 
detailed example to use when you return to ask this group for 
additional help.


Is there documentation somewhere as to allowed characters, field
lengths, etc for CSV import of accounts?

Here is an example of an import file that fails for me.  The top
level
and sub-accounts exist.  Why won't it import successfully?

Type,Full Account Name,Account Name,Description,Account
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
Direct,,,USD,CURRENCY,F,F,F



___
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] Importing csv files

2023-01-19 Thread Mark Bole
By coincidence, I too am trying to import my QuickBooks well-tuned COA 
into GnuCash via CSV files.  I already knew to try the things 
recommended in this thread but still have indeterminate results. I 
realize by now that with the time already invested (especially after I 
finish writing this), I could have manually altered the sub-account 
status and been done with it, but I want to understand what is going on 
at a lower level.


I broke my QB accounts into smaller chunks for better testing and 
recovery if needed. _/My first batch import of type BANK accounts worked 
fine!/_  But now, with the same CSV format, I find I cannot successfully 
import further small groups of account rows from CSV files.  The 
Preview, even more frustrating, can show that the first four or five 
input rows don't parse correctly, but then suddenly  row six is fine for 
import in the preview.


Is there documentation somewhere as to allowed characters, field 
lengths, etc for CSV import of accounts?


Here is an example of an import file that fails for me.  The top level 
and sub-accounts exist.  Why won't it import successfully?


Type,Full Account Name,Account Name,Description,Account 
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury 
Direct,,,USD,CURRENCY,F,F,F


-Mark B.

On 2023-01-19 11:58, R Losey wrote:

Also, do you really need to import data from Quickbooks? I used Quicken,
not Quickbooks, but (by and large), I just started up GnuCash afresh and
went back to Quicken only when I needed to look things up.  Now that I'm
years into GnuCash, I have had no need to go back to Quicken.



On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:


Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To
that end I've first been trying to import my accounts structure in via a
csv file and failing badly.

Pre Christmas holidays I was getting an error message I could not
interpret. Now I've installed the latest stable version 4.13 and it just
dies mid process.

I'm running on Windows 11 and using open office to manipulate the csv
files before trying to import.

Where can I find a good discussion or indepth material on importing csv
files, the expected format for them, ect...?


___
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] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread Mark Penner via gnucash-user



Jan 11, 2023 18:07:03 R Losey :

I apologize for not using "debit" and "credit" terms, but I'm not sure 
I'd

get them right.


I also have to think a bit sometimes to get them right. As someone(s) 
said, debits are always on the left, credits on the right. I just 
remember that money flows from right to left, from the credited accounts 
to the debited accounts. I find that easier to remember than which types 
of accounts increase with debits, etc.


HTH
Mark
___
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 PC

2022-12-15 Thread Mark Penner via gnucash-user



Dec 15, 2022 09:26:28 Michael or Penny Novack 
:


It would perhaps be a good idea to explain WHERE that other user data 
is stored so that users so gnucash can include that in their gnucash 
back-ups (and so in moves to a different computer). I don't mean just 
on the list, but also in the documentation under back-up instructions. 
I realize that the location might be different for different OS's.


Michael D Novack


It's in the wiki:
https://wiki.gnucash.org/wiki/Backup
https://wiki.gnucash.org/wiki/Configuration_Locations

Mark
___
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 someone confirm if this split transaction is correct?

2022-12-12 Thread Mark Penner via gnucash-user


Dec 12, 2022 14:39:13 Dr. David Kirkby :


So at one point your PayPal account has the full amount, then you split
that, so the fees are removed?


When you process payment, you'll get a transaction like:
Debit  Paypal: 906
Credit A/R: 906

Edit that transaction by subtracting the fee from the amount debited to 
PayPal and make a debit to Fees. The transaction should then look 
something like:

Debit  Paypal: 867.74
Debit Fees: 38.26
Credit A/R: 906

Mark
___
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 someone confirm if this split transaction is correct?

2022-12-12 Thread Mark Penner via gnucash-user



Dec 12, 2022 10:26:24 Dr. David Kirkby :


Now I'm a bit lost on what I should be doing.

When I create the invoice

Business -> Customer -> ,New Invoice,

a copy of which I will send to the customer, I don't want the PayPal 
fees

showing. So I post the invoice without the PayPal fees showing. That is
going into

Assets -> Accounts Receivable -> PayPal (GPB)
(the name might have changed slightly since when I originally posted, 
but

the functionality should be obvious)

After that, to process the payment

Business -> Customer -> Process Payment

I can only select one transfer account, which is not what I want to do.

What item(s) on the menu should I be using to make the correct debits 
and
credits to move the money into the PayPal account and the expenses 
account

from the Accounts Receivable -> PayPal (GPB)?


When I process payment, I choose my PayPal account, then edit the 
transaction by adding a split for the fee and subtracting the fee from 
the debit to PayPal. Don't change the Accounts Receivable split.

If someone has a better solution, I would like to hear it too.

Mark
___
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] CPA recommendations for California S-corp

2022-02-06 Thread Mark Hedges via gnucash-user
Hi... apologies if it's not right to ask for recommendations.  The list FAQ
doesn't say it's prohibited.  Can anyone recommend a CPA experienced with
S-corporations and California tax returns who can use GnuCash?  I just got
a 50 hour/week gig so I'm going to fall even further behind than I was
before.  Thanks.
--
Mark Alan Hedges
CEO Weird Vibe Inc.
+1 (310) 487-7123
https://weirdvibe.media <http://weirdvibe.media>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-13 Thread Mark Sutton
Ok, so I see there was no change to gnucash to fix this only a fix to
libofx. So I shouldn't even bother looking at the combination of 4.9
and 0.10.2. I will upgrade and try a few different time stamp/ offset
combinations.

Thanks

On Thu, Jan 13, 2022 at 10:32:17AM -0800, John Ralls wrote:
> Mark,
> 
> AIO expands to "all-in-one" and refers to the Windows and macOS bundles that 
> we publish containing GnuCash and all of its dependencies. Flatpak is 
> something of a hybrid in that the GNOME dependencies are provided by the 
> flatpak runtime and our build script adds AQBanking, Boost, and libofx.
> 
> The relevant commit is 
> https://github.com/libofx/libofx/commit/70ae1b44fd4ea00175ae9fa5a6abd12243534fc2
>  and it was to fix https://bugs.gnucash.org/show_bug.cgi?id=798267.
> 
> Interestingly that bug was for Australian Eastern Standard Time, +10:00 
> instead of US Eastern Standard Time -5:00.
> 
> Regards,
> John Ralls
> 
> > On Jan 13, 2022, at 10:07 AM, Mark Sutton  wrote:
> > 
> > On Thu, Jan 13, 2022 at 09:28:06AM -0800, john wrote:
> >> Derek,
> >> 
> >> The libofx change was in libofx-0.10.3 but I also (as I generally do) set 
> >> the same patch to libofx 0.10.2 in the build repositories so GnuCash 4.8 
> >> and 4.9 include the fix.
> >> Since the 4.9 AIO still doesn't work there must be another path where the 
> >> TZ is bering applied backwards.
> >> 
> > I'm not sure what AIO is, but I have 4.9 installed on funtoo. Right now 
> > libofx-0.10.2
> > is installed, but I can emerge libofx-0.10.3.
> > I have also run into this problem but I am in UTC-8 or -7 depending on the 
> > time
> > of year so the problem only manifested when DST set in. I think I just 
> > massaged the
> > file to make the transaction post at noon then it didn't matter.
> > 
> > I have five years of TD files to import so I don't mind doing some tests.
> > So what combination should work? gnc-4.9 with libofx-0.10.2? 
> > if so does that break with 0.10.3 
> > I can not find the commit that might have fixed this so I can't see what it 
> > does.
> > Does it check version and apply the correction or not.
> > 
> > -mark
> >> 
> >> 
> >>> On Jan 12, 2022, at 9:31 AM, Derek Atkins  wrote:
> >>> 
> >>> According to that bug it was fixed in LibOFX in June 2021...  And the fix
> >>> appears to be in 0.10.3
> >>> What version of LibOFX is in use?
> >>> 
> >>> -derek
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-13 Thread Mark Sutton
On Thu, Jan 13, 2022 at 09:28:06AM -0800, john wrote:
> Derek,
> 
> The libofx change was in libofx-0.10.3 but I also (as I generally do) set the 
> same patch to libofx 0.10.2 in the build repositories so GnuCash 4.8 and 4.9 
> include the fix.
> Since the 4.9 AIO still doesn't work there must be another path where the TZ 
> is bering applied backwards.
> 
I'm not sure what AIO is, but I have 4.9 installed on funtoo. Right now 
libofx-0.10.2
is installed, but I can emerge libofx-0.10.3.
I have also run into this problem but I am in UTC-8 or -7 depending on the time
of year so the problem only manifested when DST set in. I think I just massaged 
the
file to make the transaction post at noon then it didn't matter.

I have five years of TD files to import so I don't mind doing some tests.
So what combination should work? gnc-4.9 with libofx-0.10.2? 
if so does that break with 0.10.3 
I can not find the commit that might have fixed this so I can't see what it 
does.
Does it check version and apply the correction or not.

-mark
> 
> 
> > On Jan 12, 2022, at 9:31 AM, Derek Atkins  wrote:
> > 
> > According to that bug it was fixed in LibOFX in June 2021...  And the fix
> > appears to be in 0.10.3
> > What version of LibOFX is in use?
> > 
> > -derek
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-11 Thread Mark Sutton
The  [-5:EST] is in fact the problem. I think GNC posts in UTC.
They even change that when daylight saving time comes into effect. 
I either made the change in vi or wrong a sed script. 
I'll have a look at what I did.

On Tue, Jan 11, 2022 at 12:06:04PM -0800, Jean Laroche wrote:
> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to 
> > have 0200 as their time; subtracting 5 hours from that would return -3 
> > o'clock (and presumably shift the date back one).
> 
> You could do a test where you modify your OFX file to remove [-5:EST] from
> all transactions (you can do that easily in an editor), then try to import
> it and see whether this fixes the dates.
> 
> After that the question is whether that [-5:EST] is valid or not.
> Jean
> 
> 
> On 1/11/22 11:59 AM, D. via gnucash-user wrote:
> > But EFT transactions (which are the bulk of my txns these days) shouldn't 
> > get shifted around much at all. I'd be miffed if every EFT entry were a day 
> > off.
> > 
> > 
> >  Original Message 
> > From: Gyle McCollam 
> > Sent: Tue Jan 11 13:33:51 EST 2022
> > To: "D." 
> > Cc: "gnucash-user@gnucash.org" 
> > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file (TD 
> > Bank)
> > 
> > I find my dates usualy do not agree with the bank dates.  I record credit 
> > card bills when I pay them (electronically) and they are recorded by the 
> > payee on the same date.  However, they usually hit my bank the next banking 
> > day.  This isn't and shouldn't be a problem or concern.  Actual physical 
> > checks take even longer to show up at the bank.  This is all normal.
> > 
> > 
> > Thank You,
> > Gyle McCollam
> > 
> > Gyle McCollam
> > 
> > 609.680.2326 Mobile
> > 
> > gmccol...@live.com   email
> > 
> > 
> > From: gnucash-user  on 
> > behalf of D. via gnucash-user 
> > Sent: Tuesday, January 11, 2022 1:20 PM
> > To: David Carlson 
> > Cc: GnuCash 
> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
> > 
> > I'd be annoyed at the shift.
> > 
> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to 
> > have 0200 as their time; subtracting 5 hours from that would return -3 
> > o'clock (and presumably shift the date back one).
> > 
> > 
> >  Original Message 
> > From: David Carlson 
> > Sent: Tue Jan 11 12:53:59 EST 2022
> > To: "xraive ." 
> > Cc: Gnucash Users 
> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
> > 
> > Your bank creates the Ofx file.   Gnucash just accepts what they give you.
> > Sometimes it may appear to be incorrect when it is a misunderstanding about
> > whether transactions are posted on the same day they occur.
> > 
> > Does it really make a difference?
> > 
> > 
> > 
> > 
> > On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:
> > 
> > > I downloaded transactions from my bank (TD) in Canada and when I tried
> > > importing the file into GNUCASH all the dates were set to one day earlier
> > > then the actual transactions.  I'm including sample transactions below.
> > > 
> > > OFX file imported to GNUCASH
> > > 
> > > 
> > > DEBIT
> > > 2021072202[-5:EST]
> > > -14.64
> > > 21203175847980020
> > > Best Buy
> > > 
> > > 
> > > CREDIT
> > > 2021072602[-5:EST]
> > > 21.83
> > > 2120719980010
> > > Home Depot
> > > 
> > > 
> > > Any help would be greatly appreciated.  If you need additional information
> > > please let me know.
> > > 
> > > Thanks
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by 

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

2022-01-11 Thread Mark Sutton
what time zone are you in? 2:00AM (whether GMT, or EST) is still yesterday if 
you are GMT-8 ?

On January 11, 2022 2:33:08 PM PST, "xraive ."  wrote:
>Sorry for the late response.  I tried removing [-5:EST] and the issue still 
>persists. All the dates are still reported as one day earlier.  I imported the 
>same file in MSMoney and the dates matched the banks if that helps.
>
>Thanks for your assistance so far.
>
>From: gnucash-user  on 
>behalf of David Carlson 
>Sent: Tuesday, January 11, 2022 9:33 PM
>To: Jean Laroche 
>Cc: gnucash-user@gnucash.org 
>Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
>That -5 EST relates local time to universal time and may come into play if
>the local computer clock is not set to the local time zone.  Usually it
>clarifies the source time reference of the data.
>
>On Tue, Jan 11, 2022, 2:07 PM Jean Laroche  wrote:
>
>> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
>> have 0200 as their time; subtracting 5 hours from that would return -3
>> o'clock (and presumably shift the date back one).
>>
>> You could do a test where you modify your OFX file to remove [-5:EST]
>> from all transactions (you can do that easily in an editor), then try to
>> import it and see whether this fixes the dates.
>>
>> After that the question is whether that [-5:EST] is valid or not.
>> Jean
>>
>>
>> On 1/11/22 11:59 AM, D. via gnucash-user wrote:
>> > But EFT transactions (which are the bulk of my txns these days)
>> shouldn't get shifted around much at all. I'd be miffed if every EFT entry
>> were a day off.
>> >
>> >
>> >  Original Message 
>> > From: Gyle McCollam 
>> > Sent: Tue Jan 11 13:33:51 EST 2022
>> > To: "D." 
>> > Cc: "gnucash-user@gnucash.org" 
>> > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file
>> (TD Bank)
>> >
>> > I find my dates usualy do not agree with the bank dates.  I record
>> credit card bills when I pay them (electronically) and they are recorded by
>> the payee on the same date.  However, they usually hit my bank the next
>> banking day.  This isn't and shouldn't be a problem or concern.  Actual
>> physical checks take even longer to show up at the bank.  This is all
>> normal.
>> >
>> >
>> > Thank You,
>> > Gyle McCollam
>> >
>> > Gyle McCollam
>> >
>> > 609.680.2326 Mobile
>> >
>> > gmccol...@live.com   email
>> >
>> > 
>> > From: gnucash-user 
>> on behalf of D. via gnucash-user 
>> > Sent: Tuesday, January 11, 2022 1:20 PM
>> > To: David Carlson 
>> > Cc: GnuCash 
>> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>> >
>> > I'd be annoyed at the shift.
>> >
>> > I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
>> have 0200 as their time; subtracting 5 hours from that would return -3
>> o'clock (and presumably shift the date back one).
>> >
>> >
>> >  Original Message 
>> > From: David Carlson 
>> > Sent: Tue Jan 11 12:53:59 EST 2022
>> > To: "xraive ." 
>> > Cc: Gnucash Users 
>> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>> >
>> > Your bank creates the Ofx file.   Gnucash just accepts what they give
>> you.
>> > Sometimes it may appear to be incorrect when it is a misunderstanding
>> about
>> > whether transactions are posted on the same day they occur.
>> >
>> > Does it really make a difference?
>> >
>> >
>> >
>> >
>> > On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:
>> >
>> >> I downloaded transactions from my bank (TD) in Canada and when I tried
>> >> importing the file into GNUCASH all the dates were set to one day
>> earlier
>> >> then the actual transactions.  I'm including sample transactions below.
>> >>
>> >> OFX file imported to GNUCASH
>> >>
>> >> 
>> >> DEBIT
>> >> 2021072202[-5:EST]
>> >> -14.64
>> >> 21203175847980020
>> >> Best Buy
>> >> 
>> >> 
>> >> CREDIT
>> >> 2021072602[-5:EST]
>> >> 21.83
>> >> 2120719980010
>> >> Home Depot
>> >> 
>> >>
>> >> Any help would be greatly appreciated.  If you need additional
>> information
>> >> please let me know.
>> >>
>> >> Thanks
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see
>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
>> >>
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, 

Re: [GNC] gnucash-user Digest, Vol 224, Issue 36

2021-11-20 Thread Mark
Hi Alex,

I have an open source project which pushes VAT records to HMRC from
GnuCash: https://github.com/cybermaggedon/gnucash-uk-vat

I created this for me, I suspect I'm the only user at the moment.  I
registered with HMRC as a developer and got approval to use this, with all
the right fraud protection headers.  Further, I have been using this for my
own VAT returns since April this year, everything works fine, and I the
appropriate VAT records are created.  In periods where I'm VAT-positive, I
have received refunds to my bank account as I should.

Complications:
- This needs the gnucash Python modules, which as I understand it, are only
bundled with the Linux builds of GnuCash. I can't speak as to whether it is
possible to get this to work with other operating systems. It might be
possible to get this working by parsing the GnuCash file directly so that
the gnucash modules aren't needed.
- There are problems with how the credentials would work. HMRC won't permit
me to publicly share the secret key which authorises the application.  I
can generate secret keys and give them to individuals on the understanding
that they are not shared, but there's a limit of 4 keys.  It is possible
for other people to register developer accounts and get keys to use my
application as I understand it, HMRC developer support told me that was the
correct thing to do.

Info on credentials:
https://github.com/cybermaggedon/gnucash-uk-vat#credentials

FYI, I have an interest in getting GnuCash working for all my UK business
accounting, I have GnuCash corporation tax filing working and filed my own
corp tax this year. Companies House accounts filing is nearly complete. If
anyone is interested in collaboration on UK business accounting, get in
touch.

Mark.

Date: Fri, 19 Nov 2021 17:52:01 +
> From: mcmurchy1917techy 
> To: gnucash-user 
> Subject: [GNC] UK - Making tax digital
> Message-ID: <81115caa-ae2e-fb67-90b7-79d1451ad...@btinternet.com>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Hi all
>
> In the UK, from April 2022, all VAT registered companies are going to have
> to submit their tax returns receipts
> electronically.
>
> Some while back there was a discussion here on how that can be done.
>
> is there anyone that's managed to achieve this and still use gnucash?
>
> Alex
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Problem changing report configuration location

2021-11-09 Thread Mark Itzcovitz
Yes, that worked, as did two backslashes.

On Tue, 9 Nov 2021 at 11:46, Chris Grinton  wrote:
>
> Consistent with other default settings in the environment file, I am using 
> forward slashes (/) in my GNC_DATA_HOME setting on Windows, not backslashes 
> (\). So if you haven't tried using forward slashes then that would certainly 
> be worth a shot.
>
> Chris
>
> On Tue, 9 Nov 2021 at 22:40, Mark Itzcovitz  wrote:
>>
>> Hi Chris,
>>
>> I tried that and it didn't help.
>>
>> As a test, I changed it to GNC_DATA_HOME={ALLUSERSPROFILE} and it
>> worked.  Are there some rules about the way a path is written with
>> GnuCash on Windows?  Maybe '/' instead of '\'?  I will investigate
>> further, but not just now, I need to get on with the day job.
>>
>> Mark
>>
>> On Tue, 9 Nov 2021 at 10:54, Chris Grinton  wrote:
>> >
>> > I am able to successfully configure my GNC_DATA_HOME setting in the  
>> > C:\Program Files (x86)\gnucash\etc\gnucash\environment file. So maybe try 
>> > configuring the setting in that file instead of the  environment.local 
>> > file.
>> >
>> > On Tue, 9 Nov 2021 at 20:06, Mark Itzcovitz  
>> > wrote:
>> >>
>> >> Hi David,
>> >>
>> >> Thanks for the thought, but that's not the problem.  I changed the
>> >> value of GNC_DATA_HOME to C:\Temp and it still doesn't work.
>> >>
>> >> From Process Monitor I can see that it's reading my environment.local
>> >> but it's going straight to the default location when it opens
>> >> saved-reports-2.8.
>> >>
>> >> Mark
>> >>
>> >> On Tue, 9 Nov 2021 at 01:14, D.  wrote:
>> >> >
>> >> > Mark,
>> >> >
>> >> > I'm no expert, but my experience of the various cloud services under 
>> >> > Windows is that their mappings as folders is not always what they 
>> >> > appear to be. You may be running into some issue related to the 
>> >> > following email on the list earlier: 
>> >> > https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097159.html
>> >> >
>> >> > David
>> >> > 
>> >> > From: Mark Itzcovitz
>> >> > Sent: Mon Nov 08 17:36:44 EST 2021
>> >> > To: gnucash-user@gnucash.org
>> >> > Subject: [GNC] Problem changing report configuration location
>> >> >
>> >> > I'm trying to change the location of the report configuration files,
>> >> > so I can put them on OneDrive to share between machines.  I've created
>> >> > the file environment.local in the same place as the file environment,
>> >> > C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
>> >> > GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
>> >> > I've also created the gnucash_data_home directory.
>> >> >
>> >> > My problem is that GnuCash is still using the file saved-reports-2.8
>> >> > in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
>> >> > might be?
>> >> >
>> >> > As you'll have gathered, I'm running on Windows.  My GnuCash version is 
>> >> > 4.5.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Mark
>> >> > 
>> >> >
>> >> > gnucash-user mailing list
>> >> > gnucash-user@gnucash.org
>> >> > To update your subscription preferences or to unsubscribe:
>> >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> > If you are using Nabble or Gmane, please see 
>> >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> > -
>> >> > Please remember to CC this list on all your replies.
>> >> > You can do this by using Reply-To-List or Reply-All.
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see 
>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Problem changing report configuration location

2021-11-09 Thread Mark Itzcovitz
Hi Chris,

I tried that and it didn't help.

As a test, I changed it to GNC_DATA_HOME={ALLUSERSPROFILE} and it
worked.  Are there some rules about the way a path is written with
GnuCash on Windows?  Maybe '/' instead of '\'?  I will investigate
further, but not just now, I need to get on with the day job.

Mark

On Tue, 9 Nov 2021 at 10:54, Chris Grinton  wrote:
>
> I am able to successfully configure my GNC_DATA_HOME setting in the  
> C:\Program Files (x86)\gnucash\etc\gnucash\environment file. So maybe try 
> configuring the setting in that file instead of the  environment.local file.
>
> On Tue, 9 Nov 2021 at 20:06, Mark Itzcovitz  wrote:
>>
>> Hi David,
>>
>> Thanks for the thought, but that's not the problem.  I changed the
>> value of GNC_DATA_HOME to C:\Temp and it still doesn't work.
>>
>> From Process Monitor I can see that it's reading my environment.local
>> but it's going straight to the default location when it opens
>> saved-reports-2.8.
>>
>> Mark
>>
>> On Tue, 9 Nov 2021 at 01:14, D.  wrote:
>> >
>> > Mark,
>> >
>> > I'm no expert, but my experience of the various cloud services under 
>> > Windows is that their mappings as folders is not always what they appear 
>> > to be. You may be running into some issue related to the following email 
>> > on the list earlier: 
>> > https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097159.html
>> >
>> > David
>> > 
>> > From: Mark Itzcovitz
>> > Sent: Mon Nov 08 17:36:44 EST 2021
>> > To: gnucash-user@gnucash.org
>> > Subject: [GNC] Problem changing report configuration location
>> >
>> > I'm trying to change the location of the report configuration files,
>> > so I can put them on OneDrive to share between machines.  I've created
>> > the file environment.local in the same place as the file environment,
>> > C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
>> > GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
>> > I've also created the gnucash_data_home directory.
>> >
>> > My problem is that GnuCash is still using the file saved-reports-2.8
>> > in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
>> > might be?
>> >
>> > As you'll have gathered, I'm running on Windows.  My GnuCash version is 
>> > 4.5.
>> >
>> > Thanks,
>> >
>> > Mark
>> > 
>> >
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see 
>> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Problem changing report configuration location

2021-11-09 Thread Mark Itzcovitz
Thanks, Geert, I should have noticed that.  However, it didn't solve
the problem - see my answer to Chris for further info...

On Tue, 9 Nov 2021 at 10:59, Geert Janssens  wrote:
>
> Hi,
>
>
> The parameter changes in you environment.local file should be preceeded with 
> the line
>
> [Variables]
>
>
> And only then you can specify the path changes you want.
>
>
> Regards,
>
>
> Geert
>
>
> Op dinsdag 9 november 2021 10:05:03 CET schreef Mark Itzcovitz:
>
> > Hi David,
>
> >
>
> > Thanks for the thought, but that's not the problem.  I changed the
>
> > value of GNC_DATA_HOME to C:\Temp and it still doesn't work.
>
> >
>
> > From Process Monitor I can see that it's reading my environment.local
>
> > but it's going straight to the default location when it opens
>
> > saved-reports-2.8.
>
> >
>
> > Mark
>
> >
>
> > On Tue, 9 Nov 2021 at 01:14, D.  wrote:
>
> > > Mark,
>
> > >
>
> > > I'm no expert, but my experience of the various cloud services under
>
> > > Windows is that their mappings as folders is not always what they appear
>
> > > to be. You may be running into some issue related to the following email
>
> > > on the list earlier:
>
> > > https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097159.html
>
> > >
>
> > > David
>
> > > 
>
> > > From: Mark Itzcovitz
>
> > > Sent: Mon Nov 08 17:36:44 EST 2021
>
> > > To: gnucash-user@gnucash.org
>
> > > Subject: [GNC] Problem changing report configuration location
>
> > >
>
> > > I'm trying to change the location of the report configuration files,
>
> > > so I can put them on OneDrive to share between machines.  I've created
>
> > > the file environment.local in the same place as the file environment,
>
> > > C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
>
> > > GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
>
> > > I've also created the gnucash_data_home directory.
>
> > >
>
> > > My problem is that GnuCash is still using the file saved-reports-2.8
>
> > > in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
>
> > > might be?
>
> > >
>
> > > As you'll have gathered, I'm running on Windows.  My GnuCash version is
>
> > > 4.5.
>
> > >
>
> > > Thanks,
>
> > >
>
> > > Mark
>
> > > 
>
> > >
>
> > > gnucash-user mailing list
>
> > > gnucash-user@gnucash.org
>
> > > To update your subscription preferences or to unsubscribe:
>
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > > If you are using Nabble or Gmane, please see
>
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
>
> > > Please remember to CC this list on all your replies.
>
> > > You can do this by using Reply-To-List or Reply-All.
>
> >
>
> > ___
>
> > gnucash-user mailing list
>
> > gnucash-user@gnucash.org
>
> > To update your subscription preferences or to unsubscribe:
>
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > If you are using Nabble or Gmane, please see
>
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
>
> > Please remember to CC this list on all your replies.
>
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Problem changing report configuration location

2021-11-09 Thread Mark Itzcovitz
Hi David,

Thanks for the thought, but that's not the problem.  I changed the
value of GNC_DATA_HOME to C:\Temp and it still doesn't work.

>From Process Monitor I can see that it's reading my environment.local
but it's going straight to the default location when it opens
saved-reports-2.8.

Mark

On Tue, 9 Nov 2021 at 01:14, D.  wrote:
>
> Mark,
>
> I'm no expert, but my experience of the various cloud services under Windows 
> is that their mappings as folders is not always what they appear to be. You 
> may be running into some issue related to the following email on the list 
> earlier: 
> https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097159.html
>
> David
> ____
> From: Mark Itzcovitz
> Sent: Mon Nov 08 17:36:44 EST 2021
> To: gnucash-user@gnucash.org
> Subject: [GNC] Problem changing report configuration location
>
> I'm trying to change the location of the report configuration files,
> so I can put them on OneDrive to share between machines.  I've created
> the file environment.local in the same place as the file environment,
> C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
> GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
> I've also created the gnucash_data_home directory.
>
> My problem is that GnuCash is still using the file saved-reports-2.8
> in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
> might be?
>
> As you'll have gathered, I'm running on Windows.  My GnuCash version is 4.5.
>
> Thanks,
>
> Mark
> 
>
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Problem changing report configuration location

2021-11-08 Thread Mark Itzcovitz
I'm trying to change the location of the report configuration files,
so I can put them on OneDrive to share between machines.  I've created
the file environment.local in the same place as the file environment,
C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
I've also created the gnucash_data_home directory.

My problem is that GnuCash is still using the file saved-reports-2.8
in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
might be?

As you'll have gathered, I'm running on Windows.  My GnuCash version is 4.5.

Thanks,

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


Re: [GNC] Making Tax Digital (MTD) for Tax Self-Assessment

2021-07-28 Thread Mark
Maf,

I'm prepping to do a DIY corp tax filing next month.  There's a couple of
other repos may be of interest...
- gnucash-ixbrl creates iXBRL reports from GnuCash accounts. I've got this
producing a UK company account and also the corp tax calculation which are
required to be in iXBRL.
- gnucash-uk-corptax takes the above iXBRL files and submits them to the
corptax service. It creates the electronic equivalent of the CT600 record
out of the corp tax calculation.
No warranty.  This all works for me.  Probably.  I'll find out in
September. :)

Oh, just for "fun"...
- ixbrl-to-ct600 writes the numbers into a CT600 PDF so you can print it
out for a paper filing.  Not a huge value to you unless you have exemption
for a paper filing.

Mark.

On Wed, 28 Jul 2021 at 13:19, Maf. King  wrote:

> Hi Mark & Neil.
>
> thanks for highlighting the github repository - looks interesting, I might
> have a play next month..  I've been using a commercial bridgeing
> spreadsheet
> so far for VAT submission of data from GC, I rather anticipate that the
> next
> step (which, AIUI, is not for Corp Tax (yet)) for the self-assessment
> pages
> will allow similar spreadsheet manipulation and submission.  It seems to
> me
> that they are targetting smaller one-man-band type businesses via the
> personal
> tax return.
>
>
> the direction of travel is clear, though!  Digital APIs wherever possible,
> and
> remove a different sort of digit-al mistake - the fat fingered kind!
>
> regards,
> Maf
>
>
> On Wednesday, 28 July 2021 12:48:36 BST Neil Campbell wrote:
> > Hi Mark
> >
> > Thank you for all that background information which I found to be very
> > informative. I hear, and agree with, you about the complexity of UK
> > Taxation system and the practicality of this, but do wonder how the
> > software developers mentioned on HMRC website got MTD status. I expect
> all
> > they did was to get submission of the unadulterated records without year
> > end adjustments etc linked to HMRC via their API. I was not aware of the
> > HMRC motives, so that was interesting. From what you have said, it may be
> > correct to say that the existing P Report would be OK for this
> automatic
> > return. It would just need to be integrated with the HMRC system using
> > their API. But I am not a programmer, so I couldn’t do this.
> >
> > I have put in an enhancement request for this change and will see what
> > happens next. Thank you for your enlightenment.
> >
> > Regards.
> > Neil
> > neilcam...@gmail.com
> >
> > > On 28 Jul 2021, at 12:24, Mark  wrote:
> > >
> > > Hi Neil,
> > >
> > > From what I understand, HMRC's stated aim for Making Tax Digital is to
> > > reduce errors which cost the government tax money. The general approach
> > > consists of (my interpretation): - Making APIs which make it easier for
> > > the right information to be submitted. - Requiring that software
> > > developers that implement the APIs do so by creating submissions
> straight
> > > out of the raw accounts.  Thus, there is no way for the end user to
> > > manipulate the submission data; the data will be accurate (if the
> > > accounts are right) and it's harder to defraud the system.
> > >
> > > I got to see inside the MTD process as I've implemented the MTD VAT
> > > interface for my businesses, taking the account data out of GnuCash. In
> > > order to get this approved for production use, I had an interview with
> an
> > > HMRC engineer, shared my screen and showed the solution at work. It was
> > > relatively painless, but the interviewer wanted to check that the
> general
> > > approach was right, that there was a legal submission containing
> required
> > > text, and that there was no way for the end user to change the
> submitted
> > > data (other than by editing the accounts).  I shared the code on
> GitHub,
> > > Google for gnucash-uk-vat if anyone is interested.
> > >
> > > I would expect that MTD for Corporation Tax submission is going to be
> > > along the same lines i.e. a requirement that the corporation tax return
> > > is automatically derived from accounting records.  I wonder how that
> will
> > > work in reality: VAT accounting is relatively straightforward - the
> same
> > > accounting approach works in lots of different countries. Corporation
> Tax
> > > is a whole different kettle of fish - there are arcane rules specific
> to
> > > the UK: Depreciation, two ways for getting R relief, and the way
> > > profit/loss is shifted between 

Re: [GNC] Making Tax Digital (MTD) for Tax Self-Assessment

2021-07-28 Thread Mark
Hi Neil,

Unlike VAT, the Corporation Tax service is an earlier API, and isn't
currently covered by MTD standards  There is no verification process for
developers to be able to use corp tax. Developers just ask for a 4-digit
vendor ID and that's it.

At the moment, small businesses could use the existing balance sheet and
P to fill in the details in HMRC's free online service, but MTD could
well change all of this.

Mark.

On Wed, 28 Jul 2021 at 12:48, Neil Campbell  wrote:

> Hi Mark
>
> Thank you for all that background information which I found to be very
> informative. I hear, and agree with, you about the complexity of UK
> Taxation system and the practicality of this, but do wonder how the
> software developers mentioned on HMRC website got MTD status. I expect all
> they did was to get submission of the unadulterated records without year
> end adjustments etc linked to HMRC via their API. I was not aware of the
> HMRC motives, so that was interesting. From what you have said, it may be
> correct to say that the existing P Report would be OK for this automatic
> return. It would just need to be integrated with the HMRC system using
> their API. But I am not a programmer, so I couldn’t do this.
>
> I have put in an enhancement request for this change and will see what
> happens next. Thank you for your enlightenment.
>
> Regards.
>
> *neilneilcam...@gmail.com *
>
>
>
> On 28 Jul 2021, at 12:24, Mark  wrote:
>
> Hi Neil,
>
> From what I understand, HMRC's stated aim for Making Tax Digital is to
> reduce errors which cost the government tax money. The general approach
> consists of (my interpretation):
> - Making APIs which make it easier for the right information to be
> submitted.
> - Requiring that software developers that implement the APIs do so by
> creating submissions straight out of the raw accounts.  Thus, there is no
> way for the end user to manipulate the submission data; the data will be
> accurate (if the accounts are right) and it's harder to defraud the system.
>
> I got to see inside the MTD process as I've implemented the MTD VAT
> interface for my businesses, taking the account data out of GnuCash. In
> order to get this approved for production use, I had an interview with an
> HMRC engineer, shared my screen and showed the solution at work. It was
> relatively painless, but the interviewer wanted to check that the general
> approach was right, that there was a legal submission containing required
> text, and that there was no way for the end user to change the submitted
> data (other than by editing the accounts).  I shared the code on GitHub,
> Google for gnucash-uk-vat if anyone is interested.
>
> I would expect that MTD for Corporation Tax submission is going to be
> along the same lines i.e. a requirement that the corporation tax return is
> automatically derived from accounting records.  I wonder how that will work
> in reality: VAT accounting is relatively straightforward - the same
> accounting approach works in lots of different countries. Corporation Tax
> is a whole different kettle of fish - there are arcane rules specific to
> the UK: Depreciation, two ways for getting R relief, and the way
> profit/loss is shifted between tax years to name a few.
>
> Mark.
>
> > From April 2023, new laws in UK will require all businesses with a gross
> income of in excess of £10,000 to keep digital records for Tax returns. I
> think that there are already laws in place for record-keeping and
> submitting VAT digitally direct to HMRC. I am sure that there must be
> thousands of GNUCash users who will be affected.
> >
> > This may seem a long way away, but can one of the developers please
> confirm that GNUCash either complies already (I can’t find anything in the
> Menu’s that relates to VAT or the collection thereof) or the matter is in
> hand and GNUCash will comply before April 2023.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Making Tax Digital (MTD) for Tax Self-Assessment

2021-07-28 Thread Mark
Hi Neil,

From what I understand, HMRC's stated aim for Making Tax Digital is to
reduce errors which cost the government tax money. The general approach
consists of (my interpretation):
- Making APIs which make it easier for the right information to be
submitted.
- Requiring that software developers that implement the APIs do so by
creating submissions straight out of the raw accounts.  Thus, there is no
way for the end user to manipulate the submission data; the data will be
accurate (if the accounts are right) and it's harder to defraud the system.

I got to see inside the MTD process as I've implemented the MTD VAT
interface for my businesses, taking the account data out of GnuCash. In
order to get this approved for production use, I had an interview with an
HMRC engineer, shared my screen and showed the solution at work. It was
relatively painless, but the interviewer wanted to check that the general
approach was right, that there was a legal submission containing required
text, and that there was no way for the end user to change the submitted
data (other than by editing the accounts).  I shared the code on GitHub,
Google for gnucash-uk-vat if anyone is interested.

I would expect that MTD for Corporation Tax submission is going to be along
the same lines i.e. a requirement that the corporation tax return is
automatically derived from accounting records.  I wonder how that will work
in reality: VAT accounting is relatively straightforward - the same
accounting approach works in lots of different countries. Corporation Tax
is a whole different kettle of fish - there are arcane rules specific to
the UK: Depreciation, two ways for getting R relief, and the way
profit/loss is shifted between tax years to name a few.

Mark.

> From April 2023, new laws in UK will require all businesses with a gross
income of in excess of £10,000 to keep digital records for Tax returns. I
think that there are already laws in place for record-keeping and
submitting VAT digitally direct to HMRC. I am sure that there must be
thousands of GNUCash users who will be affected.
>
> This may seem a long way away, but can one of the developers please
confirm that GNUCash either complies already (I can’t find anything in the
Menu’s that relates to VAT or the collection thereof) or the matter is in
hand and GNUCash will comply before April 2023.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] GnuCash, UK accounts, iXBRL

2021-04-02 Thread Mark
For anyone interested, here's a project to create UK accounts from GnuCash
accounts.  Can create HTML documents with iXBRL tags which meet the
Companies House / HMRC taxonomies.

https://github.com/cybermaggedon/gnucash-uk-reports

All in Python, uses the GnuCash Python API.  Sample accounts validate with
Arelle, and also can be loaded into the Workiva viewer.  Maybe output would
work with HMRC submission, haven't taken it that far yet.

Some sample output here:
https://github.com/cybermaggedon/gnucash-uk-reports/blob/master/docs/screenshots.md

Done this for my own personal interest, but if anyone wants assistance or
to share ideas for particular features, happy to discuss.

Share and enjoy,

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


[GNC] stuck tax table object

2021-04-01 Thread Mark Hedges via gnucash-user
Hi GnuCashers,

I created a tax table and accidentally associated it with an expense
account instead of a liability account.

I edited the tax table to point to a liability account instead, and
reposted the invoice.  I also tried deleting the tax table and creating a
new tax table with a different name using the liability account, then
reposting the invoice.  Both times I reset the tax tables when I unposted
the invoice.

I can't delete the unneeded expense account.  It says that it's still
associated with a tax table object under the old tax table name, even
though there is no reference to that tax table name anymore on any invoice
or transaction.

I tried quitting and restarting GnuCash.  No luck.

How do I force it to remove the old tax table object that has no actual
referent?

Thanks.
Mark

--
Mark Hedges
CEO Weird Vibe Inc.
+1 (310) 487-7123
https://weirdvibe.media <http://weirdvibe.media>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] UK specific: MTD - Making Tax Digital

2021-01-29 Thread Mark
My application for HMRC VAT production credentials was approved, so
this project can (in theory) be used to submit VAT returns from
GnuCash:

  https://github.com/cybermaggedon/gnucash-uk-vat

I say "in theory", my company is not VAT registered yet, so other than
testing with an emulator, and the sandbox, I haven't used this in
anger.

I enquired about including the credentials in open-source projects - I
was informed this is OK, this has happened before but I don't know
which projects.

Reading the documentation, if there's any fraud/inappropriate use, the
credentials are going to get pulled by HMRC.  There's not much an
open-source project can do to prevent inappropriate use if a malicious
person chooses to use the credentials inappropriately.  Having said
that, (my day job is security engineer) it's not difficult to get
credentials such as these out of a proprietary desktop or mobile
application in which they're embedded if someone malicious wants to do
that.  A primary defence against abusing somebody else's VAT account
is that VAT users have to elect to trust an application, and can
choose not to.  A secondary defence is the rotation of client secrets
if compromised.

> >* Lots of subquestions in that regard:
*> >* 1. How does HMRC "approve" a bridge for "production" ? And can the code of
*> >* the bridge still
*> >* change after approval without re-approval ?
*>
>
> There is an approval process. Anyone can get credentials on the sandbox
> API, but the approval process applies to getting production credentials.
>  I'm part-way through the process so I haven't seen it to the end yet.
> There are some questionnaires to fill in, and HMRC verify that the API
> usage is correct by looking at logs in the sandbox environment.
>
> There are two types of application: "In-house" is used for an enterprise
> which wants production access to submit their own VAT records. "Retail" is
> used for a developer which creates a VAT product for other people to use.
> I'm part-way through a retail  application.
>
> The API reference is public online, but you get access to more detailed
> documentation by submitting an application for production credentials.
>
>
> >* Is there a check on the resulting binary or do they
*> >* use some other kind of validation ?
*> >>
> No, there is no validation of the binary / code itself.  The HTTP request
> must meet what HMRC call the 'Fraud API' which is a bunch of headers
> describing various things like the hardware, device ID, local IP/MAC
> address, software version, etc. The internal use of these headers is not
> defined, but I guess there's some anomaly detection for fraud/abuse
> purposes.
>
>
> >* 2. Do you intend to keep your bridge as a separate project, to which
*> >* gnucash can interface ?
*> >* Or would you like the functionality to become part of the gnucash code ?
*> >> 3. Will you provide your integration (in whatever form) in a way that it's
> >* compatible with the
*> >* GPL code (under which gnucash is released) ?
*> >>
> The code I published at github.com/cybermaggedon/gnucash-uk-vat is a
> separate bridge which uses the Python API, and licenced under GPL.  I would
> be up for getting involved in an development to integrate a capability with
> Gnucash if there's enough interest.
>
> Mark.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] UK specific: MTD - Making Tax Digital

2021-01-16 Thread Mark
> Lots of subquestions in that regard:
> 1. How does HMRC "approve" a bridge for "production" ? And can the code of
> the bridge still
> change after approval without re-approval ?


There is an approval process. Anyone can get credentials on the sandbox
API, but the approval process applies to getting production credentials.
 I'm part-way through the process so I haven't seen it to the end yet.
There are some questionnaires to fill in, and HMRC verify that the API
usage is correct by looking at logs in the sandbox environment.

There are two types of application: "In-house" is used for an enterprise
which wants production access to submit their own VAT records. "Retail" is
used for a developer which creates a VAT product for other people to use.
I'm part-way through a retail  application.

The API reference is public online, but you get access to more detailed
documentation by submitting an application for production credentials.


> Is there a check on the resulting binary or do they
> use some other kind of validation ?
>

No, there is no validation of the binary / code itself.  The HTTP request
must meet what HMRC call the 'Fraud API' which is a bunch of headers
describing various things like the hardware, device ID, local IP/MAC
address, software version, etc. The internal use of these headers is not
defined, but I guess there's some anomaly detection for fraud/abuse
purposes.


> 2. Do you intend to keep your bridge as a separate project, to which
> gnucash can interface ?
> Or would you like the functionality to become part of the gnucash code ?
>
3. Will you provide your integration (in whatever form) in a way that it's
> compatible with the
> GPL code (under which gnucash is released) ?
>

The code I published at github.com/cybermaggedon/gnucash-uk-vat is a
separate bridge which uses the Python API, and licenced under GPL.  I would
be up for getting involved in an development to integrate a capability with
Gnucash if there's enough interest.

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


Re: [GNC] UK specific: MTD - Making Tax Digital

2021-01-14 Thread Mark
Hi Chris,

FYI, I've got a bridge which takes data out of Gnucash accounts and
submits. It's Python code which  uses the  GnuCash Python modules at the
moment.

https://github.com/cybermaggedon/gnucash-uk-vat

I've initiated a submission to get production credentials which is with
HMRC, we're testing Fraud  API compliance at the moment.

How far did you get? Have you got HMRC production signoff yet?

Mark.

Hi,
> Is anyone interest in having a MTD bridge for GnuCash for VAT submissions?
> I
> have developed a bridge and would be happy to integrate it with GnuCash if
> there is still any interest.
> Kind regards,
> Chris
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Prototype GnuCash accounts for UK HMRC VAT returns (MTD / Making Tax Digital)

2020-12-23 Thread Mark
I've been looking at VAT return submission from GnuCash to prepare for my
own accounts automation.  I've got some prototype code which works with the
HMRC test API on Github.  This is Python scripts which use the GnuCash
Python API and then sends to HMRC APIs:

https://github.com/cybermaggedon/gnucash-uk-vat

This is definitely experimental / prototype stage. I've done as much
testing as it is possible to do with the test APIs (not much).  I'm sharing
this because it could be of interest to others, and to see if anyone else
knows the pitfalls I'm likely to come across working with HMRC APIs.

It's Python but there's no Python packaging, so you just clone the repo and
run in place.  I may take a look at packaging over the Christmas period.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] ASX price lookup failing

2020-10-22 Thread Mark Walters
Thanks Geoff - worked a treat
My only problem was finding the right folder. Flatpak made an interesting
directory - it was about three pages long.

Thanks,
Mark



On Thu, Oct 22, 2020 at 8:27 PM Geoff  wrote:

> Hi Mark
>
> See this thread:
>
> http://gnucash.1415818.n4.nabble.com/GNC-ASX-quotes-not-working-tc4722167.html
>
> Temporary fix attached towards the end.
>
> Regards
>
> Geoff
> =
>
> On 21/10/2020 4:45 pm, Mark Walters wrote:
> > Hi,
> > Is anyone else having trouble with price lookups to the Australian stock
> > exchange?
> >
> > Looks like they updated their website and all price queries now fail.
> >
> > Gnucash v 4.2, finance::quote 1.49
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


  1   2   >