Re: importing splits

2018-02-20 Thread Matt Graham
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 fir

RE: Users replying to digest rather than starting a new thread

2018-02-13 Thread Matt Graham
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

RE: Users replying to digest rather than starting a new thread

2018-02-13 Thread Matt Graham
; 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 wrote: > Probably stupid question – is there a way to set rules on the

RE: inventory management examples or links

2018-02-13 Thread Matt Graham
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 integrate

Users replying to digest rather than starting a new thread

2018-02-10 Thread Matt Graham
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 line

The Wiki, and documentation

2018-02-08 Thread Matt Graham
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

RE: Cash Flow View

2018-02-08 Thread Matt Graham
G’day All, I was thinking about what Adrien said in a past email: “Many questions lately seem to be asked a bit too quickly.”. I agree – I sometimes wonder whether people do a simple google before asking. Still, when I tried to go onto the GNUCash FAQ wiki to find the answer and send it to som

Re: New Entities

2018-02-06 Thread Matt Graham
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 - I'm

RE: Future allocated money vs Budgets

2018-02-04 Thread Matt Graham
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

RE: Entering Budget Values

2018-02-04 Thread Matt Graham
-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 aren

RE: Future allocated money vs Budgets

2018-02-03 Thread Matt Graham
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 t

RE: Entering Budget Values

2018-02-03 Thread Matt Graham
Hi Bruce! Have you established your account hierarchy? The budget view should mirror your normal account hierarchy and allow you to enter values against each time period. So when you say ‘no cells’, do you mean you can see the accounts on the left and the periods along the top? Additionally, d

Re: Please remove me from the mailing list

2018-01-31 Thread Matt Graham
Sorry, you are probably all sick of this thread, but can the unsubscribe process send an email to the person unsubscribing to tell them "if you have a third party mail thing like Nabble, make sure you unsubscribe there or you'll keep getting messages " Thanks and regards, Matt Origi

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-30 Thread Matt Graham
cial accounts 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 wrote: > > Again, thank you Adrien for being patient with me. I’m probably getting > myself confu

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-30 Thread Matt Graham
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 [Snip] If, rather than a sub-account, I use a separate asset account then there is no balancing Cr to an asset to increase the allocation. In your example,

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-30 Thread Matt Graham
other money allocations (eg restaurants/cafe) I wouldnt change > it - underspending means the money is available for later. > > Am I understanding you right? > > > Thanks and regards, > Matt > > > Original message > From: Mike or Penny N

RE: Merging Files or Other Method getting Transactions into main File.

2018-01-30 Thread Matt Graham
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

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-29 Thread Matt Graham
tt Original message From: Mike or Penny Novack Date: 30/1/18 09:31 (GMT+10:00) To: Matt Graham Cc: gnucash-user@gnucash.org Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets] On 1/28/2018 8:11 PM, Matt Graham wrote: When you look at what liabilities

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-28 Thread Matt Graham
n the real world. Regards, Adrien > On Jan 28, 2018, at 7:11 PM, Matt Graham wrote: > > :-) you missed one of the previous posts. Using Liability accounts that way > is adding anoter "layer" of accounting to your system. When you look at what > liabilities really are, Ad

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-28 Thread Matt Graham
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 Graham wrote: > > Nice! It seems like

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-28 Thread Matt Graham
dgets] 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. And it looks like Gnucash is > a

Re: Does anyone successfully use GNU Android App. If not get it off the main web site.

2018-01-28 Thread Matt Graham
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 g

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-27 Thread Matt Graham
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 sub-accoun

RE: Future allocated money vs Budgets

2018-01-25 Thread Matt Graham
e overall big picture stuff. Regards, Adrien > On Jan 25, 2018, at 9:29 PM, Matt Graham 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. > GNUcash is v

Future allocated money vs Budgets

2018-01-25 Thread Matt Graham
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. GNUcash is very strict on proper double-entry bookkeeping practices (which I love). In accounting, “budgeting” means that you are plott