Re: [GNC] check printing

[R. Victor Klassen]

Back in the day, I worked at Xerox.  We had special MICR toner that worked with 
some of our printers.  Once I changed banks and they printed a stater set of 
personalized checks complete with the MICR

Sent from my iPhone

> On Apr 5, 2024, at 2:50 PM, John Ralls  wrote:
> 
> 20 or so years ago I had a small company and used check-printing software to 
> make the checks. I used generic pre-printed forms and the software included 
> the MICR font and printed the routing id and account number in the 
> appropriate place at the bottom. Back then the bank sent the completed checks 
> back with the statements and every once in a while there'd be a strip of 
> paper taped to the bottom of the check with the MICR line repeated. I guess 
> that read failures were common enough that they had a procedure and probably 
> a machine where a human would read and retype the MICR line to make and 
> attach that strip when the regular read failed.
> 
> Regards,
> John Ralls
> 
>> On Apr 5, 2024, at 8:19 AM, R Losey  wrote:
>> 
>> While things may have changed, many years ago when I worked in the bank,
>> the info at the bottom of the check was printed with a special ink (I think
>> they called it a magnetic ink) so that the routing and account numbers
>> could be scanned by a computer.  The rest of the check is regular printing.
>> 
>> Moreover, I suspect that the banks don't like people being able to print an
>> entire check, as a small tweat of an account number might pull the money
>> from the wrong account.
>> 
>> 
>>> On Fri, Apr 5, 2024 at 5:08 AM Andrea Bryant 
>>> wrote:
>>> 
>>> I was wondering if you need to use a pre-printed check or can you use
>>> blank check stock and have the routing and account numbers printed out
>>> by GnuCash.
>>> --
>>> */Andrea Bryant/*
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>> 
>> 
>> 
>> -- 
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] How can I book Sales when invoice is paid vs when posted?

[R. Victor Klassen]

What you want is cash accounting and Gnucash is set up for accrual based 
accounting.  

In our jurisdiction certain businesses are permitted to use cash accounting for 
income tax (and there are, for some, advantages to doing so) but all businesses 
are required to use accrual accounting for sales tax.  

What I wind up doing is posting the invoices that span the year boundary to 
December 31 until I have filed the sales tax return, and then reposting them to 
the first of the year before generating the reports for income tax.  And I do 
the reverse for bills received but not paid by the end of the year.  

Sent from my iPhone

> On Mar 3, 2024, at 12:43 PM, Murugan Muruganandam 
>  wrote:
> 
> when you are posting the invoice, select year 2 date, then your book should 
> reflect it on the corresponding year
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Blake Hannaford 
> Sent: Sunday, March 3, 2024 12:46 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] How can I book Sales when invoice is paid vs when posted?
> 
> Sometimes I send an invoice to a customer in year 1, but the payment is
> received in year 2.   Gnucash always seems to credit the Income/Sales
> account when posted, but then my income for Year 1 taxes is overstated, and
> Year 2 is understated.I know you can select different accounts
> receivable accounts for the post but how can I not boost Sales until the
> invoice is paid?
> 
> Thanks!
> 
> --
> Blake Hannaford
> --
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]

[R. Victor Klassen]

Years ago - like in the 60s and 70s, there were adding machines - things that 
were replaced with what we now call calculators - that had a ‘feature’  - in 
some case the only mode of operating - that the decimal point was assumed two 
to the left of the last digit.  This was a great time saver - you never had to 
hit the decimal point between dollars and cents - if there was no decimal, it 
just assumed you were typing cents.  They typically had a 00 button too, so 
when you actually wanted integer dollars, you didn’t have to type .00 (three 
key strokes) just 00 (one).

I have got to believe “automatic decimal” is emulating that behaviour.  And no 
wonder nobody has that setting on anymore.  

It’s consistent with all the “bug” examples that have been shown.

> On Dec 1, 2023, at 2:43 PM, Mark via gnucash-user  
> wrote:
> 
> Dec 1, 2023 13:37:32 Adrien Monteleone :
> 
>> It seems the code for auto-decimal is occurring with each numerical entry, 
>> rather than the final result.
> 
> To me it seems the least surprising way for auto-decimal to work would be if 
> it only applied when you enter an amount directly. I wouldn't expect it to 
> apply to the result of a calculation. (Issues like this is why I don't use 
> auto-decimal. I don't like decimals appearing where I didn't put them.)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Linking credit notes

[R. Victor Klassen]

Morning all,

I have an invoice from August that was generated in error, but because it 
included tax which is reported quarterly my options do not include unposting 
it.  (Not that that would be best practice from an accounting POV). 

So I generated a matching credit note which automatically got matched up with 
several newer invoices making them appear to be paid while leaving the old on 
outstanding.  

Did I get something wrong in creating the Credit note?  Is there a way of 
clearing it up so it pays the right invoice?

Sent from my iPhone
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Should GNUCash allow a split to reference the same account twice

[R. Victor Klassen]

Just to add one more instance, the business features, regularly do this, when 
entering a bill or invoice.  

10 items on an invoice/bill could correspond to as many as 10 different 
income/expense accounts, or as few as one.  Once the transaction has been 
posted, (one transaction per invoice/bill), you can look it up and find one 
split per line item, and these may all be to the same account, or not, 
depending on whether they should.

> On Jul 20, 2023, at 2:35 PM, David Carlson  
> wrote:
> 
> Yes.  I do it monthly in some accounts where I make a minimum payment on a
> loan and separately add an additional amount.
> 
> 
> 
> On Thu, Jul 20, 2023, 1:18 PM Henry Law  wrote:
> 
>> Earlier today my wife was running GNUCash to update "her" bit of the
>> accounts and got into a serious tangle because she (inadvertently)
>> changed a newly-imported transaction so that its two splits -- which
>> should have been our current account and her credit card account --
>> both referred to the credit card account.  She then reconciled one half
>> and not the other, which caused a cascade of issues which took me
>> several hours and a manual edit to the GNUCash file to fix.
>> 
>> Should GNUCash refuse to allow a transaction to have two splits into
>> the same account?  My knowledge of accounting is scant, but with it I
>> can't see why one would ever legitimately do that.
>> 
>> --
>> --
>> Henry Lawn e w s @ l a w s h o u s e . o r g
>> Manchester, England
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] In Praise of Excellent Features

[R. Victor Klassen]

I would add, a few versions back we had a change to how account names are 
filled in/suggested.

I understood the feature would let me type
Greenhouse:Tom in order to get Income:Produce Sales:Greenhouse:Tomatoes 
which is better than the old
Income:Produce Sales:Greenhouse:T  filling in the rest of Tomatoes.

… which was cool enough, but it turns out I can type

Gre:T and get the same effect.

[your mileage may vary if your chart of accounts doesn’t include Income:Produce 
Sales:Greenhouse:Tomatoes]


> On Jun 3, 2023, at 4:30 PM, David Klann  wrote:
> 
> (Replying to the digest summary...)
> 
> Hear, Hear NoobAlice! Thank you for this great summary of little-known (to me 
> at least) features!
> 
> On 6/3/23 11:00, you wrote:
>> Hello All!
>> No questions, just joy!  Thank you to all the devs and to everyone who
>> gives advice in the mailing list!
> 
> To this I add my thanks. I have been using GnuCash for about six years to 
> keep books for my sole proprietorship consulting practice. Each new release 
> brings more satisfaction!
> 
>> I have been happily using GnuCash for years.  Today I was poking through
>> the menus to see if I could find an Expand All/Collapse All option for
>> the accounts tree, when I saw other options I had never previously noticed.
>> New treats:
>> Edit > Cascade Account Properties
>> For an account and all its subaccounts, you can change all the colors,
>> set placeholder status, and/or set hidden status.
>> Edit > Renumber Subaccounts
>> WOW!  This has been the bane of my existence when working with
>> QuickBooks-using clients who have never numbered their charts of
>> accounts, as the external program we use requires numbered accounts.
>> This looks so efficient!  I am accustomed to manually changing account
>> numbers one. by. one.
>> Actions > Rename Page
>> This looks so convenient.  You can even rename the Accounts page!
>> And my favorite options that are good friends:
>> Variables
>> You can use variables in scheduled transactions.  For example, if you
>> are entering a paycheck and you like to split out taxes and deductions,
>> you can just fill in the blank for "grosswages" and have GnuCash compute
>> all the line items.
>> Credit Salarygrosswages
>> Debit Income Tax grosswages*0.10 ### 10%
>> Debit Retirement grosswages*0.05 ### 5%
>> Debit Local Tax  3.98### assuming fixed amount
>> Debit Health Insurance   100.00  ### assuming fixed amount
>> Debit Checking Acct  grosswages*(1-0.15)-3.98-100### net of above
>> Spreadsheets
>> One can just copy a GnuCash report and paste into a spreadsheet for
>> further manipulation, which is great for generating external reports for
>> non-coders such as myself.
>> Custom Shortcuts
>> Two simple edits to ~/.local/share/gnucash/accelerator-map, and I have
>> shortcuts to open the Saved Reports list with Ctrl+A and turn
>> double-line view on/off with Ctrl+D!!!
>> ;
>> ; Double-line register on/off
>> (gtk_accel_path
>> "/GncPluginPageRegisterActions/ViewStyleDoubleLineAction"
>> "d")
>> ;
>> ; Saved reports configuration list
>> (gtk_accel_path
>> "/gnc-plugin-menu-additions-actions/AdditionsAction/4d3dcdc8890b11df99dd94cddfd72085Action"
>>   "a")
> 
> To this great list of awesome features I add: thank you for the excellent 
> instructions for compiling GnuCash from the git sources.
> 
> I recently learned that the 5.1 flatpak (at FlatHub) would not work with the 
> Python API. I have been hoping to explore it in order to write a custom 
> invoice printing tool. I set off to compile from the git repo and was led to 
> the wiki for compiling on Linux. Work perfectly for me on the first attempt.
> 
> Now to continue my education in the Python interface...
> 
> Thank you!
> 
>  ~David Klann
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Reporting Woes - Newbie incompetence

[R. Victor Klassen]

What works for me is just selecting the contents of the report and doing copy.  
Then opening a spreadsheet and doing paste 

Sent from my iPhone

> On Mar 24, 2023, at 12:41 PM, Brook Milligan  wrote:
> 
> 
>> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  wrote:
>> 
>> I use a transaction report for what you seek.  With the right options I get 
>> the account, date, description and amount.  Copy paste the result into a 
>> spreadsheet 
> 
> Perhaps I am doing something wrong, but how do you copy/paste the result into 
> a spreadsheet.  
> 
> My understanding is that the reports are HTML documents.  Perhaps there is 
> some magic I am not aware of?
> 
> Cheers,
> Brook
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Reporting Woes - Newbie incompetence

[R. Victor Klassen]

I use a transaction report for what you seek.  With the right options I get the 
account, date, description and amount.  Copy paste the result into a 
spreadsheet 

Sent from my iPhone

> On Mar 24, 2023, at 12:30 PM, Michael or Penny Novack 
>  wrote:
> 
> 
>>> The end of the UK Tax Year approaches and I am thinking about my tax
>>> return. When I used Quicken there was a report that listed every
>>> transcation in particular accounts which was useful since not all my
>>> accounts are related to the Return.  I had been hoping to do the same in
>>> GNU but I don't seem to be able to find a way to do something so simple.
>>> (Yes I have read all about Reporting but am not a lot the wiser)
>>> 
>>> Opening a relevant account, choosing Select All, Copy and Paste into a
>>> spreadsheet does not seem to be possible either.
>>> 
>>> I am sure that somebody has worked out how to do this hence my request.
> 
> Keep in mind jurisdictions differ, so what I am about to describe would be US 
> (and 501(c)3 non-profits)
> 
> Gnucash is a basic accounting system, keeps standard double entry books. You 
> need to set up your CaO so that the data will be usefully grouped for tax and 
> other reporting purposes. BUT  also keep in mind that you might have to 
> do some work outside of gnucash because you might need to be reporting to 
> different entities (the state might require different from the feds) and you 
> can have only one hierarchy of accounts.
> 
> For example, "printing and postage" is a line item on the 990/990-EZ 
> *Federal" so each expense parent that has those as a component of that 
> parent's total* should have a separate "printing and postage" child. If what 
> you "pay" and intern is partly PAY and partly Mileage Reimbursement you'd 
> want those as separate children under that intern (because the pay part might 
> mean a 1099-MISC)
> 
> In other words, it is going to be up to YOU to create a suitable CoA so it 
> will make it easy to get the data you need for the reports you must fill out.
> 
> Michael D Novack
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Demo accounts

[R. Victor Klassen]

I would start by exporting some of your own stuff to .csv

That will tell you what the native GNUCash csv input format looks like.

Now you can go to a spreadsheet and create transactions to your heart’s content 
using dates that are based on formulae (like every 14 days put in the same 
transaction). and so on.
Save that to csv, and import it into a brand new file.

> On Feb 5, 2023, at 6:05 AM, Michelle  wrote:
> 
> This is going to be a bit of an odd question, but hey ho.
> 
> I have a very small channel and would like to make a small video about
> GnuCash and reporting insights for the average home user.
> 
> What I'm looking for is a set of demo accounts.
> 
> Nothing serious, just a bank account and a credit card, showing wages
> coming into the bank account monthly, the credit card being paid off
> monthly, and a series of transactions on the credit card, like
> supermarket, cd, dvd, fuel, that sort of thing... covering maybe five
> years with some simple categories to cover the spending.
> 
> So, nothing complicated like interest or multiple currencies, or
> anything like that.
> 
> Is there something out there please, or something I can do to make
> creation a bit easier?
> 
> Many thanks,
> 
> Michelle.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Entered Date, UX Question

[R. Victor Klassen]

For the business features there is the entered date and the posted date, and 
they may differ in either direction.  That way I can enter something in 
January, but post in last December because it really belonged then, but I 
hadn’t gotten to it, and it shows up correctly under the rules accrual based 
accounting.  And I can fake it by posting it to the first of January if it is 
paid in January and I’m using cash based accounting for tax purposes.   In this 
case I could see having the entered date the date of import, so long as the 
posted date is the date I had set when I posted it.  Not sure what Quicken does 
here or allows me to do (been well over a decade).

If I just enter the transaction directly in a register and I want to get it 
connected to the right date for cash or accrual basis, I want the date that 
appears to be in the register to match what it was when I put it in.  Because 
to me that is the posted date. 
If GnuCash has a separate entered date for all transactions (and I think it 
does), and that date is not visible (except for when probing the database 
directly), I would be happy to have the entered date be the imported date, so 
long as the posted date isn’t mucked with.  But that’s just my two cents.

> On Feb 4, 2023, at 8:00 AM, m...@tgr66.me wrote:
> 
> Hello!
> 
> I’m writing an app to help people migrate to GnuCash (primarily from Quicken, 
> in my case Quicken for Mac), and I’m using PieCash to write sqlite3 file. 
> I’ve read/searched the docs, and so I believe I understand the concept of a 
> transaction entry date into an accounting system, and that users generally 
> won’t ever see it, or perhaps I should just say “edit it”.
> 
> I’ve realized that I can export entered dates from Quicken, and so here is my 
> question.
> 
> As a user of GnuCash, if you were to migrate data from another system, would 
> you expect the entry/entered date to be when you migrated the data or when 
> you first entered it into your personal financial management system?
> 
> I know some of you are experts in the field of accounting AIS, and so I 
> welcome your thoughts too. If, one of the two approaches *must* be followed 
> because of accounting rule (especially for businesses), please let me know.
> 
> Thank you for your help.
> 
> Tim
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Best way to link an overpaid invoice and credit note?

[R. Victor Klassen]

Enter the new invoice without the credit.  When you go to pay it, you will find 
it offers the reduced amount. 
But first change the other one manually at the transaction where it is coming 
out of your bank
Sent from my iPhone

> On Feb 3, 2023, at 1:43 PM, Dr. David Kirkby  
> wrote:
> 
> I have 4 transactions in my GnuCash accounts to a vendor RS with whom I
> have an account, and must pay by 20th of the following month. The amount of
> all the transactions is entered correctly, with a total of £322.70. I then
> put one payment in GnuCash, which was a split payment for all 4
> transactions. However, when actually paying RS from my mobile banking app,
> I paid £332.70 instead of £322.70. So there's an overpayment of £10. So
> when RS invoiced me again, it they have deducted £10 due to the
> overpayment.
> 
> I don't know the best way to handle this. I obviously need to change the
> payment in GnuCash to be £10 more than before. But I'm unsure how I can now
> pay those 4 transactions, plus an extra £10, unless I delete them all, then
> try to pay the 4, but change the amount GnuCash suggests, to an extra £10.
> 
> Should I unpost them? I was thinking of creating an asset account, and
> calling it something like 'credit notes', and moving the £10 to there. But
> next time I pay RS, which will be for several hundred pounds, how could
> GnuCash be told to credit the credit note by £10, and credit the bank
> account by the rest?
> 
> Dr David Kirkby Ph.D
> Email: drkir...@kirkbymicrowave.co.uk Web:
> https://www.kirkbymicrowave.co.uk/
> Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
> Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Strange crash (macOS specific)

[R. Victor Klassen]

Thanks.  I’ll keep an eye out for it, and try that if it happens again.  I have 
Xcode and the command line tools installed on that machine, so if it happens, I 
can try that.

It was several weeks before instances so far.

> On Jan 30, 2023, at 5:16 PM, John Ralls  wrote:
> 
> 
> 
>> On Jan 30, 2023, at 11:43 AM, R. Victor Klassen  wrote:
>> 
>> Twice now I’ve had a totally new failure mode.  For whatever reason Gnucash 
>> crashes and then when I reopen it crashes faster than I can say jack 
>> Robinson.  Looking in the crash report it is failing to satisfy itself with 
>> the code signing and aborting.   I reinstall and the problem is resolved.  
>> Or is it?  It recurred about two weeks later. 
>> 
>> I don’t know enough about Apple’s codes signing to see how this could even 
>> happen.  The signature should not be something that can be changed.  
>> 
>> Anyone else see anything like this?
>> 
> 
> The signature can't be changed, but the thing that's signed can. If you do 
> then the signature becomes invalid and Gatekeeper will fail to validate it.
> 
> AFAICT codesign only signs mach-o binaries, that is the GnuCash and AQBanking 
> executables in Contents/MacOSX/ and the shared libraries (*.dylib) and 
> loadable modules (*.so) in Contents/Resources/lib.
> 
> You can get some information about what if anything is wrong with the 
> signature with 
>  spctl --assess -vv /Applications/Gnucash.app/
> If everything is OK it will print
>  /Applications/Gnucash.app/: accepted
>  source=Notarized Developer ID
>  origin=Developer ID Application: John D Ralls (Y9EHT5WMK7)
> 
> I don't know if codesign is installed without the command-line tools or 
> Xcode, but if you have it you can get a lot more information with
>  codesign -dvvv /Applications/Gnucash.app/
> including what component's signature is invalid.
> 
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Strange crash (macOS specific)

[R. Victor Klassen]

Ventura 13.0.1 on a Mac mini with an m1 chip. And gnucash is 4.13 build 
2022-12-17.  

Sent from my iPhone

> On Jan 30, 2023, at 2:47 PM, R Losey  wrote:
> 
> 
> What version of MacOS are you using? I'm on Monterey (12.6.3) and I'm not 
> having any problems with GnuCash.
> 
> 
>> On Mon, Jan 30, 2023 at 1:43 PM R. Victor Klassen  
>> wrote:
>> Twice now I’ve had a totally new failure mode.  For whatever reason Gnucash 
>> crashes and then when I reopen it crashes faster than I can say jack 
>> Robinson.  Looking in the crash report it is failing to satisfy itself with 
>> the code signing and aborting.   I reinstall and the problem is resolved.  
>> Or is it?  It recurred about two weeks later. 
>> 
>> I don’t know enough about Apple’s codes signing to see how this could even 
>> happen.  The signature should not be something that can be changed.  
>> 
>> Anyone else see anything like this?
>> 
>> Sent from my iPhone
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
> 
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Strange crash (macOS specific)

[R. Victor Klassen]

Twice now I’ve had a totally new failure mode.  For whatever reason Gnucash 
crashes and then when I reopen it crashes faster than I can say jack Robinson.  
Looking in the crash report it is failing to satisfy itself with the code 
signing and aborting.   I reinstall and the problem is resolved.  Or is it?  It 
recurred about two weeks later. 

I don’t know enough about Apple’s codes signing to see how this could even 
happen.  The signature should not be something that can be changed.  

Anyone else see anything like this?

Sent from my iPhone
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] reconcile dates

[R. Victor Klassen]

When I write a post dated cheque and the recipient cashed it prematurely, most 
banks these days don’t blink an eyelash.  

While rare, this is a case where a transaction dated after the reconciliation 
window needs to be included.  

Sent from my iPhone

> On Jan 7, 2023, at 5:29 PM, Gyle McCollam  wrote:
> 
> I to don't see the need to include transactions whose date falls beyond the 
> closing date of the reconciliation.  Gnucash could cutoff any transactions 
> whose date is after the closing date.  However, I will say that I have gotten 
> used to this little quirk and since I import most of my monthly transactions 
> (and the financial institution knows how to cut off transactions beyond the 
> closing date) using QFX, when I reconcile the needed transactions have 
> already been checked and the ones after the closing have not.  Even though in 
> a manual reconciliation you wouldn't even look at transactions after the 
> closing date, it does no harm to include them.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> 
> 
> From: gnucash-user  on 
> behalf of David T. via gnucash-user 
> Sent: Saturday, January 7, 2023 3:54 PM
> To: Kevin T 
> Cc: Gnucash Users 
> Subject: Re: [GNC] reconcile dates
> 
> Your records and the bank's differ. The reconciliation date may include 
> entries that you've entered with later dates, and how would GnuCash determine 
> the proper cutoff?
> 
> Personally, I don't have trouble determining when the difference figure goes 
> to 0.
> 
> ⁣David T. ​
> 
>> On Jan 7, 2023, 11:45 PM, at 11:45 PM, Kevin T via gnucash-user 
>>  wrote:
>> Is there some reason that the reconcile feature looks past the closing
>> date specified?
>> I have imported numerous months of transactions for an account.  Trying
>> to reconcile only the first month with 0 balance and 0 transactions
>> before the starting date.  I provide the 'statement date' to the
>> reconcile feature and it brings up every transaction entered, even the
>> ones after the 'statement date'.
>> This is not how a person would reconcile this.  We could concern
>> ourselves with on the transactions that occur before the closing date
>> 'statement date'.
>> Is there something I am missing ?
>> Kevin
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Are accountants happy with CVS exports?

[R. Victor Klassen]

I do my own taxes (by hand).

> On Jan 4, 2023, at 8:33 PM, Dr. David Kirkby  
> wrote:
> 
> On Wed, 4 Jan 2023 at 22:29, R. Victor Klassen  <mailto:rvklas...@gmail.com>> wrote:
> I generally export a transaction report with all (relevant) accounts 
> selected.  I generally do a select-all from the open report window and then 
> paste it into OpenOffice/LibreOffice Calc. 
> 
> That I can sort on any key I like - normally date within (sub)account, and 
> run subtotals and look for anomalies.
> 
> If I find any I fix them and then re-export.
> 
> There may well be a pass to and from .csv after it’s pasted into the 
> spreadsheet.
> 
> But after you fix the anomalies and reexport, do you pass the exported files 
> to your accountant? 
> 
> I am quite tempted to give my accountant the files exported by GnuCash, but 
> offer to put them in a different format if he wants. If nothing else it will 
> make him aware of the program. 
> 
> Dave 
> -- 
> Dr. David Kirkby,
> Kirkby Microwave Ltd, 
> drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk>
> https://www.kirkbymicrowave.co.uk/ <https://www.kirkbymicrowave.co.uk/>
> Telephone 01621-680100./ +44 1621 680100
> 
> Registered in England & Wales, company number 08914892. 
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United 
> Kingdom

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Are accountants happy with CVS exports?

[R. Victor Klassen]

I generally export a transaction report with all (relevant) accounts selected.  
I generally do a select-all from the open report window and then paste it into 
OpenOffice/LibreOffice Calc. 

That I can sort on any key I like - normally date within (sub)account, and run 
subtotals and look for anomalies.

If I find any I fix them and then re-export.

There may well be a pass to and from .csv after it’s pasted into the 
spreadsheet.


> On Jan 2, 2023, at 4:30 PM, Dr. David Kirkby  
> wrote:
> 
> It would be nice if one could export all the expenses without the dates
> being in a random order. The only way I can find to get dates in a
> chronological order is to export every single account separately, so there
> are no sub accounts. I thought about trying to write some code that would
> allow all the expenses to be exported in one file in chronological order.
> That’s not an impossible task, but would take me quite a bit of coding. If
> I did it, I would just create something that’s command line driven, using
> as many as the unix tools as possible to cut down the work. It might be
> possible to just make a fairly complex shell script.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Inaccurate information about GnuCash at https://www.capterra.com/

[R. Victor Klassen via gnucash-user]

Interestingly, it claims GnuCash handles payroll, which is not actually a claim 
made by the developers/documentation.

Some of us use GnuCash for payroll, but so far as I know, everyone that does 
it, uses an external program to calculate the deductions.  It’s not super hard 
to do payroll for a small enough number of employees, specific to one 
jurisdiction.  Handling arbitrary jurisdictions and numbers of employees is a 
different matter entirely.

> On Dec 18, 2022, at 10:19 PM, Dr. David Kirkby 
>  wrote:
> 
> I stumbled across this link, comparing Sage to GnuCash
> 
> https://www.capterra.com/accounting-software/compare/125092-168740/GnuCash-vs-Sage-One-UK
> 
> The list of features given for GnuCash is a small subset of the actual
> features. GnuCash scores 3/13, and Sage 13/13. See the two screenshots.
> 
> I don’t know if it’s considered worth advising them of the serious errors
> in their feature list. I don’t know if GnuCash can do everything on the
> list, but it can certainly do more than 3.
> 
> 
> -- 
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
> 
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Changes: Macbook Pro

[R. Victor Klassen via gnucash-user]

Not entirely.  I downloaded 4.13 and there are still some issues in that ilk:
scrolling not working - neither with the scroll wheel on the mouse, nor 
by dragging the scroll bar;
can’t get window focus unless I grab the top of the window and move it 
around a bit

OpenOffice has some of the same issues.

As far as I can tell this is strictly an M1 chip running Ventura issue, so more 
specific than just Ventura.

> On Dec 19, 2022, at 6:57 PM, David Reiser via gnucash-user 
>  wrote:
> 
> That came from an incompatibility between Ventura and the gtk version 
> available when gnucash 4.12 was built. Fixed in gnucash 4.13 (released 
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble downloading OFX from Canadian Tire Bank

[R. Victor Klassen]

Thanks.  I’ll take a look when I’m at the machine where it happened - early 
next week.

> On Dec 16, 2022, at 1:27 PM, Vincent Dawans  wrote:
> 
> I recently helped somebody with an ofx file missing the  and 
>  tags. Both are required for gnuCash to remember how to match the 
> ofx to an account in your books. It remembers the first time then uses  
>  and  to redo the match on following imports. Although in 
> that case I think the import process would simply abort, I don't think it 
> crashed. If you don't see these tags, you can put whatever you want for both 
> tags as long as it is unique to files for that account in your books
> 
> Here is the sanitized example ofx file that was used when we discussed that 
> issue. The ACCTID and TYPE are part of the  group which could 
> also be missing. In testing in that case it was discovered that the  
> tag that is in the same group wasn't really needed (but it won't hurt if it's 
> there of course). If your file does in fact have a correct BANKACCTFROM 
> section and tags, then you might need to compare what other differences exist 
> and experiment to see if they are the source of the problem.
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NON
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:NONE
> 
> 
> 
> 
> 0
> INFO
> 
> 20220925094411
> ENG
> 
> 
> 
> 
> 1
> 
> 0
> INFO
> 
> 
> AUD
> 
> 123456789
> 123456789012
> CHECKING
> 
> 
> 
> DEBIT
> 2022092200
> -999.96
> 808288
> Transfer to censored - Receipt censored
> 
> 
> CREDIT
> 2022092200
> 999.99
> 788899
> censored - Internal Transfer - Receipt censored
> 
> 
> 
> 
> 
> 
> 
> On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen  <mailto:rvklas...@gmail.com>> wrote:
> I just downloaded the monthly credit card statement as “Microsoft money” 
> format which gave me a file with suffix ofx and header content that appears 
> to be OFX.  Importing it causes a prompt and consistent crash.  I tried 
> trimming out all transactions but one and it still crashes.  I’m assuming 
> there is something in the header causing the problem.  
> 
> I tried switching to Quicken and got a qfx file with the identical header 
> which I find suspicious. Attempting to open it was as fruitful as before.  
> 
> I don’t know whether it’s Gnucash or the file.  If the file I could likely 
> write a preprocessor to fix it.  Is there documentation somewhere as to what 
> is expected in the file?
> 
> 
> Gnucash 4.12 build 4.12+ (2022-09-24) 
> MaxOS Ventura on a 2022 Mac mini with an M1 chip
> 
> 
> 
> 
> Sent from my iPhone
> ___
> 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>
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble downloading OFX from Canadian Tire Bank

[R. Victor Klassen]

I did succeed in building once - I’m not sure how hard it will be to reproduce 
that success.  

The latest stable build is late September (which is what I’m running).   I 
don’t recall how long until the next release.  I was able to pull in the file 
using csv.

> On Dec 16, 2022, at 2:34 PM, Glenn Serre  wrote:
> 
> Good morning,
> 
> You may be crashing due to a recently fixed bug:
> https://bugs.gnucash.org/show_bug.cgi?id=798629
> 
> Can you download (or build) a more recent gnucash? You would want a
> gnucash built after Oct 7 2022.
> 
> -- Glenn S.
> 
> On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen  wrote:
>> 
>> I just downloaded the monthly credit card statement as “Microsoft money” 
>> format which gave me a file with suffix ofx and header content that appears 
>> to be OFX.  Importing it causes a prompt and consistent crash.  I tried 
>> trimming out all transactions but one and it still crashes.  I’m assuming 
>> there is something in the header causing the problem.
>> 
>> I tried switching to Quicken and got a qfx file with the identical header 
>> which I find suspicious. Attempting to open it was as fruitful as before.
>> 
>> I don’t know whether it’s Gnucash or the file.  If the file I could likely 
>> write a preprocessor to fix it.  Is there documentation somewhere as to what 
>> is expected in the file?
>> 
>> 
>> Gnucash 4.12 build 4.12+ (2022-09-24)
>> MaxOS Ventura on a 2022 Mac mini with an M1 chip
>> 
>> 
>> 
>> 
>> Sent from my iPhone
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Trouble downloading OFX from Canadian Tire Bank

[R. Victor Klassen]

I just downloaded the monthly credit card statement as “Microsoft money” format 
which gave me a file with suffix ofx and header content that appears to be OFX. 
 Importing it causes a prompt and consistent crash.  I tried trimming out all 
transactions but one and it still crashes.  I’m assuming there is something in 
the header causing the problem.  

I tried switching to Quicken and got a qfx file with the identical header which 
I find suspicious. Attempting to open it was as fruitful as before.  

I don’t know whether it’s Gnucash or the file.  If the file I could likely 
write a preprocessor to fix it.  Is there documentation somewhere as to what is 
expected in the file?


Gnucash 4.12 build 4.12+ (2022-09-24) 
MaxOS Ventura on a 2022 Mac mini with an M1 chip




Sent from my iPhone
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Overflow menus in invoices/bills not working in latest release on MacOS Ventura

[R. Victor Klassen]

Not transitory.  I don’t think the M1 chip should matter since it appears to be 
running under Rosetta.  But Ventura brings in its own versions of various 
libraries.  I rolled forward to get Xcode (for other work) but this appears to 
have been a side effect.  

Not generally a problem except when using invoices and bills.  In those cases 
the tool bar is so full I need to stretch the window to nearly covered the 
screen in order to get the post and pay icons.  

Sent from my iPhone

> On Dec 10, 2022, at 7:43 AM, R. Victor Klassen  wrote:
> 
> Adrian has it right.  I’m going to restart and see if it’s transitory.  
> 
> Sent from my iPhone
> 
>> On Dec 10, 2022, at 1:07 AM, Adrien Monteleone 
>>  wrote:
>> 
>> John,
>> 
>> It sounds like Victor is describing the ToolBar overflow 'menu'.
>> 
>> I can get this menu when I narrow my window width such that icons would be 
>> 'off window' to the right.
>> 
>> But I can't reproduce the behavior described. My overflow entries appear to 
>> work properly. (4.12 on Monterey)
>> 
>> Regards,
>> Adrien
>> 
>>>> On 12/9/22 10:05 PM, john wrote:
>>> Um, on macOS there aren't supposed to be menus on the window, they go on 
>>> the menubar at the top of the screen. If it's too wide macOS is supposed to 
>>> make room for it by hiding  as many of the "menubar extra" icons on the 
>>> right side.
>>> So is there somewhere that I've missed setting up the integration to put 
>>> the menus on the menubar or are you using a self-built GnuCash?
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Overflow menus in invoices/bills not working in latest release on MacOS Ventura

[R. Victor Klassen]

Adrian has it right.  I’m going to restart and see if it’s transitory.  

Sent from my iPhone

> On Dec 10, 2022, at 1:07 AM, Adrien Monteleone 
>  wrote:
> 
> John,
> 
> It sounds like Victor is describing the ToolBar overflow 'menu'.
> 
> I can get this menu when I narrow my window width such that icons would be 
> 'off window' to the right.
> 
> But I can't reproduce the behavior described. My overflow entries appear to 
> work properly. (4.12 on Monterey)
> 
> Regards,
> Adrien
> 
>> On 12/9/22 10:05 PM, john wrote:
>> Um, on macOS there aren't supposed to be menus on the window, they go on the 
>> menubar at the top of the screen. If it's too wide macOS is supposed to make 
>> room for it by hiding  as many of the "menubar extra" icons on the right 
>> side.
>> So is there somewhere that I've missed setting up the integration to put the 
>> menus on the menubar or are you using a self-built GnuCash?
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Overflow menus in invoices/bills not working in latest release on MacOS Ventura

[R. Victor Klassen]

I’ve not poked at it very long, but what I’m experiencing is if the window 
isn’t wide enough (my normal practice) there appears a menu on the right of the 
toolbar with (typically) one or more of Post, Unpost, Pay - possibly more.  
Normal behaviour is that I can select any of these by pulling down on this 
menu.  What I’m seeing is that the menu appears (with the little triangle), and 
I can pull down the menu, but the items in the menu don’t get shaded, and 
clicking on them only causes the menu to disappear.  This may be the case when 
not using invoices/bills, but I generally keep the window wide enough to avoid 
running out of icon space. (I’m currently at home and can’t test this without 
upgrading the OS on my personal machine, which isn’t an M1 anyhow, so it 
wouldn’t be a perfect reproduction).

There was a recent thread about having to click more than once for some things 
to work, and I’m wondering whether this is just another manifestation of the 
same thing.

I just installed the latest version of GnuCash on a shiny new Mac  (M1 chip),  
with the latest version of OSX (13, Ventura).  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] rounding of Invoice vs Accounts Receivable

[R. Victor Klassen]

We encounter the same problem in jurisdictions with tax computed after.  Which 
is to say this problem is not unique to having tax-in pricing advertised.

Where I see it is in bills where the GnuCash rounding differs from that used by 
the vendor.  And it only happens when there are multiple line items in the 
bill. GnuCash appears to total tax the taxable items and then round and sum the 
tax, whereas most vendors hereabouts add the taxable items and then multiply by 
the tax rate and round.  Because the “bill” I create within GnuCash is only for 
internal use, I add a pair of entries - one taxable and one non-taxable, that 
balance out the amount in Accounts Payable, while adjusting the amount of VAT 
paid to match that on the bill from the vendor.

In your case, is it making the invoice have the wrong total, or just your 
internal Accounts Receivable and/or VAT payable?  In the latter case you can 
make an adjusting transaction to fix it.  Ugly, and error prone, but possible.  
At least it only happens  of the time.

> On Oct 17, 2022, at 3:50 PM, Michael or Penny Novack 
>  wrote:
> 
> On 10/17/2022 11:03 AM, gnuc...@boeziek.nl wrote:
>> Hi,
>> I created a Sales Tax Table entry of 20%.
>> When I create an Invoice of EUR 109,95 with tax included and select my Tax 
>> table, GNUCash calculates EUR 18,33 tax and EUR 91,63 in net revenue.
>> My Accounts Receivable however will not increase by EUR 109,95 but by 
>> 109,96. So 1 cent difference. (the precise amounts are: sales is EUR 91,625 
>> and tax EUR 18,325 and thus both are rounded up)
>> 
>> Is there a way to have the tax rounded down (by 0,5cent) so that the total 
>> stays EUR 109,95?
>> I really prefer to have accounts being 0 at the end of a period, instead of 
>> all these loose cents adding up (makes reconciliation harder).
>> 
>> Thanks,
>> Etienne
> 
> This is NOT a rounded-up rounded-down issue. It is a when calculated issue if 
> both a set of items and their sum.
> 
> Rounded (A+B) does not (necessarily) equal (Rounded A) + (Rounded B) And 
> how far the distance can become depends on the number of items involved. If 
> there were a couple dozen items the range of "answers" could vary by several 
> units. The calculation of "fuzz" is a fine art (when a computer program is 
> checking for equality between amounts calculated in different ways the 
> program decides they are equal if the difference between them is less than 
> the "fuzz" -- and I have had to figure what the correct fuzz should be in my 
> days in the cypher mines)
> 
> SO --- what are the actual tax rules of the jurisdiction? If several items 
> are bought at the same time is the correct VAT the sum of the VAT due for 
> each item or is it the VAT due on the sum of the items?
> 
> Michael D Novack
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Billing Terms Due Date is Ignored

[R. Victor Klassen via gnucash-user]

It is possible to associate terms with specific customers, so all invoices 
going forward default [for those customer(s)] to their terms.


> On Aug 27, 2022, at 9:43 AM, Benjamin Soffer  wrote:
> 
> Never mind - I see what I am doing wrong.  I am failing to select "terms" 
> when I create the invoice.
> 
> Thank you
> 
> Ben
> 
> 
> 
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+bsoffer=soffer-law@gnucash.org] On Behalf Of 
> Benjamin Soffer
> Sent: 08/27/2022 6:37 AM
> To: Derek Atkins 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Billing Terms Due Date is Ignored
> 
> Just a Due Date.  Other terms are set to 0.
> 
> Ben
> 
> 
> -Original Message-
> From: Derek Atkins [mailto:de...@ihtfp.com]
> Sent: 08/27/2022 6:35 AM
> To: Benjamin Soffer 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Billing Terms Due Date is Ignored
> 
> What type of Bill Terms are you using.
> GnuCash only supports certain types in computing the due date.
> -derek
> 
> On Sat, August 27, 2022 9:24 am, Benjamin Soffer wrote:
>> Hello,
>> 
>> I'm using GNC version 4.8 (Build ID 4.8a - 2021-09-28) in Windows.
>> 
>> I have edited the Billing Terms so that the Due Date is +15 days.
>> 
>> However, when I post a new invoice, the Due Date set in the Billing 
>> Terms is ignored and the default due date that is displayed is 
>> identical to the post date.  See attached screen capture.
>> 
>> Any suggestions?
>> 
>> Thank you
>> 
>> Ben
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>> 
> 
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h

[R. Victor Klassen]

Just out of curiosity, how does one determine those numbers?  An SQL query?  
grep  | wc on the xml?  Some feature of gnuCash I’ve never discovered? 
 

> On Aug 8, 2022, at 3:54 PM, Derek Atkins  wrote:
> 
> 
> On Mon, August 8, 2022 3:21 pm, Robert Simmons wrote:
>>> Accounting systems primarily perform the same operation on large numbers
>> of data elements.
>> 
>> I wish I had time to devote to this. I use graph databases in many of the
>> other systems that I develop. This would be a great pivot point on which
>> to
>> create a new open source project and see which paradigm really is better.
>> But really I need to get my data organized and then handed off to an
>> accountant (so I can get back to working on my real work).
> 
> My GnuCash database, which has data going back to at least 2007, only
> contains 26781 transactions, with 59582 splits (at least 2 per
> transaction), over a total of 564 "accounts".
> 
> Even if you increase by a factor of 10, I doubt you're going to see any
> significant performance differences between databases of similar nominal
> performance.
> 
>> 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 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Request for two new features in GnuCash

[R. Victor Klassen]

Actually you can edit the suggested payment amount, and only “process” a 
partial payment.  Then you can pay again, using Process Payment, and pay with a 
different account for the second payment.

> On Aug 8, 2022, at 11:40 AM, Adrien Monteleone 
>  wrote:
> 
> I agree, this is already possible, but *not* using the 'Process Payment' 
> feature as it is currently implemented. (that is, if one is paying on a 
> Vendor invoice.)
> 
> To accomplish this, you have to enter the payment with multiple source splits 
> as Frank and others have noted, and AP as the debit split, then you have to 
> 'assign as payment' on the AP split using the right-click context menu. (you 
> might have to commit the transaction first, I don't recall if it works before 
> commit.)
> 
> This will then let you assign the multi-source payment to an Invoice.
> 
> I see the feature request as changing the Process Payment dialog to support 
> multiple sources. (A request I've seen here before)
> 
> 
> Regards,
> Adrien
> 
> On 8/6/22 11:19 PM, Frank H. Ellenberger wrote:
>> Am 07.08.22 um 03:04 schrieb Eric Hammond:
>>> The second is the ability to pay bills from more than one source. Example I 
>>> purchase an oscilloscope and pay for it with a cash incentive from the 
>>> company and a bank transfer for the rest. My solution at the present is not 
>>> pretty, nor helpful if I look at it next year.
>> Then it's time to claim your easter egg ;-):
>> Edit->Peeferences->Register Defaults,
>> select Default Style: "Auto-Split ledger" or "Transaction Journal"
>> More details in
>> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
>> Then you can easily enter the differnt amounts.
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Request for two new features in GnuCash

[R. Victor Klassen]

I routinely pay invoices from multiple accounts.  We have pseudo customers for 
each farmers market we attend.  After the market is done I create an invoice 
for the appropriate “customer “.  I pay it twice.  The first time with the 
amount that was paid by credit or debit card- to an account connected to the 
payment processor- and then the balance to petty cash.  

I have to edit the proposed payment amount the first time and then not close 
the invoice window before paying it again (I could close it and come back if I 
forgot but that’s not the efficient workflow)

Is this what you want?
Sent from my iPhone

> On Aug 7, 2022, at 3:18 PM, Eric Hammond  wrote:
> 
> Thanks again to all who answered my two part question (next time I will make 
> it two separate questions...)
> 
> Frank, I already have that selected. The problem is not how transactions are 
> entered or displayed.
> If I am entering a manual transaction, I can add any number of splits no 
> problem.
> The issue is specifically with the Bill, or Invoice, "Process Payment" form 
> which only allows one payment amount, and one transfer account (from the 
> account tree).
> If I bypass the "Process Payment" by using manual transactions the Bill or 
> Invoice is not closed.
> 
> All the best,
> Eric Hammond
> 
> 
> Message: 6
> Date: Sun, 7 Aug 2022 06:19:40 +0200
> From: "Frank H. Ellenberger" 
> To: Eric Hammond , "gnucash-user@gnucash.org"
>
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349f...@gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> 
> 
>> Am 07.08.22 um 03:04 schrieb Eric Hammond:
>> The second is the ability to pay bills from more than one source. Example I 
>> purchase an oscilloscope and pay for it with a cash incentive from the 
>> company and a bank transfer for the rest. My solution at the present is not 
>> pretty, nor helpful if I look at it next year.
> 
> Then it's time to claim your easter egg ;-):
> Edit->Peeferences->Register Defaults,
> select Default Style: "Auto-Split ledger" or "Transaction Journal"
> 
> More details in
> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
> 
> Then you can easily enter the differnt amounts.
> 
> Regards
> Frank
> 
> 
> 
> --
> 
> Message: 7
> Date: Sun, 7 Aug 2022 17:44:36 +1000
> From: flywire 
> To: Gnucash Users 
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
>
> Content-Type: text/plain; charset="UTF-8"
> 
> More cat skinning:
> 
>> * the ability to have two separate (at least) GnuCash file systems:
> *
> 
> In Windows (or probably any GUI) double-click file in data folder and it
> will use file association to open the file (in GnuCash).
> 
> Alternatively, for each file: right-click file, create a shortcut, drag
> shortcut to desktop. Same as above from desktop.
> 
> 
> --
> 
> Message: 8
> Date: Sun, 7 Aug 2022 06:28:50 -0500
> From: Tom Browder 
> To: Chris Good 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID:
>
> Content-Type: text/plain; charset="UTF-8"
> 
>> On Sat, Aug 6, 2022 at 21:25 Chris Good  wrote:
>> From: Tom Browder 
>> Sent: Sunday, 7 August 2022 12:37 AM
>> To: Chris Good 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Third party OFX/CVS providers
>> 
>> 
>> 
>> On Sat, Aug 6, 2022 at 08:51 Chris Good  wrote:
>> 
>> ..,
>> 
>> Can you copy the text out of the pdf statement?
>> 
>> 
>> 
>> Getting "organized" text programmatically out of PDF is a giant pain. My 
>> current approach is almost completely programmatic. BTW, Raku is the 
>> "sister" language of Perl, and it is a "scripting" language.
>> 
>> 
>> 
>> Raku can also use Perl modules so I can use Finance::Quote with it if need 
>> be. But, until I can get the bank data working, I won't be needing it.
>> 
>> 
>> 
>> Thanks, Chris.
>> 
>> 
>> 
>> -Tom
>> 
>> 
>> 
>> Hi Tom,
>> 
>> 
>> 
>> I was actually suggesting you just highlight the transactions in the pdf 
>> statement and copy/paste them into a
>> 
>> spreadsheet or text file before using a scripting language to reformat them 
>> but if you can programmatically
>> extract the text that would be better long term.
> 
> But I did see Peter West's warning about checking results
> carefully--it's not always the expected result. Although I hope the
> products from the same source are consistent enough to make it
> reasonably fool proof. (See my comments below.)
> 
>> I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows 
>> me to select text (as they want me to pay for a fancy tool - BOO) but if you 
>> send the pdf to Edge or Chrome you can select just the transaction text.
> 
> Yes, I now see my "PDF COmplete" on Windows can do that--I never
> thought of doing that until now.
> 
>> Thanks for the info re Raku.
> 
> You're welcome! I'm always happy for programmers to learn about Raku
> 
>> Finan

Re: [GNC] Revisiting the pre-paid invoice (coupon, credit note)

[R. Victor Klassen via gnucash-user]

Pretty sure that’s been around for quite a few versions.  I’ve been marking 
bills paid with Liabilities:Credit Card for as long as I’ve been using GnuCash 
(2012? 2013??)

> On Jul 14, 2022, at 2:31 PM, Eric Hammond  wrote:
> 
> Hold the presses!
> Just testing v4.11: It appears that it now allows for the 'assign as payment' 
> to use Liability accounts! (and matching process for Bills)
> I will report back after more testing!

___
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] Revisiting the pre-paid invoice (coupon, credit note)

[R. Victor Klassen]

Pretty sure that’s been around for quite a few versions.  I’ve been marking 
bills paid with Liabilities:Credit Card for as long as I’ve been using GnuCash 
(2012? 2013??)

> On Jul 14, 2022, at 2:31 PM, Eric Hammond  > wrote:
> 
> Hold the presses!
> Just testing v4.11: It appears that it now allows for the 'assign as payment' 
> to use Liability accounts! (and matching process for Bills)
> I will report back after more testing!

___
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] Deleting an account

[R. Victor Klassen]

I think the OP did, very clearly, describe in words what they wanted.  To whit, 
to combine the transactions held in the two children accounts into the parent 
account and remove those two sub-accounts.  They achieved this, and noticed 
that there could be some improvement to the workflow, in particular, handling 
of scheduled transactions involving an account being deleted with its 
transactions going to a known target account.

> On May 20, 2022, at 5:42 PM, Michael or Penny Novack 
>  wrote:
> 
> On 5/20/2022 4:07 PM, Gyle McCollam wrote:
>> I had a Parent Account:  Bank Name, with Subaccounts  Bank Name:Checking,  
>> and Bank Name:Special Checking.  I wanted to eliminate the subaccounts and 
>> end up with only the Parent account.
>> 
>> 
>>   1.  I changed the Parent account Bank Name from a placeholder account to a 
>> regular account.
>>   2.  I deleted Bank Name: Checking and moved all the transactions to Bank 
>> Name.  A dialogue box explained what I was about to do and asked if I sure I 
>> want ed to do this.  It gave me the choices of "Cancel" and "Delete".  That 
>> was slightly confusing, it would have been better if it was "No" and "Yes", 
>> even "No/ Cancel" and "Yes/Delete" would be more clear.
>>   3.  There were "Scheduled Transactions" (ST), involving the subaccount.  
>> It displayed the 10 ST and asked if I wanted to edit them.  I thought this 
>> was a REALLY GREAT feature and was thankful that it checked ST to see if 
>> they were affected.  However, I would be even better if it had substituted 
>> the account the transactions were moved to for the account that was deleted 
>> instead of just removing the deleted account (it leaves the associated 
>> split, which is also great).  That way the account could just be accepted 
>> without editing or edited only if need be.
> 
> 
> Describe in words, WHAT were you trying to do? You had two accounts at the 
> bank, "regular checking" and "special checking" and in gnucash you had 
> accounts for these these as children of a parent "bank name". How did you 
> want to end up? << was "special checking" to be a child of "regular checking" 
> or a sibling? >> Is that description correct for what you were trying to 
> accomplish?
> 
> In NEITHER case would you have to delete an account that had transactions in 
> it (and scheduled transactions, to boot) << the parent "bank name" was a 
> placeholder >> You simply alter the parent specifications of "regular 
> checking" and "special checking" so that "bank name" is no longer their 
> parent, delete the ex-parent "bank name", rename "regular checking" to "bank 
> name", and if you want "special checking" to be a child instead of a sibling, 
> specify its parent to be whatever name you have for that regular checking 
> account.
> 
> A useful hint for everybody. Sometimes you want an account to end up with an 
> account name still in use (at the moment, you are in the middle of 
> restructuring your CoA). Don't stop thinking you need to do things in s 
> special order. Just do the rename to a temporary name (like "qqq'"; you know 
> THAT name is not in use) and then later in the process when the name you 
> wanted to end up is available, you rename "qqq" to what you wanted to to be. 
> << this advice of course is not just about gnucash; more generally useful 
> when doing a sequence of renames >>
> 
> Michael D Novack
> 
> 
> ___
> 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] Reconciliation discrepancies

[R. Victor Klassen]

Well that would implicate data corruption 

Sent from my iPhone

> On Apr 12, 2022, at 10:20 AM, David T.  wrote:
> 
> Reconciled entries *are* marked read only. If you aren't getting a notice on 
> editing, it's because you told gnucash not to notify you any more. That can 
> be reset somewhere in the preferences. 
> 
> David
> 
> 
>> On April 12, 2022 5:25:51 AM PDT, "R. Victor Klassen"  
>> wrote:
>> I run into such issues once in every one or two blue moons.  The starting 
>> balance is off.
>> I’ve reconciled successfully the previous month, but something somehow 
>> (dis)appeared in the meantime.  I assume it disappeared, although the 
>> symptoms could be generated by something appearing.
>> 
>> I hope it’s more than a year old, and live with it.  Meaning I do a balance 
>> adjustment and move on.
>> 
>> It’s disturbing, but the size of my file is such that I have no reasonable 
>> means of tracking down whatever may have happened.
>> 
>> Possible that it’s user error, but unlikely.  Possible that it results from 
>> one of the periodic crashes I experience, or power failures, that appear to 
>> be fully recovered from at the time.  Pretty much impossible to reproduce.
>> If it is due to user error, that would be an argument in favour of the 
>> ability to mark old transactions as read-only.  Yes I’m very aware that 
>> “read-only” can be worked around.  But when it’s about protecting one from 
>> oneself, that kind of read-only could be useful.  If it’s due to bit 
>> rot/power glitches/crash recovery, not so much.
>> 
>>> On Apr 12, 2022, at 6:09 AM, Liz  wrote:
>>> 
>>> On Mon, 11 Apr 2022 14:36:41 -0700 (PDT)
>>> Rich Shepard  wrote:
>>> 
>>>> Every now and then one of my bank accounts doesn't reconcile because
>>>> what the bank shows differs from what GnuCash shows. The amounts are
>>>> significant. What puzzles me is that the previous month's balances
>>>> (bank and GC) match and so do all the transactions. But, the end of
>>>> month balances don't match.
>>> 
>>> Rich when I get into a mess, I do very small increments on the
>>> reconcile. For example, just choosing a date about 10 transactions
>>> down, or one week, and then I will go through very slowly, doing small
>>> chunks. 
>>> Assume this is one month, and I am doing weekly...
>>> I find the bank's ending balance for 7th of month, put 7th of correct
>>> month and the balance from the bank statement into the reconcile
>>> dialogue, and check off that week's items from the bank statement. When
>>> the residual is zero, I mark finished, and move forward to the 14th.
>>> (Procedure loops)
>>> 
>>> By looking at such a small number of transactions it is possible to
>>> find whatever the errors are.
>>> I too have been on Gnucash for a couple of decades, but still found 4
>>> errors in one file this March, payments not entered as received, and
>>> digit transposition.
>>> 
>>> I hope you find what is happening and let us know.
>>> 
>>> liz
>>> 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] Reconciliation discrepancies

[R. Victor Klassen]

I run into such issues once in every one or two blue moons.  The starting 
balance is off.
I’ve reconciled successfully the previous month, but something somehow 
(dis)appeared in the meantime.  I assume it disappeared, although the symptoms 
could be generated by something appearing.

I hope it’s more than a year old, and live with it.  Meaning I do a balance 
adjustment and move on.

It’s disturbing, but the size of my file is such that I have no reasonable 
means of tracking down whatever may have happened.

Possible that it’s user error, but unlikely.  Possible that it results from one 
of the periodic crashes I experience, or power failures, that appear to be 
fully recovered from at the time.  Pretty much impossible to reproduce.
If it is due to user error, that would be an argument in favour of the ability 
to mark old transactions as read-only.  Yes I’m very aware that “read-only” can 
be worked around.  But when it’s about protecting one from oneself, that kind 
of read-only could be useful.  If it’s due to bit rot/power glitches/crash 
recovery, not so much.

> On Apr 12, 2022, at 6:09 AM, Liz  wrote:
> 
> On Mon, 11 Apr 2022 14:36:41 -0700 (PDT)
> Rich Shepard  wrote:
> 
>> Every now and then one of my bank accounts doesn't reconcile because
>> what the bank shows differs from what GnuCash shows. The amounts are
>> significant. What puzzles me is that the previous month's balances
>> (bank and GC) match and so do all the transactions. But, the end of
>> month balances don't match.
> 
> Rich when I get into a mess, I do very small increments on the
> reconcile. For example, just choosing a date about 10 transactions
> down, or one week, and then I will go through very slowly, doing small
> chunks. 
> Assume this is one month, and I am doing weekly...
> I find the bank's ending balance for 7th of month, put 7th of correct
> month and the balance from the bank statement into the reconcile
> dialogue, and check off that week's items from the bank statement. When
> the residual is zero, I mark finished, and move forward to the 14th.
> (Procedure loops)
> 
> By looking at such a small number of transactions it is possible to
> find whatever the errors are.
> I too have been on Gnucash for a couple of decades, but still found 4
> errors in one file this March, payments not entered as received, and
> digit transposition.
> 
> I hope you find what is happening and let us know.
> 
> liz
> ___
> 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] Directly posting payments

[R. Victor Klassen]

The telling phrase was “vendor summary “.  I’m afraid if you want to be able 
the track expenses by vendor you need to open an invoice.  The advantage is 
that you can set up the tax to automatically calculated.  The disadvantage- 
well, you seem to encountered that already.  

Sent from my iPhone

> On Feb 21, 2022, at 6:24 PM, j...@paradisepro.com wrote:
> 
> Dear Mr. Carlson:
> 
>> Do you intend to use GnuCash for personal finances or business use?  If for
>> personal use, don't bother with those business features.
> 
> Business. Self-employed, no employees.
> 
> Jim
> 
> --
> 
>>> On Mon, Feb 21, 2022 at 4:10 PM  wrote:
>>> 
>>> I am a newbie on GnuCash, currently running it side-by-side with my
>>> previous software which I can't install on Win10 without a very expensive
>>> upgrade [currently logging into my old Win7 machine using Remote Desktop
>>> but old machine is becoming unreliable].
>>> 
>>> In my old software, I could directly post incidental payments without
>>> first creating an invoice. In GnuCash, it appears I need to create an
>>> invoice prior to posting a payment. For a simple transaction like a store
>>> or restaurant purchase, this seems somewhat cumbersome.
>>> 
>>> I can create the transaction directly in the General Journal; however,
>>> then I don't have a vendor summary.
>>> 
>>> What am I overlooking?
>>> 
>>> Regards,
>>> 
>>> Jim
>>> 
>>> James E. Gochnauer
>>> Independent Claims Adjuster
>>> Licensed/bonded/Xactimate certified
>>> 132 Cleveland St. Flr 1
>>> Brooklyn, NY  11208
>>> CELL & TXT:  646-465-4800
>>> j...@paradisepro.com
>>> 
>>> ___
>>> 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.
>> 
>> David Carlson
>> 
> 
> 
> 
> 
> 
> ___
> 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] Canadian Mortgage

[R. Victor Klassen]

Happily, in Canada, Escrow is not nearly as common a practice as in the US.  So 
that complication likely does not apply.  

But since this thread wandered off into the question of banks making money off 
the rounding (in Australia), there was a case in Canada - back in the 70s or 
80s, as I recall, where a rogue programmer - someone with a job not unlike 
Michael's previous life - figured out how to siphon rounding errors into his 
own account.  I don’t know how much rounding was involved - but it was 
described (by a member of the fraud unit of the police) as taking the rounding 
errors from savings interest and putting it into his account.  I would imagine 
that everything was right to one or two digits beyond the penny, to avoid 
detection, but then the remainder was truncated rather than rounded, and that 
error went in one place.  At the time, US banks were small, as they weren’t yet 
allowed to operate across state lines.  But Canadian banks had no such 
restrictions and were already operating internationally.  So a tiny bit every 
month from each of very many accounts added up.

> On Jan 31, 2022, at 10:00 AM, Michael or Penny Novack 
>  wrote:
> 
> On 1/30/2022 9:40 PM, Al Maloney wrote:
>> Victor
>> 
>> Thanks.
>> What you say about formulae and bank practice makes sense to me.
>> Your advice says to me: "Don't sweat the small stuff".
>> 
>> Al Maloney
>> Velox Versutus Vigilans
> 
> Speaking as somebody who has written software to produce mortgage 
> amortization tables, don't sweat it. It would be close to impossible for you 
> to exactly match what the bank has. The problem is that there are simply too 
> many places where assumptions being made, where rounding, how to treat the 
> odd amount at the end, etc. for example, that an exact match cannot be 
> expected. I actually did have a program that could produce  a table to match 
> (given the payment according to the bank) but that used automated "trial and 
> error" adjustment until it did match as opposed to a calculation.
> 
> If  you get a "statement" for each payment from the lender indicated how the 
> payment broken down between principle, interest, and escrow (taxes, 
> insurance, etc.) you can do it in a two step process. Create an extra account 
> under expenses with a useful name like "mortgage payment" (meaning not yet 
> allocated) and have your scheduled transaction use this for the debit. Then 
> when you have the statement you can transfer (credit this) splitting the 
> debits between "mortgage interest" (an expense), "mortgage balance" (a 
> liability), and "mortgage escrow" (an asset) --- later when you get notified 
> that th escrow account has been used to make a tax payment, an insurance 
> payment, etc. you can enter those against the escrow account.
> 
> BTW -- it is really tricky (and so the amount the bank is collecting) to do 
> the escrow calculation because this usually isn't an amount that will collect 
> enough over the year to equal those expenses but an amount that also will 
> keep the escrow account positive at all times (in other words, a "cash flow" 
> calculation). That's why the amount will jump around year to year even if 
> your taxes and insurance amounts remain relatively constant.
> 
> Michael D Novack
> 
> 
> ___
> 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] Adding late charges to a vendor bill after posting?

[R. Victor Klassen]

Not what the Canadian (Federal) taxing authorities do with payroll taxes.  They 
have a separate account for arrears, and interest goes there as well.  As far 
as I can tell, this is just to baffle the poor taxpayer, so if you ever get in 
arrears, you have to be sure to tell them the next payment is to go there, and 
not to your regular payroll account…

Gag me with a spoon.


To the OP’s question, I agree, although you might not have a 
Liabilities:Property Tax account, in which case it would be 
Liabilities:Accounts Payable.

> On Jan 30, 2022, at 11:17 AM, Stan Brown  wrote:
> 
> Why not do what the taxing authority almost certainly does? As soon as
> you incur that late fee, do a transaction
> Debit:  Expenses:Late Fees
> Credit: Liabilities:Property Tax

___
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] Canadian Mortgage

[R. Victor Klassen]

My experience is that if I do interest compounded semi-annually, and the right 
payment frequency, the interest/principal breakdown still doesn’t match the 
bank’s, because they say compounded semi-annually on the mortgage documents, 
but then they calculate what the equivalent is and calculate it with every 
payment.  Mine has always been monthly, and months have varying lengths, so 
your mileage may be better, where you are paying every 14 days.

> On Jan 30, 2022, at 3:08 PM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Sun, January 30, 2022 2:13 pm, Al Maloney wrote:
>> How can I use gnuCash for a Canadian mortgage?
>> 
>> I need:
>> 1) frequency of payments as bi-weekly (not semi-monthly)
> 
> On the Loan Repayment page, select:
> Frequency: Weekly
> Every 2 weeks
> 
>> 2) a compounding period of 6 months
> 
> If you know what the (libre)office PMT() invocation would be, then you can
> program GnuCash similarly because the pmt functions behave the same way.
> I can't tell you off hand how to do it, though.  You might be better off
> just supplying the "Interest Rate", but you're right, there is no "APR
> Compounded every 6 months" setting.  Please file an RFE in Bugzilla to get
> that added.
> 
>> These are not available in version 4.9-1 Actions->Scheduled
>> Transactions->Mortgage & Loan Repayment
>> 
>> I am using macOS 10.14.6 or macOS 12.2
> 
> Good Luck,
> 
>> Al Maloney
>> Velox Versutus Vigilans
> 
>> 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 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> ___
> 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] Lodging a cheque to an a/c - 'cash in wallet'??

[R. Victor Klassen]

I generally use a two step process.  

First the cheque goes into “undeposited cheques”.   And the appropriate income 
account is credited.  Then when I make a deposit I may be depositing cash and 
multiply cheques in a single transaction with the bank account as destination.  

Sent from my iPhone

> On Jan 17, 2022, at 12:10 PM, Derek Atkins  wrote:
> 
> Hi,
> 
>> On Mon, January 17, 2022 10:51 am, Mahon Finbar wrote:
>> Hi,
>> 
>> My wife got a cheque (or check if you insist) and lodged it in her bank
>> account.
>> 
>> I want to enter it as a deposit to her a/c. It only seems to accept
>> Assets:Current Assets:Cash in Wallet as a transfer entry without
>> entering two transactions - deposit and withdrawal
>> 
>> Since the amount will be credited to the a/c "cash in wallet" somehow
>> doesn't seem right?
>> 
>> Is there a 'proper' way to enter a cheque lodgement?
> 
> Just like any other deposit   You debit your checking/bank account for
> the amount of the check, and then credit the amount from wherever the
> funds are coming from, like Income:Salary, Income:Gifts Received, etc.
> 
> Why did she get a check?  What was it paying for?  That will help you
> decide where the credit the funds.
> 
>> Finbar
> 
>> 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 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> ___
> 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] Question on Parent Accounts

[R. Victor Klassen]

1) Create the new account: presumably Expenses:Cost of Goods Sold 
2) Optionally (recommended for parent accounts) make it a placeholder account
3) Edit any accounts that are to become children of this one.  When you create 
or edit an account, there’s an option near the bottom of the pop-up to specify 
the parent account.
4) Optionally create any further children accounts, specifying this one as 
parent.

> On Jan 14, 2022, at 5:37 PM, Brad Weibel  wrote:
> 
> Need to have a new parent account (Cost of Goods Sold) … not able to 
> determine how to go about setting  up a new parent account
> 
> Sent from Mail for Windows
> 
> ___
> 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] Modify Invoice Template

[R. Victor Klassen]

And once you get one you like,  save it.  And then, find the default template 
on your file system and put your saved one there.

> On Jan 6, 2022, at 10:17 AM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Thu, January 6, 2022 10:01 am, Don Gray wrote:
>> My invoices print with
>> 
>> Thank you for your patronage.
>> 
>> Where can I find how to remove this, or at least change the wording?
> 
> In the Report Options.
> 
>> Running on MacOS 12.1 if it makes a difference.
>> 
>> Sincerely,
>> 
>> Don Gray - Exploring Human Systems in Action
>> +1 (336) 414-4645
> 
>> 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 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 
> ___
> 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] Cash Basis Accounting

[R. Victor Klassen]

The only problem being if you want to send the invoice to your customer, it 
says “invoice in progress”.

So I do find myself posting, printing, unposting (only around the end of the 
year) and re-posting as necessary.

> On Jan 6, 2022, at 9:50 AM, Don Gray  wrote:
> 
> Rich and Victor,
> 
>> What I do, on the advice of my previous accountant who's now retired, is not 
>> to enter an A/P or A/R invoice until payment is made or received, 
>> respectively. That way what you see is what you have. 
> Simple solution - I unposted the invoices which removed them from the 
> Profit/Loss statement.
> 
> In the future I'll not post invoices until I receive payment.
> 
> Thank you!
> 
> 
> Don Gray
> Exploring Human Systems in Action
> +1(336)414-4645
> 
> Tomorrow belongs to those who can hear it coming. - David Bowie 
> ___
> 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.

[GNC] Commission sales and business features

[R. Victor Klassen]

We occasionally sell something through a third party acting in a broker role.  
Which is to say the item is never the possession of the party who does the sale 
- or at least not owned by them.  

When I do the invoice I do not know the actual customer so I create a pseudo 
customer as a stand-in.  I put in line items for everything sold and then I 
would like to have a item for commission which reduces the total amount owed. 

Adding to the complexity is that commission is taxable,  while none of the 
other line items is. 

Here’s the question:   The commission should be booked against cost of sales 
which is an expense.  Invoices don’t permit expenses, just assets, income and 
liabilities.  

How do folks normally treat this?

Sent from my iPhone
___
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] Cash Basis Accounting

[R. Victor Klassen]

I normally re-post invoices to the 1st of the year if not paid before, and any 
bills that are due and paid after the year end I also post to the 1st.  
Rarely do I find something that needs to be moved the other direction (although 
it is possible, I just can’t think of an instance off hand).

The date opened and the dates on the entries of the invoices/bills can still 
remain attached to reality, only the posting dates need to be fiddled with.

The method in the wiki works if you are really good at keeping A/P and A/R 
correct and up to date.  i.e. never receive payment without assigning it to an 
invoice
or properly categorizing the split, and never pay a bill without linking the 
payment to the bill.  In an ideal world that works all the time. Just not in my 
experience.

> On Jan 4, 2022, at 5:23 PM, Don Gray  wrote:
> 
> For 2021 year end account I need to generate a profit/loss report. No problem 
> as a standard report exists.
> 
> The problem stems from the report being off by several thousand dollars as 
> I’ve posted invoices but not received the payments.
> 
> Searching the internet I found 
> https://wiki.gnucash.org/wiki/Cash_Based_Accounting 
> . Is this still the 
> current way of handling Cash basis accounting?
> 
> Don
> ___
> 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] MEMORIZING PAYEE ADDRESS

[R. Victor Klassen]

[forgot to copy the list the last time].

So when I pay from the account I sometimes find it works, and don’t know why 
only sometimes.   In the process payment dialogue attached to the bill there is 
a checkbox near the bottom left, not far from where you fill in the number, 
that says “print check” - if I recall correctly.  When I use that procedure I 
am now reliably getting addresses printed.  I know this hasn’t worked this way 
for all previous versions, but I’m not sure when it started working.  

> On Jan 1, 2022, at 12:44 PM, Adrien Monteleone 
>  wrote:
> 
> Indeed, my file meets both conditions.
> 
> Regards,
> Adrien
> 
> On 1/1/22 7:03 AM, R. Victor Klassen wrote:
>> I’m fairly certain you also have to be using the business features and have 
>> the payee listed as a vendor.
>>> On Dec 28, 2021, at 5:32 PM, Adrien Monteleone 
>>>  wrote:
>>> 
>>> What is your process?
>>> 
>>> I first select the transaction, then go to File > Print Checks, and 
>>> everything is filled out for me.
>>> 
>>> Also, what OS/version are you using?
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> On 11/10/21 12:22 PM, men...@fastmail.fm wrote:
>>>> Hi
>>>> I print checks occassionally using GnuCash.  I find that the program 
>>>> doesn't remember the addresses of regular payees.  Each time I go to print 
>>>> a check, I need to re-enter the address for the payee, even though I've 
>>>> paid them before.  Is there a step I'm missing?
> 
> ___
> 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] MEMORIZING PAYEE ADDRESS

[R. Victor Klassen]

I’m fairly certain you also have to be using the business features and have the 
payee listed as a vendor.

> On Dec 28, 2021, at 5:32 PM, Adrien Monteleone 
>  wrote:
> 
> What is your process?
> 
> I first select the transaction, then go to File > Print Checks, and 
> everything is filled out for me.
> 
> Also, what OS/version are you using?
> 
> Regards,
> Adrien
> 
> On 11/10/21 12:22 PM, men...@fastmail.fm wrote:
>> Hi
>> I print checks occassionally using GnuCash.  I find that the program doesn't 
>> remember the addresses of regular payees.  Each time I go to print a check, 
>> I need to re-enter the address for the payee, even though I've paid them 
>> before.  Is there a step I'm missing?
> 
> ___
> 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] (no subject)

[R. Victor Klassen]

What most people have found - and someone would be sure to say eventually - is 
that to get reports formulated exactly as you want them, you pretty much need 
to export them to a spreadsheet or even a word processor table, and manipulate 
them from there.   GnuCash will handle the numbers, and even give you a number 
of reports, but it won’t give you all the options you need/want regarding 
formatting.

Regarding the inventory in/out if you have inventory as an asset, then running 
a balance sheet at the start and end of the year will give you the two numbers 
you want.  Not all in one report matching Form T2125, but you need to fill that 
out by hand in the end anyhow.  

There’s a certain amount if creative accounting required for inventory anyhow, 
since you can take raw materials at the price you paid for them and finished 
goods at the price you expect to sell them for, but goods in process is not so 
cut and dried.  If none of your end of year inventory remains by the time you 
file a few months later, you will have real values for everything, but in the 
more likely case, you don’t know how much of that inventory really is worth its 
original value.   I expect GnuCash for things that can really be measured - 
cash, funds in the bank - and treat inventory as something for spreadsheets.  
It’s not that you can’t  do what you’re setting out to do, it’s that GnuCash 
isn’t designed to do full inventory management for you, and if that’s what you 
need, you should find something that is.  If it isn’t what you need, it’s a 
once a year thing to satisfy the CRA, and not worth the detailed tracking that 
following inventory through every transaction would give you.   But that’s a 
choice.

 

> On Dec 19, 2021, at 1:05 PM, Jesse MacDougall  
> wrote:
> 
> Thanks for the reply Mike.  After reading your message I realize I should
> have shown what I am building this set of Financial Statements(FS) from.
> I am making this set of FS congruent to Canada Revenue Agency's GIFI codes
> for self employment tax payers.
> 
> The .pdf shows the estic I am trying to achieve.
> Does that make sense?
> 
> 
> On Sun, Dec 19, 2021 at 7:53 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> 
>> On 12/19/2021 2:11 AM, Jesse MacDougall wrote:
>>> I am trying to add a "label"(not sure if that is the right word) on
>> Income
>>> Statement "Cost of Goods Sold" and put accounts under COGS.  Like there
>> is
>>> with "Total Revenue".  What is happening is COGS is a parent account with
>>> sub accounts but I want to make COGS a label.
>>>   I am trying to achieve a bolded "COGS" on the IS.  I don't see
>> anywhere
>>> to achieve this.  Been stuck on this a few hours.  I have COGS as a
>>> placeholder currently.  Here is what I see:
>> 
>> You really need to start with a "fundamentals of bookkeeping, an
>> "accounting 101" sort of text.
>> 
>> a) You seem to have some sort of "business" embedded in a set of
>> personal books. I can understand WHY you might want to do that (they
>> share a bank account)
>> 
>> b) I have no idea what your (tax) reporting requirements might be and
>> how that affects "a real business" vs a very much side operation liable
>> to be classed as a "hobby" << important for over here as while both
>> businesses and hobbies pay tax on profits, only businesses can deduct
>> losses from other income >>
>> 
>> c) Inventory should be under assets, expensed as used, not as bought.
>> 
>> d) Because a CoA can have only one structure (one tree hierarchy) when
>> you choose to embed the business books into your personal books you will
>> NOT be able to produce a simple "Statement of Revenues and Expenses".
>> Same with the "Balance Sheet". In other words, you will probably want to
>> run multiple using account selection to disentangle accounts.
>> 
>> Michael D Novack
>> 
>> 
>> ___
>> 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.
>> 
> 
> 
> -- 
> * Please consider adding jesse@macdougall.ninja to your address book.  This
> will be my new address.  This gmail address is being retired.
> ___
> 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 mail

Re: [GNC] Beginner Accounting Question Using GnuCash

[R. Victor Klassen]

There are two kinds of expenses - current expenses and capital expenses 
(specific terms may vary).  Capital expenses convert one asset (usually money) 
to another.  Current expenses just deplete an asset (or increase a liability).  
In the case where you are converting money to inventory of materials from which 
to make something, and you are treating that inventory as an asset, you don’t 
actually get to see the expense.  The real expense occurs when you deplete the 
assets by making the first notebook.  In the meantime you still have all the 
paper.  Unless the paper drops in value, which would be depreciation or - if it 
dropped because of fire or water damage, a different sort of expense, the name 
of which likely depends on where you are.  

One report that would allow you to see the money move is the cash flow report, 
which isn’t exactly as its name implies.  For that report you select a subset 
of your accounts and it tells you what moves in and out of the subset, ignoring 
anything that happens within it.  So long as your paper inventory is on one 
side and the money spent comes from the other, it will show up.



> On Dec 17, 2021, at 6:48 AM, Patrick Skelton  wrote:
> 
> Hi, David,
> 
> Thank you for that. I have actually just kind-of worked that bit out but I
> would like the £8 spent on paper to become an asset. Is it simply then a
> case of entering a transfer from Expenses-Stock Purchases to Assets - Stock
> on Hand?
> 
> Kind wishes - Patrick
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Fri, 17 Dec 2021 at 11:40, David H  wrote:
> 
>> Patrick,
>> 
>> Look carefully at point 2, one side of your transaction should be an
>> expense as you are expending funds to buy stock eg Expense >> Stock
>> Purchases rather than Stock on Hand ?
>> 
>> Cheers David H
>> 
>> 
>> 
>> On Fri, 17 Dec 2021 at 21:20, Patrick Skelton 
>> wrote:
>> 
>>> Hi,
>>> 
>>> I am trying to get my head around double-entry accounting. I think I have
>>> kind-of got it. I have just set up a stripped down set of accounts and
>>> tried a handful of transactions, to see how they affect profit-and-loss
>>> and
>>> the balance sheet. It all seems to make sense except that there is one
>>> piece of information that seems to vanish, and I am worried this means I
>>> am
>>> doing something wrong.
>>> 
>>> My transactions beginning with all zero balances are:
>>> 
>>> (N*ote:* I have added some dates to give context to my later question)
>>> 
>>>   1. 1st Nov: I pay £100 into the business *Bank* financed by *Owner's
>>>   Equity*.
>>>   2. 2nd Nov: I buy some paper costing £12, which comes from *Bank* and
>>>   goes into *Stock on Hand*.
>>>   3. 3rd Dec: I sell a notepad for £12, which credits *Bank* and is
>>>   assigned to *Income - Sales*.
>>>   4. 4th Dec: I transfer the cost of the paper used to make the notepad
>>>   (£1.00) from *Stock on Hand* to *Expenses - Cost of Materials*.
>>> 
>>> The Balance Sheet shows £111. Liabilities are zero. Retained Earnings are
>>> £11, which gives total equity of £111. Thus the sheet is balanced.
>>> 
>>> My question is that no matter what report I run using whatever dates, I
>>> cannot see the £12 I spent on stock. All I ever see is the £1 that I
>>> decided was the cost of the paper taken from stock.
>>> 
>>> Even if I do reports only for the month of November, I don't see the £12 I
>>> paid for stock because the money came from my bank and went into stock,
>>> which are both Asset accounts.
>>> 
>>> Is there a better way to do these transactions so that I could ask the
>>> question: how much have I spent on stock this month?
>>> 
>>> I am a complete newbie so would welcome any help or advice (short of 'get
>>> an accountant', which I would love to but can't afford).
>>> 
>>> Kind wishes - Patrick
>>> ___
>>> 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

Re: [GNC] Can I add a customer and/or vendor to a previously entered transaction?

[R. Victor Klassen]

Normally the first transaction you would enter would be the payment, and then 
the refund later.

Assuming you have a payment to associate, first create a “bill”.  This is 
GnuCash-speak for an invoice received from a vendor.
Put in it what you need, then “Post” it.   

Now you can go to the account from which you paid the vendor and click on the 
transaction.  With the transaction selected go to Edit->Assign as Payment and 
you will have a pop-up to fill in.
That will include a place to type the vendor’s name.  Once everything is good 
with that window and you accept it, the transaction will be assigned.

For the refund, you do much the same thing, except when you open the “bill” you 
select “Credit Note” - near the top.  

> On Dec 12, 2021, at 10:06 AM, Dr. David Kirkby 
>  wrote:
> 
> I have entered a couple of transactions into GnuCash, and entered some
> vendors and customers. However, the transactions are not associated with
> any vendors, and I'm unsure how to do that, if it is possible - see
> screenshot
> ___
> 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] how to handle temporary desk checks

[R. Victor Klassen]

This is not really a GnuCash problem - as far as the program is concerned, you 
can have as many instances of  as you like.  So it depends on how you use 
the number.  If you write a, b, c etc beside the number when they get used, and 
you either get them or their images returned, you can match them up when you 
reconcile.  If you rely on the bank to report the number either online or on a 
statement, it will use whatever is in the MICR, and you can’t change that.  But 
as far as the software is concerned, it doesn’t matter.

> On Dec 2, 2021, at 4:34 AM, Jeff  wrote:
> 
> I never encountered this in any of my accounting practice before.  My wife's 
> personal business ran out of checks, so until the new ones arrived all of the 
> banks desk checks are numbered .  Check number  already exists as a 
> valid check number some years ago.
> 
> Should all of the temporary numbered check numbers be entered as  or 
> a, b, etc in GNC?
> 
> -- 
> --JEffrey Black M.B.A.
> 
> ___
> 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] Processing a customer payment

[R. Victor Klassen]

Assuming you have created the invoices using the “Business Features”, you go to 
Business->Customer->Process Payment, select the customer, and select both 
invoices.

If they paid by a means that has a transaction number (check, credit card 
transaction…) put that in the number field.

Select your checking account for where it goes, and you will have one 
transaction, with a split with three parts: one for the destination account, 
and two for Accounts Receivable.

> On Oct 23, 2021, at 1:25 PM, davidvernonl...@gmail.com wrote:
> 
> Hi, if a customer makes one payment to cover say two invoices, how do I
> process that in accounts receivable without having two cash receipts showing
> up on my checking account in GNUCASH whereas there should only be one? I can
> imagine various clumsy manual  ways of doing it, but am thinking there must
> be a business process method I have not seen.  
> 
> 
> 
> Thanks
> 
> 
> 
> David Long
> 
> ___
> 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] Count Transactions

[R. Victor Klassen]

Someone may have a better way, but I would use the view->filter menu item to 
restrict it by date, then do an account report and copy it to a spreadsheet and 
count them there using the count function on one of the columns. 

Sent from my iPhone

> On Oct 16, 2021, at 6:53 PM, Joseph Hesse  wrote:
> 
> Hello,
> How do I count the total number of transactions in an account from a start to 
> end date of my choosing?
> Thank you,
> Joe
> 
> 
> ___
> 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] Credit Card Rewards Refund

[R. Victor Klassen]

The OLD day?  We still have a couple of vendors like that.  Happily for us 
accrual accounting is their problem.  

Sent from my iPhone

> On Oct 15, 2021, at 12:17 PM, Michael or Penny Novack 
>  wrote:
> 
> Perhaps historical perspective might help, especially with businesses, 
> because might want to treat the same way as when invoices typically were like 
> this, except conditional on when paid.
> 
> I have no idea how accrual treats this (would have treated this) when in the 
> old days a vendor might send an invoice like this:
> 
> Immediate, 2% discount, 30 days net, else 1% per month.
> 
> I am old enough to remember those days. Assuming the accrual system treated 
> the "30 days net" as normal, what was done if paid immediately? That closely 
> resembles the situation of credit card rebates on purchases. As to the 
> argument wanting to  distribute to reduce all expenses  paid during that 
> billing period, is that also being done in reverse with interest charges (if 
> any -- often a business credit card is not intended as a source of credit and 
> balance paid each month -- and SOME people ca manage that with their personal 
> credit cards too)
> 
> 
> Michael D Novack
> 
> 
> ___
> 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.

[GNC] Search/report by description

[R. Victor Klassen]

I’m looking for a report or means of searching all bills/invoices for a 
specific pattern in the description field of any line.  I would further like to 
restrict it (optionally) by date range or customer/vendor.  

For example I might want to know what we paid for whatsits last year and from 
whom all we bought them.  They might be a small subset of what went in the 
account and they might have wound up in multiple accounts depending on their 
intended end use.  

Similarly I might want to know what we charged for dinguses. And there might 
have been some that were accounted as greenhouse dinguses, while others were 
grown in the field, but just now I want to know what we charged customer x for 
them. 

I’m willing to use piecash if necessary but not write scheme.  

Sent from my iPhone
___
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] Check printing

[R. Victor Klassen]

Got me. The only potential difference is the version and OS.  Don’t know 
whether anyone else has had a similar experience...

Sent from my iPhone

> On Jun 15, 2021, at 9:35 AM, Bruce Irving  wrote:
> 
> 
> Hi, Victor.
> I use the same format as you.
> 
> I still can't understand why I create 8 transactions in the Checking account, 
> everything is the same except the number and payee.  Only one of those checks 
> would print.  For the rest of them, it goes through the procedure on screen 
> but when I click the final print, it does not go to the printer!  I have to 
> hand write those 7 checks.
> Bruce
> 
>> On Mon, Jun 14, 2021 at 4:51 AM R. Victor Klassen  
>> wrote:
>> I have no experience with the three-part cheques, as the ones I use consume 
>> a full page (one third for the cheque, one third for each of the stubs).
>> 
>> When I do what you describe - except for the format - it works fine.   So 
>> someone else will have to chime in here.
>> 
>> > On Jun 10, 2021, at 12:55 PM, R. Victor Klassen  
>> > wrote:
>> > 
>> > What I would do under your circumstances is fill out all the details in 
>> > the register for the first one,  duplicate transaction and edit the payee 
>> > and number fields, and so on until I had them all in the register.  Then 
>> > command-p on the Mac for each of them.  It might be control-p on your 
>> > platform I don’t know.  Does that not work?
>> > 
>> > Sent from my iPhone
>> > 
>> >> On Jun 10, 2021, at 12:46 PM, Bruce Irving  wrote:
>> >> 
>> >> I am using preprinted check stock that has the MICR already on it.  I 
>> >> don.t
>> >> need to use MICR printing
>> >> Bruce
>> >> 
>> >>> On Thu, Jun 10, 2021 at 10:39 AM David Carlson 
>> >>> 
>> >>> wrote:
>> >>> 
>> >>> A few days ago the MICR printer cartridge that I used to use popped up 
>> >>> out
>> >>> of some black hole so I may try printing checks again.   As I recall, tho
>> >>> it used to be reasonably easy to print test checks on plain paper first,
>> >>> then just be sure the desired transactions had the word print in the Num
>> >>> field.  Oh, there was a trick to matching up check numbers which now 
>> >>> slips
>> >>> my mind.
>> >>> 
>> >>> I suppose that is the issue Bruce is wrestling with.
>> >>> 
>> >>> 
>> >>> 
>> >>>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving  
>> >>>> wrote:
>> >>>> 
>> >>>> I'm getting to the point that I can rarely read my own handwriting.  So 
>> >>>> I
>> >>>> started playing with printing checks from GC bank reisters.
>> >>>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC 
>> >>>> Version
>> >>>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>> >>>> It works - sometimes.  If I "print" a check, and the printer 
>> >>>> mis-behaves,
>> >>>> I
>> >>>> can't reprint it!  The other day, I needed to write eight checks to
>> >>>> different parties, other than the payee, the checks were the same, I 
>> >>>> could
>> >>>> only print one of them!  I had to hand write the others.
>> >>>> Is there any way that I can get a check to reprint?  Or, to print 
>> >>>> multiple
>> >>>> nearly identical checks?
>> >>>> Bruce
>> >>>> ___
>> >>>> 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] Check printing

[R. Victor Klassen]

That would depend upon the number you’re doing in a given period. 

I have payroll output to QIF which when imported gives me the stub I need.  And 
it fits the window envelope just fine.  

I would hate to have to edit each and every cheque. 

Sent from my iPhone

> On Jun 14, 2021, at 10:49 AM, Michael or Penny Novack 
>  wrote:
> 
> On 6/14/2021 6:51 AM, R. Victor Klassen wrote:
>> I have no experience with the three-part cheques, as the ones I use consume 
>> a full page (one third for the cheque, one third for each of the stubs).
>> 
>> When I do what you describe - except for the format - it works fine.   So 
>> someone else will have to chime in here.
>> 
> This is a matter where because of personal professional experience, I would 
> strongly suggest that checks not be printed directly from gnucash. In other 
> words, "print" to file which then could be processed by an editor before 
> being sent to a printer.
> 
> Why?
> 
> There is potentially some "fine tuning" required in the exact formatting. I 
> am thinking of the general case, say printing payroll checks which may be 
> required to come attached to a "stub" << statement for the employee showing 
> all deductions, etc. >> and if to be mailed, when folded, the address must 
> show properly in the envelope window.
> 
> It is MUCH easier to deal with issues like "the new envelopes have the window 
> in a slightly different position" by fixing in that in between editing 
> program. Much easier than trying to make the change in the application 
> writing the checks or madly dashing around trying to find a supplier of 
> envelopes with the window in the old position. This is one of the things I 
> used to have to deal with, an emergency call from the department doing the 
> printing, folding, envelope stuffing that all of a sudden the address out of 
> window.
> 
> Note that IF doing this (having that intermediate editor step) you can also 
> relieve gnucash of all details like font size, font used, logos, etc. and 
> instead do all the formatting/pretty printing with a full power editor.
> 
> Michael D Novack
> 
> 
> ___
> 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 very slow to start up and quit

[R. Victor Klassen]

When I had speed problems it was much more extreme.  I had been using SQLite.  
I switched to XML, and then switched back, and the effect of saving it in a 
different format, and reading it back was enough to make a dramatic 
improvement.  There was something in the data file that made it slow, and that 
was cleaned up by the change of format.

> On Jun 13, 2021, at 6:45 AM, David Carlson  
> wrote:
> 
> Speed depends on not only the factors that you have identified, but other
> factors as well.  I have an instance of release 3.8 running in a Linux Lite
> environment within a  Virtualbox on a laptop.  Of course this hardware has
> its limits too.
> 
> I happen to normally store my compressed XML datafile on a Network Attached
> Storage device connected via Ethernet in (probably unencrypted) SMB
> protocol, which I thought was a speedy connection.  However, I recently set
> up an alternate arrangement on a locally attached USB 3.0 memory stick and
> found that file saves in particular sped up from around 30 seconds to
> around 2 or 3 seconds.  This is anecdotal information as I currently am not
> in a position to perform a controlled experiment.  I suspect that there
> must be a kink in the Ethernet possibly limiting it to 1 MHz or 10 MHZ.
> instead of the 100 MHz I expect on my rather dated network.  I do know that
> the network saves take roughly the same amount of time when Wi-Fi is used
> as the transmission medium, but there is still one ethernet cable between
> the router and the NAS.  That connection could be 1 Gigahertz if the cable
> is good enough.  I will be checking that when I get a chance in a week or
> two.
> 
> On Sun, Jun 13, 2021 at 5:11 AM Tim Hume  wrote:
> 
>> On Sunday, June 13th, 2021 at 18:28, Saša Janiška 
>> wrote:
>> 
>>> Just wonder how does SQLite back-end compare with XML and whether you
>>> recommend one over the other? (my XML is 20MB uncompressed and under
>>> VCS).
>> 
>> I just ran a test. My data file is 37 MByte in SQLite format, and 52 MByte
>> when in XML and uncompressed. However, the compressed XML is under 4 MByte.
>> 
>> It took 1m 17s to open GnuCash with the compressed XML file, and 55s with
>> the SQLite file. I'd recommend the SQLite format based on these tests.
>> 
>> My CPU is currently an i5 6300U. I was looking at a small PC with a Ryzen
>> 7 4700U CPU. Given GnuCash runs on a single thread, I suspect speedup in
>> loading the data will be about 1.5 times given it seems to be CPU bound.
>> I'm not sure if I'm going to upgrade. The advantage of my current setup is
>> that it's on a laptop, so if the power goes out (which it does frequently
>> enough) I don't lose everything. Mind you, I wouldn't mind the extra speed.
>> Once GnuCash is loaded, it's fast enough to do the tasks I want it to do,
>> so I normally just keep it open.
>> 
>> Cheers,
>> 
>> Tim
>> ___
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> ___
> 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] Check printing

[R. Victor Klassen]

I have no experience with the three-part cheques, as the ones I use consume a 
full page (one third for the cheque, one third for each of the stubs).

When I do what you describe - except for the format - it works fine.   So 
someone else will have to chime in here.

> On Jun 10, 2021, at 12:55 PM, R. Victor Klassen  wrote:
> 
> What I would do under your circumstances is fill out all the details in the 
> register for the first one,  duplicate transaction and edit the payee and 
> number fields, and so on until I had them all in the register.  Then 
> command-p on the Mac for each of them.  It might be control-p on your 
> platform I don’t know.  Does that not work?
> 
> Sent from my iPhone
> 
>> On Jun 10, 2021, at 12:46 PM, Bruce Irving  wrote:
>> 
>> I am using preprinted check stock that has the MICR already on it.  I don.t
>> need to use MICR printing
>> Bruce
>> 
>>> On Thu, Jun 10, 2021 at 10:39 AM David Carlson 
>>> wrote:
>>> 
>>> A few days ago the MICR printer cartridge that I used to use popped up out
>>> of some black hole so I may try printing checks again.   As I recall, tho
>>> it used to be reasonably easy to print test checks on plain paper first,
>>> then just be sure the desired transactions had the word print in the Num
>>> field.  Oh, there was a trick to matching up check numbers which now slips
>>> my mind.
>>> 
>>> I suppose that is the issue Bruce is wrestling with.
>>> 
>>> 
>>> 
>>>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving  wrote:
>>>> 
>>>> I'm getting to the point that I can rarely read my own handwriting.  So I
>>>> started playing with printing checks from GC bank reisters.
>>>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version
>>>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>>>> It works - sometimes.  If I "print" a check, and the printer mis-behaves,
>>>> I
>>>> can't reprint it!  The other day, I needed to write eight checks to
>>>> different parties, other than the payee, the checks were the same, I could
>>>> only print one of them!  I had to hand write the others.
>>>> Is there any way that I can get a check to reprint?  Or, to print multiple
>>>> nearly identical checks?
>>>> Bruce
>>>> ___
>>>> 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] Check printing

[R. Victor Klassen]

What I would do under your circumstances is fill out all the details in the 
register for the first one,  duplicate transaction and edit the payee and 
number fields, and so on until I had them all in the register.  Then command-p 
on the Mac for each of them.  It might be control-p on your platform I don’t 
know.  Does that not work?

Sent from my iPhone

> On Jun 10, 2021, at 12:46 PM, Bruce Irving  wrote:
> 
> I am using preprinted check stock that has the MICR already on it.  I don.t
> need to use MICR printing
> Bruce
> 
>> On Thu, Jun 10, 2021 at 10:39 AM David Carlson 
>> wrote:
>> 
>> A few days ago the MICR printer cartridge that I used to use popped up out
>> of some black hole so I may try printing checks again.   As I recall, tho
>> it used to be reasonably easy to print test checks on plain paper first,
>> then just be sure the desired transactions had the word print in the Num
>> field.  Oh, there was a trick to matching up check numbers which now slips
>> my mind.
>> 
>> I suppose that is the issue Bruce is wrestling with.
>> 
>> 
>> 
>>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving  wrote:
>>> 
>>> I'm getting to the point that I can rarely read my own handwriting.  So I
>>> started playing with printing checks from GC bank reisters.
>>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version
>>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>>> It works - sometimes.  If I "print" a check, and the printer mis-behaves,
>>> I
>>> can't reprint it!  The other day, I needed to write eight checks to
>>> different parties, other than the payee, the checks were the same, I could
>>> only print one of them!  I had to hand write the others.
>>> Is there any way that I can get a check to reprint?  Or, to print multiple
>>> nearly identical checks?
>>> Bruce
>>> ___
>>> 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] Question about Profit-Loss Report

[R. Victor Klassen]

In our jurisdiction farms are permitted to choose whether to use cash or 
accrual, and there are various tax advantages to using cash-based.

Happily, December/January is the time of lightest business, so the difference 
isn’t huge when it comes to accounting.

I do find I need to unpost and re-post invoices (dated Dec 31) when they are 
issued but not paid; and similarly bills that are issued but not due (or paid) 
until after the year end I post with a January 1 date.

If and when I’m audited by the taxing authorities I explain what I’ve done and 
they’re good with it.

> On May 31, 2021, at 9:08 PM, Alan Hopkins  wrote:
> 
>   Hello Howard
>   I agree with both Michaels - you need to understand the difference
>   between accounting records & reports prepared on an accruals basis vs a
>   cash basis. You should do some reading on basic accounting.
>   GNUCash used for business uses the accrual basis - (invoices are
>   registered in accounts receivable, bills are registered in accounts
>   payable).  Depending on the number of invoices & bills involved, you
>   may find that you need to develop your own cash report on a
>   spreadsheet.
>   Some of these links may  be of help to you:
>   [1]https://www.accountingtools.com/articles/how-to-convert-accrual-basi 
> 
>   s-to-cash-basis-accounting.html
>   [2]https://www.bookstime.com/articles/accrual-to-cash-conversion 
> 
>   [3]https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual- 
> 
>   to-cash-conversion-excel-worksheet/
>   GNUCash is excellent software (a big thank you to the developers!) and
>   you can get more understanding of basic accounting and using the
>   business features by referring to the Tutorial & Concepts guide:
>   [4]https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide 
> 
>   I hope that is of some help to you
>   Cheers
>   Alan
> 
>   On 1/6/21 12:42 am, Michael Hendry wrote:
> 
> On 31 May 2021, at 15:10, Howard M. Fried [5] > wrote:
> 
> I have several invoices that were issued in 2020 but paid in 2021. These 
> funds a
> re not included in a P&L report for 2021, apparently because the report is 
> based
> on date of invoice issue, or have I missed something.
> 
> Is it possible to get the 2020 Sales that were paid in 2021 into the report 
> for
> 2021?  Simply extending the Report date range backward is not a solution 
> because
> many invoices that were issued and paid in 2020 will be included.  Or am I to 
> i
> nclude unrealized assets for 2020 as profit, like the P&L report does (I have 
> no
> accounting, financial, or legal experience in such matters).
> 
> Thank you for considering,
> Howard Fried
> 
> Not an accountant either, Howard, but I believe the approach varies according 
> to
> whether your books are kept on a cash or an accrual basis.
> 
> If cash, then reports are based on the date when you received income, or the 
> dat
> e you made a payment for expenses.
> 
> I don’t use the business features, but I think that you will be working on an 
> ac
> crual basis, and have reports on Accounts Receivable and Accounts Payable 
> which
> carry over the end of the financial year.
> 
> Michael
> 
> 
> ___
> gnucash-user mailing list
> [6]gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> [7]https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> [8]https://wiki.gnucash.org/wiki/Ma 
> iling_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.
> 
> References
> 
>   1. 
> https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html
>  
> 
>   2. https://www.bookstime.com/articles/accrual-to-cash-conversion 
> 
>   3. 
> https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/
>  
> 
>   4. https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide 
> 
>   5. mailto:cursor...@gmail.com 
>   6. mailto:gnucash-user@gnucash.org 
>   7. https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 

Re: [GNC] Cut & Paste transaction problem

[R. Victor Klassen]

When that happens I just change the account in the offending register and when 
I hit enter, hey presto! the transaction disappears from that register.

….And appears in the one where it should.

> On May 4, 2021, at 6:39 AM, Robert Stocker  wrote:
> 
> Yes, I'm sorry I didn't make that clear in my follow-up: the specific
> problem I originally observed was in using Cut Transaction & Paste
> Transaction to correct the problem of having entered a transaction on the
> wrong register.
> 
> On Mon, May 3, 2021 at 8:02 PM Glenn Fowler  wrote:
> 
>> I'm assuming the copy/paste would be more for copying to a
>> different account as the duplicate option is in the same account.
>> 
>> On Mon, May 3, 2021 at 7:44 PM David H  wrote:
>> 
>>> Is there any advantage in using Copy Transaction and Paste Transaction ?
>>> I
>>> only ever use Duplicate Transaction - 1 step as opposed to 2...
>>> 
>>> Cheers David H.
>>> 
>>> 
>>> On Tue, 4 May 2021 at 07:07, David Carlson 
>>> wrote:
>>> 
 I would be willing to bet that you never automatically got the original
 date on any copy.  When I use the copy transaction feature in previous
 releases of GnuCash up to 3.8 it always asks for the date and defaults
>>> to
 today if not changed.
 
 On Mon, May 3, 2021, 2:19 PM Robert Stocker 
>>> wrote:
 
> Follow up to my earlier post, which I just noticed. My recommended
> work-around for the Cut Transaction & Paste Transaction problem (using
 Copy
> Transaction & Paste Transaction) has an issue I have never noticed
 before:
> 
> When I just used Copy Transaction & Paste Transaction, the date of the
> original transaction did not carry through when I pasted, the new
> transaction took today's date. Though I can't swear that it wasn't
>>> doing
> this before, I am 95% certain it did not.
> ___
> 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.

___
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] removing Appendix D; was:Chart of Account maintainers

[R. Victor Klassen]

I do.

I suspect most North America-based users of the business features write cheques 
(checks in the US).It’s just a matter of volume whether it’s worth printing 
them.  (I find it much easier to avoid missing recording them if they are 
recorded and then printed).

> On Apr 23, 2021, at 7:24 PM, David Carlson  
> wrote:
> 
> 
> Granted, not many users print checks any more, but IIRC there was a
> question quite recently about that on this maillist.

___
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] Import invoices ~ tax table

[R. Victor Klassen]

Bingo.  

This has been hanging around for a long time since 99% of our sales are 
zero-rated. Automatically catching the other 1% will reduce the opportunity for 
errors and speed up the process. 

Sent from my iPhone

> On Mar 5, 2021, at 7:13 AM, R. Victor Klassen  wrote:
> 
> I’m wondering whether I left out the “Tax Included” column, and whether 
> there are no important columns after that so it just (almost) works.
> 
> I’ll have another chance to try it out this morning, as we have an importable 
> invoice twice a week.  Something to try.
> 
>> On Mar 4, 2021, at 8:10 PM, Nelson Handcock  
>> wrote:
>> 
>> In your original email you say your GST Tax table is in column P - mine is 
>> in column Q. So perhaps that's the problem?
>> 
>> Thanks & Regards,
>> 
>> Nelson Handcock
>> 0409 149919
>> 
>> http://www.linkedin.com/in/nelsonhandcockaustralia
>> 
>> 
>> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock  
>> wrote:
>>> Hello,
>>> 
>>> Ahh yes - I mis-read your original email!
>>> 
>>> Here's a snapshot of my recent loadfile:
>>> 
>>> 
>>> And here's a snapshot of my tax tables:
>>> 
>>> 
>>> The loaded invoice looks fine in GN - the GST amount is correct and is 
>>> showing in the liabilities account as defined.
>>> 
>>> 
>>> Thanks & Regards,
>>> 
>>> Nelson Handcock
>>> 
>>> 
>>> 
>>> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen  
>>> wrote:
>>>> When I said the x in the “Taxable?” column is correctly showing which 
>>>> items are taxable, I was referring to the column in the invoice after 
>>>> import.
>>>> 
>>>> I do have a Y in the appropriate column of the csv file being imported - 
>>>> else I wouldn’t get the x in the “Taxable?” column.
>>>> 
>>>> 
>>>>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock  
>>>>> wrote:
>>>>> 
>>>>> Hello,
>>>>> 
>>>>> Try using "Y" in the Taxable column instead of "X"
>>>>> 
>>>>> Regards, etc
>>>>> 
>>>>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen,  
>>>>> wrote:
>>>>>> The documentation I’ve read has me specify the tax table in column 15 
>>>>>> (counting from 0) aka column P when the csv file is opened as a 
>>>>>> spreadsheet. 
>>>>>> 
>>>>>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, 
>>>>>> both of which name sales tax tables, in that column, it is ignored. 
>>>>>> 
>>>>>> The x in the “Taxable?” Column is correctly showing which items are 
>>>>>> taxable. 
>>>>>> 
>>>>>> Is there a trick I am missing?
>>>>>> 
>>>>>> 
>>>>>> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
>>>>>> 
>>>>>> Sent from my iPhone
>>>>>> ___
>>>>>> 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] Import invoices ~ tax table

[R. Victor Klassen]

I’m wondering whether I left out the “Tax Included” column, and whether there 
are no important columns after that so it just (almost) works.

I’ll have another chance to try it out this morning, as we have an importable 
invoice twice a week.  Something to try.

> On Mar 4, 2021, at 8:10 PM, Nelson Handcock  wrote:
> 
> In your original email you say your GST Tax table is in column P - mine is in 
> column Q. So perhaps that's the problem?
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 0409 149919
> 
> http://www.linkedin.com/in/nelsonhandcockaustralia 
> <http://www.linkedin.com/in/nelsonhandcockaustralia>
> 
> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock  <mailto:nelson.handc...@gmail.com>> wrote:
> Hello,
> 
> Ahh yes - I mis-read your original email!
> 
> Here's a snapshot of my recent loadfile:
> 
> 
> And here's a snapshot of my tax tables:
> 
> 
> The loaded invoice looks fine in GN - the GST amount is correct and is 
> showing in the liabilities account as defined.
> 
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 
> 
> 
> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen  <mailto:rvklas...@gmail.com>> wrote:
> When I said the x in the “Taxable?” column is correctly showing which items 
> are taxable, I was referring to the column in the invoice after import.
> 
> I do have a Y in the appropriate column of the csv file being imported - else 
> I wouldn’t get the x in the “Taxable?” column.
> 
> 
>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock > <mailto:nelson.handc...@gmail.com>> wrote:
>> 
>> Hello,
>> 
>> Try using "Y" in the Taxable column instead of "X"
>> 
>> Regards, etc
>> 
>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, > <mailto:rvklas...@gmail.com>> wrote:
>> The documentation I’ve read has me specify the tax table in column 15 
>> (counting from 0) aka column P when the csv file is opened as a spreadsheet. 
>>  
>> 
>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, 
>> both of which name sales tax tables, in that column, it is ignored. 
>> 
>> The x in the “Taxable?” Column is correctly showing which items are taxable. 
>> 
>> Is there a trick I am missing?
>> 
>> 
>> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
>> 
>> Sent from my iPhone
>> ___
>> 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: [GNC] Import invoices ~ tax table

[R. Victor Klassen]

When I said the x in the “Taxable?” column is correctly showing which items are 
taxable, I was referring to the column in the invoice after import.

I do have a Y in the appropriate column of the csv file being imported - else I 
wouldn’t get the x in the “Taxable?” column.


> On Mar 2, 2021, at 2:50 PM, Nelson Handcock  wrote:
> 
> Hello,
> 
> Try using "Y" in the Taxable column instead of "X"
> 
> Regards, etc
> 
> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen,  <mailto:rvklas...@gmail.com>> wrote:
> The documentation I’ve read has me specify the tax table in column 15 
> (counting from 0) aka column P when the csv file is opened as a spreadsheet.  
> 
> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, both 
> of which name sales tax tables, in that column, it is ignored. 
> 
> The x in the “Taxable?” Column is correctly showing which items are taxable. 
> 
> Is there a trick I am missing?
> 
> 
> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
> 
> Sent from my iPhone
> ___
> 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: [GNC] 4.4 slow

[R. Victor Klassen]

Just got around to checking, and yes there were multiple voided transactions in 
both accounts. 

I haven’t tried check and repair since the magic of saving in the other format 
and then reopening cleared up the slowness. 

Sent from my iPhone

> On Feb 23, 2021, at 3:52 PM, Jim DeLaHunt  wrote:
> 
> On 2021-02-23 10:37, R. Victor Klassen wrote:
> 
>> I tried check and repair and ran into an infinite loop in accts receivable 
>> and accounts payable.
> 
> 
> Regarding that infinite loop: was there a voided transaction in those 
> accounts?
> 
> If so, it might be related to Bug 797984 - Infinite loop while Check & Repair 
> on voided transaction in Accounts/Receivable account - 
> <https://bugs.gnucash.org/show_bug.cgi?id=797984 
> <https://bugs.gnucash.org/show_bug.cgi?id=797984>>. I encountered that bug in 
> GnuCash 4.2. I worked around it by deleting the voided transaction. Bob 
> apparently fixed it in GnuCash 4.3. But if what you saw in GnuCash 4.4 was 
> this bug, then maybe the fix wasn't effective.
> 
> Or maybe what you saw is not related to Bug 797984.
> 
> Just another lead to follow, if it is helpful.  Best regards,
>  —Jim DeLaHunt
> 
> 
> ___
> 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.

[GNC] Import invoices ~ tax table

[R. Victor Klassen]

The documentation I’ve read has me specify the tax table in column 15 (counting 
from 0) aka column P when the csv file is opened as a spreadsheet.  

When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, both 
of which name sales tax tables, in that column, it is ignored. 

The x in the “Taxable?” Column is correctly showing which items are taxable. 

Is there a trick I am missing?


Gnucash v 3.11 MacOS 10.13.6 if it matters.  

Sent from my iPhone
___
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] 4.4 slow

[R. Victor Klassen]

As a follow-up 

I tried check and repair and ran into an infinite loop in accts receivable and 
accounts payable.  

I tried check and repair on descendants of income and expense but no effect

I tried backing off to 3.11 to no avail 

John suggested it was my machine so I moved to a fresh (but only slightly 
newer) machine. Nothing. 

As a last resort I saved to XML and it opened quickly.  Progress at last.  
Wanting the transactional behaviour of SQLite I saved again as SQLite and it 
now appears fast.  

So there was something mysterious about the file that seems to have been 
repaired. 

Sent from my iPhone

> On Feb 8, 2021, at 10:50 AM, R. Victor Klassen  wrote:
> 
> When I came in check & repair was in an infinite loop in accounts 
> receivable. 
> 
> The progress log shows it counting up to about 1000 out 6614 and then 
> restarting at 0. Not clear whether a profile of check and repair is useful.  
> System is relatively unresponsive while I try to interrupt it
> 
> Sent from my iPhone
> 
>> On Feb 5, 2021, at 3:30 PM, John Ralls  wrote:
>> 
>> 7 minutes is a lot. If it's still doing that after the C&R finishes then 
>> please open a bug and attach a profile.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>>> On Feb 5, 2021, at 12:21 PM, R. Victor Klassen  wrote:
>>> 
>>> It definitely does beachball long enough. 
>>> 
>>> Might be able to get a profile. 
>>> 
>>> It’s been in check and repair for a bit over 2 hrs now so I am guessing any 
>>> further probing will be Monday.  For what It’s worth it was in excess of 7 
>>> minutes of CPU time last time I started (from a crash).  Minimal disk 
>>> activity. Reasonable memory pressure 
>>> 
>>> Sent from my iPhone
>>> 
>>>>> On Feb 5, 2021, at 1:57 PM, John Ralls  wrote:
>>>> 
>>>> Does it beachball long enough to get a process sample out of Activity 
>>>> Monitor? Better yet, do you know your way around Xcode well enough to get 
>>>> a time profile?
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen  wrote:
>>>>> 
>>>>> I should also say I’m using the SQLite back end. 90% or more of what I do 
>>>>> passes though the business features. When I say entering an invoice line 
>>>>> is slow I mean that when I hit tab to get past the last entry and start a 
>>>>> new one I sometimes see the spinning lollipop. 
>>>>> 
>>>>> Trying check and repair to see if it makes a difference 
>>>>> 
>>>>> Sent from my iPhone
>>>>> 
>>>>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone 
>>>>>>>  wrote:
>>>>>> 
>>>>>> And on that note, it is always recommended when stepping between major 
>>>>>> versions to run Actions > Check & Repair > Check & Repair All. (which 
>>>>>> should accomplish such data translations all in one go)
>>>>>> 
>>>>>> I forgot to add that I'm using the SQLite backend. Not sure if that 
>>>>>> makes a difference.
>>>>>> 
>>>>>> Regards,
>>>>>> Adrien
>>>>>> 
>>>>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>>>>>>> My memory is a bit fuzzy, but version 4 made some significant changes 
>>>>>>> to (I think) a number of key-value structures in the database. The 
>>>>>>> first time you open version 4, it has to convert all the old values (if 
>>>>>>> you have done lots of transaction importing, that’s a big contributor). 
>>>>>>> If you quit gnucash before it’s done with the conversion, it  has to 
>>>>>>> start over the next time. I think it took something like 45 minutes 
>>>>>>> before my Mac was done updating everything internally in the database.
>>>>>>> After that it has been fine.
>>>>>> 
>>>>>> ___
>>>>>> 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/wik

Re: [GNC] 4.4 slow

[R. Victor Klassen]

When I came in check & repair was in an infinite loop in accounts receivable. 

The progress log shows it counting up to about 1000 out 6614 and then 
restarting at 0. Not clear whether a profile of check and repair is useful.  
System is relatively unresponsive while I try to interrupt it

Sent from my iPhone

> On Feb 5, 2021, at 3:30 PM, John Ralls  wrote:
> 
> 7 minutes is a lot. If it's still doing that after the C&R finishes then 
> please open a bug and attach a profile.
> 
> Regards,
> John Ralls
> 
> 
>> On Feb 5, 2021, at 12:21 PM, R. Victor Klassen  wrote:
>> 
>> It definitely does beachball long enough. 
>> 
>> Might be able to get a profile. 
>> 
>> It’s been in check and repair for a bit over 2 hrs now so I am guessing any 
>> further probing will be Monday.  For what It’s worth it was in excess of 7 
>> minutes of CPU time last time I started (from a crash).  Minimal disk 
>> activity. Reasonable memory pressure 
>> 
>> Sent from my iPhone
>> 
>>>> On Feb 5, 2021, at 1:57 PM, John Ralls  wrote:
>>> 
>>> Does it beachball long enough to get a process sample out of Activity 
>>> Monitor? Better yet, do you know your way around Xcode well enough to get a 
>>> time profile?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen  wrote:
>>>> 
>>>> I should also say I’m using the SQLite back end. 90% or more of what I do 
>>>> passes though the business features. When I say entering an invoice line 
>>>> is slow I mean that when I hit tab to get past the last entry and start a 
>>>> new one I sometimes see the spinning lollipop. 
>>>> 
>>>> Trying check and repair to see if it makes a difference 
>>>> 
>>>> Sent from my iPhone
>>>> 
>>>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone 
>>>>>>  wrote:
>>>>> 
>>>>> And on that note, it is always recommended when stepping between major 
>>>>> versions to run Actions > Check & Repair > Check & Repair All. (which 
>>>>> should accomplish such data translations all in one go)
>>>>> 
>>>>> I forgot to add that I'm using the SQLite backend. Not sure if that makes 
>>>>> a difference.
>>>>> 
>>>>> Regards,
>>>>> Adrien
>>>>> 
>>>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>>>>>> My memory is a bit fuzzy, but version 4 made some significant changes to 
>>>>>> (I think) a number of key-value structures in the database. The first 
>>>>>> time you open version 4, it has to convert all the old values (if you 
>>>>>> have done lots of transaction importing, that’s a big contributor). If 
>>>>>> you quit gnucash before it’s done with the conversion, it  has to start 
>>>>>> over the next time. I think it took something like 45 minutes before my 
>>>>>> Mac was done updating everything internally in the database.
>>>>>> After that it has been fine.
>>>>> 
>>>>> ___
>>>>> 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] 4.4 slow

[R. Victor Klassen]

Last I heard the “check and repair” was still running at 7 last night.  I’m 
home now, but will check it on Monday when I’m back there.

> On Feb 5, 2021, at 5:26 PM, David H  wrote:
> 
> Running GnuCash 4.4 on Big Sur 11.2, seems about the same except the save
> time has blown out by about a factor of 10 (i.e. from a few seconds to
> about 30-40 seconds), whereas Ubuntu and Win 10 are as speedy as ever.  I
> put it down to something in Big Sur - I have issues with my Logitech mouse
> as well when it starts to get all jittery and stop responding for half a
> second or so here and there. Maybe time for a system re-install, been
> putting it off as it's a lot of work :-(
> 
> Cheers David H.
> 
> 
> On Sat, 6 Feb 2021 at 06:12, John Ralls  wrote:
> 
>> Does it beachball long enough to get a process sample out of Activity
>> Monitor? Better yet, do you know your way around Xcode well enough to get a
>> time profile?
>> 
>> Regards,
>> John Ralls
>> 
>>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen 
>> wrote:
>>> 
>>> I should also say I’m using the SQLite back end. 90% or more of what I
>> do passes though the business features. When I say entering an invoice line
>> is slow I mean that when I hit tab to get past the last entry and start a
>> new one I sometimes see the spinning lollipop.
>>> 
>>> Trying check and repair to see if it makes a difference
>>> 
>>> Sent from my iPhone
>>> 
>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>>> 
>>>> And on that note, it is always recommended when stepping between major
>> versions to run Actions > Check & Repair > Check & Repair All. (which
>> should accomplish such data translations all in one go)
>>>> 
>>>> I forgot to add that I'm using the SQLite backend. Not sure if that
>> makes a difference.
>>>> 
>>>> Regards,
>>>> Adrien
>>>> 
>>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>>>>> My memory is a bit fuzzy, but version 4 made some significant changes
>> to (I think) a number of key-value structures in the database. The first
>> time you open version 4, it has to convert all the old values (if you have
>> done lots of transaction importing, that’s a big contributor). If you quit
>> gnucash before it’s done with the conversion, it  has to start over the
>> next time. I think it took something like 45 minutes before my Mac was done
>> updating everything internally in the database.
>>>>> After that it has been fine.
>>>> 
>>>> ___
>>>> 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.

___
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] 4.4 slow

[R. Victor Klassen]

It definitely does beachball long enough. 

Might be able to get a profile. 

It’s been in check and repair for a bit over 2 hrs now so I am guessing any 
further probing will be Monday.  For what It’s worth it was in excess of 7 
minutes of CPU time last time I started (from a crash).  Minimal disk activity. 
Reasonable memory pressure 

Sent from my iPhone

> On Feb 5, 2021, at 1:57 PM, John Ralls  wrote:
> 
> Does it beachball long enough to get a process sample out of Activity 
> Monitor? Better yet, do you know your way around Xcode well enough to get a 
> time profile?
> 
> Regards,
> John Ralls
> 
>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen  wrote:
>> 
>> I should also say I’m using the SQLite back end. 90% or more of what I do 
>> passes though the business features. When I say entering an invoice line is 
>> slow I mean that when I hit tab to get past the last entry and start a new 
>> one I sometimes see the spinning lollipop. 
>> 
>> Trying check and repair to see if it makes a difference 
>> 
>> Sent from my iPhone
>> 
>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone 
>>>>  wrote:
>>> 
>>> And on that note, it is always recommended when stepping between major 
>>> versions to run Actions > Check & Repair > Check & Repair All. (which 
>>> should accomplish such data translations all in one go)
>>> 
>>> I forgot to add that I'm using the SQLite backend. Not sure if that makes a 
>>> difference.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>>>> My memory is a bit fuzzy, but version 4 made some significant changes to 
>>>> (I think) a number of key-value structures in the database. The first time 
>>>> you open version 4, it has to convert all the old values (if you have done 
>>>> lots of transaction importing, that’s a big contributor). If you quit 
>>>> gnucash before it’s done with the conversion, it  has to start over the 
>>>> next time. I think it took something like 45 minutes before my Mac was 
>>>> done updating everything internally in the database.
>>>> After that it has been fine.
>>> 
>>> ___
>>> 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] 4.4 slow

[R. Victor Klassen]

I should also say I’m using the SQLite back end. 90% or more of what I do 
passes though the business features. When I say entering an invoice line is 
slow I mean that when I hit tab to get past the last entry and start a new one 
I sometimes see the spinning lollipop. 

Trying check and repair to see if it makes a difference 

Sent from my iPhone

> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone 
>  wrote:
> 
> And on that note, it is always recommended when stepping between major 
> versions to run Actions > Check & Repair > Check & Repair All. (which should 
> accomplish such data translations all in one go)
> 
> I forgot to add that I'm using the SQLite backend. Not sure if that makes a 
> difference.
> 
> Regards,
> Adrien
> 
>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote:
>> My memory is a bit fuzzy, but version 4 made some significant changes to (I 
>> think) a number of key-value structures in the database. The first time you 
>> open version 4, it has to convert all the old values (if you have done lots 
>> of transaction importing, that’s a big contributor). If you quit gnucash 
>> before it’s done with the conversion, it  has to start over the next time. I 
>> think it took something like 45 minutes before my Mac was done updating 
>> everything internally in the database.
>> After that it has been fine.
> 
> ___
> 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.

[GNC] 4.4 slow

[R. Victor Klassen]

So I finally decided to upgrade from 2.6.21, and downloaded 4.4 for Mac. I had 
read something about faster startup times.  

Well I am unconvinced about that part.  But worse still, it regularly has long 
delays when entering lines in an invoice or posting it. 

I think I would have heard lots of complaints by now if this were common.  
Wondering what might be up with this. 

Mac OS 10.13.6. 
Gnucash version 4.4+ (2020-12-28)

Sent from my iPhone
___
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] List of invoices

[R. Victor Klassen]

That works.  I had thought of an account report - for which Accounts Receivable 
is special, and so it doesn’t work, but the transaction report works fine.

Thanks.

> On Jan 30, 2021, at 11:14 AM, Derek Atkins  wrote:
> 
> How about a transaction report of your A/R account?
> Filter by dates; Sort by amount?
> That will give you the invoice numbers -- then you can open and print
> those invoices.
> 
> -derek
> 
> On Sat, January 30, 2021 10:50 am, R. Victor Klassen wrote:
>> Our taxing authority is doing something more than a rubber stamp and less
>> than a full audit of our HST (a.k.a VAT) for the last year.  Among other
>> things they are requesting our 10 largest invoices to different customers.
>> Most of what we sell is zero-rated, meaning that there is no tax (food).
>> But we do sell some other things as well, for which we charge tax.  I can
>> look at a transaction report to easily find the 10 largest instances of
>> charging tax, but they seem to want the 10 largest invoices (independent
>> of tax).
>> 
>> Is there a way of listing invoices within a time period, without
>> restricting it by customer and showing the invoice amount?   It’s
>> certainly not in a report I commonly use.
>> ___
>> 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.
>> 
> 
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> 

___
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] List of invoices

[R. Victor Klassen]

Our taxing authority is doing something more than a rubber stamp and less than 
a full audit of our HST (a.k.a VAT) for the last year.  Among other things they 
are requesting our 10 largest invoices to different customers.
Most of what we sell is zero-rated, meaning that there is no tax (food).  But 
we do sell some other things as well, for which we charge tax.  I can look at a 
transaction report to easily find the 10 largest instances of charging tax, but 
they seem to want the 10 largest invoices (independent of tax).  

Is there a way of listing invoices within a time period, without restricting it 
by customer and showing the invoice amount?   It’s certainly not in a report I 
commonly use.
___
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] Commission sales

[R. Victor Klassen]

The reason it matters that it is not revenue is that in this jurisdiction there 
is a subsidy based on reduction in revenue during COVID-19.  The neighbour’s  
ability to sell was severely hampered so we helped out.   Before the pandemic 
we were not selling anything for him, nor did we have an online store.  So it 
doesn’t make sense to inflate revenue. For income tax purposes the difference 
is only what goes on what line of the tax forms and the end result is the same. 

Regarding your side comment with the discount for early payment - yes we have 
at least two such vendors.  It would be nice if bills permitted discounts like 
invoices do, since there may be five line items with three accounts and I 
generally don’t but should allocate the discount proportionately.  


Sent from my iPhone

> On Jan 15, 2021, at 1:15 PM, Adrien Monteleone 
>  wrote:
> 
> On 1/15/21 7:25 AM, R. Victor Klassen wrote:
>> The mechanism looks like this: customer orders from our online store 
>> (typically) some items of ours and some of the neighbour’s.  Branding is 
>> clear on the store.  Twice a week we deliver orders.  On that day or the one 
>> before, we inform the neighbour what they need to supply (we have no 
>> inventory of theirs - they are responsible for informing us how much we can 
>> sell) and they bring it over.  We pay in cash the amount the customer will 
>> pay us, less a percentage.  The customer has already paid us through the 
>> online store.
>> Where it starts to look like bills and invoices is that the online ordering 
>> system provides us with what can be (fairly) easily converted (perl script) 
>> into an importable invoice.  But the online system, being 3rd party, has no 
>> idea that we have a mix of sales out of our inventory and commission sales, 
>> so the invoice contains both.
> 
> Okay, so this is more formal than I was thinking. Certainly, if you can make 
> this work by importing from a 3rd-party app, that is the best route.
> 
>> This looks somewhat cleaner than having an expense amount that later gets 
>> re-characterized.
>> Cleaner yet would be putting an income entry in a bill, but that’s not 
>> permitted.
> 
> 
> Probably because that would then be a charge to the neighbor, which is 
> usually done for a 'customer' rather than a vendor. (the devs seem to take 
> the approach that it is extremely rare for customers to also be vendors 
> and/or employees, or all three. From personal mom & pop small biz experience, 
> I beg to differ, but I understand trying to accommodate such cases might be a 
> bit messy for the code.)
> 
> You could possibly initially treat the commission as a discount from the 
> neighbor. I don't know if you can use the discount feature and have it hit a 
> proper income account, or if it needs a special contra-expense account that 
> you later balance out with income. Otherwise, you could maybe enter it as a 
> separate line-item.
> 
> Maybe ask a CPA, as it might work as a discount the whole way around and you 
> don't need to involve income accounts at all for it. (if you are tracking 
> COGS, it would reduce your cost, thus increasing income, as distinct from 
> revenue) This would be similar to 2/10Net30 terms (does anyone offer that 
> anymore?) where if you pay within 10 days, you can deduct 2% off the invoice, 
> otherwise you have to pay within 30 days to avoid late fees or interest. Such 
> terms are vendor discounts applied against inventory, and thus against COGS. 
> (and very likely tracked in their own account a la "Vendor Discounts" so you 
> can tell if you are taking advantage of them. Some business even track 
> available vs. utilized discounts for that reason.)
> 
> Since you are paying the neighbor for the merchandise and taking possession 
> of it, perhaps you should be booking it to inventory anyway. (again, a local 
> CPA can better answer that for your exact situation)
> 
> This kind of sounds like a 3rd party shipping and payment factor situation 
> (common in the furniture industry for example) where sometimes, the trucking 
> company takes possession of the merchandise legally, buying it (the invoice 
> less a percentage for the convenience) from the shipper, and then collects 
> the full amount from the retailer. This used to be common with owner/operator 
> single-rig truckers, but can still be found with small fleet operations.
> 
> Other than the manufacturer/wholesaler shipping on their own trucks, the 
> other scenario is the retailer takes legal possession at the shipping point 
> (known as "FOB shipping") and pays the shipper and trucking company 
> separately. The trucking company is merely custodian for the retailer's 
> pro

Re: [GNC] Commission sales

[R. Victor Klassen]

> On Jan 14, 2021, at 10:48 AM, Adrien Monteleone 
>  wrote:
> 
> The usual "I am not an accountant and this is not accounting advice" applies 
> here. The following is simply how *I* would approach this:
> 
And I’m not really asking about accounting, more the GnuCash mechanisms.

> Some questions would need to be answered first.
> 
> Are you taking possession of the goods from your neighbor, or is this just a 
> consignment type operation? (meaning, do you have any financial or legal 
> interest in the goods, can you walk away with them, or can they take them 
> back with no issue?) I understand this might be quite an informal 
> arrangement, but unless you are buying the goods from the neighbor, I 
> wouldn't think there is an occasion for entering a bill for them.

The mechanism looks like this: customer orders from our online store 
(typically) some items of ours and some of the neighbour’s.  Branding is clear 
on the store.  Twice a week we deliver orders.  On that day or the one before, 
we inform the neighbour what they need to supply (we have no inventory of 
theirs - they are responsible for informing us how much we can sell) and they 
bring it over.  We pay in cash the amount the customer will pay us, less a 
percentage.  The customer has already paid us through the online store. 

Where it starts to look like bills and invoices is that the online ordering 
system provides us with what can be (fairly) easily converted (perl script) 
into an importable invoice.  But the online system, being 3rd party, has no 
idea that we have a mix of sales out of our inventory and commission sales, so 
the invoice contains both.

> 
> I would think a holding/suspense liability account for the funds collected on 
> behalf of the neighbor would work, named something like 'Sales-Payable'. 
> (similar concept to sales tax collection) The full amount collected from the 
> end customer drops here first from their invoice. (posted against AR, which 
> itself is reduced as the end customer pays you.)
> 
> Result: Dr. AR, Cr. Liabilities:Sales-Payable

I was aware that I could not enter an expense account in an invoice, but hadn’t 
realized that liabilities accounts were permitted.

> 
> Do a manual transaction periodically or each time, reducing the holding 
> account balanced against an income account. (Dr. Sales-Payable, Cr. 
> Income:Commission)
> 

This looks somewhat cleaner than having an expense amount that later gets 
re-characterized.
Cleaner yet would be putting an income entry in a bill, but that’s not 
permitted.

> 
> 
> 
> Regards,
> Adrien
> 
> On 1/13/21 12:09 PM, R. Victor Klassen wrote:
>> Since early in the pandemic we’ve been selling some of our neighbour’s 
>> stuff, charging a few percent commission, mostly to cover credit card fees.
>> Our income here is really just the commission since the end customer knows 
>> it isn’t ours and we aren’t providing any value add othe than facilitating 
>> the order and delivery process.
>> The only way I have figured out to account using the business features is to 
>> enter an invoice to the end customer and a bill for the full amount from the 
>> neighbour.  Then I have to hack around in the income and expense accounts to 
>> make the difference between the two show up as commission.
>> This is because I can’t put an income account in a bill.
>> Is there a more elegant way of handling this?
> 
> ___
> 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.

[GNC] Commission sales

[R. Victor Klassen]

Since early in the pandemic we’ve been selling some of our neighbour’s stuff, 
charging a few percent commission, mostly to cover credit card fees.  

Our income here is really just the commission since the end customer knows it 
isn’t ours and we aren’t providing any value add othe than facilitating the 
order and delivery process.  

The only way I have figured out to account using the business features is to 
enter an invoice to the end customer and a bill for the full amount from the 
neighbour.  Then I have to hack around in the income and expense accounts to 
make the difference between the two show up as commission. 

This is because I can’t put an income account in a bill.  

Is there a more elegant way of handling this?

Sent from my iPhone
___
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] bulk operations?

[R. Victor Klassen]

The advantage of getting the invoices in a spreadsheet is that, as far as I can 
tell (haven’t tested this) you can put the whole string of invoices in one 
file. Each line in the file has a field for invoice number, and I believe if 
you change the number it creates an additional invoice. So if there is more 
than one or two, I think the net number of mouse clicks would be reduced.

You might want to test it on a dummy gnucash file, as otherwise you might wind 
up with LOTS of garbage invoices from testing. 

> On Dec 7, 2020, at 5:45 PM, Samantha Payn  
> wrote:
> 
> 
> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into 
> Gnucash down to a fine art (especially with the recent “predictive text” 
> input in my “product” fields! Thanks again for that, whoever it was!). It is 
> specifically the step to confirm the exchange rate when posting an invoice 
> which is the time consuming point.
> Samantha Payn
> 
>> On 7 Dec 2020, at 22:25, Adrien Monteleone  
>> wrote:
>> 
>> Samantha, you can import invoice data.
>> 
>> Thus, if you have a way to easily create that data in a spreadsheet, you can 
>> save it as CSV, then import them to GnuCash.
>> 
>> See the Help/Guide about importing business data for the required columns.
>> 
>> I'm not certain if it works well with a foreign currency however.
>> 
>> Regards,
>> Adrien
>> 
>>> On 12/7/20 4:11 PM, Samantha Payn wrote:
>>> I’d find a “batch post invoice” function enormously helpful. I have a 
>>> foreign currency client who insists on a separate invoice for each 
>>> (sometimes inconsequential) amount and the multiple clicks to post the 
>>> invoice and confirm the exchange rate for each one are time consuming.
>>> Currently the quickest I’ve got it is to create each invoice but not post 
>>> it, then use “find invoice” criteria to call all the invoices up, highlight 
>>> them all and then click “post” which prompts the exchange rate dialogue 
>>> (for every invoice). I use “fetch rate” for the first invoice, and just 
>>> “accept rate” for all the others, but that’s still three clicks per invoice 
>>> (I think).
>>> Please could Santa bring me a “batch post invoice” function for Christmas?
>> 
>> ___
>> 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] cash basis and accrual basis

[R. Victor Klassen]

And further, if you’re working with the business features, you will need to 
post invoices with a post date matching the period in which payment is 
received.  This may involve unposting and reposting.  They have to be posted to 
print without the “invoice in progress…” notation, but then if you want strict 
cash accounting you get to change the posted date to a period in which you 
expect to receive payment, and possibly again when your expectations turn out 
to be wrong.

With bills it’s easier, as you have control over when you pay them.

> On Oct 22, 2020, at 5:14 AM, Adrien Monteleone 
>  wrote:
> 
> It isn't a 'view'. If you want to work on cash basis, you record the 
> transaction when money physically (or digitally) changes hands. If you want 
> to work on an accrual basis, you record the transaction when the expense is 
> incurred or the income is earned without regards to actual exchanges.
> 
> 
> Regards,
> Adrien
> 
> On 10/21/20 5:34 AM, HaxNet wrote:
>> Hi,
>> Is there a way to choose which basis I want to view? Right now, it's 
>> defaulted to Accrual.
>> When I pick the Income Statement, and income hasn't been received yet, I 
>> don't want it to show that there's revenue.
>> Thank you in advance.
> 
> ___
> 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] I'm still a bit confused about when things get saved.

[R. Victor Klassen]

At least on the Mac, there’s no guarantee that it is physically written to disk 
immediately.  I’ve experienced a handful of posted and printed invoices 
disappearing due to a power outage.  Probably less likely to happen on a system 
with an SSD drive, as there’s not as much reason to wait to flush disk buffers 
to disk.  This would be an issue with the SQLite implementation, likely not in 
GnuCash directly.

> 
> Correct, this is "commiting" the transaction.  At this stage it will only
> go into the in-memory cache of your data.  It is not written to disk
> (unless you're using a SQL backend -- that's one of the two main
> differences between SQL and XML-File storage).
> 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] Anyone noticing an issue with list messages 'un-threading'?

[R. Victor Klassen]

Yes.  In fact it just happened with your latest reply to the “Chaning …” thread.

> On Jan 7, 2020, at 2:08 PM, Adrien Monteleone 
>  wrote:
> 
> Starting in late December I noticed almost every subject is coming in as 
> separate threads at some point.
> 
> An initial post is made, then a reply or two appears, then a subsequent reply 
> appears as a separate ‘conversation’, which might have a reply or more, and 
> then it splits off again. For some longer threads, this can happen several 
> times.
> 
> I’m curious if anyone else is seeing this behavior or if it might just be my 
> mail client acting up. (MacOS Mail.app)
> 
> This isn’t a case of getting a direct-addressed reply instead of the one from 
> the list. That happens on occasion, but even then Mail.app was threading by 
> subject. Each of the split conversations are all coming from the list address.
> 
> Regards,
> Adrien 
> ___
> 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] Voucher checks?

[R. Victor Klassen]

And if you have them printed by gnucash you save the risk of what’s in the 
register differing from what got printed, which for me is worth a lot

Sent from my iPhone

> On Nov 23, 2019, at 2:52 PM, John Ralls  wrote:
> 
> 
> 
>> On Nov 23, 2019, at 10:35 AM, Roderick Anderson  wrote:
>> 
>> Good Day.
>> 
>> The organization I am treasurer for currently has three-up checks that I 
>> fill out by hand.
>> 
>> We typically only use 10 or less a year and I have plenty on hand but I 
>> would prefer not hand writing them out.  I don't need GnuCash to print the 
>> checks but do need something that is usable from LibreOffice - ready made 
>> template?
>> 
>> My research (Google) turns some up but everyone mentions being compatible 
>> with commercial accounting software.  Probably so they can be printed from 
>> the software.  Since I do not need that I would still like any thoughts or 
>> suggestions for a good brand.
> 
> GnuCash can print 3-up voucher checks, see 
> https://www.gnucash.org/docs/v3/C/gnucash-help/print-check.html. The only 
> reason not to use it would be if you get checks that don't have the MICR 
> routing id and account number pre-printed on them, but if you're currently 
> filling them out by hand you must already have those.
> 
> 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.
___
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] Print Report does not "page" properly

[R. Victor Klassen]

Because it is a problem wit WebKit, the workaround I use is to save it as HTML 
and then open it in a browser that handles it properly.  Some do, some don’t.  
It’s an optional feature in the standard.  

Sent from my iPhone

> On Oct 7, 2019, at 4:56 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I have the preferences set to Landscape and the margins set to .5 inches on 
> all 4-sides.
> When I print it does not always "form-feed" at the end of a line... 
> meaning half a line will be at the bottom of one page...and the other half at 
> the top of the next page.
> What is the best way to fix this?
> Thanks for any help.
> PS - I guess I could experiment around with different top and bottom margins 
> hoping to get the reports to print properly but that seems like a brute force 
> approach. Hopefully there is a more elegant approach that I am missing. 
> Thanks again.
> ___
> 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 not obtaining lock Solved

[R. Victor Klassen]

> On Sep 14, 2019, at 5:11 PM, Mike or Penny Novack 
>  wrote:
> 
> On 9/13/2019 1:50 PM, Bob Hammons wrote:
>> The trouble was Windows Defender in a recent update blocked Gnucash,  
>> Quicken and Open Office data directories.
>> This was in the Ransom ware section
>> Here is a website that explains how to fix this
>> ..
>> Wasn't very nice of MS to do this without any notice that these programs 
>> would be blocked
>> Thanks again for you help I did learn a little more about Windows but 
>> something new will pop up I am sure.
> That does not seem to me to be much of an explanation. I don't know about 
> Quicken, but with either OpenOffice (I use LibreOffice) or Gnucash the "data 
> directories" (the directory in which the data lives AND where the lock file 
> will be created) is up to you. Certainly MS didn't block "Documents" (the 
> parent directory where LibreOffice documents likely placed).
> 
Well, actually, yes.

And it makes sense.  They’re trying to protect you from ransomware - software 
that encrypts your stuff and then offers to give you the decryption key if you 
pay up.
The idea is that a known list of applications are allowed to touch files in the 
protected directories, and you can add tru

___
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 not obtaining lock Solved

[R. Victor Klassen]

> On Sep 14, 2019, at 5:11 PM, Mike or Penny Novack 
>  wrote:
> 
> On 9/13/2019 1:50 PM, Bob Hammons wrote:
>> The trouble was Windows Defender in a recent update blocked Gnucash,  
>> Quicken and Open Office data directories.
>> This was in the Ransom ware section
>> Here is a website that explains how to fix this
>> ..
>> Wasn't very nice of MS to do this without any notice that these programs 
>> would be blocked
>> Thanks again for you help I did learn a little more about Windows but 
>> something new will pop up I am sure.
> That does not seem to me to be much of an explanation. I don't know about 
> Quicken, but with either OpenOffice (I use LibreOffice) or Gnucash the "data 
> directories" (the directory in which the data lives AND where the lock file 
> will be created) is up to you. Certainly MS didn't block "Documents" (the 
> parent directory where LibreOffice documents likely placed).
> 
Well, actually, yes.

And it makes sense.  They’re trying to protect you from ransomware - software 
that encrypts your stuff and then offers to give you the decryption key if you 
pay up.
The idea is that a known list of applications are allowed to touch files in the 
protected directories, and you can add trusted applications to that list.  

From the first page of the web site linked in the previous message:
> 
> Controlled folder access applies to a number of system folders and default 
> locations, including folders such as Documents, Pictures, Movies, and Desktop.

___
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 bug

[R. Victor Klassen]

Local file.  Not a backup.  Accessing a backup would be an XML issue.

> On Jul 8, 2019, at 3:48 PM, Adrien Monteleone 
>  wrote:
> 
> Is your data file local or on a network? If a network, there might be 
> something that has interfered with the data being written. Also, be certain 
> you’re accessing the current file and not a 5 day old backup. (usually the 
> case in threads where users find data ‘missing’)
> 
> Regards,
> Adrien
> 
>> On Jul 8, 2019, at 10:55 AM, R. Victor Klassen  wrote:
>> 
>> Perhaps this has been fixed. I’m using 2.6.21 for production. 
>> 
>> Using SQLite I am expecting every transaction to hit disk immediately. 
>> 
>> Saturday we had a power failure and lost about five days’ worth of 
>> transactions including at least 10 invoices and three new customers.   
>> 
>> I think I can reconstruct. But I wouldn’t expect this to have happened. 
>> 
> 
> 
> ___
> 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.

[GNC] Gnucash bug

[R. Victor Klassen]

Perhaps this has been fixed. I’m using 2.6.21 for production. 

Using SQLite I am expecting every transaction to hit disk immediately. 

Saturday we had a power failure and lost about five days’ worth of transactions 
including at least 10 invoices and three new customers.   

I think I can reconstruct. But I wouldn’t expect this to have happened. 

Sent from my iPhone
___
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 treat benefit payments from government?

[R. Victor Klassen]

Both the Trillium benefit and the HST/GST credit are essentially refundable tax 
credits, except that are paid out either over a period of a year beginning some 
time after the filing deadline, or in a lump sum (but later).  Unlike in the US 
where state tax refunds are income for federal purposes, provincial and federal 
taxes do not interact.  So these are purely tax-free.

> On Apr 18, 2019, at 9:36 AM, Adrien Monteleone 
>  wrote:
> 
> Michael,
> 
> Yep, I’m well aware. I just looked over my Mom’s filing before she mailed it 
> off. Certainly, having to massage the raw number two or three times with 
> various figures from multiple lines on several different schedules just to 
> figure out if her SS payments were taxable I can attest you are correct, that 
> my question isn’t always a simple one.
> 
> But even an answer of ‘depends’ is an answer that you can take some action on.
> 
> Though I don’t live in Canada, I’m still curious to see how that one should 
> be handled.
> 
> Regards,
> Adrien
> 
>> On Apr 18, 2019, at 8:23 AM, Michael or Penny Novack 
>>  wrote:
>> 
>> On 4/17/2019 6:16 PM, Adrien Monteleone wrote:
>>> Someone on the list from Canada (even better, a local CPA) should offer 
>>> better advice, but the first question you probably want answered is, “Is 
>>> this taxable next year?”
>>> 
>>> That will likely influence how you record it now.
>>> 
>>> Regards,
>>> Adrien
>> Adrian, it could be worse than that (in the general case). How about SS 
>> pension payments here in the US? The question "is this taxable" cannot be 
>> answered based upon the pension payment alone because it will depend on 
>> OTHER income received. Thus while you could possibly "know" (barring 
>> unexpected events) that none of it will be taxable (your estimate of other 
>> income is below X) or that 85% of it will be taxable (your estimate of other 
>> income is above Y) what you enter COULD be wrong << in the former case you 
>> ended up receiving some windfall and in the latter, suffered some economic 
>> disaster >> But SOME of us, alas, normally have an "other" income between X 
>> and Y and always have a messy calculation to perform come tax time to figure 
>> out how much of our SS was taxable.
>> 
>> Michael D Novack
> 
> ___
> 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] How to treat benefit payments from government?

[R. Victor Klassen]

I generally treat such payments as income, but as its own account.  It isn’t 
taxable, or reportable, so if you care (i.e. if you are going to use your 
GnuCash data in filling in your income taxes, rather than, say downloading your 
T-slips), you want it segregated from other income.  Then I can do an Income 
Statement that does or does not include that account.  If I want to take it to 
the bank - to convince them I am worth lending some money to, I’d want to 
include it, as it increases my income.  Also it’s more complete for my own use. 
 


> On Apr 17, 2019, at 5:37 PM, gn00b  wrote:
> 
> When I file my 2019 personal income tax for income earned in 2018, the
> government will send me a monthly cheque based on my 2018 income. What
> should the credit side of the journal entry look like when I initially
> record this? Should I be treating this as income? I know I should Debit
> Benefit Receivable for the amount. When the government pays me, I know I
> would Debit Bank, Credit Benefit Receivable.
> 
> If anyone is from Canada, this is referring to the Ontario Trillium Benefit
> and the GST/HST Credit.
> 
> 
> 
> --
> 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.

___
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] Bills in Gnucash

[R. Victor Klassen]

Before you can do any of the below, you need to “enable business features”.  I 
don’t run GnuCash on this machine, so I don’t know exactly where that is - 
something anyone only does once - but when you have done that you can create 
customers (who buy from you) and vendors (who sell to you), and then create 
invoices (associated with customers) and bills (associated with vendors).  
Normally when invoices and bills are “posted” they create entries in Accounts 
Receivable and Accounts Payable respectively - which you don’t manipulate 
directly.  When you make/receive payment you go to the corresponding menu item 
(vendor->process payment or customer->process payment) and fill in the fields 
in the form that appears.   

At first it seems like a lot of overhead to have to create a customer for an 
invoice (if any one customer is unlikely to be repeat, you might want a 
pseudo-customer that you re-use)  or a vendor for a bill (more likely that 
vendors are recurring).  But once they’ve been created you just select them and 
there’s less typing.

> On Mar 29, 2019, at 7:23 AM, Justin Haynes  
> wrote:
> 
> Gustav, try what Geert says.  You’ll need an Accounts Payable account under 
> liabilities, and this is a standard accounting practice. 
> 
> When you create a new bill you post it, and it shows in Accounts Payable.  
> When you pay against that bill, it goes also to Accounts Payable.  The 
> billing system keeps vendors and bills organized so you know how much you owe 
> each vendor and for what.
> 
> Sent from my iPhone
> 
>> On Mar 29, 2019, at 5:42 AM, Geert Janssens  
>> wrote:
>> 
>> Hi Gustav,
>> 
>> Welcome to gnucash!
>> 
>> It's not clear what you mean with "I don't have a way to log in a bill...". 
>> Did you try
>> Business->Vendor->New Bill... ?
>> What exactly didn't work ?
>> 
>> Regards,
>> 
>> Geert
>> 
>> Op donderdag 28 maart 2019 21:24:41 CET schreef Gustav Kriek:
>>> Hi there
>>> I'm new to using Gnucash and its also the first time I'm doing my own
>>> books. I just started working for myself, and as sole proprietor I need to
>>> keep better track of things.
>>> Ive set up all of my accounts and brought everything up to date...took me
>>> quite a few hours to be honest. I just realised I dont have a way to log in
>>> a bill, see when its must be paid or indicate it has been paid. I presume I
>>> didnt make the correct selection when I chose my hierarchy. I don't want to
>>> create a new profile because it took so long. Is there a way I can add this
>>> in to what I already have?
>>> I would appreciate any advise.
>>> Gustav
>>> ___
>>> 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] BUSINESS CHECK PRINTING - BILLS PAID INFORMATION ON STUBS

[R. Victor Klassen]

I know of no way to get that information automatically included.

With the right format, you can get the name and address, and - if the 
information on the stubs is in the splits - the rest of the information more or 
less as shown.
The lack of automation is in getting the information into the splits.  

With some moderate programming you could likely extract the information for the 
splits from a vendor report and then massage it into a format suitable to be 
imported as qif or perhaps csv, thereby automatically populating the splits.
But I have no idea what your level of programming expertise is.

> On Feb 28, 2019, at 2:09 PM, Greg Crawford  wrote:
> 
> Hello,
> 
> Please advise if I err in format or in conforming to mailing list rules.
> I'm new to this and as well as to GNUCASH and open source programs.
> 
> I've installed GNUCASH on my Windows 10 PC this month. I'm still trying to
> figure out functions.
> 
> When I print a check that I have paid bills with, I need it to display the
> original bill information on the stubs. So far, I have only been able to
> get it to display "Liabilities:Accounts Payable" and the total amount of
> that bill.
> 
> I've attached a sample check (generated from Quickbooks exported check data
> by a VBA macro I wrote). This shows the information that I need on checks.
> Is there a way to print checks in this manner from GNUCASH? Or, maybe a
> report I can generate that will contain that information?
> 
> Thanks for your help,
> g
> ___
> 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] SMTP TLS -- Re: Liabilities and Net Worth in Android app

[R. Victor Klassen]

It reachd the list.

> On Feb 11, 2019, at 4:58 PM, Derek Atkins  wrote:
> 
> humming.b...@posteo.net writes:
> 
>> Dear Derek,
>> 
>> if this email reaches the list, then TLS is working.
> 
> Considering you sent it to me *and* the list, I have no way to confirm.
> My tests seem to imply it is working.  ;)
> 
>> Cheers
>> Chris
> 
> -derek
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com www.ihtfp.com
>   Computer and Internet Security Consultant
> ___
> 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] Impossible de faire une copie de sauvegarde pour le fichier /run/media/pierre/Stockage/Documents/oney 10/Compte Chicot (translated)

[R. Victor Klassen]

I think he said

I’ve been using gnu cash for many years and have never had this problem.  What 
do I need to do in order to allow me to save backups again?

…  Not that I have an answer to contribute.

> On Jan 20, 2019, at 4:01 AM, Pierre Chaland  wrote:
> 
> J'utilise Gnucash depuis de très nombreuses années et je n'ai jamais eu ce 
> problème. Que dois je faire pour permettre à nouveau mes sauvegardes de se 
> faire?
> 
> Merci de votre aide
> 
> Salutations
> 
> -- 
>Pierre Chaland
>  Le Chicot
> 47900 Montagnac-surAuvignon
>  Tél: 0553971013
> 
> ___
> 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] Export Report to PDF - characters split across pages

[R. Victor Klassen]

… and then if that doesn’t work, switch browsers (for the purpose of 
printing/exporting to PDF).  Some browsers ignore the optional tag that 
controls whether characters can be split across page breaks.  Others don’t.

> On Dec 19, 2018, at 7:46 AM, David Carlson  
> wrote:
> 
> Michael,  Try exporting the report to html.
> 
> David C
> 
> On Wed, Dec 19, 2018 at 5:31 AM Michael Hendry 
> wrote:
> 
>> Here is a screen-shot to demonstrate the problem:
>> 
>> 
>> https://www.dropbox.com/s/mmde3eqphnhabp6/Screenshot%202018-12-19%2011.22.14.png?dl=0
>> 
>> The report is readable, but inelegant.
>> 
>> Any suggestions?
>> 
>> Regards,
>> 
>> 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.
>> 
> ___
> 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] How to handle a Square Transaction

[R. Victor Klassen]

What I do for Square is basically the same.  I am using invoices for the 
transactions involved.  In fact, it’s more complicated, since a few customers 
at the farmers’ market will use square while the vast majority pay cash, and we 
treat the farmers’ market as a single virtual customer.  So when part of the 
payment for a day’s market is through square, the invoice is ‘paid’ through 
square - to the Assets/Current Assets/Square Payments account - and the 
remainder is paid to petty cash.

Then when Square pays (2-3 days later) I put in a split transaction drawing it 
down from Square Payments and dividing the full amount into the amount that 
goes into the bank account and the amount that goes to Expenses/Bank Fees (I 
dion’t distinguish Square fees at the account level).  

Basically the same as below, but with the extra step of having an invoice 
involved.

> On Dec 5, 2018, at 7:16 AM, Maf. King  wrote:
> 
> Looks right to me, assuming all the account balances increase!
> 
> Maf.
> 
> 
> On Wednesday, 5 December 2018 11:52:08 GMT Overland Park Electric Company 
> wrote:
>> Thanks for the info.  I was actually shocked when I saw the money
>> transferred overnight.
>> I think I figured it out.
>> 
>> 
>> checking  120.00
>> credit card fees   5.00
>> job income  125.00
>> 
>> On Wed, Dec 5, 2018 at 5:31 AM Maf. King > > wrote:
>>> OK,
>>> 
>>> Assuming Square sits on your money for a day or 2 (or longer), I would
>>> create
>>> a couple of accounts.
>>> 
>>> something like
>>> Assets:Current Assets: Square
>>> and
>>> Expenses:BankingFees:SquareCommission
>>> 
>>> Record the payment as a 3-way split  (i'm never sure about which column is
>>> which, and I don't have GC open at the moment to test)
>>> Assets:C:S+120
>>> Income  +125
>>> Expenses:B:S+5
>>> 
>>> then when square moves the money to your bank, I'd just do a simple
>>> transaction to move the 120 from Assets:Square to Assets:checking
>>> 
>>> If square don't sit on your money for more than a day, I'd just skip the
>>> new
>>> Asset account and do the 3-way txn straight into the main bank account...
>>> 
>>> HTH,
>>> Maf.
>>> 
>>> 
>>> 
>>> On Wednesday, 5 December 2018 11:18:00 GMT Overland Park Electric Company
>>> 
>>> wrote:
 I don't use GC to create the invoice and I only enter the transaction
>>> 
>>> when
>>> 
 I get paid.
 
 On Wed, Dec 5, 2018 at 4:57 AM Maf. King  wrote:
> Hi,
> 
> do you create an invoice in GC (ie. accruals) or is this all
>>> 
>>> "cash-based"
>>> 
> accounting?
> 
> 
> -- 
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
> 
> 
> 
> 
> 
> ___
> 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] Migrating to iMac from PC

[R. Victor Klassen]

Sent from my iPhone

> On Nov 28, 2018, at 9:47 AM, Colin Law  wrote:
> 
> 
> I hope you are going to be running Linux on the new machine.
> 
> Colin

Why?  The iMac runs a Unix variant native. It’s called macOS 

> ___
> 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] Inheritance of Cash

[R. Victor Klassen]

There may have been a small amount of earnings between the death and 
distribution. Not sure about the treatment here but the US does charge the 
heirs tax on their part of those gains. 

Sent from my iPhone

> On Oct 12, 2018, at 5:34 PM, Leo Bolta  wrote:
> 
> Thanks for the input all!  Good to especially know that the tax had already 
> been paid before the final distribution.
> 
> 
>> On 2018-10-12 8:44 AM, R. Victor Klassen wrote:
>> Canada does not have inheritance tax.  Presuming the executor got it right, 
>> the estate paid all its taxes before releasing the last of the inheritance.  
>> I’m not sure what happens if the executor screws up and distributes too much 
>> before CRA has its final say on how much the estate owes (basically any 
>> capital gains and the remaining value of any RRSP/RIF/LIF are treated as 
>> income in the year of death, in addition to the usual income for that year, 
>> and these are taxable just the same as if they had been sold the day before 
>> death).  And there’s probate, which is another tax - also to be paid by the 
>> estate before the final distribution.
>> 
>> As far as GnuCash is concerned, that has already been answered.
>> 
>>> On Oct 11, 2018, at 11:27 PM, Leo Bolta  wrote:
>>> 
>>> How would one handle a transaction of inherited cash in GnuCash within 
>>> Canada?  Can I expect to be paying taxes on the sum in the future?
>>> 
>>> Thanks,
>>> 
>>> Leo
>>> 
>>> 
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.
>>> https://www.avast.com/antivirus
>>> 
>>> ___
>>> 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] Inheritance of Cash

[R. Victor Klassen]

Canada does not have inheritance tax.  Presuming the executor got it right, the 
estate paid all its taxes before releasing the last of the inheritance.  I’m 
not sure what happens if the executor screws up and distributes too much before 
CRA has its final say on how much the estate owes (basically any capital gains 
and the remaining value of any RRSP/RIF/LIF are treated as income in the year 
of death, in addition to the usual income for that year, and these are taxable 
just the same as if they had been sold the day before death).  And there’s 
probate, which is another tax - also to be paid by the estate before the final 
distribution.

As far as GnuCash is concerned, that has already been answered.  

> On Oct 11, 2018, at 11:27 PM, Leo Bolta  wrote:
> 
> How would one handle a transaction of inherited cash in GnuCash within 
> Canada?  Can I expect to be paying taxes on the sum in the future?
> 
> Thanks,
> 
> Leo
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> ___
> 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.