Re: [GNC] Can a bank account have sub-accounts?

[Alton Brantley]

to answer your question— yes, a bank account can have subaccounts. 

I use a subaccount named “ACH” for  Automated Clearing House bank and 
investment accounts so that double entry accounts match up to statements on 
both credit cards and check ledgers to account for the delay going through the 
ACH. It just requires a second transaction to record the second half of the ACH 
activity. So e.g. an automatic payment on a Cc account is two entries:
1. Debit CC , Credit Bank:ACH
 Now the CC statement dates match
2. Debit Bank:ACH, Credit Bank
 Now the ACH balance is 0 and each statement matches up. 

The process is easy because I enter both transactions at the same time with the 
same date, and then correct dates on part 2 above at reconciliation. 


In order to see the bank account and subaccounts during bank statement 
reconciliation, just use the “include subaccounts” feature and the bank 
register will open with its name followed by a “+” so my “Bank of America” 
account opens as “Bank of America+”

--Alton Brantley

___
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] Equity account changed to Trading Account

[Alton Brantley via gnucash-user]

I recognize that I can use that mechanism ((Menu-.Transaction->Manage Document
Links and Transaction->Open Linked Document in V4.6). However, I use scheduled 
transactions and template transactions (model transactions with all the split 
accounts with amounts set to zero) so that all I do is fill in the values. That 
way, I never have to take my hands off the keyboard to enter data.

I double-checked, and the account marked as Trading is already a top-level 
account. If I try to move it under any other account, it shows the possible 
types of accounts as blank, so there’s nothing for me to select that enables me 
to move the account.

Also, I looked under File->Properties->Accounts and the “Use Trading accounts” 
checkbox is not marked.

 For the time being, I created a new “Assets” account and moved the current 
year’s transactions using the trading account split from the “Trading account” 
by editing the account in the splits of a search on the “trading” account name 
for the current year. Now I have all previous year’s transactions in the 
“trading” account, and the current year in an “assets” account, and I will 
enter future lines in the new account.

I am at a loss as to what made the account become identified as a “trading” 
account, as all my accounts are in USD.  I did discover that in one of my 
current year transactions, I had entered a non-zero value in the account that 
had switched from “asset” to “trading.” I wonder if that somehow triggered the 
software to convert the account.  I think I’ll take a look at the code around 
accounts and see what I can find.

Thanks for your suggestions.



> Date: Sun, 26 Sep 2021 08:11:01 +1000
> From: davidcousen...@gmail.com
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Equity account changed to Trading Account
> Message-ID: <21626e93bbfcba5046a6b18f15c6917b29fe6ad9.ca...@gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
> Alton
> 
>> From your description it would appear you are using the notes field to stor a
> link to an external file descriptor. GnuCash has had a facility to associate a
> URL for an external file to a transaction (Menu-.Transaction->Manage Document
> Links and Transaction->Open Linked Document in V4.6). This allows you to link 
> a
> file (PDF or image of e receipt for example) to a specific transaction and 
> open
> it from within GnuCash).  You can also set a path header in the preferences so
> all your linked files are stored in a single directory (can be a subdirectory 
> of
> a folder with your data files in it )
> 
> 
> Not sure if this will work on your retyped Equity account but may be worth a
> try. The range of the available account types displayed in the edit procedure 
> is
> set by the account type of the parent account in the edit account process 
> Can't
> guarantee it will work but worth a try. In the Edit Account process try 
> setting
> the Parent Account for the trading account to "New top level account" and then
> try changing the account type back to Equity and then reset the parent account
> to Equity. 
> 
> David Cousens
> 
> On Sat, 2021-09-25 at 17:17 -0400, Alton Brantley wrote:
>> I have an equity account which I use to record notes about purchases by
>> storing the file name as the note in the split and it always has a zero value
>> so it sorts to the middle of the splits. 
>> Sometime in the past couple months, this account became tagged as a ?Trading?
>> account even though it and all of the transaction splits are in USD. 
>> 
>> I tried to create a new tracking account, and to delete the Trading account 
>> by
>> moving the transactions over, but that wasn?t allowed. 
>> 
>> At this point, I cannot add transactions to the account and I don't want to
>> delete the transactions. 
>> 
>> I can create a new Equity account and change the account manually one by one.
>> This would be a slow process(10+years) or I could use the new account going
>> forward and just correct this year?s entries. This may have happened when I
>> upgraded to 4.6, as I only do this process quarterly. 
>> 
>> I have never used Trading accounts for any reason as I don?t use foreign
>> currency. 
>> 
>> Any ideas appreciated 
>> 
>> 
>> --Alton Brantley
>> 
>> ___
>> 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 o

