gnucash-user Digest, Vol 98, Issue 4
Leslie Hendelman
lesliehendelman at gmail.com
Wed May 4 13:05:15 EDT 2011
*
I was going to try to set up accounts for categories, but when I booted into
the mac, I couldn't find GNUCASH!! any ideas? It's not in Applications, or
on the desktop.....
thanks,
Leslie
*
On Wed, May 4, 2011 at 12:00 PM, <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
> Today's Topics:
>
> 1. Re: Problem opening a new file (Manfred Usselmann)
> 2. Re: How do I assign US Schedule C tax categories to
> transactions (Leslie Hendelman)
> 3. Re: How do I assign US Schedule C tax categories to
> transactions (David T.)
> 4. Re: eguile-gnc.scm (Dennis Powless)
> 5. Re: View pie chart of an account under Liability.
> (Manfred Usselmann)
> 6. Error Recently Started in AQBanking (Jason Ferrell)
> 7. Income Statement (Jos)
> 8. Transactions with split dates (Jonathan Ellis)
> 9. Re: Transactions with split dates (Michael Hendry)
> 10. Re: Income Statement (Mike or Penny Novack)
> 11. Re: Transactions with split dates (Ian K)
> 12. Re: Transactions with split dates (Michael Hendry)
>
>
> ---------- Forwarded message ----------
> From: Manfred Usselmann <usselmann.m at icg-online.de>
> To: Geert Janssens <janssens-geert at telenet.be>
> Date: Tue, 3 May 2011 18:55:50 +0200
> Subject: Re: Problem opening a new file
> On Mon, 2 May 2011 09:59:19 +0200
> Geert Janssens <janssens-geert at telenet.be> wrote:
>
> > On zondag 1 mei 2011, Bill Reimer wrote:
> > > Problem solved!
> > >
> > > When I got home and tried to open a new account using the procedure
> > > on the GnuCash example, the account properties window opened nicely
> > > - on my alternate screen!
> > >
> > > [...]
> > >
> > Ah, there are a couple of bug reports related to this problem, but no
> > one has fixed them so far.
> > https://bugzilla.gnome.org/show_bug.cgi?id=605163
> > https://bugzilla.gnome.org/show_bug.cgi?id=506558
>
> This is not a GnuCash specific problem. A lot of applications cause
> such issues. At work my secondary monitor is on the left side and at
> home on the right side and sometimes I use no second monitor (This is
> with my company notebook running Windows XP). Windows detects this
> nicely and automatically switches the grafics configuration
> accordingly, but many applications open windows at invisible positions
> and I'm searching hidden windows all the time.
>
> > Until someone actually fixes these bugs, here is a tip to move hidden
> > windows back on the visible part of your screen:
> >
> http://www.onetipaday.com/2008/01/11/how-to-move-off-screen-windows-back-to-
> > your-desktop/
>
> Yes, this is the workaround I use as well. What does help as well is to
> move all windows to the main monitor before closing them.
>
> Manfred
>
>
>
>
>
>
>
> ---------- Forwarded message ----------
> From: Leslie Hendelman <lesliehendelman at gmail.com>
> To: gnucash-user at gnucash.org
> Date: Tue, 3 May 2011 13:50:29 -0400
> Subject: Re: How do I assign US Schedule C tax categories to transactions
> Dear Alex:
> Thanks for the message. What I understand about that is to set up
> individual Expense accounts and Income accounts for each (usually
> repetitive) item, for example, cell phone, office rent, cleaning, etc.,
> supplies, and 1099 Income, individual patient pay income, etc.
> Then, after importing transactions to my bank accounts, I can use these
> other accounts to assign "splits".
>
> When you talk about "splits" you lose me. I don't know what that means.
> On
> a typical, for example, Quicken-type, transaction, a split is an amount
> that
> is assigned to a certain category, like the amount of a deposit is $1,000,
> and there are 3 splits, $300, $500 and $200, which are individually "split"
> off. Is that what you mean?
> thank you,
> Leslie
>
>
>
> ---------- Forwarded message ----------
> From: "David T." <sunfish62 at yahoo.com>
> To: gnucash-user at gnucash.org, Leslie Hendelman <lesliehendelman at gmail.com>
> Date: Tue, 3 May 2011 11:10:40 -0700 (PDT)
> Subject: Re: How do I assign US Schedule C tax categories to transactions
>
>
> --- On Tue, 5/3/11, Leslie Hendelman <lesliehendelman at gmail.com> wrote:
>
> > From: Leslie Hendelman <lesliehendelman at gmail.com>
> > Subject: Re: How do I assign US Schedule C tax categories to transactions
> > To: gnucash-user at gnucash.org
> > Date: Tuesday, May 3, 2011, 10:50 AM
> > Dear Alex:
> > Thanks for the message. What I understand about that
> > is to set up
> > individual Expense accounts and Income accounts for each
> > (usually
> > repetitive) item, for example, cell phone, office rent,
> > cleaning, etc.,
> > supplies, and 1099 Income, individual patient pay income,
> > etc.
> > Then, after importing transactions to my bank accounts, I
> > can use these
> > other accounts to assign "splits".
> >
> > When you talk about "splits" you lose me. I don't
> > know what that means. On
> > a typical, for example, Quicken-type, transaction, a split
> > is an amount that
> > is assigned to a certain category, like the amount of a
> > deposit is $1,000,
> > and there are 3 splits, $300, $500 and $200, which are
> > individually "split"
> > off. Is that what you mean?
> > thank you,
> > Leslie
>
> Leslie--
>
> That is what Alex meant. Quicken "categories" equate (essentially) to
> Gnucash "accounts". For an explanation of Gnucash splits, see
> http://svn.gnucash.org/docs/guide/txns-registers1.html
>
> You might also read the Guide in general, as it introduces a lot of
> concepts that help users understand Gnucash better.
>
> David
>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
> >
>
>
>
> ---------- Forwarded message ----------
> From: Dennis Powless <claven123 at gmail.com>
> To: Derek Atkins <warlord at mit.edu>
> Date: Tue, 3 May 2011 14:26:24 -0400
> Subject: Re: eguile-gnc.scm
> I guess that's good I didn't attempt to modify it. Well, what I did was a
> multicolumn report: at the top I did an account summary and set the dates
> to have the beginning balance.
>
> Then the middle is a transaction report with the dates set...
>
> The last one is another annual report with the dates set to the ending
> balance.
>
> This does produce the report, but it's not as pretty as it could be. It
> does show the three elements I need (Starting balance, transactions and
> ending balance).
>
> I wonder why this has not been done already. I know how to do some coding
> (VBA) but not equle or scheme quile etc....
>
> I would do the work if I had the location of some resources, I did some
> searching but it's too confusing as to what language is being used.
>
> Thanks,
>
> D
>
> On Tue, May 3, 2011 at 9:38 AM, Derek Atkins <warlord at mit.edu> wrote:
>
> > Hi,
> >
> > Dennis Powless <claven123 at gmail.com> writes:
> >
> > > I'm using 2.2.9
> >
> > well, you could try to grab the copy in 2.4.x and back-port to 2.2.9.
> > Or you could just upgrade to 2.4.5. Either way, it wont help you with
> > modifying transaction.scm as the transaction report is not written using
> > e-guile.
> >
> > > D
> >
> > -derek
> >
> > > On Mon, May 2, 2011 at 9:07 AM, Derek Atkins <warlord at mit.edu> wrote:
> > >
> > > Dennis Powless <claven123 at gmail.com> writes:
> > >
> > > > <http://www.fb-cs.co.uk/files/gnucash/eguile-gnc.scm>How do I
> get
> > the
> > > file
> > > > equile-gnc.scm? I think I'm sure I have to make a custom report
> to
> > get
> > > the
> > > > starting or opening balance for a report. I have to make a
> > statement
> > > and
> > > > give it to the board each month of the activity.
> > >
> > > It's included in GnuCash 2.4.x
> > >
> > > > So, I'm trying to create a report, but I can't figure out how to
> > > download
> > > > the file. I see the wiki that links me to the DL, but it's a
> > readme.txt
> > > > file.
> > >
> > > > Please remember to CC this list on all your replies.
> > > > You can do this by using Reply-To-List or Reply-All.
> > >
> > > -derek
> > >
> > > --
> > > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> > > Member, MIT Student Information Processing Board (SIPB)
> > > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> > > warlord at MIT.EDU PGP key available
> > >
> >
> > --
> > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> > Member, MIT Student Information Processing Board (SIPB)
> > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> > warlord at MIT.EDU PGP key available
> >
>
>
>
> ---------- Forwarded message ----------
> From: Manfred Usselmann <usselmann.m at icg-online.de>
> To: "David T." <sunfish62 at yahoo.com>
> Date: Tue, 3 May 2011 22:06:15 +0200
> Subject: Re: View pie chart of an account under Liability.
>
> On Mon, 2 May 2011 17:48:38 -0700 (PDT)
> "David T." <sunfish62 at yahoo.com> wrote:
>
>
> > --- On Mon, 5/2/11, Lovius <gnucash at lovius.eu> wrote:
> >
> > > From: Lovius <gnucash at lovius.eu>
> > > Subject: View pie chart of an account under Liability.
> > > To: gnucash-user at gnucash.org
> > > Date: Monday, May 2, 2011, 2:02 AM
> > > I have a credit card account under
> > > Liabilities and would like to create a pie chart to show
> > > what accounts the money has been used for or the accounts
> > > that have been charged by the credit card account?
> > > But don't figure out how to do it, maybe I miss part of the
> > > conceptive part !
> > > Anyone got any ideas it would be great.
>
> > I don't see a reply yet.
> >
> > I have not used the pie chart report, and I am not at my machine to
> > test it, so I am flying just a little blind here.
> >
> > I'll assume that creating the pie chart using the single Liability
> > account does not give you a listing arranged by the destination
> > account, so...
> >
> > I am not sure whether the pie chart reports include it, but the
> > Filter By Account feature might do what you want. Assuming that it's
> > on the accounts tab, you would open the options for your pie chart
> > report, click on the accounts tab, select all the various accounts as
> > the source for your pie chart, and then select the Liability account
> > in the Filter By box below.
>
> The bar and pie chart reports don't have that filter functionality.
> This would be nice though, but for now only the transaction report
> allows such kind of filtering as part of the account selection.
>
> Manfred
>
>
>
>
>
> --
> Manfred Usselmann <usselmann.m at icg-online.de>
>
>
>
>
> ---------- Forwarded message ----------
> From: Jason Ferrell <jasontferrell at gmail.com>
> To: gnucash-user at gnucash.org
> Date: Tue, 3 May 2011 21:55:59 -0500
> Subject: Error Recently Started in AQBanking
> My AQBanking setup worked fine until about 2 weeks ago. Now, I'm not
> getting it to download any new transactions, even though I know there are
> new transactions to download. I get this message:
> The Online Banking import returned no transactions for the selected time
> period.
> Then, looking at the log, I see:
>
> Sending jobs to the bank(s)
> Locking user xxxx
> Resolving hostname "ofx.discovercard.com" ...
> IP address is 199.38.xx.16
> Sending request...
> Connecting to bank...
> TLS Handshake Error: -59 (GnuTLS internal error.)
> Error parsing server response
> Unlocking user xxxx
> Postprocessing jobs
> Resetting provider queues
>
>
>
> ---------- Forwarded message ----------
> From: Jos <josvis at sonicmail.co.za>
> To: gnucash-user at lists.gnucash.org
> Date: Tue, 03 May 2011 13:44:00 +0200
> Subject: Income Statement
> Please design the following multi-column Income Statement:
>
> Columns :
>
> Column 1 : Headings/Account names
> Column 2 : Actual Month x
> Column 3 : Actual Month x last year
> Column 4 : Variance columns 2 & 3
> Column 5 : Actual cummulative for this financial year until Month x
> Column 6 : Actual cummulative for previous financial year until Month x
> Column 7 : Variance columns 5 & 6
>
> ROWS (Top - down)
>
> 1 Headings
> 2 Sales (with individual accounts and subtotal)
> 3 Cost of sales (with individual accounts and subtotal)
> 4 Gross Profit (2-3)
> 5 Other income (with individual accounts and subtotal)
> 6 Expenses (with individual accounts and subtotal)
> 7 Net Profit/(Loss)
>
> This is the only shortcoming that prevents me from migrating to Linux
> permanently
>
> Please !!
>
> Joshua Visser
>
>
>
>
> ---------- Forwarded message ----------
> From: Jonathan Ellis <jonathan.ac.ellis at gmail.com>
> To: gnucash-user at gnucash.org
> Date: Wed, 4 May 2011 11:36:25 +0100
> Subject: Transactions with split dates
> Is it possible to enter a transaction with different dates for the two
> halves of the split?
>
> The reason I ask is that when a transfer happens between two of my bank
> accounts (for example from my current account to my credit card or from
> Paypal to either my current account or credit card) there is a time lag
> (usually a few days) between the credit or debit being sent from one bank
> and being received by the other bank. This means that the same transaction
> would have different dates in the two accounts.
>
> When I download the statements, I have to choose whether to keep the date
> from one statement or the other. Sometimes, Gnucash might not even
> recognise
> the transaction as being the same one so I end up with duplicate
> transactions with different dates.
>
> This makes it very hard to reconcile the accounts as the date will be wrong
> and so the reconciled balance will be wrong in one of the accounts or there
> will be duplicate transactions.
>
>
>
> ---------- Forwarded message ----------
> From: Michael Hendry <hendry.michael at gmail.com>
> To: Jonathan Ellis <jonathan.ac.ellis at gmail.com>
> Date: Wed, 04 May 2011 12:24:01 +0100
> Subject: Re: Transactions with split dates
> On Wed, 2011-05-04 at 11:36 +0100, Jonathan Ellis wrote:
> > Is it possible to enter a transaction with different dates for the two
> > halves of the split?
> >
> > The reason I ask is that when a transfer happens between two of my bank
> > accounts (for example from my current account to my credit card or from
> > Paypal to either my current account or credit card) there is a time lag
> > (usually a few days) between the credit or debit being sent from one bank
> > and being received by the other bank. This means that the same
> transaction
> > would have different dates in the two accounts.
> >
> > When I download the statements, I have to choose whether to keep the date
> > from one statement or the other. Sometimes, Gnucash might not even
> recognise
> > the transaction as being the same one so I end up with duplicate
> > transactions with different dates.
> >
> > This makes it very hard to reconcile the accounts as the date will be
> wrong
> > and so the reconciled balance will be wrong in one of the accounts or
> there
> > will be duplicate transactions.
>
> Isn't this analogous to the gap between your writing a cheque and its
> being cleared through your account?
>
> I would regard the date of a transaction as being the date it is
> initiated rather than the date it is completed, and enter details of
> cheques as they are written rather than when they reach the bank
> statement.
>
> What problem are you trying to solve by putting in two separate dates?
>
> Michael
>
>
>
>
>
> ---------- Forwarded message ----------
> From: Mike or Penny Novack <stepbystepfarm at mtdata.com>
> To: Jos <josvis at sonicmail.co.za>
> Date: Wed, 04 May 2011 07:30:57 -0400
> Subject: Re: Income Statement
> Jos wrote:
>
> Please design the following multi-column Income Statement: ........
>>
>>
>>
> What are you expecting?
>
> Let me start with a question. Are you unsure how you would use the existing
> Income Statement report(s) to extract the data necessary to build the report
> you want? Of course that would require you to construct the "finished
> product" report from this data using the editor of your choice. Or is the
> problem that you expect gnucash to come with a built in "ready made" report
> for this PARTICULAR "finished product" (as opposed to all the possible other
> "finished product" reports other people might require).
>
> Because I do use gnucash for organizational books and because I am a
> retired senior analyst with decades of experience doing financial software
> this was a question I asked our organization's accounting/tax person (a
> board member actually a lawyer but treasurer of the nonprofit/charitable of
> the lawyer's association). He told me "Mike, don't bother to custom code
> this. I prefer to use my favorite editor and so would any other accountant".
> The reason is that there is MORE you want (you probably need to edit in any
> case).
>
> Let's for a moment assume you had this report as you described and it was
> to be presented (to your board, etc.). Do you not see that in cases where
> that variance was very large you would be wanting to NOTE (either footnote
> or endnote) explanations?
>
> Could there be as part of gnucash an "editor" that could take as input two
> Income Statements and construct from these the report you want? One allowing
> you to insert fixed text and notes? Of course there could be. But
> interactive editors are a big project all in themselves, they already exist,
> so why reinvent the wheel. Please look again at what you asked for in more
> detail to see all the little bits and pieces you left out. For example, you
> imagined ONE column for current and ONE for previous. Oh, your income and
> expense account trees aren't nested? But what of they were (probably the
> more general case). So you want some way in this built in report to control
> that (to flatten or not, how to flatten). In other words, there are LOTS of
> decisions anybody wanting a report as you described to make.
>
> But back to the beginning. If you were doubting that gnucash as it stands
> could produce the reports with the necessary data, just run two Income
> Statements for the respective begin and end dates, export them, and copy the
> data from these files into the finished product document as you described.
> Yes of course a bit of fudging/adjusting. For example, you assumed that the
> accounts would line up 1:1 for these two time periods but clearly that is
> not necessarily the case as accounts could have been created in the current
> period that have no corresponding line on the previous.
>
> Michael D Novack, FLMI
>
>
>
> ---------- Forwarded message ----------
> From: Ian K <ik522000 at yahoo.co.uk>
> To: gnucash-user at gnucash.org
> Date: Wed, 4 May 2011 04:39:57 -0700 (PDT)
> Subject: Re: Transactions with split dates
> The issue would arise when funds leave one account on a certain day, but do
> not arrive at the destination account until a later date. E.g. the UK BACS
> process can take 3 days during which the funds have left the source account
> and do not arrive into the destination account.
> In GnuCash one solution would be to create a dummy 'Transit' account then
> wash the transactions through that.
> For example, transferring £1000 from Bank A to Bank B through a Transit
> account could look like this:
>
> 05-May, Bank A -£1000, Transit +£1000
> 07-May, Bank B +£1000, Transit -£1000
>
> That way the funds can be shown to be 'in transit' between two accounts.
> It's not ideal - there are extra transactions to create, and it might
> become
> confusing to match the sides of the transactions if there are many
> different
> accounts using the transit account. This could be solved by creating more
> transit accounts of course...
>
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/Transactions-with-split-dates-tp3495094p3495220.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
>
> ---------- Forwarded message ----------
> From: Michael Hendry <hendry.michael at gmail.com>
> To: Ian K <ik522000 at yahoo.co.uk>
> Date: Wed, 04 May 2011 13:02:46 +0100
> Subject: Re: Transactions with split dates
> On Wed, 2011-05-04 at 04:39 -0700, Ian K wrote:
> > The issue would arise when funds leave one account on a certain day, but
> do
> > not arrive at the destination account until a later date. E.g. the UK
> BACS
> > process can take 3 days during which the funds have left the source
> account
> > and do not arrive into the destination account.
> > In GnuCash one solution would be to create a dummy 'Transit' account then
> > wash the transactions through that.
> > For example, transferring £1000 from Bank A to Bank B through a Transit
> > account could look like this:
> >
> > 05-May, Bank A -£1000, Transit +£1000
> > 07-May, Bank B +£1000, Transit -£1000
> >
> > That way the funds can be shown to be 'in transit' between two accounts.
> > It's not ideal - there are extra transactions to create, and it might
> become
> > confusing to match the sides of the transactions if there are many
> different
> > accounts using the transit account. This could be solved by creating more
> > transit accounts of course...
>
> I can see what you're trying to achieve, but I'm not sure _why_ you're
> trying to achieve it!
>
> I can see that you might wish to avoid spending money from an account
> which was the destination of a transfer which wasn't actually going to
> take place for a few days (Bank B, to use your example), but if you're
> aiming to ensure that the reconciliation of your Bank A => Bank B
> transaction has an exact date-match between Bank B's statement and your
> GNUCash transaction I think you're giving yourself unnecessary stress!
>
> To go back to my example of a cheque payment - do you adjust the date of
> the posting in GNUCash when you come to reconcile this transaction with
> the bank statement?
>
> Michael
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
More information about the gnucash-user
mailing list