Dwight Raymond | 23 Jul 18:53 2014
Picon

Scheduled Transactions

Hello:
I am running GnuCash 2.6.3 on ubuntu 12.04.
I would like to have a projected balance displayed for each scheduled
transaction. This would be the current account balance minus/plus a
running balance of the scheduled transactions.
This could be an added column to the scheduled transactions list if
possible.
It could also be a report that can be generated, but I have failed in an
attempt to generate such a report.
Does anyone have a possible solution to my request?
Thanks,
Dwight
_______________________________________________
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.

Tommy Trussell | 23 Jul 16:28 2014
Picon

Email Messages Triggering Spam Filter [WAS: Re: How to configure the budget report to put a zero or space in bgt & diff columns]

On Wed, Jul 23, 2014 at 5:18 AM, Dave Koelmeyer <
dave.koelmeyer <at> davekoelmeyer.co.nz> wrote:

>
> On 22/07/14 06:58, Steve Nospam wrote:
>
>> Hmmm, you are correct.  I'm not sure why I had a problem before but I'm
>> really happy that I can work with the exported file as it is!  Thanks.
>>
>
> Off-topic: apparently by virtue of your rather unique surname, every
> single email from you is being dumped straight into my junk email folder.
> You might want to think about changing this as other recipients may be
> missing mail from you.
>
>
Actually I believe it ISN'T the user's name causing Steve Nospam's email to
get trapped. It's more likely due to a change in Yahoo domain registrations
(effective April 2014 if I recall correctly) intended to reduce email
abuse, but also causes all yahoo messages to be flagged as spam when
re-directed through certain email lists (such as GnuCash's). I believe this
has been mentioned on this list a couple of times in the past month.

Technically, yahoo's domain setting indicates that only yahoo's official
servers are allowed to handle email from their domains. Email lists that
modify email headers so that the messages appear to come from the list
server will still work OK.

I believe this change affects yahoo.com email as well as many of the
domains they manage email for -- ymail.com, att.com, sbcglobal.net, etc.
(Continue reading)

Jim Marshall | 22 Jul 21:27 2014
Picon

gnuCash not getting transactions when updating

Hi,
 Just recently moved from Quicken to gnuCash 2.6.3 on Windows 7(64bit). So
far I am extremely happy with it. I am having one small issue, I would like
to try and solve it but I can live with it too.

First, this may have been asked before but none of the searches I did on
google (including using the site=lists.gnucash.org....) found anything that
seemed relevant.

I've setup several online CC accounts which all appear to work fine. I also
have some mutual fund accounts and it seems as though the aqBanking is able
to connect and get data but it never seems to get any transactions.

A specific example, one of my mutual fund accounts is with a company that
uses the MyStreetScape bank. AqBanking connects but says there are no
transactions. I know there was a transaction recently (at least 1 last week
and at least 1 this week). I enabled OFX logging and it seems the response
is fairly empty (although I am not familiar with the OFX structure to
really understand it)

Here is the response from the ofx log - I didn't know if you needed the
request part but it only has the account number (which is correct) and the
start/end date of the search.

I've put the response below.

Any thoughts on what I can do to figure this out?

Thanks

(Continue reading)

Ron Stone | 22 Jul 17:47 2014
Picon

HST remittance formula

Hello all,

First - I am fairly new to GnuCash and, having heard about it for years, wish I’d started sooner. It is a
robust app and my hat is off to everyone who has contributed. 

My question is about Canadian HST (Harmonized Sales Tax) - a combination of provincial sales tax and
federal GST collected and administered together in some provinces.

Small businesses can elect to use a ‘simple method’ for calculating the HST they need to remit at the end
of each period (in my case every quarter). Instead of tracking every sale and every purchase to come up with
a number, they can remit a percentage based on total sales. 
For example, in Ontario HST is 13%. The quick method might require that I remit 7.5% of total sales. For
businesses such as consultants who do not have a lot of purchases, it means you actually keep some of the HST
(which becomes taxable income). 

The 7.5% above was just a number to illustrate, but there is a wrinkle. For most businesses (mine at least),
the percentage you remit is lower on the first $30,000 and then jumps on the rest of your income for the year.
Say, >=30k = 7.5%, and <$30k=8.5.

My question is if a formula could be written for a scheduled transaction to calculate what I owe at the end of
each quarter and what I’ll have to track as income on my business taxes (the amount from the HST collected
that I remit and the amount that I keep). I have not seen any examples of querying account data from a script,
so I’m not sure if it is doable. You would need to know how much you have sold in the past quarter and how much
of that is above/below the $30k threshold. 

I am using 2.6.3. 

If it is doable, and anyone cares to lend their expertise, it may help document some powerful features of Gnucash.

Many thanks,
(Continue reading)

Steve | 22 Jul 04:14 2014
Picon

GnuCash App (Android)

I've tried this app off and on in the past, and have always got frustrated
given its limited usage, or perhaps because I just didn't spend enough time
with it.

Well, I have to say, I've given it another chance, and I do find real value,
although yes, I do wish it was more robust.

I use cash a lot, and the tedius nightly job of having to manually post each
of my receipts and scribbles, has started to irritate me.  So I reinstalled
the app and after marking certain categories as "favorites", I now easily
send one qif file through email to me each night, download it, import it,
and voila, it actually does (accurately) work.  

Do I wish it was more robust, do I wish certain aspects would work correctly
or better, yep.  But I have to say, I find value in recording my cash
outlays on the spot, and being able to import them in one group, both on the
debit and credit side.

So I give it, a "B-" with hopes it gets the attention it deserves for
improvements.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/GnuCash-App-Android-tp4671970.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
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.
(Continue reading)

labour | 21 Jul 18:48 2014
Picon

Remove from Mailing List

Please remove labour <at> telus.net from your mailing list.
Thank you,
Ellen Oxman
President
_______________________________________________
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.

Vikas Damodar Garud | 21 Jul 17:26 2014

Income Report

Hi,

The situation:
I raise invoice on my customer on some date,
Customer pays the due on some other date.
The payment is is two parts:  Some amount credited to my bank account and some 
part (Typically 10%) deducted as tax (TDS - Tax Deducted at Source) and paid 
to my account with Income Tax Department.
The payment typically happens couple of months after the invoice is raised.

I am looking for a report which tells me the invoices actually paid - not the 
posted ones in a particular period.

For example, I've raised, say 3, invoice, in one accounting period (1 April to 
31 March, in India).  Two of the invoices are actually paid (Amount credited 
to my bank account plus the amount credited to my Income Tax Account) in the 
same accounting period.  The balance one is paid in subsequent accounting 
period.

