Skip to main content
Question

uploading vendor payments for 1099s from a prior system

  • 22 January 2024
  • 7 replies
  • 92 views

We implemented Acumatica mid-year and I was told that I could simply upload the information once I gathered the vendor number, name and amount paid in the previous system.  It starts with creating a separate account and designating it to take on balances for 1099s, but I am not finding any instructions on that, does anyone have the steps to do that?

 

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 22, 2024

Hello,

Complete steps can be found in this post answered a few weeks ago:

https://community.acumatica.com/financials-7/mark-vendors-bills-for-1099-20650
  1. Update Vendor Profile to check ON 1099 Vendor.
  2. Open all Bills (Paid, unpaid, … ALL of them for 2023) for the Vendor shown above and add the correct 1099 Box Number to every line where appropriate (expense reimbursements should not need a box #, only revenue paid to the vendor).
  3. If you have a large quantity, the above link includes instructions for mass update.  Box numbers may also be added via import scenario.

 

Laura


  • Freshman I
  • January 22, 2024

I am not finding a link.  I don’t need to change anything we paid in Acumatica, I just need to add the payments from the previous accounting system.  Thanks


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 22, 2024

Hi,

Payments made in the previous accounting system may be imported with AP Migration Mode turned on, into the AP Bills screen with 2023 dates.  Import AP Bill Lines with original amount and 1099 box # , and import document header showing $0 unpaid Balance.  These migrated documents will not increase the vendor balance and will be included in 2023 1099 figures.

https://community.acumatica.com/financials-7/load-prior-1099-information-17396

Laura


  • Freshman I
  • January 24, 2024

We have tried this in our test environment and they do not show up in any of the 1099 reports.


  • Freshman I
  • January 24, 2024

I have even tried the “Recalculate Vendor Totals” to see if that would update the totals paid, but all Acumatica is reflecting in the 1099 reports are the amounts we paid through Acumatica.


  • Freshman I
  • January 24, 2024

Looks like what is making this work is putting in an expense date on the line of the bill that is in the year for 1099 reporting and then individually recalculating by vendor.  When I recalculate by a vendor type it is missing some.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • March 19, 2024

Hi @jweber were you able to find a solution? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings