Re: [GNC] Setting up existing investments in new GnuCash file

[ornd25]

As far as moving accounts into a nested position later, I think you can use
the "Edit Account" functionality to change the Parent Account setting. Found
this out after carelessly creating an account in the wrong place. You don't
need to delete anything. The program automatically updates all the
transactions that reference the moved account. 
...

-
Ken Farley

Ken,

The "Delete Account" function is a way of combining two accounts into a single 
one. You can certainly use "Edit Accounts" if you want to move an single 
account to another parent. However, if you're updating that account from an 
experimental one (or deciding you don't need multiple accounts), then you'll 
have to use the "Delete Account" function, and the wizard will ask what you 
want to do with the transactions currently in the to-be-deleted account. 
___
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] Setting up existing investments in new GnuCash file

[ornd25]

Nov 9, 2019, 18:39 by no1clash...@mailbox.org:
Thanks for the suggestions. It sounds from your description as though you 
entered a bunch of historical information for your investment accounts. Is this 
correct? To be clear, I have no intention of doing that. I am not bringing any 
history over from Quicken, for any account. I intend to use recent balances on 
each account as an opening balance in GnucCash, and then use QFX downloads to 
maintain them from that point. This applies to my investment account as well. 
It is an IRA, so I don´t need to identify lots, I have no splits, etc., I 
intend to start with positions as of X date, and import from that point on. If 
this is a bad approach, please let me know. But spending the time to bring over 
3.5 years of history, since the establishment of the IRA, is a non-starter for 
me. 

~dean~
On November 9, 2019 at 8:33 AM orn...@tutanota.com wrote:


"Thanks for your reply. I get the impression that even if I get the import 
process sorted out, that this will be a tedious process and probably no easier 
in the long run that just entering all the data manually. You state the 
importer is ahead of the documentation, but my evaluation was based on actually 
trying the importer more than going following the documentation. None of them 
seemed suitable without a lot of work, and manual entry is a lot of work. I 
believe I'll do the latter. 

Regards, 
~dean~"I went through much the same process in August and was unable to use the 
importer for investments 
effectively - I ended up doing much of it manually, also.

I have some techniques suggestions that might be useful for manual entry.
"Save as" your work product as something like "GnuCash_Experimental" in a 
directory different from your main one in case of non-recoverable errors.
Do one account at a time 
Have your working account at the top level, e.g., ABCDE Mutual Fund, rather 
than "Assets:Investments:Taxable:Joint:Mutual Funds; this makes the splits 
easier to assign. Moving a whole account to its nested position later is easy 
using the (hair-raising) "Delete Account" technique, which I practiced a few 
times before invoking it with real data.
Do only six months or a year's worth of your most recent data at a time. This 
gives you current information immediately, allowing you to fill in older data 
as you have time.
Use common Description terms, such as "Dividend Reinvestment" when possible - 
this allows you to  to create the same split as previously, saving much 
Debit/Credit assignment clicks.
If you aren't bringing in significant history, then migration will be much 
simpler. GnuCash is my fifth financial manager program, and in each case before 
GnuCash I abandoned the all previous data and stated afresh, primarily due to 
my perception of the probable difficulty. 

I regretted those choices and this time I captured most of the old data for two 
earlier programs back through 2009. I made the effort because understanding 
just what I'd been doing was/is important for me to understand what I'm doing 
today using GnuCash's invaluable report system. Also importantly, migrating the 
old data helped me better understand double entry accounting better. Since this 
doesn't apply to you, your migration will be much simpler. I wish you good luck.
___
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] Setting up existing investments in new GnuCash file

[ornd25]

"Thanks for your reply. I get the impression that even if I get the import 
process sorted out, that this will be a tedious process and probably no easier 
in the long run that just entering all the data manually. You state the 
importer is ahead of the documentation, but my evaluation was based on actually 
trying the importer more than going following the documentation. None of them 
seemed suitable without a lot of work, and manual entry is a lot of work. I 
believe I'll do the latter. 

Regards, 
~dean~"I went through much the same process in August and was unable to use the 
importer for investments 
effectively - I ended up doing much of it manually, also.

I have some techniques suggestions that might be useful for manual entry.
"Save as" your work product as something like "GnuCash_Experimental" in a 
directory different from your main one in case of non-recoverable errors.
Do one account at a time 
Have your working account at the top level, e.g., ABCDE Mutual Fund, rather 
than "Assets:Investments:Taxable:Joint:Mutual Funds; this makes the splits 
easier to assign. Moving a whole account to its nested position later is easy 
using the (hair-raising) "Delete Account" technique, which I practiced a few 
times before invoking it with real data.
Do only six months or a year's worth of your most recent data at a time. This 
gives you current information immediately, allowing you to fill in older data 
as you have time.
Use common Description terms, such as "Dividend Reinvestment" when possible - 
this allows you to  to create the same split as previously, saving much 
Debit/Credit assignment clicks.


___
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] Change edit account mutual fund Security/Currency value

[ornd25]

"One way to achieve this may be to create a second stock account with 
thecorrect currency using a dummy name, then delete the account with 
theincorrect currency. In the delete dialog it should ask you if you want 
totransfer any existing transactions into the account you are deleting 
toanother account. Specify the new account with the correctcurrency/commodity.  
Don't know if this works on stock type accounts or fortransactions with 
different currencies but it does for most other accountdeletions. You may have 
to do some editing to get the prices right afterthis if it does work.

