Client Write-Up Reports and Their Options

Balance Sheet

• The default title for the Balance Sheet is STATEMENT OF ASSETS, LIABILITIES AND EQUITY. You can override this title is you like.
  
  Setup -> Reporting -> Statement -> Statement Titles -> Statement Title Overrides -> Override Balance Sheet (Tab)
  
  Note: If the fields are blank the system will use the default title.
  
  Note: You can also override the Date that prints on the Balance Sheet with a description (ie: FULL YEAR, etc)
  
  
• Automatic Total Descriptions - You can override some of the heading descriptions by going to.
  
  Setup -> Reporting -> Automatic Total Descriptions
  
  
• Rounding - If you wish to round the dollar figures go to:
  
  Setup -> Reporting -> Statement -> General -> Suppression Tab
  
  There are (3) options:
  
  
  1. None - No rounding
  2. Whole Dollars - Round to the nearest whole dollar (up or down)
  3. Hundreds - Round to the nearest hundred (up or down)
  
  Note: In order for options "2" and "3" to work correctly you need to select an Asset, Liability or Equity adjustment account.
  
  The system will keep a running total of the amount it round off (ie: 50.19 -> .19) and add this figure to the account you specified. This will keep the Balance Sheet in balance.
  
  
• Printing - The Balance Sheet doesn't look the way it should when it prints.
  
  
  1. Locate Setup Errors - Run this option and check the Chart of Accounts section. They may have a setup problem.
     
     
  2. Report Format - Check the Report Format (Tab) on the Chart of Accounts Maintenance Screen. They may have something checked that is causing the problem.
     
     Note: Has one instance where the person had Print Blank Line Before checked on the Assets account. This was causing the Assets heading not to print and added a Total Do Not Print line at the end of the Assets section.
     
  
  
• Partners Capital Accounts - If you want/need to split out the profit/loss per partner on the Balance Sheet and/or Year End. You need to go to the option listed below.
  
  Setup -> Account -> Partners Capital Accounts
  
  
  1. Using Multiple Partner's Capital and Retained Earnings Accounts
     
     This will split the net profit/loss at Year End and post them to the specified accounts.
     
     
  2. Split Net Income on Balance Sheet by Percentage
     
     This option will split the figures on the Balance Sheet.
     
  
  On the grid listed below enter the Retained Earnings account in thee order you want the Partners listed and the percentage for each.
  

Bank Reconciliation Worksheet

• CF (Carry Forward) - These are checks that were not marked as cleared last month. This includes checks that were manually entered into the system to start a set of books.
  
  Transactions -> Bank Reconciliation -> Edit Carry Forwards
  
  
• GL (General Ledger Entries) - These are G/L entries made in the current period. These include deposits and checks
  
  
• PR (Payroll Checks) - These are payroll checks entered in the current period.
  
  
• Duplicate Entries - Are most likely the result of transferring in a group of transactions twice. To check and see if this is the case run:
  
  Reports -> File Listings -> Ledger Transactions -> Journal Reports
  
  This will list the journals in check number order, which is a quick way to see if you really have duplicate entries. (ie: Check 100 shows twice with different Transaction numbers)
  
  If this is the case then run:
  
  Reports -> File Listings -> Ledger Transactions -> List General Ledger Transactions
  
  Look for a group of transactions that repeat (1000-2000 repeat again at 2500-3500) and if so remove them using.
  
  Transactions -> Delete a Group of Transactions -> Enter the range of duplicates (2500-3500) and click OK.

Disclaimer Letters

• Stating with v5.48.02 you can set a Default Disclaimer Letter Folder location. This allows you to store all your letters on a network drive for the workstations to find.
  
  Setup -> System -> Default Data Directory
  
  
• To enter/change a Disclaimer Letter go to:
  
  Setup -> Reporting -> Disclaimer Letter
  
  Enter/Change the letter and save it.
  
  Note: Click on Open to show where you last saved a letter. This may not be the Default Data Directory.
  
  Note: You can save the letter anywhere you want. You just have to remember where you saved it. This is why it's best to save it to the Default Data Directory. It makes it easier to find and backup.
  
  
