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

2022-03-22 Thread 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.

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

2022-03-21 Thread 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

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

2022-03-18 Thread 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"

Re: [GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

2022-03-18 Thread Fran_3 via gnucash-user
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 20

[GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

2022-03-17 Thread 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

[GNC] Recurring Monthly bills, How to Auto Post... TFN ?

2021-08-13 Thread 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

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

2021-05-13 Thread Fran_3 via gnucash-user
_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

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

2021-05-12 Thread 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

Re: [GNC] Need Transaction Report on Checking to show only Debits

2021-05-12 Thread Fran_3 via gnucash-user
: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. > ___

Re: [GNC] Need Transaction Report on Checking to show only Debits

2021-05-12 Thread Fran_3 via gnucash-user
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 t

Re: [GNC] Need Transaction Report on Checking to show only Debits

2021-05-11 Thread 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

[GNC] Need Transaction Report on Checking to show only Debits

2021-05-11 Thread 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:

Re: [GNC] How to use Reminders?

2020-12-09 Thread Fran_3 via gnucash-user
w, 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, 202

[GNC] How to use Reminders?

2020-12-09 Thread 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

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

2020-12-05 Thread 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? D

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

2020-12-05 Thread Fran_3 via gnucash-user
t, 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 gn

[GNC] Need help using Gnucash IRC to live chat

2020-12-05 Thread 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

[GNC] Looking for Point-of-Sale App suggestions & if any interface with GnuCash & How

2020-11-08 Thread 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

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

2020-10-26 Thread Fran_3 via gnucash-user
pplications 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 tha

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

2020-10-25 Thread Fran_3 via gnucash-user
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: O

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

2020-10-25 Thread 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

[GNC] how to set Bills Due Reminder Date Range?

2020-10-20 Thread 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

Re: [GNC] Make PDF from reports

2020-10-20 Thread 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

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

2020-10-18 Thread Fran_3 via gnucash-user
" > > 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 G

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

2020-10-18 Thread Fran_3 via gnucash-user
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 au

Re: [GNC] transaction report missing subtotals

2020-10-17 Thread 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

Re: [GNC] transaction report missing subtotals

2020-10-16 Thread 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

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

2020-10-16 Thread 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?

Re: [GNC] Will the file myStuff.gnucash work on Linux & Windows machines?

2020-10-11 Thread Fran_3 via gnucash-user
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 w

[GNC] Will the file myStuff.gnucash work on Linux & Windows machines?

2020-10-11 Thread 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

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

2020-10-09 Thread Fran_3 via gnucash-user
ness 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

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

2020-10-09 Thread 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.

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

2020-10-09 Thread 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

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

2020-10-08 Thread 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

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

2020-09-25 Thread Fran_3 via gnucash-user
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 s

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

2020-09-25 Thread 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.

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
lp 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 Repor

[GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread 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.

Re: [GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread Fran_3 via gnucash-user
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

[GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread 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

Re: [GNC] Need to - Mark Split as Un-reconciled - in GC 3.8

2020-09-17 Thread Fran_3 via gnucash-user
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

Re: [GNC] Need to - Mark Split as Un-reconciled - in GC 3.8 - Correction

2020-09-16 Thread 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 Transact

[GNC] Need to - Mark Split as Un-reconciled - in GC 3.8

2020-09-16 Thread 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"

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-15 Thread 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

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread Fran_3 via gnucash-user
e 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 e

[GNC] Subject Correction: How to import CSV into AP Register?

2020-09-14 Thread 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

[GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread 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

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

2020-09-11 Thread Fran_3 via gnucash-user
u 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 &g

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

2020-09-11 Thread 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 rep

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

2020-09-11 Thread Fran_3 via gnucash-user
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 misse

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

2020-09-11 Thread 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

[GNC] 1) search list 2) gnucash-u...@lists.gnucash.org vs gnucash-user@gnucash.org

2020-09-01 Thread 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

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

2020-08-27 Thread Fran_3 via gnucash-user
inks > 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: >

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

2020-08-27 Thread 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

Re: [GNC] Monthly Payments on posted Liability?

2020-08-24 Thread Fran_3 via gnucash-user
n 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

[GNC] Monthly Payments on posted Liability?

2020-08-24 Thread 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..

Re: [GNC] Can you move a Liability Account to a "sub-account" in Liabilities?

2020-07-30 Thread Fran_3 via gnucash-user
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

[GNC] Can you move a Liability Account to a "sub-account" in Liabilities?

2020-07-30 Thread 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--

[GNC] 1) list unpaid vendor bills only 2) delete vendor to delete all bills?

2020-07-22 Thread 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

Re: [GNC] How to remove or hide certain bills from appearing in the Due Bills Reminder?

2020-07-21 Thread Fran_3 via gnucash-user
, 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"

Re: [GNC] How to remove or hide certain bills from appearing in the Due Bills Reminder?

2020-07-20 Thread Fran_3 via gnucash-user
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:

[GNC] How to remove or hide certain bills from appearing in the Due Bills Reminder?

2020-07-20 Thread 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

Re: [GNC] Bills Due Reminder: Column titled "CN?" is what?

2020-07-20 Thread 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 tit

[GNC] Bills Due Reminder: Column titled "CN?" is what?

2020-07-20 Thread 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

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

2020-07-19 Thread 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 -

[GNC] How to find UnPosted Bill?

2020-06-19 Thread 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

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

2020-06-18 Thread 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

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

2020-06-18 Thread Fran_3 via gnucash-user
ice 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-us

[GNC] New Bill: Bill ID vs Billing ID

2020-06-16 Thread 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

[GNC] 1) View Transactions: Newest at Top 2) Larger Type

