Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

[Fran_3 via gnucash-user]

 Glad to see your are still active Adrien. You and the others here are an asset 
to the community and we are thankful for your participation in the gnuCash 
email list.

On Monday, March 21, 2022, 10:53:03 PM EDT, Adrien Monteleone 
 wrote:  
 
 Yeah, I got one too.

I'm still here of course. I took a break last fall, but have been fairly 
active since returning.

Regards,
Adrien

On 3/21/22 3:17 PM, David Carlson wrote:
> Fran_3,
> 
> I did not see your original message.  Did you send it directly to
> Christopher instead of the list?  That is seriously discouraged, and the
> primary reason that I thought that was phishing.

___
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] Have you abandoned gnuCash email list? U were so helpful!

[Fran_3 via gnucash-user]

 Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very small 
entities here in Florida.They make the data inputs during the year and I try 
and help them organize their annual financials for their tax guy to do their 
taxes.
That said, I am not an accountant but I know enough to get by with a little 
help from the great gnuCash forum members.
And, I will say that I am a big fan of the program... even though I wish it 
could also generate reports on a cash basis... as opposed to an accrual 
basis... but I can get there by exporting select gnuCash accounts and 
Transaction Reports to cvs files and then loading them into Google Sheets or 
Excel.
Thanks.Fran LeeFlorida


On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson 
 wrote:  
 
 That looks to me like it was an exceptionally well crafted phishing email

On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam  
wrote:

On Sun, 20 Mar 2022 at 14:34, Fran_3  wrote:

> (snip).
>
Now I don't see you participating and it seems traffic on the list is way
> down.
> Have the developers abandoned the project?
>

Thank you Fran; no, the project is alive as long as there is interest in
it. The number of live bugs seems to be decreasing, hence the slow decline
in traffic. It seems the community is being very helpful, thus there's
little need to intervene.
___
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.

[GNC] How to create Transaction Report Filter on Checking to only show Accounts Payable Transactions?

[Fran_3 via gnucash-user]

I struggle with the Transaction Report Filter.
The Situation:If I create a Transaction Report on Checking for last year...- I 
can enter key words from the Description field or from the Memo/Notes field...- 
into Transaction Filter field...- and it works fine...ButIf I enter "Accounts 
Payable" into the Transaction Filter field... it does not work.Ditto if I enter 
"Transfer from/to = Accounts Payable"
The Question:How do I filter a Transaction Report on Checking to only show 
Accounts Payable transactions?
Thanks for any help!
___
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 Re: Transaction Report on Expenses, All Children, for 2021

[Fran_3 via gnucash-user]

 My Bad. Expenses are created when the bill is posted... not when it is 
paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor 
X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking 
Account and relive AP
So to get all expenses paid in 2021 you would create a Transaction Report on 
the Checking Account for the time period you desire...And set the Sorting 
Option Primary Key to "Other Account"And then lookup Accounts Payable Total in 
the results.
And if you know how you could set the Transaction Report Filter to only show 
Checking Transactions charged to Accounts Payable...I'm posting another thread 
on that... more properly titled... to help other poor souls... like me :-)






On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user 
 wrote:  
 
 Situation:
We posted a bill in 2020 but paid it in 2021.
I need to create an Expense report for all expenses paid in 2021... regardless 
of when the bill was posted...
My attempted solution:I created a Transaction Report on "Expenses" with "All 
Children"  selected...And with a date range of 1/1/2021 to 12/31/2021
The Problem:The payment for the 2020 bill does not show in the report...Even 
though the expense was paid in paid in 2021.
How can I create a report that will show all expenses paid in 2021 regardless 
of when the bill was posted?
Thanks for any help.





___
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] Question Re: Transaction Report on Expenses, All Children, for 2021

[Fran_3 via gnucash-user]

Situation:
We posted a bill in 2020 but paid it in 2021.
I need to create an Expense report for all expenses paid in 2021... regardless 
of when the bill was posted...
My attempted solution:I created a Transaction Report on "Expenses" with "All 
Children"  selected...And with a date range of 1/1/2021 to 12/31/2021
The Problem:The payment for the 2020 bill does not show in the report...Even 
though the expense was paid in paid in 2021.
How can I create a report that will show all expenses paid in 2021 regardless 
of when the bill was posted?
Thanks for any help.





___
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] Recurring Monthly bills, How to Auto Post... TFN ?

[Fran_3 via gnucash-user]

Like many we have a number of regular monthly bills.
Is there a way to have these bills "auto posted" each month?
And then have gnu cash add them to the reminders... say on the 1st of each 
month... or what ever appropriate date for the bill?
Now, in order to have the bill show up in reminders we are...
Manually creating 12 bills for each monthly account with an estimated "due" 
date and a simple 1-cent balance due.
Then when that date approaches the bill shows up in the reminders and we open 
it, un-post it, change the amount due, and repost it again.
Thanks for any help on this.
PS - maybe this would be called an auto recurring bill... or whatever.
___
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] What is the current GnuCash version and...

[Fran_3 via gnucash-user]

 Thanks Glen & David. Our current version seems to be working OK so I guess we 
will wait till the next release subject to David's precautionary note.
Thanks again.

On Wednesday, May 12, 2021, 9:04:27 PM EDT, David Carlson 
 wrote:  
 
 Fran,
Since you are using Windows, the Windows installer will automatically remove 
the current version and install the new version.  

If you had done a non-standard installation that might not work smoothly, but 
it will leave your saved report settings, window sizes, etc. intact.  I believe 
there may be an issue with selecting accounts if you are building new 
transactions in that particular release - see "[Bug 798061] Quickfill for 
account splits on Windows: input freeze if more than 2 characters are typed" 
for info.  If that will affect you, you may want to wait for the next release 
before updating.
On Wed, May 12, 2021 at 7:51 PM Glenn Fowler  wrote:

Hi,

The current version is 4.5 which you can d/l here:
https://www.gnucash.org/download.phtml

You shouldn't have any issues upgrading from 4.1 to 4.5 since it's not a
major release change as detailed here:
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade

On Wed, May 12, 2021 at 8:04 PM Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Running Version: 4.1
> Build ID: 4.1+(2020-07-25)here on  Windows 10 system
> What is the latest version and can I just download it and install it or
> should I remove the old version first... or what proceedure?
> Thanks for any help.
> ___
> 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.



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

[GNC] What is the current GnuCash version and...

[Fran_3 via gnucash-user]

Running Version: 4.1
Build ID: 4.1+(2020-07-25)here on  Windows 10 system
What is the latest version and can I just download it and install it or should 
I remove the old version first... or what proceedure?
Thanks for any help.
___
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] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

 Matt, thanks for the reply.
Note that all withdrawals from Checking are not charged to Expense Accounts so 
that wouldn't pick up all withdrawals.
I can export the checking range I want to work on and do all this in a 
spreadsheet however so no worries.
Thanks


On Wednesday, May 12, 2021, 4:43:51 AM EDT, Maf. King  
wrote:  
 
 On Tuesday, 11 May 2021 13:41:04 BST Fran_3 via gnucash-user wrote:
> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.
> ___

Hi,

use the Filter... settings on the "accounts" tab of the report options.

so run the report on the Checking account, and then in the lower half of the 
accounts tab  Filter by say only Expense accounts.

HTH,
Maf.



  
___
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] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

 This almost worked for what I wanted but it gave me a double line for each 
transaction... 
line 1: the goes in account line 2: and the goes out account
As opposed to when I simply run a Transaction Report on Checking... I can get 
one line per transaction.
I can, of course, export the checking account and do this in a spreadshet... 
but I thought I could previously do it via a Transaction Report.
That said, I've been away from gnuCash for months... maybe a year... and just 
got called back to do some work... so I'm learning all over again.
I do appreciate the help folks. Thanks!



On Tuesday, May 11, 2021, 10:44:24 PM EDT, Geoff  
wrote:  
 
 Hi Fran

Since it is only for a single account, here is a slightly long winded 
way to do it:

1. Open the Account
2. Do a Find specifying Debit (or Credit) values only
3. Run the Account Report on the search results.

See attached screenshot.

Hope this helps.

Regards

Geoff
=

On 12/05/2021 9:22 am, Fran_3 via gnucash-user wrote:
>  What are txns? Transactions?
> I sorted the Transaction Report by "amount" but I don't know how to limit the 
> output to values greater than zero... or to values less than zero.
> Do I do that on the Filter tab? And if so how?
> If its Regular Expressions my eyes just rolled back in my head :-)
> Thanks for  the help.
> 
> 
>      On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone 
> wrote:
>  
>  On 11 May 2021 at 12:41, Fran_3 said:
> 
>> How can I create a Transaction Report on the Checking AccountAnd show only
>> Debits?Or show only Credits? Thanks for any help.
> 
> Start by selecting only the relevant txns, perhaps?
> e.g. Value has debits greater than 0.00
> 
> 
> 
> ___
> 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] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

 What are txns? Transactions?
I sorted the Transaction Report by "amount" but I don't know how to limit the 
output to values greater than zero... or to values less than zero.
Do I do that on the Filter tab? And if so how?
If its Regular Expressions my eyes just rolled back in my head :-)
Thanks for  the help.


On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone 
 wrote:  
 
 On 11 May 2021 at 12:41, Fran_3 said:

> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.

Start by selecting only the relevant txns, perhaps?
e.g. Value has debits greater than 0.00



___
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] Need Transaction Report on Checking to show only Debits

[Fran_3 via gnucash-user]

How can I create a Transaction Report on the Checking AccountAnd show only 
Debits?Or show only Credits?
Thanks for any help.
___
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 use Reminders?

[Fran_3 via gnucash-user]

 Please, wake up and smell the real world small business day old burnt coffee 
at the end of a 12 hour day when you are trying to do the bookkeeping and still 
get home for a few hours sleep before it all starts over again...
Look... if you are working the front desk, or the floor, and trying to do other 
small business duties, doing the books, and trying to keep up with bills from a 
large quantity of vendors...- And some vendors don't actually send you a bill, 
they just expect you to know they want their payment by the 10th of the month 
or whatever...- While other vendors send bills via snail mail...- And other 
vendors email bills- And now some small vendors are even (exclusively) using 
Social Media Private Messenger instead of email to send bills...
- So bills are coming in from every direction...Some times it gets very hard to 
keep up with the mail, email, etc...Results... things fall through the cracks 
no matter how hard you work.
So now you are telling me to keep up with multiple calendars ! Yet another job 
piled on the head of some poor owner or employee working at a conically 
understaffed, hanging on for dear life, small business !!!
Forget the damn boss's birthday and Valentines day... the main issue here is 
having specific reminders to remember to go find and post every bill that came 
in from who knows where.
If it were that easy to "just post the bills" the OP would have never been 
created.
Sorry for the rant, we love GC... but creating/modifying the code for a simple 
general purpose reminder ain't that big of a job.
My guess here is this is about setting design boundaries to minimize project 
creep... got it... but this one is so close to the line that I dare 
characterize it as a reasonable "suggestion"...
There is probably a way to use the current reminder feature to "fake it" just 
to get an "in your face" reminder to  do whatever. I'll post back  if  I come 
up with such.




On Wednesday, December 9, 2020, 1:50:45 PM EST, Derek Atkins 
 wrote:  
 
 Hi,

Before I respond inline below, I just want to point out that GnuCash is
not a calendaring system.  If you want to remember things like your Boss'
birthday or Valentine's day, there are much better tools (like your
calendar!) to do that.  So use those tools for those kinds of reminders.

Having said that

On Wed, December 9, 2020 1:10 pm, Fran_3 via gnucash-user wrote:
> Problem with "Bills Due" reminder popup is if you have forgotten to Post
> the bill you don't get reminded.

Why do you not post the bill as soon as you get it?  I mean, if you take
the time to enter in your bill into the system, why not post it
immediately?  It's not like the bill is going to change over time, or be
ammended.  So in the immortal words of "Doctor, it hurts when I do
this"...  "Don't Do That."

Post your bill when you enter it.  That's what the reminders are for, to
pay the bill that you entered AND POSTED.

>      Problem with missing your boss's birthday
> is you forgot what date it was.

This is not a GnuCash problem; use your calendar for that.  There are many
options, like Orange and Evolution, which will do a MUCH better job.

> So, how do you create a general purpose Reminders for various things in
> GnuCash like..- Post Electric Bill Today (this reminds you to go find the
> bill online or in the mail or wherever & post it)
> - Boss's birthday is on April 1st- Valentines Day coming up on February
> 14th- Leave check under door mat for yard guy

None of these reminders belong in GnuCash.

> I see the calendar view via clicking... Actions > Schedule > Edit
> Scheduled Transactions
> And the tabs & fields when I click "New"
> And most of the fields are obvious except under Template Transaction...
> I'm clueless about what I'm looking at...Is tat a template for...- a new
> bill to be posted- a reminder to pay a bill- or what?

The Template Transaction is the transaction you have scheduled.  The
template will be executed and posted into your accounts when the SX fires.
 The template can be anything (well, any transaction -- you cannot
schedule a Business feature object like Invoice or Bill).  I, personally,
use them to schedule Loan (and Mortgage) payments, because it can
approximate interest calculations.

> And, what about a reminder that is not a financial transaction?
> Questions:
> 1 - Is there a way to create General Purpose Reminders in GnuCash?

No.

> 2 - Where can I find instructions on how to navigate to General Purpose
> Reminders?

Read up on Evolution (the program, not the Theory of).

> 3 - Is there a document that explains the use of the various fields in
> either...
> a. the General Purpose Reminder or in
>
> b. Scheduled Transactions Reminders?

There should be documentation the SX Editor, yes.  Check the Help file.

Oh, one more thing -- keep in min

[GNC] How to use Reminders?

[Fran_3 via gnucash-user]

Problem with "Bills Due" reminder popup is if you have forgotten to Post the 
bill you don't get reminded.Problem with missing your boss's birthday is you 
forgot what date it was.
So, how do you create a general purpose Reminders for various things in GnuCash 
like..- Post Electric Bill Today (this reminds you to go find the bill online 
or in the mail or wherever & post it)
- Boss's birthday is on April 1st- Valentines Day coming up on February 14th- 
Leave check under door mat for yard guy
I see the calendar view via clicking... Actions > Schedule > Edit Scheduled 
Transactions
And the tabs & fields when I click "New"
And most of the fields are obvious except under Template Transaction... I'm 
clueless about what I'm looking at...Is tat a template for...- a new bill to be 
posted- a reminder to pay a bill- or what?
And, what about a reminder that is not a financial transaction?
Questions:
1 - Is there a way to create General Purpose Reminders in GnuCash?
2 - Where can I find instructions on how to navigate to General Purpose 
Reminders?

3 - Is there a document that explains the use of the various fields in either...
a. the General Purpose Reminder or in 

b. Scheduled Transactions Reminders?
Thanks for any help.



___
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] Fwd: Need help using Gnucash IRC to live chat

