Re: [GNC] Difference between Net Loss and Retained Earnings
Net loss or profit is for a specific period of time. Retained earnings would be for the whole file up until the last closing period. So if your annual start date is the end of the calendar year, then the retianed earnings would be the equivalent of running a profit and loss since the beginning of the file up until 12/31/2017. Rick Copple Window Cleaning Specialist Copple Cleaning Service <http://www.copplecleaningservice.com> On Jun 18, 2018, 4:20 PM, at 4:20 PM, Gareth Davies via gnucash-user wrote: >Again another Newby question. > > > >When I generate a Profit and Loss report it shows a net Loss for the >period >of £567, yet on the Balance Sheet report it shows a Retained Earnings >figure >of £701. > > > >I dont understand why the difference, as I thought Retained Earnings >meant >Profit. > > > >Any help much appreciated. > >___ >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] A/P: invoice not displayed and payment is displayed
On 05/30/2018 07:45 AM, Rich Shepard wrote: On Wed, 30 May 2018, Maf. King wrote: Yes, tedious unpost-repost is probably the thing to do. Maf, There were only about 10 transactions in that subaccount. Three of them were payments which I corrected in the checking account register, the rest I corrected by displaying the invoice, unposting, and reposting changing the reporting account to 'accounts payable' itself. That removed all transactions from the 'bad subaccount' register. But if you delete a normal account which contains transactions, GC will ask you if you want to re-assign the txns to another account or delete them... Don't know if that will work for payables with posted entries, which are generally read-only... no ham in trying (on a backup) Rich, I have my A/R set up as sub accounts. Here's how I handle it. First, you'll want to click the box in the account edit section that says "placeholder" of the parent account. That tells GNUCash that it is a parent account and cannot contain transactions. if you absent mindedly attempt to post something to it, it will give you an error message. That has saved me more than once from posting an invoice (or bill in your case) to that parent account. The downside of this is anytime you post a new invoice or bill, you'll have to set the right account in the posting account field. From then on, it will default to that account the next time you post to it, at least on the A/R side of things. But the really annoying thing about it is every time you want to run a report, you have to set the right account in the report, like the A/R aging report. But I have a rather large credit in A/R that i wanted to separate out, is why I did it. I plan on consolidating those back together once that credit is cleared. But for now, I need it to see that actual total of what I have in A/R without having to adjust for the credit all the time. Hint: if you want to make sure all your payments are going into the same account as your invoices, first open the invoice you want to pay, then click on the payment option (either icon or from the menu), and it will post to the same account. -- Rick Copple ___ 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] Handling VISA Debit Accounts
On 05/07/2018 01:39 AM, Karen Stingel wrote: How does gnc handle the Case of a VISA Debit card? Technically, this is a BANK account with a VISA enabled card and a $0.00 Credit Limit Should it just be created as a normal BANK account type? How I normally handle mine is any transaction I make from my debit card, I enter as a transaction in my bank account, usually using the word "Debit" for the ref. number field. Of course, you could use any code word there you wanted (ex. "Visa", "MC", "CCard", etc.) as long as you are consistent in using the same term. But there is no reason to complicate things by creating this as a separate bank account from the one your funds come out of. As to the rest, I'll let the developers answer those, though I don't see the point in not using the create a new account function in GNUCash itself to create any new accounts you need, or to create a specialized function for handling debit cards. -- Rick Copple Window Cleaning Specialist <http://www.copplecleaningservice.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] help setting accounts to track contributions
On 05/04/2018 08:24 AM, Matthew Pounsett wrote: This doesn't sound straightforward at all. What's complicated about treating joint contributions to the household coffers as "income" to the household? Treating that income as ever-increasing equity would confuse P and cashflow calculations, wouldn't it? I believe what he is talking about as straightforward is fewer entries. IOW, instead of showing an entry from equity to income, you are showing an entry from equity straight to expenses. That eliminates an entry that would otherwise be made. One's P would look a little funky (only showing expenses), but this isn't a business as such that has income other than from the "partners". So actually, it would be more accurate. For instance, think of it as what an accountant I used to work for did. For personal expenses that were drawn on the company, she had a separate set of "books" in equity under draws for their varied personal expenses. Reverse that, and you have money being contributed by a partner going to pay bills. Same thing. So it makes sense from that perspective. The only advantage I can see to entering from equity to income, and then paying the bills is that you can get the whole thing on one report which would make it clear who is paying what, but only for a specific period of time. That said, it would be just as easy to look in equity and see who is behind and who is ahead to decide who pays the next bill. That has the advantage of not having to worry about running a P for that purpose at all, other than to see what your expenses were for a specific period of time, or being force to run a P for the time of the whole file to see that information. Easier to look at the chart of accounts to see the whole picture of who is ahead or not. For instance, let's say you had to pay a bill for electricity of $200.00. It would be one simple entry to record it: Equity:Owners Investment:P1 CR: 200.00 Electricity DB 200.00 OR Equity:Owners Investments:P1 CR 100.00 Equity:Owners Investments:P2 CR 100.00 Expense:Electricity DB 200.00 Your done. To record it the other way would mean: Bank Account: DB 200.00 Income:P1 CR 200.00 OR Bank Account: DB 200.00 Income:P1 CR 100.00 Income:P2 CR 100.00 And then: Bank Account: CR 200.00 Expense:Electricity: DB 200.00 You'll get a nicer P, but I don't know how valuable that is in this situation. It sounds to me like they mainly want to record expenses and have an easy way to make sure they are paying an equal share. Either method would accomplish that, but the former method has less data entry to accomplish that. We'll leave it up to them which route they want to take. -- Rick Copple Window Cleaning Specialist <http://www.copplecleaningservice.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] splits 3+ accounts, how to
On 04/20/2018 10:58 AM, Rich Shepard wrote: Perhaps I can provide an example that helps. When I pay my mortgage each month I assign the total payment to 3 debit acounts accessed using the Split menu function. The standard three debits (increases) are: Expense -> Mortgage interest, Expense -> Mortgage escrow, and Liability -> Mortgage principal. The total of these three amounts are offset by their total in the credit (decrease) to my checking account. I think what you may be missing is in splits, there has to be a line for the current register's transaction in the split itself. So for example the above example would look something like this: Checking account: $1000.00 Mortgage Interest: $100.00 Mortgage escrow: $300.00 Mortgage Principle; $600.00 When you do the above, $1000.00 would appear in the checking account line from the split where you enter the amount for the checking account. You don't enter it directly, but in the splits. So you're 3 part split is actually a 4 part split. :) -- Rick Copple Window Cleaning Specialist <http://www.copplecleaningservice.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: Problem with tax table under sqlite3
On 03/27/2018 08:26 AM, Geert Janssens wrote: I have tried to reproduce on 2.6.18 but I can't. I have started with an old sqlite based book, created a new invoice in it with a tax table set and posted the invoice. Looking in the AR register, the transaction does have have the correct tax splits. Can you share a minimal test file in which you have reproduced the issue ? I've created a test file with the minimal data to create invoices. It all worked as expected. I created an XML file and entered the sales tax in the table, then created a dummy invoice to make sure it was working. Then I saved the file. Right after that, I saved the file in SQLite3 format. Then created another dummy invoice. It created the sales tax in the liability account just fine. So I exited and restarted the program, and it still recorded the sales tax in the liability acct. as one would expect. This caused me to suspect something was amiss with my file, and I postulated it was something in the XML's sales tax table file that wasn't being converted over to SQLite3 correctly, causing the problem. So I went into the XML file, and created a NEW sales tax item (I had only edited it in times past). I then saved it in the XML file, and then saved it again in the SQLite3 backend. Upon entering an invoice, it recorded the sales tax correctly. I exited and restarted the program, and entered another invoice, and it too recorded the sales tax correctly. So the issue has been resolved I can now use the SQLite3 backend without having to mess with the sales tax table everytime. The only thing I can think of is that something "corrupted" the sales tax entry in the XML file so that when I converted it over to SQLite3, it stopped accumulating. Strange. But it apparently happened in my case. Anyway, thanks for helping me with this. Glad I was able to figure it out! -- Rick Copple ___ 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: Problem with tax table under sqlite3
Sure, will do so when I get back home this evening. Thanks. Rick Copple On Mar 27, 2018, 8:26 AM, at 8:26 AM, Geert Janssens <geert.gnuc...@kobaltwit.be> wrote: >Op maandag 26 maart 2018 02:29:12 CEST schreef John Ralls: >> > On Mar 25, 2018, at 5:21 PM, Rick Copple ><r...@copplecleaningservice.com> >> > wrote: >> > >> > Thank you, John, for bearing with me. >> > >> > On 03/25/2018 04:37 PM, John Ralls wrote: >> >> Rick, >> >> >> >> OK, I'll try again. You reported that when you post an invoice "it >fails >> >> to accumulate in the liability account" until you "edited the tax >table >> >> [and]... reposted that invoice. Then it showed up in the liability >> >> account..." >> >> >> >> Then you "went back in" (presumably having quit and restarted >GnuCash) >> >> and tried to post another invoice, only to have to edit the tax >table >> >> again to get to "accumulate". >> >> >> >> I need you to break that down so that I understand exactly what >happened >> >> when and what is the problem. When posting an invoice without >first >> >> editing the tax table: >> >> Is the sales tax liability account register open when you post the >> >> invoice? >> > >> > I've done it both ways, register open and closed. Same thing >happens. >> > >> >> Are you examining that register immediately after posting the >invoice and >> >> not seeing the invoice's transaction there?> >> > Yes. >> > >> >> What about other accounts (e.g. Accounts Receivable) that the >invoice >> >> should have posted to? If the transaction is present in those >other >> >> accounts, does it include the tax split if you put it in split >view?> >> > Yes, it posts to the A/R account, but without the sales tax split >showing, >> > despite it showing in the invoice itself.> >> >> If the tax liability register was open when you post the invoice, >does >> >> closing and reopening it change anything?> >> > No, it is either there or not. >> > >> >> Otherwise, if the splits are all there after you post the invoice, >do >> >> some or all of them disappear when you quit and restart GnuCash?> >> > The splits are not there after I post an invoice unless, for that >session >> > since opening the program, I first edit the tax table to include >the tax >> > %. The strange thing is when I go to edit it, the name of the sales >tax >> > item in the left pane shows up, in my case "Marble Falls", but >there is >> > nothing in the right window UNTIL I click on the name "Marble >Falls", >> > then the "Sales Tax Payable" account shows up in the right window >(it >> > does the same thing in the XML database, but it still calculates it >> > correctly). It doesn't accumulate the sales tax into that >> > register/account until I edit the entry on the right side (it shows >8.25% >> > as I had entered before), and then once I go in and edit the >invoice that >> > didn't post sales tax, unpost it, save the line by clicking through >it, >> > then reposting it.> >> >> You report all this for the Sqlite3 backend. Does it work >correctly when >> >> you do the same using the XML backend?> >> > Yes, it works as expected for the XML backend. It is only in the >Sqlite3 >> > backend that I've had this happen. Note, I've not attempted using >MySql >> > or PostSql on this as it would require me stetting it up. I don't >know if >> > it would do the same thing on those backends or not. >> > >> > I've experimented with this some and can't seem to isolate why this >is >> > happening. If you can think of anything else I could try, let me >know. >> Thanks, now I understand what's happening. >> >> What I don't understand is why the backend would make a difference. >Geert >> will be back on Tuesday and he's way more familiar with the business >code. >> Maybe he'll have an idea of what's going on. >> >Unfortunately neither do I. > >I have tried to reproduce on 2.6.18 but I can't. I have started with an >old >sqlite based book, created a new invoice in it with a tax table set and >posted >the invoice. Looking in the AR register, the transaction does have have >the >correct tax splits. > >Can you share a minimal test file in which you have reproduced the >issue ? > >Geert ___ 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: Problem with tax table under sqlite3
On 03/25/2018 07:29 PM, John Ralls wrote: Thanks, now I understand what's happening. What I don't understand is why the backend would make a difference. Geert will be back on Tuesday and he's way more familiar with the business code. Maybe he'll have an idea of what's going on. Cool. I look forward to his analysis. Rick Copple ___ 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: Problem with tax table under sqlite3
Thank you, John, for bearing with me. On 03/25/2018 04:37 PM, John Ralls wrote: Rick, OK, I'll try again. You reported that when you post an invoice "it fails to accumulate in the liability account" until you "edited the tax table [and]... reposted that invoice. Then it showed up in the liability account..." Then you "went back in" (presumably having quit and restarted GnuCash) and tried to post another invoice, only to have to edit the tax table again to get to "accumulate". I need you to break that down so that I understand exactly what happened when and what is the problem. When posting an invoice without first editing the tax table: Is the sales tax liability account register open when you post the invoice? I've done it both ways, register open and closed. Same thing happens. Are you examining that register immediately after posting the invoice and not seeing the invoice's transaction there? Yes. What about other accounts (e.g. Accounts Receivable) that the invoice should have posted to? If the transaction is present in those other accounts, does it include the tax split if you put it in split view? Yes, it posts to the A/R account, but without the sales tax split showing, despite it showing in the invoice itself. If the tax liability register was open when you post the invoice, does closing and reopening it change anything? No, it is either there or not. Otherwise, if the splits are all there after you post the invoice, do some or all of them disappear when you quit and restart GnuCash? The splits are not there after I post an invoice unless, for that session since opening the program, I first edit the tax table to include the tax %. The strange thing is when I go to edit it, the name of the sales tax item in the left pane shows up, in my case "Marble Falls", but there is nothing in the right window UNTIL I click on the name "Marble Falls", then the "Sales Tax Payable" account shows up in the right window (it does the same thing in the XML database, but it still calculates it correctly). It doesn't accumulate the sales tax into that register/account until I edit the entry on the right side (it shows 8.25% as I had entered before), and then once I go in and edit the invoice that didn't post sales tax, unpost it, save the line by clicking through it, then reposting it. You report all this for the Sqlite3 backend. Does it work correctly when you do the same using the XML backend? Yes, it works as expected for the XML backend. It is only in the Sqlite3 backend that I've had this happen. Note, I've not attempted using MySql or PostSql on this as it would require me stetting it up. I don't know if it would do the same thing on those backends or not. I've experimented with this some and can't seem to isolate why this is happening. If you can think of anything else I could try, let me know. Thanks for your time. Rick Copple ___ 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: Problem with tax table under sqlite3
Sorry John, thought I did. I was on my cell phone and it quoted the whole thing, but my answer to your question was at the top, which I've quoted below now that I'm home and can respond via my computer. Sorry for any confusion. Unless I completely misunderstood your question and you did see my answer, which is always a possibility as well, in which case, you may need to clarify what you were asking. Rick Copple On 03/25/2018 01:28 PM, John Ralls wrote: Rick, Please answer the question instead of repeating what you already reported. Regards, John Ralls On Mar 25, 2018, at 10:43 AM, Rick Copple<r...@copplecleaningservice.com> wrote: When I quit and restart the program, then it stops accumulating in the tax liability acct. Rick Copple ___ 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: database problem with invoices to more than one customer
Try using the customer without the job, or with a new job. Each job is attached to a specific customer. Rick Copple On Mar 25, 2018, 10:18 AM, at 10:18 AM, Vario816 <993...@gmx.net> wrote: >Screenshots came out to small. Re-post > ><http://gnucash.1415818.n4.nabble.com/file/t377995/GnuCash_client_data.jpg> > > ><http://gnucash.1415818.n4.nabble.com/file/t377995/GnuCash_client_data2.jpg> > > ><http://gnucash.1415818.n4.nabble.com/file/t377995/GnuCash_client_data3.jpg> > > ><http://gnucash.1415818.n4.nabble.com/file/t377995/GnuCash_client_data4.jpg> > > ><http://gnucash.1415818.n4.nabble.com/file/t377995/GnuCash_client_data5.jpg> > > > > >-- >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.
Re: Problem with tax table under sqlite3
When I quit and restart the program, then it stops accumulating in the tax liability acct. Rick Copple On Mar 25, 2018, 9:36 AM, at 9:36 AM, John Ralls <jra...@ceridwen.us> wrote: > > >> On Mar 25, 2018, at 1:47 AM, Rick Copple ><r...@copplecleaningservice.com> wrote: >> >> I decided to switch back to the sqlite db to see if it still did the >same thing as before: even though an invoice shows the breakdown of >sales tax, it fails to accumulate in the liability account. It did fail >to do so on a test invoice I had plugged in. So I edited the tax table, >then went back and reposted that invoice. It then showed up in the >liability account and I figured all was well. >> >> Not so fast. When I went in it today to put another invoice in, it >again failed to accumulate in the liability acct. I had to edit the >sales tax table again and repost the invoice to get the sales tax to >accumulate. >> >> My question is, is this a known bug for ver. 2.6.12 running under >Ubuntu? I'm on 16.04.4 LTS. >> >> Or is there something else at play here that I'm unaware of? >> >> Thanks for your help. > >I don’t see anything that looks similar in the bugs. > >When you say that the new tax liability isn’t getting credited to the >tax account do you mean the register in the still-running GnuCash or do >you mean after quitting and restarting? > >Regards, >John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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: database problem with invoices to more than one customer
From your screen shot, it appears you are attempting to enter a new customer from the invoice detail screen. If you wish to create a new invoice, whether a new customer or the same one, you have to start by entering a new invoice. Via the menu, you would go to "Business," "Customer," "New Invoice..." All that spot on your screen shot allows is for you to edit the details of that customer. But you cannot change the customer or start a new invoice through that field. -- Rick Copple On 03/24/2018 04:05 PM, Vario816 wrote: hi folks, i am a newbie here. i had installed GnuCash a couple of days ago and have been through some tutorials since. All good. However, at the moment I am failing to create invoices to more than one customer. I have added a number of various customers and then I started creating invoices. But already on the first invoice to another/different customer the info on the first customer which I have ever entered pops back in the menu 'billing information'. I have tried all ways through various menu shortcuts trying to create more invoices. But the problem remains. In the first step it I can also search for other customers I entered and saved b4 and add them together with invoice ID, job and billing ID. But after pressing 'ok' then everytime the ever first made entry/name in the customer database pops up under 'billing information'. Now, I am stuck. I am limited to book invoices for one customer only... Can anyone in the community assist, please? Win7Pro - 64 bit - GnuCash 2.6.19 <http://gnucash.1415818.n4.nabble.com/file/t377995/GnuChash_Billing_Info_Problem.jpg> ___ 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.
Problem with tax table under sqlite3
I decided to switch back to the sqlite db to see if it still did the same thing as before: even though an invoice shows the breakdown of sales tax, it fails to accumulate in the liability account. It did fail to do so on a test invoice I had plugged in. So I edited the tax table, then went back and reposted that invoice. It then showed up in the liability account and I figured all was well. Not so fast. When I went in it today to put another invoice in, it again failed to accumulate in the liability acct. I had to edit the sales tax table again and repost the invoice to get the sales tax to accumulate. My question is, is this a known bug for ver. 2.6.12 running under Ubuntu? I'm on 16.04.4 LTS. Or is there something else at play here that I'm unaware of? Thanks for your help. -- Rick Copple ___ 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: Average of transactions
I don't believe there is. The easiest way I know to accomplish that is to create a transaction report restricting it to that day and account, then make sure the create a table box is checked. Once you run the report, you can copy and paste the results into a spreadsheet. From there you should be able to get your average. Rick Copple On Mar 19, 2018, 6:49 AM, at 6:49 AM, Muhammad Bashir Al-Noimi <mbno...@gmail.com> wrote: > Hi, > I've a liabilities account and I want to get the daily average of its > transactions. Is there any report can calculate this value. >-- >Best Regards, >Muhammad Bashir Al-Noimi >Skype+Telegram+GMail: mbnoimi >___ >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: Check Printing Question
On 03/12/2018 04:29 PM, Jay Ridgley wrote: Good Afternoon, I have Quicken Wallet Checks w/side stub. These are 3 up with a tab at the bottom. When I try to print checks with: Check format: Quicken(tm) Wallet Checks w/side stub Check position: Top Checks on first page: 3 The results are: The first two print properly, however, the third check prints on the tab at the bottom and leaves the third check blank. What have I done incorrectly? I run Ubuntu 16.04.4 LTS w/Cinnamon Desktop and GnuCash 2.6.12. Regards, Jay Hi Jay, You can edit and fix any check format by going to ~/.gnucash/checks in your file manager. There are some text files there that contain the code for where to put lines on the checks. You can find out more on how to edit them at <https://lists.gnucash.org/docs/C/gnucash-guide/check_format_info.html> I had to do this some time ago to get it to print on Quickbooks style 3 part, 1 page checks as the one they provided didn't work either and didn't include accounts and line notes needed for printing paychecks and stubs. Good luck! -- Rick Copple <http://www.copplecleaningservice.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.
Warning, possible bug, and question
I am using GNUCash 2.6.12 on an Lubuntu desktop environment running on Unbuntu 16.04.4 LTS. I just discovered tonight that my sales tax had stopped accumulating in the sales tax account since an invoice on 2/1/18. I only noticed it tonight because I wanted to know how much sales tax today's invoices had recorded and when I went in, that's when I discovered the truth of what had been going on. Yikes! After some investigation, I discovered that the sales tax liability account (I used the default) had somehow become disassociated with the sales tax item, which apparently caused it to send the full amount of the payment into the Undeposited Funds account instead of splitting out the sales tax. On the invoice, it showed the sales tax item, and the sales tax being split out like normal, but apparently it wasn't actually splitting it out to the sales tax account. I suspected when this happened, as earlier that month I switched from using an XML books to an SQLite books. Then after using it on that for a couple of weeks, decided to switch back (took just as long to open and it did create a significantly bigger file, even though I have plenty of room, but . . .) to an XML format data file. I noticed in my file's A/R account, that on 2/1/18, I had entered one last invoice that did split it out, but the following invoice on the same day didn't split the sales tax out, so I knew it had to have happened between those two invoices. So upon looking at the SQLite file and then the original XML file, I determined that it happened when I first changed from an XML file to a SQLite data file. So, that is what happened, at least on my end. I don't know if anyone wants to verify that on their system, but if so, it is a potential bug that may need to be fixed. But at least a warning that whenever one switches to an SQLite or any other format, to check the sales tax item to make sure it is still linked to its sales tax account. But now I have a question: what is the best way to edit almost a month and a half of invoices to fix this problem? I know one way to do it, but it is tedious. It involves pulling up each invoice since 2/1/18 through 3/11/1/8, unposting, resaving the line, and then reposting each invoice, then reconnecting the payment back to each invoice. Being we have an average of around 5 invoices a day, we're talking about 130 invoices to do that to. I was wondering if it would work and be any easier if I went into my undeposited funds account where all the payments are posted, and edited each entry to include a split for sales tax? Would that mess up anything in the backend of the business functions to do that? Or is there yet another way of accomplishing that which is easier? Thanks for your help. -- Rick Copple ___ 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: Installation
On 02/12/2018 10:45 AM, David Carlson wrote: However, one reason (of several) that I personally am not using a cloud service yet is that I do not see how the cloud would handle all all those log files coming and going and data files being renamed every few minutes. I used to keep my files on a cloud service but it began to become unstable, so I moved it to my hard drive. I also created a script file that would run on a chron job automatically to backup my directory to one on my cloud drive: #!/bin/bash echo "\n---\n Backup changed files on $(date) \n" | tee -a "/home/rick/CCS-BackUpLogs/CCS-BackUp.log" rsync -avW --delete-before "/home/rick/Documents/CCS" "/home/rick/OneDrive" | tee -a "/home/rick/CCS-BackUpLogs/CCS-BackUp.log" echo "\nFinished!" | tee -a "/home/rick/CCS-BackUpLogs/CCS-BackUp.log" exit Works well for me at any rate. -- Rick Copple ___ 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: inventory management examples or links
I have an inventory of books I keep on a spreadsheet. I've designed the spreadsheet to give me an average cost that I can then plug into gnucash. Do you want a screenshot of my inventory account? I could probably get to that this afternoon central time. Rick Copple On Feb 12, 2018, 6:26 AM, at 6:26 AM, Bert Heijne <berthei...@outlook.com> wrote: >Hello All. > >This is a nice treat about Inventory but are there some “real examples” >or “ putting it all together” of gnucash for Inventory or stock of >goods management? >And how this is covered with the invoice. >I now that gnu cash is not build for that but small stock would be nice >Woocommerce webshop is in construction so this will be covered mostly >by WC. > >Would be nice to see some real samples in gnucash to study. >Any links or G search links would be nice > >Gr. Bert > >Verzonden met Windows Mail > >Van: Robert Heller<mailto:hel...@deepsoft.com> >Verzonden: zondag 11 februari 2018 17:15 >Aan: >stepbystepf...@dialup4less.com<mailto:stepbystepf...@dialup4less.com> >CC: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> > >At Sun, 11 Feb 2018 10:55:58 -0500 stepbystepf...@dialup4less.com >wrote: > >> >> On 2/11/2018 9:03 AM, Robert Heller wrote: >> > At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson <j...@p27.eu> >wrote: >> > ... transfer >> > "money" from the vegetable account to a bank account (income when >you sell >> > vegetables) and when you transfer money from a bank account to the >vegetable >> > account (an expense when you buy vegetables). *I* do this which my >inventory >> > of thumb drives. GnuCash does not have "inventory" accounts or any >way of >> > dealing with inventory as such >> Inventory MANAGEMENT is something else (gnucash lacks this but that >> belongs in an inventory system*, not "general ledger". > >Yes, I understand. > >> >> But you are saying that gnucash does not support inventory value and >> cost accounting and that is simply not so. > >Only in the sense of not specificly labeling things as "inventory value >and >cost accounting". You are right, one can use gnucash to "manage" >inventory >value and cost accounting. From the point of a newbie, there isn't a >specific >menu of things relating to inventory value and cost accounting, so >there is >the *appearence* of a of lack of support for inventory. My intent was >to point >the OP in "right direction", one that is not obvious. Inventory value >and cost >accounting is handled in GnuCash under "other names" -- it is a matter >of >understanding that inventory is really a kind of asset (that is bought >and >sold) and can (should) be treated as such, at which point all of pieces >fall >into place. The OP wanted to treat his inventory as income or expense >and that >what was confusing (to him). > >> >> Let's say incidental to its main activity an organization sells >various >> things (tee shirts, coffee mugs, etc.) as a fund raiser. You create >> under Assets (after "current assets" and "fixed assets") a parent >> "Inventory of goods". Under that might be accounts (more likely also >> parents as batches of goods might have different basis) for "tee >> shirts", "coffee mugs", etc. When the organization buys a new batch >of >> tee shirts that is a debit to "tee shirts" (or as I mentioned, >perhaps >> "tee shirts batch 4" --- the account description can include what the >> unit price was for this batch) and a credit to checking << note: we >get >> confused using the supposedly more user friendly terms worrying about >> what sort of "transfer" this is). Each sale of a tee shirt not only >> debits cash and credits "sale of tee shirts" for the sale price but >also >> debits "cost of goods sold" and credits the inventory account "tee >> shirts batch N" for the unit cost of batch N << going to be a policy >> decision whether to simply use FIFO or to actually worry about from >> which batch that shirt came. Maybe BOTH come into play. To use your >> example, thumb drives, you might have 8 Gb drives (batches of those) >and >> 16 Gb drives (batches of those) so you might want under "thumb >drives" >> children "8 Gb drives" and "16 Gb drives" and under each of those >"batch >> 1, batch2, etc. and use FIFO there >> >> >> >> >> Michael D Novack >> >&
Re: New Entities
On 02/06/2018 08:25 PM, Adrien Monteleone wrote: When you want to switch from one entity’s file to the other, simply open the File menu, look near the bottom and you’ll see a list of recently used Gnucash files. One will be the file you want to open. Click it. Gnucash will open that file, closing the one you were working in. I have four different files I open, one of the every day. Different businesses. What I do is a bit more work to set up, but is easy to navigate, as long as you remember the key combinations. ;) I create keyboard shortcuts in my Lubuntu system with: gnucash "/home/rick/Documents/CCS/GNU Accounting/sqlitedb/CCS.gnucash" - set as an executable in my openbox file, in this case: /home/rick/.config/openbox/lubuntu-rc.xml using the key combo: Ctrl-Shift-H. I've likewise created something similar for the other three files, plus one with simply: gnucash --nofile for when I want to open up a blank copy of the program. Then to switch, all I have to do is to close one file and hit the key combo to open up the other file. I know such key combos are easy to set up in Windows as well. Your on your own for other systems. :) -- Rick Copple ___ 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: Need help with opening my Gnucash software
On 02/02/2018 07:57 PM, Lorrie E Clemens wrote: Hello, I have had this problem before and someone was able to help. I have loaded Gnucash onto my hard drive. That was the previous fix. But every time I try to open it up I get “the file URI/Users/Lorrie/Desktop/imbalance .gnucash could not be found” How do I get into my file? I should add that in Windows, if your path doesn't contain the folder the program is in, you'll have to either add the path or navigate to the directory where it resides at or include the complete path in your run statement. On my Win10 Surface Pro, it put it in "c:\Program Files (x86)/gnucash/gnucash.exe" --nofile -- Rick Copple ___ 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: Need help with opening my Gnucash software
On 02/02/2018 07:57 PM, Lorrie E Clemens wrote: Hello, I have had this problem before and someone was able to help. I have loaded Gnucash onto my hard drive. That was the previous fix. But every time I try to open it up I get “the file URI/Users/Lorrie/Desktop/imbalance .gnucash could not be found” How do I get into my file? Sincerely, Lorrie Sounds to me like that was the last file you had opened, then moved/deleted it, so it is trying to open that file again, but it can't find it. If that is the case, go to a terminal window or a cmd window in Windows, and enter the following command: gnucash --nofile (might be different in Apple?) It should open up a blank copy of GNUCash. Then you can go to file/open or file/new to open or create a file. -- Rick Copple ___ 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.
Exporting customer and vendor data
I checked out the pycash python script for get_customers_from_xml.py as a way of exporting in csv format from the XML file. I believe I've figured out how to make this work. It involves going to <https://github.com/EvansMike/pycash> to download that script. Then, make a copy of your gnucash file. Then rename the .gnucash extension to .zip. This is also a good time to rename the whole file to something different if you have spaces in your filename. Then extract the file from it, which will be the XML file. (I couldn't get it to go inside to access the file, though there may be a way for it to do it.) I also added the .xml onto the file as an extension, though I don't know if that is necessary or not. Then I was able to run the script for extracting customers by going into terminal to the location of your xml file and typing in: python c > . So in my case, I had "python ~/home/rick/MyScripts/get_customers_from_xml.py CCS.xml c > CCSCust.csv" That exported into the output file a list of customers from the XML file which can be imported into your GNUCash file using the "File," "Import," "Customers and Vendors". Select the file at the top, select "Customers" as your import type, and select "Commas with quotes" as the input format. The only thing is it exports all your customers, active and inactive, and imports them all as active. As it says on the site, the export of vendors doesn't work yet. I figured out why and fixed it by adding two lines of code to it. I'll explain further on that point if there is interest in doing so. But I was able to export from the old xml file and import both customers and vendors into a new file using this procedure. Hope this is of help to someone. -- Rick Copple ___ 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.
Are there plans for an export expansion?
Hi, First time posting to this list. I've been using GNUCash for several years now. Currently on a Lunbuntu computer, using GNUCash version 2.6.12. I use it for 4 different businesses, and aside from having no inventory function (I track that in a spreadsheet), it serves my purposes quite well. So, first off, thank you for having this program. It does a great job and is pretty flexible in general. I wanted to know if there was a plan for an export of the various lists like vendor, customer, employee, etc. I see where they can be imported, but no ability to export them. I've tried some of the solutions of creating a transaction report, but I've not be able to get that to include fields like addresses, phone #s, etc. Just the company name. Related to that, it would be nice to be able to do a list report, which could be used to export those same lists, a report that would allow for listing all the fields in the different lists. So, are there any plans for this feature? Thank you! -- Rick Copple Window Cleaning Specialist <http://www.copplecleaningservice.com> ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Manually entering historic records
Hi Trevor, What exactly is it doing to prevent you from entering past dates? I enter them all the time. You do have to enter the / dividers. Like instead of 11418 you would have to enter 1/14/18 to get the date to come out right. -- Rick Copple On Jan 14, 2018, at 12:15 AM, Trevor Richards <tr...@yahoo.co.uk> wrote: > I've been following the user group for years but still not started the move > from 20yrs of MSmoney... all looks too hard with an MSM file with records > back to 1997. > I thought I could test the water with a new business and associated bank > account that started in 2016.I've been managing this with a spreadsheet as > very few transactions. > So I set up a business set of accounts and tried entering manually, the > historic records... I'm immediately stumped. It does not let me enter past > dates. Clearly I'm going about this in the wrong way.Advice appreciated.Trevor > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/ ___ gnucash-user mailing list gnucash-user@gnucash.org 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.