Navigator User Forums
  Transaction Entry
  Balancing Transactions

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Balancing Transactions
edgiamboi
Member
posted 08-29-2003 12:41 PM     Click Here to See the Profile for edgiamboi   Click Here to Email edgiamboi     Edit/Delete Message
How would you do the following transactions and who is the payor and which account for each transaction?
1. From a Retirement/Deferred IRA Asset account which we will call "Broker IRA" with an asset value of $30,000.00, you are to draw out $10,000.00 as an IRA distribution by a check. This is income in the tax schedule.
2. Deposit the check in a checking account that has a balance of $1,000.00.
After the entries made in the above transactions, show balances as follows:
Broker IRA $20,000.00
Checking Account $11,000.00
IRA Distribution $10,000.00

The IRA distribution should show up in the tax schedule as income.

I tried in your FN8 Demo to post the withdrawal as an IRA Distribution so that came out OK but the deposit if I use the IRA account as payor then the balance of the IRA account gets messed up and if I use Transfer Clearing account I don't balance transfers. If I use Transfer Clearing account for both transactions then I don't get the IRA distribution.

IP: Logged

fni_support
Moderator
posted 08-29-2003 04:39 PM     Click Here to See the Profile for fni_support     Edit/Delete Message
Hello Ed,

To accomplish what you want in your example, you will need to do two transactions:

1. Debit your Checking Account by $10,000 and Credit your IRA Distribution Income by $10,000.

2. Credit your Broker IRA account by $10,000 and Debit a Contra IRA Income account by $10,000.

Here is an example of these two transactions:

Checking Account:
Debit your Checking Account for $10,000. The offsetting account (credit) will be a your IRA Distribution Income account. Make sure your IRA Distribution Income account has the IRA Taxable Distribution tax code assigned to it.

IRA Account:
Credit your IRA Account for $10,000. The offsetting account (debit) will be a Contra Income account. Because you are debiting this income account it will be a negative amount. The net effect of your IRA Distribution Income and your Contra Income is zero and your total net worth did not change. You are simply taking money out of your IRA and putting it into your Checking Account and realizing this as taxable income.


---------------------------------------------
George
Financial Navigator Int’l

IP: Logged

edgiamboi
Member
posted 08-30-2003 12:51 AM     Click Here to See the Profile for edgiamboi   Click Here to Email edgiamboi     Edit/Delete Message
George:
I believe you want me to do a General Journal transaction with the debits and credits in your example especially since you want me to debit the checking account when I am making a deposit of the IRA Distribution in the account and crediting the IRA account when I am withdrawing funds.
After doing the transactions I get a negative balance in the Contra Income IRA Account which I set up in the Chart of Accounts under my IRA Distributions Income Account. Don't know what it is but set it up for the transactions. In the General Journal I had no idea as to who is the payee/payor and what account to enter. I made up phony names to accomplish the transactions. It was, also, difficult to enter Multiple Distributions as I did not get anything like what the Help Screen for Multiple Distributions says I should be getting. I believe I accomplished it by double clicking the Enter key but am not sure as when I did get it I didn't wnat to lose the window. I feel like a new user with FN 8 when I have used FN for the past nine years with no problems except for it is does not adjust for the year 2000. That is the main reason why I want to update. I have my own way of solving the problem listed but it is not an accountants procedure but works. I may do the same with your advice and only have to change the start up figure of the Contra Income by adding the debit amount making the balance zero.

IP: Logged

edgiamboi
Member
posted 08-31-2003 12:52 PM     Click Here to See the Profile for edgiamboi   Click Here to Email edgiamboi     Edit/Delete Message
George:
I deleted all General Journal entries in FN 8 Demo and started over again. I made one multiple transaction for all the transactions per your suggestion. The Checking account came out correct. The IRA Distribution came out correct. The Broker IRA account came out correct but the Contra IRA account came out with a negative balance. Am I making a mistake in my transactions? I know that the Demo only works for January so I posted the date as January 1. I usually use in my older FN in the Name or Memo Field (only info required)"Reclassification Entry" or "Depreciation" but in FN 8 they ask for a payee/payor and account. I created the Reclassification Entry payee/payor and then tried leaving the account field blank as suggested by your Help and then going to Debit and or Credit and enter a Zero but the window that pops up says that the Account Field cannot be blank and must be a Multiple Distribution. This is automatic in my current FN. There is nothing on the bottom of my window for me to click on to go into Multiple Distributions. If I right click my mouse I get a window that allows me to enter a Multiple Distribution and then get that window to enter transactions. This is not what your Help says. Am I doing something wrong?

IP: Logged

fni_support
Moderator
posted 09-04-2003 06:13 PM     Click Here to See the Profile for fni_support     Edit/Delete Message
Hello Ed,

You can go into Multiple Distributions screen by clicking the “***MD” button on your toolbar during Transaction Entry. This will bring up the Multiple Distribution screen for your current entry. I did not use Payee/Payor examples because these are really defined by you. You should use ones that are the most meaningful for you.

Yes, the Contra Income Account should have a negative balance. That is the nature of a contra account. It is needed to accomplish all of the transactions you need. It offsets the Income you received from your IRA to your Checking account. You are just really transferring amounts between two assets, and thus would not want to change your net income.

---------------------------------------------
George
Financial Navigator Int’l

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e