Re: [GNC] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

[elvis]

Hello Greg,

I encountered this exact same problem.


The way bills are entered just does not scale for someone doing more 
than home entry, or doing it because they love it. 50 mouse clicks to 
record buying a Mars bar just isn't viable if you have more than a Mars 
bar a week.



I have a small program that takes downloaded transactions from the bank, 
munges the descriptions so the qif importer recognises the accounts and 
also adds gst. Saves hours and hours a month.





On 10/10/20 9:37 pm, Greg Feneis wrote:

Yes, but keep in mind that I don't purchase anything for resale.

Kind regards, Greg Feneis
(Pixel 3)


On Fri, Oct 9, 2020, 16:17 Fran_3  wrote:


So Greg, you don't post any Bills to Accounts Payable? Electric & Utilityered
bills. Rent or whatever?

You just post the payments... is that what you are saying?

Thanks


On Friday, October 9, 2020, 12:15:25 PM EDT, Greg Feneis <
mfen...@gmail.com> wrote:


I don't use this process at all. Everything my business buys how on a
credit card. 路

Kind regards, Greg Feneis
(Pixel 3)


On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user <
gnucash-user@gnucash.org>
wrote:


Posting Bills allows you to keep track of AP and provides data to the
Bills Due Reminder...
However some routine expenses may just get paid without going through the
steps of creating and posting and paying a bill.
For a small venture posting bills can require a lot of keyboard time...
even duplicating a bill requires a number of steps, data entry, and

clicks

and can eat up time if you have a bunch of them to do...
Example, we have a couple of vendor from which we get 50+ to 100+ charges
per year. They each are on auto pay and are mostly for the same amount

per

charge... but each charge is for a different thing... so descriptions,

due

dates, etc are different for each item.
(You can think of these as if they were an annual listing or service
fee... one for each item.)
I got reminded of this recently when we made an effort to enter/create
Bills for the 100+ charges that were going to occur for Vendor-A over the
next 12 months... again, the big corporate vendor does not supply a

monthly

Bill listing all charges for that month... the item fee comes up and gets
auto paid... so 100+ transactions per year for that one vendor.

It is a lot less work to just enter each payment into the system as
opposed to first creating a bill then posting a bill and then paying the
bill.
How do you all choose which things to create Bills for and which things
just Pay?
Thanks.



___
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 Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists
for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash and Swedish accounting legislation

[elvis]

If you want a fixed date burn a cd or use other ways of verifying the 
files like md5sum



All of this fixed date stuff is just security theatre if you can access 
the source and pretty much the same even if you can't.



One of the attractions of gnucash is you have access to all your 
accounts, not just what some commercial company says you can have.



On 11/8/20 8:35 am, doncram wrote:

Both fixed date and relative date locking are needed, let me chime in to
say, with reasons that may not have been considered so far.  Relative (same
as number of days?) should be a mild locking, like just a notice that can
be over-ruled ("The transaction is more than 60 days in the past, are you
sure you want to change it?).  This is a simple control to help avoid data
entry mistakes.  In another software, that feature helps me surprisingly
often.

