If you switched to Aplos mid-calendar year without bringing in the full year’s worth of transactions, your 1099s will be incomplete in Aplos. You will need to backfill those vendor transactions to produce a full 1099 for the calendar year. This is a multi-step process and will require a little setup before getting started. Follow the steps below to get started
- Make sure to complete the basic setup steps for 1099s in Aplos.
- Create an asset account in your chart of accounts. Learn how to create an asset account.
- Account Number = whatever you’d like
- Account Name = “1099 Historical Transactions”
- Type = Use as a register
- Activity = Cash
- Once created, go to this account in your register and click “Import” on the righthand side.
- Download the template here, which is what you will use for the historical transactions.
- Fill in this template with all of the missing calendar year transactions for each vendor. Then enter a reversing transaction that uses the same date, account, fund, and amount as what you’ve recorded for each vendor. Be sure to use a different payee name like "1099 reversal" to ensure the vendor contact amount is not also getting zeroed out
Attached at the bottom of this article is the template file with an example of how this should look. You’ll see that Alex was paid $1,000 for a speaking engagement. The line with red text below essentially reverses it but does not use Alex’s name. Using the different vendor will count the expense against the applicable vendor while the reversal adjusts the accounting side without affecting the vendor history. When this is done for all of the transactions, upload this file into the newly created register account from above.
Now you should have a full record of the vendor transactions, with reversals that use a different contact. The net effect on the register should be $0, and each vendor should see all of the transaction history on their 1099.
Related to