[Fran_3 via gnucash-user]

 Well, I think I finally got to the GnuCash IRC channel using the HexChat IRC 
client... da da ! :-)


On Saturday, December 5, 2020, 6:59:39 PM EST, Derek Atkins 
 wrote:  
 
 HI,

On Sat, December 5, 2020 6:51 pm, Fran_3 via gnucash-user wrote:
>  1 - How do you browse there in Firefox? Does it have a built in IRC
> client?2 - I've installed HexChat and got on the FreeNode server but no
> gnucash channel there...
> When I attempt to join #gnucash I get this prompt...
> "The #gnucash irc channel is #gnucash on irc.gnome.org... please join us
> all there!"

this implies you joined a different IRC network -- probably freenode.
You need to join GIMPnet.

> 3 - Problem is I don't know how to navigate to irc.gnome.org... is that
> the name of an IRC chat server?

Yes.  AKA GIMPnet

> 4 - On mIRC they list "servers" and each server has channels...
> But on HexChat they list "Networks" which I assume is the same as
> "servers" in mIRC... right?

Generally, yes.

> I'll be darn'd if I know why I'm having such a hard time with this... but
> thanks for any help :-)

I used HexChat, and it says "GIMPnet / #gnucash"

-derek

>
>    On Saturday, December 5, 2020, 1:34:01 PM EST, David Carlson
>  wrote:
>
>  Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> -- Forwarded message -
> From: Fred 
> Date: Sat, Dec 5, 2020 at 11:48 AM
> Subject: Re: [GNC] Need help using Gnucash IRC to live chat
> To: David Carlson 
>
>
> I rarely do IRC, but when I do I just browse there in Firefox, which seems
> to give me a reasonable view into the channel.
>
> On Sat, Dec 5, 2020 at 12:06 PM David Carlson
> 
> wrote:
>
>> Derek is right.  Wiki IRC to find a list.
>>
>> On Sat, Dec 5, 2020, 10:45 AM Derek Atkins  wrote:
>>
>> > There are tons of free IRC clients.
>> > -derek
>> >
>> > On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
>> > > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 -
>> Are
>> > > their any free open source alternatives to mIRC?Thanks for any help.
>> > >
>> > > ___
>> > > 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.
>> >
>> ___
>> 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
> g

Re: [GNC] Fwd: Need help using Gnucash IRC to live chat

[Fran_3 via gnucash-user]

 1 - How do you browse there in Firefox? Does it have a built in IRC client?2 - 
I've installed HexChat and got on the FreeNode server but no gnucash channel 
there...
When I attempt to join #gnucash I get this prompt...
"The #gnucash irc channel is #gnucash on irc.gnome.org... please join us all 
there!"
3 - Problem is I don't know how to navigate to irc.gnome.org... is that the 
name of an IRC chat server?
4 - On mIRC they list "servers" and each server has channels...
But on HexChat they list "Networks" which I assume is the same as "servers" in 
mIRC... right?
I'll be darn'd if I know why I'm having such a hard time with this... but 
thanks for any help :-)



On Saturday, December 5, 2020, 1:34:01 PM EST, David Carlson 
 wrote:  
 
  Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-- Forwarded message -
From: Fred 
Date: Sat, Dec 5, 2020 at 11:48 AM
Subject: Re: [GNC] Need help using Gnucash IRC to live chat
To: David Carlson 


I rarely do IRC, but when I do I just browse there in Firefox, which seems
to give me a reasonable view into the channel.

On Sat, Dec 5, 2020 at 12:06 PM David Carlson 
wrote:

> Derek is right.  Wiki IRC to find a list.
>
> On Sat, Dec 5, 2020, 10:45 AM Derek Atkins  wrote:
>
> > There are tons of free IRC clients.
> > -derek
> >
> > On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
> > > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 -
> Are
> > > their any free open source alternatives to mIRC?Thanks for any help.
> > >
> > > ___
> > > 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.
> >
> ___
> 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.

[GNC] Need help using Gnucash IRC to live chat

[Fran_3 via gnucash-user]

1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are their 
any free open source alternatives to mIRC?Thanks for any help.

___
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] Looking for Point-of-Sale App suggestions & if any interface with GnuCash & How

[Fran_3 via gnucash-user]

1 - What Point of Sale Apps would you sugges for a small business?(Open Source 
is preferred.)
2 - Do any interface or transfer data easily with GnuCash?
3 - If so what info does the POS software share?.. daily sales.. sales by item 
with sales by quantity and total sales dollars and/or price of each item 
sold... or what?
4 - How does the POS software share data with GnuCash?.. export CSV file to be 
imported by GnuCash.. or what?
Thanks for any help.


___
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] Simultaneous Users? Cloud Access? Split FE & BE?

[Fran_3 via gnucash-user]

 Thanks Will. 

That is more or less what i was talking about when I talked about "splitting" a 
Microsoft Access database so the data was on one computer (the server) and the 
user interface with the Microsoft Jet database engine, custom queries, data 
entry forms, reports, etc was on another. 

Ditto for writing the html/php/java script code for storing and retrieving data 
from an online Microsoft or Linux host computer/server.
When this division of ~data and ~code occurrs properly you can have multiple 
users access and, with proper protections, manipulate the data at the same time.

Regarding GnuCash... I view it, more or less, as two parts...1 - the code to 
get, store, manipulate, retrieve, and present the users data to the user2 - the 
actual data itself... which I think is in XML.(There are other ways to see the 
GnuCash "parts" of course.)
With that "model" in mind I guess I was wondering if provisions had been for 
the data to be split off, stored on a server, and accessed by multiple users... 
each with their own "front end" (as I call it)
All that said, I guess I know enough to be dangerous :-)

As someone mentioned I should probably have read the FAQ's and other stuff 
before I posted this question.
On Monday, October 26, 2020, 1:06:59 AM EDT, w...@theprescotts.com 
 wrote:  
 
 Just to chime in on the terminology...

In my current job I do back-end development for an NGO. We have another 
developer who works on the front end and a couple people working on a mobile 
app.

The back end is an application that runs on an Amazon Web Service instance. The 
front end is a web app that users use to communicate with the back end. The 
data is stored in a data base that the back end talks to. The back end has an 
API (Application Programming Interface) and the front end and mobile app both 
make https calls to the back end to talk to it as well as using some other 
protocols.

I believe this structure is common and what most developers have in mind when 
they refer to a back end and a front end. Stand alone applications like Gnucash 
probably would not normally be considered to have a back end or front end.

Will

On 2020 Oct 25, at 10-25 21:11:11, Fran_3 via gnucash-user 
 wrote:

Thanks Jim. Regarding Front End and Back End... 

When I used to develop Microsoft Access databases I would split it such 
that...- All the data was stored on a local peer-to-peer server. We called that 
the "Back End"
- The "Front End" would have the user interface with the queries, data entry 
forms, reports, etc. And, if I remember correctly, this could actually be 
different for each user of the mdb database so some people had easy access to 
certain things... like data entry only, etc.
In recent times I've been developing online databases with MySQL and PHP. In 
this case the "front end" would be the queries, etc coded in PHP while 
everything else would live in a MySQL database on the web server.
At least that is the language I've used to describe things to myself.



  On Sunday, October 25, 2020, 4:37:26 PM EDT, Jim DeLaHunt 
 wrote:  

On 2020-10-25 08:29, Fran_3 via gnucash-user wrote:

> - I have always considered GnuCash as a program that must be installed on the 
> local machine.
> - With the myBiz.gnucash file also on the local machine.
> - This means that two users can not open GnuCash on their respective machines 
> and access the myBiz.gnucash data file at the same time...
> 1 - Right so far?
> 2 - Am I also correct in assuming that the gnucash.exe is essentially the 
> data base's front end while myBiz.gnucash is the back end containing all the 
> data?
> 3 - If so is there anyway to keep the back end with the data (myBiz.gnuCash) 
> in the cloud and point the frond end on your local machine (gnucash.exe) to 
> the data stored in the cloud... like maybe stored on MyDrive at Google or 
> where ever?
> Thanks for any help.

Fran:

There are Frequently Asked Questions (FAQs) about "Multiple Computers, 
Users, ..." 
<https://wiki.gnucash.org/wiki/FAQ#Multiple_Computers.2C_Users.2C_...>. 
You will find some answers there, especially to your questions 1 and 3.

Also, Stan Brown's Oct 12 answer 
<https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093577.html> 
to your question, "Re: [GNC] Will the file myStuff.gnucash work on Linux 
& Windows machines?" is relevant.

Regarding the terms "front end" and "back end", in software engineering 
they have specific meanings which don't line up with your question #2. 
In general, all of your bookkeeping information (transactions, balances, 
chart of accounts) is stored in your book file, myBiz.gnucash, and none 
is stored in the GnuCash.exe program. Some of the data you rely on when 
using GnuCash, such as your preferences, custom reports, etc., are in 
preferences files which are neither i

Re: [GNC] Simultaneous Users? Cloud Access? Split FE & BE?

[Fran_3 via gnucash-user]

 Thanks Jim. Regarding Front End and Back End... 

When I used to develop Microsoft Access databases I would split it such 
that...- All the data was stored on a local peer-to-peer server. We called that 
the "Back End"
- The "Front End" would have the user interface with the queries, data entry 
forms, reports, etc. And, if I remember correctly, this could actually be 
different for each user of the mdb database so some people had easy access to 
certain things... like data entry only, etc.
In recent times I've been developing online databases with MySQL and PHP. In 
this case the "front end" would be the queries, etc coded in PHP while 
everything else would live in a MySQL database on the web server.
At least that is the language I've used to describe things to myself.



On Sunday, October 25, 2020, 4:37:26 PM EDT, Jim DeLaHunt 
 wrote:  
 
 On 2020-10-25 08:29, Fran_3 via gnucash-user wrote:

> - I have always considered GnuCash as a program that must be installed on the 
> local machine.
> - With the myBiz.gnucash file also on the local machine.
> - This means that two users can not open GnuCash on their respective machines 
> and access the myBiz.gnucash data file at the same time...
> 1 - Right so far?
> 2 - Am I also correct in assuming that the gnucash.exe is essentially the 
> data base's front end while myBiz.gnucash is the back end containing all the 
> data?
> 3 - If so is there anyway to keep the back end with the data (myBiz.gnuCash) 
> in the cloud and point the frond end on your local machine (gnucash.exe) to 
> the data stored in the cloud... like maybe stored on MyDrive at Google or 
> where ever?
> Thanks for any help.

Fran:

There are Frequently Asked Questions (FAQs) about "Multiple Computers, 
Users, ..." 
<https://wiki.gnucash.org/wiki/FAQ#Multiple_Computers.2C_Users.2C_...>. 
You will find some answers there, especially to your questions 1 and 3.

Also, Stan Brown's Oct 12 answer 
<https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093577.html> 
to your question, "Re: [GNC] Will the file myStuff.gnucash work on Linux 
& Windows machines?" is relevant.

Regarding the terms "front end" and "back end", in software engineering 
they have specific meanings which don't line up with your question #2. 
In general, all of your bookkeeping information (transactions, balances, 
chart of accounts) is stored in your book file, myBiz.gnucash, and none 
is stored in the GnuCash.exe program. Some of the data you rely on when 
using GnuCash, such as your preferences, custom reports, etc., are in 
preferences files which are neither in your book file nor in the 
GnuCash.exe program. The "multiple computers" FAQ linked to above talks 
about this a little.

Best regards,
   —Jim DeLaHunt, Vancouver, Canada


___
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] Simultaneous Users? Cloud Access? Split FE & BE?

[Fran_3 via gnucash-user]

- I have always considered GnuCash as a program that must be installed on the 
local machine.
- With the myBiz.gnucash file also on the local machine.
- This means that two users can not open GnuCash on their respective machines 
and access the myBiz.gnucash data file at the same time...
1 - Right so far?
2 - Am I also correct in assuming that the gnucash.exe is essentially the data 
base's front end while myBiz.gnucash is the back end containing all the data?
3 - If so is there anyway to keep the back end with the data (myBiz.gnuCash) in 
the cloud and point the frond end on your local machine (gnucash.exe) to the 
data stored in the cloud... like maybe stored on MyDrive at Google or where 
ever?
Thanks for any help.





___
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] how to set Bills Due Reminder Date Range?

[Fran_3 via gnucash-user]

How do you change the Bills Due Reminder date range?
In particular how to set it to show any bill due in the next "x"days.
I poked around in preferences but couldn't seem to crack the code.
Running GnuCash 4.1 on Win10.
Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Make PDF from reports

[Fran_3 via gnucash-user]

 It looks to me like a printer problem and not a GnuCash problem.
If you are on a Windows PC open Notepad and see if you can print a  test 
document from there.If you are on Linux open your text editor and to the same 
thing.Ditto for other's like Apple... I guess.
Alternately make sure you have the correct printer selected when you try to 
print from GnuCash.
Try opening one of the built in reports and printing it.
If none of the above works maybe someone else here on the list can pitch in.


On Tuesday, October 20, 2020, 12:56:19 AM EDT, Derek Zehr 
 wrote:  
 
 Hello,

 

I just created my first-ever report in GnuCash, to report some finances with
a forum I'm involved with. This is the window I get when I hit Make PDF, and
specify a valid file name in my documents folder. GnuCash Version: 4.1 Build
ID: 4.1+(2020-07-25) on Windows 7.

 

Hope it something simple. Not sure what to do to resolve something like
this.

 

Thanks,

 

Derek Zehr

 



 

 

___
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] Best way to Auto Sync GC Checking Transactions with the Bank?

[Fran_3 via gnucash-user]

nually
> outside of GnuCash when GnuCash has built-in methods of helping you find
> those duplicates?"
>
> If you still really need to do a comparison outside the matcher, yes,
> there are ways to script it, to a point. But I caution that approach
> because it will be a bit of work to set up and my suspicion is you'll
> find most of that effort will be duplicating what GnuCash is already
> capable of.
>
> Regards,
> Adrien
>
> On 10/16/20 9:45 AM, Fran_3 via gnucash-user wrote:
> > Given a checking account with a number incidental and auto pay
> transactions ocuring daily...
> > Is there a way to automate...- logging on to the bank daily- determining
> which transactions have hit the bank but are not posted in GnuCash- then
> updating GnuCash with those unrecorded transactions?
> > Doing this manually when the account has a number of incidential and
> auto pay transactions occurring daily is a lot of work.It is also prone for
> error as the transaction date and description at the bank do not always
> match how they are entered in GnuCash.
> > Manually we have been daily downloading CSV files, and comparing them in
> spreadsheets...or screen capturing the latest bank transactions and the
> latest GC transactions, pasting them into PC Paint, and then doing the
> compare.or printing them out on paper to do the compare.
> > In summary...1 - How can we automate this daily task?2 - If there is a
> way... does GC use the description field and amount field to "match"
> transactions?3 - or what?
> > Thanks for any help.
>
> ___
> 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] Best way to Auto Sync GC Checking Transactions with the Bank?

