Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[David G. Pickett via gnucash-user]

 For transfers, I put both dates in the description, and start it at the from 
date for ease of reconciling that account, then move it to the to date for ease 
in reconciling that account.  I have not tried that for checks, but might start 
them when cleared and then move them to when written.  Even ACH often shows up 
a business day later.

So much of the business world still runs like it did on daily tape master file 
updates, where they fed one or more tapes of input transactions and inquiries 
into a tape master file update and got one or more output transaction tapes.  
They could do it in real time on disk.  The only downside for instant real time 
is that a delay with notification allows the account owner a chance at catching 
fraud.  Similarly, some CC make me wait days for a statement, as if printing 
paper, when they could generate the pdf from their RDBMS for me interactively 
one second after midnight after the cycle!
On Monday, June 3, 2024 at 11:37:12 AM EDT, R Losey  
wrote:   

 

On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user 
 wrote:

I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!  Float is nice, 
especially if you get interest, but not something I bank on!  :D  Similarly, 
one bank puts a 3 day hold on transfers, so the money goes out one day and 
shows up in the other account 3-5 days later!  Maybe another field would be 
nice?  I don't want to create a limbo account and two transactions to hold the 
value when it is floating!


I have run into this same thing when transferring funds from one institution to 
another.  I have settled on the practice of using the date when it shows up at 
the "TO" institution rather than the "FROM" of the previous one; and I usually 
enter it when the "FROM" initiates the transfer... so there is a future 
transaction when I enter it to know that it is "in transit"
-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8  
___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[R Losey]

On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I like to record my checks written on the day they were written, not
> cashed, but am frustrated that then I cannot check when they cleared!
> Float is nice, especially if you get interest, but not something I bank
> on!  :D  Similarly, one bank puts a 3 day hold on transfers, so the money
> goes out one day and shows up in the other account 3-5 days later!  Maybe
> another field would be nice?  I don't want to create a limbo account and
> two transactions to hold the value when it is floating!
>

I have run into this same thing when transferring funds from one
institution to another.  I have settled on the practice of using the date
when it shows up at the "TO" institution rather than the "FROM" of the
previous one; and I usually enter it when the "FROM" initiates the
transfer... so there is a future transaction when I enter it to know that
it is "in transit"

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[Michael or Penny Novack]

On 6/1/2024 4:39 PM, David G. Pickett via gnucash-user wrote:

I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!


Well technically should be recorded when delivered, with delivered 
meaning "constructively delivered" << when you mail them >> You should 
NOT be tracking "float". Legally that money isn't yours any more even 
though sitting in your bank account until the check clears. The reason 
that just WRITING the check (that date) has no meaning is until you send 
it, could just change your mind and rip it up. But as many do, I use the 
date written even though might not be be immediately picked up by the PO 
<< say I put in the mailbox after collection on Saturday and Monday is a 
Federal holiday -- won't get postmarked till Tuesday at the earliest -- 
the postmark date has legal significance >>


Michael D Novack


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

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[David Cousens]

David,

AFAIK the reconcile "R" column has three settings ,"n","c","y". If you
manually record a transaction it should be set at "n". The "c" setting
indicates that a transaction has been cleared and can be set to this
when for example the money either appears in your account or when it
has been taken out of your account. It is set to "y" when you do a
reconciliation against a statement.

David Cousens
 

On Sat, 2024-06-01 at 20:39 +, David G. Pickett via gnucash-user
wrote:
> I like to record my checks written on the day they were written, not
> cashed, but am frustrated that then I cannot check when they
> cleared!  Float is nice, especially if you get interest, but not
> something I bank on!  :D  Similarly, one bank puts a 3 day hold on
> transfers, so the money goes out one day and shows up in the other
> account 3-5 days later!  Maybe another field would be nice?  I don't
> want to create a limbo account and two transactions to hold the value
> when it is floating!
> ___
> 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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[David G. Pickett via gnucash-user]

I like to record my checks written on the day they were written, not cashed, 
but am frustrated that then I cannot check when they cleared!  Float is nice, 
especially if you get interest, but not something I bank on!  :D  Similarly, 
one bank puts a 3 day hold on transfers, so the money goes out one day and 
shows up in the other account 3-5 days later!  Maybe another field would be 
nice?  I don't want to create a limbo account and two transactions to hold the 
value when it is floating!
___
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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[David Cousens]

Bruce.
There should be no problem just adding additional lines for each sale
and shipping label purchase and fee transaction to the single
transaction with the debit entry to your check account being the payout
figure. 

Alternatively if you have the gross amount of each sale available you
can calculate what you receive from each sale and could post each
individual sale as a transaction and instead of debiting your cheque
account, debit an accounts receivable account. When you record the
transaction for Ebay's payment to you at the end of the day, you credit
the accounts receivable and then debit your cheque account. The amounts
should match.

What is more appropraite will depend on your reporting requirements and
taxation legislation. This is where you need your local accountant.

David Cousens

On Fri, 2024-05-31 at 10:25 -0400, Bruce Griffis wrote:
> I’m looking for help in figuring out GnuCash for a small eBay
> reseller, 
> basically selling items from home, but occasionally purchasing an
> item 
> for resale. I’m looking at this from the perspective of viewing sales
> from the My eBay / Selling / Payments / Total Sales page.
> 
> 
> Under Assets, I have Checking account, Savings account, Cash account
> and 
> eBay Inventory account (I get that GnuCash does not support inventory
> – 
> I just build this using a CSV export from Libre Office Calc). Under 
> liabilities I have a secured credit card.
> 
> 
> Under Income I have eBay Transactions (and I want this to reflect the
> eBay All Transactions page). Under expenses I have eBay Final Value 
> Fees, eBay Shipping Labels and eBay Refunds. I also have standard
> small 
> business chart of accounts to support basics of purchasing boxes,
> bubble 
> wrap, bubble mailers, tape, poly bags, …
> 
> 
> When I look at making just one sale in a day, this approach works
> pretty 
> well:
> 
> On eBay All Transactions I have one entry that gives Date,
> Description 
> (the item that was sold),
> 
> Amount (this is gross amount), Fees (this is eBay Final Value fees),
> Net 
> (the net amount I receive – if I pay shipping (offer free shipping),
> net 
> gets reduced by my shipping label costs), Total Funds.
> 
> 
> I then see a second transaction under All Transactions for the
> purchase 
> of the shipping label. This includes Date, Description, Amount and
> Net. 
> Since Total Amount is the amount in this account before payout, my
> total 
> amount in this account gets modified (it gets reduced by shipping
> label 
> amount).
> 
> 
> I then see a third transaction. The third is my payout. This includes
> Date, Description, Amount and Total Amount. Amount is the dollar
> amount 
> that hits my checking account in two business days. Total Amount is
> the 
> Total in this account (eBay Funds? I need to figure out what to 
> descriptively call it). If I only had one sale in a day and did not
> make 
> any new sales then Total is zero.
> 
> 
> To reflect this, I enter a split transaction.
> 
> I enter the Date, Description and Gross amount for the sale.
> 
> I enter another transaction in the split. This is Date, Description, 
> eBay Final Fees (an expense). This goes into Expense account eBay
> Final 
> Fees.
> 
> I enter another transaction in the split. This is Date, Description, 
> Shipping label cost and goes to eBay Shipping Labels expense account.
> 
> I enter a third transaction. This is my payout. It usually simply 
> matches Imbalance-USD. This goes to my Income account Checking.
> 
> 
> When I look at my checking account, I can match it by the dollar
> amount, 
> but since payouts post in two business days, the date does not match
> up. 
> But it is simple enough to figure out.
> 
> 
> Things get way out of hand when I make multiple sales in one day. I 
> would enter a split transaction for every sale, so if I had four 
> transaction – I would show four split transactions made up of the
> sale, 
> the final value fees, and the shipping label. However – I would only 
> have one payout. So if I take the income from the sale and post it 
> directly to checking, I end up adding 1 of 4, 2 of 4, 3 of 4, … to
> the 
> front of the description field. Then when looking at my checking
> account 
> – I would need to add together each individual transaction to equal
> my 
> payout. Now I am not matching on date (posted two business days
> later) 
> and amount (I need to add individual sales together to correlate with
> the days payout.
> 
> 
> Additionally, Refunds get pulled out of the running eBay Funds
> account 
> (that I need to create in GnuCash). If the funds in that account
> aren’t 
> enough t cover it, the refund comes out of checking as a direct
> debit.
> 
> Any recommendations on how I would show multiple sales in a day
> making 
> up one entry into my checking account? Do I need another account –
> send 
> my payouts there. Then group multiples in another split (if I can do 
> that?) to show the days transactions? Or do I need to think about
> doing 
> an 

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[Jim DeLaHunt]

Bruce:

Welcome to GnuCash, congratulations on the eBay business, and I hope it 
goes well for you.


It sounds like your question is not about GnuCash, it is about 
accounting. Once you know how the information should get tracked as an 
accounting matter, it will be straightforward to explain how to record 
that information using GnuCash as the recording tool.


Do you have an accountant advising you?  If so, ask them for their 
advice about how to record this information.  Have you read an 
introductory accounting textbook?  If not, maybe this is a good time for 
that learning.


You say,

…Under Income I have eBay Transactions (and I want this to reflect the 
eBay All Transactions page).…


From what you describe, this sounds to me like it should be an Asset, 
not Income. It is something like Accounts Receivable from eBay. The eBay 
All Transactions page as you describe it lists a sale, where eBay starts 
to owe you money, then a deduction for cost of sales, where eBay reduces 
the amount they owe you, then a payout, where eBay reduces what they owe 
you to zero by sending you money. So: it sounds to me like the type of 
this account should be Asset, not Income.


…Things get way out of hand when I make multiple sales in one day. I 
would enter a split transaction for every sale, so if I had four 
transaction – I would show four split transactions made up of the 
sale, the final value fees, and the shipping label. However – I would 
only have one payout. So if I take the income from the sale and post 
it directly to checking, I end up adding 1 of 4, 2 of 4, 3 of 4, … to 
the front of the description field. Then when looking at my checking 
account – I would need to add together each individual transaction to 
equal my payout.…
It sounds like you should be entering only one transaction from the eBay 
Accounts Receivable account to the chequing account, to correspond to 
the one payout per day. There is no need to make a transaction between 
these two accounts for each eBay sale. The amount of the one daily 
transaction equals the amount of the eBay payout, and the amount which 
arrives in your chequing account.


Note that the balance in your eBay Accounts Receivable account starts at 
zero each day, increases as eBay makes sales, decreases as eBay charges 
you fees, then drop to zero when eBay makes the daily payout.


…When I look at my checking account, I can match it by the dollar 
amount, but since payouts post in two business days, the date does not 
match up. But it is simple enough to figure out.… 
In my finances, it is completely normal for a transaction to take 
multiple days to play out, so the statements from various parties to the 
transaction will have different dates.  For instance, I pay a store by 
credit card on May 1st. When I get my credit card statement, it has two 
dates for the transaction: transaction date, and posting date.  The 
transaction date is May 3rd, because the store did not report the sale 
to the credit card company for a little while.  The posting date is May 
4th, because the credit card company also took a little time to process 
the transaction.


GnuCash only has one date field per transaction, so I choose one of 
those three transaction dates as the representative date to record in 
GnuCash.


It is possible to enter multiple GnuCash transactions to record the 
separate steps and the time delay in transactions, but I almost never 
find it worth the bother.


Does this answer your question?
  —Jim DeLaHunt


On 2024-05-31 10:25, Bruce Griffis wrote:
I’m looking for help in figuring out GnuCash for a small eBay 
reseller, basically selling items from home, but occasionally 
purchasing an item for resale. I’m looking at this from the 
perspective of viewing sales from the My eBay / Selling / Payments / 
Total Sales page.



Under Assets, I have Checking account, Savings account, Cash account 
and eBay Inventory account (I get that GnuCash does not support 
inventory – I just build this using a CSV export from Libre Office 
Calc). Under liabilities I have a secured credit card.



Under Income I have eBay Transactions (and I want this to reflect the 
eBay All Transactions page). Under expenses I have eBay Final Value 
Fees, eBay Shipping Labels and eBay Refunds. I also have standard 
small business chart of accounts to support basics of purchasing 
boxes, bubble wrap, bubble mailers, tape, poly bags, …



When I look at making just one sale in a day, this approach works 
pretty well:


On eBay All Transactions I have one entry that gives Date, Description 
(the item that was sold),


Amount (this is gross amount), Fees (this is eBay Final Value fees), 
Net (the net amount I receive – if I pay shipping (offer free 
shipping), net gets reduced by my shipping label costs), Total Funds.



I then see a second transaction under All Transactions for the 
purchase of the shipping label. This includes Date, Description, 
Amount and Net. Since Total Amount is the amount 

[GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

[Bruce Griffis]

I’m looking for help in figuring out GnuCash for a small eBay reseller, 
basically selling items from home, but occasionally purchasing an item 
for resale. I’m looking at this from the perspective of viewing sales 
from the My eBay / Selling / Payments / Total Sales page.



Under Assets, I have Checking account, Savings account, Cash account and 
eBay Inventory account (I get that GnuCash does not support inventory – 
I just build this using a CSV export from Libre Office Calc). Under 
liabilities I have a secured credit card.



Under Income I have eBay Transactions (and I want this to reflect the 
eBay All Transactions page). Under expenses I have eBay Final Value 
Fees, eBay Shipping Labels and eBay Refunds. I also have standard small 
business chart of accounts to support basics of purchasing boxes, bubble 
wrap, bubble mailers, tape, poly bags, …



When I look at making just one sale in a day, this approach works pretty 
well:


On eBay All Transactions I have one entry that gives Date, Description 
(the item that was sold),


Amount (this is gross amount), Fees (this is eBay Final Value fees), Net 
(the net amount I receive – if I pay shipping (offer free shipping), net 
gets reduced by my shipping label costs), Total Funds.



I then see a second transaction under All Transactions for the purchase 
of the shipping label. This includes Date, Description, Amount and Net. 
Since Total Amount is the amount in this account before payout, my total 
amount in this account gets modified (it gets reduced by shipping label 
amount).



I then see a third transaction. The third is my payout. This includes 
Date, Description, Amount and Total Amount. Amount is the dollar amount 
that hits my checking account in two business days. Total Amount is the 
Total in this account (eBay Funds? I need to figure out what to 
descriptively call it). If I only had one sale in a day and did not make 
any new sales then Total is zero.



To reflect this, I enter a split transaction.

I enter the Date, Description and Gross amount for the sale.

I enter another transaction in the split. This is Date, Description, 
eBay Final Fees (an expense). This goes into Expense account eBay Final 
Fees.


I enter another transaction in the split. This is Date, Description, 
Shipping label cost and goes to eBay Shipping Labels expense account.


I enter a third transaction. This is my payout. It usually simply 
matches Imbalance-USD. This goes to my Income account Checking.



When I look at my checking account, I can match it by the dollar amount, 
but since payouts post in two business days, the date does not match up. 
But it is simple enough to figure out.



Things get way out of hand when I make multiple sales in one day. I 
would enter a split transaction for every sale, so if I had four 
transaction – I would show four split transactions made up of the sale, 
the final value fees, and the shipping label. However – I would only 
have one payout. So if I take the income from the sale and post it 
directly to checking, I end up adding 1 of 4, 2 of 4, 3 of 4, … to the 
front of the description field. Then when looking at my checking account 
– I would need to add together each individual transaction to equal my 
payout. Now I am not matching on date (posted two business days later) 
and amount (I need to add individual sales together to correlate with 
the days payout.



Additionally, Refunds get pulled out of the running eBay Funds account 
(that I need to create in GnuCash). If the funds in that account aren’t 
enough t cover it, the refund comes out of checking as a direct debit.


Any recommendations on how I would show multiple sales in a day making 
up one entry into my checking account? Do I need another account – send 
my payouts there. Then group multiples in another split (if I can do 
that?) to show the days transactions? Or do I need to think about doing 
an accounts receivable kind of thing and bundle multiple transactions 
into an A/R account for the day for when I have more than one sale in a day?

___
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] need help getting started

[David H]

Eric,

On the gnucash.org homepage you must have missed the "Development" panel -
first item - "How to help" points to
https://wiki.gnucash.org/wiki/Contributing_to_GnuCash which covers how to
help with development - scroll down to "Coders" section.  Further links in
it re coding standards, yada, yada, yada.

Cheers David H.


On Sat, 4 Jun 2022 at 05:04, Eric Hammond  wrote:

>
> To the group,
>
> A short intro: I have been a user of Quicken for the last 1000 years or
> so, they have gone from a business that cares about customers to  not
> so much.
> Late last year one of their updates lost or scrambled years of my business
> accounting data, and my backups. Their help line help was "we are so
> sorry..."
>
> I discovered GnuCash in February this year and with a lot of very hard
> work and digging got almost all entries into it: the major journals balance.
> Six months of digging, creating and importing .csv files and seeing what
> broke. And repeat.
>
> I would like to convert my brute force AR and AP entries into the GnuCash
> format and have encountered some issues:
> Importing from CSV to regular journals was tricky, but I got it done and
> balanced.
> Is there any way to import the invoice data from CSV to the
> invoices-A/Receivables, and bills-A/Payables system and have the Posted and
> Paid flags set right?
>
> In the distant past I programmed accounting systems in RPG. Some help
> there.
>
> I have much programming experience (PC computers unfortunately) in C, C++,
> and Python: I would like to help with the project.
> I need help finding out how to do this, I have not yet found such in the
> website maze.
>
> And, how do I contribute the money I would have paid for Quicken to this
> worthy cause?
>
> Thank you for your help,
>
> Eric Hammond
> 670 Rainier Lane
> Port Ludlow, WA 98365
> (949) 244-3595
> e...@jehammond.net
>
> "Be the change that you wish to see in the world."
> ― Mahatma Gandhi
>
>
>
> ___
> 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] need help getting started

[Adrien Monteleone]

Eric,

Check the Help and the Tutorial (linked from the website, but should be 
available from within GnuCash). I don't recall which, but one describes 
the CSV format for importing bills/invoices.


I don't *think* you can import them as paid, because it isn't just a 
flag on the transaction. There is a link to the payment transaction as 
well that is needed. The only way I know of setting that properly, is to 
either 'Process Payment' or if the payment transaction is already 
entered (most likely in your case) then right-click and 'assign as 
payment'. (which brings up the Process Payment window with some details 
already filled out and which will link that transaction as a payment to 
that 'document')


