Re: [GNC] End of Year?

2024-01-13 Thread R Losey
Absolutely; there is no reason to do anything special at the end of the year; for many years, I have just kept using GnuCash and have had no issues, but some people like to make yearly archives, or do the "close the books" thing. On Sat, Jan 13, 2024 at 5:53 PM Stan Brown (using GC 4.14) <

Re: [GNC] register auto-complete

2024-01-13 Thread Adrien Monteleone
That is interesting. Is this only for Descriptions or for Memos & Notes too? *there is no preference. Bugs and kinks are being worked out though. This sounds like a bug, as I doubt that would be intended behavior. (it certainly isn't reasonable to expect, that I can see) Regards, Adrien On

[GNC] register auto-complete

2024-01-13 Thread chuck elliot
The behaviour of register auto-complete, where current transaction input is matched against previous transactions within an account, seems to have changed recently (v.5.5). It now seems to search only the active categories (unreconciled, cleared etc). I normally hide 'reconciled' and so

Re: [GNC] Maddening!!!!!!!!

2024-01-13 Thread John Layman via gnucash-user
I have not found that situation (entering a missing transaction during reconciliation) to be unusual, and GnuCash handles it quite gracefully. -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: Friday, January 12, 2024 12:44 PM To: Jack Slater Cc:

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

2024-01-13 Thread John Layman via gnucash-user
I have scheduled transactions with simple calculation. They work just fine, but only when the transactions actually fire. -Original Message- From: gnucash-user On Behalf Of David T. via gnucash-user Sent: Thursday, January 11, 2024 3:56 PM To: gnucash-user@gnucash.org Subject: [GNC]

Re: [GNC] List of fields checked by importer when matching transactions

2024-01-13 Thread Etienne Boeziek via gnucash-user
Perhaps related to your question. I did notice as I was closing last quarter that in the GNU Cash latest version something seems to have changed with the importer matching. I create my own CSV files in Python based on the export from suppliers/payments. I had to change the Transfer memo field I

Re: [GNC] End of Year?

2024-01-13 Thread Adrien Monteleone
Sorry, I would not like to see an FAQ pop up in this list on any periodic basis. What you are describing there is akin to a 'sticky' or 'pinned' post in a web forum. This is not a web forum. We have the Wiki, which has the FAQ section. We also have the Help Manual, and the Tutorial &

Re: [GNC] End of Year?

2024-01-13 Thread Adrien Monteleone
That would be the case at first glance, but see my reply up the chain concerning correcting entries and usual procedures when starting with fresh books each year. I'd hazard that with Pen & Paper, Reconciliation is *not* necessarily a function of the T-Accounts or General Journal. That is

Re: [GNC] Budget car payment

2024-01-13 Thread Adrien Monteleone
You can indeed save as CSV after opening in LibreOffice or Excel. Once it is opened, the spreadsheet app now controls what you do with it. Regards, Adrien On 1/13/24 5:27 PM, David Carlson wrote: I just tried opening a GnuCash report saved in Html format with Libre Office writer and found

Re: [GNC] End of Year?

2024-01-13 Thread Stan Brown (using GC 4.14)
With older versions of GC, it used to take a long time to open a file. With 4.14, and I presume with 5.x, it's almost instantaneous. So why is there any discussion of saving previous-year data? It seems reasonable to me to archive a file as of 12-31-20XX, because you can't have too many archives.

Re: [GNC] Budget car payment

2024-01-13 Thread David Carlson
I just tried opening a GnuCash report saved in Html format with Libre Office writer and found that it would offer to save in ODT format as soon as I tried to save anything. I am sure that it would also save in csv or other common formats. On Sat, Jan 13, 2024 at 3:14 PM Michael or Penny Novack

Re: [GNC] End of Year?

2024-01-13 Thread David Carlson
Dumb question. The original topic was about unreconncciled transactions from the pervious year. If they are not copied over to the new file wouldn't that mess up the next reconciliation? On Sat, Jan 13, 2024, 3:07 PM Liz wrote: > On Sat, 13 Jan 2024 11:19:26 -0600 > R Losey wrote: > > >

Re: [GNC] Budget car payment

2024-01-13 Thread Michael or Penny Novack
On 1/13/2024 1:34 PM, Dennis Powless wrote: Are there other options to export besides HTML? Say to excel in csv or txt? If you open an HTML document, do you know how to get the content saved as .xlsx or .cvs or .txt?  The point here is that asking the developers to add the option of adding

Re: [GNC] End of Year?

2024-01-13 Thread Liz
On Sat, 13 Jan 2024 11:19:26 -0600 R Losey wrote: > But the larger issue is that I believe this email list could benefit > from a FAQ that is posted monthly or every other month to this group. > The wiki has some neat ideas about tracking year to year equity > growth. You will need to convince

Re: [GNC] Budget car payment

2024-01-13 Thread Stan Brown (using GC 4.14)
On 2024-01-13 10:34, Dennis Powless wrote: > Are there other options to export besides HTML? Say to excel in csv or txt? Directly, no. But you can open the exported HTML file in Excel and then File » Save As a variety of formats including CSV and text. I've never done this myself, but it has

Re: [GNC] End of Year?

2024-01-13 Thread David Cousens
A section in the Tutorial and Concepts Guide may be even more appropriate and then link the FAQ to it. That then provides the option when the question comes up repeatedly in the list of just providing the link to it. David Cousens On Sat, 2024-01-13 at 11:19 -0600, R Losey wrote: > Pretty much,

Re: [GNC] Budget car payment

2024-01-13 Thread Dennis Powless
I realize that Gnucash is not a budgeting tool and I don't expect it to provide the functionality that one can get from excel or open office. So, I think I will just export the data to excel and do the budget/dashboard from there. I can get what I need from the reports quite easily in gnucash. D

Re: [GNC] Budget car payment

2024-01-13 Thread Dennis Powless
Are there other options to export besides HTML? Say to excel in csv or txt? D On Wed, Jan 10, 2024 at 2:50 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Signs in Budgets need more testing. (I had plans to do so long ago, > perhaps I might get to it now as I'm way behind in my

Re: [GNC] End of Year?

2024-01-13 Thread Fred Tydeman
On Sat, Jan 13, 2024 at 9:20 AM R Losey wrote: > I gather that the main reason for "closing" books is that on the "Accounts" > tab, one can see the year-to-date expenses and income instead of the total > since one started using GnuCash. It's a neat idea. > Another option is to use the

[GNC] QIF import ignore account

2024-01-13 Thread Fred Tydeman
GnuCash 4.14 on Linux As part of a QIF import, I have the following transaction: ^ D1/12'24 NDiv Yblue owl cap CX T122.50 Mblue owl cap LIncome:us:NoTax:Roth-F-Fid:div:blue owl cap ^ However, when I do the Import in GnuCash, it shows up as:

Re: [GNC] End of Year?

2024-01-13 Thread R Losey
Pretty much, yes, although I found it a bit weak on the note that it is not really necessary. But the larger issue is that I believe this email list could benefit from a FAQ that is posted monthly or every other month to this group. The wiki has some neat ideas about tracking year to year equity

Re: [GNC] End of Year?

2024-01-13 Thread sunfish62--- via gnucash-user
https://wiki.gnucash.org/wiki/Closing_Books Does that cover it? ⁣David T.​ On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone wrote: >You could add A2b: > >Export your Chart of Accounts and write down the ending balances as >needed. Start a new file, import your exported chart of

Re: [GNC] End of Year?

2024-01-13 Thread Phyllis Bruce
Just to clarify further, I'm referring to Adrien's A2b option above of just entering ending balances for a new year. On Sat, Jan 13, 2024 at 10:52 AM Phyllis Bruce wrote: > Thanks for the explanation. I guess it's a matter of personal > preference. If I'm starting a new file I want to be

Re: [GNC] End of Year?

2024-01-13 Thread Phyllis Bruce
Thanks for the explanation. I guess it's a matter of personal preference. If I'm starting a new file I want to be able to reconcile to my statement when it's received in 2024. It does not bother me to have uncleared items in the archived file. I could even go so far as to delete them from the

Re: [GNC] End of Year?

2024-01-13 Thread Gyle McCollam
Phyllis, If you enter unreconciled transactions again in 2024 you will have doubled counted them because they will be in 2023 and 2024. They are already accounted for in the balance. Since reconciliation is just matching what has cleared with the statement it is OK that the transactions are

Re: [GNC] End of Year?

2024-01-13 Thread Phyllis Bruce
I did mean checking/savings and credit card accounts. Thanks Since I use Gnucash for personal rather than business use, I don't "close" the books. However, if I wanted to archive 2023 and start fresh on Jan 1, 2024, I would enter any unreconciled transactions in those accounts in your A2b

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

2024-01-13 Thread Fred Bone
On 12 January 2024 at 23:36, Adrien Monteleone said: > That's moving beyond Scheduled Transactions and into a more general case > of Templates. I'm pretty sure I've already filed an RFE for that long ago. > > I see Scheduled Transactions as a special use case of Templates, though > Scheduled was

Re: [GNC] End of Year?

2024-01-13 Thread Adrien Monteleone
*ALL accounts are 'credit and debit' accounts. But perhaps you mean Checking & Credit Card accounts? (i.e., those held at a 3rd party financial institution, since you are referencing 'reconciliation'.) Reconciliation is usually done prior to a Trial Balance as part of the End of Year process

Re: [GNC] End of Year?

2024-01-13 Thread Phyllis Bruce
H, would you not also need to re-enter any unreconciled transactions in your credit and debit accounts? On Sat, Jan 13, 2024 at 7:24 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > You could add A2b: > > Export your Chart of Accounts and write down the ending balances as >

Re: [GNC] End of Year?

2024-01-13 Thread Adrien Monteleone
You could add A2b: Export your Chart of Accounts and write down the ending balances as needed. Start a new file, import your exported chart of accounts and set opening balances to the old ending balances. This method is more like Pen & Paper days in that each file only contains one period

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

2024-01-13 Thread Adrien Monteleone
Not general templates, no. It only has scheduled transactions. There is a request for templates. Regards, Adrien On 1/12/24 11:56 PM, R Losey wrote: I'm sensing a learning opportunity here... GnuCash has templates? I never noticed that; I only use the templates in the Scheduled Transaction

Re: [GNC] List of fields checked by importer when matching transactions

2024-01-13 Thread GNUCash via gnucash-user
John, Yes the description had to match the tranfer memo. To clarify. In my transaction CSV I had 3 rows belonging to 1 transaction. Description on all 3 rows: “Order 1234” Receivables and deposit rows where identical in all fields (memo, transfer memo, description). But the third row contained