[Fran_3 via gnucash-user]

 Adrien,
Yes, in the old days before debit cards and auto-pay we did a reconciliation 
once a month... when the paper bank statement showed up in the mail box. In 
those days if we didn't write a check then no bank transaction should appear... 
other than bank charges. Much simpler times :-)
Now days there are often several incidental debit card charges plus a number of 
auto-pay charges that hit the bank.
We check the bank transactions daily to make sure we didn't miss recording any 
of these.

The reason for my post was to get some guidance on using the GnuCash built in 
tools to help find duplicate transactions.
The problem to us... as you mentioned is...
- Our Check Register Description Field doesn't match the banks- The Transaction 
Dates are often not the same
Regarding doing the bank transactions to recorded GC transactions comparison 
manually...I wrote an App Script for Google Sheets that helps with that... but 
it is still a lot of work... thus my question on using GnuCash tools to help.
I see David has also responded to this post so I'll read his comments then 
probably make a test copy of the GnuCash file and do some experimentation.
That said... for one particular entity with a lot of auto-pays and incidental 
debit card transactions... I still don't see any option but to check the bank 
daily to check what hit the bank and verify their entry into GnuCasy.
How do you handle a loose cannon with a debit card?How do you handle capturing 
transactions from a vendor that generates a lot of individual auto pay and/or 
auto deposit charges each month?
Thanks for the help.






On Saturday, October 17, 2020, 7:58:34 PM EDT, Adrien Monteleone 
 wrote:  
 
 The Help/Guide and probably the wiki (as well as various threads in this 
list) will provide more insight into how the Import Matcher works, along 
with tips and tricks to use it most effectively.

My first question would be, "What is the reason for doing this daily? 
What advantage over larger periods does this level of effort give you?"

I ask, because my first recommendation would be to do so less 
frequently, maybe even weekly at the most, but monthly would be a most 
likely target. What you appear to be doing is essentially reconciliation 
and that is traditionally (though it doesn't have to be) a monthly 
procedure.

I don't download bank transactions or use the import matcher myself, but 
after reading many, many threads here on the various nuances, I'd think 
the matcher *should* recognize 'amount', 'date', and 'description' and 
flag those qualifying transactions as potential duplicates. You get to 
decide before completing the import if they really are duplicates. If 
you leave them marked as such, if I recall correctly, GnuCash will 
change the flag in the "r" column from 'n' to 'c'—meaning the 
transaction has cleared the bank. When you do a formal reconciliation of 
the account with a periodic bank statement, those marked 'c' will be 
pre-checked for you. You would only need to verify and check off the 
remaining transactions in the reconcile window.

The date that your bank shows for the transaction may not be the same 
date as the real-world transaction. (the real date *should* be what you 
have entered in GnuCash) I think the matcher is smart enough to flag 
those for a closer look if the other key data matches.

For transactions that don't qualify as true duplicates (thus needing to 
just be 'cleared') they will be imported as new with the 'c' flag 
already set.

My second question is, "Why are you doing the comparison manually 
outside of GnuCash when GnuCash has built-in methods of helping you find 
those duplicates?"

If you still really need to do a comparison outside the matcher, yes, 
there are ways to script it, to a point. But I caution that approach 
because it will be a bit of work to set up and my suspicion is you'll 
find most of that effort will be duplicating what GnuCash is already 
capable of.

Regards,
Adrien

On 10/16/20 9:45 AM, Fran_3 via gnucash-user wrote:
> Given a checking account with a number incidental and auto pay transactions 
> ocuring daily...
> Is there a way to automate...- logging on to the bank daily- determining 
> which transactions have hit the bank but are not posted in GnuCash- then 
> updating GnuCash with those unrecorded transactions?
> Doing this manually when the account has a number of incidential and auto pay 
> transactions occurring daily is a lot of work.It is also prone for error as 
> the transaction date and description at the bank do not always match how they 
> are entered in GnuCash.
> Manually we have been daily downloading CSV files, and comparing them in 
> spreadsheets...or screen capturing the latest bank transactions and the 
> latest GC transactions, pasting them into PC Paint, and then doing the 
> compare.or printing them out on paper to do the compare.
> In summary...1 - How can we automate

Re: [GNC] transaction report missing subtotals

[Fran_3 via gnucash-user]

 I see the problem. After some experimentation I failed to discover a solution. 
Hopefully someone else here can chip in.

On Saturday, October 17, 2020, 3:57:15 AM EDT, Gal  
wrote:  
 
 GnuCash - User mailing list wrote
> .. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal
> Date Key)

When the primary key is the date, the primary subtotal are displayed.
The issue arises when the date is chosen as the secondary key, in which case
"secondary subtotal" checkbox can't be checked, and accordingly, no monthly
subtotals are displayed in the table.

Why are date subtotals limited to appear only when the date is the primary
key?



--
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] transaction report missing subtotals

[Fran_3 via gnucash-user]

 I missed the OP but saw a followup on this question. Here is my attempt to 
explain Transaction Reports Monthly Totals.
I'm running Windows 10 and GnuCash Version 4.1 and getting Transaction Reports 
Monthly Totals seems to work perfectly here.
My Process:
- Click Reports
- Click Transaction Reports
- Click Edit Report Options
.. On General Tab - set date range
.. On Accounts Tab - select Assets > Current Assets > Checking (or whatever 
accout you choose)
.. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal Date 
Key)
.. On Sorting Tab - set Primary Subtotal for Date Key to "Monthly" (thats the 
default on my Win 10 GnuCash)
.. On Sorting Tab - Make sure Primary Subtotal is checked
.. Click Apply or OK

and KaBoom - there you go

PS - You can also use the Filter Tab to... for instance... only show 
transactions with a key word in the Descriptio Memo or Note Fields...
BUT... this is tricky so make sure your case matches as the Filter uses Regular 
Expressions...
or if you know Regular Expressions you can match any way you like.

Hope this helps.









On Friday, October 16, 2020, 5:43:28 PM EDT, Gal  wrote: 
 
 
 Christopher Lam wrote
> Can you attach a screenshot of the problem?
> 
> Use MSPaint or something to hide any sensitive data. Also switch on
> "General / Add options summary" to "Always" to show us which options were
> set.

Having the same issue. can't get monthly sub totals.
Here's a screenshot:
 



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

[GNC] Best way to Auto Sync GC Checking Transactions with the Bank?

[Fran_3 via gnucash-user]

Given a checking account with a number incidental and auto pay transactions 
ocuring daily...
Is there a way to automate...- logging on to the bank daily- determining which 
transactions have hit the bank but are not posted in GnuCash- then updating 
GnuCash with those unrecorded transactions?
Doing this manually when the account has a number of incidential and auto pay 
transactions occurring daily is a lot of work.It is also prone for error as the 
transaction date and description at the bank do not always match how they are 
entered in GnuCash.
Manually we have been daily downloading CSV files, and comparing them in 
spreadsheets...or screen capturing the latest bank transactions and the latest 
GC transactions, pasting them into PC Paint, and then doing the compare.or 
printing them out on paper to do the compare.
In summary...1 - How can we automate this daily task?2 - If there is a way... 
does GC use the description field and amount field to "match" transactions?3 - 
or what?
Thanks for any help.





___
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] Will the file myStuff.gnucash work on Linux & Windows machines?

[Fran_3 via gnucash-user]

 David, you may have just solved one of our problems. 

Google Drive doesn't offer a sync feature for Linux, as far as I can find.
1 - I'm assuming you sync between your Dropbox account and yourlocal Linux or 
Windows PC... right?
2 - Does FreeFileSync auto sync to each computer or do you have to manually run 
it?
3 - Does it only work with Dropbox?
Thanks !!!



On Sunday, October 11, 2020, 8:24:06 PM EDT, David H  
wrote:  
 
 Fran,
I should perhaps add I'm assuming you save the file in the default xml format 
:-)  I'm also using Dropbox and FreeFileSync to sync the file on whatever pc I 
happen to be in front off at the time
Cheers David H.

On Mon, 12 Oct 2020 at 10:10, David H  wrote:

I have been using the same Gnucash file on Win 7, Win 10, Ubuntu Linux & MacOS 
Big Sur without issue so yes.
Cheers David H

On Mon, 12 Oct 2020 at 10:04 am, Fran_3 via gnucash-user 
 wrote:

Given a GnuCash file myStuff.gnucash...
Can that file be shared and worked on on both a Windows 10 machine and a Linux 
Mint 20.0 Cinnamon machine?
Or does GnuCash save the two files differently for Windows 10 and Linux Mint?
(In our case the .gnucash file lives in the cloud so either computer can 
download it, work on it, and then re-upload it when done.)
Thanks for any help.

___
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] Will the file myStuff.gnucash work on Linux & Windows machines?

[Fran_3 via gnucash-user]

Given a GnuCash file myStuff.gnucash...
Can that file be shared and worked on on both a Windows 10 machine and a Linux 
Mint 20.0 Cinnamon machine?
Or does GnuCash save the two files differently for Windows 10 and Linux Mint?
(In our case the .gnucash file lives in the cloud so either computer can 
download it, work on it, and then re-upload it when done.)
Thanks for any help.

___
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] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

[Fran_3 via gnucash-user]

 So Greg, you don't post any Bills to Accounts Payable? Electric & Utility 
bills. Rent or whatever?
You just post the payments... is that what you are saying?
Thanks

On Friday, October 9, 2020, 12:15:25 PM EDT, Greg Feneis 
 wrote:  
 
 I don't use this process at all. Everything my business buys how on a
credit card. 路

Kind regards, Greg Feneis
(Pixel 3)


On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user 
wrote:

> Posting Bills allows you to keep track of AP and provides data to the
> Bills Due Reminder...
> However some routine expenses may just get paid without going through the
> steps of creating and posting and paying a bill.
> For a small venture posting bills can require a lot of keyboard time...
> even duplicating a bill requires a number of steps, data entry, and clicks
> and can eat up time if you have a bunch of them to do...
> Example, we have a couple of vendor from which we get 50+ to 100+ charges
> per year. They each are on auto pay and are mostly for the same amount per
> charge... but each charge is for a different thing... so descriptions, due
> dates, etc are different for each item.
> (You can think of these as if they were an annual listing or service
> fee... one for each item.)
> I got reminded of this recently when we made an effort to enter/create
> Bills for the 100+ charges that were going to occur for Vendor-A over the
> next 12 months... again, the big corporate vendor does not supply a monthly
> Bill listing all charges for that month... the item fee comes up and gets
> auto paid... so 100+ transactions per year for that one vendor.
>
> It is a lot less work to just enter each payment into the system as
> opposed to first creating a bill then posting a bill and then paying the
> bill.
> How do you all choose which things to create Bills for and which things
> just Pay?
> Thanks.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Fran_3 via gnucash-user]

 In this case the PC"s are running the latest GnuCash download version for 
Windows.

I haven't explored the "App" yet. I assume you are talking about an app to run 
on a smart phone... right?
Regardless, I want to learn more about the  App but I think that will be 
another thread down the road.
Thanks.

On Friday, October 9, 2020, 1:04:23 PM EDT, John Ralls  
wrote:  
 
 

> On Oct 9, 2020, at 4:09 AM, Manfred Usselmann  wrote:
> 
> Under MacOS X the following directory is used: 
> ~/Library/Preferences/gnucash.plist.

That depends on how you get GnuCash. If it's Gnucash.app then the preferences 
file is ~/Library/Preferences/org.gnucash.Gnucash.plist. gnucash.plist will be 
used if you've installed GnuCash from MacPorts or built it yourself.

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.

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

[Fran_3 via gnucash-user]

Posting Bills allows you to keep track of AP and provides data to the Bills Due 
Reminder...
However some routine expenses may just get paid without going through the steps 
of creating and posting and paying a bill.
For a small venture posting bills can require a lot of keyboard time... even 
duplicating a bill requires a number of steps, data entry, and clicks and can 
eat up time if you have a bunch of them to do...
Example, we have a couple of vendor from which we get 50+ to 100+ charges per 
year. They each are on auto pay and are mostly for the same amount per 
charge... but each charge is for a different thing... so descriptions, due 
dates, etc are different for each item.
(You can think of these as if they were an annual listing or service fee... one 
for each item.)
I got reminded of this recently when we made an effort to enter/create Bills 
for the 100+ charges that were going to occur for Vendor-A over the next 12 
months... again, the big corporate vendor does not supply a monthly Bill 
listing all charges for that month... the item fee comes up and gets auto 
paid... so 100+ transactions per year for that one vendor.

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



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

[GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Fran_3 via gnucash-user]

The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash is installed 
on both pcX and pcY at locations X and Y.
Google Drive is sync'd on both pcX and on pcY...So the entityA.gnucash file is 
available locally on both computers hard drive.

This way  work can be done from either location.
The Issue:When a custom Transaction Report is created on pcX and saved...It 
does not get sync'd up to the cloud so it is not available if GnuCash is used 
with pcY from location Y.
The questions:1 - Are the custom Transaction Reports saved as a special file... 
or set of files in some local folder?2 - If so can that folder be changed such 
that the custom Transaction Reports can be sync'd to the Google Drive and 
ultimately be available to both pc's?3 - If not  are what alternate solutions 
exist?
Thanks for any help.

___
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 have Transaction Report show Debit Totals (&/or Credit Totals) ?

[Fran_3 via gnucash-user]

 I check that out. I can set the date range via Filter ByBut I can't see how to 
make any other adjustments to what the report returns...
One example is if you wanted to see 2019 Checking Deposits from customers...or 
2019 Payments to vendorsOr relative to a particular vendor or customer or 
income or expense account
I will keep the Register Report in my bag of tricks however so thanks!


On Friday, September 25, 2020, 2:51:15 PM EDT, Derek Atkins 
 wrote:  
 
 Hi,