The fixed date locking should be stronger, ideally requiring a password.
The previous year would be locked only when the Treasurer or
other authorized person is really finally signing off on all reporting,
after performing all necessary closing entries to recognize accruals (see
my comment in separate thread "closing of accounts, and locking, "not
needed in Gnucash"? Needed!") and reviewing the financial reports
thoroughly.  This matches up to how nonprofits and businesses have to
operate.  For a nonprofit, the final financial statements would be given to
board , and used in applications for grant funding, and in filing
IRS-required financial statements which are eventually published online at
Guidestar, and so on.  One doesn't want incompatible versions being printed
out and reported publicly, ever!  One really needs to finalize the previous
year, for many purposes.  This allows a nonprofit (or business) to separate
some duties (e.g. a cash withdrawal transaction can not be removed later by
the office-person who took the cash). It can help even a single person
business, too, in making sure that past-years data is fixed (and so
financial statements and tax info is fixed), unless you really really want
to change it for some reason (I can't think of any good reason though).

About the Swedish legal requirement, I say kudos to them for requiring it.
It seems a very good thing, to insist that any organization which will file
reports will have the basic control that the transactions are locked.  It
is good practice to ensure that any organizationsthen defines a change to
prior year to be verboten, and it is therefore a detectable "crime" if that
happens.  The requirement should be easy to achieve, and it has some value
towards ensuring good info.  It's like requiring double-entry accounting,
always having entries that balance!  The fixed date lock may suffice to
meet this requirement.  It seems to me that the further locking feature
(already discussed?), which prevents editing of any existing transactions,
but allows journal entries, would be really helpful.  So that late changes
would be clearly identified.  So that informal internal audit, or external
formal audit, could focus especially on those late journal entries, as it
should properly focus upon all unusual entries (including all or almost all
journal entries).  It would be useful to have a software feature that
allows one to compare one saved version of data vs. current version of
data, to detect any "crime" and then take action on it.  The threat of
being detected itself dissuades "crime" of unauthorized changes.  Trust but
verify.

Informational note:  Many participants here may not be aware, but U.S. GAAP
and International IFRS standards have specific severe provisions about
making changes to any previous year's data, especially but not limited to
any change that affects reported earnings.  Any substantial revision would
be publicly embarrassing and require issuing revised financial statements
very publicly and explaining.  Revisions might be (appropriately) avoided
by argument that, oh, this change may be necessary for accuracy but is not
material enough to warrant a public revision, so do let's make the
correction within the next year's accounting without mentioning it.  *And
even if/when a revision to a prior year is implemented, it is done by
adjustment of current year balances, without changing the past year's
accounting!*  Say a significant amount of accounts receivable should have
been written off, but such expense was not recorded.  A restated Income
Statement and a Balance Sheet and a Statement of Cash Flows, all taking
that into account would be issued, but the correction in the accounting
system is to make a journal entry only in the current year reducing
retained earnings by that amount and reducing accounts receivable.  Getting
to where you would have gotten if the proper entry had been made in the
prior year. Because the prior year's data really really is locked.  I
mention this by way of supporting idea that fixed date locking is a
regular, usual, basic feature of an accounting system.  IMO it should be

Re: [GNC] Australian System

[elvis]

On 2/7/20 4:08 pm, Mike Alsop wrote:

You have probably been asked a thousand times, but as we entered a new
financial year yesterday, I seriously need to look at doing my own
books. Bookkeeping fees are now over the moon!!

So, does this system comply with the Aussie GST and BAS reporting
system for the Australian Taxation Office??
  
Many thanks in advance for any info.



It's a very flexible system, you can make it do anything. I have used it 
since 2007 to do gst and bas.



I just used the plain reports with appropriate accounts selected. I did 
the June qtr bas in about 5 minutes last night.



You can use the business features, but it's pretty clunky and time 
consuming if you want to do a lot of entries, especially business 
consumables.



I also have a small program I run over my exported bank files to insert 
a gst split, otherwise it is business features or manual, neither of 
which appeal.






Mike
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Don't force it, get a larger hammer.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 3.7 Accounts open bar

[elvis]

On 4/12/19 3:47 am, Geert Janssens wrote:

Op dinsdag 3 december 2019 13:08:30 CET schreef elvis:

On 3/12/19 8:58 pm, Geert Janssens wrote:

In 2.6.12 I have 12 accounts open with space for 3 or 4 more. They all
have close buttons on them, and every bit of text is readable.


In 3.7 I have 12 accounts open, but to fit them on the screen I have had
to change preferences --> windows to width 7. Which makes the account
names unreadable. And there is no more space to open other accounts.


is there a way to bring back the old behaviour? It looks like someone
has tried to pretty things up, but it has made it unusable.

The "someone" in that sentence is the upstream gtk project. We depend on
their code to create the graphical user interface for gnucash. When Gtk
switched from version 2 to 3, they redesigned all of the user interface
elements the gtk library provides. In many cases the new elements take up
more space as you noted.

As to what can be done about it: you can tweak the style sheet used by
gnucash to render the user interface elements on screen. Starting points
for this can be found here:
https://wiki.gnucash.org/wiki/GTK3#Visual_Styling

Thanks Geert,
I'm both super happy that I can do something about it, and also sad to find
out that all those threads that ended in "fix the CSS" apply to me. I was
hoping it wouldn't be the case but kind of expecting it. I will report back
with results.

I do sympathize.

Unfortunately the GnuCash development team is too small to maintain its own
custom css style to adjust for the design choices made by the Gtk developers.
We used to have a theme selector for 2.6, but that was no longer supported
either after Gtk switched to version 3.

If you happen to be on linux (you didn't mention your platform) you could try
to use the gnome tweak tool to install a different gtk3 theme. You can
download plenty from https://www.gnome-look.org/browse/cat/135/order/latest/

I don't know of a similar tool for the other platforms but it should be
possible to install a different Gtk theme on these platforms as well, albeit
manually. If you find a nice predefined gtk theme that uses layout choices
that better fit your requirements you could try that route rather than
tweaking css directly.


Hi Geert,

I have managed to make a start on what I would like..

tab * {
  font: 9px arial, sans-serief;
}

in    .config/gnucash/gtk-3.0.css  changes the font size in the 
tabs, but it is in every tab including the setting tabs. I can't work 
out how to make it just to apply to the notebook gtk section. Also the 
padding on the tabs could definitely be optimised as well to fit more 
text in. I can see the setting in gtk inspector, but don't know how to 
translate that to into css. It is not very intuitive! All the examples 
seem to be adjusting colours and other fairly simple stuff.


Lawrence










Geert



--
Ahh. The joy of Windows. Second only to the joy of getting kicked square in the 
biscuits.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Loan with overpayments

[elvis]

On 23/2/20 8:23 am, David Cousens wrote:

Claire

Can you request a more detailed statement?

"Trust us, we are a bank" is not a good modus operandi as we have found out
recently in Australia. We had banks charging for services never rendered,
continuing to charge fees to dead people along with outrageous fees for
letting the computer do the hard work. When my statements were delivered on
paper I used to get them monthly at no charge, now that they are computer
generated by default I get them six monthly with a fee but can also request
a statement for which I will be charged a fee at any time - no human
intervention as it is supplied immediately as a downloaded PDF so no mailing
or printing costs. Statements here are generally fairly complete  usually
with interest credited monthly but calculated on daily stops. Additional
payments of course should reduce the interest paid which should be
calculated on the current daily balance.
If you do set up a spreadsheet for the loan calculations you can setup the
usual setup with no additional payments and a parallel setup with the
additional payments so you can document the interest saved . Most
spreadsheets have financial functions for doing the interest calculations
using daily compounding interest but they rarely define the formuae they are
using but they are usually standrd calculations from the financial
literature.

David Cousens


And now the banks are so risk adverse that I can't refinance a loan I 
have had for 15 years. A big thanks to all the people who whinged at the 
banks and are turning us into a nanny state.








-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Niagara Falls would be much more impressive if it flowed the other way.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where should i put my account "Loan to a Friend" when they evaded debt ?

[elvis]

On 20/2/20 2:47 pm, Long wrote:

Hello GnuCash Users,

I just assumed that when i loan to a friend and they don't give my money
back, and then, where should i put that Account to make it doesn't not
affect my Assets ? i mean, my Asset only had 100$, "Stealer" owed to me
about 20$, everytime i open GnuCash... oh, look, this month i got 120$, and
check my bank, oh man, it's only 100$...

To Expense : I assumed that i want to put it to Expense, maybe it's make
sense, because i already spent my money.

To Liability : How about move it to Liability ? so look at a placeholder
"Liability", my owe will decrease because i will make a negative account for
"owed to me". it seems like unreasonable for me when i check my owed.

of course, this is just assumed, like the way GnuCash teach us when the
first time we fall in love with GnuCash.

Thank you for take your time to read this post, and help me.


Expense account --->> Bad debts.


Write it off and be glad the experience only cost you 20 bucks...







--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
the melancholy of all things completed.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 3.7 Accounts open bar

[elvis]

On 3/12/19 8:58 pm, Geert Janssens wrote:

In 2.6.12 I have 12 accounts open with space for 3 or 4 more. They all
have close buttons on them, and every bit of text is readable.


In 3.7 I have 12 accounts open, but to fit them on the screen I have had
to change preferences --> windows to width 7. Which makes the account
names unreadable. And there is no more space to open other accounts.


is there a way to bring back the old behaviour? It looks like someone
has tried to pretty things up, but it has made it unusable.

The "someone" in that sentence is the upstream gtk project. We depend on their
code to create the graphical user interface for gnucash. When Gtk switched
from version 2 to 3, they redesigned all of the user interface elements the
gtk library provides. In many cases the new elements take up more space as you
noted.

As to what can be done about it: you can tweak the style sheet used by gnucash
to render the user interface elements on screen. Starting points for this can
be found here:
https://wiki.gnucash.org/wiki/GTK3#Visual_Styling


Thanks Geert,
I'm both super happy that I can do something about it, and also sad to find out that all 
those threads that ended in "fix the CSS" apply to me. I was hoping it wouldn't 
be the case but kind of expecting it. I will report back with results.




--
Arachnohobophobia: Fear of homeless spiders

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] 3.7 Accounts open bar

[elvis]

Hi,

I am trying out moving to 3.7 from the 2.6 series.

Looks good so far, I can't tell the difference, which to me is a good 
thing,



One thing though - the list of open accounts across the top of the 
screen. Notebook tabs I think they are called.


In 2.6.12 I have 12 accounts open with space for 3 or 4 more. They all 
have close buttons on them, and every bit of text is readable.



In 3.7 I have 12 accounts open, but to fit them on the screen I have had 
to change preferences --> windows to width 7. Which makes the account 
names unreadable. And there is no more space to open other accounts.



is there a way to bring back the old behaviour? It looks like someone 
has tried to pretty things up, but it has made it unusable.



Lawrence


--
Treat her like a lady and she'll always bring you home.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo blocking GnuCash Email

[elvis]

On 21/9/19 3:37 am, Derek Atkins wrote:

Hi,

Starting around September 10, Yahoo appears to have started blocking
SMTP (email) originating at code.gnucash.org.  This means that yahoo
users have been prevented from receiving any mail (including list mail
and bug mail), and worse, they've been blocked from sending mail *to*
the list as well (due to sender-verify blocking them because yahoo is
blocking us).



If anyone has other ideas, please let me know.


Maybe add dmarc and spf to your sent email / domains




-derek


--
"It's based on actual math." - Dilbert

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] STP (Australia only)

[elvis]

On 15/9/19 12:05 pm, David Cousens wrote:

Liz,

Possible more significant will be the SBR (standard Business Reporting) of
which the STP is one of the first installments.  It will have an extension
of the MyGov ID which will be used for reporting to multiple agencies which
will replace AUSkey in March 2020. It will be used for any of the following:

Australian Business Register
Australian Taxation Office
Australian Securities and Investments Commission
ACT Revenue Office
QLD Office of State Revenue
NSW Office of State Revenue
Revenue SA
TAS State Revenue Office
Territory Revenue Office
State Revenue Office VIC
WA State Revenue

and will address things like licence renewals, business registrations etc
directly.


Real Big Brother stuff, where you can't run a business without a slew of 
IT things you need to fork out money for.


I'm furious the Liberals brought this in, it it totally against what 
their ethos is in regards to small business. We don't work for the 
government as some kind of serfs.





David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
The Dose Makes The Poison

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bookkeeping for a club's charity account - use business features?

[elvis]

If #1 one, that is quite messy, yes, and you’ll need lots of manual 
transactions and some sort of searchable/filterable tag system as I described 
previously. (to avoid hundreds or thousands of accounts and sub-accounts)

But if #2, then the business features can handle that easily with invoice line 
items posted to Income accounts for each destination and assigning those 
invoices to  individual customer accounts. No need for the individual member 
account(s) in the Income tree at all. GnuCash will track each customer's 
pledged (invoiced) amounts as well as payments. The gift portion *might* be a 
little trickier, but I think it can be achieved by the expense vouchers 
feature. (since they operate as sort of a ‘chargeback’) I’ll have to 
investigate.

Regards,
Adrien


Hi Michael,

This is how I would do it. I'm assuming you have around 30 people to 
account for.


Make up all your accounts and sub accounts and sub sub accounts and 
cross accounts.


Have a transaction in each person's account with all the splits possible.

Each dinner copy the last transaction and alter the amounts. Maybe 20 
seconds each so you are looking at about 15 minutes to update the whole.



I'm assuming your primary document is some kind of piece of paper your 
members fill out. If you have a spreadsheet on entry you would just 
massage it and import it.


By the time you much around with business features you might as well 
just copy transactions.



Lawrence


Thanks,

Michael

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
The harder I work the luckier I get.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] apply coefficient to an account

[elvis]

Hi Peter,

I have a program in python to add a split like that to a qif file.

I had it written to add Australian GST to my transactions after years of 
splitting them manually.



So I download my bank file, run the program, then import with all the 
splits added.



You might need to alter it to suit your split values,


if you are interested let me know.


Lawrence





On 6/3/19 6:10 am, Peter Münster wrote:

On Tue, Mar 05 2019, John Ralls wrote:


Just edit the transaction and add a split. You can type '.3*123.45' and
'.7*123.45' in the expense debit column, no need to get out your calculator.

Sure. But how can I split *all* transactions of an account the same way?
The only way, that I know, is to split the transactions manually one by one.


--
Treat her like a lady and she'll always bring you home.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle bounced check

[elvis]

I think from memory when I had allocated payments to the wrong invoice, 
I just deleted the payment split in the bank register - which also 
deleted the payment in invoices


Everything went back to as it was before the payment was made, which 
seems to be what you want.


On 2/2/19 2:24 pm, Mike Alexander wrote:

A few weeks ago I received a check in payment for an invoice I had sent to a 
customer.  I recorded the payment and deposited the check.  A couple of weeks 
later I got notice from my bank that the check had bounced.  My question is how 
to record this.  I want to “unpay” the invoice and charge the amount back to 
the customer, but I can’t find a good way to do this.

