The easiest way would be saving the spreadsheet to .csv format and importing
that to Gnucash.
Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file
to a digest (and harder to do it wrong!).
Should be possible making the link address
‘mailto:gnucash-user@gnucash.org?subject=Previous subject string’. Just don’t
know if it is possible with mailman.
Thanks and regards,
Matt
From: Matt Graham<mailto:matt_graham2...@hotmail.com>
Sent: Wed
;
Sent: Tuesday, 13 February 2018 5:49 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Users replying to digest rather than starting a new thread
On Sun, 11 Feb 2018 05:29:13 +
Matt Graham <matt_graham2...@hotmail.com> wrote:
> Probably stupid ques
https://wiki.gnucash.org/wiki/Inventory_Handling
This issue must have come up before. The wiki could ideally use some discussion
about separation of inventory and accounting systems. I imagine for a small
business that just wants to keep track of a few things they would want them
both
Probably stupid question – is there a way to set rules on the gnucash-user
account?
Ie anytime someone sends an email that starts with “Re gnucash-user Digest”,
the system rejects their email with a response along the lines of “Please do
not reply to the digest without changing the subject
y 2018 4:27 PM
To: Matt Graham<mailto:matt_graham2...@hotmail.com>
Cc: Adrien Monteleone<mailto:adrien.montele...@gmail.com>;
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Cash Flow View
Matt,
The wiki can always use help, so thank you! I think your
The only other thing to add - this all presumes that you need separation.
Probably do for your businesses (tax and legal reasons - I have no idea), but
don't forget that GNUCash reports are very flexible - you choose the accounts
you want included.
I don't use the business features though -
So there really is more than one way to skin a cat... or make a budget.
Whatever.
Since we are talking about something very personal to the needs of individuals,
perhaps Gnucash needs a ‘add module’ system, where we can write modules that
perform data access and manipulation? So we could write
-admin<mailto:bmclar...@comcast.net>
Sent: Monday, 5 February 2018 4:59 AM
To: Matt Graham<mailto:matt_graham2...@hotmail.com>
Subject: Re: Entering Budget Values
Matt,
Hierarchy is good. "no cells" means that I would expect to see cells like on an
excel spreadsheet but there
Welcome to the discussion!
So if I understand correctly, you have written scripts to automate the use of
extra accounts to track allocated money? That was the line I was going down too
(except building them into GNUCash), but Chris Lam’s discussion on “Budget
transactions” is starting to look
in Balance Sheet reports, then I’d just opt to use asset sub-accounts
as I already outlined.
Best of luck to you.
Regards,
Adrien
> On Jan 30, 2018, at 5:05 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Again, thank you Adrien for being patient with me. I’m probably
omething to balance them, you
might as well male them Subaccounts of checking anyway.
Cheers,
David
On Wed, Jan 31, 2018 at 4:06, Matt Graham
<matt_graham2...@hotmail.com>
[Snip]
If, rather than a sub-account, I use a separate asset account then there is no
balancing Cr to an asset to in
here and
how do you record the receipt of money as a credit to an asset instead and how
does that balance against your credit to your income account?
i.e.—
Dr. $1000
Cr. Income:Salary $1000
Cr. Assets:??
Regards,
Adrien
> On Jan 29, 2018, a
Hi Mike,
So if I understand correctly from looking through the email chains:
1. You had everything entered into the mobile app
2. You exported from the mobile app and hit the bug where splits lose their
values in the export
3. You imported all the transactions into GNUCash desktop in a
tt
Original message
From: Mike or Penny Novack <stepbystepf...@dialup4less.com>
Date: 30/1/18 09:31 (GMT+10:00)
To: Matt Graham <matt_graham2...@hotmail.com>
Cc: gnucash-user@gnucash.org
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]
On 1/28/2
you’re in the habit of spending from any ole’ source for any ole’
purpose then by all means, keep the sub-accounts separate, you’ll just have to
include the transfer split in the expense transaction or else do a separate
transfer transaction.
Regards,
Adrien
> On Jan 27, 2018, at 9:25 PM, Matt
[WAS Re: Future allocated money vs Budgets]
On 1/27/2018 10:25 PM, Matt Graham wrote:
> Nice! It seems like we are getting somewhere. I am convinced that the process
> we think of budgeting where we are saving up for something is really a case
> of segmenting money within a sub-account.
I find the android app useful, exporting transactions by qif file and then
bringing them into my desktop app. It is very limited, as you say. Really needs
to implement proper access to the ".gnucash" files so that we can keep the two
in sync easily.
Pretty sure that app is also open source on
Nice! It seems like we are getting somewhere. I am convinced that the process
we think of budgeting where we are saving up for something is really a case of
segmenting money within a sub-account. And it looks like Gnucash is already
happy with this kind of situation - with the include
icture stuff.
Regards,
Adrien
> On Jan 25, 2018, at 9:29 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Hi All!
> I’m going to discuss (and get people’s opinions) on a way in which many users
> (myself included) struggle to get “what they want” from GNUCash budgeting.
&
20 matches
Mail list logo