On Fri, September 25, 2020 2:40 pm, Fran_3 via gnucash-user wrote:
> Is there anyway to have a Transaction Report show the total of the Debits
> column... or the Credits column... or both?
> (I thought sure I had done this before but today I stared and stared at
> the Transaction Report Tabs and didn't see it.)
> Thanks for any help.

If you start with the register you want summed, you can run Report ->
Account Report and it will sum it up for you.  Not the same as a
transaction report, because you need to configure everything from the
register before you run the report.

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

[GNC] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

[Fran_3 via gnucash-user]

Is there anyway to have a Transaction Report show the total of the Debits 
column... or the Credits column... or both?
(I thought sure I had done this before but today I stared and stared at the 
Transaction Report Tabs and didn't see it.)
Thanks for any help.

___
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] Transaction Report Filter for keyword in Description ?

[Fran_3 via gnucash-user]

 I think the implied meaning of "Account" got me confused...
Transaction Report - Accounts Tab:I selected the "Account" via the Accounts Tab 
to be...
"Assets > Current Assets > Checking Account"

Transaction Report - Filter Tab - Account Name Filter field:
Is the "Account Name Filter" field expecting the name of an Expense Account... 
or Income Account... that the Checking transaction was charged to?
Transaction Report: - Filter Tab - Transaction Filter field:Regular 
Expressions... Rats!Rant...I can, more or less, program in a number of 
languages... Assembly Language, Basic, Visual Basic, Visual Basic for 
Applications, HTML, Java Script, PHP, Active Server Pages, SQL... plus on rare 
occasions Python, C, & C++ and a few more more...But, that said, I will do 
almost anything to avoid Regular Expressions.Can I do it... sure if I take the 
day off to refresh myself and then hack, hack, hack, and groan, groan, 
groan.Rant finished.Sorry. Not Sorry.
In this case my Keyword string may have any case letters, anywhere in it... and 
it may have a punctuation mark before or after it... like...WebsiTenAme.cOm
Anyway, thanks for the help John... I was moving so fast to get done that I 
skipped right over the obvious... Too. Tips.



On Monday, September 21, 2020, 12:43:05 PM EDT, John Ralls 
 wrote:  
 
 

> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> How can I create a Transaction Report for the Check Register...
> set to only display transactions where a keyword appears in the Description 
> field?
> I'm confused by the "Account Name" Filter and the "Transaction Filter" 
> fields...
> 
> Thanks for any help.

Even after reading the tooltips? (Hover your pointer over each field.)

Summarizing them, use the Accounts filter to select from which accounts to 
select the transactions and the transactions filter to select which 
transactions based on the entered string or regular expression [1] matching the 
transaction description or notes, or a split memo.

Regards,
John Ralls

[1] https://en.wikipedia.org/wiki/Regular_expression  
___
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] Transaction Report Filter for keyword in Description ?

[Fran_3 via gnucash-user]

How can I create a Transaction Report for the Check Register...
set to only display transactions where a keyword appears in the Description 
field?
I'm confused by the "Account Name" Filter and the "Transaction Filter" fields...

Thanks for any help.

___
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 upgrade from 3.8 to 4.1 on Win10?

[Fran_3 via gnucash-user]

 Did you remove 3.8 first or did the 4.1 upgrade see that you were running 3.8 
and automatically do everything?Or can you have two simultaneous 
versions?Thanks for the help.

On Thursday, September 17, 2020, 7:26:31 PM EDT, Geoff 
 wrote:  
 
 Hi Fran

I recently upgraded from 3.6 to 4.1 on Windows 10 without any issues.

In the event of any problems, you can always revert to 3.8 as long as 
you have a clean backup of your data.

Good luck.

Geoff
=

On 18/09/2020 7:36 am, Fran_3 via gnucash-user wrote:
> Just now getting around to upgrading 3.4 to 4.1 on Win10.
> 1 - I've downloaded 4.1. Do I just run it or first uninstall 3.8?
> 2 - Also I see in the archives someone tried to upgrade from ver 2.x to ver 
> 4...
> and the following comment (amoung others)...
> " Skipping versions (such as2.5 ---> 4.0 is not supported"
> Does this apply to going from 3.8 to 4.1?
> 3 - any other steps that should be performed to have things go smoothly?
> I'm sure this is somewhere online or in the archives or Wiki but, after 
> digging around for awhile, I just haven't stumbled across it so thanks in 
> advance for any help.
> 
> ___
> 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] How to upgrade from 3.8 to 4.1 on Win10?

[Fran_3 via gnucash-user]

Just now getting around to upgrading 3.4 to 4.1 on Win10.
1 - I've downloaded 4.1. Do I just run it or first uninstall 3.8?
2 - Also I see in the archives someone tried to upgrade from ver 2.x to ver 
4... 
and the following comment (amoung others)...
" Skipping versions (such as2.5 ---> 4.0 is not supported"
Does this apply to going from 3.8 to 4.1?
3 - any other steps that should be performed to have things go smoothly?
I'm sure this is somewhere online or in the archives or Wiki but, after digging 
around for awhile, I just haven't stumbled across it so thanks in advance for 
any help.

___
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] Need to - Mark Split as Un-reconciled - in GC 3.8

[Fran_3 via gnucash-user]

 Thanks Chris. 

Question - Do I have to remove GC 3.8 before installing 4.1 or what? (On 
Windows 10(
Thanks for the help.
FYI - I searched... site:lists.gnucash.org upgrade to 4.1
for help on this before posting. I'm sure the question has been asked before 
but I guess I didn't see it in the search results.




On Wednesday, September 16, 2020, 9:18:25 PM EDT, Christopher Lam 
 wrote:  
 
 This freezing of reconciled splits was removed in a later release: you will be 
able to modify the textual fields without necessarily resetting reconcile 
status.
In the old release, if you unreconcile then you can simply reconcile again (but 
you can't reconcile using old statement date, must be recent).
On Thu, 17 Sep 2020, 8:08 am Fran_3 via gnucash-user, 
 wrote:

Under Liabilities I have an account named "Reimbursable"
I want to change the Description field of each Transaction to make have them 
more uniform...
However a few of the transactions... in the "R" column have one line/split set 
to... "n" for "not reconciled" and the other line/split set to "r" for 
"reconciled" 

So GC warns me when I attempt to modify the Description of that Transaction 
that I may break things as doing such will "un-reconcile" the split.
What are the risk of just going ahead and changing the Transactions Description 
and ignoring the warning?
Any other way to do this?
Thanks for any help.

___
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] Need to - Mark Split as Un-reconciled - in GC 3.8 - Correction

[Fran_3 via gnucash-user]

 The below should read "y" for "reconciled and not "r"
On Wednesday, September 16, 2020, 8:06:32 PM EDT, Fran_3 via gnucash-user 
 wrote:  
 
 Under Liabilities I have an account named "Reimbursable"
I want to change the Description field of each Transaction to make have them 
more uniform...
However a few of the transactions... in the "R" column have one line/split set 
to... "n" for "not reconciled" and the other line/split set to "r" for 
"reconciled" 

So GC warns me when I attempt to modify the Description of that Transaction 
that I may break things as doing such will "un-reconcile" the split.
What are the risk of just going ahead and changing the Transactions Description 
and ignoring the warning?
Any other way to do this?
Thanks for any help.

___
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] Need to - Mark Split as Un-reconciled - in GC 3.8

[Fran_3 via gnucash-user]

Under Liabilities I have an account named "Reimbursable"
I want to change the Description field of each Transaction to make have them 
more uniform...
However a few of the transactions... in the "R" column have one line/split set 
to... "n" for "not reconciled" and the other line/split set to "r" for 
"reconciled" 

So GC warns me when I attempt to modify the Description of that Transaction 
that I may break things as doing such will "un-reconcile" the split.
What are the risk of just going ahead and changing the Transactions Description 
and ignoring the warning?
Any other way to do this?
Thanks for any help.

___
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] Importing Liability Transactions to AP/Bills

[Fran_3 via gnucash-user]

 FYI, this has been solved. Thanks.

On Monday, September 14, 2020, 7:20:55 PM EDT, Fran_3 via gnucash-user 
 wrote:  
 
  David, That worked great. thanks!
Next question... anyway to import payments?
And, actually, instead of Assets: Checking making the payments...I want the 
payments to come from...Liabilities: Reimbursements To/From Entity B

Because Entity B paid a bunch of Bills for Entity A...So Entity A wants to show 
the Bills Paid and record a debt to Entity B for those payments.
Note: Such transactions occur on occasion between both Entities thus the 
name...Reimbursements To/From Entity B

Thanks again for the help.
    On Monday, September 14, 2020, 5:17:20 PM EDT, david whiting 
 wrote:  
 
 Hi Fran,

I import lots of bills and use File -> Import -> Import bills and
Invoices (not transactions). See this help page for details:
https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html
For my purposes I found it useful to create a spreadsheet for entering
details that has a structure that makes sense and then a second sheet
that I named "Export to csv" that has formula that take the values
from the structured form and formats it in the format needed for the
csv import. I then save the invoice in the spreadsheet and do Save As
on the second tab to create the csv file import.

David

On Mon, 14 Sep 2020 at 19:11, Fran_3 via gnucash-user
 wrote:
>
> Note: When I say "Bill" here I mean a Bill from a Vendor to us.
> I'm trying to import a CSV  file to AP and also have it create the 
> corresponding Bill.I have 100+ of these to import else a lot of labor to do 
> it by hand...
>
> So... to experiment I exported the Entities AP register as a CSV file.Then 
> deleted all transactions except one... just to keep it simple.So now I have 3 
> comma separated lines...- Column Title line- Transaction 1 line 1- 
> Transaction 1 line 2
> Now with the AP register still open I click...File > Import > Transactions 
> from a CSV fileI then...- select the file to import- tell the importer to 
> ignore line 1... the Column Title line- tell the importer the date format to 
> use
> Next I start telling the importer the titles of the columns...I leave some 
> column titles set to "none" like...Transaction-ID, Number, 
> Commodity/Currency, Void Reason, to name a fewI do choose titles for these 
> columns to import...Date, Description, Notes, Action, Memo,
>
> Now I'm stuck...The "Exported" sample shows the next four columns titled 
> as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num
> BUT... the importer doesn't offer these column name options...
> My Question: Which Column Name do I choose from the Importer for the above 4 
> lines?
> I don't know, for instance, if the Amount with Symbol and the Amount Num 
> should have their columns named Withdrawal or Deposit... as those titles seem 
> to go with a checking account.
> I also don't know how to make the importer identify the double entry accounts 
> for each imported transaction... like...- Accounts Payable and Utilities... 
> or...- Accounts Payable and Office Supplies... etc
> Thanks for any help.
>
>
> ___
> 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 Whiting  
___
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] Importing Liability Transactions to AP/Bills

[Fran_3 via gnucash-user]

 David, That worked great. thanks!
Next question... anyway to import payments?
And, actually, instead of Assets: Checking making the payments...I want the 
payments to come from...Liabilities: Reimbursements To/From Entity B

Because Entity B paid a bunch of Bills for Entity A...So Entity A wants to show 
the Bills Paid and record a debt to Entity B for those payments.
Note: Such transactions occur on occasion between both Entities thus the 
name...Reimbursements To/From Entity B

Thanks again for the help.
On Monday, September 14, 2020, 5:17:20 PM EDT, david whiting 
 wrote:  
 
 Hi Fran,

I import lots of bills and use File -> Import -> Import bills and
Invoices (not transactions). See this help page for details:
https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html
For my purposes I found it useful to create a spreadsheet for entering
details that has a structure that makes sense and then a second sheet
that I named "Export to csv" that has formula that take the values
from the structured form and formats it in the format needed for the
csv import. I then save the invoice in the spreadsheet and do Save As
on the second tab to create the csv file import.

David

On Mon, 14 Sep 2020 at 19:11, Fran_3 via gnucash-user
 wrote:
>
> Note: When I say "Bill" here I mean a Bill from a Vendor to us.
> I'm trying to import a CSV  file to AP and also have it create the 
> corresponding Bill.I have 100+ of these to import else a lot of labor to do 
> it by hand...
>
> So... to experiment I exported the Entities AP register as a CSV file.Then 
> deleted all transactions except one... just to keep it simple.So now I have 3 
> comma separated lines...- Column Title line- Transaction 1 line 1- 
> Transaction 1 line 2
> Now with the AP register still open I click...File > Import > Transactions 
> from a CSV fileI then...- select the file to import- tell the importer to 
> ignore line 1... the Column Title line- tell the importer the date format to 
> use
> Next I start telling the importer the titles of the columns...I leave some 
> column titles set to "none" like...Transaction-ID, Number, 
> Commodity/Currency, Void Reason, to name a fewI do choose titles for these 
> columns to import...Date, Description, Notes, Action, Memo,
>
> Now I'm stuck...The "Exported" sample shows the next four columns titled 
> as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num
> BUT... the importer doesn't offer these column name options...
> My Question: Which Column Name do I choose from the Importer for the above 4 
> lines?
> I don't know, for instance, if the Amount with Symbol and the Amount Num 
> should have their columns named Withdrawal or Deposit... as those titles seem 
> to go with a checking account.
> I also don't know how to make the importer identify the double entry accounts 
> for each imported transaction... like...- Accounts Payable and Utilities... 
> or...- Accounts Payable and Office Supplies... etc
> Thanks for any help.
>
>
> ___
> 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 Whiting  
___
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] Subject Correction: How to import CSV into AP Register?

[Fran_3 via gnucash-user]

Note: When I say "Bill" here I mean a Bill from a Vendor to us.
I'm trying to import a CSV  file to AP and also have it create the 
corresponding Bill.I have 100+ of these to import else a lot of labor to do it 
by hand...

So... to experiment I exported the Entities AP register as a CSV file.Then 
deleted all transactions except one... just to keep it simple.So now I have 3 
comma separated lines...- Column Title line- Transaction 1 line 1- Transaction 
1 line 2
Now with the AP register still open I click...File > Import > Transactions from 
a CSV fileI then...- select the file to import- tell the importer to ignore 
line 1... the Column Title line- tell the importer the date format to use
Next I start telling the importer the titles of the columns...I leave some 
column titles set to "none" like...Transaction-ID, Number, Commodity/Currency, 
Void Reason, to name a fewI do choose titles for these columns to 
import...Date, Description, Notes, Action, Memo, 

Now I'm stuck...The "Exported" sample shows the next four columns titled as...- 
Full Account Name- Account Name- Amount with Symbol- and Amount Num
BUT... the importer doesn't offer these column name options...
My Question: Which Column Name do I choose from the Importer for the above 4 
lines?
I don't know, for instance, if the Amount with Symbol and the Amount Num should 
have their columns named Withdrawal or Deposit... as those titles seem to go 
with a checking account.
I also don't know how to make the importer identify the double entry accounts 
for each imported transaction... like...- Accounts Payable and Utilities... 
or...- Accounts Payable and Office Supplies... etc
Thanks for any help.


___
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] Importing Liability Transactions to AP/Bills

[Fran_3 via gnucash-user]

Note: When I say "Bill" here I mean a Bill from a Vendor to us.
I'm trying to import a CSV  file to AP and also have it create the 
corresponding Bill.I have 100+ of these to import else a lot of labor to do it 
by hand...

So... to experiment I exported the Entities AP register as a CSV file.Then 
deleted all transactions except one... just to keep it simple.So now I have 3 
comma separated lines...- Column Title line- Transaction 1 line 1- Transaction 
1 line 2
Now with the AP register still open I click...File > Import > Transactions from 
a CSV fileI then...- select the file to import- tell the importer to ignore 
line 1... the Column Title line- tell the importer the date format to use
Next I start telling the importer the titles of the columns...I leave some 
column titles set to "none" like...Transaction-ID, Number, Commodity/Currency, 
Void Reason, to name a fewI do choose titles for these columns to 
import...Date, Description, Notes, Action, Memo, 

