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] 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] 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.
Re: [GNC] Find what was in Accounts Payable some date in the past.
Okay, I can see two ways to go from here. First try using the Vendor Report. That one provides the option selecting both the beginning and ending date to be used. If that doesn't do it, checking the individual vendor accounts should provide the information needed. Kirk On Monday, November 27, 2023 at 06:10:13 PM PST, David Kirkby wrote: 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. ___ 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.
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. On Mon, Nov 27, 2023 at 8:11 PM David Kirkby wrote: > 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. > -- David Carlson ___ 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.
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 On Monday, November 27, 2023 at 05:08:42 PM PST, David Kirkby wrote: 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. ___ 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.
Re: [GNC] Find what was in Accounts Payable some date in the past.
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 On Monday, November 27, 2023 at 02:59:43 PM PST, David Kirkby wrote: On Mon, 27 Nov 2023 at 22:19, kirk abbott wrote: > While looking at the report, click on 'Options' on the menu bar. General > options should allow you to select the date that you want. > > Kirk > 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. [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] Find what was in Accounts Payable some date in the past.
While looking at the report, click on 'Options' on the menu bar. General options should allow you to select the date that you want. Kirk On Monday, November 27, 2023 at 12:42:13 PM PST, David Kirkby wrote: 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. ___ 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 Monday, 27 November 2023 20:41:52 GMT David Kirkby wrote: > 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 Hi Dave, 99% sure you can set the date on the aging report. HTH, Maf. ___ 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.
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 On 11/27/23 1:23 PM, David Kirkby wrote: 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.
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.
Re: [GNC] Find what was in Accounts Payable some date in the past.
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 On Mon, 27 Nov 2023 at 18:03, David Kirkby wrote: > > 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. -- David Whiting ___ 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.