[GNC] Equity account changed to Trading Account

[Alton Brantley]

I have an equity account which I use to record notes about purchases by storing 
the file name as the note in the split and it always has a zero value so it 
sorts to the middle of the splits. 
Sometime in the past couple months, this account became tagged as a “Trading” 
account even though it and all of the transaction splits are in USD. 

I tried to create a new tracking account, and to delete the Trading account by 
moving the transactions over, but that wasn’t allowed. 

At this point, I cannot add transactions to the account and I don't want to 
delete the transactions. 

I can create a new Equity account and change the account manually one by one. 
This would be a slow process(10+years) or I could use the new account going 
forward and just correct this year’s entries. This may have happened when I 
upgraded to 4.6, as I only do this process quarterly. 

I have never used Trading accounts for any reason as I don’t use foreign 
currency. 

Any ideas appreciated 


--Alton Brantley

___
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] Gnucash 4.1 on Mac Crashing on Exit

[Alton Brantley]

It seems that if I have a couple of unsaved transactions, and then go to exit 
Gnucash, I can get a crash. 
If I have one or two transactions I have edited but not saved, and I do 
Menu->File->Quit,
1. I get asked to save a transaction, so I click yes, then
2. I get asked to safe the file before closing, so I click yes, then
3. BEFORE I see a Save process, Gnucash crashes. The Crash file shows below.

(Here’s a link to the entire crash log. 
https://www.dropbox.com/s/6tn6rttbvyfw80o/GnuCash%20Crash%20File.txt?dl=0)

Process:   Gnucash [41511]
Path:  /Applications/Gnucash/Gnucash.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   4.1-1 (4.1-1)
Code Type: X86-64 (Native)
Parent Process:??? [1]
Responsible:   Gnucash [41511]
User ID:   503

Date/Time: 2020-08-25 18:02:15.024 -0400
OS Version:Mac OS X 10.15.6 (19G2021)
Report Version:12
Anonymous UUID:3E41EEE5-4F58-9EEC-F94F-3CDA86CFB356


Time Awake Since Boot: 40 seconds

System Integrity Protection: disabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   EXC_I386_GPFLT
Exception Note:EXC_CORPSE_NOTIFY

Termination Signal:Segmentation fault: 11
Termination Reason:Namespace SIGNAL, Code 0xb
Terminating Process:   exc handler [41511]

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   libgnc-gnome-utils.dylib0x00011038ddfe auto_save_countdown 
+ 46
1   libglib-2.0.0.dylib 0x00010e006394 g_timeout_dispatch + 
20
2   libglib-2.0.0.dylib 0x00010e00a32d 
g_main_context_dispatch + 349
3   libglib-2.0.0.dylib 0x00010e00a6a9 
g_main_context_iterate + 537
4   libglib-2.0.0.dylib 0x00010e00a9ea g_main_loop_run + 250
5   libgtk-3.0.dylib0x0001105f42da gtk_main + 74
6   libgnc-gnome-utils.dylib0x00011038488c 
gnc_ui_start_event_loop + 76
7   org.gnucash.Gnucash 0x00010dc23dbf 
scm_run_gnucash(void*, int, char**) + 1039
8   libguile-2.2.1.dylib0x00010de328c2 invoke_main_func + 34
9   libguile-2.2.1.dylib0x00010de1188f c_body + 15
10  libguile-2.2.1.dylib0x00010de9f90c vm_regular_engine + 
1532
11  libguile-2.2.1.dylib0x00010de9e463 scm_call_n + 739
12  libguile-2.2.1.dylib0x00010de9aef6 catch + 486
13  libguile-2.2.1.dylib0x00010de11859 
scm_c_with_continuation_barrier + 137
14  libguile-2.2.1.dylib0x00010de9aa6f with_guile + 63
15  libgc.1.dylib   0x00010df5d9cb 
GC_call_with_stack_base + 27
16  libguile-2.2.1.dylib0x00010de98a9b scm_with_guile + 43
17  libguile-2.2.1.dylib0x00010de32885 scm_boot_guile + 69
18  org.gnucash.Gnucash 0x00010dc23959 
Gnucash::Gnucash::start(int, char**) + 617
19  org.gnucash.Gnucash 0x00010dc2454e main + 990
20  libdyld.dylib   0x7fff70cc4cc9 start + 1
___
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] Disappearing entries

