Re: [GNC] Trail balance Imbalance / multi-currency transaction
I should have added, there’s nothing in any imbalance accounts. On Sat, 18 Nov 2023 at 04:17, David Kirkby wrote: > When I run a trial balance, right at the bottom the sums are given. The > one on the left is £7 higher than the one on the right. I believe I know > the source of this problem, but can't seem to get rid of it. > > I'm in the UK, but sold something to a customer who wanted to pay in > Euros. The item was sold at 500 Euros. The bank converted €500 to > £427.76, took a £7 fee, and deposited £420.76 into the account. > > Unfortunately, when entering the transaction into GnuCash, I created a > split and put the £7 bank fee into Expense -> Bank Charges. The result is > that £7 is accounted for twice. I'm show it as an expense, but the bank > statement has already taken this into account. > > No matter what I do, I can't seem to get rid of this £7 issue. I unposted > the invoice, and then deleted the transaction. This removes £420.76 from > the bank account and removes the £7 from the bank charges. But if I run a > trial balance, there's still a £7 difference. > > I've tried Actions -> Check and Repair -> Check and Repair All. That does > not help. > > I know £7 is not a lot, but it is annoying me. I would like to try to > solve the problem. > > -- > Dr David Kirkby Ph.D > Kirkby Microwave Ltd > Email: drkir...@kirkbymicrowave.co.uk > Web: https://www.kirkbymicrowave.co.uk/ > Telephone 07910 441670 (UK) or +44 7910 441670 (international) > Registered in England and Wales, company number 08914892. > Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT > > > ___ 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] Trail balance Imbalance / multi-currency transaction
David The transactions splits should have been recorded as follows: Income:Sales Cr 427.67 Bank Account Dr 420.67 Expense:Fees Dr 7.00 David Cousens On Sat, 2023-11-18 at 04:17 +, David Kirkby wrote: > When I run a trial balance, right at the bottom the sums are given. The one > on the left is £7 higher than the one on the right. I believe I know the > source of this problem, but can't seem to get rid of it. > > I'm in the UK, but sold something to a customer who wanted to pay in Euros. > The item was sold at 500 Euros. The bank converted €500 to £427.76, took a > £7 fee, and deposited £420.76 into the account. > > Unfortunately, when entering the transaction into GnuCash, I created a > split and put the £7 bank fee into Expense -> Bank Charges. The result is > that £7 is accounted for twice. I'm show it as an expense, but the bank > statement has already taken this into account. > > No matter what I do, I can't seem to get rid of this £7 issue. I unposted > the invoice, and then deleted the transaction. This removes £420.76 from > the bank account and removes the £7 from the bank charges. But if I run a > trial balance, there's still a £7 difference. > > I've tried Actions -> Check and Repair -> Check and Repair All. That does > not help. > > I know £7 is not a lot, but it is annoying me. I would like to try to solve > the problem. > ___ 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] Trail balance Imbalance / multi-currency transaction
When I run a trial balance, right at the bottom the sums are given. The one on the left is £7 higher than the one on the right. I believe I know the source of this problem, but can't seem to get rid of it. I'm in the UK, but sold something to a customer who wanted to pay in Euros. The item was sold at 500 Euros. The bank converted €500 to £427.76, took a £7 fee, and deposited £420.76 into the account. Unfortunately, when entering the transaction into GnuCash, I created a split and put the £7 bank fee into Expense -> Bank Charges. The result is that £7 is accounted for twice. I'm show it as an expense, but the bank statement has already taken this into account. No matter what I do, I can't seem to get rid of this £7 issue. I unposted the invoice, and then deleted the transaction. This removes £420.76 from the bank account and removes the £7 from the bank charges. But if I run a trial balance, there's still a £7 difference. I've tried Actions -> Check and Repair -> Check and Repair All. That does not help. I know £7 is not a lot, but it is annoying me. I would like to try to solve the problem. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ 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] budget reports 'YTD' vs 'use accumulated amounts'
On Friday, November 17, 2023 1:53:38 PM CST larry johnston wrote: > I got as far as upgrading to GC 4.14 and was planning to use the Use > Accumulated Amounts report but I could not find it. Do I have to upgrade to > ver 5 or am I not looking in the correct place? I don't know where you've looked, but in the Budget Report options, on the General tab, there is a checkbox labelled 'Use accumulated amounts'. Is that what you're looking for? When checked the accumulated amount budgeted over all periods up to the that period is shown. When unchecked only the amount budgeted for that period is shown. ___ 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] Import Multi-split transactions from CSV
> On Nov 17, 2023, at 10:38 PM, john wrote: > > > >> On Nov 17, 2023, at 16:48, Sherman Yoder wrote: >> >> What am I >> doing wrong? > > Total speculation, but perhaps using "notes" instead of "memo" for the CSV's > Memo field. Notes is a per-transaction field while Memo is per-split. > > Regards, > John Ralls Yes, that’s what it was. Thanks so much for the help! Sherman > ___ 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] budget reports 'YTD' vs 'use accumulated amounts'
I'm not familiar with such a report name. I'm on 5.4 and it does not exist. Regards, Adrien On 11/17/23 1:53 PM, larry johnston wrote: Hi, I got as far as upgrading to GC 4.14 and was planning to use the Use Accumulated Amounts report but I could not find it. Do I have to upgrade to ver 5 or am I not looking in the correct place? ___ 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] Import Multi-split transactions from CSV
> On Nov 17, 2023, at 16:48, Sherman Yoder wrote: > > What am I > doing wrong? Total speculation, but perhaps using "notes" instead of "memo" for the CSV's Memo field. Notes is a per-transaction field while Memo is per-split. Regards, John Ralls ___ 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] budget reports 'YTD' vs 'use accumulated amounts'
Hi, I got as far as upgrading to GC 4.14 and was planning to use the Use Accumulated Amounts report but I could not find it. Do I have to upgrade to ver 5 or am I not looking in the correct place? TIA, Larry On Wed, Jul 19, 2023 at 1:31 PM larry johnston wrote: > Hi, > > Yes, I was thinking of starting over with 5.3. If I could import the Chart > of Accounts from 2.6.15 that would be great. > > Larry > > On Wed, Jul 19, 2023, 11:17 a.m. Stan Brown (using GC 2.6.19) < > stan+gnuc...@fastmail.fm> wrote: > >> On 2023-07-19 09:25, Adrien Monteleone wrote: >> > On 7/18/23 1:07 PM, larry johnston wrote: >> >> Will 2.6.15 run on Windows 11? Can it still be downloaded? >> > >> > First a direct answer: >> > >> > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with >> > Win11 can try installing it to see and report back. (best I have is >> > access to Win10) >> >> I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't >> imagine 2.6.15 would be any different. >> >> (I've been very short of time for months, and haven't had time to follow >> through on my intention to move to 5.x.) >> >> Stan Brown >> Tehachapi, CA, USA >> https://BrownMath.com >> ___ >> 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] Help pages not showing
> On Nov 17, 2023, at 9:06 AM, Stephen Cohoon wrote: > > When I access the help button on the account edit window or from the help | > contents menu I get a blank window. Running Flathub 5.4.1 on Pop!_OS 22.04 > LTS Linux. Is this a known problem? Not to me, and it works correctly for me on Debian 12. Regards, John Ralls ___ 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] Help pages not showing
When I access the help button on the account edit window or from the help | contents menu I get a blank window. Running Flathub 5.4.1 on Pop!_OS 22.04 LTS Linux. Is this a known problem? -Stephen -- Stephen Cohoon smcoh...@gmail.com If there's a problem that can't be solved with a clever program, is that problem really worth solving? ___ 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] Adjusting column width on Gnucash
That file is the metadata file, see "books/.gcm" in https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_DATA_HOME. One could also edit that file--it's plain text in .ini format--to set the column widths to what you like. Regards, John Ralls > On Nov 17, 2023, at 08:01, R Losey wrote: > > Another possibility would be to shut down Gnucash, find the file that > stores these kind of preferences, and delete it. Presumably, GnuCash would > come up with the standard settings... but this may affect too many other > items to be a valid option but as a last chance if you cannot get to > just the right pixel... > > On Fri, Nov 17, 2023 at 3:10 AM Maf. King wrote: > >> Hello Olaide, >> >> Welcome to the list. >> >> In brief, you need to be very precise with your mouse and manage to drag >> the >> right-hand side of the credit column to the right to make it more than 0 >> pixels wide. It can be a very difficut thing to actually do, though. >> >> see: >> >> https://www.gnucash.org/docs/v5/C/gnucash-guide//chapter_txns.html#txns-columnwidths1 >> >> and also a tip if the mouse can't be precise enough here: >> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns. >> 3F_Why_can_I_not_shrink_the_description_column.3F >> >> good luck, >> Maf. >> >> On Thursday, 16 November 2023 14:49:34 GMT olaide olowu wrote: >>> Good day, >>> >>> Hope this mail finds you well? >>> >>> I appreciate Gnucash software, it has assisted me in my day to day >>> accounting duties. >>> >>> Please I currently have an issue with the column width adjustment on >>> Gnucash. I tried to adjust the credit column of the journal but it >>> inadvertently closed up and I was unable to readjust it back to its >> visible >>> state. The credit column is not visible to view the figures I have >> posted. >>> >>> Please assist with the possible best solution on how this can be >> rectified. >>> >>> Anticipating your swift response. >>> >>> 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. >> > > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > 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] Adjusting column width on Gnucash
Another possibility would be to shut down Gnucash, find the file that stores these kind of preferences, and delete it. Presumably, GnuCash would come up with the standard settings... but this may affect too many other items to be a valid option but as a last chance if you cannot get to just the right pixel... On Fri, Nov 17, 2023 at 3:10 AM Maf. King wrote: > Hello Olaide, > > Welcome to the list. > > In brief, you need to be very precise with your mouse and manage to drag > the > right-hand side of the credit column to the right to make it more than 0 > pixels wide. It can be a very difficut thing to actually do, though. > > see: > > https://www.gnucash.org/docs/v5/C/gnucash-guide//chapter_txns.html#txns-columnwidths1 > > and also a tip if the mouse can't be precise enough here: > https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns. > 3F_Why_can_I_not_shrink_the_description_column.3F > > good luck, > Maf. > > On Thursday, 16 November 2023 14:49:34 GMT olaide olowu wrote: > > Good day, > > > > Hope this mail finds you well? > > > > I appreciate Gnucash software, it has assisted me in my day to day > > accounting duties. > > > > Please I currently have an issue with the column width adjustment on > > Gnucash. I tried to adjust the credit column of the journal but it > > inadvertently closed up and I was unable to readjust it back to its > visible > > state. The credit column is not visible to view the figures I have > posted. > > > > Please assist with the possible best solution on how this can be > rectified. > > > > Anticipating your swift response. > > > > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Adjusting column width on Gnucash
Hello Olaide, Welcome to the list. In brief, you need to be very precise with your mouse and manage to drag the right-hand side of the credit column to the right to make it more than 0 pixels wide. It can be a very difficut thing to actually do, though. see: https://www.gnucash.org/docs/v5/C/gnucash-guide//chapter_txns.html#txns-columnwidths1 and also a tip if the mouse can't be precise enough here: https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns. 3F_Why_can_I_not_shrink_the_description_column.3F good luck, Maf. On Thursday, 16 November 2023 14:49:34 GMT olaide olowu wrote: > Good day, > > Hope this mail finds you well? > > I appreciate Gnucash software, it has assisted me in my day to day > accounting duties. > > Please I currently have an issue with the column width adjustment on > Gnucash. I tried to adjust the credit column of the journal but it > inadvertently closed up and I was unable to readjust it back to its visible > state. The credit column is not visible to view the figures I have posted. > > Please assist with the possible best solution on how this can be rectified. > > Anticipating your swift response. > > 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.
Re: [GNC] linking pre-existing assets with liabilities
You are a man after my own heart Stan, 95% of the questions asked aren't relevant to me, but I like watching the solutions appear and store them away in my memory for later use. Many times such information is useful in a completely unrelated situation. G On Fri, 17 Nov 2023 at 00:58, Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > Thanks very much for posting your solution. That will be helpful for > future people who have a similar question. And even for folks like me > who may not need it right now, still it's interesting! > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > > On 2023-11-16 16:39, AP wrote: > > On Fri, Nov 17, 2023 at 11:19:01AM +1100, AP wrote: > >> I am importing my bank statements into my bank Assets account in > gnucash. I > >> would like to link those withdrawals with bills I have created in my > A/Payable > >> Liabilities account. > >> > >> The hassle is when I hit pay it creates a manual entry for me. I don't > want > >> that. I would like to link that to the entry generated from my bank > import > >> that corresponds to the payment that was made. > >> > >> Is there a way to do this so that I can remove the "unpaid" tag from > the bill > >> and keep the accounts appropriately balanced? > > > > As it turns out, once again, I find my answer right after asking. For > anyone else > > here it is: > > > > Go to the withdrawal, right click and select "Assign as payment..." > > > > One downside is that it changes the description of the field to the > company name > > and puts the old description into the memo field. If you want to keep > the description > > the bank gave remember to copy the memo field and then paste into the > desc. > ___ > 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.
