Re: [GNC] Entry of unknown transaction

[Jeff]

On 2/4/23 11:46 AM, David Carlson wrote:
I have occasionally found a stray deposit receipt near an ATM when I 
was withdrawing cash.  If I carelessly pocketed it with my receipt, I 
might get a surprise later. The stray would have a different account 
number on it.  Could this be what happened to you?


On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry 
 wrote:


On 4 Feb 2023, at 11:58, Jeff  wrote:

>
> I have discovered several transactions that show up in one
account but do not show up in any other existing account.
Regardless of what the bank image shows of where the check was
deposited.
>
> I.E.  I have a deposit slip that shows it went to our checking
account but never showed up there  (OFX or printed mailed
statement).  I can not reconcile it so how do  handle it?
>
> In other words, I have half of a double entry transaction.  More
than one, unfortunately.
>
> --
> --JEffrey Black M.B.A.

Not entirely sure what you mean, Jeffrey.

Are the transactions you refer to recorded in GNUCash as money
paid into your account but without a recorded source account? This
should have a corresponding entry in the Imbalance account,
automatically created when you put in an unbalanced transaction.

Did you receive a check which you deposited in your checking
account and for which your received a receipt from the bank in the
form of a date-stamp on the deposit slip, but for which there is
no record in the bank statement (paper or electronic)?

If yes, then you need to take that up with the bank - was the
check bounced?

When you’re reconciling, you’re matching up the bank’s view of the
world with your own, and can only mark as reconciled the
transactions which appear in both.

Michael


___
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



Easiest example that I can remember off the top of my head is, my wife 
recently wrote a check from her business account (her weeks wages) and 
deposited it directly into our personal account.  The OFX import, and 
statement, from our bank show it but there is no matching transaction in 
the business account.  Our statement has an image of the check plain as 
day but there is no match, period, in her business account 
statement(s).  And what really has me bumfuzzled is both sets of books 
are reconciled per their respective statements.  And it's not just one 
transaction involved, there are multiples.  That check did not bounce, 
it just seemingly like magic appeared in our account out of thin air. 
Magic money.



For now I have the check recorded as a deposit to our account and 
withdrawal from Imbalance-USD.  Just wanted to get your input on if that 
is the best way to handle transactions like that.


Her PayPal dealings are even worse but; that is for a different thread.

--
--JEffrey Black M.B.A.
___
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] GnuCash 4.901 Released

[Glenn Fowler]

Hi,

Would you like for me to open the issues?


On Sun, Feb 5, 2023 at 11:07 PM john  wrote:

> Neither of which seem to be in the bug tracker.
>
> Regards,
> John Ralls
>
>
> On Feb 5, 2023, at 7:54 PM, Glenn Fowler  wrote:
>
> Thank you to the team for the continued development!
>
> I just installed 4.901 on W10 and just pointing out two bugs still persist
> from 4.900:
>
> 1. Tip of the day cannot be suppressed
> 2. Keyboard shortcut for "Manage Document Link" is still missing
>
> Thank you
>
> On Sun, Feb 5, 2023 at 2:51 PM John Ralls  wrote:
>
> The GnuCash development team announces GnuCash 4.901, the second unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
> New Features
>
>• A new Stock Transaction Assistant to guide you through entering
> most investment transactions for stocks, bonds, and mutual funds. You can
> access it from Actions>Stock Assistant when you have the Accounts page ora
> Stock or Fund account register open.
>• A new Investment Lots report showing a graph of capital gains
> and losses in a period by investment lot. Note that if you don't use the
> View Lots dialog to manage capital gains and losses this report won't have
> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
> see the report.
>• A new tab on the New/Edit Account dialog called More Properties
> includes entries to set a high and low limit on an account. That's coupled
> to a new column that's available on the Accounts Page, Balance Limit. If
> you set a high or low limit and the account balance falls above or below
> the respective limit an indicator will be shown in the Balance Limit
> column.
>• The description field quickfill in the register now displays a
> drop-down list of possible completions instead of just one inline
> completion.
>• File import menu items for the MT940, MT942, and DTAUS formats
> is replaced with a single Import from AQBanking that supports importing any
> file format supported by AQBanking, including the frequently requested
> CAMT.
>• The report generated by the Print Invoice button on the Edit
> Invoice tab can now be configured as a book option at teh bottom of the
> Business tab; this permits selecting a saved configuration of one of the
> standard invoice reports. Another option enables a delay, during which a
> dialog box will appear enabling the user to select a different report.
>
> Note: When saving a configuration make sure that the invoice number is not
> set or you'll get that particular invoice instead of the one that you
> pressed the button for.
>
> Between 4.900 and 4.901, the following bugfixes were accomplished:
>
> The following fixes will also appear in GnuCash 4.14:
>• Bug 797477 - Manual foreign transaction from APAR to another
> doesn't trigger price input
>• Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
>• Bug 798734 - Aging Reports don't handle mixed currency payments
> and invoices without Trading Accounts
>• Bug 798737 - Minor grammatical error - 'for' missing in 'You
> will be asked a conversion rate for each.'
>• Bug 798740 - Build fails with gcc 13
>• Bug 798747 - Crash in Investment Portfolio report
>
> The following additional bug fixes are in unstable only:
>
>• Bug 753307 - Custom Report be selectable as default Report for
> Printing
> Change the preference in Business->'Report for Printing' to be saved as a
> book property and allow the selection of any Invoice Report to be used as
> the default.
>
>• Bug 794028 - CSV import, default to matching full account name
> If the account map doesn't yield a result, try to map the import string
> against existing accounts' full names
>
>• Bug 796955 - Import CSV - Single-line two-currency transactions
> can't be imported
>• Use a provided price if the transfer account uses a
> different commodity from the base account's; apply it as transfer amount =
> base amount * price.
>• Add a transfer amount column option to avoid the
> rounding that might arise from having an inexact price.
>• Bug 797756 - Currency format setting is ignored
>• Bug 798292 - csv Import Transactions Ignores Multi-Splits
>• Bug 798475 - GNCAccountSel could have shortcuts
>• Bug 798730 - Open report doesn't remember selected accounts over
> restart
>• Bug 798739 - Advanced Portfolio report fails
> The following fixes and improvements were not associated with bug reports:
>
>• Move the Balance Sheet P Report out of experimental into
> regular menu.
>• Rename the Deposit and Withdrawal column labels in the CSV
> import assistant to Amount and Amount(Negated) for clarity when importing
> into something other than a bank account.
>• Improve muti-currency invoice 

Re: [GNC] GnuCash 4.901 Released

[john]

