Changing Chart of Accounts

Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

I am sure this is not uncommon.  I was asked to submit to the network.

What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to we continue using the current structure and phase in the new process as new campaigns are created?

 

Parents
  • Former Member
    Former Member $organization
    Clean Clean DocumentEmail MicrosoftInternetExplorer4

    Is it possible to do the switch at the beginning of the fiscal year?  That would make some things easier.

     

    We changed account numbers after only a few months of Tessy use.  You can easily change the account numbers in the fund setup by entering the new chart of accounts in the Accounts tab (under References) and then selecting the new account numbers for each fund.  While this would not change any prior transactions, of course, it would affect anything going forward.  You could use the same campaign setup but just tie it to new accounts.

     

    It’s best if you can do it all at once; that is, ideally you change all the account numbers for all your funds over one night.  I think this would be a necessity for ticketing.  Development funds could be done a little more gradually – start with the campaigns that are most active if you can’t make all the changes in a day.

     

    _______________

     

    Julie P. Hamre

    Development Associate

    Strathmore Hall Foundation, Inc.

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    301.581.5136; fax 301.581.5201

    www.strathmore.org

     

    Become a Strathmore Member!

    Support what you love. Members enjoy advance

    ticket purchase, discounts in the Shops at

    Strathmore and Tea Room and access to special events.

     

    Join now at http://www.strathmore.org/support/membership.asp

    or call (301) 581-5135

     

    -----Original Message-----
    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michelle Wohlers
    Sent: Thursday, April 16, 2009 2:48 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Changing Chart of Accounts

     

    Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

    I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

    I am sure this is not uncommon.  I was asked to submit to the network.

    What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to we continue using the current structure and phase in the new process as new campaigns are created?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.

  • Clean Clean DocumentEmail MicrosoftInternetExplorer4
    Thanks for your insights.  We are hoping to coordinate with a fiscal year change, but it may not be possible.  Knowing that we can change the fund account numbers without affecting previous transactions is what I was hoping to hear.  I will share the information with our finance department.
     

    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com


     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Julie Hamre
    Sent: Thursday, April 16, 2009 12:28 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] Changing Chart of Accounts
    Importance: Low

    Is it possible to do the switch at the beginning of the fiscal year?  That would make some things easier.

     

    We changed account numbers after only a few months of Tessy use.  You can easily change the account numbers in the fund setup by entering the new chart of accounts in the Accounts tab (under References) and then selecting the new account numbers for each fund.  While this would not change any prior transactions, of course, it would affect anything going forward.  You could use the same campaign setup but just tie it to new accounts.

     

    It’s best if you can do it all at once; that is, ideally you change all the account numbers for all your funds over one night.  I think this would be a necessity for ticketing.  Development funds could be done a little more gradually – start with the campaigns that are most active if you can’t make all the changes in a day.

     

    _______________

     

    Julie P. Hamre

    Development Associate

    Strathmore Hall Foundation, Inc.

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    301.581.5136; fax 301.581.5201

    www.strathmore.org

     

    Become a Strathmore Member!

    Support what you love. Members enjoy advance

    ticket purchase, discounts in the Shops at

    Strathmore and Tea Room and access to special events.

     

    Join now at http://www.strathmore.org/support/membership.asp

    or call (301) 581-5135

     

    -----Original Message-----
    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michelle Wohlers
    Sent: Thursday, April 16, 2009 2:48 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Changing Chart of Accounts

     

    Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

    I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

    I am sure this is not uncommon.  I was asked to submit to the network.

    What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to continue using the current structure and phase in the new process as new campaigns are created?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.
  • Michelle,

    One logistical point; the GL numbers are assigned at the time of batch posting.  I would therefore recommend at the time of the change you make sure that all batches are posted for the fiscal period.  You can then change the GLs during the day and for the subsequent post the new GL numbers will be reflected. 

    This is fairly easy for operator batches but I would also make sure you are aware of the process for posting the web batch as well as any auto billing processes which may be scheduled; especially because the Auto Billing processes are often scheduled for the start or end of a month. 

    Best,

     

    Anna

     

    Anna E. Wessely

    Manager Asia Pacific/Senior Application Specialist

    Tessitura Network, Inc

    +1 888 643 5778 x 308

    awessely@tessituranetwork.com

    www.tessituranetwork.com

  • Former Member
    Former Member $organization in reply to Anna Wessely (Past Staff Member)
    One more thing to note is that changes to GL numbers for funds, fees and price maps are logged in the table t_gl_account_hist.  When the "Reprint Posting Report" is run, it will use the GL numbers that were in place at the time the original posting was performed and will therefore reflect the numbers sent to Finance originally.
     
    Bob 


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Thursday, April 16, 2009 4:03 PM
    To: Robert Bell
    Subject: Re: [Tessitura Finance Forum] RE: [BULK] RE: Changing Chart of Accounts

    Michelle,

    One logistical point; the GL numbers are assigned at the time of batch posting.  I would therefore recommend at the time of the change you make sure that all batches are posted for the fiscal period.  You can then change the GLs during the day and for the subsequent post the new GL numbers will be reflected. 

    This is fairly easy for operator batches but I would also make sure you are aware of the process for posting the web batch as well as any auto billing processes which may be scheduled; especially because the Auto Billing processes are often scheduled for the start or end of a month. 

    Best,

     

    Anna

     

    Anna E. Wessely

    Manager Asia Pacific/Senior Application Specialist

    Tessitura Network, Inc

    +1 888 643 5778 x 308

    awessely@tessituranetwork.com

    www.tessituranetwork.com

    From: Michelle Wohlers <bounce-michellewohlers2537@tessituranetwork.com>
    Sent: 4/16/2009 2:42:50 PM

    Clean Clean DocumentEmail MicrosoftInternetExplorer4
    Thanks for your insights.  We are hoping to coordinate with a fiscal year change, but it may not be possible.  Knowing that we can change the fund account numbers without affecting previous transactions is what I was hoping to hear.  I will share the information with our finance department.
     

    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com


     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Julie Hamre
    Sent: Thursday, April 16, 2009 12:28 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] Changing Chart of Accounts
    Importance: Low

    Is it possible to do the switch at the beginning of the fiscal year?  That would make some things easier.

     

    We changed account numbers after only a few months of Tessy use.  You can easily change the account numbers in the fund setup by entering the new chart of accounts in the Accounts tab (under References) and then selecting the new account numbers for each fund.  While this would not change any prior transactions, of course, it would affect anything going forward.  You could use the same campaign setup but just tie it to new accounts.

     

    It’s best if you can do it all at once; that is, ideally you change all the account numbers for all your funds over one night.  I think this would be a necessity for ticketing.  Development funds could be done a little more gradually – start with the campaigns that are most active if you can’t make all the changes in a day.

     

    _______________

     

    Julie P. Hamre

    Development Associate

    Strathmore Hall Foundation, Inc.

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    301.581.5136; fax 301.581.5201

    www.strathmore.org

     

    Become a Strathmore Member!

    Support what you love. Members enjoy advance

    ticket purchase, discounts in the Shops at

    Strathmore and Tea Room and access to special events.

     

    Join now at http://www.strathmore.org/support/membership.asp

    or call (301) 581-5135

     

    -----Original Message-----
    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michelle Wohlers
    Sent: Thursday, April 16, 2009 2:48 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Changing Chart of Accounts

     

    Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

    I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

    I am sure this is not uncommon.  I was asked to submit to the network.

    What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to continue using the current structure and phase in the new process as new campaigns are created?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.
  • Thanks, so much.  I am certainly glad I asked! 
     
    Love the new network.
    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com

     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Bob Bell
    Sent: Thursday, April 16, 2009 1:53 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] RE: [BULK] RE: Changing Chart of Accounts
    Importance: Low

    One more thing to note is that changes to GL numbers for funds, fees and price maps are logged in the table t_gl_account_hist.  When the "Reprint Posting Report" is run, it will use the GL numbers that were in place at the time the original posting was performed and will therefore reflect the numbers sent to Finance originally.
     
    Bob 


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Thursday, April 16, 2009 4:03 PM
    To: Robert Bell
    Subject: Re: [Tessitura Finance Forum] RE: [BULK] RE: Changing Chart of Accounts

    Michelle,

    One logistical point; the GL numbers are assigned at the time of batch posting.  I would therefore recommend at the time of the change you make sure that all batches are posted for the fiscal period.  You can then change the GLs during the day and for the subsequent post the new GL numbers will be reflected. 

    This is fairly easy for operator batches but I would also make sure you are aware of the process for posting the web batch as well as any auto billing processes which may be scheduled; especially because the Auto Billing processes are often scheduled for the start or end of a month. 

    Best,

     

    Anna

     

    Anna E. Wessely

    Manager Asia Pacific/Senior Application Specialist

    Tessitura Network, Inc

    +1 888 643 5778 x 308

    awessely@tessituranetwork.com

    www.tessituranetwork.com

    From: Michelle Wohlers <bounce-michellewohlers2537@tessituranetwork.com>
    Sent: 4/16/2009 2:42:50 PM

    Clean Clean DocumentEmail MicrosoftInternetExplorer4
    Thanks for your insights.  We are hoping to coordinate with a fiscal year change, but it may not be possible.  Knowing that we can change the fund account numbers without affecting previous transactions is what I was hoping to hear.  I will share the information with our finance department.
     

    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com


     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Julie Hamre
    Sent: Thursday, April 16, 2009 12:28 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] Changing Chart of Accounts
    Importance: Low

    Is it possible to do the switch at the beginning of the fiscal year?  That would make some things easier.

     

    We changed account numbers after only a few months of Tessy use.  You can easily change the account numbers in the fund setup by entering the new chart of accounts in the Accounts tab (under References) and then selecting the new account numbers for each fund.  While this would not change any prior transactions, of course, it would affect anything going forward.  You could use the same campaign setup but just tie it to new accounts.

     

    It’s best if you can do it all at once; that is, ideally you change all the account numbers for all your funds over one night.  I think this would be a necessity for ticketing.  Development funds could be done a little more gradually – start with the campaigns that are most active if you can’t make all the changes in a day.

     

    _______________

     

    Julie P. Hamre

    Development Associate

    Strathmore Hall Foundation, Inc.

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    301.581.5136; fax 301.581.5201

    www.strathmore.org

     

    Become a Strathmore Member!

    Support what you love. Members enjoy advance

    ticket purchase, discounts in the Shops at

    Strathmore and Tea Room and access to special events.

     

    Join now at http://www.strathmore.org/support/membership.asp

    or call (301) 581-5135

     

    -----Original Message-----
    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michelle Wohlers
    Sent: Thursday, April 16, 2009 2:48 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Changing Chart of Accounts

     

    Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

    I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

    I am sure this is not uncommon.  I was asked to submit to the network.

    What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to continue using the current structure and phase in the new process as new campaigns are created?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.