You could maybe ask on IRC, but I don't think there is a programmatic 
way to do this at this time. (there are python bindings, however, I 
don't think they expose everything)


As for contributions, I think that info is on the website, wiki, or both.

The devs follow this list too, so one of them may see this and offer 
more definitive guidance.


Regards,
Adrien

On 6/3/22 2:02 PM, Eric Hammond wrote:


To the group,

A short intro: I have been a user of Quicken for the last 1000 years or so, 
they have gone from a business that cares about customers to  not so much.
Late last year one of their updates lost or scrambled years of my business accounting 
data, and my backups. Their help line help was "we are so sorry..."

I discovered GnuCash in February this year and with a lot of very hard work and 
digging got almost all entries into it: the major journals balance.
Six months of digging, creating and importing .csv files and seeing what broke. 
And repeat.

I would like to convert my brute force AR and AP entries into the GnuCash 
format and have encountered some issues:
Importing from CSV to regular journals was tricky, but I got it done and 
balanced.
Is there any way to import the invoice data from CSV to the 
invoices-A/Receivables, and bills-A/Payables system and have the Posted and 
Paid flags set right?

In the distant past I programmed accounting systems in RPG. Some help there.

I have much programming experience (PC computers unfortunately) in C, C++, and 
Python: I would like to help with the project.
I need help finding out how to do this, I have not yet found such in the 
website maze.

And, how do I contribute the money I would have paid for Quicken to this worthy 
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.

[GNC] need help getting started

[Eric Hammond]

To the group,

A short intro: I have been a user of Quicken for the last 1000 years or so, 
they have gone from a business that cares about customers to  not so much.
Late last year one of their updates lost or scrambled years of my business 
accounting data, and my backups. Their help line help was "we are so sorry..."

I discovered GnuCash in February this year and with a lot of very hard work and 
digging got almost all entries into it: the major journals balance.
Six months of digging, creating and importing .csv files and seeing what broke. 
And repeat.

I would like to convert my brute force AR and AP entries into the GnuCash 
format and have encountered some issues:
Importing from CSV to regular journals was tricky, but I got it done and 
balanced.
Is there any way to import the invoice data from CSV to the 
invoices-A/Receivables, and bills-A/Payables system and have the Posted and 
Paid flags set right?

In the distant past I programmed accounting systems in RPG. Some help there.

I have much programming experience (PC computers unfortunately) in C, C++, and 
Python: I would like to help with the project.
I need help finding out how to do this, I have not yet found such in the 
website maze.

And, how do I contribute the money I would have paid for Quicken to this worthy 
cause?

Thank you for your help,

Eric Hammond
670 Rainier Lane
Port Ludlow, WA 98365
(949) 244-3595
e...@jehammond.net

"Be the change that you wish to see in the world."
― Mahatma Gandhi



___
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] Need help importing Investment transactions

[davidcousens49]

David,

The issues with building GC4.9 on Ubuntu 20.04 are likely relatively minor as
far as I can see, and mainly those that first time builders of GnuCash encounter
with getting the dpendencies and build environment setup and enough familiarity
with the process to be able to avoid the common mistakes with relative
addressing etc.

I had absolutely no problems on Linux Mint which is an Ubuntu 20.04
derivative. I had to reinstall a couple of dependencies because I had downgraded
some libraries while installing another piece of software a couple of weeks ago
(I was expecting that problem) but once I had them reinstalled there was no
problem and it was built and installed in a few minutes.  David Whiting's script
looks pretty good

I had started to explore the CSV import of both single line and multiline CSV
with a view to documenting it better a year or two ago and then was sidetracked
by a physics project I have been involved with and I unfortunately have not got
back to doing that. One difficulty for me with this was that I am not actively
trading shares so I am not familiar and couldn't easily create suitable test
cases.

David Cousens

