7 digit G/L account codes?

I'll give your results. It's alive!

Reply to
Allan Martin
Loading thread data ...

Point well taken - Yes, you can use up to, but not more than, seven digits for G/L accounts.

Reply to
Burt

"Allan Martin" wrote in message news:F88gi.1$ snipped-for-privacy@newsfe12.lga...

Thank you for the explanation. Obviously, I am not an accountant, but I have had more than 40 years of business experience and have some working knowledge with various accounting software programs. The non-profit I volunteer for has been using proprietary software for data management and receivables, and they have been entering the income totals into MAS90, which they use for G/L, payables, and fund investments. The proprietary software is used to generate a variety of detailed reports that cover individual location income, and MAS90 generates reports combining income, expense, and investment status. I am aware of the 9 digit MAS90 G/L numbering system. It breaks into 4-3-2, with each segment capable of various sorts for reporting. MAS 90 is much more powerful than is necessary for the non-profit and is much more costly to maintain than QBP. The non-profit has recently purchased new proprietary software that will coordinate with and transfer data to QBP. The bookkeeper for the organization is reluctant to give up MAS90 and we are slowly pressing him to move to QBP. I looked over his 17 pages (at aboutt 60 lines per page) of G/L accounts and found that about 20% are inactive items that do not have to be reentered in QB, all of the accounts that would flow from the proprietary software are four digits in the first set followed by 000 in the second set, and have the two digits of the third set used only for location ID's, something that can be handled well by QB classes. This leaves about 300 line items that involve investments in half a dozen endowment accounts that would have to be renumbered to fit QB's numbering system. That's the long story. I am convinced that the accounts that are using the first four digits for account numbers and the last two for location could be managed with four digit G/L numbers plus class designations for location, and that the investment accounts could be renumbered to do the same. The bookkeeper is so reluctant to change, however, that I was looking for the max number of digits to help him get over his inertia regarding the change to QB.

Reply to
Burt

Agreed, migrating from one of the leading mid-range products to the leading low-end product can be difficult to swallow. I am assuming that you are taking about a current version of MAS90. I feel for the bookkeeper.

Reply to
Allan Martin

Ya mean he documentation is right?!! Why will wonders never cease.

Reply to
Golden California Girls

You would need to know the bookkeeper to realize that he makes every task more difficult than it has to be. For years he had been entering receipts in our proprietary A/R software, and he also entered the same data in excel spreadsheets. We finally convinced him that this double entry of data was simply a waste of time. Instead of using a simple data export utility to output client data for use in a mailmerge with MS Word, he had one of our secretaries re-imput client data into a spreadsheet for the mailmerge. I think his middle name is redundancy! His use of MAS90 for this organization is totally overkill.

The CPA (a board member of the non-profit) who oversees his work for us has many clients with much more complex businesses who use QB, and he is in favor of our dropping MAS90 and using QB. Our new proprietary software will do all the receivables, billing and income reporting. QB will essentially be used for payables and record keeping for investment of endowment funds. The proprietary software will transfer the receivable and income data to QB so that P&Ls and G/L reports can be run. It isn't rocket science, and QB can certainly handle it well. It simply requires a revision of some of the G/L numbers and setting up subaccounts and classes to do what had been done with the nine digit G/L numbers, the separate segments of which would be used to identify data for separate location reports. Not a task anyone wishes to perform, but one that will do everything we need and save us the annual upgrades and support costs of several modules of MAS90. Because data can be digitally transfered from the database and A/R proprietary software to QB it will obviate the necessity for the bookkeeper to manually transfer data to the G/L program as he does now for MAS90.

Yes, we continually upgrade as the company will not support older versions of MAS90, so we have the most recent versions of each module. BTW, we outsource our payroll and only do ledger entries of payroll/payroll tax totals that are necessary to generate our P&L's for the overall organization and separately for the individual locations.

Reply to
Burt

You've got to understand that a bookkeeper (or CPA) is just as happy adding up the numbers for a bankrupt organization as for a profitable one. That's why a bookkeeper (or a lawyer) should be pigeon-holed into a STAFF function, not a LINE authority. That means they make NO decisions. Their job is to implement decisions made by others, with a smile and a "Yes sir, yes sir, three bags full!"

Reply to
HeyBub

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.