Now I'm stuck...The "Exported" sample shows the next four columns titled as...- 
Full Account Name- Account Name- Amount with Symbol- and Amount Num
BUT... the importer doesn't offer these column name options...
My Question: Which Column Name do I choose from the Importer for the above 4 
lines?
I don't know, for instance, if the Amount with Symbol and the Amount Num should 
have their columns named Withdrawal or Deposit... as those titles seem to go 
with a checking account.
I also don't know how to make the importer identify the double entry accounts 
for each imported transaction... like...- Accounts Payable and Utilities... 
or...- Accounts Payable and Office Supplies... etc
Thanks for any help.


___
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] Is there a Report for All Expenses Paid between Date A & Date B

[Fran_3 via gnucash-user]

 Thanks Adrian. You zeroed in on the issue. 
This particular entity is reporting on a cash basis... not accrual.And, sadly, 
in this case using Invoices that were posted and paid to vendors won't get the 
entire picture as some incidental purchases/expenses were paid without posting 
an invoice from the vendor...But, in both cases... they do show up in expenses. 
So, I guess we are stuck with a lot of work to figure this out.I will read your 
last reply more carefully this weekend and see if I discover any hint's to make 
it easier.Thanks again for the help.



On Friday, September 11, 2020, 6:11:54 PM EDT, Adrien Monteleone 
 wrote:  
 
 Ah, are you using the Business features and you want to only show those 
expenses (from invoices) that are paid?

That's a tougher call.

With accrual accounting, you book expenses when incurred, not 
necessarily when paid. That transaction is separate from the payment.

Paying a vendor may or may not completely cover any particular line item 
expense. The idea with accruals isn't just following the Recognition 
Principle, but also separating the concept of paying expenses 
individually. (you might be so lucky, but likely not)

So you can either track each expense and if it is paid, or you can track 
if you've paid invoices, but not really both, at least not without lots 
of work.

This would be similar to a credit card. You purchase using the card as 
payment. The expense is realized right away though technically you 
didn't pay for them, you used a line of credit. (similar to with vendors)

When you do make payment, you track the balance of the account as a 
whole, not each individual use of the credit line.

It is of course possible to see what invoices have been paid and with 
what payment transactions. Use the Vendor Report. You can run it 
directly and choose a vendor, or Run the Payables Aging report, then 
click the total amount for that Vendor (not their name) and you'll get 
the Vendor report for that vendor. I keep a Payables Aging tab open at 
all times and just click to run their reports as needed. (same for 
Receivables)

You can go to Options and turn on Display Columns > Links > 'Simple' or 
'Detailed' as desired to see the payment transaction links to each 
invoice. (and vice versa)

 From there, you can pull up those paid (or unpaid) invoices to see what 
was covered by payments.

That sounds daunting at first, but there is a slight bit of time saving 
that is possible here, though it requires some spreadsheet KungFu:

#1 - you need to not 'accumulate splits' when posting bills. This means 
that each line item on the bill will show up in the AP and associated 
expense registers rather than being consolidated. (so if you had 
multiple line items for 'supplies' each line would show up, rather than 
just one split for supplies)

#2 - Export/Copy-Paste that Transaction Report to a spreadsheet

#3 - Do the same for the Vendor Report in another sheet in the same 
workbook.

#4 - Either on the Transaction Report sheet, or a 3rd sheet, write some 
IF statement formulas (or SUMIF forumals) to show you only expense 
splits that have matching payments for their bills (or do not) as 
desired. Note, the bill numbers should show up next to the date as the 
NUM field. (you might have to make this visible in the Transaction 
Report when you run it)



For any expenses not paid through Bills, you then have to check to see 
if you made credit card payments, or you can check to see if paid by 
Checking or Cash and then include them in the summary data.


Another option is to learn Scheme and design this report from within 
GnuCash, or hire someone to do so. But I'd first play with spreadsheets 
so you see exactly how the data appears and the minimum parts of it you 
need to make the determination.


You can narrow down your expense list by filtering the Accounts used for 
the Transaction Report to only include transactions that also include 
say Checking or Cash, then you know those are paid.

A separate report could show you expenses that also include AP, so you 
know those are Bills.

A third could show you expenses that also include credit card accounts, 
so you know you'd have to handle those accordingly.

Regards,
Adrien

On 9/11/20 4:16 PM, Fran_3 via gnucash-user wrote:
>  How can I limit the report to "Paid Expenses" during the period?
> Thanks
> 
>      On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone 
> wrote:
>  
>  Use the Income Statement (Profit & Loss) but only select Expense
> accounts. Set your date range as desired in the General tab. You can
> then click the account links to examine which transactions were
> affecting the report.
> 
> If you instead want just a list of individual transactions, run the
> Transaction report with those same options. (choose only expense
> accounts and then set dates accordingly)
> 
> The Transaction report also lets y

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

[Fran_3 via gnucash-user]

 Michael, maybe I got my words mixed up. 
What we want is a report that shows paid expenses for a defined period. 
Thanks


On Friday, September 11, 2020, 6:02:48 PM EDT, Michael or Penny Novack 
 wrote:  
 
 On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote:
>  How can I limit the report to "Paid Expenses" during the period?
> Thanks


WHAT do you mean? The books are not a "budget". They are a record of 
transactions that have actually taken place. If you did not pay some 
expense there should not be a record of its payment in your books.

What ARE you meaning by the "paid" in "paid expenses"?

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] Is there a Report for All Expenses Paid between Date A & Date B

[Fran_3 via gnucash-user]

 How can I limit the report to "Paid Expenses" during the period?
Thanks

On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone 
 wrote:  
 
 Use the Income Statement (Profit & Loss) but only select Expense 
accounts. Set your date range as desired in the General tab. You can 
then click the account links to examine which transactions were 
affecting the report.

If you instead want just a list of individual transactions, run the 
Transaction report with those same options. (choose only expense 
accounts and then set dates accordingly)

The Transaction report also lets you group them, so you can group by 
Payee (description) or by Month for example.


Regards,
Adrien

On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote:
> I'm looking for an easy way list all paid expenses for a defined period.
> I poked around under Reports and maybe I missed it.
> How can I do this?
> Thanks for any help.

___
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] Is there a Report for All Expenses Paid between Date A & Date B

[Fran_3 via gnucash-user]

I'm looking for an easy way list all paid expenses for a defined period.
I poked around under Reports and maybe I missed it.
How can I do this?
Thanks for any help.

___
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] 1) search list 2) gnucash-u...@lists.gnucash.org vs gnucash-user@gnucash.org

[Fran_3 via gnucash-user]

1 - Is there anyway to search the list archives... like maybe you would do an 
online forum?
2 - I've ended up with two emails addresses for GnuCash...
gnucash-user@lists.gnucash.organdgnucash-u...@gnucash.org
What is the difference?Will both get my email distributed to the list members?
Thanks for any help.



___
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 transfer multiple bills from Vendor A to Vendor B? Journal Entry or what & how?

[Fran_3 via gnucash-user]

 Thanks Derek. After reading your helpful post we have decided on a different 
route.
We are leaving the bills in Ven A's acct but noting the amount in the Bill 
Description field ...
and then changing the amount of the bill to zero...
Then in the Post Description noting $xx.xx Transfered to Ven B.
Then we create a new bill in Ven B's account for the bill amount with 
appropriate notations.
Then pay the bill to Ven B.
This way there is a record of what happened for both  Ven A & Ven B when we 
look at 
Reports > Experimental > Vendor Report beta
and click Display Columns > Links > Simple

Complicated maybe but we only have a few instances where this must be done... 
and it seems to work :-)
Thanks again for the help.
On Thursday, August 27, 2020, 12:37:29 PM EDT, Derek Atkins 
 wrote:  
 
 HI,

On Thu, August 27, 2020 11:50 am, Fran_3 via gnucash-user wrote:
> We have some unpaid bills posted to Vendor A's account...We need to
> transfer the total of those bills from Vendor A's account to Vendor B's
> account.Then pay that total out of Vendor B's account
> We do not want to delete the individual bills from Vendor A's account.We
> just want to transfer the total of the bills so that we show that we moved
> the total of the bills to Account B.
> Once the transfer is done we will record the payment of the bills in
> Account B.
> I thought we could do this with a journal entry but I can't see how to do
> that as when I look at...Tools > General Journal
> How can I do this so I have a record in the system of what happened?

Do you want the bills for Vendor A to show as "paid"?  If so, the only way
to do that would be to "Process Payment" for them.  But there is no way,
internally, to create a transaction that will transfer the outstanding
balance from one vendor to another in a single transaction.

You COULD potentially to it through a suspense account.  So you "pay" the
vendor A bills from some account (Equity:Vendor Shift?).  Then you create
a new bill for vendor B that pulls from that Equity account and moves the
balance back into AP.  Then you can Process Payment to pay Vendor B.

Two notes:

1) You may not be able to do this from an equity account -- it might make
sense to do the second step first and figure out what account you want to
(and can) use, and then move the funds from Vendor A.

2) You can safely change the "far" account of the Vendor A payment.  So
e.g. you could Process Payment from Bank to A/P for Vendor A, and then
change "Bank" to anything else.  So long as you don't change the amount or
touch the AP side, everything stays kosher under the covers.

Hope this helps!

> Thanks for any help.

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

[GNC] How to transfer multiple bills from Vendor A to Vendor B? Journal Entry or what & how?

[Fran_3 via gnucash-user]

We have some unpaid bills posted to Vendor A's account...We need to transfer 
the total of those bills from Vendor A's account to Vendor B's account.Then pay 
that total out of Vendor B's account
We do not want to delete the individual bills from Vendor A's account.We just 
want to transfer the total of the bills so that we show that we moved the total 
of the bills to Account B.
Once the transfer is done we will record the payment of the bills in Account B.
I thought we could do this with a journal entry but I can't see how to do that 
as when I look at...Tools > General Journal
How can I do this so I have a record in the system of what happened?
Thanks for any help.
___
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] Monthly Payments on posted Liability?

[Fran_3 via gnucash-user]

 Thanks Steve, Michael, and Adrian.Steve answered it, Adrian explained, and 
Michael made the point about interest and taxes. All good and helpful.


On Monday, August 24, 2020, 5:18:38 PM EDT, Michael or Penny Novack 
 wrote:  
 
 
>
> On 8/24/20 11:19 AM, Stan Brown wrote:
>> On 2020-08-24 09:01, Fran_3 via gnucash-user wrote:
>>> For a posted liability of say $1,000with an agreement to pay in 10 
>>> monthly installments of $100 each.How do you enter those monthly 
>>> payments and...1 - have the payment applied to the liability

Also, something seems to have been left out. A liability of $1000 paid 
off by ten payments of $100 would mean this was a no interest loan.

More usually, you are paying interest. So some of each payment is a 
reduction of the liability and some interest expense. A split 
transaction. Even if this were a purchase on an installment contract (so 
no explicitly stated interest) strictly correct would be to assume what 
rate should be implied and enter the liability at this discounted 
amount. These days might not matter for personal finances but I bet it 
does for business since the interest would be a deductible expense.  
Mind, I have never looked at the "installment sales" or "installment 
purchases" parts of the1040.


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] Monthly Payments on posted Liability?

[Fran_3 via gnucash-user]

For a posted liability of say $1,000with an agreement to pay in 10 monthly 
installments of $100 each.How do you enter those monthly payments and...1 - 
have the payment applied to the liability2 - have the monthly payment appear in 
the "Bills Due Reminder"3 - or any report that shows you.. upcoming 
expenses, item by item for the next x days... upcoming revenue, item by item 
for the next x days
I ask because clicking Reports > Vendor > Process Payments seems to only look 
in AP... or does it?
Thanks for any help.

___
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] Can you move a Liability Account to a "sub-account" in Liabilities?

[Fran_3 via gnucash-user]

 Great ! Thanks Derek and Stephen. That saved me some time :-)

On Thursday, July 30, 2020, 9:49:35 AM EDT, Derek Atkins  
wrote:  
 
 Hi,
Yes, of course.
Create Liabilities ABC account
then edit each of Liabilities A, .. etc and change the parent.
-derek

On Thu, July 30, 2020 9:41 am, Fran_3 via gnucash-user wrote:
> 3 items listed under Liabilities...
> Liability ALiability BLiability Ceach to a different entity but related
> based on certain criteria.
> We want to setup another Liability account "Liabilities ABC" and then move
> the 3 above under it as "sub-accounts" like ...
> Liabilities- Liabilities ABC-- Liability A-- Liability B-- Liability C
> That way we can see the total of the 3 or each individual total...
> The Question: Is there any way to do this without having to delete A, B,
> C, and re-creating them under Liabilities ABC ?
> Thanks for any help.
>
> ___
> 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] Can you move a Liability Account to a "sub-account" in Liabilities?

[Fran_3 via gnucash-user]

3 items listed under Liabilities... 
Liability ALiability BLiability Ceach to a different entity but related based 
on certain criteria.
We want to setup another Liability account "Liabilities ABC" and then move the 
3 above under it as "sub-accounts" like ...
Liabilities- Liabilities ABC-- Liability A-- Liability B-- Liability C
That way we can see the total of the 3 or each individual total...
The Question: Is there any way to do this without having to delete A, B, C, and 
re-creating them under Liabilities ABC ?
Thanks for any help.

___
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] 1) list unpaid vendor bills only 2) delete vendor to delete all bills?

[Fran_3 via gnucash-user]