I am looking for a report to tell me the amount credited in both my accounts - 
Bank and Tax.  If I run a transaction report for particular period on the bank 
or tax account I get the information about the amounts credited in these 
accounts.  I am looking for report telling me the the amounts credited by 
customer in both the accounts, in a particular accounting period.  

I may probably be missing something obvious - but I AM missing it!

Any help is appreciated.

Thanks,
(Continue reading)

Steve Nospam | 21 Jul 15:55 2014
Picon

How to configure the budget report to put a zero or space in bgt & diff columns

I frequently need to save my budget report to html and then open it in Excel in order to work with the data. 
Unfortunately the report places a period (.) in the budget and diff columns if no budget value has been
set.  I would prefer a space or a zero so that I can easily sum the column in Excel.  Right now I have to
replace all the . values with 0 in order to sum the columns.  I've looked at the options but haven't found a
way to accomplish this.
_______________________________________________
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.

Steve Nospam | 21 Jul 15:22 2014
Picon

Bug 729955 Enhancement request date range for the budget report does not load

Hello I'm running Windows 7 64bit and GnuCash 2.6.3,

I renamed the old budget.scm and downloaded the  new budget.scm file and put it in the directory:
C:\Program Files
(x86)\gnucash\share\gnucash\guile-modules\gnucash\report\standard-reports.  When I try to
start GC, the program starts loading and gets to the message that it's loading standard-reports and then
stops without an error message.  When I check task manager, GC is not running.  I checked for a trace file
and a filename exists with 0 bytes.  Is there another way to trace what is happening?
_______________________________________________
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.

Maf. King | 21 Jul 10:56 2014
X-Face
Picon

Re: Remove list of accounts from standard reports

On Sat 19 July 14 16:42:36 Philip Tromans wrote:
> I am running Gnucash version 2.6.3 under windows 7
> The main report I use is Income&Expense-Cash Flow, where the body of the
> report starts with 2 pages listing all the accounts included. and I
> cannot see how to remove this list of accounts
> 

Hi Philip,

Yes, I see what you mean - I don't use the Cash Flow report (usually the 
transaction report can be beaten enough to show me what I want).  I can't see 
any way to turn the list of selected accounts off on that report. The 
transaction report doesn't show the list you mention.

Seems to me that you may have to hand edit the report file (it is written in 
scheme) - I'm not on Windows so don't know where the definition file is 
located to give you a pointer.

Note, you should always copy emails to the list for GnuCash User - it doesn't 
do it for you, unlike some other mailing lists.  You may have a "reply all" or 
"reply to list" function in your email software that will help....  Others 
here know far more than I about GC, and other readers may benefit from the 
whole discussion. ( And you won't have to wait for me to get back after a 
weekend to see your reply!...)

HTH,
Maf.

_______________________________________________
gnucash-user mailing list
(Continue reading)

John Ralls | 20 Jul 12:30 2014
Picon

Transaction Entry Dates

It has been a long-standing and often discussed problem that transaction entry dates can change with time
zone, and https://bugzilla.gnome.org/show_bug.cgi?id=137017 has many useful comments on the
subject. But today I discovered https://bugzilla.gnome.org/show_bug.cgi?id=89439 with an
alternative view, that Date Entered should be Time Entered, and that there should be an optional column in
the register to show the time. That suggests an alternative solution to the problem while adding a sorting
option for transactions.

I've created two "suggestions" on UserVoice. Please vote for the one you prefer:

https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/6194177-add-an-optional-entry-time-field-to-the
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/6194125-fix-the-moving-entry-date-problem-by-getting-rid-o

Regards,
John Ralls

_______________________________________________
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.


Gmane