Re: [GNC] Custom Report
On 5/9/2019 8:28 PM, Adrien Monteleone wrote: Excel might be a problem, but LibreOffice has no issues either opening saved GnuCash reports, or importing them as plain text. (copy/paste also works) The only issue with doing comparative P&L’s in a spreadsheet is that each period needs to have all accounts visible so things line up easily, otherwise you’ll have lots of formatting to do. In general, you DO have this "line up" problem since there is no good reason to expect the CoA to be EXACTLY the same in different time periods. This is not different whether doing inside or outside of gnucash. There is not going to be an automatic solution, each situation (of the accounts being slightly different) may call for a different solution and probably an annotation as to what was done. As for how hard to get the exported data into a document under control of an editor, I can't speak about when EXCEL is used since I don't use it. Whether or not a particular editor app is suitable is outside the scope of what I am willing to talk about. I do this all the time, opening the (exported) HTML with the browser I choose to use (FireFox) and then copy the data "unformatted text" into a document under the control of LibreOffice. Do this every quarter for just one period (year through this quarter) except for end of year when after doing this, put in parallel the one form the previous year for the annual financial report. More or less "standard" for a non-profits. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing invoices as paid
Adrien Monteleone writes: > If they are paid, you’d need to have the payment transactions imported > as well. There isn’t any such thing as ‘paid’ with no actual > payment. (as far as I’m aware) You will both have to import the payment transaction, and you will have to *manually* attach the payment to the invoice/customer. There is no importer way to do that. > I don’t know of a way to auto-assign the transactions as being applied > in payment of any particular invoice once they are imported. You might > have to assign those one at a time. (but at least you don’t have to > create the individual transactions) Right. > Perhaps one of the devs familiar with the Business Features can offer > more insight. Nope, nothing more; there is no way to import that metadata at this time. > Regards, > Adrien > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Need help reconciling
On 4/26/19 3:19 PM, ToddAndMargo via gnucash-user wrote: Hi All, I have been looking over the "Reconcile" on on eof m yu credit card account. I just don understand what I am seeing. 1) do I put a "c" in the opening balance as I I has checked it? 2) I have put "C" in all the charges on my bank statement. 3) I press the Reconcile button and I put in the closing data. It puts a weird entry into the the ledger that I don't understand and puts it on one of those weird "you goofed" accounts. And I get no "y"'s. I look at the doc and I have no clue what is going on. https://gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=help https://gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=guide :'( -T okay, I am just not understanding. In the reconcile window 1) I presume "Statement Date" is my statement's closing date? 1) the statement date matches my bank statement 2) starting balance is 0 (it is not) 3) Ending Balance matches my statement 4) there is a -$700 reconcile Balance. I just do not understand ___ 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] Need help reconciling
You have to fix the starting balance first. If this is your first reconcile of a pre-existing account, read the docs as this is a little different. More than likely, you can just reconcile starting from zero and include your Opening Balance transaction which should get you to the proper ending balance. (note, the Opening Balance transaction in this case *should* be equal to the Starting Balance from your first statement that you are reconciling) Regards, Adrien > On May 10, 2019, at 5:04 PM, ToddAndMargo via gnucash-user > wrote: > > On 4/26/19 3:19 PM, ToddAndMargo via gnucash-user wrote: >> Hi All, >> I have been looking over the "Reconcile" on on eof m yu >> credit card account. I just don understand what I am seeing. >> 1) do I put a "c" in the opening balance as I >> I has checked it? >> 2) I have put "C" in all the charges on my bank statement. >> 3) I press the Reconcile button and I put in the closing data. >> It puts a weird entry into the the ledger that I don't understand >> and puts it on one of those weird "you goofed" accounts. And >> I get no "y"'s. >> I look at the doc and I have no clue what is going on. >> https://gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=help >> https://gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=guide >> :'( >> -T > > okay, I am just not understanding. > > In the reconcile window > > 1) I presume "Statement Date" is my statement's closing > date? > > 1) the statement date matches my bank statement > > 2) starting balance is 0 (it is not) > > 3) Ending Balance matches my statement > > 4) there is a -$700 reconcile Balance. > > I just do not understand > ___ 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] Need help reconciling
Todd The Statement date is the closing date on your statement. If the statement date does not match then you set it to the closing date on your statement. I have never changed the reconcile status to c or anything else (unless I needed to manually unreconcile a statement period which I don't ever remember having to do) manually on any transactions. There may be a case for doing this if you use a check book perhaps. The starting balance should be the closing balance of the last reconciliation. If it is 0 the GnuCash does not recognize that there has been any previous reconciliation. In this case if the account setup in GnuCash matches a pre-existing bank account, that account will not have had a zero balance when you started using GnuCash. The first transaction to reconcile will be the transaction setup to set the opening balance in the account when you created it (or set it manually after creation of the account in GnuCash). That opening balance for the account in GnuCash should have been set to the closing balance of the statement of the period before the first period you started using Gnucash. This would appear to be the step you are missing when setting up Gnucash for an existing account. You then enter the closing balance from your current statement as the ending balance for the reconciliation. If it is a credit card and interest charges for the period have not been entered into GnuCash you can enter these by pressing the ENter Interest Charges button . Ignore if the interest charges are already entered or there are none. Press OK. The next window will show payments into the account on the LHS and withdrawals from the account on the RHS. GnuCash will attempt to select those transactions which fall within the statement period set in the previous setup window and they will appear with the checkboxes checked. By default the transactions are usually arranged in date order of the entries. Check 1. Any unchecked entries at the top of either window pane are a likely problem. They will generally indicate unreconciled transactions earlier in your GnuCash records than the period currently being reconciled. They need to be fixed ( identify whether they are duplicates or wrong amounts entered etc) because if not, your reconciliation up to the start of the current period is not correct. After fixing them you will need to at least check that your reconciliation up to the start of the current period is now correct. That may mean reconciling again completely from the start although GnuCash generally appears to reflect any changes you make in the accounts directly into the reconciliation window as they happen. Check 2. In the summary panel at the bottom of the window, the starting balance should be the starting balance of the statement, the closing balance should equal the closing balance of the statement and if you are lucky ( i.e. no errors in the current period), the reconciled balance will equal the closing balance). Check 3 If the reconciled and closing balances match and the difference is zero check that all the payments into the account and withdrawals from the account for the date range in the current period are checked. If this is the case then your reconciliation is probably complete. Check 4 If there are any unchecked payments or withdrawals with dates in the current statement period, then you have an error - find out why and fix it then repeat the reconciliation from the startuntil all of the above are correct. Check 5 If any checked entry in either pane falls outside the date range of the current statement, this is an error either in the date of the transaction. Find out why and fix it - then repeat the reconciliation from the start At this point you can press the finish button and your account should reconcile and the newly reconciled entries will have a "y" in the reconcile status column. I personally do not use the above. I uncheck all entries (Ctrl-A then use the Unreconcile Selection button) then check each entry off individually as I match it against the corresponding entries in the statement, but I'm an accountant and therefore pedantic. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Price Editor Problems
Where, please, can I get wo-to-go instructions to get my stock Price Editor (Re)working?? I am running Ubuntu 18.04. GNC ver 3.5. My stock is all on the ASX (Australia). Things worked wonderfully until the Yahoo demise and then for a while I was able to use Alphvantage but that stopped too. I have tried all sorts of fixes randomly and fear I have completely confused GNC in the process. I would greatly appreciate some step by step assistance. Dave W ___ 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.
