Navigator User Forums
  Navigator 9.0 New Features
  Converting Chart of Accounts for multiple years

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:   Converting Chart of Accounts for multiple years
FN_User
Member
posted 05-30-2008 11:45 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
Now that I can convert multiple years my old (Financial) Navigator 8.2 data into Navigator 9.0, I'm wondering how that works. What happens if I used different Category or account names in each year?

IP: Logged

David
Administrator
posted 05-30-2008 11:46 AM     Click Here to See the Profile for David     Edit/Delete Message
Good question.

For accounts, the conversion program looks at the account name and the Category. If both years have the exact same account name in the same Category, it creates a matching account in 9.0. If there is any difference in the account name, or the same name appears in multiple categories (not a good idea), it creates separate accounts.

For Categories (and Groups), the situation is a little different. The Chart of Accounts structure is fixed. It's all based on the position of the Category in the Master Chart of Accounts. There are a lot more Categories in 9.0, but the each of the old 8.2 Categories are pre-mapped to a matching 9.0 Category. So, if there is a difference in the spelling or even a completely different Category name at a certain position in in the Master Chart of Accounts, the conversion program can only assign the 8.2 Categories to a single 9.0 Category. The conversion program uses the Category name from the first data you convert to assign these Category names. We recommend that you convert the newest data first, then convert prior years.

All of this applies to a single entity. When you convert another entity, it gets its own Chart of Accounts with new Category names.

- David
FNI Technical Support
Case #38-10465

[This message has been edited by David (edited 05-30-2008).]

IP: Logged

FN_User
Member
posted 07-07-2008 09:33 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
OK, I understand that the following characteristics must match exactly from year to year for there to be just one account created on the single chart of accounts, and that if any of these characteristics are different, there will be separate accounts appearing on the single chart of accounts:
  • Account number
  • Account name & qualifier (exact spelling)
  • Account location on chart of accounts (category)
I am going through past years and updating the name and location where possible to create matching accounts across years, however I cannot change the account number. Is there any way for me to overwrite the account number so it matches from year to year? If not, what do I do with the multiple accounts that will be created on the single chart of accounts? How will I ever be able to combine that past activity into one account?

IP: Logged

David
Administrator
posted 07-07-2008 09:45 AM     Click Here to See the Profile for David     Edit/Delete Message
The Account Number does not matter. If accounts from multiple years all have the same spelling and are in the same category, they will become a single account in the 9.0 Chart of Accounts, even if they have different Account Numbers in Navigator 8.2.

Likewise, the order of the accounts within a Category does not matter. The first year you convert (which should normally be the most recent year) will determine the order of accounts in each Category. If other years have the accounts in a different order, each account will still will match up with the account from the first year in the 9.0 Chart of Accounts.

Note that this is different for Categories. If you have a Category with the same name if different years but the position in the Master Chart of Accounts changes, it will become two different Categories (and different accounts will be created in each Category) in 9.0. You probably don't want this to happen. So see How to make sure Categories are consistent? for instructions how to make Categories match across entities.

- David
FNI Technical Support

[This message has been edited by David (edited 07-07-2008).]

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