[Alton Brantley]

Are you, by chance, using the “Import transactions from CSV” capability to 
update your accounts?

If so, you should be aware that sometimes the transaction matched is one that 
has already been reconciled, so it appears that the transaction has been added 
when, in fact, it has updated a previously reconciled transaction, replaced it 
as a “cleared” transaction, and then rereconciles it, leaving the account 
showing a missing transaction.

___
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] looking for quicken alternative

[Alton Brantley]

I was in the same boat, and made the conversion, and would never go back.

There are a few steps to take to accomplish the migration, and to understand 
the conceptual differences between the two programs.
However, it’s worth it once you get the process working for you.

If you have any questions, you can always contact this list or look up past 
responses to similar questions in the archives.

> Date: Fri, 27 Mar 2020 05:20:43 + (UTC)
> From: Ken Cohen mailto:kcoh...@yahoo.com>>
> To: "gnucash-user@gnucash.org " 
> mailto:gnucash-user@gnucash.org>>
> Subject: [GNC] looking for quicken alternative
> Message-ID: <57147887.1864901.1585286443...@mail.yahoo.com 
> >
> Content-Type: text/plain; charset=UTF-8
> 
> I have used Quicken for well over 15 years but continue to have problems with 
> the software. I am looking for a replacement that can download transactions 
> from my bank and Schwab brokerage and maintain detail security information 
> including lots purchased and cost basis. Is gnucash a program that can 
> accommodate that?thanks,Ken
___
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] Find or search all expenses in a certain account

[Alton Brantley]

In situations like this, I have usually just moved the 10 or so transactions 
from the current account(“AccountX”) to a new account (say AccountXNew), then 
delete AccountX, then rename AccountXNew to AccountX.
___
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] Apple Card csv

[Alton Brantley]

I successfully download the Applecard CSV through the iPhone, transfer it over 
to my mac with AirDrop, and import it into my account on Mac Catalina with 
Gnucash 3.8.

Getting CSV import set up can take a bit of fiddling, but once you get it all 
configured so it goes through, and you save the configuration, it’s virtually 
painless.

Fiddling involves setting starting lines to skip, character set, selecting the 
correct columns (remember that positive amounts are withdrawals, so your 
payment will show as a negative, and selecting the appropriate account for them 
to be loaded.

BE AWARE, transaction matching can really mess up, so I recommend not using it. 
It would be great if it only sought to match from the last closing date to the 
present…. Also, It would be nice if the accounts pull-down menu matched the 
order of accounts in your file, but they appear to be in balance sheet order 
(assets, liabilitys, income, an expense), so you may have to look through the 
whole list to find your account.

Finally, the process is, for a reason unknown to me, terribly slow, so it seems 
like nothing is happening, even for a very small import. For a very active 
account, it can seem like the program has hung. Go get a cup of coffee or take 
a bathroom break!

-Alton Brantley


> Date: Mon, 3 Feb 2020 11:44:01 -0500
> From: Keith Bellairs mailto:ke...@bellairs.org>>
> To: gnucash-user email group  <mailto:gnucash-user@gnucash.org>>
> Subject: [GNC] Apple Card csv
> Message-ID:
><mailto:CAALV8s==p+qtdfhsj+j2_9mukhjqfw4ilgm8bua_r5ysiip...@mail.gmail.com>>
> Content-Type: text/plain; charset="UTF-8"
> I have been using GNC for a long, long time. So I have an account for each
> of my credit cards. I can update the accounts with ofx/qfx downloads. I see
> that Apple only allows csv downloads from that card. I have never used the
> csv upload to GNC. Does anyone have experience with Apple's csv files? If
> they don't upload cleanly that's a deal breaker for me.
> Keith
___
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] Getting slow response and logged faults in 2.6.21 to 3.7-1 conversion