2020-06-12 Thread 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'

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

2020-06-10 Thread Fran_3 via gnucash-user
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

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

2020-06-09 Thread 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

Re: [GNC] Transaction Report Filter Questions

2020-05-22 Thread 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 "Ch

[GNC] Transaction Report Filter Questions

2020-05-20 Thread 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

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

2020-05-19 Thread 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 -

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

2020-05-19 Thread Fran_3 via gnucash-user
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 >

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

2020-05-19 Thread 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

Re: [GNC] How to "relaunch" Transaction Report Options Window

2020-05-19 Thread 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:

[GNC] How to "relaunch" Transaction Report Options Window

2020-05-19 Thread 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

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

2020-05-18 Thread 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

Re: [GNC] wells fargo downloads

2020-05-18 Thread 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

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

2020-05-18 Thread 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

Re: [GNC] Reconciliation "R" column question

2020-05-18 Thread Fran_3 via gnucash-user
'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 &g

[GNC] Reconciliation "R" column question

2020-05-18 Thread 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

[GNC] RegEx Case insensitive Search via Reports > Transaction Report > Transaction Filter ?

2020-05-09 Thread 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

Re: [GNC] How to start a new GC file for a new year?

2020-03-21 Thread Fran_3 via gnucash-user
nd 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 h

[GNC] How to start a new GC file for a new year?

2020-03-21 Thread 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,

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?

2020-03-16 Thread Fran_3 via gnucash-user
;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: &g

[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?

2020-03-16 Thread 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

[GNC] How to balance checking account in GC?

2020-02-29 Thread 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

Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?

2020-02-18 Thread Fran_3 via gnucash-user
> 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

[GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?

2020-02-18 Thread 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

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread 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,

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
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. > >

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
til 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 & Withdraw

Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread Fran_3 via gnucash-user
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

[GNC] How to change MANY Deposits to Withdrawals? (Import error)

2020-02-16 Thread 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.

[GNC] Importing Vendor Bills: Field Definitions Questions

2020-02-15 Thread 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

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

2020-02-15 Thread 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:

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

2020-02-13 Thread 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,

  1   2   >