I tried entering a transaction to debit Accounts Receivable and credit the bank 
account after which I manually added the split in A/R to the lot for that 
invoice.  This sort of worked, but the invoice is still marked paid in the 
customer report.  I can, however, select it in the “Process Payment” dialog to 
pay it again and it shows up as unpaid in the receivables aging report.  Can I 
do better than this?

Mike

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
I quit Paranoids Anonymous.  They were all plotting against me.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Accounting period setup

[elvis]

Hi,

I'm just wondering, do people whos financial year runs from July to 
June, do they change the absolute start date of the year every year for 
reports?



All the relative dates refer to normal years, is these a way to redefine 
a normal year's start and end dates? So they aren't tied to a year 
beginning 1st Jan.



Lawrence

--
Auntie Em:  Hate you, Hate Kansas, Taking the dog.  -Dorothy.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bootstrapping and Company Ownership.

[elvis]

As of right now, is it okay to record it under DB Cash and CR Paid-in
Capita:Jason ? OR should I use CR Common Stock:Jason acccount?

 Did you issue common stock or is it a loan to the business from you? 
You really should speak to an accountant.





--


--
See Jane. See the dog. See the dog maul Jane.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] *.deb package for GnuCash 3.4 Released

[elvis]

On 2/1/19 6:14 am, Les wrote:

Me either on Linux Mint. Still on GC 2.6.17.



Was that from the package manager? I'd love to have the latest 2.6 
series on Mint but have .12




On 1/1/19 1:06 PM, Tim Kallmer wrote:

No luck, still not working for me.

On Tue, Jan 1, 2019 at 4:12 AM Colin Law  wrote:


On Mon, 31 Dec 2018 at 17:58, Tim Kallmer  wrote:

the .deb package did not work for me on Ubuntu 18.10

As I posted earlier, for ubuntu 18.10 do
sudo apt install libboost-regex1.65.1

Colin


___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
We have enough youth, how about a fountain of SMART?

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How To Handle Prepayments

[elvis]

Unless you really need to do accrual accounting, then don't. If you are 
never getting it back, it is not much of an asset.


Put it though as Insurance Expense, Initial Payment, Payment 2 etc.

Accounting is there to help you, not make more work to make it "correct".


On 16/12/18 7:06 am, tbalaban wrote:

My Company pays an initial payment to our insurer at the beginning of each
policy year. As we incur insurance costs based on event participants, that
initial payment is charged. After it is exhausted we get a monthly bill for
the amount due. In no case do we ever get the initial payment back.

I'd like to treat the initial payment as a credit to insurer's A/P account
then each month create a bill for the amount payable.

Is this the correct way to handle such a transaction?

Assuming it is, how do I credit the amount due from whatever account I
posted the initial payment to?

In practice we pay the initial payment in February, the start of our paolicy
year. Usually, in April or May, the initial payment is exhaused and we have
to send more money to pay that month's bill. I'm not at all clear on how to
post this situation.

I'd appreciate knowing how to do this in GNUCash as well as any comments on
the applicable general accounting rules. In Quickbooks I could debit or
credit A/R or A/P diectly and selects the customer or vendor required. Since
that capabiity does not appear to be available in GNUCash, how do I post it?

Many thanks for your already generous help.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
"I love the smell of napalm in the morning."

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciling different periods?

[elvis]

On 15/12/18 9:16 am, Stephen M. Butler wrote:

On 12/14/18 2:39 PM, elvis wrote:

Bite sized chunks, bite sized chunks.


Sometimes I get a few months and hundreds of transactions behind. 
I'll go a few days at a time to get started then weeks. Trying to 
remember what you did 3 months ago is hard! :-) But finding an error 
in 5 transactions is easy, finding it in 500 is hard.


Remember, you are never alone. There's you and the future-you trying 
to figure out what you did just now.




The worst feeling is knowing that the accounts were balanced before 
you started the day.  Then finding that nothing balances all the way 
back to January.  Turns out that the last transaction for November 
showed up in January (my finger failed to stutter on the month number)!


Took awhile to track that one down and convince myself I wasn't going 
crazy.  So, even byte sized chunks may be bigger than you expect.



I used to have that problem, starting off from something that balanced 
last time but was now out.



I just do 1 or 0 transactions to start with, if you are reconciling with 
the same balance you had last time, it makes it easier to find something 
that has been unreconciled by mistake or a transaction moved about...  
hopefully it would just balance again, but leave the out of place 
transaction unreconciled on its own in the window.










On 14/12/18 8:07 pm, Finbar Mahon wrote:

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. 
So, what I wanted to do was go back to the last 'good' 
reconciliation that I had on the printed bank statements for that 
a/c and work forward to discover where things had gone wrong. I 
suspect a date anomaly, an entry on the wrong date, maybe even the 
wrong year, finger problems :-)


So, the ideas on this thread indicate the way to do it is to ensure 
the balance at the end of a good reconciliation is coincident with 
the bank statement and look to see what income/expenditures are 
listed in the attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this 
year as the last 'OK' date but doing it up to latest balance seems 
to catch other errors, so I  was wondering if I could 'stage' the 
process.


Looks like D's reply indicates I could do it by varying the 
closing balance to coincide with one I am happy with. Maybe a 
slight problem if the closing balance is duplicated elsewhere? 
Maybe unlikely.


In fact by a combination of the two replies I can go back to the 
last 'good' situation and use the closing balance there as a 
starting point?


I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what 
we in the UK call a “current account”.


For this example, consider that your financial year starts on the 
1st January 2018, and you have a bank statement for the period 
ending 31 December 2017. This will have a figure (say £x) for the 
balance on 31 December 2017.


When you create this bank account in GnuCash, you set it up with a 
starting balance of £x.


Throughout January and into February you enter every transaction 
that involves that account (payments into the account of cash and 
cheques, withdrawals in cash, by cheque, direct debit, and so on).