[Alton Brantley]

On Mac OS X 10.14.6, I’ve moved from Gnucash 2.6.21 to 3.7. All the data look 
fine, BUT

I get lots of beachballs as I move from one screen to the next, or even scroll 
within a register. Looking at the logs,
I get lots of Gnucash process messages along the lines of 
"found no value for key NSPersistentUIShowQuietSafeQuitStatus in 
CFPrefsSearchListSource<0x630bed80> 
  (Domain: org.gnucash.Gnucash, Container: (null))”

So it seems that the program is not finding something it expects and is 
spending a lot of time in error or fault management. Any suggestions about
how to give the program what it needs for the keys for which it’s finding no 
values?


___
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] Scheduled transactions: Why create in advance?

[Alton Brantley]

One option you could use is the ability to create the future transactions in a 
subaccount of the relevant account. Simply use the “include subaccounts” when 
you want to look at future balances, and don’t include that account when you 
want only the current figures.

On the date that the future transactions take effect, edit the account to move 
it from the subaccount to the parent account.

I do this with my bank account as follows:

Account: Bank
Subaccount: Bank:Income due
Subaccount:Bank:Payments due

I create future deposits in the Bank:Income due account and future payments 
(mortgage, utilities, etc) in the Bank:Payments due account.

When I want the actual Bank account updated, I just open each subaccount, edit 
off the “:Income due” or “Payments due”, and the transaction is moved to the 
parent account.

-Alton Brantley



> Date: Wed, 10 Jul 2019 15:20:33 -0500 (CDT)
> From: AEG mailto:aeg21212-fo...@yahoo.com>>
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> Subject: Re: [GNC] Scheduled transactions: Why create in advance?
> Message-ID: <1562790033481-0.p...@n4.nabble.com 
> <mailto:1562790033481-0.p...@n4.nabble.com>>
> Content-Type: text/plain; charset=UTF-8
> Adrien,
> Thanks for your input.
> I don't really want to see the created transactions together. I want to see
> (in advance) the effect scheduled transactions will have on individual
> account balances when they are created but to delay creation until the
> correct scheduled date. I am sure others would find this extremely useful if
> the feature existed.
> Alan
> 
___
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 better documentation - and maybe more robust functionality - on using Lots

[Alton Brantley]

If you’re a day-trader, I can sympathize, put you would probably find the same 
issues with other personal accounting programs.

I use Gnucash to manage 7 different investment portfolios, including trading 
options, and I track commission fees, reconcile the lots, adjust for partial 
lot sales,  and  reconcile to the penny with my brokerage statement every month.

When opening a transaction for stocks, enter the shares and stock price; for 
options, enter contractsx100 and option price.
Create a subaccount for commissions under each brokerage account. I consider it 
a prepaid expense (to be realized when I close the transaction. I call it 
“Commissions-open.”

When closing a transaction, do the same.

On opening a lot, Go to Action->View Lots, Use “New Lot” button to create new 
lot, and move the open transaction into it with the double arrows, and “Close” 
button.
On closing, select the appropriate lot, and do the same.

You’ll get a “Realized Gain/Loss” transaction in your stock account. That will 
be the “gross gain/loss” based on shares/contracts and prices.
You need to add a split to subtract the “Commissions-open” charges from the 
realized gain/loss to get your net realized gain/loss. (Note: easy check—rename 
splits for “Commissions-open” in the transactions to “Commissions-closed”. 
Commissions-closed should ALWAYS total 0. Commission-open should always hold 
unclosed positions.”

Once I close out an active security, I move it to a subaccount 
(Positions-Closed placeholder) under brokerage account.

For partial position closings, apportion the initial commission by replacing 
the commission split with two apportioned splits.



> I luv GnuCash, but not for investments, certainly not for stock trading. Lot
> selection, forget about it... clearly none of that was a priority for the
> developers and I have zero expectation that will change. Use another program
> for recording and maintaining bookkeeping for those investments.
___
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] Options Trading

[Alton Brantley via gnucash-user]

As you know, options are quoted in “contracts” of 100 shares (a lot), but the 
prices are quoted on a “per share” amount, I simply multiple the number of 
contracts by 100 for the quantity of shares value and the quote for the price.

So, on an opening transaction of a “Buy to Open”, you credit the total price, 
and debit the commission  to a subaccount named “Open Commissions”  and debit 
the quantity and price (=cost) to the option account.
On the closing transaction (“Sell  to Close”), you debit the commission and 
credit the option account. 
Then, do an Action->View Lots in the option account and match up the options, 
which will give you a “Realized Gain/Loss” in the option account. The realized 
gain/loss transaction is edited to add credit splits for the opening and 
closing commissions to give you your next transaction gain/loss(to match your 
brokerage statement).

On a short transaction (Sell to Open), the credit and debits are reversed for 
the cash account and the option account, but the commissions are still debited 
on the open and close, and credited on the Realized gain/loss reconciliation.

Hope this helps.

> Date: Mon, 10 Jun 2019 21:27:55 -0500
> From: Les mailto:lellio...@gmail.com>>
> To: Gnucash Users mailto:gnucash-user@gnucash.org>>
> Subject: [GNC] Options Trading
> Message-ID:  >
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> Hi All:
> I can't seem to find any instructions on how to handle options. If 
> anyone is using options how are you using GC for tracking?
> I am using Linux Mint 19.0 and GC 2.6.19.
> Thanks,
> Les
___
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] QFX vs OXR/QXF