Neither of which seem to be in the bug tracker.

Regards,
John Ralls


> On Feb 5, 2023, at 7:54 PM, Glenn Fowler  wrote:
> 
> Thank you to the team for the continued development!
> 
> I just installed 4.901 on W10 and just pointing out two bugs still persist
> from 4.900:
> 
> 1. Tip of the day cannot be suppressed
> 2. Keyboard shortcut for "Manage Document Link" is still missing
> 
> Thank you
> 
> On Sun, Feb 5, 2023 at 2:51 PM John Ralls  > wrote:
> 
>> The GnuCash development team announces GnuCash 4.901, the second unstable
>> release leading to GnuCash 5.0.
>> 
>> This is an unstable release for testing purposes. Do not use it with
>> production data! Make a copy of your book to test this release.
>> 
>> New Features
>> 
>>• A new Stock Transaction Assistant to guide you through entering
>> most investment transactions for stocks, bonds, and mutual funds. You can
>> access it from Actions>Stock Assistant when you have the Accounts page ora
>> Stock or Fund account register open.
>>• A new Investment Lots report showing a graph of capital gains
>> and losses in a period by investment lot. Note that if you don't use the
>> View Lots dialog to manage capital gains and losses this report won't have
>> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
>> see the report.
>>• A new tab on the New/Edit Account dialog called More Properties
>> includes entries to set a high and low limit on an account. That's coupled
>> to a new column that's available on the Accounts Page, Balance Limit. If
>> you set a high or low limit and the account balance falls above or below
>> the respective limit an indicator will be shown in the Balance Limit column.
>>• The description field quickfill in the register now displays a
>> drop-down list of possible completions instead of just one inline
>> completion.
>>• File import menu items for the MT940, MT942, and DTAUS formats
>> is replaced with a single Import from AQBanking that supports importing any
>> file format supported by AQBanking, including the frequently requested CAMT.
>>• The report generated by the Print Invoice button on the Edit
>> Invoice tab can now be configured as a book option at teh bottom of the
>> Business tab; this permits selecting a saved configuration of one of the
>> standard invoice reports. Another option enables a delay, during which a
>> dialog box will appear enabling the user to select a different report.
>> 
>> Note: When saving a configuration make sure that the invoice number is not
>> set or you'll get that particular invoice instead of the one that you
>> pressed the button for.
>> 
>> Between 4.900 and 4.901, the following bugfixes were accomplished:
>> 
>> The following fixes will also appear in GnuCash 4.14:
>>• Bug 797477 - Manual foreign transaction from APAR to another
>> doesn't trigger price input
>>• Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
>>• Bug 798734 - Aging Reports don't handle mixed currency payments
>> and invoices without Trading Accounts
>>• Bug 798737 - Minor grammatical error - 'for' missing in 'You
>> will be asked a conversion rate for each.'
>>• Bug 798740 - Build fails with gcc 13
>>• Bug 798747 - Crash in Investment Portfolio report
>> 
>> The following additional bug fixes are in unstable only:
>> 
>>• Bug 753307 - Custom Report be selectable as default Report for
>> Printing
>> Change the preference in Business->'Report for Printing' to be saved as a
>> book property and allow the selection of any Invoice Report to be used as
>> the default.
>> 
>>• Bug 794028 - CSV import, default to matching full account name
>> If the account map doesn't yield a result, try to map the import string
>> against existing accounts' full names
>> 
>>• Bug 796955 - Import CSV - Single-line two-currency transactions
>> can't be imported
>>• Use a provided price if the transfer account uses a
>> different commodity from the base account's; apply it as transfer amount =
>> base amount * price.
>>• Add a transfer amount column option to avoid the
>> rounding that might arise from having an inexact price.
>>• Bug 797756 - Currency format setting is ignored
>>• Bug 798292 - csv Import Transactions Ignores Multi-Splits
>>• Bug 798475 - GNCAccountSel could have shortcuts
>>• Bug 798730 - Open report doesn't remember selected accounts over
>> restart
>>• Bug 798739 - Advanced Portfolio report fails
>> The following fixes and improvements were not associated with bug reports:
>> 
>>• Move the Balance Sheet P Report out of experimental into
>> regular menu.
>>• Rename the Deposit and Withdrawal column labels in the CSV
>> import assistant to Amount and Amount(Negated) for clarity when importing
>> into something other than a bank account.
>>• Improve 

Re: [GNC] GnuCash 4.901 Released

[Glenn Fowler]

Thank you to the team for the continued development!

I just installed 4.901 on W10 and just pointing out two bugs still persist
from 4.900:

1. Tip of the day cannot be suppressed
2. Keyboard shortcut for "Manage Document Link" is still missing

Thank you

On Sun, Feb 5, 2023 at 2:51 PM John Ralls  wrote:

> The GnuCash development team announces GnuCash 4.901, the second unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
> New Features
>
> • A new Stock Transaction Assistant to guide you through entering
> most investment transactions for stocks, bonds, and mutual funds. You can
> access it from Actions>Stock Assistant when you have the Accounts page ora
> Stock or Fund account register open.
> • A new Investment Lots report showing a graph of capital gains
> and losses in a period by investment lot. Note that if you don't use the
> View Lots dialog to manage capital gains and losses this report won't have
> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
> see the report.
> • A new tab on the New/Edit Account dialog called More Properties
> includes entries to set a high and low limit on an account. That's coupled
> to a new column that's available on the Accounts Page, Balance Limit. If
> you set a high or low limit and the account balance falls above or below
> the respective limit an indicator will be shown in the Balance Limit column.
> • The description field quickfill in the register now displays a
> drop-down list of possible completions instead of just one inline
> completion.
> • File import menu items for the MT940, MT942, and DTAUS formats
> is replaced with a single Import from AQBanking that supports importing any
> file format supported by AQBanking, including the frequently requested CAMT.
> • The report generated by the Print Invoice button on the Edit
> Invoice tab can now be configured as a book option at teh bottom of the
> Business tab; this permits selecting a saved configuration of one of the
> standard invoice reports. Another option enables a delay, during which a
> dialog box will appear enabling the user to select a different report.
>
> Note: When saving a configuration make sure that the invoice number is not
> set or you'll get that particular invoice instead of the one that you
> pressed the button for.
>
> Between 4.900 and 4.901, the following bugfixes were accomplished:
>
> The following fixes will also appear in GnuCash 4.14:
> • Bug 797477 - Manual foreign transaction from APAR to another
> doesn't trigger price input
> • Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
> • Bug 798734 - Aging Reports don't handle mixed currency payments
> and invoices without Trading Accounts
> • Bug 798737 - Minor grammatical error - 'for' missing in 'You
> will be asked a conversion rate for each.'
> • Bug 798740 - Build fails with gcc 13
> • Bug 798747 - Crash in Investment Portfolio report
>
> The following additional bug fixes are in unstable only:
>
> • Bug 753307 - Custom Report be selectable as default Report for
> Printing
> Change the preference in Business->'Report for Printing' to be saved as a
> book property and allow the selection of any Invoice Report to be used as
> the default.
>
> • Bug 794028 - CSV import, default to matching full account name
> If the account map doesn't yield a result, try to map the import string
> against existing accounts' full names
>
> • Bug 796955 - Import CSV - Single-line two-currency transactions
> can't be imported
> • Use a provided price if the transfer account uses a
> different commodity from the base account's; apply it as transfer amount =
> base amount * price.
> • Add a transfer amount column option to avoid the
> rounding that might arise from having an inexact price.
> • Bug 797756 - Currency format setting is ignored
> • Bug 798292 - csv Import Transactions Ignores Multi-Splits
> • Bug 798475 - GNCAccountSel could have shortcuts
> • Bug 798730 - Open report doesn't remember selected accounts over
> restart
> • Bug 798739 - Advanced Portfolio report fails
> The following fixes and improvements were not associated with bug reports:
>
> • Move the Balance Sheet P Report out of experimental into
> regular menu.
> • Rename the Deposit and Withdrawal column labels in the CSV
> import assistant to Amount and Amount(Negated) for clarity when importing
> into something other than a bank account.
> • Improve muti-currency invoice payment:
> • Show proper amount in dialog when applying or editing an
> existing transaction as payment.
> • Be more careful not to waste the existing payment split
> • If the 