Reply
  • Thanks, so much.  I am certainly glad I asked! 
     
    Love the new network.
    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com

     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Bob Bell
    Sent: Thursday, April 16, 2009 1:53 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] RE: [BULK] RE: Changing Chart of Accounts
    Importance: Low

    One more thing to note is that changes to GL numbers for funds, fees and price maps are logged in the table t_gl_account_hist.  When the "Reprint Posting Report" is run, it will use the GL numbers that were in place at the time the original posting was performed and will therefore reflect the numbers sent to Finance originally.
     
    Bob 


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Thursday, April 16, 2009 4:03 PM
    To: Robert Bell
    Subject: Re: [Tessitura Finance Forum] RE: [BULK] RE: Changing Chart of Accounts

    Michelle,

    One logistical point; the GL numbers are assigned at the time of batch posting.  I would therefore recommend at the time of the change you make sure that all batches are posted for the fiscal period.  You can then change the GLs during the day and for the subsequent post the new GL numbers will be reflected. 

    This is fairly easy for operator batches but I would also make sure you are aware of the process for posting the web batch as well as any auto billing processes which may be scheduled; especially because the Auto Billing processes are often scheduled for the start or end of a month. 

    Best,

     

    Anna

     

    Anna E. Wessely

    Manager Asia Pacific/Senior Application Specialist

    Tessitura Network, Inc

    +1 888 643 5778 x 308

    awessely@tessituranetwork.com

    www.tessituranetwork.com

    From: Michelle Wohlers <bounce-michellewohlers2537@tessituranetwork.com>
    Sent: 4/16/2009 2:42:50 PM

    Clean Clean DocumentEmail MicrosoftInternetExplorer4
    Thanks for your insights.  We are hoping to coordinate with a fiscal year change, but it may not be possible.  Knowing that we can change the fund account numbers without affecting previous transactions is what I was hoping to hear.  I will share the information with our finance department.
     

    Michelle Wohlers
    Tessitura Operations Lead/
    Development Office Manager
    San Diego Symphony
    1245 Seventh Avenue
    San Diego, CA 92101
    619.615.3903
    619.615.7002 Fax
    www.sandiegosymphony.com


     


    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Julie Hamre
    Sent: Thursday, April 16, 2009 12:28 PM
    To: Michelle Wohlers
    Subject: [BULK] RE: [Tessitura Finance Forum] Changing Chart of Accounts
    Importance: Low

    Is it possible to do the switch at the beginning of the fiscal year?  That would make some things easier.

     

    We changed account numbers after only a few months of Tessy use.  You can easily change the account numbers in the fund setup by entering the new chart of accounts in the Accounts tab (under References) and then selecting the new account numbers for each fund.  While this would not change any prior transactions, of course, it would affect anything going forward.  You could use the same campaign setup but just tie it to new accounts.

     

    It’s best if you can do it all at once; that is, ideally you change all the account numbers for all your funds over one night.  I think this would be a necessity for ticketing.  Development funds could be done a little more gradually – start with the campaigns that are most active if you can’t make all the changes in a day.

     

    _______________

     

    Julie P. Hamre

    Development Associate

    Strathmore Hall Foundation, Inc.

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    301.581.5136; fax 301.581.5201

    www.strathmore.org

     

    Become a Strathmore Member!

    Support what you love. Members enjoy advance

    ticket purchase, discounts in the Shops at

    Strathmore and Tea Room and access to special events.

     

    Join now at http://www.strathmore.org/support/membership.asp

    or call (301) 581-5135

     

    -----Original Message-----
    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michelle Wohlers
    Sent: Thursday, April 16, 2009 2:48 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Changing Chart of Accounts

     

    Our Finance Dept will soon be converting to a new software program and in the process we will taking a look at the current chart of accounts.  We have already been told to expect a major overhaul.

    I am less concerned about the time involved in re creating the process and more concerned about how these changes will affect the ongoing/previous practices within the database itself.

    I am sure this is not uncommon.  I was asked to submit to the network.

    What would happen in Tessitura if a gl number was changed mid year for funds already associated with campaigns or for payment methods currently created/used?  Does it make sense to continue using the current structure and phase in the new process as new campaigns are created?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums.
Children
No Data