Books review: Wrap-up in Quickbooks Online.

Keywords: Management, Expenses,Purchase, Quickbooks

Credit: Intuit- Quickbooks Online  Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Once the final review is complete, it’s time for Wrap-up. The main focus of this stage is to prepare and send reports. Depending on you and your firm, these could include financial statements, operational reports, or both.

These are steps to follow when you want to Wrap-up your reports.

Step 1 : The step of Wrap-up is to prepare your reports. Selecting Select under prepare reports will open a dropdown containing a list of all the management reports available. Select the one you need, then continue

Step 2 : You can then edit the report, including writing an introduction. This can be a great place to highlight any actions you think you could take and to begin advisory conversations based on your review. When you are done, make sure to save your changes.

Step 3 : Complete this process for any of the reports packages that are needed. The dropdown list will display all the reports packages in the management reports tab in the reports center.

Step 4 : When the reports have been finalized, it’s time to share them with you. Selecting Send in Wrap-up, opens a new tab containing the Management reports tab of the Reports center. Use the down arrow menu next to a report to send it to you.

Step 5 : You can then add the email addresses of the people you are sharing the report with. This might be different for each of the different reports you have prepared. It can be a good idea to CC yourself too, so you have a record of the email sent.

Step 6 : Here you can decide whether the report should be sent as PDF or a Microsoft Word Document, and you can edit the default text to personalize your message.

Step 7 : At this point you may want to discuss the content of the reports with your client, so your message could include a link for your client to schedule a meeting with you.

Step 8 : Once management reports have been shared, the next step presented in the Wrap-up tab is to Close the Books. To do this, select Close now

Step 9 : Selecting Close Now in the Wrap-up tab opens a new browser tab displaying the Close the books section of Account and Settings. This feature can only be used by account users, and you who are the primary admin or company admin.

Here you can set the closing date, decide what should happen if changes are made to transactions before this date, and add a password to protect closed transactions.

Step 10 : Closing the books locks all transactions, including non posting transactions, such as estimates and purchase orders. It is a good idea to close the books throughout the year as part of your period-end process, but even if you don’t, it should definitely be done at year end. The benefit of closing the books is that any changes to transactions made before the closing date will show up on the Exceptions to closing report.

Step 11 : If any additional items have been added to Wrap-up for you, these should be carried out. Depending on your firm’s workflows, these could include saving copies of the workpapers and your overview. Then that’s the Books review completed for you.

Exceptions to Closing Date

Users with the correct permissions can edit or delete a transaction after the closing date—and after the books have been closed.

If a password has been set, it will need to be entered before the change is made.

All changes—regardless of whether the books are closed with a password or not—will be listed in the Exceptions to Closing Date report available in the Reports center. This report is only available when the books have been closed, and displays details of what has been changed, when, and by whom. You may see the name of the individual at your firm, or your company, that made the change, but you will only ever see your firm’s name if they run this report.

To see more detail about the changes, select View.

Changing or removing the closing date erases the existing Exceptions to Closing Date report and starts it again from scratch. You’ll only be able to track changes that occur after a new closing date is added.

It’s good practice to save a copy of the Exceptions to Closing Date report before changing the closing date, so you have a record of any changes that have been made.

Lets take a look at some other period end tasks below;

Getting ready for 1099 preparation

The Books review center steps you through the core tasks that are a good idea to do at period end, but there are other things that might be right for you, that sit outside this workflow.

You usually need to submit a 1099 to the IRS at year end when they pay more than $600 for services from someone who is not an employee. To prepare the 1099, you need to collect information about the individual via a completed W-9.

Collecting this information throughout the year will make 1099 preparation so much smoother. It can also be a really good idea to request their completed W-9 before work is started. Not doing this could prove troublesome after beginning the work-you may find yourself unable to get a W-9 from a vendor that’s already been paid, and you could be required to pay withholding taxes on the money you pay them.

Whose W-9 do you need?

You need to collect a W-9 for anyone that may need a 1099 at the end of the year. As you might not know at the beginning of an engagement if you will pay someone more than $600, it is good practice to collect a W-9 from all people or companies from whom they purchase services in case they do.

The Vendors list in the Expenses center shows which of your vendors are set up for 1099 tracking. These vendors will also appear on the Contractors list.

Marking a vendor as a 1099 contractor

If you see a vendor on the list that should be tracked for 1099, open up their details, select Edit, then check Track payments for 1099.

Identifying missing W-9s

Any vendors that have had Track payments for 1099 checked, or any contractors set up through the Contractors tab, will appear on the Contractors tab of the Expenses center.

If no W-9 information is held for the contractor, you’ll see a W-9 missing flag by their name, making it easier to identify who needs to be contacted for a W-9.

W-9 ready is shown by contractors for whom a tax ID has been entered. You can also check if a paper or PDF copy of the W-9 has been received by selecting the contractor’s name and viewing the Documents tab.

Requesting a W-9

Selecting a contractor’s name in the Contractors list opens up their details. From here you can send an email requesting them to provide a W-9. If a contractor is set up through the Contractors tab of the Expenses center, this invitation can be sent as part of the workflow.

Either way, the contractor can then set up—or sign into—an Intuit account where they can input their information and digitally sign a W-9. This information, including a PDF of the signed W-9, will then appear in your client’s QuickBooks Online account.

Once this information is in place, you’ll be all set for 1099 preparation in tax season.

Bulk W-9 Management

You can also manage who to send 1099s to using the W-9 management tool available in the 1099 filings tab, accessed from the Expenses and Taxes centers.

Here, you can:

  • view a list of recipients who seem to meet the criteria for receiving a 1099 form
  • see which vendors have missing info
  • send a bulk invite to get the info you need to complete their 1099.

You can select Review to see why QuickBooks recommend that contractor. If you agree, select Track for 1099. Select Remove from list to not provide a 1099.

Saving the Client Overview

Another period-end task that you might want to do is download the Client overview (after you have completed the Books review!). It will show a summary of all bank and credit card accounts and their reconciliation status, as well as non-bank accounts that have been selected to list there as well. It also summarizes any common issues, and the volume transaction over a set period.

Reviewing this overview, and how it changes over time, could prompt advisory conversations around the changing volume of transactions, or the number of bank accounts you have.

Check out our Free Additional Articles