Difference between revisions of "AP: Year End"
Jump to navigation
Jump to search
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<!-- | <!-- | ||
| − | <span style="color:#FFFFFF; background:#FF0000; font-size:30">Preliminary Notes for | + | <span style="color:#FFFFFF; background:#FF0000; font-size:30">Preliminary Notes for 2023 y/e</span> |
--> | --> | ||
| − | = | + | =2023 Year End= |
| − | + | <p>UPDATED 12/15/2023</p> | |
| − | <p>UPDATED 12/ | ||
| − | |||
| − | Keystone provides the ability to print | + | Keystone provides the ability to print 1099-DIV, 1099-INT, 1099-MISC and 1099-NEC forms using the Web Services Process. |
| − | + | This process is performed via our 3rd party partner Nelco. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
See: [https://givenhansco.nelcoportal.com/Content/Filing_Information Web Services Pricing Information] | See: [https://givenhansco.nelcoportal.com/Content/Filing_Information Web Services Pricing Information] | ||
| − | |||
=Year end processing= | =Year end processing= | ||
| − | |||
===Setup Periods for the new year=== | ===Setup Periods for the new year=== | ||
| − | [[File:APSetPdsNewYr.PNG | + | [[File:APSetPdsNewYr.PNG]] |
#Select “Setup Periods” from the Accounts Payable Month End menu. | #Select “Setup Periods” from the Accounts Payable Month End menu. | ||
| − | #Enter | + | #Enter “2023” in the Year box and hit “tab” |
#Follow the prompts to fill in the 12 calendar months automatically. | #Follow the prompts to fill in the 12 calendar months automatically. | ||
#Click OK or press F2 when done. | #Click OK or press F2 when done. | ||
| Line 38: | Line 22: | ||
===Close Old Year (also see [[Setup Periods]])=== | ===Close Old Year (also see [[Setup Periods]])=== | ||
| − | [[File:APSetPdsOldYr.PNG | + | [[File:APSetPdsOldYr.PNG]] |
#Select “Setup Periods” from the Accounts Payable Month End menu.<br> | #Select “Setup Periods” from the Accounts Payable Month End menu.<br> | ||
| − | #Enter | + | #Enter “2023” in the Year box and hit “tab”<br> |
#Mark the Status “C” for Closed | #Mark the Status “C” for Closed | ||
<br clear=all> | <br clear=all> | ||
===Run Year End Processing=== | ===Run Year End Processing=== | ||
| − | [[File:APYrEnd.PNG|APYrEnd.PNG | + | [[File:APYrEnd.PNG|APYrEnd.PNG]] |
#Open Month/Year End Processing from the Month/Year End menu of Accounts Payable | #Open Month/Year End Processing from the Month/Year End menu of Accounts Payable | ||
#Enter Month and Year | #Enter Month and Year | ||
| Line 57: | Line 41: | ||
==Preparation== | ==Preparation== | ||
| − | ===Set up 1099 States | + | ===Set up 1099 States === |
| − | [[1099 State Code Maintenance]] | + | [[1099 State Code Maintenance]] is used when... |
*State 1099s are required | *State 1099s are required | ||
*Federal 1099s with multiple boxes are used. (NOTE: This code is automatically created by Keystone) | *Federal 1099s with multiple boxes are used. (NOTE: This code is automatically created by Keystone) | ||
| Line 69: | Line 53: | ||
===Set Tax Information for Vendors=== | ===Set Tax Information for Vendors=== | ||
Review vendors using [[AP Vendor Maintenance]]. | Review vendors using [[AP Vendor Maintenance]]. | ||
| − | :* | + | :*Verify the Name. Set '''1099 Name''' to the official name for tax reporting to handle dba vendors - Only if needed. |
:On the new Taxes Tab... | :On the new Taxes Tab... | ||
:*Verify 1099 Classes are setup properly. If necessary setup new 1099 classes in [[Accounts Payable 1099 Class Maintenance|1099 Class Maintenance]] | :*Verify 1099 Classes are setup properly. If necessary setup new 1099 classes in [[Accounts Payable 1099 Class Maintenance|1099 Class Maintenance]] | ||
:*Verify '''Tax ID No.''' | :*Verify '''Tax ID No.''' | ||
| − | :*Set the '''Type of TIN''' | + | :*Set the '''Type of TIN''' Required if you are using Web Services. |
| − | :*Set the '''Tax ID Type''' | + | :*Set the '''Tax ID Type'''. This is used for W9 and not for 1099s. |
| + | :*Set '''Account No.''' | ||
:*Use [[AP Vendor Maintenance]] to setup the 1099 address where needed. (Only use this when the 1099 address is different than the standard address. These fields hold larger values than the standard address.) | :*Use [[AP Vendor Maintenance]] to setup the 1099 address where needed. (Only use this when the 1099 address is different than the standard address. These fields hold larger values than the standard address.) | ||
| − | ===Adjust 1099 Amounts for Vendors | + | ===Adjust 1099 Amounts for Vendors === |
| − | + | Both state and multi-box federal amounts are configured on the new "1099 Amounts" tab in [[AP Vendor Maintenance]]. Skip this section if you want to rely on traditional 1099 method of reporting the Previous Year, Current Year or Transaction Amounts from the main Vendor record. | |
| − | Both state and multi-box federal amounts are configured on the new "1099 Amounts" tab in [[AP Vendor Maintenance]]. Skip this section if | ||
====State Amounts==== | ====State Amounts==== | ||
| − | Make sure 1099 States are configured (from | + | Make sure 1099 States are configured (from A/P File Maintenance menu). |
On the 1099 Amounts tab, for each state and 1099 Class that apply to the vendor enter the: | On the 1099 Amounts tab, for each state and 1099 Class that apply to the vendor enter the: | ||
| Line 97: | Line 81: | ||
When entering amounts on the tab for Federal use "00" as the State ID. Add one line for each box with the appropriate 1099 class and amounts. | When entering amounts on the tab for Federal use "00" as the State ID. Add one line for each box with the appropriate 1099 class and amounts. | ||
| + | |||
[[File:APVen1099Amts.PNG]] | [[File:APVen1099Amts.PNG]] | ||
| − | '''NOTES:''' | + | '''NOTES:''' |
*Any Federal Amount entered will trigger a 1099 to print even if it's less than the "Minimum Amount for Federal 1099" | *Any Federal Amount entered will trigger a 1099 to print even if it's less than the "Minimum Amount for Federal 1099" | ||
*When Federal Amount is entered for a 1099 class, it will override the "traditional" value for that class (e.g. "Prior Year Summary"). | *When Federal Amount is entered for a 1099 class, it will override the "traditional" value for that class (e.g. "Prior Year Summary"). | ||
*Entering 0 for Federal Amount for a 1099 class will cause that class to be skipped, even if a value exist based on the "traditional" value. | *Entering 0 for Federal Amount for a 1099 class will cause that class to be skipped, even if a value exist based on the "traditional" value. | ||
| + | <!-- | ||
==Steps to Printing 1099s - Traditional Method== | ==Steps to Printing 1099s - Traditional Method== | ||
This is the traditional method of printing your own 1099s. You can use this option when... | This is the traditional method of printing your own 1099s. You can use this option when... | ||
| Line 123: | Line 109: | ||
:'''Previous Year''': This is the most common method. All payments for the year are recorded in the "YTD Payments" field in the Vendor record. When Year End Processing is run these roll into "Last Year Payments". | :'''Previous Year''': This is the most common method. All payments for the year are recorded in the "YTD Payments" field in the Vendor record. When Year End Processing is run these roll into "Last Year Payments". | ||
:'''Current Year''': This will print 1099s from the '''YTD Payments''' field. This only works if you print 1099s right after the year ends and have no new activity. Timing becomes quite tricky. | :'''Current Year''': This will print 1099s from the '''YTD Payments''' field. This only works if you print 1099s right after the year ends and have no new activity. Timing becomes quite tricky. | ||
| − | :'''Transaction Detail''': This takes advantage of the capability in invoice vouchering to record the 1099 class for each transaction with a vendor. For example you could mark just the interest portion of note payments for the 1099-Int. | + | :'''Transaction Detail''': This takes advantage of the capability in invoice vouchering to record the 1099 class for each transaction with a vendor. For example you could mark just the interest portion of note payments for the 1099-Int. This provides way to distinguish activity by state. |
| + | --> | ||
==Processing Web Services 1099s== | ==Processing Web Services 1099s== | ||
| − | + | Use Web Services option for E-Filing, State and Multiple boxes on single 1099 form. Instructions are developing. If you plan to process 1099s with Web Services before all instructions are complete, please contact GivenHansco support. | |
Use must this option if... | Use must this option if... | ||
| Line 137: | Line 124: | ||
#Select Federal & State 1099 Export from the Web Portal Export/Filing menu<br>[[File:APWebEfile.PNG]] | #Select Federal & State 1099 Export from the Web Portal Export/Filing menu<br>[[File:APWebEfile.PNG]] | ||
| − | ##Verify Year is | + | ##Verify Year is 2023 |
##Set Min. Amount for Federal 1099 | ##Set Min. Amount for Federal 1099 | ||
##Select Payments From option | ##Select Payments From option | ||
| Line 151: | Line 138: | ||
#Upload To Web Portal | #Upload To Web Portal | ||
#Web Portal Dashboard | #Web Portal Dashboard | ||
| − | |||
| − | |||
<!-- | <!-- | ||
| Line 158: | Line 143: | ||
--> | --> | ||
| − | =Preparing for | + | =Preparing for 2024= |
*Use [[AP Vendor Maintenance]] to: | *Use [[AP Vendor Maintenance]] to: | ||
:*verify W-9 Tax Types | :*verify W-9 Tax Types | ||
:*verify TIN types. | :*verify TIN types. | ||
| − | :*Set Default 1099 State Code - This will be the default used for 1099 vouchering detail for | + | :*Set Default 1099 State Code - This will be the default used for 1099 vouchering detail for 2024. |
*When using [[Accounts Payable Invoice Vouchering|Invoice Vouchering]] - you may choose to enter the appropriate 1099 Type along with the 1099 state. This will provide data you can use for next year's 1099s. | *When using [[Accounts Payable Invoice Vouchering|Invoice Vouchering]] - you may choose to enter the appropriate 1099 Type along with the 1099 state. This will provide data you can use for next year's 1099s. | ||
*Keep up to date on new rules. Prepare for 1099s going to all corporations. | *Keep up to date on new rules. Prepare for 1099s going to all corporations. | ||
Latest revision as of 15:10, 15 December 2023
2023 Year End
UPDATED 12/15/2023
Keystone provides the ability to print 1099-DIV, 1099-INT, 1099-MISC and 1099-NEC forms using the Web Services Process.
This process is performed via our 3rd party partner Nelco. See: Web Services Pricing Information
Year end processing
Setup Periods for the new year
- Select “Setup Periods” from the Accounts Payable Month End menu.
- Enter “2023” in the Year box and hit “tab”
- Follow the prompts to fill in the 12 calendar months automatically.
- Click OK or press F2 when done.
Close Old Year (also see Setup Periods)
- Select “Setup Periods” from the Accounts Payable Month End menu.
- Enter “2023” in the Year box and hit “tab”
- Mark the Status “C” for Closed
Run Year End Processing
- Open Month/Year End Processing from the Month/Year End menu of Accounts Payable
- Enter Month and Year
- Click OK
- When prompted to backup optionally Click YES to proceed.
Note: Running Year End Processing recalculates Year to Date Purchases and Payments for the new and prior year. If you make transactions into AP after running Year End Processing, run the process again.
Processing 1099s
Preparation
Set up 1099 States
1099 State Code Maintenance is used when...
- State 1099s are required
- Federal 1099s with multiple boxes are used. (NOTE: This code is automatically created by Keystone)
For each state enter...
- Description
- State ID No.
- Sequence - Your home state typically comes first.
Set Tax Information for Vendors
Review vendors using AP Vendor Maintenance.
- Verify the Name. Set 1099 Name to the official name for tax reporting to handle dba vendors - Only if needed.
- On the new Taxes Tab...
- Verify 1099 Classes are setup properly. If necessary setup new 1099 classes in 1099 Class Maintenance
- Verify Tax ID No.
- Set the Type of TIN Required if you are using Web Services.
- Set the Tax ID Type. This is used for W9 and not for 1099s.
- Set Account No.
- Use AP Vendor Maintenance to setup the 1099 address where needed. (Only use this when the 1099 address is different than the standard address. These fields hold larger values than the standard address.)
Adjust 1099 Amounts for Vendors
Both state and multi-box federal amounts are configured on the new "1099 Amounts" tab in AP Vendor Maintenance. Skip this section if you want to rely on traditional 1099 method of reporting the Previous Year, Current Year or Transaction Amounts from the main Vendor record.
State Amounts
Make sure 1099 States are configured (from A/P File Maintenance menu).
On the 1099 Amounts tab, for each state and 1099 Class that apply to the vendor enter the:
- Tax Year
- 1099 Class (e.g. 1099-INT)
- State
- State Income
- State Tax (where applicable)
Federal 1099 Amounts
This is typically used for Federal 1099s with values in multiple boxes. Do not set this up if you want to rely on Previous Year or Current Year balance for the Vendor.
In this case, separate 1099 classes should be already configured to represent each box that could print on a 1099 form.
When entering amounts on the tab for Federal use "00" as the State ID. Add one line for each box with the appropriate 1099 class and amounts.
NOTES:
- Any Federal Amount entered will trigger a 1099 to print even if it's less than the "Minimum Amount for Federal 1099"
- When Federal Amount is entered for a 1099 class, it will override the "traditional" value for that class (e.g. "Prior Year Summary").
- Entering 0 for Federal Amount for a 1099 class will cause that class to be skipped, even if a value exist based on the "traditional" value.
Processing Web Services 1099s
Use Web Services option for E-Filing, State and Multiple boxes on single 1099 form. Instructions are developing. If you plan to process 1099s with Web Services before all instructions are complete, please contact GivenHansco support.
Use must this option if...
- Processing State 1099s
- E-Filing Federal 1099s
- Processing Federal 1099s with multiple boxes on a single form.
- Select Federal & State 1099 Export from the Web Portal Export/Filing menu
- Verify Year is 2023
- Set Min. Amount for Federal 1099
- Select Payments From option
- Setup information on Company Info Tab
- Name/Address City/State/Zip
- Federl ID Number
- Iowa E-File Number
- Payer RTN
- Select Export
- Review report for accuracy
- Continue to Export. NOTE: Select a file location that will be easy to find for the Web Portal Upload.
- Upload To Web Portal
- Web Portal Dashboard
Preparing for 2024
- Use AP Vendor Maintenance to:
- verify W-9 Tax Types
- verify TIN types.
- Set Default 1099 State Code - This will be the default used for 1099 vouchering detail for 2024.
- When using Invoice Vouchering - you may choose to enter the appropriate 1099 Type along with the 1099 state. This will provide data you can use for next year's 1099s.
- Keep up to date on new rules. Prepare for 1099s going to all corporations.
