QuickBooks HelpQuickBooksHelpIntuit

Use Workpapers to map and export your clients’ tax info

SOLVEDby QuickBooks21Updated December 01, 2023

Learn how to use Workpapers to review, adjust, map, and export your client’s QuickBooks Online accounts to get ready for tax season.

Workpapers is a tool in QuickBooks Online Accountant lets you review a client’s accounts from a single dashboard. It's very similar to a trial balance. You can use it for any clients who use QuickBooks Online. After you review your client's accounts, Workpapers automatically export accounts to the proper lines on tax forms.

In this article, you'll learn how to:

Step 1: Open Workpapers

Each client has their own dedicated Workpapers page. There are two ways to get to Workpapers:

  • If you're in QuickBooks Online Accountant, go to the Clients tab. Find your client and select Workpapers from arrow drop-down in the Actions column. You can also access Workpapers under the Books To Tax section of the left navigation menu in your client's file.
  • If you’re working in a specific client’s QuickBooks Online account, select Workpapers from the Accountant Toolkit.

Step 2: Review your client’s accounts

Start your work in the Review & adjust tab. Your client’s annual Balance Sheet and Profit and Loss Reports are side-by-side so you can make quick comparisons. You’ll also see last year’s totals, account differences, and any adjusting entries you’ve made.

To dive into a specific account:

  1. Expand the list of accounts.
  2. Select the account total from the column for the current year.
  3. Review the transactions in the account.

Step 3: Make adjusting journal entries

Workpapers makes it easy to record and adjust journal entries if needed. This lets you adjust transaction totals without changing the original record. To make an adjusting journal entry while you're on the Review & adjust tab:

  1. Expand the list of accounts.
  2. Find the account you want to adjust.
  3. From the Actions column, select Make adjustment.

 You can attach notes and documents to keep track of work on individual accounts as needed:

  1. From the Actions column, select the small arrow ▼ icon.
  2. Select Add attachment or Add note.

 Icons appear next to each account for easy reference.

 Change the accounting method view

You can toggle between accounting method views to make your review easier. This won’t affect your client’s settings or view in QuickBooks Online.

  1. Select the pencil icon at the top.
  2. Toggle between Cash basis and Accrual basis.

Review the Change List

The Change List in the Review & adjust tab acts as an audit log. Every time someone makes a change in Workpapers, it appears on this list.

To approve these changes so QuickBooks applies them, select Accept changes.

Step 4: Map accounts to tax forms

After reviewing your client’s accounts, you’ll assign them to specific lines on tax forms.

  1. Go to the Tax Mapping tab.
  2. Select Edit ✎ next to the form name.
  3. Select the appropriate tax form for your client.
Important: Edits don’t carry over to different forms. If you change forms in the middle of mapping accounts, you’ll need to make edits again on the new form.

Workpapers automatically assigns most accounts to tax lines. Any unassigned accounts appear in the “We found unmapped accounts” section. Simply select Assign tax line and move them to the correct tax line.

Review each tax line. If you need to reassign an account to a different tax line:

  1. Find the account on the tax form.
  2. Select Edit ✎ to edit.
  3. Choose the correct tax line.

Step 5: Export the mapped tax forms

When you're ready to export, download a CSV for other tax preparation software.

  1. Go to Tax options at the top right, then select Export CSV button. Tip: Export CSV is available when you change the form name to T2125.

Was this helpful?

You must sign in to vote, reply, or post

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this