[Alton Brantley]

You should be aware that the OFX import will use the posting date only as its 
import date. Your statements will list the transaction date, so your statements 
and your ledger will not match directly.

For that reason, I have gone back to using CSV import format, because the CSV 
import tool allows the option of choosing which date is used for the entry into 
your ledger.

Note to developers: it would be wonderful to add a flag to either the ledger 
account or the OFX import tool that would allow the specification of which date 
to use.

Second note to developers: it would also be wonderful if the settings used in 
the import tool (specifically the CSV tool) were sticky, i.e. the previously 
used settings were retained between uses. I have 3 separate cards with one 
bank, and have to select “skip the first line, m-d-y format, and tag the 
columns Date, Description, Debit, Credit” every time I do an import. As a 
benefit to those who don’t want that feature, either a “reset” button or a 
“non-sticky” flag on the account could be added. Maybe even save the options as 
account specific!


___
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] how to track Futures and Options

[Alton Brantley]

I carry options as a stock. Just multiply the contracts by 100 to show shares 
under options.
Regarding commissions, I have a subaccount under the brokerage account labeled 
“Open Commissions”.
When I execute an opening transaction, then the commission is debited to “Open 
Commissions”. I think of this as a prepaid expense.
When I execute a closing transaction, the commission is debited to “Open 
Commissions” also. And here’s the trick.
When I use the lots function to match the two parts of the transaction, I get a 
realized gain that is then adjusted by
 crediting the two “Open Commissions”.
(I actually do one additional step, which is to change the above “Open 
Commissions” to “Closed Commissions-CYxx” where xx is the year of the realized 
gain/loss.  By doing this, I have an automatic check that I have accounted for 
commissions correctly, as the balance of Closed Commissions should always be 0.)

So my accounts look like this:
Brokerage: AAPL 01/15/2021 230.00 C

Transactions: 
Opening (Sell Call to Open) 
09/19/2018 SCO  AAPL 01/15/2021 230.00 C
   -1200.
Brokerage:Cash38,379.55
Brokerage:Open Commissions 8.45
Brokerage:AAPL 01/15/2021 230.00 C -1200.  31.99
 38,388.00

Closing (Buy Call to Close)
11/09/2018 BCC  AAPL 01/15/2021 230.00 C
   0.
Brokerage:AAPL 01/15/2021 230.00 C  1200.  25.58  30,696.00
Brokerage: Open Commissions   12.90
Brokerage:Cash  
  30,78.90

After matching up lots
11/09/2018  Realized Gain AAPL 01/15/2021 230.00 C
Brokerage:AAPL 01/15/2021 230.00 C 7,692.00 
Brokerage:ShtTermCapGain
  7,670.65
Brokerage:Open Commissions  
  8.45
Brokerage:Open Commissions  
 12.90