On Sat, 2021-12-25 at 14:52 -0600, David Carlson wrote:
> I almost forgot that there is an issue with release 3.8 where scheduled
> reinvested dividend transactions and other stock purchase transactions do
> not correctly apply the share price when the SX runs which I know has been
> fixed in the 4.something update.  Maybe that fix also fixed this issue?
> 
> On Sat, Dec 25, 2021 at 2:31 PM David Carlson 
> wrote:
> 
> > The main difference is that I am using release 3.8.  At the matching step
> > after I touch add so it won't erase the text in the existing transactions
> > it declares that the four non-zero value dividend  transactions are already
> > balanced and it won't let me assign an income account.
> > 
> > Then I touch Next and it accepts them without an imbalance transfer
> > account and I cannot manually edit them to add an income account.
> > That throws the brokerage account out of balance and the transaction
> > repair feature cannot fix it either.
> > 
> > I n other accounts the matching step will behave similarly on occasional
> > zero value transactions but I have been able to assign a special account
> > that I use exclusively for comments.
> > 
> > As you have seen in other threads here it is still an error-prone process
> > to upgrade Ubuntu LTS to Gnucash release 4.9.  I would want to try it in a
> > disposable virtual machine before committing my only working instance to
> > the upgrade.
> > 
> > On Sat, Dec 25, 2021, 12:15 PM john  wrote:
> > 
> > > Your example worked fine for me in GnuCash 4.9. I set it to ignore the
> > > first 5 rows, set the date field to Date, the description field to
> > > Description, and the Amount Field to deposit and ignored the rest. I used
> > > Assets:Investment:Brokerage Account for the target account. On import the
> > > matcher window came up with the several transactions. I clicked OK without
> > > bothering with matching and all were created with splits in Brokerage
> > > Account and Imbalance-USD.
> > > 
> > > What did you do?
> > > 
> > > Regards,
> > > John Ralls
> > > 
> > > 
> > > On Dec 25, 2021, at 8:26 AM, David Carlson 
> > > wrote:
> > > 
> > > I have created a test csv import file and I can replicate the single line
> > > out-of-balance imported transactions. .  Reminder, I am still using
> > > release
> > > 3.8 in Llnux Lite [Ubuntu 20.04].
> > > 
> > > The test file is pure text, I will quote it to be sure that it gets
> > > through.  Alas, that adds spurious carriage returns.  There should only be
> > > five transaction lines beginning with the date and no cr's until just
> > > before the next date.  I will try attaching it as well.
> > > I set it to import into the brokerage account skipping the header lines,
> > > assign import columns Date to Date, Memo to Type, Description to
> > > Description, Deposit to Amount, Transaction Commodity to Symbol and Price
> > > to Price. Then I make all five transactions new in the match step as there
> > > are existing similar transactions.  The dividend transaction does get a
> > > transfer to the correct account.
> > > 
> > > [Transactions
> > > Account: DianeIRA (*574)
> > > 
> > > Time Period: 07/01/2021 to 12/22/2021
> > > Transaction type: All transactions without Cash Sweep Activity
> > > 
> > > Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
> > > 08/02/2021,Dividend,"Bristol Myers Squibb Co
> > > Cash Div  On 475 Shs
> > > Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
> > > 08/02/2021,Dividend,"Pimco Corporate & Income
> > > Opportunity Fund
> > > Cash Div  On 600 Shs",,78,PTY,,
> > > 07/26/2021,Interest,"RBC Insured Deposits
> > > Monthly Interest 06/28-07/25
> > > Apye#: 00.01 %",,0.02,,,
> > > 07/09/2021,Dividend,"American Tower Corporation
> > > Reit
> > > Cash Div  On 150 Shs",,190.5,AMT,,
> > > 07/01/2021,Dividend,"Pimco 

Re: [GNC] Need help importing Investment transactions

[David Carlson]

I almost forgot that there is an issue with release 3.8 where scheduled
reinvested dividend transactions and other stock purchase transactions do
not correctly apply the share price when the SX runs which I know has been
fixed in the 4.something update.  Maybe that fix also fixed this issue?

On Sat, Dec 25, 2021 at 2:31 PM David Carlson 
wrote:

> The main difference is that I am using release 3.8.  At the matching step
> after I touch add so it won't erase the text in the existing transactions
> it declares that the four non-zero value dividend  transactions are already
> balanced and it won't let me assign an income account.
>
> Then I touch Next and it accepts them without an imbalance transfer
> account and I cannot manually edit them to add an income account.
> That throws the brokerage account out of balance and the transaction
> repair feature cannot fix it either.
>
> I n other accounts the matching step will behave similarly on occasional
> zero value transactions but I have been able to assign a special account
> that I use exclusively for comments.
>
> As you have seen in other threads here it is still an error-prone process
> to upgrade Ubuntu LTS to Gnucash release 4.9.  I would want to try it in a
> disposable virtual machine before committing my only working instance to
> the upgrade.
>
> On Sat, Dec 25, 2021, 12:15 PM john  wrote:
>
>> Your example worked fine for me in GnuCash 4.9. I set it to ignore the
>> first 5 rows, set the date field to Date, the description field to
>> Description, and the Amount Field to deposit and ignored the rest. I used
>> Assets:Investment:Brokerage Account for the target account. On import the
>> matcher window came up with the several transactions. I clicked OK without
>> bothering with matching and all were created with splits in Brokerage
>> Account and Imbalance-USD.
>>
>> What did you do?
>>
>> Regards,
>> John Ralls
>>
>>
>> On Dec 25, 2021, at 8:26 AM, David Carlson 
>> wrote:
>>
>> I have created a test csv import file and I can replicate the single line
>> out-of-balance imported transactions. .  Reminder, I am still using release
>> 3.8 in Llnux Lite [Ubuntu 20.04].
>>
>> The test file is pure text, I will quote it to be sure that it gets
>> through.  Alas, that adds spurious carriage returns.  There should only be
>> five transaction lines beginning with the date and no cr's until just
>> before the next date.  I will try attaching it as well.
>> I set it to import into the brokerage account skipping the header lines,
>> assign import columns Date to Date, Memo to Type, Description to
>> Description, Deposit to Amount, Transaction Commodity to Symbol and Price
>> to Price. Then I make all five transactions new in the match step as there
>> are existing similar transactions.  The dividend transaction does get a
>> transfer to the correct account.
>>
>> [Transactions
>> Account: DianeIRA (*574)
>>
>> Time Period: 07/01/2021 to 12/22/2021
>> Transaction type: All transactions without Cash Sweep Activity
>>
>> Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
>> 08/02/2021,Dividend,"Bristol Myers Squibb Co
>> Cash Div  On 475 Shs
>> Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
>> 08/02/2021,Dividend,"Pimco Corporate & Income
>> Opportunity Fund
>> Cash Div  On 600 Shs",,78,PTY,,
>> 07/26/2021,Interest,"RBC Insured Deposits
>> Monthly Interest 06/28-07/25
>> Apye#: 00.01 %",,0.02,,,
>> 07/09/2021,Dividend,"American Tower Corporation
>> Reit
>> Cash Div  On 150 Shs",,190.5,AMT,,
>> 07/01/2021,Dividend,"Pimco Corporate & Income
>> Opportunity Fund
>> Cash Div  On 600 Shs",,78,PTY,,]
>>
>> On Thu, Dec 23, 2021 at 12:58 PM David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> It will be a while before I can find an adequate time window to test and
>>> post an example csv with instructions to duplicate the single line
>>> transactions that I saw the other day.  I still have the csv file and the
>>> import configuration so I should be able to do it.  In the meantime have a
>>> nice holiday.
>>>
>>> On Thu, Dec 23, 2021 at 11:44 AM john  wrote:
>>>


 On Dec 22, 2021, at 8:58 PM, David Carlson 
 wrote:

 I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
 under a different label.  I think that the CSV transaction import has
 not
 been changed, between 3.8 and 4.9.  If that is not correct, then some
 of my
 issues may be bugs that have been fixed.

 I have read the current help manual section on importing transactions in
 csv format 
 which
 gave me a start, but there are some things that I cannot make work
 correctly.

 I have come to the conclusion that my brokerage house World Equity Group
 CSV exports probably need to be massaged, and possibly split up but
 there
 are a couple of issues that I need to understand in order to determine
 how
 to fix the 

Re: [GNC] Need help importing Investment transactions

[David Carlson]

The main difference is that I am using release 3.8.  At the matching step
after I touch add so it won't erase the text in the existing transactions
it declares that the four non-zero value dividend  transactions are already
balanced and it won't let me assign an income account.

Then I touch Next and it accepts them without an imbalance transfer account
and I cannot manually edit them to add an income account.
That throws the brokerage account out of balance and the transaction repair
feature cannot fix it either.

I n other accounts the matching step will behave similarly on occasional
zero value transactions but I have been able to assign a special account
that I use exclusively for comments.

As you have seen in other threads here it is still an error-prone process
to upgrade Ubuntu LTS to Gnucash release 4.9.  I would want to try it in a
disposable virtual machine before committing my only working instance to
the upgrade.

On Sat, Dec 25, 2021, 12:15 PM john  wrote:

> Your example worked fine for me in GnuCash 4.9. I set it to ignore the
> first 5 rows, set the date field to Date, the description field to
> Description, and the Amount Field to deposit and ignored the rest. I used
> Assets:Investment:Brokerage Account for the target account. On import the
> matcher window came up with the several transactions. I clicked OK without
> bothering with matching and all were created with splits in Brokerage
> Account and Imbalance-USD.
>
> What did you do?
>
> Regards,
> John Ralls
>
>
> On Dec 25, 2021, at 8:26 AM, David Carlson 
> wrote:
>
> I have created a test csv import file and I can replicate the single line
> out-of-balance imported transactions. .  Reminder, I am still using release
> 3.8 in Llnux Lite [Ubuntu 20.04].
>
> The test file is pure text, I will quote it to be sure that it gets
> through.  Alas, that adds spurious carriage returns.  There should only be
> five transaction lines beginning with the date and no cr's until just
> before the next date.  I will try attaching it as well.
> I set it to import into the brokerage account skipping the header lines,
> assign import columns Date to Date, Memo to Type, Description to
> Description, Deposit to Amount, Transaction Commodity to Symbol and Price
> to Price. Then I make all five transactions new in the match step as there
> are existing similar transactions.  The dividend transaction does get a
> transfer to the correct account.
>
> [Transactions
> Account: DianeIRA (*574)
>
> Time Period: 07/01/2021 to 12/22/2021
> Transaction type: All transactions without Cash Sweep Activity
>
> Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
> 08/02/2021,Dividend,"Bristol Myers Squibb Co
> Cash Div  On 475 Shs
> Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
> 08/02/2021,Dividend,"Pimco Corporate & Income
> Opportunity Fund
> Cash Div  On 600 Shs",,78,PTY,,
> 07/26/2021,Interest,"RBC Insured Deposits
> Monthly Interest 06/28-07/25
> Apye#: 00.01 %",,0.02,,,
> 07/09/2021,Dividend,"American Tower Corporation
> Reit
> Cash Div  On 150 Shs",,190.5,AMT,,
> 07/01/2021,Dividend,"Pimco Corporate & Income
> Opportunity Fund
> Cash Div  On 600 Shs",,78,PTY,,]
>
> On Thu, Dec 23, 2021 at 12:58 PM David Carlson <
> david.carlson@gmail.com> wrote:
>
>> It will be a while before I can find an adequate time window to test and
>> post an example csv with instructions to duplicate the single line
>> transactions that I saw the other day.  I still have the csv file and the
>> import configuration so I should be able to do it.  In the meantime have a
>> nice holiday.
>>
>> On Thu, Dec 23, 2021 at 11:44 AM john  wrote:
>>
>>>
>>>
>>> On Dec 22, 2021, at 8:58 PM, David Carlson 
>>> wrote:
>>>
>>> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
>>> under a different label.  I think that the CSV transaction import has not
>>> been changed, between 3.8 and 4.9.  If that is not correct, then some of
>>> my
>>> issues may be bugs that have been fixed.
>>>
>>> I have read the current help manual section on importing transactions in
>>> csv format 
>>> which
>>> gave me a start, but there are some things that I cannot make work
>>> correctly.
>>>
>>> I have come to the conclusion that my brokerage house World Equity Group
>>> CSV exports probably need to be massaged, and possibly split up but there
>>> are a couple of issues that I need to understand in order to determine
>>> how
>>> to fix the import data and to assign the proper names to the various
>>> fields.
>>>
>>> One issue is that in one test many transactions were imported as single
>>> line unbalanced transactions with no transfer account, not even an
>>> assignment to an unbalance account.  Why did GnuCash accept unbalanced
>>> transactions containing amounts? Applying Check and Repair to some of
>>> those
>>> transactions did not balance them to an unbalance account.
>>>
>>> Another issue is that I have not 

Re: [GNC] Need help importing Investment transactions

[john]

Your example worked fine for me in GnuCash 4.9. I set it to ignore the first 5 
rows, set the date field to Date, the description field to Description, and the 
Amount Field to deposit and ignored the rest. I used 
Assets:Investment:Brokerage Account for the target account. On import the 
matcher window came up with the several transactions. I clicked OK without 
bothering with matching and all were created with splits in Brokerage Account 
and Imbalance-USD.

What did you do?

Regards,
John Ralls


> On Dec 25, 2021, at 8:26 AM, David Carlson  
> wrote:
> 
> I have created a test csv import file and I can replicate the single line 
> out-of-balance imported transactions. .  Reminder, I am still using release 
> 3.8 in Llnux Lite [Ubuntu 20.04].
> 
> The test file is pure text, I will quote it to be sure that it gets through.  
> Alas, that adds spurious carriage returns.  There should only be five 
> transaction lines beginning with the date and no cr's until just before the 
> next date.  I will try attaching it as well.
> I set it to import into the brokerage account skipping the header lines, 
> assign import columns Date to Date, Memo to Type, Description to Description, 
> Deposit to Amount, Transaction Commodity to Symbol and Price to Price. Then I 
> make all five transactions new in the match step as there are existing 
> similar transactions.  The dividend transaction does get a transfer to the 
> correct account.
> 
> [Transactions
> Account: DianeIRA (*574)
> 
> Time Period: 07/01/2021 to 12/22/2021
> Transaction type: All transactions without Cash Sweep Activity
> 
> Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
> 08/02/2021,Dividend,"Bristol Myers Squibb Co
> Cash Div  On 475 Shs
> Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
> 08/02/2021,Dividend,"Pimco Corporate & Income
> Opportunity Fund
> Cash Div  On 600 Shs",,78,PTY,,
> 07/26/2021,Interest,"RBC Insured Deposits
> Monthly Interest 06/28-07/25
> Apye#: 00.01 %",,0.02,,,
> 07/09/2021,Dividend,"American Tower Corporation
> Reit
> Cash Div  On 150 Shs",,190.5,AMT,,
> 07/01/2021,Dividend,"Pimco Corporate & Income
> Opportunity Fund
> Cash Div  On 600 Shs",,78,PTY,,]
> 
> On Thu, Dec 23, 2021 at 12:58 PM David Carlson  > wrote:
> It will be a while before I can find an adequate time window to test and post 
> an example csv with instructions to duplicate the single line transactions 
> that I saw the other day.  I still have the csv file and the import 
> configuration so I should be able to do it.  In the meantime have a nice 
> holiday.
> 
> On Thu, Dec 23, 2021 at 11:44 AM john  > wrote:
> 
> 
>> On Dec 22, 2021, at 8:58 PM, David Carlson > > wrote:
>> 
>> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
>> under a different label.  I think that the CSV transaction import has not
>> been changed, between 3.8 and 4.9.  If that is not correct, then some of my
>> issues may be bugs that have been fixed.
>> 
>> I have read the current help manual section on importing transactions in
>> csv format > > which
>> gave me a start, but there are some things that I cannot make work
>> correctly.
>> 
>> I have come to the conclusion that my brokerage house World Equity Group
>> CSV exports probably need to be massaged, and possibly split up but there
>> are a couple of issues that I need to understand in order to determine how
>> to fix the import data and to assign the proper names to the various fields.
>> 
>> One issue is that in one test many transactions were imported as single
>> line unbalanced transactions with no transfer account, not even an
>> assignment to an unbalance account.  Why did GnuCash accept unbalanced
>> transactions containing amounts? Applying Check and Repair to some of those
>> transactions did not balance them to an unbalance account.
>> 
>> Another issue is that I have not figured out which column name should be
>> used for the number of shares in a purchase or sale transaction.
>> 
>> Yet another issue would be whether I can import everything into the
>> brokerage account or do I need to do something special to get stock
>> transactions assigned to the proper security account when appropriate?
>> 
>> A fourth issue would be whether I need to use the Multi-Split feature and,
>> if so, how to format the CSV file to make it assign the correct split lines
>> to the correct base transaction, and save it in CSV format if I built the
>> spreadsheet in LibreOffice Calc or equivalent
> 
> Your premise might be mistaken: There have been 40 commits in 
> gnucash/import-export/csv since 3.8 including several bug-fixes. However none 
> of the summaries say anything about creating single-split transactions. 
> You're right that that shouldn't be possible. Can you post an example or two 

Re: [GNC] Need help importing Investment transactions

[David Carlson]

I have created a test csv import file and I can replicate the single line
out-of-balance imported transactions. .  Reminder, I am still using release
3.8 in Llnux Lite [Ubuntu 20.04].

The test file is pure text, I will quote it to be sure that it gets
through.  Alas, that adds spurious carriage returns.  There should only be
five transaction lines beginning with the date and no cr's until just
before the next date.  I will try attaching it as well.
I set it to import into the brokerage account skipping the header lines,
assign import columns Date to Date, Memo to Type, Description to
Description, Deposit to Amount, Transaction Commodity to Symbol and Price
to Price. Then I make all five transactions new in the match step as there
are existing similar transactions.  The dividend transaction does get a
transfer to the correct account.

[Transactions
Account: DianeIRA (*574)

Time Period: 07/01/2021 to 12/22/2021
Transaction type: All transactions without Cash Sweep Activity

Date,Type,Description,Quantity,Amount,Symbol,Price,Check number
08/02/2021,Dividend,"Bristol Myers Squibb Co
Cash Div  On 475 Shs
Rec 07/02/21 Pay 08/02/21",,232.75,BMY,,
08/02/2021,Dividend,"Pimco Corporate & Income
Opportunity Fund
Cash Div  On 600 Shs",,78,PTY,,
07/26/2021,Interest,"RBC Insured Deposits
Monthly Interest 06/28-07/25
Apye#: 00.01 %",,0.02,,,
07/09/2021,Dividend,"American Tower Corporation
Reit
Cash Div  On 150 Shs",,190.5,AMT,,
07/01/2021,Dividend,"Pimco Corporate & Income
Opportunity Fund
Cash Div  On 600 Shs",,78,PTY,,]

On Thu, Dec 23, 2021 at 12:58 PM David Carlson 
wrote:

> It will be a while before I can find an adequate time window to test and
> post an example csv with instructions to duplicate the single line
> transactions that I saw the other day.  I still have the csv file and the
> import configuration so I should be able to do it.  In the meantime have a
> nice holiday.
>
> On Thu, Dec 23, 2021 at 11:44 AM john  wrote:
>
>>
>>
>> On Dec 22, 2021, at 8:58 PM, David Carlson 
>> wrote:
>>
>> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
>> under a different label.  I think that the CSV transaction import has not
>> been changed, between 3.8 and 4.9.  If that is not correct, then some of
>> my
>> issues may be bugs that have been fixed.
>>
>> I have read the current help manual section on importing transactions in
>> csv format 
>> which
>> gave me a start, but there are some things that I cannot make work
>> correctly.
>>
>> I have come to the conclusion that my brokerage house World Equity Group
>> CSV exports probably need to be massaged, and possibly split up but there
>> are a couple of issues that I need to understand in order to determine how
>> to fix the import data and to assign the proper names to the various
>> fields.
>>
>> One issue is that in one test many transactions were imported as single
>> line unbalanced transactions with no transfer account, not even an
>> assignment to an unbalance account.  Why did GnuCash accept unbalanced
>> transactions containing amounts? Applying Check and Repair to some of
>> those
>> transactions did not balance them to an unbalance account.
>>
>> Another issue is that I have not figured out which column name should be
>> used for the number of shares in a purchase or sale transaction.
>>
>> Yet another issue would be whether I can import everything into the
>> brokerage account or do I need to do something special to get stock
>> transactions assigned to the proper security account when appropriate?
>>
>> A fourth issue would be whether I need to use the Multi-Split feature and,
>> if so, how to format the CSV file to make it assign the correct split
>> lines
>> to the correct base transaction, and save it in CSV format if I built the
>> spreadsheet in LibreOffice Calc or equivalent
>>
>>
>> Your premise might be mistaken: There have been 40 commits in
>> gnucash/import-export/csv since 3.8 including several bug-fixes. However
>> none of the summaries say anything about creating single-split
>> transactions. You're right that that shouldn't be possible. Can you post an
>> example or two of CSV rows that do that?
>>
>> There isn't a column name for amount (see
>> https://bugs.gnucash.org/show_bug.cgi?id=797368), just for price, but
>> even that apparently doesn't work well:
>> https://bugs.gnucash.org/show_bug.cgi?id=793306 and
>> https://bugs.gnucash.org/show_bug.cgi?id=796955.
>>
>> If you root the import on the brokerage cash account you should be able
>> to designate the transfer accounts to the various stock's accounts in the
>> matcher if importing stock trades worked, see previous item.
>>
>> The easiest way to learn the format for multi-split CSV files is to do
>> File>Export>Export Transactions to CSV and examine the resulting
>> spreadsheet.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>>
>>
>>
>>
>
> --
> David Carlson
>


-- 
David Carlson
Transactions

Re: [GNC] Need help importing Investment transactions

[David Carlson]

It will be a while before I can find an adequate time window to test and
post an example csv with instructions to duplicate the single line
transactions that I saw the other day.  I still have the csv file and the
import configuration so I should be able to do it.  In the meantime have a
nice holiday.

On Thu, Dec 23, 2021 at 11:44 AM john  wrote:

>
>
> On Dec 22, 2021, at 8:58 PM, David Carlson 
> wrote:
>
> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
> under a different label.  I think that the CSV transaction import has not
> been changed, between 3.8 and 4.9.  If that is not correct, then some of my
> issues may be bugs that have been fixed.
>
> I have read the current help manual section on importing transactions in
> csv format  which
> gave me a start, but there are some things that I cannot make work
> correctly.
>
> I have come to the conclusion that my brokerage house World Equity Group
> CSV exports probably need to be massaged, and possibly split up but there
> are a couple of issues that I need to understand in order to determine how
> to fix the import data and to assign the proper names to the various
> fields.
>
> One issue is that in one test many transactions were imported as single
> line unbalanced transactions with no transfer account, not even an
> assignment to an unbalance account.  Why did GnuCash accept unbalanced
> transactions containing amounts? Applying Check and Repair to some of those
> transactions did not balance them to an unbalance account.
>
> Another issue is that I have not figured out which column name should be
> used for the number of shares in a purchase or sale transaction.
>
> Yet another issue would be whether I can import everything into the
> brokerage account or do I need to do something special to get stock
> transactions assigned to the proper security account when appropriate?
>
> A fourth issue would be whether I need to use the Multi-Split feature and,
> if so, how to format the CSV file to make it assign the correct split lines
> to the correct base transaction, and save it in CSV format if I built the
> spreadsheet in LibreOffice Calc or equivalent
>
>
> Your premise might be mistaken: There have been 40 commits in
> gnucash/import-export/csv since 3.8 including several bug-fixes. However
> none of the summaries say anything about creating single-split
> transactions. You're right that that shouldn't be possible. Can you post an
> example or two of CSV rows that do that?
>
> There isn't a column name for amount (see
> https://bugs.gnucash.org/show_bug.cgi?id=797368), just for price, but
> even that apparently doesn't work well:
> https://bugs.gnucash.org/show_bug.cgi?id=793306 and
> https://bugs.gnucash.org/show_bug.cgi?id=796955.
>
> If you root the import on the brokerage cash account you should be able to
> designate the transfer accounts to the various stock's accounts in the
> matcher if importing stock trades worked, see previous item.
>
> The easiest way to learn the format for multi-split CSV files is to do
> File>Export>Export Transactions to CSV and examine the resulting
> spreadsheet.
>
> Regards,
> John Ralls
>
>
>
>
>
>
>
>

-- 
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] Need help importing Investment transactions

[john]

> On Dec 22, 2021, at 8:58 PM, David Carlson  
> wrote:
> 
> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
> under a different label.  I think that the CSV transaction import has not
> been changed, between 3.8 and 4.9.  If that is not correct, then some of my
> issues may be bugs that have been fixed.
> 
> I have read the current help manual section on importing transactions in
> csv format  which
> gave me a start, but there are some things that I cannot make work
> correctly.
> 
> I have come to the conclusion that my brokerage house World Equity Group
> CSV exports probably need to be massaged, and possibly split up but there
> are a couple of issues that I need to understand in order to determine how
> to fix the import data and to assign the proper names to the various fields.
> 
> One issue is that in one test many transactions were imported as single
> line unbalanced transactions with no transfer account, not even an
> assignment to an unbalance account.  Why did GnuCash accept unbalanced
> transactions containing amounts? Applying Check and Repair to some of those
> transactions did not balance them to an unbalance account.
> 
> Another issue is that I have not figured out which column name should be
> used for the number of shares in a purchase or sale transaction.
> 
> Yet another issue would be whether I can import everything into the
> brokerage account or do I need to do something special to get stock
> transactions assigned to the proper security account when appropriate?
> 
> A fourth issue would be whether I need to use the Multi-Split feature and,
> if so, how to format the CSV file to make it assign the correct split lines
> to the correct base transaction, and save it in CSV format if I built the
> spreadsheet in LibreOffice Calc or equivalent

Your premise might be mistaken: There have been 40 commits in 
gnucash/import-export/csv since 3.8 including several bug-fixes. However none 
of the summaries say anything about creating single-split transactions. You're 
right that that shouldn't be possible. Can you post an example or two of CSV 
rows that do that?

There isn't a column name for amount (see 
https://bugs.gnucash.org/show_bug.cgi?id=797368 
), just for price, but even 
that apparently doesn't work well: 
https://bugs.gnucash.org/show_bug.cgi?id=793306 
 and 
https://bugs.gnucash.org/show_bug.cgi?id=796955 
.

If you root the import on the brokerage cash account you should be able to 
designate the transfer accounts to the various stock's accounts in the matcher 
if importing stock trades worked, see previous item.

The easiest way to learn the format for multi-split CSV files is to do 
File>Export>Export Transactions to CSV and examine the resulting spreadsheet.

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.

[GNC] Need help importing Investment transactions

[David Carlson]

I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
under a different label.  I think that the CSV transaction import has not
been changed, between 3.8 and 4.9.  If that is not correct, then some of my
issues may be bugs that have been fixed.

I have read the current help manual section on importing transactions in
csv format  which
gave me a start, but there are some things that I cannot make work
correctly.

I have come to the conclusion that my brokerage house World Equity Group
CSV exports probably need to be massaged, and possibly split up but there
are a couple of issues that I need to understand in order to determine how
to fix the import data and to assign the proper names to the various fields.

One issue is that in one test many transactions were imported as single
line unbalanced transactions with no transfer account, not even an
assignment to an unbalance account.  Why did GnuCash accept unbalanced
transactions containing amounts? Applying Check and Repair to some of those
transactions did not balance them to an unbalance account.

Another issue is that I have not figured out which column name should be
used for the number of shares in a purchase or sale transaction.

Yet another issue would be whether I can import everything into the
brokerage account or do I need to do something special to get stock
transactions assigned to the proper security account when appropriate?

A fourth issue would be whether I need to use the Multi-Split feature and,
if so, how to format the CSV file to make it assign the correct split lines
to the correct base transaction, and save it in CSV format if I built the
spreadsheet in LibreOffice Calc or equivalent

-- 
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] Need help

[Fross, Michael]

Hello Glen,

As a note of encouragement, I also read it when I first started after
bumping my head into things which now seem obvious.  The authors did a very
nice job making it easily readable and walking you through step by step.
It doesn't answer every question, but it gives you the foundation which is
really needed to be successful.

Have fun with it and welcome to the community.

Michael

On Fri, Apr 16, 2021 at 8:40 AM David Carlson 
wrote:

> Glen,
> Welcome!
> Because it is so easy to make practice files and more practice files and
> delete and start over, you do not need to read the entire 311 pages before
> you start!
>
> Also, the only test is the one where you get a result that meets your
> needs.
>
> On Fri, Apr 16, 2021 at 6:05 AM Liz  wrote:
>
> > On Fri, 16 Apr 2021 12:54:33 +0200
> > "Glen Bailie"  wrote:
> >
> > > Dear Sirs,
> > >
> > > I am trying to set up a set of books, but have come across some
> > > problems for which I need help.
> > >
> > > !) How do I get into Accounts,
> > >
> > > 2) How do I do transactions from a bank cheque account, such as
> > > receipts and payments that are not from customers or vendors. For
> > > example bank charges, and subscriptions.
> > >
> > > 3) When I enter a new Vendor, I get the message " no valid vendor can
> > > be found" What is wrong  here?
> > >
> > >
> > >
> > > Would you please give me detailed instructions about solving the above
> > > problems.
> > >
> > > Regards,
> > >
> > > Glen Bailie
> > >
> >
> > Glen
> > Welcome here
> > I think that you would do well to read the concepts guide and tutorial,
> > which does have detailed explanations, and then start a set of books
> > simply to experiment with and practise in.
> >
> > https://code.gnucash.org/docs/C/gnucash-guide.pdf
> >
> > Warning, because it is detailed, it's 311 pages long.
> >
> > Then come back with your questions.
> >
> > 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.
> >
>
>
> --
> 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.
>
___
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] Need help

