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?
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 Op dinsdag 24 januari 2023 03:39:02 CET schreef Dr. David Kirkby: > 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-opera > tors > > *You can invoice in any currency for the goods and services that you ___ 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.
Re: [GNC] Is there any way to find all outstanding bills?
have you tried looking at the Payable ageing report Saludos Cordiales Murugan From: gnucash-user on behalf of Dr. David Kirkby Sent: Monday, January 23, 2023 7:25 PM To: GNU Cash User Subject: [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. ___ 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?
The Bills Due Reminder is not just short term, it should show all unpaid bills *that are posted*. (in conjunction with setting the reminder window via Preferences > Business > Bills > Notify when due & Days in advance.) You can also do Business > Vendor > Find Bill and set the criteria to find unpaid bills. GnuCash does not have a projection feature to automatically guess if certain bills continue or not. However, the Budget module may be useful there, (and it does have an estimating function based on historical activity) or you can employ future Scheduled Transactions (SX) which make a few reports designed for them a bit more useful for such a scenario. If you choose the SX route, you can get them to fire, run your report, delete them and then turn off the SXs till needed again. (*note, going the SX route is 'outside' the cognizance of the Business Features, so really only useful for projection reports, not as a regular data-entry substitute) Regards, Adrien On 1/23/23 4:25 PM, Dr. David Kirkby wrote: 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. ___ 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.
