Skip to main content

Office of Finance

Three Simple Steps to Make Oracle ERP Cloud Ready for 1099 Season

aws glue cloud ssl connect

It’s 1099 season – is your ERP ready?

It only takes a few simple steps to verify your data and make sure you are fully prepared to meet the IRS deadline to publish your 1099’s.

Step 1:

Validate that your “Reporting Entities” are setup, and that they have assigned “Balancing Segments”.   A reporting entity contains the federal reporting number.  It will logically group your 1099’s by paying company from the payables invoices lines.

Step 2:

Validate that your 1099 Suppliers contain one “site” flagged as a “tax site”, that it has a “Tax Type” assigned, such as “MISC7”, a country code, and a Tax ID number on the Supplier Profile page.  If there is a “Tax Reporting Name” that is different from the Supplier Name (such as a DBA), verify it is populated with the correct data.

 

Step 3:

Create and Pay invoices.  Validate that the line items on the invoice contain “MISC7”.  To validate these invoices will be picked up on a 1099, run the report: US 1099 Payment Report.  To determine why something is missing, you can run the following helpful reports:

  • US 1099 Invoice Exceptions Report
  • US 1099 Supplier Exceptions Report

 

If you have already created invoices BEFORE your supplier settings were updated, you can run the process “Update Income Tax Details”, which will retroactively populate tax data on your invoices based on the new supplier information.

For more useful tips and tricks, contact Perficient today, respond to this blog, or email matt.makowsky@perficient.com for a free 1 hour consultation.

#oraclecloud

#oracleerp

#1099

#oraclefinancials

#oraclesupport

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Matt Makowsky

Matthew is the managing director of Perficient's Oracle ERP practice. He has 19 years of experience in Oracle Financial Applications which include 5 large-scale, global, full cycle implementations across multiple industries and multiple countries across Europe and Latin America, plus upgrades across many release of Oracle EBS.  Matthew has extensive application experience in General Ledger, Accounts Payable, Accounts Receivable, and Fixed Assets.  In addition he has managed implementations ranging from 2-3 people to as many as 100 people.  Matthew is personable, and has both excellent written and verbal communication skills.  Matthew has experience conducting workshops– both formal and informal and is charged with driving design sessions.   Matthew’s application experience extends into supply chain modules including purchasing, order management, and inventory, and with that he is able to guide our clients through month end and financial reporting, seamlessly, end to end.

More from this Author

Follow Us