I then go back to each of the above transactions and change the
“Brokerage:Open Commissions” to “Brokerage:Closed Commissions-CY18”
This way, the “Open Commissions” account holds only unclosed transactions, and 
all “Closed Commissions-CYxx” are 0.

(For best results, copy this message into a text file and view with a fixed 
size font so columns match up.)




  
___
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] how do I get different dates for balancing transactions when transferring amounts between two accounts

[Alton Brantley]

Under each account for which this can occur, I create a subaccount called “ACH” 
for “Automated Clearing House,” so when the originating account registers the 
transfer transaction, the target account’s subaccount “ACH” gets the 
corresponding split. Then, when the receiving account registers the 
transaction, I put the matching inverse split in the ACH and the closing 
deposit in its parent account.

This sequence matches what really happens (Source ->ACH then ACH->Target), with 
the added benefit that the Target account, when opened with “Include 
Subaccounts” checked, shows the true expected value of the deposit.

I have an ACH account as a subaccount of both my bank account and my investment 
accounts.





> Message: 13
> Date: Mon, 14 May 2018 19:35:30 -0700
> From: Kate Kelly mailto:kken...@gmail.com>>
> To: rlagg...@mail.com 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] how do I get different dates for balancing
>   transactions when transferring amounts between two accounts
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> Hi Rufus,
> 
> I am a bookkeeper and former CPA.
> 
> An account that is often used for checks not yet sent to the bank is
> "undeposited funds." This is similar to a suspense account in that there is
> a timing difference between the receipt of a check and the time you
> actually deposit it.  You could debit the undeposited funds account for the
> amount of the payment. When the check clears the receiving bank, credit
> Undeposited Funds and debit your Checking account.  You could add the check
> number to the memo line or record the deposit as DEP ( being the
> check number.
> 
> 1.  Write check # 1718 for $100:
>   Undeposited Funds  $100
>   Checking Account A $100
> 
> 2. Check clears the receiving bank:
>   Checking Account B $100
>   Undeposited Funds.  $100
> 
> I hope this helps.
> 
> Kate
> 
> 
> On Mon, May 14, 2018, 3:21 PM RL  > wrote:
> 
>> I have two bank accounts on which I regularly write checks to transfer
>> amounts between them. Downloading the ofx files from each bank, I have,
>> for those checks, transactions with different (correct) dates in each GC
>> account which represent the left and right side of the same accounting
>> transaction. For purposes of reconciling against the bank statements,
>> these dates must remain different in their separate GC accounts, even
>> though they are opposite ends of the same accounting transaction.
>> 
>> GC wants to make the balancing transactions in each GC account one
>> single identical transaction (except for the proper credit/debit column,
>> depending on which account I'm looking at). I don't see how to work this
>> and maintain both accounts true to their source, the bank transactions.
>> The date is also important because at times it matters when a check was
>> cashed and when it was payed by the originating bank; there needs to be
>> an accurate record of this. An additional, maybe lesser, problem is that
>> GC's methodology makes the transaction number the same in each GC
>> account. Since the trans number is one of the most easily noted text
>> fields, I have been using it to quickly/easily identify "deposits" - but
>> this won't work if I want to retain the check number in that field (very
>> important). Also, a check number on a deposit line doesn't seem
>> particularly proper.
>> 
>> How is this handled in GC?
>> 
>> 
>> Thanks
>> Rufus
>> ___
___
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] Handling Return of Capital in Reinvested dividends

[Alton Brantley]

I am trying to deal with Return of Capital events happening over a series of 
dates, therefore a series of lots. 
For whatever reason, I am not able to adjust individual lot amounts.

Example:
Tx 0:January 1,2017
$1000 DR Stock:XYZ Corp 100 sh @ $10/shr 
$1000 CR Cash
 And in ACTION->View Lots make this Lot 0
 
Tx 1: March 1,2017
$10 DR Cash 
 Dividend for Reinvestment
$10 CR Income:Dividend:XYZ Corp

$10 DR Stock:XYZ Corp 1 sh@ $10/shr
$10 CR Cash
 And in ACTION->View Lots make this Lot 1

Next 3 transactions identical to Tx 1
Tx 2: June 1,2017  (Lot 2)
Tx 3: Sep 1,2017   (Lot 3)
Tx 4: Dec 1,2017   (Lot 4)