David Cousens"

Thank you, David. I was fixated on "change" and didn't consider "delete."

It did work and required no additional editing. I had already completed this 
transition using the export/import/editing but decided this was cleaner with 
less chance of induced error and so used the "delete" approach anyway.
___
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] Understanding Transaction Report options

[ornd25]

Oct 12, 2019, 17:09 by mailbox0...@yahoo.com:

>
> OK, I'll take a shot  at this since I've been using  the  Transaction Report 
> a lot  over the last two weeks.
>
> If you run a Transaction Report on Checking and select...
>
> Filter Type: Transactions To/From Filter Accounts...
>
> Filter By: Expenses > Utilities
>
> Then Click Apply...
>
> then gnuCash will show you all transactions that hit the checking account 
> that were charged to the Utilities Expense Account
>
> ALSO... If you want more than one account you can Ctl Click to add accounts...
>
> For instance if you want the Transaction Report to include both Checking and 
> Savings then you can Click Checking and Ctl Click Savings in "Accounts" 
> section at the top sections of the Accounts Tab in the Options popup window.
>
> And, you can also add additional "Filter By: accounts in the same way... for 
> example you can "Filter By"...
>  Expenses > Insurance > Health Insurance
> and then Ctl  Click Medical Expenses and then Apply
>
> Then the Transaction Report will show you what hit your Checking and Savings 
> Accounts that were charged to either Health Insurance or Medical Insurance.
>
> I suggest you copy your gnuCash file and rename the copy test.gnucash and 
> then open that and do some experiments... shouldn't take long to get the 
> general idea.
>
> Regarding Regular Expressions... That is a really complicated way to search 
> used mainly by programmers and I would suggest you avoid it unless you 
> really... really need a special type of search. If so there are plenty of 
> YouTube Tutorials on how to search using Regular Expressions.
>
> Didn't cover all your questions but this should get you started.
>
> And finally, I must say, the Transaction Report is a great feature of 
> gnuCash... so thanks to the development team for that!
>
> Hope this helps.
>
>
>
> On Saturday, October 12, 2019, 11:37:33 AM EDT, orn...@tutanota.com 
>  wrote:
>
>
>
> I’m having some trouble understanding the meaning of the Accounts and Filter 
> tabs options and I find the Help and the Tutorial and Concepts Guide needs a 
> bit more explanation.
>
> 1. Account tab:  What does the “Include transactions to/from Filter Accounts” 
> (and “Exclude”) mean? The documentation uses those same words to describe 
> their function.
>
> 2. Account tab:  I understand the Account tree selection under “Accounts” 
> (top block), but what is the account tree under “Filter By” used for? How can 
> you “filter by” something you’ve already chosen?
>
> 3. Filter tab: How is the “Account Name Filter” used? Am I to change it each 
> time for a selection or is this invoking a previously-named “Account Name 
> Filter?”
>
> 4. Filter tab: The “Transaction Filter” appears to be used to specify the 
> words I want to report and link them to the specific transaction in which 
> they appear, but sometimes the Transaction Report indicates “No transactions 
> were found,” so perhaps I’m mistaken.
>
> 5. Filter tab: When would I select “Use regular expressions for transaction 
> filter?”
>
> 6. Filter tab: What is POSIX and how and why should I invoke it?
>
> 7. Filter tab: How can I invoke a boolean “OR” to report either of two or 
> more transaction filters? (in this case I want to report a transaction that 
> has either one person’s name or another in the Description.)
>
> ___
> 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.
>
Fran_3,

Yes, it does help with context.

1. Account tab:  What does the “Include transactions to/from Filter Accounts” 
(and “Exclude”) mean? The documentation uses those same words to describe their 
function.

2. Account tab:  I understand the Account tree selection under “Accounts” (top 
block), but what is the account tree under “Filter By” used for? How can you 
“filter by” something you’ve already chosen?

Update: Choosing two different accounts (or sets of accounts) in the two 
account trees means you’re looking for the intersection of the two sets. I must 
have tried it previously only with “Exclude” (see Number 1, above) and that 
didn’t work at all.

With “Include” selected it mostly worked, except long splits with two 
possibilities would show both possibilities (same date), with one that wasn’t 
really the expected result, unless the Transaction filter (number 4, below, 
also limited it further. Okay, I understand this now.

3. Filter tab: How is the “Account Name Filter” used? Am I to use it each time 
for a 

[GNC] Understanding Transaction Report options

[ornd25]

I’m having some trouble understanding the meaning of the Accounts and Filter 
tabs options and I find the Help and the Tutorial and Concepts Guide needs a 
bit more explanation.

1. Account tab:  What does the “Include transactions to/from Filter Accounts” 
(and “Exclude”) mean? The documentation uses those same words to describe their 
function.

2. Account tab:  I understand the Account tree selection under “Accounts” (top 
block), but what is the account tree under “Filter By” used for? How can you 
“filter by” something you’ve already chosen?

3. Filter tab: How is the “Account Name Filter” used? Am I to change it each 
time for a selection or is this invoking a previously-named “Account Name 
Filter?”

4. Filter tab: The “Transaction Filter” appears to be used to specify the words 
I want to report and link them to the specific transaction in which they 
appear, but sometimes the Transaction Report indicates “No transactions were 
found,” so perhaps I’m mistaken.

5. Filter tab: When would I select “Use regular expressions for transaction 
filter?”

6. Filter tab: What is POSIX and how and why should I invoke it?

7. Filter tab: How can I invoke a boolean “OR” to report either of two or more 
transaction filters? (in this case I want to report a transaction that has 
either one person’s name or another in the Description.)

___
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] gnucash-user Digest, Vol 199, Issue 18

