Re: importing one-ended transfers
On Wed, 31 May 2000, Hendrik Boom wrote: I now see the following possibility: One transaction, that debits the chequing account by $200, memo groceries debits the chequing account $10, memo cash debits the chequing account $90, memo allowances credits the allowance account $90, credits the cash account $210 This way the Quicken splits become gnucash splits in the same accounts. And Quicken splits that are associated with a category end up associated with the appropriate account. I'm not sure that I follow your logic here. Look at it from another view: Credit Allowance $ 90 Debit Chequing $300 Credit Cash $200 groceries Credit Cash $ 10 cash This seems to me to be closer to the transaction items that you would actually realize. I suspect that the bank only knows that you withdrew $300. From an accounting view, you have chosen to credit part of that to the Allowance account and the rest to the Cash account. You are using the memo field to represent subaccounts Cash:Groceries and Cash:Petty_Cash. -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
Re: importing one-ended transfers
On Wed, 31 May 2000, Hendrik Boom wrote: I now see the following possibility: One transaction, that debits the chequing account by $200, memo groceries debits the chequing account $10, memo cash debits the chequing account $90, memo allowances credits the allowance account $90, credits the cash account $210 This way the Quicken splits become gnucash splits in the same accounts. And Quicken splits that are associated with a category end up associated with the appropriate account. I'm not sure that I follow your logic here. Look at it from another view: Credit Allowance $ 90 Debit Chequing $300 Credit Cash $200 groceries Credit Cash $ 10 cash except that you lose the memo "allowances". This seems to me to be closer to the transaction items that you would actually realize. I'd be just as happy with your version as mine. It's just that I don't clearly see how your version generalises to situations where both ends of the transaction have been split in Quicken. I suspect that the bank only knows that you withdrew $300. From an accounting view, you have chosen to credit part of that to the Allowance account and the rest to the Cash account. You are using the memo field to represent subaccounts Cash:Groceries and Cash:Petty_Cash. -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED] -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
Re: importing one-ended transfers
On Fri, 02 Jun 2000, Hendrik Boom wrote: On Wed, 31 May 2000, Hendrik Boom wrote: I now see the following possibility: One transaction, that debits the chequing account by $200, memo groceries debits the chequing account $10, memo cash debits the chequing account $90, memo allowances credits the allowance account $90, credits the cash account $210 This way the Quicken splits become gnucash splits in the same accounts. And Quicken splits that are associated with a category end up associated with the appropriate account. I'm not sure that I follow your logic here. Look at it from another view: Credit Allowance $ 90 Debit Chequing $300 Credit Cash $200 groceries Credit Cash $ 10 cash except that you lose the memo "allowances". Sorry, that is just a "typo" error. That memo should be attached to the first line. This seems to me to be closer to the transaction items that you would actually realize. I'd be just as happy with your version as mine. It's just that I don't clearly see how your version generalises to situations where both ends of the transaction have been split in Quicken. I had to "jump through hoops" to create such transactions in Quicken. And the QIF form of them is virtually unrecognizable. However, I acknowledge that we need to have transactions in gnucash that have multiple JEs for the same account. This was discussed on this list a few weeks ago. -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
importing one-ended transfers
When I imported *everything* from Quicken to gnucash, I noticed the balances were different in gnucash from in Quicken, even after fixing the "Opening Balance" transaction. Hoping to nail a gnucash bug, I binary-searched throug about 8 years of transaction data, and found that it was not Gnucash, but Quicken that seems to have been at fault. Here's an extract from my (Quicken) [Checking] account: 12/04 pos provigo33.67 X368.88 1998 memo: cat: Groceries 12/04 cash cash 300.00 X 68.88 1998 SPLIT [cash] 200.00 groceries allowances 90.00 allowances [cash] 10.00 cash 12/04 interac fee 1.25 X 67.63 1998 memo: cat: Bank Chrg 12/04 039 Mini-Menage65.00 X 2.63 1998 memo: cat: Cleaning and in [cash]: 12/04 cash 210.00 49,641.91 1998 memo: cat: [Checking] As you see, one cash withdrawal is split into several purposes, two of which are handled in the cash account. When I import this into gnucash, the transactions become duplicated. I get both the split transaction from checking and the unsplit transaction from cash, presumably because it does not recognise that the split transaction in [Checking] corresponds to the nonsplit transaction in [cash]. Now I don't expect you to run and fix this (though it would be nice) immediately before a stable release, for fear of disturbing something else. But if the mass import process were to produce a log of unmatched transfers, this would help me track them down. gif file extracts follow: -- hendrik. from cash: ^ D12/ 4/98 T210.00 Pcash L[Checking] ^ from Checking: ^ D12/ 4/98 T-33.67 CX Npos Pprovigo LGroceries ^ D12/ 4/98 T-300.00 CX Ncash Pcash L[cash] S[cash] Egroceries $-200.00 Sallowances Eallowances $-90.00 S[cash] Ecash $-10.00 ^ D12/ 4/98 T-1.25 CX Pinterac fee LBank Chrg ^ D12/ 4/98 T-65.00 CX N039 PMini-Menage LCleaning ^ -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
importing one-ended transfers (fwd)
Whoops! I miswrote myself. - Forwarded message from Hendrik Boom - "Opening Balance" transaction. Hoping to nail a gnucash bug, I binary-searched throug about 8 years of transaction data, and found that it was not Gnucash, but Quicken that seems to have been at fault. - End of forwarded message from Hendrik Boom - As you can see from the details, the bug is in gnucash not in Quicken. -- hendrik. -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
Re: importing one-ended transfers
Hendrik Boom [EMAIL PROTECTED] writes: Now I don't expect you to run and fix this (though it would be nice) immediately before a stable release, for fear of disturbing something else. This period of time is for bug fixes, and you've found a bug, so it's the perfect time to fix it. The question is, what's the right way to fix the problem? In your ideal solution, would Gnucash merge the two splits into one, following the Cash account's representation of the event, or split the Cash transaction, following the Checking account's representation? But if the mass import process were to produce a log of unmatched transfers, this would help me track them down. This is on my list for 1.5 features in QIF import, along with a more general mechanism for recognizing transactions that have already been imported into gnucash. Bill Gribble -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]
Re: importing one-ended transfers
Hendrik Boom [EMAIL PROTECTED] writes: Now I don't expect you to run and fix this (though it would be nice) immediately before a stable release, for fear of disturbing something else. This period of time is for bug fixes, and you've found a bug, so it's the perfect time to fix it. The question is, what's the right way to fix the problem? In your ideal solution, would Gnucash merge the two splits into one, following the Cash account's representation of the event, or split the Cash transaction, following the Checking account's representation? Let's see.. In chequing, 12/04 cash cash 300.00 X 68.88 1998 SPLIT [cash] 200.00 groceries allowances 90.00 allowances [cash] 10.00 cash in cash, 12/04 cash 210.00 49,641.91 1998 memo: cat: [Checking] There are two Quicken accounts involved - chequing, and cash. There are three gnucash accounts involved - chequing, cash, and allowances. I had trouble deciding between your two choices, until I remembered that we do have multiple entry bookkeeping. This means we can choose how to split a little more cunningly that Quicken did. I now see the following possibility: One transaction, that debits the chequing account by $200, memo groceries debits the chequing account $10, memo cash debits the chequing account $90, memo allowances credits the allowance account $90, credits the cash account $210 This way the Quicken splits become gnucash splits in the same accounts. And Quicken splits that are associated with a category end up associated with the appropriate account. This resolution seems to specialize properly to the way you handle other transfers and categories. -- hendrik. -- Gnucash Developer's List To unsubscribe send empty email to: [EMAIL PROTECTED]