salessupportnewscompanycontact
Back to: Home : Support



  Back to Year End Information

Common 1099 Problems

I accidentally zeroed out the owners' annual statistics before printing the 1099s

Not to worry, this happens more often than you might think. When you start to print owner statements for the first month of a new 1099 reporting year, the software asks a question about 1099s and gives the option to re-set annual statistics totals. At that point in time the 1099s for the year just completed are typically not yet printed and annual statistics should not yet be zeroed out, so answering 'Y' to zero the annual statistics is premature. This problem will require a little manual labor to re-enter, but the software will help you determine what the correct 1099 amounts are. Since 1099 amounts are generated from the annual statistics category called 'INCOME,' that is the only category that needs to be re-entered. Here are the steps:

  1. First, go into Business Setup (H,A from the Application Selection Menu), input your business code, type E to Edit, press Page Down until you come to screen #8. Look at the value in the field called 'Statement month after which to do owner 1099's' (it's four lines up from the bottom). It should either be an 11 or 12. Make a note of the value.
  2. Escape out of the Business Setup area and go to P,R,I. This is the Income/Expense Summary report. We're going to run this report to determine what each owner's INCOME total is for the current year. Choose A for all properties, N to enter a date range, leave the other report parameters at their default values (you may set 'Pause before each summary' to N if you wish) and choose P to print the report. You will be prompted to enter a beginning and ending month. If your value in step a. above is 11, enter 12 as the beginning month and 11 as the ending month. If your value in step a. above is 12, enter 1 as the beginning month and 12 as the ending month. The resultant hard copies will give you the 1099 amount which will need to be re-entered; it will be the value in the INCOME category.
  3. Please do not attempt to re-enter the INCOME totals into the live data, instead we strongly suggest you make a copy of your data onto the local hard drive of one of your PCs and perform the re-entry in the copied data instead. That way you can save the copied data on the local hard drive until you are sure the IRS has accepted the 1099s. Contact First Resort Support if you need assistance making a copy of the data. Once you are in the copied data, go to P,A,S. Answer E to edit and input the first property from your Income/Expense Summary report (note: you will need to know the property code to input into the P,A,S area. Since the Income/Expense Summary report lists the property name but not the property code you may wish to also print the Property List by Rental Type report (P,R,L) to use as a cross-reference since that report includes both the property name and property code). Type E to edit and input the INCOME value from the Income/Expense Summary report into the INCOME field. Press F10. You can scroll through the rest of the properties in this area by typing F to go forward to the next property (it goes in alphanumeric property code order) each time after you press F10 to save an input value.
  4. In the copied data, go into Business Setup (H,A), input your business code, type E to Edit, press Page Down until you come to screen #6. The first line shows two date fields. For the 1099s to print properly the first date field must be set to the final month of your 1099 year. For example, if you identified a value of '12' in Step 1. above, this date field should show 12/31/XX (replace XX with the two-digit abbreviation for the year being concluded). The second date field should show one month later. A third date field which appears on the second line of the screen should show one month later than the second date field. DO NOT ATTEMPT TO MANUALLY CHANGE THE VALUES IN THESE DATE FIELDS WITHOUT CONTACTING First Resort SUPPORT!
  5. Once you have completed the re-entry of the INCOME values and established proper dates in Business Setup, you are ready to print 1099s following the standard procedure for that task.

I forgot to zero out last year's annual statistics after printing 1099s and now I don't have the option to zero them out any longer