When your statement arrives for the month ending 31st January, go 
ahead with the reconciliation. Because there are sometimes delays 
in transactions hitting the bank account, Gnucash will have the 
correct starting balance, but may have calculated the ending 
balance for the month incorrectly - let’s say you issued a cheque 
on 28th January and the recipient hasn’t paid it into his bank 
account yet. You should enter the bank’s version of the final 
balance for January into the “Reconcile information” in the box 
marked “Ending Balance”.


Now press OK, and work your way through the reconciliation 
procedure, ticking the box against each transaction on the screen 
that matches one on the bank statement, which you should mark as 
reconciled in pencil.


Once you have ticked all the transactions on the statement you 
should have a “Difference” at the bottom right of the Reconcile 
window of £0.00.


If there is a discrepancy (i.e. “Difference” is non-zero), you have 
a problem which you need to resolve NOW, because in my experience 
banks and computers can add or subtract quite accurately, and 
you’ve just ticked the computer’s and the bank’s versions of the 
same transactions

Re: [GNC] Reconciling different periods?

[elvis]

Bite sized chunks, bite sized chunks.


Sometimes I get a few months and hundreds of transactions behind. I'll 
go a few days at a time to get started then weeks. Trying to remember 
what you did 3 months ago is hard! :-) But finding an error in 5 
transactions is easy, finding it in 500 is hard.


Remember, you are never alone. There's you and the future-you trying to 
figure out what you did just now.





On 14/12/18 8:07 pm, Finbar Mahon wrote:

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. 
So, what I wanted to do was go back to the last 'good' reconciliation 
that I had on the printed bank statements for that a/c and work 
forward to discover where things had gone wrong. I suspect a date 
anomaly, an entry on the wrong date, maybe even the wrong year, finger 
problems :-)


So, the ideas on this thread indicate the way to do it is to ensure 
the balance at the end of a good reconciliation is coincident with the 
bank statement and look to see what income/expenditures are listed in 
the attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this 
year as the last 'OK' date but doing it up to latest balance seems 
to catch other errors, so I  was wondering if  I could 'stage' the 
process.


Looks like D's reply indicates I could do it by varying the closing 
balance to coincide with one I am happy with. Maybe a slight problem 
if the closing balance is duplicated elsewhere? Maybe unlikely.


In fact by a combination of the two replies I can go back to the 
last 'good' situation and use the closing balance there as a 
starting point?


I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what 
we in the UK call a “current account”.


For this example, consider that your financial year starts on the 1st 
January 2018, and you have a bank statement for the period ending 31 
December 2017. This will have a figure (say £x) for the balance on 31 
December 2017.


When you create this bank account in GnuCash, you set it up with a 
starting balance of £x.


Throughout January and into February you enter every transaction that 
involves that account (payments into the account of cash and cheques, 
withdrawals in cash, by cheque, direct debit, and so on).


When your statement arrives for the month ending 31st January, go 
ahead with the reconciliation. Because there are sometimes delays in 
transactions hitting the bank account, Gnucash will have the correct 
starting balance, but may have calculated the ending balance for the 
month incorrectly - let’s say you issued a cheque on 28th January and 
the recipient hasn’t paid it into his bank account yet. You should 
enter the bank’s version of the final balance for January into the 
“Reconcile information” in the box marked “Ending Balance”.


Now press OK, and work your way through the reconciliation procedure, 
ticking the box against each transaction on the screen that matches 
one on the bank statement, which you should mark as reconciled in 
pencil.


Once you have ticked all the transactions on the statement you should 
have a “Difference” at the bottom right of the Reconcile window of 
£0.00.


If there is a discrepancy (i.e. “Difference” is non-zero), you have a 
problem which you need to resolve NOW, because in my experience banks 
and computers can add or subtract quite accurately, and you’ve just 
ticked the computer’s and the bank’s versions of the same 
transactions and they don’t match!


Occasionally, you’ll discover that there’s a missing transaction in 
your records, leaving an unticked transaction in the bank statement. 
This could be a fraudulent transaction, but is more likely to be a 
standing order you’d forgotten to enter.


Unless your bank account has very little in the way of transactions, 
you’ll almost certainly have several transactions recorded in GC 
which haven’t been ticked - like the unpresented cheque.


Once you’ve cleaned up the reconciliation for January, wait for the 
February bank statement and reconcile that with GC.


If you’re catching up on reconciliation a month or two late, don’t 
rush it! Complete one reconciliation by correcting any errors before 
you move on to the next one.


Pardon me if I have misjudged your situation and made you feel you’re 
being patronised,


Michael








___
gnucash-user mailing list

Re: [GNC] [GNC-dev] Automatically split transactions with sales tax

[elvis]

On 12/11/18 2:56 am, Michael or Penny Novack wrote:

On 11/11/2018 6:23 AM, elvis wrote:
Seriously? Are you just telling someone to type stuff stuff in? The 
WHOLE point of computers is to automate stuff.


What if they have 1000 transactions? At a minute a transaction that a 
whole day entering stuff that could be in under a SECOND


I know if you have a hammer everything looks like a nail, but really 
we should be thinking of inventing a better hammer... or eliminating 
the screw entirely. 


 Well yes, and this used to be exactly my line of country, writing 
"sproj's" (special projects; ad hoc programs) to generate thousands of 
transactions.  Well more like tens of thousands, which would be a lot 
of end users entering by hand for day after after day. But please take 
note of that "ad hoc" because almost never EXACTLY the same even when 
the same type of transaction being generated. Sure, I had useful 
skeletons in my library, 90+% of the program going to be the same but 
needing changes before each use << my main activity my last few weeks 
before retirement was to get that library indexed "this skeleton is 
good for that" so junior programmers could use it >>


THAT is why this sort of thing best done OUTSIDE of gnucash, a stand 
alone program (that took "instruction input" and data input) which 
created a file to be imported. Not PART of gnucash because one user's 
needs will not be the same as another's. To make this clear .


Person who made the initial request  please describe YOUR 
situation in detail. What input would you be expecting to feed this 
program and how would it calculate the tax amount to be split? ALL 
things sold taxed at the same rate in your jurisdiction? That would 
not be true for other users. Simple rate? Or something odd for 
fractions of a dollar (every state I've lived in with a sales tax had 
special rules for that).