[ornd25]

"I think you have found the bug in the import and export of stocktransactions. 
I recently exportedsome dummy stock transactions and theinformation in the 
exported CSV records appears to be correct. I am workingmy way through the CSV 
import process and documenting it as I go withexamples for the guideand I 
hadn't made it to doing the stock transactions as yet. I have jumped ahead and 
reimported  stock purchase and stock saletransactions with no errors at all.I 
created a dummy dividend reinvestmenttransaction for a stock and exported it in 
the GnuCash Export Format andthen reimported it. On reimporting it created a 
miscellaneous transaction tothe imbalance account for 3.45.   The price on 
export was 14+17238/34483 butwhen reimported the price is recorded as 
13+17238/34483 accounting for thisdifference. This appears to be some problem 
with importing prices expressedas a whole number + a fractional part.The 
transaction recorded before export in the stock account register  was   
 
   Shares   
Price  Debit  
CreditAsset:Investments:Brokerage:Stock:Acme  6.8966  
14+17238/34483   100Income:Dividend 
 100After 
reimporting after deleting the transaction exported it reappears as 
 Shares   Price 
 Debit  CreditAsset:Investments:Brokerage:Stock:Acme
  6.8966  13+17238/34483   96.55Imbalance   
   
3.45Income:Dividend 
 100
1and there is a 
spurious line with a 
 1 in the price column - no account andno values in the debit and credit 
columns.If I edit the 96.55 to 100 and then tab to the next line and ask for 
theprice to be recalculated when the dialogue to rebalance the transactioncomes 
up then the price is restored to its original value and a secondimbalance line 
with a credit of 3.45 is created to balance the debit whichstill exists 
although ithe Imbalance account does not appear in the accountcolumn for that 
line (it is assigned to the Imbalance account when the editis closed). If I 
then close the edit on the transaction by clicking onanother transaction or at 
the bottom of the register it closes and whenreopened the Imbalance entries 
have disappeared as expected. Deleting the Imbalance entries in the editor can 
be tricky as you can't select the two matching entries simultaneously and 
delete them together andthe minute you delete one GnuCash recalulates the other 
because thetransaction is imbalanced. This is a quirk of the transaction ed
 it operationas it does not currently check if there is an existing split to an 
Imbalanceaccount which could be cancelled out (or its balance changed) by the 
newlycreated balancing split. I didn't have a dummy mutual fund setup in the 
dummy books I am currentlyusing to develop the documentation but the stock 
import should be the sameand is likely experiencing  the same problem. If you 
open the CSV file in atext editor and find the line you can check if the price 
recorded on exportis the same after being reimported to see if the problem is 
the same. If itis you could report it as a bug at bugs.gnucash .orgDavid 
Cousens"
David, I got a similar spurious entry (your 3.45, above) only if I had not 
deleted the TransactionID or Price formula, either or both, because I deleted 
them at the same time. After deleting them I just got the extra line in my 
original post.

I will write up the bug on Bugzilla as I phrased in in my OP, and I will also 
mention the spurious amount briefly. Please add anything to it you wish.

___
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] GC Importing GC Export Format - too many credits

[ornd25]

When I import using GnuCash Export Format it brings in more splits than I 
requested.

This is a simple dividend reinvestment, with one Dr Asset:Mutual fund, and one 
Cr Income:Dividends. I ended up with the wrong number of splits and a wrong 
allocation follows:
Line 1 - Asset: Mutual Fund 3.026 shares
Line 2 - Income:Dividend Dr $100
Line 3 - Income:Dividend Cr $100

I created the format by actually exporting dividend reinvestment lines from the 
applicable account. I did not add any others by copying the first several I 
directly downloaded. I then changed the dates, deleted the TransactionID, price 
calculation, changed Reconciled to "n" and removed the reconciliation dates. 
The import went well with only the two accounts to link - it was just the 
result that was odd.

If this is just a quirk, it's simple enough to work around it by manually 
moving the Dr amount to the Asset:Mutual Fund line and deleting the extra 
Income:Dividend line, but if I'm doing something wrong or there's a way to 
correct it, I'd like to fix it.


___
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] Correcting Bayesian rules?

[ornd25]

I suspect I corrupted the Bayesian reasoning, accidentally. I did an import and 
matched things badly, then quit GC without saving. I understand there is a bug 
report indicating that quit-before-save does not correct Bayesian errors.

So, how do you correct a Bayesian reasoning error that you have caused, other 
than manually repairing every 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.

[GNC] GC Transaction Report for investments displays shares not money

[ornd25]

