Chart of Account

SUGGESTED

Is there a way to increase the number of digits of existing general ledger account numbers from 4 to 6? Like from 2042.000 to 204200.000. (New to Sage BusinessWorks; inherited setup.)

  • 0
    SUGGESTED
    DA-
    Accounts can be up to eight digits to the left of the decimal and a minimum of 3 digits to the right of the decimal. If you are looking to renumber existing accounts, see Knowledge Base article #19016 How do I renumber a General Ledger account.
    Thanks,
    Coleen
  • 0 in reply to Coleen Graber

    Thanks Coleen.  I am actually planning my GL mapping now and wanted to see how many hierarchal levels can be created.  Mike

  • 0 in reply to Mike Cecco
    SUGGESTED

    Mike-

    BusinessWorks accounts numbers only have 2 levels – main accounts and departments. As mentioned above, General Ledger account numbers can be 8 digits to the left of the decimal and 3 digits to the right of the decimal. The 3 digits to the right are for departmental accounts, of which you can have up to 999 departments (hence the 3 digits). For reporting purposes, you can group accounts together by making Subtotal and/or Consolidated accounts.

    Note:  Some customers may prefer to create a copy or backup of their company data, prior to changing their Chart of Accounts, to assure they are getting the results they desire. 

    I have included a Knowledge Base article on creating a copy company, as well as some articles relating to the Chart of Accounts that you may want to review.  To get to our Knowledge Base go to www.sagekb.com.  From there you can search on any of the titles below:

    • How to add or edit an account in General Ledger (26197)
    • How to set up subtotal accounts in General Ledger (45239)
    • How to set up consolidation account (59287)
    • How to resolve overlapping ranges in chart of accounts (31441)
    • How to set up departments and departmental accounts in General Ledger (18763)
    • How to change the Account Type or Account Class of a general ledger account number (26673)
    • How do I renumber a General Ledger account (19016)
    • How to create an archive or copy of a company (17616)

     

    Sincerely,

    Coleen

  • 0 in reply to Coleen Graber

    Hi Coleen,

    I probably did not describe what I am trying to do.  My goal is to rollup as follows:

    Assets

       Current Assets

            Cash

                 Checking 

                      Chase Bank 

                       Nevada State Bank

    The two banks would receive data input and then would both roll up into no-input checking...and non input checking would rollup into Cash...and non input Cash would rollup into Current Assets; then all current assets would rollup into Assets.  I am hoping that type of aggregation is possible with BusinessWorks.  If not, please direct me to another Sage product that can aggregate like that.  Thanks, Coleen.

    Mike

  • 0 in reply to Mike Cecco
    SUGGESTED

    Mike- I would recommend working with our sales team to discuss what other Sage product may handle the accounting numbering you are needing for your company.  You can reach the Sales team by calling 1-800-447-5700.  Sincerely, Coleen