USUALLY business systems designed to handle sales have a component 
that does this, usually called a POS (point of sales) component and 
THAT generates transactions which feed the general ledger program << 
POS would also produce feeds to the inventory system >> Gnucash is 
JUST "general ledger". Personally I think that there should be teams 
working on these other sorts of systems (to have an open source POS, 
and open source "inventory", etc.). However it is important to note 
that POS systems are often sold by the same company that sells the 
register (doing things like keeping track of cash, producing customer 
receipts, etc.). Might be far fetched to expect one of these outfits 
to produce something to feed gnucash << but here could sit an open 
source program to CONVERT the output to what gnucash wanted >>


Michael D Novack


Hi Mike, you have very fair points there. I have often wondered how best 
to implement something like this and whether or not it would be useful 
to enough people to be a core feature.


My input problem is with purchases and not sales, I sell very few things 
but at a high price that entering them through the business features 
isn't a hassle.



And how would I implement the feature I wanted? Well the qif importer 
does pretty much all of it already. All it needs is something like (Add 
a split) to (debits/credits) , (Split account)  (amount). That would 
work for places that have a fairly fixed rate of tax like Australia's 
gst and I assume vat in other places. The tax tables are already set up 
and if I recall correctly linked to accounts, with a tax split account 
defined. Another way would be to add the tax to anything imported to 
that account.


Anyway I am not a great programmer so I am grateful for what I get, but 
I have seen this query enough times over the last 10 years to sometimes 
try and add some support to it.


Cheers

Lawrence





___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Jesus is coming, look busy

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [GNC-dev] Automatically split transactions with sales tax

[elvis]

On 12/11/18 12:08 am, Adrien Monteleone wrote:

Calm down.

The business features are the better route certainly. And if you have 1000 
transactions, then the even better route is to use some other software to 
generate a CSV to import. On that scale, probably a point of sale system that 
integrates with GnuCash via python and/or a MySQL backend is more sane.

The OP didn’t seem to indicate they were entering 1000s of transactions (but 
vaguely said “a lot”) and they specifically were looking for a General Ledger 
(but somehow automatic) solution.

Taking advantage of auto-fill with a few formulas is about the best to hope for 
under that restriction.

I didn’t mean it as the optimum solution.

Regards,
Adrien


I'm very passionate about entering data! :-)

The data isn't something the business features cater for, not unless you 
want to do 15 clicks per entry. Stuff like if you buy a folder for the 
office, and some coffee and other random things that you accumulate over 
a month. You might have 30 transactions like this a month, after a few 
years of entering it manually I got sick of it enough to do something 
about it.



Anyway my workflow goes like this. Download a month's transactions or 
so. Run the qif file through the importer where it adds a gst split, and 
deletes transactions I import in other ways (mostly payroll).


Upload using the qif importer, most of the regular transactions are 
matched, the rest go into unspecified where I allocate them.


Takes maybe 5-10 minutes for 150 total transactions or so.

Splitting each transaction to add gst used to take ages, and just as 
long if I used the business features. I have no idea if my situation is 
a minority because it's hard to tell reading the list what volume of 
transactions people do, and what sort of business.



Cheers

Lawrence




On Nov 11, 2018, at 5:23 AM, elvis  wrote:

Seriously? Are you just telling someone to type stuff stuff in? The WHOLE point 
of computers is to automate stuff.

What if they have 1000 transactions? At a minute a transaction that a whole day 
entering stuff that could be in under a SECOND

I know if you have a hammer everything looks like a nail, but really we should 
be thinking of inventing a better hammer... or eliminating the screw entirely.


On 11/11/18 3:23 pm, Adrien Monteleone wrote:

Chris,

If for some reason you don’t want to use the business features and prefer to 
enter transactions manually, the auto-fill feature helps greatly for this case.

I enter all of my cash expenses with a separate sales tax split. (I’m not in a 
VAT locale, this is ‘in addition to’ sales tax) The principle should be the 
same for VAT but the math might vary.

If you’re entering a transaction for the same payee, GnuCash will autofill the 
splits from the last entry for that payee. So if you’ve entered a split for 
GST, it will show up there. The difference then for each transaction will be 
your memo, possibly your income/expense account will need to change, and then 
the actual math, but the GST split will be added for you saving a few 
keystrokes.

In your case, for the item itself, enter the price as a formula and subtract the GST 
(I’m presuming it is inclusive) as "price / 1+(GST rate)”

So if your price inclusive of tax is $2.10 your formula is:

2.10 / 1.05lyl

which will give you your ‘pre-tax’ amount or in this example: $2.00

Then the GST split will automatically “be” the tax. (if you’ve already entered 
the opposing split)

