Re: File Format : XML v MySQL / postgres / sqllite
Hi, David, Whether PyCash is for an average user really depends on what you consider the average user to be. It is a Python library and, if you don't expect an average user to know how to write Python code then no - it is not for an average user. What it offers, though, is a pure Python interface to a GnuCash book, which needs to be stored in SQL format. This makes it cross-platform and takes the compilation of custom GnuCash binaries out of the loop (definitely not for an average user). Until Python bindings are complete and available on all platforms, it is a wonderful alternative way to read your data and generate any sort of report or action (I like to see the upcoming scheduled transactions without starting GnuCash and eventually trigger some action). In addition, it allows writing data, too, but one has to be well aware that this is raw access to data and excludes any GnuCash business logic and validations with the checks and balances that guarantee the consistency of the records. It is a 3rd party component from the GnuCash point of view and does not have any endorsement or support by GnuCash. Writing data for some simple cases, or when you know exactly what you are doing (by checking the GnuCash source, for example) is fine. I.e. I have a price importer for Vanguard Australia retail funds and exchange rates. Somehow I find it easier to implement the custom logic in Python than install another platform and the system for downloading prices, which for some reason I also had issues setting up. Once you know what PieCash does, and check the great documentation with examples, you can decide if it would help you with what you are trying to achieve. Cheers -- 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: Does anyone successfully use GNU Android App. If not get it off the main web site.
On Sun, 28 Jan 2018 19:48:54 + jeffrey black wrote: > All I do is export the app data to a qif file and use the usb port to > transfer it to my desktop. Never had a problem with it. I have never > tried exporting as xml. > > Keep in mind the android app is an entirely separate product, > developed by a different group. I had a working version, then a non-exporting version. I went back to scraps of paper. On the new phone the version I have seems to be able to export again. It's 2.2.0 However, it won't connect to my nextcloud server, so I have to do some odd things to get the data to my computer. Paper remains easier. Liz ___ 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.
In which account are Invoice customer balances posted
When a customer pays more than the amount due on an invoice that balance appears in the receive payment window the next time there is an invoice to pay. In which account is that balance stored? I suspect it is kept in receivables. Is that correct? Trying to figure out a way to keep track of what portion of the balance in the checking and cash accounts are advance payments. Thanks, Roger ___ 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: Subaccounts [WAS Re: Future allocated money vs Budgets]
On 1/28/2018 8:11 PM, Matt Graham wrote: When you look at what liabilities really are, Adrien and I concluded on this thread that this situation (segmenting money for future) is really using a separate asset account. After all - creating a liability INCREASES your cash available. ... Yes, the problem precisely, we aren't assigning the same meaning to "available" and "liability" But your example of what you would like to see: Template transactions (I'd probably call them "Triggerred transactions", but it doesn'tmatter) sound awesome. As someone else highlighted, there are implementation difficulties to consider, but I dont think that it would be too onerous. In terms of spending from another account but recording against a sub-account, its easy: Dr Exp whatever account Cr Cash I pay for something awesome Dr Parent account the amount I paid Cr sub-account the amount I paid SPECIAL CASE of a GENERAL requirement. The special case might be easy to implement BUT in general the amounts are NOT going to be the same. This is actually a fairly common situation for me, say one of the organizations SELLS a tee shirt (fundraising, but tee shirts might also be being given away to volunteers). Db Cash Cr Sales Db Cost of goods sold Cr Tee shirt inventory << the shirts might be being sold for $20 but cost the organization $7 >> Or, and though this is common with our restricted funds (not exactly matching) I will give an example precisely for your situation. You socked away into this reserve $100/mo toward the annual renewal of your car insurance based on your ESTIMATE of what that annual bill will be. But when the bill arrives it is for $1150 or $1250. In both cases you pay the bill and release the restriction, yes? << in one case, you had more in the fund than needed but it still can be released to general purposes, in the other you used all of the fund AND had to add some general funds >> Michael D Novack ___ 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: In which account are Invoice customer balances posted
Roger, You are correct. Ideally, that overpayment should instead be held as a liability in the form of ‘customer deposits’ but I suppose that would have complicated the code. A reverse balanced AR is technically a liability, not an asset. When I encounter such a situation, I set a scheduled transaction for 30 days ahead. When that transaction fires for my approval, I check to see if the Customer Report still shows the credit balance. If so, I use the SX to move the funds from AR to Liability:Customer Deposits which I’ll use as a payment method on their next invoice when that happens. Regards, Adrien > On Jan 29, 2018, at 2:50 PM, rmom...@gmail.com wrote: > > When a customer pays more than the amount due on an invoice that balance > appears in the receive payment window the next time there is an invoice to > pay. In which account is that balance stored? I suspect it is kept in > receivables. Is that correct? > > > > Trying to figure out a way to keep track of what portion of the balance in > the checking and cash accounts are advance payments. > > > > Thanks, > > Roger > > ___ > 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: info about action field in double-line view
Thanks all. I don't understand the difference between "cleared" and "reconciled" in Gnucash context. Someone mentioned that one changes R from "n" to "c" when they see the charge in their bank statement or online banking. How is that different in terms of information flow from using the reconciliation feature to do exactly the same thing? I still end up having to cherry-pick individual transactions to make the balance work out. Regarding the Num field, I understand that this would be a check number if anyone paid for much with checks anymore. For checking visa or ACH transactions, am I supposed to record the transaction number from the bank online balance sheet or statement? Thanks. Mark ___ 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: info about action field in double-line view
An item that is cleared means that your bank has cashed it. An item that is reconciled means that at the end of the month the balance of the bank and your checking account match for all item that have cleared. That is the difference between the two. I hope my explanation is simple enough. Sent from my iPhone > On Jan 29, 2018, at 7:56 PM, Mark Hedges wrote: > > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
The letter c is applied to transaction splits by GnuCash either when the user imports a transaction from a QIF, OFX or QFX file that was probably downloaded over the Internet from a banking website or manually by clicking in the appropriate box. This is interpreted to mean that the information in that split line of that account register of the data file matches the information from the bank. Arguably, it would probably be better to have separate indicators for these two distinctly different actions. That is not the same as the R applied by GnuCash from a Reconciliation, where the user is verifying that his data records match those from whatever independent source he chooses. Historically, the independent source was the checkbook register, but now it is probably a combination of memory and whatever receipts the user has kept. The R indicator cannot be manually applied to a transaction split line. There is no requirement that the user even consider using these indicators. Many users, myself included, never reconcile income or expenses or any other accounts except bank and investment accounts. As to your cherry-picking to make the balance work out, are you referring to making a reconciliation balance work out? That would be little different than comparing a manually recorded checkbook register to a bank statement. You still need to 'remember' that credit card or debit card purchase that you forgot to record or to notice that there was an unauthorized charge to your account. This is your opportunity to discover fraudulent use of your account. To your last point, the Num field can contain whatever information that you choose to put there, period. David C On Mon, Jan 29, 2018 at 6:56 PM, Mark Hedges wrote: > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
Here's the workflow that I ideally go through. During the month, I order something online using a credit card. When I enter the transaction into GnuCash, the split associated with the transaction in the credit card account is tagged "n". The next day, I check my online banking, and I see that the credit card company considers the transaction "pending". I leave it tagged as "n". The next day, I check again, and now the transaction is charged against my account, and is no longer "pending". I tag the entry in GnuCash as "c", cleared. At the end of the month, I receive my statement, and I run the "reconciliation" process in GnuCash. GnuCash automatically cherry-picks "cleared" transactions for me, and I look for any discrepancy (transactions that haven't cleared, or transactions on the card I don't have recorded, etc). When I am satisfied that all is well, I tell GnuCash that the reconciliation is complete, and it marks the reconciled transactions as "r". In the future, when you go to reconcile the next month, it won't consider the ones already reconciled. GnuCash also shows multiple balances for an account: a current balance, a future balance, a reconciled balance, and a cleared balance. At any given time, the "cleared balance" should match match what the online banking says it should be, the "reconciled balance" matches your last statement balance. On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges wrote: > Thanks all. > > I don't understand the difference between "cleared" and "reconciled" > in Gnucash context. Someone mentioned that one changes R from "n" to > "c" when they see the charge in their bank statement or online > banking. How is that different in terms of information flow from > using the reconciliation feature to do exactly the same thing? I > still end up having to cherry-pick individual transactions to make the > balance work out. > > Regarding the Num field, I understand that this would be a check > number if anyone paid for much with checks anymore. For checking visa > or ACH transactions, am I supposed to record the transaction number > from the bank online balance sheet or statement? > > Thanks. > > Mark > ___ > 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: info about action field in double-line view
My workflow is remarkably similar but my transactions are marked as "y" when they get reconciled :-) I wouldn't mind also being able to flag a transaction as 'p' = pending for the pending credit card transactions and 's' = scheduled when I have scheduled a future transaction in online banking but I was told previously that it's a binary value even though it transitions from 'n' to 'c' to 'y' in my world !!! Cheers Dave H. On 30 January 2018 at 11:36, Buddha Buck wrote: > Here's the workflow that I ideally go through. > > During the month, I order something online using a credit card. > > When I enter the transaction into GnuCash, the split associated with the > transaction in the credit card account is tagged "n". > > The next day, I check my online banking, and I see that the credit card > company considers the transaction "pending". I leave it tagged as "n". > The next day, I check again, and now the transaction is charged against my > account, and is no longer "pending". I tag the entry in GnuCash as "c", > cleared. > > At the end of the month, I receive my statement, and I run the > "reconciliation" process in GnuCash. GnuCash automatically cherry-picks > "cleared" transactions for me, and I look for any discrepancy (transactions > that haven't cleared, or transactions on the card I don't have recorded, > etc). When I am satisfied that all is well, I tell GnuCash that the > reconciliation is complete, and it marks the reconciled transactions as > "r". In the future, when you go to reconcile the next month, it won't > consider the ones already reconciled. > > GnuCash also shows multiple balances for an account: a current balance, a > future balance, a reconciled balance, and a cleared balance. At any given > time, the "cleared balance" should match match what the online banking says > it should be, the "reconciled balance" matches your last statement balance. > > > On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges > wrote: > > > Thanks all. > > > > I don't understand the difference between "cleared" and "reconciled" > > in Gnucash context. Someone mentioned that one changes R from "n" to > > "c" when they see the charge in their bank statement or online > > banking. How is that different in terms of information flow from > > using the reconciliation feature to do exactly the same thing? I > > still end up having to cherry-pick individual transactions to make the > > balance work out. > > > > Regarding the Num field, I understand that this would be a check > > number if anyone paid for much with checks anymore. For checking visa > > or ACH transactions, am I supposed to record the transaction number > > from the bank online balance sheet or statement? > > > > Thanks. > > > > Mark > > ___ > > 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.
Re: Subaccounts [WAS Re: Future allocated money vs Budgets]
Ah, true. I guess this is why I favored "triggered transactions " rather than "template transactions". I want a transaction involving expense account "spending money" to automatically add two more splits to reduce the asset account "segmented spending money" balanced by increasing the value of "allocated cash" asset acct (increase = make it less negative). For saving up for something expensive, I would still set up the above, but I would need to manually change the numbers if I wanted to return the allocation to zero. So when I enter: Cr account I used to pay insurance 1150 Dr expense account for insurance (with the trigger attached) 1150 I would want gnucash to automatically add the splits Cr account I am using to segment insurance money 1150 Dr account showing allocated cash 1150. I would the (during my reconciling/budget review) need to amend that transaction (or create a new one to return the insurance allocation to zero. For many of my other money allocations (eg restaurants/cafe) I wouldnt change it - underspending means the money is available for later. Am I understanding you right? Thanks and regards, Matt Original message From: Mike or Penny Novack Date: 30/1/18 09:31 (GMT+10:00) To: Matt Graham Cc: gnucash-user@gnucash.org Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets] On 1/28/2018 8:11 PM, Matt Graham wrote: When you look at what liabilities really are, Adrien and I concluded on this thread that this situation (segmenting money for future) is really using a separate asset account. After all - creating a liability INCREASES your cash available. ... Yes, the problem precisely, we aren't assigning the same meaning to "available" and "liability" But your example of what you would like to see: Template transactions (I'd probably call them "Triggerred transactions", but it doesn'tmatter) sound awesome. As someone else highlighted, there are implementation difficulties to consider, but I dont think that it would be too onerous. In terms of spending from another account but recording against a sub-account, its easy: Dr Exp whatever account Cr Cash I pay for something awesome Dr Parent account the amount I paid Cr sub-account the amount I paid SPECIAL CASE of a GENERAL requirement. The special case might be easy to implement BUT in general the amounts are NOT going to be the same. This is actually a fairly common situation for me, say one of the organizations SELLS a tee shirt (fundraising, but tee shirts might also be being given away to volunteers). Db Cash Cr Sales Db Cost of goods sold Cr Tee shirt inventory << the shirts might be being sold for $20 but cost the organization $7 >> Or, and though this is common with our restricted funds (not exactly matching) I will give an example precisely for your situation. You socked away into this reserve $100/mo toward the annual renewal of your car insurance based on your ESTIMATE of what that annual bill will be. But when the bill arrives it is for $1150 or $1250. In both cases you pay the bill and release the restriction, yes? << in one case, you had more in the fund than needed but it still can be released to general purposes, in the other you used all of the fund AND had to add some general funds >> Michael D Novack ___ 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: info about action field in double-line view
Dave, you got me! I didn't look carefully before replying. I too get 'y' as a result of a reconcile! :-) David C On Mon, Jan 29, 2018 at 10:48 PM, Dave H wrote: > My workflow is remarkably similar but my transactions are marked as "y" > when they get reconciled :-) > > I wouldn't mind also being able to flag a transaction as 'p' = pending for > the pending credit card transactions and 's' = scheduled when I have > scheduled a future transaction in online banking but I was told previously > that it's a binary value even though it transitions from 'n' to 'c' to 'y' > in my world !!! > > Cheers Dave H. > > > On 30 January 2018 at 11:36, Buddha Buck wrote: > > > Here's the workflow that I ideally go through. > > > > During the month, I order something online using a credit card. > > > > When I enter the transaction into GnuCash, the split associated with the > > transaction in the credit card account is tagged "n". > > > > The next day, I check my online banking, and I see that the credit card > > company considers the transaction "pending". I leave it tagged as "n". > > The next day, I check again, and now the transaction is charged against > my > > account, and is no longer "pending". I tag the entry in GnuCash as "c", > > cleared. > > > > At the end of the month, I receive my statement, and I run the > > "reconciliation" process in GnuCash. GnuCash automatically cherry-picks > > "cleared" transactions for me, and I look for any discrepancy > (transactions > > that haven't cleared, or transactions on the card I don't have recorded, > > etc). When I am satisfied that all is well, I tell GnuCash that the > > reconciliation is complete, and it marks the reconciled transactions as > > "r". In the future, when you go to reconcile the next month, it won't > > consider the ones already reconciled. > > > > GnuCash also shows multiple balances for an account: a current balance, a > > future balance, a reconciled balance, and a cleared balance. At any given > > time, the "cleared balance" should match match what the online banking > says > > it should be, the "reconciled balance" matches your last statement > balance. > > > > > > On Mon, Jan 29, 2018 at 7:59 PM Mark Hedges > > wrote: > > > > > Thanks all. > > > > > > I don't understand the difference between "cleared" and "reconciled" > > > in Gnucash context. Someone mentioned that one changes R from "n" to > > > "c" when they see the charge in their bank statement or online > > > banking. How is that different in terms of information flow from > > > using the reconciliation feature to do exactly the same thing? I > > > still end up having to cherry-pick individual transactions to make the > > > balance work out. > > > > > > Regarding the Num field, I understand that this would be a check > > > number if anyone paid for much with checks anymore. For checking visa > > > or ACH transactions, am I supposed to record the transaction number > > > from the bank online balance sheet or statement? > > > > > > Thanks. > > > > > > Mark > > > ___ > > > 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. > ___ 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.
Merging Files or Other Method getting Transactions into main File.
Confused! Back ground : Trying to get damaged transactions from phone to main file. Transactions entered whilst phone app had some sort of double minus problem. What I have done: The only way to repair the transactions was to export as an XML file. Open that XML in GNUCash. Go through line by line and enter amounts. Now I want these transactions to be imported into my main file. I have attempted to export these corrected transactions to a QIF File. But this option does not seem to exist. So have followed the export to CSV file. Now when attempting to import these CSV files to my main file. It fails. So is there a way to simply merging the two XML files rather than importing them. If not I will print the transactions out and start manually entering them in my main file as this is now totally beyond a joke. I say again. AS THE GNUCASH ANDROID APP DOES NOT WORK PLEASE PLEASE PLEASE REMOVE IT FROM THE GNUCASH WEB SITE SO THAT NO ONE ELSE SUFFERS THIS HUGE WASTE OF TIME. -- 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: Subaccounts [WAS Re: Future allocated money vs Budgets]
Matt, You lost me again. I don’t understand why you’d have a negative 'segmented spending money' asset. You receive a paycheck, say $1000. You earmark 50% of that into various sub-accounts. You still have $1000. There’s no negative balance on any asset account. Perhaps your checking account holds $500 of that money, and each of four sub-accounts hold $250, $150, $50 & $50 respectively. That all adds up to $1000. The act of earmarking funds moves you from one account with a single positive $1000 balance to 5 accounts totaling a positive $1000 balance NONE of which are negative. Where’s the ‘negative segmented money account?’ Please describe with debits and credits. I don’t see it. What I see is this: Receipt of money with segregation: Dr. Assets:Checking $500 Dr. Assets:Checking:Vacation$250 Dr. Assets:Checking:Insurance $150 Dr. Assets:Checking:Dining $ 50 Dr. Assets:Checking:Coffee&Tea $ 50 Cr. Income:Salary $1000 When you go out for lunch I see this: Dr. Expenses:Dining $20 Cr. Assets:Checking:Dining $20 How does recording an expense INCREASE the allocated cash for Dining as you describe? (making it less negative) How was it negative in the first place? What transaction did you record to make it so? Note, for an asset to be ‘negative’ it has to have a ‘credit’ balance, that is, credits have to be greater than debits. Making an asset account ‘less negative’ is a debit transaction. (since asset accounts are usually debit positive balanced) Debits don’t decrease an asset, they increase it. Spending money never gives you more to spend, it means you have less. Spending money is always (eventually) a credit to assets, never a debit. I can’t see any scenario where that above example of going out for lunch looks like this: Dr. Expenses:Dining $20 Dr. Assets:Checking:Dining $20 Cr. $40 If that would even begin to make any sense why $40 is moving somewhere instead of just $20. Note, doing this: Dr. Assets:Checking:Dining $20 Cr. Expenses:Dining $20 Is an incorrect transaction if you SPENT the money. (as opposed to receiving a refund, or correcting a prior error) Crediting an expense is a refund/reversing condition, not a normal expenditure. When you record the receipt of money, that goes to an income/revenue account, split with the physical asset account for the form you received the payment in. Generally, this will be a credit to ‘income’ and a debit to ‘cash.’ Where and how do you record the receipt of money as a credit to an asset instead and how does that balance against your credit to your income account? i.e.— Dr. $1000 Cr. Income:Salary $1000 Cr. Assets:?? Regards, Adrien > On Jan 29, 2018, at 11:25 PM, Matt Graham wrote: > > Ah, true. I guess this is why I favored "triggered transactions " rather than > "template transactions". > > I want a transaction involving expense account "spending money" to > automatically add two more splits to reduce the asset account "segmented > spending money" balanced by increasing the value of "allocated cash" asset > acct (increase = make it less negative). > > For saving up for something expensive, I would still set up the above, but I > would need to manually change the numbers if I wanted to return the > allocation to zero. > > So when I enter: > > Cr account I used to pay insurance 1150 > Dr expense account for insurance (with the trigger attached) 1150 > > I would want gnucash to automatically add the splits > > Cr account I am using to segment insurance money 1150 > Dr account showing allocated cash 1150. > > I would the (during my reconciling/budget review) need to amend that > transaction (or create a new one to return the insurance allocation to zero. > > For many of my other money allocations (eg restaurants/cafe) I wouldnt change > it - underspending means the money is available for later. > > Am I understanding you right? > > > Thanks and regards, > Matt > > > Original message > From: Mike or Penny Novack > Date: 30/1/18 09:31 (GMT+10:00) > To: Matt Graham > Cc: gnucash-user@gnucash.org > Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets] > > On 1/28/2018 8:11 PM, Matt Graham wrote: > When you look at what liabilities really are, Adrien and I concluded > on this thread that this situation (segmenting money for future) is really > using a separate asset account. After all - creating a liability INCREASES > your cash available. ... > Yes, the problem precisely, we aren't assigning the same meaning to > "available" and "liability" > > But your example of what you would like to see: > > Template transactions (I'd probably call them "Triggerred transactions", but > it doesn'tmatter) sound awesome. As someone else highlighted, there
Re: Merging Files or Other Method getting Transactions into main File.
GnuCash for Android is a separate project. The developers of GnuCash (or this mailing list) are not affiliated with it. The GnuCash project has a link to it because users of GnuCash may be interested in it. So you’ve found that this 3rd party app for your phone had a bug. That happens from time to time with any software, including GnuCash itself. The bug, as has been noted on this forum very recently (last few days) MANY times, has been fixed in newer releases. I would think removing mention of the app from the GnuCash website on account of a bug would be a bit too far. Just update the app on your phone and re-export the data. Is that not possible for you? Perhaps I’m misunderstanding, but I didn’t interpret that the bug was a damage to the data file on the phone, but rather an incorrect export. If it really did damage your file, other than restoring from a backup and manually entering in the later transactions, or manually keying in everything from the phone to the desktop version, I’m not sure there’s a simpler solution. But if you can see the full data on the phone, then I suspect updating the app and re-exporting will solve the dilemma. Regards, Adrien > On Jan 30, 2018, at 12:59 AM, john_mike > wrote: > > Confused! > > Back ground : Trying to get damaged transactions from phone to main file. > Transactions entered whilst phone app had some sort of double minus problem. > > > What I have done: > > The only way to repair the transactions was to export as an XML file. Open > that XML in GNUCash. Go through line by line and enter amounts. > > Now I want these transactions to be imported into my main file. > > > I have attempted to export these corrected transactions to a QIF File. But > this option does not seem to exist. So have followed the export to CSV file. > > Now when attempting to import these CSV files to my main file. It fails. > > So is there a way to simply merging the two XML files rather than importing > them. > > > If not I will print the transactions out and start manually entering them in > my main file as this is now totally beyond a joke. > > I say again. > > AS THE GNUCASH ANDROID APP DOES NOT WORK PLEASE PLEASE PLEASE REMOVE IT FROM > THE GNUCASH WEB SITE SO THAT NO ONE ELSE SUFFERS THIS HUGE WASTE OF TIME. > > > > > > > > > -- > 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. ___ 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.