Re: [GNC] Entered Date, UX Question

[ml]

Thank you! 

Yeah, the more I’ve been thinking about this and researching what Quicken does, 
I think it makes more sense to have the `entered_date` be the timestamp the 
transaction is imported.

Where I’m finding I still have to investigate, discuss and ponder is that 
Quicken has a Date field, and a Posted field (in addition to the Entered). In 
may data, there are a few times where the technical Posted date is the 30th or 
31st of the month, but I will change it to be the 1st of the following month 
because that is when I want it recorded. 

GnuCash, afaik, only has posted and entered for the dates. Entered we’ve 
already discussed.

I’m leaning toward testing the equality of the Date and Posted for each 
transaction coming from Quicken. If they are equal, easy. If not, I’ll take the 
Date field since it means the user probably wanted to override the Posted date 
for some reason. 

I could then add the Posted date to the memo/notes. Would that be useful or 
just clutter things up? 

> On Feb 5, 2023, at 13:11, R. Victor Klassen  wrote:
> 
> For the business features there is the entered date and the posted date, and 
> they may differ in either direction.  That way I can enter something in 
> January, but post in last December because it really belonged then, but I 
> hadn’t gotten to it, and it shows up correctly under the rules accrual based 
> accounting.  And I can fake it by posting it to the first of January if it is 
> paid in January and I’m using cash based accounting for tax purposes.   In 
> this case I could see having the entered date the date of import, so long as 
> the posted date is the date I had set when I posted it.  Not sure what 
> Quicken does here or allows me to do (been well over a decade).
> 
> If I just enter the transaction directly in a register and I want to get it 
> connected to the right date for cash or accrual basis, I want the date that 
> appears to be in the register to match what it was when I put it in.  Because 
> to me that is the posted date. 
> If GnuCash has a separate entered date for all transactions (and I think it 
> does), and that date is not visible (except for when probing the database 
> directly), I would be happy to have the entered date be the imported date, so 
> long as the posted date isn’t mucked with.  But that’s just my two cents.
> 
>> On Feb 4, 2023, at 8:00 AM, m...@tgr66.me wrote:
>> 
>> Hello!
>> 
>> I’m writing an app to help people migrate to GnuCash (primarily from 
>> Quicken, in my case Quicken for Mac), and I’m using PieCash to write sqlite3 
>> file. I’ve read/searched the docs, and so I believe I understand the concept 
>> of a transaction entry date into an accounting system, and that users 
>> generally won’t ever see it, or perhaps I should just say “edit it”.
>> 
>> I’ve realized that I can export entered dates from Quicken, and so here is 
>> my question.
>> 
>> As a user of GnuCash, if you were to migrate data from another system, would 
>> you expect the entry/entered date to be when you migrated the data or when 
>> you first entered it into your personal financial management system?
>> 
>> I know some of you are experts in the field of accounting AIS, and so I 
>> welcome your thoughts too. If, one of the two approaches *must* be followed 
>> because of accounting rule (especially for businesses), please let me know.
>> 
>> Thank you for your help.
>> 
>> Tim
>> ___
>> 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] gnucash

[David Cousens]

Bob,

Try this https://wiki.gnucash.org/wiki/RedHat.  I don't know how out of date the
wiki is and I'm not a RHEL user. If the repositories don't have a recent enough
version, you can always build it from scratch
https://wiki.gnucash.org/wiki/Building_On_Linux. 

David Cousens

On Sun, 2023-02-05 at 16:07 -0600, Robert L Sisk wrote:
> Is it possible to install Gnucash into Red Hat 9.1? I cannot figure out 
> how to do. It finally installed using flatpak, but when opened it is 
> unreadable.
> 
> Thanks
> 
> Bob
> 
> ___
> 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] Demo accounts

[flywire]

> What I'm looking for is a set of demo accounts.

Have another look at the GnuCash Tutorial and Concepts Guide. You could do
something to work with that data and extend it to using csv.

Example data (
https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj
) based on GnuCash Tutorial and Concepts Guide Part II. Managing Personal
Finances. The csv import works better if you import the accounts first.
___
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] gnucash

[Robert L Sisk]

Is it possible to install Gnucash into Red Hat 9.1? I cannot figure out 
how to do. It finally installed using flatpak, but when opened it is 
unreadable.


Thanks

Bob

___
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] Demo accounts

[Michelle]

Thanks very much all.

I managed to use the CSV import, as suggested, to import CSV files with
spurious values, but good enough to make it look like a basic set of
accounts for an individual... at least good enough to show the reports
I wanted.

Michelle.

On Sun, 2023-02-05 at 14:20 -0500, R. Victor Klassen wrote:
> I would start by exporting some of your own stuff to .csv
> 
> That will tell you what the native GNUCash csv input format looks
> like.
> 
> Now you can go to a spreadsheet and create transactions to your
> heart’s content using dates that are based on formulae (like every 14
> days put in the same transaction). and so on.
> Save that to csv, and import it into a brand new file.
> 
> > On Feb 5, 2023, at 6:05 AM, Michelle  wrote:
> > 
> > This is going to be a bit of an odd question, but hey ho.
> > 
> > I have a very small channel and would like to make a small video
> > about
> > GnuCash and reporting insights for the average home user.
> > 
> > What I'm looking for is a set of demo accounts.
> > 
> > Nothing serious, just a bank account and a credit card, showing
> > wages
> > coming into the bank account monthly, the credit card being paid
> > off
> > monthly, and a series of transactions on the credit card, like
> > supermarket, cd, dvd, fuel, that sort of thing... covering maybe
> > five
> > years with some simple categories to cover the spending.
> > 
> > So, nothing complicated like interest or multiple currencies, or
> > anything like that.
> > 
> > Is there something out there please, or something I can do to make
> > creation a bit easier?
> > 
> > Many thanks,
> > 
> > Michelle.
> > 
> > ___
> > 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] Credit/Debit vs Withdrwal/Deposit

[Michael or Penny Novack]

On 2/5/2023 4:05 PM, Robert Heller wrote:

I believe this is a function of the account type.  "Bank" accounts get the
Withdrawal and Deposit labels, and others get labeled the Debit and Credit (I
think credit [card] accounts get labeled with Charge and Payment).

At Sun, 5 Feb 2023 15:50:18 -0500 King Mak  wrote:


For some, the "user friendly" labels will be easier than the formal 
accounting labels "debit" and "credit".



But if not, if these sometimes confuse you (changing as they do 
depending on "type" of account, you can always ask gnucash to use the 
formal labels. Then all you have to remember is the sense of the account 
(assets have sense debit, liabilities and equity sense credit; temporary 
accounts of type expense and income are debit and credit respectively). 
If a transaction amount is the same sense as the account, it is 
increasing, if opposite then decreasing.



Michael D Novack


___
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] Credit/Debit vs Withdrwal/Deposit

[David H]

Depends on account type but check your Prefs >> Accounts >> Use formal
accounting labels setting - try toggling it off and on.

Cheers David H.


On Mon, 6 Feb 2023 at 06:51, King Mak  wrote:

> Good day,
>
> How does one change the word Debit and Credit to Withdrawal and Deposit?
>
> Thank you
>
> --
> *Dr. Polycarpe N. Makinga*
> MD., Dip Obst., Dip HIV Man., Adv Cert Health Mangt., MPH., MMed (FamMed)
> Mobile: +1 438 2278912
> Fax: +27 86 512 4653
> ___
> 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] Credit/Debit vs Withdrwal/Deposit

[Robert Heller]

I believe this is a function of the account type.  "Bank" accounts get the 
Withdrawal and Deposit labels, and others get labeled the Debit and Credit (I 
think credit [card] accounts get labeled with Charge and Payment).

At Sun, 5 Feb 2023 15:50:18 -0500 King Mak  wrote:

> 
> Good day,
> 
> How does one change the word Debit and Credit to Withdrawal and Deposit?
> 
> Thank you
> 

-- 
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
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] Credit/Debit vs Withdrwal/Deposit

[Stan Brown (using GC 2.6.19)]

That depends.

To you, your bank account is an asset. Debits increase assets and
credits reduce them, so a deposit is a debit and a withdrawal is a
credit -- to you.

To the bank, your account is a liability: money that they are holding
but do not own and must one day repay. Debits decrease liabilities and
credits increase them, so a withdrawal is a debit and a deposit is a
credit -- to the bank.

It's similar with credit-card accounts, by the way, except that the
situation is reversed: the account balance is a liability to you and an
asset to the bank. So a "credit", for instance when you make a payment
or return an item, is indeed a credit to the bank (because it reduces an
asset) but it's a debit to you (because it reduces a liability). A
"charge" or "debit" increases your account balance and therefore is a
debit to the bank but a credit to you.

Debits increase Assets and Expenses; credits reduce them.
Debits reduce liabilities, equity,and income; credits increase them.

I'm pretty sure there's a longer explanation in the Tutorial and
Concepts manual, but that's the short version.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-02-05 12:50, King Mak wrote:
> Good day,
> 
> How does one change the word Debit and Credit to Withdrawal and Deposit?
> 
> 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.

[GNC] Credit/Debit vs Withdrwal/Deposit

[King Mak]

Good day,

How does one change the word Debit and Credit to Withdrawal and Deposit?

Thank you

-- 
*Dr. Polycarpe N. Makinga*
MD., Dip Obst., Dip HIV Man., Adv Cert Health Mangt., MPH., MMed (FamMed)
Mobile: +1 438 2278912
Fax: +27 86 512 4653
___
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] Huge number of missing transactions

[Phyllis Bruce]

Has anyone suggested that you look back at older log files and recover from
one that is more complete?  What's gone today may not have been gone last
month.  Just saying

On Sun, Feb 5, 2023 at 9:42 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 2/5/2023 4:26 AM, David T. via gnucash-user wrote:
> > I'll briefly chime in here to suggest that network issues and potential
> simultaneous access are more likely culprits for your data corruption and
> loss.
> >
> I will second that. Gnucash does NOT support multiple simultaneous
> users. It does support multiple sequential users but if used that way
> the message "could not obtain lock" has to be treated very seriously. A
> single user can override this and proceed anyway, but if there is ANY
> chance a different user is accessing the data cannot do that.
>
> For a program to support multiple simultaneous users it must be running
> UNDER the control of a DBM (database manager) program. In which case the
> simultaneous users might not even be using the same program to access
> the database (as long as all such programs are running under the control
> of the DBM). Back in my working days maintained apps running under DB2
> (a DBM for mainframe SQL).
>
> So in a case like this, multiple users and the data on a network drive,
> that is overwhelmingly likely the problem. Unless you can definitely
> rule out simultaneous access issues, look no farther. No point in trying
> to analyze the details of what happened to the data because the
> consequences of simultaneous access are unpredictable.
>
>
> Michael D Novack
>
>
>
>
> ___
> 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] [GNC-dev] GnuCash 4.901 Released

[John Ralls]

BTW, www.gnucash.org isn't accepting changes so the announcement isn't visible 
there and the unstable download link remains at 4.900.

Corrected Github Links:
https://github.com/Gnucash/gnucash/releases/download/4.901/gnucash-4.901.setup.exe
https://github.com/Gnucash/gnucash/releases/download/4.901/Gnucash-Intel-4.901-1.dmg

Regards,
John Ralls


