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 the
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 Edi
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 (y
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
> nee
*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 a
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
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 exampl
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 no
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
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 able
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 account
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 g
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:
Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-
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 "Total(Per
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
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
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,
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 bee
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 m
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 ex
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:
>
> > Bu
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
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.
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 that
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 some
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 & Concep
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 be
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] Te
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: gnucash-user@gnuca
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 th
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
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) <
stan...
32 matches
Mail list logo
