Re: [GNC] Gnucash on MacOs Catalina
Looks like I had to drag the download into the applications folder via the finder window and replace instead of keep both. That seems to have worked. Really appreciate everyone's advice! -- 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.
Re: [GNC] Small business accounting importing transactions
Rob, The basic idea is OK but you are not creating 2 additional transaction, but adding the additional splits to the transaction recording the sale, or at least that is what you will need to be doing. A single transaction can have 2 or more entries to different accounts referred to as splits in GnuCash documentation and that is what Stephen and I had suggested. GnuCash has a multisplit multiline CSV format for importing Data like this. I am currently updating the documentation on using this so you won't find it completely described in the Help manual or Guide yet although the Help manual is the most recently updated. The wiki https://wiki.gnucash.org/wiki/CSV_Import/Export has a very brief description of the multiline multisplit CSV import process but it does describe the fields. I have attached a copy of a test file for a multiline-multisplit export form GnuCash (Gnucash Export Format) which I am using to document the import process. It will give you the basic csv format for the second and subsequent lines ofthe multisplit format. The wiki seems to suggest that the transactionID is essential to import multisplit data but I have yet to test whether that is the case and just which fields I can leave out and still manage to import the data in mutlisplit format. The wiki does have a list of the mandatory fields which have to be present in the record. The transaction ID as AFAIK is a Globally Unique ID or UUID as described in this wikipedia article (version 4, I think). Python has a UUID generator(https://docs.python.org/2/library/uuid.html) which should be OK for creating them in the hex format used in the import. Hope this is enopugh to get you headed in the right direction. I had originally intended to get the documentation done earlier this year but a couple of overseas trips and a couple of bouts of illness delayed my plans. David Cousens On Sat, 2019-11-30 at 12:01 -0500, Robert Slippey wrote: > David and Stephen, > > I wanted to circle back to this again and reach out directly to get your > thoughts on this. I was going through this > issue again in my mind and admittedly I'm a bit lazy. I'm also learning > Python slowly, so of course I put two and two > together. Was curious your thoughts. > > I might have missed something here but here is how I envisioned the script > working. > The script takes each transaction and splits it up into the following: > > Income from your sales account > Transfer to your bank account > Expense to your expense account > > Basically, I've turned 1 line in the CSV into 3 per transaction. > > https://github.com/rwslippey/square_transaction_parser > > > As previously discussed, this probably wouldn't help for multiple sales on a > single day and refunds are probably a no > go. > I know this is for square and we were talking stripe I'm moving things > off of square so everything is in square > right now... I'll need to make this for stripe if you guys think it's right. > Your thoughts? > > Thanks > On Wed, Nov 27, 2019 at 6:20 PM David Cousens > wrote: > > Rob, > > > > > > > > Not sure of the details of how Stripe operates but presume it is somewhat > > > > similar to paypal.How you record it will depend upon the detail of the > > > > procedure they use. I treat my Paypal account as a Liability account as I > > > > can also make payments from it. In my case it is directly connected to a > > > > bank account and my Paypal account has direct debit/credit access to that > > > > bank account and unless i have a positive balance in my Paypal account it > > > > will debit funds from my bank account as required. It is so long since I > > > > sold anything using it I cannot remember if it automatically credits funds > > > > received. If I remember correctly I had to manually transfer funds as > > > > required. As the balance in a Paypal account always has to be >=0, I should > > > > really treat it as an asset but I set it up as a Liability and as the > > > > balance is at or near 0 most of the time, so I am happy keeping it that > > way. > > > > My transactions are all imported as OFX from my bank and CSV from Paypal. > > > > > > > > My bank records only have the amount of any debits and/or credits to the > > > > paypal account and hence have no information pertaining to fees and charges. > > > > I only receive this when I download a CSV statement from Paypal which > > > > details the amounts received and fees and charges. I keep separate Income > > > > sub accounts and Expense subaccounts for the Paypal transactions. A sale > > > > would be recorded in the Paypal account as follows: > > > > > > > > Liability :Paypal Dr > > > > Income:Paypal Sales Cr > > > > Expenses: Paypal Fees and ChargesDr yyy > > > > > > > > where =yyy+ or you could consider this as two transactions > > > > > > >
Re: [GNC] automatic reconnaissance of a transaction
Just to be clear, when a user selects a file for import, it's transactions appear in the matcher dialog. This is where the user must correct whatever assignments are not done, or are done incorrectly. The matcher only learns from corrections made from within this dialog. Once the user is past this dialog, and the transactions have been imported and appear in a GnuCash register, if some error is found and gets corrected, the matcher doesn't learn from this correction, so it will likely fail the same way the next time. Kind regards, Greg Feneis (Pixel 3) On Wed, Dec 4, 2019, 07:39 Joffrey Bienvenue wrote: > Thanks for the update! > > Yeah I can understand when description changes but here I'm referring to > transactions that are always the same and never get automatched > > I'll look at the options you gave me. > > Cheers, > Joffrey > > On Tue, 3 Dec 2019 at 22:57, John Ralls wrote: > > > > > > > > On Dec 3, 2019, at 4:16 PM, Joffrey Bienvenue < > > joffrey.bienve...@gmail.com> wrote: > > > > > > Hello > > > > > > When I import transactions from my bank accounts, some transactions, > very > > > few in fact, are recognized by GnuCash. It used to be better at > > recognizing > > > but I find it's less and less. > > > > > > Is there a way to help that "reconnaissance" ? > > > > > > Some transactions I am registering are *always* posted in the same > > category > > > (eg. Expenses->Groceries) but it keeps on not being recognized. > > > > The matcher works mostly from descriptions. Have those changed > > significantly? > > > > There are two things you can do: Always update the matches and from time > > to time use Tools>Import Match Editor to remove obsolete matches that > might > > lead the match algorithm astray. > > > > If nearly all of your transactions will match descriptions exactly with > > their predecessors then the non-Bayesian matcher may work better, but in > > all other cases the Bayesian one will be better in the long run, though > it > > requires more training at the outset to start getting good matches and > > needs to be maintained by reviewing matches and correcting mismatches *in > > the matcher* to keep on track. > > > > Regards, > > John Ralls > > > > > > -- > -- > Je roule pour la santé des hommes. I ride for men's health > https://gentlemansride.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] automatic reconnaissance of a transaction
On 12/3/19 10:57 PM, John Ralls wrote: On Dec 3, 2019, at 4:16 PM, Joffrey Bienvenue wrote: Hello When I import transactions from my bank accounts, some transactions, very few in fact, are recognized by GnuCash. It used to be better at recognizing but I find it's less and less. Is there a way to help that "reconnaissance" ? Some transactions I am registering are *always* posted in the same category (eg. Expenses->Groceries) but it keeps on not being recognized. The matcher works mostly from descriptions. Have those changed significantly? There are two things you can do: Always update the matches and from time to time use Tools>Import Match Editor to remove obsolete matches that might lead the match algorithm astray. I have no such action under "Tools". I do have a Tools-->Import Map Editor, but it doesn't show any individual entries that can be changed. Version: 3.7 Build ID: 3.7+(2019-09-07) Finance::Quote: 1.47 openSUSE Tumbleweed Ken ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash on MacOs Catalina
3.7 Should have overwritten 3.3 when you dragged it over as they are both named Gnucash.app. MacOS should have asked you what to do, and you had the option to ‘keep both’ which you may have chosen. I’ve run 2 versions back and forth before, so that shouldn’t be an issue. But if you don’t need 3.3, then just remove it and see if that helps. Sometimes, it won’t launch after the first time the security warning pops up, but it should open after that even with a left-click in /Applications or your Dock. (or Launchpad) Try running from the command line in Terminal.app and see if there is any interesting output: /Applications/Gnucash.app/Contents/MacOS/Gnucash Also, try launching with Console.app open and see if any warnings or errors show up related to GnuCash. You can check Activity Monitor.app to see if it is still shown as running when it ‘disappears’. Finally, do you happen to use more than one monitor? Have you at some point set up a second monitor? (even if it is not connected now) Some users have noted that the app can open on a different physical screen for some reason and that it is indeed running, just not where they are looking for it. (on that note, make sure it isn’t in another workspace via MissionControl. You can assign apps to workspaces and it may have opened on one that isn’t current, though it should have switched to that space when it launched) Regards, Adrien > On Dec 3, 2019 w49d337, at 8:58 PM, joshn268 wrote: > > So my issue is this. I've dragged it into the applications folder to install. > However, once I click "Open" from the security warning, it just disappears. > I'm currently running version 3.3 - do I need to uninstall that first and > then install 3.7? I wouldn't think so and never have had to before... > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] automatic reconnaissance of a transaction
Thanks for the update! Yeah I can understand when description changes but here I'm referring to transactions that are always the same and never get automatched I'll look at the options you gave me. Cheers, Joffrey On Tue, 3 Dec 2019 at 22:57, John Ralls wrote: > > > > On Dec 3, 2019, at 4:16 PM, Joffrey Bienvenue < > joffrey.bienve...@gmail.com> wrote: > > > > Hello > > > > When I import transactions from my bank accounts, some transactions, very > > few in fact, are recognized by GnuCash. It used to be better at > recognizing > > but I find it's less and less. > > > > Is there a way to help that "reconnaissance" ? > > > > Some transactions I am registering are *always* posted in the same > category > > (eg. Expenses->Groceries) but it keeps on not being recognized. > > The matcher works mostly from descriptions. Have those changed > significantly? > > There are two things you can do: Always update the matches and from time > to time use Tools>Import Match Editor to remove obsolete matches that might > lead the match algorithm astray. > > If nearly all of your transactions will match descriptions exactly with > their predecessors then the non-Bayesian matcher may work better, but in > all other cases the Bayesian one will be better in the long run, though it > requires more training at the outset to start getting good matches and > needs to be maintained by reviewing matches and correcting mismatches *in > the matcher* to keep on track. > > Regards, > John Ralls > > -- -- Je roule pour la santé des hommes. I ride for men's health https://gentlemansride.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Gnucash on MacOs Catalina
So my issue is this. I've dragged it into the applications folder to install. However, once I click "Open" from the security warning, it just disappears. I'm currently running version 3.3 - do I need to uninstall that first and then install 3.7? I wouldn't think so and never have had to before... -- 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.