Re: [GNC] Problem Editing Payment - Customer Job
Hi Adrien, Thanks for the feedback. I downloaded the latest version of GnuCash 4.11, and the issue still exists. When I edit an existing payment, the job name appears where the customer name should appear in the payment dialog. If you try to remove the job name, you can’t enter or find the customer. When the payment dialog is initially opened, you also get a warning dialog that says “You have no valid “Post To” accounts. Once you close this dialog, the Post To field is empty and you can not select an account. When you open the existing invoice, it shows both the customer and job. I checked and the job is only associated with a single customer and not a vendor. If I delete the payment and create a new one, I can enter the customer then select the invoice that had the job assigned to it. This appears to me as a defect in the edit payment. A payment is associated with a customer, not a job, and it’s applied to an invoice associated with the customer. I wish one of the developers would take a look at the defect that I filed back in 2021. Thanks for responding. Keith > > -- > > Message: 3 > Date: Mon, 8 Aug 2022 10:08:22 -0500 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Problem Editing Payment - Customer Job > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > After you re-create the payment, does it show as 'owned by' the Customer > or the Job? (as before) > > I'm going to hazard a guess this is due to the following: > > In order to match payments, each payment and invoice need a common > 'owner'. There can be only one 'owner' of a document. (payment, invoice, > bill) If I recall correctly, the Jobs feature is implemented by > replacing the Customer/Vendor owner with the Job as owner. This still > otherwise works, because a Job is tied 1:1 with a single > Customer/Vendor. (you can't have the same Job associated with multiple > Customers/Vendors) > > I'm not sure if this is a bug 'as-code-error' as it is maybe an > oversight to facilitate editing of a payment with a Job assigned due to > design decisions. Certainly, I agree with the expectation that it should > work regardless. > > - > A sidebar here is that a Job can't be assigned to both a Vendor and > Customer. You *can* have two Jobs with the same name one assigned to > each, but they aren't tied together in anyway. > - > > Regards, > Adrien > > On 8/6/22 11:23 AM, Keith Fetterman wrote: >> Back in 2021, I reported an issue that I was having with editing an invoice >> payment if the invoice had a job associated with it. When I try to edit the >> payment, the payment dialog shows the job and not the customer, and I can >> not select the customer. This issue still exists in GnuCash 4.9. >> >> Has anyone else encountered the issue? Does anyone else use jobs with >> invoices and have not experienced this problem? >> >> I have to delete the payment and create a new one. >> >> I submitted a Bugzilla bug (Bug 798210), but I haven?t seen any activity on >> the ticket since I posted 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.
[GNC] Problem Editing Payment - Customer Job
Back in 2021, I reported an issue that I was having with editing an invoice payment if the invoice had a job associated with it. When I try to edit the payment, the payment dialog shows the job and not the customer, and I can not select the customer. This issue still exists in GnuCash 4.9. Has anyone else encountered the issue? Does anyone else use jobs with invoices and have not experienced this problem? I have to delete the payment and create a new one. I submitted a Bugzilla bug (Bug 798210), but I haven’t seen any activity on the ticket since I posted it. Thanks Keith > Begin forwarded message: > > From: Keith Fetterman > Subject: Problem Editing Payment - Customer Job > Date: June 13, 2021 at 2:51:28 PM PDT > To: gnucash-user@gnucash.org > > Hi, > > I am encountering a problem with GnuCash 4.5 where I can not edit an existing > customer payment if the payment is for invoices that have a job associated > with them. When I select “Edit payment” on an existing payment, I see a > dialog overlaying the Process Payment dialog that says: > > You have no valid “Post To” accounts. Please create an account of type “” > before you continue to process this payment. Perhaps you want to create an > Invoice or Bill first?. > > When I close this dialog, the Process Payment dialog shows the job name where > the customer name usually appears in the upper left sections. The Post To > account select is blank and the invoice(s) that were originally selected when > the payment was created are missing. > > I attempted to replace the job name with the customer name, but it only > accepts the other jobs for that customer. You can not find or select a > customer. > > Am I doing something wrong or is this a defect in GnuCash 4.5? > > If my invoices do not have a job selected, I do not have an issue editing an > existing payment. It only happens when the invoices have a job associated > with them. > > I am using GnuCash 4.5 on MacOS Catalina. I searched Bugzilla, but I didn’t > find an existing defect. > > Thanks, > Keith ___ 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] Customer Deposits
Hi Adrien, Thank you for sharing your experience and suggestions. It’s too much work to generate the reports outside of GnuCash, so I am going to follow your lead and switch to doing pre-payments. I thought it was important to show the customer deposits in a separate liability account. I hadn’t thought of the pre-payments as a having a contra affect on the accounts receivables, which makes sense. Thanks Keith > > > -- > > Message: 2 > Date: Tue, 8 Feb 2022 16:04:41 -0600 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Customer Deposits > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > You can create such a liability account though you'd have to run a > separate Account Report on it and later combine it with a Customer > Report outside of GnuCash. (in a spreadsheet) And when you record > pre-payments, you have to do them manually in that Deposits account, > then later, 'pay' the invoice with the Deposits account balance using > the Process Payments feature. > > I used to do it this way, but reverted to simply doing normal > pre-payments for ease of generating reports. It is easy enough to see > the pre-payments with an A/R Aging or individual Customer Report. (that > is if they exceed posted invoices. If not, technically, they aren't a > liability) > > Negative A/R *is* a Liability because it is a contra-balance in an asset > account. > > Regards, > Adrien > > On 2/5/22 4:52 PM, Keith Fetterman wrote: >> Is there a way to configure GnuCash to enter customer pre-payments a >> ?Customer Deposits? liability account under the ?Liabilities? account and >> have the pre-payment appear in a customer report? >> >> Currently, when you enter a customer payment as a pre-payment it appears as >> a negative amount in the accounts receivable account. I would like >> pre-payments to entered into a ?customer deposits" liability account so they >> appear as a liability to the company. When I pay the customer invoices, I >> can pay them from the ?customer deposits? liability account. >> >> I experimented with using a Customer Payment to enter the payment into the >> AR account then use a journal entry between the AR account and the ?customer >> deposits? liability account. When I pay an invoice from the ?customer >> deposits? account, I get two payments in the customer report. >> >> I can create transactions between a bank account and a ?customer deposits? >> liability account to represent the customer deposit, but it does not appear >> in a customer report. It would be nice to have this shown in the customer >> report. > > > > -- > > > -- > > Subject: Digest Footer > > ___ > > gnucash-user mailing list > gnucash-user@gnucash.org > 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. > > > -- > > End of gnucash-user Digest, Vol 227, Issue 14 > * ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Customer Deposits
Is there a way to configure GnuCash to enter customer pre-payments a “Customer Deposits” liability account under the “Liabilities” account and have the pre-payment appear in a customer report? Currently, when you enter a customer payment as a pre-payment it appears as a negative amount in the accounts receivable account. I would like pre-payments to entered into a “customer deposits" liability account so they appear as a liability to the company. When I pay the customer invoices, I can pay them from the “customer deposits” liability account. I experimented with using a Customer Payment to enter the payment into the AR account then use a journal entry between the AR account and the “customer deposits” liability account. When I pay an invoice from the “customer deposits” account, I get two payments in the customer report. I can create transactions between a bank account and a “customer deposits” liability account to represent the customer deposit, but it does not appear in a customer report. It would be nice to have this shown in the customer report. Thoughts on how to do this? ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Problem Editing Payment - Customer Job
Hi, I am encountering a problem with GnuCash 4.5 where I can not edit an existing customer payment if the payment is for invoices that have a job associated with them. When I select “Edit payment” on an existing payment, I see a dialog overlaying the Process Payment dialog that says: You have no valid “Post To” accounts. Please create an account of type “” before you continue to process this payment. Perhaps you want to create an Invoice or Bill first?. When I close this dialog, the Process Payment dialog shows the job name where the customer name usually appears in the upper left sections. The Post To account select is blank and the invoice(s) that were originally selected when the payment was created are missing. I attempted to replace the job name with the customer name, but it only accepts the other jobs for that customer. You can not find or select a customer. Am I doing something wrong or is this a defect in GnuCash 4.5? If my invoices do not have a job selected, I do have an issue editing an existing payment. It only happens when the invoices have a job associated with them. I am using GnuCash 4.5 on MacOS Catalina. I searched Bugzilla, but I didn’t find an existing defect. Thanks, Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] How To Remove All Old Invoices
Has anyone found a way to remove old invoices? I am using a GnuCash accounting file for a different business, but I want to retain the same customers. I followed the steps below to remove the old transactions and use the same chart of accounts. I discovered today that the old file also retained all of the previous invoices, and I didn’t find a command to delete them. Is there anyway to remove the old invoices? If not, I think I will need to start from scratch and re-import the customers. Unfortunately, that would mean having to go through each customer and reestablish the billing terms and sales tax table assignements. > On Mar 20, 2021, at 6:30 PM, Geoff wrote: > > How about: > . Export the Accounts > . Delete each Account (and its transactions) > . Import the Accounts. > > > Geoff > = > > On 21/03/2021 12:23 pm, Keith Fetterman wrote: >> I’ve tried that, and you are correct. I creates the same chart of accounts, >> but the tax tables, customers/vendors, etc. are missing. >> I thought a bulk delete of the transactions would work, but I don’t see a >> way to bulk delete the transactions. >>> On Mar 20, 2021, at 6:21 PM, D. wrote: >>> >>> That saves accounts, but I believe not any of the business objects, >>> unfortunately. >>> >>> >>> ---- Original Message >>> From: "D. via gnucash-user" >>> Sent: Sat Mar 20 21:18:51 EDT 2021 >>> To: Keith Fetterman >>> Cc: GnuCash users group >>> Subject: Re: [GNC] How To Remove All Transactions >>> >>> File->Export Accounts >>> >>> >>> Original Message >>> From: Keith Fetterman >>> Sent: Sat Mar 20 21:14:40 EDT 2021 >>> To: GnuCash users group >>> Subject: [GNC] How To Remove All Transactions >>> >>> I need to create a copy of an existing GnuCash file that does not have the >>> transactions. I need to keep the same chart of accounts, configuration and >>> settings, tax tables, customers, vendors and report configurations in the >>> new GnuCash file, but have all of the transactions removed. What is the >>> easiest way to do this? >>> >>> Is there a way to bulk delete all of the transactions and have an empty >>> chart of accounts? >>> >>> Thanks >>> Keith >>> >>> PS. I checked the mailing list, but I could find any recent posts. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> 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 >>> gnucash-user@gnucash.org >>> 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 >> gnucash-user@gnucash.org >> 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 gnucash-user@gnucash.org 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.
Re: [GNC] How To Remove All Transactions
Geoff, That appears to work. The only thing that I lost was the Tax Report Options that were assigned to the original accounts. That’s a minor pain to reconfigure, but a lot less of a pain than setting up everything and re-importing customers. Thanks Keith > On Mar 20, 2021, at 6:30 PM, Geoff wrote: > > How about: > . Export the Accounts > . Delete each Account (and its transactions) > . Import the Accounts. > > > Geoff > = > > On 21/03/2021 12:23 pm, Keith Fetterman wrote: >> I’ve tried that, and you are correct. I creates the same chart of accounts, >> but the tax tables, customers/vendors, etc. are missing. >> I thought a bulk delete of the transactions would work, but I don’t see a >> way to bulk delete the transactions. >>> On Mar 20, 2021, at 6:21 PM, D. wrote: >>> >>> That saves accounts, but I believe not any of the business objects, >>> unfortunately. >>> >>> >>> ---- Original Message >>> From: "D. via gnucash-user" >>> Sent: Sat Mar 20 21:18:51 EDT 2021 >>> To: Keith Fetterman >>> Cc: GnuCash users group >>> Subject: Re: [GNC] How To Remove All Transactions >>> >>> File->Export Accounts >>> >>> >>> Original Message >>> From: Keith Fetterman >>> Sent: Sat Mar 20 21:14:40 EDT 2021 >>> To: GnuCash users group >>> Subject: [GNC] How To Remove All Transactions >>> >>> I need to create a copy of an existing GnuCash file that does not have the >>> transactions. I need to keep the same chart of accounts, configuration and >>> settings, tax tables, customers, vendors and report configurations in the >>> new GnuCash file, but have all of the transactions removed. What is the >>> easiest way to do this? >>> >>> Is there a way to bulk delete all of the transactions and have an empty >>> chart of accounts? >>> >>> Thanks >>> Keith >>> >>> PS. I checked the mailing list, but I could find any recent posts. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> 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 >>> gnucash-user@gnucash.org >>> 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 >> gnucash-user@gnucash.org >> 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 gnucash-user@gnucash.org 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.
Re: [GNC] How To Remove All Transactions
I’ve tried that, and you are correct. I creates the same chart of accounts, but the tax tables, customers/vendors, etc. are missing. I thought a bulk delete of the transactions would work, but I don’t see a way to bulk delete the transactions. > On Mar 20, 2021, at 6:21 PM, D. wrote: > > That saves accounts, but I believe not any of the business objects, > unfortunately. > > > Original Message > From: "D. via gnucash-user" > Sent: Sat Mar 20 21:18:51 EDT 2021 > To: Keith Fetterman > Cc: GnuCash users group > Subject: Re: [GNC] How To Remove All Transactions > > File->Export Accounts > > > Original Message > From: Keith Fetterman > Sent: Sat Mar 20 21:14:40 EDT 2021 > To: GnuCash users group > Subject: [GNC] How To Remove All Transactions > > I need to create a copy of an existing GnuCash file that does not have the > transactions. I need to keep the same chart of accounts, configuration and > settings, tax tables, customers, vendors and report configurations in the new > GnuCash file, but have all of the transactions removed. What is the easiest > way to do this? > > Is there a way to bulk delete all of the transactions and have an empty chart > of accounts? > > Thanks > Keith > > PS. I checked the mailing list, but I could find any recent posts. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
[GNC] How To Remove All Transactions
I need to create a copy of an existing GnuCash file that does not have the transactions. I need to keep the same chart of accounts, configuration and settings, tax tables, customers, vendors and report configurations in the new GnuCash file, but have all of the transactions removed. What is the easiest way to do this? Is there a way to bulk delete all of the transactions and have an empty chart of accounts? Thanks Keith PS. I checked the mailing list, but I could find any recent posts. ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Best way to close unpaid invoices?
I recall the original question was how to make the open invoices disappear from the “Due Invoices Reminder” dialog. Based on the explanation below, do the open invoices still appear in the dialog? If so, how does one make them disappear? > > > -- > > Message: 7 > Date: Sun, 7 Mar 2021 16:53:56 -0600 (CST) > From: David Cousens > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Best way to close unpaid invoices? > Message-ID: <1615157636594-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > There is no need to zero out the invoice. It remains as it originally was and > the debt remains on the books. What the debt write off does is correct your > income for the amount of income you expected to but didn't receive and > adjusts the accounts receivable to reflect that you do not expect to receive > that income. > > If you cancel out the invoice and at some future time the client coughs up > the money, you will have no way of accounting for how that money was > received but a simple adjustment allows you to reverse the bad debt write > off and then record the payment against the original invoice. > > When you make a payment against an invoice normally, you do not change the > amount of the invoice, itself but you increase the amount of an asset(bank > account) and decrease the amount of the Accounts receivable (also an asset ) > by the same amount. > > The invoice creates an increase in an income account and an increase in the > Accounts receivable when it is posted to you accounts. In the case of a bad > debt you do not adjust the income but an expense account which has the same > effect on your profit. Expense accounts can be regarded as contra income > accounts. > > This way your accounts contain a record of the events as they affected your > finances at the time the events occurred. If they are annotated well enough > anyone can reconstruct the sequence of events as recorded > > David Cousens > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > > -- > > Subject: Digest Footer > > ___ > > gnucash-user mailing list > gnucash-user@gnucash.org > 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. > > > -- > > End of gnucash-user Digest, Vol 216, Issue 17 > * ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Missing Bank Interest Transactions When Importing with QFX
Hi Chris, Thanks for the help. I’ll take a look at the last bank import QFX file to see if that’s the issue. Double thanks for sharing the Java code. I’ll test it on MacOS and let you know if it works. It will be a few days before I can test it. Keith > On Apr 27, 2020, at 10:15 PM, Chris Good wrote: > > Message: 2 > Date: Mon, 27 Apr 2020 18:51:41 -0700 > From: Keith Fetterman > To: GnuCash users group > Subject: [GNC] Missing Bank Interest Transactions When Importing with > QFX > Message-ID: <5fc46e9e-f08a-4ba1-b13e-0dad30c1f...@gmail.com> > Content-Type: text/plain; charset=us-ascii > > When I import the transactions from my bank using QFX, the small interest > transactions are not appearing in the import screen? The amounts are > usually less than a $1 dollar. Does anyone know why this is? Is there a > threshold somewhere that might be filtering them out? I discovered it with > GnuCash 3.8 and 3.9 on MacOS. > > Hi Keith, > > Perhaps they are not being imported because the transaction has the same > as a previous transaction? > FITID's must be unique for each transaction in an account. > Is your bank ING? The interest transactions from ING Australia bank have > this problem. > I have a java program that I run on my .ofx file before I import into > GnuCash to fix this problem. > QFX is effectively the same as OFX I believe. > See https://github.com/goodvibes2/IngAusOfxFixLinux > Or https://github.com/goodvibes2/IngAusOfxFixWin > > Note my fix program has not been tested in MacOS but should work. > > Regards, Chris Good > ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Missing Bank Interest Transactions When Importing with QFX
When I import the transactions from my bank using QFX, the small interest transactions are not appearing in the import screen? The amounts are usually less than a $1 dollar. Does anyone know why this is? Is there a threshold somewhere that might be filtering them out? I discovered it with GnuCash 3.8 and 3.9 on MacOS. ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] Assigning TXF Category to Returns & Allowances Income Account Issue
I am assigning the tax (TXF) categories to my income and expense accounts, and I have run into an issue with assigning the tax category to my “Returns & Allowances” income account. The tax category "Schedule C Returns and Allowances” category appears for expense accounts, but not income accounts. There seems to be a mistake in GnuCash because the “Returns & Allowances” account should appear in the income section of an income statement. It appears in the income section of the IRS Schedule C form. I looked up what a “Returns & Allowances” account is, and it’s defined as a contra-revenue account. Is this a defect in Gnucash or do I have the account in the wrong place? Thanks for the help Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] How To Set Tax Report Options
Hi Alex, Thank you finding this. I dug deeper in the Gnucash help manual and found the sections that you referred to. Thanks for the clarification about the copy number. I’ve seen that used in TurboTax. It all makes sense. Keith > On Apr 4, 2020, at 11:15 AM, Alex Aycinena wrote: > > > From: Keith Fetterman <mailto:keithfetter...@gmail.com>> > To: GnuCash users group <mailto:gnucash-user@gnucash.org>> > Cc: > Bcc: > Date: Sat, 4 Apr 2020 08:33:43 -0700 > Subject: Re: [GNC] How To Set Tax Report Options > A follow up question related to using the "Tax Report Options” feature. What > are the fields “Payer Name Source” and “Copy Number” used for? > > > See "Setting Tax Report Options" in Gnucash help manual: > > "For codes for which the "Payer Name Source" is not grayed, the payer on the > TXF record will be based on what is specified here, either the account name > of the account or the account name of the account’s parent account. This > feature is typically used for interest accounts or stocks or mutual funds > that pay dividends where the individual payees are shown on the tax schedule. > For example, if the parent account’s name is the name of your broker and the > sub-account’s names are the names of individual stocks that pay dividends and > the name on the 1099-DIV received is that of the broker, in order to match > that name, you would select ’Parent Account’; the total dividends from the > broker would be exported and, if you had several brokers, there would be an > amount exported and a subtotal for each broker, along with each brokers name. > Alternatively, if you had a parent account named Directly Held, for example, > and below it sub-accounts for one or more stocks, you would receive a > 1099-DIV from the issuer of each stock separately and, in order to match that > name, you would select Current Account; the total dividends from each stock > would be exported and, if you had several stocks, there would be an amount > exported and a subtotal for each stock, along with each stock’s name as the > payer. > Some tax Forms/Schedules need to have multiple copies filed under some > circumstances (for example, Schedule C if a taxpayer and spouse have separate > businesses). For tax categories on these Forms/Schedules, the Copy Number is > not grayed out and can be used to segregate accounts by copy number." > > > Thanks > > > On Apr 4, 2020, at 8:30 AM, Keith Fetterman > <mailto:keithfetter...@gmail.com>> wrote: > > > > Is there documentation on how to set tax report options for multiple > > accounts? I am trying to set the income tax classifications (TXF > > Categories) for multiple expense and income accounts, but it doesn’t seem > > to be able to do more than one account at a time. Here is what I am doing. > > > > Set income tax identity to “Individual, Joint …” > > Select an expense account > > Click the Tax Related checkbox > > Select a TXF Category > > Select another expense account > > Click the Tax Related checkbox > > Select a TXF Category > > etc. > > > > When I return to a previous expense account, the Tax Related checkbox is > > unchecked and the TXF Category assignment is cleared. > > > > Do you have to run the “Tax Report Options” assignment separately for each > > account? By this I mean, perform the steps above for a single account then > > click the “OK” button to close the dialog? > > Unfortunately, you have to do them one-at-a-time. There is a long-standing > feature request to allow them to be done in batches but it hasn't been > implemented. At least it is just a big effort once at the beginning; once set > up, ongoing maintenance is not as onerous. Note that, as it says in the > manual,: > > "If the Income Tax features are used, it is strongly recommended that the Tax > Info column be made visible on the accounts tab (click large > downward-pointing arrow and select Tax Info check box). The Tax Info column > will display the Form/Schedule and tax category (e.g., Schedule D Dividend, > cap gain distrib.) assigned to an account, if any." > > This allows you to scan down the chart-of-accounts and see that all accounts > that should be tagged are and that those that shouldn't be aren't. > > The whole US Income Tax feature is a bit cumbersome and needs to be > re-implemented, but that is a big task. > > > > > > Thanks > > > > Keith > > > Regards, > > Alex ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] How To Set Tax Report Options
A follow up question related to using the "Tax Report Options” feature. What are the fields “Payer Name Source” and “Copy Number” used for? Thanks > On Apr 4, 2020, at 8:30 AM, Keith Fetterman wrote: > > Is there documentation on how to set tax report options for multiple > accounts? I am trying to set the income tax classifications (TXF Categories) > for multiple expense and income accounts, but it doesn’t seem to be able to > do more than one account at a time. Here is what I am doing. > > Set income tax identity to “Individual, Joint …” > Select an expense account > Click the Tax Related checkbox > Select a TXF Category > Select another expense account > Click the Tax Related checkbox > Select a TXF Category > etc. > > When I return to a previous expense account, the Tax Related checkbox is > unchecked and the TXF Category assignment is cleared. > > Do you have to run the “Tax Report Options” assignment separately for each > account? By this I mean, perform the steps above for a single account then > click the “OK” button to close the dialog? > > Thanks > > Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
[GNC] How To Set Tax Report Options
Is there documentation on how to set tax report options for multiple accounts? I am trying to set the income tax classifications (TXF Categories) for multiple expense and income accounts, but it doesn’t seem to be able to do more than one account at a time. Here is what I am doing. Set income tax identity to “Individual, Joint …” Select an expense account Click the Tax Related checkbox Select a TXF Category Select another expense account Click the Tax Related checkbox Select a TXF Category etc. When I return to a previous expense account, the Tax Related checkbox is unchecked and the TXF Category assignment is cleared. Do you have to run the “Tax Report Options” assignment separately for each account? By this I mean, perform the steps above for a single account then click the “OK” button to close the dialog? Thanks Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Printed Reports Being Cutoff
Hi David, Thanks for the feedback. I tested exporting as PDF. It has the same problem. It cut’s off account names in the same place as the printed report. Your suggestion gave me an idea. I discovered that when I export the file as an html file and print it, it does not cut off the account names. Nice. A bit more work, but I don’t print often, so no big deal. Thanks Keith > On Mar 31, 2020, at 3:00 PM, David Carlson > wrote: > > That is a well-known problem that cannot be fixed easily within the GnuCash > program. Many of us use some combination of exporting as PDF or printing to > PDF and then opening in a better quality PDF viewer and printing from there. > > David Carlson > > On Tue, Mar 31, 2020 at 4:53 PM Keith Fetterman <mailto:keithfetter...@gmail.com>> wrote: > When I print an income statement that spans multiple pages, the accounts are > getting cut off at the bottom and top of the printed pages. I experimented > with changing the scale Page Setup tab on the print dialog, but it doesn’t > help. Anyone have ideas on how to prevent the lines from being cutoff? The > reports are being printed to an Epson Artisan 730 printer from an iMac. > > Thanks > Keith > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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. > > > -- > 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 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.
[GNC] Printed Reports Being Cutoff
When I print an income statement that spans multiple pages, the accounts are getting cut off at the bottom and top of the printed pages. I experimented with changing the scale Page Setup tab on the print dialog, but it doesn’t help. Anyone have ideas on how to prevent the lines from being cutoff? The reports are being printed to an Epson Artisan 730 printer from an iMac. Thanks Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Sales Tax Report
First off, thanks everyone for responding to my post about Sales Tax Report. I really appreciate it. It’s helped a lot. Adrien, I agree that editing the invoice lines is not really option, especially since the customers receive the invoices. You could include a standardized location code on each line, but what a pain. And, if a mistake was made, the invoice would have to be unposted to change. Based on everyone’s comments, I now see that creating sub accounts for each tax table would grow considerably if there were a lot of work locations with different tax tables. Stephen’s idea of a separate database is a good idea, especially when customers have multiple locations. Your idea creating a new report using Scheme is interesting. I didn't considered that because I haven’t written custom reports before. Can you write a report using Scheme that can access invoices? Does writing a report in Scheme require GnuCash software to be built from source? > On Jan 21, 2020, at 3:22 PM, gnucash-user-requ...@gnucash.org wrote: > > > Message: 1 > Date: Tue, 21 Jan 2020 12:41:16 -0600 > From: Adrien Monteleone > To: GnuCash users group > Subject: Re: [GNC] Sales Tax Report > Message-ID: <00d6135e-d567-4933-a327-336d0192a...@lusfiber.net> > Content-Type: text/plain; charset=utf-8 > > > >> On Jan 19, 2020 w4d19, at 12:22 PM, Keith Fetterman >> wrote: >> >> Adrien, >> >> Thanks for the help. >> >> In the state of Washington, we need to report the local city/county sales >> tax for each physical location we do work in. The state assigns a tax code >> based on address. The business is a very small landscaping business that >> only does work in a few local locations, so fortunately there are not many >> tax codes to keep track of. > > My state is similar as well. I used to work for a furniture store that had to > charge and file and remit based on the point of delivery. The situation is > such a mess with local jurisdictions that three houses next to each other > could be charged three different rates because they each happen to fall in a > different jurisdiction. Politicians don?t care and just assume ?computers > make it easy." > >> >> I have created a tax table for each tax code and assigned it to a customer. >> This works because the physical work locations are the customers? homes. If >> work done in a different location, it?s almost always in the same area. >> >> I see what you mean about creating a sub account for each custom location. >> In general, this could become very large. Your suggestion of using filters >> is a good one. I hadn?t thought of it. But, it doesn?t appear that you add >> notes to the memo lines of an invoice. I tested adding a note in the >> invoice to see if it would appear in the memo line in AR. It doesn?t. The >> invoice transaction in the AR is locked so you can not edit the memo lines. >> > > Yep, special sub-accounts could grow considerably. If however, you routinely > do business in a set list of jurisdictions, it might be doable. (but I would > probably choose to learn Scheme and write the proper report as I suspect that > would be less work in the long run, and of course, ideal as you note.) > > I don?t mean to add notes to a memo line, I mean to use the Description in > each line item to include the info you need. Unfortunately, this doesn?t > always work well with how you need the invoice itself to look. Also you can?t > edit invoice memos in AR as you have discovered. (same for bills in AP) you > really shouldn?t be editing either AR/AP directly if you are using the > business features. Use the provided methods of invoice/bill/process-payment > as needed to make any changes. Think of AR/AP as special read-only registers > that show you the resulting transactions that are entered into your books by > the business features. > > Regards, > Adrien > > >> The ideal solution is a report of taxable sales by tax table. > > >> >> >> Thanks, >> Keith >> > ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Sales Tax Report
Adrien, Thanks for the help. In the state of Washington, we need to report the local city/county sales tax for each physical location we do work in. The state assigns a tax code based on address. The business is a very small landscaping business that only does work in a few local locations, so fortunately there are not many tax codes to keep track of. I have created a tax table for each tax code and assigned it to a customer. This works because the physical work locations are the customers’ homes. If work done in a different location, it’s almost always in the same area. I see what you mean about creating a sub account for each custom location. In general, this could become very large. Your suggestion of using filters is a good one. I hadn’t thought of it. But, it doesn’t appear that you add notes to the memo lines of an invoice. I tested adding a note in the invoice to see if it would appear in the memo line in AR. It doesn’t. The invoice transaction in the AR is locked so you can not edit the memo lines. The ideal solution is a report of taxable sales by tax table. Thanks, Keith > -- > > Message: 1 > Date: Sat, 18 Jan 2020 21:53:07 -0600 > From: Adrien Monteleone > To: GnuCash users group > Subject: Re: [GNC] Sales Tax Report > Message-ID: <226840b7-6eb5-4879-b1ff-e32850e5d...@lusfiber.net> > Content-Type: text/plain; charset=utf-8 > > A common method is to post sales tax lines on invoices to a ?sales tax > collected? account or something similar. > > Then when you file the reports and make the payments, you reduce the amount > still unremitted. (some books might then employ a ?sales tax due? account as > an intermediary when filing, then reduce that account when making payments) > > Reporting varies by jurisdiction of course. > > I?m most familiar (in 3 US states) with filing a report of total sales and > total taxable sales, calculating tax due on that amount, and then remitting > it. How much you actually collected is irrelevant. (UNLESS, you collected > more than you were supposed to, in which case, you had to remit what was > actually collected. A business generally can?t ?profit? off of excessive tax > charged, though they are in some locales allowed to deduct a tiny if not > infinitesimal ?vendor compensation? from the remittance) > > So for some jurisdictions at least, all that would be needed is a total > taxable sales report. Comparing that to what was charged to and collected > from customers would otherwise be an internal auditing matter to make sure > you were collecting the right amount so you don?t lose money or run afoul of > the law. > > If you need to break down sales by customer location, that can get real messy > really fast. GnuCash isn?t really set up for it out of the box. > > You might be able to employ a little extra work by putting the filter > criteria in a note or memo. That way you can run a report restricted to > matching that note or memo to aggregate sales. > > As with all such questions, seek the advice of a local CPA before embarking > on a particular bookkeeping method. > > 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 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.
[GNC] Unposting an Invoice - Reset Tax Tables Prompt
Hi, I am a newbie with GnuCash invoicing. When I unpost an invoice, I receive a prompt that says “Reset Tax Tables to Present Values?”. What happens when I answer either Yes or No? I searched the GnuCash documentation and searched the mailing list, but I wasn’t able to find an answers. I have always answered Yes, but I would like to know what happens when I answer Yes or No. Thanks Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Re: [GNC] Sales Tax Report
Christopher, Thank you. This report kinda works. It doesn’t report the tax by tax table. It only reports the tax by the sales tax liability account. But, I can make it work if I create sub accounts under the liability account for each tax table and assign the tax table entries to the appropriate sub account. Seems to be a bit of kludge, but maybe that’s how it is intended to work. I am not an accounting expert. Thanks a lot for the help. Keith > On Jan 18, 2020, at 5:35 PM, Christopher Lam > wrote: > > You may try the "Income GST Statement" report but it may not necessarily meet > your needs. > If you wish you can file an enhancement request in bugzilla. > > On Sat, 18 Jan 2020 at 22:27, Keith Fetterman <mailto:keithfetter...@gmail.com>> wrote: > Is there a report in GunCash that shows sales by tax table (tax code)? I > need to file an end of year sales tax report to the state showing the sales > by tax code. I created a tax table for each customer’s city and assigned the > entries to the customers. Now, I would like to generate a sales report based > on last year’s sales by tax table. So far, I haven’t found a report that > like this version 3.8, but I may not know what it’s called. Does it exist? > > If not, how are other people handling this common issue? > > Thanks > Keith > ___ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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 gnucash-user@gnucash.org 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.
[GNC] Sales Tax Report
Is there a report in GunCash that shows sales by tax table (tax code)? I need to file an end of year sales tax report to the state showing the sales by tax code. I created a tax table for each customer’s city and assigned the entries to the customers. Now, I would like to generate a sales report based on last year’s sales by tax table. So far, I haven’t found a report that like this version 3.8, but I may not know what it’s called. Does it exist? If not, how are other people handling this common issue? Thanks Keith ___ gnucash-user mailing list gnucash-user@gnucash.org 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.