Re: [GNC] Minimum window width
On Wed, 22 Jan 2020 at 04:14, Tommy Trussell wrote: > > The register window size may have improved with 3.7 or 3.8 but it still seems > pretty big to me after upgrading from 2.6.19 to 3.7 a few months ago. > With 2.6.19 I was seeing a min width of about 1000px and this went up to 1350px with 3.3. Now with 3.6 I am seeing a min width of 980, so back to about what it was on 2.6. As noted in the bug report it did vary with which accounts are open, I don't know whether that is still the case. It was which accounts were open that mattered, not which had the focus. I find it odd though that one cannot reduce the width further and have scroll bars appear. It is very unusual for an app to exhibit that behaviour in its main windows (as opposed to popups). Colin ___ 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] Unreconciling a transaction causes trouble with later reconciliation
> On 21 Jan 2020, at 22:26, Michael Hendry wrote: > > I’m using GC version 3.8 running on iMac with High Sierra, and have > encountered the following problem: > > > > I failed to record the receipt of £40 via BACS on 9th December > > On 13th December I recorded the deposit of a cheque for £40 in the same > account. > > My bank statement for the month to 16th December didn’t include the cheque > deposit (it didn’t actually reach the account until the 17th), but I > erroneously marked the cheque deposit for £40 as reconciled (instead of the > missing BACS deposit). > > The statement for the month to 16th January included the £40 cheque deposit, > but because I’d previously marked this as reconciled, it didn’t appear on the > list of unreconciled transactions. > > When I eventually realised my mistake, I unreconciled the cheque deposit and > entered the missing (9th December) transaction. > > I then re-ran the reconciliation for the 16th January, but found I was always > £40 out. > > I cancelled the reconciliation, then saved the file and shut down and > restarted Gnucash. This time the reconciliation went through without trouble. > > I’d previously come across this problem when experimenting with child > accounts of the current (checking) account used as envelopes for committed > funds - previously reconciled transactions that had been moved back to the > parent account became unreconciled and a subsequent reconciliation failed. > > It seems as though GC keeps a running total of reconciled transactions, but > fails to update this if one transaction is unreconciled, merely clearing the > reconciled flag (“y” => “n”). > > > If this can be confirmed by other users, I feel it should be recorded as a > bug. > > Regards, > > Michael PS I’ve tried (and failed) to reproduce this problem by going back to an earlier copy of my .gnucash file and retracing my steps. I’ll keep my eyes open for a recurrence, and report back if I can reproduce it. Regards, Michael ___ 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] Minimum window width
Op woensdag 22 januari 2020 10:33:51 CET schreef Colin Law: > On Wed, 22 Jan 2020 at 04:14, Tommy Trussell wrote: > > The register window size may have improved with 3.7 or 3.8 but it still > > seems pretty big to me after upgrading from 2.6.19 to 3.7 a few months > > ago. > With 2.6.19 I was seeing a min width of about 1000px and this went up > to 1350px with 3.3. Now with 3.6 I am seeing a min width of 980, so > back to about what it was on 2.6. As noted in the bug report it did > vary with which accounts are open, I don't know whether that is still > the case. It was which accounts were open that mattered, not which > had the focus. I find it odd though that one cannot reduce the width > further and have scroll bars appear. It is very unusual for an app to > exhibit that behaviour in its main windows (as opposed to popups). That's the user interface showing its age... :( Valid point though. Regards, Geert ___ 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
You don’t have to build the whole app, just your report, and then you need to tell GnuCash how to find it. (covered in the wiki) I’ve added reports others have built to a stock installation of GnuCash without issue. Note, some custom reports *might* require changes to GnuCash itself, but that would be entirely under your control in how you design the report. (you may find you’ll need to add something to the main app to make your report easier to code, but maybe not) Note, Scheme is not for the faint of heart. All of the other GnuCash reports are written in Scheme so you should be able to access anything you need. The wiki has links to get you started learning in the custom report section. If you are more familiar with Python I’d go the PieCash route, or Stephen’s route of a separate db. Regards, Adrien > On Jan 22, 2020 w4d22, at 12:50 PM, Keith Fetterman > wrote: > > 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? ___ 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, Sales Taxs & Deposits
I've been doing bookkeeping/accounting for my business for a long time, going back to the old Dome Book to present day alternatives. I have been doing trial and error recording transactions in GNU. I presently enter a deposit ex. $1080.00 of which $1000 is sales and $80 in sales tax Using a deposit split of Income:Sales 1000 and Liabilities:Sales Tax:Sales Tax Collected 80 How would you do it ? is there a better way ??? The problem I'm having is selecting the income account "sales' which shows all the sales income of the deposits but when you export to csv it shows all the splits income & tax from the deposits. I need to see only the Income sales only. Sometimes a company needs to export sales for someone outside using other spreadsheets to do trend analysis among other accounts. Thanks Jimmy -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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, Sales Taxs & Deposits
Try the income gst statement report On Thu, 23 Jan 2020, 8:52 am Jimmy R via gnucash-user, < gnucash-user@gnucash.org> wrote: > I've been doing bookkeeping/accounting for my business for a long time, > going > back to the old Dome Book to present day alternatives. I have been doing > trial and error recording transactions in GNU. > > I presently enter a deposit ex. $1080.00 of which $1000 is sales and $80 in > sales tax > Using a deposit split of Income:Sales 1000 and Liabilities:Sales Tax:Sales > Tax Collected 80 > > How would you do it ? is there a better way ??? > > The problem I'm having is selecting the income account "sales' which shows > all the sales income of the deposits but when you export to csv it shows > all > the splits income & tax from the deposits. I need to see only the Income > sales only. Sometimes a company needs to export sales for someone outside > using other spreadsheets to do trend analysis among other accounts. > > Thanks > > Jimmy > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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] Sales, Sales Taxs & Deposits
If the GST report doesn’t quite meet your needs does a Transaction Report on just the Income:Sales account work? (note, there are lots of customizations options with that report) Regards, Adrien > On Jan 22, 2020 w4d22, at 6:53 PM, Jimmy R via gnucash-user > wrote: > > I've been doing bookkeeping/accounting for my business for a long time, going > back to the old Dome Book to present day alternatives. I have been doing > trial and error recording transactions in GNU. > > I presently enter a deposit ex. $1080.00 of which $1000 is sales and $80 in > sales tax > Using a deposit split of Income:Sales 1000 and Liabilities:Sales Tax:Sales > Tax Collected 80 > > How would you do it ? is there a better way ??? > > The problem I'm having is selecting the income account "sales' which shows > all the sales income of the deposits but when you export to csv it shows all > the splits income & tax from the deposits. I need to see only the Income > sales only. Sometimes a company needs to export sales for someone outside > using other spreadsheets to do trend analysis among other accounts. > > Thanks > > Jimmy ___ 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.
