Re: [GNC] Delete acct + move txns - can't specify acct
Thank you Fred, you nailed it - the "old" checking acct (the one I want to delete) is Type=Bank. The "new" checking acct into which I want to roll the txn's from the old acct was Type=Asset. And thanks for all the other responses as well. Next ... to learn how to help revise/expand this page- https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html ... to capture what I've learned here. Thanks again Fred + all. And again big thank you to dev's + all who have contributed to and maintain this great program + community. Chris On 6/3/24 17:48, gnucash-user-requ...@gnucash.org wrote: Message: 1 Date: Mon, 03 Jun 2024 17:22:31 +0100 From: "Fred Bone" To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Delete acct + move txns - can't specify acct Message-ID: <665dedc7.32669.e533...@fred.mandfb.me.uk> Some experimenting (2.6.21, but it doesn't strike me as the sort of thing that would have changed) it appears to restrict to the same Account Type. If I try to delete a "Bank" account under Assets, it offers all the other Bank accounts (including the Orphan and Imbalance ones). For a Cash account it offers all the Cash accounts. Obviously not exhaustive testing but might help. ___ 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] Delete acct + move txns - can't specify acct
<< Is the missing account set to Placeholder? >> ... no, it is not ... still, thanks for coming back on it. - Chris *From:* sunfis...@yahoo.com *To:* Chris Skudder *Cc:* Gnucash Users *Date:* Sunday, June 2, 2024 at 11:35 PM *Subject:* [GNC] Delete acct + move txns - can't specify acct Is the missing account set to Placeholder? David T. On Jun 3, 2024, at 1:22 AM, Chris Skudder wrote: I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db). I tried to delete a closed checking acct, and move the transactions to another checking acct. When in the "Delete Acct" dialog box, I get the button to move transactions to another acct, and GnuCash offers another asset acct - but not the one I want. I cannot change this "move to" acct - I can't type the name of the acct that I want into the box. I can type characters, but whatever I type, it only offers the one single acct which it first offers. The dropdown also offers Imbalance + Orphan. I looked here - https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html ... didn't find any mention of how to specify the "move-to" acct. Any ideas? Thanks in advance. This is a great program. Big thank you for all the thought, time + effort from dev's and everyone working on it. Chris 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.
[GNC] Delete acct + move txns - can't specify acct
I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db). I tried to delete a closed checking acct, and move the transactions to another checking acct. When in the "Delete Acct" dialog box, I get the button to move transactions to another acct, and GnuCash offers another asset acct - but not the one I want. I cannot change this "move to" acct - I can't type the name of the acct that I want into the box. I can type characters, but whatever I type, it only offers the one single acct which it first offers. The dropdown also offers Imbalance + Orphan. I looked here - https://gnucash.org/docs/v5/C/gnucash-manual/acct-delete.html ... didn't find any mention of how to specify the "move-to" acct. Any ideas? Thanks in advance. This is a great program. Big thank you for all the thought, time + effort from dev's and everyone working on it. Chris ___ 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] importing or pasting reports into spreadsheets
I do this using the "Export" choice in GnuCash, saving the report as an html file on the desktop, then right-click + open with LibreOffice Calc. In addition to what Hop said below about ticking the box for: "Detect special numbers (such as dates)" in the import ... I also need to do this step: - Select the entire column of numbers that aren't numerical values, by clicking on the letter at the column header) - In the "Data" menu dropdown, select "Text to Columns", then click OK. Hope that helps too. Chris (Xubuntu 22.04, Xfce desktop, GnuCash 5.4 flatpak, LibreOffice 7.3.7.2) On 4/14/24 02:01, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson To: "gnucash-user@gnucash.org" Subject: [GNC] importing or pasting reports into spreadsheets I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not recognize them. It also looks like dates are in some form of text as they have a format code "@" whatever that means. I am not very proficient with these format issues. Does someone know of an elementary reference that is easier to understand than the spreadsheet help file? Just in case it makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 with a LXQT desktop. -- David Carlson -- Date: Sun, 14 Apr 2024 12:20:35 +1000 From: Alan Hopkins To: David Carlson Cc: GnuCash users group Subject: Re: [GNC] importing or pasting reports into spreadsheets Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers Hop ___ 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] Multi-column reports- sort by acct code?
I usually do multi-column Statements of Activity and Position. I have been using Custom Multicolumn because that sorts in order of Account Code. Is there a way to sort the Income Statement-Multicolumn by acct code? That would save some time setting up the several reports. Thanks very much, Chris ___ 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] Compare two sets of accounts?
I wonder if Reports>Transaction Report might do it, with this option - - Click "Edit options", go to "General" tab Change "Date Filter" to filter on "Date Entered" Set start date = the date on which you sent the file to your accountant ... end date= the day you're doing the report That would seem to tell you what the accountant did. If the accountant didn't do too many txn's, might be easiest, or at least possible, to just enter them by hand into your "master" file. As far as automating this entry part, someone else has already mentioned logfiles. I can't think of another or better way to do it automatically. HTH, good luck, Chris On 1/19/24 12:00p, gnucash-user-requ...@gnucash.org wrote: Message: 5 Date: Fri, 19 Jan 2024 06:50:29 -0700 From: Simon Roberts To: Gnucash Users Subject: [GNC] Compare two sets of accounts? Message-ID: Hi all, Does GNC provide any mechanism for comparing two versions of the same set of accounts? I'll be sending my books to my accountant soon, and I imagine they will have some corrections/adjustments. I'll be giving them a laptop with GNC installed, so they can most easily browse, and it occurs to me that they could also make their changes in place. But, unless they write down separately every entry they create or change, I would need to somehow re-integrate their work with my "master" file. Either that, or I'd have to freeze my bookkeeping while they're working on things, and that's likely to take too long to be acceptable. With the hostage-taker's rent-ware that I used to use, there was a specific mechanism for an "accountant's copy" and a means to merge the changes back automatically. But I've failed to find this in the docs for GNC (quite possibly as a result of poor / uninspired searching!) Is this supported directly? Is this something folks have found an approach for? I suppose, as a not quite worst case, I could simply diff the XML file itself, but that's going to produce results that will be somewhat messy, at best. But at least I'd know something about what changed. What ideas can you offer (or manual pages, if I've failed that embarrassingly!) TIA, Simon -- Simon Roberts 303 249 3613 ___ 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] Business Income Statement: manipulating Cost of Goods sold (Eric Chapman)
I'd suggest *NUMBERING* the expense accounts - the field is called "Account Code." Get to it by editing the account, in the account tab. Number the accounts in the sequence in which you want to see them. Most often, accounts are numbered in "layers", corresponding to parent + subaccount relationships, like: 5000 COGS 5100 COGS, parts 5200 COGS, labor I believe the income stmt will then sort + display accounts in the order or their number or acct code. But there may be preference(s) which need to be set for the sort to use number instead of name. Maybe somebody else knows that better than I do. HTH, Chris *From:* gnucash-user-requ...@gnucash.org *Sent:* Friday, December 8, 2023 at 2:57 PM *To:* gnucash-user@gnucash.org *Subject:* gnucash-user Digest, Vol 249, Issue 24 Today's Topics: 1. Business Income Statement: manipulating Cost of Goods sold (Eric Chapman) -- Message: 1 Date: Fri, 8 Dec 2023 14:57:25 -0500 From: Eric Chapman To: GNUcash User List Subject: [GNC] Business Income Statement: manipulating Cost of Goods sold Message-ID: Content-Type: text/plain; charset="utf-8"; Format="flowed" (Note 1: I hope the mailing list presents this with fixed-width characters. If it does not, but sample below of a tax form will not appear as I intended it to.) (Note 2: The three attached screenshots might help you understand my question. I hope they are small enough to come through.) In GnuCash 5.4 I have a Chart of Accounts / Account Tree that reflects Schedule F of Form 1040 for reporting of farm business. I use the business feature "Accounts Payable." Here is how part of it looks: 1a Sales of purchased livestock and other resale items $.xx <-- my sales of resale items account 1b Cost or other basis or purchased livestock or other items reported on line 1a??? xxx.xx <-- I have 3 Cost of Goods Sold (COGS) accounts that are to be here (should be income account with debit balance [negative]) 1c Subtract line 1b from line 1a $.xx My problem: In the Chart of Accounts / Account Tree I set up the COGS accounts as "income" accounts. As such, in v. 5.4 the COGS accounts were not on the drop down list of "expenses" to debit when recording purchases. So I changed the tick mark for them and called them expenses. They worked fine. But now when I print a report, the COGS accounts are listed down in the expense section of the Income Statement, not up under "1a" as they should be (and as they are "parented" an "begotten" in the Chart of Accounts / Account Tree). These are the workarounds I see: (1) Change the 3 COGS accounts back to having the "Expense" attribute before printing reports. (2) Debit all COGS items into inventory accounts and later make journal entries (transactions) from that inventory account to the COGS accounts. I realize this is normal (maybe desirable, but since I'm using all of those COGS items immediately, I thought I'd save time and not use inventory accounts. What I'd like: The ability for the accounts called "Expenses" but used for COGS to be debitable when entering "Bills" (invoices issued to me by vendors). Are there better ways to do what I want to do, or an option to tweak GnuCash so that I can debit those accounts as I want to? Advice, anyone? Thank you very much! ___ 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] Exporting from QuickBooks / Importing to GnuCash
From Intuit: "Intuit Interchange Format (.IIF) files are ASCII text, TSV (Tab-Separated Value) files that QuickBooks Desktop uses to import or export lists or transactions" source: https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577 So this could very well work, but I can't test it: Export from QB as IIF. Open IIF in a spreadsheet Save as a COMMA separated value file- that is, CSV ... ... instead of Intuit's TAB separated IIF file Then in GnuCash: File> Import> Import Txn's from CSV Hope it helps. Chris FWIW ... IMHO ... Intuit seems to have a track record of aggressively, even unethically, hiding technical pathways, or anything, which might help people do something which costs Intuit revenue. As contrasted with building a product which offers real value for money. IMHO. On 3/30/23 12:00, gnucash-user-requ...@gnucash.org wrote: Message: 4 Date: Thu, 30 Mar 2023 10:47:48 -0400 From: Richard Lindgren To: "gnucash-user@gnucash org" Subject: [GNC] Exporting from QuickBooks / Importing to GnuCash Message-ID: Content-Type: text/plain; charset="UTF-8" I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help here. Please advise me as to a good plan of attack? Thank you very much for help in this matter, and look forward to hearing from you. Richard Lindgren ___ 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] gnucash-user Digest, Vol 239, Issue 9
One way is to schedule a transaction to be created before you import the bank record. Then match the imported bank record to the scheduled transaction. The amounts on payrolls are often pretty consistent from one payroll run to the next, so it might match automatically, or you might have to select the match manually. You might also have to edit the created transaction, to exactly match the amounts for the current payroll run. But at least you can program in the splits with the right GL accounts (with a default amount), descriptions, etc. That way at least the transaction is all set up, with the possible exception of some minor edits. Chris Similar situation - I'm treasurer of our church, which has 4 employees and pays every 2 weeks, with the same structure of 2 direct debits - one for what's paid to employees and the other for what's deposited to govt tax collection accts. We charge the wages and taxes to 8-10 different GL acct's in our books. The church is on Quickbooks Online which doesn't offer scheduled transactions unless you upgrade + pay them more money - argh. So when I run payroll, I copy the previous payroll run's transactions and edit the amounts to match the current payroll run, change date etc. The edited transactions match to the bank's record of the direct debits when they come in. On 2/4/23 11:43, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 4 Feb 2023 08:23:00 -0700 From: Simon Roberts To: Gnucash Users Subject: [GNC] Splitting an imported transaction? Message-ID: Content-Type: text/plain; charset="UTF-8" Hi all, I use a third party organization to run payroll, and they make two withdrawals from my bank. One is the amount actually paid to employees (two of us and the other is the sum of taxes collected from those employees, plus the employer's tax contributions. Unsurprisingly, when this imports, from the bank records, it shows as two transactions, and the tax stuff is all lumped into a single transaction. As yet, I've only handled this once and did it wrong anyway (I fixed it up by hand OK though). However, in three months it'll happen again so I figure if I ask now I could be ready to try to do it right next time. What I'd like--but suspect might be impossible, is to persuade the import operation to create a split to the two accounts (payroll taxes: employer and payroll taxes-employee). I'm not so concerned about how the money is allocated across the split (there's really no way for the system to know what to do about that, after all), but if there's a placeholder, that would be a nice start. Or perhaps there's some other approach that I've not thought of? What do folks recommend? Cheers, Simon -- Simon Roberts (303) 249 3613 ___ 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] Reports suddenly not working - found it
Found the problem + fix here - [1]https://askubuntu.com/questions/1398945/why-have-my-gnucash-reports- stopped-working Caused by flatpak not updating correctly. Fix = $flatpak update thanks all the same - - Chris __ From: Chris Skudder [[2]mailto:cskud...@earthlink.net] Sent: Thursday, January 5, 2023, 9:00 AM To: [3]gnucash-user@gnucash.org Subject: Reports suddenly not working at all I'm on Build ID: Flathub 4.13, on Lubuntu 18.04, been using it for years without any issue. Today reports simply do not work: it returns a blank screen, whether I call up a standard report or a custom; and regardless of what options I select (dates, accounts, etc). Last time I pulled reports, about a month ago, everything worked as it always had for years. Any ideas? thanks in advance, Chris References 1. https://askubuntu.com/questions/1398945/why-have-my-gnucash-reports-stopped-working 2. mailto:cskud...@earthlink.net 3. mailto:gnucash-user@gnucash.org ___ 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] Reports suddenly not working at all
I'm on Build ID: Flathub 4.13, on Lubuntu 18.04, been using it for years without any issue. Today reports simply do not work: it returns a blank screen, whether I call up a standard report or a custom; and regardless of what options I select (dates, accounts, etc). Last time I pulled reports, about a month ago, everything worked as it always had for years. Any ideas? thanks in advance, Chris ___ 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] gnucash-user Digest, Vol 237, Issue 113
FWIW, I'm another who enters most txn's on the same day I make them. IMHO, one of the great and beautiful advantages of GnuCash over Quickbooks Online (which I must use to do our church's accounts) - is that GC opens basically instantaneously. There's no network latency, no login, no "let's make sure it's really you" and "let's verify your cell number," no clicking thru "Don't you want to sign up for our payroll service, and our credit card processing service" and Lord knows what else, before I can do what "I" want to do, versus what Intuit wants me to do. For me, I can open the computer from standby, open GnuCash, enter the txn, and stash the receipt "off the deck" somewhere, quite a bit faster than try to find receipts later, find time, remember what they're for, + etc. Realizing everybody's different ... but my own 1 vote is to keep the date default "today", or at least to give a user the OPTION to default txn dates to today. So hooray for open source software, and for the talented and dedicated peep's who do the coding that I don't know how to do. Thank you to you all. Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Thursday, December 29, 2022, 12:00 PM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 237, Issue 113 On 12/28/2022 11:11 AM, R Losey wrote: That would be an interesting poll (about when one enters data) References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org ___ 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] Buying with PayPal - how do I split the transaction?
When you BUY something using paypal, the SELLER pays their fees, not you. So recording a purchase for which you paid using paypal is no different than any other purchase: Debit: expense (or asset, if you're buying something that you'll recognize as an asset on your balance sheet) Credit: your paypal asset account if you carry a balance in it; or credit a credit card account if your paypal purchases pull money directly from a credit card. Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Saturday, December 10, 2022, 12:00 PM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 237, Issue 31 Message: 2 Date: Sat, 10 Dec 2022 14:50:05 + From: "Dr. David Kirkby" [3] To: [4]stepbystepf...@comcast.net Cc: [5]gnucash-user@gnucash.org Subject: Re: [GNC] Buying with PayPal - how do I split the transaction? Message-ID: [6] Content-Type: text/plain; charset="UTF-8" On Sat, 10 Dec 2022 at 01:19, Michael or Penny Novack < [7]stepbystepf...@comcast.net> wrote: On 12/9/2022 7:01 PM, David Cousens wrote: However, I do NOT understand why you were treating your Paypal account as a liability. AFAIK, Paypal does not offer credit. PayPal do offer credit [8]https://www.paypal.com/uk/webapps/mpp/paypal-virtual-credit although I consider the PayPal account an asset. It's much like a bank account - money goes in and out. It's a bit more complicated though, as often transactions involve another currency. Selling things with PayPal obviously adds another bit of complexity as there are fees then, but for now I just want to sort out how to record purchases - I will worry about sales later. Michael D Novack Dave References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org 3. mailto:drkir...@kirkbymicrowave.co.uk 4. mailto:stepbystepf...@comcast.net 5. mailto:gnucash-user@gnucash.org 6. mailto:canx10hafdo7ipn4xzyvmghsaa250yk4vofbcxr5jx4a-gt3...@mail.gmail.com 7. mailto:stepbystepf...@comcast.net 8. https://www.paypal.com/uk/webapps/mpp/paypal-virtual-credit ___ 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] pre-paid electronic toll card
The card, with a cash value on it, is an asset - probably best described as a "prepaid expense." The fully accurate way to account for it: 1. When you "put cash onto the card": -- credit "cash" (or bank account, or credit card, or wherever you get the money that you put onto the toll card) -- debit the pre-paid asset account (increasing its value). 2. When you use some of the balance on the card to pay a toll: -- credit the pre-paid asset account (decreasing its value), and -- debit an "Expense-tolls" account The other way, the simple way, is to just debit "expense- tolls" when you "load up" the card. This is fewer transactions, less bookkeeping, but it "lumps" all your toll expense into a bigger amount and into the date on which you "load" the card. - Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Tuesday, October 18, 2022, 12:00 PM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 235, Issue 45 Send gnucash-user mailing list submissions to [3]gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to [5]gnucash-user-requ...@gnucash.org You can reach the person managing the list at [6]gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Accounting for a pre-paid electronic toll card (Tony Vanson) -- Message: 1 Date: Tue, 18 Oct 2022 22:54:28 +0700 From: Tony Vanson [7] To: gnucash-user [8] Subject: [GNC] Accounting for a pre-paid electronic toll card Message-ID: [9] Content-Type: text/plain; charset="UTF-8" I'm hoping that someone on this list can aid my befuddled brain to get to grips with my problem. The tolling system here is not the automated ones I'm used to. Here one needs to obtain an electronic card and, once done, must be charged with a cash value prior to travelling and topped up with cash on a regular basis. My question is what category is this card and how do I treat additions and subtractions from it? I initially thought it might be treated as a credit card but the way it operates it's obviously not. Any advice would be much appreciated *Tony Vanson* *The older I get,* *the better I was* -- Subject: Digest Footer ___ gnucash-user mailing list [10]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [11]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. -- End of gnucash-user Digest, Vol 235, Issue 45 * References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. mailto:gnucash-user-requ...@gnucash.org 6. mailto:gnucash-user-ow...@gnucash.org 7. mailto:tonyvan...@gmail.com 8. mailto:gnucash-user@gnucash.org 9. mailto:cacnjauczzekyqroourhg7fkga7nf7s0r_zlndhys74318gh...@mail.gmail.com 10. mailto:gnucash-user@gnucash.org 11. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ 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] How is A-L=Eq+(Inc-Exp) correct?
I think it may be TIMING which is confusing it - - - like this: Keep in mind the basic fact that a Balance Sheet measures Assets Liabilities + Equity as of a specific MOMENT - a POINT - in time. But Income and Expense can only be measured OVER A PERIOD of time, since they are MOVEMENTS of things of value. They can only be non-zero over a PERIOD of elapsed time. They are, by definition, zero, at every single MOMENT or POINT in time. So A-L = EQ at every point in time. This is always so because by definition these measurements (Assets, Liabilities, Equity) include all Inc + Exp which have been recorded in all periods BEFORE that MOMENT or POINT in time. If you understand this, then perhaps you can see that dealing correctly with TIMING is crucial, when you try to draw non-zero Inc+Exp into the Balance Sheet equation - - because the equation deals only with MOMENTS or POINTS in time. So: Starting with A-L=EQ (balance sheet) measured at the BEGINNING of a PERIOD ... You can only measure and add Inc + Exp recorded OVER a period (which can be something more than zero ONLY over a period). When you DO add Inc+Exp measured over a period, then you must "update" the balance sheet tally's (A, L, EQ) to the END of that period, in order for the balance sheet to still balance. And when you do update A, L + EQ to the end of that period, by definition Inc+Exp are zero AS OF THAT NEW END POINT in time ... because these can only exist and be measured OVER A PERIOD of time. So then going back to your original construction of the question: (A+L) =/= [not equal] EQ+ (Inc+Exp) ... This "still works" when you add or "force" non-zero Income + Expense into the equation, ONLY when you deal logically and correctly with the timing of that Inc+Exp: (Assets-Liabilities at the END of a period) ... DOES in fact equal ... [ (Equity at the BEGINNING of a period) + (Income - Expense OVER that period) ] So to summarize: the only way to add or include non-zero Inc+Exp into the Balance Sheet equation, is: 1. to recognize the fact that Assets Liabilities + Equity are measured AT A POINT in time, 2. while Income and Expense are measured OVER A PERIOD of time ... 3. then to re-construct or adjust the balance sheet equation with the Asset, Liability, and Equity measurements at points in time that are logically consistent with the period of time over which the Income+Expense (which you're trying to add to this equation) were measured. This has logical integrity to it, so it keeps the equation balanced. That is ... TIMING is the crucial "new" piece that you need to deal with, as soon as you try to incorporate non-zero Inc + Exp into the Balance Sheet equation. Hope this helps. Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Monday, August 29, 2022, 12:00 PM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 233, Issue 86 Message: 1 Date: Sun, 28 Aug 2022 17:38:03 -0500 From: "W. Neal Lewis" [3] To: [4]gnucash-user@gnucash.org Subject: [GNC] Can someone tell me how A-L=Eq+(I-Ex) is correct? Message-ID: [5]<75b5c885-4b07-d1e3-ccf3-6b5fb39cf...@southwind.net> Content-Type: text/plain; charset=UTF-8; format=flowed I will agree that by mathematical logic, Assets-(Liabilities)=Equity. ? Assets+(Liabilites)-(Liabilities)=Equity+Liability, or stated more simply, A=Eq+L. I have added Liability to both sides ? both sides remain equal. However, although(A+L)=Eq, (A+L) =/= Eq+(Inc+Exp). I have added a term to the right side that is most decidedly not on the left therefor they cannot be equal. Therefor A and L must be terms that include other factors. Not good at accounting, I will ask what those other factors are. I want to use GnuCash but I am having trouble getting my mind to accept an equation that is not correct unless terms are redefined. Please help me with my (obviously) incorrect understandings. Thank you, Neal Lewis References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org 3. mailto:wnle...@southwind.net 4. mailto:gnucash-user@gnucash.org 5. mailto:75b5c885-4b07-d1e3-ccf3-6b5fb39cf...@southwind.net ___ 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] gnucash-user Digest, Vol 233, Issue 68
GnuCash will do the accounting fine. It won't do the equipment, RMA, and inventory tracking. I suspect it'll be very hard to find a software which integrates these other functions with accounting - because of that, if it were me, I'd use GnuCash for the accounting, and look for other solutions for the other functions. Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Saturday, August 20, 2022, 11:54 AM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 233, Issue 68 Message: 7 Date: Sat, 20 Aug 2022 10:32:03 -0400 From: Dave Mueller AA3EE [3] To: [4]gnucash-user@gnucash.org Subject: [GNC] Is GnuCash right for me? Message-ID: [5]<3d2f789355cdf0a0da9e91379e1d3...@ditdit.us> Content-Type: text/plain; charset=US-ASCII; format=flowed HI Everyone, Sorry for the totally noob uneducated question. I'm an engineer by training, not an accountant! I recently started a home business and everyone said "Quickbooks". It's too expensive and I despise subscription software. Online/cloud options are not an option, we have limited (and expensive) internet where we live. The business is repairing custom electronic equipment. What I want/need: Basic money tracking for the checking account. Keep track of equipment based on serial number (I was thinking a database). Here I will keep a record of owner(s), data like software versions, and work done per RMA. RMA tracking (another database?). Ability to generate RMA numbers or use one supplied by the distributor. Invoicing based on what was done on an RMA (labor, parts and state tax if applicable). Simple payroll (I'm the only employee). Light duty inventory control. I have about 30 items, some are almost too cheap to track, a few items are expensive, some of those are supplied by the manufacturer so I need to settle with them at the end of the month. My wife wants to run the entire business from Excel, and in one spreadsheet I think? Databases seem more proper to me :-) Thanks and enjoy the weekend. Dave -- Dit Dit Electronics References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org 3. mailto:d...@ditdit.us 4. mailto:gnucash-user@gnucash.org 5. mailto:3d2f789355cdf0a0da9e91379e1d3...@ditdit.us ___ 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] gnucash-user Digest, Vol 230, Issue 18
The simplest way is to just consider the purchase price to be $95,000, not $100,000. (If you really want to capture the seller credit, you "could" record the purchase price at $100,000, and create another "split" in the transaction: $5,000 credit to a new account - - for instance, "Income:credit for repairs.") Chris *From:* gnucash-user-requ...@gnucash.org *Sent:* Saturday, May 7, 2022, 11:00 AM *To:* gnucash-user@gnucash.org *Subject:* gnucash-user Digest, Vol 230, Issue 18 > Message: 11 Date: Sat, 7 May 2022 11:00:05 -0400 I am still learning double-entry accounting, and I need a little help. I recently purchased a home, but the price was reduced during negotiation and a seller credit was applied at closing. Agreed Purchase Price: $100,000 Seller Credit for Repairs: $5,000 Actual Purchase Price: $95,000 When I add this asset, I am stumped.? When I increase the asset by $100,000 and decrease other accounts for cash and loans of $95,000, that all makes sense.? But how do I account for the $5,000?? I see it as an unrealized gain... instant equity provided by the seller. But I need to debit an account with this amount, so it shows an unrealized gain of -$5,000. Should I simply just increase the asset by $95,000 and not account for the credit? I know I am missing the big picture.? Can anyone point me in the right direction? Thanks to all, Mike ___ 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-user Digest, Vol 230, Issue 18
The simplest way is to just consider the purchase price to be $95,000, not $100,000. (If you really want to capture the seller credit, you "could" record the purchase price at $100k, and create another "split" in the transaction, $5,000 credit to a new account, for instance, "Income:credit for repairs.") Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Saturday, May 7, 2022, 11:00 AM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 230, Issue 18 -- Message: 11 Date: Sat, 7 May 2022 11:00:05 -0400 From: M [3] To: [4]gnucash-user@gnucash.org Subject: [GNC] Account for Seller Credit when purchasing a home Message-ID: [5] Content-Type: text/plain; charset=UTF-8; format=flowed I am still learning double-entry accounting, and I need a little help. I recently purchased a home, but the price was reduced during negotiation and a seller credit was applied at closing. Agreed Purchase Price: $100,000 Seller Credit for Repairs: $5,000 Actual Purchase Price: $95,000 When I add this asset, I am stumped.? When I increase the asset by $100,000 and decrease other accounts for cash and loans of $95,000, that all makes sense.? But how do I account for the $5,000?? I see it as an unrealized gain... instant equity provided by the seller. But I need to debit an account with this amount, so it shows an unrealized gain of -$5,000. Should I simply just increase the asset by $95,000 and not account for the credit? I know I am missing the big picture.? Can anyone point me in the right direction? Thanks to all, Mike References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org 3. mailto:m_st...@hotmail.com 4. mailto:gnucash-user@gnucash.org 5. mailto:mw4pr04mb7460d540d47f5148454840c290...@mw4pr04mb7460.namprd04.prod.outlook.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-user Digest, Vol 229, Issue 39
Ken, You can hold other "commodities" (in addition to currencies) in INVESTMENT acct's - which are asset accounts, rather than equity accts. I think the contribution of an asset like stamps, bitcoin, etc would be recorded with an "opening balance" entry which credits the equity account, balancing with a debit (increase) to the investment asset account. Chris __ Message: 1 Date: Sat, 23 Apr 2022 21:10:03 +1000 From: [1]davidcousen...@gmail.com To: [2]gnucash-user@gnucash.org Subject: Re: [GNC] Why does an Equity account have to be of Currency type? Message-ID: [3]<562e2258bd573a8cffb2e690e2eaae3da31333bf.ca...@gmail.com> Content-Type: text/plain; charset="UTF-8" Ken All accounts have a currency associated with them. When you hold an asset, you hold it at a value in a particular currency, not as an item of indeterminate value. You would require an inventory (which GnuCash does not have to hold the items and in inventory accounting each item still has a value, usually its cost to either buy or produce which is used to calculate the value of the items held in the corresponding inventory account. An inventory account would not dissimilar to a stock account. David Cosuens On Sat, 2022-04-23 at 17:46 +0800, km22 wrote: Hi, I am starting a new Gnucash file for a simple "mock" trust. The trust holds physical assets (like stamps and coins and other collectibles). I want to represent the contributions to this trust in the form of these assets. However, when I try to create new Equity accounts for the contributions it only allows me to use "Currency" type assets. I don't understand why Gnucash would force this limitation. Why wouldn't a user be allowed to use any asset type they wish (stocks, bitcoin, collectables) and not solely the ISO cash types? A screenshot of the issue is attached. Thanks, Ken References 1. mailto:davidcousen...@gmail.com 2. mailto:gnucash-user@gnucash.org 3. mailto:562e2258bd573a8cffb2e690e2eaae3da31333bf.ca...@gmail.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.
[GNC] Asset price source: select by account or commodity?
Hi - I'm using GnuCash for personal finances. There are 2 distinct types of commodity assets I want to account for: #1. Conventional financial market securities like stocks and mutual funds. These work well using the well-established Buy + Sell transactions, lots, and setting Price Source as "Last up thru Report date" when creating Balance Sheet reports. #2. Home heating fuel, specifically propane gas (LPG): We buy propane in deliveries of hundreds of gallons. A delivery is enough to heat the house for several months. I want to be able to report the value of the propane in our tank as an asset, valued at the price we paid for it based on FIFO. A balance sheet does this when buy's, sell's, and lots are set up correctly, and I set (Options > Commodities > Price Source) to "Average cost of purchased weighted by volume." Is there any way to differentiate Price Source by asset? That is, set or select Price Source to: "Average Cost" for Propane, and "Last up thru Report date" for financial assets? Thanks in advance. Chris ___ 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.