• To print the letter go to:
  
  Reports -> Financial Reporting -> Disclaimer Letter
  
  The system defaults to looking in the Default Data Directory for the letters. You can change this if need be. But the system will not remember the new location and default back to the Default Data Directory the next time this option is run.
  
  
• Group Reports will remember where you got the letter from. But does not show it anywhere. So if you got the letter from a hard to remember location and deleted the letter or didn't move it to a new computer the system will not print the letter and it may be hard to remember where you got the letter if the first place.
  
  
• If you get the messaged shown below while trying to change Fonts you do not have a valid printer setup under Windows.
  
  There are no fonts installed. Open the Fonts Folder from the Control Panel to install fonts.
  
  
• You need to line up the asterisk ("*") symbol of the various tokens if you are right justifying a column of figures. Otherwise the last figure in the columns will not line up.
  

FICA Wage List

• Reports -> Payroll Reporting -> FICA Wages List
  
  This report lists:
  
  
  1. Employee ID
  2. Employee Name
  3. Wages subject to FICA
     
     Note: If the employee has total wages that exceed the FICA Limit the report will only show the limit figure.
     

General Ledger

• You can change the left margin from the default of 1" or 1440 TWIPS by going to:
  
  Setup -> Reporting -> Statement -> General -> Miscellaneous (Tab)
  
  Enter a figure in TWIPS for the left margin in the field labeled Left Margin for Ledger.
  
  
• Enhanced Print - If checked the following item will print in bold:
  
  
  • Beginning Balance
  • Ending Balance
  • Account Headers
  
  Plus an asterisk ("*") is printed after the Ending Balance.
  
  
• Summarize Payroll Transactions - The system can either summarize payroll transactions or not on the Ledger Reports depending what options listed below are checked.
  
  Note: Summarized transactions will use the account description on the reports (NC Gross, FICA, Net Payroll Checks, etc).
  
  Non summarized transactions will use the employees name as the description.
  
  Setup -> Payroll -> Payroll Setup -> General (Tab)
  
  Summarize Ledger Transaction from Payroll for
  
  
  1. If W2 Gross is checked the system will summarize the payroll transactions.
     
     
  2. If W2 Gross is unchecked the system will summarize the deductions but list each addition separately on the Ledger Reports.
     
     
  3. If Create GL Detail for Entire Paycheck is checked the system will list both additions and deductions separately on the Ledger Reports.
  
  
• Starting with v5.48.01 you can specify a date range when you select the print All Transactions option.
  
  After you select this option a Use Date Range checkbox and date range fields will appear. Enable the checkbox and specify the date range you want. (ie: 2,3,..12 month range)
  
  This allows you print the General Ledger for any period of time you want.
  
  
• The Plenary Form will switch the Reference Number and Transaction Numbers on the report. It will also insert the employee/vendor numbers at the beginning of the Description it the number was used.
  
  Setup -> Reporting -> Statement -> General -> Miscellaneous (Tab)
  
  Note: If it was a Temporary vendor it will put TEMP at the beginning to the description.
  
  
• There are a couple of buttons/Icons located at the bottom on the View Screen that allow you to save the report was either a PDF and/or HTM file.
  

Income Statement

• The default title for the Income Statement is STATEMENT OF REVENUE AND EXPENSES. You can override this title is you like.
  
  Setup -> Reporting -> Statement -> Statement Titles -> Statement Title Overrides -> Override Income Statement (Tab)
  
  Note: If the fields are blank the system will use the default title.
  
  Note: You can also override the Date that prints on the Income Statement with a description (ie: FULL YEAR, etc)
  
  