> On Feb 5, 2023, at 11:51 AM, John Ralls  wrote:
> 
> The GnuCash development team announces GnuCash 4.901, the second unstable 
> release leading to GnuCash 5.0.
> 
> This is an unstable release for testing purposes. Do not use it with 
> production data! Make a copy of your book to test this release. 
> 
> New Features
> 
>   • A new Stock Transaction Assistant to guide you through entering most 
> investment transactions for stocks, bonds, and mutual funds. You can access 
> it from Actions>Stock Assistant when you have the Accounts page ora Stock or 
> Fund account register open.
>   • A new Investment Lots report showing a graph of capital gains and 
> losses in a period by investment lot. Note that if you don't use the View 
> Lots dialog to manage capital gains and losses this report won't have 
> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to see 
> the report.
>   • A new tab on the New/Edit Account dialog called More Properties 
> includes entries to set a high and low limit on an account. That's coupled to 
> a new column that's available on the Accounts Page, Balance Limit. If you set 
> a high or low limit and the account balance falls above or below the 
> respective limit an indicator will be shown in the Balance Limit column.
>   • The description field quickfill in the register now displays a 
> drop-down list of possible completions instead of just one inline completion.
>   • File import menu items for the MT940, MT942, and DTAUS formats is 
> replaced with a single Import from AQBanking that supports importing any file 
> format supported by AQBanking, including the frequently requested CAMT.
>   • The report generated by the Print Invoice button on the Edit Invoice 
> tab can now be configured as a book option at teh bottom of the Business tab; 
> this permits selecting a saved configuration of one of the standard invoice 
> reports. Another option enables a delay, during which a dialog box will 
> appear enabling the user to select a different report.
> 
> Note: When saving a configuration make sure that the invoice number is not 
> set or you'll get that particular invoice instead of the one that you pressed 
> the button for.
> 
> Between 4.900 and 4.901, the following bugfixes were accomplished:
> 
> The following fixes will also appear in GnuCash 4.14:
>   • Bug 797477 - Manual foreign transaction from APAR to another doesn't 
> trigger price input
>   • Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
>   • Bug 798734 - Aging Reports don't handle mixed currency payments and 
> invoices without Trading Accounts
>   • Bug 798737 - Minor grammatical error - 'for' missing in 'You will be 
> asked a conversion rate for each.'
>   • Bug 798740 - Build fails with gcc 13
>   • Bug 798747 - Crash in Investment Portfolio report
> 
> The following additional bug fixes are in unstable only:
> 
>   • Bug 753307 - Custom Report be selectable as default Report for 
> Printing
> Change the preference in Business->'Report for Printing' to be saved as a 
> book property and allow the selection of any Invoice Report to be used as the 
> default. 
> 
>   • Bug 794028 - CSV import, default to matching full account name
> If the account map doesn't yield a result, try to map the import string 
> against existing accounts' full names 
> 
>   • Bug 796955 - Import CSV - Single-line two-currency transactions can't 
> be imported
>   • Use a provided price if the transfer account uses a different 
> commodity from the base account's; apply it as transfer amount = base amount 
> * price.
>   • Add a transfer amount column option to avoid the rounding 
> that might arise from having an inexact price.
>   • Bug 797756 - Currency format setting is ignored
>   • Bug 798292 - csv Import Transactions Ignores Multi-Splits
>   • Bug 798475 - GNCAccountSel could have shortcuts
>   • Bug 798730 - Open report doesn't remember selected accounts over 
> restart
>   • Bug 798739 - Advanced Portfolio report fails
> The following fixes and improvements were not associated with bug reports:
> 
>   • Move the Balance Sheet P Report out of experimental into regular 
> menu.
>   • Rename the Deposit and Withdrawal column labels in the CSV import 
> assistant to Amount and Amount(Negated) for clarity when importing into 
> something other than a bank account.
>   • Improve muti-currency invoice payment:
>   • Show proper amount in dialog when applying or editing an 
> existing transaction as payment.
>   

Re: [GNC] [GNC-dev] GnuCash 4.901 Released

[David H]

Thanks John,

Will give it a shot later.  GitHub links don't seem to be working for me,
SourceForge is ok.

Cheers David H.


On Mon, 6 Feb 2023 at 05:51, John Ralls  wrote:

> The GnuCash development team announces GnuCash 4.901, the second unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
> New Features
>
> • A new Stock Transaction Assistant to guide you through entering
> most investment transactions for stocks, bonds, and mutual funds. You can
> access it from Actions>Stock Assistant when you have the Accounts page ora
> Stock or Fund account register open.
> • A new Investment Lots report showing a graph of capital gains
> and losses in a period by investment lot. Note that if you don't use the
> View Lots dialog to manage capital gains and losses this report won't have
> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
> see the report.
> • A new tab on the New/Edit Account dialog called More Properties
> includes entries to set a high and low limit on an account. That's coupled
> to a new column that's available on the Accounts Page, Balance Limit. If
> you set a high or low limit and the account balance falls above or below
> the respective limit an indicator will be shown in the Balance Limit column.
> • The description field quickfill in the register now displays a
> drop-down list of possible completions instead of just one inline
> completion.
> • File import menu items for the MT940, MT942, and DTAUS formats
> is replaced with a single Import from AQBanking that supports importing any
> file format supported by AQBanking, including the frequently requested CAMT.
> • The report generated by the Print Invoice button on the Edit
> Invoice tab can now be configured as a book option at teh bottom of the
> Business tab; this permits selecting a saved configuration of one of the
> standard invoice reports. Another option enables a delay, during which a
> dialog box will appear enabling the user to select a different report.
>
> Note: When saving a configuration make sure that the invoice number is not
> set or you'll get that particular invoice instead of the one that you
> pressed the button for.
>
> Between 4.900 and 4.901, the following bugfixes were accomplished:
>
> The following fixes will also appear in GnuCash 4.14:
> • Bug 797477 - Manual foreign transaction from APAR to another
> doesn't trigger price input
> • Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
> • Bug 798734 - Aging Reports don't handle mixed currency payments
> and invoices without Trading Accounts
> • Bug 798737 - Minor grammatical error - 'for' missing in 'You
> will be asked a conversion rate for each.'
> • Bug 798740 - Build fails with gcc 13
> • Bug 798747 - Crash in Investment Portfolio report
>
> The following additional bug fixes are in unstable only:
>
> • Bug 753307 - Custom Report be selectable as default Report for
> Printing
> Change the preference in Business->'Report for Printing' to be saved as a
> book property and allow the selection of any Invoice Report to be used as
> the default.
>
> • Bug 794028 - CSV import, default to matching full account name
> If the account map doesn't yield a result, try to map the import string
> against existing accounts' full names
>
> • Bug 796955 - Import CSV - Single-line two-currency transactions
> can't be imported
> • Use a provided price if the transfer account uses a
> different commodity from the base account's; apply it as transfer amount =
> base amount * price.
> • Add a transfer amount column option to avoid the
> rounding that might arise from having an inexact price.
> • Bug 797756 - Currency format setting is ignored
> • Bug 798292 - csv Import Transactions Ignores Multi-Splits
> • Bug 798475 - GNCAccountSel could have shortcuts
> • Bug 798730 - Open report doesn't remember selected accounts over
> restart
> • Bug 798739 - Advanced Portfolio report fails
> The following fixes and improvements were not associated with bug reports:
>
> • Move the Balance Sheet P Report out of experimental into
> regular menu.
> • Rename the Deposit and Withdrawal column labels in the CSV
> import assistant to Amount and Amount(Negated) for clarity when importing
> into something other than a bank account.
> • Improve muti-currency invoice payment:
> • Show proper amount in dialog when applying or editing an
> existing transaction as payment.
> • Be more careful not to waste the existing payment split
> • If the user changed the payment amount while starting
> from an existing transaction unreconcile the changed payment split
> • 

[GNC] GnuCash 4.901 Released

[John Ralls]

The GnuCash development team announces GnuCash 4.901, the second unstable 
release leading to GnuCash 5.0.

This is an unstable release for testing purposes. Do not use it with production 
data! Make a copy of your book to test this release. 

New Features

• A new Stock Transaction Assistant to guide you through entering most 
investment transactions for stocks, bonds, and mutual funds. You can access it 
from Actions>Stock Assistant when you have the Accounts page ora Stock or Fund 
account register open.
• A new Investment Lots report showing a graph of capital gains and 
losses in a period by investment lot. Note that if you don't use the View Lots 
dialog to manage capital gains and losses this report won't have anything to 
show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
• A new tab on the New/Edit Account dialog called More Properties 
includes entries to set a high and low limit on an account. That's coupled to a 
new column that's available on the Accounts Page, Balance Limit. If you set a 
high or low limit and the account balance falls above or below the respective 
limit an indicator will be shown in the Balance Limit column.
• The description field quickfill in the register now displays a 
drop-down list of possible completions instead of just one inline completion.
• File import menu items for the MT940, MT942, and DTAUS formats is 
replaced with a single Import from AQBanking that supports importing any file 
format supported by AQBanking, including the frequently requested CAMT.
• The report generated by the Print Invoice button on the Edit Invoice 
tab can now be configured as a book option at teh bottom of the Business tab; 
this permits selecting a saved configuration of one of the standard invoice 
reports. Another option enables a delay, during which a dialog box will appear 
enabling the user to select a different report.

Note: When saving a configuration make sure that the invoice number is not set 
or you'll get that particular invoice instead of the one that you pressed the 
button for.

Between 4.900 and 4.901, the following bugfixes were accomplished:

The following fixes will also appear in GnuCash 4.14:
• Bug 797477 - Manual foreign transaction from APAR to another doesn't 
trigger price input
• Bug 797725 - Untranslatable string "For Period Covering ~a to ~a"
• Bug 798734 - Aging Reports don't handle mixed currency payments and 
invoices without Trading Accounts
• Bug 798737 - Minor grammatical error - 'for' missing in 'You will be 
asked a conversion rate for each.'
• Bug 798740 - Build fails with gcc 13
• Bug 798747 - Crash in Investment Portfolio report

The following additional bug fixes are in unstable only:

• Bug 753307 - Custom Report be selectable as default Report for 
Printing
Change the preference in Business->'Report for Printing' to be saved as a book 
property and allow the selection of any Invoice Report to be used as the 
default. 

• Bug 794028 - CSV import, default to matching full account name
If the account map doesn't yield a result, try to map the import string against 
existing accounts' full names 

• Bug 796955 - Import CSV - Single-line two-currency transactions can't 
be imported
• Use a provided price if the transfer account uses a different 
commodity from the base account's; apply it as transfer amount = base amount * 
price.
• Add a transfer amount column option to avoid the rounding 
that might arise from having an inexact price.
• Bug 797756 - Currency format setting is ignored
• Bug 798292 - csv Import Transactions Ignores Multi-Splits
• Bug 798475 - GNCAccountSel could have shortcuts
• Bug 798730 - Open report doesn't remember selected accounts over 
restart
• Bug 798739 - Advanced Portfolio report fails
The following fixes and improvements were not associated with bug reports:

• Move the Balance Sheet P Report out of experimental into regular 
menu.
• Rename the Deposit and Withdrawal column labels in the CSV import 
assistant to Amount and Amount(Negated) for clarity when importing into 
something other than a bank account.
• Improve muti-currency invoice payment:
• Show proper amount in dialog when applying or editing an 
existing transaction as payment.
• Be more careful not to waste the existing payment split
• If the user changed the payment amount while starting from an 
existing transaction unreconcile the changed payment split
• Avoid needlessly changing transaction currency (only do so if 
the user chose a new transfer account and the old currency is neither the new 
transfer account's currency nor the post account's currency) Payment dialog - 
always list all possible post accounts instead of only those in the currency of 

Re: [GNC] Demo accounts

[R. Victor Klassen]

I would start by exporting some of your own stuff to .csv

That will tell you what the native GNUCash csv input format looks like.

Now you can go to a spreadsheet and create transactions to your heart’s content 
using dates that are based on formulae (like every 14 days put in the same 
transaction). and so on.
Save that to csv, and import it into a brand new file.

> On Feb 5, 2023, at 6:05 AM, Michelle  wrote:
> 
> This is going to be a bit of an odd question, but hey ho.
> 
> I have a very small channel and would like to make a small video about
> GnuCash and reporting insights for the average home user.
> 
> What I'm looking for is a set of demo accounts.
> 
> Nothing serious, just a bank account and a credit card, showing wages
> coming into the bank account monthly, the credit card being paid off
> monthly, and a series of transactions on the credit card, like
> supermarket, cd, dvd, fuel, that sort of thing... covering maybe five
> years with some simple categories to cover the spending.
> 
> So, nothing complicated like interest or multiple currencies, or
> anything like that.
> 
> Is there something out there please, or something I can do to make
> creation a bit easier?
> 
> Many thanks,
> 
> Michelle.
> 
> ___
> 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] Entered Date, UX Question

[R. Victor Klassen]

For the business features there is the entered date and the posted date, and 
they may differ in either direction.  That way I can enter something in 
January, but post in last December because it really belonged then, but I 
hadn’t gotten to it, and it shows up correctly under the rules accrual based 
accounting.  And I can fake it by posting it to the first of January if it is 
paid in January and I’m using cash based accounting for tax purposes.   In this 
case I could see having the entered date the date of import, so long as the 
posted date is the date I had set when I posted it.  Not sure what Quicken does 
here or allows me to do (been well over a decade).

If I just enter the transaction directly in a register and I want to get it 
connected to the right date for cash or accrual basis, I want the date that 
appears to be in the register to match what it was when I put it in.  Because 
to me that is the posted date. 
If GnuCash has a separate entered date for all transactions (and I think it 
does), and that date is not visible (except for when probing the database 
directly), I would be happy to have the entered date be the imported date, so 
long as the posted date isn’t mucked with.  But that’s just my two cents.

> On Feb 4, 2023, at 8:00 AM, m...@tgr66.me wrote:
> 
> Hello!
> 
> I’m writing an app to help people migrate to GnuCash (primarily from Quicken, 
> in my case Quicken for Mac), and I’m using PieCash to write sqlite3 file. 
> I’ve read/searched the docs, and so I believe I understand the concept of a 
> transaction entry date into an accounting system, and that users generally 
> won’t ever see it, or perhaps I should just say “edit it”.
> 
> I’ve realized that I can export entered dates from Quicken, and so here is my 
> question.
> 
> As a user of GnuCash, if you were to migrate data from another system, would 
> you expect the entry/entered date to be when you migrated the data or when 
> you first entered it into your personal financial management system?
> 
> I know some of you are experts in the field of accounting AIS, and so I 
> welcome your thoughts too. If, one of the two approaches *must* be followed 
> because of accounting rule (especially for businesses), please let me know.
> 
> Thank you for your help.
> 
> Tim
> ___
> 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] Demo accounts

[Murugan Muruganandam]

Michelle 

Create a new gnu file and follow the assistant steps and choose common accounts 
, this should give you the basics 


Regard

Murugan


> On 05-02-2023, at 08:16, Michelle  wrote:
> 
> This is going to be a bit of an odd question, but hey ho.
> 
> I have a very small channel and would like to make a small video about
> GnuCash and reporting insights for the average home user.
> 
> What I'm looking for is a set of demo accounts.
> 
> Nothing serious, just a bank account and a credit card, showing wages
> coming into the bank account monthly, the credit card being paid off
> monthly, and a series of transactions on the credit card, like
> supermarket, cd, dvd, fuel, that sort of thing... covering maybe five
> years with some simple categories to cover the spending.
> 
> So, nothing complicated like interest or multiple currencies, or
> anything like that.
> 
> Is there something out there please, or something I can do to make
> creation a bit easier?
> 
> Many thanks,
> 
> Michelle.
> 
> ___
> 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] Adding new accounts

[Gyle McCollam]

Sorry, I apparently only replied to Ken in my initial response instead of to 
"Reply All".

Thank you all!  I didn't think it was the setting "View>Filter By>{“Other” 
tab]>Show unused accounts" or "View->Filter By..->Other->Show Zero Total 
Accounts" as when it didn't seem to add the account, I tried again.  On the 
second attempt, I did not get the error message that the account already 
existed.  I did get that message after reinstalling the software, so you were 
right that may have been prt of the issue.  I notice that even the subaccount 
indicator does not show up when the subaccounts are zero or not used.  I 
appreciate all the suggestions and happy to be running again.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Ken Farley 
Sent: Sunday, February 5, 2023 11:17 AM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Adding new accounts

I've done this very thing to myself in the past. Turns out I wanted to
stop seeing a bunch of zero value accounts and didn't make them
"hidden", but instead unclicked the


View->Filter By..->Other->Show Zero Total Accounts checkbox.


Since new accounts have a zero balance, voila (or maybe un-voila?) they
disappear as soon as they're created. What fun.
___
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] Adding new accounts

[Gyle McCollam]

Thank you all!  I didn't think it was the setting "View>Filter By>{“Other” 
tab]>Show unused accounts" or "View->Filter By..->Other->Show Zero Total 
Accounts" as when it didn't seem to add the account, I tried again.  On the 
second attempt, I did not get the error message that the account already 
existed.  I did get that message after reinstalling the software, so you were 
right that may have been prt of the issue.  I notice that even the subaccount 
indicator does not show up when the subaccounts are zero or not used.  I 
appreciate all the suggestions and happy to be running again.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Ken Farley 
Sent: Sunday, February 5, 2023 11:17 AM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Adding new accounts

I've done this very thing to myself in the past. Turns out I wanted to
stop seeing a bunch of zero value accounts and didn't make them
"hidden", but instead unclicked the


View->Filter By..->Other->Show Zero Total Accounts checkbox.


Since new accounts have a zero balance, voila (or maybe un-voila?) they
disappear as soon as they're created. What fun.
___
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] Adding new accounts

[Ken Farley]

I've done this very thing to myself in the past. Turns out I wanted to 
stop seeing a bunch of zero value accounts and didn't make them 
"hidden", but instead unclicked the



View->Filter By..->Other->Show Zero Total Accounts checkbox.


Since new accounts have a zero balance, voila (or maybe un-voila?) they 
disappear as soon as they're created. What fun.

___
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] Huge number of missing transactions

[Michael or Penny Novack]

On 2/5/2023 4:26 AM, David T. via gnucash-user wrote:

I'll briefly chime in here to suggest that network issues and potential 
simultaneous access are more likely culprits for your data corruption and loss.

I will second that. Gnucash does NOT support multiple simultaneous 
users. It does support multiple sequential users but if used that way 
the message "could not obtain lock" has to be treated very seriously. A 
single user can override this and proceed anyway, but if there is ANY 
chance a different user is accessing the data cannot do that.


For a program to support multiple simultaneous users it must be running 
UNDER the control of a DBM (database manager) program. In which case the 
simultaneous users might not even be using the same program to access 
the database (as long as all such programs are running under the control 
of the DBM). Back in my working days maintained apps running under DB2 
(a DBM for mainframe SQL).


So in a case like this, multiple users and the data on a network drive, 
that is overwhelmingly likely the problem. Unless you can definitely 
rule out simultaneous access issues, look no farther. No point in trying 
to analyze the details of what happened to the data because the 
consequences of simultaneous access are unpredictable.



Michael D Novack




___
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] Demo accounts

[Stephen]