If you want to double check it with a formula (helpful for more complicated 
entries with multiple other splits) then enter this as “price - (price / 1(GST 
rate)”

So the above example would be:

2.10 - (2.10 / 1.05)

Which would result in a GST split amount of $0.10.

Of course, these number look easy but the formulas work no matter how ‘messy’ 
the rate.

It isn’t automatic, but it does save time and is very easy to do, especially 
with practice.

Note, if you really need to enter the price for the item including GST, but 
also want a separate split to break it off to a GST Due or some such account, 
then you’ll need an additional split with a memo something like “GST/Tax 
Inclusive” and make it the reverse entry of the item. (so a credit to an 
expense account or a debit to a revenue/income account) and set its value to 
the amount of the GST split, thus your transaction will still balance.

For example:

Cr. Cash$105
Dr. Expense:Supplies$105
-memo “paper"
Cr. Expenses:Supplies   $5
-memo “GST Inclusive”
Dr. Expenses:GST$5
-memo “GST 5%"

- or -

Dr. Cash$105
Cr. Revenue:Sales   $105
-memo “widgets”
Dr. Revenue:Sales   $5
-memo “GST inclusive”
Cr. Liabilities:GST Due $5
-memo “GST 5%"

Of course, talk to a local CPA to make sure your reports are reflecting the 
proper amounts and adjust these entries as needed. These are just rough 
examples.

*Tip - because I pay different tax rates due to purchase

Re: [GNC] [GNC-dev] Automatically split transactions with sales tax

[elvis]

Hi Christian

I had a python program written for me to insert the 10% gst into a qif 
file download, I reckon it has saved me thousands of hours of manual 
entry over the last 10 years.


If you are interested I can send you a copy. It's not perfect but it 
does the job.


Lawrence

On 11/11/18 8:03 am, Christian Kluge wrote:

Hi,

Am 10.11.2018 um 22:09 schrieb CHRISTOPHER PEARCE:

Hello all,

I would like Gnucash to automatically create a split transaction for sales
tax when a taxable product is bought/sold.  I deal with a lot of
transactions, and its a pain to manually enter the sales tax for each one.
I'd rather just work within the general ledger and have Gnucash do it
automatically.

This feature has been wanted for a long time:

https://bugs.gnucash.org/show_bug.cgi?id=371581


For example, I buy a widget for $100 + 5% GST = $105.  I want Gnucash to
automatically create the split, and allocate $5.00 to the GST liability
account.


The only way to do this in a fully automatic fashion is by using the
business features with the tax tables and writing invoices.

Although this system only really works for accrual accounting, because
the VAT/GST will posted to VAT due, unless you route it through some
temporary accounts.

For entering it in the General Journal directly:

I guess you already know the built-in calculator features of gnucash, so
that you could write 1*105 to get the $105 paired with the use of
account numbers for making the entry easier.

But for what it’s worth I also would like to have a way to have a column
for the tax-table to use in the transaction register.

However for I seem to have understood it’s very deeply ingrained in the
business features, that it would be a lot of work to do so.

Kind regards

Christian Kluge

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
The choices you make, whether good or bad,  make you more of who you are and 
less of who you could be.

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] No Disk error

[elvis]

4. Yank out the cable connecting the drives to the motherboard :-) If 
you never use it



On 30/08/18 15:09, Arthur wrote:
As Colin suggested, I Googled the error message. [Silly of me not to 
look beyond the gnucash archives.]  I've summarized the 3 suggested 
solutions which I tried, and I also have a thought for consideration 
by the developers.


First, I have a Dell XPS from 2010 that came with *4* memory card 
reader slots that I have never used (before today). It is running 
Windows 7.  For every GnuCash 3.x (including a couple of recent 3.2 
maintenance releases) I see the following.
If I select "Import transactions from CSV...", I have to cancel 24 no 
disk pop-up windows (6 for each slot) to continue.  This happens every 
time I try to import transactions. I don't want to be a whiner, but it 
quickly becomes annoying.


Here's what I tried that worked.
1) Keep media in the drives.  I scrounged through a box of old stuff 
and found a compact flash card.  Inserting that into the reader 
eliminated the error for that slot.  Woo-Hoo.  Only 18 pop-ups to 
cancel.  I presume if I fill all the slots, the errors will disappear 
entirely.


2) Disable each drive that causes a problem.  I opened the Device 
Manager in the control panel. The item "Disk drives" lists all the 
drives on the machine including those for the memory cards. Disabling 
a drive eliminates the error for that drive.  If I disable every 
memory card drive, all the pop-ups are eliminated.


3) Hack the registry.  Go to the registry entry
"Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Windows"
The default value of of the DWORD "ErrorMode" is "0".  Change 
"ErrorMode" to "2".  Pop-ups gone. The following link gives more 
explanation
https://support.microsoft.com/en-us/help/124873/disabling-system-hard-error-message-dialog-boxes 


I pasted the following advice from that page.
"To run an unattended server, use mode 2. The default value is 0."
The implication being one will have to make a visit to the previously 
unattended server to click on the pop-ups in the event of an error 
since the server will hang until they are cleared.


Here's my humble thought for consideration by the developers.  If I'm 
reading the documentation correctly (a big if), the state of ErrorMode 
can be controlled programmatically on a per process basis via the 
Windows API.  I think it might solve the problem if sometime shortly 
after Gnucash starts, it calls "SetErrorMode(SEM_NOGPFAULTERRORBOX)".  
Below is a link to the description of the Windows function 
SetErrorMode().
https://msdn.microsoft.com/en-us/library/windows/desktop/ms680621(v=vs.85).aspx 

Assuming it works, perhaps you would consider adding that to the 
Windows port?


Regards,
-Arthur

On 8/23/2018 3:23 AM, Colin Law wrote:

Googling  for that error message finds lots of hits.  It seems to be
do do with having a drive that windows thinks is there but actually
isn't.  Something like that anyway.  There are some solutions offered.

Colin
On Thu, 23 Aug 2018 at 04:39, jeffrey black 
 wrote:

On 8/22/2018 1:43 PM, Adrien Monteleone wrote:
Were either of you at any time storing your GnuCash files on an SD 
card?


If so, I’d suggest using a card to load the file, then doing a Save 
As elsewhere (with the card still in the drive). Then close and 
re-open GnuCash to load from the new location. THEN Safely Eject 
and remove the SD card.


Otherwise, some sort of bug is at play.

Regards,
Adrien


On Aug 22, 2018, at 7:30 AM, Mike stagl  wrote:

I have the same issue on Windows 7 and GnuCash 3.2, and I believe 
its because I have several SD card readers on my machine and no 
cards installed in them.



I haven't looked into a work around yet, but I agree its highly 
annoying.



I figure I'll need to uninstall my SD card readers in order to 
stop the alerts.



Anyone else have any thoughts?


Mike



From: Patrick Murez 
Sent: Wednesday, August 22, 2018 1:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] No Disk error

Dear all I want to report a problem already submitted in this 
mailing list

with no answer so far:

Hi!

I am starting over with gnucash, and thought I'd do a clean 
re-install.

Note, I am on windows, and have removed all the gnucash files I could
find before installing 3.1.

However, now I am getting an annoying error message every time I 
try to

look at the preferences, as well as when I do "save as":

Gnucash.exe - No Disk
There is no disk in the drive. Please insert a disk into drive
\Device\Harddisk1\DR1.

