[GNC] I don't understand this IRA distribution solution
I am an ex-quicken user, with no formal accounting training (only gnucash manuals). I hope to track money between my banking accounts, identify who is receiving payments, and budget (income >= expense). I started by using the wizard for common + investment accounts. I didn’t see a problem until my investments generated an IRA distribution with money to federal, state, and checking. I didn’t want to record the federal, state deductions as an actual cash expense so I created an “Investment Expense” root expense account to track the payments. Now a new year has started and I’m trying to reuse my account tree but I can not identify why the budget income is not reporting the sum of the income sub-accounts. Thinking my IRA distribution solution was the root of the problem I found in gnucash-user “Accounting Treatment of Taxable IRA Distributions” thread. There is a statement of a solution which I do not understand, “How did you open your books? I bet your opening transaction had the balancing amount of that IRA lumped into equity. But you should instead had it as a "deferred income" under equity (a child). The equity total still correct, but now it becomes easy for you to "undefer" that income as you take a distribution. Understand? The distribution has TWO effects. One is to reduce the IRA balance as it increases money in your checking account. The second is to "undefer" that amount of income, reduce "deferred" and increase current income (your regular income account).” Would someone please explain this solution as accounts and transactions? Thanks, very much, Morris ___ 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] How to copy open budget to spreadsheet
Hello GNUCash, My version is 4.4. My budget is open. No export seems to be available for the budget. After highlighting several rows ctrl-c doesn't seem to copy the highlighted data to the clipboard. I'm trying to get the sum of expense sub-accounts to enter into the "Total Monthly Expense" parent account. I wouldn't expect everyone adds this manually, I must be missing something. I found a 2010 hit that recommended ctrl-c and the clipboard, didn't work for me. Thanks, Morris ___ 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] Unsuccessful aqBanking to TD AmeriTrade
Hello Everyone,
I am trying to migrate from Windows/Quicken (successful online access) to
Raspbian/GnuCash (failure). New GnuCash user here. I’m trying to get online
data from TD AmeriTrade.
Hardware: Raspberry Pi 4, 4GB. Software: GnuCash Ver 3.4 Build id 3.4+
(2018-12-30) Finance::Quote: 1.49, libaqbanking35-5.7.8-3 with plugins and
data, libaqofxconnect7-5.7.8-3
If someone has success with online access to TD AmeriTrade please reply
with User and Account settings or indicate what is wrong with my aqBanking
User or Account settings.
Below are my actions to create user and account, query Account list
(successfully?), Get Balance and Transactions (failure).
Define aqBanking User and Account.
File contents: .aqbanking/settings/users/uid%3a%3a000c.conf
int uniqueId="30"
char backendName="aqofxconnect"
char userName="John Doe"
char userId="5"
char customerId="5"
char country="us"
char bankCode="00"
int lastSessionId="0"
data {
backend {
char bankName="TD Ameritrade"
char brokerId="ameritrade.com"
char org="ameritrade.com"
char fid="5024"
char serverAddr="https%3A%2F%2Fofxs.ameritrade.com%2Fcgi-bin%2Fapps%2FOFX"
char appId="QWIN"
char appVer="2200"
char headerVer="102"
int httpVMajor="1"
int httpVMinor="1"
} #backend
} #data
File contents: .aqbanking/settings/accounts/uid%3a%3a0006.conf
char provider="aqofxconnect"
int uniqueId="32"
int accountType="7"
char accountNumber="5"
char bankCode="ameritrade.com"
char bankName="ameritrade.com"
char country="us"
int user="30"
data {
backend {
int maxPurposeLines="1"
int debitAllowed="0"
} #backend
} #data
Download account list output:
06:56:42 Sending request...
06:56:42 Using GnuTLS default ciphers.
06:56:42 TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
06:56:42 Waiting for response...
06:56:42 Parsing response...
06:56:42 Parsing response
06:56:42 Status for signon request: Success (Code 0, severity "INFO")
The server successfully processed the request.
06:56:42 Status for account info request: Success (Code 0, severity "INFO")
The server successfully processed the request.
06:56:42 Adding account 5 to bank ameritrade.com
06:56:42 Operation finished, you can now close this window.
Match Online accounts with GnuCash accounts.
Bank code ameritrade.com (ameritrade.com), Account 5()
Assets:Investments:JohnDoe Roth IRA xx5
Open the “JohnDoe Roth IRA xx5” account:
Actions>Online Action>Get Balance:
Log Messages:
AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user 5
Prompt for Password:
Log Messages:
Sending request...
Connecting to server...
Resolving hostname "ofxs.ameritrade.com" ...
IP address is "198.200.171.142"
Connecting to "ofxs.ameritrade.com"
Connected to "ofxs.ameritrade.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user 5
Postprocessing jobs
Job Get Balance: finished
Resetting provider queues
Actions>Online Action>Get Transactions:
Log Messages:
AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user 5
Prompt for Password:
Log Messages:
Sending request...
Connecting to server...
Resolving hostname "ofxs.ameritrade.com" ...
IP address is "198.200.171.142"
Connecting to "ofxs.ameritrade.com"
Connected to "ofxs.ameritrade.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user 5
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues
Pop-up message:
The Online Banking import returned no transaction for the selected time
period.
Thank you for your interest and assistance,
Morris
___
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 can't find tutorial & concepts guide
New user/installation on RaspberryPi. When I select Help/Tutorial and Concepts Guide, I get the message: "GnuCash could not find the files for the help documentation. This is likely because the 'gnucash-docs' package is not installed." dpkg --list | grep gnucash reports: ii gnucash 1:2.6.4-3 armhf personal and small-business financial-accounting software ii gnucash-common 1:2.6.4-3 all common files for the financial-accounting software Gnucash ii gnucash-docs 2.6.4-1 all Documentation for gnucash, a personal finance tracking program How to fix the help menu? Thanks, Morris ___ 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.
