Re: [GNC] Issues with missing gnc-fq-dump
>From the 5.0 release notes The Online Quotes facility has been completely rewritten and the old gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with finance-quote-wrapper. The functions performed by those programs may now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help for specifics. The perl module requirements have changed with the rewrite: The new version doesn't need Date::Manip but needs JSON::Parse instead. gnc-fq-update has been, er, updated to reflect that. On Wed, 29 Nov 2023 at 15:51, Robin Haeusler via gnucash-user < gnucash-user@gnucash.org> wrote: > g'day. trying to setup Gnucash on my Debian Linux system. Installed and > working fine, but now need to start tracking crypto currency trading and > earnings/losses. I have followed the manual, can get gnc-fq-update to > work, but not gnc-fq-dump can't find it installed anywhere. > > I work with aud as my default currency, and all investments reported > back as usd/usdt. I honestly think there are some improvements needed in > the manual for helping an ancient beginner! > > any advice be greatfully appreciated. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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] Issues with missing gnc-fq-dump
g'day. trying to setup Gnucash on my Debian Linux system. Installed and working fine, but now need to start tracking crypto currency trading and earnings/losses. I have followed the manual, can get gnc-fq-update to work, but not gnc-fq-dump can't find it installed anywhere. I work with aud as my default currency, and all investments reported back as usd/usdt. I honestly think there are some improvements needed in the manual for helping an ancient beginner! any advice be greatfully appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] closing accounts
Thank you! Perfect! On Tue, Nov 28, 2023, 5:25 PM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > mark the account as place holder, which will stop transactions to be > entered > > > > Saludos Cordiales > > > Murugan > -- > *From:* gnucash-user hotmail@gnucash.org> on behalf of Elmar > *Sent:* Tuesday, November 28, 2023 6:51 PM > *To:* gnucash-user@gnucash.org > *Subject:* [GNC] closing accounts > > How do you actually CLOSE but not delete an account, so that no new > transactions can ever be posted to it, i.e. mark it as read only? GC > keeps stuffing things automatched some way to the closed accounts. How > can I flag that account as unavailable? > > - elmar > ___ > 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] closing accounts
mark the account as place holder, which will stop transactions to be entered Saludos Cordiales Murugan From: gnucash-user on behalf of Elmar Sent: Tuesday, November 28, 2023 6:51 PM To: gnucash-user@gnucash.org Subject: [GNC] closing accounts How do you actually CLOSE but not delete an account, so that no new transactions can ever be posted to it, i.e. mark it as read only? GC keeps stuffing things automatched some way to the closed accounts. How can I flag that account as unavailable? - elmar ___ 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] closing accounts
Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2023-11-28 13:51, Elmar wrote: > How do you actually CLOSE but not delete an account, so that no new > transactions can ever be posted to it, i.e. mark it as read only? Yes, that's right. The GnuCash word for a read-only account is a Placeholder. On your Accounts panel, you may want to click the down arrow at the extreme right of the headings row, and tick (check) Placeholder. Then if you have several accounts to make read only, you can do that by ticking (checking) boxes in the new column of the Accounts Panel, instead of having to open up a new Edit screen for each account. By the way, Hidden accounts also have an optional column in the Accounts panel. If you want to hide or unhide several accounts at once, it's a time saver too. Stan Brown Tehachapi, CA, USA https://BrownMath.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] 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.
[GNC] closing accounts
How do you actually CLOSE but not delete an account, so that no new transactions can ever be posted to it, i.e. mark it as read only? GC keeps stuffing things automatched some way to the closed accounts. How can I flag that account as unavailable? - elmar ___ 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.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:
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.
Re: [GNC] How do I add AP and AR for multiple currencies?
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 On 11/28/23 11:11 AM, David Kirkby wrote: 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 ___ 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.
Weird. Without that bill, do the vendors show but with everything as zero balances? If not, try Options > General > Show zero balance items. If that works and your balances are all zero as of the end of Feb '22, then your A/P as of that date was indeed zero. Any discrepancy otherwise *might* be a multi-currency related bug. Note, some reports still have bugs with multi-currency. I know the Balance Sheet is one. It is possible the P and/or Trial Balance also have such bugs. If that is the case, you might have to run each of those for each currency, (Options > Commodities) and manually (using some copy/paste steps to a spreadsheet) assemble a combined report from them pulling only the relevant figures. And if you can verify that all is correct on your end, file a bug report with the details you found, or amend an existing bug or bugs. If I recall, there hasn't been much real-world testing of multi-currency for most reports. Regards, Adrien On 11/28/23 10:11 AM, David Kirkby wrote: But if I add a bill, and don't pay it, then the Payable Aging report shows 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] 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] Have I got my USD accounts set up wrong?
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.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 11/28/23 5:34 AM, David Kirkby wrote: 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* 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. 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. With the report open, click the Options button on the toolbar. On the General tab, change the 'To' date to your desired end date explicitly, in this case, 28/02/2022. 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 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. I thought the Help Manual or the Tutorial & Concepts Guide covered this situation, but I could be mistaken. Regards, Adrien ___ 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] Setting up an account for stocks
Please copy the list on replies. For one thing, this gives other people the chance to come in and help: you could have had further suggestions well before I got to see your message. On 28 November 2023 at 11:41, Max Hilbig said: > Hi Fred, > > Thanks for your response. > > My first email was a bit incomplete so I will outline my steps from the > beginning. My reference to the guide below is to the Tutorial and Concept > Guide available from the Help menu of GnuCash. [...] > 3. This displayed the "Select security" dialog box. This I note is also > different to the Guide Figure 9.7 and I have no Idea what is meant by > Namespace (see Shot 3). Clicking on the down arrow next to Namespace only > displays "All non-currency" and the down arrow along side of Security did > nothing. > > 4. Clicking the New button in the Select security dialog box displayed the > New security dialog box as shown in shot 4. This also differs form the > Guide figure 9.8 but I filled it out as shown in shot 4 and this is where > I could go no further as the bottom half under Quote Source Information is > greyed out . But it does display the Warning "Finance:Quote not installed > properly". I have not been able to find any information about this to > date. > > So I hope you can shed light on my problem. Your input is most welcome. You need to create a security before you can link it to an account. Please read the Tutorial and the Help on creating securities. The reason you can't complete adding the security isn't because you haven't installed Finance:Quote, it's because you've left Namespace blank (I think). I'm on an earlier version but in the one I have you can't leave Namespace blank. Mine defaults to AMEX (no idea why, unless because it's first alphabetically) but as the Help says you can put anything you like if the security you're interested in isn't one of the predefined ones (apparently your version doesn't have any predefined). ___ 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.
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 On 11/27/23 4:58 PM, David Kirkby wrote: [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.
Re: [GNC] Find what was in Accounts Payable some date in the past.
Not so. Go back and read my replies again. You absolutely can get what you are looking for after the fact. Most accountants just want the total AP number. But if you need to provide it by Vendor, I've given you the steps to get that info. Regards, Adrien On 11/27/23 7:08 PM, David Kirkby wrote: 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.
Re: [GNC] Find what was in Accounts Payable some date in the past.
The Payables Aging Report will tell you the *amount* that is outstanding, and to who, and with an aging time frame, as of the date of the report. Once you have the Payables Aging Report - you know who you owed money to as of that date and how much. To see which bills that entails, you have to click the total amount owed to that vendor, which will then give you a Vendor Report where you can choose in Options to see the Detailed Links that show you which payments apply to which bills and which bills were covered by which payments, and thus figure out what exactly was owed and why as of a particular date. (with aging info on both reports) You may need or want to alter this reports date range as well. You *could* just run the vendor report correctly, but running the Aging Report first quickly highlights the amounts and vendors to target for further investigation. Regards, Adrien On 11/27/23 4:58 PM, David Kirkby wrote: That allows me to set a date range, gives a report that ends like this. But it is not clear what is outstanding. I'm fairly convinced it should be £0.00, as I try to settle anything owed near the end of the accounting period. But clearly it is not showing zero, and in fact has never shown zero. There is an £8.99 balance carried forward, and quite often the running balance falls to £8.99. Then after 12/4/22, the balance does not fall to £8.99, and I can't see why. [image: image.png] Then lots more, and ending. It's not obvious to me what is causing this, and I can't seem to find a list what was supposed to be outstanding here. ___ 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.
