[BCB:5:Third-party support:ECB] Considerations Review the following considerations to determine which reporting option you need to use below. - Is your 1099 year correct and up to date?
- Do you want to print 1099s for the current year or last year? This depends on your current Accounts Payable 1099 year ending date.
- Do you need to print one 1099 for each vendor in the data folder? Or do you need to print one for each vendor by General Ledger fiscal entity? If you don't know if you need to print 1099s by entity, contact your accountant for assistance.
- If you use the cash basis accounting method, don’t use the following reports. Instead use the Paid Invoices or Paid Invoices by Property report. For the accrual basis accounting method, use the table below to determine the report design that you need.
Printing by fiscal entity If you want to print 1099s for different fiscal entities, determine which General Ledger prefix corresponds to your fiscal entity level. You can have up to three different General Ledger prefixes in your account format. The fiscal entity level can be any of those prefixes, or at the data folder level. Use the report that matches the fiscal entity level you need to print 1099s for. Don't use the report for the total number of prefixes you have. For example, you have three different General Ledger prefixes. You set the fiscal entity level to the B prefix level. Download and use the "AP 1099 Amt Pd by Prefix AB Recon" report. Other information 1099 amounts don’t include the following: - Taxes paid
- Discounts taken
- Deductions
- Payments made by credit card
- Payments made for distributions marked as "exempt"
Reporting options CAUTION: Don’t add any ranges or conditions when you print any of the 1099 reconciliation reports we've provided. Using ranges or condition on these reports can cause incorrect results. Select an option below based on the time frame and sorting method you need for your report. | 1099 Method And Time Period | Report To Save And Print | | 1099s by vendor (for this year) | AP1099ThisYrAmtPdByVendorReconAPrev1.rpt | | 1099s by Prefix A (for this year) | AP1099AmtPdByPrefixAReconAP.rpt | | 1099s by Prefix AB (for this year) | AP1099AmtPdByPrefixABReconAP.rpt | | 1099s by Prefix ABC (for this year) | AP1099AmtPdByPrefixABCReconAP.rpt | | 1099s by vendor (for last year) | AP1099LastYrAmtPdByVendorReconAPrev1.rpt | | 1099s by Prefix A (for last year) | AP1099LstYrAmtPdByPrefixAReconAP.rpt | | 1099s by Prefix AB (for last year) | AP1099LstYrAmtPdByPrefixABReconAP.rpt | | 1099s by Prefix ABC (for last year) | AP1099LstYrAmtPdByPrefixABCReconAP.rpt | ▼ 1099 amounts by vendor for this year 1099 amounts by vendor for this year Print the AP 1099 This Yr Amt Paid by Vendor Reconciliation report to determine the correct 1099 vendor totals for the current 1099 year. Attachment: AP1099ThisYrAmtPdByVendorReconAPrev1.rpt - Download and save the report design.
- Select the report to print it either from Report Designer or the Accounts Payable Reports menu as appropriate.
- Select AP Master and click OK.
- Don’t select both AP Master and AP Invoice (history) when you print the report. If you’ve moved checks to history for the year to report on, print the report twice. Follow all the steps to print the report and select AP Master in step 3. Then follow all the steps again, but select AP Invoice (history) in step 3. Add the amounts in the Calculated 1099 Amt Paid column together for each vendor. This will help determine the correct 1099 total.
- In the Start date box, type the beginning of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 01/01/2025.
- In the End date box, type the ending of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 12/31/2025.
- Don’t click Ranges or Conditions. Ranging or conditioning these reports can result in incorrect information on the reports.
- Click Print Preview to view the report, or click Start to print the report.
- When you view the report, the This Year 1099 Amount column indicates your current stored 1099 year totals. The Calculated 1099 Amt Paid column indicates the correct 1099 total for each vendor. It bases the totals on the actual transactions for the dates specified.
- If there’s a difference, use the Calculated 1099 Amt Paid column to correct your 1099 totals. Click Print Preview to view the report, or click Start to print the report.
▼ 1099 amounts by vendor for last year 1099 amounts by vendor for last year Print the AP 1099 Last Yr Amt Paid by Vendor Reconciliation report to determine the correct 1099 vendor totals for the prior 1099 year. Attachment: AP1099LastYrAmtPdByVendorReconAPrev1.rpt - Download and save the report design.
-
Select the report to print it either from Report Designer or the Accounts Payable Reports menu as appropriate. -
Select AP Master and click OK. - Don’t select both AP Master and AP Invoice (history) when you print the report. If you’ve moved checks to history for the year to report on, print the report twice. Follow all the steps to print the report and select AP Master in step 3. Then follow all the steps again, but select AP Invoice (history) in step 3. Add the amounts in the Calculated 1099 Amt Paid column together for each vendor. This will help determine the correct 1099 total.
-
In the Start date box, type the beginning of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 01/01/2025. -
In the End date box, type the ending of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 12/31/2025. -
Don’t click Ranges or Conditions. Ranging or conditioning these reports can result in incorrect information on the reports. -
Click Print Preview to view the report, or click Start to print the report. -
When you view the report, the Last Year 1099 Amount column indicates your last year stored 1099 totals. The Calculated 1099 Amt Paid column indicates the correct 1099 total for each vendor. It bases the totals on the actual transactions for the dates specified. -
If there’s a difference, use the Calculated 1099 Amt Paid column to correct your 1099 totals. ▼ 1099 amounts by prefix (current or last year) 1099 amounts by prefix (current or last year) Print any of the 1099 reconciliation reports by prefix. Attachment: AP1099AmtPdByPrefixAReconAP.rpt
Attachment: AP1099AmtPdByPrefixABReconAP.rpt
Attachment: AP1099AmtPdByPrefixABCReconAP.rpt
Attachment: AP1099LstYrAmtPdByPrefixAReconAP.rpt
Attachment: AP1099LstYrAmtPdByPrefixABReconAP.rpt
Attachment: AP1099LstYrAmtPdByPrefixABCReconAP.rpt - Download and save the report design.
- Select the report to print it either from Report Designer or the Accounts Payable Reports menu as appropriate.
- Select AP Master and click OK.
- Don’t select both AP Master and AP Invoice (history) when you print the report. If you’ve moved checks to history for the year to report on, print the report twice. Follow all the steps to print the report and select AP Master in step 3. Then follow all the steps again, but select AP Invoice (history) in step 3. Add the amounts in the Calculated 1099 Amt Paid column together for each vendor. This will help determine the correct 1099 total.
- In the Start Date box, type the beginning of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 01/01/2025.
- In the End Date box, type the ending of the calendar year to verify the 1099 totals for. For example, if you want to verify 1099 totals for 2025, enter 12/31/2025.
- For the following reports, type the description of the requested prefix in the prompt field. Find the description in File, Company Settings, Custom Descriptions, Set Up Sections button, the GL Account field.
- AP1099AmtPdByPrefixABReconAP.rpt
- AP1099AmtPdByPrefixABCReconAP.rpt
- AP1099LstYrAmtPdByPrefixABReconAP.rpt
- AP1099LstYrAmtPdByPrefixABCReconAP.rpt
- Don’t click Ranges or Conditions. Ranging or conditioning these reports can result in incorrect information on the reports.
- Click Print Preview to view the report, or click Start to print the report.
- Prefix Total YTD 1099 Amount (X) or Prefix Total Last Year 1099 Amount (X) columns: Indicates your 1099 prefix total in Accounts Payable for the current or previous 1099 year.
- Calculated 1099 Amount Paid (Y) column: Indicates the correct 1099 total for each prefix and vendor. The total is based on the transactions for the dates specified.
- If there’s a difference, use the Calculated 1099 Amount Paid (Y) column to correct your 1099 prefix totals.
Correcting 1099 amounts [BCB:156:Chat 300 CRE US:ECB]
|