[David Carlson]

Glen,
Welcome!
Because it is so easy to make practice files and more practice files and
delete and start over, you do not need to read the entire 311 pages before
you start!

Also, the only test is the one where you get a result that meets your needs.

On Fri, Apr 16, 2021 at 6:05 AM Liz  wrote:

> On Fri, 16 Apr 2021 12:54:33 +0200
> "Glen Bailie"  wrote:
>
> > Dear Sirs,
> >
> > I am trying to set up a set of books, but have come across some
> > problems for which I need help.
> >
> > !) How do I get into Accounts,
> >
> > 2) How do I do transactions from a bank cheque account, such as
> > receipts and payments that are not from customers or vendors. For
> > example bank charges, and subscriptions.
> >
> > 3) When I enter a new Vendor, I get the message " no valid vendor can
> > be found" What is wrong  here?
> >
> >
> >
> > Would you please give me detailed instructions about solving the above
> > problems.
> >
> > Regards,
> >
> > Glen Bailie
> >
>
> Glen
> Welcome here
> I think that you would do well to read the concepts guide and tutorial,
> which does have detailed explanations, and then start a set of books
> simply to experiment with and practise in.
>
> https://code.gnucash.org/docs/C/gnucash-guide.pdf
>
> Warning, because it is detailed, it's 311 pages long.
>
> Then come back with your questions.
>
> 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.
>


-- 
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] Need help

[Liz]

On Fri, 16 Apr 2021 12:54:33 +0200
"Glen Bailie"  wrote:

> Dear Sirs,
> 
> I am trying to set up a set of books, but have come across some
> problems for which I need help.
> 
> !) How do I get into Accounts,
> 
> 2) How do I do transactions from a bank cheque account, such as
> receipts and payments that are not from customers or vendors. For
> example bank charges, and subscriptions.
> 
> 3) When I enter a new Vendor, I get the message " no valid vendor can
> be found" What is wrong  here? 
> 
>  
> 
> Would you please give me detailed instructions about solving the above
> problems.
> 
> Regards,
> 
> Glen Bailie 
> 

Glen
Welcome here
I think that you would do well to read the concepts guide and tutorial,
which does have detailed explanations, and then start a set of books
simply to experiment with and practise in.

https://code.gnucash.org/docs/C/gnucash-guide.pdf

Warning, because it is detailed, it's 311 pages long.

Then come back with your questions.

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.

[GNC] Need help

[Glen Bailie]

Dear Sirs,

I am trying to set up a set of books, but have come across some problems for
which I need help.

!) How do I get into Accounts,

2) How do I do transactions from a bank cheque account, such as receipts and
payments that are not from customers or vendors. For example bank charges,
and subscriptions.

3) When I enter a new Vendor, I get the message " no valid vendor can be
found" What is wrong  here? 

 

Would you please give me detailed instructions about solving the above
problems.

Regards,

Glen Bailie 

___
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] Need help correcting transaction account [RESOLVED]

[Rich Shepard]

On Mon, 1 Mar 2021, Adrien Monteleone wrote:


The context menu (right click) should give you the option to open the
invoice. The should work for either the invoice transaction or linked
payment transaction.


Adrien,

That right click did the trick; it never occurred to me to try that on
anything.

Yes, I was able to display the invoice, unpost it, change the transfer
account, and re-post it. Now it shows up where it belongs.

Thanks very much for the valuable lesson!

Stay well,

Rich
___
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] Need help correcting transaction account

[Adrien Monteleone]

The invoice # is supposed to appear in the NUM/Action column. (Also, an 
"I" appears to the right of the date for invoices/bills, and for 
payments it is a "P")


The context menu (right click) should give you the option to open the 
invoice. The should work for either the invoice transaction or linked 
payment transaction.


If you can't find either transaction, Run a Vendor/Customer Report and 
turn on Options > Display Columns > Transaction Links > Simple/Detailed 
to see the invoice that payment applied to.


Regards,
Adrien

On 3/1/21 11:41 AM, Rich Shepard wrote:



Ah! I overlooked that account. I see it in the A/P register but there's no
invoice number in any of the columns. I don't suppose I can directly delete
that A/P transaction and it's invoice and recreate the invoice and payment
correctly?


___
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] Need help correcting transaction account

[Rich Shepard]

On Mon, 1 Mar 2021, Derek Atkins wrote:


Jump over to the AR/AP account for the transaction and there it should
have the Invoice # in the register.


derek,

Ah! I overlooked that account. I see it in the A/P register but there's no
invoice number in any of the columns. I don't suppose I can directly delete
that A/P transaction and it's invoice and recreate the invoice and payment
correctly?

