Solution Strategists Newsletter The Accounting Software Experts   --   Solutions from the Strategists
Winter 2003
Inside this Issue:
  • New Features in MAS 90/200 Version 3.71
  • Tips and Tricks
  • Steps to Prevent Data Loss
  • Disaster Planning and Recovery
  • New Features in MAS 90/200 Version 3.71

    Tips and Tricks

    Writing Off Bad Debts

    There are two methods to writing off bad debts. The first method is to create a miscellaneous charge code in Accounts Receivable with the account number pointing to your Bad Debt account. Create a negative invoice for the customer and on the lines tab use the Code created for the Bad Debt. You would then apply the negative Bad Debt invoice just created against those you wish to write off using the Cash Receipts Entry and a deposit amount of $0.00. An alternative method is as follows:

    1. Use Accounts Receivable | Main | Cash Receipts Entry.
    2. Enter a bank code, date and deposit number. The deposit amount should be $0.00.
    3. Enter the customer number.
    4. For the check number use "BAD DEBT". The amount received is $0.00.
    5. On the lines tab, select the invoice or invoices to be written off. Enter the amount to be written off in the Amount Posted field, this will usually be the invoice balance.
    6. For the next or final line entry, click in the GL Account box and enter the GL Account number you use for Bad Debt expense. The amount posted should default to the distribution balance or the amount of the invoice(s) being written off.
    7. Print and update the Cash Receipts Journal.
    8. Print and update the Daily Transaction Register.



    Accounting for an NSF Check

    This procedure can be used to record a customer's bounced check. It will make the appropriate postings for the reduction in cash and increase the balance owed on the customer's account and the invoice will be reinstated.

    1. Select Accounts Receivable | Main | Cash Receipts Entry.
    2. Enter the Bank Code, Deposit Date and the Deposit Number. Enter the Deposit Amount as a negative amount for the amount of the NSF Check and select OK.
    3. Select the Customer Number.
    4. Enter the Check Number of the bounced check.
    5. Enter the dollar amount as a negative number.
    6. Use the look-up feature if needed to select the invoice number to be reinstated.
    7. Leave the Discounts Used field blank.
    8. Enter the amount of the invoice as negative and select OK.
    9. Select Accept.
    10. Print and update the Cash Receipts Journal and the Daily Transaction Register.



    Process Payroll Checks in Next Quarter

    There are no future postings in Payroll. However, it is sometimes necessary to prepare payroll checks for a subsequent quarter before the previous quarter has been closed. The following procedure will allow for printing checks in a subsequent quarter prior to closing the previous Payroll Quarter:

    1. Select Payroll | Main | Payroll Data Entry.
    2. Enter the default payroll cycle values to be used.
    3. Be sure to verify that the period-ending date fall in the future quarter.
    4. Continue to process the pay cycle as usual using either the automatic pay feature or individual entries.
    5. Calculate taxes and run all necessary reports.
    6. Print the Payroll checks.
    7. At the point of update, the registers may be printed, but do not update the check registers.
    8. Before this current payroll's check cycle can be updated, the period-end processing for the previous quarter must be completed.
    9. Close the previous quarter, which will allow the system to advance the current payroll processing quarter to the next quarter.
    10. Print the check register again for the cycle processed in steps 2 - 6.
    11. Update the check register for the current processing cycle.

    This process should only be used for the first payroll in the subsequent quarter prior to closing the previous quarter. We also suggest that before performing the above procedure, a back up of the payroll data is performed.



    Reconciling the Inventory to the GL at Month End

    At month end, the Inventory Valuation Report may not match the General Ledger Detail total for the inventory account number.

    • The Inventory Valuation Report is a real-time report. This means that it includes all transactions in Inventory at the time of Printing.
    • General Ledger Detail prints the transactions based on the posting dates.
    • Use the Inventory Trial Balance Report to reconcile the General Ledger Detail total for the Inventory account. This report recognizes the transactions by posting dates (similar to the Accounts Payable and Accounts Receivable Trial Balance Reports).

    Steps to Prevent Data Loss

    In the war against data loss, you can never be too careful. We've all heard the story: It's Friday night and you can't wait for the weekend to start. In your rush to leave, you decide to skip your backup. Monday, you discover that your data is missing! You say to yourself "This isn't happening to me." - But it did! What should you do to avoid situations like this?

    Backup, Backup, Backup! These may not be the three words you want to hear, but they may be the most important. By having a backup policy, you can avoid having to re-enter all your data from scratch, or worse, paying someone to rescue it, sector by sector, from your hard drive. We cannot stress enough that, at the minimum, you should:

    Preventive maintenance is key to avoiding valuable downtime and additional expense. If you need further assistance regarding backup, tape drives or any hardware related issues, contact your Network Integrator. For SSI's recommended 10-tape Backup Routine, give us a call.

    Disaster Planning and Recovery

    What IF. . .? Failing to plan is planning to fail. Keeping your business alive and functioning should be a number one priority! To help, we are listing just a few of many things to be considered. Please take a moment and think about where you would be if a major disaster struck and you didn't have any of these:

    A roster of your disaster team (names, home telephone and cell numbers, e-mails, etc.).
    A description of each team member's responsibilities.
    An employee list (home telephone and cell numbers, addresses, e-mails, etc).
    A current vendor list.
    A current customer list.
    A supply of corporate letterhead, checks, etc.
    Insurance policy inventory.
    Fixed Asset inventory.
    Computer software and hardware inventory.
    A list of software passwords (kept confidential).

    At our May User Group, we will be handing out our 15-page Disaster Recovery plan with instructions. We have presented the Disaster Planning and Recovery seminars to both the New York and New Jersey CPA Societies. Come to the meeting to receive yours.

    A Note from Art

    With Winter's freezing temperatures and snow storms hopefully behind us, we are looking forward to Spring.

    *

    The economy continues to fluctuate, influenced by world events and the threat of terrorism. This challenges all of us to work harder and smarter, and at the same time, to be prepared in the event of a disaster. At our May User Groups, we will devote more time to Tips & Tricks, in addition to discussing disaster planning and recovery. Mark your calendar for May 14 (NJ) and May 15 (NY).

    *

    Our focus is to provide you with timely topics that will make you more efficient. We welcome your comments and suggestions. Until we meet again, happy computing.


    In the Spotlight:
    Trish Proudman

    "My own professional philosophy is exactly the mission statement that Solution Strategists makes - to provide world-class service", said Client Account Manager Trish Proudman, "and is why coming to work here was such a natural transition".

    In her role as Account Manager, Trish Proudman serves as the internal point of contact person and maintains consistent communications with our clients. In addition to providing non-technical support, Trish coordinates our client e-newsletter and organizes events such as user group meetings. As Account Manager, Trish has the opportunity to provide our clients with a world-class service experience.

    Trish's natural disposition is to help others and see others succeed. She feels she has found her home at SSI. In addition to taking care of clients, she enjoys working with a team of professionals who are as committed to client services as she is. "Everyone benefits when you work as a team toward the same goal", said Trish.

    Trish brings more than 20 years of client service experience to SSI. Most recently she was a Customer Relations Representative for an authorized Compaq reseller where she handled returns, customer concerns and vendor relations. She did a tremendous amount of reporting and quality analysis to determine how service could be improved.

    "The most rewarding part of my job is to have helped someone out and know that I made a difference. It is a great feeling when a client says "thank you" because I called to see how they were doing," said Trish.

    In her spare time Trish enjoys spending time with her family, home improvement projects and reading.


    Murphy's Law of Computing

    1. When computing, whatever happens, behave as though you mean it to happen.
    2. When you get to the point where you really understand your computer, it's probably obsolete.
    3. The first place to look for information is in the section of the manual where you least expect to find it.
    4. When the going gets tough, upgrade.
    5. For every action, there is an equal and opposite malfunction.
    6. To err is human - to blame your computer for your mistakes is even more human, it is downright natural.
    7. He who laughs last probably made a back up.
    8. If at first you do not succeed, blame your computer.
    9. A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.
    10. The number one cause of computer problems is computer solutions.
    11. A computer program will always do what you tell it to do, but rarely what you want to do.


    Answers at your Fingertips


    Every so often a user may encounter a repeat of a problem that occurred in the past. Chances are, you have the answer at your fingertips. Did you know that if you placed a support call during a billing period, the Client Detail Copy documenting the support call and its resolution is attached to the back of your invoice? You may want to setup a MAS 90/200 support binder to file this information so you can review prior support call resolutions or to review certain procedures.


    Mark Your Calender


    Our next User Group meetings are scheduled for the mornings of May 14th in NJ and May 15th in NYC.


    Sites of Interest

    Solution Strategists
    VARbase
    30% Tax Write-off
    Virus Alerts
    Product Literature

    Best Software
    AnyWho
    Electronic Accountant
    NJSCPA
    NYSSCPA

    Join our Mailing List




    Solution Strategists LLC
    312 North Avenue East · Suite 7 · Cranford, NJ 07016
    908.276.2270 · fax: 908.272.5404
    e-mail: info@solstrat.com
    website: www.solstrat.com