1 - In Ver 3.8 is there anyway to list all unpaid bills for a vendor? 
(Reports > Experimental > Vendor Report (beta shows all for the period selected 
but we only want unpaid)
2 - If I delete a Vendor will it delete all of the Vendors Bills?We actually 
want to do this but the vendor has lots of Bills. 
(If this won't work we will have to un-post every single bill and then delete 
it... lots of work... 
and it leaves all the un-posted bills in the system :-(
Thanks for any help.

___
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 remove or hide certain bills from appearing in the Due Bills Reminder?

[Fran_3 via gnucash-user]

Thanks Adrien. As always very helpful!
BTW, I attempted to setup a second AP account under Liabilities named "AP 
Temporary Suspended " 
- But, when posting it GC won't let me post to that account. - It will however 
allow creating a new account that shows up on the same level as Assets & 
Liabilities...
So, I've decided to un-post the bills in question and re=post them with a date 
way out... as GC will not allow posting a bill without a due date.

Thanks again for the help !!!
On Tuesday, July 21, 2020, 1:55:13 AM EDT, Adrien Monteleone 
 wrote:  
 
 #2 - I forgot to make clear that, no, unchecking the Active box does not 
hide the bill from the Due reminder. You'll have to also unpost it for 
that effect. You can of course re-post later with the original due date 
if you like. The Active checkbox, I think, will only hide the invoice 
from a Find operation.

Regards,
Adrien

On 7/20/20 6:50 PM, Fran_3 via gnucash-user wrote:
>  1 - So to force a posted bill down the list we will have to un-post it, 
>change the due date, and then re-post it... right?
> 2 - And, on a posted bill... what is the "Active" Check box?
> Thanks for the help.

___
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 remove or hide certain bills from appearing in the Due Bills Reminder?

[Fran_3 via gnucash-user]

 1 - So to force a posted bill down the list we will have to un-post it, change 
the due date, and then re-post it... right?
2 - And, on a posted bill... what is the "Active" Check box?
Thanks for the help.


On Monday, July 20, 2020, 4:43:22 PM EDT, Adrien Monteleone 
 wrote:  
 
 #1 - I don't think so. Either you see what is posted (and not paid in 
full) or your don't post stuff. You do have the preference to set how 
many days in advance you want to be notified. (Preferences > Business > 
Invoices/Bills > Notify when due) But once within that window, they are 
going to appear.

#2 - The bill will still show with the remaining balance but as of the 
original due date. Not sure why you'd want to not show the balance as 
still due if it in fact is. If you've been issued a credit as a 
correction, you can apply the credit as an offset.

It sounds like you want to 'turn off' some bills from notices/reminders, 
but then you'd need a feature to bug you occasionally that you've turned 
them off! (else, what is the point of using the original feature?)

Regards,
Adrien

On 7/20/20 11:40 AM, Fran_3 via gnucash-user wrote:
> 1 - Bill Temporary Suspended Case:
> Can you decide which bills appear in the Due Bills Reminder list?
> There a variety of reasons we may choose to delay payment to a vendor. so we 
> do not always want to see every single "due" bill in the Due Bills Reminder 
> list.
> I assume we can change the bills due date but we don't want to do that as it 
> destroys information that we would like to keep... that is we still want to 
> know when the bill was originally due.
> 2 - Bill Partially Paid Case:
> What about the case where the bill is due but only a partial payment is made 
> to the vendor...
> 
> Example the bill was for $100 but we only paid $30 until certain issues were 
> resolved...  the $70 balance would keep popping up on the top of the Due 
> Bills Reminder list...
> Unless we went back and deleted the original bill for $100 and re-posted it 
> as two bills... one for $30 and the second for $70... but that can be 
> confusing as it then looks like we posted 2 bills for 2 different jobs.
> How would you manage this?
> Thanks for any help.

___
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] How to remove or hide certain bills from appearing in the Due Bills Reminder?

[Fran_3 via gnucash-user]

1 - Bill Temporary Suspended Case:
Can you decide which bills appear in the Due Bills Reminder list?
There a variety of reasons we may choose to delay payment to a vendor. so we do 
not always want to see every single "due" bill in the Due Bills Reminder list.
I assume we can change the bills due date but we don't want to do that as it 
destroys information that we would like to keep... that is we still want to 
know when the bill was originally due.
2 - Bill Partially Paid Case:
What about the case where the bill is due but only a partial payment is made to 
the vendor... 

Example the bill was for $100 but we only paid $30 until certain issues were 
resolved...  the $70 balance would keep popping up on the top of the Due Bills 
Reminder list...
Unless we went back and deleted the original bill for $100 and re-posted it as 
two bills... one for $30 and the second for $70... but that can be confusing as 
it then looks like we posted 2 bills for 2 different jobs.
How would you manage this?
Thanks for any help.




___
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 Due Reminder: Column titled "CN?" is what?

[Fran_3 via gnucash-user]

 Thanks Derek!
A "hover" tip would be handy for some of us :-)

On Monday, July 20, 2020, 11:35:08 AM EDT, Derek Atkins  
wrote:  
 
 "Credit Note?"

-derek

On Mon, July 20, 2020 11:29 am, Fran_3 via gnucash-user wrote:
> What is the "check box" column titled CN? in the Bills Due Reminder?
> Thanks.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
      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] Bills Due Reminder: Column titled "CN?" is what?

[Fran_3 via gnucash-user]

What is the "check box" column titled CN? in the Bills Due Reminder?
Thanks.

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

[GNC] 1) Vendor Overview Report Questions 2) Any issues if I upgrade from GC 3.8?

[Fran_3 via gnucash-user]

1 - Vendor Overview Report Question - How to add columns... like the Vendor 
Notes Column?We often put notes in this field about when invoices are normally 
received, when payments are due, payment terms, etc. It would be hand to see 
that when we clicked Business > Vendor > Vendors Overview
2 - Upcoming Expenses Report:Is there a report that list upcoming regular 
monthly bills by vendor and typical due date... and maybe average monthly 
amount?I would call this a "look ahead" feature to see what regular expenses 
are upcoming... 
The "Bill Due Reminder" report is somewhat like what I'm looking for but the 
difference is...I want regular monthly bills included even if we have not 
actually posted the bill yet.
3 - Future Cash Flow report.A report that shows predicted expenses vs predicted 
income... month by month... is this feature or something kind of like it in GC 
or planned?

4 - Reminders vs Scheduled Transactions
4a - Are "Scheduled Transactions" automatically executed... like a scheduled 
monthly payment... is it automatically deducted from your bank account... or 
does it just remind you in the "Bill Due Reminder" report?
4b - Anyway to just put a reminder into the system like maybe... Wife's 
Birthday or whatevr?

4 - Should I expect any issues if I upgrade from 3.8 to 4.0 on Windows 10?
5 - Will the upgrade automatically replace 3.8 or should I uninstall it first?
Thanks for any help.


___
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] How to find UnPosted Bill?

[Fran_3 via gnucash-user]

Seems like I ran into this way back but can't remember the solution...
- If a bill is created...- Then the bill tab is closed before it is "Posted"
it seems it does not appear in... 
Business > Vendor > Find Billnor in...Reports > Experimental > Vendor Report 
(beta)
So where is it? How to find it and post it?
Thanks.

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

[GNC] Will Image Attachments go through the email list server?

[Fran_3 via gnucash-user]

Just wondering if I can include an image file with a post?
Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Bill: Bill ID vs Billing ID

[Fran_3 via gnucash-user]

 Thanks to all for responding to this.
For now we have decided to make up our own definitions for the two fields...
Bill ID: we leave it blank so GnuCash auto numbers it for us.
Billing ID: we enter the Vendor's Bill number aka their "Invoice" number. If 
the vendor does not put an Invoice Number on their Bill to us then we enter the 
vendor's initials plus the due month and year like... 
gdJun20 for a GoDaddy bill due June, 2020
Thanks again for all the response to this OP.


On Wednesday, June 17, 2020, 12:29:38 PM EDT, Derek Atkins 
 wrote:  
 
 Hi,

Fran_3 via gnucash-user  writes:

> In 7.10.1 are the field definitions for a New Bill from a
> vendor... two of them are...
>
> Invoice Info - Invoice ID (optional) - the identification number of
> the invoice as emitted by the vendor (IE: the vendor’s internal number
> for this invoice).
> Billing Info - Billing ID (optional) - the vendor’s ID for the bill
> (e.g.: their invoice #).
> This is confusing to me as follows...
> On Bills we receive from vendors we often find a number on the
> document we use to identify it...1 - Vendor's Bill Number

The idea is that both you and the other entity might have your own
unique identifiers for the Bill or Invoice, so this lets you put them
both on.  This boils down to "naming is hard".

When you send out an Invoice to a customer you have your invoice number
on it, but the customer may want something on it (like a PO#).

When you receive a Bill from a vendor it will have their invoice# on it,
but you might want your own counter for it.

This is why there are two cases.

These numbers are irrespective of due dates.

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

[GNC] New Bill: Bill ID vs Billing ID

[Fran_3 via gnucash-user]

In 7.10.1 are the field definitions for a New Bill from a vendor... two of them 
are...

Invoice Info - Invoice ID (optional) - the identification number of the invoice 
as emitted by the vendor (IE: the vendor’s internal number for this invoice).
Billing Info - Billing ID (optional) - the vendor’s ID for the bill (e.g.: 
their invoice #).
This is confusing to me as follows...
On Bills we receive from vendors we often find a number on the document we use 
to identify it...1 - Vendor's Bill Number
 
along with the the dates often found on the document... like...2 - Date the 
vendor created the Bill3 - Service Period Dates
4 - Due Date
We consider 4 above to be the Billing ID in 7.10.1 above... aka the vendor's ID 
for the bill... aka their invoice #
So what is Invoice Info - Invoice ID  in 7.10.1?
Thanks for any clarification. 





___
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] 1) View Transactions: Newest at Top 2) Larger Type

[Fran_3 via gnucash-user]

1 - Is there anyway... when looking at a register... like Check Register... to 
reverse the order & have the latest transaction on top? 
(Including the blank fields for the "next" transaction)
2 - Any way to make the type larger on the screen for easier viewing?
If not are these in the "wish list' ?
Thanks.

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

Re: [GNC] Random Payment To: field and For: field -- without creating invoice?

[Fran_3 via gnucash-user]

 Well I'll be darn'd... I can't beleive I am just discovering the view "Double 
Line" option !

That is the answer I needed Adrien. Thank you!

On Tuesday, June 9, 2020, 1:55:06 PM EDT, Adrien Monteleone 
 wrote:  
 
 Personally, I consider “Description” to always be “Payee” no matter the 
transaction.

“For” would be more appropriate for the “Memo” line on the relevant split.

If you have more than one debit split, use the “Notes” field. You’ll need to 
turn on View > Double Line to be able to see it. With that, if you really want 
to use "Description" for ‘For’ then you can use “Notes” for ‘Payee’

Regards,
Adrien

> On Jun 9, 2020 w24d161, at 12:37 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> When making a routine random payment ... is there a way to have 2 fields...
> To:For:
> I have a number vendors that are routinely used but that are paid on the spot 
> without them submitting, or us creating an invoice...
> If I just go to the bottom of the check register I only get a Description 
> field... 
> So unless I am very careful in how the entry is made... 
> I may not be able to run easily a transaction report to get the total spent 
> at a specific vendor.
> I try to enter vendor first and then what it was for... but consistency can 
> be elusive.
> Yes, assigning it to an account gives me another tool but that is not vendor 
> specific.
> thanks any help.

___
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] Random Payment To: field and For: field -- without creating invoice?

[Fran_3 via gnucash-user]

When making a routine random payment ... is there a way to have 2 fields...
To:For:
I have a number vendors that are routinely used but that are paid on the spot 
without them submitting, or us creating an invoice...
If I just go to the bottom of the check register I only get a Description 
field... 
So unless I am very careful in how the entry is made... 
I may not be able to run easily a transaction report to get the total spent at 
a specific vendor.
I try to enter vendor first and then what it was for... but consistency can be 
elusive.
Yes, assigning it to an account gives me another tool but that is not vendor 
specific.
thanks any help.






___
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] Transaction Report Filter Questions

[Fran_3 via gnucash-user]

 Thanks Christopher.

On Thursday, May 21, 2020, 1:58:52 AM EDT, Christopher Lam 
 wrote:  
 
 Until 4.x is ready, yes you'll have to use this syntax.
On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, 
 wrote:

Transaction Filter seems to be case sensitive as searching for "Chevron" will 
not find "CHEVRON" so you must use regx like 
[Cd][Hh][Er][Vv][Rr][On][Nn]Right?
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[GNC] Transaction Report Filter Questions

[Fran_3 via gnucash-user]

Transaction Filter seems to be case sensitive as searching for "Chevron" will 
not find "CHEVRON" so you must use regx like 
[Cd][Hh][Er][Vv][Rr][On][Nn]Right?
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

[Fran_3 via gnucash-user]

 I'm not quite sure I understand the comment here but fyi I have had zero 
problems importing csv data into GnuCash checking and savings accounts from 
Wells Fargo... but there is a process I use.
1 - Download the transactions from your bank as a csv file.2 - Import them into 
a spreadsheet.3 - Delete the columns you don't want and arrange the remainder 
in any order you want.4 - For checking & savings I use 5 fields (columns)  
Date, Num, Description, Deposit, Withdrawal5 - Now save/export that from your 
spreadsheet as a csv file6 - Now open GC and click File > Import > Transactions 
from CSVthen follow the bouncing ball.
I suggest you make a test copy of your GC file and experiment with this until 
you feel comfortable with the process.
During the import process if you select your Assets > Current Assets > Checking 
Accountthe import feature of GC allows you to assign which expense account to 
assign each transaction to.After awhile it "learns" which one even though I 
always check each one.
Frankly, for me, it works flawlessly as the developers have done one hell of a 
job building the application.
The biggest problem I have with GC is me. I don't do it every day and often 
stumble around remembering how I did it.I'm also prone to rushing and shooting 
myself in the foot.Cockpit error is my number one enemy.
Finally, the original post was simply to let folks know that you can just copy 
a Transaction Report from the GC screen and then paste it into Google Sheets. 
Now need to export. Plus the Transaction Report gives you the option of 
selecting which columns you want... and more.

An application for this is when you are looking for some error between banking 
and say the GC cecking transactions.
 For instance for checking I have copied 3 years of transactions from the 
Transaction Report and pasted it into a Google Sheet tab.Then imported csv 
banking transactions into another tab in the spreadsheet.Then copied the date & 
amount of each into a 3rd tab.Then sorted each by amount, date.Then with a 
column in the middle enter the formula...=if(Bank Amount <> GC Amount, 
"X",)This will place an X anywhere the two don't agree so any mismatching 
transaction will jump out at you.
Sorry, too much info here but maybe it will help somebody... and I'm sure there 
is an easier way but, worked for me :-)
Fran

On Tuesday, May 19, 2020, 6:56:19 PM EDT, flywire  
wrote:  
 
 A useful tip but an unfortunate post title because this exports the
transactions. The Transaction Report can be exported as a html and opened
directly in a spreadsheet (LibreCalc). GnuCash csv import not initially
recognising anything in the csv file it just exported is also a surprise
and disappointment.
___
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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

[Fran_3 via gnucash-user]

 Adrien, yes, File > Export> Transactionsallows you to choose a delimiter, 
select an account (like checking), and select a date rangewhile > Registerwill 
let you export an entire register... like the check register or whatever.There 
are also other options.
I found this useful when trying to understand to organize fields for import 
into GC... but later learned that the import feature will let you tell it what 
field is what...In that regard I normally import fieldsDate, Num, Description, 
Deposits, WithdrawalsRemembering that GC wants both deposits and withdrawals to 
be positive numbers.

But the ability to cut and paste from a report is awsome and so simple.
FYI, Google Sheets, the free Google spreadsheet, works  perfectly either 
importing GC comma delimited data or bank exported csv files... and when 
copying a GC report and pasting directly into a spreadsheet.
Fran

On Tuesday, May 19, 2020, 2:15:37 PM EDT, Adrien Monteleone 
 wrote:  
 
 Thanks Fran!

I had previously resorted to Account Report or Transaction Report with 
copy/paste, but I hadn’t noticed the Export > Active Register option. I wonder 
how new that is?

I see it could be quite useful as it includes data that is otherwise hidden 
from the Register tab. (transaction ID, Currency, Rate/Price, Reconcile Date) 
While most people might not have a use for them, I could see they might come in 
hand when trying to solve a problem —say with an import. I also like that you 
get a column both with and without currency symbols. (some spreadsheets don’t 
play nice with the symbols, so you have to remove them. This saves a step)