Regards,

Rich
___
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] Need help correcting transaction account

[Derek Atkins]

HI,

Jump over to the AR/AP account for the transaction and there it should
have the Invoice # in the register.

-derek

On Mon, March 1, 2021 12:21 pm, Rich Shepard wrote:
> ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to
> the loan liability account rather than to the members draw expense
> account.
>
> I cannot delete that transaction and re-enter it because gnucash tells me
> it
> was paid on an invoice, and I cannot find that invoice searching for the
> payee name in the Business->Vendor->Find invoice dialog box.
>
> I'm stymied and need to learn how to correct that transaction. The
> liability
> account should show only the PPP loan amount while the draw against it
> should be to the Expenses->SBA-PPP Salary account.
>
> TIA,
>
> Rich
>
> ___
> 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.

[GNC] Need help correcting transaction account

[Rich Shepard]

ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to
the loan liability account rather than to the members draw expense account.

I cannot delete that transaction and re-enter it because gnucash tells me it
was paid on an invoice, and I cannot find that invoice searching for the
payee name in the Business->Vendor->Find invoice dialog box.

I'm stymied and need to learn how to correct that transaction. The liability
account should show only the PPP loan amount while the draw against it
should be to the Expenses->SBA-PPP Salary account.

TIA,

Rich

___
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] Need help using Gnucash IRC to live chat

[David Carlson]

Derek is right.  Wiki IRC to find a list.

On Sat, Dec 5, 2020, 10:45 AM Derek Atkins  wrote:

> There are tons of free IRC clients.
> -derek
>
> On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
> > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are
> > their any free open source alternatives to mIRC?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.
> >
>
>
> --
>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] Need help using Gnucash IRC to live chat

[Derek Atkins]

There are tons of free IRC clients.
-derek

On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote:
> 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are
> their any free open source alternatives to mIRC?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.
>


-- 
   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.

[GNC] Need help using Gnucash IRC to live chat

[Fran_3 via gnucash-user]

1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are their 
any free open source alternatives to mIRC?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.

Re: [GNC] Need help related to mortgages

[David Cousens]

Anthony

This forum is not for advice on financial matters per se but only on how to
use the Gnucash accounting program to record financial events. You need to
consult your financial adviser or an accountant for the advice you are
seeking. 

David Cousens



-
David Cousens
--
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.

[GNC] Need help related to mortgages

[AnthonyLy]

I am planning to buy my first house in the near future. Have a few questions
about the buying process. From my understanding, the pre-approval rate that
you get may not be the same as the rate you get when you are actually
approved. You may receive a lower rate once your offer on a house is
accepted and you are applying for a mortgage. 
So, do you apply for a few mortgages after your offer has been accepted by
the seller? Would you just contact a few mortgage brokers and ask them the
best rate they can give you after your offer on the house is accepted? Are
there any penalties if you are already approved from one lender but don't go
through with it because you found a lower rate elsewhere? Is there any point
in going to multiple brokers for pre-approval?
Also, if I choose to go  with a three year fixed rate

  
would that be a good idea or should I go with the variable rate?



--
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] Need help reconciling

[Derek Atkins]

Hi,

ToddAndMargo via gnucash-user  writes:

> okay, I am just not understanding.
>
> In the reconcile window
>
> 1) I presume "Statement Date" is my statement's closing
>date?

Correct.

> 1) the statement date matches my bank statement

Good.

> 2) starting balance is 0 (it is not)

I assume this is your first time reconciling in GnuCash?  If so, that is
correct.  In general you can safely ignore the starting balance -- if
there is a difference it means something "earlier" is not properly
reconciled so you will need to click off "extra" stuff.

> 3) Ending Balance matches my statement

Good.  If it doesn't you need to enter in the correct ending balance
from your statement.

> 4) there is a -$700 reconcile Balance.

I presume there is a $700 opening balance in the account?  Just
reconcile that the first time, too.

> I just do not understand

Reconciliation is always "from the beginning of time through the end
date".  This means that the first time you reconcile an account you need
to also include the opening balance transaction in the reconcile
process.

Going forward you wont have to do that, because the starting balance
*should* match your account statement.

Hope this helps!

> 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] Need help reconciling

[David Cousens]

Todd

The Statement date is the closing date on your statement. If the statement
date does not match then you set it to the closing date on your statement.

I have never changed the reconcile status to c or anything else (unless I
needed to manually unreconcile a statement period which I don't ever
remember having to do) manually on any transactions. There may be a case for
doing this if you use a check book perhaps.

The starting balance should be the closing balance of the last
reconciliation. If it is 0 the GnuCash does not recognize that there has
been any previous reconciliation. In this case if the account setup in
GnuCash matches a pre-existing bank account, that account will not have had
a zero balance when you started using GnuCash. The first transaction to
reconcile will be the transaction setup to set the opening balance in the
account when you created it (or set it manually after creation of the
account in GnuCash). That opening balance for the account in GnuCash should
have been set to the closing balance of the statement of the period before
the first period you started using Gnucash. This would appear to be the step
you are missing when setting up Gnucash for an existing account.

You then enter the closing balance from your current statement as the ending
balance for the reconciliation.

If it is a credit card and interest charges for the period have not been
entered into GnuCash you can enter these by pressing the ENter Interest
Charges button . Ignore if the interest charges are already entered  or
there are none.

Press OK.  The next window will show payments into the account on the LHS
and withdrawals from the account on the RHS. GnuCash will attempt to select
those transactions which fall within the statement period set in the
previous setup window and they will appear with the checkboxes checked. By
default the transactions are usually arranged in date order of the entries.

Check 1.  Any unchecked entries at the top of either window pane are a
likely problem. They will generally indicate unreconciled transactions
earlier in your GnuCash records than the period currently being reconciled.
They need to be fixed ( identify whether they are duplicates or wrong
amounts entered etc) because if not, your reconciliation up to the start of
the current period is not correct. After fixing them you will need to at
least check that your reconciliation up to the start of the current period
is now correct. That may mean reconciling again completely from the start
although GnuCash generally appears to reflect any changes you make in the
accounts directly into the reconciliation window as they happen.

Check 2.  In the summary panel at the bottom of the window, the starting
balance should be the starting balance of the statement, the closing balance
should equal the closing balance  of the statement and if you are lucky (
i.e. no errors in the current period), the reconciled balance will equal the
closing balance).

Check 3 If the reconciled and closing balances match and the difference is
zero check that all the payments into the account and withdrawals from the
account for the date range in the current period are checked. If this is the
case then your reconciliation is probably complete. 

Check 4 If there are any unchecked payments or withdrawals with dates in the
current statement period, then you have an error - find out why and fix it
then repeat the reconciliation from the startuntil all of the above are
correct.

Check 5 If any checked entry in either pane falls outside the date range of
the current statement, this is an error either in the date of the
transaction. Find out why and fix it - then repeat the reconciliation from
the start

At this point you can press the finish button and your account should
reconcile and the newly reconciled entries will have a "y" in the reconcile
status column.

I personally do not use the above. I uncheck all entries (Ctrl-A then use
the Unreconcile Selection button) then check each entry off individually as
I match it against the corresponding entries in the statement, but I'm an
accountant and therefore pedantic. 

David Cousens 





-
David Cousens
--
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] Need help reconciling

[Adrien Monteleone]

You have to fix the starting balance first.

If this is your first reconcile of a pre-existing account, read the docs as 
this is a little different.

More than likely, you can just reconcile starting from zero and include your 
Opening Balance transaction which should get you to the proper ending balance. 
(note, the Opening Balance transaction in this case *should* be equal to the 
Starting Balance from your first statement that you are reconciling)

Regards,
Adrien

> On May 10, 2019, at 5:04 PM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> On 4/26/19 3:19 PM, ToddAndMargo via gnucash-user wrote:
>> Hi All,
>> I have been looking over the "Reconcile" on on eof m yu
>> credit card account.  I just don understand what I am seeing.
>> 1) do I put a "c" in the opening balance as I
>> I has checked it?
>> 2) I have put "C" in all the charges on my bank statement.
>> 3) I press the Reconcile button and I put in the closing data.
>> It puts a weird entry into the the ledger that I don't understand
>> and puts it on one of those weird  "you goofed" accounts.  And
>> I get no "y"'s.
>> I look at the doc and I have no clue what is going on.
>> https://gnucash.org/viewdoc.phtml?rev=3=C=help
>> https://gnucash.org/viewdoc.phtml?rev=3=C=guide
>> :'(
>> -T
> 
> okay, I am just not understanding.
> 
> In the reconcile window
> 
> 1) I presume "Statement Date" is my statement's closing
>   date?
> 
> 1) the statement date matches my bank statement
> 
> 2) starting balance is 0 (it is not)
> 
> 3) Ending Balance matches my statement
> 
> 4) there is a -$700 reconcile Balance.
> 
> I just do not understand
> 


___
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/26/19 3:19 PM, ToddAndMargo via gnucash-user wrote:

Hi All,

I have been looking over the "Reconcile" on on eof m yu
credit card account.  I just don understand what I am seeing.

1) do I put a "c" in the opening balance as I
I has checked it?

2) I have put "C" in all the charges on my bank statement.

3) I press the Reconcile button and I put in the closing data.

It puts a weird entry into the the ledger that I don't understand
and puts it on one of those weird  "you goofed" accounts.  And
I get no "y"'s.

I look at the doc and I have no clue what is going on.
     https://gnucash.org/viewdoc.phtml?rev=3=C=help
     https://gnucash.org/viewdoc.phtml?rev=3=C=guide

:'(

-T


okay, I am just not understanding.

In the reconcile window

1) I presume "Statement Date" is my statement's closing
   date?

1) the statement date matches my bank statement

2) starting balance is 0 (it is not)

3) Ending Balance matches my statement

4) there is a -$700 reconcile Balance.

I just do not understand


___
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/27/19 2:29 AM, Liz wrote:

We all learn in different combinations of three main ways
Hearing, Doing and Seeing
It doesn't matter how.
Most importantly
Some people just don't learn from lectures
some just don't learn from reading a book

some only learn by doing and asking questions.
Sometimes they have the skills to research the answers to questions
Sometimes they don't have the skills to know what question to ask.


Fascinating analysis!  Charitable too.


___
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/27/19 3:18 AM, Michael Hendry wrote:

On 27 Apr 2019, at 10:29, Liz  wrote:

On Sat, 27 Apr 2019 14:16:25 +0530
"David T. via gnucash-user"  wrote:


ToddAndMango, you might try reading the documentation.


I'm going to put my education hat on here

We all learn in different combinations of three main ways
Hearing, Doing and Seeing
It doesn't matter how.
Most importantly
Some people just don't learn from lectures
some just don't learn from reading a book

some only learn by doing and asking questions.
Sometimes they have the skills to research the answers to questions
Sometimes they don't have the skills to know what question to ask.

For the human identified as ToddAndMargo

I think we'd understand more if you could send some screenshots and a
bit more detail as you ask questions.

Liz
The Moderator


Couldn’t agree more, Liz, and especially the bit about knowing what question to 
ask.

In my past life as a GP facing a set of symptoms and signs that I couldn’t 
assemble into a diagnosis, I would suggest a referral to a consultant.

Away from the pressures of the consulting room, I would construct a referral 
letter containing a coherent history and clinical findings and in the process 
find that the diagnosis fell into my lap - not unlike the awkward crossword 
clue that mysteriously solves itself overnight.

Michael


Tell me what is missing.  But wait till I get a chance to
read the manual, which will be about two weeks.  I will
get back.




___
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/27/19 2:29 AM, Liz wrote:

For the human identified as ToddAndMargo


Can't think of a way to remove the private information


___
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] Need help reconciling

[Michael Hendry]

> On 27 Apr 2019, at 10:29, Liz  wrote:
> 
> On Sat, 27 Apr 2019 14:16:25 +0530
> "David T. via gnucash-user"  wrote:
> 
>> ToddAndMango, you might try reading the documentation.
> 
> I'm going to put my education hat on here
> 
> We all learn in different combinations of three main ways
> Hearing, Doing and Seeing
> It doesn't matter how.
> Most importantly
> Some people just don't learn from lectures 
> some just don't learn from reading a book
> 
> some only learn by doing and asking questions.
> Sometimes they have the skills to research the answers to questions
> Sometimes they don't have the skills to know what question to ask.
> 
> For the human identified as ToddAndMargo
> 
> I think we'd understand more if you could send some screenshots and a
> bit more detail as you ask questions.
> 
> Liz
> The Moderator

Couldn’t agree more, Liz, and especially the bit about knowing what question to 
ask.

In my past life as a GP facing a set of symptoms and signs that I couldn’t 
assemble into a diagnosis, I would suggest a referral to a consultant.

Away from the pressures of the consulting room, I would construct a referral 
letter containing a coherent history and clinical findings and in the process 
find that the diagnosis fell into my lap - not unlike the awkward crossword 
clue that mysteriously solves itself overnight.

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] Need help reconciling

[Liz]

On Sat, 27 Apr 2019 14:16:25 +0530
"David T. via gnucash-user"  wrote:

> ToddAndMango, you might try reading the documentation.

I'm going to put my education hat on here

We all learn in different combinations of three main ways
Hearing, Doing and Seeing
It doesn't matter how.
Most importantly
Some people just don't learn from lectures 
some just don't learn from reading a book

some only learn by doing and asking questions.
Sometimes they have the skills to research the answers to questions
Sometimes they don't have the skills to know what question to ask.

For the human identified as ToddAndMargo

I think we'd understand more if you could send some screenshots and a
bit more detail as you ask questions.

Liz
The Moderator
___
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] Need help reconciling

[David T. via gnucash-user]

All of this is covered in the Guide at 
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1
 
,
 especially 2.9.4.1, which includes a section regarding the starting balance, 
as well as a note specifically about the starting balance:

Note
The first time you reconcile your account, the starting balance will be 0.00, 
thus probably not the opening balance of your account. When you reconcile the 
account, the opening balance for the account will be included in the 
reconciliation, and the result should balance.


ToddAndMango, you might try reading the documentation.

David T.

