Re: [GNC] Your Classification / Tagging Implementation
Yes, I'm pretty sure I've even included that use case in previous threads. Notes: transaction-wide tag Memo: tag just for that split Thus, you can tag individual memos and craft a Transaction Report for job costing no matter the nature of the original physical individual transactions. If you have issues with consistent spelling and capitalization of tags (which can be fixed with a search and then manual adjustments) you can employ regular expressions in the Filter field of the report Options. Regards, Adrien On 11/14/20 8:05 PM, doncram wrote: Gal and Adrien -- I'm curious, does "method 1", i.e. tagging, allow for transactions having splits with varying tags? E.g., it is very common for one entity i work with to have a purchase transaction at Home Depot with items to be charged to different jobs, so the total expense needs to be split out. Interfaces to allow for seeing and entering/selecting specific jobs are needed. E.g. checkbook register needs to allow for job field on each line. E.g. journal entry interface has to allow for a job field, so that, for example you could make a correction moving an expense from one job to a different job. Do you think it possible to use tagging as you do it, to serve for coding jobs until GnuCash explicitly allowed them? --Don ___ 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] Your Classification / Tagging Implementation
I'll pile on that in addition to including this filter in other reports for more utility, adding the NUM and Action fields to the filter would also make the feature more versatile. Regards, Adrien On 11/15/20 2:15 AM, Gal wrote: Transaction splits only expose 2 fields: action & memo, Transaction report lets you filter by memo field but not by action field. So yes, I think the tagging method can work for the use case you described, provided that you utilize the memo field. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to Manually Match transactions
Here is a very simple question but I can't figure out how to do this. I have searched the documentation and this mailing list. How do I manually match 2 transactions: I have 2 account that have had data imported via qfx. Account 1 (credit card) has a transaction on 2020-01-19 that is a payment for $amount which is the credit card payment from checking account Account 2 (bank account) has a transaction on 2020-01-21 that is a withdrawal for $amount which is the checking account payment to the credit card. The Transfer for the transactions in each account are currently set to Imbalance-USD. When I change the Account 1 transaction Transfer field to Account 2 - a new transaction is created in Account 2 instead of matching to the existing one. ___ 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] Shifted Details Invoice Addresses
Take a look at the custom CSS in the options. I'm suspecting there is something there causing this block to float-right instead of float-left or else an errant large margin or padding exists for that block. If you aren't familiar with CSS and you can reply with an exported example invoice (rather than a screenshot), I can take a look at the underlying HTML in the report to see what is wrong. I'm still on 4.1, but I don't see this problem on my invoices. I'll be updating to 4.2 soon and will double-check to see if a change was introduced there. Regards, Adrien On 11/13/20 8:53 AM, Dr. J. Richard Herbert wrote: Morning everyone, I ran into a problem yesterday with printing invoices. My style sheets have been set for over a year and work well when printing [see attached file Invoice_Before.png]. Without any changes to style sheets, client addresses shifted to the right [see Invoice_After.png]. I did not change settings in the invoice options [see Options.png]. I have also not changed setting in page setup [see Page_Setup.png]. I have not found a way to realign client addressing to the left margin. I am also working on including more invoice information into headings on invoices and it is occurring with that as well. I went back to a previous backup of local files [see Local_Files.png] and installed them but the same problem continues to occur. How can I get an alignment back for the left margin?? Richard ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
The most likely correct short answer: the import created two transactions rather than one. Your correction of the Imbalance assignment is not creating a new transaction, but correcting only one of the existing two separate transactions. Commit this fix, and then delete the extraneous transaction. The longer answer: Step 1: I *highly* recommend turning on View > Transaction Journal View, at least temporarily. This will show all splits of a transaction for easy viewing. (I use this view permanently) Step 2: From account 1 (either credit card or bank, your choice) observe the two splits shown. One should be a debit (Dr.—left column figure) and one should be a credit (Cr.—right column figure). If you are looking at the Credit Card, you should see Dr. Credit Card Cr. Checking Account and the opposite if you are viewing the Checking Account. I use Debit(Dr.) and Credit(Cr.) because the informal labels change based on the type of account viewed and might even be confusing. Debits increase asset and expense accounts, debits increase equity, liability, and income accounts. If *instead* you see: Dr. Credit Card Cr. Imbalance and, Dr. Imbalance Cr. Checking Account then the import created two separate transactions instead of only one. (as I guessed above in the short answer) Simply fix *one* of them—e.g., Dr. Credit Card Cr. Checking Account (re-assigned from Imbalance) and *delete* the other transaction in the opposite account. It would be good to review the Help & Guide documents concerning imports, specifically with respect to how to assign the 'transfer' account properly so that you end up with one transaction instead of two. The QFX file might list each side of the transaction separately and the importer is treating it as two separate rather then two sides of, the same transaction. That's a user fix either before or during the import. Regards, Adrien On 11/19/20 12:29 PM, Griff wrote: Here is a very simple question but I can't figure out how to do this. I have searched the documentation and this mailing list. How do I manually match 2 transactions: I have 2 account that have had data imported via qfx. Account 1 (credit card) has a transaction on 2020-01-19 that is a payment for $amount which is the credit card payment from checking account Account 2 (bank account) has a transaction on 2020-01-21 that is a withdrawal for $amount which is the checking account payment to the credit card. The Transfer for the transactions in each account are currently set to Imbalance-USD. When I change the Account 1 transaction Transfer field to Account 2 - a new transaction is created in Account 2 instead of matching to the existing one. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
On 11/19/20 10:29 AM, Griff wrote: Here is a very simple question but I can't figure out how to do this. I have searched the documentation and this mailing list. How do I manually match 2 transactions: I have 2 account that have had data imported via qfx. Account 1 (credit card) has a transaction on 2020-01-19 that is a payment for $amount which is the credit card payment from checking account Account 2 (bank account) has a transaction on 2020-01-21 that is a withdrawal for $amount which is the checking account payment to the credit card. The Transfer for the transactions in each account are currently set to Imbalance-USD. When I change the Account 1 transaction Transfer field to Account 2 - a new transaction is created in Account 2 instead of matching to the existing one. _ Manually -- you pick one of those dates and enter a single transaction. I usually have the bank payment entered in by hand and then do an OFX import of the CC file. The match happens automatically during the import. You can't do the match afterwards without manually removing one of them and adjusting the other. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166. --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Looking for Point-of-Sale App suggestions & if any interface with GnuCash & How
Fran, that is quite an open-ended question. 1. The best I could suggest is to research POS systems *for your specific industry*. As someone who has evaluated and researched such systems a few times, I can confidently say that the choices are myriad, and a system specifically designed for your industry is usually going to be less headache to use on a daily basis than a generic app. Unfortunately, that generally leaves out OSS as most of those are generic. However, some are highly customizable by design. (and being OSS, at least the code is available to do so even if it wasn't so designed.) Most importantly, it needs to work the way you already do without it as much as possible. Adopting a POS where none exists most assuredly will require some adjustment of your own daily business procedures or the crafting of software customizations. Neither are simple, easy, or free. (Either in money or in time.) The more adjustment or customization needed to meld the two, the more 'expensive' that system will be. Unfortunately, a good bit of the difference won't be discovered until you start trying to use the new software. 2. I'm not aware of any POS specifically designed to interface with GnuCash. What types of integration are you looking for? 3. Most POS systems can export at least a consolidated daily sales report in CSV. Some are not so friendly because they either include, or want to sell you, an add-on accounting module. In such a case, you might be able to store daily reports as PDF, then use OCR or a script to scrape the report and generate a useable CSV. Otherwise, entering data off a physical report might be your only option, but not terrible. More data friendly systems will let you export any report in CSV or spreadsheet format (usually Excel) and may even let you access the data directly via an API. (so you could write a scraper to pull data from the POS files, then create a CSV) A system which advertises 'exports to QuickBooks' will possibly (though not certainly) be friendly to GnuCash. 4. See #2 & #3. Caveat: the only officially supported method for entering or editing data in GnuCash is through the app directly, not 'behind the scenes' via other access methods to your data file. Thus some sort of import file (like CSV) is the preferred and supported route. Regards, Adrien On 11/8/20 8:31 AM, Fran_3 via gnucash-user wrote: 1 - What Point of Sale Apps would you sugges for a small business?(Open Source is preferred.) 2 - Do any interface or transfer data easily with GnuCash? 3 - If so what info does the POS software share?.. daily sales.. sales by item with sales by quantity and total sales dollars and/or price of each item sold... or what? 4 - How does the POS software share data with GnuCash?.. export CSV file to be imported by GnuCash.. or what? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. To your suggestion of importing it all at once, that is not possible as one QFX file is from the credit card company download and the other QFX is from the different bank company's download. They will be two files. This is unfortunate as the matcher is only run on QIF import and not OFX/QFX import. Should I be getting the data from the banks in QIF instead, does that work better then OFX/QFX for GnuCash import? On Thu, Nov 19, 2020 at 11:48 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The most likely correct short answer: the import created two > transactions rather than one. Your correction of the Imbalance > assignment is not creating a new transaction, but correcting only one of > the existing two separate transactions. Commit this fix, and then delete > the extraneous transaction. > > The longer answer: > > Step 1: > > I *highly* recommend turning on View > Transaction Journal View, at > least temporarily. This will show all splits of a transaction for easy > viewing. (I use this view permanently) > > Step 2: > > From account 1 (either credit card or bank, your choice) observe the > two splits shown. One should be a debit (Dr.—left column figure) and one > should be a credit (Cr.—right column figure). > > If you are looking at the Credit Card, you should see > > Dr. Credit Card > Cr. Checking Account > > and the opposite if you are viewing the Checking Account. I use > Debit(Dr.) and Credit(Cr.) because the informal labels change based on > the type of account viewed and might even be confusing. > > Debits increase asset and expense accounts, debits increase equity, > liability, and income accounts. > > If *instead* you see: > > Dr. Credit Card > Cr. Imbalance > > and, > > Dr. Imbalance > Cr. Checking Account > > then the import created two separate transactions instead of only one. > (as I guessed above in the short answer) > > Simply fix *one* of them—e.g., > > Dr. Credit Card > Cr. Checking Account (re-assigned from Imbalance) > > and *delete* the other transaction in the opposite account. > > > > It would be good to review the Help & Guide documents concerning > imports, specifically with respect to how to assign the 'transfer' > account properly so that you end up with one transaction instead of two. > The QFX file might list each side of the transaction separately and the > importer is treating it as two separate rather then two sides of, the > same transaction. That's a user fix either before or during the import. > > > > Regards, > Adrien > > On 11/19/20 12:29 PM, Griff wrote: > > Here is a very simple question but I can't figure out how to do this. > > I have searched the documentation and this mailing list. > > > > How do I manually match 2 transactions: > > > > I have 2 account that have had data imported via qfx. > > > > Account 1 (credit card) has a transaction on 2020-01-19 that is a payment > > for $amount which is the credit card payment from checking account > > > > Account 2 (bank account) has a transaction on 2020-01-21 that is a > > withdrawal for $amount which is the checking account payment to the > credit > > card. > > > > The Transfer for the transactions in each account are currently set to > > Imbalance-USD. When I change the Account 1 transaction Transfer field to > > Account 2 - a new transaction is created in Account 2 instead of matching > > to the existing one. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Griif The import matcher should run on both the QIF import and the OFX/QFX import. It also has a time window in which it tries to match existing transactions which is not adjustable. Since the records are from two different companies there may not however be sufficient matching data in the description and other fields to recognise a match. You should however be able to at the import stage of the second file, override the import matcher decisions prior to actual import in the import matcher window display. You can uncheck the A, C, or U checkbox and check one of the others as appropriate prior to importing the data. I always manually check the importer decisions particularly in regard to matching credit card and Paypal accounts with my bank accounts. The Paypal often has different dates to my bank accounts for example. Once you have ascertained the transactions where this is likely to occur scanning the matcher window for them is usually quite quick. You can also adjust the option selections in the Import preferences. Make sure the Bayesian matching is selected and the Update match action (these are usually the defaults). David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Hello Griff, Am 19.11.20 um 22:18 schrieb Griff: > Thanks Adrien and Stephen. > > Both your solutions are good work arounds, sounds like the short answer is > it can't be done the nice way preserving data. The result will be to > manually delete one of the import transactions and the new duplicate > created won't have the date that matches one of the 2 banks for correctness > purposes. : it is possible to keep both dates. The more common case is: you send money from account A to accout B. It disappears from accout A today and reappears on account B after the weekend. The proper solution is to use a "very current" asset account "money in transfer" between the two real accounts. In your case you can use a corresponded very current liability account. But I do not know the right english term of it. Just create the account and reassign the splits from your Imbalance-USD to the newly created account. Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
On 11/19/20 1:18 PM, Griff wrote: Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. To your suggestion of importing it all at once, that is not possible as one QFX file is from the credit card company download and the other QFX is from the different bank company's download. They will be two files. This is unfortunate as the matcher is only run on QIF import and not OFX/QFX import. I use the OFX import all the time and get matching. Sometimes I have to force it to look for a match (check the R column). And sometimes, it matches too good and thinks it finds a duplicate (a charge that occurs every 2 weeks) so I have to force it to bring it in by checking the import column. Should I be getting the data from the banks in QIF instead, does that work better then OFX/QFX for GnuCash import? Should be just the same. <> -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Frank, I think it would still be proper to use a current asset account. Should something interrupt the transit, the funds would not come out of the original asset account. But really, this now sounds more like a situation of simple clearing. I'm not sure the second date is necessary any more than if you write a physical check to a friend and they don't cash it for a week.(or longer) I suppose one could always include this clearing date in the Notes or Memo if it was thought to be important. Regards, Adrien On 11/19/20 3:54 PM, Frank H. Ellenberger wrote: Hello Griff, Am 19.11.20 um 22:18 schrieb Griff: Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. : it is possible to keep both dates. The more common case is: you send money from account A to accout B. It disappears from accout A today and reappears on account B after the weekend. The proper solution is to use a "very current" asset account "money in transfer" between the two real accounts. In your case you can use a corresponded very current liability account. But I do not know the right english term of it. Just create the account and reassign the splits from your Imbalance-USD to the newly created account. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Griff, Sorry, I misunderstood the original post. I thought it was a single import, not two separate ones. David's suggestions should be the way to go in your case. As for retaining the second date, (presumably from the Credit Card account) see my reply to Frank. Regards, Adrien On 11/19/20 3:18 PM, Griff wrote: Thanks Adrien and Stephen. Both your solutions are good work arounds, sounds like the short answer is it can't be done the nice way preserving data. The result will be to manually delete one of the import transactions and the new duplicate created won't have the date that matches one of the 2 banks for correctness purposes. To your suggestion of importing it all at once, that is not possible as one QFX file is from the credit card company download and the other QFX is from the different bank company's download. They will be two files. This is unfortunate as the matcher is only run on QIF import and not OFX/QFX import. Should I be getting the data from the banks in QIF instead, does that work better then OFX/QFX for GnuCash import? ___ 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] Using GnuCash with Dropbox
My Gnucash is saving to C:\Users\my username\Documents. However, Dropbox is synchronising with folders on my D Drive, which is where I would like my Gnucash files to go. Probably I should have thought of that in the setup process, but I didn't. How can I now make that happen? I have setup a special sub folder on my D Drive under Dropbox folder in readiness. David ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
In the olden days some people would even try to take advantage of having a lot of funds in "float" between various bank accounts. 🤭😷 On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Griff, > > Sorry, I misunderstood the original post. I thought it was a single > import, not two separate ones. > > David's suggestions should be the way to go in your case. > > As for retaining the second date, (presumably from the Credit Card > account) see my reply to Frank. > > Regards, > Adrien > > On 11/19/20 3:18 PM, Griff wrote: > > Thanks Adrien and Stephen. > > > > Both your solutions are good work arounds, sounds like the short answer > is > > it can't be done the nice way preserving data. The result will be to > > manually delete one of the import transactions and the new duplicate > > created won't have the date that matches one of the 2 banks for > correctness > > purposes. > > > > To your suggestion of importing it all at once, that is not possible as > one > > QFX file is from the credit card company download and the other QFX is > from > > the different bank company's download. They will be two files. > > > > This is unfortunate as the matcher is only run on QIF import and not > > OFX/QFX import. > > Should I be getting the data from the banks in QIF instead, does that > work > > better then OFX/QFX for GnuCash import? > > > ___ > 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] Using GnuCash with Dropbox
Just copy your GnuCash data files, backup files and log files from from their current location in Documents to the folder in Dropbox and then use the file open dialog in GnuCash to open the files in their new location. All should be sweet. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using GnuCash with Dropbox
I imagine File->Save As might work. Original Message From: davidvernonl...@gmail.com Sent: Thu Nov 19 19:15:45 EST 2020 To: gnucash-user@gnucash.org Subject: [GNC] Using GnuCash with Dropbox My Gnucash is saving to C:\Users\my username\Documents. However, Dropbox is synchronising with folders on my D Drive, which is where I would like my Gnucash files to go. Probably I should have thought of that in the setup process, but I didn't. How can I now make that happen? I have setup a special sub folder on my D Drive under Dropbox folder in readiness. David ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Thanks for the great suggestions everyone. I tried the idea of changing from A to C during import and then looking for a match but no matches were present to select from in the matcher dialog. I even manually changed the date of the transaction in account A to match the date of account B before importing, then did the import and the matcher still did not find anything to offer up. Too bad GnuCash does not allow selecting the match from the full list of transactions or matching at other times besides import. Hopefully this was a special case match issue and the norm will be to find a match for the transfers like your example of PayPal and the multi-day float. Otherwise, I can manually fix the issue or use Frank's short-term float account "money in transfer" to match the transactions. I have the default import setting of bayesian and 1, 3, 6 for thresholds, I tried changing the match display threshold to 0 but no impact. As a side note, I tested the QIF file for the same transactions instead to see if that worked better and had the strange issue of GnuCash hanging. Tried it several times with the same issue. David places like PayPal/Venmo still enjoy the float on their end and offer a rapid no-float option for a fee, win-win for them. On Thu, Nov 19, 2020 at 5:54 PM David Carlson wrote: > In the olden days some people would even try to take advantage of having a > lot of funds in "float" between various bank accounts. 🤭😷 > > On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Griff, > > > > Sorry, I misunderstood the original post. I thought it was a single > > import, not two separate ones. > > > > David's suggestions should be the way to go in your case. > > > > As for retaining the second date, (presumably from the Credit Card > > account) see my reply to Frank. > > > > Regards, > > Adrien > > > > On 11/19/20 3:18 PM, Griff wrote: > > > Thanks Adrien and Stephen. > > > > > > Both your solutions are good work arounds, sounds like the short answer > > is > > > it can't be done the nice way preserving data. The result will be to > > > manually delete one of the import transactions and the new duplicate > > > created won't have the date that matches one of the 2 banks for > > correctness > > > purposes. > > > > > > To your suggestion of importing it all at once, that is not possible as > > one > > > QFX file is from the credit card company download and the other QFX is > > from > > > the different bank company's download. They will be two files. > > > > > > This is unfortunate as the matcher is only run on QIF import and not > > > OFX/QFX import. > > > Should I be getting the data from the banks in QIF instead, does that > > work > > > better then OFX/QFX for GnuCash import? > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