"My Transaction Report is displaying the proper transactions for my filter, but 
because these are mutual funds the totals are in numbers of shares instead of 
currency. Under a column heading "Amount" it shows FundA150 (shares) instead of 
the value, FundA $1,000. How do I display dollars?"

Checking the "Common Currency" block in the General tab will allow money to 
display in lieu of share numbers.
___
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] GC Transaction Report for investments displays shares not money

[ornd25]

My Transaction Report is displaying the proper transactions for my filter, but 
because these are mutual funds the totals are in numbers of shares instead of 
currency. Under a column heading "Amount" it shows FundA150 (shares) instead of 
the value, FundA $1,000. How do I display dollars?
___
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] Trouble with import and splits (David Cousens)

[ornd25]

> "AFAIK the import process for securites and transactions with currency 
> changesis problematical even when importing data re-exported from GnuCash."
> ...
> "One thing you could try is to create a correct dummy transaction of 
> thetype(s) you need to import, export them to CSV using the 
> multi-splitmulti-line ( default GnuCash Export Format) and then try 
> reimporting theminto GnuCash using the same format.  If that works you can 
> examine the CSVexport format and put your import data in the same format 
> before trying toimport it.David Cousens"
>
> Thanks, David. I've spent a lot of time trying to automate my migration and 
> so far I haven't been able to do it well, but I keep trying, finally giving 
> up and doing it manually. 
>
> I took your suggestion and exported an account with transactions similar to 
> the ones I mentioned in my original post - without the ability to write good 
> script, it appears I'd spend a lot more time massaging .csv data into usable 
> form that might not be quite good enough. I think I'll do it manually. 
> Thanks, anyway.
>
>
David, I was mistaken. I found the "GnuCash format" import to be very useful 
for some routine transactions in which only the date changes - pay splits with 
standard deductions and similar things.  It's allowed me to import my accounts 
further back much more quickly than doing it manually. Thanks. I didn't want 
posterity to see a negative comment record of this useful tool.
___
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] Please suggest approach to track a category of disbursements

[ornd25]

> Dr. Taxable Fund  $80
> Dr. Exp:Tax   $20
>  Cr. IRA  $100
>
> Could you describe in more detail what info you want to see? That is, are 
> there certain totals or balances you want to track?
>
> What you are doing above can show you how much went from one account (the 
> IRA) to another account. (or multiple accounts)
>
> This can be done with a Transaction Report or a Cash Flow Report. (which is 
> misnamed, but does this particular job)
>
> Since you mentioned tracking 20+ taxable funds, David and I mentioned 
> possibly creating a single placeholder account and then put those individual 
> funds as their own accounts as children of the placeholder ?e.g.,
>
> Assets:Investments:Taxable Funds
> Assets:Investments:Taxable Funds:Fund A
> Assets:Investments:Taxable Funds:Fund B
> Assets:Investments:Taxable Funds:Fund C
> Assets:Investments:Taxable Funds:Fund etc.
>
> If you and your wife both invest in the same fund individually and you want 
> to track that separately, you could ?tag? each transaction with your names 
> somewhere and filter reports based on that info. (see below) You could also 
> create an intermediary placeholder for you and your wife, but I don?t think 
> that is necessary and might get messy. But do what works for you. You might 
> even leave out the ?Taxable Funds? example above and just put the individual 
> funds under ?Investments?.
>
> This would allow you to see all of the accounts aggregated if you wanted in a 
> report, (or the CoA tab) or individually as desired. (or any mix of them 
> since you can select individual accounts for a report)
>
> The Transaction Report is likely the better vehicle here because it allows 
> for filtering against accounts as well as filtering on info such as 
> Description, Notes, or Memos of individual splits. This way, you could enter 
> more detailed info there and run a report to see totals/balances based on 
> that info. (what that info might be is up to you)
>
> Get a handle on how you want to structure your account tree to track all of 
> these funds, and then try a Transaction Report including only those accounts. 
> Play with the options a bit to see how they work. Then feel free to come back 
> with more questions on tweaking that. I too found the Report documentation a 
> bit rough at first. I learned the most by running the reports and tweaking 
> options.
>
> Regards,
> Adrien
>
I want to be able to track all disbursements from IRA/tax-benefited funds and 
accept David's and your recommendation that I use Reports to do this rather 
than an intermediate account. I'm tracking only six funds plus some associated 
cash funds and some CDs, but rather than the simple account tree you and he 
mention with tags, I nested them deeply. "Investments" account has three 
children, tax-free Roth, tax-benefited IRA, and taxable. Each of those accounts 
is split between my wife and me, and that leads to the 20+ number that I track. 
That part works okay, but apparently does yield some difficulties in tracking 
disbursements from those two particular branches.

I'll look into changing this but initially I'll spend some time learning the 
Report system. In that regard I did locate the Options button in the menu bar 
and that definitely helps my learning process. The Tutorial and Concepts Guide 
was more useful to me as a beginner than the Help Guide. I have some questions 
about that but I'll ask those in a separate question.

Thanks. We can call this question complete.
___
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] gnucash-user Digest, Vol 199, Issue 3

[ornd25]

Adrien, thanks for responding. I hope I have some misconceptions that can be 
easily rectified but a belief in a limited number of splits isn’t one of them.