> On Apr 27, 2019, at 1:18 PM, Colin Law  > wrote:
> 
> On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
> mailto:gnucash-user@gnucash.org>> wrote:
>> 
>> On 4/27/19 12:11 AM, Colin Law wrote:
>>> I am sure we have been over this before.  You should not generally
>>> need to touch the reconcile column in the register yourself.  It is
>>> all done through the Reconcile feature.  Open the credit card (or
>>> bank) account and select Options > Reconcile.  Check the opening
>>> balance matches the opening balance on the statement from the bank,
>>> enter the closing balance from the statement and then tick off the
>>> transactions.
>>> 
>>> Colin
>> 
>> Something is wrong.  I don't have an opening Balance.  It
>> says it is zero
> 
> If it is the first time you have reconciled this account then it will
> be zero, and you should see your opening balance that you entered in
> the reconcile window.  Obviously that is not in the bank statement.
> This is a one-off situation due to the fact that you have started
> using gnucash with the account already up and running.
> 
>> 
>> ___
>> 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] Need help reconciling

[Colin Law]

On Sat, 27 Apr 2019 at 08:48, Colin Law  wrote:
>
> On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
>  wrote:
> >
> > On 4/27/19 12:11 AM, Colin Law wrote:
> > > I am sure we have been over this before.  You should not generally
> > > need to touch the reconcile column in the register yourself.  It is
> > > all done through the Reconcile feature.  Open the credit card (or
> > > bank) account and select Options > Reconcile.  Check the opening
> > > balance matches the opening balance on the statement from the bank,
> > > enter the closing balance from the statement and then tick off the
> > > transactions.
> > >
> > > Colin
> >
> > Something is wrong.  I don't have an opening Balance.  It
> > says it is zero
>
> If it is the first time you have reconciled this account then it will
> be zero, and you should see your opening balance that you entered in
> the reconcile window.  Obviously that is not in the bank statement.
> This is a one-off situation due to the fact that you have started
> using gnucash with the account already up and running.

I meant that you should see your opening balance in the list of
transactions waiting to be ticked off.

>
> >
> > ___
> > 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] Need help reconciling

[Colin Law]

On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
 wrote:
>
> On 4/27/19 12:11 AM, Colin Law wrote:
> > I am sure we have been over this before.  You should not generally
> > need to touch the reconcile column in the register yourself.  It is
> > all done through the Reconcile feature.  Open the credit card (or
> > bank) account and select Options > Reconcile.  Check the opening
> > balance matches the opening balance on the statement from the bank,
> > enter the closing balance from the statement and then tick off the
> > transactions.
> >
> > Colin
>
> Something is wrong.  I don't have an opening Balance.  It
> says it is zero

If it is the first time you have reconciled this account then it will
be zero, and you should see your opening balance that you entered in
the reconcile window.  Obviously that is not in the bank statement.
This is a one-off situation due to the fact that you have started
using gnucash with the account already up and running.

>
> ___
> 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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/27/19 12:11 AM, Colin Law wrote:

I am sure we have been over this before.  You should not generally
need to touch the reconcile column in the register yourself.  It is
all done through the Reconcile feature.  Open the credit card (or
bank) account and select Options > Reconcile.  Check the opening
balance matches the opening balance on the statement from the bank,
enter the closing balance from the statement and then tick off the
transactions.

Colin


Something is wrong.  I don't have an opening Balance.  It
says it is zero

___
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] Need help reconciling

[Colin Law]

I am sure we have been over this before.  You should not generally
need to touch the reconcile column in the register yourself.  It is
all done through the Reconcile feature.  Open the credit card (or
bank) account and select Options > Reconcile.  Check the opening
balance matches the opening balance on the statement from the bank,
enter the closing balance from the statement and then tick off the
transactions.

Colin

On Fri, 26 Apr 2019 at 23:22, ToddAndMargo via gnucash-user
 wrote:
>
> Hi All,
>
> I have been looking over the "Reconcile" on on eof m yu
> credit card account.  I just don understand what I am seeing.
>
> 1) do I put a "c" in the opening balance as I
> I has checked it?
>
> 2) I have put "C" in all the charges on my bank statement.
>
> 3) I press the Reconcile button and I put in the closing data.
>
> It puts a weird entry into the the ledger that I don't understand
> and puts it on one of those weird  "you goofed" accounts.  And
> I get no "y"'s.
>
> I look at the doc and I have no clue what is going on.
>  https://gnucash.org/viewdoc.phtml?rev=3=C=help
>  https://gnucash.org/viewdoc.phtml?rev=3=C=guide
>
> :'(
>
> -T
>
> ___
> 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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/26/19 10:13 PM, Liz wrote:

On Fri, 26 Apr 2019 19:59:32 -0500 (CDT)
David Cousens  wrote:


Me: Where's the  ?
Wife: In the refrigerator.
Me: No it isn't.
Wife: Yes it is.
Me: Definitely is not!
Wife: Walks to refrigerator, opens the door grab.s .  from the
front of the middle shelf.
Wife Dirty look.



Here it's called "boy look"
as in
"You only had a boy look"

:D

Liz


It probably wasn't shiny enough

:-)

___
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] Need help reconciling

[Liz]

On Fri, 26 Apr 2019 19:59:32 -0500 (CDT)
David Cousens  wrote:

> Me: Where's the  ?
> Wife: In the refrigerator.
> Me: No it isn't.
> Wife: Yes it is.
> Me: Definitely is not!
> Wife: Walks to refrigerator, opens the door grab.s .  from the
> front of the middle shelf.
> Wife Dirty look.


Here it's called "boy look" 
as in
"You only had a boy look"

:D

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] Need help reconciling

[Tommy Trussell]

On Fri, Apr 26, 2019 at 6:44 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 4/26/19 4:36 PM, Tommy Trussell wrote:
> > Most of the time you probably don't want to bother with the n or c flags
> > in the ledger -- let GnuCash do that for you, through the
>
> I think the rest of your sentence got cut off.. Anyway, I dod not
> follow.  :'(
>
>
My apologies ... I got called away from the office for a few hours and I
hit SEND thinking I had finished the thought. If the manual doesn't give
you what you need please ask more.


> -
> 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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/26/19 5:59 PM, David Cousens wrote:

Me: Where's the  ?
Wife: In the refrigerator.
Me: No it isn't.
Wife: Yes it is.
Me: Definitely is not!
Wife: Walks to refrigerator, opens the door grab.s .  from the front of
the middle shelf.
Wife Dirty look.


That could be my house!

___
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] Need help reconciling

[Cricket Onebit]

Sounds like me at the grocery store. Just tell me what aisle, even better
something big beside it, and like magic it appears, even though I'd already
checked that area thoroughly.

On Fri, 26 Apr 2019 at 20:35, David Cousens 
wrote:

> Todd,
>
> >Why I could not find it on my own, I can only speculate ...
>
> We all went through not being able to find stuff at one point. Sometimes
> the
> greatest help is just knowing it exists somewhere.
>
> David
>
>
>
>
> -
> David Cousens
> --
> 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.
>


-- 
+++

Not as a ladder from earth to Heaven, not as a witness to any creed,
But simple service simply given to his own kind in their common need.
-- Rudyard Kipling
___
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] Need help reconciling

[David Cousens]

Todd,

>Why I could not find it on my own, I can only speculate ... 

We all went through not being able to find stuff at one point. Sometimes the
greatest help is just knowing it exists somewhere.

David




-
David Cousens
--
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/26/19 4:55 PM, David Cousens wrote:

Todd,

Google "GnuCash" and a keyword or phrase  and google will usually locate
specific info within the documentation on a topic. Doesn't always work but
usually gets you into the ballpark.

Google "GnuCash reconcile"  lists the relevant help manual entry as well as
the tutorial and concepts guide entries on that topic for example and often
the wiki pages which may have up to date info not yet in the documentation
for example.

David Cousens.


Tommy sent me to

https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html

Why I could not find it on my own, I can only speculate ...

___
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] Need help reconciling

[ToddAndMargo via gnucash-user]

On 4/26/19 4:57 PM, David Carlson wrote:

If you are using GMail


Zoho mail


___
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] Need help reconciling

[David Carlson]

ToddAndMargo,

If you are using GMail, it tries to hide what it considers less important,
which often accidentally hides important information.

Click on the three dots icon to see the rest.

David Carlson

On Fri, Apr 26, 2019 at 6:43 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> >
> > https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html
>
> Thank you!  Now I have a place to start.  For the life of
> me I could not find that chapter!  I bet it was right under
> my nose too!
>
>
> On 4/26/19 4:36 PM, Tommy Trussell wrote:
> > Most of the time you probably don't want to bother with the n or c flags
> > in the ledger -- let GnuCash do that for you, through the
>
> I think the rest of your sentence got cut off.. Anyway, I dod not
> follow.  :'(
>
>
> ___
> 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] Need help reconciling

[David Cousens]

Todd,

Google "GnuCash" and a keyword or phrase  and google will usually locate
specific info within the documentation on a topic. Doesn't always work but
usually gets you into the ballpark.

Google "GnuCash reconcile"  lists the relevant help manual entry as well as
the tutorial and concepts guide entries on that topic for example and often
the wiki pages which may have up to date info not yet in the documentation
for example.

David Cousens.



-
David Cousens
--
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] Need help reconciling

[Tommy Trussell]

Hi! Welcome to GnuCash!

On Fri, Apr 26, 2019 at 5:22 PM ToddAndMargo via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I have been looking over the "Reconcile" on on eof m yu
> credit card account.  I just don understand what I am seeing.
>
> 1) do I put a "c" in the opening balance as I
> I has checked it?
>

When you reconcile, you want to use the Reconcile window. Here's the
specific part of the manual that deals with Credit Card accounts -- have a
glance through here

https://www.gnucash.org/docs/v3/C/gnucash-guide/cc-together1.html


> 2) I have put "C" in all the charges on my bank statement.
>

Most of the time you probably don't want to bother with the n or c flags in
the ledger -- let GnuCash do that for you, through the


> 3) I press the Reconcile button and I put in the closing data.
>
> It puts a weird entry into the the ledger that I don't understand
> and puts it on one of those weird  "you goofed" accounts.  And
> I get no "y"'s.
>
>
It sounds like you may have had GnuCash create a correcting entry INSTEAD
of finding the discrepancy in the data you've entered. When you have
everything verified against your statement, you shouldn't need to enter a
correcting entry, unless the problem preceded the month you are looking at.

Alternatively, are you looking at the same account? You would open the
Credit Card account (NOT the "General Ledger" because that gets confusing)
When you have the focus on the Credit Card account tab, choose Actions -->
Reconcile...


> I look at the doc and I have no clue what is going on.
>  https://gnucash.org/viewdoc.phtml?rev=3=C=help
>  https://gnucash.org/viewdoc.phtml?rev=3=C=guide
>
>
Even though you have spent some time on this, I recommend starting at least
at the beginning of the Credit Card chapter, and if it's still not
absolutely clear, go back to the beginning of the manual and make sure you
understand the examples. Maybe even create a couple of "Fake" accounts in
your data and enter the examples from the manual exactly as they are there.
If they're clearly labeled as fake you can easily delete them (and the
transactions in them) when you are through with them.

Good luck, and remember to respond to the list (as described below)


> -
> 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.

[GNC] Need help reconciling

[ToddAndMargo via gnucash-user]

Hi All,

I have been looking over the "Reconcile" on on eof m yu
credit card account.  I just don understand what I am seeing.

1) do I put a "c" in the opening balance as I
I has checked it?

2) I have put "C" in all the charges on my bank statement.

3) I press the Reconcile button and I put in the closing data.

It puts a weird entry into the the ledger that I don't understand
and puts it on one of those weird  "you goofed" accounts.  And
I get no "y"'s.

I look at the doc and I have no clue what is going on.
https://gnucash.org/viewdoc.phtml?rev=3=C=help
https://gnucash.org/viewdoc.phtml?rev=3=C=guide

:'(

-T

___
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] Need help with a Savings account

[Fred Bone]

On 17 April 2019 at 19:12, ToddAndMargo said:

> On 4/16/19 1:24 AM, Fred Bone wrote:
> >> So I should switch my opening balance to a negative number?
> 
> > Possibly. It rather depends on whether your account was overdrawn when
> > you started your current books.
> 
> My paper bank book and bank statement shows a positive number.
> 
> They way I am understanding this, they own me a debt, so I
> should enter it as a negative number for opening balance
> because they have a debt to me

Your choice. 

You should enter it as a negative amount if you insist on putting the 
amount in the "credit" column. Gnucash will then transfer the amount, as 
a positive number, to the "debit" column for you. 

Or you can enter it in the "debit" column, as a positive number.

___
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] Need help with a Savings account

[Adrien Monteleone]

David,

I agree, a reading of the Guide would have helped significantly.

Perhaps I should have refrained from personal assistance and commentary and 
simply pointed to the relevant sections. That is likely the better approach, 
especially since the ‘work’ in explaining is already done.

Regards,
Adrien

> On Apr 17, 2019, at 11:57 PM, David T.  wrote:
> 
> Adrien,
> 
> 
> The Guide covers in some detail both the concept of double entry and debits 
> and credits. In fact, some have suggested that the guide goes into too much 
> detail about these concepts. 
> 
> 
> It was the reason I suggested that the recent user consult the documentation, 
> since it explained everything he was asking. 
> 
> 
> David
> 

___
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] Need help with a Savings account

[Adrien Monteleone]

> On Apr 17, 2019, at 11:18 PM, AC  wrote:
> 
> On 2019-04-17 20:00, Adrien Monteleone wrote:
>> And I also agree that the GnuCash defaults of informal labels and Basic View 
>> are much simpler to comprehend.
>> 
>> However, once someone encounters a situation where they don’t understand 
>> ’transfer’ account or the nature of double-entry, problems arise.
>> 
>> They arise because by default, GnuCash is hiding the double-entry nature of 
>> the system from them. (something of a contra-selling point when comparing GC 
>> to proprietary systems that do the same thing, very strange it is the GC 
>> default)
> 
> How is it that using the "informal" labels (not the accounting labels)
> is hiding the double-entry process?  It's fairly formal in everyday use
> that people understand and flows from natural language pretty easily.  I
> "withdraw" money from my bank and use it to make a "payment" to my
> credit card.  I "charge" my card when I go buy gasoline which is an
> "expense". The double entry is there, it's not hidden at all.AC,