Now, I have 104 shares of XYZ purchased over 12 months at $10/shr ($1040) in 5 
Lots.

Then, in Jan 2018, my brokerage statement shows that $20 of the $40 Dividend 
was Return of Capital.
I then enter the transaction

Tx 5: Jan 31, 2018
$20 DR Income:Dividend:XYZ Corp
$20 CR Return of Capital:XYZ Corp

So my total investment in XYZ Corp is now $1020 in 5 lots (100,1,1,1,1) 
and my $20 gets allocated pro rata (100/104*$20, 1/104*$20, etc) or ($19.23, 
0.19,0.19,0.19,0.20).
The last amount is adjusted up a penny because of small fractions to add up to 
$20.
(In real life, the share price varied each quarter so fractional shares were 
purchased).

The problem happens in the lots mechanism. I now want to enter the following 
Transaction:

Tx 6: 
$20   DR Return of Capital:XYZ Corp
$19.23 CR Stock:XYZ Corp  Memo:this is ROC for Lot 0
$ 00.19 CR Stock:XYZ Corp  Memo:this is ROC for Lot 1
$ 00.19 CR …
$ 00.19 CR …
$ 00.20 CR …

When I open ACTION->View Lots, none of the CREDIT splits show up for me to put 
into their appropriate lots.

I don’t want to do a buy/sell of each lot, because I lose date tracking.

It would be nice if the Lots would show all Tx splits for Stock:XYZ Corp, even 
the ones with 0 shares at 0 cost per share.
It appears my only option is to hold the ROC CR transactions until I sell XYZ 
Corp, and then incorporate them into
the capital gain/loss reconciliation.

Any other suggestions?


___
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: What's the best way to model "in-flight" transactions?

[Alton Brantley]

The way I handle this is to create a subaccount of my bank accounts labeled 
“Bank1:ACH” for automated clearing house.
Then the transactions look like this (where Db means debit, Cr means credit, 
and assuming credit card is paid $1000.00)
Bank1 is an account of type bank (an asset),
ACH is a subaccount of Bank1 of type cash (also an asset)
CreditCard1 is an account of type credit card (a liability)

When the credit card bill is paid:
CreditCard1 Db 1000.00
Bank1:ACH  Cr 1000.00
  This transaction reduces the liability (by increasing the credit available) 
and reduces the cash available in the ACH account(creating a negative balace). 
If I look at the Accounts tab, I can see at a glance what my bank account is 
according to the bank, and the pending deductions from that amount.

When the payment clears the bank:

Bank1:ACH Db 1000.00
Bank1 Cr 1000.00 
  This transaction reduces the money in the “float” of the ACH (by increasing 
the negative balance there), and reduces the cash in the Bank1 account, showing 
that the bank paid through the ACH.

It seems complicated (at first), so play with it in a dummy set of books. 
You’ll get the feel of it pretty quick. 
This is the only way I have found of being able to reconcile easily both the 
credit card statement and the bank statement without editing dates that make 
one or the other not map correctly.



> Date: Thu, 28 Sep 2017 05:39:09 -0700 (MST)
> From: replicon mailto:repli...@gmail.com>>
> To: gnucash-user@gnucash.org 
> Subject: What's the best way to model "in-flight" transactions?
> Message-ID: <1506602349864-0.p...@n4.nabble.com 
> >
> Content-Type: text/plain; charset=us-ascii
> 
> Hey all,
> 
> I've been using/loving GNUCash for almost a year now, and one thing I'm sure
> I'm doing wrong is how I'm showing credit card payments.
> 
> For paying credit card bills, I just use my bank's bill pay. The bank is
> different from the credit card provider, so there's some "in-flight" time
> for that money. The day the withdrawal shows up on my checking account is
> not the same as the day the payment shows up when I login to my credit card
> provider and check transactions there.
> 
> Right now, in GNUCash, I just do a transaction from checking account to
> credit card, and by convention, always adjust the time to reflect checking
> account, but I wonder if there's a more correct way to do it.
> 
> The best I can think of is to have a separate account for "in-flight"
> transactions between establishments, and turn the credit card payment into
> two transactions that go through this account. Is that the best way to do
> it? If so, what account type would that be? Would it be an asset, because in
> a way, it's like I'm loaning money to some imaginary entity for a while,
> which it will repay to my other account a day or two later? :)
> 
> Thanks!
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Printing reports without spliting text across pages

