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:
- 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.
- 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.
- 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.
- 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!
- 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:
- 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.
- 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.'
- 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.
- 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.'
- 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.
- 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.
- Press F10 through the comments screen to get to
the 'Select range of months' screen.
- 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.
- The resulting owner statements will provide the
information you need to establish correct current
year-to-date statistics and occupancy nights totals.
- 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.
- Type F to go forward to the next property and
repeat step j. Continue the process until all
properties have been updated.
- 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:
- 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.
- 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.
- 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.
- 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.
- Print 1099s, verifying the proper split for this
unit.
- 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.
- 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.
|