I have the options Cancel, Try Again and Continue. Try Again just 
pops

up the message again, so do the other two too. However, if I click
enough times on Cancel or Continue, the message goes away.

Note, when I change something in Preferences, that change stays 
when I

quit and restart.

This is quite annoying, and if anybody could shed some light on 
what has

happened and how to get rid of said message, I'd be very happy.

Re: [GNC] Process Payment and convenience fees

[elvis]

On 27/08/18 03:16, Justin H Haynes wrote:

I have two invoices to pay to a utility company.  Let’s say the amounts of the 
invoices are $200 and $300 for a total of $500.  I have paid $600, so the 
payment correctly is applied to those two invoices, and $100 to the Accounts 
Payable account.  I can see the three transactions in Account payable.  
Actually 3 splits - 1 for each of the amounts of the 2 invoices, and 1 for the 
remainder, then on the other side of the transaction the $600 from 
Liabilities:Credit Card.

However, there was a convenience fee charged by the payment processor for the 
city utilities.  So, the amount charged to my credit card was $603.49.

Will the best way to deal with this be to edit the split from the 
Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?


If it a fee that is incurred solely for paying the bill then it is part 
of your utility bill.








Thanks!,

Justin


___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Tomorrow is the most important thing in life. Comes into us at midnight very 
clean. It's perfect when it arrives and it puts itself in our hands. It hopes 
we've learned something from yesterday

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Autofill with Open Date?

[elvis]

On 09/06/18 07:30, Tim Rosanelli wrote:

Hey Maf,
Thanks for the advice.
I thought about a solution like that but wouldn't that mean you don't
have any customer history.
Kyoshi Tim

Hi Tim,
For purchases, what I do is import a few weeks at a time from the bank 
using a qif file. I don't use the business features as they are 
incredibly clunky if you just want to enter a Mars bar or series of 
small items. That gives the correct date etc and lets me split the 
transaction automatically to add gst before the import.


Cheers
Lawrence



___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Political Correctness: a method to mask one's phobias

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Mailing list filter no longer working

[elvis]

Just wondering if something changed in the list-ID, Thunderbird no 
longer recognises gnucash emails


--

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Upgrading to 2.7 series

[elvis]

Thanks John for the comprehensive answer, I will hold off until 3.0


On 14/03/18 00:30, John Ralls wrote:



On Mar 13, 2018, at 4:47 AM, elvis <el...@dogonfire.com> wrote:

Hi,

I run Gnucash under Gentoo and it has recently recommended it be upgraded to 
2.7.4


Currently I use 2.6.15

I was wondering if there was any real problem with doing this? I understand the 
database changes format, that's not a problem.

The reason Gentoo recommends upgrading to 2.7.x is that 2.6.x requires an old 
version of libwebkit and Gentoo wants to get rid of that dependency. 2.7.x uses 
up-to-date libwebkit.

Unfortunately 2.7.x is an unstable release series with frequent releases and 
Gentoo isn’t keeping up: 2.7.4 was from the end of January, we just released 
2.7.6 yesterday and will release 2.7.7 next weekend. If everything goes well 
3.0 will follow the weekend after that.

I’d recommend *not* installing 2.7.4. 2.7.6 is much more stable, but there are 
still a couple of significant bugs that we know about. If you want to be a 
beta-tester you could install that, but if you just want to get your accounting 
done you should wait for 3.0.

Regards,
John Ralls



___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Upgrading to 2.7 series

[elvis]

Hi,

I run Gnucash under Gentoo and it has recently recommended it be 
upgraded to 2.7.4



Currently I use 2.6.15

I was wondering if there was any real problem with doing this? I 
understand the database changes format, that's not a problem.


Thanks

Lawrence

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing splits

[elvis]

On 27/02/18 01:59, David Carlson wrote:
I believe the OP does not want to use a csv to qif converter. Perhaps 
whichever one he tried was difficult to use.


Or maybe he wishes that his bank would do the split for him
David C





I got a python script written to put the Australia gst split into 
downloaded bank (qif) files. Otherwise there doesn't seem to be any way 
of accounting for it short of putting every purchase through the 
invoicing system. And that just isn't reasonable or practical for a 
large volume of transactions.


I've never used a commercial product, I've always wondered how they 
handle it.


Lawrence


On Feb 26, 2018 5:39 AM, "elvis" <el...@dogonfire.com 
<mailto:el...@dogonfire.com>> wrote:




On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is
that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

     deposit cheque           bank dx 100.00
     cheque 1        Alice    membership     rx 50.00
     cheque 2        Bob      membership     rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking
to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0
(which we are
preparing for release, hopefully next month).

I've been importing multi split transactions for years using the
qif importer. Am I missing something here?

Cheers
Lawrence
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: importing splits

[elvis]

On 24/02/18 03:39, Geert Janssens wrote:

Op vrijdag 23 februari 2018 16:06:37 CET schreef Jeff Abrahamson:

Thanks.  I see my question wasn't clear.  My problem is that I want to
import the splits and it seems I can only import transactions.

I.e. (super simplified):

 deposit cheque   bank  dx 100.00
 cheque 1Alicemembership rx 50.00
 cheque 2Bob  membership rx 50.00

Jeff

Assuming this is one transaction, you are essentially asking to import multi-
split transactions.

This is not possible in gnucash 2.6, but it will be in 3.0 (which we are
preparing for release, hopefully next month).
I've been importing multi split transactions for years using the qif 
importer. Am I missing something here?


Cheers
Lawrence
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: General Ledger

[elvis]

On 25/02/18 07:54, Dave H wrote:

Well from my point of view that is confusing.  Nobody in my world refers to
a "General Journal" we refer to the "General Ledger" and we do journals
:-)  I've never actually heard the term general journal used anywhere
before until this discussion over the weekend !!!


You weren't in my accounting class where we got the use of the general 
journal beaten into us :-) I can still remember it 30 years later. Maybe 
it's an Australian accounting thing.

Cheers Dave H.

On 24 February 2018 at 19:58, Geert Janssens 
wrote:




___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.