Yes, I agree that the exchange rate has to be input. Whether you fetch the rate (also permitted by HMRC as I understand it) or input the rate manually it still has to be confirmed for each invoice when posting in Gnucash.
---- Christopher Lam wrote ---- >But it's crucial to input the exchange rate - and IIUC you are encouraged >to use >https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly > >On Mon, 7 Dec 2020 at 22:47, Samantha Payn <[email protected]> >wrote: > >> >> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into >> Gnucash down to a fine art (especially with the recent “predictive text” >> input in my “product” fields! Thanks again for that, whoever it was!). It >> is specifically the step to confirm the exchange rate when posting an >> invoice which is the time consuming point. >> Samantha Payn >> >> > On 7 Dec 2020, at 22:25, Adrien Monteleone < >> [email protected]> wrote: >> > >> > Samantha, you can import invoice data. >> > >> > Thus, if you have a way to easily create that data in a spreadsheet, you >> can save it as CSV, then import them to GnuCash. >> > >> > See the Help/Guide about importing business data for the required >> columns. >> > >> > I'm not certain if it works well with a foreign currency however. >> > >> > Regards, >> > Adrien >> > >> >> On 12/7/20 4:11 PM, Samantha Payn wrote: >> >> I’d find a “batch post invoice” function enormously helpful. I have a >> foreign currency client who insists on a separate invoice for each >> (sometimes inconsequential) amount and the multiple clicks to post the >> invoice and confirm the exchange rate for each one are time consuming. >> >> Currently the quickest I’ve got it is to create each invoice but not >> post it, then use “find invoice” criteria to call all the invoices up, >> highlight them all and then click “post” which prompts the exchange rate >> dialogue (for every invoice). I use “fetch rate” for the first invoice, and >> just “accept rate” for all the others, but that’s still three clicks per >> invoice (I think). >> >> Please could Santa bring me a “batch post invoice” function for >> Christmas? >> > >> > _______________________________________________ >> > gnucash-user mailing list >> > [email protected] >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > ----- >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> _______________________________________________ >> gnucash-user mailing list >> [email protected] >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