In order for my notional “Disbursements” account to work the full disbursement 
before taxes must be debited fully in Disbursements pre-tax in a single 
transaction (or so I believe). Once it’s there, I have no choice but to do the 
tax split from Disbursements (again, so I believe) in a second transaction. 
Those two transactions then led me to the abstraction, confusion, and 
self-zeroing problems I mentioned in the OP.

I’m not sure what you mean about making child accounts under disbursements - 
Exp:Income Tax is already an account.

If I have misunderstood you, please tell me.

> I?m sure there are various methods but you can change IRA distributions to be 
> a parent account. Then make the necessary sub-accounts for the various 
> distributions.
>
> You can report on only the total distributions or the individual ones as 
> needed.
>
> You also don?t need to make a transaction include only 2 accounts. You can 
> have as many splits as you like.
>
> It looks like you?re adding layers and accounts simply by following a 2-split 
> per transaction artificial limitation. (which does not exist in GnuCash)
>
> That withholding split can be a part of the original transaction.
>
> Regards,
> Adrien
>
>> On Oct 1, 2019 w40d274, at 11:49 AM,  
>>  wrote:
>>
>> I would like to track IRA disbursements. (For those who don't know, an 
>> Individual Retirement Account is a US category of retirement investments in 
>> which taxes are not paid until the funds are withdrawn, i.e., "disbursed." 
>> In our case and these are disbursements from an IRA mutual fund and will be 
>> re-invested in a taxable mutual fund.
>>
>> 1. I'm currently using the simplest way - Cr losing IRA mutual fund $100, Dr 
>> gaining taxable fund $80, Dr withholding tax $20. I keep track of where the 
>> various distributions are by using the term "Distributions" in the GnuCash 
>> Description block. That way I can easily find them.
>>
>> 2. I tried setting up an "IRA Distributions" account but I found it 
>> unsatisfactory for various reasons, at least the way I set it up. It require 
>> two transactions instead of one. First, Cr losing IRA fund $100 and Dr IRA 
>> Distributions. Then, from the "IRA Distributions" account, Dr "IRA 
>> Distributions" $100, Cr "Withholding tax" $20, and Dr gaining taxable 
>> account $80.
>>
>> I had two problems I had with the second approach before I returned to the 
>> simple approach. It abstracted the re-investment and the withholding tax 
>> from the actual distribution and I found it confusing, even after I created 
>> it. Also, the "IRA Distributions" account was self-zeroing, as my debits and 
>> credits were equal - I was hoping for an approach that would clearly show my 
>> distributions over time.
>>
>> Between my wife's accounts and mine - different flavors of tax-benefitted 
>> and taxable accounts - I'm tracking 20+ accounts and I would like some 
>> suggestions as to a simple, clear way to do it.
>>

___
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] Please suggest approach to track a category of disbursements

[ornd25]

> I would use placeholder accounts under some sort of Assets:Investments top
> level structure to record funds whose tax treatments was different.  You
> could use the description/memo fields to cross reference funds transferred
> between the different categories of investment as you suggest with a
> searchable keyword.  Using an intermediate account really doesn't add
> anything unless the taxation on exit status could be maintained for those
> funds on reinvestment. A transaction report where you specify the
> placeholder and subaccounts for your IRA accounts in the Accounts tab and
> also specify displaying the transfer account, sorted on transfer account,
> date etc should give you a record of the transactions to and from the IRA
> fund account(s). It can be saved as a custom  user report for reuse and
> exported and modified further as required.
>
> David Cousens
>
David, thanks, some of your comments were a little over my head, but I think I 
understand that you don’t believe I can accomplish what I want with an account 
- I have about come to that conclusion myself - and I should approach the 
problem with a Transaction Report. Unfortunately, when I reviewed the Help 
Manual on Reports I found it to be really heavy going. Is there somewhere I can 
read beginner-level Report documentation?

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

[GNC] Please suggest approach to track a category of disbursements

[ornd25]

I would like to track IRA disbursements. (For those who don't know, an 
Individual Retirement Account is a US category of retirement investments in 
which taxes are not paid until the funds are withdrawn, i.e., "disbursed." In 
our case and these are disbursements from an IRA mutual fund and will be 
re-invested in a taxable mutual fund.

1. I'm currently using the simplest way - Cr losing IRA mutual fund $100, Dr 
gaining taxable fund $80, Dr withholding tax $20. I keep track of where the 
various distributions are by using the term "Distributions" in the GnuCash 
Description block. That way I can easily find them.

2. I tried setting up an "IRA Distributions" account but I found it 
unsatisfactory for various reasons, at least the way I set it up. It require 
two transactions instead of one. First, Cr losing IRA fund $100 and Dr IRA 
Distributions. Then, from the "IRA Distributions" account, Dr "IRA 
Distributions" $100, Cr "Withholding tax" $20, and Dr gaining taxable account 
$80.

I had two problems I had with the second approach before I returned to the 
simple approach. It abstracted the re-investment and the withholding tax from 
the actual distribution and I found it confusing, even after I created it. 
Also, the "IRA Distributions" account was self-zeroing, as my debits and 
credits were equal - I was hoping for an approach that would clearly show my 
distributions over time.

Between my wife's accounts and mine - different flavors of tax-benefitted and 
taxable accounts - I'm tracking 20+ accounts and I would like some suggestions 
as to a simple, clear way to do it.

___
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] Trouble with import and splits