This is a somewhat common occurrence too - since printing 1099s and zeroing out annual statistics only occur once a year it's not unusual to make a mistake. The solution is a little more involved than in #1 above, but as in #1 the software will help you determine the values needed to make corrections. At this point in time your current owner statement month is most likely the second month of the new 1099 reporting year (the solution is the same even if you are farther into the new 1099 year). Check to see what your current statement month is by going to P,E from the Application Selection Menu. If it shows two months, consider the oldest month to be the current statement month. The solution involves replacing the current annual statistics - which include totals from the prior 1099 reporting year - with statistics for just the new 1099 reporting year. Here are the steps:

  1. Annual statistics records in the software include both dollar amounts and unit occupancy nights. It is important to re-set both types of values during this process. The best report to use to obtain the correct current-year-to-date numbers for both of these types of values is the owner statement with display settings enabled to show both annual statistics and occupancy statistics.
  2. Go into Business Setup (H,A), input your business code, type E to Edit, press Page Down until you come to screen #7. Look at the value in the field called 'PM Stats on Statement Code' (it's in the upper right corner). Make a note of the value, then change it if necessary to show 'A.'
  3. Press Page Down one more time to go to screen #8. Look at the value in the field called 'Statement month after which to do owner 1099's' (it's four lines up from the bottom). It should either be an 11 or 12. Make a note of the value.
  4. Press Page Down one more time to go to screen #9. Look at the value in the field called 'Show occupancy nights on statements (about halfway down). Make a note of the value, then change it if necessary to show 'Y.'
  5. Save any changes by continuing to press the Page Down key until you see the message 'All required files are on disk.' Press Enter, then Y to save the changes.
  6. Go into owner statement printing (P,S,S). If you see a message 'Only past statements may be printed until you advance the statement month' select 'A' to print all statements and press F10. If you do not see the message, enter 'S' to select another month or months then 'A' to print all statements and press F10.
  7. Press F10 through the comments screen to get to the 'Select range of months' screen.
  8. Input beginning and ending months based on the value you identified on screen #8 in step 3. above and your current owner statement month as described in the introduction above. Make the beginning month one month later than the value in screen #8. Make the ending month one month earlier than your current owner statement month. For example, if screen #8 shows a 12 and your current owner statement month is February, 2002 you would make the beginning month '01/02' and the ending month '01/02.' In 'Base for YTD Stats' enter the same value as the beginning month.
  9. The resulting owner statements will provide the information you need to establish correct current year-to-date statistics and occupancy nights totals.
  10. Go to P,A,S. Answer E to edit and input the first property from your owner statement run (note: you will need to know the property code to in put into the P,A,S area. Since the Owner Statements list the property name but not the property code you may wish to also print the Property List by Rental Type report (P,R,L) to use as a cross-reference since that report includes both the property name and property code). Type E to edit and input the annual statistics and occupancy night values from the summary section of the Owner Statement, then press F10 when finished. Note: your input values should generally be much smaller amounts than existing values.
  11. Type F to go forward to the next property and repeat step j. Continue the process until all properties have been updated.
  12. That's it - you're done!

I need to produce 2 50-50 1099s for a unit, although it is currently set up with 1 100% owner

Sometimes unit owners want their 1099 form split with a second person (we'll use the term 'silent partner') although day-to-day they act as the sole owner and receive 100% of monthly revenue checks. Here's the best way to handle this:

  1. Go to P,A,P from the Application Selection Menu and add a new, fictitious property code for the silent partner. This code will not be used for reservations, so it only needs a bare-bones setup. Use the property name/address fields to describe the reason for adding this property. Give it a standard management type such as ST, then just press F10 and Y to save.
  2. Go to P,A,O and access the owner record for the new property code you just input in step 1. Input the name, address, and Tax ID # for the silent partner. Locate the 1099 Override fields. Set the first field to '%' and the second field to '50.00.' Press F10 and Y to save.
  3. While still in P,A,O access the owner record for the real property code whose totals you are splitting. Set the 1099 Override fields to match the settings in step b., i.e. put a '%' in the first field and '50.00' in the second field.
  4. Go to P,A,S; type E to edit; and access the record for the real property code. Make a note of the value in the INCOME field. Type Y to save and access the record for the fictitious property code. Input the same value in the INCOME field that you saw on the real property code's record.
  5. Print 1099s, verifying the proper split for this unit.
  6. Go to P,A,P and delete the property code for the silent partner. Make a note of the existence of this property code for next year's use when it can be recalled and used again to split the 1099 amount if necessary.
  7. Remove the '%' and '50.00' from the P,A,O screen for the real property owner unless you are certain future 1099s will need to be split 50-50.

 

 
To make comments or report problems with this site, please contact webmaster@firstres.com.

firstres.com is published by First Resort - An Instant Software Company
155 South Side Drive, Suite 1 | Basalt, CO 81621 | Ph: 800.872.3771
Copyright 2002. All Rights Reserved.

SALES | SUPPORT | NEWS & EVENTS | NEWSLETTER | JOBS | COMPANY