Re: [GNC] Redo account reconciliations
> The starting balance is computed from all the reconciled transactions "to > date". It *can* be safe to ignore the starting balance if, for example, a > transaction became unreconciled. For example, let's say you reconcile > from some starting balance X to a final balance of $1000. Then you > accidentally unreconcile a $100 transactions. If you try to re-reconcile > that same statement/date/ending-balance of $1000, it won't show X as the > starting balance, but something else (PROBABLY $900, but I'm not 100% > sure). But that's okay -- just ensure the ending balance is correct and > all the transactions that SHOULD be reconciled ARE reconciled. > > There is no way to get a transaction to reconciled status (y) manually -- > the only way is through a reconcile process. So if you have reconciled > transactions, that must've happened through a reconcile. > > I would recommend you just go ahead with March, ignore the starting > balance, enter the correct March ending balance, and see if the > reconciliation works (ensure you re-reconcile anything from earlier that > might have become unreconciled). > So I just want to build a bit on this answer. GNUCash doesn't have QBs reconciliation system - so don't equate the two. As an accountant who doesn't need to be handheld or leashed, I find GNUCash's system better than QBs - albeit there is room for improvement. However, I wouldn't recommend GNUCash to someone less comfortable with bare-ledger accounting - controls exist for a reason. I don't know how the backend works, but my experience is that the "Opening balance" is basically a running total of all the transactions marked "Reconciled" in that account. Whereas QB will _prevent_ you from attempting to reconcile August if July's reconciled balance differs from what it previously reconciled, GNUCash doesn't care - it just says "The transactions marked 'Reconciled' for this account total to $X." And that's good for when you have to go back and fix things... and know what you're doing. When you reconcile a transaction, again based on my experience, GNUCash toggles the "Reconciled" flag on the account _and_ inserts the reconciliation date. I personally like this because I can, say, start a fresh reconciliation for March having reconciled through August to pick up the transactions that _should_ have been in the March reconciliation but weren't because I readded them (or whatever). However, I need my calculator with me because I need to adjust the "closing balance" to reflect not the statement balance but what GNUCash's "running total" balance should be. Contrast this to having to undo every rec in QB back to March and redo every rec again. Still, as I said, there's room for improvement in GNUCash:1) Since the rec date gets stored with the Rec flag, GNUCash can have a function that unreconciles every transaction before a given rec date. This would be analogous to QB's batch rec undo. 2) One should be able to rec from the ledger as QB lets you do - and prompt for a rec date. Yes it's dangerous, poor practice, etc., but the GNU philosophy is not to leash the user. If a user wants to sudo rm -rf / their installation, GNU warns them first, but ultimately lets them. User knows best. If you want your computer to dictate what you're allowed to do with it, that's what Apple's for. I hope that helps a bit ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] QIF imports for security pricing
Hello GnuCash Dev and user community - Looking for answer to few questions related to GnuCash use, so I am hoping community can provide guidance. - Recently I tried to import a QIF file containing mutual fund transactions and pricing info into an investment account. The securities transactions in it imported fine but it appears that the importer skipped security prices that were also defined in that file. I tried same file with Quicken 2017 to make sure there were no errors in the file and it imported all data without any problem, and with a brand new clean GnuCash file and importing it. Price database do not show any pricing information either. Is this the intended behavior of the importer? - After importing transactions, I noticed that Present (USD), Cleared (USD), Reconciled (USD), and total (USD) columns in the account list displays zero for the value of the account or the individual security sub-account. Since these are non-public mutual funds, I am unable to get them downloaded via any of the financial sources nor do symbol exist for them. Is this the intended behavior? How should symbol for each mutual fund be specified? Is there a way to tell it to use the last provided price for the mutual fund to calculate total for that account and show in at least one of those columns? - Where can I find what is expected in the format of import prices from csv mechanism? Specifically I am getting tripped up with "From Namespace" column. I RTFM but I couldn't make sense out of this specific field. If there is any guidance on simply importing pricing via CSV that has three columns - date, mutual fund name, and price for that day - it would be appreciated. Look forward to replies. 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] One more question on treansaction taxes
Thanks ever s much Derek. That was the ticket - I had the tax table done, but each item was just linked to Liabilities. I didn’t drill down far enough for the tax accounts. Thanks! Nora -Original Message- From: Derek Atkins [mailto:de...@ihtfp.com] Sent: September 3, 2021 7:57 AM To: Nora Cc: gnucash-user@gnucash.org Subject: RE: [GNC] One more question on treansaction taxes Hi, On Thu, September 2, 2021 9:02 pm, Nora wrote: > Hi Derek, > > OK - Like I've done in QB, one invoice with the project name as the > customer and the units represent number of attendees and make partial > payments that represent the actual payments coming in with a note in the > memo field. Yes, that would work. The only downside is that it would not really give you easy access to the list of attendees who have not paid you, only the *number* of people who haven't paid. > ONE other question - I've tried entering a bill, with several > transactions, using the "tax" option and had previously added the > subaccounts - "Tax on Purchases" and "Tax on Sales" in my Liabilities > section as suggested. It did not automatically enter the total tax into > the correct sub account??? - just into Liabilities as a negative. What did > I do wrong or miss Did you create the necessary Tax Table first? You need to assign the tax %ages and Tax Holding accounts, and then you need to apply that Tax Table *AND* mark the Invoice/Bill line-item as "Taxable". > Nora -derek > > -Original Message- > From: Derek Atkins [mailto:de...@ihtfp.com] > Sent: September 2, 2021 7:52 PM > To: Nora > Cc: gnucash-user@gnucash.org > Subject: RE: [GNC] One Job - Many Customers > > Hi Nora, > > First, please remember to CC the list on all replies so that others can > chime in and help.. > > On Thu, September 2, 2021 5:09 pm, Nora wrote: >> Thanks Derek >> >> Are there any work-arounds - like treating the "job/program" as a >> purchase >> order??? >> i.e. the customers are "requesting" a program? >> Nora > > My understanding of what you are trying to do is combine invoices for > multiple customers into a single "project". GnuCash does not do that, and > I cannot think of any way to use the business features to do that. > > One thing you COULD do is have different A/R accounts "per project", and > then you would invoice each person towards the specific A/R account. But > that implies each person is paying to one A/R (project) -- you cannot > split a single invoice across multiple A/R accounts. > > The downside with this approach is that it is VERY easy to post to the > wrong account, and fixing that could be a lot of cleanup. > > Another option is to completely forego the business features of GnuCash > and just enter the transactions in manually with useful descriptions for > you to filter on later. > > You're right, though -- GnuCash does not have good "Project tracking". > When I wrote the business features nearly 20 years ago it just wasn't > something that I ever needed, so I didn't build it in. Honestly, I wrote > it for my (one-man) consulting firm. > > Good Luck, > >> Nora Zylstra-Savage >> >> >> Capturing Stories & Connecting Generations >> Writing Coach, Workshops & Content Editing >> www.story-lines.ca >> 519-853-1187 > > > -derek > >> >> >> -Original Message- >> From: Derek Atkins [mailto:de...@ihtfp.com] >> Sent: September 2, 2021 1:44 PM >> To: Nora >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] One Job - Many Customers >> >> Hi, >> >> I'm afraid a Job is really misnamed -- it's really a "Puchase Order" -- >> a >> way to link multiple Invoices. >> >> GnuCash's invoicing system really doesn't do what you are asking for. >> >> -derek >> >> On Thu, September 2, 2021 1:31 pm, Nora wrote: >>> Hi User Group, >>> >>> >>> >>> I've just joined and set up my chart of accounts and am ready to >>> process >>> jobs and customers etc. >>> >>> Currently you can have one customer to many jobs, But I want one job to >>> many >>> customers. >>> >>> >>> >>> My question: >>> >>> I run many different classes/programs/courses, each with several >>> students/customers attending. >>> >>> How do I set up the one "program"/job and then invoice or associate >>> all >>> the customers to that "program/job"? >>> >>> >>> >>> When I used quick books - I had one invoice to represent the program >>> associated to an income account, and just typed the names in a >>> description >>> field of the payees/attendees. The individual payments reduced the >>> invoice, >>> and I used the memo field to list who made the payment. I want to get >>> away >>> from this as each person is only listed in the memo field and I can't >>> easily >>> reconcile with the bank by name. >>> >>> >>> >>> Thanks so much for your help! >>> >>> Nora >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Nora Zylstra-Savage >>> >>> >>> >>> >>> >>> Capturing Stories & Connecting Generations >>> >>> Writing Coach, Workshops & Content Editing >>> >>> www.story-lines.ca >>> >>> 519-853-1
Re: [GNC] Deleting Scheduled Transactions
The checkbox in the scheduled transactions list is just for display. Edit the scheduled transaction and uncheck enabled on the Frequency tab, then click OK to complete the edit. Regards, John Ralls > On Sep 3, 2021, at 7:33 AM, Jack Frillman via gnucash-user > wrote: > > Your last suggestion got me what I wanted. > Thanks. > > BTW: I'm not able to uncheck the Enabled check box for some reason. Running > Version 4.4 on a Mac. I thought I did that before but I can't now for some > odd reason. > > > > On 9/3/21 9:03 AM, Derek Atkins wrote: >> HI, >> >> On Fri, September 3, 2021 8:54 am, Jack Frillman via gnucash-user wrote: >>> How do you delete/remove a scheduled transaction from the list of >>> scheduled transactions under the scheduled transaction tab? >> So just to be clear, you are trying to remove the full schedule (not >> existing, fired-off transactions from your CoA), right? You just want it >> to stop firing off in the future... >> >>> I tried unchecking the Enabled check box but that didn't do anything. I >>> tried the Delete button in the transaction editor and that didn't do >>> anything. I tried doing it from the calendar and had no luck. I checked >>> the GNUC documentation and didn't find anything on how to remove/delete >>> a scheduled transaction. >> Unchecking the Enabled box will cause the SX never to fire again, so it >> won't create new transactions in the future. >> >>> So how can I remove/delete a scheduled transaction? >> If you go to Actions -> Scheduled Transactions -> Scheduled Transaction >> Editor it brings up the SX page. From there you can click on the SX you >> want to delete and then click on the "Delete" toolbar item to delete the >> SX. >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> -derek >> > > -- > Old Unix programmers never die, they just mv to /dev/null > - Anonymous > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Deleting Scheduled Transactions
Your last suggestion got me what I wanted. Thanks. BTW: I'm not able to uncheck the Enabled check box for some reason. Running Version 4.4 on a Mac. I thought I did that before but I can't now for some odd reason. On 9/3/21 9:03 AM, Derek Atkins wrote: HI, On Fri, September 3, 2021 8:54 am, Jack Frillman via gnucash-user wrote: How do you delete/remove a scheduled transaction from the list of scheduled transactions under the scheduled transaction tab? So just to be clear, you are trying to remove the full schedule (not existing, fired-off transactions from your CoA), right? You just want it to stop firing off in the future... I tried unchecking the Enabled check box but that didn't do anything. I tried the Delete button in the transaction editor and that didn't do anything. I tried doing it from the calendar and had no luck. I checked the GNUC documentation and didn't find anything on how to remove/delete a scheduled transaction. Unchecking the Enabled box will cause the SX never to fire again, so it won't create new transactions in the future. So how can I remove/delete a scheduled transaction? If you go to Actions -> Scheduled Transactions -> Scheduled Transaction Editor it brings up the SX page. From there you can click on the SX you want to delete and then click on the "Delete" toolbar item to delete the SX. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting Scheduled Transactions
HI, On Fri, September 3, 2021 8:54 am, Jack Frillman via gnucash-user wrote: > > How do you delete/remove a scheduled transaction from the list of > scheduled transactions under the scheduled transaction tab? So just to be clear, you are trying to remove the full schedule (not existing, fired-off transactions from your CoA), right? You just want it to stop firing off in the future... > I tried unchecking the Enabled check box but that didn't do anything. I > tried the Delete button in the transaction editor and that didn't do > anything. I tried doing it from the calendar and had no luck. I checked > the GNUC documentation and didn't find anything on how to remove/delete > a scheduled transaction. Unchecking the Enabled box will cause the SX never to fire again, so it won't create new transactions in the future. > So how can I remove/delete a scheduled transaction? If you go to Actions -> Scheduled Transactions -> Scheduled Transaction Editor it brings up the SX page. From there you can click on the SX you want to delete and then click on the "Delete" toolbar item to delete the SX. > 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] Deleting Scheduled Transactions
How do you delete/remove a scheduled transaction from the list of scheduled transactions under the scheduled transaction tab? I tried unchecking the Enabled check box but that didn't do anything. I tried the Delete button in the transaction editor and that didn't do anything. I tried doing it from the calendar and had no luck. I checked the GNUC documentation and didn't find anything on how to remove/delete a scheduled transaction. So how can I remove/delete a scheduled transaction? -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] One more question on treansaction taxes
Hi, On Thu, September 2, 2021 9:02 pm, Nora wrote: > Hi Derek, > > OK - Like I've done in QB, one invoice with the project name as the > customer and the units represent number of attendees and make partial > payments that represent the actual payments coming in with a note in the > memo field. Yes, that would work. The only downside is that it would not really give you easy access to the list of attendees who have not paid you, only the *number* of people who haven't paid. > ONE other question - I've tried entering a bill, with several > transactions, using the "tax" option and had previously added the > subaccounts - "Tax on Purchases" and "Tax on Sales" in my Liabilities > section as suggested. It did not automatically enter the total tax into > the correct sub account??? - just into Liabilities as a negative. What did > I do wrong or miss Did you create the necessary Tax Table first? You need to assign the tax %ages and Tax Holding accounts, and then you need to apply that Tax Table *AND* mark the Invoice/Bill line-item as "Taxable". > Nora -derek > > -Original Message- > From: Derek Atkins [mailto:de...@ihtfp.com] > Sent: September 2, 2021 7:52 PM > To: Nora > Cc: gnucash-user@gnucash.org > Subject: RE: [GNC] One Job - Many Customers > > Hi Nora, > > First, please remember to CC the list on all replies so that others can > chime in and help.. > > On Thu, September 2, 2021 5:09 pm, Nora wrote: >> Thanks Derek >> >> Are there any work-arounds - like treating the "job/program" as a >> purchase >> order??? >> i.e. the customers are "requesting" a program? >> Nora > > My understanding of what you are trying to do is combine invoices for > multiple customers into a single "project". GnuCash does not do that, and > I cannot think of any way to use the business features to do that. > > One thing you COULD do is have different A/R accounts "per project", and > then you would invoice each person towards the specific A/R account. But > that implies each person is paying to one A/R (project) -- you cannot > split a single invoice across multiple A/R accounts. > > The downside with this approach is that it is VERY easy to post to the > wrong account, and fixing that could be a lot of cleanup. > > Another option is to completely forego the business features of GnuCash > and just enter the transactions in manually with useful descriptions for > you to filter on later. > > You're right, though -- GnuCash does not have good "Project tracking". > When I wrote the business features nearly 20 years ago it just wasn't > something that I ever needed, so I didn't build it in. Honestly, I wrote > it for my (one-man) consulting firm. > > Good Luck, > >> Nora Zylstra-Savage >> >> >> Capturing Stories & Connecting Generations >> Writing Coach, Workshops & Content Editing >> www.story-lines.ca >> 519-853-1187 > > > -derek > >> >> >> -Original Message- >> From: Derek Atkins [mailto:de...@ihtfp.com] >> Sent: September 2, 2021 1:44 PM >> To: Nora >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] One Job - Many Customers >> >> Hi, >> >> I'm afraid a Job is really misnamed -- it's really a "Puchase Order" -- >> a >> way to link multiple Invoices. >> >> GnuCash's invoicing system really doesn't do what you are asking for. >> >> -derek >> >> On Thu, September 2, 2021 1:31 pm, Nora wrote: >>> Hi User Group, >>> >>> >>> >>> I've just joined and set up my chart of accounts and am ready to >>> process >>> jobs and customers etc. >>> >>> Currently you can have one customer to many jobs, But I want one job to >>> many >>> customers. >>> >>> >>> >>> My question: >>> >>> I run many different classes/programs/courses, each with several >>> students/customers attending. >>> >>> How do I set up the one "program"/job and then invoice or associate >>> all >>> the customers to that "program/job"? >>> >>> >>> >>> When I used quick books - I had one invoice to represent the program >>> associated to an income account, and just typed the names in a >>> description >>> field of the payees/attendees. The individual payments reduced the >>> invoice, >>> and I used the memo field to list who made the payment. I want to get >>> away >>> from this as each person is only listed in the memo field and I can't >>> easily >>> reconcile with the bank by name. >>> >>> >>> >>> Thanks so much for your help! >>> >>> Nora >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Nora Zylstra-Savage >>> >>> >>> >>> >>> >>> Capturing Stories & Connecting Generations >>> >>> Writing Coach, Workshops & Content Editing >>> >>> www.story-lines.ca >>> >>> 519-853-1187 >>> >>> >>> >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Pleas