• The 5 Year Comparative will only show 5 years if you have 5 years worth of data for the client. Otherwise it will only show 2 years. This year and last year.
  
  The program looks at the following 3 things.
  
  
  • Initial Balance Date - It must be at least 5 years from the Current Reporting Period.
    
    
  • Current Reporting Period - When you roll into a new period the system checks to see if you have 5 years worth of data. If so it will store yearly figures for years 3,4 and 5. If not, it will ignore posting these figures.
    
    
  • Fiscal Years - You must have at least 5 years defined.
  
  
• Rounding Dollar Amounts - If you wish to round the dollar figures go to:
  
  Setup -> Reporting -> Statement -> General -> Suppression Tab
  
  There are (3) options:
  
  
  1. None - No rounding
  2. Whole Dollars - Round to the nearest whole dollar (up or down)
  3. Hundreds - Round to the nearest hundred (up or down)
  
  Note: Since the adjustment account needs to be an Asset, Liability or Equity account. The Income Sheet doesn't use this account. It will just round off the figures.
  
  
• Rounding Percentages - You can select the number of decimal places the percentage shows:
  
  Setup -> Reporting -> Statement -> General -> Miscellaneous Tab
  
  There are (3) options:
  
  
  1. 0 - Round to the nearest whole figure (up or down)
  2. 1 - Show 1 decimal place
  3. 2 - Show 2 decimal places
  
  

Laser 941

• If you want to print a Third Party Designee on the 941.
  
  
  1. Reporting -> Payroll Reporting -> Laser 941
  2. Enable the Use Designee checkbox in the IRS Designee section of the first screen.
  3. Fill in the Designee's Name, Phone Number and PIN Number if desired.
  
  
• Nothing will print on the Laser 941 line 17 - Monthly summary of Federal Tax Liability if the amount for line 13 - Net Taxes Due is less then $2,500.
  
  Note: The system will show any amounts due by month on the screen. Even if they total up to less then $2,500. So its possible to have figures showing up on the screen but not printing out.
  
  Note: The monthly figures shown on line 17 should add up to figure shown on line 13.
  
  
• Unless you select Produce Schedule B off the Choices (Tab), nothing will print in the total fields on the Schedule B (Tab).
  
  

Payroll Summary

• To run the report for an entire year
  
  
  • Change the Stare Date to the beginning of the year.
  • Change the 1st Day of Quarter to the 1st Day of the Year
  
  
• Print FICA, Medicare in Separate Columns - This option allows you print FICA and Medicare figures in separate columns.
  
  Note: This option will only print figures if the employee(s) was setup with both FICA and Medicare Payroll Items. If the employee(s) was setup with only the FICAMD Payroll Item then you will get zeros in the columns. As the system will not figure the amounts.
  

Print G/L Transactions (File Listing)

• Posting Summary - Shows the total debits and credits posted to each account for the period.
  

Print Payroll Transactions (File Listing)

• Print FICA, Medicare in Separate Columns - This option allows you print FICA and Medicare figures in separate columns.
  
  Note: This option will only print figures if the employee(s) was setup with both FICA and Medicare Payroll Items. If the employee(s) was setup with only the FICAMD Payroll Item then you will get zeros in the columns. As the system will not figure the amounts.
  

Record Taxes Paid

Report Groups

• Starting with v5.48.01 you can copy a Report Group to a new name.
  
  Once you select a Group Report the Copy Group Button and New Group Name Field will appear at the bottom of the screen. Simply type in a new name and click the Copy Group Button.
  
  

Unemployment Reports

• You can select how the system determines the number of employees that worked in the quarter starting with version 5.37.01.
  
  
  • Setup -> Payroll -> Payroll Setup -> Unemployment Page 1 (Tab)
    
    
  • Count Employees for Unempl/941 by:
    
    
    1. Hire/Term Date
    2. Check Dates
    
    Hire/Term Date - The system checks the employee's Hire and Termination date to see if they were employed during the quarter. If they were a valid employee for any month in the quarter they will be added to the appropriate monthly count. Even if they received NO payroll checks for the quarter.
    
    Check Dates - The system checks to see if the employee had any checks written to them that falls within the quarter. The employee is added to the count for any month in which they received a check.