[Alton Brantley]

I run Gnucash on a Mac, but under VirtualBox with Ubuntu. That way, my data is 
stashed on a virtual disk for security and it’s a cleaner environment.

> On Aug 9, 2017, at 7:46 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Wed, 9 Aug 2017 07:37:53 -0700 (PDT)
> From: Jeffrey Black  >
> To: gnucash-user@gnucash.org 
> Subject: Re: Printing reports without spliting text across pages
> Message-ID: <1502289473484-4693158.p...@n4.nabble.com 
> >
> Content-Type: text/plain; charset=us-ascii
> 
> 
> On 9 August 2017 at 11:31, Geert Janssens  wrote:
>> On woensdag 9 augustus 2017 02:47:52 CEST Jeffrey Black wrote:
>>> The last post I can find on this is from 2013, and there were no
>>> satisfactory answers then.
>>> 
>>> Does anyone know how or of a utility that will allow me to print reports
>>> without the text splitting in half across page breaks?  PDF does not work
>>> and besides I can not import it into my documents.  HTML export to a
>>> browser
>>> is not really an option as I need to add these reports to documents in
>>> Open
>>> Office.
>>> 
>> The good news is that in gnucash 2.8 this will no longer be an issue. The
>> more
>> recent webkit2 being used does properly handle page breaks.
>> 
>> The bad news is our Windows version of gnucash 2.8 will stick with webkit1
>> as
>> webkit2 is not available there. So unfortunately on Windows the page
>> breaks
>> will continue to be borked. For now there is no solution to this.
> 
> Other than the obvious one to not use Windows.
> That may sound like a flippant comment, but actually it is not
> difficult to move to something like Ubuntu unless you absolutely need
> an application that is only available on Windows. I did it some years
> ago and have never regretted it. It is great to feel that one is back
> in control of one's PC again.
> 
> Colin
> ___
> 
> As you and Geert pointed out moving to a Unix based system would be the
> smart thing to do, for many reasons.  Unfortunately I am still stuck with
> some legacy WidoZe apps for which there are no replacements, yet.  Once I
> can find suitable replacements for them I will happily remove the only
> legally available computer virus in the world from my computer and go
> strictly with a UNIX box.  
> 
> You have no idea how happy I was when I discovered GnuCash and it's very
> unrelated distant cousin GnuCash for Android.
> 
> Since I do not want to take a chance on wiping my windows boot drive just
> yet I think I will take your suggestions and try running a copy of Ubuntu in
> a VMware box and printing reports from there.  Simple enough to get access
> to a copy of my data files.
> 
> Thanks for the idea.
> 
> --JEffrey Black M.B.A.
> 
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Getting OFX import to use DTUSER vs DTPOSTED

[Alton Brantley]

After much trial and tribulation (and hours upon hours of transaction editing 
while importing OFX files), I have discovered the secret to getting OFX import 
to use DTUSER instead of DTPOSTED. First, a little background:
When I get my credit card statements, they have the date that the transaction 
occurred at the transaction site, so a Friday night restaurant charge will show 
up on a Friday date. However, when I download either a QIF file or an OFX file 
and then import the data, it is almost always a few days off on the 
transactions. Researching OFX, there are actually two different dates to 
consider:
DTUSER is the date the transaction occurred( which matches the printed 
statement) and
DTPOSTED is the date the bank processed the transaction (which doesn’t!).

Inspecting the OFX files, I find both XML tags present. 
There appears to be no way to tell QFX/OFX import which date to use, and 
apparently if DTPOSTED is present, it supercedes DTUSER.

Here’s the simple solution:

Edit the OFX file and do a replacement of the text “DTPOSTED" with “IGNORE”. 
The rule for XML is that if a TAG is unrecognized, it is ignored.
That leaves all the dates with DTUSER as the only valid date indication for 
each transaction, and that’s what get used

I would love to have an option, by account, which would allow me to specify 
which date entry takes precedence!

-Alton Brantley

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.