[ornd25]

"AFAIK the import process for securites and transactions with currency 
changesis problematical even when importing data re-exported from GnuCash."
...
"One thing you could try is to create a correct dummy transaction of thetype(s) 
you need to import, export them to CSV using the multi-splitmulti-line ( 
default GnuCash Export Format) and then try reimporting theminto GnuCash using 
the same format.  If that works you can examine the CSVexport format and put 
your import data in the same format before trying toimport it.David Cousens"

Thanks, David. I've spent a lot of time trying to automate my migration and so 
far I haven't been able to do it well, but I keep trying, finally giving up and 
doing it manually. 

I took your suggestion and exported an account with transactions similar to the 
ones I mentioned in my original post - without the ability to write good 
script, it appears I'd spend a lot more time massaging .csv data into usable 
form that might not be quite good enough. I think I'll do it manually. Thanks, 
anyway.
___
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] Trouble with import and splits

[ornd25]

I can't get the split to calculate a price properly after an import.

The account block in the Import Preview is right and the debit amount is right 
and in the proper account after import, the split accounts are right (after the 
import matcher), and the deposit amount is right and it goes to into debit. 
(Assume small dividends being re-invested.) The share amount is wrong - it's 
the same number as the dollar amount because the default price is $1.00, but I 
expect that because I don't know of a "number of shares" column in the import 
screen.

Here's an example of one Dividend Re-Investment line after import: Tot Shares - 
102.5, Share Price 1.00, Total Debit 102.5.(This latter is accurate.)
It provides me with three splits the base account and two for the 
Transfer/Destination account, one for 3.107, and the other 99.393, both of the 
latter two are the Transfer/Destination account, but I don't know what the 
separate amounts signify.

My actions: Change Number of Shares to 3.136 in order to allow GC to calculate 
the price at approximately $32.68. I click down into the first split line and 
the Recalculate Transaction box pops up  allowing me to choose "Recalculate 
Price," which I do. It then recalculates the price back to $1.00 and changes 
the number of shares back to the 102.5, the correct number if share price were 
$1.00.

This seems to take place only after I've imported transactions, not when I 
create them all from scratch.

I haven't been able to locate this as a known bug, but it's possible I'm 
searching for the wrong terms.



___
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] Suggestion to ease newbies import problems

[ornd25]

As a newbie I did (and do) have some trouble with GnuCash, but my largest 
concerns were with the  import process. I have a few suggestions that might 
ease the path of the next newbies to come. The import process, per se, seemed 
to go smoothly - it was the assigning appropriate splits that took me a few 
weeks. May I suggest that the Tutorial and Concepts Guide, Chapter 3, be 
expanded very slightly with regard to comma separated value (csv) files? 

First, and most simply, the Guide refers to "Base Account" and "Destination 
Account," while the Import wizard itself has the word "Transfer" apparently in 
lieu of "Destination; I didn't understand this for some time. 

Second, the Guide in "Import Panel" refers to "minimum to import data," while 
"optimum" would have aided me significantly. Adding a column in a .csv file 
with the Destination (Transfer) would have saved me many double-clicks in the 
Matcher. Perhaps a sentence added would help: "Those planning to import large 
amounts of data by .csv will be aided by adding a Destination column in their 
import file."

Finally, after adding the new column, the Importer led me to a page that 
confused me for a short time. It said something about needing to change or add 
Links. On my test (well after completing this the hard way) It wanted me to 
change From Expenses:Miscellaneous to Expenses:Miscellaneous. I'm certain this 
is nothing more than a last check to ensure that you will be importing them to 
where you really want them, but perhaps if the words match so exactly the 
question might be changed to something like, "Unless you change links your 
Exp:Misc will have a Destination of Exp:Misc," or something similar.

There were other instances of mild confusion, but they applied to my attempting 
to convert credit cards as expenses to credit cards as liabilities and would 
not necessarily apply as broadly as the above.

On the good side, the time I spent converting 10 years of old data made me 
quite comfortable with GnuCash, so it wasn't time wasted.


___
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] Bank check - debit and credit?

[ornd25]

"For a one off for a personal account i would record it as follows. You willnot 
normally be notified by the bank when the bank cheque is cleared sothere is 
little point in having a clearing account as you might for personalcheques. As 
Mike points out it isor may be a negotiable instrument and maynot necessarily 
be cashed by the receiver. That is not really your concernonly the receiver's 
and the banks. The only other possibility is that manybanks will charge a fee 
for issuing a bank cheque:
DR   CRAsset:Checking Account
Expense:Bank Fees   Expense:Repairs 
  where  = +   and  is the amount of the bank 
check.I would record in the Description and/or memo fields for the expense that 
itwas a bank cheque and the bank cheque number and you would record your 
owncheque number made out to the bank as you would normally for any otherch
 eck.Recording the details is useful should the bank cheque not be cashed by 
therecipient - unlikely if a business but it has happened in cases where it 
hasbeen posted to someone and not been received. The bank can track down if 
itwas cashed and by whom if necessary.David Cousens"

Thank you - I appreciate the answers. This issue is resolved.


___
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] GNC] Bank check - debit and credit?

[ornd25]