Use of informal labels isn’t the part that is hiding the double-entry aspect. 
Use of the Basic View (by default) is doing so.

Basic View only shows you one side of the transaction. (it assumes the other 
side, that is, the register you are in, mind you, I don’t think that assumption 
is unreasonable)

If you continue to use the informal labels, but show the actual splits, you’ll 
get the result in my previous reply - that is, splits with amounts in the 
charge column for a payment and splits with amounts in the payment column for 
charges. Technically, these splits are *not* either charges or payments, they 
are debits or credits.

‘Formal’ and ‘everyday use’ are not the same thing, certainly not in this case. 
(that should be self explanatory, but...)

Yes, you charge your card when you buy gasoline. Do you also make a payment on 
the card at the exact same time *as part of* that charge transaction in order 
for it to balance? No, you don’t.

But GnuCash makes it look like you do — a charge assigned to Liabilities:Credit 
Card and a balancing ‘payment’ assigned to Expenses:Gasoline - that is 
non-sensical, certainly to a newbie.

What you are really doing is crediting your Liabilities:Credit Card and 
debiting your Expenses:Gasoline accounts. THAT makes much more sense than what 
appears to be a ‘payment’ on the card assigned to Expenses:Gasoline. The same 
goes for making an actual payment on the card and seeing a ‘charge’ on the same 
card tied to your bank account.

Go ahead and click the ’split’ button or use Auto-Split Ledger, or Transaction 
Journal while still using the informal labels and you’ll see what I’m talking 
about. Can you honestly tell me it makes sense that each and every transaction 
on your credit card account has *both* payments and charges? Regardless of if 
that transaction was either a payment or charge? Please explain if you do.

The informal labels only have meaning in Basic View. Basic View hides the other 
split in every transaction. (sometimes, there are more than one) If you try to 
figure out what is going wrong when you mis-enter a transaction, GnuCash is not 
helpful, and quite confusing, with either it’s view or it’s labels. (as the 
defaults) And then, only the casual user who only involves one expense account 
per card swipe might avoid seeing the other splits. Buy groceries and bath 
towels at the same time from a big box retailer, see the splits with both 
charges and payments and hold the popcorn for the ensuing mind-mush.

> 
> All of my banks (three) don't even use formal labels for the statements.
> They all write "Deposits" and "Withdrawls" right at the top of the
> transaction logs.  The credit cards I have (six) all write "Charges" and
> "Payments" on the statements.

Your bank statements then, are not showing both entries, but only one side. 
Each of those line items has a debit and a credit in the bank’s books. (and you 
should have the opposite in your books)

Transactions are not single entry. (that is, *either* debit or credit, but 
always BOTH) The use of the Basic View leads one to believe they are, expanding 
the full view of the transaction shows they are not, and the informal labels in 
that context are simply not useful, if not detrimental, to understanding the 
transaction.

Mind you, I didn’t write any of this (or the previous reply) as a complaint, 
critique, or RFE. I’m just hashing out what I see as a problem. Maybe it is all 
in my head, or maybe it is real, but just not frequent enough to bother with...

I don’t have anything more I think I can add, unless someone isn’t 
understanding what I’m describing, in which case, I’ll endeavor take a 
different approach.


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 

Re: [GNC] Need help with a Savings account

[David T. via gnucash-user]

Adrien,

The Guide covers in some detail both the concept of double entry and debits and 
credits. In fact, some have suggested that the guide goes into too much detail 
about these concepts. 

It was the reason I suggested that the recent user consult the documentation, 
since it explained everything he was asking. 

David

 
 
  On Thu, Apr 18, 2019 at 8:32, Adrien 
Monteleone wrote:   Colin,

Recent threads showcase this exact scenario — a user didn’t understand 
what GnuCash was doing, (and perhaps to my lesser judgement) I recommended 
turning on BOTH Transaction Journal View and Formal Accounting Labels. 
Unfortunately, only the first was initially accomplished and many list 
exchanges and confusion ensued. Once both changes were made, things improved. 
(with, it seems, still room for better understanding)

Maybe I’m missing something from a long ago thread where this was discussed as 
a design decision. And admittedly, the case doesn’t come up often enough to 
warrant a change in the defaults.

But I do see room for improvement for comprehension, though I’m not sure what 
form it should take, if simply to continue to be addressed on a case-by-case 
basis when a user reaches that stage. Maybe this is something for the wiki?

Maybe there is a better way to explain what GnuCash is doing without resorting 
to an explanation of double-entry, debits/credits, without seeing the whole 
transaction, etc. I’m all for a simple path to the ‘right answer’ or at least 
the ‘most correct answer for right now’ even if it isn’t the ‘most complete 
answer’.

I guess I just don’t see how to explain what is going on, without explaining 
what is going on. (I’m not talking about backend details of the code of course, 
just the basic accounting principles being implemented)

Maybe “I” need to read the docs more often? Perhaps they are doing the job 
already and a simple, but polite version of RT(f)M (even for myself) would 
suffice?

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] Need help with a Savings account

[AC]

On 2019-04-17 20:00, Adrien Monteleone wrote:
> And I also agree that the GnuCash defaults of informal labels and Basic View 
> are much simpler to comprehend.
> 
> However, once someone encounters a situation where they don’t understand 
> ’transfer’ account or the nature of double-entry, problems arise.
> 
> They arise because by default, GnuCash is hiding the double-entry nature of 
> the system from them. (something of a contra-selling point when comparing GC 
> to proprietary systems that do the same thing, very strange it is the GC 
> default)

How is it that using the "informal" labels (not the accounting labels)
is hiding the double-entry process?  It's fairly formal in everyday use
that people understand and flows from natural language pretty easily.  I
"withdraw" money from my bank and use it to make a "payment" to my
credit card.  I "charge" my card when I go buy gasoline which is an
"expense". The double entry is there, it's not hidden at all.

All of my banks (three) don't even use formal labels for the statements.
 They all write "Deposits" and "Withdrawls" right at the top of the
transaction logs.  The credit cards I have (six) all write "Charges" and
"Payments" on the statements.



___
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] Need help with a Savings account

[Adrien Monteleone]

Colin,

I agree, most people are coming from a place of hearing those terms from the 
institution’s perspective, which confuses many at first.

And I also agree that the GnuCash defaults of informal labels and Basic View 
are much simpler to comprehend.

However, once someone encounters a situation where they don’t understand 
’transfer’ account or the nature of double-entry, problems arise.

They arise because by default, GnuCash is hiding the double-entry nature of the 
system from them. (something of a contra-selling point when comparing GC to 
proprietary systems that do the same thing, very strange it is the GC default)

So, perhaps I am mistaken here, but my usual approach is to advise people to 
delve into double-entry to understand it. Because once you understand it, the 
rest of GC and accounting make so much more sense. (personally, I find this a 
much stronger selling point for GC)

As part of this, I offer the suggestion to turn on either Auto-Split or 
Transaction Journal view so the user can see the entire transaction with 
nothing hidden. The problem with this suggestion is now, in the case of a 
credit card account, the user sees:

DateDescription Account Payment Charge
-   -   -   -   -   

4/1/19  Wal-Mart
Expenses:Clothes$100
Liabilities:Credit Card $100

Of course, this results in mind-mush and brain-explosions, because they didn’t 
make a payment on their card for Expenses:Clothes, they charged it. To them, 
this transaction hasn’t anything to do with payments on the card. (and try 
explaining why every payment on their card account involves a ‘charge’ as well!)

This is either a shortcoming, or bug in the informal label implementation.

So, heading off this confusion, I suggest to also turn on formal accounting 
labels so one always sees ‘debit/credit’ and then proceed to explain what these 
mean.

While the learning curve might seem steeper at first, I think the end result is 
better understanding and ability to use GnuCash.

If GnuCash auto-switched to formal labels when expanding a transaction to show 
splits, that might suffice, but it might also introduce confusion since the 
user would not be warned that column headers would change.

The use of ‘payment’ or ‘charge’ as a balancing column header where no payment 
or charge is involved is non-sensical in this context. (same applies to other 
informal label contexts)

Recent threads showcase this exact scenario — a user didn’t understand what 
GnuCash was doing, (and perhaps to my lesser judgement) I recommended turning 
on BOTH Transaction Journal View and Formal Accounting Labels. Unfortunately, 
only the first was initially accomplished and many list exchanges and confusion 
ensued. Once both changes were made, things improved. (with, it seems, still 
room for better understanding)

Maybe I’m missing something from a long ago thread where this was discussed as 
a design decision. And admittedly, the case doesn’t come up often enough to 
warrant a change in the defaults.

But I do see room for improvement for comprehension, though I’m not sure what 
form it should take, if simply to continue to be addressed on a case-by-case 
basis when a user reaches that stage. Maybe this is something for the wiki?

Maybe there is a better way to explain what GnuCash is doing without resorting 
to an explanation of double-entry, debits/credits, without seeing the whole 
transaction, etc. I’m all for a simple path to the ‘right answer’ or at least 
the ‘most correct answer for right now’ even if it isn’t the ‘most complete 
answer’.

I guess I just don’t see how to explain what is going on, without explaining 
what is going on. (I’m not talking about backend details of the code of course, 
just the basic accounting principles being implemented)

Maybe “I” need to read the docs more often? Perhaps they are doing the job 
already and a simple, but polite version of RT(f)M (even for myself) would 
suffice?

Regards,
Adrien


> On Apr 16, 2019, at 11:32 AM, Colin Law  wrote:
> 
> On Tue, 16 Apr 2019 at 01:14, John Clark via gnucash-user
>  wrote:
>> 
>> Because these terms ‘never make sense’, as seen by this example. It is far 
>> more simpler to just say, money coming in, on the left, money going out on 
>> the right… or is the other way around...
> 
> Money moves from right to left, that is one of the immutable laws of
> natrure (at least in the universe of Gnucash).
> 
> It may have been mentioned before but in Settings > Accounts there is
> a checkbox, Use formal accounting labels.  If you clear that then the
> headings on bank accounts say withdrawal and deposit, and on Credit
> card accounts say Charge and Payment, which I find much easier to cope
> with.
> 
> The reason we have so much trouble with the words debit and credit is
> 

Re: [GNC] Need help with a Savings account

[ToddAndMargo via gnucash-user]

On 4/16/19 9:32 AM, Colin Law wrote:

It may have been mentioned before but in Settings > Accounts there is
a checkbox, Use formal accounting labels.  If you clear that then the
headings on bank accounts say withdrawal and deposit, and on Credit
card accounts say Charge and Payment, which I find much easier to cope
with.


Thank you.  It now makes more sense

___
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] Need help with a Savings account

[Adrien Monteleone]

“Debt” and “Debit” are NOT the same thing, despite they are 1 letter apart.

If the balance of your bank account is positive (you have money to spend in it) 
then your opening balance entry in GnuCash should be a debit to that account 
and a credit to `Equity:Opening Balances`.

That isn’t because the bank ‘owes you’ anything, but rather, solely, because 
increasing an asset requires a ‘debit’ entry.

The side of the ledger you use to reflect an increase or decrease is entirely 
dependent on the *type* of account you are dealing with, which is determined by 
the side of the Accounting Equation it lies on.

Regards,
Adrien

> On Apr 17, 2019, at 9:12 PM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> On 4/16/19 1:24 AM, Fred Bone wrote:
>>> So I should switch my opening balance to a negative number?
> 
>> Possibly. It rather depends on whether your account was overdrawn when
>> you started your current books.
> 
> My paper bank book and bank statement shows a positive number.
> 
> They way I am understanding this, they own me a debt, so I
> should enter it as a negative number for opening balance
> because they have a debt to me


___
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] Need help with a Savings account

[ToddAndMargo via gnucash-user]

On 4/16/19 5:41 AM, Michael or Penny Novack wrote:

On 4/15/2019 6:11 PM, ToddAndMargo via gnucash-user wrote:

Hi All,

Now that I am feeling brave coming off of creating a charge
card account, I decided to create a saving account.

My bank statement shows deposits as positive numbers and
withdrawals as negative numbers, so I decided to follow suite

Okay, I set the initial test balance to +100.  It shows in
balance as 100.  All is well so far.

Then I put 10 in the debit column of the account, meaning I
withdrew 10 from the account. 


STOP  ask yourself, are you trying to keep books from the point of 
view of yourself of from the point of view of the bank?

What is a positive for the bank is a negative for you and vice versa.

Increases to the account FROM YOUR POINT OF VIEW are debits. Decreases 
are credits. That is because the type of account FROM YOUR POINT OF VIEW 
is an asset. From the bank's point of view, it is a liability (they owe 
you the money in your account) so this is reversed.


We cannot tell if you were right about that "all is well so far" unless 
you tell us whether that was a $100 debit balance of a $100 credit balance.


Michael D Novack


Wonderful description!  Thank you!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Need help with a Savings account

[ToddAndMargo via gnucash-user]

On 4/16/19 1:24 AM, Fred Bone wrote:

So I should switch my opening balance to a negative number?



Possibly. It rather depends on whether your account was overdrawn when
you started your current books.


My paper bank book and bank statement shows a positive number.

They way I am understanding this, they own me a debt, so I
should enter it as a negative number for opening balance
because they have a debt to me


___
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] Need help with a Savings account

[Colin Law]

On Tue, 16 Apr 2019 at 01:14, John Clark via gnucash-user
 wrote:
>
> Because these terms ‘never make sense’, as seen by this example. It is far 
> more simpler to just say, money coming in, on the left, money going out on 
> the right… or is the other way around...

Money moves from right to left, that is one of the immutable laws of
natrure (at least in the universe of Gnucash).

It may have been mentioned before but in Settings > Accounts there is
a checkbox, Use formal accounting labels.  If you clear that then the
headings on bank accounts say withdrawal and deposit, and on Credit
card accounts say Charge and Payment, which I find much easier to cope
with.

The reason we have so much trouble with the words debit and credit is
that we are used to seeing them on the bank statement and such like,
so we have got used to them apparently meaning the opposite of what
they really mean when looked at from our own point of view, rather
than the bank's.

Colin
___
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] Need help with a Savings account

[Michael or Penny Novack]

On 4/15/2019 6:11 PM, ToddAndMargo via gnucash-user wrote:

Hi All,

