Hi Robert,
Excellent question! I didn't have the answer, but thought I'd google
it, and this is what I found;
https://www.accountingtools.com/articles/accounting-for-gift-cards-gift-certificates
Hope that's helpful.
~mark petryk
~w:http://www.lorimarksolutions.com
On 10/31/24 12:38, Robe
Tested and works, instructions perfect.
~mark petryk
~w:http://www.lorimarksolutions.com
On 10/18/24 16:10, Ken Pyzik wrote:
OK — For Phyllis and Joanna - Please bear with me. I do have a programming
background - so I have to be mindful to not be too technical. This is for
Windows. Steps:
Hi Brook,
I've used doc-links 'a bit' so I have only a few examples.
(see attached)
I can tell you where the links are 'stored' but not how they get there.
You would want to explore the code in the slots/mechanism (sorry I can't
give better source references).
But, as you can see in the att
the first transaction. There are 4 splits, each of which is
represented in the file by 3 duplicate lines.
Cheers,
Brook
On Oct 18, 2024, at 2:17 PM, Mark at Lorimark
wrote:
That shouldn't be. The 'account' column should change for the split.
Normally, a transaction would
esented in the file by 3 duplicate lines.
Cheers,
Brook
On Oct 18, 2024, at 2:17 PM, Mark at Lorimark
wrote:
That shouldn't be. The 'account' column should change for the split.
Normally, a transaction would have 2-lines (2-splits).
Can you send me an excerpt of those lines?
That shouldn't be. The 'account' column should change for the split.
Normally, a transaction would have 2-lines (2-splits).
Can you send me an excerpt of those lines?
~mark petryk
~w:http://www.lorimarksolutions.com
On 10/18/24 15:08, Brook Milligan via gnucash-user wrote:
No, I mean exactly
Brook,
In your export, for any duplicated line, what is that value in the
'account name' column for each of those lines?
~mark petryk
~w:http://www.lorimarksolutions.com
On 10/18/24 13:31, Brook Milligan via gnucash-user wrote:
I’m not sure I understand your answer.
To be more clear, I have
Hi Gere,
The back-end is simply "sqlite". If you can get that installed, then
you can open the gnucash.sqlite files directly and poke around in them.
The flat structure is pretty simple, does not rely heavily on RDBMS.
Here is one reference in the gnucash docs;
https://wiki.gnucash.org/wik
This might have something to do with rendering. I have this as my
command line;
~/bin/gnucash.sh
WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/25/24 17:59, Mark Sattolo wrote:
A few days ago I upgraded from Linux Mint
once again... thank you, sir!
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/24/24 13:38, John Ralls wrote:
Yes.
You might find https://wiki.gnucash.org/wiki/SQL helpful; it has brief
descriptions of each table.
Regards,
John Ralls
On Sep 24, 2024, at 9:54 AM, Mark at Lorimark
Hi,
I'm casually curious about the 'books' table.
sqlite> .schema books
CREATE TABLE books(guid text(32) PRIMARY KEY NOT NULL, root_account_guid
text(32) NOT NULL, root_template_guid text(32) NOT NULL);
sqlite> select * from books;
212f7dc40c094219a08d3b8c1f52d347|dd3701d5f2bb4f55be49248d7b420
Wow! Beautiful, thank you for the code references as well!
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/23/24 12:40, John Ralls wrote:
This applies to the SQL backend only, the XML file has no version
information.
Once you’ve populated the database the versions table should look like
Hi,
I was looking at my back-end data, and find that there is a version
reference there. In my old accounting file that I've been working in
for a while, it shows "Gnucash|413". If I create a new file with no
data, it shows "Gnucash|508".
I'm curious, are there any references on-li
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/18/24 22:30, Chris Miller via gnucash-user wrote:
Hi David,
I don't suppose GnuCash has a transaction list report that could tell us that
quickly?
A simple way to answer this question would be to save the file as SQL,
open the SQL wit
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/19/24 11:27, Chris Miller via gnucash-user wrote:
Hi Roberts,
* Transactional database updates implies multiple user concurrency, but everywhere I hear that multiple
users is "problematic". Certainly this is true with the XML storag
Hi Chris,
I have ~some~ knowledge.
In SQL, these are the 'tables' used for storage;
sqlite> .tables
accounts employees orderstaxtables
billterms entries pricestransactions
books gnclock recurrences
assword. Don't chose a
password that would show up in a password dictionary. And don't pick a
short, simple password. A hacker could point a 'Nix machine with
multiple GPUs at it and get in.
On 9/12/24 14:01, Mark at Lorimark wrote:
use keepass - keep the databa
thing that I want to have
access to wherever I am and whatever I have to reach it.
Keepass allows me to keep the database on my servers, and manage my own
access and security.
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/12/24 13:42, Stephen M. Butler wrote:
On 9/12/24 11:01, Mark a
use keepass - keep the database on your pc
~mark petryk
~w:http://www.lorimarksolutions.com
On 9/12/24 12:57, Stephen M. Butler wrote:
On 9/11/24 23:03, Chris Green wrote:
BTW, who remembers a 1000 character password anyway! I know, use a
password manager -- but then you have to trust that i
Hi Boniforti,
I received this explanation for basic accounting, which helped me a lot
with understanding how to do the 'maths' for the various accounts within
gnucash. I found it very useful, I hope you do as well;
Debit/Credit is just Left/Right. Maybe this will help...
The Accounting Equ
(not an accountant)
That sounds like 'barter' which should probably not be on the books?
~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com
On 8/29/24 17:09, Eric Hammond wrote:
Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org
To subscribe or unsubs
Hi Ron,
Go to edit-> pref-> import and read what the 'default transaction
status' is set to.
~mark petryk
~w:http://www.lorimarksolutions.com
On 8/13/24 08:47, Ronald Solomon wrote:
I am just starting with Gnucash. I was importing transactions one month at
a time. January and February of 202
(not sure)
I think if you hit "Help-> About" it will display the paths that are in use.
~mark petryk
~w:http://www.lorimarksolutions.com
On 8/11/24 10:09, Mahon Finbar via gnucash-user wrote:
Hi,
I have a Lenovo with Windows 10, with GNUCash, I want to change GNUCash
and current files to a L
CP/M... oh my! Cut my teeth on T.E.I. computers with CP/M. *sigh*
good times!
~mark petryk
~w:http://www.lorimarksolutions.com
On 8/5/24 14:29, Michael Hendry wrote:
Are you a genealogy addict too, John?
I built a Nascom 2 Z80 machine in 1979, with Microsoft BASIC and a cassette
tape drive
do not know, sir, but I will find out :)
~mark petryk
~w:http://www.lorimarksolutions.com
On 8/1/24 16:28, David Cousens wrote:
Mark there is a preference setting on the Edit->_Preferences_->Import
tab that sets the default status on imported transactions What was that
setting at during the im
Hi Steve, yes but this seems like it's setting the R to 'y' which is
really odd to me. I can see setting it to 'c', but not 'y'.
Thank you for your reply.
~mark petryk
~w:http://www.lorimarksolutions.com
On 8/1/24 14:01, Stephen M. Butler wrote:
On 8
Helping someone out with their new GnuCash experience, regarding
importing and reconciliation. He reports that after an import, the
reconciliation balances are off, and the account balances are off.
I looked at his register, and he had reconciled 5 months or so, and then
following those recon
Yea... never mind!
The original BUG does not reference anything in this Jira email...
Probably just a coincidence.
~mark petryk
~w:http://www.lorimarksolutions.com
On 7/31/24 16:49, Mark at Lorimark wrote:
That kind-of looks like the gnucash email server has Jira hooked in to
it somewhere
That kind-of looks like the gnucash email server has Jira hooked in to
it somewhere...
~mark petryk
~w:http://www.lorimarksolutions.com
On 7/31/24 16:45, Derek Atkins wrote:
I don't think this has anything to do with us.
We don't use Jira.
-derek
Sent using my mobile device. Please excuse an
grab a screen recorder (or your cell phone) and see if you can capture it.
(I have set my phone on slo-mo-record, that works.
~mark petryk
~w:http://www.lorimarksolutions.com
On 7/22/24 12:54, Art Chimes wrote:
Original Poster here. Running Gnucash Version: 5.6 / Build ID: 5.6+(2024-03-30)
Win
(not an accountant)
I think you can make your one (1) payment to the bank, and then split
the portions of that payment for each card;
account DrCr
Bank $1000
CC1 $400
CC2 $600
So you're writing out one check and paying it towards the two credit
card
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@gnucas
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 regis
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 th
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
__
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.lo
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://ww
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 impo
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
gn
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
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
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_DISABL
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
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
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.
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
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 success
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,
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 acc
pens 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
On 1/11/24 13:00, Jack Slater wrote:
Is there a way I post the image?
___
gnucash-user mailing list
gnucash-user@gnuc
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
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.c
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-u
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
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 colo
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
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 sixt
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 on
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.
Attach
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, D
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]
_
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___
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 ca
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
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 rememb
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
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
mi
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
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
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 ar
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,
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
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 ac
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
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 ra
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 expens
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 subs
.. 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
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
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 star
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
___
82 matches
Mail list logo
