Re: [GNC] Reconciliation with a strange opening balance
Another good idea. I went back to the start and sorted by Description, but nothing out of the ordinary. As we might expect the majority of entries are withdrawals, so the deposits are easier to see. Also, sorted by description sorts out if you put down the credit card payments or the pub expenditures in the wrong place!! Ho hum. Thanks for the suggestion. Barry On 15/11/2023 23:37, Liz wrote: On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. liz ___ 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] linking pre-existing assets with liabilities
Hi, My searching is failing me so I thought I'd ask. 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? Thanks, Andrew ___ 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
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. AP ___ 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
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.
Re: [GNC] linking pre-existing assets with liabilities
Glad you found your answer, and thanks for reporting back that you did! That's an odd bug with regards to the Description/Memo fields. I recall an existing bug about the Notes/Memo fields but didn't realize this affected the Description also. If you find that existing bug, maybe make a comment about this new facet, and/or file an additional bug. From what I recall, the Notes field and the first 'assigned' Memo field always end up duplicated for some reason and the Notes are not otherwise editable even after the fact. Such data should not change in these cases. Regards, Adrien On 11/16/23 6:39 PM, AP wrote: 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.
[GNC] Adjusting column width on Gnucash
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.
