If you have a lot of transactions or if you are behind in your reconcile, there is a small button in the upper left corner of the reconcile window “Hide transactions after the statement’s end date” that will simplify the work.

When you click this button, it will hide all transaction you don’t need. You can use Reconcile Window tip #1 (see previous tip) to sort to find transaction only in the period you are working in.

You can organize the transaction data by the headers in the reconcile window.

The data is in date order but if you want to sort by earliest to latest, you can click the ‘Date’ header once and it will reverse the order.

Each of the headers can be sorted by clicking it once, and the order can be reversed by clicking it again. Each header will sort smallest to largest or alphabetical depending on the transaction data.

You can email reports directly from QuickBooks. On the top bar of the report, click the email button. You will have two formats to choose from. You can send the report either as an excel or PDF file.

If you have not set up this feature, QuickBooks will prompt you to set up the email you would prefer to send the report from. After you have set up your email, each time you want to send the report it will save your email settings.

QuickBooks Desktop

Please note this update will only be available in these QuickBooks versions: QuickBooks Desktop Pro and Premier 2020, 2019, 2018. QuickBooks Enterprise Solutions 20, 19, 18.

1. Be sure you have run the recent update for Quickbooks
2. There are now 2 places to run the wizard: To map your vendors, go to Vendors, 1099 Forms, Print/EFile 1099 Forms or File, Print Forms, 1099s/1096
3. It may ask you to create a back-up of your file.
4. Go through the wizard separately for NEC and MISC. All the vendors you have designated as eligible to receive 1099’s will be listed. The only difference for 2020 will be to separate the vendors into two filing types the NEC (non-employee compensation) and MISC.
5. After you have gone through both wizards, you can review the reports which are still in the same place as prior year versions. Vendors, 1099 Forms, 1099 Summary Report
6. Please note you will have to toggle between NEC and MISC in the report options section located in the upper right-hand side of the report to see the amounts.
7. After you have verified the amounts and vendor information you will go to the wizard again to run both returns to print the filing copies. This will look and work like prior year versions.

QBO

1. Open your QBO program, on the left sidebar, click Expenses/Expenditures.
2. Far right top click Prepare 1099s.
3. Click continue your 1099s
4. You will see a box of your vendors set to receive a 1099.
5. Bottom left hit the back button.
6. This will open a box to map your 1099’s. There are two to choose from. Starting for 2020 you have the 1099 NEC (non-employee compensation) and 1099 Misc. You will probably use the 1099NEC for most of your vendors that are to receive a 1099. The 1099 Misc. will be for all others types of pay, mostly for rent and attorney’s. If you have any mapping already set, it will show you the accounts being mapped. If you need to add more accounts to the mapping, just click on the drop down and choose the additional accounts you want.
7. When done hit next. This takes you back to the list of vendors already set to receive a 1099, you can review them and add any additional vendors or correct information. If information is missing it will show in red.
8. Hit next and you can see what 1099s have been prepared. If not correct and you need to make changes or add vendors, hit the back button and make the corrections.
9. When done you can click Finish Preparing 1099s and print.

QuickBooks Online offers you the ability to prepare and e-file 1099s with the Intuit 1099 E-File Service.

QuickBooks will also mail a printed copy to your contractors at no additional cost, or you can invite your contractors to sign into a secure online portal to access their 1099s rather than having to wait for their printed copies in the mail.

Ask your accountant how to prepare your 1099s through QuickBooks!