Now that I am feeling brave coming off of creating a charge
card account, I decided to create a saving account.

My bank statement shows deposits as positive numbers and
withdrawals as negative numbers, so I decided to follow suite

Okay, I set the initial test balance to +100.  It shows in
balance as 100.  All is well so far.

Then I put 10 in the debit column of the account, meaning I
withdrew 10 from the account. 


STOP  ask yourself, are you trying to keep books from the point of 
view of yourself of from the point of view of the bank?

What is a positive for the bank is a negative for you and vice versa.

Increases to the account FROM YOUR POINT OF VIEW are debits. Decreases 
are credits. That is because the type of account FROM YOUR POINT OF VIEW 
is an asset. From the bank's point of view, it is a liability (they owe 
you the money in your account) so this is reversed.


We cannot tell if you were right about that "all is well so far" unless 
you tell us whether that was a $100 debit balance of a $100 credit balance.


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] Need help with a Savings account

[Fred Bone]

On 15 April 2019 at 15:43, ToddAndMargo said:

[...]
> So, when I deposit something to the bank, I am actually
> losing money (giving it to someone else), so it is a debit?

No, you are handing it to them, so they owe it back. That's what "debit" 
means, after all.

> So I should switch my opening balance to a negative number?

Possibly. It rather depends on whether your account was overdrawn when 
you started your current books.

___
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] Need help with a Savings account

[Adrien Monteleone]

Sorry, too much copying and pasting and not enough proofreading. That second 
‘report’ should have read:


===
ToddAndMargo Balance Sheet (partial)
as of April 15, 2019

Assets
Cash$ 250
Savings $ 900
-
Total Assets$1150
===


for clarity as of the date of the report.

Regards,
Adrien


> On Apr 15, 2019, at 7:14 PM, Adrien Monteleone 
>  wrote:
> 
> ===
> ToddAndMargo Balance Sheet (partial)
> 
> Assets
>   Cash$ 250
>   Savings $ 900
>   -
> Total Assets  $1150
> ===


___
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] Need help with a Savings account

[Adrien Monteleone]

As Dale mentioned in another reply, money moves from credit to debit.

Do not think of the money as moving from you to the bank.

Think of the money as moving from one (or more) of your accounts to another one 
(or more) of your accounts.

Everything is done within and from the perspective of *your* books, not someone 
else’s. (sorry if my other reply confused you on that point)

When the *bank* says they are ‘crediting’ or ‘debiting’ your account, that is 
from *their* perspective in *their* books. From your perspective, in your 
books, you would enter that same transaction as a debit in that account. So 
when the bank says they are ‘crediting’ your account, thus increasing its 
value, that means their liability to you is increasing, because your account 
with them is not an asset account, it is a liability account. (opposite side of 
the accounting equation from their perspective) When they say they are 
‘debiting’ your account, thus decreasing its value, that means they owe you 
less, they’re decreasing their liability. But while the effect in your books is 
the same (increase or decrease) the side of the ledger you record it on is the 
opposite (debit or credit).


Let’s say yesterday, you started with $800 in your savings account and you had 
$350 on hand in cash...



===
ToddAndMargo Balance Sheet (partial)
as of April 14, 2019

Assets
Cash$ 350
Savings $ 800
-
Total Assets$1150
===



Now, today, you move $100 from Cash (credit) to Savings (debit)

DateMemoDebit   Credit
-   -   -   --
4/15/19 Assets:Savings  $100
Assets:Cash $100


When written Journal style it would look like this:

4/15/19
Dr. Assets:Savings  $100
Cr. Assets:Cash $100

I indented the amounts as well, but they might not always appear that way in 
textbooks and references. The distinguishing feature is the ‘Dr.’ and ‘Cr.’ 
prefixes to denote which is which.

(for some reason, convention has it to always show debits first, and usually to 
indent all credits, but you can enter them as credits first if you like, though 
GnuCash will likely re-order them to debits first upon saving.)



===
ToddAndMargo Balance Sheet (partial)

Assets
Cash$ 250
Savings $ 900
-
Total Assets$1150
===



As you can see, your total assets did not change. Your books remain in balance. 
Money did not appear or disappear, it moved from one area where you held it to 
another area where you held it. (it is still your asset) I didn’t need to show 
the Liabilities or Equities section of the Balance Sheet because they did not 
change and were not affected. (and we don’t even know or care about them for 
this example)

From your perspective, the increase in your savings account *came from* your 
cash on hand.

Now, let’s look at the Bank’s books for the exact same transaction:



===
'First Bank' Balance Sheet (partial)
as of April 14, 2019

Assets
Cash$ 800
-
Total Assets$ 800

Liabilities
   ToddAndMargo $ 800
-
Total Liabilities   $ 800
===



So ‘First Bank’ as of close of business yesterday, has $800 cash on hand, and 
they owe it all to ToddAndMargo. (sweet!)

This is how that *same* transaction above from your books, looks in theirs:

DateMemoDebit   Credit
-   -   -   --
4/15/19 Assets:Cash $100
Liabilities:ToddAndMargo$100


Or, Journal Style:

4/15/19
Dr. Assets:Cash $100
Cr. Liabilities:ToddAndMargo$100

As you can see, *your* savings account with them is a liability, and the 
entries for it are on the opposite side of the ledger from your books.



===
'First Bank' Balance Sheet (partial)
as of April 15, 2019

Assets
Cash$ 900
-
Total Assets$ 900

Liabilities
   ToddAndMargo $ 900
-
Total Liabilities   $ 900
===

Now, at the end of today, First Bank now has $900 on hand, and they still owe 
all of it to ToddAndMargo, while their assets increased, so did their 
liabilities. Their books still are in balance.

From their perspective, their increase in cash on hand, *came from* their 
liability (debt) to you.



---

On two other notes, thanks, but I’m not and never have been a teacher, though I 

Re: [GNC] Need help with a Savings account

[John Clark via gnucash-user]

> On Apr 15, 2019, at 4:10 PM, Adrien Monteleone 
>  wrote:
> 
> I wrote a longer reply, but let’s get this out of the way first:
> 
> What makes you think ‘losing money’ = ‘debit’?

Because these terms ‘never make sense’, as seen by this example. It is far more 
simpler to just say, money coming in, on the left, money going out on the 
right… or is the other way around...

I will of course note that I was kicked out of highschool accounting class for 
this and a few other reasons, namely I could give a rats ass about a few cents 
of difference between the right and left columns, whatever the convention.

In the case of the bank, when I put money into ‘my’ account that is an 
increase, and when the bank, at least in the olden days of savings accounts, 
put in interest, again an increase from my perspective, and hence a credit to 
that account for the bank’s ‘use’ of the money.

And if I dispatch dealing with banks, I sure don’t ‘owe’(debit) a cookie jar to 
store my cash, and when I take money out, it sure is no ‘credit’ to the cookie 
jar.


> 
> 
> Regards,
> Adrien
>> 
>> Hi Adrian,
>> 
>> So, when I deposit something to the bank, I am actually
>> losing money (giving it to someone else), so it is a debit?
>> 
>> So I should switch my opening balance to a negative number?
>> 
>> I think I might be going insane.  :'(
>> 
>> Thank you for all your patience with this!
>> 
>> -T
> 
> ___
> 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] Need help with a Savings account

[ToddAndMargo via gnucash-user]

On 4/15/19 4:10 PM, Adrien Monteleone wrote:

What makes you think ‘losing money’ = ‘debit'?


Hi Adrian,

By "losing money", I meant money moving away from me.
From me (debit) to the bank

By the way, I am a bit disturbed with myself that I actually
understood your reply.

By chance do you have a teaching background?  It is a skill
all in its own and you are very good at it.

And now a word from the funniest man to ever have walked the face
of this earth:


“He who asks is a fool for five minutes, but he who does
not ask remains a fool forever.”
   ― Mark Twain

Okay, maybe 10 minutes.

:-)

-T

 Of all the things I've lost, I miss my mind the most
 --Mark Twain


___
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] Need help with a Savings account

[Adrien Monteleone]

I wrote a longer reply, but let’s get this out of the way first:

What makes you think ‘losing money’ = ‘debit'?


Regards,
Adrien
> 
> Hi Adrian,
> 
> So, when I deposit something to the bank, I am actually
> losing money (giving it to someone else), so it is a debit?
> 
> So I should switch my opening balance to a negative number?
> 
> I think I might be going insane.  :'(
> 
> Thank you for all your patience with this!
> 
> -T

___
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] Need help with a Savings account

[ToddAndMargo via gnucash-user]

>> On Apr 15, 2019, at 5:11 PM, ToddAndMargo via gnucash-user 
 wrote:

>>
>> Hi All,
>>
>> Now that I am feeling brave coming off of creating a charge
>> card account, I decided to create a saving account.
>>
>> My bank statement shows deposits as positive numbers and
>> withdrawals as negative numbers, so I decided to follow suite
>>
>> Okay, I set the initial test balance to +100.  It shows in
>> balance as 100.  All is well so far.
>>
>> Then I put 10 in the debit column of the account, meaning I
>> withdrew 10 from the account.
>>
>> Problem: the balance went to 110, not to 90.  What did
>> I do wrong THIS time?
>>
>> Many thanks,
>> -T

On 4/15/19 3:17 PM, Adrien Monteleone wrote:

Another reminder - the Bank’s use of “debit/credit” with respect to your 
account is with respect to your account in *their* books which lies on the 
opposite of the ledger/accounting equation from *your* books.

So when they ‘debit your account’ to decrease it, that is because *to them* 
your account is a liability. (right side of the equation)

But in your books you would credit your account to decrease it, because it is 
on the left side of your equation. (an asset)

And notice, that when they debit, you credit - debits and credits still balance 
- even across books! (neat hunh?)

Regards,
Adrien



Hi Adrian,

So, when I deposit something to the bank, I am actually
losing money (giving it to someone else), so it is a debit?

So I should switch my opening balance to a negative number?

I think I might be going insane.  :'(

Thank you for all your patience with this!

-T


___
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] Need help with a Savings account

[Dale Alspach]

A simple rule for getting the debit and credit correct is

money flows from credit to debit.

So if you want to remove $10 from the savings account that will be a
credit of $10 to savings and debit of $10 to some other account(s) such
as Expense.

Dale

On 4/15/19 5:11 PM, ToddAndMargo via gnucash-user wrote:
> Hi All,
> 
> Now that I am feeling brave coming off of creating a charge
> card account, I decided to create a saving account.
> 
> My bank statement shows deposits as positive numbers and
> withdrawals as negative numbers, so I decided to follow suite
> 
> Okay, I set the initial test balance to +100.  It shows in
> balance as 100.  All is well so far.
> 
> Then I put 10 in the debit column of the account, meaning I
> withdrew 10 from the account.
> 
> Problem: the balance went to 110, not to 90.  What did
> I do wrong THIS time?
> 
> Many thanks,
> -T
> 
> ___
> 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] Need help with a Savings account

[Adrien Monteleone]

Another reminder - the Bank’s use of “debit/credit” with respect to your 
account is with respect to your account in *their* books which lies on the 
opposite of the ledger/accounting equation from *your* books.

So when they ‘debit your account’ to decrease it, that is because *to them* 
your account is a liability. (right side of the equation)

But in your books you would credit your account to decrease it, because it is 
on the left side of your equation. (an asset)

And notice, that when they debit, you credit - debits and credits still balance 
- even across books! (neat hunh?)

Regards,
Adrien

> On Apr 15, 2019, at 5:11 PM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> Hi All,
> 
> Now that I am feeling brave coming off of creating a charge
> card account, I decided to create a saving account.
> 
> My bank statement shows deposits as positive numbers and
> withdrawals as negative numbers, so I decided to follow suite
> 
> Okay, I set the initial test balance to +100.  It shows in
> balance as 100.  All is well so far.
> 
> Then I put 10 in the debit column of the account, meaning I
> withdrew 10 from the account.
> 
> Problem: the balance went to 110, not to 90.  What did
> I do wrong THIS time?
> 
> Many thanks,
> -T

___
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] Need help with a Savings account

[Adrien Monteleone]

No, debiting an asset account means you increased it. A withdrawal would be a 
credit to an asset account.

Remember:

Assets + Expenses = Liabilities + Equity + Income

Left side of “=“ means ‘debit increases/credit decreases’

The opposite for the right side of the “=“

Regards,
Adrien

> On Apr 15, 2019, at 5:11 PM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> Hi All,
> 
> Now that I am feeling brave coming off of creating a charge
> card account, I decided to create a saving account.
> 
> My bank statement shows deposits as positive numbers and
> withdrawals as negative numbers, so I decided to follow suite
> 
> Okay, I set the initial test balance to +100.  It shows in
> balance as 100.  All is well so far.
> 
> Then I put 10 in the debit column of the account, meaning I
> withdrew 10 from the account.
> 
> Problem: the balance went to 110, not to 90.  What did
> I do wrong THIS time?
> 
> Many thanks,
> -T


___
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.

[GNC] Need help with a Savings account

[ToddAndMargo via gnucash-user]

Hi All,

Now that I am feeling brave coming off of creating a charge
card account, I decided to create a saving account.

My bank statement shows deposits as positive numbers and
withdrawals as negative numbers, so I decided to follow suite

Okay, I set the initial test balance to +100.  It shows in
balance as 100.  All is well so far.

Then I put 10 in the debit column of the account, meaning I
withdrew 10 from the account.

Problem: the balance went to 110, not to 90.  What did
I do wrong THIS time?

Many thanks,
-T

___
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.

[GNC] Need help setting up OFX. Getting Signer not found on 2 different banking entities? Do I need a certificate?

[socaldood04]

Hi all,

I see this issue from GNUCash. The same accounts are downloading fine on
Quicken 2017.

Both fidelity and vanguard returned the same error.  It appears there's
something wrong in my setup. Is there a missing certificate I need to get?

AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user 
Sending request...
Connecting to server...
Resolving hostname "vesnc.vanguard.com" ...
IP address is "192.175.192.161"
Connecting to "vesnc.vanguard.com"
Connected to "vesnc.vanguard.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-128-CBC:SHA1
TLS: Warning - The server has chosen unsafe SSL-Ciphers!
Signer not found
Certificate is not trusted
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user xx
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues
___
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.