I don’t use Excel, but some years ago, I recall a few threads where there were 
quirks. It seemed OOo or LO (and I suppose Google Sheets) were better suited, 
or at least didn’t require extra hoops to get to the end result. I can’t 
remember what Excel was choking on though.

Regards,
Adrien

> On May 19, 2020 w21d140, at 11:55 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> To get a register, or part of a register out of GC and into  a spreadsheet 
> you can...
> File > Export > etcThen import the csv file into the spreadsheetthen dink 
> with it to delete or hide unwanted columns, etc...
> Or do it faster and with more control via...
> 
> Open the registerClick Reports Transaction ReportEdit Report Options
> And then just highlight the transactions with the mouse and paste them right 
> into a Google Sheet !
> Much quicker (to me) and you have more control in that you can select the 
> columns you want and more.
> I wonder if this works in Excel too?

___
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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

[Fran_3 via gnucash-user]

To get a register, or part of a register out of GC and into  a spreadsheet you 
can...
 File > Export > etcThen import the csv file into the spreadsheetthen dink with 
it to delete or hide unwanted columns, etc...
Or do it faster and with more control via...

Open the registerClick Reports Transaction ReportEdit Report Options
And then just highlight the transactions with the mouse and paste them right 
into a Google Sheet !
Much quicker (to me) and you have more control in that you can select the 
columns you want and more.
I wonder if this works in Excel too?




___
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 "relaunch" Transaction Report Options Window

[Fran_3 via gnucash-user]

 Dad Burn It... I should have seen that. Thanks!

On Tuesday, May 19, 2020, 11:51:07 AM EDT, Derek Atkins  
wrote:  
 
 Of course!  Just click the "Options" button in the toolbar.
It kind of looks like a wrench.

-derek

On Tue, May 19, 2020 11:43 am, Fran_3 via gnucash-user wrote:
> After I create a "Transaction Report" I often close the  "Transaction
> Report Options Window"That is the window that allows me to select the date
> range, choose what columns to display, etc.And often, after I close the
> Options Window... I wish I hadn't as I want to tweak something about the
> report.
> The Question:While I'm looking at a Transaction Report...And having
> already closed the "Transaction Report Options Window"
> Is there a way to "Relaunch" the "Transaction Report Options Window" and
> tweak the existing report?
> Thanks
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
      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] How to "relaunch" Transaction Report Options Window

[Fran_3 via gnucash-user]

After I create a "Transaction Report" I often close the  "Transaction Report 
Options Window"That is the window that allows me to select the date range, 
choose what columns to display, etc.And often, after I close the Options 
Window... I wish I hadn't as I want to tweak something about the report.
The Question:While I'm looking at a Transaction Report...And having already 
closed the "Transaction Report Options Window"
Is there a way to "Relaunch" the "Transaction Report Options Window" and tweak 
the existing report?
Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What does OFX Direct Connect do?

[Fran_3 via gnucash-user]

 Woops! No ill intent. I've seen the same response on other SIG's when someone 
started a new thread that a groups member or admin thought should have been 
included in a recent thread on that some related topic. Oh well.

Back to the topic... so OFX just saves you the steps of downloading the 
transactions as CSV and then having to do a bit of formatting before you import 
them into GC... right?


On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls  
wrote:  
 
 Don't hijack threads, it's rude. Start a new one when you have a new question.

OFX Direct Connect is just like importing an OFX or QFX file downloaded from 
your bank's website except that it will connect to the bank and get the OFX 
file for you.

Regards,
John Ralls


> On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> 
> If I can jump in here I would like to learn more about OFX Direct Connect 
> with GnuCash.
> 
> Does such automatically determine what transactions occur at the bank that 
> are not in GC...
> And then automatically update GnuCash?
> 
> Or what?
> 
> Thanks.
> 
> 
> On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
> wrote:
> 
> 
> 
> 
> > On May 17, 2020, at 12:06 PM, Hershey  wrote:
> > 
> > I'm new to Gnu and am having issues setting up online downloads.
> > My first attempt is Wells Fargo and I get a 2000 error message.
> > The Tutorial show Wells Fargo in its example but I've also seen this
> > statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> > doesn't support this authentication.
> 
> That last sentence is your answer, but perhaps you need some more detail. 
> There are two ways of connecting to a bank for OFX online communication, OFX 
> Direct Connect and OFX Web Connect. The former collects your user name and 
> password as part of the online session and the latter has you log in to the 
> bank's website and launch the OFX session from there. The way that the bank's 
> website connects to the financial software is proprietary to Intuit, the 
> makers of Quicken, so that it works only with their products. GnuCash is able 
> to work only with OFX Direct Connect.
> 
> 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] wells fargo downloads

[Fran_3 via gnucash-user]

 If I can jump in here I would like to learn more about OFX Direct Connect with 
GnuCash.
Does such automatically determine what transactions occur at the bank that are 
not in GC...And then automatically update GnuCash?
Or what?
Thanks.

On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls  
wrote:  
 
 

> On May 17, 2020, at 12:06 PM, Hershey  wrote:
> 
> I'm new to Gnu and am having issues setting up online downloads.
> My first attempt is Wells Fargo and I get a 2000 error message.
> The Tutorial show Wells Fargo in its example but I've also seen this
> statement on the web: Wells Fargo has switched to OFX Web Connect. GnuCash
> doesn't support this authentication.

That last sentence is your answer, but perhaps you need some more detail. There 
are two ways of connecting to a bank for OFX online communication, OFX Direct 
Connect and OFX Web Connect. The former collects your user name and password as 
part of the online session and the latter has you log in to the bank's website 
and launch the OFX session from there. The way that the bank's website connects 
to the financial software is proprietary to Intuit, the makers of Quicken, so 
that it works only with their products. GnuCash is able to work only with OFX 
Direct Connect.

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.

[GNC] Why does Reconciled field auto mark "n" & "c"

[Fran_3 via gnucash-user]

I've been importing csv files into checking with only 5 fields in each import...
Date, Num, Description, Deposit, Withdrawal
During the import process I assign the appropriated expense or income account 
and it works fine.
I also manually enter some transactions.
The Question: 

The Reconciliation column ("R" column) seems to be auto choosing either a "n" 
or"c"What is causing that?
Thanks for any help.


___
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 "R" column question

[Fran_3 via gnucash-user]

 Yes that did help. Thank.

On Monday, May 18, 2020, 9:57:13 AM EDT, Derek Atkins  
wrote:  
 
 Hi,

The three* values (at least in English) are n, c, and y.

Yes, you may freely swap between n and c in the register.  It just causes
a recomputation of account balances.

I do not believe you can get to 'y' without going through formal
reconciliation.  I.e., I don't think you can type 'y' in there and have it
be accepted, although I admit I've never tried to do that.  It would be
missing the "reconcile date" metadata for one thing.

Hope this helps.

-derek

* There is also a 'v' (void) status.

On Mon, May 18, 2020 9:41 am, Fran_3 via gnucash-user wrote:
> In Help 2.94 Reconciliation... "R" column choices are...
> n = not cleared the bankc = cleared the bankr = Reconciled
> I've got the GnuCash Check Register open in one window and I'm logged on
> to the bank in another window looking at recent transactions...I'm trying
> to make sure each bank transaction has been entered into GC.I'm not doing
> a formal monthly reconciliation... this is just an end of day check up.
>
> Question 1: May I freely change "n" and "c" back and forth while looking
> at the check register?Question 2: I understand that if you enter "r" in
> the "R" field it is hard to change back... true?
> Thanks for any help.
>
>
> ___
> 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] Reconciliation "R" column question

[Fran_3 via gnucash-user]

In Help 2.94 Reconciliation... "R" column choices are...
n = not cleared the bankc = cleared the bankr = Reconciled
I've got the GnuCash Check Register open in one window and I'm logged on to the 
bank in another window looking at recent transactions...I'm trying to make sure 
each bank transaction has been entered into GC.I'm not doing a formal monthly 
reconciliation... this is just an end of day check up.

Question 1: May I freely change "n" and "c" back and forth while looking at the 
check register?Question 2: I understand that if you enter "r" in the "R" field 
it is hard to change back... true?
Thanks for any help.


___
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] RegEx Case insensitive Search via Reports > Transaction Report > Transaction Filter ?

[Fran_3 via gnucash-user]

When using Reports > Transaction Report
I want to use the Transaction Filter to do a case insensitive search for some 
word like, for instance ... godaddy
I'm searching the Check Register but do not want use the Ctl-F search as it 
always returns each transaction as a split.
I tried
(?i)godaddy
in the Transaction Filter field but get nothing...
The target word may be entered into the system in many ways
GODADDYGodaddyGoDaddyetc
Thanks for any help.







___
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 start a new GC file for a new year?

[Fran_3 via gnucash-user]

 How about just creating a new account under Assets > Current Assets >and 
naming it Checking 2020Then for the last transaction in Checking 2019 transfer 
the ending balance to Checking 2020.This way everything is preserved and you 
have all your 2020 checking transactions in one neat account.Wouldn't that work?

On Saturday, March 21, 2020, 2:28:37 PM EDT, Adrien Monteleone 
 wrote:  
 
 Unfortunately, there is no simple and clean answer to this, but here are the 
easier options while keeping the book all together. (instead of separate files 
for each or collection of years)

#1 - Preferences > Register Defaults > Number of Transactions, might be useful 
but you can’t spec a date, you have to guess a number of transactions. A good 
RFE would be to change this to, or add a date option that applies to all 
registers.

(note, the General Journal defaults to showing only the last 30 days, but for 
all accounts, and I don’t think it is persistent.)

#2 - View > Filter By... > Date > Number of Days *or* Date Range, is what you 
are likely looking for, make sure to use the ’Save Filter’ option at the bottom 
or you’ll have to reset it when you re-open that register.

#3 - View > Filter By... > Status, adjust as needed. (and save the filter) This 
might be a good option to use to not show reconciled transactions for example, 
cutting down on anything that isn’t still pending.

You have to set #2/3 to each register independently.

I wouldn’t recommend creating separate yearly asset accounts, but whatever 
works for you...

Regards,
Adrien

> On Mar 21, 2020 w12d81, at 1:07 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I've got data from 1/1/2018 to date in one particular GC file. Tons of 
> transactions
> I would like to have a new GC file with just 2020 transactions it it.
> Is there an easy way to do this without having to "initialize" the entity in 
> the new file from scratch?
> I'm thinking about things like equity, liabilities, assets, expense accounts, 
> customers, AP, AR, and everything else.
> alternately is there a way to archive all the 2018 & 2019 transactions so 
> they are still in the system but you don't have to scroll through a zillion 
> transactions in the check register to navigate top to bottom.
> Or... maybe a solution for the big fat check register is to create a new 
> asset account called 2020 checking.
> thanks for any help.


___
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] How to start a new GC file for a new year?

[Fran_3 via gnucash-user]

I've got data from 1/1/2018 to date in one particular GC file. Tons of 
transactions
I would like to have a new GC file with just 2020 transactions it it.
Is there an easy way to do this without having to "initialize" the entity in 
the new file from scratch?
I'm thinking about things like equity, liabilities, assets, expense accounts, 
customers, AP, AR, and everything else.
alternately is there a way to archive all the 2018 & 2019 transactions so they 
are still in the system but you don't have to scroll through a zillion 
transactions in the check register to navigate top to bottom.
Or... maybe a solution for the big fat check register is to create a new asset 
account called 2020 checking.
thanks for any help.





___
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] 1) How to "jump" to a date in ck register? 2) Form for writing a check? 3)finding checking transactions to apply to bills?

[Fran_3 via gnucash-user]

 1) Using Find to lookup a transactions by date range results in a split view 
of each transaction... is there a way to have this appear as the check register 
does with one transaction per line?

2) Entering a new random check at the bottom of the check register works but is 
a little tedious.
It would be nice to have a popup form accessible by a shortcut key to create a 
new random check... i.e. not a bill payment but just an incidental check for 
gas or some  local purchase.

3) I have 200 or 300 checking account transactions that were imported and now 
need to "assign as payment" but they are buried in a 1,000 plus other imported 
transactions that are incidental purchases that do not need to be "assigned as 
payment."

The problem is finding those checking transactions that do need to be "assigned 
as payment" without having to grind through all the other transactions in the 
register line by line.

Possibly I can export the check register as a csv file, import it into a 
spreadsheet, and come up with some search algorithm to mark them and then sort 
on that mark. I will explore that technique.

Also, for others doing large imports... in this case many bills were paid via 
credit or debit card so there is no check number. That occured to me half way 
through the import so I started coding a number in the check number field to 
indicate "Bill Payment" so with regards to those transactions, I should be able 
to find them and "assign as payment" quite easily.

Wish I had thought of that at the outset... 2020 hind site.
Thanks again for the help.



On Monday, March 16, 2020, 6:17:04 PM EDT, Adrien Monteleone 
 wrote:  
 
 
> On Mar 16, 2020 w12d76, at 4:53 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> 1) If I want to jump to a place in the check register... as opposed to find a 
> transaction... say I want to jump to 2-12-2019 and see transactions in that 
> area... is there a way to do this other than grabbing the mouse and scrolling 
> up and down the register?

Not that I’m aware of, but if it does exist, it will be covered in the Help 
document.

Not sure about Win or Linux, but on Mac CMD-Up or CMD-Down jumps up and down 
transactions rapidly. (you can also hold it down)

If you know you want to work within a certain date range, or starting or ending 
with one, you could use Edit > Filter. (or do a Find for dates)


> 2) Is the a form and a shortcut key for simply creating a new check as 
> opposed to paying a bill?Other than going to the bottom ot the check register 
> and entering it there?

If you mean to ‘Process a Payment’ to a bill or invoice, I don’t think so. 
There is a such a window (via the Invoice toolbar, or via Business > 
Customer/Vendor) but I don’t know how to bring it up via the keyboard. (again, 
check the Help file) Those shouldn’t be entered directly in a register anyway 
under normal circumstances, but that can be fixed if they already exist. (see 
below on #3)

The Action menu has a ‘Blank Transaction’ entry that will jump to the next open 
transaction. There is also a ‘Blank’ toolbar button that does the same thing. 
(a keyboard shortcut would be nice, allegedly on Mac, it is supposed to be 
CMD-Down, but it only moves one transaction rather than to the blank one)


> 3) I've imported a bunch of checking transactions in to gnuCash, many of 
> which were bill payments. Now I have to find those transactions that have yet 
> to be applied to pay a bill. Is there an easy way to do this?

The process for each one is to find it in the check register, right-click and 
choose ‘assign as payment’ then select the bill you want to assign it to, etc.

As for ‘finding’ them, that depends on what kind of info is entered into them. 
The Find facility is pretty useful if you have some common text or other info 
you can search on. Also, don’t forget the usefulness of an exclusionary search 
if that gets you a useable list that is more manageable.

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.

[GNC] 1) How to "jump" to a date in ck register? 2) Form for writing a check? 3)finding checking transactions to apply to bills?