"a) ...Your purchase of one is just an asset transfer transaction. When and if 
used to pay an expense* that transaction would be debit expense and credit this 
asset. The reason I put the asterisk is often the bank check is needed to 
purchase an expensive asset (car, house, art work, etc.) so the debit side 
would be for some fixed asset,not an expense.
Michael D Novack"

This appears to be my answer. Some of my accounts are doing this... Cr 
checking, Dr assets:art?

If that's the case I can rid myself of the confusion of trying to use the Cash 
account.


___
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] Bank check - debit and credit?

[ornd25]

On 9/19/2019 9:20 AM, orn...@tutanota.com wrote:

>> How does one debit and credit for a bank check when the person/company 
>> doesn't want to accept a personal check? I usually forgo reality and just 
>> record that I sent the personal check directly to the individual, but that's 
>> not exactly what happens.
>>
>
> I think this depends on how fancy you want to be. Perhaps not unrelated 
> to how you enter OTHER "check" transactions for which there is no check 
> number like automatic payments, one time electronic payments, etc.
>
> IF the money (for purchase  the bank check) came from the checking 
> account, I'd probably treat is as a numberless check putting into the 
> description column something like "bank check to..." instead of just 
> the payee. 
>
> Michael D Novack
>
Mike, 

That's the way I was doing it previously, but persuaded myself that I should 
track it "properly." My original question meant, "I give the bank check number 
527 for cash or made out to the bank for $75, so Cr Checking, Dr bank. Then 
they hand me a cashier's check - is that "other income?" Then I give the check 
to the repair service - what am I to Dr and Cr at that point.

As I said, that was my original question, and I withdraw it; I will call check 
number 527 "Repair Service - Bank Check." That's close enough for personal 
expenses. Thanks.

For what it's worth, I do "number" my electronic payments with the next paper 
checks in order, then I destroy the paper checks. This allows me to sort by 
check number and find the payment, though I do add in Notes: "ePay - numbered 
for convenience." Then I add the pseudo numbers to the balance statement.

___
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] Bank check - debit and credit?

[ornd25]

> You left out a few details.  Is this a business expense?  Or is it something 
> else?  In the accounting world, purpose is the driving force.  
>
> If you are just concerned about the mechanics of the money flow, you would 
> show a conversion to cash or whatever medium you used as an intermediate 
> step. That, of course requires appropriate accounts, such as petty cash, for 
> example.
>
> David Carlson
>
> On Thu, Sep 19, 2019 at 9:22 AM <> orn...@tutanota.com 
> > > wrote:
>
>> How does one debit and credit for a bank check when the person/company 
>> doesn't want to accept a personal check? I usually forgo reality and just 
>> record that I sent the personal check directly to the individual, but that's 
>> not exactly what happens.
>>
Let me expand a little. This is for personal use, such as the purchase of 
artwork or a service, so its purpose is not for a business. Recent examples 
were for repair of a vintage fountain pen or a wrist watch. The repairers asked 
for a bank check, so I wrote a check to the bank for cash, the bank then gave 
me a "bank check," which I sent to the repairer. 

What are the mechanics of double entry debits and credits? If I write the check 
to the bank do I then have to show income to bring it back in?

As I mentioned, I ended up showing a check written to the repairer, rather than 
reflecting the actual purchase of a bank check.
___
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] Bank check - debit and credit?

[ornd25]

How does one debit and credit for a bank check when the person/company doesn't 
want to accept a personal check? I usually forgo reality and just record that I 
sent the personal check directly to the individual, but that's not exactly what 
happens.



___
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] Are insurance proceeds income?

[ornd25]

>> Are insurance proceeds income? If not, how do you characterize an insurance 
>> payout when they send you a check?
>>
...

> I have always considered it "income" but I know of others who think it
> is a "return of premiums paid".? Certainly it is also an offset against
> a "loss".
>
Thanks. I'll ask him at tax time but until then I'll carry it as "Other Income."
___
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] Are insurance proceeds income?

[ornd25]

Are insurance proceeds income? If not, how do you characterize an insurance 
payout when they send you a check?

I've seen a reference online to using accounts receivable against lowered value 
of inventory, but that approach doesn't seem to apply to a homeowner who has 
storm damage or a fire.


___
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] Credit Card Format Good?

[ornd25]

> For example, ... if you paid with the credit card would be db expense; cr 
> credit card.
>
> Then when you pay against credit card charges might be:
>  1) balance paid in full, no interest - db credit card; cr checking
>  ...
> Michael D Novack
>
>
Possible duplicate.

Thank you, Mike. I'm enjoying the discussion, but you've answered my question.
___
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] gnucash-user Digest, Vol 198, Issue 34

[ornd25]

> For example, ... if you paid with the credit card would be db expense; cr 
> credit card.
>
> Then when you pay against credit card charges might be:
>  1) balance paid in full, no interest - db credit card; cr checking
>  ...
>
> Michael D Novack
>
>
>
Michael,

Thank you. I'm enjoying the discussion, but this answers my question.
___
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] Credit Card Format Good?

[ornd25]

I've just recently started with GnuCash and decided to treat credit cards as 
liabilities rather than expenses as I did previously. To that end I've migrated 
my accounts, but since I don't know how the result should appear I'd like to 
ask if I have it done properly.

