Re: [GNC] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 20:50, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > As Derek noted, this is likely not a bug, but an issue with your pricedb > in your main file. > > I too lost the plot, and forgot that those reports can target which > price to use for such cases. > > Your options then are to: > > 1. Play with the price target option > 2. Edit, or delete the offending price(s) in the pricedb if not needed > elsewhere. > > Regards, > Adrien I am in bed now using my mobile phone so don’t have access to GnuCash to look at anything. I was unaware of the price db, and have not *knowingly* set anything up like I see described here https://wiki.gnucash.org/wiki/Online_Quotes Maybe at some time I did mess around and set something up, and that’s what it is using. However, I have noticed sometimes that GnuCash does suggest a number of GBP to enter for a USD transaction, and it’s “guess” is not wildly out. I have not taken much notice of the values, but they seem to imply £1 is worth more than a USD, but not twice as much. I am not sure how GnuCash will ever be able to make a meaningful report that includes any conversion from pounds to dollars, particularly when each transaction will have a different exchange rate. I have tried to keep things simple when USD or EUR payments are made by bank transfer, by recording only amount in pounds received. I am not going to itemise the bank charge, as it is not recorded in any statement. But with PayPal the transaction fee is always recorded in the statements from PayPal. There’s a fee even on GBP transactions. Dave ___ 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] An operation is still running, wait for it to complete before quitting
On Thu, 30 Nov 2023 at 20:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Have you run Actions > Check & Repair > Check & Repair All? > > There might be something amiss that such scrubbing can clean up. > > Regards, > Adrien I have run that many times. However, I never thought of running it when this happened. will do that next time I get the problem. Thank you for the suggestion. Dave. > ___ 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] An operation is still running, wait for it to complete before quitting
Although the invoice was showing as unpaid as I mentioned, I forcibly quit GnuCash, then saw the $591 invoice was marked as paid. But when I looked at the trial balance I saw this [image: image.png] for a $591 invoice. But there's no way GnuCash should have any idea how any GBP that was, as it was paid as USD directly into a USD PayPal account. After PayPal fees that was $561.80. The P shows $591.00 £443.58 Income statement show the same $591.00 £443.58 I can't see how any accounts will have any idea how many GBP it is as this time. On Thu, 30 Nov 2023 at 15:53, David Kirkby wrote: > This may be related to my other issues, but I sometimes see this. > > I just deleted all my USD transactions, leaving GBP and EUR untouched and > verified that both the P and trial balance showed a zero balance for > goods and services sold in USD. > > Then I tried posting the first invoice and then paying it. But it did not > show as paid. When I try to exit I get this message. Windows task manager > indicates that GnuCash is using virtually no CPU time. (I'm running Windows > 11 and GnuCash 5,4 - Build ID: 5.4+(2023-09-23). > > > [image: image.png] > > > > > -- > Dr David Kirkby Ph.D > Kirkby Microwave Ltd > Email: drkir...@kirkbymicrowave.co.uk > Web: https://www.kirkbymicrowave.co.uk/ > Telephone 07910 441670 (UK) or +44 7910 441670 (international) > Registered in England and Wales, company number 08914892. > Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT > > > ___ 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] An operation is still running, wait for it to complete before quitting
This may be related to my other issues, but I sometimes see this. I just deleted all my USD transactions, leaving GBP and EUR untouched and verified that both the P and trial balance showed a zero balance for goods and services sold in USD. Then I tried posting the first invoice and then paying it. But it did not show as paid. When I try to exit I get this message. Windows task manager indicates that GnuCash is using virtually no CPU time. (I'm running Windows 11 and GnuCash 5,4 - Build ID: 5.4+(2023-09-23). [image: image.png] -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Apparently so! > I have lost the plot I think. I think there's a bug in the reporting. Here's a demo account, with the GBP shown correctly for USD sales, but the value of the USD sales is not given. I don't know if that's intentional or not, but having both the GBP and USD would seem nice. [image: image.png] But the ones I produced for my accountant have the foreign currency too, which is nice. I have not blanked out the $540 transaction, but left that. The GBP amount is wrong. But I'm not sure what the intended behavior of the report is. [image: image.png] Looking in the bank account for that transaction I see [image: image.png] In the trial balance [image: image.png] So there are 3 different GBP figures for these reports. 1) $540 was converted by the bank into £424.00. It shown as that in the bank account. 2) P shows $540 and £441.67. The £441.67 is wrong (£17.67 too high). 3) Trial balance shows £434.98 which is also wrong. (£10.98 too low) I suppose it's worth reporting this as a bug, despite the fact I can't reproduce it in a test case, which would obviously be most helpful to the developers. ___ 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] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 09:18, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Once again - please remember to reply to the list... > OOps. > > It was several replies up the thread, but I was replying to your point > about being able to delete payments for only some currencies. (though > you've now discovered that currency isn't a limitation) > > Here was my posting: > > > Let's get some terminology and workflow straight: > > > > 1. Using the Business Features, Invoices and Bills are entered in a > separate UI, *not* directly in an account register. > > > > 2. Posting these, results in transactions appearing in the respective > A/R or A/P accounts. > > > > 3. Those transactions are immutable at this point and cannot be edited > or deleted from either the AR/AP accounts, or the other side of their > transactions. (Income accounts in the case of Invoices, or Expense accounts > in the case of Bills) At this point, no bank account or other 'payment > account' is involved. > > > > 4. Payments can either be entered via the 'Process Payment' function, or > entered directly into an appropriate account register. (or imported into > said register) If directly entering or importing, you then have to > right-click the transaction and choose 'Assign as payment' to bring up the > 'Process Payment' dialog to formally link the payment transaction to an > Invoice or Bill. These transactions affect and appear in the source account > and either AR/AP accordingly. They are always editable and delete-able from > any affected register. The Invoice/Bill posting status has no bearing on > this. However, while you can edit them directly, you generally should do so > by right-clicking and choosing 'Edit payment'. > > Does that clear up the issue concerning deleting payments? > > Note, I think there is a bug concerning invoices showing still as paid > after a payment is deleted, but that might only be in the Invoice UI. > I'm not sure that is the case everywhere. I'd have to investigate. I > also don't know if that bug has been filed. > > Regardless, if after deleting a payment, you unpost and repost the > invoice, it should now show as unpaid since GnuCash can't find the > original payment to re-link it. > > There is nothing odd about being able to delete a payment. > > Regards, > Adrien > I think I must be going mad. I thought in the past I had always observed an error message if trying to delete a transaction in the bank account that was attached to a posted invoice, using the business features and AR or AP. . But I just checked a previous installation on another computer (slightly earlier release on Linux) and found it is possible to simply delete an entry from the bank account, despite it being attached to a posted invoice. Did I just dream there was an error message generated if one tried to delete a transaction in the bank account, for which there was a posted invoice? Dave ___ 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] Have I got my USD accounts set up wrong?
On Thu, 30 Nov 2023 at 03:48, Alan Hopkins wrote: >Hello David >We receive and pay for a multitude of currencies. This made life >complicated for a small business so we decided to use a FX service - we >use OFX because we managed to get to them in their early days and were >offered a special continuing deal. >However, there are quite a few others too - TransferWise (now just >called Wise) were probably the initiators in this area. >The way it works is that we tell them what we need to pay in FX, we pay >in our local currency and the bill is paid to the supplier in their >currency. On the receipt side, the client pays into a bank account >local to them, the OFX service notifies us of the receipt, and then we >can either convert to our local currency immediately or at some time >over the next 2 months when we wish - this has an advantage (generally) >in being able to get a more favourable exchange rate and thus a better >return. >The service costs less than banks - they provide a better exchange rate >and have lower fees - and our accounts are all in local currency. We >just adjust our invoices/bills according to the rate received/paid. >Easy peasy. >I'm not sure that will help you but it just might! >Cheers >Hop > A significant percentage of my transactions go via PayPal, so I don't think that would work too well for me. It might sometimes, especially on the rare higher value transaction which is paid by bank transfer. Dave ___ 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] Have I got my USD accounts set up wrong?
On Wed, 29 Nov 2023 at 23:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Since all of them are of type A/R and this isn't working with your > current tree arrangement, I'd say you found a bug in the reports. You > might want to file one and ask if you should separately file the same > for the others. > > When you do so, create and upload a test file with just enough > transactions to indicate the failure/discrepancy. (it will likely be > requested anyway) > > Regards, > Adrien > I have tried to create a test case and demonstrate the problem but I couldn’t reproduce it. But my test case probably didn’t have the accounts nested the way they are. I have occasionally had an error message when trying to exit that indicated GnuCash was in the middle of an operation. The only way out is to forcibly stop the program. Another issue I have found is that it’s possible to pay an invoice but it not marked as paid. This then often results in the error message that I indicated in the previous paragraph. I am seriously wondering if it is safer to tart again. It is not too painful with two copies of GnuCash running. One can copy/information from one set of accounts to another. Dave ___ 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] Have I got my USD accounts set up wrong?
On Wed, 29 Nov 2023 at 23:28, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > You can set your bank accounts nested however you want. GnuCash doesn't > care as there is nothing special about such accounts. > > Gnucash *does* care about types Accounts Receivable and Accounts > Payable. (regardless of what you name them) > > But exactly how these should be structured is still to be determined. > > Regards, > Adrien Is it possible, and so how, to move the A/R USD account directly under the assets and not under the GBP account? When I set up accounts like that, the P and trial balance agreed with each other. I am still puzzled it’s now possible to delete a non-GBP transaction that has been posted. I think that’s a new problem , within the last day or two. I would need to go back to an earlier version to be sure. I charge customer extra for non-GBP transactions, anti always say GBP will be cheaper. They certainly do cause an extra overhead with software issues, accounting issues, the need to maintain 3 price lists. A few years ago I reported a bug to the bug tracker related to non-GBP currencies. I think it was a report that was wrong, but that issue got resolved. Dave. > > On 11/29/23 5:05 PM, David Kirkby wrote: > > On Wed, 29 Nov 2023 at 23:02, David Kirkby < > drkir...@kirkbymicrowave.co.uk> > > wrote: > > > >> But think about it, the fact one is supposed to set bank accounts that > >> way, probably implies one needs to do the same with A/P and A/R. > >> > >> Dave. > >> > > > > I meant to say “thinking about it “ not “think about it “ > > ___ > 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.
Re: [GNC] Have I got my USD accounts set up wrong?
On Wed, 29 Nov 2023 at 23:02, David Kirkby wrote: > But think about it, the fact one is supposed to set bank accounts that > way, probably implies one needs to do the same with A/P and A/R. > > Dave. > I meant to say “thinking about it “ not “think about it “ > > > > > ___ 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] Have I got my USD accounts set up wrong?
On Wed, 29 Nov 2023 at 20:57, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Thanks. I saw that from the bug report. > > Please double-check all three of those and make sure they are of 'type' > "Accounts Receivable". > > Regards, > Adrien Hi, I checked and all are accounts receivable. I also checked under liabilities and see the corresponding accounts are accounts payable. The list of currencies for A/P & A/R are not the same - for example I sometimes buy in HKD, but don’t sell in them. But I don’t think there’s any reason they should be the same. If I look at the documentation, it doesn’t show one bank being a child account of another. But as I indicated, the documentation does not cover the A/R and A/P. But think about it, the fact one is supposed to set bank accounts that way, probably implies one needs to do the same with A/P and A/R. Dave. ___ 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] Have I got my USD accounts set up wrong?
On Wed, 29 Nov 2023 at 20:43, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Relax, have some more beer. Read over my other replies. And perhaps > those screenshots I suggested in the other response will clear things up > for both of us. From what I can tell, you can likely just re-parent your > accounts to solve this. > This is what I have. I changed the name of one account, adding "GBP" as you suggested. [image: image.png] ___ 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] Have I got my USD accounts set up wrong?
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If so, I'd rename it. > > It is possible you don't even need it if that is your book currency. > Just stick with the original Assets:Accounts Receivable, but you should > verify that. (a single currency book, just has the one account) > > Either way, I don't think those USD & EUR A/R accounts should be > children of a child of A/R. (at least that is how your indentation reads > below) > > Make a copy of your book and test out if one of these does the trick by > editing one bill and/or payment accordingly (you might be able to just > re-parent the account(s) though: > > Assets:A/R > --Assets:A/R (GBP) > --Assets:A/R (USD) > --Assets:A/R (EUR) > > or perhaps more simply: > > Assets:A/R > --Assets:A/R (USD) > --Assets:A/R (EUR) > > Where each child is specifically set to those named currencies and the > parent A/R is in your book currency. (assuming GBP here) > > Your Assets:PayPal account tree has no bearing on the Business Features. > They *should* just be generic asset accounts. > > Regards, > Adrien > Unfortunately I don't think I have another option but to start fresh with a completely new account and enter all the transactions again. That's a PITA, but I don't see another method I would have any confidence in. I did what you said, and moved the accounts. The one with the least transactions is the EUR account. After moving them I noticed two problems. 1) It is possible to post an invoice, let the customer pay it, then delete the transaction from the bank account. Nothing is stopping the fact that the invoice has been posted and paid. For GBP transactions it is not possible to delete it from the bank account unless the invoice is unposted. 2) The Profit and Loss account is giving both a EUR and GBP amount, but the line with €1,089.00 £933.27 has the EUR bit right, but the GBP is wrong. I just set up a fresh set of accounts as a demo incase I needed to file a bug report. I actually used USD and GBP, but I don't think that should make any difference. What I see is a) The P+L does not show a USD amount, but the GBP bit is correct. Sales (USD) £100,001.60 b) It's impossible to delete either a GBP or USD transaction without unposting it. With it impossible to create a reliable report, and possible to delete transactions that are posted, I obviously have concerns. I tried creating a new transaction, rather than unpost and post an old one. It is still possible to delete it from the bank account, despite it's posted. At least I have a year before I need to get them to my accountant again. ___ 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] Have I got my USD accounts set up wrong?
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, I could be mistaken, but I think this is influencing your > reporting problem. (if the A/P side looks like what you posted below > concerning A/R) > > Assets:A/R > --Assets:A/R (GBP) > --Assets:A/R (USD) > --Assets:A/R (EUR) > That looks very logical, but would mean unposting and reposting every single transaction. But it is very clear to both me and my account. > > or perhaps more simply: > > Assets:A/R > --Assets:A/R (USD) > --Assets:A/R (EUR) > > Where each child is specifically set to those named currencies and the > parent A/R is in your book currency. (assuming GBP here) > As I wrote before, I don't understand this one. If I put GBP transactions in Assets:A/R, that's no different to what I have now. It would however be much easier, as only non-GBP transaction would need to be reposted, not every single one. But the former looks clearer. My accountant is happy with the accounts, having worked out himself what the issues were, but he did not use my reports. He is going to phone me within the next few days. Dave ___ 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] Have I got my USD accounts set up wrong?
Originally I sent this to just to Adrien by mistake. Now sending to the list. On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, I could be mistaken, but I think this is influencing your > reporting problem. (if the A/P side looks like what you posted below > concerning A/R) > > I'm hazarding a guess that: > > Assets:Accounts Receivable:Accounts Receivable > > is in GBP, though you have no indication in the name. > > If so, I'd rename it. > Yes, it is. It is possible you don't even need it if that is your book currency. > Just stick with the original Assets:Accounts Receivable, but you should > verify that. (a single currency book, just has the one account) > > Either way, I don't think those USD & EUR A/R accounts should be > children of a child of A/R. (at least that is how your indentation reads > below) > Yes, they are, and I suspect that is wrong. Make a copy of your book and test out if one of these does the trick by > editing one bill and/or payment accordingly (you might be able to just > re-parent the account(s) though: > > Assets:A/R > --Assets:A/R (GBP) > --Assets:A/R (USD) > --Assets:A/R (EUR) > I see that it is different from what I have now. In which case I assume Assets:A/R would be a placeholder account. How would I test this out? There is actually just one single transaction for Services in USD, so I guess that would be a good one to try. There are many more for sales in USD. > or perhaps more simply: > > Assets:A/R > --Assets:A/R (USD) > --Assets:A/R (EUR) > I'm not following you there. Are you saying make Assets:A/R a placeholder account? If so, where do GBP accounts get posted? If not, how is this different to what I have now? Are you saying I don't need an A/R for GBP? > Where each child is specifically set to those named currencies and the > parent A/R is in your book currency. (assuming GBP here) > I don't follow how that's different to what I have now. > > Your Assets:PayPal account tree has no bearing on the Business Features. > They *should* just be generic asset accounts. > Okay. > > Regards, > Adrien > I will look at this after I have not had a few beers. Now is not the time to start playing around with complex things. On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, I could be mistaken, but I think this is influencing your > reporting problem. (if the A/P side looks like what you posted below > concerning A/R) > > I'm hazarding a guess that: > > Assets:Accounts Receivable:Accounts Receivable > > is in GBP, though you have no indication in the name. > > If so, I'd rename it. > > It is possible you don't even need it if that is your book currency. > Just stick with the original Assets:Accounts Receivable, but you should > verify that. (a single currency book, just has the one account) > > Either way, I don't think those USD & EUR A/R accounts should be > children of a child of A/R. (at least that is how your indentation reads > below) > > Make a copy of your book and test out if one of these does the trick by > editing one bill and/or payment accordingly (you might be able to just > re-parent the account(s) though: > > Assets:A/R > --Assets:A/R (GBP) > --Assets:A/R (USD) > --Assets:A/R (EUR) > > or perhaps more simply: > > Assets:A/R > --Assets:A/R (USD) > --Assets:A/R (EUR) > > Where each child is specifically set to those named currencies and the > parent A/R is in your book currency. (assuming GBP here) > > Your Assets:PayPal account tree has no bearing on the Business Features. > They *should* just be generic asset accounts. > > Regards, > Adrien > > On 11/27/23 7:06 PM, David Kirkby wrote: > > I'm getting some crazy results things happening in my accounts, in that a > > GBP amount of a transaction is not matching the USD amount. > > > > I am wondering what I'm doing wrong. I have my accounts set up like this, > > so the USD and EUR accounts are child accounts of the default (GBP) > > account. Is that right or wrong? I'm starting to wonder now if this is > all > > wrong. > > > > Assets:Accounts Receivable:Accounts Receivable > > Assets:Accounts Receivable:Accounts Receivable (USD) > > Assets:Accounts Receivable:Accounts Receivable (EUR) > > > > However, I notice PayPal is not set up like that. The PayPal (GBP) and > > PayPal USD are both child accounts of Assets:PayPal. > > > > Assets:PayPal:PayPal (GBP) > > Assets:PayPal:PayPal (USD) > > ___ > gnucash-user mailing list > gnucash-user@gnucash.or
Re: [GNC] How do I add AP and AR for multiple currencies?
Well against my own advice, and submitted the lack of documentation as a bug. https://bugs.gnucash.org/show_bug.cgi?id=799146 I'm not going to say there's a bug in the reports, as the problem might be my errors. But without details on handling AR and AP in the documentation, errors are likely to occur. On Tue, 28 Nov 2023 at 20:06, David Kirkby wrote: > On Tue, 28 Nov 2023 at 17:25, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> As I noted in the other thread, you might not have to delete any >> transactions, just re-parent the account(s). >> >> In a worst case, you'd have to unpost and repost bills/invoices >> accordingly if you need to assign some to a different AR/AP account. >> (you can't delete bills or invoices, but you can delete payments) >> >> Regards, >> Adrien >> > > But do I need to? That's what's not 100% clear to me. Is it a bug in the > reports, or have I set the accounts up incorrectly? > > Is it worth submitting a request for enhancement, for the documentation to > describe how to handle AP and AR? > > I have had a few pints of beer tonight, so it's not the best time to start > messing around with the account, not submitting requests for enhancement. > But I do feel the documentation should address the issue of AR and AP. > > Dave (please excuse any errors duto to the consumption of C2H5-OH ) > > ___ 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] How do I add AP and AR for multiple currencies?
Reading https://www.gnucash.org/docs/v5/C/gnucash-guide/currency_manual.html it describes how to set up *banks *for multiple currencies -Assets (USD) -Current Assets (USD) -US Bank (USD) -European Bank (EUR) -HK Bank (HKD) -Equity (USD) -Opening Balances (USD) -USD (USD) -EUR (EUR) -HKD (HKD) but there's nothing I can see written about setting up AR or AP. I currently have the following setup, and I'm starting to suspect that this might be wrong, as GnuCash is not generating reports properly. [image: image.png] Assets > Accounts Receivable is a GBP account. It's used for 95% of the transactions. It has child-accounts (sub-accounts?) of USD and EUR. I'm wondering if it is necessary to have instead either 1) Assets:Accounts Receivable *(placeolder account)* Assets:Accounts Recieive:Accounts Recievable (GBP) Assets:Accounts Recieive:Accounts Recievable (EUR) Assets:Accounts Recieive:Accounts Recievable (USD) or 2) Assets:Accounts Receivable(GBP)* (rename the current AR)* Assets:Accounts Receivable(USD) Assets:Accounts Receivable(EUR) If I need to change my current setup, then it is going to be a real PITA. I'll probably have to go for option 2 above and delete all transactions that are not in GBP It would be useful if the online documentation covered this, as I can't see it anywhere. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Find what was in Accounts Payable some date in the past.
On Tue, 28 Nov 2023 at 15:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/28/23 5:34 AM, David Kirkby wrote: > > > > If I go to Reports > Business > Payable Aging, I just see > > > > > > > > *Payable Ageing - 28/11/2023A/Payable or A/Receivable accounts exist but > > have no suitable transactions* > > That message tells me you don't have bills entered for any vendors. If > you do, then I suspect this has something to do with your AP account > tree and how you are using it with respect to multiple currencies. The > report is not 'seeing' them. > But if I add a bill, and don't pay it, then the Payable Aging report shows it. > I seem to be in one big mess > > You need to solve the multi-currency setup first procedure wise, and if > different from your current setup, adjust previous bills (and perhaps > invoices if that has the same problem) accordingly. Then your reports > should work. > Yes. > I thought the Help Manual or the Tutorial & Concepts Guide covered this > situation, but I could be mistaken. > I will check that again. I was given a false sense of security by the fact that everything seemed to be credited to the right accounts. It was not until my accountant queried the things that I realised something was wrong. > Regards, > Adrien > Dave ___ 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] Find what was in Accounts Payable some date in the past.
On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Neither of those is an Accounts Payable Aging Report. > > I'm not certain what the first one is. The second is a Transaction Report. > > Go to Reports > Business > Payable Aging > > Regards, > Adrien > If I go to Reports > Business > Payable Aging, I just see *Payable Ageing - 28/11/2023A/Payable or A/Receivable accounts exist but have no suitable transactions* Since today (28/11/2023) there's nothing outstanding. But it does not tell what (if anything) was outstanding on 28/02/2022, which is what I want to know. I can't see a way of generating that report on a specific date. I'm fairly certain the balance was zero on that date, but it would be nice to know for sure. 1) Click Reports > Transaction reports 2) Edit the report options and select the starting and ending dates of the financial year 3) Select A/P as the account 4) Check "Subtotal balance" and "Account Balance" on the Display section I then get a report showing £382.83 owing, but no indication of who too. Essentially I generated a P+L plus trial balance for my accountant, and he can see they don't match. He also sees this £382.83 on A/P and asked what transactions is it for. The truth is I can't find any transactions, as I believe it's incorrect. I seem to be in one big mess ___ 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] Find what was in Accounts Payable some date in the past.
On Tue, 28 Nov 2023 at 02:26, David Carlson wrote: > David, > > While I am not conversant with your basic issue, I have not seen where you > account for the fact that every time money is exchanged from one currency > to another, there is a specific exchange rate and possibly fees that apply > only to that specific transaction. Then the next transaction most likely > will have a different exchange rate. You will have to document those > details separately each time there is an actual transaction. > > Good luck with getting things figured out. > Did you mean to post under this thread of mine, or the other one about USD/GBP issues? I don't think this one is related to USD/GBP things, although I might be wrong. Whereas the other issue most certainly is. ___ 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] Find what was in Accounts Payable some date in the past.
On Tue, 28 Nov 2023 at 02:01, kirk abbott wrote: > I just took another look at the PNG's, and it looks like you might not be > using the A/P module correctly. To ascertain this, I would like to ask if > you have setup vendor accounts. They would be the normal way for entering > A/P expenses. > > Kirk > Yes, each vendor has an account.. Here's one for eBay. [image: image.png] ___ 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] Find what was in Accounts Payable some date in the past.
On Tue, 28 Nov 2023 at 00:57, kirk abbott wrote: > They probably won't match, ever . Basically the starting balance plus the > account total will equal the ending balance. The beginning balance seems to > be set to whatever the last balance was prior to period of the report > generated. If you check the account balance prior to 01/03/2022 you may > find the difference. > > Kirk > Does that mean one can never determine what is owed at the end of the financial year? I would have thought that pretty important. ___ 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] Have I got my USD accounts set up wrong?
I'm getting some crazy results things happening in my accounts, in that a GBP amount of a transaction is not matching the USD amount. I am wondering what I'm doing wrong. I have my accounts set up like this, so the USD and EUR accounts are child accounts of the default (GBP) account. Is that right or wrong? I'm starting to wonder now if this is all wrong. Assets:Accounts Receivable:Accounts Receivable Assets:Accounts Receivable:Accounts Receivable (USD) Assets:Accounts Receivable:Accounts Receivable (EUR) However, I notice PayPal is not set up like that. The PayPal (GBP) and PayPal USD are both child accounts of Assets:PayPal. Assets:PayPal:PayPal (GBP) Assets:PayPal:PayPal (USD) -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Find what was in Accounts Payable some date in the past.
On Mon, 27 Nov 2023 at 20:08, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > There's an Payable Aging Report. You can then click the total amounts > owed for each Vendor to see which documents are outstanding. (this runs > a Vendor Report) If you set the option on the Vendor Report for detailed > links, you'll see which payments were applied to which bills and which > bills are paid by which payments. > > Regards, > Adrien > Business -> Payable Ageing gives me what is owned *today*, which is nothing. Can I find out what was owed at the end of the accounting period? That's what I want. Short of perhaps changing the date on the computer, which I'd rather not do. Dave ___ 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] Find what was in Accounts Payable some date in the past.
On Mon, 27 Nov 2023 at 18:51, david whiting wrote: > Does setting the date in the report Options give you what you need? > You should be able to see where there are amounts payable for each > vendor and if you click on the value link it will take you to the > vendor report for that same date. Is that what you are looking for? > > David > Strangely, the amount shown with for the report for Accounts Payable is £344.91, whilst the amount shown on the trial balance is £353.90. I don't know why there's an £8.99 difference. I don't see any transaction for that amount at the end of the accounting period. Unfortunately the report on Accounts Payable lists a lot of things in debits and credit, but it is not obvious what ones are outstanding. I don't actually see any outstanding myself. Is there a way to get a list of the amount owed to all vendors? Then I could look and find any non-zero amounts. ___ 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] Profit and loss - pounds not matching dollars.
I have a problem that seems to only occur if one transaction is there, and goes away if the transaction is deleted. The trial balance shows Services sold worldwide in USD £434.98 There's only a single transaction for services sold in USD, and that's for $540, which is the amount shown in services. But the amount credited to the bank account was not £441.67 but £424.00. I can't make out why there's a £17.67 difference. No bank fees or PayPal fees were paid. The trial balance shows yet another amount Services sold worldwide in USD £434.98. I would have expected all these to be £424, but I have a disparity of £17.67 on one, and £10.98 on the other. Any ideas? [image: image.png] -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Find what was in Accounts Payable some date in the past.
I have given my accounts to my accountant, who has asked for a breakdown of the what transactions are in the accounts payable, as there's £353.90 shown on A/P at the end of the accounting period. Since whatever was owed has now been paid, I can't find what was owed on that date. There's no single transaction for that amount, so it must consist of multiple transactions. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I find transactions into an account that has only one split?
On Fri, 24 Nov 2023 at 19:24, David Cousens wrote: > David, > > That is a function of the email client program you are using not the > mailing > list admins. I am on numerous mailing lists. This is the *only* one where simply hitting reply does automatically go to the list. Dave ___ 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] Can I find transactions into an account that has only one split?
Apologies for not sending to the list. Have the admins considered making that the default behaviour, which is the case with other mailing lists I am on. On Wed, 22 Nov 2023 at 18:25, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Also, please remember to copy the list on all replies. > > Regards, > Adrien > > > On 11/22/23 3:53 AM, David Kirkby wrote: > >> Unfortunately that's a bit difficult, as a lot of times I buy things > >> with PayPal, so there's an entry in the PayPal account where no fees > >> need to be paid, as the seller pays the fees, not the buyer. So not > >> every transaction in the PayPal account needs 3 splits - most need 2. > > ___ > 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] Last reconciled transactions have an error.
I have discovered a problem with my accounts. A transaction moved money from the PayPal account to the Bank account, but this is not recorded in the bank account. Unfortunately, about a dozen transactions have been marked as reconciled after this date. Reconciled on 06/02/23 - I believe they are all okay. *Transaction on 18/02/2023 - should be recorded but is not. * Reconciled 23/2/2023 Reconciled 28/2/2023 Reconciled 17/3/2023- last time reconciled. I'm not sure how this mess happened, but I'm wondering the best way to resolve it. Can I simply unreconcile them in this order? 1) 17/3/2023, 2) 28/2/2023 3) 23/2/2023 To my knowledge, this is the first time I have managed to reconcile transactions that should not have been, but that's the state I'm in. Retrieving a backup is possible, but I have done a lot of work on reconciling the PayPal account and picking up a couple of errors on PayPal transactions, so I'd rather not use an earlier backup if possible. But if that's the safest way, maybe I should. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I find transactions into an account that has only one split?
I often receive PayPal transactions, which get put into the PayPal account as Credit: Assets: Accounts Receivable (£720.00) Debit: Assets:PayPal (£720.00) What I should then do is edit the PayPal account so the fees are put in the correct place - for one example transaction Credit: Assets: Accounts Receivable (£720) Debit: Assets:PayPal (£705.62) Debit: Expenses:PayPal Fees (£21.38) But I quite often forget to do this, so the PayPal account will not reconcile. Is there any way to search to find transactions going into accounts that don't have a second split, or some other way to weed out the ones that have gone into the PayPal account, but don't have an entry in PayPal expenses? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I set accounts to read-only?
I have a few accounts that I will use very occasionally, but not normally. Can I set them to read-only, so I just mark them writable when I need to? This will avoid transactions accidentally getting put in there. I discovered something in the Travel account the other day that should not have been there. I will probably use that account once per year, so it makes sense to stop things accidentally going into them. I believe setting them to placeholder accounts will achieve the same effect, but I'm not sure. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Hidden and duplicated accounts.
I have a couple of questions related to accounts, and my ability to see them and delete them. 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD) and bank fees. [image: image.png] I remember creating some more to include eBay fees, but since I so rarely use eBay, I think I set them to hidden. But when I tried to edit the Expenses account, I can see the other entries But I do I unhide these? I tried clicking on other accounts, but none show hidden, and all are marked as placeholder, so I don't think that's the way to edit their visability. [image: image.png] 2) As you can see I two accounts called Depreciation. Why I would have created two for this I have no idea. These are both shown if I edit the Expenses account, but not when I look normally. How can I delete one of the? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Can I produce a trial balance as a simple CSV file?
On Tue, 21 Nov 2023 at 13:22, Maf. King wrote: > On Tuesday, 21 November 2023 12:58:32 GMT David Kirkby wrote: > > > > > I can see I can produce the trial balance as a PDF, but I can't see a way > > to convert it to a CSV file, which I think he would prefer. > > The usual advice is the either: > > a. save the report as HTML > b. select and copy the text of the report > > then open with / paste into a spreadsheet (LibreOffice Calc opens HTML > just fine) > and save as CSV from there, with any format / line-up tinkering needed > first, > of course,. > Thank you. I'll probably just give him the spreadsheet in that case - it will be easier to read than a csv file. ___ 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] Can I produce a trial balance as a simple CSV file?
I was a bit concerned about the complexity of the CSV files exported from GnuCash, since they contain information my accountant does not want. I wrote to him and received this as a response (slightly edited from his reply) *Thank you for your email. Do not worry about sending me over complicated CSV files - we are very used to this. * *The way in which we normally work is that a client sends across the trial balance, we make relevant adjustments to which we use for the accounts and send these adjustments back to you to make within your software. * I can see I can produce the trial balance as a PDF, but I can't see a way to convert it to a CSV file, which I think he would prefer. I can find online converters for this, but can't see an open-source project to do it. There are sufficiently few entries that I could do this myself in a spreadsheet, but it would be a bit tedious. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Transaction not showing as reconciled when it should be.
On Mon, 20 Nov 2023 at 21:14, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Your ending balance is £98.00 more than your starting balance. That's > why only that one Debit gets you to zero. > > Are you saying the £107.29 transaction appears on this statement and > needs to be reconciled? If so, either you have a duplicate as Steve > mentioned, or you are missing an offsetting £107.29 Debit transaction. > Thank you. The transaction had been entered twice. One was reconciled and the other was not. I just deleted the one that was not reconciled. ___ 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] Transaction not showing as reconciled when it should be.
On Mon, 20 Nov 2023 at 20:55, Steve Butler wrote: > I suspect you have a transaction for the £107.29 that has already been > reconciled when it shouldn't have been. Probably for a different date. Go > get a transaction report for this account and sort by reconcile date. Look > at transactions reconciled after the last good reconciliation date. > > I once found a dupe that was entered for a year prior to the other. Now > as I reconcile I check the transaction date to be sure I'm not reconciling > something with a very old date unless it was a true error that I went back > and fixed. > Thank you Steve. It was indeed a duplicate transaction. ___ 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] Transaction not showing as reconciled when it should be.
On Mon, 20 Nov 2023 at 19:57, David Carlson wrote: > That image does not appear to be from the reconciliation tool. If it is > from the reconciliation report, it probably cannot actually reconcile a > transaction, but I have never used that report and I dont know how it works. > That's correct, but here's a view from the reconciliation tool. I picked a date that had just one extra transaction compared to the previous reconciled amount. So selecting the £98 deposit the account will reconcile. But to get to that point, the £107.29 must have already been reconciled, but I'm still shown the option to select it. [image: image.png] > > > > On Mon, Nov 20, 2023, 1:28 PM David Kirkby > wrote: > >> I've reconciled my accounts. To do that I would have needed to include a >> particular transaction of £107.29 to Digikey, but not the one of £176.20 >> to >> Digikey on the same day. However, the £107.29 is not marked as reconciled. >> If I try to reconcile to any later date, I'm always presented with the >> option to reconcile that transaction. But the accounts will not reconcile >> unless I ignore that one. >> >> It seems the "n" in the reconciliation status needs to be changed to a >> "y", >> but why this is happening I don't have a clue. >> >> >> [image: image.png] >> >> >> -- >> Dr David Kirkby Ph.D >> Kirkby Microwave Ltd >> Email: drkir...@kirkbymicrowave.co.uk >> Web: https://www.kirkbymicrowave.co.uk/ >> Telephone 07910 441670 (UK) or +44 7910 441670 (international) >> Registered in England and Wales, company number 08914892. >> Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT >> ___ >> 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] Transaction not showing as reconciled when it should be.
I've reconciled my accounts. To do that I would have needed to include a particular transaction of £107.29 to Digikey, but not the one of £176.20 to Digikey on the same day. However, the £107.29 is not marked as reconciled. If I try to reconcile to any later date, I'm always presented with the option to reconcile that transaction. But the accounts will not reconcile unless I ignore that one. It seems the "n" in the reconciliation status needs to be changed to a "y", but why this is happening I don't have a clue. [image: image.png] -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Trail balance Imbalance / multi-currency transaction
On Sat, 18 Nov 2023 at 19:58, David Cousens wrote: > Dave, > > When you do the next reconiliation, the unreconciled transaction should > appear > at the top of the pane in the second step. The starting balance should be > out by > the amount of that deleted transaction, i.e. 7 pound. Mark it as > reconciled by > setting the checkbox, then reconcile the rest as usual to the closing date > of > the statement, finish the reconciliation and it should all be good. > > David Cousens > I did the reconciliation, but it was not out by £7 because I had reconciled the bank account which was correct. The account which had the problem was the expenses account, and I'm not reconciling that. I've no idea how that unbalanced transaction occurred, although I did *think *of a possibility. I *think *when entering the currency conversion one ends up entering an exchange rate twice. If wonder if one puts them differently then a different amount go could into two accounts, and imbalance not be noticed by GnuCash. But I'm not sure of this I might make a set of test accounts later and see for myself. ___ 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] Trail balance Imbalance / multi-currency transaction
On Sat, 18 Nov 2023 at 15:52, Maf. King wrote: > On Saturday, 18 November 2023 15:45:07 GMT David Kirkby wrote: > > > > > *I have discovered that's not the source of the problem, which explains > why > > it does not go away if I delete the transaction! * > > OK, that clears up one part of the mystery! > > > > > > Debit: Expenses -> Stock £214.45 > > Credit:Assets -> Bank account £207.45 > > Nothing is recorded in bank fees. > > > > > surely that is an unbalanced txn? is there a split to imbalance-GBP or > silmilar? > No, there was not an imbalance-GBP or similar. I've seen them before, but have always resorted to a backup without the error imbalance and sorted out the source of the error. Unposting the transaction, deleting it, posting it and paying it got the things to balance okay. I now have Debit: Expenses -> Stock £207.45 Credit: Assets -> Bank account £207.45 Trial balance matches debits and credit. Now I'm left with an unreconciled transaction. Should I change the reconciliation status of all those more recent to "n" rather than "y"? I have never deleted a reconciled transaction before. But I did not seem to have a lot of choice in this case. ___ 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] Trail balance Imbalance / multi-currency transaction
On Sat, 18 Nov 2023 at 13:40, Maf. King wrote: > On Saturday, 18 November 2023 04:17:50 GMT David Kirkby wrote: > > Unfortunately, when entering the transaction into GnuCash, I created a > > split and put the £7 bank fee into Expense -> Bank Charges. The result > is > > that £7 is accounted for twice. I'm show it as an expense, but the bank > > statement has already taken this into account. > > > Where is the £7 accounted for twice? Is it also in the exchange rate > conversion or something? What you describe above sounds exactly the > correct > thing to have done. > *I have discovered that's not the source of the problem, which explains why it does not go away if I delete the transaction! * I found the source of the problem by changing the end date of the accounting period in GnuCash, then doing a trial balance. Things are okay unless the end of the accounting period is set to 25/7/22 or later. Looking at my accounts, there was a transaction on 25/7/2022, and that was a foreign currency transaction where I purchased something in HK$1650.00. There would have been a bank fee associated with that, but I might not necessarily have recorded it separately, and I would have expected it to be higher than £7, as I paid the vendor's bank charges too. But what I see is. Debit: Expenses -> Stock £214.45 Credit:Assets -> Bank account £207.45 Nothing is recorded in bank fees. So I suspect that's the cause of the problem. The amount spent on stock for that transaction is higher than the amount deducted from the bank account. I have just made a backup of the accounts, unposted that HKD transaction and deleted the transaction. The trial balance indicates no problems. Unfortunately I have reconciled the bank account, which meant deleting a reconciled transaction. What's the best way to solve this? Clearly something was wrong with that transaction, I could re-enter it and it should solve the problem, but then I have deleted a reconciled transaction. Is it best to delete the transaction, or try to find where the £7 went to? I'm rather uneasy. I have deleted a reconciled transaction, but the amount deducted from the bank account shown in GnuCash matches what the bank statement shows. Dave . ___ 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] Trail balance Imbalance / multi-currency transaction
On Sat, 18 Nov 2023 at 04:47, David Cousens wrote: > David > > The transactions splits should have been recorded as follows: > > Income:Sales Cr 427.67 > Bank Account Dr 420.67 > Expense:Fees Dr 7.00 > > David Cousens However, if I unpost and delete the transaction, the problem remains. It seems whatever I do, I can not get rid of the £7 discrepancy. It makes life particularly difficult (for me at least), as the transaction is split across multiple currencies. I am less confortable with them. Just to add a complication, the GBP bank account has been reconciled. Dave > ___ 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] Trail balance Imbalance / multi-currency transaction
I should have added, there’s nothing in any imbalance accounts. On Sat, 18 Nov 2023 at 04:17, David Kirkby wrote: > When I run a trial balance, right at the bottom the sums are given. The > one on the left is £7 higher than the one on the right. I believe I know > the source of this problem, but can't seem to get rid of it. > > I'm in the UK, but sold something to a customer who wanted to pay in > Euros. The item was sold at 500 Euros. The bank converted €500 to > £427.76, took a £7 fee, and deposited £420.76 into the account. > > Unfortunately, when entering the transaction into GnuCash, I created a > split and put the £7 bank fee into Expense -> Bank Charges. The result is > that £7 is accounted for twice. I'm show it as an expense, but the bank > statement has already taken this into account. > > No matter what I do, I can't seem to get rid of this £7 issue. I unposted > the invoice, and then deleted the transaction. This removes £420.76 from > the bank account and removes the £7 from the bank charges. But if I run a > trial balance, there's still a £7 difference. > > I've tried Actions -> Check and Repair -> Check and Repair All. That does > not help. > > I know £7 is not a lot, but it is annoying me. I would like to try to > solve the problem. > > -- > Dr David Kirkby Ph.D > Kirkby Microwave Ltd > Email: drkir...@kirkbymicrowave.co.uk > Web: https://www.kirkbymicrowave.co.uk/ > Telephone 07910 441670 (UK) or +44 7910 441670 (international) > Registered in England and Wales, company number 08914892. > Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT > > > ___ 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] Trail balance Imbalance / multi-currency transaction
When I run a trial balance, right at the bottom the sums are given. The one on the left is £7 higher than the one on the right. I believe I know the source of this problem, but can't seem to get rid of it. I'm in the UK, but sold something to a customer who wanted to pay in Euros. The item was sold at 500 Euros. The bank converted €500 to £427.76, took a £7 fee, and deposited £420.76 into the account. Unfortunately, when entering the transaction into GnuCash, I created a split and put the £7 bank fee into Expense -> Bank Charges. The result is that £7 is accounted for twice. I'm show it as an expense, but the bank statement has already taken this into account. No matter what I do, I can't seem to get rid of this £7 issue. I unposted the invoice, and then deleted the transaction. This removes £420.76 from the bank account and removes the £7 from the bank charges. But if I run a trial balance, there's still a £7 difference. I've tried Actions -> Check and Repair -> Check and Repair All. That does not help. I know £7 is not a lot, but it is annoying me. I would like to try to solve the problem. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Change the default "Find" from "Description" to "Value"?
Yes, the last search sounds sensible, as it does not need any extra widgets to make a selection. On Wed, 15 Nov 2023 at 21:47, Derek Atkins wrote: > I think if you ask 100 people what their default "search" is, you'll get > 120 different answers. I don't think any solution is going to work for > everyone. > > IMHO, the most reasonable solution would be remembering the last used > search criteria and default to that next time. > > -derek > > On Wed, November 15, 2023 4:03 pm, Adrien Monteleone wrote: > > Probably 99.23% of my searches, 96.81% of the time, are the same. > > > > Regards, > > Adrien > > > > On 11/15/23 2:57 PM, David H wrote: > >> Good suggestion, I'd like that as well, every time I do a Find I always > >> change it to "Description, Notes or Memo" to cover all the bases :-) > > > > ___ > > 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. > > > > > -- >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 > - > 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.
Re: [GNC] Bill allocated to the wrong account
Edit payment does not seem to get me anything I know how to use. I can't seem to see this "Assign as Payment" option on any transaction in the bank account - including those where a single payment was made for a single bill. On Wed, 15 Nov 2023 at 15:32, Maf. King wrote: > On Wednesday, 15 November 2023 15:09:09 GMT David Kirkby wrote: > > On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > > > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > > > Hi David. > > > > Hi Maf > > > > > I presume these are vendor bills and were entered as such via A/P? > > > > Yes. > > > > IIRC, in the bank account right-click the transaction that paid the bill > > > > > and > > > then choose "Assign as payment" > > > > Em, I can't see that option. Here's what I see in the bank account for > the > > one that has *not *be reconciled. The total amount for the bill is > £52.76, > > but was paid along with several others to the same vendor as I have a > > credit account with them. I have unposted the billed, corrected the > error, > > and posted it again, but it shows as unpaid. This is what I see in the > bank > > account. I don't any "Assign as payment" when I right click. See > > screenshots. I'm using GnuCash 5.4 on Windows. > > Aah, so the payment txn covered multiple bills. I see. Well, from the > options in the screenshot, "Edit payment" seems the most appropriate. > > > another choice you *may* have is to "process payment" like normal and > select > something like "auto balance forward" and the edited bill in the dialog > box, > but I'm relly not sure on that. > > The final option (a little more nuclear) is to delete the payment txn > from the > bank account and reprocess all the relevant bills. > > HTH, > Maf. > > > > > (Note there was another error on this - when I paid the vendor I actually > > overpaid £10. So there's a £10 credit note, but that was used the next > > month, so that's not a big deal.) > > > > [image: image.png][image: image.png] > > > > > ___ > 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.
Re: [GNC] Bill allocated to the wrong account
On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > Hi David. > Hi Maf > > I presume these are vendor bills and were entered as such via A/P? > Yes. IIRC, in the bank account right-click the transaction that paid the bill > and > then choose "Assign as payment" > Em, I can't see that option. Here's what I see in the bank account for the one that has *not *be reconciled. The total amount for the bill is £52.76, but was paid along with several others to the same vendor as I have a credit account with them. I have unposted the billed, corrected the error, and posted it again, but it shows as unpaid. This is what I see in the bank account. I don't any "Assign as payment" when I right click. See screenshots. I'm using GnuCash 5.4 on Windows. (Note there was another error on this - when I paid the vendor I actually overpaid £10. So there's a £10 credit note, but that was used the next month, so that's not a big deal.) [image: image.png][image: image.png] ___ 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] Bill allocated to the wrong account
I have received a couple of bills from an electronics component supplier. These should be allocated as "Stock" but I must have accidentally clicked "Travel" instead.(I noticed this after doing a trial balance, and seeing some travel there, when I knew there was no travel). One has been reconciled against the bank account, the other one has not. I thought the one that had not been reconciled would be easy to correct by just unposting, changing the account from Travel to Stock. I did that, and it was okay. However, at that point is was shown as unpaid. What's the best way of paying it? The more tricky one is the one that has been reconciled to the bank account. Can that be corrected easily? If not, I could just leave it as Travel and let my accountant know. The amount is quite small - under £10, but I would like to get it right if possible. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Change the default "Find" from "Description" to "Value"?
If I want to find something, Edit -> Find will find it, but 99% of the time I want to search by a value, not by description. Is it possible to change the default, so I don't have to keep selecting "Value" each time? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Is it safe to change description of reconciled translation?
I have a reconciled transaction in my bank account, but the description is vague as to what it is. Can I change that safely - I don't need to change the amount. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Best way to resolve an unpaid but posted bill
I have created a bill, which just says Keysight Bits £1.00 The bill was actually for several hundred pounds, but Keysight wanted a purpose order number, so I must have created that. What's the best way to handle this? Can I just unpost, edit, then post and pay? It was paid months ago. I gave Keysight the reference number of this bill, so it would be sort of nice to keep that, but I'm not too fussed. I can easily make a note of what happened, and that would satisfy my accountant. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Sat, 28 Jan 2023 at 21:41, Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Thu, 26 Jan 2023 at 09:31, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Fix: >> >> Delete the PorkBun payment and re-entered properly as a payment in USD >> or if it were in GBP to a USD Vendor, turn on Trading Accounts, then >> re-enter the payment in GBP with the FX as the fixed debit amount. >> > > Based on the discussion at https://bugs.gnucash.org/show_bug.cgi?id=798734 > > it seems to be a GnuCash bug, which will be fixed in the next release. > That does indeed to be the case. I just updated to version 5.0, and the issues with some foreign currency transactions have now disappeared. ___ 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,org url is now working
On Fri, 3 Mar 2023 at 16:53, Fred Bone wrote: > > What appears to be up is the loss of an automatic redirect from > http://www.gnucash.org > to > https://www.gnucash.org > which, as this is clearly an Apache webserver, is a matter of one line in > a .htaccess file. That’s not the best way to do it, although it will work. It puts less load on the server to have it in the server configuration file which is read once when the server starts. Reading the .htaccess every time a site is accessed adds unnecessary load. You will find that documented in the Apache docs somewhere. Dave > -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Site certificate expiry warning
On Thu, 30 Mar 2023 at 19:42, Patrick James wrote: > About two months ago, there was a major ice storm in Austin, and the area > was completely unprepared for such a storm. A friend of mine was without > power for about 12 days. He has two small children, and he has good local > resources, which were also impacted by the ice storm, and it was not easy > on him. > > From the other messages here, the web server is in Austin, and was > impacted by the storm. The basic claim extends to the ISP in terms of > recovery from the ice storm, which propagated to the GnuCash server. > > No one here seems to have a philosophical problem with https, but when an > ice storm bring the system down, well, that's a problem. > There are people here that do not see the advantages of it. To quote Chris Green above. "How does that make the site 'dangerous'? All it means is that communication between you (i.e. the user) and the site isn't encrypted. As you don't need to send or receive any confidential information the lack of encryption is wholly irrelevant! I would argue it is *not **wholly irrelevant* when the largest search engine uses it as a ranking factor. ___ 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] Site certificate expiry warning
On Thu, 30 Mar 2023 at 19:03, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > > "Here are the criteria for a URL to rate as good in page experience > status > > in Google Search:: > > > > - *Failed:* The URL is served using HTTP, not HTTPS. > > > > So it seems to me that the argument that a website does not collect > > personal information, so does not need HTTPS, is flawed. You can argue > the > > technical merits of Google's approach, but it does seem to be the case > that > > the use of HTTPS is a good thing if you want the website to do well in > > Google. > > Except you seriously misunderstand the difference between HTTP and HTTPS. > I do know the difference. > This has nothing to do with the capability of collecting personal > information. It has to do with the SECURITY of what is transmitted. In > other words, IF personal data were collected by a site using HTTP it > would be insecure during transmission. Therefore a site should not be > collecting personal data without being HTTPS. > > Google is down rating sites using HTTP because it doesn't know what the > site is doing (collecting personal data or not). It is telling users > "this site less safe" because IF the site is collecting personal > information would be less secure. > But that still means if you want to do well in Google, you maximise your chances if you use HTTPS. Even if you have a completely static website, with no possibility of a user entering even an email address or name. > > Michael D Novack > Dave ___ 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] Site certificate expiry warning
I noticed from the Google website - actually Google, not what someone says they think about Google. https://support.google.com/webmasters/answer/10218333?hl=en-GB#not_enough_data "The Page Experience report provides a summary of the user experience of visitors to your site. Google evaluates page experience metrics for individual URLs on your site and will use them as a ranking signal for a URL in Google Search results" Then under "Here are the criteria for a URL to rate as good in page experience status in Google Search:: - *Failed:* The URL is served using HTTP, not HTTPS. So it seems to me that the argument that a website does not collect personal information, so does not need HTTPS, is flawed. You can argue the technical merits of Google's approach, but it does seem to be the case that the use of HTTPS is a good thing if you want the website to do well in Google. ___ 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] Should I upgrade or update?
On Mon, 27 Mar 2023 at 14:45, Derek Atkins wrote: > Version 5 was just released this weekend. > It is the new major stable series. > -derek I know there has been problems on the website, but when I look at the downloads page, there’s no version 5 https://www.gnucash.org/download.phtml -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Should I upgrade or update?
On Mon, 27 Mar 2023 at 14:27, Kalpesh Patel wrote: > The million dollar question: Should I upgrade to GNC 5.0 or update to 4.14? > I am predominately on Windows 11 platform but I am NOT a business user. > I don't see version 5. That might not be a stable release if it exists, so I don't know what you should do about that. But I know what you should do - trim posts when replying to a digest. You have included 1000's of lines of irrelevant stuff. ___ 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] Temporary Website URL
On Mon, 27 Mar 2023 at 03:11, Brad Morrison wrote: > I will > say that some people in open source communities may not realize how > common it is for people outside of the open source realm to be very > hesitant about using open source software. I have encountered this > attitude a lot from various lawyers and business people with the primary > reason being financial risk & responsibility. If an open source software > is responsible for an error that results in damages, many decision > makers want to be able to hold someone financially responsible for that > mistake and recoup their losses. It's interesting you say that. Many years ago I wrote some finite difference code https://atlc.sourceforge.net/ Once a publisher asked me if they could include a copy of the code on a CD with a book they were going to publish on modelling of electromagnetic systems. My reply was "sure, it's released under the GPL, just use it". But that did not satisfy them. *They wanted it confirmed in writing that they could use the code.* I could hardly be bothered to send a letter to them, but agreed with them that I would write a letter if they would send me a copy of the book when it was published. They agreed to that, so I confirmed in writing that they could include this GPL code with the book. It struck me as very weird, but at least I got a decent hardback textbook out of it. Dave ___ 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] Site certificate expiry warning
On Fri, 24 Mar 2023 at 15:22, wrote: > On Fri, Mar 24, 2023 at 11:16:09AM +, Michael Hendry wrote: > > I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve > > just been informed that www.gnucash.org is being flagged up as dangerous > > because its site certificate expired recently. > > > How does that make the site 'dangerous'? All it means is that > communication between you (i.e. the user) and the site isn't > encrypted. As you don't need to send or receive any confidential > information the lack of encryption is wholly irrelevant! > > -- > Chris Green Whilst I don’t disagree with you on a technical level, you need to bear in mind that browsers are going to warn people, and that will put people off. There’s a body of opinion that this will impact Google ranking. I have in the past paid for a fairly expensive EV SSL certificate, but now I use https://letsencrypt.org/ on Debian Linux. The certificates are valid for 90 days, but renewed after 60 days. Dave. -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Site certificate expiry warning
On Fri, 24 Mar 2023 at 11:16, Michael Hendry wrote: > I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve > just been informed that www.gnucash.org is being flagged up as dangerous > because its site certificate expired recently. > > I can get through by overriding the warnings, but I don’t think I should > be advising others to do so. > > Regards, > > Michael > I find https://www.downnotifier.com/?ref=700351 really good for monitoring a website. The basic service is free, and it will send an email if a certificate is soon to expire. It also gives you the uptime percentage over various periods of time. I pay about $15/year for the premium monitoring, which sends me text alerts if the website goes down. The nice thing about that site is it looks for specific text on a webpage (in my case I set it to be "attenuator"). That means it reports an error, even if the server responded with a missing page, internal error or similar Dave ___ 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] Can one add notes / memos / whatever to reconciled transactions?
On Sun, 5 Feb 2023 at 04:45, Phyllis Bruce wrote: > What happens when you try it? As far as I know, there is nothing to > prevent it. I could not edit it - no error message or anything, but could not be edited. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Can one add notes / memos / whatever to reconciled transactions?
I have a couple of transactions which are reconciled, but I realise they are missing some useful information. 1) One is shown in the bank account as costing £100, but it was actually paid in USD. If one jumps to the invoice, this is shown as a USD payment, but it would be nice if a note was added to the bank account indicating it was actually paid in USD 2) Another is a transaction for a printed circuit board. The part number of the board is given in the invoice, but it would be useful to add into Capital Equipment a note about the function of this board. Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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] Best way to link an overpaid invoice and credit note?
I have 4 transactions in my GnuCash accounts to a vendor RS with whom I have an account, and must pay by 20th of the following month. The amount of all the transactions is entered correctly, with a total of £322.70. I then put one payment in GnuCash, which was a split payment for all 4 transactions. However, when actually paying RS from my mobile banking app, I paid £332.70 instead of £322.70. So there's an overpayment of £10. So when RS invoiced me again, it they have deducted £10 due to the overpayment. I don't know the best way to handle this. I obviously need to change the payment in GnuCash to be £10 more than before. But I'm unsure how I can now pay those 4 transactions, plus an extra £10, unless I delete them all, then try to pay the 4, but change the amount GnuCash suggests, to an extra £10. Should I unpost them? I was thinking of creating an asset account, and calling it something like 'credit notes', and moving the £10 to there. But next time I pay RS, which will be for several hundred pounds, how could GnuCash be told to credit the credit note by £10, and credit the bank account by the rest? Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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 to force y in reconcile field
On Thu, 2 Feb 2023 at 19:27, Derek Atkins wrote: > Yes, when you start the reconcile dialog you can enter in the closing date > AND closing balance. GnuCash tries to give you an option, but you can > (and SHOULD) ensure it is the correct balance for the day. > > -derek > I sometimes wonder if it would be better if there was no default value, forcing one to enter a value. It is less likely to lead to mistakes. ___ 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] Find not working on multi-currency transactions.
I found what I feel is a bug - see attachment. It's basically the same as https://bugs.gnucash.org/show_bug.cgi?id=779888 reported by Christopher Lam, and marked as fixed. But I don't think it is fixed, so I added a comment. There's a link to another bug on that bug, but the link points to nowhere useful. I disagree with the comment that Find by Value should be removed - I use that quite a bit. I don't know how unusual my company is, being small (1 employee == me), but dealing in multiple currencies. 90% of what the company sells is exported outside the UK, and a reasonable fraction of those buyers only want to pay in their local currency. Or in the case of a Polish company, wanted to pay in USD, despite the fact that I offered to accept their local currency (zloty). Recently I got chatting to a guy in a pub in England who claimed he was a chartered accountant. I have no reason to disbelieve him. He said that I should not be invoicing companies in any currency other than GBP, and in his opinion I was breaking the law by doing so. Yet I discovered later after checking, our own government website clearly states* "You can invoice in any currency for the goods and services that you supply" * https://www.gov.uk/guidance/foreign-currency-transactions-vat-and-tour-operators I seem to have found a few bugs related to using multiple currencies. I guess if there are not that many people using them, bugs are not going to be discovered so readily as they otherwise would. Dave Find-bug-on-muli-currency-splits.gnucash Description: Binary data ___ 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] Reconciliation error - how should I correct?
On Mon, 30 Jan 2023 at 16:41, Phyllis Bruce wrote: > Dr. Kirby, > > I'm praying your problem is getting away from paper reconciliation. > Remember how we used to turn the page over and list the items NOT on the > bank statements? No, because I have never before attempted reconciling a bank account. My process in the past has always been one of scanning the bank statement to see if anything looked suspicious, rather than actually checking if it was right. I spotted when a company set up a scam direct debit for £4, but to be honest if a transaction to a regular supplier like RS Components was £100 too high, I would most likely not noticed. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Reconciliation error - how should I correct?
On Mon, 30 Jan 2023 at 19:46, R Losey wrote: > Normally, people 'reconcile' their records to the financial institution, > marking the ones on which they agree as 'reconciled'. > > If everything went right, the accounts should balance, leaving the > transactions that the bank doesn't know about... regardless of date. > I was probably interpreting this https://cvs.gnucash.org/docs/C/gnucash-guide/txns-reconcile1.html incorrectly, where it says “ Warning It is important to understand that reconciliation is done for a given date, and when you reconcile an account based on a statement from a given date, you are reconciling *all transactions prior to that date*. Therefore, if you add or modify transactions that predate your last reconciliation, your *reconciled* balances will be thrown off.” As far as I am aware, the transaction took place in June. So to add the entry to GnuCash I needed to add a transaction that occurred prior to the last reconciliation. I note that bit of the documentation starts cvs. Google found me that, but I think the latest documentation doesn’t say quite the same thing. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Reconciliation error - how should I correct?
On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt wrote: > On 2023-01-29 17:34, Dr. David Kirkby wrote: > > > I've reconciled my bank account until the end of July 2022, but then > found > > a bill from a vendor which was paid from the bank account in August, but > > the transaction occurred in June. So really I want to create a bill in > > June. > > In what sense is this a "reconciliation error"? I was under the impression that the reconciliation should record all transactions up to the date one reconciles. Clearly one had been missed, so I thought that was an error. But from what you say it is not. The amount is correct, so I'll just add the transaction in. That's a bit of a relief. I must say, I am impressed with the software and the support. I have found a few bugs, but once reported they get fixed. ___ 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] gnu cash creates a ton of files.
On Sat, 28 Jan 2023 at 22:04, wrote: > I get a lot of files in my documents folder that are like this: > > "X"Books.gnucash."Y" where "X" is the name of my database and "Y" seems > to > be a date time stamp. They never go away. How to I control these so that > they are automatically cleaned up by gnucash? > > Thanks > They are backups that are regularly taken. You control whether you want the backups, the frequency of the period, and how long they are kept from. Go to the Edit menu, select Preferences, then click on general. Dave (newbie to GnuCash) ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Thu, 26 Jan 2023 at 09:31, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Fix: > > Delete the PorkBun payment and re-entered properly as a payment in USD > or if it were in GBP to a USD Vendor, turn on Trading Accounts, then > re-enter the payment in GBP with the FX as the fixed debit amount. > Based on the discussion at https://bugs.gnucash.org/show_bug.cgi?id=798734 it seems to be a GnuCash bug, which will be fixed in the next release. Thank you for your help. I'm relieved that I don't have a serious error - I was concerned all *the* reports were going to be wrong. I can live with the temporary problem of some reports showing the wrong information. At least it is confined to a few transactions that I am aware of. Adrien > Dave ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Thu, 26 Jan 2023 at 09:31, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Dave, > > First off, let's get this out of the way: > > I noticed in your last screenshots, the window title bar is included > with a 'Reconciled ...' file name. Name your file whatever you want, but > I can imagine that will get tedious as time goes on to keep renaming the > file. (but I suppose if you're making copies and proceeding from there, > that is an interesting strategy) > I like to name things occasionally with names that indicate what I'm going to do, or what I have just done. If I notice a problem, I can look back and find where the problem first occurred. It seems to work for me. > > The more concerning part is that the file name has a 'date stamp' after > 'gnucash' which indicates, at some point you opened up a backup file > rather than your main file. This again, may be intentional, but if not, > you have a bit of a mess on your hands as you may inadvertently enter > data in two different files. > It would have been intentional, if I noticed a problem, I would have looked for an earlier backup. now, on to the show... > - > > I tried to duplicate what I could from your screenshots & description > but I can't seem to duplicate the issue. (I eventually did, but keep > reading) > Thank you for your efforts. I see you put a lot of effort into this. To describe the HKD problem would be quite complicated, as it is made up from two transactions to the same vendor. I did update the bug you reported https://bugs.gnucash.org/show_bug.cgi?id=798734 with a slightly more complicated case, but this time on Receivable Ageing. It's more complicated, because unlike the very low value Porkbun case for USD, which was paid on a debit card, this transaction was a bank transfer, and attracted a bank fee, which I recorded separately. I did not bother to obfuscate Porkbun, since who I buy a domain from is hardly confidential - I used them after GoDaddy wanted about 5x as much, so I decided to shop around. I did however obfuscate my customer, so little is shown of their name. Dave ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Wed, 25 Jan 2023 at 20:35, Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > > I forgot one of the attachments. > The money shown outstanding to RS Components Ltd, in GBP, is correct. It's the USD and HKD ones that are wrong. Dave ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > > I have the attached transaction showing as owing $0.98 to Porkbun.com. The > number 0.98 happens to be the difference between what this cost in USD > ($6.90) and what it cost in pounds (£5.92). > > 6.90-5.92=0.98. > I forgot one of the attachments. ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Wed, 25 Jan 2023 at 20:10, Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > can you try running Check & Repair all and check if it solves your issue > > > Saludos Cordiales > > > Murugan > I have tried that, and it does not. Dave ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
On Wed, 25 Jan 2023 at 20:04, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I'm not saying this is particularly necessary, (I'm not sure myself) but > just for completeness of information: > > Do you have Trading Accounts turned on? > > Regards, > Adrien > No. ___ 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] Have I screwed up with my Accounts Payable and Accounts Receivable?
I have some issue with some non-GBP transactions showing as outstanding if I look at Business -> Reports -> Payable Aging. Business -> Reports -> Receivable Ageing. An amount of money appears to be payable on some transactions, despite I believe they are all paid. I have the following structure Assets :Accounts Receivable Assets :Accounts Receivable:Accounts Receivable (USD) Assets :Accounts Receivable:Accounts Receivable (EUR) Assets :Accounts Receivable is *not* a placeholder account, but a GBP account. This means there are non-GBP accounts under a GBP account. Is that a bad idea? I initially had Assets :Accounts Receivable (placeholder) Assets :Accounts Receivable:Accounts Receivable (GBP) Assets :Accounts Receivable:Accounts Receivable (USD) Assets :Accounts Receivable:Accounts Receivable (EUR) but got fed up having to select Assets :Accounts Receivable:Accounts Receivable (GBP) for 99% of the transactions. So now Assets :Accounts Receivable is a GBP account, and is selected by default. I'm wondering if my layout is fundamentally flawed, having a non-GBP account as a sub-account of a GBP account. I have the same issues on Liabilities: Accounts Payable. In that case there are USD and HKD accounts under a GBP account. I have the attached transaction showing as owing $0.98 to Porkbun.com. The number 0.98 happens to be the difference between what this cost in USD ($6.90) and what it cost in pounds (£5.92). 6.90-5.92=0.98. So I'm starting to wonder if my accounts structure is wrong, and I should make Assets :Accounts Receivable and Liabilities: Accounts Payable into placeholder accounts, If I have made a fundamental error, it would be good in GnuCash could spot these, and non allow sub-accounts like this. If I have not made an error, then I need to resolve why these transactions are appearing to have money outstanding, despite there is not. Of course, the next problem is, if I should indeed have messed up, whether it's possible to recover. The GBP side of these has been reconciled, so deleting the transactions is probably not a good idea. Maybe setting up new accounts is possible, and changing the accounts things are debited or credited to. ___ 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] Is there any way to find all outstanding bills?
On Tue, 24 Jan 2023 at 09:15, Geert Janssens wrote: > Most likely you have created payments and bills independently of each > other and never linked them. In that case your balances show 0, but the > gnucash business logic doesn't know the bill is actually paid. > > There are a few ways to solve this. I propose to try this: > > * Open Business->Vendor->Process Payment... > > * Select the vendor that's listed in your payable ageing as having unpaid > bills. > > * Select the proper "Post To" account. It should be different depending on > the currency of the outstanding bills. > > => This should show a list of pre-payments and bills in the documents view > that haven't been considered as processed by the business logic. > > * Use shift-click or ctrl-click to select one or more payments and bills > that should be linked together. > > => If the payments and bills balance, the payment and refund fields should > both be 0 and the "Transfer Account" list greyed out. > > * Click the Ok button to complete linking the bill(s) and payment(s). > > * Repeat for each of the vendors that appear to have unpaid bills. > > Hope that helps, > > Geert > This does not seem to be the case. I attached a few screenshots with PORKBUN.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there any way to find all outstanding bills?
On Tue, 24 Jan 2023 at 01:50, Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > have you tried looking at the Payable ageing report > > > Saludos Cordiales > > > Murugan > No, I had not, and that seems to have what I wanted. I'm just a bit puzzled that some of the figures don't make sense. If I look at Accounts Payable, which is in GBP, the data seems correct - I owe RS £210.41. Accounts Payable for USD and HKD are both zero, but the report indicates monies are owed. But when I click on the vendors, it shows nothing owed. When I click on the bills, it shows these are paid. These seem to have a pre-payment on these couple of transactions. I assume I have done something wrong with these transactions, It's a lot more complicated dealing with payments in another currency. I assume this means there's a good chance reports I generate will be wrong. One of the amounts (USD amount) is very small, but the one in HKD is not so small. BTW, I was in the pub a couple of weeks ago, and somehow got chatting to a chartered accountant. I was telling him about issues when invoicing people in USD or Euros (my native currency is GBP). He said that I should not be billing people in anything other than GBP. I asked him whether he thought I was breaking the law in invoicing in USD and Euros, and he said that* in his opinion, it is against the law for me to invoice customers in anything other than GBP*. My accountant has never had a problem with this, but it obviously caused me to research it more. Our government website clearly states we can invoice in any currency. The only requirement is that if VAT is payable, then that amount needs to be in GBP. But it would be quite rare to invoice someone in USD if they are in the UK. I'm pretty sure this guy in the pub was wrong, despite him saying he was a chartered accountant. From our own government website. https://www.gov.uk/guidance/foreign-currency-transactions-vat-and-tour-operators *You can invoice in any currency for the goods and services that you supply. If UK VAT is due on the transaction your invoices must also show the following in sterling:* - *the total net value of goods and services at each VAT rate* - *the amount of VAT, if any, at each rate* *You do not need to show sterling figures for each line on the invoice.* ___ 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] Is there any way to find all outstanding bills?
A look at* Liabilities:Accounts Payable* allows me to find out how much. If the bills are due, then looking at Business -> Vendor -> Bills Due Reminder, will allow me to find any that need to be paid soon. But is there any way of finding a list of everyone owed money at some time in the future? I believe one can tweak the reminder period, so one could set it to remind one 6 months in advance of any bills due. But I'm wondering if there's a quicker way. Dave ___ 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] An operation is still running, wait for it to complete before quitting
I've had the above error message a few times. I'm currently using 4.12 on Linux, but I think I have seen the message with 4.12 or 4.13 with Windoze too. It does not seem to want to go away - it's not simply a case of waiting for the CPU. The program is not using much CPU power. See attachment showing output from top -n 1 -b. The CPUs in this computer are not very fast (2 GHz IIRC), but there are 52 cores in total, so a program like gnucash should not have problems accessing enough CPU resources, as the machine is basically idle. Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. top - 22:54:35 up 29 min, 1 user, load average: 0.12, 0.23, 0.32 Tasks: 654 total, 1 running, 653 sleeping, 0 stopped, 0 zombie %Cpu(s): 0.4 us, 0.5 sy, 0.0 ni, 99.1 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st MiB Mem : 385602.8 total, 379728.5 free, 3690.3 used, 2184.0 buff/cache MiB Swap: 2048.0 total, 2048.0 free, 0.0 used. 379680.5 avail Mem PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 6962 drkirkby 20 0 12420 4188 3140 R 16.7 0.0 0:00.05 top 5868 drkirkby 20 0 4233208 632136 230836 S 11.1 0.2 3:48.07 firefox 6054 drkirkby 20 0 2452288 94340 75488 S 11.1 0.0 0:09.14 Isolated Servic 2790 kernoops 20 0 11264444 0 S 5.6 0.0 0:00.09 kerneloops 1 root 20 0 168764 12196 8332 S 0.0 0.0 0:03.28 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kthreadd 3 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 rcu_gp 4 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 rcu_par_gp 5 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 netns 7 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/0:0H-events_highpri 8 root 20 0 0 0 0 I 0.0 0.0 0:00.34 kworker/u104:0-ext4-rsv-conversion 9 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/0:1H-kblockd 11 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 mm_percpu_wq 12 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_tasks_rude_ 13 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_tasks_trace 14 root 20 0 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0 15 root 20 0 0 0 0 I 0.0 0.0 0:00.61 rcu_sched 16 root rt 0 0 0 0 S 0.0 0.0 0:00.01 migration/0 17 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/0 18 root 20 0 0 0 0 I 0.0 0.0 0:00.25 kworker/0:1-events 19 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/0 20 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/1 21 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/1 22 root rt 0 0 0 0 S 0.0 0.0 0:02.25 migration/1 23 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1 25 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/1:0H-events_highpri 26 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/2 27 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/2 28 root rt 0 0 0 0 S 0.0 0.0 0:02.26 migration/2 29 root 20 0 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/2 31 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/2:0H-kblockd 32 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/3 33 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/3 34 root rt 0 0 0 0 S 0.0 0.0 0:02.26 migration/3 35 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3 37 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/3:0H-kblockd 38 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/4 39 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/4 40 root rt 0 0 0 0 S 0.0 0.0 0:02.27 migration/4 41 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/4 43 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/4:0H-events_highpri 44 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/5 45 root -51 0 0 0 0 S 0.0 0.0 0:00.00 idle_inject/5 46 root rt 0 0 0 0 S 0.0 0.0 0:02.28 migration/5 47 root 20 0 0 0
Re: [GNC] Is it reasonable to have sub-accounts under Equity:Fixed Assets?
On Tue, 17 Jan 2023 at 18:58, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > Maybe I misunderstood, I thought you wanted to track the items' values & > depreciation separately. By all means, otherwise lump them in one > account. (you can of course make separate transactions for each item, > which would allow you to run Transaction Reports filtered on each item > if needed) > I might do that. > > > What would you do for transactions that have already been written off? I > > was tempted to add those, as the company has been going for 8 years, so > > whether I add 8 years of assets or 5 does not make much difference - am > > extra 55 items. > > I don't see why there would be any need to. If they are already zero, > they don't need to enter the book at all as far as I can tell. Although written off, it might possibly be of some use to be able to look back over the years and see what was bought. If something had been purchased 4 years ago, would you bother recording the value each year, or just that when the accounts were submitted? I guess that’s probably a personal preference. I think nearly everything of mine is written off after 5 years. I think some companies might write electronic test equipment off over a longer period, but virtually all of mine is purchased used, and often when the manufacturer considers it obsolete. > > Then continue to depreciate as instructed by your accountant. None of > this involves Vendors or Bills. Okay. > > > > Regards, > Adrien Thank you for the help. I didn’t get anything done with my accounts today, due to other more pressing issues like dispatching items to customers, and attending to my dog who has a bad paw. Dave > -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Is it reasonable to have sub-accounts under Equity:Fixed Assets?
On Mon, 16 Jan 2023 at 16:27, Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 1/16/2023 7:29 AM, Dr. David Kirkby wrote: > > Apologies if this is too much an accounting question, but I'm stuck, and > am > > trying to work out how GnuCash will handle this. > > It is accounting, as opposed to gnucash, but I will help. But please do > note that perhaps more basis in double entry accounting needed than > just the tutorial if doing for a business. > > Thank you. I do have a couple of books on accounting, but admit to not reading them in full. I thought this was an equity issue, so read the sections about that, and was not convinced that using equity was correct. > > OK, I will describe what you SHOULD have done and how to get from where > you are to there. > > Ideally under fixed assets you have sub accounts, perhaps first by > acquisition year and under that for the individual things (or group of > same type). All of these accounts should have two sub accounts, one for > basis (cost of acquisition) and one for depreciation taken, the > difference being the current net book value. Note that USUALLY > depreciation is adjusted annually, as you are not required to do > monthly, AND this is to your advantage if/when any are disposed of (will > decrease any gain and increase any loss if you are allowed to use as net > value remaining that of the previous year end) > Thank you. I'm surprised the business accounts in GnuCash don't have anything resembling this. I realise the accounts are supposed to be tweaked, but this is *significantly* different to the business accounts in Gnucash. Maybe they should be altered to have 5-10 years, and some items that people are likely to buy. > > Getting there from where you are should not require you changing > anything in equity. You would just be "transferring" from your initial > structure of fixed assets to this new one. The "credit side" is account > in the old structure as you debit into the new structure. Thus, you can > rename (for now) you existing account "fixed assets" (in which nothing > broken down to something like "xfixed assets" and create your new fixed > assets tree with all the accounts in it zero. You then populate the new > tree using transactions that put in the values using the old structure > (single account) as the other side of these transactions. When you are > all done, the remaining balance in xfixed assets should be zero and you > can HIDE it. > Interesting. It's actually tempting to put *all *the assets the company has ever purchased, including those written off. It means adding 55 more assets, which is not a huge number. Although not strictly accurate, it would not seem unreasonable to write them off after 5 years in one go, rather than each year, given their net value is zero. If one writes of X in one year, Y in 4 subsequent years, and Z in another year, it does not seem unreasonable to write off X + 4 Y + Z in one go, if the result is the same - the net value is zero. However, although entering 55 new transactions would not be too time-consuming, it would if I had to set up 55 new vendors for items that have no value. As I remarked in another email, I wonder if buying from a vendor called "Written Off" or something similar would be sensible. A vendor report of Written Off would be interesting reading, despite it has no significance. I do have information on the vendors these things are purchased from, and need to keep them for 7-year. But I don't want the hassle of importing every transaction into GnuCash for 7-years. Each year as you depreciate (part of end of fiscal year processing) the > other side of the transaction will be an account under expenses named > "depreciation of fixed assets. You could set up to do monthly but WHY? > (what benefit do you gain vs what does this cost you). Remember, > depreciation is an expense but does not represent any money flowing in > or out. The money went out when you acquired the fixed asset (but you > weren't allowed to treat that as an expense at the time). > I thought monthly might work better with trying to automate what will be a tedious process. The GnuCash Scheduled Transactions could possibly be useful there. > Michael D Novack > I don't think I will bother with that. ___ 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] Is it reasonable to have sub-accounts under Equity:Fixed Assets?
On Mon, 16 Jan 2023 at 23:32, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Chris & Michael have both offered sound advice. > > I'll add towards your question of individual item tracking, simply > create sub-accounts under Assets:Fixed Assets for each one, and the > parent Fixed Assets should be empty. > > And no, they don't belong under Equity, they are Assets. The other side > of those transactions goes to Equity. (and then to Expenses for later > Depreciation as Chris noted) > > Regards, > Adrien > That would require a *lot* of accounts, but I guess it makes it blindingly obvious what the items are. I was hoping to try to automate the depreciation with the Scheduled Transactions in GnuCash. I've not used them yet, but I assume that it would be much more tricky if things are in many different accounts. But maybe I am wrong. For the purposes of submitting to Companies House, I only need the total of fixed assets - no breakdown is necessary. If the company was inspected, I assume that inspectors would want to see a breakdown. What would you do for transactions that have already been written off? I was tempted to add those, as the company has been going for 8 years, so whether I add 8 years of assets or 5 does not make much difference - am extra 55 items. Would it be sensible to create a vendor in GnuCash called "Written off" and let all things that are written off be purchased from "Written Off"? I don't really want to enter a new vendor for everything purchased years ago, and already written off. That would mean filling in the names and addresses of 55 more vendors, which would be a bit too time-consuming for my liking. ___ 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] A bug or not ? - Windows shuts down with no warning of GnuCash running.
I'm running GnuCash 4.12 on linux, and 4.13 on Windows. If I try to shut down Windows, it detects programs like LibraOffice are running, and does not shut down until I have confirmed if I want to save the data or not. I'm no fan of Windoze,. but I can see the point of that. There's no similar warning if shutting down GnuCash with a file open. One just gets the warning the next time GnuCash opens that it can't get the lock on the file, and offering the change to open read-only, quit, open anyway - or something like that from memory. Dave ___ 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] Is it reasonable to have sub-accounts under Equity:Fixed Assets?
Apologies if this is too much an accounting question, but I'm stuck, and am trying to work out how GnuCash will handle this. I'm trying to enter into GnuCash my company accounts for this financial year only - I'm not going to bother trying to enter every transaction since the company started. So the opening balances should reflect the company's financial position on 28/2/2022, and transactions from 1/3/22 being recorded. I have the account Assets:Fixed Assets All that contains is test equipment and computer equipment, all of which will be depreciated - there's no land, or other things that don't depreciate. I initially set Assets:Fixed Assets to have an opening balance of £x, as that's what my accountant told me the total of all thef fixed assets was worth. I see that is reflected in the account Equity:Opening Balances However, after I asked him, my accountant gave me a breakdown of the net value of the individual fixed assets, which have obviously depreciated over time. I thought it would be useful to have their individual net values on 28/2/2022 recorded in GnuCash, so when I depreciate them next year, I can keep a track of the depreciation. (I also thought of depreciating them monthly, which I could probably do with the scheduled transactions, as my accountant is using linear depreciation). That brings me to the problem that my initial entry for the opening balance of these fixed assets would be wrong, and should possibly set to zero. Can I set that balance to zero, then delete the appropriate Equity:Opening Balances entry? Would it be sensible to have a sub-account under Equity:Fixed Assets, or is that just not sensible? Obviously by the very nature of a double-entry system, in order to debit the Fixed Assets, I need to credit somewhere else. ___ 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] Sort order not being maintained
On Thu, 12 Jan 2023 at 04:27, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Oddly, after an unrelated crash, upon restarting GnuCash, the sort order > was back to what I had tested, rather than what I had last used. I had > to change the order again with the 'save' . (so far) > > I suppose I shouldn't expect such prefs to persist after a crash... > > Regards, > Adrien Il am losing the sort order even if the program doesn’t crash. I should have replied earlier to state I was still getting the problem in 4.13. I did look at the release notes in 4.13 and didn’t see any significant differences to 4.12, so that’s why I didn’t bother upgrading until you suggested that I did so. Initially I thought the upgrade had solved the problem, but it hasn’t. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Billing terms / payment due x days from the end of the month
On Wed, 11 Jan 2023 at 02:51, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If using the Business Features and raising Bills for that Vendor, then > set up terms either in the Vendor, or per Bill. (there is a separate > Terms editor) Thank you. I found it was proximo that I needed. Regards, > Adrien Dave. > -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Billing terms / payment due x days from the end of the month
My account with one company has terms of “ 20 Days from end of month”. I receive a statement on the 1st or 2nd of each month, dated the last day of the previous month, detailing what was ordered in the previous month. It says payment is due by the 20th of the month. Is there any way I can set up GnuCash to sort out when payment is due? -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] One payment covering multiple invoices
On Sun, 8 Jan 2023 at 23:16, Derek Atkins wrote: > Just apply the 300£ payment split between the two invoices. In the > process payment, just select both. > -derek > I am using my phone now, not near the computer, so this is from memory. On the business features there is a way to list who needs paying. Two were listed as needing paying, but it was not obvious how to select both. I will havé to look again tomorrow. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] One payment covering multiple invoices
I have an account with an electronics company RS. I get invoiced on the 20th of each month. Anything brought up to the 20th then needs to be paid by the 20th of next month. So depending on when I place the order, I can get from roughly 30 to 60 days credit. So I buy something for £100 one day, and another day I buy something for £200. So I created two bills. But when I pay, I just pay a single invoice of £300. How should this be handled in GnuCash? Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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] Will adding a transaction dated earlier than the last reconciliation cause a problem?
On Sat, 7 Jan 2023 at 23:15, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Yes, the principle of Materiality. The link Geoff gave was quite useful to me. I have noticed some differences between my calculations and my accountants before. He has replied “That will be reflected in next year’s accounts”. It was only £5.59, but I knew could not be explained by rounding errors. Now this maybe a misunderstanding on my part, and may depend upon the jurisdiction, but here’s one example. For my last years accounts (ending February 28th 2022), the money in the bank account at the end of the financial year was X. He submitted X to Companies House. Yet there were two transactions shown on the bank statement on 1st March, but shown with a date in late February. I thought he was supposed to include those two transactions in last years accounts, but he didn’t. He has not answered my email on the topic. He probably determines that they are immaterial, as they total about £15. > > It isn't worth spending time looking for small errors. Just adjust them > out and move on. That would niggle me. In any case, I would not know how to adjust it properly. My background is science, (I have a Ph.D not a medical degree). A number of scientific discoveries have been made by people who refuse to ignore things that could easily have been dismissed as insignificant. I suppose that I need to get out of that habit when chasing immaterial amounts of money. > > Otherwise, I'd say enter the transaction on what you think is the proper > date and re-reconcile. That’s what I have now done. I stuck the earlier date. I don’t have any record of the cancellation - I didn’t record it and Royal Mail didn’t email me any confirmation of the cancellation. But I know that £0.60 was the fee to get a parcel collected, so I knew what it would be. > But that begs the question, how did you reconcile without it? The truth is that in this point in time, I am trusting the bank’s records more than my own when it comes to small things like that, as I would not have bothered recording that I sought a £0.60 refund. The only reason I would bother going to the Royal Mail website and cancelling the pickup would be to save the postman a wasted journey. I would not have bothered recording it in my spreadsheet. But now I am using GnuCash, I will record these sorts of things. > > If you had to make an adjusting entry, that will also need to be edited > or deleted. I will have to find out how to handle adjustments. It is an area of accounting that I don’t understand, but are willing to learn. Regards, > Adrien Dave. > -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Will adding a transaction dated earlier than the last reconciliation cause a problem?
On Sat, 7 Jan 2023 at 14:37, Maf. King wrote: > > Is the Effective Legal Tax date 6th or 19th? Enter it to that date. The > reconcilliation will not be affected either way. > > Maf. Certainly not the 19th, but probably not the 6th either. It was for postage and a pickup fee. I must have cancelled the pickup and rebooked it for a later date. So arguably it is an unknown date between the two. The amount is only £0.60 (< $1 USD), and nowhere near the end of the accounting period, so I don’t think anyone is going to be too bothered about the accuracy of the information. I think setting it the 6th is probably best, as that’s consistent with more than 90% of the transactions. I was concerned that it might cause problems with reconciliation, in which case I would certainly not want to risk problems with that. -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Is a screwed-up style sheet hiding somewhere?
On Fri, 6 Jan 2023 at 23:18, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Fair enough. > > I see you managed to clear it up with a registry edit. > > I did manage to get a similar looking invoice to yours by default > though. That was via Reports > Business > Fancy Invoice. > > The other options of Easy, Printable, & Tax Invoice are more sane looking. It’s difficult for me to comprehend why that fancy template in that form should exist at all. I don’t think anyone could consider it sane. I reported it a bug https://bugs.gnucash.org/show_bug.cgi?id=798717 and see it has been closed with a note that it will be fixed in the next release. I thought that “Reset Defaults” in that part of the software would have reset the default invoice to be the default one. > > > You can change the 'default' Invoice template to Fancy (not that you'd > want to now) via Preferences > Business > Report for printing. Thank you. I had created an invoice with my company logo, which I would have liked to use as a default. I will recreate that now, tweak it a bit as I am not 100% satisfied, then save that as a default. (I was a bit surprised that setting the width of the banner to 1” was about optimal. The manual says one will have to experiment, but suggests 6” x 1” to be reasonable. Clearly 6” wide is very different to 1” wide) I'd bet > you had it set for the Fancy template before your re-install and regedit > attempt. I don’t know for certain, but I expect that you are right. The description of the layout clearly shows that the information is duplicated. Anyway, it will be fixed in the next release. - > As a side note here, maybe take from a clean install, a copy of the > settings location folders as a backup to do a quick restore. For the > registry entries, I think you can export selected folders/keys as a > subset that can be 're-imported' if needed rather than have to manually > edit individual keys. (This is how installations work behind the scenes) > I don't recall all of those steps as I haven't regularly used Windows in > years, but I know it can be done. Thank you for the suggestion. I would much prefer to be using a Linux computer myself. Unfortunately the Linux computer is in my lab, which is detached from the house. In order to use that computer I would need to run the air conditioning to keep the room temperature comfortable, then use a power hungry computer to use some software that uses very little CPU power or memory. I think I should invest in a more general purpose computer. It is very rare for me to need several hundred of GB of RAM. Regards, > Adrien Dave ___ 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] Will adding a transaction dated earlier than the last reconciliation cause a problem?
I'm inputting my 2022 accounts, and have reconciled up to 10/04/2022 (DD/MM/). Now I just found a refund, dated 06/04/2022, but does not appear in the bank account until 19/04/2022. Is it safe to create a credit note, dated 06/04/2022, then reconcile up to 19/04/2022 at a later date? Or should I date it 19/04/2022, and reconcile up to that at a later date? Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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] Is a screwed-up style sheet hiding somewhere?
On Fri, 6 Jan 2023 at 22:12, David H wrote: > Dave, > > You might be overlooking the settings in the Windows Registry? Details at > https://wiki.gnucash.org/wiki/Configuration_Locations - snippet below > > Cheers David H. > Thank you. Clearing the stuff from the registry with regedit cleared the problem. Dave ___ 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] Is a screwed-up style sheet hiding somewhere?
On Fri, 6 Jan 2023 at 21:28, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > You didn't like the looks of an invoice so you tried > uninstall/re-install? Holy cow. > > Since you don't specify what about the invoice you don't like, the best > I can do is guess: > > You're not a fan of your duplicated company name and info. That's > certainly reasonable. I'm not sure why it would appear twice either. > That's an easy fix though. (without a re-install or starting a new book!) > Since installation was so quick, I thought removing all files from all the directories listed in Help -> About was certain to solve the problem. Your fix works for an invoice, but the next time I try to generate one, the same problem persists. So I don't think that's an ideal solution. I don't want to have to change it manually each time. Originally the default invoice looked reasonable (no duplicated company name). I was messing around with the style sheets a week or so ago when I caused the problem. I know I created it, and also moving the accounts to a Linux workstation does not show the problem. So the problem was caused by me on this Windows laptop and remains on the laptop, not the .gnucash file. I have somehow changed the default invoice (and bill), and left the changes in a location I can't find. I tried changing the location I saved files from the Documents folder to the Desktop. But that does not solve the problem. I'm 99% sure there was an uninstall program on version 4.12. But maybe Windows put one in the GnuCash folder. Looking at this https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Windows GnuCash uses files in HOME\AppData\Local. That's not listed on the help menu. You might laugh, but I'm going to uninstall again, and see if I can clear out anything from HOME\AppData\Local. Perhaps then I can restore the default behaviour to something sensible. Dave ___ 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] Is a screwed-up style sheet hiding somewhere?
A week or two ago I managed to do something that meant invoices and bills looked silly. Today I upgraded to GnuCash 4.13 on Windoze, and the problem persisted. So I used the uninstall tool. That did not seem to delete all the directories, so I deleted the directories C:\Program Files(x86)\gnucash, as well as C:\Users\44719\AppData\Roading\GnuCash (For reasons I don't know, my use id on this laptop seems to be 44719. That's nothing specific to GnuCash). Then I reinstalled GnuCash 4.13 again. The bills and invoices still looked silly. So I created a new set of accounts, with some silly company names, and still they look silly - see attachment. I'm guessing there's some style sheet hiding somewhere, but I don't know where it is. BTW, I noticed that GnuCash version 4.13 does not have an uninstall program, whereas version 4.12 has. I'm not sure if that's intentional or not. Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. Invoice-01-06_01_2023.pdf Description: Adobe PDF document ___ 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] Sort order not being maintained
I'm running GnuCash 4.12 on both linux and Windoze - mainly on Windoze laptop, as my desktop PC uses 200 W of power when idle, plus whatever the monitor uses. I keep sorting the bank account, or other accounts, but the sort order keeps being lost, despite me ticking the box to keep the sort order. See attachment. Is there anyway I can set this sort order for every account once and forget it? ___ 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.