[GNC] Manually edit pmt info (reverse a payment) for a vendor?
I'm just getting started entering in 2022 data. I made some mistakes in using Accounts Payable and Credit Cards. The amounts in those accounts are accurate, but only because I deleted erroneously posted transactions. However, I have two vendors which show "prepayment" amounts when I do a vendor report. Is there a way to manually change that data? Since I only have one transaction entered for each of those vendors, and I'm just getting started, I would not be opposed to just deleting those vendors and their associated bills (invoices) and starting over (now that I better understand how AP and Credit Cards work. Is it possible to delete all transactions related to a vendor and then delete the vendor? How? Or maybe I could somehow enter in a "debit memo" for the vendor (i.e., another bill) that would zero out the amount now listed as prepayment. But then how would I "pay" it such that the prepayment is applied to it? Thank you for helping me correct my newbie errors! -- Eric Chapman GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz 6-Core Intel Core i7) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manually edit pmt info (reverse a payment) for a vendor?
I think I have a plan: I will just start the whole year over. I only had a few transactions entered, so I'll copy the chart of accounts to a new file and start anew. :) On 3/2/23 12:36, Eric Chapman wrote: I'm just getting started entering in 2022 data. I made some mistakes in using Accounts Payable and Credit Cards. The amounts in those accounts are accurate, but only because I deleted erroneously posted transactions. However, I have two vendors which show "prepayment" amounts when I do a vendor report. Is there a way to manually change that data? Since I only have one transaction entered for each of those vendors, and I'm just getting started, I would not be opposed to just deleting those vendors and their associated bills (invoices) and starting over (now that I better understand how AP and Credit Cards work. Is it possible to delete all transactions related to a vendor and then delete the vendor? How? Or maybe I could somehow enter in a "debit memo" for the vendor (i.e., another bill) that would zero out the amount now listed as prepayment. But then how would I "pay" it such that the prepayment is applied to it? Thank you for helping me correct my newbie errors! -- Eric Chapman GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz 6-Core Intel Core i7) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manually edit pmt info (reverse a payment) for a vendor?
This sounds like a good solution for your situation. I recommend the complementary idea: saving a copy of your active book as a test book, doing experiments in that test book to see how things actually work, then deleting the test book, and redoing the actual transactions in the active book. It is only a little time and effort to make a test book, and it can save you having to undo mistakes in the active book. Best regards, —Jim DeLaHunt On 2023-03-02 10:07, Eric Chapman wrote: I think I have a plan: I will just start the whole year over. I only had a few transactions entered, so I'll copy the chart of accounts to a new file and start anew. :) On 3/2/23 12:36, Eric Chapman wrote: I'm just getting started entering in 2022 data. I made some mistakes in using Accounts Payable and Credit Cards. The amounts in those accounts are accurate, but only because I deleted erroneously posted transactions. However, I have two vendors which show "prepayment" amounts when I do a vendor report. Is there a way to manually change that data? Since I only have one transaction entered for each of those vendors, and I'm just getting started, I would not be opposed to just deleting those vendors and their associated bills (invoices) and starting over (now that I better understand how AP and Credit Cards work. Is it possible to delete all transactions related to a vendor and then delete the vendor? How? Or maybe I could somehow enter in a "debit memo" for the vendor (i.e., another bill) that would zero out the amount now listed as prepayment. But then how would I "pay" it such that the prepayment is applied to it? Thank you for helping me correct my newbie errors! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manually edit pmt info (reverse a payment) for a vendor?
However .. learning how to properly correct something like this should be on your agenda. In the not distant future you are likely to be faced with something like this when you have many transactions already entered (and so would not want to have to be re-starting from scratch) Precisely because you are now in a good position in that regard (could easily re-start from scratch) it would also be a good time to try to fix it. If you can;t get the fix right, can always revert to starting over (and so putting off learning how to fix till later). Up to you. Michael D Novack PS --- Your problem might have originated with HOW you earlier tried to ":fix" by DELETING transactions as opposed to having entered correcting transactions. Think back to the old days of pen and ink on paper in bound books. Never "deleted" anything once entered but fixed mistakes by an off setting transaction. On 3/2/2023 1:07 PM, Eric Chapman wrote: I think I have a plan: I will just start the whole year over. I only had a few transactions entered, so I'll copy the chart of accounts to a new file and start anew. :) On 3/2/23 12:36, Eric Chapman wrote: I'm just getting started entering in 2022 data. I made some mistakes in using Accounts Payable and Credit Cards. The amounts in those accounts are accurate, but only because I deleted erroneously posted transactions. However, I have two vendors which show "prepayment" amounts when I do a vendor report. Is there a way to manually change that data? Since I only have one transaction entered for each of those vendors, and I'm just getting started, I would not be opposed to just deleting those vendors and their associated bills (invoices) and starting over (now that I better understand how AP and Credit Cards work. Is it possible to delete all transactions related to a vendor and then delete the vendor? How? Or maybe I could somehow enter in a "debit memo" for the vendor (i.e., another bill) that would zero out the amount now listed as prepayment. But then how would I "pay" it such that the prepayment is applied to it? Thank you for helping me correct my newbie errors! -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] New Bill: way to change default "Date Opened"?
When entering a new bill, is there a way to change the default "Date Opened"? (Screenshot attached.) It defaults to today's date, but I'm entering old data. I would like it if it would default to the last entered date. Also … is there a way to change this date after it's been entered? It is grayed out later in the "Edit Bill" pane. Thanks! -- Eric Chapman GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz 6-Core Intel Core i7) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Any way to "unpay" (reverse payment of bill)?
One can unpost a bill from vendor, but if one has already clicked the "Pay" button and followed through with that, the bill still looks as if it is "paid" in the vendor report. Can I "unpay" a bill? I'm paying by credit card, so it's really not that I'm unpaying (which one could never do if a check were already issued or a wire transfer initiated). My problem has to do with GnuCash's aggravating default dates. I enter a bill from January 2022, and when I click "Pay", GnuCash automatically inserts today's date, even though it was paid via credit card months ago. Thanks for your advice! -- Eric Chapman GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz 6-Core Intel Core i7) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Any way to "unpay" (reverse payment of bill)?
Two options: 1) correct the date on the payment transaction, or 2) just delete the payment transaction -derek On Thu, March 2, 2023 4:42 pm, Eric Chapman wrote: > One can unpost a bill from vendor, but if one has already clicked the > "Pay" button and followed through with that, the bill still looks as if > it is "paid" in the vendor report. Can I "unpay" a bill? > > I'm paying by credit card, so it's really not that I'm unpaying (which > one could never do if a check were already issued or a wire transfer > initiated). > > My problem has to do with GnuCash's aggravating default dates. I enter a > bill from January 2022, and when I click "Pay", GnuCash automatically > inserts today's date, even though it was paid via credit card months ago. > > Thanks for your advice! > > -- > Eric Chapman > GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz > 6-Core Intel Core i7) > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New Bill: way to change default "Date Opened"?
Hi, On Thu, March 2, 2023 4:20 pm, Eric Chapman wrote: > When entering a new bill, is there a way to change the default "Date > Opened"? (Screenshot attached.) It defaults to today's date, but I'm > entering old data. I would like it if it would default to the last > entered date. No. > Also … is there a way to change this date after it's been entered? It is > grayed out later in the "Edit Bill" pane. Yes. Click on the "Edit Bill" button so it pops up the dialog where you can edit that field. -derek > Thanks! > > -- > Eric Chapman > GnuCash 4.13 on MacOS 13.1 Ventura running on 2018 Mac Mini (3.2 GHz > 6-Core Intel Core i7) > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Any way to "unpay" (reverse payment of bill)?
In addition to Derek's options, you can leave the payment after unposting the bill, and then from a register containing that payment (usually the source account), right-click and choose 'Assign as Payment' where you can then edit the date, as well as change, if desired, which bill it applies to. Regards, Adrien On 3/2/23 3:42 PM, Eric Chapman wrote: One can unpost a bill from vendor, but if one has already clicked the "Pay" button and followed through with that, the bill still looks as if it is "paid" in the vendor report. Can I "unpay" a bill? I'm paying by credit card, so it's really not that I'm unpaying (which one could never do if a check were already issued or a wire transfer initiated). My problem has to do with GnuCash's aggravating default dates. I enter a bill from January 2022, and when I click "Pay", GnuCash automatically inserts today's date, even though it was paid via credit card months ago. Thanks for your advice! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Manually edit pmt info (reverse a payment) for a vendor?
Start over if you want, but editing and re-assigning payments is a simple enough process. If you want to go that route instead (or find you need to do it again) then say so and we can help. Regards, Adrien On 3/2/23 12:07 PM, Eric Chapman wrote: I think I have a plan: I will just start the whole year over. I only had a few transactions entered, so I'll copy the chart of accounts to a new file and start anew. :) On 3/2/23 12:36, Eric Chapman wrote: I'm just getting started entering in 2022 data. I made some mistakes in using Accounts Payable and Credit Cards. The amounts in those accounts are accurate, but only because I deleted erroneously posted transactions. However, I have two vendors which show "prepayment" amounts when I do a vendor report. Is there a way to manually change that data? Since I only have one transaction entered for each of those vendors, and I'm just getting started, I would not be opposed to just deleting those vendors and their associated bills (invoices) and starting over (now that I better understand how AP and Credit Cards work. Is it possible to delete all transactions related to a vendor and then delete the vendor? How? Or maybe I could somehow enter in a "debit memo" for the vendor (i.e., another bill) that would zero out the amount now listed as prepayment. But then how would I "pay" it such that the prepayment is applied to it? Thank you for helping me correct my newbie errors! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Plaid
Vanguard doesn't provide ability to download OFX formatted data as a download option but there is indirect way to get it. I have been happily downloading so using something called PocketSense which I have mentioned in the past here. It can be found here: https://sites.google.com/site/pocketsense/home/msmoneyfixp1. It is quite simple to setup actually and happily works with Vanguard and Fidelity and number of others financial providers. I also believe ofxget is likely to work as well although I have not tried with it. Sadly, I do agree that download-you-data landscape for finances in the US is just broken and likely to stay that way. -- Message: 5 Date: Wed, 1 Mar 2023 08:26:12 -0800 From: Jean L To: Steve Brown , gnucash-user@gnucash.org Subject: Re: [GNC] Using Plaid Message-ID: <5f7b6e1c-6043-44df-033f-4c702e4eb...@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed And now, vanguard apparently no longer offers OFX as a download option, just csv files. >:( hopefully this is temporary, but I'm not holding my breath. The entire download-you-data landscape for finances in the US is just broken Jean On 3/1/2023 2:51 AM, Steve Brown wrote: > This is interesting. > > https://www.plaidsettlement.com/ > > This prompted me to look at a Quicken OFX log after downloading > investment transactions from Raymond James. That log stays traffic > comes from > > https://directconnect.rjf.com/eftxweb/access.ofx > > but the traffic really comes from > > https://services.quicken.com/ofx-secure-plus > > Third parties collecting your bank credentials and sniffing your > financial traffic, what can go wrong? > > Steve > > On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote: >> To me it's very different.? You're not giving a user name and a >> password >> to AQBanking. I started using Plaid, then got really spooked by the >> fact >> that they do have access to your account as if they were you. Removed >> my >> account and canceled my keys. >> There are no current alternatives at the moment, unlike in Europe >> where >> there seem to be, I believe mandated by the EU. >> I wrote automated scripts to scrape my banks for the OFX files, but >> that's a royal pain in the butt, and it's not robust at all. >> >> Jean >> >> On 2/28/23 3:44 PM, Ben Pracht wrote: >>> ? I read that disclaimer. It says to keep the token secure and yes, >>> the >>> bearer of that token gets access. As they said: >>> "The access token generated by using this tool is sensitive >>> material as it >>> grants access to your accounts. It should be handled with care and >>> protected from unauthorized access. You must be sure to store it in >>> such a >>> way that makes it impossible for others to gain access. The >>> creators and >>> maintainers of Plaid2QIF are in no way responsible if you mishandle >>> your >>> access token." >>> >>> GIving Plaid2QIF this token is no different than me giving a >>> username and >>> password to AQBanking, except that Plaid has a chance of working. I >>> don't >>> like having an intermediary, in this case Plaid and Plaid2QIF, but >>> OFX is >>> unusable, and at the moment, AQBanking isn't even showing the list >>> of banks >>> anymore. Does anyone know of a US bank or credit union that uses a >>> modern >>> REST based API that they actually share with developers? >>> >>> Regards, >>> Ben >>> >>> On 2/22/23 23:08, john wrote: >>> >>> On Feb 22, 2023, at 2:01 PM, Ben Pracht >>> ? wrote: >>> >>> I'd like to use Plaid with GnuCash. There is a plaid2qif project >>> that >>> claims to have been extensively tested with GnuCash and Plaid. >>> However, >>> when I created the Plaid account, it asks for either a limited >>> developer >>> account or a production account with a compliance audit. What >>> account type >>> should I use? Anything else helpful to know? >>> >>> >>> Neither. See >>> https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md >>> , >>> >>> Pay particular attention to the disclaimer at the bottom of that >>> page. >>> >>> Regards, >>> John Ralls >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.
Re: [GNC] Can't complete "To-Create" scheduled transaction in "Since Last Run"
On Wed, Mar 1, 2023 at 3:00 AM rsbrux via gnucash-user < gnucash-user@gnucash.org> wrote: > I have a scheduled transaction involving two currencies: a charge in EUR > which is charged to a CHF credit card. > > This has worked in the past. > > When the "Since Last Run" dialog appears, it lists this transaction > under "To-Create" and shows: > EUR <-> CHF(Need value) > > When I click on "(Need value)", it turns into what appears to be a text > edit field, where I usually enter an exchange rate. > > However, today, no value was accepted, leaving me unable to close the > "Since Last Run" dialog with "OK". > The Scheduled Transaction explicitly disallows automatic transactions to any accounts requiring exchange rates. Here's how to verify this -- pick a transaction with exchange rates you've already entered in the past and choose Actions --> Schedule. The Make Scheduled Transaction assistant window will come up. Set up your parameters. If you check the "Create automatically" checkbox, you'll get the following message: "Scheduled Transactions with variables or involving more than one commodity cannot be automatically created." It's a disappointment to me because one nonprofit I keep the books for makes a regular contribution to a mutual fund. I don't keep track of the mutual fund's value using GnuCash, but I set it up "properly" when I took over the bookkeeping, so every time I enter a new transaction for the mutual fund it uses the original (outdated) exchange rate. (I've never bothered to reconcile the mutual fund amounts to GnuCash's accounts.) SO I have to create each month's contribution to the mutual fund "manually" in the non-profit organization's checking account. HOWEVER one part of that warning from GnuCash is NOT correct. As you have discovered, you CAN create automatic transactions with variables (I use them all the time). The Since Last Run dialog DOES prompt you (as you have seen) for the value in the variable. HOWEVER it apparently doesn't catch and warn you when you've edited the Template Transaction to try to make it work with exchange rates. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Easier way to import PayPal CSV
I have a major nightmare on my hands. My wife has a PayPal account that she uses for both personal and business use (stab me right here multiple times, she uses accounts that I know about and several ones that I do not). Problem #1: I have no idea what financial institution she used, except the 3 I have access to. Problem #2: Determining business vs personal expense. Problem #3: PayPal transaction descriptions are only a little less cryptic than the financial institutions I have access to. Problem #4: Never can remember whether the gross from PayPal is a credit or debit to account:PayPal in the CSV import. Or whether to use Balance affecting or all-transactions. I used to have a script that would sort most of this mess out, and put it in all proper upper/lower case/foreign language (I edited it multiple times and somewhere introduced a heap error that I cannot locate). I assume that an account PayPal:Imbalance would be the right course for where I do not know where the funds came from. Right now I have the institutions that I know of throw all transactions into PayPal:Bank. And PayPal import throw All payments to financial institutions there as well, otherwise to PayPal:Expense. That means copy and paste between accounts to get things right. A major pain in the a$$ since I have to copy and paste from two separate accounts. Problem #4 rears it's head here in the midst of #2. I have to manually match the PayPal payments/returns individually. Especially since PayPal may have the actual company name in it's native language and what was actually shipped (generally in English). Then Problem #2, personal or business. Which get thrown into PayPal:Expense until I figure out which expense account it really goes to. The CSV format generally provides enough information, but not always, to determine if is a business or personal expense. Including who from and what for. Confused yet, I am. There has to be a simpler way to import PayPal CSV to preserve my insanity from escalating to the next level, beserkergang! And because I can never seem to remember it, is the gross sale amount a debit or credit to the PayPal account from the CSV (still assigned as a credit card since that was all she originally had). Signed, Driving fence posts with my forehead. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
