Re: [GNC] Automatic sales tax

2022-03-01 Thread John Layman
I can lay no claim to being an expert where sales tax is concerned. Your comment caused me to research how many states are origin-based, and it turns out the number is eleven. So you are correct that the majority are destination-based. Online sales have clouded this issue because states have

Re: [GNC] Automatic sales tax

2022-03-01 Thread John Layman
According to SalesTaxInstutute.com: Sales Tax is tax on the sale, transfer or exchange of a taxable item/service, generally charged to the purchaser as an add-on to the price, the purchaser typically being the consumer or end user. Use Tax is a tax on storage, use, or consumption of a taxable ite

[GNC] Reconcile Reset Please

2022-03-01 Thread Brock Rycenga
Someone please tell me there is a way to "reset" the reconcile record for an account. There has to be a way. I am on my 2nd attempt at rebuilding all of my accounts and their corresponding transactions. I have successfully reconciled all but my final checking account. Unfortunately, as soon as I st

Re: [GNC] Reconcile Reset Please

2022-03-01 Thread Derek Atkins
HI, On Tue, March 1, 2022 10:05 am, Brock Rycenga wrote: > Someone please tell me there is a way to "reset" the reconcile record > for an account. There has to be a way. I am on my 2nd attempt at > rebuilding all of my accounts and their corresponding transactions. I > have successfully reconciled

Re: [GNC] Reconcile Reset Please

2022-03-01 Thread Brock Rycenga
Thank-you for the reply, Derek. Here are some better details. 1. I had problems with my checking account - probably because I added other accounts that fed into/out of that account after I had already reconciled the checking account. 2. At that point, after researching, I felt it best to "re-do"

Re: [GNC] Reconcile Reset Please

2022-03-01 Thread Derek Atkins
Hi, It is unlikely that importing will have caused a reconcile issue, but copying transactions out of the older account certainly could be. I suggest you open the (new) checking account, go to View -> Filter by.. -> Status and then uncheck everything but "reconciled". This will show you all th

Re: [GNC] Postgresql is not available as an option on "Save As"

2022-03-01 Thread Dimitri Balios
Thanks for the guidance Thomas. For Ubuntu the package is called libdbd-pgsql , and after installing that the option to "save as" postgresql appears On Mon, Feb 21, 2022 at 12:57 PM Thomas Boerner wrote: > You are probably missing the libdbi driver for postgresql. Unfortunately I > can't tell wh

[GNC] Close books or start over?

2022-03-01 Thread Leo Bolta via gnucash-user
Hello, I moved from my home country about 4 months ago and did keep track of expenses from the day that I left. Would now like to start tracking again using the program but wondering what would be the most practical way to begin again. If starting from a clean slate, how can I keep the same acco

Re: [GNC] Close books or start over?

2022-03-01 Thread davidcousens49
Leo Just export your account tree (File_>Export_>Export Account Tree to CSV) and reimport it into your new set of books. David cousens On Tue, 2022-03-01 at 22:14 +, Leo Bolta via gnucash-user wrote: > Hello, I moved from my home country about 4 months ago and did keep track of > expenses fr

Re: [GNC] Close books or start over?

2022-03-01 Thread Michael or Penny Novack
On 3/1/2022 5:14 PM, Leo Bolta via gnucash-user wrote: Hello, I moved from my home country about 4 months ago and did keep track of expenses from the day that I left. Would now like to start tracking again using the program but wondering what would be the most practical way to begin again. If

Re: [GNC] Reconcile Reset Please

2022-03-01 Thread Brock Rycenga
Wow! Thanks-a-bunch for the help, Derek! That got me the "reset" that I was looking for. Much appreciated. Brock On Tue, Mar 1, 2022 at 11:30 AM Derek Atkins wrote: > > Hi, > > It is unlikely that importing will have caused a reconcile issue, but > copying transactions out of the older account c

[GNC] Eliminate Manual Download of Transaction

2022-03-01 Thread Jesse MacDougall
I have downloaded OFX file from my bank and credit cards. Is there a way I can automate manually downloading these files? I only File - Import - Import options. The Objective is to have to download the QFX files each month and auto import them. I see Tools - Online Banking Setup - and see Start A

Re: [GNC] Eliminate Manual Download of Transaction

2022-03-01 Thread Geoff
Hi Jesse GnuCash cannot do this. You need to investigate automation tools. For Windows, check out: AutoHotKey https://www.autohotkey.com/ Power Automate Desktop https://powerautomate.microsoft.com/en-us/desktop/ For web browser automation: Selenium https://www.selenium.dev/ I can't recommend

Re: [GNC] Eliminate Manual Download of Transaction

2022-03-01 Thread davidcousens49
Jesse, That is exactly what the Aqbanking interface does. It depends upon your bank allowing OFXDirectConnect. Some banks in some countries do not allow this. There is a lot of dscussion about setting up the aqbanking For setting this up see https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnec