Re: [GNC] Question about OFX imports

[Kalpesh Patel]

I do see a good reason to do so, at least in my use case. 

I am imagining case where if I were to download good number of transfers 
transactions  (I do so for last three months in a moving window fashion through 
CSV, QIF and OFX imports), I could end up needing to touch many other accounts, 
possibly ones that were already reconciled after import would entail needless 
download again, and then re-imports again  for those accounts, especially now 
that description can be appended from two sides of import of a transaction. 
Since CSV and QIF already permits reimport and reconciliation window, having 
the same capabilities on OFX/QFX would make the behavior consistent amongst 
three heavily used import methods in the States. I do not see any adverse 
effect from permitting it. If it finds same FITID, permit to update, update and 
reconcile existing one or just reconcile existing one. Just a thought

-Original Message-
From: Jean Laroche  
Sent: Monday, May 13, 2024 6:19 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Question about OFX imports

Also, you definitely would not want to double-import the same transaction, so 
there isn't a good reason to want to mock with the FITID. What *could* be 
useful (but in extremely rare cases) would be to force a re-import of the same 
transaction despite the fact that it's been imported previous, while avoiding a 
duplication (i.e. the second import would update the existing transaction 
instead of being skipped altogether). But I don't see a good reason to 
implement that at this point... Deleting the existing one achieves the same 
result for these rare cases.

Jean

On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote:
>> On May 13, 2024, at 17:50, David Carlson  wrote:
>>
>> Now it is my turn to ask a question.
>>
>> My bank recently had an issue with the description text for a few 
>> transactions that resulted in the transactions being reposted with 
>> corrected descriptions.  Now I am trying to import the corrected 
>> transactions but they do not appear in the OFX importer even though 
>> they are in the file generated by the bank.
>>
>> My question is: If I delete the previously imported transactions, can 
>> I import the corrected transactions?
> yes.
>
>> A corollary; is there any way to check, edit or remove the FITID 
>> value of a transaction that prevents the duplicate import without 
>> doing tricks in the OFX file before importing?
> only if you are willing to risk damaging your datafile editing it outside of 
> gnucash. The FITID values are stored as a key/value pair like:
>
>  
>online_id
>20180906246910059666
>  
>
> and finding specific transactions in the raw XML is harder than you might 
> imagine. The online_id is not available to the user anywhere in the gnucash 
> interface.
>
> I have never tried editing a gnucash SQL file outside of gnucash.
>
>> --
>> David Carlson
>> ___
>
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about OFX imports

[Jean Laroche]

Also, you definitely would not want to double-import the same 
transaction, so there isn't a good reason to want to mock with the 
FITID. What *could* be useful (but in extremely rare cases) would be to 
force a re-import of the same transaction despite the fact that it's 
been imported previous, while avoiding a duplication (i.e. the second 
import would update the existing transaction instead of being skipped 
altogether). But I don't see a good reason to implement that at this 
point... Deleting the existing one achieves the same result for these 
rare cases.


Jean

On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote:

On May 13, 2024, at 17:50, David Carlson  wrote:

Now it is my turn to ask a question.

My bank recently had an issue with the description text for a few
transactions that resulted in the transactions being reposted with
corrected descriptions.  Now I am trying to import the corrected
transactions but they do not appear in the OFX importer even though they
are in the file generated by the bank.

My question is: If I delete the previously imported transactions, can I
import the corrected transactions?

yes.


A corollary; is there any way to check, edit or remove the FITID value of a
transaction that prevents the duplicate import without doing tricks in the
OFX file before importing?

only if you are willing to risk damaging your datafile editing it outside of 
gnucash. The FITID values are stored as a key/value pair like:

 
   online_id
   20180906246910059666
 

and finding specific transactions in the raw XML is harder than you might 
imagine. The online_id is not available to the user anywhere in the gnucash 
interface.

I have never tried editing a gnucash SQL file outside of gnucash.


--
David Carlson
___


--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about OFX imports

[David Reiser via gnucash-user]

> On May 13, 2024, at 17:50, David Carlson  wrote:
> 
> Now it is my turn to ask a question.
> 
> My bank recently had an issue with the description text for a few
> transactions that resulted in the transactions being reposted with
> corrected descriptions.  Now I am trying to import the corrected
> transactions but they do not appear in the OFX importer even though they
> are in the file generated by the bank.
> 
> My question is: If I delete the previously imported transactions, can I
> import the corrected transactions?

yes.

> A corollary; is there any way to check, edit or remove the FITID value of a
> transaction that prevents the duplicate import without doing tricks in the
> OFX file before importing?

only if you are willing to risk damaging your datafile editing it outside of 
gnucash. The FITID values are stored as a key/value pair like:


  online_id
  20180906246910059666


and finding specific transactions in the raw XML is harder than you might 
imagine. The online_id is not available to the user anywhere in the gnucash 
interface.

I have never tried editing a gnucash SQL file outside of gnucash.

> 
> -- 
> David Carlson
> ___


--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about OFX imports

[Jean Laroche]

Yes, I believe that if you delete the previously imported transaction, 
the new one will be imported.


For your 2nd question, there isn't a way to remove or edit that FITID 
value without hacking either the OFX or your database... I don't think 
GC ever shows you the FITID of transactions (even though they're saved 
in the database).


Jean

On 5/13/24 2:50 PM, David Carlson wrote:

Now it is my turn to ask a question.

My bank recently had an issue with the description text for a few
transactions that resulted in the transactions being reposted with
corrected descriptions.  Now I am trying to import the corrected
transactions but they do not appear in the OFX importer even though they
are in the file generated by the bank.

My question is: If I delete the previously imported transactions, can I
import the corrected transactions?
A corollary; is there any way to check, edit or remove the FITID value of a
transaction that prevents the duplicate import without doing tricks in the
OFX file before importing?


___
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] Question about OFX imports

[Phyllis Bruce]

If it wasn’t many transactions cannot you just edit the cleared transactions?  
I’ m thinking Gnu  won’t allow you to clear clear the nut ones as a feature to 
avoid duplicates.
 Alternatively, you might delete the cleared transactions and reimport.

At least, that’s what I would do.

> On May 13, 2024, at 4:51 PM, David Carlson  
> wrote:
> 
> Now it is my turn to ask a question.
> 
> My bank recently had an issue with the description text for a few
> transactions that resulted in the transactions being reposted with
> corrected descriptions.  Now I am trying to import the corrected
> transactions but they do not appear in the OFX importer even though they
> are in the file generated by the bank.
> 
> My question is: If I delete the previously imported transactions, can I
> import the corrected transactions?
> A corollary; is there any way to check, edit or remove the FITID value of a
> transaction that prevents the duplicate import without doing tricks in the
> OFX file before importing?
> 
> --
> David Carlson
> ___
> 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] Question about billing

[Angela Haggerty via gnucash-user]

I think I understand your question. I work with several CPA's and 
lawyers in my area primarily in taxes as an Enrolled agent. However I do 
a lot of bookkeeping and corporate maintenance as well. Please forgive 
me if I break this down too much, or cover steps you already know, I 
just want to be complete in my explanation.


I would suggest going to the chart of accounts and adding a new account 
to your liabilities for the credit card in question if you don't already 
have one. If you already have an account double check that in the 
account properties under parent account the drop down menu for account 
type reads "credit card".


When your statements come in enter each individual charge here with an 
offset in correct expense category using the date cleared on the 
statement. EX: 01/15/23 Valero $32.53 would Debit (DB) Fuel Expense and 
Credit (CR) the credit card account on 15 Jan. Doing this for each 
individual charge is tedious at times but it ensures that all the 
charges are listed in the appropriate expense account AND the correct 
accounting period as accrued.


You will also still have a balance in your liabilities to pay through 
the bill system from your bank account. Enter the bill in your system 
for the amount you paid the day the payment cleared your credit card and 
pay it as normal from your bank/cash account. You can then reconcile the 
credit card liability account as you would a bank account.


Tedious but still easier in GNUCash over QB any day... I HATE QB with a 
passion!


A. Haggerty CB EA MTax

___
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] Question about billing

[G R Hewitt]

HI,
Have you tried asking your credit card company to change the billing date
to the end of the month, that would solve that particular problem?

On Sat, 1 Jul 2023 at 23:24, C H  wrote:

> Hello,
>
> I downloaded GNUcash a couple weeks ago and I've been gradually entering
> past data, and there's something I keep running into that I'm hoping
> someone here can give me advice about. When I create bills, I frequently
> want some expenses to count to one period, and some to count to another.
> For example, when I enter a credit card bill, statements are generated
> halfway through the month. Half of expenses might be from May and the other
> half from June. The only way I've found to make expenses match the right
> period is to create two invoices. It feels like there must be a better way.
>
> I tried entering each transaction through journal entries, but it was
> cumbersome, prone to mistakes, and then I lost the ability to view
> information about my credit card bills on the vendor report page.
>
> Is there an easier way to match expenses to the right period?
>
> Thanks
> ___
> 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] Question about billing

[Jim DeLaHunt]

On 2023-07-01 15:23, C H wrote:

Hello,

I downloaded GNUcash a couple weeks ago and I've been gradually entering
past data,


Hello, C H, and welcome to GnuCash!

This is a good type of question for the gnucash-user list, and you will 
find many people here ready to try and help you.


We can help you more if you give us some basic information:

 * For what are you doing bookkeeping: for your personal finances, for
   a business, for something else?
 * What version of GnuCash are you using?
 * What operating system are you using?


… and there's something I keep running into that I'm hoping
someone here can give me advice about. When I create bills, I frequently
want some expenses to count to one period, and some to count to another.
For example, when I enter a credit card bill, statements are generated
halfway through the month. Half of expenses might be from May and the other
half from June. The only way I've found to make expenses match the right
period is to create two invoices. It feels like there must be a better way.


You mention "bills" and "invoices". These terms normally refer to 
GnuCash features which apply to bookkeeping for a business. But you also 
"credit card" "statements". Typically these are are entered as routine 
internal transactions of a person or business, and do not use the 
GnuCash features of "bills" and "invoices".


When you say "enter a credit card bill", do you mean that you hold a 
monthly statement for a particular credit card in your hand, and you are 
entering into GnuCash information about the purchases and payments 
charged to that credit card and listed on that statement?  If so, the 
normal way to do that is to create a GnuCash "account" corresponding to 
that credit card, and then enter each individual purchase or payment as 
a separate GnuCash "transaction" in the credit card's GnuCash "account". 
Each transaction has its own date, some in May, some in June. What you 
do with the monthly statement for the credit card is to "reconcile" it 
with your bookkeeping of the transactions, making sure that your books 
list exactly the same transactions as the statement lists. There is no 
need to use the GnuCash "bills" and "invoices" features.




I tried entering each transaction through journal entries, but it was
cumbersome, prone to mistakes, and then I lost the ability to view
information about my credit card bills on the vendor report page.

Is there an easier way to match expenses to the right period?


If you have not yet read the "GnuCash Tutorial and Concepts Guide" 
, I strongly 
recommend that you put down your statement and read that Guide first. 
See especially section 7. "Credit Cards". You might find it helpful to 
create an separate GnuCash file just for experimentation. Once you do 
the experiments to see how to enter credit card transactions into 
GnuCash using the separate file, then open your main bookkeeping file 
and do the actual data entry.


Best regards,

    —Jim DeLaHunt, from Vancouver, Canada

___
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] Question - Applying Credit notes to an outstanding invoice

[Nora]

Thanks Very Much
It worked!
Nora


-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+nora=story-lines...@gnucash.org] On Behalf Of
Adrien Monteleone
Sent: September 1, 2022 2:47 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Question - Applying Credit notes to an outstanding
invoice

Menu: Business > Customer > Process Payment

Look up the customer
Select both the desired credit note and the desired invoice

Set the other appropriate info, but unless also taking another form of 
payment leave the payment field unchanged.

The credit note will be used to partially/fully offset the invoice which 
will show up as a 'payment' in the Customer Report.

Regards,
Adrien

On 9/1/22 9:39 AM, Nora wrote:
> I'm not sure how to apply a client's credit note to pay for another
invoice
> of the same client.


___
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] Question - Applying Credit notes to an outstanding invoice

[Adrien Monteleone]

Menu: Business > Customer > Process Payment

Look up the customer
Select both the desired credit note and the desired invoice

Set the other appropriate info, but unless also taking another form of 
payment leave the payment field unchanged.


The credit note will be used to partially/fully offset the invoice which 
will show up as a 'payment' in the Customer Report.


Regards,
Adrien

On 9/1/22 9:39 AM, Nora wrote:

I'm not sure how to apply a client's credit note to pay for another invoice
of the same client.



___
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] Question about gnucash

[John Ralls]

> On May 30, 2022, at 3:27 AM, stephen.lohn...@oxnee.com wrote:
> 
> Dear gnucash-user,
> 
> 
> 
> I have a question is there any documentation about installing and creating
> report via Scheme. I assume that it is interpretive language so that once it
> is installed in in the correct directory it will be visibly to use.
> 
> 
> 
> I have tried to connect it to PostgreSQL but I have not had any success, I
> know that my PostgreSQL is working correctly as I use for Django
> development, I tried the sqlite3 that seems to work but I don't know where
> the db file is created as I have a sqlite browser 
> 

For custom reports, https://wiki.gnucash.org/wiki/Custom_Reports is a good 
starting point.

For pgsql if you're a Linux user you may need to install libdbd-pgsql; note 
that that's what Debian calls it, other distros may have slightly different 
names.

The SQLite3 file is created wherever you told GnuCash to create it in the 
File>New or File>Save As dialogs.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Greg Feneis]

I thought perhaps Quicken has a dialogue/wizard feature that appears as a
paper check and works as an easily filled form that the user may repeatedly
fill as if writing a paper check (QuickBooks had this, I imagine Quicken
does too). This might be what the OP is asking to find.  GnuCash doesn't
have this feature.  I think the previously mentioned tutorial should get
the OP on the right track


Kind regards, Greg Feneis
(Pixel 3)


On Fri, May 13, 2022, 06:02 Derek Atkins  wrote:

> Michael,
>
> On Fri, May 13, 2022 8:50 am, Michael or Penny Novack wrote:
> >> First, I highly recommend you read the GnuCash documentation.  The
> >> Tutorial and Guide are very useful in explaining the concepts, and the
> >> Help is useful at explaining what the buttons do.
> >>
> >> Having said that, there are two ways to enter a transaction like a
> >> Check.
> >> The first is to open the Transfer Dialog (Ctrl-T) and enter the date,
> >> amount, source (e.g. Assets:Checking) and destination (e.g.
> >> Expenses:Rent).
> >> The second is to open the account register of the checking account and
> >> from there you can create a transaction for the expense.
> >
> > OR, in the second case, you could open the account for the expense and
> > do it there. With gnucash, entering a transaction affecting just two
> > accounts you can do it form the ledger account of either. But please
> > note IF AN EXPENSE. When you write a check, this will be a credit to the
> > checking account. The debit side of the transaction will usually be an
> > account under expense BUT NOT NECESSARILY SO. For some examples:
>
> Considering the OP said "doesn't know accounting", I chose not to
> introduce this because in the majority of cases it will just confuse the
> user and they will enter the transaction incorrectly.  Also, most humans
> intuitively understand transactions from an Asset or Liability, but have a
> much harder time "originating" a transaction from an Income or Expense
> account.
>
> Yes, a user CAN enter a transaction from any account, but IMNSHO a newbie
> user should be encouraged to enter them from an Asset or Liability account
> to reduce the chance of errors and confusion.
>
> Thanks,
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Derek Atkins]

Michael,

On Fri, May 13, 2022 8:50 am, Michael or Penny Novack wrote:
>> First, I highly recommend you read the GnuCash documentation.  The
>> Tutorial and Guide are very useful in explaining the concepts, and the
>> Help is useful at explaining what the buttons do.
>>
>> Having said that, there are two ways to enter a transaction like a
>> Check.
>> The first is to open the Transfer Dialog (Ctrl-T) and enter the date,
>> amount, source (e.g. Assets:Checking) and destination (e.g.
>> Expenses:Rent).
>> The second is to open the account register of the checking account and
>> from there you can create a transaction for the expense.
>
> OR, in the second case, you could open the account for the expense and
> do it there. With gnucash, entering a transaction affecting just two
> accounts you can do it form the ledger account of either. But please
> note IF AN EXPENSE. When you write a check, this will be a credit to the
> checking account. The debit side of the transaction will usually be an
> account under expense BUT NOT NECESSARILY SO. For some examples:

Considering the OP said "doesn't know accounting", I chose not to
introduce this because in the majority of cases it will just confuse the
user and they will enter the transaction incorrectly.  Also, most humans
intuitively understand transactions from an Asset or Liability, but have a
much harder time "originating" a transaction from an Income or Expense
account.

Yes, a user CAN enter a transaction from any account, but IMNSHO a newbie
user should be encouraged to enter them from an Asset or Liability account
to reduce the chance of errors and confusion.

Thanks,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[David Carlson]

If you recall, when you set up check printing in Quicken there was some
trial and error adjusting the printing to fit your check stock.  There will
also be some trial and error in GnuCash.

Good luck.

On Fri, May 13, 2022, 6:26 AM Derek Atkins  wrote:

> Hi,
>
> On Mon, May 9, 2022 7:39 pm, Alan Brinker wrote:
> > Hi,
> > I have transferred my account from Quicken to Gnucash and can open it
> fine
> > but I can't find any way to write a check or enter it.  How can I do that
> > or where can I find instructions on it.  I am just a basic user with no
> > accounting training or experience beyond Quicken.
>
> First, I highly recommend you read the GnuCash documentation.  The
> Tutorial and Guide are very useful in explaining the concepts, and the
> Help is useful at explaining what the buttons do.
>
> Having said that, there are two ways to enter a transaction like a Check.
> The first is to open the Transfer Dialog (Ctrl-T) and enter the date,
> amount, source (e.g. Assets:Checking) and destination (e.g.
> Expenses:Rent).
> The second is to open the account register of the checking account and
> from there you can create a transaction for the expense.
>
> If you want to print a check, you need to do that from the register.
>
> Hpoe this helps,
>
> > Alan Brinker
> > CEO
> > Do-I.T. Where Small and Medium Companies Get Big Company IT.
> > 408 234 5100
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Michael or Penny Novack]

First, I highly recommend you read the GnuCash documentation.  The
Tutorial and Guide are very useful in explaining the concepts, and the
Help is useful at explaining what the buttons do.

Having said that, there are two ways to enter a transaction like a Check.
The first is to open the Transfer Dialog (Ctrl-T) and enter the date,
amount, source (e.g. Assets:Checking) and destination (e.g.
Expenses:Rent).
The second is to open the account register of the checking account and
from there you can create a transaction for the expense.


OR, in the second case, you could open the account for the expense and 
do it there. With gnucash, entering a transaction affecting just two 
accounts you can do it form the ledger account of either. But please 
note IF AN EXPENSE. When you write a check, this will be a credit to the 
checking account. The debit side of the transaction will usually be an 
account under expense BUT NOT NECESSARILY SO. For some examples:


1) check to pay brother back for a loan he gave you last week (debit 
would be a liability account)


2) check to transfer money to a savings account (debit would be the 
account of that savings account)


3) check to buy 100 widgets you plan to sell at a profit (debit would be 
an inventory account -- becomes an expense for :cost of goods sold only 
when you manage to sell them.



If you want to print a check, you need to do that from the register.

Strictly speaking, not part of accounting for the check. Checks can be 
hand written on pre-printed forms (aka"checks") or printed off on a 
computer printer* or be an electronic transfer. A pure accounting system 
is just recording the transaction regardless of how the "check" is 
produced. An accounting "package" might or might not ALSO have 
provisions for producing a check as well as entering it as an "added 
feature". Which means that the best way to ask this question about an 
accounting application is "can it write checks?" before asking "how".


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Derek Atkins]

Hi,

On Mon, May 9, 2022 7:39 pm, Alan Brinker wrote:
> Hi,
> I have transferred my account from Quicken to Gnucash and can open it fine
> but I can't find any way to write a check or enter it.  How can I do that
> or where can I find instructions on it.  I am just a basic user with no
> accounting training or experience beyond Quicken.

First, I highly recommend you read the GnuCash documentation.  The
Tutorial and Guide are very useful in explaining the concepts, and the
Help is useful at explaining what the buttons do.

Having said that, there are two ways to enter a transaction like a Check. 
The first is to open the Transfer Dialog (Ctrl-T) and enter the date,
amount, source (e.g. Assets:Checking) and destination (e.g.
Expenses:Rent).
The second is to open the account register of the checking account and
from there you can create a transaction for the expense.

If you want to print a check, you need to do that from the register.

Hpoe this helps,

> Alan Brinker
> CEO
> Do-I.T. Where Small and Medium Companies Get Big Company IT.
> 408 234 5100

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

It looks like using sub-accounts to track amounts designated for a
specific purpose going into and out of accounts will work great.
Thanks everyone.
Brad

On Sat, Apr 23, 2022 at 11:14 AM Brad  wrote:
>
> I like the idea of using sub-accounts.  I will test it out and report back.
> Thanks.
>
> On Fri, Apr 22, 2022 at 7:37 PM David H  wrote:
> >
> > Brad,
> >
> > If I were to do this I think I'd look at creating sub-accounts under the 
> > Transfer To account - i.e.
> >
> > Assets >> Current Assets >> Transfer To Account  >> Groceries
> > Assets >> Current Assets >> Transfer To Account  >> Utilities
> > Assets >> Current Assets >> Transfer To Account  >> etc
> >
> > This tells you how much you transferred to each and also includes the 
> > balance of the sub accounts in the Transfer To account.
> >
> > cheers David H.
> >
> >
> >
> > On Sat, 23 Apr 2022 at 07:39, Brad  wrote:
> >>
> >> Hello,
> >> I am new to GnuCash and to this list.  I am a long, long time Quicken
> >> user who has finally gotten fed up with Quicken and I am in the midst
> >> of converting to GnuCash.
> >>
> >> My question is regarding transfer of funds from one account to
> >> another.  I want to transfer funds from one account to another, but I
> >> also want to track the transfer amount against an expense account so I
> >> can keep track separately of how much I have transferred for different
> >> reasons.
> >>
> >> Anyone have any ideas?  I'm guessing it involves a split transaction
> >> of some sort, but I can't figure out what the pieces of the split look
> >> like.
> >> Thanks in advance for your help.
> >> Brad
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Michael or Penny Novack]

On 4/22/2022 11:35 PM, john wrote:

Quicken isn't really an accounting app. Intuit's offering in that space is 
Quickbooks. That means that how you used Quicken isn't directly transferable to 
GnuCash. If being able to use a Free Software alternative to Quicken the same way you 
use Quicken is important to you then have a look at KMyMoney: https://kmymoney.org/ 


To accomplish what I think you're trying to do in "real" accounting requires 
two special accounts: An asset account to collect the money reserved for the payment and 
a liability account to accumulate the accrual. For your property tax example, suppose you 
owe 1200 every six month, but you want to record the expense and make a reservation 
monthly. You'll create two accounts: Assets:Current Assets:Provision for Property Tax and 
Liabliltues:Current Liabilities:Accrued Property Tax. Every month you'll create a 
transaction that looks something like:


I think perhaps the real issue is the different types of information.

ONE sort of information is the actual transactions.

But it is not the only sort of information. We also may need 
"prospective" information. I think here the specific question is along 
the lines of "at some future time will a bank account contain enough to 
pay for some expense. Here you are thinking about a a specific actual 
transfer, but it could also be a scheduled transfer (scheduled to take 
place before the check for the expense must be written; when THAT is 
scheduled to happen).


Look at the possibilities of the "cash flow" report.

Michael D Novack

PS:Understand, you are thinking of JUST this one future expense, but you 
want the bank account to contain enough for ANY future expense and 
although you have only one, you could have many.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

I like the idea of using sub-accounts.  I will test it out and report back.
Thanks.

On Fri, Apr 22, 2022 at 7:37 PM David H  wrote:
>
> Brad,
>
> If I were to do this I think I'd look at creating sub-accounts under the 
> Transfer To account - i.e.
>
> Assets >> Current Assets >> Transfer To Account  >> Groceries
> Assets >> Current Assets >> Transfer To Account  >> Utilities
> Assets >> Current Assets >> Transfer To Account  >> etc
>
> This tells you how much you transferred to each and also includes the balance 
> of the sub accounts in the Transfer To account.
>
> cheers David H.
>
>
>
> On Sat, 23 Apr 2022 at 07:39, Brad  wrote:
>>
>> Hello,
>> I am new to GnuCash and to this list.  I am a long, long time Quicken
>> user who has finally gotten fed up with Quicken and I am in the midst
>> of converting to GnuCash.
>>
>> My question is regarding transfer of funds from one account to
>> another.  I want to transfer funds from one account to another, but I
>> also want to track the transfer amount against an expense account so I
>> can keep track separately of how much I have transferred for different
>> reasons.
>>
>> Anyone have any ideas?  I'm guessing it involves a split transaction
>> of some sort, but I can't figure out what the pieces of the split look
>> like.
>> Thanks in advance for your help.
>> Brad
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[john]

Quicken isn't really an accounting app. Intuit's offering in that space is 
Quickbooks. That means that how you used Quicken isn't directly transferable to 
GnuCash. If being able to use a Free Software alternative to Quicken the same 
way you use Quicken is important to you then have a look at KMyMoney: 
https://kmymoney.org/ 

To accomplish what I think you're trying to do in "real" accounting requires 
two special accounts: An asset account to collect the money reserved for the 
payment and a liability account to accumulate the accrual. For your property 
tax example, suppose you owe 1200 every six month, but you want to record the 
expense and make a reservation monthly. You'll create two accounts: 
Assets:Current Assets:Provision for Property Tax and Liabliltues:Current 
Liabilities:Accrued Property Tax. Every month you'll create a transaction that 
looks something like:

5/1/2022 Accrued Property Tax
 Assets:Current Assets:Bank 
200.00
 Assets:Current 
Assets:Provision for Property Tax  200.00
 Expenses:Tax 
Expenses:Property Tax   200.00
 Liabilities:Current 
Liabilities:Accrued Property Tax  200.00

Then when you transfer the money to the Tax Collector:

6/1/2022 Pay Property Tax
Assets:Current 
Assets:Provision for Property Tax200.00
Liabilities:Current 
Liabilities:Accrued Property Tax   200.00

Regards,
John Ralls

> On Apr 22, 2022, at 3:24 PM, Brad  wrote:
> 
> Thank you for the quick response.  I do have some background in
> accounting and I have actually reviewed both the Tutorial and the full
> Help manual.  So far I am liking QnuCash alot.  It's just a matter of
> getting it to do some of the things I was doing in Quicken.
> 
> So, you are pretty close to understanding what I am trying to do.
> Yes, I am accumulating funds in a separate bank account for a large
> purchase (let's say property taxes paid once a year).  Then when it is
> time to pay the property tax I need to transfer the funds to my
> checking account so that I can write the check to the county.  At the
> same time I want to keep track of how much I have transferred for that
> purpose.  For example, maybe I transfer the funds in two transactions
> and I want a quick way to see if I have transferred enough.
> 
> In Quicken, my property tax budget was set to zero.  When I write the
> check for the property taxes, say for $1,000, that expense category
> goes to -$1,000.  Then when I transfer the funds, I can add them to
> that budget line, bringing the property tax expense category back to
> zero.  This way I have basically 3 entries, but I need an even number
> of entries to follow double-entry accounting rules.  Two entries to
> transfer the funds from one account to another, and then one to show
> the funds going to the property tax expense.  Oh, and I guess two more
> when I write the check to the county.
> Thanks.
> Brad
> 
> 
> On Fri, Apr 22, 2022 at 3:54 PM Stan Brown  wrote:
>> 
>> 
>> On 2022-04-22 14:37, Brad wrote:
>>> My question is regarding transfer of funds from one account to
>>> another.  I want to transfer funds from one account to another, but I
>>> also want to track the transfer amount against an expense account so I
>>> can keep track separately of how much I have transferred for different
>>> reasons.
>> 
>> Welcome to GnuCash, Brad! There's a bit of a learning curve coming from
>> Quicken or most other software, because in GnuCash you're doing
>> double-entry bookkeeping, and most of the details are visible to you.
>> Have you looked at the Tutorial and Concepts Guide (in the Help menu)
>> yet, to help you with that learning curve?
>> 
>> 
>> By "transfer funds from one account to another", do you mean transfer
>> from one bank account (or cash, money market, etc) to another? Is this a
>> matter of segregating funds that you expect to spend for a large future
>> expense, such as a vacation or a new furnace? I'm going to assume both
>> of those are yes, but if I've guessed wrong please follow up with more
>> details and perhaps an example of what you're trying to do.
>> 
>> 
>> 
>> By the way, this isn't really a GnuCash problem, but an accounting
>> problem. Your chart of accounts should be structured to let you
>> aggregate information in the ways that you want. It would be no
>> different if you were keeping our books in a big ledger with pen and ink.
>> 
>> 
>> 
>> If you have some sort of bank account in which you're accumulating funds
>> against a large future expense, you'd probably want to name that account
>> in GnuCash as "Assets:Banks:Savings for 

Re: [GNC] Question about transfers

[David H]

Brad,

If I were to do this I think I'd look at creating sub-accounts under the
Transfer To account - i.e.

Assets >> Current Assets >> Transfer To Account  >> Groceries
Assets >> Current Assets >> Transfer To Account  >> Utilities
Assets >> Current Assets >> Transfer To Account  >> etc

This tells you how much you transferred to each and also includes the
balance of the sub accounts in the Transfer To account.

cheers David H.



On Sat, 23 Apr 2022 at 07:39, Brad  wrote:

> Hello,
> I am new to GnuCash and to this list.  I am a long, long time Quicken
> user who has finally gotten fed up with Quicken and I am in the midst
> of converting to GnuCash.
>
> My question is regarding transfer of funds from one account to
> another.  I want to transfer funds from one account to another, but I
> also want to track the transfer amount against an expense account so I
> can keep track separately of how much I have transferred for different
> reasons.
>
> Anyone have any ideas?  I'm guessing it involves a split transaction
> of some sort, but I can't figure out what the pieces of the split look
> like.
> Thanks in advance for your help.
> Brad
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Michael or Penny Novack]

On 4/22/2022 6:24 PM, Brad wrote:

...but I need an even number
of entries to follow double-entry accounting rules.  Two entries to
transfer the funds from one account to another, and then one to show
the funds going to the property tax expense.  Oh, and I guess two more
when I write the check to the county.
Thanks.
Brad


Using "entry" may be causing confusion.. Let's work in reverse:

a) Writing check to county - That transaction has a debit of "real 
estate tax" (expense) and credit "checking account" (asset)


b) Transferring from savings to checking -- That transaction has a debit 
of "checking account" and a credit of "savings account"


Now let's discuss this other tracking you want to do, making sure you 
have enough transferred. WHERE did you have that amount recorded (in 
what account) and how did it get there? Do not confuse "budget" with 
"actual". The transactions described in "a" and "b" are actuals.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

Thank you for the quick response.  I do have some background in
accounting and I have actually reviewed both the Tutorial and the full
Help manual.  So far I am liking QnuCash alot.  It's just a matter of
getting it to do some of the things I was doing in Quicken.

So, you are pretty close to understanding what I am trying to do.
Yes, I am accumulating funds in a separate bank account for a large
purchase (let's say property taxes paid once a year).  Then when it is
time to pay the property tax I need to transfer the funds to my
checking account so that I can write the check to the county.  At the
same time I want to keep track of how much I have transferred for that
purpose.  For example, maybe I transfer the funds in two transactions
and I want a quick way to see if I have transferred enough.

In Quicken, my property tax budget was set to zero.  When I write the
check for the property taxes, say for $1,000, that expense category
goes to -$1,000.  Then when I transfer the funds, I can add them to
that budget line, bringing the property tax expense category back to
zero.  This way I have basically 3 entries, but I need an even number
of entries to follow double-entry accounting rules.  Two entries to
transfer the funds from one account to another, and then one to show
the funds going to the property tax expense.  Oh, and I guess two more
when I write the check to the county.
Thanks.
Brad


On Fri, Apr 22, 2022 at 3:54 PM Stan Brown  wrote:
>
>
> On 2022-04-22 14:37, Brad wrote:
> > My question is regarding transfer of funds from one account to
> > another.  I want to transfer funds from one account to another, but I
> > also want to track the transfer amount against an expense account so I
> > can keep track separately of how much I have transferred for different
> > reasons.
>
> Welcome to GnuCash, Brad! There's a bit of a learning curve coming from
> Quicken or most other software, because in GnuCash you're doing
> double-entry bookkeeping, and most of the details are visible to you.
> Have you looked at the Tutorial and Concepts Guide (in the Help menu)
> yet, to help you with that learning curve?
>
>
> By "transfer funds from one account to another", do you mean transfer
> from one bank account (or cash, money market, etc) to another? Is this a
> matter of segregating funds that you expect to spend for a large future
> expense, such as a vacation or a new furnace? I'm going to assume both
> of those are yes, but if I've guessed wrong please follow up with more
> details and perhaps an example of what you're trying to do.
>
>
>
> By the way, this isn't really a GnuCash problem, but an accounting
> problem. Your chart of accounts should be structured to let you
> aggregate information in the ways that you want. It would be no
> different if you were keeping our books in a big ledger with pen and ink.
>
>
>
> If you have some sort of bank account in which you're accumulating funds
> against a large future expense, you'd probably want to name that account
> in GnuCash as "Assets:Banks:Savings for Vacation" or similar. when you
> transfer money from your regular everyday bank account, your transaction
> would look like this:
>
> Debit: Assets:Banks:Savings for Vacation
>
> Credit:Assets:Banks:Regular Checking
>
>
>
> As for tracking against expenses, no expense is created by this account
> transfer. Why? Because even though you may presently intend to use these
> funds for a particular future expense, you haven't actually spent them
> yet, and you could change your mind before you do.
>
> When you start spending out of the vacation account, _that's_ when you
> have an expense, and your transactions would look like this:
>
> Debit: Expenses:Vacations
>
> Credit:Assets:Banks:Savings for Vacation
>
>
>
> --
>
> Stan Brown
>
> Tehachapi, CA, USA
>
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Stan Brown]

On 2022-04-22 14:37, Brad wrote:
> My question is regarding transfer of funds from one account to
> another.  I want to transfer funds from one account to another, but I
> also want to track the transfer amount against an expense account so I
> can keep track separately of how much I have transferred for different
> reasons.

Welcome to GnuCash, Brad! There's a bit of a learning curve coming from
Quicken or most other software, because in GnuCash you're doing
double-entry bookkeeping, and most of the details are visible to you.
Have you looked at the Tutorial and Concepts Guide (in the Help menu)
yet, to help you with that learning curve?


By "transfer funds from one account to another", do you mean transfer
from one bank account (or cash, money market, etc) to another? Is this a
matter of segregating funds that you expect to spend for a large future
expense, such as a vacation or a new furnace? I'm going to assume both
of those are yes, but if I've guessed wrong please follow up with more
details and perhaps an example of what you're trying to do.



By the way, this isn't really a GnuCash problem, but an accounting
problem. Your chart of accounts should be structured to let you
aggregate information in the ways that you want. It would be no
different if you were keeping our books in a big ledger with pen and ink.



If you have some sort of bank account in which you're accumulating funds
against a large future expense, you'd probably want to name that account
in GnuCash as "Assets:Banks:Savings for Vacation" or similar. when you
transfer money from your regular everyday bank account, your transaction
would look like this:

Debit: Assets:Banks:Savings for Vacation

Credit:Assets:Banks:Regular Checking



As for tracking against expenses, no expense is created by this account
transfer. Why? Because even though you may presently intend to use these
funds for a particular future expense, you haven't actually spent them
yet, and you could change your mind before you do.

When you start spending out of the vacation account, _that's_ when you
have an expense, and your transactions would look like this:

Debit: Expenses:Vacations

Credit:Assets:Banks:Savings for Vacation



-- 

Stan Brown

Tehachapi, CA, USA

https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Derek Atkins]

Hi,

On Fri, April 22, 2022 5:37 pm, Brad wrote:
> Hello,
> I am new to GnuCash and to this list.  I am a long, long time Quicken
> user who has finally gotten fed up with Quicken and I am in the midst
> of converting to GnuCash.
>
> My question is regarding transfer of funds from one account to
> another.  I want to transfer funds from one account to another, but I
> also want to track the transfer amount against an expense account so I
> can keep track separately of how much I have transferred for different
> reasons.

>From a GAAP point of view, that does not make sense.  If you have an
account at Bank of America and another account at Truist, if you transfer
$100 from BoA to T it's not tied to any expense at all.

You could put a description in the transfer that says "For Groceries" if
you want, but there is no way to tie that transfer explicitly to the
Expenses:Groceries account.

> Anyone have any ideas?  I'm guessing it involves a split transaction
> of some sort, but I can't figure out what the pieces of the split look
> like.

What is actual transaction that you're trying to model?  Explain the
transaction (or series of transactions, but in that case make sure you
separate them) you have here.

But...  if you have money entering an account and then exiting an account,
and you want to mark that entry and exit, those are, necessarily, two
transactions.

> Thanks in advance for your help.
> Brad

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

PS: You COULD make a split transaction that, say, credits BoA, then both
debits and credits Truist, and then debits your Expense.   But that's
extremely ugly.

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

[Adrien Monteleone]

Fran,

Do a bit of reading on 'Accrual' vs. 'Cash' accounting.

The Business Features of GnuCash are designed for the Accrual method.

With a bit of small fuss, they can be used for the Cash method too.

Expenses in the Accrual method are 'recognized' when 'incurred'. That 
is, when you 'owe' the money to whomever you purchased something (good 
or service) that is when you incurred the expense, not when you happen 
to get around to physically paying their invoice. The idea here is that 
you are recording expenses in the same period that you use those 
expenses (good or services) to generate revenue.


A similar process takes place with Sales. You 'earn' Revenue when the 
sale is made (usually upon 'good delivery') and the actual timing of the 
receipt of payment is not part of when you made the sale. (your vendors 
'earn' their revenue when they deliver a good or service to you, not 
when you pay them, which is why you incur the expense at their point of 
'good delivery' as that is when you legally 'owe' them.)


Accounts Receivable and Accounts Payable are used to track actual 
payments made and received, while still recording the expenses and 
revenue when they are incurred and earned.


Now, read up on the 'Matching Principle' of accounting. It will explain 
why it is done this way.


With the Cash method, you aren't concerned with when you incur expenses 
or when you earn revenue, but when you make payment or receive payment. 
For businesses that pay for inventory up front, and receive payment at 
the exchange of goods, this makes sense.


For businesses that purchase on credit and sell on credit, it is a mess 
and makes little sense. (it also makes it difficult to analyze your 
historical sales activity and expenses, because they don't match each 
other.) For this reason and for these cases, Accrual accounting is 
employed rather than the Cash method.


-
What it appears you are describing is that you are using the Business 
Features as normal, and thus using the Accrual Method, but for some 
reason (not yet explained) you want an Expense Report on a Cash Basis.


That's fine, but beware, if your accounting is supposed to be on a Cash 
Basis, you should probably alter your GnuCash workflow to assist with 
this and make reporting easier and more accurate. And if not, then sure, 
you can still generate Cash Basis reports as you found out.


Regards,
Adrien

On 3/18/22 9:50 AM, Fran_3 via gnucash-user wrote:

  My Bad. Expenses are created when the bill is posted... not when it is 
paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor 
X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking 
Account and relive AP
So to get all expenses paid in 2021 you would create a Transaction Report on the Checking 
Account for the time period you desire...And set the Sorting Option Primary Key to 
"Other Account"And then lookup Accounts Payable Total in the results.
And if you know how you could set the Transaction Report Filter to only show 
Checking Transactions charged to Accounts Payable...I'm posting another thread 
on that... more properly titled... to help other poor souls... like me :-)


 On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user 
 wrote:
  
  Situation:

We posted a bill in 2020 but paid it in 2021.
I need to create an Expense report for all expenses paid in 2021... regardless 
of when the bill was posted...
My attempted solution:I created a Transaction Report on "Expenses" with "All 
Children"  selected...And with a date range of 1/1/2021 to 12/31/2021
The Problem:The payment for the 2020 bill does not show in the report...Even 
though the expense was paid in paid in 2021.
How can I create a report that will show all expenses paid in 2021 regardless 
of when the bill was posted?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Assemblies

[Adrien Monteleone]

Fred, please be sure to always copy the list address on all replies so 
the discussion stays on the list.


That way, others can benefit from the discussion, as well as chime in 
and help out.


Also keep in mind, we don't give accounting advice here. If you need 
such advice, you need the services of an accountant.


But once you know 'what' to do, we can help you with the 'how to do it 
in GnuCash.'


-

I am not familiar with Sage so I can't explain how GnuCash works in 
reference to what you were doing before.


There is no inventory management in GnuCash.

You can set up accounts to track the *value* of your inventory, but not 
the quantity. (at least not out of the box, and without lots of work)


You should make entries when you purchase ingredients/materials.

Then you should make entries when you assemble or make something from those.

Then you make more entries when you sell the assembled products.

Basic Accounting Generic Examples
-

When you purchase ingredients for soap:

Dr. Assets:Inventory:Raw Materials
Cr. Assets:Bank

This 'moves' money from your bank account to 'Raw Materials'. (which is 
now in the form of Inventory, so this records the value of that inventory)


When you make the soap:

Dr. Assets:Inventory:Work In Progress
Cr. Assets:Inventory:Raw Materials

This moves that value from Raw Materials to inventory 'in production' 
but not yet finished. (this step may be optional for you if the time 
involved in production is rather short, like one day or less and you 
package as part of the basic production process.)


When you package the final product ready for sale:

Dr. Assets:Inventory:Finished Goods
Cr. Assets:Inventory:Work In Progress

This moves the value from 'in production' to its final state as a 
Saleable Good or Finished Product.


When you sell a finished product:

Dr. Assets:Cash
Cr. Revenue:Sales
Dr. Expenses:Costs of Goods Sold
Cr. Assets:Inventory:Finished Goods

For this last one, the value of the first two splits should be equal, 
and the value of the last two splits should be equal. (but they will of 
course be less than the first two, or else you aren't making a profit!)


The first two splits record the receipt of payment (could be 
'Undeposited Funds' if by Credit Card or Paper Check instead of 'Cash') 
and 'recognizes' the revenue earned. (by type, in this case 'Sales Revenue')


The second two splits move the value of the inventory sold out of 
inventory entirely, and records it as an expense of doing business. 
(which will eventually be subtracted from revenue to obtain 'income', 
Revenue - Expenses = Income) The Profit & Loss Report or Income 
Statement Report (same report - different names) will handle that math 
for you.


Your actual transactions may differ, but this is a 'big picture' 
overview of the generic inventory-to-sales process.


--

The math for figuring out the value of raw materials that go into a 
product that you'll need for making those 'in progress'/'finished goods' 
entries in GnuCash is something you're going to have to setup outside of 
GnuCash in a spreadsheet or other inventory management software.


If you like, it is possible to export the result from the spreadsheet or 
other software into GnuCash so you don't have to manually cross-enter 
anything.


If you only have one or a small handful of products you only need do the 
math by hand once, and then you can just duplicate those transactions 
changing the dates.


You can also put in the Memo fields the proportions of each ingredient 
as a reminder, then enter that as a math equation in the transaction 
instead of just a final number. GnuCash can do the calculations for you.


--
There are no shortcuts if you're going to do your own accounting. You 
just have to learn it.


It really isn't difficult, and you don't have to learn 'all' of 
accounting, just what you need for your business. (and you won't learn 
it all at once, most likely, as you find out you need to know it)


Accounting is not about difficult or fancy math. The hard part is 
learning 'how to account' properly for your activity. That's it.



Regards,
Adrien


On Mar 17, 2022 w12d76, at 10:20 AM, Frederick  wrote:

Hi Adrian, thanks for your response.  

Unfortunately i am a bit confused by it, however.  I am sure this comes from being as guy who makes soap and the accounting is done, only as a necessity and not by way of my profession.  I am definitely trying to avoid taking an accounting course (-:  


I am a maker of stuff that wants to track assembly-build  (Sage 50 terms) as i 
do now with my Sage 50 software.  I set up my system to purchase ingredients 
and then Assemble-Build these ingredients into finished goods that i sell.  I 
track quantities and value of ingredients and finished goods. I am looking for 
a different platform to do this tracking, both monetary and quantity.  It 
sounds like you are saying the monetary tracking is possible but the 
quantity/item 

Re: [GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

[Fran_3 via gnucash-user]

 My Bad. Expenses are created when the bill is posted... not when it is 
paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor 
X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking 
Account and relive AP
So to get all expenses paid in 2021 you would create a Transaction Report on 
the Checking Account for the time period you desire...And set the Sorting 
Option Primary Key to "Other Account"And then lookup Accounts Payable Total in 
the results.
And if you know how you could set the Transaction Report Filter to only show 
Checking Transactions charged to Accounts Payable...I'm posting another thread 
on that... more properly titled... to help other poor souls... like me :-)






On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user 
 wrote:  
 
 Situation:
We posted a bill in 2020 but paid it in 2021.
I need to create an Expense report for all expenses paid in 2021... regardless 
of when the bill was posted...
My attempted solution:I created a Transaction Report on "Expenses" with "All 
Children"  selected...And with a date range of 1/1/2021 to 12/31/2021
The Problem:The payment for the 2020 bill does not show in the report...Even 
though the expense was paid in paid in 2021.
How can I create a report that will show all expenses paid in 2021 regardless 
of when the bill was posted?
Thanks for any help.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Assemblies

[Adrien Monteleone]

If you're looking for 'inventory control/manangement' or 'item tracking' 
by quantity, no, GnuCash can't do it. (out of the box)


Some people have finagled it to do so using user-defined commodity 
accounts, but that seems like more trouble than it is worth.


Inventory management should be done in a separate app and the resulting 
monetary values imported into GnuCash for accounting.


If you just want to track monetary-value of your inventory, yes, 
absolutely, GnuCash can handle that, be it parts, assemblies, etc.


A good accounting reference on manufacturing accounting will show you 
the transaction entries for acquiring the raw material inventory, and 
then moving inventory from raw materials, to work in progress, to 
finished goods, then cost of goods sold and revenue.


Here's a good start: https://www.principlesofaccounting.com/

But there are plenty of others online and in your nearest library. 
Especially consider college texts for basic and 2nd level accounting. 
(usually the first two courses are from the first half and second half 
of the same text)


Regards,
Adrien

On 3/16/22 8:59 PM, Frederick wrote:

Hi there, i am a interested in abandoning my Accounting software and looking to 
see if Gnucash will work for my one person business.

The main issue is that i manufacture items to sell and need software that can 
account for assemblies.  This can go by the name of manufacture/build or 
assembly.  Sage 50 calls this Assembly.

If someone can let me know if builds are easily possible with gnucash and 
direct me to literature on this matter, it would be greatly appreciated.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Assemblies

[Liz]

On Thu, 17 Mar 2022 01:59:28 +
Frederick  wrote:

> Hi there, i am a interested in abandoning my Accounting software and
> looking to see if Gnucash will work for my one person business.
> 
> The main issue is that i manufacture items to sell and need software
> that can account for assemblies.  This can go by the name of
> manufacture/build or assembly.  Sage 50 calls this Assembly.
> 
> If someone can let me know if builds are easily possible with gnucash
> and direct me to literature on this matter, it would be greatly
> appreciated.
> 
> take care,  fred
> 

I'm assuming here that you mean "manufacture a widget" for assembly and
build.
There are other meanings of build that software developers use.

When I make an invoice I can invoice different items. I can invoice
Time, different types of Service, and different Goods.

We don't know how you account for manufacturing costs when you invoice,
nor how you spread this income in your accounts. If you give some more
details, someone who is already doing similar with Gnucash can advise. 

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[David Carlson]

 Κωνσταντίνος,
you are not the first to have this trouble.  See
https://bugs.gnucash.org/show_bug.cgi?id=769256.

On Wed, Feb 9, 2022 at 5:18 PM Κωνσταντίνος  wrote:

> Yeah, i found it and it works!
> I misunderstood that this option (and the option next to it) was by
> default the same with the account's option you choose to do the new account
> action.
> And the guide mentions it clearly, but i thought that was been selected by
> default.
>
> Maybe i read to much for one day...
>
> Really thank you all of you guys, for the help, quick reaction and the
> friendly atmosphere!
>
> Have a great day!
>
> 10 Φεβ 2022 01:02:20 David Carlson :
>
> As Fred hinted, the Account type box where you need to select security (in
> English?) is on the lower left, not near the top or right where you might
> expect to see it.
>
> On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:
>
>> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>>
>> > And how i can set it in stock?
>>
>> The "Account Type" dropdown is at the bottom left of the "New Account"
>> window, which I think is the one you showed (part of) in your original
>> message. You will probably need to scroll down to find the entry for
>> "Stock". You need to do this before clicking "Select", and then you will
>> get a "Select security" window instead of "Select currency".
>>
>> Sorry for not making this clear earlier: I thought it was mentioned in
>> the documentation.
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Carlson
>
>

-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[Κωνσταντίνος]

Yeah, i found it and it works!
I misunderstood that this option (and the option next to it) was by default the 
same with the account's option you choose to do the new account action.
And the guide mentions it clearly, but i thought that was been selected by 
default.

Maybe i read to much for one day...

Really thank you all of you guys, for the help, quick reaction and the friendly 
atmosphere!

Have a great day!

10 Φεβ 2022 01:02:20 David Carlson :

> As Fred hinted, the Account type box where you need to select security (in 
> English?) is on the lower left, not near the top or right where you might 
> expect to see it.
> 
> On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:
>> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>> 
>>> And how i can set it in stock?
>> 
>> The "Account Type" dropdown is at the bottom left of the "New Account"
>> window, which I think is the one you showed (part of) in your original
>> message. You will probably need to scroll down to find the entry for
>> "Stock". You need to do this before clicking "Select", and then you will
>> get a "Select security" window instead of "Select currency".
>> 
>> Sorry for not making this clear earlier: I thought it was mentioned in
>> the documentation.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 
> -- 
> David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[David Carlson]

As Fred hinted, the Account type box where you need to select security (in
English?) is on the lower left, not near the top or right where you might
expect to see it.

On Wed, Feb 9, 2022 at 4:26 PM Fred Bone  wrote:

> On 09 February 2022 at 20:47, Κωνσταντίνος said:
>
> > And how i can set it in stock?
>
> The "Account Type" dropdown is at the bottom left of the "New Account"
> window, which I think is the one you showed (part of) in your original
> message. You will probably need to scroll down to find the entry for
> "Stock". You need to do this before clicking "Select", and then you will
> get a "Select security" window instead of "Select currency".
>
> Sorry for not making this clear earlier: I thought it was mentioned in
> the documentation.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[Fred Bone]

On 09 February 2022 at 20:47, Κωνσταντίνος said:

> And how i can set it in stock?

The "Account Type" dropdown is at the bottom left of the "New Account" 
window, which I think is the one you showed (part of) in your original 
message. You will probably need to scroll down to find the entry for 
"Stock". You need to do this before clicking "Select", and then you will 
get a "Select security" window instead of "Select currency".

Sorry for not making this clear earlier: I thought it was mentioned in 
the documentation.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[Κωνσταντίνος]

And how i can set it in stock?

(No accounting to the ancient greek lessons... what a same! Haha Yeah, 
translating accounting is difficult. Thankfully i had some lessons at the 
universe so it is easier to understand the ngucash. Ευχαριστώ/thanks!).

9 Φεβ 2022 22:35:03 Fred Bone :

> On 09 February 2022 at 19:16, Κωνσταντίνος said:
> 
>> Hello, 
>> I am glad that I am starting using the Gnucash. I read the guide and
>> seams quite easy and friendly to use.  My question is about the stock
>> entries.  
>> 
>> In the guide  
>> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-se
>> tup-stockaccounts2  it is clearly what it needs, but when I go to the
>> Gnucash I can’t find other option than currency for the type of the
>> stock. 
> 
> You need to make sure the "account type" is set to "stock", first. Sorry
> I don't know this in Greek (I did do Ancient Greek at school, many years
> ago, but the syllabus strangely omitted any mention of accounting).
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[Fred Bone]

On 09 February 2022 at 19:16, Κωνσταντίνος said:

> Hello, 
> I am glad that I am starting using the Gnucash. I read the guide and
> seams quite easy and friendly to use.  My question is about the stock
> entries.  
> 
> In the guide  
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-se
> tup-stockaccounts2  it is clearly what it needs, but when I go to the
> Gnucash I can’t find other option than currency for the type of the
> stock. 

You need to make sure the "account type" is set to "stock", first. Sorry 
I don't know this in Greek (I did do Ancient Greek at school, many years 
ago, but the syllabus strangely omitted any mention of accounting).

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about stock entry

[Derek Atkins]

HI,

On Wed, February 9, 2022 2:16 pm, Κωνσταντίνος wrote:
> Hello, 
> I am glad that I am starting using the Gnucash. I read the guide and seams
> quite easy and friendly to use. 
> My question is about the stock entries.  
>
> In the guide  
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-setup-stockaccounts2
>  
> it is clearly what it needs, but when I go to the Gnucash I can’t find
> other option than currency for the type of the stock. 
>
> What supposes to be shown…
>   [cid:f7328306-5524-425a-b076-2a89de6a8cd5] 
>
>  ...and that is shown
>  [cid:da7d58e4-b612-4195-b92b-68d61da7217a]
>  
> Can you tell me what to do to have the other option than currency?  

You need to change the account type to either Stock or Mutual first, and
only then will you be able to select a commodity that is not a currency.

> Few translation to be easier for you:
> Μετοχή= Stock 
> Τύπος= Type 
> Νομίσματα= Currency  
>
> Thank you in advance, 

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on Parent Accounts

[R. Victor Klassen]

1) Create the new account: presumably Expenses:Cost of Goods Sold 
2) Optionally (recommended for parent accounts) make it a placeholder account
3) Edit any accounts that are to become children of this one.  When you create 
or edit an account, there’s an option near the bottom of the pop-up to specify 
the parent account.
4) Optionally create any further children accounts, specifying this one as 
parent.

> On Jan 14, 2022, at 5:37 PM, Brad Weibel  wrote:
> 
> Need to have a new parent account (Cost of Goods Sold) … not able to 
> determine how to go about setting  up a new parent account
> 
> Sent from Mail for Windows
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on opening files

[Charles Vincent]

Thank you to colleagues. Problem resolved. I am not quite sure what I did
but the concerned file is opening and not minimizing.
Have a great 2022!


*Charles *




On Thu, Dec 30, 2021 at 5:42 PM Gyle McCollam  wrote:

> He was referring to the Windows 10/11 icon.  If you right-click on the
> gnucash icon, you should see 3 options: Gnucash, unpin from taskbar, and
> close all windows.  Then, if you right-click on the Gnucash, the last
> option should be "properties".  Left Click properties.  In the Gnucash
> properties near the bottom is a run option.  The three selections are:
> "Normal Window, Minimized, Maximized".  It probably has minimized
> selected as the option.
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> --
> *From:* Charles Vincent 
> *Sent:* Thursday, December 30, 2021 11:16 AM
> *To:* Glenn Fowler 
> *Cc:* Gyle McCollam ; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Question on opening files
>
> Thanks.
> Some files open without problems but some do not.
> Which properties are you referring to? In gnucash or generally ?
>
> Charles VINCENT
> Membre fondateur et ancien président du Conseil d'Administration
>
> Ecole Française de Battambang
>
> +33 6 7082 0475 (Mobile & WhattsApp)
> +855 12 635612 (Telegram)
>
> www.ecolefrancaisedebattambang.org
>
> On Tue, Dec 28, 2021, 16:36 Glenn Fowler  wrote:
>
> Are you possibility opening from a desktop shortcut? If so, right click >
> Properties and make sure Minimized is not selected in "Run" as shows in the
> attached screenshot.
>
>
> On Tue, Dec 28, 2021 at 10:30 AM Charles Vincent <
> memb...@ecolefrancaisedebattambang.org> wrote:
>
> Repeating copying...
>
> Windows10.  I just opened up a file just sent to me without problems. It
> appears to affect older files, ( the one I need was saved in March 2021).
>
>
> *Charles *
>
>
>
>
> On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam  wrote:
>
> > Charles, Question, what operating system are you using?
> >
> > Thank You,
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.comemail
> > --
> > *From:* gnucash-user 
> > on behalf of Charles Vincent 
> > *Sent:* Tuesday, December 28, 2021 10:17 AM
> > *To:* gnucash-user@gnucash.org 
> > *Subject:* [GNC] Question on opening files
> >
> > For the last few weeks, i have noticed that some gnucash files which I
> had
> > saved open but are minimized and cannot be restored maximized. Anyone
> else
> > encountering this issue and any suggestions?
> > Thank you
> >
> >
> > *Charles *
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on opening files

[Gyle McCollam]

He was referring to the Windows 10/11 icon.  If you right-click on the gnucash 
icon, you should see 3 options: Gnucash, unpin from taskbar, and close all 
windows.  Then, if you right-click on the Gnucash, the last option should be 
"properties".  Left Click properties.  In the Gnucash properties near the 
bottom is a run option.  The three selections are: "Normal Window, Minimized, 
Maximized".  It probably has minimized selected as the option.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: Charles Vincent 
Sent: Thursday, December 30, 2021 11:16 AM
To: Glenn Fowler 
Cc: Gyle McCollam ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Question on opening files

Thanks.
Some files open without problems but some do not.
Which properties are you referring to? In gnucash or generally ?

Charles VINCENT
Membre fondateur et ancien président du Conseil d'Administration

Ecole Française de Battambang

+33 6 7082 0475 (Mobile & WhattsApp)
+855 12 635612 (Telegram)

www.ecolefrancaisedebattambang.org<http://www.ecolefrancaisedebattambang.org>

On Tue, Dec 28, 2021, 16:36 Glenn Fowler 
mailto:gfowl...@outlook.com>> wrote:
Are you possibility opening from a desktop shortcut? If so, right click > 
Properties and make sure Minimized is not selected in "Run" as shows in the 
attached screenshot.


On Tue, Dec 28, 2021 at 10:30 AM Charles Vincent 
mailto:memb...@ecolefrancaisedebattambang.org>>
 wrote:
Repeating copying...

Windows10.  I just opened up a file just sent to me without problems. It
appears to affect older files, ( the one I need was saved in March 2021).


*Charles *




On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:

> Charles, Question, what operating system are you using?
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@live.com> 
> mailto:gmccol...@gyleshomes.com>>   email
> --
> *From:* gnucash-user 
> mailto:gmail@gnucash.org>>
> on behalf of Charles Vincent 
> mailto:memb...@ecolefrancaisedebattambang.org>>
> *Sent:* Tuesday, December 28, 2021 10:17 AM
> *To:* gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> 
> mailto:gnucash-user@gnucash.org>>
> *Subject:* [GNC] Question on opening files
>
> For the last few weeks, i have noticed that some gnucash files which I had
> saved open but are minimized and cannot be restored maximized. Anyone else
> encountering this issue and any suggestions?
> Thank you
>
>
> *Charles *
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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<mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on opening files

[Glenn Fowler]

Are you possibility opening from a desktop shortcut? If so, right click >
Properties and make sure Minimized is not selected in "Run" as shows in the
attached screenshot.


On Tue, Dec 28, 2021 at 10:30 AM Charles Vincent <
memb...@ecolefrancaisedebattambang.org> wrote:

> Repeating copying...
>
> Windows10.  I just opened up a file just sent to me without problems. It
> appears to affect older files, ( the one I need was saved in March 2021).
>
>
> *Charles *
>
>
>
>
> On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam  wrote:
>
> > Charles, Question, what operating system are you using?
> >
> > Thank You,
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.comemail
> > --
> > *From:* gnucash-user 
> > on behalf of Charles Vincent 
> > *Sent:* Tuesday, December 28, 2021 10:17 AM
> > *To:* gnucash-user@gnucash.org 
> > *Subject:* [GNC] Question on opening files
> >
> > For the last few weeks, i have noticed that some gnucash files which I
> had
> > saved open but are minimized and cannot be restored maximized. Anyone
> else
> > encountering this issue and any suggestions?
> > Thank you
> >
> >
> > *Charles *
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on opening files

[Charles Vincent]

Repeating copying...

Windows10.  I just opened up a file just sent to me without problems. It
appears to affect older files, ( the one I need was saved in March 2021).


*Charles *




On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam  wrote:

> Charles, Question, what operating system are you using?
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of Charles Vincent 
> *Sent:* Tuesday, December 28, 2021 10:17 AM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] Question on opening files
>
> For the last few weeks, i have noticed that some gnucash files which I had
> saved open but are minimized and cannot be restored maximized. Anyone else
> encountering this issue and any suggestions?
> Thank you
>
>
> *Charles *
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question on opening files

[Gyle McCollam]

Charles, Question, what operating system are you using?


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Charles Vincent 
Sent: Tuesday, December 28, 2021 10:17 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] Question on opening files

For the last few weeks, i have noticed that some gnucash files which I had
saved open but are minimized and cannot be restored maximized. Anyone else
encountering this issue and any suggestions?
Thank you


*Charles *
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question from newbie

[Jean-David Beyer via gnucash-user]

On 11/7/21 05:42, Michael Hendry wrote:

I’m assuming a “head check” is what we in the UK would call a post-dated cheque 
- a cheque which can’t be cashed until a stated date; for what it’s worth, I 
understand that banks in the UK will often make the payment if the cheque is 
presented early.


As far as I can tell, here in the USA, checks are seldom seen by human 
eyes. The MICR scanner reads the account number and a 
character-recognitian scanner tries to read the amount. Only if that 
faiul does a human being try to read the amount. Consequently, 
post-dating a check is usually ignored.


It also was a custom for a bank not to cash a check over 90 days old, 
but that is not always happens either.


With a post office as bad as here in USA, more and more checks do not 
make it to their destination. The worst recent case for me was a check 
mailed inside the post office to a post office box in the same post 
office that was returned months later from another post office, saying 
there was no such post office box.


--
  .~.  Jean-David Beyer
  /V\  Shrewsbury, New Jersey
 /( )\ Red Hat Enterprise Linux
 ^^-^^ up 2 days, 21 hours, 27 minutes
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question from newbie

[Doug]

Similar comment, by a non-accountant. What I do with transactions that are 
planned is to enter them when I place
 the forward transaction with the bank, & set the date as when the account will 
be paid (or transferred). 
I can always see the current day balance by looking at the dividing line on the 
account at todays date.
 Recurring expenses such as loan payments, periodical payments etc are copied 
using the duplicated transaction,
 then edited if required. This is handy for transactions with multiple splits 
(such as your pay if employed), 
where the amounts might change, but the splits remain fairly consistent (albeit 
with changed amounts).
eg in my case for deposited weekly pay (before I retired!) I had (to give an 
idea) Total pay> Income; Tax> Tax; Superannuation> Super; 
various benefits & payments such as Union fees> relevant accounts. By using a 
duplicated transaction, it is 
easier to remember exactly how the splits are distributed.
Hope that helps Mr Newbie!
regards, Doug 

On Sun, 7 Nov 2021 10:42:10 +
Michael Hendry  wrote:

> On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
> > 
> >   Hello there,
> >   'I'm having trouble on how to record buying groceries on Jan. 1  with a
> >   head check for Feb. 1
> >   What I understood from the manual that this is not an expense but a
> >   liablity but I don't understand if I should make two accounts one
> >   expense: grocery and one "liability: grocery" or some easier way to
> >   record this.
> >   Thank you very much for the help
> >   Shevach
> >   gif  
> 
> I’m assuming a “head check” is what we in the UK would call a post-dated 
> cheque - a cheque which can’t be cashed until a stated date; for what it’s 
> worth, I understand that banks in the UK will often make the payment if the 
> cheque is presented early.
> 
> I would suggest recording the expense on the date of the purchase as a 
> transaction between your checking account and the grocery store. If you wish, 
> you could add a note to indicate that the check can’t be presented until 1st 
> Feb to avoid confusion when reconciling the bank account.
> 
> It’s a similar situation to making a postal payment by check - you know that 
> the payee won’t receive it for several days and may not take it to the bank 
> for several days after that, but you’re recording your commitment to the 
> payee rather than the date on which the bank transfers the money to his 
> account.
> 
> I am not an accountant, but there are those on the list who will no doubt 
> correct me if there are problems with the way I view this!
> 
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question from newbie

[Michael Hendry]

On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
> 
>   Hello there,
>   'I'm having trouble on how to record buying groceries on Jan. 1  with a
>   head check for Feb. 1
>   What I understood from the manual that this is not an expense but a
>   liablity but I don't understand if I should make two accounts one
>   expense: grocery and one "liability: grocery" or some easier way to
>   record this.
>   Thank you very much for the help
>   Shevach
>   gif

I’m assuming a “head check” is what we in the UK would call a post-dated cheque 
- a cheque which can’t be cashed until a stated date; for what it’s worth, I 
understand that banks in the UK will often make the payment if the cheque is 
presented early.

I would suggest recording the expense on the date of the purchase as a 
transaction between your checking account and the grocery store. If you wish, 
you could add a note to indicate that the check can’t be presented until 1st 
Feb to avoid confusion when reconciling the bank account.

It’s a similar situation to making a postal payment by check - you know that 
the payee won’t receive it for several days and may not take it to the bank for 
several days after that, but you’re recording your commitment to the payee 
rather than the date on which the bank transfers the money to his account.

I am not an accountant, but there are those on the list who will no doubt 
correct me if there are problems with the way I view this!

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[R. Victor Klassen]

In our jurisdiction farms are permitted to choose whether to use cash or 
accrual, and there are various tax advantages to using cash-based.

Happily, December/January is the time of lightest business, so the difference 
isn’t huge when it comes to accounting.

I do find I need to unpost and re-post invoices (dated Dec 31) when they are 
issued but not paid; and similarly bills that are issued but not due (or paid) 
until after the year end I post with a January 1 date.

If and when I’m audited by the taxing authorities I explain what I’ve done and 
they’re good with it.

> On May 31, 2021, at 9:08 PM, Alan Hopkins  wrote:
> 
>   Hello Howard
>   I agree with both Michaels - you need to understand the difference
>   between accounting records & reports prepared on an accruals basis vs a
>   cash basis. You should do some reading on basic accounting.
>   GNUCash used for business uses the accrual basis - (invoices are
>   registered in accounts receivable, bills are registered in accounts
>   payable).  Depending on the number of invoices & bills involved, you
>   may find that you need to develop your own cash report on a
>   spreadsheet.
>   Some of these links may  be of help to you:
>   [1]https://www.accountingtools.com/articles/how-to-convert-accrual-basi 
> 
>   s-to-cash-basis-accounting.html
>   [2]https://www.bookstime.com/articles/accrual-to-cash-conversion 
> 
>   [3]https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual- 
> 
>   to-cash-conversion-excel-worksheet/
>   GNUCash is excellent software (a big thank you to the developers!) and
>   you can get more understanding of basic accounting and using the
>   business features by referring to the Tutorial & Concepts guide:
>   [4]https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide 
> 
>   I hope that is of some help to you
>   Cheers
>   Alan
> 
>   On 1/6/21 12:42 am, Michael Hendry wrote:
> 
> On 31 May 2021, at 15:10, Howard M. Fried [5] > wrote:
> 
> I have several invoices that were issued in 2020 but paid in 2021. These 
> funds a
> re not included in a P report for 2021, apparently because the report is 
> based
> on date of invoice issue, or have I missed something.
> 
> Is it possible to get the 2020 Sales that were paid in 2021 into the report 
> for
> 2021?  Simply extending the Report date range backward is not a solution 
> because
> many invoices that were issued and paid in 2020 will be included.  Or am I to 
> i
> nclude unrealized assets for 2020 as profit, like the P report does (I have 
> no
> accounting, financial, or legal experience in such matters).
> 
> Thank you for considering,
> Howard Fried
> 
> Not an accountant either, Howard, but I believe the approach varies according 
> to
> whether your books are kept on a cash or an accrual basis.
> 
> If cash, then reports are based on the date when you received income, or the 
> dat
> e you made a payment for expenses.
> 
> I don’t use the business features, but I think that you will be working on an 
> ac
> crual basis, and have reports on Accounts Receivable and Accounts Payable 
> which
> carry over the end of the financial year.
> 
> Michael
> 
> 
> ___
> gnucash-user mailing list
> [6]gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> [7]https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> [8]https://wiki.gnucash.org/wiki/Ma 
> iling_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> References
> 
>   1. 
> https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html
>  
> 
>   2. https://www.bookstime.com/articles/accrual-to-cash-conversion 
> 
>   3. 
> https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/
>  
> 
>   4. https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide 
> 
>   5. mailto:cursor...@gmail.com 
>   6. mailto:gnucash-user@gnucash.org 
>   7. https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 

Re: [GNC] Question about Profit-Loss Report

[Mahon Finbar]

All very understandable. It has always intrigued me how accountants deal 
with 'late payments' i.e. bills paid after the close of the year. If I 
understand the discussion, ongoing (accrual based) businesses are always 
behind when it comes to an analysis of the state of play, unless all 
invoices are paid within the accounting period? Is that why a cash based 
spreadsheet is needed?


Isn't it possible in GNU to 'clear' an entry when the amount is paid? 
Then it will appear in the reconciliation?


Just a question, I don't want to drag out the discussion.

On 01/06/2021 04:13, Howard M. Fried wrote:

On 5/31/21 9:08 PM, Alan Hopkins wrote:

Hello Howard

I agree with both Michaels - you need to understand the difference 
between
accounting records & reports prepared on an accruals basis vs a cash 
basis. You

should do some reading on basic accounting.

GNUCash used for business uses the accrual basis - (invoices are 
registered in
accounts receivable, bills are registered in accounts payable). 
Depending on
the number of invoices & bills involved, you may find that you need 
to develop

your own cash report on a spreadsheet.

Some of these links may  be of help to you:
https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html 

 


https://www.bookstime.com/articles/accrual-to-cash-conversion

https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/ 

 



GNUCash is excellent software (a big thank you to the developers!) 
and you can
get more understanding of basic accounting and using the business 
features by

referring to the Tutorial & Concepts guide:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide


I hope that is of some help to you

Cheers

Alan


Thank you Alan, and both Michaels.  I was an educator for 34 years 
before launching a second career as an Editor.  Clearly, I need to 
take up the role of student and learn some basic accounting methods.  
I will certainly examine the materials that you have so kindly provided.


Regards,
Howard


On 1/6/21 12:42 am, Michael Hendry wrote:

On 31 May 2021, at 15:10, Howard M. Fried  wrote:

I have several invoices that were issued in 2020 but paid in 2021. 
These funds are not included in a P report for 2021, apparently 
because the report is based on date of invoice issue, or have I 
missed something.


Is it possible to get the 2020 Sales that were paid in 2021 into 
the report for 2021?  Simply extending the Report date range 
backward is not a solution because many invoices that were issued 
and paid in 2020 will be included.  Or am I to include unrealized 
assets for 2020 as profit, like the P report does (I have no 
accounting, financial, or legal experience in such matters).


Thank you for considering,
Howard Fried
Not an accountant either, Howard, but I believe the approach varies 
according to whether your books are kept on a cash or an accrual basis.


If cash, then reports are based on the date when you received 
income, or the date you made a payment for expenses.


I don’t use the business features, but I think that you will be 
working on an accrual basis, and have reports on Accounts Receivable 
and Accounts Payable which carry over the end of the financial year.


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
If you are using Nabble or Gmane, please 
seehttps://wiki.gnucash.org/wiki/Mailing_Lists  for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Howard M. Fried]

On 5/31/21 9:08 PM, Alan Hopkins wrote:

Hello Howard

I agree with both Michaels - you need to understand the difference between
accounting records & reports prepared on an accruals basis vs a cash basis. You
should do some reading on basic accounting.

GNUCash used for business uses the accrual basis - (invoices are registered in
accounts receivable, bills are registered in accounts payable).  Depending on
the number of invoices & bills involved, you may find that you need to develop
your own cash report on a spreadsheet.

Some of these links may  be of help to you:
https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html

https://www.bookstime.com/articles/accrual-to-cash-conversion

https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/


GNUCash is excellent software (a big thank you to the developers!) and you can
get more understanding of basic accounting and using the business features by
referring to the Tutorial & Concepts guide:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide


I hope that is of some help to you

Cheers

Alan


Thank you Alan, and both Michaels.  I was an educator for 34 years 
before launching a second career as an Editor.  Clearly, I need to take 
up the role of student and learn some basic accounting methods.  I will 
certainly examine the materials that you have so kindly provided.


Regards,
Howard


On 1/6/21 12:42 am, Michael Hendry wrote:

On 31 May 2021, at 15:10, Howard M. Fried  wrote:

I have several invoices that were issued in 2020 but paid in 2021. These funds are 
not included in a P report for 2021, apparently because the report is based 
on date of invoice issue, or have I missed something.

Is it possible to get the 2020 Sales that were paid in 2021 into the report for 
2021?  Simply extending the Report date range backward is not a solution because 
many invoices that were issued and paid in 2020 will be included.  Or am I to 
include unrealized assets for 2020 as profit, like the P report does (I have 
no accounting, financial, or legal experience in such matters).

Thank you for considering,
Howard Fried

Not an accountant either, Howard, but I believe the approach varies according 
to whether your books are kept on a cash or an accrual basis.

If cash, then reports are based on the date when you received income, or the 
date you made a payment for expenses.

I don’t use the business features, but I think that you will be working on an 
accrual basis, and have reports on Accounts Receivable and Accounts Payable 
which carry over the end of the financial year.

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
If you are using Nabble or Gmane, please 
seehttps://wiki.gnucash.org/wiki/Mailing_Lists  for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Alan Hopkins]

   Hello Howard
   I agree with both Michaels - you need to understand the difference
   between accounting records & reports prepared on an accruals basis vs a
   cash basis. You should do some reading on basic accounting.
   GNUCash used for business uses the accrual basis - (invoices are
   registered in accounts receivable, bills are registered in accounts
   payable).  Depending on the number of invoices & bills involved, you
   may find that you need to develop your own cash report on a
   spreadsheet.
   Some of these links may  be of help to you:
   [1]https://www.accountingtools.com/articles/how-to-convert-accrual-basi
   s-to-cash-basis-accounting.html
   [2]https://www.bookstime.com/articles/accrual-to-cash-conversion
   [3]https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-
   to-cash-conversion-excel-worksheet/
   GNUCash is excellent software (a big thank you to the developers!) and
   you can get more understanding of basic accounting and using the
   business features by referring to the Tutorial & Concepts guide:
   [4]https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide
   I hope that is of some help to you
   Cheers
   Alan

   On 1/6/21 12:42 am, Michael Hendry wrote:

On 31 May 2021, at 15:10, Howard M. Fried [5] wrote:

I have several invoices that were issued in 2020 but paid in 2021. These funds a
re not included in a P report for 2021, apparently because the report is based
 on date of invoice issue, or have I missed something.

Is it possible to get the 2020 Sales that were paid in 2021 into the report for
2021?  Simply extending the Report date range backward is not a solution because
 many invoices that were issued and paid in 2020 will be included.  Or am I to i
nclude unrealized assets for 2020 as profit, like the P report does (I have no
 accounting, financial, or legal experience in such matters).

Thank you for considering,
Howard Fried

Not an accountant either, Howard, but I believe the approach varies according to
 whether your books are kept on a cash or an accrual basis.

If cash, then reports are based on the date when you received income, or the dat
e you made a payment for expenses.

I don’t use the business features, but I think that you will be working on an ac
crual basis, and have reports on Accounts Receivable and Accounts Payable which
carry over the end of the financial year.

Michael


___
gnucash-user mailing list
[6]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[7]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see [8]https://wiki.gnucash.org/wiki/Ma
iling_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

References

   1. 
https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html
   2. https://www.bookstime.com/articles/accrual-to-cash-conversion
   3. 
https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/
   4. https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide
   5. mailto:cursor...@gmail.com
   6. mailto:gnucash-user@gnucash.org
   7. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   8. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Howard M. Fried]

On 5/31/21 10:42 AM, Michael Hendry wrote:

On 31 May 2021, at 15:10, Howard M. Fried  wrote:

I have several invoices that were issued in 2020 but paid in 2021. These funds are 
not included in a P report for 2021, apparently because the report is based 
on date of invoice issue, or have I missed something.

Is it possible to get the 2020 Sales that were paid in 2021 into the report for 
2021?  Simply extending the Report date range backward is not a solution because 
many invoices that were issued and paid in 2020 will be included.  Or am I to 
include unrealized assets for 2020 as profit, like the P report does (I have 
no accounting, financial, or legal experience in such matters).

Thank you for considering,
Howard Fried


Not an accountant either, Howard, but I believe the approach varies according 
to whether your books are kept on a cash or an accrual basis.

If cash, then reports are based on the date when you received income, or the 
date you made a payment for expenses.

I don’t use the business features, but I think that you will be working on an 
accrual basis, and have reports on Accounts Receivable and Accounts Payable 
which carry over the end of the financial year.

Michael


Thank you Michael.  I'm a one-person business with one service 
(manuscript editing).  It never occurred to me that any method other 
than cash would be the way to go, and I just blindly set up my GnuCash 
account without thinking about it.  This year is the first in which the 
issuance and payment of invoices spanned two years.  I'll have to 
remember to add those funds come tax time.  Will have to check expenses 
as well.


Cheers,
Howard
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Michael Hendry]

> On 31 May 2021, at 15:10, Howard M. Fried  wrote:
> 
> I have several invoices that were issued in 2020 but paid in 2021. These 
> funds are not included in a P report for 2021, apparently because the 
> report is based on date of invoice issue, or have I missed something.
> 
> Is it possible to get the 2020 Sales that were paid in 2021 into the report 
> for 2021?  Simply extending the Report date range backward is not a solution 
> because many invoices that were issued and paid in 2020 will be included.  Or 
> am I to include unrealized assets for 2020 as profit, like the P report 
> does (I have no accounting, financial, or legal experience in such matters).
> 
> Thank you for considering,
> Howard Fried

Not an accountant either, Howard, but I believe the approach varies according 
to whether your books are kept on a cash or an accrual basis.

If cash, then reports are based on the date when you received income, or the 
date you made a payment for expenses.

I don’t use the business features, but I think that you will be working on an 
accrual basis, and have reports on Accounts Receivable and Accounts Payable 
which carry over the end of the financial year.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about Profit-Loss Report

[Michael or Penny Novack]

On 5/31/2021 10:10 AM, Howard M. Fried wrote:
I have several invoices that were issued in 2020 but paid in 2021. 
These funds are not included in a P report for 2021, apparently 
because the report is based on date of invoice issue, or have I missed 
something.


Is it possible to get the 2020 Sales that were paid in 2021 into the 
report for 2021?  Simply extending the Report date range backward is 
not a solution because many invoices that were issued and paid in 2020 
will be included.  Or am I to include unrealized assets for 2020 as 
profit, like the P report does (I have no accounting, financial, or 
legal experience in such matters).


Thank you for considering,
Howard Fried 



This is less of a gnucash question than a fundamentals of bookkeeping 
question. You need to look up/understand the essential differences 
between books kept on the "cash basis" and books kept under the "accrual 
basis".


You mention "invoice" and that means that you are using "accrual basis" 
since gnucash only supports invoices when using the "business features" 
and that means accrual basis. However it appears that you want want a 
P report on the cash basis << transactions dated as of when cash 
received or cash paid).


I will repeat, using software to partially automate your accounting does 
not mean that you can skip learning some of the fundamentals. This is 
especially true if you want/need reports both on the accrual basis and 
the cash basis.  Doing and undoing the adjustments you would need for 
that not easy.



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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[Michael or Penny Novack]

On 5/29/2021 10:28 PM, flywire wrote:

If most transactions are to be moved to one account it can be worth renaming
the account and moving out the other transactions.



Good advice. When splitting an account (one account becomes two) a 
little planning ahead can greatly reduce the amount of work, especially 
if it is the bulk of the transactions that will be moved to the new 
account.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[flywire]

If most transactions are to be moved to one account it can be worth renaming
the account and moving out the other transactions.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[Chris Good]

Message: 1
> Date: Sat, 29 May 2021 10:32:25 -0500
> From: David Carlson 
> To: DaveC49 
> Cc: Gnucash Users 
> Subject: Re: [GNC] question - how do I move one or more transactions
>   between accounts?
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
> 
> The method described by DaveC49 is about the only practical way to do it.
> 
> However,  if you want to change the account for a split line from the
> current account to a different account,  it is faster to first jump to one
> of the other accounts in that transaction before changing.   Changing the
> "home" is much slower, and waiting for the transaction to disappear is a
> pain in the neck.
> 
>> On Sat, May 29, 2021, 5:13 AM DaveC49  wrote:
>> To move one split of  a transaction from one account to another if you edit
>> the transaction in the register for the account of the split which is going
>> to be unchanged. A all you have to do is change the account in the Account
>> column. Delete the existing selected account and you should get a drop down
>> list which will allow you to select the new account for the split. There is
>> no bulk cut and paste type operation AFAIK.

Hi David Carlson,

There is no waiting for the “transaction to disappear” on my i7 computer with 
an ssd and 16 GB ram.

Regards, Chris Good
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[David Carlson]

The method described by DaveC49 is about the only practical way to do it.

However,  if you want to change the account for a split line from the
current account to a different account,  it is faster to first jump to one
of the other accounts in that transaction before changing.   Changing the
"home" is much slower, and waiting for the transaction to disappear is a
pain in the neck.

On Sat, May 29, 2021, 5:13 AM DaveC49  wrote:

> To move one split of  a transaction from one account to another if you edit
> the transaction in the register for the account of the split which is going
> to be unchanged. A all you have to do is change the account in the Account
> column. Delete the existing selected account and you should get a drop down
> list which will allow you to select the new account for the split. There is
> no bulk cut and paste type operation AFAIK.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[Michael or Penny Novack]

On 5/29/2021 5:02 AM, s310...@gmail.com wrote:

hi,

I want to re-organize my transactions into the correct accounts.
I know I can "CUT" from the original account and "PASTE" in the destination
account.
It takes a lot of work.

Is there a way to select the required transactions and do a "move" instead?

Shay


With double entry bookkeeping each transaction affects at least two 
account. Understand? A transaction is never "in" just one account.


"How do I change one of these accounts?" Open the transaction in the 
other account. In edit transaction mode, respecify the other account..If 
the error was in a slit transaction, find it in any of the other 
account, enter split mode, and respecify the one that is wrong.


"How do I change both accounts? Do the previous process twice, fix 
one, then from that account, fix the other.


"How do I do this according to more formal bookkeeping procedures?"    
In more formal bookkeeping, once entered, a transaction is never 
altered. I am not talking about wile you were working, but when 
correcting at some later date. Instead, you enter a transaction to 
correct the account making it clear what you are doing in the description.


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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question - how do I move one or more transactions between accounts?

[DaveC49]

To move one split of  a transaction from one account to another if you edit
the transaction in the register for the account of the split which is going
to be unchanged. A all you have to do is change the account in the Account
column. Delete the existing selected account and you should get a drop down
list which will allow you to select the new account for the split. There is
no bulk cut and paste type operation AFAIK.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[Adrian Yong]

Thanks Liz..

Very valid point... I don't have much problems with GNUcash...

On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd  wrote:

> On Mon, 22 Jun 2020 20:06:05 +0800
> Adrian Yong  wrote:
>
> > As Gnucash is still under development,
>
> This is a place to point out a difference in view points.
>
> Lots of software is still under development. Most commercial software
> is, so that they can sell you a new version, rather than just an offer
> to give you new features.
>
> Gnucash for Android is not under development, and that's not a good
> thing, as it appears to be abandoned, and no updates will come.
>
> Every time there are updates, some users have some problems. For many
> that marks the first time they come to this mailing list for advice.
> You already know about us, and can ask what you need to know.
>
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[Liz Dodd]

On Mon, 22 Jun 2020 20:06:05 +0800
Adrian Yong  wrote:

> As Gnucash is still under development,

This is a place to point out a difference in view points.

Lots of software is still under development. Most commercial software
is, so that they can sell you a new version, rather than just an offer
to give you new features.

Gnucash for Android is not under development, and that's not a good
thing, as it appears to be abandoned, and no updates will come.

Every time there are updates, some users have some problems. For many
that marks the first time they come to this mailing list for advice.
You already know about us, and can ask what you need to know.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[Adrien Monteleone]

Zi,

Welcome to GnuCash!

The answer is ‘yes, sort of’.

While it doesn’t have an explicit class facility, you can make up your own 
tagging and filtering system.

Specific to your example, each transaction can have multiple splits, that isn’t 
an issue at all.

Each split has a ‘memo’ line where you can describe the split.

Additionally, each transaction has a Description (payee if you like) *and* a 
Notes field right under the Description. You have to turn on View > Double Line 
to see it and use it.

My personal preference is to use Description for payee, Notes for a general 
transaction description or info, and the Memos as descriptions specific to each 
split.

You also have a NUM field, which may or may not be useful with text for you. 
The ‘official’ purpose for it is something like Check#, so consider that 
accordingly if you record check or bank transaction#s.

For each split, there is also an Action field that can be used. By default it 
is a physically small column, but can hold more than one word.

So you can have a single Utility transaction with splits for each property.

Read the earlier reply I sent in response to Adrian. I outline a basic method 
for tagging info and how to filter or search for it with reports. You could use 
Unit#s or street names, etc. as your tags.

Note, this won’t give you a P with breakouts as-is. It will allow you to run 
a P for each property separately.

If you want a combination or break-out style report, you’ll need to run the 
reports that get you the data, then export to a spreadsheet app and re-combine 
them from there. (or code the reports from scratch)

What you are looking for is possible, just not obvious. (even from the docs)

Regards,
Adrien


> On Jun 21, 2020 w26d173, at 2:18 PM, Zi via gnucash-user 
>  wrote:
> 
> Hi
> 
> I've used QuickBooks for years and am seriously considering finding a 
> (*non*web based) alternative. GnuCash looks very promising, but here's the 
> million-dollar question (and yes, I browsed the whole site, the manual, the 
> FAQ, etc. trying to find an answer to this question!)
> 
> In addition to the accounts and sub-accounts that inform reconciliation and 
> P type reporting, is there a way to *class* transactions the way QuickBooks 
> does? In other words, can one, while entering a transaction, enter something 
> like the following:
> 
> (vendor) Local Electricity Provider
> (amount) $ total amount of bill
> (split line one account) "utilities" AND THEN
> (*class*) address of investment property and unit #
> (split $ amount for this property)
> (split line two account) "utilities"
> (*class*) address of *other* investment property and unit #
> (split $ amount for *that* property)
> etc.
> thus allowing a property manager to show expenditures around *each 
> particular* property.
> 
> OR for instance one travels sometimes, and needs to record the expenses.
> Like, the appropriate transaction accounts for such would include "meals", 
> "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix 
> 2019" thus giving one a way to show the expenditures for a *particular* trip.
> 
> If GnuCash provides this functionality, I will likely switch over to it! If, 
> however, it does not, Intuit must, sadly, still win.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[Adrien Monteleone]

While there is no official ‘class’ or ’tag’ facility, you can still accomplish 
this somewhat.

You can do searches on any text located in any text field, Description, Memo, 
Notes, Action, Num, etc.

Thus you can create your own tagging system using # or @ if you like. (or any 
other symbol or even emoji as those are now supported)

Most reports have a Filter option where you can only report transactions that 
match (or exclude) the Filter text. Unfortunately, the report filtering only 
works for Description, Notes, and Memo fields.

Both Edit > Find & (report) Options > Filter allow regular expressions.

--

Concerning the ‘finding files’ threads, those all have been user issues. 
GnuCash hasn’t been eating data. (though you should always have a backup 
available for *any* important data for *any* app.)

I’ve been stepping through 3.0-3.10 and with the exception of a display 
discrepancy back at 3.1, I haven’t had any major issues. (plenty of small, 
minor bugs, but that is to be expected, and most of them were quickly fixed 
after reporting)

Of course, upgrade at your own pace. I believe the official policy is to 
support the current and most recent major version. So after 4.0 is out only the 
3.x series will continue to be ’supported’ but I don’t think you’ll see any 
additional 3.x releases to fix bugs. The wiki has more info on this.

Regards,
Adrien

> On Jun 22, 2020 w26d174, at 7:06 AM, Adrian Yong 
>  wrote:
> 
> Hi Zi,
> 
> I was a QB user as well and have recently switched to Gnucash...
> 
> I have tried splitting expenses claims like Quit Rent & Assessment as an
> expense claim but split into Quit Rent and Assessment as separate Expenses
> in P & L...
> 
> The one thing which I have trouble with is the General Ledger which QB
> lists the opening and closing balances and all the transactions in between
> for individual ledger accounts... In Gnucash, you won't get that but the
> argument is we enter data using a double entry procedure, so *assuming that
> the transactions are entered correctly,* the opening and closing balance
> should be reflected in the Account Tree or Balance Sheet...
> 
> As I am not super confident that the transactions are entered correctly, I
> do have a problem with this...
> 
> As Gnucash is still under development, there are a lot of updates and I am
> hearing of people having difficulties in locating their files after
> updating... I think the current version is 3.10 and I am on 3.x... I have
> this fear of updating to 3.10... Maybe I will do it after my auditors
> confirmed that they have got everything they need...

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[D. via gnucash-user]

Zi,

Welcome to the world of GnuCash. As a user of GnuCash for nearly 15 years, I 
can tell you that it's a feature-rich application with a great user community.

Unfortunately, "classes" is not one of those features. It has been discussed 
for as long as I can remember (e.g., 
https://lists.gnucash.org/pipermail/gnucash-user/2001-October/002612.html, 
https://lists.gnucash.org/pipermail/gnucash-user/2007-July/020856.html, 
https://lists.gnucash.org/pipermail/gnucash-user/2010-December/037498.html), 
and users have an established request for it to be added (see 
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1543027-transaction-classifications).

The developers are aware of these requests and discussions, but have not to 
date found time to implement the feature. Since this is a volunteer-run open 
source project, we accept both the limitations of the program and the input of 
interested parties who may be able to add a given feature such as this to the 
program. Examining the threads through the years will yield a number of 
workarounds that users have cobbled together. 

Despite its limitations, GnuCash remains for me a powerful and useful program. 
I heartily recommend it. 

David T. 


 Original Message 
From: Zi via gnucash-user 
Sent: Sun Jun 21 15:18:25 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

Hi

I've used QuickBooks for years and am seriously considering finding a (*non*web 
based) alternative. GnuCash looks very promising, but here's the million-dollar 
question (and yes, I browsed the whole site, the manual, the FAQ, etc. trying 
to find an answer to this question!)

In addition to the accounts and sub-accounts that inform reconciliation and P 
type reporting, is there a way to *class* transactions the way QuickBooks does? 
In other words, can one, while entering a transaction, enter something like the 
following:

(vendor) Local Electricity Provider
(amount) $ total amount of bill
(split line one account) "utilities" AND THEN
(*class*) address of investment property and unit #
(split $ amount for this property)
(split line two account) "utilities"
(*class*) address of *other* investment property and unit #
(split $ amount for *that* property)
etc.
thus allowing a property manager to show expenditures around *each particular* 
property.

OR for instance one travels sometimes, and needs to record the expenses.
Like, the appropriate transaction accounts for such would include "meals", 
"lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix 
2019" thus giving one a way to show the expenditures for a *particular* trip.

If GnuCash provides this functionality, I will likely switch over to it! If, 
however, it does not, Intuit must, sadly, still win.

Thanks so much!

Sent from ProtonMail mobile
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

[Adrian Yong]

Hi Zi,

I was a QB user as well and have recently switched to Gnucash...

I have tried splitting expenses claims like Quit Rent & Assessment as an
expense claim but split into Quit Rent and Assessment as separate Expenses
in P & L...

The one thing which I have trouble with is the General Ledger which QB
lists the opening and closing balances and all the transactions in between
for individual ledger accounts... In Gnucash, you won't get that but the
argument is we enter data using a double entry procedure, so *assuming that
the transactions are entered correctly,* the opening and closing balance
should be reflected in the Account Tree or Balance Sheet...

As I am not super confident that the transactions are entered correctly, I
do have a problem with this...

As Gnucash is still under development, there are a lot of updates and I am
hearing of people having difficulties in locating their files after
updating... I think the current version is 3.10 and I am on 3.x... I have
this fear of updating to 3.10... Maybe I will do it after my auditors
confirmed that they have got everything they need...

Regards,
Adrian

On Mon, 22 Jun. 2020, 17:52 Zi via gnucash-user, 
wrote:

> Hi
>
> I've used QuickBooks for years and am seriously considering finding a
> (*non*web based) alternative. GnuCash looks very promising, but here's the
> million-dollar question (and yes, I browsed the whole site, the manual, the
> FAQ, etc. trying to find an answer to this question!)
>
> In addition to the accounts and sub-accounts that inform reconciliation
> and P type reporting, is there a way to *class* transactions the way
> QuickBooks does? In other words, can one, while entering a transaction,
> enter something like the following:
>
> (vendor) Local Electricity Provider
> (amount) $ total amount of bill
> (split line one account) "utilities" AND THEN
> (*class*) address of investment property and unit #
> (split $ amount for this property)
> (split line two account) "utilities"
> (*class*) address of *other* investment property and unit #
> (split $ amount for *that* property)
> etc.
> thus allowing a property manager to show expenditures around *each
> particular* property.
>
> OR for instance one travels sometimes, and needs to record the expenses.
> Like, the appropriate transaction accounts for such would include "meals",
> "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or
> "Phoenix 2019" thus giving one a way to show the expenditures for a
> *particular* trip.
>
> If GnuCash provides this functionality, I will likely switch over to it!
> If, however, it does not, Intuit must, sadly, still win.
>
> Thanks so much!
>
> Sent from ProtonMail mobile
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Adrien Monteleone]

That’s the beauty of a mailing list - I forgot all about that option.

Thanks!

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 6:56 AM, pobox.d...@outlook.in wrote:
> 
> Gio,
> 
> I had the same problem with my invoice report a while ago whereby my INR 
> currency symbol was displayed as question marks. Adrien helped with some CSS 
> styling code (which I had to put on the Notes tab in Embedded CSS box). After 
> I put this snippet there, it all works fine now.
> 
> h1.coyname { text-align: left; }
> * { font-family: Helvetica; }
> 
> You can try with a font-family name of your choice to see if that helps.
> 
> Cheers.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Adrien Monteleone]

You *might* be able to find that info by running the GTKInspector. There is a 
panel that will show you the current values of various UI elements. But no 
guarantee it will show you the actual font used rather than just a declaration. 
It’s worth a shot I suppose if it is really important to tweak.

That might be considered an RFE. If GnuCash specified a font family (not just 
one) that has all the currency symbols then it is unlikely anyone would ever 
come across this issue.

Glad to hear you solved it.

Regards,
Adrien

> On Jun 19, 2020 w25d171, at 6:47 AM, Gio Bacareza  wrote:
> 
> I finally solved it! Thank you Adrien. I followed your lead and examined the 
> style sheets. There I found out that the default style sheets has Fonts set 
> to NONE. I still don't quite understand what default font GNUCASH defaults to 
> if it is set at NONE but I experimented and created my own style sheet and 
> explicitly specified a font. It worked! Thanks Adrien.
> 
> I'm just curious. What font does it default to if it's set to NONE? Thanks
> 
> On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone 
>  wrote:
> Also, are you using a custom/modified stylesheet for the report with a 
> different font for the totals?
> 
> Regards,
> Adrien
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[John Ralls]

Hard to tell for reports, that would be up to webkit and while I found where 
it's set in the webkit source I don't see any default value there. Gtk's 
default on MacOS is SystemDefaultFont (San Francisco on El Cap and later) 12pt.

Regards,
John Ralls


> On Jun 19, 2020, at 4:47 AM, Gio Bacareza  wrote:
> 
> I finally solved it! Thank you Adrien. I followed your lead and examined
> the style sheets. There I found out that the default style sheets has Fonts
> set to NONE. I still don't quite understand what default font GNUCASH
> defaults to if it is set at NONE but I experimented and created my own
> style sheet and explicitly specified a font. It worked! Thanks Adrien.
> 
> I'm just curious. What font does it default to if it's set to NONE? Thanks
> 
> On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> Also, are you using a custom/modified stylesheet for the report with a
>> different font for the totals?
>> 
>> Regards,
>> Adrien
>> 
>>> On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
>> christopher@gmail.com> wrote:
>>> 
>>> The only technical difference between regular lines and total lines is
>> that
>>> the latter is in bold. Try checking your font for bold symbol?
>>> 
>>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
>>> 
 it now shows up in the reports but the total is still a question mark.
>> see
 screenshot below
 [image: image.png]
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> -- 
> cheers,
> 
> Gio
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[pobox . deva]

Gio,

I had the same problem with my invoice report a while ago whereby my INR 
currency symbol was displayed as question marks. Adrien helped with some CSS 
styling code (which I had to put on the Notes tab in Embedded CSS box). After I 
put this snippet there, it all works fine now.

h1.coyname { text-align: left; }
* { font-family: Helvetica; }

You can try with a font-family name of your choice to see if that helps.

Cheers.

> On 19-Jun-2020, at 3:59 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 19 Jun 2020 18:29:38 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: Christopher Lam  <mailto:christopher@gmail.com>>
> Cc: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Question marks instead of currency in reports
> Message-ID:
><mailto:CAEC3bMTFHBr8=xdnsysv+r3ztljnnadvnd3xeongc-l2frf...@mail.gmail.com>>
> Content-Type: text/plain; charset="utf-8"
> 
> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]
> 
> On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam  <mailto:christopher@gmail.com>>
> wrote:
> 
>> The only technical difference between regular lines and total lines is
>> that the latter is in bold. Try checking your font for bold symbol?
>> 
>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, > <mailto:gbacar...@gmail.com>> wrote:
>> 
>>> it now shows up in the reports but the total is still a question mark. see
>>> screenshot below
>>> [image: image.png]
>>> 
>>> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza >> <mailto:gbacar...@gmail.com>> wrote:
>>> 
>>>> Hi Adrien and others,
>>>> 
>>>> I checked the character viewer and Peso is confirmed to be there
>>> available
>>>> in various fonts including Apple Symbols collection. See screenshot.
>>>> [image: image.png]
>>>> 
>>>> It is also in the Security Editor. see screenshot below
>>>> [image: image.png]
>>>> 
>>>> So I don't know what else I need to do.
>>>> 
>>>> 
>>>> 
>>>> On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
>>>> adrien.montele...@lusfiber.net <mailto:adrien.montele...@lusfiber.net>> 
>>>> wrote:
>>>> 
>>>>> Your font probably doesn?t have that symbol. Check your custom CSS file
>>>>> and find a different font. I?d use either the Mac Character Viewer or
>>> Font
>>>>> Book to find a suitable one. It looks like that is Unicode 20B1. A
>>> simple
>>>>> search in Character Viewer for ?peso? brought it right up. Select the
>>>>> character in the search results in the middle pane, then use the
>>>>> bottom-right pane to click each sample to see what fonts have it.
>>> (that is
>>>>> a really bad UI/UX for this, but it is doable)
>>>>> 
>>>>> Also check Tools > Security editor and make sure a symbol is displayed
>>>>> there. If not, you can reset it manually.
>>>>> 
>>>>> Regards,
>>>>> Adrien
>>>>> 
>>>>>> On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
>>> gbacar...@gmail.com <mailto:gbacar...@gmail.com>>
>>>>> wrote:
>>>>>> 
>>>>>> Why am I getting question marks instead of currency in the reports?
>>>>>> 
>>>>>> Gnucash Version: 3.7
>>>>>> Preferences / Default Currency = PHP (Philippine Peso)
>>>>>> 
>>>>>> Mac OSX Catalina
>>>>> 
>>>>> ___
>>>>> gnucash-user mailing list
>>>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>>>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>>>> If you are using Nabble or Gmane, please see
>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>>>> <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>>>>> -
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Gio Bacareza]

I finally solved it! Thank you Adrien. I followed your lead and examined
the style sheets. There I found out that the default style sheets has Fonts
set to NONE. I still don't quite understand what default font GNUCASH
defaults to if it is set at NONE but I experimented and created my own
style sheet and explicitly specified a font. It worked! Thanks Adrien.

I'm just curious. What font does it default to if it's set to NONE? Thanks

On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Also, are you using a custom/modified stylesheet for the report with a
> different font for the totals?
>
> Regards,
> Adrien
>
> > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> > The only technical difference between regular lines and total lines is
> that
> > the latter is in bold. Try checking your font for bold symbol?
> >
> > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
> >
> >> it now shows up in the reports but the total is still a question mark.
> see
> >> screenshot below
> >> [image: image.png]
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
cheers,

Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Gio Bacareza]

Thank you Fred. I was also pointing out to other fonts. That was just an
example to show that it's there.

On Fri, Jun 19, 2020, 7:04 PM Fred Bone  wrote:

> On 19 June 2020 at 18:29, Gio Bacareza said:
>
> > Thank you for the help Christopher. Yes there are bold fonts capable of
> > displaying Philippine Peso but the report still displays question marks.
> > See screenshot below
> >
> > [image: image.png]
>
> Your total line is very obviously not in Arial so the display of Arial in
> Character Viewer is irrelevant.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Fred Bone]

On 19 June 2020 at 18:29, Gio Bacareza said:

> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]

Your total line is very obviously not in Arial so the display of Arial in 
Character Viewer is irrelevant.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Gio Bacareza]

Thank you for the help Christopher. Yes there are bold fonts capable of
displaying Philippine Peso but the report still displays question marks.
See screenshot below

[image: image.png]

On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam 
wrote:

> The only technical difference between regular lines and total lines is
> that the latter is in bold. Try checking your font for bold symbol?
>
> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
>
>> it now shows up in the reports but the total is still a question mark. see
>> screenshot below
>> [image: image.png]
>>
>> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza  wrote:
>>
>> > Hi Adrien and others,
>> >
>> > I checked the character viewer and Peso is confirmed to be there
>> available
>> > in various fonts including Apple Symbols collection. See screenshot.
>> > [image: image.png]
>> >
>> > It is also in the Security Editor. see screenshot below
>> > [image: image.png]
>> >
>> > So I don't know what else I need to do.
>> >
>> >
>> >
>> > On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
>> > adrien.montele...@lusfiber.net> wrote:
>> >
>> >> Your font probably doesn’t have that symbol. Check your custom CSS file
>> >> and find a different font. I’d use either the Mac Character Viewer or
>> Font
>> >> Book to find a suitable one. It looks like that is Unicode 20B1. A
>> simple
>> >> search in Character Viewer for ‘peso’ brought it right up. Select the
>> >> character in the search results in the middle pane, then use the
>> >> bottom-right pane to click each sample to see what fonts have it.
>> (that is
>> >> a really bad UI/UX for this, but it is doable)
>> >>
>> >> Also check Tools > Security editor and make sure a symbol is displayed
>> >> there. If not, you can reset it manually.
>> >>
>> >> Regards,
>> >> Adrien
>> >>
>> >> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
>> gbacar...@gmail.com>
>> >> wrote:
>> >> >
>> >> > Why am I getting question marks instead of currency in the reports?
>> >> >
>> >> > Gnucash Version: 3.7
>> >> > Preferences / Default Currency = PHP (Philippine Peso)
>> >> >
>> >> > Mac OSX Catalina
>> >>
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see
>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
>> >>
>> >
>> >
>> > --
>> > cheers,
>> >
>> > Gio
>> >
>>
>>
>> --
>> cheers,
>>
>> Gio
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>

-- 
cheers,

Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Gio Bacareza]

No. I'm just using default

On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Also, are you using a custom/modified stylesheet for the report with a
> different font for the totals?
>
> Regards,
> Adrien
>
> > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam <
> christopher@gmail.com> wrote:
> >
> > The only technical difference between regular lines and total lines is
> that
> > the latter is in bold. Try checking your font for bold symbol?
> >
> > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
> >
> >> it now shows up in the reports but the total is still a question mark.
> see
> >> screenshot below
> >> [image: image.png]
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
cheers,

Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Adrien Monteleone]

Also, are you using a custom/modified stylesheet for the report with a 
different font for the totals?

Regards,
Adrien

> On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam 
>  wrote:
> 
> The only technical difference between regular lines and total lines is that
> the latter is in bold. Try checking your font for bold symbol?
> 
> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:
> 
>> it now shows up in the reports but the total is still a question mark. see
>> screenshot below
>> [image: image.png]


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Christopher Lam]

The only technical difference between regular lines and total lines is that
the latter is in bold. Try checking your font for bold symbol?

On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:

> it now shows up in the reports but the total is still a question mark. see
> screenshot below
> [image: image.png]
>
> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza  wrote:
>
> > Hi Adrien and others,
> >
> > I checked the character viewer and Peso is confirmed to be there
> available
> > in various fonts including Apple Symbols collection. See screenshot.
> > [image: image.png]
> >
> > It is also in the Security Editor. see screenshot below
> > [image: image.png]
> >
> > So I don't know what else I need to do.
> >
> >
> >
> > On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Your font probably doesn’t have that symbol. Check your custom CSS file
> >> and find a different font. I’d use either the Mac Character Viewer or
> Font
> >> Book to find a suitable one. It looks like that is Unicode 20B1. A
> simple
> >> search in Character Viewer for ‘peso’ brought it right up. Select the
> >> character in the search results in the middle pane, then use the
> >> bottom-right pane to click each sample to see what fonts have it. (that
> is
> >> a really bad UI/UX for this, but it is doable)
> >>
> >> Also check Tools > Security editor and make sure a symbol is displayed
> >> there. If not, you can reset it manually.
> >>
> >> Regards,
> >> Adrien
> >>
> >> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
> gbacar...@gmail.com>
> >> wrote:
> >> >
> >> > Why am I getting question marks instead of currency in the reports?
> >> >
> >> > Gnucash Version: 3.7
> >> > Preferences / Default Currency = PHP (Philippine Peso)
> >> >
> >> > Mac OSX Catalina
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> >
> > --
> > cheers,
> >
> > Gio
> >
>
>
> --
> cheers,
>
> Gio
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Gio Bacareza]

Thanks Adrien. Let me try this. Let you guys know

On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Your font probably doesn’t have that symbol. Check your custom CSS file
> and find a different font. I’d use either the Mac Character Viewer or Font
> Book to find a suitable one. It looks like that is Unicode 20B1. A simple
> search in Character Viewer for ‘peso’ brought it right up. Select the
> character in the search results in the middle pane, then use the
> bottom-right pane to click each sample to see what fonts have it. (that is
> a really bad UI/UX for this, but it is doable)
>
> Also check Tools > Security editor and make sure a symbol is displayed
> there. If not, you can reset it manually.
>
> Regards,
> Adrien
>
> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza 
> wrote:
> >
> > Why am I getting question marks instead of currency in the reports?
> >
> > Gnucash Version: 3.7
> > Preferences / Default Currency = PHP (Philippine Peso)
> >
> > Mac OSX Catalina
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
cheers,

Gio
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Fred Bone]

On 17 June 2020 at 16:34, Gio Bacareza said:

> Why am I getting question marks instead of currency in the reports?
> 
> Gnucash Version: 3.7
> Preferences / Default Currency = PHP (Philippine Peso)

Because the currency symbol isn't defined in the font you're using, is 
the usual cause.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question marks instead of currency in reports

[Adrien Monteleone]

Your font probably doesn’t have that symbol. Check your custom CSS file and 
find a different font. I’d use either the Mac Character Viewer or Font Book to 
find a suitable one. It looks like that is Unicode 20B1. A simple search in 
Character Viewer for ‘peso’ brought it right up. Select the character in the 
search results in the middle pane, then use the bottom-right pane to click each 
sample to see what fonts have it. (that is a really bad UI/UX for this, but it 
is doable)

Also check Tools > Security editor and make sure a symbol is displayed there. 
If not, you can reset it manually.

Regards,
Adrien

> On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza  wrote:
> 
> Why am I getting question marks instead of currency in the reports?
> 
> Gnucash Version: 3.7
> Preferences / Default Currency = PHP (Philippine Peso)
> 
> Mac OSX Catalina

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about new 5 fundamental budget categories

[Christopher Lam]

Your contribution very welcome in
https://bugs.gnucash.org/show_bug.cgi?id=797551

On Tue, 7 Jan 2020 at 07:09, Caleb Begly  wrote:

> In the changelog for 3.8, it says:
>
>  [gnc-budget-view.c] totals - 5 fundamental types
> previous showed income/expense/transfers/totals budget totals, of uncertain
> meaning. now shows income/expense/asset/liability/equity budget totals. The
> 5 lines also become sensitive to the global sign-reverse property.
>
>
> Previously with 3.7 and previous, I would use the totals column to signal
> if the combination of income, expense, and transfers balances (when totals
> = 0, then it is balanced). However with the new categories, I don't see a
> way to confirm balance besides manually adding them up. Is there some way
> to enable an Imbalance summary row so it can show if the budget for that
> period is balanced or not?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[William Benson]

Will do, thanks!

On Mon, Nov 11, 2019 at 6:38 AM Derek Atkins  wrote:

> Hi,
>
> Please CC gnucash-user on all replies...
>
> On Mon, November 11, 2019 8:35 am, William Benson wrote:
> > I tried that. Catalina will not ope to any version of gnucash. Bill
>
> No, Catalina will definitely open 3.7.  There are many people using 3.7
> with Catalina.  You MAY have to tell your Mac to allow it.  It may try to
> open a dialog asking your permission, but it's possible you have that
> window minimized if it was asking you a different question and you clicked
> it away.
>
> Please go read the gnucash-user archives about this.  We have had several
> discussions already about GnuCash on Catalina.
>
> >> > Please remember to CC this list on all your replies.
> >> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Derek Atkins]

Hi,

Please CC gnucash-user on all replies...

On Mon, November 11, 2019 8:35 am, William Benson wrote:
> I tried that. Catalina will not ope to any version of gnucash. Bill

No, Catalina will definitely open 3.7.  There are many people using 3.7
with Catalina.  You MAY have to tell your Mac to allow it.  It may try to
open a dialog asking your permission, but it's possible you have that
window minimized if it was asking you a different question and you clicked
it away.

Please go read the gnucash-user archives about this.  We have had several
discussions already about GnuCash on Catalina.

>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] question

[Derek Atkins]

Upgrade to 3.7

-derek


On Mon, November 11, 2019 7:22 am, William Benson wrote:
> On the weekend of November 2-3, I upgraded my Mac desktop to a new
> software program, from Mojave to Catalina. Then, this weekend, I tried to
> get into my Gnucash app, but discovered that it would not open. I called
> Apple, and the tech showed me that Gnucash is a 32-bit app, but that
> Catalina only works with 64-bit apps. Mojave worked with both 32 and
> 64-bit apps.
>
> Are there any plans to upgrade Gnucash to a 64-bit app? Or, is there a
> workaround for this difficulty?
>
> Bill Benson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about offset entery for inventory

[Derek Atkins]

Kebcoinc  writes:

> I just cannot remember.
> When I am entering a transaction for one of my vendors,
> I ordered some inventory,
> I want to increase the liability for this vendor
> What would I decrease to balance?

Your inventory asset account.

> I'm actually increasing my inventory and increasing my liability

Right.  If you credit the vendor and debit inventory, it will "increase"
both (because a liability is a "negative" account).

> Thanks

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about display of reports

[David T. via gnucash-user]

Mark, 
Your problem stems from the fact that your accounts are in (Canadian?) dollars, 
while your locale may be in pounds. 
I am not versed in multi-currency situations. Maybe someone else can advise you 
on how to clear that up. 
David
 
 
  On Mon, Feb 4, 2019 at 13:54, Mark Stockwell wrote:   
Hi David
It appears to be in all reports that I run. Attached is an example of a balance 
sheet report where there are lots of zero balances showing on the right hand 
side that do not appear to represent anything and none of the totals add up to 
what I am expecting to see?
Thanks
Mark



On 3 Feb 2019, at 6:11 am, David T.  wrote:
And which report.


On Feb 3, 2019, at 9:42 AM, David Carlson  wrote:

Mark, you left out which version you are using.

On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
gnucash-user@gnucash.org> wrote:


Hi

Whenever I run a report from my version of Gnucash, for every line
displaying balances, there is another ghost column to the right with zeros
all the way down the page. Please could you let me know how I can remove
this ghost column so that I can use the reporting for sending to my tax
adviser?

Thanks

Mark
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about display of reports

[Mark Stockwell via gnucash-user]

Hi David

It appears to be in all reports that I run. Attached is an example of a balance 
sheet report where there are lots of zero balances showing on the right hand 
side that do not appear to represent anything and none of the totals add up to 
what I am expecting to see?

Thanks

Mark



> On 3 Feb 2019, at 6:11 am, David T.  wrote:
> 
> And which report.
> 
>> On Feb 3, 2019, at 9:42 AM, David Carlson  
>> wrote:
>> 
>> Mark, you left out which version you are using.
>> 
>> On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> Hi
>>> 
>>> Whenever I run a report from my version of Gnucash, for every line
>>> displaying balances, there is another ghost column to the right with zeros
>>> all the way down the page. Please could you let me know how I can remove
>>> this ghost column so that I can use the reporting for sending to my tax
>>> adviser?
>>> 
>>> Thanks
>>> 
>>> Mark
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about display of reports

[David T. via gnucash-user]

And which report.

> On Feb 3, 2019, at 9:42 AM, David Carlson  wrote:
> 
> Mark, you left out which version you are using.
> 
> On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Hi
>> 
>> Whenever I run a report from my version of Gnucash, for every line
>> displaying balances, there is another ghost column to the right with zeros
>> all the way down the page. Please could you let me know how I can remove
>> this ghost column so that I can use the reporting for sending to my tax
>> adviser?
>> 
>> Thanks
>> 
>> Mark
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about display of reports

[David Carlson]

Mark, you left out which version you are using.

On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi
>
> Whenever I run a report from my version of Gnucash, for every line
> displaying balances, there is another ghost column to the right with zeros
> all the way down the page. Please could you let me know how I can remove
> this ghost column so that I can use the reporting for sending to my tax
> adviser?
>
> Thanks
>
> Mark
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about sub accounts

[Kenneth Schneider]

Ken Schneider 

> On Oct 31, 2018, at 1:01 PM, Wm via gnucash-user  
> wrote:
> 
>> On 29/10/2018 16:49, Adrien Monteleone wrote:
>> 
>> We’ve discussed envelope budgeting quite a bit here on the list. Do a list 
>> restricted search to find the threads. I’ve tried it myself in the past, and 
>> currently have the account tree set up to use, but honestly, it is probably 
>> better to use an outside piece of software to manage the budgeting and just 
>> use GnuCash for the actual real accounting. (GnuCash has a budget module, 
>> but it is not envelope based) There are several methods and lots of 
>> pitfalls. The least of which is nearly double the work in entering 
>> transaction splits.
> 
> I think it is a envelope budget hangover.
> 
>> Finally, there are plenty of good standard accounting textbooks online for 
>> free. Here’s one I’ve found pretty useful as a quick reference: 
>> https://www.principlesofaccounting.com/ (I have a college textbook I kept 
>> that is probably better, but that copy is on paper and this is at my 
>> fingertips)
>> All of your questions though were not accounting questions, but GnuCash 
>> mechanics questions. We don’t give accounting advice here, but can offer 
>> some basic generic example help and can point you in the right direction, 
>> but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, 
>> that’s what we’re here for.
> 
> You are sort of right and sort of wrong, the OP wants something that gnc can 
> do with effort but if you have brains you don't bother with.
> 
> Envelope budgeting is, oddly, something Trump voters pay for.  Weird.

PLEASE keep your snide childish remarks to yourself. They’re not appreciated on 
this list.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about sub accounts

[Wm via gnucash-user]

On 29/10/2018 16:49, Adrien Monteleone wrote:


We’ve discussed envelope budgeting quite a bit here on the list. Do a list 
restricted search to find the threads. I’ve tried it myself in the past, and 
currently have the account tree set up to use, but honestly, it is probably 
better to use an outside piece of software to manage the budgeting and just use 
GnuCash for the actual real accounting. (GnuCash has a budget module, but it is 
not envelope based) There are several methods and lots of pitfalls. The least 
of which is nearly double the work in entering transaction splits.


I think it is a envelope budget hangover.


Finally, there are plenty of good standard accounting textbooks online for 
free. Here’s one I’ve found pretty useful as a quick reference: 
https://www.principlesofaccounting.com/ (I have a college textbook I kept that 
is probably better, but that copy is on paper and this is at my fingertips)

All of your questions though were not accounting questions, but GnuCash 
mechanics questions. We don’t give accounting advice here, but can offer some 
basic generic example help and can point you in the right direction, but if the 
question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re 
here for.


You are sort of right and sort of wrong, the OP wants something that gnc 
can do with effort but if you have brains you don't bother with.


Envelope budgeting is, oddly, something Trump voters pay for.  Weird.

--
Wm

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about sub accounts

[Wm via gnucash-user]

On 29/10/2018 14:55, Eric Gwin wrote:

Hi,

I'm pretty new to to application, and have basically 0 accounting
background. I've setup my books and all is working pretty well, but I am
running into an issue with subaccounts I hope I'm doing something wrong,
but if not I'd also like to know so I can post a suggestion.

Scenario:

I have a checking account I am using as an accumulator for multiple other
purposes (it is a "sinking" fund account I use to "save" for
expected/budgeted non-monthly expenses)

I have set it up like this:
*assets:current assets:sinking checking*

is then has sub accounts to track deposits to and deductions from various
categories


*assets:current assets:sinking checking:AutoMaint*

*assets:current assets:sinking checking:Clothing*
*assets:current assets:sinking checking:HairCare*
*assets:current assets:sinking checking:HomeMaint*
*assets:current assets:sinking checking:KidActivity*

On a bi-monthly basis, I deposit a fixed amount to the "sinking checking"
and a split transaction allocates it to the various sub-accounts.
Then as payments need to be made I use that checking for the payment and
track it using an entry against the sub-account.

This works pretty well as it solves the major problem of maintaining each
sub-accounts spending and balances. However, in order to reconcile the
checking account I need to see all the transactions to each sub account
listed in the register for the "sinking checking" along with the running
balance for the account.


I'm missing the point a bit, you have really specific accounts.


I've been able to limp by so far by specifying every transaction as a split
with no amount to *assets:current assets:sinking checking *
and the actual transaction amount to the sub-account:
*assets:current assets:sinking checking:AutoMaint*   -135.45
*Expenses:Sinking:AutoMaint  * 135.45
That at least creates an entry in the "singing checking" register and the
"Accounts" tab does show the current balance for "sinking checking", but
there is no running total, nor does the transaction amount show in that
account's register.

Setting "Sinking checking" as a placeholder seems to simply mean GNUCash
won't allow you to view the register or enter a transaction against the
account.


We are aware of envelope accounting as a theory and don't really think 
of it as accounting, it is a budgeting method and hope you realise that. 
 Your budget is your business, gnc can help you but it isn't going to 
do it for you.  gnc is for grown ups not the average Trump voter.



Is there a way to set up an account of this type where the account
maintains the transactions (as it should for reconciliation) and each
sub-account also "inherits" transactions for their type: or the sub
accounts get the transaction entries as I'm doing, but the parent account
register lists (but doesn't total) the sub account transactions?


Yes, spend at the lowest level and report at the highest level and drill 
down until you see what you do (or don't) want to see.


BTW, this sort of Budgeting won't work in gnc so don't even try.  Micro 
management of personal finance is best done in another way, I'd go so 
far as to suggest not doing it on social media.

--
Wm

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about sub accounts

[Adrien Monteleone]

Eric,

Read the end of my reply first...

Now, I was following you up until this point:

> On Oct 29, 2018, at 9:55 AM, Eric Gwin  wrote:
> ...

> I've been able to limp by so far by specifying every transaction as a split
> with no amount to *assets:current assets:sinking checking *
> and the actual transaction amount to the sub-account:
> *assets:current assets:sinking checking:AutoMaint*   -135.45
> *Expenses:Sinking:AutoMaint  * 135.45

What you showed here *was* an amount to the sinking checking *and* an amount to 
the related expense account. Yet you said you “_no_ amount to the ...:sinking 
checking”.


> That at least creates an entry in the "singing checking" register and the
> "Accounts" tab does show the current balance for "sinking checking", but
> there is no running total, nor does the transaction amount show in that
> account's register.
> 

What do you mean by ‘running total’ and how could you not see the transaction 
amount in that account’s register if you in fact created a transaction with a 
split to that account? Your description here is very confusing.


> Setting "Sinking checking" as a placeholder seems to simply mean GNUCash
> won't allow you to view the register or enter a transaction against the
> account.

Correct. And as a good rule of thumb to not tear your hair out later, it is 
good practice to make all parent accounts placeholders except for very special 
situations. (This is one of them, but see below)


> 
> Is there a way to set up an account of this type where the account
> maintains the transactions (as it should for reconciliation)

If you enter a transaction with splits to a certain account, that account’s 
register will contain a copy of the transaction and its running balance will 
reflect the result of the cumulative effect of those splits.

> and each
> sub-account also "inherits" transactions for their type:

Not sure what you mean by this. By ’type’ do you mean ‘expense, asset, etc.?'


> or the sub
> accounts get the transaction entries as I'm doing, but the parent account
> register lists (but doesn't total) the sub account transactions?

Now we’re back to the first part of your post, the problem you are initially 
having an issue with is reconciling. There is a solution:

When you click the Reconcile button while viewing the *parent* account, check 
the “Include Subaccounts” box. But keep reading first...

Note, if this is a real checking account that you are simply segregating funds 
in *artificially* (that is, not actually with separate accounts at the bank) 
then make all of these subs as children of the actual checking account - not 
Current Assets. But do not make the parent real checking account a placeholder 
as it might contain real transactions unrelated to the children. Then the 
reconcile process will make sense using the ‘Include Subaccounts’ option. So 
you can see here, it would be odd to reconcile ‘Current Assets’ especially 
since that account can have other children like “Cash” or “Pre-paid Expenses” 
and other actual checking and savings accounts among others.

If these are simply your own mechanism for savings, like a virtual envelope 
method, and the funds might be physically represented in the real world in 
various or multiple places, then create a parent for them, say “Current 
Assets:Budget Envelopes” and include in each transaction a set of transfer 
splits from the envelope back to the physical account where the funds reside, 
then ’spend’ from the actual physical account, then reconcile the actual 
physical account. This means more splits for each transaction (at least 4 
total) but you can maintain your budgeting method.

We’ve discussed envelope budgeting quite a bit here on the list. Do a list 
restricted search to find the threads. I’ve tried it myself in the past, and 
currently have the account tree set up to use, but honestly, it is probably 
better to use an outside piece of software to manage the budgeting and just use 
GnuCash for the actual real accounting. (GnuCash has a budget module, but it is 
not envelope based) There are several methods and lots of pitfalls. The least 
of which is nearly double the work in entering transaction splits.

Finally, there are plenty of good standard accounting textbooks online for 
free. Here’s one I’ve found pretty useful as a quick reference: 
https://www.principlesofaccounting.com/ (I have a college textbook I kept that 
is probably better, but that copy is on paper and this is at my fingertips)

All of your questions though were not accounting questions, but GnuCash 
mechanics questions. We don’t give accounting advice here, but can offer some 
basic generic example help and can point you in the right direction, but if the 
question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re 
here for.

Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription 

Re: [GNC] question

[Adrien Monteleone]

The First line is the Description.

Second line is Notes

Additional lines for each split are Memos.

I’ve noticed in the AR register that this is the case, (there’s already a bug 
filed) but I’ve just tested in several others and it is behaving correctly.

Which register(s) are you noticing this behavior?

What version of GnuCash and which OS are you using?

Regards,
Adrien


> On Oct 13, 2018, at 4:26 PM, tom9...@earthlink.net wrote:
> 
>   In the transaction view of a journal entry, I have found that anything
>   put in the memo section (the second line of the entry) is automatically
>   repeated in the first line description field (the third line of the
>   entry). Why is that and how can I stop it?
> Thomas Marks
> 
> Thomas Marks
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.