Re: [GNC] split transaction description field length limit
That log file can also be attached to the transaction in GnuCash. Also, explore using View > Double Line as that exposes a Notes field for the entire transaction. Regards, Adrien On 3/3/24 7:08 PM, Jim DeLaHunt wrote: I suggest a workaround: write in separate log document your detailed description, with date, location, and description of work. Make a concise tag or label for each entry in the log. Put that tag or label in the GnuCash transaction record. ___ 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] Bill import csv - no lines in preview, all lines are ignored
Hello! I typically import our vendor bills every month from a csv file that I export out of a Google Sheets spreadsheet. I've essentially not had this problem in the past, but today, when I selected the csv file for import the preview window isn't showing any information. If I go ahead and start the import, I get a notification listing every row in the import as ignored, but I didn't see any specific information about why. This is a procedure I've successfully done many times, so I'm having trouble guessing what might have changed. Does anyone have any ideas? I'm on version 5.4 in Windows 11 -- Leland Webb 英会話スクール English Garden ___ 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] split transaction description field length limit
Whatever the actual character count limit is for the memo field in a transaction line, I have found the practical limit is what can be printed in reports that show that field. On the computer screen you cannot directly see anything that is after a linefeed character unless you scroll past that character since the 'window' is one line tall. I do not use business features so I don't have invoices or vendors. Another possibility would be to use spreadsheets and refer to them in the document link field. I don't remember if that is associated with individual lines or to the entire transaction. On Sun, Mar 3, 2024 at 9:13 PM Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > I suggest you put your handyman in as a vendor. Then you can create a bill > with long descriptions per item, and then pay the bill with a check. If you > want to see what was paid, right click on the payment entry in the register > and choose jump to invoice/bill. You can also run a vendor report. > > Mar 3, 2024 18:39:49 Tim via gnucash-user : > > > The descriptions that I enter in GNU cash for split items get truncated. > Is > > there a way to change this or is this a hard limit? > > > > > > > > To provide some context, I pay a handyman to work on various projects. > When > > I write the check to pay him I split the amount among the various > projects > > (which correspond to line items on his timesheet)that he worked on to > > allocated it to the different expense accounts associated with those > > projects. I like to enter a fairly long description which includes things > > like the date the work was done, the location, and a brief description of > > what was done but GNU cash truncates it when producing reports or when I > go > > back and look at data that I entered earlier. > > > > > > > > Should I be setting up an account for the handyman in which the line > items > > of his timesheet would be entered as individual transactions which add > up to > > the amount he gets paid? I get the impression that I'm probably trying to > > misuse GNU cash again as I was when I paid my credit card bills with long > > split transactions. I was able to fix that by entering the transactions > in > > an account for the credit card and then having a single transaction from > my > > bank account to pay off the credit card. I'm not adept enough at > accounting, > > to put it mildly, to know if there's something analogous I should be > doing > > in this case. Can you explain it in a way that a newbie would understand? > > > > > > > > Thank 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. > ___ > 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. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] split transaction description field length limit
I suggest you put your handyman in as a vendor. Then you can create a bill with long descriptions per item, and then pay the bill with a check. If you want to see what was paid, right click on the payment entry in the register and choose jump to invoice/bill. You can also run a vendor report. Mar 3, 2024 18:39:49 Tim via gnucash-user : > The descriptions that I enter in GNU cash for split items get truncated. Is > there a way to change this or is this a hard limit? > > > > To provide some context, I pay a handyman to work on various projects. When > I write the check to pay him I split the amount among the various projects > (which correspond to line items on his timesheet)that he worked on to > allocated it to the different expense accounts associated with those > projects. I like to enter a fairly long description which includes things > like the date the work was done, the location, and a brief description of > what was done but GNU cash truncates it when producing reports or when I go > back and look at data that I entered earlier. > > > > Should I be setting up an account for the handyman in which the line items > of his timesheet would be entered as individual transactions which add up to > the amount he gets paid? I get the impression that I'm probably trying to > misuse GNU cash again as I was when I paid my credit card bills with long > split transactions. I was able to fix that by entering the transactions in > an account for the credit card and then having a single transaction from my > bank account to pay off the credit card. I'm not adept enough at accounting, > to put it mildly, to know if there's something analogous I should be doing > in this case. Can you explain it in a way that a newbie would understand? > > > > Thank 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. smime.p7s Description: S/MIME cryptographic signature ___ 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] split transaction description field length limit
Hello, Tim: On 2024-03-03 15:39, Tim via gnucash-user wrote: The descriptions that I enter in GNU cash for split items get truncated. Is there a way to change this or is this a hard limit? I am not certain, having not looked at the GnuCash code, but in my years using the program I have not come across a way to extend the length limit of the description, memo, or notes fields. I suspect it is not changeable. To provide some context, I pay a handyman…. I like to enter a fairly long description which includes things like the date the work was done, the location, and a brief description of what was done but GNU cash truncates it…. I think it would be reasonable to respond with, GnuCash is an accounting program, and you are trying to use it for project tracking. It is reasonable for GnuCash to not attempt to be a project tracking program also. I suggest a workaround: write in separate log document your detailed description, with date, location, and description of work. Make a concise tag or label for each entry in the log. Put that tag or label in the GnuCash transaction record. Best regards, —Jim DeLaHunt ___ 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] split transaction description field length limit
The descriptions that I enter in GNU cash for split items get truncated. Is there a way to change this or is this a hard limit? To provide some context, I pay a handyman to work on various projects. When I write the check to pay him I split the amount among the various projects (which correspond to line items on his timesheet)that he worked on to allocated it to the different expense accounts associated with those projects. I like to enter a fairly long description which includes things like the date the work was done, the location, and a brief description of what was done but GNU cash truncates it when producing reports or when I go back and look at data that I entered earlier. Should I be setting up an account for the handyman in which the line items of his timesheet would be entered as individual transactions which add up to the amount he gets paid? I get the impression that I'm probably trying to misuse GNU cash again as I was when I paid my credit card bills with long split transactions. I was able to fix that by entering the transactions in an account for the credit card and then having a single transaction from my bank account to pay off the credit card. I'm not adept enough at accounting, to put it mildly, to know if there's something analogous I should be doing in this case. Can you explain it in a way that a newbie would understand? Thank 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] How can I book Sales when invoice is paid vs when posted?
On 3/3/2024 10:46 AM, Blake Hannaford wrote: Sometimes I send an invoice to a customer in year 1, but the payment is received in year 2. Gnucash always seems to credit the Income/Sales account when posted, but then my income for Year 1 taxes is overstated, and Year 2 is understated.I know you can select different accounts receivable accounts for the post but how can I not boost Sales until the invoice is paid? Thanks! Are you keeping your books on the cash basis or the accrual basis? Are you asking about how to adjust (at year end) if your intent is to be on cash basis but gnucash does not support invoices unless accrual? If you are keeping the books on (and filing taxes on) the accrual basis it is IRRELEVANT in what year the customer pays the invoice. You received the income for that sale when the order was fulfilled/customer invoiced. At that point you have a RECEIVABLE for the amount. Receivables might be sold to a FACTOR (at which point not longer relevant to YOU when the customer pays, or even if the customer pays. If any of this is not making sense to you then you need more learning about "accounting for a business". And "cash bass" vs "accrual basis". It's basics you need help with, not gnucash (or not gnucash yet). Michael D Novack -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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] How can I book Sales when invoice is paid vs when posted?
What you want is cash accounting and Gnucash is set up for accrual based accounting. In our jurisdiction certain businesses are permitted to use cash accounting for income tax (and there are, for some, advantages to doing so) but all businesses are required to use accrual accounting for sales tax. What I wind up doing is posting the invoices that span the year boundary to December 31 until I have filed the sales tax return, and then reposting them to the first of the year before generating the reports for income tax. And I do the reverse for bills received but not paid by the end of the year. Sent from my iPhone > On Mar 3, 2024, at 12:43 PM, Murugan Muruganandam > wrote: > > when you are posting the invoice, select year 2 date, then your book should > reflect it on the corresponding year > > > > > Saludos Cordiales > > > Murugan > > > From: gnucash-user > on behalf of > Blake Hannaford > Sent: Sunday, March 3, 2024 12:46 PM > To: gnucash-user@gnucash.org > Subject: [GNC] How can I book Sales when invoice is paid vs when posted? > > Sometimes I send an invoice to a customer in year 1, but the payment is > received in year 2. Gnucash always seems to credit the Income/Sales > account when posted, but then my income for Year 1 taxes is overstated, and > Year 2 is understated.I know you can select different accounts > receivable accounts for the post but how can I not boost Sales until the > invoice is paid? > > Thanks! > > -- > Blake Hannaford > -- > ___ > 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. ___ 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] How can I book Sales when invoice is paid vs when posted?
when you are posting the invoice, select year 2 date, then your book should reflect it on the corresponding year Saludos Cordiales Murugan From: gnucash-user on behalf of Blake Hannaford Sent: Sunday, March 3, 2024 12:46 PM To: gnucash-user@gnucash.org Subject: [GNC] How can I book Sales when invoice is paid vs when posted? Sometimes I send an invoice to a customer in year 1, but the payment is received in year 2. Gnucash always seems to credit the Income/Sales account when posted, but then my income for Year 1 taxes is overstated, and Year 2 is understated.I know you can select different accounts receivable accounts for the post but how can I not boost Sales until the invoice is paid? Thanks! -- Blake Hannaford -- ___ 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.
[GNC] How can I book Sales when invoice is paid vs when posted?
Sometimes I send an invoice to a customer in year 1, but the payment is received in year 2. Gnucash always seems to credit the Income/Sales account when posted, but then my income for Year 1 taxes is overstated, and Year 2 is understated.I know you can select different accounts receivable accounts for the post but how can I not boost Sales until the invoice is paid? Thanks! -- Blake Hannaford -- ___ 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] Blank reports
So, If you think it's theme related; naming the theme might help. Also, to me, the theme you choose is beyond the GnuCash scope. And you don't explicitly say, but it appears you're running GnuCash 5.5 on Fedora 39, based on the package name. As I happen to have Fedora 39 running here, I have installed GnuCash 5.5 from the software center, and get no display issues with reports. I'm using something called Adwaita mixed. ISTR that there was an issue with certain NVidia video cards and report rendering. Perhaps you should look for those threads in the list if you have such a card. David T. On Mar 3, 2024, 8:33 AM, at 8:33 AM, Daffy Duck wrote: >It's in Linux and possibly related to theme, or something. > >When I access remotely with a different windows manager, it's fine. > >Also, when I print the report, the PDF is fine. > >But ANY reports from this particular Fedora desktop, while inside >gnucash, are blank. You can only see the theme background. But >clearly the report is there because when I look at the printed PDF, >it's fine. > >On Tue, 2024-01-09 at 19:19 +1000, David H wrote: >> Probably this known Windows only bug discussed a few days ago on >> this mailing list - >> > https://lists.gnucash.org/pipermail/gnucash-user/2024-January/110256.html >> . ? >> >> >> >> On Tue, 9 Jan 2024 at 18:50, Daffy Duck >> wrote: >> > Hello, >> > >> > On and off for a while, I would get blank reports(easy invoice, >> > etc) to >> > where you couldn't see anything, but if you printed, or printed to >> > PDF, >> > it looked fine. >> > >> > Rebooting the computer seemed to fix that, but now I can't make it >> > go >> > away. >> > >> > Any ideas? >> > >> > The tab for the report just has the default gtk color background. >> > >> > gnucash-5.5-1.fc39.x86_64 >> > ___ >> > 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. ___ 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.