Right now I've set it up simply, without tracking individual purchases, but if 
I've done it right, I can begin to track individual purchases next month.

Expense:Credit Card Charge Account
Expense:Credit Card (Column "Tot Expense") $5
Liabilities:Credit Card-L (Column "Tot Rebate") $5

Liabilities Account
Entry 1
Credit Card-L Account
Bills:Credit Card Charge (Column "Payment") $5
Liabilities:Credit Cards - L (Column "Charge") $5

Entry 2
Credit Card-L Account
Liabilities:Credit Cards - L (Column "Payment") $5
Checking account   (Column "Charge") $5

Expenses no longer balance; Liabilities balance, but I suppose they would if 
I'd done it completely backwards. Is this done properly or backwards?



___
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] Convert credit cards as expenses to credit cards as liabilities?

[ornd25]

> If you?re going to keep using the simplified method, there?s no point to 
> changing the account type.
>
> #1 you?d lose expense tracking entirely for anything spent via the card.
> #2 credit card liability would forever be ?negative? (meaning they owe you)
>
> The simplified method works as you have been doing it.
>
> The more real-world method is as follows:
>
> -
> When making a purchase on credit:
>
> Dr. Expenses:(whatever)
> Cr. Liabilities:Credit Card
>
> When making a payment on the card:
>
> Dr. Liabilities:Credit Card
> Cr. Checking
>
> Now you can track what you spent the money on, as well as how much you owe on 
> the card.
>
> --
>
> With the current method, all you are doing is recording the card payment from 
> checking and no specific expense tracking at all. (even though it is listed 
> as an expense account, you keep increasing it forever as a generic) But an 
> Income Statement will make sense, as will your Balance Sheet
>
> With the switch you are considering, you?d just be doing the second of the 
> above two transactions instead of:
>
> Dr. Expenses:Credit Card
> Cr. Checking
>
> Which would remove expenses entirely and make your liabilities look like 
> assets since they are negative. (because you keep paying more down, without 
> the charge part of the transaction) So both your Income Statement and Balance 
> Sheet would be wrong.
>
> It wouldn?t be hard to switch the historical data, especially since it is 
> just 240 transactions. (which you?ve already noted you don?t mind altering)
>
> That would *maybe* involve changing the account type. You shouldn?t need to 
> alter those 240 transactions, because those splits assigned to the card are 
> still going to be debits. (they were payments, now on a liability which is 
> correct)
>
> If you can?t just change the type, then create the new liability account and 
> then delete the old expense account. When GnuCash asks, choose the liability 
> version to assign the transactions to. In a very worst case, you?d have to do 
> that manually 240 times, but I think it is going to be more automatic than 
> that.
>
> What you would need to do for the card account balance to make sense (and not 
> understate your liabilities) is to also enter 240 expense transactions 
> between the card and ?something?. (you might also do this as annual 
> transactions, or even a single transaction as the sum of everything up to 
> this point)
>
> If you don?t know or don?t care what those historical transactions were for, 
> you could either leave the expenses:card in place and assign them there, or 
> create a ?miscellaneous? account or something similar and then proceed in the 
> future with recording actual expenses paid with the card.
>
> You might also be able to download some of that actual history from your card 
> company if you think you want it. (I doubt all 10 years though)
>
> Regards,
> Adrien
>
>
Thank you, Adrien. We can close this.

I'll try your import idea using my Expenses:Credit Card export as a baseline. 
First I'll modify it using search and replace for what the Liabilities:Credit 
Card account should look like with regard to Expenses:Credit Card, then, 
second, I'll modify the Expenses:Credit Card account to remove the checking 
account reference - probably I'll just remove all the transactions and allow 
them to rebuild when I import the Liabilties:Credit Card transaction. Finally, 
I'll modify the original Expenses:Credit Card transactions to reflect them paid 
from within the Liabilities:Credit Card account. I'll try all this with the 
Transaction ID removed. 

If this doesn't work, then I'll fall back to just doing it properly from now on.

I did check my bank's download capability and it's limited to 120 days, though 
they do have 10 years worth of monthly statements.

Again, thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Convert credit cards as expenses to credit cards as liabilities?

[ornd25]

Can I convert credit cards as expenses to credit cards as liabilities 
reasonably easily, or is my best choice to start doing it properly now and 
leave the old transactions alone?

I have just started with GnuCash and have imported and hand-massaged 10 years 
worth of records from two other financial managers. In them I was tracking only 
Income and Expenses and therefore treated credit cards as expenses in a 
simplified manner, that is, one credit card entry per month per credit card in 
Expenses:Credit Card and one entry per month paying that bill from 
Bank:Checking. Each Bank:checking was reconciled, and Expenses:credit card was 
not reconciled. 

There are two credit cards so Expenses:credit card has approximately 240 
entries for 10 years.

I intend to continue with the simplified approach per the documentation, so I 
won't be entering individual credit card charges, just the monthly amount.

MY first thought was to change Expenses:Credit Card to Liabilities:Credit Card, 
but then I'd be left without an Expense:Credit Card.

I actually don't mind manipulating 240 transactions, but entering 240 of them 
invites errors.

Do I have a way to do this? If so, please explain simply, remembering my newbie 
status.

Thanks.




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