[Fran_3 via gnucash-user]

1) If I want to jump to a place in the check register... as opposed to find a 
transaction... say I want to jump to 2-12-2019 and see transactions in that 
area... is there a way to do this other than grabbing the mouse and scrolling 
up and down the register?
2) Is the a form and a shortcut key for simply creating a new check as opposed 
to paying a bill?Other than going to the bottom ot the check register and 
entering it there?
3) I've imported a bunch of checking transactions in to gnuCash, many of which 
were bill payments. Now I have to find those transactions that have yet to be 
applied to pay a bill. Is there an easy way to do this?
thanks for any help.

___
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] How to balance checking account in GC?

[Fran_3 via gnucash-user]

First, since IANAA I'm unsure if there is a difference in "reconciling" your 
checking account vs "balancing" your checking account...
The later used by me to note that I've matched the bank statement to my entries 
in the check register and both now show the same balance as of the last 
transaction...
So in my question below I'm going to call this job "Balancing" the Checking 
Account.
The Question: Does GC have a built in tool to help balance a checking account?
Like maybe import the bank statement as a csv or whatever and automatically try 
to find transactions that are either missing or do not match the corresponding 
GC entry?
A technique I have used is to1 - Download banking transactions to a csv & then 
import them into a spreadsheet.2 - Then export GC checking transactions as csv 
& then import that into another tab on the spreadsheet3 - Then on another 
spreadsheet tab copy and paste bank transactions and GC transactions side by 
side4 - Then try and match them up to find any missing transactions
But this is hard work if you have a lot of transactions.
Alternately you could print out the bank transactions and while looking at the 
GC Checking Account use the "R" Reconciliation column in the check register to 
mark those that have cleared the bank... 
But I've been apprehensive about using the "R" column as I read that once a 
transaction is marked R for Reconciled... it becomes difficult to change if if 
the need arises.
Any tips on an easier way to go about balancing the check register to match the 
bank statement?

Thanks for any help.

___
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] How2find 1) Duplicate items imported 2)Un-Posted Bills?

[Fran_3 via gnucash-user]

 Thanks Adrian. 
I'll try and run a test on importing a duplicate checking transaction.In this 
case the transactions description may not match exactly and I assume that is 
one of the fields tested by GC to discover that the transaction is already in 
the system.The fields being imported are Date, Num, Description, Deposit, and 
Withdrawal
Good answer on finding unposted Bills.Thanks again

On Tuesday, February 18, 2020, 6:45:53 PM EST, Adrien Monteleone 
 wrote:  
 
 I’m not sure about flagging, but it shouldn’t create a duplicate.

As for the finding unposted bills, do a Business > Vendors > Find Bill and set 
criteria of “Is Posted?” to unchecked.

Regards,
Adrien


> On Feb 18, 2020 w8d49, at 4:05 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> 1) When importing or entering checking transactions does gnuCash flag 
> importing a transaction that is already in the system?
> 2) How do you find Un-Posted bills.
> Thanks for any help.

___
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] How2find 1) Duplicate items imported 2)Un-Posted Bills?

[Fran_3 via gnucash-user]

1) When importing or entering checking transactions does gnuCash flag importing 
a transaction that is already in the system?
2) How do you find Un-Posted bills.
Thanks for any help.
___
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 change MANY Deposits to Withdrawals? (Import error)

[Fran_3 via gnucash-user]

 I found the GC file before I did the big import and am all set to try it 
again... but on a copy of that backup GC file, of course :-)
But, I'm done for today so I'll do the import in small chunks in the morning 
and report back.
Thanks everyone for the help.

On Sunday, February 16, 2020, 5:30:32 PM EST, David Cousens 
 wrote:  
 
 Have you checked the directory that contains your data file for previous
automatically created backup files created whenever the GnuCash program is
exited and restarted?. If one of these is timestamped before your large
import you may be able to recover to the point before the import. Apart from
saving a copy explicitly I generally exit and restart the program when I am
going to be importing reasonable quantities fo data.

https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
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 change MANY Deposits to Withdrawals? (Import error)

[Fran_3 via gnucash-user]

 Ah Ha! That must be where I took the wrong fork in the road. Thanks, good info.

On Sunday, February 16, 2020, 2:50:06 PM EST, David Carlson 
 wrote:  
 
 When importing, the sign overrides the column name, so a negative
withdrawal becomes a deposit.

David Carlson

On Sun, Feb 16, 2020, 1:33 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 2/16/2020 11:28 AM, Fran_3 via gnucash-user wrote:
> > I imported a big bunch of checking transactions and guess I got the
> Deposit & Withdrawal columns labeled wrong during the import process.
> > Is there any way to select a bunch of checking transactions and change
> Deposits to Withdrawals?
> > Thanks for any help.
>
> Horse and barn doors, but this is worth pointing out. Take checkpoints.
>
> In other words, before doing a large import of data, make a backup copy
> of the file. Then, as in a case like this, you can easily back out the
> faulty import.
>
> 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.
  
___
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 change MANY Deposits to Withdrawals? (Import error)

[Fran_3 via gnucash-user]

 Well, turns out I did have a copy of the GC file just before import :-)And I 
have the data ready to import again.I can experiment and find this out but my 
question now is... 

Does the sign need to be minus for Withdrawals?
I think, when I originally imported the 663 transactions I may have had both 
the Deposit & Withdrawal columns populated with positive numbers...
Our bank puts deposits & withdrawals in the same column with a negative sign 
for withdrawals...
Preparing the spreadsheet for import into GC I used 
=if(A2>0, A2,) to get the positive numbers into the Deposit column and then 
used=if(A2<0, A2,) to get the negative numbers into the Withdrawal field.So the 
withdrawal column should have the negative sign in front of each 
withdrawal...Maybe GC wants both to be positive and uses the Column Heading to 
figure things out... I'm not sureI'll experiment
Anyway thanks for talking me through this guys :-)
Wish me luck.


On Sunday, February 16, 2020, 1:27:33 PM EST, David Carlson 
 wrote:  
 
 In the future,  be sure to save a copy of the file just before importing! 
David Carlson 
On Sun, Feb 16, 2020, 12:14 PM Fran_3  wrote:

 They are the last 663 checking transactions and they were already saved 
gnuCash and its going to be hard to go back to an earlier version.
My plan is to export those last 633 transactions and edit them in a 
spreadsheet... which I've already doneand I ended up with just 5 columns...  
Date, Num, Description, Deposit, Withdrawal
Next I need to delete the last 633 transactions from the check register but I 
have not been able to select multiple checking transactions...
Any idea on how do select multiple checking transactions so you can just delete 
them all at once?
Thanks for the help !

On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson 
 wrote:  
 
 The easiest way is to close gnucash without saving to abandon the current data 
and import again.  
If you saved the file with the incorrect import, close it and open the last 
save before the import.
If you didn't notice the error until much later, there is no mass correction 
possible, but you could import again if it was a qif import then delete the 
ones that are wrong. 
David Carlson 
On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user 
 wrote:

I imported a big bunch of checking transactions and guess I got the Deposit & 
Withdrawal columns labeled wrong during the import process.
Is there any way to select a bunch of checking transactions and change Deposits 
to Withdrawals?
Thanks for any help.

___
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 change MANY Deposits to Withdrawals? (Import error)

[Fran_3 via gnucash-user]

 They are the last 663 checking transactions and they were already saved 
gnuCash and its going to be hard to go back to an earlier version.
My plan is to export those last 633 transactions and edit them in a 
spreadsheet... which I've already doneand I ended up with just 5 columns...  
Date, Num, Description, Deposit, Withdrawal
Next I need to delete the last 633 transactions from the check register but I 
have not been able to select multiple checking transactions...
Any idea on how do select multiple checking transactions so you can just delete 
them all at once?
Thanks for the help !

On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson 
 wrote:  
 
 The easiest way is to close gnucash without saving to abandon the current data 
and import again.  
If you saved the file with the incorrect import, close it and open the last 
save before the import.
If you didn't notice the error until much later, there is no mass correction 
possible, but you could import again if it was a qif import then delete the 
ones that are wrong. 
David Carlson 
On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user 
 wrote:

I imported a big bunch of checking transactions and guess I got the Deposit & 
Withdrawal columns labeled wrong during the import process.
Is there any way to select a bunch of checking transactions and change Deposits 
to Withdrawals?
Thanks for any help.

___
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] How to change MANY Deposits to Withdrawals? (Import error)

[Fran_3 via gnucash-user]

I imported a big bunch of checking transactions and guess I got the Deposit & 
Withdrawal columns labeled wrong during the import process.
Is there any way to select a bunch of checking transactions and change Deposits 
to Withdrawals?
Thanks for any help.

___
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] Importing Vendor Bills: Field Definitions Questions

[Fran_3 via gnucash-user]

Referring to the field definitions in
18.1. Importing Bills and Invoices
I tried to line those up with the three dialog boxes that come up as you create 
and post a new bill.
New Bill DialogEdit Bill DialogPost Bill Dialog (aka Question)
I think I have most of them properly associated but need help on a few...
   
   -
owner_id - Customer or vendor number. Mandatory in the first data row of an 
invoice. If not provided, all rows of the same invoice will be ignored.

I don't see "Owner ID" in any of those three screens... but I do see a field 
for the Vendors name in the "New Bill" Dialog.
However I do see it in the "Vendor Overview" list of vendorsI guess that means 
one would have to lookup the Vendor Number for each vendor's bill they are 
about to import.
(This is the case of having a clerk enter the bills into a spreadsheet so that 
a the GC admin could import them later... as when you don't want the data entry 
clerk to see all your financial data :-)

Now that I think about it that makes sense as the data entry clerk could 
misspell the vendors name or enter it differently than it is in the system... 
so maybe I just answered that one for myself.
Next I see these fields... again I couldn't find them in any of the three 
dialog boxes that appear when you are creating/entering a new bill... or did I 
miss them somewhere. Maybe somebody can point the discount fields out to me 
wherever they are.
   
   -
disc_type - Type of discount. Optional. Only relevant for invoices, not for 
bills. Use “%” or blank for percentage value, anything else for monetary value.

   -
disc_how - Discount how. Optional. Only relevant for invoices, not for bills. 
Use “>” for discount applied after tax, “=” for discount and tax applied before 
tax, and “<”, blank or anything else for discount applied before tax.

   -
discount - Amount or percentage of discount. Optional. Only relevant for 
invoices, not for bills

Another question... and maybe I missed it... but is there anyway to import 
bills from a CSV file but not have it automatically Posted?

Finally, for anyone interested...
These import fields match the "New Bill" Dialog fields...(except Billingid... 
which on the dialog is the Vendor Name field)

Id

Date_opened

owner_id

Billingid
Notes
These import fields match the Edit Bill Dialog fields(except I can find the 3 
Discount Type fields.)

Date

Desc

Action

Account

Quantity

Price

Disc_type

Disc_how

Discount

Taxable

Taxincluded

Tax_table


And finally these import fields match the Post Bill Dialog fields
Date_posted

Due_date

account_posted

Memo_posted

Accu_splits







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

Re: [GNC] Where to charge? Ins pays us, we pay vendor. Resolved

[Fran_3 via gnucash-user]

 Thanks Christopher, that is exactly what we did except in this case the 
insured was covered 100% so your $150 partial payment received would have been 
$200 full payment received.
Thanks again everyone for the help.

On Thursday, February 13, 2020, 5:23:29 PM EST, Christopher Lam 
 wrote:  
 
 This is what I would do: (I assume you're the patient attending the clinic). 
Say the clinic bills $200 and Medicare pays/prepays $150 ($50 co-pay). 

I believe the Expenses:Medical:Rebates is an expense contra-account? The 
GnuCash account type would still be EXPENSE, but would become more negative 
with time.

On Thu, 13 Feb 2020 at 16:34, Fran_3  wrote:

Here is the original scenario:1 - Doctor billed patient2 - Insurance paid 
patient3 - Patient paid doctor

1. Clinic bills patient    Create bill, include services rendered, post to AP   
 Expenses:Medical $200    A/Payable: -$200
2. Insurance pays patient    Expenses:Medical:Rebates -$150    Bank +$150
3. Patient pays clinic    A/Payable: +$200    Bank: -$200
   
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where to charge? Ins pays us, we pay vendor. Resolved

[Fran_3 via gnucash-user]

 Thanks Stephen. This is the first time I've seen a case like this... meaning 
insurance pays client before client gets a bill from the provider... etc... as 
far as I can remember. 
Regardless, this would have zero tax impact on the individual since it all 
netted to zero... IMO... but, like you, IANAA :-)
Thanks again for the help.


On Thursday, February 13, 2020, 03:28:32 PM EST, Stephen M. Butler 
 wrote:  
 
 On 2/13/20 11:12 AM, Fran_3 wrote:
> In this case the "Doctor" was actually a nationally known diagnostic &
> treatment clinic
> And the "Insurance Company" was Medicare.
> At that time the clinic accepted those insured by Medicare but it was
> not  "Medicare Assigned"
> What all that meant  effectively was the clinic sent the bill Medicare
> and later to the patient.
> Medicare sent the payment to the patient before the patient got the
> bill from the clinic.
> Then later, when the patient got the clinic bill they paid it with the
> money Medicare had sent them to pay the bill.
>
> Regardless of whether this was normal or not, is is the way it happened.
>
> In the "T" account example I provided it was charged initially to the
> medical expanse account
> But when the bill was paid that was offset so the net effect on the
> medical expense account was zero.
>
> But your suggestion seems like a good one to a non-account type..
> Is this what you suggested?
>
> Enter payment from insurance company:    Assign to Checking & Reimbursable
> Enter bill from the Clinic:    Assign to AP & Reimbursable
> Enter payment to the Clinic:    Assign to AP & Checking
>
> Question: Wouldn't a pre-payment be a liability as opposed to an Asset?
> Not that it would matter so long as it was reconciled... right?
> Just asking.
>
> Thanks for the help.


Wow!  I used to work for a medical claims processing company (PPO and
3rd Party Adjudication).  Rare to have payment before the bill!! 
Usually the insurance company would want proof you paid before they
would reimburse!

In this case I'm taking "not 'Medicare Assigned'" to be the equivalent
of "out-of-network".  But not exactly equivalent as normal insurance
wouldn't reimburse for out-of-network without some extenuating
circumstances.

As to the last question, yup.  But so is a negative Asset (a
Liability).  The main reason to split the two is to group accounts of
similar character (negative value vs positive value).  That way if an
account has the opposite sign from "normal", it stands out like a sore
thumb and needs to be researched. 

As to your three step approach, I'd probably combine the 2nd and 3rd
into one and skip the AP.  But your approach works and ensures that in
the end all three accounts net to zero [as would be the case if the
clinic where "Medicare Assigned" and you never saw any of the transactions.

But, fair warning, my background is software development, database
administration and project management.  I've had to write accounting
software in the past so have some insight into the mind of the finance
folks.

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