Hi
I am relatively new so am trying to understand some of the concepts.
I have created a single Gnucash file for my household accounts. So this
includes my personal account, my wife's personal account and our joint
account.
I want to produce a report which shows the income / expenditure for my
On Wednesday, 12 July 2017 09:19:01 BST Matthew wrote:
>> Hi
>>
>> I am relatively new so am trying to understand some of the concepts.
>>
>> I have created a single Gnucash file for my household accounts. So this
>> includes my personal account, my wife
hanks
Matt
On 12/07/17 13:43, Maf. King wrote:
> On Wednesday, 12 July 2017 12:17:38 BST Matthew wrote:
>> Hi Maf
>>
>> That's just what I was looking for - thanks.
>>
>> As a best practice, is it better to keep all accounts in one GC File, or
>> to split a
I just received an update to gnucash of Build ID:
5.10-unknown-commit(2025-01-19)
I can't see any reference to this build on the website, etc. I wanted to
verify if this was a legit update or not. It came through my distro's extra
repo.
thank you.
___
g
I originally wrote and sent this on November 28, but I wasn't subscribed to
the mailing list yet so I don't think it went through. Since then I have
contacted DigiCert and they have revoked the code signing certificate.
Original email follows.
I saw a Google search ad for GNU Cash which is a malwa
to
actually implement it.
More dialog about what a truly generic multi-currency accounting product might
look like I think would be interesting even if it never does get implemented
for another 20 years.
Regards,
Matthew
> On Dec 10, 2021, at 1:30 PM, davidcousen...@gmail.com wrote:
>
>
.
It would be one thing if you can’t set these things up with out internet or
don’t have access to all the bells and whistles but you shouldn’t lose the
ability to the primary function because the internet goes down when trying to
use them locally.
Ok I’m done just wanted to share.
Matthew
I have used gnucash for a few years, and have all of my investments sorted
by account. To understand how my investments are distributed, it would be
very convenient for me to have a report that computes the percentage of
certain investments in the whole, e.g., the percent that is bonds. Is it
possi
Hey Richard and Guillermo,
Thanks for your suggestions. I will try exporting the data and using
another tool.
Sincerely,
Matthew
On Sun, Mar 26, 2023, 04:20 Guille Lopez wrote:
> Hello,
>
> For this purpose, one could also use a portfolio tracking specific tool
> such as https://w
still cannot select my target destination account.
Has anybody experienced this issue?
I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu system.
Thanks,
Matthew
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
Dear All,
Thank you all for your help. After changing all account types to "Cash"
(right click -> Edit Account -> select "Cash" for Account Type), I was able
to merge them. Previously, the new account I created was just an "Asset",
not "Cash"!
Thank
This is more of an accounting question than a GnuCash question; what I would
like to know is how to handle this within GnuCash. I’m sure that this situation
isn’t unique, and there is probably a standard way of handling it in accounting.
I am maintaining the checkbook for a club account. Several
Gnucash 3.5-1 running on a MacBook Pro under macOS 10.14.6. I’m been using
Gnucash for years for very simple accounting, primarily just maintaining a
checkbook register. Today I had trouble reconciling a bank statement. After
clicking “Finish” the reconciled transactions had a “y” in the appropr
> From: Matthew Lybanon
> Subject: [GNC] Lost Data
> Date: January 7, 2020 at 4:31:14 PM CST
> To: " User"
>
>
> Gnucash 3.5-1 running on a MacBook Pro under macOS 10.14.6. I’m been using
> Gnucash for years for very simple accounting, primarily just maintain
can open it. If that
doesn’t work then I don’t think it will hurt to reinstall Gnucash.app and see
if that solves the problem.
Begin forwarded message:
> From: David Cousens
> Subject: Re: [GNC] Lost Data
> Date: January 7, 2020 at 11:13:18 PM CST
> To: Matthew Lybanon
see
"Share" or "Price" as options. I'd like to set the "Share" and "Price"
columns, and then have Gnucash calculate the "Buy"/"Sell" price and
the "Balance" of shares after the transaction.
Sincerely,
Matthew
___
port such a CSV file, would I import it for the stock
account, or maybe it doesn't matter?
Thank you very much for your time and help.
Sincerely,
Matthew
On Mon, May 4, 2020 at 7:09 AM Geert Janssens
wrote:
>
> Op maandag 4 mei 2020 02:36:58 CEST schreef Matthew Clay:
>
> > Dear
actually "flows" into and out of a selected account(s) with split
transactions, or is it on the user to mentally keep track of this?
Maybe there is another kind of report that can do this? Thank you for
your time and help.
Sincerely,
Matthew Clay
___
gnu
lts with the statements from
my financial institution (e.g., the fractional number of shares over
many statements is still correct, etc.). In order to get to this
point, however, I had to write some python code to process the
thousands of transactions in the csv file. It would be great if in the
fu
how to add a column to the chart
of accounts. I found the answer in chapter 10 of the gnucash-guide.pdf,
in case anyone else is looking. There's a little down arrow on the top
right corner of the accounts window that gives more display options.
Adding my thanks!
~Matthew
On 3/20/19
es in
alphabetical order. Any suggestions on how to organize the accounts? I
have a tree structure, but when they're on the same level, how do I
change the order they appear?
Thanks!
~Matthew
___
gnucash-user mailing list
gnucash-user@gnucash.org
To u
f just having the name
displayed.
For example, under expenses, I may want the two or three largest and
most active accounts at the top of the list, and the other small or
inactive expense accounts below in alphabetical order.
~Matthew
On 3/29/19 12:19 PM, Colin Law wrote:
Click on the the Acc
I had an "Opening Balance" sub-account under Equity. I haven't touched
it, but I recently noticed the account has disappeared from my account
tree. When looking at the accounts homepage, the money is still on the
Equity account line. But when I click the triangle to view
sub-accounts, it's n
Hi all.
I work in a bit of an edge case, in that I have a very large desktop (just
shy of 7k pixels wide, over 1.5 meters of physical distance). The main
gnucash window seems to save its location and always open where it was last
closed. This is awesome. However, nearly every other window (I th
On 21 September 2017 at 09:50, Phil Longstaff
wrote:
> I find envelope budgeting good for some expense types but not as good for
> others. For something like groceries or rent which are even over the year,
> it is good. For something like a trip which has 0 expense for most months
> but a large e
On 25 September 2017 at 10:57, wrote:
> Is there a way to tell GnuCash to process a scheduled transaction early
> other than to chance the date of each transaction? Some months I would like
> to do my monthly accounting earlier than the first of the month. Only way I
> have found to do that is to
On 25 September 2017 at 22:20, Explorare H. David
wrote:
> So the best solution for me is to make a scheduled payment after I got
> CC bill? This would help me a lot, I think. And "Future Minimum" is a
> useful feature.
>
> If you're talking about creating that each time you receive a bill, then
On 10 October 2017 at 15:15, Carsten Rinke wrote:
> Hi Ben,
>
> what do you mean by machine specific?
>
> If you transfer your gnucash data file between machines, I thought it
> should also possible to transfer the saved-reports-2.x file between the
> machines.
>
It probably is, but it's not tri
On 20 December 2017 at 14:40, jcnw wrote:
> I am setting up our church books on GNUCash and wonder how to handle
> restricted funds.
> For example if a member makes a donation to The Organ Fund
>
> I'd suggest adding it to a subaccount of whatever actual account the funds
are deposited to.
e.g.
On 3 January 2018 at 13:28, Derek Atkins wrote:
> Hi,
>
> rj ruble writes:
>
> > How can I print my accounts to hard copy?
>
> Generate the appropriate report that shows the accounts as you want, and
> then you can print the report.
>
>
Is there a report that reproduces a Basic, Auto-Split, or T
I am not an accountant.. or even a bookkeeper.. but here's how I deal with
RRSPs.
>
>> For me, the RRSPs have been converted to Income Funds, but the principle
> and procedure are still the same. Contribution is straightforward: from a
> Current Asset account to the RRSP, like this:
>
> Assets:Cu
On 3 January 2018 at 22:11, Cam Ellison wrote:
>
>> The examples I used were (perhaps over-) simplifications. In practice, I
> actually have a number of stocks and money market accounts within two RIFs,
> like so:
>
> Assets:investments:RIF:Stock1
> Assets:Investments:RIF:Stock2
> Assets:Investme
On 21 March 2018 at 22:29, BPleasantHill wrote:
> Hi:
>
> I am new to GnuCash and am converting from Quicken.
>
> *Problem Summary*
> I created a checking account, set a starting balance, and imported my
> quicken QIF file. Then I adjusted the Opening Balance. Everything is OK.
> Finally I entere
On 23 March 2018 at 00:35, Geert Janssens
wrote:
>
> Ideally this would become part of libgnucash in order to make the report
> generation platform independent as well (and hence opening the way to make
> it
> accessible one day on android or osx platforms). This will only be
> possible at
> the
On 23 March 2018 at 11:59, John Ralls wrote:
>
>
> On Mar 23, 2018, at 8:34 AM, Matthew Pounsett wrote:
>
> On 23 March 2018 at 00:35, Geert Janssens
> wrote:
>
>
> Ideally this would become part of libgnucash in order to make the report
> generation platform
te tax accordingly. This works, but it
is cumbersome.
--
Matthew
___
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
On 03/28/2018 07:50 AM, Mike or Penny Novack wrote:
On 3/27/2018 6:28 PM, Matthew Pressly wrote:
Our state tax laws are such that most of the work that I do is
considered "data processing" of which 20% is exempt and 80% is
taxable. Is there a good way to configure GnuCash to handle
On 8 April 2018 at 13:13, John Ralls wrote:
>
> In the meantime there are four alternatives for custom reports:
> 2. Learn SQL and use a SQL backend to extract the data you want. The
> results are generally amenable to import into a spreadsheet for further
> processing; you could also install the
On 10 April 2018 at 11:45, Amish wrote:
> May be fastest and easiest way would be to first save sample data (say
> only 1 transaction) to say PostgreSQL database and then use pg_dump to dump
> it to text file.
>
> That's an approach, for sure. However... there are 24 tables just in my
personal
Thanks very much to William, David, and Sébastien for those links. That's
all the documentation I could want.
Cheers!
Matt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists
On 13 April 2018 at 11:11, Ankur Sinha wrote:
> I've a query regarding placeholder accounts in the budget view too. My
> "dining" account has two sub accounts: "drinks", and "food", for
> example. Dining is a "placeholder" account and the values associated
> with it show in light grey colour in t
On 4 May 2018 at 04:13, Gio Bacareza wrote:
> Hi,
>
> My partner and I are moving in together and we'd like to share expenses
> like groceries, rent, etc. So we'd like to track expenses as well as our
> appropriate contributions to make sure that we both are contributing
> equally to house expens
On 4 May 2018 at 09:05, Mike or Penny Novack wrote:
> On 5/4/2018 4:13 AM, Gio Bacareza wrote:
>
>> Hi,
>>
>> My partner and I are moving in together and we'd like to share expenses
>> like groceries, rent, etc. So we'd like to track expenses as well as our
>> appropriate contributions to make su
I'm just starting to use the business functions of GnuCash.. most things
I've sorted out fairly easily, but I'm having issues figuring out the best
way to use Employee expense vouchers.
The intended use looks pretty straightforward: enter line items attached to
the appropriate expense account, pos
On 22 May 2018 at 18:21, Rich Shepard wrote:
> On Tue, 22 May 2018, Matthew Pounsett wrote:
>
> So.. I'd like to assign employee expenses to some other account type, and
>> enter the receipts as vendor bills. I'm trying to decide how to tie the
>> two together
On 22 May 2018 at 18:59, Rich Shepard wrote:
> I'm confused by the above. Do you get a bill from a vendor (e.g., Office
> Depot) for something, and an expense voucher from an employee for the same
> item?
>
No, I have an expense item from an employee which they need to be
reimbursed for. The
On 22 May 2018 at 19:20, Adrien Monteleone
wrote:
> Matt,
>
> There are others using vouchers on this list as I’ve seen threads on the
> tax issue before. Try a list search and you might find something helpful.
> (prefix your search terms with ’site:lists.gnucash.org’ without the
> quotes)
>
> On
On 22 May 2018 at 19:36, Adrien Monteleone
wrote:
> Sales Tax on sales is *not* an expense or revenue. You shouldn’t need to
> balance it against anything. It’s a pass-through liability.‡ It should have
> no bearing on your books other than you have to collect it and remit it.
>
Sales tax on sal
I've got an off-by-a-cent error on an invoice due to the way taxes are
calculated. GnuCash (2.6.21) is calculating the tax on each individual
taxable item, then summing that up, and adding that value to the subtotal.
This causes an error because each individual tax calculation is rounded
prior to
On 22 May 2018 at 21:02, Adrien Monteleone
wrote:
>
>
> >
> > There isn't a way to make a line item in an employee voucher taxable (no
> taxable checkbox, and no field to specify a tax table). But with a bit of
> math I could reduce the unit price of a taxable item and then add a tax
> line afte
Thanks for all your replies. If just the people who have replied in the
last 12 hours is any indication, then a lot of people are "living with" a
fairly annoying bug.
In my case, this is on an invoice I'm generating, not a bill, so I don't
feel like I can mess with the data too much. Fortunately
After setting up my tax tables I realized it would be best if I renamed one
of the tables I had already created and used, but there is no rename
function. So, I created a new table using the name I wanted, and went
through each Vendor Bill that used the old table (there are only two) to
unpost, ch
On 25 May 2018 at 11:33, Geert Janssens wrote:
> Op vrijdag 25 mei 2018 17:29:04 CEST schreef Derek Atkins:
> > I thought the name was changeable? I'm not sure why it wouldn't be.
>
> I think it's not. I happened to be searching for that as well a few days
> back.
> Probably an omission ?
>
> Ye
I have clients that get billed in their home currency. I see what looks
like multiple bugs in handling this in GnuCash, and so I think maybe I'm
doing something wrong.
I have the following accounts in a test file where the default currency is
CAD. Notes about each account's configuration in pare
On 1 June 2018 at 09:33, Matthew Pounsett wrote:
>
>
> Have I missed something?
>
> Apparently I have.. I missed the Currency setting in the customer setup.
The odd thing is that I specifically went and looked for that. But didn't
find it until after I hit send on the
A short aside.. I think there may still be a bug here.
Even though Assets:Accounts Receivable is set to Placeholder, it gets
offered as a choice for posting to when I'm posting an invoice... only when
I try to post to it I get an error that I'm trying to post to a placeholder
account. It should p
.
>
> But if you can do as I suppose, you could eliminate the complication of
> extra accounts and the placeholder issue and just use the A/R account as
> normal. (save for the conversions done for foreign billing and the
> conversion on several reports)
>
> Regards,
> Adri
I'm entering an employee expense voucher that includes some receipts that
are billable back to a customer. If I'm reading the documentation
correctly, I should be able to enter a customer name in the "Default
chargeback project - Customer" field, and then mark individual line items
as billable in
Sorry, I failed to note I'm seeing this issue in GnuCash 2.6.21 on MacOS
10.13.3
On 8 June 2018 at 20:41, Matthew Pounsett wrote:
> I'm entering an employee expense voucher that includes some receipts that
> are billable back to a customer. If I'm reading the documen
On 9 June 2018 at 03:40, Christoph R
wrote:
> Hi Matthew,
>
> You need to first press the button “Edit Invoice”. Then you can change the
> customer.
>
> Aha! Thanks!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update
My clients typically pay me by wire, and when my bank presents the
transaction it's as the received wire and their service fee as a single
line item in my statement. My inclination is to modify the split created
by "process payment" and add the service fee to it rather than add the
service fee as
On 10 June 2018 at 06:22, Geert Janssens wrote:
> Op zaterdag 9 juni 2018 15:50:13 CEST schreef Matthew Pounsett:
> > My clients typically pay me by wire, and when my bank presents the
> > transaction it's as the received wire and their service fee as a single
> > line
I accidentally flubbed some keyboard entry while putting together an
invoice and messed up a billable expense item which had been automatically
added when the invoice was created. Since there is no "Undo" the best
option seemed to be to delete the entry and start over, but I can't find a
way to in
On 6 September 2018 at 12:04, Derek Atkins wrote:
> Matthew Pounsett writes:
>
> > I accidentally flubbed some keyboard entry while putting together an
> > invoice and messed up a billable expense item which had been
> automatically
> > added when the invoice was
I have cases with both billable employee expenses (vouchers) and billable
purchases (vendor bills) which need to go on customer invoices. This is
fairly straight forward... the problem I'm having is how to deal with these
when the currency I'm entering the voucher or bill in is not the same as
th
On Tue, 6 Nov 2018 at 12:22, Geert Janssens
wrote:
> I believe you have just pushed the boundaries of what to do with invoices
> further than anyone ever could have imagined :)
>
Good? :)
>
> I don't think anyone so far ever considered the case of having billable
> expenses in a different curr
On Tue, 6 Nov 2018 at 15:30, Christian Kluge wrote:
> > The currency logic is pretty simple: every amount you see in the invoice
> > entries is assumed to be in the customer's default currency. They income
> > account for each entry can be in a currency different from the invoice
> > account. In
On 31 August 2017 at 12:27, John Ralls wrote:
>
>
> It also doesn't make backups, so unless the user does there's no way to
> roll back to an earlier state. Since all changes are immediately written to
> storage there's also no way to abandon a bunch of changes by quitting
> without saving.
>
> I
I've been poking around in GnuCash trying to find a way to report on the
high balance for a list of accounts in a given period. This would be
hugely helpful in FBAR reporting (Foreign Bank and Financial Accounting
Report) for the IRS.
I imagine I'm going to need to look into writing custom report
On 31 August 2017 at 13:33, Geert Janssens
wrote:
>
> While these solutions will work most of the time they all have the same
> risk:
> if the snapshot is made while gnucash is updating the db, you end up with
> an
> inconsistent db file. I don't know how well sqlite3 handles this so the
> risk
>
On 31 August 2017 at 14:29, John Ralls wrote:
>
>
> There's no report that does it directly, but you can get there by running
> the Asset Barchart report on just the one account with the appropriate date
> range, frequency set to "day" and show table checked.
>
Hmm.. a bit awkward, but it'd work
On 31 August 2017 at 22:58, John Ralls wrote:
>
>
> > On Aug 31, 2017, at 2:36 PM, Mike or Penny Novack <
> stepbystepf...@dialup4less.com> wrote:
> >
> > Are folks saying that sqlite3 does NOT come with a backup/restore
> utility? I would think that at least somewhat strange.
>
> Not a bit. I ju
ke
gnucash-cli --quotes dump yahooweb AAPL
be saved to text files and later imported into a gnucash file?
Thanks,
Matthew
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnu
ine
Quotes" for each batch of securities.
Sincerely,
Matthew
On Fri, Jun 6, 2025 at 12:39 AM sunfis...@yahoo.com
wrote:
> You can import prices as an option on the File->Import menu.
>
> It is relatively easy (for example) to create a spreadsheet in Google
> which has live pr
emailing as recommended on:
https://wiki.gnucash.org/wiki/Budget_Requirements.
Auto populate or initiate a new budget based on current balances and
scheduled transactions. Prior transaction analysis doesn't work for new
users (without lots of imports from their bank and reconciling, maybe).
I'm fully in agreement of making the description column behave like all the
others.
Matt
On Thursday, January 5, 2023 at 09:41:58 PM CST, john
wrote:
Users,
There have been occasional complaints for many years about column width sizing.
See for e.g. https://bugs.gnucash.org/show_bug.
Hi All,
JRalls authored a patch not too long ago that was around trading accounts and
not finding the correct trading account when it wasn't at the top level, so it
created a second one. It will be included in 4.6. This scenario sounds pretty
similiar and I wonder if this is related.
Bug:
Just because I was curious and had time on my hands, some digging into git
looks like the binary file support was removed sometime during the development
of 2.2, so the 2.0 series looks to be the last version that would read the old
binary files. In case anyone is curious, here is the commit:
I've actually found that sometimes it's easier to retrieve quotes and import
through the CSV importer instead of trying to add price quotes on a cron job.
If you have already set up and alphavantage account, I've found that with a
little powershell, I can easily retrieve the historical prices g
Colin,
For some reason the original email you sent through to the list in reply didn't
make it to my email inbox, I just happened to see it referenced in a different
email. For your benefit and everyone else, where is the powershell script I am
using to retrieve quotes from Alphavantage for a
Hi All,
I'm sure it's somewhere that I'm overlooking, but I can't find where to turn
off the reconcile window that opens automatically when importing an OFX file. I
know there was some discussion on the development list about the reconcile
window automatically popping up when importing an OFX f
action matching dialog
(the one that opens after you select the OFX file).
J.
On 6/29/2020 5:50 PM, Matthew Forbis via gnucash-user wrote:
> Hi All,
>
> I'm sure it's somewhere that I'm overlooking, but I can't find where to turn
> off the reconcile window that
It's probably bug https://bugs.gnucash.org/show_bug.cgi?id=797283. I had
started looking at it and then life got in the way. It's been a difficult one
to figure out the actual cause.
Matt
On Friday, November 8, 2019, 9:06:08 AM CST, baruch95
wrote:
Gnucash 3.7 (64 bit), Windows 10
I'm going to add a contrary example as to why I create an imbalance split semi
regularly in my books. This is an easy way to keep the transaction balanced if
you don't have all the information at the time you need when you add a
transaction. The common scenario for me is my paycheck. Our comp
Sending to list from correct email address.
The Average Balance report would seem to have merit in my mind, such as
tracking a portfolio over time, but I decided to test it to see what it's
capable of. In my testing, I found it can be rmostly eplicated by using the
Net Worth linechart graph (
idden soon, but IMHO the networth
linechart taking 1 minute is still an interesting issue and I'd be keen to know
why.
On Sat, 18 May 2019 at 18:33, Matthew Forbis via gnucash-user
wrote:
> Sending to list from correct email address.
> The Average Balance report would seem to have m
Resending my response since I sent from the wrong email address.
I've always been able to just edit the transaction while the reconcile window
is still open. I just switch over to the register window, make my changes and
switch back. I believe there might even be an option to edit the tran
87 matches
Mail list logo