Just a suggestion - Using the Gnucash Tutorial and Concepts Guide one 
can build step-by-step a sample file beginning with "Putting It All 
Together" on page 28 (v4). I think this file, though not for a 5 year 
period, could suffice to give you examples of the types of transactions 
you're talking about. One could always add more transactions to include 
a longer span of time. I've referred back to the Tutorial countless 
times to refresh my memory.


On 2/5/2023 5:05 AM, Michelle wrote:

This is going to be a bit of an odd question, but hey ho.

I have a very small channel and would like to make a small video about
GnuCash and reporting insights for the average home user.

What I'm looking for is a set of demo accounts.

Nothing serious, just a bank account and a credit card, showing wages
coming into the bank account monthly, the credit card being paid off
monthly, and a series of transactions on the credit card, like
supermarket, cd, dvd, fuel, that sort of thing... covering maybe five
years with some simple categories to cover the spending.

So, nothing complicated like interest or multiple currencies, or
anything like that.

Is there something out there please, or something I can do to make
creation a bit easier?

Many thanks,

Michelle.

___
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] Demo accounts

[Michelle]

This is going to be a bit of an odd question, but hey ho.

I have a very small channel and would like to make a small video about
GnuCash and reporting insights for the average home user.

What I'm looking for is a set of demo accounts.

Nothing serious, just a bank account and a credit card, showing wages
coming into the bank account monthly, the credit card being paid off
monthly, and a series of transactions on the credit card, like
supermarket, cd, dvd, fuel, that sort of thing... covering maybe five
years with some simple categories to cover the spending.

So, nothing complicated like interest or multiple currencies, or
anything like that.

Is there something out there please, or something I can do to make
creation a bit easier?

Many thanks,

Michelle.

___
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] Can one add notes / memos / whatever to reconciled transactions?

[Maf. King]

On Sunday, 5 February 2023 09:37:44 GMT Dr. David Kirkby wrote:
> On Sun, 5 Feb 2023 at 04:45, Phyllis Bruce  wrote:
> > What happens when you try it?  As far as I know, there is nothing to
> > prevent it.
> 
> I could not edit it - no error message or anything, but could not be edited.

Hi Dave, 

there is a warning dialog box that you may have suppressed (somewhat 
inadvertently)

I think it is along the lines of "warning: you are attepmting to change a 
reconciled transaction.  Are You Sure?"

with an option to never allow a change and never show the warning again.

Have a tinker with Actions -> reset warnings.

HTH,
Maf.



___
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] Can one add notes / memos / whatever to reconciled transactions?

[Dr. David Kirkby]

On Sun, 5 Feb 2023 at 04:45, Phyllis Bruce  wrote:

> What happens when you try it?  As far as I know, there is nothing to
> prevent it.


I could not edit it - no error message or anything, but could not be edited.


Dave
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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] Huge number of missing transactions

[David T. via gnucash-user]

I'll briefly chime in here to suggest that network issues and potential 
simultaneous access are more likely culprits for your data corruption and loss. 

A search for compatibility issues between GnuCash versions 3.6 and 4.11 did not 
yield any specific changes that would result in the loss of swathes of 
transactions from one version to the other, although access to the same file 
from different major versions isn't really a great idea regardless. 

In all my years of using GnuCash (18 and counting), I haven't heard of any 
documented examples of transaction loss that didn't ultimately have some other 
explanation (hardware failure, user error, unsupported uses, etc.). 

The only remotely-related problem I've personally encountered over the years 
was that at one time (around version 3.1 or so), one of my saved reports kept 
causing the saved reports file to truncate arbitrarily, leaving me without many 
saved reports. I ended up creating my saved reports from scratch, which 
eliminated the problem. But again, that wasn't accounting data; it was the 
supporting reports file. 

David T. 



On Feb 5, 2023, 2:44 AM, at 2:44 AM, Daine Pearson via gnucash-user 
 wrote:
>Sadly, no.. those help docs are pretty basic - I have looked at most of
>
>what can be found in the various docs and generally searching.
>I'll probably need to go to the code repository and look for comments
>or 
>something along those lines.
>
>Still would be good to at least confirm that our actions of accessing 
>the data file with two app versions was the issue.
>It was a pretty devastating number of transactions.
>
>Thanks!
>
>On 2/3/2023 9:11 PM, David H wrote:
>>
>https://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F
>> https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html
>>
>> Might give you an explanation of the log files...
>>
>> Cheers David H.
>>
>> On Sat, 4 Feb 2023 at 10:01, Daine Pearson via gnucash-user 
>>  wrote:
>>
>>
>> Hi all,
>>
>> I do see a few messages spread over the years about similar
>issues
>> but
>> most have gone unanswered so I thought I'd create a new one.
>>
>> My partner and I have been jointly using GNUcash for a few years.
>The
>> XML data files reside on a shared network drive.
>> I recently installed a new Win 10 computer and installed the
>> latest (at
>> the time) 4.11.
>> I did not think about the fact that her system was still running
>> 3.6 -
>> Probably the culprit...
>> Everything seems to have been going fine but yesterday she
>noticed
>> all
>> the payments into a credit card account were gone, leaving quite
>a
>> large
>> negative balance. I looked further and discovered this was true
>> for many
>> accounts but I do not believe any accounts were missing or
>> completely empty.
>> I went into the shared directory and could easily see by the file
>> size
>> that a large data reduction recently occurred as the size
>suddenly
>> drops
>> from ~900KB to ~600KB.
>> There is also a 17MB (136325 lines) log file in that same time
>period.
>> Not so much had happened in the few days after that file size
>drop
>> so I
>> exported some new transactions that had been manually entered in
>the
>> (corrupted) file and saved one of the earlier files as the new
>> data file.
>> I updated both machines to the latest stable 4.13 build, imported
>> those
>> new transactions and just for kicks, ran the repair function
>which
>> did
>> not throw any messages so presumably nothing was fixed.
>> Things seem to be fine but it occurred to me that it would be
>> useful if
>> I understood better what the log files actually might reveal and
>> if they
>> also show actions taken by the program?
>> It seems pretty clear that each new transaction generates a log
>entry
>> but I'm unsure how deletions, moved items, etc., are marked in
>the
>> logs.
>> I'm guessing the letters in the 'mod' column between Start & End
>mean
>> something but not sure what.
>>
>> I presume and hope that something about managing and saving the
>same
>> data file under both versions is what caused the mishap but it
>> would be
>> good to understand the situation better so all thoughts welcome.
>>
>> And presuming sharing files between different program version is
>a
>> danger (which it likely is), I guess it would be helpful if
>> opening an
>> account file would trigger a cancel message if it was last saved
>by a
>> different version, particularly a newer version.
>>
>> Thanks... DP
>> ___
>> 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